DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ELIGIBILITY2 dependencies on BENUTILS

Line 176: 20-JUL-99 Gperry 115.39 genutils -> benutils package rename.

172: 11 Jul 99 mhoyes 115.36 - Added new trace messages.
173: - Removed + 0s from all cursors.
174: 12 Jul 99 jcarpent 115.37 - Added checks for backed out nocopy pil.
175: 13 Jul 99 mhoyes 115.38 - Added trace messages.
176: 20-JUL-99 Gperry 115.39 genutils -> benutils package rename.
177: 28-JUL-99 mhoyes 115.40 - Added trace messages.
178: - Removed product join from cursor
179: c_prev_elig_check.
180: 03-AUG-99 jcarpent 115.41 - changed prev_elig_check cursor to

Line 246: 22-May-00 mhoyes 115.65 - Replaced benutils function call to get the

242: start and end dates.
243: - Modified calls to
244: create_Elig_Person_Option to
245: create_perf_Elig_Person_Option.
246: 22-May-00 mhoyes 115.65 - Replaced benutils function call to get the
247: per in ler with a cache call.
248: 22-May-00 mhoyes 115.66 - Reduced cache calls in get start and end
249: dates by using passed in records.
250: 23-May-00 shdas 115.67 - bug5224 call ben_newly_inelig.main if inelig for

Line 287: derived inside benutils.formula.

283: 01-Aug-01 kmahendr 115.82 - Plan not in programs not getting deenrolled on selection
284: mode-bug#1871579. nvl is used to return effective date
285: for least function in 3 places where it was not there before
286: 27-aug-01 tilak 115.83 bug:1949361 jurisdiction code is
287: derived inside benutils.formula.
288: 26-sep-01 tjesumic 115.84 wait_perd_Strt_dt added
289: 19-dec-01 pbodla 115.85 CWB Changes - Look for non comp potential
290: life events when waiting periods are defined.
291: 20-Dec-01 ikasire 115.86 added dbdrv lines

Line 360: benutils.formula in procedure get_start_end_dates

356: to ben_determine_eligibility3.
357: 30-Jan-06 mhoyes 115.118 Bug#4968123 - moved out cursors
358: to ben_determine_eligibility4.
359: 28-Jun-06 swjain 115.119 Bug 5331889 Added person_id param in call to
360: benutils.formula in procedure get_start_end_dates
361: 24-Jul-06 kmahendr 115.120 Bug#5404392-added ben_newly_ineligible call
362: in the case of first time ineligible.
363: 25-aug-06 ssarkar 115.121 bug# 5478994 - passed ler_id to update_perf_eligible_person
364: 11-Dec-06 rgajula 115.122 Bug 5682845 - passed the l_envplipid to the call to ben_pep_Cache.get_pilepo_dets.

Line 447: l_benmngle_parm_rec benutils.g_batch_param_rec;

443: l_envptip_id number;
444: l_envplip_id number;
445: l_envpl_id number;
446: l_env_rec ben_env_object.g_global_env_rec_type;
447: l_benmngle_parm_rec benutils.g_batch_param_rec;
448: --FONM
449: l_fonm_cvg_strt_dt DATE ;
450: --END FONM
451: --

Line 475: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id

471: --
472: -- if the mode is Personnel Action - the participation start date and end date needs to be
473: -- defaulted to Event and 1 day before event
474: ben_env_object.get(p_rec => l_env_rec);
475: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
476: ,p_rec => l_benmngle_parm_rec);
477: if l_benmngle_parm_rec.mode_cd = 'P' then
478: --
479: if p_start_or_end = 'S' then

Line 822: l_outputs := benutils.formula

818: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
819: --
820: end if;
821: --
822: l_outputs := benutils.formula
823: (p_formula_id => l_prtn_eff_strt_dt_rl
824: ,p_effective_date => p_effective_date
825: ,p_business_group_id => p_business_group_id
826: ,p_assignment_id => l_ass_rec.assignment_id

Line 1031: l_outputs := benutils.formula

1027: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
1028: --
1029: end if;
1030: --
1031: l_outputs := benutils.formula
1032: (p_formula_id => l_prtn_eff_end_dt_rl
1033: ,p_effective_date => p_effective_date
1034: ,p_business_group_id => p_business_group_id
1035: ,p_assignment_id => l_ass_rec.assignment_id

Line 1210: l_benmngle_parm_rec benutils.g_batch_param_rec;

1206: --END FONM
1207:
1208: -- iRec
1209: l_env_rec ben_env_object.g_global_env_rec_type;
1210: l_benmngle_parm_rec benutils.g_batch_param_rec;
1211: -- End iRec
1212: /* 4968123
1213: -- Cursor to check previous eligibility for plan/program.
1214: --

Line 1554: benutils.get_batch_parameters( p_benefit_action_id => l_env_rec.benefit_action_id

1550: end if;
1551: --
1552: -- iRec
1553: ben_env_object.get(p_rec => l_env_rec);
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'

Line 1871: benutils.write(p_text => fnd_message.get);

1867: hr_utility.set_location ('oipl first elig',121);
1868: l_first_elig := true;
1869: l_start_or_end := 'S';
1870: fnd_message.set_name ('BEN','BEN_91385_FIRST_ELIG');
1871: benutils.write(p_text => fnd_message.get);
1872: --
1873: else
1874: --
1875: fnd_message.set_name ('BEN','BEN_92533_FIRST_INELIG2');

Line 1876: benutils.write(p_text => fnd_message.get);

1872: --
1873: else
1874: --
1875: fnd_message.set_name ('BEN','BEN_92533_FIRST_INELIG2');
1876: benutils.write(p_text => fnd_message.get);
1877: -- only continue with program and call of api if we want to track
1878: -- inelig people.
1879: l_trk_inelig_per_flag := l_oipl_rec.trk_inelig_per_flag;
1880: --

Line 1916: benutils.write(p_text => fnd_message.get);

1912: --
1913: if l_opt_elig_flag = 'Y' and p_elig_flag then --d
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: --

Line 1940: benutils.write(p_text => fnd_message.get);

1936: hr_utility.set_location ('newly inelig',121);
1937: l_newly_inelig := true;
1938: l_start_or_end := 'E';
1939: fnd_message.set_name('BEN','BEN_91347_NOT_ELIG_PREV_ELIG');
1940: benutils.write(p_text => fnd_message.get);
1941: --
1942: elsif l_opt_elig_flag = 'N' and p_elig_flag = false then --d
1943: -- person is still inelig, do nothing.
1944: fnd_message.set_name('BEN','BEN_91348_NOT_ELIG_PREV_NT_ELG');

Line 1945: benutils.write(p_text => fnd_message.get);

1941: --
1942: elsif l_opt_elig_flag = 'N' and p_elig_flag = false then --d
1943: -- person is still inelig, do nothing.
1944: fnd_message.set_name('BEN','BEN_91348_NOT_ELIG_PREV_NT_ELG');
1945: benutils.write(p_text => fnd_message.get);
1946: --
1947: -- Set transition state for processing only. Elig
1948: -- per is not written
1949: --

Line 2180: benutils.write(p_text => fnd_message.get);

2176: hr_utility.set_location('new elig',23);
2177: l_newly_elig := true;
2178: l_start_or_end := 'S';
2179: fnd_message.set_name('BEN','BEN_91346_ELIG_PREV_NOT_ELIG');
2180: benutils.write(p_text => fnd_message.get);
2181: --
2182: else
2183: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
2184: fnd_message.set_token('FLAG','epo.elig_flag');

Line 4355: benutils.write(p_text => fnd_message.get);

4351: l_first_elig := true;
4352: hr_utility.set_location ('first elig',121);
4353: l_start_or_end := 'S';
4354: fnd_message.set_name ('BEN','BEN_91385_FIRST_ELIG');
4355: benutils.write(p_text => fnd_message.get);
4356: --
4357: else
4358: --
4359: hr_utility.set_location('elig is false ben_determine_eligibility2.check_prev_elig', 10);

Line 4361: benutils.write(p_text => fnd_message.get);

4357: else
4358: --
4359: hr_utility.set_location('elig is false ben_determine_eligibility2.check_prev_elig', 10);
4360: fnd_message.set_name ('BEN','BEN_92533_FIRST_INELIG2');
4361: benutils.write(p_text => fnd_message.get);
4362: --
4363: -- only continue with program and call of api if we want to track
4364: -- inelig people.
4365: --

Line 4448: benutils.write(p_text => fnd_message.get);

4444: hr_utility.set_location ('still elig',121);
4445: -- Person still eligible, do nothing.
4446: --
4447: fnd_message.set_name ('BEN','BEN_91345_ELIG_PREV_ELIG');
4448: benutils.write(p_text => fnd_message.get);
4449: l_start_or_end := 'S';
4450: l_still_elig := true;
4451: --
4452: --return;

Line 4460: benutils.write(p_text => fnd_message.get);

4456: hr_utility.set_location ('newly inelig',121);
4457: l_newly_inelig := true;
4458: l_start_or_end := 'E';
4459: fnd_message.set_name('BEN','BEN_91347_NOT_ELIG_PREV_ELIG');
4460: benutils.write(p_text => fnd_message.get);
4461: --
4462: elsif l_elig_per_elig_flag = 'N' and p_elig_flag = false then --d
4463: -- person is still inelig, do nothing.
4464: fnd_message.set_name('BEN','BEN_91348_NOT_ELIG_PREV_NT_ELG');

Line 4465: benutils.write(p_text => fnd_message.get);

4461: --
4462: elsif l_elig_per_elig_flag = 'N' and p_elig_flag = false then --d
4463: -- person is still inelig, do nothing.
4464: fnd_message.set_name('BEN','BEN_91348_NOT_ELIG_PREV_NT_ELG');
4465: benutils.write(p_text => fnd_message.get);
4466: --
4467: -- Set transition state for processing only. Elig
4468: -- per is not written
4469: --

Line 4845: benutils.write(p_text => fnd_message.get);

4841: hr_utility.set_location('new elig',23);
4842: l_newly_elig := true;
4843: l_start_or_end := 'S';
4844: fnd_message.set_name('BEN','BEN_91346_ELIG_PREV_NOT_ELIG');
4845: benutils.write(p_text => fnd_message.get);
4846: --
4847: else
4848: --
4849: fnd_message.set_name('BEN','BEN_91392_ELIG_FLAG_ERROR');