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

Line 37: * 20-JUL-99 Gperry 115.16 genutils -> benutils package rename.

33: * for error reports to fix concurrent
34: * manager display.
35: * 05-JUL-99 stee 115.15 Create benefit assignments for
36: * dependents who become ineligible.
37: * 20-JUL-99 Gperry 115.16 genutils -> benutils package rename.
38: * 24-Aug-99 maagrawa 115.17 Dependents related changes.
39: * 30-Aug-99 maagrawa 115.18 Added parameter p_dpnt_inelig_rsn_cd
40: * to dependent eligibility process
41: * to return ineligible reason.

Line 76: * derived inside benutils.formula

72: * 07-Jun-00 jcarpent 115.33 - Added init of l_returned_end_dt since
73: * was bleeding to other comp objects
74: * for dependent. (4728)
75: * 29-aug-01 pbodla 115.34 - bug:1949361 jurisdiction code is
76: * derived inside benutils.formula
77: * 18-dec-01 tjesumic 115.35 - cwb changes
78: * 20-dec-01 ikasire 115.36 added dbdrv lines
79: * 20-dec-01 ikasire 115.37 added commit
80: * 12-feb-02 pabodla 115.38 Bug 1579948 Fix: if g_profile_value is

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

360: dt_fndate.change_ses_date
361: (p_ses_date => l_effective_date,
362: p_commit => l_commit);
363: --
364: l_actn := 'Calling benutils.get_parameter...';
365: benutils.get_parameter(p_business_group_id => p_business_group_Id
366: ,p_batch_exe_cd => 'BENDSGEL'
367: ,p_threads => l_threads
368: ,p_chunk_size => l_chunk_size

Line 365: benutils.get_parameter(p_business_group_id => p_business_group_Id

361: (p_ses_date => l_effective_date,
362: p_commit => l_commit);
363: --
364: l_actn := 'Calling benutils.get_parameter...';
365: benutils.get_parameter(p_business_group_id => p_business_group_Id
366: ,p_batch_exe_cd => 'BENDSGEL'
367: ,p_threads => l_threads
368: ,p_chunk_size => l_chunk_size
369: ,p_max_errors => g_max_errors_allowed);

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

380: --
381: l_actn := 'Calling ben_batch_utils.ini...';
382: ben_batch_utils.ini;
383: --
384: -- Copy benefit action id to global in benutils package
385: --
386: benutils.g_benefit_action_id := p_benefit_action_id;
387: benutils.g_thread_id := p_thread_id;
388: g_persons_errored := 0;

Line 386: benutils.g_benefit_action_id := p_benefit_action_id;

382: ben_batch_utils.ini;
383: --
384: -- Copy benefit action id to global in benutils package
385: --
386: benutils.g_benefit_action_id := p_benefit_action_id;
387: benutils.g_thread_id := p_thread_id;
388: g_persons_errored := 0;
389: g_persons_processed := 0;
390: open c_parameter;

Line 387: benutils.g_thread_id := p_thread_id;

383: --
384: -- Copy benefit action id to global in benutils package
385: --
386: benutils.g_benefit_action_id := p_benefit_action_id;
387: benutils.g_thread_id := p_thread_id;
388: g_persons_errored := 0;
389: g_persons_processed := 0;
390: open c_parameter;
391: fetch c_parameter into l_parm;

Line 488: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); --Bug 5070692

484: If (g_persons_errored > g_max_errors_allowed) then
485: fnd_message.raise_error;
486: End if;
487: End;
488: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); --Bug 5070692
489: End loop;
490: Else
491: --
492: l_actn := 'Erroring out nocopy since not person is found in range...' ;

Line 498: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); --Bug 5070692

494: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.raise_error;
497: End if;
498: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); --Bug 5070692
499: End loop;
500: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); -- Bug5070692
501: --
502: l_actn := 'Calling Log_statistics...';

Line 500: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); -- Bug5070692

496: fnd_message.raise_error;
497: End if;
498: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); --Bug 5070692
499: End loop;
500: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); -- Bug5070692
501: --
502: l_actn := 'Calling Log_statistics...';
503: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
504: ,p_num_pers_errored => g_persons_errored

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

512: );
513: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
514: ,p_num_pers_errored => g_persons_errored
515: );
516: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
517: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
518: fnd_message.set_token('PROCEDURE', l_proc);
519: fnd_message.set_token('STEP',l_actn );
520: fnd_message.raise_error;

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

817: -- assure they are sensible.
818: -- chunk_size between(10 and 100). If not in range, default to 20.
819: -- threads between <1 and 100>. If not in range, default to 1
820: --
821: l_actn := 'Calling benutils.get_parameter...';
822: benutils.get_parameter(p_business_group_id => p_business_group_Id
823: ,p_batch_exe_cd => 'BENDSGEL'
824: ,p_threads => l_threads
825: ,p_chunk_size => l_chunk_size

Line 822: benutils.get_parameter(p_business_group_id => p_business_group_Id

818: -- chunk_size between(10 and 100). If not in range, default to 20.
819: -- threads between <1 and 100>. If not in range, default to 1
820: --
821: l_actn := 'Calling benutils.get_parameter...';
822: benutils.get_parameter(p_business_group_id => p_business_group_Id
823: ,p_batch_exe_cd => 'BENDSGEL'
824: ,p_threads => l_threads
825: ,p_chunk_size => l_chunk_size
826: ,p_max_errors => g_max_errors_allowed);

Line 827: benutils.g_benefit_action_id := p_benefit_action_id;

823: ,p_batch_exe_cd => 'BENDSGEL'
824: ,p_threads => l_threads
825: ,p_chunk_size => l_chunk_size
826: ,p_max_errors => g_max_errors_allowed);
827: benutils.g_benefit_action_id := p_benefit_action_id;
828: benutils.g_thread_id := 99;
829: --
830: -- Create benefit actions parameters in the benefit action table.
831: -- Do not create is a benefit action already exists, in other words

Line 828: benutils.g_thread_id := 99;

824: ,p_threads => l_threads
825: ,p_chunk_size => l_chunk_size
826: ,p_max_errors => g_max_errors_allowed);
827: benutils.g_benefit_action_id := p_benefit_action_id;
828: benutils.g_thread_id := 99;
829: --
830: -- Create benefit actions parameters in the benefit action table.
831: -- Do not create is a benefit action already exists, in other words
832: -- we are doing a restart.

Line 872: benutils.g_benefit_action_id := l_benefit_action_id;

868: ,p_program_application_id => fnd_global.prog_appl_id
869: ,p_program_id => fnd_global.conc_program_id
870: ,p_program_update_date => sysdate
871: );
872: benutils.g_benefit_action_id := l_benefit_action_id;
873: --
874: -- Delete/clear ranges from ben_batch_ranges table
875: --
876: l_actn := 'Delete rows from ben_batch_ranges..';

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

1061: when others then
1062: ben_batch_utils.rpt_error(p_proc => l_proc
1063: ,p_last_actn => l_actn
1064: ,p_rpt_flag => TRUE );
1065: benutils.write(p_text => fnd_message.get);
1066: benutils.write(p_text => sqlerrm);
1067: -- benutils.write(p_text => 'Big Error Occured');
1068: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1069: If (l_num_range > 0) then

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

1062: ben_batch_utils.rpt_error(p_proc => l_proc
1063: ,p_last_actn => l_actn
1064: ,p_rpt_flag => TRUE );
1065: benutils.write(p_text => fnd_message.get);
1066: benutils.write(p_text => sqlerrm);
1067: -- benutils.write(p_text => 'Big Error Occured');
1068: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1069: If (l_num_range > 0) then
1070: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

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

1063: ,p_last_actn => l_actn
1064: ,p_rpt_flag => TRUE );
1065: benutils.write(p_text => fnd_message.get);
1066: benutils.write(p_text => sqlerrm);
1067: -- benutils.write(p_text => 'Big Error Occured');
1068: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1069: If (l_num_range > 0) then
1070: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1071: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

1064: ,p_rpt_flag => TRUE );
1065: benutils.write(p_text => fnd_message.get);
1066: benutils.write(p_text => sqlerrm);
1067: -- benutils.write(p_text => 'Big Error Occured');
1068: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1069: If (l_num_range > 0) then
1070: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1071: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1072: ,p_person_selected => l_person_cnt

Line 1164: l_outputs := benutils.formula

1160: end if;
1161: */
1162: -- Call formula initialise routine
1163: --
1164: l_outputs := benutils.formula
1165: (p_formula_id => p_comp_selection_rule_id
1166: ,p_effective_date => p_effective_date
1167: ,p_pgm_id => p_pgm_id
1168: ,p_pl_id => p_pl_id

Line 1847: ,p_benefit_action_id => benutils.g_benefit_action_id

1843: and nvl(g_profile_value, 'Y') = 'Y')) then
1844: ben_batch_dpnt_info_api.create_batch_dpnt_info
1845: (p_batch_dpnt_id => l_id
1846: ,p_person_id => l_cache(i).person_id
1847: ,p_benefit_action_id => benutils.g_benefit_action_id
1848: ,p_business_group_id => p_business_group_id
1849: ,p_pgm_id => l_cache(i).pgm_id
1850: ,p_pl_id => l_cache(i).pl_id
1851: ,p_oipl_id => l_cache(i).oipl_id

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

1878: When others then
1879: rollback to process_default_enrt_savepoint;
1880: g_persons_errored := g_persons_errored + 1;
1881: -- capture the error message
1882: benutils.write(p_text => fnd_message.get);
1883: benutils.write(p_text => sqlerrm);
1884: ben_batch_utils.write_error_rec;
1885: ben_batch_utils.rpt_error(p_proc => l_proc
1886: ,p_last_actn => l_actn

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

1879: rollback to process_default_enrt_savepoint;
1880: g_persons_errored := g_persons_errored + 1;
1881: -- capture the error message
1882: benutils.write(p_text => fnd_message.get);
1883: benutils.write(p_text => sqlerrm);
1884: ben_batch_utils.write_error_rec;
1885: ben_batch_utils.rpt_error(p_proc => l_proc
1886: ,p_last_actn => l_actn
1887: ,p_rpt_flag => TRUE);