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

Line 282: from MTL_SYSTEM_ITEMS_INTERFACE

278: --Adding an attribute for R12
279: DRP_PLANNED_FLAG,
280: -- bug 10230460
281: template_id
282: from MTL_SYSTEM_ITEMS_INTERFACE
283: --Replacing organization_id + 0 with organization_id - Anmurali -Bug 4175124
284: where ((organization_id = org_id) or
285: (all_Org = 1))
286: and set_process_id = xset_id

Line 326: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';

322:
323: IF l_inv_debug_level IN(101, 102) THEN
324: INVPUTLI.info('Inside INVPVDR3');
325: END IF;
326: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';
327:
328: /*
329: ** validate the records
330: */

Line 352: from mtl_system_items_interface

348: */
349: /* Bug 4705184. Get item_id from the cursor itself
350: select inventory_item_id
351: into l_item_id
352: from mtl_system_items_interface
353: where transaction_id = cr.transaction_id
354: and set_process_id = xset_id; */
355:
356:

Line 385: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 408: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 431: 'MTL_SYSTEM_ITEMS_INTERFACE',

427: request_id,
428: cr.TRANSACTION_ID,
429: error_msg,
430: 'ENFORCE_SHIP_TO_LOCATION_CODE',
431: 'MTL_SYSTEM_ITEMS_INTERFACE',
432: 'INV_IOI_ENF_SHIP_TO_LOC',
433: err_text);
434: if dumm_status < 0 then
435: raise LOGGING_ERR;

Line 454: 'MTL_SYSTEM_ITEMS_INTERFACE',

450: request_id,
451: cr.TRANSACTION_ID,
452: error_msg,
453: 'RECEIPT_DAYS_EXCEPTION_CODE',
454: 'MTL_SYSTEM_ITEMS_INTERFACE',
455: 'INV_IOI_REC_DAYS_EXC',
456: err_text);
457: if dumm_status < 0 then
458: raise LOGGING_ERR;

Line 476: 'MTL_SYSTEM_ITEMS_INTERFACE',

472: request_id,
473: cr.TRANSACTION_ID,
474: error_msg,
475: 'LOT_CONTROL_CODE',
476: 'MTL_SYSTEM_ITEMS_INTERFACE',
477: 'INV_IOI_LOT_CTRL_CODE',
478: err_text);
479: if dumm_status < 0 then
480: raise LOGGING_ERR;

Line 497: 'MTL_SYSTEM_ITEMS_INTERFACE',

493: request_id,
494: cr.TRANSACTION_ID,
495: error_msg,
496: 'SHELF_LIFE_CODE',
497: 'MTL_SYSTEM_ITEMS_INTERFACE',
498: 'INV_IOI_SHELF_LIFE_CODE',
499: err_text);
500: if dumm_status < 0 then
501: raise LOGGING_ERR;

Line 521: 'MTL_SYSTEM_ITEMS_INTERFACE',

517: request_id,
518: cr.TRANSACTION_ID,
519: error_msg,
520: 'SERIAL_NUMBER_CONTROL_CODE',
521: 'MTL_SYSTEM_ITEMS_INTERFACE',
522: 'INV_IOI_SERIAL_NUM_CONTROL',
523: err_text);
524: if dumm_status < 0 then
525: raise LOGGING_ERR;

Line 545: 'MTL_SYSTEM_ITEMS_INTERFACE',

541: request_id,
542: cr.TRANSACTION_ID,
543: error_msg,
544: 'SOURCE_TYPE',
545: 'MTL_SYSTEM_ITEMS_INTERFACE',
546: 'INV_IOI_SOURCE_TYPE',
547: err_text);
548: if dumm_status < 0 then
549: raise LOGGING_ERR;

Line 567: 'MTL_SYSTEM_ITEMS_INTERFACE',

563: request_id,
564: cr.TRANSACTION_ID,
565: error_msg,
566: 'RESTRICT_SUBINVENTORIES_CODE',
567: 'MTL_SYSTEM_ITEMS_INTERFACE',
568: 'BOM_OP_VALIDATION_ERR',
569: err_text);
570: if dumm_status < 0 then
571: raise LOGGING_ERR;

Line 589: 'MTL_SYSTEM_ITEMS_INTERFACE',

585: request_id,
586: cr.TRANSACTION_ID,
587: error_msg,
588: 'RESTRICT_LOCATOR_CODE',
589: 'MTL_SYSTEM_ITEMS_INTERFACE',
590: 'INV_IOI_REST_LOC_CODE',
591: err_text);
592: if dumm_status < 0 then
593: raise LOGGING_ERR;

Line 612: 'MTL_SYSTEM_ITEMS_INTERFACE',

608: request_id,
609: cr.TRANSACTION_ID,
610: error_msg,
611: 'LOCATION_CONTROL_CODE',
612: 'MTL_SYSTEM_ITEMS_INTERFACE',
613: 'INV_IOI_LOC_CTRL_CODE',
614: err_text);
615: if dumm_status < 0 then
616: raise LOGGING_ERR;

Line 636: 'MTL_SYSTEM_ITEMS_INTERFACE',

632: request_id,
633: cr.TRANSACTION_ID,
634: error_msg,
635: 'PLANNING_TIME_FENCE_CODE',
636: 'MTL_SYSTEM_ITEMS_INTERFACE',
637: 'INV_IOI_PLN_TIME_FENCE_CODE',
638: err_text);
639: if dumm_status < 0 then
640: raise LOGGING_ERR;

Line 660: 'MTL_SYSTEM_ITEMS_INTERFACE',

656: request_id,
657: cr.TRANSACTION_ID,
658: error_msg,
659: 'DEMAND_TIME_FENCE_CODE',
660: 'MTL_SYSTEM_ITEMS_INTERFACE',
661: 'INV_IOI_DEM_TIME_FENCE_CODE',
662: err_text);
663: if dumm_status < 0 then
664: raise LOGGING_ERR;

Line 684: 'MTL_SYSTEM_ITEMS_INTERFACE',

680: request_id,
681: cr.TRANSACTION_ID,
682: error_msg,
683: 'LOT_STATUS_ENABLED',
684: 'MTL_SYSTEM_ITEMS_INTERFACE',
685: 'INV_INVALID_LOT_STA_ENABLED',
686: err_text);
687: if dumm_status < 0 then
688: raise LOGGING_ERR;

Line 726: 'MTL_SYSTEM_ITEMS_INTERFACE',

722: request_id,
723: cr.TRANSACTION_ID,
724: error_msg,
725: 'SERIAL_NUMBER_CONTROL_CODE',
726: 'MTL_SYSTEM_ITEMS_INTERFACE',
727: 'INV_SER_CNT_FLG_NT_CHG',
728: err_text);
729: if dumm_status < 0 then
730: raise LOGGING_ERR;

Line 759: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 784: 'MTL_SYSTEM_ITEMS_INTERFACE',

780: request_id,
781: cr.TRANSACTION_ID,
782: error_msg,
783: 'MRP_SAFETY_STOCK_CODE',
784: 'MTL_SYSTEM_ITEMS_INTERFACE',
785: 'INV_SAFETY_STOCK',
786: err_text);
787: if dumm_status < 0 then
788: raise LOGGING_ERR;

Line 806: 'MTL_SYSTEM_ITEMS_INTERFACE',

802: request_id,
803: cr.TRANSACTION_ID,
804: error_msg,
805: 'EFFECTIVITY_CONTROL',
806: 'MTL_SYSTEM_ITEMS_INTERFACE',
807: 'INV_IOI_INVALID_EFFECT_CONTL',
808: err_text);
809: if dumm_status < 0 then
810: raise LOGGING_ERR;

Line 828: 'MTL_SYSTEM_ITEMS_INTERFACE',

824: request_id,
825: cr.TRANSACTION_ID,
826: error_msg,
827: 'EFFECTIVITY_CONTROL',
828: 'MTL_SYSTEM_ITEMS_INTERFACE',
829: 'INV_IOI_MODEL_UNIT_CONTROL_NA',
830: err_text);
831: if dumm_status < 0 then
832: raise LOGGING_ERR;

Line 853: 'MTL_SYSTEM_ITEMS_INTERFACE',

849: request_id,
850: cr.TRANSACTION_ID,
851: error_msg,
852: 'SERIAL_NUMBER_CONTROL_CODE',
853: 'MTL_SYSTEM_ITEMS_INTERFACE',
854: 'ITM-EFFC-Invalid Serial Ctrl',
855: err_text);
856: if dumm_status < 0 then
857: raise LOGGING_ERR;

Line 877: 'MTL_SYSTEM_ITEMS_INTERFACE',

873: request_id,
874: cr.TRANSACTION_ID,
875: error_msg,
876: 'BOM_ITEM_TYPE',
877: 'MTL_SYSTEM_ITEMS_INTERFACE',
878: 'ITM-EFFC-BOM Type is not Std',
879: err_text);
880: if dumm_status < 0 then
881: raise LOGGING_ERR;

Line 900: 'MTL_SYSTEM_ITEMS_INTERFACE',

896: request_id,
897: cr.TRANSACTION_ID,
898: error_msg,
899: 'ORDERABLE_ON_WEB_FLAG',
900: 'MTL_SYSTEM_ITEMS_INTERFACE',
901: 'INV_ORDERABLE_ON_WEB',
902: err_text);
903: if dumm_status < 0 then
904: raise LOGGING_ERR;

Line 925: 'MTL_SYSTEM_ITEMS_INTERFACE',

921: request_id,
922: cr.TRANSACTION_ID,
923: error_msg,
924: 'BOM_ITEM_TYPE',
925: 'MTL_SYSTEM_ITEMS_INTERFACE',
926: 'INV_BOM_TYPE',
927: err_text);
928: if dumm_status < 0 then
929: raise LOGGING_ERR;

Line 953: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 974: 'MTL_SYSTEM_ITEMS_INTERFACE',

970: request_id,
971: cr.TRANSACTION_ID,
972: error_msg,
973: 'SERIAL_NUMBER_CONTROL_CODE',
974: 'MTL_SYSTEM_ITEMS_INTERFACE',
975: 'INV-ITM-EQMT-INVALID_SER_CTRL',
976: err_text);
977: if dumm_status < 0 then
978: raise LOGGING_ERR;

Line 994: 'MTL_SYSTEM_ITEMS_INTERFACE',

990: request_id,
991: cr.TRANSACTION_ID,
992: error_msg,
993: 'OVERCOMPLETION_TOLERANCE_VALUE',
994: 'MTL_SYSTEM_ITEMS_INTERFACE',
995: 'INV_WIP_OC_TOLERANCE_V_NUPD',
996: err_text);
997: if dumm_status < 0 then
998: raise LOGGING_ERR;

Line 1021: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 1046: 'MTL_SYSTEM_ITEMS_INTERFACE',

1042: request_id,
1043: cr.TRANSACTION_ID,
1044: error_msg,
1045: 'DEFAULT_SERIAL_STATUS_ID',
1046: 'MTL_SYSTEM_ITEMS_INTERFACE',
1047: l_err_msg,
1048: err_text);
1049: if dumm_status < 0 then
1050: raise LOGGING_ERR;

Line 1066: from MTL_SYSTEM_ITEMS_INTERFACE

1062: ** 32, 42 :set by INVPVDR2
1063: */
1064: /* Bug 4705184. Get process flag from the cursor itself
1065: select process_flag into temp_proc_flag
1066: from MTL_SYSTEM_ITEMS_INTERFACE
1067: where inventory_item_id = l_item_id
1068: and organization_id = cr.organization_id
1069: and process_flag in (31,32,42)
1070: and set_process_id = xset_id

Line 1079: update MTL_SYSTEM_ITEMS_INTERFACE

1075: ** Essentially, we check to see if validation has not already failed in one of
1076: ** the previous packages.
1077: */
1078: if (temp_proc_flag <> 31 and temp_proc_flag <> 32) then
1079: update MTL_SYSTEM_ITEMS_INTERFACE
1080: set process_flag = DECODE(status,0,43,33),
1081: PRIMARY_UOM_CODE = cr.primary_uom_code,
1082: primary_unit_of_measure = cr.primary_unit_of_measure
1083: where inventory_item_id = l_item_id

Line 1109: 'MTL_SYSTEM_ITEMS_INTERFACE',

1105: request_id,
1106: trans_id,
1107: err_text,
1108: 'validation_error ' || stmt,
1109: 'MTL_SYSTEM_ITEMS_INTERFACE',
1110: 'BOM_OP_VALIDATION_ERR',
1111: err_text);
1112: return(status);
1113: when OTHERS then