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 153: l_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;

149: l_cnt BINARY_INTEGER;
150: l_count BINARY_INTEGER;
151: l_loop_index BINARY_INTEGER;
152: l_loop_flag BOOLEAN;
153: l_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
154: p_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
155: l_del_empty_batches HXT_BATCH_PROCESS.DEL_EMPTY_BATCHES_TYPE_TABLE;
156:
157: /********Bug: 4620315 **********/

Line 154: p_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;

150: l_count BINARY_INTEGER;
151: l_loop_index BINARY_INTEGER;
152: l_loop_flag BOOLEAN;
153: l_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
154: p_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
155: l_del_empty_batches HXT_BATCH_PROCESS.DEL_EMPTY_BATCHES_TYPE_TABLE;
156:
157: /********Bug: 4620315 **********/
158:

Line 155: l_del_empty_batches HXT_BATCH_PROCESS.DEL_EMPTY_BATCHES_TYPE_TABLE;

151: l_loop_index BINARY_INTEGER;
152: l_loop_flag BOOLEAN;
153: l_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
154: p_merge_batches HXT_BATCH_PROCESS.MERGE_BATCHES_TYPE_TABLE;
155: l_del_empty_batches HXT_BATCH_PROCESS.DEL_EMPTY_BATCHES_TYPE_TABLE;
156:
157: /********Bug: 4620315 **********/
158:
159: BEGIN

Line 311: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

307: -- Check for a valid status code
308: IF (batch_rec.batch_status = 'VT') THEN
309: l_final_valid_retcode := 2;
310: FND_MESSAGE.SET_NAME('HXT','HXT_39348_TC_VAL_NOT_REPROC'); --HXT111
311: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
312: 'VE',
313: '',
314: l_return);
315: ELSE

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

317: -- Validate batch, status:0=Normal, 1=Warning, 2=Stop Level Data Error, 3=System
318: --
319: --HXT_UTIL.DEBUG('Begin timecard validation.');
320: -- Delete prior errors for this batch
321: HXT_BATCH_PROCESS.Del_Prior_Errors(batch_rec.batch_id);
322: HXT_RETRO_VAL.Val_Retro_Timecard(batch_rec.batch_id,
323: batch_rec.tim_id,
324: l_valid_retcode,
325: p_merge_flag,

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

350: END IF;
351: -- Successful Validation, Set batch to ready Status
352: IF l_valid_retcode = 0 then
353: --HXT_UTIL.DEBUG('Successful timecard validation.');
354: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VV');
355: END IF;
356: -- set status to Warning and lets user know we have a TAMS/O
357: -- User Level Data Error for this batch
358: IF l_valid_retcode = 1 then

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

356: -- set status to Warning and lets user know we have a TAMS/O
357: -- User Level Data Error for this batch
358: IF l_valid_retcode = 1 then
359: --HXT_UTIL.DEBUG('Timecard validation warnings.');
360: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VW');
361: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); --HXT111
362: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
363: 'W',
364: '',

Line 362: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

358: IF l_valid_retcode = 1 then
359: --HXT_UTIL.DEBUG('Timecard validation warnings.');
360: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VW');
361: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); --HXT111
362: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
363: 'W',
364: '',
365: l_return);
366: END IF;

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

365: l_return);
366: END IF;
367: IF l_valid_retcode > 2 THEN
368: --HXT_UTIL.DEBUG('Timecard validation errors.');
369: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');
370: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS');
371: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
372: 'VE',
373: '',

Line 371: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

367: IF l_valid_retcode > 2 THEN
368: --HXT_UTIL.DEBUG('Timecard validation errors.');
369: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');
370: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS');
371: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
372: 'VE',
373: '',
374: l_return);
375: END IF;

Line 385: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

381: -- Don't allow batches in a Hold status to be Transferred to PayMIX
382: IF batch_rec.batch_status = 'H' THEN
383: l_final_valid_retcode := 2;
384: FND_MESSAGE.SET_NAME('HXT','HXT_39350_CANT_TRANS_HLD_PAYMX');
385: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
386: 'VE',
387: '',
388: l_return);
389: -- Don't move to PayMIX while Timecard errors exist

Line 393: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

389: -- Don't move to PayMIX while Timecard errors exist
390: ELSIF batch_rec.batch_status in ('VE','ET') THEN -- RETROPAY
391: l_final_valid_retcode := 2;
392: FND_MESSAGE.SET_NAME('HXT','HXT_39351_CANT_TRANS_ERR_PAYMX');
393: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
394: 'VE',
395: '',
396: l_return);
397: ELSIF (batch_rec.batch_status = 'VT') THEN

Line 400: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

396: l_return);
397: ELSIF (batch_rec.batch_status = 'VT') THEN
398: l_final_valid_retcode := 2;
399: FND_MESSAGE.SET_NAME('HXT','HXT_39352_BTCHS_PREV_TRANS');
400: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
401: 'VE',
402: '',
403: l_return);
404: ELSIF batch_rec.batch_status in ('VV','VW') THEN -- RETROPAY

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

412: l_final_sum_retcode := l_sum_retcode;
413: END IF;
414: IF (l_sum_retcode = 0) then
415: --HXT_UTIL.DEBUG('Successful move to PayMIX.');
416: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VT');
417: ELSE
418: retcode := 2;
419: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
420: IF v_err_buf IS NULL THEN

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

424: END IF;
425: l_errbuf := FND_MESSAGE.GET;
426: FND_MESSAGE.CLEAR;
427: errbuf := l_errbuf;
428: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, l_batch_id, 'VE');
429: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,
430: 'VE',
431: sqlerrm,
432: l_return);

Line 429: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,

425: l_errbuf := FND_MESSAGE.GET;
426: FND_MESSAGE.CLEAR;
427: errbuf := l_errbuf;
428: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, l_batch_id, 'VE');
429: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,
430: 'VE',
431: sqlerrm,
432: l_return);
433: commit;

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

434: return;
435:
436: END IF;
437: IF (l_sum_retcode = 3) then
438: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');
439: END IF;
440: ELSE
441: l_final_valid_retcode := 2;
442: FND_MESSAGE.SET_NAME('HXT','HXT_39353_BTCHS_MST_BE_VALDTED');

Line 443: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,

439: END IF;
440: ELSE
441: l_final_valid_retcode := 2;
442: FND_MESSAGE.SET_NAME('HXT','HXT_39353_BTCHS_MST_BE_VALDTED');
443: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
444: 'VE', -- RETROPAY
445: '',
446: l_return);
447: END IF; -- check status before processing

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

464: hr_utility.trace('Batch '||batch_rec.batch_id||' threw a NO_DATA_FOUND');
465: hr_utility.trace('Backtrace this error to Batch validation log ');
466: hr_utility.trace('Skipping to next batch ');
467: WHEN OTHERS THEN
468: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');
469: HXT_UTIL.DEBUG('Other exception.'||sqlerrm);
470: l_index := null;
471: END; -- batches
472: END LOOP; -- while more batches exist in the range l_index not equal to null

Line 551: HXT_BATCH_PROCESS.merge_batches (p_merge_batch_name,

547: IF g_debug THEN
548: hr_utility.trace('before calling merge_batches proc');
549: END IF;
550:
551: HXT_BATCH_PROCESS.merge_batches (p_merge_batch_name,
552: l_merge_batches,
553: l_del_empty_batches,
554: p_bus_group_id,
555: 'R'

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

576: END IF;
577: l_errbuf := FND_MESSAGE.GET;
578: FND_MESSAGE.CLEAR;
579: errbuf := l_errbuf;
580: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, l_batch_id, 'VE');
581: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,
582: 'VE', -- RETROPAY
583: sqlerrm,
584: l_return);

Line 581: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,

577: l_errbuf := FND_MESSAGE.GET;
578: FND_MESSAGE.CLEAR;
579: errbuf := l_errbuf;
580: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, l_batch_id, 'VE');
581: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,
582: 'VE', -- RETROPAY
583: sqlerrm,
584: l_return);
585: commit;