DBA Data[Home] [Help]

APPS.HXT_TRAN_PA dependencies on FND_MESSAGE

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

207: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',90);
208: end if;
209: ROLLBACK;
210: l_location := 'hxt_tran_pa.transfer_timecards';
211: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
212: l_error_text := FND_MESSAGE.GET;
213: FND_MESSAGE.CLEAR;
214: l_system_text := SQLERRM;
215: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);

Line 212: l_error_text := FND_MESSAGE.GET;

208: end if;
209: ROLLBACK;
210: l_location := 'hxt_tran_pa.transfer_timecards';
211: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
212: l_error_text := FND_MESSAGE.GET;
213: FND_MESSAGE.CLEAR;
214: l_system_text := SQLERRM;
215: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
216: l_conc_error_flag := TRUE;

Line 213: FND_MESSAGE.CLEAR;

209: ROLLBACK;
210: l_location := 'hxt_tran_pa.transfer_timecards';
211: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
212: l_error_text := FND_MESSAGE.GET;
213: FND_MESSAGE.CLEAR;
214: l_system_text := SQLERRM;
215: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
216: l_conc_error_flag := TRUE;
217: END; -- timecard error block

Line 239: FND_MESSAGE.SET_NAME('HXT','HXT_39455_DET_XFER_SUCCESS');

235: end if;
236: RAISE l_no_timecards;
237: END IF;
238: o_ret_code := 0;
239: FND_MESSAGE.SET_NAME('HXT','HXT_39455_DET_XFER_SUCCESS');
240: o_err_buf := FND_MESSAGE.GET;
241: FND_MESSAGE.CLEAR;
242: HXT_UTIL.DEBUG('Time details successfully transferred!');
243: EXCEPTION

Line 240: o_err_buf := FND_MESSAGE.GET;

236: RAISE l_no_timecards;
237: END IF;
238: o_ret_code := 0;
239: FND_MESSAGE.SET_NAME('HXT','HXT_39455_DET_XFER_SUCCESS');
240: o_err_buf := FND_MESSAGE.GET;
241: FND_MESSAGE.CLEAR;
242: HXT_UTIL.DEBUG('Time details successfully transferred!');
243: EXCEPTION
244: WHEN l_conc_error THEN

Line 241: FND_MESSAGE.CLEAR;

237: END IF;
238: o_ret_code := 0;
239: FND_MESSAGE.SET_NAME('HXT','HXT_39455_DET_XFER_SUCCESS');
240: o_err_buf := FND_MESSAGE.GET;
241: FND_MESSAGE.CLEAR;
242: HXT_UTIL.DEBUG('Time details successfully transferred!');
243: EXCEPTION
244: WHEN l_conc_error THEN
245: if g_debug then

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

244: WHEN l_conc_error THEN
245: if g_debug then
246: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',130);
247: end if;
248: FND_MESSAGE.SET_NAME('HXT','HXT_39456_CHK_TCARD_ERRS');
249: o_err_buf := FND_MESSAGE.GET;
250: FND_MESSAGE.CLEAR;
251: o_ret_code := 2;
252: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');

Line 249: o_err_buf := FND_MESSAGE.GET;

245: if g_debug then
246: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',130);
247: end if;
248: FND_MESSAGE.SET_NAME('HXT','HXT_39456_CHK_TCARD_ERRS');
249: o_err_buf := FND_MESSAGE.GET;
250: FND_MESSAGE.CLEAR;
251: o_ret_code := 2;
252: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');
253: RETURN;

Line 250: FND_MESSAGE.CLEAR;

246: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',130);
247: end if;
248: FND_MESSAGE.SET_NAME('HXT','HXT_39456_CHK_TCARD_ERRS');
249: o_err_buf := FND_MESSAGE.GET;
250: FND_MESSAGE.CLEAR;
251: o_ret_code := 2;
252: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');
253: RETURN;
254: WHEN l_no_timecards THEN

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

255: if g_debug then
256: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',140);
257: end if;
258: --HXT111 o_err_buf := 'No timecards located for payroll/period';
259: FND_MESSAGE.SET_NAME('HXT','HXT_39457_NO_TCARD_4_PAY_PRD');
260: o_err_buf := FND_MESSAGE.GET;
261: FND_MESSAGE.CLEAR;
262: o_ret_code := 2;
263: HXT_UTIL.DEBUG('No timecards located for this payroll');

Line 260: o_err_buf := FND_MESSAGE.GET;

256: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',140);
257: end if;
258: --HXT111 o_err_buf := 'No timecards located for payroll/period';
259: FND_MESSAGE.SET_NAME('HXT','HXT_39457_NO_TCARD_4_PAY_PRD');
260: o_err_buf := FND_MESSAGE.GET;
261: FND_MESSAGE.CLEAR;
262: o_ret_code := 2;
263: HXT_UTIL.DEBUG('No timecards located for this payroll');
264: RETURN;

Line 261: FND_MESSAGE.CLEAR;

257: end if;
258: --HXT111 o_err_buf := 'No timecards located for payroll/period';
259: FND_MESSAGE.SET_NAME('HXT','HXT_39457_NO_TCARD_4_PAY_PRD');
260: o_err_buf := FND_MESSAGE.GET;
261: FND_MESSAGE.CLEAR;
262: o_ret_code := 2;
263: HXT_UTIL.DEBUG('No timecards located for this payroll');
264: RETURN;
265: WHEN l_no_details THEN

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

266: if g_debug then
267: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',150);
268: end if;
269: --HXT111 o_err_buf := 'No timecard details transferable';
270: FND_MESSAGE.SET_NAME('HXT','HXT_39458_NO_TCARD_DET_XFER');
271: o_err_buf := FND_MESSAGE.GET;
272: FND_MESSAGE.CLEAR;
273: o_ret_code := 0;
274: HXT_UTIL.DEBUG('No timecard details transferable');

Line 271: o_err_buf := FND_MESSAGE.GET;

267: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',150);
268: end if;
269: --HXT111 o_err_buf := 'No timecard details transferable';
270: FND_MESSAGE.SET_NAME('HXT','HXT_39458_NO_TCARD_DET_XFER');
271: o_err_buf := FND_MESSAGE.GET;
272: FND_MESSAGE.CLEAR;
273: o_ret_code := 0;
274: HXT_UTIL.DEBUG('No timecard details transferable');
275: RETURN;

Line 272: FND_MESSAGE.CLEAR;

268: end if;
269: --HXT111 o_err_buf := 'No timecard details transferable';
270: FND_MESSAGE.SET_NAME('HXT','HXT_39458_NO_TCARD_DET_XFER');
271: o_err_buf := FND_MESSAGE.GET;
272: FND_MESSAGE.CLEAR;
273: o_ret_code := 0;
274: HXT_UTIL.DEBUG('No timecard details transferable');
275: RETURN;
276: WHEN g_error_log_error THEN

Line 280: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');

276: WHEN g_error_log_error THEN
277: if g_debug then
278: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',160);
279: end if;
280: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');
281: o_err_buf := FND_MESSAGE.GET;
282: FND_MESSAGE.CLEAR;
283: HXT_UTIL.DEBUG('Error in hxt_tran_pa.log_transfer_errors.');
284: o_ret_code := 2;

Line 281: o_err_buf := FND_MESSAGE.GET;

277: if g_debug then
278: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',160);
279: end if;
280: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');
281: o_err_buf := FND_MESSAGE.GET;
282: FND_MESSAGE.CLEAR;
283: HXT_UTIL.DEBUG('Error in hxt_tran_pa.log_transfer_errors.');
284: o_ret_code := 2;
285: RETURN;

Line 282: FND_MESSAGE.CLEAR;

278: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',160);
279: end if;
280: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');
281: o_err_buf := FND_MESSAGE.GET;
282: FND_MESSAGE.CLEAR;
283: HXT_UTIL.DEBUG('Error in hxt_tran_pa.log_transfer_errors.');
284: o_ret_code := 2;
285: RETURN;
286: WHEN OTHERS THEN

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

287: if g_debug then
288: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',170);
289: end if;
290: l_location := 'hxt_tran_pa';
291: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
292: l_error_text := FND_MESSAGE.GET;
293: FND_MESSAGE.CLEAR;
294: l_system_text := SQLERRM;
295: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);

Line 292: l_error_text := FND_MESSAGE.GET;

288: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',170);
289: end if;
290: l_location := 'hxt_tran_pa';
291: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
292: l_error_text := FND_MESSAGE.GET;
293: FND_MESSAGE.CLEAR;
294: l_system_text := SQLERRM;
295: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
296: o_ret_code := 2;

Line 293: FND_MESSAGE.CLEAR;

289: end if;
290: l_location := 'hxt_tran_pa';
291: FND_MESSAGE.SET_NAME('HXT','HXT_39454_PA_XFER_ERROR');
292: l_error_text := FND_MESSAGE.GET;
293: FND_MESSAGE.CLEAR;
294: l_system_text := SQLERRM;
295: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
296: o_ret_code := 2;
297: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');

Line 297: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');

293: FND_MESSAGE.CLEAR;
294: l_system_text := SQLERRM;
295: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
296: o_ret_code := 2;
297: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');
298: o_err_buf := FND_MESSAGE.GET;
299: FND_MESSAGE.CLEAR;
300: HXT_UTIL.DEBUG('Error processing timecard for PA Transfer');
301: RETURN;

Line 298: o_err_buf := FND_MESSAGE.GET;

294: l_system_text := SQLERRM;
295: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
296: o_ret_code := 2;
297: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');
298: o_err_buf := FND_MESSAGE.GET;
299: FND_MESSAGE.CLEAR;
300: HXT_UTIL.DEBUG('Error processing timecard for PA Transfer');
301: RETURN;
302: END transfer_timecards;

Line 299: FND_MESSAGE.CLEAR;

295: l_retcode := log_transfer_errors(l_location, l_error_text, l_system_text);
296: o_ret_code := 2;
297: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');
298: o_err_buf := FND_MESSAGE.GET;
299: FND_MESSAGE.CLEAR;
300: HXT_UTIL.DEBUG('Error processing timecard for PA Transfer');
301: RETURN;
302: END transfer_timecards;
303: