[Home] [Help]
32: l_enabled_for_data_pool VARCHAR2(1);
33: l_item_interface_rec EGO_IMPORT_USER_HOOKS.ITEM_INTERFACE_REC;
34:
35: BEGIN
36: INV_EGO_REVISION_VALIDATE.Set_Process_Control('EGO_ITEM_BULKLOAD');
37: RETCODE := G_SUCCESS;
38:
39: BEGIN
40: SELECT batch.source_system_id, NVL(opt.import_xref_only,'N'), NVL(opt.ENABLED_FOR_DATA_POOL, 'N')
233:
234: END IF; --IF l_retcode NOT IN (0, 1) THEN
235: END IF; -- Xref import only
236:
237: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
238: --Now returning the highest status recieved and stored in l_retcode
239: EXCEPTION
240: WHEN OTHERS THEN
241: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
237: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
238: --Now returning the highest status recieved and stored in l_retcode
239: EXCEPTION
240: WHEN OTHERS THEN
241: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
242: IF l_inv_debug_level IN(101, 102) THEN
243: INVPUTLI.info('WHEN-OTHERS-EXCEPTION item_open_interface_process: ' ||SQLCODE);
244: INVPUTLI.info(SQLERRM);
245: END IF;
521: ,p_user_id IN NUMBER := NULL
522: ,p_login_id IN NUMBER := NULL) IS
523:
524: BEGIN
525: INV_EGO_REVISION_VALIDATE.Set_Process_Control('EGO_ITEM_BULKLOAD');
526:
527: INV_ITEM_CATEGORY_OI.process_Item_Category_records(
528: ERRBUF => ERRBUF
529: ,RETCODE => RETCODE
536: ,p_request_id => fnd_global.conc_request_id --4105841
537: ,p_user_id => p_user_id
538: ,p_login_id => fnd_global.conc_login_id);
539:
540: INV_EGO_REVISION_VALIDATE.Set_Process_Control(NULL);
541: END process_Item_Category_records;
542:
543: ------------------------------------------------------------------------------------
544: /*