DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_NEW_DELIVERY_ACTIONS

Line 5021: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.PROCESS_CARRIER_SELECTION',WSH_DEBUG_SV.C_PROC_LEVEL);

5017: -- make sure the table is empty
5018: --
5019: l_del_ids_tab.DELETE;
5020: IF l_debug_on THEN
5021: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.PROCESS_CARRIER_SELECTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5022: END IF;
5023: WSH_NEW_DELIVERY_ACTIONS.PROCESS_CARRIER_SELECTION (
5024: p_delivery_id_tab => l_del_ids_tab,
5025: p_batch_id => p_batch_id,

Line 5023: WSH_NEW_DELIVERY_ACTIONS.PROCESS_CARRIER_SELECTION (

5019: l_del_ids_tab.DELETE;
5020: IF l_debug_on THEN
5021: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.PROCESS_CARRIER_SELECTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5022: END IF;
5023: WSH_NEW_DELIVERY_ACTIONS.PROCESS_CARRIER_SELECTION (
5024: p_delivery_id_tab => l_del_ids_tab,
5025: p_batch_id => p_batch_id,
5026: p_form_flag => 'N',
5027: p_caller => 'WSH_PICK_RELEASE',

Line 5112: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);

5108: -- Delivery Merge For Pre-existing / Appended Deliveries
5109: IF g_assigned_del_tbl.COUNT > 0 THEN --{
5110: IF l_debug_on THEN
5111: WSH_DEBUG_SV.log(l_module_name,'g_assigned_del_tbl.COUNT', g_assigned_del_tbl.COUNT);
5112: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);
5113: END IF;
5114: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag (
5115: p_delivery_ids => g_assigned_del_tbl,
5116: p_caller => 'WSH_DLMG',

Line 5114: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag (

5110: IF l_debug_on THEN
5111: WSH_DEBUG_SV.log(l_module_name,'g_assigned_del_tbl.COUNT', g_assigned_del_tbl.COUNT);
5112: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);
5113: END IF;
5114: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag (
5115: p_delivery_ids => g_assigned_del_tbl,
5116: p_caller => 'WSH_DLMG',
5117: p_force_appending_limit => 'N',
5118: p_call_lcss => 'Y',

Line 5125: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag');

5121: WSH_DEBUG_SV.log(l_module_name,'Adjust_Planned_Flag returns ',l_return_status);
5122: END IF;
5123: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
5124: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
5125: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag');
5126: RAISE e_Return;
5127: END IF;
5128: END IF; --}
5129:

Line 5140: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);

5136: l_detail_cfetch := c_batch_unplanned_del%ROWCOUNT - l_detail_pfetch;
5137: EXIT WHEN (l_detail_cfetch = 0);
5138: IF l_debug_on THEN
5139: WSH_DEBUG_SV.log(l_module_name,'l_delivery_ids.COUNT', l_delivery_ids.COUNT);
5140: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);
5141: END IF;
5142: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag (
5143: p_delivery_ids => l_delivery_ids,
5144: p_caller => 'WSH_DLMG',

Line 5142: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag (

5138: IF l_debug_on THEN
5139: WSH_DEBUG_SV.log(l_module_name,'l_delivery_ids.COUNT', l_delivery_ids.COUNT);
5140: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag',WSH_DEBUG_SV.C_PROC_LEVEL);
5141: END IF;
5142: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag (
5143: p_delivery_ids => l_delivery_ids,
5144: p_caller => 'WSH_DLMG',
5145: p_force_appending_limit => 'N',
5146: p_call_lcss => 'Y',

Line 5153: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag');

5149: WSH_DEBUG_SV.log(l_module_name,'Adjust_Planned_Flag returns ',l_return_status);
5150: END IF;
5151: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
5152: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
5153: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag');
5154: RAISE e_Return;
5155: END IF;
5156: l_detail_pfetch := c_batch_unplanned_del%ROWCOUNT;
5157: END LOOP; --}