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

Line 78: l_actn := 'Calling benutils.formula procedure...';

74: End if;
75: close c1;
76: -- Call formula initialise routine
77: --
78: l_actn := 'Calling benutils.formula procedure...';
79:
80: l_outputs := benutils.formula
81: (p_formula_id => p_person_selection_rule_id
82: ,p_effective_date => p_effective_date

Line 80: l_outputs := benutils.formula

76: -- Call formula initialise routine
77: --
78: l_actn := 'Calling benutils.formula procedure...';
79:
80: l_outputs := benutils.formula
81: (p_formula_id => p_person_selection_rule_id
82: ,p_effective_date => p_effective_date
83: ,p_business_group_id => p_business_group_id
84: ,p_assignment_id => l_assignment_id

Line 92: l_actn := 'Evaluating benutils.formula return...';

88: ,p_param2_value => p_input1_value);
89: --
90: p_return := l_outputs(l_outputs.first).value;
91: --
92: l_actn := 'Evaluating benutils.formula return...';
93: --
94: If upper(p_return) not in ('Y', 'N') then
95: Raise value_exception ;
96: End if;

Line 162: benutils.iftrue

158: ben_batch_utils.write(p_text =>'Business Group ID :' || p_business_group_id);
159: --
160: If (nvl(p_person_selection_rule_id,-1) <> hr_api.g_number) then
161: ben_batch_utils.write(p_text => 'Person Selection Rule :'||
162: benutils.iftrue
163: (p_expression => p_person_selection_rule_id is null
164: ,p_true => 'None'
165: ,p_false => p_person_selection_rule_id));
166: End if;

Line 171: benutils.iftrue

167: --
168: l_actn := 'Printing p_person_id...';
169: If (nvl(p_person_id,-1) <> hr_api.g_number) then
170: ben_batch_utils.write(p_text => 'Person ID :'||
171: benutils.iftrue
172: (p_expression => p_person_id is null
173: ,p_true => 'None'
174: ,p_false => p_person_id));
175: End if;

Line 181: benutils.iftrue

177: --
178: l_actn := 'Printing p_ler_id...';
179: If (nvl(p_ler_id,-1) <> hr_api.g_number) then
180: ben_batch_utils.write(p_text => 'Ler ID :'||
181: benutils.iftrue
182: (p_expression => p_ler_id is null
183: ,p_true => 'None'
184: ,p_false => p_ler_id));
185: End if;

Line 190: benutils.iftrue

186: --
187: l_actn := 'Printing p_organization_id...';
188: If (nvl(p_organization_id,-1) <> hr_api.g_number) then
189: ben_batch_utils.write(p_text => 'Organization ID :'||
190: benutils.iftrue
191: (p_expression => p_organization_id is null
192: ,p_true => 'None'
193: ,p_false => p_organization_id));
194: End if;

Line 199: benutils.iftrue

195: --
196: l_actn := 'Printing p_benfts_grp_id...';
197: If (nvl(p_benfts_grp_id,-1) <> hr_api.g_number) then
198: ben_batch_utils.write(p_text => 'Benefits Group ID :'||
199: benutils.iftrue
200: (p_expression => p_benfts_grp_id is null
201: ,p_true => 'None'
202: ,p_false => p_benfts_grp_id));
203: End if;

Line 208: benutils.iftrue

204: --
205: l_actn := 'Printing p_location_id...';
206: If (nvl(p_location_id,-1) <> hr_api.g_number) then
207: ben_batch_utils.write(p_text => 'Location ID :'||
208: benutils.iftrue
209: (p_expression => p_location_id is null
210: ,p_true => 'None'
211: ,p_false => p_location_id));
212: End if;

Line 217: benutils.iftrue

213: --
214: l_actn := 'Printing p_legal_entity_id...';
215: If (nvl(p_legal_entity_id,-1) <> hr_api.g_number) then
216: ben_batch_utils.write(p_text => 'Legal Entity ID :'||
217: benutils.iftrue
218: (p_expression => p_legal_entity_id is null
219: ,p_true => 'None'
220: ,p_false => p_legal_entity_id));
221: End if;

Line 226: benutils.iftrue

222: --
223: l_actn := 'Printing p_payroll_id...';
224: If (nvl(p_payroll_id,-1) <> hr_api.g_number) then
225: ben_batch_utils.write(p_text => 'Payroll ID :'||
226: benutils.iftrue
227: (p_expression => p_payroll_id is null
228: ,p_true => 'None'
229: ,p_false => p_payroll_id));
230: End if;

Line 394: benutils.get_parameter

390: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
391: --
392: -- Get the parameters defined for the batch process.
393: --
394: benutils.get_parameter
395: (p_business_group_id => p_business_group_id
396: ,p_batch_exe_cd => 'BENPRBCK'
397: ,p_threads => l_threads
398: ,p_chunk_size => l_chunk_size

Line 435: benutils.g_benefit_action_id := l_benefit_action_id;

431: ,p_program_application_id => fnd_global.prog_appl_id
432: ,p_program_id => fnd_global.conc_program_id
433: ,p_program_update_date => sysdate);
434: --
435: benutils.g_benefit_action_id := l_benefit_action_id;
436: --
437: benutils.g_thread_id := 99;
438: --
439: l_actn := 'Removing batch ranges ';

Line 437: benutils.g_thread_id := 99;

433: ,p_program_update_date => sysdate);
434: --
435: benutils.g_benefit_action_id := l_benefit_action_id;
436: --
437: benutils.g_thread_id := 99;
438: --
439: l_actn := 'Removing batch ranges ';
440: --
441: delete from ben_batch_ranges

Line 684: benutils.write(p_text => benutils.g_banner_minus);

680: --
681: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
682: --
683: --
684: benutils.write(p_text => benutils.g_banner_minus);
685: if p_delete_ptnl_life_evt = 'Y' and p_delete_life_evt = 'Y'
686: then
687: --
688: delete from ben_ptnl_ler_for_per

Line 720: benutils.write(p_text => benutils.g_banner_minus);

716: ben_batch_utils.write(p_text => ' No. of Voided Potentials Deleted = ' || sql%rowcount );
717: --
718: end if;
719: --
720: benutils.write(p_text => benutils.g_banner_minus);
721: --
722: -- Time to delete orphaned data in key transation tables as this causes
723: -- application errors and customers expect this process to delete all such data.
724: -- dont delete PEN as it has lot of other child tables.

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

752: ben_batch_utils.rpt_error(p_proc => l_proc
753: ,p_last_actn => l_actn
754: ,p_rpt_flag => TRUE);
755: --
756: benutils.write(p_text => fnd_message.get);
757: benutils.write(p_text => sqlerrm);
758: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
759: --
760: if l_num_ranges > 0 then

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

753: ,p_last_actn => l_actn
754: ,p_rpt_flag => TRUE);
755: --
756: benutils.write(p_text => fnd_message.get);
757: benutils.write(p_text => sqlerrm);
758: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
759: --
760: if l_num_ranges > 0 then
761: --

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

754: ,p_rpt_flag => TRUE);
755: --
756: benutils.write(p_text => fnd_message.get);
757: benutils.write(p_text => sqlerrm);
758: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
759: --
760: if l_num_ranges > 0 then
761: --
762: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

Line 855: l_rec benutils.g_active_life_event;

851: l_parm c_parameter%rowtype;
852: l_commit number;
853: --
854: -- start bug 3079317
855: l_rec benutils.g_active_life_event;
856: l_env ben_env_object.g_global_env_rec_type;
857: l_per_rec per_all_people_f%rowtype;
858: l_encoded_message varchar2(2000);
859: l_app_short_name varchar2(2000);

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

882: dt_fndate.change_ses_date
883: (p_ses_date => l_effective_date,
884: p_commit => l_commit);
885: --
886: l_actn := 'Calling benutils.get_parameter...';
887: benutils.get_parameter(p_business_group_id => p_business_group_id
888: ,p_batch_exe_cd => 'BENPRBCK'
889: ,p_threads => l_threads
890: ,p_chunk_size => l_chunk_size

Line 887: benutils.get_parameter(p_business_group_id => p_business_group_id

883: (p_ses_date => l_effective_date,
884: p_commit => l_commit);
885: --
886: l_actn := 'Calling benutils.get_parameter...';
887: benutils.get_parameter(p_business_group_id => p_business_group_id
888: ,p_batch_exe_cd => 'BENPRBCK'
889: ,p_threads => l_threads
890: ,p_chunk_size => l_chunk_size
891: ,p_max_errors => g_max_person_err);

Line 928: benutils.g_benefit_action_id := p_benefit_action_id;

924: g_le_clsn_rows := 0;
925: --
926: ben_batch_utils.ini;
927: --
928: benutils.g_benefit_action_id := p_benefit_action_id;
929: benutils.g_thread_id := p_thread_id;
930: --
931: -- Fetch the parameters defined for the batch process.
932: --

Line 929: benutils.g_thread_id := p_thread_id;

925: --
926: ben_batch_utils.ini;
927: --
928: benutils.g_benefit_action_id := p_benefit_action_id;
929: benutils.g_thread_id := p_thread_id;
930: --
931: -- Fetch the parameters defined for the batch process.
932: --
933: open c_parameter;

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

1058: g_rec.error_message_code := nvl(l_message_name , nvl(g_rec.error_message_code,sqlcode));
1059: g_rec.text := nvl(g_rec.text , nvl(g_rec.text,substr(sqlerrm,1,400)) );
1060: g_rec.rep_typ_cd := 'ERROR';
1061: g_rec.person_id := g_cache_per_proc(l_cnt).person_id;
1062: benutils.write(p_text => g_rec.text);
1063: benutils.write(p_rec => g_rec);
1064: --
1065: update ben_person_actions
1066: set action_status_cd = 'E'

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

1059: g_rec.text := nvl(g_rec.text , nvl(g_rec.text,substr(sqlerrm,1,400)) );
1060: g_rec.rep_typ_cd := 'ERROR';
1061: g_rec.person_id := g_cache_per_proc(l_cnt).person_id;
1062: benutils.write(p_text => g_rec.text);
1063: benutils.write(p_rec => g_rec);
1064: --
1065: update ben_person_actions
1066: set action_status_cd = 'E'
1067: where person_action_id = g_cache_per_proc(l_cnt).person_action_id;

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

1090: fnd_message.raise_error;
1091: --
1092: end if;
1093: --
1094: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1095: --
1096: commit;
1097: --
1098: end loop;

Line 1100: benutils.write(p_text => benutils.g_banner_minus);

1096: commit;
1097: --
1098: end loop;
1099: --
1100: benutils.write(p_text => benutils.g_banner_minus);
1101: benutils.write(p_text => 'Table Name No. Of Rows Deleted');
1102: benutils.write(p_text => '---------- -------------------');
1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));
1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));

Line 1101: benutils.write(p_text => 'Table Name No. Of Rows Deleted');

1097: --
1098: end loop;
1099: --
1100: benutils.write(p_text => benutils.g_banner_minus);
1101: benutils.write(p_text => 'Table Name No. Of Rows Deleted');
1102: benutils.write(p_text => '---------- -------------------');
1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));
1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));
1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));

Line 1102: benutils.write(p_text => '---------- -------------------');

1098: end loop;
1099: --
1100: benutils.write(p_text => benutils.g_banner_minus);
1101: benutils.write(p_text => 'Table Name No. Of Rows Deleted');
1102: benutils.write(p_text => '---------- -------------------');
1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));
1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));
1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));
1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));

Line 1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));

1099: --
1100: benutils.write(p_text => benutils.g_banner_minus);
1101: benutils.write(p_text => 'Table Name No. Of Rows Deleted');
1102: benutils.write(p_text => '---------- -------------------');
1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));
1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));
1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));
1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));
1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));

Line 1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));

1100: benutils.write(p_text => benutils.g_banner_minus);
1101: benutils.write(p_text => 'Table Name No. Of Rows Deleted');
1102: benutils.write(p_text => '---------- -------------------');
1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));
1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));
1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));
1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));
1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));
1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));

Line 1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));

1101: benutils.write(p_text => 'Table Name No. Of Rows Deleted');
1102: benutils.write(p_text => '---------- -------------------');
1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));
1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));
1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));
1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));
1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));
1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));
1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));

Line 1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));

1102: benutils.write(p_text => '---------- -------------------');
1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));
1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));
1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));
1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));
1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));
1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));
1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));
1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));

Line 1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));

1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));
1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));
1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));
1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));
1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));
1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));
1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));
1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));
1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));

Line 1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));

1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));
1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));
1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));
1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));
1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));
1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));
1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));
1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));
1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));

Line 1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));

1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));
1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));
1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));
1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));
1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));
1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));
1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));
1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));
1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));

Line 1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));

1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));
1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));
1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));
1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));
1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));
1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));
1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));
1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));
1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));

Line 1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));

1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));
1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));
1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));
1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));
1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));
1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));
1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));
1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));
1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));

Line 1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));

1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));
1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));
1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));
1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));
1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));
1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));
1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));
1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));
1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));

Line 1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));

1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));
1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));
1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));
1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));
1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));
1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));
1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));
1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));
1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));

Line 1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));

1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));
1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));
1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));
1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));
1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));
1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));
1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));
1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));
1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));

Line 1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));

1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));
1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));
1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));
1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));
1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));
1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));
1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));
1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));
1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));

Line 1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));

1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));
1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));
1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));
1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));
1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));
1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));
1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));
1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));
1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));

Line 1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));

1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));
1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));
1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));
1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));
1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));
1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));
1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));
1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));
1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));

Line 1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));

1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));
1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));
1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));
1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));
1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));
1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));
1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));
1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));
1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_rows));

Line 1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));

1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));
1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));
1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));
1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));
1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));
1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));
1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));
1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_rows));
1123: benutils.write(p_text => benutils.g_banner_minus);

Line 1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));

1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));
1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));
1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));
1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));
1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));
1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));
1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_rows));
1123: benutils.write(p_text => benutils.g_banner_minus);
1124: --

Line 1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));

1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));
1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));
1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));
1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));
1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));
1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_rows));
1123: benutils.write(p_text => benutils.g_banner_minus);
1124: --
1125: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

Line 1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_rows));

1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));
1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));
1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));
1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));
1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_rows));
1123: benutils.write(p_text => benutils.g_banner_minus);
1124: --
1125: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1126: --

Line 1123: benutils.write(p_text => benutils.g_banner_minus);

1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));
1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));
1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));
1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_rows));
1123: benutils.write(p_text => benutils.g_banner_minus);
1124: --
1125: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1126: --
1127: commit;

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

1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));
1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_rows));
1123: benutils.write(p_text => benutils.g_banner_minus);
1124: --
1125: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1126: --
1127: commit;
1128: --
1129: --

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

1136: --
1137: when others then
1138: --
1139: rollback;
1140: benutils.write(p_text => sqlerrm);
1141: --
1142: hr_utility.set_location('BENPRBCK Super Error ' || l_proc, 10);
1143: --
1144: ben_batch_utils.rpt_error(p_proc => l_proc

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

1147: --
1148: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd
1149: ,p_num_pers_errored => g_persons_errored);
1150: --
1151: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1152: --
1153: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1154: fnd_message.set_token('PROCEDURE', l_proc);
1155: fnd_message.set_token('STEP',l_actn );