DBA Data[Home] [Help]

APPS.INVPVDR3 dependencies on INVPUOPI

Line 372: dumm_status := INVPUOPI.mtl_log_interface_err(

368:
369: IF l_inv_debug_level IN(101, 102) THEN
370: INVPUTLI.info('INVPVDR3: inside the if..ie validation failed');
371: END IF;
372: dumm_status := INVPUOPI.mtl_log_interface_err(
373: cr.organization_id,
374: user_id,
375: login_id,
376: prog_appid,

Line 395: dumm_status := INVPUOPI.mtl_log_interface_err(

391: -- validate lookup
392: if (cr.qty_rcv_exception_code <> 'NONE' and
393: cr.qty_rcv_exception_code <> 'REJECT' and
394: cr.qty_rcv_exception_code <> 'WARNING') then
395: dumm_status := INVPUOPI.mtl_log_interface_err(
396: cr.organization_id,
397: user_id,
398: login_id,
399: prog_appid,

Line 418: dumm_status := INVPUOPI.mtl_log_interface_err(

414: -- validate lookup
415: if (cr.enforce_ship_to_location_code <> 'NONE' and
416: cr.enforce_ship_to_location_code <> 'REJECT' and
417: cr.enforce_ship_to_location_code <> 'WARNING') then
418: dumm_status := INVPUOPI.mtl_log_interface_err(
419: cr.organization_id,
420: user_id,
421: login_id,
422: prog_appid,

Line 441: dumm_status := INVPUOPI.mtl_log_interface_err(

437: -- validate lookup
438: if (cr.receipt_days_exception_code <> 'NONE' and
439: cr.receipt_days_exception_code <> 'REJECT' and
440: cr.receipt_days_exception_code <> 'WARNING') then
441: dumm_status := INVPUOPI.mtl_log_interface_err(
442: cr.organization_id,
443: user_id,
444: login_id,
445: prog_appid,

Line 463: dumm_status := INVPUOPI.mtl_log_interface_err(

459:
460: -- validate lookup
461: if (cr.lot_control_code <> 1 and
462: cr.lot_control_code <> 2) then
463: dumm_status := INVPUOPI.mtl_log_interface_err(
464: cr.organization_id,
465: user_id,
466: login_id,
467: prog_appid,

Line 484: dumm_status := INVPUOPI.mtl_log_interface_err(

480: end if;
481:
482: -- validate lookup
483: if (cr.shelf_life_code not in (1, 2, 4)) then
484: dumm_status := INVPUOPI.mtl_log_interface_err(
485: cr.organization_id,
486: user_id,
487: login_id,
488: prog_appid,

Line 508: dumm_status := INVPUOPI.mtl_log_interface_err(

504: if (cr.serial_number_control_code <> 1 and
505: cr.serial_number_control_code <> 2 and
506: cr.serial_number_control_code <> 5 and
507: cr.serial_number_control_code <> 6 ) then
508: dumm_status := INVPUOPI.mtl_log_interface_err(
509: cr.organization_id,
510: user_id,
511: login_id,
512: prog_appid,

Line 532: dumm_status := INVPUOPI.mtl_log_interface_err(

528: if (cr.source_type is not null) then
529: if (cr.source_type <> 1 and
530: cr.source_type <> 2 and
531: cr.source_type <> 3) then
532: dumm_status := INVPUOPI.mtl_log_interface_err(
533: cr.organization_id,
534: user_id,
535: login_id,
536: prog_appid,

Line 554: dumm_status := INVPUOPI.mtl_log_interface_err(

550: end if;
551: -- validate lookup
552: if (cr.restrict_subinventories_code <> 1 and
553: cr.restrict_subinventories_code <> 2) then
554: dumm_status := INVPUOPI.mtl_log_interface_err(
555: cr.organization_id,
556: user_id,
557: login_id,
558: prog_appid,

Line 576: dumm_status := INVPUOPI.mtl_log_interface_err(

572:
573: -- validate lookup
574: if (cr.restrict_locators_code <> 1 and
575: cr.restrict_locators_code <> 2) then
576: dumm_status := INVPUOPI.mtl_log_interface_err(
577: cr.organization_id,
578: user_id,
579: login_id,
580: prog_appid,

Line 599: dumm_status := INVPUOPI.mtl_log_interface_err(

595: -- validate lookup
596: if (cr.location_control_code <> 1 and
597: cr.location_control_code <> 2 and
598: cr.location_control_code <> 3) then
599: dumm_status := INVPUOPI.mtl_log_interface_err(
600: cr.organization_id,
601: user_id,
602: login_id,
603: prog_appid,

Line 623: dumm_status := INVPUOPI.mtl_log_interface_err(

619: if (cr.planning_time_fence_code <> 1 and
620: cr.planning_time_fence_code <> 2 and
621: cr.planning_time_fence_code <> 3 and
622: cr.planning_time_fence_code <> 4) then
623: dumm_status := INVPUOPI.mtl_log_interface_err(
624: cr.organization_id,
625: user_id,
626: login_id,
627: prog_appid,

Line 647: dumm_status := INVPUOPI.mtl_log_interface_err(

643: if (cr.demand_time_fence_code <> 1 and
644: cr.demand_time_fence_code <> 2 and
645: cr.demand_time_fence_code <> 3 and
646: cr.demand_time_fence_code <> 4) then
647: dumm_status := INVPUOPI.mtl_log_interface_err(
648: cr.organization_id,
649: user_id,
650: login_id,
651: prog_appid,

Line 671: dumm_status := INVPUOPI.mtl_log_interface_err(

667: INVPUTLI.info('INVPVDR3: verifying lot status....');
668: END IF;
669:
670: if (cr.LOT_CONTROL_CODE = 1 and NVL(cr.LOT_STATUS_ENABLED,'N') = 'Y') then
671: dumm_status := INVPUOPI.mtl_log_interface_err(
672: cr.organization_id,
673: user_id,
674: login_id,
675: prog_appid,

Line 695: dumm_status := INVPUOPI.mtl_log_interface_err(

691: IF l_inv_debug_level IN(101, 102) THEN
692: INVPUTLI.info('INVPVDR3: verifying serial status....');
693: END IF;
694: if (cr.SERIAL_NUMBER_CONTROL_CODE = 1 and NVL(cr.SERIAL_STATUS_ENABLED,'N') = 'Y') then
695: dumm_status := INVPUOPI.mtl_log_interface_err(
696: cr.organization_id,
697: user_id,
698: login_id,
699: prog_appid,

Line 719: dumm_status := INVPUOPI.mtl_log_interface_err(

715: if ( cr.MRP_PLANNING_CODE = 6
716: -- Adding the NVL for Bug 5239406
717: and NVL(cr.drp_planned_flag,2) = 2 -- Adding the clause for R12
718: and cr.MRP_SAFETY_STOCK_CODE <> 1) then
719: dumm_status := INVPUOPI.mtl_log_interface_err(
720: cr.organization_id,
721: user_id,
722: login_id,
723: prog_appid,

Line 741: dumm_status := INVPUOPI.mtl_log_interface_err(

737: -- Start 2958422 : Effectivity Control Validations
738: if cr.EFFECTIVITY_CONTROL IS NOT NULL
739: AND cr.EFFECTIVITY_CONTROL NOT IN (1,2)
740: then
741: dumm_status := INVPUOPI.mtl_log_interface_err(
742: cr.organization_id,
743: user_id,
744: login_id,
745: prog_appid,

Line 763: dumm_status := INVPUOPI.mtl_log_interface_err(

759:
760: if cr.EFFECTIVITY_CONTROL = 2
761: AND INV_ITEM_UTIL.g_Appl_Inst.PJM_Unit_Eff_flag ='N'
762: then
763: dumm_status := INVPUOPI.mtl_log_interface_err(
764: cr.organization_id,
765: user_id,
766: login_id,
767: prog_appid,

Line 788: dumm_status := INVPUOPI.mtl_log_interface_err(

784: IF l_inv_debug_level IN(101, 102) THEN
785: INVPUTLI.info('INVPVDR3: verifying serial status....');
786: END IF;
787: if (cr.SERIAL_NUMBER_CONTROL_CODE = 1 and cr.EFFECTIVITY_CONTROL = 2) then
788: dumm_status := INVPUOPI.mtl_log_interface_err(
789: cr.organization_id,
790: user_id,
791: login_id,
792: prog_appid,

Line 812: dumm_status := INVPUOPI.mtl_log_interface_err(

808: IF l_inv_debug_level IN(101, 102) THEN
809: INVPUTLI.info('INVPVDR3: verifying bom item type for effectivity control....');
810: END IF;
811: if (cr.BOM_ITEM_TYPE <> 4 and cr.EFFECTIVITY_CONTROL = 2) then
812: dumm_status := INVPUOPI.mtl_log_interface_err(
813: cr.organization_id,
814: user_id,
815: login_id,
816: prog_appid,

Line 835: dumm_status := INVPUOPI.mtl_log_interface_err(

831: IF l_inv_debug_level IN(101, 102) THEN
832: INVPUTLI.info('INVPVDR3: verifying serial status....');
833: END IF;
834: if (NVL(cr.CUSTOMER_ORDER_ENABLED_FLAG,'N') = 'N' and NVL(cr.ORDERABLE_ON_WEB_FLAG,'N') = 'Y') then
835: dumm_status := INVPUOPI.mtl_log_interface_err(
836: cr.organization_id,
837: user_id,
838: login_id,
839: prog_appid,

Line 860: dumm_status := INVPUOPI.mtl_log_interface_err(

856: INVPUTLI.info('INVPVDR3: verifying serial status....');
857: END IF;
858: if ((cr.BOM_ITEM_TYPE = 1 OR cr.BOM_ITEM_TYPE = 2 )
859: AND NVL(cr.PICK_COMPONENTS_FLAG,'N') = 'N' AND NVL(cr.REPLENISH_TO_ORDER_FLAG,'N') = 'N') then
860: dumm_status := INVPUOPI.mtl_log_interface_err(
861: cr.organization_id,
862: user_id,
863: login_id,
864: prog_appid,

Line 888: dumm_status := INVPUOPI.mtl_log_interface_err(

884: elsif(cr.SHELF_LIFE_CODE = 2 AND cr.SHELF_LIFE_DAYS = 0 )then
885: l_err_msg := 'INV_SHELF_DAYS_MUST_BE_GT_ZERO';
886: end if;
887: if (l_err_msg IS NOT NULL) then
888: dumm_status := INVPUOPI.mtl_log_interface_err(
889: cr.organization_id,
890: user_id,
891: login_id,
892: prog_appid,

Line 909: dumm_status := INVPUOPI.mtl_log_interface_err(

905: end if;
906:
907: -- Bug No:3436107 if Equipment is set to yes, then Serial number generation has to be `Receipt or Predefined
908: if (cr.SERIAL_NUMBER_CONTROL_CODE NOT IN (2,5) and cr.EQUIPMENT_TYPE = 1) then
909: dumm_status := INVPUOPI.mtl_log_interface_err(
910: cr.organization_id,
911: user_id,
912: login_id,
913: prog_appid,

Line 929: dumm_status := INVPUOPI.mtl_log_interface_err(

925: status := 1;
926: end if;
927: -- Bug No:3969580 If OVERCOMPLETION_TOLERANCE_TYPE is not specified then OVER_COMPLETION_TOLERANCE_VALUE must throw an error msg on entry
928: if (cr.OVERCOMPLETION_TOLERANCE_TYPE IS NULL)and (cr.OVERCOMPLETION_TOLERANCE_VALUE IS NOT NULL) then
929: dumm_status := INVPUOPI.mtl_log_interface_err(
930: cr.organization_id,
931: user_id,
932: login_id,
933: prog_appid,

Line 956: dumm_status := INVPUOPI.mtl_log_interface_err(

952: elsif (cr.DEFAULT_LOT_STATUS_ID IS NOT NULL and NVL(cr.LOT_STATUS_ENABLED,'N') = 'N') then
953: l_err_msg := 'INV_DEF_LOT_STATUS_ID_NULL';
954: end if;
955: if l_err_msg IS NOT NULL then
956: dumm_status := INVPUOPI.mtl_log_interface_err(
957: cr.organization_id,
958: user_id,
959: login_id,
960: prog_appid,

Line 981: dumm_status := INVPUOPI.mtl_log_interface_err(

977: elsif (cr.DEFAULT_SERIAL_STATUS_ID IS NOT NULL and NVL(cr.SERIAL_STATUS_ENABLED,'N') = 'N') then
978: l_err_msg := 'INV_DEF_SERIAL_STATUS_ID_NULL';
979: end if;
980: if l_err_msg IS NOT NULL then
981: dumm_status := INVPUOPI.mtl_log_interface_err(
982: cr.organization_id,
983: user_id,
984: login_id,
985: prog_appid,

Line 1043: dumm_status := INVPUOPI.mtl_log_interface_err(

1039: exception
1040: when LOGGING_ERR then
1041: return(dumm_status);
1042: when VALIDATE_ERR then
1043: dumm_status := INVPUOPI.mtl_log_interface_err(
1044: l_org_id,
1045: user_id,
1046: login_id,
1047: prog_appid,