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_DETERMINE_ELIGIBILITY dependencies on BEN_MANAGE_LIFE_EVENTS

Line 13: (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec

9: -- It also determines all profiles or rules associated
10: -- with the comp object that is being passed through.
11: --
12: procedure determine_elig_prfls
13: (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
14: ,p_par_elig_state in out NOCOPY ben_comp_obj_filter.g_par_elig_state_rec
15: ,p_per_row in out NOCOPY per_all_people_f%rowtype
16: ,p_empasg_row in out NOCOPY per_all_assignments_f%rowtype
17: ,p_benasg_row in out NOCOPY per_all_assignments_f%rowtype

Line 227: if ben_manage_life_events.fonm = 'Y'

223:
224: l_all_inelig := 'N';
225: g_inelg_rsn_cd := NULL;
226: --
227: if ben_manage_life_events.fonm = 'Y'
228: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
229: --
230: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
231: --

Line 228: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

224: l_all_inelig := 'N';
225: g_inelg_rsn_cd := NULL;
226: --
227: if ben_manage_life_events.fonm = 'Y'
228: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
229: --
230: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
231: --
232: end if;

Line 230: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

226: --
227: if ben_manage_life_events.fonm = 'Y'
228: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
229: --
230: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
231: --
232: end if;
233: --
234: l_per_rec := p_per_row;

Line 336: ben_manage_life_events.g_output_string :=

332: -- plan in program
333: --
334: -- The pl, ptip and plip eligibilty sets the elig_for_pl_flag
335: --
336: ben_manage_life_events.g_output_string :=
337: ben_manage_life_events.g_output_string||
338: 'Elg: No '||
339: 'Rsn: Inelig Parent Pgm';
340: --

Line 337: ben_manage_life_events.g_output_string||

333: --
334: -- The pl, ptip and plip eligibilty sets the elig_for_pl_flag
335: --
336: ben_manage_life_events.g_output_string :=
337: ben_manage_life_events.g_output_string||
338: 'Elg: No '||
339: 'Rsn: Inelig Parent Pgm';
340: --
341: fnd_message.set_name('BEN','BEN_92219_INELIG_PGM');

Line 354: ben_manage_life_events.g_output_string :=

350: -- plan in program
351: --
352: -- The pl, ptip and plip eligibilty sets the elig_for_pl_flag
353: --
354: ben_manage_life_events.g_output_string :=
355: ben_manage_life_events.g_output_string||
356: 'Elg: No '||
357: 'Rsn: Inelig Parent Pgm';
358: --

Line 355: ben_manage_life_events.g_output_string||

351: --
352: -- The pl, ptip and plip eligibilty sets the elig_for_pl_flag
353: --
354: ben_manage_life_events.g_output_string :=
355: ben_manage_life_events.g_output_string||
356: 'Elg: No '||
357: 'Rsn: Inelig Parent Pgm';
358: --
359: fnd_message.set_name('BEN','BEN_92219_INELIG_PGM');

Line 372: ben_manage_life_events.g_output_string :=

368: -- plan in program
369: --
370: -- The pl, ptip and plip eligibilty sets the elig_for_pl_flag
371: --
372: ben_manage_life_events.g_output_string :=
373: ben_manage_life_events.g_output_string||
374: 'Elg: No '||
375: 'Rsn: Inelig Parent Pgm';
376: --

Line 373: ben_manage_life_events.g_output_string||

369: --
370: -- The pl, ptip and plip eligibilty sets the elig_for_pl_flag
371: --
372: ben_manage_life_events.g_output_string :=
373: ben_manage_life_events.g_output_string||
374: 'Elg: No '||
375: 'Rsn: Inelig Parent Pgm';
376: --
377: fnd_message.set_name('BEN','BEN_92219_INELIG_PGM');

Line 388: ben_manage_life_events.g_output_string :=

384: -- Person is not eligible for the plan
385: -- therefore person not eligible for the
386: -- option in plan
387: --
388: ben_manage_life_events.g_output_string :=
389: ben_manage_life_events.g_output_string||
390: 'Elg: No '||
391: 'Rsn: Inelig Pln';
392: --

Line 389: ben_manage_life_events.g_output_string||

385: -- therefore person not eligible for the
386: -- option in plan
387: --
388: ben_manage_life_events.g_output_string :=
389: ben_manage_life_events.g_output_string||
390: 'Elg: No '||
391: 'Rsn: Inelig Pln';
392: --
393: fnd_message.set_name('BEN','BEN_92221_INELIG_PLN');

Line 433: ben_manage_life_events.g_output_string :=

429: -- e.g. eligible stays eligible, ineligible stays ineligible.
430: --
431: if p_comp_rec.elig_flag = 'Y' then
432: --
433: ben_manage_life_events.g_output_string :=
434: ben_manage_life_events.g_output_string ||
435: 'Elg: Yes '||
436: 'Rsn: Prtn Ovrid';
437: raise g_eligible;

Line 434: ben_manage_life_events.g_output_string ||

430: --
431: if p_comp_rec.elig_flag = 'Y' then
432: --
433: ben_manage_life_events.g_output_string :=
434: ben_manage_life_events.g_output_string ||
435: 'Elg: Yes '||
436: 'Rsn: Prtn Ovrid';
437: raise g_eligible;
438: --

Line 441: ben_manage_life_events.g_output_string :=

437: raise g_eligible;
438: --
439: elsif p_comp_rec.elig_flag = 'N' then
440: --
441: ben_manage_life_events.g_output_string :=
442: ben_manage_life_events.g_output_string ||
443: 'Elg: No '||
444: 'Rsn: Prtn Ovrid';
445: --

Line 442: ben_manage_life_events.g_output_string ||

438: --
439: elsif p_comp_rec.elig_flag = 'N' then
440: --
441: ben_manage_life_events.g_output_string :=
442: ben_manage_life_events.g_output_string ||
443: 'Elg: No '||
444: 'Rsn: Prtn Ovrid';
445: --
446: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');

Line 479: ben_manage_life_events.g_output_string :=

475: -- e.g. eligible stays eligible, ineligible stays ineligible.
476: --
477: if p_comp_rec.elig_flag = 'Y' then
478: --
479: ben_manage_life_events.g_output_string :=
480: ben_manage_life_events.g_output_string||
481: 'Elg: Yes '||
482: 'Rsn: Prtn Ovrid';
483: --

Line 480: ben_manage_life_events.g_output_string||

476: --
477: if p_comp_rec.elig_flag = 'Y' then
478: --
479: ben_manage_life_events.g_output_string :=
480: ben_manage_life_events.g_output_string||
481: 'Elg: Yes '||
482: 'Rsn: Prtn Ovrid';
483: --
484: raise g_eligible;

Line 488: ben_manage_life_events.g_output_string :=

484: raise g_eligible;
485: --
486: elsif p_comp_rec.elig_flag = 'N' then
487: --
488: ben_manage_life_events.g_output_string :=
489: ben_manage_life_events.g_output_string||
490: 'Elg: No '||
491: 'Rsn: Prtn Ovrid';
492: --

Line 489: ben_manage_life_events.g_output_string||

485: --
486: elsif p_comp_rec.elig_flag = 'N' then
487: --
488: ben_manage_life_events.g_output_string :=
489: ben_manage_life_events.g_output_string||
490: 'Elg: No '||
491: 'Rsn: Prtn Ovrid';
492: --
493: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');

Line 531: ben_manage_life_events.g_output_string :=

527: raise g_eligible;
528: --
529: elsif p_comp_rec.elig_flag = 'N' then
530: --
531: ben_manage_life_events.g_output_string :=
532: ben_manage_life_events.g_output_string||
533: 'Elg: No '||
534: 'Rsn: Prtn Ovrid';
535: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');

Line 532: ben_manage_life_events.g_output_string||

528: --
529: elsif p_comp_rec.elig_flag = 'N' then
530: --
531: ben_manage_life_events.g_output_string :=
532: ben_manage_life_events.g_output_string||
533: 'Elg: No '||
534: 'Rsn: Prtn Ovrid';
535: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');
536: raise g_not_eligible;

Line 572: ben_manage_life_events.g_output_string :=

568: raise g_eligible;
569: --
570: elsif p_comp_rec.elig_flag = 'N' then
571: --
572: ben_manage_life_events.g_output_string :=
573: ben_manage_life_events.g_output_string||
574: 'Elg: No '||
575: 'Rsn: Prtn Ovrid';
576: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');

Line 573: ben_manage_life_events.g_output_string||

569: --
570: elsif p_comp_rec.elig_flag = 'N' then
571: --
572: ben_manage_life_events.g_output_string :=
573: ben_manage_life_events.g_output_string||
574: 'Elg: No '||
575: 'Rsn: Prtn Ovrid';
576: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');
577: raise g_not_eligible;

Line 609: ben_manage_life_events.g_output_string :=

605: -- e.g. eligible stays eligible, ineligible stays ineligible.
606: --
607: if p_comp_rec.elig_flag = 'Y' then
608: --
609: ben_manage_life_events.g_output_string :=
610: ben_manage_life_events.g_output_string||
611: 'Elg: Yes '||
612: 'Rsn: Prtn Ovrid';
613: raise g_eligible;

Line 610: ben_manage_life_events.g_output_string||

606: --
607: if p_comp_rec.elig_flag = 'Y' then
608: --
609: ben_manage_life_events.g_output_string :=
610: ben_manage_life_events.g_output_string||
611: 'Elg: Yes '||
612: 'Rsn: Prtn Ovrid';
613: raise g_eligible;
614: --

Line 617: ben_manage_life_events.g_output_string :=

613: raise g_eligible;
614: --
615: elsif p_comp_rec.elig_flag = 'N' then
616: --
617: ben_manage_life_events.g_output_string :=
618: ben_manage_life_events.g_output_string||
619: 'Elg: No '||
620: 'Rsn: Prtn Ovrid';
621: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');

Line 618: ben_manage_life_events.g_output_string||

614: --
615: elsif p_comp_rec.elig_flag = 'N' then
616: --
617: ben_manage_life_events.g_output_string :=
618: ben_manage_life_events.g_output_string||
619: 'Elg: No '||
620: 'Rsn: Prtn Ovrid';
621: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');
622: raise g_not_eligible;

Line 893: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

889: p_ler_id => p_ler_id,
890: p_param1 => 'PERSON_ID',
891: p_param1_value => to_char(p_person_id),
892: p_param2 => 'BEN_IV_RT_STRT_DT',
893: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
894: p_param3 => 'BEN_IV_CVG_STRT_DT',
895: p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
896: p_jurisdiction_code => l_jurisdiction_code);
897: --

Line 895: p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),

891: p_param1_value => to_char(p_person_id),
892: p_param2 => 'BEN_IV_RT_STRT_DT',
893: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
894: p_param3 => 'BEN_IV_CVG_STRT_DT',
895: p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
896: p_jurisdiction_code => l_jurisdiction_code);
897: --
898: if l_outputs(l_outputs.first).value = 'N' then
899: g_inelg_rsn_cd := 'FMM';

Line 1163: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

1159: p_pl_typ_id => NVL(l_pl_rec.pl_typ_id, NVL(l_ctp_rec.pl_typ_id, l_pln_rec.pl_typ_id)),
1160: p_opt_id => l_oipl_rec.opt_id,
1161: p_ler_id => p_ler_id,
1162: p_param1 => 'BEN_IV_RT_STRT_DT',
1163: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1164: p_param2 => 'BEN_IV_CVG_STRT_DT',
1165: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
1166: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
1167: p_param3_value => to_char(p_person_id),

Line 1165: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),

1161: p_ler_id => p_ler_id,
1162: p_param1 => 'BEN_IV_RT_STRT_DT',
1163: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1164: p_param2 => 'BEN_IV_CVG_STRT_DT',
1165: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
1166: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
1167: p_param3_value => to_char(p_person_id),
1168: p_jurisdiction_code => l_jurisdiction_code);
1169: --

Line 1185: ben_manage_life_events.g_output_string :=

1181: end if;
1182: --
1183: elsif l_outputs(l_outputs.first).value = 'N' then
1184: --
1185: ben_manage_life_events.g_output_string :=
1186: ben_manage_life_events.g_output_string||
1187: 'Elg: No '||
1188: 'Rsn: Rule No Pass';
1189: --

Line 1186: ben_manage_life_events.g_output_string||

1182: --
1183: elsif l_outputs(l_outputs.first).value = 'N' then
1184: --
1185: ben_manage_life_events.g_output_string :=
1186: ben_manage_life_events.g_output_string||
1187: 'Elg: No '||
1188: 'Rsn: Rule No Pass';
1189: --
1190: l_ok_so_far := 'N';

Line 1205: raise ben_manage_life_events.g_record_error;

1201: --
1202: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1203: fnd_message.set_token('RL','formula_id :'||l_inst_set(i).formula_id);
1204: fnd_message.set_token('PROC',l_proc);
1205: raise ben_manage_life_events.g_record_error;
1206: --
1207: end if;
1208: --
1209: end loop; -- elig rules

Line 1268: benutils.write(p_text => ben_manage_life_events.g_output_string);

1264: hr_utility.set_location(l_proc||' BU_WRITE g_eligible ',812);
1265: end if;
1266: --
1267: benutils.write(p_rec => g_rec);
1268: benutils.write(p_text => ben_manage_life_events.g_output_string);
1269: ben_manage_life_events.g_output_string := null;
1270: --
1271: if g_debug then
1272: hr_utility.set_location(l_proc||' BDE_CPE g_eligible ',814);

Line 1269: ben_manage_life_events.g_output_string := null;

1265: end if;
1266: --
1267: benutils.write(p_rec => g_rec);
1268: benutils.write(p_text => ben_manage_life_events.g_output_string);
1269: ben_manage_life_events.g_output_string := null;
1270: --
1271: if g_debug then
1272: hr_utility.set_location(l_proc||' BDE_CPE g_eligible ',814);
1273: hr_utility.set_location('AGE VAL in CPE'||p_comp_rec.age_val,814);

Line 1341: benutils.write(p_text => ben_manage_life_events.g_output_string);

1337: hr_utility.set_location(l_proc||' Dn BU_WRI g_not_eligible ',822);
1338: end if;
1339: --
1340: benutils.write(p_rec => g_rec);
1341: benutils.write(p_text => ben_manage_life_events.g_output_string);
1342: ben_manage_life_events.g_output_string := null;
1343: --
1344: if g_debug then
1345: hr_utility.set_location(l_proc||' Dn BDE_CPE g_not_eligible ',824);

Line 1342: ben_manage_life_events.g_output_string := null;

1338: end if;
1339: --
1340: benutils.write(p_rec => g_rec);
1341: benutils.write(p_text => ben_manage_life_events.g_output_string);
1342: ben_manage_life_events.g_output_string := null;
1343: --
1344: if g_debug then
1345: hr_utility.set_location(l_proc||' Dn BDE_CPE g_not_eligible ',824);
1346: hr_utility.set_location('g_inelg_rsn_cd ' || g_inelg_rsn_cd ,824);