DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PUB dependencies on AHL_LTP_SIMUL_PLAN_PUB

Line 1: PACKAGE BODY AHL_LTP_SIMUL_PLAN_PUB AS

1: PACKAGE BODY AHL_LTP_SIMUL_PLAN_PUB AS
2: /* $Header: AHLPSPNB.pls 115.7 2003/09/09 06:05:47 rroy noship $ */
3: --
4:
5: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SIMUL_PLAN_PUB';

Line 5: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SIMUL_PLAN_PUB';

1: PACKAGE BODY AHL_LTP_SIMUL_PLAN_PUB AS
2: /* $Header: AHLPSPNB.pls 115.7 2003/09/09 06:05:47 rroy noship $ */
3: --
4:
5: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SIMUL_PLAN_PUB';
6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7: --
8: -----------------------------------------------------------
9: -- PACKAGE

Line 10: -- AHL_LTP_SIMUL_PLAN_PUB

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

Line 67: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');

63: AHL_DEBUG_PUB.enable_debug;
64: END IF;
65: -- Debug info.
66: IF G_DEBUG='Y' THEN
67: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');
68: END IF;
69: -- Standard call to check for call compatibility.
70: IF FND_API.to_boolean(p_init_msg_list)
71: THEN

Line 192: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');

188:
189: IF G_DEBUG='Y' THEN
190: AHL_DEBUG_PUB.log_app_messages (
191: x_msg_count, x_msg_data, 'ERROR' );
192: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');
193: END IF;
194: -- Check if API is called in debug mode. If yes, disable debug.
195: AHL_DEBUG_PUB.disable_debug;
196:

Line 207: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');

203: -- Debug info.
204: IF G_DEBUG='Y' THEN
205: AHL_DEBUG_PUB.log_app_messages (
206: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
207: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation plan','+SMPLN+');
208: END IF;
209: -- Check if API is called in debug mode. If yes, disable debug.
210: AHL_DEBUG_PUB.disable_debug;
211:

Line 217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',

213: ROLLBACK TO process_simulation_plan;
214: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
216: THEN
217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
218: p_procedure_name => 'PROCESS_SIMULATION_PLAN',
219: p_error_text => SUBSTR(SQLERRM,1,240));
220: END IF;
221: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 229: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');

225: -- Debug info.
226: IF G_DEBUG='Y' THEN
227: AHL_DEBUG_PUB.log_app_messages (
228: x_msg_count, x_msg_data, 'SQL ERROR' );
229: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Plan','+SMPLN+');
230: END IF;
231: -- Check if API is called in debug mode. If yes, disable debug.
232: AHL_DEBUG_PUB.disable_debug;
233:

Line 281: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Process Visits to Plan','+SMPLN+');

277: AHL_DEBUG_PUB.enable_debug;
278: END IF;
279: -- Debug info.
280: IF G_DEBUG='Y' THEN
281: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Process Visits to Plan','+SMPLN+');
282: END IF;
283: -- Standard call to check for call compatibility.
284: IF FND_API.to_boolean(p_init_msg_list)
285: THEN

Line 453: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');

449:
450: IF G_DEBUG='Y' THEN
451: AHL_DEBUG_PUB.log_app_messages (
452: x_msg_count, x_msg_data, 'ERROR' );
453: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');
454: END IF;
455: -- Check if API is called in debug mode. If yes, disable debug.
456: AHL_DEBUG_PUB.disable_debug;
457:

Line 468: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');

464: -- Debug info.
465: IF G_DEBUG='Y' THEN
466: AHL_DEBUG_PUB.log_app_messages (
467: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
468: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation Visit','+SMPLN+');
469: END IF;
470: -- Check if API is called in debug mode. If yes, disable debug.
471: AHL_DEBUG_PUB.disable_debug;
472:

Line 478: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',

474: ROLLBACK TO process_simulation_visit;
475: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
477: THEN
478: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
479: p_procedure_name => 'PROCESS_SIMULATION_VISIT',
480: p_error_text => SUBSTR(SQLERRM,1,240));
481: END IF;
482: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 490: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation visit','+SMPLN+');

486: -- Debug info.
487: IF G_DEBUG='Y' THEN
488: AHL_DEBUG_PUB.log_app_messages (
489: x_msg_count, x_msg_data, 'SQL ERROR' );
490: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Process Simulation visit','+SMPLN+');
491: END IF;
492: -- Check if API is called in debug mode. If yes, disable debug.
493: AHL_DEBUG_PUB.disable_debug;
494:

Line 542: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

538: AHL_DEBUG_PUB.enable_debug;
539: END IF;
540: -- Debug info.
541: IF G_DEBUG='Y' THEN
542: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
543: END IF;
544: -- Standard call to check for call compatibility.
545: IF FND_API.to_boolean(p_init_msg_list)
546: THEN

Line 605: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

601:
602: IF G_DEBUG='Y' THEN
603: AHL_DEBUG_PUB.log_app_messages (
604: x_msg_count, x_msg_data, 'ERROR' );
605: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
606: END IF;
607: -- Check if API is called in debug mode. If yes, disable debug.
608: AHL_DEBUG_PUB.disable_debug;
609:

Line 620: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

616: -- Debug info.
617: IF G_DEBUG='Y' THEN
618: AHL_DEBUG_PUB.log_app_messages (
619: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
620: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
621: END IF;
622: -- Check if API is called in debug mode. If yes, disable debug.
623: AHL_DEBUG_PUB.disable_debug;
624:

Line 630: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',

626: ROLLBACK TO toggle_simulation_delete;
627: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
631: p_procedure_name => 'TOGGLE_SIMULATION_DELETE',
632: p_error_text => SUBSTR(SQLERRM,1,240));
633: END IF;
634: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 642: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');

638: -- Debug info.
639: IF G_DEBUG='Y' THEN
640: AHL_DEBUG_PUB.log_app_messages (
641: x_msg_count, x_msg_data, 'SQL ERROR' );
642: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Toggle Simulation Delete','+SMPLN+');
643: END IF;
644: -- Check if API is called in debug mode. If yes, disable debug.
645: AHL_DEBUG_PUB.disable_debug;
646:

Line 694: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub. Set Plan as Primary','+SMPLN+');

690: AHL_DEBUG_PUB.enable_debug;
691: END IF;
692: -- Debug info.
693: IF G_DEBUG='Y' THEN
694: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub. Set Plan as Primary','+SMPLN+');
695: END IF;
696: -- Standard call to check for call compatibility.
697: IF FND_API.to_boolean(p_init_msg_list)
698: THEN

Line 757: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');

753:
754: IF G_DEBUG='Y' THEN
755: AHL_DEBUG_PUB.log_app_messages (
756: x_msg_count, x_msg_data, 'ERROR' );
757: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');
758: END IF;
759: -- Check if API is called in debug mode. If yes, disable debug.
760: AHL_DEBUG_PUB.disable_debug;
761:

Line 772: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Plan as primary','+SMPLN+');

768: -- Debug info.
769: IF G_DEBUG='Y' THEN
770: AHL_DEBUG_PUB.log_app_messages (
771: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
772: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Plan as primary','+SMPLN+');
773: END IF;
774: -- Check if API is called in debug mode. If yes, disable debug.
775: AHL_DEBUG_PUB.disable_debug;
776:

Line 782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',

778: ROLLBACK TO set_plan_as_primary;
779: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
781: THEN
782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
783: p_procedure_name => 'SET_PLAN_AS_PRIMARY',
784: p_error_text => SUBSTR(SQLERRM,1,240));
785: END IF;
786: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 794: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');

790: -- Debug info.
791: IF G_DEBUG='Y' THEN
792: AHL_DEBUG_PUB.log_app_messages (
793: x_msg_count, x_msg_data, 'SQL ERROR' );
794: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set plan as primary','+SMPLN+');
795: END IF;
796: -- Check if API is called in debug mode. If yes, disable debug.
797: AHL_DEBUG_PUB.disable_debug;
798:

Line 847: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub. Set Visit as Primary','+SMPLN+');

843: AHL_DEBUG_PUB.enable_debug;
844: END IF;
845: -- Debug info.
846: IF G_DEBUG='Y' THEN
847: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_simul_plan_pub. Set Visit as Primary','+SMPLN+');
848: END IF;
849: -- Standard call to check for call compatibility.
850: IF FND_API.to_boolean(p_init_msg_list)
851: THEN

Line 911: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');

907:
908: IF G_DEBUG='Y' THEN
909: AHL_DEBUG_PUB.log_app_messages (
910: x_msg_count, x_msg_data, 'ERROR' );
911: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');
912: END IF;
913: -- Check if API is called in debug mode. If yes, disable debug.
914: AHL_DEBUG_PUB.disable_debug;
915:

Line 926: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Visit as primary','+SMPLN+');

922: -- Debug info.
923: IF G_DEBUG='Y' THEN
924: AHL_DEBUG_PUB.log_app_messages (
925: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
926: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set Visit as primary','+SMPLN+');
927: END IF;
928: -- Check if API is called in debug mode. If yes, disable debug.
929: AHL_DEBUG_PUB.disable_debug;
930:

Line 936: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',

932: ROLLBACK TO set_visit_as_primary;
933: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
935: THEN
936: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
937: p_procedure_name => 'SET_VISIT_AS_PRIMARY',
938: p_error_text => SUBSTR(SQLERRM,1,240));
939: END IF;
940: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 948: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');

944: -- Debug info.
945: IF G_DEBUG='Y' THEN
946: AHL_DEBUG_PUB.log_app_messages (
947: x_msg_count, x_msg_data, 'SQL ERROR' );
948: AHL_DEBUG_PUB.debug( 'ahl_ltp_simul_plan_pub.Set visit as primary','+SMPLN+');
949: END IF;
950: -- Check if API is called in debug mode. If yes, disable debug.
951: AHL_DEBUG_PUB.disable_debug;
952: END Set_Visit_As_Primary;

Line 954: END AHL_LTP_SIMUL_PLAN_PUB;

950: -- Check if API is called in debug mode. If yes, disable debug.
951: AHL_DEBUG_PUB.disable_debug;
952: END Set_Visit_As_Primary;
953: --
954: END AHL_LTP_SIMUL_PLAN_PUB;