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 HXT_UTIL

Line 912: HXT_UTIL.DEBUG('Start process.');-- debug only --HXT115

908: end if;
909:
910:
911: l_date_earned := to_date(to_char(trunc(l_date_earned),'DD/MM/RRRR'),'DD/MM/RRRR');
912: HXT_UTIL.DEBUG('Start process.');-- debug only --HXT115
913: g_time_period_id := p_time_period_id;
914: l_payroll_id := to_char(p_payroll_id);
915: --
916: --Validate and Transfer, Transfer, or Rollback TAMS/O data

Line 936: HXT_UTIL.DEBUG('A range has been selected by the user');-- debug only --HXT115

932: --
933: -- Determine if a range has been selected by the user
934: --
935: IF l_starting_batch_num IS NOT NULL AND l_ending_batch_num IS NOT NULL THEN
936: HXT_UTIL.DEBUG('A range has been selected by the user');-- debug only --HXT115
937: b_range_is_active := TRUE;
938: l_batch_requested := l_starting_batch_num;
939: IF l_starting_batch_num > l_ending_batch_num THEN
940: b_we_have_batches := FALSE;

Line 951: HXT_UTIL.DEBUG('Beginning we have batches loop');-- debug only --HXT115

947: -- requested)
948: --
949: WHILE b_we_have_batches LOOP
950: BEGIN
951: HXT_UTIL.DEBUG('Beginning we have batches loop');-- debug only --HXT115
952: --
953: -- Select and process all user specified batches for this payroll/reference
954: -- number
955: -- Process batch range specified by the user, else do all available

Line 964: HXT_UTIL.DEBUG('Batch number is ' || TO_CHAR(batch_rec.batch_id));

960: g_time_period_id,
961: l_batch_requested,
962: p_ref_num)
963: LOOP
964: HXT_UTIL.DEBUG('Batch number is ' || TO_CHAR(batch_rec.batch_id));
965: l_batch_id := batch_rec.batch_id;
966: -- l_counter := l_counter + 1;
967: --
968: -- rollback all PayMix data per user request

Line 972: HXT_UTIL.DEBUG('Now ROLLING BACK');-- debug only --HXT115

968: -- rollback all PayMix data per user request
969: --
970: IF p_process_mode = 'D' and batch_rec.batch_status = 'VT' THEN --2709527
971: l_counter := l_counter + 1;
972: HXT_UTIL.DEBUG('Now ROLLING BACK');-- debug only --HXT115
973: -- Delete prior errors for this batch
974: -- Del_Prior_Errors(batch_rec.batch_id);
975: rollback_paymix(batch_rec.batch_id,
976: g_time_period_id, l_rollback_retcode); --SPR C166 BY BC

Line 1020: HXT_UTIL.DEBUG('Begin timecard validation.');-- debug only --HXT115

1016: --
1017: -- Validate batch, status:0=Normal, 1=Warning,
1018: -- 2=Stop Level Data Error, 3=System
1019: --
1020: HXT_UTIL.DEBUG('Begin timecard validation.');-- debug only --HXT115
1021: -- Delete prior errors for this batch
1022: -- Del_Prior_Errors(batch_rec.batch_id);
1023: HXT_BATCH_VAL.Val_Batch(batch_rec.batch_id,
1024: g_time_period_id,

Line 1070: HXT_UTIL.DEBUG('Successful timecard validation.');--debug onlyHXT115

1066: l_final_valid_retcode := l_valid_retcode;
1067: END IF;
1068: -- Successful Validation, Set batch to ready Status
1069: IF l_valid_retcode = 0 then
1070: HXT_UTIL.DEBUG('Successful timecard validation.');--debug onlyHXT115
1071: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VV'); --SIR020
1072: END IF;
1073: -- set status to Warning and lets user know we have a TAMS/O
1074: -- User Level Data Error for this batch

Line 1076: HXT_UTIL.DEBUG('Timecard validation warnings.');-- debug only HXT115

1072: END IF;
1073: -- set status to Warning and lets user know we have a TAMS/O
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',

Line 1085: HXT_UTIL.DEBUG('Timecard validation errors.');-- debug only HXT115

1081: '', -- HXT11
1082: l_return);
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

Line 1124: HXT_UTIL.DEBUG('Now moving to BEE.');-- debug only --HXT115

1120: -- '', -- HXT11
1121: -- l_return);
1122: ELSIF batch_rec.batch_status in ('VV','VW') THEN --SIR020
1123: -- move to PayMIX
1124: HXT_UTIL.DEBUG('Now moving to BEE.');-- debug only --HXT115
1125: sum_to_mix(batch_rec.batch_id, g_time_period_id, l_sum_retcode);
1126: IF l_sum_retcode > l_final_sum_retcode then
1127: l_final_sum_retcode := l_sum_retcode;
1128: END IF;

Line 1130: HXT_UTIL.DEBUG('Successful move to BEE.');-- debug only --HXT115

1126: IF l_sum_retcode > l_final_sum_retcode then
1127: l_final_sum_retcode := l_sum_retcode;
1128: END IF;
1129: IF (l_sum_retcode = 0) then
1130: HXT_UTIL.DEBUG('Successful move to BEE.');-- debug only --HXT115
1131: -- bug 848062 Fassadi the p_date_earned replaced with l_date_earned.
1132: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VT');
1133: END IF;
1134: IF (l_sum_retcode = 3) then

Line 1135: HXT_UTIL.DEBUG('Error moving to BEE.');-- debug only --HXT115

1131: -- bug 848062 Fassadi the p_date_earned replaced with l_date_earned.
1132: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VT');
1133: END IF;
1134: IF (l_sum_retcode = 3) then
1135: HXT_UTIL.DEBUG('Error moving to BEE.');-- debug only --HXT115
1136: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VE');--SIR020
1137: END IF;
1138: ELSE
1139: l_final_valid_retcode := 2;

Line 1244: HXT_UTIL.DEBUG('l_final_valid_retcode is 2');-- debug only --HXT115

1240: IF l_final_valid_retcode = 1 THEN
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;

Line 1259: HXT_UTIL.DEBUG('Retcode:' || TO_CHAR(l_retcode) || ' ' || l_errbuf);-- debug only

1255: l_retcode := 2;
1256: END IF;
1257: retcode := l_retcode;
1258: errbuf := l_errbuf;
1259: HXT_UTIL.DEBUG('Retcode:' || TO_CHAR(l_retcode) || ' ' || l_errbuf);-- debug only
1260:
1261: /********Bug: 4620315 **********/
1262: /*** To merge the batch TCs by calling 'merge_batches' procedure ***/
1263:

Line 1284: HXT_UTIL.DEBUG('Oops...g_lookup_not_found in procedure sum_to_mix');

1280: END IF;
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

Line 1298: HXT_UTIL.DEBUG('Oops...Rollback Error');

1294: IF retcode = 2 THEN /* Bug: 6064910 */
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;

Line 1340: HXT_UTIL.DEBUG('convert_lookup - code = '||p_lookup_code||'

1336:
1337: if g_debug then
1338: hr_utility.set_location('convert_lookup',10);
1339: end if;
1340: HXT_UTIL.DEBUG('convert_lookup - code = '||p_lookup_code||'
1341: type = '||p_lookup_type||' date = '||fnd_date.date_to_chardate(p_date_active));
1342:
1343:
1344: -- Bug 8888777

Line 1402: HXT_UTIL.DEBUG('get_lookup_ code for meaning = '||p_meaning||'

1398: g_debug :=hr_utility.debug_enabled;
1399: if g_debug then
1400: hr_utility.set_location('get_lookup_code',10);
1401: end if;
1402: HXT_UTIL.DEBUG('get_lookup_ code for meaning = '||p_meaning||'
1403: type = '||'NAME_TRANSLATIONS'||' date = '||fnd_date.date_to_chardate(p_date_active));
1404: if g_debug then
1405: hr_utility.trace('p_meaning :'||p_meaning);
1406: end if;

Line 1444: -- HXT_UTIL.DEBUG('Putting OTM data into BEE values per input values'); --HXT115

1440: end if;
1441: RETURN l_lookup_code;
1442: END get_lookup_code;
1443: -- Place OTM data into BEE values per input values
1444: -- HXT_UTIL.DEBUG('Putting OTM data into BEE values per input values'); --HXT115
1445: -- In order to get the input-value logic work in different legislations we need
1446: -- to create (SEED) new lookups for 'Hours' , 'Hourly Rate', 'Rate Multiple',
1447: -- and 'Rate Code' with lookup_type of 'NAME_TRANSLATION' and lookup_code
1448: -- of 'HOURS', 'HOURLY_RATE', 'RATE_MULTIPLE' and 'RATE_CODE' respectively.

Line 1727: HXT_UTIL.DEBUG('Getting input values for element '||to_char(p_values_rec.element_type_id)||' date '||fnd_date.date_to_chardate(p_values_rec.date_worked)); --FORMS60 --HXT115

1723: CLOSE get_input_values;
1724: END IF;
1725:
1726: -- Get input values details for this element
1727: HXT_UTIL.DEBUG('Getting input values for element '||to_char(p_values_rec.element_type_id)||' date '||fnd_date.date_to_chardate(p_values_rec.date_worked)); --FORMS60 --HXT115
1728:
1729: -- Bug 12993528
1730: -- Replaced the pay_paywsqee_pkg call with our own new procedure.
1731: -- Added new params otl_sequence for each of the 15 input values.

Line 1800: HXT_UTIL.DEBUG('Putting OTM data into BEE values per input values'); --HXT115

1796: if g_debug then
1797: hr_utility.set_location('dtl_to_BEE',20);
1798: end if;
1799: -- Place OTM data into BEE values per input values
1800: HXT_UTIL.DEBUG('Putting OTM data into BEE values per input values'); --HXT115
1801: --
1802: -- In order to get the input-value logic work in different legislations we
1803: -- need to create (SEED) new lookups for 'Hours', 'Hourly Rate',
1804: -- 'Rate Multiple', and 'Rate Code' with lookup_type of 'NAME_TRANSLATION'

Line 2175: HXT_UTIL.DEBUG('value_'||to_char(i)||' = '||pbl_value(i)); --HXT115

2171: end if;
2172: if g_debug then
2173: hr_utility.set_location('dtl_to_BEE',190);
2174: end if;
2175: HXT_UTIL.DEBUG('value_'||to_char(i)||' = '||pbl_value(i)); --HXT115
2176: END LOOP;
2177: -- Get Batch Line ID
2178: if g_debug then
2179: hr_utility.set_location('dtl_to_BEE',200);

Line 2186: HXT_UTIL.DEBUG('batch_sequence = '||to_char(p_batch_sequence)); --HXT115

2182: -- l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_values_rec.batch_id);
2183: if g_debug then
2184: hr_utility.set_location('dtl_to_BEE',210);
2185: end if;
2186: HXT_UTIL.DEBUG('batch_sequence = '||to_char(p_batch_sequence)); --HXT115
2187: -- Insert data into BEE table
2188: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_line
2189: (p_session_date => sysdate
2190: ,p_batch_id => p_values_rec.batch_id

Line 2254: HXT_UTIL.DEBUG('Successful INSERT INTO pay_batch_lines'); --HXT115

2250: ,p_batch_line_id => l_batch_line_id
2251: ,p_object_version_number => l_line_ovn
2252: ,p_iv_all_internal_format => g_IV_format -- Bug 8888777
2253: );
2254: HXT_UTIL.DEBUG('Successful INSERT INTO pay_batch_lines'); --HXT115
2255: -- Update OTM detail row to show BEE line entry id
2256: IF p_values_rec.hrw_rowid IS NOT NULL THEN
2257: UPDATE HXT_DET_HOURS_WORKED_F
2258: set PBL_LINE_ID = l_batch_line_id

Line 2407: HXT_UTIL.DEBUG('Successful UPDATE hxt_det_hours_worked_f'); --HXT115

2403: END IF;
2404:
2405: END IF;
2406:
2407: HXT_UTIL.DEBUG('Successful UPDATE hxt_det_hours_worked_f'); --HXT115
2408: EXCEPTION
2409: WHEN g_lookup_not_found THEN
2410: HXT_UTIL.DEBUG('Oops...g_lookup_not_found'); --HXT115
2411: p_sum_retcode := 3;

Line 2410: HXT_UTIL.DEBUG('Oops...g_lookup_not_found'); --HXT115

2406:
2407: HXT_UTIL.DEBUG('Successful UPDATE hxt_det_hours_worked_f'); --HXT115
2408: EXCEPTION
2409: WHEN g_lookup_not_found THEN
2410: HXT_UTIL.DEBUG('Oops...g_lookup_not_found'); --HXT115
2411: p_sum_retcode := 3;
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

Line 2414: HXT_UTIL.DEBUG(sqlerrm); --HXT115

2410: HXT_UTIL.DEBUG('Oops...g_lookup_not_found'); --HXT115
2411: p_sum_retcode := 3;
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);

Line 2415: HXT_UTIL.DEBUG('Oops...others'); --HXT115

2411: p_sum_retcode := 3;
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;

Line 2546: HXT_UTIL.DEBUG('Successful COMMIT');

2542: -- update in the Retrieval Dashboard tables.
2543: snap_retrieval_details(p_batch_id);
2544:
2545: COMMIT; --115.37
2546: HXT_UTIL.DEBUG('Successful COMMIT');
2547: EXCEPTION
2548: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00
2549: ROLLBACK; --115.37
2550: HXT_UTIL.DEBUG('Oops...g_lookup_not_found in procedure sum_to_mix');

Line 2550: HXT_UTIL.DEBUG('Oops...g_lookup_not_found in procedure sum_to_mix');

2546: HXT_UTIL.DEBUG('Successful COMMIT');
2547: EXCEPTION
2548: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00
2549: ROLLBACK; --115.37
2550: HXT_UTIL.DEBUG('Oops...g_lookup_not_found in procedure sum_to_mix');
2551: p_sum_retcode := 3;
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

Line 2555: HXT_UTIL.DEBUG('Error attempting to insert paymix information');

2551: p_sum_retcode := 3;
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');

Line 2559: HXT_UTIL.DEBUG(' back from calling insert_pay_batch_errors');

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 ;
2562: WHEN others THEN
2563: ROLLBACK; --115.37

Line 2564: HXT_UTIL.DEBUG(sqlerrm);

2560: p_sum_retcode := 3;
2561: raise g_error_ins_batch_lines ;
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);

Line 2565: HXT_UTIL.DEBUG('Oops...others');

2561: raise g_error_ins_batch_lines ;
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;

Line 2642: HXT_UTIL.GEN_EXCEPTION

2638: ,p_oracle_error_text IN VARCHAR2 default NULL )
2639: RETURN NUMBER IS
2640: -- calls error processing procedure --
2641: BEGIN
2642: HXT_UTIL.GEN_EXCEPTION
2643: (p_location||'. Batch Id = '||to_char(p_batch_id)
2644: ,p_error_text
2645: ,p_oracle_error_text
2646: ,null);

Line 2908: -- HXT_UTIL.DEBUG(batch_line_rec.assignment_number);--debug only HXT115

2904: -- Delete batch lines for the time period selected by the user
2905: -- Delete any existing batch line errors
2906: --HXT11FOR batch_line_rec IN batch_line_cur(l_period_start_date, l_period_end_date) LOOP
2907: FOR batch_line_rec IN batch_line_cur LOOP --HXT11
2908: -- HXT_UTIL.DEBUG(batch_line_rec.assignment_number);--debug only HXT115
2909: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.from_date));--debug only HXT115
2910: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.to_date));--debug only HXT115
2911: -- Locate the Timecard associated with this particular batch line.
2912: -- we will create a new batch, the first time we enter this loop

Line 2909: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.from_date));--debug only HXT115

2905: -- Delete any existing batch line errors
2906: --HXT11FOR batch_line_rec IN batch_line_cur(l_period_start_date, l_period_end_date) LOOP
2907: FOR batch_line_rec IN batch_line_cur LOOP --HXT11
2908: -- HXT_UTIL.DEBUG(batch_line_rec.assignment_number);--debug only HXT115
2909: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.from_date));--debug only HXT115
2910: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.to_date));--debug only HXT115
2911: -- Locate the Timecard associated with this particular batch line.
2912: -- we will create a new batch, the first time we enter this loop
2913: if not l_batch_created then

Line 2910: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.to_date));--debug only HXT115

2906: --HXT11FOR batch_line_rec IN batch_line_cur(l_period_start_date, l_period_end_date) LOOP
2907: FOR batch_line_rec IN batch_line_cur LOOP --HXT11
2908: -- HXT_UTIL.DEBUG(batch_line_rec.assignment_number);--debug only HXT115
2909: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.from_date));--debug only HXT115
2910: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.to_date));--debug only HXT115
2911: -- Locate the Timecard associated with this particular batch line.
2912: -- we will create a new batch, the first time we enter this loop
2913: if not l_batch_created then
2914: SELECT business_group_id, batch_name, batch_reference

Line 2978: HXT_UTIL.DEBUG('Error: ' || sqlerrm); --HXT115

2974: -- Bug 13388573
2975: -- Modified this section to do ROLLBACK first and then Raise instead of adjustng batch status.
2976: WHEN OTHERS THEN
2977: ROLLBACK;
2978: HXT_UTIL.DEBUG('Error: ' || sqlerrm); --HXT115
2979: l_sql_error := sqlerrm;
2980: FND_FILE.put_line(fnd_file.log,'Error: '||sqlerrm);
2981: p_rollback_retcode := 3;
2982: -- Bug 10143866

Line 3000: HXT_UTIL.GEN_EXCEPTION

2996: FND_MESSAGE.CLEAR;
2997: ELSE
2998: l_ERROR_MSG := p_exception_details;
2999: END IF;
3000: HXT_UTIL.GEN_EXCEPTION
3001: ('Batch processing. Batch Id = '||to_char(p_batch_id)
3002: ,l_error_msg
3003: ,null
3004: ,null);

Line 3036: HXT_UTIL.GEN_ERROR(p_batch_id

3032: BEGIN
3033: OPEN tim_dates;
3034: FETCH tim_dates into l_eff_start, l_eff_end;
3035: if tim_dates%FOUND then
3036: HXT_UTIL.GEN_ERROR(p_batch_id
3037: , p_tim_id
3038: , p_hrw_id
3039: , p_time_period_id
3040: , p_error_msg