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);
195: --
196: -- raise an error as mlt_cd can only be TTLPRTT .
197: --
198: --
199: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');
200: fnd_message.raise_error;
201: END IF;
202: END IF;
203:
196: -- raise an error as mlt_cd can only be TTLPRTT .
197: --
198: --
199: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');
200: fnd_message.raise_error;
201: END IF;
202: END IF;
203:
204: 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_prtt_det_cd');
358: fnd_message.set_token('TYPE','BEN_PRTT_DET');
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_prtt_det_cd');
358: fnd_message.set_token('TYPE','BEN_PRTT_DET');
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_prtt_det_cd');
358: fnd_message.set_token('TYPE','BEN_PRTT_DET');
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_prtt_det_cd');
358: fnd_message.set_token('TYPE','BEN_PRTT_DET');
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_prtt_num_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_prtt_num_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_prtt_num_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_prtt_num_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_prtt_num_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_prtt_num_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_prtt_num_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_prtt_num_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;
642: close c1;
643: --
644: -- raise an error as vrbl_rt_prfl_id assigned to ttl_cvg_vol_rt(s).
645: --
646: fnd_message.set_name('BEN','BEN_92259_TTLPRTT_CVGVOL_EXCL2');
647: fnd_message.raise_error;
648: --
649: end if;
650: --
643: --
644: -- raise an error as vrbl_rt_prfl_id assigned to ttl_cvg_vol_rt(s).
645: --
646: fnd_message.set_name('BEN','BEN_92259_TTLPRTT_CVGVOL_EXCL2');
647: fnd_message.raise_error;
648: --
649: end if;
650: --
651: close c1;
690: --
691: hr_utility.set_location('Entering:'||l_proc, 5);
692: --
693: if p_flag = 'Y' and p_val is not null then
694: fnd_message.set_name('BEN', p_msg);
695: fnd_message.raise_error;
696: end if;
697: --
698: hr_utility.set_location('Leaving:'||l_proc,10);
691: hr_utility.set_location('Entering:'||l_proc, 5);
692: --
693: if p_flag = 'Y' and p_val is not null then
694: fnd_message.set_name('BEN', p_msg);
695: fnd_message.raise_error;
696: end if;
697: --
698: hr_utility.set_location('Leaving:'||l_proc,10);
699: --
738: if (p_mn_val >= p_mx_val) then
739: --
740: -- raise error as is not a valid combination
741: --
742: fnd_message.set_name('BEN','BEN_91142_MIN_LESS_NOT_EQ_MAX');
743: fnd_message.raise_error;
744: --
745: end if;
746: --
739: --
740: -- raise error as is not a valid combination
741: --
742: fnd_message.set_name('BEN','BEN_91142_MIN_LESS_NOT_EQ_MAX');
743: fnd_message.raise_error;
744: --
745: end if;
746: --
747: hr_utility.set_location('Leaving:'||l_proc, 5);
800: -- raise error if max value not greater than min value
801: --
802: if p_mx_prtt_num <= p_mn_prtt_num then
803: --
804: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
805: fnd_message.raise_error;
806: --
807: end if;
808: --
801: --
802: if p_mx_prtt_num <= p_mn_prtt_num then
803: --
804: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
805: fnd_message.raise_error;
806: --
807: end if;
808: --
809: end if;
813: --
814: if p_no_mn_prtt_num_apls_flag = 'Y' and
815: p_mn_prtt_num is not null then
816: --
817: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
818: fnd_message.raise_error;
819: --
820: elsif p_no_mn_prtt_num_apls_flag = 'N' and
821: p_mn_prtt_num is null then
814: if p_no_mn_prtt_num_apls_flag = 'Y' and
815: p_mn_prtt_num is not null then
816: --
817: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
818: fnd_message.raise_error;
819: --
820: elsif p_no_mn_prtt_num_apls_flag = 'N' and
821: p_mn_prtt_num is null then
822: --
819: --
820: elsif p_no_mn_prtt_num_apls_flag = 'N' and
821: p_mn_prtt_num is null then
822: --
823: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
824: fnd_message.raise_error;
825: --
826: end if;
827: --
820: elsif p_no_mn_prtt_num_apls_flag = 'N' and
821: p_mn_prtt_num is null then
822: --
823: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
824: fnd_message.raise_error;
825: --
826: end if;
827: --
828: -- If No Maximum poe flag set to "on" (Y),
830: --
831: if p_no_mx_prtt_num_apls_flag = 'Y' and
832: p_mx_prtt_num is not null then
833: --
834: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
835: fnd_message.raise_error;
836: --
837: elsif p_no_mx_prtt_num_apls_flag = 'N' and
838: p_mx_prtt_num is null then
831: if p_no_mx_prtt_num_apls_flag = 'Y' and
832: p_mx_prtt_num is not null then
833: --
834: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
835: fnd_message.raise_error;
836: --
837: elsif p_no_mx_prtt_num_apls_flag = 'N' and
838: p_mx_prtt_num is null then
839: --
836: --
837: elsif p_no_mx_prtt_num_apls_flag = 'N' and
838: p_mx_prtt_num is null then
839: --
840: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
841: fnd_message.raise_error;
842: --
843: end if;
844: --
837: elsif p_no_mx_prtt_num_apls_flag = 'N' and
838: p_mx_prtt_num is null then
839: --
840: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
841: fnd_message.raise_error;
842: --
843: end if;
844: --
845: 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 >----------------------------|
1321: close csr_leg_code;
1322: --
1323: -- The primary key is invalid therefore we must error
1324: --
1325: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1326: fnd_message.raise_error;
1327: --
1328: end if;
1329: --
1322: --
1323: -- The primary key is invalid therefore we must error
1324: --
1325: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1326: fnd_message.raise_error;
1327: --
1328: end if;
1329: --
1330: close csr_leg_code;