DBA Data[Home] [Help]

APPS.BEN_XCC_BUS dependencies on FND_MESSAGE

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

98: close csr_sec_grp;
99: --
100: -- The primary key is invalid therefore we must error
101: --
102: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
103: fnd_message.raise_error;
104: --
105: end if;
106: close csr_sec_grp;

Line 103: fnd_message.raise_error;

99: --
100: -- The primary key is invalid therefore we must error
101: --
102: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
103: fnd_message.raise_error;
104: --
105: end if;
106: close csr_sec_grp;
107: --

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

315: p_effective_date => p_effective_date) then
316: --
317: -- raise error as does not exist as lookup
318: --
319: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
320: fnd_message.set_token('FIELD','p_oper_cd');
321: fnd_message.set_token('TYPE','OPERATOR');
322: fnd_message.raise_error;
323: --

Line 320: fnd_message.set_token('FIELD','p_oper_cd');

316: --
317: -- raise error as does not exist as lookup
318: --
319: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
320: fnd_message.set_token('FIELD','p_oper_cd');
321: fnd_message.set_token('TYPE','OPERATOR');
322: fnd_message.raise_error;
323: --
324: end if;

Line 321: fnd_message.set_token('TYPE','OPERATOR');

317: -- raise error as does not exist as lookup
318: --
319: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
320: fnd_message.set_token('FIELD','p_oper_cd');
321: fnd_message.set_token('TYPE','OPERATOR');
322: fnd_message.raise_error;
323: --
324: end if;
325: else

Line 322: fnd_message.raise_error;

318: --
319: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
320: fnd_message.set_token('FIELD','p_oper_cd');
321: fnd_message.set_token('TYPE','OPERATOR');
322: fnd_message.raise_error;
323: --
324: end if;
325: else
326: /* BG is null, so alternative call is required */

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

330: p_effective_date => p_effective_date) then
331: --
332: -- raise error as does not exist as lookup
333: --
334: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
335: fnd_message.set_token('FIELD','p_oper_cd');
336: fnd_message.set_token('TYPE','OPERATOR');
337: fnd_message.raise_error;
338: --

Line 335: fnd_message.set_token('FIELD','p_oper_cd');

331: --
332: -- raise error as does not exist as lookup
333: --
334: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
335: fnd_message.set_token('FIELD','p_oper_cd');
336: fnd_message.set_token('TYPE','OPERATOR');
337: fnd_message.raise_error;
338: --
339: end if;

Line 336: fnd_message.set_token('TYPE','OPERATOR');

332: -- raise error as does not exist as lookup
333: --
334: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
335: fnd_message.set_token('FIELD','p_oper_cd');
336: fnd_message.set_token('TYPE','OPERATOR');
337: fnd_message.raise_error;
338: --
339: end if;
340: end if;

Line 337: fnd_message.raise_error;

333: --
334: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
335: fnd_message.set_token('FIELD','p_oper_cd');
336: fnd_message.set_token('TYPE','OPERATOR');
337: fnd_message.raise_error;
338: --
339: end if;
340: end if;
341: --

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

407: p_effective_date => p_effective_date) then
408: --
409: -- raise error as does not exist as lookup
410: --
411: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
412: fnd_message.set_token('FIELD','p_crit_typ_cd');
413: fnd_message.set_token('TYPE','BEN_EXT_CRIT_TYP');
414: fnd_message.raise_error;
415: --

Line 412: fnd_message.set_token('FIELD','p_crit_typ_cd');

408: --
409: -- raise error as does not exist as lookup
410: --
411: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
412: fnd_message.set_token('FIELD','p_crit_typ_cd');
413: fnd_message.set_token('TYPE','BEN_EXT_CRIT_TYP');
414: fnd_message.raise_error;
415: --
416: end if;

Line 413: fnd_message.set_token('TYPE','BEN_EXT_CRIT_TYP');

409: -- raise error as does not exist as lookup
410: --
411: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
412: fnd_message.set_token('FIELD','p_crit_typ_cd');
413: fnd_message.set_token('TYPE','BEN_EXT_CRIT_TYP');
414: fnd_message.raise_error;
415: --
416: end if;
417: else

Line 414: fnd_message.raise_error;

410: --
411: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
412: fnd_message.set_token('FIELD','p_crit_typ_cd');
413: fnd_message.set_token('TYPE','BEN_EXT_CRIT_TYP');
414: fnd_message.raise_error;
415: --
416: end if;
417: else
418: /* BG is null, so alternative call is required */

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

426: p_effective_date => p_effective_date) then
427: --
428: -- raise error as does not exist as lookup
429: --
430: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
431: fnd_message.set_token('FIELD','p_crit_typ_cd');
432: fnd_message.set_token('TYPE','BEN_EXT_CRIT_TYP');
433: fnd_message.raise_error;
434: --

Line 431: fnd_message.set_token('FIELD','p_crit_typ_cd');

427: --
428: -- raise error as does not exist as lookup
429: --
430: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
431: fnd_message.set_token('FIELD','p_crit_typ_cd');
432: fnd_message.set_token('TYPE','BEN_EXT_CRIT_TYP');
433: fnd_message.raise_error;
434: --
435: end if;

Line 432: fnd_message.set_token('TYPE','BEN_EXT_CRIT_TYP');

428: -- raise error as does not exist as lookup
429: --
430: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
431: fnd_message.set_token('FIELD','p_crit_typ_cd');
432: fnd_message.set_token('TYPE','BEN_EXT_CRIT_TYP');
433: fnd_message.raise_error;
434: --
435: end if;
436: end if;

Line 433: fnd_message.raise_error;

429: --
430: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
431: fnd_message.set_token('FIELD','p_crit_typ_cd');
432: fnd_message.set_token('TYPE','BEN_EXT_CRIT_TYP');
433: fnd_message.raise_error;
434: --
435: end if;
436: end if;
437: --

Line 503: fnd_message.set_name('BEN','BEN_92173_CRIT_DT_OPER_EQ_BET');

499: --
500: --
501: if p_crit_typ_cd = 'CAD' or p_crit_typ_cd = 'CED' then
502: if p_oper_cd <> 'EQ' and p_oper_cd <> 'BE' then
503: fnd_message.set_name('BEN','BEN_92173_CRIT_DT_OPER_EQ_BET');
504: fnd_message.raise_error;
505: end if;
506: --
507: end if;

Line 504: fnd_message.raise_error;

500: --
501: if p_crit_typ_cd = 'CAD' or p_crit_typ_cd = 'CED' then
502: if p_oper_cd <> 'EQ' and p_oper_cd <> 'BE' then
503: fnd_message.set_name('BEN','BEN_92173_CRIT_DT_OPER_EQ_BET');
504: fnd_message.raise_error;
505: end if;
506: --
507: end if;
508: --

Line 593: fnd_message.set_name('BEN','BEN_92174_CRIT_CHG_OPER_EQ_NEQ');

589: --
590: --
591: if p_crit_typ_cd in ( 'CCE' , 'CPE') then
592: if p_oper_cd <> 'EQ' and p_oper_cd <> 'NE' then
593: fnd_message.set_name('BEN','BEN_92174_CRIT_CHG_OPER_EQ_NEQ');
594: fnd_message.raise_error;
595: end if;
596: --
597: end if;

Line 594: fnd_message.raise_error;

590: --
591: if p_crit_typ_cd in ( 'CCE' , 'CPE') then
592: if p_oper_cd <> 'EQ' and p_oper_cd <> 'NE' then
593: fnd_message.set_name('BEN','BEN_92174_CRIT_CHG_OPER_EQ_NEQ');
594: fnd_message.raise_error;
595: end if;
596: --
597: end if;
598:

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

602: open c1 ;
603: fetch c1 into l_dummy ;
604: if c1%notfound then
605: close c1 ;
606: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
607: fnd_message.set_token('FIELD','Value 1');
608: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
609: fnd_message.raise_error;
610: end if ;

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

603: fetch c1 into l_dummy ;
604: if c1%notfound then
605: close c1 ;
606: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
607: fnd_message.set_token('FIELD','Value 1');
608: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
609: fnd_message.raise_error;
610: end if ;
611: close c1 ;

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

604: if c1%notfound then
605: close c1 ;
606: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
607: fnd_message.set_token('FIELD','Value 1');
608: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
609: fnd_message.raise_error;
610: end if ;
611: close c1 ;
612: end if ;

Line 609: fnd_message.raise_error;

605: close c1 ;
606: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
607: fnd_message.set_token('FIELD','Value 1');
608: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
609: fnd_message.raise_error;
610: end if ;
611: close c1 ;
612: end if ;
613:

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

616: open c2 ;
617: fetch c2 into l_dummy ;
618: if c2%notfound then
619: close c2 ;
620: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
621: fnd_message.set_token('FIELD','Value 1');
622: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
623: fnd_message.raise_error;
624: end if ;

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

617: fetch c2 into l_dummy ;
618: if c2%notfound then
619: close c2 ;
620: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
621: fnd_message.set_token('FIELD','Value 1');
622: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
623: fnd_message.raise_error;
624: end if ;
625: close c2 ;

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

618: if c2%notfound then
619: close c2 ;
620: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
621: fnd_message.set_token('FIELD','Value 1');
622: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
623: fnd_message.raise_error;
624: end if ;
625: close c2 ;
626: end if ;

Line 623: fnd_message.raise_error;

619: close c2 ;
620: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
621: fnd_message.set_token('FIELD','Value 1');
622: fnd_message.set_token('TYPE','BEN_EXT_CHG_EVT');
623: fnd_message.raise_error;
624: end if ;
625: close c2 ;
626: end if ;
627: --

Line 695: fnd_message.set_name('BEN','BEN_92175_OPER_BET_VAL_NULL');

691: --
692: --
693: if p_oper_cd = 'BE' then
694: if p_val_1 is null or p_val_2 is null then
695: fnd_message.set_name('BEN','BEN_92175_OPER_BET_VAL_NULL');
696: fnd_message.raise_error;
697: end if;
698: --
699: end if;

Line 696: fnd_message.raise_error;

692: --
693: if p_oper_cd = 'BE' then
694: if p_val_1 is null or p_val_2 is null then
695: fnd_message.set_name('BEN','BEN_92175_OPER_BET_VAL_NULL');
696: fnd_message.raise_error;
697: end if;
698: --
699: end if;
700: --

Line 768: fnd_message.set_name('BEN','BEN_92176_OPER_EQ_NEQ_VAL');

764: --
765: --
766: if p_oper_cd = 'EQ' or p_oper_cd = 'NE' then
767: if p_val_1 is null or p_val_2 is not null then
768: fnd_message.set_name('BEN','BEN_92176_OPER_EQ_NEQ_VAL');
769: fnd_message.raise_error;
770: end if;
771: --
772: end if;

Line 769: fnd_message.raise_error;

765: --
766: if p_oper_cd = 'EQ' or p_oper_cd = 'NE' then
767: if p_val_1 is null or p_val_2 is not null then
768: fnd_message.set_name('BEN','BEN_92176_OPER_EQ_NEQ_VAL');
769: fnd_message.raise_error;
770: end if;
771: --
772: end if;
773: --

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

992: close csr_leg_code;
993: --
994: -- The primary key is invalid therefore we must error
995: --
996: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
997: fnd_message.raise_error;
998: --
999: end if;
1000: --

Line 997: fnd_message.raise_error;

993: --
994: -- The primary key is invalid therefore we must error
995: --
996: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
997: fnd_message.raise_error;
998: --
999: end if;
1000: --
1001: close csr_leg_code;