DBA Data[Home] [Help]

APPS.AHL_DI_PRO_TYPE_ASO_PUB dependencies on AHL_DI_PRO_TYPE_ASO_PUB

Line 1: PACKAGE BODY AHL_DI_PRO_TYPE_ASO_PUB AS

1: PACKAGE BODY AHL_DI_PRO_TYPE_ASO_PUB AS
2: /* $Header: AHLPPTAB.pls 120.0 2005/05/26 00:07:57 appldev noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_PRO_TYPE_ASO_PUB';
5: --

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

1: PACKAGE BODY AHL_DI_PRO_TYPE_ASO_PUB AS
2: /* $Header: AHLPPTAB.pls 120.0 2005/05/26 00:07:57 appldev noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_PRO_TYPE_ASO_PUB';
5: --
6: /*---------------------------------------------------*/
7: /* procedure name: create_doc_type_assoc */
8: /* description : Creates new association record */

Line 74: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pub.Create Doc Type','+DOCTY+');

70: END IF;
71: -- Debug info.
72: IF G_DEBUG='Y' THEN
73: IF G_DEBUG='Y' THEN
74: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pub.Create Doc Type','+DOCTY+');
75:
76: END IF;
77: END IF;
78: -- Standard call to check for call compatibility.

Line 197: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','CREATE_DOC_TYPE_ASSOC',

193: /* Date : Dec 20 2001 */
194: /*--------------------------------------------------------------------------*/
195:
196:
197: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','CREATE_DOC_TYPE_ASSOC',
198: 'B', 'C' ) then
199: IF G_DEBUG='Y' THEN
200: AHL_DEBUG_PUB.debug( 'Start AHL_DI_PRO_TYPE_ASO_CUHK.Create_Doc_Type_Assoc_PRE');
201:

Line 224: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','CREATE_DOC_TYPE_ASSOC',

220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222: END IF;
223:
224: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','CREATE_DOC_TYPE_ASSOC',
225: 'B', 'V' ) then
226: IF G_DEBUG='Y' THEN
227: AHL_DEBUG_PUB.debug( 'Start AHL_DI_PRO_TYPE_ASO_VUHK.Create_Doc_Type_Assoc_PRE');
228:

Line 301: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','CREATE_DOC_TYPE_ASSOC',

297: /*------------------------------------------------------------------------------*/
298:
299:
300:
301: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','CREATE_DOC_TYPE_ASSOC',
302: 'A', 'V' ) then
303: IF G_DEBUG='Y' THEN
304: AHL_DEBUG_PUB.debug( 'Start AHL_DI_PRO_TYPE_ASO_VUHK.Create_Doc_Type_Assoc_POST');
305:

Line 328: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','CREATE_DOC_TYPE_ASSOC',

324:
325:
326: END IF;
327:
328: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','CREATE_DOC_TYPE_ASSOC',
329: 'A', 'C' ) then
330: IF G_DEBUG='Y' THEN
331: AHL_DEBUG_PUB.debug( 'Start AHL_DI_PRO_TYPE_ASO_CUHK.Create_Doc_Type_Assoc_POST');
332:

Line 384: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Create Doc Type','+DOCTY+');

380: p_count => x_msg_count,
381: p_data => x_msg_data);
382: IF G_DEBUG='Y' THEN
383: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
384: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Create Doc Type','+DOCTY+');
385:
386:
387: -- Check if API is called in debug mode. If yes, disable debug.
388: AHL_DEBUG_PUB.disable_debug;

Line 401: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Create Doc Type','+DOCTY+');

397: p_data => X_msg_data);
398: -- Debug info.
399: IF G_DEBUG='Y' THEN
400: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
401: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Create Doc Type','+DOCTY+');
402:
403: -- Check if API is called in debug mode. If yes, disable debug.
404: AHL_DEBUG_PUB.disable_debug;
405:

Line 413: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',

409: ROLLBACK TO create_doc_type_assoc;
410: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
412: THEN
413: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',
414: p_procedure_name => 'CREATE_DOC_TYPE_ASSOC',
415: p_error_text => SUBSTR(SQLERRM,1,240));
416: END IF;
417: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 424: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Create Doc Type','+DOCTY+');

420:
421: -- Debug info.
422: IF G_DEBUG='Y' THEN
423: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
424: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Create Doc Type','+DOCTY+');
425:
426:
427: -- Check if API is called in debug mode. If yes, disable debug.
428: AHL_DEBUG_PUB.disable_debug;

Line 500: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pub.Modify Doc Type','+DOCTY+');

496: END IF;
497: -- Debug info.
498: IF G_DEBUG='Y' THEN
499: IF G_DEBUG='Y' THEN
500: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pub.Modify Doc Type','+DOCTY+');
501:
502: END IF;
503: END IF;
504: -- Standard call to check for call compatibility.

Line 617: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','MODIFY_DOC_TYPE_ASSOC',

613: /* Date : Dec 20 2001 */
614: /*------------------------------------------------------------------------*/
615:
616:
617: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','MODIFY_DOC_TYPE_ASSOC',
618: 'B', 'C' ) then
619: IF G_DEBUG='Y' THEN
620: AHL_DEBUG_PUB.debug( 'Start AHL_DI_PRO_TYPE_ASO_CUHK.MODIFY_DOC_TYPE_ASSOC_PRE');
621:

Line 646: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','MODIFY_DOC_TYPE_ASSOC',

642:
643:
644: END IF;
645:
646: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','MODIFY_DOC_TYPE_ASSOC',
647: 'B', 'V' ) then
648: IF G_DEBUG='Y' THEN
649: AHL_DEBUG_PUB.debug( 'Start AHL_DI_PRO_TYPE_ASO_VUHK.MODIFY_DOC_TYPE_ASSOC_PRE');
650:

Line 714: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','MODIFY_DOC_TYPE_ASSOC',

710: /* Date : Dec 20 2001 */
711: /*------------------------------------------------------------------------*/
712:
713:
714: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','MODIFY_DOC_TYPE_ASSOC',
715: 'A', 'V' ) then
716: IF G_DEBUG='Y' THEN
717: AHL_DEBUG_PUB.debug( 'Start AHL_DI_PRO_TYPE_ASO_VUHK.MODIFY_DOC_TYPE_ASSOC_POST');
718:

Line 741: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','MODIFY_DOC_TYPE_ASSOC',

737: END IF;
738:
739: END IF;
740:
741: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_PRO_TYPE_ASO_PUB','MODIFY_DOC_TYPE_ASSOC',
742: 'A', 'C' ) then
743: IF G_DEBUG='Y' THEN
744: AHL_DEBUG_PUB.debug( 'Start AHL_DI_PRO_TYPE_ASO_CUHK.MODIFY_DOC_TYPE_ASSOC_POST');
745:

Line 800: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Modify Doc Type','+DOCTY+');

796: p_count => x_msg_count,
797: p_data => x_msg_data);
798: IF G_DEBUG='Y' THEN
799: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
800: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Modify Doc Type','+DOCTY+');
801:
802:
803: -- Check if API is called in debug mode. If yes, disable debug.
804: AHL_DEBUG_PUB.disable_debug;

Line 817: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Modify Doc Type','+DOCTY+');

813: p_data => X_msg_data);
814: -- Debug info.
815: IF G_DEBUG='Y' THEN
816: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
817: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Modify Doc Type','+DOCTY+');
818:
819:
820: -- Check if API is called in debug mode. If yes, disable debug.
821: AHL_DEBUG_PUB.disable_debug;

Line 830: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',

826: ROLLBACK TO modify_doc_type_assoc;
827: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PUB',
831: p_procedure_name => 'MODIFY_DOC_TYPE_ASSOC',
832: p_error_text => SUBSTR(SQLERRM,1,240));
833: END IF;
834: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 841: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Modify Doc Type','+DOCTY+');

837:
838: -- Debug info.
839: IF G_DEBUG='Y' THEN
840: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
841: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pub.Modify Doc Type','+DOCTY+');
842:
843:
844: -- Check if API is called in debug mode. If yes, disable debug.
845: AHL_DEBUG_PUB.disable_debug;

Line 851: END AHL_DI_PRO_TYPE_ASO_PUB;

847: END IF;
848:
849: END MODIFY_DOC_TYPE_ASSOC;
850:
851: END AHL_DI_PRO_TYPE_ASO_PUB;
852: