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 FND_FILE

Line 97: --fnd_file.put_line(fnd_file.log,'Inside initialise globals ');

93: --
94: procedure initialize_globals is
95: begin
96: --
97: --fnd_file.put_line(fnd_file.log,'Inside initialise globals ');
98: g_person_cnt := 0;
99: g_person_actn_cnt := 0;
100: g_error_person_cnt := 0;
101: --

Line 122: -- fnd_file.put_line(fnd_file.log,'half way ');

118: g_parm.plan_in_pgm_flag := null;
119: g_parm.comp_selection_rl := null;
120: g_parm.lf_evt_ocrd_dt := null;
121: --
122: -- fnd_file.put_line(fnd_file.log,'half way ');
123: g_parm.rptg_grp := null;
124: g_parm.svc_area_id := null ;
125: g_parm.assgn_type := null ;
126: g_parm.cvg_strt_dt := null;

Line 143: --fnd_file.put_line(fnd_file.log,'Leaving initialise globals ');

139: g_threads := 3 ;
140: g_chunk_size := 10 ;
141: g_max_errors := 20 ;
142: g_num_ranges := 0 ;
143: --fnd_file.put_line(fnd_file.log,'Leaving initialise globals ');
144:
145: end initialize_globals;
146: --
147: -- ----------------------------------------------------------------------------

Line 184: fnd_file.put_line(which => fnd_file.log

180: if fnd_global.conc_request_id = -1 then
181: return;
182: end if;
183: --
184: fnd_file.put_line(which => fnd_file.log
185: ,buff => 'Runtime Parameters');
186: --
187: fnd_file.put_line(which => fnd_file.log
188: ,buff => '---------------------------');

Line 187: fnd_file.put_line(which => fnd_file.log

183: --
184: fnd_file.put_line(which => fnd_file.log
185: ,buff => 'Runtime Parameters');
186: --
187: fnd_file.put_line(which => fnd_file.log
188: ,buff => '---------------------------');
189: --
190: fnd_file.put_line(which => fnd_file.log
191: ,buff => 'Benefit Action ID : '||

Line 190: fnd_file.put_line(which => fnd_file.log

186: --
187: fnd_file.put_line(which => fnd_file.log
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'

Line 197: fnd_file.put_line(which => fnd_file.log

193: (p_expression => g_parm.benefit_action_id is null
194: ,p_true => 'NONE'
195: ,p_false => g_parm.benefit_action_id));
196: --
197: fnd_file.put_line(which => fnd_file.log
198: ,buff => 'Effective Date : '||
199: g_parm.effective_date );
200: -- to_char(g_parm.effective_date,'DD-MON-YYYY'));
201: --

Line 202: fnd_file.put_line(which => fnd_file.log

198: ,buff => 'Effective Date : '||
199: g_parm.effective_date );
200: -- to_char(g_parm.effective_date,'DD-MON-YYYY'));
201: --
202: fnd_file.put_line(which => fnd_file.log
203: ,buff => 'Business Group ID : '||
204: g_parm.business_group_id);
205: --
206: fnd_file.put_line(which => fnd_file.log

Line 206: fnd_file.put_line(which => fnd_file.log

202: fnd_file.put_line(which => fnd_file.log
203: ,buff => 'Business Group ID : '||
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'

Line 213: fnd_file.put_line(which => fnd_file.log

209: (p_expression => g_parm.person_id is null
210: ,p_true => 'All'
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'

Line 220: fnd_file.put_line(which => fnd_file.log

216: (p_expression => g_parm.person_type_id is null
217: ,p_true => 'All'
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'

Line 227: fnd_file.put_line(which => fnd_file.log

223: (p_expression => g_parm.person_sel_rl is null
224: ,p_true => 'All'
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'

Line 234: fnd_file.put_line(which => fnd_file.log

230: (p_expression => g_parm.comp_selection_rl is null
231: ,p_true => 'All'
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'

Line 241: fnd_file.put_line(which => fnd_file.log

237: (p_expression => g_parm.organization_id is null
238: ,p_true => 'All'
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'

Line 248: fnd_file.put_line(which => fnd_file.log

244: (p_expression => g_parm.location_id is null
245: ,p_true => 'All'
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'

Line 255: fnd_file.put_line(which => fnd_file.log

251: (p_expression => g_parm.ler_id is null
252: ,p_true => 'All'
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'

Line 262: fnd_file.put_line(which => fnd_file.log

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: --
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'

Line 269: fnd_file.put_line(which => fnd_file.log,

265: (p_expression => g_parm.pgm_id is null
266: ,p_true => 'All'
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'

Line 276: fnd_file.put_line(which => fnd_file.log,

272: (p_expression => g_parm.pl_nip_id is null
273: ,p_true => 'All'
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'

Line 283: fnd_file.put_line(which => fnd_file.log,

279: (p_expression => g_parm.svc_area_id is null
280: ,p_true => 'All'
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'

Line 290: fnd_file.put_line(which => fnd_file.log,

286: (p_expression => g_parm.assgn_type is null
287: ,p_true => 'All'
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'

Line 297: fnd_file.put_line(which => fnd_file.log,

293: (p_expression => g_parm.cvg_strt_dt is null
294: ,p_true => 'All'
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'

Line 304: fnd_file.put_line(which => fnd_file.log,

300: (p_expression => g_parm.cvg_end_dt is null
301: ,p_true => 'All'
302: ,p_false => g_parm.cvg_end_dt));
303: --
304: fnd_file.put_line(which => fnd_file.log,
305: buff => 'Is plan in program? : '||
306: g_parm.plan_in_pgm_flag);
307: --
308: fnd_file.put_line(which => fnd_file.log,

Line 308: fnd_file.put_line(which => fnd_file.log,

304: fnd_file.put_line(which => fnd_file.log,
305: buff => 'Is plan in program? : '||
306: g_parm.plan_in_pgm_flag);
307: --
308: fnd_file.put_line(which => fnd_file.log,
309: buff => 'Benefits Selection : '||
310: g_parm.ben_sel_flag);
311: --
312: fnd_file.put_line(which => fnd_file.log,

Line 312: fnd_file.put_line(which => fnd_file.log,

308: fnd_file.put_line(which => fnd_file.log,
309: buff => 'Benefits Selection : '||
310: g_parm.ben_sel_flag);
311: --
312: fnd_file.put_line(which => fnd_file.log,
313: buff => 'Flex Credit Summary : '||
314: g_parm.flx_sum_flag);
315: --
316: fnd_file.put_line(which => fnd_file.log,

Line 316: fnd_file.put_line(which => fnd_file.log,

312: fnd_file.put_line(which => fnd_file.log,
313: buff => 'Flex Credit Summary : '||
314: g_parm.flx_sum_flag);
315: --
316: fnd_file.put_line(which => fnd_file.log,
317: buff => 'Action Items Flag : '||
318: g_parm.actn_items_flag);
319: --
320: fnd_file.put_line(which => fnd_file.log,

Line 320: fnd_file.put_line(which => fnd_file.log,

316: fnd_file.put_line(which => fnd_file.log,
317: buff => 'Action Items Flag : '||
318: g_parm.actn_items_flag);
319: --
320: fnd_file.put_line(which => fnd_file.log,
321: buff => 'Covered Dependent Flag : '||
322: g_parm.cov_dpnt_flag);
323: --
324: fnd_file.put_line(which => fnd_file.log,

Line 324: fnd_file.put_line(which => fnd_file.log,

320: fnd_file.put_line(which => fnd_file.log,
321: buff => 'Covered Dependent Flag : '||
322: g_parm.cov_dpnt_flag);
323: --
324: fnd_file.put_line(which => fnd_file.log,
325: buff => 'Primary Care Provider Flag : '||
326: g_parm.prmy_care_flag);
327: --
328: fnd_file.put_line(which => fnd_file.log,

Line 328: fnd_file.put_line(which => fnd_file.log,

324: fnd_file.put_line(which => fnd_file.log,
325: buff => 'Primary Care Provider Flag : '||
326: g_parm.prmy_care_flag);
327: --
328: fnd_file.put_line(which => fnd_file.log,
329: buff => 'Beneficiaries Flag : '||
330: g_parm.beneficaries_flag);
331: --
332: fnd_file.put_line(which => fnd_file.log,

Line 332: fnd_file.put_line(which => fnd_file.log,

328: fnd_file.put_line(which => fnd_file.log,
329: buff => 'Beneficiaries Flag : '||
330: g_parm.beneficaries_flag);
331: --
332: fnd_file.put_line(which => fnd_file.log,
333: buff => 'Certifications Flag : '||
334: g_parm.certifications_flag);
335: --
336: fnd_file.put_line(which => fnd_file.log,

Line 336: fnd_file.put_line(which => fnd_file.log,

332: fnd_file.put_line(which => fnd_file.log,
333: buff => 'Certifications Flag : '||
334: g_parm.certifications_flag);
335: --
336: fnd_file.put_line(which => fnd_file.log,
337: buff => 'Display Flexfields Flag : '||
338: g_parm.disp_flex_fields);
339:
340: --

Line 341: fnd_file.put_line(which => fnd_file.log,

337: buff => 'Display Flexfields Flag : '||
338: g_parm.disp_flex_fields);
339:
340: --
341: fnd_file.put_line(which => fnd_file.log,
342: buff => 'Elec Choice Flexfields Flag: '||
343: g_parm.disp_epe_flxfld_flag );
344:
345: hr_utility.set_location('Leaving : ' || l_proc, 10);

Line 418: -- fnd_file.put_line(fnd_file.log,'Inside check rules ');

414: l_proc varchar2(80) := g_package || '.check_business_rules';
415: --
416: begin
417: --
418: -- fnd_file.put_line(fnd_file.log,'Inside check rules ');
419: hr_utility.set_location ('Entering '||l_proc,10);
420: --
421: -- This procedure checks validity of parameters that have been passed
422: --

Line 445: fnd_file.put_line(fnd_file.log, fnd_message.get );

441: fnd_message.set_token('PROC',l_proc);
442: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
443: fnd_message.set_token('PER_SELECT_RL',
444: 'person_selection_rule :'||g_parm.person_sel_rl);
445: fnd_file.put_line(fnd_file.log, fnd_message.get );
446: fnd_message.raise_error;
447: end if;
448: --
449: -- p_person_id must be of p_person_type_id specified

Line 463: fnd_file.put_line(fnd_file.log, fnd_message.get );

459: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
460: fnd_message.set_token('PROC',l_proc);
461: fnd_message.set_token('PERSON_ID',to_char(g_parm.person_id));
462: fnd_message.set_token('PER_TYPE_ID',to_char(g_parm.person_type_id));
463: fnd_file.put_line(fnd_file.log, fnd_message.get );
464: fnd_message.raise_error;
465: --
466: end if;
467: --

Line 500: fnd_file.put_line(fnd_file.log, fnd_message.get );

496: --
497: fnd_message.set_name('BEN', 'BEN_93247_PLN_NIP_PGM_NULL');
498: -- If you specify a plan as not in a program then the program should be blank.
499: fnd_message.set_token('PROC',l_proc);
500: fnd_file.put_line(fnd_file.log, fnd_message.get );
501: fnd_message.raise_error;
502: --
503: end if;
504: --

Line 510: fnd_file.put_line(fnd_file.log, fnd_message.get );

506: ( g_parm.cvg_strt_dt is not null or g_parm.cvg_end_dt is not null )) then
507: --
508: fnd_message.set_name('BEN', 'BEN_93245_INVALID_PARM_VALUE');
509: fnd_message.set_token('PROC',l_proc);
510: fnd_file.put_line(fnd_file.log, fnd_message.get );
511: fnd_message.raise_error;
512: --
513: end if;
514: --

Line 520: fnd_file.put_line(fnd_file.log, fnd_message.get );

516: ( g_parm.disp_flex_fields is not null or g_parm.disp_epe_flxfld_flag is not null )) then
517: --
518: fnd_message.set_name('BEN', 'BEN_93246_INVALID_PARM_VALUE');
519: fnd_message.set_token('PROC',l_proc);
520: fnd_file.put_line(fnd_file.log, fnd_message.get );
521: --
522: end if;
523:
524: --

Line 532: fnd_file.put_line(fnd_file.log, fnd_message.get );

528: or (g_parm.cvg_end_dt is not null and g_parm.cvg_strt_dt is null )) then
529: --
530: fnd_message.set_name('BEN', 'BEN_93237_CVG_START_END_DT');
531: fnd_message.set_token('PROC',l_proc);
532: fnd_file.put_line(fnd_file.log, fnd_message.get );
533: fnd_message.raise_error;
534: --
535: end if;
536: --

Line 596: -- fnd_file.put_line(fnd_file.log, to_char(l_assignment_id)||' -> ' || p_return );

592: ,p_param1 => 'BEN_IV_PERSON_ID' -- Bug 5331889
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 ;

Line 814: -- fnd_file.put_line(fnd_file.log, ' after person selection rule ');

810: End if;
811: end if;
812: end if;
813: --
814: -- fnd_file.put_line(fnd_file.log, ' after person selection rule ');
815: -- Create a person action only if the person passes the person selection rule
816: If ( not skip) then
817: --
818: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);

Line 819: -- fnd_file.put_line(fnd_file.log, 'not skip...Inserting Ben_person_actions');

815: -- Create a person action only if the person passes the person selection rule
816: If ( not skip) then
817: --
818: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
819: -- fnd_file.put_line(fnd_file.log, 'not skip...Inserting Ben_person_actions');
820: --
821: l_actn := 'Create person actions ...';
822: ben_person_actions_api.create_person_actions(
823: p_validate => false

Line 841: -- fnd_file.put_line(fnd_file.log, 'after we get start , end action ids');

837: end if;
838: --
839: p_ending_person_action_id := l_person_action_id;
840: --
841: -- fnd_file.put_line(fnd_file.log, 'after we get start , end action ids');
842: if mod(g_person_actn_cnt, g_chunk_size) = 0 or g_chunk_size = 1 then
843: --
844: -- fnd_file.put_line(fnd_file.log, ' before create_batch_ranges');
845: ben_batch_ranges_api.create_batch_ranges

Line 844: -- fnd_file.put_line(fnd_file.log, ' before create_batch_ranges');

840: --
841: -- fnd_file.put_line(fnd_file.log, 'after we get start , end action ids');
842: if mod(g_person_actn_cnt, g_chunk_size) = 0 or g_chunk_size = 1 then
843: --
844: -- fnd_file.put_line(fnd_file.log, ' before create_batch_ranges');
845: ben_batch_ranges_api.create_batch_ranges
846: (p_validate => FALSE
847: ,p_effective_date => g_parm.effective_date
848: ,p_benefit_action_id => g_parm.benefit_action_id

Line 857: -- fnd_file.put_line(fnd_file.log, ' after create_batch_ranges');

853: ,p_object_version_number => l_object_version_number);
854: --
855: g_num_ranges := g_num_ranges + 1;
856: --
857: -- fnd_file.put_line(fnd_file.log, ' after create_batch_ranges');
858: end if;
859: else
860: -- persons excluded by the selection rule report them on the audit log
861: l_actn := 'Print person header information ...';

Line 866: fnd_file.put_line(fnd_file.log, ' persons excluded by the selection rule');

862: ben_batch_utils.person_header
863: (p_person_id => p_person_id
864: ,p_business_group_id => g_parm.business_group_id
865: ,p_effective_date => g_parm.effective_date );
866: fnd_file.put_line(fnd_file.log, ' persons excluded by the selection rule');
867: end if;
868: --
869: hr_utility.set_location('Leaving : ' || l_proc, 10);
870: -- fnd_file.put_line(fnd_file.log, ' Leaving : create_actions_ranges ');

Line 870: -- fnd_file.put_line(fnd_file.log, ' Leaving : create_actions_ranges ');

866: fnd_file.put_line(fnd_file.log, ' persons excluded by the selection rule');
867: end if;
868: --
869: hr_utility.set_location('Leaving : ' || l_proc, 10);
870: -- fnd_file.put_line(fnd_file.log, ' Leaving : create_actions_ranges ');
871: --
872: exception
873: when others then
874: fnd_file.put_line(fnd_file.log, sqlerrm || ' ' || sqlcode);

Line 874: fnd_file.put_line(fnd_file.log, sqlerrm || ' ' || sqlcode);

870: -- fnd_file.put_line(fnd_file.log, ' Leaving : create_actions_ranges ');
871: --
872: exception
873: when others then
874: fnd_file.put_line(fnd_file.log, sqlerrm || ' ' || sqlcode);
875: raise;
876: --
877: end create_actions_ranges;
878: --

Line 1027: --fnd_file.put_line(fnd_file.log, 'before person loop : ');

1023: hr_utility.set_location('Entering : ' || l_package , 10);
1024: --
1025: hr_utility.set_location('Creating actions and ranges ' || l_package , 15);
1026: --
1027: --fnd_file.put_line(fnd_file.log, 'before person loop : ');
1028: open c_person ;
1029: loop
1030: fetch c_person into l_per_rec ;
1031: exit when c_person%notfound ;

Line 1033: --fnd_file.put_line(fnd_file.log, 'inside person loop : ');

1029: loop
1030: fetch c_person into l_per_rec ;
1031: exit when c_person%notfound ;
1032: --
1033: --fnd_file.put_line(fnd_file.log, 'inside person loop : ');
1034: create_actions_ranges
1035: (p_person_id => l_per_rec.person_id
1036: ,p_ler_id => g_parm.ler_id
1037: ,p_start_person_action_id => l_start_person_action_id

Line 1042: -- fnd_file.put_line(fnd_file.log, 'after person loop : ');

1038: ,p_ending_person_action_id => l_ending_person_action_id);
1039: --
1040: end loop;
1041: close c_person ;
1042: -- fnd_file.put_line(fnd_file.log, 'after person loop : ');
1043: --
1044: -- There could be a few person actions left over from the call in the for
1045: -- loop above. Create a batch range for them.
1046: --

Line 1052: --fnd_file.put_line(fnd_file.log, 'before create batch ranges ');

1048: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
1049: --
1050: hr_utility.set_location('Ranges for remaining people ' || l_package, 25);
1051: --
1052: --fnd_file.put_line(fnd_file.log, 'before create batch ranges ');
1053: ben_batch_ranges_api.create_batch_ranges
1054: (p_validate => FALSE
1055: ,p_effective_date => g_parm.effective_date
1056: ,p_benefit_action_id => g_parm.benefit_action_id

Line 1068: --fnd_file.put_line(fnd_file.log, 'leaving create_bensmrep_ranges ');

1064: --
1065: end if;
1066: --
1067: hr_utility.set_location('Leaving : ' || l_package, 10);
1068: --fnd_file.put_line(fnd_file.log, 'leaving create_bensmrep_ranges ');
1069: end create_bensmrep_ranges;
1070: --
1071: -- ==================================================================================
1072: -- << Procedure: create_enrkit_ranges >>

Line 1180: --fnd_file.put_line(fnd_file.log, 'before person loop : ');

1176: hr_utility.set_location('Entering : ' || l_package , 10);
1177: --
1178: hr_utility.set_location('Creating actions and ranges ' || l_package , 15);
1179: --
1180: --fnd_file.put_line(fnd_file.log, 'before person loop : ');
1181: open c_person ;
1182: loop
1183: fetch c_person into l_per_rec ;
1184: exit when c_person%notfound ;

Line 1186: --fnd_file.put_line(fnd_file.log, 'inside person loop : ');

1182: loop
1183: fetch c_person into l_per_rec ;
1184: exit when c_person%notfound ;
1185: --
1186: --fnd_file.put_line(fnd_file.log, 'inside person loop : ');
1187: create_actions_ranges
1188: (p_person_id => l_per_rec.person_id
1189: ,p_ler_id => g_parm.ler_id
1190: ,p_start_person_action_id => l_start_person_action_id

Line 1195: -- fnd_file.put_line(fnd_file.log, 'after person loop : ');

1191: ,p_ending_person_action_id => l_ending_person_action_id);
1192: --
1193: end loop;
1194: close c_person ;
1195: -- fnd_file.put_line(fnd_file.log, 'after person loop : ');
1196: --
1197: -- There could be a few person actions left over from the call in the for
1198: -- loop above. Create a batch range for them.
1199: --

Line 1205: --fnd_file.put_line(fnd_file.log, 'before create batch ranges ');

1201: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
1202: --
1203: hr_utility.set_location('Ranges for remaining people ' || l_package, 25);
1204: --
1205: --fnd_file.put_line(fnd_file.log, 'before create batch ranges ');
1206: ben_batch_ranges_api.create_batch_ranges
1207: (p_validate => FALSE
1208: ,p_effective_date => g_parm.effective_date
1209: ,p_benefit_action_id => g_parm.benefit_action_id

Line 1221: --fnd_file.put_line(fnd_file.log, 'leaving create_bensmrep_ranges ');

1217: --
1218: end if;
1219: --
1220: hr_utility.set_location('Leaving : ' || l_package, 10);
1221: --fnd_file.put_line(fnd_file.log, 'leaving create_bensmrep_ranges ');
1222:
1223: end ;
1224: -- ==================================================================================
1225: -- << Procedure: process >>

Line 1357: -- fnd_file.put_line(fnd_file.log, 'g_parm.effective_date : ' || g_parm.effective_date);

1353: g_parm.certifications_flag := p_certifications_flag ;
1354: g_parm.disp_epe_flxfld_flag := p_disp_epe_flxfld_flag ;
1355: g_parm.disp_flex_fields := p_disp_flex_fields ;
1356: --
1357: -- fnd_file.put_line(fnd_file.log, 'g_parm.effective_date : ' || g_parm.effective_date);
1358: -- fnd_file.put_line(fnd_file.log, 'g_parm.lf_evt_ocrd_dt : ' || g_parm.lf_evt_ocrd_dt);
1359: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_strt_dt : ' || g_parm.cvg_strt_dt );
1360: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_end_dt : ' || g_parm.cvg_end_dt );
1361: -- fnd_file.put_line(fnd_file.log, 'l_cvg_end_dt : ' || to_char(l_cvg_end_dt,'dd-mon-yyyy'));

Line 1358: -- fnd_file.put_line(fnd_file.log, 'g_parm.lf_evt_ocrd_dt : ' || g_parm.lf_evt_ocrd_dt);

1354: g_parm.disp_epe_flxfld_flag := p_disp_epe_flxfld_flag ;
1355: g_parm.disp_flex_fields := p_disp_flex_fields ;
1356: --
1357: -- fnd_file.put_line(fnd_file.log, 'g_parm.effective_date : ' || g_parm.effective_date);
1358: -- fnd_file.put_line(fnd_file.log, 'g_parm.lf_evt_ocrd_dt : ' || g_parm.lf_evt_ocrd_dt);
1359: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_strt_dt : ' || g_parm.cvg_strt_dt );
1360: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_end_dt : ' || g_parm.cvg_end_dt );
1361: -- fnd_file.put_line(fnd_file.log, 'l_cvg_end_dt : ' || to_char(l_cvg_end_dt,'dd-mon-yyyy'));
1362: l_actn := 'check business rules ...';

Line 1359: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_strt_dt : ' || g_parm.cvg_strt_dt );

1355: g_parm.disp_flex_fields := p_disp_flex_fields ;
1356: --
1357: -- fnd_file.put_line(fnd_file.log, 'g_parm.effective_date : ' || g_parm.effective_date);
1358: -- fnd_file.put_line(fnd_file.log, 'g_parm.lf_evt_ocrd_dt : ' || g_parm.lf_evt_ocrd_dt);
1359: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_strt_dt : ' || g_parm.cvg_strt_dt );
1360: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_end_dt : ' || g_parm.cvg_end_dt );
1361: -- fnd_file.put_line(fnd_file.log, 'l_cvg_end_dt : ' || to_char(l_cvg_end_dt,'dd-mon-yyyy'));
1362: l_actn := 'check business rules ...';
1363: -- Check the parameters for validity and incompatibilities.

Line 1360: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_end_dt : ' || g_parm.cvg_end_dt );

1356: --
1357: -- fnd_file.put_line(fnd_file.log, 'g_parm.effective_date : ' || g_parm.effective_date);
1358: -- fnd_file.put_line(fnd_file.log, 'g_parm.lf_evt_ocrd_dt : ' || g_parm.lf_evt_ocrd_dt);
1359: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_strt_dt : ' || g_parm.cvg_strt_dt );
1360: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_end_dt : ' || g_parm.cvg_end_dt );
1361: -- fnd_file.put_line(fnd_file.log, 'l_cvg_end_dt : ' || to_char(l_cvg_end_dt,'dd-mon-yyyy'));
1362: l_actn := 'check business rules ...';
1363: -- Check the parameters for validity and incompatibilities.
1364: check_business_rules;

Line 1361: -- fnd_file.put_line(fnd_file.log, 'l_cvg_end_dt : ' || to_char(l_cvg_end_dt,'dd-mon-yyyy'));

1357: -- fnd_file.put_line(fnd_file.log, 'g_parm.effective_date : ' || g_parm.effective_date);
1358: -- fnd_file.put_line(fnd_file.log, 'g_parm.lf_evt_ocrd_dt : ' || g_parm.lf_evt_ocrd_dt);
1359: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_strt_dt : ' || g_parm.cvg_strt_dt );
1360: -- fnd_file.put_line(fnd_file.log, 'g_parm.cvg_end_dt : ' || g_parm.cvg_end_dt );
1361: -- fnd_file.put_line(fnd_file.log, 'l_cvg_end_dt : ' || to_char(l_cvg_end_dt,'dd-mon-yyyy'));
1362: l_actn := 'check business rules ...';
1363: -- Check the parameters for validity and incompatibilities.
1364: check_business_rules;
1365: -- Get the parameters for the batch process so we know how many slaves to

Line 1388: -- fnd_file.put_line(fnd_file.log, 'g_threads : ' || g_threads );

1384: g_threads := nvl( g_threads , 3 ) ;
1385: g_chunk_size := nvl( g_chunk_size , 10 );
1386: g_max_errors := nvl( g_max_errors , 20 );
1387: --
1388: -- fnd_file.put_line(fnd_file.log, 'g_threads : ' || g_threads );
1389: -- fnd_file.put_line(fnd_file.log, 'g_chunk_size : ' || g_chunk_size);
1390: -- fnd_file.put_line(fnd_file.log, 'g_max_errors : ' || g_max_errors);
1391: --
1392: hr_utility.set_location('Num Threads = ' || g_threads, 10);

Line 1389: -- fnd_file.put_line(fnd_file.log, 'g_chunk_size : ' || g_chunk_size);

1385: g_chunk_size := nvl( g_chunk_size , 10 );
1386: g_max_errors := nvl( g_max_errors , 20 );
1387: --
1388: -- fnd_file.put_line(fnd_file.log, 'g_threads : ' || g_threads );
1389: -- fnd_file.put_line(fnd_file.log, 'g_chunk_size : ' || g_chunk_size);
1390: -- fnd_file.put_line(fnd_file.log, 'g_max_errors : ' || g_max_errors);
1391: --
1392: hr_utility.set_location('Num Threads = ' || g_threads, 10);
1393: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);

Line 1390: -- fnd_file.put_line(fnd_file.log, 'g_max_errors : ' || g_max_errors);

1386: g_max_errors := nvl( g_max_errors , 20 );
1387: --
1388: -- fnd_file.put_line(fnd_file.log, 'g_threads : ' || g_threads );
1389: -- fnd_file.put_line(fnd_file.log, 'g_chunk_size : ' || g_chunk_size);
1390: -- fnd_file.put_line(fnd_file.log, 'g_max_errors : ' || g_max_errors);
1391: --
1392: hr_utility.set_location('Num Threads = ' || g_threads, 10);
1393: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);
1394: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);

Line 1501: fnd_file.put_line(fnd_file.log, 'Number of persons selected : ' || g_person_cnt);

1497: --
1498: g_person_cnt := g_person_actn_cnt ;
1499: g_error_person_cnt := 0 ;
1500: --
1501: fnd_file.put_line(fnd_file.log, 'Number of persons selected : ' || g_person_cnt);
1502: --
1503: print_parameters ;
1504: --
1505: write_logfile ;

Line 1525: --fnd_file.put_line(fnd_file.log, 'Number of Threads : ' || g_threads);

1521: g_threads := least(g_threads, g_num_ranges);
1522: --
1523: hr_utility.set_location('Number of Threads : ' || g_threads, 20);
1524: --
1525: --fnd_file.put_line(fnd_file.log, 'Number of Threads : ' || g_threads);
1526: -- Submit requests
1527: --
1528: -- for l_count in 1..g_threads loop
1529: if g_num_ranges <> 0 then

Line 1538: -- fnd_file.put_line(fnd_file.log, 'before submitting request for BENSMREP ..');

1534: l_actn := 'Submit request for report ...';
1535: --
1536: if p_report_name = 'BENSMREP' then
1537: --
1538: -- fnd_file.put_line(fnd_file.log, 'before submitting request for BENSMREP ..');
1539: l_request_id := FND_REQUEST.SUBMIT_REQUEST
1540: (application => 'BEN',
1541: program => 'BENSMREP',
1542: sub_request => FALSE,

Line 1573: -- fnd_file.put_line(fnd_file.log, 'before submitting request for BEENRKIT..');

1569: );
1570:
1571: elsif p_report_name = 'BEENRKIT' then
1572: --
1573: -- fnd_file.put_line(fnd_file.log, 'before submitting request for BEENRKIT..');
1574: l_request_id := FND_REQUEST.SUBMIT_REQUEST
1575: (application => 'BEN',
1576: program => 'BEENRKIT',
1577: sub_request => FALSE,

Line 1617: -- fnd_file.put_line(fnd_file.log, 'leaving process ..');

1613: -- end loop;
1614: --
1615: l_actn := 'After submitting request for report ...';
1616: --
1617: -- fnd_file.put_line(fnd_file.log, 'leaving process ..');
1618: Exception
1619: when others then
1620: ben_batch_utils.rpt_error(p_proc => l_package
1621: ,p_last_actn => l_actn

Line 1631: fnd_file.put_line(fnd_file.log, fnd_message.get );

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 );
1631: fnd_file.put_line(fnd_file.log, fnd_message.get );
1632: fnd_message.raise_error;
1633: end;
1634: --
1635: end ben_conc_reports;