DBA Data[Home] [Help]

APPS.WSH_TRIP_VALIDATIONS dependencies on FND_MESSAGE

Line 114: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_STOPS');

110: FETCH stops_exist INTO l_numstops;
111: CLOSE stops_exist;
112:
113: IF ( nvl(l_numstops,0) < 2) THEN
114: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_STOPS');
115: --
116: -- Debug Statements
117: --
118: IF l_debug_on THEN

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 140: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

136: FETCH trip_info INTO l_vehicle, l_ship_method, l_mode;
137:
138: IF (trip_info%NOTFOUND) THEN
139: CLOSE trip_info;
140: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
141: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
142: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
143: --
144: -- Debug Statements

Line 158: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_VEHICLE_SH_M_REQ');

154:
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: --

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 173: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_MODE_TR_REQ_VEH');

169: RETURN;
170: END IF;
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));

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 197: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_DELIVERIES');

193: FETCH deliveries_exist INTO l_del_id;
194: CLOSE deliveries_exist;
195:
196: IF (l_del_id IS NULL) THEN
197: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_DELIVERIES');
198: --
199: -- Debug Statements
200: --
201: IF l_debug_on THEN

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 217: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_FILL_PC_MIN');

213: CLOSE vehicle_info;
214:
215: FOR st IN stops_info LOOP
216: IF ((st.departure_fill_percent IS NOT NULL) AND ( l_min_fill IS NOT NULL) AND (st.departure_fill_percent < l_min_fill)) THEN
217: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_FILL_PC_MIN');
218: --
219: -- Debug Statements
220: --
221: IF l_debug_on THEN

Line 226: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(st.stop_id,p_caller));

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));
227: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
228: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
229: ELSIF ((st.departure_fill_percent IS NOT NULL) AND (st.departure_fill_percent > 100)) THEN
230: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_FILL_PC_MAX');

Line 230: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_FILL_PC_MAX');

226: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(st.stop_id,p_caller));
227: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
228: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
229: ELSIF ((st.departure_fill_percent IS NOT NULL) AND (st.departure_fill_percent > 100)) THEN
230: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_FILL_PC_MAX');
231: --
232: -- Debug Statements
233: --
234: IF l_debug_on THEN

Line 239: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(st.stop_id,p_caller));

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));
240: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
241: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
242: END IF;
243: IF ((st.departure_gross_weight IS NOT NULL) AND ( l_max_wt IS NOT NULL) AND (st.departure_gross_weight > l_max_wt)) OR

Line 245: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_MAX_WT_VOL_EXCEEDED');

241: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
242: END IF;
243: IF ((st.departure_gross_weight IS NOT NULL) AND ( l_max_wt IS NOT NULL) AND (st.departure_gross_weight > l_max_wt)) OR
244: ((st.departure_fill_percent IS NOT NULL) AND ( l_max_vol IS NOT NULL) AND (st.departure_volume > l_max_vol)) THEN
245: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_MAX_WT_VOL_EXCEEDED');
246: --
247: -- Debug Statements
248: --
249: IF l_debug_on THEN

Line 254: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(st.stop_id, p_caller));

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));
255: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
256: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
257: END IF;
258:

Line 337: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

333: FETCH trip_info INTO l_status_code, l_planned_flag,l_shipments_type_flag;
334:
335: IF (trip_info%NOTFOUND) THEN
336: CLOSE trip_info;
337: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
338: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
339: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
340: --
341: -- Debug Statements

Line 425: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PREV_NOT_CLOSED');

421:
422: OPEN prev_stop_info;
423: FETCH prev_stop_info INTO l_stop_id;
424: IF (prev_stop_info%FOUND) THEN
425: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PREV_NOT_CLOSED');
426: --
427: -- Debug Statements
428: --
429: IF l_debug_on THEN

Line 433: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(p_stop_id, p_caller));

429: IF l_debug_on THEN
430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
431: END IF;
432: --
433: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(p_stop_id, p_caller));
434: close prev_stop_info;
435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
436: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
437: --

Line 600: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PREV_NOT_CLOSED');

596:
597:
598: IF (prev_stop_rec.status_code <> 'CL') THEN
599: --{
600: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PREV_NOT_CLOSED');
601: --
602: -- Debug Statements
603: --
604: IF l_debug_on THEN

Line 608: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(prev_stop_rec.stop_id));

604: IF l_debug_on THEN
605: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
606: END IF;
607: --
608: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(prev_stop_rec.stop_id));
609: -- Pack J IB: KVENKATE
610: -- Set the return status based on checks of shipment_type_flag
611: -- of current stop and the previous stop
612:

Line 825: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

821: FETCH trip_info INTO l_status_code, l_planned_flag;
822:
823: IF (trip_info%NOTFOUND) THEN
824: CLOSE trip_info;
825: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
826: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
827: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
828: --
829: -- Debug Statements

Line 841: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');

837:
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: --

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 858: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_DELETE_PLAN_TRIP');

854:
855: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
856:
857: IF (l_planned_flag = 'Y') THEN
858: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_DELETE_PLAN_TRIP');
859: --
860: -- Debug Statements
861: --
862: IF l_debug_on THEN

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 870: FND_MESSAGE.SET_NAME('WSH','WSH_DELETE_FIRM_TRIP');

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

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 913: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_DELETE_WITH_FC');

909: l_freight_costs_flag := 'Y';
910: END LOOP;
911:
912: IF (l_freight_costs_flag = 'Y') THEN
913: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_DELETE_WITH_FC');
914: --
915: -- Debug Statements
916: --
917: IF l_debug_on THEN

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 1016: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

1012: FETCH trip_info INTO l_status_code, l_planned_flag;
1013:
1014: IF (trip_info%NOTFOUND) THEN
1015: CLOSE trip_info;
1016: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1017: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1018: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1019: --
1020: -- Debug Statements

Line 1038: FND_MESSAGE.SET_NAME('WSH','Group-by-carrier-set');

1034:
1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1036:
1037: IF (l_cnt IS NOT NULL) THEN
1038: FND_MESSAGE.SET_NAME('WSH','Group-by-carrier-set');
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1040: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1041: END IF;
1042:

Line 1139: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');

1135: FETCH stop_info INTO l_stop_seq_num, l_status_code, l_trip_id, l_shipments_type_flag;
1136:
1137: IF (stop_info%NOTFOUND) THEN
1138: CLOSE stop_info;
1139: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1140: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1141: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1142: --
1143: -- Debug Statements

Line 1155: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_STATUS');

1151:
1152: CLOSE stop_info;
1153:
1154: IF (l_status_code = 'CL') THEN
1155: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_STATUS');
1156: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1157: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1158: --
1159: -- Debug Statements

Line 1273: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');

1269: FETCH stop_info INTO l_stop_date, l_status_code, l_trip_id;
1270:
1271: IF (stop_info%NOTFOUND) THEN
1272: CLOSE stop_info;
1273: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1274: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1275: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1276: --
1277: -- Debug Statements

Line 1297: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_CLOSE_OP_PA_ERROR');

1293: END IF;
1294: CLOSE deliveries_still_open;
1295:
1296: IF l_delivery_id IS NOT NULL THEN
1297: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_CLOSE_OP_PA_ERROR');
1298: --
1299: -- Debug Statements
1300: --
1301: IF l_debug_on THEN

Line 1305: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_id, p_caller));

1301: IF l_debug_on THEN
1302: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1303: END IF;
1304: --
1305: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_id, p_caller));
1306: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1307: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1308: --
1309: -- Debug Statements

Line 1484: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');

1480: FETCH stop_info INTO l_trip_status_code, l_planned_flag, l_stop_status_code, l_trip_id;
1481:
1482: IF (stop_info%NOTFOUND) THEN
1483: CLOSE stop_info;
1484: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1485: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1486: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1487: --
1488: -- Debug Statements

Line 1500: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_STATUS');

1496:
1497: CLOSE stop_info;
1498:
1499: IF (l_stop_status_code <> 'OP') THEN
1500: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_STATUS');
1501: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1502: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1503: --
1504: -- Debug Statements

Line 1514: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');

1510: RETURN;
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: --

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 1529: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_TRIP_PLAN');

1525: RETURN;
1526: END IF;
1527:
1528: IF (l_planned_flag='Y') THEN
1529: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_TRIP_PLAN');
1530: --
1531: -- Debug Statements
1532: --
1533: IF l_debug_on THEN

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 1549: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_TRIP_FIRM');

1545: END IF;
1546: --
1547: RETURN;
1548: ELSIF (l_planned_flag ='F') THEN
1549: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_TRIP_FIRM');
1550: --
1551: -- Debug Statements
1552: --
1553: IF l_debug_on THEN

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 1585: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DELETE_WITH_DELS');

1581:
1582: END IF;
1583:
1584: IF (l_del_flag = 'Y') THEN
1585: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DELETE_WITH_DELS');
1586: --
1587: -- Debug Statements
1588: --
1589: IF l_debug_on THEN

Line 1593: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(p_stop_id, p_caller));

1589: IF l_debug_on THEN
1590: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1591: END IF;
1592: --
1593: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(p_stop_id, p_caller));
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1595: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1596: END IF;
1597:

Line 1605: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DELETE_WITH_FC');

1601: l_freight_costs_flag := 'Y';
1602: END LOOP;
1603:
1604: IF (l_freight_costs_flag = 'Y') THEN
1605: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DELETE_WITH_FC');
1606: --
1607: -- Debug Statements
1608: --
1609: IF l_debug_on THEN

Line 1613: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(p_stop_id,p_caller));

1609: IF l_debug_on THEN
1610: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1611: END IF;
1612: --
1613: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(p_stop_id,p_caller));
1614: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1615: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1616: END IF;
1617:

Line 1909: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');

1905: IF get_trip_status%ISOPEN THEN
1906: CLOSE get_trip_status;
1907: END IF;
1908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1909: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');
1910: FND_MESSAGE.Set_Token('ENTITY_ID',p_trip_id);
1911: wsh_util_core.add_message(x_return_status,l_module_name);
1912: IF l_debug_on THEN
1913: -- Nothing is updateable

Line 1910: FND_MESSAGE.Set_Token('ENTITY_ID',p_trip_id);

1906: CLOSE get_trip_status;
1907: END IF;
1908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1909: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');
1910: FND_MESSAGE.Set_Token('ENTITY_ID',p_trip_id);
1911: wsh_util_core.add_message(x_return_status,l_module_name);
1912: IF l_debug_on THEN
1913: -- Nothing is updateable
1914: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');

Line 1923: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');

1919: -- OTM R12, glog proj
1920: IF get_trip_status%ISOPEN THEN
1921: CLOSE get_trip_status;
1922: END IF;
1923: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
1924: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR);
1925: x_return_status := FND_API.G_RET_STS_ERROR;
1926: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1927: if x_msg_count > 1 then

Line 1947: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');

1943: -- OTM R12, glog proj
1944: IF get_trip_status%ISOPEN THEN
1945: CLOSE get_trip_status;
1946: END IF;
1947: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
1948: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR);
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1951: if x_msg_count > 1 then

Line 1970: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');

1966: IF get_trip_status%ISOPEN THEN
1967: CLOSE get_trip_status;
1968: END IF;
1969:
1970: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1971: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1972:
1973:
1974: --

Line 2057: FND_MESSAGE.Set_Name('WSH','WSH_PLANNED_TRIP');

2053: END IF;
2054: -- new message
2055: -- Stop Sequence Number cannot be updated for a planned trip.
2056: IF l_trip_planned ='Y' THEN
2057: FND_MESSAGE.Set_Name('WSH','WSH_PLANNED_TRIP');
2058: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2059: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2060: --
2061: -- Debug Statements

Line 2069: FND_MESSAGE.Set_Name('WSH','WSH_FIRMED_TRIP');

2065: END IF;
2066: --
2067: RETURN;
2068: ELSIF l_trip_planned = 'F' THEN
2069: FND_MESSAGE.Set_Name('WSH','WSH_FIRMED_TRIP');
2070: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2071: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2072: --
2073: -- Debug Statements

Line 2089: FND_MESSAGE.Set_Name('WSH','WSH_STOP_NOT_FOUND');

2085:
2086: /*
2087: ELSE -- fields are not null
2088: --invalid trip stop information
2089: FND_MESSAGE.Set_Name('WSH','WSH_STOP_NOT_FOUND');
2090: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2091: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2092: --
2093: -- Debug Statements

Line 2270: FND_MESSAGE.SET_NAME('WSH',l_trip_actions_tab(l_loop_counter).message_name);

2266: IF l_trip_actions_tab(l_loop_counter).message_name IS NOT NULL THEN
2267: IF l_debug_on THEN
2268: wsh_debug_sv.log(l_module_name, 'Message Name is', l_trip_actions_tab(l_loop_counter).message_name);
2269: END IF;
2270: FND_MESSAGE.SET_NAME('WSH',l_trip_actions_tab(l_loop_counter).message_name);
2271: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2272: END IF;
2273: RAISE e_set_messages;
2274: END IF;

Line 2333: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_TRIP_LANE');

2329: IF p_trip_rec_tab(j).lane_id IS NOT NULL THEN
2330: IF l_debug_on THEN
2331: wsh_debug_sv.log(l_module_name, 'Trip has lane id : ', p_trip_rec_tab(j).lane_id);
2332: END IF;
2333: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_TRIP_LANE');
2334: FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_rec_tab(j).trip_id);
2335: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2336: RAISE e_set_messages;
2337: END IF;

Line 2334: FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_rec_tab(j).trip_id);

2330: IF l_debug_on THEN
2331: wsh_debug_sv.log(l_module_name, 'Trip has lane id : ', p_trip_rec_tab(j).lane_id);
2332: END IF;
2333: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_TRIP_LANE');
2334: FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_rec_tab(j).trip_id);
2335: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2336: RAISE e_set_messages;
2337: END IF;
2338:

Line 2347: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_TRIP_MOVE');

2343: IF l_move_id <> -1 THEN
2344: IF l_debug_on THEN
2345: wsh_debug_sv.log(l_module_name, 'Trip has continuous move id id : ', l_move_id);
2346: END IF;
2347: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_TRIP_MOVE');
2348: FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_rec_tab(j).trip_id);
2349: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2350: RAISE e_set_messages;
2351:

Line 2348: FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_rec_tab(j).trip_id);

2344: IF l_debug_on THEN
2345: wsh_debug_sv.log(l_module_name, 'Trip has continuous move id id : ', l_move_id);
2346: END IF;
2347: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_TRIP_MOVE');
2348: FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_rec_tab(j).trip_id);
2349: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2350: RAISE e_set_messages;
2351:
2352: END IF;

Line 2364: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_ACTION_INELIGIBLE');

2360: EXCEPTION
2361: WHEN e_set_messages THEN
2362: x_error_ids(x_error_ids.COUNT + 1) := p_trip_rec_tab(j).trip_id;
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);

Line 2365: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('TRIP',p_action));

2361: WHEN e_set_messages THEN
2362: x_error_ids(x_error_ids.COUNT + 1) := p_trip_rec_tab(j).trip_id;
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;

Line 2366: FND_MESSAGE.Set_Token('TRIP_NAME',

2362: x_error_ids(x_error_ids.COUNT + 1) := p_trip_rec_tab(j).trip_id;
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;

Line 2378: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED');

2374: IF (x_valid_ids.COUNT = 0 ) THEN
2375: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2376: --
2377: IF NOT (l_caller = 'WSH_PUB' OR l_caller LIKE 'FTE%') THEN
2378: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED');
2379: wsh_util_core.add_message(x_return_status,l_module_name);
2380: END IF;
2381: --
2382: ELSIF (x_valid_ids.COUNT = p_trip_rec_tab.COUNT) THEN

Line 2388: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED_WARN');

2384: ELSIF (x_valid_ids.COUNT < p_trip_rec_tab.COUNT ) THEN
2385: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2386: --
2387: IF NOT (l_caller = 'WSH_PUB' OR l_caller LIKE 'FTE%') THEN
2388: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED_WARN');
2389: wsh_util_core.add_message(x_return_status,l_module_name);
2390: END IF;
2391: --
2392: ElSE

Line 2396: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED');

2392: ElSE
2393: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2394: --
2395: IF NOT (l_caller = 'WSH_PUB' OR l_caller LIKE 'FTE%') THEN
2396: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED');
2397: wsh_util_core.add_message(x_return_status,l_module_name);
2398: END IF;
2399: --
2400: END IF;

Line 2497: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ARR_AFTER_TRIP');

2493:
2494: END IF;
2495:
2496: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2497: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ARR_AFTER_TRIP');
2498: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
2499: END IF;
2500:
2501: IF l_debug_on THEN

Line 3714: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');

3710: --
3711: EXCEPTION
3712: WHEN e_all_disabled THEN
3713: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3714: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');
3715: FND_MESSAGE.Set_Token('ENTITY_ID',p_trip_rec.trip_id);
3716: wsh_util_core.add_message(x_return_status,l_module_name);
3717: IF l_debug_on THEN
3718: -- Nothing is updateable

Line 3715: FND_MESSAGE.Set_Token('ENTITY_ID',p_trip_rec.trip_id);

3711: EXCEPTION
3712: WHEN e_all_disabled THEN
3713: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3714: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');
3715: FND_MESSAGE.Set_Token('ENTITY_ID',p_trip_rec.trip_id);
3716: wsh_util_core.add_message(x_return_status,l_module_name);
3717: IF l_debug_on THEN
3718: -- Nothing is updateable
3719: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');

Line 3729: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_FIELD_NAME');

3725: WSH_DEBUG_SV.pop(l_module_name,'e_dp_no_entity');
3726: END IF;
3727: WHEN e_bad_field THEN
3728: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3729: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_FIELD_NAME');
3730: FND_MESSAGE.Set_Token('FIELD_NAME',l_field_name);
3731: wsh_util_core.add_message(x_return_status,l_module_name);
3732: IF l_debug_on THEN
3733: WSH_DEBUG_SV.log(l_module_name,'Bad field name passed to the list:'

Line 3730: FND_MESSAGE.Set_Token('FIELD_NAME',l_field_name);

3726: END IF;
3727: WHEN e_bad_field THEN
3728: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3729: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_FIELD_NAME');
3730: FND_MESSAGE.Set_Token('FIELD_NAME',l_field_name);
3731: wsh_util_core.add_message(x_return_status,l_module_name);
3732: IF l_debug_on THEN
3733: WSH_DEBUG_SV.log(l_module_name,'Bad field name passed to the list:'
3734: ,l_field_name);

Line 4121: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');

4117: END IF;
4118: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
4119: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
4120: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4121: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
4122: ELSE
4123: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4124: END IF;
4125:

Line 4123: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');

4119: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
4120: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4121: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
4122: ELSE
4123: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4124: END IF;
4125:
4126: -- BugFix #3947506
4127: WSH_UTIL_CORE.Get_Entity_Name

Line 4140: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506

4136: RAISE FND_API.G_EXC_ERROR;
4137: END IF;
4138: -- End of code BugFix #3947506
4139:
4140: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4141: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4142: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
4143: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4144: wsh_util_core.add_message(x_return_status);

Line 4141: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506

4137: END IF;
4138: -- End of code BugFix #3947506
4139:
4140: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4141: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4142: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
4143: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4144: wsh_util_core.add_message(x_return_status);
4145: l_num_warnings := l_num_warnings + 1;

Line 4142: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');

4138: -- End of code BugFix #3947506
4139:
4140: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4141: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4142: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
4143: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4144: wsh_util_core.add_message(x_return_status);
4145: l_num_warnings := l_num_warnings + 1;
4146:

Line 4155: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');

4151:
4152: RAISE wsh_util_core.e_not_allowed;
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;

Line 4156: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');

4152: RAISE wsh_util_core.e_not_allowed;
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);

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

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;

Line 4158: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');

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;
4162: l_exp_warning := TRUE;

Line 4177: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');

4173: wsh_util_core.add_message(l_out_status);
4174: RAISE FND_API.G_EXC_ERROR;
4175: END IF;
4176: -- End of code BugFix #3947506
4177: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4178: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4179: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4180: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4181: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4178: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506

4174: RAISE FND_API.G_EXC_ERROR;
4175: END IF;
4176: -- End of code BugFix #3947506
4177: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4178: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4179: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4180: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4181: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4182: l_exp_logged := TRUE;

Line 4179: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506

4175: END IF;
4176: -- End of code BugFix #3947506
4177: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4178: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4179: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4180: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4181: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4182: l_exp_logged := TRUE;
4183: wsh_util_core.add_message(x_return_status);

Line 4180: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');

4176: -- End of code BugFix #3947506
4177: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4178: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4179: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4180: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4181: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4182: l_exp_logged := TRUE;
4183: wsh_util_core.add_message(x_return_status);
4184: l_num_warnings := l_num_warnings + 1;

Line 4420: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');

4416: END IF;
4417: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
4418: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
4419: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4420: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
4421: ELSE
4422: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4423: END IF;
4424:

Line 4422: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');

4418: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
4419: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
4420: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
4421: ELSE
4422: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4423: END IF;
4424:
4425: -- BugFix #3947506
4426: WSH_UTIL_CORE.Get_Entity_Name

Line 4439: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506

4435: RAISE FND_API.G_EXC_ERROR;
4436: END IF;
4437: -- End of code BugFix #3947506
4438:
4439: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4440: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4441: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
4442: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4443: wsh_util_core.add_message(x_return_status);

Line 4440: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506

4436: END IF;
4437: -- End of code BugFix #3947506
4438:
4439: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4440: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4441: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
4442: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4443: wsh_util_core.add_message(x_return_status);
4444: l_num_warnings := l_num_warnings + 1;

Line 4441: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');

4437: -- End of code BugFix #3947506
4438:
4439: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4440: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4441: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
4442: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4443: wsh_util_core.add_message(x_return_status);
4444: l_num_warnings := l_num_warnings + 1;
4445: RAISE wsh_util_core.e_not_allowed;

Line 4448: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');

4444: l_num_warnings := l_num_warnings + 1;
4445: RAISE wsh_util_core.e_not_allowed;
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;

Line 4449: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');

4445: RAISE wsh_util_core.e_not_allowed;
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);

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

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;

Line 4451: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');

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;
4455: l_exp_warning := TRUE;

Line 4471: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');

4467: RAISE FND_API.G_EXC_ERROR;
4468: END IF;
4469: -- End of code BugFix #3947506
4470:
4471: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4472: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4473: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4474: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4475: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4472: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506

4468: END IF;
4469: -- End of code BugFix #3947506
4470:
4471: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4472: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4473: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4474: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4475: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4476: l_exp_logged := TRUE;

Line 4473: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506

4469: -- End of code BugFix #3947506
4470:
4471: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4472: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4473: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4474: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4475: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4476: l_exp_logged := TRUE;
4477: wsh_util_core.add_message(x_return_status);

Line 4474: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');

4470:
4471: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
4472: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
4473: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
4474: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
4475: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4476: l_exp_logged := TRUE;
4477: wsh_util_core.add_message(x_return_status);
4478: l_num_warnings := l_num_warnings + 1;

Line 4668: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_STATUS_NO_ACTION');

4664: EXCEPTION
4665: --{
4666: WHEN wsh_util_core.e_not_allowed THEN
4667: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4668: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_STATUS_NO_ACTION');
4669: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_rec.name);
4670: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4671: --
4672: IF l_debug_on THEN

Line 4669: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_rec.name);

4665: --{
4666: WHEN wsh_util_core.e_not_allowed THEN
4667: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4668: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_STATUS_NO_ACTION');
4669: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_rec.name);
4670: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4671: --
4672: IF l_debug_on THEN
4673: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 6024: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_TRIP');

6020: IF l_debug_on THEN
6021: WSH_DEBUG_SV.logmsg(l_module_name,'unassign delivery '|| l_del_to_unassign(i));
6022: END IF;
6023:
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));

Line 6025: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',

6021: WSH_DEBUG_SV.logmsg(l_module_name,'unassign delivery '|| l_del_to_unassign(i));
6022: END IF;
6023:
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;

Line 6027: FND_MESSAGE.SET_TOKEN('TRIP_NAME',

6023:
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:

Line 6077: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_ID_REQUIRED');

6073: EXCEPTION
6074:
6075: WHEN invalid_input THEN
6076: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6077: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_ID_REQUIRED');
6078: wsh_util_core.add_message(x_return_status, l_module_name);
6079: IF l_debug_on THEN
6080: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: Trip ID is NULL');
6081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');

Line 6090: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_DATE_OVERLAP');

6086: close get_invalid_planned_dates;
6087: END IF;
6088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6089: IF l_invalid_planned_date.physical_stop_id is NULL THEN
6090: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_DATE_OVERLAP');
6091: FND_MESSAGE.SET_TOKEN('CURRENT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_dep_date));
6092: FND_MESSAGE.SET_TOKEN('CURRENT_LOCATION_DESP',
6093: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.cur_location_id,'NEW UI CODE INFO'));
6094: FND_MESSAGE.SET_TOKEN('NEXT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));

Line 6091: FND_MESSAGE.SET_TOKEN('CURRENT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_dep_date));

6087: END IF;
6088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6089: IF l_invalid_planned_date.physical_stop_id is NULL THEN
6090: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_DATE_OVERLAP');
6091: FND_MESSAGE.SET_TOKEN('CURRENT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_dep_date));
6092: FND_MESSAGE.SET_TOKEN('CURRENT_LOCATION_DESP',
6093: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.cur_location_id,'NEW UI CODE INFO'));
6094: FND_MESSAGE.SET_TOKEN('NEXT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));
6095: ELSE

Line 6092: FND_MESSAGE.SET_TOKEN('CURRENT_LOCATION_DESP',

6088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6089: IF l_invalid_planned_date.physical_stop_id is NULL THEN
6090: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_DATE_OVERLAP');
6091: FND_MESSAGE.SET_TOKEN('CURRENT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_dep_date));
6092: FND_MESSAGE.SET_TOKEN('CURRENT_LOCATION_DESP',
6093: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.cur_location_id,'NEW UI CODE INFO'));
6094: FND_MESSAGE.SET_TOKEN('NEXT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));
6095: ELSE
6096: -- No stop is allowed between dummy stop and physical stop.

Line 6094: FND_MESSAGE.SET_TOKEN('NEXT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));

6090: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_DATE_OVERLAP');
6091: FND_MESSAGE.SET_TOKEN('CURRENT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_dep_date));
6092: FND_MESSAGE.SET_TOKEN('CURRENT_LOCATION_DESP',
6093: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.cur_location_id,'NEW UI CODE INFO'));
6094: FND_MESSAGE.SET_TOKEN('NEXT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));
6095: ELSE
6096: -- No stop is allowed between dummy stop and physical stop.
6097: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
6098: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_arr_date));

Line 6097: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');

6093: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.cur_location_id,'NEW UI CODE INFO'));
6094: FND_MESSAGE.SET_TOKEN('NEXT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));
6095: ELSE
6096: -- No stop is allowed between dummy stop and physical stop.
6097: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
6098: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_arr_date));
6099: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
6100: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.cur_location_id,'NEW UI CODE INFO'));
6101: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));

Line 6098: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_arr_date));

6094: FND_MESSAGE.SET_TOKEN('NEXT_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));
6095: ELSE
6096: -- No stop is allowed between dummy stop and physical stop.
6097: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
6098: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_arr_date));
6099: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
6100: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.cur_location_id,'NEW UI CODE INFO'));
6101: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));
6102: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',

Line 6099: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',

6095: ELSE
6096: -- No stop is allowed between dummy stop and physical stop.
6097: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
6098: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_arr_date));
6099: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
6100: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.cur_location_id,'NEW UI CODE INFO'));
6101: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));
6102: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
6103: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.nxt_location_id,'NEW UI CODE INFO'));

Line 6101: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));

6097: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
6098: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_arr_date));
6099: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
6100: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.cur_location_id,'NEW UI CODE INFO'));
6101: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));
6102: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
6103: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.nxt_location_id,'NEW UI CODE INFO'));
6104: END IF;
6105: wsh_util_core.add_message(x_return_status, l_module_name);

Line 6102: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',

6098: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.cur_arr_date));
6099: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
6100: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.cur_location_id,'NEW UI CODE INFO'));
6101: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_invalid_planned_date.nxt_arr_date));
6102: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
6103: WSH_UTIL_CORE.Get_Location_Description (l_invalid_planned_date.nxt_location_id,'NEW UI CODE INFO'));
6104: END IF;
6105: wsh_util_core.add_message(x_return_status, l_module_name);
6106:

Line 6115: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_STOP_DATE');

6111: -- Bug 3782135
6112: WHEN invalid_arrival_date THEN
6113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6114:
6115: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_STOP_DATE');
6116: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_invalid_plarrival_date.cur_stop_id,p_caller));
6117: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
6118:
6119: IF l_debug_on THEN

Line 6116: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_invalid_plarrival_date.cur_stop_id,p_caller));

6112: WHEN invalid_arrival_date THEN
6113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6114:
6115: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_STOP_DATE');
6116: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_invalid_plarrival_date.cur_stop_id,p_caller));
6117: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
6118:
6119: IF l_debug_on THEN
6120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_planned_arrival_date');