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 545: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');

541: ben_env_object.get(p_rec => l_env);
542: --
543: If (p_person_id is null) then
544: --
545: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');
546: fnd_message.set_token('PACKAGE',l_package);
547: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
548: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
549: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

542: --
543: If (p_person_id is null) then
544: --
545: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');
546: fnd_message.set_token('PACKAGE',l_package);
547: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
548: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
549: fnd_message.set_token('PL_ID',to_char(p_pl_id));
550: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

543: If (p_person_id is null) then
544: --
545: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');
546: fnd_message.set_token('PACKAGE',l_package);
547: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
548: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
549: fnd_message.set_token('PL_ID',to_char(p_pl_id));
550: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
551: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

544: --
545: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');
546: fnd_message.set_token('PACKAGE',l_package);
547: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
548: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
549: fnd_message.set_token('PL_ID',to_char(p_pl_id));
550: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
551: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
552: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

545: fnd_message.set_name('BEN','BEN_91554_BENVRBRT_INPT_PRSN');
546: fnd_message.set_token('PACKAGE',l_package);
547: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
548: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
549: fnd_message.set_token('PL_ID',to_char(p_pl_id));
550: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
551: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
552: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
553: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

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

546: fnd_message.set_token('PACKAGE',l_package);
547: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
548: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
549: fnd_message.set_token('PL_ID',to_char(p_pl_id));
550: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
551: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
552: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
553: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
554: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

547: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
548: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
549: fnd_message.set_token('PL_ID',to_char(p_pl_id));
550: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
551: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
552: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
553: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
554: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
555: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

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

548: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
549: fnd_message.set_token('PL_ID',to_char(p_pl_id));
550: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
551: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
552: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
553: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
554: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
555: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
556: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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

549: fnd_message.set_token('PL_ID',to_char(p_pl_id));
550: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
551: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
552: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
553: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
554: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
555: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
556: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
557: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));

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

550: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
551: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
552: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
553: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
554: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
555: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
556: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
557: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
558: fnd_message.raise_error;

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

551: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
552: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
553: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
554: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
555: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
556: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
557: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
558: fnd_message.raise_error;
559: --

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

552: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
553: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
554: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
555: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
556: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
557: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
558: fnd_message.raise_error;
559: --
560: end if;

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

553: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
554: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
555: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
556: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
557: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
558: fnd_message.raise_error;
559: --
560: end if;
561: --

Line 558: fnd_message.raise_error;

554: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
555: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
556: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
557: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
558: fnd_message.raise_error;
559: --
560: end if;
561: --
562: -- Edit to insure that the input p_effective_date has a value

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

561: --
562: -- Edit to insure that the input p_effective_date has a value
563: If (p_effective_date is null) then
564: --
565: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');
566: fnd_message.set_token('PACKAGE',l_package);
567: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
568: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
569: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

562: -- Edit to insure that the input p_effective_date has a value
563: If (p_effective_date is null) then
564: --
565: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');
566: fnd_message.set_token('PACKAGE',l_package);
567: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
568: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
569: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
570: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

563: If (p_effective_date is null) then
564: --
565: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');
566: fnd_message.set_token('PACKAGE',l_package);
567: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
568: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
569: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
570: fnd_message.set_token('PL_ID',to_char(p_pl_id));
571: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

564: --
565: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');
566: fnd_message.set_token('PACKAGE',l_package);
567: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
568: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
569: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
570: fnd_message.set_token('PL_ID',to_char(p_pl_id));
571: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
572: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

565: fnd_message.set_name('BEN','BEN_91555_BENVRBRT_INPT_EFFDT');
566: fnd_message.set_token('PACKAGE',l_package);
567: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
568: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
569: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
570: fnd_message.set_token('PL_ID',to_char(p_pl_id));
571: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
572: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
573: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

566: fnd_message.set_token('PACKAGE',l_package);
567: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
568: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
569: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
570: fnd_message.set_token('PL_ID',to_char(p_pl_id));
571: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
572: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
573: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
574: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

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

567: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
568: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
569: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
570: fnd_message.set_token('PL_ID',to_char(p_pl_id));
571: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
572: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
573: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
574: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
575: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

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

568: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
569: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
570: fnd_message.set_token('PL_ID',to_char(p_pl_id));
571: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
572: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
573: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
574: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
575: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
576: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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

569: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
570: fnd_message.set_token('PL_ID',to_char(p_pl_id));
571: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
572: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
573: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
574: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
575: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
576: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
577: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));

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

570: fnd_message.set_token('PL_ID',to_char(p_pl_id));
571: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
572: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
573: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
574: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
575: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
576: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
577: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
578: fnd_message.raise_error;

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

571: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
572: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
573: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
574: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
575: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
576: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
577: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
578: fnd_message.raise_error;
579: --

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

572: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
573: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
574: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
575: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
576: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
577: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
578: fnd_message.raise_error;
579: --
580: end if;

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

573: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
574: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
575: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
576: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
577: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
578: fnd_message.raise_error;
579: --
580: end if;
581: --

Line 578: fnd_message.raise_error;

574: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
575: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
576: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
577: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
578: fnd_message.raise_error;
579: --
580: end if;
581: --
582: -- Edit to insure that the input p_elig_per_elctbl_chc_id has a value

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

581: --
582: -- Edit to insure that the input p_elig_per_elctbl_chc_id has a value
583: If (p_elig_per_elctbl_chc_id is null) and not(p_calc_only_rt_val_flag) then
584: --
585: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');
586: fnd_message.set_token('PACKAGE',l_package);
587: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
588: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
589: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

582: -- Edit to insure that the input p_elig_per_elctbl_chc_id has a value
583: If (p_elig_per_elctbl_chc_id is null) and not(p_calc_only_rt_val_flag) then
584: --
585: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');
586: fnd_message.set_token('PACKAGE',l_package);
587: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
588: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
589: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
590: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

583: If (p_elig_per_elctbl_chc_id is null) and not(p_calc_only_rt_val_flag) then
584: --
585: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');
586: fnd_message.set_token('PACKAGE',l_package);
587: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
588: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
589: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
590: fnd_message.set_token('PL_ID',to_char(p_pl_id));
591: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

584: --
585: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');
586: fnd_message.set_token('PACKAGE',l_package);
587: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
588: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
589: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
590: fnd_message.set_token('PL_ID',to_char(p_pl_id));
591: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
592: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

585: fnd_message.set_name('BEN','BEN_91556_BENVRBRT_INPT_EC');
586: fnd_message.set_token('PACKAGE',l_package);
587: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
588: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
589: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
590: fnd_message.set_token('PL_ID',to_char(p_pl_id));
591: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
592: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
593: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

586: fnd_message.set_token('PACKAGE',l_package);
587: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
588: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
589: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
590: fnd_message.set_token('PL_ID',to_char(p_pl_id));
591: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
592: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
593: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
594: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

587: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
588: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
589: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
590: fnd_message.set_token('PL_ID',to_char(p_pl_id));
591: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
592: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
593: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
594: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
595: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));

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

588: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
589: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
590: fnd_message.set_token('PL_ID',to_char(p_pl_id));
591: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
592: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
593: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
594: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
595: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
596: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

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

589: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
590: fnd_message.set_token('PL_ID',to_char(p_pl_id));
591: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
592: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
593: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
594: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
595: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
596: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
597: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));

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

590: fnd_message.set_token('PL_ID',to_char(p_pl_id));
591: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
592: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
593: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
594: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
595: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
596: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
597: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
598: fnd_message.raise_error;

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

591: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
592: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
593: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
594: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
595: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
596: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
597: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
598: fnd_message.raise_error;
599: --

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

592: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
593: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
594: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
595: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
596: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
597: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
598: fnd_message.raise_error;
599: --
600: end if;

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

593: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
594: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
595: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
596: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
597: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
598: fnd_message.raise_error;
599: --
600: end if;
601: --

Line 598: fnd_message.raise_error;

594: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
595: fnd_message.set_token('ACTL_PREM_ID',to_char(p_actl_prem_id));
596: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
597: fnd_message.set_token('CVG_AMT_CALC_MTHD_ID',to_char(p_cvg_amt_calc_mthd_id));
598: fnd_message.raise_error;
599: --
600: end if;
601: --
602: -- Edit to ensure that one of the base table ids has a value

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

603: If (p_acty_base_rt_id is null and
604: p_actl_prem_id is null and
605: p_cvg_amt_calc_mthd_id is null) then
606: --
607: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');
608: fnd_message.set_token('PACKAGE',l_package);
609: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
610: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
611: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));

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

604: p_actl_prem_id is null and
605: p_cvg_amt_calc_mthd_id is null) then
606: --
607: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');
608: fnd_message.set_token('PACKAGE',l_package);
609: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
610: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
611: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
612: fnd_message.set_token('PL_ID',to_char(p_pl_id));

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

605: p_cvg_amt_calc_mthd_id is null) then
606: --
607: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');
608: fnd_message.set_token('PACKAGE',l_package);
609: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
610: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
611: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
612: fnd_message.set_token('PL_ID',to_char(p_pl_id));
613: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

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

606: --
607: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');
608: fnd_message.set_token('PACKAGE',l_package);
609: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
610: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
611: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
612: fnd_message.set_token('PL_ID',to_char(p_pl_id));
613: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
614: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

607: fnd_message.set_name('BEN','BEN_91557_BENVRBRT_INPT_BT');
608: fnd_message.set_token('PACKAGE',l_package);
609: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
610: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
611: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
612: fnd_message.set_token('PL_ID',to_char(p_pl_id));
613: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
614: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
615: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

608: fnd_message.set_token('PACKAGE',l_package);
609: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
610: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
611: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
612: fnd_message.set_token('PL_ID',to_char(p_pl_id));
613: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
614: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
615: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
616: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

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

609: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
610: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
611: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
612: fnd_message.set_token('PL_ID',to_char(p_pl_id));
613: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
614: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
615: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
616: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
617: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));

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

610: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
611: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
612: fnd_message.set_token('PL_ID',to_char(p_pl_id));
613: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
614: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
615: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
616: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
617: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
618: fnd_message.raise_error;

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

611: fnd_message.set_token('PL_TYP_ID',to_char(p_pl_typ_id));
612: fnd_message.set_token('PL_ID',to_char(p_pl_id));
613: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
614: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
615: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
616: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
617: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
618: fnd_message.raise_error;
619: --

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

612: fnd_message.set_token('PL_ID',to_char(p_pl_id));
613: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
614: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
615: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
616: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
617: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
618: fnd_message.raise_error;
619: --
620: end if;

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

613: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
614: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
615: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
616: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
617: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
618: fnd_message.raise_error;
619: --
620: end if;
621: -- bug 1210355

Line 618: fnd_message.raise_error;

614: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
615: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
616: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
617: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',to_char(p_elig_per_elctbl_chc_id));
618: fnd_message.raise_error;
619: --
620: end if;
621: -- bug 1210355
622: g_vrbl_mlt_code := null;

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

678: --
679: if c_epe%notfound then
680: --
681: close c_epe;
682: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');
683: fnd_message.set_token('PACKAGE',l_package);
684: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
685: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
686: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

679: if c_epe%notfound then
680: --
681: close c_epe;
682: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');
683: fnd_message.set_token('PACKAGE',l_package);
684: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
685: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
686: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
687: fnd_message.raise_error;

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

680: --
681: close c_epe;
682: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');
683: fnd_message.set_token('PACKAGE',l_package);
684: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
685: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
686: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
687: fnd_message.raise_error;
688: --

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

681: close c_epe;
682: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');
683: fnd_message.set_token('PACKAGE',l_package);
684: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
685: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
686: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
687: fnd_message.raise_error;
688: --
689: end if;

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

682: fnd_message.set_name('BEN','BEN_91558_BENVRBRT_EPE_NF');
683: fnd_message.set_token('PACKAGE',l_package);
684: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
685: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
686: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
687: fnd_message.raise_error;
688: --
689: end if;
690: --

Line 687: fnd_message.raise_error;

683: fnd_message.set_token('PACKAGE',l_package);
684: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
685: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
686: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
687: fnd_message.raise_error;
688: --
689: end if;
690: --
691: close c_epe;

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

805: --
806: if c_vpf%notfound then
807: --
808: close c_vpf;
809: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');
810: fnd_message.set_token('PACKAGE',l_package);
811: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
812: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
813: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

806: if c_vpf%notfound then
807: --
808: close c_vpf;
809: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');
810: fnd_message.set_token('PACKAGE',l_package);
811: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
812: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
813: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
814: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

807: --
808: close c_vpf;
809: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');
810: fnd_message.set_token('PACKAGE',l_package);
811: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
812: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
813: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
814: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
815: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

808: close c_vpf;
809: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');
810: fnd_message.set_token('PACKAGE',l_package);
811: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
812: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
813: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
814: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
815: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
816: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

809: fnd_message.set_name('BEN','BEN_91559_BENVRBRT_VPF_NF');
810: fnd_message.set_token('PACKAGE',l_package);
811: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
812: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
813: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
814: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
815: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
816: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
817: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

810: fnd_message.set_token('PACKAGE',l_package);
811: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
812: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
813: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
814: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
815: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
816: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
817: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
818: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

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

811: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
812: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
813: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
814: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
815: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
816: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
817: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
818: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
819: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

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

812: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
813: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
814: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
815: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
816: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
817: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
818: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
819: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
820: to_char(p_elig_per_elctbl_chc_id));

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

813: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
814: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
815: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
816: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
817: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
818: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
819: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
820: to_char(p_elig_per_elctbl_chc_id));
821: fnd_message.raise_error;

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

814: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
815: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
816: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
817: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
818: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
819: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
820: to_char(p_elig_per_elctbl_chc_id));
821: fnd_message.raise_error;
822: --

Line 819: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

815: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
816: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
817: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
818: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
819: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
820: to_char(p_elig_per_elctbl_chc_id));
821: fnd_message.raise_error;
822: --
823: end if;

Line 821: fnd_message.raise_error;

817: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
818: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
819: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
820: to_char(p_elig_per_elctbl_chc_id));
821: fnd_message.raise_error;
822: --
823: end if;
824: --
825: close c_vpf;

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

844: if l_coverage_value is null then
845: --
846: if p_enrt_bnft_id is null then
847: --
848: fnd_message.set_name('BEN','BEN_91560_BENVRBRT_INPT_EB');
849: fnd_message.set_token('PACKAGE',l_package);
850: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
851: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
852: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

845: --
846: if p_enrt_bnft_id is null then
847: --
848: fnd_message.set_name('BEN','BEN_91560_BENVRBRT_INPT_EB');
849: fnd_message.set_token('PACKAGE',l_package);
850: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
851: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
852: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
853: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

846: if p_enrt_bnft_id is null then
847: --
848: fnd_message.set_name('BEN','BEN_91560_BENVRBRT_INPT_EB');
849: fnd_message.set_token('PACKAGE',l_package);
850: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
851: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
852: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
853: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
854: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

847: --
848: fnd_message.set_name('BEN','BEN_91560_BENVRBRT_INPT_EB');
849: fnd_message.set_token('PACKAGE',l_package);
850: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
851: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
852: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
853: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
854: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
855: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

848: fnd_message.set_name('BEN','BEN_91560_BENVRBRT_INPT_EB');
849: fnd_message.set_token('PACKAGE',l_package);
850: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
851: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
852: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
853: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
854: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
855: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
856: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

849: fnd_message.set_token('PACKAGE',l_package);
850: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
851: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
852: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
853: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
854: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
855: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
856: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
857: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

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

850: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
851: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
852: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
853: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
854: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
855: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
856: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
857: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
858: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

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

851: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
852: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
853: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
854: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
855: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
856: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
857: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
858: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
859: to_char(p_elig_per_elctbl_chc_id));

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

852: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
853: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
854: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
855: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
856: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
857: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
858: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
859: to_char(p_elig_per_elctbl_chc_id));
860: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

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

853: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
854: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
855: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
856: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
857: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
858: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
859: to_char(p_elig_per_elctbl_chc_id));
860: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
861: fnd_message.raise_error;

Line 858: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

854: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
855: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
856: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
857: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
858: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
859: to_char(p_elig_per_elctbl_chc_id));
860: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
861: fnd_message.raise_error;
862: --

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

856: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
857: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
858: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
859: to_char(p_elig_per_elctbl_chc_id));
860: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
861: fnd_message.raise_error;
862: --
863: end if;
864: --

Line 861: fnd_message.raise_error;

857: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
858: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
859: to_char(p_elig_per_elctbl_chc_id));
860: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
861: fnd_message.raise_error;
862: --
863: end if;
864: --
865: open c_enb;

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

868: --
869: if c_enb%notfound then
870: --
871: close c_enb;
872: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
873: fnd_message.set_token('PACKAGE',l_package);
874: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
875: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
876: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

869: if c_enb%notfound then
870: --
871: close c_enb;
872: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
873: fnd_message.set_token('PACKAGE',l_package);
874: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
875: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
876: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
877: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

870: --
871: close c_enb;
872: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
873: fnd_message.set_token('PACKAGE',l_package);
874: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
875: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
876: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
877: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
878: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

871: close c_enb;
872: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
873: fnd_message.set_token('PACKAGE',l_package);
874: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
875: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
876: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
877: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
878: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
879: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

872: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
873: fnd_message.set_token('PACKAGE',l_package);
874: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
875: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
876: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
877: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
878: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
879: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
880: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

873: fnd_message.set_token('PACKAGE',l_package);
874: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
875: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
876: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
877: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
878: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
879: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
880: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
881: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

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

874: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
875: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
876: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
877: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
878: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
879: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
880: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
881: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
882: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

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

875: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
876: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
877: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
878: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
879: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
880: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
881: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
882: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
883: to_char(p_elig_per_elctbl_chc_id));

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

876: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
877: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
878: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
879: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
880: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
881: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
882: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
883: to_char(p_elig_per_elctbl_chc_id));
884: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

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

877: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
878: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
879: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
880: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
881: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
882: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
883: to_char(p_elig_per_elctbl_chc_id));
884: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
885: fnd_message.raise_error;

Line 882: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

878: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
879: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
880: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
881: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
882: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
883: to_char(p_elig_per_elctbl_chc_id));
884: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
885: fnd_message.raise_error;
886: --

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

880: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
881: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
882: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
883: to_char(p_elig_per_elctbl_chc_id));
884: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
885: fnd_message.raise_error;
886: --
887: end if;
888: --

Line 885: fnd_message.raise_error;

881: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
882: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
883: to_char(p_elig_per_elctbl_chc_id));
884: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
885: fnd_message.raise_error;
886: --
887: end if;
888: --
889: close c_enb;

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

898: if l_vpf.mlt_cd in ('CL','CLANDCVG','FLFXPCL') then
899: --
900: if l_vpf.comp_lvl_fctr_id is null then
901: --
902: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');
903: fnd_message.set_token('PACKAGE',l_package);
904: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
905: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
906: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

899: --
900: if l_vpf.comp_lvl_fctr_id is null then
901: --
902: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');
903: fnd_message.set_token('PACKAGE',l_package);
904: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
905: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
906: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
907: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

900: if l_vpf.comp_lvl_fctr_id is null then
901: --
902: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');
903: fnd_message.set_token('PACKAGE',l_package);
904: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
905: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
906: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
907: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
908: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

901: --
902: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');
903: fnd_message.set_token('PACKAGE',l_package);
904: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
905: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
906: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
907: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
908: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
909: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

902: fnd_message.set_name('BEN','BEN_91565_BENVRBRT_NULL_CLF');
903: fnd_message.set_token('PACKAGE',l_package);
904: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
905: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
906: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
907: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
908: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
909: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
910: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

903: fnd_message.set_token('PACKAGE',l_package);
904: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
905: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
906: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
907: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
908: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
909: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
910: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
911: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

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

904: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
905: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
906: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
907: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
908: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
909: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
910: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
911: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
912: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

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

905: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
906: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
907: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
908: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
909: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
910: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
911: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
912: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
913: to_char(p_elig_per_elctbl_chc_id));

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

906: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
907: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
908: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
909: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
910: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
911: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
912: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
913: to_char(p_elig_per_elctbl_chc_id));
914: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

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

907: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
908: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
909: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
910: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
911: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
912: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
913: to_char(p_elig_per_elctbl_chc_id));
914: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
915: fnd_message.raise_error;

Line 912: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

908: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
909: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
910: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
911: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
912: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
913: to_char(p_elig_per_elctbl_chc_id));
914: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
915: fnd_message.raise_error;
916: --

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

910: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
911: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
912: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
913: to_char(p_elig_per_elctbl_chc_id));
914: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
915: fnd_message.raise_error;
916: --
917: end if;
918: --

Line 915: fnd_message.raise_error;

911: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
912: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
913: to_char(p_elig_per_elctbl_chc_id));
914: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
915: fnd_message.raise_error;
916: --
917: end if;
918: --
919: ben_derive_factors.determine_compensation

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

945: open c_pgm(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
946: fetch c_pgm into l_pgm;
947: if c_pgm%notfound then
948: close c_pgm;
949: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
950: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
951: fnd_message.set_token('PACKAGE',l_package);
952: fnd_message.raise_error;
953: end if;

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

946: fetch c_pgm into l_pgm;
947: if c_pgm%notfound then
948: close c_pgm;
949: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
950: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
951: fnd_message.set_token('PACKAGE',l_package);
952: fnd_message.raise_error;
953: end if;
954: close c_pgm;

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

947: if c_pgm%notfound then
948: close c_pgm;
949: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
950: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
951: fnd_message.set_token('PACKAGE',l_package);
952: fnd_message.raise_error;
953: end if;
954: close c_pgm;
955: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;

Line 952: fnd_message.raise_error;

948: close c_pgm;
949: fnd_message.set_name('BEN','BEN_92410_BENACTBR_PGM_NF');
950: fnd_message.set_token('ID',to_char(l_epe.pgm_id));
951: fnd_message.set_token('PACKAGE',l_package);
952: fnd_message.raise_error;
953: end if;
954: close c_pgm;
955: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;
956: else

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

958: open c_pln(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
959: fetch c_pln into l_pln;
960: if c_pln%notfound then
961: close c_pln;
962: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
963: fnd_message.set_token('ID',to_char(l_epe.pl_id));
964: fnd_message.set_token('PACKAGE',l_package);
965: fnd_message.raise_error;
966: end if;

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

959: fetch c_pln into l_pln;
960: if c_pln%notfound then
961: close c_pln;
962: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
963: fnd_message.set_token('ID',to_char(l_epe.pl_id));
964: fnd_message.set_token('PACKAGE',l_package);
965: fnd_message.raise_error;
966: end if;
967: close c_pln;

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

960: if c_pln%notfound then
961: close c_pln;
962: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
963: fnd_message.set_token('ID',to_char(l_epe.pl_id));
964: fnd_message.set_token('PACKAGE',l_package);
965: fnd_message.raise_error;
966: end if;
967: close c_pln;
968: l_acty_ref_perd_cd := l_pln.nip_acty_ref_perd_cd;

Line 965: fnd_message.raise_error;

961: close c_pln;
962: fnd_message.set_name('BEN','BEN_92411_BENACTBR_PLN_NF');
963: fnd_message.set_token('ID',to_char(l_epe.pl_id));
964: fnd_message.set_token('PACKAGE',l_package);
965: fnd_message.raise_error;
966: end if;
967: close c_pln;
968: l_acty_ref_perd_cd := l_pln.nip_acty_ref_perd_cd;
969: end if;

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

1039: l_actl_prem_value := l_actl_prem_value * 12 / l_pay_annualization_factor;
1040: --
1041:
1042: else
1043: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
1044: fnd_message.set_token('PROC',l_package);
1045: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
1046: hr_utility.set_location (' FNDMS_RE 2 ',150);
1047: fnd_message.raise_error;

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

1040: --
1041:
1042: else
1043: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
1044: fnd_message.set_token('PROC',l_package);
1045: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
1046: hr_utility.set_location (' FNDMS_RE 2 ',150);
1047: fnd_message.raise_error;
1048: end if;

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

1041:
1042: else
1043: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
1044: fnd_message.set_token('PROC',l_package);
1045: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
1046: hr_utility.set_location (' FNDMS_RE 2 ',150);
1047: fnd_message.raise_error;
1048: end if;
1049: --

Line 1047: fnd_message.raise_error;

1043: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
1044: fnd_message.set_token('PROC',l_package);
1045: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
1046: hr_utility.set_location (' FNDMS_RE 2 ',150);
1047: fnd_message.raise_error;
1048: end if;
1049: --
1050: end if;
1051: --

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

1189: p_val := l_outputs(l_outputs.first).value;
1190: --
1191: else
1192: --
1193: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');
1194: hr_utility.set_location(l_package||' FND 91572 ',10);
1195: fnd_message.set_token('PACKAGE',l_package);
1196: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1197: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

1191: else
1192: --
1193: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');
1194: hr_utility.set_location(l_package||' FND 91572 ',10);
1195: fnd_message.set_token('PACKAGE',l_package);
1196: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1197: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1198: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1199: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

1192: --
1193: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');
1194: hr_utility.set_location(l_package||' FND 91572 ',10);
1195: fnd_message.set_token('PACKAGE',l_package);
1196: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1197: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1198: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1199: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1200: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

1193: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');
1194: hr_utility.set_location(l_package||' FND 91572 ',10);
1195: fnd_message.set_token('PACKAGE',l_package);
1196: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1197: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1198: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1199: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1200: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1201: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

1194: hr_utility.set_location(l_package||' FND 91572 ',10);
1195: fnd_message.set_token('PACKAGE',l_package);
1196: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1197: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1198: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1199: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1200: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1201: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1202: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1195: fnd_message.set_token('PACKAGE',l_package);
1196: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1197: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1198: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1199: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1200: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1201: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1202: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1203: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));

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

1196: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1197: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1198: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1199: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1200: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1201: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1202: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1203: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1204: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

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

1197: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1198: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1199: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1200: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1201: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1202: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1203: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1204: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1205: to_char(p_elig_per_elctbl_chc_id));

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

1198: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
1199: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1200: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1201: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1202: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1203: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1204: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1205: to_char(p_elig_per_elctbl_chc_id));
1206: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);

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

1199: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
1200: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1201: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1202: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1203: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1204: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1205: to_char(p_elig_per_elctbl_chc_id));
1206: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
1207: fnd_message.raise_error;

Line 1204: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

1200: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
1201: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
1202: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1203: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1204: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1205: to_char(p_elig_per_elctbl_chc_id));
1206: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
1207: fnd_message.raise_error;
1208: --

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

1202: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1203: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1204: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1205: to_char(p_elig_per_elctbl_chc_id));
1206: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
1207: fnd_message.raise_error;
1208: --
1209: end if; -- mult_cd
1210: --

Line 1207: fnd_message.raise_error;

1203: fnd_message.set_token('PER_IN_LER_ID',to_char(l_epe.per_in_ler_id));
1204: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
1205: to_char(p_elig_per_elctbl_chc_id));
1206: fnd_message.set_token('MLT_CD',l_vpf.mlt_cd);
1207: fnd_message.raise_error;
1208: --
1209: end if; -- mult_cd
1210: --
1211: -- assign other outputs