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 1152: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1173: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1203: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1221: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1252: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1270: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1301: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1319: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1350: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1368: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1399: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1417: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1448: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1478: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1507: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1536: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1565: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1595: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1623: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1651: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1679: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1707: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1736: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1760: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1795: 'MTL_SYSTEM_ITEMS_INTERFACE',

1791: request_id,
1792: cr.TRANSACTION_ID,
1793: error_msg,
1794: 'SOURCE_SUBINVENTORY',
1795: 'MTL_SYSTEM_ITEMS_INTERFACE',
1796: 'INV_ITEM_IN_SOURCE_ORG',
1797: err_text);
1798: if dumm_status < 0 then
1799: raise LOGGING_ERR;

Line 1813: 'MTL_SYSTEM_ITEMS_INTERFACE',

1809: request_id,
1810: cr.TRANSACTION_ID,
1811: error_msg,
1812: 'SOURCE_SUBINVENTORY',
1813: 'MTL_SYSTEM_ITEMS_INTERFACE',
1814: 'INV_INTERORG_NTWK',
1815: err_text);
1816: if dumm_status < 0 then
1817: raise LOGGING_ERR;

Line 1847: 'MTL_SYSTEM_ITEMS_INTERFACE',

1843: request_id,
1844: cr.TRANSACTION_ID,
1845: error_msg,
1846: 'TAX_CODE',
1847: 'MTL_SYSTEM_ITEMS_INTERFACE',
1848: 'INV_IOI_TAX_CODE',
1849: err_text);
1850: if dumm_status < 0 then
1851: raise LOGGING_ERR;

Line 1882: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1906: 'MTL_SYSTEM_ITEMS_INTERFACE',

1902: request_id,
1903: cr.TRANSACTION_ID,
1904: error_msg,
1905: 'DRP_PLANNED_FLAG',
1906: 'MTL_SYSTEM_ITEMS_INTERFACE',
1907: 'INV_DRP_CANNOT_BE_ATO',
1908: err_text);
1909: if dumm_status < 0 then
1910: raise LOGGING_ERR;

Line 2032: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 2060: from MTL_SYSTEM_ITEMS_INTERFACE

2056: */
2057:
2058: /* Bug 4705184
2059: select process_flag into temp_proc_flag
2060: from MTL_SYSTEM_ITEMS_INTERFACE
2061: where inventory_item_id = l_item_id
2062: and set_process_id + 0 = xset_id
2063: and process_flag in (31, 32, 33, 34, 35, 45)
2064: and organization_id = cr.organization_id

Line 2076: update MTL_SYSTEM_ITEMS_INTERFACE

2072:
2073: if (temp_proc_flag <> 31 and temp_proc_flag <> 32
2074: and temp_proc_flag <> 33 and temp_proc_flag <> 34
2075: and temp_proc_flag <> 35) then
2076: update MTL_SYSTEM_ITEMS_INTERFACE
2077: set process_flag = DECODE(status,0,46,36),
2078: PRIMARY_UOM_CODE = cr.primary_uom_code,
2079: primary_unit_of_measure = cr.primary_unit_of_measure
2080: where inventory_item_id = l_item_id

Line 2105: 'MTL_SYSTEM_ITEMS_INTERFACE',

2101: request_id,
2102: trans_id,
2103: err_text,
2104: 'validation_error ' || stmt,
2105: 'MTL_SYSTEM_ITEMS_INTERFACE',
2106: 'BOM_OP_VALIDATION_ERR',
2107: err_text);
2108: return(status);
2109: