DBA Data[Home] [Help]

APPS.INVPOPIF dependencies on INVPUOPI

Line 403: dumm_status := INVPUOPI.mtl_log_interface_err(

399: AND MIRI.process_flag=1;
400:
401: -- When organization id is missing, update process_flag, and log an error
402: FOR cr IN update_org_id LOOP
403: dumm_status := INVPUOPI.mtl_log_interface_err(
404: -1,
405: user_id,
406: login_id,
407: prog_appid,

Line 427: dumm_status := INVPUOPI.mtl_log_interface_err (

423:
424: END LOOP;
425:
426: FOR cr IN update_org_id_revs LOOP
427: dumm_status := INVPUOPI.mtl_log_interface_err (
428: -1,
429: user_id,
430: login_id,
431: prog_appid,

Line 1000: dumm_status := INVPUOPI.mtl_log_interface_err (

996:
997:
998: IF NOT ( l_return_status = FND_API.g_RET_STS_SUCCESS ) THEN
999: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: ' || 'Synch Up of ENI tables failed');
1000: dumm_status := INVPUOPI.mtl_log_interface_err (
1001: ORG_ID => -1,
1002: USER_ID =>user_id,
1003: LOGIN_ID =>login_id,
1004: PROG_APPID =>prog_appid,

Line 1022: dumm_status := INVPUOPI.mtl_log_interface_err (

1018: EXCEPTION
1019: WHEN OTHERS THEN
1020: l_msg_data := 'Unhandled Excpetion in INV_ENI_ITEMS_STAR_PKG: ';
1021: l_msg_data := l_msg_data || SQLERRM;
1022: dumm_status := INVPUOPI.mtl_log_interface_err (
1023: ORG_ID => -1,
1024: USER_ID =>user_id,
1025: LOGIN_ID =>login_id,
1026: PROG_APPID =>prog_appid,

Line 1709: dumm_status := INVPUOPI.mtl_log_interface_err(

1705: --Bug 4767919 Anmurali
1706:
1707: FOR ee in Error_Items LOOP
1708:
1709: dumm_status := INVPUOPI.mtl_log_interface_err(
1710: ee.organization_id,
1711: user_id,
1712: login_id,
1713: prog_appid,

Line 1994: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER(

1990: l_item_id := NULL;
1991:
1992: IF item_record.inventory_item_id IS NULL THEN
1993: IF item_record.item_number IS NOT NULL THEN
1994: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER(
1995: ITEM_NUMBER =>item_record.item_number
1996: ,ITEM_ID =>item_record.inventory_item_id
1997: ,TRANS_ID =>item_record.transaction_id
1998: ,ORG_ID =>item_record.organization_id

Line 2007: l_status := INVPUOPI.mtl_pr_parse_item_segments(

2003: item_record.segment9 || item_record.segment10 || item_record.segment11 || item_record.segment12 ||
2004: item_record.segment13 || item_record.segment14 || item_record.segment15 || item_record.segment16 ||
2005: item_record.segment17 || item_record.segment18 || item_record.segment19 || item_record.segment20 )
2006: IS NOT NULL THEN
2007: l_status := INVPUOPI.mtl_pr_parse_item_segments(
2008: P_ROW_ID => item_record.rowid,
2009: ITEM_NUMBER => item_record.item_number,
2010: ITEM_ID => item_record.inventory_item_id,
2011: ERR_TEXT => l_err_text);

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

2121:
2122: IF revision_record.inventory_item_id IS NOT NULL THEN
2123: l_item_id := revision_record.inventory_item_id;
2124: ELSIF revision_record.item_number is NOT NULL THEN
2125: l_status := INVPUOPI.mtl_pr_parse_flex_name (
2126: revision_record.organization_id
2127: ,'MSTK'
2128: ,revision_record.item_number
2129: ,l_item_id

Line 2217: l_dumm_status := INVPUOPI.mtl_log_interface_err(

2213: IF LENGTH(l_Item_Catalog) = INSTR(l_Item_Catalog,':') THEN
2214: --No ID is selected for this catalog name ...Mark these records as errored
2215: FOR cr IN update_catg_name(p_catg_name => l_Item_Catalog_Group_Name)
2216: LOOP
2217: l_dumm_status := INVPUOPI.mtl_log_interface_err(
2218: -1,
2219: p_user_id,
2220: p_login_id,
2221: p_prog_appid,