APPS.BEN_DETERMINE_COVERAGE dependencies on FND_MESSAGE

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

2321: -- Edit to insure that the input p_effective_date has a value
2322: --
2323: If (p_effective_date is null) then
2324: --
2325: fnd_message.set_name('BEN','BEN_91837_BENCVRGE_INPT_EFFDT');
2326: fnd_message.set_token('PACKAGE',l_package);
2327: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2328: to_char(p_elig_per_elctbl_chc_id));
2329: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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

2322: --
2323: If (p_effective_date is null) then
2324: --
2325: fnd_message.set_name('BEN','BEN_91837_BENCVRGE_INPT_EFFDT');
2326: fnd_message.set_token('PACKAGE',l_package);
2327: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2328: to_char(p_elig_per_elctbl_chc_id));
2329: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2330: fnd_message.raise_error;

Line 2327: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

2323: If (p_effective_date is null) then
2324: --
2325: fnd_message.set_name('BEN','BEN_91837_BENCVRGE_INPT_EFFDT');
2326: fnd_message.set_token('PACKAGE',l_package);
2327: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2328: to_char(p_elig_per_elctbl_chc_id));
2329: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2330: fnd_message.raise_error;
2331: --

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

2325: fnd_message.set_name('BEN','BEN_91837_BENCVRGE_INPT_EFFDT');
2326: fnd_message.set_token('PACKAGE',l_package);
2327: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2328: to_char(p_elig_per_elctbl_chc_id));
2329: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2330: fnd_message.raise_error;
2331: --
2332: end if;
2333: --

Line 2330: fnd_message.raise_error;

2326: fnd_message.set_token('PACKAGE',l_package);
2327: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2328: to_char(p_elig_per_elctbl_chc_id));
2329: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2330: fnd_message.raise_error;
2331: --
2332: end if;
2333: --
2334: -- Edit to insure that the input p_elig_per_elctbl_chc_id has a value

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

2334: -- Edit to insure that the input p_elig_per_elctbl_chc_id has a value
2335: --
2336: If (p_elig_per_elctbl_chc_id is null) then
2337: --
2338: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');
2339: fnd_message.set_token('PACKAGE',l_package);
2340: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2341: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2342: fnd_message.raise_error;

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

2335: --
2336: If (p_elig_per_elctbl_chc_id is null) then
2337: --
2338: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');
2339: fnd_message.set_token('PACKAGE',l_package);
2340: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2341: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2342: fnd_message.raise_error;
2343: --

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

2336: If (p_elig_per_elctbl_chc_id is null) then
2337: --
2338: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');
2339: fnd_message.set_token('PACKAGE',l_package);
2340: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2341: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2342: fnd_message.raise_error;
2343: --
2344: end if;

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

2337: --
2338: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');
2339: fnd_message.set_token('PACKAGE',l_package);
2340: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2341: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2342: fnd_message.raise_error;
2343: --
2344: end if;
2345: --

Line 2342: fnd_message.raise_error;

2338: fnd_message.set_name('BEN','BEN_91838_BENCVRGE_INPT_EC');
2339: fnd_message.set_token('PACKAGE',l_package);
2340: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2341: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2342: fnd_message.raise_error;
2343: --
2344: end if;
2345: --
2346: -- Deduce effective date

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

2398: --
2399: if c_epe%notfound then
2400: --
2401: close c_epe;
2402: fnd_message.set_name('BEN','BEN_91839_BENCVRGE_EPE_NF');
2403: fnd_message.set_token('PACKAGE',l_package);
2404: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2405: to_char(p_elig_per_elctbl_chc_id));
2406: fnd_message.raise_error;

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

2399: if c_epe%notfound then
2400: --
2401: close c_epe;
2402: fnd_message.set_name('BEN','BEN_91839_BENCVRGE_EPE_NF');
2403: fnd_message.set_token('PACKAGE',l_package);
2404: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2405: to_char(p_elig_per_elctbl_chc_id));
2406: fnd_message.raise_error;
2407: --

Line 2404: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

2400: --
2401: close c_epe;
2402: fnd_message.set_name('BEN','BEN_91839_BENCVRGE_EPE_NF');
2403: fnd_message.set_token('PACKAGE',l_package);
2404: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2405: to_char(p_elig_per_elctbl_chc_id));
2406: fnd_message.raise_error;
2407: --
2408: end if;

Line 2406: fnd_message.raise_error;

2402: fnd_message.set_name('BEN','BEN_91839_BENCVRGE_EPE_NF');
2403: fnd_message.set_token('PACKAGE',l_package);
2404: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2405: to_char(p_elig_per_elctbl_chc_id));
2406: fnd_message.raise_error;
2407: --
2408: end if;
2409: --
2410: close c_epe;

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

2457: l_person_id := l_epe.person_id;
2458: --
2459: if l_cvg(0).cvg_mlt_cd is null then
2460: --
2461: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');
2462: fnd_message.set_token('PACKAGE',l_package);
2463: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2464: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2465: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

2458: --
2459: if l_cvg(0).cvg_mlt_cd is null then
2460: --
2461: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');
2462: fnd_message.set_token('PACKAGE',l_package);
2463: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2464: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2465: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2466: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

2459: if l_cvg(0).cvg_mlt_cd is null then
2460: --
2461: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');
2462: fnd_message.set_token('PACKAGE',l_package);
2463: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2464: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2465: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2466: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2467: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

2460: --
2461: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');
2462: fnd_message.set_token('PACKAGE',l_package);
2463: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2464: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2465: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2466: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2467: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2468: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

2461: fnd_message.set_name('BEN','BEN_91840_BENCVRGE_MLT_CD_RQD');
2462: fnd_message.set_token('PACKAGE',l_package);
2463: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2464: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2465: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2466: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2467: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2468: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2469: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

2462: fnd_message.set_token('PACKAGE',l_package);
2463: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2464: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2465: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2466: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2467: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2468: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2469: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2470: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

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

2463: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2464: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2465: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2466: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2467: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2468: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2469: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2470: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2471: to_char(p_elig_per_elctbl_chc_id));

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

2464: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2465: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2466: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2467: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2468: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2469: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2470: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2471: to_char(p_elig_per_elctbl_chc_id));
2472: fnd_message.raise_error;

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

2465: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2466: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2467: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2468: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2469: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2470: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2471: to_char(p_elig_per_elctbl_chc_id));
2472: fnd_message.raise_error;
2473: --

Line 2470: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',

2466: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2467: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2468: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2469: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2470: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2471: to_char(p_elig_per_elctbl_chc_id));
2472: fnd_message.raise_error;
2473: --
2474: end if;

Line 2472: fnd_message.raise_error;

2468: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2469: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2470: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',
2471: to_char(p_elig_per_elctbl_chc_id));
2472: fnd_message.raise_error;
2473: --
2474: end if;
2475: --
2476: if l_cvg(0).cvg_mlt_cd in ('FLFX','CL','FLPCLRNG','CLPFLRNG','FLFXPCL') then

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

2476: if l_cvg(0).cvg_mlt_cd in ('FLFX','CL','FLPCLRNG','CLPFLRNG','FLFXPCL') then
2477: --
2478: if l_cvg(0).val is null and l_cvg(0).entr_val_at_enrt_flag = 'N' then
2479: --
2480: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
2481: fnd_message.set_token('PACKAGE',l_package);
2482: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2483: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2484: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

2477: --
2478: if l_cvg(0).val is null and l_cvg(0).entr_val_at_enrt_flag = 'N' then
2479: --
2480: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
2481: fnd_message.set_token('PACKAGE',l_package);
2482: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2483: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2484: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2485: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

2478: if l_cvg(0).val is null and l_cvg(0).entr_val_at_enrt_flag = 'N' then
2479: --
2480: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
2481: fnd_message.set_token('PACKAGE',l_package);
2482: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2483: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2484: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2485: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2486: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

2479: --
2480: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
2481: fnd_message.set_token('PACKAGE',l_package);
2482: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2483: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2484: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2485: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2486: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2487: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

2480: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
2481: fnd_message.set_token('PACKAGE',l_package);
2482: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2483: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2484: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2485: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2486: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2487: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2488: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

2481: fnd_message.set_token('PACKAGE',l_package);
2482: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2483: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2484: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2485: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2486: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2487: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2488: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2489: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

2482: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2483: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2484: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2485: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2486: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2487: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2488: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2489: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2490: fnd_message.raise_error;

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

2483: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2484: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2485: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2486: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2487: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2488: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2489: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2490: fnd_message.raise_error;
2491: --

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

2484: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2485: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2486: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2487: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2488: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2489: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2490: fnd_message.raise_error;
2491: --
2492: end if;

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

2485: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2486: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2487: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2488: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2489: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2490: fnd_message.raise_error;
2491: --
2492: end if;
2493: --

Line 2490: fnd_message.raise_error;

2486: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2487: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2488: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2489: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2490: fnd_message.raise_error;
2491: --
2492: end if;
2493: --
2494: end if;

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

2498: if l_cvg(0).mn_val is null or
2499: l_cvg(0).mx_val is null or
2500: l_cvg(0).incrmt_val is null then
2501: --
2502: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');
2503: fnd_message.set_token('PACKAGE',l_package);
2504: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2505: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2506: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

2499: l_cvg(0).mx_val is null or
2500: l_cvg(0).incrmt_val is null then
2501: --
2502: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');
2503: fnd_message.set_token('PACKAGE',l_package);
2504: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2505: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2506: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2507: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

2500: l_cvg(0).incrmt_val is null then
2501: --
2502: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');
2503: fnd_message.set_token('PACKAGE',l_package);
2504: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2505: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2506: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2507: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2508: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

2501: --
2502: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');
2503: fnd_message.set_token('PACKAGE',l_package);
2504: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2505: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2506: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2507: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2508: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2509: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

2502: fnd_message.set_name('BEN','BEN_91842_BENCVRGE_MX_MN_INC_R');
2503: fnd_message.set_token('PACKAGE',l_package);
2504: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2505: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2506: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2507: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2508: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2509: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2510: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

2503: fnd_message.set_token('PACKAGE',l_package);
2504: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2505: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2506: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2507: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2508: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2509: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2510: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2511: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

2504: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2505: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2506: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2507: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2508: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2509: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2510: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2511: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2512: fnd_message.raise_error;

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

2505: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2506: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2507: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2508: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2509: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2510: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2511: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2512: fnd_message.raise_error;
2513: --

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

2506: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2507: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2508: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2509: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2510: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2511: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2512: fnd_message.raise_error;
2513: --
2514: end if;

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

2507: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2508: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2509: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2510: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2511: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2512: fnd_message.raise_error;
2513: --
2514: end if;
2515: --

Line 2512: fnd_message.raise_error;

2508: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2509: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2510: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2511: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2512: fnd_message.raise_error;
2513: --
2514: end if;
2515: --
2516: end if;

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

2518: if l_cvg(0).cvg_mlt_cd in ('CL','CLRNG','FLFXPCL','FLPCLRNG','CLPFLRNG') then
2519: --
2520: if l_cvg(0).comp_lvl_fctr_id is null then
2521: --
2522: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');
2523: fnd_message.set_token('PACKAGE',l_package);
2524: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2525: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2526: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

2519: --
2520: if l_cvg(0).comp_lvl_fctr_id is null then
2521: --
2522: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');
2523: fnd_message.set_token('PACKAGE',l_package);
2524: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2525: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2526: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2527: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

2520: if l_cvg(0).comp_lvl_fctr_id is null then
2521: --
2522: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');
2523: fnd_message.set_token('PACKAGE',l_package);
2524: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2525: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2526: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2527: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2528: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

2521: --
2522: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');
2523: fnd_message.set_token('PACKAGE',l_package);
2524: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2525: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2526: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2527: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2528: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2529: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

2522: fnd_message.set_name('BEN','BEN_91843_BENCVRGE_NULL_CLF');
2523: fnd_message.set_token('PACKAGE',l_package);
2524: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2525: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2526: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2527: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2528: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2529: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2530: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

2523: fnd_message.set_token('PACKAGE',l_package);
2524: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2525: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2526: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2527: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2528: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2529: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2530: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2531: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

2524: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
2525: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2526: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2527: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2528: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2529: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2530: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2531: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2532: fnd_message.raise_error;

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

2525: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
2526: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2527: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2528: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2529: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2530: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2531: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2532: fnd_message.raise_error;
2533: --

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

2526: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
2527: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2528: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2529: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2530: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2531: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2532: fnd_message.raise_error;
2533: --
2534: end if;

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

2527: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
2528: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2529: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2530: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2531: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2532: fnd_message.raise_error;
2533: --
2534: end if;
2535: --

Line 2532: fnd_message.raise_error;

2528: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
2529: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
2530: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
2531: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
2532: fnd_message.raise_error;
2533: --
2534: end if;
2535: --
2536: ben_derive_factors.determine_compensation

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

2555: fetch c_clf into l_clf;
2556: close c_clf;
2557:
2558: --
2559: fnd_message.set_name('BEN','BEN_92488_BENCVRGE_INVALID_VAL');
2560: fnd_message.set_token('PERSON_ID',l_epe.person_id);
2561: /*
2562: if l_clf.comp_src_cd = 'STTDCOMP' then
2563:

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

2556: close c_clf;
2557:
2558: --
2559: fnd_message.set_name('BEN','BEN_92488_BENCVRGE_INVALID_VAL');
2560: fnd_message.set_token('PERSON_ID',l_epe.person_id);
2561: /*
2562: if l_clf.comp_src_cd = 'STTDCOMP' then
2563:
2564: fnd_message.set_token('COMP_CODE',' stated Salary, '||l_clf.name);

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

2560: fnd_message.set_token('PERSON_ID',l_epe.person_id);
2561: /*
2562: if l_clf.comp_src_cd = 'STTDCOMP' then
2563:
2564: fnd_message.set_token('COMP_CODE',' stated Salary, '||l_clf.name);
2565:
2566: elsif l_clf.comp_src_cd = 'BALTYP' then
2567:
2568: fnd_message.set_token('COMP_CODE',' benefits balance, '||l_clf.name);

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

2564: fnd_message.set_token('COMP_CODE',' stated Salary, '||l_clf.name);
2565:
2566: elsif l_clf.comp_src_cd = 'BALTYP' then
2567:
2568: fnd_message.set_token('COMP_CODE',' benefits balance, '||l_clf.name);
2569:
2570: elsif l_clf.comp_src_cd = 'BNFTBALTYP' then
2571:
2572: fnd_message.set_token('COMP_CODE',' defined balance, '||l_clf.name);

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

2568: fnd_message.set_token('COMP_CODE',' benefits balance, '||l_clf.name);
2569:
2570: elsif l_clf.comp_src_cd = 'BNFTBALTYP' then
2571:
2572: fnd_message.set_token('COMP_CODE',' defined balance, '||l_clf.name);
2573:
2574: end if;
2575: */
2576: --

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

2573:
2574: end if;
2575: */
2576: --
2577: fnd_message.set_token('COMP_FCTR',hr_general.decode_lookup
2578: ( p_lookup_type => 'BEN_COMP_SRC' ,
2579: p_lookup_code => l_clf.comp_src_cd
2580: )
2581: );

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

2579: p_lookup_code => l_clf.comp_src_cd
2580: )
2581: );
2582:
2583: fnd_message.set_token('COMP_CODE',l_clf.name);
2584: fnd_message.set_token('PACKAGE',l_package);
2585: raise ben_manage_life_events.g_record_error;
2586: --
2587: end if;

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

2580: )
2581: );
2582:
2583: fnd_message.set_token('COMP_CODE',l_clf.name);
2584: fnd_message.set_token('PACKAGE',l_package);
2585: raise ben_manage_life_events.g_record_error;
2586: --
2587: end if;
2588: --

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

5115: p_combined_val => l_combined_val);
5116: --
5117: if l_combined_val is null or l_combined_val = 0 then
5118: --
5119: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
5120: fnd_message.set_token('PACKAGE',l_package);
5121: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5122: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5123: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

5116: --
5117: if l_combined_val is null or l_combined_val = 0 then
5118: --
5119: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
5120: fnd_message.set_token('PACKAGE',l_package);
5121: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5122: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5123: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5124: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

5117: if l_combined_val is null or l_combined_val = 0 then
5118: --
5119: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
5120: fnd_message.set_token('PACKAGE',l_package);
5121: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5122: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5123: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5124: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5125: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

5118: --
5119: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
5120: fnd_message.set_token('PACKAGE',l_package);
5121: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5122: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5123: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5124: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5125: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5126: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

5119: fnd_message.set_name('BEN','BEN_91841_BENCVRGE_VAL_RQD');
5120: fnd_message.set_token('PACKAGE',l_package);
5121: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5122: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5123: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5124: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5125: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5126: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5127: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

5120: fnd_message.set_token('PACKAGE',l_package);
5121: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5122: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5123: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5124: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5125: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5126: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5127: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5128: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

5121: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5122: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5123: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5124: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5125: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5126: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5127: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5128: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5129: fnd_message.raise_error;

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

5122: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5123: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5124: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5125: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5126: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5127: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5128: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5129: fnd_message.raise_error;
5130: --

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

5123: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5124: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5125: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5126: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5127: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5128: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5129: fnd_message.raise_error;
5130: --
5131: end if;

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

5124: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5125: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5126: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5127: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5128: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5129: fnd_message.raise_error;
5130: --
5131: end if;
5132: --

Line 5129: fnd_message.raise_error;

5125: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5126: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5127: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5128: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5129: fnd_message.raise_error;
5130: --
5131: end if;
5132: --
5133: --Bug 5933576 Adding chk_bnft_ctfn for NSVU as well

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

5482: end if;
5483: --
5484: else
5485: --
5486: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');
5487: fnd_message.set_token('PACKAGE',l_package);
5488: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5489: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5490: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));

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

5483: --
5484: else
5485: --
5486: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');
5487: fnd_message.set_token('PACKAGE',l_package);
5488: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5489: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5490: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5491: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));

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

5484: else
5485: --
5486: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');
5487: fnd_message.set_token('PACKAGE',l_package);
5488: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5489: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5490: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5491: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5492: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

5485: --
5486: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');
5487: fnd_message.set_token('PACKAGE',l_package);
5488: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5489: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5490: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5491: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5492: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5493: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));

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

5486: fnd_message.set_name('BEN','BEN_91844_BENCVRGE_MLT_CD');
5487: fnd_message.set_token('PACKAGE',l_package);
5488: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5489: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5490: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5491: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5492: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5493: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5494: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));

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

5487: fnd_message.set_token('PACKAGE',l_package);
5488: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5489: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5490: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5491: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5492: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5493: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5494: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5495: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));

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

5488: fnd_message.set_token('PERSON_ID',to_char(l_epe.person_id));
5489: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5490: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5491: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5492: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5493: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5494: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5495: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5496: fnd_message.raise_error;

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

5489: fnd_message.set_token('CALC_MTHD',l_cvg(0).cvg_mlt_cd);
5490: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5491: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5492: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5493: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5494: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5495: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5496: fnd_message.raise_error;
5497: --

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

5490: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
5491: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5492: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5493: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5494: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5495: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5496: fnd_message.raise_error;
5497: --
5498: end if;

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

5491: fnd_message.set_token('PL_ID',to_char(l_epe.pl_id));
5492: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5493: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5494: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5495: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5496: fnd_message.raise_error;
5497: --
5498: end if;
5499: --

Line 5496: fnd_message.raise_error;

5492: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));
5493: fnd_message.set_token('OIPL_ID',to_char(l_epe.oipl_id));
5494: fnd_message.set_token('PLIP_ID',to_char(l_epe.plip_id));
5495: fnd_message.set_token('PTIP_ID',to_char(l_epe.ptip_id));
5496: fnd_message.raise_error;
5497: --
5498: end if;
5499: --
5500: -- This following routine need to create an additional benefit row, if