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_QA_RESULTS_PVT dependencies on AHL_DEBUG_PUB

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

1: PACKAGE BODY AHL_QA_RESULTS_PVT AS
2: /* $Header: AHLVQARB.pls 120.5 2008/01/28 20:36:02 sikumar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_QA_RESULTS_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: -- Added by Arvind for 11.5.10
8: G_MR_TXN_NO NUMBER := TO_NUMBER( FND_PROFILE.value( 'AHL_MR_QA_TXN_NO' ) );
9: G_JOB_TXN_NO NUMBER := 2001;

Line 515: AHL_DEBUG_PUB.enable_debug;

511: l_transaction_no NUMBER;
512: BEGIN
513: -- Enable Debug (optional)
514: IF ( G_DEBUG = 'Y' ) THEN
515: AHL_DEBUG_PUB.enable_debug;
516: END IF;
517:
518: -- Initialize API return status to success
519: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After validating Inputs ' );

546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: END IF;
548:
549: IF G_DEBUG = 'Y' THEN
550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After validating Inputs ' );
551: END IF;
552:
553: IF ( p_x_collection_id IS NULL ) THEN
554: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO p_x_collection_id FROM DUAL;

Line 557: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Getting Collection ID ' );

553: IF ( p_x_collection_id IS NULL ) THEN
554: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO p_x_collection_id FROM DUAL;
555:
556: IF G_DEBUG = 'Y' THEN
557: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Getting Collection ID ' );
558: END IF;
559:
560: END IF;
561:

Line 587: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Forming Hidden Result String : ' || l_hidden_result_string );

583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584: END IF;
585:
586: IF G_DEBUG = 'Y' THEN
587: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Forming Hidden Result String : ' || l_hidden_result_string );
588: END IF;
589:
590: FOR i IN 1..p_x_occurrence_tbl.COUNT LOOP
591:

Line 609: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Forming Result String : ' || l_result_string || ' for row : ' || i );

605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607:
608: IF G_DEBUG = 'Y' THEN
609: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Forming Result String : ' || l_result_string || ' for row : ' || i );
610: END IF;
611:
612: l_start_index := l_start_index + p_x_occurrence_tbl(i).element_count;
613:

Line 637: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Invoking nontxnt_post_result ' );

633: x_messages => l_msg_data
634: );
635:
636: IF G_DEBUG = 'Y' THEN
637: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Invoking nontxnt_post_result ' );
638: END IF;
639: IF(l_msg_data IS NOT NULL)THEN
640: x_msg_data := l_msg_data || x_msg_data;
641: x_msg_count := 1;

Line 671: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Invoking post_result ' || l_msg_data);

667: x_messages => l_msg_data
668: );
669:
670: IF G_DEBUG = 'Y' THEN
671: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Invoking post_result ' || l_msg_data);
672: END IF;
673: IF(l_msg_data IS NOT NULL)THEN
674: x_msg_data := l_msg_data || x_msg_data;
675: x_msg_count := 1;

Line 682: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Post Result Failed ' );

678:
679: IF ( l_qa_post_result = -1 ) THEN
680:
681: IF G_DEBUG = 'Y' THEN
682: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Post Result Failed ' );
683: END IF;
684:
685: IF ( l_msg_data IS NULL ) THEN
686: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_POST_UNEXP_ERROR' );

Line 736: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Firing AHL Actions ' );

732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734:
735: IF G_DEBUG = 'Y' THEN
736: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Firing AHL Actions ' );
737: END IF;
738: END IF;
739:
740: -- Fix for bug# 5501482.

Line 768: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Firing QA Actions ' || l_msg_data );

764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
765: END IF;
766:
767: IF G_DEBUG = 'Y' THEN
768: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Firing QA Actions ' || l_msg_data );
769: END IF;
770: END IF;
771: -- Fix for bug#5501482
772:

Line 774: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : returned message: ' || x_msg_data );

770: END IF;
771: -- Fix for bug#5501482
772:
773: IF G_DEBUG = 'Y' THEN
774: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : returned message: ' || x_msg_data );
775: END IF;
776:
777: -- Perform the Commit (if requested)
778: IF ( FND_API.to_boolean( p_commit ) ) THEN

Line 784: AHL_DEBUG_PUB.disable_debug;

780: END IF;
781:
782:
783: IF ( G_DEBUG = 'Y' ) THEN
784: AHL_DEBUG_PUB.disable_debug;
785: END IF;
786:
787: EXCEPTION
788:

Line 800: AHL_DEBUG_PUB.disable_debug;

796: p_data => x_msg_data
797: );
798:
799: IF ( G_DEBUG = 'Y' ) THEN
800: AHL_DEBUG_PUB.disable_debug;
801: END IF;
802:
803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
804: ROLLBACK TO submit_qa_results_PVT;

Line 814: AHL_DEBUG_PUB.disable_debug;

810: p_data => x_msg_data
811: );
812:
813: IF ( G_DEBUG = 'Y' ) THEN
814: AHL_DEBUG_PUB.disable_debug;
815: END IF;
816:
817: WHEN OTHERS THEN
818: ROLLBACK TO submit_qa_results_PVT;

Line 837: AHL_DEBUG_PUB.disable_debug;

833: p_data => x_msg_data
834: );
835:
836: IF ( G_DEBUG = 'Y' ) THEN
837: AHL_DEBUG_PUB.disable_debug;
838: END IF;
839:
840: END submit_qa_results;
841:

Line 869: AHL_DEBUG_PUB.enable_debug;

865: BEGIN
866:
867: -- Enable Debug (optional)
868: IF ( G_DEBUG = 'Y' ) THEN
869: AHL_DEBUG_PUB.enable_debug;
870: END IF;
871:
872: -- Initialize API return status to success
873: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 916: AHL_DEBUG_PUB.disable_debug;

912: RAISE FND_API.G_EXC_ERROR;
913: END IF;
914:
915: IF ( G_DEBUG = 'Y' ) THEN
916: AHL_DEBUG_PUB.disable_debug;
917: END IF;
918:
919: EXCEPTION
920:

Line 931: AHL_DEBUG_PUB.disable_debug;

927: p_data => x_msg_data
928: );
929:
930: IF ( G_DEBUG = 'Y' ) THEN
931: AHL_DEBUG_PUB.disable_debug;
932: END IF;
933:
934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 944: AHL_DEBUG_PUB.disable_debug;

940: p_data => x_msg_data
941: );
942:
943: IF ( G_DEBUG = 'Y' ) THEN
944: AHL_DEBUG_PUB.disable_debug;
945: END IF;
946:
947: WHEN OTHERS THEN
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 966: AHL_DEBUG_PUB.disable_debug;

962: p_data => x_msg_data
963: );
964:
965: IF ( G_DEBUG = 'Y' ) THEN
966: AHL_DEBUG_PUB.disable_debug;
967: END IF;
968: END get_char_lov_sql;
969:
970: PROCEDURE get_qa_plan

Line 992: AHL_DEBUG_PUB.enable_debug;

988: BEGIN
989:
990: -- Enable Debug (optional)
991: IF ( G_DEBUG = 'Y' ) THEN
992: AHL_DEBUG_PUB.enable_debug;
993: END IF;
994:
995: -- Initialize API return status to success
996: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1032: AHL_DEBUG_PUB.disable_debug;

1028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1029: END;
1030:
1031: IF ( G_DEBUG = 'Y' ) THEN
1032: AHL_DEBUG_PUB.disable_debug;
1033: END IF;
1034:
1035: EXCEPTION
1036:

Line 1047: AHL_DEBUG_PUB.disable_debug;

1043: p_data => x_msg_data
1044: );
1045:
1046: IF ( G_DEBUG = 'Y' ) THEN
1047: AHL_DEBUG_PUB.disable_debug;
1048: END IF;
1049:
1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1060: AHL_DEBUG_PUB.disable_debug;

1056: p_data => x_msg_data
1057: );
1058:
1059: IF ( G_DEBUG = 'Y' ) THEN
1060: AHL_DEBUG_PUB.disable_debug;
1061: END IF;
1062:
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1082: AHL_DEBUG_PUB.disable_debug;

1078: p_data => x_msg_data
1079: );
1080:
1081: IF ( G_DEBUG = 'Y' ) THEN
1082: AHL_DEBUG_PUB.disable_debug;
1083: END IF;
1084: END get_qa_plan;
1085:
1086: END AHL_QA_RESULTS_PVT;