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_DEBUG_PUB

Line 15: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;

11: /* new record as well before modification */
12: /* takes place */
13: /*---------------------------------------------------------*/
14:
15: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
16: PROCEDURE VALIDATE_SUBSCRIPTION
17: (
18: P_SUBSCRIPTION_ID IN NUMBER ,
19: P_DOCUMENT_ID IN NUMBER ,

Line 179: AHL_DEBUG_PUB.enable_debug;

175: --Enhancement nos #2034767 and #2205830: pbarman : April 2003
176: IF (NVL(p_delete_flag, 'N') = 'N' )
177: THEN
178: IF G_DEBUG='Y' THEN
179: AHL_DEBUG_PUB.enable_debug;
180: END IF;
181:
182: -- Perf Fixes for 4919023
183: BEGIN

Line 185: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PER','+SUB+');

181:
182: -- Perf Fixes for 4919023
183: BEGIN
184: IF G_DEBUG='Y' THEN
185: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PER','+SUB+');
186: END IF;
187: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER')
188: INTO l_prod_install_status
189: FROM DUAL;

Line 194: AHL_DEBUG_PUB.debug( 'VALIDATION START');

190: END;
191:
192: -- Debug info.
193: IF G_DEBUG='Y' THEN
194: AHL_DEBUG_PUB.debug( 'VALIDATION START');
195: END IF;
196: --When the process is update
197: IF p_subscription_id IS NOT NULL
198: THEN

Line 523: AHL_DEBUG_PUB.enable_debug;

519: SAVEPOINT create_subscription;
520:
521: -- Check if API is called in debug mode. If yes, enable debug.
522: IF G_DEBUG='Y' THEN
523: AHL_DEBUG_PUB.enable_debug;
524:
525: END IF;
526: -- Debug info.
527: IF G_DEBUG='Y' THEN

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 809: AHL_DEBUG_PUB.debug( 'End of private api Create Subscription','+SUB+');

805: COMMIT;
806: END IF;
807: -- Debug info
808: IF G_DEBUG='Y' THEN
809: AHL_DEBUG_PUB.debug( 'End of private api Create Subscription','+SUB+');
810:
811: END IF;
812: -- Check if API is called in debug mode. If yes, disable debug.
813: IF G_DEBUG='Y' THEN

Line 814: AHL_DEBUG_PUB.disable_debug;

810:
811: END IF;
812: -- Check if API is called in debug mode. If yes, disable debug.
813: IF G_DEBUG='Y' THEN
814: AHL_DEBUG_PUB.disable_debug;
815:
816: END IF;
817:
818: EXCEPTION

Line 827: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

823: p_count => x_msg_count,
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.

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 832: AHL_DEBUG_PUB.disable_debug;

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;
833:
834: END IF;
835:
836: WHEN FND_API.G_EXC_ERROR THEN

Line 844: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

840: p_count => x_msg_count,
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.

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 849: AHL_DEBUG_PUB.disable_debug;

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;
850:
851: END IF;
852:
853:

Line 861: AHL_DEBUG_PUB.disable_debug;

857: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBSC_DUP_RECORD');
858: FND_MSG_PUB.ADD;
859: -- Check if API is called in debug mode. If yes, disable debug.
860: IF G_DEBUG='Y' THEN
861: AHL_DEBUG_PUB.disable_debug;
862:
863: END IF;
864:
865:

Line 880: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

876: p_count => x_msg_count,
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.

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 885: AHL_DEBUG_PUB.disable_debug;

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;
886:
887: END IF;
888:
889: END CREATE_SUBSCRIPTION;

Line 1032: AHL_DEBUG_PUB.enable_debug;

1028: -- Standard Start of API savepoint
1029: SAVEPOINT modify_subscription;
1030: -- Check if API is called in debug mode. If yes, enable debug.
1031: IF G_DEBUG='Y' THEN
1032: AHL_DEBUG_PUB.enable_debug;
1033:
1034: END IF;
1035: -- Debug info.
1036: IF G_DEBUG='Y' THEN

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 1059: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PER','+SUB+');

1055:
1056: -- Perf Fixes for 4919023
1057: BEGIN
1058: IF G_DEBUG='Y' THEN
1059: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PER','+SUB+');
1060: END IF;
1061: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER')
1062: INTO l_prod_install_status
1063: FROM DUAL;

Line 1394: AHL_DEBUG_PUB.debug( 'End of private api Modify Subscription','+SUB+');

1390: COMMIT;
1391: END IF;
1392: -- Debug info
1393: IF G_DEBUG='Y' THEN
1394: AHL_DEBUG_PUB.debug( 'End of private api Modify Subscription','+SUB+');
1395:
1396: END IF;
1397: -- Check if API is called in debug mode. If yes, disable debug.
1398: IF G_DEBUG='Y' THEN

Line 1399: AHL_DEBUG_PUB.disable_debug;

1395:
1396: END IF;
1397: -- Check if API is called in debug mode. If yes, disable debug.
1398: IF G_DEBUG='Y' THEN
1399: AHL_DEBUG_PUB.disable_debug;
1400:
1401: END IF;
1402:
1403: EXCEPTION

Line 1412: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

1408: p_count => x_msg_count,
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.

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 1417: AHL_DEBUG_PUB.disable_debug;

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;
1418:
1419: END IF;
1420:
1421: WHEN FND_API.G_EXC_ERROR THEN

Line 1429: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

1425: p_count => x_msg_count,
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.

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 1434: AHL_DEBUG_PUB.disable_debug;

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;
1435:
1436: END IF;
1437:
1438: WHEN OTHERS THEN

Line 1453: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

1449: p_data => X_msg_data);
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.

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 1458: AHL_DEBUG_PUB.disable_debug;

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;
1459:
1460: END IF;
1461:
1462: END MODIFY_SUBSCRIPTION;