DBA Data[Home] [Help]

APPS.AHL_UA_FLIGHT_SCHEDULES_PUB dependencies on AHL_VWP_VISITS_PVT

Line 1024: l_x_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;

1020: x_msg_count OUT NOCOPY NUMBER,
1021: x_msg_data OUT NOCOPY VARCHAR2
1022: )
1023: IS
1024: l_x_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
1025: l_x_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
1026: l_is_conflict VARCHAR2(1);
1027: l_x_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
1028: i NUMBER;

Line 1025: l_x_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

1021: x_msg_data OUT NOCOPY VARCHAR2
1022: )
1023: IS
1024: l_x_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
1025: l_x_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
1026: l_is_conflict VARCHAR2(1);
1027: l_x_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
1028: i NUMBER;
1029: j NUMBER;

Line 1251: 'Calling AHL_VWP_VISITS_PVT.Process_Visit'

1247: fnd_log.string
1248: (
1249: fnd_log.level_statement,
1250: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1251: 'Calling AHL_VWP_VISITS_PVT.Process_Visit'
1252: );
1253: END IF;
1254:
1255: AHL_VWP_VISITS_PVT.Process_Visit (

Line 1255: AHL_VWP_VISITS_PVT.Process_Visit (

1251: 'Calling AHL_VWP_VISITS_PVT.Process_Visit'
1252: );
1253: END IF;
1254:
1255: AHL_VWP_VISITS_PVT.Process_Visit (
1256: p_api_version => 1.0,
1257: p_init_msg_list => FND_API.G_FALSE,
1258: p_commit => FND_API.G_FALSE,
1259: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1272: 'After calling AHL_VWP_VISITS_PVT.Process_Visit'

1268: fnd_log.string
1269: (
1270: fnd_log.level_statement,
1271: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1272: 'After calling AHL_VWP_VISITS_PVT.Process_Visit'
1273: );
1274: END IF;
1275:
1276: -- Check Error Message stack.

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

1279: fnd_log.string
1280: (
1281: fnd_log.level_error,
1282: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1283: 'AHL_VWP_VISITS_PVT.Process_Visit API raised expected error....'
1284: );
1285: END IF;
1286: RAISE FND_API.G_EXC_ERROR;
1287: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

1289: fnd_log.string
1290: (
1291: fnd_log.level_error,
1292: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1293: 'AHL_VWP_VISITS_PVT.Process_Visit API raised unexpected error....'
1294: );
1295: END IF;
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: END IF;