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

Line 395: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec

391: -- |----------------------< get_start_end_dates >------------------------------|
392: -- -----------------------------------------------------------------------------
393: --
394: procedure get_start_end_dates
395: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
396: ,p_pil_row in ben_per_in_ler%rowtype
397: ,p_effective_date in date
398: ,p_business_group_id in number
399: ,p_person_id in number

Line 465: if ben_manage_life_events.fonm = 'Y'

461: -- hr_utility.set_location('p_plip_id -> ' ||p_plip_id,123);
462: -- hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,123);
463: -- hr_utility.set_location('p_oipl_id -> ' ||p_oipl_id,123);
464: --
465: if ben_manage_life_events.fonm = 'Y'
466: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
467: --
468: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
469: --

Line 466: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

462: -- hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,123);
463: -- hr_utility.set_location('p_oipl_id -> ' ||p_oipl_id,123);
464: --
465: if ben_manage_life_events.fonm = 'Y'
466: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
467: --
468: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
469: --
470: end if;

Line 468: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

464: --
465: if ben_manage_life_events.fonm = 'Y'
466: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
467: --
468: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
469: --
470: end if;
471: --
472: -- if the mode is Personnel Action - the participation start date and end date needs to be

Line 750: if ben_manage_life_events.fonm = 'Y' and

746: if p_start_or_end = 'S' then
747: if l_prtn_eff_strt_dt_cd <> 'RL' then
748: -- hr_utility.set_location('ben_determine_eligibility2.get_start_end_dates SOE S not RL ben_determine_eligibility2.get_start_end_dates', 10);
749: /* -- FONM START
750: if ben_manage_life_events.fonm = 'Y' and
751: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
752: --
753: p_prtn_eff_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
754: --

Line 751: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

747: if l_prtn_eff_strt_dt_cd <> 'RL' then
748: -- hr_utility.set_location('ben_determine_eligibility2.get_start_end_dates SOE S not RL ben_determine_eligibility2.get_start_end_dates', 10);
749: /* -- FONM START
750: if ben_manage_life_events.fonm = 'Y' and
751: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
752: --
753: p_prtn_eff_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
754: --
755: else

Line 753: p_prtn_eff_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

749: /* -- FONM START
750: if ben_manage_life_events.fonm = 'Y' and
751: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
752: --
753: p_prtn_eff_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
754: --
755: else
756: --
757: --FONM END

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

830: ,p_pgm_id => l_envpgm_id
831: ,p_opt_id => l_oipl_rec.opt_id
832: ,p_ler_id => p_pil_row.ler_id
833: ,p_param1 => 'BEN_IV_RT_STRT_DT'
834: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
835: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
836: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
837: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
838: ,p_param3_value => to_char(p_person_id)

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

832: ,p_ler_id => p_pil_row.ler_id
833: ,p_param1 => 'BEN_IV_RT_STRT_DT'
834: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
835: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
836: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
837: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
838: ,p_param3_value => to_char(p_person_id)
839: ,p_jurisdiction_code => l_jurisdiction_code
840: );

Line 853: raise ben_manage_life_events.g_record_error;

849: when others then
850: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
851: fnd_message.set_token('RL','prtn_eff_strt_dt_rl');
852: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
853: raise ben_manage_life_events.g_record_error;
854: end;
855: else
856: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
857: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');

Line 859: raise ben_manage_life_events.g_record_error ;

855: else
856: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
857: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
858: fnd_message.set_token('CODE1',l_prtn_eff_strt_dt_cd);
859: raise ben_manage_life_events.g_record_error ;
860: end if;
861:
862: elsif p_start_or_end = 'E' then
863: --

Line 866: if ben_manage_life_events.fonm = 'Y' and

862: elsif p_start_or_end = 'E' then
863: --
864: -- hr_utility.set_location('ben_determine_eligibility2.get_start_end_dates p_start_or_end is E ' , 10);
865: -- FONM START
866: if ben_manage_life_events.fonm = 'Y' and
867: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
868: --
869: p_prtn_eff_end_dt := ben_manage_life_events.g_fonm_cvg_strt_dt - 1 ;
870: --

Line 867: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

863: --
864: -- hr_utility.set_location('ben_determine_eligibility2.get_start_end_dates p_start_or_end is E ' , 10);
865: -- FONM START
866: if ben_manage_life_events.fonm = 'Y' and
867: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
868: --
869: p_prtn_eff_end_dt := ben_manage_life_events.g_fonm_cvg_strt_dt - 1 ;
870: --
871: --END FONM

Line 869: p_prtn_eff_end_dt := ben_manage_life_events.g_fonm_cvg_strt_dt - 1 ;

865: -- FONM START
866: if ben_manage_life_events.fonm = 'Y' and
867: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
868: --
869: p_prtn_eff_end_dt := ben_manage_life_events.g_fonm_cvg_strt_dt - 1 ;
870: --
871: --END FONM
872: elsif l_prtn_eff_end_dt_cd = 'A30DFPSD' then
873: hr_utility.set_location('ben_determine_eligibility2.get_start_end_dates SOE E A30DFPSD ben_determine_eligibility2.get_start_end_dates', 10);

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

1039: ,p_pgm_id => l_envpgm_id
1040: ,p_opt_id => l_oipl_rec.opt_id
1041: ,p_ler_id => p_pil_row.ler_id
1042: ,p_param1 => 'BEN_IV_RT_STRT_DT'
1043: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
1044: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
1045: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
1046: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
1047: ,p_param3_value => to_char(p_person_id)

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

1041: ,p_ler_id => p_pil_row.ler_id
1042: ,p_param1 => 'BEN_IV_RT_STRT_DT'
1043: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
1044: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
1045: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
1046: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
1047: ,p_param3_value => to_char(p_person_id)
1048: ,p_jurisdiction_code => l_jurisdiction_code
1049: );

Line 1062: raise ben_manage_life_events.g_record_error;

1058: when others then
1059: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1060: fnd_message.set_token('RL','prtn_eff_end_dt_rl');
1061: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1062: raise ben_manage_life_events.g_record_error;
1063: end;
1064:
1065: else
1066: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');

Line 1069: raise ben_manage_life_events.g_record_error;

1065: else
1066: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
1067: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1068: fnd_message.set_token('CODE1',l_prtn_eff_end_dt_cd);
1069: raise ben_manage_life_events.g_record_error;
1070: end if;
1071: else
1072: fnd_message.set_name('BEN','BEN_91393_STRT_END_ERROR');
1073: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');

Line 1074: raise ben_manage_life_events.g_record_error;

1070: end if;
1071: else
1072: fnd_message.set_name('BEN','BEN_91393_STRT_END_ERROR');
1073: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1074: raise ben_manage_life_events.g_record_error;
1075: end if;
1076: -- hr_utility.set_location('Leaving ben_determine_eligibility2.get_start_end_dates',10);
1077:
1078: end get_start_end_dates;

Line 1087: (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec

1083: -- |------------------------< check_prev_elig >--------------------------------|
1084: -- -----------------------------------------------------------------------------
1085: --
1086: procedure check_prev_elig
1087: (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
1088: ,p_per_row in out NOCOPY per_all_people_f%rowtype
1089: ,p_empasg_row in out NOCOPY per_all_assignments_f%rowtype
1090: ,p_benasg_row in out NOCOPY per_all_assignments_f%rowtype
1091: ,p_pil_row in out NOCOPY ben_per_in_ler%rowtype

Line 1246: ben_manage_life_events.g_irec_ass_rec.assignment_id,

1242: or pil.per_in_ler_stat_cd is null -- outer join condition
1243: )
1244: and nvl(pil.assignment_id, -9999) = decode ( l_benmngle_parm_rec.mode_cd,
1245: 'I',
1246: ben_manage_life_events.g_irec_ass_rec.assignment_id,
1247: nvl(pil.assignment_id, -9999) ) -- iRec : Match assignment_id for iRec
1248: ;
1249: */
1250: /* 4968123

Line 1290: ben_manage_life_events.g_irec_ass_rec.assignment_id,

1286: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1287: or pil.per_in_ler_stat_cd is null)
1288: and nvl(pil.assignment_id,-9999) = decode ( l_benmngle_parm_rec.mode_cd,
1289: 'I',
1290: ben_manage_life_events.g_irec_ass_rec.assignment_id,
1291: nvl(pil.assignment_id, -9999) ); -- iRec : Match assignment_id for iRec
1292: */
1293: --
1294: cursor c_prev_oiplip_elig_check

Line 1558: if ben_manage_life_events.fonm = 'Y'

1554: benutils.get_batch_parameters( p_benefit_action_id => l_env_rec.benefit_action_id
1555: ,p_rec => l_benmngle_parm_rec);
1556: hr_utility.set_location('l_benmngle_parm_rec.mode_cd'||l_benmngle_parm_rec.mode_cd,125);
1557: -- iRec
1558: if ben_manage_life_events.fonm = 'Y'
1559: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1560: --
1561: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1562: --

Line 1559: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

1555: ,p_rec => l_benmngle_parm_rec);
1556: hr_utility.set_location('l_benmngle_parm_rec.mode_cd'||l_benmngle_parm_rec.mode_cd,125);
1557: -- iRec
1558: if ben_manage_life_events.fonm = 'Y'
1559: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1560: --
1561: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1562: --
1563: end if;

Line 1561: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

1557: -- iRec
1558: if ben_manage_life_events.fonm = 'Y'
1559: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1560: --
1561: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1562: --
1563: end if;
1564: --
1565: l_effective_dt := nvl(l_fonm_cvg_strt_dt,l_effective_dt);

Line 1638: ben_manage_life_events.g_output_string :=

1634: then
1635: close c_ptnl_le;
1636: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1637: hr_utility.set_location('PTNL LE FOUND ben_determine_eligibility2.check_prev_elig', 10);
1638: ben_manage_life_events.g_output_string :=
1639: ben_manage_life_events.g_output_string||
1640: 'Elg: Yes '||-- 3597303
1641: 'Warning:'||fnd_message.get;
1642: --

Line 1639: ben_manage_life_events.g_output_string||

1635: close c_ptnl_le;
1636: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1637: hr_utility.set_location('PTNL LE FOUND ben_determine_eligibility2.check_prev_elig', 10);
1638: ben_manage_life_events.g_output_string :=
1639: ben_manage_life_events.g_output_string||
1640: 'Elg: Yes '||-- 3597303
1641: 'Warning:'||fnd_message.get;
1642: --
1643: -- DDW change, set object ineligible

Line 1690: ben_manage_life_events.g_output_string :=

1686: and l_benmngle_parm_rec.mode_cd <> 'I' --iRec:Do not raise the error when BENMNGLE processed in iRecruitment mode
1687: then
1688: close c_ptnl_le;
1689: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1690: ben_manage_life_events.g_output_string :=
1691: ben_manage_life_events.g_output_string||
1692: 'Elg: Yes '||-- 3597303
1693: 'Warning:'||fnd_message.get;
1694: --

Line 1691: ben_manage_life_events.g_output_string||

1687: then
1688: close c_ptnl_le;
1689: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1690: ben_manage_life_events.g_output_string :=
1691: ben_manage_life_events.g_output_string||
1692: 'Elg: Yes '||-- 3597303
1693: 'Warning:'||fnd_message.get;
1694: --
1695: -- DDW change, set object ineligible

Line 1802: ,p_irec_asg_id => ben_manage_life_events.g_irec_ass_rec.assignment_id

1798: ,p_effective_date => l_effective_dt
1799: ,p_pl_id => l_envpl_id
1800: ,p_opt_id => l_oipl_rec.opt_id
1801: ,p_mode_cd => l_benmngle_parm_rec.mode_cd
1802: ,p_irec_asg_id => ben_manage_life_events.g_irec_ass_rec.assignment_id
1803: --
1804: ,p_prev_eligibility => l_prev_eligibility
1805: ,p_elig_per_opt_id => l_elig_per_opt_id
1806: ,p_opt_elig_flag => l_opt_elig_flag

Line 1894: if instr(ben_manage_life_events.g_output_string,

1890: -- per is not written
1891: p_first_inelig := true;
1892: -- person is inelig for the first time
1893: -- and not being recorded.
1894: if instr(ben_manage_life_events.g_output_string,
1895: 'Elg:') = 0 then
1896: --
1897: ben_manage_life_events.g_output_string :=
1898: ben_manage_life_events.g_output_string||

Line 1897: ben_manage_life_events.g_output_string :=

1893: -- and not being recorded.
1894: if instr(ben_manage_life_events.g_output_string,
1895: 'Elg:') = 0 then
1896: --
1897: ben_manage_life_events.g_output_string :=
1898: ben_manage_life_events.g_output_string||
1899: 'Elg: No '||
1900: 'Rsn: Inelig FT';
1901: --

Line 1898: ben_manage_life_events.g_output_string||

1894: if instr(ben_manage_life_events.g_output_string,
1895: 'Elg:') = 0 then
1896: --
1897: ben_manage_life_events.g_output_string :=
1898: ben_manage_life_events.g_output_string||
1899: 'Elg: No '||
1900: 'Rsn: Inelig FT';
1901: --
1902: end if;

Line 1918: if instr(ben_manage_life_events.g_output_string,

1914: -- Person still eligible, do nothing.
1915: fnd_message.set_name ('BEN','BEN_91345_ELIG_PREV_ELIG');
1916: benutils.write(p_text => fnd_message.get);
1917: --
1918: if instr(ben_manage_life_events.g_output_string,
1919: 'Elg:') = 0 then
1920: --
1921: ben_manage_life_events.g_output_string :=
1922: ben_manage_life_events.g_output_string||

Line 1921: ben_manage_life_events.g_output_string :=

1917: --
1918: if instr(ben_manage_life_events.g_output_string,
1919: 'Elg:') = 0 then
1920: --
1921: ben_manage_life_events.g_output_string :=
1922: ben_manage_life_events.g_output_string||
1923: 'Elg: Yes '||
1924: 'Rsn: Still Elig';
1925: --

Line 1922: ben_manage_life_events.g_output_string||

1918: if instr(ben_manage_life_events.g_output_string,
1919: 'Elg:') = 0 then
1920: --
1921: ben_manage_life_events.g_output_string :=
1922: ben_manage_life_events.g_output_string||
1923: 'Elg: Yes '||
1924: 'Rsn: Still Elig';
1925: --
1926: end if;

Line 2186: raise ben_manage_life_events.g_record_error;

2182: else
2183: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
2184: fnd_message.set_token('FLAG','epo.elig_flag');
2185: fnd_message.set_token('PROC','ben_determine_eligibility2.check_prev_elig');
2186: raise ben_manage_life_events.g_record_error;
2187: --
2188: end if; --d
2189: --
2190: end if; --b

Line 2263: raise ben_manage_life_events.g_record_error;

2259: if l_plnpep_dets.elig_per_id is null
2260: then
2261: --
2262: fnd_message.set_name('BEN','BEN_91394_ELIG_NOT_FOUND');
2263: raise ben_manage_life_events.g_record_error;
2264: --
2265: else
2266: --
2267: l_elig_per_id := l_plnpep_dets.elig_per_id;

Line 2313: if instr(ben_manage_life_events.g_output_string,

2309: --
2310: if l_first_elig then --n
2311: hr_utility.set_location ('first elig',121);
2312: -- Create Elig Person for Option
2313: if instr(ben_manage_life_events.g_output_string,
2314: 'Elg:') = 0 then
2315: --
2316: ben_manage_life_events.g_output_string :=
2317: ben_manage_life_events.g_output_string||

Line 2316: ben_manage_life_events.g_output_string :=

2312: -- Create Elig Person for Option
2313: if instr(ben_manage_life_events.g_output_string,
2314: 'Elg:') = 0 then
2315: --
2316: ben_manage_life_events.g_output_string :=
2317: ben_manage_life_events.g_output_string||
2318: 'Elg: Yes '||
2319: 'Rsn: First Time Elig';
2320: --

Line 2317: ben_manage_life_events.g_output_string||

2313: if instr(ben_manage_life_events.g_output_string,
2314: 'Elg:') = 0 then
2315: --
2316: ben_manage_life_events.g_output_string :=
2317: ben_manage_life_events.g_output_string||
2318: 'Elg: Yes '||
2319: 'Rsn: First Time Elig';
2320: --
2321: end if;

Line 2329: if ben_manage_life_events.g_modified_mode in ('S') then

2325: -- then prtn_strt_dt of the eligibility record created in
2326: -- ben_elig_per_f and ben_elig_per_opt_f should be the date on
2327: -- which concurrent request is run.
2328:
2329: if ben_manage_life_events.g_modified_mode in ('S') then
2330: if l_prtn_eff_strt_dt > l_elig_per_prtn_strt_dt then
2331: l_prtn_eff_strt_dt := l_elig_per_prtn_strt_dt;
2332: end if;
2333: end if;

Line 2536: if instr(ben_manage_life_events.g_output_string,

2532: --
2533: elsif l_still_elig then --n
2534: --
2535: hr_utility.set_location ('still elig',121);
2536: if instr(ben_manage_life_events.g_output_string,
2537: 'Elg:') = 0 then
2538: --
2539: ben_manage_life_events.g_output_string :=
2540: ben_manage_life_events.g_output_string||

Line 2539: ben_manage_life_events.g_output_string :=

2535: hr_utility.set_location ('still elig',121);
2536: if instr(ben_manage_life_events.g_output_string,
2537: 'Elg:') = 0 then
2538: --
2539: ben_manage_life_events.g_output_string :=
2540: ben_manage_life_events.g_output_string||
2541: 'Elg: Yes '||
2542: 'Rsn: Prev elig';
2543: --

Line 2540: ben_manage_life_events.g_output_string||

2536: if instr(ben_manage_life_events.g_output_string,
2537: 'Elg:') = 0 then
2538: --
2539: ben_manage_life_events.g_output_string :=
2540: ben_manage_life_events.g_output_string||
2541: 'Elg: Yes '||
2542: 'Rsn: Prev elig';
2543: --
2544: end if;

Line 2836: if instr(ben_manage_life_events.g_output_string,

2832: end if;
2833: elsif l_newly_elig then --n
2834: --
2835: hr_utility.set_location('new elig',23);
2836: if instr(ben_manage_life_events.g_output_string,
2837: 'Elg:') = 0 then
2838: --
2839: ben_manage_life_events.g_output_string :=
2840: ben_manage_life_events.g_output_string||

Line 2839: ben_manage_life_events.g_output_string :=

2835: hr_utility.set_location('new elig',23);
2836: if instr(ben_manage_life_events.g_output_string,
2837: 'Elg:') = 0 then
2838: --
2839: ben_manage_life_events.g_output_string :=
2840: ben_manage_life_events.g_output_string||
2841: 'Elg: Yes '||
2842: 'Rsn: Prev Inelig';
2843: --

Line 2840: ben_manage_life_events.g_output_string||

2836: if instr(ben_manage_life_events.g_output_string,
2837: 'Elg:') = 0 then
2838: --
2839: ben_manage_life_events.g_output_string :=
2840: ben_manage_life_events.g_output_string||
2841: 'Elg: Yes '||
2842: 'Rsn: Prev Inelig';
2843: --
2844: end if;

Line 3512: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH

3508: if (l_pl_id is not null or
3509: p_oipl_id is not null or
3510: p_pgm_id is not null) then
3511: --
3512: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
3513: --
3514: ben_newly_ineligible.main
3515: (p_person_id => p_person_id,
3516: p_pl_id => l_pl_id,

Line 3529: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH

3525: --
3526: end if;
3527: --
3528: if p_ptip_id is not null then
3529: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
3530: --
3531: for l_rec in c_get_pl_from_ptip(nvl(l_fonm_cvg_strt_dt,p_effective_date)) loop
3532: ben_newly_ineligible.main
3533: (p_person_id => p_person_id,

Line 3566: raise ben_manage_life_events.g_record_error;

3562: if l_plnpep_dets.elig_per_id is null
3563: then
3564: --
3565: fnd_message.set_name('BEN','BEN_91394_ELIG_NOT_FOUND');
3566: raise ben_manage_life_events.g_record_error;
3567: --
3568: else
3569: --
3570: l_elig_per_id := l_plnpep_dets.elig_per_id;

Line 3587: if instr(ben_manage_life_events.g_output_string,

3583: -- Person not eligible now or in the past.
3584: -- Create elig person with elig flag = 'n'
3585: -- Call API
3586: --
3587: if instr(ben_manage_life_events.g_output_string,
3588: 'Elg:') = 0 then
3589: --
3590: ben_manage_life_events.g_output_string :=
3591: ben_manage_life_events.g_output_string||

Line 3590: ben_manage_life_events.g_output_string :=

3586: --
3587: if instr(ben_manage_life_events.g_output_string,
3588: 'Elg:') = 0 then
3589: --
3590: ben_manage_life_events.g_output_string :=
3591: ben_manage_life_events.g_output_string||
3592: 'Elg: No '||
3593: 'Rsn: Not Elig FTIME';
3594: --

Line 3591: ben_manage_life_events.g_output_string||

3587: if instr(ben_manage_life_events.g_output_string,
3588: 'Elg:') = 0 then
3589: --
3590: ben_manage_life_events.g_output_string :=
3591: ben_manage_life_events.g_output_string||
3592: 'Elg: No '||
3593: 'Rsn: Not Elig FTIME';
3594: --
3595: end if;

Line 3760: raise ben_manage_life_events.g_record_error;

3756: end if;
3757: else
3758: --
3759: fnd_message.set_name('BEN','BEN_91392_ELIG_FLAG_ERROR');
3760: raise ben_manage_life_events.g_record_error;
3761: --
3762: end if; --n
3763: --
3764: -- Now check for the oiplip case.

Line 3829: raise ben_manage_life_events.g_record_error;

3825: -- Bug 3111613
3826: -- if cache reeturns a null here, raise an error
3827: if l_prev_oiplip_elig_check.elig_per_id is null then
3828: fnd_message.set_name('BEN','BEN_91394_ELIG_NOT_FOUND');
3829: raise ben_manage_life_events.g_record_error;
3830: end if;
3831:
3832:
3833: -- Create oiplip record

Line 4282: ,p_irec_asg_id => ben_manage_life_events.g_irec_ass_rec.assignment_id

4278: ,p_pl_id => nvl(p_pl_id,-1)
4279: ,p_ptip_id => nvl(p_ptip_id,-1)
4280: ,p_effective_date => l_effective_dt
4281: ,p_mode_cd => l_benmngle_parm_rec.mode_cd
4282: ,p_irec_asg_id => ben_manage_life_events.g_irec_ass_rec.assignment_id
4283: --
4284: ,p_prev_eligibility => l_prev_eligibility
4285: ,p_elig_per_id => l_elig_per_id
4286: ,p_elig_per_elig_flag => l_elig_per_elig_flag

Line 4396: if instr(ben_manage_life_events.g_output_string,

4392: l_start_or_end := 'E';
4393: --
4394: else
4395: --
4396: if instr(ben_manage_life_events.g_output_string,
4397: 'Elg:') = 0 then
4398: --
4399: ben_manage_life_events.g_output_string :=
4400: ben_manage_life_events.g_output_string||

Line 4399: ben_manage_life_events.g_output_string :=

4395: --
4396: if instr(ben_manage_life_events.g_output_string,
4397: 'Elg:') = 0 then
4398: --
4399: ben_manage_life_events.g_output_string :=
4400: ben_manage_life_events.g_output_string||
4401: 'Elg: No '||
4402: 'Rsn: Not Elig FTIME';
4403: --

Line 4400: ben_manage_life_events.g_output_string||

4396: if instr(ben_manage_life_events.g_output_string,
4397: 'Elg:') = 0 then
4398: --
4399: ben_manage_life_events.g_output_string :=
4400: ben_manage_life_events.g_output_string||
4401: 'Elg: No '||
4402: 'Rsn: Not Elig FTIME';
4403: --
4404: end if;

Line 4415: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH

4411: --
4412: -- bug#5404392 - previous FONM event creates the elig per row in future
4413: -- the subsequent finds first ineligible
4414: if p_pgm_id is not null then
4415: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
4416: --
4417: ben_newly_ineligible.main
4418: (p_person_id => p_person_id,
4419: p_pl_id => null,

Line 4804: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH

4800: if (l_pl_id is not null or
4801: p_oipl_id is not null or
4802: p_pgm_id is not null) then
4803:
4804: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
4805: ben_newly_ineligible.main
4806: (p_person_id => p_person_id,
4807: p_pl_id => l_pl_id,
4808: p_pgm_id => nvl(p_pgm_id,l_envpgm_id),

Line 4821: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH

4817:
4818: end if;
4819: --
4820: if p_ptip_id is not null then
4821: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
4822: for l_rec in c_get_pl_from_ptip(nvl(l_fonm_cvg_strt_dt,p_effective_date)) loop
4823: ben_newly_ineligible.main
4824: (p_person_id => p_person_id,
4825: p_pl_id => l_rec.pl_id,

Line 4850: raise ben_manage_life_events.g_record_error;

4846: --
4847: else
4848: --
4849: fnd_message.set_name('BEN','BEN_91392_ELIG_FLAG_ERROR');
4850: raise ben_manage_life_events.g_record_error;
4851: --
4852: end if; --d
4853: --
4854: end if; --a2

Line 4902: if instr(ben_manage_life_events.g_output_string,

4898: --
4899: if l_first_elig then --c
4900: --
4901: hr_utility.set_location ('first elig',121);
4902: if instr(ben_manage_life_events.g_output_string,
4903: 'Elg:') = 0 then
4904: --
4905: ben_manage_life_events.g_output_string :=
4906: ben_manage_life_events.g_output_string||

Line 4905: ben_manage_life_events.g_output_string :=

4901: hr_utility.set_location ('first elig',121);
4902: if instr(ben_manage_life_events.g_output_string,
4903: 'Elg:') = 0 then
4904: --
4905: ben_manage_life_events.g_output_string :=
4906: ben_manage_life_events.g_output_string||
4907: 'Elg: Yes '||
4908: 'Rsn: FTIME Elig';
4909: --

Line 4906: ben_manage_life_events.g_output_string||

4902: if instr(ben_manage_life_events.g_output_string,
4903: 'Elg:') = 0 then
4904: --
4905: ben_manage_life_events.g_output_string :=
4906: ben_manage_life_events.g_output_string||
4907: 'Elg: Yes '||
4908: 'Rsn: FTIME Elig';
4909: --
4910: end if;

Line 4919: if ben_manage_life_events.g_modified_mode in ('S') then

4915: -- then prtn_strt_dt of the eligibility record created in
4916: -- ben_elig_per_f and ben_elig_per_opt_f should be the date on
4917: -- which concurrent request is run.
4918: --
4919: if ben_manage_life_events.g_modified_mode in ('S') then
4920: if l_prtn_eff_strt_dt > p_effective_date then
4921: l_prtn_eff_strt_dt := p_effective_date;
4922: end if;
4923: end if;

Line 5164: if instr(ben_manage_life_events.g_output_string,

5160: end if;
5161: elsif l_still_elig then --c
5162: --
5163: hr_utility.set_location('ben_determine_eligibility2.check_prev_elig l_still_elig ', 10);
5164: if instr(ben_manage_life_events.g_output_string,
5165: 'Elg:') = 0 then
5166: --
5167: ben_manage_life_events.g_output_string :=
5168: ben_manage_life_events.g_output_string||

Line 5167: ben_manage_life_events.g_output_string :=

5163: hr_utility.set_location('ben_determine_eligibility2.check_prev_elig l_still_elig ', 10);
5164: if instr(ben_manage_life_events.g_output_string,
5165: 'Elg:') = 0 then
5166: --
5167: ben_manage_life_events.g_output_string :=
5168: ben_manage_life_events.g_output_string||
5169: 'Elg: Yes '||
5170: 'Rsn: Prev Elig';
5171: --

Line 5168: ben_manage_life_events.g_output_string||

5164: if instr(ben_manage_life_events.g_output_string,
5165: 'Elg:') = 0 then
5166: --
5167: ben_manage_life_events.g_output_string :=
5168: ben_manage_life_events.g_output_string||
5169: 'Elg: Yes '||
5170: 'Rsn: Prev Elig';
5171: --
5172: end if;

Line 5471: if instr(ben_manage_life_events.g_output_string,

5467: hr_utility.set_location('newly eligible',23);
5468: --
5469: l_p_object_version_number := l_object_version_number;
5470: --
5471: if instr(ben_manage_life_events.g_output_string,
5472: 'Elg:') = 0 then
5473: --
5474: ben_manage_life_events.g_output_string :=
5475: ben_manage_life_events.g_output_string||

Line 5474: ben_manage_life_events.g_output_string :=

5470: --
5471: if instr(ben_manage_life_events.g_output_string,
5472: 'Elg:') = 0 then
5473: --
5474: ben_manage_life_events.g_output_string :=
5475: ben_manage_life_events.g_output_string||
5476: 'Elg: Yes '||
5477: 'Rsn: Prev InElig';
5478: --

Line 5475: ben_manage_life_events.g_output_string||

5471: if instr(ben_manage_life_events.g_output_string,
5472: 'Elg:') = 0 then
5473: --
5474: ben_manage_life_events.g_output_string :=
5475: ben_manage_life_events.g_output_string||
5476: 'Elg: Yes '||
5477: 'Rsn: Prev InElig';
5478: --
5479: end if;

Line 5822: if instr(ben_manage_life_events.g_output_string,

5818: hr_utility.set_location ('newly inelig',121);
5819: --
5820: l_p_object_version_number := l_object_version_number;
5821: --
5822: if instr(ben_manage_life_events.g_output_string,
5823: 'Elg:') = 0 then
5824: --
5825: ben_manage_life_events.g_output_string :=
5826: ben_manage_life_events.g_output_string||

Line 5825: ben_manage_life_events.g_output_string :=

5821: --
5822: if instr(ben_manage_life_events.g_output_string,
5823: 'Elg:') = 0 then
5824: --
5825: ben_manage_life_events.g_output_string :=
5826: ben_manage_life_events.g_output_string||
5827: 'Elg: No '||
5828: 'Rsn: Prev Elig';
5829: --

Line 5826: ben_manage_life_events.g_output_string||

5822: if instr(ben_manage_life_events.g_output_string,
5823: 'Elg:') = 0 then
5824: --
5825: ben_manage_life_events.g_output_string :=
5826: ben_manage_life_events.g_output_string||
5827: 'Elg: No '||
5828: 'Rsn: Prev Elig';
5829: --
5830: end if;

Line 6145: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH

6141:
6142: if (l_pl_id is not null or
6143: p_oipl_id is not null or
6144: p_pgm_id is not null) then
6145: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
6146: ben_newly_ineligible.main
6147: (p_person_id => p_person_id,
6148: p_pl_id => l_pl_id,
6149: p_pgm_id => nvl(p_pgm_id,l_envpgm_id),

Line 6162: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH

6158: --
6159: end if;
6160: --
6161: if p_ptip_id is not null then
6162: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
6163: for l_rec in c_get_pl_from_ptip(nvl(l_fonm_cvg_strt_dt,p_effective_date)) loop
6164: ben_newly_ineligible.main
6165: (p_person_id => p_person_id,
6166: p_pl_id => l_rec.pl_id,

Line 6181: if instr(ben_manage_life_events.g_output_string,

6177: end if;
6178: elsif l_first_inelig then --c
6179: --
6180: hr_utility.set_location ('first inelig',121);
6181: if instr(ben_manage_life_events.g_output_string,
6182: 'Elg:') = 0 then
6183: --
6184: ben_manage_life_events.g_output_string :=
6185: ben_manage_life_events.g_output_string||

Line 6184: ben_manage_life_events.g_output_string :=

6180: hr_utility.set_location ('first inelig',121);
6181: if instr(ben_manage_life_events.g_output_string,
6182: 'Elg:') = 0 then
6183: --
6184: ben_manage_life_events.g_output_string :=
6185: ben_manage_life_events.g_output_string||
6186: 'Elg: No '||
6187: 'Rsn: FTIME InElig';
6188: --

Line 6185: ben_manage_life_events.g_output_string||

6181: if instr(ben_manage_life_events.g_output_string,
6182: 'Elg:') = 0 then
6183: --
6184: ben_manage_life_events.g_output_string :=
6185: ben_manage_life_events.g_output_string||
6186: 'Elg: No '||
6187: 'Rsn: FTIME InElig';
6188: --
6189: end if;