after if else set the error and error message.check the tn is work.if @object_type = '17' AND @transaction_type IN ('A','U')beginif (select ORDR.Comments from ORDR where ORDR.DocEntry=@list_of_cols_val_tab_del) IS NULLBeginset @error = -2set @error_m...