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.FTE_WSH_INTERFACE_PKG dependencies on WSH_UTIL_CORE

Line 192: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

188: --
189: x_curr_stop_old_position := l_curr_stop_old_position;
190: x_trip_stop_tab := l_trip_stop_tab;
191: --
192: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
193: --}
194: EXCEPTION
195: --{
196: WHEN OTHERS THEN

Line 197: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.GET_SEGMENT_STOPS');

193: --}
194: EXCEPTION
195: --{
196: WHEN OTHERS THEN
197: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.GET_SEGMENT_STOPS');
198: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
199: --}
200: END get_segment_stops;
201: --

Line 198: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

194: EXCEPTION
195: --{
196: WHEN OTHERS THEN
197: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.GET_SEGMENT_STOPS');
198: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
199: --}
200: END get_segment_stops;
201: --
202: --

Line 242: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

238: --
239: --}
240: BEGIN
241: --{
242: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
243: l_number_of_errors := 0;
244: l_number_of_warnings := 0;
245: --
246: --

Line 279: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

275: x_return_status => x_return_status
276: );
277: --
278: --
279: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
280: THEN
281: --{
282: RETURN;
283: --}

Line 296: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

292: --{
293: FND_MESSAGE.SET_NAME('FTE', 'FTE_FIRST_STOP_DATE_MATCH_ERR');
294: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
295: FND_MESSAGE.SET_TOKEN('SCHED_DEPARTURE_DATE', fnd_date.date_to_displayDT(p_schedule_start_datetime));
296: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
297: l_number_of_errors := l_number_of_errors + 1;
298: --}
299: END IF;
300: --}

Line 333: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

329: x_return_status => x_return_status
330: );
331: --
332: --
333: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
334: THEN
335: --{
336: RETURN;
337: --}

Line 346: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

342: THEN
343: --{
344: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_LOCN_LANE_ORIG_ERR');
345: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
346: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
347: l_number_of_errors := l_number_of_errors + 1;
348: --}
349: END IF;
350: --}

Line 406: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

402: x_return_status => x_return_status
403: );
404: --
405: --
406: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
407: THEN
408: --{
409: RETURN;
410: --}

Line 420: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

416: --{
417: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CONNECT_ERROR');
418: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
419: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);
420: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
421: l_number_of_warnings := l_number_of_warnings + 1;
422: --
423: --
424: UPDATE fte_trips

Line 448: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

444: THEN
445: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_DLVY_INTRANSIT_ERR');
446: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
447: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);
448: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
449: l_number_of_warnings := l_number_of_warnings + 1;
450: END IF;
451: --}
452: END IF;

Line 462: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

458: --
459: --
460: IF l_number_of_errors > 0
461: THEN
462: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
463: ELSIF l_number_of_warnings > 0
464: THEN
465: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
466: ELSE

Line 465: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

461: THEN
462: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
463: ELSIF l_number_of_warnings > 0
464: THEN
465: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
466: ELSE
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
468: END IF;
469: --}

Line 467: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

463: ELSIF l_number_of_warnings > 0
464: THEN
465: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
466: ELSE
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
468: END IF;
469: --}
470: EXCEPTION
471: --{

Line 473: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_FIRST_STOP');

469: --}
470: EXCEPTION
471: --{
472: WHEN OTHERS THEN
473: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_FIRST_STOP');
474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
475: --}
476: END validate_first_stop;
477: --

Line 474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

470: EXCEPTION
471: --{
472: WHEN OTHERS THEN
473: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_FIRST_STOP');
474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
475: --}
476: END validate_first_stop;
477: --
478: --

Line 517: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

513: --
514: --}
515: BEGIN
516: --{
517: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
518: l_number_of_errors := 0;
519: l_number_of_warnings := 0;
520: --
521: --

Line 554: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

550: x_return_status => x_return_status
551: );
552: --
553: --
554: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
555: THEN
556: --{
557: RETURN;
558: --}

Line 571: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

567: --{
568: FND_MESSAGE.SET_NAME('FTE', 'FTE_LAST_STOP_DATE_MATCH_ERR');
569: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
570: FND_MESSAGE.SET_TOKEN('SCHED_ARRIVAL_DATE', fnd_date.date_to_displayDT(p_schedule_end_datetime));
571: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
572: l_number_of_errors := l_number_of_errors + 1;
573: --}
574: END IF;
575: --}

Line 608: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

604: x_return_status => x_return_status
605: );
606: --
607: --
608: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
609: THEN
610: --{
611: RETURN;
612: --}

Line 622: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

618: THEN
619: --{
620: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_LOCN_LANE_DEST_ERR');
621: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
622: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
623: l_number_of_errors := l_number_of_errors + 1;
624: --}
625: END IF;
626: --}

Line 681: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

677: x_return_status => x_return_status
678: );
679: --
680: --
681: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
682: THEN
683: --{
684: RETURN;
685: --}

Line 695: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

691: --{
692: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NEXT_CONNECT_ERROR');
693: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
694: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);
695: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
696: l_number_of_warnings := l_number_of_warnings + 1;
697: --
698: --
699: UPDATE fte_trips

Line 723: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

719: THEN
720: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_DLVY_INTRANSIT_ERR');
721: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
722: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);
723: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
724: l_number_of_warnings := l_number_of_warnings + 1;
725: END IF;
726: --}
727: END IF;

Line 737: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

733: --
734: --
735: IF l_number_of_errors > 0
736: THEN
737: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
738: ELSIF l_number_of_warnings > 0
739: THEN
740: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
741: ELSE

Line 740: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

736: THEN
737: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
738: ELSIF l_number_of_warnings > 0
739: THEN
740: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
741: ELSE
742: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
743: END IF;
744: --}

Line 742: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

738: ELSIF l_number_of_warnings > 0
739: THEN
740: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
741: ELSE
742: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
743: END IF;
744: --}
745: EXCEPTION
746: --{

Line 748: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_LAST_STOP');

744: --}
745: EXCEPTION
746: --{
747: WHEN OTHERS THEN
748: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_LAST_STOP');
749: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
750: --}
751: END validate_last_stop;
752: --

Line 749: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

745: EXCEPTION
746: --{
747: WHEN OTHERS THEN
748: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_LAST_STOP');
749: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
750: --}
751: END validate_last_stop;
752: --
753: --

Line 782: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

778: --
779: --}
780: BEGIN
781: --{
782: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
783: l_number_of_errors := 0;
784: l_number_of_warnings := 0;
785: --
786: --

Line 819: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

815: x_return_status => x_return_status
816: );
817: --
818: --
819: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
820: THEN
821: --{
822: RETURN;
823: --}

Line 839: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

835: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
836: FND_MESSAGE.SET_TOKEN('STOP_SEQUENCE_NUMBER', p_current_stop_rec.stop_sequence_number);
837: FND_MESSAGE.SET_TOKEN('SCHED_DEPARTURE_DATE', fnd_date.date_to_displayDT(p_schedule_start_datetime));
838: FND_MESSAGE.SET_TOKEN('SCHED_ARRIVAL_DATE', fnd_date.date_to_displayDT(p_schedule_end_datetime));
839: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
840: l_number_of_warnings := l_number_of_warnings + 1;
841: --
842: -- Not setting as error due to timezone issues.
843: -- It will be a warning until timezone issues are resolved.

Line 845: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

841: --
842: -- Not setting as error due to timezone issues.
843: -- It will be a warning until timezone issues are resolved.
844: --
845: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
846: --l_number_of_errors := l_number_of_errors + 1;
847: --}
848: END IF;
849: --

Line 862: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

858: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
859: FND_MESSAGE.SET_TOKEN('STOP_SEQUENCE_NUMBER', p_current_stop_rec.stop_sequence_number);
860: FND_MESSAGE.SET_TOKEN('SCHED_DEPARTURE_DATE', fnd_date.date_to_displayDT(p_schedule_start_datetime));
861: FND_MESSAGE.SET_TOKEN('SCHED_ARRIVAL_DATE', fnd_date.date_to_displayDT(p_schedule_end_datetime));
862: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
863: l_number_of_warnings := l_number_of_warnings + 1;
864: --
865: -- Not setting as error due to timezone issues.
866: -- It will be a warning until timezone issues are resolved.

Line 868: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

864: --
865: -- Not setting as error due to timezone issues.
866: -- It will be a warning until timezone issues are resolved.
867: --
868: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
869: --l_number_of_errors := l_number_of_errors + 1;
870: --}
871: END IF;
872: --}

Line 905: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

901: x_return_status => x_return_status
902: );
903: --
904: --
905: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
906: THEN
907: --{
908: RETURN;
909: --}

Line 918: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

914: THEN
915: --{
916: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_LOCN_LANE_WARN');
917: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
918: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
919: l_number_of_warnings := l_number_of_warnings + 1;
920: --}
921: END IF;
922: --}

Line 928: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

924: --
925: --
926: IF l_number_of_errors > 0
927: THEN
928: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
929: ELSIF l_number_of_warnings > 0
930: THEN
931: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
932: ELSE

Line 931: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

927: THEN
928: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
929: ELSIF l_number_of_warnings > 0
930: THEN
931: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
932: ELSE
933: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
934: END IF;
935: --}

Line 933: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

929: ELSIF l_number_of_warnings > 0
930: THEN
931: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
932: ELSE
933: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
934: END IF;
935: --}
936: EXCEPTION
937: --{

Line 939: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_INTERMEDIATE_STOP');

935: --}
936: EXCEPTION
937: --{
938: WHEN OTHERS THEN
939: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_INTERMEDIATE_STOP');
940: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
941: --}
942: END validate_intermediate_stop;
943: --

Line 940: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

936: EXCEPTION
937: --{
938: WHEN OTHERS THEN
939: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_INTERMEDIATE_STOP');
940: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
941: --}
942: END validate_intermediate_stop;
943: --
944: --

Line 987: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

983:
984: --}
985: BEGIN
986: --{
987: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
988: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
989: l_number_of_errors := 0;
990: l_number_of_warnings := 0;
991: l_first := FALSE;

Line 988: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

984: --}
985: BEGIN
986: --{
987: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
988: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
989: l_number_of_errors := 0;
990: l_number_of_warnings := 0;
991: l_first := FALSE;
992: l_last := FALSE;

Line 1032: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1028: x_return_status => x_return_status
1029: );
1030: --
1031: --
1032: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1033: THEN
1034: --{
1035: RETURN;
1036: --}

Line 1074: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1070: x_return_status => x_return_status
1071: );
1072: --
1073: --
1074: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1075: THEN
1076: --{
1077: RETURN;
1078: --}

Line 1113: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1109: x_return_status => x_return_status
1110: );
1111: --
1112: --
1113: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1114: THEN
1115: --{
1116: RETURN;
1117: --}

Line 1125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1121: --
1122: --
1123: IF l_number_of_errors > 0
1124: THEN
1125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1126: ELSIF l_number_of_warnings > 0
1127: THEN
1128: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1129: ELSE

Line 1128: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1124: THEN
1125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1126: ELSIF l_number_of_warnings > 0
1127: THEN
1128: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1129: ELSE
1130: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1131: END IF;
1132: --}

Line 1130: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1126: ELSIF l_number_of_warnings > 0
1127: THEN
1128: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1129: ELSE
1130: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1131: END IF;
1132: --}
1133: EXCEPTION
1134: --{

Line 1136: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD');

1132: --}
1133: EXCEPTION
1134: --{
1135: WHEN OTHERS THEN
1136: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD');
1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1138: --}
1139: END validate_stop_add;
1140: --

Line 1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1133: EXCEPTION
1134: --{
1135: WHEN OTHERS THEN
1136: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_ADD');
1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1138: --}
1139: END validate_stop_add;
1140: --
1141: --

Line 1194: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1190: --
1191: --}
1192: BEGIN
1193: --{
1194: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1195: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1196: l_number_of_errors := 0;
1197: l_number_of_warnings := 0;
1198: --

Line 1195: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1191: --}
1192: BEGIN
1193: --{
1194: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1195: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1196: l_number_of_errors := 0;
1197: l_number_of_warnings := 0;
1198: --
1199: --

Line 1276: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1272: x_return_status => x_return_status
1273: );
1274: --
1275: --
1276: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1277: THEN
1278: --{
1279: RETURN;
1280: --}

Line 1333: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1329: x_return_status => x_return_status
1330: );
1331: --
1332: --
1333: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1334: THEN
1335: --{
1336: RETURN;
1337: --}

Line 1387: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1383: x_return_status => x_return_status
1384: );
1385: --
1386: --
1387: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1388: THEN
1389: --{
1390: RETURN;
1391: --}

Line 1431: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1427: x_return_status => x_return_status
1428: );
1429: --
1430: --
1431: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1432: THEN
1433: --{
1434: RETURN;
1435: --}

Line 1469: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1465: x_return_status => x_return_status
1466: );
1467: --
1468: --
1469: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1470: THEN
1471: --{
1472: RETURN;
1473: --}

Line 1484: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1480: --
1481: --
1482: IF l_number_of_errors > 0
1483: THEN
1484: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1485: ELSIF l_number_of_warnings > 0
1486: THEN
1487: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1488: ELSE

Line 1487: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1483: THEN
1484: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1485: ELSIF l_number_of_warnings > 0
1486: THEN
1487: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1488: ELSE
1489: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1490: END IF;
1491: --}

Line 1489: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1485: ELSIF l_number_of_warnings > 0
1486: THEN
1487: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1488: ELSE
1489: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1490: END IF;
1491: --}
1492: EXCEPTION
1493: --{

Line 1495: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_UPDATE');

1491: --}
1492: EXCEPTION
1493: --{
1494: WHEN OTHERS THEN
1495: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_UPDATE');
1496: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1497: --}
1498: END validate_stop_update;
1499: --

Line 1496: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1492: EXCEPTION
1493: --{
1494: WHEN OTHERS THEN
1495: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_UPDATE');
1496: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1497: --}
1498: END validate_stop_update;
1499: --
1500: --

Line 1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1541: --
1542: --}
1543: BEGIN
1544: --{
1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1546: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1547: l_number_of_errors := 0;
1548: l_number_of_warnings := 0;
1549: l_trip_count := 0;

Line 1546: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1542: --}
1543: BEGIN
1544: --{
1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1546: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1547: l_number_of_errors := 0;
1548: l_number_of_warnings := 0;
1549: l_trip_count := 0;
1550: l_first := FALSE;

Line 1618: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1614: x_return_status => x_return_status
1615: );
1616: --
1617: --
1618: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1619: THEN
1620: --{
1621: RETURN;
1622: --}

Line 1632: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

1628: --{
1629: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CONNECT_ERROR');
1630: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
1631: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);
1632: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
1633: l_number_of_warnings := l_number_of_warnings + 1;
1634: --
1635: --
1636: UPDATE fte_trips

Line 1675: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1671: x_return_status => x_return_status
1672: );
1673: --
1674: --
1675: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1676: THEN
1677: --{
1678: RETURN;
1679: --}

Line 1689: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

1685: --{
1686: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NEXT_CONNECT_ERROR');
1687: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
1688: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);
1689: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
1690: l_number_of_warnings := l_number_of_warnings + 1;
1691: --
1692: --
1693: UPDATE fte_trips

Line 1714: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1710: THEN
1711: --{
1712: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_DELETE_ERROR');
1713: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
1714: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1716: RETURN;
1717: --}
1718: END IF;

Line 1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1711: --{
1712: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_DELETE_ERROR');
1713: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);
1714: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1716: RETURN;
1717: --}
1718: END IF;
1719: --

Line 1798: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1794: x_return_status => x_return_status
1795: );
1796: --
1797: --
1798: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1799: THEN
1800: --{
1801: RETURN;
1802: --}

Line 1810: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1806: --
1807: --
1808: IF l_number_of_errors > 0
1809: THEN
1810: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1811: ELSIF l_number_of_warnings > 0
1812: THEN
1813: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1814: ELSE

Line 1813: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1809: THEN
1810: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1811: ELSIF l_number_of_warnings > 0
1812: THEN
1813: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1814: ELSE
1815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1816: END IF;
1817: --}

Line 1815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1811: ELSIF l_number_of_warnings > 0
1812: THEN
1813: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1814: ELSE
1815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1816: END IF;
1817: --}
1818: EXCEPTION
1819: --{

Line 1821: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_DELETE');

1817: --}
1818: EXCEPTION
1819: --{
1820: WHEN OTHERS THEN
1821: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_DELETE');
1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1823: --}
1824: END validate_stop_delete;
1825: --

Line 1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1818: EXCEPTION
1819: --{
1820: WHEN OTHERS THEN
1821: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_STOP_DELETE');
1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1823: --}
1824: END validate_stop_delete;
1825: --
1826: --

Line 1926: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1922: END IF;
1923: --
1924: --
1925: -- Initialize API return status to success
1926: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1927: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1928: l_number_of_errors := 0;
1929: l_number_of_warnings := 0;
1930: p_action_type := p_segmentStopChangeInRec.action_type;

Line 1927: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1923: --
1924: --
1925: -- Initialize API return status to success
1926: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1927: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1928: l_number_of_errors := 0;
1929: l_number_of_warnings := 0;
1930: p_action_type := p_segmentStopChangeInRec.action_type;
1931: --

Line 1948: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1944: ELSE
1945: --{
1946: FND_MESSAGE.SET_NAME('FTE', 'FTE_WSH_IF_INVALID_ACTION');
1947: FND_MESSAGE.SET_TOKEN('ACTION_TYPE', p_action_type);
1948: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1949: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1950: RAISE FND_API.G_EXC_ERROR;
1951: --RETURN;
1952: --}

Line 1949: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1945: --{
1946: FND_MESSAGE.SET_NAME('FTE', 'FTE_WSH_IF_INVALID_ACTION');
1947: FND_MESSAGE.SET_TOKEN('ACTION_TYPE', p_action_type);
1948: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1949: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1950: RAISE FND_API.G_EXC_ERROR;
1951: --RETURN;
1952: --}
1953: END IF;

Line 1985: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1981: x_return_status => x_return_status
1982: );
1983: --
1984: --
1985: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1986: THEN
1987: --{
1988: RAISE FND_API.G_EXC_ERROR;
1989: --RETURN;

Line 2035: wsh_util_core.api_post_call(

2031: X_return_status => l_return_status
2032: );
2033:
2034:
2035: wsh_util_core.api_post_call(
2036: p_return_status =>l_return_status,
2037: x_num_warnings =>l_number_of_warnings,
2038: x_num_errors =>l_number_of_errors);
2039:

Line 2059: wsh_util_core.api_post_call(

2055: X_msg_data => l_msg_data,
2056: P_trip_segment_rec => p_trip_segment_rec,
2057: P_new_segment_stop_rec => l_current_stop_rec);
2058:
2059: wsh_util_core.api_post_call(
2060: p_return_status =>l_return_status,
2061: x_num_warnings =>l_number_of_warnings,
2062: x_num_errors =>l_number_of_errors,
2063: p_msg_data =>l_msg_data);

Line 2091: wsh_util_core.api_post_call(

2087: X_return_status => l_return_status
2088: );
2089:
2090:
2091: wsh_util_core.api_post_call(
2092: p_return_status => l_return_status,
2093: x_num_warnings =>l_number_of_warnings,
2094: x_num_errors =>l_number_of_errors);
2095:

Line 2132: wsh_util_core.api_post_call(

2128: WSH_DEBUG_SV.logmsg(l_module_name,' message data ' || l_msg_data,
2129: WSH_DEBUG_SV.C_PROC_LEVEL);
2130: END IF;
2131:
2132: wsh_util_core.api_post_call(
2133: p_return_status =>l_return_status,
2134: x_num_warnings =>l_number_of_warnings,
2135: x_num_errors =>l_number_of_errors,
2136: p_msg_data =>l_msg_data);

Line 2175: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

2171: x_return_status => x_return_status
2172: );
2173: --
2174: --
2175: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2176: THEN
2177: --{
2178: RAISE FND_API.G_EXC_ERROR;
2179: --RETURN;

Line 2190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2186: --
2187: --
2188: IF l_number_of_errors > 0
2189: THEN
2190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2191: ELSIF l_number_of_warnings > 0
2192: THEN
2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2194: ELSE

Line 2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2189: THEN
2190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2191: ELSIF l_number_of_warnings > 0
2192: THEN
2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2194: ELSE
2195: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2196: END IF;
2197: --

Line 2195: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2191: ELSIF l_number_of_warnings > 0
2192: THEN
2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2194: ELSE
2195: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2196: END IF;
2197: --
2198: --
2199: --

Line 2265: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.segment_stop_change SEGMENT');

2261: wsh_debug_sv.log (l_module_name,' Unexpected error ');
2262: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
2263: WSH_DEBUG_SV.pop(l_module_name);
2264: END IF;
2265: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.segment_stop_change SEGMENT');
2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2267: --
2268: --
2269: FND_MSG_PUB.Count_And_Get

Line 2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2262: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
2263: WSH_DEBUG_SV.pop(l_module_name);
2264: END IF;
2265: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.segment_stop_change SEGMENT');
2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2267: --
2268: --
2269: FND_MSG_PUB.Count_And_Get
2270: (

Line 2340: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2336: --
2337: --}
2338: BEGIN
2339: --{
2340: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2341: l_number_of_errors := 0;
2342: l_number_of_warnings := 0;
2343: l_trip_segment_name := p_new_trip_segment_rec.name;
2344: --

Line 2376: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

2372: AND NVL(p_new_trip_segment_rec.ship_method_code, '!-') <> NVL(p_old_trip_segment_rec.ship_method_code,'!-')
2373: THEN
2374: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_CSM_CHANGE_ERROR');
2375: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_new_trip_segment_rec.name);
2376: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2377: l_number_of_errors := l_number_of_errors + 1;
2378: END IF;
2379: --}
2380: END IF;

Line 2413: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

2409: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CLOSE_ERROR');
2410: FND_MESSAGE.SET_TOKEN('PREV_TRIP_SEG_NAME', get_prev_segments_rec.wsh_trip_name);
2411: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_new_trip_segment_rec.name);
2412: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);
2413: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
2414: l_number_of_warnings := l_number_of_warnings + 1;
2415: --}
2416: END IF;
2417: --}

Line 2459: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

2455: x_return_status => x_return_status
2456: );
2457: --
2458: --
2459: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2460: THEN
2461: --{
2462: RETURN;
2463: --}

Line 2499: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2495: --
2496: --
2497: IF l_number_of_errors > 0
2498: THEN
2499: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2500: ELSIF l_number_of_warnings > 0
2501: THEN
2502: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2503: ELSE

Line 2502: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2498: THEN
2499: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2500: ELSIF l_number_of_warnings > 0
2501: THEN
2502: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2503: ELSE
2504: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2505: END IF;
2506: --}

Line 2504: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2500: ELSIF l_number_of_warnings > 0
2501: THEN
2502: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2503: ELSE
2504: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2505: END IF;
2506: --}
2507: EXCEPTION
2508: --{

Line 2510: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_UPDATE');

2506: --}
2507: EXCEPTION
2508: --{
2509: WHEN OTHERS THEN
2510: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_UPDATE');
2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2512: --}
2513: END validate_segment_update;
2514: --

Line 2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2507: EXCEPTION
2508: --{
2509: WHEN OTHERS THEN
2510: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_UPDATE');
2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2512: --}
2513: END validate_segment_update;
2514: --
2515: --

Line 2562: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2558: --
2559: --}
2560: BEGIN
2561: --{
2562: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2563: l_number_of_errors := 0;
2564: l_number_of_warnings := 0;
2565: l_trip_segment_name := p_trip_segment_rec.name;
2566: --

Line 2601: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

2597: x_return_status => x_return_status
2598: );
2599: --
2600: --
2601: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2602: THEN
2603: --{
2604: RETURN;
2605: --}

Line 2634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2630: --
2631: --
2632: IF l_number_of_errors > 0
2633: THEN
2634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2635: ELSIF l_number_of_warnings > 0
2636: THEN
2637: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2638: ELSE

Line 2637: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2633: THEN
2634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2635: ELSIF l_number_of_warnings > 0
2636: THEN
2637: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2638: ELSE
2639: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2640: END IF;
2641: --}

Line 2639: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2635: ELSIF l_number_of_warnings > 0
2636: THEN
2637: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2638: ELSE
2639: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2640: END IF;
2641: --}
2642: EXCEPTION
2643: --{

Line 2645: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_DELETE');

2641: --}
2642: EXCEPTION
2643: --{
2644: WHEN OTHERS THEN
2645: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_DELETE');
2646: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2647: --}
2648: END validate_segment_delete;
2649: --

Line 2646: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2642: EXCEPTION
2643: --{
2644: WHEN OTHERS THEN
2645: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.VALIDATE_SEGMENT_DELETE');
2646: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2647: --}
2648: END validate_segment_delete;
2649: --
2650: --

Line 2713: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2709: END IF;
2710: --
2711: --
2712: -- Initialize API return status to success
2713: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2714: l_number_of_errors := 0;
2715: l_number_of_warnings := 0;
2716: p_action_type := p_tripSegmentChangeInRec.action_type;
2717: --

Line 2757: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

2753: ELSE
2754: --{
2755: FND_MESSAGE.SET_NAME('FTE', 'FTE_WSH_IF_INVALID_ACTION');
2756: FND_MESSAGE.SET_TOKEN('ACTION_TYPE', p_action_type);
2757: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2758: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2759: RAISE FND_API.G_EXC_ERROR;
2760: --RETURN;
2761: --}

Line 2758: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2754: --{
2755: FND_MESSAGE.SET_NAME('FTE', 'FTE_WSH_IF_INVALID_ACTION');
2756: FND_MESSAGE.SET_TOKEN('ACTION_TYPE', p_action_type);
2757: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2758: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2759: RAISE FND_API.G_EXC_ERROR;
2760: --RETURN;
2761: --}
2762: END IF;

Line 2778: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

2774: x_return_status => x_return_status
2775: );
2776: --
2777: --
2778: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2779: THEN
2780: --{
2781: RAISE FND_API.G_EXC_ERROR;
2782: --RETURN;

Line 2793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2789: --
2790: --
2791: IF l_number_of_errors > 0
2792: THEN
2793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2794: ELSIF l_number_of_warnings > 0
2795: THEN
2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2797: ELSE

Line 2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2792: THEN
2793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2794: ELSIF l_number_of_warnings > 0
2795: THEN
2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2797: ELSE
2798: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2799: END IF;
2800: --

Line 2798: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2794: ELSIF l_number_of_warnings > 0
2795: THEN
2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2797: ELSE
2798: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2799: END IF;
2800: --
2801: --
2802: --

Line 2849: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.TRIP_SEGMENT_CHANGE');

2845: );
2846: WHEN OTHERS THEN
2847: ROLLBACK TO TRIP_SEGMENT_CHANGE_PUB;
2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2849: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.TRIP_SEGMENT_CHANGE');
2850: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2851: --
2852: --
2853: FND_MSG_PUB.Count_And_Get

Line 2850: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2846: WHEN OTHERS THEN
2847: ROLLBACK TO TRIP_SEGMENT_CHANGE_PUB;
2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2849: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.TRIP_SEGMENT_CHANGE');
2850: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2851: --
2852: --
2853: FND_MSG_PUB.Count_And_Get
2854: (

Line 2935: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2931: THEN
2932: FND_MSG_PUB.initialize;
2933: END IF;
2934:
2935: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2936: x_msg_count := 0;
2937: x_msg_data := 0;
2938: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2939: l_number_of_warnings := 0;

Line 2938: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2934:
2935: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2936: x_msg_count := 0;
2937: x_msg_data := 0;
2938: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2939: l_number_of_warnings := 0;
2940: l_number_of_errors := 0;
2941: l_trip_id := NULL;
2942: l_org_id := NULL;

Line 2969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2965: END IF;
2966: EXCEPTION
2967: WHEN NO_DATA_FOUND THEN
2968: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_STOP');
2969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2970: wsh_util_core.add_message(x_return_status);
2971: RAISE FND_API.G_EXC_ERROR;
2972: END;
2973: END IF;

Line 2970: wsh_util_core.add_message(x_return_status);

2966: EXCEPTION
2967: WHEN NO_DATA_FOUND THEN
2968: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_STOP');
2969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2970: wsh_util_core.add_message(x_return_status);
2971: RAISE FND_API.G_EXC_ERROR;
2972: END;
2973: END IF;
2974:

Line 2992: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2988: END IF;
2989: EXCEPTION
2990: WHEN NO_DATA_FOUND THEN
2991: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_DLVY');
2992: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2993: wsh_util_core.add_message(x_return_status);
2994: RAISE FND_API.G_EXC_ERROR;
2995: END;
2996: ELSIF (p_entity_type = 'DETAIL')

Line 2993: wsh_util_core.add_message(x_return_status);

2989: EXCEPTION
2990: WHEN NO_DATA_FOUND THEN
2991: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_DLVY');
2992: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2993: wsh_util_core.add_message(x_return_status);
2994: RAISE FND_API.G_EXC_ERROR;
2995: END;
2996: ELSIF (p_entity_type = 'DETAIL')
2997: THEN

Line 3011: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3007: END IF;
3008: EXCEPTION
3009: WHEN NO_DATA_FOUND THEN
3010: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_DETAIL');
3011: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3012: wsh_util_core.add_message(x_return_status);
3013: RAISE FND_API.G_EXC_ERROR;
3014: END;
3015: END IF;

Line 3012: wsh_util_core.add_message(x_return_status);

3008: EXCEPTION
3009: WHEN NO_DATA_FOUND THEN
3010: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_DETAIL');
3011: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3012: wsh_util_core.add_message(x_return_status);
3013: RAISE FND_API.G_EXC_ERROR;
3014: END;
3015: END IF;
3016:

Line 3029: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3025: FETCH GET_ORG_ID INTO x_org_id;
3026:
3027: IF (GET_ORG_ID%NOTFOUND) THEN
3028: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_ID_NOTFOUND');
3029: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3030: wsh_util_core.add_message(x_return_status);
3031: END IF;
3032:
3033: CLOSE GET_ORG_ID;

Line 3030: wsh_util_core.add_message(x_return_status);

3026:
3027: IF (GET_ORG_ID%NOTFOUND) THEN
3028: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_ID_NOTFOUND');
3029: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3030: wsh_util_core.add_message(x_return_status);
3031: END IF;
3032:
3033: CLOSE GET_ORG_ID;
3034: END IF;

Line 3082: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.GET_TRIP_ORG_ORGANIZATION');

3078: IF l_debug_on THEN
3079: WSH_DEBUG_SV.pop(l_module_name);
3080: END IF;
3081: WHEN OTHERS THEN
3082: wsh_util_core.default_handler('FTE_WSH_INTERFACE_PKG.GET_TRIP_ORG_ORGANIZATION');
3083: x_return_status := FND_API.G_RET_STS_ERROR;
3084: FND_MSG_PUB.Count_And_Get
3085: (
3086: p_count => x_msg_count,