916: WHERE batch.batch_id = xset_id
917: AND batch.batch_id = opt.batch_id;
918: EXCEPTION
919: WHEN OTHERS THEN
920: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;
921: l_import_xref_only := 'N';
922: END;
923:
924: IF NOT(l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y') THEN
920: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;
921: l_import_xref_only := 'N';
922: END;
923:
924: IF NOT(l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y') THEN
925:
926: --Calling Demerge_Batch_After_Import
927: IF l_inv_debug_level IN(101, 102) THEN
928: INVPUTLI.info('Calling EGO_IMPORT_PVT.Demerge_Batch_After_Import');
924: IF NOT(l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y') THEN
925:
926: --Calling Demerge_Batch_After_Import
927: IF l_inv_debug_level IN(101, 102) THEN
928: INVPUTLI.info('Calling EGO_IMPORT_PVT.Demerge_Batch_After_Import');
929: END IF;
930: EGO_IMPORT_PVT.Demerge_Batch_After_Import(
931: ERRBUF => err_text
932: ,RETCODE => ret_code
926: --Calling Demerge_Batch_After_Import
927: IF l_inv_debug_level IN(101, 102) THEN
928: INVPUTLI.info('Calling EGO_IMPORT_PVT.Demerge_Batch_After_Import');
929: END IF;
930: EGO_IMPORT_PVT.Demerge_Batch_After_Import(
931: ERRBUF => err_text
932: ,RETCODE => ret_code
933: ,p_batch_id => xset_id);
934: IF l_inv_debug_level IN(101, 102) THEN
931: ERRBUF => err_text
932: ,RETCODE => ret_code
933: ,p_batch_id => xset_id);
934: IF l_inv_debug_level IN(101, 102) THEN
935: INVPUTLI.info('Returned EGO_IMPORT_PVT.Demerge_Batch_After_Import '||ret_code);
936: INVPUTLI.info(err_text);
937: END IF;
938:
939: --Calling source system xref bulkloader
937: END IF;
938:
939: --Calling source system xref bulkloader
940: IF l_inv_debug_level IN(101, 102) THEN
941: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_SSXref_Intf_Rows');
942: END IF;
943:
944: EGO_IMPORT_PVT.Process_SSXref_Intf_Rows(
945: ERRBUF => err_text
940: IF l_inv_debug_level IN(101, 102) THEN
941: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_SSXref_Intf_Rows');
942: END IF;
943:
944: EGO_IMPORT_PVT.Process_SSXref_Intf_Rows(
945: ERRBUF => err_text
946: ,RETCODE => ret_code
947: ,p_data_set_id => xset_id);
948:
946: ,RETCODE => ret_code
947: ,p_data_set_id => xset_id);
948:
949: IF l_inv_debug_level IN(101, 102) THEN
950: INVPUTLI.info('Returned EGO_IMPORT_PVT.Process_SSXref_Intf_Rows '||ret_code);
951: INVPUTLI.info(err_text);
952: END IF;
953:
954: END IF;