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.QA_RESULT_GRP dependencies on FND_LOG

Line 515: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

511: ORDER BY creation_date DESC;
512:
513: BEGIN
514:
515: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
516: FND_LOG.string
517: (
518: FND_LOG.level_procedure,
519: g_pkg_name || '.' || l_api_name,

Line 516: FND_LOG.string

512:
513: BEGIN
514:
515: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
516: FND_LOG.string
517: (
518: FND_LOG.level_procedure,
519: g_pkg_name || '.' || l_api_name,
520: 'Entering Procedure for collection: ' || p_collection_id

Line 518: FND_LOG.level_procedure,

514:
515: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
516: FND_LOG.string
517: (
518: FND_LOG.level_procedure,
519: g_pkg_name || '.' || l_api_name,
520: 'Entering Procedure for collection: ' || p_collection_id
521: );
522: END IF;

Line 543: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

539:
540: -- Initialize API return status to success
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
544: FND_LOG.string
545: (
546: FND_LOG.level_statement,
547: g_pkg_name || '.' || l_api_name,

Line 544: FND_LOG.string

540: -- Initialize API return status to success
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
544: FND_LOG.string
545: (
546: FND_LOG.level_statement,
547: g_pkg_name || '.' || l_api_name,
548: 'Before getting occurrences for the collection'

Line 546: FND_LOG.level_statement,

542:
543: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
544: FND_LOG.string
545: (
546: FND_LOG.level_statement,
547: g_pkg_name || '.' || l_api_name,
548: 'Before getting occurrences for the collection'
549: );
550: END IF;

Line 567: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

563:
564: l_event_key := occ_cur.plan_id || '-' || p_collection_id || '-';
565: l_prev_plan_id := occ_cur.plan_id;
566:
567: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
568: FND_LOG.string
569: (
570: FND_LOG.level_statement,
571: g_pkg_name || '.' || l_api_name,

Line 568: FND_LOG.string

564: l_event_key := occ_cur.plan_id || '-' || p_collection_id || '-';
565: l_prev_plan_id := occ_cur.plan_id;
566:
567: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
568: FND_LOG.string
569: (
570: FND_LOG.level_statement,
571: g_pkg_name || '.' || l_api_name,
572: 'Checking if event exists for the collection. Event Key: ' || l_event_key

Line 570: FND_LOG.level_statement,

566:
567: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
568: FND_LOG.string
569: (
570: FND_LOG.level_statement,
571: g_pkg_name || '.' || l_api_name,
572: 'Checking if event exists for the collection. Event Key: ' || l_event_key
573: );
574: END IF;

Line 589: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

585: x_qa_erecord_tbl(ctr).event_name := erec_cur.event_name;
586: x_qa_erecord_tbl(ctr).event_key := l_event_key;
587: x_qa_erecord_tbl(ctr).erec_id := erec_cur.document_id;
588:
589: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
590: FND_LOG.string
591: (
592: FND_LOG.level_statement,
593: g_pkg_name || '.' || l_api_name,

Line 590: FND_LOG.string

586: x_qa_erecord_tbl(ctr).event_key := l_event_key;
587: x_qa_erecord_tbl(ctr).erec_id := erec_cur.document_id;
588:
589: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
590: FND_LOG.string
591: (
592: FND_LOG.level_statement,
593: g_pkg_name || '.' || l_api_name,
594: 'Found Event for the collection. Adding record: ' || ctr || ' E-Record: ' || x_qa_erecord_tbl(ctr).erec_id

Line 592: FND_LOG.level_statement,

588:
589: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
590: FND_LOG.string
591: (
592: FND_LOG.level_statement,
593: g_pkg_name || '.' || l_api_name,
594: 'Found Event for the collection. Adding record: ' || ctr || ' E-Record: ' || x_qa_erecord_tbl(ctr).erec_id
595: );
596: END IF;

Line 605: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

601: END IF;
602:
603: l_event_key := occ_cur.plan_id || '-' || p_collection_id || '-' || occ_cur.occurrence;
604:
605: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
606: FND_LOG.string
607: (
608: FND_LOG.level_statement,
609: g_pkg_name || '.' || l_api_name,

Line 606: FND_LOG.string

602:
603: l_event_key := occ_cur.plan_id || '-' || p_collection_id || '-' || occ_cur.occurrence;
604:
605: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
606: FND_LOG.string
607: (
608: FND_LOG.level_statement,
609: g_pkg_name || '.' || l_api_name,
610: 'Checking if event exists for the occurrence. Event Key: ' || l_event_key

Line 608: FND_LOG.level_statement,

604:
605: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
606: FND_LOG.string
607: (
608: FND_LOG.level_statement,
609: g_pkg_name || '.' || l_api_name,
610: 'Checking if event exists for the occurrence. Event Key: ' || l_event_key
611: );
612: END IF;

Line 620: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

616: x_qa_erecord_tbl(ctr).event_name := erec_cur.event_name;
617: x_qa_erecord_tbl(ctr).event_key := l_event_key;
618: x_qa_erecord_tbl(ctr).erec_id := erec_cur.document_id;
619:
620: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
621: FND_LOG.string
622: (
623: FND_LOG.level_statement,
624: g_pkg_name || '.' || l_api_name,

Line 621: FND_LOG.string

617: x_qa_erecord_tbl(ctr).event_key := l_event_key;
618: x_qa_erecord_tbl(ctr).erec_id := erec_cur.document_id;
619:
620: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
621: FND_LOG.string
622: (
623: FND_LOG.level_statement,
624: g_pkg_name || '.' || l_api_name,
625: 'Found Event for the collection. Adding record: ' || ctr || ' E-Record: ' || x_qa_erecord_tbl(ctr).erec_id

Line 623: FND_LOG.level_statement,

619:
620: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
621: FND_LOG.string
622: (
623: FND_LOG.level_statement,
624: g_pkg_name || '.' || l_api_name,
625: 'Found Event for the collection. Adding record: ' || ctr || ' E-Record: ' || x_qa_erecord_tbl(ctr).erec_id
626: );
627: END IF;

Line 640: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

636: p_count => x_msg_count,
637: p_data => x_msg_data
638: );
639:
640: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
641: FND_LOG.string
642: (
643: FND_LOG.level_procedure,
644: g_pkg_name || '.' || l_api_name,

Line 641: FND_LOG.string

637: p_data => x_msg_data
638: );
639:
640: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
641: FND_LOG.string
642: (
643: FND_LOG.level_procedure,
644: g_pkg_name || '.' || l_api_name,
645: 'Exiting Procedure: Success'

Line 643: FND_LOG.level_procedure,

639:
640: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
641: FND_LOG.string
642: (
643: FND_LOG.level_procedure,
644: g_pkg_name || '.' || l_api_name,
645: 'Exiting Procedure: Success'
646: );
647: END IF;

Line 659: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );
658:
659: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
660: FND_LOG.string
661: (
662: FND_LOG.level_procedure,
663: g_pkg_name || '.' || l_api_name,

Line 660: FND_LOG.string

656: p_data => x_msg_data
657: );
658:
659: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
660: FND_LOG.string
661: (
662: FND_LOG.level_procedure,
663: g_pkg_name || '.' || l_api_name,
664: 'Exiting Procedure: Error'

Line 662: FND_LOG.level_procedure,

658:
659: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
660: FND_LOG.string
661: (
662: FND_LOG.level_procedure,
663: g_pkg_name || '.' || l_api_name,
664: 'Exiting Procedure: Error'
665: );
666: END IF;

Line 676: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

672: p_count => x_msg_count,
673: p_data => x_msg_data
674: );
675:
676: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
677: FND_LOG.string
678: (
679: FND_LOG.level_procedure,
680: g_pkg_name || '.' || l_api_name,

Line 677: FND_LOG.string

673: p_data => x_msg_data
674: );
675:
676: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
677: FND_LOG.string
678: (
679: FND_LOG.level_procedure,
680: g_pkg_name || '.' || l_api_name,
681: 'Exiting Procedure: Error'

Line 679: FND_LOG.level_procedure,

675:
676: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
677: FND_LOG.string
678: (
679: FND_LOG.level_procedure,
680: g_pkg_name || '.' || l_api_name,
681: 'Exiting Procedure: Error'
682: );
683: END IF;

Line 702: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

698: p_count => x_msg_count,
699: p_data => x_msg_data
700: );
701:
702: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
703: FND_LOG.string
704: (
705: FND_LOG.level_procedure,
706: g_pkg_name || '.' || l_api_name,

Line 703: FND_LOG.string

699: p_data => x_msg_data
700: );
701:
702: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
703: FND_LOG.string
704: (
705: FND_LOG.level_procedure,
706: g_pkg_name || '.' || l_api_name,
707: 'Exiting Procedure: Error'

Line 705: FND_LOG.level_procedure,

701:
702: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
703: FND_LOG.string
704: (
705: FND_LOG.level_procedure,
706: g_pkg_name || '.' || l_api_name,
707: 'Exiting Procedure: Error'
708: );
709: END IF;

Line 811: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

807:
808: BEGIN
809: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
810:
811: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
812: FND_LOG.string
813: (
814: FND_LOG.level_procedure,
815: g_pkg_name || '.' || l_api_name,

Line 812: FND_LOG.string

808: BEGIN
809: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
810:
811: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
812: FND_LOG.string
813: (
814: FND_LOG.level_procedure,
815: g_pkg_name || '.' || l_api_name,
816: 'Entering Procedure for collection: ' || p_collection_id

Line 814: FND_LOG.level_procedure,

810:
811: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
812: FND_LOG.string
813: (
814: FND_LOG.level_procedure,
815: g_pkg_name || '.' || l_api_name,
816: 'Entering Procedure for collection: ' || p_collection_id
817: );
818: END IF;

Line 844: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:
842: IF ( FND_PROFILE.value('EDR_ERES_ENABLED') = 'Y' ) THEN
843:
844: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
845: FND_LOG.string
846: (
847: FND_LOG.level_statement,
848: g_pkg_name || '.' || l_api_name,

Line 845: FND_LOG.string

841:
842: IF ( FND_PROFILE.value('EDR_ERES_ENABLED') = 'Y' ) THEN
843:
844: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
845: FND_LOG.string
846: (
847: FND_LOG.level_statement,
848: g_pkg_name || '.' || l_api_name,
849: 'Before Getting QA Result ERecords'

Line 847: FND_LOG.level_statement,

843:
844: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
845: FND_LOG.string
846: (
847: FND_LOG.level_statement,
848: g_pkg_name || '.' || l_api_name,
849: 'Before Getting QA Result ERecords'
850: );
851: END IF;

Line 867: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

863: x_msg_count => l_msg_count,
864: x_msg_data => l_msg_data
865: );
866:
867: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
868: FND_LOG.string
869: (
870: FND_LOG.level_statement,
871: g_pkg_name || '.' || l_api_name,

Line 868: FND_LOG.string

864: x_msg_data => l_msg_data
865: );
866:
867: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
868: FND_LOG.string
869: (
870: FND_LOG.level_statement,
871: g_pkg_name || '.' || l_api_name,
872: 'Obtained ' || l_erec_tbl.COUNT || ' number of QA Result ERecords'

Line 870: FND_LOG.level_statement,

866:
867: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
868: FND_LOG.string
869: (
870: FND_LOG.level_statement,
871: g_pkg_name || '.' || l_api_name,
872: 'Obtained ' || l_erec_tbl.COUNT || ' number of QA Result ERecords'
873: );
874: END IF;

Line 880: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

876: -- Send Transaction Acknowledgement for E-Records obtained
877: IF ( l_erec_tbl.COUNT > 0 ) THEN
878: FOR i IN l_erec_tbl.FIRST..l_erec_tbl.LAST LOOP
879:
880: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
881: FND_LOG.string
882: (
883: FND_LOG.level_statement,
884: g_pkg_name || '.' || l_api_name,

Line 881: FND_LOG.string

877: IF ( l_erec_tbl.COUNT > 0 ) THEN
878: FOR i IN l_erec_tbl.FIRST..l_erec_tbl.LAST LOOP
879:
880: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
881: FND_LOG.string
882: (
883: FND_LOG.level_statement,
884: g_pkg_name || '.' || l_api_name,
885: 'Before Sending Txn acknowledgement for ERecord: ' || l_erec_tbl(i).erec_id || ' with event_name: ' || l_erec_tbl(i).event_name || ' and event_key: ' || l_erec_tbl(i).event_key

Line 883: FND_LOG.level_statement,

879:
880: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
881: FND_LOG.string
882: (
883: FND_LOG.level_statement,
884: g_pkg_name || '.' || l_api_name,
885: 'Before Sending Txn acknowledgement for ERecord: ' || l_erec_tbl(i).erec_id || ' with event_name: ' || l_erec_tbl(i).event_name || ' and event_key: ' || l_erec_tbl(i).event_key
886: );
887: END IF;

Line 909: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

905: END IF;
906:
907: END IF;
908:
909: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
910: FND_LOG.string
911: (
912: FND_LOG.level_statement,
913: g_pkg_name || '.' || l_api_name,

Line 910: FND_LOG.string

906:
907: END IF;
908:
909: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
910: FND_LOG.string
911: (
912: FND_LOG.level_statement,
913: g_pkg_name || '.' || l_api_name,
914: 'Before Enabling QA Results and firing Actions'

Line 912: FND_LOG.level_statement,

908:
909: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
910: FND_LOG.string
911: (
912: FND_LOG.level_statement,
913: g_pkg_name || '.' || l_api_name,
914: 'Before Enabling QA Results and firing Actions'
915: );
916: END IF;

Line 1012: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1008: p_count => x_msg_count,
1009: p_data => x_msg_data
1010: );
1011:
1012: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1013: FND_LOG.string
1014: (
1015: FND_LOG.level_procedure,
1016: g_pkg_name || '.' || l_api_name,

Line 1013: FND_LOG.string

1009: p_data => x_msg_data
1010: );
1011:
1012: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1013: FND_LOG.string
1014: (
1015: FND_LOG.level_procedure,
1016: g_pkg_name || '.' || l_api_name,
1017: 'Exiting Procedure: Success'

Line 1015: FND_LOG.level_procedure,

1011:
1012: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1013: FND_LOG.string
1014: (
1015: FND_LOG.level_procedure,
1016: g_pkg_name || '.' || l_api_name,
1017: 'Exiting Procedure: Success'
1018: );
1019: END IF;

Line 1032: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1028: p_count => x_msg_count,
1029: p_data => x_msg_data
1030: );
1031:
1032: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1033: FND_LOG.string
1034: (
1035: FND_LOG.level_procedure,
1036: g_pkg_name || '.' || l_api_name,

Line 1033: FND_LOG.string

1029: p_data => x_msg_data
1030: );
1031:
1032: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1033: FND_LOG.string
1034: (
1035: FND_LOG.level_procedure,
1036: g_pkg_name || '.' || l_api_name,
1037: 'Exiting Procedure: Error'

Line 1035: FND_LOG.level_procedure,

1031:
1032: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1033: FND_LOG.string
1034: (
1035: FND_LOG.level_procedure,
1036: g_pkg_name || '.' || l_api_name,
1037: 'Exiting Procedure: Error'
1038: );
1039: END IF;

Line 1050: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1046: p_count => x_msg_count,
1047: p_data => x_msg_data
1048: );
1049:
1050: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1051: FND_LOG.string
1052: (
1053: FND_LOG.level_procedure,
1054: g_pkg_name || '.' || l_api_name,

Line 1051: FND_LOG.string

1047: p_data => x_msg_data
1048: );
1049:
1050: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1051: FND_LOG.string
1052: (
1053: FND_LOG.level_procedure,
1054: g_pkg_name || '.' || l_api_name,
1055: 'Exiting Procedure: Error'

Line 1053: FND_LOG.level_procedure,

1049:
1050: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1051: FND_LOG.string
1052: (
1053: FND_LOG.level_procedure,
1054: g_pkg_name || '.' || l_api_name,
1055: 'Exiting Procedure: Error'
1056: );
1057: END IF;

Line 1077: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1073: p_count => x_msg_count,
1074: p_data => x_msg_data
1075: );
1076:
1077: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1078: FND_LOG.string
1079: (
1080: FND_LOG.level_procedure,
1081: g_pkg_name || '.' || l_api_name,

Line 1078: FND_LOG.string

1074: p_data => x_msg_data
1075: );
1076:
1077: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1078: FND_LOG.string
1079: (
1080: FND_LOG.level_procedure,
1081: g_pkg_name || '.' || l_api_name,
1082: 'Exiting Procedure: Error'

Line 1080: FND_LOG.level_procedure,

1076:
1077: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1078: FND_LOG.string
1079: (
1080: FND_LOG.level_procedure,
1081: g_pkg_name || '.' || l_api_name,
1082: 'Exiting Procedure: Error'
1083: );
1084: END IF;

Line 1117: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1113:
1114: BEGIN
1115: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1116:
1117: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1118: FND_LOG.string
1119: (
1120: FND_LOG.level_procedure,
1121: g_pkg_name || '.' || l_api_name,

Line 1118: FND_LOG.string

1114: BEGIN
1115: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1116:
1117: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1118: FND_LOG.string
1119: (
1120: FND_LOG.level_procedure,
1121: g_pkg_name || '.' || l_api_name,
1122: 'Entering Procedure for collection: ' || p_collection_id

Line 1120: FND_LOG.level_procedure,

1116:
1117: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1118: FND_LOG.string
1119: (
1120: FND_LOG.level_procedure,
1121: g_pkg_name || '.' || l_api_name,
1122: 'Entering Procedure for collection: ' || p_collection_id
1123: );
1124: END IF;

Line 1150: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1146: x_return_status := FND_API.G_RET_STS_SUCCESS;
1147:
1148: IF ( FND_PROFILE.value('EDR_ERES_ENABLED') = 'Y' ) THEN
1149:
1150: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1151: FND_LOG.string
1152: (
1153: FND_LOG.level_statement,
1154: g_pkg_name || '.' || l_api_name,

Line 1151: FND_LOG.string

1147:
1148: IF ( FND_PROFILE.value('EDR_ERES_ENABLED') = 'Y' ) THEN
1149:
1150: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1151: FND_LOG.string
1152: (
1153: FND_LOG.level_statement,
1154: g_pkg_name || '.' || l_api_name,
1155: 'Before Getting QA Result ERecords'

Line 1153: FND_LOG.level_statement,

1149:
1150: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1151: FND_LOG.string
1152: (
1153: FND_LOG.level_statement,
1154: g_pkg_name || '.' || l_api_name,
1155: 'Before Getting QA Result ERecords'
1156: );
1157: END IF;

Line 1173: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1169: x_msg_count => l_msg_count,
1170: x_msg_data => l_msg_data
1171: );
1172:
1173: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1174: FND_LOG.string
1175: (
1176: FND_LOG.level_statement,
1177: g_pkg_name || '.' || l_api_name,

Line 1174: FND_LOG.string

1170: x_msg_data => l_msg_data
1171: );
1172:
1173: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1174: FND_LOG.string
1175: (
1176: FND_LOG.level_statement,
1177: g_pkg_name || '.' || l_api_name,
1178: 'Obtained ' || l_erec_tbl.COUNT || ' number of QA Result ERecords'

Line 1176: FND_LOG.level_statement,

1172:
1173: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1174: FND_LOG.string
1175: (
1176: FND_LOG.level_statement,
1177: g_pkg_name || '.' || l_api_name,
1178: 'Obtained ' || l_erec_tbl.COUNT || ' number of QA Result ERecords'
1179: );
1180: END IF;

Line 1186: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1182: -- Send Transaction Acknowledgement for E-Records obtained
1183: IF ( l_erec_tbl.COUNT > 0 ) THEN
1184: FOR i IN l_erec_tbl.FIRST..l_erec_tbl.LAST LOOP
1185:
1186: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1187: FND_LOG.string
1188: (
1189: FND_LOG.level_statement,
1190: g_pkg_name || '.' || l_api_name,

Line 1187: FND_LOG.string

1183: IF ( l_erec_tbl.COUNT > 0 ) THEN
1184: FOR i IN l_erec_tbl.FIRST..l_erec_tbl.LAST LOOP
1185:
1186: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1187: FND_LOG.string
1188: (
1189: FND_LOG.level_statement,
1190: g_pkg_name || '.' || l_api_name,
1191: 'Before Sending Txn acknowledgement for ERecord: ' || l_erec_tbl(i).erec_id || ' with event_name: ' || l_erec_tbl(i).event_name || ' and event_key: ' || l_erec_tbl(i).event_key

Line 1189: FND_LOG.level_statement,

1185:
1186: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1187: FND_LOG.string
1188: (
1189: FND_LOG.level_statement,
1190: g_pkg_name || '.' || l_api_name,
1191: 'Before Sending Txn acknowledgement for ERecord: ' || l_erec_tbl(i).erec_id || ' with event_name: ' || l_erec_tbl(i).event_name || ' and event_key: ' || l_erec_tbl(i).event_key
1192: );
1193: END IF;

Line 1215: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

1211: END IF;
1212:
1213: END IF;
1214:
1215: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1216: FND_LOG.string
1217: (
1218: FND_LOG.level_statement,
1219: g_pkg_name || '.' || l_api_name,

Line 1216: FND_LOG.string

1212:
1213: END IF;
1214:
1215: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1216: FND_LOG.string
1217: (
1218: FND_LOG.level_statement,
1219: g_pkg_name || '.' || l_api_name,
1220: 'Before Purging QA Results'

Line 1218: FND_LOG.level_statement,

1214:
1215: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
1216: FND_LOG.string
1217: (
1218: FND_LOG.level_statement,
1219: g_pkg_name || '.' || l_api_name,
1220: 'Before Purging QA Results'
1221: );
1222: END IF;

Line 1249: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1245: p_count => x_msg_count,
1246: p_data => x_msg_data
1247: );
1248:
1249: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1250: FND_LOG.string
1251: (
1252: FND_LOG.level_procedure,
1253: g_pkg_name || '.' || l_api_name,

Line 1250: FND_LOG.string

1246: p_data => x_msg_data
1247: );
1248:
1249: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1250: FND_LOG.string
1251: (
1252: FND_LOG.level_procedure,
1253: g_pkg_name || '.' || l_api_name,
1254: 'Exiting Procedure: Success'

Line 1252: FND_LOG.level_procedure,

1248:
1249: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1250: FND_LOG.string
1251: (
1252: FND_LOG.level_procedure,
1253: g_pkg_name || '.' || l_api_name,
1254: 'Exiting Procedure: Success'
1255: );
1256: END IF;

Line 1269: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1265: p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );
1268:
1269: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1270: FND_LOG.string
1271: (
1272: FND_LOG.level_procedure,
1273: g_pkg_name || '.' || l_api_name,

Line 1270: FND_LOG.string

1266: p_data => x_msg_data
1267: );
1268:
1269: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1270: FND_LOG.string
1271: (
1272: FND_LOG.level_procedure,
1273: g_pkg_name || '.' || l_api_name,
1274: 'Exiting Procedure: Error'

Line 1272: FND_LOG.level_procedure,

1268:
1269: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1270: FND_LOG.string
1271: (
1272: FND_LOG.level_procedure,
1273: g_pkg_name || '.' || l_api_name,
1274: 'Exiting Procedure: Error'
1275: );
1276: END IF;

Line 1287: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1283: p_count => x_msg_count,
1284: p_data => x_msg_data
1285: );
1286:
1287: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1288: FND_LOG.string
1289: (
1290: FND_LOG.level_procedure,
1291: g_pkg_name || '.' || l_api_name,

Line 1288: FND_LOG.string

1284: p_data => x_msg_data
1285: );
1286:
1287: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1288: FND_LOG.string
1289: (
1290: FND_LOG.level_procedure,
1291: g_pkg_name || '.' || l_api_name,
1292: 'Exiting Procedure: Error'

Line 1290: FND_LOG.level_procedure,

1286:
1287: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1288: FND_LOG.string
1289: (
1290: FND_LOG.level_procedure,
1291: g_pkg_name || '.' || l_api_name,
1292: 'Exiting Procedure: Error'
1293: );
1294: END IF;

Line 1314: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

1310: p_count => x_msg_count,
1311: p_data => x_msg_data
1312: );
1313:
1314: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1315: FND_LOG.string
1316: (
1317: FND_LOG.level_procedure,
1318: g_pkg_name || '.' || l_api_name,

Line 1315: FND_LOG.string

1311: p_data => x_msg_data
1312: );
1313:
1314: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1315: FND_LOG.string
1316: (
1317: FND_LOG.level_procedure,
1318: g_pkg_name || '.' || l_api_name,
1319: 'Exiting Procedure: Error'

Line 1317: FND_LOG.level_procedure,

1313:
1314: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1315: FND_LOG.string
1316: (
1317: FND_LOG.level_procedure,
1318: g_pkg_name || '.' || l_api_name,
1319: 'Exiting Procedure: Error'
1320: );
1321: END IF;