461: my_schedule_name := null;
462: end if;
463:
464: if (schedule_type in ('A', 'O')) then
465: fnd_message.set_name('FND', 'SCH-NO RECURRENCE');
466: a := fnd_message.get;
467: elsif schedule_type = 'P' then
468: if my_schedule_name is null then
469: select resubmit_interval, resubmit_interval_unit_code
462: end if;
463:
464: if (schedule_type in ('A', 'O')) then
465: fnd_message.set_name('FND', 'SCH-NO RECURRENCE');
466: a := fnd_message.get;
467: elsif schedule_type = 'P' then
468: if my_schedule_name is null then
469: select resubmit_interval, resubmit_interval_unit_code
470: into interval, int_unit
470: into interval, int_unit
471: from fnd_concurrent_requests
472: where request_id = req_id;
473: if date2 is null then
474: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');
475: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
476: fnd_message.set_token('UNIT_TYPE', int_unit );
477: else
478: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
471: from fnd_concurrent_requests
472: where request_id = req_id;
473: if date2 is null then
474: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');
475: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
476: fnd_message.set_token('UNIT_TYPE', int_unit );
477: else
478: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
479: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
472: where request_id = req_id;
473: if date2 is null then
474: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');
475: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
476: fnd_message.set_token('UNIT_TYPE', int_unit );
477: else
478: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
479: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
480: fnd_message.set_token('UNIT_TYPE', int_unit );
474: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');
475: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
476: fnd_message.set_token('UNIT_TYPE', int_unit );
477: else
478: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
479: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
480: fnd_message.set_token('UNIT_TYPE', int_unit );
481: fnd_message.set_token('END_DATE',to_char(date2));
482: end if;
475: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
476: fnd_message.set_token('UNIT_TYPE', int_unit );
477: else
478: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
479: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
480: fnd_message.set_token('UNIT_TYPE', int_unit );
481: fnd_message.set_token('END_DATE',to_char(date2));
482: end if;
483: else
476: fnd_message.set_token('UNIT_TYPE', int_unit );
477: else
478: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
479: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
480: fnd_message.set_token('UNIT_TYPE', int_unit );
481: fnd_message.set_token('END_DATE',to_char(date2));
482: end if;
483: else
484: fnd_message.set_name('FND','SCH-PERIODIC');
477: else
478: fnd_message.set_name('FND','SCH-PERIODIC WITH END DATE');
479: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));
480: fnd_message.set_token('UNIT_TYPE', int_unit );
481: fnd_message.set_token('END_DATE',to_char(date2));
482: end if;
483: else
484: fnd_message.set_name('FND','SCH-PERIODIC');
485: fnd_message.set_token('SCH_NAME', my_schedule_name);
480: fnd_message.set_token('UNIT_TYPE', int_unit );
481: fnd_message.set_token('END_DATE',to_char(date2));
482: end if;
483: else
484: fnd_message.set_name('FND','SCH-PERIODIC');
485: fnd_message.set_token('SCH_NAME', my_schedule_name);
486: end if;
487: a := fnd_message.get;
488: elsif schedule_type = 'S' then
481: fnd_message.set_token('END_DATE',to_char(date2));
482: end if;
483: else
484: fnd_message.set_name('FND','SCH-PERIODIC');
485: fnd_message.set_token('SCH_NAME', my_schedule_name);
486: end if;
487: a := fnd_message.get;
488: elsif schedule_type = 'S' then
489: begin -- schedule_type = 'S'
483: else
484: fnd_message.set_name('FND','SCH-PERIODIC');
485: fnd_message.set_token('SCH_NAME', my_schedule_name);
486: end if;
487: a := fnd_message.get;
488: elsif schedule_type = 'S' then
489: begin -- schedule_type = 'S'
490: -- either 39 char map or 56 char map
491: if (LENGTH(class_info) = 39) then
490: -- either 39 char map or 56 char map
491: if (LENGTH(class_info) = 39) then
492: if my_schedule_name is null then
493: if date2 is null then
494: fnd_message.set_name('FND','SCH-SPECIFIC START');
495: fnd_message.set_token('DATE',to_char(date1));
496: else
497: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');
498: fnd_message.set_token('DATE1',to_char(date1));
491: if (LENGTH(class_info) = 39) then
492: if my_schedule_name is null then
493: if date2 is null then
494: fnd_message.set_name('FND','SCH-SPECIFIC START');
495: fnd_message.set_token('DATE',to_char(date1));
496: else
497: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');
498: fnd_message.set_token('DATE1',to_char(date1));
499: fnd_message.set_token('DATE2',to_char(date2));
493: if date2 is null then
494: fnd_message.set_name('FND','SCH-SPECIFIC START');
495: fnd_message.set_token('DATE',to_char(date1));
496: else
497: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');
498: fnd_message.set_token('DATE1',to_char(date1));
499: fnd_message.set_token('DATE2',to_char(date2));
500: end if;
501: else
494: fnd_message.set_name('FND','SCH-SPECIFIC START');
495: fnd_message.set_token('DATE',to_char(date1));
496: else
497: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');
498: fnd_message.set_token('DATE1',to_char(date1));
499: fnd_message.set_token('DATE2',to_char(date2));
500: end if;
501: else
502: fnd_message.set_name('FND','SCH-SPECIFIC');
495: fnd_message.set_token('DATE',to_char(date1));
496: else
497: fnd_message.set_name('FND','SCH-SPECIFIC RANGE');
498: fnd_message.set_token('DATE1',to_char(date1));
499: fnd_message.set_token('DATE2',to_char(date2));
500: end if;
501: else
502: fnd_message.set_name('FND','SCH-SPECIFIC');
503: fnd_message.set_token('SCH_NAME', my_schedule_name);
498: fnd_message.set_token('DATE1',to_char(date1));
499: fnd_message.set_token('DATE2',to_char(date2));
500: end if;
501: else
502: fnd_message.set_name('FND','SCH-SPECIFIC');
503: fnd_message.set_token('SCH_NAME', my_schedule_name);
504: end if;
505: a := fnd_message.get || ': ';
506:
499: fnd_message.set_token('DATE2',to_char(date2));
500: end if;
501: else
502: fnd_message.set_name('FND','SCH-SPECIFIC');
503: fnd_message.set_token('SCH_NAME', my_schedule_name);
504: end if;
505: a := fnd_message.get || ': ';
506:
507: for cnt in 1..39 loop
501: else
502: fnd_message.set_name('FND','SCH-SPECIFIC');
503: fnd_message.set_token('SCH_NAME', my_schedule_name);
504: end if;
505: a := fnd_message.get || ': ';
506:
507: for cnt in 1..39 loop
508: if substr(class_info, cnt, 1) = '1' then
509: a := a || to_char(cnt) || ' ';
591: begin
592: -- both days and date are specified.. use DAD (date and day) messages
593:
594: if (date2 IS null) then
595: fnd_message.set_name('FND','SCH-ADV-START-DAD');
596: fnd_message.set_token('DATES', date_msg);
597: fnd_message.set_token('MONTHS', month_msg);
598: fnd_message.set_token('DAYS', weekday_msg);
599: else
592: -- both days and date are specified.. use DAD (date and day) messages
593:
594: if (date2 IS null) then
595: fnd_message.set_name('FND','SCH-ADV-START-DAD');
596: fnd_message.set_token('DATES', date_msg);
597: fnd_message.set_token('MONTHS', month_msg);
598: fnd_message.set_token('DAYS', weekday_msg);
599: else
600: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
593:
594: if (date2 IS null) then
595: fnd_message.set_name('FND','SCH-ADV-START-DAD');
596: fnd_message.set_token('DATES', date_msg);
597: fnd_message.set_token('MONTHS', month_msg);
598: fnd_message.set_token('DAYS', weekday_msg);
599: else
600: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
601: fnd_message.set_token('DATES', date_msg);
594: if (date2 IS null) then
595: fnd_message.set_name('FND','SCH-ADV-START-DAD');
596: fnd_message.set_token('DATES', date_msg);
597: fnd_message.set_token('MONTHS', month_msg);
598: fnd_message.set_token('DAYS', weekday_msg);
599: else
600: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
601: fnd_message.set_token('DATES', date_msg);
602: fnd_message.set_token('MONTHS', month_msg);
596: fnd_message.set_token('DATES', date_msg);
597: fnd_message.set_token('MONTHS', month_msg);
598: fnd_message.set_token('DAYS', weekday_msg);
599: else
600: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
601: fnd_message.set_token('DATES', date_msg);
602: fnd_message.set_token('MONTHS', month_msg);
603: fnd_message.set_token('DAYS', weekday_msg);
604: fnd_message.set_token('EDATE', to_char(date2));
597: fnd_message.set_token('MONTHS', month_msg);
598: fnd_message.set_token('DAYS', weekday_msg);
599: else
600: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
601: fnd_message.set_token('DATES', date_msg);
602: fnd_message.set_token('MONTHS', month_msg);
603: fnd_message.set_token('DAYS', weekday_msg);
604: fnd_message.set_token('EDATE', to_char(date2));
605: end if;
598: fnd_message.set_token('DAYS', weekday_msg);
599: else
600: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
601: fnd_message.set_token('DATES', date_msg);
602: fnd_message.set_token('MONTHS', month_msg);
603: fnd_message.set_token('DAYS', weekday_msg);
604: fnd_message.set_token('EDATE', to_char(date2));
605: end if;
606: end;
599: else
600: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
601: fnd_message.set_token('DATES', date_msg);
602: fnd_message.set_token('MONTHS', month_msg);
603: fnd_message.set_token('DAYS', weekday_msg);
604: fnd_message.set_token('EDATE', to_char(date2));
605: end if;
606: end;
607: else
600: fnd_message.set_name('FND','SCH-ADV-RANGE-DAD');
601: fnd_message.set_token('DATES', date_msg);
602: fnd_message.set_token('MONTHS', month_msg);
603: fnd_message.set_token('DAYS', weekday_msg);
604: fnd_message.set_token('EDATE', to_char(date2));
605: end if;
606: end;
607: else
608: begin
607: else
608: begin
609: -- either days and date are specified.. use DOD (date or day) messages
610: if (date2 IS null) then
611: fnd_message.set_name('FND','SCH-ADV-START-DOD');
612:
613: if (date_spec = true) then
614: fnd_message.set_token('DOD', date_msg);
615: else
610: if (date2 IS null) then
611: fnd_message.set_name('FND','SCH-ADV-START-DOD');
612:
613: if (date_spec = true) then
614: fnd_message.set_token('DOD', date_msg);
615: else
616: fnd_message.set_token('DOD', weekday_msg);
617: end if;
618:
612:
613: if (date_spec = true) then
614: fnd_message.set_token('DOD', date_msg);
615: else
616: fnd_message.set_token('DOD', weekday_msg);
617: end if;
618:
619: fnd_message.set_token('MONTHS', month_msg);
620:
615: else
616: fnd_message.set_token('DOD', weekday_msg);
617: end if;
618:
619: fnd_message.set_token('MONTHS', month_msg);
620:
621: else
622: fnd_message.set_name('FND','SCH-ADV-RANGE-DOD');
623:
618:
619: fnd_message.set_token('MONTHS', month_msg);
620:
621: else
622: fnd_message.set_name('FND','SCH-ADV-RANGE-DOD');
623:
624: if (date_spec = true) then
625: fnd_message.set_token('DOD', date_msg);
626: else
621: else
622: fnd_message.set_name('FND','SCH-ADV-RANGE-DOD');
623:
624: if (date_spec = true) then
625: fnd_message.set_token('DOD', date_msg);
626: else
627: fnd_message.set_token('DOD', weekday_msg);
628: end if;
629:
623:
624: if (date_spec = true) then
625: fnd_message.set_token('DOD', date_msg);
626: else
627: fnd_message.set_token('DOD', weekday_msg);
628: end if;
629:
630: fnd_message.set_token('MONTHS', month_msg);
631: fnd_message.set_token('EDATE', to_char(date2));
626: else
627: fnd_message.set_token('DOD', weekday_msg);
628: end if;
629:
630: fnd_message.set_token('MONTHS', month_msg);
631: fnd_message.set_token('EDATE', to_char(date2));
632:
633: end if;
634: end;
627: fnd_message.set_token('DOD', weekday_msg);
628: end if;
629:
630: fnd_message.set_token('MONTHS', month_msg);
631: fnd_message.set_token('EDATE', to_char(date2));
632:
633: end if;
634: end;
635: end if;
632:
633: end if;
634: end;
635: end if;
636: a := fnd_message.get;
637: end if; -- handle advance schedule of 56 char map
638:
639: end; -- schedule_type = 'S'
640:
638:
639: end; -- schedule_type = 'S'
640:
641: else -- must be 'X'
642: fnd_message.set_name('FND','SCH-ADVANCED');
643: fnd_message.set_token('SCH_NAME', my_schedule_name);
644: a := fnd_message.get;
645: end if;
646: return substrb(a, 1, 80);
639: end; -- schedule_type = 'S'
640:
641: else -- must be 'X'
642: fnd_message.set_name('FND','SCH-ADVANCED');
643: fnd_message.set_token('SCH_NAME', my_schedule_name);
644: a := fnd_message.get;
645: end if;
646: return substrb(a, 1, 80);
647: end build_short_schedule;
640:
641: else -- must be 'X'
642: fnd_message.set_name('FND','SCH-ADVANCED');
643: fnd_message.set_token('SCH_NAME', my_schedule_name);
644: a := fnd_message.get;
645: end if;
646: return substrb(a, 1, 80);
647: end build_short_schedule;
648: