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

Line 35: FROM mtl_system_items_interface intf

31: l_test NUMBER;
32:
33: CURSOR cc IS
34: SELECT ROWID, intf.*
35: FROM mtl_system_items_interface intf
36: WHERE((intf.organization_id = org_id) OR (all_Org = 1) )
37: AND intf.set_process_id = xset_id
38: AND intf.process_flag in (31, 32, 33, 43);
39:

Line 120: 'MTL_SYSTEM_ITEMS_INTERFACE',

116: request_id,
117: cr.TRANSACTION_ID,
118: error_msg,
119: 'BOM_ITEM_TYPE',
120: 'MTL_SYSTEM_ITEMS_INTERFACE',
121: 'INV_IOI_BOM_ITEM_TYPE',
122: err_text);
123: IF dumm_status < 0 THEN
124: raise LOGGING_ERR;

Line 147: 'MTL_SYSTEM_ITEMS_INTERFACE',

143: request_id,
144: cr.TRANSACTION_ID,
145: error_msg,
146: 'WIP_SUPPLY_TYPE',
147: 'MTL_SYSTEM_ITEMS_INTERFACE',
148: 'INV_IOI_WIP_SUPP_TYPE',
149: err_text);
150: IF dumm_status < 0 THEN
151: raise LOGGING_ERR;

Line 171: 'MTL_SYSTEM_ITEMS_INTERFACE',

167: request_id,
168: cr.TRANSACTION_ID,
169: error_msg,
170: 'ALLOWED_UNITS_LOOKUP_CODE',
171: 'MTL_SYSTEM_ITEMS_INTERFACE',
172: 'INV_IOI_ALWD_UN_LKUP_CODE',
173: err_text);
174: IF dumm_status < 0 THEN
175: raise LOGGING_ERR;

Line 197: 'MTL_SYSTEM_ITEMS_INTERFACE',

193: request_id,
194: cr.TRANSACTION_ID,
195: error_msg,
196: 'INVENTORY_PLANNING_CODE',
197: 'MTL_SYSTEM_ITEMS_INTERFACE',
198: 'INV_IOI_INV_PLN_CODE',
199: err_text);
200: IF dumm_status < 0 THEN
201: raise LOGGING_ERR;

Line 218: 'MTL_SYSTEM_ITEMS_INTERFACE',

214: request_id,
215: cr.TRANSACTION_ID,
216: error_msg,
217: 'PLANNING_MAKE_BUY_CODE',
218: 'MTL_SYSTEM_ITEMS_INTERFACE',
219: 'INV_IOI_PLN_MAKE_BUY_CODE',
220: err_text);
221: IF dumm_status < 0 THEN
222: raise LOGGING_ERR;

Line 240: 'MTL_SYSTEM_ITEMS_INTERFACE',

236: request_id,
237: cr.TRANSACTION_ID,
238: error_msg,
239: 'ROUNDING_CONTROL_TYPE',
240: 'MTL_SYSTEM_ITEMS_INTERFACE',
241: 'INV_IOI_RND_CTRL_TYPE',
242: err_text);
243: IF dumm_status < 0 THEN
244: raise LOGGING_ERR;

Line 261: 'MTL_SYSTEM_ITEMS_INTERFACE',

257: request_id,
258: cr.TRANSACTION_ID,
259: error_msg,
260: 'MRP_SAFETY_STOCK_CODE',
261: 'MTL_SYSTEM_ITEMS_INTERFACE',
262: 'INV_IOI_MRP_SAF_STK_CODE',
263: err_text);
264: IF dumm_status < 0 THEN
265: raise LOGGING_ERR;

Line 282: 'MTL_SYSTEM_ITEMS_INTERFACE',

278: request_id,
279: cr.TRANSACTION_ID,
280: error_msg,
281: 'RESERVABLE_TYPE',
282: 'MTL_SYSTEM_ITEMS_INTERFACE',
283: 'INV_IOI_RESER_TYPE',
284: err_text);
285: IF dumm_status < 0 THEN
286: raise LOGGING_ERR;

Line 306: 'MTL_SYSTEM_ITEMS_INTERFACE',

302: request_id,
303: cr.TRANSACTION_ID,
304: error_msg,
305: 'RESPONSE_TIME_PERIOD_CODE',
306: 'MTL_SYSTEM_ITEMS_INTERFACE',
307: 'INV_IOI_RESP_TIME_PER_CODE',
308: err_text);
309: IF dumm_status < 0 THEN
310: raise LOGGING_ERR;

Line 329: 'MTL_SYSTEM_ITEMS_INTERFACE',

325: request_id,
326: cr.TRANSACTION_ID,
327: error_msg,
328: 'NEW_REVISION_CODE',
329: 'MTL_SYSTEM_ITEMS_INTERFACE',
330: 'INV_IOI_NEW_REV_CODE',
331: err_text);
332: IF dumm_status < 0 THEN
333: raise LOGGING_ERR;

Line 351: 'MTL_SYSTEM_ITEMS_INTERFACE',

347: request_id,
348: cr.TRANSACTION_ID,
349: error_msg,
350: 'OUTSIDE_OPERATION_UOM_TYPE',
351: 'MTL_SYSTEM_ITEMS_INTERFACE',
352: 'INV_IOI_OUTSIDE_OP_UOM_TYPE',
353: err_text);
354: IF dumm_status < 0 THEN
355: raise LOGGING_ERR;

Line 376: 'MTL_SYSTEM_ITEMS_INTERFACE',

372: request_id,
373: cr.TRANSACTION_ID,
374: error_msg,
375: 'AUTO_REDUCE_MPS',
376: 'MTL_SYSTEM_ITEMS_INTERFACE',
377: 'INV_IOI_AUTO_REDUCE_MPS',
378: err_text);
379: IF dumm_status < 0 THEN
380: raise LOGGING_ERR;

Line 398: 'MTL_SYSTEM_ITEMS_INTERFACE',

394: request_id,
395: cr.TRANSACTION_ID,
396: error_msg,
397: 'MRP_PLANNING_CODE',
398: 'MTL_SYSTEM_ITEMS_INTERFACE',
399: 'INV_IOI_MRP_PLANNING_CODE',
400: err_text);
401: IF dumm_status < 0 THEN
402: raise LOGGING_ERR;

Line 419: 'MTL_SYSTEM_ITEMS_INTERFACE',

415: request_id,
416: cr.TRANSACTION_ID,
417: error_msg,
418: 'PURCHASING_TAX_CODE',
419: 'MTL_SYSTEM_ITEMS_INTERFACE',
420: 'INV_IOI_TAXABLE_FLAG',
421: err_text);
422: IF dumm_status < 0 THEN
423: raise LOGGING_ERR;

Line 460: 'MTL_SYSTEM_ITEMS_INTERFACE',

456: request_id,
457: cr.TRANSACTION_ID,
458: error_msg,
459: 'PURCHASING_TAX_CODE',
460: 'MTL_SYSTEM_ITEMS_INTERFACE',
461: 'INV_IOI_PUR_TAX_CODE',
462: err_text);
463: IF dumm_status < 0 THEN
464: raise LOGGING_ERR;

Line 483: 'MTL_SYSTEM_ITEMS_INTERFACE',

479: request_id,
480: cr.TRANSACTION_ID,
481: error_msg,
482: 'MARKET_PRICE',
483: 'MTL_SYSTEM_ITEMS_INTERFACE',
484: 'INV_GREATER_EQUAL_ZERO',
485: err_text);
486: IF dumm_status < 0 THEN
487: raise LOGGING_ERR;

Line 503: 'MTL_SYSTEM_ITEMS_INTERFACE',

499: request_id,
500: cr.TRANSACTION_ID,
501: error_msg,
502: 'LIST_PRICE_PER_UNIT',
503: 'MTL_SYSTEM_ITEMS_INTERFACE',
504: 'INV_GREATER_EQUAL_ZERO',
505: err_text);
506: IF dumm_status < 0 THEN
507: raise LOGGING_ERR;

Line 524: 'MTL_SYSTEM_ITEMS_INTERFACE',

520: request_id,
521: cr.TRANSACTION_ID,
522: error_msg,
523: 'RETURN_INSPECTION_REQUIREMENT',
524: 'MTL_SYSTEM_ITEMS_INTERFACE',
525: 'INV_IOI_RETURN_INSP_REQ',
526: err_text);
527: IF dumm_status < 0 THEN
528: raise LOGGING_ERR;

Line 548: 'MTL_SYSTEM_ITEMS_INTERFACE',

544: request_id,
545: cr.TRANSACTION_ID,
546: error_msg,
547: 'ATO_FORECAST_CONTROL',
548: 'MTL_SYSTEM_ITEMS_INTERFACE',
549: 'INV_IOI_ATO_FORECAST_CTRL',
550: err_text);
551: IF dumm_status < 0 THEN
552: raise LOGGING_ERR;

Line 572: 'MTL_SYSTEM_ITEMS_INTERFACE',

568: request_id,
569: cr.TRANSACTION_ID,
570: error_msg,
571: 'CUMULATIVE_TOTAL_LEAD_TIME',
572: 'MTL_SYSTEM_ITEMS_INTERFACE',
573: 'INV_IOI_NUMBER_TOO_LONG',
574: err_text);
575: IF dumm_status < 0 THEN
576: raise LOGGING_ERR;

Line 595: 'MTL_SYSTEM_ITEMS_INTERFACE',

591: request_id,
592: cr.TRANSACTION_ID,
593: error_msg,
594: 'CUM_MANUFACTURING_LEAD_TIME',
595: 'MTL_SYSTEM_ITEMS_INTERFACE',
596: 'INV_IOI_CUM_MANU_TOO_LONG',
597: err_text);
598: IF dumm_status < 0 THEN
599: raise LOGGING_ERR;

Line 618: 'MTL_SYSTEM_ITEMS_INTERFACE',

614: request_id,
615: cr.TRANSACTION_ID,
616: error_msg,
617: 'COVERAGE_SCHEDULE_ID',
618: 'MTL_SYSTEM_ITEMS_INTERFACE',
619: 'INV_COVERAGE_TEMP_CONTRACT',
620: err_text);
621: IF dumm_status < 0 THEN
622: raise LOGGING_ERR;

Line 657: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

653: dumm_status := INVPUOPI.mtl_log_interface_err
654: ( cr.organization_id,
655: user_id, login_id, prog_appid, prog_id, request_id,
656: cr.TRANSACTION_ID, error_msg,
657: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
658: l_msg_name,
659: err_text );
660: IF dumm_status < 0 THEN
661: raise LOGGING_ERR;

Line 678: 'MTL_SYSTEM_ITEMS_INTERFACE',

674: request_id,
675: cr.TRANSACTION_ID,
676: error_msg,
677: 'COVERAGE_SCHEDULE_ID',
678: 'MTL_SYSTEM_ITEMS_INTERFACE',
679: 'INV_COVERAGE_TEMPL_MAND',
680: err_text);
681: IF dumm_status < 0 THEN
682: raise LOGGING_ERR;

Line 702: 'MTL_SYSTEM_ITEMS_INTERFACE',

698: request_id,
699: cr.TRANSACTION_ID,
700: error_msg,
701: 'COMMS_NL_TRACKABLE_FLAG',
702: 'MTL_SYSTEM_ITEMS_INTERFACE',
703: 'INV_IB_TRACKING_CONTRACT',
704: err_text);
705: IF dumm_status < 0 THEN
706: raise LOGGING_ERR;

Line 725: 'MTL_SYSTEM_ITEMS_INTERFACE',

721: request_id,
722: cr.TRANSACTION_ID,
723: error_msg,
724: 'COMMS_NL_TRACKABLE_FLAG',
725: 'MTL_SYSTEM_ITEMS_INTERFACE',
726: 'INV_CTTYPE_INSBASE_VALID',
727: err_text);
728: IF dumm_status < 0 THEN
729: raise LOGGING_ERR;

Line 749: 'MTL_SYSTEM_ITEMS_INTERFACE',

745: request_id,
746: cr.TRANSACTION_ID,
747: error_msg,
748: 'ASSET_CREATION_CODE',
749: 'MTL_SYSTEM_ITEMS_INTERFACE',
750: 'INV_INST_BASE_ASSET_CREATE_DEP',
751: err_text);
752: IF dumm_status < 0 THEN
753: raise LOGGING_ERR;

Line 773: 'MTL_SYSTEM_ITEMS_INTERFACE',

769: request_id,
770: cr.TRANSACTION_ID,
771: error_msg,
772: 'COMMS_NL_TRACKABLE_FLAG',
773: 'MTL_SYSTEM_ITEMS_INTERFACE',
774: 'INV_IB_TRACKING_SERVICEABLE',
775: err_text);
776: IF dumm_status < 0 THEN
777: raise LOGGING_ERR;

Line 795: 'MTL_SYSTEM_ITEMS_INTERFACE',

791: request_id,
792: cr.TRANSACTION_ID,
793: error_msg,
794: 'LOT_SUBSTITUTION_ENABLED',
795: 'MTL_SYSTEM_ITEMS_INTERFACE',
796: 'INV_INVALID_LOT_SUB_ENABLED',
797: err_text);
798: IF dumm_status < 0 THEN
799: raise LOGGING_ERR;

Line 813: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

809: dumm_status := INVPUOPI.mtl_log_interface_err
810: ( cr.organization_id,
811: user_id, login_id, prog_appid, prog_id, request_id,
812: cr.TRANSACTION_ID, error_msg,
813: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
814: l_msg_name,
815: err_text);
816: IF dumm_status < 0 THEN
817: raise LOGGING_ERR;

Line 834: 'MTL_SYSTEM_ITEMS_INTERFACE',

830: request_id,
831: cr.TRANSACTION_ID,
832: error_msg,
833: 'LOT_SUBSTITUTION_ENABLED',
834: 'MTL_SYSTEM_ITEMS_INTERFACE',
835: 'INV_INVALID_LOT_SUB_ENABLED',
836: err_text);
837: IF dumm_status < 0 THEN
838: raise LOGGING_ERR;

Line 857: 'MTL_SYSTEM_ITEMS_INTERFACE',

853: request_id,
854: cr.TRANSACTION_ID,
855: error_msg,
856: 'LOT_TRANSLATE_ENABLED',
857: 'MTL_SYSTEM_ITEMS_INTERFACE',
858: 'INV_IOI_FLAG_Y_N_NULL',
859: err_text);
860: IF dumm_status < 0 THEN
861: raise LOGGING_ERR;

Line 877: 'MTL_SYSTEM_ITEMS_INTERFACE',

873: request_id,
874: cr.TRANSACTION_ID,
875: error_msg,
876: 'LOT_TRANSLATE_ENABLED',
877: 'MTL_SYSTEM_ITEMS_INTERFACE',
878: 'INV_INVALID_LOT_TRANS_ENABLED',
879: err_text);
880: IF dumm_status < 0 THEN
881: raise LOGGING_ERR;

Line 899: 'MTL_SYSTEM_ITEMS_INTERFACE',

895: request_id,
896: cr.TRANSACTION_ID,
897: error_msg,
898: 'LOT_SPLIT_ENABLED',
899: 'MTL_SYSTEM_ITEMS_INTERFACE',
900: 'INV_IOI_FLAG_Y_N_NULL',
901: err_text);
902: IF dumm_status < 0 THEN
903: raise LOGGING_ERR;

Line 919: 'MTL_SYSTEM_ITEMS_INTERFACE',

915: request_id,
916: cr.TRANSACTION_ID,
917: error_msg,
918: 'LOT_SPLIT_ENABLED',
919: 'MTL_SYSTEM_ITEMS_INTERFACE',
920: 'INV_INVALID_LOT_SPLIT_ENABLED',
921: err_text);
922: IF dumm_status < 0 THEN
923: raise LOGGING_ERR;

Line 941: 'MTL_SYSTEM_ITEMS_INTERFACE',

937: request_id,
938: cr.TRANSACTION_ID,
939: error_msg,
940: 'LOT_MERGE_ENABLED',
941: 'MTL_SYSTEM_ITEMS_INTERFACE',
942: 'INV_IOI_FLAG_Y_N_NULL',
943: err_text);
944: IF dumm_status < 0 THEN
945: raise LOGGING_ERR;

Line 961: 'MTL_SYSTEM_ITEMS_INTERFACE',

957: request_id,
958: cr.TRANSACTION_ID,
959: error_msg,
960: 'LOT_MERGE_ENABLED',
961: 'MTL_SYSTEM_ITEMS_INTERFACE',
962: 'INV_INVALID_LOT_MERGE_ENABLED',
963: err_text);
964: IF dumm_status < 0 THEN
965: raise LOGGING_ERR;

Line 986: 'MTL_SYSTEM_ITEMS_INTERFACE',

982: request_id,
983: cr.TRANSACTION_ID,
984: error_msg,
985: 'MINIMUM_LICENSE_QUANTITY',
986: 'MTL_SYSTEM_ITEMS_INTERFACE',
987: 'INV_INVALID_MIN_LICENSE',
988: err_text);
989: IF dumm_status < 0 THEN
990: raise LOGGING_ERR;

Line 1006: 'MTL_SYSTEM_ITEMS_INTERFACE',

1002: request_id,
1003: cr.TRANSACTION_ID,
1004: error_msg,
1005: 'IB_ITEM_INSTANCE_CLASS',
1006: 'MTL_SYSTEM_ITEMS_INTERFACE',
1007: 'INV_IB_INSTANCE_CLASS_IB_TRACK',
1008: err_text);
1009: IF dumm_status < 0 THEN
1010: raise LOGGING_ERR;

Line 1028: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1024: dumm_status := INVPUOPI.mtl_log_interface_err
1025: ( cr.organization_id,
1026: user_id, login_id, prog_appid, prog_id, request_id,
1027: cr.TRANSACTION_ID, error_msg,
1028: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1029: l_msg_name,
1030: err_text );
1031: IF dumm_status < 0 THEN
1032: raise LOGGING_ERR;

Line 1053: 'MTL_SYSTEM_ITEMS_INTERFACE',

1049: request_id,
1050: cr.TRANSACTION_ID,
1051: error_msg,
1052: 'CONFIG_MODEL_TYPE',
1053: 'MTL_SYSTEM_ITEMS_INTERFACE',
1054: 'INV_CONFIG_MODEL_TYPE_MOD',
1055: err_text);
1056: IF dumm_status < 0 THEN
1057: raise LOGGING_ERR;

Line 1075: 'MTL_SYSTEM_ITEMS_INTERFACE',

1071: request_id,
1072: cr.TRANSACTION_ID,
1073: error_msg,
1074: 'CONFIG_MODEL_TYPE',
1075: 'MTL_SYSTEM_ITEMS_INTERFACE',
1076: 'INV_CONFIG_MODEL_TYPE_IB_TRACK',
1077: err_text);
1078: IF dumm_status < 0 THEN
1079: raise LOGGING_ERR;

Line 1097: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1093: dumm_status := INVPUOPI.mtl_log_interface_err
1094: ( cr.organization_id,
1095: user_id, login_id, prog_appid, prog_id, request_id,
1096: cr.TRANSACTION_ID, error_msg,
1097: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1098: l_msg_name,
1099: err_text );
1100: IF dumm_status < 0 THEN
1101: raise LOGGING_ERR;

Line 1125: 'MTL_SYSTEM_ITEMS_INTERFACE',

1121: request_id,
1122: cr.TRANSACTION_ID,
1123: error_msg,
1124: 'WEB_STATUS',
1125: 'MTL_SYSTEM_ITEMS_INTERFACE',
1126: 'INV_IOI_WEB_STATUS',
1127: err_text);
1128: IF dumm_status < 0 THEN
1129: raise LOGGING_ERR;

Line 1174: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1170: dumm_status := INVPUOPI.mtl_log_interface_err
1171: ( cr.organization_id,
1172: user_id, login_id, prog_appid, prog_id, request_id,
1173: cr.TRANSACTION_ID, error_msg,
1174: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1175: l_msg_name, -- l_msg_token
1176: err_text );
1177: IF dumm_status < 0 THEN
1178: raise LOGGING_ERR;

Line 1192: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1188: dumm_status := INVPUOPI.mtl_log_interface_err
1189: ( cr.organization_id,
1190: user_id, login_id, prog_appid, prog_id, request_id,
1191: cr.TRANSACTION_ID, error_msg,
1192: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1193: l_msg_name,
1194: err_text );
1195: IF dumm_status < 0 THEN
1196: raise LOGGING_ERR;

Line 1221: 'MTL_SYSTEM_ITEMS_INTERFACE',

1217: request_id,
1218: cr.TRANSACTION_ID,
1219: error_msg,
1220: l_col_name,
1221: 'MTL_SYSTEM_ITEMS_INTERFACE',
1222: l_msg_name,
1223: err_text );
1224: IF dumm_status < 0 THEN
1225: raise LOGGING_ERR;

Line 1239: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1235: dumm_status := INVPUOPI.mtl_log_interface_err
1236: ( cr.organization_id,
1237: user_id, login_id, prog_appid, prog_id, request_id,
1238: cr.TRANSACTION_ID, error_msg,
1239: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1240: l_msg_name,
1241: err_text );
1242: IF dumm_status < 0 THEN
1243: raise LOGGING_ERR;

Line 1260: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1256: dumm_status := INVPUOPI.mtl_log_interface_err
1257: ( cr.organization_id,
1258: user_id, login_id, prog_appid, prog_id, request_id,
1259: cr.TRANSACTION_ID, error_msg,
1260: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1261: l_msg_name,
1262: err_text );
1263: IF dumm_status < 0 THEN
1264: raise LOGGING_ERR;

Line 1283: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1279: dumm_status := INVPUOPI.mtl_log_interface_err
1280: ( cr.organization_id,
1281: user_id, login_id, prog_appid, prog_id, request_id,
1282: cr.TRANSACTION_ID, error_msg,
1283: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1284: l_msg_name,
1285: err_text );
1286: IF dumm_status < 0 THEN
1287: raise LOGGING_ERR;

Line 1319: 'MTL_SYSTEM_ITEMS_INTERFACE',

1315: request_id,
1316: cr.TRANSACTION_ID,
1317: error_msg,
1318: l_col_name,
1319: 'MTL_SYSTEM_ITEMS_INTERFACE',
1320: l_msg_name,
1321: err_text );
1322: IF dumm_status < 0 THEN
1323: raise LOGGING_ERR;

Line 1348: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',l_msg_name,err_text );

1344: IF (temp IS NULL) THEN
1345: dumm_status := INVPUOPI.mtl_log_interface_err
1346: ( cr.organization_id,user_id, login_id, prog_appid,
1347: prog_id, request_id,cr.TRANSACTION_ID, error_msg,
1348: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',l_msg_name,err_text );
1349: IF dumm_status < 0 THEN
1350: raise LOGGING_ERR;
1351: END IF;
1352: status := 1;

Line 1371: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1367: dumm_status := INVPUOPI.mtl_log_interface_err
1368: ( cr.organization_id,
1369: user_id, login_id, prog_appid, prog_id, request_id,
1370: cr.TRANSACTION_ID, error_msg,
1371: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1372: l_msg_name,
1373: err_text );
1374: IF dumm_status < 0 THEN
1375: raise LOGGING_ERR;

Line 1396: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1392: dumm_status := INVPUOPI.mtl_log_interface_err
1393: ( cr.organization_id,
1394: user_id, login_id, prog_appid, prog_id, request_id,
1395: cr.TRANSACTION_ID, error_msg,
1396: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1397: l_msg_name, err_text );
1398: IF dumm_status < 0 THEN
1399: raise LOGGING_ERR;
1400: END IF;

Line 1419: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1415: dumm_status := INVPUOPI.mtl_log_interface_err
1416: ( cr.organization_id,
1417: user_id, login_id, prog_appid, prog_id, request_id,
1418: cr.TRANSACTION_ID, error_msg,
1419: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1420: l_msg_name,
1421: err_text );
1422: IF dumm_status < 0 THEN
1423: raise LOGGING_ERR;

Line 1447: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1443: dumm_status := INVPUOPI.mtl_log_interface_err
1444: ( cr.organization_id,
1445: user_id, login_id, prog_appid, prog_id, request_id,
1446: cr.TRANSACTION_ID, error_msg,
1447: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1448: l_msg_name,
1449: err_text );
1450: IF dumm_status < 0 THEN
1451: raise LOGGING_ERR;

Line 1469: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1465: dumm_status := INVPUOPI.mtl_log_interface_err
1466: ( cr.organization_id,
1467: user_id, login_id, prog_appid, prog_id, request_id,
1468: cr.TRANSACTION_ID, error_msg,
1469: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1470: l_msg_name,
1471: err_text );
1472: IF dumm_status < 0 THEN
1473: raise LOGGING_ERR;

Line 1489: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1485: dumm_status := INVPUOPI.mtl_log_interface_err
1486: ( cr.organization_id,
1487: user_id, login_id, prog_appid, prog_id, request_id,
1488: cr.TRANSACTION_ID, error_msg,
1489: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1490: l_msg_name,
1491: err_text );
1492: IF dumm_status < 0 THEN
1493: raise LOGGING_ERR;

Line 1509: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1505: dumm_status := INVPUOPI.mtl_log_interface_err
1506: ( cr.organization_id,
1507: user_id, login_id, prog_appid, prog_id, request_id,
1508: cr.TRANSACTION_ID, error_msg,
1509: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1510: l_msg_name,
1511: err_text );
1512: IF dumm_status < 0 THEN
1513: raise LOGGING_ERR;

Line 1529: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1525: dumm_status := INVPUOPI.mtl_log_interface_err
1526: ( cr.organization_id,
1527: user_id, login_id, prog_appid, prog_id, request_id,
1528: cr.TRANSACTION_ID, error_msg,
1529: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1530: l_msg_name,
1531: err_text );
1532: IF dumm_status < 0 THEN
1533: raise LOGGING_ERR;

Line 1548: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1544: dumm_status := INVPUOPI.mtl_log_interface_err
1545: ( cr.organization_id,
1546: user_id, login_id, prog_appid, prog_id, request_id,
1547: cr.TRANSACTION_ID, error_msg,
1548: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1549: l_msg_name,
1550: err_text );
1551: IF dumm_status < 0 THEN
1552: raise LOGGING_ERR;

Line 1580: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1576: dumm_status := INVPUOPI.mtl_log_interface_err
1577: (cr.organization_id,
1578: user_id, login_id, prog_appid, prog_id, request_id,
1579: cr.TRANSACTION_ID, error_msg,
1580: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1581: l_msg_name, err_text );
1582: IF dumm_status < 0 THEN
1583: raise LOGGING_ERR;
1584: END IF;

Line 1599: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1595: dumm_status := INVPUOPI.mtl_log_interface_err
1596: (cr.organization_id,
1597: user_id, login_id, prog_appid, prog_id, request_id,
1598: cr.TRANSACTION_ID, error_msg,
1599: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1600: l_msg_name, err_text );
1601: IF dumm_status < 0 THEN
1602: raise LOGGING_ERR;
1603: END IF;

Line 1614: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1610: dumm_status := INVPUOPI.mtl_log_interface_err
1611: (cr.organization_id,
1612: user_id, login_id, prog_appid, prog_id, request_id,
1613: cr.TRANSACTION_ID, error_msg,
1614: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1615: l_msg_name, err_text );
1616: IF dumm_status < 0 THEN
1617: raise LOGGING_ERR;
1618: END IF;

Line 1651: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1647: dumm_status := INVPUOPI.mtl_log_interface_err
1648: (cr.organization_id,
1649: user_id, login_id, prog_appid, prog_id, request_id,
1650: cr.TRANSACTION_ID, error_msg,
1651: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1652: l_msg_name, err_text );
1653: IF dumm_status < 0 THEN
1654: raise LOGGING_ERR;
1655: END IF;

Line 1676: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1672: dumm_status := INVPUOPI.mtl_log_interface_err
1673: (cr.organization_id,
1674: user_id, login_id, prog_appid, prog_id, request_id,
1675: cr.TRANSACTION_ID, error_msg,
1676: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1677: l_msg_name, err_text );
1678: IF dumm_status < 0 THEN
1679: raise LOGGING_ERR;
1680: END IF;

Line 1711: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1707: dumm_status := INVPUOPI.mtl_log_interface_err
1708: (cr.organization_id,
1709: user_id, login_id, prog_appid, prog_id, request_id,
1710: cr.TRANSACTION_ID, error_msg,
1711: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1712: l_msg_name, err_text );
1713: IF dumm_status < 0 THEN
1714: raise LOGGING_ERR;
1715: END IF;

Line 1741: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1737: ( cr.organization_id,
1738: user_id, login_id, prog_appid, prog_id, request_id,
1739: cr.TRANSACTION_ID,
1740: error_msg,
1741: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1742: l_msg_name, -- l_msg_token
1743: err_text );
1744: IF dumm_status < 0 THEN
1745: raise LOGGING_ERR;

Line 1768: FROM MTL_SYSTEM_ITEMS_INTERFACE

1764: stmt := 911;
1765:
1766: /* Bug 4705184
1767: SELECT process_flag into temp_proc_flag
1768: FROM MTL_SYSTEM_ITEMS_INTERFACE
1769: WHERE inventory_item_id = l_item_id
1770: AND set_process_id + 0 = xset_id
1771: AND process_flag in (31,32,33,43)
1772: AND organization_id = cr.organization_id

Line 1787: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

1783: IF (temp_proc_flag <> 31 AND
1784: temp_proc_flag <> 32 AND
1785: temp_proc_flag <> 33 )
1786: THEN
1787: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
1788: SET process_flag = DECODE(status,0,44,34),
1789: PRIMARY_UOM_CODE = cr.primary_uom_code,
1790: primary_unit_of_measure = cr.primary_unit_of_measure
1791: WHERE inventory_item_id = l_item_id

Line 1815: 'MTL_SYSTEM_ITEMS_INTERFACE',

1811: request_id,
1812: trans_id,
1813: err_text,
1814: 'validation_error ' || stmt,
1815: 'MTL_SYSTEM_ITEMS_INTERFACE',
1816: 'BOM_OP_VALIDATION_ERR',
1817: err_text);
1818: return (status);
1819: WHEN OTHERS THEN