DBA Data[Home] [Help]

APPS.AHL_UA_FLIGHT_SCHEDULES_PUB dependencies on AHL_VWP_VISITS_PVT

Line 993: l_x_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;

989: x_msg_count OUT NOCOPY NUMBER,
990: x_msg_data OUT NOCOPY VARCHAR2
991: )
992: IS
993: l_x_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
994: l_x_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
995: l_is_conflict VARCHAR2(1);
996: l_x_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
997: i NUMBER;

Line 994: l_x_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

990: x_msg_data OUT NOCOPY VARCHAR2
991: )
992: IS
993: l_x_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
994: l_x_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
995: l_is_conflict VARCHAR2(1);
996: l_x_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
997: i NUMBER;
998: j NUMBER;

Line 1220: 'Calling AHL_VWP_VISITS_PVT.Process_Visit'

1216: fnd_log.string
1217: (
1218: fnd_log.level_statement,
1219: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1220: 'Calling AHL_VWP_VISITS_PVT.Process_Visit'
1221: );
1222: END IF;
1223:
1224: AHL_VWP_VISITS_PVT.Process_Visit (

Line 1224: AHL_VWP_VISITS_PVT.Process_Visit (

1220: 'Calling AHL_VWP_VISITS_PVT.Process_Visit'
1221: );
1222: END IF;
1223:
1224: AHL_VWP_VISITS_PVT.Process_Visit (
1225: p_api_version => 1.0,
1226: p_init_msg_list => FND_API.G_FALSE,
1227: p_commit => FND_API.G_FALSE,
1228: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1241: 'After calling AHL_VWP_VISITS_PVT.Process_Visit'

1237: fnd_log.string
1238: (
1239: fnd_log.level_statement,
1240: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1241: 'After calling AHL_VWP_VISITS_PVT.Process_Visit'
1242: );
1243: END IF;
1244:
1245: -- Check Error Message stack.

Line 1252: 'AHL_VWP_VISITS_PVT.Process_Visit API raised expected error....'

1248: fnd_log.string
1249: (
1250: fnd_log.level_error,
1251: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1252: 'AHL_VWP_VISITS_PVT.Process_Visit API raised expected error....'
1253: );
1254: END IF;
1255: RAISE FND_API.G_EXC_ERROR;
1256: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1262: 'AHL_VWP_VISITS_PVT.Process_Visit API raised unexpected error....'

1258: fnd_log.string
1259: (
1260: fnd_log.level_error,
1261: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1262: 'AHL_VWP_VISITS_PVT.Process_Visit API raised unexpected error....'
1263: );
1264: END IF;
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: END IF;