DBA Data[Home] [Help]

APPS.BEN_ETP_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 210: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');

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

Line 211: fnd_message.raise_error;

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;

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

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

Line 282: fnd_message.set_token('FIELD','p_prtt_det_cd');

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;

Line 283: fnd_message.set_token('TYPE','BEN_PRTT_DET');

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

Line 284: fnd_message.raise_error;

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;

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

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

Line 353: fnd_message.set_token('FIELD','p_no_mx_prtt_num_apls_flag');

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;

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

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

Line 355: fnd_message.raise_error;

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;

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

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

Line 424: fnd_message.set_token('FIELD','p_no_mn_prtt_num_apls_flag');

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;

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

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

Line 426: fnd_message.raise_error;

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;

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

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

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

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;

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

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

Line 497: fnd_message.raise_error;

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;

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

Line 605: fnd_message.raise_error;

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;

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

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

Line 618: fnd_message.raise_error;

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

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

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

Line 624: fnd_message.raise_error;

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

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

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

Line 635: fnd_message.raise_error;

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

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

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

Line 641: fnd_message.raise_error;

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

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

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;

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

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

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

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

Line 742: fnd_message.raise_error;

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

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

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

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

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

Line 837: fnd_message.raise_error;

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

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

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;

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

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

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

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

Line 846: fnd_message.raise_error;

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

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

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

Line 1090: fnd_message.raise_error;

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;