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.7.12020000.3 2013/03/07 10:00:55 debadey 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.7.12020000.3 2013/03/07 10:00:55 debadey 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 812: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Create Simulation plan','+SMPLN+');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1726: -- Check if API is called in debug mode. If yes, enable debug.
1727: IF G_DEBUG='Y' THEN
1728: AHL_DEBUG_PUB.enable_debug;
1729: -- Debug info.
1730: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Copy Visits to Plan','+SMPNL+');
1731: END IF;
1732: -- Standard call to check for call compatibility.
1733: IF FND_API.to_boolean(p_init_msg_list)
1734: THEN

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

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

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

2416:
2417: -- Debug info.
2418: AHL_DEBUG_PUB.log_app_messages (
2419: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2420: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2421: -- Check if API is called in debug mode. If yes, disable debug.
2422: AHL_DEBUG_PUB.disable_debug;
2423: END IF;
2424:

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

2426: ROLLBACK TO copy_visits_to_plan;
2427: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2429: THEN
2430: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
2431: p_procedure_name => 'COPY_VISITS_TO_PLAN',
2432: p_error_text => SUBSTR(SQLERRM,1,240));
2433: END IF;
2434: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

2438:
2439: -- Debug info.
2440: AHL_DEBUG_PUB.log_app_messages (
2441: x_msg_count, x_msg_data, 'SQL ERROR' );
2442: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Copy Visits to plan','+SMPLN+');
2443: -- Check if API is called in debug mode. If yes, disable debug.
2444: AHL_DEBUG_PUB.disable_debug;
2445: END IF;
2446:

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

2530: AHL_DEBUG_PUB.enable_debug;
2531: END IF;
2532: -- Debug info.
2533: IF G_DEBUG='Y' THEN
2534: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Remove Visits from Plan','+SMPNL+');
2535: END IF;
2536: -- Standard call to check for call compatibility.
2537: IF FND_API.to_boolean(p_init_msg_list)
2538: THEN

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

2740: IF G_DEBUG='Y' THEN
2741:
2742: AHL_DEBUG_PUB.log_app_messages (
2743: x_msg_count, x_msg_data, 'ERROR' );
2744: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2745: -- Check if API is called in debug mode. If yes, disable debug.
2746: AHL_DEBUG_PUB.disable_debug;
2747: END IF;
2748:

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

2756:
2757: -- Debug info.
2758: AHL_DEBUG_PUB.log_app_messages (
2759: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2760: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2761: -- Check if API is called in debug mode. If yes, disable debug.
2762: AHL_DEBUG_PUB.disable_debug;
2763: END IF;
2764:

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

2766: ROLLBACK TO remove_visits_fr_plan;
2767: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2768: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2769: THEN
2770: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
2771: p_procedure_name => 'REMOVE_VISITS_FR_PLAN',
2772: p_error_text => SUBSTR(SQLERRM,1,240));
2773: END IF;
2774: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

2778:
2779: -- Debug info.
2780: AHL_DEBUG_PUB.log_app_messages (
2781: x_msg_count, x_msg_data, 'SQL ERROR' );
2782: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Remove Visits from plan','+SMPLN+');
2783: -- Check if API is called in debug mode. If yes, disable debug.
2784: AHL_DEBUG_PUB.disable_debug;
2785: END IF;
2786:

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

2836: -- Check if API is called in debug mode. If yes, enable debug.
2837: IF G_DEBUG='Y' THEN
2838: AHL_DEBUG_PUB.enable_debug;
2839: -- Debug info.
2840: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.toggle simulation delete','+SMPNL+');
2841: END IF;
2842: -- Standard call to check for call compatibility.
2843: IF FND_API.to_boolean(p_init_msg_list)
2844: THEN

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

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

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

2938: -- Debug info.
2939: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2940: AHL_DEBUG_PUB.log_app_messages (
2941: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2942: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2943: END IF;
2944: -- Check if API is called in debug mode. If yes, disable debug.
2945: AHL_DEBUG_PUB.disable_debug;
2946: END IF;

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

2949: ROLLBACK TO toggle_simulation_delete;
2950: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2952: THEN
2953: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
2954: p_procedure_name => 'TOGGLE_SIMULATION_DELETE',
2955: p_error_text => SUBSTR(SQLERRM,1,240));
2956: END IF;
2957: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

2962: -- Debug info.
2963: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2964: AHL_DEBUG_PUB.log_app_messages (
2965: x_msg_count, x_msg_data, 'SQL ERROR' );
2966: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Toggle Simulation Delete','+SMPLN+');
2967: END IF;
2968: -- Check if API is called in debug mode. If yes, disable debug.
2969: AHL_DEBUG_PUB.disable_debug;
2970: END IF;

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

3036: AHL_DEBUG_PUB.enable_debug;
3037: END IF;
3038: -- Debug info.
3039: IF G_DEBUG='Y' THEN
3040: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set plan as primary','+SMPNL+');
3041: END IF;
3042: -- Standard call to check for call compatibility.
3043: IF FND_API.to_boolean(p_init_msg_list)
3044: THEN

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

3145: IF G_DEBUG='Y' THEN
3146:
3147: AHL_DEBUG_PUB.log_app_messages (
3148: x_msg_count, x_msg_data, 'ERROR' );
3149: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan As Primary','+SMPLN+');
3150: -- Check if API is called in debug mode. If yes, disable debug.
3151: AHL_DEBUG_PUB.disable_debug;
3152: END IF;
3153:

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

3161:
3162: -- Debug info.
3163: AHL_DEBUG_PUB.log_app_messages (
3164: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3165: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Set Plan as Primary','+SMPLN+');
3166: -- Check if API is called in debug mode. If yes, disable debug.
3167: AHL_DEBUG_PUB.disable_debug;
3168: END IF;
3169: WHEN OTHERS THEN

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

3170: ROLLBACK TO set_plan_as_primary;
3171: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3172: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3173: THEN
3174: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
3175: p_procedure_name => 'SET_PLAN_AS_PRIMARY',
3176: p_error_text => SUBSTR(SQLERRM,1,240));
3177: END IF;
3178: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

3182: -- Debug info.
3183: IF G_DEBUG='Y' THEN
3184: AHL_DEBUG_PUB.log_app_messages (
3185: x_msg_count, x_msg_data, 'SQL ERROR' );
3186: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Set Plan as Primary','+SMPLN+');
3187: END IF;
3188: -- Check if API is called in debug mode. If yes, disable debug.
3189: AHL_DEBUG_PUB.disable_debug;
3190: END Set_Plan_As_Primary;

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

3639: AHL_DEBUG_PUB.enable_debug;
3640: END IF;
3641: -- Debug info.
3642: IF G_DEBUG='Y' THEN
3643: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.set visit as primary','+SMPNL+');
3644: END IF;
3645: -- Standard call to check for call compatibility.
3646: IF FND_API.to_boolean(p_init_msg_list)
3647: THEN

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

4652:
4653: IF G_DEBUG='Y' THEN
4654: AHL_DEBUG_PUB.log_app_messages (
4655: x_msg_count, x_msg_data, 'ERROR' );
4656: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');
4657: END IF;
4658: -- Check if API is called in debug mode. If yes, disable debug.
4659: AHL_DEBUG_PUB.disable_debug;
4660:

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

4667: -- Debug info.
4668: IF G_DEBUG='Y' THEN
4669: AHL_DEBUG_PUB.log_app_messages (
4670: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4671: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.set visit as primary','+SMPLN+');
4672: END IF;
4673: -- Check if API is called in debug mode. If yes, disable debug.
4674: AHL_DEBUG_PUB.disable_debug;
4675:

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

4677: ROLLBACK TO set_visit_as_primary;
4678: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4679: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4680: THEN
4681: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
4682: p_procedure_name => 'SET_VISIT_AS_PRIMARY',
4683: p_error_text => SUBSTR(SQLERRM,1,240));
4684: END IF;
4685: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

4689: -- Debug info.
4690: IF G_DEBUG='Y' THEN
4691: AHL_DEBUG_PUB.log_app_messages (
4692: x_msg_count, x_msg_data, 'SQL ERROR' );
4693: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. set visit as primary','+SMPLN+');
4694: END IF;
4695: -- Check if API is called in debug mode. If yes, disable debug.
4696: AHL_DEBUG_PUB.disable_debug;
4697: END Set_Visit_As_Primary;

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

4760: AHL_DEBUG_PUB.enable_debug;
4761: END IF;
4762: -- Debug info.
4763: IF G_DEBUG='Y' THEN
4764: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPNL+');
4765: END IF;
4766: -- Standard call to check for call compatibility.
4767: IF FND_API.to_boolean(p_init_msg_list)
4768: THEN

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

4844:
4845: IF G_DEBUG='Y' THEN
4846: AHL_DEBUG_PUB.log_app_messages (
4847: x_msg_count, x_msg_data, 'ERROR' );
4848: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');
4849: END IF;
4850: -- Check if API is called in debug mode. If yes, disable debug.
4851: AHL_DEBUG_PUB.disable_debug;
4852:

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

4859: -- Debug info.
4860: IF G_DEBUG='Y' THEN
4861: AHL_DEBUG_PUB.log_app_messages (
4862: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4863: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt.Delete Simul Visits','+SMPLN+');
4864: END IF;
4865: -- Check if API is called in debug mode. If yes, disable debug.
4866: AHL_DEBUG_PUB.disable_debug;
4867:

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

4869: ROLLBACK TO Delete_Simul_Visits;
4870: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4871: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4872: THEN
4873: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PVT',
4874: p_procedure_name => 'DELETE_SIMUL_VISITS',
4875: p_error_text => SUBSTR(SQLERRM,1,240));
4876: END IF;
4877: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

4880: -- Debug info.
4881: IF G_DEBUG='Y' THEN
4882: AHL_DEBUG_PUB.log_app_messages (
4883: x_msg_count, x_msg_data, 'SQL ERROR' );
4884: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pvt. Delete Simul Visits','+SMPLN+');
4885: END IF;
4886: -- Check if API is called in debug mode. If yes, disable debug.
4887: AHL_DEBUG_PUB.disable_debug;
4888:

Line 4893: END AHL_LTP_SIMUL_PLAN_PVT;

4889: END Delete_Simul_Visits;
4890:
4891:
4892: --
4893: END AHL_LTP_SIMUL_PLAN_PVT;