DBA Data[Home] [Help]

APPS.WSH_WV_UTILS dependencies on WSH_SHIPPING_PARAMS_PVT

Line 3029: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

3025: l_err_container NUMBER;
3026: mark_reprice_error EXCEPTION;
3027: invalid_detail EXCEPTION;
3028:
3029: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
3030: l_num_warnings NUMBER := 0;
3031: l_unit_wt NUMBER;
3032: l_unit_vol NUMBER;
3033:

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

3107: END IF;
3108:
3109: -- Get the shipping parameters of container organization
3110: IF l_debug_on THEN
3111: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
3112: END IF;
3113:
3114: WSH_SHIPPING_PARAMS_PVT.Get(
3115: p_organization_id => childInfo_rec.organization_id,

Line 3114: WSH_SHIPPING_PARAMS_PVT.Get(

3110: IF l_debug_on THEN
3111: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
3112: END IF;
3113:
3114: WSH_SHIPPING_PARAMS_PVT.Get(
3115: p_organization_id => childInfo_rec.organization_id,
3116: x_param_info => l_param_info,
3117: x_return_status => l_return_status);
3118:

Line 3121: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);

3117: x_return_status => l_return_status);
3118:
3119: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3120: IF l_debug_on THEN
3121: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
3122: END IF;
3123: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
3124: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
3125: wsh_util_core.get_org_name(childInfo_rec.organization_id));

Line 4752: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

4748: l_fill_pc NUMBER;
4749: l_min_fill_pc NUMBER;
4750: l_cont_item_id NUMBER;
4751: l_organization_id NUMBER;
4752: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
4753:
4754: l_gr_wt NUMBER;
4755: l_net_wt NUMBER;
4756: l_vol NUMBER;

Line 4825: WSH_SHIPPING_PARAMS_PVT.Get(

4821:
4822: CLOSE Get_Cont_Info;
4823:
4824: --Bug 3562797 jckwok
4825: WSH_SHIPPING_PARAMS_PVT.Get(
4826: p_organization_id => l_organization_id,
4827: x_param_info => l_param_info,
4828: x_return_status => x_return_status);
4829: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

Line 4835: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||x_return_status);

4831: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
4832: wsh_util_core.get_org_name(l_organization_id));
4833: wsh_util_core.add_message(x_return_status,l_module_name);
4834: IF l_debug_on THEN
4835: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||x_return_status);
4836: WSH_DEBUG_SV.pop(l_module_name);
4837: END IF;
4838: return;
4839: END IF;

Line 5072: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

5068: consol_lpn_volume NUMBER;
5069:
5070: l_num_warnings NUMBER := 0;
5071: l_return_status VARCHAR2(100);
5072: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
5073:
5074: l_debug_on BOOLEAN;
5075: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELIVERY_WEIGHT_VOLUME';
5076:

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

5143: END IF;
5144:
5145: -- Get the Shipping parameters of DD's organization
5146: IF l_debug_on THEN
5147: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
5148: END IF;
5149:
5150: WSH_SHIPPING_PARAMS_PVT.Get(
5151: p_organization_id => l_organization_id,

Line 5150: WSH_SHIPPING_PARAMS_PVT.Get(

5146: IF l_debug_on THEN
5147: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
5148: END IF;
5149:
5150: WSH_SHIPPING_PARAMS_PVT.Get(
5151: p_organization_id => l_organization_id,
5152: x_param_info => l_param_info,
5153: x_return_status => l_return_status);
5154:

Line 5157: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);

5153: x_return_status => l_return_status);
5154:
5155: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
5156: IF l_debug_on THEN
5157: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
5158: END IF;
5159: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
5160: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
5161: wsh_util_core.get_org_name(l_organization_id));