DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_SHIP_CONFIRM_ACTIONS2

Line 3903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.CHECK_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

3899: --
3900: -- Debug Statements
3901: --
3902: IF l_debug_on THEN
3903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.CHECK_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
3904: END IF;
3905: --
3906: WSH_SHIP_CONFIRM_ACTIONS2.check_exception(
3907: p_delivery_detail_id => l_delivery_detail_id,

Line 3906: WSH_SHIP_CONFIRM_ACTIONS2.check_exception(

3902: IF l_debug_on THEN
3903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.CHECK_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
3904: END IF;
3905: --
3906: WSH_SHIP_CONFIRM_ACTIONS2.check_exception(
3907: p_delivery_detail_id => l_delivery_detail_id,
3908: x_exception_exist => l_exception_exist,
3909: x_severity_present => l_severity_present,
3910: x_return_status => l_return_status);

Line 3943: WSH_SHIP_CONFIRM_ACTIONS2.check_exception(

3939: OPEN Get_Containers(l_delivery_detail_id);
3940: LOOP
3941: FETCH Get_Containers INTO l_container_id;
3942: EXIT WHEN Get_Containers%NOTFOUND;
3943: WSH_SHIP_CONFIRM_ACTIONS2.check_exception(
3944: p_delivery_detail_id => l_container_id,
3945: x_exception_exist => l_exception_exist,
3946: x_severity_present => l_severity_present,
3947: x_return_status => l_return_status);

Line 4228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);

4224: --
4225: -- Debug Statements
4226: --
4227: IF l_debug_on THEN
4228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4229: END IF;
4230: --
4231:
4232:

Line 4234: wsh_ship_confirm_actions2.backorder(

4230: --
4231:
4232:
4233:
4234: wsh_ship_confirm_actions2.backorder(
4235: p_detail_ids => l_assigned_line_ids ,
4236: p_line_ids => l_assigned_source_lines, -- Consolidation of BO Delivery Details project
4237: p_bo_qtys => l_assigned_req_qtys , -- pass total requested_quantity for BO
4238: p_req_qtys => l_assigned_req_qtys ,

Line 4302: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);

4298: --
4299: -- Debug Statements
4300: --
4301: IF l_debug_on THEN
4302: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4303: END IF;
4304: --
4305:
4306: wsh_ship_confirm_actions2.backorder(

Line 4306: wsh_ship_confirm_actions2.backorder(

4302: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4303: END IF;
4304: --
4305:
4306: wsh_ship_confirm_actions2.backorder(
4307: p_detail_ids => l_assigned_line_ids ,
4308: p_line_ids => l_assigned_source_lines, -- Consolidation of BO Delivery Details project
4309: p_bo_qtys => l_assigned_req_qtys , -- pass total requested_quantity for BO
4310: p_req_qtys => l_assigned_req_qtys ,

Line 4664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);

4660: --
4661: -- Debug Statements
4662: --
4663: IF l_debug_on THEN
4664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4665: END IF;
4666: --
4667:
4668: wsh_ship_confirm_actions2.backorder(

Line 4668: wsh_ship_confirm_actions2.backorder(

4664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4665: END IF;
4666: --
4667:
4668: wsh_ship_confirm_actions2.backorder(
4669: p_detail_ids => l_cc_rows ,
4670: p_line_ids => l_cc_source_lines, -- Consolidation of BO Delivery Details project
4671: p_bo_qtys => l_cc_qtys ,
4672: p_req_qtys => l_cc_req_qtys ,

Line 4700: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);

4696: --
4697: -- Debug Statements
4698: --
4699: IF l_debug_on THEN
4700: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4701: END IF;
4702: --
4703:
4704: wsh_ship_confirm_actions2.backorder(

Line 4704: wsh_ship_confirm_actions2.backorder(

4700: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4701: END IF;
4702: --
4703:
4704: wsh_ship_confirm_actions2.backorder(
4705: p_detail_ids => l_bo_rows ,
4706: p_line_ids => l_bo_source_lines, -- Consolidation of BO Delivery Details project
4707: p_bo_qtys => l_bo_qtys ,
4708: p_req_qtys => l_bo_req_qtys ,

Line 5044: -- might have been deleted by wsh_ship_confirm_actions2.backorder api.

5040:
5041:
5042: -- Consolidation of BO Delivery Details project.
5043: -- At this point of time, some of the dd_ids in l_unassign_dds with released_status as 'B'
5044: -- might have been deleted by wsh_ship_confirm_actions2.backorder api.
5045: -- So checking whether dd_ids to be unassigned are already deleted.
5046: -- Do this only if there are lines to be unassigned AND there is atleast one delivery line BackOrdered.
5047: -- Begin
5048: IF (l_unassign_dds.COUNT > 0 AND (l_out_bo_rows.count > 0 OR l_out_cc_rows.count > 0)) THEN