eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on EGO_IMPORT_PVT

Line 48: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;

44: WHERE batch.batch_id = p_xset_id
45: AND batch.batch_id = opt.batch_id;
46: EXCEPTION
47: WHEN OTHERS THEN
48: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;
49: l_import_xref_only := 'N';
50: l_enabled_for_data_pool := 'N';
51: END;
52:

Line 53: IF l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' THEN

49: l_import_xref_only := 'N';
50: l_enabled_for_data_pool := 'N';
51: END;
52:
53: IF l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' THEN
54: IF l_inv_debug_level IN(101, 102) THEN
55: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_SSXref_Intf_Rows');
56: END IF;
57: EGO_IMPORT_PVT.Process_SSXref_Intf_Rows(

Line 55: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_SSXref_Intf_Rows');

51: END;
52:
53: IF l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' THEN
54: IF l_inv_debug_level IN(101, 102) THEN
55: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_SSXref_Intf_Rows');
56: END IF;
57: EGO_IMPORT_PVT.Process_SSXref_Intf_Rows(
58: ERRBUF => ERRBUF
59: ,RETCODE => l_retcode

Line 57: EGO_IMPORT_PVT.Process_SSXref_Intf_Rows(

53: IF l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' THEN
54: IF l_inv_debug_level IN(101, 102) THEN
55: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_SSXref_Intf_Rows');
56: END IF;
57: EGO_IMPORT_PVT.Process_SSXref_Intf_Rows(
58: ERRBUF => ERRBUF
59: ,RETCODE => l_retcode
60: ,p_data_set_id => p_xset_id);
61:

Line 63: INVPUTLI.info('Returned EGO_IMPORT_PVT.Process_SSXref_Intf_Rows '||l_retcode);

59: ,RETCODE => l_retcode
60: ,p_data_set_id => p_xset_id);
61:
62: IF l_inv_debug_level IN(101, 102) THEN
63: INVPUTLI.info('Returned EGO_IMPORT_PVT.Process_SSXref_Intf_Rows '||l_retcode);
64: INVPUTLI.info(ERRBUF);
65: END IF;
66: -- Bug: 5565750
67: IF ( p_commit_flag = 1 AND NVL(l_retcode, 0) IN (0, 1) ) THEN

Line 69: INVPUTLI.info('EGO_IMPORT_PVT.Process_SSXref_Intf_Rows => COMMITING');

65: END IF;
66: -- Bug: 5565750
67: IF ( p_commit_flag = 1 AND NVL(l_retcode, 0) IN (0, 1) ) THEN
68: IF l_inv_debug_level IN(101, 102) THEN
69: INVPUTLI.info('EGO_IMPORT_PVT.Process_SSXref_Intf_Rows => COMMITING');
70: INVPUTLI.info(ERRBUF);
71: END IF;
72: COMMIT;
73: END IF;

Line 75: ELSE --l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' THEN

71: END IF;
72: COMMIT;
73: END IF;
74: RETCODE := l_retcode;
75: ELSE --l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' THEN
76: --Adding this If condition as
77: --Java concurrent program calls EGOPOPIB as PL/SQL
78: --routine and not a concurrent request and passes
79: --request id as parameter

Line 316: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;

312: WHERE batch.batch_id = p_xset_id
313: AND batch.batch_id = opt.batch_id;
314: EXCEPTION
315: WHEN OTHERS THEN
316: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;
317: l_import_xref_only := 'N';
318: l_enabled_for_data_pool := 'N';
319: END;
320:

Line 321: IF NOT( l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' ) THEN

317: l_import_xref_only := 'N';
318: l_enabled_for_data_pool := 'N';
319: END;
320:
321: IF NOT( l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' ) THEN
322: --Calling Item Intersections Import
323: IF l_inv_debug_level IN(101, 102) THEN
324: INVPUTLI.info('Calling EGO_ITEM_ASSOCIATIONS_PUB.Import_Item_Associations');
325: END IF;

Line 629: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;

625: WHERE batch.batch_id = p_batch_id
626: AND batch.batch_id = opt.batch_id;
627: EXCEPTION
628: WHEN OTHERS THEN
629: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;
630: l_import_xref_only := 'N';
631: l_enabled_for_data_pool := 'N';
632: END;
633:

Line 634: IF NOT( l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' ) THEN

630: l_import_xref_only := 'N';
631: l_enabled_for_data_pool := 'N';
632: END;
633:
634: IF NOT( l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' ) THEN
635: --Calling GTIN bulkloader
636: IF l_inv_debug_level IN(101, 102) THEN
637: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_Gtin_Intf_Rows');
638: END IF;

Line 637: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_Gtin_Intf_Rows');

633:
634: IF NOT( l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' ) THEN
635: --Calling GTIN bulkloader
636: IF l_inv_debug_level IN(101, 102) THEN
637: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_Gtin_Intf_Rows');
638: END IF;
639:
640: EGO_IMPORT_PVT.Process_Gtin_Intf_Rows(
641: ERRBUF => ERRBUF

Line 640: EGO_IMPORT_PVT.Process_Gtin_Intf_Rows(

636: IF l_inv_debug_level IN(101, 102) THEN
637: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_Gtin_Intf_Rows');
638: END IF;
639:
640: EGO_IMPORT_PVT.Process_Gtin_Intf_Rows(
641: ERRBUF => ERRBUF
642: ,RETCODE => RETCODE
643: ,p_data_set_id => p_batch_id);
644:

Line 646: INVPUTLI.info('Returned EGO_IMPORT_PVT.Process_Gtin_Intf_Rows '||RETCODE);

642: ,RETCODE => RETCODE
643: ,p_data_set_id => p_batch_id);
644:
645: IF l_inv_debug_level IN(101, 102) THEN
646: INVPUTLI.info('Returned EGO_IMPORT_PVT.Process_Gtin_Intf_Rows '||RETCODE);
647: INVPUTLI.info(ERRBUF);
648: END IF;
649:
650: IF RETCODE > l_retcode THEN