DBA Data[Home] [Help]

APPS.BEN_ETC_BUS dependencies on FND_MESSAGE

Line 129: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');

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: --

Line 130: fnd_message.raise_error;

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);

Line 209: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');

205: close c1;
206: --
207: -- raise error
208: --
209: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
210: fnd_message.raise_error;
211: --
212: end if;
213: --

Line 210: fnd_message.raise_error;

206: --
207: -- raise error
208: --
209: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
210: fnd_message.raise_error;
211: --
212: end if;
213: --
214: close c1;

Line 280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

276: p_effective_date => p_effective_date) then
277: --
278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cvg_vol_det_cd');
282: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
283: fnd_message.raise_error;
284: --

Line 281: fnd_message.set_token('FIELD','p_cvg_vol_det_cd');

277: --
278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cvg_vol_det_cd');
282: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
283: fnd_message.raise_error;
284: --
285: end if;

Line 282: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');

278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cvg_vol_det_cd');
282: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
283: fnd_message.raise_error;
284: --
285: end if;
286: --

Line 283: fnd_message.raise_error;

279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cvg_vol_det_cd');
282: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
283: fnd_message.raise_error;
284: --
285: end if;
286: --
287: end if;

Line 351: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

347: p_effective_date => p_effective_date) then
348: --
349: -- raise error as does not exist as lookup
350: --
351: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
352: fnd_message.set_token('FIELD','p_no_mx_cvg_vol_amt_apls_flag');
353: fnd_message.set_token('TYPE','YES_NO');
354: fnd_message.raise_error;
355: --

Line 352: fnd_message.set_token('FIELD','p_no_mx_cvg_vol_amt_apls_flag');

348: --
349: -- raise error as does not exist as lookup
350: --
351: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
352: fnd_message.set_token('FIELD','p_no_mx_cvg_vol_amt_apls_flag');
353: fnd_message.set_token('TYPE','YES_NO');
354: fnd_message.raise_error;
355: --
356: end if;

Line 353: fnd_message.set_token('TYPE','YES_NO');

349: -- raise error as does not exist as lookup
350: --
351: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
352: fnd_message.set_token('FIELD','p_no_mx_cvg_vol_amt_apls_flag');
353: fnd_message.set_token('TYPE','YES_NO');
354: fnd_message.raise_error;
355: --
356: end if;
357: --

Line 354: fnd_message.raise_error;

350: --
351: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
352: fnd_message.set_token('FIELD','p_no_mx_cvg_vol_amt_apls_flag');
353: fnd_message.set_token('TYPE','YES_NO');
354: fnd_message.raise_error;
355: --
356: end if;
357: --
358: end if;

Line 422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

418: p_effective_date => p_effective_date) then
419: --
420: -- raise error as does not exist as lookup
421: --
422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
423: fnd_message.set_token('FIELD','p_no_mn_cvg_vol_amt_apls_flag');
424: fnd_message.set_token('TYPE','YES_NO');
425: fnd_message.raise_error;
426: --

Line 423: fnd_message.set_token('FIELD','p_no_mn_cvg_vol_amt_apls_flag');

419: --
420: -- raise error as does not exist as lookup
421: --
422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
423: fnd_message.set_token('FIELD','p_no_mn_cvg_vol_amt_apls_flag');
424: fnd_message.set_token('TYPE','YES_NO');
425: fnd_message.raise_error;
426: --
427: end if;

Line 424: fnd_message.set_token('TYPE','YES_NO');

420: -- raise error as does not exist as lookup
421: --
422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
423: fnd_message.set_token('FIELD','p_no_mn_cvg_vol_amt_apls_flag');
424: fnd_message.set_token('TYPE','YES_NO');
425: fnd_message.raise_error;
426: --
427: end if;
428: --

Line 425: fnd_message.raise_error;

421: --
422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
423: fnd_message.set_token('FIELD','p_no_mn_cvg_vol_amt_apls_flag');
424: fnd_message.set_token('TYPE','YES_NO');
425: fnd_message.raise_error;
426: --
427: end if;
428: --
429: end if;

Line 493: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

489: p_effective_date => p_effective_date) then
490: --
491: -- raise error as does not exist as lookup
492: --
493: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
494: fnd_message.set_token('FIELD','p_excld_flag');
495: fnd_message.set_token('TYPE','YES_NO');
496: fnd_message.raise_error;
497: --

Line 494: fnd_message.set_token('FIELD','p_excld_flag');

490: --
491: -- raise error as does not exist as lookup
492: --
493: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
494: fnd_message.set_token('FIELD','p_excld_flag');
495: fnd_message.set_token('TYPE','YES_NO');
496: fnd_message.raise_error;
497: --
498: end if;

Line 495: fnd_message.set_token('TYPE','YES_NO');

491: -- raise error as does not exist as lookup
492: --
493: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
494: fnd_message.set_token('FIELD','p_excld_flag');
495: fnd_message.set_token('TYPE','YES_NO');
496: fnd_message.raise_error;
497: --
498: end if;
499: --

Line 496: fnd_message.raise_error;

492: --
493: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
494: fnd_message.set_token('FIELD','p_excld_flag');
495: fnd_message.set_token('TYPE','YES_NO');
496: fnd_message.raise_error;
497: --
498: end if;
499: --
500: end if;

Line 542: fnd_message.set_name('BEN', p_msg);

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);

Line 543: fnd_message.raise_error;

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: --

Line 604: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');

600: -- raise error if max value not greater than min value
601: --
602: if p_mx_cvg_vol_amt <= p_mn_cvg_vol_amt then
603: --
604: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
605: fnd_message.raise_error;
606: --
607: end if;
608: --

Line 605: fnd_message.raise_error;

601: --
602: if p_mx_cvg_vol_amt <= p_mn_cvg_vol_amt 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;

Line 617: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');

613: --
614: if p_no_mn_cvg_vol_amt_apls_flag = 'Y' and
615: p_mn_cvg_vol_amt 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_cvg_vol_amt_apls_flag = 'N' and
621: p_mn_cvg_vol_amt is null then

Line 618: fnd_message.raise_error;

614: if p_no_mn_cvg_vol_amt_apls_flag = 'Y' and
615: p_mn_cvg_vol_amt 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_cvg_vol_amt_apls_flag = 'N' and
621: p_mn_cvg_vol_amt is null then
622: --

Line 623: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');

619: --
620: elsif p_no_mn_cvg_vol_amt_apls_flag = 'N' and
621: p_mn_cvg_vol_amt 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: --

Line 624: fnd_message.raise_error;

620: elsif p_no_mn_cvg_vol_amt_apls_flag = 'N' and
621: p_mn_cvg_vol_amt 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),

Line 634: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');

630: --
631: if p_no_mx_cvg_vol_amt_apls_flag = 'Y' and
632: p_mx_cvg_vol_amt 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_cvg_vol_amt_apls_flag = 'N' and
638: p_mx_cvg_vol_amt is null then

Line 635: fnd_message.raise_error;

631: if p_no_mx_cvg_vol_amt_apls_flag = 'Y' and
632: p_mx_cvg_vol_amt 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_cvg_vol_amt_apls_flag = 'N' and
638: p_mx_cvg_vol_amt is null then
639: --

Line 640: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');

636: --
637: elsif p_no_mx_cvg_vol_amt_apls_flag = 'N' and
638: p_mx_cvg_vol_amt 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: --

Line 641: fnd_message.raise_error;

637: elsif p_no_mx_cvg_vol_amt_apls_flag = 'N' and
638: p_mx_cvg_vol_amt 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);

Line 740: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

736: --
737: -- An unhandled or unexpected error has occurred which
738: -- we must report
739: --
740: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
741: fnd_message.set_token('PROCEDURE', l_proc);
742: fnd_message.set_token('STEP','15');
743: fnd_message.raise_error;
744: End dt_update_validate;

Line 741: fnd_message.set_token('PROCEDURE', l_proc);

737: -- An unhandled or unexpected error has occurred which
738: -- we must report
739: --
740: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
741: fnd_message.set_token('PROCEDURE', l_proc);
742: fnd_message.set_token('STEP','15');
743: fnd_message.raise_error;
744: End dt_update_validate;
745: --

Line 742: fnd_message.set_token('STEP','15');

738: -- we must report
739: --
740: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
741: fnd_message.set_token('PROCEDURE', l_proc);
742: fnd_message.set_token('STEP','15');
743: fnd_message.raise_error;
744: End dt_update_validate;
745: --
746: -- ----------------------------------------------------------------------------

Line 743: fnd_message.raise_error;

739: --
740: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
741: fnd_message.set_token('PROCEDURE', l_proc);
742: fnd_message.set_token('STEP','15');
743: fnd_message.raise_error;
744: End dt_update_validate;
745: --
746: -- ----------------------------------------------------------------------------
747: -- |--------------------------< dt_delete_validate >--------------------------|

Line 836: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

832: --
833: -- A referential integrity check was violated therefore
834: -- we must error
835: --
836: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
837: fnd_message.set_token('TABLE_NAME', l_table_name);
838: fnd_message.raise_error;
839: When Others Then
840: --

Line 837: fnd_message.set_token('TABLE_NAME', l_table_name);

833: -- A referential integrity check was violated therefore
834: -- we must error
835: --
836: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
837: fnd_message.set_token('TABLE_NAME', l_table_name);
838: fnd_message.raise_error;
839: When Others Then
840: --
841: -- An unhandled or unexpected error has occurred which

Line 838: fnd_message.raise_error;

834: -- we must error
835: --
836: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
837: fnd_message.set_token('TABLE_NAME', l_table_name);
838: fnd_message.raise_error;
839: When Others Then
840: --
841: -- An unhandled or unexpected error has occurred which
842: -- we must report

Line 844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

840: --
841: -- An unhandled or unexpected error has occurred which
842: -- we must report
843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;

Line 845: fnd_message.set_token('PROCEDURE', l_proc);

841: -- An unhandled or unexpected error has occurred which
842: -- we must report
843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;
849: --

Line 846: fnd_message.set_token('STEP','15');

842: -- we must report
843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;
849: --
850: -- ----------------------------------------------------------------------------

Line 847: fnd_message.raise_error;

843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;
849: --
850: -- ----------------------------------------------------------------------------
851: -- |---------------------------< insert_validate >----------------------------|

Line 1090: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

1086: close csr_leg_code;
1087: --
1088: -- The primary key is invalid therefore we must error
1089: --
1090: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1091: fnd_message.raise_error;
1092: --
1093: end if;
1094: --

Line 1091: fnd_message.raise_error;

1087: --
1088: -- The primary key is invalid therefore we must error
1089: --
1090: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1091: fnd_message.raise_error;
1092: --
1093: end if;
1094: --
1095: close csr_leg_code;