DBA Data[Home] [Help]

APPS.WSH_TMS_RELEASE dependencies on WSH_SHIPPING_PARAMS_PVT

Line 2603: l_shipping_parameters WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;

2599: l_start_time DATE;
2600: x_start_time DATE := NULL;
2601: l_end_time DATE;
2602: x_end_time DATE := NULL;
2603: l_shipping_parameters WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
2604:
2605: BEGIN
2606: -- Fetching Dock Door Appt Scheduling info for the pick_up_stop
2607: --Bug7717569 replaced p_group_id with l_trip_info_tab(i).group_id

Line 2615: WSH_DEBUG_SV.log(l_module_name,'Calling WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);

2611: CLOSE c_dock_appt_rec;
2612: IF (l_organization_id IS NOT NULL) THEN --{
2613: IF (wsh_util_validate.check_wms_org(l_organization_id) = 'Y') THEN --{
2614: IF l_debug_on THEN
2615: WSH_DEBUG_SV.log(l_module_name,'Calling WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
2616: END IF;
2617: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_organization_id,
2618: x_param_info => l_shipping_parameters,
2619: x_return_status => l_rs);

Line 2617: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_organization_id,

2613: IF (wsh_util_validate.check_wms_org(l_organization_id) = 'Y') THEN --{
2614: IF l_debug_on THEN
2615: WSH_DEBUG_SV.log(l_module_name,'Calling WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
2616: END IF;
2617: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_organization_id,
2618: x_param_info => l_shipping_parameters,
2619: x_return_status => l_rs);
2620:
2621: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 2624: WSH_DEBUG_SV.log(l_module_name, 'WSH_SHIPPING_PARAMS_PVT.GET Failed: l_return_status', l_return_status);

2620:
2621: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2622: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2623: IF l_debug_on THEN
2624: WSH_DEBUG_SV.log(l_module_name, 'WSH_SHIPPING_PARAMS_PVT.GET Failed: l_return_status', l_return_status);
2625: END IF;
2626: GOTO trip_error;
2627: END IF;
2628: