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 FND_MESSAGE

Line 243: FND_MESSAGE.SET_NAME('HXT','HXT_39348_TC_VAL_NOT_REPROC'); --HXT111

239:
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);

Line 294: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); --HXT111

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: '',
298: l_return);

Line 303: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS');

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: '',
307: l_return);

Line 317: FND_MESSAGE.SET_NAME('HXT','HXT_39350_CANT_TRANS_HLD_PAYMX');

313: ELSIF p_process_mode = 'T' THEN
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);

Line 325: FND_MESSAGE.SET_NAME('HXT','HXT_39351_CANT_TRANS_ERR_PAYMX');

321: l_return);
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);

Line 332: FND_MESSAGE.SET_NAME('HXT','HXT_39352_BTCHS_PREV_TRANS');

328: '',
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);

Line 352: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');

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
354: FND_MESSAGE.SET_TOKEN('ERR_BUF',sqlerrm);
355: ELSE
356: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);

Line 354: FND_MESSAGE.SET_TOKEN('ERR_BUF',sqlerrm);

350: ELSE
351: retcode := 2;
352: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
353: IF v_err_buf IS NULL THEN
354: FND_MESSAGE.SET_TOKEN('ERR_BUF',sqlerrm);
355: ELSE
356: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
357: END IF;
358: l_errbuf := FND_MESSAGE.GET;

Line 356: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);

352: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
353: IF v_err_buf IS NULL THEN
354: FND_MESSAGE.SET_TOKEN('ERR_BUF',sqlerrm);
355: ELSE
356: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
357: END IF;
358: l_errbuf := FND_MESSAGE.GET;
359: FND_MESSAGE.CLEAR;
360: errbuf := l_errbuf;

Line 358: l_errbuf := FND_MESSAGE.GET;

354: FND_MESSAGE.SET_TOKEN('ERR_BUF',sqlerrm);
355: ELSE
356: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
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,

Line 359: FND_MESSAGE.CLEAR;

355: ELSE
356: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
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',

Line 375: FND_MESSAGE.SET_NAME('HXT','HXT_39353_BTCHS_MST_BE_VALDTED');

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');
376: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
377: 'VE', -- RETROPAY
378: '',
379: l_return);

Line 401: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL');

397: END; -- batches
398: END LOOP; -- while more batches exist in the range l_index not equal to null
399: -- Check for error totals to return a status from concurrent manager.
400: -- Normal
401: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL');
402: l_errbuf := FND_MESSAGE.GET;
403: FND_MESSAGE.CLEAR;
404: --HXT111 l_errbuf := 'Completed Normal.';
405: l_retcode := 0;

Line 402: l_errbuf := FND_MESSAGE.GET;

398: END LOOP; -- while more batches exist in the range l_index not equal to null
399: -- Check for error totals to return a status from concurrent manager.
400: -- Normal
401: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL');
402: l_errbuf := FND_MESSAGE.GET;
403: FND_MESSAGE.CLEAR;
404: --HXT111 l_errbuf := 'Completed Normal.';
405: l_retcode := 0;
406: -- No batches selected at all

Line 403: FND_MESSAGE.CLEAR;

399: -- Check for error totals to return a status from concurrent manager.
400: -- Normal
401: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL');
402: l_errbuf := FND_MESSAGE.GET;
403: FND_MESSAGE.CLEAR;
404: --HXT111 l_errbuf := 'Completed Normal.';
405: l_retcode := 0;
406: -- No batches selected at all
407: IF l_kounter = 0 THEN

Line 408: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL');

404: --HXT111 l_errbuf := 'Completed Normal.';
405: l_retcode := 0;
406: -- No batches selected at all
407: IF l_kounter = 0 THEN
408: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL');
409: l_errbuf := FND_MESSAGE.GET;
410: FND_MESSAGE.CLEAR;
411: --HXT111 l_errbuf := 'ERROR: No batches selected for processing, check batch status.';
412: l_retcode := 2;

Line 409: l_errbuf := FND_MESSAGE.GET;

405: l_retcode := 0;
406: -- No batches selected at all
407: IF l_kounter = 0 THEN
408: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL');
409: l_errbuf := FND_MESSAGE.GET;
410: FND_MESSAGE.CLEAR;
411: --HXT111 l_errbuf := 'ERROR: No batches selected for processing, check batch status.';
412: l_retcode := 2;
413: END IF;

Line 410: FND_MESSAGE.CLEAR;

406: -- No batches selected at all
407: IF l_kounter = 0 THEN
408: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL');
409: l_errbuf := FND_MESSAGE.GET;
410: FND_MESSAGE.CLEAR;
411: --HXT111 l_errbuf := 'ERROR: No batches selected for processing, check batch status.';
412: l_retcode := 2;
413: END IF;
414: -- v115.11 start

Line 416: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG');

412: l_retcode := 2;
413: END IF;
414: -- v115.11 start
415: IF b_stop = TRUE Then
416: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG');
417: l_errbuf := FND_MESSAGE.GET;
418: FND_MESSAGE.CLEAR;
419: l_retcode := 2;
420: END IF;

Line 417: l_errbuf := FND_MESSAGE.GET;

413: END IF;
414: -- v115.11 start
415: IF b_stop = TRUE Then
416: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG');
417: l_errbuf := FND_MESSAGE.GET;
418: FND_MESSAGE.CLEAR;
419: l_retcode := 2;
420: END IF;
421: -- v115.11 end

Line 418: FND_MESSAGE.CLEAR;

414: -- v115.11 start
415: IF b_stop = TRUE Then
416: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG');
417: l_errbuf := FND_MESSAGE.GET;
418: FND_MESSAGE.CLEAR;
419: l_retcode := 2;
420: END IF;
421: -- v115.11 end
422: IF l_final_rollback_retcode > 0 THEN

Line 424: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK');

420: END IF;
421: -- v115.11 end
422: IF l_final_rollback_retcode > 0 THEN
423: IF v_err_buf IS NULL THEN
424: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK');
425: ELSE
426: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_ERROR');
427: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
428: END IF;

Line 426: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_ERROR');

422: IF l_final_rollback_retcode > 0 THEN
423: IF v_err_buf IS NULL THEN
424: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK');
425: ELSE
426: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_ERROR');
427: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
428: END IF;
429: l_errbuf := FND_MESSAGE.GET;
430: FND_MESSAGE.CLEAR;

Line 427: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);

423: IF v_err_buf IS NULL THEN
424: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK');
425: ELSE
426: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_ERROR');
427: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
428: END IF;
429: l_errbuf := FND_MESSAGE.GET;
430: FND_MESSAGE.CLEAR;
431: l_retcode := 2;

Line 429: l_errbuf := FND_MESSAGE.GET;

425: ELSE
426: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_ERROR');
427: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
428: END IF;
429: l_errbuf := FND_MESSAGE.GET;
430: FND_MESSAGE.CLEAR;
431: l_retcode := 2;
432: END IF;
433: -- A warning was returned from the validate process

Line 430: FND_MESSAGE.CLEAR;

426: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_ERROR');
427: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
428: END IF;
429: l_errbuf := FND_MESSAGE.GET;
430: FND_MESSAGE.CLEAR;
431: l_retcode := 2;
432: END IF;
433: -- A warning was returned from the validate process
434: IF l_final_valid_retcode = 1 THEN

Line 440: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR');

436: END IF;
437: -- A stop-level error was returned from the validate process
438: IF l_final_valid_retcode = 2 THEN
439: IF v_err_buf IS NULL THEN
440: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR');
441: ELSE
442: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');
443: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
444: END IF;

Line 442: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');

438: IF l_final_valid_retcode = 2 THEN
439: IF v_err_buf IS NULL THEN
440: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR');
441: ELSE
442: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');
443: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
444: END IF;
445: l_errbuf := FND_MESSAGE.GET;
446: FND_MESSAGE.CLEAR;

Line 443: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);

439: IF v_err_buf IS NULL THEN
440: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR');
441: ELSE
442: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');
443: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
444: END IF;
445: l_errbuf := FND_MESSAGE.GET;
446: FND_MESSAGE.CLEAR;
447: l_retcode := 2;

Line 445: l_errbuf := FND_MESSAGE.GET;

441: ELSE
442: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');
443: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
444: END IF;
445: l_errbuf := FND_MESSAGE.GET;
446: FND_MESSAGE.CLEAR;
447: l_retcode := 2;
448: END IF;
449: -- a system level error occured somewhere during processing

Line 446: FND_MESSAGE.CLEAR;

442: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');
443: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
444: END IF;
445: l_errbuf := FND_MESSAGE.GET;
446: FND_MESSAGE.CLEAR;
447: l_retcode := 2;
448: END IF;
449: -- a system level error occured somewhere during processing
450: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN

Line 452: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');

448: END IF;
449: -- a system level error occured somewhere during processing
450: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN
451: IF v_err_buf IS NULL THEN
452: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
453: ELSE
454: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
455: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
456: END IF;

Line 454: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');

450: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN
451: IF v_err_buf IS NULL THEN
452: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
453: ELSE
454: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
455: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
456: END IF;
457: l_errbuf := FND_MESSAGE.GET;
458: FND_MESSAGE.CLEAR;

Line 455: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);

451: IF v_err_buf IS NULL THEN
452: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
453: ELSE
454: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
455: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
456: END IF;
457: l_errbuf := FND_MESSAGE.GET;
458: FND_MESSAGE.CLEAR;
459: l_retcode := 2;

Line 457: l_errbuf := FND_MESSAGE.GET;

453: ELSE
454: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
455: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
456: END IF;
457: l_errbuf := FND_MESSAGE.GET;
458: FND_MESSAGE.CLEAR;
459: l_retcode := 2;
460: END IF;
461: retcode := l_retcode;

Line 458: FND_MESSAGE.CLEAR;

454: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
455: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
456: END IF;
457: l_errbuf := FND_MESSAGE.GET;
458: FND_MESSAGE.CLEAR;
459: l_retcode := 2;
460: END IF;
461: retcode := l_retcode;
462: errbuf := l_errbuf;

Line 498: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');

494: -- delete from fnd_sessions where session_id = userenv('SESSIONID');
495: -- commit;
496: retcode := 2;
497: IF v_err_buf IS NULL THEN
498: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
499: ELSE
500: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
501: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
502: END IF;

Line 500: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');

496: retcode := 2;
497: IF v_err_buf IS NULL THEN
498: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
499: ELSE
500: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
501: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
502: END IF;
503: l_errbuf := FND_MESSAGE.GET;
504: FND_MESSAGE.CLEAR;

Line 501: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);

497: IF v_err_buf IS NULL THEN
498: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
499: ELSE
500: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
501: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
502: END IF;
503: l_errbuf := FND_MESSAGE.GET;
504: FND_MESSAGE.CLEAR;
505: errbuf := l_errbuf;

Line 503: l_errbuf := FND_MESSAGE.GET;

499: ELSE
500: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
501: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
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,

Line 504: FND_MESSAGE.CLEAR;

500: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
501: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
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