Internal Error (245) occured [message 131-183]

Hi All,

Can anyone explain as to why, when the following is added to the sp_transactionnotification and you attempt to update a BP you get the error as per this message subject?

if @object_type = '2' and @transaction_type in ('A','U')

begin

if (select t0.u_primarysrc from ocrd t0 where t0.DOCENTRY = @list_of_cols_val_tab_del) IS NULL

begin

set @error = -1

set @error_message = 'A primary Media Code must be selected'

end

end

Regards

Earl