DBA Data[Home] [Help]

APPS.AHL_DI_ASSO_DOC_ASO_PUB dependencies on AHL_DI_ASSO_DOC_ASO_PUB

Line 1: PACKAGE BODY AHL_DI_ASSO_DOC_ASO_PUB AS

1: PACKAGE BODY AHL_DI_ASSO_DOC_ASO_PUB AS
2: /* $Header: AHLPDASB.pls 115.26 2003/10/20 19:36:13 sikumar noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_ASSO_DOC_ASO_PUB';
5: --

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

1: PACKAGE BODY AHL_DI_ASSO_DOC_ASO_PUB AS
2: /* $Header: AHLPDASB.pls 115.26 2003/10/20 19:36:13 sikumar noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_ASSO_DOC_ASO_PUB';
5: --
6: /*-----------------------------------------------------------*/
7: /* procedure name: Check_lookup_name_Or_Id(private procedure)*/
8: /* description : used to retrieve lookup code */

Line 147: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pub.Create Association','+DOBJASS+');

143: END IF;
144: -- Debug info.
145: IF G_DEBUG='Y' THEN
146: IF G_DEBUG='Y' THEN
147: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pub.Create Association','+DOBJASS+');
148:
149: END IF;
150: END IF;
151: -- Standard call to check for call compatibility.

Line 304: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','CREATE_ASSOCIATION',

300: /* description : Added by Senthil to call User Hooks */
301: /* Date : Dec 10 2001 */
302: /*------------------------------------------------------------------------*/
303:
304: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','CREATE_ASSOCIATION',
305: 'B', 'C' ) then
306: IF G_DEBUG='Y' THEN
307: AHL_DEBUG_PUB.debug( 'Start of api Customer Create Association_Pre');
308:

Line 328: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','CREATE_ASSOCIATION',

324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326: END IF;
327:
328: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','CREATE_ASSOCIATION',
329: 'B', 'V' ) then
330: IF G_DEBUG='Y' THEN
331: AHL_DEBUG_PUB.debug( 'Start of api Vertical Create Association_Pre');
332:

Line 392: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','CREATE_ASSOCIATION',

388: /* description : Added by Senthil to call User Hooks */
389: /* Date : Dec 10 2001 */
390: /*------------------------------------------------------------------------*/
391:
392: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','CREATE_ASSOCIATION',
393: 'A', 'C' ) then
394: IF G_DEBUG='Y' THEN
395: AHL_DEBUG_PUB.debug( 'Start of api Customer Create Association_Post');
396:

Line 414: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','CREATE_ASSOCIATION',

410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411: END IF;
412: END IF;
413:
414: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','CREATE_ASSOCIATION',
415: 'A', 'V' ) then
416: IF G_DEBUG='Y' THEN
417: AHL_DEBUG_PUB.debug( 'Start of api Vertical Create Association_Post');
418:

Line 470: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Create Association','+DOCJASS+');

466:
467:
468:
469:
470: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Create Association','+DOCJASS+');
471:
472:
473:
474: -- Check if API is called in debug mode. If yes, disable debug.

Line 491: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Create Association','+DOCJASS+');

487:
488: -- Debug info.
489: IF G_DEBUG='Y' THEN
490: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
491: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Create Association','+DOCJASS+');
492:
493: -- Check if API is called in debug mode. If yes, disable debug.
494: AHL_DEBUG_PUB.disable_debug;
495:

Line 504: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PUB',

500: ROLLBACK TO create_association;
501: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
503: THEN
504: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PUB',
505: p_procedure_name => 'CREATE_ASSOCIATION',
506: p_error_text => SUBSTR(SQLERRM,1,240));
507: END IF;
508: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 515: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Create Association','+DOCJASS+');

511: x_msg_count := l_msg_count;
512: -- Debug info.
513: IF G_DEBUG='Y' THEN
514: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
515: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Create Association','+DOCJASS+');
516: -- Check if API is called in debug mode. If yes, disable debug.
517: AHL_DEBUG_PUB.disable_debug;
518:
519: END IF;

Line 614: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pub.Rajanth Testing the code','+DOBJASS+');

610: END IF;
611: -- Debug info.
612: IF G_DEBUG='Y' THEN
613: IF G_DEBUG='Y' THEN
614: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pub.Rajanth Testing the code','+DOBJASS+');
615:
616: END IF;
617: END IF;
618: -- Standard call to check for call compatibility.

Line 845: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','MODIFY_ASSOCIATION',

841: /* Date : Dec 10 2001 */
842: /*------------------------------------------------------------------------*/
843:
844:
845: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','MODIFY_ASSOCIATION',
846: 'B', 'C' ) then
847: IF G_DEBUG='Y' THEN
848: AHL_DEBUG_PUB.debug( 'Start of api Customer MODIFY_ASSOCIATION_PRE');
849:

Line 864: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','MODIFY_ASSOCIATION',

860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
861: END IF;
862: END IF;
863:
864: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','MODIFY_ASSOCIATION',
865: 'B', 'V' ) then
866: IF G_DEBUG='Y' THEN
867: AHL_DEBUG_PUB.debug( 'Start of api Vertical MODIFY_ASSOCIATION_PRE');
868:

Line 917: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','MODIFY_ASSOCIATION',

913: /* description : Added by Senthil to call User Hooks */
914: /* Date : Dec 10 2001 */
915: /*------------------------------------------------------------------------*/
916:
917: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','MODIFY_ASSOCIATION',
918: 'A', 'C' ) then
919: IF G_DEBUG='Y' THEN
920: AHL_DEBUG_PUB.debug( 'Start of api Customer MODIFY_ASSOCIATION_POST');
921:

Line 936: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','MODIFY_ASSOCIATION',

932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934: END IF;
935:
936: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_ASSO_DOC_ASO_PUB','MODIFY_ASSOCIATION',
937: 'A', 'V' ) then
938: IF G_DEBUG='Y' THEN
939: AHL_DEBUG_PUB.debug( 'Start of api Vertical MODIFY_ASSOCIATION_POST');
940:

Line 984: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Modify Association','+DOCJASS+');

980: p_data => x_msg_data);
981: --Debug Info
982: IF G_DEBUG='Y' THEN
983: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
984: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Modify Association','+DOCJASS+');
985:
986: -- Check if API is called in debug mode. If yes, disable debug.
987: AHL_DEBUG_PUB.disable_debug;
988:

Line 1000: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Modify Association','+DOCJASS+');

996: p_data => X_msg_data);
997: -- Debug info.
998: IF G_DEBUG='Y' THEN
999: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1000: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Modify Association','+DOCJASS+');
1001:
1002: -- Check if API is called in debug mode. If yes, disable debug.
1003: AHL_DEBUG_PUB.disable_debug;
1004:

Line 1012: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PUB',

1008: ROLLBACK TO modify_association;
1009: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1011: THEN
1012: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PUB',
1013: p_procedure_name => 'MODIFY_ASSOCIATION',
1014: p_error_text => SUBSTR(SQLERRM,1,240));
1015: END IF;
1016: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1023: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Modify Association','+DOCJASS+');

1019:
1020: -- Debug info.
1021: IF G_DEBUG='Y' THEN
1022: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1023: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Modify Association','+DOCJASS+');
1024:
1025: -- Check if API is called in debug mode. If yes, disable debug.
1026: AHL_DEBUG_PUB.disable_debug;
1027:

Line 1096: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pub.Process Association','+DOBJASS+');

1092: END IF;
1093: -- Debug info.
1094: IF G_DEBUG='Y' THEN
1095: IF G_DEBUG='Y' THEN
1096: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pub.Process Association','+DOBJASS+');
1097:
1098: END IF;
1099: END IF;
1100: -- Standard call to check for call compatibility.

Line 1561: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Proces Association','+DOCJASS+');

1557: p_data => x_msg_data);
1558: --Debug Info
1559: IF G_DEBUG='Y' THEN
1560: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1561: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Proces Association','+DOCJASS+');
1562:
1563: -- Check if API is called in debug mode. If yes, disable debug.
1564: AHL_DEBUG_PUB.disable_debug;
1565:

Line 1579: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Process Association','+DOCJASS+');

1575: p_data => X_msg_data);
1576: -- Debug info.
1577: IF G_DEBUG='Y' THEN
1578: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1579: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Process Association','+DOCJASS+');
1580:
1581: -- Check if API is called in debug mode. If yes, disable debug.
1582: AHL_DEBUG_PUB.disable_debug;
1583:

Line 1591: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PUB',

1587: ROLLBACK TO PROCESS_association;
1588: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1590: THEN
1591: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PUB',
1592: p_procedure_name => 'PROCESS_ASSOCIATION',
1593: p_error_text => SUBSTR(SQLERRM,1,240));
1594: END IF;
1595: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1602: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Process Association','+DOCJASS+');

1598:
1599: -- Debug info.
1600: IF G_DEBUG='Y' THEN
1601: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1602: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.Process Association','+DOCJASS+');
1603:
1604:
1605: -- Check if API is called in debug mode. If yes, disable debug.
1606: AHL_DEBUG_PUB.disable_debug;

Line 1612: END AHL_DI_ASSO_DOC_ASO_PUB;

1608: END IF;
1609:
1610: END PROCESS_ASSOCIATION;
1611:
1612: END AHL_DI_ASSO_DOC_ASO_PUB;