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_DOC_REVISION_PUB dependencies on AHL_DEBUG_PUB

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

8: /* */
9: /*-----------------------------------------------------------*/
10:
11: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
12: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
13: PROCEDURE Check_lookup_name_Or_Id
14: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
15: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE,
16: p_meaning IN FND_LOOKUPS.meaning%TYPE,

Line 150: AHL_DEBUG_PUB.enable_debug;

146: -- Standard Start of API savepoint
147: SAVEPOINT create_revision;
148: -- Check if API is called in debug mode. If yes, enable debug.
149: IF G_DEBUG='Y' THEN
150: AHL_DEBUG_PUB.enable_debug;
151:
152: END IF;
153: -- Debug info.
154: IF G_DEBUG='Y' THEN

Line 156: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pub.Create Revision','+REV+');

152: END IF;
153: -- Debug info.
154: IF G_DEBUG='Y' THEN
155: IF G_DEBUG='Y' THEN
156: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pub.Create Revision','+REV+');
157:
158: END IF;
159: END IF;
160: -- Standard call to check for call compatibility.

Line 530: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_PRE');

526: 'B', 'C' ) then
527:
528:
529: IF G_DEBUG='Y' THEN
530: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_PRE');
531:
532: END IF;
533:
534: AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_PRE

Line 545: AHL_DEBUG_PUB.debug( 'end AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_PRE');

541: );
542:
543:
544: IF G_DEBUG='Y' THEN
545: AHL_DEBUG_PUB.debug( 'end AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_PRE');
546:
547: END IF;
548:
549:

Line 560: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_PRE');

556:
557: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',
558: 'B', 'V' ) then
559: IF G_DEBUG='Y' THEN
560: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_PRE');
561:
562: END IF;
563:
564: AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_PRE(

Line 572: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_PRE');

568: X_MSG_DATA => l_msg_data );
569:
570:
571: IF G_DEBUG='Y' THEN
572: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_PRE');
573:
574: END IF;
575:
576: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 642: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_POST');

638: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',
639: 'A', 'V' ) then
640:
641: IF G_DEBUG='Y' THEN
642: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_POST');
643:
644: END IF;
645:
646: AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_POST(

Line 653: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_POST');

649: X_MSG_COUNT => l_msg_count ,
650: X_MSG_DATA => l_msg_data );
651:
652: IF G_DEBUG='Y' THEN
653: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_POST');
654:
655: END IF;
656:
657: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 669: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_POST');

665: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',
666: 'A', 'C' ) then
667:
668: IF G_DEBUG='Y' THEN
669: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_POST');
670:
671: END IF;
672:
673: AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_POST(

Line 681: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_POST');

677: X_MSG_COUNT => l_msg_count ,
678: X_MSG_DATA => l_msg_data );
679:
680: IF G_DEBUG='Y' THEN
681: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_POST');
682:
683: END IF;
684:
685: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 707: AHL_DEBUG_PUB.debug( 'End of public api Create Revision','+REV+');

703: COMMIT;
704: END IF;
705: -- Debug info
706: IF G_DEBUG='Y' THEN
707: AHL_DEBUG_PUB.debug( 'End of public api Create Revision','+REV+');
708:
709: END IF;
710: -- Check if API is called in debug mode. If yes, disable debug.
711: IF G_DEBUG='Y' THEN

Line 712: AHL_DEBUG_PUB.disable_debug;

708:
709: END IF;
710: -- Check if API is called in debug mode. If yes, disable debug.
711: IF G_DEBUG='Y' THEN
712: AHL_DEBUG_PUB.disable_debug;
713:
714: END IF;
715:
716: x_msg_data := 'tHIS IS A cHECK'||TO_CHAR(p_x_revision_tbl(1).approved_by_party_id);

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

721: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
722: p_count => x_msg_count,
723: p_data => x_msg_data);
724: IF G_DEBUG='Y' THEN
725: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
726: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
727:
728:
729: -- Check if API is called in debug mode. If yes, disable debug.

Line 726: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');

722: p_count => x_msg_count,
723: p_data => x_msg_data);
724: IF G_DEBUG='Y' THEN
725: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
726: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
727:
728:
729: -- Check if API is called in debug mode. If yes, disable debug.
730: AHL_DEBUG_PUB.disable_debug;

Line 730: AHL_DEBUG_PUB.disable_debug;

726: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
727:
728:
729: -- Check if API is called in debug mode. If yes, disable debug.
730: AHL_DEBUG_PUB.disable_debug;
731:
732: END IF;
733:
734: WHEN FND_API.G_EXC_ERROR THEN

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

738: p_count => x_msg_count,
739: p_data => X_msg_data);
740: -- Debug info.
741: IF G_DEBUG='Y' THEN
742: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
743: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
744:
745:
746: -- Check if API is called in debug mode. If yes, disable debug.

Line 743: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');

739: p_data => X_msg_data);
740: -- Debug info.
741: IF G_DEBUG='Y' THEN
742: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
743: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
744:
745:
746: -- Check if API is called in debug mode. If yes, disable debug.
747: AHL_DEBUG_PUB.disable_debug;

Line 747: AHL_DEBUG_PUB.disable_debug;

743: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
744:
745:
746: -- Check if API is called in debug mode. If yes, disable debug.
747: AHL_DEBUG_PUB.disable_debug;
748:
749: END IF;
750:
751:

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

762: p_count => x_msg_count,
763: p_data => X_msg_data);
764: -- Debug info.
765: IF G_DEBUG='Y' THEN
766: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
767: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
768:
769: -- Check if API is called in debug mode. If yes, disable debug.
770: AHL_DEBUG_PUB.disable_debug;

Line 767: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');

763: p_data => X_msg_data);
764: -- Debug info.
765: IF G_DEBUG='Y' THEN
766: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
767: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
768:
769: -- Check if API is called in debug mode. If yes, disable debug.
770: AHL_DEBUG_PUB.disable_debug;
771:

Line 770: AHL_DEBUG_PUB.disable_debug;

766: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
767: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
768:
769: -- Check if API is called in debug mode. If yes, disable debug.
770: AHL_DEBUG_PUB.disable_debug;
771:
772: END IF;
773:
774: END CREATE_REVISION;

Line 871: AHL_DEBUG_PUB.enable_debug;

867: -- Standard Start of API savepoint
868: SAVEPOINT modify_revision;
869: -- Check if API is called in debug mode. If yes, enable debug.
870: IF G_DEBUG='Y' THEN
871: AHL_DEBUG_PUB.enable_debug;
872:
873: END IF;
874: -- Debug info.
875: IF G_DEBUG='Y' THEN

Line 877: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pub.Modify Revision','+REV+');

873: END IF;
874: -- Debug info.
875: IF G_DEBUG='Y' THEN
876: IF G_DEBUG='Y' THEN
877: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pub.Modify Revision','+REV+');
878:
879: END IF;
880: END IF;
881: -- Standard call to check for call compatibility.

Line 1256: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_PRE');

1252:
1253: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',
1254: 'B', 'C' ) then
1255: IF G_DEBUG='Y' THEN
1256: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_PRE');
1257:
1258: END IF;
1259:
1260: AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_PRE

Line 1271: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_PRE');

1267: );
1268:
1269:
1270: IF G_DEBUG='Y' THEN
1271: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_PRE');
1272:
1273: END IF;
1274:
1275: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1285: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_PRE');

1281:
1282: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',
1283: 'B', 'V' ) then
1284: IF G_DEBUG='Y' THEN
1285: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_PRE');
1286:
1287: END IF;
1288:
1289:

Line 1303: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_PRE');

1299: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: END IF;
1302: IF G_DEBUG='Y' THEN
1303: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_PRE');
1304:
1305: END IF;
1306:
1307: END IF;

Line 1357: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_POST');

1353:
1354: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',
1355: 'A', 'V' ) then
1356: IF G_DEBUG='Y' THEN
1357: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_POST');
1358:
1359: END IF;
1360:
1361: AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_POST(

Line 1369: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_POST');

1365: X_MSG_DATA => l_msg_data );
1366:
1367:
1368: IF G_DEBUG='Y' THEN
1369: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_POST');
1370:
1371: END IF;
1372:
1373: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1385: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_POST');

1381:
1382: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',
1383: 'A', 'C' ) then
1384: IF G_DEBUG='Y' THEN
1385: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_POST');
1386:
1387: END IF;
1388:
1389: AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_POST(

Line 1397: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_POST');

1393: X_MSG_COUNT => l_msg_count ,
1394: X_MSG_DATA => l_msg_data );
1395:
1396: IF G_DEBUG='Y' THEN
1397: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_POST');
1398:
1399: END IF;
1400:
1401: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1422: AHL_DEBUG_PUB.debug( 'End of public api Modify Revision','+REV+');

1418: COMMIT;
1419: END IF;
1420: -- Debug info
1421: IF G_DEBUG='Y' THEN
1422: AHL_DEBUG_PUB.debug( 'End of public api Modify Revision','+REV+');
1423:
1424: END IF;
1425: -- Check if API is called in debug mode. If yes, disable debug.
1426: IF G_DEBUG='Y' THEN

Line 1427: AHL_DEBUG_PUB.disable_debug;

1423:
1424: END IF;
1425: -- Check if API is called in debug mode. If yes, disable debug.
1426: IF G_DEBUG='Y' THEN
1427: AHL_DEBUG_PUB.disable_debug;
1428:
1429: END IF;
1430:
1431: x_msg_data := 'tHIS IS A cHECK'||TO_CHAR(p_x_revision_tbl(1).approved_by_party_id);

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

1437: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1438: p_count => x_msg_count,
1439: p_data => x_msg_data);
1440: IF G_DEBUG='Y' THEN
1441: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1442: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1443:
1444: -- Check if API is called in debug mode. If yes, disable debug.
1445: AHL_DEBUG_PUB.disable_debug;

Line 1442: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');

1438: p_count => x_msg_count,
1439: p_data => x_msg_data);
1440: IF G_DEBUG='Y' THEN
1441: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1442: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1443:
1444: -- Check if API is called in debug mode. If yes, disable debug.
1445: AHL_DEBUG_PUB.disable_debug;
1446:

Line 1445: AHL_DEBUG_PUB.disable_debug;

1441: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1442: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1443:
1444: -- Check if API is called in debug mode. If yes, disable debug.
1445: AHL_DEBUG_PUB.disable_debug;
1446:
1447: END IF;
1448:
1449: WHEN FND_API.G_EXC_ERROR THEN

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

1453: p_count => x_msg_count,
1454: p_data => X_msg_data);
1455: -- Debug info.
1456: IF G_DEBUG='Y' THEN
1457: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1458: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1459:
1460:
1461: -- Check if API is called in debug mode. If yes, disable debug.

Line 1458: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');

1454: p_data => X_msg_data);
1455: -- Debug info.
1456: IF G_DEBUG='Y' THEN
1457: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1458: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1459:
1460:
1461: -- Check if API is called in debug mode. If yes, disable debug.
1462: AHL_DEBUG_PUB.disable_debug;

Line 1462: AHL_DEBUG_PUB.disable_debug;

1458: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1459:
1460:
1461: -- Check if API is called in debug mode. If yes, disable debug.
1462: AHL_DEBUG_PUB.disable_debug;
1463:
1464: END IF;
1465:
1466: WHEN OTHERS THEN

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

1477: p_data => X_msg_data);
1478:
1479: -- Debug info.
1480: IF G_DEBUG='Y' THEN
1481: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1482: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1483:
1484:
1485: -- Check if API is called in debug mode. If yes, disable debug.

Line 1482: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');

1478:
1479: -- Debug info.
1480: IF G_DEBUG='Y' THEN
1481: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1482: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1483:
1484:
1485: -- Check if API is called in debug mode. If yes, disable debug.
1486: AHL_DEBUG_PUB.disable_debug;

Line 1486: AHL_DEBUG_PUB.disable_debug;

1482: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1483:
1484:
1485: -- Check if API is called in debug mode. If yes, disable debug.
1486: AHL_DEBUG_PUB.disable_debug;
1487:
1488: END IF;
1489:
1490: END MODIFY_REVISION;