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

Line 606: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

602:
603:
604: -- skekkar
605: BEGIN
606: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
607: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
608: '100: Entered ' || g_pkg_name || '.' || l_api_name
609: );
610: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

Line 607: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

603:
604: -- skekkar
605: BEGIN
606: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
607: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
608: '100: Entered ' || g_pkg_name || '.' || l_api_name
609: );
610: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
611: '100: p_template_set_id : '||p_rtmpv_rec.template_set_id

Line 610: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

606: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
607: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
608: '100: Entered ' || g_pkg_name || '.' || l_api_name
609: );
610: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
611: '100: p_template_set_id : '||p_rtmpv_rec.template_set_id
612: );
613: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
614: '100: p_document_type : '||p_rtmpv_rec.template_set_type

Line 613: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

609: );
610: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
611: '100: p_template_set_id : '||p_rtmpv_rec.template_set_id
612: );
613: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
614: '100: p_document_type : '||p_rtmpv_rec.template_set_type
615: );
616: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
617: '100: p_process_code : '||p_rtmpv_rec.process_code

Line 616: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

612: );
613: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
614: '100: p_document_type : '||p_rtmpv_rec.template_set_type
615: );
616: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
617: '100: p_process_code : '||p_rtmpv_rec.process_code
618: );
619: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
620: '100: p_applies_to : '||p_rtmpv_rec.applies_to

Line 619: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

615: );
616: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
617: '100: p_process_code : '||p_rtmpv_rec.process_code
618: );
619: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
620: '100: p_applies_to : '||p_rtmpv_rec.applies_to
621: );
622: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
623: '100: p_report_duration : '||p_rtmpv_rec.report_duration

Line 622: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

618: );
619: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
620: '100: p_applies_to : '||p_rtmpv_rec.applies_to
621: );
622: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
623: '100: p_report_duration : '||p_rtmpv_rec.report_duration
624: );
625: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
626: '100: p_report_period : '||p_rtmpv_rec.report_period

Line 625: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

621: );
622: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
623: '100: p_report_duration : '||p_rtmpv_rec.report_duration
624: );
625: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
626: '100: p_report_period : '||p_rtmpv_rec.report_period
627: );
628: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
629: '100: p_id : '||p_rtmpv_rec.id

Line 628: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

624: );
625: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
626: '100: p_report_period : '||p_rtmpv_rec.report_period
627: );
628: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
629: '100: p_id : '||p_rtmpv_rec.id
630: );
631: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
632: '100: p_rtmpv_rec.start_date : '||p_rtmpv_rec.start_date

Line 631: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

627: );
628: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
629: '100: p_id : '||p_rtmpv_rec.id
630: );
631: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
632: '100: p_rtmpv_rec.start_date : '||p_rtmpv_rec.start_date
633: );
634: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
635: '100: p_rtmpv_rec.end_date : '||p_rtmpv_rec.end_date

Line 634: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

630: );
631: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
632: '100: p_rtmpv_rec.start_date : '||p_rtmpv_rec.start_date
633: );
634: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
635: '100: p_rtmpv_rec.end_date : '||p_rtmpv_rec.end_date
636: );
637: END IF;
638:

Line 649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

645: IF p_rtmpv_rec.process_code <> 'M' -- bug 5916645
646: OR (p_rtmpv_rec.process_code = 'M' AND p_rtmpv_rec.template_set_type <> 'QUOTE' ) -- bug 6030060
647: THEN
648:
649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
650: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
651: '110: Check 1: Check if the same combination exists '
652: );
653: END IF;

Line 650: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

646: OR (p_rtmpv_rec.process_code = 'M' AND p_rtmpv_rec.template_set_type <> 'QUOTE' ) -- bug 6030060
647: THEN
648:
649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
650: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
651: '110: Check 1: Check if the same combination exists '
652: );
653: END IF;
654:

Line 661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

657: -- Check 1: Check if the same combination exists
658: --
659: IF p_rtmpv_rec.template_set_type IN ('RMN','CCN') THEN
660:
661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
662: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
663: '120: OPEN csr_check_record2'
664: );
665: END IF;

Line 662: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

658: --
659: IF p_rtmpv_rec.template_set_type IN ('RMN','CCN') THEN
660:
661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
662: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
663: '120: OPEN csr_check_record2'
664: );
665: END IF;
666:

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

672: p_report_period => p_rtmpv_rec.report_period,
673: p_id => p_rtmpv_rec.id);
674: FETCH csr_check_record2 INTO l_start_date, l_end_date;
675:
676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
677: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
678: '120: AFTER OPENING csr_check_record2'
679: );
680: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

Line 677: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

673: p_id => p_rtmpv_rec.id);
674: FETCH csr_check_record2 INTO l_start_date, l_end_date;
675:
676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
677: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
678: '120: AFTER OPENING csr_check_record2'
679: );
680: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
681: '120: l_start_date : '||l_start_date

Line 680: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
677: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
678: '120: AFTER OPENING csr_check_record2'
679: );
680: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
681: '120: l_start_date : '||l_start_date
682: );
683: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
684: '120: l_end_date : '||l_end_date

Line 683: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

679: );
680: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
681: '120: l_start_date : '||l_start_date
682: );
683: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
684: '120: l_end_date : '||l_end_date
685: );
686: END IF;
687:

Line 704: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

700: END IF; -- csr_check_record2%FOUND
701: CLOSE csr_check_record2;
702:
703: ELSE
704: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
705: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
706: '130: OPEN csr_check_record1'
707: );
708: END IF;

Line 705: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

701: CLOSE csr_check_record2;
702:
703: ELSE
704: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
705: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
706: '130: OPEN csr_check_record1'
707: );
708: END IF;
709:

Line 717: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

713: p_applies_to => p_rtmpv_rec.applies_to,
714: p_id => p_rtmpv_rec.id);
715: FETCH csr_check_record1 INTO l_start_date, l_end_date;
716:
717: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
719: '140: AFTER OPENING csr_check_record1'
720: );
721: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

Line 718: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

714: p_id => p_rtmpv_rec.id);
715: FETCH csr_check_record1 INTO l_start_date, l_end_date;
716:
717: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
719: '140: AFTER OPENING csr_check_record1'
720: );
721: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
722: '140: l_start_date : '||l_start_date

Line 721: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

717: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
719: '140: AFTER OPENING csr_check_record1'
720: );
721: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
722: '140: l_start_date : '||l_start_date
723: );
724: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
725: '140: l_end_date : '||l_end_date

Line 724: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

720: );
721: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
722: '140: l_start_date : '||l_start_date
723: );
724: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
725: '140: l_end_date : '||l_end_date
726: );
727: END IF;
728:

Line 750: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

746: --
747: -- Check 2: If current record process_code is 'B' then check no records for the same date range with
748: -- process_code as 'O' or 'M'
749: --
750: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
751: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
752: '200: Check 2: If current record process_code is B'
753: );
754: END IF;

Line 751: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

747: -- Check 2: If current record process_code is 'B' then check no records for the same date range with
748: -- process_code as 'O' or 'M'
749: --
750: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
751: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
752: '200: Check 2: If current record process_code is B'
753: );
754: END IF;
755:

Line 758: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

754: END IF;
755:
756: IF p_rtmpv_rec.process_code = 'B' THEN
757:
758: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
759: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
760: '220: OPEN csr_check_record3'
761: );
762: END IF;

Line 759: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

755:
756: IF p_rtmpv_rec.process_code = 'B' THEN
757:
758: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
759: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
760: '220: OPEN csr_check_record3'
761: );
762: END IF;
763:

Line 772: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

768: p_report_period => p_rtmpv_rec.report_period,
769: p_id => p_rtmpv_rec.id);
770: FETCH csr_check_record3 INTO l_start_date, l_end_date;
771:
772: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
773: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
774: '240: AFTER OPENING csr_check_record3'
775: );
776: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

Line 773: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

769: p_id => p_rtmpv_rec.id);
770: FETCH csr_check_record3 INTO l_start_date, l_end_date;
771:
772: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
773: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
774: '240: AFTER OPENING csr_check_record3'
775: );
776: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
777: '240: l_start_date : '||l_start_date

Line 776: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

772: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
773: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
774: '240: AFTER OPENING csr_check_record3'
775: );
776: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
777: '240: l_start_date : '||l_start_date
778: );
779: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
780: '240: l_end_date : '||l_end_date

Line 779: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

775: );
776: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
777: '240: l_start_date : '||l_start_date
778: );
779: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
780: '240: l_end_date : '||l_end_date
781: );
782: END IF;
783:

Line 806: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

802: --
803: -- Check 3: If current record process_code is 'O' or 'M' then check no records for the same date range with
804: -- process_code as 'B'
805: --
806: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
807: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
808: '300: Check 3: If current record process_code is O or M'
809: );
810: END IF;

Line 807: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

803: -- Check 3: If current record process_code is 'O' or 'M' then check no records for the same date range with
804: -- process_code as 'B'
805: --
806: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
807: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
808: '300: Check 3: If current record process_code is O or M'
809: );
810: END IF;
811:

Line 815: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

811:
812: IF p_rtmpv_rec.process_code IN ('O','M') THEN
813: -- IF p_rtmpv_rec.process_code = 'O' THEN -- bug 5916645
814:
815: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
816: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
817: '320: OPEN csr_check_record4'
818: );
819: END IF;

Line 816: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

812: IF p_rtmpv_rec.process_code IN ('O','M') THEN
813: -- IF p_rtmpv_rec.process_code = 'O' THEN -- bug 5916645
814:
815: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
816: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
817: '320: OPEN csr_check_record4'
818: );
819: END IF;
820:

Line 829: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

825: p_report_period => p_rtmpv_rec.report_period,
826: p_id => p_rtmpv_rec.id);
827: FETCH csr_check_record4 INTO l_start_date, l_end_date;
828:
829: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
830: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
831: '340: AFTER OPENING csr_check_record4'
832: );
833: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

Line 830: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

826: p_id => p_rtmpv_rec.id);
827: FETCH csr_check_record4 INTO l_start_date, l_end_date;
828:
829: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
830: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
831: '340: AFTER OPENING csr_check_record4'
832: );
833: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
834: '340: l_start_date : '||l_start_date

Line 833: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

829: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
830: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
831: '340: AFTER OPENING csr_check_record4'
832: );
833: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
834: '340: l_start_date : '||l_start_date
835: );
836: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
837: '340: l_end_date : '||l_end_date

Line 836: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

832: );
833: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
834: '340: l_start_date : '||l_start_date
835: );
836: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
837: '340: l_end_date : '||l_end_date
838: );
839: END IF;
840:

Line 863: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

859: --
860: -- Check 4: If current record applies_to is 'B' then check no records for the same date range with
861: -- applies_to as 'N' or 'R'
862: --
863: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
864: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
865: '400: Check 4: If current record applies_to is B'
866: );
867: END IF;

Line 864: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

860: -- Check 4: If current record applies_to is 'B' then check no records for the same date range with
861: -- applies_to as 'N' or 'R'
862: --
863: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
864: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
865: '400: Check 4: If current record applies_to is B'
866: );
867: END IF;
868:

Line 871: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

867: END IF;
868:
869: IF p_rtmpv_rec.applies_to = 'B' THEN
870:
871: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
872: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
873: '420: OPEN csr_check_record5'
874: );
875: END IF;

Line 872: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

868:
869: IF p_rtmpv_rec.applies_to = 'B' THEN
870:
871: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
872: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
873: '420: OPEN csr_check_record5'
874: );
875: END IF;
876:

Line 885: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

881: p_report_period => p_rtmpv_rec.report_period,
882: p_id => p_rtmpv_rec.id);
883: FETCH csr_check_record5 INTO l_start_date, l_end_date;
884:
885: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
886: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
887: '440: AFTER OPENING csr_check_record5'
888: );
889: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

Line 886: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

882: p_id => p_rtmpv_rec.id);
883: FETCH csr_check_record5 INTO l_start_date, l_end_date;
884:
885: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
886: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
887: '440: AFTER OPENING csr_check_record5'
888: );
889: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
890: '440: l_start_date : '||l_start_date

Line 889: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

885: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
886: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
887: '440: AFTER OPENING csr_check_record5'
888: );
889: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
890: '440: l_start_date : '||l_start_date
891: );
892: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
893: '440: l_end_date : '||l_end_date

Line 892: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

888: );
889: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
890: '440: l_start_date : '||l_start_date
891: );
892: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
893: '440: l_end_date : '||l_end_date
894: );
895: END IF;
896:

Line 918: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

914: --
915: -- Check 5: If current record applies_to in ('N','R') then check no records for the same date range with
916: -- applies_to as 'B'
917: --
918: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
919: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
920: '500: Check 5: If current record applies_to is N or R'
921: );
922: END IF;

Line 919: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

915: -- Check 5: If current record applies_to in ('N','R') then check no records for the same date range with
916: -- applies_to as 'B'
917: --
918: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
919: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
920: '500: Check 5: If current record applies_to is N or R'
921: );
922: END IF;
923:

Line 926: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

922: END IF;
923:
924: IF p_rtmpv_rec.applies_to IN ('N','R') THEN
925:
926: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
927: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
928: '520: OPEN csr_check_record6'
929: );
930: END IF;

Line 927: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

923:
924: IF p_rtmpv_rec.applies_to IN ('N','R') THEN
925:
926: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
927: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
928: '520: OPEN csr_check_record6'
929: );
930: END IF;
931:

Line 940: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

936: p_report_period => p_rtmpv_rec.report_period,
937: p_id => p_rtmpv_rec.id);
938: FETCH csr_check_record6 INTO l_start_date, l_end_date;
939:
940: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
941: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
942: '540: AFTER OPENING csr_check_record6'
943: );
944: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

Line 941: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

937: p_id => p_rtmpv_rec.id);
938: FETCH csr_check_record6 INTO l_start_date, l_end_date;
939:
940: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
941: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
942: '540: AFTER OPENING csr_check_record6'
943: );
944: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
945: '540: l_start_date : '||l_start_date

Line 944: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

940: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
941: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
942: '540: AFTER OPENING csr_check_record6'
943: );
944: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
945: '540: l_start_date : '||l_start_date
946: );
947: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
948: '540: l_end_date : '||l_end_date

Line 947: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

943: );
944: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
945: '540: l_start_date : '||l_start_date
946: );
947: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
948: '540: l_end_date : '||l_end_date
949: );
950: END IF;
951:

Line 976: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

972: -- Check 6: bug 5873004
973: -- New Validation: Both Message and Attachment template are optional
974: -- For each record atleast ONE of the template MUST be specified.
975: --
976: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
977: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
978: '600: Check 6: Both Message and Attachment template are optional'
979: );
980: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

Line 977: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

973: -- New Validation: Both Message and Attachment template are optional
974: -- For each record atleast ONE of the template MUST be specified.
975: --
976: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
977: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
978: '600: Check 6: Both Message and Attachment template are optional'
979: );
980: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
981: '600: p_rtmpv_rec.message_template_id : '||p_rtmpv_rec.message_template_id

Line 980: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

976: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
977: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
978: '600: Check 6: Both Message and Attachment template are optional'
979: );
980: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
981: '600: p_rtmpv_rec.message_template_id : '||p_rtmpv_rec.message_template_id
982: );
983: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
984: '600: p_rtmpv_rec.report_id: '||p_rtmpv_rec.report_id

Line 983: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,

979: );
980: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
981: '600: p_rtmpv_rec.message_template_id : '||p_rtmpv_rec.message_template_id
982: );
983: fnd_log.STRING (fnd_log.level_procedure, g_module || l_api_name,
984: '600: p_rtmpv_rec.report_id: '||p_rtmpv_rec.report_id
985: );
986: END IF;
987: