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_RESRC_LEVL_PUB dependencies on AHL_LTP_RESRC_LEVL_PUB

Line 1: PACKAGE BODY AHL_LTP_RESRC_LEVL_PUB AS

1: PACKAGE BODY AHL_LTP_RESRC_LEVL_PUB AS
2: /* $Header: AHLPRLGB.pls 115.14 2003/09/09 06:05:19 rroy noship $ */
3: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_RESRC_LEVL_PUB';
4: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
5: --

Line 3: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_RESRC_LEVL_PUB';

1: PACKAGE BODY AHL_LTP_RESRC_LEVL_PUB AS
2: /* $Header: AHLPRLGB.pls 115.14 2003/09/09 06:05:19 rroy noship $ */
3: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_RESRC_LEVL_PUB';
4: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
5: --
6: -----------------------------------------------------------
7: -- PACKAGE

Line 8: -- AHL_LTP_RESRC_LEVL_PUB

4: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
5: --
6: -----------------------------------------------------------
7: -- PACKAGE
8: -- AHL_LTP_RESRC_LEVL_PUB
9: --
10: -- PURPOSE
11: --
12: -- NOTES

Line 50: l_aval_resources_tbl AHL_LTP_RESRC_LEVL_PUB.Aval_Resources_Tbl;

46: l_api_version CONSTANT NUMBER := 1.0;
47: l_msg_count NUMBER;
48: l_return_status VARCHAR2(1);
49: l_msg_data VARCHAR2(2000);
50: l_aval_resources_tbl AHL_LTP_RESRC_LEVL_PUB.Aval_Resources_Tbl;
51: l_period_Rsrc_Req_Tbl AHL_LTP_RESRC_LEVL_PVT.Period_Rsrc_Req_Tbl_Type;
52: l_department_id NUMBER := null;
53: BEGIN
54:

Line 64: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_resrc_levl_pub. derive resource capacity','+RESLG+');

60: AHL_DEBUG_PUB.enable_debug;
61: END IF;
62: -- Debug info.
63: IF G_DEBUG='Y' THEN
64: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_resrc_levl_pub. derive resource capacity','+RESLG+');
65: END IF;
66: -- Standard call to check for call compatibility.
67: IF FND_API.to_boolean(p_init_msg_list)
68: THEN

Line 185: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Capacity','+RSRLG+');

181: IF G_DEBUG='Y' THEN
182:
183: AHL_DEBUG_PUB.log_app_messages (
184: x_msg_count, x_msg_data, 'ERROR' );
185: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Capacity','+RSRLG+');
186: -- Check if API is called in debug mode. If yes, disable debug.
187: AHL_DEBUG_PUB.disable_debug;
188: END IF;
189: WHEN FND_API.G_EXC_ERROR THEN

Line 200: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Capacity','+RSRLG+');

196:
197: -- Debug info.
198: AHL_DEBUG_PUB.log_app_messages (
199: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
200: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Capacity','+RSRLG+');
201: -- Check if API is called in debug mode. If yes, disable debug.
202: AHL_DEBUG_PUB.disable_debug;
203: END IF;
204: WHEN OTHERS THEN

Line 209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',

205: ROLLBACK TO derive_resource_capacity;
206: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
208: THEN
209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',
210: p_procedure_name => 'DERIVE_RESOURCE_CAPACITY',
211: p_error_text => SUBSTR(SQLERRM,1,240));
212: END IF;
213: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 221: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Capacity','+RSRLG+');

217:
218: -- Debug info.
219: AHL_DEBUG_PUB.log_app_messages (
220: x_msg_count, x_msg_data, 'SQL ERROR' );
221: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Capacity','+RSRLG+');
222: -- Check if API is called in debug mode. If yes, disable debug.
223: AHL_DEBUG_PUB.disable_debug;
224: END IF;
225:

Line 260: l_resource_con_tbl AHL_LTP_RESRC_LEVL_PUB.Resource_Con_Tbl;

256: l_msg_count NUMBER;
257: l_return_status VARCHAR2(1);
258: l_msg_data VARCHAR2(2000);
259: l_task_req_tbl AHL_LTP_RESRC_LEVL_PVT.Task_Requirement_Tbl_Type;
260: l_resource_con_tbl AHL_LTP_RESRC_LEVL_PUB.Resource_Con_Tbl;
261: l_department_id NUMBER;
262: BEGIN
263:
264: --------------------Initialize ----------------------------------

Line 273: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_resrc_levl_pub. derive resource consum','+RESLG+');

269: AHL_DEBUG_PUB.enable_debug;
270: END IF;
271: -- Debug info.
272: IF G_DEBUG='Y' THEN
273: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_resrc_levl_pub. derive resource consum','+RESLG+');
274: END IF;
275: -- Standard call to check for call compatibility.
276: IF FND_API.to_boolean(p_init_msg_list)
277: THEN

Line 405: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Consum','+RSRLG+');

401: IF G_DEBUG='Y' THEN
402:
403: AHL_DEBUG_PUB.log_app_messages (
404: x_msg_count, x_msg_data, 'ERROR' );
405: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Consum','+RSRLG+');
406: -- Check if API is called in debug mode. If yes, disable debug.
407: AHL_DEBUG_PUB.disable_debug;
408: END IF;
409:

Line 421: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Consum','+RSRLG+');

417:
418: -- Debug info.
419: AHL_DEBUG_PUB.log_app_messages (
420: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
421: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Consum','+RSRLG+');
422: -- Check if API is called in debug mode. If yes, disable debug.
423: AHL_DEBUG_PUB.disable_debug;
424: END IF;
425:

Line 431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',

427: ROLLBACK TO derive_resource_consum;
428: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_RESRC_LEVL_PUB',
432: p_procedure_name => 'DERIVE_RESOURCE_CAPACITY',
433: p_error_text => SUBSTR(SQLERRM,1,240));
434: END IF;
435: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 443: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Consum','+RSRLG+');

439:
440: -- Debug info.
441: AHL_DEBUG_PUB.log_app_messages (
442: x_msg_count, x_msg_data, 'SQL ERROR' );
443: AHL_DEBUG_PUB.debug( 'ahl_ltp_resrc_levl_pub. Derive Resource Consum','+RSRLG+');
444: -- Check if API is called in debug mode. If yes, disable debug.
445: AHL_DEBUG_PUB.disable_debug;
446: END IF;
447:

Line 450: END AHL_LTP_RESRC_LEVL_PUB;

446: END IF;
447:
448: END Derive_Resource_Consum;
449: --
450: END AHL_LTP_RESRC_LEVL_PUB;