DBA Data[Home] [Help]

APPS.AHL_DI_ASSO_DOC_GEN_PUB dependencies on AHL_DEBUG_PUB

Line 13: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

9: /* */
10: /*-----------------------------------------------------------*/
11:
12: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
13: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
14:
15:
16: PROCEDURE RECORD_IDENTIFIER
17: (

Line 497: AHL_DEBUG_PUB.enable_debug;

493: BEGIN
494: x_return_status:=FND_API.G_RET_STS_SUCCESS;
495:
496: IF G_DEBUG='Y' THEN
497: AHL_DEBUG_PUB.enable_debug;
498: END IF;
499:
500:
501: RECORD_IDENTIFIER

Line 517: AHL_DEBUG_PUB.debug( 'Stage 002');

513: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_NULL');
514: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
515: FND_MSG_PUB.ADD;
516: IF G_DEBUG='Y' THEN
517: AHL_DEBUG_PUB.debug( 'Stage 002');
518: END IF;
519: l_check_flag:='N';
520: ELSE
521:

Line 532: AHL_DEBUG_PUB.debug( 'Document number Does not exist');

528: FND_MESSAGE.SET_TOKEN('FIELD',p_association_rec.document_no);
529: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
530: FND_MSG_PUB.ADD;
531: IF G_DEBUG='Y' THEN
532: AHL_DEBUG_PUB.debug( 'Document number Does not exist');
533: END IF;
534: l_check_flag:='N';
535: ELSE
536: p_x_association_rec.document_id := l_document_id;

Line 565: AHL_DEBUG_PUB.debug( 'Revision for Document is null');

561: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_NULL');
562: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
563: FND_MSG_PUB.ADD;
564: IF G_DEBUG='Y' THEN
565: AHL_DEBUG_PUB.debug( 'Revision for Document is null');
566: END IF;
567:
568: l_check_flag:='N';
569: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');

Line 572: AHL_DEBUG_PUB.debug( 'Select document from lov');

568: l_check_flag:='N';
569: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');
570: FND_MSG_PUB.ADD;
571: IF G_DEBUG='Y' THEN
572: AHL_DEBUG_PUB.debug( 'Select document from lov');
573: END IF;
574: END IF;
575: ELSE -- ROUTE AND OPER
576: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_NULL');

Line 580: AHL_DEBUG_PUB.debug( 'Revision for Document is null');

576: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_NULL');
577: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
578: FND_MSG_PUB.ADD;
579: IF G_DEBUG='Y' THEN
580: AHL_DEBUG_PUB.debug( 'Revision for Document is null');
581: END IF;
582:
583: l_check_flag:='N';
584: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');

Line 587: AHL_DEBUG_PUB.debug( 'Select document from lov');

583: l_check_flag:='N';
584: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');
585: FND_MSG_PUB.ADD;
586: IF G_DEBUG='Y' THEN
587: AHL_DEBUG_PUB.debug( 'Select document from lov');
588: END IF;
589: END IF;-- NOT R O
590: ELSE -- REV NOT NULL
591: OPEN GetDocRevNoId (l_document_id,p_association_rec.revision_no );

Line 642: AHL_DEBUG_PUB.enable_debug;

638: SAVEPOINT process_association;
639: -- Check if API is called in debug mode. If yes, enable debug.
640:
641: IF G_DEBUG='Y' THEN
642: AHL_DEBUG_PUB.enable_debug;
643: END IF;
644:
645: -- Debug info.
646:

Line 648: AHL_DEBUG_PUB.debug( 'entering..... ahl_di_asso_doc_aso_pub.Process Association','+DOBJASS+');

644:
645: -- Debug info.
646:
647: IF G_DEBUG='Y' THEN
648: AHL_DEBUG_PUB.debug( 'entering..... ahl_di_asso_doc_aso_pub.Process Association','+DOBJASS+');
649: END IF;
650:
651:
652:

Line 709: AHL_DEBUG_PUB.debug( 'before the record .... '||l_record,'+adhariamr+');

705: p_association_rec =>p_x_association_tbl(i),
706: x_record =>l_record
707: );
708: IF G_DEBUG='Y' THEN
709: AHL_DEBUG_PUB.debug( 'before the record .... '||l_record,'+adhariamr+');
710: END IF;
711:
712: DEFAULT_MISSING_ATTRIBS
713: (

Line 809: AHL_DEBUG_PUB.debug( 'before modify');

805: -- RAISE FND_API.G_EXC_ERROR;
806: END IF;
807:
808: IF G_DEBUG='Y' THEN
809: AHL_DEBUG_PUB.debug( 'before modify');
810: END IF;
811:
812:
813: END IF;

Line 864: AHL_DEBUG_PUB.debug( 'End of public api PROCESS Association','+DOBJASS+');

860: COMMIT;
861: END IF;
862: -- Debug info
863: IF G_DEBUG='Y' THEN
864: AHL_DEBUG_PUB.debug( 'End of public api PROCESS Association','+DOBJASS+');
865:
866: END IF;
867: -- Check if API is called in debug mode. If yes, disable debug.
868: IF G_DEBUG='Y' THEN

Line 869: AHL_DEBUG_PUB.disable_debug;

865:
866: END IF;
867: -- Check if API is called in debug mode. If yes, disable debug.
868: IF G_DEBUG='Y' THEN
869: AHL_DEBUG_PUB.disable_debug;
870:
871: END IF;
872:
873: EXCEPTION

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

879: p_data => x_msg_data);
880: --Debug Info
881: IF G_DEBUG='Y' THEN
882:
883: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
884: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');
885: -- Check if API is called in debug mode. If yes, disable debug.
886: AHL_DEBUG_PUB.disable_debug;
887:

Line 884: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');

880: --Debug Info
881: IF G_DEBUG='Y' THEN
882:
883: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
884: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');
885: -- Check if API is called in debug mode. If yes, disable debug.
886: AHL_DEBUG_PUB.disable_debug;
887:
888: END IF;

Line 886: AHL_DEBUG_PUB.disable_debug;

882:
883: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
884: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');
885: -- Check if API is called in debug mode. If yes, disable debug.
886: AHL_DEBUG_PUB.disable_debug;
887:
888: END IF;
889:
890: WHEN FND_API.G_EXC_ERROR THEN

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

896: x_msg_count := l_msg_count;
897:
898: -- Debug info.
899: IF G_DEBUG='Y' THEN
900: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
901: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');
902:
903: -- Check if API is called in debug mode. If yes, disable debug.
904: AHL_DEBUG_PUB.disable_debug;

Line 901: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');

897:
898: -- Debug info.
899: IF G_DEBUG='Y' THEN
900: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
901: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');
902:
903: -- Check if API is called in debug mode. If yes, disable debug.
904: AHL_DEBUG_PUB.disable_debug;
905:

Line 904: AHL_DEBUG_PUB.disable_debug;

900: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
901: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');
902:
903: -- Check if API is called in debug mode. If yes, disable debug.
904: AHL_DEBUG_PUB.disable_debug;
905:
906: END IF;
907:
908: WHEN OTHERS THEN

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

919: p_data => X_msg_data);
920: x_msg_count := l_msg_count;
921: -- Debug info.
922: IF G_DEBUG='Y' THEN
923: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
924: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');
925: -- Check if API is called in debug mode. If yes, disable debug.
926: AHL_DEBUG_PUB.disable_debug;
927:

Line 924: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');

920: x_msg_count := l_msg_count;
921: -- Debug info.
922: IF G_DEBUG='Y' THEN
923: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
924: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');
925: -- Check if API is called in debug mode. If yes, disable debug.
926: AHL_DEBUG_PUB.disable_debug;
927:
928: END IF;

Line 926: AHL_DEBUG_PUB.disable_debug;

922: IF G_DEBUG='Y' THEN
923: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
924: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pub.PROCESS Association','+DOCJASS+');
925: -- Check if API is called in debug mode. If yes, disable debug.
926: AHL_DEBUG_PUB.disable_debug;
927:
928: END IF;
929:
930: END PROCESS_ASSOCIATION;