DBA Data[Home] [Help]

APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on BENUTILS

Line 70: * 20-JUL-1999 Gperry 115.30 genutils -> benutils package rename.

66: * 03-MAr-1999 Stee 115.23 Removed dbms_output.put_line.
67: * 22-MAR-1999 TMathers 115.27 CHanged -MON- to /MM/
68: * 05-Apr-1999 mhoyes 115.28 - Un-datetrack of per_in_ler_f changes.
69: * 10-May-1999 jcarpent 115.29 Check ('VOIDD','BCKDT') for pil stt cd
70: * 20-JUL-1999 Gperry 115.30 genutils -> benutils package rename.
71: * 12-Aug-1999 lmcdonal 115.31 Start support for enterable cvg amounts.
72: * To complete, need task 280 to be done
73: * (changes to benelinf).
74: * 25-Aug-1999 Gperry 115.32 Added ben_env_object call to multithread.

Line 205: g_rec benutils.g_batch_ler_rec;

201: g_package varchar2(80) := 'Ben_manage_default_Enrt';
202: g_max_errors_allowed number(9) := 200;
203: g_persons_errored number(9) := 0;
204: g_persons_procd number(9) := 0;
205: g_rec benutils.g_batch_ler_rec;
206: --
207: -- ===========================================================================
208: -- << Procedure: Write_person_category >>
209: -- ===========================================================================

Line 295: benutils.g_benefit_action_id,

291: business_group_id,
292: object_version_number)
293: values
294: (ben_batch_rate_info_s.nextval,
295: benutils.g_benefit_action_id,
296: p_person_id,
297: l_cache(i).pgm_id,
298: l_cache(i).pl_id,
299: l_cache(i).oipl_id,

Line 327: benutils.g_benefit_action_id,

323: dpnt_person_id)
324: values
325: (ben_batch_dpnt_info_s.nextval,
326: p_person_id,
327: benutils.g_benefit_action_id,
328: p_business_group_id,
329: l_cache(i).pgm_id,
330: l_cache(i).pl_id,
331: l_cache(i).oipl_id,

Line 484: l_actn := 'Calling benutils.get_parameter...';

480: dt_fndate.change_ses_date
481: (p_ses_date => l_effective_date,
482: p_commit => l_commit);
483: --
484: l_actn := 'Calling benutils.get_parameter...';
485: benutils.get_parameter(p_business_group_id => p_business_group_Id
486: ,p_batch_exe_cd => 'BENEADEB'
487: ,p_threads => l_threads
488: ,p_chunk_size => l_chunk_size

Line 485: benutils.get_parameter(p_business_group_id => p_business_group_Id

481: (p_ses_date => l_effective_date,
482: p_commit => l_commit);
483: --
484: l_actn := 'Calling benutils.get_parameter...';
485: benutils.get_parameter(p_business_group_id => p_business_group_Id
486: ,p_batch_exe_cd => 'BENEADEB'
487: ,p_threads => l_threads
488: ,p_chunk_size => l_chunk_size
489: ,p_max_errors => g_max_errors_allowed );

Line 504: -- Copy benefit action id to global in benutils package

500: --
501: l_actn := 'Calling ben_batch_utils.ini...';
502: ben_batch_utils.ini;
503: --
504: -- Copy benefit action id to global in benutils package
505: --
506: benutils.g_benefit_action_id := p_benefit_action_id;
507: benutils.g_thread_id := p_thread_id;
508: g_persons_errored := 0;

Line 506: benutils.g_benefit_action_id := p_benefit_action_id;

502: ben_batch_utils.ini;
503: --
504: -- Copy benefit action id to global in benutils package
505: --
506: benutils.g_benefit_action_id := p_benefit_action_id;
507: benutils.g_thread_id := p_thread_id;
508: g_persons_errored := 0;
509: g_persons_procd := 0;
510: open c_parameter;

Line 507: benutils.g_thread_id := p_thread_id;

503: --
504: -- Copy benefit action id to global in benutils package
505: --
506: benutils.g_benefit_action_id := p_benefit_action_id;
507: benutils.g_thread_id := p_thread_id;
508: g_persons_errored := 0;
509: g_persons_procd := 0;
510: open c_parameter;
511: fetch c_parameter into l_parm;

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

613: fnd_message.raise_error;
614: End if;
615: commit;
616: End loop;
617: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
618: commit;
619: --
620: l_actn := 'Calling Log_beneadeb_statistics...';
621: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd

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

630: );
631: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd
632: ,p_num_pers_errored => g_persons_errored
633: );
634: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
635: commit;
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP',l_actn );

Line 931: l_actn := 'Calling benutils.get_parameter...';

927: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
928: --
929: -- Get chunk_size and Thread values for multi-thread process, and check to
930: --
931: l_actn := 'Calling benutils.get_parameter...';
932: benutils.get_parameter(p_business_group_id => p_business_group_Id
933: ,p_batch_exe_cd => 'BENEADEB'
934: ,p_threads => l_threads
935: ,p_chunk_size => l_chunk_size

Line 932: benutils.get_parameter(p_business_group_id => p_business_group_Id

928: --
929: -- Get chunk_size and Thread values for multi-thread process, and check to
930: --
931: l_actn := 'Calling benutils.get_parameter...';
932: benutils.get_parameter(p_business_group_id => p_business_group_Id
933: ,p_batch_exe_cd => 'BENEADEB'
934: ,p_threads => l_threads
935: ,p_chunk_size => l_chunk_size
936: ,p_max_errors => g_max_errors_allowed);

Line 938: benutils.g_benefit_action_id := p_benefit_action_id;

934: ,p_threads => l_threads
935: ,p_chunk_size => l_chunk_size
936: ,p_max_errors => g_max_errors_allowed);
937: --
938: benutils.g_benefit_action_id := p_benefit_action_id;
939: benutils.g_thread_id := 99;
940: --
941: -- Create benefit actions parameters in the benefit action table.
942: -- Do not create if a benefit action already exists, in other words

Line 939: benutils.g_thread_id := 99;

935: ,p_chunk_size => l_chunk_size
936: ,p_max_errors => g_max_errors_allowed);
937: --
938: benutils.g_benefit_action_id := p_benefit_action_id;
939: benutils.g_thread_id := 99;
940: --
941: -- Create benefit actions parameters in the benefit action table.
942: -- Do not create if a benefit action already exists, in other words
943: -- we are doing a restart.

Line 985: benutils.g_benefit_action_id := l_benefit_action_id;

981: ,p_program_application_id => fnd_global.prog_appl_id
982: ,p_program_id => fnd_global.conc_program_id
983: ,p_program_update_date => sysdate);
984: --
985: benutils.g_benefit_action_id := l_benefit_action_id;
986: --
987: -- Now lets create person actions for all the people we are going to
988: -- process in the BENEADEB run.
989: --

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

1273: Exception
1274: --
1275: when l_silent_error then
1276: ben_batch_utils.write(p_text => fnd_message.get);
1277: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1278: If (l_num_ranges > 0) then
1279: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1280: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1281: ,p_person_selected => l_num_persons

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

1289: ,p_rpt_flag => TRUE );
1290: ben_batch_utils.write(p_text => fnd_message.get);
1291: ben_batch_utils.write(p_text => sqlerrm);
1292: ben_batch_utils.write(p_text => 'Big Error Occured');
1293: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1294: If (l_num_ranges > 0) then
1295: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1296: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1297: ,p_person_selected => l_num_persons

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

1928: fetch c_pl_bnf into l_pl_bnf;
1929: if c_pl_bnf%found then
1930: fnd_message.set_name('BEN','BEN_94757_BNF_SLF_DSGN_NOTE');
1931: fnd_message.set_token('PLAN',l_bnf_exl_participant.name);
1932: benutils.write(p_text => fnd_message.get);
1933: end if;
1934: close c_pl_bnf;
1935: end if;
1936: end if;

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

2200: g_rec.cvrge_rt_prem_flag := 'N';
2201: g_rec.business_group_id := p_business_group_id;
2202: g_rec.effective_date := p_effective_date;
2203: --
2204: benutils.write(p_rec => g_rec);
2205: --
2206: g_persons_procd := g_persons_procd + 1;
2207: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
2208: hr_utility.set_location ('Leaving '|| l_proc,10);

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

2203: --
2204: benutils.write(p_rec => g_rec);
2205: --
2206: g_persons_procd := g_persons_procd + 1;
2207: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
2208: hr_utility.set_location ('Leaving '|| l_proc,10);
2209: Exception
2210: When others then
2211: rollback to process_default_enrt_savepoint;

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

2232: ,p_person_id => p_person_id
2233: ,p_business_group_id => p_business_group_id
2234: ,p_effective_date => p_effective_date
2235: );
2236: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
2237: raise ben_batch_utils.g_record_error;
2238: end process_default_enrt;
2239:
2240: -- ============================================================================