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

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

Line 484: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 504: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 525: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 549: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 573: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 596: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 619: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 658: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 679: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 703: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 726: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 750: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 774: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 796: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 816: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 837: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 860: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 880: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 902: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 922: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 944: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 964: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 989: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1009: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1031: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1056: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1078: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1100: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1128: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1180: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1176: dumm_status := INVPUOPI.mtl_log_interface_err
1177: ( cr.organization_id,
1178: user_id, login_id, prog_appid, prog_id, request_id,
1179: cr.TRANSACTION_ID, error_msg,
1180: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1181: l_msg_name, -- l_msg_token
1182: err_text );
1183: IF dumm_status < 0 THEN
1184: raise LOGGING_ERR;

Line 1198: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1194: dumm_status := INVPUOPI.mtl_log_interface_err
1195: ( cr.organization_id,
1196: user_id, login_id, prog_appid, prog_id, request_id,
1197: cr.TRANSACTION_ID, error_msg,
1198: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1199: l_msg_name,
1200: err_text );
1201: IF dumm_status < 0 THEN
1202: raise LOGGING_ERR;

Line 1227: 'MTL_SYSTEM_ITEMS_INTERFACE',

1223: request_id,
1224: cr.TRANSACTION_ID,
1225: error_msg,
1226: l_col_name,
1227: 'MTL_SYSTEM_ITEMS_INTERFACE',
1228: l_msg_name,
1229: err_text );
1230: IF dumm_status < 0 THEN
1231: raise LOGGING_ERR;

Line 1245: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1241: dumm_status := INVPUOPI.mtl_log_interface_err
1242: ( cr.organization_id,
1243: user_id, login_id, prog_appid, prog_id, request_id,
1244: cr.TRANSACTION_ID, error_msg,
1245: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1246: l_msg_name,
1247: err_text );
1248: IF dumm_status < 0 THEN
1249: raise LOGGING_ERR;

Line 1266: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1262: dumm_status := INVPUOPI.mtl_log_interface_err
1263: ( cr.organization_id,
1264: user_id, login_id, prog_appid, prog_id, request_id,
1265: cr.TRANSACTION_ID, error_msg,
1266: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1267: l_msg_name,
1268: err_text );
1269: IF dumm_status < 0 THEN
1270: raise LOGGING_ERR;

Line 1289: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1285: dumm_status := INVPUOPI.mtl_log_interface_err
1286: ( cr.organization_id,
1287: user_id, login_id, prog_appid, prog_id, request_id,
1288: cr.TRANSACTION_ID, error_msg,
1289: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1290: l_msg_name,
1291: err_text );
1292: IF dumm_status < 0 THEN
1293: raise LOGGING_ERR;

Line 1326: 'MTL_SYSTEM_ITEMS_INTERFACE',

1322: request_id,
1323: cr.TRANSACTION_ID,
1324: error_msg,
1325: l_col_name,
1326: 'MTL_SYSTEM_ITEMS_INTERFACE',
1327: l_msg_name,
1328: err_text );
1329: IF dumm_status < 0 THEN
1330: raise LOGGING_ERR;

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

1351: IF (temp IS NULL) THEN
1352: dumm_status := INVPUOPI.mtl_log_interface_err
1353: ( cr.organization_id,user_id, login_id, prog_appid,
1354: prog_id, request_id,cr.TRANSACTION_ID, error_msg,
1355: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',l_msg_name,err_text );
1356: IF dumm_status < 0 THEN
1357: raise LOGGING_ERR;
1358: END IF;
1359: status := 1;

Line 1378: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1374: dumm_status := INVPUOPI.mtl_log_interface_err
1375: ( cr.organization_id,
1376: user_id, login_id, prog_appid, prog_id, request_id,
1377: cr.TRANSACTION_ID, error_msg,
1378: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1379: l_msg_name,
1380: err_text );
1381: IF dumm_status < 0 THEN
1382: raise LOGGING_ERR;

Line 1403: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1399: dumm_status := INVPUOPI.mtl_log_interface_err
1400: ( cr.organization_id,
1401: user_id, login_id, prog_appid, prog_id, request_id,
1402: cr.TRANSACTION_ID, error_msg,
1403: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1404: l_msg_name, err_text );
1405: IF dumm_status < 0 THEN
1406: raise LOGGING_ERR;
1407: END IF;

Line 1426: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1422: dumm_status := INVPUOPI.mtl_log_interface_err
1423: ( cr.organization_id,
1424: user_id, login_id, prog_appid, prog_id, request_id,
1425: cr.TRANSACTION_ID, error_msg,
1426: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1427: l_msg_name,
1428: err_text );
1429: IF dumm_status < 0 THEN
1430: raise LOGGING_ERR;

Line 1454: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1450: dumm_status := INVPUOPI.mtl_log_interface_err
1451: ( cr.organization_id,
1452: user_id, login_id, prog_appid, prog_id, request_id,
1453: cr.TRANSACTION_ID, error_msg,
1454: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1455: l_msg_name,
1456: err_text );
1457: IF dumm_status < 0 THEN
1458: raise LOGGING_ERR;

Line 1476: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1472: dumm_status := INVPUOPI.mtl_log_interface_err
1473: ( cr.organization_id,
1474: user_id, login_id, prog_appid, prog_id, request_id,
1475: cr.TRANSACTION_ID, error_msg,
1476: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1477: l_msg_name,
1478: err_text );
1479: IF dumm_status < 0 THEN
1480: raise LOGGING_ERR;

Line 1496: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1492: dumm_status := INVPUOPI.mtl_log_interface_err
1493: ( cr.organization_id,
1494: user_id, login_id, prog_appid, prog_id, request_id,
1495: cr.TRANSACTION_ID, error_msg,
1496: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1497: l_msg_name,
1498: err_text );
1499: IF dumm_status < 0 THEN
1500: raise LOGGING_ERR;

Line 1516: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1512: dumm_status := INVPUOPI.mtl_log_interface_err
1513: ( cr.organization_id,
1514: user_id, login_id, prog_appid, prog_id, request_id,
1515: cr.TRANSACTION_ID, error_msg,
1516: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1517: l_msg_name,
1518: err_text );
1519: IF dumm_status < 0 THEN
1520: raise LOGGING_ERR;

Line 1536: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1532: dumm_status := INVPUOPI.mtl_log_interface_err
1533: ( cr.organization_id,
1534: user_id, login_id, prog_appid, prog_id, request_id,
1535: cr.TRANSACTION_ID, error_msg,
1536: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1537: l_msg_name,
1538: err_text );
1539: IF dumm_status < 0 THEN
1540: raise LOGGING_ERR;

Line 1555: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1551: dumm_status := INVPUOPI.mtl_log_interface_err
1552: ( cr.organization_id,
1553: user_id, login_id, prog_appid, prog_id, request_id,
1554: cr.TRANSACTION_ID, error_msg,
1555: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1556: l_msg_name,
1557: err_text );
1558: IF dumm_status < 0 THEN
1559: raise LOGGING_ERR;

Line 1587: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1583: dumm_status := INVPUOPI.mtl_log_interface_err
1584: (cr.organization_id,
1585: user_id, login_id, prog_appid, prog_id, request_id,
1586: cr.TRANSACTION_ID, error_msg,
1587: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1588: l_msg_name, err_text );
1589: IF dumm_status < 0 THEN
1590: raise LOGGING_ERR;
1591: END IF;

Line 1606: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1602: dumm_status := INVPUOPI.mtl_log_interface_err
1603: (cr.organization_id,
1604: user_id, login_id, prog_appid, prog_id, request_id,
1605: cr.TRANSACTION_ID, error_msg,
1606: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1607: l_msg_name, err_text );
1608: IF dumm_status < 0 THEN
1609: raise LOGGING_ERR;
1610: END IF;

Line 1621: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1617: dumm_status := INVPUOPI.mtl_log_interface_err
1618: (cr.organization_id,
1619: user_id, login_id, prog_appid, prog_id, request_id,
1620: cr.TRANSACTION_ID, error_msg,
1621: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1622: l_msg_name, err_text );
1623: IF dumm_status < 0 THEN
1624: raise LOGGING_ERR;
1625: END IF;

Line 1658: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1654: dumm_status := INVPUOPI.mtl_log_interface_err
1655: (cr.organization_id,
1656: user_id, login_id, prog_appid, prog_id, request_id,
1657: cr.TRANSACTION_ID, error_msg,
1658: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1659: l_msg_name, err_text );
1660: IF dumm_status < 0 THEN
1661: raise LOGGING_ERR;
1662: END IF;

Line 1683: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1679: dumm_status := INVPUOPI.mtl_log_interface_err
1680: (cr.organization_id,
1681: user_id, login_id, prog_appid, prog_id, request_id,
1682: cr.TRANSACTION_ID, error_msg,
1683: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1684: l_msg_name, err_text );
1685: IF dumm_status < 0 THEN
1686: raise LOGGING_ERR;
1687: END IF;

Line 1718: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1714: dumm_status := INVPUOPI.mtl_log_interface_err
1715: (cr.organization_id,
1716: user_id, login_id, prog_appid, prog_id, request_id,
1717: cr.TRANSACTION_ID, error_msg,
1718: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1719: l_msg_name, err_text );
1720: IF dumm_status < 0 THEN
1721: raise LOGGING_ERR;
1722: END IF;

Line 1748: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

1744: ( cr.organization_id,
1745: user_id, login_id, prog_appid, prog_id, request_id,
1746: cr.TRANSACTION_ID,
1747: error_msg,
1748: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',
1749: l_msg_name, -- l_msg_token
1750: err_text );
1751: IF dumm_status < 0 THEN
1752: raise LOGGING_ERR;

Line 1775: FROM MTL_SYSTEM_ITEMS_INTERFACE

1771: stmt := 911;
1772:
1773: /* Bug 4705184
1774: SELECT process_flag into temp_proc_flag
1775: FROM MTL_SYSTEM_ITEMS_INTERFACE
1776: WHERE inventory_item_id = l_item_id
1777: AND set_process_id + 0 = xset_id
1778: AND process_flag in (31,32,33,43)
1779: AND organization_id = cr.organization_id

Line 1794: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

1790: IF (temp_proc_flag <> 31 AND
1791: temp_proc_flag <> 32 AND
1792: temp_proc_flag <> 33 )
1793: THEN
1794: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
1795: SET process_flag = DECODE(status,0,44,34),
1796: PRIMARY_UOM_CODE = cr.primary_uom_code,
1797: primary_unit_of_measure = cr.primary_unit_of_measure
1798: WHERE inventory_item_id = l_item_id

Line 1823: 'MTL_SYSTEM_ITEMS_INTERFACE',

1819: request_id,
1820: trans_id,
1821: err_text,
1822: 'validation_error ' || stmt,
1823: 'MTL_SYSTEM_ITEMS_INTERFACE',
1824: 'BOM_OP_VALIDATION_ERR',
1825: err_text);
1826: return (status);
1827: WHEN OTHERS THEN