DBA Data[Home] [Help]

APPS.AHL_UA_UNIT_SCHEDULES_PVT dependencies on AHL_UA_FLIGHT_SCHEDULES_PUB

Line 848: l_flight_search_rec AHL_UA_FLIGHT_SCHEDULES_PUB.FLIGHT_SEARCH_REC_TYPE;

844: l_is_org_in_user_ou VARCHAR2(1);
845:
846:
847: -- To search a flight record and hold search results
848: l_flight_search_rec AHL_UA_FLIGHT_SCHEDULES_PUB.FLIGHT_SEARCH_REC_TYPE;
849: l_flight_schedules_tbl AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE;
850:
851: -- early exit flag for module type 'US' processing
852: l_early_exit_flag BOOLEAN;

Line 1101: ----dbms_output.put_line('calling AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details for UNIT_SCHEDULE_ID : ' || l_flight_search_rec.UNIT_SCHEDULE_ID);

1097: FOR i IN l_event_schedule_tbl.FIRST..l_event_schedule_tbl.LAST LOOP
1098: IF(l_event_schedule_tbl(i).EVENT_TYPE = G_EVENT_TYPE_FLIGHT)THEN
1099: l_curr_event_type := G_EVENT_TYPE_FLIGHT;
1100: l_flight_search_rec.UNIT_SCHEDULE_ID := l_event_schedule_tbl(i).EVENT_ID;
1101: ----dbms_output.put_line('calling AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details for UNIT_SCHEDULE_ID : ' || l_flight_search_rec.UNIT_SCHEDULE_ID);
1102: AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details(
1103: p_api_version => 1.0,
1104: p_init_msg_list => FND_API.G_TRUE,
1105: p_commit => FND_API.G_FALSE,

Line 1102: AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details(

1098: IF(l_event_schedule_tbl(i).EVENT_TYPE = G_EVENT_TYPE_FLIGHT)THEN
1099: l_curr_event_type := G_EVENT_TYPE_FLIGHT;
1100: l_flight_search_rec.UNIT_SCHEDULE_ID := l_event_schedule_tbl(i).EVENT_ID;
1101: ----dbms_output.put_line('calling AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details for UNIT_SCHEDULE_ID : ' || l_flight_search_rec.UNIT_SCHEDULE_ID);
1102: AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details(
1103: p_api_version => 1.0,
1104: p_init_msg_list => FND_API.G_TRUE,
1105: p_commit => FND_API.G_FALSE,
1106: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1117: ----dbms_output.put_line('Unexpected error : AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details returned error');

1113: x_flight_schedules_tbl => l_flight_schedules_tbl
1114: );
1115: -- Check for API errors
1116: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1117: ----dbms_output.put_line('Unexpected error : AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details returned error');
1118: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1119: fnd_log.string
1120: (
1121: fnd_log.level_error,

Line 1123: 'Unexpected error : AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details returned error'

1119: fnd_log.string
1120: (
1121: fnd_log.level_error,
1122: L_DEBUG_MODULE,
1123: 'Unexpected error : AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details returned error'
1124: );
1125: END IF;
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: END IF;