DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_DELIVERY_LEGS_ACTIONS

Line 2797: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

2793: --
2794: END IF;
2795: --
2796: IF l_debug_on THEN
2797: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
2798: END IF;
2799: --
2800: wsh_delivery_legs_actions.assign_deliveries(
2801: p_del_rows => l_good_dels,

Line 2800: wsh_delivery_legs_actions.assign_deliveries(

2796: IF l_debug_on THEN
2797: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
2798: END IF;
2799: --
2800: wsh_delivery_legs_actions.assign_deliveries(
2801: p_del_rows => l_good_dels,
2802: p_trip_id => x_trip_id,
2803: p_create_flag => 'Y',
2804: x_leg_rows => l_del_legs,

Line 2816: wsh_debug_sv.log(l_module_name, 'Return Status after calling wsh_delivery_legs_actions.assign_deliveries', x_return_Status);

2812:
2813: IF x_return_status in ( WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2814: --
2815: IF l_debug_on THEN
2816: wsh_debug_sv.log(l_module_name, 'Return Status after calling wsh_delivery_legs_actions.assign_deliveries', x_return_Status);
2817: WSH_DEBUG_SV.pop(l_module_name);
2818: END IF;
2819: --
2820: RETURN;

Line 3897: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

3893: --
3894: -- Debug Statements
3895: --
3896: IF l_debug_on THEN
3897: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
3898: END IF;
3899: --
3900: wsh_delivery_legs_actions.assign_deliveries(
3901: p_del_rows => x_del_rows,

Line 3900: wsh_delivery_legs_actions.assign_deliveries(

3896: IF l_debug_on THEN
3897: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
3898: END IF;
3899: --
3900: wsh_delivery_legs_actions.assign_deliveries(
3901: p_del_rows => x_del_rows,
3902: p_trip_id => p_trip_id,
3903: p_create_flag => 'Y',
3904: x_leg_rows => l_del_legs,

Line 4985: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES for internal deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);

4981: -- end of SSN Change, add conditional check
4982:
4983: IF l_internal_del_ids IS NOT NULL and l_internal_del_ids.count>0 THEN
4984: IF l_debug_on THEN
4985: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES for internal deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4986: END IF;
4987: wsh_delivery_legs_actions.assign_deliveries(
4988: p_del_rows => l_internal_del_ids,
4989: p_trip_id => p_trip_id,

Line 4987: wsh_delivery_legs_actions.assign_deliveries(

4983: IF l_internal_del_ids IS NOT NULL and l_internal_del_ids.count>0 THEN
4984: IF l_debug_on THEN
4985: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES for internal deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4986: END IF;
4987: wsh_delivery_legs_actions.assign_deliveries(
4988: p_del_rows => l_internal_del_ids,
4989: p_trip_id => p_trip_id,
4990: p_pickup_stop_id => l_pickup_stop_id,
4991: p_pickup_stop_seq => l_pickup_stop_seq,

Line 5006: WSH_DEBUG_SV.log(l_module_name,'wsh_delivery_legs_actions.assign_deliveries return_status',l_return_status);

5002: p_dropoff_arr_date => p_dropoff_arr_date,
5003: p_dropoff_dep_date => p_dropoff_dep_date);
5004:
5005: IF l_debug_on THEN
5006: WSH_DEBUG_SV.log(l_module_name,'wsh_delivery_legs_actions.assign_deliveries return_status',l_return_status);
5007: END IF;
5008:
5009: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5010: x_return_status := l_return_status;

Line 5023: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES for regular deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);

5019:
5020:
5021: IF l_del_ids IS NOT NULL and l_del_ids.count>0 THEN
5022: IF l_debug_on THEN
5023: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES for regular deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
5024: END IF;
5025: wsh_delivery_legs_actions.assign_deliveries(
5026: p_del_rows => l_del_ids,
5027: p_trip_id => p_trip_id,

Line 5025: wsh_delivery_legs_actions.assign_deliveries(

5021: IF l_del_ids IS NOT NULL and l_del_ids.count>0 THEN
5022: IF l_debug_on THEN
5023: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES for regular deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
5024: END IF;
5025: wsh_delivery_legs_actions.assign_deliveries(
5026: p_del_rows => l_del_ids,
5027: p_trip_id => p_trip_id,
5028: p_pickup_stop_id => l_pickup_stop_id,
5029: p_pickup_stop_seq => l_pickup_stop_seq,

Line 5044: WSH_DEBUG_SV.log(l_module_name,'wsh_delivery_legs_actions.assign_deliveries return_status',l_return_status);

5040: p_dropoff_arr_date => p_dropoff_arr_date,
5041: p_dropoff_dep_date => p_dropoff_dep_date);
5042:
5043: IF l_debug_on THEN
5044: WSH_DEBUG_SV.log(l_module_name,'wsh_delivery_legs_actions.assign_deliveries return_status',l_return_status);
5045: END IF;
5046:
5047: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5048: x_return_status := l_return_status;

Line 6660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

6656: --
6657: -- Debug Statements
6658: --
6659: IF l_debug_on THEN
6660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
6661: END IF;
6662: --
6663: wsh_delivery_legs_actions.unassign_deliveries( p_del_rows, p_trip_id, NULL, NULL, l_return_status);
6664: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 6663: wsh_delivery_legs_actions.unassign_deliveries( p_del_rows, p_trip_id, NULL, NULL, l_return_status);

6659: IF l_debug_on THEN
6660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
6661: END IF;
6662: --
6663: wsh_delivery_legs_actions.unassign_deliveries( p_del_rows, p_trip_id, NULL, NULL, l_return_status);
6664: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
6665: raise unassign_deliveries_err;
6666: ELSE
6667: x_return_status := l_return_status;

Line 6684: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

6680: --
6681: -- Debug Statements
6682: --
6683: IF l_debug_on THEN
6684: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
6685: END IF;
6686: --
6687: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
6688: p_entity_type => 'TRIP',

Line 6687: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

6683: IF l_debug_on THEN
6684: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
6685: END IF;
6686: --
6687: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
6688: p_entity_type => 'TRIP',
6689: p_entity_ids => l_trip_tab,
6690: x_return_status => l_return_status);
6691: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN