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

Line 26: from MTL_SYSTEM_ITEMS_INTERFACE intf

22: ** Retrieve column values for validation
23: */
24: CURSOR cc is
25: select intf.ROWID, intf.*
26: from MTL_SYSTEM_ITEMS_INTERFACE intf
27: where ((organization_id + 0 = org_id) or
28: (all_Org = 1))
29: and set_process_id = xset_id
30: and process_flag in (31, 32, 33, 34, 35, 36, 46);

Line 112: from mtl_system_items_interface

108:
109: /* Bug 4705184
110: select inventory_item_id
111: into l_item_id
112: from mtl_system_items_interface
113: where transaction_id = cr.transaction_id
114: and set_process_id = xset_id; */
115:
116: open c_org_loc_control(cr.organization_id);

Line 167: 'MTL_SYSTEM_ITEMS_INTERFACE',

163: request_id,
164: cr.TRANSACTION_ID,
165: error_msg,
166: 'LOT_DIVISIBLE_FLAG',
167: 'MTL_SYSTEM_ITEMS_INTERFACE',
168: 'INV_IOI_FLAG_Y_N_NULL',
169: err_text );
170: IF dumm_status < 0 THEN
171: raise LOGGING_ERR;

Line 188: 'MTL_SYSTEM_ITEMS_INTERFACE',

184: request_id,
185: cr.TRANSACTION_ID,
186: error_msg,
187: 'LOT_DIVISIBLE_FLAG',
188: 'MTL_SYSTEM_ITEMS_INTERFACE',
189: 'INV_INVALID_LOT_DIVISIBLE',
190: err_text);
191: if dumm_status < 0 then
192: raise LOGGING_ERR;

Line 213: 'MTL_SYSTEM_ITEMS_INTERFACE',

209: request_id,
210: cr.TRANSACTION_ID,
211: error_msg,
212: 'GRADE_CONTROL_FLAG',
213: 'MTL_SYSTEM_ITEMS_INTERFACE',
214: 'INV_IOI_FLAG_Y_N_NULL',
215: err_text );
216: IF dumm_status < 0 THEN
217: raise LOGGING_ERR;

Line 235: 'MTL_SYSTEM_ITEMS_INTERFACE',

231: request_id,
232: cr.TRANSACTION_ID,
233: error_msg,
234: 'GRADE_CONTROL_FLAG',
235: 'MTL_SYSTEM_ITEMS_INTERFACE',
236: 'INV_INVALID_GRADE_CONTROL',
237: err_text);
238: if dumm_status < 0 then
239: raise LOGGING_ERR;

Line 263: 'MTL_SYSTEM_ITEMS_INTERFACE',

259: request_id,
260: cr.TRANSACTION_ID,
261: error_msg,
262: 'DEFAULT_GRADE',
263: 'MTL_SYSTEM_ITEMS_INTERFACE',
264: 'INV_INVALID_DEFAULT_GRADE_NULL',
265: err_text);
266: if dumm_status < 0 then
267: raise LOGGING_ERR;

Line 291: 'MTL_SYSTEM_ITEMS_INTERFACE',

287: request_id,
288: cr.TRANSACTION_ID,
289: error_msg,
290: 'DEFAULT_GRADE',
291: 'MTL_SYSTEM_ITEMS_INTERFACE',
292: 'INV_INVALID_DEFAULT_GRADE',
293: err_text);
294:
295: if dumm_status < 0 then

Line 315: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 345: 'MTL_SYSTEM_ITEMS_INTERFACE',

341: request_id,
342: cr.TRANSACTION_ID,
343: error_msg,
344: 'CHILD_LOT_FLAG',
345: 'MTL_SYSTEM_ITEMS_INTERFACE',
346: 'INV_IOI_FLAG_Y_N_NULL',
347: err_text );
348: IF dumm_status < 0 THEN
349: raise LOGGING_ERR;

Line 367: 'MTL_SYSTEM_ITEMS_INTERFACE',

363: request_id,
364: cr.TRANSACTION_ID,
365: error_msg,
366: 'CHILD_LOT_FLAG',
367: 'MTL_SYSTEM_ITEMS_INTERFACE',
368: 'INV_INVALID_CHILD_LOT_FLAG',
369: err_text);
370: if dumm_status < 0 then
371: raise LOGGING_ERR;

Line 414: 'MTL_SYSTEM_ITEMS_INTERFACE',

410: request_id,
411: cr.TRANSACTION_ID,
412: error_msg,
413: 'PARENT_CHILD_GENERATION_FLAG',
414: 'MTL_SYSTEM_ITEMS_INTERFACE',
415: l_msg_name,
416: err_text);
417: if dumm_status < 0 then
418: raise LOGGING_ERR;

Line 436: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 467: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 492: 'MTL_SYSTEM_ITEMS_INTERFACE',

488: request_id,
489: cr.TRANSACTION_ID,
490: error_msg,
491: 'CHILD_LOT_STARTING_NUMBER',
492: 'MTL_SYSTEM_ITEMS_INTERFACE',
493: 'INV_INVALID_CHILD_LOT_START_NO',
494: err_text);
495: if dumm_status < 0 then
496: raise LOGGING_ERR;

Line 514: 'MTL_SYSTEM_ITEMS_INTERFACE',

510: request_id,
511: cr.TRANSACTION_ID,
512: error_msg,
513: 'CHILD_LOT_STARTING_NUMBER',
514: 'MTL_SYSTEM_ITEMS_INTERFACE',
515: 'INV_INVALID_CHILD_LOT_START_NO',
516: err_text);
517: if dumm_status < 0 then
518: raise LOGGING_ERR;

Line 536: 'MTL_SYSTEM_ITEMS_INTERFACE',

532: request_id,
533: cr.TRANSACTION_ID,
534: error_msg,
535: 'CHILD_LOT_STARTING_NUMBER',
536: 'MTL_SYSTEM_ITEMS_INTERFACE',
537: 'INV_INVALID_CHILD_LOT_START_NO',
538: err_text);
539: if dumm_status < 0 then
540: raise LOGGING_ERR;

Line 563: 'MTL_SYSTEM_ITEMS_INTERFACE',

559: request_id,
560: cr.TRANSACTION_ID,
561: error_msg,
562: 'CHILD_LOT_VALIDATION_FLAG',
563: 'MTL_SYSTEM_ITEMS_INTERFACE',
564: 'INV_IOI_FLAG_Y_N_NULL',
565: err_text );
566: IF dumm_status < 0 THEN
567: raise LOGGING_ERR;

Line 591: 'MTL_SYSTEM_ITEMS_INTERFACE',

587: request_id,
588: cr.TRANSACTION_ID,
589: error_msg,
590: 'COPY_LOT_ATTRIBUTE_FLAG',
591: 'MTL_SYSTEM_ITEMS_INTERFACE',
592: 'INV_IOI_FLAG_Y_N_NULL',
593: err_text );
594: IF dumm_status < 0 THEN
595: raise LOGGING_ERR;

Line 614: 'MTL_SYSTEM_ITEMS_INTERFACE',

610: request_id,
611: cr.TRANSACTION_ID,
612: error_msg,
613: 'RECIPE_ENABLED_FLAG',
614: 'MTL_SYSTEM_ITEMS_INTERFACE',
615: 'INV_IOI_FLAG_Y_N_NULL',
616: err_text );
617: IF dumm_status < 0 THEN
618: raise LOGGING_ERR;

Line 637: 'MTL_SYSTEM_ITEMS_INTERFACE',

633: request_id,
634: cr.TRANSACTION_ID,
635: error_msg,
636: 'PROCESS_EXECUTION_ENABLED_FLAG',
637: 'MTL_SYSTEM_ITEMS_INTERFACE',
638: 'INV_IOI_FLAG_Y_N_NULL',
639: err_text );
640: IF dumm_status < 0 THEN
641: raise LOGGING_ERR;

Line 661: 'MTL_SYSTEM_ITEMS_INTERFACE',

657: request_id,
658: cr.TRANSACTION_ID,
659: error_msg,
660: 'PROCESS_EXECUTION_ENABLED_FLAG',
661: 'MTL_SYSTEM_ITEMS_INTERFACE',
662: 'INV_PR_EXEC_NOT_ALLOWED',
663: err_text );
664: IF dumm_status < 0 THEN
665: raise LOGGING_ERR;

Line 685: 'MTL_SYSTEM_ITEMS_INTERFACE',

681: request_id,
682: cr.TRANSACTION_ID,
683: error_msg,
684: 'PROCESS_COSTING_ENABLED_FLAG',
685: 'MTL_SYSTEM_ITEMS_INTERFACE',
686: 'INV_IOI_FLAG_Y_N_NULL',
687: err_text );
688: IF dumm_status < 0 THEN
689: raise LOGGING_ERR;

Line 708: 'MTL_SYSTEM_ITEMS_INTERFACE',

704: request_id,
705: cr.TRANSACTION_ID,
706: error_msg,
707: 'PROCESS_QUALITY_ENABLED_FLAG',
708: 'MTL_SYSTEM_ITEMS_INTERFACE',
709: 'INV_IOI_FLAG_Y_N_NULL',
710: err_text );
711: IF dumm_status < 0 THEN
712: raise LOGGING_ERR;

Line 770: 'MTL_SYSTEM_ITEMS_INTERFACE',

766: request_id,
767: cr.TRANSACTION_ID,
768: error_msg,
769: 'PROCESS_SUPPLY_SUBINVENTORY',
770: 'MTL_SYSTEM_ITEMS_INTERFACE',
771: l_message_name,
772: err_text);
773: if dumm_status < 0 then
774: raise LOGGING_ERR;

Line 822: 'MTL_SYSTEM_ITEMS_INTERFACE',

818: request_id,
819: cr.TRANSACTION_ID,
820: error_msg,
821: 'PROCESS_SUPPLY_LOCATOR_ID',
822: 'MTL_SYSTEM_ITEMS_INTERFACE',
823: 'INV_IOI_PROCESS_SUP_LOC_ID',
824: err_text);
825: if dumm_status < 0 THEN
826: raise LOGGING_ERR;

Line 886: 'MTL_SYSTEM_ITEMS_INTERFACE',

882: request_id,
883: cr.TRANSACTION_ID,
884: error_msg,
885: 'PROCESS_SUPPLY_LOCATOR_ID',
886: 'MTL_SYSTEM_ITEMS_INTERFACE',
887: 'INV_IOI_PROCESS_SUP_LOC_ID',
888: err_text);
889: if dumm_status < 0 then
890: raise LOGGING_ERR;

Line 954: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1005: 'MTL_SYSTEM_ITEMS_INTERFACE',

1001: request_id,
1002: cr.TRANSACTION_ID,
1003: error_msg,
1004: 'PROCESS_YIELD_LOCATOR_ID',
1005: 'MTL_SYSTEM_ITEMS_INTERFACE',
1006: 'INV_IOI_PROCESS_YLD_LOC_ID',
1007: err_text);
1008: if dumm_status < 0 THEN
1009: raise LOGGING_ERR;

Line 1063: 'MTL_SYSTEM_ITEMS_INTERFACE',

1059: request_id,
1060: cr.TRANSACTION_ID,
1061: error_msg,
1062: 'PROCESS_YIELD_LOCATOR_ID',
1063: 'MTL_SYSTEM_ITEMS_INTERFACE',
1064: 'INV_IOI_PROCESS_YLD_LOC_ID',
1065: err_text);
1066: if dumm_status < 0 then
1067: raise LOGGING_ERR;

Line 1096: 'MTL_SYSTEM_ITEMS_INTERFACE',

1092: request_id,
1093: cr.TRANSACTION_ID,
1094: error_msg,
1095: 'EXPIRATION_ACTION_CODE',
1096: 'MTL_SYSTEM_ITEMS_INTERFACE',
1097: 'INV_INVALID_EXPRTN_ACTN_CODE',
1098: err_text);
1099:
1100: if dumm_status < 0 then

Line 1125: 'MTL_SYSTEM_ITEMS_INTERFACE',

1121: request_id,
1122: cr.TRANSACTION_ID,
1123: error_msg,
1124: 'RETEST_INTERVAL',
1125: 'MTL_SYSTEM_ITEMS_INTERFACE',
1126: 'INV_INVALID_RETEST_INTERVAL',
1127: err_text);
1128: if dumm_status < 0 then
1129: raise LOGGING_ERR;

Line 1153: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1182: 'MTL_SYSTEM_ITEMS_INTERFACE',

1178: request_id,
1179: cr.TRANSACTION_ID,
1180: error_msg,
1181: 'MATURITY_DAYS',
1182: 'MTL_SYSTEM_ITEMS_INTERFACE',
1183: 'INV_INVALID_MATURITY_DAYS',
1184: err_text);
1185: if dumm_status < 0 then
1186: raise LOGGING_ERR;

Line 1211: 'MTL_SYSTEM_ITEMS_INTERFACE',

1207: request_id,
1208: cr.TRANSACTION_ID,
1209: error_msg,
1210: 'HOLD_DAYS',
1211: 'MTL_SYSTEM_ITEMS_INTERFACE',
1212: 'INV_INVALID_HOLD_DAYS',
1213: err_text);
1214: if dumm_status < 0 then
1215: raise LOGGING_ERR;

Line 1237: 'MTL_SYSTEM_ITEMS_INTERFACE',

1233: request_id,
1234: cr.TRANSACTION_ID,
1235: error_msg,
1236: 'HAZARDOUS_MATERIAL_FLAG',
1237: 'MTL_SYSTEM_ITEMS_INTERFACE',
1238: 'INV_IOI_FLAG_Y_N_NULL',
1239: err_text );
1240: IF dumm_status < 0 THEN
1241: raise LOGGING_ERR;

Line 1271: 'MTL_SYSTEM_ITEMS_INTERFACE',

1267: request_id,
1268: cr.TRANSACTION_ID,
1269: error_msg,
1270: 'CHARGE_PERIODICITY_CODE',
1271: 'MTL_SYSTEM_ITEMS_INTERFACE',
1272: 'INV_IOI_INVALID_CHARGE_CODE',
1273: err_text );
1274:
1275: IF dumm_status < 0 THEN

Line 1296: 'MTL_SYSTEM_ITEMS_INTERFACE',

1292: request_id,
1293: cr.TRANSACTION_ID,
1294: error_msg,
1295: 'REPAIR_LEADTIME',
1296: 'MTL_SYSTEM_ITEMS_INTERFACE',
1297: 'INV_INVALID_ATTR_COL_VALUE',
1298: err_text );
1299: IF dumm_status < 0 THEN
1300: RAISE LOGGING_ERR;

Line 1328: 'MTL_SYSTEM_ITEMS_INTERFACE',

1324: request_id,
1325: cr.TRANSACTION_ID,
1326: error_msg,
1327: 'REPAIR_YIELD',
1328: 'MTL_SYSTEM_ITEMS_INTERFACE',
1329: 'INV_IOI_ERR',--Bug 5216657
1330: err_text );
1331: IF dumm_status < 0 THEN
1332: RAISE LOGGING_ERR;

Line 1351: 'MTL_SYSTEM_ITEMS_INTERFACE',

1347: request_id,
1348: cr.TRANSACTION_ID,
1349: error_msg,
1350: 'PREPOSITION_POINT',
1351: 'MTL_SYSTEM_ITEMS_INTERFACE',
1352: 'INV_INVALID_ATTR_COL_VALUE',
1353: err_text );
1354: IF dumm_status < 0 THEN
1355: RAISE LOGGING_ERR;

Line 1374: 'MTL_SYSTEM_ITEMS_INTERFACE',

1370: request_id,
1371: cr.TRANSACTION_ID,
1372: error_msg,
1373: 'REPAIR_PROGRAM',
1374: 'MTL_SYSTEM_ITEMS_INTERFACE',
1375: 'INV_INVALID_ATTR_COL_VALUE',
1376: err_text );
1377: IF dumm_status < 0 THEN
1378: RAISE LOGGING_ERR;

Line 1399: 'MTL_SYSTEM_ITEMS_INTERFACE',

1395: request_id,
1396: cr.TRANSACTION_ID,
1397: error_msg,
1398: 'SUBCONTRACTING_COMPONENT',
1399: 'MTL_SYSTEM_ITEMS_INTERFACE',
1400: 'INV_INVALID_ATTR_COL_VALUE',
1401: err_text );
1402: IF dumm_status < 0 THEN
1403: RAISE LOGGING_ERR;

Line 1422: 'MTL_SYSTEM_ITEMS_INTERFACE',

1418: request_id,
1419: cr.TRANSACTION_ID,
1420: error_msg,
1421: 'OUTSOURCED_ASSEMBLY',
1422: 'MTL_SYSTEM_ITEMS_INTERFACE',
1423: 'INV_INVALID_ATTR_COL_VALUE',
1424: err_text );
1425: IF dumm_status < 0 THEN
1426: RAISE LOGGING_ERR;

Line 1445: 'MTL_SYSTEM_ITEMS_INTERFACE',

1441: request_id,
1442: cr.TRANSACTION_ID,
1443: error_msg,
1444: 'OUTSOURCED_ASSEMBLY',
1445: 'MTL_SYSTEM_ITEMS_INTERFACE',
1446: 'INV_OS_ASMBLY_NO_JMF_PROFILE',
1447: err_text );
1448: IF dumm_status < 0 THEN
1449: RAISE LOGGING_ERR;

Line 1469: 'MTL_SYSTEM_ITEMS_INTERFACE',

1465: request_id,
1466: cr.TRANSACTION_ID,
1467: error_msg,
1468: 'OUTSOURCED_ASSEMBLY',
1469: 'MTL_SYSTEM_ITEMS_INTERFACE',
1470: 'INV_OS_ASMBLY_TP_TIME_FENSE',
1471: err_text );
1472: IF dumm_status < 0 THEN
1473: RAISE LOGGING_ERR;

Line 1494: 'MTL_SYSTEM_ITEMS_INTERFACE',

1490: request_id,
1491: cr.TRANSACTION_ID,
1492: error_msg,
1493: 'OUTSOURCED_ASSEMBLY',
1494: 'MTL_SYSTEM_ITEMS_INTERFACE',
1495: 'INV_OS_ASMBLY_INVALID_ORG',
1496: err_text );
1497: IF dumm_status < 0 THEN
1498: RAISE LOGGING_ERR;

Line 1521: -- 'MTL_SYSTEM_ITEMS_INTERFACE',

1517: -- request_id,
1518: -- cr.TRANSACTION_ID,
1519: -- error_msg,
1520: -- 'OUTSOURCED_ASSEMBLY',
1521: -- 'MTL_SYSTEM_ITEMS_INTERFACE',
1522: -- 'INV_OS_ASMBLY_STD_COST_ORG',
1523: -- err_text );
1524: -- IF dumm_status < 0 THEN
1525: -- RAISE LOGGING_ERR;

Line 1545: 'MTL_SYSTEM_ITEMS_INTERFACE',

1541: request_id,
1542: cr.TRANSACTION_ID,
1543: error_msg,
1544: 'OUTSOURCED_ASSEMBLY',
1545: 'MTL_SYSTEM_ITEMS_INTERFACE',
1546: 'INV_OS_ASMBLY_INVALID_BOM_ATTR',
1547: err_text );
1548: IF dumm_status < 0 THEN
1549: RAISE LOGGING_ERR;

Line 1568: 'MTL_SYSTEM_ITEMS_INTERFACE',

1564: request_id,
1565: cr.transaction_id,
1566: error_msg,
1567: 'INVENTORY_ITEM_FLAG',
1568: 'MTL_SYSTEM_ITEMS_INTERFACE',
1569: 'INV_BOM_ITEM_TYPE_PF_INV',
1570: err_text);
1571: IF dumm_status < 0 THEN
1572: RAISE LOGGING_ERR;

Line 1590: 'MTL_SYSTEM_ITEMS_INTERFACE',

1586: request_id,
1587: cr.transaction_id,
1588: error_msg,
1589: 'PLANNING_MAKE_BUY_CODE',
1590: 'MTL_SYSTEM_ITEMS_INTERFACE',
1591: 'INV_PLANNING_MAKE_BUY_CODE',
1592: err_text);
1593: IF dumm_status < 0 THEN
1594: RAISE LOGGING_ERR;

Line 1615: 'MTL_SYSTEM_ITEMS_INTERFACE',

1611: request_id,
1612: cr.TRANSACTION_ID,
1613: error_msg,
1614: 'OUTSOURCED_ASSEMBLY',
1615: 'MTL_SYSTEM_ITEMS_INTERFACE',
1616: 'INV_OS_ASMBLY_OUTSIDE_OPRN',
1617: err_text );
1618: IF dumm_status < 0 THEN
1619: RAISE LOGGING_ERR;

Line 1637: 'MTL_SYSTEM_ITEMS_INTERFACE',

1633: request_id,
1634: cr.TRANSACTION_ID,
1635: error_msg,
1636: 'OUTSOURCED_ASSEMBLY',
1637: 'MTL_SYSTEM_ITEMS_INTERFACE',
1638: 'INV_OS_ASMBLY_INVALID_OM_ATTR',
1639: err_text );
1640: IF dumm_status < 0 THEN
1641: RAISE LOGGING_ERR;

Line 1662: 'MTL_SYSTEM_ITEMS_INTERFACE',

1658: request_id,
1659: cr.TRANSACTION_ID,
1660: error_msg,
1661: 'SUBCONTRACTING_COMPONENT',
1662: 'MTL_SYSTEM_ITEMS_INTERFACE',
1663: 'INV_SUBCONTR_COMP_NO_JMF_PRFL',
1664: err_text );
1665: IF dumm_status < 0 THEN
1666: RAISE LOGGING_ERR;

Line 1686: 'MTL_SYSTEM_ITEMS_INTERFACE',

1682: request_id,
1683: cr.TRANSACTION_ID,
1684: error_msg,
1685: 'SUBCONTRACTING_COMPONENT',
1686: 'MTL_SYSTEM_ITEMS_INTERFACE',
1687: 'INV_OS_ASMBLY_INVALID_ORG',
1688: err_text );
1689: IF dumm_status < 0 THEN
1690: RAISE LOGGING_ERR;

Line 1706: 'MTL_SYSTEM_ITEMS_INTERFACE',

1702: request_id,
1703: cr.TRANSACTION_ID,
1704: error_msg,
1705: 'SUBCONTRACTING_COMPONENT',
1706: 'MTL_SYSTEM_ITEMS_INTERFACE',
1707: 'INV_SUBCONTR_COMP_STD_COST_ORG',
1708: err_text );
1709: IF dumm_status < 0 THEN
1710: RAISE LOGGING_ERR;

Line 1736: from MTL_SYSTEM_ITEMS_INTERFACE

1732: */
1733:
1734: /* Bug 4705184
1735: select process_flag into temp_proc_flag
1736: from MTL_SYSTEM_ITEMS_INTERFACE
1737: where inventory_item_id = l_item_id
1738: and set_process_id + 0 = xset_id
1739: and process_flag in (3,31,32,33,34,35,36,46) --3571136
1740: and organization_id = cr.organization_id

Line 1755: update MTL_SYSTEM_ITEMS_INTERFACE

1751:
1752: if (temp_proc_flag = 46 ) then
1753: /*The validations are all clear up until this package*/
1754:
1755: update MTL_SYSTEM_ITEMS_INTERFACE
1756: set process_flag = DECODE(status,0,4,3),
1757: PRIMARY_UOM_CODE = cr.primary_uom_code,
1758: primary_unit_of_measure = cr.primary_unit_of_measure
1759: where inventory_item_id = l_item_id

Line 1776: update MTL_SYSTEM_ITEMS_INTERFACE

1772: /*there is some validation problem somewhere: process
1773: **flag is one of 31,32,33,34,35,36:
1774: **Set it to 3 unconditionally*/
1775:
1776: update MTL_SYSTEM_ITEMS_INTERFACE
1777: set process_flag = 3,
1778: PRIMARY_UOM_CODE = cr.primary_uom_code,
1779: primary_unit_of_measure = cr.primary_unit_of_measure,
1780: request_id = reqst_id,

Line 1842: 'MTL_SYSTEM_ITEMS_INTERFACE',

1838: request_id,
1839: trans_id,
1840: err_text,
1841: 'validation_error ' || stmt,
1842: 'MTL_SYSTEM_ITEMS_INTERFACE',
1843: 'BOM_OP_VALIDATION_ERR',
1844: err_text);
1845: return(status);
1846: when OTHERS then