DBA Data[Home] [Help]

APPS.INVPOPIF dependencies on INVPUOPI

Line 420: dumm_status := INVPUOPI.mtl_log_interface_err(

416: -- End: 2808277 Supporting Item Revision Update
417: */
418: --wrong transaction type in msii
419: FOR cr IN wrong_trans_type_msii LOOP
420: dumm_status := INVPUOPI.mtl_log_interface_err(
421: -1,
422: user_id,
423: login_id,
424: prog_appid,

Line 445: dumm_status := INVPUOPI.mtl_log_interface_err(

441: END LOOP;
442:
443: -- wrong transaction_type in mtl_item_revisions_interface
444: FOR cr IN wrong_trans_type_miri LOOP
445: dumm_status := INVPUOPI.mtl_log_interface_err(
446: -1,
447: user_id,
448: login_id,
449: prog_appid,

Line 508: dumm_status := INVPUOPI.mtl_log_interface_err(

504: AND MIRI.process_flag=1;
505:
506: -- When organization id is missing, update process_flag, and log an error
507: FOR cr IN update_org_id LOOP
508: dumm_status := INVPUOPI.mtl_log_interface_err(
509: -1,
510: user_id,
511: login_id,
512: prog_appid,

Line 532: dumm_status := INVPUOPI.mtl_log_interface_err (

528:
529: END LOOP;
530:
531: FOR cr IN update_org_id_revs LOOP
532: dumm_status := INVPUOPI.mtl_log_interface_err (
533: -1,
534: user_id,
535: login_id,
536: prog_appid,

Line 1173: dumm_status := INVPUOPI.mtl_log_interface_err (

1169:
1170:
1171: IF NOT ( l_return_status = FND_API.g_RET_STS_SUCCESS ) THEN
1172: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Synch Up of ENI tables failed');
1173: dumm_status := INVPUOPI.mtl_log_interface_err (
1174: ORG_ID => -1,
1175: USER_ID =>user_id,
1176: LOGIN_ID =>login_id,
1177: PROG_APPID =>prog_appid,

Line 1195: dumm_status := INVPUOPI.mtl_log_interface_err (

1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: l_msg_data := 'Unhandled Excpetion in INV_ENI_ITEMS_STAR_PKG: ';
1194: l_msg_data := l_msg_data || SQLERRM;
1195: dumm_status := INVPUOPI.mtl_log_interface_err (
1196: ORG_ID => -1,
1197: USER_ID =>user_id,
1198: LOGIN_ID =>login_id,
1199: PROG_APPID =>prog_appid,

Line 1933: dumm_status := INVPUOPI.mtl_log_interface_err(

1929: --Bug 4767919 Anmurali
1930:
1931: FOR ee in Error_Items LOOP
1932:
1933: dumm_status := INVPUOPI.mtl_log_interface_err(
1934: ee.organization_id,
1935: user_id,
1936: login_id,
1937: prog_appid,

Line 2218: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER(

2214: l_item_id := NULL;
2215:
2216: IF item_record.inventory_item_id IS NULL THEN
2217: IF item_record.item_number IS NOT NULL THEN
2218: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER(
2219: ITEM_NUMBER =>item_record.item_number
2220: ,ITEM_ID =>item_record.inventory_item_id
2221: ,TRANS_ID =>item_record.transaction_id
2222: ,ORG_ID =>item_record.organization_id

Line 2231: l_status := INVPUOPI.mtl_pr_parse_item_segments(

2227: item_record.segment9 || item_record.segment10 || item_record.segment11 || item_record.segment12 ||
2228: item_record.segment13 || item_record.segment14 || item_record.segment15 || item_record.segment16 ||
2229: item_record.segment17 || item_record.segment18 || item_record.segment19 || item_record.segment20 )
2230: IS NOT NULL THEN
2231: l_status := INVPUOPI.mtl_pr_parse_item_segments(
2232: P_ROW_ID => item_record.rowid,
2233: ITEM_NUMBER => item_record.item_number,
2234: ITEM_ID => item_record.inventory_item_id,
2235: ERR_TEXT => l_err_text);

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 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 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 2349: l_status := INVPUOPI.mtl_pr_parse_flex_name (

2345:
2346: IF revision_record.inventory_item_id IS NOT NULL THEN
2347: l_item_id := revision_record.inventory_item_id;
2348: ELSIF revision_record.item_number is NOT NULL THEN
2349: l_status := INVPUOPI.mtl_pr_parse_flex_name (
2350: revision_record.organization_id
2351: ,'MSTK'
2352: ,revision_record.item_number
2353: ,l_item_id

Line 2443: l_dumm_status := INVPUOPI.mtl_log_interface_err(

2439: IF LENGTH(l_Item_Catalog) = INSTR(l_Item_Catalog,':') THEN
2440: --No ID is selected for this catalog name ...Mark these records as errored
2441: FOR cr IN update_catg_name(p_catg_name => l_Item_Catalog_Group_Name)
2442: LOOP
2443: l_dumm_status := INVPUOPI.mtl_log_interface_err(
2444: -1,
2445: p_user_id,
2446: p_login_id,
2447: p_prog_appid,

Line 2507: dumm_status := INVPUOPI.mtl_log_interface_err(

2503: AND emcgvb.START_ACTIVE_DATE IS NOT NULL AND emcgvb.START_ACTIVE_DATE <= SYSDATE) ;
2504:
2505: BEGIN
2506: FOR cr IN cur_non_released_icc LOOP
2507: dumm_status := INVPUOPI.mtl_log_interface_err(
2508: -1,
2509: p_user_id,
2510: p_login_id,
2511: p_prog_appid,