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.INVPVDR5 dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 313: from MTL_SYSTEM_ITEMS_INTERFACE

309: , DUAL_UOM_DEVIATION_HIGH
310: , DUAL_UOM_DEVIATION_LOW
311: , CONTRACT_ITEM_TYPE_CODE
312: , RECOVERED_PART_DISP_CODE
313: from MTL_SYSTEM_ITEMS_INTERFACE
314: -- Replacing organization_id + 0 with organization_id - Anmurali - Bug 4175124
315: where ((organization_id = org_id) or
316: (all_Org = 1))
317: and set_process_id = xset_id

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

401: l_prev_org_id NUMBER := -1; -- Bug: 4654433
402:
403: begin
404:
405: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';
406:
407:
408: -- validate the records
409:

Line 431: from mtl_system_items_interface

427: */
428: /* Bug: 4654433 Commneting out the following code
429: select inventory_item_id
430: into l_item_id
431: from mtl_system_items_interface
432: where transaction_id = cr.transaction_id
433: and set_process_id = xset_id;
434: */
435: -- Validate first group of foreign keys

Line 452: -- If an organization in mtl_system_items_interface does not exist in

448: ** cost_of_sales_account, sales_account, expense_account and encumbrance_account
449: */
450:
451: -- Bug fix # 3742121
452: -- If an organization in mtl_system_items_interface does not exist in
453: -- org_organization_definitions, error message is logged.
454: --Bug: 4654433 Query chart_of_accounts_id only if organization_id has changed
455: if l_org_id <> l_prev_org_id then
456: begin

Line 479: 'MTL_SYSTEM_ITEMS_INTERFACE',

475: request_id,
476: cr.TRANSACTION_ID,
477: l_msg_text,
478: 'ORGANIZATION_ID',
479: 'MTL_SYSTEM_ITEMS_INTERFACE',
480: 'INV_IOI_INVALID_ORG',
481: err_text);
482: if dumm_status < 0 then
483: raise LOGGING_ERR;

Line 516: 'MTL_SYSTEM_ITEMS_INTERFACE',

512: request_id,
513: cr.TRANSACTION_ID,
514: l_msg_text,
515: 'COST_OF_SALES_ACCOUNT',
516: 'MTL_SYSTEM_ITEMS_INTERFACE',
517: 'INV_IOI_ERR',
518: err_text);
519: if dumm_status < 0 then
520: raise LOGGING_ERR;

Line 553: 'MTL_SYSTEM_ITEMS_INTERFACE',

549: request_id,
550: cr.TRANSACTION_ID,
551: l_msg_text,
552: 'SALES_ACCOUNT',
553: 'MTL_SYSTEM_ITEMS_INTERFACE',
554: 'INV_IOI_ERR',
555: err_text);
556: if dumm_status < 0 then
557: raise LOGGING_ERR;

Line 590: 'MTL_SYSTEM_ITEMS_INTERFACE',

586: request_id,
587: cr.TRANSACTION_ID,
588: l_msg_text,
589: 'EXPENSE_ACCOUNT',
590: 'MTL_SYSTEM_ITEMS_INTERFACE',
591: 'INV_IOI_ERR',
592: err_text);
593: if dumm_status < 0 then
594: raise LOGGING_ERR;

Line 627: 'MTL_SYSTEM_ITEMS_INTERFACE',

623: request_id,
624: cr.TRANSACTION_ID,
625: l_msg_text,
626: 'ENCUMBRANCE_ACCOUNT',
627: 'MTL_SYSTEM_ITEMS_INTERFACE',
628: 'INV_IOI_ERR',
629: err_text);
630: if dumm_status < 0 then
631: raise LOGGING_ERR;

Line 649: 'MTL_SYSTEM_ITEMS_INTERFACE',

645: request_id,
646: cr.TRANSACTION_ID,
647: error_msg,
648: 'MATERIAL_BILLABLE_FLAG',
649: 'MTL_SYSTEM_ITEMS_INTERFACE',
650: 'INV_MATERIAL_BILLABLE_NON_TXN',
651: err_text);
652: if dumm_status < 0 then
653: raise LOGGING_ERR;

Line 670: 'MTL_SYSTEM_ITEMS_INTERFACE',

666: request_id,
667: cr.TRANSACTION_ID,
668: error_msg,
669: 'MATERIAL_BILLABLE_FLAG',
670: 'MTL_SYSTEM_ITEMS_INTERFACE',
671: 'INV_REC_PART_BIILLING_TYPE',
672: err_text);
673: if dumm_status < 0 then
674: raise LOGGING_ERR;

Line 691: 'MTL_SYSTEM_ITEMS_INTERFACE',

687: request_id,
688: cr.TRANSACTION_ID,
689: error_msg,
690: 'MATERIAL_BILLABLE_FLAG',
691: 'MTL_SYSTEM_ITEMS_INTERFACE',
692: 'INV_SERV_BILLING_MATERIAL_DEP',
693: err_text);
694: if dumm_status < 0 then
695: raise LOGGING_ERR;

Line 718: 'MTL_SYSTEM_ITEMS_INTERFACE',

714: request_id,
715: cr.TRANSACTION_ID,
716: error_msg,
717: 'PICKING_RULE_ID',
718: 'MTL_SYSTEM_ITEMS_INTERFACE',
719: 'INV_IOI_PICKING_RULE',
720: err_text);
721: if dumm_status < 0 then
722: raise LOGGING_ERR;

Line 748: 'MTL_SYSTEM_ITEMS_INTERFACE',

744: request_id,
745: cr.TRANSACTION_ID,
746: error_msg,
747: 'INVENTORY_ITEM_STATUS_CODE',
748: 'MTL_SYSTEM_ITEMS_INTERFACE',
749: 'INV_IOI_STATUS_CODE',
750: err_text);
751: if dumm_status < 0 then
752: raise LOGGING_ERR;

Line 778: 'MTL_SYSTEM_ITEMS_INTERFACE',

774: request_id,
775: cr.TRANSACTION_ID,
776: error_msg,
777: 'ENGINEERING_ITEM_ID',
778: 'MTL_SYSTEM_ITEMS_INTERFACE',
779: 'BOM_OP_VALIDATION_ERR',
780: err_text);
781: if dumm_status < 0 then
782: raise LOGGING_ERR;

Line 818: 'MTL_SYSTEM_ITEMS_INTERFACE',

814: request_id,
815: cr.TRANSACTION_ID,
816: error_msg,
817: 'PRIMARY_UOM_CODE',
818: 'MTL_SYSTEM_ITEMS_INTERFACE',
819: 'INV_IOI_PRIMARY_UOM',
820: err_text);
821: if dumm_status < 0 then
822: raise LOGGING_ERR;

Line 839: 'MTL_SYSTEM_ITEMS_INTERFACE',

835: request_id,
836: cr.TRANSACTION_ID,
837: error_msg,
838: 'PRIMARY_UNIT_OF_MEASURE',
839: 'MTL_SYSTEM_ITEMS_INTERFACE',
840: 'INV_IOI_PRIMARY_UOM',
841: err_text);
842: if dumm_status < 0 then
843: raise LOGGING_ERR;

Line 873: 'MTL_SYSTEM_ITEMS_INTERFACE',

869: request_id,
870: cr.TRANSACTION_ID,
871: error_msg,
872: 'PRIMARY_UOM_CODE',
873: 'MTL_SYSTEM_ITEMS_INTERFACE',
874: 'INV_IOI_PRIMARY_UOM',
875: err_text);
876: IF dumm_status < 0 THEN
877: RAISE LOGGING_ERR;

Line 932: 'MTL_SYSTEM_ITEMS_INTERFACE',

928: request_id,
929: cr.TRANSACTION_ID,
930: error_msg,
931: 'PRIMARY_UNIT_OF_MEASURE',
932: 'MTL_SYSTEM_ITEMS_INTERFACE',
933: 'INV_IOI_PRIMARY_UOM2',
934: err_text);
935: if dumm_status < 0 then
936: raise LOGGING_ERR;

Line 982: 'MTL_SYSTEM_ITEMS_INTERFACE',

978: request_id,
979: cr.TRANSACTION_ID,
980: error_msg,
981: 'PRIMARY_UNIT_OF_MEASURE',
982: 'MTL_SYSTEM_ITEMS_INTERFACE',
983: 'INV_IOI_NO_UOM_CONV',
984: err_text);
985: if dumm_status < 0 then
986: raise LOGGING_ERR;

Line 1014: 'MTL_SYSTEM_ITEMS_INTERFACE',

1010: request_id,
1011: cr.TRANSACTION_ID,
1012: error_msg,
1013: 'ITEM_TYPE',
1014: 'MTL_SYSTEM_ITEMS_INTERFACE',
1015: 'INV_IOI_ITEM_TYPE',
1016: err_text);
1017: if dumm_status < 0 then
1018: raise LOGGING_ERR;

Line 1043: 'MTL_SYSTEM_ITEMS_INTERFACE',

1039: request_id,
1040: cr.TRANSACTION_ID,
1041: error_msg,
1042: 'CONTAINER_TYPE_CODE',
1043: 'MTL_SYSTEM_ITEMS_INTERFACE',
1044: 'INV_IOI_CONTAINER_TYPE_CODE',
1045: err_text);
1046: if dumm_status < 0 then
1047: raise LOGGING_ERR;

Line 1072: 'MTL_SYSTEM_ITEMS_INTERFACE',

1068: request_id,
1069: cr.TRANSACTION_ID,
1070: error_msg,
1071: 'VOLUME_UOM_CODE',
1072: 'MTL_SYSTEM_ITEMS_INTERFACE',
1073: 'INV_IOI_VOLUME_UOM_CODE',
1074: err_text);
1075: if dumm_status < 0 then
1076: raise LOGGING_ERR;

Line 1102: 'MTL_SYSTEM_ITEMS_INTERFACE',

1098: request_id,
1099: cr.TRANSACTION_ID,
1100: error_msg,
1101: 'WEIGHT_UOM_CODE',
1102: 'MTL_SYSTEM_ITEMS_INTERFACE',
1103: 'INV_IOI_WEIGHT_UOM_CODE',
1104: err_text);
1105: if dumm_status < 0 then
1106: raise LOGGING_ERR;

Line 1139: 'MTL_SYSTEM_ITEMS_INTERFACE',

1135: request_id,
1136: cr.TRANSACTION_ID,
1137: error_msg,
1138: 'ITEM_CATALOG_GROUP_ID',
1139: 'MTL_SYSTEM_ITEMS_INTERFACE',
1140: 'INV_IOI_ITEM_CAT_GROUP',
1141: err_text);
1142: if dumm_status < 0 then
1143: raise LOGGING_ERR;

Line 1201: 'MTL_SYSTEM_ITEMS_INTERFACE',

1197: request_id,
1198: cr.TRANSACTION_ID,
1199: error_msg,
1200: 'ITEM_CATALOG_GROUP_ID',
1201: 'MTL_SYSTEM_ITEMS_INTERFACE',
1202: 'INV_IOI_ONLY_CATALOG_DOWNCAST',
1203: err_text);
1204: if dumm_status < 0 then
1205: raise LOGGING_ERR;

Line 1273: 'MTL_SYSTEM_ITEMS_INTERFACE',

1269: request_id,
1270: cr.TRANSACTION_ID,
1271: error_msg,
1272: 'SOURCE_SUBINVENTORY',
1273: 'MTL_SYSTEM_ITEMS_INTERFACE',
1274: l_message_name,
1275: err_text);
1276: if dumm_status < 0 then
1277: raise LOGGING_ERR;

Line 1303: 'MTL_SYSTEM_ITEMS_INTERFACE',

1299: request_id,
1300: cr.TRANSACTION_ID,
1301: error_msg,
1302: 'HAZARD_CLASS_ID',
1303: 'MTL_SYSTEM_ITEMS_INTERFACE',
1304: 'INV_IOI_HAZARD_CLASS',
1305: err_text);
1306: if dumm_status < 0 then
1307: raise LOGGING_ERR;

Line 1332: 'MTL_SYSTEM_ITEMS_INTERFACE',

1328: request_id,
1329: cr.TRANSACTION_ID,
1330: error_msg,
1331: 'UN_NUMBER_ID',
1332: 'MTL_SYSTEM_ITEMS_INTERFACE',
1333: 'INV_IOI_UN_NUMBER',
1334: err_text);
1335: if dumm_status < 0 then
1336: raise LOGGING_ERR;

Line 1361: 'MTL_SYSTEM_ITEMS_INTERFACE',

1357: request_id,
1358: cr.TRANSACTION_ID,
1359: error_msg,
1360: 'ASSET_CATEGORY_ID',
1361: 'MTL_SYSTEM_ITEMS_INTERFACE',
1362: 'INV_IOI_ASSET_CAT_ID',
1363: err_text);
1364: if dumm_status < 0 then
1365: raise LOGGING_ERR;

Line 1391: 'MTL_SYSTEM_ITEMS_INTERFACE',

1387: request_id,
1388: cr.TRANSACTION_ID,
1389: error_msg,
1390: 'BASE_ITEM_ID',
1391: 'MTL_SYSTEM_ITEMS_INTERFACE',
1392: 'INV_IOI_BASE_ITEM_ID',
1393: err_text);
1394: if dumm_status < 0 then
1395: raise LOGGING_ERR;

Line 1411: 'MTL_SYSTEM_ITEMS_INTERFACE',

1407: request_id,
1408: cr.TRANSACTION_ID,
1409: error_msg,
1410: 'AUTO_CREATED_CONFIG_FLAG',
1411: 'MTL_SYSTEM_ITEMS_INTERFACE',
1412: 'INV_BASE_ITEM_AUTO_CREATE_DEP',
1413: err_text);
1414: if dumm_status < 0 then
1415: raise LOGGING_ERR;

Line 1465: 'MTL_SYSTEM_ITEMS_INTERFACE',

1461: request_id,
1462: cr.TRANSACTION_ID,
1463: error_msg,
1464: 'WIP_SUPPLY_SUBINVENTORY',
1465: 'MTL_SYSTEM_ITEMS_INTERFACE',
1466: l_message_name,
1467: err_text);
1468: if dumm_status < 0 then
1469: raise LOGGING_ERR;

Line 1530: 'MTL_SYSTEM_ITEMS_INTERFACE',

1526: request_id,
1527: cr.TRANSACTION_ID,
1528: error_msg,
1529: 'WIP_SUPPLY_LOCATOR_ID',
1530: 'MTL_SYSTEM_ITEMS_INTERFACE',
1531: 'INV_IOI_SUP_LOC_ID_MANDATORY',
1532: err_text);
1533: IF dumm_status < 0 THEN
1534: raise LOGGING_ERR;

Line 1588: 'MTL_SYSTEM_ITEMS_INTERFACE',

1584: request_id,
1585: cr.TRANSACTION_ID,
1586: error_msg,
1587: 'WIP_SUPPLY_LOCATOR_ID',
1588: 'MTL_SYSTEM_ITEMS_INTERFACE',
1589: 'INV_IOI_WIP_SUP_LOC_ID',
1590: err_text);
1591: if dumm_status < 0 then
1592: raise LOGGING_ERR;

Line 1645: 'MTL_SYSTEM_ITEMS_INTERFACE',

1641: request_id,
1642: cr.TRANSACTION_ID,
1643: error_msg,
1644: 'BUYER_ID',
1645: 'MTL_SYSTEM_ITEMS_INTERFACE',
1646: 'INV_IOI_BUYER_ID',
1647: err_text);
1648: if dumm_status < 0 then
1649: raise LOGGING_ERR;

Line 1675: 'MTL_SYSTEM_ITEMS_INTERFACE',

1671: request_id,
1672: cr.TRANSACTION_ID,
1673: error_msg,
1674: 'RECEIVING_ROUTING_ID',
1675: 'MTL_SYSTEM_ITEMS_INTERFACE',
1676: 'INV_IOI_REC_ROUTING_ID',
1677: err_text);
1678: if dumm_status < 0 then
1679: raise LOGGING_ERR;

Line 1696: 'MTL_SYSTEM_ITEMS_INTERFACE',

1692: request_id,
1693: cr.TRANSACTION_ID,
1694: error_msg,
1695: 'SERV_REQ_ENABLED_FLAG',
1696: 'MTL_SYSTEM_ITEMS_INTERFACE',
1697: 'INV_IOI_SERV_REQ_ENABLED',
1698: err_text);
1699: if dumm_status < 0 then
1700: raise LOGGING_ERR;

Line 1717: 'MTL_SYSTEM_ITEMS_INTERFACE',

1713: request_id,
1714: cr.TRANSACTION_ID,
1715: error_msg,
1716: 'SERV_REQ_ENABLED_FLAG',
1717: 'MTL_SYSTEM_ITEMS_INTERFACE',
1718: 'INV_SERV_REQ_CONTRACT_DEP',
1719: err_text);
1720: if dumm_status < 0 then
1721: raise LOGGING_ERR;

Line 1738: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1758: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1791: 'MTL_SYSTEM_ITEMS_INTERFACE',

1787: request_id,
1788: cr.TRANSACTION_ID,
1789: error_msg,
1790: 'TRACKING_QUANTITY_IND',
1791: 'MTL_SYSTEM_ITEMS_INTERFACE',
1792: 'INV_INVALID_ATTR_COL_VALUE',
1793: err_text);
1794: if dumm_status < 0 then
1795: raise LOGGING_ERR;

Line 1827: 'MTL_SYSTEM_ITEMS_INTERFACE',

1823: request_id,
1824: cr.TRANSACTION_ID,
1825: error_msg,
1826: 'ONT_PRICING_QTY_SOURCE',
1827: 'MTL_SYSTEM_ITEMS_INTERFACE',
1828: 'INV_INVALID_ATTR_COL_VALUE',
1829: err_text);
1830: if dumm_status < 0 then
1831: raise LOGGING_ERR;

Line 1855: 'MTL_SYSTEM_ITEMS_INTERFACE',

1851: request_id,
1852: cr.TRANSACTION_ID,
1853: error_msg,
1854: 'SECONDARY_DEFAULT_IND',
1855: 'MTL_SYSTEM_ITEMS_INTERFACE',
1856: 'INV_INVALID_ATTR_COL_VALUE',
1857: err_text);
1858: if dumm_status < 0 then
1859: raise LOGGING_ERR;

Line 1881: 'MTL_SYSTEM_ITEMS_INTERFACE',

1877: request_id,
1878: cr.TRANSACTION_ID,
1879: error_msg,
1880: 'SECONDARY_UOM_CODE',
1881: 'MTL_SYSTEM_ITEMS_INTERFACE',
1882: 'INV_PRIMARY_SEC_UOM_SAME',
1883: err_text);
1884: if dumm_status < 0 then
1885: raise LOGGING_ERR;

Line 1901: 'MTL_SYSTEM_ITEMS_INTERFACE',

1897: request_id,
1898: cr.TRANSACTION_ID,
1899: error_msg,
1900: 'SECONDARY_UOM_CODE',
1901: 'MTL_SYSTEM_ITEMS_INTERFACE',
1902: 'INV_INVALID_ATTR_COL_VALUE',
1903: err_text);
1904: IF dumm_status < 0 THEN
1905: RAISE LOGGING_ERR;

Line 1926: 'MTL_SYSTEM_ITEMS_INTERFACE',

1922: request_id,
1923: cr.TRANSACTION_ID,
1924: error_msg,
1925: 'SECONDARY_DEFAULT_IND',
1926: 'MTL_SYSTEM_ITEMS_INTERFACE',
1927: 'INV_SEC_DEFULT_IS_FIXED',
1928: err_text);
1929: if dumm_status < 0 then
1930: raise LOGGING_ERR;

Line 1948: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1967: 'MTL_SYSTEM_ITEMS_INTERFACE',

1963: request_id,
1964: cr.TRANSACTION_ID,
1965: error_msg,
1966: 'SECONDARY_UOM_CODE',
1967: 'MTL_SYSTEM_ITEMS_INTERFACE',
1968: 'INV_SEC_UOM_IS_NOT_NULL',
1969: err_text);
1970: if dumm_status < 0 then
1971: raise LOGGING_ERR;

Line 1989: 'MTL_SYSTEM_ITEMS_INTERFACE',

1985: request_id,
1986: cr.TRANSACTION_ID,
1987: error_msg,
1988: 'DUAL_UOM_DEVIATION_HIGH',
1989: 'MTL_SYSTEM_ITEMS_INTERFACE',
1990: 'INV_UOM_DEV_IS_NOT_ZERO',
1991: err_text);
1992: if dumm_status < 0 then
1993: raise LOGGING_ERR;

Line 2011: 'MTL_SYSTEM_ITEMS_INTERFACE',

2007: request_id,
2008: cr.TRANSACTION_ID,
2009: error_msg,
2010: 'SECONDARY_UOM_CODE',
2011: 'MTL_SYSTEM_ITEMS_INTERFACE',
2012: 'INV_REQUIRED_FIELDS',
2013: err_text);
2014: if dumm_status < 0 then
2015: raise LOGGING_ERR;

Line 2032: 'MTL_SYSTEM_ITEMS_INTERFACE',

2028: request_id,
2029: cr.TRANSACTION_ID,
2030: error_msg,
2031: 'SECONDARY_DEFAULT_IND',
2032: 'MTL_SYSTEM_ITEMS_INTERFACE',
2033: 'INV_REQUIRED_FIELDS',
2034: err_text);
2035: if dumm_status < 0 then
2036: raise LOGGING_ERR;

Line 2052: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 2097: 'MTL_SYSTEM_ITEMS_INTERFACE',

2093: request_id,
2094: cr.TRANSACTION_ID,
2095: error_msg,
2096: 'SECONDARY_UOM_CODE',
2097: 'MTL_SYSTEM_ITEMS_INTERFACE',
2098: 'INV_SEC_UOM_MISMATCH_CLASS',
2099: err_text);
2100: if dumm_status < 0 then
2101: raise LOGGING_ERR;

Line 2126: 'MTL_SYSTEM_ITEMS_INTERFACE',

2122: request_id,
2123: cr.TRANSACTION_ID,
2124: error_msg,
2125: 'TRACKING_QUANTITY_IND',
2126: 'MTL_SYSTEM_ITEMS_INTERFACE',
2127: 'INV_INVALID_TRACKING_QTY_IND',
2128: err_text);
2129: if dumm_status < 0 then
2130: raise LOGGING_ERR;

Line 2156: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 2182: from MTL_SYSTEM_ITEMS_INTERFACE

2178: */
2179:
2180: /* Bug 4705184
2181: select process_flag into temp_proc_flag
2182: from MTL_SYSTEM_ITEMS_INTERFACE
2183: where inventory_item_id = l_item_id
2184: and set_process_id + 0 = xset_id
2185: and process_flag in (31, 32, 33, 34, 44)
2186: and organization_id = cr.organization_id

Line 2196: update MTL_SYSTEM_ITEMS_INTERFACE

2192: ** the previous packages.
2193: */
2194: if (temp_proc_flag <> 31 and temp_proc_flag <> 32
2195: and temp_proc_flag <> 33 and temp_proc_flag <> 34) then
2196: update MTL_SYSTEM_ITEMS_INTERFACE
2197: set process_flag = DECODE(status,0,45,35),
2198: PRIMARY_UOM_CODE = cr.primary_uom_code,
2199: primary_unit_of_measure = cr.primary_unit_of_measure
2200: where inventory_item_id = l_item_id

Line 2225: 'MTL_SYSTEM_ITEMS_INTERFACE',

2221: request_id,
2222: trans_id,
2223: err_text,
2224: 'validation_error ' || stmt,
2225: 'MTL_SYSTEM_ITEMS_INTERFACE',
2226: 'BOM_OP_VALIDATION_ERR',
2227: err_text);
2228: return(status);
2229: when OTHERS then