I alter the procedure like
IF @transaction_type IN (N'A', N'U') AND (@Object_type IN ('22'))
if exists (select count(*) from opor where cardcode=(select o.cardcode from opor o where o.docentry =@list_of_cols_val_tab_del ))
SET @error = 10
SET @error_message = N'cardcode is repeated'
If the vendor already do an purchase order then the vendor don't allow to make purchase order.So I add the above code in the SBO_SP_TransactionNotification procedure.
But the purchase order does not allow me to save for the vendor who doesn't make the purchase order or who already make purchase order.It give the error what i give in the procedure.
can anyone help me.It is urgent.
Edited by: Ramya sukumar on Jul 11, 2008 12:44 PM