[Home] [Help]
3210: l_req NUMBER;
3211: l_req2 NUMBER;
3212: l_line_id NUMBER;
3213: l_del_id NUMBER;
3214: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3215: -- 6749200 (replenishment project) : end
3216:
3217: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
3218: l_requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
3245: l_item_id NUMBER;
3246: l_locator_id NUMBER;
3247: l_subinventory VARCHAR2(20);
3248: l_container_name VARCHAR2(50);
3249: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
3250: e_wt_vol_fail EXCEPTION;
3251:
3252: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI changes
3253: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
4146:
4147: -- Debug Statements
4148: --
4149: IF l_debug_on THEN
4150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
4151: END IF;
4152: --
4153: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_status);
4154: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4149: IF l_debug_on THEN
4150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
4151: END IF;
4152: --
4153: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_status);
4154: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4155: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');
4156: x_return_status := l_return_status;
4157: END IF;