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')
if (select t0.u_primarysrc from ocrd t0 where t0.DOCENTRY = @list_of_cols_val_tab_del) IS NULL
set @error = -1
set @error_message = 'A primary Media Code must be selected'