eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EVALUATE_ELIG_CONC dependencies on BENUTILS

Line 136: fnd_message.set_token('PROC','benutils.get_parameter');

132: --
133: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
134: --
135: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
136: fnd_message.set_token('PROC','benutils.get_parameter');
137: benutils.get_parameter(p_business_group_id => p_business_group_id
138: ,p_batch_exe_cd => 'BENUNVEL'
139: ,p_threads => l_threads
140: ,p_chunk_size => l_chunk_size

Line 137: benutils.get_parameter(p_business_group_id => p_business_group_id

133: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
134: --
135: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
136: fnd_message.set_token('PROC','benutils.get_parameter');
137: benutils.get_parameter(p_business_group_id => p_business_group_id
138: ,p_batch_exe_cd => 'BENUNVEL'
139: ,p_threads => l_threads
140: ,p_chunk_size => l_chunk_size
141: ,p_max_errors => g_max_errors_allowed);

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

149: p_threads => l_threads,
150: p_max_errors => g_max_errors_allowed,
151: p_benefit_action_id => p_benefit_action_id);
152: --
153: -- Copy benefit action id to global in benutils package
154: --
155: benutils.g_benefit_action_id := p_benefit_action_id;
156: benutils.g_thread_id := p_thread_id;
157: g_persons_errored := 0;

Line 155: benutils.g_benefit_action_id := p_benefit_action_id;

151: p_benefit_action_id => p_benefit_action_id);
152: --
153: -- Copy benefit action id to global in benutils package
154: --
155: benutils.g_benefit_action_id := p_benefit_action_id;
156: benutils.g_thread_id := p_thread_id;
157: g_persons_errored := 0;
158: g_persons_processed := 0;
159: --

Line 156: benutils.g_thread_id := p_thread_id;

152: --
153: -- Copy benefit action id to global in benutils package
154: --
155: benutils.g_benefit_action_id := p_benefit_action_id;
156: benutils.g_thread_id := p_thread_id;
157: g_persons_errored := 0;
158: g_persons_processed := 0;
159: --
160: open c_parameter;

Line 233: benutils.set_cache_record_position;

229: --
230: exit when c_person_thread%notfound;
231: --
232: savepoint last_place;
233: benutils.set_cache_record_position;
234: --
235: l_per_rec := l_per_dummy_rec;
236: open c_person;
237: fetch c_person into l_per_rec;

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

260: close c_ebo;
261:
262: g_rec.rep_typ_cd := 'LFBO';
263: g_rec.person_id := l_person_id;
264: benutils.write(p_rec => g_rec);
265: --
266: -- If we get here it was successful.
267: --
268: update ben_person_actions

Line 273: benutils.write(l_per_rec.full_name||' processed successfully');

269: set action_status_cd = 'P'
270: where person_id = l_person_id
271: and benefit_action_id = p_benefit_action_id;
272: --
273: benutils.write(l_per_rec.full_name||' processed successfully');
274: g_persons_processed := g_persons_processed + 1;
275: --
276: exception
277: --

Line 283: benutils.rollback_cache;

279: --
280: hr_utility.set_location('Super Error exception level',10);
281: hr_utility.set_location(sqlerrm,10);
282: rollback to last_place;
283: benutils.rollback_cache;
284: --
285: update ben_person_actions
286: set action_status_cd = 'E'
287: where person_id = l_person_id

Line 296: g_rec.error_message_code := benutils.get_message_name;

292: g_persons_errored := g_persons_errored + 1;
293: g_rec.rep_typ_cd := 'ERROR_LF';
294: g_rec.person_id := l_person_id;
295: g_rec.national_identifier := l_per_rec.national_identifier;
296: g_rec.error_message_code := benutils.get_message_name;
297: g_rec.text := fnd_message.get;
298:
299: hr_utility.set_location('Error Message '||g_rec.text,10);
300: benutils.write(l_per_rec.full_name||' processed unsuccessfully');

Line 300: benutils.write(l_per_rec.full_name||' processed unsuccessfully');

296: g_rec.error_message_code := benutils.get_message_name;
297: g_rec.text := fnd_message.get;
298:
299: hr_utility.set_location('Error Message '||g_rec.text,10);
300: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
301: benutils.write(g_rec.text);
302: benutils.write(p_rec => g_rec);
303: --
304: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);

Line 301: benutils.write(g_rec.text);

297: g_rec.text := fnd_message.get;
298:
299: hr_utility.set_location('Error Message '||g_rec.text,10);
300: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
301: benutils.write(g_rec.text);
302: benutils.write(p_rec => g_rec);
303: --
304: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
305: hr_utility.set_location('Num Errors = '||g_persons_errored,10);

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

298:
299: hr_utility.set_location('Error Message '||g_rec.text,10);
300: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
301: benutils.write(g_rec.text);
302: benutils.write(p_rec => g_rec);
303: --
304: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
305: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
306: if g_persons_errored > g_max_errors_allowed then

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

305: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
306: if g_persons_errored > g_max_errors_allowed then
307: --
308: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
309: benutils.write(p_text => fnd_message.get);
310: --
311: raise;
312: --
313: end if;

Line 334: fnd_message.set_token('PROC','benutils.write_table_and_file');

330: --
331: end if;
332: --
333: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
334: fnd_message.set_token('PROC','benutils.write_table_and_file');
335: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
336: commit;
337: --
338: end loop;

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

331: end if;
332: --
333: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
334: fnd_message.set_token('PROC','benutils.write_table_and_file');
335: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
336: commit;
337: --
338: end loop;
339: --

Line 357: benutils.rollback_cache;

353: hr_utility.set_location('Super Error',10);
354: hr_utility.set_location(sqlerrm,10);
355: hr_utility.set_location('Super Error',10);
356: rollback;
357: benutils.rollback_cache;
358: --
359: g_rec.rep_typ_cd := 'FATAL';
360: g_rec.text := fnd_message.get;
361: g_rec.person_id := l_person_id;

Line 363: benutils.write(p_text => g_rec.text);

359: g_rec.rep_typ_cd := 'FATAL';
360: g_rec.text := fnd_message.get;
361: g_rec.person_id := l_person_id;
362: --
363: benutils.write(p_text => g_rec.text);
364: benutils.write(p_rec => g_rec);
365: --
366: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
367: ,p_num_pers_errored => g_persons_errored);

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

360: g_rec.text := fnd_message.get;
361: g_rec.person_id := l_person_id;
362: --
363: benutils.write(p_text => g_rec.text);
364: benutils.write(p_rec => g_rec);
365: --
366: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
367: ,p_num_pers_errored => g_persons_errored);
368: --

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

365: --
366: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
367: ,p_num_pers_errored => g_persons_errored);
368: --
369: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
370: --
371: commit;
372: --
373: fnd_message.raise_error;

Line 573: benutils.get_parameter(p_business_group_id => p_business_group_id

569: --
570: ben_batch_utils.ini;
571: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
572: --
573: benutils.get_parameter(p_business_group_id => p_business_group_id
574: ,p_batch_exe_cd => 'BENUNVEL'
575: ,p_threads => l_threads
576: ,p_chunk_size => l_chunk_size
577: ,p_max_errors => g_max_errors_allowed);

Line 621: benutils.g_benefit_action_id := l_benefit_action_id;

617: ,p_program_application_id => fnd_global.prog_appl_id
618: ,p_program_id => fnd_global.conc_program_id
619: ,p_program_update_date => sysdate);
620: --
621: benutils.g_benefit_action_id := l_benefit_action_id;
622: --
623: -- Delete/clear ranges from ben_batch_ranges table
624: --
625: Delete from ben_batch_ranges

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

810: hr_utility.set_location ('Leaving '||l_proc,70);
811: --
812: Exception
813: when l_no_one_to_process then
814: benutils.write(p_text => fnd_message.get);
815: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
816: when others then
817: --
818: hr_utility.set_location('Super Error',10);

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

811: --
812: Exception
813: when l_no_one_to_process then
814: benutils.write(p_text => fnd_message.get);
815: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
816: when others then
817: --
818: hr_utility.set_location('Super Error',10);
819: rollback;

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

816: when others then
817: --
818: hr_utility.set_location('Super Error',10);
819: rollback;
820: benutils.write(p_text => fnd_message.get);
821: benutils.write(p_text => sqlerrm);
822: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
823: If (l_num_range > 0) then
824: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

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

817: --
818: hr_utility.set_location('Super Error',10);
819: rollback;
820: benutils.write(p_text => fnd_message.get);
821: benutils.write(p_text => sqlerrm);
822: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
823: If (l_num_range > 0) then
824: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
825: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

818: hr_utility.set_location('Super Error',10);
819: rollback;
820: benutils.write(p_text => fnd_message.get);
821: benutils.write(p_text => sqlerrm);
822: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
823: If (l_num_range > 0) then
824: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
825: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
826: ,p_person_selected => l_person_cnt