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_ASSIGN_PVT dependencies on AHL_LTP_SPACE_ASSIGN_PVT

Line 1: PACKAGE BODY AHL_LTP_SPACE_ASSIGN_PVT AS

1: PACKAGE BODY AHL_LTP_SPACE_ASSIGN_PVT AS
2: /* $Header: AHLVSANB.pls 120.0.12020000.2 2012/12/07 14:35:19 sareepar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SPACE_ASSIGN_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

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

1: PACKAGE BODY AHL_LTP_SPACE_ASSIGN_PVT AS
2: /* $Header: AHLVSANB.pls 120.0.12020000.2 2012/12/07 14:35:19 sareepar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SPACE_ASSIGN_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: -- PACKAGE
8: -- AHL_LTP_SPACE_ASSIGN_PVT

Line 8: -- AHL_LTP_SPACE_ASSIGN_PVT

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

Line 1129: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Create Space Assignment','+SPASN+');

1125: AHL_DEBUG_PUB.enable_debug;
1126: END IF;
1127: -- Debug info.
1128: IF G_DEBUG='Y' THEN
1129: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Create Space Assignment','+SPASN+');
1130: END IF;
1131: -- Standard call to check for call compatibility.
1132: IF FND_API.to_boolean(p_init_msg_list)
1133: THEN

Line 1530: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');

1526: IF G_DEBUG='Y' THEN
1527:
1528: AHL_DEBUG_PUB.log_app_messages (
1529: x_msg_count, x_msg_data, 'ERROR' );
1530: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1531: -- Check if API is called in debug mode. If yes, disable debug.
1532: AHL_DEBUG_PUB.disable_debug;
1533: END IF;
1534: WHEN FND_API.G_EXC_ERROR THEN

Line 1544: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');

1540: IF G_DEBUG='Y' THEN
1541: -- Debug info.
1542: AHL_DEBUG_PUB.log_app_messages (
1543: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1544: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1545: -- Check if API is called in debug mode. If yes, disable debug.
1546: AHL_DEBUG_PUB.disable_debug;
1547: END IF;
1548: WHEN OTHERS THEN

Line 1553: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',

1549: ROLLBACK TO create_space_assignment;
1550: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1552: THEN
1553: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',
1554: p_procedure_name => 'CREATE_SPACE_ASSIGNMENT',
1555: p_error_text => SUBSTR(SQLERRM,1,240));
1556: END IF;
1557: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1564: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');

1560: IF G_DEBUG='Y' THEN
1561: -- Debug info.
1562: AHL_DEBUG_PUB.log_app_messages (
1563: x_msg_count, x_msg_data, 'SQL ERROR' );
1564: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1565: -- Check if API is called in debug mode. If yes, disable debug.
1566: AHL_DEBUG_PUB.disable_debug;
1567: END IF;
1568: END Create_Space_assignment;

Line 1616: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');

1612: AHL_DEBUG_PUB.enable_debug;
1613: END IF;
1614: -- Debug info.
1615: IF G_DEBUG='Y' THEN
1616: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1617: END IF;
1618: -- Standard call to check for call compatibility.
1619: IF FND_API.to_boolean(p_init_msg_list)
1620: THEN

Line 1768: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');

1764: IF G_DEBUG='Y' THEN
1765:
1766: AHL_DEBUG_PUB.log_app_messages (
1767: x_msg_count, x_msg_data, 'ERROR' );
1768: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1769: -- Check if API is called in debug mode. If yes, disable debug.
1770: AHL_DEBUG_PUB.disable_debug;
1771: END IF;
1772: WHEN FND_API.G_EXC_ERROR THEN

Line 1782: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');

1778: IF G_DEBUG='Y' THEN
1779: -- Debug info.
1780: AHL_DEBUG_PUB.log_app_messages (
1781: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1782: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1783: -- Check if API is called in debug mode. If yes, disable debug.
1784: AHL_DEBUG_PUB.disable_debug;
1785: END IF;
1786: WHEN OTHERS THEN

Line 1791: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',

1787: ROLLBACK TO update_space_assignment;
1788: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1790: THEN
1791: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',
1792: p_procedure_name => 'UPDATE_SPACE_ASSIGNMENT',
1793: p_error_text => SUBSTR(SQLERRM,1,240));
1794: END IF;
1795: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1803: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignemnt','+SPANT+');

1799: IF G_DEBUG='Y' THEN
1800: -- Debug info.
1801: AHL_DEBUG_PUB.log_app_messages (
1802: x_msg_count, x_msg_data, 'SQL ERROR' );
1803: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignemnt','+SPANT+');
1804: -- Check if API is called in debug mode. If yes, disable debug.
1805: AHL_DEBUG_PUB.disable_debug;
1806: END IF;
1807: END Update_Space_Assignment;

Line 1900: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');

1896: AHL_DEBUG_PUB.enable_debug;
1897: END IF;
1898: -- Debug info.
1899: IF G_DEBUG='Y' THEN
1900: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1901: END IF;
1902: -- Standard call to check for call compatibility.
1903: IF FND_API.to_boolean(p_init_msg_list)
1904: THEN

Line 2043: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');

2039: IF G_DEBUG='Y' THEN
2040:
2041: AHL_DEBUG_PUB.log_app_messages (
2042: x_msg_count, x_msg_data, 'ERROR' );
2043: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2044: -- Check if API is called in debug mode. If yes, disable debug.
2045: AHL_DEBUG_PUB.disable_debug;
2046: END IF;
2047: WHEN FND_API.G_EXC_ERROR THEN

Line 2058: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');

2054:
2055: -- Debug info.
2056: AHL_DEBUG_PUB.log_app_messages (
2057: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2058: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2059: -- Check if API is called in debug mode. If yes, disable debug.
2060: AHL_DEBUG_PUB.disable_debug;
2061: END IF;
2062: WHEN OTHERS THEN

Line 2067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',

2063: ROLLBACK TO delete_space_assignment;
2064: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2066: THEN
2067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',
2068: p_procedure_name => 'DELETE_SPACE_ASSIGNMENT',
2069: p_error_text => SUBSTR(SQLERRM,1,240));
2070: END IF;
2071: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2079: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');

2075:
2076: -- Debug info.
2077: AHL_DEBUG_PUB.log_app_messages (
2078: x_msg_count, x_msg_data, 'SQL ERROR' );
2079: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2080: -- Check if API is called in debug mode. If yes, disable debug.
2081: AHL_DEBUG_PUB.disable_debug;
2082: END IF;
2083: END Delete_Space_Assignment;

Line 2193: 'ahl.plsql.AHL_LTP_SPACE_ASSIGN_PVT.Schedule_Visit',

2189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2190: fnd_log.string
2191: (
2192: fnd_log.level_procedure,
2193: 'ahl.plsql.AHL_LTP_SPACE_ASSIGN_PVT.Schedule_Visit',
2194: 'At the start of PLSQL procedure'
2195: );
2196: END IF;
2197:

Line 2207: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');

2203: AHL_DEBUG_PUB.enable_debug;
2204: END IF;
2205: -- Debug info.
2206: IF G_DEBUG='Y' THEN
2207: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2208: END IF;
2209: -- Standard call to check for call compatibility.
2210: IF FND_API.to_boolean(p_init_msg_list)
2211: THEN

Line 2659: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');

2655: IF G_DEBUG='Y' THEN
2656:
2657: AHL_DEBUG_PUB.log_app_messages (
2658: x_msg_count, x_msg_data, 'ERROR' );
2659: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2660: -- Check if API is called in debug mode. If yes, disable debug.
2661: AHL_DEBUG_PUB.disable_debug;
2662: END IF;
2663: WHEN FND_API.G_EXC_ERROR THEN

Line 2674: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule visit','+SPANT+');

2670:
2671: -- Debug info.
2672: AHL_DEBUG_PUB.log_app_messages (
2673: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2674: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule visit','+SPANT+');
2675: -- Check if API is called in debug mode. If yes, disable debug.
2676: AHL_DEBUG_PUB.disable_debug;
2677: END IF;
2678: WHEN OTHERS THEN

Line 2683: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',

2679: ROLLBACK TO schedule_visit;
2680: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2682: THEN
2683: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',
2684: p_procedure_name => 'SCHEDULE_VISIT',
2685: p_error_text => SUBSTR(SQLERRM,1,240));
2686: END IF;
2687: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2695: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');

2691:
2692: -- Debug info.
2693: AHL_DEBUG_PUB.log_app_messages (
2694: x_msg_count, x_msg_data, 'SQL ERROR' );
2695: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2696: -- Check if API is called in debug mode. If yes, disable debug.
2697: AHL_DEBUG_PUB.disable_debug;
2698:
2699: END IF;

Line 2795: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');

2791: AHL_DEBUG_PUB.enable_debug;
2792: END IF;
2793: -- Debug info.
2794: IF G_DEBUG='Y' THEN
2795: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2796: END IF;
2797: -- Standard call to check for call compatibility.
2798: IF FND_API.to_boolean(p_init_msg_list)
2799: THEN

Line 3018: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');

3014: IF G_DEBUG='Y' THEN
3015:
3016: AHL_DEBUG_PUB.log_app_messages (
3017: x_msg_count, x_msg_data, 'ERROR' );
3018: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
3019: -- Check if API is called in debug mode. If yes, disable debug.
3020: AHL_DEBUG_PUB.disable_debug;
3021: END IF;
3022: WHEN FND_API.G_EXC_ERROR THEN

Line 3033: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule visit','+SPANT+');

3029:
3030: -- Debug info.
3031: AHL_DEBUG_PUB.log_app_messages (
3032: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3033: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule visit','+SPANT+');
3034: -- Check if API is called in debug mode. If yes, disable debug.
3035: AHL_DEBUG_PUB.disable_debug;
3036: END IF;
3037: WHEN OTHERS THEN

Line 3042: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',

3038: ROLLBACK TO unschedule_visit;
3039: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3041: THEN
3042: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',
3043: p_procedure_name => 'UNSCHEDULE_VISIT',
3044: p_error_text => SUBSTR(SQLERRM,1,240));
3045: END IF;
3046: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3054: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');

3050:
3051: -- Debug info.
3052: AHL_DEBUG_PUB.log_app_messages (
3053: x_msg_count, x_msg_data, 'SQL ERROR' );
3054: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
3055: -- Check if API is called in debug mode. If yes, disable debug.
3056: AHL_DEBUG_PUB.disable_debug;
3057: END IF;
3058: END Unschedule_Visit;

Line 3060: END AHL_LTP_SPACE_ASSIGN_PVT;

3056: AHL_DEBUG_PUB.disable_debug;
3057: END IF;
3058: END Unschedule_Visit;
3059:
3060: END AHL_LTP_SPACE_ASSIGN_PVT;