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 280: from MTL_SYSTEM_ITEMS_INTERFACE

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

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

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

Line 349: from mtl_system_items_interface

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

Line 382: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 405: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 428: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 451: 'MTL_SYSTEM_ITEMS_INTERFACE',

447: request_id,
448: cr.TRANSACTION_ID,
449: error_msg,
450: 'RECEIPT_DAYS_EXCEPTION_CODE',
451: 'MTL_SYSTEM_ITEMS_INTERFACE',
452: 'INV_IOI_REC_DAYS_EXC',
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: 'LOT_CONTROL_CODE',
473: 'MTL_SYSTEM_ITEMS_INTERFACE',
474: 'INV_IOI_LOT_CTRL_CODE',
475: err_text);
476: if dumm_status < 0 then
477: raise LOGGING_ERR;

Line 494: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 518: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 542: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 564: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 586: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 609: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 633: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 657: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 681: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 705: 'MTL_SYSTEM_ITEMS_INTERFACE',

701: request_id,
702: cr.TRANSACTION_ID,
703: error_msg,
704: 'SERIAL_STATUS_ENABLED',
705: 'MTL_SYSTEM_ITEMS_INTERFACE',
706: 'INV_INVALID_SER_STA_ENABLED',
707: err_text);
708: if dumm_status < 0 then
709: raise LOGGING_ERR;

Line 729: 'MTL_SYSTEM_ITEMS_INTERFACE',

725: request_id,
726: cr.TRANSACTION_ID,
727: error_msg,
728: 'MRP_SAFETY_STOCK_CODE',
729: 'MTL_SYSTEM_ITEMS_INTERFACE',
730: 'INV_SAFETY_STOCK',
731: err_text);
732: if dumm_status < 0 then
733: raise LOGGING_ERR;

Line 751: 'MTL_SYSTEM_ITEMS_INTERFACE',

747: request_id,
748: cr.TRANSACTION_ID,
749: error_msg,
750: 'EFFECTIVITY_CONTROL',
751: 'MTL_SYSTEM_ITEMS_INTERFACE',
752: 'INV_IOI_INVALID_EFFECT_CONTL',
753: err_text);
754: if dumm_status < 0 then
755: raise LOGGING_ERR;

Line 773: 'MTL_SYSTEM_ITEMS_INTERFACE',

769: request_id,
770: cr.TRANSACTION_ID,
771: error_msg,
772: 'EFFECTIVITY_CONTROL',
773: 'MTL_SYSTEM_ITEMS_INTERFACE',
774: 'INV_IOI_MODEL_UNIT_CONTROL_NA',
775: err_text);
776: if dumm_status < 0 then
777: raise LOGGING_ERR;

Line 798: 'MTL_SYSTEM_ITEMS_INTERFACE',

794: request_id,
795: cr.TRANSACTION_ID,
796: error_msg,
797: 'SERIAL_NUMBER_CONTROL_CODE',
798: 'MTL_SYSTEM_ITEMS_INTERFACE',
799: 'ITM-EFFC-Invalid Serial Ctrl',
800: err_text);
801: if dumm_status < 0 then
802: raise LOGGING_ERR;

Line 822: 'MTL_SYSTEM_ITEMS_INTERFACE',

818: request_id,
819: cr.TRANSACTION_ID,
820: error_msg,
821: 'BOM_ITEM_TYPE',
822: 'MTL_SYSTEM_ITEMS_INTERFACE',
823: 'ITM-EFFC-BOM Type is not Std',
824: err_text);
825: if dumm_status < 0 then
826: raise LOGGING_ERR;

Line 845: 'MTL_SYSTEM_ITEMS_INTERFACE',

841: request_id,
842: cr.TRANSACTION_ID,
843: error_msg,
844: 'ORDERABLE_ON_WEB_FLAG',
845: 'MTL_SYSTEM_ITEMS_INTERFACE',
846: 'INV_ORDERABLE_ON_WEB',
847: err_text);
848: if dumm_status < 0 then
849: raise LOGGING_ERR;

Line 870: 'MTL_SYSTEM_ITEMS_INTERFACE',

866: request_id,
867: cr.TRANSACTION_ID,
868: error_msg,
869: 'BOM_ITEM_TYPE',
870: 'MTL_SYSTEM_ITEMS_INTERFACE',
871: 'INV_BOM_TYPE',
872: err_text);
873: if dumm_status < 0 then
874: raise LOGGING_ERR;

Line 898: 'MTL_SYSTEM_ITEMS_INTERFACE',

894: request_id,
895: cr.TRANSACTION_ID,
896: error_msg,
897: 'SHELF_LIFE_DAYS',
898: 'MTL_SYSTEM_ITEMS_INTERFACE',
899: l_err_msg,
900: err_text);
901: if dumm_status < 0 then
902: raise LOGGING_ERR;

Line 919: 'MTL_SYSTEM_ITEMS_INTERFACE',

915: request_id,
916: cr.TRANSACTION_ID,
917: error_msg,
918: 'SERIAL_NUMBER_CONTROL_CODE',
919: 'MTL_SYSTEM_ITEMS_INTERFACE',
920: 'INV-ITM-EQMT-INVALID_SER_CTRL',
921: err_text);
922: if dumm_status < 0 then
923: raise LOGGING_ERR;

Line 939: 'MTL_SYSTEM_ITEMS_INTERFACE',

935: request_id,
936: cr.TRANSACTION_ID,
937: error_msg,
938: 'OVERCOMPLETION_TOLERANCE_VALUE',
939: 'MTL_SYSTEM_ITEMS_INTERFACE',
940: 'INV_WIP_OC_TOLERANCE_V_NUPD',
941: err_text);
942: if dumm_status < 0 then
943: raise LOGGING_ERR;

Line 966: 'MTL_SYSTEM_ITEMS_INTERFACE',

962: request_id,
963: cr.TRANSACTION_ID,
964: error_msg,
965: 'DEFAULT_LOT_STATUS_ID',
966: 'MTL_SYSTEM_ITEMS_INTERFACE',
967: l_err_msg,
968: err_text);
969: if dumm_status < 0 then
970: raise LOGGING_ERR;

Line 991: 'MTL_SYSTEM_ITEMS_INTERFACE',

987: request_id,
988: cr.TRANSACTION_ID,
989: error_msg,
990: 'DEFAULT_SERIAL_STATUS_ID',
991: 'MTL_SYSTEM_ITEMS_INTERFACE',
992: l_err_msg,
993: err_text);
994: if dumm_status < 0 then
995: raise LOGGING_ERR;

Line 1011: from MTL_SYSTEM_ITEMS_INTERFACE

1007: ** 32, 42 :set by INVPVDR2
1008: */
1009: /* Bug 4705184. Get process flag from the cursor itself
1010: select process_flag into temp_proc_flag
1011: from MTL_SYSTEM_ITEMS_INTERFACE
1012: where inventory_item_id = l_item_id
1013: and organization_id = cr.organization_id
1014: and process_flag in (31,32,42)
1015: and set_process_id = xset_id

Line 1024: update MTL_SYSTEM_ITEMS_INTERFACE

1020: ** Essentially, we check to see if validation has not already failed in one of
1021: ** the previous packages.
1022: */
1023: if (temp_proc_flag <> 31 and temp_proc_flag <> 32) then
1024: update MTL_SYSTEM_ITEMS_INTERFACE
1025: set process_flag = DECODE(status,0,43,33),
1026: PRIMARY_UOM_CODE = cr.primary_uom_code,
1027: primary_unit_of_measure = cr.primary_unit_of_measure
1028: where inventory_item_id = l_item_id

Line 1053: 'MTL_SYSTEM_ITEMS_INTERFACE',

1049: request_id,
1050: trans_id,
1051: err_text,
1052: 'validation_error ' || stmt,
1053: 'MTL_SYSTEM_ITEMS_INTERFACE',
1054: 'BOM_OP_VALIDATION_ERR',
1055: err_text);
1056: return(status);
1057: when OTHERS then