DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PKG dependencies on WSH_DELIVERY_DETAILS_ACTIONS

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

1911:
1912: -- bug 4416863
1913: IF (l_delivery_id is not null) THEN
1914: IF l_debug_on THEN
1915: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_delivery_details_actions.unassign_detail_from_delivery', WSH_DEBUG_SV.C_PROC_LEVEL);
1916: END IF;
1917: wsh_delivery_details_actions.unassign_detail_from_delivery (
1918: p_detail_id => l_delivery_detail_id,
1919: x_return_status => l_return_status);

Line 1917: wsh_delivery_details_actions.unassign_detail_from_delivery (

1913: IF (l_delivery_id is not null) THEN
1914: IF l_debug_on THEN
1915: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_delivery_details_actions.unassign_detail_from_delivery', WSH_DEBUG_SV.C_PROC_LEVEL);
1916: END IF;
1917: wsh_delivery_details_actions.unassign_detail_from_delivery (
1918: p_detail_id => l_delivery_detail_id,
1919: x_return_status => l_return_status);
1920: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR
1921: (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 3207: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

3203: wsh_delivery_assignments wda
3204: WHERE wdd.delivery_detail_id = p_delivery_details_info.delivery_detail_id
3205: AND wdd.delivery_detail_id = wda.delivery_detail_id;
3206:
3207: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
3208: l_cons_dd_ids WSH_UTIL_CORE.Id_Tab_Type ; --Stores the dd_ids returned by Consolidate_Source_Line
3209: l_back_order_consolidation VARCHAR2(1) := 'N';
3210: l_req NUMBER;
3211: l_req2 NUMBER;

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

4151: END IF;
4152: --
4153: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_status);
4154: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4155: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');
4156: x_return_status := l_return_status;
4157: END IF;
4158: IF (l_global_param_rec.consolidate_bo_lines = 'Y') THEN
4159: --{

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

4170: --
4171: -- Debug Statements
4172: --
4173: IF l_debug_on THEN
4174: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);
4175: END IF;
4176: --
4177: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
4178: p_Cons_Source_Line_Rec_Tab => l_cons_source_line_rec_tab,

Line 4177: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(

4173: IF l_debug_on THEN
4174: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);
4175: END IF;
4176: --
4177: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
4178: p_Cons_Source_Line_Rec_Tab => l_cons_source_line_rec_tab,
4179: x_consolidate_ids => l_cons_dd_ids,
4180: x_return_status => l_return_status);
4181: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )THEN