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 285: from MTL_SYSTEM_ITEMS_INTERFACE

281: DIMENSION_UOM_CODE,
282: UNIT_LENGTH,
283: UNIT_WIDTH,
284: UNIT_HEIGHT
285: from MTL_SYSTEM_ITEMS_INTERFACE
286: where ((organization_id = org_id) or -- fix for bug#8757041,removed + 0
287: (all_Org = 1))
288: and set_process_id = xset_id
289: and process_flag = 2;

Line 324: ** from MTL_SYSTEM_ITEMS_INTERFACE

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

Line 410: l_item_number mtl_system_items_interface.item_number%TYPE;

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

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

521: /*
522: ** End section for dynamic sql bind variables
523: */
524:
525: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';
526:
527: /*
528: ** validate the records
529: */

Line 545: from mtl_system_items_interface

541:
542: /* Bug 4705184. Get item id from the cursor. At this point there is no change in item id.
543: select inventory_item_id
544: into l_item_id
545: from mtl_system_items_interface
546: where transaction_id = cr.transaction_id
547: and set_process_id = xset_id ; */
548:
549: /* Put in the values of cr.segmentX in the right

Line 634: ,'MTL_SYSTEM_ITEMS_INTERFACE'

630: ,request_id
631: ,cr.transaction_id
632: ,error_msg
633: ,null
634: ,'MTL_SYSTEM_ITEMS_INTERFACE'
635: ,'BOM_PARSE_ITEM_ERROR'
636: ,err_text);
637: if dumm_status < 0 then
638: raise LOGGING_ERR;

Line 684: 'MTL_SYSTEM_ITEMS_INTERFACE',

680: request_id,
681: cr.TRANSACTION_ID,
682: substr(FND_FLEX_KEYVAL.error_message,1,239),
683: 'ITEM_NUMBER',
684: 'MTL_SYSTEM_ITEMS_INTERFACE',
685: 'INV_IOI_ERR_SEG_FFK_CK_FAIL',--bug 11894684, replace INV_IOI_ERR
686: err_text);
687: if dumm_status < 0 then
688: raise LOGGING_ERR;

Line 713: 'MTL_SYSTEM_ITEMS_INTERFACE',

709: request_id,
710: cr.TRANSACTION_ID,
711: error_msg,
712: 'ITEM_NUMBER',
713: 'MTL_SYSTEM_ITEMS_INTERFACE',
714: 'INV_IOI_ERR_ITM_SGMS_INVALID',--bug 11894684, replace INV_IOI_ERR
715: err_text);
716: if dumm_status < 0 then
717: raise LOGGING_ERR;

Line 843: update mtl_system_items_interface

839: dbms_sql.column_value(DSQL_c1,1,DSQL_inventory_item_id);
840:
841: dup_item_id := DSQL_inventory_item_id;
842:
843: update mtl_system_items_interface
844: set inventory_item_id = dup_item_id
845: where transaction_id = cr.transaction_id
846: and set_process_id = xset_id;
847:

Line 887: from mtl_system_items_interface msii,

883: and clause of organization_id to fix bug 7459820 with base bug 7003119 */
884: DSQL_statement2 := ' select msii.inventory_item_id,
885: msii.transaction_id,
886: msii.organization_id
887: from mtl_system_items_interface msii,
888: mtl_parameters mp
889: where msii.inventory_item_id <>
890: :l_item_id_bind
891: and set_process_id = :xset_id_bind

Line 945: update mtl_system_items_interface

941: IF l_inv_debug_level IN(101, 102) THEN
942: INVPUTLI.info('INVPVHDR: Same item being added to MULTIPLE masters ');
943: INVPUTLI.info('INVPVHDR: So now updating inv_item_id in MSII, MIRI ');
944: END IF;
945: update mtl_system_items_interface
946: set inventory_item_id = l_item_id
947: where transaction_id = DSQL2_transaction_id
948: and set_process_id = xset_id;
949:

Line 1072: 'MTL_SYSTEM_ITEMS_INTERFACE',

1068: request_id,
1069: cr.TRANSACTION_ID,
1070: error_msg,
1071: 'INVENTORY_ITEM_ID',
1072: 'MTL_SYSTEM_ITEMS_INTERFACE',
1073: 'INV_IOI_ERR_DPLC_ITEM_MSI',--bug 11894684, replace INV_IOI_ERR
1074: err_text);
1075: if dumm_status < 0 then
1076: raise LOGGING_ERR;

Line 1082: from MTL_SYSTEM_ITEMS_INTERFACE

1078: else
1079: stmt := 4;
1080: select count(*)
1081: into ext_flag
1082: from MTL_SYSTEM_ITEMS_INTERFACE
1083: where inventory_item_id = l_item_id
1084: and organization_id = cr.organization_id
1085: and process_flag = 2
1086: and set_process_id = xset_id;

Line 1121: 'MTL_SYSTEM_ITEMS_INTERFACE',

1117: request_id,
1118: cr.TRANSACTION_ID,
1119: error_msg,
1120: 'INVENTORY_ITEM_ID',
1121: 'MTL_SYSTEM_ITEMS_INTERFACE',
1122: 'INV_IOI_ERR_DPLC_REC_MSII_01',--bug 11894684, replace INV_IOI_ERR
1123: err_text);
1124: if dumm_status < 0 then
1125: raise LOGGING_ERR;

Line 1236: 'MTL_SYSTEM_ITEMS_INTERFACE',

1232: request_id,
1233: cr.TRANSACTION_ID,
1234: error_msg,
1235: 'SEGMENTS',
1236: 'MTL_SYSTEM_ITEMS_INTERFACE',
1237: 'INV_IOI_ERR_DPLC_ITM_MSI',--bug 11894684, replace INV_IOI_ERR
1238: err_text);
1239: /*NP 08-APR-96 Changed the table to
1240: **be msi instead of MSI_intf

Line 1254: **from MTL_SYSTEM_ITEMS_INTERFACE msii

1250: /*
1251: ** Changing following stmt to dynamic sql
1252: **select count(*)
1253: **into ext_flag
1254: **from MTL_SYSTEM_ITEMS_INTERFACE msii
1255: **where organization_id = cr.organization_id
1256: **and nvl(msii.segment1, '.') = nvl(cr.segment1,'.');
1257: **and so on......
1258: ** intermediate step: ...... = nvl(:cr_segment1_bind, '.')

Line 1267: from MTL_SYSTEM_ITEMS_INTERFACE msii

1263:
1264: --Bug 8520379: the select is for duplication check, so doesn't need to select count(*) for performance sake
1265: --DSQL_statement4 := 'select count(*)
1266: DSQL_statement4 := 'select 1
1267: from MTL_SYSTEM_ITEMS_INTERFACE msii
1268: where organization_id = :organization_id_bind
1269: and set_process_id = :xset_id_bind
1270: and process_flag = 2
1271: and ' || statement_temp4;

Line 1371: 'MTL_SYSTEM_ITEMS_INTERFACE',

1367: request_id,
1368: cr.TRANSACTION_ID,
1369: error_msg,
1370: 'SEGMENTS',
1371: 'MTL_SYSTEM_ITEMS_INTERFACE',
1372: 'INV_IOI_ERR_DPLC_REC_MSII_02',--bug 11894684, replace INV_IOI_ERR
1373: err_text);
1374: if dumm_status < 0 then
1375: raise LOGGING_ERR;

Line 1394: 'MTL_SYSTEM_ITEMS_INTERFACE',

1390: request_id,
1391: cr.TRANSACTION_ID,
1392: error_msg,
1393: 'DESCRIPTION',
1394: 'MTL_SYSTEM_ITEMS_INTERFACE',
1395: 'INV_DESC_NULL_ITEM_ERROR',
1396: err_text);
1397: status := 1;
1398: if dumm_status < 0 then

Line 1416: 'MTL_SYSTEM_ITEMS_INTERFACE',

1412: request_id,
1413: cr.TRANSACTION_ID,
1414: error_msg,
1415: 'DESCRIPTION',
1416: 'MTL_SYSTEM_ITEMS_INTERFACE',
1417: 'INV_DESC_ITEM_ERROR',
1418: err_text);
1419: status := 1;
1420: if dumm_status < 0 then

Line 1451: 'MTL_SYSTEM_ITEMS_INTERFACE',

1447: request_id,
1448: cr.TRANSACTION_ID,
1449: error_msg,
1450: 'UOM_PROFILE',
1451: 'MTL_SYSTEM_ITEMS_INTERFACE',
1452: 'INV_INVALID_PRIMARY_UOM',
1453: err_text);
1454: status := 1;
1455: if dumm_status < 0 then

Line 1474: 'MTL_SYSTEM_ITEMS_INTERFACE',

1470: request_id,
1471: cr.TRANSACTION_ID,
1472: error_msg,
1473: 'SHIPPABLE_ITEM_FLAG',
1474: 'MTL_SYSTEM_ITEMS_INTERFACE',
1475: 'INV_SHIP_INT_YES',
1476: err_text);
1477: status := 1;
1478: if dumm_status < 0 then

Line 1496: 'MTL_SYSTEM_ITEMS_INTERFACE',

1492: request_id,
1493: cr.TRANSACTION_ID,
1494: error_msg,
1495: 'BOM_ITEM_TYPE',
1496: 'MTL_SYSTEM_ITEMS_INTERFACE',
1497: 'INV_CUSTOMER',
1498: err_text);
1499: status := 1;
1500: if dumm_status < 0 then

Line 1517: 'MTL_SYSTEM_ITEMS_INTERFACE',

1513: request_id,
1514: cr.TRANSACTION_ID,
1515: error_msg,
1516: 'BOM_ITEM_TYPE',
1517: 'MTL_SYSTEM_ITEMS_INTERFACE',
1518: 'INV_CUSTOMER',
1519: err_text);
1520: status := 1;
1521: if dumm_status < 0 then

Line 1536: 'MTL_SYSTEM_ITEMS_INTERFACE',

1532: request_id,
1533: cr.TRANSACTION_ID,
1534: error_msg,
1535: 'SHIPPABLE_ITEM_FLAG',
1536: 'MTL_SYSTEM_ITEMS_INTERFACE',
1537: 'INV_SHIPPABLE',
1538: err_text);
1539: status := 1;
1540: if dumm_status < 0 then

Line 1558: 'MTL_SYSTEM_ITEMS_INTERFACE',

1554: request_id,
1555: cr.TRANSACTION_ID,
1556: error_msg,
1557: 'BOM_ITEM_TYPE',
1558: 'MTL_SYSTEM_ITEMS_INTERFACE',
1559: 'INV_IOI_PLANNING_DEP',
1560: err_text);
1561: status := 1;
1562: if dumm_status < 0 then

Line 1580: 'MTL_SYSTEM_ITEMS_INTERFACE',

1576: request_id,
1577: cr.TRANSACTION_ID,
1578: error_msg,
1579: 'BOM_ITEM_TYPE',
1580: 'MTL_SYSTEM_ITEMS_INTERFACE',
1581: 'INV_IOI_BOM_STANDARD',
1582: err_text);
1583: status := 1;
1584: if dumm_status < 0 then

Line 1608: 'MTL_SYSTEM_ITEMS_INTERFACE',

1604: request_id,
1605: cr.TRANSACTION_ID,
1606: error_msg,
1607: 'INTERNAL_ORDER_FLAG',
1608: 'MTL_SYSTEM_ITEMS_INTERFACE',
1609: -- 'INV_INTERNAL',
1610: l_msg_name,
1611: err_text);
1612: status := 1;

Line 1632: 'MTL_SYSTEM_ITEMS_INTERFACE',

1628: request_id,
1629: cr.TRANSACTION_ID,
1630: error_msg,
1631: 'STOCK_ENABLED_FLAG',
1632: 'MTL_SYSTEM_ITEMS_INTERFACE',
1633: 'INV_STOCKABLE',
1634: err_text);
1635: if dumm_status < 0 then
1636: raise LOGGING_ERR;

Line 1661: 'MTL_SYSTEM_ITEMS_INTERFACE',

1657: request_id,
1658: cr.TRANSACTION_ID,
1659: error_msg,
1660: 'INVENTORY_ITEM_FLAG',
1661: 'MTL_SYSTEM_ITEMS_INTERFACE',
1662: -- 'INV_ITM_SERVICE_ITM',
1663: 'INV_NO_INVENTORY_ITEM',
1664: err_text);
1665: if dumm_status < 0 then

Line 1693: 'MTL_SYSTEM_ITEMS_INTERFACE',

1689: request_id,
1690: cr.TRANSACTION_ID,
1691: error_msg,
1692: 'INVENTORY_ITEM_FLAG',
1693: 'MTL_SYSTEM_ITEMS_INTERFACE',
1694: 'INV_BOM_ENABLED1',
1695: err_text);
1696: if dumm_status < 0 then
1697: raise LOGGING_ERR;

Line 1715: 'MTL_SYSTEM_ITEMS_INTERFACE',

1711: request_id,
1712: cr.TRANSACTION_ID,
1713: error_msg,
1714: 'INVENTORY_ITEM_FLAG',
1715: 'MTL_SYSTEM_ITEMS_INTERFACE',
1716: 'INV_BUILD_WIP_NO',
1717: err_text);
1718: if dumm_status < 0 then
1719: raise LOGGING_ERR;

Line 1737: 'MTL_SYSTEM_ITEMS_INTERFACE',

1733: request_id,
1734: cr.TRANSACTION_ID,
1735: error_msg,
1736: 'PURCHASING_ITEM_FLAG',
1737: 'MTL_SYSTEM_ITEMS_INTERFACE',
1738: 'INV_PO_ENABLED',
1739: err_text);
1740: if dumm_status < 0 then
1741: raise LOGGING_ERR;

Line 1759: 'MTL_SYSTEM_ITEMS_INTERFACE',

1755: request_id,
1756: cr.TRANSACTION_ID,
1757: error_msg,
1758: 'CUSTOMER_ORDER_FLAG',
1759: 'MTL_SYSTEM_ITEMS_INTERFACE',
1760: 'INV_CUSTOMER_ENABLED',
1761: err_text);
1762: if dumm_status < 0 then
1763: raise LOGGING_ERR;

Line 1781: 'MTL_SYSTEM_ITEMS_INTERFACE',

1777: request_id,
1778: cr.TRANSACTION_ID,
1779: error_msg,
1780: 'INVOICEABLE_ITEM_FLAG',
1781: 'MTL_SYSTEM_ITEMS_INTERFACE',
1782: 'INV_INVOICE_ENABLED',
1783: err_text);
1784: if dumm_status < 0 then
1785: raise LOGGING_ERR;

Line 1803: 'MTL_SYSTEM_ITEMS_INTERFACE',

1799: request_id,
1800: cr.TRANSACTION_ID,
1801: error_msg,
1802: 'SERVICE_ITEM_FLAG',
1803: 'MTL_SYSTEM_ITEMS_INTERFACE',
1804: 'BOM_OP_VALIDATION_ERR',
1805: err_text);
1806: if dumm_status < 0 then
1807: raise LOGGING_ERR;

Line 1826: 'MTL_SYSTEM_ITEMS_INTERFACE',

1822: cr.TRANSACTION_ID,
1823: error_msg,
1824: -- 'SERVICE_ITEM_FLAG',
1825: 'CONTRACT_ITEM_TYPE_CODE',
1826: 'MTL_SYSTEM_ITEMS_INTERFACE',
1827: -- 'INV_SERVICE',
1828: 'INV_SERVICEABLE_CONTRACT',
1829: err_text);
1830: if dumm_status < 0 then

Line 1860: 'MTL_SYSTEM_ITEMS_INTERFACE',

1856: cr.TRANSACTION_ID,
1857: error_msg,
1858: -- 'SERVICE_ITEM_FLAG',
1859: 'CONTRACT_ITEM_TYPE_CODE',
1860: 'MTL_SYSTEM_ITEMS_INTERFACE',
1861: 'INV_SERVICE1',
1862: err_text);
1863: if dumm_status < 0 then
1864: raise LOGGING_ERR;

Line 1894: 'MTL_SYSTEM_ITEMS_INTERFACE',

1890: cr.TRANSACTION_ID,
1891: error_msg,
1892: -- 'SERVICE_ITEM_FLAG',
1893: 'CONTRACT_ITEM_TYPE_CODE',
1894: 'MTL_SYSTEM_ITEMS_INTERFACE',
1895: 'INV_SERVICE2',
1896: err_text);
1897: if dumm_status < 0 then
1898: raise LOGGING_ERR;

Line 1925: 'MTL_SYSTEM_ITEMS_INTERFACE',

1921: cr.TRANSACTION_ID,
1922: error_msg,
1923: -- 'SERVICE_ITEM_FLAG',
1924: 'CONTRACT_ITEM_TYPE_CODE',
1925: 'MTL_SYSTEM_ITEMS_INTERFACE',
1926: -- 'INV_SERVICE3',
1927: 'INV_SER_DURATION_MAND',
1928: err_text);
1929: if dumm_status < 0 then

Line 1949: 'MTL_SYSTEM_ITEMS_INTERFACE',

1945: request_id,
1946: cr.TRANSACTION_ID,
1947: error_msg,
1948: 'SERVICEABLE_PRODUCT_FLAG',
1949: 'MTL_SYSTEM_ITEMS_INTERFACE',
1950: 'INV_SERVICE_PROD_FL',
1951: err_text);
1952: if dumm_status < 0 then
1953: raise LOGGING_ERR;

Line 1972: 'MTL_SYSTEM_ITEMS_INTERFACE',

1968: request_id,
1969: cr.TRANSACTION_ID,
1970: error_msg,
1971: 'PICK_COMPONENTS_FLAG',
1972: 'MTL_SYSTEM_ITEMS_INTERFACE',
1973: 'INV_IOI_PICK_DEP',
1974: err_text);
1975: if dumm_status < 0 then
1976: raise LOGGING_ERR;

Line 1991: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 2015: 'MTL_SYSTEM_ITEMS_INTERFACE',

2011: request_id,
2012: cr.TRANSACTION_ID,
2013: error_msg,
2014: 'REPLENISH_TO_ORDER',
2015: 'MTL_SYSTEM_ITEMS_INTERFACE',
2016: 'INV_IOI_REPL_TO_ORDER_DEP',
2017: err_text);
2018: if dumm_status < 0 then
2019: raise LOGGING_ERR;

Line 2045: 'MTL_SYSTEM_ITEMS_INTERFACE',

2041: request_id,
2042: cr.TRANSACTION_ID,
2043: error_msg,
2044: 'LOT_CONTROL_CODE',
2045: 'MTL_SYSTEM_ITEMS_INTERFACE',
2046: 'INV_AUTO_LOT_PREFIX',
2047: err_text);
2048: if dumm_status < 0 then
2049: raise LOGGING_ERR;

Line 2082: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 2106: 'MTL_SYSTEM_ITEMS_INTERFACE',

2102: request_id,
2103: cr.TRANSACTION_ID,
2104: error_msg,
2105: 'LOT_CONTROL_CODE',
2106: 'MTL_SYSTEM_ITEMS_INTERFACE',
2107: 'INV_START_LOT_NUM',
2108: err_text);
2109: if dumm_status < 0 then
2110: raise LOGGING_ERR;

Line 2135: 'MTL_SYSTEM_ITEMS_INTERFACE',

2131: request_id,
2132: cr.TRANSACTION_ID,
2133: error_msg,
2134: 'SERIAL_NUMBER_CONTROL_CODE',
2135: 'MTL_SYSTEM_ITEMS_INTERFACE',
2136: 'INV_START_SERIAL_NUM',
2137: err_text);
2138: if dumm_status < 0 then
2139: raise LOGGING_ERR;

Line 2164: 'MTL_SYSTEM_ITEMS_INTERFACE',

2160: request_id,
2161: cr.TRANSACTION_ID,
2162: error_msg,
2163: 'SERIAL_NUMBER_CONTROL_CODE',
2164: 'MTL_SYSTEM_ITEMS_INTERFACE',
2165: 'INV_AUTO_SERIAL_PREFIX',
2166: err_text);
2167: if dumm_status < 0 then
2168: raise LOGGING_ERR;

Line 2186: 'MTL_SYSTEM_ITEMS_INTERFACE',

2182: request_id,
2183: cr.TRANSACTION_ID,
2184: error_msg,
2185: 'SHELF_LIFE_CODE',
2186: 'MTL_SYSTEM_ITEMS_INTERFACE',
2187: 'INV_SHELF_DAYS_MAND',
2188: err_text);
2189: if dumm_status < 0 then
2190: raise LOGGING_ERR;

Line 2208: 'MTL_SYSTEM_ITEMS_INTERFACE',

2204: request_id,
2205: cr.TRANSACTION_ID,
2206: error_msg,
2207: 'OUTSIDE_OPERATION_FLAG',
2208: 'MTL_SYSTEM_ITEMS_INTERFACE',
2209: 'INV_IOI_OUT_OP_FLAG_DEP',
2210: err_text);
2211: if dumm_status < 0 then
2212: raise LOGGING_ERR;

Line 2227: 'MTL_SYSTEM_ITEMS_INTERFACE',

2223: request_id,
2224: cr.TRANSACTION_ID,
2225: error_msg,
2226: 'OUTSIDE_OPERATION_FLAG',
2227: 'MTL_SYSTEM_ITEMS_INTERFACE',
2228: 'INV_OUTSIDE_OP_UNIT',
2229: err_text);
2230: if dumm_status < 0 then
2231: raise LOGGING_ERR;

Line 2268: 'MTL_SYSTEM_ITEMS_INTERFACE',

2264: request_id,
2265: cr.TRANSACTION_ID,
2266: error_msg,
2267: 'SOURCE_ORGANIZATION_ID',
2268: 'MTL_SYSTEM_ITEMS_INTERFACE',
2269: 'INV_ITEM_IN_SOURCE_ORG',
2270: err_text);
2271: if dumm_status < 0 then
2272: raise LOGGING_ERR;

Line 2296: 'MTL_SYSTEM_ITEMS_INTERFACE',

2292: request_id,
2293: cr.TRANSACTION_ID,
2294: error_msg,
2295: 'SOURCE_ORGANIZATION_ID',
2296: 'MTL_SYSTEM_ITEMS_INTERFACE',
2297: 'INV_INTERORG_NTWK',
2298: err_text);
2299: if dumm_status < 0 then
2300: raise LOGGING_ERR;

Line 2327: 'MTL_SYSTEM_ITEMS_INTERFACE',

2323: request_id,
2324: cr.TRANSACTION_ID,
2325: error_msg,
2326: 'SOURCE_ORGANIZATION_ID',
2327: 'MTL_SYSTEM_ITEMS_INTERFACE',
2328: 'INV_INTRAORG_SOURCE',
2329: err_text);
2330: if dumm_status < 0 then
2331: raise LOGGING_ERR;

Line 2358: 'MTL_SYSTEM_ITEMS_INTERFACE',

2354: request_id,
2355: cr.TRANSACTION_ID,
2356: error_msg,
2357: 'SOURCE_TYPE',
2358: 'MTL_SYSTEM_ITEMS_INTERFACE',
2359: 'INV_SOURCE_ORG_MUST_BE_NULL',
2360: err_text);
2361: if dumm_status < 0 then
2362: raise LOGGING_ERR;

Line 2383: 'MTL_SYSTEM_ITEMS_INTERFACE',

2379: request_id,
2380: cr.TRANSACTION_ID,
2381: error_msg,
2382: 'MINIMUM_ORDER_QUANTITY',
2383: 'MTL_SYSTEM_ITEMS_INTERFACE',
2384: 'INV_IOI_MIN_ORD_QTY',
2385: err_text);
2386: if dumm_status < 0 then
2387: raise LOGGING_ERR;

Line 2407: 'MTL_SYSTEM_ITEMS_INTERFACE',

2403: request_id,
2404: cr.TRANSACTION_ID,
2405: error_msg,
2406: 'MAXIMUM_ORDER_QUANTITY',
2407: 'MTL_SYSTEM_ITEMS_INTERFACE',
2408: 'INV_IOI_MAX_ORD_QTY',
2409: err_text);
2410: if dumm_status < 0 then
2411: raise LOGGING_ERR;

Line 2430: 'MTL_SYSTEM_ITEMS_INTERFACE',

2426: request_id,
2427: cr.TRANSACTION_ID,
2428: error_msg,
2429: 'MIN_MINMAX_QUANTITY',
2430: 'MTL_SYSTEM_ITEMS_INTERFACE',
2431: 'INV_IOI_MINMAX_MIN',
2432: err_text);
2433: if dumm_status < 0 then
2434: raise LOGGING_ERR;

Line 2451: 'MTL_SYSTEM_ITEMS_INTERFACE',

2447: request_id,
2448: cr.TRANSACTION_ID,
2449: error_msg,
2450: 'MAX_MINMAX_QUANTITY',
2451: 'MTL_SYSTEM_ITEMS_INTERFACE',
2452: 'INV_IOI_MINMAX_MAX',
2453: err_text);
2454: if dumm_status < 0 then
2455: raise LOGGING_ERR;

Line 2473: 'MTL_SYSTEM_ITEMS_INTERFACE',

2469: request_id,
2470: cr.TRANSACTION_ID,
2471: error_msg,
2472: 'CHECK_SHORTAGES_FLAG',
2473: 'MTL_SYSTEM_ITEMS_INTERFACE',
2474: 'INV_ENABLE_SHORT_CHECK',
2475: err_text);
2476: if dumm_status < 0 then
2477: raise LOGGING_ERR;

Line 2493: 'MTL_SYSTEM_ITEMS_INTERFACE',

2489: request_id,
2490: cr.TRANSACTION_ID,
2491: error_msg,
2492: 'CONTRACT_ITEM_TYPE_CODE',
2493: 'MTL_SYSTEM_ITEMS_INTERFACE',
2494: 'INV_CUSTOMER_CONTRACT',
2495: err_text);
2496: if dumm_status < 0 then
2497: raise LOGGING_ERR;

Line 2520: 'MTL_SYSTEM_ITEMS_INTERFACE',

2516: request_id,
2517: cr.TRANSACTION_ID,
2518: error_msg,
2519: 'WEIGHT_UOM_CODE',
2520: 'MTL_SYSTEM_ITEMS_INTERFACE',
2521: 'INV_IOI_WEIGHT_UOM_CODE',
2522: err_text);
2523: IF dumm_status < 0 THEN
2524: raise LOGGING_ERR;

Line 2562: 'MTL_SYSTEM_ITEMS_INTERFACE',

2558: request_id,
2559: cr.TRANSACTION_ID,
2560: error_msg,
2561: l_col_name,
2562: 'MTL_SYSTEM_ITEMS_INTERFACE',
2563: l_msg_name,
2564: err_text );
2565: IF dumm_status < 0 THEN
2566: raise LOGGING_ERR;

Line 2590: update MTL_SYSTEM_ITEMS_INTERFACE

2586: ** INVPVDR2.sql thru INVPVDR6.sql
2587: */
2588:
2589: --R12C WHERE clause changed to ROWID
2590: update MTL_SYSTEM_ITEMS_INTERFACE
2591: set process_flag = DECODE(status,0,41,31),
2592: PRIMARY_UOM_CODE = cr.primary_uom_code,
2593: primary_unit_of_measure = cr.primary_unit_of_measure
2594: where rowid = cr.rowid;

Line 2614: 'MTL_SYSTEM_ITEMS_INTERFACE',

2610: request_id,
2611: trans_id,
2612: err_text,
2613: 'validation_error ' || stmt,
2614: 'MTL_SYSTEM_ITEMS_INTERFACE',
2615: 'BOM_OP_VALIDATION_ERR',
2616: err_text);
2617: return(status);
2618: when OTHERS then