DBA Data[Home] [Help]

APPS.BEN_LCT_BUS dependencies on FND_MESSAGE

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

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_tco_chg_enrt_cd');
139: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
140: fnd_message.raise_error;
141: --

Line 138: fnd_message.set_token('FIELD','p_tco_chg_enrt_cd');

134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_tco_chg_enrt_cd');
139: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
140: fnd_message.raise_error;
141: --
142: end if;

Line 139: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');

135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_tco_chg_enrt_cd');
139: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
140: fnd_message.raise_error;
141: --
142: end if;
143: --

Line 140: fnd_message.raise_error;

136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_tco_chg_enrt_cd');
139: fnd_message.set_token('TYPE','BEN_TCO_CHG_ENRT');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;

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

206: p_effective_date => p_effective_date) then
207: --
208: -- raise error
209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_enrt_rl);
212: fnd_message.set_token('TYPE_ID',-393);
213: fnd_message.raise_error;
214: --

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

207: --
208: -- raise error
209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_enrt_rl);
212: fnd_message.set_token('TYPE_ID',-393);
213: fnd_message.raise_error;
214: --
215: end if;

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

208: -- raise error
209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_enrt_rl);
212: fnd_message.set_token('TYPE_ID',-393);
213: fnd_message.raise_error;
214: --
215: end if;
216: --

Line 213: fnd_message.raise_error;

209: --
210: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
211: fnd_message.set_token('ID',p_enrt_rl);
212: fnd_message.set_token('TYPE_ID',-393);
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_enrt_mthd_cd');
283: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
284: fnd_message.raise_error;
285: --

Line 282: fnd_message.set_token('FIELD','p_enrt_mthd_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_enrt_mthd_cd');
283: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
284: fnd_message.raise_error;
285: --
286: end if;

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

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_enrt_mthd_cd');
283: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
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_enrt_mthd_cd');
283: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
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_enrt_cd');
354: fnd_message.set_token('TYPE','BEN_ENRT');
355: fnd_message.raise_error;
356: --

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

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_enrt_cd');
354: fnd_message.set_token('TYPE','BEN_ENRT');
355: fnd_message.raise_error;
356: --
357: end if;

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

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_enrt_cd');
354: fnd_message.set_token('TYPE','BEN_ENRT');
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_enrt_cd');
354: fnd_message.set_token('TYPE','BEN_ENRT');
355: fnd_message.raise_error;
356: --
357: end if;
358: --
359: end if;

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

421: p_effective_date => p_effective_date) then
422: --
423: -- raise error
424: --
425: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
426: fnd_message.set_token('ID',p_dflt_enrt_rl);
427: fnd_message.set_token('TYPE_ID',-32);
428: fnd_message.raise_error;
429: --

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

422: --
423: -- raise error
424: --
425: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
426: fnd_message.set_token('ID',p_dflt_enrt_rl);
427: fnd_message.set_token('TYPE_ID',-32);
428: fnd_message.raise_error;
429: --
430: end if;

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

423: -- raise error
424: --
425: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
426: fnd_message.set_token('ID',p_dflt_enrt_rl);
427: fnd_message.set_token('TYPE_ID',-32);
428: fnd_message.raise_error;
429: --
430: end if;
431: --

Line 428: fnd_message.raise_error;

424: --
425: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
426: fnd_message.set_token('ID',p_dflt_enrt_rl);
427: fnd_message.set_token('TYPE_ID',-32);
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_dflt_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
499: fnd_message.raise_error;
500: --

Line 497: fnd_message.set_token('FIELD','p_dflt_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_dflt_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
499: fnd_message.raise_error;
500: --
501: end if;

Line 498: fnd_message.set_token('TYPE','BEN_DFLT_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_dflt_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_DFLT_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_dflt_enrt_cd');
498: fnd_message.set_token('TYPE','BEN_DFLT_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_dflt_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --

Line 568: fnd_message.set_token('FIELD','p_dflt_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_dflt_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_dflt_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_dflt_flag');
569: fnd_message.set_token('TYPE','YES_NO');
570: fnd_message.raise_error;
571: --
572: end if;
573: --
574: end if;

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

634: p_effective_date => p_effective_date) then
635: --
636: -- raise error as does not exist as lookup
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
640: fnd_message.set_token('TYPE','YES_NO');
641: fnd_message.raise_error;
642: --

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

635: --
636: -- raise error as does not exist as lookup
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
640: fnd_message.set_token('TYPE','YES_NO');
641: fnd_message.raise_error;
642: --
643: end if;

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

636: -- raise error as does not exist as lookup
637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
640: fnd_message.set_token('TYPE','YES_NO');
641: fnd_message.raise_error;
642: --
643: end if;
644: --

Line 641: fnd_message.raise_error;

637: --
638: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
639: fnd_message.set_token('FIELD','p_stl_elig_cant_chg_flag');
640: fnd_message.set_token('TYPE','YES_NO');
641: fnd_message.raise_error;
642: --
643: end if;
644: --
645: end if;

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

705: p_effective_date => p_effective_date) then
706: --
707: -- raise error as does not exist as lookup
708: --
709: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
710: fnd_message.set_token('FIELD','p_crnt_enrt_prclds_chg_flag');
711: fnd_message.set_token('TYPE','YES_NO');
712: fnd_message.raise_error;
713: --

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

706: --
707: -- raise error as does not exist as lookup
708: --
709: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
710: fnd_message.set_token('FIELD','p_crnt_enrt_prclds_chg_flag');
711: fnd_message.set_token('TYPE','YES_NO');
712: fnd_message.raise_error;
713: --
714: end if;

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

707: -- raise error as does not exist as lookup
708: --
709: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
710: fnd_message.set_token('FIELD','p_crnt_enrt_prclds_chg_flag');
711: fnd_message.set_token('TYPE','YES_NO');
712: fnd_message.raise_error;
713: --
714: end if;
715: --

Line 712: fnd_message.raise_error;

708: --
709: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
710: fnd_message.set_token('FIELD','p_crnt_enrt_prclds_chg_flag');
711: fnd_message.set_token('TYPE','YES_NO');
712: fnd_message.raise_error;
713: --
714: end if;
715: --
716: end if;

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

821: --
822: -- An unhandled or unexpected error has occurred which
823: -- we must report
824: --
825: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
826: fnd_message.set_token('PROCEDURE', l_proc);
827: fnd_message.set_token('STEP','15');
828: fnd_message.raise_error;
829: End dt_update_validate;

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

822: -- An unhandled or unexpected error has occurred which
823: -- we must report
824: --
825: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
826: fnd_message.set_token('PROCEDURE', l_proc);
827: fnd_message.set_token('STEP','15');
828: fnd_message.raise_error;
829: End dt_update_validate;
830: --

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

823: -- we must report
824: --
825: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
826: fnd_message.set_token('PROCEDURE', l_proc);
827: fnd_message.set_token('STEP','15');
828: fnd_message.raise_error;
829: End dt_update_validate;
830: --
831: -- ----------------------------------------------------------------------------

Line 828: fnd_message.raise_error;

824: --
825: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
826: fnd_message.set_token('PROCEDURE', l_proc);
827: fnd_message.set_token('STEP','15');
828: fnd_message.raise_error;
829: End dt_update_validate;
830: --
831: -- ----------------------------------------------------------------------------
832: -- |--------------------------< dt_delete_validate >--------------------------|

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

917: --
918: -- A referential integrity check was violated therefore
919: -- we must error
920: --
921: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
922: fnd_message.set_token('TABLE_NAME', l_table_name);
923: fnd_message.raise_error;
924: When Others Then
925: --

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

918: -- A referential integrity check was violated therefore
919: -- we must error
920: --
921: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
922: fnd_message.set_token('TABLE_NAME', l_table_name);
923: fnd_message.raise_error;
924: When Others Then
925: --
926: -- An unhandled or unexpected error has occurred which

Line 923: fnd_message.raise_error;

919: -- we must error
920: --
921: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
922: fnd_message.set_token('TABLE_NAME', l_table_name);
923: fnd_message.raise_error;
924: When Others Then
925: --
926: -- An unhandled or unexpected error has occurred which
927: -- we must report

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

925: --
926: -- An unhandled or unexpected error has occurred which
927: -- we must report
928: --
929: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
930: fnd_message.set_token('PROCEDURE', l_proc);
931: fnd_message.set_token('STEP','15');
932: fnd_message.raise_error;
933: End dt_delete_validate;

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

926: -- An unhandled or unexpected error has occurred which
927: -- we must report
928: --
929: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
930: fnd_message.set_token('PROCEDURE', l_proc);
931: fnd_message.set_token('STEP','15');
932: fnd_message.raise_error;
933: End dt_delete_validate;
934: --

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

927: -- we must report
928: --
929: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
930: fnd_message.set_token('PROCEDURE', l_proc);
931: fnd_message.set_token('STEP','15');
932: fnd_message.raise_error;
933: End dt_delete_validate;
934: --
935: -- ----------------------------------------------------------------------------

Line 932: fnd_message.raise_error;

928: --
929: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
930: fnd_message.set_token('PROCEDURE', l_proc);
931: fnd_message.set_token('STEP','15');
932: fnd_message.raise_error;
933: End dt_delete_validate;
934: --
935: -- ----------------------------------------------------------------------------
936: -- |---------------------------< insert_validate >----------------------------|

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

1176: close csr_leg_code;
1177: --
1178: -- The primary key is invalid therefore we must error
1179: --
1180: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1181: fnd_message.raise_error;
1182: --
1183: end if;
1184: --

Line 1181: fnd_message.raise_error;

1177: --
1178: -- The primary key is invalid therefore we must error
1179: --
1180: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1181: fnd_message.raise_error;
1182: --
1183: end if;
1184: --
1185: close csr_leg_code;