DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_NEW_DELIVERY_ACTIONS

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

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

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

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

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

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

Line 3605: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(

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

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

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

Line 3684: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(

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

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

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

Line 3747: WSH_NEW_DELIVERY_ACTIONS.Adjust_Planned_Flag(

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

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

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

Line 6626: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(

6622: END LOOP;
6623:
6624: IF l_mdc_del_tab.count > 0 THEN
6625:
6626: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(
6627: p_parent_del => NULL,
6628: p_caller => 'WSH_UNASSIGN_TRIP',
6629: p_del_tab => l_mdc_del_tab,
6630: x_return_status => l_return_status);

Line 8967: 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);

8963:
8964: FOR i in 1..l_consol_delivery_tab.count LOOP
8965:
8966: IF l_debug_on THEN
8967: 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);
8968: END IF;
8969: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(
8970: p_parent_del => l_consol_delivery_tab(i),
8971: p_caller => p_caller,

Line 8969: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(

8965:
8966: IF l_debug_on THEN
8967: 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);
8968: END IF;
8969: WSH_NEW_DELIVERY_ACTIONS.Unassign_Dels_from_Consol_Del(
8970: p_parent_del => l_consol_delivery_tab(i),
8971: p_caller => p_caller,
8972: p_del_tab => l_dummy_tab,
8973: x_return_status => l_return_status);