DBA Data[Home] [Help]

APPS.BEN_COLLAPSE_LIFE_EVENT dependencies on FND_MESSAGE

Line 304: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');

300: p_assignment_id => l_ass_rec.assignment_id);
301: --
302: if l_outputs(l_outputs.first).value not in ('V','D') then
303: --
304: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
305: fnd_message.set_token('RL','p_events.eval_rl');
306: fnd_message.set_token('PROC',l_proc);
307: raise ben_manage_life_events.g_record_error;
308: --

Line 305: fnd_message.set_token('RL','p_events.eval_rl');

301: --
302: if l_outputs(l_outputs.first).value not in ('V','D') then
303: --
304: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
305: fnd_message.set_token('RL','p_events.eval_rl');
306: fnd_message.set_token('PROC',l_proc);
307: raise ben_manage_life_events.g_record_error;
308: --
309: end if;

Line 306: fnd_message.set_token('PROC',l_proc);

302: if l_outputs(l_outputs.first).value not in ('V','D') then
303: --
304: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
305: fnd_message.set_token('RL','p_events.eval_rl');
306: fnd_message.set_token('PROC',l_proc);
307: raise ben_manage_life_events.g_record_error;
308: --
309: end if;
310: --

Line 358: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');

354: --
355: -- Account for cases where formula returns an unknown
356: -- variable name
357: --
358: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
359: fnd_message.set_token('PROC',l_proc);
360: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
361: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
362: fnd_message.raise_error;

Line 359: fnd_message.set_token('PROC',l_proc);

355: -- Account for cases where formula returns an unknown
356: -- variable name
357: --
358: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
359: fnd_message.set_token('PROC',l_proc);
360: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
361: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
362: fnd_message.raise_error;
363: --

Line 360: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);

356: -- variable name
357: --
358: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
359: fnd_message.set_token('PROC',l_proc);
360: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
361: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
362: fnd_message.raise_error;
363: --
364: end if;

Line 361: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);

357: --
358: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
359: fnd_message.set_token('PROC',l_proc);
360: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
361: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
362: fnd_message.raise_error;
363: --
364: end if;
365: --

Line 362: fnd_message.raise_error;

358: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
359: fnd_message.set_token('PROC',l_proc);
360: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
361: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
362: fnd_message.raise_error;
363: --
364: end if;
365: --
366: -- Code for type casting errors from formula return variables

Line 372: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

368: exception
369: --
370: when others then
371: --
372: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
373: fnd_message.set_token('PROC',l_proc);
374: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
375: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
376: fnd_message.raise_error;

Line 373: fnd_message.set_token('PROC',l_proc);

369: --
370: when others then
371: --
372: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
373: fnd_message.set_token('PROC',l_proc);
374: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
375: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
376: fnd_message.raise_error;
377: --

Line 374: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);

370: when others then
371: --
372: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
373: fnd_message.set_token('PROC',l_proc);
374: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
375: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
376: fnd_message.raise_error;
377: --
378: end;

Line 375: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);

371: --
372: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
373: fnd_message.set_token('PROC',l_proc);
374: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
375: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
376: fnd_message.raise_error;
377: --
378: end;
379: --

Line 376: fnd_message.raise_error;

372: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
373: fnd_message.set_token('PROC',l_proc);
374: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
375: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
376: fnd_message.raise_error;
377: --
378: end;
379: --
380: elsif p_events.eval_ler_det_cd = 'ELED' then

Line 475: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');

471: l_bckdt_pil_count := l_bckdt_pil_count +1;
472: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl(l_bckdt_pil_count) := l_pil_rec.per_in_ler_id;
473: --End 6086392
474:
475: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
476: fnd_message.set_token('NAME',l_pil_rec.name);
477: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
478: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
479: benutils.write(fnd_message.get);

Line 476: fnd_message.set_token('NAME',l_pil_rec.name);

472: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl(l_bckdt_pil_count) := l_pil_rec.per_in_ler_id;
473: --End 6086392
474:
475: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
476: fnd_message.set_token('NAME',l_pil_rec.name);
477: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
478: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
479: benutils.write(fnd_message.get);
480: --

Line 477: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);

473: --End 6086392
474:
475: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
476: fnd_message.set_token('NAME',l_pil_rec.name);
477: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
478: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
479: benutils.write(fnd_message.get);
480: --
481: end loop;

Line 478: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);

474:
475: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
476: fnd_message.set_token('NAME',l_pil_rec.name);
477: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
478: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
479: benutils.write(fnd_message.get);
480: --
481: end loop;
482: close get_all_fut_pils;

Line 479: benutils.write(fnd_message.get);

475: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
476: fnd_message.set_token('NAME',l_pil_rec.name);
477: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
478: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
479: benutils.write(fnd_message.get);
480: --
481: end loop;
482: close get_all_fut_pils;
483: --

Line 491: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');

487: p_bckt_stat_cd => 'VOIDD',
488: p_business_group_id => p_business_group_id,
489: p_effective_date => p_effective_date);
490: --
491: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
492: fnd_message.set_token('NAME',l_ler_rec.name);
493: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
494: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
495: benutils.write(fnd_message.get);

Line 492: fnd_message.set_token('NAME',l_ler_rec.name);

488: p_business_group_id => p_business_group_id,
489: p_effective_date => p_effective_date);
490: --
491: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
492: fnd_message.set_token('NAME',l_ler_rec.name);
493: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
494: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
495: benutils.write(fnd_message.get);
496: --

Line 493: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);

489: p_effective_date => p_effective_date);
490: --
491: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
492: fnd_message.set_token('NAME',l_ler_rec.name);
493: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
494: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
495: benutils.write(fnd_message.get);
496: --
497: g_rec.person_id := p_person_id;

Line 494: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);

490: --
491: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
492: fnd_message.set_token('NAME',l_ler_rec.name);
493: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
494: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
495: benutils.write(fnd_message.get);
496: --
497: g_rec.person_id := p_person_id;
498: g_rec.ler_id := g_included_events(l_count).ler_id;

Line 495: benutils.write(fnd_message.get);

491: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
492: fnd_message.set_token('NAME',l_ler_rec.name);
493: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
494: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
495: benutils.write(fnd_message.get);
496: --
497: g_rec.person_id := p_person_id;
498: g_rec.ler_id := g_included_events(l_count).ler_id;
499: g_rec.lf_evt_ocrd_dt := g_included_events(l_count).lf_evt_ocrd_dt;

Line 530: fnd_message.set_name('BEN','BEN_92434_PTNL_LER_VOIDED');

526: p_effective_date => p_effective_date,
527: p_object_version_number => g_included_events(l_count).
528: object_version_number);
529: --
530: fnd_message.set_name('BEN','BEN_92434_PTNL_LER_VOIDED');
531: fnd_message.set_token('NAME',l_ler_rec.name);
532: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
533: lf_evt_ocrd_dt);
534: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).

Line 531: fnd_message.set_token('NAME',l_ler_rec.name);

527: p_object_version_number => g_included_events(l_count).
528: object_version_number);
529: --
530: fnd_message.set_name('BEN','BEN_92434_PTNL_LER_VOIDED');
531: fnd_message.set_token('NAME',l_ler_rec.name);
532: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
533: lf_evt_ocrd_dt);
534: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
535: ntfn_dt);

Line 532: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).

528: object_version_number);
529: --
530: fnd_message.set_name('BEN','BEN_92434_PTNL_LER_VOIDED');
531: fnd_message.set_token('NAME',l_ler_rec.name);
532: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
533: lf_evt_ocrd_dt);
534: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
535: ntfn_dt);
536: benutils.write(fnd_message.get);

Line 534: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).

530: fnd_message.set_name('BEN','BEN_92434_PTNL_LER_VOIDED');
531: fnd_message.set_token('NAME',l_ler_rec.name);
532: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
533: lf_evt_ocrd_dt);
534: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
535: ntfn_dt);
536: benutils.write(fnd_message.get);
537: --
538: elsif l_operation = 'D' then

Line 536: benutils.write(fnd_message.get);

532: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
533: lf_evt_ocrd_dt);
534: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
535: ntfn_dt);
536: benutils.write(fnd_message.get);
537: --
538: elsif l_operation = 'D' then
539: --
540: ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per

Line 547: fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');

543: p_effective_date => p_effective_date,
544: p_object_version_number => g_included_events(l_count).
545: object_version_number);
546: --
547: fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');
548: fnd_message.set_token('NAME',l_ler_rec.name);
549: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
550: lf_evt_ocrd_dt);
551: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).

Line 548: fnd_message.set_token('NAME',l_ler_rec.name);

544: p_object_version_number => g_included_events(l_count).
545: object_version_number);
546: --
547: fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');
548: fnd_message.set_token('NAME',l_ler_rec.name);
549: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
550: lf_evt_ocrd_dt);
551: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
552: ntfn_dt);

Line 549: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).

545: object_version_number);
546: --
547: fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');
548: fnd_message.set_token('NAME',l_ler_rec.name);
549: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
550: lf_evt_ocrd_dt);
551: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
552: ntfn_dt);
553: benutils.write(fnd_message.get);

Line 551: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).

547: fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');
548: fnd_message.set_token('NAME',l_ler_rec.name);
549: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
550: lf_evt_ocrd_dt);
551: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
552: ntfn_dt);
553: benutils.write(fnd_message.get);
554: --
555: end if;

Line 553: benutils.write(fnd_message.get);

549: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
550: lf_evt_ocrd_dt);
551: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
552: ntfn_dt);
553: benutils.write(fnd_message.get);
554: --
555: end if;
556: --
557: end if;