DBA Data[Home] [Help]

APPS.FND_CONC_SSWA dependencies on FND_MESSAGE

Line 526: fnd_message.set_name('FND', 'SCH-NO RECURRENCE');

522: my_schedule_name := null;
523: end if;
524:
525: if (schedule_type in ('A', 'O')) then
526: fnd_message.set_name('FND', 'SCH-NO RECURRENCE');
527: a := fnd_message.get;
528: elsif schedule_type = 'P' then
529: if my_schedule_name is null then
530: select resubmit_interval, resubmit_interval_unit_code

Line 527: a := fnd_message.get;

523: end if;
524:
525: if (schedule_type in ('A', 'O')) then
526: fnd_message.set_name('FND', 'SCH-NO RECURRENCE');
527: a := fnd_message.get;
528: elsif schedule_type = 'P' then
529: if my_schedule_name is null then
530: select resubmit_interval, resubmit_interval_unit_code
531: into interval, int_unit

Line 535: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');

531: into interval, int_unit
532: from fnd_concurrent_requests
533: where request_id = req_id;
534: if date2 is null then
535: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');
536: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
537: fnd_message.set_token('UNIT_TYPE', int_unit );
538: else
539: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');

Line 536: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));

532: from fnd_concurrent_requests
533: where request_id = req_id;
534: if date2 is null then
535: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');
536: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
537: fnd_message.set_token('UNIT_TYPE', int_unit );
538: else
539: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
540: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));

Line 537: fnd_message.set_token('UNIT_TYPE', int_unit );

533: where request_id = req_id;
534: if date2 is null then
535: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');
536: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
537: fnd_message.set_token('UNIT_TYPE', int_unit );
538: else
539: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
540: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
541: fnd_message.set_token('UNIT_TYPE', int_unit );

Line 539: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');

535: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');
536: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
537: fnd_message.set_token('UNIT_TYPE', int_unit );
538: else
539: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
540: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
541: fnd_message.set_token('UNIT_TYPE', int_unit );
542: fnd_message.set_token('END_DATE',to_char(date2));
543: end if;

Line 540: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));

536: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
537: fnd_message.set_token('UNIT_TYPE', int_unit );
538: else
539: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
540: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
541: fnd_message.set_token('UNIT_TYPE', int_unit );
542: fnd_message.set_token('END_DATE',to_char(date2));
543: end if;
544: else

Line 541: fnd_message.set_token('UNIT_TYPE', int_unit );

537: fnd_message.set_token('UNIT_TYPE', int_unit );
538: else
539: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
540: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
541: fnd_message.set_token('UNIT_TYPE', int_unit );
542: fnd_message.set_token('END_DATE',to_char(date2));
543: end if;
544: else
545: fnd_message.set_name('FND','SCH-PERIODIC');

Line 542: fnd_message.set_token('END_DATE',to_char(date2));

538: else
539: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
540: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
541: fnd_message.set_token('UNIT_TYPE', int_unit );
542: fnd_message.set_token('END_DATE',to_char(date2));
543: end if;
544: else
545: fnd_message.set_name('FND','SCH-PERIODIC');
546: fnd_message.set_token('SCH_NAME', my_schedule_name);

Line 545: fnd_message.set_name('FND','SCH-PERIODIC');

541: fnd_message.set_token('UNIT_TYPE', int_unit );
542: fnd_message.set_token('END_DATE',to_char(date2));
543: end if;
544: else
545: fnd_message.set_name('FND','SCH-PERIODIC');
546: fnd_message.set_token('SCH_NAME', my_schedule_name);
547: end if;
548: a := fnd_message.get;
549: elsif schedule_type = 'S' then

Line 546: fnd_message.set_token('SCH_NAME', my_schedule_name);

542: fnd_message.set_token('END_DATE',to_char(date2));
543: end if;
544: else
545: fnd_message.set_name('FND','SCH-PERIODIC');
546: fnd_message.set_token('SCH_NAME', my_schedule_name);
547: end if;
548: a := fnd_message.get;
549: elsif schedule_type = 'S' then
550: begin -- schedule_type = 'S'

Line 548: a := fnd_message.get;

544: else
545: fnd_message.set_name('FND','SCH-PERIODIC');
546: fnd_message.set_token('SCH_NAME', my_schedule_name);
547: end if;
548: a := fnd_message.get;
549: elsif schedule_type = 'S' then
550: begin -- schedule_type = 'S'
551: -- either 39 char map or 56 char map
552: if (LENGTH(class_info) = 39) then

Line 555: fnd_message.set_name('FND','SCH-SPECIFIC START');

551: -- either 39 char map or 56 char map
552: if (LENGTH(class_info) = 39) then
553: if my_schedule_name is null then
554: if date2 is null then
555: fnd_message.set_name('FND','SCH-SPECIFIC START');
556: fnd_message.set_token('DATE',to_char(date1));
557: else
558: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');
559: fnd_message.set_token('DATE1',to_char(date1));

Line 556: fnd_message.set_token('DATE',to_char(date1));

552: if (LENGTH(class_info) = 39) then
553: if my_schedule_name is null then
554: if date2 is null then
555: fnd_message.set_name('FND','SCH-SPECIFIC START');
556: fnd_message.set_token('DATE',to_char(date1));
557: else
558: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');
559: fnd_message.set_token('DATE1',to_char(date1));
560: fnd_message.set_token('DATE2',to_char(date2));

Line 558: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');

554: if date2 is null then
555: fnd_message.set_name('FND','SCH-SPECIFIC START');
556: fnd_message.set_token('DATE',to_char(date1));
557: else
558: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');
559: fnd_message.set_token('DATE1',to_char(date1));
560: fnd_message.set_token('DATE2',to_char(date2));
561: end if;
562: else

Line 559: fnd_message.set_token('DATE1',to_char(date1));

555: fnd_message.set_name('FND','SCH-SPECIFIC START');
556: fnd_message.set_token('DATE',to_char(date1));
557: else
558: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');
559: fnd_message.set_token('DATE1',to_char(date1));
560: fnd_message.set_token('DATE2',to_char(date2));
561: end if;
562: else
563: fnd_message.set_name('FND','SCH-SPECIFIC');

Line 560: fnd_message.set_token('DATE2',to_char(date2));

556: fnd_message.set_token('DATE',to_char(date1));
557: else
558: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');
559: fnd_message.set_token('DATE1',to_char(date1));
560: fnd_message.set_token('DATE2',to_char(date2));
561: end if;
562: else
563: fnd_message.set_name('FND','SCH-SPECIFIC');
564: fnd_message.set_token('SCH_NAME', my_schedule_name);

Line 563: fnd_message.set_name('FND','SCH-SPECIFIC');

559: fnd_message.set_token('DATE1',to_char(date1));
560: fnd_message.set_token('DATE2',to_char(date2));
561: end if;
562: else
563: fnd_message.set_name('FND','SCH-SPECIFIC');
564: fnd_message.set_token('SCH_NAME', my_schedule_name);
565: end if;
566: a := fnd_message.get || ': ';
567:

Line 564: fnd_message.set_token('SCH_NAME', my_schedule_name);

560: fnd_message.set_token('DATE2',to_char(date2));
561: end if;
562: else
563: fnd_message.set_name('FND','SCH-SPECIFIC');
564: fnd_message.set_token('SCH_NAME', my_schedule_name);
565: end if;
566: a := fnd_message.get || ': ';
567:
568: for cnt in 1..39 loop

Line 566: a := fnd_message.get || ': ';

562: else
563: fnd_message.set_name('FND','SCH-SPECIFIC');
564: fnd_message.set_token('SCH_NAME', my_schedule_name);
565: end if;
566: a := fnd_message.get || ': ';
567:
568: for cnt in 1..39 loop
569: if substr(class_info, cnt, 1) = '1' then
570: a := a || to_char(cnt) || ' ';

Line 656: fnd_message.set_name('FND','SCH-ADV-START-DAD');

652: begin
653: -- both days and date are specified.. use DAD (date and day) messages
654:
655: if (date2 IS null) then
656: fnd_message.set_name('FND','SCH-ADV-START-DAD');
657: fnd_message.set_token('DATES', date_msg);
658: fnd_message.set_token('MONTHS', month_msg);
659: fnd_message.set_token('DAYS', weekday_msg);
660: else

Line 657: fnd_message.set_token('DATES', date_msg);

653: -- both days and date are specified.. use DAD (date and day) messages
654:
655: if (date2 IS null) then
656: fnd_message.set_name('FND','SCH-ADV-START-DAD');
657: fnd_message.set_token('DATES', date_msg);
658: fnd_message.set_token('MONTHS', month_msg);
659: fnd_message.set_token('DAYS', weekday_msg);
660: else
661: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');

Line 658: fnd_message.set_token('MONTHS', month_msg);

654:
655: if (date2 IS null) then
656: fnd_message.set_name('FND','SCH-ADV-START-DAD');
657: fnd_message.set_token('DATES', date_msg);
658: fnd_message.set_token('MONTHS', month_msg);
659: fnd_message.set_token('DAYS', weekday_msg);
660: else
661: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
662: fnd_message.set_token('DATES', date_msg);

Line 659: fnd_message.set_token('DAYS', weekday_msg);

655: if (date2 IS null) then
656: fnd_message.set_name('FND','SCH-ADV-START-DAD');
657: fnd_message.set_token('DATES', date_msg);
658: fnd_message.set_token('MONTHS', month_msg);
659: fnd_message.set_token('DAYS', weekday_msg);
660: else
661: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
662: fnd_message.set_token('DATES', date_msg);
663: fnd_message.set_token('MONTHS', month_msg);

Line 661: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');

657: fnd_message.set_token('DATES', date_msg);
658: fnd_message.set_token('MONTHS', month_msg);
659: fnd_message.set_token('DAYS', weekday_msg);
660: else
661: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
662: fnd_message.set_token('DATES', date_msg);
663: fnd_message.set_token('MONTHS', month_msg);
664: fnd_message.set_token('DAYS', weekday_msg);
665: fnd_message.set_token('EDATE', to_char(date2));

Line 662: fnd_message.set_token('DATES', date_msg);

658: fnd_message.set_token('MONTHS', month_msg);
659: fnd_message.set_token('DAYS', weekday_msg);
660: else
661: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
662: fnd_message.set_token('DATES', date_msg);
663: fnd_message.set_token('MONTHS', month_msg);
664: fnd_message.set_token('DAYS', weekday_msg);
665: fnd_message.set_token('EDATE', to_char(date2));
666: end if;

Line 663: fnd_message.set_token('MONTHS', month_msg);

659: fnd_message.set_token('DAYS', weekday_msg);
660: else
661: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
662: fnd_message.set_token('DATES', date_msg);
663: fnd_message.set_token('MONTHS', month_msg);
664: fnd_message.set_token('DAYS', weekday_msg);
665: fnd_message.set_token('EDATE', to_char(date2));
666: end if;
667: end;

Line 664: fnd_message.set_token('DAYS', weekday_msg);

660: else
661: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
662: fnd_message.set_token('DATES', date_msg);
663: fnd_message.set_token('MONTHS', month_msg);
664: fnd_message.set_token('DAYS', weekday_msg);
665: fnd_message.set_token('EDATE', to_char(date2));
666: end if;
667: end;
668: else

Line 665: fnd_message.set_token('EDATE', to_char(date2));

661: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
662: fnd_message.set_token('DATES', date_msg);
663: fnd_message.set_token('MONTHS', month_msg);
664: fnd_message.set_token('DAYS', weekday_msg);
665: fnd_message.set_token('EDATE', to_char(date2));
666: end if;
667: end;
668: else
669: begin

Line 672: fnd_message.set_name('FND','SCH-ADV-START-DOD');

668: else
669: begin
670: -- either days and date are specified.. use DOD (date or day) messages
671: if (date2 IS null) then
672: fnd_message.set_name('FND','SCH-ADV-START-DOD');
673:
674: if (date_spec = true) then
675: fnd_message.set_token('DOD', date_msg);
676: else

Line 675: fnd_message.set_token('DOD', date_msg);

671: if (date2 IS null) then
672: fnd_message.set_name('FND','SCH-ADV-START-DOD');
673:
674: if (date_spec = true) then
675: fnd_message.set_token('DOD', date_msg);
676: else
677: fnd_message.set_token('DOD', weekday_msg);
678: end if;
679:

Line 677: fnd_message.set_token('DOD', weekday_msg);

673:
674: if (date_spec = true) then
675: fnd_message.set_token('DOD', date_msg);
676: else
677: fnd_message.set_token('DOD', weekday_msg);
678: end if;
679:
680: fnd_message.set_token('MONTHS', month_msg);
681:

Line 680: fnd_message.set_token('MONTHS', month_msg);

676: else
677: fnd_message.set_token('DOD', weekday_msg);
678: end if;
679:
680: fnd_message.set_token('MONTHS', month_msg);
681:
682: else
683: fnd_message.set_name('FND','SCH-ADV-RANGE-DOD');
684:

Line 683: fnd_message.set_name('FND','SCH-ADV-RANGE-DOD');

679:
680: fnd_message.set_token('MONTHS', month_msg);
681:
682: else
683: fnd_message.set_name('FND','SCH-ADV-RANGE-DOD');
684:
685: if (date_spec = true) then
686: fnd_message.set_token('DOD', date_msg);
687: else

Line 686: fnd_message.set_token('DOD', date_msg);

682: else
683: fnd_message.set_name('FND','SCH-ADV-RANGE-DOD');
684:
685: if (date_spec = true) then
686: fnd_message.set_token('DOD', date_msg);
687: else
688: fnd_message.set_token('DOD', weekday_msg);
689: end if;
690:

Line 688: fnd_message.set_token('DOD', weekday_msg);

684:
685: if (date_spec = true) then
686: fnd_message.set_token('DOD', date_msg);
687: else
688: fnd_message.set_token('DOD', weekday_msg);
689: end if;
690:
691: fnd_message.set_token('MONTHS', month_msg);
692: fnd_message.set_token('EDATE', to_char(date2));

Line 691: fnd_message.set_token('MONTHS', month_msg);

687: else
688: fnd_message.set_token('DOD', weekday_msg);
689: end if;
690:
691: fnd_message.set_token('MONTHS', month_msg);
692: fnd_message.set_token('EDATE', to_char(date2));
693:
694: end if;
695: end;

Line 692: fnd_message.set_token('EDATE', to_char(date2));

688: fnd_message.set_token('DOD', weekday_msg);
689: end if;
690:
691: fnd_message.set_token('MONTHS', month_msg);
692: fnd_message.set_token('EDATE', to_char(date2));
693:
694: end if;
695: end;
696: end if;

Line 697: a := fnd_message.get;

693:
694: end if;
695: end;
696: end if;
697: a := fnd_message.get;
698: end if; -- handle advance schedule of 56 char map
699:
700: end; -- schedule_type = 'S'
701:

Line 703: fnd_message.set_name('FND','SCH-ADVANCED');

699:
700: end; -- schedule_type = 'S'
701:
702: else -- must be 'X'
703: fnd_message.set_name('FND','SCH-ADVANCED');
704: fnd_message.set_token('SCH_NAME', my_schedule_name);
705: a := fnd_message.get;
706: end if;
707: return substrb(a, 1, 80);

Line 704: fnd_message.set_token('SCH_NAME', my_schedule_name);

700: end; -- schedule_type = 'S'
701:
702: else -- must be 'X'
703: fnd_message.set_name('FND','SCH-ADVANCED');
704: fnd_message.set_token('SCH_NAME', my_schedule_name);
705: a := fnd_message.get;
706: end if;
707: return substrb(a, 1, 80);
708: end build_short_schedule;

Line 705: a := fnd_message.get;

701:
702: else -- must be 'X'
703: fnd_message.set_name('FND','SCH-ADVANCED');
704: fnd_message.set_token('SCH_NAME', my_schedule_name);
705: a := fnd_message.get;
706: end if;
707: return substrb(a, 1, 80);
708: end build_short_schedule;
709: