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;
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: --
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: --
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;
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
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 */
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: --
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;
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;
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: --
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: --
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;
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
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 */
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: --
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;
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;
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: --
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;
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: --
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;
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:
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 ;
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 ;
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 ;
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:
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 ;
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 ;
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 ;
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: --
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;
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: --
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;
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: --
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: --
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;