DBA Data[Home] [Help]

APPS.CAC_VIEW_ACC_DAILY_VIEW_PVT dependencies on FND_MESSAGE

Line 49: fnd_message.set_name('JTF','CAC_VIEW_APT_ALL_DAY');

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;

Line 50: l_start_time := fnd_message.get;

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:

Line 712: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_4');

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);

Line 713: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);

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);

Line 715: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_2');

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

Line 716: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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

Line 717: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);

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');

Line 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);

Line 722: fnd_message.set_token('END_DATE', p_end_date);

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);

Line 724: fnd_message.set_name('JTF', 'CAC_VIEW_DAILY_REPEAT_1');

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;

Line 725: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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);

Line 726: fnd_message.set_token('END_DATE', p_end_date);

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:

Line 729: fnd_message.set_token('TIMEZONE', p_timezone);

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:

Line 731: RETURN fnd_message.get;

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)

Line 775: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_4');

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');

Line 776: fnd_message.set_token('WHICH_DAYS', l_weekdays);

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);

Line 777: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);

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);

Line 779: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_2');

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;

Line 780: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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

Line 781: 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
785: IF p_occurs_every = 1 THEN

Line 782: 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
786: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_3');

Line 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');

Line 787: fnd_message.set_token('WHICH_DAYS', l_weekdays);

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);

Line 788: fnd_message.set_token('END_DATE', p_end_date);

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);

Line 790: fnd_message.set_name('JTF', 'CAC_VIEW_WEEKLY_REPEAT_1');

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;

Line 791: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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;

Line 792: 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;
796: fnd_message.set_token('TIMEZONE', p_timezone);

Line 793: 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);
797:

Line 796: fnd_message.set_token('TIMEZONE', p_timezone);

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:

Line 798: RETURN fnd_message.get;

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)

Line 858: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_6');

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');

Line 859: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);

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);

Line 860: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);

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);

Line 862: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_2');

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;

Line 863: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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

Line 864: 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
868: IF p_occurs_every = 1 THEN

Line 865: 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
869: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_5');

Line 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');

Line 870: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);

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);

Line 871: fnd_message.set_token('END_DATE', p_end_date);

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);

Line 873: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_1');

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;

Line 874: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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;

Line 875: 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;
879: ELSE

Line 876: 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
880: IF p_occurs_number IS NOT NULL THEN

Line 882: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_8');

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

Line 883: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);

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');

Line 884: fnd_message.set_token('WHICH_DAYS', l_weekdays);

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);

Line 885: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);

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);

Line 887: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_4');

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);

Line 888: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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;

Line 889: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);

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

Line 890: fnd_message.set_token('WHICH_DAYS', l_weekdays);

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

Line 891: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);

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');

Line 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

Line 896: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);

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');

Line 897: fnd_message.set_token('WHICH_DAYS', l_weekdays);

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);

Line 898: fnd_message.set_token('END_DATE', p_end_date);

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);

Line 900: fnd_message.set_name('JTF', 'CAC_VIEW_MONTHLY_REPEAT_3');

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);

Line 901: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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;

Line 902: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);

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;

Line 903: fnd_message.set_token('WHICH_DAYS', l_weekdays);

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;

Line 904: fnd_message.set_token('END_DATE', p_end_date);

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);

Line 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:

Line 910: RETURN fnd_message.get;

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)

Line 972: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_6');

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

Line 973: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));

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');

Line 974: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);

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);

Line 975: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);

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));

Line 977: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_2');

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);

Line 978: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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;

Line 979: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_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;
983: ELSE

Line 980: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);

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

Line 981: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);

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');

Line 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

Line 986: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));

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');

Line 987: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);

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);

Line 988: fnd_message.set_token('END_DATE', p_end_date);

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));

Line 990: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_1');

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);

Line 991: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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;

Line 992: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_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;
996: END IF;

Line 993: fnd_message.set_token('DATE_OF_MONTH', p_date_of_month);

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

Line 994: fnd_message.set_token('END_DATE', p_end_date);

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

Line 1000: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_8');

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);

Line 1001: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);

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

Line 1002: fnd_message.set_token('WHICH_DAYS', l_weekdays);

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');

Line 1003: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));

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);

Line 1004: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);

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);

Line 1006: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_4');

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));

Line 1007: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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);

Line 1008: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);

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;

Line 1009: fnd_message.set_token('WHICH_DAYS', l_weekdays);

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

Line 1010: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));

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

Line 1011: fnd_message.set_token('OCCURS_NUMBER', p_occurs_number);

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');

Line 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);

Line 1016: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);

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

Line 1017: fnd_message.set_token('WHICH_DAYS', l_weekdays);

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');

Line 1018: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));

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);

Line 1019: fnd_message.set_token('END_DATE', p_end_date);

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);

Line 1021: fnd_message.set_name('JTF', 'CAC_VIEW_YEARLY_REPEAT_3');

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));

Line 1022: fnd_message.set_token('OCCURS_EVERY', p_occurs_every);

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);

Line 1023: fnd_message.set_token('OCCURS_WHICH', l_occurs_which);

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;

Line 1024: fnd_message.set_token('WHICH_DAYS', l_weekdays);

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;

Line 1025: fnd_message.set_token('OCCURS_MONTH', get_occurs_month(p_occurs_month));

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;

Line 1026: fnd_message.set_token('END_DATE', p_end_date);

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);

Line 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:

Line 1032: RETURN fnd_message.get;

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

Line 1083: fnd_message.set_name('JTF', 'CAC_VIEW_NO_REPEAT');

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);

Line 1084: RETURN fnd_message.get;

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;