97: hr_utility.set_location ('Leaving '||l_proc,10);
98: Exception
99: When ben_batch_utils.g_record_error then
100: p_return := 'N' ;
101: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
102: fnd_message.set_token('ID' ,to_char(p_person_id) );
103: fnd_message.set_token('PROC',l_proc ) ;
104: p_err_message := fnd_message.get ;
105:
98: Exception
99: When ben_batch_utils.g_record_error then
100: p_return := 'N' ;
101: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
102: fnd_message.set_token('ID' ,to_char(p_person_id) );
103: fnd_message.set_token('PROC',l_proc ) ;
104: p_err_message := fnd_message.get ;
105:
106: When value_exception then
99: When ben_batch_utils.g_record_error then
100: p_return := 'N' ;
101: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
102: fnd_message.set_token('ID' ,to_char(p_person_id) );
103: fnd_message.set_token('PROC',l_proc ) ;
104: p_err_message := fnd_message.get ;
105:
106: When value_exception then
107: p_return := 'N' ;
100: p_return := 'N' ;
101: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
102: fnd_message.set_token('ID' ,to_char(p_person_id) );
103: fnd_message.set_token('PROC',l_proc ) ;
104: p_err_message := fnd_message.get ;
105:
106: When value_exception then
107: p_return := 'N' ;
108: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
104: p_err_message := fnd_message.get ;
105:
106: When value_exception then
107: p_return := 'N' ;
108: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
109: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
110: fnd_message.set_token('PROC',l_proc ) ;
111: p_err_message := fnd_message.get ;
112:
105:
106: When value_exception then
107: p_return := 'N' ;
108: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
109: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
110: fnd_message.set_token('PROC',l_proc ) ;
111: p_err_message := fnd_message.get ;
112:
113: when others then
106: When value_exception then
107: p_return := 'N' ;
108: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
109: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
110: fnd_message.set_token('PROC',l_proc ) ;
111: p_err_message := fnd_message.get ;
112:
113: when others then
114: p_return := 'N' ;
107: p_return := 'N' ;
108: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
109: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
110: fnd_message.set_token('PROC',l_proc ) ;
111: p_err_message := fnd_message.get ;
112:
113: when others then
114: p_return := 'N' ;
115: p_err_message := 'Unhandled exception while processing Person : '||to_char(p_person_id)
644: --
645: ben_batch_utils.write(p_text =>
646: 'No person got selected with above selection criteria.');
647: --
648: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
649: fnd_message.set_token('PROC',l_proc);
650: fnd_message.raise_error;
651: --
652: end if;
645: ben_batch_utils.write(p_text =>
646: 'No person got selected with above selection criteria.');
647: --
648: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
649: fnd_message.set_token('PROC',l_proc);
650: fnd_message.raise_error;
651: --
652: end if;
653: --
646: 'No person got selected with above selection criteria.');
647: --
648: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
649: fnd_message.set_token('PROC',l_proc);
650: fnd_message.raise_error;
651: --
652: end if;
653: --
654: -- Carry on with the master. This will ensure that the master finishes last.
752: ben_batch_utils.rpt_error(p_proc => l_proc
753: ,p_last_actn => l_actn
754: ,p_rpt_flag => TRUE);
755: --
756: benutils.write(p_text => fnd_message.get);
757: benutils.write(p_text => sqlerrm);
758: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
759: --
760: if l_num_ranges > 0 then
768: --submit_all_reports(p_audit_log => 'N');
769: --
770: end if;
771: --
772: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
773: fnd_message.set_token('PROCEDURE', l_proc);
774: fnd_message.set_token('STEP', l_actn );
775: fnd_message.raise_error;
776: --
769: --
770: end if;
771: --
772: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
773: fnd_message.set_token('PROCEDURE', l_proc);
774: fnd_message.set_token('STEP', l_actn );
775: fnd_message.raise_error;
776: --
777: end process;
770: end if;
771: --
772: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
773: fnd_message.set_token('PROCEDURE', l_proc);
774: fnd_message.set_token('STEP', l_actn );
775: fnd_message.raise_error;
776: --
777: end process;
778: --
771: --
772: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
773: fnd_message.set_token('PROCEDURE', l_proc);
774: fnd_message.set_token('STEP', l_actn );
775: fnd_message.raise_error;
776: --
777: end process;
778: --
779:
1045: ben_env_object.get(p_rec => l_env);
1046: ben_person_object.get_object(p_person_id => g_cache_per_proc(l_cnt).person_id,
1047: p_rec => l_per_rec);
1048: --
1049: l_encoded_message := fnd_message.get_encoded;
1050: fnd_message.parse_encoded(encoded_message => l_encoded_message,
1051: app_short_name => l_app_short_name,
1052: message_name => l_message_name);
1053:
1046: ben_person_object.get_object(p_person_id => g_cache_per_proc(l_cnt).person_id,
1047: p_rec => l_per_rec);
1048: --
1049: l_encoded_message := fnd_message.get_encoded;
1050: fnd_message.parse_encoded(encoded_message => l_encoded_message,
1051: app_short_name => l_app_short_name,
1052: message_name => l_message_name);
1053:
1054: fnd_message.set_encoded(encoded_message => l_encoded_message);
1050: fnd_message.parse_encoded(encoded_message => l_encoded_message,
1051: app_short_name => l_app_short_name,
1052: message_name => l_message_name);
1053:
1054: fnd_message.set_encoded(encoded_message => l_encoded_message);
1055: --
1056: g_rec.text := fnd_message.get ;
1057: --
1058: g_rec.error_message_code := nvl(l_message_name , nvl(g_rec.error_message_code,sqlcode));
1052: message_name => l_message_name);
1053:
1054: fnd_message.set_encoded(encoded_message => l_encoded_message);
1055: --
1056: g_rec.text := fnd_message.get ;
1057: --
1058: g_rec.error_message_code := nvl(l_message_name , nvl(g_rec.error_message_code,sqlcode));
1059: g_rec.text := nvl(g_rec.text , nvl(g_rec.text,substr(sqlerrm,1,400)) );
1060: g_rec.rep_typ_cd := 'ERROR';
1068: --
1069: g_persons_errored := g_persons_errored + 1;
1070: --
1071: if g_persons_errored > g_max_person_err then
1072: fnd_message.raise_error;
1073: end if;
1074: --
1075: end;
1076: --
1081: hr_utility.set_location('No records found. Erroring out.', 10);
1082: --
1083: l_actn := 'Reporting error since there is no record found';
1084: --
1085: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1086: fnd_message.set_token('PROC',l_proc);
1087: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1088: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1082: --
1083: l_actn := 'Reporting error since there is no record found';
1084: --
1085: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1086: fnd_message.set_token('PROC',l_proc);
1087: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1088: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1090: fnd_message.raise_error;
1083: l_actn := 'Reporting error since there is no record found';
1084: --
1085: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1086: fnd_message.set_token('PROC',l_proc);
1087: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1088: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1090: fnd_message.raise_error;
1091: --
1084: --
1085: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1086: fnd_message.set_token('PROC',l_proc);
1087: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1088: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1090: fnd_message.raise_error;
1091: --
1092: end if;
1085: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');
1086: fnd_message.set_token('PROC',l_proc);
1087: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1088: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1090: fnd_message.raise_error;
1091: --
1092: end if;
1093: --
1086: fnd_message.set_token('PROC',l_proc);
1087: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));
1088: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1090: fnd_message.raise_error;
1091: --
1092: end if;
1093: --
1094: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1149: ,p_num_pers_errored => g_persons_errored);
1150: --
1151: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1152: --
1153: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1154: fnd_message.set_token('PROCEDURE', l_proc);
1155: fnd_message.set_token('STEP',l_actn );
1156: fnd_message.raise_error;
1157: --
1150: --
1151: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1152: --
1153: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1154: fnd_message.set_token('PROCEDURE', l_proc);
1155: fnd_message.set_token('STEP',l_actn );
1156: fnd_message.raise_error;
1157: --
1158: end do_multithread;
1151: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1152: --
1153: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1154: fnd_message.set_token('PROCEDURE', l_proc);
1155: fnd_message.set_token('STEP',l_actn );
1156: fnd_message.raise_error;
1157: --
1158: end do_multithread;
1159: --
1152: --
1153: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1154: fnd_message.set_token('PROCEDURE', l_proc);
1155: fnd_message.set_token('STEP',l_actn );
1156: fnd_message.raise_error;
1157: --
1158: end do_multithread;
1159: --
1160: -- -----------------------------------------------------------------------------
1210: --
1211: if c_parameters%notfound then
1212: --
1213: close c_parameters;
1214: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
1215: fnd_message.set_token('PROC',l_proc);
1216: fnd_message.raise_error;
1217: --
1218: end if;
1211: if c_parameters%notfound then
1212: --
1213: close c_parameters;
1214: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
1215: fnd_message.set_token('PROC',l_proc);
1216: fnd_message.raise_error;
1217: --
1218: end if;
1219: --
1212: --
1213: close c_parameters;
1214: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
1215: fnd_message.set_token('PROC',l_proc);
1216: fnd_message.raise_error;
1217: --
1218: end if;
1219: --
1220: close c_parameters;