DBA Data[Home] [Help]

APPS.BEN_PREMIUM_CONCURRENT dependencies on BENUTILS

Line 17: * 20-JUL-99 Gperry 115.2 genutils -> benutils package rename.

13: * Date Who Version What?
14: * ------- --------- ------- --------------------------------------
15: * 18-Jun-99 lmcdonal 115.0 Created
16: * 08-Jul-99 lmcdonal 115.1 Added reporting
17: * 20-JUL-99 Gperry 115.2 genutils -> benutils package rename.
18: * 23-Jul-99 lmcdonal 115.3 add distinct to main cursor.
19: * 06-Oct-99 tguy 115.4 added call to dt_fndate
20: * 12-Oct-99 maagrawa 115.5 ben_env_object.init call added
21: * to do_multithread.

Line 152: l_actn := 'Calling benutils.formula procedure...';

148: End if;
149: close c1;
150: -- Call formula initialise routine
151: --
152: l_actn := 'Calling benutils.formula procedure...';
153:
154: l_outputs := benutils.formula
155: (p_formula_id => p_person_selection_rule_id
156: ,p_effective_date => p_effective_date

Line 154: l_outputs := benutils.formula

150: -- Call formula initialise routine
151: --
152: l_actn := 'Calling benutils.formula procedure...';
153:
154: l_outputs := benutils.formula
155: (p_formula_id => p_person_selection_rule_id
156: ,p_effective_date => p_effective_date
157: ,p_business_group_id => p_business_group_id
158: ,p_assignment_id => l_assignment_id

Line 165: l_actn := 'Evaluating benutils.formula return...';

161: ,p_param2 => p_input1
162: ,p_param2_value => p_input1_value);
163: p_return := l_outputs(l_outputs.first).value;
164: --
165: l_actn := 'Evaluating benutils.formula return...';
166: --
167: If upper(p_return) not in ('Y', 'N') then
168: Raise value_exception ;
169: End if;

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

276: dt_fndate.change_ses_date
277: (p_ses_date => l_effective_date,
278: p_commit => l_commit);
279: --
280: l_actn := 'Calling benutils.get_parameter...';
281: benutils.get_parameter(p_business_group_id => p_business_group_Id
282: ,p_batch_exe_cd => 'BENPRCON'
283: ,p_threads => l_threads
284: ,p_chunk_size => l_chunk_size

Line 281: benutils.get_parameter(p_business_group_id => p_business_group_Id

277: (p_ses_date => l_effective_date,
278: p_commit => l_commit);
279: --
280: l_actn := 'Calling benutils.get_parameter...';
281: benutils.get_parameter(p_business_group_id => p_business_group_Id
282: ,p_batch_exe_cd => 'BENPRCON'
283: ,p_threads => l_threads
284: ,p_chunk_size => l_chunk_size
285: ,p_max_errors => g_max_errors_allowed);

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

296: --
297: l_actn := 'Calling ben_batch_utils.ini...';
298: ben_batch_utils.ini;
299: --
300: -- Copy benefit action id to global in benutils package
301: --
302: benutils.g_benefit_action_id := p_benefit_action_id;
303: benutils.g_thread_id := p_thread_id;
304: g_persons_errored := 0;

Line 302: benutils.g_benefit_action_id := p_benefit_action_id;

298: ben_batch_utils.ini;
299: --
300: -- Copy benefit action id to global in benutils package
301: --
302: benutils.g_benefit_action_id := p_benefit_action_id;
303: benutils.g_thread_id := p_thread_id;
304: g_persons_errored := 0;
305: g_persons_processed := 0;
306: open c_parameter;

Line 303: benutils.g_thread_id := p_thread_id;

299: --
300: -- Copy benefit action id to global in benutils package
301: --
302: benutils.g_benefit_action_id := p_benefit_action_id;
303: benutils.g_thread_id := p_thread_id;
304: g_persons_errored := 0;
305: g_persons_processed := 0;
306: open c_parameter;
307: fetch c_parameter into l_parm;

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

423: hr_utility.set_location ('BEN_91709_PER_NOT_FND_IN_RNG',778);
424: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
425: fnd_message.raise_error;
426: End if;
427: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
428: End loop;
429: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
430: --
431: l_actn := 'Calling Log_statistics...';

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

425: fnd_message.raise_error;
426: End if;
427: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
428: End loop;
429: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
430: --
431: l_actn := 'Calling Log_statistics...';
432: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
433: ,p_num_pers_errored => g_persons_errored

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

445: );
446: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
447: ,p_num_pers_errored => g_persons_errored
448: );
449: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
450: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
451: fnd_message.set_token('PROCEDURE', l_proc);
452: fnd_message.set_token('STEP',l_actn );
453: fnd_message.raise_error;

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

678: -- assure they are sensible.
679: -- chunk_size between(10 and 100). If not in range, default to 20.
680: -- threads between <1 and 100>. If not in range, default to 1
681: --
682: l_actn := 'Calling benutils.get_parameter...';
683: benutils.get_parameter(p_business_group_id => p_business_group_Id
684: ,p_batch_exe_cd => 'BENPRCON'
685: ,p_threads => l_threads
686: ,p_chunk_size => l_chunk_size

Line 683: benutils.get_parameter(p_business_group_id => p_business_group_Id

679: -- chunk_size between(10 and 100). If not in range, default to 20.
680: -- threads between <1 and 100>. If not in range, default to 1
681: --
682: l_actn := 'Calling benutils.get_parameter...';
683: benutils.get_parameter(p_business_group_id => p_business_group_Id
684: ,p_batch_exe_cd => 'BENPRCON'
685: ,p_threads => l_threads
686: ,p_chunk_size => l_chunk_size
687: ,p_max_errors => g_max_errors_allowed);

Line 688: benutils.g_benefit_action_id := p_benefit_action_id;

684: ,p_batch_exe_cd => 'BENPRCON'
685: ,p_threads => l_threads
686: ,p_chunk_size => l_chunk_size
687: ,p_max_errors => g_max_errors_allowed);
688: benutils.g_benefit_action_id := p_benefit_action_id;
689: benutils.g_thread_id := 99;
690:
691: --
692: -- Create benefit actions parameters in the benefit action table.

Line 689: benutils.g_thread_id := 99;

685: ,p_threads => l_threads
686: ,p_chunk_size => l_chunk_size
687: ,p_max_errors => g_max_errors_allowed);
688: benutils.g_benefit_action_id := p_benefit_action_id;
689: benutils.g_thread_id := 99;
690:
691: --
692: -- Create benefit actions parameters in the benefit action table.
693: -- Do not create is a benefit action already exists, in other words

Line 738: benutils.g_benefit_action_id := l_benefit_action_id;

734: ,p_program_application_id => fnd_global.prog_appl_id
735: ,p_program_id => fnd_global.conc_program_id
736: ,p_program_update_date => sysdate
737: );
738: benutils.g_benefit_action_id := l_benefit_action_id;
739: --
740: -- Delete/clear ranges from ben_batch_ranges table
741: --
742: l_actn := 'Delete rows from ben_batch_ranges..';

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

1022: ben_batch_utils.rpt_error(p_proc => l_proc
1023: ,p_last_actn => l_actn
1024: ,p_rpt_flag => TRUE );
1025: --
1026: benutils.write(p_text => fnd_message.get);
1027: benutils.write(p_text => sqlerrm);
1028: benutils.write(p_text => 'Big Error Occured');
1029: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1030: If (l_num_range > 0) then

Line 1027: benutils.write(p_text => sqlerrm);

1023: ,p_last_actn => l_actn
1024: ,p_rpt_flag => TRUE );
1025: --
1026: benutils.write(p_text => fnd_message.get);
1027: benutils.write(p_text => sqlerrm);
1028: benutils.write(p_text => 'Big Error Occured');
1029: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1030: If (l_num_range > 0) then
1031: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

Line 1028: benutils.write(p_text => 'Big Error Occured');

1024: ,p_rpt_flag => TRUE );
1025: --
1026: benutils.write(p_text => fnd_message.get);
1027: benutils.write(p_text => sqlerrm);
1028: benutils.write(p_text => 'Big Error Occured');
1029: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1030: If (l_num_range > 0) then
1031: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1032: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

1025: --
1026: benutils.write(p_text => fnd_message.get);
1027: benutils.write(p_text => sqlerrm);
1028: benutils.write(p_text => 'Big Error Occured');
1029: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1030: If (l_num_range > 0) then
1031: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1032: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1033: ,p_person_selected => l_person_cnt