DBA Data[Home] [Help]

APPS.FND_CONC_SSWA dependencies on FND_MESSAGE

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

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

Line 466: a := fnd_message.get;

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

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

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

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

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

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

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

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

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;

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

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

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

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

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

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

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

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

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

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'

Line 487: a := fnd_message.get;

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

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

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

Line 495: fnd_message.set_token('DATE',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));

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

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

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

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

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

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

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

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:

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

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

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

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

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

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

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

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

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

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

Line 598: fnd_message.set_token('DAYS', weekday_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);

Line 600: fnd_message.set_name('FND','SCH-ADV-RANGE-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);
603: fnd_message.set_token('DAYS', weekday_msg);
604: fnd_message.set_token('EDATE', to_char(date2));

Line 601: 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));
605: end if;

Line 602: 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;
606: end;

Line 603: 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;
607: else

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

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

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

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

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

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:

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

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:

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

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:

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

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

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

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:

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

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

Line 630: fnd_message.set_token('MONTHS', month_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));
632:
633: end if;
634: end;

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

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;

Line 636: a := fnd_message.get;

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:

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

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

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

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;

Line 644: a := fnd_message.get;

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: