eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on FND_MESSAGE

Line 579: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');

575: ben_env_object.get(p_rec => l_env);
576: --
577: If (p_person_id is null) then
578: --
579: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');
580: fnd_message.set_token('PACKAGE',l_package);
581: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
582: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
583: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 580: fnd_message.set_token('PACKAGE',l_package);

576: --
577: If (p_person_id is null) then
578: --
579: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');
580: fnd_message.set_token('PACKAGE',l_package);
581: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
582: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
583: fnd_message.set_token('PL_ID',to_char(p_pl_id));
584: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

Line 581: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

577: If (p_person_id is null) then
578: --
579: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');
580: fnd_message.set_token('PACKAGE',l_package);
581: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
582: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
583: fnd_message.set_token('PL_ID',to_char(p_pl_id));
584: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
585: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 582: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

578: --
579: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');
580: fnd_message.set_token('PACKAGE',l_package);
581: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
582: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
583: fnd_message.set_token('PL_ID',to_char(p_pl_id));
584: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
585: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
586: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

Line 583: fnd_message.set_token('PL_ID',to_char(p_pl_id));

579: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');
580: fnd_message.set_token('PACKAGE',l_package);
581: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
582: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
583: fnd_message.set_token('PL_ID',to_char(p_pl_id));
584: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
585: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
586: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
587: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

Line 584: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

580: fnd_message.set_token('PACKAGE',l_package);
581: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
582: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
583: fnd_message.set_token('PL_ID',to_char(p_pl_id));
584: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
585: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
586: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
587: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
588: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 585: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

581: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
582: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
583: fnd_message.set_token('PL_ID',to_char(p_pl_id));
584: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
585: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
586: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
587: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
588: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
589: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

Line 586: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

582: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
583: fnd_message.set_token('PL_ID',to_char(p_pl_id));
584: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
585: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
586: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
587: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
588: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
589: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
590: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

Line 587: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

583: fnd_message.set_token('PL_ID',to_char(p_pl_id));
584: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
585: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
586: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
587: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
588: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
589: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
590: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
591: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));

Line 588: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

584: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
585: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
586: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
587: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
588: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
589: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
590: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
591: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
592: fnd_message.raise_error;

Line 589: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

585: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
586: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
587: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
588: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
589: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
590: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
591: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
592: fnd_message.raise_error;
593: --

Line 590: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

586: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
587: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
588: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
589: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
590: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
591: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
592: fnd_message.raise_error;
593: --
594: end if;

Line 591: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));

587: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
588: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
589: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
590: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
591: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
592: fnd_message.raise_error;
593: --
594: end if;
595: --

Line 592: fnd_message.raise_error;

588: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
589: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
590: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
591: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
592: fnd_message.raise_error;
593: --
594: end if;
595: --
596: -- Edit to insure that the input p_effective_date has a value

Line 599: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');

595: --
596: -- Edit to insure that the input p_effective_date has a value
597: If (p_effective_date is null) then
598: --
599: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');
600: fnd_message.set_token('PACKAGE',l_package);
601: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
602: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
603: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

Line 600: fnd_message.set_token('PACKAGE',l_package);

596: -- Edit to insure that the input p_effective_date has a value
597: If (p_effective_date is null) then
598: --
599: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');
600: fnd_message.set_token('PACKAGE',l_package);
601: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
602: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
603: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
604: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 601: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

597: If (p_effective_date is null) then
598: --
599: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');
600: fnd_message.set_token('PACKAGE',l_package);
601: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
602: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
603: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
604: fnd_message.set_token('PL_ID',to_char(p_pl_id));
605: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

Line 602: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

598: --
599: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');
600: fnd_message.set_token('PACKAGE',l_package);
601: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
602: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
603: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
604: fnd_message.set_token('PL_ID',to_char(p_pl_id));
605: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
606: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 603: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

599: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');
600: fnd_message.set_token('PACKAGE',l_package);
601: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
602: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
603: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
604: fnd_message.set_token('PL_ID',to_char(p_pl_id));
605: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
606: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

Line 604: fnd_message.set_token('PL_ID',to_char(p_pl_id));

600: fnd_message.set_token('PACKAGE',l_package);
601: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
602: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
603: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
604: fnd_message.set_token('PL_ID',to_char(p_pl_id));
605: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
606: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
608: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

Line 605: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

601: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
602: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
603: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
604: fnd_message.set_token('PL_ID',to_char(p_pl_id));
605: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
606: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
608: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
609: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

Line 606: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

602: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
603: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
604: fnd_message.set_token('PL_ID',to_char(p_pl_id));
605: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
606: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
608: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
609: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
610: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

Line 607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

603: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
604: fnd_message.set_token('PL_ID',to_char(p_pl_id));
605: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
606: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
608: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
609: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
610: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
611: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));

Line 608: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

604: fnd_message.set_token('PL_ID',to_char(p_pl_id));
605: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
606: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
608: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
609: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
610: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
611: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
612: fnd_message.raise_error;

Line 609: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

605: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
606: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
608: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
609: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
610: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
611: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
612: fnd_message.raise_error;
613: --

Line 610: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

606: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
608: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
609: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
610: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
611: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
612: fnd_message.raise_error;
613: --
614: end if;

Line 611: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));

607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
608: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
609: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
610: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
611: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
612: fnd_message.raise_error;
613: --
614: end if;
615: --

Line 612: fnd_message.raise_error;

608: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
609: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
610: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
611: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
612: fnd_message.raise_error;
613: --
614: end if;
615: --
616: -- Edit to insure that the input p_elig_per_elctbl_chc_id has a value

Line 619: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');

615: --
616: -- Edit to insure that the input p_elig_per_elctbl_chc_id has a value
617: If (p_elig_per_elctbl_chc_id is null) and not(p_calc_only_rt_val_flag) then
618: --
619: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');
620: fnd_message.set_token('PACKAGE',l_package);
621: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
622: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
623: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

Line 620: fnd_message.set_token('PACKAGE',l_package);

616: -- Edit to insure that the input p_elig_per_elctbl_chc_id has a value
617: If (p_elig_per_elctbl_chc_id is null) and not(p_calc_only_rt_val_flag) then
618: --
619: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');
620: fnd_message.set_token('PACKAGE',l_package);
621: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
622: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
623: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
624: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 621: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

617: If (p_elig_per_elctbl_chc_id is null) and not(p_calc_only_rt_val_flag) then
618: --
619: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');
620: fnd_message.set_token('PACKAGE',l_package);
621: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
622: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
623: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
624: fnd_message.set_token('PL_ID',to_char(p_pl_id));
625: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

Line 622: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

618: --
619: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');
620: fnd_message.set_token('PACKAGE',l_package);
621: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
622: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
623: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
624: fnd_message.set_token('PL_ID',to_char(p_pl_id));
625: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
626: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 623: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

619: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');
620: fnd_message.set_token('PACKAGE',l_package);
621: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
622: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
623: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
624: fnd_message.set_token('PL_ID',to_char(p_pl_id));
625: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
626: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
627: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 624: fnd_message.set_token('PL_ID',to_char(p_pl_id));

620: fnd_message.set_token('PACKAGE',l_package);
621: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
622: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
623: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
624: fnd_message.set_token('PL_ID',to_char(p_pl_id));
625: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
626: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
627: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
628: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

Line 625: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

621: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
622: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
623: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
624: fnd_message.set_token('PL_ID',to_char(p_pl_id));
625: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
626: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
627: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
628: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
629: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

Line 626: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

622: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
623: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
624: fnd_message.set_token('PL_ID',to_char(p_pl_id));
625: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
626: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
627: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
628: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
629: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
630: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

Line 627: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

623: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
624: fnd_message.set_token('PL_ID',to_char(p_pl_id));
625: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
626: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
627: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
628: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
629: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
630: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
631: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));

Line 628: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

624: fnd_message.set_token('PL_ID',to_char(p_pl_id));
625: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
626: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
627: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
628: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
629: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
630: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
631: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
632: fnd_message.raise_error;

Line 629: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

625: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
626: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
627: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
628: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
629: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
630: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
631: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
632: fnd_message.raise_error;
633: --

Line 630: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

626: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
627: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
628: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
629: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
630: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
631: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
632: fnd_message.raise_error;
633: --
634: end if;

Line 631: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));

627: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
628: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
629: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
630: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
631: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
632: fnd_message.raise_error;
633: --
634: end if;
635: --

Line 632: fnd_message.raise_error;

628: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
629: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
630: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
631: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
632: fnd_message.raise_error;
633: --
634: end if;
635: --
636: -- Edit to ensure that one of the base table ids has a value

Line 641: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');

637: If (p_acty_base_rt_id is null and
638: p_actl_prem_id is null and
639: p_cvg_amt_calc_mthd_id is null) then
640: --
641: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');
642: fnd_message.set_token('PACKAGE',l_package);
643: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
644: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
645: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

Line 642: fnd_message.set_token('PACKAGE',l_package);

638: p_actl_prem_id is null and
639: p_cvg_amt_calc_mthd_id is null) then
640: --
641: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');
642: fnd_message.set_token('PACKAGE',l_package);
643: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
644: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
645: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
646: fnd_message.set_token('PL_ID',to_char(p_pl_id));

Line 643: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

639: p_cvg_amt_calc_mthd_id is null) then
640: --
641: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');
642: fnd_message.set_token('PACKAGE',l_package);
643: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
644: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
645: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
646: fnd_message.set_token('PL_ID',to_char(p_pl_id));
647: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

Line 644: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

640: --
641: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');
642: fnd_message.set_token('PACKAGE',l_package);
643: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
644: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
645: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
646: fnd_message.set_token('PL_ID',to_char(p_pl_id));
647: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
648: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 645: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

641: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');
642: fnd_message.set_token('PACKAGE',l_package);
643: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
644: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
645: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
646: fnd_message.set_token('PL_ID',to_char(p_pl_id));
647: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
648: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
649: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 646: fnd_message.set_token('PL_ID',to_char(p_pl_id));

642: fnd_message.set_token('PACKAGE',l_package);
643: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
644: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
645: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
646: fnd_message.set_token('PL_ID',to_char(p_pl_id));
647: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
648: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
649: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
650: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

Line 647: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

643: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
644: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
645: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
646: fnd_message.set_token('PL_ID',to_char(p_pl_id));
647: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
648: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
649: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
650: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
651: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

Line 648: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

644: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
645: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
646: fnd_message.set_token('PL_ID',to_char(p_pl_id));
647: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
648: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
649: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
650: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
651: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
652: fnd_message.raise_error;

Line 649: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

645: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
646: fnd_message.set_token('PL_ID',to_char(p_pl_id));
647: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
648: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
649: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
650: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
651: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
652: fnd_message.raise_error;
653: --

Line 650: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

646: fnd_message.set_token('PL_ID',to_char(p_pl_id));
647: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
648: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
649: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
650: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
651: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
652: fnd_message.raise_error;
653: --
654: end if;

Line 651: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

647: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
648: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
649: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
650: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
651: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
652: fnd_message.raise_error;
653: --
654: end if;
655: -- bug 1210355

Line 652: fnd_message.raise_error;

648: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
649: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
650: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
651: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
652: fnd_message.raise_error;
653: --
654: end if;
655: -- bug 1210355
656: g_vrbl_mlt_code := null;

Line 716: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');

712: --
713: if c_epe%notfound then
714: --
715: close c_epe;
716: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');
717: fnd_message.set_token('PACKAGE',l_package);
718: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
719: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
720: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 717: fnd_message.set_token('PACKAGE',l_package);

713: if c_epe%notfound then
714: --
715: close c_epe;
716: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');
717: fnd_message.set_token('PACKAGE',l_package);
718: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
719: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
720: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
721: fnd_message.raise_error;

Line 718: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

714: --
715: close c_epe;
716: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');
717: fnd_message.set_token('PACKAGE',l_package);
718: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
719: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
720: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
721: fnd_message.raise_error;
722: --

Line 719: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

715: close c_epe;
716: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');
717: fnd_message.set_token('PACKAGE',l_package);
718: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
719: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
720: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
721: fnd_message.raise_error;
722: --
723: end if;

Line 720: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

716: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');
717: fnd_message.set_token('PACKAGE',l_package);
718: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
719: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
720: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
721: fnd_message.raise_error;
722: --
723: end if;
724: --

Line 721: fnd_message.raise_error;

717: fnd_message.set_token('PACKAGE',l_package);
718: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
719: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
720: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
721: fnd_message.raise_error;
722: --
723: end if;
724: --
725: close c_epe;

Line 843: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');

839: --
840: if c_vpf%notfound then
841: --
842: close c_vpf;
843: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');
844: fnd_message.set_token('PACKAGE',l_package);
845: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
846: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
847: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 844: fnd_message.set_token('PACKAGE',l_package);

840: if c_vpf%notfound then
841: --
842: close c_vpf;
843: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');
844: fnd_message.set_token('PACKAGE',l_package);
845: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
846: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
847: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
848: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

Line 845: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

841: --
842: close c_vpf;
843: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');
844: fnd_message.set_token('PACKAGE',l_package);
845: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
846: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
847: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
848: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
849: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

Line 846: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

842: close c_vpf;
843: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');
844: fnd_message.set_token('PACKAGE',l_package);
845: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
846: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
847: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
848: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
849: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
850: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 847: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

843: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');
844: fnd_message.set_token('PACKAGE',l_package);
845: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
846: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
847: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
848: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
849: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
850: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
851: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 848: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

844: fnd_message.set_token('PACKAGE',l_package);
845: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
846: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
847: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
848: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
849: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
850: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
851: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
852: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

Line 849: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

845: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
846: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
847: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
848: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
849: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
850: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
851: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
852: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
853: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

Line 850: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

846: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
847: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
848: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
849: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
850: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
851: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
852: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
853: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
854: to_char(p_elig_per_elctbl_chc_id));

Line 851: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

847: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
848: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
849: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
850: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
851: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
852: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
853: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
854: to_char(p_elig_per_elctbl_chc_id));
855: fnd_message.raise_error;

Line 852: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

848: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
849: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
850: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
851: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
852: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
853: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
854: to_char(p_elig_per_elctbl_chc_id));
855: fnd_message.raise_error;
856: --

Line 853: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

849: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
850: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
851: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
852: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
853: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
854: to_char(p_elig_per_elctbl_chc_id));
855: fnd_message.raise_error;
856: --
857: end if;

Line 855: fnd_message.raise_error;

851: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
852: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
853: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
854: to_char(p_elig_per_elctbl_chc_id));
855: fnd_message.raise_error;
856: --
857: end if;
858: --
859: close c_vpf;

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

879: if l_coverage_value is null then
880: --
881: if p_enrt_bnft_id is null then
882: --
883: fnd_message.set_name('BEN','BEN_91560_BENVRBRT_INPT_EB');
884: fnd_message.set_token('PACKAGE',l_package);
885: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
886: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
887: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 884: fnd_message.set_token('PACKAGE',l_package);

880: --
881: if p_enrt_bnft_id is null then
882: --
883: fnd_message.set_name('BEN','BEN_91560_BENVRBRT_INPT_EB');
884: fnd_message.set_token('PACKAGE',l_package);
885: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
886: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
887: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
888: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

Line 885: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

881: if p_enrt_bnft_id is null then
882: --
883: fnd_message.set_name('BEN','BEN_91560_BENVRBRT_INPT_EB');
884: fnd_message.set_token('PACKAGE',l_package);
885: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
886: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
887: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
888: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
889: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

Line 886: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

882: --
883: fnd_message.set_name('BEN','BEN_91560_BENVRBRT_INPT_EB');
884: fnd_message.set_token('PACKAGE',l_package);
885: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
886: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
887: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
888: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
889: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
890: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 887: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

883: fnd_message.set_name('BEN','BEN_91560_BENVRBRT_INPT_EB');
884: fnd_message.set_token('PACKAGE',l_package);
885: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
886: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
887: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
888: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
889: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
890: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
891: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 888: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

884: fnd_message.set_token('PACKAGE',l_package);
885: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
886: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
887: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
888: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
889: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
890: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
891: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
892: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

Line 889: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

885: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
886: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
887: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
888: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
889: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
890: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
891: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
892: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
893: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

Line 890: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

886: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
887: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
888: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
889: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
890: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
891: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
892: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
893: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
894: to_char(p_elig_per_elctbl_chc_id));

Line 891: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

887: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
888: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
889: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
890: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
891: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
892: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
893: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
894: to_char(p_elig_per_elctbl_chc_id));
895: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

Line 892: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

888: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
889: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
890: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
891: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
892: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
893: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
894: to_char(p_elig_per_elctbl_chc_id));
895: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
896: fnd_message.raise_error;

Line 893: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

889: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
890: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
891: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
892: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
893: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
894: to_char(p_elig_per_elctbl_chc_id));
895: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
896: fnd_message.raise_error;
897: --

Line 895: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

891: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
892: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
893: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
894: to_char(p_elig_per_elctbl_chc_id));
895: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
896: fnd_message.raise_error;
897: --
898: end if;
899: --

Line 896: fnd_message.raise_error;

892: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
893: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
894: to_char(p_elig_per_elctbl_chc_id));
895: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
896: fnd_message.raise_error;
897: --
898: end if;
899: --
900: open c_enb;

Line 907: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');

903: --
904: if c_enb%notfound then
905: --
906: close c_enb;
907: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
908: fnd_message.set_token('PACKAGE',l_package);
909: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
910: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
911: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 908: fnd_message.set_token('PACKAGE',l_package);

904: if c_enb%notfound then
905: --
906: close c_enb;
907: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
908: fnd_message.set_token('PACKAGE',l_package);
909: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
910: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
911: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
912: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

Line 909: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

905: --
906: close c_enb;
907: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
908: fnd_message.set_token('PACKAGE',l_package);
909: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
910: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
911: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
912: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
913: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

Line 910: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

906: close c_enb;
907: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
908: fnd_message.set_token('PACKAGE',l_package);
909: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
910: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
911: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
912: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
913: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
914: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 911: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

907: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
908: fnd_message.set_token('PACKAGE',l_package);
909: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
910: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
911: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
912: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
913: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
914: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
915: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 912: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

908: fnd_message.set_token('PACKAGE',l_package);
909: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
910: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
911: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
912: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
913: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
914: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
915: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
916: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

Line 913: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

909: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
910: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
911: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
912: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
913: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
914: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
915: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
916: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
917: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

Line 914: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

910: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
911: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
912: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
913: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
914: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
915: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
916: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
917: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
918: to_char(p_elig_per_elctbl_chc_id));

Line 915: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

911: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
912: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
913: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
914: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
915: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
916: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
917: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
918: to_char(p_elig_per_elctbl_chc_id));
919: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

Line 916: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

912: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
913: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
914: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
915: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
916: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
917: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
918: to_char(p_elig_per_elctbl_chc_id));
919: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
920: fnd_message.raise_error;

Line 917: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

913: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
914: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
915: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
916: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
917: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
918: to_char(p_elig_per_elctbl_chc_id));
919: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
920: fnd_message.raise_error;
921: --

Line 919: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

915: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
916: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
917: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
918: to_char(p_elig_per_elctbl_chc_id));
919: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
920: fnd_message.raise_error;
921: --
922: end if;
923: --

Line 920: fnd_message.raise_error;

916: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
917: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
918: to_char(p_elig_per_elctbl_chc_id));
919: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
920: fnd_message.raise_error;
921: --
922: end if;
923: --
924: close c_enb;

Line 937: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');

933: if l_vpf.mlt_cd in ('CL','CLANDCVG','FLFXPCL') then
934: --
935: if l_vpf.comp_lvl_fctr_id is null then
936: --
937: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');
938: fnd_message.set_token('PACKAGE',l_package);
939: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
940: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
941: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 938: fnd_message.set_token('PACKAGE',l_package);

934: --
935: if l_vpf.comp_lvl_fctr_id is null then
936: --
937: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');
938: fnd_message.set_token('PACKAGE',l_package);
939: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
940: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
941: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
942: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

Line 939: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

935: if l_vpf.comp_lvl_fctr_id is null then
936: --
937: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');
938: fnd_message.set_token('PACKAGE',l_package);
939: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
940: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
941: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
942: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
943: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

Line 940: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

936: --
937: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');
938: fnd_message.set_token('PACKAGE',l_package);
939: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
940: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
941: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
942: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
943: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
944: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 941: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

937: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');
938: fnd_message.set_token('PACKAGE',l_package);
939: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
940: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
941: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
942: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
943: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
944: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 942: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

938: fnd_message.set_token('PACKAGE',l_package);
939: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
940: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
941: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
942: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
943: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
944: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
946: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

Line 943: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

939: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
940: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
941: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
942: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
943: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
944: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
946: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
947: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

Line 944: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

940: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
941: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
942: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
943: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
944: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
946: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
947: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
948: to_char(p_elig_per_elctbl_chc_id));

Line 945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

941: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
942: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
943: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
944: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
946: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
947: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
948: to_char(p_elig_per_elctbl_chc_id));
949: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

Line 946: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

942: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
943: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
944: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
946: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
947: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
948: to_char(p_elig_per_elctbl_chc_id));
949: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
950: fnd_message.raise_error;

Line 947: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

943: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
944: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
946: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
947: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
948: to_char(p_elig_per_elctbl_chc_id));
949: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
950: fnd_message.raise_error;
951: --

Line 949: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
946: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
947: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
948: to_char(p_elig_per_elctbl_chc_id));
949: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
950: fnd_message.raise_error;
951: --
952: end if;
953: --

Line 950: fnd_message.raise_error;

946: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
947: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
948: to_char(p_elig_per_elctbl_chc_id));
949: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
950: fnd_message.raise_error;
951: --
952: end if;
953: --
954: ben_derive_factors.determine_compensation

Line 984: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');

980: open c_pgm(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
981: fetch c_pgm into l_pgm;
982: if c_pgm%notfound then
983: close c_pgm;
984: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
985: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
986: fnd_message.set_token('PACKAGE',l_package);
987: fnd_message.raise_error;
988: end if;

Line 985: fnd_message.set_token('ID',to_char(l_epe.pgm_id));

981: fetch c_pgm into l_pgm;
982: if c_pgm%notfound then
983: close c_pgm;
984: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
985: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
986: fnd_message.set_token('PACKAGE',l_package);
987: fnd_message.raise_error;
988: end if;
989: close c_pgm;

Line 986: fnd_message.set_token('PACKAGE',l_package);

982: if c_pgm%notfound then
983: close c_pgm;
984: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
985: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
986: fnd_message.set_token('PACKAGE',l_package);
987: fnd_message.raise_error;
988: end if;
989: close c_pgm;
990: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;

Line 987: fnd_message.raise_error;

983: close c_pgm;
984: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
985: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
986: fnd_message.set_token('PACKAGE',l_package);
987: fnd_message.raise_error;
988: end if;
989: close c_pgm;
990: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;
991: else

Line 997: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');

993: open c_pln(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
994: fetch c_pln into l_pln;
995: if c_pln%notfound then
996: close c_pln;
997: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
998: fnd_message.set_token('ID',to_char(l_epe.pl_id));
999: fnd_message.set_token('PACKAGE',l_package);
1000: fnd_message.raise_error;
1001: end if;

Line 998: fnd_message.set_token('ID',to_char(l_epe.pl_id));

994: fetch c_pln into l_pln;
995: if c_pln%notfound then
996: close c_pln;
997: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
998: fnd_message.set_token('ID',to_char(l_epe.pl_id));
999: fnd_message.set_token('PACKAGE',l_package);
1000: fnd_message.raise_error;
1001: end if;
1002: close c_pln;

Line 999: fnd_message.set_token('PACKAGE',l_package);

995: if c_pln%notfound then
996: close c_pln;
997: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
998: fnd_message.set_token('ID',to_char(l_epe.pl_id));
999: fnd_message.set_token('PACKAGE',l_package);
1000: fnd_message.raise_error;
1001: end if;
1002: close c_pln;
1003: l_acty_ref_perd_cd := l_pln.nip_acty_ref_perd_cd;

Line 1000: fnd_message.raise_error;

996: close c_pln;
997: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
998: fnd_message.set_token('ID',to_char(l_epe.pl_id));
999: fnd_message.set_token('PACKAGE',l_package);
1000: fnd_message.raise_error;
1001: end if;
1002: close c_pln;
1003: l_acty_ref_perd_cd := l_pln.nip_acty_ref_perd_cd;
1004: end if;

Line 1078: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');

1074: l_actl_prem_value := l_actl_prem_value * 12 / l_pay_annualization_factor;
1075: --
1076:
1077: else
1078: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
1079: fnd_message.set_token('PROC',l_package);
1080: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
1081: hr_utility.set_location (' FNDMS_RE 2 ',150);
1082: fnd_message.raise_error;

Line 1079: fnd_message.set_token('PROC',l_package);

1075: --
1076:
1077: else
1078: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
1079: fnd_message.set_token('PROC',l_package);
1080: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
1081: hr_utility.set_location (' FNDMS_RE 2 ',150);
1082: fnd_message.raise_error;
1083: end if;

Line 1080: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);

1076:
1077: else
1078: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
1079: fnd_message.set_token('PROC',l_package);
1080: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
1081: hr_utility.set_location (' FNDMS_RE 2 ',150);
1082: fnd_message.raise_error;
1083: end if;
1084: --

Line 1082: fnd_message.raise_error;

1078: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
1079: fnd_message.set_token('PROC',l_package);
1080: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
1081: hr_utility.set_location (' FNDMS_RE 2 ',150);
1082: fnd_message.raise_error;
1083: end if;
1084: --
1085: end if;
1086: --

Line 1236: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');

1232: p_val := l_outputs(l_outputs.first).value;
1233: --
1234: else
1235: --
1236: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');
1237: hr_utility.set_location(l_package||' FND 91572 ',10);
1238: fnd_message.set_token('PACKAGE',l_package);
1239: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1240: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

Line 1238: fnd_message.set_token('PACKAGE',l_package);

1234: else
1235: --
1236: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');
1237: hr_utility.set_location(l_package||' FND 91572 ',10);
1238: fnd_message.set_token('PACKAGE',l_package);
1239: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1240: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1241: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1242: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

Line 1239: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

1235: --
1236: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');
1237: hr_utility.set_location(l_package||' FND 91572 ',10);
1238: fnd_message.set_token('PACKAGE',l_package);
1239: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1240: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1241: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1242: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1243: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

Line 1240: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

1236: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');
1237: hr_utility.set_location(l_package||' FND 91572 ',10);
1238: fnd_message.set_token('PACKAGE',l_package);
1239: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1240: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1241: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1242: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1243: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1244: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 1241: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

1237: hr_utility.set_location(l_package||' FND 91572 ',10);
1238: fnd_message.set_token('PACKAGE',l_package);
1239: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1240: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1241: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1242: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1243: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1244: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1245: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 1242: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

1238: fnd_message.set_token('PACKAGE',l_package);
1239: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1240: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1241: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1242: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1243: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1244: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1245: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1246: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

Line 1243: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

1239: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1240: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1241: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1242: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1243: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1244: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1245: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1246: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1247: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

Line 1244: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

1240: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1241: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1242: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1243: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1244: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1245: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1246: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1247: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1248: to_char(p_elig_per_elctbl_chc_id));

Line 1245: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

1241: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1242: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1243: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1244: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1245: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1246: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1247: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1248: to_char(p_elig_per_elctbl_chc_id));
1249: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

Line 1246: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

1242: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1243: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1244: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1245: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1246: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1247: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1248: to_char(p_elig_per_elctbl_chc_id));
1249: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
1250: fnd_message.raise_error;

Line 1247: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

1243: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1244: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1245: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1246: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1247: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1248: to_char(p_elig_per_elctbl_chc_id));
1249: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
1250: fnd_message.raise_error;
1251: --

Line 1249: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

1245: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1246: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1247: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1248: to_char(p_elig_per_elctbl_chc_id));
1249: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
1250: fnd_message.raise_error;
1251: --
1252: end if; -- mult_cd
1253: --

Line 1250: fnd_message.raise_error;

1246: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1247: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1248: to_char(p_elig_per_elctbl_chc_id));
1249: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
1250: fnd_message.raise_error;
1251: --
1252: end if; -- mult_cd
1253: --
1254: -- assign other outputs