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