APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on AHL_VWP_VISITS_PVT

Line 44: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;

40: arrival_time DATE
41: );
42: TYPE pre_us_tbl_type IS TABLE OF pre_us_rec_type INDEX BY BINARY_INTEGER;
43:
44: l_visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type;
45: l_visit_count NUMBER;
46:
47: CURSOR get_flight_visit
48: (

Line 2119: AHL_VWP_VISITS_PVT.DELETE_FLIGHT_ASSOC(

2115:
2116: THEN
2117: -- Bug # 9075539 -- start
2118: -- delete all associations of the flight schedule to its own transit visits
2119: AHL_VWP_VISITS_PVT.DELETE_FLIGHT_ASSOC(
2120: p_visit_sync_rec.UNIT_SCHEDULE_ID,
2121: x_return_status
2122: );
2123: -- Bug # 9075539 -- end

Line 2131: AHL_VWP_VISITS_PVT.Process_Visit (

2127: END LOOP;
2128:
2129: CLOSE get_flight_visit;
2130:
2131: AHL_VWP_VISITS_PVT.Process_Visit (
2132: p_api_version => 1.0,
2133: p_init_msg_list => FND_API.g_false,
2134: p_commit => FND_API.g_false,
2135: p_validation_level => FND_API.g_valid_level_full,

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

2147: fnd_log.string
2148: (
2149: fnd_log.level_exception,
2150: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2151: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'
2152: );
2153: END IF;
2154: -- fix for bug 13866936
2155: -- RAISE FND_API.G_EXC_ERROR;

Line 2163: 'AHL_VWP_VISITS_PVT.Process_Visit returned with un-expected error..'

2159: fnd_log.string
2160: (
2161: fnd_log.level_exception,
2162: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2163: 'AHL_VWP_VISITS_PVT.Process_Visit returned with un-expected error..'
2164: );
2165: END IF;
2166: -- fix for bug 13866936
2167: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3186: AHL_VWP_VISITS_PVT.DELETE_FLIGHT_ASSOC(

3182: END LOOP;
3183: CLOSE get_flight_visit;
3184:
3185: -- delete all associations of the flight schedule to its own transit visits
3186: AHL_VWP_VISITS_PVT.DELETE_FLIGHT_ASSOC(
3187: p_x_flight_schedules_tbl(i).unit_schedule_id,
3188: x_return_status
3189: );
3190:

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

3194: fnd_log.string
3195: (
3196: fnd_log.level_exception,
3197: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3198: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'
3199: );
3200: END IF;
3201: RAISE FND_API.G_EXC_ERROR;
3202: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3241: AHL_VWP_VISITS_PVT.Process_Visit (

3237: )
3238: THEN
3239:
3240: -- delete the transit visits found
3241: AHL_VWP_VISITS_PVT.Process_Visit (
3242: p_api_version => 1.0,
3243: p_init_msg_list => FND_API.g_false,
3244: p_commit => FND_API.g_false,
3245: p_validation_level => FND_API.g_valid_level_full,

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

3256: fnd_log.string
3257: (
3258: fnd_log.level_exception,
3259: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3260: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'
3261: );
3262: END IF;
3263: -- fix for bug 13866936
3264: -- RAISE FND_API.G_EXC_ERROR;

Line 3272: 'AHL_VWP_VISITS_PVT.Process_Visit returned with un-expected error..'

3268: fnd_log.string
3269: (
3270: fnd_log.level_exception,
3271: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3272: 'AHL_VWP_VISITS_PVT.Process_Visit returned with un-expected error..'
3273: );
3274: END IF;
3275: -- fix for bug 13866936
3276: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;