eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_RETRO_PROCESS dependencies on HXT_BATCH_PROCESS

Line 117: l_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;

113: l_cnt BINARY_INTEGER;
114: l_count BINARY_INTEGER;
115: l_loop_index BINARY_INTEGER;
116: l_loop_flag BOOLEAN;
117: l_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
118: p_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
119: l_del_empty_batches HXT_BATCH_PROCESS.DEL_EMPTY_BATCHES_TYPE_TABLE;
120:
121: /********Bug: 4620315 **********/

Line 118: p_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;

114: l_count BINARY_INTEGER;
115: l_loop_index BINARY_INTEGER;
116: l_loop_flag BOOLEAN;
117: l_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
118: p_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
119: l_del_empty_batches HXT_BATCH_PROCESS.DEL_EMPTY_BATCHES_TYPE_TABLE;
120:
121: /********Bug: 4620315 **********/
122:

Line 119: l_del_empty_batches HXT_BATCH_PROCESS.DEL_EMPTY_BATCHES_TYPE_TABLE;

115: l_loop_index BINARY_INTEGER;
116: l_loop_flag BOOLEAN;
117: l_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
118: p_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
119: l_del_empty_batches HXT_BATCH_PROCESS.DEL_EMPTY_BATCHES_TYPE_TABLE;
120:
121: /********Bug: 4620315 **********/
122:
123: BEGIN

Line 244: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

240: -- Check for a valid status code
241: IF (batch_rec.batch_status = 'VT') THEN
242: l_final_valid_retcode := 2;
243: FND_MESSAGE.SET_NAME('HXT','HXT_39348_TC_VAL_NOT_REPROC'); --HXT111
244: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
245: 'VE',
246: '',
247: l_return);
248: ELSE

Line 254: HXT_BATCH_PROCESS.Del_Prior_Errors(batch_rec.batch_id);

250: -- Validate batch, status:0=Normal, 1=Warning, 2=Stop Level Data Error, 3=System
251: --
252: --HXT_UTIL.DEBUG('Begin timecard validation.');
253: -- Delete prior errors for this batch
254: HXT_BATCH_PROCESS.Del_Prior_Errors(batch_rec.batch_id);
255: HXT_RETRO_VAL.Val_Retro_Timecard(batch_rec.batch_id,
256: batch_rec.tim_id,
257: l_valid_retcode,
258: p_merge_flag,

Line 287: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VV');

283: END IF;
284: -- Successful Validation, Set batch to ready Status
285: IF l_valid_retcode = 0 then
286: --HXT_UTIL.DEBUG('Successful timecard validation.');
287: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VV');
288: END IF;
289: -- set status to Warning and lets user know we have a TAMS/O
290: -- User Level Data Error for this batch
291: IF l_valid_retcode = 1 then

Line 293: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VW');

289: -- set status to Warning and lets user know we have a TAMS/O
290: -- User Level Data Error for this batch
291: IF l_valid_retcode = 1 then
292: --HXT_UTIL.DEBUG('Timecard validation warnings.');
293: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VW');
294: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); --HXT111
295: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
296: 'W',
297: '',

Line 295: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

291: IF l_valid_retcode = 1 then
292: --HXT_UTIL.DEBUG('Timecard validation warnings.');
293: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VW');
294: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); --HXT111
295: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
296: 'W',
297: '',
298: l_return);
299: END IF;

Line 302: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');

298: l_return);
299: END IF;
300: IF l_valid_retcode > 2 THEN
301: --HXT_UTIL.DEBUG('Timecard validation errors.');
302: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');
303: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS');
304: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
305: 'VE',
306: '',

Line 304: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

300: IF l_valid_retcode > 2 THEN
301: --HXT_UTIL.DEBUG('Timecard validation errors.');
302: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');
303: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS');
304: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
305: 'VE',
306: '',
307: l_return);
308: END IF;

Line 318: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

314: -- Don't allow batches in a Hold status to be Transferred to PayMIX
315: IF batch_rec.batch_status = 'H' THEN
316: l_final_valid_retcode := 2;
317: FND_MESSAGE.SET_NAME('HXT','HXT_39350_CANT_TRANS_HLD_PAYMX');
318: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
319: 'VE',
320: '',
321: l_return);
322: -- Don't move to PayMIX while Timecard errors exist

Line 326: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

322: -- Don't move to PayMIX while Timecard errors exist
323: ELSIF batch_rec.batch_status in ('VE','ET') THEN -- RETROPAY
324: l_final_valid_retcode := 2;
325: FND_MESSAGE.SET_NAME('HXT','HXT_39351_CANT_TRANS_ERR_PAYMX');
326: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
327: 'VE',
328: '',
329: l_return);
330: ELSIF (batch_rec.batch_status = 'VT') THEN

Line 333: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

329: l_return);
330: ELSIF (batch_rec.batch_status = 'VT') THEN
331: l_final_valid_retcode := 2;
332: FND_MESSAGE.SET_NAME('HXT','HXT_39352_BTCHS_PREV_TRANS');
333: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
334: 'VE',
335: '',
336: l_return);
337: ELSIF batch_rec.batch_status in ('VV','VW') THEN -- RETROPAY

Line 349: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VT');

345: l_final_sum_retcode := l_sum_retcode;
346: END IF;
347: IF (l_sum_retcode = 0) then
348: --HXT_UTIL.DEBUG('Successful move to PayMIX.');
349: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VT');
350: ELSE
351: retcode := 2;
352: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
353: IF v_err_buf IS NULL THEN

Line 361: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, l_batch_id, 'VE');

357: END IF;
358: l_errbuf := FND_MESSAGE.GET;
359: FND_MESSAGE.CLEAR;
360: errbuf := l_errbuf;
361: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, l_batch_id, 'VE');
362: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,
363: 'VE',
364: sqlerrm,
365: l_return);

Line 362: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,

358: l_errbuf := FND_MESSAGE.GET;
359: FND_MESSAGE.CLEAR;
360: errbuf := l_errbuf;
361: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, l_batch_id, 'VE');
362: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,
363: 'VE',
364: sqlerrm,
365: l_return);
366: commit;

Line 371: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');

367: return;
368:
369: END IF;
370: IF (l_sum_retcode = 3) then
371: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');
372: END IF;
373: ELSE
374: l_final_valid_retcode := 2;
375: FND_MESSAGE.SET_NAME('HXT','HXT_39353_BTCHS_MST_BE_VALDTED');

Line 376: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

372: END IF;
373: ELSE
374: l_final_valid_retcode := 2;
375: FND_MESSAGE.SET_NAME('HXT','HXT_39353_BTCHS_MST_BE_VALDTED');
376: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
377: 'VE', -- RETROPAY
378: '',
379: l_return);
380: END IF; -- check status before processing

Line 394: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');

390: WHEN NO_DATA_FOUND THEN
391: l_index := null;
392:
393: WHEN OTHERS THEN
394: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');
395: HXT_UTIL.DEBUG('Other exception.'||sqlerrm);
396: l_index := null;
397: END; -- batches
398: END LOOP; -- while more batches exist in the range l_index not equal to null

Line 477: HXT_BATCH_PROCESS.merge_batches (p_merge_batch_name,

473: IF g_debug THEN
474: hr_utility.trace('before calling merge_batches proc');
475: END IF;
476:
477: HXT_BATCH_PROCESS.merge_batches (p_merge_batch_name,
478: l_merge_batches,
479: l_del_empty_batches,
480: p_bus_group_id,
481: 'R'

Line 506: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, l_batch_id, 'VE');

502: END IF;
503: l_errbuf := FND_MESSAGE.GET;
504: FND_MESSAGE.CLEAR;
505: errbuf := l_errbuf;
506: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, l_batch_id, 'VE');
507: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,
508: 'VE', -- RETROPAY
509: sqlerrm,
510: l_return);

Line 507: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,

503: l_errbuf := FND_MESSAGE.GET;
504: FND_MESSAGE.CLEAR;
505: errbuf := l_errbuf;
506: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, l_batch_id, 'VE');
507: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,
508: 'VE', -- RETROPAY
509: sqlerrm,
510: l_return);
511: commit;