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 1576: benutils.g_benefit_action_id := p_benefit_action_id;

1572: g_fonm_rt_strt_dt := null;
1573: -- bug 6872010
1574:
1575: flush_global_structures;
1576: benutils.g_benefit_action_id := p_benefit_action_id;
1577: benutils.g_thread_id := p_thread_id;
1578: --
1579: -- Initialise comp object list globals
1580: --

Line 1577: benutils.g_thread_id := p_thread_id;

1573: -- bug 6872010
1574:
1575: flush_global_structures;
1576: benutils.g_benefit_action_id := p_benefit_action_id;
1577: benutils.g_thread_id := p_thread_id;
1578: --
1579: -- Initialise comp object list globals
1580: --
1581: ben_comp_object_list.init_comp_object_list_globals;

Line 1691: l_rec benutils.g_active_life_event;

1687: -- p_popl_enrt_typ_cycl_id in number) is
1688: --
1689: l_package varchar2(80) := g_package||'.check_business_rules';
1690: l_dummy varchar2(1);
1691: l_rec benutils.g_active_life_event;
1692: l_ler_rec benutils.g_ler;
1693: l_effective_start_date date;
1694: l_effective_end_date date;
1695: l_ptnl_ler_for_per_id number;

Line 1692: l_ler_rec benutils.g_ler;

1688: --
1689: l_package varchar2(80) := g_package||'.check_business_rules';
1690: l_dummy varchar2(1);
1691: l_rec benutils.g_active_life_event;
1692: l_ler_rec benutils.g_ler;
1693: l_effective_start_date date;
1694: l_effective_end_date date;
1695: l_ptnl_ler_for_per_id number;
1696: l_object_version_number number;

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

3125: l_package := g_package||'.write_logfile';
3126: hr_utility.set_location ('Entering '||l_package,10);
3127: end if;
3128: --
3129: benutils.write(p_text => benutils.g_banner_minus);
3130: benutils.write(p_text => 'Benefits Statistical Information');
3131: benutils.write(p_text => benutils.g_banner_minus);
3132: benutils.write(p_text => 'Processed persons '||p_person_count);
3133: benutils.write(p_text => 'Errored persons '||p_error_person_count);

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

3126: hr_utility.set_location ('Entering '||l_package,10);
3127: end if;
3128: --
3129: benutils.write(p_text => benutils.g_banner_minus);
3130: benutils.write(p_text => 'Benefits Statistical Information');
3131: benutils.write(p_text => benutils.g_banner_minus);
3132: benutils.write(p_text => 'Processed persons '||p_person_count);
3133: benutils.write(p_text => 'Errored persons '||p_error_person_count);
3134: benutils.write(p_text => benutils.g_banner_minus);

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

3127: end if;
3128: --
3129: benutils.write(p_text => benutils.g_banner_minus);
3130: benutils.write(p_text => 'Benefits Statistical Information');
3131: benutils.write(p_text => benutils.g_banner_minus);
3132: benutils.write(p_text => 'Processed persons '||p_person_count);
3133: benutils.write(p_text => 'Errored persons '||p_error_person_count);
3134: benutils.write(p_text => benutils.g_banner_minus);
3135: --

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

3128: --
3129: benutils.write(p_text => benutils.g_banner_minus);
3130: benutils.write(p_text => 'Benefits Statistical Information');
3131: benutils.write(p_text => benutils.g_banner_minus);
3132: benutils.write(p_text => 'Processed persons '||p_person_count);
3133: benutils.write(p_text => 'Errored persons '||p_error_person_count);
3134: benutils.write(p_text => benutils.g_banner_minus);
3135: --
3136: benutils.write_table_and_file(p_table => true,

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

3129: benutils.write(p_text => benutils.g_banner_minus);
3130: benutils.write(p_text => 'Benefits Statistical Information');
3131: benutils.write(p_text => benutils.g_banner_minus);
3132: benutils.write(p_text => 'Processed persons '||p_person_count);
3133: benutils.write(p_text => 'Errored persons '||p_error_person_count);
3134: benutils.write(p_text => benutils.g_banner_minus);
3135: --
3136: benutils.write_table_and_file(p_table => true,
3137: p_file => true);

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

3130: benutils.write(p_text => 'Benefits Statistical Information');
3131: benutils.write(p_text => benutils.g_banner_minus);
3132: benutils.write(p_text => 'Processed persons '||p_person_count);
3133: benutils.write(p_text => 'Errored persons '||p_error_person_count);
3134: benutils.write(p_text => benutils.g_banner_minus);
3135: --
3136: benutils.write_table_and_file(p_table => true,
3137: p_file => true);
3138: commit;

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

3132: benutils.write(p_text => 'Processed persons '||p_person_count);
3133: benutils.write(p_text => 'Errored persons '||p_error_person_count);
3134: benutils.write(p_text => benutils.g_banner_minus);
3135: --
3136: benutils.write_table_and_file(p_table => true,
3137: p_file => true);
3138: commit;
3139: --
3140: if g_debug then

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

3144: exception
3145: --
3146: --
3147: when table_full then
3148: benutils.write(fnd_message.get);
3149: fnd_message.raise_error;
3150: when index_full then
3151: benutils.write(fnd_message.get);
3152: fnd_message.raise_error;

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

3147: when table_full then
3148: benutils.write(fnd_message.get);
3149: fnd_message.raise_error;
3150: when index_full then
3151: benutils.write(fnd_message.get);
3152: fnd_message.raise_error;
3153: --
3154: when others then
3155: --

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

3153: --
3154: when others then
3155: --
3156: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
3157: benutils.write(fnd_message.get);
3158: fnd_message.raise_error;
3159: --
3160: end write_logfile;
3161: --

Line 3175: benutils.clear_down_cache;

3171: hr_utility.set_location ('Entering '||l_package,10);
3172: end if;
3173: --
3174: g_cache_person_process.delete;
3175: benutils.clear_down_cache;
3176: benutils.g_batch_param_table_object.delete;
3177: ben_elig_rl_cache.clear_down_cache;
3178: ben_location_object.clear_down_cache;
3179: ben_org_object.clear_down_cache;

Line 3176: benutils.g_batch_param_table_object.delete;

3172: end if;
3173: --
3174: g_cache_person_process.delete;
3175: benutils.clear_down_cache;
3176: benutils.g_batch_param_table_object.delete;
3177: ben_elig_rl_cache.clear_down_cache;
3178: ben_location_object.clear_down_cache;
3179: ben_org_object.clear_down_cache;
3180: ben_life_object.clear_down_cache;

Line 3206: l_rec benutils.g_batch_param_rec;

3202: procedure print_parameters
3203: (p_benefit_action_id in number) is
3204: --
3205: l_package varchar2(80);
3206: l_rec benutils.g_batch_param_rec;
3207: -- added bug: 5618436
3208: CURSOR c_conc_pgm_name is
3209: SELECT fcp.concurrent_program_name
3210: FROM ben_benefit_actions bft, fnd_concurrent_programs fcp

Line 3230: benutils.get_batch_parameters

3226: if fnd_global.conc_request_id = -1 then
3227: return;
3228: end if;
3229: --
3230: benutils.get_batch_parameters
3231: (p_benefit_action_id => p_benefit_action_id,
3232: p_rec => l_rec);
3233: --
3234: fnd_file.put_line(which => fnd_file.log,

Line 3270: benutils.iftrue

3266: buff => 'Business Group ID :'||
3267: l_rec.business_group_id);
3268: fnd_file.put_line(which => fnd_file.log,
3269: buff => 'Program ID :'||
3270: benutils.iftrue
3271: (p_expression => l_rec.pgm_id is null,
3272: p_true => 'All',
3273: p_false => l_rec.pgm_id));
3274: fnd_file.put_line(which => fnd_file.log,

Line 3276: benutils.iftrue

3272: p_true => 'All',
3273: p_false => l_rec.pgm_id));
3274: fnd_file.put_line(which => fnd_file.log,
3275: buff => 'Plan ID :'||
3276: benutils.iftrue
3277: (p_expression => l_rec.pl_id is null,
3278: p_true => 'All',
3279: p_false => l_rec.pl_id));
3280: fnd_file.put_line(which => fnd_file.log,

Line 3282: benutils.iftrue

3278: p_true => 'All',
3279: p_false => l_rec.pl_id));
3280: fnd_file.put_line(which => fnd_file.log,
3281: buff => 'Plan Type ID :'||
3282: benutils.iftrue
3283: (p_expression => l_rec.pl_typ_id is null,
3284: p_true => 'All',
3285: p_false => l_rec.pl_typ_id));
3286: fnd_file.put_line(which => fnd_file.log,

Line 3288: benutils.iftrue

3284: p_true => 'All',
3285: p_false => l_rec.pl_typ_id));
3286: fnd_file.put_line(which => fnd_file.log,
3287: buff => 'Option ID :'||
3288: benutils.iftrue
3289: (p_expression => l_rec.opt_id is null,
3290: p_true => 'All',
3291: p_false => l_rec.opt_id));
3292: --

Line 3299: benutils.iftrue

3295: --
3296: /*
3297: fnd_file.put_line(which => fnd_file.log,
3298: buff => 'Enrollment Type Cycle :'||
3299: benutils.iftrue
3300: (p_expression => l_rec.popl_enrt_typ_cycl_id is null,
3301: p_true => 'All',
3302: p_false => l_rec.popl_enrt_typ_cycl_id));
3303: */

Line 3312: benutils.iftrue

3308: buff => 'Just Programs :'||
3309: hr_general.decode_lookup('YES_NO',l_rec.no_plans_flag));
3310: fnd_file.put_line(which => fnd_file.log,
3311: buff => 'Reporting Group :'||
3312: benutils.iftrue
3313: (p_expression => l_rec.rptg_grp_id is null,
3314: p_true => 'All',
3315: p_false => l_rec.rptg_grp_id));
3316: fnd_file.put_line(which => fnd_file.log,

Line 3318: benutils.iftrue

3314: p_true => 'All',
3315: p_false => l_rec.rptg_grp_id));
3316: fnd_file.put_line(which => fnd_file.log,
3317: buff => 'Eligiblity Profile :'||
3318: benutils.iftrue
3319: (p_expression => l_rec.eligy_prfl_id is null,
3320: p_true => 'All',
3321: p_false => l_rec.eligy_prfl_id));
3322: fnd_file.put_line(which => fnd_file.log,

Line 3324: benutils.iftrue

3320: p_true => 'All',
3321: p_false => l_rec.eligy_prfl_id));
3322: fnd_file.put_line(which => fnd_file.log,
3323: buff => 'Variable Rate Profile :'||
3324: benutils.iftrue
3325: (p_expression => l_rec.vrbl_rt_prfl_id is null,
3326: p_true => 'All',
3327: p_false => l_rec.vrbl_rt_prfl_id));
3328: fnd_file.put_line(which => fnd_file.log,

Line 3330: benutils.iftrue

3326: p_true => 'All',
3327: p_false => l_rec.vrbl_rt_prfl_id));
3328: fnd_file.put_line(which => fnd_file.log,
3329: buff => 'Person Selection Rule :'||
3330: benutils.iftrue
3331: (p_expression => l_rec.person_selection_rl is null,
3332: p_true => 'None',
3333: p_false => l_rec.person_selection_rl));
3334: fnd_file.put_line(which => fnd_file.log,

Line 3336: benutils.iftrue

3332: p_true => 'None',
3333: p_false => l_rec.person_selection_rl));
3334: fnd_file.put_line(which => fnd_file.log,
3335: buff => 'Comp Object Selection Rule :'||
3336: benutils.iftrue
3337: (p_expression => l_rec.comp_selection_rl is null,
3338: p_true => 'None',
3339: p_false => l_rec.comp_selection_rl));
3340: --

Line 3364: l_rec benutils.g_batch_param_rec;

3360: l_business_group_id number ;
3361: l_pl_id number;
3362: l_lf_evt_ocrd_dt date;
3363: l_ler_id number;
3364: l_rec benutils.g_batch_param_rec;
3365: lv_pl_id number;
3366: lv_business_group_id number;
3367: lv_ler_id number;
3368: lv_lf_evt_ocrd_dt date;

Line 3621: if benutils.g_benefit_action_id is not null then

3617: --
3618: lv_pl_id := -1;
3619: lv_lf_evt_ocrd_dt := hr_api.g_eot;
3620: --
3621: if benutils.g_benefit_action_id is not null then
3622: --
3623: benutils.get_batch_parameters
3624: (p_benefit_action_id => benutils.g_benefit_action_id,
3625: p_rec => l_rec);

Line 3623: benutils.get_batch_parameters

3619: lv_lf_evt_ocrd_dt := hr_api.g_eot;
3620: --
3621: if benutils.g_benefit_action_id is not null then
3622: --
3623: benutils.get_batch_parameters
3624: (p_benefit_action_id => benutils.g_benefit_action_id,
3625: p_rec => l_rec);
3626: --
3627: lv_pl_id := l_rec.pl_id;

Line 3624: (p_benefit_action_id => benutils.g_benefit_action_id,

3620: --
3621: if benutils.g_benefit_action_id is not null then
3622: --
3623: benutils.get_batch_parameters
3624: (p_benefit_action_id => benutils.g_benefit_action_id,
3625: p_rec => l_rec);
3626: --
3627: lv_pl_id := l_rec.pl_id;
3628: lv_lf_evt_ocrd_dt := l_rec.lf_evt_ocrd_dt;

Line 3812: l_rec benutils.g_batch_param_rec;

3808: l_business_group_id number ;
3809: l_pl_id number;
3810: l_lf_evt_ocrd_dt date;
3811: l_ler_id number;
3812: l_rec benutils.g_batch_param_rec;
3813: lv_pl_id number;
3814: lv_business_group_id number;
3815: lv_ler_id number;
3816: lv_lf_evt_ocrd_dt date;

Line 4045: if benutils.g_benefit_action_id is not null then

4041: --
4042: lv_pl_id := -1;
4043: lv_lf_evt_ocrd_dt := hr_api.g_eot;
4044: --
4045: if benutils.g_benefit_action_id is not null then
4046: --
4047: benutils.get_batch_parameters
4048: (p_benefit_action_id => benutils.g_benefit_action_id,
4049: p_rec => l_rec);

Line 4047: benutils.get_batch_parameters

4043: lv_lf_evt_ocrd_dt := hr_api.g_eot;
4044: --
4045: if benutils.g_benefit_action_id is not null then
4046: --
4047: benutils.get_batch_parameters
4048: (p_benefit_action_id => benutils.g_benefit_action_id,
4049: p_rec => l_rec);
4050: --
4051: lv_pl_id := l_rec.pl_id;

Line 4048: (p_benefit_action_id => benutils.g_benefit_action_id,

4044: --
4045: if benutils.g_benefit_action_id is not null then
4046: --
4047: benutils.get_batch_parameters
4048: (p_benefit_action_id => benutils.g_benefit_action_id,
4049: p_rec => l_rec);
4050: --
4051: lv_pl_id := l_rec.pl_id;
4052: lv_lf_evt_ocrd_dt := l_rec.lf_evt_ocrd_dt;

Line 4210: l_rec benutils.g_active_life_event;

4206: ) is
4207: --
4208: l_package varchar2(80);
4209: --
4210: l_rec benutils.g_active_life_event;
4211: l_mgr_rec benutils.g_active_life_event;
4212: l_mgr_rec_temp benutils.g_active_life_event;
4213: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
4214: l_procd_dt date;

Line 4211: l_mgr_rec benutils.g_active_life_event;

4207: --
4208: l_package varchar2(80);
4209: --
4210: l_rec benutils.g_active_life_event;
4211: l_mgr_rec benutils.g_active_life_event;
4212: l_mgr_rec_temp benutils.g_active_life_event;
4213: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
4214: l_procd_dt date;
4215: l_strtd_dt date;

Line 4212: l_mgr_rec_temp benutils.g_active_life_event;

4208: l_package varchar2(80);
4209: --
4210: l_rec benutils.g_active_life_event;
4211: l_mgr_rec benutils.g_active_life_event;
4212: l_mgr_rec_temp benutils.g_active_life_event;
4213: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
4214: l_procd_dt date;
4215: l_strtd_dt date;
4216: l_voidd_dt date;

Line 4337: benutils.get_active_life_event

4333: l_package := g_package||'.popu_cross_gb_epe_data';
4334: hr_utility.set_location ('Entering '||l_package,10);
4335: end if;
4336: --
4337: benutils.get_active_life_event
4338: (p_person_id => p_person_id,
4339: p_business_group_id => p_business_group_id,
4340: p_effective_date => p_effective_date,
4341: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 4362: benutils.get_active_life_event

4358: -- Get per in ler for manager in per_business_group_id.
4359: --
4360: l_mgr_rec := l_mgr_rec_temp;
4361: --
4362: benutils.get_active_life_event
4363: (p_person_id => l_mgr_person_id,
4364: p_business_group_id => l_curr_pel.per_business_group_id,
4365: p_effective_date => p_effective_date,
4366: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 4752: l_rec benutils.g_active_life_event;

4748: ) is
4749: --
4750: l_package varchar2(80);
4751: --
4752: l_rec benutils.g_active_life_event;
4753: l_mgr_rec benutils.g_active_life_event;
4754: l_mgr_rec_temp benutils.g_active_life_event;
4755: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
4756: l_procd_dt date;

Line 4753: l_mgr_rec benutils.g_active_life_event;

4749: --
4750: l_package varchar2(80);
4751: --
4752: l_rec benutils.g_active_life_event;
4753: l_mgr_rec benutils.g_active_life_event;
4754: l_mgr_rec_temp benutils.g_active_life_event;
4755: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
4756: l_procd_dt date;
4757: l_strtd_dt date;

Line 4754: l_mgr_rec_temp benutils.g_active_life_event;

4750: l_package varchar2(80);
4751: --
4752: l_rec benutils.g_active_life_event;
4753: l_mgr_rec benutils.g_active_life_event;
4754: l_mgr_rec_temp benutils.g_active_life_event;
4755: l_effective_date date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
4756: l_procd_dt date;
4757: l_strtd_dt date;
4758: l_voidd_dt date;

Line 4844: benutils.get_active_life_event

4840: l_package := g_package||'.popu_cross_gb_epe_data';
4841: hr_utility.set_location ('Entering '||l_package,10);
4842: end if;
4843: --
4844: benutils.get_active_life_event
4845: (p_person_id => p_person_id,
4846: p_business_group_id => p_business_group_id,
4847: p_effective_date => p_effective_date,
4848: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 4875: benutils.get_active_life_event

4871: -- Get per in ler for manager in per_business_group_id.
4872: --
4873: l_mgr_rec := l_mgr_rec_temp;
4874: --
4875: benutils.get_active_life_event
4876: (p_person_id => l_mgr_person_id,
4877: p_business_group_id => l_curr_epe.per_business_group_id,
4878: p_effective_date => p_effective_date,
4879: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

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

5663: */
5664: if g_debug then
5665: hr_utility.set_location (l_package||' Write TAF ',20);
5666: end if;
5667: benutils.write_table_and_file(p_table => true,
5668: p_file => true);
5669: commit;
5670: --
5671: if g_debug then

Line 6120: l_ler_rec benutils.g_ler;

6116: l_max_errors number;
6117: l_commit number;
6118: l_slave_errored boolean := false;
6119: --
6120: l_ler_rec benutils.g_ler;
6121: --
6122: begin
6123: --
6124: g_debug := hr_utility.debug_enabled;

Line 6144: benutils.get_ler

6140: */
6141: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
6142: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
6143: --
6144: benutils.get_ler
6145: (p_business_group_id => p_business_group_id
6146: ,p_typ_cd => 'SCHEDDU'
6147: ,p_effective_date => l_effective_date
6148: ,p_rec => l_ler_rec

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

6155: if p_mode = 'I' then
6156: --
6157: -- Set G_LER_ID to iRecruitment LER_ID for subsequent use in ben_evaluate_ptnl_lf_evt
6158: --
6159: benutils.get_ler (p_business_group_id => p_business_group_id,
6160: p_typ_cd => 'IREC',
6161: p_effective_date => l_effective_date,
6162: p_rec => l_ler_rec
6163: );

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

6168: -- iRec
6169:
6170: /* Bug 14484394: Set g_max_errors_allowed for the Participation Process: Compensation Workbench Conc Program */
6171: if(p_mode = 'W') then
6172: benutils.get_parameter(p_business_group_id => p_business_group_id,
6173: p_batch_exe_cd => 'BENGCMOD',
6174: p_threads => l_threads,
6175: p_chunk_size => l_chunk_size,
6176: p_max_errors => g_max_errors_allowed);

Line 6178: benutils.get_parameter

6174: p_threads => l_threads,
6175: p_chunk_size => l_chunk_size,
6176: p_max_errors => g_max_errors_allowed);
6177: else
6178: benutils.get_parameter
6179: (p_business_group_id => p_business_group_id,
6180: p_batch_exe_cd => 'BENMNGLE',
6181: p_threads => l_threads,
6182: p_chunk_size => l_chunk_size,

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

6382: when g_record_error then
6383: if g_debug then
6384: hr_utility.set_location (l_package||' Exception g_record_error ',50);
6385: end if;
6386: benutils.write(p_text => fnd_message.get);
6387: --
6388: -- Write the last bit of information for the thread
6389: --
6390: benutils.write_table_and_file(p_table => true,

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

6386: benutils.write(p_text => fnd_message.get);
6387: --
6388: -- Write the last bit of information for the thread
6389: --
6390: benutils.write_table_and_file(p_table => true,
6391: p_file => true);
6392: commit;
6393: --
6394: -- Output log information to log file

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

6420: g_rec.text := nvl(fnd_message.get,sqlerrm);
6421: if g_debug then
6422: hr_utility.set_location(substr(g_rec.text,1,100),10);
6423: end if;
6424: benutils.write(p_rec => g_rec);
6425: --
6426: -- Output log information to log file
6427: --
6428: write_logfile(p_benefit_action_id => p_benefit_action_id,

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

6443: --
6444: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');
6445: fnd_message.set_token('ORA_ERRCODE',SQLCODE);
6446: --
6447: benutils.write(p_text => fnd_message.get);
6448: benutils.write_table_and_file(p_table => true,
6449: p_file => true);
6450: commit;
6451: if g_debug then

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

6444: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');
6445: fnd_message.set_token('ORA_ERRCODE',SQLCODE);
6446: --
6447: benutils.write(p_text => fnd_message.get);
6448: benutils.write_table_and_file(p_table => true,
6449: p_file => true);
6450: commit;
6451: if g_debug then
6452: hr_utility.set_location ('Others error '||l_package,100);

Line 7897: l_ler_rec benutils.g_ler;

7893: l_num_ranges number := 0;
7894: l_num_persons number := 0;
7895: l_person_action_id number;
7896: l_range_id number;
7897: l_ler_rec benutils.g_ler;
7898: l_retcode number;
7899: l_errbuf varchar2(1000);
7900: l_no_one_to_process exception; -- Bug 3870204
7901: -- iRec

Line 8027: benutils.get_ler

8023: --
8024: -- Get ler_id for Unrestricted Mode and store it in globle variable so that procedures down the road can
8025: -- access it
8026: --
8027: benutils.get_ler
8028: (p_business_group_id => p_business_group_id,
8029: p_typ_cd => 'SCHEDDU',
8030: p_effective_date => l_effective_date,
8031: p_rec => l_ler_rec);

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

8036: if p_mode = 'I' then
8037: --
8038: -- Set G_LER_ID to iRecruitment LER_ID for subsequent use in ben_evaluate_ptnl_lf_evt
8039: --
8040: benutils.get_ler (p_business_group_id => p_business_group_id,
8041: p_typ_cd => 'IREC',
8042: p_effective_date => l_effective_date,
8043: p_rec => l_ler_rec
8044: );

Line 8084: benutils.get_ler

8080: -- Get ler id for unrestricted
8081: --
8082: if p_mode in ('U','D') then
8083: --
8084: benutils.get_ler
8085: (p_business_group_id => p_business_group_id,
8086: p_typ_cd => 'SCHEDDU',
8087: p_effective_date => l_effective_date,
8088: p_rec => l_ler_rec);

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

8089: --
8090: l_ler_override_id := l_ler_rec.ler_id;
8091: --
8092: if g_debug then
8093: hr_utility.set_location (l_package||' benutils.get_ler ',30);
8094: end if;
8095: --
8096: end if;
8097: /*

Line 8103: benutils.get_ler

8099: -- Get ler id for Grade/Step
8100: --
8101: if p_mode = 'G' then
8102: --
8103: benutils.get_ler
8104: (p_business_group_id => p_business_group_id,
8105: p_typ_cd => 'GSP',
8106: p_effective_date => l_effective_date,
8107: p_rec => l_ler_rec);

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

8108: --
8109: l_ler_override_id := l_ler_rec.ler_id;
8110: --
8111: if g_debug then
8112: hr_utility.set_location (l_package||' benutils.get_ler ',31);
8113: end if;
8114: end if;
8115: */
8116: --

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

8121: hr_utility.set_location (l_package||' get_parameter',20);
8122: end if;
8123: /* Start: CWB Thread Num Enhancement */
8124: if(p_mode = 'W') then
8125: benutils.get_parameter(p_business_group_id => p_business_group_id,
8126: p_batch_exe_cd => 'BENGCMOD',
8127: p_threads => l_threads,
8128: p_chunk_size => l_chunk_size,
8129: p_max_errors => l_max_errors);

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

8127: p_threads => l_threads,
8128: p_chunk_size => l_chunk_size,
8129: p_max_errors => l_max_errors);
8130: else
8131: benutils.get_parameter(p_business_group_id => p_business_group_id,
8132: p_batch_exe_cd => 'BENMNGLE',
8133: p_threads => l_threads,
8134: p_chunk_size => l_chunk_size,
8135: p_max_errors => l_max_errors);

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

8143: hr_utility.set_location('Max Errors = '||l_max_errors,10);
8144: --
8145: end if;
8146: --
8147: benutils.g_benefit_action_id := l_benefit_action_id; -- Bug 3870204
8148: --
8149: -- Create benefit actions parameters in the benefit action table.
8150: -- Do not create if a benefit action already exists, in other words
8151: -- we are doing a restart.

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

8228: p_concat_segs => p_concat_segs
8229: -- end 2940151
8230: );
8231: --
8232: benutils.g_benefit_action_id := l_benefit_action_id; -- Bug 3870204
8233: --
8234: if g_debug then
8235: hr_utility.set_location (l_package||' Dn Create BFT ',20);
8236: end if;

Line 8333: benutils.get_ler

8329: end if;
8330: --
8331: elsif p_mode in ('U','D') then
8332: --
8333: benutils.get_ler
8334: (p_business_group_id => p_business_group_id,
8335: p_typ_cd => 'SCHEDDU',
8336: p_effective_date => l_effective_date,
8337: p_rec => l_ler_rec);

Line 8523: benutils.g_benefit_action_id := l_benefit_action_id;

8519: end if;
8520: --
8521: -- Prasad special case
8522: --
8523: benutils.g_benefit_action_id := l_benefit_action_id;
8524: p_benefit_action_id := l_benefit_action_id;
8525: --
8526: /* GLOBALCWB : The issue of track ineligible flag have to be addressed
8527: later after drop 3, currently it has no meaning

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

8596: --
8597: exception
8598: -- Bug 3870204
8599: when l_no_one_to_process then
8600: benutils.write(p_text => fnd_message.get);
8601: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
8602: rollback;
8603: end internal_process;
8604: --

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

8597: exception
8598: -- Bug 3870204
8599: when l_no_one_to_process then
8600: benutils.write(p_text => fnd_message.get);
8601: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
8602: rollback;
8603: end internal_process;
8604: --
8605: procedure process

Line 8791: benutils.id(p_oipl_id);

8787: p_oipl_id => p_oipl_id);
8788: ben_comp_object.get_object(p_rec => l_opt_rec,
8789: p_opt_id => l_oipl_rec.opt_id);
8790: p_comp_object_name := rpad(substr(l_opt_rec.name,1,18),18,' ')||
8791: benutils.id(p_oipl_id);
8792: --
8793: elsif p_pl_id is not null then
8794: --
8795: -- Test if plan is in program or not

Line 8810: benutils.id(p_pl_id);

8806: --
8807: ben_comp_object.get_object(p_rec => l_pl_rec,
8808: p_pl_id => p_pl_id);
8809: p_comp_object_name := rpad(substr(l_pl_rec.name,1,18),18,' ')||
8810: benutils.id(p_pl_id);
8811: --
8812: elsif p_pgm_id is not null then
8813: --
8814: p_comp_object_value := g_cache_comp_objects.pgm;

Line 8819: benutils.id(p_pgm_id);

8815: --
8816: ben_comp_object.get_object(p_rec => l_pgm_rec,
8817: p_pgm_id => p_pgm_id);
8818: p_comp_object_name := rpad(substr(l_pgm_rec.name,1,18),18,' ')||
8819: benutils.id(p_pgm_id);
8820: --
8821: elsif p_plip_id is not null then
8822: --
8823: p_comp_object_value := g_cache_comp_objects.plip;

Line 8826: benutils.id(p_plip_id);

8822: --
8823: p_comp_object_value := g_cache_comp_objects.plip;
8824: --
8825: p_comp_object_name := rpad('Plip',15,' ')||
8826: benutils.id(p_plip_id);
8827: --
8828: elsif p_ptip_id is not null then
8829: --
8830: p_comp_object_value := g_cache_comp_objects.ptip;

Line 8833: benutils.id(p_ptip_id);

8829: --
8830: p_comp_object_value := g_cache_comp_objects.ptip;
8831: --
8832: p_comp_object_name := rpad('Ptip',15,' ')||
8833: benutils.id(p_ptip_id);
8834: --
8835: end if;
8836: --
8837: if g_debug then

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

9034: --
9035: ben_org_object.get_object(p_business_group_id => p_business_group_id,
9036: p_rec => l_bus_rec);
9037: --
9038: benutils.write(p_text => benutils.g_banner_asterix);
9039: l_output_string := 'Name: '||
9040: substr(l_per_rec.full_name,1,45)||
9041: benutils.id(p_person_id);
9042: benutils.write(p_text => l_output_string);

Line 9041: benutils.id(p_person_id);

9037: --
9038: benutils.write(p_text => benutils.g_banner_asterix);
9039: l_output_string := 'Name: '||
9040: substr(l_per_rec.full_name,1,45)||
9041: benutils.id(p_person_id);
9042: benutils.write(p_text => l_output_string);
9043: l_output_string := ' Typ: '||
9044: substr(l_typ_rec(1).user_person_type,1,45);
9045: --

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

9038: benutils.write(p_text => benutils.g_banner_asterix);
9039: l_output_string := 'Name: '||
9040: substr(l_per_rec.full_name,1,45)||
9041: benutils.id(p_person_id);
9042: benutils.write(p_text => l_output_string);
9043: l_output_string := ' Typ: '||
9044: substr(l_typ_rec(1).user_person_type,1,45);
9045: --
9046: -- loop through the rest of the person_types

Line 9053: benutils.write(l_output_string);

9049: --
9050: l_output_string := rpad(' ',6,' ');
9051: l_output_string := l_output_string||
9052: substr(l_typ_rec(l_count).user_person_type,1,45);
9053: benutils.write(l_output_string);
9054: --
9055: end loop;
9056: l_output_string := 'Grp: '||
9057: substr(l_ben_rec.name,1,45)||

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

9054: --
9055: end loop;
9056: l_output_string := 'Grp: '||
9057: substr(l_ben_rec.name,1,45)||
9058: benutils.id(l_per_rec.benefit_group_id);
9059: benutils.write(p_text => l_output_string);
9060: --
9061: l_output_string := 'BG: '||
9062: substr(l_bus_rec.name,1,45)||

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

9055: end loop;
9056: l_output_string := 'Grp: '||
9057: substr(l_ben_rec.name,1,45)||
9058: benutils.id(l_per_rec.benefit_group_id);
9059: benutils.write(p_text => l_output_string);
9060: --
9061: l_output_string := 'BG: '||
9062: substr(l_bus_rec.name,1,45)||
9063: benutils.id(p_business_group_id);

Line 9063: benutils.id(p_business_group_id);

9059: benutils.write(p_text => l_output_string);
9060: --
9061: l_output_string := 'BG: '||
9062: substr(l_bus_rec.name,1,45)||
9063: benutils.id(p_business_group_id);
9064: benutils.write(p_text => l_output_string);
9065: --
9066: l_output_string := 'Org: '||
9067: substr(l_org_rec.name,1,45)||

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

9060: --
9061: l_output_string := 'BG: '||
9062: substr(l_bus_rec.name,1,45)||
9063: benutils.id(p_business_group_id);
9064: benutils.write(p_text => l_output_string);
9065: --
9066: l_output_string := 'Org: '||
9067: substr(l_org_rec.name,1,45)||
9068: benutils.id(l_ass_rec.organization_id);

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

9064: benutils.write(p_text => l_output_string);
9065: --
9066: l_output_string := 'Org: '||
9067: substr(l_org_rec.name,1,45)||
9068: benutils.id(l_ass_rec.organization_id);
9069: benutils.write(p_text => l_output_string);
9070: --
9071: if hr_api.return_legislation_code(p_business_group_id) = 'US'
9072: then

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

9065: --
9066: l_output_string := 'Org: '||
9067: substr(l_org_rec.name,1,45)||
9068: benutils.id(l_ass_rec.organization_id);
9069: benutils.write(p_text => l_output_string);
9070: --
9071: if hr_api.return_legislation_code(p_business_group_id) = 'US'
9072: then
9073: l_output_string := 'Gre: '||

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

9071: if hr_api.return_legislation_code(p_business_group_id) = 'US'
9072: then
9073: l_output_string := 'Gre: '||
9074: substr(l_org2_rec.name,1,45);
9075: benutils.write(p_text => l_output_string);
9076: else
9077: l_output_string := 'Gre: '|| 'Not applicable' ;
9078: benutils.write(p_text => l_output_string);
9079: end if;

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

9074: substr(l_org2_rec.name,1,45);
9075: benutils.write(p_text => l_output_string);
9076: else
9077: l_output_string := 'Gre: '|| 'Not applicable' ;
9078: benutils.write(p_text => l_output_string);
9079: end if;
9080: --
9081: l_output_string := 'Loc: '||
9082: substr(l_loc_rec.address_line_1,1,45)||

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

9079: end if;
9080: --
9081: l_output_string := 'Loc: '||
9082: substr(l_loc_rec.address_line_1,1,45)||
9083: benutils.id(l_loc_rec.location_id);
9084: benutils.write(p_text => l_output_string);
9085: --
9086: l_output_string := 'Pst: '||
9087: substr(l_pad_rec.postal_code,1,45);

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

9080: --
9081: l_output_string := 'Loc: '||
9082: substr(l_loc_rec.address_line_1,1,45)||
9083: benutils.id(l_loc_rec.location_id);
9084: benutils.write(p_text => l_output_string);
9085: --
9086: l_output_string := 'Pst: '||
9087: substr(l_pad_rec.postal_code,1,45);
9088: benutils.write(p_text => l_output_string);

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

9084: benutils.write(p_text => l_output_string);
9085: --
9086: l_output_string := 'Pst: '||
9087: substr(l_pad_rec.postal_code,1,45);
9088: benutils.write(p_text => l_output_string);
9089: --
9090: l_output_string := 'Pyr: '||
9091: substr(l_pay_rec.payroll_name,1,45)||
9092: benutils.id(l_pay_rec.payroll_id);

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

9088: benutils.write(p_text => l_output_string);
9089: --
9090: l_output_string := 'Pyr: '||
9091: substr(l_pay_rec.payroll_name,1,45)||
9092: benutils.id(l_pay_rec.payroll_id);
9093: benutils.write(p_text => l_output_string);
9094: --
9095: if g_debug then
9096: hr_utility.set_location ('Leaving '||l_package,10);

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

9089: --
9090: l_output_string := 'Pyr: '||
9091: substr(l_pay_rec.payroll_name,1,45)||
9092: benutils.id(l_pay_rec.payroll_id);
9093: benutils.write(p_text => l_output_string);
9094: --
9095: if g_debug then
9096: hr_utility.set_location ('Leaving '||l_package,10);
9097: end if;

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

9241: ben_org_object.get_object (p_business_group_id => p_business_group_id,
9242: p_rec => l_bus_rec
9243: );
9244: --
9245: benutils.WRITE (p_text => benutils.g_banner_asterix);
9246: --
9247: l_output_string :=
9248: 'Name: '
9249: || SUBSTR (l_per_rec.full_name, 1, 45)

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

9246: --
9247: l_output_string :=
9248: 'Name: '
9249: || SUBSTR (l_per_rec.full_name, 1, 45)
9250: || benutils.ID (p_person_id);
9251: --
9252: benutils.WRITE (p_text => l_output_string);
9253: --
9254: l_output_string :=

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

9248: 'Name: '
9249: || SUBSTR (l_per_rec.full_name, 1, 45)
9250: || benutils.ID (p_person_id);
9251: --
9252: benutils.WRITE (p_text => l_output_string);
9253: --
9254: l_output_string :=
9255: ' Typ: '
9256: || SUBSTR (l_typ_rec (1).user_person_type, 1, 45);

Line 9268: benutils.WRITE (l_output_string);

9264: l_output_string := RPAD (' ', 6, ' ');
9265: l_output_string :=
9266: l_output_string
9267: || SUBSTR (l_typ_rec (l_count).user_person_type, 1, 45);
9268: benutils.WRITE (l_output_string);
9269: --
9270: END LOOP;
9271:
9272: l_output_string :=

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

9271:
9272: l_output_string :=
9273: 'Grp: '
9274: || SUBSTR (l_ben_rec.NAME, 1, 45)
9275: || benutils.ID (l_per_rec.benefit_group_id);
9276: benutils.WRITE (p_text => l_output_string);
9277: --
9278: l_output_string :=
9279: 'BG: '

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

9272: l_output_string :=
9273: 'Grp: '
9274: || SUBSTR (l_ben_rec.NAME, 1, 45)
9275: || benutils.ID (l_per_rec.benefit_group_id);
9276: benutils.WRITE (p_text => l_output_string);
9277: --
9278: l_output_string :=
9279: 'BG: '
9280: || SUBSTR (l_bus_rec.NAME, 1, 45)

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

9277: --
9278: l_output_string :=
9279: 'BG: '
9280: || SUBSTR (l_bus_rec.NAME, 1, 45)
9281: || benutils.ID (p_business_group_id);
9282: benutils.WRITE (p_text => l_output_string);
9283: --
9284: l_output_string :=
9285: 'Org: '

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

9278: l_output_string :=
9279: 'BG: '
9280: || SUBSTR (l_bus_rec.NAME, 1, 45)
9281: || benutils.ID (p_business_group_id);
9282: benutils.WRITE (p_text => l_output_string);
9283: --
9284: l_output_string :=
9285: 'Org: '
9286: || SUBSTR (l_org_rec.NAME, 1, 45)

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

9283: --
9284: l_output_string :=
9285: 'Org: '
9286: || SUBSTR (l_org_rec.NAME, 1, 45)
9287: || benutils.ID (l_ass_rec.organization_id);
9288: benutils.WRITE (p_text => l_output_string);
9289: --
9290: if hr_api.return_legislation_code(p_business_group_id) = 'US'
9291: then

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

9284: l_output_string :=
9285: 'Org: '
9286: || SUBSTR (l_org_rec.NAME, 1, 45)
9287: || benutils.ID (l_ass_rec.organization_id);
9288: benutils.WRITE (p_text => l_output_string);
9289: --
9290: if hr_api.return_legislation_code(p_business_group_id) = 'US'
9291: then
9292: l_output_string := 'Gre: ' || SUBSTR (l_org2_rec.NAME, 1, 45);

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

9289: --
9290: if hr_api.return_legislation_code(p_business_group_id) = 'US'
9291: then
9292: l_output_string := 'Gre: ' || SUBSTR (l_org2_rec.NAME, 1, 45);
9293: benutils.WRITE (p_text => l_output_string);
9294: else
9295: l_output_string := 'Gre: ' || 'Not applicable' ;
9296: benutils.WRITE (p_text => l_output_string);
9297: end if;

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

9292: l_output_string := 'Gre: ' || SUBSTR (l_org2_rec.NAME, 1, 45);
9293: benutils.WRITE (p_text => l_output_string);
9294: else
9295: l_output_string := 'Gre: ' || 'Not applicable' ;
9296: benutils.WRITE (p_text => l_output_string);
9297: end if;
9298: --
9299: l_output_string :=
9300: 'Loc: '

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

9298: --
9299: l_output_string :=
9300: 'Loc: '
9301: || SUBSTR (l_loc_rec.address_line_1, 1, 45)
9302: || benutils.ID (l_loc_rec.location_id);
9303: benutils.WRITE (p_text => l_output_string);
9304: --
9305: l_output_string := 'Pst: ' || SUBSTR (l_pad_rec.postal_code, 1, 45);
9306: benutils.WRITE (p_text => l_output_string);

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

9299: l_output_string :=
9300: 'Loc: '
9301: || SUBSTR (l_loc_rec.address_line_1, 1, 45)
9302: || benutils.ID (l_loc_rec.location_id);
9303: benutils.WRITE (p_text => l_output_string);
9304: --
9305: l_output_string := 'Pst: ' || SUBSTR (l_pad_rec.postal_code, 1, 45);
9306: benutils.WRITE (p_text => l_output_string);
9307: --

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

9302: || benutils.ID (l_loc_rec.location_id);
9303: benutils.WRITE (p_text => l_output_string);
9304: --
9305: l_output_string := 'Pst: ' || SUBSTR (l_pad_rec.postal_code, 1, 45);
9306: benutils.WRITE (p_text => l_output_string);
9307: --
9308: l_output_string :=
9309: 'Pyr: '
9310: || SUBSTR (l_pay_rec.payroll_name, 1, 45)

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

9307: --
9308: l_output_string :=
9309: 'Pyr: '
9310: || SUBSTR (l_pay_rec.payroll_name, 1, 45)
9311: || benutils.ID (l_pay_rec.payroll_id);
9312: benutils.WRITE (p_text => l_output_string);
9313:
9314: --
9315: IF g_debug

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

9308: l_output_string :=
9309: 'Pyr: '
9310: || SUBSTR (l_pay_rec.payroll_name, 1, 45)
9311: || benutils.ID (l_pay_rec.payroll_id);
9312: benutils.WRITE (p_text => l_output_string);
9313:
9314: --
9315: IF g_debug
9316: THEN

Line 9339: l_ptnl_ler benutils.g_ptnl_ler;

9335: --
9336: l_package varchar2(80);
9337: l_created_ler_id ben_ler_f.ler_id%type := null;
9338: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
9339: l_ptnl_ler benutils.g_ptnl_ler;
9340: l_effective_start_date date;
9341: l_effective_end_date date;
9342: l_rec benutils.g_active_life_event;
9343: l_param_rec benutils.g_batch_param_rec;

Line 9342: l_rec benutils.g_active_life_event;

9338: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
9339: l_ptnl_ler benutils.g_ptnl_ler;
9340: l_effective_start_date date;
9341: l_effective_end_date date;
9342: l_rec benutils.g_active_life_event;
9343: l_param_rec benutils.g_batch_param_rec;
9344: l_ler_rec benutils.g_ler;
9345: l_ler_batch_rec benutils.g_batch_ler_rec;
9346: l_ptnl_ler_for_per_id number;

Line 9343: l_param_rec benutils.g_batch_param_rec;

9339: l_ptnl_ler benutils.g_ptnl_ler;
9340: l_effective_start_date date;
9341: l_effective_end_date date;
9342: l_rec benutils.g_active_life_event;
9343: l_param_rec benutils.g_batch_param_rec;
9344: l_ler_rec benutils.g_ler;
9345: l_ler_batch_rec benutils.g_batch_ler_rec;
9346: l_ptnl_ler_for_per_id number;
9347: l_object_version_number number;

Line 9344: l_ler_rec benutils.g_ler;

9340: l_effective_start_date date;
9341: l_effective_end_date date;
9342: l_rec benutils.g_active_life_event;
9343: l_param_rec benutils.g_batch_param_rec;
9344: l_ler_rec benutils.g_ler;
9345: l_ler_batch_rec benutils.g_batch_ler_rec;
9346: l_ptnl_ler_for_per_id number;
9347: l_object_version_number number;
9348: l_ovn number;

Line 9345: l_ler_batch_rec benutils.g_batch_ler_rec;

9341: l_effective_end_date date;
9342: l_rec benutils.g_active_life_event;
9343: l_param_rec benutils.g_batch_param_rec;
9344: l_ler_rec benutils.g_ler;
9345: l_ler_batch_rec benutils.g_batch_ler_rec;
9346: l_ptnl_ler_for_per_id number;
9347: l_object_version_number number;
9348: l_ovn number;
9349: l_commit number;

Line 9386: l_gsp_ler_rec benutils.g_ler;

9382: l_use_mode varchar2(80);
9383: l_asnd_lf_evt_dt date;
9384: l_cv_ler_id number;
9385: l_cv_lf_evt_ocrd_dt date;
9386: l_gsp_ler_rec benutils.g_ler;
9387: l_validate boolean;
9388: --
9389: begin
9390: --

Line 9423: benutils.get_batch_parameters

9419: -- without this.
9420: ben_env_object.setenv(p_lf_evt_ocrd_dt => p_effective_date);
9421: -- Add ended
9422: --
9423: benutils.get_batch_parameters
9424: (p_benefit_action_id => benutils.g_benefit_action_id
9425: ,p_rec => l_param_rec
9426: );
9427: --

Line 9424: (p_benefit_action_id => benutils.g_benefit_action_id

9420: ben_env_object.setenv(p_lf_evt_ocrd_dt => p_effective_date);
9421: -- Add ended
9422: --
9423: benutils.get_batch_parameters
9424: (p_benefit_action_id => benutils.g_benefit_action_id
9425: ,p_rec => l_param_rec
9426: );
9427: --
9428: benutils.get_batch_parameters

Line 9428: benutils.get_batch_parameters

9424: (p_benefit_action_id => benutils.g_benefit_action_id
9425: ,p_rec => l_param_rec
9426: );
9427: --
9428: benutils.get_batch_parameters
9429: (p_benefit_action_id => benutils.g_benefit_action_id
9430: ,p_rec => l_param_rec
9431: );
9432: --

Line 9429: (p_benefit_action_id => benutils.g_benefit_action_id

9425: ,p_rec => l_param_rec
9426: );
9427: --
9428: benutils.get_batch_parameters
9429: (p_benefit_action_id => benutils.g_benefit_action_id
9430: ,p_rec => l_param_rec
9431: );
9432: --
9433: -- CWB Changes : Added mode ABSENCES mode(M) added. Added GRADE/STEP mode

Line 9463: benutils.get_ler

9459: p_effective_date);
9460: --
9461: elsif p_mode = 'G' then
9462: --
9463: benutils.get_ler
9464: (p_business_group_id => p_business_group_id,
9465: p_typ_cd => 'GSP',
9466: p_effective_date => p_effective_date,
9467: p_lf_evt_oper_cd => p_lf_evt_oper_cd, /* GSP Rate Sync */

Line 9631: benutils.get_active_life_event

9627: if p_mode <> 'W' then
9628: --
9629: if p_mode = 'G' then
9630: --
9631: benutils.get_active_life_event
9632: (p_person_id => p_person_id,
9633: p_business_group_id => p_business_group_id,
9634: p_effective_date => p_effective_date,
9635: p_lf_event_mode => 'G',

Line 9640: benutils.get_active_life_event

9636: p_rec => l_rec);
9637: --
9638: elsif p_mode = 'M' then
9639: --
9640: benutils.get_active_life_event
9641: (p_person_id => p_person_id,
9642: p_business_group_id => p_business_group_id,
9643: p_effective_date => p_effective_date,
9644: p_lf_event_mode => 'M',

Line 9650: benutils.get_active_life_event

9646: --
9647: elsif p_mode = 'I' then
9648: --
9649: -- iRec
9650: benutils.get_active_life_event
9651: (p_person_id => p_person_id,
9652: p_business_group_id => p_business_group_id,
9653: p_effective_date => p_effective_date,
9654: p_lf_event_mode => 'I',

Line 9659: benutils.get_active_life_event

9655: p_rec => l_rec);
9656: --
9657: else
9658: --
9659: benutils.get_active_life_event
9660: (p_person_id => p_person_id,
9661: p_business_group_id => p_business_group_id,
9662: p_effective_date => p_effective_date,
9663: p_rec => l_rec);

Line 9670: benutils.get_active_life_event

9666: --
9667: else
9668: --
9669: -- Is it necessary in this procedure as this proc may not be called in W mode.
9670: benutils.get_active_life_event
9671: (p_person_id => p_person_id,
9672: p_business_group_id => p_business_group_id,
9673: p_effective_date => p_effective_date,
9674: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

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

9739: --
9740: -- PB : 5422 : (p_mode = 'L' and l_rec.typ_cd in ('SCHEDDO', 'SCHEDDA','SCHEDDU','UNRSTR'))
9741: then
9742: --
9743: benutils.write(p_text => 'Winner Life Event : '|| l_rec.name||
9744: benutils.id(l_rec.ler_id) ||
9745: ' , Supplied Mode : ' || p_mode);
9746: --
9747: -- Raise error for this person.

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

9740: -- PB : 5422 : (p_mode = 'L' and l_rec.typ_cd in ('SCHEDDO', 'SCHEDDA','SCHEDDU','UNRSTR'))
9741: then
9742: --
9743: benutils.write(p_text => 'Winner Life Event : '|| l_rec.name||
9744: benutils.id(l_rec.ler_id) ||
9745: ' , Supplied Mode : ' || p_mode);
9746: --
9747: -- Raise error for this person.
9748: --

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

9760: -- return null value. Hence set the values.
9761: --
9762: g_rec.text := fnd_message.get;
9763: g_rec.error_message_code := 'BEN_92145_MODE_LE_DIFFER';
9764: benutils.write(p_text => g_rec.text );
9765: --
9766: -- Bug 2836770
9767: --
9768: -- Bug : 3658807

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

9774: raise g_record_error;
9775: --
9776: end if;
9777: --
9778: benutils.write(p_text => 'Life Event Occured Date: '||
9779: l_rec.lf_evt_ocrd_dt);
9780: if l_created_ler_id <> nvl(p_ler_id,-1) then
9781: --
9782: -- Get life event name we are dealing with, put in global structure

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

9781: --
9782: -- Get life event name we are dealing with, put in global structure
9783: --
9784: p_ler_id := l_created_ler_id;
9785: benutils.write(p_text => 'Winner Life Event : '||
9786: l_rec.name||
9787: benutils.id(l_rec.ler_id));
9788: --
9789: end if;

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

9783: --
9784: p_ler_id := l_created_ler_id;
9785: benutils.write(p_text => 'Winner Life Event : '||
9786: l_rec.name||
9787: benutils.id(l_rec.ler_id));
9788: --
9789: end if;
9790: --
9791: ben_env_object.setenv(p_lf_evt_ocrd_dt => l_rec.lf_evt_ocrd_dt);

Line 9835: (p_benefit_action_id => benutils.g_benefit_action_id

9831: hr_utility.set_location (l_package||' Bef BCOL ' ,25);
9832: end if;
9833:
9834: ben_comp_object_list.build_comp_object_list
9835: (p_benefit_action_id => benutils.g_benefit_action_id
9836: ,p_comp_selection_rule_id => l_param_rec.comp_selection_rl
9837: ,p_effective_date => l_rec.lf_evt_ocrd_dt
9838: ,p_pgm_id => l_param_rec.pgm_id
9839: ,p_business_group_id => l_param_rec.business_group_id

Line 9851: ,p_thread_id => benutils.g_thread_id

9847: ,p_pl_typ_id => l_param_rec.pl_typ_id
9848: ,p_opt_id => l_param_rec.opt_id
9849: ,p_eligy_prfl_id => l_param_rec.eligy_prfl_id
9850: ,p_vrbl_rt_prfl_id => l_param_rec.vrbl_rt_prfl_id
9851: ,p_thread_id => benutils.g_thread_id
9852: -- PB : 5422 :
9853: ,p_mode => nvl(ben_manage_life_events.g_modified_mode,l_param_rec.mode_cd)
9854: -- ,p_mode => l_param_rec.mode_cd
9855: ,p_lmt_prpnip_by_org_flag => l_param_rec.lmt_prpnip_by_org_flag

Line 9871: benutils.get_active_life_event

9867: 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') */
9868: --
9869: if p_mode = 'D' then
9870: --
9871: benutils.get_active_life_event
9872: (p_person_id => p_person_id,
9873: p_business_group_id => p_business_group_id,
9874: p_effective_date => p_effective_date,
9875: p_lf_event_mode => 'U',

Line 9891: benutils.get_ler

9887: end if;
9888: --
9889: -- if p_mode in ('U','D') then -- Bug 6321565
9890: --
9891: benutils.get_ler
9892: (p_business_group_id => p_business_group_id,
9893: p_typ_cd => 'SCHEDDU',
9894: p_effective_date => p_effective_date,
9895: p_rec => l_ler_rec);

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

9962: l_ler_batch_rec.cvrge_rt_prem_flag := 'N';
9963: l_ler_batch_rec.business_group_id := p_business_group_id;
9964: l_ler_batch_rec.effective_date := p_effective_date;
9965: --
9966: benutils.write(p_rec => l_ler_batch_rec);
9967: if g_debug then
9968: hr_utility.set_location (l_package,60);
9969: end if;
9970: if l_rec.per_in_ler_id is null then

Line 10009: (p_benefit_action_id => benutils.g_benefit_action_id

10005: --
10006: if p_mode = 'R' then
10007: --
10008: ben_comp_object_list.build_comp_object_list
10009: (p_benefit_action_id => benutils.g_benefit_action_id
10010: ,p_comp_selection_rule_id => l_param_rec.comp_selection_rl
10011: ,p_effective_date => p_effective_date
10012: ,p_pgm_id => l_param_rec.pgm_id
10013: ,p_business_group_id => l_param_rec.business_group_id

Line 10023: ,p_thread_id => benutils.g_thread_id

10019: ,p_pl_typ_id => l_param_rec.pl_typ_id
10020: ,p_opt_id => l_param_rec.opt_id
10021: ,p_eligy_prfl_id => l_param_rec.eligy_prfl_id
10022: ,p_vrbl_rt_prfl_id => l_param_rec.vrbl_rt_prfl_id
10023: ,p_thread_id => benutils.g_thread_id
10024: ,p_mode => 'U'
10025: ,p_lmt_prpnip_by_org_flag => l_param_rec.lmt_prpnip_by_org_flag
10026: ,p_person_id => p_person_id
10027: );

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

10030: --
10031: end if;
10032: --
10033: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10034: fnd_message.set_token('PROC','benutils.get_batch_parameters');
10035: ben_enrolment_requirements.g_electable_choice_created := false;
10036: ben_enrolment_requirements.g_any_choice_created := false;
10037: ben_enrolment_requirements.g_auto_choice_created := false;
10038: ben_determine_dpnt_eligibility.g_dpnt_ineligible := false;

Line 10051: (p_benefit_action_id => benutils.g_benefit_action_id

10047: if g_debug then
10048: hr_utility.set_location (' Temp BCOL '||l_package,10);
10049: end if;
10050: ben_comp_object_list.build_comp_object_list
10051: (p_benefit_action_id => benutils.g_benefit_action_id
10052: ,p_comp_selection_rule_id => l_param_rec.comp_selection_rl
10053: ,p_effective_date => p_effective_date
10054: ,p_pgm_id => l_param_rec.pgm_id
10055: ,p_business_group_id => l_param_rec.business_group_id

Line 10067: ,p_thread_id => benutils.g_thread_id

10063: ,p_pl_typ_id => l_param_rec.pl_typ_id
10064: ,p_opt_id => l_param_rec.opt_id
10065: ,p_eligy_prfl_id => l_param_rec.eligy_prfl_id
10066: ,p_vrbl_rt_prfl_id => l_param_rec.vrbl_rt_prfl_id
10067: ,p_thread_id => benutils.g_thread_id
10068: -- PB : 5422 :
10069: ,p_mode => p_mode
10070: -- ,p_mode => l_param_rec.mode_cd
10071: ,p_lmt_prpnip_by_org_flag => l_param_rec.lmt_prpnip_by_org_flag

Line 10164: l_rec benutils.g_active_life_event;

10160: where per_in_ler_id = p_per_in_ler_id
10161: and (popl.pgm_id = p_pgm_id or
10162: popl.pl_id = p_pl_id);
10163: --
10164: l_rec benutils.g_active_life_event;
10165: l_lf_rec benutils.g_active_life_event;
10166: --
10167: cursor c_ptnl is
10168: select a.ptnl_ler_for_per_id ptnl_ler_for_per_id,

Line 10165: l_lf_rec benutils.g_active_life_event;

10161: and (popl.pgm_id = p_pgm_id or
10162: popl.pl_id = p_pl_id);
10163: --
10164: l_rec benutils.g_active_life_event;
10165: l_lf_rec benutils.g_active_life_event;
10166: --
10167: cursor c_ptnl is
10168: select a.ptnl_ler_for_per_id ptnl_ler_for_per_id,
10169: a.object_version_number object_version_number

Line 10660: benutils.get_active_life_event

10656: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
10657: if (l_mode = 'U'or l_mode = 'R' or l_mode = 'D') then
10658: --
10659: if l_mode <> 'D' then
10660: benutils.get_active_life_event
10661: (p_person_id => p_person_id,
10662: p_business_group_id => p_business_group_id,
10663: p_effective_date => p_effective_date,
10664: p_lf_event_mode => 'U',

Line 10669: benutils.get_active_life_event

10665: p_rec => l_rec);
10666: --
10667: else
10668: --
10669: benutils.get_active_life_event
10670: (p_person_id => p_person_id,
10671: p_business_group_id => p_business_group_id,
10672: p_effective_date => p_effective_date,
10673: p_lf_event_mode => 'D',

Line 10678: benutils.get_active_life_event

10674: p_rec => l_rec);
10675: --
10676: end if;
10677: --
10678: benutils.get_active_life_event
10679: (p_person_id => p_person_id,
10680: p_business_group_id => p_business_group_id,
10681: p_effective_date => p_effective_date,
10682: p_rec => l_lf_rec);

Line 10691: benutils.get_active_life_event

10687: -- CWB Changes .
10688: --
10689: if l_mode = 'W' then
10690: --
10691: benutils.get_active_life_event
10692: (p_person_id => p_person_id,
10693: p_business_group_id => p_business_group_id,
10694: p_effective_date => p_effective_date,
10695: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 10701: benutils.get_active_life_event

10697: p_rec => l_rec);
10698: --
10699: elsif l_mode = 'G' then
10700: --
10701: benutils.get_active_life_event
10702: (p_person_id => p_person_id,
10703: p_business_group_id => p_business_group_id,
10704: p_effective_date => p_effective_date,
10705: p_lf_event_mode => 'G',

Line 10710: benutils.get_active_life_event

10706: p_rec => l_rec);
10707: --
10708: elsif l_mode = 'M' then
10709: --
10710: benutils.get_active_life_event
10711: (p_person_id => p_person_id,
10712: p_business_group_id => p_business_group_id,
10713: p_effective_date => p_effective_date,
10714: p_lf_event_mode => 'M',

Line 10720: benutils.get_active_life_event

10716: --
10717: elsif l_mode = 'I' then
10718: --
10719: -- iRec
10720: benutils.get_active_life_event
10721: (p_person_id => p_person_id,
10722: p_business_group_id => p_business_group_id,
10723: p_effective_date => p_effective_date,
10724: p_lf_event_mode => 'I',

Line 10729: benutils.get_active_life_event

10725: p_rec => l_rec);
10726: --
10727: else
10728: --
10729: benutils.get_active_life_event
10730: (p_person_id => p_person_id,
10731: p_business_group_id => p_business_group_id,
10732: p_effective_date => p_effective_date,
10733: p_rec => l_rec);

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

11282: g_action_rec.ler_id := p_ler_id;
11283: g_action_rec.object_version_number := p_object_version_number;
11284: g_action_rec.effective_date := p_effective_date;
11285: --
11286: benutils.write(p_rec => g_action_rec);
11287: --
11288: return;
11289: --
11290: elsif l_evaluate_eligibility

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

12093: end if;
12094: --
12095: end if;
12096: -- end of mode 'R'
12097: benutils.write(p_text => g_output_string);
12098: --
12099: -- Check if the last row of the comp object list has been reached
12100: -- otherwise navigate to the next row
12101: --

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

12590: p_actn_typ_id => null,
12591: p_enrt_mthd_cd => null,
12592: p_business_group_id => p_business_group_id,
12593: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12594: p_proc_cd1 => benutils.iftrue(l_mode = 'U'
12595: ,null
12596: ,'MLEPECP'),
12597: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12598: p_proc_cd2 => benutils.iftrue(l_mode = 'U'

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

12594: p_proc_cd1 => benutils.iftrue(l_mode = 'U'
12595: ,null
12596: ,'MLEPECP'),
12597: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12598: p_proc_cd2 => benutils.iftrue(l_mode = 'U'
12599: ,null
12600: ,'MLEAUTOENRT'),
12601: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12602: p_proc_cd3 => benutils.iftrue(l_mode = 'U'

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

12598: p_proc_cd2 => benutils.iftrue(l_mode = 'U'
12599: ,null
12600: ,'MLEAUTOENRT'),
12601: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12602: p_proc_cd3 => benutils.iftrue(l_mode = 'U'
12603: ,null
12604: ,'MLERTCHG'),
12605: p_proc_cd4 => 'MLEENDENRT',
12606: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071

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

12603: ,null
12604: ,'MLERTCHG'),
12605: p_proc_cd4 => 'MLEENDENRT',
12606: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
12607: p_proc_cd5 => benutils.iftrue(l_mode = 'U'
12608: ,null
12609: ,'MLENOIMP'),
12610: p_proc_cd6 => 'MLEELIG',
12611: p_proc_cd7 => 'MLEINELIG',

Line 12707: benutils.get_active_life_event

12703: -- Set life event to processed, only update the per_in_ler_stat_cd
12704: --
12705: if l_mode = 'M' then
12706: --
12707: benutils.get_active_life_event
12708: (p_person_id => p_person_id,
12709: p_business_group_id => p_business_group_id,
12710: p_effective_date => p_effective_date,
12711: p_lf_event_mode => 'M',

Line 12716: benutils.get_active_life_event

12712: p_rec => l_rec);
12713: --
12714: else
12715: --
12716: benutils.get_active_life_event
12717: (p_person_id => p_person_id,
12718: p_business_group_id => p_business_group_id,
12719: p_effective_date => p_effective_date,
12720: p_rec => l_rec);

Line 12725: benutils.get_active_life_event will not return life event. Added below code to get the Life event details*/

12721: --
12722: end if;
12723:
12724: /* Bug 12711900 : If there is no electability life event will directly move to Processed state. So calling
12725: benutils.get_active_life_event will not return life event. Added below code to get the Life event details*/
12726: if(not ben_enrolment_requirements.g_electable_choice_created) then
12727: hr_utility.set_location('Getting pil_id ',10);
12728: declare
12729: cursor c_get_pil_id is

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

12848: --
12849: -- Update status of life event to opened and closed as this is what has
12850: -- happened unless the life event was replaced.
12851: --
12852: benutils.update_life_event_cache(p_open_and_closed => 'Y');
12853: --
12854: end if;
12855: --
12856: if (p_ler_id is not null and

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

13076: raise;
13077: end;
13078: end if; --end irec2
13079: --
13080: benutils.write(p_text => benutils.g_banner_asterix);
13081: --
13082: p_person_count := p_person_count +1;
13083: --
13084: g_action_rec.person_action_id := p_person_action_id;

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

13086: g_action_rec.ler_id := p_ler_id;
13087: g_action_rec.object_version_number := p_object_version_number;
13088: g_action_rec.effective_date := p_effective_date;
13089: --
13090: benutils.write(p_rec => g_action_rec);
13091: --
13092: if g_debug then
13093: hr_utility.set_location ('Leaving '||l_package,10);
13094: end if;

Line 13122: l_rec benutils.g_active_life_event;

13118: ) is
13119: --
13120: l_package varchar2(80);
13121: l_ler_id number := p_ler_id;
13122: l_rec benutils.g_active_life_event;
13123: l_env ben_env_object.g_global_env_rec_type;
13124: l_encoded_message varchar2(2000);
13125: l_app_short_name varchar2(2000);
13126: l_message_name varchar2(2000);

Line 13142: benutils.set_cache_record_position;

13138: --
13139: -- Create savepoint for error handling purposes
13140: --
13141: savepoint process_life_event_savepoint;
13142: benutils.set_cache_record_position;
13143:
13144: -- iRec
13145: -- In iRecruitment mode, as multiple life events for a person could be processed for
13146: -- single person on a given day, clear down person cache. This change is necessary as

Line 13215: benutils.get_active_life_event

13211: if p_mode not in ('A','P','S','T') then
13212: --
13213: if p_mode in ( 'R', 'U') then
13214: --
13215: benutils.get_active_life_event
13216: (p_person_id => p_person_id,
13217: p_business_group_id => p_business_group_id,
13218: p_effective_date => p_effective_date,
13219: p_lf_event_mode => 'U',

Line 13228: benutils.get_active_life_event

13224: -- CWB Changes .
13225: --
13226: if p_mode = 'W' then
13227: --
13228: benutils.get_active_life_event
13229: (p_person_id => p_person_id,
13230: p_business_group_id => p_business_group_id,
13231: p_effective_date => p_effective_date,
13232: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 13238: benutils.get_active_life_event

13234: p_rec => l_rec);
13235: --
13236: elsif p_mode = 'G' then
13237: --
13238: benutils.get_active_life_event
13239: (p_person_id => p_person_id,
13240: p_business_group_id => p_business_group_id,
13241: p_effective_date => p_effective_date,
13242: p_lf_event_mode => 'G',

Line 13247: benutils.get_active_life_event

13243: p_rec => l_rec);
13244: --
13245: elsif p_mode = 'M' then
13246: --
13247: benutils.get_active_life_event
13248: (p_person_id => p_person_id,
13249: p_business_group_id => p_business_group_id,
13250: p_effective_date => p_effective_date,
13251: p_lf_event_mode => 'M',

Line 13256: benutils.get_active_life_event

13252: p_rec => l_rec);
13253: --
13254: else
13255: --
13256: benutils.get_active_life_event
13257: (p_person_id => p_person_id,
13258: p_business_group_id => p_business_group_id,
13259: p_effective_date => p_effective_date,
13260: p_rec => l_rec);

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

13330: end if;
13331: --
13332: if g_debug then
13333: hr_utility.set_location ('Calling pqh ranking proc ',10);
13334: hr_utility.set_location ('p_benefit_action_id=>'||benutils.g_benefit_action_id,10);
13335: hr_utility.set_location ('p_module=>'||l_module,10);
13336: hr_utility.set_location ('p_per_in_ler_id=>'||l_rec.per_in_ler_id,10);
13337: hr_utility.set_location ('p_person_id=>'||p_person_id,10);
13338: hr_utility.set_location ('p_effective_date=>'||l_rec.lf_evt_ocrd_dt,10);

Line 13342: p_benefit_action_id => benutils.g_benefit_action_id

13338: hr_utility.set_location ('p_effective_date=>'||l_rec.lf_evt_ocrd_dt,10);
13339: end if;
13340: --
13341: pqh_ranking.compute_total_score (
13342: p_benefit_action_id => benutils.g_benefit_action_id
13343: ,p_module => l_module
13344: ,p_per_in_ler_id => l_rec.per_in_ler_id
13345: ,p_person_id => p_person_id
13346: ,p_effective_date => l_rec.lf_evt_ocrd_dt );

Line 13379: benutils.rollback_cache;

13375: end;
13376: --
13377: -- Roll cache to savepoint
13378: --
13379: benutils.rollback_cache;
13380: --
13381: -- WW1178659 - Set the life event occured date to the effective
13382: -- date because the life event occured date may not have been
13383: -- derived. We can do this because national identifier is

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

13408: --
13409: g_rec.error_message_code := nvl(l_message_name , g_rec.error_message_code);
13410: g_rec.text := nvl(fnd_message.get , g_rec.text );
13411: --
13412: --benutils.write(p_text => g_rec.text); /* GSP Rate Sync */
13413: benutils.write(p_rec => g_rec);
13414: --
13415: -- benutils.write_table_and_file(p_table => true,
13416: -- p_file => true);

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

13409: g_rec.error_message_code := nvl(l_message_name , g_rec.error_message_code);
13410: g_rec.text := nvl(fnd_message.get , g_rec.text );
13411: --
13412: --benutils.write(p_text => g_rec.text); /* GSP Rate Sync */
13413: benutils.write(p_rec => g_rec);
13414: --
13415: -- benutils.write_table_and_file(p_table => true,
13416: -- p_file => true);
13417:

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

13411: --
13412: --benutils.write(p_text => g_rec.text); /* GSP Rate Sync */
13413: benutils.write(p_rec => g_rec);
13414: --
13415: -- benutils.write_table_and_file(p_table => true,
13416: -- p_file => true);
13417:
13418: -- Bug 2836770
13419: g_action_rec.person_action_id := p_person_action_id;

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

13421: g_action_rec.ler_id := p_ler_id;
13422: g_action_rec.object_version_number := p_object_version_number;
13423: g_action_rec.effective_date := p_effective_date;
13424: --
13425: benutils.write(p_rec => g_action_rec);
13426: --
13427: p_error_person_count := p_error_person_count +1;
13428: --
13429: -- bug 7374364

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

13431: --
13432: if p_error_person_count = g_max_errors_allowed then
13433: --
13434: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
13435: benutils.write(p_text => fnd_message.get);
13436: if g_debug then
13437: hr_utility.set_location ('PLE g_record_error Err Lim '||l_package,10);
13438: end if;
13439: --

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

13439: --
13440: -- Write the last bit of information for the thread before
13441: -- the rollback fires when we raise the error.
13442: --
13443: benutils.write_table_and_file(p_table => true,
13444: p_file => true);
13445: commit;
13446: --
13447: raise;

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

13468: --
13469: -- bug 7374364
13470: ben_use_cvg_rt_date.clear_fonm_globals;
13471: --
13472: benutils.write(p_rec => g_action_rec);
13473: --
13474: p_person_count := p_person_count +1;
13475: --
13476: when g_life_event_after then

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

13490: --
13491: -- bug 7374364
13492: ben_use_cvg_rt_date.clear_fonm_globals;
13493: --
13494: benutils.write(p_rec => g_action_rec);
13495: --
13496: p_person_count := p_person_count +1;
13497: --
13498: when app_exception.application_exception then

Line 13507: benutils.rollback_cache;

13503: --
13504: -- Update person action to errored as record has an error
13505: --
13506: rollback to process_life_event_savepoint;
13507: benutils.rollback_cache;
13508: --
13509: -- Roll cache to savepoint
13510: --
13511: ben_env_object.setenv(p_lf_evt_ocrd_dt => p_effective_date);

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

13524: g_rec.rep_typ_cd := 'ERROR';
13525: g_rec.error_message_code := l_message_name;
13526: g_rec.national_identifier := l_per_rec.national_identifier;
13527: g_rec.text := fnd_message.get;
13528: benutils.write(p_text => g_rec.text);
13529: benutils.write(p_rec => g_rec);
13530: --
13531: g_action_rec.person_action_id := p_person_action_id;
13532: g_action_rec.action_status_cd := 'E';

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

13525: g_rec.error_message_code := l_message_name;
13526: g_rec.national_identifier := l_per_rec.national_identifier;
13527: g_rec.text := fnd_message.get;
13528: benutils.write(p_text => g_rec.text);
13529: benutils.write(p_rec => g_rec);
13530: --
13531: g_action_rec.person_action_id := p_person_action_id;
13532: g_action_rec.action_status_cd := 'E';
13533: g_action_rec.ler_id := p_ler_id;

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

13536: -- bug 7374364
13537: ben_use_cvg_rt_date.clear_fonm_globals;
13538: --
13539: --
13540: benutils.write(p_rec => g_action_rec);
13541: --
13542: p_error_person_count := p_error_person_count +1;
13543: --
13544: if p_error_person_count = g_max_errors_allowed then

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

13543: --
13544: if p_error_person_count = g_max_errors_allowed then
13545: --
13546: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
13547: benutils.write(p_text => fnd_message.get);
13548: --
13549: -- Write the last bit of information for the thread before
13550: -- the rollback fires when we raise the error.
13551: --

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

13548: --
13549: -- Write the last bit of information for the thread before
13550: -- the rollback fires when we raise the error.
13551: --
13552: benutils.write_table_and_file(p_table => true,
13553: p_file => true);
13554: commit;
13555: --
13556: raise;

Line 13569: benutils.rollback_cache;

13565: --
13566: -- Update person action to errored as record has an error
13567: --
13568: rollback to process_life_event_savepoint;
13569: benutils.rollback_cache;
13570: --
13571: g_rec.rep_typ_cd := 'FATAL';
13572: g_rec.text := sqlerrm;
13573: benutils.write(p_rec => g_rec);

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

13569: benutils.rollback_cache;
13570: --
13571: g_rec.rep_typ_cd := 'FATAL';
13572: g_rec.text := sqlerrm;
13573: benutils.write(p_rec => g_rec);
13574: --
13575: g_action_rec.person_action_id := p_person_action_id;
13576: g_action_rec.action_status_cd := 'E';
13577: g_action_rec.ler_id := p_ler_id;

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

13581: -- bug 7374364
13582: ben_use_cvg_rt_date.clear_fonm_globals;
13583: --
13584: --
13585: benutils.write(p_rec => g_action_rec);
13586: --
13587:
13588: p_error_person_count := p_error_person_count +1;
13589: --

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

13670: --
13671: if g_debug then
13672: hr_utility.set_location (l_proc||' Write ',35);
13673: end if;
13674: benutils.write(p_rec => g_proc_rec);
13675: --
13676: end write_bft_statistics;
13677: --
13678: end ben_manage_life_events;