DBA Data[Home] [Help]

APPS.INVPOPIF dependencies on FND_GLOBAL

Line 118: prog_appid => FND_GLOBAL.prog_appl_id,

114: all_org => p_all_org,
115: val_item_flag => p_val_item_flag,
116: pro_item_flag => p_pro_item_flag,
117: del_rec_flag => p_del_rec_flag,
118: prog_appid => FND_GLOBAL.prog_appl_id,
119: prog_id => FND_GLOBAL.conc_program_id,
120: request_id => FND_GLOBAL.conc_request_id,
121: user_id => FND_GLOBAL.user_id,
122: login_id => FND_GLOBAL.login_id,

Line 119: prog_id => FND_GLOBAL.conc_program_id,

115: val_item_flag => p_val_item_flag,
116: pro_item_flag => p_pro_item_flag,
117: del_rec_flag => p_del_rec_flag,
118: prog_appid => FND_GLOBAL.prog_appl_id,
119: prog_id => FND_GLOBAL.conc_program_id,
120: request_id => FND_GLOBAL.conc_request_id,
121: user_id => FND_GLOBAL.user_id,
122: login_id => FND_GLOBAL.login_id,
123: err_text => err_text,

Line 120: request_id => FND_GLOBAL.conc_request_id,

116: pro_item_flag => p_pro_item_flag,
117: del_rec_flag => p_del_rec_flag,
118: prog_appid => FND_GLOBAL.prog_appl_id,
119: prog_id => FND_GLOBAL.conc_program_id,
120: request_id => FND_GLOBAL.conc_request_id,
121: user_id => FND_GLOBAL.user_id,
122: login_id => FND_GLOBAL.login_id,
123: err_text => err_text,
124: xset_id => NVL(p_xset_id,-999),

Line 121: user_id => FND_GLOBAL.user_id,

117: del_rec_flag => p_del_rec_flag,
118: prog_appid => FND_GLOBAL.prog_appl_id,
119: prog_id => FND_GLOBAL.conc_program_id,
120: request_id => FND_GLOBAL.conc_request_id,
121: user_id => FND_GLOBAL.user_id,
122: login_id => FND_GLOBAL.login_id,
123: err_text => err_text,
124: xset_id => NVL(p_xset_id,-999),
125: run_mode => p_run_mode,

Line 122: login_id => FND_GLOBAL.login_id,

118: prog_appid => FND_GLOBAL.prog_appl_id,
119: prog_id => FND_GLOBAL.conc_program_id,
120: request_id => FND_GLOBAL.conc_request_id,
121: user_id => FND_GLOBAL.user_id,
122: login_id => FND_GLOBAL.login_id,
123: err_text => err_text,
124: xset_id => NVL(p_xset_id,-999),
125: run_mode => p_run_mode,
126: source_org_id => source_org_id,

Line 132: AND request_id = FND_GLOBAL.conc_request_id

128:
129: SELECT count(*) INTO l_pro_flag_3
130: FROM mtl_system_items_interface
131: WHERE process_flag = 3
132: AND request_id = FND_GLOBAL.conc_request_id
133: AND rownum = 1;
134:
135: IF l_pro_flag_3 > 0 THEN
136: FND_FILE.put_line (FND_FILE.log, 'Validation errors occured during Import Item');

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

333: ** Make sure transaction type is in upper case
334: */
335: --Start 2698140 : Gather stats before running the IOI
336: --When called through GRP pac, or through PLM prog_id will be -1.
337: --IF fnd_global.conc_program_id <> -1 THEN Bug:3547401
338: IF NVL(prog_id,-1) <> -1 AND gather_stats = 1 THEN /* Added for Bug 8532728 */
339:
340: IF l_inv_debug_level IN(101, 102) THEN
341: INVPUTLI.info('INVPOPIF: Gathering interface table stats');

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

2260: INVPUTLI.info('INVPOPIF.update sync records: Item Number update' || item_record.item_number || ' ' || l_item_number || ' ' || l_item_id);
2261: END IF;
2262:
2263: IF ( l_updateable_item_number <> 'Y' ) THEN
2264: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2265: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2266: 'INVPOPIF: Update to Item number not allowed',
2267: 'ITEM NUMBER',
2268: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

2261: END IF;
2262:
2263: IF ( l_updateable_item_number <> 'Y' ) THEN
2264: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2265: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2266: 'INVPOPIF: Update to Item number not allowed',
2267: 'ITEM NUMBER',
2268: 'MTL_SYSTEM_ITEMS_INTERFACE',
2269: 'INV_ITEM_NUMBER_NO_UDPATE',

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

2278:
2279: END IF;
2280:
2281: IF ( isMasterOrg(item_record.organization_id) = 0 ) THEN
2282: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2283: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2284: 'INVPOPIF: Update to Item number not allowed in child organization',
2285: 'ITEM NUMBER',
2286: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

2279: END IF;
2280:
2281: IF ( isMasterOrg(item_record.organization_id) = 0 ) THEN
2282: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2283: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2284: 'INVPOPIF: Update to Item number not allowed in child organization',
2285: 'ITEM NUMBER',
2286: 'MTL_SYSTEM_ITEMS_INTERFACE',
2287: 'INV_ITEM_NUMBER_ORG_NO_UDPATE',

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

2305: IF (l_item_exist <> 0 AND l_item_exist <> l_item_id) THEN
2306: IF l_inv_debug_level IN(101, 102) THEN
2307: INVPUTLI.info('INVPOPIF.update sync records: Item Number update to duplicate case:' || item_record.item_number || ' ' || l_item_exist || ' ' || l_item_id);
2308: END IF;
2309: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2310: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2311: 'INVPOPIF: Update to Duplicate Item number',
2312: 'ITEM NUMBER',
2313: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

2306: IF l_inv_debug_level IN(101, 102) THEN
2307: INVPUTLI.info('INVPOPIF.update sync records: Item Number update to duplicate case:' || item_record.item_number || ' ' || l_item_exist || ' ' || l_item_id);
2308: END IF;
2309: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2310: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2311: 'INVPOPIF: Update to Duplicate Item number',
2312: 'ITEM NUMBER',
2313: 'MTL_SYSTEM_ITEMS_INTERFACE',
2314: 'INV_UPDATE_TO_EXIST_ITEM_NAME',