DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_NEW_DELIVERY_ACTIONS

Line 1384: wsh_new_delivery_actions.firm (p_del_rows => l_del_tmp_rows,

1380: l_del_tmp_rows(l_del_tmp_rows.COUNT+1):=cur.delivery_id;
1381: END LOOP;
1382:
1383: IF l_del_tmp_rows.COUNT>0 THEN
1384: wsh_new_delivery_actions.firm (p_del_rows => l_del_tmp_rows,
1385: x_return_status => l_return_status);
1386: WSH_UTIL_CORE.api_post_call
1387: (
1388: p_return_status => l_return_status,

Line 1493: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.changeStatus',l_module_name);

1489: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1490: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1491: END IF;
1492: WHEN others THEN
1493: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.changeStatus',l_module_name);
1494: --
1495: --ROLLBACK TO trip_chgStatus_begin_sp;
1496: --
1497: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3603: wsh_debug_sv.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag ');

3599:
3600: --
3601: IF l_debug_on THEN--{
3602: wsh_debug_sv.log(l_module_name,'id_tab_temp count ',l_id_tab_temp.COUNT);
3603: wsh_debug_sv.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag ');
3604: END IF;--}
3605:
3606: -- deliveryMerge
3607: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(

Line 3607: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(

3603: wsh_debug_sv.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag ');
3604: END IF;--}
3605:
3606: -- deliveryMerge
3607: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(
3608: p_delivery_ids => l_id_tab_temp,
3609: p_caller => 'WSH_DLMG',
3610: p_force_appending_limit => 'N',
3611: p_call_lcss => 'Y',

Line 3616: wsh_debug_sv.log(l_module_name,'Return status from WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag ', l_return_status);

3612: p_event => NULL,
3613: x_return_status => l_return_status);
3614:
3615: IF l_debug_on THEN --{
3616: wsh_debug_sv.log(l_module_name,'Return status from WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag ', l_return_status);
3617: END IF;--}
3618:
3619: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN--{
3620: raise Adjust_Planned_Flag_Err;

Line 3686: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(

3682:
3683: ELSE --line_groups --}{
3684: --
3685: -- deliveryMerge
3686: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(
3687: p_delivery_ids => x_del_rows,
3688: p_caller => 'WSH_DLMG',
3689: p_force_appending_limit => 'N',
3690: p_call_lcss => 'Y',

Line 3695: wsh_debug_sv.log(l_module_name,'Return status from WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag ', l_return_status);

3691: p_event => NULL,
3692: x_return_status => l_return_status);
3693:
3694: IF l_debug_on THEN --{
3695: wsh_debug_sv.log(l_module_name,'Return status from WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag ', l_return_status);
3696: END IF;--}
3697:
3698: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN--{
3699: raise Adjust_Planned_Flag_Err;

Line 3749: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(

3745:
3746: ELSE --}{
3747: --
3748: -- deliveryMerge
3749: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(
3750: p_delivery_ids => x_del_rows,
3751: p_caller => 'WSH_DLMG',
3752: p_force_appending_limit => 'N',
3753: p_call_lcss => 'Y',

Line 3758: wsh_debug_sv.log(l_module_name,'Return status from WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag ', l_return_status);

3754: p_event => NULL,
3755: x_return_status => l_return_status);
3756:
3757: IF l_debug_on THEN --{
3758: wsh_debug_sv.log(l_module_name,'Return status from WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag ', l_return_status);
3759: END IF;--}
3760:
3761: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN--{
3762: raise Adjust_Planned_Flag_Err;

Line 6637: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(

6633: END LOOP;
6634:
6635: IF l_mdc_del_tab.count > 0 THEN
6636:
6637: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(
6638: p_parent_del => NULL,
6639: p_caller => 'WSH_UNASSIGN_TRIP',
6640: p_del_tab => l_mdc_del_tab,
6641: x_return_status => l_return_status);

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

8974:
8975: FOR i in 1..l_consol_delivery_tab.count LOOP
8976:
8977: IF l_debug_on THEN
8978: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del',WSH_DEBUG_SV.C_PROC_LEVEL);
8979: END IF;
8980: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(
8981: p_parent_del => l_consol_delivery_tab(i),
8982: p_caller => p_caller,

Line 8980: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(

8976:
8977: IF l_debug_on THEN
8978: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del',WSH_DEBUG_SV.C_PROC_LEVEL);
8979: END IF;
8980: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(
8981: p_parent_del => l_consol_delivery_tab(i),
8982: p_caller => p_caller,
8983: p_del_tab => l_dummy_tab,
8984: x_return_status => l_return_status);