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 2005/05/26 10:59:45 appldev noship $ */
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 2005/05/26 10:59:45 appldev noship $ */
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 785: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Create Space Assignment','+SPASN+');

781: AHL_DEBUG_PUB.enable_debug;
782: END IF;
783: -- Debug info.
784: IF G_DEBUG='Y' THEN
785: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Create Space Assignment','+SPASN+');
786: END IF;
787: -- Standard call to check for call compatibility.
788: IF FND_API.to_boolean(p_init_msg_list)
789: THEN

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

1141: IF G_DEBUG='Y' THEN
1142:
1143: AHL_DEBUG_PUB.log_app_messages (
1144: x_msg_count, x_msg_data, 'ERROR' );
1145: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1146: -- Check if API is called in debug mode. If yes, disable debug.
1147: AHL_DEBUG_PUB.disable_debug;
1148: END IF;
1149: WHEN FND_API.G_EXC_ERROR THEN

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

1155: IF G_DEBUG='Y' THEN
1156: -- Debug info.
1157: AHL_DEBUG_PUB.log_app_messages (
1158: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1159: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1160: -- Check if API is called in debug mode. If yes, disable debug.
1161: AHL_DEBUG_PUB.disable_debug;
1162: END IF;
1163: WHEN OTHERS THEN

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

1164: ROLLBACK TO create_space_assignment;
1165: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1167: THEN
1168: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',
1169: p_procedure_name => 'CREATE_SPACE_ASSIGNMENT',
1170: p_error_text => SUBSTR(SQLERRM,1,240));
1171: END IF;
1172: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1175: IF G_DEBUG='Y' THEN
1176: -- Debug info.
1177: AHL_DEBUG_PUB.log_app_messages (
1178: x_msg_count, x_msg_data, 'SQL ERROR' );
1179: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1180: -- Check if API is called in debug mode. If yes, disable debug.
1181: AHL_DEBUG_PUB.disable_debug;
1182: END IF;
1183: END Create_Space_assignment;

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

1226: AHL_DEBUG_PUB.enable_debug;
1227: END IF;
1228: -- Debug info.
1229: IF G_DEBUG='Y' THEN
1230: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1231: END IF;
1232: -- Standard call to check for call compatibility.
1233: IF FND_API.to_boolean(p_init_msg_list)
1234: THEN

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

1373: IF G_DEBUG='Y' THEN
1374:
1375: AHL_DEBUG_PUB.log_app_messages (
1376: x_msg_count, x_msg_data, 'ERROR' );
1377: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1378: -- Check if API is called in debug mode. If yes, disable debug.
1379: AHL_DEBUG_PUB.disable_debug;
1380: END IF;
1381: WHEN FND_API.G_EXC_ERROR THEN

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

1387: IF G_DEBUG='Y' THEN
1388: -- Debug info.
1389: AHL_DEBUG_PUB.log_app_messages (
1390: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1391: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1392: -- Check if API is called in debug mode. If yes, disable debug.
1393: AHL_DEBUG_PUB.disable_debug;
1394: END IF;
1395: WHEN OTHERS THEN

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

1396: ROLLBACK TO update_space_assignment;
1397: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1399: THEN
1400: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',
1401: p_procedure_name => 'UPDATE_SPACE_ASSIGNMENT',
1402: p_error_text => SUBSTR(SQLERRM,1,240));
1403: END IF;
1404: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1408: IF G_DEBUG='Y' THEN
1409: -- Debug info.
1410: AHL_DEBUG_PUB.log_app_messages (
1411: x_msg_count, x_msg_data, 'SQL ERROR' );
1412: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignemnt','+SPANT+');
1413: -- Check if API is called in debug mode. If yes, disable debug.
1414: AHL_DEBUG_PUB.disable_debug;
1415: END IF;
1416: END Update_Space_Assignment;

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

1499: AHL_DEBUG_PUB.enable_debug;
1500: END IF;
1501: -- Debug info.
1502: IF G_DEBUG='Y' THEN
1503: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1504: END IF;
1505: -- Standard call to check for call compatibility.
1506: IF FND_API.to_boolean(p_init_msg_list)
1507: THEN

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

1629: IF G_DEBUG='Y' THEN
1630:
1631: AHL_DEBUG_PUB.log_app_messages (
1632: x_msg_count, x_msg_data, 'ERROR' );
1633: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1634: -- Check if API is called in debug mode. If yes, disable debug.
1635: AHL_DEBUG_PUB.disable_debug;
1636: END IF;
1637: WHEN FND_API.G_EXC_ERROR THEN

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

1644:
1645: -- Debug info.
1646: AHL_DEBUG_PUB.log_app_messages (
1647: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1648: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1649: -- Check if API is called in debug mode. If yes, disable debug.
1650: AHL_DEBUG_PUB.disable_debug;
1651: END IF;
1652: WHEN OTHERS THEN

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

1653: ROLLBACK TO delete_space_assignment;
1654: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1656: THEN
1657: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',
1658: p_procedure_name => 'DELETE_SPACE_ASSIGNMENT',
1659: p_error_text => SUBSTR(SQLERRM,1,240));
1660: END IF;
1661: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1665:
1666: -- Debug info.
1667: AHL_DEBUG_PUB.log_app_messages (
1668: x_msg_count, x_msg_data, 'SQL ERROR' );
1669: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1670: -- Check if API is called in debug mode. If yes, disable debug.
1671: AHL_DEBUG_PUB.disable_debug;
1672: END IF;
1673: END Delete_Space_Assignment;

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

1779: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1780: fnd_log.string
1781: (
1782: fnd_log.level_procedure,
1783: 'ahl.plsql.AHL_LTP_SPACE_ASSIGN_PVT.Schedule_Visit',
1784: 'At the start of PLSQL procedure'
1785: );
1786: END IF;
1787:

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

1793: AHL_DEBUG_PUB.enable_debug;
1794: END IF;
1795: -- Debug info.
1796: IF G_DEBUG='Y' THEN
1797: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
1798: END IF;
1799: -- Standard call to check for call compatibility.
1800: IF FND_API.to_boolean(p_init_msg_list)
1801: THEN

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

2245: IF G_DEBUG='Y' THEN
2246:
2247: AHL_DEBUG_PUB.log_app_messages (
2248: x_msg_count, x_msg_data, 'ERROR' );
2249: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2250: -- Check if API is called in debug mode. If yes, disable debug.
2251: AHL_DEBUG_PUB.disable_debug;
2252: END IF;
2253: WHEN FND_API.G_EXC_ERROR THEN

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

2260:
2261: -- Debug info.
2262: AHL_DEBUG_PUB.log_app_messages (
2263: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2264: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule visit','+SPANT+');
2265: -- Check if API is called in debug mode. If yes, disable debug.
2266: AHL_DEBUG_PUB.disable_debug;
2267: END IF;
2268: WHEN OTHERS THEN

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

2269: ROLLBACK TO schedule_visit;
2270: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2272: THEN
2273: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',
2274: p_procedure_name => 'SCHEDULE_VISIT',
2275: p_error_text => SUBSTR(SQLERRM,1,240));
2276: END IF;
2277: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

2281:
2282: -- Debug info.
2283: AHL_DEBUG_PUB.log_app_messages (
2284: x_msg_count, x_msg_data, 'SQL ERROR' );
2285: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2286: -- Check if API is called in debug mode. If yes, disable debug.
2287: AHL_DEBUG_PUB.disable_debug;
2288:
2289: END IF;

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

2381: AHL_DEBUG_PUB.enable_debug;
2382: END IF;
2383: -- Debug info.
2384: IF G_DEBUG='Y' THEN
2385: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2386: END IF;
2387: -- Standard call to check for call compatibility.
2388: IF FND_API.to_boolean(p_init_msg_list)
2389: THEN

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

2604: IF G_DEBUG='Y' THEN
2605:
2606: AHL_DEBUG_PUB.log_app_messages (
2607: x_msg_count, x_msg_data, 'ERROR' );
2608: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2609: -- Check if API is called in debug mode. If yes, disable debug.
2610: AHL_DEBUG_PUB.disable_debug;
2611: END IF;
2612: WHEN FND_API.G_EXC_ERROR THEN

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

2619:
2620: -- Debug info.
2621: AHL_DEBUG_PUB.log_app_messages (
2622: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2623: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule visit','+SPANT+');
2624: -- Check if API is called in debug mode. If yes, disable debug.
2625: AHL_DEBUG_PUB.disable_debug;
2626: END IF;
2627: WHEN OTHERS THEN

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

2628: ROLLBACK TO unschedule_visit;
2629: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2630: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2631: THEN
2632: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PVT',
2633: p_procedure_name => 'UNSCHEDULE_VISIT',
2634: p_error_text => SUBSTR(SQLERRM,1,240));
2635: END IF;
2636: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

2640:
2641: -- Debug info.
2642: AHL_DEBUG_PUB.log_app_messages (
2643: x_msg_count, x_msg_data, 'SQL ERROR' );
2644: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2645: -- Check if API is called in debug mode. If yes, disable debug.
2646: AHL_DEBUG_PUB.disable_debug;
2647: END IF;
2648: END Unschedule_Visit;

Line 2650: END AHL_LTP_SPACE_ASSIGN_PVT;

2646: AHL_DEBUG_PUB.disable_debug;
2647: END IF;
2648: END Unschedule_Visit;
2649:
2650: END AHL_LTP_SPACE_ASSIGN_PVT;