DBA Data[Home] [Help]

APPS.WSH_TRIP_VALIDATIONS dependencies on WSH_TRIPS_PVT

Line 7: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,

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:

Line 8: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,

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:

Line 119: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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;

Line 122: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

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

Line 159: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

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

Line 175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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);

Line 177: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

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

Line 202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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;

Line 205: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

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:

Line 222: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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));

Line 235: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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));

Line 250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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));

Line 842: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

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

Line 863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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;

Line 866: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));

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');

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

Line 918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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;

Line 921: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));

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:

Line 1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trip_id));

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

Line 1534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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;

Line 1537: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));

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

Line 1554: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

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;

Line 1557: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));

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

Line 2370: wsh_trips_pvt.get_name(x_error_ids(x_error_ids.COUNT)));

2366: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' THEN
2367: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_ACTION_INELIGIBLE');
2368: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('TRIP',p_action));
2369: FND_MESSAGE.Set_Token('TRIP_NAME',
2370: wsh_trips_pvt.get_name(x_error_ids(x_error_ids.COUNT)));
2371: wsh_util_core.add_message('E',l_module_name);
2372: END IF;
2373: END;
2374:

Line 2521: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,

2517: END Validate_Arrive_after_trip;
2518:
2519:
2520: PROCEDURE Validate_Consol_Allowed(
2521: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2522: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2523: x_return_status OUT NOCOPY VARCHAR2) IS
2524:
2525: l_vehicle_item_id wsh_trips.vehicle_item_id%type;

Line 2522: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,

2518:
2519:
2520: PROCEDURE Validate_Consol_Allowed(
2521: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2522: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
2523: x_return_status OUT NOCOPY VARCHAR2) IS
2524:
2525: l_vehicle_item_id wsh_trips.vehicle_item_id%type;
2526: l_vehicle_organization_id wsh_trips.vehicle_organization_id%type;

Line 2700: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type

2696:
2697:
2698:
2699: PROCEDURE eliminate_displayonly_fields (
2700: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
2701: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
2702: , x_trip_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2703: )
2704: IS

Line 2702: , x_trip_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

2698:
2699: PROCEDURE eliminate_displayonly_fields (
2700: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
2701: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
2702: , x_trip_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2703: )
2704: IS
2705: BEGIN
2706:

Line 2992: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type

2988: -----------------------------------------------------------*/
2989:
2990: PROCEDURE disable_from_list(
2991: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
2992: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
2993: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2994: , x_return_status OUT NOCOPY VARCHAR2
2995: , x_field_name OUT NOCOPY VARCHAR2
2996:

Line 2993: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

2989:
2990: PROCEDURE disable_from_list(
2991: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
2992: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
2993: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
2994: , x_return_status OUT NOCOPY VARCHAR2
2995: , x_field_name OUT NOCOPY VARCHAR2
2996:
2997: ) IS

Line 3158: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type

3154: -----------------------------------------------------------*/
3155:
3156: PROCEDURE enable_from_list(
3157: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
3158: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
3159: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3160: , x_return_status OUT NOCOPY VARCHAR2
3161: , x_field_name OUT NOCOPY VARCHAR2
3162:

Line 3159: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

3155:
3156: PROCEDURE enable_from_list(
3157: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
3158: , p_in_rec IN WSH_TRIPS_PVT.trip_rec_type
3159: , x_out_rec IN OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3160: , x_return_status OUT NOCOPY VARCHAR2
3161: , x_field_name OUT NOCOPY VARCHAR2
3162:
3163: ) IS

Line 3462: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type

3458: -- Overloaded procedure
3459: -- Bug 2678363: Added new parameter p_in_rec, in place of p_action
3460: --
3461: PROCEDURE Get_Disabled_List (
3462: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
3463: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
3464: , x_return_status OUT NOCOPY VARCHAR2
3465: , x_msg_count OUT NOCOPY NUMBER
3466: , x_msg_data OUT NOCOPY VARCHAR2

Line 3467: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

3463: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
3464: , x_return_status OUT NOCOPY VARCHAR2
3465: , x_msg_count OUT NOCOPY NUMBER
3466: , x_msg_data OUT NOCOPY VARCHAR2
3467: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3468: )
3469: IS
3470: l_disabled_list WSH_UTIL_CORE.column_tab_type;
3471: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;

Line 3471: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;

3467: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
3468: )
3469: IS
3470: l_disabled_list WSH_UTIL_CORE.column_tab_type;
3471: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;
3472: l_return_status VARCHAR2(30);
3473: l_field_name VARCHAR2(100);
3474: l_debug_on BOOLEAN;
3475: l_module_name CONSTANT VARCHAR2(100) :=

Line 3561: WSH_TRIPS_PVT.populate_record(

3557: END IF;
3558: END IF;
3559: --
3560:
3561: WSH_TRIPS_PVT.populate_record(
3562: p_trip_id => p_trip_rec.trip_id,
3563: x_trip_info => x_trip_rec,
3564: x_return_status => x_return_status);
3565:

Line 4160: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trips_pvt.get_name(l_exceptions_tab(exp_cnt).entity_id));

4156: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
4157: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4158: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
4159: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
4160: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trips_pvt.get_name(l_exceptions_tab(exp_cnt).entity_id));
4161: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4162: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4163: wsh_util_core.add_message(x_return_status);
4164: l_num_warnings := l_num_warnings + 1;

Line 4453: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trips_pvt.get_name(l_exceptions_tab(exp_cnt).entity_id));

4449: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
4450: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4451: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
4452: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
4453: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trips_pvt.get_name(l_exceptions_tab(exp_cnt).entity_id));
4454: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4455: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4456: wsh_util_core.add_message(x_return_status);
4457: l_num_warnings := l_num_warnings + 1;

Line 5040: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,

5036: -- J-IB-NPARIKH-}
5037: --
5038: --3509004:public api change
5039: PROCEDURE user_non_updatable_columns
5040: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
5041: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
5042: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
5043: x_return_status OUT NOCOPY VARCHAR2)
5044:

Line 5041: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,

5037: --
5038: --3509004:public api change
5039: PROCEDURE user_non_updatable_columns
5040: (p_user_in_rec IN WSH_TRIPS_PVT.trip_rec_type,
5041: p_out_rec IN WSH_TRIPS_PVT.trip_rec_type,
5042: p_in_rec IN WSH_TRIPS_GRP.TripInRecType,
5043: x_return_status OUT NOCOPY VARCHAR2)
5044:
5045: IS

Line 6031: WSH_TRIPS_PVT.get_name(p_trip_id));

6027: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_TRIP');
6028: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
6029: WSH_NEW_DELIVERIES_PVT.get_name(l_del_to_unassign(i)));
6030: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
6031: WSH_TRIPS_PVT.get_name(p_trip_id));
6032: l_num_warn := l_num_warn + 1;
6033: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
6034:
6035: i := l_del_to_unassign.next(i);