DBA Data[Home] [Help]

APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on BENUTILS

Line 1597: VALUES (benutils.g_benefit_action_id

1593: , asgn_change_reason
1594: , pending_workflow
1595: , new_rpt
1596: , prev_eev_screen_entry_value)
1597: VALUES (benutils.g_benefit_action_id
1598: , g_cache_cwb_rpt_person (i).person_rate_id
1599: , g_cache_cwb_rpt_person (i).pl_id
1600: , g_cache_cwb_rpt_person (i).person_id
1601: , g_cache_cwb_rpt_person (i).country_code

Line 1778: VALUES (benutils.g_benefit_action_id

1774: , status_cd
1775: , lf_evt_closed_flag
1776: , cwb_rpt_detail_id
1777: )
1778: VALUES (benutils.g_benefit_action_id
1779: , -9999
1780: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).person_id
1781: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).country_code
1782: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).bg_id

Line 2303: benutils.write(p_text => l_string);

2299: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
2300: fnd_message.set_token('PARMA',l_element_name);
2301: fnd_message.set_token('PARMB',to_char(l_effective_date));
2302: l_string := fnd_message.get;
2303: benutils.write(p_text => l_string);
2304: --
2305: end if;
2306: --
2307: --

Line 3211: IF(benutils.get_message_name = 'BEN_93371_RATING_EXST_FOR_DATE') THEN

3207: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
3208: g_person_errored := TRUE;
3209: WRITE(l_perf_person_rec.error_or_warning_text);
3210: ROLLBACK TO process_rating;
3211: IF(benutils.get_message_name = 'BEN_93371_RATING_EXST_FOR_DATE') THEN
3212: --l_perf_person_rec.error_or_warning_text := fnd_message.get;
3213: write_m ('Time after processing rating '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
3214: WRITE('Failed Performance rating is '||l_perf_person_rec.performance_rating);
3215: l_rating_status := 'CWB_PERF_SUS';

Line 3881: WRITE (benutils.get_message_name);

3877: g_cache_cwb_sum_person (p_person_id).country_code := l_emp_num_and_emp_name.legislation_code;
3878: -- g_cache_cwb_rpt_person (g_cache_cwb_rpt_person.COUNT + 1) := g_cwb_rpt_person;
3879:
3880: END IF;
3881: WRITE (benutils.get_message_name);
3882: WRITE (fnd_message.get);
3883: WRITE (SQLERRM||' in process_person');
3884: RAISE ben_batch_utils.g_record_error;
3885: END;

Line 3918: benutils.g_benefit_action_id := p_benefit_action_id;

3914: l_chunk_size NUMBER;
3915: g_max_errors_allowed NUMBER;
3916: BEGIN
3917: g_proc := 'do_multithread';
3918: benutils.g_benefit_action_id := p_benefit_action_id;
3919: WRITE (g_actn);
3920: write_h ('=====================do_multithread=============');
3921: write_h ('||Parameter Description ');
3922: write_h ('||p_effective_dates - ' || p_effective_date);

Line 3950: benutils.get_parameter (p_business_group_id => l_parm.business_group_id

3946: INTO l_parm;
3947:
3948: CLOSE c_parameter;
3949:
3950: benutils.get_parameter (p_business_group_id => l_parm.business_group_id
3951: , p_batch_exe_cd => 'BENCWBBP'
3952: , p_threads => l_threads
3953: , p_chunk_size => l_chunk_size
3954: , p_max_errors => g_max_errors_allowed

Line 4239: g_actn := 'Calling benutils.get_parameter...';

4235: g_actn := 'Calling ben_batch_utils.ini...';
4236: WRITE (g_actn);
4237: write_h ('ben_batch_utils.ini with PROC_INFO');
4238: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
4239: g_actn := 'Calling benutils.get_parameter...';
4240: WRITE (g_actn);
4241: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBBP' || ' '
4242: || g_max_errors_allowed
4243: );

Line 4241: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBBP' || ' '

4237: write_h ('ben_batch_utils.ini with PROC_INFO');
4238: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
4239: g_actn := 'Calling benutils.get_parameter...';
4240: WRITE (g_actn);
4241: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBBP' || ' '
4242: || g_max_errors_allowed
4243: );
4244: benutils.get_parameter (p_business_group_id => p_bg_id
4245: , p_batch_exe_cd => 'BENCWBBP'

Line 4244: benutils.get_parameter (p_business_group_id => p_bg_id

4240: WRITE (g_actn);
4241: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBBP' || ' '
4242: || g_max_errors_allowed
4243: );
4244: benutils.get_parameter (p_business_group_id => p_bg_id
4245: , p_batch_exe_cd => 'BENCWBBP'
4246: , p_threads => l_threads
4247: , p_chunk_size => l_chunk_size
4248: , p_max_errors => g_max_errors_allowed

Line 4251: benutils.g_thread_id := 99; -- need to investigate why this is needed

4247: , p_chunk_size => l_chunk_size
4248: , p_max_errors => g_max_errors_allowed
4249: );
4250: write_h ('Values of l_threads is ' || l_threads || ' and l_chunk_size is ' || l_chunk_size);
4251: benutils.g_thread_id := 99; -- need to investigate why this is needed
4252: g_actn := 'Creating benefit actions...';
4253: WRITE (g_actn);
4254: WRITE ('Time'||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
4255: write_h ('=====================Benefit Actions=======================');

Line 4293: benutils.g_benefit_action_id := l_benefit_action_id;

4289: , p_bft_attribute7 => p_is_open_access
4290: , p_bft_attribute8 => p_send_fyi
4291: );
4292: write ('Benefit Action Id is ' || l_benefit_action_id);
4293: benutils.g_benefit_action_id := l_benefit_action_id;
4294: g_actn := 'Inserting Person Actions...';
4295: WRITE (g_actn);
4296: write_m ('Time before processing the person selections '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
4297: