289: IF p_current_stop_rec.planned_departure_date
290: <> p_schedule_start_datetime
291: THEN
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;
290: <> p_schedule_start_datetime
291: THEN
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: --}
291: THEN
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;
340: --
341: IF l_lane_valid_flag = 'N'
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: --}
341: IF l_lane_valid_flag = 'N'
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;
413: --
414: IF NOT(l_connected)
415: THEN
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;
414: IF NOT(l_connected)
415: THEN
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: --
415: THEN
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: --
441: THEN
442: --{
443: IF segment_has_intransit_dlvy( P_trip_segment_rec => p_trip_segment_rec )
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;
442: --{
443: IF segment_has_intransit_dlvy( P_trip_segment_rec => p_trip_segment_rec )
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;
443: IF segment_has_intransit_dlvy( P_trip_segment_rec => p_trip_segment_rec )
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: --}
564: IF p_current_stop_rec.planned_arrival_date
565: <> p_schedule_end_datetime
566: THEN
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;
565: <> p_schedule_end_datetime
566: THEN
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: --}
566: THEN
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;
616: l_lane_valid_flag := 'Y';
617: IF l_lane_valid_flag = 'N'
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: --}
617: IF l_lane_valid_flag = 'N'
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;
688: --
689: IF NOT(l_connected)
690: THEN
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;
689: IF NOT(l_connected)
690: THEN
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: --
690: THEN
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: --
716: THEN
717: --{
718: IF segment_has_intransit_dlvy( P_trip_segment_rec => p_trip_segment_rec )
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;
717: --{
718: IF segment_has_intransit_dlvy( P_trip_segment_rec => p_trip_segment_rec )
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;
718: IF segment_has_intransit_dlvy( P_trip_segment_rec => p_trip_segment_rec )
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: --}
830: NOT BETWEEN p_schedule_start_datetime
831: AND p_schedule_end_datetime
832: THEN
833: --{
834: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_DEP_DATE_ERR');
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));
831: AND p_schedule_end_datetime
832: THEN
833: --{
834: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_DEP_DATE_ERR');
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);
832: THEN
833: --{
834: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_DEP_DATE_ERR');
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;
833: --{
834: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_DEP_DATE_ERR');
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: --
834: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_DEP_DATE_ERR');
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.
853: NOT BETWEEN p_schedule_start_datetime
854: AND p_schedule_end_datetime
855: THEN
856: --{
857: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_ARR_DATE_ERR');
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));
854: AND p_schedule_end_datetime
855: THEN
856: --{
857: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_ARR_DATE_ERR');
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);
855: THEN
856: --{
857: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_ARR_DATE_ERR');
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;
856: --{
857: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_ARR_DATE_ERR');
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: --
857: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_ARR_DATE_ERR');
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.
912: --
913: IF l_lane_valid_flag = 'N'
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: --}
913: IF l_lane_valid_flag = 'N'
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;
1625: --
1626: IF l_previous_segment_id IS NOT NULL
1627: THEN
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;
1626: IF l_previous_segment_id IS NOT NULL
1627: THEN
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: --
1627: THEN
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: --
1682: --
1683: IF l_next_segment_id IS NOT NULL
1684: THEN
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;
1683: IF l_next_segment_id IS NOT NULL
1684: THEN
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: --
1684: THEN
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: --
1708: l_trip_count > 0
1709: )
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;
1709: )
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: --}
1942: THEN
1943: NULL;
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;
1943: NULL;
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;
2217: p_count => x_msg_count,
2218: p_data => x_msg_data,
2219: p_encoded => FND_API.G_FALSE
2220: );
2221: --fnd_message.set_name('WSH','END');
2222: --
2223:
2224: IF l_debug_on THEN
2225: WSH_DEBUG_SV.pop(l_module_name);
2370: -- Release 12: Added so that FTE can update lane_id without first having to null out lane_id
2371: IF p_new_trip_segment_rec.lane_id = p_old_trip_segment_rec.lane_id
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;
2371: IF p_new_trip_segment_rec.lane_id = p_old_trip_segment_rec.lane_id
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: --}
2405: --{
2406: IF get_prev_segments_rec.status_code <> 'CL'
2407: THEN
2408: --{
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);
2406: IF get_prev_segments_rec.status_code <> 'CL'
2407: THEN
2408: --{
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;
2407: THEN
2408: --{
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: --}
2408: --{
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;
2751: );
2752: --}
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;
2752: --}
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;
2964: RAISE NO_DATA_FOUND;
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;
2987: RAISE NO_DATA_FOUND;
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;
3006: RAISE NO_DATA_FOUND;
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;
3024: OPEN GET_ORG_ID(x_organization_id);
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: