DBA Data[Home] [Help]

APPS.BEN_LPR_BUS dependencies on FND_MESSAGE

Line 155: fnd_message.set_name('BEN','BEN_93794_FUTURE_LE_PLAN_EXIST');

151: --
152: -- raise error as UK1 is violated
153: --
154: --Bug 2960193 Created message and updated message name in call to set_name
155: fnd_message.set_name('BEN','BEN_93794_FUTURE_LE_PLAN_EXIST');
156: fnd_message.raise_error;
157: --Bug 2960193
158: --
159: end if;

Line 156: fnd_message.raise_error;

152: -- raise error as UK1 is violated
153: --
154: --Bug 2960193 Created message and updated message name in call to set_name
155: fnd_message.set_name('BEN','BEN_93794_FUTURE_LE_PLAN_EXIST');
156: fnd_message.raise_error;
157: --Bug 2960193
158: --
159: end if;
160: --

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

224: p_effective_date => p_effective_date) then
225: --
226: -- raise error as does not exist as lookup
227: --
228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
229: fnd_message.set_token('FIELD', 'p_enrt_cd');
230: fnd_message.set_token('TYPE', 'BEN_ENRT');
231: fnd_message.raise_error;
232: --

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

225: --
226: -- raise error as does not exist as lookup
227: --
228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
229: fnd_message.set_token('FIELD', 'p_enrt_cd');
230: fnd_message.set_token('TYPE', 'BEN_ENRT');
231: fnd_message.raise_error;
232: --
233: end if;

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

226: -- raise error as does not exist as lookup
227: --
228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
229: fnd_message.set_token('FIELD', 'p_enrt_cd');
230: fnd_message.set_token('TYPE', 'BEN_ENRT');
231: fnd_message.raise_error;
232: --
233: end if;
234: --

Line 231: fnd_message.raise_error;

227: --
228: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
229: fnd_message.set_token('FIELD', 'p_enrt_cd');
230: fnd_message.set_token('TYPE', 'BEN_ENRT');
231: fnd_message.raise_error;
232: --
233: end if;
234: --
235: end if;

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

295: p_effective_date => p_effective_date) then
296: --
297: -- raise error as does not exist as lookup
298: --
299: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
300: fnd_message.set_token('FIELD', 'p_stl_elig_cant_chg_flag');
301: fnd_message.set_token('TYPE', 'YES_NO');
302: fnd_message.raise_error;
303: --

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

296: --
297: -- raise error as does not exist as lookup
298: --
299: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
300: fnd_message.set_token('FIELD', 'p_stl_elig_cant_chg_flag');
301: fnd_message.set_token('TYPE', 'YES_NO');
302: fnd_message.raise_error;
303: --
304: end if;

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

297: -- raise error as does not exist as lookup
298: --
299: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
300: fnd_message.set_token('FIELD', 'p_stl_elig_cant_chg_flag');
301: fnd_message.set_token('TYPE', 'YES_NO');
302: fnd_message.raise_error;
303: --
304: end if;
305: --

Line 302: fnd_message.raise_error;

298: --
299: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
300: fnd_message.set_token('FIELD', 'p_stl_elig_cant_chg_flag');
301: fnd_message.set_token('TYPE', 'YES_NO');
302: fnd_message.raise_error;
303: --
304: end if;
305: --
306: end if;

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

366: p_effective_date => p_effective_date) then
367: --
368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
372: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
373: fnd_message.raise_error;
374: --

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

367: --
368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
372: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
373: fnd_message.raise_error;
374: --
375: end if;

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

368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
372: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
373: fnd_message.raise_error;
374: --
375: end if;
376: --

Line 373: fnd_message.raise_error;

369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD', 'p_enrt_mthd_cd');
372: fnd_message.set_token('TYPE', 'BEN_ENRT_MTHD');
373: fnd_message.raise_error;
374: --
375: end if;
376: --
377: end if;

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

437: p_effective_date => p_effective_date) then
438: --
439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', 'p_dflt_enrt_cd');
443: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
444: fnd_message.raise_error;
445: --

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

438: --
439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', 'p_dflt_enrt_cd');
443: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
444: fnd_message.raise_error;
445: --
446: end if;

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

439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', 'p_dflt_enrt_cd');
443: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
444: fnd_message.raise_error;
445: --
446: end if;
447: --

Line 444: fnd_message.raise_error;

440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', 'p_dflt_enrt_cd');
443: fnd_message.set_token('TYPE', 'BEN_DFLT_ENRT');
444: fnd_message.raise_error;
445: --
446: end if;
447: --
448: end if;

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

530: close c1;
531: --
532: -- raise error
533: --
534: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
535: fnd_message.set_token('ID',p_enrt_rl);
536: fnd_message.set_token('TYPE_ID',-393);
537: fnd_message.raise_error;
538: --

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

531: --
532: -- raise error
533: --
534: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
535: fnd_message.set_token('ID',p_enrt_rl);
536: fnd_message.set_token('TYPE_ID',-393);
537: fnd_message.raise_error;
538: --
539: end if;

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

532: -- raise error
533: --
534: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
535: fnd_message.set_token('ID',p_enrt_rl);
536: fnd_message.set_token('TYPE_ID',-393);
537: fnd_message.raise_error;
538: --
539: end if;
540: --

Line 537: fnd_message.raise_error;

533: --
534: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
535: fnd_message.set_token('ID',p_enrt_rl);
536: fnd_message.set_token('TYPE_ID',-393);
537: fnd_message.raise_error;
538: --
539: end if;
540: --
541: close c1;

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

625: close c1;
626: --
627: -- raise error
628: --
629: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
630: fnd_message.set_token('ID',p_dflt_enrt_rl);
631: fnd_message.set_token('TYPE_ID',-32);
632: fnd_message.raise_error;
633: --

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

626: --
627: -- raise error
628: --
629: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
630: fnd_message.set_token('ID',p_dflt_enrt_rl);
631: fnd_message.set_token('TYPE_ID',-32);
632: fnd_message.raise_error;
633: --
634: end if;

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

627: -- raise error
628: --
629: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
630: fnd_message.set_token('ID',p_dflt_enrt_rl);
631: fnd_message.set_token('TYPE_ID',-32);
632: fnd_message.raise_error;
633: --
634: end if;
635: --

Line 632: fnd_message.raise_error;

628: --
629: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
630: fnd_message.set_token('ID',p_dflt_enrt_rl);
631: fnd_message.set_token('TYPE_ID',-32);
632: fnd_message.raise_error;
633: --
634: end if;
635: --
636: close c1;

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

718: p_effective_date => p_effective_date) then
719: --
720: -- raise error as does not exist as lookup
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('FIELD', 'p_dflt_flag');
724: fnd_message.set_token('TYPE', 'YES_NO');
725: fnd_message.raise_error;
726: --

Line 723: fnd_message.set_token('FIELD', 'p_dflt_flag');

719: --
720: -- raise error as does not exist as lookup
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('FIELD', 'p_dflt_flag');
724: fnd_message.set_token('TYPE', 'YES_NO');
725: fnd_message.raise_error;
726: --
727: end if;

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

720: -- raise error as does not exist as lookup
721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('FIELD', 'p_dflt_flag');
724: fnd_message.set_token('TYPE', 'YES_NO');
725: fnd_message.raise_error;
726: --
727: end if;
728: --

Line 725: fnd_message.raise_error;

721: --
722: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
723: fnd_message.set_token('FIELD', 'p_dflt_flag');
724: fnd_message.set_token('TYPE', 'YES_NO');
725: fnd_message.raise_error;
726: --
727: end if;
728: --
729: -- COMMENTING OUT PER BUG# 849

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

735: -- close chk_unique;
736: -- --
737: -- -- raise error as UK1 is violated
738: -- --
739: -- fnd_message.set_name('PAY','ONLY_ONE_DEFAULT');
740: -- fnd_message.raise_error;
741: -- --
742: -- end if;
743: -- --

Line 740: -- fnd_message.raise_error;

736: -- --
737: -- -- raise error as UK1 is violated
738: -- --
739: -- fnd_message.set_name('PAY','ONLY_ONE_DEFAULT');
740: -- fnd_message.raise_error;
741: -- --
742: -- end if;
743: -- --
744: -- close chk_unique;

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

807: p_effective_date => p_effective_date) then
808: --
809: -- raise error as does not exist as lookup
810: --
811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
812: fnd_message.set_token('FIELD', 'p_crnt_enrt_prclds_chg_flag');
813: fnd_message.set_token('TYPE', 'YES_NO');
814: fnd_message.raise_error;
815: --

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

808: --
809: -- raise error as does not exist as lookup
810: --
811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
812: fnd_message.set_token('FIELD', 'p_crnt_enrt_prclds_chg_flag');
813: fnd_message.set_token('TYPE', 'YES_NO');
814: fnd_message.raise_error;
815: --
816: end if;

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

809: -- raise error as does not exist as lookup
810: --
811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
812: fnd_message.set_token('FIELD', 'p_crnt_enrt_prclds_chg_flag');
813: fnd_message.set_token('TYPE', 'YES_NO');
814: fnd_message.raise_error;
815: --
816: end if;
817: --

Line 814: fnd_message.raise_error;

810: --
811: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
812: fnd_message.set_token('FIELD', 'p_crnt_enrt_prclds_chg_flag');
813: fnd_message.set_token('TYPE', 'YES_NO');
814: fnd_message.raise_error;
815: --
816: end if;
817: --
818: end if;

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

879: p_effective_date => p_effective_date) then
880: --
881: -- raise error as does not exist as lookup
882: --
883: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
884: fnd_message.set_token('FIELD', 'p_tco_chg_enrt_cd');
885: fnd_message.set_token('TYPE', 'BEN_TCO_CHG_ENRT');
886: fnd_message.raise_error;
887: --

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

880: --
881: -- raise error as does not exist as lookup
882: --
883: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
884: fnd_message.set_token('FIELD', 'p_tco_chg_enrt_cd');
885: fnd_message.set_token('TYPE', 'BEN_TCO_CHG_ENRT');
886: fnd_message.raise_error;
887: --
888: end if;

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

881: -- raise error as does not exist as lookup
882: --
883: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
884: fnd_message.set_token('FIELD', 'p_tco_chg_enrt_cd');
885: fnd_message.set_token('TYPE', 'BEN_TCO_CHG_ENRT');
886: fnd_message.raise_error;
887: --
888: end if;
889: --

Line 886: fnd_message.raise_error;

882: --
883: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
884: fnd_message.set_token('FIELD', 'p_tco_chg_enrt_cd');
885: fnd_message.set_token('TYPE', 'BEN_TCO_CHG_ENRT');
886: fnd_message.raise_error;
887: --
888: end if;
889: --
890: end if;

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

972: close c1;
973: --
974: -- raise error
975: --
976: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
977: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
978: fnd_message.set_token('TYPE_ID',-146);
979: fnd_message.raise_error;
980: --

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

973: --
974: -- raise error
975: --
976: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
977: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
978: fnd_message.set_token('TYPE_ID',-146);
979: fnd_message.raise_error;
980: --
981: end if;

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

974: -- raise error
975: --
976: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
977: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
978: fnd_message.set_token('TYPE_ID',-146);
979: fnd_message.raise_error;
980: --
981: end if;
982: --

Line 979: fnd_message.raise_error;

975: --
976: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
977: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
978: fnd_message.set_token('TYPE_ID',-146);
979: fnd_message.raise_error;
980: --
981: end if;
982: --
983: close c1;

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

1090: --
1091: -- An unhandled or unexpected error has occurred which
1092: -- we must report
1093: --
1094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1095: fnd_message.set_token('PROCEDURE', l_proc);
1096: fnd_message.set_token('STEP','15');
1097: fnd_message.raise_error;
1098: End dt_update_validate;

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

1091: -- An unhandled or unexpected error has occurred which
1092: -- we must report
1093: --
1094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1095: fnd_message.set_token('PROCEDURE', l_proc);
1096: fnd_message.set_token('STEP','15');
1097: fnd_message.raise_error;
1098: End dt_update_validate;
1099: --

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

1092: -- we must report
1093: --
1094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1095: fnd_message.set_token('PROCEDURE', l_proc);
1096: fnd_message.set_token('STEP','15');
1097: fnd_message.raise_error;
1098: End dt_update_validate;
1099: --
1100: -- ----------------------------------------------------------------------------

Line 1097: fnd_message.raise_error;

1093: --
1094: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1095: fnd_message.set_token('PROCEDURE', l_proc);
1096: fnd_message.set_token('STEP','15');
1097: fnd_message.raise_error;
1098: End dt_update_validate;
1099: --
1100: -- ----------------------------------------------------------------------------
1101: -- |--------------------------< dt_delete_validate >--------------------------|

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

1200: --
1201: -- An unhandled or unexpected error has occurred which
1202: -- we must report
1203: --
1204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1205: fnd_message.set_token('PROCEDURE', l_proc);
1206: fnd_message.set_token('STEP','15');
1207: fnd_message.raise_error;
1208: End dt_delete_validate;

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

1201: -- An unhandled or unexpected error has occurred which
1202: -- we must report
1203: --
1204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1205: fnd_message.set_token('PROCEDURE', l_proc);
1206: fnd_message.set_token('STEP','15');
1207: fnd_message.raise_error;
1208: End dt_delete_validate;
1209: --

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

1202: -- we must report
1203: --
1204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1205: fnd_message.set_token('PROCEDURE', l_proc);
1206: fnd_message.set_token('STEP','15');
1207: fnd_message.raise_error;
1208: End dt_delete_validate;
1209: --
1210: -- ----------------------------------------------------------------------------

Line 1207: fnd_message.raise_error;

1203: --
1204: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1205: fnd_message.set_token('PROCEDURE', l_proc);
1206: fnd_message.set_token('STEP','15');
1207: fnd_message.raise_error;
1208: End dt_delete_validate;
1209: --
1210: -- ----------------------------------------------------------------------------
1211: -- |---------------------------< insert_validate >----------------------------|

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

1493: close csr_leg_code;
1494: --
1495: -- The primary key is invalid therefore we must error
1496: --
1497: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1498: fnd_message.raise_error;
1499: --
1500: end if;
1501: --

Line 1498: fnd_message.raise_error;

1494: --
1495: -- The primary key is invalid therefore we must error
1496: --
1497: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1498: fnd_message.raise_error;
1499: --
1500: end if;
1501: --
1502: close csr_leg_code;