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

Line 32: FROM MTL_SYSTEM_ITEMS_INTERFACE

28: masterorg_id NUMBER ;
29:
30: CURSOR cc IS
31: SELECT *
32: FROM MTL_SYSTEM_ITEMS_INTERFACE
33: WHERE ((organization_id = org_id) OR (all_Org = 1))
34: AND set_process_id = xset_id
35: AND process_flag in (31, 32, 33, 34 , 35 , 45);
36:

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

136: IF l_inv_debug_level IN(101, 102) THEN
137: INVPUTLI.info('INVPVDR6.validate_item_header6 : begin');
138: END IF;
139: reqst_id := request_id ;
140: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';
141:
142: --Start 3515652: Performance enhancements
143: dumm_status := INVPUPI2.validate_flags(
144: org_id

Line 195: from mtl_system_items_interface

191: temp_proc_flag := cr.process_flag; -- Bug 4705184
192:
193: /* Bug 4705184
194: select inventory_item_id into l_item_id
195: from mtl_system_items_interface
196: where transaction_id = cr.transaction_id
197: and set_process_id = xset_id; */
198:
199: -- Validate second group of foreign keys

Line 227: 'MTL_SYSTEM_ITEMS_INTERFACE',

223: request_id,
224: cr.TRANSACTION_ID,
225: error_msg,
226: 'PLANNING_EXCEPTION_SET',
227: 'MTL_SYSTEM_ITEMS_INTERFACE',
228: 'INV_IOI_PLN_EXC_SET',
229: err_text);
230: if dumm_status < 0 then
231: raise LOGGING_ERR;

Line 256: 'MTL_SYSTEM_ITEMS_INTERFACE',

252: request_id,
253: cr.TRANSACTION_ID,
254: error_msg,
255: 'ATP_RULE_ID',
256: 'MTL_SYSTEM_ITEMS_INTERFACE',
257: 'INV_IOI_ATP_RULE',
258: err_text);
259: if dumm_status < 0 then
260: raise LOGGING_ERR;

Line 286: 'MTL_SYSTEM_ITEMS_INTERFACE',

282: request_id,
283: cr.TRANSACTION_ID,
284: error_msg,
285: 'BASE_WARRANTY_SERVICE_ID',
286: 'MTL_SYSTEM_ITEMS_INTERFACE',
287: 'INV_IOI_BASE_WAR_SERV',
288: err_text);
289: if dumm_status < 0 then
290: raise LOGGING_ERR;

Line 315: 'MTL_SYSTEM_ITEMS_INTERFACE',

311: request_id,
312: cr.TRANSACTION_ID,
313: error_msg,
314: 'PAYMENT_TERMS_ID',
315: 'MTL_SYSTEM_ITEMS_INTERFACE',
316: 'INV_IOI_PAYMENT_TERMS',
317: err_text);
318: if dumm_status < 0 then
319: raise LOGGING_ERR;

Line 369: 'MTL_SYSTEM_ITEMS_INTERFACE',

365: request_id,
366: cr.TRANSACTION_ID,
367: error_msg,
368: 'UNIT_OF_ISSUE',
369: 'MTL_SYSTEM_ITEMS_INTERFACE',
370: 'INV_IOI_UNIT_OF_ISSUE',
371: err_text);
372: if dumm_status < 0 then
373: raise LOGGING_ERR;

Line 406: 'MTL_SYSTEM_ITEMS_INTERFACE',

402: request_id,
403: cr.TRANSACTION_ID,
404: error_msg,
405: 'SOURCE_ORGANIZATION_ID',
406: 'MTL_SYSTEM_ITEMS_INTERFACE',
407: 'INV_IOI_SOURCE_ORG_ID',
408: err_text);
409: if dumm_status < 0 then
410: raise LOGGING_ERR;

Line 435: 'MTL_SYSTEM_ITEMS_INTERFACE',

431: request_id,
432: cr.TRANSACTION_ID,
433: error_msg,
434: 'DEFAULT_SHIPPING_ORG',
435: 'MTL_SYSTEM_ITEMS_INTERFACE',
436: 'INV_IOI_DEF_SHIPPING_ORG',
437: err_text);
438: if dumm_status < 0 then
439: raise LOGGING_ERR;

Line 467: 'MTL_SYSTEM_ITEMS_INTERFACE',

463: request_id,
464: cr.TRANSACTION_ID,
465: error_msg,
466: 'ACCOUNTING_RULE_ID',
467: 'MTL_SYSTEM_ITEMS_INTERFACE',
468: 'INV_IOI_ACCT_RULE_ID',
469: err_text);
470: if dumm_status < 0 then
471: raise LOGGING_ERR;

Line 500: 'MTL_SYSTEM_ITEMS_INTERFACE',

496: request_id,
497: cr.TRANSACTION_ID,
498: error_msg,
499: 'INVOICING_RULE_ID',
500: 'MTL_SYSTEM_ITEMS_INTERFACE',
501: 'INV_IOI_INVOICING_RULE_ID',
502: err_text);
503: if dumm_status < 0 then
504: raise LOGGING_ERR;

Line 531: 'MTL_SYSTEM_ITEMS_INTERFACE',

527: request_id,
528: cr.TRANSACTION_ID,
529: error_msg,
530: 'PLANNER_CODE',
531: 'MTL_SYSTEM_ITEMS_INTERFACE',
532: 'INV_IOI_PLANNER_CODE',
533: err_text);
534: if dumm_status < 0 then
535: raise LOGGING_ERR;

Line 555: 'MTL_SYSTEM_ITEMS_INTERFACE',

551: request_id,
552: cr.TRANSACTION_ID,
553: error_msg,
554: 'START_DATE_ACTIVE',
555: 'MTL_SYSTEM_ITEMS_INTERFACE',
556: 'INV_START_DATE_END_DATE_WARN',
557: err_text);
558: if dumm_status < 0 then
559: raise LOGGING_ERR;

Line 574: 'MTL_SYSTEM_ITEMS_INTERFACE',

570: request_id,
571: cr.TRANSACTION_ID,
572: error_msg,
573: 'END_DATE_ACTIVE',
574: 'MTL_SYSTEM_ITEMS_INTERFACE',
575: 'INV_START_DATE_END_DATE_WARN',
576: err_text);
577: if dumm_status < 0 then
578: raise LOGGING_ERR;

Line 601: 'MTL_SYSTEM_ITEMS_INTERFACE',

597: request_id,
598: cr.TRANSACTION_ID,
599: error_msg,
600: 'CONFIG_ORGS',
601: 'MTL_SYSTEM_ITEMS_INTERFACE',
602: 'INV_INVALID_ATTR_COL_VALUE',
603: err_text);
604: if dumm_status < 0 then
605: raise LOGGING_ERR;

Line 628: 'MTL_SYSTEM_ITEMS_INTERFACE',

624: request_id,
625: cr.TRANSACTION_ID,
626: error_msg,
627: 'CONFIG_MATCH',
628: 'MTL_SYSTEM_ITEMS_INTERFACE',
629: 'INV_INVALID_ATTR_COL_VALUE',
630: err_text);
631: if dumm_status < 0 then
632: raise LOGGING_ERR;

Line 652: 'MTL_SYSTEM_ITEMS_INTERFACE',

648: request_id,
649: cr.TRANSACTION_ID,
650: error_msg,
651: 'CONFIG_ORGS_OR_CONFIG_MATCH',
652: 'MTL_SYSTEM_ITEMS_INTERFACE',
653: 'INV_CONFIG_ORG_MATCH',
654: err_text);
655: if dumm_status < 0 then
656: raise LOGGING_ERR;

Line 674: 'MTL_SYSTEM_ITEMS_INTERFACE',

670: request_id,
671: cr.TRANSACTION_ID,
672: error_msg,
673: 'BOM_ITEM_TYPE',
674: 'MTL_SYSTEM_ITEMS_INTERFACE',
675: 'INV_ITEM_OPTION_PHANTOM',
676: err_text);
677: if dumm_status < 0 then
678: raise LOGGING_ERR;

Line 702: 'MTL_SYSTEM_ITEMS_INTERFACE',

698: request_id,
699: cr.TRANSACTION_ID,
700: error_msg,
701: 'INVENTORY_PLANNING_CODE',
702: 'MTL_SYSTEM_ITEMS_INTERFACE',
703: 'INV_INVALID_ATTR_COL_VALUE',
704: err_text);
705: if dumm_status < 0 then
706: raise LOGGING_ERR;

Line 731: 'MTL_SYSTEM_ITEMS_INTERFACE',

727: request_id,
728: cr.TRANSACTION_ID,
729: error_msg,
730: 'INVENTORY_PLANNING_CODE',
731: 'MTL_SYSTEM_ITEMS_INTERFACE',
732: 'MTL_MSI_GP_INV_PLAN_CODE',
733: err_text);
734: if dumm_status < 0 then
735: raise LOGGING_ERR;

Line 760: 'MTL_SYSTEM_ITEMS_INTERFACE',

756: request_id,
757: cr.TRANSACTION_ID,
758: error_msg,
759: 'INVENTORY_PLANNING_CODE',
760: 'MTL_SYSTEM_ITEMS_INTERFACE',
761: 'INV_MINMAX_QUANTITIES',
762: err_text);
763: if dumm_status < 0 then
764: raise LOGGING_ERR;

Line 790: 'MTL_SYSTEM_ITEMS_INTERFACE',

786: request_id,
787: cr.TRANSACTION_ID,
788: error_msg,
789: 'VMI_MINIMUM_UNITS',
790: 'MTL_SYSTEM_ITEMS_INTERFACE',
791: 'INV_VMI_INTEGER_VALUE',
792: err_text);
793: if dumm_status < 0 then
794: raise LOGGING_ERR;

Line 808: 'MTL_SYSTEM_ITEMS_INTERFACE',

804: request_id,
805: cr.TRANSACTION_ID,
806: error_msg,
807: 'VMI_MINIMUM_UNITS',
808: 'MTL_SYSTEM_ITEMS_INTERFACE',
809: 'INV_VMI_GREATER_THAN_ZERO',
810: err_text);
811: if dumm_status < 0 then
812: raise LOGGING_ERR;

Line 839: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 857: 'MTL_SYSTEM_ITEMS_INTERFACE',

853: request_id,
854: cr.TRANSACTION_ID,
855: error_msg,
856: 'VMI_MINIMUM_DAYS',
857: 'MTL_SYSTEM_ITEMS_INTERFACE',
858: 'INV_VMI_GREATER_THAN_ZERO',
859: err_text);
860: if dumm_status < 0 then
861: raise LOGGING_ERR;

Line 888: 'MTL_SYSTEM_ITEMS_INTERFACE',

884: request_id,
885: cr.TRANSACTION_ID,
886: error_msg,
887: 'VMI_MAXIMUM_UNITS',
888: 'MTL_SYSTEM_ITEMS_INTERFACE',
889: 'INV_VMI_INTEGER_VALUE',
890: err_text);
891: if dumm_status < 0 then
892: raise LOGGING_ERR;

Line 906: 'MTL_SYSTEM_ITEMS_INTERFACE',

902: request_id,
903: cr.TRANSACTION_ID,
904: error_msg,
905: 'VMI_MAXIMUM_UNITS',
906: 'MTL_SYSTEM_ITEMS_INTERFACE',
907: 'INV_VMI_GREATER_THAN_ZERO',
908: err_text);
909: if dumm_status < 0 then
910: raise LOGGING_ERR;

Line 937: 'MTL_SYSTEM_ITEMS_INTERFACE',

933: request_id,
934: cr.TRANSACTION_ID,
935: error_msg,
936: 'VMI_MAXIMUM_DAYS',
937: 'MTL_SYSTEM_ITEMS_INTERFACE',
938: 'INV_VMI_INTEGER_VALUE',
939: err_text);
940: if dumm_status < 0 then
941: raise LOGGING_ERR;

Line 955: 'MTL_SYSTEM_ITEMS_INTERFACE',

951: request_id,
952: cr.TRANSACTION_ID,
953: error_msg,
954: 'VMI_MAXIMUM_DAYS',
955: 'MTL_SYSTEM_ITEMS_INTERFACE',
956: 'INV_VMI_GREATER_THAN_ZERO',
957: err_text);
958: if dumm_status < 0 then
959: raise LOGGING_ERR;

Line 986: 'MTL_SYSTEM_ITEMS_INTERFACE',

982: request_id,
983: cr.TRANSACTION_ID,
984: error_msg,
985: 'VMI_FIXED_ORDER_QUANTITY',
986: 'MTL_SYSTEM_ITEMS_INTERFACE',
987: 'INV_VMI_INTEGER_VALUE',
988: err_text);
989: if dumm_status < 0 then
990: raise LOGGING_ERR;

Line 1004: 'MTL_SYSTEM_ITEMS_INTERFACE',

1000: request_id,
1001: cr.TRANSACTION_ID,
1002: error_msg,
1003: 'VMI_FIXED_ORDER_QUANTITY',
1004: 'MTL_SYSTEM_ITEMS_INTERFACE',
1005: 'INV_VMI_GREATER_THAN_ZERO',
1006: err_text);
1007: if dumm_status < 0 then
1008: raise LOGGING_ERR;

Line 1026: 'MTL_SYSTEM_ITEMS_INTERFACE',

1022: request_id,
1023: cr.TRANSACTION_ID,
1024: error_msg,
1025: 'VMI_MINIMUM_UNITS',
1026: 'MTL_SYSTEM_ITEMS_INTERFACE',
1027: 'INV_MIN_UNITS_DAYS_VALUE',
1028: err_text);
1029: if dumm_status < 0 then
1030: raise LOGGING_ERR;

Line 1047: 'MTL_SYSTEM_ITEMS_INTERFACE',

1043: request_id,
1044: cr.TRANSACTION_ID,
1045: error_msg,
1046: 'VMI_MAXIMUM_UNITS',
1047: 'MTL_SYSTEM_ITEMS_INTERFACE',
1048: 'INV_MAX_UNITS_DAYS_VALUE',
1049: err_text);
1050: if dumm_status < 0 then
1051: raise LOGGING_ERR;

Line 1068: 'MTL_SYSTEM_ITEMS_INTERFACE',

1064: request_id,
1065: cr.TRANSACTION_ID,
1066: error_msg,
1067: 'VMI_MAXIMUM_DAYS',
1068: 'MTL_SYSTEM_ITEMS_INTERFACE',
1069: 'INV_MAX_UNITS_DAYS_VALUE',
1070: err_text);
1071: if dumm_status < 0 then
1072: raise LOGGING_ERR;

Line 1089: 'MTL_SYSTEM_ITEMS_INTERFACE',

1085: request_id,
1086: cr.TRANSACTION_ID,
1087: error_msg,
1088: 'VMI_MAXIMUM_UNITS',
1089: 'MTL_SYSTEM_ITEMS_INTERFACE',
1090: 'INV_MAX_DAYS_UNIT_VALUE',
1091: err_text);
1092: if dumm_status < 0 then
1093: raise LOGGING_ERR;

Line 1110: 'MTL_SYSTEM_ITEMS_INTERFACE',

1106: request_id,
1107: cr.TRANSACTION_ID,
1108: error_msg,
1109: 'VMI_MAXIMUM_DAYS',
1110: 'MTL_SYSTEM_ITEMS_INTERFACE',
1111: 'INV_MIN_MAX_UNITS_DAYS_VALUE',
1112: err_text);
1113: if dumm_status < 0 then
1114: raise LOGGING_ERR;

Line 1131: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1153: 'MTL_SYSTEM_ITEMS_INTERFACE',

1149: request_id,
1150: cr.TRANSACTION_ID,
1151: error_msg,
1152: 'VMI_MINIMUM_UNITS',
1153: 'MTL_SYSTEM_ITEMS_INTERFACE',
1154: 'INV_MIN_MAX_QTY_VALUE',
1155: err_text);
1156: if dumm_status < 0 then
1157: raise LOGGING_ERR;

Line 1175: 'MTL_SYSTEM_ITEMS_INTERFACE',

1171: request_id,
1172: cr.TRANSACTION_ID,
1173: error_msg,
1174: 'VMI_MINIMUM_DAYS',
1175: 'MTL_SYSTEM_ITEMS_INTERFACE',
1176: 'INV_MIN_DAYS_MAX_DAYS_VALUE',
1177: err_text);
1178: if dumm_status < 0 then
1179: raise LOGGING_ERR;

Line 1205: 'MTL_SYSTEM_ITEMS_INTERFACE',

1201: request_id,
1202: cr.TRANSACTION_ID,
1203: error_msg,
1204: 'FORECAST_HORIZON',
1205: 'MTL_SYSTEM_ITEMS_INTERFACE',
1206: 'INV_VMI_INTEGER_VALUE',
1207: err_text);
1208: if dumm_status < 0 then
1209: raise LOGGING_ERR;

Line 1223: 'MTL_SYSTEM_ITEMS_INTERFACE',

1219: request_id,
1220: cr.TRANSACTION_ID,
1221: error_msg,
1222: 'FORECAST_HORIZON',
1223: 'MTL_SYSTEM_ITEMS_INTERFACE',
1224: 'INV_VMI_GREATER_THAN_ZERO',
1225: err_text);
1226: if dumm_status < 0 then
1227: raise LOGGING_ERR;

Line 1254: 'MTL_SYSTEM_ITEMS_INTERFACE',

1250: request_id,
1251: cr.TRANSACTION_ID,
1252: error_msg,
1253: 'DAYS_TGT_INV_SUPPLY',
1254: 'MTL_SYSTEM_ITEMS_INTERFACE',
1255: 'INV_VMI_INTEGER_VALUE',
1256: err_text);
1257: if dumm_status < 0 then
1258: raise LOGGING_ERR;

Line 1272: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1303: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1321: 'MTL_SYSTEM_ITEMS_INTERFACE',

1317: request_id,
1318: cr.TRANSACTION_ID,
1319: error_msg,
1320: 'DAYS_TGT_INV_WINDOW',
1321: 'MTL_SYSTEM_ITEMS_INTERFACE',
1322: 'INV_VMI_GREATER_THAN_ZERO',
1323: err_text);
1324: if dumm_status < 0 then
1325: raise LOGGING_ERR;

Line 1352: 'MTL_SYSTEM_ITEMS_INTERFACE',

1348: request_id,
1349: cr.TRANSACTION_ID,
1350: error_msg,
1351: 'DAYS_MAX_INV_WINDOW',
1352: 'MTL_SYSTEM_ITEMS_INTERFACE',
1353: 'INV_VMI_INTEGER_VALUE',
1354: err_text);
1355: if dumm_status < 0 then
1356: raise LOGGING_ERR;

Line 1370: 'MTL_SYSTEM_ITEMS_INTERFACE',

1366: request_id,
1367: cr.TRANSACTION_ID,
1368: error_msg,
1369: 'DAYS_MAX_INV_WINDOW',
1370: 'MTL_SYSTEM_ITEMS_INTERFACE',
1371: 'INV_VMI_GREATER_THAN_ZERO',
1372: err_text);
1373: if dumm_status < 0 then
1374: raise LOGGING_ERR;

Line 1401: 'MTL_SYSTEM_ITEMS_INTERFACE',

1397: request_id,
1398: cr.TRANSACTION_ID,
1399: error_msg,
1400: 'DAYS_MAX_INV_SUPPLY',
1401: 'MTL_SYSTEM_ITEMS_INTERFACE',
1402: 'INV_VMI_INTEGER_VALUE',
1403: err_text);
1404: if dumm_status < 0 then
1405: raise LOGGING_ERR;

Line 1419: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1450: 'MTL_SYSTEM_ITEMS_INTERFACE',

1446: request_id,
1447: cr.TRANSACTION_ID,
1448: error_msg,
1449: 'CONSIGNED_FLAG',
1450: 'MTL_SYSTEM_ITEMS_INTERFACE',
1451: 'INV_INVALID_ATTR_COL_VALUE',
1452: err_text);
1453: if dumm_status < 0 then
1454: raise LOGGING_ERR;

Line 1480: 'MTL_SYSTEM_ITEMS_INTERFACE',

1476: request_id,
1477: cr.TRANSACTION_ID,
1478: error_msg,
1479: 'ASN_AUTOEXPIRE_FLAG',
1480: 'MTL_SYSTEM_ITEMS_INTERFACE',
1481: 'INV_INVALID_ATTR_COL_VALUE',
1482: err_text);
1483: if dumm_status < 0 then
1484: raise LOGGING_ERR;

Line 1509: 'MTL_SYSTEM_ITEMS_INTERFACE',

1505: request_id,
1506: cr.TRANSACTION_ID,
1507: error_msg,
1508: 'EXCLUDE_FROM_BUDGET_FLAG',
1509: 'MTL_SYSTEM_ITEMS_INTERFACE',
1510: 'INV_INVALID_ATTR_COL_VALUE',
1511: err_text);
1512: if dumm_status < 0 then
1513: raise LOGGING_ERR;

Line 1538: 'MTL_SYSTEM_ITEMS_INTERFACE',

1534: request_id,
1535: cr.TRANSACTION_ID,
1536: error_msg,
1537: 'DRP_PLANNED_FLAG',
1538: 'MTL_SYSTEM_ITEMS_INTERFACE',
1539: 'INV_INVALID_ATTR_COL_VALUE',
1540: err_text);
1541: if dumm_status < 0 then
1542: raise LOGGING_ERR;

Line 1567: 'MTL_SYSTEM_ITEMS_INTERFACE',

1563: request_id,
1564: cr.TRANSACTION_ID,
1565: error_msg,
1566: 'CRITICAL_COMPONENT_FLAG',
1567: 'MTL_SYSTEM_ITEMS_INTERFACE',
1568: 'INV_INVALID_ATTR_COL_VALUE',
1569: err_text);
1570: if dumm_status < 0 then
1571: raise LOGGING_ERR;

Line 1597: 'MTL_SYSTEM_ITEMS_INTERFACE',

1593: request_id,
1594: cr.TRANSACTION_ID,
1595: error_msg,
1596: 'SO_AUTHORIZATION_FLAG',
1597: 'MTL_SYSTEM_ITEMS_INTERFACE',
1598: 'INV_INVALID_ATTR_COL_VALUE',
1599: err_text);
1600: if dumm_status < 0 then
1601: raise LOGGING_ERR;

Line 1625: 'MTL_SYSTEM_ITEMS_INTERFACE',

1621: request_id,
1622: cr.TRANSACTION_ID,
1623: error_msg,
1624: 'VMI_FORECAST_TYPE',
1625: 'MTL_SYSTEM_ITEMS_INTERFACE',
1626: 'INV_INVALID_ATTR_COL_VALUE',
1627: err_text);
1628: if dumm_status < 0 then
1629: raise LOGGING_ERR;

Line 1653: 'MTL_SYSTEM_ITEMS_INTERFACE',

1649: request_id,
1650: cr.TRANSACTION_ID,
1651: error_msg,
1652: 'CONTINOUS_TRANSFER',
1653: 'MTL_SYSTEM_ITEMS_INTERFACE',
1654: 'INV_INVALID_ATTR_COL_VALUE',
1655: err_text);
1656: if dumm_status < 0 then
1657: raise LOGGING_ERR;

Line 1681: 'MTL_SYSTEM_ITEMS_INTERFACE',

1677: request_id,
1678: cr.TRANSACTION_ID,
1679: error_msg,
1680: 'CONVERGENCE',
1681: 'MTL_SYSTEM_ITEMS_INTERFACE',
1682: 'INV_INVALID_ATTR_COL_VALUE',
1683: err_text);
1684: if dumm_status < 0 then
1685: raise LOGGING_ERR;

Line 1709: 'MTL_SYSTEM_ITEMS_INTERFACE',

1705: request_id,
1706: cr.TRANSACTION_ID,
1707: error_msg,
1708: 'DIVERGENCE',
1709: 'MTL_SYSTEM_ITEMS_INTERFACE',
1710: 'INV_INVALID_ATTR_COL_VALUE',
1711: err_text);
1712: if dumm_status < 0 then
1713: raise LOGGING_ERR;

Line 1744: 'MTL_SYSTEM_ITEMS_INTERFACE',

1740: request_id,
1741: cr.TRANSACTION_ID,
1742: error_msg,
1743: 'SOURCE_TYPE',
1744: 'MTL_SYSTEM_ITEMS_INTERFACE',
1745: 'INV_SOURCE_ORG_MUST_BE_NULL',
1746: err_text);
1747: if dumm_status < 0 then
1748: raise LOGGING_ERR;

Line 1769: 'MTL_SYSTEM_ITEMS_INTERFACE',

1765: request_id,
1766: cr.TRANSACTION_ID,
1767: error_msg,
1768: 'SOURCE_SUBINVENTORY',
1769: 'MTL_SYSTEM_ITEMS_INTERFACE',
1770: 'INV_IOI_SOURCE_SUBINV_REQUIRED',
1771: err_text);
1772: if dumm_status < 0 then
1773: raise LOGGING_ERR;

Line 1804: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1822: 'MTL_SYSTEM_ITEMS_INTERFACE',

1818: request_id,
1819: cr.TRANSACTION_ID,
1820: error_msg,
1821: 'SOURCE_SUBINVENTORY',
1822: 'MTL_SYSTEM_ITEMS_INTERFACE',
1823: 'INV_INTERORG_NTWK',
1824: err_text);
1825: if dumm_status < 0 then
1826: raise LOGGING_ERR;

Line 1856: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1891: 'MTL_SYSTEM_ITEMS_INTERFACE',

1887: request_id,
1888: cr.TRANSACTION_ID,
1889: error_msg,
1890: 'LEAD_TIMES_QUANTITIES',
1891: 'MTL_SYSTEM_ITEMS_INTERFACE',
1892: 'INV_IOI_NEGATIVE_LEAD_TIME_QTY',
1893: err_text);
1894: if dumm_status < 0 then
1895: raise LOGGING_ERR;

Line 1915: 'MTL_SYSTEM_ITEMS_INTERFACE',

1911: request_id,
1912: cr.TRANSACTION_ID,
1913: error_msg,
1914: 'DRP_PLANNED_FLAG',
1915: 'MTL_SYSTEM_ITEMS_INTERFACE',
1916: 'INV_DRP_CANNOT_BE_ATO',
1917: err_text);
1918: if dumm_status < 0 then
1919: raise LOGGING_ERR;

Line 2041: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 2069: from MTL_SYSTEM_ITEMS_INTERFACE

2065: */
2066:
2067: /* Bug 4705184
2068: select process_flag into temp_proc_flag
2069: from MTL_SYSTEM_ITEMS_INTERFACE
2070: where inventory_item_id = l_item_id
2071: and set_process_id + 0 = xset_id
2072: and process_flag in (31, 32, 33, 34, 35, 45)
2073: and organization_id = cr.organization_id

Line 2085: update MTL_SYSTEM_ITEMS_INTERFACE

2081:
2082: if (temp_proc_flag <> 31 and temp_proc_flag <> 32
2083: and temp_proc_flag <> 33 and temp_proc_flag <> 34
2084: and temp_proc_flag <> 35) then
2085: update MTL_SYSTEM_ITEMS_INTERFACE
2086: set process_flag = DECODE(status,0,46,36),
2087: PRIMARY_UOM_CODE = cr.primary_uom_code,
2088: primary_unit_of_measure = cr.primary_unit_of_measure
2089: where inventory_item_id = l_item_id

Line 2115: 'MTL_SYSTEM_ITEMS_INTERFACE',

2111: request_id,
2112: trans_id,
2113: err_text,
2114: 'validation_error ' || stmt,
2115: 'MTL_SYSTEM_ITEMS_INTERFACE',
2116: 'BOM_OP_VALIDATION_ERR',
2117: err_text);
2118: return(status);
2119: