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 INVPUTLI

Line 29: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

25:
26: l_retcode VARCHAR2(100);
27: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
28: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
29: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
30: l_request_id NUMBER;
31: l_pro_flag_3 NUMBER;
32: l_enabled_for_data_pool VARCHAR2(1);
33: BEGIN

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 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 62: INVPUTLI.info(ERRBUF);

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
66: IF l_inv_debug_level IN(101, 102) 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 68: INVPUTLI.info(ERRBUF);

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;
72: RETCODE := l_retcode;

Line 88: INVPUTLI.info('Calling INVPOPIF.inopinp_open_interface_process in validation mode - run mode -> '||p_run_mode);

84: -- IF batch is enabled for data pool, then calling IOI in validation mode
85: -- and then calling Validate_Timestamp_In_Batch i.e. phase-2 validation
86: IF l_enabled_for_data_pool = 'Y' AND NVL(p_pro_item_flag, 0) = 1 THEN
87: IF l_inv_debug_level IN(101, 102) THEN
88: INVPUTLI.info('Calling INVPOPIF.inopinp_open_interface_process in validation mode - run mode -> '||p_run_mode);
89: END IF;
90: l_retcode := INVPOPIF.inopinp_open_interface_process(
91: org_id => p_org_id
92: ,all_org => p_all_org

Line 107: INVPUTLI.info(' RETCODE for INVPOPIF.inopinp_open_interface_process in validation mode - run mode -> '||p_run_mode ||':'||l_retcode);

103: ,run_mode => p_run_mode
104: ,err_text => ERRBUF);
105:
106: IF l_inv_debug_level IN(101, 102) THEN
107: INVPUTLI.info(' RETCODE for INVPOPIF.inopinp_open_interface_process in validation mode - run mode -> '||p_run_mode ||':'||l_retcode);
108: INVPUTLI.info(ERRBUF);
109: END IF;
110:
111: IF l_retcode NOT IN (0, 1) THEN

Line 108: INVPUTLI.info(ERRBUF);

104: ,err_text => ERRBUF);
105:
106: IF l_inv_debug_level IN(101, 102) THEN
107: INVPUTLI.info(' RETCODE for INVPOPIF.inopinp_open_interface_process in validation mode - run mode -> '||p_run_mode ||':'||l_retcode);
108: INVPUTLI.info(ERRBUF);
109: END IF;
110:
111: IF l_retcode NOT IN (0, 1) THEN
112: RETCODE := G_ERROR;

Line 116: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Validate_Timestamp_In_Batch');

112: RETCODE := G_ERROR;
113: END IF;
114:
115: IF l_inv_debug_level IN(101, 102) THEN
116: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Validate_Timestamp_In_Batch');
117: END IF;
118:
119: EGO_IMPORT_UTIL_PVT.Validate_Timestamp_In_Batch(
120: RETCODE => l_retcode

Line 125: INVPUTLI.info(' RETCODE for EGO_IMPORT_UTIL_PVT.Validate_Timestamp_In_Batch - '||l_retcode);

121: ,ERRBUF => ERRBUF
122: ,p_batch_id => p_xset_id);
123:
124: IF l_inv_debug_level IN(101, 102) THEN
125: INVPUTLI.info(' RETCODE for EGO_IMPORT_UTIL_PVT.Validate_Timestamp_In_Batch - '||l_retcode);
126: INVPUTLI.info(ERRBUF);
127: END IF;
128:
129: IF l_retcode NOT IN (0, 1) THEN

Line 126: INVPUTLI.info(ERRBUF);

122: ,p_batch_id => p_xset_id);
123:
124: IF l_inv_debug_level IN(101, 102) THEN
125: INVPUTLI.info(' RETCODE for EGO_IMPORT_UTIL_PVT.Validate_Timestamp_In_Batch - '||l_retcode);
126: INVPUTLI.info(ERRBUF);
127: END IF;
128:
129: IF l_retcode NOT IN (0, 1) THEN
130: RETCODE := G_ERROR;

Line 137: INVPUTLI.info('Calling INVPOPIF.inopinp_open_interface_process - run mode -> '||p_run_mode);

133:
134: -- Call INV Item open interface.
135: -- Note: Categories prg is called from INV IOI
136: IF l_inv_debug_level IN(101, 102) THEN
137: INVPUTLI.info('Calling INVPOPIF.inopinp_open_interface_process - run mode -> '||p_run_mode);
138: END IF;
139: l_retcode := INVPOPIF.inopinp_open_interface_process(
140: org_id => p_org_id
141: ,all_org => p_all_org

Line 157: INVPUTLI.info(' RETCODE for INVPOPIF.inopinp_open_interface_process - run mode -> '||p_run_mode ||':'||l_retcode);

153: ,run_mode => p_run_mode
154: ,err_text => ERRBUF);
155:
156: IF l_inv_debug_level IN(101, 102) THEN
157: INVPUTLI.info(' RETCODE for INVPOPIF.inopinp_open_interface_process - run mode -> '||p_run_mode ||':'||l_retcode);
158: INVPUTLI.info(ERRBUF);
159: END IF;
160:
161: IF l_retcode NOT IN (0, 1) THEN

Line 158: INVPUTLI.info(ERRBUF);

154: ,err_text => ERRBUF);
155:
156: IF l_inv_debug_level IN(101, 102) THEN
157: INVPUTLI.info(' RETCODE for INVPOPIF.inopinp_open_interface_process - run mode -> '||p_run_mode ||':'||l_retcode);
158: INVPUTLI.info(ERRBUF);
159: END IF;
160:
161: IF l_retcode NOT IN (0, 1) THEN
162: /* Bug 5257590 - Checking for run time exceptions so status can be set to ERROR */

Line 194: INVPUTLI.info('WHEN-OTHERS-EXCEPTION item_open_interface_process: ' ||SQLCODE);

190: EXCEPTION
191: WHEN OTHERS THEN
192: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
193: IF l_inv_debug_level IN(101, 102) THEN
194: INVPUTLI.info('WHEN-OTHERS-EXCEPTION item_open_interface_process: ' ||SQLCODE);
195: INVPUTLI.info(SQLERRM);
196: END IF;
197: ERRBUF := 'Unexpected error in item_open_interface_process: '||SQLERRM;
198: RETCODE := G_ERROR;

Line 195: INVPUTLI.info(SQLERRM);

191: WHEN OTHERS THEN
192: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
193: IF l_inv_debug_level IN(101, 102) THEN
194: INVPUTLI.info('WHEN-OTHERS-EXCEPTION item_open_interface_process: ' ||SQLCODE);
195: INVPUTLI.info(SQLERRM);
196: END IF;
197: ERRBUF := 'Unexpected error in item_open_interface_process: '||SQLERRM;
198: RETCODE := G_ERROR;
199: END item_open_interface_process;

Line 249: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

245: l_temp_message VARCHAR2(2000);
246: l_retcode VARCHAR2(100);
247: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
248: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
249: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
250: err_msg VARCHAR2(300); --Bug: 5473796
251: l_batch_id NUMBER := p_xset_id;
252: l_enabled_for_data_pool VARCHAR2(1);
253: BEGIN

Line 271: INVPUTLI.info('Calling EGO_ITEM_ASSOCIATIONS_PUB.Import_Item_Associations');

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;
273:
274: EGO_ITEM_ASSOCIATIONS_PUB.Import_Item_Associations
275: ( p_api_version => 1.0,

Line 282: INVPUTLI.info('Returned EGO_ITEM_ASSOCIATIONS_PUB.Import_Item_Associations - '||RETCODE);

278: x_retcode => RETCODE
279: );
280:
281: IF l_inv_debug_level IN(101, 102) THEN
282: INVPUTLI.info('Returned EGO_ITEM_ASSOCIATIONS_PUB.Import_Item_Associations - '||RETCODE);
283: INVPUTLI.info(ERRBUF);
284: END IF;
285:
286: l_retcode := RETCODE;

Line 283: INVPUTLI.info(ERRBUF);

279: );
280:
281: IF l_inv_debug_level IN(101, 102) THEN
282: INVPUTLI.info('Returned EGO_ITEM_ASSOCIATIONS_PUB.Import_Item_Associations - '||RETCODE);
283: INVPUTLI.info(ERRBUF);
284: END IF;
285:
286: l_retcode := RETCODE;
287:

Line 290: INVPUTLI.info('Calling EGO_ITEM_PEOPLE_IMPORT_PKG.LOAD_INTERFACE_LINES');

286: l_retcode := RETCODE;
287:
288: --Calling Item People prg
289: IF l_inv_debug_level IN(101, 102) THEN
290: INVPUTLI.info('Calling EGO_ITEM_PEOPLE_IMPORT_PKG.LOAD_INTERFACE_LINES');
291: END IF;
292:
293: EGO_ITEM_PEOPLE_IMPORT_PKG.LOAD_INTERFACE_LINES(
294: X_ERRBUFF => ERRBUF

Line 300: INVPUTLI.info('Returned EGO_ITEM_PEOPLE_IMPORT_PKG.LOAD_INTERFACE_LINES '||RETCODE);

296: ,p_data_set_id => p_xset_id
297: ,p_delete_lines => p_del_rec_flag);
298:
299: IF l_inv_debug_level IN(101, 102) THEN
300: INVPUTLI.info('Returned EGO_ITEM_PEOPLE_IMPORT_PKG.LOAD_INTERFACE_LINES '||RETCODE);
301: INVPUTLI.info(ERRBUF);
302: END IF;
303:
304: l_retcode := RETCODE;

Line 301: INVPUTLI.info(ERRBUF);

297: ,p_delete_lines => p_del_rec_flag);
298:
299: IF l_inv_debug_level IN(101, 102) THEN
300: INVPUTLI.info('Returned EGO_ITEM_PEOPLE_IMPORT_PKG.LOAD_INTERFACE_LINES '||RETCODE);
301: INVPUTLI.info(ERRBUF);
302: END IF;
303:
304: l_retcode := RETCODE;
305:

Line 308: INVPUTLI.info('Calling EGO_ITEM_AML_PVT.LOAD_INTERFACE_LINES');

304: l_retcode := RETCODE;
305:
306: --Calling AML prg
307: IF l_inv_debug_level IN(101, 102) THEN
308: INVPUTLI.info('Calling EGO_ITEM_AML_PVT.LOAD_INTERFACE_LINES');
309: END IF;
310:
311: EGO_ITEM_AML_PVT.LOAD_INTERFACE_LINES(
312: ERRBUF => ERRBUF

Line 320: INVPUTLI.info('Returned EGO_ITEM_AML_PVT.LOAD_INTERFACE_LINES '||RETCODE);

316: ,p_mode =>'NORMAL'
317: ,P_perform_security_check => FND_API.G_TRUE);
318:
319: IF l_inv_debug_level IN(101, 102) THEN
320: INVPUTLI.info('Returned EGO_ITEM_AML_PVT.LOAD_INTERFACE_LINES '||RETCODE);
321: INVPUTLI.info(ERRBUF);
322: END IF;
323: IF RETCODE > l_retcode THEN
324: l_retcode := RETCODE;

Line 321: INVPUTLI.info(ERRBUF);

317: ,P_perform_security_check => FND_API.G_TRUE);
318:
319: IF l_inv_debug_level IN(101, 102) THEN
320: INVPUTLI.info('Returned EGO_ITEM_AML_PVT.LOAD_INTERFACE_LINES '||RETCODE);
321: INVPUTLI.info(ERRBUF);
322: END IF;
323: IF RETCODE > l_retcode THEN
324: l_retcode := RETCODE;
325: END IF;

Line 332: INVPUTLI.info('Calling EGO_ITEM_USER_ATTRS_CP_PUB.PROCESS_ITEM_USER_ATTRS_DATA');

328: --code for this is shifted to EGOVIMUB.pls
329:
330: --Calling user attr+gtin prg
331: IF l_inv_debug_level IN(101, 102) THEN
332: INVPUTLI.info('Calling EGO_ITEM_USER_ATTRS_CP_PUB.PROCESS_ITEM_USER_ATTRS_DATA');
333: EGO_ITEM_USER_ATTRS_CP_PUB.PROCESS_ITEM_USER_ATTRS_DATA(
334: ERRBUF => ERRBUF
335: ,RETCODE => RETCODE
336: ,p_data_set_id => p_xset_id

Line 347: INVPUTLI.info('Returned EGO_ITEM_USER_ATTRS_CP_PUB.PROCESS_ITEM_USER_ATTRS_DATA '||RETCODE);

343:
344: END IF;
345:
346: IF l_inv_debug_level IN(101, 102) THEN
347: INVPUTLI.info('Returned EGO_ITEM_USER_ATTRS_CP_PUB.PROCESS_ITEM_USER_ATTRS_DATA '||RETCODE);
348: INVPUTLI.info(ERRBUF);
349: END IF;
350: IF RETCODE > l_retcode THEN
351: l_retcode := RETCODE;

Line 348: INVPUTLI.info(ERRBUF);

344: END IF;
345:
346: IF l_inv_debug_level IN(101, 102) THEN
347: INVPUTLI.info('Returned EGO_ITEM_USER_ATTRS_CP_PUB.PROCESS_ITEM_USER_ATTRS_DATA '||RETCODE);
348: INVPUTLI.info(ERRBUF);
349: END IF;
350: IF RETCODE > l_retcode THEN
351: l_retcode := RETCODE;
352: END IF;

Line 360: INVPUTLI.info('WHEN-OTHERS-EXCEPTION process_item_entities: ' ||SQLCODE);

356: RETCODE := l_retcode;
357: EXCEPTION
358: WHEN OTHERS THEN
359: IF l_inv_debug_level IN(101, 102) THEN
360: INVPUTLI.info('WHEN-OTHERS-EXCEPTION process_item_entities: ' ||SQLCODE);
361: INVPUTLI.info(SQLERRM);
362: END IF;
363: RETCODE := G_ERROR;
364: ERRBUF := 'Unexpected error in process_item_entities: '||SQLERRM;

Line 361: INVPUTLI.info(SQLERRM);

357: EXCEPTION
358: WHEN OTHERS THEN
359: IF l_inv_debug_level IN(101, 102) THEN
360: INVPUTLI.info('WHEN-OTHERS-EXCEPTION process_item_entities: ' ||SQLCODE);
361: INVPUTLI.info(SQLERRM);
362: END IF;
363: RETCODE := G_ERROR;
364: ERRBUF := 'Unexpected error in process_item_entities: '||SQLERRM;
365: END process_item_entities;

Line 551: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;

547: p_batch_id IN NUMBER,
548: p_del_rec_flag IN NUMBER := 1)
549: IS
550: l_retcode VARCHAR2(100);
551: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
552: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
553: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
554: l_enabled_for_data_pool VARCHAR2(1);
555: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

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 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

Line 587: INVPUTLI.info(ERRBUF);

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
591: l_retcode := RETCODE;

Line 597: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Update_Timestamp_In_Prod');

593:
594: --Calling updation of inbound message timestamp
595: IF l_enabled_for_data_pool = 'Y' THEN
596: IF l_inv_debug_level IN(101, 102) THEN
597: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Update_Timestamp_In_Prod');
598: END IF;
599:
600: EGO_IMPORT_UTIL_PVT.Update_Timestamp_In_Prod(
601: ERRBUF => ERRBUF

Line 606: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Update_Timestamp_In_Prod '||RETCODE);

602: ,RETCODE => RETCODE
603: ,p_batch_id => p_batch_id);
604:
605: IF l_inv_debug_level IN(101, 102) THEN
606: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Update_Timestamp_In_Prod '||RETCODE);
607: INVPUTLI.info(ERRBUF);
608: END IF;
609:
610: IF RETCODE > l_retcode THEN

Line 607: INVPUTLI.info(ERRBUF);

603: ,p_batch_id => p_batch_id);
604:
605: IF l_inv_debug_level IN(101, 102) THEN
606: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Update_Timestamp_In_Prod '||RETCODE);
607: INVPUTLI.info(ERRBUF);
608: END IF;
609:
610: IF RETCODE > l_retcode THEN
611: l_retcode := RETCODE;

Line 617: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Default_Item_People');

613: END IF; -- IF l_enabled_for_data_pool = 'Y' THEN
614:
615: --Calling Item People Defaulting
616: IF l_inv_debug_level IN(101, 102) THEN
617: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Default_Item_People');
618: END IF;
619:
620: EGO_IMPORT_UTIL_PVT.Default_Item_People(
621: RETCODE => RETCODE

Line 626: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Default_Item_People '||RETCODE);

622: ,ERRBUF => ERRBUF
623: ,p_batch_id => p_batch_id);
624:
625: IF l_inv_debug_level IN(101, 102) THEN
626: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Default_Item_People '||RETCODE);
627: INVPUTLI.info(ERRBUF);
628: END IF;
629: IF RETCODE > l_retcode THEN
630: l_retcode := RETCODE;

Line 627: INVPUTLI.info(ERRBUF);

623: ,p_batch_id => p_batch_id);
624:
625: IF l_inv_debug_level IN(101, 102) THEN
626: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Default_Item_People '||RETCODE);
627: INVPUTLI.info(ERRBUF);
628: END IF;
629: IF RETCODE > l_retcode THEN
630: l_retcode := RETCODE;
631: END IF;

Line 635: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Copy_LC_Projects');

631: END IF;
632:
633: --Calling Item LC Project Defaulting
634: IF l_inv_debug_level IN(101, 102) THEN
635: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Copy_LC_Projects');
636: END IF;
637:
638: EGO_IMPORT_UTIL_PVT.Copy_LC_Projects(
639: RETCODE => RETCODE

Line 644: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Copy_LC_Projects '||RETCODE);

640: ,ERRBUF => ERRBUF
641: ,p_batch_id => p_batch_id);
642:
643: IF l_inv_debug_level IN(101, 102) THEN
644: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Copy_LC_Projects '||RETCODE);
645: INVPUTLI.info(ERRBUF);
646: END IF;
647: IF RETCODE > l_retcode THEN
648: l_retcode := RETCODE;

Line 645: INVPUTLI.info(ERRBUF);

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

Line 653: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Copy_Attachments');

649: END IF;
650:
651: --Calling Item Attachments Copy
652: IF l_inv_debug_level IN(101, 102) THEN
653: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Copy_Attachments');
654: END IF;
655:
656: EGO_IMPORT_UTIL_PVT.Copy_Attachments(
657: RETCODE => RETCODE

Line 662: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Copy_Attachments '||RETCODE);

658: ,ERRBUF => ERRBUF
659: ,p_batch_id => p_batch_id);
660:
661: IF l_inv_debug_level IN(101, 102) THEN
662: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Copy_Attachments '||RETCODE);
663: INVPUTLI.info(ERRBUF);
664: END IF;
665: IF RETCODE > l_retcode THEN
666: l_retcode := RETCODE;

Line 663: INVPUTLI.info(ERRBUF);

659: ,p_batch_id => p_batch_id);
660:
661: IF l_inv_debug_level IN(101, 102) THEN
662: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Copy_Attachments '||RETCODE);
663: INVPUTLI.info(ERRBUF);
664: END IF;
665: IF RETCODE > l_retcode THEN
666: l_retcode := RETCODE;
667: END IF;

Line 671: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Clean_Dirty_SKUs');

667: END IF;
668:
669: --Cleaning up dirty SKU entries
670: IF l_inv_debug_level IN(101, 102) THEN
671: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Clean_Dirty_SKUs');
672: END IF;
673:
674: EGO_IMPORT_UTIL_PVT.Clean_Dirty_SKUs(
675: RETCODE => RETCODE

Line 680: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Clean_Dirty_SKUs '||RETCODE);

676: ,ERRBUF => ERRBUF
677: ,p_batch_id => p_batch_id);
678:
679: IF l_inv_debug_level IN(101, 102) THEN
680: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Clean_Dirty_SKUs '||RETCODE);
681: INVPUTLI.info(ERRBUF);
682: END IF;
683: IF RETCODE > l_retcode THEN
684: l_retcode := RETCODE;

Line 681: INVPUTLI.info(ERRBUF);

677: ,p_batch_id => p_batch_id);
678:
679: IF l_inv_debug_level IN(101, 102) THEN
680: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Clean_Dirty_SKUs '||RETCODE);
681: INVPUTLI.info(ERRBUF);
682: END IF;
683: IF RETCODE > l_retcode THEN
684: l_retcode := RETCODE;
685: END IF;

Line 689: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Copy_Item_People_From_Style');

685: END IF;
686:
687: --calling copy people from style to SKU for newly added people
688: IF l_inv_debug_level IN(101, 102) THEN
689: INVPUTLI.info('Calling EGO_IMPORT_UTIL_PVT.Copy_Item_People_From_Style');
690: END IF;
691:
692: EGO_IMPORT_UTIL_PVT.Copy_Item_People_From_Style(
693: RETCODE => RETCODE

Line 698: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Copy_Item_People_From_Style '||RETCODE);

694: ,ERRBUF => ERRBUF
695: ,p_batch_id => p_batch_id);
696:
697: IF l_inv_debug_level IN(101, 102) THEN
698: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Copy_Item_People_From_Style '||RETCODE);
699: INVPUTLI.info(ERRBUF);
700: END IF;
701: IF RETCODE > l_retcode THEN
702: l_retcode := RETCODE;

Line 699: INVPUTLI.info(ERRBUF);

695: ,p_batch_id => p_batch_id);
696:
697: IF l_inv_debug_level IN(101, 102) THEN
698: INVPUTLI.info('Returned EGO_IMPORT_UTIL_PVT.Copy_Item_People_From_Style '||RETCODE);
699: INVPUTLI.info(ERRBUF);
700: END IF;
701: IF RETCODE > l_retcode THEN
702: l_retcode := RETCODE;
703: END IF;

Line 709: INVPUTLI.info('Deleting interface records');

705:
706: --Bug: 5473976 Interface rows will be deleted here not in IOI
707: IF p_del_rec_flag = 1 THEN
708: IF l_inv_debug_level IN(101, 102) THEN
709: INVPUTLI.info('Deleting interface records');
710: END IF;
711: l_retcode := INVPOPIF.indelitm_delete_item_oi (err_text => err_msg,
712: xset_id => p_batch_id);
713:

Line 715: INVPUTLI.info('Returned INVPOPIF.indelitm_delete_item_oi '||err_msg);

711: l_retcode := INVPOPIF.indelitm_delete_item_oi (err_text => err_msg,
712: xset_id => p_batch_id);
713:
714: IF l_inv_debug_level IN(101, 102) THEN
715: INVPUTLI.info('Returned INVPOPIF.indelitm_delete_item_oi '||err_msg);
716: END IF;
717: IF RETCODE > l_retcode THEN
718: l_retcode := RETCODE;
719: END IF;

Line 758: INVPUTLI.info('WHEN-OTHERS-EXCEPTION Post_Import_Defaulting: ' ||SQLCODE);

754: END IF;
755: EXCEPTION
756: WHEN OTHERS THEN
757: IF l_inv_debug_level IN(101, 102) THEN
758: INVPUTLI.info('WHEN-OTHERS-EXCEPTION Post_Import_Defaulting: ' ||SQLCODE);
759: INVPUTLI.info(SQLERRM);
760: END IF;
761: RETCODE := G_ERROR;
762: ERRBUF := 'Unexpected error in Post_Import_Defaulting: '||SQLERRM;

Line 759: INVPUTLI.info(SQLERRM);

755: EXCEPTION
756: WHEN OTHERS THEN
757: IF l_inv_debug_level IN(101, 102) THEN
758: INVPUTLI.info('WHEN-OTHERS-EXCEPTION Post_Import_Defaulting: ' ||SQLCODE);
759: INVPUTLI.info(SQLERRM);
760: END IF;
761: RETCODE := G_ERROR;
762: ERRBUF := 'Unexpected error in Post_Import_Defaulting: '||SQLERRM;
763: END Post_Import_Defaulting;