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 573: g_rec benutils.g_batch_elctbl_rec;

569: Default Enrollment rule type. Parameter is passed for procedure execute_auto_dflt_enrt_rule
570: */
571: ---------------------------------------------------------------------------------------------------
572: g_package VARCHAR2(80) := 'ben_enrolment_requirements';
573: g_rec benutils.g_batch_elctbl_rec;
574: g_ptip_id NUMBER;
575: --
576: --
577: -- internal version below for update_defaults

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

4397: p_run_mode not in ('U','R','D') THEN
4398: --
4399: fnd_message.set_name('BEN', 'BEN_91463_ELCTBL_CHC_EXISTS');
4400: fnd_message.set_token('PROC', l_proc);
4401: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
4402: if g_debug then
4403: hr_utility.set_location('Leaving: ' || l_proc, 20);
4404: end if;
4405: p_electable_flag := 'N';

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

6595: TO_CHAR(l_pgm_rec.effective_start_date));
6596: fnd_message.set_token(
6597: 'PGM_END_DT',
6598: TO_CHAR(l_pgm_rec.effective_end_date));
6599: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6600: p_electable_flag := 'N';
6601: RETURN;
6602: end if;
6603: close c_pgm_requery;

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

6618: 'ENRT_PERD_STRT_DT',
6619: TO_CHAR(l_rec_enrt_perd_strt_dt));
6620: fnd_message.set_token('PLIP_STRT_DT', TO_CHAR(l_plip_esd));
6621: fnd_message.set_token('PLIP_END_DT', TO_CHAR(l_plip_eed));
6622: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6623: p_electable_flag := 'N';
6624: RETURN;
6625: end if;
6626: close c_plip_requery;

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

6652: 'ENRT_PERD_STRT_DT',
6653: TO_CHAR(l_rec_enrt_perd_strt_dt));
6654: fnd_message.set_token('PTIP_STRT_DT', TO_CHAR(l_ptip_esd));
6655: fnd_message.set_token('PTIP_END_DT', TO_CHAR(l_ptip_eed));
6656: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6657: p_electable_flag := 'N';
6658: -- Bug fix 2008871 -- hnarayan
6659: close c_ptip_requery;
6660: RETURN;

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

6701: TO_CHAR(l_oipl_rec.effective_start_date));
6702: fnd_message.set_token(
6703: 'OIPL_END_DT',
6704: TO_CHAR(l_oipl_rec.effective_end_date));
6705: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6706: p_electable_flag := 'N';
6707: RETURN;
6708: end if;
6709: close c_oipl_requery;

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

6732: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_start_date));
6733: fnd_message.set_token(
6734: 'OPT_END_DT',
6735: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_end_date));
6736: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6737: p_electable_flag := 'N';
6738: RETURN;
6739: end if;
6740: close c_opt_requery;

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

6765: TO_CHAR(l_plan_rec.effective_start_date));
6766: fnd_message.set_token(
6767: 'PL_END_DT',
6768: TO_CHAR(l_plan_rec.effective_end_date));
6769: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6770: p_electable_flag := 'N';
6771: RETURN;
6772: end if;
6773: close c_plan_requery;

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

6794: 'ENRT_PERD_STRT_DT',
6795: TO_CHAR(l_rec_enrt_perd_strt_dt));
6796: fnd_message.set_token('PL_TYP_STRT_DT', TO_CHAR(l_pl_typ_esd));
6797: fnd_message.set_token('PL_TYP_END_DT', TO_CHAR(l_pl_typ_eed));
6798: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6799: p_electable_flag := 'N';
6800: RETURN;
6801: end if;
6802: close c_pl_typ_requery;

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

6821: 'ENRT_PERD_STRT_DT',
6822: TO_CHAR(l_rec_enrt_perd_strt_dt));
6823: fnd_message.set_token('LEE_RSN_STRT_DT', TO_CHAR(l_rec_lee_rsn_esd));
6824: fnd_message.set_token('LEE_RSN_END_DT', TO_CHAR(l_rec_lee_rsn_eed));
6825: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6826: p_electable_flag := 'N';
6827: RETURN;
6828: end if;
6829: close c_lee_rsn_requery;

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

6844: 'ENRT_PERD_STRT_DT',
6845: TO_CHAR(l_rec_enrt_perd_strt_dt));
6846: fnd_message.set_token('LER_STRT_DT', TO_CHAR(l_ler_esd));
6847: fnd_message.set_token('LER_END_DT', TO_CHAR(l_ler_eed));
6848: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6849: p_electable_flag := 'N';
6850: RETURN;
6851: end if;
6852: close c_ler_requery;

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

7175: g_rec.dflt_flag := l_dflt_flag;
7176: g_rec.business_group_id := p_business_group_id;
7177: g_rec.effective_date := p_effective_date;
7178: --
7179: benutils.write(p_rec => g_rec);
7180: if g_debug then
7181: hr_utility.set_location('FND mess: ' || l_proc, 10);
7182: end if;
7183: --

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

7190: --
7191: if g_debug then
7192: hr_utility.set_location('Dn FND mess: ' || l_proc, 10);
7193: end if;
7194: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
7195: --
7196: -- if choice is created for an oipl create one for plan it belongs to
7197: -- first find out if it already exists.
7198: --

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

7406: g_rec.dflt_flag := 'N';
7407: g_rec.business_group_id := p_business_group_id;
7408: g_rec.effective_date := p_effective_date;
7409: --
7410: benutils.write(p_rec => g_rec);
7411: --
7412: if g_debug then
7413: hr_utility.set_location('FND Mess: ' || l_proc, 10);
7414: end if;

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

7420: fnd_message.set_token('OIPL_NAME', ' ');
7421: if g_debug then
7422: hr_utility.set_location('Dn FND Mess: ' || l_proc, 10);
7423: end if;
7424: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
7425: if g_debug then
7426: hr_utility.set_location('Dn FND GetMess: ' || l_proc, 10);
7427: end if;
7428: --

Line 7678: benutils.formula(

7674: if g_debug then
7675: hr_utility.set_location(' Fire Rule ' || l_package, 10);
7676: end if;
7677: l_outputs :=
7678: benutils.formula(
7679: p_opt_id => p_opt_id,
7680: p_pl_id => p_pl_id,
7681: p_pgm_id => p_pgm_id,
7682: p_formula_id => p_rule_id,

Line 7995: benutils.formula(

7991: --
7992: END IF;
7993: --
7994: l_outputs :=
7995: benutils.formula(
7996: p_opt_id => p_opt_id,
7997: p_pl_id => p_pl_id,
7998: p_pgm_id => p_pgm_id,
7999: p_formula_id => p_rule_id,

Line 8517: benutils.formula(

8513: hr_utility.set_location('opt_id ' || TO_CHAR(p_opt_id), 60);
8514: hr_utility.set_location('ler_id ' || TO_CHAR(p_ler_id), 70);
8515: end if;
8516: l_outputs :=
8517: benutils.formula(
8518: p_formula_id => p_rqd_perd_enrt_nenrt_rl,
8519: p_effective_date => NVL(p_lf_evt_ocrd_dt, p_effective_date),
8520: p_business_group_id => p_business_group_id,
8521: p_assignment_id => p_assignment_id,

Line 8687: benutils.formula(

8683: hr_utility.set_location('opt_id ' || TO_CHAR(p_opt_id), 60);
8684: hr_utility.set_location('ler_id ' || TO_CHAR(p_ler_id), 70);
8685: end if;
8686: l_outputs :=
8687: benutils.formula(
8688: p_formula_id => l_dpnt_cvg_rl,
8689: p_effective_date => NVL(p_lf_evt_ocrd_dt, p_effective_date),
8690: p_business_group_id => p_business_group_id,
8691: p_assignment_id => p_assignment_id,

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

9672: ,p_per_in_ler_id in number
9673: )
9674: IS
9675: --
9676: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();
9677: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9678: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9679: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9680: l_plip_id_va benutils.g_number_table := benutils.g_number_table();

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

9673: )
9674: IS
9675: --
9676: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();
9677: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9678: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9679: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9680: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9681: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();

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

9674: IS
9675: --
9676: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();
9677: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9678: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9679: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9680: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9681: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9682: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();

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

9675: --
9676: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();
9677: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9678: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9679: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9680: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9681: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9682: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9683: l_epe_id_va benutils.g_number_table := benutils.g_number_table();

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

9676: l_oipl_id_va benutils.g_number_table := benutils.g_number_table();
9677: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9678: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9679: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9680: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9681: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9682: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9683: l_epe_id_va benutils.g_number_table := benutils.g_number_table();
9684: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();

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

9677: l_pl_id_va benutils.g_number_table := benutils.g_number_table();
9678: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9679: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9680: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9681: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9682: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9683: l_epe_id_va benutils.g_number_table := benutils.g_number_table();
9684: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();
9685: --

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

9678: l_pgm_id_va benutils.g_number_table := benutils.g_number_table();
9679: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9680: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9681: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9682: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9683: l_epe_id_va benutils.g_number_table := benutils.g_number_table();
9684: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();
9685: --
9686: l_prevepo_rec ben_derive_part_and_rate_facts.g_cache_structure;

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

9679: l_ptip_id_va benutils.g_number_table := benutils.g_number_table();
9680: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9681: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9682: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9683: l_epe_id_va benutils.g_number_table := benutils.g_number_table();
9684: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();
9685: --
9686: l_prevepo_rec ben_derive_part_and_rate_facts.g_cache_structure;
9687: l_prevpep_rec ben_derive_part_and_rate_facts.g_cache_structure;

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

9680: l_plip_id_va benutils.g_number_table := benutils.g_number_table();
9681: l_epe_dflt_flag_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9682: l_ELCTBL_FLAG_va benutils.g_v2_30_table := benutils.g_v2_30_table();
9683: l_epe_id_va benutils.g_number_table := benutils.g_number_table();
9684: l_epe_ovn_va benutils.g_number_table := benutils.g_number_table();
9685: --
9686: l_prevepo_rec ben_derive_part_and_rate_facts.g_cache_structure;
9687: l_prevpep_rec ben_derive_part_and_rate_facts.g_cache_structure;
9688: --