DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_DELIVERY_LEGS_ACTIONS

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

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

Line 2798: wsh_delivery_legs_actions.assign_deliveries(

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

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

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

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

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

Line 3898: wsh_delivery_legs_actions.assign_deliveries(

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

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

4979: -- end of SSN Change, add conditional check
4980:
4981: IF l_internal_del_ids IS NOT NULL and l_internal_del_ids.count>0 THEN
4982: IF l_debug_on THEN
4983: 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);
4984: END IF;
4985: wsh_delivery_legs_actions.assign_deliveries(
4986: p_del_rows => l_internal_del_ids,
4987: p_trip_id => p_trip_id,

Line 4985: wsh_delivery_legs_actions.assign_deliveries(

4981: IF l_internal_del_ids IS NOT NULL and l_internal_del_ids.count>0 THEN
4982: IF l_debug_on THEN
4983: 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);
4984: END IF;
4985: wsh_delivery_legs_actions.assign_deliveries(
4986: p_del_rows => l_internal_del_ids,
4987: p_trip_id => p_trip_id,
4988: p_pickup_stop_id => l_pickup_stop_id,
4989: p_pickup_stop_seq => l_pickup_stop_seq,

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

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

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

5017:
5018:
5019: IF l_del_ids IS NOT NULL and l_del_ids.count>0 THEN
5020: IF l_debug_on THEN
5021: 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);
5022: END IF;
5023: wsh_delivery_legs_actions.assign_deliveries(
5024: p_del_rows => l_del_ids,
5025: p_trip_id => p_trip_id,

Line 5023: wsh_delivery_legs_actions.assign_deliveries(

5019: IF l_del_ids IS NOT NULL and l_del_ids.count>0 THEN
5020: IF l_debug_on THEN
5021: 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);
5022: END IF;
5023: wsh_delivery_legs_actions.assign_deliveries(
5024: p_del_rows => l_del_ids,
5025: p_trip_id => p_trip_id,
5026: p_pickup_stop_id => l_pickup_stop_id,
5027: p_pickup_stop_seq => l_pickup_stop_seq,

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

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

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

6645: --
6646: -- Debug Statements
6647: --
6648: IF l_debug_on THEN
6649: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
6650: END IF;
6651: --
6652: wsh_delivery_legs_actions.unassign_deliveries( p_del_rows, p_trip_id, NULL, NULL, l_return_status);
6653: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

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

6648: IF l_debug_on THEN
6649: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
6650: END IF;
6651: --
6652: wsh_delivery_legs_actions.unassign_deliveries( p_del_rows, p_trip_id, NULL, NULL, l_return_status);
6653: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
6654: raise unassign_deliveries_err;
6655: ELSE
6656: x_return_status := l_return_status;

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

6669: --
6670: -- Debug Statements
6671: --
6672: IF l_debug_on THEN
6673: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
6674: END IF;
6675: --
6676: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
6677: p_entity_type => 'TRIP',

Line 6676: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

6672: IF l_debug_on THEN
6673: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
6674: END IF;
6675: --
6676: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
6677: p_entity_type => 'TRIP',
6678: p_entity_ids => l_trip_tab,
6679: x_return_status => l_return_status);
6680: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN