DBA Data[Home] [Help]

APPS.HXT_RETRO_PA dependencies on FND_MESSAGE

Line 170: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');

166: -- Other errors
167: WHEN OTHERS THEN
168: ROLLBACK;
169: l_location := 'hxt_retro_pa.retro_pa_process';
170: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
171: l_error_text := FND_MESSAGE.GET;
172: FND_MESSAGE.CLEAR;
173: l_system_text := SQLERRM;
174: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);

Line 171: l_error_text := FND_MESSAGE.GET;

167: WHEN OTHERS THEN
168: ROLLBACK;
169: l_location := 'hxt_retro_pa.retro_pa_process';
170: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
171: l_error_text := FND_MESSAGE.GET;
172: FND_MESSAGE.CLEAR;
173: l_system_text := SQLERRM;
174: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
175: l_conc_error_flag := TRUE;

Line 172: FND_MESSAGE.CLEAR;

168: ROLLBACK;
169: l_location := 'hxt_retro_pa.retro_pa_process';
170: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
171: l_error_text := FND_MESSAGE.GET;
172: FND_MESSAGE.CLEAR;
173: l_system_text := SQLERRM;
174: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
175: l_conc_error_flag := TRUE;
176: END; -- timecard error block

Line 194: FND_MESSAGE.SET_NAME('HXT','HXT_39456_CHK_TCARD_ERRS');

190: HXT_UTIL.DEBUG('Retro details successfully transferred!');
191:
192: EXCEPTION
193: WHEN l_conc_error THEN
194: FND_MESSAGE.SET_NAME('HXT','HXT_39456_CHK_TCARD_ERRS');
195: o_err_buf := FND_MESSAGE.GET;
196: FND_MESSAGE.CLEAR;
197: o_ret_code := 2;
198: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');

Line 195: o_err_buf := FND_MESSAGE.GET;

191:
192: EXCEPTION
193: WHEN l_conc_error THEN
194: FND_MESSAGE.SET_NAME('HXT','HXT_39456_CHK_TCARD_ERRS');
195: o_err_buf := FND_MESSAGE.GET;
196: FND_MESSAGE.CLEAR;
197: o_ret_code := 2;
198: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');
199: RETURN;

Line 196: FND_MESSAGE.CLEAR;

192: EXCEPTION
193: WHEN l_conc_error THEN
194: FND_MESSAGE.SET_NAME('HXT','HXT_39456_CHK_TCARD_ERRS');
195: o_err_buf := FND_MESSAGE.GET;
196: FND_MESSAGE.CLEAR;
197: o_ret_code := 2;
198: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');
199: RETURN;
200: WHEN l_no_timecards THEN

Line 201: FND_MESSAGE.SET_NAME('HXT','HXT_39457_NO_TCARD_4_PAY_PRD');

197: o_ret_code := 2;
198: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');
199: RETURN;
200: WHEN l_no_timecards THEN
201: FND_MESSAGE.SET_NAME('HXT','HXT_39457_NO_TCARD_4_PAY_PRD');
202: o_err_buf := FND_MESSAGE.GET;
203: FND_MESSAGE.CLEAR;
204: o_ret_code := 2;
205: HXT_UTIL.DEBUG('No timecards located for this payroll');

Line 202: o_err_buf := FND_MESSAGE.GET;

198: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');
199: RETURN;
200: WHEN l_no_timecards THEN
201: FND_MESSAGE.SET_NAME('HXT','HXT_39457_NO_TCARD_4_PAY_PRD');
202: o_err_buf := FND_MESSAGE.GET;
203: FND_MESSAGE.CLEAR;
204: o_ret_code := 2;
205: HXT_UTIL.DEBUG('No timecards located for this payroll');
206: RETURN;

Line 203: FND_MESSAGE.CLEAR;

199: RETURN;
200: WHEN l_no_timecards THEN
201: FND_MESSAGE.SET_NAME('HXT','HXT_39457_NO_TCARD_4_PAY_PRD');
202: o_err_buf := FND_MESSAGE.GET;
203: FND_MESSAGE.CLEAR;
204: o_ret_code := 2;
205: HXT_UTIL.DEBUG('No timecards located for this payroll');
206: RETURN;
207: WHEN l_no_details THEN

Line 208: FND_MESSAGE.SET_NAME('HXT','HXT_39458_NO_TCARD_DET_XFER');

204: o_ret_code := 2;
205: HXT_UTIL.DEBUG('No timecards located for this payroll');
206: RETURN;
207: WHEN l_no_details THEN
208: FND_MESSAGE.SET_NAME('HXT','HXT_39458_NO_TCARD_DET_XFER');
209: o_err_buf := FND_MESSAGE.GET;
210: FND_MESSAGE.CLEAR;
211: o_ret_code := 0;
212: HXT_UTIL.DEBUG('No timecard details transferable');

Line 209: o_err_buf := FND_MESSAGE.GET;

205: HXT_UTIL.DEBUG('No timecards located for this payroll');
206: RETURN;
207: WHEN l_no_details THEN
208: FND_MESSAGE.SET_NAME('HXT','HXT_39458_NO_TCARD_DET_XFER');
209: o_err_buf := FND_MESSAGE.GET;
210: FND_MESSAGE.CLEAR;
211: o_ret_code := 0;
212: HXT_UTIL.DEBUG('No timecard details transferable');
213: RETURN;

Line 210: FND_MESSAGE.CLEAR;

206: RETURN;
207: WHEN l_no_details THEN
208: FND_MESSAGE.SET_NAME('HXT','HXT_39458_NO_TCARD_DET_XFER');
209: o_err_buf := FND_MESSAGE.GET;
210: FND_MESSAGE.CLEAR;
211: o_ret_code := 0;
212: HXT_UTIL.DEBUG('No timecard details transferable');
213: RETURN;
214: WHEN g_error_log_error THEN

Line 215: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');

211: o_ret_code := 0;
212: HXT_UTIL.DEBUG('No timecard details transferable');
213: RETURN;
214: WHEN g_error_log_error THEN
215: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');
216: o_err_buf := FND_MESSAGE.GET;
217: FND_MESSAGE.CLEAR;
218: HXT_UTIL.DEBUG('Error in hxt_retro_pa.log_transfer_errors.');
219: o_ret_code := 2;

Line 216: o_err_buf := FND_MESSAGE.GET;

212: HXT_UTIL.DEBUG('No timecard details transferable');
213: RETURN;
214: WHEN g_error_log_error THEN
215: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');
216: o_err_buf := FND_MESSAGE.GET;
217: FND_MESSAGE.CLEAR;
218: HXT_UTIL.DEBUG('Error in hxt_retro_pa.log_transfer_errors.');
219: o_ret_code := 2;
220: RETURN;

Line 217: FND_MESSAGE.CLEAR;

213: RETURN;
214: WHEN g_error_log_error THEN
215: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');
216: o_err_buf := FND_MESSAGE.GET;
217: FND_MESSAGE.CLEAR;
218: HXT_UTIL.DEBUG('Error in hxt_retro_pa.log_transfer_errors.');
219: o_ret_code := 2;
220: RETURN;
221: WHEN OTHERS THEN

Line 223: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');

219: o_ret_code := 2;
220: RETURN;
221: WHEN OTHERS THEN
222: l_location := 'hxt_retro_pa';
223: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
224: l_error_text := FND_MESSAGE.GET;
225: FND_MESSAGE.CLEAR;
226: l_system_text := SQLERRM;
227: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);

Line 224: l_error_text := FND_MESSAGE.GET;

220: RETURN;
221: WHEN OTHERS THEN
222: l_location := 'hxt_retro_pa';
223: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
224: l_error_text := FND_MESSAGE.GET;
225: FND_MESSAGE.CLEAR;
226: l_system_text := SQLERRM;
227: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
228: o_ret_code := 2;

Line 225: FND_MESSAGE.CLEAR;

221: WHEN OTHERS THEN
222: l_location := 'hxt_retro_pa';
223: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
224: l_error_text := FND_MESSAGE.GET;
225: FND_MESSAGE.CLEAR;
226: l_system_text := SQLERRM;
227: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
228: o_ret_code := 2;
229: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');

Line 229: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');

225: FND_MESSAGE.CLEAR;
226: l_system_text := SQLERRM;
227: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
228: o_ret_code := 2;
229: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');
230: o_err_buf := FND_MESSAGE.GET;
231: FND_MESSAGE.CLEAR;
232: HXT_UTIL.DEBUG('Error processing timecard for PA Transfer');
233: RETURN;

Line 230: o_err_buf := FND_MESSAGE.GET;

226: l_system_text := SQLERRM;
227: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
228: o_ret_code := 2;
229: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');
230: o_err_buf := FND_MESSAGE.GET;
231: FND_MESSAGE.CLEAR;
232: HXT_UTIL.DEBUG('Error processing timecard for PA Transfer');
233: RETURN;
234: END retro_pa_process;

Line 231: FND_MESSAGE.CLEAR;

227: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
228: o_ret_code := 2;
229: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');
230: o_err_buf := FND_MESSAGE.GET;
231: FND_MESSAGE.CLEAR;
232: HXT_UTIL.DEBUG('Error processing timecard for PA Transfer');
233: RETURN;
234: END retro_pa_process;
235: /************************************************************************************************

Line 1048: FND_MESSAGE.SET_NAME('HXT','HXT_39461_SEND_ADJ_TRANS');

1044: EXCEPTION
1045: WHEN l_transfer_error THEN
1046: RETURN 1;
1047: WHEN l_adjusting_error THEN
1048: FND_MESSAGE.SET_NAME('HXT','HXT_39461_SEND_ADJ_TRANS');
1049: o_location := FND_MESSAGE.GET;
1050: FND_MESSAGE.CLEAR;
1051: o_system_text := NULL;
1052: RETURN 1;

Line 1049: o_location := FND_MESSAGE.GET;

1045: WHEN l_transfer_error THEN
1046: RETURN 1;
1047: WHEN l_adjusting_error THEN
1048: FND_MESSAGE.SET_NAME('HXT','HXT_39461_SEND_ADJ_TRANS');
1049: o_location := FND_MESSAGE.GET;
1050: FND_MESSAGE.CLEAR;
1051: o_system_text := NULL;
1052: RETURN 1;
1053: WHEN l_retro_error THEN

Line 1050: FND_MESSAGE.CLEAR;

1046: RETURN 1;
1047: WHEN l_adjusting_error THEN
1048: FND_MESSAGE.SET_NAME('HXT','HXT_39461_SEND_ADJ_TRANS');
1049: o_location := FND_MESSAGE.GET;
1050: FND_MESSAGE.CLEAR;
1051: o_system_text := NULL;
1052: RETURN 1;
1053: WHEN l_retro_error THEN
1054: FND_MESSAGE.SET_NAME('HXT','HXT_39462_SEND_RETRO_TRANS');

Line 1054: FND_MESSAGE.SET_NAME('HXT','HXT_39462_SEND_RETRO_TRANS');

1050: FND_MESSAGE.CLEAR;
1051: o_system_text := NULL;
1052: RETURN 1;
1053: WHEN l_retro_error THEN
1054: FND_MESSAGE.SET_NAME('HXT','HXT_39462_SEND_RETRO_TRANS');
1055: o_location := FND_MESSAGE.GET;
1056: FND_MESSAGE.CLEAR;
1057: o_system_text := NULL;
1058: RETURN 1;

Line 1055: o_location := FND_MESSAGE.GET;

1051: o_system_text := NULL;
1052: RETURN 1;
1053: WHEN l_retro_error THEN
1054: FND_MESSAGE.SET_NAME('HXT','HXT_39462_SEND_RETRO_TRANS');
1055: o_location := FND_MESSAGE.GET;
1056: FND_MESSAGE.CLEAR;
1057: o_system_text := NULL;
1058: RETURN 1;
1059: WHEN l_backout_error THEN

Line 1056: FND_MESSAGE.CLEAR;

1052: RETURN 1;
1053: WHEN l_retro_error THEN
1054: FND_MESSAGE.SET_NAME('HXT','HXT_39462_SEND_RETRO_TRANS');
1055: o_location := FND_MESSAGE.GET;
1056: FND_MESSAGE.CLEAR;
1057: o_system_text := NULL;
1058: RETURN 1;
1059: WHEN l_backout_error THEN
1060: FND_MESSAGE.SET_NAME('HXT','HXT_39463_SEND_BACK_TRANS');

Line 1060: FND_MESSAGE.SET_NAME('HXT','HXT_39463_SEND_BACK_TRANS');

1056: FND_MESSAGE.CLEAR;
1057: o_system_text := NULL;
1058: RETURN 1;
1059: WHEN l_backout_error THEN
1060: FND_MESSAGE.SET_NAME('HXT','HXT_39463_SEND_BACK_TRANS');
1061: o_location := FND_MESSAGE.GET;
1062: FND_MESSAGE.CLEAR;
1063: o_system_text := NULL;
1064: RETURN 1;

Line 1061: o_location := FND_MESSAGE.GET;

1057: o_system_text := NULL;
1058: RETURN 1;
1059: WHEN l_backout_error THEN
1060: FND_MESSAGE.SET_NAME('HXT','HXT_39463_SEND_BACK_TRANS');
1061: o_location := FND_MESSAGE.GET;
1062: FND_MESSAGE.CLEAR;
1063: o_system_text := NULL;
1064: RETURN 1;
1065: WHEN OTHERS THEN

Line 1062: FND_MESSAGE.CLEAR;

1058: RETURN 1;
1059: WHEN l_backout_error THEN
1060: FND_MESSAGE.SET_NAME('HXT','HXT_39463_SEND_BACK_TRANS');
1061: o_location := FND_MESSAGE.GET;
1062: FND_MESSAGE.CLEAR;
1063: o_system_text := NULL;
1064: RETURN 1;
1065: WHEN OTHERS THEN
1066: o_location := 'hxt_retro_pa.retro_non_ewr_transfer' || l_message;