[Home] [Help]
25: * x-bg. Modified the name of the routines
26: * of default_comp_obj and process_default
27: * _enrt.
28: * 10-MAR-02 aprabhak 115.6 The salary conversions now uses the newly
29: * developed benutils routine plan_to_basis_
30: * _conversion. Change the position of the
31: * p_preson_id in the process routine.
32: * 11-MAR-02 aprabhak 115.7 added the per_pay_bases to the element
33: * cursor and approved condition to the
1836: , asgn_change_reason
1837: , pending_workflow
1838: , new_rpt
1839: , prev_eev_screen_entry_value)
1840: VALUES (benutils.g_benefit_action_id
1841: , g_cache_cwb_rpt_person (i).person_rate_id
1842: , g_cache_cwb_rpt_person (i).pl_id
1843: , g_cache_cwb_rpt_person (i).person_id
1844: , g_cache_cwb_rpt_person (i).country_code
2017: , status_cd
2018: , lf_evt_closed_flag
2019: , cwb_rpt_detail_id
2020: )
2021: VALUES (benutils.g_benefit_action_id
2022: , -9999
2023: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).person_id
2024: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).country_code
2025: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).bg_id
4218: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4219: g_person_errored := TRUE;
4220: WRITE(l_perf_person_rec.error_or_warning_text);
4221: ROLLBACK TO process_rating;
4222: IF(benutils.get_message_name = 'BEN_93371_RATING_EXST_FOR_DATE') THEN
4223: --l_perf_person_rec.error_or_warning_text := fnd_message.get;
4224: write_m ('Time after processing rating '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
4225: WRITE('Failed Performance rating is '||l_perf_person_rec.performance_rating);
4226: l_rating_status := 'CWB_PERF_SUS';
4814: IF g_cwb_rpt_person.group_oipl_id <> -1 THEN
4815: g_cwb_rpt_person.opt_name := g_cache_group_options (g_cwb_rpt_person.group_oipl_id);
4816: END IF;
4817:
4818: g_cwb_rpt_person.error_or_warning_text := substr(benutils.get_message_name || ' '||fnd_message.get,1,2000);
4819:
4820: IF l_comp_error THEN
4821: g_cwb_rpt_person.error_or_warning_text := substr(g_cwb_rpt_person.error_or_warning_text ||
4822: ' '||'Person ' || p_person_id || ' failed for compensation',1,2000);
4841: g_cache_cwb_sum_person (p_person_id).country_code := l_emp_num_and_emp_name.legislation_code;
4842: -- g_cache_cwb_rpt_person (g_cache_cwb_rpt_person.COUNT + 1) := g_cwb_rpt_person;
4843:
4844: END IF;
4845: WRITE (benutils.get_message_name);
4846: WRITE (fnd_message.get);
4847: WRITE (SQLERRM||' in process_person');
4848: RAISE ben_batch_utils.g_record_error;
4849: END;
4882: dbms_lock.sleep(30);
4883: end if;*/
4884: g_actn := 'Started do_multithread for the thread ' || p_thread_id;
4885: g_proc := 'do_multithread';
4886: benutils.g_benefit_action_id := p_benefit_action_id;
4887: WRITE (g_actn);
4888: write_h ('=====================do_multithread=============');
4889: write_h ('||Parameter Description ');
4890: write_h ('||p_effective_dates - ' || p_effective_date);
4916: INTO l_parm;
4917:
4918: CLOSE c_parameter;
4919:
4920: benutils.get_parameter (p_business_group_id => l_parm.business_group_id
4921: , p_batch_exe_cd => 'BENCWBPP'
4922: , p_threads => l_threads
4923: , p_chunk_size => l_chunk_size
4924: , p_max_errors => g_max_errors_allowed
5192: g_actn := 'Calling ben_batch_utils.ini...';
5193: WRITE (g_actn);
5194: write_h ('ben_batch_utils.ini with PROC_INFO');
5195: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
5196: g_actn := 'Calling benutils.get_parameter...';
5197: WRITE (g_actn);
5198: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBPP' || ' '
5199: || g_max_errors_allowed
5200: );
5194: write_h ('ben_batch_utils.ini with PROC_INFO');
5195: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
5196: g_actn := 'Calling benutils.get_parameter...';
5197: WRITE (g_actn);
5198: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBPP' || ' '
5199: || g_max_errors_allowed
5200: );
5201: benutils.get_parameter (p_business_group_id => p_bg_id
5202: , p_batch_exe_cd => 'BENCWBPP'
5197: WRITE (g_actn);
5198: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBPP' || ' '
5199: || g_max_errors_allowed
5200: );
5201: benutils.get_parameter (p_business_group_id => p_bg_id
5202: , p_batch_exe_cd => 'BENCWBPP'
5203: , p_threads => l_threads
5204: , p_chunk_size => l_chunk_size
5205: , p_max_errors => g_max_errors_allowed
5204: , p_chunk_size => l_chunk_size
5205: , p_max_errors => g_max_errors_allowed
5206: );
5207: write_h ('Values of l_threads is ' || l_threads || ' and l_chunk_size is ' || l_chunk_size);
5208: benutils.g_thread_id := 99; -- need to investigate why this is needed
5209: g_actn := 'Creating benefit actions...';
5210: WRITE (g_actn);
5211: WRITE ('Time'||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
5212: write_h ('=====================Benefit Actions=======================');
5243: , p_bft_attribute3 => p_employees_in_bg
5244: , p_bft_attribute4 => p_manager_id
5245: );
5246: write ('Benefit Action Id is ' || l_benefit_action_id);
5247: benutils.g_benefit_action_id := l_benefit_action_id;
5248: g_actn := 'Inserting Person Actions...';
5249: WRITE (g_actn);
5250: write_m ('Time before processing the person selections '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
5251: