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_IREC_BACK_OUT_CONC dependencies on BENUTILS

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

153: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
154: l_ocrd_date := trunc(fnd_date.canonical_to_date(p_ocrd_date));
155: --
156: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
157: fnd_message.set_token('PROC','benutils.get_parameter');
158: benutils.get_parameter(p_business_group_id => p_business_group_id
159: ,p_batch_exe_cd => 'BENBOCON'
160: ,p_threads => l_threads
161: ,p_chunk_size => l_chunk_size

Line 158: benutils.get_parameter(p_business_group_id => p_business_group_id

154: l_ocrd_date := trunc(fnd_date.canonical_to_date(p_ocrd_date));
155: --
156: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
157: fnd_message.set_token('PROC','benutils.get_parameter');
158: benutils.get_parameter(p_business_group_id => p_business_group_id
159: ,p_batch_exe_cd => 'BENBOCON'
160: ,p_threads => l_threads
161: ,p_chunk_size => l_chunk_size
162: ,p_max_errors => g_max_errors_allowed);

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

174: p_threads => l_threads,
175: p_max_errors => g_max_errors_allowed,
176: p_benefit_action_id => p_benefit_action_id);
177: --
178: -- Copy benefit action id to global in benutils package
179: --
180: benutils.g_benefit_action_id := p_benefit_action_id;
181: benutils.g_thread_id := p_thread_id;
182: g_persons_errored := 0;

Line 180: benutils.g_benefit_action_id := p_benefit_action_id;

176: p_benefit_action_id => p_benefit_action_id);
177: --
178: -- Copy benefit action id to global in benutils package
179: --
180: benutils.g_benefit_action_id := p_benefit_action_id;
181: benutils.g_thread_id := p_thread_id;
182: g_persons_errored := 0;
183: g_persons_processed := 0;
184: --

Line 181: benutils.g_thread_id := p_thread_id;

177: --
178: -- Copy benefit action id to global in benutils package
179: --
180: benutils.g_benefit_action_id := p_benefit_action_id;
181: benutils.g_thread_id := p_thread_id;
182: g_persons_errored := 0;
183: g_persons_processed := 0;
184: --
185: open c_parameter;

Line 259: benutils.set_cache_record_position;

255: --
256: exit when c_person_thread%notfound;
257: --
258: savepoint last_place;
259: benutils.set_cache_record_position;
260:
261: open c_person;
262: -- l_per_rec := l_per_dummy_rec;
263: fetch c_person into l_per_rec;

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

311: -- This is to assign the per_in_ler_id in the record to extract the
312: -- the electable choices later.
313: g_rec.temporal_ler_id := l_ler_thread.per_in_ler_id;
314:
315: benutils.write(p_rec => g_rec);
316: --
317: End loop;
318: --
319: close c_ler_thread;

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

324: set action_status_cd = 'P'
325: where person_id = l_person_id
326: and benefit_action_id = p_benefit_action_id;
327: --
328: benutils.write(l_per_rec.full_name||' processed successfully');
329: g_persons_processed := g_persons_processed + 1;
330: --
331: exception
332: --

Line 346: benutils.rollback_cache;

342: --
343: end if;
344: --
345: rollback to last_place;
346: benutils.rollback_cache;
347: --
348: update ben_person_actions
349: set action_status_cd = 'E'
350: where person_id = l_person_id

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

358: -- g_rec.text := fnd_message.get;
359: g_rec.person_id := l_person_id;
360:
361: g_rec.national_identifier := l_per_rec.national_identifier;
362: g_rec.error_message_code := benutils.get_message_name;
363: g_rec.text := fnd_message.get;
364:
365: hr_utility.set_location('Error Message '||g_rec.text,10);
366: benutils.write(l_per_rec.full_name||' processed unsuccessfully');

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

362: g_rec.error_message_code := benutils.get_message_name;
363: g_rec.text := fnd_message.get;
364:
365: hr_utility.set_location('Error Message '||g_rec.text,10);
366: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
367: benutils.write(g_rec.text);
368: benutils.write(p_rec => g_rec);
369: --
370: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);

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

363: g_rec.text := fnd_message.get;
364:
365: hr_utility.set_location('Error Message '||g_rec.text,10);
366: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
367: benutils.write(g_rec.text);
368: benutils.write(p_rec => g_rec);
369: --
370: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
371: hr_utility.set_location('Num Errors = '||g_persons_errored,10);

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

364:
365: hr_utility.set_location('Error Message '||g_rec.text,10);
366: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
367: benutils.write(g_rec.text);
368: benutils.write(p_rec => g_rec);
369: --
370: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
371: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
372: if g_persons_errored > g_max_errors_allowed then

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

371: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
372: if g_persons_errored > g_max_errors_allowed then
373: --
374: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
375: benutils.write(p_text => fnd_message.get);
376: --
377: raise;
378: --
379: end if;

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

396: --
397: end if;
398: --
399: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
400: fnd_message.set_token('PROC','benutils.write_table_and_file');
401: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
402: commit;
403: --
404: end loop;

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

397: end if;
398: --
399: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
400: fnd_message.set_token('PROC','benutils.write_table_and_file');
401: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
402: commit;
403: --
404: end loop;
405: --

Line 423: benutils.rollback_cache;

419: hr_utility.set_location('Super Error',10);
420: hr_utility.set_location(sqlerrm,10);
421: hr_utility.set_location('Super Error',10);
422: rollback;
423: benutils.rollback_cache;
424: --
425: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
426: g_rec.rep_typ_cd := 'FATAL';
427: g_rec.text := fnd_message.get;

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

426: g_rec.rep_typ_cd := 'FATAL';
427: g_rec.text := fnd_message.get;
428: g_rec.person_id := l_person_id;
429: --
430: benutils.write(p_text => g_rec.text);
431: benutils.write(p_rec => g_rec);
432: --
433: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
434: ,p_num_pers_errored => g_persons_errored);

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

427: g_rec.text := fnd_message.get;
428: g_rec.person_id := l_person_id;
429: --
430: benutils.write(p_text => g_rec.text);
431: benutils.write(p_rec => g_rec);
432: --
433: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
434: ,p_num_pers_errored => g_persons_errored);
435: --

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

432: --
433: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
434: ,p_num_pers_errored => g_persons_errored);
435: --
436: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
437: --
438: commit;
439: --
440: fnd_message.raise_error;

Line 603: benutils.get_parameter(p_business_group_id => p_business_group_id

599: ben_batch_utils.ini;
600: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
601: --
602:
603: benutils.get_parameter(p_business_group_id => p_business_group_id
604: ,p_batch_exe_cd => 'BENBOCON'
605: ,p_threads => l_threads
606: ,p_chunk_size => l_chunk_size
607: ,p_max_errors => g_max_errors_allowed);

Line 660: benutils.g_benefit_action_id := l_benefit_action_id;

656: ,p_program_update_date => sysdate
657: ,p_date_from => l_ocrd_date
658: ,p_uneai_effective_date => null);
659: --
660: benutils.g_benefit_action_id := l_benefit_action_id;
661: --
662: hr_utility.set_location ('l_benefit_action_id created is '||l_benefit_action_id,30);
663: -- Delete/clear ranges from ben_batch_ranges table
664: --

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

903: --hr_utility.trace_off;
904: Exception
905:
906: when l_no_one_to_process then
907: benutils.write(p_text => fnd_message.get);
908: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
909:
910: when l_no_irec_ler then
911: benutils.write(p_text => fnd_message.get);

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

904: Exception
905:
906: when l_no_one_to_process then
907: benutils.write(p_text => fnd_message.get);
908: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
909:
910: when l_no_irec_ler then
911: benutils.write(p_text => fnd_message.get);
912: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

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

907: benutils.write(p_text => fnd_message.get);
908: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
909:
910: when l_no_irec_ler then
911: benutils.write(p_text => fnd_message.get);
912: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
913:
914: when others then
915: --

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

908: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
909:
910: when l_no_irec_ler then
911: benutils.write(p_text => fnd_message.get);
912: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
913:
914: when others then
915: --
916: hr_utility.set_location('Super Error',10);

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

914: when others then
915: --
916: hr_utility.set_location('Super Error',10);
917: rollback;
918: benutils.write(p_text => fnd_message.get);
919: benutils.write(p_text => sqlerrm);
920: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
921: If (l_num_range > 0) then
922: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

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

915: --
916: hr_utility.set_location('Super Error',10);
917: rollback;
918: benutils.write(p_text => fnd_message.get);
919: benutils.write(p_text => sqlerrm);
920: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
921: If (l_num_range > 0) then
922: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
923: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

916: hr_utility.set_location('Super Error',10);
917: rollback;
918: benutils.write(p_text => fnd_message.get);
919: benutils.write(p_text => sqlerrm);
920: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
921: If (l_num_range > 0) then
922: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
923: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
924: ,p_person_selected => l_person_cnt