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_SPACE_SCHEDULE_PVT dependencies on AHL_LTP_SPACE_SCHEDULE_PVT

Line 1: PACKAGE BODY AHL_LTP_SPACE_SCHEDULE_PVT AS

1: PACKAGE BODY AHL_LTP_SPACE_SCHEDULE_PVT AS
2: /* $Header: AHLVSPSB.pls 120.2 2006/05/25 09:51:23 anraj noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SPACE_SCHEDULE_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

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

1: PACKAGE BODY AHL_LTP_SPACE_SCHEDULE_PVT AS
2: /* $Header: AHLVSPSB.pls 120.2 2006/05/25 09:51:23 anraj noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SPACE_SCHEDULE_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: --
8: -- PACKAGE

Line 9: -- AHL_LTP_SPACE_SCHEDULE_PVT

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

Line 4088: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt. Search Scheduled Visits','+SPANT+');

4084: AHL_DEBUG_PUB.enable_debug;
4085: END IF;
4086: -- Debug info.
4087: IF G_DEBUG='Y' THEN
4088: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt. Search Scheduled Visits','+SPANT+');
4089: END IF;
4090: -- Standard call to check for call compatibility.
4091: IF FND_API.to_boolean(p_init_msg_list)
4092: THEN

Line 4542: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');

4538:
4539: IF G_DEBUG='Y' THEN
4540: AHL_DEBUG_PUB.log_app_messages (
4541: x_msg_count, x_msg_data, 'ERROR' );
4542: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4543: -- Check if API is called in debug mode. If yes, disable debug.
4544: AHL_DEBUG_PUB.disable_debug;
4545: END IF;
4546: WHEN FND_API.G_EXC_ERROR THEN

Line 4557: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');

4553:
4554: -- Debug info.
4555: AHL_DEBUG_PUB.log_app_messages (
4556: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4557: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4558: -- Check if API is called in debug mode. If yes, disable debug.
4559: AHL_DEBUG_PUB.disable_debug;
4560: END IF;
4561: WHEN OTHERS THEN

Line 4566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

4562: ROLLBACK TO Search_Scheduled_Visits;
4563: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4565: THEN
4566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4567: p_procedure_name => 'SEARCH_SCHEDULED_VISITS',
4568: p_error_text => SUBSTR(SQLERRM,1,240));
4569: END IF;
4570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4578: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');

4574:
4575: -- Debug info.
4576: AHL_DEBUG_PUB.log_app_messages (
4577: x_msg_count, x_msg_data, 'SQL ERROR' );
4578: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4579: -- Check if API is called in debug mode. If yes, disable debug.
4580: AHL_DEBUG_PUB.disable_debug;
4581: END IF;
4582:

Line 4631: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_duration','+SPSL+');

4627: AHL_DEBUG_PUB.enable_debug;
4628: END IF;
4629: -- Debug info.
4630: IF G_DEBUG='Y' THEN
4631: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_duration','+SPSL+');
4632: END IF;
4633: -- Standard call to check for call compatibility.
4634: IF FND_API.to_boolean(l_init_msg_list)
4635: THEN

Line 4722: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit duration','+SPSL+');

4718: IF G_DEBUG='Y' THEN
4719:
4720: AHL_DEBUG_PUB.log_app_messages (
4721: x_msg_count, x_msg_data, 'ERROR' );
4722: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit duration','+SPSL+');
4723: -- Check if API is called in debug mode. If yes, disable debug.
4724: AHL_DEBUG_PUB.disable_debug;
4725: END IF;
4726:

Line 4738: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');

4734:
4735: -- Debug info.
4736: AHL_DEBUG_PUB.log_app_messages (
4737: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4738: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');
4739: -- Check if API is called in debug mode. If yes, disable debug.
4740: AHL_DEBUG_PUB.disable_debug;
4741: END IF;
4742:

Line 4748: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

4744: ROLLBACK TO get_visit_duration;
4745: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4747: THEN
4748: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4749: p_procedure_name => 'GET_VISIT_DURATION',
4750: p_error_text => SUBSTR(SQLERRM,1,240));
4751: END IF;
4752: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4760: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');

4756:
4757: -- Debug info.
4758: AHL_DEBUG_PUB.log_app_messages (
4759: x_msg_count, x_msg_data, 'SQL ERROR' );
4760: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');
4761: -- Check if API is called in debug mode. If yes, disable debug.
4762: AHL_DEBUG_PUB.disable_debug;
4763: END IF;
4764: END Get_Visit_Duration;

Line 4806: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_end_date','+SUAVL+');

4802: AHL_DEBUG_PUB.enable_debug;
4803: END IF;
4804: -- Debug info.
4805: IF G_DEBUG='Y' THEN
4806: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_end_date','+SUAVL+');
4807: END IF;
4808: -- Standard call to check for call compatibility.
4809: IF FND_API.to_boolean(l_init_msg_list)
4810: THEN

Line 4872: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit end date','+SPSL+');

4868: IF G_DEBUG='Y' THEN
4869:
4870: AHL_DEBUG_PUB.log_app_messages (
4871: x_msg_count, x_msg_data, 'ERROR' );
4872: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit end date','+SPSL+');
4873: -- Check if API is called in debug mode. If yes, disable debug.
4874: AHL_DEBUG_PUB.disable_debug;
4875: END IF;
4876:

Line 4887: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');

4883: IF G_DEBUG='Y' THEN
4884: -- Debug info.
4885: AHL_DEBUG_PUB.log_app_messages (
4886: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4887: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');
4888: -- Check if API is called in debug mode. If yes, disable debug.
4889: AHL_DEBUG_PUB.disable_debug;
4890: END IF;
4891:

Line 4897: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

4893: ROLLBACK TO get_visit_end_date;
4894: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4896: THEN
4897: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4898: p_procedure_name => 'GET_VISIT_END_DATE',
4899: p_error_text => SUBSTR(SQLERRM,1,240));
4900: END IF;
4901: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4909: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');

4905:
4906: -- Debug info.
4907: AHL_DEBUG_PUB.log_app_messages (
4908: x_msg_count, x_msg_data, 'SQL ERROR' );
4909: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');
4910: -- Check if API is called in debug mode. If yes, disable debug.
4911: AHL_DEBUG_PUB.disable_debug;
4912: END IF;
4913:

Line 4962: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_due_by_date','+SPSL+');

4958: -- Check if API is called in debug mode. If yes, enable debug.
4959: IF G_DEBUG='Y' THEN
4960: AHL_DEBUG_PUB.enable_debug;
4961: -- Debug info.
4962: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_due_by_date','+SPSL+');
4963: --
4964: END IF;
4965: -- Standard call to check for call compatibility.
4966: IF FND_API.to_boolean(l_init_msg_list)

Line 5031: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit due by date','+SPSL+');

5027: p_data => x_msg_data);
5028: IF G_DEBUG='Y' THEN
5029: AHL_DEBUG_PUB.log_app_messages (
5030: x_msg_count, x_msg_data, 'ERROR' );
5031: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit due by date','+SPSL+');
5032: -- Check if API is called in debug mode. If yes, disable debug.
5033: AHL_DEBUG_PUB.disable_debug;
5034: END IF;
5035: WHEN FND_API.G_EXC_ERROR THEN

Line 5046: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');

5042:
5043: -- Debug info.
5044: AHL_DEBUG_PUB.log_app_messages (
5045: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5046: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');
5047: -- Check if API is called in debug mode. If yes, disable debug.
5048: AHL_DEBUG_PUB.disable_debug;
5049: END IF;
5050: WHEN OTHERS THEN

Line 5055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

5051: ROLLBACK TO get_visit_due_by_date;
5052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5054: THEN
5055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
5056: p_procedure_name => 'GET_VISIT_DUE_BY_DATE',
5057: p_error_text => SUBSTR(SQLERRM,1,240));
5058: END IF;
5059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5067: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');

5063:
5064: -- Debug info.
5065: AHL_DEBUG_PUB.log_app_messages (
5066: x_msg_count, x_msg_data, 'SQL ERROR' );
5067: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');
5068: -- Check if API is called in debug mode. If yes, disable debug.
5069: AHL_DEBUG_PUB.disable_debug;
5070: END IF;
5071:

Line 5101: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Derive visit end date','+SPSL+');

5097: END IF;
5098: -- Debug info.
5099: IF G_DEBUG='Y' THEN
5100: --
5101: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Derive visit end date','+SPSL+');
5102: --
5103: END IF;
5104: -- Standard call to check for call compatibility.
5105: IF FND_API.to_boolean(l_init_msg_list)

Line 5165: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');

5161: IF G_DEBUG='Y' THEN
5162:
5163: AHL_DEBUG_PUB.log_app_messages (
5164: x_msg_count, x_msg_data, 'ERROR' );
5165: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
5166: -- Check if API is called in debug mode. If yes, disable debug.
5167: AHL_DEBUG_PUB.disable_debug;
5168: END IF;
5169:

Line 5181: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');

5177:
5178: -- Debug info.
5179: AHL_DEBUG_PUB.log_app_messages (
5180: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5181: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
5182: -- Check if API is called in debug mode. If yes, disable debug.
5183: AHL_DEBUG_PUB.disable_debug;
5184: END IF;
5185:

Line 5191: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

5187: ROLLBACK TO Derive_visit_end_date;
5188: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5190: THEN
5191: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
5192: p_procedure_name => 'DERIEVE_VISIT_END_DATE',
5193: p_error_text => SUBSTR(SQLERRM,1,240));
5194: END IF;
5195: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5203: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Derive visit end date','+SPSL+');

5199:
5200: -- Debug info.
5201: AHL_DEBUG_PUB.log_app_messages (
5202: x_msg_count, x_msg_data, 'SQL ERROR' );
5203: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Derive visit end date','+SPSL+');
5204: -- Check if API is called in debug mode. If yes, disable debug.
5205: AHL_DEBUG_PUB.disable_debug;
5206: END IF;
5207:

Line 5493: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');

5489: AHL_DEBUG_PUB.enable_debug;
5490: END IF;
5491: -- Debug info.
5492: IF G_DEBUG='Y' THEN
5493: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');
5494: END IF;
5495: -- Standard call to check for call compatibility.
5496: IF FND_API.to_boolean(p_init_msg_list)
5497: THEN

Line 6086: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit details','+SPSL+');

6082: IF G_DEBUG='Y' THEN
6083:
6084: AHL_DEBUG_PUB.log_app_messages (
6085: x_msg_count, x_msg_data, 'ERROR' );
6086: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit details','+SPSL+');
6087: -- Check if API is called in debug mode. If yes, disable debug.
6088: AHL_DEBUG_PUB.disable_debug;
6089: END IF;
6090:

Line 6102: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');

6098:
6099: -- Debug info.
6100: AHL_DEBUG_PUB.log_app_messages (
6101: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
6102: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
6103: -- Check if API is called in debug mode. If yes, disable debug.
6104: AHL_DEBUG_PUB.disable_debug;
6105: END IF;
6106: WHEN OTHERS THEN

Line 6111: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

6107: ROLLBACK TO Get_visit_details;
6108: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6110: THEN
6111: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
6112: p_procedure_name => 'GET_VISIT_DETAILS',
6113: p_error_text => SUBSTR(SQLERRM,1,240));
6114: END IF;
6115: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 6123: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');

6119:
6120: -- Debug info.
6121: AHL_DEBUG_PUB.log_app_messages (
6122: x_msg_count, x_msg_data, 'SQL ERROR' );
6123: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');
6124: -- Check if API is called in debug mode. If yes, disable debug.
6125: AHL_DEBUG_PUB.disable_debug;
6126:
6127: END IF;

Line 6154: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Get derived end date','+SPSL+');

6150: BEGIN
6151: --
6152: IF G_DEBUG='Y' THEN
6153: AHL_DEBUG_PUB.enable_debug;
6154: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Get derived end date','+SPSL+');
6155: END IF;
6156: --
6157: IF (p_visit_id IS NOT NULL AND p_visit_id <> FND_API.G_MISS_NUM )THEN
6158: OPEN get_visit_cur(p_visit_id);

Line 6177: END AHL_LTP_SPACE_SCHEDULE_PVT;

6173: RETURN l_visit_end_time;
6174: --
6175: END get_derived_end_date;
6176: --
6177: END AHL_LTP_SPACE_SCHEDULE_PVT;