IF @transaction_type = 'A' AND @object_type = '176'
BEGIN
If Exists (SELECT Distinct 'ERROR' FROM OINS O1 where o1.internalSN in
(select o2.internalSN from OINS o2 where o2.insID <> @list_of_cols_val_tab_del and o2.internalSN = o1.internalSN ) and o1.insID = @list_of_cols_val_tab_del
)
Begin
SET @error = 1761
SET @error_message = N'Duplication of serial Number!!!'
End
END
