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 223: if ben_manage_life_events.fonm = 'Y'

219: if g_debug then
220: hr_utility.set_location('Entering :'||l_proc,10);
221: end if;
222: --
223: if ben_manage_life_events.fonm = 'Y'
224: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
225: --
226: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
227: --

Line 224: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

220: hr_utility.set_location('Entering :'||l_proc,10);
221: end if;
222: --
223: if ben_manage_life_events.fonm = 'Y'
224: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
225: --
226: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
227: --
228: end if;

Line 226: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

222: --
223: if ben_manage_life_events.fonm = 'Y'
224: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
225: --
226: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
227: --
228: end if;
229: --
230: l_per_rec := p_per_row;

Line 332: ben_manage_life_events.g_output_string :=

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

Line 333: ben_manage_life_events.g_output_string||

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

Line 350: ben_manage_life_events.g_output_string :=

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

Line 351: ben_manage_life_events.g_output_string||

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

Line 368: ben_manage_life_events.g_output_string :=

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

Line 369: ben_manage_life_events.g_output_string||

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

Line 384: ben_manage_life_events.g_output_string :=

380: -- Person is not eligible for the plan
381: -- therefore person not eligible for the
382: -- option in plan
383: --
384: ben_manage_life_events.g_output_string :=
385: ben_manage_life_events.g_output_string||
386: 'Elg: No '||
387: 'Rsn: Inelig Pln';
388: --

Line 385: ben_manage_life_events.g_output_string||

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

Line 427: ben_manage_life_events.g_output_string :=

423: -- e.g. eligible stays eligible, ineligible stays ineligible.
424: --
425: if p_comp_rec.elig_flag = 'Y' then
426: --
427: ben_manage_life_events.g_output_string :=
428: ben_manage_life_events.g_output_string ||
429: 'Elg: Yes '||
430: 'Rsn: Prtn Ovrid';
431: raise g_eligible;

Line 428: ben_manage_life_events.g_output_string ||

424: --
425: if p_comp_rec.elig_flag = 'Y' then
426: --
427: ben_manage_life_events.g_output_string :=
428: ben_manage_life_events.g_output_string ||
429: 'Elg: Yes '||
430: 'Rsn: Prtn Ovrid';
431: raise g_eligible;
432: --

Line 435: ben_manage_life_events.g_output_string :=

431: raise g_eligible;
432: --
433: elsif p_comp_rec.elig_flag = 'N' then
434: --
435: ben_manage_life_events.g_output_string :=
436: ben_manage_life_events.g_output_string ||
437: 'Elg: No '||
438: 'Rsn: Prtn Ovrid';
439: --

Line 436: ben_manage_life_events.g_output_string ||

432: --
433: elsif p_comp_rec.elig_flag = 'N' then
434: --
435: ben_manage_life_events.g_output_string :=
436: ben_manage_life_events.g_output_string ||
437: 'Elg: No '||
438: 'Rsn: Prtn Ovrid';
439: --
440: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');

Line 471: ben_manage_life_events.g_output_string :=

467: -- e.g. eligible stays eligible, ineligible stays ineligible.
468: --
469: if p_comp_rec.elig_flag = 'Y' then
470: --
471: ben_manage_life_events.g_output_string :=
472: ben_manage_life_events.g_output_string||
473: 'Elg: Yes '||
474: 'Rsn: Prtn Ovrid';
475: --

Line 472: ben_manage_life_events.g_output_string||

468: --
469: if p_comp_rec.elig_flag = 'Y' then
470: --
471: ben_manage_life_events.g_output_string :=
472: ben_manage_life_events.g_output_string||
473: 'Elg: Yes '||
474: 'Rsn: Prtn Ovrid';
475: --
476: raise g_eligible;

Line 480: ben_manage_life_events.g_output_string :=

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

Line 481: ben_manage_life_events.g_output_string||

477: --
478: elsif p_comp_rec.elig_flag = 'N' then
479: --
480: ben_manage_life_events.g_output_string :=
481: ben_manage_life_events.g_output_string||
482: 'Elg: No '||
483: 'Rsn: Prtn Ovrid';
484: --
485: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');

Line 520: ben_manage_life_events.g_output_string :=

516: raise g_eligible;
517: --
518: elsif p_comp_rec.elig_flag = 'N' then
519: --
520: ben_manage_life_events.g_output_string :=
521: ben_manage_life_events.g_output_string||
522: 'Elg: No '||
523: 'Rsn: Prtn Ovrid';
524: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');

Line 521: ben_manage_life_events.g_output_string||

517: --
518: elsif p_comp_rec.elig_flag = 'N' then
519: --
520: ben_manage_life_events.g_output_string :=
521: ben_manage_life_events.g_output_string||
522: 'Elg: No '||
523: 'Rsn: Prtn Ovrid';
524: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');
525: raise g_not_eligible;

Line 559: ben_manage_life_events.g_output_string :=

555: raise g_eligible;
556: --
557: elsif p_comp_rec.elig_flag = 'N' then
558: --
559: ben_manage_life_events.g_output_string :=
560: ben_manage_life_events.g_output_string||
561: 'Elg: No '||
562: 'Rsn: Prtn Ovrid';
563: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');

Line 560: ben_manage_life_events.g_output_string||

556: --
557: elsif p_comp_rec.elig_flag = 'N' then
558: --
559: ben_manage_life_events.g_output_string :=
560: ben_manage_life_events.g_output_string||
561: 'Elg: No '||
562: 'Rsn: Prtn Ovrid';
563: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');
564: raise g_not_eligible;

Line 594: ben_manage_life_events.g_output_string :=

590: -- e.g. eligible stays eligible, ineligible stays ineligible.
591: --
592: if p_comp_rec.elig_flag = 'Y' then
593: --
594: ben_manage_life_events.g_output_string :=
595: ben_manage_life_events.g_output_string||
596: 'Elg: Yes '||
597: 'Rsn: Prtn Ovrid';
598: raise g_eligible;

Line 595: ben_manage_life_events.g_output_string||

591: --
592: if p_comp_rec.elig_flag = 'Y' then
593: --
594: ben_manage_life_events.g_output_string :=
595: ben_manage_life_events.g_output_string||
596: 'Elg: Yes '||
597: 'Rsn: Prtn Ovrid';
598: raise g_eligible;
599: --

Line 602: ben_manage_life_events.g_output_string :=

598: raise g_eligible;
599: --
600: elsif p_comp_rec.elig_flag = 'N' then
601: --
602: ben_manage_life_events.g_output_string :=
603: ben_manage_life_events.g_output_string||
604: 'Elg: No '||
605: 'Rsn: Prtn Ovrid';
606: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');

Line 603: ben_manage_life_events.g_output_string||

599: --
600: elsif p_comp_rec.elig_flag = 'N' then
601: --
602: ben_manage_life_events.g_output_string :=
603: ben_manage_life_events.g_output_string||
604: 'Elg: No '||
605: 'Rsn: Prtn Ovrid';
606: fnd_message.set_name('BEN','BEN_92223_PRTN_OVERRIDE');
607: raise g_not_eligible;

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

864: p_ler_id => p_ler_id,
865: p_param1 => 'PERSON_ID',
866: p_param1_value => to_char(p_person_id),
867: p_param2 => 'BEN_IV_RT_STRT_DT',
868: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
869: p_param3 => 'BEN_IV_CVG_STRT_DT',
870: p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
871: p_jurisdiction_code => l_jurisdiction_code);
872: --

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

866: p_param1_value => to_char(p_person_id),
867: p_param2 => 'BEN_IV_RT_STRT_DT',
868: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
869: p_param3 => 'BEN_IV_CVG_STRT_DT',
870: p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
871: p_jurisdiction_code => l_jurisdiction_code);
872: --
873: if l_outputs(l_outputs.first).value = 'N' then
874: g_inelg_rsn_cd := 'FMM';

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

1134: p_pl_typ_id => NVL(l_pl_rec.pl_typ_id, NVL(l_ctp_rec.pl_typ_id, l_pln_rec.pl_typ_id)),
1135: p_opt_id => l_oipl_rec.opt_id,
1136: p_ler_id => p_ler_id,
1137: p_param1 => 'BEN_IV_RT_STRT_DT',
1138: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1139: p_param2 => 'BEN_IV_CVG_STRT_DT',
1140: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
1141: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
1142: p_param3_value => to_char(p_person_id),

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

1136: p_ler_id => p_ler_id,
1137: p_param1 => 'BEN_IV_RT_STRT_DT',
1138: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1139: p_param2 => 'BEN_IV_CVG_STRT_DT',
1140: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
1141: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
1142: p_param3_value => to_char(p_person_id),
1143: p_jurisdiction_code => l_jurisdiction_code);
1144: --

Line 1160: ben_manage_life_events.g_output_string :=

1156: end if;
1157: --
1158: elsif l_outputs(l_outputs.first).value = 'N' then
1159: --
1160: ben_manage_life_events.g_output_string :=
1161: ben_manage_life_events.g_output_string||
1162: 'Elg: No '||
1163: 'Rsn: Rule No Pass';
1164: --

Line 1161: ben_manage_life_events.g_output_string||

1157: --
1158: elsif l_outputs(l_outputs.first).value = 'N' then
1159: --
1160: ben_manage_life_events.g_output_string :=
1161: ben_manage_life_events.g_output_string||
1162: 'Elg: No '||
1163: 'Rsn: Rule No Pass';
1164: --
1165: l_ok_so_far := 'N';

Line 1180: raise ben_manage_life_events.g_record_error;

1176: --
1177: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1178: fnd_message.set_token('RL','formula_id :'||l_inst_set(i).formula_id);
1179: fnd_message.set_token('PROC',l_proc);
1180: raise ben_manage_life_events.g_record_error;
1181: --
1182: end if;
1183: --
1184: end loop; -- elig rules

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

1239: hr_utility.set_location(l_proc||' BU_WRITE g_eligible ',812);
1240: end if;
1241: --
1242: benutils.write(p_rec => g_rec);
1243: benutils.write(p_text => ben_manage_life_events.g_output_string);
1244: ben_manage_life_events.g_output_string := null;
1245: --
1246: if g_debug then
1247: hr_utility.set_location(l_proc||' BDE_CPE g_eligible ',814);

Line 1244: ben_manage_life_events.g_output_string := null;

1240: end if;
1241: --
1242: benutils.write(p_rec => g_rec);
1243: benutils.write(p_text => ben_manage_life_events.g_output_string);
1244: ben_manage_life_events.g_output_string := null;
1245: --
1246: if g_debug then
1247: hr_utility.set_location(l_proc||' BDE_CPE g_eligible ',814);
1248: hr_utility.set_location('AGE VAL in CPE'||p_comp_rec.age_val,814);

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

1312: hr_utility.set_location(l_proc||' Dn BU_WRI g_not_eligible ',822);
1313: end if;
1314: --
1315: benutils.write(p_rec => g_rec);
1316: benutils.write(p_text => ben_manage_life_events.g_output_string);
1317: ben_manage_life_events.g_output_string := null;
1318: --
1319: if g_debug then
1320: hr_utility.set_location(l_proc||' Dn BDE_CPE g_not_eligible ',824);

Line 1317: ben_manage_life_events.g_output_string := null;

1313: end if;
1314: --
1315: benutils.write(p_rec => g_rec);
1316: benutils.write(p_text => ben_manage_life_events.g_output_string);
1317: ben_manage_life_events.g_output_string := null;
1318: --
1319: if g_debug then
1320: hr_utility.set_location(l_proc||' Dn BDE_CPE g_not_eligible ',824);
1321: hr_utility.set_location('g_inelg_rsn_cd ' || g_inelg_rsn_cd ,824);