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.AHL_UA_UNIT_SCHEDULES_PVT dependencies on AHL_UA_COMMON_PVT

Line 768: l_event_schedule_tbl AHL_UA_COMMON_PVT.Event_schedule_Tbl_type;

764: l_api_version CONSTANT NUMBER := 1.0;
765: L_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
766:
767: -- Variable to hold all the events in the time slot
768: l_event_schedule_tbl AHL_UA_COMMON_PVT.Event_schedule_Tbl_type;
769: -- to store the flight record
770: l_flight_schedule_rec AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
771: -- to store fetched visit record
772: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;

Line 942: ----dbms_output.put_line('Calling AHL_UA_COMMON_PVT.get_all_events');

938: END IF;
939: -- initialize header level conflict and Maintenance Opportunity related flags with default values
940: p_x_MEvent_Header_Rec.HAS_CONFLICT := FND_API.G_FALSE;
941: p_x_MEvent_Header_Rec.HAS_MOPPORTUNITY := FND_API.G_FALSE;
942: ----dbms_output.put_line('Calling AHL_UA_COMMON_PVT.get_all_events');
943: -- Get all the events in the time slot
944: AHL_UA_COMMON_PVT.get_all_events(
945: p_api_version => 1.0 ,
946: x_return_status => x_return_status,

Line 944: AHL_UA_COMMON_PVT.get_all_events(

940: p_x_MEvent_Header_Rec.HAS_CONFLICT := FND_API.G_FALSE;
941: p_x_MEvent_Header_Rec.HAS_MOPPORTUNITY := FND_API.G_FALSE;
942: ----dbms_output.put_line('Calling AHL_UA_COMMON_PVT.get_all_events');
943: -- Get all the events in the time slot
944: AHL_UA_COMMON_PVT.get_all_events(
945: p_api_version => 1.0 ,
946: x_return_status => x_return_status,
947: x_msg_count => x_msg_count,
948: x_msg_data => x_msg_data,

Line 956: ----dbms_output.put_line('Unexpected error : AHL_UA_COMMON_PVT.get_all_events returned errors');

952: p_use_actuals => G_USE_ACTUALS,
953: x_event_schedules => l_event_schedule_tbl);
954: -- Check for API errors
955: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
956: ----dbms_output.put_line('Unexpected error : AHL_UA_COMMON_PVT.get_all_events returned errors');
957: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
958: fnd_log.string
959: (
960: fnd_log.level_error,

Line 962: 'Unexpected error : AHL_UA_COMMON_PVT.get_all_events returned errors'

958: fnd_log.string
959: (
960: fnd_log.level_error,
961: L_DEBUG_MODULE,
962: 'Unexpected error : AHL_UA_COMMON_PVT.get_all_events returned errors'
963: );
964: END IF;
965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
966: END IF;

Line 976: AHL_UA_COMMON_PVT.Get_Prec_Flight_Info

972: p_x_MEvent_Header_Rec.EVENT_COUNT := l_event_schedule_tbl.COUNT;
973: END IF;
974:
975: -- Get previous flight information in all cases
976: AHL_UA_COMMON_PVT.Get_Prec_Flight_Info
977: (
978: p_api_version => 1.0,
979: x_return_status => x_return_status,
980: x_msg_count => x_msg_count,

Line 991: ----dbms_output.put_line('Unexpected error : AHL_UA_COMMON_PVT.Get_Prec_Flight_Info returned errors');

987:
988: );
989: -- Check for API errors
990: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
991: ----dbms_output.put_line('Unexpected error : AHL_UA_COMMON_PVT.Get_Prec_Flight_Info returned errors');
992: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
993: fnd_log.string
994: (
995: fnd_log.level_error,

Line 997: 'Unexpected error : AHL_UA_COMMON_PVT.Get_Prec_Flight_Info returned errors'

993: fnd_log.string
994: (
995: fnd_log.level_error,
996: L_DEBUG_MODULE,
997: 'Unexpected error : AHL_UA_COMMON_PVT.Get_Prec_Flight_Info returned errors'
998: );
999: END IF;
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END IF;

Line 1016: AHL_UA_COMMON_PVT.Get_Prec_Event_Info

1012: p_x_MEvent_Header_Rec.EVENT_COUNT = 0 OR
1013: (p_module_type <> 'US' and l_event_schedule_tbl(l_event_schedule_tbl.FIRST).EVENT_START_TIME >= p_x_MEvent_Header_Rec.START_TIME) OR
1014: (p_module_type = 'US' and l_event_schedule_tbl(l_event_schedule_tbl.FIRST).EVENT_START_TIME > p_x_MEvent_Header_Rec.START_TIME)
1015: ) THEN
1016: AHL_UA_COMMON_PVT.Get_Prec_Event_Info
1017: (
1018: p_api_version => 1.0,
1019: x_return_status => x_return_status,
1020: x_msg_count => x_msg_count,

Line 1033: ----dbms_output.put_line('Unexpected error : AHL_UA_COMMON_PVT.Get_Prec_Visit_Info returned errors');

1029:
1030: );
1031: -- Check for API errors
1032: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1033: ----dbms_output.put_line('Unexpected error : AHL_UA_COMMON_PVT.Get_Prec_Visit_Info returned errors');
1034: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1035: fnd_log.string
1036: (
1037: fnd_log.level_error,

Line 1039: 'Unexpected error : AHL_UA_COMMON_PVT.Get_Prec_Event_Info returned errors'

1035: fnd_log.string
1036: (
1037: fnd_log.level_error,
1038: L_DEBUG_MODULE,
1039: 'Unexpected error : AHL_UA_COMMON_PVT.Get_Prec_Event_Info returned errors'
1040: );
1041: END IF;
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043: END IF;

Line 1194: AHL_UA_COMMON_PVT.Get_Succ_Event_Info

1190: NVL(l_event_schedule_tbl(l_event_schedule_tbl.LAST).EVENT_END_TIME,
1191: l_event_schedule_tbl(l_event_schedule_tbl.LAST).EVENT_START_TIME + 1/1440 )< p_x_MEvent_Header_Rec.END_TIME) THEN
1192: -- populate previous event information
1193: -- get previous flight information
1194: AHL_UA_COMMON_PVT.Get_Succ_Event_Info
1195: (
1196: p_api_version => 1.0,
1197: x_return_status => x_return_status,
1198: x_msg_count => x_msg_count,

Line 1211: ----dbms_output.put_line('Unexpected error : AHL_UA_COMMON_PVT.Get_Succ_Event_Info returned errors');

1207:
1208: );
1209: -- Check for API errors
1210: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1211: ----dbms_output.put_line('Unexpected error : AHL_UA_COMMON_PVT.Get_Succ_Event_Info returned errors');
1212: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1213: fnd_log.string
1214: (
1215: fnd_log.level_error,

Line 1217: 'Unexpected error : AHL_UA_COMMON_PVT.Get_Succ_Event_Info returned errors'

1213: fnd_log.string
1214: (
1215: fnd_log.level_error,
1216: L_DEBUG_MODULE,
1217: 'Unexpected error : AHL_UA_COMMON_PVT.Get_Succ_Event_Info returned errors'
1218: );
1219: END IF;
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;

Line 2124: -- Call AHL_UA_COMMON_PVT.Get_Prec_Event_Info to retrieve details of the previous event (visit / flight) and conflicts, if any

2120: 'Basic validations done'
2121: );
2122: END IF;
2123:
2124: -- Call AHL_UA_COMMON_PVT.Get_Prec_Event_Info to retrieve details of the previous event (visit / flight) and conflicts, if any
2125: AHL_UA_COMMON_PVT.Get_Prec_Event_Info
2126: (
2127: p_api_version => 1.0,
2128: x_return_status => l_return_status,

Line 2125: AHL_UA_COMMON_PVT.Get_Prec_Event_Info

2121: );
2122: END IF;
2123:
2124: -- Call AHL_UA_COMMON_PVT.Get_Prec_Event_Info to retrieve details of the previous event (visit / flight) and conflicts, if any
2125: AHL_UA_COMMON_PVT.Get_Prec_Event_Info
2126: (
2127: p_api_version => 1.0,
2128: x_return_status => l_return_status,
2129: x_msg_count => l_msg_count,

Line 2146: 'After calling AHL_UA_COMMON_PVT.Get_Prec_Event_Info [x_is_prec_conflict='||x_is_prec_conflict||']'

2142: fnd_log.string
2143: (
2144: fnd_log.level_statement,
2145: L_DEBUG_MODULE,
2146: 'After calling AHL_UA_COMMON_PVT.Get_Prec_Event_Info [x_is_prec_conflict='||x_is_prec_conflict||']'
2147: );
2148: END IF;
2149:
2150: -- Call AHL_UA_COMMON_PVT.Get_Succ_Event_Info to retrieve details of the next event (visit / flight) and conflicts, if any

Line 2150: -- Call AHL_UA_COMMON_PVT.Get_Succ_Event_Info to retrieve details of the next event (visit / flight) and conflicts, if any

2146: 'After calling AHL_UA_COMMON_PVT.Get_Prec_Event_Info [x_is_prec_conflict='||x_is_prec_conflict||']'
2147: );
2148: END IF;
2149:
2150: -- Call AHL_UA_COMMON_PVT.Get_Succ_Event_Info to retrieve details of the next event (visit / flight) and conflicts, if any
2151: AHL_UA_COMMON_PVT.Get_Succ_Event_Info
2152: (
2153: p_api_version => 1.0,
2154: x_return_status => l_return_status,

Line 2151: AHL_UA_COMMON_PVT.Get_Succ_Event_Info

2147: );
2148: END IF;
2149:
2150: -- Call AHL_UA_COMMON_PVT.Get_Succ_Event_Info to retrieve details of the next event (visit / flight) and conflicts, if any
2151: AHL_UA_COMMON_PVT.Get_Succ_Event_Info
2152: (
2153: p_api_version => 1.0,
2154: x_return_status => l_return_status,
2155: x_msg_count => l_msg_count,

Line 2174: 'After calling AHL_UA_COMMON_PVT.Get_Succ_Event_Info [x_is_succ_conflict='||x_is_succ_conflict||']'

2170: fnd_log.string
2171: (
2172: fnd_log.level_statement,
2173: L_DEBUG_MODULE,
2174: 'After calling AHL_UA_COMMON_PVT.Get_Succ_Event_Info [x_is_succ_conflict='||x_is_succ_conflict||']'
2175: );
2176: END IF;
2177: -- API body ends here
2178: