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

Line 77: FROM MTL_SYSTEM_ITEMS_INTERFACE

73: CONTRACT_ITEM_TYPE_CODE,
74: --R12 FPC
75: GDSN_OUTBOUND_ENABLED_FLAG,
76: STYLE_ITEM_FLAG
77: FROM MTL_SYSTEM_ITEMS_INTERFACE
78: --3515652: Performance enhancements
79: WHERE ((organization_id = org_id) or (all_Org = 1))
80: AND set_process_id = xset_id
81: AND process_flag in (31, 32, 33, 34 , 35 , 45);

Line 109: l_prev_uom_code MTL_SYSTEM_ITEMS_INTERFACE.service_duration_period_code%TYPE := '!'; --Bug: 4654433

105: l_status VARCHAR2(10);
106: l_industry VARCHAR2(10);
107: bill_value VARCHAR2(2000);
108: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
109: l_prev_uom_code MTL_SYSTEM_ITEMS_INTERFACE.service_duration_period_code%TYPE := '!'; --Bug: 4654433
110: l_serv_dur_per_code_err NUMBER := 0; --Bug: 4654433
111:
112:
113: BEGIN

Line 139: 'MTL_SYSTEM_ITEMS_INTERFACE',

135: request_id,
136: cr.TRANSACTION_ID,
137: error_msg,
138: 'PURCHASING_ITEM_FLAG',
139: 'MTL_SYSTEM_ITEMS_INTERFACE',
140: 'INV_IOI_FLAG_Y_N',
141: err_text);
142: IF dumm_status < 0 THEN
143: raise LOGGING_ERR;

Line 161: 'MTL_SYSTEM_ITEMS_INTERFACE',

157: request_id,
158: cr.TRANSACTION_ID,
159: error_msg,
160: 'SHIPPABLE_ITEM_FLAG',
161: 'MTL_SYSTEM_ITEMS_INTERFACE',
162: 'INV_IOI_FLAG_Y_N',
163: err_text);
164: IF dumm_status < 0 THEN
165: RAISE LOGGING_ERR;

Line 183: 'MTL_SYSTEM_ITEMS_INTERFACE',

179: request_id,
180: cr.TRANSACTION_ID,
181: error_msg,
182: 'CUSTOMER_ORDER_FLAG',
183: 'MTL_SYSTEM_ITEMS_INTERFACE',
184: 'INV_IOI_FLAG_Y_N',
185: err_text);
186: IF dumm_status < 0 THEN
187: RAISE LOGGING_ERR;

Line 205: 'MTL_SYSTEM_ITEMS_INTERFACE',

201: request_id,
202: cr.TRANSACTION_ID,
203: error_msg,
204: 'INTERNAL_ORDER_FLAG',
205: 'MTL_SYSTEM_ITEMS_INTERFACE',
206: 'INV_IOI_FLAG_Y_N',
207: err_text);
208: if dumm_status < 0 then
209: raise LOGGING_ERR;

Line 230: 'MTL_SYSTEM_ITEMS_INTERFACE',

226: request_id,
227: cr.TRANSACTION_ID,
228: error_msg,
229: 'CONTRACT_ITEM_TYPE_CODE',
230: 'MTL_SYSTEM_ITEMS_INTERFACE',
231: 'INV_INVALID_ATTR_COL_VALUE',
232: err_text);
233: if dumm_status < 0 then
234: raise LOGGING_ERR;

Line 252: 'MTL_SYSTEM_ITEMS_INTERFACE',

248: request_id,
249: cr.TRANSACTION_ID,
250: error_msg,
251: 'INVENTORY_ITEM_FLAG',
252: 'MTL_SYSTEM_ITEMS_INTERFACE',
253: 'INV_IOI_FLAG_Y_N',
254: err_text);
255: if dumm_status < 0 then
256: raise LOGGING_ERR;

Line 274: 'MTL_SYSTEM_ITEMS_INTERFACE',

270: request_id,
271: cr.TRANSACTION_ID,
272: error_msg,
273: 'ENG_ITEM_FLAG',
274: 'MTL_SYSTEM_ITEMS_INTERFACE',
275: 'INV_IOI_FLAG_Y_N',
276: err_text);
277: if dumm_status < 0 then
278: raise LOGGING_ERR;

Line 296: 'MTL_SYSTEM_ITEMS_INTERFACE',

292: request_id,
293: cr.TRANSACTION_ID,
294: error_msg,
295: 'INVENTORY_ASSET_FLAG',
296: 'MTL_SYSTEM_ITEMS_INTERFACE',
297: 'INV_IOI_FLAG_Y_N',
298: err_text);
299: if dumm_status < 0 then
300: raise LOGGING_ERR;

Line 318: 'MTL_SYSTEM_ITEMS_INTERFACE',

314: request_id,
315: cr.TRANSACTION_ID,
316: error_msg,
317: 'PURCHASING_ENABLED_FLAG',
318: 'MTL_SYSTEM_ITEMS_INTERFACE',
319: 'INV_IOI_FLAG_Y_N',
320: err_text);
321: if dumm_status < 0 then
322: raise LOGGING_ERR;

Line 341: 'MTL_SYSTEM_ITEMS_INTERFACE',

337: request_id,
338: cr.TRANSACTION_ID,
339: error_msg,
340: 'CUSTOMER_ORDER_ENABLED_FLAG',
341: 'MTL_SYSTEM_ITEMS_INTERFACE',
342: 'INV_IOI_FLAG_Y_N',
343: err_text);
344: if dumm_status < 0 then
345: raise LOGGING_ERR;

Line 363: 'MTL_SYSTEM_ITEMS_INTERFACE',

359: request_id,
360: cr.TRANSACTION_ID,
361: error_msg,
362: 'INTERNAL_ORDER_ENABLED_FLAG',
363: 'MTL_SYSTEM_ITEMS_INTERFACE',
364: 'INV_IOI_FLAG_Y_N',
365: err_text);
366: if dumm_status < 0 then
367: raise LOGGING_ERR;

Line 385: 'MTL_SYSTEM_ITEMS_INTERFACE',

381: request_id,
382: cr.TRANSACTION_ID,
383: error_msg,
384: 'SO_TRANSACTIONS_FLAG',
385: 'MTL_SYSTEM_ITEMS_INTERFACE',
386: 'INV_IOI_FLAG_Y_N',
387: err_text);
388: if dumm_status < 0 then
389: raise LOGGING_ERR;

Line 407: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 429: 'MTL_SYSTEM_ITEMS_INTERFACE',

425: request_id,
426: cr.TRANSACTION_ID,
427: error_msg,
428: 'STOCK_ENABLED_FLAG',
429: 'MTL_SYSTEM_ITEMS_INTERFACE',
430: 'INV_IOI_FLAG_Y_N',
431: err_text);
432: if dumm_status < 0 then
433: raise LOGGING_ERR;

Line 451: 'MTL_SYSTEM_ITEMS_INTERFACE',

447: request_id,
448: cr.TRANSACTION_ID,
449: error_msg,
450: 'BOM_ENABLED_FLAG',
451: 'MTL_SYSTEM_ITEMS_INTERFACE',
452: 'INV_IOI_FLAG_Y_N',
453: err_text);
454: if dumm_status < 0 then
455: raise LOGGING_ERR;

Line 473: 'MTL_SYSTEM_ITEMS_INTERFACE',

469: request_id,
470: cr.TRANSACTION_ID,
471: error_msg,
472: 'BUILD_IN_WIP_FLAG',
473: 'MTL_SYSTEM_ITEMS_INTERFACE',
474: 'INV_IOI_FLAG_Y_N',
475: err_text);
476: if dumm_status < 0 then
477: raise LOGGING_ERR;

Line 495: 'MTL_SYSTEM_ITEMS_INTERFACE',

491: request_id,
492: cr.TRANSACTION_ID,
493: error_msg,
494: 'CATALOG_STATUS_FLAG',
495: 'MTL_SYSTEM_ITEMS_INTERFACE',
496: 'INV_IOI_FLAG_Y_N',
497: err_text);
498: if dumm_status < 0 then
499: raise LOGGING_ERR;

Line 517: 'MTL_SYSTEM_ITEMS_INTERFACE',

513: request_id,
514: cr.TRANSACTION_ID,
515: error_msg,
516: 'RETURNABLE_FLAG',
517: 'MTL_SYSTEM_ITEMS_INTERFACE',
518: 'INV_IOI_FLAG_Y_N',
519: err_text);
520: if dumm_status < 0 then
521: raise LOGGING_ERR;

Line 539: 'MTL_SYSTEM_ITEMS_INTERFACE',

535: request_id,
536: cr.TRANSACTION_ID,
537: error_msg,
538: 'COLLATERAL_FLAG',
539: 'MTL_SYSTEM_ITEMS_INTERFACE',
540: 'INV_IOI_FLAG_Y_N',
541: err_text);
542: if dumm_status < 0 then
543: raise LOGGING_ERR;

Line 561: 'MTL_SYSTEM_ITEMS_INTERFACE',

557: request_id,
558: cr.TRANSACTION_ID,
559: error_msg,
560: 'TAXABLE_FLAG',
561: 'MTL_SYSTEM_ITEMS_INTERFACE',
562: 'INV_IOI_FLAG_Y_N',
563: err_text);
564: if dumm_status < 0 then
565: raise LOGGING_ERR;

Line 583: 'MTL_SYSTEM_ITEMS_INTERFACE',

579: request_id,
580: cr.TRANSACTION_ID,
581: error_msg,
582: 'ALLOW_ITEM_DESC_UPDATE_FLAG',
583: 'MTL_SYSTEM_ITEMS_INTERFACE',
584: 'INV_IOI_FLAG_Y_N',
585: err_text);
586: if dumm_status < 0 then
587: raise LOGGING_ERR;

Line 605: 'MTL_SYSTEM_ITEMS_INTERFACE',

601: request_id,
602: cr.TRANSACTION_ID,
603: error_msg,
604: 'INSPECTION_REQUIRED_FLAG',
605: 'MTL_SYSTEM_ITEMS_INTERFACE',
606: 'INV_IOI_FLAG_Y_N',
607: err_text);
608: if dumm_status < 0 then
609: raise LOGGING_ERR;

Line 627: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 649: 'MTL_SYSTEM_ITEMS_INTERFACE',

645: request_id,
646: cr.TRANSACTION_ID,
647: error_msg,
648: 'RFQ_REQUIRED_FLAG',
649: 'MTL_SYSTEM_ITEMS_INTERFACE',
650: 'INV_IOI_FLAG_Y_N',
651: err_text);
652: if dumm_status < 0 then
653: raise LOGGING_ERR;

Line 671: 'MTL_SYSTEM_ITEMS_INTERFACE',

667: request_id,
668: cr.TRANSACTION_ID,
669: error_msg,
670: 'ALLOW_SUBSTITUTE_RECEIPTS_FLAG',
671: 'MTL_SYSTEM_ITEMS_INTERFACE',
672: 'INV_IOI_FLAG_Y_N',
673: err_text);
674: if dumm_status < 0 then
675: raise LOGGING_ERR;

Line 693: 'MTL_SYSTEM_ITEMS_INTERFACE',

689: request_id,
690: cr.TRANSACTION_ID,
691: error_msg,
692: 'ALLOW_UNORDERED_RECEIPTS_FLAG',
693: 'MTL_SYSTEM_ITEMS_INTERFACE',
694: 'INV_IOI_FLAG_Y_N',
695: err_text);
696: if dumm_status < 0 then
697: raise LOGGING_ERR;

Line 715: 'MTL_SYSTEM_ITEMS_INTERFACE',

711: request_id,
712: cr.TRANSACTION_ID,
713: error_msg,
714: 'ALLOW_EXPRESS_DELIVERY_FLAG',
715: 'MTL_SYSTEM_ITEMS_INTERFACE',
716: 'INV_IOI_FLAG_Y_N',
717: err_text);
718: if dumm_status < 0 then
719: raise LOGGING_ERR;

Line 737: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 760: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 782: 'MTL_SYSTEM_ITEMS_INTERFACE',

778: request_id,
779: cr.TRANSACTION_ID,
780: error_msg,
781: 'REPETITIVE_PLANNING_FLAG',
782: 'MTL_SYSTEM_ITEMS_INTERFACE',
783: 'INV_IOI_FLAG_Y_N',
784: err_text);
785: if dumm_status < 0 then
786: raise LOGGING_ERR;

Line 804: 'MTL_SYSTEM_ITEMS_INTERFACE',

800: request_id,
801: cr.TRANSACTION_ID,
802: error_msg,
803: 'PICK_COMPONENTS_FLAG',
804: 'MTL_SYSTEM_ITEMS_INTERFACE',
805: 'INV_IOI_FLAG_Y_N',
806: err_text);
807: if dumm_status < 0 then
808: raise LOGGING_ERR;

Line 826: 'MTL_SYSTEM_ITEMS_INTERFACE',

822: request_id,
823: cr.TRANSACTION_ID,
824: error_msg,
825: 'REPLENISH_TO_ORDER_FLAG',
826: 'MTL_SYSTEM_ITEMS_INTERFACE',
827: 'INV_IOI_FLAG_Y_N',
828: err_text);
829: if dumm_status < 0 then
830: raise LOGGING_ERR;

Line 847: 'MTL_SYSTEM_ITEMS_INTERFACE',

843: request_id,
844: cr.TRANSACTION_ID,
845: error_msg,
846: 'ATP_COMPONENTS_FLAG',
847: 'MTL_SYSTEM_ITEMS_INTERFACE',
848: 'INV_IOI_ATP_COMPONENTS_FLAG',
849: err_text);
850: if dumm_status < 0 then
851: raise LOGGING_ERR;

Line 868: 'MTL_SYSTEM_ITEMS_INTERFACE',

864: request_id,
865: cr.TRANSACTION_ID,
866: error_msg,
867: 'ATP_FLAG',
868: 'MTL_SYSTEM_ITEMS_INTERFACE',
869: 'INV_IOI_ATP_FLAG',
870: err_text);
871: if dumm_status < 0 then
872: raise LOGGING_ERR;

Line 893: 'MTL_SYSTEM_ITEMS_INTERFACE',

889: request_id,
890: cr.TRANSACTION_ID,
891: error_msg,
892: 'ATP_FLAG',
893: 'MTL_SYSTEM_ITEMS_INTERFACE',
894: 'INV_IOI_CHECK_ATP_CTP_1',
895: err_text);
896: if dumm_status < 0 then
897: raise LOGGING_ERR;

Line 911: 'MTL_SYSTEM_ITEMS_INTERFACE',

907: request_id,
908: cr.TRANSACTION_ID,
909: error_msg,
910: 'ATP_FLAG',
911: 'MTL_SYSTEM_ITEMS_INTERFACE',
912: 'INV_IOI_CHECK_ATP_CTP_2',
913: err_text);
914: if dumm_status < 0 then
915: raise LOGGING_ERR;

Line 931: 'MTL_SYSTEM_ITEMS_INTERFACE',

927: request_id,
928: cr.TRANSACTION_ID,
929: error_msg,
930: 'ATP_FLAG',
931: 'MTL_SYSTEM_ITEMS_INTERFACE',
932: 'INV_IOI_CHECK_ATP_CTP_3A',
933: err_text);
934: if dumm_status < 0 then
935: raise LOGGING_ERR;

Line 952: 'MTL_SYSTEM_ITEMS_INTERFACE',

948: request_id,
949: cr.TRANSACTION_ID,
950: error_msg,
951: 'ATP_FLAG',
952: 'MTL_SYSTEM_ITEMS_INTERFACE',
953: 'INV_CHECK_ATP_CTP_3B',--'INV_IOI_CHECK_ATP_CTP_3B',
954: err_text);
955: if dumm_status < 0 then
956: raise LOGGING_ERR;

Line 974: 'MTL_SYSTEM_ITEMS_INTERFACE',

970: request_id,
971: cr.TRANSACTION_ID,
972: error_msg,
973: 'DEFAULT_INCLUDE_IN_ROLLUP_FLAG',
974: 'MTL_SYSTEM_ITEMS_INTERFACE',
975: 'INV_IOI_FLAG_Y_N',
976: err_text);
977: if dumm_status < 0 then
978: raise LOGGING_ERR;

Line 999: 'MTL_SYSTEM_ITEMS_INTERFACE',

995: request_id,
996: cr.TRANSACTION_ID,
997: error_msg,
998: 'VENDOR_WARRANTY_FLAG',
999: 'MTL_SYSTEM_ITEMS_INTERFACE',
1000: 'INV_IOI_FLAG_Y_N',
1001: err_text);
1002: if dumm_status < 0 then
1003: raise LOGGING_ERR;

Line 1022: 'MTL_SYSTEM_ITEMS_INTERFACE',

1018: request_id,
1019: cr.TRANSACTION_ID,
1020: error_msg,
1021: 'SERVICEABLE_COMPONENT_FLAG',
1022: 'MTL_SYSTEM_ITEMS_INTERFACE',
1023: 'INV_IOI_FLAG_Y_N',
1024: err_text);
1025: if dumm_status < 0 then
1026: raise LOGGING_ERR;

Line 1044: 'MTL_SYSTEM_ITEMS_INTERFACE',

1040: request_id,
1041: cr.TRANSACTION_ID,
1042: error_msg,
1043: 'SERVICEABLE_PRODUCT_FLAG',
1044: 'MTL_SYSTEM_ITEMS_INTERFACE',
1045: 'INV_IOI_FLAG_Y_N',
1046: err_text);
1047: if dumm_status < 0 then
1048: raise LOGGING_ERR;

Line 1066: 'MTL_SYSTEM_ITEMS_INTERFACE',

1062: request_id,
1063: cr.TRANSACTION_ID,
1064: error_msg,
1065: 'PREVENTIVE_MAINTENANCE_FLAG',
1066: 'MTL_SYSTEM_ITEMS_INTERFACE',
1067: 'INV_IOI_FLAG_Y_N',
1068: err_text);
1069: if dumm_status < 0 then
1070: raise LOGGING_ERR;

Line 1087: 'MTL_SYSTEM_ITEMS_INTERFACE',

1083: request_id,
1084: cr.TRANSACTION_ID,
1085: error_msg,
1086: 'TIME_BILLABLE_FLAG',
1087: 'MTL_SYSTEM_ITEMS_INTERFACE',
1088: 'INV_IOI_FLAG_Y_N',
1089: err_text);
1090: if dumm_status < 0 then
1091: raise LOGGING_ERR;

Line 1117: 'MTL_SYSTEM_ITEMS_INTERFACE',

1113: request_id,
1114: cr.TRANSACTION_ID,
1115: error_msg,
1116: 'MATERIAL_BILLABLE_FLAG',
1117: 'MTL_SYSTEM_ITEMS_INTERFACE',
1118: 'INV_INVALID_ATTR_COL_VALUE',--'INV_IOI_MATERIAL_BILLABLE_FLAG',
1119: err_text);
1120: if dumm_status < 0 then
1121: raise LOGGING_ERR;

Line 1140: 'MTL_SYSTEM_ITEMS_INTERFACE',

1136: request_id,
1137: cr.TRANSACTION_ID,
1138: error_msg,
1139: 'EXPENSE_BILLABLE_FLAG',
1140: 'MTL_SYSTEM_ITEMS_INTERFACE',
1141: 'INV_IOI_FLAG_Y_N',
1142: err_text);
1143: if dumm_status < 0 then
1144: raise LOGGING_ERR;

Line 1162: 'MTL_SYSTEM_ITEMS_INTERFACE',

1158: request_id,
1159: cr.TRANSACTION_ID,
1160: error_msg,
1161: 'PRORATE_SERVICE_FLAG',
1162: 'MTL_SYSTEM_ITEMS_INTERFACE',
1163: 'INV_IOI_FLAG_Y_N',
1164: err_text);
1165: if dumm_status < 0 then
1166: raise LOGGING_ERR;

Line 1205: 'MTL_SYSTEM_ITEMS_INTERFACE',

1201: request_id,
1202: cr.TRANSACTION_ID,
1203: error_msg,
1204: 'SERVICE_DURATION_PERIOD_CODE',
1205: 'MTL_SYSTEM_ITEMS_INTERFACE',
1206: 'INV_IOI_SERV_DUR_PER_CODE',
1207: err_text);
1208: l_serv_dur_per_code_err := 1;
1209: IF dumm_status < 0 THEN

Line 1225: 'MTL_SYSTEM_ITEMS_INTERFACE',

1221: request_id,
1222: cr.TRANSACTION_ID,
1223: error_msg,
1224: 'SERVICE_DURATION_PERIOD_CODE',
1225: 'MTL_SYSTEM_ITEMS_INTERFACE',
1226: 'INV_IOI_SERV_DUR_PER_CODE',
1227: err_text);
1228: l_serv_dur_per_code_err := 1;
1229: IF dumm_status < 0 THEN

Line 1250: 'MTL_SYSTEM_ITEMS_INTERFACE',

1246: request_id,
1247: cr.TRANSACTION_ID,
1248: error_msg,
1249: 'INVOICEABLE_ITEM_FLAG',
1250: 'MTL_SYSTEM_ITEMS_INTERFACE',
1251: 'INV_IOI_FLAG_Y_N',
1252: err_text);
1253: if dumm_status < 0 then
1254: raise LOGGING_ERR;

Line 1272: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1294: 'MTL_SYSTEM_ITEMS_INTERFACE',

1290: request_id,
1291: cr.TRANSACTION_ID,
1292: error_msg,
1293: 'MUST_USE_APPROVED_VENDOR_FLAG',
1294: 'MTL_SYSTEM_ITEMS_INTERFACE',
1295: 'INV_IOI_FLAG_Y_N',
1296: err_text);
1297: if dumm_status < 0 then
1298: raise LOGGING_ERR;

Line 1316: 'MTL_SYSTEM_ITEMS_INTERFACE',

1312: request_id,
1313: cr.TRANSACTION_ID,
1314: error_msg,
1315: 'OUTSIDE_OPERATION_FLAG',
1316: 'MTL_SYSTEM_ITEMS_INTERFACE',
1317: 'INV_IOI_FLAG_Y_N',
1318: err_text);
1319: if dumm_status < 0 then
1320: raise LOGGING_ERR;

Line 1338: 'MTL_SYSTEM_ITEMS_INTERFACE',

1334: request_id,
1335: cr.TRANSACTION_ID,
1336: error_msg,
1337: 'COSTING_ENABLED_FLAG',
1338: 'MTL_SYSTEM_ITEMS_INTERFACE',
1339: 'INV_IOI_FLAG_Y_N',
1340: err_text);
1341: if dumm_status < 0 then
1342: raise LOGGING_ERR;

Line 1360: 'MTL_SYSTEM_ITEMS_INTERFACE',

1356: request_id,
1357: cr.TRANSACTION_ID,
1358: error_msg,
1359: 'CYCLE_COUNT_ENABLED_FLAG',
1360: 'MTL_SYSTEM_ITEMS_INTERFACE',
1361: 'INV_IOI_FLAG_Y_N',
1362: err_text);
1363: if dumm_status < 0 then
1364: raise LOGGING_ERR;

Line 1382: 'MTL_SYSTEM_ITEMS_INTERFACE',

1378: request_id,
1379: cr.TRANSACTION_ID,
1380: error_msg,
1381: 'AUTO_CREATED_CONFIG_FLAG',
1382: 'MTL_SYSTEM_ITEMS_INTERFACE',
1383: 'INV_IOI_FLAG_Y_N',
1384: err_text);
1385: if dumm_status < 0 then
1386: raise LOGGING_ERR;

Line 1405: 'MTL_SYSTEM_ITEMS_INTERFACE',

1401: request_id,
1402: cr.TRANSACTION_ID,
1403: error_msg,
1404: 'CHECK_SHORTAGES_FLAG',
1405: 'MTL_SYSTEM_ITEMS_INTERFACE',
1406: 'BOM_OP_VALIDATION_ERR',
1407: err_text);
1408: IF dumm_status < 0 THEN
1409: raise LOGGING_ERR;

Line 1428: 'MTL_SYSTEM_ITEMS_INTERFACE',

1424: request_id,
1425: cr.TRANSACTION_ID,
1426: error_msg,
1427: 'GDSN_OUTBOUND_ENABLED_FLAG',
1428: 'MTL_SYSTEM_ITEMS_INTERFACE',
1429: 'INV_IOI_FLAG_Y_N',
1430: err_text);
1431: IF dumm_status < 0 THEN
1432: raise LOGGING_ERR;

Line 1451: 'MTL_SYSTEM_ITEMS_INTERFACE',

1447: request_id,
1448: cr.TRANSACTION_ID,
1449: error_msg,
1450: 'STYLE_ITEM_FLAG',
1451: 'MTL_SYSTEM_ITEMS_INTERFACE',
1452: 'BOM_OP_VALIDATION_ERR',
1453: err_text);
1454: IF dumm_status < 0 THEN
1455: raise LOGGING_ERR;

Line 1461: from MTL_SYSTEM_ITEMS_INTERFACE

1457: status := 1;
1458: END IF;
1459: --Start 3515652: Performance enhancements
1460: select process_flag into temp_proc_flag
1461: from MTL_SYSTEM_ITEMS_INTERFACE
1462: where inventory_item_id = cr.inventory_item_id
1463: and set_process_id + 0 = xset_id
1464: and process_flag in (31, 32, 33, 34 , 35 , 45)
1465: and organization_id = cr.organization_id

Line 1473: update MTL_SYSTEM_ITEMS_INTERFACE

1469: and temp_proc_flag <> 32
1470: and temp_proc_flag <> 33
1471: and temp_proc_flag <> 34)
1472: THEN
1473: update MTL_SYSTEM_ITEMS_INTERFACE
1474: set process_flag = DECODE(status,0,45,35)
1475: where inventory_item_id = cr.inventory_item_id
1476: and set_process_id + 0 = xset_id
1477: and process_flag = 45

Line 1510: 'MTL_SYSTEM_ITEMS_INTERFACE',

1506: request_id,
1507: null,
1508: err_text,
1509: null,
1510: 'MTL_SYSTEM_ITEMS_INTERFACE',
1511: 'BOM_OP_VALIDATION_ERR',
1512: err_text);
1513: RETURN(status);
1514: WHEN OTHERS THEN