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_MANAGE_LIFE_EVENTS dependencies on BENUTILS

Line 297: benutils.formula.

293: 23-APR-99 GPerry 115.83 Added p_mode to evaluate life
294: event call.
295: 22-APR-99 mhoyes 115.84 Modified per in ler calls.
296: 29-APR-99 shdas 115.85 Added to parameter list of
297: benutils.formula.
298: 06-May-99 TGuy 115.86 uncommented rate change call
299: 06-MAY-99 shdas 115.87 Added jurisdiction_code.
300: 06-May-99 bbulusu 115.89 Added original_hire_date to the
301: person cache.

Line 362: 20-JUL-99 GPerry 115.118 genutils -> benutils package rename

358: check for enrd_perd_for_pl by
359: business_group_id. Also, do
360: not call actual premium if
361: no choices are created.
362: 20-JUL-99 GPerry 115.118 genutils -> benutils package rename
363: 26-JUL-99 GPerry 115.119 Removed ben_timing stuff.
364: 26-JUL-99 GPerry 115.120 Added calls to dt_fndate.
365: Added call to new
366: create_perf_benefit_actions to

Line 369: benutils package.

365: Added call to new
366: create_perf_benefit_actions to
367: reduce bottleneck.
368: Added call to clear_down_cache in
369: benutils package.
370: 26-JUL-99 GPerry 115.121 Removed setenv for business_group
371: in evaluate_life_events.
372: 27-JUL-99 mhoyes 115.122 - Fixed genutil problems.
373: 29-JUL-99 mhoyes 115.123 - Assigned globals to locals in

Line 376: - Modified references to benutils.

372: 27-JUL-99 mhoyes 115.122 - Fixed genutil problems.
373: 29-JUL-99 mhoyes 115.123 - Assigned globals to locals in
374: process_comp_objects.
375: - Added new trace messages.
376: - Modified references to benutils.
377: to bentype.
378: 10-AUG-99 Gperry 115.124 Removed global references to
379: g_cache_person and the like.
380: Rewrote person_header.

Line 1107: 06-Aug-07 rtagarra 115.415 Bug 6321565 : For 'R' mode corrected the if condition to call benutils.get_ler.

1103: 16-Nov-06 maagrawa 115.411 5666180. Remove the cwb check (c7)
1104: which prevented plan with only one
1105: salary component.
1106: 22-Jan-07 rtagarra 115.412 ICM Changes.
1107: 06-Aug-07 rtagarra 115.415 Bug 6321565 : For 'R' mode corrected the if condition to call benutils.get_ler.
1108: 04-Dec-07 krupani 115.419 Incorporated changes of defer deenrollment, Bug 6519622, Bug 6373951,
1109: Bug 6373951 and Bug 6390880 from branchline to mainline
1110: 10-Mar-08 krupani 115.421 Bug 6404338. Min Max enhancement incorporated in R12 mainline
1111: 12-Aug-08 pvelugul 120.28.12010000.2 Bug 6872010: Cleared global variables

Line 1184: benutils.g_benefit_action_id := p_benefit_action_id;

1180: g_fonm_rt_strt_dt := null;
1181: -- bug 6872010
1182:
1183: flush_global_structures;
1184: benutils.g_benefit_action_id := p_benefit_action_id;
1185: benutils.g_thread_id := p_thread_id;
1186: --
1187: -- Initialise comp object list globals
1188: --

Line 1185: benutils.g_thread_id := p_thread_id;

1181: -- bug 6872010
1182:
1183: flush_global_structures;
1184: benutils.g_benefit_action_id := p_benefit_action_id;
1185: benutils.g_thread_id := p_thread_id;
1186: --
1187: -- Initialise comp object list globals
1188: --
1189: ben_comp_object_list.init_comp_object_list_globals;

Line 1299: l_rec benutils.g_active_life_event;

1295: -- p_popl_enrt_typ_cycl_id in number) is
1296: --
1297: l_package varchar2(80) := g_package||'.check_business_rules';
1298: l_dummy varchar2(1);
1299: l_rec benutils.g_active_life_event;
1300: l_ler_rec benutils.g_ler;
1301: l_effective_start_date date;
1302: l_effective_end_date date;
1303: l_ptnl_ler_for_per_id number;

Line 1300: l_ler_rec benutils.g_ler;

1296: --
1297: l_package varchar2(80) := g_package||'.check_business_rules';
1298: l_dummy varchar2(1);
1299: l_rec benutils.g_active_life_event;
1300: l_ler_rec benutils.g_ler;
1301: l_effective_start_date date;
1302: l_effective_end_date date;
1303: l_ptnl_ler_for_per_id number;
1304: l_object_version_number number;

Line 2737: benutils.write(p_text => benutils.g_banner_minus);

2733: l_package := g_package||'.write_logfile';
2734: hr_utility.set_location ('Entering '||l_package,10);
2735: end if;
2736: --
2737: benutils.write(p_text => benutils.g_banner_minus);
2738: benutils.write(p_text => 'Benefits Statistical Information');
2739: benutils.write(p_text => benutils.g_banner_minus);
2740: benutils.write(p_text => 'Processed persons '||p_person_count);
2741: benutils.write(p_text => 'Errored persons '||p_error_person_count);

Line 2738: benutils.write(p_text => 'Benefits Statistical Information');

2734: hr_utility.set_location ('Entering '||l_package,10);
2735: end if;
2736: --
2737: benutils.write(p_text => benutils.g_banner_minus);
2738: benutils.write(p_text => 'Benefits Statistical Information');
2739: benutils.write(p_text => benutils.g_banner_minus);
2740: benutils.write(p_text => 'Processed persons '||p_person_count);
2741: benutils.write(p_text => 'Errored persons '||p_error_person_count);
2742: benutils.write(p_text => benutils.g_banner_minus);

Line 2739: benutils.write(p_text => benutils.g_banner_minus);

2735: end if;
2736: --
2737: benutils.write(p_text => benutils.g_banner_minus);
2738: benutils.write(p_text => 'Benefits Statistical Information');
2739: benutils.write(p_text => benutils.g_banner_minus);
2740: benutils.write(p_text => 'Processed persons '||p_person_count);
2741: benutils.write(p_text => 'Errored persons '||p_error_person_count);
2742: benutils.write(p_text => benutils.g_banner_minus);
2743: --

Line 2740: benutils.write(p_text => 'Processed persons '||p_person_count);

2736: --
2737: benutils.write(p_text => benutils.g_banner_minus);
2738: benutils.write(p_text => 'Benefits Statistical Information');
2739: benutils.write(p_text => benutils.g_banner_minus);
2740: benutils.write(p_text => 'Processed persons '||p_person_count);
2741: benutils.write(p_text => 'Errored persons '||p_error_person_count);
2742: benutils.write(p_text => benutils.g_banner_minus);
2743: --
2744: benutils.write_table_and_file(p_table => true,

Line 2741: benutils.write(p_text => 'Errored persons '||p_error_person_count);

2737: benutils.write(p_text => benutils.g_banner_minus);
2738: benutils.write(p_text => 'Benefits Statistical Information');
2739: benutils.write(p_text => benutils.g_banner_minus);
2740: benutils.write(p_text => 'Processed persons '||p_person_count);
2741: benutils.write(p_text => 'Errored persons '||p_error_person_count);
2742: benutils.write(p_text => benutils.g_banner_minus);
2743: --
2744: benutils.write_table_and_file(p_table => true,
2745: p_file => true);

Line 2742: benutils.write(p_text => benutils.g_banner_minus);

2738: benutils.write(p_text => 'Benefits Statistical Information');
2739: benutils.write(p_text => benutils.g_banner_minus);
2740: benutils.write(p_text => 'Processed persons '||p_person_count);
2741: benutils.write(p_text => 'Errored persons '||p_error_person_count);
2742: benutils.write(p_text => benutils.g_banner_minus);
2743: --
2744: benutils.write_table_and_file(p_table => true,
2745: p_file => true);
2746: commit;

Line 2744: benutils.write_table_and_file(p_table => true,

2740: benutils.write(p_text => 'Processed persons '||p_person_count);
2741: benutils.write(p_text => 'Errored persons '||p_error_person_count);
2742: benutils.write(p_text => benutils.g_banner_minus);
2743: --
2744: benutils.write_table_and_file(p_table => true,
2745: p_file => true);
2746: commit;
2747: --
2748: if g_debug then

Line 2756: benutils.write(fnd_message.get);

2752: exception
2753: --
2754: --
2755: when table_full then
2756: benutils.write(fnd_message.get);
2757: fnd_message.raise_error;
2758: when index_full then
2759: benutils.write(fnd_message.get);
2760: fnd_message.raise_error;

Line 2759: benutils.write(fnd_message.get);

2755: when table_full then
2756: benutils.write(fnd_message.get);
2757: fnd_message.raise_error;
2758: when index_full then
2759: benutils.write(fnd_message.get);
2760: fnd_message.raise_error;
2761: --
2762: when others then
2763: --

Line 2765: benutils.write(fnd_message.get);

2761: --
2762: when others then
2763: --
2764: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
2765: benutils.write(fnd_message.get);
2766: fnd_message.raise_error;
2767: --
2768: end write_logfile;
2769: --

Line 2783: benutils.clear_down_cache;

2779: hr_utility.set_location ('Entering '||l_package,10);
2780: end if;
2781: --
2782: g_cache_person_process.delete;
2783: benutils.clear_down_cache;
2784: benutils.g_batch_param_table_object.delete;
2785: ben_elig_rl_cache.clear_down_cache;
2786: ben_location_object.clear_down_cache;
2787: ben_org_object.clear_down_cache;

Line 2784: benutils.g_batch_param_table_object.delete;

2780: end if;
2781: --
2782: g_cache_person_process.delete;
2783: benutils.clear_down_cache;
2784: benutils.g_batch_param_table_object.delete;
2785: ben_elig_rl_cache.clear_down_cache;
2786: ben_location_object.clear_down_cache;
2787: ben_org_object.clear_down_cache;
2788: ben_life_object.clear_down_cache;

Line 2814: l_rec benutils.g_batch_param_rec;

2810: procedure print_parameters
2811: (p_benefit_action_id in number) is
2812: --
2813: l_package varchar2(80);
2814: l_rec benutils.g_batch_param_rec;
2815: -- added bug: 5618436
2816: CURSOR c_conc_pgm_name is
2817: SELECT fcp.concurrent_program_name
2818: FROM ben_benefit_actions bft, fnd_concurrent_programs fcp

Line 2838: benutils.get_batch_parameters

2834: if fnd_global.conc_request_id = -1 then
2835: return;
2836: end if;
2837: --
2838: benutils.get_batch_parameters
2839: (p_benefit_action_id => p_benefit_action_id,
2840: p_rec => l_rec);
2841: --
2842: fnd_file.put_line(which => fnd_file.log,

Line 2878: benutils.iftrue

2874: buff => 'Business Group ID :'||
2875: l_rec.business_group_id);
2876: fnd_file.put_line(which => fnd_file.log,
2877: buff => 'Program ID :'||
2878: benutils.iftrue
2879: (p_expression => l_rec.pgm_id is null,
2880: p_true => 'All',
2881: p_false => l_rec.pgm_id));
2882: fnd_file.put_line(which => fnd_file.log,

Line 2884: benutils.iftrue

2880: p_true => 'All',
2881: p_false => l_rec.pgm_id));
2882: fnd_file.put_line(which => fnd_file.log,
2883: buff => 'Plan ID :'||
2884: benutils.iftrue
2885: (p_expression => l_rec.pl_id is null,
2886: p_true => 'All',
2887: p_false => l_rec.pl_id));
2888: fnd_file.put_line(which => fnd_file.log,

Line 2890: benutils.iftrue

2886: p_true => 'All',
2887: p_false => l_rec.pl_id));
2888: fnd_file.put_line(which => fnd_file.log,
2889: buff => 'Plan Type ID :'||
2890: benutils.iftrue
2891: (p_expression => l_rec.pl_typ_id is null,
2892: p_true => 'All',
2893: p_false => l_rec.pl_typ_id));
2894: fnd_file.put_line(which => fnd_file.log,

Line 2896: benutils.iftrue

2892: p_true => 'All',
2893: p_false => l_rec.pl_typ_id));
2894: fnd_file.put_line(which => fnd_file.log,
2895: buff => 'Option ID :'||
2896: benutils.iftrue
2897: (p_expression => l_rec.opt_id is null,
2898: p_true => 'All',
2899: p_false => l_rec.opt_id));
2900: --

Line 2907: benutils.iftrue

2903: --
2904: /*
2905: fnd_file.put_line(which => fnd_file.log,
2906: buff => 'Enrollment Type Cycle :'||
2907: benutils.iftrue
2908: (p_expression => l_rec.popl_enrt_typ_cycl_id is null,
2909: p_true => 'All',
2910: p_false => l_rec.popl_enrt_typ_cycl_id));
2911: */

Line 2920: benutils.iftrue

2916: buff => 'Just Programs :'||
2917: hr_general.decode_lookup('YES_NO',l_rec.no_plans_flag));
2918: fnd_file.put_line(which => fnd_file.log,
2919: buff => 'Reporting Group :'||
2920: benutils.iftrue
2921: (p_expression => l_rec.rptg_grp_id is null,
2922: p_true => 'All',
2923: p_false => l_rec.rptg_grp_id));
2924: fnd_file.put_line(which => fnd_file.log,

Line 2926: benutils.iftrue

2922: p_true => 'All',
2923: p_false => l_rec.rptg_grp_id));
2924: fnd_file.put_line(which => fnd_file.log,
2925: buff => 'Eligiblity Profile :'||
2926: benutils.iftrue
2927: (p_expression => l_rec.eligy_prfl_id is null,
2928: p_true => 'All',
2929: p_false => l_rec.eligy_prfl_id));
2930: fnd_file.put_line(which => fnd_file.log,

Line 2932: benutils.iftrue

2928: p_true => 'All',
2929: p_false => l_rec.eligy_prfl_id));
2930: fnd_file.put_line(which => fnd_file.log,
2931: buff => 'Variable Rate Profile :'||
2932: benutils.iftrue
2933: (p_expression => l_rec.vrbl_rt_prfl_id is null,
2934: p_true => 'All',
2935: p_false => l_rec.vrbl_rt_prfl_id));
2936: fnd_file.put_line(which => fnd_file.log,

Line 2938: benutils.iftrue

2934: p_true => 'All',
2935: p_false => l_rec.vrbl_rt_prfl_id));
2936: fnd_file.put_line(which => fnd_file.log,
2937: buff => 'Person Selection Rule :'||
2938: benutils.iftrue
2939: (p_expression => l_rec.person_selection_rl is null,
2940: p_true => 'None',
2941: p_false => l_rec.person_selection_rl));
2942: fnd_file.put_line(which => fnd_file.log,

Line 2944: benutils.iftrue

2940: p_true => 'None',
2941: p_false => l_rec.person_selection_rl));
2942: fnd_file.put_line(which => fnd_file.log,
2943: buff => 'Comp Object Selection Rule :'||
2944: benutils.iftrue
2945: (p_expression => l_rec.comp_selection_rl is null,
2946: p_true => 'None',
2947: p_false => l_rec.comp_selection_rl));
2948: --

Line 2972: l_rec benutils.g_batch_param_rec;

2968: l_business_group_id number ;
2969: l_pl_id number;
2970: l_lf_evt_ocrd_dt date;
2971: l_ler_id number;
2972: l_rec benutils.g_batch_param_rec;
2973: lv_pl_id number;
2974: lv_business_group_id number;
2975: lv_ler_id number;
2976: lv_lf_evt_ocrd_dt date;

Line 3229: if benutils.g_benefit_action_id is not null then

3225: --
3226: lv_pl_id := -1;
3227: lv_lf_evt_ocrd_dt := hr_api.g_eot;
3228: --
3229: if benutils.g_benefit_action_id is not null then
3230: --
3231: benutils.get_batch_parameters
3232: (p_benefit_action_id => benutils.g_benefit_action_id,
3233: p_rec => l_rec);

Line 3231: benutils.get_batch_parameters

3227: lv_lf_evt_ocrd_dt := hr_api.g_eot;
3228: --
3229: if benutils.g_benefit_action_id is not null then
3230: --
3231: benutils.get_batch_parameters
3232: (p_benefit_action_id => benutils.g_benefit_action_id,
3233: p_rec => l_rec);
3234: --
3235: lv_pl_id := l_rec.pl_id;

Line 3232: (p_benefit_action_id => benutils.g_benefit_action_id,

3228: --
3229: if benutils.g_benefit_action_id is not null then
3230: --
3231: benutils.get_batch_parameters
3232: (p_benefit_action_id => benutils.g_benefit_action_id,
3233: p_rec => l_rec);
3234: --
3235: lv_pl_id := l_rec.pl_id;
3236: lv_lf_evt_ocrd_dt := l_rec.lf_evt_ocrd_dt;

Line 3420: l_rec benutils.g_batch_param_rec;

3416: l_business_group_id number ;
3417: l_pl_id number;
3418: l_lf_evt_ocrd_dt date;
3419: l_ler_id number;
3420: l_rec benutils.g_batch_param_rec;
3421: lv_pl_id number;
3422: lv_business_group_id number;
3423: lv_ler_id number;
3424: lv_lf_evt_ocrd_dt date;

Line 3653: if benutils.g_benefit_action_id is not null then

3649: --
3650: lv_pl_id := -1;
3651: lv_lf_evt_ocrd_dt := hr_api.g_eot;
3652: --
3653: if benutils.g_benefit_action_id is not null then
3654: --
3655: benutils.get_batch_parameters
3656: (p_benefit_action_id => benutils.g_benefit_action_id,
3657: p_rec => l_rec);

Line 3655: benutils.get_batch_parameters

3651: lv_lf_evt_ocrd_dt := hr_api.g_eot;
3652: --
3653: if benutils.g_benefit_action_id is not null then
3654: --
3655: benutils.get_batch_parameters
3656: (p_benefit_action_id => benutils.g_benefit_action_id,
3657: p_rec => l_rec);
3658: --
3659: lv_pl_id := l_rec.pl_id;

Line 3656: (p_benefit_action_id => benutils.g_benefit_action_id,

3652: --
3653: if benutils.g_benefit_action_id is not null then
3654: --
3655: benutils.get_batch_parameters
3656: (p_benefit_action_id => benutils.g_benefit_action_id,
3657: p_rec => l_rec);
3658: --
3659: lv_pl_id := l_rec.pl_id;
3660: lv_lf_evt_ocrd_dt := l_rec.lf_evt_ocrd_dt;

Line 3818: l_rec benutils.g_active_life_event;

3814: ) is
3815: --
3816: l_package varchar2(80);
3817: --
3818: l_rec benutils.g_active_life_event;
3819: l_mgr_rec benutils.g_active_life_event;
3820: l_mgr_rec_temp benutils.g_active_life_event;
3821: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
3822: l_procd_dt date;

Line 3819: l_mgr_rec benutils.g_active_life_event;

3815: --
3816: l_package varchar2(80);
3817: --
3818: l_rec benutils.g_active_life_event;
3819: l_mgr_rec benutils.g_active_life_event;
3820: l_mgr_rec_temp benutils.g_active_life_event;
3821: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
3822: l_procd_dt date;
3823: l_strtd_dt date;

Line 3820: l_mgr_rec_temp benutils.g_active_life_event;

3816: l_package varchar2(80);
3817: --
3818: l_rec benutils.g_active_life_event;
3819: l_mgr_rec benutils.g_active_life_event;
3820: l_mgr_rec_temp benutils.g_active_life_event;
3821: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
3822: l_procd_dt date;
3823: l_strtd_dt date;
3824: l_voidd_dt date;

Line 3945: benutils.get_active_life_event

3941: l_package := g_package||'.popu_cross_gb_epe_data';
3942: hr_utility.set_location ('Entering '||l_package,10);
3943: end if;
3944: --
3945: benutils.get_active_life_event
3946: (p_person_id => p_person_id,
3947: p_business_group_id => p_business_group_id,
3948: p_effective_date => p_effective_date,
3949: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 3970: benutils.get_active_life_event

3966: -- Get per in ler for manager in per_business_group_id.
3967: --
3968: l_mgr_rec := l_mgr_rec_temp;
3969: --
3970: benutils.get_active_life_event
3971: (p_person_id => l_mgr_person_id,
3972: p_business_group_id => l_curr_pel.per_business_group_id,
3973: p_effective_date => p_effective_date,
3974: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 4360: l_rec benutils.g_active_life_event;

4356: ) is
4357: --
4358: l_package varchar2(80);
4359: --
4360: l_rec benutils.g_active_life_event;
4361: l_mgr_rec benutils.g_active_life_event;
4362: l_mgr_rec_temp benutils.g_active_life_event;
4363: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
4364: l_procd_dt date;

Line 4361: l_mgr_rec benutils.g_active_life_event;

4357: --
4358: l_package varchar2(80);
4359: --
4360: l_rec benutils.g_active_life_event;
4361: l_mgr_rec benutils.g_active_life_event;
4362: l_mgr_rec_temp benutils.g_active_life_event;
4363: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
4364: l_procd_dt date;
4365: l_strtd_dt date;

Line 4362: l_mgr_rec_temp benutils.g_active_life_event;

4358: l_package varchar2(80);
4359: --
4360: l_rec benutils.g_active_life_event;
4361: l_mgr_rec benutils.g_active_life_event;
4362: l_mgr_rec_temp benutils.g_active_life_event;
4363: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
4364: l_procd_dt date;
4365: l_strtd_dt date;
4366: l_voidd_dt date;

Line 4452: benutils.get_active_life_event

4448: l_package := g_package||'.popu_cross_gb_epe_data';
4449: hr_utility.set_location ('Entering '||l_package,10);
4450: end if;
4451: --
4452: benutils.get_active_life_event
4453: (p_person_id => p_person_id,
4454: p_business_group_id => p_business_group_id,
4455: p_effective_date => p_effective_date,
4456: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 4483: benutils.get_active_life_event

4479: -- Get per in ler for manager in per_business_group_id.
4480: --
4481: l_mgr_rec := l_mgr_rec_temp;
4482: --
4483: benutils.get_active_life_event
4484: (p_person_id => l_mgr_person_id,
4485: p_business_group_id => l_curr_epe.per_business_group_id,
4486: p_effective_date => p_effective_date,
4487: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 5275: benutils.write_table_and_file(p_table => true,

5271: */
5272: if g_debug then
5273: hr_utility.set_location (l_package||' Write TAF ',20);
5274: end if;
5275: benutils.write_table_and_file(p_table => true,
5276: p_file => true);
5277: commit;
5278: --
5279: if g_debug then

Line 5728: l_ler_rec benutils.g_ler;

5724: l_max_errors number;
5725: l_commit number;
5726: l_slave_errored boolean := false;
5727: --
5728: l_ler_rec benutils.g_ler;
5729: --
5730: begin
5731: --
5732: g_debug := hr_utility.debug_enabled;

Line 5752: benutils.get_ler

5748: */
5749: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
5750: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
5751: --
5752: benutils.get_ler
5753: (p_business_group_id => p_business_group_id
5754: ,p_typ_cd => 'SCHEDDU'
5755: ,p_effective_date => l_effective_date
5756: ,p_rec => l_ler_rec

Line 5767: benutils.get_ler (p_business_group_id => p_business_group_id,

5763: if p_mode = 'I' then
5764: --
5765: -- Set G_LER_ID to iRecruitment LER_ID for subsequent use in ben_evaluate_ptnl_lf_evt
5766: --
5767: benutils.get_ler (p_business_group_id => p_business_group_id,
5768: p_typ_cd => 'IREC',
5769: p_effective_date => l_effective_date,
5770: p_rec => l_ler_rec
5771: );

Line 5777: benutils.get_parameter

5773: g_ler_id := l_ler_rec.ler_id;
5774: --
5775: end if;
5776: -- iRec
5777: benutils.get_parameter
5778: (p_business_group_id => p_business_group_id,
5779: p_batch_exe_cd => 'BENMNGLE',
5780: p_threads => l_threads,
5781: p_chunk_size => l_chunk_size,

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

5979: when g_record_error then
5980: if g_debug then
5981: hr_utility.set_location (l_package||' Exception g_record_error ',50);
5982: end if;
5983: benutils.write(p_text => fnd_message.get);
5984: --
5985: -- Write the last bit of information for the thread
5986: --
5987: benutils.write_table_and_file(p_table => true,

Line 5987: benutils.write_table_and_file(p_table => true,

5983: benutils.write(p_text => fnd_message.get);
5984: --
5985: -- Write the last bit of information for the thread
5986: --
5987: benutils.write_table_and_file(p_table => true,
5988: p_file => true);
5989: commit;
5990: --
5991: -- Output log information to log file

Line 6021: benutils.write(p_rec => g_rec);

6017: g_rec.text := nvl(fnd_message.get,sqlerrm);
6018: if g_debug then
6019: hr_utility.set_location(substr(g_rec.text,1,100),10);
6020: end if;
6021: benutils.write(p_rec => g_rec);
6022: --
6023: -- Output log information to log file
6024: --
6025: write_logfile(p_benefit_action_id => p_benefit_action_id,

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

6040: --
6041: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');
6042: fnd_message.set_token('ORA_ERRCODE',SQLCODE);
6043: --
6044: benutils.write(p_text => fnd_message.get);
6045: benutils.write_table_and_file(p_table => true,
6046: p_file => true);
6047: commit;
6048: if g_debug then

Line 6045: benutils.write_table_and_file(p_table => true,

6041: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');
6042: fnd_message.set_token('ORA_ERRCODE',SQLCODE);
6043: --
6044: benutils.write(p_text => fnd_message.get);
6045: benutils.write_table_and_file(p_table => true,
6046: p_file => true);
6047: commit;
6048: if g_debug then
6049: hr_utility.set_location ('Others error '||l_package,100);

Line 7491: l_ler_rec benutils.g_ler;

7487: l_num_ranges number := 0;
7488: l_num_persons number := 0;
7489: l_person_action_id number;
7490: l_range_id number;
7491: l_ler_rec benutils.g_ler;
7492: l_retcode number;
7493: l_errbuf varchar2(1000);
7494: l_no_one_to_process exception; -- Bug 3870204
7495: -- iRec

Line 7621: benutils.get_ler

7617: --
7618: -- Get ler_id for Unrestricted Mode and store it in globle variable so that procedures down the road can
7619: -- access it
7620: --
7621: benutils.get_ler
7622: (p_business_group_id => p_business_group_id,
7623: p_typ_cd => 'SCHEDDU',
7624: p_effective_date => l_effective_date,
7625: p_rec => l_ler_rec);

Line 7634: benutils.get_ler (p_business_group_id => p_business_group_id,

7630: if p_mode = 'I' then
7631: --
7632: -- Set G_LER_ID to iRecruitment LER_ID for subsequent use in ben_evaluate_ptnl_lf_evt
7633: --
7634: benutils.get_ler (p_business_group_id => p_business_group_id,
7635: p_typ_cd => 'IREC',
7636: p_effective_date => l_effective_date,
7637: p_rec => l_ler_rec
7638: );

Line 7678: benutils.get_ler

7674: -- Get ler id for unrestricted
7675: --
7676: if p_mode in ('U','D') then
7677: --
7678: benutils.get_ler
7679: (p_business_group_id => p_business_group_id,
7680: p_typ_cd => 'SCHEDDU',
7681: p_effective_date => l_effective_date,
7682: p_rec => l_ler_rec);

Line 7687: hr_utility.set_location (l_package||' benutils.get_ler ',30);

7683: --
7684: l_ler_override_id := l_ler_rec.ler_id;
7685: --
7686: if g_debug then
7687: hr_utility.set_location (l_package||' benutils.get_ler ',30);
7688: end if;
7689: --
7690: end if;
7691: /*

Line 7697: benutils.get_ler

7693: -- Get ler id for Grade/Step
7694: --
7695: if p_mode = 'G' then
7696: --
7697: benutils.get_ler
7698: (p_business_group_id => p_business_group_id,
7699: p_typ_cd => 'GSP',
7700: p_effective_date => l_effective_date,
7701: p_rec => l_ler_rec);

Line 7706: hr_utility.set_location (l_package||' benutils.get_ler ',31);

7702: --
7703: l_ler_override_id := l_ler_rec.ler_id;
7704: --
7705: if g_debug then
7706: hr_utility.set_location (l_package||' benutils.get_ler ',31);
7707: end if;
7708: end if;
7709: */
7710: --

Line 7719: benutils.get_parameter(p_business_group_id => p_business_group_id,

7715: hr_utility.set_location (l_package||' get_parameter',20);
7716: end if;
7717: /* Start: CWB Thread Num Enhancement */
7718: if(p_mode = 'W') then
7719: benutils.get_parameter(p_business_group_id => p_business_group_id,
7720: p_batch_exe_cd => 'BENGCMOD',
7721: p_threads => l_threads,
7722: p_chunk_size => l_chunk_size,
7723: p_max_errors => l_max_errors);

Line 7725: benutils.get_parameter(p_business_group_id => p_business_group_id,

7721: p_threads => l_threads,
7722: p_chunk_size => l_chunk_size,
7723: p_max_errors => l_max_errors);
7724: else
7725: benutils.get_parameter(p_business_group_id => p_business_group_id,
7726: p_batch_exe_cd => 'BENMNGLE',
7727: p_threads => l_threads,
7728: p_chunk_size => l_chunk_size,
7729: p_max_errors => l_max_errors);

Line 7741: benutils.g_benefit_action_id := l_benefit_action_id; -- Bug 3870204

7737: hr_utility.set_location('Max Errors = '||l_max_errors,10);
7738: --
7739: end if;
7740: --
7741: benutils.g_benefit_action_id := l_benefit_action_id; -- Bug 3870204
7742: --
7743: -- Create benefit actions parameters in the benefit action table.
7744: -- Do not create if a benefit action already exists, in other words
7745: -- we are doing a restart.

Line 7826: benutils.g_benefit_action_id := l_benefit_action_id; -- Bug 3870204

7822: p_concat_segs => p_concat_segs
7823: -- end 2940151
7824: );
7825: --
7826: benutils.g_benefit_action_id := l_benefit_action_id; -- Bug 3870204
7827: --
7828: if g_debug then
7829: hr_utility.set_location (l_package||' Dn Create BFT ',20);
7830: end if;

Line 7925: benutils.get_ler

7921: end if;
7922: --
7923: elsif p_mode in ('U','D') then
7924: --
7925: benutils.get_ler
7926: (p_business_group_id => p_business_group_id,
7927: p_typ_cd => 'SCHEDDU',
7928: p_effective_date => l_effective_date,
7929: p_rec => l_ler_rec);

Line 8115: benutils.g_benefit_action_id := l_benefit_action_id;

8111: end if;
8112: --
8113: -- Prasad special case
8114: --
8115: benutils.g_benefit_action_id := l_benefit_action_id;
8116: p_benefit_action_id := l_benefit_action_id;
8117: --
8118: /* GLOBALCWB : The issue of track ineligible flag have to be addressed
8119: later after drop 3, currently it has no meaning

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

8188: --
8189: exception
8190: -- Bug 3870204
8191: when l_no_one_to_process then
8192: benutils.write(p_text => fnd_message.get);
8193: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
8194: rollback;
8195: end internal_process;
8196: --

Line 8193: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

8189: exception
8190: -- Bug 3870204
8191: when l_no_one_to_process then
8192: benutils.write(p_text => fnd_message.get);
8193: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
8194: rollback;
8195: end internal_process;
8196: --
8197: procedure process

Line 8383: benutils.id(p_oipl_id);

8379: p_oipl_id => p_oipl_id);
8380: ben_comp_object.get_object(p_rec => l_opt_rec,
8381: p_opt_id => l_oipl_rec.opt_id);
8382: p_comp_object_name := rpad(substr(l_opt_rec.name,1,18),18,' ')||
8383: benutils.id(p_oipl_id);
8384: --
8385: elsif p_pl_id is not null then
8386: --
8387: -- Test if plan is in program or not

Line 8402: benutils.id(p_pl_id);

8398: --
8399: ben_comp_object.get_object(p_rec => l_pl_rec,
8400: p_pl_id => p_pl_id);
8401: p_comp_object_name := rpad(substr(l_pl_rec.name,1,18),18,' ')||
8402: benutils.id(p_pl_id);
8403: --
8404: elsif p_pgm_id is not null then
8405: --
8406: p_comp_object_value := g_cache_comp_objects.pgm;

Line 8411: benutils.id(p_pgm_id);

8407: --
8408: ben_comp_object.get_object(p_rec => l_pgm_rec,
8409: p_pgm_id => p_pgm_id);
8410: p_comp_object_name := rpad(substr(l_pgm_rec.name,1,18),18,' ')||
8411: benutils.id(p_pgm_id);
8412: --
8413: elsif p_plip_id is not null then
8414: --
8415: p_comp_object_value := g_cache_comp_objects.plip;

Line 8418: benutils.id(p_plip_id);

8414: --
8415: p_comp_object_value := g_cache_comp_objects.plip;
8416: --
8417: p_comp_object_name := rpad('Plip',15,' ')||
8418: benutils.id(p_plip_id);
8419: --
8420: elsif p_ptip_id is not null then
8421: --
8422: p_comp_object_value := g_cache_comp_objects.ptip;

Line 8425: benutils.id(p_ptip_id);

8421: --
8422: p_comp_object_value := g_cache_comp_objects.ptip;
8423: --
8424: p_comp_object_name := rpad('Ptip',15,' ')||
8425: benutils.id(p_ptip_id);
8426: --
8427: end if;
8428: --
8429: if g_debug then

Line 8630: benutils.write(p_text => benutils.g_banner_asterix);

8626: --
8627: ben_org_object.get_object(p_business_group_id => p_business_group_id,
8628: p_rec => l_bus_rec);
8629: --
8630: benutils.write(p_text => benutils.g_banner_asterix);
8631: l_output_string := 'Name: '||
8632: substr(l_per_rec.full_name,1,45)||
8633: benutils.id(p_person_id);
8634: benutils.write(p_text => l_output_string);

Line 8633: benutils.id(p_person_id);

8629: --
8630: benutils.write(p_text => benutils.g_banner_asterix);
8631: l_output_string := 'Name: '||
8632: substr(l_per_rec.full_name,1,45)||
8633: benutils.id(p_person_id);
8634: benutils.write(p_text => l_output_string);
8635: l_output_string := ' Typ: '||
8636: substr(l_typ_rec(1).user_person_type,1,45);
8637: --

Line 8634: benutils.write(p_text => l_output_string);

8630: benutils.write(p_text => benutils.g_banner_asterix);
8631: l_output_string := 'Name: '||
8632: substr(l_per_rec.full_name,1,45)||
8633: benutils.id(p_person_id);
8634: benutils.write(p_text => l_output_string);
8635: l_output_string := ' Typ: '||
8636: substr(l_typ_rec(1).user_person_type,1,45);
8637: --
8638: -- loop through the rest of the person_types

Line 8645: benutils.write(l_output_string);

8641: --
8642: l_output_string := rpad(' ',6,' ');
8643: l_output_string := l_output_string||
8644: substr(l_typ_rec(l_count).user_person_type,1,45);
8645: benutils.write(l_output_string);
8646: --
8647: end loop;
8648: l_output_string := 'Grp: '||
8649: substr(l_ben_rec.name,1,45)||

Line 8650: benutils.id(l_per_rec.benefit_group_id);

8646: --
8647: end loop;
8648: l_output_string := 'Grp: '||
8649: substr(l_ben_rec.name,1,45)||
8650: benutils.id(l_per_rec.benefit_group_id);
8651: benutils.write(p_text => l_output_string);
8652: --
8653: l_output_string := 'BG: '||
8654: substr(l_bus_rec.name,1,45)||

Line 8651: benutils.write(p_text => l_output_string);

8647: end loop;
8648: l_output_string := 'Grp: '||
8649: substr(l_ben_rec.name,1,45)||
8650: benutils.id(l_per_rec.benefit_group_id);
8651: benutils.write(p_text => l_output_string);
8652: --
8653: l_output_string := 'BG: '||
8654: substr(l_bus_rec.name,1,45)||
8655: benutils.id(p_business_group_id);

Line 8655: benutils.id(p_business_group_id);

8651: benutils.write(p_text => l_output_string);
8652: --
8653: l_output_string := 'BG: '||
8654: substr(l_bus_rec.name,1,45)||
8655: benutils.id(p_business_group_id);
8656: benutils.write(p_text => l_output_string);
8657: --
8658: l_output_string := 'Org: '||
8659: substr(l_org_rec.name,1,45)||

Line 8656: benutils.write(p_text => l_output_string);

8652: --
8653: l_output_string := 'BG: '||
8654: substr(l_bus_rec.name,1,45)||
8655: benutils.id(p_business_group_id);
8656: benutils.write(p_text => l_output_string);
8657: --
8658: l_output_string := 'Org: '||
8659: substr(l_org_rec.name,1,45)||
8660: benutils.id(l_ass_rec.organization_id);

Line 8660: benutils.id(l_ass_rec.organization_id);

8656: benutils.write(p_text => l_output_string);
8657: --
8658: l_output_string := 'Org: '||
8659: substr(l_org_rec.name,1,45)||
8660: benutils.id(l_ass_rec.organization_id);
8661: benutils.write(p_text => l_output_string);
8662: --
8663: if hr_api.return_legislation_code(p_business_group_id) = 'US'
8664: then

Line 8661: benutils.write(p_text => l_output_string);

8657: --
8658: l_output_string := 'Org: '||
8659: substr(l_org_rec.name,1,45)||
8660: benutils.id(l_ass_rec.organization_id);
8661: benutils.write(p_text => l_output_string);
8662: --
8663: if hr_api.return_legislation_code(p_business_group_id) = 'US'
8664: then
8665: l_output_string := 'Gre: '||

Line 8667: benutils.write(p_text => l_output_string);

8663: if hr_api.return_legislation_code(p_business_group_id) = 'US'
8664: then
8665: l_output_string := 'Gre: '||
8666: substr(l_org2_rec.name,1,45);
8667: benutils.write(p_text => l_output_string);
8668: else
8669: l_output_string := 'Gre: '|| 'Not applicable' ;
8670: benutils.write(p_text => l_output_string);
8671: end if;

Line 8670: benutils.write(p_text => l_output_string);

8666: substr(l_org2_rec.name,1,45);
8667: benutils.write(p_text => l_output_string);
8668: else
8669: l_output_string := 'Gre: '|| 'Not applicable' ;
8670: benutils.write(p_text => l_output_string);
8671: end if;
8672: --
8673: l_output_string := 'Loc: '||
8674: substr(l_loc_rec.address_line_1,1,45)||

Line 8675: benutils.id(l_loc_rec.location_id);

8671: end if;
8672: --
8673: l_output_string := 'Loc: '||
8674: substr(l_loc_rec.address_line_1,1,45)||
8675: benutils.id(l_loc_rec.location_id);
8676: benutils.write(p_text => l_output_string);
8677: --
8678: l_output_string := 'Pst: '||
8679: substr(l_pad_rec.postal_code,1,45);

Line 8676: benutils.write(p_text => l_output_string);

8672: --
8673: l_output_string := 'Loc: '||
8674: substr(l_loc_rec.address_line_1,1,45)||
8675: benutils.id(l_loc_rec.location_id);
8676: benutils.write(p_text => l_output_string);
8677: --
8678: l_output_string := 'Pst: '||
8679: substr(l_pad_rec.postal_code,1,45);
8680: benutils.write(p_text => l_output_string);

Line 8680: benutils.write(p_text => l_output_string);

8676: benutils.write(p_text => l_output_string);
8677: --
8678: l_output_string := 'Pst: '||
8679: substr(l_pad_rec.postal_code,1,45);
8680: benutils.write(p_text => l_output_string);
8681: --
8682: l_output_string := 'Pyr: '||
8683: substr(l_pay_rec.payroll_name,1,45)||
8684: benutils.id(l_pay_rec.payroll_id);

Line 8684: benutils.id(l_pay_rec.payroll_id);

8680: benutils.write(p_text => l_output_string);
8681: --
8682: l_output_string := 'Pyr: '||
8683: substr(l_pay_rec.payroll_name,1,45)||
8684: benutils.id(l_pay_rec.payroll_id);
8685: benutils.write(p_text => l_output_string);
8686: --
8687: if g_debug then
8688: hr_utility.set_location ('Leaving '||l_package,10);

Line 8685: benutils.write(p_text => l_output_string);

8681: --
8682: l_output_string := 'Pyr: '||
8683: substr(l_pay_rec.payroll_name,1,45)||
8684: benutils.id(l_pay_rec.payroll_id);
8685: benutils.write(p_text => l_output_string);
8686: --
8687: if g_debug then
8688: hr_utility.set_location ('Leaving '||l_package,10);
8689: end if;

Line 8837: benutils.WRITE (p_text => benutils.g_banner_asterix);

8833: ben_org_object.get_object (p_business_group_id => p_business_group_id,
8834: p_rec => l_bus_rec
8835: );
8836: --
8837: benutils.WRITE (p_text => benutils.g_banner_asterix);
8838: --
8839: l_output_string :=
8840: 'Name: '
8841: || SUBSTR (l_per_rec.full_name, 1, 45)

Line 8842: || benutils.ID (p_person_id);

8838: --
8839: l_output_string :=
8840: 'Name: '
8841: || SUBSTR (l_per_rec.full_name, 1, 45)
8842: || benutils.ID (p_person_id);
8843: --
8844: benutils.WRITE (p_text => l_output_string);
8845: --
8846: l_output_string :=

Line 8844: benutils.WRITE (p_text => l_output_string);

8840: 'Name: '
8841: || SUBSTR (l_per_rec.full_name, 1, 45)
8842: || benutils.ID (p_person_id);
8843: --
8844: benutils.WRITE (p_text => l_output_string);
8845: --
8846: l_output_string :=
8847: ' Typ: '
8848: || SUBSTR (l_typ_rec (1).user_person_type, 1, 45);

Line 8860: benutils.WRITE (l_output_string);

8856: l_output_string := RPAD (' ', 6, ' ');
8857: l_output_string :=
8858: l_output_string
8859: || SUBSTR (l_typ_rec (l_count).user_person_type, 1, 45);
8860: benutils.WRITE (l_output_string);
8861: --
8862: END LOOP;
8863:
8864: l_output_string :=

Line 8867: || benutils.ID (l_per_rec.benefit_group_id);

8863:
8864: l_output_string :=
8865: 'Grp: '
8866: || SUBSTR (l_ben_rec.NAME, 1, 45)
8867: || benutils.ID (l_per_rec.benefit_group_id);
8868: benutils.WRITE (p_text => l_output_string);
8869: --
8870: l_output_string :=
8871: 'BG: '

Line 8868: benutils.WRITE (p_text => l_output_string);

8864: l_output_string :=
8865: 'Grp: '
8866: || SUBSTR (l_ben_rec.NAME, 1, 45)
8867: || benutils.ID (l_per_rec.benefit_group_id);
8868: benutils.WRITE (p_text => l_output_string);
8869: --
8870: l_output_string :=
8871: 'BG: '
8872: || SUBSTR (l_bus_rec.NAME, 1, 45)

Line 8873: || benutils.ID (p_business_group_id);

8869: --
8870: l_output_string :=
8871: 'BG: '
8872: || SUBSTR (l_bus_rec.NAME, 1, 45)
8873: || benutils.ID (p_business_group_id);
8874: benutils.WRITE (p_text => l_output_string);
8875: --
8876: l_output_string :=
8877: 'Org: '

Line 8874: benutils.WRITE (p_text => l_output_string);

8870: l_output_string :=
8871: 'BG: '
8872: || SUBSTR (l_bus_rec.NAME, 1, 45)
8873: || benutils.ID (p_business_group_id);
8874: benutils.WRITE (p_text => l_output_string);
8875: --
8876: l_output_string :=
8877: 'Org: '
8878: || SUBSTR (l_org_rec.NAME, 1, 45)

Line 8879: || benutils.ID (l_ass_rec.organization_id);

8875: --
8876: l_output_string :=
8877: 'Org: '
8878: || SUBSTR (l_org_rec.NAME, 1, 45)
8879: || benutils.ID (l_ass_rec.organization_id);
8880: benutils.WRITE (p_text => l_output_string);
8881: --
8882: if hr_api.return_legislation_code(p_business_group_id) = 'US'
8883: then

Line 8880: benutils.WRITE (p_text => l_output_string);

8876: l_output_string :=
8877: 'Org: '
8878: || SUBSTR (l_org_rec.NAME, 1, 45)
8879: || benutils.ID (l_ass_rec.organization_id);
8880: benutils.WRITE (p_text => l_output_string);
8881: --
8882: if hr_api.return_legislation_code(p_business_group_id) = 'US'
8883: then
8884: l_output_string := 'Gre: ' || SUBSTR (l_org2_rec.NAME, 1, 45);

Line 8885: benutils.WRITE (p_text => l_output_string);

8881: --
8882: if hr_api.return_legislation_code(p_business_group_id) = 'US'
8883: then
8884: l_output_string := 'Gre: ' || SUBSTR (l_org2_rec.NAME, 1, 45);
8885: benutils.WRITE (p_text => l_output_string);
8886: else
8887: l_output_string := 'Gre: ' || 'Not applicable' ;
8888: benutils.WRITE (p_text => l_output_string);
8889: end if;

Line 8888: benutils.WRITE (p_text => l_output_string);

8884: l_output_string := 'Gre: ' || SUBSTR (l_org2_rec.NAME, 1, 45);
8885: benutils.WRITE (p_text => l_output_string);
8886: else
8887: l_output_string := 'Gre: ' || 'Not applicable' ;
8888: benutils.WRITE (p_text => l_output_string);
8889: end if;
8890: --
8891: l_output_string :=
8892: 'Loc: '

Line 8894: || benutils.ID (l_loc_rec.location_id);

8890: --
8891: l_output_string :=
8892: 'Loc: '
8893: || SUBSTR (l_loc_rec.address_line_1, 1, 45)
8894: || benutils.ID (l_loc_rec.location_id);
8895: benutils.WRITE (p_text => l_output_string);
8896: --
8897: l_output_string := 'Pst: ' || SUBSTR (l_pad_rec.postal_code, 1, 45);
8898: benutils.WRITE (p_text => l_output_string);

Line 8895: benutils.WRITE (p_text => l_output_string);

8891: l_output_string :=
8892: 'Loc: '
8893: || SUBSTR (l_loc_rec.address_line_1, 1, 45)
8894: || benutils.ID (l_loc_rec.location_id);
8895: benutils.WRITE (p_text => l_output_string);
8896: --
8897: l_output_string := 'Pst: ' || SUBSTR (l_pad_rec.postal_code, 1, 45);
8898: benutils.WRITE (p_text => l_output_string);
8899: --

Line 8898: benutils.WRITE (p_text => l_output_string);

8894: || benutils.ID (l_loc_rec.location_id);
8895: benutils.WRITE (p_text => l_output_string);
8896: --
8897: l_output_string := 'Pst: ' || SUBSTR (l_pad_rec.postal_code, 1, 45);
8898: benutils.WRITE (p_text => l_output_string);
8899: --
8900: l_output_string :=
8901: 'Pyr: '
8902: || SUBSTR (l_pay_rec.payroll_name, 1, 45)

Line 8903: || benutils.ID (l_pay_rec.payroll_id);

8899: --
8900: l_output_string :=
8901: 'Pyr: '
8902: || SUBSTR (l_pay_rec.payroll_name, 1, 45)
8903: || benutils.ID (l_pay_rec.payroll_id);
8904: benutils.WRITE (p_text => l_output_string);
8905:
8906: --
8907: IF g_debug

Line 8904: benutils.WRITE (p_text => l_output_string);

8900: l_output_string :=
8901: 'Pyr: '
8902: || SUBSTR (l_pay_rec.payroll_name, 1, 45)
8903: || benutils.ID (l_pay_rec.payroll_id);
8904: benutils.WRITE (p_text => l_output_string);
8905:
8906: --
8907: IF g_debug
8908: THEN

Line 8931: l_ptnl_ler benutils.g_ptnl_ler;

8927: --
8928: l_package varchar2(80);
8929: l_created_ler_id ben_ler_f.ler_id%type := null;
8930: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
8931: l_ptnl_ler benutils.g_ptnl_ler;
8932: l_effective_start_date date;
8933: l_effective_end_date date;
8934: l_rec benutils.g_active_life_event;
8935: l_param_rec benutils.g_batch_param_rec;

Line 8934: l_rec benutils.g_active_life_event;

8930: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
8931: l_ptnl_ler benutils.g_ptnl_ler;
8932: l_effective_start_date date;
8933: l_effective_end_date date;
8934: l_rec benutils.g_active_life_event;
8935: l_param_rec benutils.g_batch_param_rec;
8936: l_ler_rec benutils.g_ler;
8937: l_ler_batch_rec benutils.g_batch_ler_rec;
8938: l_ptnl_ler_for_per_id number;

Line 8935: l_param_rec benutils.g_batch_param_rec;

8931: l_ptnl_ler benutils.g_ptnl_ler;
8932: l_effective_start_date date;
8933: l_effective_end_date date;
8934: l_rec benutils.g_active_life_event;
8935: l_param_rec benutils.g_batch_param_rec;
8936: l_ler_rec benutils.g_ler;
8937: l_ler_batch_rec benutils.g_batch_ler_rec;
8938: l_ptnl_ler_for_per_id number;
8939: l_object_version_number number;

Line 8936: l_ler_rec benutils.g_ler;

8932: l_effective_start_date date;
8933: l_effective_end_date date;
8934: l_rec benutils.g_active_life_event;
8935: l_param_rec benutils.g_batch_param_rec;
8936: l_ler_rec benutils.g_ler;
8937: l_ler_batch_rec benutils.g_batch_ler_rec;
8938: l_ptnl_ler_for_per_id number;
8939: l_object_version_number number;
8940: l_ovn number;

Line 8937: l_ler_batch_rec benutils.g_batch_ler_rec;

8933: l_effective_end_date date;
8934: l_rec benutils.g_active_life_event;
8935: l_param_rec benutils.g_batch_param_rec;
8936: l_ler_rec benutils.g_ler;
8937: l_ler_batch_rec benutils.g_batch_ler_rec;
8938: l_ptnl_ler_for_per_id number;
8939: l_object_version_number number;
8940: l_ovn number;
8941: l_commit number;

Line 8978: l_gsp_ler_rec benutils.g_ler;

8974: l_use_mode varchar2(80);
8975: l_asnd_lf_evt_dt date;
8976: l_cv_ler_id number;
8977: l_cv_lf_evt_ocrd_dt date;
8978: l_gsp_ler_rec benutils.g_ler;
8979: l_validate boolean;
8980: --
8981: begin
8982: --

Line 9015: benutils.get_batch_parameters

9011: -- without this.
9012: ben_env_object.setenv(p_lf_evt_ocrd_dt => p_effective_date);
9013: -- Add ended
9014: --
9015: benutils.get_batch_parameters
9016: (p_benefit_action_id => benutils.g_benefit_action_id
9017: ,p_rec => l_param_rec
9018: );
9019: --

Line 9016: (p_benefit_action_id => benutils.g_benefit_action_id

9012: ben_env_object.setenv(p_lf_evt_ocrd_dt => p_effective_date);
9013: -- Add ended
9014: --
9015: benutils.get_batch_parameters
9016: (p_benefit_action_id => benutils.g_benefit_action_id
9017: ,p_rec => l_param_rec
9018: );
9019: --
9020: benutils.get_batch_parameters

Line 9020: benutils.get_batch_parameters

9016: (p_benefit_action_id => benutils.g_benefit_action_id
9017: ,p_rec => l_param_rec
9018: );
9019: --
9020: benutils.get_batch_parameters
9021: (p_benefit_action_id => benutils.g_benefit_action_id
9022: ,p_rec => l_param_rec
9023: );
9024: --

Line 9021: (p_benefit_action_id => benutils.g_benefit_action_id

9017: ,p_rec => l_param_rec
9018: );
9019: --
9020: benutils.get_batch_parameters
9021: (p_benefit_action_id => benutils.g_benefit_action_id
9022: ,p_rec => l_param_rec
9023: );
9024: --
9025: -- CWB Changes : Added mode ABSENCES mode(M) added. Added GRADE/STEP mode

Line 9055: benutils.get_ler

9051: p_effective_date);
9052: --
9053: elsif p_mode = 'G' then
9054: --
9055: benutils.get_ler
9056: (p_business_group_id => p_business_group_id,
9057: p_typ_cd => 'GSP',
9058: p_effective_date => p_effective_date,
9059: p_lf_evt_oper_cd => p_lf_evt_oper_cd, /* GSP Rate Sync */

Line 9223: benutils.get_active_life_event

9219: if p_mode <> 'W' then
9220: --
9221: if p_mode = 'G' then
9222: --
9223: benutils.get_active_life_event
9224: (p_person_id => p_person_id,
9225: p_business_group_id => p_business_group_id,
9226: p_effective_date => p_effective_date,
9227: p_lf_event_mode => 'G',

Line 9232: benutils.get_active_life_event

9228: p_rec => l_rec);
9229: --
9230: elsif p_mode = 'M' then
9231: --
9232: benutils.get_active_life_event
9233: (p_person_id => p_person_id,
9234: p_business_group_id => p_business_group_id,
9235: p_effective_date => p_effective_date,
9236: p_lf_event_mode => 'M',

Line 9242: benutils.get_active_life_event

9238: --
9239: elsif p_mode = 'I' then
9240: --
9241: -- iRec
9242: benutils.get_active_life_event
9243: (p_person_id => p_person_id,
9244: p_business_group_id => p_business_group_id,
9245: p_effective_date => p_effective_date,
9246: p_lf_event_mode => 'I',

Line 9251: benutils.get_active_life_event

9247: p_rec => l_rec);
9248: --
9249: else
9250: --
9251: benutils.get_active_life_event
9252: (p_person_id => p_person_id,
9253: p_business_group_id => p_business_group_id,
9254: p_effective_date => p_effective_date,
9255: p_rec => l_rec);

Line 9262: benutils.get_active_life_event

9258: --
9259: else
9260: --
9261: -- Is it necessary in this procedure as this proc may not be called in W mode.
9262: benutils.get_active_life_event
9263: (p_person_id => p_person_id,
9264: p_business_group_id => p_business_group_id,
9265: p_effective_date => p_effective_date,
9266: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 9335: benutils.write(p_text => 'Winner Life Event : '|| l_rec.name||

9331: --
9332: -- PB : 5422 : (p_mode = 'L' and l_rec.typ_cd in ('SCHEDDO', 'SCHEDDA','SCHEDDU','UNRSTR'))
9333: then
9334: --
9335: benutils.write(p_text => 'Winner Life Event : '|| l_rec.name||
9336: benutils.id(l_rec.ler_id) ||
9337: ' , Supplied Mode : ' || p_mode);
9338: --
9339: -- Raise error for this person.

Line 9336: benutils.id(l_rec.ler_id) ||

9332: -- PB : 5422 : (p_mode = 'L' and l_rec.typ_cd in ('SCHEDDO', 'SCHEDDA','SCHEDDU','UNRSTR'))
9333: then
9334: --
9335: benutils.write(p_text => 'Winner Life Event : '|| l_rec.name||
9336: benutils.id(l_rec.ler_id) ||
9337: ' , Supplied Mode : ' || p_mode);
9338: --
9339: -- Raise error for this person.
9340: --

Line 9356: benutils.write(p_text => g_rec.text );

9352: -- return null value. Hence set the values.
9353: --
9354: g_rec.text := fnd_message.get;
9355: g_rec.error_message_code := 'BEN_92145_MODE_LE_DIFFER';
9356: benutils.write(p_text => g_rec.text );
9357: --
9358: -- Bug 2836770
9359: --
9360: -- Bug : 3658807

Line 9370: benutils.write(p_text => 'Life Event Occured Date: '||

9366: raise g_record_error;
9367: --
9368: end if;
9369: --
9370: benutils.write(p_text => 'Life Event Occured Date: '||
9371: l_rec.lf_evt_ocrd_dt);
9372: if l_created_ler_id <> nvl(p_ler_id,-1) then
9373: --
9374: -- Get life event name we are dealing with, put in global structure

Line 9377: benutils.write(p_text => 'Winner Life Event : '||

9373: --
9374: -- Get life event name we are dealing with, put in global structure
9375: --
9376: p_ler_id := l_created_ler_id;
9377: benutils.write(p_text => 'Winner Life Event : '||
9378: l_rec.name||
9379: benutils.id(l_rec.ler_id));
9380: --
9381: end if;

Line 9379: benutils.id(l_rec.ler_id));

9375: --
9376: p_ler_id := l_created_ler_id;
9377: benutils.write(p_text => 'Winner Life Event : '||
9378: l_rec.name||
9379: benutils.id(l_rec.ler_id));
9380: --
9381: end if;
9382: --
9383: ben_env_object.setenv(p_lf_evt_ocrd_dt => l_rec.lf_evt_ocrd_dt);

Line 9427: (p_benefit_action_id => benutils.g_benefit_action_id

9423: hr_utility.set_location (l_package||' Bef BCOL ' ,25);
9424: end if;
9425:
9426: ben_comp_object_list.build_comp_object_list
9427: (p_benefit_action_id => benutils.g_benefit_action_id
9428: ,p_comp_selection_rule_id => l_param_rec.comp_selection_rl
9429: ,p_effective_date => l_rec.lf_evt_ocrd_dt
9430: ,p_pgm_id => l_param_rec.pgm_id
9431: ,p_business_group_id => l_param_rec.business_group_id

Line 9443: ,p_thread_id => benutils.g_thread_id

9439: ,p_pl_typ_id => l_param_rec.pl_typ_id
9440: ,p_opt_id => l_param_rec.opt_id
9441: ,p_eligy_prfl_id => l_param_rec.eligy_prfl_id
9442: ,p_vrbl_rt_prfl_id => l_param_rec.vrbl_rt_prfl_id
9443: ,p_thread_id => benutils.g_thread_id
9444: -- PB : 5422 :
9445: ,p_mode => nvl(ben_manage_life_events.g_modified_mode,l_param_rec.mode_cd)
9446: -- ,p_mode => l_param_rec.mode_cd
9447: ,p_lmt_prpnip_by_org_flag => l_param_rec.lmt_prpnip_by_org_flag

Line 9463: benutils.get_active_life_event

9459: elsif (p_mode = 'U' or p_mode = 'R' or p_mode = 'D') then /* IF p_mode IN ('G', 'L', 'C', 'U', 'R', 'W', 'M', 'I') */
9460: --
9461: if p_mode = 'D' then
9462: --
9463: benutils.get_active_life_event
9464: (p_person_id => p_person_id,
9465: p_business_group_id => p_business_group_id,
9466: p_effective_date => p_effective_date,
9467: p_lf_event_mode => 'U',

Line 9483: benutils.get_ler

9479: end if;
9480: --
9481: -- if p_mode in ('U','D') then -- Bug 6321565
9482: --
9483: benutils.get_ler
9484: (p_business_group_id => p_business_group_id,
9485: p_typ_cd => 'SCHEDDU',
9486: p_effective_date => p_effective_date,
9487: p_rec => l_ler_rec);

Line 9558: benutils.write(p_rec => l_ler_batch_rec);

9554: l_ler_batch_rec.cvrge_rt_prem_flag := 'N';
9555: l_ler_batch_rec.business_group_id := p_business_group_id;
9556: l_ler_batch_rec.effective_date := p_effective_date;
9557: --
9558: benutils.write(p_rec => l_ler_batch_rec);
9559: if g_debug then
9560: hr_utility.set_location (l_package,60);
9561: end if;
9562: if l_rec.per_in_ler_id is null then

Line 9601: (p_benefit_action_id => benutils.g_benefit_action_id

9597: --
9598: if p_mode = 'R' then
9599: --
9600: ben_comp_object_list.build_comp_object_list
9601: (p_benefit_action_id => benutils.g_benefit_action_id
9602: ,p_comp_selection_rule_id => l_param_rec.comp_selection_rl
9603: ,p_effective_date => p_effective_date
9604: ,p_pgm_id => l_param_rec.pgm_id
9605: ,p_business_group_id => l_param_rec.business_group_id

Line 9615: ,p_thread_id => benutils.g_thread_id

9611: ,p_pl_typ_id => l_param_rec.pl_typ_id
9612: ,p_opt_id => l_param_rec.opt_id
9613: ,p_eligy_prfl_id => l_param_rec.eligy_prfl_id
9614: ,p_vrbl_rt_prfl_id => l_param_rec.vrbl_rt_prfl_id
9615: ,p_thread_id => benutils.g_thread_id
9616: ,p_mode => 'U'
9617: ,p_lmt_prpnip_by_org_flag => l_param_rec.lmt_prpnip_by_org_flag
9618: ,p_person_id => p_person_id
9619: );

Line 9626: fnd_message.set_token('PROC','benutils.get_batch_parameters');

9622: --
9623: end if;
9624: --
9625: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
9626: fnd_message.set_token('PROC','benutils.get_batch_parameters');
9627: ben_enrolment_requirements.g_electable_choice_created := false;
9628: ben_enrolment_requirements.g_any_choice_created := false;
9629: ben_enrolment_requirements.g_auto_choice_created := false;
9630: ben_determine_dpnt_eligibility.g_dpnt_ineligible := false;

Line 9643: (p_benefit_action_id => benutils.g_benefit_action_id

9639: if g_debug then
9640: hr_utility.set_location (' Temp BCOL '||l_package,10);
9641: end if;
9642: ben_comp_object_list.build_comp_object_list
9643: (p_benefit_action_id => benutils.g_benefit_action_id
9644: ,p_comp_selection_rule_id => l_param_rec.comp_selection_rl
9645: ,p_effective_date => p_effective_date
9646: ,p_pgm_id => l_param_rec.pgm_id
9647: ,p_business_group_id => l_param_rec.business_group_id

Line 9659: ,p_thread_id => benutils.g_thread_id

9655: ,p_pl_typ_id => l_param_rec.pl_typ_id
9656: ,p_opt_id => l_param_rec.opt_id
9657: ,p_eligy_prfl_id => l_param_rec.eligy_prfl_id
9658: ,p_vrbl_rt_prfl_id => l_param_rec.vrbl_rt_prfl_id
9659: ,p_thread_id => benutils.g_thread_id
9660: -- PB : 5422 :
9661: ,p_mode => p_mode
9662: -- ,p_mode => l_param_rec.mode_cd
9663: ,p_lmt_prpnip_by_org_flag => l_param_rec.lmt_prpnip_by_org_flag

Line 9756: l_rec benutils.g_active_life_event;

9752: where per_in_ler_id = p_per_in_ler_id
9753: and (popl.pgm_id = p_pgm_id or
9754: popl.pl_id = p_pl_id);
9755: --
9756: l_rec benutils.g_active_life_event;
9757: l_lf_rec benutils.g_active_life_event;
9758: --
9759: cursor c_ptnl is
9760: select a.ptnl_ler_for_per_id ptnl_ler_for_per_id,

Line 9757: l_lf_rec benutils.g_active_life_event;

9753: and (popl.pgm_id = p_pgm_id or
9754: popl.pl_id = p_pl_id);
9755: --
9756: l_rec benutils.g_active_life_event;
9757: l_lf_rec benutils.g_active_life_event;
9758: --
9759: cursor c_ptnl is
9760: select a.ptnl_ler_for_per_id ptnl_ler_for_per_id,
9761: a.object_version_number object_version_number

Line 10179: benutils.get_active_life_event

10175: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
10176: if (l_mode = 'U'or l_mode = 'R' or l_mode = 'D') then
10177: --
10178: if l_mode <> 'D' then
10179: benutils.get_active_life_event
10180: (p_person_id => p_person_id,
10181: p_business_group_id => p_business_group_id,
10182: p_effective_date => p_effective_date,
10183: p_lf_event_mode => 'U',

Line 10188: benutils.get_active_life_event

10184: p_rec => l_rec);
10185: --
10186: else
10187: --
10188: benutils.get_active_life_event
10189: (p_person_id => p_person_id,
10190: p_business_group_id => p_business_group_id,
10191: p_effective_date => p_effective_date,
10192: p_lf_event_mode => 'D',

Line 10197: benutils.get_active_life_event

10193: p_rec => l_rec);
10194: --
10195: end if;
10196: --
10197: benutils.get_active_life_event
10198: (p_person_id => p_person_id,
10199: p_business_group_id => p_business_group_id,
10200: p_effective_date => p_effective_date,
10201: p_rec => l_lf_rec);

Line 10210: benutils.get_active_life_event

10206: -- CWB Changes .
10207: --
10208: if l_mode = 'W' then
10209: --
10210: benutils.get_active_life_event
10211: (p_person_id => p_person_id,
10212: p_business_group_id => p_business_group_id,
10213: p_effective_date => p_effective_date,
10214: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 10220: benutils.get_active_life_event

10216: p_rec => l_rec);
10217: --
10218: elsif l_mode = 'G' then
10219: --
10220: benutils.get_active_life_event
10221: (p_person_id => p_person_id,
10222: p_business_group_id => p_business_group_id,
10223: p_effective_date => p_effective_date,
10224: p_lf_event_mode => 'G',

Line 10229: benutils.get_active_life_event

10225: p_rec => l_rec);
10226: --
10227: elsif l_mode = 'M' then
10228: --
10229: benutils.get_active_life_event
10230: (p_person_id => p_person_id,
10231: p_business_group_id => p_business_group_id,
10232: p_effective_date => p_effective_date,
10233: p_lf_event_mode => 'M',

Line 10239: benutils.get_active_life_event

10235: --
10236: elsif l_mode = 'I' then
10237: --
10238: -- iRec
10239: benutils.get_active_life_event
10240: (p_person_id => p_person_id,
10241: p_business_group_id => p_business_group_id,
10242: p_effective_date => p_effective_date,
10243: p_lf_event_mode => 'I',

Line 10248: benutils.get_active_life_event

10244: p_rec => l_rec);
10245: --
10246: else
10247: --
10248: benutils.get_active_life_event
10249: (p_person_id => p_person_id,
10250: p_business_group_id => p_business_group_id,
10251: p_effective_date => p_effective_date,
10252: p_rec => l_rec);

Line 10776: benutils.write(p_rec => g_action_rec);

10772: g_action_rec.ler_id := p_ler_id;
10773: g_action_rec.object_version_number := p_object_version_number;
10774: g_action_rec.effective_date := p_effective_date;
10775: --
10776: benutils.write(p_rec => g_action_rec);
10777: --
10778: return;
10779: --
10780: elsif l_evaluate_eligibility

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

11565: end if;
11566: --
11567: end if;
11568: -- end of mode 'R'
11569: benutils.write(p_text => g_output_string);
11570: --
11571: -- Check if the last row of the comp object list has been reached
11572: -- otherwise navigate to the next row
11573: --

Line 12015: p_proc_cd1 => benutils.iftrue(l_mode = 'U'

12011: p_actn_typ_id => null,
12012: p_enrt_mthd_cd => null,
12013: p_business_group_id => p_business_group_id,
12014: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12015: p_proc_cd1 => benutils.iftrue(l_mode = 'U'
12016: ,null
12017: ,'MLEPECP'),
12018: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12019: p_proc_cd2 => benutils.iftrue(l_mode = 'U'

Line 12019: p_proc_cd2 => benutils.iftrue(l_mode = 'U'

12015: p_proc_cd1 => benutils.iftrue(l_mode = 'U'
12016: ,null
12017: ,'MLEPECP'),
12018: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12019: p_proc_cd2 => benutils.iftrue(l_mode = 'U'
12020: ,null
12021: ,'MLEAUTOENRT'),
12022: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12023: p_proc_cd3 => benutils.iftrue(l_mode = 'U'

Line 12023: p_proc_cd3 => benutils.iftrue(l_mode = 'U'

12019: p_proc_cd2 => benutils.iftrue(l_mode = 'U'
12020: ,null
12021: ,'MLEAUTOENRT'),
12022: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12023: p_proc_cd3 => benutils.iftrue(l_mode = 'U'
12024: ,null
12025: ,'MLERTCHG'),
12026: p_proc_cd4 => 'MLEENDENRT',
12027: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071

Line 12028: p_proc_cd5 => benutils.iftrue(l_mode = 'U'

12024: ,null
12025: ,'MLERTCHG'),
12026: p_proc_cd4 => 'MLEENDENRT',
12027: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12028: p_proc_cd5 => benutils.iftrue(l_mode = 'U'
12029: ,null
12030: ,'MLENOIMP'),
12031: p_proc_cd6 => 'MLEELIG',
12032: p_proc_cd7 => 'MLEINELIG',

Line 12124: benutils.get_active_life_event

12120: -- Set life event to processed, only update the per_in_ler_stat_cd
12121: --
12122: if l_mode = 'M' then
12123: --
12124: benutils.get_active_life_event
12125: (p_person_id => p_person_id,
12126: p_business_group_id => p_business_group_id,
12127: p_effective_date => p_effective_date,
12128: p_lf_event_mode => 'M',

Line 12133: benutils.get_active_life_event

12129: p_rec => l_rec);
12130: --
12131: else
12132: --
12133: benutils.get_active_life_event
12134: (p_person_id => p_person_id,
12135: p_business_group_id => p_business_group_id,
12136: p_effective_date => p_effective_date,
12137: p_rec => l_rec);

Line 12234: benutils.update_life_event_cache(p_open_and_closed => 'Y');

12230: --
12231: -- Update status of life event to opened and closed as this is what has
12232: -- happened unless the life event was replaced.
12233: --
12234: benutils.update_life_event_cache(p_open_and_closed => 'Y');
12235: --
12236: end if;
12237: --
12238: if (p_ler_id is not null and

Line 12459: benutils.write(p_text => benutils.g_banner_asterix);

12455: raise;
12456: end;
12457: end if; --end irec2
12458: --
12459: benutils.write(p_text => benutils.g_banner_asterix);
12460: --
12461: p_person_count := p_person_count +1;
12462: --
12463: g_action_rec.person_action_id := p_person_action_id;

Line 12469: benutils.write(p_rec => g_action_rec);

12465: g_action_rec.ler_id := p_ler_id;
12466: g_action_rec.object_version_number := p_object_version_number;
12467: g_action_rec.effective_date := p_effective_date;
12468: --
12469: benutils.write(p_rec => g_action_rec);
12470: --
12471: if g_debug then
12472: hr_utility.set_location ('Leaving '||l_package,10);
12473: end if;

Line 12501: l_rec benutils.g_active_life_event;

12497: ) is
12498: --
12499: l_package varchar2(80);
12500: l_ler_id number := p_ler_id;
12501: l_rec benutils.g_active_life_event;
12502: l_env ben_env_object.g_global_env_rec_type;
12503: l_encoded_message varchar2(2000);
12504: l_app_short_name varchar2(2000);
12505: l_message_name varchar2(2000);

Line 12521: benutils.set_cache_record_position;

12517: --
12518: -- Create savepoint for error handling purposes
12519: --
12520: savepoint process_life_event_savepoint;
12521: benutils.set_cache_record_position;
12522:
12523: -- iRec
12524: -- In iRecruitment mode, as multiple life events for a person could be processed for
12525: -- single person on a given day, clear down person cache. This change is necessary as

Line 12591: benutils.get_active_life_event

12587: if p_mode not in ('A','P','S','T') then
12588: --
12589: if p_mode in ( 'R', 'U') then
12590: --
12591: benutils.get_active_life_event
12592: (p_person_id => p_person_id,
12593: p_business_group_id => p_business_group_id,
12594: p_effective_date => p_effective_date,
12595: p_lf_event_mode => 'U',

Line 12604: benutils.get_active_life_event

12600: -- CWB Changes .
12601: --
12602: if p_mode = 'W' then
12603: --
12604: benutils.get_active_life_event
12605: (p_person_id => p_person_id,
12606: p_business_group_id => p_business_group_id,
12607: p_effective_date => p_effective_date,
12608: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 12614: benutils.get_active_life_event

12610: p_rec => l_rec);
12611: --
12612: elsif p_mode = 'G' then
12613: --
12614: benutils.get_active_life_event
12615: (p_person_id => p_person_id,
12616: p_business_group_id => p_business_group_id,
12617: p_effective_date => p_effective_date,
12618: p_lf_event_mode => 'G',

Line 12623: benutils.get_active_life_event

12619: p_rec => l_rec);
12620: --
12621: elsif p_mode = 'M' then
12622: --
12623: benutils.get_active_life_event
12624: (p_person_id => p_person_id,
12625: p_business_group_id => p_business_group_id,
12626: p_effective_date => p_effective_date,
12627: p_lf_event_mode => 'M',

Line 12632: benutils.get_active_life_event

12628: p_rec => l_rec);
12629: --
12630: else
12631: --
12632: benutils.get_active_life_event
12633: (p_person_id => p_person_id,
12634: p_business_group_id => p_business_group_id,
12635: p_effective_date => p_effective_date,
12636: p_rec => l_rec);

Line 12710: hr_utility.set_location ('p_benefit_action_id=>'||benutils.g_benefit_action_id,10);

12706: end if;
12707: --
12708: if g_debug then
12709: hr_utility.set_location ('Calling pqh ranking proc ',10);
12710: hr_utility.set_location ('p_benefit_action_id=>'||benutils.g_benefit_action_id,10);
12711: hr_utility.set_location ('p_module=>'||l_module,10);
12712: hr_utility.set_location ('p_per_in_ler_id=>'||l_rec.per_in_ler_id,10);
12713: hr_utility.set_location ('p_person_id=>'||p_person_id,10);
12714: hr_utility.set_location ('p_effective_date=>'||l_rec.lf_evt_ocrd_dt,10);

Line 12718: p_benefit_action_id => benutils.g_benefit_action_id

12714: hr_utility.set_location ('p_effective_date=>'||l_rec.lf_evt_ocrd_dt,10);
12715: end if;
12716: --
12717: pqh_ranking.compute_total_score (
12718: p_benefit_action_id => benutils.g_benefit_action_id
12719: ,p_module => l_module
12720: ,p_per_in_ler_id => l_rec.per_in_ler_id
12721: ,p_person_id => p_person_id
12722: ,p_effective_date => l_rec.lf_evt_ocrd_dt );

Line 12747: benutils.rollback_cache;

12743: rollback to process_life_event_savepoint;
12744: --
12745: -- Roll cache to savepoint
12746: --
12747: benutils.rollback_cache;
12748: --
12749: -- WW1178659 - Set the life event occured date to the effective
12750: -- date because the life event occured date may not have been
12751: -- derived. We can do this because national identifier is

Line 12780: --benutils.write(p_text => g_rec.text); /* GSP Rate Sync */

12776: --
12777: g_rec.error_message_code := nvl(l_message_name , g_rec.error_message_code);
12778: g_rec.text := nvl(fnd_message.get , g_rec.text );
12779: --
12780: --benutils.write(p_text => g_rec.text); /* GSP Rate Sync */
12781: benutils.write(p_rec => g_rec);
12782: --
12783: -- benutils.write_table_and_file(p_table => true,
12784: -- p_file => true);

Line 12781: benutils.write(p_rec => g_rec);

12777: g_rec.error_message_code := nvl(l_message_name , g_rec.error_message_code);
12778: g_rec.text := nvl(fnd_message.get , g_rec.text );
12779: --
12780: --benutils.write(p_text => g_rec.text); /* GSP Rate Sync */
12781: benutils.write(p_rec => g_rec);
12782: --
12783: -- benutils.write_table_and_file(p_table => true,
12784: -- p_file => true);
12785:

Line 12783: -- benutils.write_table_and_file(p_table => true,

12779: --
12780: --benutils.write(p_text => g_rec.text); /* GSP Rate Sync */
12781: benutils.write(p_rec => g_rec);
12782: --
12783: -- benutils.write_table_and_file(p_table => true,
12784: -- p_file => true);
12785:
12786: -- Bug 2836770
12787: g_action_rec.person_action_id := p_person_action_id;

Line 12793: benutils.write(p_rec => g_action_rec);

12789: g_action_rec.ler_id := p_ler_id;
12790: g_action_rec.object_version_number := p_object_version_number;
12791: g_action_rec.effective_date := p_effective_date;
12792: --
12793: benutils.write(p_rec => g_action_rec);
12794: --
12795: p_error_person_count := p_error_person_count +1;
12796: --
12797: if p_error_person_count = g_max_errors_allowed then

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

12796: --
12797: if p_error_person_count = g_max_errors_allowed then
12798: --
12799: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
12800: benutils.write(p_text => fnd_message.get);
12801: if g_debug then
12802: hr_utility.set_location ('PLE g_record_error Err Lim '||l_package,10);
12803: end if;
12804: --

Line 12808: benutils.write_table_and_file(p_table => true,

12804: --
12805: -- Write the last bit of information for the thread before
12806: -- the rollback fires when we raise the error.
12807: --
12808: benutils.write_table_and_file(p_table => true,
12809: p_file => true);
12810: commit;
12811: --
12812: raise;

Line 12834: benutils.write(p_rec => g_action_rec);

12830: g_action_rec.ler_id := p_ler_id;
12831: g_action_rec.object_version_number := p_object_version_number;
12832: g_action_rec.effective_date := p_effective_date;
12833: --
12834: benutils.write(p_rec => g_action_rec);
12835: --
12836: p_person_count := p_person_count +1;
12837: --
12838: when g_life_event_after then

Line 12853: benutils.write(p_rec => g_action_rec);

12849: g_action_rec.ler_id := p_ler_id;
12850: g_action_rec.object_version_number := p_object_version_number;
12851: g_action_rec.effective_date := p_effective_date;
12852: --
12853: benutils.write(p_rec => g_action_rec);
12854: --
12855: p_person_count := p_person_count +1;
12856: --
12857: when app_exception.application_exception then

Line 12866: benutils.rollback_cache;

12862: --
12863: -- Update person action to errored as record has an error
12864: --
12865: rollback to process_life_event_savepoint;
12866: benutils.rollback_cache;
12867: --
12868: -- Roll cache to savepoint
12869: --
12870: ben_env_object.setenv(p_lf_evt_ocrd_dt => p_effective_date);

Line 12887: benutils.write(p_text => g_rec.text);

12883: g_rec.rep_typ_cd := 'ERROR';
12884: g_rec.error_message_code := l_message_name;
12885: g_rec.national_identifier := l_per_rec.national_identifier;
12886: g_rec.text := fnd_message.get;
12887: benutils.write(p_text => g_rec.text);
12888: benutils.write(p_rec => g_rec);
12889: --
12890: g_action_rec.person_action_id := p_person_action_id;
12891: g_action_rec.action_status_cd := 'E';

Line 12888: benutils.write(p_rec => g_rec);

12884: g_rec.error_message_code := l_message_name;
12885: g_rec.national_identifier := l_per_rec.national_identifier;
12886: g_rec.text := fnd_message.get;
12887: benutils.write(p_text => g_rec.text);
12888: benutils.write(p_rec => g_rec);
12889: --
12890: g_action_rec.person_action_id := p_person_action_id;
12891: g_action_rec.action_status_cd := 'E';
12892: g_action_rec.ler_id := p_ler_id;

Line 12896: benutils.write(p_rec => g_action_rec);

12892: g_action_rec.ler_id := p_ler_id;
12893: g_action_rec.object_version_number := p_object_version_number;
12894: g_action_rec.effective_date := p_effective_date;
12895: --
12896: benutils.write(p_rec => g_action_rec);
12897: --
12898: p_error_person_count := p_error_person_count +1;
12899: --
12900: if p_error_person_count = g_max_errors_allowed then

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

12899: --
12900: if p_error_person_count = g_max_errors_allowed then
12901: --
12902: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
12903: benutils.write(p_text => fnd_message.get);
12904: --
12905: -- Write the last bit of information for the thread before
12906: -- the rollback fires when we raise the error.
12907: --

Line 12908: benutils.write_table_and_file(p_table => true,

12904: --
12905: -- Write the last bit of information for the thread before
12906: -- the rollback fires when we raise the error.
12907: --
12908: benutils.write_table_and_file(p_table => true,
12909: p_file => true);
12910: commit;
12911: --
12912: raise;

Line 12925: benutils.rollback_cache;

12921: --
12922: -- Update person action to errored as record has an error
12923: --
12924: rollback to process_life_event_savepoint;
12925: benutils.rollback_cache;
12926: --
12927: g_rec.rep_typ_cd := 'FATAL';
12928: g_rec.text := sqlerrm;
12929: benutils.write(p_rec => g_rec);

Line 12929: benutils.write(p_rec => g_rec);

12925: benutils.rollback_cache;
12926: --
12927: g_rec.rep_typ_cd := 'FATAL';
12928: g_rec.text := sqlerrm;
12929: benutils.write(p_rec => g_rec);
12930: --
12931: g_action_rec.person_action_id := p_person_action_id;
12932: g_action_rec.action_status_cd := 'E';
12933: g_action_rec.ler_id := p_ler_id;

Line 12937: benutils.write(p_rec => g_action_rec);

12933: g_action_rec.ler_id := p_ler_id;
12934: g_action_rec.object_version_number := p_object_version_number;
12935: g_action_rec.effective_date := p_effective_date;
12936: --
12937: benutils.write(p_rec => g_action_rec);
12938: --
12939: p_error_person_count := p_error_person_count +1;
12940: --
12941: raise;

Line 13025: benutils.write(p_rec => g_proc_rec);

13021: --
13022: if g_debug then
13023: hr_utility.set_location (l_proc||' Write ',35);
13024: end if;
13025: benutils.write(p_rec => g_proc_rec);
13026: --
13027: end write_bft_statistics;
13028: --
13029: end ben_manage_life_events;