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

Line 315: from MTL_SYSTEM_ITEMS_INTERFACE

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

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

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

Line 433: from mtl_system_items_interface

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

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

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

Line 481: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 524: 'MTL_SYSTEM_ITEMS_INTERFACE',

520: request_id,
521: cr.TRANSACTION_ID,
522: l_msg_text,
523: 'COST_OF_SALES_ACCOUNT',
524: 'MTL_SYSTEM_ITEMS_INTERFACE',
525: 'INV_IOI_ERR_CST_OF_SLS_ACNT', --bug 11894684, replace INV_IOI_ERR
526: err_text);
527: if dumm_status < 0 then
528: raise LOGGING_ERR;

Line 567: 'MTL_SYSTEM_ITEMS_INTERFACE',

563: request_id,
564: cr.TRANSACTION_ID,
565: l_msg_text,
566: 'SALES_ACCOUNT',
567: 'MTL_SYSTEM_ITEMS_INTERFACE',
568: 'INV_IOI_ERR_SLS_ACCNT',--bug 11894684, replace INV_IOI_ERR
569: err_text);
570: if dumm_status < 0 then
571: raise LOGGING_ERR;

Line 610: 'MTL_SYSTEM_ITEMS_INTERFACE',

606: request_id,
607: cr.TRANSACTION_ID,
608: l_msg_text,
609: 'EXPENSE_ACCOUNT',
610: 'MTL_SYSTEM_ITEMS_INTERFACE',
611: 'INV_IOI_ERR_EXEPENSE_ACCOUNT',--bug 11894684, replace INV_IOI_ERR
612: err_text);
613: if dumm_status < 0 then
614: raise LOGGING_ERR;

Line 647: 'MTL_SYSTEM_ITEMS_INTERFACE',

643: request_id,
644: cr.TRANSACTION_ID,
645: l_msg_text,
646: 'ENCUMBRANCE_ACCOUNT',
647: 'MTL_SYSTEM_ITEMS_INTERFACE',
648: 'INV_IOI_ERR_ENCUMB_ACCT',--bug 11894684, replace INV_IOI_ERR
649: err_text);
650: if dumm_status < 0 then
651: raise LOGGING_ERR;

Line 669: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 690: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 711: 'MTL_SYSTEM_ITEMS_INTERFACE',

707: request_id,
708: cr.TRANSACTION_ID,
709: error_msg,
710: 'MATERIAL_BILLABLE_FLAG',
711: 'MTL_SYSTEM_ITEMS_INTERFACE',
712: 'INV_SERV_BILLING_MATERIAL_DEP',
713: err_text);
714: if dumm_status < 0 then
715: raise LOGGING_ERR;

Line 738: 'MTL_SYSTEM_ITEMS_INTERFACE',

734: request_id,
735: cr.TRANSACTION_ID,
736: error_msg,
737: 'PICKING_RULE_ID',
738: 'MTL_SYSTEM_ITEMS_INTERFACE',
739: 'INV_IOI_PICKING_RULE',
740: err_text);
741: if dumm_status < 0 then
742: raise LOGGING_ERR;

Line 768: 'MTL_SYSTEM_ITEMS_INTERFACE',

764: request_id,
765: cr.TRANSACTION_ID,
766: error_msg,
767: 'INVENTORY_ITEM_STATUS_CODE',
768: 'MTL_SYSTEM_ITEMS_INTERFACE',
769: 'INV_IOI_STATUS_CODE',
770: err_text);
771: if dumm_status < 0 then
772: raise LOGGING_ERR;

Line 783: from MTL_SYSTEM_ITEMS

779: -- validate foreign keys
780: if cr.ENGINEERING_ITEM_ID is not null then
781: begin
782: select 'x' into temp
783: from MTL_SYSTEM_ITEMS
784: where INVENTORY_ITEM_ID = cr.ENGINEERING_ITEM_ID
785: and ORGANIZATION_ID = cr.ORGANIZATION_ID;
786: exception
787: when NO_DATA_FOUND then

Line 798: 'MTL_SYSTEM_ITEMS_INTERFACE',

794: request_id,
795: cr.TRANSACTION_ID,
796: error_msg,
797: 'ENGINEERING_ITEM_ID',
798: 'MTL_SYSTEM_ITEMS_INTERFACE',
799: 'BOM_OP_VALIDATION_ERR',
800: err_text);
801: if dumm_status < 0 then
802: raise LOGGING_ERR;

Line 838: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 860: 'MTL_SYSTEM_ITEMS_INTERFACE',

856: request_id,
857: cr.TRANSACTION_ID,
858: error_msg,
859: 'PRIMARY_UNIT_OF_MEASURE',
860: 'MTL_SYSTEM_ITEMS_INTERFACE',
861: 'INV_IOI_PRIMARY_UOM',
862: err_text);
863: if dumm_status < 0 then
864: raise LOGGING_ERR;

Line 895: 'MTL_SYSTEM_ITEMS_INTERFACE',

891: request_id,
892: cr.TRANSACTION_ID,
893: error_msg,
894: 'PRIMARY_UOM_CODE',
895: 'MTL_SYSTEM_ITEMS_INTERFACE',
896: 'INV_IOI_PRIMARY_UOM',
897: err_text);
898: IF dumm_status < 0 THEN
899: RAISE LOGGING_ERR;

Line 928: from MTL_SYSTEM_ITEMS msi

924: /*Fix for bug 4564472 -Organizaition_id filter was added in the where clause of the below query
925: to improve its performance. */
926:
927: select 'x' into temp
928: from MTL_SYSTEM_ITEMS msi
929: where INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID
930: and ORGANIZATION_ID in
931: ( select MASTER_ORGANIZATION_ID
932: from MTL_PARAMETERS

Line 958: 'MTL_SYSTEM_ITEMS_INTERFACE',

954: request_id,
955: cr.TRANSACTION_ID,
956: error_msg,
957: 'PRIMARY_UNIT_OF_MEASURE',
958: 'MTL_SYSTEM_ITEMS_INTERFACE',
959: 'INV_IOI_PRIMARY_UOM2',
960: err_text);
961: if dumm_status < 0 then
962: raise LOGGING_ERR;

Line 1011: 'MTL_SYSTEM_ITEMS_INTERFACE',

1007: request_id,
1008: cr.TRANSACTION_ID,
1009: error_msg,
1010: 'PRIMARY_UNIT_OF_MEASURE',
1011: 'MTL_SYSTEM_ITEMS_INTERFACE',
1012: 'INV_IOI_NO_UOM_CONV',
1013: err_text);
1014: if dumm_status < 0 then
1015: raise LOGGING_ERR;

Line 1043: 'MTL_SYSTEM_ITEMS_INTERFACE',

1039: request_id,
1040: cr.TRANSACTION_ID,
1041: error_msg,
1042: 'ITEM_TYPE',
1043: 'MTL_SYSTEM_ITEMS_INTERFACE',
1044: 'INV_IOI_ITEM_TYPE',
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: 'CONTAINER_TYPE_CODE',
1072: 'MTL_SYSTEM_ITEMS_INTERFACE',
1073: 'INV_IOI_CONTAINER_TYPE_CODE',
1074: err_text);
1075: if dumm_status < 0 then
1076: raise LOGGING_ERR;

Line 1101: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1131: 'MTL_SYSTEM_ITEMS_INTERFACE',

1127: request_id,
1128: cr.TRANSACTION_ID,
1129: error_msg,
1130: 'WEIGHT_UOM_CODE',
1131: 'MTL_SYSTEM_ITEMS_INTERFACE',
1132: 'INV_IOI_WEIGHT_UOM_CODE',
1133: err_text);
1134: if dumm_status < 0 then
1135: raise LOGGING_ERR;

Line 1168: 'MTL_SYSTEM_ITEMS_INTERFACE',

1164: request_id,
1165: cr.TRANSACTION_ID,
1166: error_msg,
1167: 'ITEM_CATALOG_GROUP_ID',
1168: 'MTL_SYSTEM_ITEMS_INTERFACE',
1169: 'INV_IOI_ITEM_CAT_GROUP',
1170: err_text);
1171: if dumm_status < 0 then
1172: raise LOGGING_ERR;

Line 1180: FROM mtl_system_items_b

1176: ELSIF cr.transaction_type ='UPDATE' THEN
1177:
1178: SELECT item_catalog_group_id
1179: INTO l_old_catalog_id
1180: FROM mtl_system_items_b
1181: WHERE inventory_item_id = cr.inventory_item_id
1182: AND organization_id = cr.organization_id;
1183:
1184: --Bug: 2805253 Modified the validation

Line 1230: 'MTL_SYSTEM_ITEMS_INTERFACE',

1226: request_id,
1227: cr.TRANSACTION_ID,
1228: error_msg,
1229: 'ITEM_CATALOG_GROUP_ID',
1230: 'MTL_SYSTEM_ITEMS_INTERFACE',
1231: 'INV_IOI_ONLY_CATALOG_DOWNCAST',
1232: err_text);
1233: if dumm_status < 0 then
1234: raise LOGGING_ERR;

Line 1251: from mtl_system_items_b

1247: l_source_subinv_error := FALSE;
1248: if ( cr.ORGANIZATION_ID <> cr.SOURCE_ORGANIZATION_ID ) then
1249: select restrict_subinventories_code
1250: into l_source_restrict_sub
1251: from mtl_system_items_b
1252: where organization_id = cr.SOURCE_ORGANIZATION_ID
1253: and inventory_item_id = cr.INVENTORY_ITEM_ID;
1254: else
1255: l_source_restrict_sub := nvl(cr.RESTRICT_SUBINVENTORIES_CODE, 2) ;

Line 1302: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1332: 'MTL_SYSTEM_ITEMS_INTERFACE',

1328: request_id,
1329: cr.TRANSACTION_ID,
1330: error_msg,
1331: 'HAZARD_CLASS_ID',
1332: 'MTL_SYSTEM_ITEMS_INTERFACE',
1333: 'INV_IOI_HAZARD_CLASS',
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: 'UN_NUMBER_ID',
1361: 'MTL_SYSTEM_ITEMS_INTERFACE',
1362: 'INV_IOI_UN_NUMBER',
1363: err_text);
1364: if dumm_status < 0 then
1365: raise LOGGING_ERR;

Line 1390: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1405: from MTL_SYSTEM_ITEMS

1401: -- validate foreign keys
1402: if cr.BASE_ITEM_ID is not null then
1403: begin
1404: select 'x' into temp
1405: from MTL_SYSTEM_ITEMS
1406: where INVENTORY_ITEM_ID = cr.BASE_ITEM_ID
1407: and ORGANIZATION_ID = cr.ORGANIZATION_ID;
1408: exception
1409: when NO_DATA_FOUND then

Line 1420: 'MTL_SYSTEM_ITEMS_INTERFACE',

1416: request_id,
1417: cr.TRANSACTION_ID,
1418: error_msg,
1419: 'BASE_ITEM_ID',
1420: 'MTL_SYSTEM_ITEMS_INTERFACE',
1421: 'INV_IOI_BASE_ITEM_ID',
1422: err_text);
1423: if dumm_status < 0 then
1424: raise LOGGING_ERR;

Line 1440: 'MTL_SYSTEM_ITEMS_INTERFACE',

1436: request_id,
1437: cr.TRANSACTION_ID,
1438: error_msg,
1439: 'AUTO_CREATED_CONFIG_FLAG',
1440: 'MTL_SYSTEM_ITEMS_INTERFACE',
1441: 'INV_BASE_ITEM_AUTO_CREATE_DEP',
1442: err_text);
1443: if dumm_status < 0 then
1444: raise LOGGING_ERR;

Line 1494: 'MTL_SYSTEM_ITEMS_INTERFACE',

1490: request_id,
1491: cr.TRANSACTION_ID,
1492: error_msg,
1493: 'WIP_SUPPLY_SUBINVENTORY',
1494: 'MTL_SYSTEM_ITEMS_INTERFACE',
1495: l_message_name,
1496: err_text);
1497: if dumm_status < 0 then
1498: raise LOGGING_ERR;

Line 1559: 'MTL_SYSTEM_ITEMS_INTERFACE',

1555: request_id,
1556: cr.TRANSACTION_ID,
1557: error_msg,
1558: 'WIP_SUPPLY_LOCATOR_ID',
1559: 'MTL_SYSTEM_ITEMS_INTERFACE',
1560: 'INV_IOI_SUP_LOC_ID_MANDATORY',
1561: err_text);
1562: IF dumm_status < 0 THEN
1563: raise LOGGING_ERR;

Line 1617: 'MTL_SYSTEM_ITEMS_INTERFACE',

1613: request_id,
1614: cr.TRANSACTION_ID,
1615: error_msg,
1616: 'WIP_SUPPLY_LOCATOR_ID',
1617: 'MTL_SYSTEM_ITEMS_INTERFACE',
1618: 'INV_IOI_WIP_SUP_LOC_ID',
1619: err_text);
1620: if dumm_status < 0 then
1621: raise LOGGING_ERR;

Line 1674: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1704: 'MTL_SYSTEM_ITEMS_INTERFACE',

1700: request_id,
1701: cr.TRANSACTION_ID,
1702: error_msg,
1703: 'RECEIVING_ROUTING_ID',
1704: 'MTL_SYSTEM_ITEMS_INTERFACE',
1705: 'INV_IOI_REC_ROUTING_ID',
1706: err_text);
1707: if dumm_status < 0 then
1708: raise LOGGING_ERR;

Line 1725: 'MTL_SYSTEM_ITEMS_INTERFACE',

1721: request_id,
1722: cr.TRANSACTION_ID,
1723: error_msg,
1724: 'SERV_REQ_ENABLED_FLAG',
1725: 'MTL_SYSTEM_ITEMS_INTERFACE',
1726: 'INV_IOI_SERV_REQ_ENABLED',
1727: err_text);
1728: if dumm_status < 0 then
1729: raise LOGGING_ERR;

Line 1746: 'MTL_SYSTEM_ITEMS_INTERFACE',

1742: request_id,
1743: cr.TRANSACTION_ID,
1744: error_msg,
1745: 'SERV_REQ_ENABLED_FLAG',
1746: 'MTL_SYSTEM_ITEMS_INTERFACE',
1747: 'INV_SERV_REQ_CONTRACT_DEP',
1748: err_text);
1749: if dumm_status < 0 then
1750: raise LOGGING_ERR;

Line 1767: 'MTL_SYSTEM_ITEMS_INTERFACE',

1763: request_id,
1764: cr.TRANSACTION_ID,
1765: error_msg,
1766: 'SERVICE_STARTING_DELAY',
1767: 'MTL_SYSTEM_ITEMS_INTERFACE',
1768: 'INV_CONTRACT_START_DELAY_DEP',
1769: err_text);
1770: if dumm_status < 0 then
1771: raise LOGGING_ERR;

Line 1787: 'MTL_SYSTEM_ITEMS_INTERFACE',

1783: request_id,
1784: cr.TRANSACTION_ID,
1785: error_msg,
1786: 'SERV_IMPORTANCE_LEVEL',
1787: 'MTL_SYSTEM_ITEMS_INTERFACE',
1788: 'INV_IOI_SERV_IMPORTANCE_LEVEL',
1789: err_text);
1790: if dumm_status < 0 then
1791: raise LOGGING_ERR;

Line 1820: 'MTL_SYSTEM_ITEMS_INTERFACE',

1816: request_id,
1817: cr.TRANSACTION_ID,
1818: error_msg,
1819: 'TRACKING_QUANTITY_IND',
1820: 'MTL_SYSTEM_ITEMS_INTERFACE',
1821: 'INV_INVALID_ATTR_COL_VALUE',
1822: err_text);
1823: if dumm_status < 0 then
1824: raise LOGGING_ERR;

Line 1856: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1884: 'MTL_SYSTEM_ITEMS_INTERFACE',

1880: request_id,
1881: cr.TRANSACTION_ID,
1882: error_msg,
1883: 'SECONDARY_DEFAULT_IND',
1884: 'MTL_SYSTEM_ITEMS_INTERFACE',
1885: 'INV_INVALID_ATTR_COL_VALUE',
1886: err_text);
1887: if dumm_status < 0 then
1888: raise LOGGING_ERR;

Line 1910: 'MTL_SYSTEM_ITEMS_INTERFACE',

1906: request_id,
1907: cr.TRANSACTION_ID,
1908: error_msg,
1909: 'SECONDARY_UOM_CODE',
1910: 'MTL_SYSTEM_ITEMS_INTERFACE',
1911: 'INV_PRIMARY_SEC_UOM_SAME',
1912: err_text);
1913: if dumm_status < 0 then
1914: raise LOGGING_ERR;

Line 1930: 'MTL_SYSTEM_ITEMS_INTERFACE',

1926: request_id,
1927: cr.TRANSACTION_ID,
1928: error_msg,
1929: 'SECONDARY_UOM_CODE',
1930: 'MTL_SYSTEM_ITEMS_INTERFACE',
1931: 'INV_INVALID_ATTR_COL_VALUE',
1932: err_text);
1933: IF dumm_status < 0 THEN
1934: RAISE LOGGING_ERR;

Line 1955: 'MTL_SYSTEM_ITEMS_INTERFACE',

1951: request_id,
1952: cr.TRANSACTION_ID,
1953: error_msg,
1954: 'SECONDARY_DEFAULT_IND',
1955: 'MTL_SYSTEM_ITEMS_INTERFACE',
1956: 'INV_SEC_DEFULT_IS_FIXED',
1957: err_text);
1958: if dumm_status < 0 then
1959: raise LOGGING_ERR;

Line 1977: 'MTL_SYSTEM_ITEMS_INTERFACE',

1973: request_id,
1974: cr.TRANSACTION_ID,
1975: error_msg,
1976: 'SECONDARY_DEFAULT_IND',
1977: 'MTL_SYSTEM_ITEMS_INTERFACE',
1978: 'INV_SEC_DEFAULT_NOT_NULL',
1979: err_text);
1980: if dumm_status < 0 then
1981: raise LOGGING_ERR;

Line 1996: 'MTL_SYSTEM_ITEMS_INTERFACE',

1992: request_id,
1993: cr.TRANSACTION_ID,
1994: error_msg,
1995: 'SECONDARY_UOM_CODE',
1996: 'MTL_SYSTEM_ITEMS_INTERFACE',
1997: 'INV_SEC_UOM_IS_NOT_NULL',
1998: err_text);
1999: if dumm_status < 0 then
2000: raise LOGGING_ERR;

Line 2018: 'MTL_SYSTEM_ITEMS_INTERFACE',

2014: request_id,
2015: cr.TRANSACTION_ID,
2016: error_msg,
2017: 'DUAL_UOM_DEVIATION_HIGH',
2018: 'MTL_SYSTEM_ITEMS_INTERFACE',
2019: 'INV_UOM_DEV_IS_NOT_ZERO',
2020: err_text);
2021: if dumm_status < 0 then
2022: raise LOGGING_ERR;

Line 2040: 'MTL_SYSTEM_ITEMS_INTERFACE',

2036: request_id,
2037: cr.TRANSACTION_ID,
2038: error_msg,
2039: 'SECONDARY_UOM_CODE',
2040: 'MTL_SYSTEM_ITEMS_INTERFACE',
2041: 'INV_REQUIRED_FIELDS',
2042: err_text);
2043: if dumm_status < 0 then
2044: raise LOGGING_ERR;

Line 2061: 'MTL_SYSTEM_ITEMS_INTERFACE',

2057: request_id,
2058: cr.TRANSACTION_ID,
2059: error_msg,
2060: 'SECONDARY_DEFAULT_IND',
2061: 'MTL_SYSTEM_ITEMS_INTERFACE',
2062: 'INV_REQUIRED_FIELDS',
2063: err_text);
2064: if dumm_status < 0 then
2065: raise LOGGING_ERR;

Line 2081: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 2101: from MTL_SYSTEM_ITEMS msi

2097: from MTL_UNITS_OF_MEASURE
2098: where UOM_CODE = cr.SECONDARY_UOM_CODE;
2099:
2100: select 'x' into temp
2101: from MTL_SYSTEM_ITEMS msi
2102: where INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID
2103: and secondary_uom_code IS NOT NULL
2104: and not exists (select UNIT_OF_MEASURE
2105: from MTL_UNITS_OF_MEASURE MUOM

Line 2126: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 2155: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 2185: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 2211: from MTL_SYSTEM_ITEMS_INTERFACE

2207: */
2208:
2209: /* Bug 4705184
2210: select process_flag into temp_proc_flag
2211: from MTL_SYSTEM_ITEMS_INTERFACE
2212: where inventory_item_id = l_item_id
2213: and set_process_id + 0 = xset_id
2214: and process_flag in (31, 32, 33, 34, 44)
2215: and organization_id = cr.organization_id

Line 2225: update MTL_SYSTEM_ITEMS_INTERFACE

2221: ** the previous packages.
2222: */
2223: if (temp_proc_flag <> 31 and temp_proc_flag <> 32
2224: and temp_proc_flag <> 33 and temp_proc_flag <> 34) then
2225: update MTL_SYSTEM_ITEMS_INTERFACE
2226: set process_flag = DECODE(status,0,45,35),
2227: PRIMARY_UOM_CODE = cr.primary_uom_code,
2228: primary_unit_of_measure = cr.primary_unit_of_measure
2229: where inventory_item_id = l_item_id

Line 2255: 'MTL_SYSTEM_ITEMS_INTERFACE',

2251: request_id,
2252: trans_id,
2253: err_text,
2254: 'validation_error ' || stmt,
2255: 'MTL_SYSTEM_ITEMS_INTERFACE',
2256: 'BOM_OP_VALIDATION_ERR',
2257: err_text);
2258: return(status);
2259: when OTHERS then