47: close csr_leg_code;
48: --
49: -- The primary key is invalid therefore we must error
50: --
51: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
52: fnd_message.raise_error;
53: --
54: end if;
55: --
48: --
49: -- The primary key is invalid therefore we must error
50: --
51: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
52: fnd_message.raise_error;
53: --
54: end if;
55: --
56: close csr_leg_code;
203: fetch c1 into l_dummy;
204: if c1%found then
205: --
206: close c1;
207: fnd_message.set_name('BEN','BEN_92124_CLP_SEQ_NOT_UNIQUE');
208: fnd_message.raise_error;
209: --
210: end if;
211: --
204: if c1%found then
205: --
206: close c1;
207: fnd_message.set_name('BEN','BEN_92124_CLP_SEQ_NOT_UNIQUE');
208: fnd_message.raise_error;
209: --
210: end if;
211: --
212: close c1;
261: p_object_version_number => p_object_version_number);
262: --
263: if p_ler1_id is null then
264: --
265: fnd_message.set_name('BEN','BEN_92125_PRMRY_LER_ID');
266: fnd_message.raise_error;
267: --
268: end if;
269: --
262: --
263: if p_ler1_id is null then
264: --
265: fnd_message.set_name('BEN','BEN_92125_PRMRY_LER_ID');
266: fnd_message.raise_error;
267: --
268: end if;
269: --
270: hr_utility.set_location('Leaving:'||l_proc, 10);
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: if p_eval_ler_id is null then
313: --
314: fnd_message.set_name('BEN','BEN_92126_EVAL_LER_ID');
315: fnd_message.raise_error;
316: --
317: end if;
318: --
311: --
312: if p_eval_ler_id is null then
313: --
314: fnd_message.set_name('BEN','BEN_92126_EVAL_LER_ID');
315: fnd_message.raise_error;
316: --
317: end if;
318: --
319: hr_utility.set_location('Leaving:'||l_proc, 10);
359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: if nvl(p_tlrnc_dys_num,0) < 0 then
362: --
363: fnd_message.set_name('BEN','BEN_92127_TLRNC_DYS_NUM');
364: fnd_message.raise_error;
365: --
366: end if;
367: --
360: --
361: if nvl(p_tlrnc_dys_num,0) < 0 then
362: --
363: fnd_message.set_name('BEN','BEN_92127_TLRNC_DYS_NUM');
364: fnd_message.raise_error;
365: --
366: end if;
367: --
368: hr_utility.set_location('Leaving:'||l_proc, 10);
593: --
594: -- We have an encapsulation problem on either life events or boolean
595: -- codes. This must be fixed as otherwise we can not parse the
596: --
597: fnd_message.set_name('BEN','BEN_92140_LER_BOOL_SEQ');
598: fnd_message.raise_error;
599: --
600: end if;
601: --
594: -- We have an encapsulation problem on either life events or boolean
595: -- codes. This must be fixed as otherwise we can not parse the
596: --
597: fnd_message.set_name('BEN','BEN_92140_LER_BOOL_SEQ');
598: fnd_message.raise_error;
599: --
600: end if;
601: --
602: end if;
677: p_effective_date => p_effective_date) then
678: --
679: -- raise error as does not exist as lookup
680: --
681: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
682: fnd_message.set_token('FIELD','p_bool1_cd');
683: fnd_message.set_token('TYPE','BEN_BOOL');
684: fnd_message.raise_error;
685: --
678: --
679: -- raise error as does not exist as lookup
680: --
681: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
682: fnd_message.set_token('FIELD','p_bool1_cd');
683: fnd_message.set_token('TYPE','BEN_BOOL');
684: fnd_message.raise_error;
685: --
686: end if;
679: -- raise error as does not exist as lookup
680: --
681: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
682: fnd_message.set_token('FIELD','p_bool1_cd');
683: fnd_message.set_token('TYPE','BEN_BOOL');
684: fnd_message.raise_error;
685: --
686: end if;
687: --
680: --
681: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
682: fnd_message.set_token('FIELD','p_bool1_cd');
683: fnd_message.set_token('TYPE','BEN_BOOL');
684: fnd_message.raise_error;
685: --
686: end if;
687: --
688: end if;
701: p_effective_date => p_effective_date) then
702: --
703: -- raise error as does not exist as lookup
704: --
705: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
706: fnd_message.set_token('FIELD','p_bool2_cd');
707: fnd_message.set_token('TYPE','BEN_BOOL');
708: fnd_message.raise_error;
709: --
702: --
703: -- raise error as does not exist as lookup
704: --
705: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
706: fnd_message.set_token('FIELD','p_bool2_cd');
707: fnd_message.set_token('TYPE','BEN_BOOL');
708: fnd_message.raise_error;
709: --
710: end if;
703: -- raise error as does not exist as lookup
704: --
705: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
706: fnd_message.set_token('FIELD','p_bool2_cd');
707: fnd_message.set_token('TYPE','BEN_BOOL');
708: fnd_message.raise_error;
709: --
710: end if;
711: --
704: --
705: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
706: fnd_message.set_token('FIELD','p_bool2_cd');
707: fnd_message.set_token('TYPE','BEN_BOOL');
708: fnd_message.raise_error;
709: --
710: end if;
711: --
712: end if;
725: p_effective_date => p_effective_date) then
726: --
727: -- raise error as does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_bool3_cd');
731: fnd_message.set_token('TYPE','BEN_BOOL');
732: fnd_message.raise_error;
733: --
726: --
727: -- raise error as does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_bool3_cd');
731: fnd_message.set_token('TYPE','BEN_BOOL');
732: fnd_message.raise_error;
733: --
734: end if;
727: -- raise error as does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_bool3_cd');
731: fnd_message.set_token('TYPE','BEN_BOOL');
732: fnd_message.raise_error;
733: --
734: end if;
735: --
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD','p_bool3_cd');
731: fnd_message.set_token('TYPE','BEN_BOOL');
732: fnd_message.raise_error;
733: --
734: end if;
735: --
736: end if;
749: p_effective_date => p_effective_date) then
750: --
751: -- raise error as does not exist as lookup
752: --
753: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
754: fnd_message.set_token('FIELD','p_bool4_cd');
755: fnd_message.set_token('TYPE','BEN_BOOL');
756: fnd_message.raise_error;
757: --
750: --
751: -- raise error as does not exist as lookup
752: --
753: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
754: fnd_message.set_token('FIELD','p_bool4_cd');
755: fnd_message.set_token('TYPE','BEN_BOOL');
756: fnd_message.raise_error;
757: --
758: end if;
751: -- raise error as does not exist as lookup
752: --
753: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
754: fnd_message.set_token('FIELD','p_bool4_cd');
755: fnd_message.set_token('TYPE','BEN_BOOL');
756: fnd_message.raise_error;
757: --
758: end if;
759: --
752: --
753: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
754: fnd_message.set_token('FIELD','p_bool4_cd');
755: fnd_message.set_token('TYPE','BEN_BOOL');
756: fnd_message.raise_error;
757: --
758: end if;
759: --
760: end if;
773: p_effective_date => p_effective_date) then
774: --
775: -- raise error as does not exist as lookup
776: --
777: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
778: fnd_message.set_token('FIELD','p_bool5_cd');
779: fnd_message.set_token('TYPE','BEN_BOOL');
780: fnd_message.raise_error;
781: --
774: --
775: -- raise error as does not exist as lookup
776: --
777: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
778: fnd_message.set_token('FIELD','p_bool5_cd');
779: fnd_message.set_token('TYPE','BEN_BOOL');
780: fnd_message.raise_error;
781: --
782: end if;
775: -- raise error as does not exist as lookup
776: --
777: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
778: fnd_message.set_token('FIELD','p_bool5_cd');
779: fnd_message.set_token('TYPE','BEN_BOOL');
780: fnd_message.raise_error;
781: --
782: end if;
783: --
776: --
777: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
778: fnd_message.set_token('FIELD','p_bool5_cd');
779: fnd_message.set_token('TYPE','BEN_BOOL');
780: fnd_message.raise_error;
781: --
782: end if;
783: --
784: end if;
797: p_effective_date => p_effective_date) then
798: --
799: -- raise error as does not exist as lookup
800: --
801: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
802: fnd_message.set_token('FIELD','p_bool6_cd');
803: fnd_message.set_token('TYPE','BEN_BOOL');
804: fnd_message.raise_error;
805: --
798: --
799: -- raise error as does not exist as lookup
800: --
801: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
802: fnd_message.set_token('FIELD','p_bool6_cd');
803: fnd_message.set_token('TYPE','BEN_BOOL');
804: fnd_message.raise_error;
805: --
806: end if;
799: -- raise error as does not exist as lookup
800: --
801: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
802: fnd_message.set_token('FIELD','p_bool6_cd');
803: fnd_message.set_token('TYPE','BEN_BOOL');
804: fnd_message.raise_error;
805: --
806: end if;
807: --
800: --
801: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
802: fnd_message.set_token('FIELD','p_bool6_cd');
803: fnd_message.set_token('TYPE','BEN_BOOL');
804: fnd_message.raise_error;
805: --
806: end if;
807: --
808: end if;
821: p_effective_date => p_effective_date) then
822: --
823: -- raise error as does not exist as lookup
824: --
825: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
826: fnd_message.set_token('FIELD','p_bool7_cd');
827: fnd_message.set_token('TYPE','BEN_BOOL');
828: fnd_message.raise_error;
829: --
822: --
823: -- raise error as does not exist as lookup
824: --
825: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
826: fnd_message.set_token('FIELD','p_bool7_cd');
827: fnd_message.set_token('TYPE','BEN_BOOL');
828: fnd_message.raise_error;
829: --
830: end if;
823: -- raise error as does not exist as lookup
824: --
825: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
826: fnd_message.set_token('FIELD','p_bool7_cd');
827: fnd_message.set_token('TYPE','BEN_BOOL');
828: fnd_message.raise_error;
829: --
830: end if;
831: --
824: --
825: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
826: fnd_message.set_token('FIELD','p_bool7_cd');
827: fnd_message.set_token('TYPE','BEN_BOOL');
828: fnd_message.raise_error;
829: --
830: end if;
831: --
832: end if;
845: p_effective_date => p_effective_date) then
846: --
847: -- raise error as does not exist as lookup
848: --
849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
850: fnd_message.set_token('FIELD','p_bool8_cd');
851: fnd_message.set_token('TYPE','BEN_BOOL');
852: fnd_message.raise_error;
853: --
846: --
847: -- raise error as does not exist as lookup
848: --
849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
850: fnd_message.set_token('FIELD','p_bool8_cd');
851: fnd_message.set_token('TYPE','BEN_BOOL');
852: fnd_message.raise_error;
853: --
854: end if;
847: -- raise error as does not exist as lookup
848: --
849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
850: fnd_message.set_token('FIELD','p_bool8_cd');
851: fnd_message.set_token('TYPE','BEN_BOOL');
852: fnd_message.raise_error;
853: --
854: end if;
855: --
848: --
849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
850: fnd_message.set_token('FIELD','p_bool8_cd');
851: fnd_message.set_token('TYPE','BEN_BOOL');
852: fnd_message.raise_error;
853: --
854: end if;
855: --
856: end if;
869: p_effective_date => p_effective_date) then
870: --
871: -- raise error as does not exist as lookup
872: --
873: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
874: fnd_message.set_token('FIELD','p_bool9_cd');
875: fnd_message.set_token('TYPE','BEN_BOOL');
876: fnd_message.raise_error;
877: --
870: --
871: -- raise error as does not exist as lookup
872: --
873: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
874: fnd_message.set_token('FIELD','p_bool9_cd');
875: fnd_message.set_token('TYPE','BEN_BOOL');
876: fnd_message.raise_error;
877: --
878: end if;
871: -- raise error as does not exist as lookup
872: --
873: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
874: fnd_message.set_token('FIELD','p_bool9_cd');
875: fnd_message.set_token('TYPE','BEN_BOOL');
876: fnd_message.raise_error;
877: --
878: end if;
879: --
872: --
873: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
874: fnd_message.set_token('FIELD','p_bool9_cd');
875: fnd_message.set_token('TYPE','BEN_BOOL');
876: fnd_message.raise_error;
877: --
878: end if;
879: --
880: end if;
943: p_effective_date => p_effective_date) then
944: --
945: -- raise error
946: --
947: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
948: fnd_message.set_token('ID',p_eval_rl);
949: fnd_message.set_token('TYPE_ID',-506);
950: fnd_message.raise_error;
951: --
944: --
945: -- raise error
946: --
947: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
948: fnd_message.set_token('ID',p_eval_rl);
949: fnd_message.set_token('TYPE_ID',-506);
950: fnd_message.raise_error;
951: --
952: end if;
945: -- raise error
946: --
947: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
948: fnd_message.set_token('ID',p_eval_rl);
949: fnd_message.set_token('TYPE_ID',-506);
950: fnd_message.raise_error;
951: --
952: end if;
953: --
946: --
947: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
948: fnd_message.set_token('ID',p_eval_rl);
949: fnd_message.set_token('TYPE_ID',-506);
950: fnd_message.raise_error;
951: --
952: end if;
953: --
954: end if;
1016: p_effective_date => p_effective_date) then
1017: --
1018: -- raise error
1019: --
1020: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1021: fnd_message.set_token('ID',p_eval_ler_det_rl);
1022: fnd_message.set_token('TYPE_ID',-505);
1023: fnd_message.raise_error;
1024: --
1017: --
1018: -- raise error
1019: --
1020: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1021: fnd_message.set_token('ID',p_eval_ler_det_rl);
1022: fnd_message.set_token('TYPE_ID',-505);
1023: fnd_message.raise_error;
1024: --
1025: end if;
1018: -- raise error
1019: --
1020: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1021: fnd_message.set_token('ID',p_eval_ler_det_rl);
1022: fnd_message.set_token('TYPE_ID',-505);
1023: fnd_message.raise_error;
1024: --
1025: end if;
1026: --
1019: --
1020: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1021: fnd_message.set_token('ID',p_eval_ler_det_rl);
1022: fnd_message.set_token('TYPE_ID',-505);
1023: fnd_message.raise_error;
1024: --
1025: end if;
1026: --
1027: end if;
1152: --
1153: -- Raise error as user must use consecutive boolean codes as otherwise
1154: -- the parsing becomes more complex.
1155: --
1156: fnd_message.set_name('BEN','BEN_92128_CONSEC_BOOLEAN');
1157: fnd_message.raise_error;
1158: --
1159: end if;
1160: --
1153: -- Raise error as user must use consecutive boolean codes as otherwise
1154: -- the parsing becomes more complex.
1155: --
1156: fnd_message.set_name('BEN','BEN_92128_CONSEC_BOOLEAN');
1157: fnd_message.raise_error;
1158: --
1159: end if;
1160: --
1161: hr_utility.set_location('Entering:'||l_proc, 5);
1298: --
1299: -- Raise error as user must use consecutive boolean codes as otherwise
1300: -- the parsing becomes more complex.
1301: --
1302: fnd_message.set_name('BEN','BEN_92129_CONSEC_LER');
1303: fnd_message.raise_error;
1304: --
1305: end if;
1306: --
1299: -- Raise error as user must use consecutive boolean codes as otherwise
1300: -- the parsing becomes more complex.
1301: --
1302: fnd_message.set_name('BEN','BEN_92129_CONSEC_LER');
1303: fnd_message.raise_error;
1304: --
1305: end if;
1306: --
1307: hr_utility.set_location('Entering:'||l_proc, 5);
1365: p_effective_date => p_effective_date) then
1366: --
1367: -- raise error as does not exist as lookup
1368: --
1369: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1370: fnd_message.set_token('FIELD','p_eval_cd');
1371: fnd_message.set_token('TYPE','BEN_EVAL');
1372: fnd_message.raise_error;
1373: --
1366: --
1367: -- raise error as does not exist as lookup
1368: --
1369: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1370: fnd_message.set_token('FIELD','p_eval_cd');
1371: fnd_message.set_token('TYPE','BEN_EVAL');
1372: fnd_message.raise_error;
1373: --
1374: end if;
1367: -- raise error as does not exist as lookup
1368: --
1369: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1370: fnd_message.set_token('FIELD','p_eval_cd');
1371: fnd_message.set_token('TYPE','BEN_EVAL');
1372: fnd_message.raise_error;
1373: --
1374: end if;
1375: --
1368: --
1369: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1370: fnd_message.set_token('FIELD','p_eval_cd');
1371: fnd_message.set_token('TYPE','BEN_EVAL');
1372: fnd_message.raise_error;
1373: --
1374: end if;
1375: --
1376: end if;
1436: p_effective_date => p_effective_date) then
1437: --
1438: -- raise error as does not exist as lookup
1439: --
1440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1441: fnd_message.set_token('FIELD','p_eval_ler_det_cd');
1442: fnd_message.set_token('TYPE','BEN_EVAL_DET');
1443: fnd_message.raise_error;
1444: --
1437: --
1438: -- raise error as does not exist as lookup
1439: --
1440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1441: fnd_message.set_token('FIELD','p_eval_ler_det_cd');
1442: fnd_message.set_token('TYPE','BEN_EVAL_DET');
1443: fnd_message.raise_error;
1444: --
1445: end if;
1438: -- raise error as does not exist as lookup
1439: --
1440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1441: fnd_message.set_token('FIELD','p_eval_ler_det_cd');
1442: fnd_message.set_token('TYPE','BEN_EVAL_DET');
1443: fnd_message.raise_error;
1444: --
1445: end if;
1446: --
1439: --
1440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1441: fnd_message.set_token('FIELD','p_eval_ler_det_cd');
1442: fnd_message.set_token('TYPE','BEN_EVAL_DET');
1443: fnd_message.raise_error;
1444: --
1445: end if;
1446: --
1447: end if;