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 382: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec

378: -- |----------------------< get_start_end_dates >------------------------------|
379: -- -----------------------------------------------------------------------------
380: --
381: procedure get_start_end_dates
382: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
383: ,p_pil_row in ben_per_in_ler%rowtype
384: ,p_effective_date in date
385: ,p_business_group_id in number
386: ,p_person_id in number

Line 452: if ben_manage_life_events.fonm = 'Y'

448: -- hr_utility.set_location('p_plip_id -> ' ||p_plip_id,123);
449: -- hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,123);
450: -- hr_utility.set_location('p_oipl_id -> ' ||p_oipl_id,123);
451: --
452: if ben_manage_life_events.fonm = 'Y'
453: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
454: --
455: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
456: --

Line 453: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

449: -- hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,123);
450: -- hr_utility.set_location('p_oipl_id -> ' ||p_oipl_id,123);
451: --
452: if ben_manage_life_events.fonm = 'Y'
453: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
454: --
455: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
456: --
457: end if;

Line 455: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

451: --
452: if ben_manage_life_events.fonm = 'Y'
453: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
454: --
455: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
456: --
457: end if;
458: --
459: -- if the mode is Personnel Action - the participation start date and end date needs to be

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

733: if p_start_or_end = 'S' then
734: if l_prtn_eff_strt_dt_cd <> 'RL' then
735: -- hr_utility.set_location('ben_determine_eligibility2.get_start_end_dates SOE S not RL ben_determine_eligibility2.get_start_end_dates', 10);
736: /* -- FONM START
737: if ben_manage_life_events.fonm = 'Y' and
738: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
739: --
740: p_prtn_eff_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
741: --

Line 738: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

734: if l_prtn_eff_strt_dt_cd <> 'RL' then
735: -- hr_utility.set_location('ben_determine_eligibility2.get_start_end_dates SOE S not RL ben_determine_eligibility2.get_start_end_dates', 10);
736: /* -- FONM START
737: if ben_manage_life_events.fonm = 'Y' and
738: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
739: --
740: p_prtn_eff_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
741: --
742: else

Line 740: p_prtn_eff_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

736: /* -- FONM START
737: if ben_manage_life_events.fonm = 'Y' and
738: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
739: --
740: p_prtn_eff_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
741: --
742: else
743: --
744: --FONM END

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

817: ,p_pgm_id => l_envpgm_id
818: ,p_opt_id => l_oipl_rec.opt_id
819: ,p_ler_id => p_pil_row.ler_id
820: ,p_param1 => 'BEN_IV_RT_STRT_DT'
821: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
822: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
823: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
824: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
825: ,p_param3_value => to_char(p_person_id)

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

819: ,p_ler_id => p_pil_row.ler_id
820: ,p_param1 => 'BEN_IV_RT_STRT_DT'
821: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
822: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
823: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
824: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
825: ,p_param3_value => to_char(p_person_id)
826: ,p_jurisdiction_code => l_jurisdiction_code
827: );

Line 840: raise ben_manage_life_events.g_record_error;

836: when others then
837: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
838: fnd_message.set_token('RL','prtn_eff_strt_dt_rl');
839: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
840: raise ben_manage_life_events.g_record_error;
841: end;
842: else
843: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
844: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');

Line 846: raise ben_manage_life_events.g_record_error ;

842: else
843: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
844: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
845: fnd_message.set_token('CODE1',l_prtn_eff_strt_dt_cd);
846: raise ben_manage_life_events.g_record_error ;
847: end if;
848:
849: elsif p_start_or_end = 'E' then
850: --

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

849: elsif p_start_or_end = 'E' then
850: --
851: -- hr_utility.set_location('ben_determine_eligibility2.get_start_end_dates p_start_or_end is E ' , 10);
852: -- FONM START
853: if ben_manage_life_events.fonm = 'Y' and
854: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
855: --
856: p_prtn_eff_end_dt := ben_manage_life_events.g_fonm_cvg_strt_dt - 1 ;
857: --

Line 854: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

850: --
851: -- hr_utility.set_location('ben_determine_eligibility2.get_start_end_dates p_start_or_end is E ' , 10);
852: -- FONM START
853: if ben_manage_life_events.fonm = 'Y' and
854: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
855: --
856: p_prtn_eff_end_dt := ben_manage_life_events.g_fonm_cvg_strt_dt - 1 ;
857: --
858: --END FONM

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

852: -- FONM START
853: if ben_manage_life_events.fonm = 'Y' and
854: ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
855: --
856: p_prtn_eff_end_dt := ben_manage_life_events.g_fonm_cvg_strt_dt - 1 ;
857: --
858: --END FONM
859: elsif l_prtn_eff_end_dt_cd = 'A30DFPSD' then
860: hr_utility.set_location('ben_determine_eligibility2.get_start_end_dates SOE E A30DFPSD ben_determine_eligibility2.get_start_end_dates', 10);

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

1026: ,p_pgm_id => l_envpgm_id
1027: ,p_opt_id => l_oipl_rec.opt_id
1028: ,p_ler_id => p_pil_row.ler_id
1029: ,p_param1 => 'BEN_IV_RT_STRT_DT'
1030: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
1031: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
1032: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
1033: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
1034: ,p_param3_value => to_char(p_person_id)

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

1028: ,p_ler_id => p_pil_row.ler_id
1029: ,p_param1 => 'BEN_IV_RT_STRT_DT'
1030: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
1031: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
1032: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
1033: ,p_param3 => 'BEN_IV_PERSON_ID' -- Bug 5331889
1034: ,p_param3_value => to_char(p_person_id)
1035: ,p_jurisdiction_code => l_jurisdiction_code
1036: );

Line 1049: raise ben_manage_life_events.g_record_error;

1045: when others then
1046: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1047: fnd_message.set_token('RL','prtn_eff_end_dt_rl');
1048: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1049: raise ben_manage_life_events.g_record_error;
1050: end;
1051:
1052: else
1053: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');

Line 1056: raise ben_manage_life_events.g_record_error;

1052: else
1053: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
1054: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1055: fnd_message.set_token('CODE1',l_prtn_eff_end_dt_cd);
1056: raise ben_manage_life_events.g_record_error;
1057: end if;
1058: else
1059: fnd_message.set_name('BEN','BEN_91393_STRT_END_ERROR');
1060: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');

Line 1061: raise ben_manage_life_events.g_record_error;

1057: end if;
1058: else
1059: fnd_message.set_name('BEN','BEN_91393_STRT_END_ERROR');
1060: fnd_message.set_token('PROC','ben_determine_eligibility2.get_start_end_dates');
1061: raise ben_manage_life_events.g_record_error;
1062: end if;
1063: -- hr_utility.set_location('Leaving ben_determine_eligibility2.get_start_end_dates',10);
1064:
1065: end get_start_end_dates;

Line 1074: (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec

1070: -- |------------------------< check_prev_elig >--------------------------------|
1071: -- -----------------------------------------------------------------------------
1072: --
1073: procedure check_prev_elig
1074: (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
1075: ,p_per_row in out NOCOPY per_all_people_f%rowtype
1076: ,p_empasg_row in out NOCOPY per_all_assignments_f%rowtype
1077: ,p_benasg_row in out NOCOPY per_all_assignments_f%rowtype
1078: ,p_pil_row in out NOCOPY ben_per_in_ler%rowtype

Line 1233: ben_manage_life_events.g_irec_ass_rec.assignment_id,

1229: or pil.per_in_ler_stat_cd is null -- outer join condition
1230: )
1231: and nvl(pil.assignment_id, -9999) = decode ( l_benmngle_parm_rec.mode_cd,
1232: 'I',
1233: ben_manage_life_events.g_irec_ass_rec.assignment_id,
1234: nvl(pil.assignment_id, -9999) ) -- iRec : Match assignment_id for iRec
1235: ;
1236: */
1237: /* 4968123

Line 1277: ben_manage_life_events.g_irec_ass_rec.assignment_id,

1273: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1274: or pil.per_in_ler_stat_cd is null)
1275: and nvl(pil.assignment_id,-9999) = decode ( l_benmngle_parm_rec.mode_cd,
1276: 'I',
1277: ben_manage_life_events.g_irec_ass_rec.assignment_id,
1278: nvl(pil.assignment_id, -9999) ); -- iRec : Match assignment_id for iRec
1279: */
1280: --
1281: cursor c_prev_oiplip_elig_check

Line 1474: if ben_manage_life_events.fonm = 'Y'

1470: benutils.get_batch_parameters( p_benefit_action_id => l_env_rec.benefit_action_id
1471: ,p_rec => l_benmngle_parm_rec);
1472: hr_utility.set_location('l_benmngle_parm_rec.mode_cd'||l_benmngle_parm_rec.mode_cd,125);
1473: -- iRec
1474: if ben_manage_life_events.fonm = 'Y'
1475: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1476: --
1477: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1478: --

Line 1475: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

1471: ,p_rec => l_benmngle_parm_rec);
1472: hr_utility.set_location('l_benmngle_parm_rec.mode_cd'||l_benmngle_parm_rec.mode_cd,125);
1473: -- iRec
1474: if ben_manage_life_events.fonm = 'Y'
1475: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1476: --
1477: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1478: --
1479: end if;

Line 1477: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

1473: -- iRec
1474: if ben_manage_life_events.fonm = 'Y'
1475: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1476: --
1477: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1478: --
1479: end if;
1480: --
1481: l_effective_dt := nvl(l_fonm_cvg_strt_dt,l_effective_dt);

Line 1544: ben_manage_life_events.g_output_string :=

1540: then
1541: close c_ptnl_le;
1542: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1543: hr_utility.set_location('PTNL LE FOUND ben_determine_eligibility2.check_prev_elig', 10);
1544: ben_manage_life_events.g_output_string :=
1545: ben_manage_life_events.g_output_string||
1546: 'Elg: Yes '||-- 3597303
1547: 'Warning:'||fnd_message.get;
1548: --

Line 1545: ben_manage_life_events.g_output_string||

1541: close c_ptnl_le;
1542: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1543: hr_utility.set_location('PTNL LE FOUND ben_determine_eligibility2.check_prev_elig', 10);
1544: ben_manage_life_events.g_output_string :=
1545: ben_manage_life_events.g_output_string||
1546: 'Elg: Yes '||-- 3597303
1547: 'Warning:'||fnd_message.get;
1548: --
1549: -- DDW change, set object ineligible

Line 1596: ben_manage_life_events.g_output_string :=

1592: and l_benmngle_parm_rec.mode_cd <> 'I' --iRec:Do not raise the error when BENMNGLE processed in iRecruitment mode
1593: then
1594: close c_ptnl_le;
1595: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1596: ben_manage_life_events.g_output_string :=
1597: ben_manage_life_events.g_output_string||
1598: 'Elg: Yes '||-- 3597303
1599: 'Warning:'||fnd_message.get;
1600: --

Line 1597: ben_manage_life_events.g_output_string||

1593: then
1594: close c_ptnl_le;
1595: fnd_message.set_name ('BEN','BEN_93992_PTNL_IN_WTG_PERD'); -- 3597303
1596: ben_manage_life_events.g_output_string :=
1597: ben_manage_life_events.g_output_string||
1598: 'Elg: Yes '||-- 3597303
1599: 'Warning:'||fnd_message.get;
1600: --
1601: -- DDW change, set object ineligible

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

1704: ,p_effective_date => l_effective_dt
1705: ,p_pl_id => l_envpl_id
1706: ,p_opt_id => l_oipl_rec.opt_id
1707: ,p_mode_cd => l_benmngle_parm_rec.mode_cd
1708: ,p_irec_asg_id => ben_manage_life_events.g_irec_ass_rec.assignment_id
1709: --
1710: ,p_prev_eligibility => l_prev_eligibility
1711: ,p_elig_per_opt_id => l_elig_per_opt_id
1712: ,p_opt_elig_flag => l_opt_elig_flag

Line 1800: if instr(ben_manage_life_events.g_output_string,

1796: -- per is not written
1797: p_first_inelig := true;
1798: -- person is inelig for the first time
1799: -- and not being recorded.
1800: if instr(ben_manage_life_events.g_output_string,
1801: 'Elg:') = 0 then
1802: --
1803: ben_manage_life_events.g_output_string :=
1804: ben_manage_life_events.g_output_string||

Line 1803: ben_manage_life_events.g_output_string :=

1799: -- and not being recorded.
1800: if instr(ben_manage_life_events.g_output_string,
1801: 'Elg:') = 0 then
1802: --
1803: ben_manage_life_events.g_output_string :=
1804: ben_manage_life_events.g_output_string||
1805: 'Elg: No '||
1806: 'Rsn: Inelig FT';
1807: --

Line 1804: ben_manage_life_events.g_output_string||

1800: if instr(ben_manage_life_events.g_output_string,
1801: 'Elg:') = 0 then
1802: --
1803: ben_manage_life_events.g_output_string :=
1804: ben_manage_life_events.g_output_string||
1805: 'Elg: No '||
1806: 'Rsn: Inelig FT';
1807: --
1808: end if;

Line 1824: if instr(ben_manage_life_events.g_output_string,

1820: -- Person still eligible, do nothing.
1821: fnd_message.set_name ('BEN','BEN_91345_ELIG_PREV_ELIG');
1822: benutils.write(p_text => fnd_message.get);
1823: --
1824: if instr(ben_manage_life_events.g_output_string,
1825: 'Elg:') = 0 then
1826: --
1827: ben_manage_life_events.g_output_string :=
1828: ben_manage_life_events.g_output_string||

Line 1827: ben_manage_life_events.g_output_string :=

1823: --
1824: if instr(ben_manage_life_events.g_output_string,
1825: 'Elg:') = 0 then
1826: --
1827: ben_manage_life_events.g_output_string :=
1828: ben_manage_life_events.g_output_string||
1829: 'Elg: Yes '||
1830: 'Rsn: Still Elig';
1831: --

Line 1828: ben_manage_life_events.g_output_string||

1824: if instr(ben_manage_life_events.g_output_string,
1825: 'Elg:') = 0 then
1826: --
1827: ben_manage_life_events.g_output_string :=
1828: ben_manage_life_events.g_output_string||
1829: 'Elg: Yes '||
1830: 'Rsn: Still Elig';
1831: --
1832: end if;

Line 2092: raise ben_manage_life_events.g_record_error;

2088: else
2089: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
2090: fnd_message.set_token('FLAG','epo.elig_flag');
2091: fnd_message.set_token('PROC','ben_determine_eligibility2.check_prev_elig');
2092: raise ben_manage_life_events.g_record_error;
2093: --
2094: end if; --d
2095: --
2096: end if; --b

Line 2169: raise ben_manage_life_events.g_record_error;

2165: if l_plnpep_dets.elig_per_id is null
2166: then
2167: --
2168: fnd_message.set_name('BEN','BEN_91394_ELIG_NOT_FOUND');
2169: raise ben_manage_life_events.g_record_error;
2170: --
2171: else
2172: --
2173: l_elig_per_id := l_plnpep_dets.elig_per_id;

Line 2219: if instr(ben_manage_life_events.g_output_string,

2215: --
2216: if l_first_elig then --n
2217: hr_utility.set_location ('first elig',121);
2218: -- Create Elig Person for Option
2219: if instr(ben_manage_life_events.g_output_string,
2220: 'Elg:') = 0 then
2221: --
2222: ben_manage_life_events.g_output_string :=
2223: ben_manage_life_events.g_output_string||

Line 2222: ben_manage_life_events.g_output_string :=

2218: -- Create Elig Person for Option
2219: if instr(ben_manage_life_events.g_output_string,
2220: 'Elg:') = 0 then
2221: --
2222: ben_manage_life_events.g_output_string :=
2223: ben_manage_life_events.g_output_string||
2224: 'Elg: Yes '||
2225: 'Rsn: First Time Elig';
2226: --

Line 2223: ben_manage_life_events.g_output_string||

2219: if instr(ben_manage_life_events.g_output_string,
2220: 'Elg:') = 0 then
2221: --
2222: ben_manage_life_events.g_output_string :=
2223: ben_manage_life_events.g_output_string||
2224: 'Elg: Yes '||
2225: 'Rsn: First Time Elig';
2226: --
2227: end if;

Line 2426: if instr(ben_manage_life_events.g_output_string,

2422: --
2423: elsif l_still_elig then --n
2424: --
2425: hr_utility.set_location ('still elig',121);
2426: if instr(ben_manage_life_events.g_output_string,
2427: 'Elg:') = 0 then
2428: --
2429: ben_manage_life_events.g_output_string :=
2430: ben_manage_life_events.g_output_string||

Line 2429: ben_manage_life_events.g_output_string :=

2425: hr_utility.set_location ('still elig',121);
2426: if instr(ben_manage_life_events.g_output_string,
2427: 'Elg:') = 0 then
2428: --
2429: ben_manage_life_events.g_output_string :=
2430: ben_manage_life_events.g_output_string||
2431: 'Elg: Yes '||
2432: 'Rsn: Prev elig';
2433: --

Line 2430: ben_manage_life_events.g_output_string||

2426: if instr(ben_manage_life_events.g_output_string,
2427: 'Elg:') = 0 then
2428: --
2429: ben_manage_life_events.g_output_string :=
2430: ben_manage_life_events.g_output_string||
2431: 'Elg: Yes '||
2432: 'Rsn: Prev elig';
2433: --
2434: end if;

Line 2670: if instr(ben_manage_life_events.g_output_string,

2666: end if;
2667: elsif l_newly_elig then --n
2668: --
2669: hr_utility.set_location('new elig',23);
2670: if instr(ben_manage_life_events.g_output_string,
2671: 'Elg:') = 0 then
2672: --
2673: ben_manage_life_events.g_output_string :=
2674: ben_manage_life_events.g_output_string||

Line 2673: ben_manage_life_events.g_output_string :=

2669: hr_utility.set_location('new elig',23);
2670: if instr(ben_manage_life_events.g_output_string,
2671: 'Elg:') = 0 then
2672: --
2673: ben_manage_life_events.g_output_string :=
2674: ben_manage_life_events.g_output_string||
2675: 'Elg: Yes '||
2676: 'Rsn: Prev Inelig';
2677: --

Line 2674: ben_manage_life_events.g_output_string||

2670: if instr(ben_manage_life_events.g_output_string,
2671: 'Elg:') = 0 then
2672: --
2673: ben_manage_life_events.g_output_string :=
2674: ben_manage_life_events.g_output_string||
2675: 'Elg: Yes '||
2676: 'Rsn: Prev Inelig';
2677: --
2678: end if;

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

3232: if (l_pl_id is not null or
3233: p_oipl_id is not null or
3234: p_pgm_id is not null) then
3235: --
3236: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
3237: --
3238: ben_newly_ineligible.main
3239: (p_person_id => p_person_id,
3240: p_pl_id => l_pl_id,

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

3249: --
3250: end if;
3251: --
3252: if p_ptip_id is not null then
3253: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
3254: --
3255: for l_rec in c_get_pl_from_ptip(nvl(l_fonm_cvg_strt_dt,p_effective_date)) loop
3256: ben_newly_ineligible.main
3257: (p_person_id => p_person_id,

Line 3290: raise ben_manage_life_events.g_record_error;

3286: if l_plnpep_dets.elig_per_id is null
3287: then
3288: --
3289: fnd_message.set_name('BEN','BEN_91394_ELIG_NOT_FOUND');
3290: raise ben_manage_life_events.g_record_error;
3291: --
3292: else
3293: --
3294: l_elig_per_id := l_plnpep_dets.elig_per_id;

Line 3311: if instr(ben_manage_life_events.g_output_string,

3307: -- Person not eligible now or in the past.
3308: -- Create elig person with elig flag = 'n'
3309: -- Call API
3310: --
3311: if instr(ben_manage_life_events.g_output_string,
3312: 'Elg:') = 0 then
3313: --
3314: ben_manage_life_events.g_output_string :=
3315: ben_manage_life_events.g_output_string||

Line 3314: ben_manage_life_events.g_output_string :=

3310: --
3311: if instr(ben_manage_life_events.g_output_string,
3312: 'Elg:') = 0 then
3313: --
3314: ben_manage_life_events.g_output_string :=
3315: ben_manage_life_events.g_output_string||
3316: 'Elg: No '||
3317: 'Rsn: Not Elig FTIME';
3318: --

Line 3315: ben_manage_life_events.g_output_string||

3311: if instr(ben_manage_life_events.g_output_string,
3312: 'Elg:') = 0 then
3313: --
3314: ben_manage_life_events.g_output_string :=
3315: ben_manage_life_events.g_output_string||
3316: 'Elg: No '||
3317: 'Rsn: Not Elig FTIME';
3318: --
3319: end if;

Line 3484: raise ben_manage_life_events.g_record_error;

3480: end if;
3481: else
3482: --
3483: fnd_message.set_name('BEN','BEN_91392_ELIG_FLAG_ERROR');
3484: raise ben_manage_life_events.g_record_error;
3485: --
3486: end if; --n
3487: --
3488: -- Now check for the oiplip case.

Line 3553: raise ben_manage_life_events.g_record_error;

3549: -- Bug 3111613
3550: -- if cache reeturns a null here, raise an error
3551: if l_prev_oiplip_elig_check.elig_per_id is null then
3552: fnd_message.set_name('BEN','BEN_91394_ELIG_NOT_FOUND');
3553: raise ben_manage_life_events.g_record_error;
3554: end if;
3555:
3556:
3557: -- Create oiplip record

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

3946: ,p_pl_id => nvl(p_pl_id,-1)
3947: ,p_ptip_id => nvl(p_ptip_id,-1)
3948: ,p_effective_date => l_effective_dt
3949: ,p_mode_cd => l_benmngle_parm_rec.mode_cd
3950: ,p_irec_asg_id => ben_manage_life_events.g_irec_ass_rec.assignment_id
3951: --
3952: ,p_prev_eligibility => l_prev_eligibility
3953: ,p_elig_per_id => l_elig_per_id
3954: ,p_elig_per_elig_flag => l_elig_per_elig_flag

Line 4064: if instr(ben_manage_life_events.g_output_string,

4060: l_start_or_end := 'E';
4061: --
4062: else
4063: --
4064: if instr(ben_manage_life_events.g_output_string,
4065: 'Elg:') = 0 then
4066: --
4067: ben_manage_life_events.g_output_string :=
4068: ben_manage_life_events.g_output_string||

Line 4067: ben_manage_life_events.g_output_string :=

4063: --
4064: if instr(ben_manage_life_events.g_output_string,
4065: 'Elg:') = 0 then
4066: --
4067: ben_manage_life_events.g_output_string :=
4068: ben_manage_life_events.g_output_string||
4069: 'Elg: No '||
4070: 'Rsn: Not Elig FTIME';
4071: --

Line 4068: ben_manage_life_events.g_output_string||

4064: if instr(ben_manage_life_events.g_output_string,
4065: 'Elg:') = 0 then
4066: --
4067: ben_manage_life_events.g_output_string :=
4068: ben_manage_life_events.g_output_string||
4069: 'Elg: No '||
4070: 'Rsn: Not Elig FTIME';
4071: --
4072: end if;

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

4079: --
4080: -- bug#5404392 - previous FONM event creates the elig per row in future
4081: -- the subsequent finds first ineligible
4082: if p_pgm_id is not null then
4083: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
4084: --
4085: ben_newly_ineligible.main
4086: (p_person_id => p_person_id,
4087: p_pl_id => null,

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

4424: if (l_pl_id is not null or
4425: p_oipl_id is not null or
4426: p_pgm_id is not null) then
4427:
4428: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
4429: ben_newly_ineligible.main
4430: (p_person_id => p_person_id,
4431: p_pl_id => l_pl_id,
4432: p_pgm_id => nvl(p_pgm_id,l_envpgm_id),

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

4441:
4442: end if;
4443: --
4444: if p_ptip_id is not null then
4445: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
4446: for l_rec in c_get_pl_from_ptip(nvl(l_fonm_cvg_strt_dt,p_effective_date)) loop
4447: ben_newly_ineligible.main
4448: (p_person_id => p_person_id,
4449: p_pl_id => l_rec.pl_id,

Line 4474: raise ben_manage_life_events.g_record_error;

4470: --
4471: else
4472: --
4473: fnd_message.set_name('BEN','BEN_91392_ELIG_FLAG_ERROR');
4474: raise ben_manage_life_events.g_record_error;
4475: --
4476: end if; --d
4477: --
4478: end if; --a2

Line 4526: if instr(ben_manage_life_events.g_output_string,

4522: --
4523: if l_first_elig then --c
4524: --
4525: hr_utility.set_location ('first elig',121);
4526: if instr(ben_manage_life_events.g_output_string,
4527: 'Elg:') = 0 then
4528: --
4529: ben_manage_life_events.g_output_string :=
4530: ben_manage_life_events.g_output_string||

Line 4529: ben_manage_life_events.g_output_string :=

4525: hr_utility.set_location ('first elig',121);
4526: if instr(ben_manage_life_events.g_output_string,
4527: 'Elg:') = 0 then
4528: --
4529: ben_manage_life_events.g_output_string :=
4530: ben_manage_life_events.g_output_string||
4531: 'Elg: Yes '||
4532: 'Rsn: FTIME Elig';
4533: --

Line 4530: ben_manage_life_events.g_output_string||

4526: if instr(ben_manage_life_events.g_output_string,
4527: 'Elg:') = 0 then
4528: --
4529: ben_manage_life_events.g_output_string :=
4530: ben_manage_life_events.g_output_string||
4531: 'Elg: Yes '||
4532: 'Rsn: FTIME Elig';
4533: --
4534: end if;

Line 4773: if instr(ben_manage_life_events.g_output_string,

4769: end if;
4770: elsif l_still_elig then --c
4771: --
4772: hr_utility.set_location('ben_determine_eligibility2.check_prev_elig l_still_elig ', 10);
4773: if instr(ben_manage_life_events.g_output_string,
4774: 'Elg:') = 0 then
4775: --
4776: ben_manage_life_events.g_output_string :=
4777: ben_manage_life_events.g_output_string||

Line 4776: ben_manage_life_events.g_output_string :=

4772: hr_utility.set_location('ben_determine_eligibility2.check_prev_elig l_still_elig ', 10);
4773: if instr(ben_manage_life_events.g_output_string,
4774: 'Elg:') = 0 then
4775: --
4776: ben_manage_life_events.g_output_string :=
4777: ben_manage_life_events.g_output_string||
4778: 'Elg: Yes '||
4779: 'Rsn: Prev Elig';
4780: --

Line 4777: ben_manage_life_events.g_output_string||

4773: if instr(ben_manage_life_events.g_output_string,
4774: 'Elg:') = 0 then
4775: --
4776: ben_manage_life_events.g_output_string :=
4777: ben_manage_life_events.g_output_string||
4778: 'Elg: Yes '||
4779: 'Rsn: Prev Elig';
4780: --
4781: end if;

Line 5038: if instr(ben_manage_life_events.g_output_string,

5034: hr_utility.set_location('newly eligible',23);
5035: --
5036: l_p_object_version_number := l_object_version_number;
5037: --
5038: if instr(ben_manage_life_events.g_output_string,
5039: 'Elg:') = 0 then
5040: --
5041: ben_manage_life_events.g_output_string :=
5042: ben_manage_life_events.g_output_string||

Line 5041: ben_manage_life_events.g_output_string :=

5037: --
5038: if instr(ben_manage_life_events.g_output_string,
5039: 'Elg:') = 0 then
5040: --
5041: ben_manage_life_events.g_output_string :=
5042: ben_manage_life_events.g_output_string||
5043: 'Elg: Yes '||
5044: 'Rsn: Prev InElig';
5045: --

Line 5042: ben_manage_life_events.g_output_string||

5038: if instr(ben_manage_life_events.g_output_string,
5039: 'Elg:') = 0 then
5040: --
5041: ben_manage_life_events.g_output_string :=
5042: ben_manage_life_events.g_output_string||
5043: 'Elg: Yes '||
5044: 'Rsn: Prev InElig';
5045: --
5046: end if;

Line 5348: if instr(ben_manage_life_events.g_output_string,

5344: hr_utility.set_location ('newly inelig',121);
5345: --
5346: l_p_object_version_number := l_object_version_number;
5347: --
5348: if instr(ben_manage_life_events.g_output_string,
5349: 'Elg:') = 0 then
5350: --
5351: ben_manage_life_events.g_output_string :=
5352: ben_manage_life_events.g_output_string||

Line 5351: ben_manage_life_events.g_output_string :=

5347: --
5348: if instr(ben_manage_life_events.g_output_string,
5349: 'Elg:') = 0 then
5350: --
5351: ben_manage_life_events.g_output_string :=
5352: ben_manage_life_events.g_output_string||
5353: 'Elg: No '||
5354: 'Rsn: Prev Elig';
5355: --

Line 5352: ben_manage_life_events.g_output_string||

5348: if instr(ben_manage_life_events.g_output_string,
5349: 'Elg:') = 0 then
5350: --
5351: ben_manage_life_events.g_output_string :=
5352: ben_manage_life_events.g_output_string||
5353: 'Elg: No '||
5354: 'Rsn: Prev Elig';
5355: --
5356: end if;

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

5624:
5625: if (l_pl_id is not null or
5626: p_oipl_id is not null or
5627: p_pgm_id is not null) then
5628: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
5629: ben_newly_ineligible.main
5630: (p_person_id => p_person_id,
5631: p_pl_id => l_pl_id,
5632: p_pgm_id => nvl(p_pgm_id,l_envpgm_id),

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

5641: --
5642: end if;
5643: --
5644: if p_ptip_id is not null then
5645: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
5646: for l_rec in c_get_pl_from_ptip(nvl(l_fonm_cvg_strt_dt,p_effective_date)) loop
5647: ben_newly_ineligible.main
5648: (p_person_id => p_person_id,
5649: p_pl_id => l_rec.pl_id,

Line 5664: if instr(ben_manage_life_events.g_output_string,

5660: end if;
5661: elsif l_first_inelig then --c
5662: --
5663: hr_utility.set_location ('first inelig',121);
5664: if instr(ben_manage_life_events.g_output_string,
5665: 'Elg:') = 0 then
5666: --
5667: ben_manage_life_events.g_output_string :=
5668: ben_manage_life_events.g_output_string||

Line 5667: ben_manage_life_events.g_output_string :=

5663: hr_utility.set_location ('first inelig',121);
5664: if instr(ben_manage_life_events.g_output_string,
5665: 'Elg:') = 0 then
5666: --
5667: ben_manage_life_events.g_output_string :=
5668: ben_manage_life_events.g_output_string||
5669: 'Elg: No '||
5670: 'Rsn: FTIME InElig';
5671: --

Line 5668: ben_manage_life_events.g_output_string||

5664: if instr(ben_manage_life_events.g_output_string,
5665: 'Elg:') = 0 then
5666: --
5667: ben_manage_life_events.g_output_string :=
5668: ben_manage_life_events.g_output_string||
5669: 'Elg: No '||
5670: 'Rsn: FTIME InElig';
5671: --
5672: end if;