DBA Data[Home] [Help]

APPS.FTE_WSH_INTERFACE_PKG dependencies on FTE_CAT_VALIDATE_PKG

Line 252: FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date

248: AND p_stop_validation_ctrl_rec.datetime_schedule_check
249: THEN
250: --{
251: /*
252: FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date
253: (
254: p_lane_id => p_trip_segment_rec.lane_id,
255: p_schedule_id => p_trip_segment_rec.schedule_id,
256: p_departure_date => p_current_stop_rec.planned_departure_date,

Line 266: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date',

262: --
263: --
264: FTE_MLS_UTIL.api_post_call
265: (
266: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date',
267: p_api_return_status => l_return_status,
268: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
269: p_trip_segment_id => p_trip_segment_rec.trip_id,
270: p_trip_segment_name => p_trip_segment_rec.name,

Line 288: --IF l_dep_match_flag <> FTE_CAT_VALIDATE_PKG.G_MATCH_WITH_DEP_DATE

284: END IF;
285: */
286: --
287: --
288: --IF l_dep_match_flag <> FTE_CAT_VALIDATE_PKG.G_MATCH_WITH_DEP_DATE
289: IF p_current_stop_rec.planned_departure_date
290: <> p_schedule_start_datetime
291: THEN
292: --{

Line 308: FTE_CAT_VALIDATE_PKG.Validate_Loc_To_Region

304: IF p_trip_segment_rec.lane_id IS NOT NULL
305: AND p_stop_validation_ctrl_rec.location_lane_check
306: THEN
307: --{
308: FTE_CAT_VALIDATE_PKG.Validate_Loc_To_Region
309: (
310: p_lane_id => p_trip_segment_rec.lane_id,
311: p_location_id => p_current_stop_rec.stop_location_id,
312: p_search_criteria => 'O',

Line 320: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_Loc_to_Region',

316: --
317: --
318: FTE_MLS_UTIL.api_post_call
319: (
320: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_Loc_to_Region',
321: p_api_return_status => l_return_status,
322: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
323: p_trip_segment_id => p_trip_segment_rec.trip_id,
324: p_trip_segment_name => p_trip_segment_rec.name,

Line 527: FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date

523: AND p_stop_validation_ctrl_rec.datetime_schedule_check
524: THEN
525: --{
526: /*
527: FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date
528: (
529: p_lane_id => p_trip_segment_rec.lane_id,
530: p_schedule_id => p_trip_segment_rec.schedule_id,
531: p_departure_date => p_current_stop_rec.planned_departure_date,

Line 541: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date',

537: --
538: --
539: FTE_MLS_UTIL.api_post_call
540: (
541: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date',
542: p_api_return_status => l_return_status,
543: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
544: p_trip_segment_id => p_trip_segment_rec.trip_id,
545: p_trip_segment_name => p_trip_segment_rec.name,

Line 563: --IF l_arr_match_flag <> FTE_CAT_VALIDATE_PKG.G_MATCH_WITH_ARR_DATE

559: END IF;
560: */
561: --
562: --
563: --IF l_arr_match_flag <> FTE_CAT_VALIDATE_PKG.G_MATCH_WITH_ARR_DATE
564: IF p_current_stop_rec.planned_arrival_date
565: <> p_schedule_end_datetime
566: THEN
567: --{

Line 583: FTE_CAT_VALIDATE_PKG.Validate_Loc_To_Region

579: IF p_trip_segment_rec.lane_id IS NOT NULL
580: AND p_stop_validation_ctrl_rec.location_lane_check
581: THEN
582: --{
583: FTE_CAT_VALIDATE_PKG.Validate_Loc_To_Region
584: (
585: p_lane_id => p_trip_segment_rec.lane_id,
586: p_location_id => p_current_stop_rec.stop_location_id,
587: p_search_criteria => 'D',

Line 595: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_Loc_to_Region',

591: --
592: --
593: FTE_MLS_UTIL.api_post_call
594: (
595: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_Loc_to_Region',
596: p_api_return_status => l_return_status,
597: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
598: p_trip_segment_id => p_trip_segment_rec.trip_id,
599: p_trip_segment_name => p_trip_segment_rec.name,

Line 792: FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date

788: AND p_stop_validation_ctrl_rec.datetime_schedule_check
789: THEN
790: --{
791: /*
792: FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date
793: (
794: p_lane_id => p_trip_segment_rec.lane_id,
795: p_schedule_id => p_trip_segment_rec.schedule_id,
796: p_departure_date => p_current_stop_rec.planned_departure_date,

Line 806: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date',

802: --
803: --
804: FTE_MLS_UTIL.api_post_call
805: (
806: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_Schedule_Date',
807: p_api_return_status => l_return_status,
808: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
809: p_trip_segment_id => p_trip_segment_rec.trip_id,
810: p_trip_segment_name => p_trip_segment_rec.name,

Line 828: --IF l_dep_match_flag <> FTE_CAT_VALIDATE_PKG.G_BETWEEN_DATES

824: END IF;
825: */
826: --
827: --
828: --IF l_dep_match_flag <> FTE_CAT_VALIDATE_PKG.G_BETWEEN_DATES
829: IF p_current_stop_rec.planned_departure_date
830: NOT BETWEEN p_schedule_start_datetime
831: AND p_schedule_end_datetime
832: THEN

Line 851: --IF l_arr_match_flag <> FTE_CAT_VALIDATE_PKG.G_BETWEEN_DATES

847: --}
848: END IF;
849: --
850: --
851: --IF l_arr_match_flag <> FTE_CAT_VALIDATE_PKG.G_BETWEEN_DATES
852: IF p_current_stop_rec.planned_arrival_date
853: NOT BETWEEN p_schedule_start_datetime
854: AND p_schedule_end_datetime
855: THEN

Line 880: FTE_CAT_VALIDATE_PKG.Validate_Loc_To_Region

876: IF p_trip_segment_rec.lane_id IS NOT NULL
877: AND p_stop_validation_ctrl_rec.location_lane_check
878: THEN
879: --{
880: FTE_CAT_VALIDATE_PKG.Validate_Loc_To_Region
881: (
882: p_lane_id => p_trip_segment_rec.lane_id,
883: p_location_id => p_current_stop_rec.stop_location_id,
884: p_search_criteria => 'A',

Line 892: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_loc_to_region',

888: --
889: --
890: FTE_MLS_UTIL.api_post_call
891: (
892: p_api_name => 'FTE_CAT_VALIDATE_PKG.Validate_loc_to_region',
893: p_api_return_status => l_return_status,
894: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',
895: p_trip_segment_id => p_trip_segment_rec.trip_id,
896: p_trip_segment_name => p_trip_segment_rec.name,