[Home] [Help]
261: tran_id := 0;
262: raise ASS_ITEM_ERR;
263: else
264: if rtn_status = -9999 then
265: dumm_status := INVPUOPI.mtl_log_interface_err(
266: 0,
267: user_id,
268: login_id,
269: prog_appid,
302: tran_id := 0;
303: raise ASS_ITEM_ERR;
304: else
305: if rtn_status = -9999 then
306: dumm_status := INVPUOPI.mtl_log_interface_err(
307: 0,
308: user_id,
309: login_id,
310: prog_appid,
349: --End Bug 8259665
350: END;
351:
352: IF l_Itemid_error THEN
353: dumm_status := INVPUOPI.mtl_log_interface_err(
354: -1,
355: user_id,
356: login_id,
357: prog_appid,
426: ,x_return_status => l_ret_status
427: ,x_msg_count => l_msg_count
428: ,x_msg_data => l_msg_data );
429: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
430: dumm_status := INVPUOPI.mtl_log_interface_err(
431: 0,
432: user_id,
433: login_id,
434: prog_appid,
470: RETURNING transaction_id BULK COLLECT INTO transaction_table;
471:
472: IF transaction_table.COUNT > 0 THEN
473: FOR j IN transaction_table.FIRST .. transaction_table.LAST LOOP
474: dumm_status := INVPUOPI.mtl_log_interface_err(
475: org_id,
476: user_id,
477: login_id,
478: prog_appid,
504: ,cp_organization_id => org_table(i));
505: FETCH c_get_style INTO l_style_item_id;
506:
507: IF c_get_style%NOTFOUND THEN
508: dumm_status := INVPUOPI.mtl_log_interface_err(
509: 0,
510: user_id,
511: login_id,
512: prog_appid,
584:
585: loop
586: if dbms_sql.fetch_rows(DSQL_ff_c) > 0 then
587: dbms_sql.column_value(DSQL_ff_c,1,DSQL_ff_transaction_id);
588: dumm_status := INVPUOPI.mtl_log_interface_err(
589: -1,
590: user_id,
591: login_id,
592: prog_appid,
625: if dbms_sql.is_open(DSQL_ff_c) then
626: dbms_sql.close_cursor(DSQL_ff_c);
627: end if;
628: err_text:= 'assign_item_header DSQL 1 '|| SQLERRM;
629: dumm_status := INVPUOPI.mtl_log_interface_err(
630: l_org_id,
631: user_id,
632: login_id,
633: prog_appid,
703: validation_check_status := 0;
704: dumm_status := NULL;
705:
706: if cr.item_number is not NULL then
707: rtn_status := INVPUOPI.mtl_pr_parse_item_number(
708: cr.item_number,
709: cr.inventory_item_id,
710: cr.transaction_id,
711: cr.organization_id,
719: We should not raise exception, so that other records are processed.
720: Log the error and set this record to 3 in MSII and proceed to next record.
721: */
722: -- RAISE ITEM_NUMBER_ERR ;
723: dumm_status := INVPUOPI.mtl_log_interface_err(
724: l_org_id,
725: user_id,
726: login_id,
727: prog_appid,
762: cr.segment15 is NULL and cr.segment16 is NULL and
763: cr.segment17 is NULL and cr.segment18 is NULL and
764: cr.segment19 is NULL and cr.segment20 is NULL and
765: l_item_num_gen <> 'F') then
766: dumm_status := INVPUOPI.mtl_log_interface_err(
767: 0,
768: user_id,
769: login_id,
770: prog_appid,
942: FND_MESSAGE.SET_NAME ('INV', 'INV_NO_OP_UNIT_FOR_ORG');
943: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', l_org_name);
944: l_msg_text := FND_MESSAGE.GET;
945: err_text := 'No Operating Unit Found for the Organization';
946: dumm_status := INVPUOPI.mtl_log_interface_err(
947: cr.organization_id,
948: user_id,
949: login_id,
950: prog_appid,
1074: if dbms_sql.is_open(DSQL_c) then
1075: dbms_sql.close_cursor(DSQL_c);
1076: end if;
1077: err_text:= 'assign_item_header DSQL 2 '|| SQLERRM;
1078: dumm_status := INVPUOPI.mtl_log_interface_err(
1079: l_org_id,
1080: user_id,
1081: login_id,
1082: prog_appid,
1198:
1199: if msiicount = 0 then
1200: error_msg := 'Orphan detected. This item has no parent in MSI';
1201: validation_check_status := -1;
1202: dumm_status := INVPUOPI.mtl_log_interface_err(
1203: cr.organization_id,
1204: user_id,
1205: login_id,
1206: prog_appid,
1718: update MTL_SYSTEM_ITEMS_INTERFACE
1719: set process_flag = l_process_flag_3
1720: where rowid = cr.rowid ;
1721:
1722: dumm_status := INVPUOPI.mtl_log_interface_err(
1723: -1,
1724: user_id,
1725: login_id,
1726: prog_appid,
1765: g_copy_item_id := -999999;
1766:
1767: IF x_ret_sts <>FND_API.G_RET_STS_SUCCESS THEN
1768:
1769: dumm_status := INVPUOPI.mtl_log_interface_err(
1770: cr.organization_id,
1771: user_id,
1772: login_id,
1773: prog_appid,
1812: x_return_status => x_ret_sts);
1813:
1814: IF x_ret_sts <>FND_API.G_RET_STS_SUCCESS THEN
1815:
1816: dumm_status := INVPUOPI.mtl_log_interface_err(
1817: cr.organization_id,
1818: user_id,
1819: login_id,
1820: prog_appid,
1842: ---Start: Bug fix 3051653. Bug Fix 8428488.
1843: if rtn_status = 0 then
1844: l_item_id := NULL;
1845: IF cr.item_number IS NULL THEN
1846: rtn_status := INVPUOPI.mtl_pr_parse_item_segments(p_row_id =>cr.rowid
1847: ,item_number =>l_item_number
1848: ,item_id =>l_item_id
1849: ,err_text => err_text);
1850: cr.item_number := l_item_number;
1853: end if;
1854:
1855: --Bug: 5512333
1856: IF cr.item_number IS NOT NULL THEN
1857: rtn_status := INVPUOPI.mtl_pr_parse_item_number(cr.item_number
1858: ,cr.inventory_item_id
1859: ,cr.transaction_id
1860: ,cr.organization_id
1861: ,err_text
1868: We should not raise exception, so that other records are processed.
1869: Log the error and set this record to 3 in MSII and proceed to next record.
1870: */
1871: -- RAISE ITEM_NUMBER_ERR ;
1872: dumm_status := INVPUOPI.mtl_log_interface_err(
1873: l_org_id,
1874: user_id,
1875: login_id,
1876: prog_appid,
1916: --Passing item number and organization_id to cursor for bug 3051653
1917: FOR c_revision_record IN c_get_revisions(l_item_number,
1918: cr.revision,cr.organization_id) LOOP
1919: IF l_item_id IS NULL THEN
1920: dumm_status := INVPUOPI.mtl_pr_parse_flex_name (
1921: c_revision_record.organization_id,
1922: 'MSTK', c_revision_record.item_number,
1923: flex_id, 0, err_temp);
1924: ELSE
2055:
2056: if rtn_status <> 0 then
2057: error_msg := err_text;
2058: if rtn_status=1403 then
2059: rtn_status := INVPUOPI.mtl_log_interface_err(
2060: l_org_id,
2061: user_id,
2062: login_id,
2063: prog_appid,
2069: 'MTL_SYSTEM_ITEMS_INTERFACE',
2070: 'INV_DESC_ITEM_ERROR',
2071: err_text);
2072: else
2073: rtn_status := INVPUOPI.mtl_log_interface_err(
2074: cr.organization_id,
2075: user_id,
2076: login_id,
2077: prog_appid,
2088: raise LOGGING_ERR;
2089: end if;
2090: end if;
2091: else --org_flag <> 0
2092: dumm_status := INVPUOPI.mtl_log_interface_err(
2093: l_org_id,
2094: user_id,
2095: login_id,
2096: prog_appid,
2131:
2132: exception
2133: when ASS_ITEM_ERR then
2134: error_msg := err_text;
2135: dumm_status := INVPUOPI.mtl_log_interface_err(
2136: l_org_id,
2137: user_id,
2138: login_id,
2139: prog_appid,
2153: --Fix for Bug 9706610
2154: /* Bug 13503782 : Start
2155: -- Commenting the below exception, this is not required as we have logged the error already.
2156: when ITEM_NUMBER_ERR then
2157: dumm_status := INVPUOPI.mtl_log_interface_err(
2158: l_org_id,
2159: user_id,
2160: login_id,
2161: prog_appid,
2170: return(rtn_status);
2171: */
2172: when OTHERS then
2173: error_msg := 'INVPAGI2.assign_item_header_recs:' || SQLERRM;
2174: dumm_status := INVPUOPI.mtl_log_interface_err(
2175: l_org_id ,
2176: user_id,
2177: login_id,
2178: prog_appid,