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

Line 16: * 20-JUL-99 Gperry 115.1 genutils -> benutils package rename.

12: * History
13: * Date Who Version What?
14: * --------- --------- ------- --------------------------------------
15: * 13-Jul-99 isen 115.0 Created
16: * 20-JUL-99 Gperry 115.1 genutils -> benutils package rename.
17: * 03-AUG-99 Gperry 115.2 CBO fix to_char with soft coded
18: * keyflex.
19: * 13-SEP-99 Asen 115.3 Added call to error reports.
20: * 04-OCT-99 Gperry 115.4 Made whole process actually work.

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

304: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
305: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
306: --
307: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
308: fnd_message.set_token('PROC','benutils.get_parameter');
309: benutils.get_parameter(p_business_group_id => p_business_group_id
310: ,p_batch_exe_cd => 'BENBOCON'
311: ,p_threads => l_threads
312: ,p_chunk_size => l_chunk_size

Line 309: benutils.get_parameter(p_business_group_id => p_business_group_id

305: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
306: --
307: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
308: fnd_message.set_token('PROC','benutils.get_parameter');
309: benutils.get_parameter(p_business_group_id => p_business_group_id
310: ,p_batch_exe_cd => 'BENBOCON'
311: ,p_threads => l_threads
312: ,p_chunk_size => l_chunk_size
313: ,p_max_errors => g_max_errors_allowed);

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

321: p_threads => l_threads,
322: p_max_errors => g_max_errors_allowed,
323: p_benefit_action_id => p_benefit_action_id);
324: --
325: -- Copy benefit action id to global in benutils package
326: --
327: benutils.g_benefit_action_id := p_benefit_action_id;
328: benutils.g_thread_id := p_thread_id;
329: g_persons_errored := 0;

Line 327: benutils.g_benefit_action_id := p_benefit_action_id;

323: p_benefit_action_id => p_benefit_action_id);
324: --
325: -- Copy benefit action id to global in benutils package
326: --
327: benutils.g_benefit_action_id := p_benefit_action_id;
328: benutils.g_thread_id := p_thread_id;
329: g_persons_errored := 0;
330: g_persons_processed := 0;
331: --

Line 328: benutils.g_thread_id := p_thread_id;

324: --
325: -- Copy benefit action id to global in benutils package
326: --
327: benutils.g_benefit_action_id := p_benefit_action_id;
328: benutils.g_thread_id := p_thread_id;
329: g_persons_errored := 0;
330: g_persons_processed := 0;
331: --
332: open c_parameter;

Line 406: benutils.set_cache_record_position;

402: --
403: exit when c_person_thread%notfound;
404: --
405: savepoint last_place;
406: benutils.set_cache_record_position;
407: --
408:
409: --
410: -- Commented out for CWB - Bug # 2183388

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

527: -- This is to assign the per_in_ler_id in the record to extract the
528: -- the electable choices later.
529: g_rec.temporal_ler_id := l_ler_thread.per_in_ler_id;
530:
531: benutils.write(p_rec => g_rec);
532: --
533: End loop;
534: --
535: close c_ler_thread;

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

540: set action_status_cd = 'P'
541: where person_id = l_person_id
542: and benefit_action_id = p_benefit_action_id;
543: --
544: benutils.write(l_per_rec.full_name||' processed successfully');
545: g_persons_processed := g_persons_processed + 1;
546: --
547: exception
548: --

Line 568: benutils.rollback_cache;

564: --
565: end if;
566: --
567: rollback to last_place;
568: benutils.rollback_cache;
569: --
570: update ben_person_actions
571: set action_status_cd = 'E'
572: where person_id = l_person_id

Line 580: -- g_rec.text := fnd_message.get; -- Bug 2376630 Moved code below benutils.get_message_name

576: --
577: g_persons_errored := g_persons_errored + 1;
578: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
579: g_rec.rep_typ_cd := 'ERROR_LF';
580: -- g_rec.text := fnd_message.get; -- Bug 2376630 Moved code below benutils.get_message_name
581: g_rec.person_id := l_person_id;
582:
583: -- Bug 2376330 start
584: -- Added National Identifier and Error Message code

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

583: -- Bug 2376330 start
584: -- Added National Identifier and Error Message code
585:
586: g_rec.national_identifier := l_per_rec.national_identifier;
587: g_rec.error_message_code := benutils.get_message_name;
588: g_rec.text := fnd_message.get;
589:
590: -- Bug 2376330 end
591: --

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

589:
590: -- Bug 2376330 end
591: --
592: hr_utility.set_location('Error Message '||g_rec.text,10);
593: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
594: benutils.write(g_rec.text);
595: benutils.write(p_rec => g_rec);
596: --
597: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);

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

590: -- Bug 2376330 end
591: --
592: hr_utility.set_location('Error Message '||g_rec.text,10);
593: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
594: benutils.write(g_rec.text);
595: benutils.write(p_rec => g_rec);
596: --
597: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
598: hr_utility.set_location('Num Errors = '||g_persons_errored,10);

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

591: --
592: hr_utility.set_location('Error Message '||g_rec.text,10);
593: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
594: benutils.write(g_rec.text);
595: benutils.write(p_rec => g_rec);
596: --
597: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
598: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
599: if g_persons_errored > g_max_errors_allowed then

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

598: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
599: if g_persons_errored > g_max_errors_allowed then
600: --
601: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
602: benutils.write(p_text => fnd_message.get);
603: --
604: raise;
605: --
606: end if;

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

623: --
624: end if;
625: --
626: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
627: fnd_message.set_token('PROC','benutils.write_table_and_file');
628: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
629: commit;
630: --
631: end loop;

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

624: end if;
625: --
626: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
627: fnd_message.set_token('PROC','benutils.write_table_and_file');
628: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
629: commit;
630: --
631: end loop;
632: --

Line 650: benutils.rollback_cache;

646: hr_utility.set_location('Super Error',10);
647: hr_utility.set_location(sqlerrm,10);
648: hr_utility.set_location('Super Error',10);
649: rollback;
650: benutils.rollback_cache;
651: --
652: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
653: g_rec.rep_typ_cd := 'FATAL';
654: g_rec.text := fnd_message.get;

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

653: g_rec.rep_typ_cd := 'FATAL';
654: g_rec.text := fnd_message.get;
655: g_rec.person_id := l_person_id;
656: --
657: benutils.write(p_text => g_rec.text);
658: benutils.write(p_rec => g_rec);
659: --
660: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
661: ,p_num_pers_errored => g_persons_errored);

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

654: g_rec.text := fnd_message.get;
655: g_rec.person_id := l_person_id;
656: --
657: benutils.write(p_text => g_rec.text);
658: benutils.write(p_rec => g_rec);
659: --
660: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
661: ,p_num_pers_errored => g_persons_errored);
662: --

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

659: --
660: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
661: ,p_num_pers_errored => g_persons_errored);
662: --
663: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
664: --
665: commit;
666: --
667: fnd_message.raise_error;

Line 936: benutils.get_parameter(p_business_group_id => p_business_group_id

932: --
933: ben_batch_utils.ini;
934: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
935: --
936: benutils.get_parameter(p_business_group_id => p_business_group_id
937: ,p_batch_exe_cd => 'BENBOCON'
938: ,p_threads => l_threads
939: ,p_chunk_size => l_chunk_size
940: ,p_max_errors => g_max_errors_allowed);

Line 989: benutils.g_benefit_action_id := l_benefit_action_id;

985: ,p_uneai_effective_date => l_to_ocrd_date
986: --Bug No 4034201
987: ,p_ptnl_ler_for_per_stat_cd => p_bckt_stat_cd);
988: --
989: benutils.g_benefit_action_id := l_benefit_action_id;
990: --
991: -- Delete/clear ranges from ben_batch_ranges table
992: --
993: Delete from ben_batch_ranges

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

1224: hr_utility.trace_off;
1225: Exception
1226: --Bug 2253040
1227: when l_no_one_to_process then
1228: benutils.write(p_text => fnd_message.get);
1229: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1230: --Bug 2253040
1231:
1232: when others then

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

1225: Exception
1226: --Bug 2253040
1227: when l_no_one_to_process then
1228: benutils.write(p_text => fnd_message.get);
1229: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1230: --Bug 2253040
1231:
1232: when others then
1233: --

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

1232: when others then
1233: --
1234: hr_utility.set_location('Super Error',10);
1235: rollback;
1236: benutils.write(p_text => fnd_message.get);
1237: benutils.write(p_text => sqlerrm);
1238: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1239: If (l_num_range > 0) then
1240: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

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

1233: --
1234: hr_utility.set_location('Super Error',10);
1235: rollback;
1236: benutils.write(p_text => fnd_message.get);
1237: benutils.write(p_text => sqlerrm);
1238: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1239: If (l_num_range > 0) then
1240: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1241: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

1234: hr_utility.set_location('Super Error',10);
1235: rollback;
1236: benutils.write(p_text => fnd_message.get);
1237: benutils.write(p_text => sqlerrm);
1238: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1239: If (l_num_range > 0) then
1240: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1241: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1242: ,p_person_selected => l_person_cnt