Hii
Try this
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[SBO_SP_TransactionNotification]
@object_type nvarchar(20), -- SBO Object Type
@transaction_type nchar(1), -- [A]dd, [U]pdate, [D]elete, [C]ancel, C[L]ose
@num_of_cols_in_key int,
@list_of_key_cols_tab_del nvarchar(255),
@list_of_cols_val_tab_del nvarchar(255)
AS
begin
-- Return values
declare @error int -- Result (0 for no error)
declare @error_message nvarchar (200) -- Error string to be displayed
select @error = 0
select @error_message = N'Ok'
--------------------------------------------------------------------------------------------------------------------------------
-- ADD YOUR CODE HERE
If @object_type = '22' and @transaction_type = 'A'
begin
If ( Select T1.ItemCode
from OPOR T0 Inner join POR1 T1 on T0.DocEntry = T1.DocEntry
Inner join OITM T2 ON T1.ItemCode = T2.ItemCode
where T2.FirmCode = @list_of_cols_val_tab_del) is null
Begin
select @error = -5001
select @error_message = N' Please add another vendor'
End
End
--------------------------------------------------------------------------------------------------------------------------------
-- Select the return values
select @error, @error_message
end
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.