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_APPR_SPACE_UNAVL_PVT dependencies on AHL_APPR_SPACE_UNAVL_PVT

Line 1: PACKAGE BODY AHL_APPR_SPACE_UNAVL_PVT AS

1: PACKAGE BODY AHL_APPR_SPACE_UNAVL_PVT AS
2: /* $Header: AHLVSUAB.pls 115.17 2003/11/04 10:43:21 rroy noship $ */
3: --
4:
5: G_PKG_NAME VARCHAR2(30) := 'AHL_APPR_SPACE_UNAVL_PVT';

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

1: PACKAGE BODY AHL_APPR_SPACE_UNAVL_PVT AS
2: /* $Header: AHLVSUAB.pls 115.17 2003/11/04 10:43:21 rroy noship $ */
3: --
4:
5: G_PKG_NAME VARCHAR2(30) := 'AHL_APPR_SPACE_UNAVL_PVT';
6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7: --
8: -----------------------------------------------------------
9: -- PACKAGE

Line 10: -- AHL_APPR_SPACE_UNAVL_PVT

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

Line 855: AHL_DEBUG_PUB.debug( 'enter ahl_appr_space_unavl_pvt.Create Space Restriction','+SUAVL+');

851: AHL_DEBUG_PUB.enable_debug;
852: END IF;
853: -- Debug info.
854: IF G_DEBUG='Y' THEN
855: AHL_DEBUG_PUB.debug( 'enter ahl_appr_space_unavl_pvt.Create Space Restriction','+SUAVL+');
856: END IF;
857: -- Standard call to check for call compatibility.
858: IF FND_API.to_boolean(p_init_msg_list)
859: THEN

Line 1216: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Create Space Restriction','+SUAVL+');

1212: p_data => x_msg_data);
1213: IF G_DEBUG='Y' THEN
1214: AHL_DEBUG_PUB.log_app_messages (
1215: x_msg_count, x_msg_data, 'ERROR' );
1216: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Create Space Restriction','+SUAVL+');
1217: -- Check if API is called in debug mode. If yes, disable debug.
1218: AHL_DEBUG_PUB.disable_debug;
1219: END IF;
1220: WHEN FND_API.G_EXC_ERROR THEN

Line 1230: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Create Space Restriction','+SUAVL+');

1226: IF G_DEBUG='Y' THEN
1227: -- Debug info.
1228: AHL_DEBUG_PUB.log_app_messages (
1229: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1230: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Create Space Restriction','+SUAVL+');
1231: -- Check if API is called in debug mode. If yes, disable debug.
1232: AHL_DEBUG_PUB.disable_debug;
1233: END IF;
1234:

Line 1240: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_SPACE_UNAVL_PVT',

1236: ROLLBACK TO create_space_restriction;
1237: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1238: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1239: THEN
1240: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_SPACE_UNAVL_PVT',
1241: p_procedure_name => 'CREATE_SPACE_RESTRICTION',
1242: p_error_text => SUBSTR(SQLERRM,1,240));
1243: END IF;
1244: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1251: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Create Space Restriction','+SUAVL+');

1247: IF G_DEBUG='Y' THEN
1248: -- Debug info.
1249: AHL_DEBUG_PUB.log_app_messages (
1250: x_msg_count, x_msg_data, 'SQL ERROR' );
1251: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Create Space Restriction','+SUAVL+');
1252: -- Check if API is called in debug mode. If yes, disable debug.
1253: AHL_DEBUG_PUB.disable_debug;
1254: END IF;
1255:

Line 1336: AHL_DEBUG_PUB.debug( 'enter ahl_appr_space_unavl_pvt.Update Space Restriction','+SUAVL+');

1332: -- Check if API is called in debug mode. If yes, enable debug.
1333: IF G_DEBUG='Y' THEN
1334: AHL_DEBUG_PUB.enable_debug;
1335: -- Debug info.
1336: AHL_DEBUG_PUB.debug( 'enter ahl_appr_space_unavl_pvt.Update Space Restriction','+SUAVL+');
1337: END IF;
1338: -- Standard call to check for call compatibility.
1339: IF FND_API.to_boolean(p_init_msg_list)
1340: THEN

Line 1502: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Update Space Restriction','+SUAVL+');

1498: p_data => x_msg_data);
1499: IF G_DEBUG='Y' THEN
1500: AHL_DEBUG_PUB.log_app_messages (
1501: x_msg_count, x_msg_data, 'ERROR' );
1502: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Update Space Restriction','+SUAVL+');
1503: -- Check if API is called in debug mode. If yes, disable debug.
1504: AHL_DEBUG_PUB.disable_debug;
1505: END IF;
1506:

Line 1517: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Update Space Restriction','+SUAVL+');

1513: IF G_DEBUG='Y' THEN
1514: -- Debug info.
1515: AHL_DEBUG_PUB.log_app_messages (
1516: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1517: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Update Space Restriction','+SUAVL+');
1518: -- Check if API is called in debug mode. If yes, disable debug.
1519: AHL_DEBUG_PUB.disable_debug;
1520: END IF;
1521:

Line 1527: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_SPACE_UNAVL_PVT',

1523: ROLLBACK TO update_space_restriction;
1524: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1525: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1526: THEN
1527: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_SPACE_UNAVL_PVT',
1528: p_procedure_name => 'UPDATE_SPACE_RESTRICTION',
1529: p_error_text => SUBSTR(SQLERRM,1,240));
1530: END IF;
1531: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1538: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Update Space Restriction','+SUAVL+');

1534: IF G_DEBUG='Y' THEN
1535: -- Debug info.
1536: AHL_DEBUG_PUB.log_app_messages (
1537: x_msg_count, x_msg_data, 'SQL ERROR' );
1538: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Update Space Restriction','+SUAVL+');
1539: -- Check if API is called in debug mode. If yes, disable debug.
1540: AHL_DEBUG_PUB.disable_debug;
1541: END IF;
1542: END Update_Space_Restriction;

Line 1597: AHL_DEBUG_PUB.debug( 'enter ahl_appr_space_unavl_pvt.Delete Space Restriction','+SUAVL+');

1593: AHL_DEBUG_PUB.enable_debug;
1594: END IF;
1595: -- Debug info.
1596: IF G_DEBUG='Y' THEN
1597: AHL_DEBUG_PUB.debug( 'enter ahl_appr_space_unavl_pvt.Delete Space Restriction','+SUAVL+');
1598: END IF;
1599: -- Standard call to check for call compatibility.
1600: IF FND_API.to_boolean(p_init_msg_list)
1601: THEN

Line 1669: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Delete Space Restriction','+SUAVL+');

1665: p_data => x_msg_data);
1666: IF G_DEBUG='Y' THEN
1667: AHL_DEBUG_PUB.log_app_messages (
1668: x_msg_count, x_msg_data, 'ERROR' );
1669: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Delete Space Restriction','+SUAVL+');
1670: -- Check if API is called in debug mode. If yes, disable debug.
1671: AHL_DEBUG_PUB.disable_debug;
1672: END IF;
1673: WHEN FND_API.G_EXC_ERROR THEN

Line 1683: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Delete Space Restriction','+SUAVL+');

1679: IF G_DEBUG='Y' THEN
1680: -- Debug info.
1681: AHL_DEBUG_PUB.log_app_messages (
1682: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1683: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Delete Space Restriction','+SUAVL+');
1684: -- Check if API is called in debug mode. If yes, disable debug.
1685: AHL_DEBUG_PUB.disable_debug;
1686: END IF;
1687:

Line 1693: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_SPACE_UNAVL_PVT',

1689: ROLLBACK TO delete_space_restriction;
1690: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1692: THEN
1693: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_SPACE_UNAVL_PVT',
1694: p_procedure_name => 'DELETE_SPACE_RESTRICTION',
1695: p_error_text => SUBSTR(SQLERRM,1,240));
1696: END IF;
1697: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1704: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Delete Space Restriction','+SUAVL+');

1700: IF G_DEBUG='Y' THEN
1701: -- Debug info.
1702: AHL_DEBUG_PUB.log_app_messages (
1703: x_msg_count, x_msg_data, 'SQL ERROR' );
1704: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pvt.Delete Space Restriction','+SUAVL+');
1705: -- Check if API is called in debug mode. If yes, disable debug.
1706: AHL_DEBUG_PUB.disable_debug;
1707: END IF;
1708:

Line 1711: END AHL_APPR_SPACE_UNAVL_PVT;

1707: END IF;
1708:
1709: END Delete_Space_Restriction;
1710:
1711: END AHL_APPR_SPACE_UNAVL_PVT;