APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_BATCH_UTILS

Line 78: l_cache ben_batch_utils.g_comp_obj_table := ben_batch_utils.g_cache_comp;

74: and pil.business_group_id=p_business_group_id
75: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
76: --
77: l_actn varchar2(80);
78: l_cache ben_batch_utils.g_comp_obj_table := ben_batch_utils.g_cache_comp;
79: l_cache_cnt binary_integer := ben_batch_utils.g_cache_comp_cnt;
80: l_category varchar2(30);
81: l_chg boolean;
82: l_detail varchar2(132) := 'Default election asigned - ' ||

Line 79: l_cache_cnt binary_integer := ben_batch_utils.g_cache_comp_cnt;

75: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
76: --
77: l_actn varchar2(80);
78: l_cache ben_batch_utils.g_comp_obj_table := ben_batch_utils.g_cache_comp;
79: l_cache_cnt binary_integer := ben_batch_utils.g_cache_comp_cnt;
80: l_category varchar2(30);
81: l_chg boolean;
82: l_detail varchar2(132) := 'Default election asigned - ' ||
83: 'no current elections changed' ;

Line 102: ben_batch_utils.write_rec(p_typ_cd => l_category

98: --
99: l_category := 'ERROR_C';
100: l_detail := 'Error occur while closing enrollment';
101: --
102: ben_batch_utils.write_rec(p_typ_cd => l_category
103: ,p_text => l_detail);
104: --
105: end if;
106: --

Line 170: l_actn := 'Calling ben_batch_utils.write_rec (DEFAULT)...';

166: end if;
167: --
168: end if;
169: --
170: l_actn := 'Calling ben_batch_utils.write_rec (DEFAULT)...';
171: --
172: ben_batch_utils.write_rec(p_typ_cd => l_category
173: ,p_text => l_detail);
174: end if;

Line 172: ben_batch_utils.write_rec(p_typ_cd => l_category

168: end if;
169: --
170: l_actn := 'Calling ben_batch_utils.write_rec (DEFAULT)...';
171: --
172: ben_batch_utils.write_rec(p_typ_cd => l_category
173: ,p_text => l_detail);
174: end if;
175: --
176: if p_audit_log = 'Y' then

Line 255: ben_batch_utils.rpt_error(p_proc => l_proc

251: exception
252: --
253: when others then
254: --
255: ben_batch_utils.rpt_error(p_proc => l_proc
256: ,p_last_actn => l_actn
257: ,p_rpt_flag => TRUE);
258: --
259: raise;

Line 285: ben_batch_utils.write

281: hr_utility.set_location ('Entering '||l_proc,05);
282: --
283: if p_cnt > 0 then
284: --
285: ben_batch_utils.write
286: (ben_batch_utils.ret_str('Program name', 30) ||
287: ben_batch_utils.ret_str('Plan name', 30) ||
288: ben_batch_utils.ret_str('Cls_to_use_cd', 15) ||
289: ben_batch_utils.ret_str('Enrt_perd_strt', 15) ||

Line 286: (ben_batch_utils.ret_str('Program name', 30) ||

282: --
283: if p_cnt > 0 then
284: --
285: ben_batch_utils.write
286: (ben_batch_utils.ret_str('Program name', 30) ||
287: ben_batch_utils.ret_str('Plan name', 30) ||
288: ben_batch_utils.ret_str('Cls_to_use_cd', 15) ||
289: ben_batch_utils.ret_str('Enrt_perd_strt', 15) ||
290: ben_batch_utils.ret_str('Enrt_perd_end', 15) ||

Line 287: ben_batch_utils.ret_str('Plan name', 30) ||

283: if p_cnt > 0 then
284: --
285: ben_batch_utils.write
286: (ben_batch_utils.ret_str('Program name', 30) ||
287: ben_batch_utils.ret_str('Plan name', 30) ||
288: ben_batch_utils.ret_str('Cls_to_use_cd', 15) ||
289: ben_batch_utils.ret_str('Enrt_perd_strt', 15) ||
290: ben_batch_utils.ret_str('Enrt_perd_end', 15) ||
291: ben_batch_utils.ret_str('Procd_end_date', 15) ||

Line 288: ben_batch_utils.ret_str('Cls_to_use_cd', 15) ||

284: --
285: ben_batch_utils.write
286: (ben_batch_utils.ret_str('Program name', 30) ||
287: ben_batch_utils.ret_str('Plan name', 30) ||
288: ben_batch_utils.ret_str('Cls_to_use_cd', 15) ||
289: ben_batch_utils.ret_str('Enrt_perd_strt', 15) ||
290: ben_batch_utils.ret_str('Enrt_perd_end', 15) ||
291: ben_batch_utils.ret_str('Procd_end_date', 15) ||
292: ben_batch_utils.ret_str('Deflt_apply_dt', 15) ||

Line 289: ben_batch_utils.ret_str('Enrt_perd_strt', 15) ||

285: ben_batch_utils.write
286: (ben_batch_utils.ret_str('Program name', 30) ||
287: ben_batch_utils.ret_str('Plan name', 30) ||
288: ben_batch_utils.ret_str('Cls_to_use_cd', 15) ||
289: ben_batch_utils.ret_str('Enrt_perd_strt', 15) ||
290: ben_batch_utils.ret_str('Enrt_perd_end', 15) ||
291: ben_batch_utils.ret_str('Procd_end_date', 15) ||
292: ben_batch_utils.ret_str('Deflt_apply_dt', 15) ||
293: ben_batch_utils.ret_str('Elcn_made_date', 15) ||

Line 290: ben_batch_utils.ret_str('Enrt_perd_end', 15) ||

286: (ben_batch_utils.ret_str('Program name', 30) ||
287: ben_batch_utils.ret_str('Plan name', 30) ||
288: ben_batch_utils.ret_str('Cls_to_use_cd', 15) ||
289: ben_batch_utils.ret_str('Enrt_perd_strt', 15) ||
290: ben_batch_utils.ret_str('Enrt_perd_end', 15) ||
291: ben_batch_utils.ret_str('Procd_end_date', 15) ||
292: ben_batch_utils.ret_str('Deflt_apply_dt', 15) ||
293: ben_batch_utils.ret_str('Elcn_made_date', 15) ||
294: ben_batch_utils.ret_str('Dflt_asgn_date', 15) ||

Line 291: ben_batch_utils.ret_str('Procd_end_date', 15) ||

287: ben_batch_utils.ret_str('Plan name', 30) ||
288: ben_batch_utils.ret_str('Cls_to_use_cd', 15) ||
289: ben_batch_utils.ret_str('Enrt_perd_strt', 15) ||
290: ben_batch_utils.ret_str('Enrt_perd_end', 15) ||
291: ben_batch_utils.ret_str('Procd_end_date', 15) ||
292: ben_batch_utils.ret_str('Deflt_apply_dt', 15) ||
293: ben_batch_utils.ret_str('Elcn_made_date', 15) ||
294: ben_batch_utils.ret_str('Dflt_asgn_date', 15) ||
295: ben_batch_utils.ret_str('Enrt status', 10)

Line 292: ben_batch_utils.ret_str('Deflt_apply_dt', 15) ||

288: ben_batch_utils.ret_str('Cls_to_use_cd', 15) ||
289: ben_batch_utils.ret_str('Enrt_perd_strt', 15) ||
290: ben_batch_utils.ret_str('Enrt_perd_end', 15) ||
291: ben_batch_utils.ret_str('Procd_end_date', 15) ||
292: ben_batch_utils.ret_str('Deflt_apply_dt', 15) ||
293: ben_batch_utils.ret_str('Elcn_made_date', 15) ||
294: ben_batch_utils.ret_str('Dflt_asgn_date', 15) ||
295: ben_batch_utils.ret_str('Enrt status', 10)
296: );

Line 293: ben_batch_utils.ret_str('Elcn_made_date', 15) ||

289: ben_batch_utils.ret_str('Enrt_perd_strt', 15) ||
290: ben_batch_utils.ret_str('Enrt_perd_end', 15) ||
291: ben_batch_utils.ret_str('Procd_end_date', 15) ||
292: ben_batch_utils.ret_str('Deflt_apply_dt', 15) ||
293: ben_batch_utils.ret_str('Elcn_made_date', 15) ||
294: ben_batch_utils.ret_str('Dflt_asgn_date', 15) ||
295: ben_batch_utils.ret_str('Enrt status', 10)
296: );
297: --

Line 294: ben_batch_utils.ret_str('Dflt_asgn_date', 15) ||

290: ben_batch_utils.ret_str('Enrt_perd_end', 15) ||
291: ben_batch_utils.ret_str('Procd_end_date', 15) ||
292: ben_batch_utils.ret_str('Deflt_apply_dt', 15) ||
293: ben_batch_utils.ret_str('Elcn_made_date', 15) ||
294: ben_batch_utils.ret_str('Dflt_asgn_date', 15) ||
295: ben_batch_utils.ret_str('Enrt status', 10)
296: );
297: --
298: for i in 1..p_cnt

Line 295: ben_batch_utils.ret_str('Enrt status', 10)

291: ben_batch_utils.ret_str('Procd_end_date', 15) ||
292: ben_batch_utils.ret_str('Deflt_apply_dt', 15) ||
293: ben_batch_utils.ret_str('Elcn_made_date', 15) ||
294: ben_batch_utils.ret_str('Dflt_asgn_date', 15) ||
295: ben_batch_utils.ret_str('Enrt status', 10)
296: );
297: --
298: for i in 1..p_cnt
299: loop

Line 307: l_pgm_name := ben_batch_utils.get_pgm_name

303: else
304: l_status := 'Started';
305: end if;
306: --
307: l_pgm_name := ben_batch_utils.get_pgm_name
308: (p_pgm_id => p_rec(i).pgm_id
309: ,p_business_group_id => p_business_group_id
310: ,p_effective_date => p_effective_date);
311: --

Line 312: l_pl_name := ben_batch_utils.get_pl_name

308: (p_pgm_id => p_rec(i).pgm_id
309: ,p_business_group_id => p_business_group_id
310: ,p_effective_date => p_effective_date);
311: --
312: l_pl_name := ben_batch_utils.get_pl_name
313: (p_pl_id => p_rec(i).pl_id
314: ,p_business_group_id => p_business_group_id
315: ,p_effective_date => p_effective_date);
316: --

Line 317: ben_batch_utils.write

313: (p_pl_id => p_rec(i).pl_id
314: ,p_business_group_id => p_business_group_id
315: ,p_effective_date => p_effective_date);
316: --
317: ben_batch_utils.write
318: (ben_batch_utils.ret_str(l_pgm_name,30) ||
319: ben_batch_utils.ret_str(l_pl_name, 30) ||
320: ben_batch_utils.ret_str(p_rec(i).cls_enrt_dt_to_use_cd, 15) ||
321: ben_batch_utils.ret_str(p_rec(i).enrt_perd_strt_dt, 15) ||

Line 318: (ben_batch_utils.ret_str(l_pgm_name,30) ||

314: ,p_business_group_id => p_business_group_id
315: ,p_effective_date => p_effective_date);
316: --
317: ben_batch_utils.write
318: (ben_batch_utils.ret_str(l_pgm_name,30) ||
319: ben_batch_utils.ret_str(l_pl_name, 30) ||
320: ben_batch_utils.ret_str(p_rec(i).cls_enrt_dt_to_use_cd, 15) ||
321: ben_batch_utils.ret_str(p_rec(i).enrt_perd_strt_dt, 15) ||
322: ben_batch_utils.ret_str(p_rec(i).enrt_perd_end_dt, 15) ||

Line 319: ben_batch_utils.ret_str(l_pl_name, 30) ||

315: ,p_effective_date => p_effective_date);
316: --
317: ben_batch_utils.write
318: (ben_batch_utils.ret_str(l_pgm_name,30) ||
319: ben_batch_utils.ret_str(l_pl_name, 30) ||
320: ben_batch_utils.ret_str(p_rec(i).cls_enrt_dt_to_use_cd, 15) ||
321: ben_batch_utils.ret_str(p_rec(i).enrt_perd_strt_dt, 15) ||
322: ben_batch_utils.ret_str(p_rec(i).enrt_perd_end_dt, 15) ||
323: ben_batch_utils.ret_str(p_rec(i).procg_end_dt, 15) ||

Line 320: ben_batch_utils.ret_str(p_rec(i).cls_enrt_dt_to_use_cd, 15) ||

316: --
317: ben_batch_utils.write
318: (ben_batch_utils.ret_str(l_pgm_name,30) ||
319: ben_batch_utils.ret_str(l_pl_name, 30) ||
320: ben_batch_utils.ret_str(p_rec(i).cls_enrt_dt_to_use_cd, 15) ||
321: ben_batch_utils.ret_str(p_rec(i).enrt_perd_strt_dt, 15) ||
322: ben_batch_utils.ret_str(p_rec(i).enrt_perd_end_dt, 15) ||
323: ben_batch_utils.ret_str(p_rec(i).procg_end_dt, 15) ||
324: ben_batch_utils.ret_str(p_rec(i).dflt_enrt_dt, 15) ||

Line 321: ben_batch_utils.ret_str(p_rec(i).enrt_perd_strt_dt, 15) ||

317: ben_batch_utils.write
318: (ben_batch_utils.ret_str(l_pgm_name,30) ||
319: ben_batch_utils.ret_str(l_pl_name, 30) ||
320: ben_batch_utils.ret_str(p_rec(i).cls_enrt_dt_to_use_cd, 15) ||
321: ben_batch_utils.ret_str(p_rec(i).enrt_perd_strt_dt, 15) ||
322: ben_batch_utils.ret_str(p_rec(i).enrt_perd_end_dt, 15) ||
323: ben_batch_utils.ret_str(p_rec(i).procg_end_dt, 15) ||
324: ben_batch_utils.ret_str(p_rec(i).dflt_enrt_dt, 15) ||
325: ben_batch_utils.ret_str(p_rec(i).elcns_made_dt, 15) ||

Line 322: ben_batch_utils.ret_str(p_rec(i).enrt_perd_end_dt, 15) ||

318: (ben_batch_utils.ret_str(l_pgm_name,30) ||
319: ben_batch_utils.ret_str(l_pl_name, 30) ||
320: ben_batch_utils.ret_str(p_rec(i).cls_enrt_dt_to_use_cd, 15) ||
321: ben_batch_utils.ret_str(p_rec(i).enrt_perd_strt_dt, 15) ||
322: ben_batch_utils.ret_str(p_rec(i).enrt_perd_end_dt, 15) ||
323: ben_batch_utils.ret_str(p_rec(i).procg_end_dt, 15) ||
324: ben_batch_utils.ret_str(p_rec(i).dflt_enrt_dt, 15) ||
325: ben_batch_utils.ret_str(p_rec(i).elcns_made_dt, 15) ||
326: ben_batch_utils.ret_str(p_rec(i).dflt_asnd_dt, 15) ||

Line 323: ben_batch_utils.ret_str(p_rec(i).procg_end_dt, 15) ||

319: ben_batch_utils.ret_str(l_pl_name, 30) ||
320: ben_batch_utils.ret_str(p_rec(i).cls_enrt_dt_to_use_cd, 15) ||
321: ben_batch_utils.ret_str(p_rec(i).enrt_perd_strt_dt, 15) ||
322: ben_batch_utils.ret_str(p_rec(i).enrt_perd_end_dt, 15) ||
323: ben_batch_utils.ret_str(p_rec(i).procg_end_dt, 15) ||
324: ben_batch_utils.ret_str(p_rec(i).dflt_enrt_dt, 15) ||
325: ben_batch_utils.ret_str(p_rec(i).elcns_made_dt, 15) ||
326: ben_batch_utils.ret_str(p_rec(i).dflt_asnd_dt, 15) ||
327: ben_batch_utils.ret_str(l_status,10)

Line 324: ben_batch_utils.ret_str(p_rec(i).dflt_enrt_dt, 15) ||

320: ben_batch_utils.ret_str(p_rec(i).cls_enrt_dt_to_use_cd, 15) ||
321: ben_batch_utils.ret_str(p_rec(i).enrt_perd_strt_dt, 15) ||
322: ben_batch_utils.ret_str(p_rec(i).enrt_perd_end_dt, 15) ||
323: ben_batch_utils.ret_str(p_rec(i).procg_end_dt, 15) ||
324: ben_batch_utils.ret_str(p_rec(i).dflt_enrt_dt, 15) ||
325: ben_batch_utils.ret_str(p_rec(i).elcns_made_dt, 15) ||
326: ben_batch_utils.ret_str(p_rec(i).dflt_asnd_dt, 15) ||
327: ben_batch_utils.ret_str(l_status,10)
328: );

Line 325: ben_batch_utils.ret_str(p_rec(i).elcns_made_dt, 15) ||

321: ben_batch_utils.ret_str(p_rec(i).enrt_perd_strt_dt, 15) ||
322: ben_batch_utils.ret_str(p_rec(i).enrt_perd_end_dt, 15) ||
323: ben_batch_utils.ret_str(p_rec(i).procg_end_dt, 15) ||
324: ben_batch_utils.ret_str(p_rec(i).dflt_enrt_dt, 15) ||
325: ben_batch_utils.ret_str(p_rec(i).elcns_made_dt, 15) ||
326: ben_batch_utils.ret_str(p_rec(i).dflt_asnd_dt, 15) ||
327: ben_batch_utils.ret_str(l_status,10)
328: );
329: --

Line 326: ben_batch_utils.ret_str(p_rec(i).dflt_asnd_dt, 15) ||

322: ben_batch_utils.ret_str(p_rec(i).enrt_perd_end_dt, 15) ||
323: ben_batch_utils.ret_str(p_rec(i).procg_end_dt, 15) ||
324: ben_batch_utils.ret_str(p_rec(i).dflt_enrt_dt, 15) ||
325: ben_batch_utils.ret_str(p_rec(i).elcns_made_dt, 15) ||
326: ben_batch_utils.ret_str(p_rec(i).dflt_asnd_dt, 15) ||
327: ben_batch_utils.ret_str(l_status,10)
328: );
329: --
330: end loop;

Line 327: ben_batch_utils.ret_str(l_status,10)

323: ben_batch_utils.ret_str(p_rec(i).procg_end_dt, 15) ||
324: ben_batch_utils.ret_str(p_rec(i).dflt_enrt_dt, 15) ||
325: ben_batch_utils.ret_str(p_rec(i).elcns_made_dt, 15) ||
326: ben_batch_utils.ret_str(p_rec(i).dflt_asnd_dt, 15) ||
327: ben_batch_utils.ret_str(l_status,10)
328: );
329: --
330: end loop;
331: --

Line 358: l_actn := 'Calling ben_batch_utils.batch_report (BENCLAUD)...';

354: if fnd_global.conc_request_id <> -1 then
355: --
356: if upper(p_audit_log) = 'Y' then
357: --
358: l_actn := 'Calling ben_batch_utils.batch_report (BENCLAUD)...';
359: --
360: ben_batch_utils.batch_report
361: (p_concurrent_request_id => fnd_global.conc_request_id
362: ,p_program_name => 'BENCLAUD'

Line 360: ben_batch_utils.batch_report

356: if upper(p_audit_log) = 'Y' then
357: --
358: l_actn := 'Calling ben_batch_utils.batch_report (BENCLAUD)...';
359: --
360: ben_batch_utils.batch_report
361: (p_concurrent_request_id => fnd_global.conc_request_id
362: ,p_program_name => 'BENCLAUD'
363: ,p_request_id => l_request_id);
364: --

Line 367: l_actn := 'Calling ben_batch_utils.batch_report (BENCLSUM)...';

363: ,p_request_id => l_request_id);
364: --
365: end if;
366: --
367: l_actn := 'Calling ben_batch_utils.batch_report (BENCLSUM)...';
368: --
369: ben_batch_utils.batch_report
370: (p_concurrent_request_id => fnd_global.conc_request_id
371: ,p_program_name => 'BENCLSUM'

Line 369: ben_batch_utils.batch_report

365: end if;
366: --
367: l_actn := 'Calling ben_batch_utils.batch_report (BENCLSUM)...';
368: --
369: ben_batch_utils.batch_report
370: (p_concurrent_request_id => fnd_global.conc_request_id
371: ,p_program_name => 'BENCLSUM'
372: ,p_request_id => l_request_id);
373: --

Line 392: ben_batch_utils.rpt_error(p_proc => l_proc

388: exception
389: --
390: when others then
391: --
392: ben_batch_utils.rpt_error(p_proc => l_proc
393: ,p_last_actn => l_actn
394: ,p_rpt_flag => p_rpt_flag);
395: --
396: raise;

Line 482: ben_batch_utils.rpt_error(p_proc=>l_proc, p_last_actn=>l_actn);

478: exception
479: --
480: when others then
481: --
482: ben_batch_utils.rpt_error(p_proc=>l_proc, p_last_actn=>l_actn);
483: raise;
484: --
485: end update_per_in_ler;
486: --

Line 770: ben_batch_utils.person_header

766: -- 2205261 : CWB Change : Pass the persons business group
767: -- Which could be different from business group id on per in ler
768: -- for CWB data.
769: --
770: ben_batch_utils.person_header
771: (p_person_id => l_person_id
772: ,p_business_group_id => l_per_business_group_id
773: ,p_effective_date => p_effective_date);
774: --

Line 775: ben_batch_utils.ini('COMP_OBJ');

771: (p_person_id => l_person_id
772: ,p_business_group_id => l_per_business_group_id
773: ,p_effective_date => p_effective_date);
774: --
775: ben_batch_utils.ini('COMP_OBJ');
776: --
777: end if;
778: --
779: --- Check the Enmrt Closeing date is between the min and max of enreollment period

Line 851: ben_batch_utils.write( p_text =>

847: l_pec_cnt := 0;
848:
849: if p_batch_flag then
850: --
851: ben_batch_utils.write( p_text =>
852: 'Life event is not closed due to pending approvals.');
853: --
854: end if;
855:

Line 1363: ben_batch_utils.write_comp

1359: ,p_effective_date => p_effective_date);
1360: --
1361: -- Calling write_comp...
1362: --
1363: ben_batch_utils.write_comp
1364: (p_business_group_id => p_business_group_id
1365: ,p_effective_date => p_effective_date);
1366: --
1367: if p_person_action_id is not null then

Line 1398: ben_batch_utils.write( p_text =>

1394: --
1395: g_persons_errored := g_persons_errored + 1;
1396: --
1397: /* 666
1398: ben_batch_utils.write( p_text =>
1399: 'Life event is not closed due to pending approvals.');
1400: */
1401: write_pil_elctbl_popl
1402: (p_rec => l_pec_rec

Line 1407: ben_batch_utils.write_comp

1403: ,p_cnt => l_pec_cnt
1404: ,p_business_group_id => p_business_group_id
1405: ,p_effective_date => p_effective_date);
1406: --
1407: ben_batch_utils.write_comp
1408: (p_business_group_id => p_business_group_id
1409: ,p_effective_date => p_effective_date);
1410: --
1411: ben_batch_utils.write_error_rec;

Line 1411: ben_batch_utils.write_error_rec;

1407: ben_batch_utils.write_comp
1408: (p_business_group_id => p_business_group_id
1409: ,p_effective_date => p_effective_date);
1410: --
1411: ben_batch_utils.write_error_rec;
1412: --
1413: ben_batch_utils.rpt_error(p_proc => l_proc
1414: ,p_last_actn => l_actn
1415: ,p_rpt_flag => false);

Line 1413: ben_batch_utils.rpt_error(p_proc => l_proc

1409: ,p_effective_date => p_effective_date);
1410: --
1411: ben_batch_utils.write_error_rec;
1412: --
1413: ben_batch_utils.rpt_error(p_proc => l_proc
1414: ,p_last_actn => l_actn
1415: ,p_rpt_flag => false);
1416: --
1417: ben_batch_utils.write(p_text => benutils.g_banner_minus);

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

1413: ben_batch_utils.rpt_error(p_proc => l_proc
1414: ,p_last_actn => l_actn
1415: ,p_rpt_flag => false);
1416: --
1417: ben_batch_utils.write(p_text => benutils.g_banner_minus);
1418: --
1419: -- Update the person action status code to errored.
1420: --
1421: if p_person_action_id is not null then

Line 1440: raise ben_batch_utils.g_record_error;

1436: ,p_effective_date => p_effective_date);
1437: --
1438: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1439: --
1440: raise ben_batch_utils.g_record_error;
1441: --
1442: else
1443: fnd_message.raise_error;
1444: end if;

Line 1567: ben_batch_utils.ini;

1563: --
1564: g_persons_procd := 0;
1565: g_persons_errored := 0;
1566: --
1567: ben_batch_utils.ini;
1568: --
1569: benutils.g_benefit_action_id := p_benefit_action_id;
1570: benutils.g_thread_id := p_thread_id;
1571: --

Line 1586: ben_batch_utils.print_parameters

1582: end if;
1583: --
1584: -- Print the parameters to the log file.
1585: --
1586: ben_batch_utils.print_parameters
1587: (p_thread_id => p_thread_id
1588: ,p_benefit_action_id => p_benefit_action_id
1589: ,p_validate => p_validate
1590: ,p_business_group_id => p_business_group_id

Line 1751: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd

1747: commit;
1748: --
1749: l_actn := 'Calling log_beneadeb_statistics...';
1750: --
1751: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd
1752: ,p_num_pers_errored => g_persons_errored);
1753: --
1754: hr_utility.set_location ('Leaving '||l_proc,70);
1755: --

Line 1765: ben_batch_utils.rpt_error(p_proc => l_proc

1761: benutils.write(p_text => sqlerrm);
1762: --
1763: hr_utility.set_location('BENCLENR Super Error ' || l_proc, 10);
1764: --
1765: ben_batch_utils.rpt_error(p_proc => l_proc
1766: ,p_last_actn => l_actn
1767: ,p_rpt_flag => TRUE);
1768: --
1769: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd

Line 1769: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd

1765: ben_batch_utils.rpt_error(p_proc => l_proc
1766: ,p_last_actn => l_actn
1767: ,p_rpt_flag => TRUE);
1768: --
1769: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd
1770: ,p_num_pers_errored => g_persons_errored);
1771: --
1772: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1773: --

Line 2015: ben_batch_utils.g_audit_flag := true;

2011: --
2012: hr_utility.set_location ('Entering ' || l_proc, 10);
2013: -- Bug 5857493
2014: if p_audit_log ='Y' then
2015: ben_batch_utils.g_audit_flag := true;
2016: else
2017: ben_batch_utils.g_audit_flag := false;
2018: end if;
2019: --

Line 2017: ben_batch_utils.g_audit_flag := false;

2013: -- Bug 5857493
2014: if p_audit_log ='Y' then
2015: ben_batch_utils.g_audit_flag := true;
2016: else
2017: ben_batch_utils.g_audit_flag := false;
2018: end if;
2019: --
2020: -- Convert varchar2 dates to real dates
2021: -- 1) First remove time component

Line 2084: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');

2080: end if;
2081: --
2082: -- Initialize the batch process.
2083: --
2084: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
2085: --
2086: -- Get the parameters defined for the batch process.
2087: --
2088: benutils.get_parameter

Line 2177: l_person_ok := ben_batch_utils.person_selection_rule

2173: -- Check the person selection rule.
2174: --
2175: if p_person_selection_rl is not null then
2176: --
2177: l_person_ok := ben_batch_utils.person_selection_rule
2178: (p_person_id => l_perid_va(i)
2179: ,p_business_group_id => p_business_group_id
2180: ,p_person_selection_rule_id => p_person_selection_rl
2181: ,p_effective_date => l_effective_date);

Line 2278: ben_batch_utils.create_restart_person_actions

2274: --
2275: hr_utility.set_location('Restarting for benefit action id : ' ||
2276: to_char(l_benefit_action_id), 10);
2277: --
2278: ben_batch_utils.create_restart_person_actions
2279: (p_benefit_action_id => p_benefit_action_id
2280: ,p_effective_date => l_effective_date
2281: ,p_chunk_size => l_chunk_size
2282: ,p_threads => l_threads

Line 2327: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;

2323: ,argument6 => p_audit_log );
2324: --
2325: -- Store the request id of the concurrent request
2326: --
2327: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
2328: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
2329: := l_request_id;
2330: commit;
2331: --

Line 2328: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)

2324: --
2325: -- Store the request id of the concurrent request
2326: --
2327: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
2328: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
2329: := l_request_id;
2330: commit;
2331: --
2332: end loop;

Line 2338: ben_batch_utils.print_parameters

2334: elsif l_num_ranges = 0 then
2335: --
2336: -- No ranges got created. i.e. no people got selected. Error out.
2337: --
2338: ben_batch_utils.print_parameters
2339: (p_thread_id => 99
2340: ,p_benefit_action_id => l_benefit_action_id
2341: ,p_validate => p_validate
2342: ,p_business_group_id => p_business_group_id

Line 2351: ben_batch_utils.write(p_text =>

2347: ,p_ler_id => p_ler_id
2348: ,p_mode => p_close_cd -- 1674123
2349: ,p_audit_log => p_audit_log);
2350: --
2351: ben_batch_utils.write(p_text =>
2352: 'No person got selected with above selection criteria.');
2353: --
2354: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
2355: fnd_message.set_token('PROC',l_proc);

Line 2376: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

2372: ,p_audit_log => p_audit_log);
2373: --
2374: -- Check if all the slave processes are finished.
2375: --
2376: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
2377: --
2378: -- End the process.
2379: --
2380: ben_batch_utils.end_process

Line 2380: ben_batch_utils.end_process

2376: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
2377: --
2378: -- End the process.
2379: --
2380: ben_batch_utils.end_process
2381: (p_benefit_action_id => l_benefit_action_id
2382: ,p_person_selected => l_person_actn_cnt
2383: ,p_business_group_id => p_business_group_id);
2384: --

Line 2395: ben_batch_utils.rpt_error(p_proc => l_proc

2391: exception
2392: --
2393: when others then
2394: --
2395: ben_batch_utils.rpt_error(p_proc => l_proc
2396: ,p_last_actn => l_actn
2397: ,p_rpt_flag => TRUE);
2398: --
2399: benutils.write(p_text => fnd_message.get);

Line 2405: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

2401: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
2402: --
2403: if l_num_ranges > 0 then
2404: --
2405: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
2406: --
2407: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
2408: ,p_person_selected => l_person_actn_cnt
2409: ,p_business_group_id => p_business_group_id);

Line 2407: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

2403: if l_num_ranges > 0 then
2404: --
2405: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
2406: --
2407: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
2408: ,p_person_selected => l_person_actn_cnt
2409: ,p_business_group_id => p_business_group_id);
2410: --
2411: submit_all_reports(p_audit_log => p_audit_log);