DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_ACTIONS_LEVELS

Line 831: l_validation_level_tab := wsh_actions_levels.g_validation_level_tab;

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

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

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

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

2645: --
2646: --
2647: -- Set validation level
2648: IF l_debug_on THEN
2649: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ACTIONS_LEVELS.SET_VALIDATION_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);
2650: WSH_DEBUG_SV.log(l_module_name,'l_action_code',l_action_code);
2651: END IF;
2652: --
2653: wsh_actions_levels.set_validation_level(

Line 2653: wsh_actions_levels.set_validation_level(

2649: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ACTIONS_LEVELS.SET_VALIDATION_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);
2650: WSH_DEBUG_SV.log(l_module_name,'l_action_code',l_action_code);
2651: END IF;
2652: --
2653: wsh_actions_levels.set_validation_level(
2654: p_entity => 'DLVB',
2655: p_caller => p_action_prms.caller,
2656: p_phase => nvl(p_action_prms.phase,1),
2657: p_action => l_action_code,

Line 2673: l_validation_level_tab := wsh_actions_levels.g_validation_level_tab;

2669: x_num_errors => l_number_of_errors,
2670: p_msg_data => l_msg_data
2671: );
2672:
2673: l_validation_level_tab := wsh_actions_levels.g_validation_level_tab;
2674:
2675: -- Need to create l_detail_rec_tab to call Is_Action_Enabled
2676:
2677: l_index := p_rec_attr_tab.FIRST;

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

2704: END LOOP;
2705:
2706:
2707: -- Call Is_Action_Enabled API depending on validation level
2708: IF l_validation_level_tab(wsh_actions_levels.C_ACTION_ENABLED_LVL) = 1 THEN
2709: --
2710: IF l_debug_on THEN
2711: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.IS_ACTION_ENABLED',WSH_DEBUG_SV.C_PROC_LEVEL);
2712: END IF;

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

2750: raise FND_API.G_EXC_ERROR;
2751: --}
2752: END IF;
2753:
2754: IF( l_validation_level_tab(wsh_actions_levels.C_DLVY_ACTION_ENABLED_LVL) = 1) THEN
2755:
2756: --
2757: IF(p_action_prms.delivery_id IS NOT NULL) THEN
2758:

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

2829: --
2830: END IF;
2831:
2832: -- Lock records
2833: IF l_validation_level_tab(wsh_actions_levels.C_LOCK_RECORDS_LVL) = 1 THEN
2834:
2835: -- we need to send only the valid records to lock procedure
2836: -- Build the table using the valid index output from Is_Action_Enabled
2837: IF l_debug_on THEN

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

2890: END IF;
2891: END IF;
2892:
2893:
2894: IF l_validation_level_tab(wsh_actions_levels.C_VALIDATE_CONSTRAINTS_LVL) = 1
2895: THEN --{
2896:
2897: --Compatibility Changes
2898: -- Autocreate trip calls autocreate del and then autocreate trip so the constraint validation

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

4008: wsh_debug_sv.log(l_module_name, 'BO qty', l_bo_qtys(1));
4009: END IF;
4010:
4011:
4012: IF l_validation_level_tab(wsh_actions_levels.C_DECIMAL_QUANTITY_LVL)= 1 THEN
4013: --
4014: --
4015: OPEN det_cur(l_id_tab(l_id_tab.first));
4016: FETCH det_cur

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

5031: -- This portion creates or generates containers for non-wms callers
5032:
5033: --validate the container item, and org bmso
5034:
5035: l_verify_org_level := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONTAINER_ORG_LVL);
5036:
5037: l_verify_cont_item := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONT_ITEM_LVL);
5038:
5039: l_organization_id := p_detail_IN_rec.organization_id;

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

5033: --validate the container item, and org bmso
5034:
5035: l_verify_org_level := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONTAINER_ORG_LVL);
5036:
5037: l_verify_cont_item := WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONT_ITEM_LVL);
5038:
5039: l_organization_id := p_detail_IN_rec.organization_id;
5040: l_organization_code := p_detail_IN_rec.organization_code;
5041: --

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

7678:
7679: -- HW Harmonization project for OPM. Need to check if org is discrete or process
7680: -- HW OPMCONV - Removed checking for process org
7681:
7682: IF (p_validation_tab(wsh_actions_levels.c_tol_above_lvl) = 1) THEN
7683: IF l_debug_on THEN
7684: WSH_DEBUG_SV.log(l_module_name, 'Ship Tolerance Above', x_detail_rec.ship_tolerance_above);
7685: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',
7686: WSH_DEBUG_SV.c_proc_level);

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

7700: p_msg_data => l_msg_data
7701: );
7702: END IF;
7703:
7704: IF (p_validation_tab(wsh_actions_levels.c_tol_below_lvl) = 1) THEN
7705: IF l_debug_on THEN
7706: WSH_DEBUG_SV.log(l_module_name, 'Ship Tolerance Below', x_detail_rec.ship_tolerance_below);
7707: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.c_proc_level);
7708: END IF;

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

7779: WSH_DEBUG_SV.log(l_module_name, 'l_lot_number', l_lot);
7780: END IF;
7781:
7782: -- UT bug fix 2657367
7783: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1
7784: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1
7785: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1
7786: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1
7787: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1

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

7780: END IF;
7781:
7782: -- UT bug fix 2657367
7783: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1
7784: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1
7785: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1
7786: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1
7787: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7788: THEN

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

7781:
7782: -- UT bug fix 2657367
7783: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1
7784: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1
7785: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1
7786: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1
7787: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7788: THEN
7789: --(

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

7782: -- UT bug fix 2657367
7783: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1
7784: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1
7785: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1
7786: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1
7787: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7788: THEN
7789: --(
7790: IF l_debug_on THEN

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

7783: IF p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1
7784: OR p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1
7785: OR p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1
7786: OR p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1
7787: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7788: THEN
7789: --(
7790: IF l_debug_on THEN
7791: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS', WSH_DEBUG_SV.c_proc_level);

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

7818: END IF;
7819:
7820: -- UT bug fix 2657367
7821:
7822: IF (p_validation_tab(wsh_actions_levels.c_ship_qty_lvl) = 1) THEN
7823: IF l_debug_on THEN
7824: WSH_DEBUG_SV.log(l_module_name, 'Shipped Qty', x_detail_rec.shipped_quantity);
7825: WSH_DEBUG_SV.log(l_module_name, 'Existing Shipped Qty', p_original_rec.shipped_quantity);
7826: END IF;

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

7903:
7904: -- HW Harmonization project for OPM.
7905: -- HW OPMCONV - Removed checking for process_flag
7906:
7907: IF (p_validation_tab(wsh_actions_levels.c_ship_qty2_lvl) = 1) THEN
7908: IF (x_detail_rec.shipped_quantity2 <> fnd_api.g_miss_num) THEN
7909: l_det_qty_rec.delivery_detail_id :=
7910: x_detail_rec.delivery_detail_id;
7911: l_det_qty_rec.requested_quantity :=

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

7962: END IF; -- of C_SHIP_QTY2_LVL
7963:
7964: -- HW OPM end of changes
7965:
7966: IF (p_validation_tab(wsh_actions_levels.c_cc_qty_lvl) = 1) THEN
7967: IF l_debug_on THEN
7968: WSH_DEBUG_SV.log(l_module_name, 'Cycle_Count Qty', x_detail_rec.cycle_count_quantity);
7969: WSH_DEBUG_SV.log(l_module_name, 'Existing Cycle_Count Qty', p_original_rec.cycle_count_quantity);
7970: END IF;

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

8022:
8023: -- HW Harmonization project for OPM. Added cycle_count_qty2
8024: -- HW OPMCONV - Removed checking for process_flag
8025:
8026: IF (p_validation_tab(wsh_actions_levels.c_cc_qty2_lvl) = 1) THEN
8027: IF (x_detail_rec.cycle_count_quantity2 <> fnd_api.g_miss_num) THEN
8028: l_det_qty_rec.delivery_detail_id :=
8029: x_detail_rec.delivery_detail_id;
8030: l_det_qty_rec.requested_quantity :=

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

8079: END IF; -- of C_CC_QTY2_LVL
8080:
8081: -- HW OPM end of changes
8082:
8083: IF (p_validation_tab(wsh_actions_levels.c_smc_lvl) = 1) THEN
8084: IF (x_detail_rec.ship_method_code <> fnd_api.g_miss_char) THEN
8085: IF l_debug_on THEN
8086: WSH_DEBUG_SV.log(l_module_name, 'Ship Method', x_detail_rec.ship_method_code);
8087: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD', WSH_DEBUG_SV.c_proc_level);

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

8101: );
8102: END IF;
8103: END IF;
8104:
8105: IF (p_validation_tab(wsh_actions_levels.c_dep_plan_lvl) = 1) THEN
8106: IF (x_detail_rec.dep_plan_required_flag <> fnd_api.g_miss_char) THEN
8107: IF l_debug_on THEN
8108: WSH_DEBUG_SV.log(l_module_name, 'Departure Plan Flag', x_detail_rec.dep_plan_required_flag);
8109: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);

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

8122: );
8123: END IF;
8124: END IF;
8125:
8126: IF (p_validation_tab(wsh_actions_levels.c_ship_mod_comp_lvl) = 1) THEN
8127: IF (x_detail_rec.ship_model_complete_flag <> fnd_api.g_miss_char) THEN
8128: IF l_debug_on THEN
8129: WSH_DEBUG_SV.log(l_module_name, 'Ship Model Complete Flag', x_detail_rec.ship_model_complete_flag);
8130: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);

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

8143: );
8144: END IF;
8145: END IF;
8146:
8147: IF (p_validation_tab(wsh_actions_levels.c_sub_inv_lvl) = 1) THEN
8148: IF (x_detail_rec.subinventory <> fnd_api.g_miss_char) THEN
8149: IF l_debug_on THEN
8150: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', x_detail_rec.subinventory);
8151: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SUBINVENTORY', WSH_DEBUG_SV.c_proc_level);

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

8184: x_mark_reprice_flag := 'Y';
8185: END IF;
8186: END IF;
8187:
8188: IF (p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1)
8189: THEN
8190: -- {
8191: IF (x_detail_rec.revision <> fnd_api.g_miss_char)
8192: THEN

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

8246: END IF;
8247: -- }
8248: END IF;
8249:
8250: IF (p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1) THEN
8251: IF (x_detail_rec.locator_id <> fnd_api.g_miss_num)
8252: THEN
8253: -- {
8254: -- UT bug fix 2657367

Line 8313: IF (p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1) AND

8309: -- }
8310: END IF;
8311: END IF;
8312:
8313: IF (p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1) AND
8314: p_original_rec.inv_interfaced_flag NOT IN ('Y','X') THEN -- Added for bug 13574503
8315: IF (x_detail_rec.lot_number <> fnd_api.g_miss_char) THEN
8316: -- HW Harmonization project for OPM. Need to branch
8317: -- HW OPMCONV - Removed branching

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

8392:
8393: /* Since we are updating by delivery_detail, make sure source_line_id is populated */
8394: x_detail_rec.source_line_id := p_original_rec.source_line_id;
8395:
8396: IF (p_validation_tab(wsh_actions_levels.c_sold_contact_lvl) = 1) THEN
8397: IF (x_detail_rec.sold_to_contact_id <> fnd_api.g_miss_num) THEN
8398: IF l_debug_on THEN
8399: WSH_DEBUG_SV.log(l_module_name, 'Sold to Contact', x_detail_rec.sold_to_contact_id);
8400: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

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

8412: );
8413: END IF;
8414: END IF;
8415:
8416: IF (p_validation_tab(wsh_actions_levels.c_ship_contact_lvl) = 1) THEN
8417: IF (x_detail_rec.ship_to_contact_id <> fnd_api.g_miss_num) THEN
8418: IF l_debug_on THEN
8419: WSH_DEBUG_SV.log(l_module_name, 'Ship to Contact Id', x_detail_rec.ship_to_contact_id);
8420: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

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

8433: );
8434: END IF;
8435: END IF;
8436:
8437: IF (p_validation_tab(wsh_actions_levels.c_deliver_contact_lvl) = 1) THEN
8438: IF (x_detail_rec.deliver_to_contact_id <> fnd_api.g_miss_num) THEN
8439: IF l_debug_on THEN
8440: WSH_DEBUG_SV.log(l_module_name, 'Deliver To Contact', x_detail_rec.deliver_to_contact_id);
8441: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

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

8454: );
8455: END IF;
8456: END IF;
8457:
8458: IF (p_validation_tab(wsh_actions_levels.c_intmed_ship_contact_lvl) = 1) THEN
8459: IF (x_detail_rec.intmed_ship_to_contact_id <> fnd_api.g_miss_num) THEN
8460: IF l_debug_on THEN
8461: WSH_DEBUG_SV.log(l_module_name, 'Intmed Ship To Contact', x_detail_rec.intmed_ship_to_contact_id);
8462: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

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

8477: END IF;
8478:
8479: -- HW Harmonization project for OPM. This is applicable for discrete only
8480: -- added a check for l_process_flag
8481: IF (p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1) THEN
8482: l_detail_ser_count := 0;
8483: l_detail_ser_qty := 0;
8484: l_index := p_serial_range_tab.FIRST;
8485: l_det_index := 1;

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

9416: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
9417: l_number_of_errors := 0;
9418: l_number_of_warnings := 0;
9419:
9420: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_CONT_ITEM_LVL) = 1 ) THEN
9421: IF (x_detail_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
9422: --
9423: IF l_debug_on THEN
9424: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item Id', x_detail_rec.inventory_item_id);

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

9631: l_number_of_warnings := 0;
9632:
9633: --HW OPMCONV - Removed checking for process org
9634:
9635: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_GROSS_WEIGHT_LVL) = 1 ) THEN
9636: IF l_debug_on THEN
9637: WSH_DEBUG_SV.log(l_module_name, 'Gross Weight', x_detail_rec.gross_weight);
9638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9639: END IF;

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

9652:
9653: x_mark_reprice_flag := 'Y';
9654: END IF;
9655:
9656: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_NET_WEIGHT_LVL) = 1 ) THEN
9657: --
9658: IF l_debug_on THEN
9659: WSH_DEBUG_SV.log(l_module_name, 'Net Weight', x_detail_rec.net_weight);
9660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);

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

9675: x_mark_reprice_flag := 'Y';
9676: END IF;
9677:
9678:
9679: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_VOLUME_LVL) = 1 ) THEN
9680: --
9681: IF l_debug_on THEN
9682: WSH_DEBUG_SV.log(l_module_name, 'Volume', x_detail_rec.volume);
9683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);

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

9697:
9698: x_mark_reprice_flag := 'Y';
9699: END IF;
9700:
9701: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_MASTER_SER_NUM_LVL) = 1 ) THEN
9702: IF(x_detail_rec.master_serial_number IS NOT NULL) THEN
9703: IF l_debug_on THEN
9704: WSH_DEBUG_SV.log(l_module_name, 'Original container Flag', p_original_rec.container_flag);
9705: WSH_DEBUG_SV.log(l_module_name, 'Master Serial Number', x_detail_rec.master_serial_number);

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

9733: END IF;
9734:
9735: END IF;
9736:
9737: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_DET_INSPECT_FLAG_LVL) = 1 ) THEN
9738: -- Cannot set the inspection_Flag to N if it is already I or R
9739:
9740: IF x_detail_rec.inspection_flag IS NOT NULL THEN
9741: IF l_debug_on THEN

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

9753: END IF;
9754:
9755: END IF;
9756:
9757: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_MASTER_LPN_ITEM_LVL) = 1) THEN
9758: IF x_detail_rec.master_container_item_id IS NOT NULL THEN
9759:
9760: IF l_debug_on THEN
9761: WSH_DEBUG_SV.log(l_module_name, 'Master cont item id', x_detail_rec.master_container_item_id);

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

9779: );
9780: END IF;
9781: END IF;
9782:
9783: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_DETAIL_LPN_ITEM_LVL) = 1) THEN
9784: IF x_detail_rec.detail_container_item_id IS NOT NULL THEN
9785:
9786: IF l_debug_on THEN
9787: WSH_DEBUG_SV.log(l_module_name, 'Detail cont item id', x_detail_rec.Detail_container_item_id);

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

10165:
10166: -- Set Validation Level
10167:
10168: IF l_debug_on THEN
10169: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ACTIONS_LEVELS.SET_VALIDATION_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);
10170: END IF;
10171: --
10172: wsh_actions_levels.set_validation_level(
10173: p_entity => 'DLVB',

Line 10172: wsh_actions_levels.set_validation_level(

10168: IF l_debug_on THEN
10169: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ACTIONS_LEVELS.SET_VALIDATION_LEVEL',WSH_DEBUG_SV.C_PROC_LEVEL);
10170: END IF;
10171: --
10172: wsh_actions_levels.set_validation_level(
10173: p_entity => 'DLVB',
10174: p_caller => p_In_rec.caller,
10175: p_phase => p_In_rec.phase,
10176: p_action => p_In_rec.action_code,

Line 10188: l_validation_tab := WSH_ACTIONS_LEVELS.G_VALIDATION_LEVEL_TAB;

10184: x_num_errors => l_number_of_errors,
10185: p_msg_data => l_msg_data
10186: );
10187: --
10188: l_validation_tab := WSH_ACTIONS_LEVELS.G_VALIDATION_LEVEL_TAB;
10189:
10190: -- Get Disabled List
10191: --
10192: IF(l_validation_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1) THEN

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

10188: l_validation_tab := WSH_ACTIONS_LEVELS.G_VALIDATION_LEVEL_TAB;
10189:
10190: -- Get Disabled List
10191: --
10192: IF(l_validation_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1) THEN
10193: l_index := p_detail_info_tab.FIRST;
10194: WHILE l_index IS NOT NULL
10195: LOOP
10196: --

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

10390: RAISE FND_API.G_EXC_ERROR;
10391: END IF;
10392:
10393: -- anxsharm for Load Tender
10394: IF(l_validation_tab(WSH_ACTIONS_LEVELS.C_WMS_CONTAINERS_LVL) = 1) THEN--{ lpn conv
10395: Validate_Delivery_Detail(
10396: x_detail_info_tab => l_detail_info_tab,
10397: p_in_detail_tab => p_detail_info_tab,
10398: p_action => p_In_rec.action_code,