APPS.BEN_DETERMINE_COVERAGE dependencies on FND_MESSAGE

Line 2061: fnd_message.set_name('BEN','BEN_91837_BENCVRGE_INPT_EFFDT');

2057: -- Edit to insure that the input p_effective_date has a value
2058: --
2059: If (p_effective_date is null) then
2060: --
2061: fnd_message.set_name('BEN','BEN_91837_BENCVRGE_INPT_EFFDT');
2062: fnd_message.set_token('PACKAGE',l_package);
2063: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2064: to_char(p_elig_per_elctbl_chc_id));
2065: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

2058: --
2059: If (p_effective_date is null) then
2060: --
2061: fnd_message.set_name('BEN','BEN_91837_BENCVRGE_INPT_EFFDT');
2062: fnd_message.set_token('PACKAGE',l_package);
2063: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2064: to_char(p_elig_per_elctbl_chc_id));
2065: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2066: fnd_message.raise_error;

Line 2063: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

2059: If (p_effective_date is null) then
2060: --
2061: fnd_message.set_name('BEN','BEN_91837_BENCVRGE_INPT_EFFDT');
2062: fnd_message.set_token('PACKAGE',l_package);
2063: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2064: to_char(p_elig_per_elctbl_chc_id));
2065: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2066: fnd_message.raise_error;
2067: --

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

2061: fnd_message.set_name('BEN','BEN_91837_BENCVRGE_INPT_EFFDT');
2062: fnd_message.set_token('PACKAGE',l_package);
2063: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2064: to_char(p_elig_per_elctbl_chc_id));
2065: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2066: fnd_message.raise_error;
2067: --
2068: end if;
2069: --

Line 2066: fnd_message.raise_error;

2062: fnd_message.set_token('PACKAGE',l_package);
2063: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2064: to_char(p_elig_per_elctbl_chc_id));
2065: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2066: fnd_message.raise_error;
2067: --
2068: end if;
2069: --
2070: -- Edit to insure that the input p_elig_per_elctbl_chc_id has a value

Line 2074: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');

2070: -- Edit to insure that the input p_elig_per_elctbl_chc_id has a value
2071: --
2072: If (p_elig_per_elctbl_chc_id is null) then
2073: --
2074: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');
2075: fnd_message.set_token('PACKAGE',l_package);
2076: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2077: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2078: fnd_message.raise_error;

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

2071: --
2072: If (p_elig_per_elctbl_chc_id is null) then
2073: --
2074: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');
2075: fnd_message.set_token('PACKAGE',l_package);
2076: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2077: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2078: fnd_message.raise_error;
2079: --

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

2072: If (p_elig_per_elctbl_chc_id is null) then
2073: --
2074: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');
2075: fnd_message.set_token('PACKAGE',l_package);
2076: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2077: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2078: fnd_message.raise_error;
2079: --
2080: end if;

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

2073: --
2074: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');
2075: fnd_message.set_token('PACKAGE',l_package);
2076: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2077: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2078: fnd_message.raise_error;
2079: --
2080: end if;
2081: --

Line 2078: fnd_message.raise_error;

2074: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');
2075: fnd_message.set_token('PACKAGE',l_package);
2076: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2077: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2078: fnd_message.raise_error;
2079: --
2080: end if;
2081: --
2082: -- Deduce effective date

Line 2138: fnd_message.set_name('BEN','BEN_91839_BENCVRGE_EPE_NF');

2134: --
2135: if c_epe%notfound then
2136: --
2137: close c_epe;
2138: fnd_message.set_name('BEN','BEN_91839_BENCVRGE_EPE_NF');
2139: fnd_message.set_token('PACKAGE',l_package);
2140: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2141: to_char(p_elig_per_elctbl_chc_id));
2142: fnd_message.raise_error;

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

2135: if c_epe%notfound then
2136: --
2137: close c_epe;
2138: fnd_message.set_name('BEN','BEN_91839_BENCVRGE_EPE_NF');
2139: fnd_message.set_token('PACKAGE',l_package);
2140: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2141: to_char(p_elig_per_elctbl_chc_id));
2142: fnd_message.raise_error;
2143: --

Line 2140: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

2136: --
2137: close c_epe;
2138: fnd_message.set_name('BEN','BEN_91839_BENCVRGE_EPE_NF');
2139: fnd_message.set_token('PACKAGE',l_package);
2140: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2141: to_char(p_elig_per_elctbl_chc_id));
2142: fnd_message.raise_error;
2143: --
2144: end if;

Line 2142: fnd_message.raise_error;

2138: fnd_message.set_name('BEN','BEN_91839_BENCVRGE_EPE_NF');
2139: fnd_message.set_token('PACKAGE',l_package);
2140: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2141: to_char(p_elig_per_elctbl_chc_id));
2142: fnd_message.raise_error;
2143: --
2144: end if;
2145: --
2146: close c_epe;

Line 2197: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');

2193: l_person_id := l_epe.person_id;
2194: --
2195: if l_cvg(0).cvg_mlt_cd is null then
2196: --
2197: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');
2198: fnd_message.set_token('PACKAGE',l_package);
2199: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2200: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2201: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

2194: --
2195: if l_cvg(0).cvg_mlt_cd is null then
2196: --
2197: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');
2198: fnd_message.set_token('PACKAGE',l_package);
2199: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2200: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2201: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2202: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 2199: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));

2195: if l_cvg(0).cvg_mlt_cd is null then
2196: --
2197: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');
2198: fnd_message.set_token('PACKAGE',l_package);
2199: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2200: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2201: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2202: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2203: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

2196: --
2197: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');
2198: fnd_message.set_token('PACKAGE',l_package);
2199: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2200: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2201: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2202: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2203: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2204: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

2197: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');
2198: fnd_message.set_token('PACKAGE',l_package);
2199: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2200: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2201: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2202: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2203: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2204: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2205: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

2198: fnd_message.set_token('PACKAGE',l_package);
2199: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2200: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2201: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2202: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2203: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2204: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2205: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2206: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

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

2199: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2200: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2201: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2202: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2203: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2204: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2205: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2206: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2207: to_char(p_elig_per_elctbl_chc_id));

Line 2204: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

2200: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2201: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2202: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2203: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2204: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2205: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2206: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2207: to_char(p_elig_per_elctbl_chc_id));
2208: fnd_message.raise_error;

Line 2205: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

2201: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2202: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2203: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2204: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2205: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2206: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2207: to_char(p_elig_per_elctbl_chc_id));
2208: fnd_message.raise_error;
2209: --

Line 2206: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

2202: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2203: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2204: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2205: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2206: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2207: to_char(p_elig_per_elctbl_chc_id));
2208: fnd_message.raise_error;
2209: --
2210: end if;

Line 2208: fnd_message.raise_error;

2204: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2205: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2206: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2207: to_char(p_elig_per_elctbl_chc_id));
2208: fnd_message.raise_error;
2209: --
2210: end if;
2211: --
2212: if l_cvg(0).cvg_mlt_cd in ('FLFX','CL','FLPCLRNG','CLPFLRNG','FLFXPCL') then

Line 2216: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');

2212: if l_cvg(0).cvg_mlt_cd in ('FLFX','CL','FLPCLRNG','CLPFLRNG','FLFXPCL') then
2213: --
2214: if l_cvg(0).val is null and l_cvg(0).entr_val_at_enrt_flag = 'N' then
2215: --
2216: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
2217: fnd_message.set_token('PACKAGE',l_package);
2218: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2219: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2220: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

2213: --
2214: if l_cvg(0).val is null and l_cvg(0).entr_val_at_enrt_flag = 'N' then
2215: --
2216: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
2217: fnd_message.set_token('PACKAGE',l_package);
2218: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2219: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2220: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2221: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

Line 2218: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));

2214: if l_cvg(0).val is null and l_cvg(0).entr_val_at_enrt_flag = 'N' then
2215: --
2216: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
2217: fnd_message.set_token('PACKAGE',l_package);
2218: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2219: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2220: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2221: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2222: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 2219: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);

2215: --
2216: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
2217: fnd_message.set_token('PACKAGE',l_package);
2218: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2219: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2220: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2221: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2222: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2223: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

2216: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
2217: fnd_message.set_token('PACKAGE',l_package);
2218: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2219: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2220: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2221: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2222: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2223: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2224: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

2217: fnd_message.set_token('PACKAGE',l_package);
2218: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2219: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2220: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2221: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2222: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2223: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2224: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2225: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

2218: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2219: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2220: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2221: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2222: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2223: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2224: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2225: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2226: fnd_message.raise_error;

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

2219: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2220: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2221: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2222: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2223: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2224: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2225: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2226: fnd_message.raise_error;
2227: --

Line 2224: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

2220: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2221: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2222: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2223: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2224: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2225: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2226: fnd_message.raise_error;
2227: --
2228: end if;

Line 2225: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

2221: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2222: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2223: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2224: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2225: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2226: fnd_message.raise_error;
2227: --
2228: end if;
2229: --

Line 2226: fnd_message.raise_error;

2222: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2223: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2224: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2225: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2226: fnd_message.raise_error;
2227: --
2228: end if;
2229: --
2230: end if;

Line 2238: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');

2234: if l_cvg(0).mn_val is null or
2235: l_cvg(0).mx_val is null or
2236: l_cvg(0).incrmt_val is null then
2237: --
2238: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');
2239: fnd_message.set_token('PACKAGE',l_package);
2240: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2241: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2242: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

2235: l_cvg(0).mx_val is null or
2236: l_cvg(0).incrmt_val is null then
2237: --
2238: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');
2239: fnd_message.set_token('PACKAGE',l_package);
2240: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2241: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2242: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2243: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

Line 2240: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));

2236: l_cvg(0).incrmt_val is null then
2237: --
2238: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');
2239: fnd_message.set_token('PACKAGE',l_package);
2240: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2241: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2242: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2243: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2244: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 2241: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);

2237: --
2238: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');
2239: fnd_message.set_token('PACKAGE',l_package);
2240: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2241: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2242: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2243: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2244: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2245: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

2238: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');
2239: fnd_message.set_token('PACKAGE',l_package);
2240: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2241: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2242: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2243: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2244: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2245: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2246: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

2239: fnd_message.set_token('PACKAGE',l_package);
2240: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2241: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2242: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2243: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2244: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2245: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2246: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2247: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

2240: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2241: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2242: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2243: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2244: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2245: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2246: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2247: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2248: fnd_message.raise_error;

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

2241: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2242: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2243: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2244: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2245: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2246: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2247: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2248: fnd_message.raise_error;
2249: --

Line 2246: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

2242: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2243: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2244: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2245: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2246: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2247: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2248: fnd_message.raise_error;
2249: --
2250: end if;

Line 2247: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

2243: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2244: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2245: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2246: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2247: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2248: fnd_message.raise_error;
2249: --
2250: end if;
2251: --

Line 2248: fnd_message.raise_error;

2244: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2245: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2246: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2247: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2248: fnd_message.raise_error;
2249: --
2250: end if;
2251: --
2252: end if;

Line 2258: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');

2254: if l_cvg(0).cvg_mlt_cd in ('CL','CLRNG','FLFXPCL','FLPCLRNG','CLPFLRNG') then
2255: --
2256: if l_cvg(0).comp_lvl_fctr_id is null then
2257: --
2258: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');
2259: fnd_message.set_token('PACKAGE',l_package);
2260: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2261: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2262: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

2255: --
2256: if l_cvg(0).comp_lvl_fctr_id is null then
2257: --
2258: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');
2259: fnd_message.set_token('PACKAGE',l_package);
2260: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2261: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2262: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2263: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

Line 2260: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));

2256: if l_cvg(0).comp_lvl_fctr_id is null then
2257: --
2258: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');
2259: fnd_message.set_token('PACKAGE',l_package);
2260: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2261: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2262: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2263: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2264: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 2261: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);

2257: --
2258: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');
2259: fnd_message.set_token('PACKAGE',l_package);
2260: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2261: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2262: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2263: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2264: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2265: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

2258: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');
2259: fnd_message.set_token('PACKAGE',l_package);
2260: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2261: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2262: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2263: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2264: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2265: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2266: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

2259: fnd_message.set_token('PACKAGE',l_package);
2260: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2261: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2262: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2263: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2264: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2265: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2266: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2267: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

2260: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2261: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2262: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2263: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2264: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2265: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2266: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2267: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2268: fnd_message.raise_error;

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

2261: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2262: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2263: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2264: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2265: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2266: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2267: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2268: fnd_message.raise_error;
2269: --

Line 2266: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

2262: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2263: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2264: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2265: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2266: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2267: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2268: fnd_message.raise_error;
2269: --
2270: end if;

Line 2267: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

2263: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2264: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2265: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2266: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2267: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2268: fnd_message.raise_error;
2269: --
2270: end if;
2271: --

Line 2268: fnd_message.raise_error;

2264: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2265: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2266: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2267: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2268: fnd_message.raise_error;
2269: --
2270: end if;
2271: --
2272: ben_derive_factors.determine_compensation

Line 2295: fnd_message.set_name('BEN','BEN_92488_BENCVRGE_INVALID_VAL');

2291: fetch c_clf into l_clf;
2292: close c_clf;
2293:
2294: --
2295: fnd_message.set_name('BEN','BEN_92488_BENCVRGE_INVALID_VAL');
2296: fnd_message.set_token('PERSON_ID',l_epe.person_id);
2297: /*
2298: if l_clf.comp_src_cd = 'STTDCOMP' then
2299:

Line 2296: fnd_message.set_token('PERSON_ID',l_epe.person_id);

2292: close c_clf;
2293:
2294: --
2295: fnd_message.set_name('BEN','BEN_92488_BENCVRGE_INVALID_VAL');
2296: fnd_message.set_token('PERSON_ID',l_epe.person_id);
2297: /*
2298: if l_clf.comp_src_cd = 'STTDCOMP' then
2299:
2300: fnd_message.set_token('COMP_CODE',' stated Salary, '||l_clf.name);

Line 2300: fnd_message.set_token('COMP_CODE',' stated Salary, '||l_clf.name);

2296: fnd_message.set_token('PERSON_ID',l_epe.person_id);
2297: /*
2298: if l_clf.comp_src_cd = 'STTDCOMP' then
2299:
2300: fnd_message.set_token('COMP_CODE',' stated Salary, '||l_clf.name);
2301:
2302: elsif l_clf.comp_src_cd = 'BALTYP' then
2303:
2304: fnd_message.set_token('COMP_CODE',' benefits balance, '||l_clf.name);

Line 2304: fnd_message.set_token('COMP_CODE',' benefits balance, '||l_clf.name);

2300: fnd_message.set_token('COMP_CODE',' stated Salary, '||l_clf.name);
2301:
2302: elsif l_clf.comp_src_cd = 'BALTYP' then
2303:
2304: fnd_message.set_token('COMP_CODE',' benefits balance, '||l_clf.name);
2305:
2306: elsif l_clf.comp_src_cd = 'BNFTBALTYP' then
2307:
2308: fnd_message.set_token('COMP_CODE',' defined balance, '||l_clf.name);

Line 2308: fnd_message.set_token('COMP_CODE',' defined balance, '||l_clf.name);

2304: fnd_message.set_token('COMP_CODE',' benefits balance, '||l_clf.name);
2305:
2306: elsif l_clf.comp_src_cd = 'BNFTBALTYP' then
2307:
2308: fnd_message.set_token('COMP_CODE',' defined balance, '||l_clf.name);
2309:
2310: end if;
2311: */
2312: --

Line 2313: fnd_message.set_token('COMP_FCTR',hr_general.decode_lookup

2309:
2310: end if;
2311: */
2312: --
2313: fnd_message.set_token('COMP_FCTR',hr_general.decode_lookup
2314: ( p_lookup_type => 'BEN_COMP_SRC' ,
2315: p_lookup_code => l_clf.comp_src_cd
2316: )
2317: );

Line 2319: fnd_message.set_token('COMP_CODE',l_clf.name);

2315: p_lookup_code => l_clf.comp_src_cd
2316: )
2317: );
2318:
2319: fnd_message.set_token('COMP_CODE',l_clf.name);
2320: fnd_message.set_token('PACKAGE',l_package);
2321: raise ben_manage_life_events.g_record_error;
2322: --
2323: end if;

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

2316: )
2317: );
2318:
2319: fnd_message.set_token('COMP_CODE',l_clf.name);
2320: fnd_message.set_token('PACKAGE',l_package);
2321: raise ben_manage_life_events.g_record_error;
2322: --
2323: end if;
2324: --

Line 4626: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');

4622: p_combined_val => l_combined_val);
4623: --
4624: if l_combined_val is null or l_combined_val = 0 then
4625: --
4626: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
4627: fnd_message.set_token('PACKAGE',l_package);
4628: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4629: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4630: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

4623: --
4624: if l_combined_val is null or l_combined_val = 0 then
4625: --
4626: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
4627: fnd_message.set_token('PACKAGE',l_package);
4628: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4629: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4630: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4631: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

Line 4628: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));

4624: if l_combined_val is null or l_combined_val = 0 then
4625: --
4626: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
4627: fnd_message.set_token('PACKAGE',l_package);
4628: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4629: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4630: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4631: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4632: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 4629: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);

4625: --
4626: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
4627: fnd_message.set_token('PACKAGE',l_package);
4628: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4629: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4630: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4631: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4632: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
4633: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

4626: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
4627: fnd_message.set_token('PACKAGE',l_package);
4628: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4629: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4630: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4631: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4632: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
4633: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
4634: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

4627: fnd_message.set_token('PACKAGE',l_package);
4628: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4629: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4630: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4631: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4632: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
4633: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
4634: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
4635: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

4628: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4629: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4630: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4631: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4632: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
4633: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
4634: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
4635: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
4636: fnd_message.raise_error;

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

4629: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4630: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4631: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4632: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
4633: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
4634: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
4635: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
4636: fnd_message.raise_error;
4637: --

Line 4634: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

4630: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4631: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4632: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
4633: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
4634: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
4635: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
4636: fnd_message.raise_error;
4637: --
4638: end if;

Line 4635: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

4631: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4632: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
4633: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
4634: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
4635: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
4636: fnd_message.raise_error;
4637: --
4638: end if;
4639: --

Line 4636: fnd_message.raise_error;

4632: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
4633: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
4634: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
4635: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
4636: fnd_message.raise_error;
4637: --
4638: end if;
4639: --
4640: --Bug 5933576 Adding chk_bnft_ctfn for NSVU as well

Line 4993: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');

4989: end if;
4990: --
4991: else
4992: --
4993: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');
4994: fnd_message.set_token('PACKAGE',l_package);
4995: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4996: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4997: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

4990: --
4991: else
4992: --
4993: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');
4994: fnd_message.set_token('PACKAGE',l_package);
4995: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4996: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4997: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4998: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

Line 4995: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));

4991: else
4992: --
4993: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');
4994: fnd_message.set_token('PACKAGE',l_package);
4995: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4996: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4997: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4998: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4999: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 4996: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);

4992: --
4993: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');
4994: fnd_message.set_token('PACKAGE',l_package);
4995: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4996: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4997: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4998: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4999: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5000: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

4993: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');
4994: fnd_message.set_token('PACKAGE',l_package);
4995: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4996: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4997: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4998: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4999: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5000: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5001: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

4994: fnd_message.set_token('PACKAGE',l_package);
4995: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4996: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4997: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4998: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4999: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5000: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5001: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5002: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

4995: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
4996: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4997: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4998: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4999: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5000: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5001: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5002: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5003: fnd_message.raise_error;

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

4996: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
4997: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4998: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4999: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5000: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5001: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5002: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5003: fnd_message.raise_error;
5004: --

Line 5001: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

4997: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
4998: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4999: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5000: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5001: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5002: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5003: fnd_message.raise_error;
5004: --
5005: end if;

Line 5002: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

4998: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
4999: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5000: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5001: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5002: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5003: fnd_message.raise_error;
5004: --
5005: end if;
5006: --

Line 5003: fnd_message.raise_error;

4999: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5000: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5001: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5002: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5003: fnd_message.raise_error;
5004: --
5005: end if;
5006: --
5007: -- This following routine need to create an additional benefit row, if