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.6.12020000.2 2012/12/07 13:31:53 sareepar 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 525: AHL_DEBUG_PUB.enable_debug;

521: l_transaction_no NUMBER;
522: BEGIN
523: -- Enable Debug (optional)
524: IF ( G_DEBUG = 'Y' ) THEN
525: AHL_DEBUG_PUB.enable_debug;
526: END IF;
527:
528: -- Initialize API return status to success
529: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
559: IF G_DEBUG = 'Y' THEN
560: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After validating Inputs ' );
561: END IF;
562:
563: IF ( p_x_collection_id IS NULL ) THEN
564: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO p_x_collection_id FROM DUAL;

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

563: IF ( p_x_collection_id IS NULL ) THEN
564: SELECT QA_COLLECTION_ID_S.NEXTVAL INTO p_x_collection_id FROM DUAL;
565:
566: IF G_DEBUG = 'Y' THEN
567: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Getting Collection ID ' );
568: END IF;
569:
570: END IF;
571:

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

593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595:
596: IF G_DEBUG = 'Y' THEN
597: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Forming Hidden Result String : ' || l_hidden_result_string );
598: END IF;
599:
600: FOR i IN 1..p_x_occurrence_tbl.COUNT LOOP
601:

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

615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: END IF;
617:
618: IF G_DEBUG = 'Y' THEN
619: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Forming Result String : ' || l_result_string || ' for row : ' || i );
620: END IF;
621:
622: l_start_index := l_start_index + p_x_occurrence_tbl(i).element_count;
623:

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

643: x_messages => l_msg_data
644: );
645:
646: IF G_DEBUG = 'Y' THEN
647: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Invoking nontxnt_post_result ' );
648: END IF;
649: IF(l_msg_data IS NOT NULL)THEN
650: x_msg_data := l_msg_data || x_msg_data;
651: x_msg_count := 1;

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

677: x_messages => l_msg_data
678: );
679:
680: IF G_DEBUG = 'Y' THEN
681: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Invoking post_result ' || l_msg_data);
682: END IF;
683: IF(l_msg_data IS NOT NULL)THEN
684: x_msg_data := l_msg_data || x_msg_data;
685: x_msg_count := 1;

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

688:
689: IF ( l_qa_post_result = -1 ) THEN
690:
691: IF G_DEBUG = 'Y' THEN
692: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Post Result Failed ' );
693: END IF;
694:
695: IF ( l_msg_data IS NULL ) THEN
696: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_POST_UNEXP_ERROR' );

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

742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
743: END IF;
744:
745: IF G_DEBUG = 'Y' THEN
746: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Firing AHL Actions ' );
747: END IF;
748: END IF;
749:
750: -- Fix for bug# 5501482.

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

784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: END IF;
786:
787: IF G_DEBUG = 'Y' THEN
788: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : After Firing QA Actions ' || l_msg_data );
789: END IF;
790: END IF;
791: -- Fix for bug#5501482
792:

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

790: END IF;
791: -- Fix for bug#5501482
792:
793: IF G_DEBUG = 'Y' THEN
794: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : returned message: ' || x_msg_data );
795: END IF;
796:
797: -- Perform the Commit (if requested)
798: IF ( FND_API.to_boolean( p_commit ) ) THEN

Line 804: AHL_DEBUG_PUB.disable_debug;

800: END IF;
801:
802:
803: IF ( G_DEBUG = 'Y' ) THEN
804: AHL_DEBUG_PUB.disable_debug;
805: END IF;
806:
807: EXCEPTION
808:

Line 820: AHL_DEBUG_PUB.disable_debug;

816: p_data => x_msg_data
817: );
818:
819: IF ( G_DEBUG = 'Y' ) THEN
820: AHL_DEBUG_PUB.disable_debug;
821: END IF;
822:
823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
824: ROLLBACK TO submit_qa_results_PVT;

Line 834: AHL_DEBUG_PUB.disable_debug;

830: p_data => x_msg_data
831: );
832:
833: IF ( G_DEBUG = 'Y' ) THEN
834: AHL_DEBUG_PUB.disable_debug;
835: END IF;
836:
837: WHEN OTHERS THEN
838: ROLLBACK TO submit_qa_results_PVT;

Line 857: AHL_DEBUG_PUB.disable_debug;

853: p_data => x_msg_data
854: );
855:
856: IF ( G_DEBUG = 'Y' ) THEN
857: AHL_DEBUG_PUB.disable_debug;
858: END IF;
859:
860: END submit_qa_results;
861:

Line 889: AHL_DEBUG_PUB.enable_debug;

885: BEGIN
886:
887: -- Enable Debug (optional)
888: IF ( G_DEBUG = 'Y' ) THEN
889: AHL_DEBUG_PUB.enable_debug;
890: END IF;
891:
892: -- Initialize API return status to success
893: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 936: AHL_DEBUG_PUB.disable_debug;

932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935: IF ( G_DEBUG = 'Y' ) THEN
936: AHL_DEBUG_PUB.disable_debug;
937: END IF;
938:
939: EXCEPTION
940:

Line 951: AHL_DEBUG_PUB.disable_debug;

947: p_data => x_msg_data
948: );
949:
950: IF ( G_DEBUG = 'Y' ) THEN
951: AHL_DEBUG_PUB.disable_debug;
952: END IF;
953:
954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 964: AHL_DEBUG_PUB.disable_debug;

960: p_data => x_msg_data
961: );
962:
963: IF ( G_DEBUG = 'Y' ) THEN
964: AHL_DEBUG_PUB.disable_debug;
965: END IF;
966:
967: WHEN OTHERS THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 986: AHL_DEBUG_PUB.disable_debug;

982: p_data => x_msg_data
983: );
984:
985: IF ( G_DEBUG = 'Y' ) THEN
986: AHL_DEBUG_PUB.disable_debug;
987: END IF;
988: END get_char_lov_sql;
989:
990: PROCEDURE get_qa_plan

Line 1012: AHL_DEBUG_PUB.enable_debug;

1008: BEGIN
1009:
1010: -- Enable Debug (optional)
1011: IF ( G_DEBUG = 'Y' ) THEN
1012: AHL_DEBUG_PUB.enable_debug;
1013: END IF;
1014:
1015: -- Initialize API return status to success
1016: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1052: AHL_DEBUG_PUB.disable_debug;

1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END;
1050:
1051: IF ( G_DEBUG = 'Y' ) THEN
1052: AHL_DEBUG_PUB.disable_debug;
1053: END IF;
1054:
1055: EXCEPTION
1056:

Line 1067: AHL_DEBUG_PUB.disable_debug;

1063: p_data => x_msg_data
1064: );
1065:
1066: IF ( G_DEBUG = 'Y' ) THEN
1067: AHL_DEBUG_PUB.disable_debug;
1068: END IF;
1069:
1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1080: AHL_DEBUG_PUB.disable_debug;

1076: p_data => x_msg_data
1077: );
1078:
1079: IF ( G_DEBUG = 'Y' ) THEN
1080: AHL_DEBUG_PUB.disable_debug;
1081: END IF;
1082:
1083: WHEN OTHERS THEN
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1102: AHL_DEBUG_PUB.disable_debug;

1098: p_data => x_msg_data
1099: );
1100:
1101: IF ( G_DEBUG = 'Y' ) THEN
1102: AHL_DEBUG_PUB.disable_debug;
1103: END IF;
1104: END get_qa_plan;
1105:
1106: END AHL_QA_RESULTS_PVT;