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 46: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;

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

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

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

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

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

Line 55: EGO_IMPORT_PVT.Process_SSXref_Intf_Rows(

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

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

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

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

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

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

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

Line 263: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;

259: WHERE batch.batch_id = p_xset_id
260: AND batch.batch_id = opt.batch_id;
261: EXCEPTION
262: WHEN OTHERS THEN
263: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;
264: l_import_xref_only := 'N';
265: l_enabled_for_data_pool := 'N';
266: END;
267:

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

264: l_import_xref_only := 'N';
265: l_enabled_for_data_pool := 'N';
266: END;
267:
268: IF NOT( l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' ) THEN
269: --Calling Item Intersections Import
270: IF l_inv_debug_level IN(101, 102) THEN
271: INVPUTLI.info('Calling EGO_ITEM_ASSOCIATIONS_PUB.Import_Item_Associations');
272: END IF;

Line 569: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;

565: WHERE batch.batch_id = p_batch_id
566: AND batch.batch_id = opt.batch_id;
567: EXCEPTION
568: WHEN OTHERS THEN
569: l_source_system_id := EGO_IMPORT_PVT.get_pdh_source_system_id;
570: l_import_xref_only := 'N';
571: l_enabled_for_data_pool := 'N';
572: END;
573:

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

570: l_import_xref_only := 'N';
571: l_enabled_for_data_pool := 'N';
572: END;
573:
574: IF NOT( l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' ) THEN
575: --Calling GTIN bulkloader
576: IF l_inv_debug_level IN(101, 102) THEN
577: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_Gtin_Intf_Rows');
578: END IF;

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

573:
574: IF NOT( l_source_system_id <> EGO_IMPORT_PVT.get_pdh_source_system_id AND l_import_xref_only = 'Y' ) THEN
575: --Calling GTIN bulkloader
576: IF l_inv_debug_level IN(101, 102) THEN
577: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_Gtin_Intf_Rows');
578: END IF;
579:
580: EGO_IMPORT_PVT.Process_Gtin_Intf_Rows(
581: ERRBUF => ERRBUF

Line 580: EGO_IMPORT_PVT.Process_Gtin_Intf_Rows(

576: IF l_inv_debug_level IN(101, 102) THEN
577: INVPUTLI.info('Calling EGO_IMPORT_PVT.Process_Gtin_Intf_Rows');
578: END IF;
579:
580: EGO_IMPORT_PVT.Process_Gtin_Intf_Rows(
581: ERRBUF => ERRBUF
582: ,RETCODE => RETCODE
583: ,p_data_set_id => p_batch_id);
584:

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

582: ,RETCODE => RETCODE
583: ,p_data_set_id => p_batch_id);
584:
585: IF l_inv_debug_level IN(101, 102) THEN
586: INVPUTLI.info('Returned EGO_IMPORT_PVT.Process_Gtin_Intf_Rows '||RETCODE);
587: INVPUTLI.info(ERRBUF);
588: END IF;
589:
590: IF RETCODE > l_retcode THEN