481: );
482: Exception
483: When others then
484: If (g_persons_errored > g_max_errors_allowed) then
485: fnd_message.raise_error;
486: End if;
487: End;
488: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); --Bug 5070692
489: End loop;
490: Else
491: --
492: l_actn := 'Erroring out nocopy since not person is found in range...' ;
493: --
494: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.raise_error;
497: End if;
498: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); --Bug 5070692
491: --
492: l_actn := 'Erroring out nocopy since not person is found in range...' ;
493: --
494: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.raise_error;
497: End if;
498: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); --Bug 5070692
499: End loop;
492: l_actn := 'Erroring out nocopy since not person is found in range...' ;
493: --
494: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
495: fnd_message.set_token('PROCEDURE', l_proc);
496: fnd_message.raise_error;
497: End if;
498: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); --Bug 5070692
499: End loop;
500: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE); -- Bug5070692
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');
518: fnd_message.set_token('PROCEDURE', l_proc);
519: fnd_message.set_token('STEP',l_actn );
520: fnd_message.raise_error;
521: End do_multithread;
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');
518: fnd_message.set_token('PROCEDURE', l_proc);
519: fnd_message.set_token('STEP',l_actn );
520: fnd_message.raise_error;
521: End do_multithread;
522: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
515: );
516: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
517: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
518: fnd_message.set_token('PROCEDURE', l_proc);
519: fnd_message.set_token('STEP',l_actn );
520: fnd_message.raise_error;
521: End do_multithread;
522: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
523: -- << Procedure: Restart >>
516: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
517: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
518: fnd_message.set_token('PROCEDURE', l_proc);
519: fnd_message.set_token('STEP',l_actn );
520: fnd_message.raise_error;
521: End do_multithread;
522: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
523: -- << Procedure: Restart >>
524: -- *****************************************************************
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');
576: fnd_message.set_token('PROC',l_proc);
577: fnd_message.raise_error;
578: End if;
579: close c_parameters;
572: ,p_last_actn => l_actn
573: ,p_rpt_flag => TRUE
574: );
575: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
576: fnd_message.set_token('PROC',l_proc);
577: fnd_message.raise_error;
578: End if;
579: close c_parameters;
580: --
573: ,p_rpt_flag => TRUE
574: );
575: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
576: fnd_message.set_token('PROC',l_proc);
577: fnd_message.raise_error;
578: End if;
579: close c_parameters;
580: --
581: -- Call process procedure with parameters for restart
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;
1039: End if;
1040: --
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;
1039: End if;
1040: --
1041: l_actn := 'Calling do_multithread...';
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;
1039: End if;
1040: --
1041: l_actn := 'Calling do_multithread...';
1042: do_multithread(errbuf => errbuf
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);
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
1073: ,p_business_group_id => p_business_group_id
1074: ) ;
1075: -- submit_all_reports;
1076: End if;
1077: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1078: fnd_message.set_token('PROCEDURE', l_proc);
1079: fnd_message.set_token('STEP', l_actn );
1080: fnd_message.raise_error;
1081: End process;
1074: ) ;
1075: -- submit_all_reports;
1076: End if;
1077: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1078: fnd_message.set_token('PROCEDURE', l_proc);
1079: fnd_message.set_token('STEP', l_actn );
1080: fnd_message.raise_error;
1081: End process;
1082: --
1075: -- submit_all_reports;
1076: End if;
1077: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1078: fnd_message.set_token('PROCEDURE', l_proc);
1079: fnd_message.set_token('STEP', l_actn );
1080: fnd_message.raise_error;
1081: End process;
1082: --
1083: -- ============================================================================
1076: End if;
1077: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1078: fnd_message.set_token('PROCEDURE', l_proc);
1079: fnd_message.set_token('STEP', l_actn );
1080: fnd_message.raise_error;
1081: End process;
1082: --
1083: -- ============================================================================
1084: -- << comp_selection_Rule >>
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));
1141: raise ben_maintain_designee_elig.g_record_error;
1142: end if;
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));
1141: raise ben_maintain_designee_elig.g_record_error;
1142: end if;
1143: close c1;
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));
1141: raise ben_maintain_designee_elig.g_record_error;
1142: end if;
1143: close c1;
1144: l_step := 20;
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);
1188: raise ben_maintain_designee_elig.g_record_error;
1189: end if;
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);
1188: raise ben_maintain_designee_elig.g_record_error;
1189: end if;
1190: return l_return;
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);
1188: raise ben_maintain_designee_elig.g_record_error;
1189: end if;
1190: return l_return;
1191: hr_utility.set_location ('Leaving '||l_proc,10);
1878: When others then
1879: rollback to process_default_enrt_savepoint;
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