APPS.WSH_DELIVERY_DETAILS_SPLITTER dependencies on WSH_SHIPPING_PARAMS_PVT

Line 40: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;

36: --
37: l_client_id NUMBER;
38: l_standalone_mode VARCHAR2(1);
39: -- LSP PROJECT : end
40: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
41: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;
42: l_max_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
43: l_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
44: l_new_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;

Line 41: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;

37: l_client_id NUMBER;
38: l_standalone_mode VARCHAR2(1);
39: -- LSP PROJECT : end
40: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
41: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;
42: l_max_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
43: l_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
44: l_new_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;
45: l_num_split NUMBER;

Line 114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);

110:
111: --get weight UOM from global parameters
112:
113: IF l_debug_on THEN
114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
115: END IF;
116:
117: WSH_SHIPPING_PARAMS_PVT.get_global_parameters(
118: x_param_info => l_global_param_info,

Line 117: WSH_SHIPPING_PARAMS_PVT.get_global_parameters(

113: IF l_debug_on THEN
114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
115: END IF;
116:
117: WSH_SHIPPING_PARAMS_PVT.get_global_parameters(
118: x_param_info => l_global_param_info,
119: x_return_status => l_return_status);
120:
121: IF l_debug_on THEN

Line 122: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters: ' || l_return_status);

118: x_param_info => l_global_param_info,
119: x_return_status => l_return_status);
120:
121: IF l_debug_on THEN
122: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters: ' || l_return_status);
123: END IF;
124:
125: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
126: l_number_of_warnings := l_number_of_warnings + 1;

Line 160: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);

156: -- LSP PROJECT : end
157: --
158: --get net weight limit
159: IF l_debug_on THEN
160: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
161: END IF;
162:
163: WSH_SHIPPING_PARAMS_PVT.get(
164: p_organization_id => p_detail_tab(i).organization_id,

Line 163: WSH_SHIPPING_PARAMS_PVT.get(

159: IF l_debug_on THEN
160: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
161: END IF;
162:
163: WSH_SHIPPING_PARAMS_PVT.get(
164: p_organization_id => p_detail_tab(i).organization_id,
165: p_client_id => l_client_id, -- LSP PROJECT
166: x_param_info => l_parameter_info,
167: x_return_status => l_return_status);

Line 170: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get: ' || l_return_status);

166: x_param_info => l_parameter_info,
167: x_return_status => l_return_status);
168:
169: IF l_debug_on THEN
170: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get: ' || l_return_status);
171: END IF;
172:
173: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
174: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN