44:
45:
46: if (error_column is not null) then
47:
48: Insert Into Xtr_Interface_Errors(CREATED_BY ,
49: CREATION_DATE ,
50: LAST_UPDATED_BY ,
51: LAST_UPDATE_DATE ,
52: LAST_UPDATE_LOGIN ,
684: p_is_success:=false;
685: ----------------------------------------------------------------------------------
686: --* To purge all the related data in the error table before processing the record
687: ----------------------------------------------------------------------------------
688: delete from xtr_interface_errors
689: where external_deal_id = LRec_External_Deal.external_deal_id
690: and deal_type = LRec_External_Deal.deal_type;
691:
692: