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_LTP_SIMUL_PLAN_PVT dependencies on AHL_LTP_SIMUL_PLAN_PVT

Line 1: PACKAGE BODY AHL_LTP_SIMUL_PLAN_PVT AS

1: PACKAGE BODY AHL_LTP_SIMUL_PLAN_PVT AS
2: /* $Header: AHLVSPNB.pls 120.5 2008/02/14 19:25:29 jaramana ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SIMUL_PLAN_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SIMUL_PLAN_PVT';

1: PACKAGE BODY AHL_LTP_SIMUL_PLAN_PVT AS
2: /* $Header: AHLVSPNB.pls 120.5 2008/02/14 19:25:29 jaramana ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SIMUL_PLAN_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: -----------------------------------------------------------
8: -- PACKAGE

Line 9: -- AHL_LTP_SIMUL_PLAN_PVT

5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: -----------------------------------------------------------
8: -- PACKAGE
9: -- AHL_LTP_SIMUL_PLAN_PVT
10: --
11: -- PURPOSE
12: -- This package is a Private API for managing Simulation plans information in
13: -- Advanced Services Online. It contains specification for pl/sql records and tables

Line 578: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Create Simulation plan','+SIMPL+');

574: AHL_DEBUG_PUB.enable_debug;
575: END IF;
576: -- Debug info.
577: IF G_DEBUG='Y' THEN
578: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Create Simulation plan','+SIMPL+');
579: END IF;
580: -- Standard call to check for call compatibility.
581: IF FND_API.to_boolean(p_init_msg_list)
582: THEN

Line 810: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');

806: IF G_DEBUG='Y' THEN
807:
808: AHL_DEBUG_PUB.log_app_messages (
809: x_msg_count, x_msg_data, 'ERROR' );
810: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');
811: -- Check if API is called in debug mode. If yes, disable debug.
812: AHL_DEBUG_PUB.disable_debug;
813: END IF;
814: WHEN FND_API.G_EXC_ERROR THEN

Line 824: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');

820: IF G_DEBUG='Y' THEN
821: -- Debug info.
822: AHL_DEBUG_PUB.log_app_messages (
823: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
824: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');
825: -- Check if API is called in debug mode. If yes, disable debug.
826: AHL_DEBUG_PUB.disable_debug;
827: END IF;
828: WHEN OTHERS THEN

Line 833: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',

829: ROLLBACK TO create_simulation_plan;
830: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
832: THEN
833: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
834: p_procedure_name => 'CREATE_SIMULATION_PLAN',
835: p_error_text => SUBSTR(SQLERRM,1,240));
836: END IF;
837: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 909: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPNL+');

905: AHL_DEBUG_PUB.enable_debug;
906: END IF;
907: -- Debug info.
908: IF G_DEBUG='Y' THEN
909: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPNL+');
910: END IF;
911: -- Standard call to check for call compatibility.
912: IF FND_API.to_boolean(p_init_msg_list)
913: THEN

Line 1051: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');

1047: IF G_DEBUG='Y' THEN
1048:
1049: AHL_DEBUG_PUB.log_app_messages (
1050: x_msg_count, x_msg_data, 'ERROR' );
1051: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1052: -- Check if API is called in debug mode. If yes, disable debug.
1053: AHL_DEBUG_PUB.disable_debug;
1054: END IF;
1055: WHEN FND_API.G_EXC_ERROR THEN

Line 1066: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');

1062:
1063: -- Debug info.
1064: AHL_DEBUG_PUB.log_app_messages (
1065: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1066: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1067: -- Check if API is called in debug mode. If yes, disable debug.
1068: AHL_DEBUG_PUB.disable_debug;
1069: END IF;
1070: WHEN OTHERS THEN

Line 1075: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',

1071: ROLLBACK TO update_simulation_plan;
1072: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1074: THEN
1075: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
1076: p_procedure_name => 'UPDATE_SIMULATION_PLAN',
1077: p_error_text => SUBSTR(SQLERRM,1,240));
1078: END IF;
1079: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1087: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');

1083:
1084: -- Debug info.
1085: AHL_DEBUG_PUB.log_app_messages (
1086: x_msg_count, x_msg_data, 'SQL ERROR' );
1087: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Update Simulation plan','+SMPLN+');
1088: -- Check if API is called in debug mode. If yes, disable debug.
1089: AHL_DEBUG_PUB.disable_debug;
1090: END IF;
1091: END Update_Simulation_plan;

Line 1175: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');

1171: AHL_DEBUG_PUB.enable_debug;
1172: END IF;
1173: -- Debug info.
1174: IF G_DEBUG='Y' THEN
1175: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1176: END IF;
1177: -- Standard call to check for call compatibility.
1178: IF FND_API.to_boolean(p_init_msg_list)
1179: THEN

Line 1291: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');

1287: IF G_DEBUG='Y' THEN
1288:
1289: AHL_DEBUG_PUB.log_app_messages (
1290: x_msg_count, x_msg_data, 'ERROR' );
1291: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1292: -- Check if API is called in debug mode. If yes, disable debug.
1293: AHL_DEBUG_PUB.disable_debug;
1294: END IF;
1295: WHEN FND_API.G_EXC_ERROR THEN

Line 1305: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');

1301: IF G_DEBUG='Y' THEN
1302: -- Debug info.
1303: AHL_DEBUG_PUB.log_app_messages (
1304: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1305: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1306: -- Check if API is called in debug mode. If yes, disable debug.
1307: AHL_DEBUG_PUB.disable_debug;
1308: END IF;
1309: WHEN OTHERS THEN

Line 1314: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',

1310: ROLLBACK TO delete_simulation_plan;
1311: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1313: THEN
1314: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
1315: p_procedure_name => 'DELETE_SIMULATION_PLAN',
1316: p_error_text => SUBSTR(SQLERRM,1,240));
1317: END IF;
1318: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1326: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');

1322:
1323: -- Debug info.
1324: AHL_DEBUG_PUB.log_app_messages (
1325: x_msg_count, x_msg_data, 'SQL ERROR' );
1326: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simulation plan','+SMPLN+');
1327: -- Check if API is called in debug mode. If yes, disable debug.
1328: AHL_DEBUG_PUB.disable_debug;
1329: END IF;
1330: END Delete_Simulation_plan;

Line 1714: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Copy Visits to Plan','+SMPNL+');

1710: -- Check if API is called in debug mode. If yes, enable debug.
1711: IF G_DEBUG='Y' THEN
1712: AHL_DEBUG_PUB.enable_debug;
1713: -- Debug info.
1714: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Copy Visits to Plan','+SMPNL+');
1715: END IF;
1716: -- Standard call to check for call compatibility.
1717: IF FND_API.to_boolean(p_init_msg_list)
1718: THEN

Line 2365: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');

2361: IF G_DEBUG='Y' THEN
2362:
2363: AHL_DEBUG_PUB.log_app_messages (
2364: x_msg_count, x_msg_data, 'ERROR' );
2365: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2366: -- Check if API is called in debug mode. If yes, disable debug.
2367: AHL_DEBUG_PUB.disable_debug;
2368: END IF;
2369:

Line 2381: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');

2377:
2378: -- Debug info.
2379: AHL_DEBUG_PUB.log_app_messages (
2380: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2381: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2382: -- Check if API is called in debug mode. If yes, disable debug.
2383: AHL_DEBUG_PUB.disable_debug;
2384: END IF;
2385:

Line 2391: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',

2387: ROLLBACK TO copy_visits_to_plan;
2388: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2390: THEN
2391: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
2392: p_procedure_name => 'COPY_VISITS_TO_PLAN',
2393: p_error_text => SUBSTR(SQLERRM,1,240));
2394: END IF;
2395: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2403: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');

2399:
2400: -- Debug info.
2401: AHL_DEBUG_PUB.log_app_messages (
2402: x_msg_count, x_msg_data, 'SQL ERROR' );
2403: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2404: -- Check if API is called in debug mode. If yes, disable debug.
2405: AHL_DEBUG_PUB.disable_debug;
2406: END IF;
2407:

Line 2495: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Remove Visits from Plan','+SMPNL+');

2491: AHL_DEBUG_PUB.enable_debug;
2492: END IF;
2493: -- Debug info.
2494: IF G_DEBUG='Y' THEN
2495: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Remove Visits from Plan','+SMPNL+');
2496: END IF;
2497: -- Standard call to check for call compatibility.
2498: IF FND_API.to_boolean(p_init_msg_list)
2499: THEN

Line 2704: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');

2700: IF G_DEBUG='Y' THEN
2701:
2702: AHL_DEBUG_PUB.log_app_messages (
2703: x_msg_count, x_msg_data, 'ERROR' );
2704: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2705: -- Check if API is called in debug mode. If yes, disable debug.
2706: AHL_DEBUG_PUB.disable_debug;
2707: END IF;
2708:

Line 2720: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');

2716:
2717: -- Debug info.
2718: AHL_DEBUG_PUB.log_app_messages (
2719: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2720: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2721: -- Check if API is called in debug mode. If yes, disable debug.
2722: AHL_DEBUG_PUB.disable_debug;
2723: END IF;
2724:

Line 2730: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',

2726: ROLLBACK TO remove_visits_fr_plan;
2727: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2729: THEN
2730: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
2731: p_procedure_name => 'REMOVE_VISITS_FR_PLAN',
2732: p_error_text => SUBSTR(SQLERRM,1,240));
2733: END IF;
2734: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2742: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');

2738:
2739: -- Debug info.
2740: AHL_DEBUG_PUB.log_app_messages (
2741: x_msg_count, x_msg_data, 'SQL ERROR' );
2742: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2743: -- Check if API is called in debug mode. If yes, disable debug.
2744: AHL_DEBUG_PUB.disable_debug;
2745: END IF;
2746:

Line 2800: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.toggle simulation delete','+SMPNL+');

2796: -- Check if API is called in debug mode. If yes, enable debug.
2797: IF G_DEBUG='Y' THEN
2798: AHL_DEBUG_PUB.enable_debug;
2799: -- Debug info.
2800: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.toggle simulation delete','+SMPNL+');
2801: END IF;
2802: -- Standard call to check for call compatibility.
2803: IF FND_API.to_boolean(p_init_msg_list)
2804: THEN

Line 2884: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');

2880:
2881: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2882: AHL_DEBUG_PUB.log_app_messages (
2883: x_msg_count, x_msg_data, 'ERROR' );
2884: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2885: END IF;
2886: -- Check if API is called in debug mode. If yes, disable debug.
2887: AHL_DEBUG_PUB.disable_debug;
2888: END IF;

Line 2902: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');

2898: -- Debug info.
2899: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2900: AHL_DEBUG_PUB.log_app_messages (
2901: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2902: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2903: END IF;
2904: -- Check if API is called in debug mode. If yes, disable debug.
2905: AHL_DEBUG_PUB.disable_debug;
2906: END IF;

Line 2913: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',

2909: ROLLBACK TO toggle_simulation_delete;
2910: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2912: THEN
2913: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
2914: p_procedure_name => 'TOGGLE_SIMULATION_DELETE',
2915: p_error_text => SUBSTR(SQLERRM,1,240));
2916: END IF;
2917: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2926: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');

2922: -- Debug info.
2923: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2924: AHL_DEBUG_PUB.log_app_messages (
2925: x_msg_count, x_msg_data, 'SQL ERROR' );
2926: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2927: END IF;
2928: -- Check if API is called in debug mode. If yes, disable debug.
2929: AHL_DEBUG_PUB.disable_debug;
2930: END IF;

Line 3000: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set plan as primary','+SMPNL+');

2996: AHL_DEBUG_PUB.enable_debug;
2997: END IF;
2998: -- Debug info.
2999: IF G_DEBUG='Y' THEN
3000: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set plan as primary','+SMPNL+');
3001: END IF;
3002: -- Standard call to check for call compatibility.
3003: IF FND_API.to_boolean(p_init_msg_list)
3004: THEN

Line 3109: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan As Primary','+SMPLN+');

3105: IF G_DEBUG='Y' THEN
3106:
3107: AHL_DEBUG_PUB.log_app_messages (
3108: x_msg_count, x_msg_data, 'ERROR' );
3109: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan As Primary','+SMPLN+');
3110: -- Check if API is called in debug mode. If yes, disable debug.
3111: AHL_DEBUG_PUB.disable_debug;
3112: END IF;
3113:

Line 3125: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Set Plan as Primary','+SMPLN+');

3121:
3122: -- Debug info.
3123: AHL_DEBUG_PUB.log_app_messages (
3124: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3125: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Set Plan as Primary','+SMPLN+');
3126: -- Check if API is called in debug mode. If yes, disable debug.
3127: AHL_DEBUG_PUB.disable_debug;
3128: END IF;
3129: WHEN OTHERS THEN

Line 3134: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',

3130: ROLLBACK TO set_plan_as_primary;
3131: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3132: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3133: THEN
3134: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
3135: p_procedure_name => 'SET_PLAN_AS_PRIMARY',
3136: p_error_text => SUBSTR(SQLERRM,1,240));
3137: END IF;
3138: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3146: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan as Primary','+SMPLN+');

3142: -- Debug info.
3143: IF G_DEBUG='Y' THEN
3144: AHL_DEBUG_PUB.log_app_messages (
3145: x_msg_count, x_msg_data, 'SQL ERROR' );
3146: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan as Primary','+SMPLN+');
3147: END IF;
3148: -- Check if API is called in debug mode. If yes, disable debug.
3149: AHL_DEBUG_PUB.disable_debug;
3150: END Set_Plan_As_Primary;

Line 3597: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set visit as primary','+SMPNL+');

3593: AHL_DEBUG_PUB.enable_debug;
3594: END IF;
3595: -- Debug info.
3596: IF G_DEBUG='Y' THEN
3597: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set visit as primary','+SMPNL+');
3598: END IF;
3599: -- Standard call to check for call compatibility.
3600: IF FND_API.to_boolean(p_init_msg_list)
3601: THEN

Line 4592: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');

4588:
4589: IF G_DEBUG='Y' THEN
4590: AHL_DEBUG_PUB.log_app_messages (
4591: x_msg_count, x_msg_data, 'ERROR' );
4592: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');
4593: END IF;
4594: -- Check if API is called in debug mode. If yes, disable debug.
4595: AHL_DEBUG_PUB.disable_debug;
4596:

Line 4607: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.set visit as primary','+SMPLN+');

4603: -- Debug info.
4604: IF G_DEBUG='Y' THEN
4605: AHL_DEBUG_PUB.log_app_messages (
4606: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4607: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.set visit as primary','+SMPLN+');
4608: END IF;
4609: -- Check if API is called in debug mode. If yes, disable debug.
4610: AHL_DEBUG_PUB.disable_debug;
4611:

Line 4617: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',

4613: ROLLBACK TO set_visit_as_primary;
4614: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4616: THEN
4617: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
4618: p_procedure_name => 'SET_VISIT_AS_PRIMARY',
4619: p_error_text => SUBSTR(SQLERRM,1,240));
4620: END IF;
4621: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4629: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');

4625: -- Debug info.
4626: IF G_DEBUG='Y' THEN
4627: AHL_DEBUG_PUB.log_app_messages (
4628: x_msg_count, x_msg_data, 'SQL ERROR' );
4629: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');
4630: END IF;
4631: -- Check if API is called in debug mode. If yes, disable debug.
4632: AHL_DEBUG_PUB.disable_debug;
4633: END Set_Visit_As_Primary;

Line 4700: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPNL+');

4696: AHL_DEBUG_PUB.enable_debug;
4697: END IF;
4698: -- Debug info.
4699: IF G_DEBUG='Y' THEN
4700: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPNL+');
4701: END IF;
4702: -- Standard call to check for call compatibility.
4703: IF FND_API.to_boolean(p_init_msg_list)
4704: THEN

Line 4784: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');

4780:
4781: IF G_DEBUG='Y' THEN
4782: AHL_DEBUG_PUB.log_app_messages (
4783: x_msg_count, x_msg_data, 'ERROR' );
4784: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');
4785: END IF;
4786: -- Check if API is called in debug mode. If yes, disable debug.
4787: AHL_DEBUG_PUB.disable_debug;
4788:

Line 4799: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPLN+');

4795: -- Debug info.
4796: IF G_DEBUG='Y' THEN
4797: AHL_DEBUG_PUB.log_app_messages (
4798: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4799: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPLN+');
4800: END IF;
4801: -- Check if API is called in debug mode. If yes, disable debug.
4802: AHL_DEBUG_PUB.disable_debug;
4803:

Line 4809: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',

4805: ROLLBACK TO Delete_Simul_Visits;
4806: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4807: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4808: THEN
4809: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
4810: p_procedure_name => 'DELETE_SIMUL_VISITS',
4811: p_error_text => SUBSTR(SQLERRM,1,240));
4812: END IF;
4813: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4820: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');

4816: -- Debug info.
4817: IF G_DEBUG='Y' THEN
4818: AHL_DEBUG_PUB.log_app_messages (
4819: x_msg_count, x_msg_data, 'SQL ERROR' );
4820: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');
4821: END IF;
4822: -- Check if API is called in debug mode. If yes, disable debug.
4823: AHL_DEBUG_PUB.disable_debug;
4824:

Line 4829: END AHL_LTP_SIMUL_PLAN_PVT;

4825: END Delete_Simul_Visits;
4826:
4827:
4828: --
4829: END AHL_LTP_SIMUL_PLAN_PVT;