APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on AHL_VWP_VISITS_PVT

Line 32: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

28: TYPE pre_us_tbl_type IS TABLE OF pre_us_rec_type INDEX BY BINARY_INTEGER;
29:
30: G_PKG_NAME VARCHAR2(30):='AHL_UA_FLIGHT_SCHEDULES_PVT';
31:
32: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
33: l_visit_count NUMBER;
34:
35: CURSOR get_flight_visit
36: (

Line 1717: AHL_VWP_VISITS_PVT.Process_Visit (

1713: END LOOP;
1714:
1715: CLOSE get_flight_visit;
1716:
1717: AHL_VWP_VISITS_PVT.Process_Visit (
1718: p_api_version => 1.0,
1719: p_init_msg_list => FND_API.g_false,
1720: p_commit => FND_API.g_false,
1721: p_validation_level => FND_API.g_valid_level_full,

Line 1737: ' AHL_VWP_VISITS_PVT.Process_Visit returned errors'

1733: fnd_log.string
1734: (
1735: fnd_log.level_statement,
1736: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1737: ' AHL_VWP_VISITS_PVT.Process_Visit returned errors'
1738: );
1739: END IF;
1740: ELSE
1741: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 1746: ' AHL_VWP_VISITS_PVT.Process_Visit executed successfully'

1742: fnd_log.string
1743: (
1744: fnd_log.level_statement,
1745: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1746: ' AHL_VWP_VISITS_PVT.Process_Visit executed successfully'
1747: );
1748: END IF;
1749: END IF;
1750:

Line 2664: AHL_VWP_VISITS_PVT.DELETE_FLIGHT_ASSOC(

2660: END LOOP;
2661: CLOSE get_flight_visit;
2662:
2663: -- delete all associations of the flight schedule to its own transit visits
2664: AHL_VWP_VISITS_PVT.DELETE_FLIGHT_ASSOC(
2665: p_x_flight_schedules_tbl(i).unit_schedule_id,
2666: x_return_status
2667: );
2668:

Line 2676: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'

2672: fnd_log.string
2673: (
2674: fnd_log.level_exception,
2675: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2676: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'
2677: );
2678: END IF;
2679: RAISE FND_API.G_EXC_ERROR;
2680: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2693: AHL_VWP_VISITS_PVT.Process_Visit (

2689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2690: END IF;
2691:
2692: -- delete the transit visits found
2693: AHL_VWP_VISITS_PVT.Process_Visit (
2694: p_api_version => 1.0,
2695: p_init_msg_list => FND_API.g_false,
2696: p_commit => FND_API.g_false,
2697: p_validation_level => FND_API.g_valid_level_full,

Line 2713: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'

2709: fnd_log.string
2710: (
2711: fnd_log.level_exception,
2712: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2713: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'
2714: );
2715: END IF;
2716: RAISE FND_API.G_EXC_ERROR;
2717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN