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 = org_id) or -- fix for bug#8757041,removed + 0
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_IVLD_PCENT_VALUE',--bug 11894684, replace INV_IOI_ERR
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 1499: 'MTL_SYSTEM_ITEMS_INTERFACE',

1495: request_id,
1496: cr.TRANSACTION_ID,
1497: error_msg,
1498: 'OUTSOURCED_ASSEMBLY',
1499: 'MTL_SYSTEM_ITEMS_INTERFACE',
1500: 'INV_OS_ASMBLY_INVALID_ORG',
1501: err_text );
1502: IF dumm_status < 0 THEN
1503: RAISE LOGGING_ERR;

Line 1526: -- 'MTL_SYSTEM_ITEMS_INTERFACE',

1522: -- request_id,
1523: -- cr.TRANSACTION_ID,
1524: -- error_msg,
1525: -- 'OUTSOURCED_ASSEMBLY',
1526: -- 'MTL_SYSTEM_ITEMS_INTERFACE',
1527: -- 'INV_OS_ASMBLY_STD_COST_ORG',
1528: -- err_text );
1529: -- IF dumm_status < 0 THEN
1530: -- RAISE LOGGING_ERR;

Line 1550: 'MTL_SYSTEM_ITEMS_INTERFACE',

1546: request_id,
1547: cr.TRANSACTION_ID,
1548: error_msg,
1549: 'OUTSOURCED_ASSEMBLY',
1550: 'MTL_SYSTEM_ITEMS_INTERFACE',
1551: 'INV_OS_ASMBLY_INVALID_BOM_ATTR',
1552: err_text );
1553: IF dumm_status < 0 THEN
1554: RAISE LOGGING_ERR;

Line 1573: 'MTL_SYSTEM_ITEMS_INTERFACE',

1569: request_id,
1570: cr.transaction_id,
1571: error_msg,
1572: 'INVENTORY_ITEM_FLAG',
1573: 'MTL_SYSTEM_ITEMS_INTERFACE',
1574: 'INV_BOM_ITEM_TYPE_PF_INV',
1575: err_text);
1576: IF dumm_status < 0 THEN
1577: RAISE LOGGING_ERR;

Line 1595: 'MTL_SYSTEM_ITEMS_INTERFACE',

1591: request_id,
1592: cr.transaction_id,
1593: error_msg,
1594: 'PLANNING_MAKE_BUY_CODE',
1595: 'MTL_SYSTEM_ITEMS_INTERFACE',
1596: 'INV_PLANNING_MAKE_BUY_CODE',
1597: err_text);
1598: IF dumm_status < 0 THEN
1599: RAISE LOGGING_ERR;

Line 1620: 'MTL_SYSTEM_ITEMS_INTERFACE',

1616: request_id,
1617: cr.TRANSACTION_ID,
1618: error_msg,
1619: 'OUTSOURCED_ASSEMBLY',
1620: 'MTL_SYSTEM_ITEMS_INTERFACE',
1621: 'INV_OS_ASMBLY_OUTSIDE_OPRN',
1622: err_text );
1623: IF dumm_status < 0 THEN
1624: RAISE LOGGING_ERR;

Line 1642: 'MTL_SYSTEM_ITEMS_INTERFACE',

1638: request_id,
1639: cr.TRANSACTION_ID,
1640: error_msg,
1641: 'OUTSOURCED_ASSEMBLY',
1642: 'MTL_SYSTEM_ITEMS_INTERFACE',
1643: 'INV_OS_ASMBLY_INVALID_OM_ATTR',
1644: err_text );
1645: IF dumm_status < 0 THEN
1646: RAISE LOGGING_ERR;

Line 1667: 'MTL_SYSTEM_ITEMS_INTERFACE',

1663: request_id,
1664: cr.TRANSACTION_ID,
1665: error_msg,
1666: 'SUBCONTRACTING_COMPONENT',
1667: 'MTL_SYSTEM_ITEMS_INTERFACE',
1668: 'INV_SUBCONTR_COMP_NO_JMF_PRFL',
1669: err_text );
1670: IF dumm_status < 0 THEN
1671: RAISE LOGGING_ERR;

Line 1697: 'MTL_SYSTEM_ITEMS_INTERFACE',

1693: request_id,
1694: cr.TRANSACTION_ID,
1695: error_msg,
1696: 'SUBCONTRACTING_COMPONENT',
1697: 'MTL_SYSTEM_ITEMS_INTERFACE',
1698: 'INV_OS_ASMBLY_INVALID_ORG',
1699: err_text );
1700: IF dumm_status < 0 THEN
1701: RAISE LOGGING_ERR;

Line 1719: 'MTL_SYSTEM_ITEMS_INTERFACE',

1715: request_id,
1716: cr.TRANSACTION_ID,
1717: error_msg,
1718: 'SUBCONTRACTING_COMPONENT',
1719: 'MTL_SYSTEM_ITEMS_INTERFACE',
1720: 'INV_SUBCONTR_COMP_STD_COST_ORG',
1721: err_text );
1722: IF dumm_status < 0 THEN
1723: RAISE LOGGING_ERR;

Line 1749: from MTL_SYSTEM_ITEMS_INTERFACE

1745: */
1746:
1747: /* Bug 4705184
1748: select process_flag into temp_proc_flag
1749: from MTL_SYSTEM_ITEMS_INTERFACE
1750: where inventory_item_id = l_item_id
1751: and set_process_id + 0 = xset_id
1752: and process_flag in (3,31,32,33,34,35,36,46) --3571136
1753: and organization_id = cr.organization_id

Line 1768: update MTL_SYSTEM_ITEMS_INTERFACE

1764:
1765: if (temp_proc_flag = 46 ) then
1766: /*The validations are all clear up until this package*/
1767:
1768: update MTL_SYSTEM_ITEMS_INTERFACE
1769: set process_flag = DECODE(status,0,4,3),
1770: PRIMARY_UOM_CODE = cr.primary_uom_code,
1771: primary_unit_of_measure = cr.primary_unit_of_measure
1772: where inventory_item_id = l_item_id

Line 1790: update MTL_SYSTEM_ITEMS_INTERFACE

1786: /*there is some validation problem somewhere: process
1787: **flag is one of 31,32,33,34,35,36:
1788: **Set it to 3 unconditionally*/
1789:
1790: update MTL_SYSTEM_ITEMS_INTERFACE
1791: set process_flag = 3,
1792: PRIMARY_UOM_CODE = cr.primary_uom_code,
1793: primary_unit_of_measure = cr.primary_unit_of_measure,
1794: request_id = reqst_id,

Line 1857: 'MTL_SYSTEM_ITEMS_INTERFACE',

1853: request_id,
1854: trans_id,
1855: err_text,
1856: 'validation_error ' || stmt,
1857: 'MTL_SYSTEM_ITEMS_INTERFACE',
1858: 'BOM_OP_VALIDATION_ERR',
1859: err_text);
1860: return(status);
1861: when OTHERS then