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 168: fnd_message.set_name('WSH','WSH_TRIP_NO_STOPS');

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

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

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

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

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

Line 177: l_stop_location_code := fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2639: FND_MESSAGE.SET_TOKEN('DEL_NAME',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4889: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(p_pickup_dep_date,calendar_aware=>FND_DATE.calendar_aware_alt));

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

Line 4890: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(p_dropoff_arr_date,calendar_aware=>FND_DATE.calendar_aware_alt));

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

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

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

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

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

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

5610: OPEN trip_info (p_trip_rows(i));
5611: 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;
5612: IF (trip_info%NOTFOUND) THEN
5613: CLOSE trip_info;
5614: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
5615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5616: wsh_util_core.add_message(x_return_status);
5617: goto wt_vol_error;
5618: END IF;

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

5627: FETCH org_info INTO l_fill_basis;
5628:
5629: IF (org_info%NOTFOUND) THEN
5630: --Start of Bug 2415809
5631: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_ORG_FILLBASIS_NULL');
5632: --
5633: -- Debug Statements
5634: --
5635: IF l_debug_on THEN

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

5635: IF l_debug_on THEN
5636: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5637: END IF;
5638: --
5639: FND_MESSAGE.SET_TOKEN('l_vehicle_org', WSH_UTIL_CORE.Get_Org_Name(l_vehicle_org_id));
5640: --End of Bug 2415809
5641: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5642: wsh_util_core.add_message(x_return_status);
5643: l_trip_num_warn:=l_trip_num_warn+1;

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

5656: IF p_suppress_errors = 'Y' THEN
5657: goto loop_end;
5658: END IF;
5659: -- end bug 2366163
5660: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_STOPS');
5661: --
5662: -- Debug Statements
5663: --
5664: IF l_debug_on THEN

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

5664: IF l_debug_on THEN
5665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5666: END IF;
5667: --
5668: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5670: wsh_util_core.add_message(x_return_status);
5671: goto wt_vol_error;
5672: END IF;

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

5680: IF p_suppress_errors = 'Y' THEN
5681: goto loop_end;
5682: END IF;
5683: -- end bug 2366163
5684: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_STOPS');
5685: --
5686: -- Debug Statements
5687: --
5688: IF l_debug_on THEN

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

5688: IF l_debug_on THEN
5689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5690: END IF;
5691: --
5692: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
5693: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5694: wsh_util_core.add_message(x_return_status);
5695: goto wt_vol_error;
5696: END IF;

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

5717: IF (wsh_util_core.fte_is_installed <> 'Y') THEN
5718: goto loop_end;
5719: END IF;
5720:
5721: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UOM_NULL');
5722: --
5723: -- Debug Statements
5724: --
5725: IF l_debug_on THEN

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

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

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

5786: IF (wsh_util_core.fte_is_installed <> 'Y') THEN
5787: goto loop_end;
5788: END IF;
5789:
5790: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_UOM_NULL');
5791: --
5792: -- Debug Statements
5793: --
5794: IF l_debug_on THEN

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

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

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

5860: x_return_status => l_return_status);
5861:
5862: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
5863: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5864: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_FAILED');
5865: --
5866: -- Debug Statements
5867: --
5868: IF l_debug_on THEN

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

5868: IF l_debug_on THEN
5869: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5870: END IF;
5871: --
5872: FND_MESSAGE.SET_TOKEN('del_name',wsh_new_deliveries_pvt.get_name(pkup_dl.d_id));
5873: g_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5874: wsh_util_core.add_message(g_return_status);
5875: END IF;
5876:

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

6081: l_stop_fill_percent := NULL;
6082: END IF;
6083:
6084: IF (l_stop_fill_percent < l_trip_min_fill) OR (l_stop_fill_percent > 100) THEN
6085: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_FILL_PC_EXCEEDED');
6086: --
6087: -- Debug Statements
6088: --
6089: IF l_debug_on THEN

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

6089: IF l_debug_on THEN
6090: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6091: END IF;
6092: --
6093: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));
6094: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6095: wsh_util_core.add_message(x_return_status);
6096: l_stop_num_warn := l_stop_num_warn + 1;
6097: END IF;

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

6170: drop_off_volume = l_total_drop_off_volume
6171: WHERE stop_id = l_stop_id;
6172:
6173: IF (SQL%NOTFOUND) THEN
6174: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
6175: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6176: wsh_util_core.add_message(x_return_status);
6177: goto wt_vol_error;
6178: END IF;

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

6187: departure_fill_percent = l_stop_fill_percent,
6188: wv_frozen_flag = 'N'
6189: WHERE stop_id = l_stop_id;
6190: IF (SQL%NOTFOUND) THEN
6191: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
6192: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6193: wsh_util_core.add_message(x_return_status);
6194: goto wt_vol_error;
6195: END IF;

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

6235: goto loop_end;
6236:
6237: <>
6238:
6239: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERROR');
6240: --
6241: -- Debug Statements
6242: --
6243: IF l_debug_on THEN

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

6243: IF l_debug_on THEN
6244: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6245: END IF;
6246: --
6247: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(i)));
6248: wsh_util_core.add_message(x_return_status);
6249: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6250: l_num_error := l_num_error + 1;
6251: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

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

6273: END IF;
6274: IF (l_num_error > 0) OR (l_num_warn > 0) THEN
6275: -- Bug 3688384 Display separate message for one trip .
6276: IF (p_trip_rows.count = 1) and (l_num_error = 0) and (l_num_warn > 0) THEN
6277: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6278: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6279: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6280: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6281: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));

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

6274: IF (l_num_error > 0) OR (l_num_warn > 0) THEN
6275: -- Bug 3688384 Display separate message for one trip .
6276: IF (p_trip_rows.count = 1) and (l_num_error = 0) and (l_num_warn > 0) THEN
6277: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6278: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6279: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6280: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6281: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6282: ELSIF (p_trip_rows.count > 1) then

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

6276: IF (p_trip_rows.count = 1) and (l_num_error = 0) and (l_num_warn > 0) THEN
6277: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6278: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6279: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6280: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6281: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6282: ELSIF (p_trip_rows.count > 1) then
6283: -- Bug 3688384 .
6284: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');

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

6277: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_WARN');
6278: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6279: ELSIF (p_trip_rows.count = 1) and (l_num_error > 0) THEN
6280: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6281: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6282: ELSIF (p_trip_rows.count > 1) then
6283: -- Bug 3688384 .
6284: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6285: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);

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

6280: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_ERR');
6281: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6282: ELSIF (p_trip_rows.count > 1) then
6283: -- Bug 3688384 .
6284: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6285: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
6286: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6287: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);
6288: END IF;

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

6281: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_rows(1)));
6282: ELSIF (p_trip_rows.count > 1) then
6283: -- Bug 3688384 .
6284: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6285: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
6286: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6287: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);
6288: END IF;
6289: IF (p_trip_rows.count = l_num_error) THEN

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

6282: ELSIF (p_trip_rows.count > 1) then
6283: -- Bug 3688384 .
6284: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6285: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
6286: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6287: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);
6288: END IF;
6289: IF (p_trip_rows.count = l_num_error) THEN
6290: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

6283: -- Bug 3688384 .
6284: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_WT_VOL_SUMMARY');
6285: FND_MESSAGE.SET_TOKEN('NUM_WARN',l_num_warn);
6286: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
6287: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_trip_rows.count - l_num_error - l_num_warn);
6288: END IF;
6289: IF (p_trip_rows.count = l_num_error) THEN
6290: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6291: ELSE

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

6409: END IF;
6410: --
6411: EXCEPTION
6412: WHEN invalid_sequence THEN
6413: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_SEQUENCE_INVALID');
6414: --
6415: -- Debug Statements
6416: --
6417: IF l_debug_on THEN

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

6417: IF l_debug_on THEN
6418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6419: END IF;
6420: --
6421: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
6422: wsh_util_core.add_message(x_return_status);
6423: --
6424: -- Debug Statements
6425: --

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

6513:
6514: CLOSE deltrip_cv;
6515:
6516: IF (cnt = 1) THEN -- cnt := cnt + 1 before we exit loop above, so cnt is always > 0, bug 2434673.
6517: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_MULTI_UNASSIGN_ERROR');
6518: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6519: wsh_util_core.add_message(x_return_status);
6520: END IF;
6521:

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

6707: EXCEPTION
6708:
6709: WHEN trip_not_found THEN
6710: x_return_status := l_return_status;
6711: fnd_message.set_name('WSH', 'WSH_TRIP_NOT_FOUND');
6712: wsh_util_core.add_message(x_return_status);
6713:
6714: --
6715: -- Debug Statements

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

6720: END IF;
6721: --
6722: WHEN unassign_deliveries_err THEN
6723: x_return_status := l_return_status;
6724: fnd_message.set_name('WSH', 'WSH_DEL_UNASSIGN_ERROR');
6725: fnd_message.set_token('TRIP_NAME', l_trip_name);
6726: wsh_util_core.add_message(x_return_status);
6727:
6728: --

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

6721: --
6722: WHEN unassign_deliveries_err THEN
6723: x_return_status := l_return_status;
6724: fnd_message.set_name('WSH', 'WSH_DEL_UNASSIGN_ERROR');
6725: fnd_message.set_token('TRIP_NAME', l_trip_name);
6726: wsh_util_core.add_message(x_return_status);
6727:
6728: --
6729: -- Debug Statements

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

6734: END IF;
6735: --
6736: WHEN reprice_required_err THEN
6737: x_return_status := l_return_status;
6738: fnd_message.set_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
6739: wsh_util_core.add_message(x_return_status);
6740:
6741: --
6742: -- Debug Statements

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

6747: END IF;
6748: --
6749: WHEN trip_planned THEN
6750: x_return_status := l_return_status;
6751: fnd_message.set_name('WSH', 'WSH_PLANNED_TRIP_NO_ACTION');
6752: fnd_message.set_token('TRIP_NAME', l_trip_name);
6753: wsh_util_core.add_message(x_return_status);
6754:
6755: --

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

6748: --
6749: WHEN trip_planned THEN
6750: x_return_status := l_return_status;
6751: fnd_message.set_name('WSH', 'WSH_PLANNED_TRIP_NO_ACTION');
6752: fnd_message.set_token('TRIP_NAME', l_trip_name);
6753: wsh_util_core.add_message(x_return_status);
6754:
6755: --
6756: -- Debug Statements

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

7998:
7999: -- Handle Date Exception
8000: WHEN invalid_stop_date THEN
8001: rollback to start_of_the_trip;
8002: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
8003: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j),calendar_aware=>FND_DATE.calendar_aware_alt));
8004: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8005: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8006: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1),calendar_aware=>FND_DATE.calendar_aware_alt));

Line 8003: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j),calendar_aware=>FND_DATE.calendar_aware_alt));

7999: -- Handle Date Exception
8000: WHEN invalid_stop_date THEN
8001: rollback to start_of_the_trip;
8002: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
8003: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j),calendar_aware=>FND_DATE.calendar_aware_alt));
8004: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8005: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8006: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1),calendar_aware=>FND_DATE.calendar_aware_alt));
8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',

Line 8004: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',

8000: WHEN invalid_stop_date THEN
8001: rollback to start_of_the_trip;
8002: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
8003: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j),calendar_aware=>FND_DATE.calendar_aware_alt));
8004: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8005: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8006: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1),calendar_aware=>FND_DATE.calendar_aware_alt));
8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
8008: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));

Line 8006: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1),calendar_aware=>FND_DATE.calendar_aware_alt));

8002: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS');
8003: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j),calendar_aware=>FND_DATE.calendar_aware_alt));
8004: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8005: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8006: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1),calendar_aware=>FND_DATE.calendar_aware_alt));
8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
8008: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));
8009: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8010:

Line 8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',

8003: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j),calendar_aware=>FND_DATE.calendar_aware_alt));
8004: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8005: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8006: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_DATE', fnd_date.date_to_displaydt(l_getstops_pl_arr_date(j+1),calendar_aware=>FND_DATE.calendar_aware_alt));
8007: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
8008: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));
8009: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8010:
8011: -- Handle SSN Exception

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

8010:
8011: -- Handle SSN Exception
8012: WHEN invalid_stop_seq_num THEN
8013: rollback to start_of_the_trip;
8014: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS_SSN');
8015: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));
8016: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8017: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8018: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));

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

8011: -- Handle SSN Exception
8012: WHEN invalid_stop_seq_num THEN
8013: rollback to start_of_the_trip;
8014: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS_SSN');
8015: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));
8016: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8017: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8018: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));
8019: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',

Line 8016: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',

8012: WHEN invalid_stop_seq_num THEN
8013: rollback to start_of_the_trip;
8014: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS_SSN');
8015: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));
8016: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8017: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8018: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));
8019: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
8020: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));

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

8014: FND_MESSAGE.SET_NAME('WSH', 'WSH_BETWEEN_LINKED_STOPS_SSN');
8015: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));
8016: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8017: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8018: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));
8019: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
8020: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));
8021: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8022:

Line 8019: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',

8015: FND_MESSAGE.SET_TOKEN('DUMMY_STOP_SEQ_NUM', l_getstops_stop_seq_num(j));
8016: FND_MESSAGE.SET_TOKEN('DUMMY_LOCATION_DESP',
8017: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j),'NEW UI CODE INFO'));
8018: FND_MESSAGE.SET_TOKEN('PHYSICAL_STOP_SEQ_NUM', l_getstops_stop_seq_num(j+1));
8019: FND_MESSAGE.SET_TOKEN('PHYSICAL_LOCATION_DESP',
8020: WSH_UTIL_CORE.Get_Location_Description (l_getstops_stop_loc_id(j+1),'NEW UI CODE INFO'));
8021: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8022:
8023: WHEN invalid_ssn_adjustment THEN

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

8021: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8022:
8023: WHEN invalid_ssn_adjustment THEN
8024: rollback to start_of_the_trip;
8025: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_SSN_ADJUSTMENT');
8026: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8027:
8028: -- Handle non unique SSN exception (bug 4245339)
8029: WHEN duplicate_stop_seq THEN

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

8027:
8028: -- Handle non unique SSN exception (bug 4245339)
8029: WHEN duplicate_stop_seq THEN
8030: rollback to start_of_the_trip;
8031: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DUP_SEQUENCE');
8032: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8033:
8034: WHEN reset_stop_seq_number_error THEN
8035: rollback to start_of_the_trip;

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

8331: FETCH c_get_trip_stops BULK COLLECT INTO l_cs_tripstops_tab;
8332: CLOSE c_get_trip_stops;
8333:
8334: IF l_cs_tripstops_tab.COUNT = 0 THEN
8335: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_NO_STOPS');
8336: --FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_id_tab(i));
8337: --FND_MSG_PUB.ADD;
8338: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8339: l_rg_trip := FALSE;

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

8332: CLOSE c_get_trip_stops;
8333:
8334: IF l_cs_tripstops_tab.COUNT = 0 THEN
8335: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_NO_STOPS');
8336: --FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_id_tab(i));
8337: --FND_MSG_PUB.ADD;
8338: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8339: l_rg_trip := FALSE;
8340: WSH_UTIL_CORE.add_message(x_return_status);

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

8504: OPEN c_ship_to_site_use(l_ultimate_dropoff_loc_id);
8505: FETCH c_ship_to_site_use INTO l_customer_site_id;
8506: IF c_ship_to_site_use%NOTFOUND THEN
8507: IF l_customer_id IS NOT NULL THEN
8508: FND_MESSAGE.SET_NAME('WSH','WSH_LOCATION_NO_SITE');
8509: --FND_MESSAGE.Set_Token('LOCATION',l_ultimate_dropoff_loc_id);
8510: FND_MESSAGE.Set_Token('TRIPNAME',l_cs_trip_rec.trip_name);
8511: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8512: l_rg_trip := FALSE;

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

8505: FETCH c_ship_to_site_use INTO l_customer_site_id;
8506: IF c_ship_to_site_use%NOTFOUND THEN
8507: IF l_customer_id IS NOT NULL THEN
8508: FND_MESSAGE.SET_NAME('WSH','WSH_LOCATION_NO_SITE');
8509: --FND_MESSAGE.Set_Token('LOCATION',l_ultimate_dropoff_loc_id);
8510: FND_MESSAGE.Set_Token('TRIPNAME',l_cs_trip_rec.trip_name);
8511: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8512: l_rg_trip := FALSE;
8513: ELSE

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

8506: IF c_ship_to_site_use%NOTFOUND THEN
8507: IF l_customer_id IS NOT NULL THEN
8508: FND_MESSAGE.SET_NAME('WSH','WSH_LOCATION_NO_SITE');
8509: --FND_MESSAGE.Set_Token('LOCATION',l_ultimate_dropoff_loc_id);
8510: FND_MESSAGE.Set_Token('TRIPNAME',l_cs_trip_rec.trip_name);
8511: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8512: l_rg_trip := FALSE;
8513: ELSE
8514: l_customer_site_id := NULL;

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

8624: END IF;
8625:
8626: IF l_trip_result_type = 'MULTILEG' THEN
8627: IF l_trip_id <> l_prev_trip_id THEN
8628: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_MULTILEG_TRIP');
8629: FND_MESSAGE.SET_TOKEN('TRIPID',l_trip_id);
8630: --FND_MSG_PUB.ADD;
8631: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8632: WSH_UTIL_CORE.add_message(x_return_status);

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

8625:
8626: IF l_trip_result_type = 'MULTILEG' THEN
8627: IF l_trip_id <> l_prev_trip_id THEN
8628: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_MULTILEG_TRIP');
8629: FND_MESSAGE.SET_TOKEN('TRIPID',l_trip_id);
8630: --FND_MSG_PUB.ADD;
8631: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8632: WSH_UTIL_CORE.add_message(x_return_status);
8633: END IF;

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

8638: -- Warning when trip already has an attached ranked list
8639:
8640: --IF l_trip_rank_array(l_trip_id) IS NOT NULL THEN
8641: IF l_trip_rank_array(TO_CHAR(l_trip_id, g_int_mask)) IS NOT NULL THEN
8642: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_UPD_TRIP_RANK_LIST');
8643: FND_MESSAGE.SET_TOKEN('TRIPID',l_trip_id);
8644: --FND_MSG_PUB.ADD;
8645: IF l_debug_on THEN
8646: WSH_DEBUG_SV.logmsg(l_module_name,'Trip already has a ranked list ');

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

8639:
8640: --IF l_trip_rank_array(l_trip_id) IS NOT NULL THEN
8641: IF l_trip_rank_array(TO_CHAR(l_trip_id, g_int_mask)) IS NOT NULL THEN
8642: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_UPD_TRIP_RANK_LIST');
8643: FND_MESSAGE.SET_TOKEN('TRIPID',l_trip_id);
8644: --FND_MSG_PUB.ADD;
8645: IF l_debug_on THEN
8646: WSH_DEBUG_SV.logmsg(l_module_name,'Trip already has a ranked list ');
8647: END IF;

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

8774: IF l_rank_result_cnt = 0 THEN
8775: --
8776: -- All results found are multileg, return an error
8777: --
8778: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_RANKED_RESULT');
8779: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8780: WSH_UTIL_CORE.add_message(x_return_status);
8781: --
8782: -- Debug Statements

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

8790: ELSE -- l_cs_result_tab.COUNT = 0
8791: --
8792: -- No results at all where found, return a warning
8793: --
8794: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_CARRIER_SELECTED');
8795: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8796: WSH_UTIL_CORE.add_message(x_return_status);
8797: --
8798: -- Debug Statements

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

8806: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8807: END IF;
8808: -- TODO
8809: ELSE -- No eligible trips were found
8810: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_VALID_TRIPS');
8811: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8812: WSH_UTIL_CORE.add_message(x_return_status);
8813: --
8814: -- Debug Statements

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

9036: WHEN WSH_INVALID_ACTION THEN
9037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9038: --
9039: -- Debug Statements
9040: FND_MESSAGE.SET_NAME('WSH','WSH_REMOVE_CONSOL_ERR');
9041: wsh_util_core.add_message(x_return_status);
9042: IF l_debug_on THEN
9043: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ACTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9044: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ACTION');