DBA Data[Home] [Help]

APPS.BEN_LGE_BUS dependencies on FND_MESSAGE

Line 139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

135: p_effective_date => p_effective_date) then
136: --
137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_dflt_enrt_rl);
141: fnd_message.set_token('TYPE_ID',-32);
142: fnd_message.raise_error;
143: --

Line 140: fnd_message.set_token('ID',p_dflt_enrt_rl);

136: --
137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_dflt_enrt_rl);
141: fnd_message.set_token('TYPE_ID',-32);
142: fnd_message.raise_error;
143: --
144: end if;

Line 141: fnd_message.set_token('TYPE_ID',-32);

137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_dflt_enrt_rl);
141: fnd_message.set_token('TYPE_ID',-32);
142: fnd_message.raise_error;
143: --
144: end if;
145: --

Line 142: fnd_message.raise_error;

138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_dflt_enrt_rl);
141: fnd_message.set_token('TYPE_ID',-32);
142: fnd_message.raise_error;
143: --
144: end if;
145: --
146: end if;

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

206: p_effective_date => p_effective_date) then
207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
212: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
213: fnd_message.raise_error;
214: --

Line 211: fnd_message.set_token('FIELD','p_dflt_enrt_cd');

207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
212: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
213: fnd_message.raise_error;
214: --
215: end if;

Line 212: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');

208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
212: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
213: fnd_message.raise_error;
214: --
215: end if;
216: --

Line 213: fnd_message.raise_error;

209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
212: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
217: end if;

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_crnt_enrt_prclds_chg_flag');
283: fnd_message.set_token('TYPE','YES_NO');
284: fnd_message.raise_error;
285: --

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

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_crnt_enrt_prclds_chg_flag');
283: fnd_message.set_token('TYPE','YES_NO');
284: fnd_message.raise_error;
285: --
286: end if;

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

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_crnt_enrt_prclds_chg_flag');
283: fnd_message.set_token('TYPE','YES_NO');
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_crnt_enrt_prclds_chg_flag');
283: fnd_message.set_token('TYPE','YES_NO');
284: fnd_message.raise_error;
285: --
286: end if;
287: --
288: end if;

Line 354: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

350: p_effective_date => p_effective_date) then
351: --
352: -- raise error
353: --
354: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
355: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
356: fnd_message.set_token('TYPE_ID',-146);
357: fnd_message.raise_error;
358: --

Line 355: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);

351: --
352: -- raise error
353: --
354: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
355: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
356: fnd_message.set_token('TYPE_ID',-146);
357: fnd_message.raise_error;
358: --
359: end if;

Line 356: fnd_message.set_token('TYPE_ID',-146);

352: -- raise error
353: --
354: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
355: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
356: fnd_message.set_token('TYPE_ID',-146);
357: fnd_message.raise_error;
358: --
359: end if;
360: --

Line 357: fnd_message.raise_error;

353: --
354: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
355: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
356: fnd_message.set_token('TYPE_ID',-146);
357: fnd_message.raise_error;
358: --
359: end if;
360: --
361: end if;

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

421: p_effective_date => p_effective_date) then
422: --
423: -- raise error as does not exist as lookup
424: --
425: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
426: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
427: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
428: fnd_message.raise_error;
429: --

Line 426: fnd_message.set_token('FIELD','p_enrt_mthd_cd');

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

Line 427: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');

423: -- raise error as does not exist as lookup
424: --
425: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
426: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
427: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
428: fnd_message.raise_error;
429: --
430: end if;
431: --

Line 428: fnd_message.raise_error;

424: --
425: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
426: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
427: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
428: fnd_message.raise_error;
429: --
430: end if;
431: --
432: end if;

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

492: p_effective_date => p_effective_date) then
493: --
494: -- raise error as does not exist as lookup
495: --
496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
497: fnd_message.set_token('FIELD','p_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_ENRT');
499: fnd_message.raise_error;
500: --

Line 497: fnd_message.set_token('FIELD','p_enrt_cd');

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

Line 498: fnd_message.set_token('TYPE','BEN_ENRT');

494: -- raise error as does not exist as lookup
495: --
496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
497: fnd_message.set_token('FIELD','p_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_ENRT');
499: fnd_message.raise_error;
500: --
501: end if;
502: --

Line 499: fnd_message.raise_error;

495: --
496: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
497: fnd_message.set_token('FIELD','p_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_ENRT');
499: fnd_message.raise_error;
500: --
501: end if;
502: --
503: end if;

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

563: p_effective_date => p_effective_date) then
564: --
565: -- raise error as does not exist as lookup
566: --
567: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
568: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --

Line 568: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');

564: --
565: -- raise error as does not exist as lookup
566: --
567: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
568: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --
572: end if;

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

565: -- raise error as does not exist as lookup
566: --
567: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
568: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --
572: end if;
573: --

Line 570: fnd_message.raise_error;

566: --
567: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
568: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --
572: end if;
573: --
574: end if;

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

636: p_effective_date => p_effective_date) then
637: --
638: -- raise error
639: --
640: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
641: fnd_message.set_token('ID',p_enrt_rl);
642: fnd_message.set_token('TYPE_ID',-393);
643: fnd_message.raise_error;
644: --

Line 641: fnd_message.set_token('ID',p_enrt_rl);

637: --
638: -- raise error
639: --
640: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
641: fnd_message.set_token('ID',p_enrt_rl);
642: fnd_message.set_token('TYPE_ID',-393);
643: fnd_message.raise_error;
644: --
645: end if;

Line 642: fnd_message.set_token('TYPE_ID',-393);

638: -- raise error
639: --
640: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
641: fnd_message.set_token('ID',p_enrt_rl);
642: fnd_message.set_token('TYPE_ID',-393);
643: fnd_message.raise_error;
644: --
645: end if;
646: --

Line 643: fnd_message.raise_error;

639: --
640: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
641: fnd_message.set_token('ID',p_enrt_rl);
642: fnd_message.set_token('TYPE_ID',-393);
643: fnd_message.raise_error;
644: --
645: end if;
646: --
647: end if;

Line 715: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');

711: or not l_api_updating) then
712: --
713: if (p_enrt_cd = 'RL' and p_enrt_rl is null) then
714: --
715: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
716: fnd_message.raise_error;
717: --
718: end if;
719: --

Line 716: fnd_message.raise_error;

712: --
713: if (p_enrt_cd = 'RL' and p_enrt_rl is null) then
714: --
715: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
716: fnd_message.raise_error;
717: --
718: end if;
719: --
720: if nvl(p_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_enrt_rl is

Line 723: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

719: --
720: if nvl(p_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_enrt_rl is
721: not null then
722: --
723: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
724: fnd_message.raise_error;
725: --
726: end if;
727: --

Line 724: fnd_message.raise_error;

720: if nvl(p_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_enrt_rl is
721: not null then
722: --
723: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
724: fnd_message.raise_error;
725: --
726: end if;
727: --
728: end if;

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

737: or not l_api_updating) then
738: --
739: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_rl is null) then
740: --
741: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
742: fnd_message.raise_error;
743: --
744: end if;
745: --

Line 742: fnd_message.raise_error;

738: --
739: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_rl is null) then
740: --
741: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
742: fnd_message.raise_error;
743: --
744: end if;
745: --
746: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_rl is

Line 749: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

745: --
746: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_rl is
747: not null then
748: --
749: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
750: fnd_message.raise_error;
751: --
752: end if;
753: --

Line 750: fnd_message.raise_error;

746: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_rl is
747: not null then
748: --
749: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
750: fnd_message.raise_error;
751: --
752: end if;
753: --
754: end if;

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

859: --
860: -- An unhandled or unexpected error has occurred which
861: -- we must report
862: --
863: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
864: fnd_message.set_token('PROCEDURE', l_proc);
865: fnd_message.set_token('STEP','15');
866: fnd_message.raise_error;
867: End dt_update_validate;

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

860: -- An unhandled or unexpected error has occurred which
861: -- we must report
862: --
863: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
864: fnd_message.set_token('PROCEDURE', l_proc);
865: fnd_message.set_token('STEP','15');
866: fnd_message.raise_error;
867: End dt_update_validate;
868: --

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

861: -- we must report
862: --
863: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
864: fnd_message.set_token('PROCEDURE', l_proc);
865: fnd_message.set_token('STEP','15');
866: fnd_message.raise_error;
867: End dt_update_validate;
868: --
869: -- ----------------------------------------------------------------------------

Line 866: fnd_message.raise_error;

862: --
863: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
864: fnd_message.set_token('PROCEDURE', l_proc);
865: fnd_message.set_token('STEP','15');
866: fnd_message.raise_error;
867: End dt_update_validate;
868: --
869: -- ----------------------------------------------------------------------------
870: -- |--------------------------< dt_delete_validate >--------------------------|

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

955: --
956: -- A referential integrity check was violated therefore
957: -- we must error
958: --
959: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
960: fnd_message.set_token('TABLE_NAME', l_table_name);
961: fnd_message.raise_error;
962: When Others Then
963: --

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

956: -- A referential integrity check was violated therefore
957: -- we must error
958: --
959: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
960: fnd_message.set_token('TABLE_NAME', l_table_name);
961: fnd_message.raise_error;
962: When Others Then
963: --
964: -- An unhandled or unexpected error has occurred which

Line 961: fnd_message.raise_error;

957: -- we must error
958: --
959: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
960: fnd_message.set_token('TABLE_NAME', l_table_name);
961: fnd_message.raise_error;
962: When Others Then
963: --
964: -- An unhandled or unexpected error has occurred which
965: -- we must report

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

963: --
964: -- An unhandled or unexpected error has occurred which
965: -- we must report
966: --
967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
968: fnd_message.set_token('PROCEDURE', l_proc);
969: fnd_message.set_token('STEP','15');
970: fnd_message.raise_error;
971: End dt_delete_validate;

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

964: -- An unhandled or unexpected error has occurred which
965: -- we must report
966: --
967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
968: fnd_message.set_token('PROCEDURE', l_proc);
969: fnd_message.set_token('STEP','15');
970: fnd_message.raise_error;
971: End dt_delete_validate;
972: --

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

965: -- we must report
966: --
967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
968: fnd_message.set_token('PROCEDURE', l_proc);
969: fnd_message.set_token('STEP','15');
970: fnd_message.raise_error;
971: End dt_delete_validate;
972: --
973: -- ----------------------------------------------------------------------------

Line 970: fnd_message.raise_error;

966: --
967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
968: fnd_message.set_token('PROCEDURE', l_proc);
969: fnd_message.set_token('STEP','15');
970: fnd_message.raise_error;
971: End dt_delete_validate;
972: --
973: -- ----------------------------------------------------------------------------
974: -- |---------------------------< insert_validate >----------------------------|

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

1222: close csr_leg_code;
1223: --
1224: -- The primary key is invalid therefore we must error
1225: --
1226: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1227: fnd_message.raise_error;
1228: --
1229: end if;
1230: --

Line 1227: fnd_message.raise_error;

1223: --
1224: -- The primary key is invalid therefore we must error
1225: --
1226: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1227: fnd_message.raise_error;
1228: --
1229: end if;
1230: --
1231: close csr_leg_code;