DBA Data[Home] [Help]

APPS.BEN_PURGE_BCKDT_VOIDED dependencies on FND_MESSAGE

Line 101: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');

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:

Line 102: fnd_message.set_token('ID' ,to_char(p_person_id) );

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

Line 103: fnd_message.set_token('PROC',l_proc ) ;

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' ;

Line 104: p_err_message := fnd_message.get ;

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');

Line 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:

Line 109: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);

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

Line 110: fnd_message.set_token('PROC',l_proc ) ;

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' ;

Line 111: p_err_message := fnd_message.get ;

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)

Line 648: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');

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;

Line 649: fnd_message.set_token('PROC',l_proc);

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: --

Line 650: fnd_message.raise_error;

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.

Line 756: benutils.write(p_text => fnd_message.get);

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

Line 772: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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: --

Line 773: fnd_message.set_token('PROCEDURE', l_proc);

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;

Line 774: fnd_message.set_token('STEP', l_actn );

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: --

Line 775: fnd_message.raise_error;

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:

Line 1049: l_encoded_message := fnd_message.get_encoded;

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:

Line 1050: fnd_message.parse_encoded(encoded_message => l_encoded_message,

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);

Line 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));

Line 1056: g_rec.text := fnd_message.get ;

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';

Line 1072: fnd_message.raise_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: --

Line 1085: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');

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);

Line 1086: fnd_message.set_token('PROC',l_proc);

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;

Line 1087: fnd_message.set_token('BENEFIT_ACTION_ID',to_char(p_benefit_action_id));

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: --

Line 1088: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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;

Line 1089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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: --

Line 1090: fnd_message.raise_error;

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);

Line 1153: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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: --

Line 1154: fnd_message.set_token('PROCEDURE', l_proc);

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;

Line 1155: fnd_message.set_token('STEP',l_actn );

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: --

Line 1156: fnd_message.raise_error;

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: -- -----------------------------------------------------------------------------

Line 1214: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');

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;

Line 1215: fnd_message.set_token('PROC',l_proc);

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: --

Line 1216: fnd_message.raise_error;

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;