DBA Data[Home] [Help]

APPS.BEN_COLLAPSE_LIFE_EVENT dependencies on FND_MESSAGE

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

341: p_assignment_id => l_ass_rec.assignment_id);
342: --
343: if l_outputs(l_outputs.first).value not in ('V','D') then
344: --
345: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
346: fnd_message.set_token('RL','p_events.eval_rl');
347: fnd_message.set_token('PROC',l_proc);
348: raise ben_manage_life_events.g_record_error;
349: --

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

342: --
343: if l_outputs(l_outputs.first).value not in ('V','D') then
344: --
345: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
346: fnd_message.set_token('RL','p_events.eval_rl');
347: fnd_message.set_token('PROC',l_proc);
348: raise ben_manage_life_events.g_record_error;
349: --
350: end if;

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

343: if l_outputs(l_outputs.first).value not in ('V','D') then
344: --
345: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
346: fnd_message.set_token('RL','p_events.eval_rl');
347: fnd_message.set_token('PROC',l_proc);
348: raise ben_manage_life_events.g_record_error;
349: --
350: end if;
351: --

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

397: --
398: -- Account for cases where formula returns an unknown
399: -- variable name
400: --
401: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
402: fnd_message.set_token('PROC',l_proc);
403: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
404: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
405: fnd_message.raise_error;

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

398: -- Account for cases where formula returns an unknown
399: -- variable name
400: --
401: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
402: fnd_message.set_token('PROC',l_proc);
403: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
404: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
405: fnd_message.raise_error;
406: --

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

399: -- variable name
400: --
401: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
402: fnd_message.set_token('PROC',l_proc);
403: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
404: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
405: fnd_message.raise_error;
406: --
407: end if;

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

400: --
401: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
402: fnd_message.set_token('PROC',l_proc);
403: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
404: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
405: fnd_message.raise_error;
406: --
407: end if;
408: --

Line 405: fnd_message.raise_error;

401: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
402: fnd_message.set_token('PROC',l_proc);
403: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
404: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
405: fnd_message.raise_error;
406: --
407: end if;
408: --
409: -- Code for type casting errors from formula return variables

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

411: exception
412: --
413: when others then
414: --
415: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
416: fnd_message.set_token('PROC',l_proc);
417: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
418: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
419: fnd_message.raise_error;

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

412: --
413: when others then
414: --
415: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
416: fnd_message.set_token('PROC',l_proc);
417: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
418: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
419: fnd_message.raise_error;
420: --

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

413: when others then
414: --
415: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
416: fnd_message.set_token('PROC',l_proc);
417: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
418: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
419: fnd_message.raise_error;
420: --
421: end;

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

414: --
415: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
416: fnd_message.set_token('PROC',l_proc);
417: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
418: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
419: fnd_message.raise_error;
420: --
421: end;
422: --

Line 419: fnd_message.raise_error;

415: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
416: fnd_message.set_token('PROC',l_proc);
417: fnd_message.set_token('FORMULA',p_events.eval_ler_det_rl);
418: fnd_message.set_token('PARAMETER',l_outputs(l_outputs.first).name);
419: fnd_message.raise_error;
420: --
421: end;
422: --
423: elsif p_events.eval_ler_det_cd = 'ELED' then

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

516: l_bckdt_pil_count := l_bckdt_pil_count +1;
517: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl(l_bckdt_pil_count) := l_pil_rec.per_in_ler_id;
518: --End 6086392
519:
520: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
521: fnd_message.set_token('NAME',l_pil_rec.name);
522: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
523: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
524: benutils.write(fnd_message.get);

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

517: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl(l_bckdt_pil_count) := l_pil_rec.per_in_ler_id;
518: --End 6086392
519:
520: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
521: fnd_message.set_token('NAME',l_pil_rec.name);
522: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
523: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
524: benutils.write(fnd_message.get);
525: --

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

518: --End 6086392
519:
520: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
521: fnd_message.set_token('NAME',l_pil_rec.name);
522: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
523: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
524: benutils.write(fnd_message.get);
525: --
526: end loop;

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

519:
520: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
521: fnd_message.set_token('NAME',l_pil_rec.name);
522: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
523: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
524: benutils.write(fnd_message.get);
525: --
526: end loop;
527: close get_all_fut_pils;

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

520: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
521: fnd_message.set_token('NAME',l_pil_rec.name);
522: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
523: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
524: benutils.write(fnd_message.get);
525: --
526: end loop;
527: close get_all_fut_pils;
528: --

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

564: --End bug 12538701
565:
566: end if;
567: --
568: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
569: fnd_message.set_token('NAME',l_ler_rec.name);
570: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
571: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
572: benutils.write(fnd_message.get);

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

565:
566: end if;
567: --
568: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
569: fnd_message.set_token('NAME',l_ler_rec.name);
570: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
571: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
572: benutils.write(fnd_message.get);
573: --

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

566: end if;
567: --
568: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
569: fnd_message.set_token('NAME',l_ler_rec.name);
570: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
571: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
572: benutils.write(fnd_message.get);
573: --
574: g_rec.person_id := p_person_id;

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

567: --
568: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
569: fnd_message.set_token('NAME',l_ler_rec.name);
570: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
571: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
572: benutils.write(fnd_message.get);
573: --
574: g_rec.person_id := p_person_id;
575: g_rec.ler_id := g_included_events(l_count).ler_id;

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

568: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
569: fnd_message.set_token('NAME',l_ler_rec.name);
570: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
571: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
572: benutils.write(fnd_message.get);
573: --
574: g_rec.person_id := p_person_id;
575: g_rec.ler_id := g_included_events(l_count).ler_id;
576: g_rec.lf_evt_ocrd_dt := g_included_events(l_count).lf_evt_ocrd_dt;

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

607: p_object_version_number => g_included_events(l_count).
608: object_version_number);
609: l_flag := true;
610: --
611: fnd_message.set_name('BEN','BEN_92434_PTNL_LER_VOIDED');
612: fnd_message.set_token('NAME',l_ler_rec.name);
613: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
614: lf_evt_ocrd_dt);
615: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).

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

608: object_version_number);
609: l_flag := true;
610: --
611: fnd_message.set_name('BEN','BEN_92434_PTNL_LER_VOIDED');
612: fnd_message.set_token('NAME',l_ler_rec.name);
613: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
614: lf_evt_ocrd_dt);
615: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
616: ntfn_dt);

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

609: l_flag := true;
610: --
611: fnd_message.set_name('BEN','BEN_92434_PTNL_LER_VOIDED');
612: fnd_message.set_token('NAME',l_ler_rec.name);
613: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
614: lf_evt_ocrd_dt);
615: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
616: ntfn_dt);
617: benutils.write(fnd_message.get);

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

611: fnd_message.set_name('BEN','BEN_92434_PTNL_LER_VOIDED');
612: fnd_message.set_token('NAME',l_ler_rec.name);
613: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
614: lf_evt_ocrd_dt);
615: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
616: ntfn_dt);
617: benutils.write(fnd_message.get);
618: else
619: if (g_included_events(l_count).ler_id = p_events.eval_ler_id) then

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

613: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
614: lf_evt_ocrd_dt);
615: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
616: ntfn_dt);
617: benutils.write(fnd_message.get);
618: else
619: if (g_included_events(l_count).ler_id = p_events.eval_ler_id) then
620: hr_utility.set_location('Event not voided '||g_included_events(l_count).ler_id, 50);
621: hr_utility.set_location('p_events.eval_ler_id '||p_events.eval_ler_id, 50);

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

649: p_effective_date => p_effective_date,
650: p_object_version_number => g_included_events(l_count).
651: object_version_number);
652: --
653: fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');
654: fnd_message.set_token('NAME',l_ler_rec.name);
655: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
656: lf_evt_ocrd_dt);
657: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).

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

650: p_object_version_number => g_included_events(l_count).
651: object_version_number);
652: --
653: fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');
654: fnd_message.set_token('NAME',l_ler_rec.name);
655: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
656: lf_evt_ocrd_dt);
657: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
658: ntfn_dt);

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

651: object_version_number);
652: --
653: fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');
654: fnd_message.set_token('NAME',l_ler_rec.name);
655: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
656: lf_evt_ocrd_dt);
657: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
658: ntfn_dt);
659: benutils.write(fnd_message.get);

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

653: fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');
654: fnd_message.set_token('NAME',l_ler_rec.name);
655: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
656: lf_evt_ocrd_dt);
657: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
658: ntfn_dt);
659: benutils.write(fnd_message.get);
660: --
661: end if;

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

655: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
656: lf_evt_ocrd_dt);
657: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
658: ntfn_dt);
659: benutils.write(fnd_message.get);
660: --
661: end if;
662: --
663: end if;