DBA Data[Home] [Help]

APPS.WSH_DELIVERIES_GRP dependencies on WSH_DELIVERY_VALIDATIONS

Line 216: l_delivery_rec_tab wsh_delivery_validations.dlvy_rec_tab_type;

212: l_org_id_tab wsh_util_core.id_tab_type;
213: l_Client_id_tab wsh_util_core.id_tab_type; -- Modified R12.1.1 LSP PROJECT
214: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
215: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.ship_method_type;
216: l_delivery_rec_tab wsh_delivery_validations.dlvy_rec_tab_type;
217: l_dummy_id_tab wsh_util_core.id_tab_type;
218: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;
219: l_param_name VARCHAR2(100);
220: l_isWshLocation BOOLEAN DEFAULT FALSE;

Line 532: WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled(

528: IF l_debug_on THEN
529: wsh_debug_sv.logmsg(l_module_name,'Calling IS_Action_Enabled');
530: END IF;
531:
532: WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled(
533: p_dlvy_rec_tab => l_delivery_rec_tab,
534: p_action => l_action_code,
535: p_caller => p_action_prms.caller,
536: p_tripid => p_action_prms.trip_id,--J TP Release

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

3805: -- Check if delivery's transportation is arranged by supplier
3806: -- or if routing request was not received for all delivery lines
3807: --
3808: IF l_debug_on THEN
3809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL',WSH_DEBUG_SV.C_PROC_LEVEL);
3810: END IF;
3811: --
3812: WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL
3813: (

Line 3812: WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL

3808: IF l_debug_on THEN
3809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL',WSH_DEBUG_SV.C_PROC_LEVEL);
3810: END IF;
3811: --
3812: WSH_DELIVERY_VALIDATIONS.GET_SHIPPING_CONTROL
3813: (
3814: p_delivery_id => x_rec_attr_tab(l_index).delivery_id,
3815: x_shipping_control => l_shipping_control,
3816: x_routing_response_id => l_routing_response_id,

Line 4302: WSH_DELIVERY_VALIDATIONS.derive_number_of_lpn(

4298: --bug 4587399 commented out the code below
4299: /**************************************************************************************
4300: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_NUMBER_OF_LPN_LVL) = 1 THEN
4301: --
4302: WSH_DELIVERY_VALIDATIONS.derive_number_of_lpn(
4303: p_delivery_id => x_rec_attr_tab(l_index).delivery_id,
4304: x_number_of_lpn => x_rec_attr_tab(l_index).number_of_lpn,
4305: x_return_status => l_return_status);
4306: --

Line 4326: WSH_DELIVERY_VALIDATIONS.Validate_Routed_Export_Txn(

4322: (p_action_code = 'UPDATE' AND
4323: ((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)
4324: ))) THEN
4325: --
4326: WSH_DELIVERY_VALIDATIONS.Validate_Routed_Export_Txn(
4327: x_rtd_expt_txn_code => x_rec_attr_tab(l_index).ROUTED_EXPORT_TXN,
4328: p_rtd_expt_txn_meaning => l_dummy_meaning,
4329: x_return_status => l_return_status);
4330: --

Line 4398: wsh_delivery_validations.derive_delivery_uom(

4394: ( (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)
4395: 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)
4396: ))) THEN
4397: --
4398: wsh_delivery_validations.derive_delivery_uom(
4399: p_delivery_id => x_rec_attr_tab(l_index).delivery_id,
4400: p_organization_id => x_rec_attr_tab(l_index).organization_id,
4401: x_volume_uom_code => x_rec_attr_tab(l_index).volume_uom_code,
4402: x_weight_uom_code => x_rec_attr_tab(l_index).weight_uom_code,

Line 4476: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip

4472: x_return_status := wsh_util_core.g_ret_sts_success;
4473: END IF;
4474:
4475: /* Assumption is this should be taken care of by get_disabled list.
4476: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip
4477: (p_delivery_id => x_rec_attr_tab(l_index).delivery_id,
4478: x_return_status => x_return_status);
4479: */
4480: IF l_debug_on THEN

Line 4760: WSH_DELIVERY_VALIDATIONS.get_disabled_list(

4756: WHILE l_index is not null LOOP
4757: BEGIN
4758: SAVEPOINT DLVY_GRP_GET_DISAB_LIST_LOOP;
4759:
4760: WSH_DELIVERY_VALIDATIONS.get_disabled_list(
4761: p_delivery_rec => p_rec_attr_tab(l_index),
4762: p_in_rec => p_in_rec,
4763: x_return_status => l_return_status,
4764: x_msg_count => l_msg_count,

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

5061:
5062: -- ITM Check applicable only for outbound (O/IO) delivery.
5063: --
5064: IF l_debug_on THEN
5065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',WSH_DEBUG_SV.C_PROC_LEVEL);
5066: END IF;
5067:
5068: l_log_itm_exc := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
5069: (p_delivery_id => x_del_out_rec_tab(l_index).delivery_id,

Line 5068: l_log_itm_exc := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required

5064: IF l_debug_on THEN
5065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',WSH_DEBUG_SV.C_PROC_LEVEL);
5066: END IF;
5067:
5068: l_log_itm_exc := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
5069: (p_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
5070: x_return_status => l_return_status);
5071: IF l_debug_on THEN
5072: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);

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

5068: l_log_itm_exc := WSH_DELIVERY_VALIDATIONS.Check_ITM_Required
5069: (p_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
5070: x_return_status => l_return_status);
5071: IF l_debug_on THEN
5072: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Check_ITM_Required',l_return_status);
5073: END IF;
5074:
5075: WSH_UTIL_CORE.api_post_call(
5076: p_return_status => l_return_status,

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

5078: x_num_errors => l_num_errors);
5079:
5080: IF l_log_itm_exc = 'Y' THEN
5081: IF l_debug_on THEN
5082: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
5083: END IF;
5084: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception (
5085: p_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
5086: p_action_type => 'CREATE_DELIVERY',

Line 5084: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception (

5080: IF l_log_itm_exc = 'Y' THEN
5081: IF l_debug_on THEN
5082: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',WSH_DEBUG_SV.C_PROC_LEVEL);
5083: END IF;
5084: WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception (
5085: p_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
5086: p_action_type => 'CREATE_DELIVERY',
5087: p_ship_from_location_id => l_rec_attr_tab(l_index).initial_pickup_location_id,
5088: x_return_status => l_return_status);

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

5086: p_action_type => 'CREATE_DELIVERY',
5087: p_ship_from_location_id => l_rec_attr_tab(l_index).initial_pickup_location_id,
5088: x_return_status => l_return_status);
5089: IF l_debug_on THEN
5090: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_VALIDATIONS.Log_ITM_Exception',l_return_status);
5091: END IF;
5092:
5093: WSH_UTIL_CORE.api_post_call(
5094: p_return_status => l_return_status,

Line 6024: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip

6020: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR
6021: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR
6022: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN
6023:
6024: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip
6025: (p_delivery_id => p_delivery_info.delivery_id,
6026: x_return_status => x_return_status);
6027:
6028: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

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

7099: END IF;
7100: --
7101: WHEN OTHERS THEN
7102: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
7103: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.Get_Delivery_Status');
7104: --
7105: IF l_debug_on THEN
7106: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7107: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:OTHERS');