45: l_start_time VARCHAR2(80);
46: BEGIN
47: l_duration := (p_end_date - p_start_date)*24*60;
48: IF l_duration IN (0, 1439) THEN
49: fnd_message.set_name('JTF','CAC_VIEW_APT_ALL_DAY');
50: l_start_time := fnd_message.get;
51: ELSE
52: l_start_time := TO_CHAR(p_start_date, 'HH12:MI AM');
53: END IF;
46: BEGIN
47: l_duration := (p_end_date - p_start_date)*24*60;
48: IF l_duration IN (0, 1439) THEN
49: fnd_message.set_name('JTF','CAC_VIEW_APT_ALL_DAY');
50: l_start_time := fnd_message.get;
51: ELSE
52: l_start_time := TO_CHAR(p_start_date, 'HH12:MI AM');
53: END IF;
54:
708: IS
709: BEGIN
710: IF p_occurs_number IS NOT NULL THEN
711: IF p_occurs_every = 1 THEN
712: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_4');
713: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
714: ELSE
715: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_2');
716: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
709: BEGIN
710: IF p_occurs_number IS NOT NULL THEN
711: IF p_occurs_every = 1 THEN
712: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_4');
713: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
714: ELSE
715: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_2');
716: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
717: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
711: IF p_occurs_every = 1 THEN
712: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_4');
713: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
714: ELSE
715: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_2');
716: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
717: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
718: END IF;
719: ELSE
712: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_4');
713: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
714: ELSE
715: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_2');
716: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
717: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
718: END IF;
719: ELSE
720: IF p_occurs_every = 1 THEN
713: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
714: ELSE
715: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_2');
716: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
717: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
718: END IF;
719: ELSE
720: IF p_occurs_every = 1 THEN
721: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_3');
717: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
718: END IF;
719: ELSE
720: IF p_occurs_every = 1 THEN
721: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_3');
722: fnd_message.set_token('END_DATE', p_end_date);
723: ELSE
724: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_1');
725: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
718: END IF;
719: ELSE
720: IF p_occurs_every = 1 THEN
721: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_3');
722: fnd_message.set_token('END_DATE', p_end_date);
723: ELSE
724: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_1');
725: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
726: fnd_message.set_token('END_DATE', p_end_date);
720: IF p_occurs_every = 1 THEN
721: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_3');
722: fnd_message.set_token('END_DATE', p_end_date);
723: ELSE
724: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_1');
725: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
726: fnd_message.set_token('END_DATE', p_end_date);
727: END IF;
728: END IF;
721: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_3');
722: fnd_message.set_token('END_DATE', p_end_date);
723: ELSE
724: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_1');
725: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
726: fnd_message.set_token('END_DATE', p_end_date);
727: END IF;
728: END IF;
729: fnd_message.set_token('TIMEZONE', p_timezone);
722: fnd_message.set_token('END_DATE', p_end_date);
723: ELSE
724: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_1');
725: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
726: fnd_message.set_token('END_DATE', p_end_date);
727: END IF;
728: END IF;
729: fnd_message.set_token('TIMEZONE', p_timezone);
730:
725: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
726: fnd_message.set_token('END_DATE', p_end_date);
727: END IF;
728: END IF;
729: fnd_message.set_token('TIMEZONE', p_timezone);
730:
731: RETURN fnd_message.get;
732: END make_sentence_daily;
733:
727: END IF;
728: END IF;
729: fnd_message.set_token('TIMEZONE', p_timezone);
730:
731: RETURN fnd_message.get;
732: END make_sentence_daily;
733:
734: /* -----------------------------------------------------------------
735: * -- Function Name: make_sentence_weekly (Private Function)
771: ,p_saturday => p_saturday);
772:
773: IF p_occurs_number IS NOT NULL THEN
774: IF p_occurs_every = 1 THEN
775: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_4');
776: fnd_message.set_token('WHICH_DAYS', l_weekdays);
777: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
778: ELSE
779: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_2');
772:
773: IF p_occurs_number IS NOT NULL THEN
774: IF p_occurs_every = 1 THEN
775: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_4');
776: fnd_message.set_token('WHICH_DAYS', l_weekdays);
777: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
778: ELSE
779: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_2');
780: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
773: IF p_occurs_number IS NOT NULL THEN
774: IF p_occurs_every = 1 THEN
775: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_4');
776: fnd_message.set_token('WHICH_DAYS', l_weekdays);
777: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
778: ELSE
779: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_2');
780: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
781: fnd_message.set_token('WHICH_DAYS', l_weekdays);
775: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_4');
776: fnd_message.set_token('WHICH_DAYS', l_weekdays);
777: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
778: ELSE
779: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_2');
780: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
781: fnd_message.set_token('WHICH_DAYS', l_weekdays);
782: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
783: END IF;
776: fnd_message.set_token('WHICH_DAYS', l_weekdays);
777: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
778: ELSE
779: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_2');
780: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
781: fnd_message.set_token('WHICH_DAYS', l_weekdays);
782: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
783: END IF;
784: ELSE
777: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
778: ELSE
779: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_2');
780: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
781: fnd_message.set_token('WHICH_DAYS', l_weekdays);
782: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
783: END IF;
784: ELSE
785: IF p_occurs_every = 1 THEN
778: ELSE
779: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_2');
780: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
781: fnd_message.set_token('WHICH_DAYS', l_weekdays);
782: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
783: END IF;
784: ELSE
785: IF p_occurs_every = 1 THEN
786: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_3');
782: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
783: END IF;
784: ELSE
785: IF p_occurs_every = 1 THEN
786: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_3');
787: fnd_message.set_token('WHICH_DAYS', l_weekdays);
788: fnd_message.set_token('END_DATE', p_end_date);
789: ELSE
790: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_1');
783: END IF;
784: ELSE
785: IF p_occurs_every = 1 THEN
786: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_3');
787: fnd_message.set_token('WHICH_DAYS', l_weekdays);
788: fnd_message.set_token('END_DATE', p_end_date);
789: ELSE
790: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_1');
791: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
784: ELSE
785: IF p_occurs_every = 1 THEN
786: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_3');
787: fnd_message.set_token('WHICH_DAYS', l_weekdays);
788: fnd_message.set_token('END_DATE', p_end_date);
789: ELSE
790: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_1');
791: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
792: fnd_message.set_token('WHICH_DAYS', l_weekdays);
786: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_3');
787: fnd_message.set_token('WHICH_DAYS', l_weekdays);
788: fnd_message.set_token('END_DATE', p_end_date);
789: ELSE
790: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_1');
791: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
792: fnd_message.set_token('WHICH_DAYS', l_weekdays);
793: fnd_message.set_token('END_DATE', p_end_date);
794: END IF;
787: fnd_message.set_token('WHICH_DAYS', l_weekdays);
788: fnd_message.set_token('END_DATE', p_end_date);
789: ELSE
790: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_1');
791: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
792: fnd_message.set_token('WHICH_DAYS', l_weekdays);
793: fnd_message.set_token('END_DATE', p_end_date);
794: END IF;
795: END IF;
788: fnd_message.set_token('END_DATE', p_end_date);
789: ELSE
790: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_1');
791: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
792: fnd_message.set_token('WHICH_DAYS', l_weekdays);
793: fnd_message.set_token('END_DATE', p_end_date);
794: END IF;
795: END IF;
796: fnd_message.set_token('TIMEZONE', p_timezone);
789: ELSE
790: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_1');
791: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
792: fnd_message.set_token('WHICH_DAYS', l_weekdays);
793: fnd_message.set_token('END_DATE', p_end_date);
794: END IF;
795: END IF;
796: fnd_message.set_token('TIMEZONE', p_timezone);
797:
792: fnd_message.set_token('WHICH_DAYS', l_weekdays);
793: fnd_message.set_token('END_DATE', p_end_date);
794: END IF;
795: END IF;
796: fnd_message.set_token('TIMEZONE', p_timezone);
797:
798: RETURN fnd_message.get;
799: END make_sentence_weekly;
800:
794: END IF;
795: END IF;
796: fnd_message.set_token('TIMEZONE', p_timezone);
797:
798: RETURN fnd_message.get;
799: END make_sentence_weekly;
800:
801: /* -----------------------------------------------------------------
802: * -- Function Name: make_sentence_monthly (Private Function)
854:
855: IF p_date_of_month IS NOT NULL THEN
856: IF p_occurs_number IS NOT NULL THEN
857: IF p_occurs_every = 1 THEN
858: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_6');
859: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
860: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
861: ELSE
862: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_2');
855: IF p_date_of_month IS NOT NULL THEN
856: IF p_occurs_number IS NOT NULL THEN
857: IF p_occurs_every = 1 THEN
858: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_6');
859: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
860: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
861: ELSE
862: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_2');
863: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
856: IF p_occurs_number IS NOT NULL THEN
857: IF p_occurs_every = 1 THEN
858: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_6');
859: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
860: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
861: ELSE
862: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_2');
863: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
864: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
858: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_6');
859: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
860: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
861: ELSE
862: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_2');
863: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
864: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
865: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
866: END IF;
859: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
860: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
861: ELSE
862: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_2');
863: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
864: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
865: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
866: END IF;
867: ELSE
860: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
861: ELSE
862: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_2');
863: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
864: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
865: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
866: END IF;
867: ELSE
868: IF p_occurs_every = 1 THEN
861: ELSE
862: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_2');
863: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
864: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
865: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
866: END IF;
867: ELSE
868: IF p_occurs_every = 1 THEN
869: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_5');
865: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
866: END IF;
867: ELSE
868: IF p_occurs_every = 1 THEN
869: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_5');
870: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
871: fnd_message.set_token('END_DATE', p_end_date);
872: ELSE
873: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_1');
866: END IF;
867: ELSE
868: IF p_occurs_every = 1 THEN
869: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_5');
870: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
871: fnd_message.set_token('END_DATE', p_end_date);
872: ELSE
873: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_1');
874: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
867: ELSE
868: IF p_occurs_every = 1 THEN
869: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_5');
870: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
871: fnd_message.set_token('END_DATE', p_end_date);
872: ELSE
873: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_1');
874: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
875: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
869: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_5');
870: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
871: fnd_message.set_token('END_DATE', p_end_date);
872: ELSE
873: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_1');
874: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
875: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
876: fnd_message.set_token('END_DATE', p_end_date);
877: END IF;
870: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
871: fnd_message.set_token('END_DATE', p_end_date);
872: ELSE
873: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_1');
874: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
875: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
876: fnd_message.set_token('END_DATE', p_end_date);
877: END IF;
878: END IF;
871: fnd_message.set_token('END_DATE', p_end_date);
872: ELSE
873: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_1');
874: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
875: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
876: fnd_message.set_token('END_DATE', p_end_date);
877: END IF;
878: END IF;
879: ELSE
872: ELSE
873: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_1');
874: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
875: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
876: fnd_message.set_token('END_DATE', p_end_date);
877: END IF;
878: END IF;
879: ELSE
880: IF p_occurs_number IS NOT NULL THEN
878: END IF;
879: ELSE
880: IF p_occurs_number IS NOT NULL THEN
881: IF p_occurs_every = 1 THEN
882: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_8');
883: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
884: fnd_message.set_token('WHICH_DAYS', l_weekdays);
885: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
886: ELSE
879: ELSE
880: IF p_occurs_number IS NOT NULL THEN
881: IF p_occurs_every = 1 THEN
882: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_8');
883: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
884: fnd_message.set_token('WHICH_DAYS', l_weekdays);
885: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
886: ELSE
887: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_4');
880: IF p_occurs_number IS NOT NULL THEN
881: IF p_occurs_every = 1 THEN
882: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_8');
883: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
884: fnd_message.set_token('WHICH_DAYS', l_weekdays);
885: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
886: ELSE
887: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_4');
888: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
881: IF p_occurs_every = 1 THEN
882: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_8');
883: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
884: fnd_message.set_token('WHICH_DAYS', l_weekdays);
885: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
886: ELSE
887: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_4');
888: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
889: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
883: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
884: fnd_message.set_token('WHICH_DAYS', l_weekdays);
885: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
886: ELSE
887: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_4');
888: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
889: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
890: fnd_message.set_token('WHICH_DAYS', l_weekdays);
891: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
884: fnd_message.set_token('WHICH_DAYS', l_weekdays);
885: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
886: ELSE
887: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_4');
888: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
889: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
890: fnd_message.set_token('WHICH_DAYS', l_weekdays);
891: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
892: END IF;
885: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
886: ELSE
887: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_4');
888: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
889: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
890: fnd_message.set_token('WHICH_DAYS', l_weekdays);
891: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
892: END IF;
893: ELSE
886: ELSE
887: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_4');
888: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
889: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
890: fnd_message.set_token('WHICH_DAYS', l_weekdays);
891: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
892: END IF;
893: ELSE
894: IF p_occurs_every = 1 THEN
887: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_4');
888: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
889: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
890: fnd_message.set_token('WHICH_DAYS', l_weekdays);
891: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
892: END IF;
893: ELSE
894: IF p_occurs_every = 1 THEN
895: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_7');
891: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
892: END IF;
893: ELSE
894: IF p_occurs_every = 1 THEN
895: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_7');
896: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
897: fnd_message.set_token('WHICH_DAYS', l_weekdays);
898: fnd_message.set_token('END_DATE', p_end_date);
899: ELSE
892: END IF;
893: ELSE
894: IF p_occurs_every = 1 THEN
895: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_7');
896: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
897: fnd_message.set_token('WHICH_DAYS', l_weekdays);
898: fnd_message.set_token('END_DATE', p_end_date);
899: ELSE
900: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_3');
893: ELSE
894: IF p_occurs_every = 1 THEN
895: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_7');
896: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
897: fnd_message.set_token('WHICH_DAYS', l_weekdays);
898: fnd_message.set_token('END_DATE', p_end_date);
899: ELSE
900: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_3');
901: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
894: IF p_occurs_every = 1 THEN
895: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_7');
896: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
897: fnd_message.set_token('WHICH_DAYS', l_weekdays);
898: fnd_message.set_token('END_DATE', p_end_date);
899: ELSE
900: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_3');
901: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
902: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
896: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
897: fnd_message.set_token('WHICH_DAYS', l_weekdays);
898: fnd_message.set_token('END_DATE', p_end_date);
899: ELSE
900: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_3');
901: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
902: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
903: fnd_message.set_token('WHICH_DAYS', l_weekdays);
904: fnd_message.set_token('END_DATE', p_end_date);
897: fnd_message.set_token('WHICH_DAYS', l_weekdays);
898: fnd_message.set_token('END_DATE', p_end_date);
899: ELSE
900: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_3');
901: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
902: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
903: fnd_message.set_token('WHICH_DAYS', l_weekdays);
904: fnd_message.set_token('END_DATE', p_end_date);
905: END IF;
898: fnd_message.set_token('END_DATE', p_end_date);
899: ELSE
900: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_3');
901: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
902: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
903: fnd_message.set_token('WHICH_DAYS', l_weekdays);
904: fnd_message.set_token('END_DATE', p_end_date);
905: END IF;
906: END IF;
899: ELSE
900: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_3');
901: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
902: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
903: fnd_message.set_token('WHICH_DAYS', l_weekdays);
904: fnd_message.set_token('END_DATE', p_end_date);
905: END IF;
906: END IF;
907: END IF;
900: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_3');
901: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
902: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
903: fnd_message.set_token('WHICH_DAYS', l_weekdays);
904: fnd_message.set_token('END_DATE', p_end_date);
905: END IF;
906: END IF;
907: END IF;
908: fnd_message.set_token('TIMEZONE', p_timezone);
904: fnd_message.set_token('END_DATE', p_end_date);
905: END IF;
906: END IF;
907: END IF;
908: fnd_message.set_token('TIMEZONE', p_timezone);
909:
910: RETURN fnd_message.get;
911: END make_sentence_monthly;
912:
906: END IF;
907: END IF;
908: fnd_message.set_token('TIMEZONE', p_timezone);
909:
910: RETURN fnd_message.get;
911: END make_sentence_monthly;
912:
913: /* -----------------------------------------------------------------
914: * -- Function Name: make_sentence_yearly (Private Function)
968:
969: IF p_date_of_month IS NOT NULL THEN
970: IF p_occurs_number IS NOT NULL THEN
971: IF p_occurs_every = 1 THEN
972: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_6');
973: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
974: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
975: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
976: ELSE
969: IF p_date_of_month IS NOT NULL THEN
970: IF p_occurs_number IS NOT NULL THEN
971: IF p_occurs_every = 1 THEN
972: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_6');
973: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
974: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
975: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
976: ELSE
977: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_2');
970: IF p_occurs_number IS NOT NULL THEN
971: IF p_occurs_every = 1 THEN
972: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_6');
973: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
974: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
975: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
976: ELSE
977: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_2');
978: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
971: IF p_occurs_every = 1 THEN
972: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_6');
973: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
974: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
975: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
976: ELSE
977: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_2');
978: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
979: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
973: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
974: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
975: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
976: ELSE
977: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_2');
978: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
979: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
980: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
981: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
974: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
975: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
976: ELSE
977: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_2');
978: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
979: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
980: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
981: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
982: END IF;
975: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
976: ELSE
977: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_2');
978: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
979: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
980: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
981: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
982: END IF;
983: ELSE
976: ELSE
977: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_2');
978: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
979: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
980: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
981: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
982: END IF;
983: ELSE
984: IF p_occurs_every = 1 THEN
977: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_2');
978: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
979: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
980: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
981: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
982: END IF;
983: ELSE
984: IF p_occurs_every = 1 THEN
985: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_5');
981: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
982: END IF;
983: ELSE
984: IF p_occurs_every = 1 THEN
985: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_5');
986: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
987: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
988: fnd_message.set_token('END_DATE', p_end_date);
989: ELSE
982: END IF;
983: ELSE
984: IF p_occurs_every = 1 THEN
985: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_5');
986: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
987: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
988: fnd_message.set_token('END_DATE', p_end_date);
989: ELSE
990: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_1');
983: ELSE
984: IF p_occurs_every = 1 THEN
985: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_5');
986: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
987: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
988: fnd_message.set_token('END_DATE', p_end_date);
989: ELSE
990: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_1');
991: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
984: IF p_occurs_every = 1 THEN
985: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_5');
986: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
987: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
988: fnd_message.set_token('END_DATE', p_end_date);
989: ELSE
990: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_1');
991: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
992: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
986: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
987: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
988: fnd_message.set_token('END_DATE', p_end_date);
989: ELSE
990: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_1');
991: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
992: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
993: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
994: fnd_message.set_token('END_DATE', p_end_date);
987: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
988: fnd_message.set_token('END_DATE', p_end_date);
989: ELSE
990: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_1');
991: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
992: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
993: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
994: fnd_message.set_token('END_DATE', p_end_date);
995: END IF;
988: fnd_message.set_token('END_DATE', p_end_date);
989: ELSE
990: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_1');
991: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
992: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
993: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
994: fnd_message.set_token('END_DATE', p_end_date);
995: END IF;
996: END IF;
989: ELSE
990: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_1');
991: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
992: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
993: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
994: fnd_message.set_token('END_DATE', p_end_date);
995: END IF;
996: END IF;
997: ELSE
990: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_1');
991: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
992: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
993: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);
994: fnd_message.set_token('END_DATE', p_end_date);
995: END IF;
996: END IF;
997: ELSE
998: IF p_occurs_number IS NOT NULL THEN
996: END IF;
997: ELSE
998: IF p_occurs_number IS NOT NULL THEN
999: IF p_occurs_every = 1 THEN
1000: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_8');
1001: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1002: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1003: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1004: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
997: ELSE
998: IF p_occurs_number IS NOT NULL THEN
999: IF p_occurs_every = 1 THEN
1000: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_8');
1001: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1002: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1003: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1004: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1005: ELSE
998: IF p_occurs_number IS NOT NULL THEN
999: IF p_occurs_every = 1 THEN
1000: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_8');
1001: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1002: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1003: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1004: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1005: ELSE
1006: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_4');
999: IF p_occurs_every = 1 THEN
1000: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_8');
1001: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1002: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1003: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1004: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1005: ELSE
1006: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_4');
1007: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1000: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_8');
1001: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1002: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1003: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1004: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1005: ELSE
1006: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_4');
1007: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1008: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1002: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1003: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1004: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1005: ELSE
1006: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_4');
1007: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1008: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1009: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1010: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1003: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1004: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1005: ELSE
1006: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_4');
1007: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1008: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1009: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1010: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1011: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1004: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1005: ELSE
1006: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_4');
1007: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1008: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1009: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1010: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1011: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1012: END IF;
1005: ELSE
1006: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_4');
1007: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1008: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1009: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1010: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1011: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1012: END IF;
1013: ELSE
1006: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_4');
1007: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1008: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1009: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1010: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1011: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1012: END IF;
1013: ELSE
1014: IF p_occurs_every = 1 THEN
1007: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1008: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1009: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1010: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1011: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1012: END IF;
1013: ELSE
1014: IF p_occurs_every = 1 THEN
1015: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_7');
1011: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);
1012: END IF;
1013: ELSE
1014: IF p_occurs_every = 1 THEN
1015: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_7');
1016: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1017: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1018: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1019: fnd_message.set_token('END_DATE', p_end_date);
1012: END IF;
1013: ELSE
1014: IF p_occurs_every = 1 THEN
1015: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_7');
1016: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1017: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1018: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1019: fnd_message.set_token('END_DATE', p_end_date);
1020: ELSE
1013: ELSE
1014: IF p_occurs_every = 1 THEN
1015: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_7');
1016: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1017: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1018: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1019: fnd_message.set_token('END_DATE', p_end_date);
1020: ELSE
1021: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_3');
1014: IF p_occurs_every = 1 THEN
1015: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_7');
1016: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1017: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1018: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1019: fnd_message.set_token('END_DATE', p_end_date);
1020: ELSE
1021: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_3');
1022: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1015: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_7');
1016: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1017: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1018: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1019: fnd_message.set_token('END_DATE', p_end_date);
1020: ELSE
1021: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_3');
1022: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1023: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1017: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1018: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1019: fnd_message.set_token('END_DATE', p_end_date);
1020: ELSE
1021: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_3');
1022: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1023: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1024: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1025: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1018: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1019: fnd_message.set_token('END_DATE', p_end_date);
1020: ELSE
1021: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_3');
1022: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1023: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1024: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1025: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1026: fnd_message.set_token('END_DATE', p_end_date);
1019: fnd_message.set_token('END_DATE', p_end_date);
1020: ELSE
1021: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_3');
1022: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1023: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1024: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1025: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1026: fnd_message.set_token('END_DATE', p_end_date);
1027: END IF;
1020: ELSE
1021: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_3');
1022: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1023: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1024: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1025: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1026: fnd_message.set_token('END_DATE', p_end_date);
1027: END IF;
1028: END IF;
1021: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_3');
1022: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1023: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1024: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1025: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1026: fnd_message.set_token('END_DATE', p_end_date);
1027: END IF;
1028: END IF;
1029: END IF;
1022: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);
1023: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);
1024: fnd_message.set_token('WHICH_DAYS', l_weekdays);
1025: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));
1026: fnd_message.set_token('END_DATE', p_end_date);
1027: END IF;
1028: END IF;
1029: END IF;
1030: fnd_message.set_token('TIMEZONE', p_timezone);
1026: fnd_message.set_token('END_DATE', p_end_date);
1027: END IF;
1028: END IF;
1029: END IF;
1030: fnd_message.set_token('TIMEZONE', p_timezone);
1031:
1032: RETURN fnd_message.get;
1033: END make_sentence_yearly;
1034:
1028: END IF;
1029: END IF;
1030: fnd_message.set_token('TIMEZONE', p_timezone);
1031:
1032: RETURN fnd_message.get;
1033: END make_sentence_yearly;
1034:
1035: /* -----------------------------------------------------------------
1036: * -- Function Name: get_repeating
1079: l_client_timezone_id := TO_NUMBER(NVL(fnd_profile.value('CLIENT_TIMEZONE_ID'),'4'));
1080:
1081:
1082: IF p_recurrence_rule_id IS NULL THEN
1083: fnd_message.set_name('JTF', 'CAC_VIEW_NO_REPEAT');
1084: RETURN fnd_message.get;
1085: END IF;
1086:
1087: OPEN c_repeating (l_client_timezone_id);
1080:
1081:
1082: IF p_recurrence_rule_id IS NULL THEN
1083: fnd_message.set_name('JTF', 'CAC_VIEW_NO_REPEAT');
1084: RETURN fnd_message.get;
1085: END IF;
1086:
1087: OPEN c_repeating (l_client_timezone_id);
1088: FETCH c_repeating INTO rec_repeating;