DBA Data[Home] [Help]

APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_BATCH_UTILS

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

230: hr_utility.set_location(' Leaving:'||l_proc, 70);
231: end calc_dpnt_cvg_end_dt;
232: --
233: -- ===========================================================================
234: -- << Procedure: ben_batch_utils.batch_report >>
235: -- ===========================================================================
236: --
237: Procedure Submit_all_reports (p_rpt_flag Boolean default FALSE) is
238: l_proc varchar2(80) := g_package||'.submit_all_reports';

Line 243: l_actn := 'Calling ben_batch_utils.batch_report (BENDEAUD)...';

239: l_actn varchar2(80);
240: l_request_id number;
241: Begin
242: hr_utility.set_location ('Entering '||l_proc,05);
243: l_actn := 'Calling ben_batch_utils.batch_report (BENDEAUD)...';
244: --
245: If fnd_global.conc_request_id <> -1 then
246: --
247: ben_batch_utils.batch_report

Line 247: ben_batch_utils.batch_report

243: l_actn := 'Calling ben_batch_utils.batch_report (BENDEAUD)...';
244: --
245: If fnd_global.conc_request_id <> -1 then
246: --
247: ben_batch_utils.batch_report
248: (p_concurrent_request_id => fnd_global.conc_request_id
249: ,p_program_name => 'BENDEAUD'
250: ,p_request_id => l_request_id
251: );

Line 252: l_actn := 'Calling ben_batch_utils.batch_report (BENDESUM)...';

248: (p_concurrent_request_id => fnd_global.conc_request_id
249: ,p_program_name => 'BENDEAUD'
250: ,p_request_id => l_request_id
251: );
252: l_actn := 'Calling ben_batch_utils.batch_report (BENDESUM)...';
253: ben_batch_utils.batch_report
254: (p_concurrent_request_id => fnd_global.conc_request_id
255: ,p_program_name => 'BENDESUM'
256: ,p_request_id => l_request_id

Line 253: ben_batch_utils.batch_report

249: ,p_program_name => 'BENDEAUD'
250: ,p_request_id => l_request_id
251: );
252: l_actn := 'Calling ben_batch_utils.batch_report (BENDESUM)...';
253: ben_batch_utils.batch_report
254: (p_concurrent_request_id => fnd_global.conc_request_id
255: ,p_program_name => 'BENDESUM'
256: ,p_request_id => l_request_id
257: );

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

254: (p_concurrent_request_id => fnd_global.conc_request_id
255: ,p_program_name => 'BENDESUM'
256: ,p_request_id => l_request_id
257: );
258: l_actn := 'Calling ben_batch_utils.batch_report (BENERTYP)...';
259: ben_batch_utils.batch_report
260: (p_concurrent_request_id => fnd_global.conc_request_id
261: ,p_program_name => 'BENERTYP'
262: ,p_request_id => l_request_id

Line 259: ben_batch_utils.batch_report

255: ,p_program_name => 'BENDESUM'
256: ,p_request_id => l_request_id
257: );
258: l_actn := 'Calling ben_batch_utils.batch_report (BENERTYP)...';
259: ben_batch_utils.batch_report
260: (p_concurrent_request_id => fnd_global.conc_request_id
261: ,p_program_name => 'BENERTYP'
262: ,p_request_id => l_request_id
263: -- ,p_subtitle =>

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

262: ,p_request_id => l_request_id
263: -- ,p_subtitle =>
264: -- 'MANAGE DEFAULT ENROLLMENTS - ERROR DETAIL BY ERROR TYPE'
265: );
266: l_actn := 'Calling ben_batch_utils.batch_report (BENERPER)...';
267: ben_batch_utils.batch_report
268: (p_concurrent_request_id => fnd_global.conc_request_id
269: ,p_program_name => 'BENERPER'
270: ,p_request_id => l_request_id

Line 267: ben_batch_utils.batch_report

263: -- ,p_subtitle =>
264: -- 'MANAGE DEFAULT ENROLLMENTS - ERROR DETAIL BY ERROR TYPE'
265: );
266: l_actn := 'Calling ben_batch_utils.batch_report (BENERPER)...';
267: ben_batch_utils.batch_report
268: (p_concurrent_request_id => fnd_global.conc_request_id
269: ,p_program_name => 'BENERPER'
270: ,p_request_id => l_request_id
271: -- ,p_subtitle =>

Line 278: ben_batch_utils.rpt_error(p_proc => l_proc

274: end if;
275: hr_utility.set_location ('Leaving '||l_proc,10);
276: Exception
277: When others then
278: ben_batch_utils.rpt_error(p_proc => l_proc
279: ,p_last_actn => l_actn
280: ,p_rpt_flag => p_rpt_flag
281: );
282: raise;

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

377: p_threads => l_threads,
378: p_max_errors => g_max_errors_allowed,
379: p_benefit_action_id => p_benefit_action_id);
380: --
381: l_actn := 'Calling ben_batch_utils.ini...';
382: ben_batch_utils.ini;
383: --
384: -- Copy benefit action id to global in benutils package
385: --

Line 382: ben_batch_utils.ini;

378: p_max_errors => g_max_errors_allowed,
379: p_benefit_action_id => p_benefit_action_id);
380: --
381: l_actn := 'Calling ben_batch_utils.ini...';
382: ben_batch_utils.ini;
383: --
384: -- Copy benefit action id to global in benutils package
385: --
386: benutils.g_benefit_action_id := p_benefit_action_id;

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

390: open c_parameter;
391: fetch c_parameter into l_parm;
392: close c_parameter;
393: --
394: l_actn := 'Calling ben_batch_utils.print_parameters...';
395: --
396: ben_batch_utils.print_parameters
397: (p_thread_id => p_thread_id
398: ,p_benefit_action_id => p_benefit_action_id

Line 396: ben_batch_utils.print_parameters

392: close c_parameter;
393: --
394: l_actn := 'Calling ben_batch_utils.print_parameters...';
395: --
396: ben_batch_utils.print_parameters
397: (p_thread_id => p_thread_id
398: ,p_benefit_action_id => p_benefit_action_id
399: ,p_validate => p_validate
400: ,p_business_group_id => p_business_group_id

Line 503: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed

499: End loop;
500: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); -- Bug5070692
501: --
502: l_actn := 'Calling Log_statistics...';
503: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
504: ,p_num_pers_errored => g_persons_errored
505: );
506: hr_utility.set_location ('Leaving '||l_proc,70);
507: Exception

Line 509: ben_batch_utils.rpt_error(p_proc => l_proc

505: );
506: hr_utility.set_location ('Leaving '||l_proc,70);
507: Exception
508: When others then
509: ben_batch_utils.rpt_error(p_proc => l_proc
510: ,p_last_actn => l_actn
511: ,p_rpt_flag => TRUE
512: );
513: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed

Line 513: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed

509: ben_batch_utils.rpt_error(p_proc => l_proc
510: ,p_last_actn => l_actn
511: ,p_rpt_flag => TRUE
512: );
513: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
514: ,p_num_pers_errored => g_persons_errored
515: );
516: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
517: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 571: ben_batch_utils.rpt_error(p_proc => l_proc

567: l_actn := 'Getting parameter data...';
568: open c_parameters;
569: fetch c_parameters into l_parameters;
570: If c_parameters%notfound then
571: ben_batch_utils.rpt_error(p_proc => l_proc
572: ,p_last_actn => l_actn
573: ,p_rpt_flag => TRUE
574: );
575: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');

Line 606: ben_batch_utils.rpt_error(p_proc => l_proc

602: );
603: hr_utility.set_location ('Leaving '||l_proc,70);
604: Exception
605: when others then
606: ben_batch_utils.rpt_error(p_proc => l_proc
607: ,p_last_actn => l_actn
608: ,p_rpt_flag => TRUE
609: );
610: raise;

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

791: dt_fndate.change_ses_date
792: (p_ses_date => l_effective_date,
793: p_commit => l_commit);
794: --
795: l_actn := 'Initialize the ben_batch_utils cache...';
796: --
797: ben_batch_utils.ini;
798: --
799: l_actn := 'Initialize the ben_batch_utils cache...';

Line 797: ben_batch_utils.ini;

793: p_commit => l_commit);
794: --
795: l_actn := 'Initialize the ben_batch_utils cache...';
796: --
797: ben_batch_utils.ini;
798: --
799: l_actn := 'Initialize the ben_batch_utils cache...';
800: --
801: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');

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

795: l_actn := 'Initialize the ben_batch_utils cache...';
796: --
797: ben_batch_utils.ini;
798: --
799: l_actn := 'Initialize the ben_batch_utils cache...';
800: --
801: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
802: --
803: -- Check that all the mandatory input parameters

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

797: ben_batch_utils.ini;
798: --
799: l_actn := 'Initialize the ben_batch_utils cache...';
800: --
801: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
802: --
803: -- Check that all the mandatory input parameters
804: -- such as p_business_group_id, p_mode, p_effective_date
805: --

Line 891: l_actn := 'Calling ben_batch_utils.person_selection_rule...';

887: Loop
888: fetch c_person into l_person_id,l_part_person_id;
889: Exit when c_person%notfound;
890: l_cnt := l_cnt + 1;
891: l_actn := 'Calling ben_batch_utils.person_selection_rule...';
892: hr_utility.set_location('person_id='||to_char(l_person_id),999);
893: --
894: -- if p_person_selection_rule_id is pass, test rule.
895: -- If the rule return 'N' then

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

897: -- skip that person_id.
898: --
899: skip := FALSE;
900: If (p_person_selection_rule_id is not NULL) then
901: l_actn := 'Calling Ben_batch_utils.person_selection_rule...';
902: rl_ret := ben_batch_utils.person_selection_rule
903: (p_person_id => l_part_person_id
904: ,p_business_group_id => p_business_group_id
905: ,p_person_selection_rule_id=> p_person_selection_rule_id

Line 902: rl_ret := ben_batch_utils.person_selection_rule

898: --
899: skip := FALSE;
900: If (p_person_selection_rule_id is not NULL) then
901: l_actn := 'Calling Ben_batch_utils.person_selection_rule...';
902: rl_ret := ben_batch_utils.person_selection_rule
903: (p_person_id => l_part_person_id
904: ,p_business_group_id => p_business_group_id
905: ,p_person_selection_rule_id=> p_person_selection_rule_id
906: ,p_effective_date => l_effective_date

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

971: l_num_range := l_num_range + 1;
972: End if;
973: Else
974: l_benefit_action_id := p_benefit_action_id;
975: l_actn := 'Calling Ben_batch_utils.create_restart_person_actions...';
976: Ben_batch_utils.create_restart_person_actions
977: (p_benefit_action_id => p_benefit_action_id
978: ,p_effective_date => l_effective_date
979: ,p_chunk_size => l_chunk_size

Line 976: Ben_batch_utils.create_restart_person_actions

972: End if;
973: Else
974: l_benefit_action_id := p_benefit_action_id;
975: l_actn := 'Calling Ben_batch_utils.create_restart_person_actions...';
976: Ben_batch_utils.create_restart_person_actions
977: (p_benefit_action_id => p_benefit_action_id
978: ,p_effective_date => l_effective_date
979: ,p_chunk_size => l_chunk_size
980: ,p_threads => l_threads

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

1003: );
1004: --
1005: -- Store the request id of the concurrent request
1006: --
1007: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
1008: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
1009: := l_request_id;
1010: End loop;
1011: Elsif (l_num_range = 0 ) then

Line 1008: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)

1004: --
1005: -- Store the request id of the concurrent request
1006: --
1007: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
1008: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
1009: := l_request_id;
1010: End loop;
1011: Elsif (l_num_range = 0 ) then
1012: l_actn := 'Calling Ben_batch_utils.print_parameters...';

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

1008: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
1009: := l_request_id;
1010: End loop;
1011: Elsif (l_num_range = 0 ) then
1012: l_actn := 'Calling Ben_batch_utils.print_parameters...';
1013: Ben_batch_utils.print_parameters
1014: (p_thread_id => 99
1015: ,p_benefit_action_id => l_benefit_action_id
1016: ,p_validate => p_validate

Line 1013: Ben_batch_utils.print_parameters

1009: := l_request_id;
1010: End loop;
1011: Elsif (l_num_range = 0 ) then
1012: l_actn := 'Calling Ben_batch_utils.print_parameters...';
1013: Ben_batch_utils.print_parameters
1014: (p_thread_id => 99
1015: ,p_benefit_action_id => l_benefit_action_id
1016: ,p_validate => p_validate
1017: ,p_business_group_id => p_business_group_id

Line 1034: Ben_batch_utils.write(p_text =>

1030: ,p_location_id => p_location_id
1031: ,p_legal_entity_id => p_legal_entity_id
1032: ,p_payroll_id => p_payroll_id
1033: );
1034: Ben_batch_utils.write(p_text =>
1035: '<< No Person got selected with above selection criteria >>' );
1036: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1037: fnd_message.set_token('PROC',l_proc);
1038: fnd_message.raise_error;

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

1047: ,p_effective_date => p_effective_date
1048: ,p_business_group_id => p_business_group_id
1049: );
1050: --
1051: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
1052: --
1053: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1054: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1055: ,p_person_selected => l_person_cnt

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

1049: );
1050: --
1051: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
1052: --
1053: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1054: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1055: ,p_person_selected => l_person_cnt
1056: ,p_business_group_id => p_business_group_id);
1057: submit_all_reports;

Line 1054: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

1050: --
1051: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
1052: --
1053: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1054: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1055: ,p_person_selected => l_person_cnt
1056: ,p_business_group_id => p_business_group_id);
1057: submit_all_reports;
1058: hr_utility.set_location ('Leaving '||l_proc,70);

Line 1062: ben_batch_utils.rpt_error(p_proc => l_proc

1058: hr_utility.set_location ('Leaving '||l_proc,70);
1059: --
1060: Exception
1061: when others then
1062: ben_batch_utils.rpt_error(p_proc => l_proc
1063: ,p_last_actn => l_actn
1064: ,p_rpt_flag => TRUE );
1065: benutils.write(p_text => fnd_message.get);
1066: benutils.write(p_text => sqlerrm);

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

1066: benutils.write(p_text => sqlerrm);
1067: -- benutils.write(p_text => 'Big Error Occured');
1068: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1069: If (l_num_range > 0) then
1070: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1071: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1072: ,p_person_selected => l_person_cnt
1073: ,p_business_group_id => p_business_group_id
1074: ) ;

Line 1071: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

1067: -- benutils.write(p_text => 'Big Error Occured');
1068: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1069: If (l_num_range > 0) then
1070: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1071: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1072: ,p_person_selected => l_person_cnt
1073: ,p_business_group_id => p_business_group_id
1074: ) ;
1075: -- submit_all_reports;

Line 1136: ben_batch_utils.rpt_error(p_proc => l_proc,

1132: --
1133: open c1;
1134: fetch c1 into l_assignment_id,l_organization_id;
1135: if c1%notfound then
1136: ben_batch_utils.rpt_error(p_proc => l_proc,
1137: p_last_actn => 'Step = '||to_char(l_step),p_rpt_flag => TRUE);
1138: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
1139: fnd_message.set_token('PROC',l_proc);
1140: fnd_message.set_token('ID' , to_char(p_person_id));

Line 1183: ben_batch_utils.rpt_error(p_proc => l_proc,

1179: if upper(l_return) not in ('Y', 'N') then
1180: --
1181: -- Defensive coding for Non Y return
1182: --
1183: ben_batch_utils.rpt_error(p_proc => l_proc,
1184: p_last_actn => 'Step = '||to_char(l_step),p_rpt_flag => TRUE);
1185: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1186: fnd_message.set_token('RL','formula_id :'||p_comp_selection_rule_id);
1187: fnd_message.set_token('PROC',l_proc);

Line 1194: ben_batch_utils.rpt_error(p_proc => l_proc,

1190: return l_return;
1191: hr_utility.set_location ('Leaving '||l_proc,10);
1192: exception
1193: when others then
1194: ben_batch_utils.rpt_error(p_proc => l_proc,
1195: p_last_actn => 'Step = '||to_char(l_step),p_rpt_flag => TRUE);
1196: raise;
1197: end comp_selection_rule;
1198: --

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

1410: Savepoint process_default_enrt_savepoint;
1411: --
1412: -- Cache person data and write personal data into cache.
1413: --
1414: l_actn := 'Calling ben_batch_utils.person_header...';
1415: ben_batch_utils.person_header
1416: (p_person_id => p_person_id
1417: ,p_business_group_id => p_business_group_id
1418: ,p_effective_date => p_effective_date

Line 1415: ben_batch_utils.person_header

1411: --
1412: -- Cache person data and write personal data into cache.
1413: --
1414: l_actn := 'Calling ben_batch_utils.person_header...';
1415: ben_batch_utils.person_header
1416: (p_person_id => p_person_id
1417: ,p_business_group_id => p_business_group_id
1418: ,p_effective_date => p_effective_date
1419: );

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

1417: ,p_business_group_id => p_business_group_id
1418: ,p_effective_date => p_effective_date
1419: );
1420: --
1421: l_actn := 'Calling ben_batch_utils.ini(COMP_OBJ)...';
1422: ben_batch_utils.ini('COMP_OBJ');
1423: For l_rec in c_designation loop
1424: hr_utility.set_location(l_proc,101);
1425:

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

1418: ,p_effective_date => p_effective_date
1419: );
1420: --
1421: l_actn := 'Calling ben_batch_utils.ini(COMP_OBJ)...';
1422: ben_batch_utils.ini('COMP_OBJ');
1423: For l_rec in c_designation loop
1424: hr_utility.set_location(l_proc,101);
1425:
1426: l_returned_end_dt:=null;

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

1801: --
1802: end if;
1803: --
1804: hr_utility.set_location(l_proc,110);
1805: l_actn := 'Calling Ben_batch_utils.write_comp...';
1806: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1807: ,p_effective_date => p_effective_date
1808: );
1809: l_actn := 'Calling write_rec (category)...';

Line 1806: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id

1802: end if;
1803: --
1804: hr_utility.set_location(l_proc,110);
1805: l_actn := 'Calling Ben_batch_utils.write_comp...';
1806: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1807: ,p_effective_date => p_effective_date
1808: );
1809: l_actn := 'Calling write_rec (category)...';
1810: If (p_validate = 'Y') then

Line 1817: ben_batch_utils.g_rec.related_person_id:=l_part_person_id;

1813: --
1814: -- Store the participant Id on the related_person_id so that
1815: -- may get participant counts for summary report
1816: --
1817: ben_batch_utils.g_rec.related_person_id:=l_part_person_id;
1818: hr_utility.set_location('g_profile_value = '||g_profile_value,100);
1819: if l_person_ended='Y' then
1820: Ben_batch_utils.write_rec(p_typ_cd => 'DSGENDED');
1821: else

Line 1820: Ben_batch_utils.write_rec(p_typ_cd => 'DSGENDED');

1816: --
1817: ben_batch_utils.g_rec.related_person_id:=l_part_person_id;
1818: hr_utility.set_location('g_profile_value = '||g_profile_value,100);
1819: if l_person_ended='Y' then
1820: Ben_batch_utils.write_rec(p_typ_cd => 'DSGENDED');
1821: else
1822: --
1823: --Bug 1579948 Fix
1824: --

Line 1827: Ben_batch_utils.write_rec(p_typ_cd => 'DSGNOCHG');

1823: --Bug 1579948 Fix
1824: --
1825: if(g_profile_value <> 'N') then
1826: --
1827: Ben_batch_utils.write_rec(p_typ_cd => 'DSGNOCHG');
1828: --
1829: end if;
1830: --
1831: end if;

Line 1884: ben_batch_utils.write_error_rec;

1880: g_persons_errored := g_persons_errored + 1;
1881: -- capture the error message
1882: benutils.write(p_text => fnd_message.get);
1883: benutils.write(p_text => sqlerrm);
1884: ben_batch_utils.write_error_rec;
1885: ben_batch_utils.rpt_error(p_proc => l_proc
1886: ,p_last_actn => l_actn
1887: ,p_rpt_flag => TRUE);
1888: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id

Line 1885: ben_batch_utils.rpt_error(p_proc => l_proc

1881: -- capture the error message
1882: benutils.write(p_text => fnd_message.get);
1883: benutils.write(p_text => sqlerrm);
1884: ben_batch_utils.write_error_rec;
1885: ben_batch_utils.rpt_error(p_proc => l_proc
1886: ,p_last_actn => l_actn
1887: ,p_rpt_flag => TRUE);
1888: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1889: ,p_effective_date => p_effective_date

Line 1888: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id

1884: ben_batch_utils.write_error_rec;
1885: ben_batch_utils.rpt_error(p_proc => l_proc
1886: ,p_last_actn => l_actn
1887: ,p_rpt_flag => TRUE);
1888: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1889: ,p_effective_date => p_effective_date
1890: );
1891: If p_person_action_id is not null then
1892: ben_person_actions_api.update_person_actions

Line 1900: raise ben_batch_utils.g_record_error;

1896: ,p_effective_date => p_effective_date
1897: );
1898: End if;
1899: commit;
1900: raise ben_batch_utils.g_record_error;
1901: end process_designee_elig;
1902: --
1903: end ben_maintain_designee_elig; -- End of Package.