DBA Data[Home] [Help]

APPS.AHL_DI_DOC_REVISION_PVT dependencies on AHL_DI_DOC_REVISION_PVT

Line 1: PACKAGE BODY AHL_DI_DOC_REVISION_PVT AS

1: PACKAGE BODY AHL_DI_DOC_REVISION_PVT AS
2: /* $Header: AHLVDORB.pls 120.0 2005/05/26 01:44:41 appldev noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_DOC_REVISION_PVT';
5: --

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

1: PACKAGE BODY AHL_DI_DOC_REVISION_PVT AS
2: /* $Header: AHLVDORB.pls 120.0 2005/05/26 01:44:41 appldev noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_DOC_REVISION_PVT';
5: --
6: /*---------------------------------------------------------*/
7: /* procedure name: validate_revision(private procedure) */
8: /* description : Validation checks for before inserting */

Line 389: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pvt.Create Revision','+REV+');

385: END IF;
386: -- Debug info.
387: IF G_DEBUG='Y' THEN
388: IF G_DEBUG='Y' THEN
389: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pvt.Create Revision','+REV+');
390:
391: END IF;
392: END IF;
393: -- Standard call to check for call compatibility.

Line 560: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Create Revision','+REV+');

556: p_data => x_msg_data);
557: --Debug Info
558: IF G_DEBUG='Y' THEN
559: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
560: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Create Revision','+REV+');
561:
562:
563: -- Check if API is called in debug mode. If yes, disable debug.
564: AHL_DEBUG_PUB.disable_debug;

Line 577: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Create Revision','+REV+');

573: p_data => X_msg_data);
574: -- Debug info.
575: IF G_DEBUG='Y' THEN
576: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
577: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Create Revision','+REV+');
578:
579:
580: -- Check if API is called in debug mode. If yes, disable debug.
581: AHL_DEBUG_PUB.disable_debug;

Line 590: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_REVISION_PVT',

586: ROLLBACK TO create_revision;
587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_REVISION_PVT',
591: p_procedure_name => 'CREATE_REVISION',
592: p_error_text => SUBSTR(SQLERRM,1,240));
593: END IF;
594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 600: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Create Revision','+REV+');

596: p_data => X_msg_data);
597: -- Debug info.
598: IF G_DEBUG='Y' THEN
599: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
600: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Create Revision','+REV+');
601:
602: -- Check if API is called in debug mode. If yes, disable debug.
603: AHL_DEBUG_PUB.disable_debug;
604:

Line 697: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pvt.Modify Revision','+REV+');

693: END IF;
694: -- Debug info.
695: IF G_DEBUG='Y' THEN
696: IF G_DEBUG='Y' THEN
697: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pvt.Modify Revision','+REV+');
698:
699: END IF;
700: END IF;
701: -- Standard call to check for call compatibility.

Line 886: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Modify Revision','+REV+');

882: p_data => x_msg_data);
883:
884: IF G_DEBUG='Y' THEN
885: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
886: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Modify Revision','+REV+');
887:
888:
889: -- Check if API is called in debug mode. If yes, disable debug.
890: AHL_DEBUG_PUB.disable_debug;

Line 903: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Modify Revision','+REV+');

899: p_data => X_msg_data);
900: -- Debug info.
901: IF G_DEBUG='Y' THEN
902: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
903: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Modify Revision','+REV+');
904:
905:
906: -- Check if API is called in debug mode. If yes, disable debug.
907: AHL_DEBUG_PUB.disable_debug;

Line 916: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_REVISION_PVT',

912: ROLLBACK TO modify_revision;
913: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
915: THEN
916: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_REVISION_PVT',
917: p_procedure_name => 'MODIFY_REVISION',
918: p_error_text => SUBSTR(SQLERRM,1,240));
919: END IF;
920: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 927: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Modify Revision','+REV+');

923:
924: -- Debug info.
925: IF G_DEBUG='Y' THEN
926: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
927: AHL_DEBUG_PUB.debug( 'ahl_di_doc_revision_pvt.Modify Revision','+REV+');
928:
929:
930: -- Check if API is called in debug mode. If yes, disable debug.
931: AHL_DEBUG_PUB.disable_debug;

Line 1059: END AHL_DI_DOC_REVISION_PVT;

1055:
1056: END DELETE_REVISION;
1057:
1058: --
1059: END AHL_DI_DOC_REVISION_PVT;