Stored Procedure for Blocking Wrong Vendor Code/Customer Code Creation in BP Master Data

------------------------------------Wrong Vendor Code Creation in BP Master Data------------------------------------------------


If @object_type = '2' and @transaction_type in ( 'A','U')



BEGIN

If exists (select CardType , CardName, CardCode from OCRD

where CardType in ('S') and CardCode like 'C%'

and CardCode = @list_of_cols_val_tab_del



)

Select @error = 420002-1,

@error_message = 'Wrong Vendor Code Created.Pl Create appropriate Vendor Code for Vendor'



End

------------------------------------Wrong Customer Code Creation in BP Master Data------------------------------------------------


If @object_type = '2' and @transaction_type in ( 'A','U')



BEGIN

If exists (select CardType , CardName, CardCode from OCRD

where CardType in ('C') and CardCode like 'V%'

and CardCode = @list_of_cols_val_tab_del



)

Select @error = 420002-2,

@error_message = 'Wrong Customer Code Created.Pl Create appropriate Customer Code for Customer. '



End