APPS.WSH_DELIVERY_DETAILS_SPLITTER dependencies on WSH_SHIPPING_PARAMS_PVT

Line 31: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;

27: (p_detail_tab IN WSH_ENTITY_INFO_TAB,
28: p_item_quantity_uom_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
29: x_return_status OUT NOCOPY VARCHAR2) IS
30:
31: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
32: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;
33: l_max_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
34: l_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
35: l_new_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;

Line 32: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;

28: p_item_quantity_uom_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
29: x_return_status OUT NOCOPY VARCHAR2) IS
30:
31: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
32: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;
33: l_max_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
34: l_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
35: l_new_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;
36: l_num_split NUMBER;

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

97:
98: --get weight UOM from global parameters
99:
100: IF l_debug_on THEN
101: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
102: END IF;
103:
104: WSH_SHIPPING_PARAMS_PVT.get_global_parameters(
105: x_param_info => l_global_param_info,

Line 104: WSH_SHIPPING_PARAMS_PVT.get_global_parameters(

100: IF l_debug_on THEN
101: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
102: END IF;
103:
104: WSH_SHIPPING_PARAMS_PVT.get_global_parameters(
105: x_param_info => l_global_param_info,
106: x_return_status => l_return_status);
107:
108: IF l_debug_on THEN

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

105: x_param_info => l_global_param_info,
106: x_return_status => l_return_status);
107:
108: IF l_debug_on THEN
109: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters: ' || l_return_status);
110: END IF;
111:
112: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
113: l_number_of_warnings := l_number_of_warnings + 1;

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

132:
133: BEGIN
134: --get net weight limit
135: IF l_debug_on THEN
136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
137: END IF;
138:
139: WSH_SHIPPING_PARAMS_PVT.get(
140: p_organization_id => p_detail_tab(i).organization_id,

Line 139: WSH_SHIPPING_PARAMS_PVT.get(

135: IF l_debug_on THEN
136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
137: END IF;
138:
139: WSH_SHIPPING_PARAMS_PVT.get(
140: p_organization_id => p_detail_tab(i).organization_id,
141: x_param_info => l_parameter_info,
142: x_return_status => l_return_status);
143:

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

141: x_param_info => l_parameter_info,
142: x_return_status => l_return_status);
143:
144: IF l_debug_on THEN
145: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get: ' || l_return_status);
146: END IF;
147:
148: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
149: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN