DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_ACTIONS_LEVELS

Line 827: l_validation_level_tab := wsh_actions_levels.g_validation_level_tab;

823:
824: x_return_status := wsh_util_core.g_ret_sts_success;
825: --
826: /* Patchset I : Harmonization Project */
827: l_validation_level_tab := wsh_actions_levels.g_validation_level_tab;
828: /* OPM changes NC - added l_requested_quantity2 */
829: OPEN c_find_delivery_detail(p_from_detail_id);
830: FETCH c_find_delivery_detail INTO l_line_direction, l_received_quantity,
831: l_received_quantity2, l_requested_quantity,

Line 870: IF (l_validation_level_tab(wsh_actions_levels.c_decimal_quantity_lvl) = 1) THEN

866: END IF;
867:
868: /* PATCHSET I: Harmonization Project. validate decimal quantity */
869:
870: IF (l_validation_level_tab(wsh_actions_levels.c_decimal_quantity_lvl) = 1) THEN
871: OPEN det_cur(p_from_detail_id);
872: FETCH det_cur INTO l_inv_item_id, l_organization_id,
873: l_requested_quantity_uom, l_top_model_line_id;
874: CLOSE det_cur;

Line 2643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ACTIONS_LEVELS.SET_VALIDATION_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);

2639: --
2640: --
2641: -- Set validation level
2642: IF l_debug_on THEN
2643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ACTIONS_LEVELS.SET_VALIDATION_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);
2644: WSH_DEBUG_SV.log(l_module_name,'l_action_code',l_action_code);
2645: END IF;
2646: --
2647: wsh_actions_levels.set_validation_level(

Line 2647: wsh_actions_levels.set_validation_level(

2643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ACTIONS_LEVELS.SET_VALIDATION_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);
2644: WSH_DEBUG_SV.log(l_module_name,'l_action_code',l_action_code);
2645: END IF;
2646: --
2647: wsh_actions_levels.set_validation_level(
2648: p_entity => 'DLVB',
2649: p_caller => p_action_prms.caller,
2650: p_phase => nvl(p_action_prms.phase,1),
2651: p_action => l_action_code,

Line 2667: l_validation_level_tab := wsh_actions_levels.g_validation_level_tab;

2663: x_num_errors => l_number_of_errors,
2664: p_msg_data => l_msg_data
2665: );
2666:
2667: l_validation_level_tab := wsh_actions_levels.g_validation_level_tab;
2668:
2669: -- Need to create l_detail_rec_tab to call Is_Action_Enabled
2670:
2671: l_index := p_rec_attr_tab.FIRST;

Line 2702: IF l_validation_level_tab(wsh_actions_levels.C_ACTION_ENABLED_LVL) = 1 THEN

2698: END LOOP;
2699:
2700:
2701: -- Call Is_Action_Enabled API depending on validation level
2702: IF l_validation_level_tab(wsh_actions_levels.C_ACTION_ENABLED_LVL) = 1 THEN
2703: --
2704: IF l_debug_on THEN
2705: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.IS_ACTION_ENABLED',WSH_DEBUG_SV.C_PROC_LEVEL);
2706: END IF;

Line 2748: IF( l_validation_level_tab(wsh_actions_levels.C_DLVY_ACTION_ENABLED_LVL) = 1) THEN

2744: raise FND_API.G_EXC_ERROR;
2745: --}
2746: END IF;
2747:
2748: IF( l_validation_level_tab(wsh_actions_levels.C_DLVY_ACTION_ENABLED_LVL) = 1) THEN
2749:
2750: --
2751: IF(p_action_prms.delivery_id IS NOT NULL) THEN
2752:

Line 2827: IF l_validation_level_tab(wsh_actions_levels.C_LOCK_RECORDS_LVL) = 1 THEN

2823: --
2824: END IF;
2825:
2826: -- Lock records
2827: IF l_validation_level_tab(wsh_actions_levels.C_LOCK_RECORDS_LVL) = 1 THEN
2828:
2829: -- we need to send only the valid records to lock procedure
2830: -- Build the table using the valid index output from Is_Action_Enabled
2831: IF l_debug_on THEN

Line 2888: IF l_validation_level_tab(wsh_actions_levels.C_VALIDATE_CONSTRAINTS_LVL) = 1

2884: END IF;
2885: END IF;
2886:
2887:
2888: IF l_validation_level_tab(wsh_actions_levels.C_VALIDATE_CONSTRAINTS_LVL) = 1
2889: THEN --{
2890:
2891: --Compatibility Changes
2892: -- Autocreate trip calls autocreate del and then autocreate trip so the constraint validation

Line 4003: IF l_validation_level_tab(wsh_actions_levels.C_DECIMAL_QUANTITY_LVL)= 1 THEN

3999: wsh_debug_sv.log(l_module_name, 'BO qty', l_bo_qtys(1));
4000: END IF;
4001:
4002:
4003: IF l_validation_level_tab(wsh_actions_levels.C_DECIMAL_QUANTITY_LVL)= 1 THEN
4004: --
4005: --
4006: OPEN det_cur(l_id_tab(l_id_tab.first));
4007: FETCH det_cur

Line 5025: l_verify_org_level := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONTAINER_ORG_LVL);

5021: -- This portion creates or generates containers for non-wms callers
5022:
5023: --validate the container item, and org bmso
5024:
5025: l_verify_org_level := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONTAINER_ORG_LVL);
5026:
5027: l_verify_cont_item := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONT_ITEM_LVL);
5028:
5029: l_organization_id := p_detail_IN_rec.organization_id;

Line 5027: l_verify_cont_item := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONT_ITEM_LVL);

5023: --validate the container item, and org bmso
5024:
5025: l_verify_org_level := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONTAINER_ORG_LVL);
5026:
5027: l_verify_cont_item := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONT_ITEM_LVL);
5028:
5029: l_organization_id := p_detail_IN_rec.organization_id;
5030: l_organization_code := p_detail_IN_rec.organization_code;
5031: --

Line 7565: IF (p_validation_tab(wsh_actions_levels.c_tol_above_lvl) = 1) THEN

7561:
7562: -- HW Harmonization project for OPM. Need to check if org is discrete or process
7563: -- HW OPMCONV - Removed checking for process org
7564:
7565: IF (p_validation_tab(wsh_actions_levels.c_tol_above_lvl) = 1) THEN
7566: IF l_debug_on THEN
7567: WSH_DEBUG_SV.log(l_module_name, 'Ship Tolerance Above', x_detail_rec.ship_tolerance_above);
7568: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',
7569: WSH_DEBUG_SV.c_proc_level);

Line 7587: IF (p_validation_tab(wsh_actions_levels.c_tol_below_lvl) = 1) THEN

7583: p_msg_data => l_msg_data
7584: );
7585: END IF;
7586:
7587: IF (p_validation_tab(wsh_actions_levels.c_tol_below_lvl) = 1) THEN
7588: IF l_debug_on THEN
7589: WSH_DEBUG_SV.log(l_module_name, 'Ship Tolerance Below', x_detail_rec.ship_tolerance_below);
7590: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.c_proc_level);
7591: END IF;

Line 7666: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1

7662: WSH_DEBUG_SV.log(l_module_name, 'l_lot_number', l_lot);
7663: END IF;
7664:
7665: -- UT bug fix 2657367
7666: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1
7667: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1
7668: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1
7669: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1
7670: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1

Line 7667: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1

7663: END IF;
7664:
7665: -- UT bug fix 2657367
7666: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1
7667: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1
7668: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1
7669: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1
7670: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7671: THEN

Line 7668: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1

7664:
7665: -- UT bug fix 2657367
7666: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1
7667: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1
7668: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1
7669: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1
7670: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7671: THEN
7672: --(

Line 7669: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1

7665: -- UT bug fix 2657367
7666: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1
7667: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1
7668: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1
7669: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1
7670: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7671: THEN
7672: --(
7673: IF l_debug_on THEN

Line 7670: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1

7666: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1
7667: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1
7668: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1
7669: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1
7670: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7671: THEN
7672: --(
7673: IF l_debug_on THEN
7674: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS', WSH_DEBUG_SV.c_proc_level);

Line 7705: IF (p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1) THEN

7701: END IF;
7702:
7703: -- UT bug fix 2657367
7704:
7705: IF (p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1) THEN
7706: IF l_debug_on THEN
7707: WSH_DEBUG_SV.log(l_module_name, 'Shipped Qty', x_detail_rec.shipped_quantity);
7708: WSH_DEBUG_SV.log(l_module_name, 'Existing Shipped Qty', p_original_rec.shipped_quantity);
7709: END IF;

Line 7790: IF (p_validation_tab(wsh_actions_levels.c_ship_qty2_lvl) = 1) THEN

7786:
7787: -- HW Harmonization project for OPM.
7788: -- HW OPMCONV - Removed checking for process_flag
7789:
7790: IF (p_validation_tab(wsh_actions_levels.c_ship_qty2_lvl) = 1) THEN
7791: IF (x_detail_rec.shipped_quantity2 <> fnd_api.g_miss_num) THEN
7792: l_det_qty_rec.delivery_detail_id :=
7793: x_detail_rec.delivery_detail_id;
7794: l_det_qty_rec.requested_quantity :=

Line 7849: IF (p_validation_tab(wsh_actions_levels.c_cc_qty_lvl) = 1) THEN

7845: END IF; -- of C_SHIP_QTY2_LVL
7846:
7847: -- HW OPM end of changes
7848:
7849: IF (p_validation_tab(wsh_actions_levels.c_cc_qty_lvl) = 1) THEN
7850: IF l_debug_on THEN
7851: WSH_DEBUG_SV.log(l_module_name, 'Cycle_Count Qty', x_detail_rec.cycle_count_quantity);
7852: WSH_DEBUG_SV.log(l_module_name, 'Existing Cycle_Count Qty', p_original_rec.cycle_count_quantity);
7853: END IF;

Line 7909: IF (p_validation_tab(wsh_actions_levels.c_cc_qty2_lvl) = 1) THEN

7905:
7906: -- HW Harmonization project for OPM. Added cycle_count_qty2
7907: -- HW OPMCONV - Removed checking for process_flag
7908:
7909: IF (p_validation_tab(wsh_actions_levels.c_cc_qty2_lvl) = 1) THEN
7910: IF (x_detail_rec.cycle_count_quantity2 <> fnd_api.g_miss_num) THEN
7911: l_det_qty_rec.delivery_detail_id :=
7912: x_detail_rec.delivery_detail_id;
7913: l_det_qty_rec.requested_quantity :=

Line 7966: IF (p_validation_tab(wsh_actions_levels.c_smc_lvl) = 1) THEN

7962: END IF; -- of C_CC_QTY2_LVL
7963:
7964: -- HW OPM end of changes
7965:
7966: IF (p_validation_tab(wsh_actions_levels.c_smc_lvl) = 1) THEN
7967: IF (x_detail_rec.ship_method_code <> fnd_api.g_miss_char) THEN
7968: IF l_debug_on THEN
7969: WSH_DEBUG_SV.log(l_module_name, 'Ship Method', x_detail_rec.ship_method_code);
7970: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD', WSH_DEBUG_SV.c_proc_level);

Line 7988: IF (p_validation_tab(wsh_actions_levels.c_dep_plan_lvl) = 1) THEN

7984: );
7985: END IF;
7986: END IF;
7987:
7988: IF (p_validation_tab(wsh_actions_levels.c_dep_plan_lvl) = 1) THEN
7989: IF (x_detail_rec.dep_plan_required_flag <> fnd_api.g_miss_char) THEN
7990: IF l_debug_on THEN
7991: WSH_DEBUG_SV.log(l_module_name, 'Departure Plan Flag', x_detail_rec.dep_plan_required_flag);
7992: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);

Line 8009: IF (p_validation_tab(wsh_actions_levels.c_ship_mod_comp_lvl) = 1) THEN

8005: );
8006: END IF;
8007: END IF;
8008:
8009: IF (p_validation_tab(wsh_actions_levels.c_ship_mod_comp_lvl) = 1) THEN
8010: IF (x_detail_rec.ship_model_complete_flag <> fnd_api.g_miss_char) THEN
8011: IF l_debug_on THEN
8012: WSH_DEBUG_SV.log(l_module_name, 'Ship Model Complete Flag', x_detail_rec.ship_model_complete_flag);
8013: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);

Line 8030: IF (p_validation_tab(wsh_actions_levels.c_sub_inv_lvl) = 1) THEN

8026: );
8027: END IF;
8028: END IF;
8029:
8030: IF (p_validation_tab(wsh_actions_levels.c_sub_inv_lvl) = 1) THEN
8031: IF (x_detail_rec.subinventory <> fnd_api.g_miss_char) THEN
8032: IF l_debug_on THEN
8033: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', x_detail_rec.subinventory);
8034: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SUBINVENTORY', WSH_DEBUG_SV.c_proc_level);

Line 8071: IF (p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1)

8067: x_mark_reprice_flag := 'Y';
8068: END IF;
8069: END IF;
8070:
8071: IF (p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1)
8072: THEN
8073: -- {
8074: IF (x_detail_rec.revision <> fnd_api.g_miss_char)
8075: THEN

Line 8133: IF (p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1) THEN

8129: END IF;
8130: -- }
8131: END IF;
8132:
8133: IF (p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1) THEN
8134: IF (x_detail_rec.locator_id <> fnd_api.g_miss_num)
8135: THEN
8136: -- {
8137: -- UT bug fix 2657367

Line 8196: IF (p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1) THEN

8192: -- }
8193: END IF;
8194: END IF;
8195:
8196: IF (p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1) THEN
8197: IF (x_detail_rec.lot_number <> fnd_api.g_miss_char) THEN
8198: -- HW Harmonization project for OPM. Need to branch
8199: -- HW OPMCONV - Removed branching
8200:

Line 8277: IF (p_validation_tab(wsh_actions_levels.c_sold_contact_lvl) = 1) THEN

8273:
8274: /* Since we are updating by delivery_detail, make sure source_line_id is populated */
8275: x_detail_rec.source_line_id := p_original_rec.source_line_id;
8276:
8277: IF (p_validation_tab(wsh_actions_levels.c_sold_contact_lvl) = 1) THEN
8278: IF (x_detail_rec.sold_to_contact_id <> fnd_api.g_miss_num) THEN
8279: IF l_debug_on THEN
8280: WSH_DEBUG_SV.log(l_module_name, 'Sold to Contact', x_detail_rec.sold_to_contact_id);
8281: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

Line 8297: IF (p_validation_tab(wsh_actions_levels.c_ship_contact_lvl) = 1) THEN

8293: );
8294: END IF;
8295: END IF;
8296:
8297: IF (p_validation_tab(wsh_actions_levels.c_ship_contact_lvl) = 1) THEN
8298: IF (x_detail_rec.ship_to_contact_id <> fnd_api.g_miss_num) THEN
8299: IF l_debug_on THEN
8300: WSH_DEBUG_SV.log(l_module_name, 'Ship to Contact Id', x_detail_rec.ship_to_contact_id);
8301: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

Line 8318: IF (p_validation_tab(wsh_actions_levels.c_deliver_contact_lvl) = 1) THEN

8314: );
8315: END IF;
8316: END IF;
8317:
8318: IF (p_validation_tab(wsh_actions_levels.c_deliver_contact_lvl) = 1) THEN
8319: IF (x_detail_rec.deliver_to_contact_id <> fnd_api.g_miss_num) THEN
8320: IF l_debug_on THEN
8321: WSH_DEBUG_SV.log(l_module_name, 'Deliver To Contact', x_detail_rec.deliver_to_contact_id);
8322: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

Line 8339: IF (p_validation_tab(wsh_actions_levels.c_intmed_ship_contact_lvl) = 1) THEN

8335: );
8336: END IF;
8337: END IF;
8338:
8339: IF (p_validation_tab(wsh_actions_levels.c_intmed_ship_contact_lvl) = 1) THEN
8340: IF (x_detail_rec.intmed_ship_to_contact_id <> fnd_api.g_miss_num) THEN
8341: IF l_debug_on THEN
8342: WSH_DEBUG_SV.log(l_module_name, 'Intmed Ship To Contact', x_detail_rec.intmed_ship_to_contact_id);
8343: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

Line 8362: IF (p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1) THEN

8358: END IF;
8359:
8360: -- HW Harmonization project for OPM. This is applicable for discrete only
8361: -- added a check for l_process_flag
8362: IF (p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1) THEN
8363: l_detail_ser_count := 0;
8364: l_detail_ser_qty := 0;
8365: l_index := p_serial_range_tab.FIRST;
8366: l_det_index := 1;

Line 9300: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_CONT_ITEM_LVL) = 1 ) THEN

9296: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
9297: l_number_of_errors := 0;
9298: l_number_of_warnings := 0;
9299:
9300: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_CONT_ITEM_LVL) = 1 ) THEN
9301: IF (x_detail_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
9302: --
9303: IF l_debug_on THEN
9304: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item Id', x_detail_rec.inventory_item_id);

Line 9515: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_GROSS_WEIGHT_LVL) = 1 ) THEN

9511: l_number_of_warnings := 0;
9512:
9513: --HW OPMCONV - Removed checking for process org
9514:
9515: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_GROSS_WEIGHT_LVL) = 1 ) THEN
9516: IF l_debug_on THEN
9517: WSH_DEBUG_SV.log(l_module_name, 'Gross Weight', x_detail_rec.gross_weight);
9518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9519: END IF;

Line 9536: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_NET_WEIGHT_LVL) = 1 ) THEN

9532:
9533: x_mark_reprice_flag := 'Y';
9534: END IF;
9535:
9536: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_NET_WEIGHT_LVL) = 1 ) THEN
9537: --
9538: IF l_debug_on THEN
9539: WSH_DEBUG_SV.log(l_module_name, 'Net Weight', x_detail_rec.net_weight);
9540: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 9559: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_VOLUME_LVL) = 1 ) THEN

9555: x_mark_reprice_flag := 'Y';
9556: END IF;
9557:
9558:
9559: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_VOLUME_LVL) = 1 ) THEN
9560: --
9561: IF l_debug_on THEN
9562: WSH_DEBUG_SV.log(l_module_name, 'Volume', x_detail_rec.volume);
9563: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 9581: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_MASTER_SER_NUM_LVL) = 1 ) THEN

9577:
9578: x_mark_reprice_flag := 'Y';
9579: END IF;
9580:
9581: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_MASTER_SER_NUM_LVL) = 1 ) THEN
9582: IF(x_detail_rec.master_serial_number IS NOT NULL) THEN
9583: IF l_debug_on THEN
9584: WSH_DEBUG_SV.log(l_module_name, 'Original container Flag', p_original_rec.container_flag);
9585: WSH_DEBUG_SV.log(l_module_name, 'Master Serial Number', x_detail_rec.master_serial_number);

Line 9617: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_DET_INSPECT_FLAG_LVL) = 1 ) THEN

9613: END IF;
9614:
9615: END IF;
9616:
9617: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_DET_INSPECT_FLAG_LVL) = 1 ) THEN
9618: -- Cannot set the inspection_Flag to N if it is already I or R
9619:
9620: IF x_detail_rec.inspection_flag IS NOT NULL THEN
9621: IF l_debug_on THEN

Line 9637: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_MASTER_LPN_ITEM_LVL) = 1) THEN

9633: END IF;
9634:
9635: END IF;
9636:
9637: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_MASTER_LPN_ITEM_LVL) = 1) THEN
9638: IF x_detail_rec.master_container_item_id IS NOT NULL THEN
9639:
9640: IF l_debug_on THEN
9641: WSH_DEBUG_SV.log(l_module_name, 'Master cont item id', x_detail_rec.master_container_item_id);

Line 9663: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_DETAIL_LPN_ITEM_LVL) = 1) THEN

9659: );
9660: END IF;
9661: END IF;
9662:
9663: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_DETAIL_LPN_ITEM_LVL) = 1) THEN
9664: IF x_detail_rec.detail_container_item_id IS NOT NULL THEN
9665:
9666: IF l_debug_on THEN
9667: WSH_DEBUG_SV.log(l_module_name, 'Detail cont item id', x_detail_rec.Detail_container_item_id);

Line 10049: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ACTIONS_LEVELS.SET_VALIDATION_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);

10045:
10046: -- Set Validation Level
10047:
10048: IF l_debug_on THEN
10049: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ACTIONS_LEVELS.SET_VALIDATION_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);
10050: END IF;
10051: --
10052: wsh_actions_levels.set_validation_level(
10053: p_entity => 'DLVB',

Line 10052: wsh_actions_levels.set_validation_level(

10048: IF l_debug_on THEN
10049: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ACTIONS_LEVELS.SET_VALIDATION_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);
10050: END IF;
10051: --
10052: wsh_actions_levels.set_validation_level(
10053: p_entity => 'DLVB',
10054: p_caller => p_In_rec.caller,
10055: p_phase => p_In_rec.phase,
10056: p_action => p_In_rec.action_code,

Line 10068: l_validation_tab := WSH_ACTIONS_LEVELS.G_VALIDATION_LEVEL_TAB;

10064: x_num_errors => l_number_of_errors,
10065: p_msg_data => l_msg_data
10066: );
10067: --
10068: l_validation_tab := WSH_ACTIONS_LEVELS.G_VALIDATION_LEVEL_TAB;
10069:
10070: -- Get Disabled List
10071: --
10072: IF(l_validation_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1) THEN

Line 10072: IF(l_validation_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1) THEN

10068: l_validation_tab := WSH_ACTIONS_LEVELS.G_VALIDATION_LEVEL_TAB;
10069:
10070: -- Get Disabled List
10071: --
10072: IF(l_validation_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1) THEN
10073: l_index := p_detail_info_tab.FIRST;
10074: WHILE l_index IS NOT NULL
10075: LOOP
10076: --

Line 10274: IF(l_validation_tab(WSH_ACTIONS_LEVELS.C_WMS_CONTAINERS_LVL) = 1) THEN--{ lpn conv

10270: RAISE FND_API.G_EXC_ERROR;
10271: END IF;
10272:
10273: -- anxsharm for Load Tender
10274: IF(l_validation_tab(WSH_ACTIONS_LEVELS.C_WMS_CONTAINERS_LVL) = 1) THEN--{ lpn conv
10275: Validate_Delivery_Detail(
10276: x_detail_info_tab => l_detail_info_tab,
10277: p_in_detail_tab => p_detail_info_tab,
10278: p_action => p_In_rec.action_code,