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_DI_DOC_REVISION_PUB

Line 1: PACKAGE BODY AHL_DI_DOC_REVISION_PUB AS

1: PACKAGE BODY AHL_DI_DOC_REVISION_PUB AS
2: /* $Header: AHLPDORB.pls 120.3.12020000.2 2012/12/07 00:02:03 sareepar ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_DOC_REVISION_PUB';
5: /*-----------------------------------------------------------*/

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

1: PACKAGE BODY AHL_DI_DOC_REVISION_PUB AS
2: /* $Header: AHLPDORB.pls 120.3.12020000.2 2012/12/07 00:02:03 sareepar ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_DOC_REVISION_PUB';
5: /*-----------------------------------------------------------*/
6: /* procedure name: Check_lookup_name_Or_Id(private procedure)*/
7: /* description : used to retrieve lookup code */
8: /* */

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 534: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',

530: /* Date : Dec 27 2001 */
531: /*----------------------------------------------------------------- */
532:
533:
534: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',
535: 'B', 'C' ) then
536:
537:
538: IF G_DEBUG='Y' THEN

Line 566: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',

562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;
564: END IF;
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:

Line 647: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',

643: /* Date : Dec 27 2001 */
644: /*------------------------------------------------------------------------------*/
645:
646:
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');

Line 674: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','CREATE_REVISION',

670: END IF;
671:
672: END IF;
673:
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');

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 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 766: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_REVISION_PUB',

762: ROLLBACK TO create_revision;
763: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
765: THEN
766: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_REVISION_PUB',
767: p_procedure_name => 'CREATE_REVISION',
768: p_error_text => SUBSTR(SQLERRM,1,240));
769: END IF;
770: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 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 1289: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',

1285: /* Date : Dec 27 2001 */
1286: /*---------------------------------------------------------------*/
1287:
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:

Line 1318: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',

1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315: END IF;
1316: END IF;
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:

Line 1390: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',

1386: /*------------------------------------------------------------------------------*/
1387:
1388:
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:

Line 1418: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_REVISION_PUB','MODIFY_REVISION',

1414:
1415:
1416: END IF;
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:

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 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 1507: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_REVISION_PUB',

1503: ROLLBACK TO modify_revision;
1504: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1506: THEN
1507: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_REVISION_PUB',
1508: p_procedure_name => 'MODIFY_REVISION',
1509: p_error_text => SUBSTR(SQLERRM,1,240));
1510: END IF;
1511: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 1527: END AHL_DI_DOC_REVISION_PUB;

1523:
1524: END IF;
1525:
1526: END MODIFY_REVISION;
1527: END AHL_DI_DOC_REVISION_PUB;