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 451: HXT_UTIL.DEBUG('Start process.');-- debug only --HXT115

447: end if;
448:
449:
450: l_date_earned := to_date(to_char(trunc(l_date_earned),'DD/MM/RRRR'),'DD/MM/RRRR');
451: HXT_UTIL.DEBUG('Start process.');-- debug only --HXT115
452: g_time_period_id := p_time_period_id;
453: l_payroll_id := to_char(p_payroll_id);
454: --
455: --Validate and Transfer, Transfer, or Rollback TAMS/O data

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

471: --
472: -- Determine if a range has been selected by the user
473: --
474: IF l_starting_batch_num IS NOT NULL AND l_ending_batch_num IS NOT NULL THEN
475: HXT_UTIL.DEBUG('A range has been selected by the user');-- debug only --HXT115
476: b_range_is_active := TRUE;
477: l_batch_requested := l_starting_batch_num;
478: IF l_starting_batch_num > l_ending_batch_num THEN
479: b_we_have_batches := FALSE;

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

486: -- requested)
487: --
488: WHILE b_we_have_batches LOOP
489: BEGIN
490: HXT_UTIL.DEBUG('Beginning we have batches loop');-- debug only --HXT115
491: --
492: -- Select and process all user specified batches for this payroll/reference
493: -- number
494: -- Process batch range specified by the user, else do all available

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

499: g_time_period_id,
500: l_batch_requested,
501: p_ref_num)
502: LOOP
503: HXT_UTIL.DEBUG('Batch number is ' || TO_CHAR(batch_rec.batch_id));
504: l_batch_id := batch_rec.batch_id;
505: -- l_counter := l_counter + 1;
506: --
507: -- rollback all PayMix data per user request

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

507: -- rollback all PayMix data per user request
508: --
509: IF p_process_mode = 'D' and batch_rec.batch_status = 'VT' THEN --2709527
510: l_counter := l_counter + 1;
511: HXT_UTIL.DEBUG('Now ROLLING BACK');-- debug only --HXT115
512: -- Delete prior errors for this batch
513: -- Del_Prior_Errors(batch_rec.batch_id);
514: rollback_paymix(batch_rec.batch_id,
515: g_time_period_id, l_rollback_retcode); --SPR C166 BY BC

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

555: --
556: -- Validate batch, status:0=Normal, 1=Warning,
557: -- 2=Stop Level Data Error, 3=System
558: --
559: HXT_UTIL.DEBUG('Begin timecard validation.');-- debug only --HXT115
560: -- Delete prior errors for this batch
561: -- Del_Prior_Errors(batch_rec.batch_id);
562: HXT_BATCH_VAL.Val_Batch(batch_rec.batch_id,
563: g_time_period_id,

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

605: l_final_valid_retcode := l_valid_retcode;
606: END IF;
607: -- Successful Validation, Set batch to ready Status
608: IF l_valid_retcode = 0 then
609: HXT_UTIL.DEBUG('Successful timecard validation.');--debug onlyHXT115
610: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VV'); --SIR020
611: END IF;
612: -- set status to Warning and lets user know we have a TAMS/O
613: -- User Level Data Error for this batch

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

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

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

620: '', -- HXT11
621: l_return);
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

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

659: -- '', -- HXT11
660: -- l_return);
661: ELSIF batch_rec.batch_status in ('VV','VW') THEN --SIR020
662: -- move to PayMIX
663: HXT_UTIL.DEBUG('Now moving to BEE.');-- debug only --HXT115
664: sum_to_mix(batch_rec.batch_id, g_time_period_id, l_sum_retcode);
665: IF l_sum_retcode > l_final_sum_retcode then
666: l_final_sum_retcode := l_sum_retcode;
667: END IF;

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

665: IF l_sum_retcode > l_final_sum_retcode then
666: l_final_sum_retcode := l_sum_retcode;
667: END IF;
668: IF (l_sum_retcode = 0) then
669: HXT_UTIL.DEBUG('Successful move to BEE.');-- debug only --HXT115
670: -- bug 848062 Fassadi the p_date_earned replaced with l_date_earned.
671: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VT');
672: END IF;
673: IF (l_sum_retcode = 3) then

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

670: -- bug 848062 Fassadi the p_date_earned replaced with l_date_earned.
671: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VT');
672: END IF;
673: IF (l_sum_retcode = 3) then
674: HXT_UTIL.DEBUG('Error moving to BEE.');-- debug only --HXT115
675: Set_Batch_Status(l_date_earned, batch_rec.batch_id, 'VE');--SIR020
676: END IF;
677: ELSE
678: l_final_valid_retcode := 2;

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

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

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

779: l_retcode := 2;
780: END IF;
781: retcode := l_retcode;
782: errbuf := l_errbuf;
783: HXT_UTIL.DEBUG('Retcode:' || TO_CHAR(l_retcode) || ' ' || l_errbuf);-- debug only
784:
785: /********Bug: 4620315 **********/
786: /*** To merge the batch TCs by calling 'merge_batches' procedure ***/
787:

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

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

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

852:
853: if g_debug then
854: hr_utility.set_location('convert_lookup',10);
855: end if;
856: HXT_UTIL.DEBUG('convert_lookup - code = '||p_lookup_code||'
857: type = '||p_lookup_type||' date = '||fnd_date.date_to_chardate(p_date_active));
858: IF p_lookup_type IS NOT NULL AND p_lookup_code IS NOT NULL THEN
859: if g_debug then
860: hr_utility.set_location('convert_lookup',20);

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

907: g_debug :=hr_utility.debug_enabled;
908: if g_debug then
909: hr_utility.set_location('get_lookup_code',10);
910: end if;
911: HXT_UTIL.DEBUG('get_lookup_ code for meaning = '||p_meaning||'
912: type = '||'NAME_TRANSLATIONS'||' date = '||fnd_date.date_to_chardate(p_date_active));
913: if g_debug then
914: hr_utility.trace('p_meaning :'||p_meaning);
915: end if;

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

949: end if;
950: RETURN l_lookup_code;
951: END get_lookup_code;
952: -- Place OTM data into BEE values per input values
953: -- HXT_UTIL.DEBUG('Putting OTM data into BEE values per input values'); --HXT115
954: -- In order to get the input-value logic work in different legislations we need
955: -- to create (SEED) new lookups for 'Hours' , 'Hourly Rate', 'Rate Multiple',
956: -- and 'Rate Code' with lookup_type of 'NAME_TRANSLATION' and lookup_code
957: -- of 'HOURS', 'HOURLY_RATE', 'RATE_MULTIPLE' and 'RATE_CODE' respectively.

Line 1033: 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

1029: hxt_value(i).name := null;
1030: hxt_value(i).lookup := null;
1031: END LOOP;
1032: -- Get input values details for this element
1033: 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
1034: pay_paywsqee_pkg.GET_INPUT_VALUE_DETAILS(p_values_rec.element_type_id,
1035: p_values_rec.date_worked,
1036: hxt_value(1).sequence,
1037: hxt_value(2).sequence,

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

1081: if g_debug then
1082: hr_utility.set_location('dtl_to_BEE',20);
1083: end if;
1084: -- Place OTM data into BEE values per input values
1085: HXT_UTIL.DEBUG('Putting OTM data into BEE values per input values'); --HXT115
1086: --
1087: -- In order to get the input-value logic work in different legislations we
1088: -- need to create (SEED) new lookups for 'Hours', 'Hourly Rate',
1089: -- 'Rate Multiple', and 'Rate Code' with lookup_type of 'NAME_TRANSLATION'

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

1276: end if;
1277: if g_debug then
1278: hr_utility.set_location('dtl_to_BEE',190);
1279: end if;
1280: HXT_UTIL.DEBUG('value_'||to_char(i)||' = '||pbl_value(i)); --HXT115
1281: END LOOP;
1282: -- Get Batch Line ID
1283: if g_debug then
1284: hr_utility.set_location('dtl_to_BEE',200);

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

1287: -- l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_values_rec.batch_id);
1288: if g_debug then
1289: hr_utility.set_location('dtl_to_BEE',210);
1290: end if;
1291: HXT_UTIL.DEBUG('batch_sequence = '||to_char(p_batch_sequence)); --HXT115
1292: -- Insert data into BEE table
1293: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_line
1294: (p_session_date => sysdate
1295: ,p_batch_id => p_values_rec.batch_id

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

1354: ,p_value_15 => pbl_value(15)
1355: ,p_batch_line_id => l_batch_line_id
1356: ,p_object_version_number => l_line_ovn
1357: );
1358: HXT_UTIL.DEBUG('Successful INSERT INTO pay_batch_lines'); --HXT115
1359: -- Update OTM detail row to show BEE line entry id
1360: IF p_values_rec.hrw_rowid IS NOT NULL THEN
1361: UPDATE HXT_DET_HOURS_WORKED_F
1362: set PBL_LINE_ID = l_batch_line_id

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

1361: UPDATE HXT_DET_HOURS_WORKED_F
1362: set PBL_LINE_ID = l_batch_line_id
1363: WHERE rowid = p_values_rec.hrw_rowid;
1364: END IF;
1365: HXT_UTIL.DEBUG('Successful UPDATE hxt_det_hours_worked_f'); --HXT115
1366: EXCEPTION
1367: WHEN g_lookup_not_found THEN
1368: HXT_UTIL.DEBUG('Oops...g_lookup_not_found'); --HXT115
1369: p_sum_retcode := 3;

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

1364: END IF;
1365: HXT_UTIL.DEBUG('Successful UPDATE hxt_det_hours_worked_f'); --HXT115
1366: EXCEPTION
1367: WHEN g_lookup_not_found THEN
1368: HXT_UTIL.DEBUG('Oops...g_lookup_not_found'); --HXT115
1369: p_sum_retcode := 3;
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

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

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

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

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

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

1483: CLOSE hxt_amounts_cur;
1484: END IF;
1485: HXT_RETRO_VAL.Mark_Rows_Complete(p_batch_id);
1486: COMMIT; --115.37
1487: HXT_UTIL.DEBUG('Successful COMMIT');
1488: EXCEPTION
1489: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00
1490: ROLLBACK; --115.37
1491: HXT_UTIL.DEBUG('Oops...g_lookup_not_found in procedure sum_to_mix');

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

1487: HXT_UTIL.DEBUG('Successful COMMIT');
1488: EXCEPTION
1489: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00
1490: ROLLBACK; --115.37
1491: HXT_UTIL.DEBUG('Oops...g_lookup_not_found in procedure sum_to_mix');
1492: p_sum_retcode := 3;
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

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

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

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

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 ;
1503: WHEN others THEN
1504: ROLLBACK; --115.37

Line 1505: HXT_UTIL.DEBUG(sqlerrm);

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

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

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

Line 1577: HXT_UTIL.GEN_EXCEPTION

1573: ,p_oracle_error_text IN VARCHAR2 default NULL )
1574: RETURN NUMBER IS
1575: -- calls error processing procedure --
1576: BEGIN
1577: HXT_UTIL.GEN_EXCEPTION
1578: (p_location||'. Batch Id = '||to_char(p_batch_id)
1579: ,p_error_text
1580: ,p_oracle_error_text
1581: ,null);

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

1744: -- Delete batch lines for the time period selected by the user
1745: -- Delete any existing batch line errors
1746: --HXT11FOR batch_line_rec IN batch_line_cur(l_period_start_date, l_period_end_date) LOOP
1747: FOR batch_line_rec IN batch_line_cur LOOP --HXT11
1748: -- HXT_UTIL.DEBUG(batch_line_rec.assignment_number);--debug only HXT115
1749: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.from_date));--debug only HXT115
1750: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.to_date));--debug only HXT115
1751: -- Locate the Timecard associated with this particular batch line.
1752: -- we will create a new batch, the first time we enter this loop

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

1745: -- Delete any existing batch line errors
1746: --HXT11FOR batch_line_rec IN batch_line_cur(l_period_start_date, l_period_end_date) LOOP
1747: FOR batch_line_rec IN batch_line_cur LOOP --HXT11
1748: -- HXT_UTIL.DEBUG(batch_line_rec.assignment_number);--debug only HXT115
1749: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.from_date));--debug only HXT115
1750: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.to_date));--debug only HXT115
1751: -- Locate the Timecard associated with this particular batch line.
1752: -- we will create a new batch, the first time we enter this loop
1753: if not l_batch_created then

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

1746: --HXT11FOR batch_line_rec IN batch_line_cur(l_period_start_date, l_period_end_date) LOOP
1747: FOR batch_line_rec IN batch_line_cur LOOP --HXT11
1748: -- HXT_UTIL.DEBUG(batch_line_rec.assignment_number);--debug only HXT115
1749: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.from_date));--debug only HXT115
1750: -- HXT_UTIL.DEBUG(TO_CHAR(batch_line_rec.to_date));--debug only HXT115
1751: -- Locate the Timecard associated with this particular batch line.
1752: -- we will create a new batch, the first time we enter this loop
1753: if not l_batch_created then
1754: SELECT business_group_id, batch_name, batch_reference

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

1811: --COMMIT;
1812: p_rollback_retcode := 0;
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: HXT_UTIL.DEBUG('Error: ' || sqlerrm); --HXT115
1816: l_sql_error := sqlerrm;
1817: ROLLBACK;
1818: Insert_Pay_Batch_Errors( p_batch_id,
1819: 'VE',

Line 1837: HXT_UTIL.GEN_EXCEPTION

1833: FND_MESSAGE.CLEAR;
1834: ELSE
1835: l_ERROR_MSG := p_exception_details;
1836: END IF;
1837: HXT_UTIL.GEN_EXCEPTION
1838: ('Batch processing. Batch Id = '||to_char(p_batch_id)
1839: ,l_error_msg
1840: ,null
1841: ,null);

Line 1870: HXT_UTIL.GEN_ERROR(p_batch_id

1866: BEGIN
1867: OPEN tim_dates;
1868: FETCH tim_dates into l_eff_start, l_eff_end;
1869: if tim_dates%FOUND then
1870: HXT_UTIL.GEN_ERROR(p_batch_id
1871: , p_tim_id
1872: , p_hrw_id
1873: , p_time_period_id
1874: , p_error_msg