eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVPVHDR dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 283: from MTL_SYSTEM_ITEMS_INTERFACE

279: DIMENSION_UOM_CODE,
280: UNIT_LENGTH,
281: UNIT_WIDTH,
282: UNIT_HEIGHT
283: from MTL_SYSTEM_ITEMS_INTERFACE
284: where ((organization_id + 0 = org_id) or
285: (all_Org = 1))
286: and set_process_id = xset_id
287: and process_flag = 2;

Line 322: ** from MTL_SYSTEM_ITEMS_INTERFACE

318: ** item_id_in number) is
319: ** select inventory_item_id,
320: ** transaction_id,
321: ** organization_id
322: ** from MTL_SYSTEM_ITEMS_INTERFACE
323: ** where inventory_item_id <> item_id_in
324: ** and set_process_id = nvl(xset_id, set_process_id)
325: ** and nvl(segment1,'.') = nvl(seg1,'.')
326: ** and nvl(segment2,'.') = nvl(seg2,'.')

Line 408: l_item_number mtl_system_items_interface.item_number%TYPE;

404: l_required_flag varchar2(1) := 'Y';
405:
406: --3360280:KFV validation using fnd_flex_keyval
407: l_valid_segments BOOLEAN := FALSE;
408: l_item_number mtl_system_items_interface.item_number%TYPE;
409: l_deliminator_count NUMBER(10) := 0;
410: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
411: l_col_name VARCHAR2(100);
412: l_is_gdsn_batch NUMBER;

Line 518: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';

514: /*
515: ** End section for dynamic sql bind variables
516: */
517:
518: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';
519:
520: /*
521: ** validate the records
522: */

Line 538: from mtl_system_items_interface

534:
535: /* Bug 4705184. Get item id from the cursor. At this point there is no change in item id.
536: select inventory_item_id
537: into l_item_id
538: from mtl_system_items_interface
539: where transaction_id = cr.transaction_id
540: and set_process_id = xset_id ; */
541:
542: /* Put in the values of cr.segmentX in the right

Line 625: ,'MTL_SYSTEM_ITEMS_INTERFACE'

621: ,request_id
622: ,cr.transaction_id
623: ,error_msg
624: ,null
625: ,'MTL_SYSTEM_ITEMS_INTERFACE'
626: ,'BOM_PARSE_ITEM_ERROR'
627: ,err_text);
628: if dumm_status < 0 then
629: raise LOGGING_ERR;

Line 674: 'MTL_SYSTEM_ITEMS_INTERFACE',

670: request_id,
671: cr.TRANSACTION_ID,
672: substr(FND_FLEX_KEYVAL.error_message,1,239),
673: 'ITEM_NUMBER',
674: 'MTL_SYSTEM_ITEMS_INTERFACE',
675: 'INV_IOI_ERR',
676: err_text);
677: if dumm_status < 0 then
678: raise LOGGING_ERR;

Line 698: 'MTL_SYSTEM_ITEMS_INTERFACE',

694: request_id,
695: cr.TRANSACTION_ID,
696: error_msg,
697: 'ITEM_NUMBER',
698: 'MTL_SYSTEM_ITEMS_INTERFACE',
699: 'INV_IOI_ERR',
700: err_text);
701: if dumm_status < 0 then
702: raise LOGGING_ERR;

Line 825: update mtl_system_items_interface

821: dbms_sql.column_value(DSQL_c1,1,DSQL_inventory_item_id);
822:
823: dup_item_id := DSQL_inventory_item_id;
824:
825: update mtl_system_items_interface
826: set inventory_item_id = dup_item_id
827: where transaction_id = cr.transaction_id
828: and set_process_id = xset_id;
829:

Line 867: from mtl_system_items_interface msii,

863:
864: DSQL_statement2 := ' select msii.inventory_item_id,
865: msii.transaction_id,
866: msii.organization_id
867: from mtl_system_items_interface msii,
868: mtl_parameters mp
869: where msii.inventory_item_id <>
870: :l_item_id_bind
871: and set_process_id = :xset_id_bind

Line 925: update mtl_system_items_interface

921: IF l_inv_debug_level IN(101, 102) THEN
922: INVPUTLI.info('INVPVHDR: Same item being added to MULTIPLE masters ');
923: INVPUTLI.info('INVPVHDR: So now updating inv_item_id in MSII, MIRI ');
924: END IF;
925: update mtl_system_items_interface
926: set inventory_item_id = l_item_id
927: where transaction_id = DSQL2_transaction_id
928: and set_process_id = xset_id;
929:

Line 1051: 'MTL_SYSTEM_ITEMS_INTERFACE',

1047: request_id,
1048: cr.TRANSACTION_ID,
1049: error_msg,
1050: 'INVENTORY_ITEM_ID',
1051: 'MTL_SYSTEM_ITEMS_INTERFACE',
1052: 'INV_IOI_ERR',
1053: err_text);
1054: if dumm_status < 0 then
1055: raise LOGGING_ERR;

Line 1061: from MTL_SYSTEM_ITEMS_INTERFACE

1057: else
1058: stmt := 4;
1059: select count(*)
1060: into ext_flag
1061: from MTL_SYSTEM_ITEMS_INTERFACE
1062: where inventory_item_id = l_item_id
1063: and organization_id = cr.organization_id
1064: and process_flag = 2
1065: and set_process_id = xset_id;

Line 1100: 'MTL_SYSTEM_ITEMS_INTERFACE',

1096: request_id,
1097: cr.TRANSACTION_ID,
1098: error_msg,
1099: 'INVENTORY_ITEM_ID',
1100: 'MTL_SYSTEM_ITEMS_INTERFACE',
1101: 'INV_IOI_ERR',
1102: err_text);
1103: if dumm_status < 0 then
1104: raise LOGGING_ERR;

Line 1215: 'MTL_SYSTEM_ITEMS_INTERFACE',

1211: request_id,
1212: cr.TRANSACTION_ID,
1213: error_msg,
1214: 'SEGMENTS',
1215: 'MTL_SYSTEM_ITEMS_INTERFACE',
1216: 'INV_IOI_ERR',
1217: err_text);
1218: /*NP 08-APR-96 Changed the table to
1219: **be msi instead of MSI_intf

Line 1233: **from MTL_SYSTEM_ITEMS_INTERFACE msii

1229: /*
1230: ** Changing following stmt to dynamic sql
1231: **select count(*)
1232: **into ext_flag
1233: **from MTL_SYSTEM_ITEMS_INTERFACE msii
1234: **where organization_id = cr.organization_id
1235: **and nvl(msii.segment1, '.') = nvl(cr.segment1,'.');
1236: **and so on......
1237: ** intermediate step: ...... = nvl(:cr_segment1_bind, '.')

Line 1244: from MTL_SYSTEM_ITEMS_INTERFACE msii

1240: ** 03MAY96 Added xset_id processing to this dynamic sql stmt.
1241: */
1242:
1243: DSQL_statement4 := 'select count(*)
1244: from MTL_SYSTEM_ITEMS_INTERFACE msii
1245: where organization_id = :organization_id_bind
1246: and set_process_id = :xset_id_bind
1247: and process_flag = 2
1248: and ' || statement_temp4;

Line 1340: 'MTL_SYSTEM_ITEMS_INTERFACE',

1336: request_id,
1337: cr.TRANSACTION_ID,
1338: error_msg,
1339: 'SEGMENTS',
1340: 'MTL_SYSTEM_ITEMS_INTERFACE',
1341: 'INV_IOI_ERR',
1342: err_text);
1343: if dumm_status < 0 then
1344: raise LOGGING_ERR;

Line 1363: 'MTL_SYSTEM_ITEMS_INTERFACE',

1359: request_id,
1360: cr.TRANSACTION_ID,
1361: error_msg,
1362: 'DESCRIPTION',
1363: 'MTL_SYSTEM_ITEMS_INTERFACE',
1364: 'INV_DESC_ITEM_ERROR',
1365: err_text);
1366: status := 1;
1367: if dumm_status < 0 then

Line 1398: 'MTL_SYSTEM_ITEMS_INTERFACE',

1394: request_id,
1395: cr.TRANSACTION_ID,
1396: error_msg,
1397: 'UOM_PROFILE',
1398: 'MTL_SYSTEM_ITEMS_INTERFACE',
1399: 'INV_INVALID_PRIMARY_UOM',
1400: err_text);
1401: status := 1;
1402: if dumm_status < 0 then

Line 1421: 'MTL_SYSTEM_ITEMS_INTERFACE',

1417: request_id,
1418: cr.TRANSACTION_ID,
1419: error_msg,
1420: 'SHIPPABLE_ITEM_FLAG',
1421: 'MTL_SYSTEM_ITEMS_INTERFACE',
1422: 'INV_SHIP_INT_YES',
1423: err_text);
1424: status := 1;
1425: if dumm_status < 0 then

Line 1443: 'MTL_SYSTEM_ITEMS_INTERFACE',

1439: request_id,
1440: cr.TRANSACTION_ID,
1441: error_msg,
1442: 'BOM_ITEM_TYPE',
1443: 'MTL_SYSTEM_ITEMS_INTERFACE',
1444: 'INV_CUSTOMER',
1445: err_text);
1446: status := 1;
1447: if dumm_status < 0 then

Line 1464: 'MTL_SYSTEM_ITEMS_INTERFACE',

1460: request_id,
1461: cr.TRANSACTION_ID,
1462: error_msg,
1463: 'BOM_ITEM_TYPE',
1464: 'MTL_SYSTEM_ITEMS_INTERFACE',
1465: 'INV_CUSTOMER',
1466: err_text);
1467: status := 1;
1468: if dumm_status < 0 then

Line 1483: 'MTL_SYSTEM_ITEMS_INTERFACE',

1479: request_id,
1480: cr.TRANSACTION_ID,
1481: error_msg,
1482: 'SHIPPABLE_ITEM_FLAG',
1483: 'MTL_SYSTEM_ITEMS_INTERFACE',
1484: 'INV_SHIPPABLE',
1485: err_text);
1486: status := 1;
1487: if dumm_status < 0 then

Line 1505: 'MTL_SYSTEM_ITEMS_INTERFACE',

1501: request_id,
1502: cr.TRANSACTION_ID,
1503: error_msg,
1504: 'BOM_ITEM_TYPE',
1505: 'MTL_SYSTEM_ITEMS_INTERFACE',
1506: 'INV_IOI_PLANNING_DEP',
1507: err_text);
1508: status := 1;
1509: if dumm_status < 0 then

Line 1527: 'MTL_SYSTEM_ITEMS_INTERFACE',

1523: request_id,
1524: cr.TRANSACTION_ID,
1525: error_msg,
1526: 'BOM_ITEM_TYPE',
1527: 'MTL_SYSTEM_ITEMS_INTERFACE',
1528: 'INV_IOI_BOM_STANDARD',
1529: err_text);
1530: status := 1;
1531: if dumm_status < 0 then

Line 1555: 'MTL_SYSTEM_ITEMS_INTERFACE',

1551: request_id,
1552: cr.TRANSACTION_ID,
1553: error_msg,
1554: 'INTERNAL_ORDER_FLAG',
1555: 'MTL_SYSTEM_ITEMS_INTERFACE',
1556: -- 'INV_INTERNAL',
1557: l_msg_name,
1558: err_text);
1559: status := 1;

Line 1579: 'MTL_SYSTEM_ITEMS_INTERFACE',

1575: request_id,
1576: cr.TRANSACTION_ID,
1577: error_msg,
1578: 'STOCK_ENABLED_FLAG',
1579: 'MTL_SYSTEM_ITEMS_INTERFACE',
1580: 'INV_STOCKABLE',
1581: err_text);
1582: if dumm_status < 0 then
1583: raise LOGGING_ERR;

Line 1608: 'MTL_SYSTEM_ITEMS_INTERFACE',

1604: request_id,
1605: cr.TRANSACTION_ID,
1606: error_msg,
1607: 'INVENTORY_ITEM_FLAG',
1608: 'MTL_SYSTEM_ITEMS_INTERFACE',
1609: -- 'INV_ITM_SERVICE_ITM',
1610: 'INV_NO_INVENTORY_ITEM',
1611: err_text);
1612: if dumm_status < 0 then

Line 1640: 'MTL_SYSTEM_ITEMS_INTERFACE',

1636: request_id,
1637: cr.TRANSACTION_ID,
1638: error_msg,
1639: 'INVENTORY_ITEM_FLAG',
1640: 'MTL_SYSTEM_ITEMS_INTERFACE',
1641: 'INV_BOM_ENABLED1',
1642: err_text);
1643: if dumm_status < 0 then
1644: raise LOGGING_ERR;

Line 1662: 'MTL_SYSTEM_ITEMS_INTERFACE',

1658: request_id,
1659: cr.TRANSACTION_ID,
1660: error_msg,
1661: 'INVENTORY_ITEM_FLAG',
1662: 'MTL_SYSTEM_ITEMS_INTERFACE',
1663: 'INV_BUILD_WIP_NO',
1664: err_text);
1665: if dumm_status < 0 then
1666: raise LOGGING_ERR;

Line 1684: 'MTL_SYSTEM_ITEMS_INTERFACE',

1680: request_id,
1681: cr.TRANSACTION_ID,
1682: error_msg,
1683: 'PURCHASING_ITEM_FLAG',
1684: 'MTL_SYSTEM_ITEMS_INTERFACE',
1685: 'INV_PO_ENABLED',
1686: err_text);
1687: if dumm_status < 0 then
1688: raise LOGGING_ERR;

Line 1706: 'MTL_SYSTEM_ITEMS_INTERFACE',

1702: request_id,
1703: cr.TRANSACTION_ID,
1704: error_msg,
1705: 'CUSTOMER_ORDER_FLAG',
1706: 'MTL_SYSTEM_ITEMS_INTERFACE',
1707: 'INV_CUSTOMER_ENABLED',
1708: err_text);
1709: if dumm_status < 0 then
1710: raise LOGGING_ERR;

Line 1728: 'MTL_SYSTEM_ITEMS_INTERFACE',

1724: request_id,
1725: cr.TRANSACTION_ID,
1726: error_msg,
1727: 'INVOICEABLE_ITEM_FLAG',
1728: 'MTL_SYSTEM_ITEMS_INTERFACE',
1729: 'INV_INVOICE_ENABLED',
1730: err_text);
1731: if dumm_status < 0 then
1732: raise LOGGING_ERR;

Line 1750: 'MTL_SYSTEM_ITEMS_INTERFACE',

1746: request_id,
1747: cr.TRANSACTION_ID,
1748: error_msg,
1749: 'SERVICE_ITEM_FLAG',
1750: 'MTL_SYSTEM_ITEMS_INTERFACE',
1751: 'BOM_OP_VALIDATION_ERR',
1752: err_text);
1753: if dumm_status < 0 then
1754: raise LOGGING_ERR;

Line 1773: 'MTL_SYSTEM_ITEMS_INTERFACE',

1769: cr.TRANSACTION_ID,
1770: error_msg,
1771: -- 'SERVICE_ITEM_FLAG',
1772: 'CONTRACT_ITEM_TYPE_CODE',
1773: 'MTL_SYSTEM_ITEMS_INTERFACE',
1774: -- 'INV_SERVICE',
1775: 'INV_SERVICEABLE_CONTRACT',
1776: err_text);
1777: if dumm_status < 0 then

Line 1807: 'MTL_SYSTEM_ITEMS_INTERFACE',

1803: cr.TRANSACTION_ID,
1804: error_msg,
1805: -- 'SERVICE_ITEM_FLAG',
1806: 'CONTRACT_ITEM_TYPE_CODE',
1807: 'MTL_SYSTEM_ITEMS_INTERFACE',
1808: 'INV_SERVICE1',
1809: err_text);
1810: if dumm_status < 0 then
1811: raise LOGGING_ERR;

Line 1841: 'MTL_SYSTEM_ITEMS_INTERFACE',

1837: cr.TRANSACTION_ID,
1838: error_msg,
1839: -- 'SERVICE_ITEM_FLAG',
1840: 'CONTRACT_ITEM_TYPE_CODE',
1841: 'MTL_SYSTEM_ITEMS_INTERFACE',
1842: 'INV_SERVICE2',
1843: err_text);
1844: if dumm_status < 0 then
1845: raise LOGGING_ERR;

Line 1872: 'MTL_SYSTEM_ITEMS_INTERFACE',

1868: cr.TRANSACTION_ID,
1869: error_msg,
1870: -- 'SERVICE_ITEM_FLAG',
1871: 'CONTRACT_ITEM_TYPE_CODE',
1872: 'MTL_SYSTEM_ITEMS_INTERFACE',
1873: -- 'INV_SERVICE3',
1874: 'INV_SER_DURATION_MAND',
1875: err_text);
1876: if dumm_status < 0 then

Line 1896: 'MTL_SYSTEM_ITEMS_INTERFACE',

1892: request_id,
1893: cr.TRANSACTION_ID,
1894: error_msg,
1895: 'SERVICEABLE_PRODUCT_FLAG',
1896: 'MTL_SYSTEM_ITEMS_INTERFACE',
1897: 'INV_SERVICE_PROD_FL',
1898: err_text);
1899: if dumm_status < 0 then
1900: raise LOGGING_ERR;

Line 1919: 'MTL_SYSTEM_ITEMS_INTERFACE',

1915: request_id,
1916: cr.TRANSACTION_ID,
1917: error_msg,
1918: 'PICK_COMPONENTS_FLAG',
1919: 'MTL_SYSTEM_ITEMS_INTERFACE',
1920: 'INV_IOI_PICK_DEP',
1921: err_text);
1922: if dumm_status < 0 then
1923: raise LOGGING_ERR;

Line 1938: 'MTL_SYSTEM_ITEMS_INTERFACE',

1934: request_id,
1935: cr.TRANSACTION_ID,
1936: error_msg,
1937: 'PICK_COMPONENTS_FLAG',
1938: 'MTL_SYSTEM_ITEMS_INTERFACE',
1939: 'INV_MRP_PLANNING',
1940: err_text);
1941: if dumm_status < 0 then
1942: raise LOGGING_ERR;

Line 1962: 'MTL_SYSTEM_ITEMS_INTERFACE',

1958: request_id,
1959: cr.TRANSACTION_ID,
1960: error_msg,
1961: 'REPLENISH_TO_ORDER',
1962: 'MTL_SYSTEM_ITEMS_INTERFACE',
1963: 'INV_IOI_REPL_TO_ORDER_DEP',
1964: err_text);
1965: if dumm_status < 0 then
1966: raise LOGGING_ERR;

Line 1992: 'MTL_SYSTEM_ITEMS_INTERFACE',

1988: request_id,
1989: cr.TRANSACTION_ID,
1990: error_msg,
1991: 'LOT_CONTROL_CODE',
1992: 'MTL_SYSTEM_ITEMS_INTERFACE',
1993: 'INV_AUTO_LOT_PREFIX',
1994: err_text);
1995: if dumm_status < 0 then
1996: raise LOGGING_ERR;

Line 2029: 'MTL_SYSTEM_ITEMS_INTERFACE',

2025: request_id,
2026: cr.TRANSACTION_ID,
2027: error_msg,
2028: 'START_AUTO_LOT_NUMBER',
2029: 'MTL_SYSTEM_ITEMS_INTERFACE',
2030: 'INV_START_AUTO_LOT_INVALID_NUM',
2031: err_text);
2032: if dumm_status < 0 then
2033: raise LOGGING_ERR;

Line 2053: 'MTL_SYSTEM_ITEMS_INTERFACE',

2049: request_id,
2050: cr.TRANSACTION_ID,
2051: error_msg,
2052: 'LOT_CONTROL_CODE',
2053: 'MTL_SYSTEM_ITEMS_INTERFACE',
2054: 'INV_START_LOT_NUM',
2055: err_text);
2056: if dumm_status < 0 then
2057: raise LOGGING_ERR;

Line 2082: 'MTL_SYSTEM_ITEMS_INTERFACE',

2078: request_id,
2079: cr.TRANSACTION_ID,
2080: error_msg,
2081: 'SERIAL_NUMBER_CONTROL_CODE',
2082: 'MTL_SYSTEM_ITEMS_INTERFACE',
2083: 'INV_START_SERIAL_NUM',
2084: err_text);
2085: if dumm_status < 0 then
2086: raise LOGGING_ERR;

Line 2111: 'MTL_SYSTEM_ITEMS_INTERFACE',

2107: request_id,
2108: cr.TRANSACTION_ID,
2109: error_msg,
2110: 'SERIAL_NUMBER_CONTROL_CODE',
2111: 'MTL_SYSTEM_ITEMS_INTERFACE',
2112: 'INV_AUTO_SERIAL_PREFIX',
2113: err_text);
2114: if dumm_status < 0 then
2115: raise LOGGING_ERR;

Line 2133: 'MTL_SYSTEM_ITEMS_INTERFACE',

2129: request_id,
2130: cr.TRANSACTION_ID,
2131: error_msg,
2132: 'SHELF_LIFE_CODE',
2133: 'MTL_SYSTEM_ITEMS_INTERFACE',
2134: 'INV_SHELF_DAYS_MAND',
2135: err_text);
2136: if dumm_status < 0 then
2137: raise LOGGING_ERR;

Line 2155: 'MTL_SYSTEM_ITEMS_INTERFACE',

2151: request_id,
2152: cr.TRANSACTION_ID,
2153: error_msg,
2154: 'OUTSIDE_OPERATION_FLAG',
2155: 'MTL_SYSTEM_ITEMS_INTERFACE',
2156: 'INV_IOI_OUT_OP_FLAG_DEP',
2157: err_text);
2158: if dumm_status < 0 then
2159: raise LOGGING_ERR;

Line 2174: 'MTL_SYSTEM_ITEMS_INTERFACE',

2170: request_id,
2171: cr.TRANSACTION_ID,
2172: error_msg,
2173: 'OUTSIDE_OPERATION_FLAG',
2174: 'MTL_SYSTEM_ITEMS_INTERFACE',
2175: 'INV_OUTSIDE_OP_UNIT',
2176: err_text);
2177: if dumm_status < 0 then
2178: raise LOGGING_ERR;

Line 2215: 'MTL_SYSTEM_ITEMS_INTERFACE',

2211: request_id,
2212: cr.TRANSACTION_ID,
2213: error_msg,
2214: 'SOURCE_ORGANIZATION_ID',
2215: 'MTL_SYSTEM_ITEMS_INTERFACE',
2216: 'INV_ITEM_IN_SOURCE_ORG',
2217: err_text);
2218: if dumm_status < 0 then
2219: raise LOGGING_ERR;

Line 2243: 'MTL_SYSTEM_ITEMS_INTERFACE',

2239: request_id,
2240: cr.TRANSACTION_ID,
2241: error_msg,
2242: 'SOURCE_ORGANIZATION_ID',
2243: 'MTL_SYSTEM_ITEMS_INTERFACE',
2244: 'INV_INTERORG_NTWK',
2245: err_text);
2246: if dumm_status < 0 then
2247: raise LOGGING_ERR;

Line 2274: 'MTL_SYSTEM_ITEMS_INTERFACE',

2270: request_id,
2271: cr.TRANSACTION_ID,
2272: error_msg,
2273: 'SOURCE_ORGANIZATION_ID',
2274: 'MTL_SYSTEM_ITEMS_INTERFACE',
2275: 'INV_INTRAORG_SOURCE',
2276: err_text);
2277: if dumm_status < 0 then
2278: raise LOGGING_ERR;

Line 2305: 'MTL_SYSTEM_ITEMS_INTERFACE',

2301: request_id,
2302: cr.TRANSACTION_ID,
2303: error_msg,
2304: 'SOURCE_TYPE',
2305: 'MTL_SYSTEM_ITEMS_INTERFACE',
2306: 'INV_SOURCE_ORG_MUST_BE_NULL',
2307: err_text);
2308: if dumm_status < 0 then
2309: raise LOGGING_ERR;

Line 2330: 'MTL_SYSTEM_ITEMS_INTERFACE',

2326: request_id,
2327: cr.TRANSACTION_ID,
2328: error_msg,
2329: 'MINIMUM_ORDER_QUANTITY',
2330: 'MTL_SYSTEM_ITEMS_INTERFACE',
2331: 'INV_IOI_MIN_ORD_QTY',
2332: err_text);
2333: if dumm_status < 0 then
2334: raise LOGGING_ERR;

Line 2354: 'MTL_SYSTEM_ITEMS_INTERFACE',

2350: request_id,
2351: cr.TRANSACTION_ID,
2352: error_msg,
2353: 'MAXIMUM_ORDER_QUANTITY',
2354: 'MTL_SYSTEM_ITEMS_INTERFACE',
2355: 'INV_IOI_MAX_ORD_QTY',
2356: err_text);
2357: if dumm_status < 0 then
2358: raise LOGGING_ERR;

Line 2377: 'MTL_SYSTEM_ITEMS_INTERFACE',

2373: request_id,
2374: cr.TRANSACTION_ID,
2375: error_msg,
2376: 'MIN_MINMAX_QUANTITY',
2377: 'MTL_SYSTEM_ITEMS_INTERFACE',
2378: 'INV_IOI_MINMAX_MIN',
2379: err_text);
2380: if dumm_status < 0 then
2381: raise LOGGING_ERR;

Line 2398: 'MTL_SYSTEM_ITEMS_INTERFACE',

2394: request_id,
2395: cr.TRANSACTION_ID,
2396: error_msg,
2397: 'MAX_MINMAX_QUANTITY',
2398: 'MTL_SYSTEM_ITEMS_INTERFACE',
2399: 'INV_IOI_MINMAX_MAX',
2400: err_text);
2401: if dumm_status < 0 then
2402: raise LOGGING_ERR;

Line 2420: 'MTL_SYSTEM_ITEMS_INTERFACE',

2416: request_id,
2417: cr.TRANSACTION_ID,
2418: error_msg,
2419: 'CHECK_SHORTAGES_FLAG',
2420: 'MTL_SYSTEM_ITEMS_INTERFACE',
2421: 'INV_ENABLE_SHORT_CHECK',
2422: err_text);
2423: if dumm_status < 0 then
2424: raise LOGGING_ERR;

Line 2440: 'MTL_SYSTEM_ITEMS_INTERFACE',

2436: request_id,
2437: cr.TRANSACTION_ID,
2438: error_msg,
2439: 'CONTRACT_ITEM_TYPE_CODE',
2440: 'MTL_SYSTEM_ITEMS_INTERFACE',
2441: 'INV_CUSTOMER_CONTRACT',
2442: err_text);
2443: if dumm_status < 0 then
2444: raise LOGGING_ERR;

Line 2467: 'MTL_SYSTEM_ITEMS_INTERFACE',

2463: request_id,
2464: cr.TRANSACTION_ID,
2465: error_msg,
2466: 'WEIGHT_UOM_CODE',
2467: 'MTL_SYSTEM_ITEMS_INTERFACE',
2468: 'INV_IOI_WEIGHT_UOM_CODE',
2469: err_text);
2470: IF dumm_status < 0 THEN
2471: raise LOGGING_ERR;

Line 2509: 'MTL_SYSTEM_ITEMS_INTERFACE',

2505: request_id,
2506: cr.TRANSACTION_ID,
2507: error_msg,
2508: l_col_name,
2509: 'MTL_SYSTEM_ITEMS_INTERFACE',
2510: l_msg_name,
2511: err_text );
2512: IF dumm_status < 0 THEN
2513: raise LOGGING_ERR;

Line 2537: update MTL_SYSTEM_ITEMS_INTERFACE

2533: ** INVPVDR2.sql thru INVPVDR6.sql
2534: */
2535:
2536: --R12C WHERE clause changed to ROWID
2537: update MTL_SYSTEM_ITEMS_INTERFACE
2538: set process_flag = DECODE(status,0,41,31),
2539: PRIMARY_UOM_CODE = cr.primary_uom_code,
2540: primary_unit_of_measure = cr.primary_unit_of_measure
2541: where rowid = cr.rowid;

Line 2561: 'MTL_SYSTEM_ITEMS_INTERFACE',

2557: request_id,
2558: trans_id,
2559: err_text,
2560: 'validation_error ' || stmt,
2561: 'MTL_SYSTEM_ITEMS_INTERFACE',
2562: 'BOM_OP_VALIDATION_ERR',
2563: err_text);
2564: return(status);
2565: when OTHERS then