[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
1816: , asgn_change_reason
1817: , pending_workflow
1818: , new_rpt
1819: , prev_eev_screen_entry_value)
1820: VALUES (benutils.g_benefit_action_id
1821: , g_cache_cwb_rpt_person (i).person_rate_id
1822: , g_cache_cwb_rpt_person (i).pl_id
1823: , g_cache_cwb_rpt_person (i).person_id
1824: , g_cache_cwb_rpt_person (i).country_code
1997: , status_cd
1998: , lf_evt_closed_flag
1999: , cwb_rpt_detail_id
2000: )
2001: VALUES (benutils.g_benefit_action_id
2002: , -9999
2003: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).person_id
2004: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).country_code
2005: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).bg_id
4143: l_perf_person_rec.error_or_warning_text := substr(fnd_message.get_number(l_app_name,l_message_name)||' '||fnd_message.get,1,2000);
4144: g_person_errored := TRUE;
4145: WRITE(l_perf_person_rec.error_or_warning_text);
4146: ROLLBACK TO process_rating;
4147: IF(benutils.get_message_name = 'BEN_93371_RATING_EXST_FOR_DATE') THEN
4148: --l_perf_person_rec.error_or_warning_text := fnd_message.get;
4149: write_m ('Time after processing rating '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
4150: WRITE('Failed Performance rating is '||l_perf_person_rec.performance_rating);
4151: l_rating_status := 'CWB_PERF_SUS';
4737: IF g_cwb_rpt_person.group_oipl_id <> -1 THEN
4738: g_cwb_rpt_person.opt_name := g_cache_group_options (g_cwb_rpt_person.group_oipl_id);
4739: END IF;
4740:
4741: g_cwb_rpt_person.error_or_warning_text := substr(benutils.get_message_name || ' '||fnd_message.get,1,2000);
4742:
4743: IF l_comp_error THEN
4744: g_cwb_rpt_person.error_or_warning_text := substr(g_cwb_rpt_person.error_or_warning_text ||
4745: ' '||'Person ' || p_person_id || ' failed for compensation',1,2000);
4764: g_cache_cwb_sum_person (p_person_id).country_code := l_emp_num_and_emp_name.legislation_code;
4765: -- g_cache_cwb_rpt_person (g_cache_cwb_rpt_person.COUNT + 1) := g_cwb_rpt_person;
4766:
4767: END IF;
4768: WRITE (benutils.get_message_name);
4769: WRITE (fnd_message.get);
4770: WRITE (SQLERRM||' in process_person');
4771: RAISE ben_batch_utils.g_record_error;
4772: END;
4805: dbms_lock.sleep(30);
4806: end if;*/
4807: g_actn := 'Started do_multithread for the thread ' || p_thread_id;
4808: g_proc := 'do_multithread';
4809: benutils.g_benefit_action_id := p_benefit_action_id;
4810: WRITE (g_actn);
4811: write_h ('=====================do_multithread=============');
4812: write_h ('||Parameter Description ');
4813: write_h ('||p_effective_dates - ' || p_effective_date);
4839: INTO l_parm;
4840:
4841: CLOSE c_parameter;
4842:
4843: benutils.get_parameter (p_business_group_id => l_parm.business_group_id
4844: , p_batch_exe_cd => 'BENCWBPP'
4845: , p_threads => l_threads
4846: , p_chunk_size => l_chunk_size
4847: , p_max_errors => g_max_errors_allowed
5115: g_actn := 'Calling ben_batch_utils.ini...';
5116: WRITE (g_actn);
5117: write_h ('ben_batch_utils.ini with PROC_INFO');
5118: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
5119: g_actn := 'Calling benutils.get_parameter...';
5120: WRITE (g_actn);
5121: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBPP' || ' '
5122: || g_max_errors_allowed
5123: );
5117: write_h ('ben_batch_utils.ini with PROC_INFO');
5118: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
5119: g_actn := 'Calling benutils.get_parameter...';
5120: WRITE (g_actn);
5121: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBPP' || ' '
5122: || g_max_errors_allowed
5123: );
5124: benutils.get_parameter (p_business_group_id => p_bg_id
5125: , p_batch_exe_cd => 'BENCWBPP'
5120: WRITE (g_actn);
5121: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBPP' || ' '
5122: || g_max_errors_allowed
5123: );
5124: benutils.get_parameter (p_business_group_id => p_bg_id
5125: , p_batch_exe_cd => 'BENCWBPP'
5126: , p_threads => l_threads
5127: , p_chunk_size => l_chunk_size
5128: , p_max_errors => g_max_errors_allowed
5127: , p_chunk_size => l_chunk_size
5128: , p_max_errors => g_max_errors_allowed
5129: );
5130: write_h ('Values of l_threads is ' || l_threads || ' and l_chunk_size is ' || l_chunk_size);
5131: benutils.g_thread_id := 99; -- need to investigate why this is needed
5132: g_actn := 'Creating benefit actions...';
5133: WRITE (g_actn);
5134: WRITE ('Time'||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
5135: write_h ('=====================Benefit Actions=======================');
5166: , p_bft_attribute3 => p_employees_in_bg
5167: , p_bft_attribute4 => p_manager_id
5168: );
5169: write ('Benefit Action Id is ' || l_benefit_action_id);
5170: benutils.g_benefit_action_id := l_benefit_action_id;
5171: g_actn := 'Inserting Person Actions...';
5172: WRITE (g_actn);
5173: write_m ('Time before processing the person selections '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
5174: