3:
4: --
5: --3509004:public api changes
6: PROCEDURE user_non_updatable_columns
7: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
8: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
9: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
10: x_return_status OUT NOCOPY VARCHAR2);
11:
4: --
5: --3509004:public api changes
6: PROCEDURE user_non_updatable_columns
7: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
8: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
9: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
10: x_return_status OUT NOCOPY VARCHAR2);
11:
12:
115: --
116: -- Debug Statements
117: --
118: IF l_debug_on THEN
119: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
120: END IF;
121: --
122: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
123: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
118: IF l_debug_on THEN
119: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
120: END IF;
121: --
122: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
123: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
124: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
125: --
126: -- Debug Statements
155: --changes in 'firm' behavior - only ship method is reqd.
156: --if tp is installed and mode happens to be TL, vehicle is required
157: IF (l_ship_method IS NULL) THEN
158: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_VEHICLE_SH_M_REQ');
159: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
160: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
161: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
162: --
163: -- Debug Statements
171:
172: IF l_mode='TRUCK' and l_vehicle is NULL AND WSH_UTIL_CORE.TP_IS_INSTALLED='Y' THEN
173: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_MODE_TR_REQ_VEH');
174: IF l_debug_on THEN
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
176: END IF;
177: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
179: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
173: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_MODE_TR_REQ_VEH');
174: IF l_debug_on THEN
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
176: END IF;
177: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
179: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
180: --
181: -- Debug Statements
198: --
199: -- Debug Statements
200: --
201: IF l_debug_on THEN
202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
203: END IF;
204: --
205: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
201: IF l_debug_on THEN
202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
203: END IF;
204: --
205: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
207: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
208: END IF;
209:
218: --
219: -- Debug Statements
220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
223: END IF;
224: --
225: -- Bug 3697947
226: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(st.stop_id,p_caller));
231: --
232: -- Debug Statements
233: --
234: IF l_debug_on THEN
235: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
236: END IF;
237: --
238: -- Bug 3697947
239: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(st.stop_id,p_caller));
246: --
247: -- Debug Statements
248: --
249: IF l_debug_on THEN
250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
251: END IF;
252: --
253: -- Bug 3697947
254: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(st.stop_id, p_caller));
838: CLOSE trip_info;
839:
840: IF (l_status_code <> 'OP') THEN
841: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');
842: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
843: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
844: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
845: --
846: -- Debug Statements
859: --
860: -- Debug Statements
861: --
862: IF l_debug_on THEN
863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: --
866: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));
867: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
862: IF l_debug_on THEN
863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: --
866: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));
867: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
868: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
869: ELSIF (l_planned_flag='F') THEN
870: FND_MESSAGE.SET_NAME('WSH','WSH_DELETE_FIRM_TRIP');
867: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
868: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
869: ELSIF (l_planned_flag='F') THEN
870: FND_MESSAGE.SET_NAME('WSH','WSH_DELETE_FIRM_TRIP');
871: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
872: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
873: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
874: IF l_debug_on THEN
875: WSH_DEBUG_SV.pop(l_module_name);
914: --
915: -- Debug Statements
916: --
917: IF l_debug_on THEN
918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
919: END IF;
920: --
921: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));
922: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
917: IF l_debug_on THEN
918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
919: END IF;
920: --
921: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));
922: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
923: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
924: END IF;
925:
1511: END IF;
1512:
1513: IF (l_trip_status_code = 'CL') THEN
1514: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');
1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trip_id));
1516: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1517: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1518: --
1519: -- Debug Statements
1530: --
1531: -- Debug Statements
1532: --
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1535: END IF;
1536: --
1537: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
1538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1535: END IF;
1536: --
1537: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
1538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1539: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1540: --
1541: -- Debug Statements
1550: --
1551: -- Debug Statements
1552: --
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1555: END IF;
1556: --
1557: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1555: END IF;
1556: --
1557: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1559: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1560: --
1561: -- Debug Statements
2363: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' THEN
2364: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_ACTION_INELIGIBLE');
2365: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('TRIP',p_action));
2366: FND_MESSAGE.Set_Token('TRIP_NAME',
2367: wsh_trips_pvt.get_name(x_error_ids(x_error_ids.COUNT)));
2368: wsh_util_core.add_message('E',l_module_name);
2369: END IF;
2370: END;
2371:
2514: END Validate_Arrive_after_trip;
2515:
2516:
2517: PROCEDURE Validate_Consol_Allowed(
2518: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2519: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2520: x_return_status OUT NOCOPY VARCHAR2) IS
2521:
2522: l_vehicle_item_id wsh_trips.vehicle_item_id%type;
2515:
2516:
2517: PROCEDURE Validate_Consol_Allowed(
2518: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2519: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2520: x_return_status OUT NOCOPY VARCHAR2) IS
2521:
2522: l_vehicle_item_id wsh_trips.vehicle_item_id%type;
2523: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;
2693:
2694:
2695:
2696: PROCEDURE eliminate_displayonly_fields (
2697: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
2698: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
2699: , x_trip_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2700: )
2701: IS
2695:
2696: PROCEDURE eliminate_displayonly_fields (
2697: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
2698: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
2699: , x_trip_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2700: )
2701: IS
2702: BEGIN
2703:
2985: -----------------------------------------------------------*/
2986:
2987: PROCEDURE disable_from_list(
2988: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
2989: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
2990: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2991: , x_return_status OUT NOCOPY VARCHAR2
2992: , x_field_name OUT NOCOPY VARCHAR2
2993:
2986:
2987: PROCEDURE disable_from_list(
2988: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
2989: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
2990: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2991: , x_return_status OUT NOCOPY VARCHAR2
2992: , x_field_name OUT NOCOPY VARCHAR2
2993:
2994: ) IS
3151: -----------------------------------------------------------*/
3152:
3153: PROCEDURE enable_from_list(
3154: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
3155: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
3156: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3157: , x_return_status OUT NOCOPY VARCHAR2
3158: , x_field_name OUT NOCOPY VARCHAR2
3159:
3152:
3153: PROCEDURE enable_from_list(
3154: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
3155: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
3156: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3157: , x_return_status OUT NOCOPY VARCHAR2
3158: , x_field_name OUT NOCOPY VARCHAR2
3159:
3160: ) IS
3455: -- Overloaded procedure
3456: -- Bug 2678363: Added new parameter p_in_rec, in place of p_action
3457: --
3458: PROCEDURE Get_Disabled_List (
3459: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
3460: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
3461: , x_return_status OUT NOCOPY VARCHAR2
3462: , x_msg_count OUT NOCOPY NUMBER
3463: , x_msg_data OUT NOCOPY VARCHAR2
3460: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
3461: , x_return_status OUT NOCOPY VARCHAR2
3462: , x_msg_count OUT NOCOPY NUMBER
3463: , x_msg_data OUT NOCOPY VARCHAR2
3464: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3465: )
3466: IS
3467: l_disabled_list WSH_UTIL_CORE.column_tab_type;
3468: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;
3464: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3465: )
3466: IS
3467: l_disabled_list WSH_UTIL_CORE.column_tab_type;
3468: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;
3469: l_return_status VARCHAR2(30);
3470: l_field_name VARCHAR2(100);
3471: l_debug_on BOOLEAN;
3472: l_module_name CONSTANT VARCHAR2(100) :=
3554: END IF;
3555: END IF;
3556: --
3557:
3558: WSH_TRIPS_PVT.populate_record(
3559: p_trip_id => p_trip_rec.trip_id,
3560: x_trip_info => x_trip_rec,
3561: x_return_status => x_return_status);
3562:
4153: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
4154: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4155: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
4156: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
4157: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trips_pvt.get_name(l_exceptions_tab(exp_cnt).entity_id));
4158: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4159: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4160: wsh_util_core.add_message(x_return_status);
4161: l_num_warnings := l_num_warnings + 1;
4446: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
4447: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4448: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
4449: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
4450: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trips_pvt.get_name(l_exceptions_tab(exp_cnt).entity_id));
4451: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4452: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4453: wsh_util_core.add_message(x_return_status);
4454: l_num_warnings := l_num_warnings + 1;
5033: -- J-IB-NPARIKH-}
5034: --
5035: --3509004:public api change
5036: PROCEDURE user_non_updatable_columns
5037: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
5038: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
5039: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
5040: x_return_status OUT NOCOPY VARCHAR2)
5041:
5034: --
5035: --3509004:public api change
5036: PROCEDURE user_non_updatable_columns
5037: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
5038: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
5039: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
5040: x_return_status OUT NOCOPY VARCHAR2)
5041:
5042: IS
6024: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_TRIP');
6025: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
6026: WSH_NEW_DELIVERIES_PVT.get_name(l_del_to_unassign(i)));
6027: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
6028: WSH_TRIPS_PVT.get_name(p_trip_id));
6029: l_num_warn := l_num_warn + 1;
6030: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
6031:
6032: i := l_del_to_unassign.next(i);