252: When others then
253: g_persons_errored := g_persons_errored + 1;
254: If (g_persons_errored > g_max_errors_allowed) then
255: hr_utility.set_location ('Errors received exceeds max allowed',05);
256: fnd_message.raise_error;
257: End if;
258: End;
259: End loop;
260: Else
260: Else
261: --
262: l_actn := 'Erroring out nocopy since not person is found in range...' ;
263: hr_utility.set_location ('BEN_92452_PREM_NOT_IN_RNG',05);
264: fnd_message.set_name('BEN','BEN_92452_PREM_NOT_IN_RNG');
265: fnd_message.set_token('PROC', l_proc);
266: fnd_message.raise_error;
267: End if;
268:
261: --
262: l_actn := 'Erroring out nocopy since not person is found in range...' ;
263: hr_utility.set_location ('BEN_92452_PREM_NOT_IN_RNG',05);
264: fnd_message.set_name('BEN','BEN_92452_PREM_NOT_IN_RNG');
265: fnd_message.set_token('PROC', l_proc);
266: fnd_message.raise_error;
267: End if;
268:
269: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
262: l_actn := 'Erroring out nocopy since not person is found in range...' ;
263: hr_utility.set_location ('BEN_92452_PREM_NOT_IN_RNG',05);
264: fnd_message.set_name('BEN','BEN_92452_PREM_NOT_IN_RNG');
265: fnd_message.set_token('PROC', l_proc);
266: fnd_message.raise_error;
267: End if;
268:
269: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
270: End loop;
287: ,p_num_pers_errored => g_persons_errored
288: );
289: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
290: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',05);
291: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
292: fnd_message.set_token('PROCEDURE', l_proc);
293: fnd_message.set_token('STEP',l_actn );
294: fnd_message.raise_error;
295: End do_multithread;
288: );
289: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
290: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',05);
291: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
292: fnd_message.set_token('PROCEDURE', l_proc);
293: fnd_message.set_token('STEP',l_actn );
294: fnd_message.raise_error;
295: End do_multithread;
296: -- *************************************************************************
289: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
290: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',05);
291: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
292: fnd_message.set_token('PROCEDURE', l_proc);
293: fnd_message.set_token('STEP',l_actn );
294: fnd_message.raise_error;
295: End do_multithread;
296: -- *************************************************************************
297: -- * << Procedure: Process >>
290: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',05);
291: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
292: fnd_message.set_token('PROCEDURE', l_proc);
293: fnd_message.set_token('STEP',l_actn );
294: fnd_message.raise_error;
295: End do_multithread;
296: -- *************************************************************************
297: -- * << Procedure: Process >>
298: -- *************************************************************************
620: -- noone to process.
621:
622: Ben_batch_utils.write(p_text =>
623: '<< No Process Premiums were selected with above selection criteria >>' );
624: --fnd_message.set_name('BEN','BEN_92453_NO_PREMS_TO_PROCESS');
625: --fnd_message.raise_error;
626: End if;
627:
628: if (l_num_range <> 0 ) then
621:
622: Ben_batch_utils.write(p_text =>
623: '<< No Process Premiums were selected with above selection criteria >>' );
624: --fnd_message.set_name('BEN','BEN_92453_NO_PREMS_TO_PROCESS');
625: --fnd_message.raise_error;
626: End if;
627:
628: if (l_num_range <> 0 ) then
629:
656: ben_batch_utils.rpt_error(p_proc => l_proc
657: ,p_last_actn => l_actn
658: ,p_rpt_flag => TRUE );
659: --
660: benutils.write(p_text => fnd_message.get);
661: benutils.write(p_text => sqlerrm);
662: benutils.write(p_text => 'Big Error Occured');
663: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
664: If (l_num_range > 0) then
668: ,p_business_group_id => p_business_group_id
669: ) ;
670: End if;
671: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',25);
672: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
673: fnd_message.set_token('PROCEDURE', l_proc);
674: fnd_message.set_token('STEP', l_actn );
675: fnd_message.raise_error;
676: End process;
669: ) ;
670: End if;
671: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',25);
672: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
673: fnd_message.set_token('PROCEDURE', l_proc);
674: fnd_message.set_token('STEP', l_actn );
675: fnd_message.raise_error;
676: End process;
677: --
670: End if;
671: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',25);
672: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
673: fnd_message.set_token('PROCEDURE', l_proc);
674: fnd_message.set_token('STEP', l_actn );
675: fnd_message.raise_error;
676: End process;
677: --
678: end ben_premium_plan_concurrent; -- End of Package.
671: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',25);
672: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
673: fnd_message.set_token('PROCEDURE', l_proc);
674: fnd_message.set_token('STEP', l_actn );
675: fnd_message.raise_error;
676: End process;
677: --
678: end ben_premium_plan_concurrent; -- End of Package.