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_DI_SUBSCRIPTION_PVT dependencies on AHL_DI_SUBSCRIPTION_PVT

Line 1: PACKAGE BODY AHL_DI_SUBSCRIPTION_PVT AS

1: PACKAGE BODY AHL_DI_SUBSCRIPTION_PVT AS
2: /* $Header: AHLVSUBB.pls 120.2 2006/02/07 03:49:26 sagarwal noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_SUBSCRIPTION_PVT';
5: --

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

1: PACKAGE BODY AHL_DI_SUBSCRIPTION_PVT AS
2: /* $Header: AHLVSUBB.pls 120.2 2006/02/07 03:49:26 sagarwal noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_SUBSCRIPTION_PVT';
5: --
6:
7: -- Validates the Subscriptions Info
8: /*---------------------------------------------------------*/

Line 529: AHL_DEBUG_PUB.debug( 'enter ahl_di_subscription_pvt.Create Subscription','+SUB+');

525: END IF;
526: -- Debug info.
527: IF G_DEBUG='Y' THEN
528: IF G_DEBUG='Y' THEN
529: AHL_DEBUG_PUB.debug( 'enter ahl_di_subscription_pvt.Create Subscription','+SUB+');
530:
531: END IF;
532: END IF;
533: -- Standard call to check for call compatibility.

Line 828: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Create Subscription','+SUB+');

824: p_data => x_msg_data);
825:
826: IF G_DEBUG='Y' THEN
827: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
828: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Create Subscription','+SUB+');
829:
830:
831: -- Check if API is called in debug mode. If yes, disable debug.
832: AHL_DEBUG_PUB.disable_debug;

Line 845: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Create Subscription','+SUB+');

841: p_data => X_msg_data);
842: -- Debug info.
843: IF G_DEBUG='Y' THEN
844: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
845: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Create Subscription','+SUB+');
846:
847:
848: -- Check if API is called in debug mode. If yes, disable debug.
849: AHL_DEBUG_PUB.disable_debug;

Line 871: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_SUBSCRIPTION_PVT',

867: ROLLBACK TO create_subscription;
868: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_SUBSCRIPTION_PVT',
872: p_procedure_name => 'CREATE_SUBSCRIPTION',
873: p_error_text => SUBSTR(SQLERRM,1,240));
874: END IF;
875: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 881: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Create Subscription','+SUB+');

877: p_data => X_msg_data);
878: -- Debug info.
879: IF G_DEBUG='Y' THEN
880: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
881: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Create Subscription','+SUB+');
882:
883:
884: -- Check if API is called in debug mode. If yes, disable debug.
885: AHL_DEBUG_PUB.disable_debug;

Line 1037: AHL_DEBUG_PUB.debug( 'enter ahl_di_subscription_pvt.Modify Subscription','+SUB+');

1033:
1034: END IF;
1035: -- Debug info.
1036: IF G_DEBUG='Y' THEN
1037: AHL_DEBUG_PUB.debug( 'enter ahl_di_subscription_pvt.Modify Subscription','+SUB+');
1038: END IF;
1039: -- Standard call to check for call compatibility.
1040: IF FND_API.to_boolean(p_init_msg_list)
1041: THEN

Line 1413: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Modify Subscription','+SUB+');

1409: p_data => x_msg_data);
1410:
1411: IF G_DEBUG='Y' THEN
1412: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1413: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Modify Subscription','+SUB+');
1414:
1415:
1416: -- Check if API is called in debug mode. If yes, disable debug.
1417: AHL_DEBUG_PUB.disable_debug;

Line 1430: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Modify Subscription','+SUB+');

1426: p_data => X_msg_data);
1427: -- Debug info.
1428: IF G_DEBUG='Y' THEN
1429: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1430: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Modify Subscription','+SUB+');
1431:
1432:
1433: -- Check if API is called in debug mode. If yes, disable debug.
1434: AHL_DEBUG_PUB.disable_debug;

Line 1443: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_SUBSCRIPTION_PVT',

1439: ROLLBACK TO modify_subscription;
1440: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_SUBSCRIPTION_PVT',
1444: p_procedure_name => 'MODIFY_SUBSCRIPTION',
1445: p_error_text => SUBSTR(SQLERRM,1,240));
1446: END IF;
1447: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1454: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Modify Subscription','+SUB+');

1450:
1451: -- Debug info.
1452: IF G_DEBUG='Y' THEN
1453: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1454: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pvt.Modify Subscription','+SUB+');
1455:
1456:
1457: -- Check if API is called in debug mode. If yes, disable debug.
1458: AHL_DEBUG_PUB.disable_debug;

Line 1611: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_SUBSCRIPTION_PVT',

1607: ROLLBACK TO delete_subscription;
1608: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1609: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1610: THEN
1611: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_SUBSCRIPTION_PVT',
1612: p_procedure_name => 'DELETE_SUBSCRIPTION',
1613: p_error_text => SUBSTR(SQLERRM,1,240));
1614: END IF;
1615: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1621: END AHL_DI_SUBSCRIPTION_PVT;

1617: p_data => X_msg_data);
1618:
1619: END DELETE_SUBSCRIPTION;
1620:
1621: END AHL_DI_SUBSCRIPTION_PVT;