171: hr_utility.set_location ('Leaving '||l_proc,10);
172: Exception
173: When ben_batch_utils.g_record_error then
174: p_return := 'N' ;
175: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
176: fnd_message.set_token('ID' ,to_char(p_person_id) );
177: fnd_message.set_token('PROC',l_proc ) ;
178: p_err_message := fnd_message.get ;
179:
172: Exception
173: When ben_batch_utils.g_record_error then
174: p_return := 'N' ;
175: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
176: fnd_message.set_token('ID' ,to_char(p_person_id) );
177: fnd_message.set_token('PROC',l_proc ) ;
178: p_err_message := fnd_message.get ;
179:
180: When value_exception then
173: When ben_batch_utils.g_record_error then
174: p_return := 'N' ;
175: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
176: fnd_message.set_token('ID' ,to_char(p_person_id) );
177: fnd_message.set_token('PROC',l_proc ) ;
178: p_err_message := fnd_message.get ;
179:
180: When value_exception then
181: p_return := 'N' ;
174: p_return := 'N' ;
175: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
176: fnd_message.set_token('ID' ,to_char(p_person_id) );
177: fnd_message.set_token('PROC',l_proc ) ;
178: p_err_message := fnd_message.get ;
179:
180: When value_exception then
181: p_return := 'N' ;
182: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
178: p_err_message := fnd_message.get ;
179:
180: When value_exception then
181: p_return := 'N' ;
182: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
183: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
184: fnd_message.set_token('PROC',l_proc ) ;
185: p_err_message := fnd_message.get ;
186:
179:
180: When value_exception then
181: p_return := 'N' ;
182: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
183: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
184: fnd_message.set_token('PROC',l_proc ) ;
185: p_err_message := fnd_message.get ;
186:
187: when others then
180: When value_exception then
181: p_return := 'N' ;
182: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
183: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
184: fnd_message.set_token('PROC',l_proc ) ;
185: p_err_message := fnd_message.get ;
186:
187: when others then
188: p_return := 'N' ;
181: p_return := 'N' ;
182: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
183: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
184: fnd_message.set_token('PROC',l_proc ) ;
185: p_err_message := fnd_message.get ;
186:
187: when others then
188: p_return := 'N' ;
189: p_err_message := 'A unhandled exception has been raised while processing Person : '||to_char(p_person_id)
411: g_persons_errored := g_persons_errored + 1;
412:
413: If (g_persons_errored > g_max_errors_allowed) then
414: hr_utility.set_location ('Person errors exceeds max allowed',778);
415: fnd_message.raise_error;
416: End if;
417: End;
418: End loop;
419: Else
420: --
421: l_actn := 'Erroring out nocopy since not person is found in range...' ;
422: --
423: hr_utility.set_location ('BEN_91709_PER_NOT_FND_IN_RNG',778);
424: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
425: fnd_message.raise_error;
426: End if;
427: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
428: End loop;
421: l_actn := 'Erroring out nocopy since not person is found in range...' ;
422: --
423: hr_utility.set_location ('BEN_91709_PER_NOT_FND_IN_RNG',778);
424: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
425: fnd_message.raise_error;
426: End if;
427: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
428: End loop;
429: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
446: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
447: ,p_num_pers_errored => g_persons_errored
448: );
449: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
450: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
451: fnd_message.set_token('PROCEDURE', l_proc);
452: fnd_message.set_token('STEP',l_actn );
453: fnd_message.raise_error;
454: End do_multithread;
447: ,p_num_pers_errored => g_persons_errored
448: );
449: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
450: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
451: fnd_message.set_token('PROCEDURE', l_proc);
452: fnd_message.set_token('STEP',l_actn );
453: fnd_message.raise_error;
454: End do_multithread;
455: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
448: );
449: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
450: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
451: fnd_message.set_token('PROCEDURE', l_proc);
452: fnd_message.set_token('STEP',l_actn );
453: fnd_message.raise_error;
454: End do_multithread;
455: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
456: -- << Procedure: Restart >>
449: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
450: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
451: fnd_message.set_token('PROCEDURE', l_proc);
452: fnd_message.set_token('STEP',l_actn );
453: fnd_message.raise_error;
454: End do_multithread;
455: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
456: -- << Procedure: Restart >>
457: -- *****************************************************************
502: ,p_last_actn => l_actn
503: ,p_rpt_flag => TRUE
504: );
505: hr_utility.set_location ('BEN_91710_RESTRT_PARMS_NOT_FND',778);
506: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
507: fnd_message.raise_error;
508: End if;
509: close c_parameters;
510: --
503: ,p_rpt_flag => TRUE
504: );
505: hr_utility.set_location ('BEN_91710_RESTRT_PARMS_NOT_FND',778);
506: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
507: fnd_message.raise_error;
508: End if;
509: close c_parameters;
510: --
511: -- Call process procedure with parameters for restart
945:
946: Ben_batch_utils.write(p_text =>
947: '<< No Person was selected for Participant Premiums with above selection criteria >>' );
948: -- hr_utility.set_location ('BEN_91769_NOONE_TO_PROCESS',778);
949: -- fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
950: -- fnd_message.raise_error;
951: End if;
952:
953: if (l_num_range <> 0 ) then
946: Ben_batch_utils.write(p_text =>
947: '<< No Person was selected for Participant Premiums with above selection criteria >>' );
948: -- hr_utility.set_location ('BEN_91769_NOONE_TO_PROCESS',778);
949: -- fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
950: -- fnd_message.raise_error;
951: End if;
952:
953: if (l_num_range <> 0 ) then
954: l_actn := 'Calling do_multithread...';
1022: ben_batch_utils.rpt_error(p_proc => l_proc
1023: ,p_last_actn => l_actn
1024: ,p_rpt_flag => TRUE );
1025: --
1026: benutils.write(p_text => fnd_message.get);
1027: benutils.write(p_text => sqlerrm);
1028: benutils.write(p_text => 'Big Error Occured');
1029: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1030: If (l_num_range > 0) then
1034: ,p_business_group_id => p_business_group_id
1035: ) ;
1036: End if;
1037: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',689);
1038: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1039: fnd_message.set_token('PROCEDURE', l_proc);
1040: fnd_message.set_token('STEP', l_actn );
1041: fnd_message.raise_error;
1042: End process;
1035: ) ;
1036: End if;
1037: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',689);
1038: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1039: fnd_message.set_token('PROCEDURE', l_proc);
1040: fnd_message.set_token('STEP', l_actn );
1041: fnd_message.raise_error;
1042: End process;
1043: --
1036: End if;
1037: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',689);
1038: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1039: fnd_message.set_token('PROCEDURE', l_proc);
1040: fnd_message.set_token('STEP', l_actn );
1041: fnd_message.raise_error;
1042: End process;
1043: --
1044: end ben_premium_concurrent; -- End of Package.
1037: hr_utility.set_location ('HR_6153_ALL_PROCEDURE_FAIL',689);
1038: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1039: fnd_message.set_token('PROCEDURE', l_proc);
1040: fnd_message.set_token('STEP', l_actn );
1041: fnd_message.raise_error;
1042: End process;
1043: --
1044: end ben_premium_concurrent; -- End of Package.