[Home] [Help]
3345: l_req NUMBER;
3346: l_req2 NUMBER;
3347: l_line_id NUMBER;
3348: l_del_id NUMBER;
3349: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3350: -- 6749200 (replenishment project) : end
3351:
3352: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
3353: l_requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
3380: l_item_id NUMBER;
3381: l_locator_id NUMBER;
3382: l_subinventory VARCHAR2(20);
3383: l_container_name VARCHAR2(50);
3384: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
3385: e_wt_vol_fail EXCEPTION;
3386:
3387: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI changes
3388: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
4281:
4282: -- Debug Statements
4283: --
4284: IF l_debug_on THEN
4285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
4286: END IF;
4287: --
4288: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_status);
4289: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4284: IF l_debug_on THEN
4285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
4286: END IF;
4287: --
4288: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_status);
4289: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4290: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');
4291: x_return_status := l_return_status;
4292: END IF;