DBA Data[Home] [Help]

APPS.BEN_TTP_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 199: fnd_message.set_name('BEN','BEN_92263_TTLPRTT_MLTCD');

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:

Line 200: fnd_message.raise_error;

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;

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_prtt_det_cd');
358: fnd_message.set_token('TYPE','BEN_PRTT_DET');
359: fnd_message.raise_error;
360: --

Line 357: fnd_message.set_token('FIELD','p_prtt_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_prtt_det_cd');
358: fnd_message.set_token('TYPE','BEN_PRTT_DET');
359: fnd_message.raise_error;
360: --
361: end if;

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

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

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

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_prtt_num_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_prtt_num_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_prtt_num_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_prtt_num_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_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;

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_prtt_num_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_prtt_num_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_prtt_num_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_prtt_num_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_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;

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 646: fnd_message.set_name('BEN','BEN_92259_TTLPRTT_CVGVOL_EXCL2');

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

Line 647: fnd_message.raise_error;

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;

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

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

Line 695: fnd_message.raise_error;

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

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

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

Line 743: fnd_message.raise_error;

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

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

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

Line 805: fnd_message.raise_error;

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;

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

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

Line 818: fnd_message.raise_error;

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

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

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

Line 824: fnd_message.raise_error;

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

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

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

Line 835: fnd_message.raise_error;

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

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

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

Line 841: fnd_message.raise_error;

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

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 1325: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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

Line 1326: fnd_message.raise_error;

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;