DBA Data[Home] [Help]

APPS.INVPVDR3 dependencies on INVPUOPI

Line 375: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 398: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 421: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 444: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 466: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 487: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 511: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 535: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 557: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 579: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 602: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 626: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 650: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 674: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 716: dumm_status := INVPUOPI.mtl_log_interface_err(

712: OR
713: (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => cr.template_id
714: , p_organization_id => l_temp_org_id)=2) then
715:
716: dumm_status := INVPUOPI.mtl_log_interface_err(
717: cr.organization_id,
718: user_id,
719: login_id,
720: prog_appid,

Line 749: dumm_status := INVPUOPI.mtl_log_interface_err(

745: -- bug 10230460
746: AND (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => cr.template_id)<>2)
747: THEN
748:
749: dumm_status := INVPUOPI.mtl_log_interface_err(
750: cr.organization_id,
751: user_id,
752: login_id,
753: prog_appid,

Line 774: dumm_status := INVPUOPI.mtl_log_interface_err(

770: if ( cr.MRP_PLANNING_CODE = 6
771: -- Adding the NVL for Bug 5239406
772: and NVL(cr.drp_planned_flag,2) = 2 -- Adding the clause for R12
773: and cr.MRP_SAFETY_STOCK_CODE <> 1) then
774: dumm_status := INVPUOPI.mtl_log_interface_err(
775: cr.organization_id,
776: user_id,
777: login_id,
778: prog_appid,

Line 796: dumm_status := INVPUOPI.mtl_log_interface_err(

792: -- Start 2958422 : Effectivity Control Validations
793: if cr.EFFECTIVITY_CONTROL IS NOT NULL
794: AND cr.EFFECTIVITY_CONTROL NOT IN (1,2)
795: then
796: dumm_status := INVPUOPI.mtl_log_interface_err(
797: cr.organization_id,
798: user_id,
799: login_id,
800: prog_appid,

Line 818: dumm_status := INVPUOPI.mtl_log_interface_err(

814:
815: if cr.EFFECTIVITY_CONTROL = 2
816: AND INV_ITEM_UTIL.g_Appl_Inst.PJM_Unit_Eff_flag ='N'
817: then
818: dumm_status := INVPUOPI.mtl_log_interface_err(
819: cr.organization_id,
820: user_id,
821: login_id,
822: prog_appid,

Line 843: dumm_status := INVPUOPI.mtl_log_interface_err(

839: IF l_inv_debug_level IN(101, 102) THEN
840: INVPUTLI.info('INVPVDR3: verifying serial status....');
841: END IF;
842: if (cr.SERIAL_NUMBER_CONTROL_CODE = 1 and cr.EFFECTIVITY_CONTROL = 2) then
843: dumm_status := INVPUOPI.mtl_log_interface_err(
844: cr.organization_id,
845: user_id,
846: login_id,
847: prog_appid,

Line 867: dumm_status := INVPUOPI.mtl_log_interface_err(

863: IF l_inv_debug_level IN(101, 102) THEN
864: INVPUTLI.info('INVPVDR3: verifying bom item type for effectivity control....');
865: END IF;
866: if (cr.BOM_ITEM_TYPE <> 4 and cr.EFFECTIVITY_CONTROL = 2) then
867: dumm_status := INVPUOPI.mtl_log_interface_err(
868: cr.organization_id,
869: user_id,
870: login_id,
871: prog_appid,

Line 890: dumm_status := INVPUOPI.mtl_log_interface_err(

886: IF l_inv_debug_level IN(101, 102) THEN
887: INVPUTLI.info('INVPVDR3: verifying serial status....');
888: END IF;
889: if (NVL(cr.CUSTOMER_ORDER_ENABLED_FLAG,'N') = 'N' and NVL(cr.ORDERABLE_ON_WEB_FLAG,'N') = 'Y') then
890: dumm_status := INVPUOPI.mtl_log_interface_err(
891: cr.organization_id,
892: user_id,
893: login_id,
894: prog_appid,

Line 915: dumm_status := INVPUOPI.mtl_log_interface_err(

911: INVPUTLI.info('INVPVDR3: verifying serial status....');
912: END IF;
913: if ((cr.BOM_ITEM_TYPE = 1 OR cr.BOM_ITEM_TYPE = 2 )
914: AND NVL(cr.PICK_COMPONENTS_FLAG,'N') = 'N' AND NVL(cr.REPLENISH_TO_ORDER_FLAG,'N') = 'N') then
915: dumm_status := INVPUOPI.mtl_log_interface_err(
916: cr.organization_id,
917: user_id,
918: login_id,
919: prog_appid,

Line 943: dumm_status := INVPUOPI.mtl_log_interface_err(

939: elsif(cr.SHELF_LIFE_CODE = 2 AND cr.SHELF_LIFE_DAYS = 0 )then
940: l_err_msg := 'INV_SHELF_DAYS_MUST_BE_GT_ZERO';
941: end if;
942: if (l_err_msg IS NOT NULL) then
943: dumm_status := INVPUOPI.mtl_log_interface_err(
944: cr.organization_id,
945: user_id,
946: login_id,
947: prog_appid,

Line 964: dumm_status := INVPUOPI.mtl_log_interface_err(

960: end if;
961:
962: -- Bug No:3436107 if Equipment is set to yes, then Serial number generation has to be `Receipt or Predefined
963: if (cr.SERIAL_NUMBER_CONTROL_CODE NOT IN (2,5) and cr.EQUIPMENT_TYPE = 1) then
964: dumm_status := INVPUOPI.mtl_log_interface_err(
965: cr.organization_id,
966: user_id,
967: login_id,
968: prog_appid,

Line 984: dumm_status := INVPUOPI.mtl_log_interface_err(

980: status := 1;
981: end if;
982: -- Bug No:3969580 If OVERCOMPLETION_TOLERANCE_TYPE is not specified then OVER_COMPLETION_TOLERANCE_VALUE must throw an error msg on entry
983: if (cr.OVERCOMPLETION_TOLERANCE_TYPE IS NULL)and (cr.OVERCOMPLETION_TOLERANCE_VALUE IS NOT NULL) then
984: dumm_status := INVPUOPI.mtl_log_interface_err(
985: cr.organization_id,
986: user_id,
987: login_id,
988: prog_appid,

Line 1011: dumm_status := INVPUOPI.mtl_log_interface_err(

1007: elsif (cr.DEFAULT_LOT_STATUS_ID IS NOT NULL and NVL(cr.LOT_STATUS_ENABLED,'N') = 'N') then
1008: l_err_msg := 'INV_DEF_LOT_STATUS_ID_NULL';
1009: end if;
1010: if l_err_msg IS NOT NULL then
1011: dumm_status := INVPUOPI.mtl_log_interface_err(
1012: cr.organization_id,
1013: user_id,
1014: login_id,
1015: prog_appid,

Line 1036: dumm_status := INVPUOPI.mtl_log_interface_err(

1032: elsif (cr.DEFAULT_SERIAL_STATUS_ID IS NOT NULL and NVL(cr.SERIAL_STATUS_ENABLED,'N') = 'N') then
1033: l_err_msg := 'INV_DEF_SERIAL_STATUS_ID_NULL';
1034: end if;
1035: if l_err_msg IS NOT NULL then
1036: dumm_status := INVPUOPI.mtl_log_interface_err(
1037: cr.organization_id,
1038: user_id,
1039: login_id,
1040: prog_appid,

Line 1099: dumm_status := INVPUOPI.mtl_log_interface_err(

1095: exception
1096: when LOGGING_ERR then
1097: return(dumm_status);
1098: when VALIDATE_ERR then
1099: dumm_status := INVPUOPI.mtl_log_interface_err(
1100: l_org_id,
1101: user_id,
1102: login_id,
1103: prog_appid,