DBA Data[Home] [Help]

APPS.INVPOPIF dependencies on FND_GLOBAL

Line 107: prog_appid => FND_GLOBAL.prog_appl_id,

103: all_org => p_all_org,
104: val_item_flag => p_val_item_flag,
105: pro_item_flag => p_pro_item_flag,
106: del_rec_flag => p_del_rec_flag,
107: prog_appid => FND_GLOBAL.prog_appl_id,
108: prog_id => FND_GLOBAL.conc_program_id,
109: request_id => FND_GLOBAL.conc_request_id,
110: user_id => FND_GLOBAL.user_id,
111: login_id => FND_GLOBAL.login_id,

Line 108: prog_id => FND_GLOBAL.conc_program_id,

104: val_item_flag => p_val_item_flag,
105: pro_item_flag => p_pro_item_flag,
106: del_rec_flag => p_del_rec_flag,
107: prog_appid => FND_GLOBAL.prog_appl_id,
108: prog_id => FND_GLOBAL.conc_program_id,
109: request_id => FND_GLOBAL.conc_request_id,
110: user_id => FND_GLOBAL.user_id,
111: login_id => FND_GLOBAL.login_id,
112: err_text => err_text,

Line 109: request_id => FND_GLOBAL.conc_request_id,

105: pro_item_flag => p_pro_item_flag,
106: del_rec_flag => p_del_rec_flag,
107: prog_appid => FND_GLOBAL.prog_appl_id,
108: prog_id => FND_GLOBAL.conc_program_id,
109: request_id => FND_GLOBAL.conc_request_id,
110: user_id => FND_GLOBAL.user_id,
111: login_id => FND_GLOBAL.login_id,
112: err_text => err_text,
113: xset_id => NVL(p_xset_id,-999),

Line 110: user_id => FND_GLOBAL.user_id,

106: del_rec_flag => p_del_rec_flag,
107: prog_appid => FND_GLOBAL.prog_appl_id,
108: prog_id => FND_GLOBAL.conc_program_id,
109: request_id => FND_GLOBAL.conc_request_id,
110: user_id => FND_GLOBAL.user_id,
111: login_id => FND_GLOBAL.login_id,
112: err_text => err_text,
113: xset_id => NVL(p_xset_id,-999),
114: run_mode => p_run_mode,

Line 111: login_id => FND_GLOBAL.login_id,

107: prog_appid => FND_GLOBAL.prog_appl_id,
108: prog_id => FND_GLOBAL.conc_program_id,
109: request_id => FND_GLOBAL.conc_request_id,
110: user_id => FND_GLOBAL.user_id,
111: login_id => FND_GLOBAL.login_id,
112: err_text => err_text,
113: xset_id => NVL(p_xset_id,-999),
114: run_mode => p_run_mode,
115: source_org_id => source_org_id);

Line 120: AND request_id = FND_GLOBAL.conc_request_id

116:
117: SELECT count(*) INTO l_pro_flag_3
118: FROM mtl_system_items_interface
119: WHERE process_flag = 3
120: AND request_id = FND_GLOBAL.conc_request_id
121: AND rownum = 1;
122:
123: IF l_pro_flag_3 > 0 THEN
124: FND_FILE.put_line (FND_FILE.log, 'Validation errors occured during Import Item');

Line 295: --IF fnd_global.conc_program_id <> -1 THEN Bug:3547401

291: ** Make sure transaction type is in upper case
292: */
293: --Start 2698140 : Gather stats before running the IOI
294: --When called through GRP pac, or through PLM prog_id will be -1.
295: --IF fnd_global.conc_program_id <> -1 THEN Bug:3547401
296: IF NVL(prog_id,-1) <> -1 THEN
297:
298: IF l_inv_debug_level IN(101, 102) THEN
299: INVPUTLI.info('INVPOPIF: Gathering interface table stats');

Line 2040: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,

2036: INVPUTLI.info('INVPOPIF.update sync records: Item Number update' || item_record.item_number || ' ' || l_item_number || ' ' || l_item_id);
2037: END IF;
2038:
2039: IF ( l_updateable_item_number <> 'Y' ) THEN
2040: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2041: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2042: 'INVPOPIF: Update to Item number not allowed',
2043: 'ITEM NUMBER',
2044: 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 2041: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,

2037: END IF;
2038:
2039: IF ( l_updateable_item_number <> 'Y' ) THEN
2040: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2041: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2042: 'INVPOPIF: Update to Item number not allowed',
2043: 'ITEM NUMBER',
2044: 'MTL_SYSTEM_ITEMS_INTERFACE',
2045: 'INV_ITEM_NUMBER_NO_UDPATE',

Line 2058: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,

2054:
2055: END IF;
2056:
2057: IF ( isMasterOrg(item_record.organization_id) = 0 ) THEN
2058: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2059: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2060: 'INVPOPIF: Update to Item number not allowed in child organization',
2061: 'ITEM NUMBER',
2062: 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 2059: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,

2055: END IF;
2056:
2057: IF ( isMasterOrg(item_record.organization_id) = 0 ) THEN
2058: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2059: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2060: 'INVPOPIF: Update to Item number not allowed in child organization',
2061: 'ITEM NUMBER',
2062: 'MTL_SYSTEM_ITEMS_INTERFACE',
2063: 'INV_ITEM_NUMBER_ORG_NO_UDPATE',

Line 2085: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,

2081: IF (l_item_exist <> 0 AND l_item_exist <> l_item_id) THEN
2082: IF l_inv_debug_level IN(101, 102) THEN
2083: INVPUTLI.info('INVPOPIF.update sync records: Item Number update to duplicate case:' || item_record.item_number || ' ' || l_item_exist || ' ' || l_item_id);
2084: END IF;
2085: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2086: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2087: 'INVPOPIF: Update to Duplicate Item number',
2088: 'ITEM NUMBER',
2089: 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 2086: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,

2082: IF l_inv_debug_level IN(101, 102) THEN
2083: INVPUTLI.info('INVPOPIF.update sync records: Item Number update to duplicate case:' || item_record.item_number || ' ' || l_item_exist || ' ' || l_item_id);
2084: END IF;
2085: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2086: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2087: 'INVPOPIF: Update to Duplicate Item number',
2088: 'ITEM NUMBER',
2089: 'MTL_SYSTEM_ITEMS_INTERFACE',
2090: 'INV_UPDATE_TO_EXIST_ITEM_NAME',