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_MANAGE_DEFAULT_ENRT dependencies on BEN_BATCH_UTILS

Line 43: * ben_batch_utils package.

39: * 05 Nov 1998 Hugh Dang 115.9 Change call to get_parameters.
40: * 01 Dec 1998 Hugh Dang 115.10 Remove p_mode_cd check.
41: * 02 Dec 1998 Hugh Dang 115.11 Change logic how to handle report/log,
42: * and common procedures/Function into
43: * ben_batch_utils package.
44: * 11 Dec 1998 S Tee 115.12 Added the per_in_ler_id to process
45: * common enrollment result procedure.
46: * 20-Dec-1998 Hdang 115.13 Added audit_log to turn audit log report
47: * on and off.

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

232:
233:
234: l_proc varchar2(80) := g_package||'.write_person_category';
235: l_actn varchar2(80);
236: l_cache ben_batch_utils.g_comp_obj_table := ben_batch_utils.g_cache_comp;
237: l_cache_cnt binary_integer := ben_batch_utils.g_cache_comp_cnt;
238: l_category varchar2(30):= 'DEFNOCHG';
239: l_detail varchar2(132) := 'Default election asigned -- no current elections changed' ;
240: l_OVN Number;

Line 237: l_cache_cnt binary_integer := ben_batch_utils.g_cache_comp_cnt;

233:
234: l_proc varchar2(80) := g_package||'.write_person_category';
235: l_actn varchar2(80);
236: l_cache ben_batch_utils.g_comp_obj_table := ben_batch_utils.g_cache_comp;
237: l_cache_cnt binary_integer := ben_batch_utils.g_cache_comp_cnt;
238: l_category varchar2(30):= 'DEFNOCHG';
239: l_detail varchar2(132) := 'Default election asigned -- no current elections changed' ;
240: l_OVN Number;
241: l_id Number;

Line 252: l_actn := 'Calling ben_batch_utils.write_rec (ERROR)...';

248: If (p_audit_log = 'Y') then
249: l_category := 'ERROR_C';
250: l_detail := 'Error occur while defaulting enrollment';
251: --
252: l_actn := 'Calling ben_batch_utils.write_rec (ERROR)...';
253: Ben_batch_utils.write_rec(p_typ_cd => l_category ,p_text => l_detail);
254: End if;
255: Else
256: For i in 1..l_cache_cnt Loop

Line 253: Ben_batch_utils.write_rec(p_typ_cd => l_category ,p_text => l_detail);

249: l_category := 'ERROR_C';
250: l_detail := 'Error occur while defaulting enrollment';
251: --
252: l_actn := 'Calling ben_batch_utils.write_rec (ERROR)...';
253: Ben_batch_utils.write_rec(p_typ_cd => l_category ,p_text => l_detail);
254: End if;
255: Else
256: For i in 1..l_cache_cnt Loop
257: If (l_cache(i).upd_flag or l_cache(i).ins_flag or l_cache(i).del_flag) then

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

260: exit;
261: End if;
262: End loop;
263: --
264: l_actn := 'Calling ben_batch_utils.write_rec (DEFAULT)...';
265: Ben_batch_utils.write_rec(p_typ_cd => l_category,p_text => l_detail);
266: End if;
267: If (p_audit_log = 'Y') then
268: For i in 1..l_cache_cnt Loop

Line 265: Ben_batch_utils.write_rec(p_typ_cd => l_category,p_text => l_detail);

261: End if;
262: End loop;
263: --
264: l_actn := 'Calling ben_batch_utils.write_rec (DEFAULT)...';
265: Ben_batch_utils.write_rec(p_typ_cd => l_category,p_text => l_detail);
266: End if;
267: If (p_audit_log = 'Y') then
268: For i in 1..l_cache_cnt Loop
269: If (l_cache(i).del_flag) then

Line 345: ben_batch_utils.rpt_error(p_proc => l_proc

341: End if;
342: hr_utility.set_location ('Leaving '||l_proc,10);
343: Exception
344: When others then
345: ben_batch_utils.rpt_error(p_proc => l_proc
346: ,p_last_actn => l_actn
347: ,p_rpt_flag => TRUE
348: );
349: raise;

Line 353: -- << Procedure: ben_batch_utils.batch_report >>

349: raise;
350: End write_person_category;
351: --
352: -- ===========================================================================
353: -- << Procedure: ben_batch_utils.batch_report >>
354: -- ===========================================================================
355: --
356: Procedure Submit_all_reports
357: (p_rpt_flag in Boolean default FALSE

Line 366: l_actn := 'Calling ben_batch_utils.batch_report (BENDFAUD)...';

362: l_request_id number;
363: Begin
364: hr_utility.set_location ('Entering '||l_proc,05);
365: If fnd_global.conc_request_id <> -1 then
366: l_actn := 'Calling ben_batch_utils.batch_report (BENDFAUD)...';
367: If (p_audit_log = 'Y') then
368: ben_batch_utils.batch_report
369: (p_concurrent_request_id => fnd_global.conc_request_id
370: ,p_program_name => 'BENDFAUD'

Line 368: ben_batch_utils.batch_report

364: hr_utility.set_location ('Entering '||l_proc,05);
365: If fnd_global.conc_request_id <> -1 then
366: l_actn := 'Calling ben_batch_utils.batch_report (BENDFAUD)...';
367: If (p_audit_log = 'Y') then
368: ben_batch_utils.batch_report
369: (p_concurrent_request_id => fnd_global.conc_request_id
370: ,p_program_name => 'BENDFAUD'
371: ,p_request_id => l_request_id
372: );

Line 374: l_actn := 'Calling ben_batch_utils.batch_report (BENDFSUM)...';

370: ,p_program_name => 'BENDFAUD'
371: ,p_request_id => l_request_id
372: );
373: End if;
374: l_actn := 'Calling ben_batch_utils.batch_report (BENDFSUM)...';
375: ben_batch_utils.batch_report
376: (p_concurrent_request_id => fnd_global.conc_request_id
377: ,p_program_name => 'BENDFSUM'
378: ,p_request_id => l_request_id

Line 375: ben_batch_utils.batch_report

371: ,p_request_id => l_request_id
372: );
373: End if;
374: l_actn := 'Calling ben_batch_utils.batch_report (BENDFSUM)...';
375: ben_batch_utils.batch_report
376: (p_concurrent_request_id => fnd_global.conc_request_id
377: ,p_program_name => 'BENDFSUM'
378: ,p_request_id => l_request_id
379: );

Line 380: l_actn := 'Calling ben_batch_utils.batch_report (BENERTYP)...';

376: (p_concurrent_request_id => fnd_global.conc_request_id
377: ,p_program_name => 'BENDFSUM'
378: ,p_request_id => l_request_id
379: );
380: l_actn := 'Calling ben_batch_utils.batch_report (BENERTYP)...';
381: ben_batch_utils.batch_report
382: (p_concurrent_request_id => fnd_global.conc_request_id
383: ,p_program_name => 'BENERTYP'
384: ,p_request_id => l_request_id

Line 381: ben_batch_utils.batch_report

377: ,p_program_name => 'BENDFSUM'
378: ,p_request_id => l_request_id
379: );
380: l_actn := 'Calling ben_batch_utils.batch_report (BENERTYP)...';
381: ben_batch_utils.batch_report
382: (p_concurrent_request_id => fnd_global.conc_request_id
383: ,p_program_name => 'BENERTYP'
384: ,p_request_id => l_request_id
385: ,p_subtitle =>

Line 388: l_actn := 'Calling ben_batch_utils.batch_report (BENERPER)...';

384: ,p_request_id => l_request_id
385: ,p_subtitle =>
386: 'ERROR DETAIL BY ERROR TYPE'
387: );
388: l_actn := 'Calling ben_batch_utils.batch_report (BENERPER)...';
389: ben_batch_utils.batch_report
390: (p_concurrent_request_id => fnd_global.conc_request_id
391: ,p_program_name => 'BENERPER'
392: ,p_request_id => l_request_id

Line 389: ben_batch_utils.batch_report

385: ,p_subtitle =>
386: 'ERROR DETAIL BY ERROR TYPE'
387: );
388: l_actn := 'Calling ben_batch_utils.batch_report (BENERPER)...';
389: ben_batch_utils.batch_report
390: (p_concurrent_request_id => fnd_global.conc_request_id
391: ,p_program_name => 'BENERPER'
392: ,p_request_id => l_request_id
393: ,p_subtitle =>

Line 400: ben_batch_utils.rpt_error(p_proc => l_proc

396: End if;
397: hr_utility.set_location ('Leaving '||l_proc,10);
398: Exception
399: When others then
400: ben_batch_utils.rpt_error(p_proc => l_proc
401: ,p_last_actn => l_actn
402: ,p_rpt_flag => p_rpt_flag
403: );
404: raise;

Line 501: l_actn := 'Calling ben_batch_utils.ini...';

497: p_threads => l_threads,
498: p_max_errors => g_max_errors_allowed,
499: p_benefit_action_id => p_benefit_action_id);
500: --
501: l_actn := 'Calling ben_batch_utils.ini...';
502: ben_batch_utils.ini;
503: --
504: -- Copy benefit action id to global in benutils package
505: --

Line 502: ben_batch_utils.ini;

498: p_max_errors => g_max_errors_allowed,
499: p_benefit_action_id => p_benefit_action_id);
500: --
501: l_actn := 'Calling ben_batch_utils.ini...';
502: ben_batch_utils.ini;
503: --
504: -- Copy benefit action id to global in benutils package
505: --
506: benutils.g_benefit_action_id := p_benefit_action_id;

Line 514: l_actn := 'Calling ben_batch_utils.print_parameters...';

510: open c_parameter;
511: fetch c_parameter into l_parm;
512: close c_parameter;
513: --
514: l_actn := 'Calling ben_batch_utils.print_parameters...';
515: --
516: ben_batch_utils.print_parameters
517: (p_thread_id => p_thread_id
518: ,p_benefit_action_id => p_benefit_action_id

Line 516: ben_batch_utils.print_parameters

512: close c_parameter;
513: --
514: l_actn := 'Calling ben_batch_utils.print_parameters...';
515: --
516: ben_batch_utils.print_parameters
517: (p_thread_id => p_thread_id
518: ,p_benefit_action_id => p_benefit_action_id
519: ,p_validate => p_validate
520: ,p_business_group_id => p_business_group_id

Line 621: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd

617: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
618: commit;
619: --
620: l_actn := 'Calling Log_beneadeb_statistics...';
621: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd
622: ,p_num_pers_errored => g_persons_errored
623: );
624: hr_utility.set_location ('Leaving '||l_proc,70);
625: Exception

Line 627: ben_batch_utils.rpt_error(p_proc => l_proc

623: );
624: hr_utility.set_location ('Leaving '||l_proc,70);
625: Exception
626: When others then
627: ben_batch_utils.rpt_error(p_proc => l_proc
628: ,p_last_actn => l_actn
629: ,p_rpt_flag => TRUE
630: );
631: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd

Line 631: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd

627: ben_batch_utils.rpt_error(p_proc => l_proc
628: ,p_last_actn => l_actn
629: ,p_rpt_flag => TRUE
630: );
631: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd
632: ,p_num_pers_errored => g_persons_errored
633: );
634: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
635: commit;

Line 692: ben_batch_utils.rpt_error(p_proc => l_proc

688: l_actn := 'Getting parameter data...';
689: open c_parameters;
690: fetch c_parameters into l_parameters;
691: If c_parameters%notfound then
692: ben_batch_utils.rpt_error(p_proc => l_proc
693: ,p_last_actn => l_actn
694: ,p_rpt_flag => TRUE
695: );
696: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');

Line 726: ben_batch_utils.rpt_error(p_proc => l_proc

722: );
723: hr_utility.set_location ('Leaving '||l_proc,70);
724: Exception
725: when others then
726: ben_batch_utils.rpt_error(p_proc => l_proc
727: ,p_last_actn => l_actn
728: ,p_rpt_flag => TRUE
729: );
730: raise;

Line 912: ben_batch_utils.g_audit_flag := true;

908: --
909: hr_utility.set_location ('Entering '||l_proc,10);
910: -- Bug 5857493
911: if p_audit_log ='Y' then
912: ben_batch_utils.g_audit_flag := true;
913: else
914: ben_batch_utils.g_audit_flag := false;
915: end if;
916: --

Line 914: ben_batch_utils.g_audit_flag := false;

910: -- Bug 5857493
911: if p_audit_log ='Y' then
912: ben_batch_utils.g_audit_flag := true;
913: else
914: ben_batch_utils.g_audit_flag := false;
915: end if;
916: --
917: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
918: --

Line 925: l_actn := 'Initialize the ben_batch_utils cache...';

921: dt_fndate.change_ses_date
922: (p_ses_date => l_effective_date,
923: p_commit => l_commit);
924: --
925: l_actn := 'Initialize the ben_batch_utils cache...';
926: --
927: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
928: --
929: -- Get chunk_size and Thread values for multi-thread process, and check to

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

923: p_commit => l_commit);
924: --
925: l_actn := 'Initialize the ben_batch_utils cache...';
926: --
927: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
928: --
929: -- Get chunk_size and Thread values for multi-thread process, and check to
930: --
931: l_actn := 'Calling benutils.get_parameter...';

Line 1003: l_actn := 'Calling Ben_batch_utils.person_selection_rule...';

999: l_skip := FALSE;
1000: --
1001: if p_person_selection_rule_id is not null then
1002: --
1003: l_actn := 'Calling Ben_batch_utils.person_selection_rule...';
1004: l_rule_value :=
1005: ben_batch_utils.person_selection_rule
1006: (p_person_id => l_person_id_out
1007: ,p_business_group_id => p_business_group_id

Line 1005: ben_batch_utils.person_selection_rule

1001: if p_person_selection_rule_id is not null then
1002: --
1003: l_actn := 'Calling Ben_batch_utils.person_selection_rule...';
1004: l_rule_value :=
1005: ben_batch_utils.person_selection_rule
1006: (p_person_id => l_person_id_out
1007: ,p_business_group_id => p_business_group_id
1008: ,p_person_selection_rule_id=> p_person_selection_rule_id
1009: ,p_effective_date => l_effective_date);

Line 1176: l_actn := 'Calling Ben_batch_utils.create_restart_person_actions...';

1172: --
1173: Else
1174: --
1175: l_benefit_action_id := p_benefit_action_id;
1176: l_actn := 'Calling Ben_batch_utils.create_restart_person_actions...';
1177: --
1178: Ben_batch_utils.create_restart_person_actions
1179: (p_benefit_action_id => p_benefit_action_id
1180: ,p_effective_date => l_effective_date

Line 1178: Ben_batch_utils.create_restart_person_actions

1174: --
1175: l_benefit_action_id := p_benefit_action_id;
1176: l_actn := 'Calling Ben_batch_utils.create_restart_person_actions...';
1177: --
1178: Ben_batch_utils.create_restart_person_actions
1179: (p_benefit_action_id => p_benefit_action_id
1180: ,p_effective_date => l_effective_date
1181: ,p_chunk_size => l_chunk_size
1182: ,p_threads => l_threads

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

1207: ,argument6 => p_audit_log);
1208: --
1209: -- Store the request id of the concurrent request
1210: --
1211: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
1212: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
1213: := l_request_id;
1214: --
1215: commit;

Line 1212: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)

1208: --
1209: -- Store the request id of the concurrent request
1210: --
1211: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
1212: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
1213: := l_request_id;
1214: --
1215: commit;
1216: --

Line 1221: l_actn := 'Calling Ben_batch_utils.print_parameters...';

1217: End loop;
1218: --
1219: Elsif (l_num_ranges = 0 ) then
1220: --
1221: l_actn := 'Calling Ben_batch_utils.print_parameters...';
1222: --
1223: Ben_batch_utils.print_parameters
1224: (p_thread_id => 99
1225: ,p_benefit_action_id => l_benefit_action_id

Line 1223: Ben_batch_utils.print_parameters

1219: Elsif (l_num_ranges = 0 ) then
1220: --
1221: l_actn := 'Calling Ben_batch_utils.print_parameters...';
1222: --
1223: Ben_batch_utils.print_parameters
1224: (p_thread_id => 99
1225: ,p_benefit_action_id => l_benefit_action_id
1226: ,p_validate => p_validate
1227: ,p_business_group_id => p_business_group_id

Line 1241: Ben_batch_utils.write(p_text =>

1237: ,p_legal_entity_id => p_legal_entity_id
1238: ,p_payroll_id => p_payroll_id
1239: ,p_audit_log => p_audit_log);
1240: --
1241: Ben_batch_utils.write(p_text =>
1242: '<< No Person got selected with above selection criteria >>' );
1243: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1244: fnd_message.set_token('PROC',l_proc);
1245: raise l_silent_error;

Line 1260: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';

1256: ,p_effective_date => p_effective_date
1257: ,p_business_group_id => p_business_group_id
1258: ,p_audit_log => p_audit_log);
1259: --
1260: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
1261: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1262: --
1263: l_actn := 'Calling ben_batch_utils.End_process...';
1264: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

1257: ,p_business_group_id => p_business_group_id
1258: ,p_audit_log => p_audit_log);
1259: --
1260: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
1261: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1262: --
1263: l_actn := 'Calling ben_batch_utils.End_process...';
1264: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1265: ,p_person_selected => l_num_persons

Line 1263: l_actn := 'Calling ben_batch_utils.End_process...';

1259: --
1260: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
1261: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1262: --
1263: l_actn := 'Calling ben_batch_utils.End_process...';
1264: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1265: ,p_person_selected => l_num_persons
1266: ,p_business_group_id => p_business_group_id);
1267: --

Line 1264: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

1260: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
1261: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1262: --
1263: l_actn := 'Calling ben_batch_utils.End_process...';
1264: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1265: ,p_person_selected => l_num_persons
1266: ,p_business_group_id => p_business_group_id);
1267: --
1268: l_actn := 'Calling submit_all_reports...';

Line 1276: ben_batch_utils.write(p_text => fnd_message.get);

1272: --
1273: Exception
1274: --
1275: when l_silent_error then
1276: ben_batch_utils.write(p_text => fnd_message.get);
1277: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1278: If (l_num_ranges > 0) then
1279: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1280: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

1275: when l_silent_error then
1276: ben_batch_utils.write(p_text => fnd_message.get);
1277: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1278: If (l_num_ranges > 0) then
1279: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1280: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1281: ,p_person_selected => l_num_persons
1282: ,p_business_group_id => p_business_group_id);
1283: submit_all_reports(p_audit_log => p_audit_log);

Line 1280: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

1276: ben_batch_utils.write(p_text => fnd_message.get);
1277: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1278: If (l_num_ranges > 0) then
1279: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1280: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1281: ,p_person_selected => l_num_persons
1282: ,p_business_group_id => p_business_group_id);
1283: submit_all_reports(p_audit_log => p_audit_log);
1284: End if;

Line 1287: ben_batch_utils.rpt_error(p_proc => l_proc

1283: submit_all_reports(p_audit_log => p_audit_log);
1284: End if;
1285: --
1286: when others then
1287: ben_batch_utils.rpt_error(p_proc => l_proc
1288: ,p_last_actn => l_actn
1289: ,p_rpt_flag => TRUE );
1290: ben_batch_utils.write(p_text => fnd_message.get);
1291: ben_batch_utils.write(p_text => sqlerrm);

Line 1290: ben_batch_utils.write(p_text => fnd_message.get);

1286: when others then
1287: ben_batch_utils.rpt_error(p_proc => l_proc
1288: ,p_last_actn => l_actn
1289: ,p_rpt_flag => TRUE );
1290: ben_batch_utils.write(p_text => fnd_message.get);
1291: ben_batch_utils.write(p_text => sqlerrm);
1292: ben_batch_utils.write(p_text => 'Big Error Occured');
1293: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1294: If (l_num_ranges > 0) then

Line 1291: ben_batch_utils.write(p_text => sqlerrm);

1287: ben_batch_utils.rpt_error(p_proc => l_proc
1288: ,p_last_actn => l_actn
1289: ,p_rpt_flag => TRUE );
1290: ben_batch_utils.write(p_text => fnd_message.get);
1291: ben_batch_utils.write(p_text => sqlerrm);
1292: ben_batch_utils.write(p_text => 'Big Error Occured');
1293: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1294: If (l_num_ranges > 0) then
1295: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

Line 1292: ben_batch_utils.write(p_text => 'Big Error Occured');

1288: ,p_last_actn => l_actn
1289: ,p_rpt_flag => TRUE );
1290: ben_batch_utils.write(p_text => fnd_message.get);
1291: ben_batch_utils.write(p_text => sqlerrm);
1292: ben_batch_utils.write(p_text => 'Big Error Occured');
1293: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1294: If (l_num_ranges > 0) then
1295: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1296: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

1291: ben_batch_utils.write(p_text => sqlerrm);
1292: ben_batch_utils.write(p_text => 'Big Error Occured');
1293: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1294: If (l_num_ranges > 0) then
1295: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1296: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1297: ,p_person_selected => l_num_persons
1298: ,p_business_group_id => p_business_group_id);
1299: submit_all_reports(p_audit_log => p_audit_log);

Line 1296: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

1292: ben_batch_utils.write(p_text => 'Big Error Occured');
1293: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1294: If (l_num_ranges > 0) then
1295: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1296: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1297: ,p_person_selected => l_num_persons
1298: ,p_business_group_id => p_business_group_id);
1299: submit_all_reports(p_audit_log => p_audit_log);
1300: End if;

Line 1860: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';

1856: --
1857: End if;
1858: If (p_batch_flag) then
1859: --
1860: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';
1861: Ben_batch_utils.cache_comp_obj
1862: (p_prtt_enrt_rslt_id => l_epe(i).prtt_enrt_rslt_id
1863: ,p_effective_date => p_effective_date
1864: ,p_actn_cd => l_epe(i).actn_cd

Line 1861: Ben_batch_utils.cache_comp_obj

1857: End if;
1858: If (p_batch_flag) then
1859: --
1860: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';
1861: Ben_batch_utils.cache_comp_obj
1862: (p_prtt_enrt_rslt_id => l_epe(i).prtt_enrt_rslt_id
1863: ,p_effective_date => p_effective_date
1864: ,p_actn_cd => l_epe(i).actn_cd
1865: ,p_suspended => l_epe(i).suspended);

Line 1978: -- ben_batch_utils.write(p_text => fnd_message.get);

1974: if p_batch_flag then
1975: --
1976: -- Update person action to errored as record has an error
1977: --
1978: -- ben_batch_utils.write(p_text => fnd_message.get);
1979: ben_batch_utils.write(p_text => sqlerrm);
1980: ben_batch_utils.rpt_error(p_proc => l_proc
1981: ,p_last_actn => l_actn
1982: ,p_rpt_flag => p_batch_flag

Line 1979: ben_batch_utils.write(p_text => sqlerrm);

1975: --
1976: -- Update person action to errored as record has an error
1977: --
1978: -- ben_batch_utils.write(p_text => fnd_message.get);
1979: ben_batch_utils.write(p_text => sqlerrm);
1980: ben_batch_utils.rpt_error(p_proc => l_proc
1981: ,p_last_actn => l_actn
1982: ,p_rpt_flag => p_batch_flag
1983: );

Line 1980: ben_batch_utils.rpt_error(p_proc => l_proc

1976: -- Update person action to errored as record has an error
1977: --
1978: -- ben_batch_utils.write(p_text => fnd_message.get);
1979: ben_batch_utils.write(p_text => sqlerrm);
1980: ben_batch_utils.rpt_error(p_proc => l_proc
1981: ,p_last_actn => l_actn
1982: ,p_rpt_flag => p_batch_flag
1983: );
1984: raise ben_batch_utils.g_record_error ;

Line 1984: raise ben_batch_utils.g_record_error ;

1980: ben_batch_utils.rpt_error(p_proc => l_proc
1981: ,p_last_actn => l_actn
1982: ,p_rpt_flag => p_batch_flag
1983: );
1984: raise ben_batch_utils.g_record_error ;
1985: -- Added for Bug 2370264
1986: else
1987: hr_utility.set_location ('Error in Default_Comp_obj : '|| sqlerrm , 87);
1988: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');

Line 2082: l_actn := 'Calling ben_batch_utils.person_header...';

2078: Savepoint process_default_enrt_savepoint;
2079: --
2080: -- Cache person data and write personal data into cache.
2081: --
2082: l_actn := 'Calling ben_batch_utils.person_header...';
2083: ben_batch_utils.person_header
2084: (p_person_id => p_person_id
2085: ,p_business_group_id => p_business_group_id
2086: ,p_effective_date => p_effective_date

Line 2083: ben_batch_utils.person_header

2079: --
2080: -- Cache person data and write personal data into cache.
2081: --
2082: l_actn := 'Calling ben_batch_utils.person_header...';
2083: ben_batch_utils.person_header
2084: (p_person_id => p_person_id
2085: ,p_business_group_id => p_business_group_id
2086: ,p_effective_date => p_effective_date
2087: );

Line 2089: l_actn := 'Calling ben_batch_utils.ini(COMP_OBJ)...';

2085: ,p_business_group_id => p_business_group_id
2086: ,p_effective_date => p_effective_date
2087: );
2088: --
2089: l_actn := 'Calling ben_batch_utils.ini(COMP_OBJ)...';
2090: ben_batch_utils.ini('COMP_OBJ');
2091: For l_rec in c_pel loop
2092: l_pel_cnt := l_pel_cnt + 1;
2093: l_per_in_ler_id:=l_rec.per_in_ler_id;

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

2086: ,p_effective_date => p_effective_date
2087: );
2088: --
2089: l_actn := 'Calling ben_batch_utils.ini(COMP_OBJ)...';
2090: ben_batch_utils.ini('COMP_OBJ');
2091: For l_rec in c_pel loop
2092: l_pel_cnt := l_pel_cnt + 1;
2093: l_per_in_ler_id:=l_rec.per_in_ler_id;
2094: l_ler_id := l_rec.ler_id;

Line 2160: l_actn := 'Calling Ben_batch_utils.write_comp...';

2156: ,p_uneai_effective_date => p_effective_date
2157: );
2158: end if;
2159: --
2160: l_actn := 'Calling Ben_batch_utils.write_comp...';
2161: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
2162: ,p_effective_date => p_effective_date
2163: );
2164: If (p_validate = 'Y') then

Line 2161: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id

2157: );
2158: end if;
2159: --
2160: l_actn := 'Calling Ben_batch_utils.write_comp...';
2161: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
2162: ,p_effective_date => p_effective_date
2163: );
2164: If (p_validate = 'Y') then
2165: Rollback to process_default_enrt_savepoint;

Line 2213: ben_batch_utils.write_error_rec;

2209: Exception
2210: When others then
2211: rollback to process_default_enrt_savepoint;
2212: g_persons_errored := g_persons_errored + 1;
2213: ben_batch_utils.write_error_rec;
2214: ben_batch_utils.write(p_text => fnd_message.get);
2215: ben_batch_utils.write(p_text => sqlerrm);
2216: ben_batch_utils.rpt_error(p_proc => l_proc
2217: ,p_last_actn => l_actn

Line 2214: ben_batch_utils.write(p_text => fnd_message.get);

2210: When others then
2211: rollback to process_default_enrt_savepoint;
2212: g_persons_errored := g_persons_errored + 1;
2213: ben_batch_utils.write_error_rec;
2214: ben_batch_utils.write(p_text => fnd_message.get);
2215: ben_batch_utils.write(p_text => sqlerrm);
2216: ben_batch_utils.rpt_error(p_proc => l_proc
2217: ,p_last_actn => l_actn
2218: ,p_rpt_flag => TRUE);

Line 2215: ben_batch_utils.write(p_text => sqlerrm);

2211: rollback to process_default_enrt_savepoint;
2212: g_persons_errored := g_persons_errored + 1;
2213: ben_batch_utils.write_error_rec;
2214: ben_batch_utils.write(p_text => fnd_message.get);
2215: ben_batch_utils.write(p_text => sqlerrm);
2216: ben_batch_utils.rpt_error(p_proc => l_proc
2217: ,p_last_actn => l_actn
2218: ,p_rpt_flag => TRUE);
2219: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id

Line 2216: ben_batch_utils.rpt_error(p_proc => l_proc

2212: g_persons_errored := g_persons_errored + 1;
2213: ben_batch_utils.write_error_rec;
2214: ben_batch_utils.write(p_text => fnd_message.get);
2215: ben_batch_utils.write(p_text => sqlerrm);
2216: ben_batch_utils.rpt_error(p_proc => l_proc
2217: ,p_last_actn => l_actn
2218: ,p_rpt_flag => TRUE);
2219: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
2220: ,p_effective_date => p_effective_date

Line 2219: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id

2215: ben_batch_utils.write(p_text => sqlerrm);
2216: ben_batch_utils.rpt_error(p_proc => l_proc
2217: ,p_last_actn => l_actn
2218: ,p_rpt_flag => TRUE);
2219: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
2220: ,p_effective_date => p_effective_date
2221: );
2222: If p_person_action_id is not null then
2223: ben_person_actions_api.update_person_actions

Line 2237: raise ben_batch_utils.g_record_error;

2233: ,p_business_group_id => p_business_group_id
2234: ,p_effective_date => p_effective_date
2235: );
2236: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
2237: raise ben_batch_utils.g_record_error;
2238: end process_default_enrt;
2239:
2240: -- ============================================================================
2241: -- << Procedure: Default_comp_obj_w >>