DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_SHIP_CONFIRM_ACTIONS2

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

3846: --
3847: -- Debug Statements
3848: --
3849: IF l_debug_on THEN
3850: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.CHECK_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
3851: END IF;
3852: --
3853: WSH_SHIP_CONFIRM_ACTIONS2.check_exception(
3854: p_delivery_detail_id => l_delivery_detail_id,

Line 3853: WSH_SHIP_CONFIRM_ACTIONS2.check_exception(

3849: IF l_debug_on THEN
3850: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.CHECK_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
3851: END IF;
3852: --
3853: WSH_SHIP_CONFIRM_ACTIONS2.check_exception(
3854: p_delivery_detail_id => l_delivery_detail_id,
3855: x_exception_exist => l_exception_exist,
3856: x_severity_present => l_severity_present,
3857: x_return_status => l_return_status);

Line 3890: WSH_SHIP_CONFIRM_ACTIONS2.check_exception(

3886: OPEN Get_Containers(l_delivery_detail_id);
3887: LOOP
3888: FETCH Get_Containers INTO l_container_id;
3889: EXIT WHEN Get_Containers%NOTFOUND;
3890: WSH_SHIP_CONFIRM_ACTIONS2.check_exception(
3891: p_delivery_detail_id => l_container_id,
3892: x_exception_exist => l_exception_exist,
3893: x_severity_present => l_severity_present,
3894: x_return_status => l_return_status);

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

4167: --
4168: -- Debug Statements
4169: --
4170: IF l_debug_on THEN
4171: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4172: END IF;
4173: --
4174:
4175:

Line 4177: wsh_ship_confirm_actions2.backorder(

4173: --
4174:
4175:
4176:
4177: wsh_ship_confirm_actions2.backorder(
4178: p_detail_ids => l_assigned_line_ids ,
4179: p_line_ids => l_assigned_source_lines, -- Consolidation of BO Delivery Details project
4180: p_bo_qtys => l_assigned_req_qtys , -- pass total requested_quantity for BO
4181: p_req_qtys => l_assigned_req_qtys ,

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

4240: --
4241: -- Debug Statements
4242: --
4243: IF l_debug_on THEN
4244: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4245: END IF;
4246: --
4247:
4248: wsh_ship_confirm_actions2.backorder(

Line 4248: wsh_ship_confirm_actions2.backorder(

4244: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4245: END IF;
4246: --
4247:
4248: wsh_ship_confirm_actions2.backorder(
4249: p_detail_ids => l_assigned_line_ids ,
4250: p_line_ids => l_assigned_source_lines, -- Consolidation of BO Delivery Details project
4251: p_bo_qtys => l_assigned_req_qtys , -- pass total requested_quantity for BO
4252: p_req_qtys => l_assigned_req_qtys ,

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

4578: --
4579: -- Debug Statements
4580: --
4581: IF l_debug_on THEN
4582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4583: END IF;
4584: --
4585:
4586: wsh_ship_confirm_actions2.backorder(

Line 4586: wsh_ship_confirm_actions2.backorder(

4582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4583: END IF;
4584: --
4585:
4586: wsh_ship_confirm_actions2.backorder(
4587: p_detail_ids => l_cc_rows ,
4588: p_line_ids => l_cc_source_lines, -- Consolidation of BO Delivery Details project
4589: p_bo_qtys => l_cc_qtys ,
4590: p_req_qtys => l_cc_req_qtys ,

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

4613: --
4614: -- Debug Statements
4615: --
4616: IF l_debug_on THEN
4617: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4618: END IF;
4619: --
4620:
4621: wsh_ship_confirm_actions2.backorder(

Line 4621: wsh_ship_confirm_actions2.backorder(

4617: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS2.BACKORDER',WSH_DEBUG_SV.C_PROC_LEVEL);
4618: END IF;
4619: --
4620:
4621: wsh_ship_confirm_actions2.backorder(
4622: p_detail_ids => l_bo_rows ,
4623: p_line_ids => l_bo_source_lines, -- Consolidation of BO Delivery Details project
4624: p_bo_qtys => l_bo_qtys ,
4625: p_req_qtys => l_bo_req_qtys ,

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

4956:
4957:
4958: -- Consolidation of BO Delivery Details project.
4959: -- At this point of time, some of the dd_ids in l_unassign_dds with released_status as 'B'
4960: -- might have been deleted by wsh_ship_confirm_actions2.backorder api.
4961: -- So checking whether dd_ids to be unassigned are already deleted.
4962: -- Do this only if there are lines to be unassigned AND there is atleast one delivery line BackOrdered.
4963: -- Begin
4964: IF (l_unassign_dds.COUNT > 0 AND (l_out_bo_rows.count > 0 OR l_out_cc_rows.count > 0)) THEN