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 154: AHL_DEBUG_PUB.enable_debug;

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

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

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

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

535: 'B', 'C' ) then
536:
537:
538: IF G_DEBUG='Y' THEN
539: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_PRE');
540:
541: END IF;
542:
543: AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_PRE

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

550: );
551:
552:
553: IF G_DEBUG='Y' THEN
554: AHL_DEBUG_PUB.debug( 'end AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_PRE');
555:
556: END IF;
557:
558:

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

565:
566: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',
567: 'B', 'V' ) then
568: IF G_DEBUG='Y' THEN
569: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_PRE');
570:
571: END IF;
572:
573: AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_PRE(

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

577: X_MSG_DATA => l_msg_data );
578:
579:
580: IF G_DEBUG='Y' THEN
581: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_PRE');
582:
583: END IF;
584:
585: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

647: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',
648: 'A', 'V' ) then
649:
650: IF G_DEBUG='Y' THEN
651: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_POST');
652:
653: END IF;
654:
655: AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_POST(

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

658: X_MSG_COUNT => l_msg_count ,
659: X_MSG_DATA => l_msg_data );
660:
661: IF G_DEBUG='Y' THEN
662: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.CREATE_REVISION_POST');
663:
664: END IF;
665:
666: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

674: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',
675: 'A', 'C' ) then
676:
677: IF G_DEBUG='Y' THEN
678: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_POST');
679:
680: END IF;
681:
682: AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_POST(

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

686: X_MSG_COUNT => l_msg_count ,
687: X_MSG_DATA => l_msg_data );
688:
689: IF G_DEBUG='Y' THEN
690: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_CUHK.CREATE_REVISION_POST');
691:
692: END IF;
693:
694: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

712: COMMIT;
713: END IF;
714: -- Debug info
715: IF G_DEBUG='Y' THEN
716: AHL_DEBUG_PUB.debug( 'End of public api Create Revision','+REV+');
717:
718: END IF;
719: -- Check if API is called in debug mode. If yes, disable debug.
720: IF G_DEBUG='Y' THEN

Line 721: AHL_DEBUG_PUB.disable_debug;

717:
718: END IF;
719: -- Check if API is called in debug mode. If yes, disable debug.
720: IF G_DEBUG='Y' THEN
721: AHL_DEBUG_PUB.disable_debug;
722:
723: END IF;
724:
725: x_msg_data := 'tHIS IS A cHECK'||TO_CHAR(p_x_revision_tbl(1).approved_by_party_id);

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

730: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data);
733: IF G_DEBUG='Y' THEN
734: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
735: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
736:
737:
738: -- Check if API is called in debug mode. If yes, disable debug.

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

731: p_count => x_msg_count,
732: p_data => x_msg_data);
733: IF G_DEBUG='Y' THEN
734: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
735: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
736:
737:
738: -- Check if API is called in debug mode. If yes, disable debug.
739: AHL_DEBUG_PUB.disable_debug;

Line 739: AHL_DEBUG_PUB.disable_debug;

735: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
736:
737:
738: -- Check if API is called in debug mode. If yes, disable debug.
739: AHL_DEBUG_PUB.disable_debug;
740:
741: END IF;
742:
743: WHEN FND_API.G_EXC_ERROR THEN

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

747: p_count => x_msg_count,
748: p_data => X_msg_data);
749: -- Debug info.
750: IF G_DEBUG='Y' THEN
751: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
752: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
753:
754:
755: -- Check if API is called in debug mode. If yes, disable debug.

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

748: p_data => X_msg_data);
749: -- Debug info.
750: IF G_DEBUG='Y' THEN
751: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
752: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
753:
754:
755: -- Check if API is called in debug mode. If yes, disable debug.
756: AHL_DEBUG_PUB.disable_debug;

Line 756: AHL_DEBUG_PUB.disable_debug;

752: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
753:
754:
755: -- Check if API is called in debug mode. If yes, disable debug.
756: AHL_DEBUG_PUB.disable_debug;
757:
758: END IF;
759:
760:

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

771: p_count => x_msg_count,
772: p_data => X_msg_data);
773: -- Debug info.
774: IF G_DEBUG='Y' THEN
775: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
776: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
777:
778: -- Check if API is called in debug mode. If yes, disable debug.
779: AHL_DEBUG_PUB.disable_debug;

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

772: p_data => X_msg_data);
773: -- Debug info.
774: IF G_DEBUG='Y' THEN
775: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
776: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
777:
778: -- Check if API is called in debug mode. If yes, disable debug.
779: AHL_DEBUG_PUB.disable_debug;
780:

Line 779: AHL_DEBUG_PUB.disable_debug;

775: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
776: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Create Revision','+REV+');
777:
778: -- Check if API is called in debug mode. If yes, disable debug.
779: AHL_DEBUG_PUB.disable_debug;
780:
781: END IF;
782:
783: END CREATE_REVISION;

Line 894: AHL_DEBUG_PUB.enable_debug;

890: -- Standard Start of API savepoint
891: SAVEPOINT modify_revision;
892: -- Check if API is called in debug mode. If yes, enable debug.
893: IF G_DEBUG='Y' THEN
894: AHL_DEBUG_PUB.enable_debug;
895:
896: END IF;
897: -- Debug info.
898: IF G_DEBUG='Y' THEN

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

896: END IF;
897: -- Debug info.
898: IF G_DEBUG='Y' THEN
899: IF G_DEBUG='Y' THEN
900: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pub.Modify Revision','+REV+');
901:
902: END IF;
903: END IF;
904: -- Standard call to check for call compatibility.

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

1288:
1289: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',
1290: 'B', 'C' ) then
1291: IF G_DEBUG='Y' THEN
1292: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_PRE');
1293:
1294: END IF;
1295:
1296: AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_PRE

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

1303: );
1304:
1305:
1306: IF G_DEBUG='Y' THEN
1307: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_PRE');
1308:
1309: END IF;
1310:
1311: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

1317:
1318: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',
1319: 'B', 'V' ) then
1320: IF G_DEBUG='Y' THEN
1321: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_PRE');
1322:
1323: END IF;
1324:
1325:

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

1335: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338: IF G_DEBUG='Y' THEN
1339: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_PRE');
1340:
1341: END IF;
1342:
1343: END IF;

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

1389:
1390: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',
1391: 'A', 'V' ) then
1392: IF G_DEBUG='Y' THEN
1393: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_POST');
1394:
1395: END IF;
1396:
1397: AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_POST(

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

1401: X_MSG_DATA => l_msg_data );
1402:
1403:
1404: IF G_DEBUG='Y' THEN
1405: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_VUHK.MODIFY_REVISION_POST');
1406:
1407: END IF;
1408:
1409: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

1417:
1418: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',
1419: 'A', 'C' ) then
1420: IF G_DEBUG='Y' THEN
1421: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_POST');
1422:
1423: END IF;
1424:
1425: AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_POST(

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

1429: X_MSG_COUNT => l_msg_count ,
1430: X_MSG_DATA => l_msg_data );
1431:
1432: IF G_DEBUG='Y' THEN
1433: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_REVISION_CUHK.MODIFY_REVISION_POST');
1434:
1435: END IF;
1436:
1437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

1454: COMMIT;
1455: END IF;
1456: -- Debug info
1457: IF G_DEBUG='Y' THEN
1458: AHL_DEBUG_PUB.debug( 'End of public api Modify Revision','+REV+');
1459:
1460: END IF;
1461: -- Check if API is called in debug mode. If yes, disable debug.
1462: IF G_DEBUG='Y' THEN

Line 1463: AHL_DEBUG_PUB.disable_debug;

1459:
1460: END IF;
1461: -- Check if API is called in debug mode. If yes, disable debug.
1462: IF G_DEBUG='Y' THEN
1463: AHL_DEBUG_PUB.disable_debug;
1464:
1465: END IF;
1466:
1467: x_msg_data := 'tHIS IS A cHECK'||TO_CHAR(p_x_revision_tbl(1).approved_by_party_id);

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

1473: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1474: p_count => x_msg_count,
1475: p_data => x_msg_data);
1476: IF G_DEBUG='Y' THEN
1477: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1478: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1479:
1480: -- Check if API is called in debug mode. If yes, disable debug.
1481: AHL_DEBUG_PUB.disable_debug;

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

1474: p_count => x_msg_count,
1475: p_data => x_msg_data);
1476: IF G_DEBUG='Y' THEN
1477: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1478: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1479:
1480: -- Check if API is called in debug mode. If yes, disable debug.
1481: AHL_DEBUG_PUB.disable_debug;
1482:

Line 1481: AHL_DEBUG_PUB.disable_debug;

1477: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1478: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1479:
1480: -- Check if API is called in debug mode. If yes, disable debug.
1481: AHL_DEBUG_PUB.disable_debug;
1482:
1483: END IF;
1484:
1485: WHEN FND_API.G_EXC_ERROR THEN

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

1489: p_count => x_msg_count,
1490: p_data => X_msg_data);
1491: -- Debug info.
1492: IF G_DEBUG='Y' THEN
1493: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1494: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1495:
1496:
1497: -- Check if API is called in debug mode. If yes, disable debug.

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

1490: p_data => X_msg_data);
1491: -- Debug info.
1492: IF G_DEBUG='Y' THEN
1493: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1494: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1495:
1496:
1497: -- Check if API is called in debug mode. If yes, disable debug.
1498: AHL_DEBUG_PUB.disable_debug;

Line 1498: AHL_DEBUG_PUB.disable_debug;

1494: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1495:
1496:
1497: -- Check if API is called in debug mode. If yes, disable debug.
1498: AHL_DEBUG_PUB.disable_debug;
1499:
1500: END IF;
1501:
1502: WHEN OTHERS THEN

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

1513: p_data => X_msg_data);
1514:
1515: -- Debug info.
1516: IF G_DEBUG='Y' THEN
1517: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1518: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1519:
1520:
1521: -- Check if API is called in debug mode. If yes, disable debug.

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

1514:
1515: -- Debug info.
1516: IF G_DEBUG='Y' THEN
1517: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1518: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1519:
1520:
1521: -- Check if API is called in debug mode. If yes, disable debug.
1522: AHL_DEBUG_PUB.disable_debug;

Line 1522: AHL_DEBUG_PUB.disable_debug;

1518: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pub.Modify Revision','+REV+');
1519:
1520:
1521: -- Check if API is called in debug mode. If yes, disable debug.
1522: AHL_DEBUG_PUB.disable_debug;
1523:
1524: END IF;
1525:
1526: END MODIFY_REVISION;