eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRIP_STOPS_ACTIONS dependencies on FND_MESSAGE

Line 259: FND_MESSAGE.SET_NAME('WSH','WSH_EXP_COMPL_SCRN_REQD');

255: ELSE -- If exceptions exist
256: -- Bug 3402366, inform user stop will not be closed due to ITM exception
257: -- on delivery.
258:
259: FND_MESSAGE.SET_NAME('WSH','WSH_EXP_COMPL_SCRN_REQD');
260: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
261: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS);
262:
263: END IF;

Line 260: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);

256: -- Bug 3402366, inform user stop will not be closed due to ITM exception
257: -- on delivery.
258:
259: FND_MESSAGE.SET_NAME('WSH','WSH_EXP_COMPL_SCRN_REQD');
260: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
261: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS);
262:
263: END IF;
264: END IF;

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

366: FETCH stop_info INTO l_trip_id, l_status_code;
367: CLOSE stop_info;
368:
369: IF (l_trip_id IS NULL) THEN
370: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
371: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
372: wsh_util_core.add_message(x_return_status);
373: --
374: -- Debug Statements

Line 384: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UPDATE_SAME_TRIP');

380: RETURN;
381: END IF;
382:
383: IF (l_trip_id = l_old_trip_id) THEN
384: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UPDATE_SAME_TRIP');
385: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
386: wsh_util_core.add_message(x_return_status);
387: --
388: -- Debug Statements

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

394: RETURN;
395: END IF;
396:
397: IF (l_status_code = 'CL') THEN
398: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_STATUS');
399: --
400: -- Debug Statements
401: --
402: IF l_debug_on THEN

Line 406: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_rows(i),p_caller));

402: IF l_debug_on THEN
403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
404: END IF;
405: --
406: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_rows(i),p_caller));
407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
408: wsh_util_core.add_message(x_return_status);
409: --
410: -- Debug Statements

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

426: CLOSE stop_dropoffs;
427:
428: IF (l_del_id IS NOT NULL ) THEN
429:
430: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PREV_NOT_CLOSED');
431: --
432: -- Debug Statements
433: --
434: IF l_debug_on THEN

Line 438: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_rows(i),p_caller));

434: IF l_debug_on THEN
435: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
436: END IF;
437: --
438: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_rows(i),p_caller));
439: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
440: wsh_util_core.add_message(x_return_status);
441: --
442: -- Debug Statements

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

452: FETCH stop_pickups INTO l_trip_stop_num;
453:
454: IF (stop_pickups%FOUND) THEN
455:
456: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_OP_PA_ERROR');
457: --
458: -- Debug Statements
459: --
460: IF l_debug_on THEN

Line 464: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_rows(i),p_caller));

460: IF l_debug_on THEN
461: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
462: END IF;
463: --
464: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_rows(i),p_caller));
465: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
466: wsh_util_core.add_message(x_return_status);
467:
468: END IF;

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

730: RETURNING stop_id BULK COLLECT INTO l_stop_tab; -- Added for DBI Project;
731:
732: --
733: IF (SQL%NOTFOUND) THEN
734: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
735: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
736: l_num_errors := l_num_errors + 1;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;

Line 817: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_ERROR');

813: ROLLBACK to stop_chg_status_sp;
814: --
815: IF p_action = 'CLOSE'
816: THEN
817: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_ERROR');
818: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_out_rec.stop_name);
819: ELSIF p_action = 'ARRIVE'
820: THEN
821: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_ARRIVE_ERROR');

Line 818: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_out_rec.stop_name);

814: --
815: IF p_action = 'CLOSE'
816: THEN
817: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_ERROR');
818: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_out_rec.stop_name);
819: ELSIF p_action = 'ARRIVE'
820: THEN
821: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_ARRIVE_ERROR');
822: --

Line 821: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_ARRIVE_ERROR');

817: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_ERROR');
818: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_out_rec.stop_name);
819: ELSIF p_action = 'ARRIVE'
820: THEN
821: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_ARRIVE_ERROR');
822: --
823: IF l_debug_on THEN
824: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
825: END IF;

Line 827: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(p_stop_rows(i),p_caller));

823: IF l_debug_on THEN
824: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
825: END IF;
826: --
827: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(p_stop_rows(i),p_caller));
828: END IF;
829: --
830: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
831: --}

Line 839: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_ERROR');

835: ROLLBACK to stop_chg_status_sp;
836: --
837: IF p_action = 'CLOSE'
838: THEN
839: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_ERROR');
840: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_out_rec.stop_name);
841: END IF;
842: --
843: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

Line 840: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_out_rec.stop_name);

836: --
837: IF p_action = 'CLOSE'
838: THEN
839: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_ERROR');
840: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_out_rec.stop_name);
841: END IF;
842: --
843: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
844: --}

Line 879: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_SUMMARY');

875: IF ( p_stop_rows.count > 1 AND l_stopsProcessed <> p_stop_rows.count) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
876: THEN
877: --{
878: IF (p_action = 'CLOSE') THEN
879: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_SUMMARY');
880: ELSE
881: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_ARRIVE_SUMMARY');
882: END IF;
883: --

Line 881: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_ARRIVE_SUMMARY');

877: --{
878: IF (p_action = 'CLOSE') THEN
879: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_SUMMARY');
880: ELSE
881: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_ARRIVE_SUMMARY');
882: END IF;
883: --
884: --
885: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_errors);

Line 885: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_errors);

881: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_ARRIVE_SUMMARY');
882: END IF;
883: --
884: --
885: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_errors);
886: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',l_stopsProcessed);
887: --
888: --
889: IF (p_action = 'CLOSE') THEN

Line 886: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',l_stopsProcessed);

882: END IF;
883: --
884: --
885: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_errors);
886: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',l_stopsProcessed);
887: --
888: --
889: IF (p_action = 'CLOSE') THEN
890: FND_MESSAGE.SET_TOKEN('NUMBER_WARN_ERROR',l_stopsNotProcessedWarnings);

Line 890: FND_MESSAGE.SET_TOKEN('NUMBER_WARN_ERROR',l_stopsNotProcessedWarnings);

886: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',l_stopsProcessed);
887: --
888: --
889: IF (p_action = 'CLOSE') THEN
890: FND_MESSAGE.SET_TOKEN('NUMBER_WARN_ERROR',l_stopsNotProcessedWarnings);
891: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_stopsProcessedWarnings);
892: ELSE
893: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_stopsProcessedWarnings+l_stopsNotProcessedWarnings);
894: END IF;

Line 891: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_stopsProcessedWarnings);

887: --
888: --
889: IF (p_action = 'CLOSE') THEN
890: FND_MESSAGE.SET_TOKEN('NUMBER_WARN_ERROR',l_stopsNotProcessedWarnings);
891: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_stopsProcessedWarnings);
892: ELSE
893: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_stopsProcessedWarnings+l_stopsNotProcessedWarnings);
894: END IF;
895: --

Line 893: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_stopsProcessedWarnings+l_stopsNotProcessedWarnings);

889: IF (p_action = 'CLOSE') THEN
890: FND_MESSAGE.SET_TOKEN('NUMBER_WARN_ERROR',l_stopsNotProcessedWarnings);
891: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_stopsProcessedWarnings);
892: ELSE
893: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_stopsProcessedWarnings+l_stopsNotProcessedWarnings);
894: END IF;
895: --
896: wsh_util_core.add_message(l_return_status,l_module_name);
897: --}

Line 1055: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PLAN_ERROR');

1051:
1052: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1053:
1054: IF (p_action = 'PLAN') THEN
1055: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PLAN_ERROR');
1056: ELSE
1057: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_ERROR');
1058: END IF;
1059:

Line 1057: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_ERROR');

1053:
1054: IF (p_action = 'PLAN') THEN
1055: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PLAN_ERROR');
1056: ELSE
1057: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_ERROR');
1058: END IF;
1059:
1060: --
1061: -- Debug Statements

Line 1067: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_rows(i),p_caller));

1063: IF l_debug_on THEN
1064: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1065: END IF;
1066: --
1067: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_rows(i),p_caller));
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1069: wsh_util_core.add_message(x_return_status);
1070: l_num_error := l_num_error + 1;
1071:

Line 1083: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PLAN_SUMMARY');

1079:
1080: IF (l_num_error > 0) OR (l_num_warn > 0) THEN
1081:
1082: IF (p_action = 'PLAN') THEN
1083: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PLAN_SUMMARY');
1084: ELSE
1085: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_SUMMARY');
1086: END IF;
1087:

Line 1085: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_SUMMARY');

1081:
1082: IF (p_action = 'PLAN') THEN
1083: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PLAN_SUMMARY');
1084: ELSE
1085: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_SUMMARY');
1086: END IF;
1087:
1088: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
1089: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);

Line 1088: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);

1084: ELSE
1085: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_SUMMARY');
1086: END IF;
1087:
1088: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
1089: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
1090: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_stop_rows.count - l_num_error - l_num_warn);
1091: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1092: /*

Line 1089: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);

1085: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_SUMMARY');
1086: END IF;
1087:
1088: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
1089: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
1090: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_stop_rows.count - l_num_error - l_num_warn);
1091: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1092: /*
1093: IF (p_stop_rows.count = l_num_error) THEN

Line 1090: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_stop_rows.count - l_num_error - l_num_warn);

1086: END IF;
1087:
1088: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
1089: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
1090: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_stop_rows.count - l_num_error - l_num_warn);
1091: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1092: /*
1093: IF (p_stop_rows.count = l_num_error) THEN
1094: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1116: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PLAN_ERROR');

1112: --
1113: EXCEPTION
1114: WHEN invalid_stop then
1115: IF (p_action = 'PLAN') THEN
1116: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PLAN_ERROR');
1117: ELSE
1118: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_ERROR');
1119: END IF;
1120:

Line 1118: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_ERROR');

1114: WHEN invalid_stop then
1115: IF (p_action = 'PLAN') THEN
1116: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_PLAN_ERROR');
1117: ELSE
1118: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_ERROR');
1119: END IF;
1120:
1121: FND_MESSAGE.SET_TOKEN('STOP_NAME',l_stop_id);
1122: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1121: FND_MESSAGE.SET_TOKEN('STOP_NAME',l_stop_id);

1117: ELSE
1118: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UNPLAN_ERROR');
1119: END IF;
1120:
1121: FND_MESSAGE.SET_TOKEN('STOP_NAME',l_stop_id);
1122: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1123: wsh_util_core.add_message(x_return_status);
1124: --
1125: -- Debug Statements

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

1198: END IF;
1199:
1200: IF (p_stop_rows.count = 0) THEN
1201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1202: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1203: wsh_util_core.add_message(x_return_status);
1204: ELSE
1205:
1206: FOR i IN 1..p_stop_rows.count LOOP

Line 1799: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_DEL_SUMMARY');

1795: x_num_warnings => l_num_warnings,
1796: x_num_errors => l_num_errors
1797: );
1798: --
1799: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_DEL_SUMMARY');
1800: FND_MESSAGE.SET_TOKEN('STOP_NAME', p_in_rec1.stop_name);
1801: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_cnt);
1802: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_err_cnt+p_in_rec1.initial_pu_err_dlvy_id_tbl.COUNT);
1803: l_num_warnings := l_num_warnings + 1;

Line 1800: FND_MESSAGE.SET_TOKEN('STOP_NAME', p_in_rec1.stop_name);

1796: x_num_errors => l_num_errors
1797: );
1798: --
1799: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_DEL_SUMMARY');
1800: FND_MESSAGE.SET_TOKEN('STOP_NAME', p_in_rec1.stop_name);
1801: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_cnt);
1802: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_err_cnt+p_in_rec1.initial_pu_err_dlvy_id_tbl.COUNT);
1803: l_num_warnings := l_num_warnings + 1;
1804: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);

Line 1801: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_cnt);

1797: );
1798: --
1799: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_DEL_SUMMARY');
1800: FND_MESSAGE.SET_TOKEN('STOP_NAME', p_in_rec1.stop_name);
1801: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_cnt);
1802: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_err_cnt+p_in_rec1.initial_pu_err_dlvy_id_tbl.COUNT);
1803: l_num_warnings := l_num_warnings + 1;
1804: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
1805: --}

Line 1802: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_err_cnt+p_in_rec1.initial_pu_err_dlvy_id_tbl.COUNT);

1798: --
1799: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_DEL_SUMMARY');
1800: FND_MESSAGE.SET_TOKEN('STOP_NAME', p_in_rec1.stop_name);
1801: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS', l_cnt);
1802: FND_MESSAGE.SET_TOKEN('NUM_ERROR', l_err_cnt+p_in_rec1.initial_pu_err_dlvy_id_tbl.COUNT);
1803: l_num_warnings := l_num_warnings + 1;
1804: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
1805: --}
1806: END IF;

Line 1894: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');

1890: --
1891:
1892: IF (SQL%NOTFOUND)
1893: THEN
1894: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');
1895: FND_MESSAGE.SET_TOKEN('STOP_ID',p_in_rec.stop_id);
1896: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
1897: RAISE FND_API.G_EXC_ERROR;
1898: END IF;

Line 1895: FND_MESSAGE.SET_TOKEN('STOP_ID',p_in_rec.stop_id);

1891:
1892: IF (SQL%NOTFOUND)
1893: THEN
1894: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');
1895: FND_MESSAGE.SET_TOKEN('STOP_ID',p_in_rec.stop_id);
1896: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
1897: RAISE FND_API.G_EXC_ERROR;
1898: END IF;
1899: --

Line 2092: FND_MESSAGE.SET_NAME('WSH','WSH_PRICE_CNSLD_UNEXP_ERROR');

2088: x_msg_data => l_msg_data);
2089: --
2090: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2091: THEN
2092: FND_MESSAGE.SET_NAME('WSH','WSH_PRICE_CNSLD_UNEXP_ERROR');
2093: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));
2094: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2095: RAISE FND_API.G_EXC_ERROR;
2096: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

Line 2093: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));

2089: --
2090: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2091: THEN
2092: FND_MESSAGE.SET_NAME('WSH','WSH_PRICE_CNSLD_UNEXP_ERROR');
2093: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));
2094: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2095: RAISE FND_API.G_EXC_ERROR;
2096: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2097: -- Bug 3278059, treat warning from rate_trip as success

Line 2102: FND_MESSAGE.SET_NAME('WSH','WSH_PRICE_CNSLD_ERROR');

2098: THEN
2099: --{
2100: l_num_warnings := l_num_warnings + 1;
2101: --
2102: FND_MESSAGE.SET_NAME('WSH','WSH_PRICE_CNSLD_ERROR');
2103: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));
2104: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
2105: --}
2106: END IF;

Line 2103: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));

2099: --{
2100: l_num_warnings := l_num_warnings + 1;
2101: --
2102: FND_MESSAGE.SET_NAME('WSH','WSH_PRICE_CNSLD_ERROR');
2103: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));
2104: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
2105: --}
2106: END IF;
2107: --}

Line 2151: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CONFIRM_ERROR');

2147: ELSE
2148: l_num_errors := l_num_errors + 1;
2149: END IF;
2150: --
2151: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CONFIRM_ERROR');
2152: FND_MESSAGE.SET_TOKEN('STOP_NAME',p_in_rec1.stop_name);
2153: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_in_rec1.trip_name);
2154: wsh_util_core.add_message(l_return_status,l_module_name);
2155: --}

Line 2152: FND_MESSAGE.SET_TOKEN('STOP_NAME',p_in_rec1.stop_name);

2148: l_num_errors := l_num_errors + 1;
2149: END IF;
2150: --
2151: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CONFIRM_ERROR');
2152: FND_MESSAGE.SET_TOKEN('STOP_NAME',p_in_rec1.stop_name);
2153: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_in_rec1.trip_name);
2154: wsh_util_core.add_message(l_return_status,l_module_name);
2155: --}
2156: END IF;

Line 2153: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_in_rec1.trip_name);

2149: END IF;
2150: --
2151: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CONFIRM_ERROR');
2152: FND_MESSAGE.SET_TOKEN('STOP_NAME',p_in_rec1.stop_name);
2153: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_in_rec1.trip_name);
2154: wsh_util_core.add_message(l_return_status,l_module_name);
2155: --}
2156: END IF;
2157: --}

Line 2496: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');

2492:
2493: --
2494: IF (SQL%NOTFOUND)
2495: THEN
2496: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');
2497: FND_MESSAGE.SET_TOKEN('STOP_ID',p_in_rec.stop_id);
2498: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2499: RAISE FND_API.G_EXC_ERROR;
2500: END IF;

Line 2497: FND_MESSAGE.SET_TOKEN('STOP_ID',p_in_rec.stop_id);

2493: --
2494: IF (SQL%NOTFOUND)
2495: THEN
2496: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');
2497: FND_MESSAGE.SET_TOKEN('STOP_ID',p_in_rec.stop_id);
2498: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2499: RAISE FND_API.G_EXC_ERROR;
2500: END IF;
2501: --

Line 2874: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_OPEN_MESSAGE');

2870: THEN
2871: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2872: ELSE
2873: --{
2874: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_OPEN_MESSAGE');
2875: FND_MESSAGE.SET_TOKEN('STOP_NAME',p_in_rec1.stop_name);
2876: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_in_rec1.trip_name);
2877: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS,l_module_name);
2878: --

Line 2875: FND_MESSAGE.SET_TOKEN('STOP_NAME',p_in_rec1.stop_name);

2871: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2872: ELSE
2873: --{
2874: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_OPEN_MESSAGE');
2875: FND_MESSAGE.SET_TOKEN('STOP_NAME',p_in_rec1.stop_name);
2876: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_in_rec1.trip_name);
2877: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS,l_module_name);
2878: --
2879: IF l_num_warnings > 0

Line 2876: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_in_rec1.trip_name);

2872: ELSE
2873: --{
2874: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_OPEN_MESSAGE');
2875: FND_MESSAGE.SET_TOKEN('STOP_NAME',p_in_rec1.stop_name);
2876: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_in_rec1.trip_name);
2877: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_SUCCESS,l_module_name);
2878: --
2879: IF l_num_warnings > 0
2880: THEN

Line 3129: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_LOCK_FAILED');

3125: close get_all_open_stops;
3126: END IF;
3127:
3128: IF l_locking_stops = 'N' THEN
3129: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_LOCK_FAILED');
3130: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(l_trip_id_tmp));
3131: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3132: IF l_debug_on THEN
3133: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock trip ID '||to_char(l_trip_id_tmp));

Line 3130: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(l_trip_id_tmp));

3126: END IF;
3127:
3128: IF l_locking_stops = 'N' THEN
3129: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_LOCK_FAILED');
3130: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',to_char(l_trip_id_tmp));
3131: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3132: IF l_debug_on THEN
3133: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock trip ID '||to_char(l_trip_id_tmp));
3134: WSH_DEBUG_SV.POP(l_module_name, 'EXCEPTION:RECORD_LOCKED');

Line 3137: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_LOCK');

3133: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock trip ID '||to_char(l_trip_id_tmp));
3134: WSH_DEBUG_SV.POP(l_module_name, 'EXCEPTION:RECORD_LOCKED');
3135: END IF;
3136: ELSE
3137: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_LOCK');
3138: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3139: IF l_debug_on THEN
3140: WSH_DEBUG_SV.log(l_module_name, 'ERROR: Failed to lock trip stops belong to trip l_trip_id_tmp' );
3141: WSH_DEBUG_SV.POP(l_module_name, 'EXCEPTION:RECORD_LOCKED');