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_TRIPS_ACTIONS dependencies on FND_MESSAGE

Line 167: fnd_message.set_name('WSH','WSH_TRIP_NO_STOPS');

163: open get_pickup_stop (p_trip_id);
164: fetch get_pickup_stop into l_stop_id, l_stop_location_id;
165: if get_pickup_stop%notfound then
166: close get_pickup_stop;
167: fnd_message.set_name('WSH','WSH_TRIP_NO_STOPS');
168: fnd_message.set_token('TRIP_NAME',p_trip_name);
169: x_return_status := wsh_util_core.g_ret_sts_error;
170: raise e_trip_confirm_exception;
171: else

Line 168: fnd_message.set_token('TRIP_NAME',p_trip_name);

164: fetch get_pickup_stop into l_stop_id, l_stop_location_id;
165: if get_pickup_stop%notfound then
166: close get_pickup_stop;
167: fnd_message.set_name('WSH','WSH_TRIP_NO_STOPS');
168: fnd_message.set_token('TRIP_NAME',p_trip_name);
169: x_return_status := wsh_util_core.g_ret_sts_error;
170: raise e_trip_confirm_exception;
171: else
172: fetch get_pickup_stop into l_stop_id, l_stop_location_id;

Line 175: fnd_message.set_name('WSH','WSH_TRIP_MULTIPLE_PICKUPS');

171: else
172: fetch get_pickup_stop into l_stop_id, l_stop_location_id;
173: if get_pickup_stop%found then
174: close get_pickup_stop;
175: fnd_message.set_name('WSH','WSH_TRIP_MULTIPLE_PICKUPS');
176: l_stop_location_code := fnd_message.get;
177: x_def_rec.trip_multiple_pickup := 'Y';
178: else
179: close get_pickup_stop;

Line 176: l_stop_location_code := fnd_message.get;

172: fetch get_pickup_stop into l_stop_id, l_stop_location_id;
173: if get_pickup_stop%found then
174: close get_pickup_stop;
175: fnd_message.set_name('WSH','WSH_TRIP_MULTIPLE_PICKUPS');
176: l_stop_location_code := fnd_message.get;
177: x_def_rec.trip_multiple_pickup := 'Y';
178: else
179: close get_pickup_stop;
180: l_stop_location_code := wsh_util_core.get_location_description(l_stop_location_id, 'NEW UI CODE');

Line 186: fnd_message.set_name('WSH','WSH_TRIP_CONFIRM_MISSING_DEL');

182: open get_pickup_delivery(l_stop_id, l_stop_location_id);
183: fetch get_pickup_delivery into l_exists;
184: if get_pickup_delivery%notfound then
185: close get_pickup_delivery;
186: fnd_message.set_name('WSH','WSH_TRIP_CONFIRM_MISSING_DEL');
187: fnd_message.set_token('TRIP',p_trip_name);
188: fnd_message.set_token('STOP_NAME',l_stop_location_code);
189: x_return_status := wsh_util_core.g_ret_sts_error;
190: raise e_trip_confirm_exception;

Line 187: fnd_message.set_token('TRIP',p_trip_name);

183: fetch get_pickup_delivery into l_exists;
184: if get_pickup_delivery%notfound then
185: close get_pickup_delivery;
186: fnd_message.set_name('WSH','WSH_TRIP_CONFIRM_MISSING_DEL');
187: fnd_message.set_token('TRIP',p_trip_name);
188: fnd_message.set_token('STOP_NAME',l_stop_location_code);
189: x_return_status := wsh_util_core.g_ret_sts_error;
190: raise e_trip_confirm_exception;
191: else

Line 188: fnd_message.set_token('STOP_NAME',l_stop_location_code);

184: if get_pickup_delivery%notfound then
185: close get_pickup_delivery;
186: fnd_message.set_name('WSH','WSH_TRIP_CONFIRM_MISSING_DEL');
187: fnd_message.set_token('TRIP',p_trip_name);
188: fnd_message.set_token('STOP_NAME',l_stop_location_code);
189: x_return_status := wsh_util_core.g_ret_sts_error;
190: raise e_trip_confirm_exception;
191: else
192: close get_pickup_delivery;

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

430: END IF;
431: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
432: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
433: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
434: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
435: ELSE
436: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
437: END IF;
438: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');

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

432: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
433: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
434: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
435: ELSE
436: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
437: END IF;
438: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
439: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
440: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');

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

434: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
435: ELSE
436: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
437: END IF;
438: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
439: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
440: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
442: wsh_util_core.add_message(x_return_status);

Line 439: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);

435: ELSE
436: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
437: END IF;
438: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
439: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
440: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
442: wsh_util_core.add_message(x_return_status);
443: raise check_exceptions;

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

436: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
437: END IF;
438: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
439: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
440: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
442: wsh_util_core.add_message(x_return_status);
443: raise check_exceptions;
444: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN

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

442: wsh_util_core.add_message(x_return_status);
443: raise check_exceptions;
444: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
445: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
446: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
447: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
448: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
449: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
450: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

443: raise check_exceptions;
444: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
445: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
446: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
447: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
448: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
449: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
450: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
451: wsh_util_core.add_message(x_return_status);

Line 448: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);

444: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
445: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
446: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
447: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
448: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
449: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
450: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
451: wsh_util_core.add_message(x_return_status);
452: ELSIF NOT (l_exp_logged) THEN

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

445: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
446: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
447: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
448: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
449: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
450: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
451: wsh_util_core.add_message(x_return_status);
452: ELSIF NOT (l_exp_logged) THEN
453: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');

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

449: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
450: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
451: wsh_util_core.add_message(x_return_status);
452: ELSIF NOT (l_exp_logged) THEN
453: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
454: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
455: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
456: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
457: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

450: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
451: wsh_util_core.add_message(x_return_status);
452: ELSIF NOT (l_exp_logged) THEN
453: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
454: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
455: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
456: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
457: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
458: l_exp_logged := TRUE;

Line 455: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);

451: wsh_util_core.add_message(x_return_status);
452: ELSIF NOT (l_exp_logged) THEN
453: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
454: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
455: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
456: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
457: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
458: l_exp_logged := TRUE;
459: wsh_util_core.add_message(x_return_status);

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

452: ELSIF NOT (l_exp_logged) THEN
453: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
454: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
455: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
456: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
457: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
458: l_exp_logged := TRUE;
459: wsh_util_core.add_message(x_return_status);
460: END IF;

Line 602: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CONFIRM_WARNING');

598:
599:
600: -- Bug 3374306
601: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
602: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CONFIRM_WARNING');
603: wsh_util_core.add_message(x_return_status);
604: END IF;
605:
606: --Bug# 2867209 - Start

Line 612: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CHANGE_ACTION');

608: WSH_DEBUG_SV.log(l_module_name,'l_is_action_not_performed',l_is_action_not_performed);
609: END IF;
610:
611: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND P_CLOSE_FLAG = 'N' AND l_is_action_not_performed THEN
612: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CHANGE_ACTION');
613: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING);
614: END IF;
615: --Bug# 2867209 - End
616: --

Line 650: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CONFIRM_ERROR');

646: IF l_debug_on THEN
647: WSH_DEBUG_SV.logmsg(l_module_name,'trip_confirm_error exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
648: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:trip_confirm_error');
649: END IF;
650: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CONFIRM_ERROR');
651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
652: wsh_util_core.add_message(x_return_status);
653: --
654: WHEN check_exceptions THEN

Line 833: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_PLAN_ERROR');

829:
830: <>
831:
832: IF (p_action = 'PLAN') THEN
833: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_PLAN_ERROR');
834: ELSIF (p_action='FIRM') THEN
835: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_FIRM_ERROR');
836: ELSE
837: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');

Line 835: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_FIRM_ERROR');

831:
832: IF (p_action = 'PLAN') THEN
833: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_PLAN_ERROR');
834: ELSIF (p_action='FIRM') THEN
835: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_FIRM_ERROR');
836: ELSE
837: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');
838: END IF;
839:

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

833: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_PLAN_ERROR');
834: ELSIF (p_action='FIRM') THEN
835: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_FIRM_ERROR');
836: ELSE
837: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');
838: END IF;
839:
840: --
841: -- Debug Statements

Line 847: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));

843: IF l_debug_on THEN
844: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
845: END IF;
846: --
847: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
848: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
849: wsh_util_core.add_message(x_return_status);
850: l_num_error := l_num_error + 1;
851:

Line 862: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_PLAN_SUMMARY');

858:
859: IF (l_num_error > 0) OR (l_num_warn > 0) THEN
860:
861: IF (p_action = 'PLAN') THEN
862: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_PLAN_SUMMARY');
863: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
864: ELSIF (p_action = 'FIRM') THEN
865: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_FIRM_SUMMARY');
866: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);

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

859: IF (l_num_error > 0) OR (l_num_warn > 0) THEN
860:
861: IF (p_action = 'PLAN') THEN
862: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_PLAN_SUMMARY');
863: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
864: ELSIF (p_action = 'FIRM') THEN
865: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_FIRM_SUMMARY');
866: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
867: ELSE

Line 865: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_FIRM_SUMMARY');

861: IF (p_action = 'PLAN') THEN
862: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_PLAN_SUMMARY');
863: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
864: ELSIF (p_action = 'FIRM') THEN
865: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_FIRM_SUMMARY');
866: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
867: ELSE
868: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_UNPLAN_SUMMARY');
869: END IF;

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

862: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_PLAN_SUMMARY');
863: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
864: ELSIF (p_action = 'FIRM') THEN
865: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_FIRM_SUMMARY');
866: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
867: ELSE
868: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_UNPLAN_SUMMARY');
869: END IF;
870:

Line 868: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_UNPLAN_SUMMARY');

864: ELSIF (p_action = 'FIRM') THEN
865: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_FIRM_SUMMARY');
866: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
867: ELSE
868: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_UNPLAN_SUMMARY');
869: END IF;
870:
871: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
872: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);

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

867: ELSE
868: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_UNPLAN_SUMMARY');
869: END IF;
870:
871: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
872: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);
873:
874: IF (p_trip_rows.count = l_num_error) THEN
875: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 872: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);

868: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_UNPLAN_SUMMARY');
869: END IF;
870:
871: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
872: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);
873:
874: IF (p_trip_rows.count = l_num_error) THEN
875: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
876: ELSE

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

990: END IF;
991: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
992: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
993: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
994: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
995: ELSE
996: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
997: END IF;
998: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');

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

992: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN
993: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
994: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
995: ELSE
996: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
997: END IF;
998: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
999: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1000: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');

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

994: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
995: ELSE
996: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
997: END IF;
998: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
999: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1000: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
1001: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1002: wsh_util_core.add_message(x_return_status);

Line 999: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);

995: ELSE
996: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
997: END IF;
998: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
999: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1000: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
1001: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1002: wsh_util_core.add_message(x_return_status);
1003: raise check_exceptions;

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

996: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
997: END IF;
998: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
999: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1000: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
1001: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1002: wsh_util_core.add_message(x_return_status);
1003: raise check_exceptions;
1004: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN

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

1002: wsh_util_core.add_message(x_return_status);
1003: raise check_exceptions;
1004: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
1005: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
1006: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
1007: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
1008: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1009: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

1003: raise check_exceptions;
1004: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
1005: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
1006: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
1007: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
1008: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1009: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1011: wsh_util_core.add_message(x_return_status);

Line 1008: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);

1004: ELSIF l_exceptions_tab(exp_cnt).exception_behavior = 'WARNING' THEN
1005: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
1006: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
1007: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
1008: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1009: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1011: wsh_util_core.add_message(x_return_status);
1012: ELSIF NOT (l_exp_logged) THEN

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

1005: IF l_exceptions_tab(exp_cnt).entity_name = 'TRIP' THEN
1006: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
1007: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
1008: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1009: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1011: wsh_util_core.add_message(x_return_status);
1012: ELSIF NOT (l_exp_logged) THEN
1013: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');

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

1009: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1011: wsh_util_core.add_message(x_return_status);
1012: ELSIF NOT (l_exp_logged) THEN
1013: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
1014: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
1015: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1016: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
1017: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1011: wsh_util_core.add_message(x_return_status);
1012: ELSIF NOT (l_exp_logged) THEN
1013: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
1014: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
1015: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1016: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
1017: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1018: l_exp_logged := TRUE;

Line 1015: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);

1011: wsh_util_core.add_message(x_return_status);
1012: ELSIF NOT (l_exp_logged) THEN
1013: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
1014: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
1015: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1016: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
1017: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1018: l_exp_logged := TRUE;
1019: wsh_util_core.add_message(x_return_status);

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

1012: ELSIF NOT (l_exp_logged) THEN
1013: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
1014: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Trip');
1015: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_exceptions_tab(exp_cnt).entity_id);
1016: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
1017: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1018: l_exp_logged := TRUE;
1019: wsh_util_core.add_message(x_return_status);
1020: END IF;

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

1258: --{
1259: --
1260: -- Invalid status for trip, raise error.
1261: --
1262: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');
1263: FND_MESSAGE.SET_TOKEN('TRIP_NAME','p_in_rec.name');
1264: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1265: RAISE FND_API.G_EXC_ERROR;
1266: --}

Line 1263: FND_MESSAGE.SET_TOKEN('TRIP_NAME','p_in_rec.name');

1259: --
1260: -- Invalid status for trip, raise error.
1261: --
1262: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');
1263: FND_MESSAGE.SET_TOKEN('TRIP_NAME','p_in_rec.name');
1264: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1265: RAISE FND_API.G_EXC_ERROR;
1266: --}
1267: END IF;

Line 1661: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_TRIP_NAME');

1657: --
1658: --
1659: IF p_rec_attr_tab(l_index).trip_id IS NULL
1660: THEN
1661: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_TRIP_NAME');
1662: ELSE
1663: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_PICKUP_ERROR');
1664: --FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name,p_rec_attr_tab(l_index).trip_id));
1665: FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name, wsh_trips_pvt.get_name( p_rec_attr_tab(l_index).trip_id)));

Line 1663: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_PICKUP_ERROR');

1659: IF p_rec_attr_tab(l_index).trip_id IS NULL
1660: THEN
1661: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_TRIP_NAME');
1662: ELSE
1663: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_PICKUP_ERROR');
1664: --FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name,p_rec_attr_tab(l_index).trip_id));
1665: FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name, wsh_trips_pvt.get_name( p_rec_attr_tab(l_index).trip_id)));
1666: END IF;
1667: --

Line 1664: --FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name,p_rec_attr_tab(l_index).trip_id));

1660: THEN
1661: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_TRIP_NAME');
1662: ELSE
1663: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_PICKUP_ERROR');
1664: --FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name,p_rec_attr_tab(l_index).trip_id));
1665: FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name, wsh_trips_pvt.get_name( p_rec_attr_tab(l_index).trip_id)));
1666: END IF;
1667: --
1668: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning,l_module_name);

Line 1665: FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name, wsh_trips_pvt.get_name( p_rec_attr_tab(l_index).trip_id)));

1661: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_TRIP_NAME');
1662: ELSE
1663: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_PICKUP_ERROR');
1664: --FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name,p_rec_attr_tab(l_index).trip_id));
1665: FND_MESSAGE.SET_TOKEN('TRIP_NAME',NVL(l_trip_name, wsh_trips_pvt.get_name( p_rec_attr_tab(l_index).trip_id)));
1666: END IF;
1667: --
1668: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning,l_module_name);
1669: l_num_warnings := NVL(l_num_warnings,0) + 1;

Line 2393: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CR_TRIP_SUMMARY');

2389: -- as oppose to showing multiple error messages
2390: -- The process will continue, as the message will come up as a Information Note
2391: -- Only filtered deliveries will be considered for further processing
2392: IF l_count_error > 0 THEN
2393: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CR_TRIP_SUMMARY');
2394: IF l_count_error = p_del_rows.count THEN
2395: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2396: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2397: x_return_status := l_return_status;

Line 2636: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_AU_TRIP_ASSIGN_DEL');

2632: -- been created as part of the rating module.
2633: --
2634: IF (p_entity = 'D') THEN
2635: --{
2636: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_AU_TRIP_ASSIGN_DEL');
2637: FND_MESSAGE.SET_TOKEN('DEL_NAME',
2638: wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
2639: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2640: l_num_skipped := l_num_skipped + 1;

Line 2637: FND_MESSAGE.SET_TOKEN('DEL_NAME',

2633: --
2634: IF (p_entity = 'D') THEN
2635: --{
2636: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_AU_TRIP_ASSIGN_DEL');
2637: FND_MESSAGE.SET_TOKEN('DEL_NAME',
2638: wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
2639: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2640: l_num_skipped := l_num_skipped + 1;
2641: --}

Line 2663: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CR_TRIP');

2659: END IF;
2660:
2661: IF l_gc3_is_installed = 'Y' AND l_ignore_for_planning = 'N' THEN--{
2662: -- Raise a new generic error message here, just trip creation will not happen.
2663: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CR_TRIP');
2664: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2665: ----- skip this delivery, handled towards the end
2666: l_num_skipped := l_num_skipped + 1;
2667: l_count_error := l_count_error + 1;

Line 2687: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DATES_MISSING');

2683:
2684: IF (l_initial_pickup_date is NULL or l_ultimate_dropoff_date is NULL)
2685: AND nvl(l_shipment_direction,'O') IN ('O', 'IO') THEN--{
2686: --
2687: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DATES_MISSING');
2688: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
2689: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2690: l_num_skipped := l_num_skipped + 1;
2691: --

Line 2688: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

2684: IF (l_initial_pickup_date is NULL or l_ultimate_dropoff_date is NULL)
2685: AND nvl(l_shipment_direction,'O') IN ('O', 'IO') THEN--{
2686: --
2687: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DATES_MISSING');
2688: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
2689: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2690: l_num_skipped := l_num_skipped + 1;
2691: --
2692: ELSE

Line 2741: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CR_TRIP_SUMMARY');

2737: -- Only filtered deliveries will be considered for further processing
2738: -- l_num_skipped is used towards the end to determine the return status out of this
2739: -- API - Error or Warning
2740: IF l_count_error > 0 THEN
2741: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CR_TRIP_SUMMARY');
2742: IF l_count_error = p_del_rows.count THEN
2743: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2744: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2745: IF l_debug_on THEN

Line 3075: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_TRIP_WARN');

3071: END IF;
3072: --
3073: -- TO DO: Add message for successful completion of action
3074: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3075: FND_MESSAGE.SET_NAME('WSH', 'WSH_AUTOCREATE_TRIP_WARN');
3076: wsh_util_core.add_message(x_return_status);
3077: END IF;
3078: --
3079: IF l_debug_on THEN

Line 3264: fnd_message.set_name('WSH', 'WSH_COMP_ACT_FAIL');

3260: -- if one one delivery fails for auto create trip, all the lines should
3261: -- should be unassigned from the deliveries and the action should
3262: -- fail for all the lines. (pack J 2862777)
3263: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3264: fnd_message.set_name('WSH', 'WSH_COMP_ACT_FAIL');
3265: wsh_util_core.add_message(x_return_status);
3266: IF l_debug_on THEN--{
3267: WSH_DEBUG_SV.pop(l_module_name);
3268: END IF;--}

Line 3560: fnd_message.set_name('WSH', 'WSH_COMP_ACT_FAIL');

3556: -- if one one delivery fails for auto create trip, all the lines should
3557: -- should be unassigned from the deliveries and the action should
3558: -- fail for all the lines. (pack J 2862777)
3559: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3560: fnd_message.set_name('WSH', 'WSH_COMP_ACT_FAIL');
3561: wsh_util_core.add_message(x_return_status);
3562: IF l_debug_on THEN--{
3563: WSH_DEBUG_SV.pop(l_module_name);
3564: END IF;--}

Line 3803: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');

3799: EXCEPTION
3800:
3801: -- deliveryMerge
3802: WHEN Adjust_Planned_Flag_Err THEN
3803: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');
3804: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
3805: x_return_status := l_return_status;
3806:
3807: IF l_debug_on THEN--{

Line 3931: fnd_message.set_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');

3927: --
3928: EXCEPTION
3929: WHEN reprice_required_err THEN
3930: x_return_status := l_return_status;
3931: fnd_message.set_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
3932: wsh_util_core.add_message(x_return_status);
3933: --
3934: -- Debug Statements
3935: --

Line 4035: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_LOCATIONS_SAME');

4031: --
4032: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4033:
4034: IF (p_pickup_location_id = p_dropoff_location_id) THEN
4035: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_LOCATIONS_SAME');
4036: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4037: wsh_util_core.add_message(x_return_status);
4038: --
4039: -- Debug Statements

Line 4064: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTIPLE_LEGS');

4060: CLOSE pickup_leg_check;
4061:
4062: IF (l_delivery_leg_id IS NOT NULL) THEN
4063:
4064: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTIPLE_LEGS');
4065: --
4066: -- Debug Statements
4067: --
4068: IF l_debug_on THEN

Line 4072: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

4068: IF l_debug_on THEN
4069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4070: END IF;
4071: --
4072: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
4073: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4074: wsh_util_core.add_message(x_return_status);
4075: warn_flag := TRUE;
4076:

Line 4097: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTIPLE_LEGS');

4093: CLOSE dropoff_leg_check;
4094:
4095: IF (l_delivery_leg_id IS NOT NULL) THEN
4096:
4097: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTIPLE_LEGS');
4098: --
4099: -- Debug Statements
4100: --
4101: IF l_debug_on THEN

Line 4105: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

4101: IF l_debug_on THEN
4102: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4103: END IF;
4104: --
4105: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
4106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4107: wsh_util_core.add_message(x_return_status);
4108: warn_flag := TRUE;
4109:

Line 4512: FND_MESSAGE.SET_NAME('WSH','WSH_CANNOT_USE_DUMMY_PICKUP');

4508: END IF;
4509:
4510: ELSE--caller is WSH
4511: x_return_status:=WSH_UTIL_CORE.G_RET_STS_ERROR;
4512: FND_MESSAGE.SET_NAME('WSH','WSH_CANNOT_USE_DUMMY_PICKUP');
4513: IF l_debug_on THEN
4514: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.get_location_description',WSH_DEBUG_SV.C_PROC_LEVEL);
4515: END IF;
4516: FND_MESSAGE.SET_TOKEN('STOP_NAME',SUBSTR(WSH_UTIL_CORE.get_location_description(l_phys_trip_pickup_loc_id, 'NEW UI CODE'),1,60));

Line 4516: FND_MESSAGE.SET_TOKEN('STOP_NAME',SUBSTR(WSH_UTIL_CORE.get_location_description(l_phys_trip_pickup_loc_id, 'NEW UI CODE'),1,60));

4512: FND_MESSAGE.SET_NAME('WSH','WSH_CANNOT_USE_DUMMY_PICKUP');
4513: IF l_debug_on THEN
4514: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.get_location_description',WSH_DEBUG_SV.C_PROC_LEVEL);
4515: END IF;
4516: FND_MESSAGE.SET_TOKEN('STOP_NAME',SUBSTR(WSH_UTIL_CORE.get_location_description(l_phys_trip_pickup_loc_id, 'NEW UI CODE'),1,60));
4517: wsh_util_core.add_message(x_return_status,l_module_name);
4518: IF l_debug_on THEN
4519: WSH_DEBUG_SV.pop(l_module_name);
4520: END IF;

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

4724: WHEN bad_trip_stop THEN
4725: IF get_stop_location%isopen THEN
4726: close get_stop_location;
4727: END IF;
4728: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
4729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4730: wsh_util_core.add_message(x_return_status);
4731: --
4732: -- Debug Statements

Line 4886: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_PLANNED_DATE');

4882: ((p_pickup_dep_date = p_dropoff_arr_date) AND
4883: (p_pickup_arr_date >= p_dropoff_arr_date)
4884: )
4885: )THEN
4886: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_PLANNED_DATE');
4887: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(p_pickup_dep_date));
4888: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(p_dropoff_arr_date));
4889: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4890: wsh_util_core.add_message(x_return_status);

Line 4887: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(p_pickup_dep_date));

4883: (p_pickup_arr_date >= p_dropoff_arr_date)
4884: )
4885: )THEN
4886: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_PLANNED_DATE');
4887: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(p_pickup_dep_date));
4888: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(p_dropoff_arr_date));
4889: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4890: wsh_util_core.add_message(x_return_status);
4891: --

Line 4888: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(p_dropoff_arr_date));

4884: )
4885: )THEN
4886: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_PLANNED_DATE');
4887: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(p_pickup_dep_date));
4888: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(p_dropoff_arr_date));
4889: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4890: wsh_util_core.add_message(x_return_status);
4891: --
4892: -- Debug Statements

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

5139: END IF;
5140: --
5141: EXCEPTION
5142: WHEN stop_not_found THEN
5143: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
5144: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5145: wsh_util_core.add_message(x_return_status);
5146: --
5147: -- Debug Statements

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

5301: l_trip_volume_uom,
5302: l_trip_org_id;
5303: IF (trip_info%NOTFOUND) THEN
5304: CLOSE trip_info;
5305: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
5306: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5307: wsh_util_core.add_message(x_return_status);
5308: END IF;
5309: CLOSE trip_info;

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

5604: OPEN trip_info (p_trip_rows(i));
5605: FETCH trip_info INTO l_trip_max_weight, l_trip_max_volume, l_trip_min_fill, l_trip_weight_uom, l_trip_volume_uom, l_trip_org_id;
5606: IF (trip_info%NOTFOUND) THEN
5607: CLOSE trip_info;
5608: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
5609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5610: wsh_util_core.add_message(x_return_status);
5611: goto wt_vol_error;
5612: END IF;

Line 5625: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_ORG_FILLBASIS_NULL');

5621: FETCH org_info INTO l_fill_basis;
5622:
5623: IF (org_info%NOTFOUND) THEN
5624: --Start of Bug 2415809
5625: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_ORG_FILLBASIS_NULL');
5626: --
5627: -- Debug Statements
5628: --
5629: IF l_debug_on THEN

Line 5633: FND_MESSAGE.SET_TOKEN('l_vehicle_org', WSH_UTIL_CORE.Get_Org_Name(l_vehicle_org_id));

5629: IF l_debug_on THEN
5630: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5631: END IF;
5632: --
5633: FND_MESSAGE.SET_TOKEN('l_vehicle_org', WSH_UTIL_CORE.Get_Org_Name(l_vehicle_org_id));
5634: --End of Bug 2415809
5635: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5636: wsh_util_core.add_message(x_return_status);
5637: l_trip_num_warn:=l_trip_num_warn+1;

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

5650: IF p_suppress_errors = 'Y' THEN
5651: goto loop_end;
5652: END IF;
5653: -- end bug 2366163
5654: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_STOPS');
5655: --
5656: -- Debug Statements
5657: --
5658: IF l_debug_on THEN

Line 5662: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));

5658: IF l_debug_on THEN
5659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5660: END IF;
5661: --
5662: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5663: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5664: wsh_util_core.add_message(x_return_status);
5665: goto wt_vol_error;
5666: END IF;

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

5674: IF p_suppress_errors = 'Y' THEN
5675: goto loop_end;
5676: END IF;
5677: -- end bug 2366163
5678: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_STOPS');
5679: --
5680: -- Debug Statements
5681: --
5682: IF l_debug_on THEN

Line 5686: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));

5682: IF l_debug_on THEN
5683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5684: END IF;
5685: --
5686: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5687: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5688: wsh_util_core.add_message(x_return_status);
5689: goto wt_vol_error;
5690: END IF;

Line 5715: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UOM_NULL');

5711: IF (wsh_util_core.fte_is_installed <> 'Y') THEN
5712: goto loop_end;
5713: END IF;
5714:
5715: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UOM_NULL');
5716: --
5717: -- Debug Statements
5718: --
5719: IF l_debug_on THEN

Line 5723: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_start_stop_id,p_caller));

5719: IF l_debug_on THEN
5720: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5721: END IF;
5722: --
5723: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_start_stop_id,p_caller));
5724: -- bug 2732503 , need a warning message only when FTE is installed
5725: -- still will go to wt_vol_error
5726: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5727: wsh_util_core.add_message(x_return_status);

Line 5784: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UOM_NULL');

5780: IF (wsh_util_core.fte_is_installed <> 'Y') THEN
5781: goto loop_end;
5782: END IF;
5783:
5784: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UOM_NULL');
5785: --
5786: -- Debug Statements
5787: --
5788: IF l_debug_on THEN

Line 5792: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));

5788: IF l_debug_on THEN
5789: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5790: END IF;
5791: --
5792: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));
5793: -- bug 2732503 , need a warning message only when FTE is installed
5794: -- still will go to wt_vol_error
5795: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5796: wsh_util_core.add_message(x_return_status);

Line 5858: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_FAILED');

5854: x_return_status => l_return_status);
5855:
5856: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
5857: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5858: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_FAILED');
5859: --
5860: -- Debug Statements
5861: --
5862: IF l_debug_on THEN

Line 5866: FND_MESSAGE.SET_TOKEN('del_name',wsh_new_deliveries_pvt.get_name(pkup_dl.d_id));

5862: IF l_debug_on THEN
5863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5864: END IF;
5865: --
5866: FND_MESSAGE.SET_TOKEN('del_name',wsh_new_deliveries_pvt.get_name(pkup_dl.d_id));
5867: g_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5868: wsh_util_core.add_message(g_return_status);
5869: END IF;
5870:

Line 6074: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_FILL_PC_EXCEEDED');

6070: l_stop_fill_percent := NULL;
6071: END IF;
6072:
6073: IF (l_stop_fill_percent < l_trip_min_fill) OR (l_stop_fill_percent > 100) THEN
6074: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_FILL_PC_EXCEEDED');
6075: --
6076: -- Debug Statements
6077: --
6078: IF l_debug_on THEN

Line 6082: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));

6078: IF l_debug_on THEN
6079: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6080: END IF;
6081: --
6082: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));
6083: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6084: wsh_util_core.add_message(x_return_status);
6085: l_stop_num_warn := l_stop_num_warn + 1;
6086: END IF;

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

6159: drop_off_volume = l_total_drop_off_volume
6160: WHERE stop_id = l_stop_id;
6161:
6162: IF (SQL%NOTFOUND) THEN
6163: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
6164: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6165: wsh_util_core.add_message(x_return_status);
6166: goto wt_vol_error;
6167: END IF;

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

6176: departure_fill_percent = l_stop_fill_percent,
6177: wv_frozen_flag = 'N'
6178: WHERE stop_id = l_stop_id;
6179: IF (SQL%NOTFOUND) THEN
6180: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
6181: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6182: wsh_util_core.add_message(x_return_status);
6183: goto wt_vol_error;
6184: END IF;

Line 6228: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERROR');

6224: goto loop_end;
6225:
6226: <>
6227:
6228: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERROR');
6229: --
6230: -- Debug Statements
6231: --
6232: IF l_debug_on THEN

Line 6236: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));

6232: IF l_debug_on THEN
6233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6234: END IF;
6235: --
6236: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
6237: wsh_util_core.add_message(x_return_status);
6238: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6239: l_num_error := l_num_error + 1;
6240: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 6266: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');

6262: END IF;
6263: IF (l_num_error > 0) OR (l_num_warn > 0) THEN
6264: -- Bug 3688384 Display separate message for one trip .
6265: IF (p_trip_rows.count = 1) and (l_num_error = 0) and (l_num_warn > 0) THEN
6266: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6267: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6268: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6269: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6270: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));

Line 6267: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));

6263: IF (l_num_error > 0) OR (l_num_warn > 0) THEN
6264: -- Bug 3688384 Display separate message for one trip .
6265: IF (p_trip_rows.count = 1) and (l_num_error = 0) and (l_num_warn > 0) THEN
6266: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6267: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6268: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6269: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6270: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6271: ELSIF (p_trip_rows.count > 1) then

Line 6269: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');

6265: IF (p_trip_rows.count = 1) and (l_num_error = 0) and (l_num_warn > 0) THEN
6266: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6267: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6268: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6269: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6270: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6271: ELSIF (p_trip_rows.count > 1) then
6272: -- Bug 3688384 .
6273: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');

Line 6270: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));

6266: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6267: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6268: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6269: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6270: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6271: ELSIF (p_trip_rows.count > 1) then
6272: -- Bug 3688384 .
6273: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6274: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);

Line 6273: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');

6269: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6270: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6271: ELSIF (p_trip_rows.count > 1) then
6272: -- Bug 3688384 .
6273: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6274: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
6275: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6276: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);
6277: END IF;

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

6270: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6271: ELSIF (p_trip_rows.count > 1) then
6272: -- Bug 3688384 .
6273: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6274: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
6275: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6276: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);
6277: END IF;
6278: IF (p_trip_rows.count = l_num_error) THEN

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

6271: ELSIF (p_trip_rows.count > 1) then
6272: -- Bug 3688384 .
6273: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6274: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
6275: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6276: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);
6277: END IF;
6278: IF (p_trip_rows.count = l_num_error) THEN
6279: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 6276: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);

6272: -- Bug 3688384 .
6273: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6274: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
6275: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6276: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);
6277: END IF;
6278: IF (p_trip_rows.count = l_num_error) THEN
6279: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6280: ELSE

Line 6402: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_SEQUENCE_INVALID');

6398: END IF;
6399: --
6400: EXCEPTION
6401: WHEN invalid_sequence THEN
6402: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_SEQUENCE_INVALID');
6403: --
6404: -- Debug Statements
6405: --
6406: IF l_debug_on THEN

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

6406: IF l_debug_on THEN
6407: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6408: END IF;
6409: --
6410: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
6411: wsh_util_core.add_message(x_return_status);
6412: --
6413: -- Debug Statements
6414: --

Line 6506: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTI_UNASSIGN_ERROR');

6502:
6503: CLOSE deltrip_cv;
6504:
6505: IF (cnt = 1) THEN -- cnt := cnt + 1 before we exit loop above, so cnt is always > 0, bug 2434673.
6506: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTI_UNASSIGN_ERROR');
6507: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6508: wsh_util_core.add_message(x_return_status);
6509: END IF;
6510:

Line 6700: fnd_message.set_name('WSH', 'WSH_TRIP_NOT_FOUND');

6696: EXCEPTION
6697:
6698: WHEN trip_not_found THEN
6699: x_return_status := l_return_status;
6700: fnd_message.set_name('WSH', 'WSH_TRIP_NOT_FOUND');
6701: wsh_util_core.add_message(x_return_status);
6702:
6703: --
6704: -- Debug Statements

Line 6713: fnd_message.set_name('WSH', 'WSH_DEL_UNASSIGN_ERROR');

6709: END IF;
6710: --
6711: WHEN unassign_deliveries_err THEN
6712: x_return_status := l_return_status;
6713: fnd_message.set_name('WSH', 'WSH_DEL_UNASSIGN_ERROR');
6714: fnd_message.set_token('TRIP_NAME', l_trip_name);
6715: wsh_util_core.add_message(x_return_status);
6716:
6717: --

Line 6714: fnd_message.set_token('TRIP_NAME', l_trip_name);

6710: --
6711: WHEN unassign_deliveries_err THEN
6712: x_return_status := l_return_status;
6713: fnd_message.set_name('WSH', 'WSH_DEL_UNASSIGN_ERROR');
6714: fnd_message.set_token('TRIP_NAME', l_trip_name);
6715: wsh_util_core.add_message(x_return_status);
6716:
6717: --
6718: -- Debug Statements

Line 6727: fnd_message.set_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');

6723: END IF;
6724: --
6725: WHEN reprice_required_err THEN
6726: x_return_status := l_return_status;
6727: fnd_message.set_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
6728: wsh_util_core.add_message(x_return_status);
6729:
6730: --
6731: -- Debug Statements

Line 6740: fnd_message.set_name('WSH', 'WSH_PLANNED_TRIP_NO_ACTION');

6736: END IF;
6737: --
6738: WHEN trip_planned THEN
6739: x_return_status := l_return_status;
6740: fnd_message.set_name('WSH', 'WSH_PLANNED_TRIP_NO_ACTION');
6741: fnd_message.set_token('TRIP_NAME', l_trip_name);
6742: wsh_util_core.add_message(x_return_status);
6743:
6744: --

Line 6741: fnd_message.set_token('TRIP_NAME', l_trip_name);

6737: --
6738: WHEN trip_planned THEN
6739: x_return_status := l_return_status;
6740: fnd_message.set_name('WSH', 'WSH_PLANNED_TRIP_NO_ACTION');
6741: fnd_message.set_token('TRIP_NAME', l_trip_name);
6742: wsh_util_core.add_message(x_return_status);
6743:
6744: --
6745: -- Debug Statements

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

7987:
7988: -- Handle Date Exception
7989: WHEN invalid_stop_date THEN
7990: rollback to start_of_the_trip;
7991: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
7992: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j)));
7993: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
7994: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
7995: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1)));

Line 7992: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j)));

7988: -- Handle Date Exception
7989: WHEN invalid_stop_date THEN
7990: rollback to start_of_the_trip;
7991: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
7992: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j)));
7993: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
7994: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
7995: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1)));
7996: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',

Line 7993: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',

7989: WHEN invalid_stop_date THEN
7990: rollback to start_of_the_trip;
7991: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
7992: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j)));
7993: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
7994: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
7995: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1)));
7996: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
7997: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));

Line 7995: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1)));

7991: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
7992: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j)));
7993: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
7994: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
7995: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1)));
7996: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
7997: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));
7998: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
7999:

Line 7996: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',

7992: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j)));
7993: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
7994: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
7995: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1)));
7996: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
7997: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));
7998: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
7999:
8000: -- Handle SSN Exception

Line 8003: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS_SSN');

7999:
8000: -- Handle SSN Exception
8001: WHEN invalid_stop_seq_num THEN
8002: rollback to start_of_the_trip;
8003: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS_SSN');
8004: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));
8005: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8006: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));

Line 8004: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));

8000: -- Handle SSN Exception
8001: WHEN invalid_stop_seq_num THEN
8002: rollback to start_of_the_trip;
8003: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS_SSN');
8004: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));
8005: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8006: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));
8008: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',

Line 8005: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',

8001: WHEN invalid_stop_seq_num THEN
8002: rollback to start_of_the_trip;
8003: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS_SSN');
8004: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));
8005: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8006: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));
8008: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
8009: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));

Line 8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));

8003: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS_SSN');
8004: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));
8005: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8006: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));
8008: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
8009: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));
8010: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8011:

Line 8008: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',

8004: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));
8005: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8006: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));
8008: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
8009: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));
8010: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8011:
8012: WHEN invalid_ssn_adjustment THEN

Line 8014: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_SSN_ADJUSTMENT');

8010: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8011:
8012: WHEN invalid_ssn_adjustment THEN
8013: rollback to start_of_the_trip;
8014: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_SSN_ADJUSTMENT');
8015: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8016:
8017: -- Handle non unique SSN exception (bug 4245339)
8018: WHEN duplicate_stop_seq THEN

Line 8020: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DUP_SEQUENCE');

8016:
8017: -- Handle non unique SSN exception (bug 4245339)
8018: WHEN duplicate_stop_seq THEN
8019: rollback to start_of_the_trip;
8020: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DUP_SEQUENCE');
8021: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8022:
8023: WHEN reset_stop_seq_number_error THEN
8024: rollback to start_of_the_trip;

Line 8324: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_NO_STOPS');

8320: FETCH c_get_trip_stops BULK COLLECT INTO l_cs_tripstops_tab;
8321: CLOSE c_get_trip_stops;
8322:
8323: IF l_cs_tripstops_tab.COUNT = 0 THEN
8324: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_NO_STOPS');
8325: --FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_id_tab(i));
8326: --FND_MSG_PUB.ADD;
8327: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8328: l_rg_trip := FALSE;

Line 8325: --FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_id_tab(i));

8321: CLOSE c_get_trip_stops;
8322:
8323: IF l_cs_tripstops_tab.COUNT = 0 THEN
8324: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_NO_STOPS');
8325: --FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_id_tab(i));
8326: --FND_MSG_PUB.ADD;
8327: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8328: l_rg_trip := FALSE;
8329: WSH_UTIL_CORE.add_message(x_return_status);

Line 8497: FND_MESSAGE.SET_NAME('WSH','WSH_LOCATION_NO_SITE');

8493: OPEN c_ship_to_site_use(l_ultimate_dropoff_loc_id);
8494: FETCH c_ship_to_site_use INTO l_customer_site_id;
8495: IF c_ship_to_site_use%NOTFOUND THEN
8496: IF l_customer_id IS NOT NULL THEN
8497: FND_MESSAGE.SET_NAME('WSH','WSH_LOCATION_NO_SITE');
8498: --FND_MESSAGE.Set_Token('LOCATION',l_ultimate_dropoff_loc_id);
8499: FND_MESSAGE.Set_Token('TRIPNAME',l_cs_trip_rec.trip_name);
8500: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8501: l_rg_trip := FALSE;

Line 8498: --FND_MESSAGE.Set_Token('LOCATION',l_ultimate_dropoff_loc_id);

8494: FETCH c_ship_to_site_use INTO l_customer_site_id;
8495: IF c_ship_to_site_use%NOTFOUND THEN
8496: IF l_customer_id IS NOT NULL THEN
8497: FND_MESSAGE.SET_NAME('WSH','WSH_LOCATION_NO_SITE');
8498: --FND_MESSAGE.Set_Token('LOCATION',l_ultimate_dropoff_loc_id);
8499: FND_MESSAGE.Set_Token('TRIPNAME',l_cs_trip_rec.trip_name);
8500: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8501: l_rg_trip := FALSE;
8502: ELSE

Line 8499: FND_MESSAGE.Set_Token('TRIPNAME',l_cs_trip_rec.trip_name);

8495: IF c_ship_to_site_use%NOTFOUND THEN
8496: IF l_customer_id IS NOT NULL THEN
8497: FND_MESSAGE.SET_NAME('WSH','WSH_LOCATION_NO_SITE');
8498: --FND_MESSAGE.Set_Token('LOCATION',l_ultimate_dropoff_loc_id);
8499: FND_MESSAGE.Set_Token('TRIPNAME',l_cs_trip_rec.trip_name);
8500: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8501: l_rg_trip := FALSE;
8502: ELSE
8503: l_customer_site_id := NULL;

Line 8617: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_MULTILEG_TRIP');

8613: END IF;
8614:
8615: IF l_trip_result_type = 'MULTILEG' THEN
8616: IF l_trip_id <> l_prev_trip_id THEN
8617: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_MULTILEG_TRIP');
8618: FND_MESSAGE.SET_TOKEN('TRIPID',l_trip_id);
8619: --FND_MSG_PUB.ADD;
8620: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8621: WSH_UTIL_CORE.add_message(x_return_status);

Line 8618: FND_MESSAGE.SET_TOKEN('TRIPID',l_trip_id);

8614:
8615: IF l_trip_result_type = 'MULTILEG' THEN
8616: IF l_trip_id <> l_prev_trip_id THEN
8617: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_MULTILEG_TRIP');
8618: FND_MESSAGE.SET_TOKEN('TRIPID',l_trip_id);
8619: --FND_MSG_PUB.ADD;
8620: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8621: WSH_UTIL_CORE.add_message(x_return_status);
8622: END IF;

Line 8631: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_UPD_TRIP_RANK_LIST');

8627: -- Warning when trip already has an attached ranked list
8628:
8629: --IF l_trip_rank_array(l_trip_id) IS NOT NULL THEN
8630: IF l_trip_rank_array(TO_CHAR(l_trip_id, g_int_mask)) IS NOT NULL THEN
8631: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_UPD_TRIP_RANK_LIST');
8632: FND_MESSAGE.SET_TOKEN('TRIPID',l_trip_id);
8633: --FND_MSG_PUB.ADD;
8634: IF l_debug_on THEN
8635: WSH_DEBUG_SV.logmsg(l_module_name,'Trip already has a ranked list ');

Line 8632: FND_MESSAGE.SET_TOKEN('TRIPID',l_trip_id);

8628:
8629: --IF l_trip_rank_array(l_trip_id) IS NOT NULL THEN
8630: IF l_trip_rank_array(TO_CHAR(l_trip_id, g_int_mask)) IS NOT NULL THEN
8631: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_UPD_TRIP_RANK_LIST');
8632: FND_MESSAGE.SET_TOKEN('TRIPID',l_trip_id);
8633: --FND_MSG_PUB.ADD;
8634: IF l_debug_on THEN
8635: WSH_DEBUG_SV.logmsg(l_module_name,'Trip already has a ranked list ');
8636: END IF;

Line 8767: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_RANKED_RESULT');

8763: IF l_rank_result_cnt = 0 THEN
8764: --
8765: -- All results found are multileg, return an error
8766: --
8767: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_RANKED_RESULT');
8768: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8769: WSH_UTIL_CORE.add_message(x_return_status);
8770: --
8771: -- Debug Statements

Line 8783: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_CARRIER_SELECTED');

8779: ELSE -- l_cs_result_tab.COUNT = 0
8780: --
8781: -- No results at all where found, return a warning
8782: --
8783: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_CARRIER_SELECTED');
8784: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8785: WSH_UTIL_CORE.add_message(x_return_status);
8786: --
8787: -- Debug Statements

Line 8799: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_VALID_TRIPS');

8795: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8796: END IF;
8797: -- TODO
8798: ELSE -- No eligible trips were found
8799: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_VALID_TRIPS');
8800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8801: WSH_UTIL_CORE.add_message(x_return_status);
8802: --
8803: -- Debug Statements

Line 9029: FND_MESSAGE.SET_NAME('WSH','WSH_REMOVE_CONSOL_ERR');

9025: WHEN WSH_INVALID_ACTION THEN
9026: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9027: --
9028: -- Debug Statements
9029: FND_MESSAGE.SET_NAME('WSH','WSH_REMOVE_CONSOL_ERR');
9030: wsh_util_core.add_message(x_return_status);
9031: IF l_debug_on THEN
9032: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ACTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9033: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ACTION');