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

Line 192: benutils.iftrue

188: ,buff => '---------------------------');
189: --
190: fnd_file.put_line(which => fnd_file.log
191: ,buff => 'Benefit Action ID : '||
192: benutils.iftrue
193: (p_expression => g_parm.benefit_action_id is null
194: ,p_true => 'NONE'
195: ,p_false => g_parm.benefit_action_id));
196: --

Line 208: benutils.iftrue

204: g_parm.business_group_id);
205: --
206: fnd_file.put_line(which => fnd_file.log
207: ,buff => 'Person ID : ' ||
208: benutils.iftrue
209: (p_expression => g_parm.person_id is null
210: ,p_true => 'All'
211: ,p_false => g_parm.person_id));
212: --

Line 215: benutils.iftrue

211: ,p_false => g_parm.person_id));
212: --
213: fnd_file.put_line(which => fnd_file.log
214: ,buff => 'Person Type ID : ' ||
215: benutils.iftrue
216: (p_expression => g_parm.person_type_id is null
217: ,p_true => 'All'
218: ,p_false => g_parm.person_type_id));
219: --

Line 222: benutils.iftrue

218: ,p_false => g_parm.person_type_id));
219: --
220: fnd_file.put_line(which => fnd_file.log
221: ,buff => 'Person Selection Rule : ' ||
222: benutils.iftrue
223: (p_expression => g_parm.person_sel_rl is null
224: ,p_true => 'All'
225: ,p_false => g_parm.person_sel_rl));
226: --

Line 229: benutils.iftrue

225: ,p_false => g_parm.person_sel_rl));
226: --
227: fnd_file.put_line(which => fnd_file.log
228: ,buff => 'Comp Object Selection Rule : ' ||
229: benutils.iftrue
230: (p_expression => g_parm.comp_selection_rl is null
231: ,p_true => 'All'
232: ,p_false => g_parm.comp_selection_rl));
233: --

Line 236: benutils.iftrue

232: ,p_false => g_parm.comp_selection_rl));
233: --
234: fnd_file.put_line(which => fnd_file.log
235: ,buff => 'Organization ID : ' ||
236: benutils.iftrue
237: (p_expression => g_parm.organization_id is null
238: ,p_true => 'All'
239: ,p_false => g_parm.organization_id));
240: --

Line 243: benutils.iftrue

239: ,p_false => g_parm.organization_id));
240: --
241: fnd_file.put_line(which => fnd_file.log
242: ,buff => 'Location ID : ' ||
243: benutils.iftrue
244: (p_expression => g_parm.location_id is null
245: ,p_true => 'All'
246: ,p_false => g_parm.location_id));
247: --

Line 250: benutils.iftrue

246: ,p_false => g_parm.location_id));
247: --
248: fnd_file.put_line(which => fnd_file.log
249: ,buff => 'Life Event Reason ID : ' ||
250: benutils.iftrue
251: (p_expression => g_parm.ler_id is null
252: ,p_true => 'All'
253: ,p_false => g_parm.ler_id));
254: --

Line 257: benutils.iftrue

253: ,p_false => g_parm.ler_id));
254: --
255: fnd_file.put_line(which => fnd_file.log
256: ,buff => 'Life Event Occured Date : ' ||
257: benutils.iftrue
258: (p_expression => g_parm.lf_evt_ocrd_dt is null
259: ,p_true => 'All'
260: ,p_false => g_parm.lf_evt_ocrd_dt));
261: --

Line 264: benutils.iftrue

260: ,p_false => g_parm.lf_evt_ocrd_dt));
261: --
262: fnd_file.put_line(which => fnd_file.log
263: ,buff => 'Program ID : '||
264: benutils.iftrue
265: (p_expression => g_parm.pgm_id is null
266: ,p_true => 'All'
267: ,p_false => g_parm.pgm_id));
268: --

Line 271: benutils.iftrue

267: ,p_false => g_parm.pgm_id));
268: --
269: fnd_file.put_line(which => fnd_file.log,
270: buff => 'Plan ID : '||
271: benutils.iftrue
272: (p_expression => g_parm.pl_nip_id is null
273: ,p_true => 'All'
274: ,p_false => g_parm.pl_nip_id));
275: --

Line 278: benutils.iftrue

274: ,p_false => g_parm.pl_nip_id));
275: --
276: fnd_file.put_line(which => fnd_file.log,
277: buff => 'Service Area : '||
278: benutils.iftrue
279: (p_expression => g_parm.svc_area_id is null
280: ,p_true => 'All'
281: ,p_false => g_parm.svc_area_id));
282: --

Line 285: benutils.iftrue

281: ,p_false => g_parm.svc_area_id));
282: --
283: fnd_file.put_line(which => fnd_file.log,
284: buff => 'Assignment Type : '||
285: benutils.iftrue
286: (p_expression => g_parm.assgn_type is null
287: ,p_true => 'All'
288: ,p_false => g_parm.assgn_type));
289: --

Line 292: benutils.iftrue

288: ,p_false => g_parm.assgn_type));
289: --
290: fnd_file.put_line(which => fnd_file.log,
291: buff => 'Coverage Start Date : '||
292: benutils.iftrue
293: (p_expression => g_parm.cvg_strt_dt is null
294: ,p_true => 'All'
295: ,p_false => g_parm.cvg_strt_dt));
296: --

Line 299: benutils.iftrue

295: ,p_false => g_parm.cvg_strt_dt));
296: --
297: fnd_file.put_line(which => fnd_file.log,
298: buff => 'Coverage End Date : '||
299: benutils.iftrue
300: (p_expression => g_parm.cvg_end_dt is null
301: ,p_true => 'All'
302: ,p_false => g_parm.cvg_end_dt));
303: --

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

581: End if;
582: close c1;
583: -- Call formula initialise routine
584: --
585: l_actn := 'Calling benutils.formula procedure...';
586:
587: l_outputs := benutils.formula
588: (p_formula_id => p_person_selection_rule_id
589: ,p_effective_date => p_effective_date

Line 587: l_outputs := benutils.formula

583: -- Call formula initialise routine
584: --
585: l_actn := 'Calling benutils.formula procedure...';
586:
587: l_outputs := benutils.formula
588: (p_formula_id => p_person_selection_rule_id
589: ,p_effective_date => p_effective_date
590: ,p_business_group_id => p_business_group_id
591: ,p_assignment_id => l_assignment_id

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

593: ,p_param1_value => to_char(p_person_id));
594: p_return := l_outputs(l_outputs.first).value;
595: --
596: -- fnd_file.put_line(fnd_file.log, to_char(l_assignment_id)||' -> ' || p_return );
597: l_actn := 'Evaluating benutils.formula return...';
598: --
599: If upper(p_return) not in ('Y', 'N') then
600: Raise value_exception ;
601: End if;

Line 682: l_outputs := benutils.formula

678: end if;
679:
680: -- Call formula initialise routine
681: --
682: l_outputs := benutils.formula
683: (p_formula_id => p_comp_selection_rule_id
684: ,p_effective_date => p_effective_date
685: ,p_pgm_id => p_pgm_id
686: ,p_pl_id => p_pl_id

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

728: begin
729: --
730: hr_utility.set_location('Entering : ' || l_proc, 10);
731: --
732: benutils.write(p_text => benutils.g_banner_minus);
733: benutils.write(p_text => 'Batch Process Statistical Information');
734: benutils.write(p_text => benutils.g_banner_minus);
735: benutils.write(p_text => 'People processed : ' || g_person_cnt);
736: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);

Line 733: benutils.write(p_text => 'Batch Process Statistical Information');

729: --
730: hr_utility.set_location('Entering : ' || l_proc, 10);
731: --
732: benutils.write(p_text => benutils.g_banner_minus);
733: benutils.write(p_text => 'Batch Process Statistical Information');
734: benutils.write(p_text => benutils.g_banner_minus);
735: benutils.write(p_text => 'People processed : ' || g_person_cnt);
736: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
737: benutils.write(p_text => benutils.g_banner_minus);

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

730: hr_utility.set_location('Entering : ' || l_proc, 10);
731: --
732: benutils.write(p_text => benutils.g_banner_minus);
733: benutils.write(p_text => 'Batch Process Statistical Information');
734: benutils.write(p_text => benutils.g_banner_minus);
735: benutils.write(p_text => 'People processed : ' || g_person_cnt);
736: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
737: benutils.write(p_text => benutils.g_banner_minus);
738: --

Line 735: benutils.write(p_text => 'People processed : ' || g_person_cnt);

731: --
732: benutils.write(p_text => benutils.g_banner_minus);
733: benutils.write(p_text => 'Batch Process Statistical Information');
734: benutils.write(p_text => benutils.g_banner_minus);
735: benutils.write(p_text => 'People processed : ' || g_person_cnt);
736: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
737: benutils.write(p_text => benutils.g_banner_minus);
738: --
739: benutils.write_table_and_file(p_table => true

Line 736: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);

732: benutils.write(p_text => benutils.g_banner_minus);
733: benutils.write(p_text => 'Batch Process Statistical Information');
734: benutils.write(p_text => benutils.g_banner_minus);
735: benutils.write(p_text => 'People processed : ' || g_person_cnt);
736: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
737: benutils.write(p_text => benutils.g_banner_minus);
738: --
739: benutils.write_table_and_file(p_table => true
740: ,p_file => true);

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

733: benutils.write(p_text => 'Batch Process Statistical Information');
734: benutils.write(p_text => benutils.g_banner_minus);
735: benutils.write(p_text => 'People processed : ' || g_person_cnt);
736: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
737: benutils.write(p_text => benutils.g_banner_minus);
738: --
739: benutils.write_table_and_file(p_table => true
740: ,p_file => true);
741: commit;

Line 739: benutils.write_table_and_file(p_table => true

735: benutils.write(p_text => 'People processed : ' || g_person_cnt);
736: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
737: benutils.write(p_text => benutils.g_banner_minus);
738: --
739: benutils.write_table_and_file(p_table => true
740: ,p_file => true);
741: commit;
742: --
743: hr_utility.set_location('Leaving : ' || l_proc, 10);

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

745: exception
746: --
747: when others then
748: --
749: benutils.write(p_text => sqlerrm);
750: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
751: fnd_message.set_token('PROC',l_proc);
752: benutils.write(p_text => fnd_message.get);
753: fnd_message.raise_error;

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

748: --
749: benutils.write(p_text => sqlerrm);
750: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
751: fnd_message.set_token('PROC',l_proc);
752: benutils.write(p_text => fnd_message.get);
753: fnd_message.raise_error;
754: --
755: end write_logfile;
756: --

Line 1369: benutils.get_parameter

1365: -- Get the parameters for the batch process so we know how many slaves to
1366: -- start and what size the chunk size is. Store them in globals.
1367: --
1368: if p_report_name = 'BENSMREP' then
1369: benutils.get_parameter
1370: (p_business_group_id => p_business_group_id
1371: ,p_batch_exe_cd => 'BENSMREP'
1372: ,p_threads => g_threads
1373: ,p_chunk_size => g_chunk_size

Line 1376: benutils.get_parameter

1372: ,p_threads => g_threads
1373: ,p_chunk_size => g_chunk_size
1374: ,p_max_errors => g_max_errors);
1375: elsif p_report_name = 'BEENRKIT' then
1376: benutils.get_parameter
1377: (p_business_group_id => p_business_group_id
1378: ,p_batch_exe_cd => 'BEENRKIT'
1379: ,p_threads => g_threads
1380: ,p_chunk_size => g_chunk_size

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

1620: ben_batch_utils.rpt_error(p_proc => l_package
1621: ,p_last_actn => l_actn
1622: ,p_rpt_flag => TRUE );
1623: --
1624: benutils.write(p_text => fnd_message.get);
1625: benutils.write(p_text => sqlerrm);
1626: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1627: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',689);
1628: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

1621: ,p_last_actn => l_actn
1622: ,p_rpt_flag => TRUE );
1623: --
1624: benutils.write(p_text => fnd_message.get);
1625: benutils.write(p_text => sqlerrm);
1626: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1627: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',689);
1628: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1629: fnd_message.set_token('PROCEDURE', l_package);

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

1622: ,p_rpt_flag => TRUE );
1623: --
1624: benutils.write(p_text => fnd_message.get);
1625: benutils.write(p_text => sqlerrm);
1626: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1627: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',689);
1628: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1629: fnd_message.set_token('PROCEDURE', l_package);
1630: fnd_message.set_token('STEP', l_actn );