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 1010: -- FND_MESSAGE.SET_NAME('HXT','HXT_39348_TC_VAL_NOT_REPROC'); -- HXT11

1006: -- Check for a valid status code
1007: -- IF batch_rec.batch_status = 'VT' THEN
1008: -- null; -- Don't revalidate batches that have been sent to PayMIX ORA128
1009: -- l_final_valid_retcode := 2;
1010: -- FND_MESSAGE.SET_NAME('HXT','HXT_39348_TC_VAL_NOT_REPROC'); -- HXT11
1011: -- Insert_Pay_Batch_Errors( batch_rec.batch_id,
1012: -- 'VE', --SIR020
1013: -- '', --HXT11
1014: -- l_return);

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

1074: -- User Level Data Error for this batch
1075: IF l_valid_retcode = 1 then
1076: HXT_UTIL.DEBUG('Timecard validation warnings.');-- debug only HXT115
1077: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VW'); --SIR020
1078: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); -- HXT11
1079: Insert_Pay_Batch_Errors( batch_rec.batch_id,
1080: 'W',
1081: '', -- HXT11
1082: l_return);

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

1083: END IF;
1084: IF l_valid_retcode >= 2 THEN
1085: HXT_UTIL.DEBUG('Timecard validation errors.');-- debug only HXT115
1086: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VE'); --SIR020
1087: FND_MESSAGE.SET_NAME('HXT','HXT_39349_CHK_IND_TCARD_ERRS'); --HXT11
1088: Insert_Pay_Batch_Errors( batch_rec.batch_id,
1089: 'VE', --SIR020
1090: '', --HXT11
1091: l_return);

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

1098: l_counter := l_counter + 1;
1099: -- Don't allow batches in a Hold status to be Transferred to PayMIX
1100: IF batch_rec.batch_status = 'H' THEN
1101: l_final_valid_retcode := 2;
1102: FND_MESSAGE.SET_NAME('HXT','HXT_39350_CANT_TRANS_HLD_PAYMX');--HXT11
1103: Insert_Pay_Batch_Errors( batch_rec.batch_id,
1104: 'VE', --SIR020
1105: '', -- HXT11
1106: l_return);

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

1106: l_return);
1107: -- Don't move to PayMIX while Timecard errors exist
1108: ELSIF batch_rec.batch_status in ('VE','ET') THEN --SIR020
1109: l_final_valid_retcode := 2;
1110: FND_MESSAGE.SET_NAME('HXT','HXT_39351_CANT_TRANS_ERR_PAYMX');-- HXT11
1111: Insert_Pay_Batch_Errors( batch_rec.batch_id,
1112: 'VE', --SIR020
1113: '', -- HXT11
1114: l_return);

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

1113: '', -- HXT11
1114: l_return);
1115: -- ELSIF (batch_rec.batch_status = 'VT') THEN
1116: -- l_final_valid_retcode := 2;
1117: -- FND_MESSAGE.SET_NAME('HXT','HXT_39352_BTCHS_PREV_TRANS'); -- HXT11
1118: -- Insert_Pay_Batch_Errors( batch_rec.batch_id,
1119: -- 'VE', --SIR020
1120: -- '', -- HXT11
1121: -- l_return);

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

1136: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VE');--SIR020
1137: END IF;
1138: ELSE
1139: l_final_valid_retcode := 2;
1140: FND_MESSAGE.SET_NAME('HXT','HXT_39353_BTCHS_MST_BE_VALDTED');-- HXT11
1141: Insert_Pay_Batch_Errors( batch_rec.batch_id,
1142: 'VE', --SIR020
1143: '', -- HXT11
1144: l_return);

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

1212: END LOOP; -- while more batches exist in the range
1213: -- end SPR C166 BY BC
1214: -- Check for error totals to return a status from concurrent manager.
1215: -- Normal
1216: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL'); -- HXT11
1217: l_errbuf := FND_MESSAGE.GET; -- HXT11
1218: FND_MESSAGE.CLEAR; -- HXT11
1219: l_retcode := 0;
1220: -- No batches seleceted at all

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

1213: -- end SPR C166 BY BC
1214: -- Check for error totals to return a status from concurrent manager.
1215: -- Normal
1216: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL'); -- HXT11
1217: l_errbuf := FND_MESSAGE.GET; -- HXT11
1218: FND_MESSAGE.CLEAR; -- HXT11
1219: l_retcode := 0;
1220: -- No batches seleceted at all
1221: IF l_counter = 0 THEN

Line 1218: FND_MESSAGE.CLEAR; -- HXT11

1214: -- Check for error totals to return a status from concurrent manager.
1215: -- Normal
1216: FND_MESSAGE.SET_NAME('HXT','HXT_39358_COMP_NORMAL'); -- HXT11
1217: l_errbuf := FND_MESSAGE.GET; -- HXT11
1218: FND_MESSAGE.CLEAR; -- HXT11
1219: l_retcode := 0;
1220: -- No batches seleceted at all
1221: IF l_counter = 0 THEN
1222: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL'); -- HXT11

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

1218: FND_MESSAGE.CLEAR; -- HXT11
1219: l_retcode := 0;
1220: -- No batches seleceted at all
1221: IF l_counter = 0 THEN
1222: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL'); -- HXT11
1223: l_errbuf := FND_MESSAGE.GET; -- HXT11
1224: FND_MESSAGE.CLEAR; -- HXT11
1225: l_retcode := 2;
1226: END IF;

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

1219: l_retcode := 0;
1220: -- No batches seleceted at all
1221: IF l_counter = 0 THEN
1222: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL'); -- HXT11
1223: l_errbuf := FND_MESSAGE.GET; -- HXT11
1224: FND_MESSAGE.CLEAR; -- HXT11
1225: l_retcode := 2;
1226: END IF;
1227: IF b_inverted_batch_nums = TRUE THEN

Line 1224: FND_MESSAGE.CLEAR; -- HXT11

1220: -- No batches seleceted at all
1221: IF l_counter = 0 THEN
1222: FND_MESSAGE.SET_NAME('HXT','HXT_39359_NO_BATCHES_SEL'); -- HXT11
1223: l_errbuf := FND_MESSAGE.GET; -- HXT11
1224: FND_MESSAGE.CLEAR; -- HXT11
1225: l_retcode := 2;
1226: END IF;
1227: IF b_inverted_batch_nums = TRUE THEN
1228: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG'); --HXT11

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

1224: FND_MESSAGE.CLEAR; -- HXT11
1225: l_retcode := 2;
1226: END IF;
1227: IF b_inverted_batch_nums = TRUE THEN
1228: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG'); --HXT11
1229: l_errbuf := FND_MESSAGE.GET; -- HXT11
1230: FND_MESSAGE.CLEAR; -- HXT11
1231: l_retcode := 2;
1232: END IF;

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

1225: l_retcode := 2;
1226: END IF;
1227: IF b_inverted_batch_nums = TRUE THEN
1228: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG'); --HXT11
1229: l_errbuf := FND_MESSAGE.GET; -- HXT11
1230: FND_MESSAGE.CLEAR; -- HXT11
1231: l_retcode := 2;
1232: END IF;
1233: IF l_final_rollback_retcode > 0 THEN

Line 1230: FND_MESSAGE.CLEAR; -- HXT11

1226: END IF;
1227: IF b_inverted_batch_nums = TRUE THEN
1228: FND_MESSAGE.SET_NAME('HXT','HXT_39360_STR_BTCH_NUM_TOO_LRG'); --HXT11
1229: l_errbuf := FND_MESSAGE.GET; -- HXT11
1230: FND_MESSAGE.CLEAR; -- HXT11
1231: l_retcode := 2;
1232: END IF;
1233: IF l_final_rollback_retcode > 0 THEN
1234: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK'); -- HXT11

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

1230: FND_MESSAGE.CLEAR; -- HXT11
1231: l_retcode := 2;
1232: END IF;
1233: IF l_final_rollback_retcode > 0 THEN
1234: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK'); -- HXT11
1235: l_errbuf := FND_MESSAGE.GET; -- HXT11
1236: FND_MESSAGE.CLEAR; -- HXT11
1237: l_retcode := 2;
1238: END IF;

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

1231: l_retcode := 2;
1232: END IF;
1233: IF l_final_rollback_retcode > 0 THEN
1234: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK'); -- HXT11
1235: l_errbuf := FND_MESSAGE.GET; -- HXT11
1236: FND_MESSAGE.CLEAR; -- HXT11
1237: l_retcode := 2;
1238: END IF;
1239: -- A warning was returned from the validate process

Line 1236: FND_MESSAGE.CLEAR; -- HXT11

1232: END IF;
1233: IF l_final_rollback_retcode > 0 THEN
1234: FND_MESSAGE.SET_NAME('HXT','HXT_39361_ERR_DURING_ROLLBACK'); -- HXT11
1235: l_errbuf := FND_MESSAGE.GET; -- HXT11
1236: FND_MESSAGE.CLEAR; -- HXT11
1237: l_retcode := 2;
1238: END IF;
1239: -- A warning was returned from the validate process
1240: IF l_final_valid_retcode = 1 THEN

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

1241: l_retcode := 1;
1242: END IF;
1243: IF l_final_valid_retcode = 2 THEN
1244: HXT_UTIL.DEBUG('l_final_valid_retcode is 2');-- debug only --HXT115
1245: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR'); -- HXT11
1246: l_errbuf := FND_MESSAGE.GET; -- HXT11
1247: FND_MESSAGE.CLEAR; -- HXT11
1248: l_retcode := 2;
1249: END IF;

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

1242: END IF;
1243: IF l_final_valid_retcode = 2 THEN
1244: HXT_UTIL.DEBUG('l_final_valid_retcode is 2');-- debug only --HXT115
1245: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR'); -- HXT11
1246: l_errbuf := FND_MESSAGE.GET; -- HXT11
1247: FND_MESSAGE.CLEAR; -- HXT11
1248: l_retcode := 2;
1249: END IF;
1250: -- a system level error occured somewhere during processing

Line 1247: FND_MESSAGE.CLEAR; -- HXT11

1243: IF l_final_valid_retcode = 2 THEN
1244: HXT_UTIL.DEBUG('l_final_valid_retcode is 2');-- debug only --HXT115
1245: FND_MESSAGE.SET_NAME('HXT','HXT_39362_BATCH_ERROR'); -- HXT11
1246: l_errbuf := FND_MESSAGE.GET; -- HXT11
1247: FND_MESSAGE.CLEAR; -- HXT11
1248: l_retcode := 2;
1249: END IF;
1250: -- a system level error occured somewhere during processing
1251: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN

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

1248: l_retcode := 2;
1249: END IF;
1250: -- a system level error occured somewhere during processing
1251: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN
1252: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR'); -- HXT11
1253: l_errbuf := FND_MESSAGE.GET; -- HXT11
1254: FND_MESSAGE.CLEAR; -- HXT11
1255: l_retcode := 2;
1256: END IF;

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

1249: END IF;
1250: -- a system level error occured somewhere during processing
1251: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN
1252: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR'); -- HXT11
1253: l_errbuf := FND_MESSAGE.GET; -- HXT11
1254: FND_MESSAGE.CLEAR; -- HXT11
1255: l_retcode := 2;
1256: END IF;
1257: retcode := l_retcode;

Line 1254: FND_MESSAGE.CLEAR; -- HXT11

1250: -- a system level error occured somewhere during processing
1251: IF (l_final_valid_retcode = 3 OR l_final_sum_retcode = 3) THEN
1252: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR'); -- HXT11
1253: l_errbuf := FND_MESSAGE.GET; -- HXT11
1254: FND_MESSAGE.CLEAR; -- HXT11
1255: l_retcode := 2;
1256: END IF;
1257: retcode := l_retcode;
1258: errbuf := l_errbuf;

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

1281:
1282: EXCEPTION
1283: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00 TESTING
1284: HXT_UTIL.DEBUG('Oops...g_lookup_not_found in procedure sum_to_mix');
1285: l_errbuf := substr(FND_MESSAGE.GET,1,65);
1286: errbuf := l_errbuf;
1287: HXT_BATCH_PROCESS.Insert_Pay_Batch_Errors( l_batch_id,
1288: 'VE', -- RETROPAY
1289: '',

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

1295: COMMIT;
1296: END IF;
1297: WHEN g_rollback_error THEN --SIR517 PWM 18FEB00 TESTING
1298: HXT_UTIL.DEBUG('Oops...Rollback Error');
1299: l_errbuf := substr(FND_MESSAGE.GET,1,65);
1300: errbuf := l_errbuf;
1301: FND_FILE.put_line(fnd_file.log,errbuf);
1302: raise;
1303: WHEN OTHERS THEN

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

1303: WHEN OTHERS THEN
1304: -- Bug 10143866
1305: hr_utility.trace(dbms_utility.format_error_backtrace);
1306: retcode := 2;
1307: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
1308: l_errbuf := FND_MESSAGE.GET;
1309: FND_MESSAGE.CLEAR;
1310: errbuf := l_errbuf;
1311: Set_Batch_Status(l_date_earned, l_batch_id, 'VE');

Line 1308: l_errbuf := FND_MESSAGE.GET;

1304: -- Bug 10143866
1305: hr_utility.trace(dbms_utility.format_error_backtrace);
1306: retcode := 2;
1307: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
1308: l_errbuf := FND_MESSAGE.GET;
1309: FND_MESSAGE.CLEAR;
1310: errbuf := l_errbuf;
1311: Set_Batch_Status(l_date_earned, l_batch_id, 'VE');
1312: Insert_Pay_Batch_Errors( l_batch_id,

Line 1309: FND_MESSAGE.CLEAR;

1305: hr_utility.trace(dbms_utility.format_error_backtrace);
1306: retcode := 2;
1307: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
1308: l_errbuf := FND_MESSAGE.GET;
1309: FND_MESSAGE.CLEAR;
1310: errbuf := l_errbuf;
1311: Set_Batch_Status(l_date_earned, l_batch_id, 'VE');
1312: Insert_Pay_Batch_Errors( l_batch_id,
1313: 'VE',

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

1358: IF get_meaning_cur%NOTFOUND then
1359: if g_debug then
1360: hr_utility.set_location('convert_lookup',30);
1361: end if;
1362: FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
1363: FND_MESSAGE.SET_TOKEN('CODE', p_lookup_code);
1364: FND_MESSAGE.SET_TOKEN('TYPE', p_lookup_type);
1365: RAISE g_lookup_not_found;
1366: END IF;

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

1359: if g_debug then
1360: hr_utility.set_location('convert_lookup',30);
1361: end if;
1362: FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
1363: FND_MESSAGE.SET_TOKEN('CODE', p_lookup_code);
1364: FND_MESSAGE.SET_TOKEN('TYPE', p_lookup_type);
1365: RAISE g_lookup_not_found;
1366: END IF;
1367: ELSE

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

1360: hr_utility.set_location('convert_lookup',30);
1361: end if;
1362: FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
1363: FND_MESSAGE.SET_TOKEN('CODE', p_lookup_code);
1364: FND_MESSAGE.SET_TOKEN('TYPE', p_lookup_type);
1365: RAISE g_lookup_not_found;
1366: END IF;
1367: ELSE
1368: if g_debug then

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

1417: if g_debug then
1418: hr_utility.set_location('get_lookup_code',30);
1419: hr_utility.trace('get_lookup_code_cur NOT FOUND');
1420: end if;
1421: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
1422: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
1423: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
1424: -- RAISE g_lookup_not_found;
1425: null; -- This is done to fix bug 1761779 -- 17/May/2001

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

1418: hr_utility.set_location('get_lookup_code',30);
1419: hr_utility.trace('get_lookup_code_cur NOT FOUND');
1420: end if;
1421: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
1422: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
1423: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
1424: -- RAISE g_lookup_not_found;
1425: null; -- This is done to fix bug 1761779 -- 17/May/2001
1426: END IF;

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

1419: hr_utility.trace('get_lookup_code_cur NOT FOUND');
1420: end if;
1421: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
1422: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
1423: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
1424: -- RAISE g_lookup_not_found;
1425: null; -- This is done to fix bug 1761779 -- 17/May/2001
1426: END IF;
1427: ELSE

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

2412: RAISE g_lookup_not_found; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
2413: WHEN others THEN
2414: HXT_UTIL.DEBUG(sqlerrm); --HXT115
2415: HXT_UTIL.DEBUG('Oops...others'); --HXT115
2416: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
2417: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2418: Insert_Pay_Batch_Errors( p_values_rec.batch_id, 'VE', '', l_return);
2419: p_sum_retcode := 3;
2420: -- Bug 10143866

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

2413: WHEN others THEN
2414: HXT_UTIL.DEBUG(sqlerrm); --HXT115
2415: HXT_UTIL.DEBUG('Oops...others'); --HXT115
2416: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
2417: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2418: Insert_Pay_Batch_Errors( p_values_rec.batch_id, 'VE', '', l_return);
2419: p_sum_retcode := 3;
2420: -- Bug 10143866
2421: hr_utility.trace(dbms_utility.format_error_backtrace);

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

2552: raise g_lookup_not_found ; --propogate to the calling procedure
2553: WHEN g_error_ins_batch_lines THEN --SIR517 PWM 18FEB00
2554: ROLLBACK; --115.37
2555: HXT_UTIL.DEBUG('Error attempting to insert paymix information');
2556: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
2557: FND_MESSAGE.SET_TOKEN('SQLERR',sqlerrm);
2558: Insert_Pay_Batch_Errors( p_batch_id, 'VE', '', l_return);
2559: HXT_UTIL.DEBUG(' back from calling insert_pay_batch_errors');
2560: p_sum_retcode := 3;

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

2553: WHEN g_error_ins_batch_lines THEN --SIR517 PWM 18FEB00
2554: ROLLBACK; --115.37
2555: HXT_UTIL.DEBUG('Error attempting to insert paymix information');
2556: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
2557: FND_MESSAGE.SET_TOKEN('SQLERR',sqlerrm);
2558: Insert_Pay_Batch_Errors( p_batch_id, 'VE', '', l_return);
2559: HXT_UTIL.DEBUG(' back from calling insert_pay_batch_errors');
2560: p_sum_retcode := 3;
2561: raise g_error_ins_batch_lines ;

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

2562: WHEN others THEN
2563: ROLLBACK; --115.37
2564: HXT_UTIL.DEBUG(sqlerrm);
2565: HXT_UTIL.DEBUG('Oops...others');
2566: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
2567: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2568: Insert_Pay_Batch_Errors( p_batch_id, 'VE', '', l_return);
2569: p_sum_retcode := 3;
2570: -- Bug 10143866

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

2563: ROLLBACK; --115.37
2564: HXT_UTIL.DEBUG(sqlerrm);
2565: HXT_UTIL.DEBUG('Oops...others');
2566: FND_MESSAGE.SET_NAME('HXT','HXT_39354_ERR_INS_PAYMX_INFO');
2567: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2568: Insert_Pay_Batch_Errors( p_batch_id, 'VE', '', l_return);
2569: p_sum_retcode := 3;
2570: -- Bug 10143866
2571: hr_utility.trace(dbms_utility.format_error_backtrace);

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

2617: end if;
2618: --DEBUG ONLY END*/
2619: EXCEPTION
2620: WHEN OTHERS THEN
2621: FND_MESSAGE.SET_NAME('HXT','HXT_39357_BATCH_ERR');
2622: FND_MESSAGE.SET_TOKEN('MESSAGE', l_errbuf);
2623: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2624: Insert_Pay_Batch_Errors(
2625: p_batch_id,

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

2618: --DEBUG ONLY END*/
2619: EXCEPTION
2620: WHEN OTHERS THEN
2621: FND_MESSAGE.SET_NAME('HXT','HXT_39357_BATCH_ERR');
2622: FND_MESSAGE.SET_TOKEN('MESSAGE', l_errbuf);
2623: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2624: Insert_Pay_Batch_Errors(
2625: p_batch_id,
2626: 'VE',

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

2619: EXCEPTION
2620: WHEN OTHERS THEN
2621: FND_MESSAGE.SET_NAME('HXT','HXT_39357_BATCH_ERR');
2622: FND_MESSAGE.SET_TOKEN('MESSAGE', l_errbuf);
2623: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2624: Insert_Pay_Batch_Errors(
2625: p_batch_id,
2626: 'VE',
2627: '',

Line 2995: l_error_msg := FND_MESSAGE.GET;

2991: p_return_code OUT NOCOPY NUMBER)IS
2992: l_error_msg VARCHAR2(240);
2993: BEGIN
2994: IF p_exception_details IS NULL THEN
2995: l_error_msg := FND_MESSAGE.GET;
2996: FND_MESSAGE.CLEAR;
2997: ELSE
2998: l_ERROR_MSG := p_exception_details;
2999: END IF;

Line 2996: FND_MESSAGE.CLEAR;

2992: l_error_msg VARCHAR2(240);
2993: BEGIN
2994: IF p_exception_details IS NULL THEN
2995: l_error_msg := FND_MESSAGE.GET;
2996: FND_MESSAGE.CLEAR;
2997: ELSE
2998: l_ERROR_MSG := p_exception_details;
2999: END IF;
3000: HXT_UTIL.GEN_EXCEPTION