DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PKG dependencies on WSH_DELIVERY_DETAILS_ACTIONS

Line 2052: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_delivery_details_actions.unassign_detail_from_delivery', WSH_DEBUG_SV.C_PROC_LEVEL);

2048:
2049: -- bug 4416863
2050: IF (l_delivery_id is not null) THEN
2051: IF l_debug_on THEN
2052: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_delivery_details_actions.unassign_detail_from_delivery', WSH_DEBUG_SV.C_PROC_LEVEL);
2053: END IF;
2054: wsh_delivery_details_actions.unassign_detail_from_delivery (
2055: p_detail_id => l_delivery_detail_id,
2056: x_return_status => l_return_status);

Line 2054: wsh_delivery_details_actions.unassign_detail_from_delivery (

2050: IF (l_delivery_id is not null) THEN
2051: IF l_debug_on THEN
2052: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_delivery_details_actions.unassign_detail_from_delivery', WSH_DEBUG_SV.C_PROC_LEVEL);
2053: END IF;
2054: wsh_delivery_details_actions.unassign_detail_from_delivery (
2055: p_detail_id => l_delivery_detail_id,
2056: x_return_status => l_return_status);
2057: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR
2058: (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 3342: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

3338: wsh_delivery_assignments wda
3339: WHERE wdd.delivery_detail_id = p_delivery_details_info.delivery_detail_id
3340: AND wdd.delivery_detail_id = wda.delivery_detail_id;
3341:
3342: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
3343: l_cons_dd_ids WSH_UTIL_CORE.Id_Tab_Type ; --Stores the dd_ids returned by Consolidate_Source_Line
3344: l_back_order_consolidation VARCHAR2(1) := 'N';
3345: l_req NUMBER;
3346: l_req2 NUMBER;

Line 4290: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');

4286: END IF;
4287: --
4288: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_status);
4289: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4290: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');
4291: x_return_status := l_return_status;
4292: END IF;
4293: IF (l_global_param_rec.consolidate_bo_lines = 'Y') THEN
4294: --{

Line 4309: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);

4305: --
4306: -- Debug Statements
4307: --
4308: IF l_debug_on THEN
4309: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);
4310: END IF;
4311: --
4312: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
4313: p_Cons_Source_Line_Rec_Tab => l_cons_source_line_rec_tab,

Line 4312: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(

4308: IF l_debug_on THEN
4309: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);
4310: END IF;
4311: --
4312: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
4313: p_Cons_Source_Line_Rec_Tab => l_cons_source_line_rec_tab,
4314: x_consolidate_ids => l_cons_dd_ids,
4315: x_return_status => l_return_status);
4316: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )THEN