2035: IF (p_effective_date IS NULL) THEN
2036: if g_debug then
2037: hr_utility.set_location('BEN_91552_BENRATES_INPT_EFFDT', 10);
2038: end if;
2039: fnd_message.set_name('BEN', 'BEN_91552_BENRATES_INPT_EFFDT');
2040: fnd_message.set_token('PACKAGE', l_package);
2041: fnd_message.set_token('PERSON_ID', p_person_id);
2042: fnd_message.set_token('LF_EVT_OCRD_DT', p_lf_evt_ocrd_dt);
2043: fnd_message.raise_error;
2036: if g_debug then
2037: hr_utility.set_location('BEN_91552_BENRATES_INPT_EFFDT', 10);
2038: end if;
2039: fnd_message.set_name('BEN', 'BEN_91552_BENRATES_INPT_EFFDT');
2040: fnd_message.set_token('PACKAGE', l_package);
2041: fnd_message.set_token('PERSON_ID', p_person_id);
2042: fnd_message.set_token('LF_EVT_OCRD_DT', p_lf_evt_ocrd_dt);
2043: fnd_message.raise_error;
2044: END IF;
2037: hr_utility.set_location('BEN_91552_BENRATES_INPT_EFFDT', 10);
2038: end if;
2039: fnd_message.set_name('BEN', 'BEN_91552_BENRATES_INPT_EFFDT');
2040: fnd_message.set_token('PACKAGE', l_package);
2041: fnd_message.set_token('PERSON_ID', p_person_id);
2042: fnd_message.set_token('LF_EVT_OCRD_DT', p_lf_evt_ocrd_dt);
2043: fnd_message.raise_error;
2044: END IF;
2045: --
2038: end if;
2039: fnd_message.set_name('BEN', 'BEN_91552_BENRATES_INPT_EFFDT');
2040: fnd_message.set_token('PACKAGE', l_package);
2041: fnd_message.set_token('PERSON_ID', p_person_id);
2042: fnd_message.set_token('LF_EVT_OCRD_DT', p_lf_evt_ocrd_dt);
2043: fnd_message.raise_error;
2044: END IF;
2045: --
2046: l_effective_date := NVL(p_lf_evt_ocrd_dt, p_effective_date);
2039: fnd_message.set_name('BEN', 'BEN_91552_BENRATES_INPT_EFFDT');
2040: fnd_message.set_token('PACKAGE', l_package);
2041: fnd_message.set_token('PERSON_ID', p_person_id);
2042: fnd_message.set_token('LF_EVT_OCRD_DT', p_lf_evt_ocrd_dt);
2043: fnd_message.raise_error;
2044: END IF;
2045: --
2046: l_effective_date := NVL(p_lf_evt_ocrd_dt, p_effective_date);
2047: --
2469: ELSE
2470: if g_debug then
2471: hr_utility.set_location('BEN_91553_BENRATES_UNKN_COMP ', 10);
2472: end if;
2473: fnd_message.set_name('BEN', 'BEN_91553_BENRATES_UNKN_COMP');
2474: fnd_message.set_token('PACKAGE', l_package);
2475: fnd_message.set_token('PERSON_ID', TO_CHAR(l_currepe_row.person_id));
2476: fnd_message.set_token(
2477: 'ELIG_PER_ELCTBL_CHC_ID',
2470: if g_debug then
2471: hr_utility.set_location('BEN_91553_BENRATES_UNKN_COMP ', 10);
2472: end if;
2473: fnd_message.set_name('BEN', 'BEN_91553_BENRATES_UNKN_COMP');
2474: fnd_message.set_token('PACKAGE', l_package);
2475: fnd_message.set_token('PERSON_ID', TO_CHAR(l_currepe_row.person_id));
2476: fnd_message.set_token(
2477: 'ELIG_PER_ELCTBL_CHC_ID',
2478: TO_CHAR(l_currepe_row.elig_per_elctbl_chc_id));
2471: hr_utility.set_location('BEN_91553_BENRATES_UNKN_COMP ', 10);
2472: end if;
2473: fnd_message.set_name('BEN', 'BEN_91553_BENRATES_UNKN_COMP');
2474: fnd_message.set_token('PACKAGE', l_package);
2475: fnd_message.set_token('PERSON_ID', TO_CHAR(l_currepe_row.person_id));
2476: fnd_message.set_token(
2477: 'ELIG_PER_ELCTBL_CHC_ID',
2478: TO_CHAR(l_currepe_row.elig_per_elctbl_chc_id));
2479: fnd_message.set_token('PGM_ID', TO_CHAR(l_currepe_row.pgm_id));
2472: end if;
2473: fnd_message.set_name('BEN', 'BEN_91553_BENRATES_UNKN_COMP');
2474: fnd_message.set_token('PACKAGE', l_package);
2475: fnd_message.set_token('PERSON_ID', TO_CHAR(l_currepe_row.person_id));
2476: fnd_message.set_token(
2477: 'ELIG_PER_ELCTBL_CHC_ID',
2478: TO_CHAR(l_currepe_row.elig_per_elctbl_chc_id));
2479: fnd_message.set_token('PGM_ID', TO_CHAR(l_currepe_row.pgm_id));
2480: fnd_message.set_token('PL_ID', TO_CHAR(l_currepe_row.pl_id));
2475: fnd_message.set_token('PERSON_ID', TO_CHAR(l_currepe_row.person_id));
2476: fnd_message.set_token(
2477: 'ELIG_PER_ELCTBL_CHC_ID',
2478: TO_CHAR(l_currepe_row.elig_per_elctbl_chc_id));
2479: fnd_message.set_token('PGM_ID', TO_CHAR(l_currepe_row.pgm_id));
2480: fnd_message.set_token('PL_ID', TO_CHAR(l_currepe_row.pl_id));
2481: fnd_message.set_token('OIPL_ID', TO_CHAR(l_currepe_row.oipl_id));
2482: fnd_message.set_token('PLIP_ID', TO_CHAR(l_currepe_row.plip_id));
2483: fnd_message.set_token('PTIP_ID', TO_CHAR(l_currepe_row.ptip_id));
2476: fnd_message.set_token(
2477: 'ELIG_PER_ELCTBL_CHC_ID',
2478: TO_CHAR(l_currepe_row.elig_per_elctbl_chc_id));
2479: fnd_message.set_token('PGM_ID', TO_CHAR(l_currepe_row.pgm_id));
2480: fnd_message.set_token('PL_ID', TO_CHAR(l_currepe_row.pl_id));
2481: fnd_message.set_token('OIPL_ID', TO_CHAR(l_currepe_row.oipl_id));
2482: fnd_message.set_token('PLIP_ID', TO_CHAR(l_currepe_row.plip_id));
2483: fnd_message.set_token('PTIP_ID', TO_CHAR(l_currepe_row.ptip_id));
2484: fnd_message.set_token('OIPLIP_ID', TO_CHAR(l_currepe_row.oiplip_id));
2477: 'ELIG_PER_ELCTBL_CHC_ID',
2478: TO_CHAR(l_currepe_row.elig_per_elctbl_chc_id));
2479: fnd_message.set_token('PGM_ID', TO_CHAR(l_currepe_row.pgm_id));
2480: fnd_message.set_token('PL_ID', TO_CHAR(l_currepe_row.pl_id));
2481: fnd_message.set_token('OIPL_ID', TO_CHAR(l_currepe_row.oipl_id));
2482: fnd_message.set_token('PLIP_ID', TO_CHAR(l_currepe_row.plip_id));
2483: fnd_message.set_token('PTIP_ID', TO_CHAR(l_currepe_row.ptip_id));
2484: fnd_message.set_token('OIPLIP_ID', TO_CHAR(l_currepe_row.oiplip_id));
2485: fnd_message.set_token('CMBN_PLIP_ID', TO_CHAR(l_currepe_row.cmbn_plip_id));
2478: TO_CHAR(l_currepe_row.elig_per_elctbl_chc_id));
2479: fnd_message.set_token('PGM_ID', TO_CHAR(l_currepe_row.pgm_id));
2480: fnd_message.set_token('PL_ID', TO_CHAR(l_currepe_row.pl_id));
2481: fnd_message.set_token('OIPL_ID', TO_CHAR(l_currepe_row.oipl_id));
2482: fnd_message.set_token('PLIP_ID', TO_CHAR(l_currepe_row.plip_id));
2483: fnd_message.set_token('PTIP_ID', TO_CHAR(l_currepe_row.ptip_id));
2484: fnd_message.set_token('OIPLIP_ID', TO_CHAR(l_currepe_row.oiplip_id));
2485: fnd_message.set_token('CMBN_PLIP_ID', TO_CHAR(l_currepe_row.cmbn_plip_id));
2486: fnd_message.set_token('CMBN_PTIP_ID', TO_CHAR(l_currepe_row.cmbn_ptip_id));
2479: fnd_message.set_token('PGM_ID', TO_CHAR(l_currepe_row.pgm_id));
2480: fnd_message.set_token('PL_ID', TO_CHAR(l_currepe_row.pl_id));
2481: fnd_message.set_token('OIPL_ID', TO_CHAR(l_currepe_row.oipl_id));
2482: fnd_message.set_token('PLIP_ID', TO_CHAR(l_currepe_row.plip_id));
2483: fnd_message.set_token('PTIP_ID', TO_CHAR(l_currepe_row.ptip_id));
2484: fnd_message.set_token('OIPLIP_ID', TO_CHAR(l_currepe_row.oiplip_id));
2485: fnd_message.set_token('CMBN_PLIP_ID', TO_CHAR(l_currepe_row.cmbn_plip_id));
2486: fnd_message.set_token('CMBN_PTIP_ID', TO_CHAR(l_currepe_row.cmbn_ptip_id));
2487: fnd_message.set_token(
2480: fnd_message.set_token('PL_ID', TO_CHAR(l_currepe_row.pl_id));
2481: fnd_message.set_token('OIPL_ID', TO_CHAR(l_currepe_row.oipl_id));
2482: fnd_message.set_token('PLIP_ID', TO_CHAR(l_currepe_row.plip_id));
2483: fnd_message.set_token('PTIP_ID', TO_CHAR(l_currepe_row.ptip_id));
2484: fnd_message.set_token('OIPLIP_ID', TO_CHAR(l_currepe_row.oiplip_id));
2485: fnd_message.set_token('CMBN_PLIP_ID', TO_CHAR(l_currepe_row.cmbn_plip_id));
2486: fnd_message.set_token('CMBN_PTIP_ID', TO_CHAR(l_currepe_row.cmbn_ptip_id));
2487: fnd_message.set_token(
2488: 'CMBN_PTIP_OPT_ID',
2481: fnd_message.set_token('OIPL_ID', TO_CHAR(l_currepe_row.oipl_id));
2482: fnd_message.set_token('PLIP_ID', TO_CHAR(l_currepe_row.plip_id));
2483: fnd_message.set_token('PTIP_ID', TO_CHAR(l_currepe_row.ptip_id));
2484: fnd_message.set_token('OIPLIP_ID', TO_CHAR(l_currepe_row.oiplip_id));
2485: fnd_message.set_token('CMBN_PLIP_ID', TO_CHAR(l_currepe_row.cmbn_plip_id));
2486: fnd_message.set_token('CMBN_PTIP_ID', TO_CHAR(l_currepe_row.cmbn_ptip_id));
2487: fnd_message.set_token(
2488: 'CMBN_PTIP_OPT_ID',
2489: TO_CHAR(l_currepe_row.cmbn_ptip_opt_id));
2482: fnd_message.set_token('PLIP_ID', TO_CHAR(l_currepe_row.plip_id));
2483: fnd_message.set_token('PTIP_ID', TO_CHAR(l_currepe_row.ptip_id));
2484: fnd_message.set_token('OIPLIP_ID', TO_CHAR(l_currepe_row.oiplip_id));
2485: fnd_message.set_token('CMBN_PLIP_ID', TO_CHAR(l_currepe_row.cmbn_plip_id));
2486: fnd_message.set_token('CMBN_PTIP_ID', TO_CHAR(l_currepe_row.cmbn_ptip_id));
2487: fnd_message.set_token(
2488: 'CMBN_PTIP_OPT_ID',
2489: TO_CHAR(l_currepe_row.cmbn_ptip_opt_id));
2490: fnd_message.raise_error;
2483: fnd_message.set_token('PTIP_ID', TO_CHAR(l_currepe_row.ptip_id));
2484: fnd_message.set_token('OIPLIP_ID', TO_CHAR(l_currepe_row.oiplip_id));
2485: fnd_message.set_token('CMBN_PLIP_ID', TO_CHAR(l_currepe_row.cmbn_plip_id));
2486: fnd_message.set_token('CMBN_PTIP_ID', TO_CHAR(l_currepe_row.cmbn_ptip_id));
2487: fnd_message.set_token(
2488: 'CMBN_PTIP_OPT_ID',
2489: TO_CHAR(l_currepe_row.cmbn_ptip_opt_id));
2490: fnd_message.raise_error;
2491: END IF;
2486: fnd_message.set_token('CMBN_PTIP_ID', TO_CHAR(l_currepe_row.cmbn_ptip_id));
2487: fnd_message.set_token(
2488: 'CMBN_PTIP_OPT_ID',
2489: TO_CHAR(l_currepe_row.cmbn_ptip_opt_id));
2490: fnd_message.raise_error;
2491: END IF;
2492: if g_debug then
2493: hr_utility.set_location('Call ben_rates ' || l_package, 10);
2494: end if;