[Home] [Help]
30: l_request_id NUMBER;
31: l_pro_flag_3 NUMBER;
32: l_enabled_for_data_pool VARCHAR2(1);
33: BEGIN
34: INV_EGO_REVISION_VALIDATE.Set_Process_Control('EGO_ITEM_BULKLOAD');
35: RETCODE := G_SUCCESS;
36:
37: BEGIN
38: SELECT batch.source_system_id, NVL(opt.import_xref_only,'N'), NVL(opt.ENABLED_FOR_DATA_POOL, 'N')
184:
185: END IF; --IF l_retcode NOT IN (0, 1) THEN
186: END IF; -- Xref import only
187:
188: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
189: --Now returning the highest status recieved and stored in l_retcode
190: EXCEPTION
191: WHEN OTHERS THEN
192: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
188: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
189: --Now returning the highest status recieved and stored in l_retcode
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;
461: ,p_user_id IN NUMBER := NULL
462: ,p_login_id IN NUMBER := NULL) IS
463:
464: BEGIN
465: INV_EGO_REVISION_VALIDATE.Set_Process_Control('EGO_ITEM_BULKLOAD');
466:
467: INV_ITEM_CATEGORY_OI.process_Item_Category_records(
468: ERRBUF => ERRBUF
469: ,RETCODE => RETCODE
476: ,p_request_id => fnd_global.conc_request_id --4105841
477: ,p_user_id => p_user_id
478: ,p_login_id => fnd_global.conc_login_id);
479:
480: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
481: END process_Item_Category_records;
482:
483: ------------------------------------------------------------------------------------
484: /*