DBA Data[Home] [Help]

APPS.WSH_WV_UTILS dependencies on WSH_SHIPPING_PARAMS_PVT

Line 3042: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

3038: l_err_container NUMBER;
3039: mark_reprice_error EXCEPTION;
3040: invalid_detail EXCEPTION;
3041:
3042: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
3043: l_num_warnings NUMBER := 0;
3044: l_unit_wt NUMBER;
3045: l_unit_vol NUMBER;
3046:

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

3120: END IF;
3121:
3122: -- Get the shipping parameters of container organization
3123: IF l_debug_on THEN
3124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
3125: END IF;
3126:
3127: WSH_SHIPPING_PARAMS_PVT.Get(
3128: p_organization_id => childInfo_rec.organization_id,

Line 3127: WSH_SHIPPING_PARAMS_PVT.Get(

3123: IF l_debug_on THEN
3124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
3125: END IF;
3126:
3127: WSH_SHIPPING_PARAMS_PVT.Get(
3128: p_organization_id => childInfo_rec.organization_id,
3129: x_param_info => l_param_info,
3130: x_return_status => l_return_status);
3131:

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

3130: x_return_status => l_return_status);
3131:
3132: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3133: IF l_debug_on THEN
3134: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
3135: END IF;
3136: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
3137: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
3138: wsh_util_core.get_org_name(childInfo_rec.organization_id));

Line 4765: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

4761: l_fill_pc NUMBER;
4762: l_min_fill_pc NUMBER;
4763: l_cont_item_id NUMBER;
4764: l_organization_id NUMBER;
4765: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
4766:
4767: l_gr_wt NUMBER;
4768: l_net_wt NUMBER;
4769: l_vol NUMBER;

Line 4838: WSH_SHIPPING_PARAMS_PVT.Get(

4834:
4835: CLOSE Get_Cont_Info;
4836:
4837: --Bug 3562797 jckwok
4838: WSH_SHIPPING_PARAMS_PVT.Get(
4839: p_organization_id => l_organization_id,
4840: x_param_info => l_param_info,
4841: x_return_status => x_return_status);
4842: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

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

4844: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
4845: wsh_util_core.get_org_name(l_organization_id));
4846: wsh_util_core.add_message(x_return_status,l_module_name);
4847: IF l_debug_on THEN
4848: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||x_return_status);
4849: WSH_DEBUG_SV.pop(l_module_name);
4850: END IF;
4851: return;
4852: END IF;

Line 5085: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

5081: consol_lpn_volume NUMBER;
5082:
5083: l_num_warnings NUMBER := 0;
5084: l_return_status VARCHAR2(100);
5085: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
5086:
5087: l_debug_on BOOLEAN;
5088: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELIVERY_WEIGHT_VOLUME';
5089:

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

5156: END IF;
5157:
5158: -- Get the Shipping parameters of DD's organization
5159: IF l_debug_on THEN
5160: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
5161: END IF;
5162:
5163: WSH_SHIPPING_PARAMS_PVT.Get(
5164: p_organization_id => l_organization_id,

Line 5163: WSH_SHIPPING_PARAMS_PVT.Get(

5159: IF l_debug_on THEN
5160: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
5161: END IF;
5162:
5163: WSH_SHIPPING_PARAMS_PVT.Get(
5164: p_organization_id => l_organization_id,
5165: x_param_info => l_param_info,
5166: x_return_status => l_return_status);
5167:

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

5166: x_return_status => l_return_status);
5167:
5168: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
5169: IF l_debug_on THEN
5170: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
5171: END IF;
5172: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
5173: FND_MESSAGE.Set_Token('ORGANIZAION_CODE',
5174: wsh_util_core.get_org_name(l_organization_id));