125: open c1;
126: fetch c1 into l_dummy;
127: if c1%found then
128: close c1;
129: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
126: fetch c1 into l_dummy;
127: if c1%found then
128: close c1;
129: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);
206: close c1;
207: --
208: -- raise error
209: --
210: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
207: --
208: -- raise error
209: --
210: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
215: close c1;
277: p_effective_date => p_effective_date) then
278: --
279: -- raise error as does not exist as lookup
280: --
281: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
282: fnd_message.set_token('FIELD','p_prtt_det_cd');
283: fnd_message.set_token('TYPE','BEN_PRTT_DET');
284: fnd_message.raise_error;
285: --
278: --
279: -- raise error as does not exist as lookup
280: --
281: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
282: fnd_message.set_token('FIELD','p_prtt_det_cd');
283: fnd_message.set_token('TYPE','BEN_PRTT_DET');
284: fnd_message.raise_error;
285: --
286: end if;
279: -- raise error as does not exist as lookup
280: --
281: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
282: fnd_message.set_token('FIELD','p_prtt_det_cd');
283: fnd_message.set_token('TYPE','BEN_PRTT_DET');
284: fnd_message.raise_error;
285: --
286: end if;
287: --
280: --
281: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
282: fnd_message.set_token('FIELD','p_prtt_det_cd');
283: fnd_message.set_token('TYPE','BEN_PRTT_DET');
284: fnd_message.raise_error;
285: --
286: end if;
287: --
288: end if;
348: p_effective_date => p_effective_date) then
349: --
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_no_mx_prtt_num_apls_flag');
354: fnd_message.set_token('TYPE','YES_NO');
355: fnd_message.raise_error;
356: --
349: --
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_no_mx_prtt_num_apls_flag');
354: fnd_message.set_token('TYPE','YES_NO');
355: fnd_message.raise_error;
356: --
357: end if;
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_no_mx_prtt_num_apls_flag');
354: fnd_message.set_token('TYPE','YES_NO');
355: fnd_message.raise_error;
356: --
357: end if;
358: --
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_no_mx_prtt_num_apls_flag');
354: fnd_message.set_token('TYPE','YES_NO');
355: fnd_message.raise_error;
356: --
357: end if;
358: --
359: end if;
419: p_effective_date => p_effective_date) then
420: --
421: -- raise error as does not exist as lookup
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_no_mn_prtt_num_apls_flag');
425: fnd_message.set_token('TYPE','YES_NO');
426: fnd_message.raise_error;
427: --
420: --
421: -- raise error as does not exist as lookup
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_no_mn_prtt_num_apls_flag');
425: fnd_message.set_token('TYPE','YES_NO');
426: fnd_message.raise_error;
427: --
428: end if;
421: -- raise error as does not exist as lookup
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_no_mn_prtt_num_apls_flag');
425: fnd_message.set_token('TYPE','YES_NO');
426: fnd_message.raise_error;
427: --
428: end if;
429: --
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_no_mn_prtt_num_apls_flag');
425: fnd_message.set_token('TYPE','YES_NO');
426: fnd_message.raise_error;
427: --
428: end if;
429: --
430: end if;
490: p_effective_date => p_effective_date) then
491: --
492: -- raise error as does not exist as lookup
493: --
494: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
495: fnd_message.set_token('FIELD','p_excld_flag');
496: fnd_message.set_token('TYPE','YES_NO');
497: fnd_message.raise_error;
498: --
491: --
492: -- raise error as does not exist as lookup
493: --
494: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
495: fnd_message.set_token('FIELD','p_excld_flag');
496: fnd_message.set_token('TYPE','YES_NO');
497: fnd_message.raise_error;
498: --
499: end if;
492: -- raise error as does not exist as lookup
493: --
494: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
495: fnd_message.set_token('FIELD','p_excld_flag');
496: fnd_message.set_token('TYPE','YES_NO');
497: fnd_message.raise_error;
498: --
499: end if;
500: --
493: --
494: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
495: fnd_message.set_token('FIELD','p_excld_flag');
496: fnd_message.set_token('TYPE','YES_NO');
497: fnd_message.raise_error;
498: --
499: end if;
500: --
501: end if;
538: --
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: if p_flag = 'Y' and p_val is not null then
542: fnd_message.set_name('BEN', p_msg);
543: fnd_message.raise_error;
544: end if;
545: --
546: hr_utility.set_location('Leaving:'||l_proc,10);
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: if p_flag = 'Y' and p_val is not null then
542: fnd_message.set_name('BEN', p_msg);
543: fnd_message.raise_error;
544: end if;
545: --
546: hr_utility.set_location('Leaving:'||l_proc,10);
547: --
600: -- raise error if max value not greater than min value
601: --
602: if p_mx_prtt_num <= p_mn_prtt_num then
603: --
604: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
605: fnd_message.raise_error;
606: --
607: end if;
608: --
601: --
602: if p_mx_prtt_num <= p_mn_prtt_num then
603: --
604: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
605: fnd_message.raise_error;
606: --
607: end if;
608: --
609: end if;
613: --
614: if p_no_mn_prtt_num_apls_flag = 'Y' and
615: p_mn_prtt_num is not null then
616: --
617: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
618: fnd_message.raise_error;
619: --
620: elsif p_no_mn_prtt_num_apls_flag = 'N' and
621: p_mn_prtt_num is null then
614: if p_no_mn_prtt_num_apls_flag = 'Y' and
615: p_mn_prtt_num is not null then
616: --
617: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
618: fnd_message.raise_error;
619: --
620: elsif p_no_mn_prtt_num_apls_flag = 'N' and
621: p_mn_prtt_num is null then
622: --
619: --
620: elsif p_no_mn_prtt_num_apls_flag = 'N' and
621: p_mn_prtt_num is null then
622: --
623: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
624: fnd_message.raise_error;
625: --
626: end if;
627: --
620: elsif p_no_mn_prtt_num_apls_flag = 'N' and
621: p_mn_prtt_num is null then
622: --
623: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
624: fnd_message.raise_error;
625: --
626: end if;
627: --
628: -- If No Maximum poe flag set to "on" (Y),
630: --
631: if p_no_mx_prtt_num_apls_flag = 'Y' and
632: p_mx_prtt_num is not null then
633: --
634: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
635: fnd_message.raise_error;
636: --
637: elsif p_no_mx_prtt_num_apls_flag = 'N' and
638: p_mx_prtt_num is null then
631: if p_no_mx_prtt_num_apls_flag = 'Y' and
632: p_mx_prtt_num is not null then
633: --
634: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
635: fnd_message.raise_error;
636: --
637: elsif p_no_mx_prtt_num_apls_flag = 'N' and
638: p_mx_prtt_num is null then
639: --
636: --
637: elsif p_no_mx_prtt_num_apls_flag = 'N' and
638: p_mx_prtt_num is null then
639: --
640: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
641: fnd_message.raise_error;
642: --
643: end if;
644: --
637: elsif p_no_mx_prtt_num_apls_flag = 'N' and
638: p_mx_prtt_num is null then
639: --
640: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
641: fnd_message.raise_error;
642: --
643: end if;
644: --
645: hr_utility.set_location('Leaving:'||l_proc,10);
735: --
736: -- An unhandled or unexpected error has occurred which
737: -- we must report
738: --
739: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: End dt_update_validate;
736: -- An unhandled or unexpected error has occurred which
737: -- we must report
738: --
739: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: End dt_update_validate;
744: --
737: -- we must report
738: --
739: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: End dt_update_validate;
744: --
745: -- ----------------------------------------------------------------------------
738: --
739: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: End dt_update_validate;
744: --
745: -- ----------------------------------------------------------------------------
746: -- |--------------------------< dt_delete_validate >--------------------------|
831: --
832: -- A referential integrity check was violated therefore
833: -- we must error
834: --
835: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
836: fnd_message.set_token('TABLE_NAME', l_table_name);
837: fnd_message.raise_error;
838: When Others Then
839: --
832: -- A referential integrity check was violated therefore
833: -- we must error
834: --
835: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
836: fnd_message.set_token('TABLE_NAME', l_table_name);
837: fnd_message.raise_error;
838: When Others Then
839: --
840: -- An unhandled or unexpected error has occurred which
833: -- we must error
834: --
835: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
836: fnd_message.set_token('TABLE_NAME', l_table_name);
837: fnd_message.raise_error;
838: When Others Then
839: --
840: -- An unhandled or unexpected error has occurred which
841: -- we must report
839: --
840: -- An unhandled or unexpected error has occurred which
841: -- we must report
842: --
843: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
844: fnd_message.set_token('PROCEDURE', l_proc);
845: fnd_message.set_token('STEP','15');
846: fnd_message.raise_error;
847: End dt_delete_validate;
840: -- An unhandled or unexpected error has occurred which
841: -- we must report
842: --
843: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
844: fnd_message.set_token('PROCEDURE', l_proc);
845: fnd_message.set_token('STEP','15');
846: fnd_message.raise_error;
847: End dt_delete_validate;
848: --
841: -- we must report
842: --
843: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
844: fnd_message.set_token('PROCEDURE', l_proc);
845: fnd_message.set_token('STEP','15');
846: fnd_message.raise_error;
847: End dt_delete_validate;
848: --
849: -- ----------------------------------------------------------------------------
842: --
843: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
844: fnd_message.set_token('PROCEDURE', l_proc);
845: fnd_message.set_token('STEP','15');
846: fnd_message.raise_error;
847: End dt_delete_validate;
848: --
849: -- ----------------------------------------------------------------------------
850: -- |---------------------------< insert_validate >----------------------------|
1085: close csr_leg_code;
1086: --
1087: -- The primary key is invalid therefore we must error
1088: --
1089: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1090: fnd_message.raise_error;
1091: --
1092: end if;
1093: --
1086: --
1087: -- The primary key is invalid therefore we must error
1088: --
1089: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1090: fnd_message.raise_error;
1091: --
1092: end if;
1093: --
1094: close csr_leg_code;