DBA Data[Home] [Help]

APPS.BEN_TCV_BUS dependencies on FND_MESSAGE

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

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

Line 129: fnd_message.raise_error;

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

Line 201: fnd_message.set_name('BEN','BEN_92264_TTLCVG_MLTCD');

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:

Line 202: fnd_message.raise_error;

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;

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

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

Line 286: fnd_message.raise_error;

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;

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

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

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

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;

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

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

Line 359: fnd_message.raise_error;

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;

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

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

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

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;

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

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

Line 430: fnd_message.raise_error;

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;

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

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

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

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;

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

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

Line 501: fnd_message.raise_error;

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;

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

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

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

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;

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

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

Line 572: fnd_message.raise_error;

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;

Line 644: fnd_message.set_name('BEN','BEN_92258_TTLPRTT_CVGVOL_EXCL1');

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

Line 645: fnd_message.raise_error;

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;

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

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

Line 694: fnd_message.raise_error;

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

Line 741: fnd_message.set_name('BEN','BEN_91142_MIN_LESS_NOT_EQ_MAX');

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

Line 742: fnd_message.raise_error;

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

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

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

Line 804: fnd_message.raise_error;

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;

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

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

Line 817: fnd_message.raise_error;

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

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

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

Line 823: fnd_message.raise_error;

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

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

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

Line 834: fnd_message.raise_error;

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

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

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

Line 840: fnd_message.raise_error;

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

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

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;

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

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

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

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

Line 942: fnd_message.raise_error;

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

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

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

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

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

Line 1037: fnd_message.raise_error;

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

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

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;

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

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

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

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

Line 1046: fnd_message.raise_error;

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

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

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

Line 1324: fnd_message.raise_error;

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;