DBA Data[Home] [Help]

APPS.FTE_WSH_INTERFACE_PKG dependencies on FND_MESSAGE

Line 293: FND_MESSAGE.SET_NAME('FTE', 'FTE_FIRST_STOP_DATE_MATCH_ERR');

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;

Line 294: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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: --}

Line 295: FND_MESSAGE.SET_TOKEN('SCHED_DEPARTURE_DATE', fnd_date.date_to_displayDT(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: --}
299: END IF;

Line 344: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_LOCN_LANE_ORIG_ERR');

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: --}

Line 345: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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;

Line 417: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CONNECT_ERROR');

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;

Line 418: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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: --

Line 419: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);

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: --

Line 445: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_DLVY_INTRANSIT_ERR');

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;

Line 446: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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;

Line 447: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);

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: --}

Line 568: FND_MESSAGE.SET_NAME('FTE', 'FTE_LAST_STOP_DATE_MATCH_ERR');

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;

Line 569: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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: --}

Line 570: FND_MESSAGE.SET_TOKEN('SCHED_ARRIVAL_DATE', fnd_date.date_to_displayDT(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: --}
574: END IF;

Line 620: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_LOCN_LANE_DEST_ERR');

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: --}

Line 621: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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;

Line 692: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NEXT_CONNECT_ERROR');

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;

Line 693: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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: --

Line 694: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);

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: --

Line 720: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_DLVY_INTRANSIT_ERR');

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;

Line 721: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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;

Line 722: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);

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: --}

Line 834: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_DEP_DATE_ERR');

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));

Line 835: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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);

Line 836: FND_MESSAGE.SET_TOKEN('STOP_SEQUENCE_NUMBER', p_current_stop_rec.stop_sequence_number);

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;

Line 837: FND_MESSAGE.SET_TOKEN('SCHED_DEPARTURE_DATE', fnd_date.date_to_displayDT(p_schedule_start_datetime));

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: --

Line 838: FND_MESSAGE.SET_TOKEN('SCHED_ARRIVAL_DATE', fnd_date.date_to_displayDT(p_schedule_end_datetime));

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.

Line 857: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_ARR_DATE_ERR');

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));

Line 858: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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);

Line 859: FND_MESSAGE.SET_TOKEN('STOP_SEQUENCE_NUMBER', p_current_stop_rec.stop_sequence_number);

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;

Line 860: FND_MESSAGE.SET_TOKEN('SCHED_DEPARTURE_DATE', fnd_date.date_to_displayDT(p_schedule_start_datetime));

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: --

Line 861: FND_MESSAGE.SET_TOKEN('SCHED_ARRIVAL_DATE', fnd_date.date_to_displayDT(p_schedule_end_datetime));

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.

Line 916: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_LOCN_LANE_WARN');

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: --}

Line 917: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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;

Line 1629: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CONNECT_ERROR');

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;

Line 1630: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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: --

Line 1631: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);

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: --

Line 1686: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NEXT_CONNECT_ERROR');

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;

Line 1687: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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: --

Line 1688: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);

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: --

Line 1712: FND_MESSAGE.SET_NAME('FTE', 'FTE_STOP_DELETE_ERROR');

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;

Line 1713: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_rec.name);

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: --}

Line 1946: FND_MESSAGE.SET_NAME('FTE', 'FTE_WSH_IF_INVALID_ACTION');

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;

Line 1947: FND_MESSAGE.SET_TOKEN('ACTION_TYPE', p_action_type);

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;

Line 2221: --fnd_message.set_name('WSH','END');

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);

Line 2374: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_CSM_CHANGE_ERROR');

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;

Line 2375: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_new_trip_segment_rec.name);

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: --}

Line 2409: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CLOSE_ERROR');

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);

Line 2410: FND_MESSAGE.SET_TOKEN('PREV_TRIP_SEG_NAME', get_prev_segments_rec.wsh_trip_name);

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;

Line 2411: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_new_trip_segment_rec.name);

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: --}

Line 2412: FND_MESSAGE.SET_TOKEN('TRIP_NAME', get_segment_trips_rec.fte_trip_name);

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;

Line 2755: FND_MESSAGE.SET_NAME('FTE', 'FTE_WSH_IF_INVALID_ACTION');

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;

Line 2756: FND_MESSAGE.SET_TOKEN('ACTION_TYPE', p_action_type);

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;

Line 2968: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_STOP');

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;

Line 2991: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_DLVY');

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;

Line 3010: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_DETAIL');

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;

Line 3028: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_ID_NOTFOUND');

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: