DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_DETAILS_VALIDATIONS

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

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

Line 394: wsh_details_validations.check_unassign_from_delivery(

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

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

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

Line 886: wsh_details_validations.check_decimal_quantity(

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

Line 2312: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;

2308: l_dlvy_status_code VARCHAR2(32767);
2309: l_dlvy_planned_flag VARCHAR2(32767);
2310: l_dlvy_shipment_direction VARCHAR2(30);
2311: --
2312: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;
2313: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
2314: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2316:

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

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;
2707: --
2708: WSH_DETAILS_VALIDATIONS.Is_Action_Enabled(
2709: p_del_detail_rec_tab => l_detail_rec_tab,

Line 2708: WSH_DETAILS_VALIDATIONS.Is_Action_Enabled(

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;
2707: --
2708: WSH_DETAILS_VALIDATIONS.Is_Action_Enabled(
2709: p_del_detail_rec_tab => l_detail_rec_tab,
2710: p_action => l_action_code,
2711: p_caller => p_action_prms.caller,
2712: p_deliveryid => p_action_prms.delivery_id,

Line 3035: IF (NOT WSH_DETAILS_VALIDATIONS.is_split_allowed

3031: -- Check if split is allowed
3032: -- HW OPMCONV - New WSH API to check if split is allowed
3033: l_delivery_detail_id := l_id_tab(l_id_tab.first);
3034:
3035: IF (NOT WSH_DETAILS_VALIDATIONS.is_split_allowed
3036: ( p_delivery_detail_id => l_delivery_detail_id,
3037: p_organization_id => l_organization_id,
3038: p_inventory_item_id => l_inv_item_id,
3039: p_released_status => l_released_status)

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

3084: IF(p_action_prms.action_code = 'ASSIGN' AND nvl(p_action_prms.phase,1) = 1) THEN
3085: IF l_debug_on THEN
3086: WSH_DEBUG_SV.log(l_module_name, 'Delivery Id', p_action_prms.delivery_id);
3087: WSH_DEBUG_SV.log(l_module_name, 'Delivery Name', p_action_prms.delivery_name);
3088: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_ASSIGN_DEL_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
3089: END IF;
3090:
3091: wsh_details_validations.check_assign_del_multi(
3092: p_detail_rows => l_id_tab,

Line 3091: wsh_details_validations.check_assign_del_multi(

3087: WSH_DEBUG_SV.log(l_module_name, 'Delivery Name', p_action_prms.delivery_name);
3088: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_ASSIGN_DEL_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
3089: END IF;
3090:
3091: wsh_details_validations.check_assign_del_multi(
3092: p_detail_rows => l_id_tab,
3093: x_del_params => l_detail_group_params,
3094: x_return_status => l_return_status);
3095:

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

3231: AND l_requested_quantity_uom2 <> FND_API.G_MISS_CHAR) THEN
3232:
3233: --{
3234: IF l_debug_on THEN
3235: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.validate_secondary_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);
3236: END IF;
3237: --
3238: -- J-IB-NPARIKH-{
3239: --

Line 3247: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity

3243: IF l_inventory_item_id is not null
3244: AND ( p_action_prms.caller like 'FTE%' or l_line_direction not in ('IO','O') )
3245: THEN
3246: --{
3247: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity
3248: (
3249: p_delivery_detail_id => l_id_tab(l_id_tab.first),
3250: x_quantity => l_split_quantity,
3251: x_quantity2 => l_split_quantity2,

Line 3935: IF (NOT WSH_DETAILS_VALIDATIONS.is_cycle_count_allowed

3931: -- HW OPMCONV - New WSH API to check if split is allowed
3932:
3933: l_delivery_detail_id := l_id_tab(l_id_tab.first);
3934:
3935: IF (NOT WSH_DETAILS_VALIDATIONS.is_cycle_count_allowed
3936: ( p_delivery_detail_id => l_delivery_detail_id,
3937: p_organization_id => l_organization_id,
3938: p_inventory_item_id => l_inv_item_id,
3939: p_released_status => l_released_status,

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

4017:
4018: -- this needs to be called only for Discrete Org
4019: --
4020: IF l_debug_on THEN
4021: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
4022: END IF;
4023: --
4024: WSH_DETAILS_VALIDATIONS.check_decimal_quantity(
4025: p_item_id => l_inv_item_id,

Line 4024: WSH_DETAILS_VALIDATIONS.check_decimal_quantity(

4020: IF l_debug_on THEN
4021: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
4022: END IF;
4023: --
4024: WSH_DETAILS_VALIDATIONS.check_decimal_quantity(
4025: p_item_id => l_inv_item_id,
4026: p_organization_id => l_organization_id,
4027: p_input_quantity => p_action_prms.quantity_to_split,
4028: p_uom_code => l_requested_quantity_uom,

Line 6627: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity

6623: nvl(x_detail_info_tab(l_index).shipped_quantity2,fnd_api.g_miss_num) <> fnd_api.g_miss_num) THEN
6624:
6625: -- HW OPMCONV - Use this API instead of GMI_RESERVATION_UTIL.validate_opm_quantities
6626:
6627: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity
6628: (
6629: p_delivery_detail_id => x_detail_info_tab(l_index).delivery_detail_id,
6630: x_quantity => x_detail_info_tab(l_index).shipped_quantity,
6631: x_quantity2 => x_detail_info_tab(l_index).shipped_quantity2,

Line 6663: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity

6659: 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);
6660:
6661: END IF;
6662:
6663: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity
6664: (
6665: p_delivery_detail_id => x_detail_info_tab(l_index).delivery_detail_id,
6666: x_quantity => x_detail_info_tab(l_index).cycle_count_quantity,
6667: x_quantity2 => x_detail_info_tab(l_index).cycle_count_quantity2,

Line 6751: WSH_DETAILS_VALIDATIONS.compare_detail_attributes

6747: -- new API added for comparison of attributes
6748: -- but has different record structure.
6749: -- Use Compare_detail_attributes API
6750: IF l_fte_installed = 'Y' THEN
6751: WSH_DETAILS_VALIDATIONS.compare_detail_attributes
6752: (p_old_table => l_old_table,
6753: p_new_table => l_new_table,
6754: p_action_code => p_action,
6755: p_phase => 1,

Line 7456: l_det_qty_rec wsh_details_validations.validatequantityattrrectype;

7452: l_ship_method_name VARCHAR2(32767);
7453: -- HW Harmonization project for OPM. Added l_process flag variable
7454: -- HW OPMCONV - Removed OPM variables
7455:
7456: l_det_qty_rec wsh_details_validations.validatequantityattrrectype;
7457: -- Bug fix 1578114
7458: l_transaction_id NUMBER;
7459: l_prefix VARCHAR2(240);
7460: v1 NUMBER;

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

7749: WSH_DEBUG_SV.log(l_module_name, 'get serial qty status', l_return_status);
7750: WSH_DEBUG_SV.log(l_module_name, 'Serial qty', l_det_qty_rec.serial_quantity);
7751: WSH_DEBUG_SV.log(l_module_name, 'Serial Number', l_det_qty_rec.serial_number);
7752: WSH_DEBUG_SV.log(l_module_name, 'Trans temp id', l_det_qty_rec.transaction_temp_id);
7753: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY', WSH_DEBUG_SV.c_proc_level);
7754: END IF;
7755:
7756: --
7757: wsh_details_validations.validate_shipped_cc_quantity(

Line 7757: wsh_details_validations.validate_shipped_cc_quantity(

7753: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY', WSH_DEBUG_SV.c_proc_level);
7754: END IF;
7755:
7756: --
7757: wsh_details_validations.validate_shipped_cc_quantity(
7758: p_flag => 'SQ',
7759: x_det_rec => l_det_qty_rec,
7760: x_return_status => l_return_status,
7761: x_msg_count => l_msg_count,

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

7818: -- HW use l_process_flag
7819: -- HW OPMCONV - Removed population of process_flag
7820:
7821: IF l_debug_on THEN
7822: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2', WSH_DEBUG_SV.c_proc_level);
7823: END IF;
7824:
7825: --
7826:

Line 7827: wsh_details_validations.validate_shipped_cc_quantity2(

7823: END IF;
7824:
7825: --
7826:
7827: wsh_details_validations.validate_shipped_cc_quantity2(
7828: p_flag => 'SQ',
7829: x_det_rec => l_det_qty_rec,
7830: x_return_status => l_return_status,
7831: x_msg_count => l_msg_count,

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

7879: -- HW OPMCONV - Removed populatation of process_flag
7880:
7881: --
7882: IF l_debug_on THEN
7883: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY', WSH_DEBUG_SV.c_proc_level);
7884: END IF;
7885:
7886: --
7887: wsh_details_validations.validate_shipped_cc_quantity(

Line 7887: wsh_details_validations.validate_shipped_cc_quantity(

7883: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY', WSH_DEBUG_SV.c_proc_level);
7884: END IF;
7885:
7886: --
7887: wsh_details_validations.validate_shipped_cc_quantity(
7888: p_flag => 'CCQ',
7889: x_det_rec => l_det_qty_rec,
7890: x_return_status => l_return_status,
7891: x_msg_count => l_msg_count,

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

7937: -- HW Harmonization project for OPM. Use l_process_flag
7938: -- HW OPMCONV - Removed population of process_flag
7939:
7940: IF l_debug_on THEN
7941: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2', WSH_DEBUG_SV.c_proc_level);
7942: END IF;
7943:
7944: --
7945: wsh_details_validations.validate_shipped_cc_quantity2(

Line 7945: wsh_details_validations.validate_shipped_cc_quantity2(

7941: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2', WSH_DEBUG_SV.c_proc_level);
7942: END IF;
7943:
7944: --
7945: wsh_details_validations.validate_shipped_cc_quantity2(
7946: p_flag => 'CCQ',
7947: x_det_rec => l_det_qty_rec,
7948: x_return_status => l_return_status,
7949: x_msg_count => l_msg_count,

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

8691: END IF;
8692:
8693: /* Bug fix: 2652300. Removed the code to call unmark serial numbers.
8694: Unmarking of serial numbers is now done in the api
8695: wsh_details_validations.validate_shipped_cc_qty , based on the shipped quantity and the serial quantity.
8696: It is no longer done here in the group API.*/
8697:
8698: -- Bug 3628620
8699: -- Handle Unmark Serial Number for Public API

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

10081: FETCH det_to_del_Cur INTO l_delivery_id;
10082: CLOSE det_to_del_Cur;
10083:
10084: IF l_debug_on THEN
10085: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.GET_DISABLED_LIST',WSH_DEBUG_SV.C_PROC_LEVEL);
10086: END IF;
10087: --
10088:
10089: IF p_In_rec.caller LIKE 'WMS%' AND p_in_rec.action_code ='UPDATE'

Line 10102: wsh_details_validations.get_disabled_list(

10098: END IF;
10099:
10100: END IF;
10101:
10102: wsh_details_validations.get_disabled_list(
10103: --
10104: p_delivery_detail_rec => p_detail_info_tab(l_index),
10105: p_delivery_id => l_delivery_id,
10106: p_in_rec => p_In_rec,