DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_DETAILS_VALIDATIONS

Line 395: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_UNASSIGN_FROM_DELIVERY', wsh_debug_sv.c_proc_level);

391: END IF;
392: ELSE
393: /* unassign */
394: IF l_debug_on THEN
395: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_UNASSIGN_FROM_DELIVERY', wsh_debug_sv.c_proc_level);
396: END IF;
397:
398: wsh_details_validations.check_unassign_from_delivery(
399: p_detail_rows => l_tabofdeldets,

Line 398: wsh_details_validations.check_unassign_from_delivery(

394: IF l_debug_on THEN
395: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_UNASSIGN_FROM_DELIVERY', wsh_debug_sv.c_proc_level);
396: END IF;
397:
398: wsh_details_validations.check_unassign_from_delivery(
399: p_detail_rows => l_tabofdeldets,
400: x_return_status => l_return_status);
401:
402: wsh_util_core.api_post_call(

Line 887: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY', wsh_debug_sv.c_proc_level);

883: IF l_debug_on THEN
884: wsh_debug_sv.LOG(l_module_name, 'Inv item id', l_inv_item_id);
885: wsh_debug_sv.LOG(l_module_name, 'Org id', l_organization_id);
886: wsh_debug_sv.LOG(l_module_name, 'Req qty uom', l_requested_quantity_uom);
887: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY', wsh_debug_sv.c_proc_level);
888: END IF;
889:
890: wsh_details_validations.check_decimal_quantity(
891: p_item_id => l_inv_item_id,

Line 890: wsh_details_validations.check_decimal_quantity(

886: wsh_debug_sv.LOG(l_module_name, 'Req qty uom', l_requested_quantity_uom);
887: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY', wsh_debug_sv.c_proc_level);
888: END IF;
889:
890: wsh_details_validations.check_decimal_quantity(
891: p_item_id => l_inv_item_id,
892: p_organization_id => l_organization_id,
893: p_input_quantity => x_split_quantity,
894: p_uom_code => l_requested_quantity_uom, -- :split_line.quantity_UOM,

Line 2318: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;

2314: l_dlvy_status_code VARCHAR2(32767);
2315: l_dlvy_planned_flag VARCHAR2(32767);
2316: l_dlvy_shipment_direction VARCHAR2(30);
2317: --
2318: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;
2319: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
2320: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2321: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2322:

Line 2711: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.IS_ACTION_ENABLED',WSH_DEBUG_SV.C_PROC_LEVEL);

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;
2713: --
2714: WSH_DETAILS_VALIDATIONS.Is_Action_Enabled(
2715: p_del_detail_rec_tab => l_detail_rec_tab,

Line 2714: WSH_DETAILS_VALIDATIONS.Is_Action_Enabled(

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;
2713: --
2714: WSH_DETAILS_VALIDATIONS.Is_Action_Enabled(
2715: p_del_detail_rec_tab => l_detail_rec_tab,
2716: p_action => l_action_code,
2717: p_caller => p_action_prms.caller,
2718: p_deliveryid => p_action_prms.delivery_id,

Line 3041: IF (NOT WSH_DETAILS_VALIDATIONS.is_split_allowed

3037: -- Check if split is allowed
3038: -- HW OPMCONV - New WSH API to check if split is allowed
3039: l_delivery_detail_id := l_id_tab(l_id_tab.first);
3040: IF l_inv_item_id IS NOT NULL THEN -- Added for bug 15885718
3041: IF (NOT WSH_DETAILS_VALIDATIONS.is_split_allowed
3042: ( p_delivery_detail_id => l_delivery_detail_id,
3043: p_organization_id => l_organization_id,
3044: p_inventory_item_id => l_inv_item_id,
3045: p_released_status => l_released_status)

Line 3095: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_ASSIGN_DEL_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);

3091: IF(p_action_prms.action_code = 'ASSIGN' AND nvl(p_action_prms.phase,1) = 1) THEN
3092: IF l_debug_on THEN
3093: WSH_DEBUG_SV.log(l_module_name, 'Delivery Id', p_action_prms.delivery_id);
3094: WSH_DEBUG_SV.log(l_module_name, 'Delivery Name', p_action_prms.delivery_name);
3095: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_ASSIGN_DEL_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
3096: END IF;
3097:
3098: wsh_details_validations.check_assign_del_multi(
3099: p_detail_rows => l_id_tab,

Line 3098: wsh_details_validations.check_assign_del_multi(

3094: WSH_DEBUG_SV.log(l_module_name, 'Delivery Name', p_action_prms.delivery_name);
3095: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_ASSIGN_DEL_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
3096: END IF;
3097:
3098: wsh_details_validations.check_assign_del_multi(
3099: p_detail_rows => l_id_tab,
3100: x_del_params => l_detail_group_params,
3101: x_return_status => l_return_status);
3102:

Line 3242: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.validate_secondary_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);

3238: AND l_requested_quantity_uom2 <> FND_API.G_MISS_CHAR) THEN
3239:
3240: --{
3241: IF l_debug_on THEN
3242: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.validate_secondary_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);
3243: END IF;
3244: --
3245: -- J-IB-NPARIKH-{
3246: --

Line 3254: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity

3250: IF l_inventory_item_id is not null
3251: AND ( p_action_prms.caller like 'FTE%' or l_line_direction not in ('IO','O') )
3252: THEN
3253: --{
3254: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity
3255: (
3256: p_delivery_detail_id => l_id_tab(l_id_tab.first),
3257: x_quantity => l_split_quantity,
3258: x_quantity2 => l_split_quantity2,

Line 3943: IF (NOT WSH_DETAILS_VALIDATIONS.is_cycle_count_allowed

3939: -- HW OPMCONV - New WSH API to check if split is allowed
3940:
3941: l_delivery_detail_id := l_id_tab(l_id_tab.first);
3942:
3943: IF (NOT WSH_DETAILS_VALIDATIONS.is_cycle_count_allowed
3944: ( p_delivery_detail_id => l_delivery_detail_id,
3945: p_organization_id => l_organization_id,
3946: p_inventory_item_id => l_inv_item_id,
3947: p_released_status => l_released_status,

Line 4030: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

4026:
4027: -- this needs to be called only for Discrete Org
4028: --
4029: IF l_debug_on THEN
4030: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
4031: END IF;
4032: --
4033: WSH_DETAILS_VALIDATIONS.check_decimal_quantity(
4034: p_item_id => l_inv_item_id,

Line 4033: WSH_DETAILS_VALIDATIONS.check_decimal_quantity(

4029: IF l_debug_on THEN
4030: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
4031: END IF;
4032: --
4033: WSH_DETAILS_VALIDATIONS.check_decimal_quantity(
4034: p_item_id => l_inv_item_id,
4035: p_organization_id => l_organization_id,
4036: p_input_quantity => p_action_prms.quantity_to_split,
4037: p_uom_code => l_requested_quantity_uom,

Line 6710: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity

6706: nvl(x_detail_info_tab(l_index).shipped_quantity2,fnd_api.g_miss_num) <> fnd_api.g_miss_num) THEN
6707:
6708: -- HW OPMCONV - Use this API instead of GMI_RESERVATION_UTIL.validate_opm_quantities
6709:
6710: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity
6711: (
6712: p_delivery_detail_id => x_detail_info_tab(l_index).delivery_detail_id,
6713: x_quantity => x_detail_info_tab(l_index).shipped_quantity,
6714: x_quantity2 => x_detail_info_tab(l_index).shipped_quantity2,

Line 6746: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity

6742: wsh_debug_sv.LOG(l_module_name, 'x_detail_info_tab(l_index).cycle_count_quantity2', x_detail_info_tab(l_index).cycle_count_quantity2);
6743:
6744: END IF;
6745:
6746: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity
6747: (
6748: p_delivery_detail_id => x_detail_info_tab(l_index).delivery_detail_id,
6749: x_quantity => x_detail_info_tab(l_index).cycle_count_quantity,
6750: x_quantity2 => x_detail_info_tab(l_index).cycle_count_quantity2,

Line 6838: WSH_DETAILS_VALIDATIONS.compare_detail_attributes

6834: -- new API added for comparison of attributes
6835: -- but has different record structure.
6836: -- Use Compare_detail_attributes API
6837: IF l_fte_installed = 'Y' THEN
6838: WSH_DETAILS_VALIDATIONS.compare_detail_attributes
6839: (p_old_table => l_old_table,
6840: p_new_table => l_new_table,
6841: p_action_code => p_action,
6842: p_phase => 1,

Line 7548: l_det_qty_rec wsh_details_validations.validatequantityattrrectype;

7544: l_lpn_id NUMBER;
7545: l_wms_installed VARCHAR2(10);
7546:
7547:
7548: l_det_qty_rec wsh_details_validations.validatequantityattrrectype;
7549: -- Bug fix 1578114
7550: l_transaction_id NUMBER;
7551: l_prefix VARCHAR2(240);
7552: v1 NUMBER;

Line 7870: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY', WSH_DEBUG_SV.c_proc_level);

7866: WSH_DEBUG_SV.log(l_module_name, 'get serial qty status', l_return_status);
7867: WSH_DEBUG_SV.log(l_module_name, 'Serial qty', l_det_qty_rec.serial_quantity);
7868: WSH_DEBUG_SV.log(l_module_name, 'Serial Number', l_det_qty_rec.serial_number);
7869: WSH_DEBUG_SV.log(l_module_name, 'Trans temp id', l_det_qty_rec.transaction_temp_id);
7870: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY', WSH_DEBUG_SV.c_proc_level);
7871: END IF;
7872:
7873: --
7874: wsh_details_validations.validate_shipped_cc_quantity(

Line 7874: wsh_details_validations.validate_shipped_cc_quantity(

7870: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY', WSH_DEBUG_SV.c_proc_level);
7871: END IF;
7872:
7873: --
7874: wsh_details_validations.validate_shipped_cc_quantity(
7875: p_flag => 'SQ',
7876: x_det_rec => l_det_qty_rec,
7877: x_return_status => l_return_status,
7878: x_msg_count => l_msg_count,

Line 7939: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2', WSH_DEBUG_SV.c_proc_level);

7935: -- HW use l_process_flag
7936: -- HW OPMCONV - Removed population of process_flag
7937:
7938: IF l_debug_on THEN
7939: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2', WSH_DEBUG_SV.c_proc_level);
7940: END IF;
7941:
7942: --
7943:

Line 7944: wsh_details_validations.validate_shipped_cc_quantity2(

7940: END IF;
7941:
7942: --
7943:
7944: wsh_details_validations.validate_shipped_cc_quantity2(
7945: p_flag => 'SQ',
7946: x_det_rec => l_det_qty_rec,
7947: x_return_status => l_return_status,
7948: x_msg_count => l_msg_count,

Line 8000: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY', WSH_DEBUG_SV.c_proc_level);

7996: -- HW OPMCONV - Removed populatation of process_flag
7997:
7998: --
7999: IF l_debug_on THEN
8000: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY', WSH_DEBUG_SV.c_proc_level);
8001: END IF;
8002:
8003: --
8004: wsh_details_validations.validate_shipped_cc_quantity(

Line 8004: wsh_details_validations.validate_shipped_cc_quantity(

8000: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY', WSH_DEBUG_SV.c_proc_level);
8001: END IF;
8002:
8003: --
8004: wsh_details_validations.validate_shipped_cc_quantity(
8005: p_flag => 'CCQ',
8006: x_det_rec => l_det_qty_rec,
8007: x_return_status => l_return_status,
8008: x_msg_count => l_msg_count,

Line 8058: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2', WSH_DEBUG_SV.c_proc_level);

8054: -- HW Harmonization project for OPM. Use l_process_flag
8055: -- HW OPMCONV - Removed population of process_flag
8056:
8057: IF l_debug_on THEN
8058: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2', WSH_DEBUG_SV.c_proc_level);
8059: END IF;
8060:
8061: --
8062: wsh_details_validations.validate_shipped_cc_quantity2(

Line 8062: wsh_details_validations.validate_shipped_cc_quantity2(

8058: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2', WSH_DEBUG_SV.c_proc_level);
8059: END IF;
8060:
8061: --
8062: wsh_details_validations.validate_shipped_cc_quantity2(
8063: p_flag => 'CCQ',
8064: x_det_rec => l_det_qty_rec,
8065: x_return_status => l_return_status,
8066: x_msg_count => l_msg_count,

Line 8814: wsh_details_validations.validate_shipped_cc_qty , based on the shipped quantity and the serial quantity.

8810: END IF;
8811:
8812: /* Bug fix: 2652300. Removed the code to call unmark serial numbers.
8813: Unmarking of serial numbers is now done in the api
8814: wsh_details_validations.validate_shipped_cc_qty , based on the shipped quantity and the serial quantity.
8815: It is no longer done here in the group API.*/
8816:
8817: -- Bug 3628620
8818: -- Handle Unmark Serial Number for Public API

Line 10205: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.GET_DISABLED_LIST',WSH_DEBUG_SV.C_PROC_LEVEL);

10201: FETCH det_to_del_Cur INTO l_delivery_id;
10202: CLOSE det_to_del_Cur;
10203:
10204: IF l_debug_on THEN
10205: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.GET_DISABLED_LIST',WSH_DEBUG_SV.C_PROC_LEVEL);
10206: END IF;
10207: --
10208:
10209: IF p_In_rec.caller LIKE 'WMS%' AND p_in_rec.action_code ='UPDATE'

Line 10222: wsh_details_validations.get_disabled_list(

10218: END IF;
10219:
10220: END IF;
10221:
10222: wsh_details_validations.get_disabled_list(
10223: --
10224: p_delivery_detail_rec => p_detail_info_tab(l_index),
10225: p_delivery_id => l_delivery_id,
10226: p_in_rec => p_In_rec,