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 313: fnd_message.set_token('PROC','benutils.get_parameter');

309: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
310: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
311: --
312: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
313: fnd_message.set_token('PROC','benutils.get_parameter');
314: benutils.get_parameter(p_business_group_id => p_business_group_id
315: ,p_batch_exe_cd => 'BENBOCON'
316: ,p_threads => l_threads
317: ,p_chunk_size => l_chunk_size

Line 314: benutils.get_parameter(p_business_group_id => p_business_group_id

310: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
311: --
312: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
313: fnd_message.set_token('PROC','benutils.get_parameter');
314: benutils.get_parameter(p_business_group_id => p_business_group_id
315: ,p_batch_exe_cd => 'BENBOCON'
316: ,p_threads => l_threads
317: ,p_chunk_size => l_chunk_size
318: ,p_max_errors => g_max_errors_allowed);

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

326: p_threads => l_threads,
327: p_max_errors => g_max_errors_allowed,
328: p_benefit_action_id => p_benefit_action_id);
329: --
330: -- Copy benefit action id to global in benutils package
331: --
332: benutils.g_benefit_action_id := p_benefit_action_id;
333: benutils.g_thread_id := p_thread_id;
334: g_persons_errored := 0;

Line 332: benutils.g_benefit_action_id := p_benefit_action_id;

328: p_benefit_action_id => p_benefit_action_id);
329: --
330: -- Copy benefit action id to global in benutils package
331: --
332: benutils.g_benefit_action_id := p_benefit_action_id;
333: benutils.g_thread_id := p_thread_id;
334: g_persons_errored := 0;
335: g_persons_processed := 0;
336: --

Line 333: benutils.g_thread_id := p_thread_id;

329: --
330: -- Copy benefit action id to global in benutils package
331: --
332: benutils.g_benefit_action_id := p_benefit_action_id;
333: benutils.g_thread_id := p_thread_id;
334: g_persons_errored := 0;
335: g_persons_processed := 0;
336: --
337: open c_parameter;

Line 411: benutils.set_cache_record_position;

407: --
408: exit when c_person_thread%notfound;
409: --
410: savepoint last_place;
411: benutils.set_cache_record_position;
412: --
413:
414: --
415: -- Commented out for CWB - Bug # 2183388

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

551: -- the electable choices later.
552: hr_utility.set_location('Assign global values 2',10);
553: g_rec.temporal_ler_id := l_ler_thread.per_in_ler_id;
554:
555: benutils.write(p_rec => g_rec);
556: --
557: End loop;
558: --
559: --close c_ler_thread;

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

566: where person_id = l_person_id
567: and benefit_action_id = p_benefit_action_id;
568: hr_utility.set_location('after update',10);
569: --
570: benutils.write(l_per_rec.full_name||' processed successfully');
571: g_persons_processed := g_persons_processed + 1;
572: --
573: exception
574: --

Line 594: benutils.rollback_cache;

590: --
591: end if;
592: --
593: rollback to last_place;
594: benutils.rollback_cache;
595: --
596: update ben_person_actions
597: set action_status_cd = 'E'
598: where person_id = l_person_id

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

602: --
603: g_persons_errored := g_persons_errored + 1;
604: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
605: g_rec.rep_typ_cd := 'ERROR_LF';
606: -- g_rec.text := fnd_message.get; -- Bug 2376630 Moved code below benutils.get_message_name
607: g_rec.person_id := l_person_id;
608:
609: -- Bug 2376330 start
610: -- Added National Identifier and Error Message code

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

609: -- Bug 2376330 start
610: -- Added National Identifier and Error Message code
611:
612: g_rec.national_identifier := l_per_rec.national_identifier;
613: g_rec.error_message_code := benutils.get_message_name;
614: g_rec.text := fnd_message.get;
615:
616: -- Bug 2376330 end
617: --

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

615:
616: -- Bug 2376330 end
617: --
618: hr_utility.set_location('Error Message '||g_rec.text,10);
619: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
620: benutils.write(g_rec.text);
621: benutils.write(p_rec => g_rec);
622: --
623: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);

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

616: -- Bug 2376330 end
617: --
618: hr_utility.set_location('Error Message '||g_rec.text,10);
619: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
620: benutils.write(g_rec.text);
621: benutils.write(p_rec => g_rec);
622: --
623: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
624: hr_utility.set_location('Num Errors = '||g_persons_errored,10);

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

617: --
618: hr_utility.set_location('Error Message '||g_rec.text,10);
619: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
620: benutils.write(g_rec.text);
621: benutils.write(p_rec => g_rec);
622: --
623: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
624: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
625: if g_persons_errored > g_max_errors_allowed then

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

624: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
625: if g_persons_errored > g_max_errors_allowed then
626: --
627: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
628: benutils.write(p_text => fnd_message.get);
629: --
630: raise;
631: --
632: end if;

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

649: --
650: end if;
651: --
652: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
653: fnd_message.set_token('PROC','benutils.write_table_and_file');
654: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
655: commit;
656: --
657: end loop;

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

650: end if;
651: --
652: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
653: fnd_message.set_token('PROC','benutils.write_table_and_file');
654: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
655: commit;
656: --
657: end loop;
658: --

Line 676: benutils.rollback_cache;

672: hr_utility.set_location('Super Error',10);
673: hr_utility.set_location(sqlerrm,10);
674: hr_utility.set_location('Super Error',10);
675: rollback;
676: benutils.rollback_cache;
677: --
678: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
679: g_rec.rep_typ_cd := 'FATAL';
680: g_rec.text := fnd_message.get;

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

679: g_rec.rep_typ_cd := 'FATAL';
680: g_rec.text := fnd_message.get;
681: g_rec.person_id := l_person_id;
682: --
683: benutils.write(p_text => g_rec.text);
684: benutils.write(p_rec => g_rec);
685: --
686: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
687: ,p_num_pers_errored => g_persons_errored);

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

680: g_rec.text := fnd_message.get;
681: g_rec.person_id := l_person_id;
682: --
683: benutils.write(p_text => g_rec.text);
684: benutils.write(p_rec => g_rec);
685: --
686: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
687: ,p_num_pers_errored => g_persons_errored);
688: --

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

685: --
686: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
687: ,p_num_pers_errored => g_persons_errored);
688: --
689: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
690: --
691: commit;
692: --
693: fnd_message.raise_error;

Line 962: benutils.get_parameter(p_business_group_id => p_business_group_id

958: --
959: ben_batch_utils.ini;
960: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
961: --
962: benutils.get_parameter(p_business_group_id => p_business_group_id
963: ,p_batch_exe_cd => 'BENBOCON'
964: ,p_threads => l_threads
965: ,p_chunk_size => l_chunk_size
966: ,p_max_errors => g_max_errors_allowed);

Line 1015: benutils.g_benefit_action_id := l_benefit_action_id;

1011: ,p_uneai_effective_date => l_to_ocrd_date
1012: --Bug No 4034201
1013: ,p_ptnl_ler_for_per_stat_cd => p_bckt_stat_cd);
1014: --
1015: benutils.g_benefit_action_id := l_benefit_action_id;
1016: --
1017: -- Delete/clear ranges from ben_batch_ranges table
1018: --
1019: Delete from ben_batch_ranges

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

1250: hr_utility.trace_off;
1251: Exception
1252: --Bug 2253040
1253: when l_no_one_to_process then
1254: benutils.write(p_text => fnd_message.get);
1255: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1256: --Bug 2253040
1257:
1258: when others then

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

1251: Exception
1252: --Bug 2253040
1253: when l_no_one_to_process then
1254: benutils.write(p_text => fnd_message.get);
1255: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1256: --Bug 2253040
1257:
1258: when others then
1259: --

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

1258: when others then
1259: --
1260: hr_utility.set_location('Super Error',10);
1261: rollback;
1262: benutils.write(p_text => fnd_message.get);
1263: benutils.write(p_text => sqlerrm);
1264: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1265: If (l_num_range > 0) then
1266: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

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

1259: --
1260: hr_utility.set_location('Super Error',10);
1261: rollback;
1262: benutils.write(p_text => fnd_message.get);
1263: benutils.write(p_text => sqlerrm);
1264: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1265: If (l_num_range > 0) then
1266: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1267: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

1260: hr_utility.set_location('Super Error',10);
1261: rollback;
1262: benutils.write(p_text => fnd_message.get);
1263: benutils.write(p_text => sqlerrm);
1264: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1265: If (l_num_range > 0) then
1266: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1267: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1268: ,p_person_selected => l_person_cnt