APPS.HXT_RETRO_PA dependencies on HXT_RETRO_PA

Line 1: PACKAGE BODY HXT_RETRO_PA AS

1: PACKAGE BODY HXT_RETRO_PA AS
2: /* $Header: hxtrpa.pkb 120.0.12010000.2 2008/08/19 14:01:11 asrajago ship $ */
3: l_hours_per_year NUMBER(22,5) := TO_NUMBER(fnd_profile.Value('HXT_HOURS_PER_YEAR'));
4:
5: PROCEDURE retro_pa_process(o_err_buf OUT NOCOPY VARCHAR2,

Line 91: AND (errf.location LIKE 'hxt_retro_pa%'

87: -- Clean up existing transfer to PA errors for this payroll/period
88: DELETE
89: FROM hxt_errors_f errf
90: WHERE errf.tim_id = l_timecard_rec.id
91: AND (errf.location LIKE 'hxt_retro_pa%'
92: OR errf.location LIKE 'hxt_pa_user_exits.p_a_%');
93:
94: COMMIT;
95:

Line 169: l_location := 'hxt_retro_pa.retro_pa_process';

165: l_conc_error_flag := TRUE;
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;

Line 218: HXT_UTIL.DEBUG('Error in hxt_retro_pa.log_transfer_errors.');

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
222: l_location := 'hxt_retro_pa';

Line 222: l_location := 'hxt_retro_pa';

218: HXT_UTIL.DEBUG('Error in hxt_retro_pa.log_transfer_errors.');
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;

Line 1066: o_location := 'hxt_retro_pa.retro_non_ewr_transfer' || l_message;

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;
1067: o_error_text := NULL;
1068: o_system_text := SQLERRM;
1069: RETURN 1;
1070: END retro_non_ewr_transfer;

Line 1108: END HXT_RETRO_PA;

1104: RAISE g_error_log_error;
1105:
1106: END log_transfer_errors;
1107:
1108: END HXT_RETRO_PA;