DBA Data[Home] [Help]

APPS.HXT_RETRO_PROCESS dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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
421: FND_MESSAGE.SET_TOKEN('ERR_BUF',sqlerrm);
422: ELSE
423: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);

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

417: ELSE
418: retcode := 2;
419: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
420: IF v_err_buf IS NULL THEN
421: FND_MESSAGE.SET_TOKEN('ERR_BUF',sqlerrm);
422: ELSE
423: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
424: END IF;
425: l_errbuf := FND_MESSAGE.GET;

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

419: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
420: IF v_err_buf IS NULL THEN
421: FND_MESSAGE.SET_TOKEN('ERR_BUF',sqlerrm);
422: ELSE
423: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
424: END IF;
425: l_errbuf := FND_MESSAGE.GET;
426: FND_MESSAGE.CLEAR;
427: errbuf := l_errbuf;

Line 425: l_errbuf := FND_MESSAGE.GET;

421: FND_MESSAGE.SET_TOKEN('ERR_BUF',sqlerrm);
422: ELSE
423: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
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,

Line 426: FND_MESSAGE.CLEAR;

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

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

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');
443: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( batch_rec.batch_id,
444: 'VE', -- RETROPAY
445: '',
446: l_return);

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

471: END; -- batches
472: END LOOP; -- while more batches exist in the range l_index not equal to null
473: -- Check for error totals to return a status from concurrent manager.
474: -- Normal
475: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL');
476: l_errbuf := FND_MESSAGE.GET;
477: FND_MESSAGE.CLEAR;
478: --HXT111 l_errbuf := 'Completed Normal.';
479: l_retcode := 0;

Line 476: l_errbuf := FND_MESSAGE.GET;

472: END LOOP; -- while more batches exist in the range l_index not equal to null
473: -- Check for error totals to return a status from concurrent manager.
474: -- Normal
475: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL');
476: l_errbuf := FND_MESSAGE.GET;
477: FND_MESSAGE.CLEAR;
478: --HXT111 l_errbuf := 'Completed Normal.';
479: l_retcode := 0;
480: -- No batches selected at all

Line 477: FND_MESSAGE.CLEAR;

473: -- Check for error totals to return a status from concurrent manager.
474: -- Normal
475: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL');
476: l_errbuf := FND_MESSAGE.GET;
477: FND_MESSAGE.CLEAR;
478: --HXT111 l_errbuf := 'Completed Normal.';
479: l_retcode := 0;
480: -- No batches selected at all
481: IF l_kounter = 0 THEN

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

478: --HXT111 l_errbuf := 'Completed Normal.';
479: l_retcode := 0;
480: -- No batches selected at all
481: IF l_kounter = 0 THEN
482: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL');
483: l_errbuf := FND_MESSAGE.GET;
484: FND_MESSAGE.CLEAR;
485: --HXT111 l_errbuf := 'ERROR: No batches selected for processing, check batch status.';
486: l_retcode := 2;

Line 483: l_errbuf := FND_MESSAGE.GET;

479: l_retcode := 0;
480: -- No batches selected at all
481: IF l_kounter = 0 THEN
482: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL');
483: l_errbuf := FND_MESSAGE.GET;
484: FND_MESSAGE.CLEAR;
485: --HXT111 l_errbuf := 'ERROR: No batches selected for processing, check batch status.';
486: l_retcode := 2;
487: END IF;

Line 484: FND_MESSAGE.CLEAR;

480: -- No batches selected at all
481: IF l_kounter = 0 THEN
482: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL');
483: l_errbuf := FND_MESSAGE.GET;
484: FND_MESSAGE.CLEAR;
485: --HXT111 l_errbuf := 'ERROR: No batches selected for processing, check batch status.';
486: l_retcode := 2;
487: END IF;
488: -- v115.11 start

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

486: l_retcode := 2;
487: END IF;
488: -- v115.11 start
489: IF b_stop = TRUE Then
490: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG');
491: l_errbuf := FND_MESSAGE.GET;
492: FND_MESSAGE.CLEAR;
493: l_retcode := 2;
494: END IF;

Line 491: l_errbuf := FND_MESSAGE.GET;

487: END IF;
488: -- v115.11 start
489: IF b_stop = TRUE Then
490: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG');
491: l_errbuf := FND_MESSAGE.GET;
492: FND_MESSAGE.CLEAR;
493: l_retcode := 2;
494: END IF;
495: -- v115.11 end

Line 492: FND_MESSAGE.CLEAR;

488: -- v115.11 start
489: IF b_stop = TRUE Then
490: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG');
491: l_errbuf := FND_MESSAGE.GET;
492: FND_MESSAGE.CLEAR;
493: l_retcode := 2;
494: END IF;
495: -- v115.11 end
496: IF l_final_rollback_retcode > 0 THEN

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

494: END IF;
495: -- v115.11 end
496: IF l_final_rollback_retcode > 0 THEN
497: IF v_err_buf IS NULL THEN
498: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK');
499: ELSE
500: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_ERROR');
501: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
502: END IF;

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

496: IF l_final_rollback_retcode > 0 THEN
497: IF v_err_buf IS NULL THEN
498: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK');
499: ELSE
500: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_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_39361_ERR_DURING_ROLLBACK');
499: ELSE
500: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_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: l_retcode := 2;

Line 503: l_errbuf := FND_MESSAGE.GET;

499: ELSE
500: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_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: l_retcode := 2;
506: END IF;
507: -- A warning was returned from the validate process

Line 504: FND_MESSAGE.CLEAR;

500: FND_MESSAGE.SET_NAME('HXT','HXT_39450_RETRO_ROLLBACK_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: l_retcode := 2;
506: END IF;
507: -- A warning was returned from the validate process
508: IF l_final_valid_retcode = 1 THEN

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

510: END IF;
511: -- A stop-level error was returned from the validate process
512: IF l_final_valid_retcode = 2 THEN
513: IF v_err_buf IS NULL THEN
514: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR');
515: ELSE
516: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');
517: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
518: END IF;

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

512: IF l_final_valid_retcode = 2 THEN
513: IF v_err_buf IS NULL THEN
514: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR');
515: ELSE
516: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');
517: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
518: END IF;
519: l_errbuf := FND_MESSAGE.GET;
520: FND_MESSAGE.CLEAR;

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

513: IF v_err_buf IS NULL THEN
514: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR');
515: ELSE
516: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');
517: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
518: END IF;
519: l_errbuf := FND_MESSAGE.GET;
520: FND_MESSAGE.CLEAR;
521: l_retcode := 2;

Line 519: l_errbuf := FND_MESSAGE.GET;

515: ELSE
516: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');
517: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
518: END IF;
519: l_errbuf := FND_MESSAGE.GET;
520: FND_MESSAGE.CLEAR;
521: l_retcode := 2;
522: END IF;
523: -- a system level error occured somewhere during processing

Line 520: FND_MESSAGE.CLEAR;

516: FND_MESSAGE.SET_NAME('HXT','HXT_39451_RETRO_BATCH_ERROR');
517: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
518: END IF;
519: l_errbuf := FND_MESSAGE.GET;
520: FND_MESSAGE.CLEAR;
521: l_retcode := 2;
522: END IF;
523: -- a system level error occured somewhere during processing
524: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN

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

522: END IF;
523: -- a system level error occured somewhere during processing
524: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN
525: IF v_err_buf IS NULL THEN
526: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
527: ELSE
528: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
529: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
530: END IF;

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

524: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN
525: IF v_err_buf IS NULL THEN
526: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
527: ELSE
528: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
529: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
530: END IF;
531: l_errbuf := FND_MESSAGE.GET;
532: FND_MESSAGE.CLEAR;

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

525: IF v_err_buf IS NULL THEN
526: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
527: ELSE
528: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
529: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
530: END IF;
531: l_errbuf := FND_MESSAGE.GET;
532: FND_MESSAGE.CLEAR;
533: l_retcode := 2;

Line 531: l_errbuf := FND_MESSAGE.GET;

527: ELSE
528: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
529: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
530: END IF;
531: l_errbuf := FND_MESSAGE.GET;
532: FND_MESSAGE.CLEAR;
533: l_retcode := 2;
534: END IF;
535: retcode := l_retcode;

Line 532: FND_MESSAGE.CLEAR;

528: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
529: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
530: END IF;
531: l_errbuf := FND_MESSAGE.GET;
532: FND_MESSAGE.CLEAR;
533: l_retcode := 2;
534: END IF;
535: retcode := l_retcode;
536: errbuf := l_errbuf;

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

568: -- delete from fnd_sessions where session_id = userenv('SESSIONID');
569: -- commit;
570: retcode := 2;
571: IF v_err_buf IS NULL THEN
572: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
573: ELSE
574: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
575: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
576: END IF;

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

570: retcode := 2;
571: IF v_err_buf IS NULL THEN
572: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
573: ELSE
574: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
575: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
576: END IF;
577: l_errbuf := FND_MESSAGE.GET;
578: FND_MESSAGE.CLEAR;

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

571: IF v_err_buf IS NULL THEN
572: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
573: ELSE
574: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
575: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
576: END IF;
577: l_errbuf := FND_MESSAGE.GET;
578: FND_MESSAGE.CLEAR;
579: errbuf := l_errbuf;

Line 577: l_errbuf := FND_MESSAGE.GET;

573: ELSE
574: FND_MESSAGE.SET_NAME('HXT','HXT_39452_RETRO_SYSTEM_ERROR');
575: FND_MESSAGE.SET_TOKEN('ERR_BUF',v_err_buf);
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,

Line 578: FND_MESSAGE.CLEAR;

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