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

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BENUTILS

Line 125: 20-JUL-99 Gperry 115.61 genutils -> benutils package rename.

121: level.
122: 12 Jul 99 jcarpent 115.59 Added checks for backed out nocopy pil.
123: 12 Jul 99 moyes 115.60 - Added trace messages.
124: - Removed + 0s from all cursors.
125: 20-JUL-99 Gperry 115.61 genutils -> benutils package rename.
126: 21-JUL-99 mhoyes 115.62 - Added trace messages.
127: 30-JUL-99 mhoyes 115.63 - Added trace messages.
128: 02-Aug-99 tguy 115.64 Added spouse and dependent for imputed
129: incomes.

Line 189: and passes to benutils.formula

185: of whether they are configured to be
186: electable for each life event or not.
187: 21-Jan-00 pbodla 115.92 - p_elig-per_id is added to
188: execute_enrt_rule, determine_enrolment
189: and passes to benutils.formula
190: 05-Jan-00 maagrawa 115.93 - Get the auto enrollment flag from oipl's
191: ler record, if availabe (Bug 4290).
192: - If the choice is automatic, it cannot
193: be default. (Bug 1175262).

Line 317: derived inside benutils.formula.

313: cached records. Also removed the calls to ben_cobj_cache
314: from internal determine_dflt_enrt_cd procedure as this
315: can not be used here.
316: 27-aug-01 tilak 115.144 bug:1949361 jurisdiction code is
317: derived inside benutils.formula.
318: 13-Nov-01 kmahendr 115.145 bug#2080856 - in determine_dflt_flag procedure, coverage is
319: checked at ptip level if plan level fails.
320: 15-Nov-01 kmahendr 115.146 Bug#2080856 - if dflt_enrt_cd is null then default flag
321: is set to 'N' - changed the assignment in determine_dflt_flag

Line 518: 26-Jun-06 swjain 115.239 5331889 - Added person_id param in calls to benutils.formula

514: 03-Mar-06 kmahendr 115.236 Added new enrollment codes
515: 14-Mar-06 ssarkar 115.237 5092244 - populating g_egd_table in update_defaults
516: 04-Apr-06 rbingi 115.238 5029028: Added UNIONs to select the enrolment codes
517: from respective tables if ler_chg records not defined
518: 26-Jun-06 swjain 115.239 5331889 - Added person_id param in calls to benutils.formula
519: 30-Jun-06 swjain 115.240 Commented out show errors
520: 01-sep-06 ssarkar 115.241 Bug 5491475 - reverted 5029028 fix
521: 26-Sep-06 abparekh 115.242 Bug 5555402 - While determining DFLT_ENRT_CD, consider code
522: at PL_NIP level for enrollment at PLIP level

Line 546: g_rec benutils.g_batch_elctbl_rec;

542: 20-Dec-07 sagnanas Included fix 6281735 and 6519487 for 12.1
543: */
544: ---------------------------------------------------------------------------------------------------
545: g_package VARCHAR2(80) := 'ben_enrolment_requirements';
546: g_rec benutils.g_batch_elctbl_rec;
547: g_ptip_id NUMBER;
548: --
549: --
550: -- internal version below for update_defaults

Line 4311: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

4307: p_run_mode not in ('U','R','D') THEN
4308: --
4309: fnd_message.set_name('BEN', 'BEN_91463_ELCTBL_CHC_EXISTS');
4310: fnd_message.set_token('PROC', l_proc);
4311: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
4312: if g_debug then
4313: hr_utility.set_location('Leaving: ' || l_proc, 20);
4314: end if;
4315: p_electable_flag := 'N';

Line 6465: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6461: TO_CHAR(l_pgm_rec.effective_start_date));
6462: fnd_message.set_token(
6463: 'PGM_END_DT',
6464: TO_CHAR(l_pgm_rec.effective_end_date));
6465: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6466: p_electable_flag := 'N';
6467: RETURN;
6468: end if;
6469: close c_pgm_requery;

Line 6488: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6484: 'ENRT_PERD_STRT_DT',
6485: TO_CHAR(l_rec_enrt_perd_strt_dt));
6486: fnd_message.set_token('PLIP_STRT_DT', TO_CHAR(l_plip_esd));
6487: fnd_message.set_token('PLIP_END_DT', TO_CHAR(l_plip_eed));
6488: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6489: p_electable_flag := 'N';
6490: RETURN;
6491: end if;
6492: close c_plip_requery;

Line 6522: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6518: 'ENRT_PERD_STRT_DT',
6519: TO_CHAR(l_rec_enrt_perd_strt_dt));
6520: fnd_message.set_token('PTIP_STRT_DT', TO_CHAR(l_ptip_esd));
6521: fnd_message.set_token('PTIP_END_DT', TO_CHAR(l_ptip_eed));
6522: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6523: p_electable_flag := 'N';
6524: -- Bug fix 2008871 -- hnarayan
6525: close c_ptip_requery;
6526: RETURN;

Line 6571: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6567: TO_CHAR(l_oipl_rec.effective_start_date));
6568: fnd_message.set_token(
6569: 'OIPL_END_DT',
6570: TO_CHAR(l_oipl_rec.effective_end_date));
6571: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6572: p_electable_flag := 'N';
6573: RETURN;
6574: end if;
6575: close c_oipl_requery;

Line 6602: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6598: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_start_date));
6599: fnd_message.set_token(
6600: 'OPT_END_DT',
6601: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_end_date));
6602: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6603: p_electable_flag := 'N';
6604: RETURN;
6605: end if;
6606: close c_opt_requery;

Line 6635: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6631: TO_CHAR(l_plan_rec.effective_start_date));
6632: fnd_message.set_token(
6633: 'PL_END_DT',
6634: TO_CHAR(l_plan_rec.effective_end_date));
6635: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6636: p_electable_flag := 'N';
6637: RETURN;
6638: end if;
6639: close c_plan_requery;

Line 6664: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6660: 'ENRT_PERD_STRT_DT',
6661: TO_CHAR(l_rec_enrt_perd_strt_dt));
6662: fnd_message.set_token('PL_TYP_STRT_DT', TO_CHAR(l_pl_typ_esd));
6663: fnd_message.set_token('PL_TYP_END_DT', TO_CHAR(l_pl_typ_eed));
6664: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6665: p_electable_flag := 'N';
6666: RETURN;
6667: end if;
6668: close c_pl_typ_requery;

Line 6691: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6687: 'ENRT_PERD_STRT_DT',
6688: TO_CHAR(l_rec_enrt_perd_strt_dt));
6689: fnd_message.set_token('LEE_RSN_STRT_DT', TO_CHAR(l_rec_lee_rsn_esd));
6690: fnd_message.set_token('LEE_RSN_END_DT', TO_CHAR(l_rec_lee_rsn_eed));
6691: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6692: p_electable_flag := 'N';
6693: RETURN;
6694: end if;
6695: close c_lee_rsn_requery;

Line 6714: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6710: 'ENRT_PERD_STRT_DT',
6711: TO_CHAR(l_rec_enrt_perd_strt_dt));
6712: fnd_message.set_token('LER_STRT_DT', TO_CHAR(l_ler_esd));
6713: fnd_message.set_token('LER_END_DT', TO_CHAR(l_ler_eed));
6714: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6715: p_electable_flag := 'N';
6716: RETURN;
6717: end if;
6718: close c_ler_requery;

Line 7045: benutils.write(p_rec => g_rec);

7041: g_rec.dflt_flag := l_dflt_flag;
7042: g_rec.business_group_id := p_business_group_id;
7043: g_rec.effective_date := p_effective_date;
7044: --
7045: benutils.write(p_rec => g_rec);
7046: if g_debug then
7047: hr_utility.set_location('FND mess: ' || l_proc, 10);
7048: end if;
7049: --

Line 7060: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

7056: --
7057: if g_debug then
7058: hr_utility.set_location('Dn FND mess: ' || l_proc, 10);
7059: end if;
7060: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
7061: --
7062: -- if choice is created for an oipl create one for plan it belongs to
7063: -- first find out if it already exists.
7064: --

Line 7274: benutils.write(p_rec => g_rec);

7270: g_rec.dflt_flag := 'N';
7271: g_rec.business_group_id := p_business_group_id;
7272: g_rec.effective_date := p_effective_date;
7273: --
7274: benutils.write(p_rec => g_rec);
7275: --
7276: if g_debug then
7277: hr_utility.set_location('FND Mess: ' || l_proc, 10);
7278: end if;

Line 7288: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

7284: fnd_message.set_token('OIPL_NAME', ' ');
7285: if g_debug then
7286: hr_utility.set_location('Dn FND Mess: ' || l_proc, 10);
7287: end if;
7288: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
7289: if g_debug then
7290: hr_utility.set_location('Dn FND GetMess: ' || l_proc, 10);
7291: end if;
7292: --

Line 7542: benutils.formula(

7538: if g_debug then
7539: hr_utility.set_location(' Fire Rule ' || l_package, 10);
7540: end if;
7541: l_outputs :=
7542: benutils.formula(
7543: p_opt_id => p_opt_id,
7544: p_pl_id => p_pl_id,
7545: p_pgm_id => p_pgm_id,
7546: p_formula_id => p_rule_id,

Line 7859: benutils.formula(

7855: --
7856: END IF;
7857: --
7858: l_outputs :=
7859: benutils.formula(
7860: p_opt_id => p_opt_id,
7861: p_pl_id => p_pl_id,
7862: p_pgm_id => p_pgm_id,
7863: p_formula_id => p_rule_id,

Line 8378: benutils.formula(

8374: hr_utility.set_location('opt_id ' || TO_CHAR(p_opt_id), 60);
8375: hr_utility.set_location('ler_id ' || TO_CHAR(p_ler_id), 70);
8376: end if;
8377: l_outputs :=
8378: benutils.formula(
8379: p_formula_id => p_rqd_perd_enrt_nenrt_rl,
8380: p_effective_date => NVL(p_lf_evt_ocrd_dt, p_effective_date),
8381: p_business_group_id => p_business_group_id,
8382: p_assignment_id => p_assignment_id,

Line 8548: benutils.formula(

8544: hr_utility.set_location('opt_id ' || TO_CHAR(p_opt_id), 60);
8545: hr_utility.set_location('ler_id ' || TO_CHAR(p_ler_id), 70);
8546: end if;
8547: l_outputs :=
8548: benutils.formula(
8549: p_formula_id => l_dpnt_cvg_rl,
8550: p_effective_date => NVL(p_lf_evt_ocrd_dt, p_effective_date),
8551: p_business_group_id => p_business_group_id,
8552: p_assignment_id => p_assignment_id,

Line 9534: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();

9530: ,p_per_in_ler_id in number
9531: )
9532: IS
9533: --
9534: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();
9535: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9536: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9537: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9538: l_plip_id_va benutils.g_number_table := benutils.g_number_table();

Line 9535: l_pl_id_va benutils.g_number_table := benutils.g_number_table();

9531: )
9532: IS
9533: --
9534: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();
9535: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9536: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9537: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9538: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9539: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();

Line 9536: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();

9532: IS
9533: --
9534: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();
9535: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9536: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9537: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9538: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9539: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9540: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();

Line 9537: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();

9533: --
9534: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();
9535: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9536: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9537: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9538: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9539: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9540: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9541: l_epe_id_va benutils.g_number_table := benutils.g_number_table();

Line 9538: l_plip_id_va benutils.g_number_table := benutils.g_number_table();

9534: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();
9535: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9536: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9537: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9538: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9539: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9540: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9541: l_epe_id_va benutils.g_number_table := benutils.g_number_table();
9542: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();

Line 9539: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();

9535: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9536: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9537: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9538: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9539: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9540: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9541: l_epe_id_va benutils.g_number_table := benutils.g_number_table();
9542: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();
9543: --

Line 9540: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();

9536: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9537: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9538: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9539: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9540: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9541: l_epe_id_va benutils.g_number_table := benutils.g_number_table();
9542: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();
9543: --
9544: l_prevepo_rec ben_derive_part_and_rate_facts.g_cache_structure;

Line 9541: l_epe_id_va benutils.g_number_table := benutils.g_number_table();

9537: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9538: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9539: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9540: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9541: l_epe_id_va benutils.g_number_table := benutils.g_number_table();
9542: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();
9543: --
9544: l_prevepo_rec ben_derive_part_and_rate_facts.g_cache_structure;
9545: l_prevpep_rec ben_derive_part_and_rate_facts.g_cache_structure;

Line 9542: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();

9538: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9539: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9540: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9541: l_epe_id_va benutils.g_number_table := benutils.g_number_table();
9542: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();
9543: --
9544: l_prevepo_rec ben_derive_part_and_rate_facts.g_cache_structure;
9545: l_prevpep_rec ben_derive_part_and_rate_facts.g_cache_structure;
9546: --