DBA Data[Home] [Help]

APPS.BEN_XIC_BUS dependencies on FND_MESSAGE

Line 159: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

155: close csr_sec_grp;
156: --
157: -- The primary key is invalid therefore we must error
158: --
159: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
160: fnd_message.raise_error;
161: --
162: end if;
163: close csr_sec_grp;

Line 160: fnd_message.raise_error;

156: --
157: -- The primary key is invalid therefore we must error
158: --
159: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
160: fnd_message.raise_error;
161: --
162: end if;
163: close csr_sec_grp;
164: --

Line 472: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

468: --
469: -- raise error as does not exist as lookup
470: --
471:
472: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
473: -- Commented for Bug 2493525
474: /*
475: fnd_message.set_token('FIELD','p_chg_evt_cd');
476: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

Line 475: fnd_message.set_token('FIELD','p_chg_evt_cd');

471:
472: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
473: -- Commented for Bug 2493525
474: /*
475: fnd_message.set_token('FIELD','p_chg_evt_cd');
476: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
477: */
478: fnd_message.set_token('VALUE',p_chg_evt_cd);
479: fnd_message.set_token('FIELD','Value');

Line 476: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

472: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
473: -- Commented for Bug 2493525
474: /*
475: fnd_message.set_token('FIELD','p_chg_evt_cd');
476: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
477: */
478: fnd_message.set_token('VALUE',p_chg_evt_cd);
479: fnd_message.set_token('FIELD','Value');
480: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

Line 478: fnd_message.set_token('VALUE',p_chg_evt_cd);

474: /*
475: fnd_message.set_token('FIELD','p_chg_evt_cd');
476: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
477: */
478: fnd_message.set_token('VALUE',p_chg_evt_cd);
479: fnd_message.set_token('FIELD','Value');
480: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
481: -- End of Bug 2493525
482:

Line 479: fnd_message.set_token('FIELD','Value');

475: fnd_message.set_token('FIELD','p_chg_evt_cd');
476: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
477: */
478: fnd_message.set_token('VALUE',p_chg_evt_cd);
479: fnd_message.set_token('FIELD','Value');
480: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
481: -- End of Bug 2493525
482:
483: fnd_message.raise_error;

Line 480: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

476: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
477: */
478: fnd_message.set_token('VALUE',p_chg_evt_cd);
479: fnd_message.set_token('FIELD','Value');
480: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
481: -- End of Bug 2493525
482:
483: fnd_message.raise_error;
484: --

Line 483: fnd_message.raise_error;

479: fnd_message.set_token('FIELD','Value');
480: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
481: -- End of Bug 2493525
482:
483: fnd_message.raise_error;
484: --
485: end if;
486: --
487: else

Line 496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

492: --
493: -- raise error as does not exist as lookup
494: --
495:
496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
497: -- Commented for Bug 2493525
498: /*
499: fnd_message.set_token('FIELD','p_chg_evt_cd');
500: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

Line 499: fnd_message.set_token('FIELD','p_chg_evt_cd');

495:
496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
497: -- Commented for Bug 2493525
498: /*
499: fnd_message.set_token('FIELD','p_chg_evt_cd');
500: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
501: */
502: fnd_message.set_token('VALUE',p_chg_evt_cd);
503: fnd_message.set_token('FIELD','Value');

Line 500: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
497: -- Commented for Bug 2493525
498: /*
499: fnd_message.set_token('FIELD','p_chg_evt_cd');
500: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
501: */
502: fnd_message.set_token('VALUE',p_chg_evt_cd);
503: fnd_message.set_token('FIELD','Value');
504: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

Line 502: fnd_message.set_token('VALUE',p_chg_evt_cd);

498: /*
499: fnd_message.set_token('FIELD','p_chg_evt_cd');
500: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
501: */
502: fnd_message.set_token('VALUE',p_chg_evt_cd);
503: fnd_message.set_token('FIELD','Value');
504: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
505: -- End of Bug 2493525
506: fnd_message.raise_error;

Line 503: fnd_message.set_token('FIELD','Value');

499: fnd_message.set_token('FIELD','p_chg_evt_cd');
500: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
501: */
502: fnd_message.set_token('VALUE',p_chg_evt_cd);
503: fnd_message.set_token('FIELD','Value');
504: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
505: -- End of Bug 2493525
506: fnd_message.raise_error;
507: --

Line 504: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

500: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
501: */
502: fnd_message.set_token('VALUE',p_chg_evt_cd);
503: fnd_message.set_token('FIELD','Value');
504: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
505: -- End of Bug 2493525
506: fnd_message.raise_error;
507: --
508: end if;

Line 506: fnd_message.raise_error;

502: fnd_message.set_token('VALUE',p_chg_evt_cd);
503: fnd_message.set_token('FIELD','Value');
504: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
505: -- End of Bug 2493525
506: fnd_message.raise_error;
507: --
508: end if;
509: --
510: end if;

Line 518: fnd_message.set_token('VALUE',p_chg_evt_cd);

514: open c3 ;
515: fetch c3 into l_dummy ;
516: if c3%notfound then
517: close c3 ;
518: fnd_message.set_token('VALUE',p_chg_evt_cd);
519: fnd_message.set_token('FIELD','Value');
520: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
521: end if ;
522: close c3 ;

Line 519: fnd_message.set_token('FIELD','Value');

515: fetch c3 into l_dummy ;
516: if c3%notfound then
517: close c3 ;
518: fnd_message.set_token('VALUE',p_chg_evt_cd);
519: fnd_message.set_token('FIELD','Value');
520: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
521: end if ;
522: close c3 ;
523:

Line 520: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');

516: if c3%notfound then
517: close c3 ;
518: fnd_message.set_token('VALUE',p_chg_evt_cd);
519: fnd_message.set_token('FIELD','Value');
520: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
521: end if ;
522: close c3 ;
523:
524: end if ;

Line 530: fnd_message.set_name('BEN','BEN_91869_CHG_EVT_NULL');

526: /*if p_ext_rcd_in_file_id is not null then
527: for crec in c1 loop
528: if (p_chg_evt_cd is null and crec.sprs_cd= 'C') or
529: (p_chg_evt_cd is not null and crec.sprs_cd='A') then
530: fnd_message.set_name('BEN','BEN_91869_CHG_EVT_NULL');
531: fnd_message.raise_error;
532: end if;
533: end loop;
534: end if;

Line 531: fnd_message.raise_error;

527: for crec in c1 loop
528: if (p_chg_evt_cd is null and crec.sprs_cd= 'C') or
529: (p_chg_evt_cd is not null and crec.sprs_cd='A') then
530: fnd_message.set_name('BEN','BEN_91869_CHG_EVT_NULL');
531: fnd_message.raise_error;
532: end if;
533: end loop;
534: end if;
535:

Line 540: fnd_message.set_name('BEN','BEN_91869_CHG_EVT_NULL');

536: if p_ext_data_elmt_in_rcd_id is not null then
537: for crec in c2 loop
538: if (p_chg_evt_cd is null and crec.sprs_cd= 'C') or
539: (p_chg_evt_cd is not null and crec.sprs_cd='A') then
540: fnd_message.set_name('BEN','BEN_91869_CHG_EVT_NULL');
541: fnd_message.raise_error;
542: end if;
543: end loop;
544: end if;*/

Line 541: fnd_message.raise_error;

537: for crec in c2 loop
538: if (p_chg_evt_cd is null and crec.sprs_cd= 'C') or
539: (p_chg_evt_cd is not null and crec.sprs_cd='A') then
540: fnd_message.set_name('BEN','BEN_91869_CHG_EVT_NULL');
541: fnd_message.raise_error;
542: end if;
543: end loop;
544: end if;*/
545: end if;

Line 589: fnd_message.set_name('BEN','BEN_91912_EXT_VAL1_NOT_UNIQUE');

585: open c1 ;
586: fetch c1 into l_dummy ;
587: if c1%found then
588: close c1 ;
589: fnd_message.set_name('BEN','BEN_91912_EXT_VAL1_NOT_UNIQUE');
590: fnd_message.raise_error;
591: end if ;
592: close c1 ;
593:

Line 590: fnd_message.raise_error;

586: fetch c1 into l_dummy ;
587: if c1%found then
588: close c1 ;
589: fnd_message.set_name('BEN','BEN_91912_EXT_VAL1_NOT_UNIQUE');
590: fnd_message.raise_error;
591: end if ;
592: close c1 ;
593:
594: end if ;

Line 601: fnd_message.set_name('BEN','BEN_91912_EXT_VAL1_NOT_UNIQUE');

597: open c2 ;
598: fetch c2 into l_dummy ;
599: if c2%found then
600: close c2 ;
601: fnd_message.set_name('BEN','BEN_91912_EXT_VAL1_NOT_UNIQUE');
602: fnd_message.raise_error;
603:
604: end if ;
605: close c2 ;

Line 602: fnd_message.raise_error;

598: fetch c2 into l_dummy ;
599: if c2%found then
600: close c2 ;
601: fnd_message.set_name('BEN','BEN_91912_EXT_VAL1_NOT_UNIQUE');
602: fnd_message.raise_error;
603:
604: end if ;
605: close c2 ;
606: end if ;

Line 839: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

835: close csr_leg_code;
836: --
837: -- The primary key is invalid therefore we must error
838: --
839: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
840: fnd_message.raise_error;
841: --
842: end if;
843:

Line 840: fnd_message.raise_error;

836: --
837: -- The primary key is invalid therefore we must error
838: --
839: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
840: fnd_message.raise_error;
841: --
842: end if;
843:
844: l_legislation_code := hr_api.return_legislation_code(l_business_group_id) ;