124: open c1;
125: fetch c1 into l_dummy;
126: --
127: if c1%found then
128: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
129: fnd_message.raise_error;
130: end if;
131: close c1;
132: --
125: fetch c1 into l_dummy;
126: --
127: if c1%found then
128: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
129: fnd_message.raise_error;
130: end if;
131: close c1;
132: --
133: hr_utility.set_location('Leaving:'||l_proc, 10);
197: --
198: -- raise an error as mlt_cd can only be TTLCVG .
199: --
200: --
201: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');
202: fnd_message.raise_error;
203: END IF;
204: END IF;
205:
198: -- raise an error as mlt_cd can only be TTLCVG .
199: --
200: --
201: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');
202: fnd_message.raise_error;
203: END IF;
204: END IF;
205:
206: close c1;
281: close c1;
282: --
283: -- raise error
284: --
285: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
286: fnd_message.raise_error;
287: --
288: end if;
289: --
282: --
283: -- raise error
284: --
285: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
286: fnd_message.raise_error;
287: --
288: end if;
289: --
290: close c1;
352: p_effective_date => p_effective_date) then
353: --
354: -- raise error as does not exist as lookup
355: --
356: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
357: fnd_message.set_token('FIELD','p_cvg_vol_det_cd');
358: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
359: fnd_message.raise_error;
360: --
353: --
354: -- raise error as does not exist as lookup
355: --
356: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
357: fnd_message.set_token('FIELD','p_cvg_vol_det_cd');
358: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
359: fnd_message.raise_error;
360: --
361: end if;
354: -- raise error as does not exist as lookup
355: --
356: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
357: fnd_message.set_token('FIELD','p_cvg_vol_det_cd');
358: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
359: fnd_message.raise_error;
360: --
361: end if;
362: --
355: --
356: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
357: fnd_message.set_token('FIELD','p_cvg_vol_det_cd');
358: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
359: fnd_message.raise_error;
360: --
361: end if;
362: --
363: end if;
423: p_effective_date => p_effective_date) then
424: --
425: -- raise error as does not exist as lookup
426: --
427: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
428: fnd_message.set_token('FIELD','p_no_mx_cvg_vol_amt_apls_flag');
429: fnd_message.set_token('TYPE','YES_NO');
430: fnd_message.raise_error;
431: --
424: --
425: -- raise error as does not exist as lookup
426: --
427: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
428: fnd_message.set_token('FIELD','p_no_mx_cvg_vol_amt_apls_flag');
429: fnd_message.set_token('TYPE','YES_NO');
430: fnd_message.raise_error;
431: --
432: end if;
425: -- raise error as does not exist as lookup
426: --
427: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
428: fnd_message.set_token('FIELD','p_no_mx_cvg_vol_amt_apls_flag');
429: fnd_message.set_token('TYPE','YES_NO');
430: fnd_message.raise_error;
431: --
432: end if;
433: --
426: --
427: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
428: fnd_message.set_token('FIELD','p_no_mx_cvg_vol_amt_apls_flag');
429: fnd_message.set_token('TYPE','YES_NO');
430: fnd_message.raise_error;
431: --
432: end if;
433: --
434: end if;
494: p_effective_date => p_effective_date) then
495: --
496: -- raise error as does not exist as lookup
497: --
498: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
499: fnd_message.set_token('FIELD','p_no_mn_cvg_vol_amt_apls_flag');
500: fnd_message.set_token('TYPE','YES_NO');
501: fnd_message.raise_error;
502: --
495: --
496: -- raise error as does not exist as lookup
497: --
498: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
499: fnd_message.set_token('FIELD','p_no_mn_cvg_vol_amt_apls_flag');
500: fnd_message.set_token('TYPE','YES_NO');
501: fnd_message.raise_error;
502: --
503: end if;
496: -- raise error as does not exist as lookup
497: --
498: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
499: fnd_message.set_token('FIELD','p_no_mn_cvg_vol_amt_apls_flag');
500: fnd_message.set_token('TYPE','YES_NO');
501: fnd_message.raise_error;
502: --
503: end if;
504: --
497: --
498: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
499: fnd_message.set_token('FIELD','p_no_mn_cvg_vol_amt_apls_flag');
500: fnd_message.set_token('TYPE','YES_NO');
501: fnd_message.raise_error;
502: --
503: end if;
504: --
505: end if;
565: p_effective_date => p_effective_date) then
566: --
567: -- raise error as does not exist as lookup
568: --
569: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
570: fnd_message.set_token('FIELD','p_excld_flag');
571: fnd_message.set_token('TYPE','YES_NO');
572: fnd_message.raise_error;
573: --
566: --
567: -- raise error as does not exist as lookup
568: --
569: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
570: fnd_message.set_token('FIELD','p_excld_flag');
571: fnd_message.set_token('TYPE','YES_NO');
572: fnd_message.raise_error;
573: --
574: end if;
567: -- raise error as does not exist as lookup
568: --
569: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
570: fnd_message.set_token('FIELD','p_excld_flag');
571: fnd_message.set_token('TYPE','YES_NO');
572: fnd_message.raise_error;
573: --
574: end if;
575: --
568: --
569: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
570: fnd_message.set_token('FIELD','p_excld_flag');
571: fnd_message.set_token('TYPE','YES_NO');
572: fnd_message.raise_error;
573: --
574: end if;
575: --
576: end if;
640: close c1;
641: --
642: -- raise an error as this vrbl_rt_prfl_id assigned to ttl_prtt_rt(s).
643: --
644: fnd_message.set_name('BEN','BEN_92258_TTLPRTT_CVGVOL_EXCL1');
645: fnd_message.raise_error;
646: --
647: end if;
648: --
641: --
642: -- raise an error as this vrbl_rt_prfl_id assigned to ttl_prtt_rt(s).
643: --
644: fnd_message.set_name('BEN','BEN_92258_TTLPRTT_CVGVOL_EXCL1');
645: fnd_message.raise_error;
646: --
647: end if;
648: --
649: close c1;
689: --
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: if p_flag = 'Y' and p_val is not null then
693: fnd_message.set_name('BEN', p_msg);
694: fnd_message.raise_error;
695: end if;
696: --
697: hr_utility.set_location('Leaving:'||l_proc,10);
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: if p_flag = 'Y' and p_val is not null then
693: fnd_message.set_name('BEN', p_msg);
694: fnd_message.raise_error;
695: end if;
696: --
697: hr_utility.set_location('Leaving:'||l_proc,10);
698: --
737: if (p_mn_val >= p_mx_val) then
738: --
739: -- raise error as is not a valid combination
740: --
741: fnd_message.set_name('BEN','BEN_91142_MIN_LESS_NOT_EQ_MAX');
742: fnd_message.raise_error;
743: --
744: end if;
745: --
738: --
739: -- raise error as is not a valid combination
740: --
741: fnd_message.set_name('BEN','BEN_91142_MIN_LESS_NOT_EQ_MAX');
742: fnd_message.raise_error;
743: --
744: end if;
745: --
746: hr_utility.set_location('Leaving:'||l_proc, 5);
799: -- raise error if max value not greater than min value
800: --
801: if p_mx_cvg_vol_amt <= p_mn_cvg_vol_amt then
802: --
803: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
804: fnd_message.raise_error;
805: --
806: end if;
807: --
800: --
801: if p_mx_cvg_vol_amt <= p_mn_cvg_vol_amt then
802: --
803: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
804: fnd_message.raise_error;
805: --
806: end if;
807: --
808: end if;
812: --
813: if p_no_mn_cvg_vol_amt_apls_flag = 'Y' and
814: p_mn_cvg_vol_amt is not null then
815: --
816: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
817: fnd_message.raise_error;
818: --
819: elsif p_no_mn_cvg_vol_amt_apls_flag = 'N' and
820: p_mn_cvg_vol_amt is null then
813: if p_no_mn_cvg_vol_amt_apls_flag = 'Y' and
814: p_mn_cvg_vol_amt is not null then
815: --
816: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
817: fnd_message.raise_error;
818: --
819: elsif p_no_mn_cvg_vol_amt_apls_flag = 'N' and
820: p_mn_cvg_vol_amt is null then
821: --
818: --
819: elsif p_no_mn_cvg_vol_amt_apls_flag = 'N' and
820: p_mn_cvg_vol_amt is null then
821: --
822: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
823: fnd_message.raise_error;
824: --
825: end if;
826: --
819: elsif p_no_mn_cvg_vol_amt_apls_flag = 'N' and
820: p_mn_cvg_vol_amt is null then
821: --
822: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
823: fnd_message.raise_error;
824: --
825: end if;
826: --
827: -- If No Maximum poe flag set to "on" (Y),
829: --
830: if p_no_mx_cvg_vol_amt_apls_flag = 'Y' and
831: p_mx_cvg_vol_amt is not null then
832: --
833: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
834: fnd_message.raise_error;
835: --
836: elsif p_no_mx_cvg_vol_amt_apls_flag = 'N' and
837: p_mx_cvg_vol_amt is null then
830: if p_no_mx_cvg_vol_amt_apls_flag = 'Y' and
831: p_mx_cvg_vol_amt is not null then
832: --
833: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
834: fnd_message.raise_error;
835: --
836: elsif p_no_mx_cvg_vol_amt_apls_flag = 'N' and
837: p_mx_cvg_vol_amt is null then
838: --
835: --
836: elsif p_no_mx_cvg_vol_amt_apls_flag = 'N' and
837: p_mx_cvg_vol_amt is null then
838: --
839: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
840: fnd_message.raise_error;
841: --
842: end if;
843: --
836: elsif p_no_mx_cvg_vol_amt_apls_flag = 'N' and
837: p_mx_cvg_vol_amt is null then
838: --
839: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
840: fnd_message.raise_error;
841: --
842: end if;
843: --
844: hr_utility.set_location('Leaving:'||l_proc,10);
935: --
936: -- An unhandled or unexpected error has occurred which
937: -- we must report
938: --
939: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
940: fnd_message.set_token('PROCEDURE', l_proc);
941: fnd_message.set_token('STEP','15');
942: fnd_message.raise_error;
943: End dt_update_validate;
936: -- An unhandled or unexpected error has occurred which
937: -- we must report
938: --
939: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
940: fnd_message.set_token('PROCEDURE', l_proc);
941: fnd_message.set_token('STEP','15');
942: fnd_message.raise_error;
943: End dt_update_validate;
944: --
937: -- we must report
938: --
939: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
940: fnd_message.set_token('PROCEDURE', l_proc);
941: fnd_message.set_token('STEP','15');
942: fnd_message.raise_error;
943: End dt_update_validate;
944: --
945: -- ----------------------------------------------------------------------------
938: --
939: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
940: fnd_message.set_token('PROCEDURE', l_proc);
941: fnd_message.set_token('STEP','15');
942: fnd_message.raise_error;
943: End dt_update_validate;
944: --
945: -- ----------------------------------------------------------------------------
946: -- |--------------------------< dt_delete_validate >--------------------------|
1031: --
1032: -- A referential integrity check was violated therefore
1033: -- we must error
1034: --
1035: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1036: fnd_message.set_token('TABLE_NAME', l_table_name);
1037: fnd_message.raise_error;
1038: When Others Then
1039: --
1032: -- A referential integrity check was violated therefore
1033: -- we must error
1034: --
1035: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1036: fnd_message.set_token('TABLE_NAME', l_table_name);
1037: fnd_message.raise_error;
1038: When Others Then
1039: --
1040: -- An unhandled or unexpected error has occurred which
1033: -- we must error
1034: --
1035: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1036: fnd_message.set_token('TABLE_NAME', l_table_name);
1037: fnd_message.raise_error;
1038: When Others Then
1039: --
1040: -- An unhandled or unexpected error has occurred which
1041: -- we must report
1039: --
1040: -- An unhandled or unexpected error has occurred which
1041: -- we must report
1042: --
1043: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1044: fnd_message.set_token('PROCEDURE', l_proc);
1045: fnd_message.set_token('STEP','15');
1046: fnd_message.raise_error;
1047: End dt_delete_validate;
1040: -- An unhandled or unexpected error has occurred which
1041: -- we must report
1042: --
1043: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1044: fnd_message.set_token('PROCEDURE', l_proc);
1045: fnd_message.set_token('STEP','15');
1046: fnd_message.raise_error;
1047: End dt_delete_validate;
1048: --
1041: -- we must report
1042: --
1043: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1044: fnd_message.set_token('PROCEDURE', l_proc);
1045: fnd_message.set_token('STEP','15');
1046: fnd_message.raise_error;
1047: End dt_delete_validate;
1048: --
1049: -- ----------------------------------------------------------------------------
1042: --
1043: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1044: fnd_message.set_token('PROCEDURE', l_proc);
1045: fnd_message.set_token('STEP','15');
1046: fnd_message.raise_error;
1047: End dt_delete_validate;
1048: --
1049: -- ----------------------------------------------------------------------------
1050: -- |---------------------------< insert_validate >----------------------------|
1319: close csr_leg_code;
1320: --
1321: -- The primary key is invalid therefore we must error
1322: --
1323: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1324: fnd_message.raise_error;
1325: --
1326: end if;
1327: --
1320: --
1321: -- The primary key is invalid therefore we must error
1322: --
1323: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1324: fnd_message.raise_error;
1325: --
1326: end if;
1327: --
1328: close csr_leg_code;