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_AVF_OPER_VSTS_PVT dependencies on AHL_VWP_VISITS_PVT

Line 1482: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;

1478: l_return_status VARCHAR2(1);
1479: l_init_msg_list VARCHAR2(10):= p_init_msg_list;
1480: l_visit_type VARCHAR2(40);
1481: l_visit_id NUMBER;
1482: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
1483: l_start_date DATE;
1484: l_end_date DATE;
1485: l_visit_type_duration NUMBER;
1486: l_visit_id2 NUMBER;

Line 1917: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);

1913: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1914: fnd_log.string
1915: ( fnd_log.level_procedure,
1916: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1917: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);
1918: END IF;
1919: AHL_VWP_VISITS_PVT.Update_Visit (
1920: p_api_version => l_api_version,
1921: p_init_msg_list => Fnd_Api.g_false,

Line 1919: AHL_VWP_VISITS_PVT.Update_Visit (

1915: ( fnd_log.level_procedure,
1916: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1917: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);
1918: END IF;
1919: AHL_VWP_VISITS_PVT.Update_Visit (
1920: p_api_version => l_api_version,
1921: p_init_msg_list => Fnd_Api.g_false,
1922: p_commit => Fnd_Api.g_false,
1923: p_validation_level => p_validation_level,

Line 1935: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

1931: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1932: fnd_log.string
1933: ( fnd_log.level_procedure,
1934: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1935: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
1936: END IF;
1937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1938: x_msg_count := FND_MSG_PUB.count_msg;
1939: IF (l_log_statement >= l_log_current_level) THEN

Line 2164: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);

2160: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2161: fnd_log.string
2162: ( fnd_log.level_procedure,
2163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2164: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);
2165: END IF;
2166: AHL_VWP_VISITS_PVT.Update_Visit (
2167: p_api_version => l_api_version,
2168: p_init_msg_list => Fnd_Api.g_false,

Line 2166: AHL_VWP_VISITS_PVT.Update_Visit (

2162: ( fnd_log.level_procedure,
2163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2164: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);
2165: END IF;
2166: AHL_VWP_VISITS_PVT.Update_Visit (
2167: p_api_version => l_api_version,
2168: p_init_msg_list => Fnd_Api.g_false,
2169: p_commit => Fnd_Api.g_false,
2170: p_validation_level => p_validation_level,

Line 2182: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

2178: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2179: fnd_log.string
2180: ( fnd_log.level_procedure,
2181: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2182: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
2183: END IF;
2184: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2185: x_msg_count := FND_MSG_PUB.count_msg;
2186: IF (l_log_statement >= l_log_current_level) THEN

Line 2753: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

2749: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2750: fnd_log.string
2751: ( fnd_log.level_procedure,
2752: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2753: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
2754: END IF;
2755: AHL_VWP_VISITS_PVT.Update_Visit (
2756: p_api_version => l_api_version,
2757: p_init_msg_list => Fnd_Api.g_false,

Line 2755: AHL_VWP_VISITS_PVT.Update_Visit (

2751: ( fnd_log.level_procedure,
2752: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2753: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
2754: END IF;
2755: AHL_VWP_VISITS_PVT.Update_Visit (
2756: p_api_version => l_api_version,
2757: p_init_msg_list => Fnd_Api.g_false,
2758: p_commit => Fnd_Api.g_false,
2759: p_validation_level => p_validation_level,

Line 2771: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

2767: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2768: fnd_log.string
2769: ( fnd_log.level_procedure,
2770: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2771: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
2772: END IF;
2773: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2774: x_msg_count := FND_MSG_PUB.count_msg;
2775: IF (l_log_statement >= l_log_current_level) THEN

Line 2906: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

2902: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2903: fnd_log.string
2904: ( fnd_log.level_procedure,
2905: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2906: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
2907: END IF;
2908: AHL_VWP_VISITS_PVT.Update_Visit (
2909: p_api_version => l_api_version,
2910: p_init_msg_list => Fnd_Api.g_false,

Line 2908: AHL_VWP_VISITS_PVT.Update_Visit (

2904: ( fnd_log.level_procedure,
2905: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2906: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
2907: END IF;
2908: AHL_VWP_VISITS_PVT.Update_Visit (
2909: p_api_version => l_api_version,
2910: p_init_msg_list => Fnd_Api.g_false,
2911: p_commit => Fnd_Api.g_false,
2912: p_validation_level => p_validation_level,

Line 2924: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

2920: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2921: fnd_log.string
2922: ( fnd_log.level_procedure,
2923: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2924: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
2925: END IF;
2926: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2927: x_msg_count := FND_MSG_PUB.count_msg;
2928: IF (l_log_statement >= l_log_current_level) THEN

Line 3106: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

3102: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3103: fnd_log.string
3104: ( fnd_log.level_procedure,
3105: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3106: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3107: END IF;
3108: AHL_VWP_VISITS_PVT.Update_Visit (
3109: p_api_version => l_api_version,
3110: p_init_msg_list => Fnd_Api.g_false,

Line 3108: AHL_VWP_VISITS_PVT.Update_Visit (

3104: ( fnd_log.level_procedure,
3105: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3106: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3107: END IF;
3108: AHL_VWP_VISITS_PVT.Update_Visit (
3109: p_api_version => l_api_version,
3110: p_init_msg_list => Fnd_Api.g_false,
3111: p_commit => Fnd_Api.g_false,
3112: p_validation_level => p_validation_level,

Line 3124: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

3120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3121: fnd_log.string
3122: ( fnd_log.level_procedure,
3123: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3124: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3125: END IF;
3126: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3127: x_msg_count := FND_MSG_PUB.count_msg;
3128: IF (l_log_statement >= l_log_current_level) THEN

Line 3345: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

3341: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3342: fnd_log.string
3343: ( fnd_log.level_procedure,
3344: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3345: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3346: END IF;
3347: AHL_VWP_VISITS_PVT.Update_Visit (
3348: p_api_version => l_api_version,
3349: p_init_msg_list => Fnd_Api.g_false,

Line 3347: AHL_VWP_VISITS_PVT.Update_Visit (

3343: ( fnd_log.level_procedure,
3344: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3345: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3346: END IF;
3347: AHL_VWP_VISITS_PVT.Update_Visit (
3348: p_api_version => l_api_version,
3349: p_init_msg_list => Fnd_Api.g_false,
3350: p_commit => Fnd_Api.g_false,
3351: p_validation_level => p_validation_level,

Line 3363: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

3359: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3360: fnd_log.string
3361: ( fnd_log.level_procedure,
3362: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3363: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3364: END IF;
3365: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3366: x_msg_count := FND_MSG_PUB.count_msg;
3367: IF (l_log_statement >= l_log_current_level) THEN

Line 3816: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

3812: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3813: fnd_log.string
3814: ( fnd_log.level_procedure,
3815: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3816: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3817: END IF;
3818: AHL_VWP_VISITS_PVT.Update_Visit (
3819: p_api_version => l_api_version,
3820: p_init_msg_list => Fnd_Api.g_false,

Line 3818: AHL_VWP_VISITS_PVT.Update_Visit (

3814: ( fnd_log.level_procedure,
3815: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3816: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3817: END IF;
3818: AHL_VWP_VISITS_PVT.Update_Visit (
3819: p_api_version => l_api_version,
3820: p_init_msg_list => Fnd_Api.g_false,
3821: p_commit => Fnd_Api.g_false,
3822: p_validation_level => p_validation_level,

Line 3834: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

3830: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3831: fnd_log.string
3832: ( fnd_log.level_procedure,
3833: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3834: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3835: END IF;
3836: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3837: x_msg_count := FND_MSG_PUB.count_msg;
3838: IF (l_log_statement >= l_log_current_level) THEN

Line 3964: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

3960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3961: fnd_log.string
3962: ( fnd_log.level_procedure,
3963: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3964: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3965: END IF;
3966: AHL_VWP_VISITS_PVT.Update_Visit (
3967: p_api_version => l_api_version,
3968: p_init_msg_list => Fnd_Api.g_false,

Line 3966: AHL_VWP_VISITS_PVT.Update_Visit (

3962: ( fnd_log.level_procedure,
3963: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3964: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3965: END IF;
3966: AHL_VWP_VISITS_PVT.Update_Visit (
3967: p_api_version => l_api_version,
3968: p_init_msg_list => Fnd_Api.g_false,
3969: p_commit => Fnd_Api.g_false,
3970: p_validation_level => p_validation_level,

Line 3982: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

3978: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3979: fnd_log.string
3980: ( fnd_log.level_procedure,
3981: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3982: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3983: END IF;
3984: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3985: x_msg_count := FND_MSG_PUB.count_msg;
3986: IF (l_log_statement >= l_log_current_level) THEN

Line 4165: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;

4161:
4162: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Departure_visit';
4163: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
4164: l_visit_type_duration NUMBER;
4165: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
4166: l_is_org_in_curr_OU VARCHAR2(1);
4167: l_visit_number NUMBER;
4168: l_start_date_ts TIMESTAMP;
4169: l_end_date_ts TIMESTAMP;

Line 4266: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);

4262: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4263: fnd_log.string
4264: ( fnd_log.level_procedure,
4265: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4266: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4267: END IF;
4268: AHL_VWP_VISITS_PVT.Create_Visit (
4269: p_api_version => 1.0,
4270: p_module_type => 'API',

Line 4268: AHL_VWP_VISITS_PVT.Create_Visit (

4264: ( fnd_log.level_procedure,
4265: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4266: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4267: END IF;
4268: AHL_VWP_VISITS_PVT.Create_Visit (
4269: p_api_version => 1.0,
4270: p_module_type => 'API',
4271: p_x_visit_rec => l_visit_rec,
4272: x_return_status => l_return_status,

Line 4281: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

4277: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4278: fnd_log.string
4279: ( fnd_log.level_procedure,
4280: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4281: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
4282: END IF;
4283:
4284: -- SATRAJEN :: Bug 14336467 :: Prevent Erroring out when the called from Operational Visit Procedure. :: START
4285: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 4425: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;

4421:
4422: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Arrival_visit';
4423: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
4424: l_visit_type_duration NUMBER;
4425: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
4426: l_is_org_in_curr_OU VARCHAR2(1);
4427: l_visit_number NUMBER;
4428: l_start_date_ts TIMESTAMP;
4429: l_end_date_ts TIMESTAMP;

Line 4524: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);

4520: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4521: fnd_log.string
4522: ( fnd_log.level_procedure,
4523: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4524: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4525: END IF;
4526: AHL_VWP_VISITS_PVT.Create_Visit (
4527: p_api_version => 1.0,
4528: p_module_type => 'API',

Line 4526: AHL_VWP_VISITS_PVT.Create_Visit (

4522: ( fnd_log.level_procedure,
4523: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4524: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4525: END IF;
4526: AHL_VWP_VISITS_PVT.Create_Visit (
4527: p_api_version => 1.0,
4528: p_module_type => 'API',
4529: p_x_visit_rec => l_visit_rec,
4530: x_return_status => l_return_status,

Line 4539: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

4535: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4536: fnd_log.string
4537: ( fnd_log.level_procedure,
4538: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4539: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
4540: END IF;
4541: -- SATRAJEN :: Bug 14336467 :: Prevent Erroring out when the called from Operational Visit Procedure. :: START
4542: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4543: l_pub_msg := FND_MSG_PUB.Get_Detail (p_msg_index => FND_MSG_PUB.G_LAST);

Line 4689: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;

4685: flt_dets_rec get_flight_details%RowType;
4686:
4687: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Downtime_visit';
4688: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
4689: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
4690: l_is_org_in_curr_OU VARCHAR2(1);
4691: l_visit_number NUMBER;
4692: l_start_date_ts TIMESTAMP;
4693: l_end_date_ts TIMESTAMP;

Line 4812: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);

4808: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4809: fnd_log.string
4810: ( fnd_log.level_procedure,
4811: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4812: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4813: END IF;
4814: AHL_VWP_VISITS_PVT.Create_Visit (
4815: p_api_version => 1.0,
4816: p_module_type => 'API',

Line 4814: AHL_VWP_VISITS_PVT.Create_Visit (

4810: ( fnd_log.level_procedure,
4811: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4812: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4813: END IF;
4814: AHL_VWP_VISITS_PVT.Create_Visit (
4815: p_api_version => 1.0,
4816: p_module_type => 'API',
4817: p_x_visit_rec => l_visit_rec,
4818: x_return_status => l_return_status,

Line 4827: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

4823: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4824: fnd_log.string
4825: ( fnd_log.level_procedure,
4826: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4827: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
4828: END IF;
4829:
4830: -- SATRAJEN :: Bug 14336467 :: Prevent Erroring out when the called from Operational Visit Procedure. :: START
4831: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 4953: 'Before calling AHL_VWP_VISITS_PVT.Delete_Visit, visit id: '||p_visit_id);

4949: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4950: fnd_log.string
4951: ( fnd_log.level_procedure,
4952: L_DEBUG_KEY||'.begin',
4953: 'Before calling AHL_VWP_VISITS_PVT.Delete_Visit, visit id: '||p_visit_id);
4954: END IF;
4955:
4956: -- PRAKKUM :: Bug 14334961 :: 18/07/2012 :: Get planned ues before deleting the visit
4957: --Get all the planned ue ids for this visit so as to pass it to notification

Line 4967: AHL_VWP_VISITS_PVT.Delete_Visit (

4963: l_ue_ids := l_ue_ids || ',' || to_char(l_planned_ue_id_rec.unit_effectivity_id);
4964: END IF;
4965: END LOOP;
4966:
4967: AHL_VWP_VISITS_PVT.Delete_Visit (
4968: p_api_version => 1.0,
4969: p_visit_id => p_visit_id,
4970: x_return_status => l_return_status,
4971: x_msg_count => l_msg_count,

Line 4979: 'After calling AHL_VWP_VISITS_PVT.Delete_Visit, l_return_status= '||l_return_status);

4975: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4976: fnd_log.string
4977: ( fnd_log.level_procedure,
4978: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4979: 'After calling AHL_VWP_VISITS_PVT.Delete_Visit, l_return_status= '||l_return_status);
4980: END IF;
4981: x_return_status := l_return_status ;
4982: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4983: l_msg_count := FND_MSG_PUB.count_msg;