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_BATCH_PROCESS dependencies on FND_MESSAGE

Line 549: -- FND_MESSAGE.SET_NAME('HXT','HXT_39348_TC_VAL_NOT_REPROC'); -- HXT11

545: -- Check for a valid status code
546: -- IF batch_rec.batch_status = 'VT' THEN
547: -- null; -- Don't revalidate batches that have been sent to PayMIX ORA128
548: -- l_final_valid_retcode := 2;
549: -- FND_MESSAGE.SET_NAME('HXT','HXT_39348_TC_VAL_NOT_REPROC'); -- HXT11
550: -- Insert_Pay_Batch_Errors( batch_rec.batch_id,
551: -- 'VE', --SIR020
552: -- '', --HXT11
553: -- l_return);

Line 617: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); -- HXT11

613: -- User Level Data Error for this batch
614: IF l_valid_retcode = 1 then
615: HXT_UTIL.DEBUG('Timecard validation warnings.');-- debug only HXT115
616: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VW'); --SIR020
617: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); -- HXT11
618: Insert_Pay_Batch_Errors( batch_rec.batch_id,
619: 'W',
620: '', -- HXT11
621: l_return);

Line 626: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); --HXT11

622: END IF;
623: IF l_valid_retcode >= 2 THEN
624: HXT_UTIL.DEBUG('Timecard validation errors.');-- debug only HXT115
625: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VE'); --SIR020
626: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); --HXT11
627: Insert_Pay_Batch_Errors( batch_rec.batch_id,
628: 'VE', --SIR020
629: '', --HXT11
630: l_return);

Line 641: FND_MESSAGE.SET_NAME('HXT','HXT_39350_CANT_TRANS_HLD_PAYMX');--HXT11

637: l_counter := l_counter + 1;
638: -- Don't allow batches in a Hold status to be Transferred to PayMIX
639: IF batch_rec.batch_status = 'H' THEN
640: l_final_valid_retcode := 2;
641: FND_MESSAGE.SET_NAME('HXT','HXT_39350_CANT_TRANS_HLD_PAYMX');--HXT11
642: Insert_Pay_Batch_Errors( batch_rec.batch_id,
643: 'VE', --SIR020
644: '', -- HXT11
645: l_return);

Line 649: FND_MESSAGE.SET_NAME('HXT','HXT_39351_CANT_TRANS_ERR_PAYMX');-- HXT11

645: l_return);
646: -- Don't move to PayMIX while Timecard errors exist
647: ELSIF batch_rec.batch_status in ('VE','ET') THEN --SIR020
648: l_final_valid_retcode := 2;
649: FND_MESSAGE.SET_NAME('HXT','HXT_39351_CANT_TRANS_ERR_PAYMX');-- HXT11
650: Insert_Pay_Batch_Errors( batch_rec.batch_id,
651: 'VE', --SIR020
652: '', -- HXT11
653: l_return);

Line 656: -- FND_MESSAGE.SET_NAME('HXT','HXT_39352_BTCHS_PREV_TRANS'); -- HXT11

652: '', -- HXT11
653: l_return);
654: -- ELSIF (batch_rec.batch_status = 'VT') THEN
655: -- l_final_valid_retcode := 2;
656: -- FND_MESSAGE.SET_NAME('HXT','HXT_39352_BTCHS_PREV_TRANS'); -- HXT11
657: -- Insert_Pay_Batch_Errors( batch_rec.batch_id,
658: -- 'VE', --SIR020
659: -- '', -- HXT11
660: -- l_return);

Line 679: FND_MESSAGE.SET_NAME('HXT','HXT_39353_BTCHS_MST_BE_VALDTED');-- HXT11

675: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VE');--SIR020
676: END IF;
677: ELSE
678: l_final_valid_retcode := 2;
679: FND_MESSAGE.SET_NAME('HXT','HXT_39353_BTCHS_MST_BE_VALDTED');-- HXT11
680: Insert_Pay_Batch_Errors( batch_rec.batch_id,
681: 'VE', --SIR020
682: '', -- HXT11
683: l_return);

Line 740: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL'); -- HXT11

736: END LOOP; -- while more batches exist in the range
737: -- end SPR C166 BY BC
738: -- Check for error totals to return a status from concurrent manager.
739: -- Normal
740: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL'); -- HXT11
741: l_errbuf := FND_MESSAGE.GET; -- HXT11
742: FND_MESSAGE.CLEAR; -- HXT11
743: l_retcode := 0;
744: -- No batches seleceted at all

Line 741: l_errbuf := FND_MESSAGE.GET; -- HXT11

737: -- end SPR C166 BY BC
738: -- Check for error totals to return a status from concurrent manager.
739: -- Normal
740: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL'); -- HXT11
741: l_errbuf := FND_MESSAGE.GET; -- HXT11
742: FND_MESSAGE.CLEAR; -- HXT11
743: l_retcode := 0;
744: -- No batches seleceted at all
745: IF l_counter = 0 THEN

Line 742: FND_MESSAGE.CLEAR; -- HXT11

738: -- Check for error totals to return a status from concurrent manager.
739: -- Normal
740: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL'); -- HXT11
741: l_errbuf := FND_MESSAGE.GET; -- HXT11
742: FND_MESSAGE.CLEAR; -- HXT11
743: l_retcode := 0;
744: -- No batches seleceted at all
745: IF l_counter = 0 THEN
746: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL'); -- HXT11

Line 746: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL'); -- HXT11

742: FND_MESSAGE.CLEAR; -- HXT11
743: l_retcode := 0;
744: -- No batches seleceted at all
745: IF l_counter = 0 THEN
746: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL'); -- HXT11
747: l_errbuf := FND_MESSAGE.GET; -- HXT11
748: FND_MESSAGE.CLEAR; -- HXT11
749: l_retcode := 2;
750: END IF;

Line 747: l_errbuf := FND_MESSAGE.GET; -- HXT11

743: l_retcode := 0;
744: -- No batches seleceted at all
745: IF l_counter = 0 THEN
746: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL'); -- HXT11
747: l_errbuf := FND_MESSAGE.GET; -- HXT11
748: FND_MESSAGE.CLEAR; -- HXT11
749: l_retcode := 2;
750: END IF;
751: IF b_inverted_batch_nums = TRUE THEN

Line 748: FND_MESSAGE.CLEAR; -- HXT11

744: -- No batches seleceted at all
745: IF l_counter = 0 THEN
746: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL'); -- HXT11
747: l_errbuf := FND_MESSAGE.GET; -- HXT11
748: FND_MESSAGE.CLEAR; -- HXT11
749: l_retcode := 2;
750: END IF;
751: IF b_inverted_batch_nums = TRUE THEN
752: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG'); --HXT11

Line 752: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG'); --HXT11

748: FND_MESSAGE.CLEAR; -- HXT11
749: l_retcode := 2;
750: END IF;
751: IF b_inverted_batch_nums = TRUE THEN
752: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG'); --HXT11
753: l_errbuf := FND_MESSAGE.GET; -- HXT11
754: FND_MESSAGE.CLEAR; -- HXT11
755: l_retcode := 2;
756: END IF;

Line 753: l_errbuf := FND_MESSAGE.GET; -- HXT11

749: l_retcode := 2;
750: END IF;
751: IF b_inverted_batch_nums = TRUE THEN
752: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG'); --HXT11
753: l_errbuf := FND_MESSAGE.GET; -- HXT11
754: FND_MESSAGE.CLEAR; -- HXT11
755: l_retcode := 2;
756: END IF;
757: IF l_final_rollback_retcode > 0 THEN

Line 754: FND_MESSAGE.CLEAR; -- HXT11

750: END IF;
751: IF b_inverted_batch_nums = TRUE THEN
752: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG'); --HXT11
753: l_errbuf := FND_MESSAGE.GET; -- HXT11
754: FND_MESSAGE.CLEAR; -- HXT11
755: l_retcode := 2;
756: END IF;
757: IF l_final_rollback_retcode > 0 THEN
758: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK'); -- HXT11

Line 758: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK'); -- HXT11

754: FND_MESSAGE.CLEAR; -- HXT11
755: l_retcode := 2;
756: END IF;
757: IF l_final_rollback_retcode > 0 THEN
758: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK'); -- HXT11
759: l_errbuf := FND_MESSAGE.GET; -- HXT11
760: FND_MESSAGE.CLEAR; -- HXT11
761: l_retcode := 2;
762: END IF;

Line 759: l_errbuf := FND_MESSAGE.GET; -- HXT11

755: l_retcode := 2;
756: END IF;
757: IF l_final_rollback_retcode > 0 THEN
758: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK'); -- HXT11
759: l_errbuf := FND_MESSAGE.GET; -- HXT11
760: FND_MESSAGE.CLEAR; -- HXT11
761: l_retcode := 2;
762: END IF;
763: -- A warning was returned from the validate process

Line 760: FND_MESSAGE.CLEAR; -- HXT11

756: END IF;
757: IF l_final_rollback_retcode > 0 THEN
758: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK'); -- HXT11
759: l_errbuf := FND_MESSAGE.GET; -- HXT11
760: FND_MESSAGE.CLEAR; -- HXT11
761: l_retcode := 2;
762: END IF;
763: -- A warning was returned from the validate process
764: IF l_final_valid_retcode = 1 THEN

Line 769: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR'); -- HXT11

765: l_retcode := 1;
766: END IF;
767: IF l_final_valid_retcode = 2 THEN
768: HXT_UTIL.DEBUG('l_final_valid_retcode is 2');-- debug only --HXT115
769: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR'); -- HXT11
770: l_errbuf := FND_MESSAGE.GET; -- HXT11
771: FND_MESSAGE.CLEAR; -- HXT11
772: l_retcode := 2;
773: END IF;

Line 770: l_errbuf := FND_MESSAGE.GET; -- HXT11

766: END IF;
767: IF l_final_valid_retcode = 2 THEN
768: HXT_UTIL.DEBUG('l_final_valid_retcode is 2');-- debug only --HXT115
769: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR'); -- HXT11
770: l_errbuf := FND_MESSAGE.GET; -- HXT11
771: FND_MESSAGE.CLEAR; -- HXT11
772: l_retcode := 2;
773: END IF;
774: -- a system level error occured somewhere during processing

Line 771: FND_MESSAGE.CLEAR; -- HXT11

767: IF l_final_valid_retcode = 2 THEN
768: HXT_UTIL.DEBUG('l_final_valid_retcode is 2');-- debug only --HXT115
769: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR'); -- HXT11
770: l_errbuf := FND_MESSAGE.GET; -- HXT11
771: FND_MESSAGE.CLEAR; -- HXT11
772: l_retcode := 2;
773: END IF;
774: -- a system level error occured somewhere during processing
775: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN

Line 776: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR'); -- HXT11

772: l_retcode := 2;
773: END IF;
774: -- a system level error occured somewhere during processing
775: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN
776: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR'); -- HXT11
777: l_errbuf := FND_MESSAGE.GET; -- HXT11
778: FND_MESSAGE.CLEAR; -- HXT11
779: l_retcode := 2;
780: END IF;

Line 777: l_errbuf := FND_MESSAGE.GET; -- HXT11

773: END IF;
774: -- a system level error occured somewhere during processing
775: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN
776: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR'); -- HXT11
777: l_errbuf := FND_MESSAGE.GET; -- HXT11
778: FND_MESSAGE.CLEAR; -- HXT11
779: l_retcode := 2;
780: END IF;
781: retcode := l_retcode;

Line 778: FND_MESSAGE.CLEAR; -- HXT11

774: -- a system level error occured somewhere during processing
775: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN
776: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR'); -- HXT11
777: l_errbuf := FND_MESSAGE.GET; -- HXT11
778: FND_MESSAGE.CLEAR; -- HXT11
779: l_retcode := 2;
780: END IF;
781: retcode := l_retcode;
782: errbuf := l_errbuf;

Line 809: l_errbuf := substr(FND_MESSAGE.GET,1,65);

805:
806: EXCEPTION
807: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00 TESTING
808: HXT_UTIL.DEBUG('Oops...g_lookup_not_found in procedure sum_to_mix');
809: l_errbuf := substr(FND_MESSAGE.GET,1,65);
810: errbuf := l_errbuf;
811: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,
812: 'VE', -- RETROPAY
813: '',

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

819: COMMIT;
820: END IF;
821: WHEN OTHERS THEN
822: retcode := 2;
823: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
824: l_errbuf := FND_MESSAGE.GET;
825: FND_MESSAGE.CLEAR;
826: errbuf := l_errbuf;
827: Set_Batch_Status(l_date_earned, l_batch_id, 'VE');

Line 824: l_errbuf := FND_MESSAGE.GET;

820: END IF;
821: WHEN OTHERS THEN
822: retcode := 2;
823: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
824: l_errbuf := FND_MESSAGE.GET;
825: FND_MESSAGE.CLEAR;
826: errbuf := l_errbuf;
827: Set_Batch_Status(l_date_earned, l_batch_id, 'VE');
828: Insert_Pay_Batch_Errors( l_batch_id,

Line 825: FND_MESSAGE.CLEAR;

821: WHEN OTHERS THEN
822: retcode := 2;
823: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
824: l_errbuf := FND_MESSAGE.GET;
825: FND_MESSAGE.CLEAR;
826: errbuf := l_errbuf;
827: Set_Batch_Status(l_date_earned, l_batch_id, 'VE');
828: Insert_Pay_Batch_Errors( l_batch_id,
829: 'VE',

Line 871: FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');

867: IF get_meaning_cur%NOTFOUND then
868: if g_debug then
869: hr_utility.set_location('convert_lookup',30);
870: end if;
871: FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
872: FND_MESSAGE.SET_TOKEN('CODE', p_lookup_code);
873: FND_MESSAGE.SET_TOKEN('TYPE', p_lookup_type);
874: RAISE g_lookup_not_found;
875: END IF;

Line 872: FND_MESSAGE.SET_TOKEN('CODE', p_lookup_code);

868: if g_debug then
869: hr_utility.set_location('convert_lookup',30);
870: end if;
871: FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
872: FND_MESSAGE.SET_TOKEN('CODE', p_lookup_code);
873: FND_MESSAGE.SET_TOKEN('TYPE', p_lookup_type);
874: RAISE g_lookup_not_found;
875: END IF;
876: ELSE

Line 873: FND_MESSAGE.SET_TOKEN('TYPE', p_lookup_type);

869: hr_utility.set_location('convert_lookup',30);
870: end if;
871: FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
872: FND_MESSAGE.SET_TOKEN('CODE', p_lookup_code);
873: FND_MESSAGE.SET_TOKEN('TYPE', p_lookup_type);
874: RAISE g_lookup_not_found;
875: END IF;
876: ELSE
877: if g_debug then

Line 930: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');

926: if g_debug then
927: hr_utility.set_location('get_lookup_code',30);
928: hr_utility.trace('get_lookup_code_cur NOT FOUND');
929: end if;
930: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
931: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
932: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
933: -- RAISE g_lookup_not_found;
934: null; -- This is done to fix bug 1761779 -- 17/May/2001

Line 931: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00

927: hr_utility.set_location('get_lookup_code',30);
928: hr_utility.trace('get_lookup_code_cur NOT FOUND');
929: end if;
930: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
931: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
932: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
933: -- RAISE g_lookup_not_found;
934: null; -- This is done to fix bug 1761779 -- 17/May/2001
935: END IF;

Line 932: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00

928: hr_utility.trace('get_lookup_code_cur NOT FOUND');
929: end if;
930: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
931: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
932: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
933: -- RAISE g_lookup_not_found;
934: null; -- This is done to fix bug 1761779 -- 17/May/2001
935: END IF;
936: ELSE

Line 1374: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');

1370: RAISE g_lookup_not_found; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
1371: WHEN others THEN
1372: HXT_UTIL.DEBUG(sqlerrm); --HXT115
1373: HXT_UTIL.DEBUG('Oops...others'); --HXT115
1374: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
1375: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
1376: Insert_Pay_Batch_Errors( p_values_rec.batch_id, 'VE', '', l_return);
1377: p_sum_retcode := 3;
1378: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure

Line 1375: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);

1371: WHEN others THEN
1372: HXT_UTIL.DEBUG(sqlerrm); --HXT115
1373: HXT_UTIL.DEBUG('Oops...others'); --HXT115
1374: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
1375: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
1376: Insert_Pay_Batch_Errors( p_values_rec.batch_id, 'VE', '', l_return);
1377: p_sum_retcode := 3;
1378: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
1379: END dtl_to_BEE;

Line 1497: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');

1493: raise g_lookup_not_found ; --propogate to the calling procedure
1494: WHEN g_error_ins_batch_lines THEN --SIR517 PWM 18FEB00
1495: ROLLBACK; --115.37
1496: HXT_UTIL.DEBUG('Error attempting to insert paymix information');
1497: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
1498: FND_MESSAGE.SET_TOKEN('SQLERR',sqlerrm);
1499: Insert_Pay_Batch_Errors( p_batch_id, 'VE', '', l_return);
1500: HXT_UTIL.DEBUG(' back from calling insert_pay_batch_errors');
1501: p_sum_retcode := 3;

Line 1498: FND_MESSAGE.SET_TOKEN('SQLERR',sqlerrm);

1494: WHEN g_error_ins_batch_lines THEN --SIR517 PWM 18FEB00
1495: ROLLBACK; --115.37
1496: HXT_UTIL.DEBUG('Error attempting to insert paymix information');
1497: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
1498: FND_MESSAGE.SET_TOKEN('SQLERR',sqlerrm);
1499: Insert_Pay_Batch_Errors( p_batch_id, 'VE', '', l_return);
1500: HXT_UTIL.DEBUG(' back from calling insert_pay_batch_errors');
1501: p_sum_retcode := 3;
1502: raise g_error_ins_batch_lines ;

Line 1507: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');

1503: WHEN others THEN
1504: ROLLBACK; --115.37
1505: HXT_UTIL.DEBUG(sqlerrm);
1506: HXT_UTIL.DEBUG('Oops...others');
1507: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
1508: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
1509: Insert_Pay_Batch_Errors( p_batch_id, 'VE', '', l_return);
1510: p_sum_retcode := 3;
1511: END sum_to_mix;

Line 1508: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);

1504: ROLLBACK; --115.37
1505: HXT_UTIL.DEBUG(sqlerrm);
1506: HXT_UTIL.DEBUG('Oops...others');
1507: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
1508: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
1509: Insert_Pay_Batch_Errors( p_batch_id, 'VE', '', l_return);
1510: p_sum_retcode := 3;
1511: END sum_to_mix;
1512: --------------------------------------------------------------------------------

Line 1559: FND_MESSAGE.SET_NAME('HXT','HXT_39357_BATCH_ERR');

1555: end if;
1556: --DEBUG ONLY END*/
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME('HXT','HXT_39357_BATCH_ERR');
1560: FND_MESSAGE.SET_TOKEN('MESSAGE', l_errbuf);
1561: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
1562: Insert_Pay_Batch_Errors(
1563: p_batch_id,

Line 1560: FND_MESSAGE.SET_TOKEN('MESSAGE', l_errbuf);

1556: --DEBUG ONLY END*/
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME('HXT','HXT_39357_BATCH_ERR');
1560: FND_MESSAGE.SET_TOKEN('MESSAGE', l_errbuf);
1561: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
1562: Insert_Pay_Batch_Errors(
1563: p_batch_id,
1564: 'VE',

Line 1561: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);

1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME('HXT','HXT_39357_BATCH_ERR');
1560: FND_MESSAGE.SET_TOKEN('MESSAGE', l_errbuf);
1561: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
1562: Insert_Pay_Batch_Errors(
1563: p_batch_id,
1564: 'VE',
1565: '',

Line 1832: l_error_msg := FND_MESSAGE.GET;

1828: p_return_code OUT NOCOPY NUMBER)IS
1829: l_error_msg VARCHAR2(240);
1830: BEGIN
1831: IF p_exception_details IS NULL THEN
1832: l_error_msg := FND_MESSAGE.GET;
1833: FND_MESSAGE.CLEAR;
1834: ELSE
1835: l_ERROR_MSG := p_exception_details;
1836: END IF;

Line 1833: FND_MESSAGE.CLEAR;

1829: l_error_msg VARCHAR2(240);
1830: BEGIN
1831: IF p_exception_details IS NULL THEN
1832: l_error_msg := FND_MESSAGE.GET;
1833: FND_MESSAGE.CLEAR;
1834: ELSE
1835: l_ERROR_MSG := p_exception_details;
1836: END IF;
1837: HXT_UTIL.GEN_EXCEPTION