DBA Data[Home] [Help]

APPS.WSH_DELIVERIES_GRP dependencies on WSH_DELIVERY_VALIDATIONS

Line 186: l_delivery_rec_tab wsh_delivery_validations.dlvy_rec_tab_type;

182: l_error_ids wsh_util_core.id_tab_type;
183: l_org_id_tab wsh_util_core.id_tab_type;
184: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
185: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.ship_method_type;
186: l_delivery_rec_tab wsh_delivery_validations.dlvy_rec_tab_type;
187: l_dummy_id_tab wsh_util_core.id_tab_type;
188: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;
189: l_param_name VARCHAR2(100);
190: l_isWshLocation BOOLEAN DEFAULT FALSE;

Line 496: WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled(

492: IF l_debug_on THEN
493: wsh_debug_sv.logmsg(l_module_name,'Calling IS_Action_Enabled');
494: END IF;
495:
496: WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled(
497: p_dlvy_rec_tab => l_delivery_rec_tab,
498: p_action => l_action_code,
499: p_caller => p_action_prms.caller,
500: p_tripid => p_action_prms.trip_id,--J TP Release

Line 3713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL',WSH_DEBUG_SV.C_PROC_LEVEL);

3709: -- Check if delivery's transportation is arranged by supplier
3710: -- or if routing request was not received for all delivery lines
3711: --
3712: IF l_debug_on THEN
3713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL',WSH_DEBUG_SV.C_PROC_LEVEL);
3714: END IF;
3715: --
3716: WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL
3717: (

Line 3716: WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL

3712: IF l_debug_on THEN
3713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL',WSH_DEBUG_SV.C_PROC_LEVEL);
3714: END IF;
3715: --
3716: WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL
3717: (
3718: p_delivery_id => x_rec_attr_tab(l_index).delivery_id,
3719: x_shipping_control => l_shipping_control,
3720: x_routing_response_id => l_routing_response_id,

Line 4149: WSH_DELIVERY_VALIDATIONS.derive_number_of_lpn(

4145: --bug 4587399 commented out the code below
4146: /**************************************************************************************
4147: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_NUMBER_OF_LPN_LVL) = 1 THEN
4148: --
4149: WSH_DELIVERY_VALIDATIONS.derive_number_of_lpn(
4150: p_delivery_id => x_rec_attr_tab(l_index).delivery_id,
4151: x_number_of_lpn => x_rec_attr_tab(l_index).number_of_lpn,
4152: x_return_status => l_return_status);
4153: --

Line 4173: WSH_DELIVERY_VALIDATIONS.Validate_Routed_Export_Txn(

4169: (p_action_code = 'UPDATE' AND
4170: ((p_in_rec_attr_tab(l_index).ROUTED_EXPORT_TXN IS NULL ) OR (p_in_rec_attr_tab(l_index).ROUTED_EXPORT_TXN <> fnd_api.g_miss_char)
4171: ))) THEN
4172: --
4173: WSH_DELIVERY_VALIDATIONS.Validate_Routed_Export_Txn(
4174: x_rtd_expt_txn_code => x_rec_attr_tab(l_index).ROUTED_EXPORT_TXN,
4175: p_rtd_expt_txn_meaning => l_dummy_meaning,
4176: x_return_status => l_return_status);
4177: --

Line 4245: wsh_delivery_validations.derive_delivery_uom(

4241: ( (p_in_rec_attr_tab(l_index).volume_uom_code IS NULL ) OR (p_in_rec_attr_tab(l_index).volume_uom_code <> fnd_api.g_miss_char)
4242: OR (p_in_rec_attr_tab(l_index).weight_uom_code IS NULL ) OR (p_in_rec_attr_tab(l_index).weight_uom_code <> fnd_api.g_miss_char)
4243: ))) THEN
4244: --
4245: wsh_delivery_validations.derive_delivery_uom(
4246: p_delivery_id => x_rec_attr_tab(l_index).delivery_id,
4247: p_organization_id => x_rec_attr_tab(l_index).organization_id,
4248: x_volume_uom_code => x_rec_attr_tab(l_index).volume_uom_code,
4249: x_weight_uom_code => x_rec_attr_tab(l_index).weight_uom_code,

Line 4323: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip

4319: x_return_status := wsh_util_core.g_ret_sts_success;
4320: END IF;
4321:
4322: /* Assumption is this should be taken care of by get_disabled list.
4323: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip
4324: (p_delivery_id => x_rec_attr_tab(l_index).delivery_id,
4325: x_return_status => x_return_status);
4326: */
4327: IF l_debug_on THEN

Line 4587: WSH_DELIVERY_VALIDATIONS.get_disabled_list(

4583: WHILE l_index is not null LOOP
4584: BEGIN
4585: SAVEPOINT DLVY_GRP_GET_DISAB_LIST_LOOP;
4586:
4587: WSH_DELIVERY_VALIDATIONS.get_disabled_list(
4588: p_delivery_rec => p_rec_attr_tab(l_index),
4589: p_in_rec => p_in_rec,
4590: x_return_status => l_return_status,
4591: x_msg_count => l_msg_count,

Line 4890: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',WSH_DEBUG_SV.C_PROC_LEVEL);

4886:
4887: -- ITM Check applicable only for outbound (O/IO) delivery.
4888: --
4889: IF l_debug_on THEN
4890: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',WSH_DEBUG_SV.C_PROC_LEVEL);
4891: END IF;
4892:
4893: l_log_itm_exc := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
4894: (p_delivery_id => x_del_out_rec_tab(l_index).delivery_id,

Line 4893: l_log_itm_exc := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required

4889: IF l_debug_on THEN
4890: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',WSH_DEBUG_SV.C_PROC_LEVEL);
4891: END IF;
4892:
4893: l_log_itm_exc := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
4894: (p_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
4895: x_return_status => l_return_status);
4896: IF l_debug_on THEN
4897: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);

Line 4897: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);

4893: l_log_itm_exc := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
4894: (p_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
4895: x_return_status => l_return_status);
4896: IF l_debug_on THEN
4897: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);
4898: END IF;
4899:
4900: WSH_UTIL_CORE.api_post_call(
4901: p_return_status => l_return_status,

Line 4907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);

4903: x_num_errors => l_num_errors);
4904:
4905: IF l_log_itm_exc = 'Y' THEN
4906: IF l_debug_on THEN
4907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
4908: END IF;
4909: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception (
4910: p_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
4911: p_action_type => 'CREATE_DELIVERY',

Line 4909: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception (

4905: IF l_log_itm_exc = 'Y' THEN
4906: IF l_debug_on THEN
4907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
4908: END IF;
4909: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception (
4910: p_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
4911: p_action_type => 'CREATE_DELIVERY',
4912: p_ship_from_location_id => l_rec_attr_tab(l_index).initial_pickup_location_id,
4913: x_return_status => l_return_status);

Line 4915: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',l_return_status);

4911: p_action_type => 'CREATE_DELIVERY',
4912: p_ship_from_location_id => l_rec_attr_tab(l_index).initial_pickup_location_id,
4913: x_return_status => l_return_status);
4914: IF l_debug_on THEN
4915: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',l_return_status);
4916: END IF;
4917:
4918: WSH_UTIL_CORE.api_post_call(
4919: p_return_status => l_return_status,

Line 5844: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip

5840: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR
5841: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR
5842: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN
5843:
5844: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip
5845: (p_delivery_id => p_delivery_info.delivery_id,
5846: x_return_status => x_return_status);
5847:
5848: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 6923: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Get_Delivery_Status');

6919: END IF;
6920: --
6921: WHEN OTHERS THEN
6922: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
6923: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Get_Delivery_Status');
6924: --
6925: IF l_debug_on THEN
6926: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6927: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');