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_RETRO_MIX dependencies on HXT_UTIL

Line 75: hxt_util.DEBUG (

71: AND enabled_flag = 'Y'
72: AND p_date_active BETWEEN NVL (start_date_active, p_date_active)
73: AND NVL (end_date_active, p_date_active);
74: BEGIN
75: hxt_util.DEBUG (
76: 'get_lookup_ code for meaning = '
77: || p_meaning
78: || ' type = '
79: || 'NAME_TRANSLATIONS'

Line 126: hxt_util.DEBUG (

122: AND fcl.enabled_flag = 'Y'
123: AND p_date BETWEEN NVL (fcl.start_date_active, p_date)
124: AND NVL (fcl.end_date_active, p_date);
125: BEGIN
126: hxt_util.DEBUG (
127: 'convert_lookup - code = '
128: || p_lookup_code
129: || ' type = '
130: || p_lookup_type

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

336: if g_debug then
337: hr_utility.set_location ('insert_pay_batch_lines', 20);
338: end if;
339: -- Place OTM data into BEE values per input values
340: hxt_util.DEBUG ('Putting OTM data into BEE values per input values'); --HXT115
341:
342:
343: --
344: -- In order to get the input-value logic work in diiferent legislations we need

Line 663: hxt_util.DEBUG ( 'value_'

659:
660: if g_debug then
661: hr_utility.set_location ('insert_pay_batch_lines', 170);
662: end if;
663: hxt_util.DEBUG ( 'value_'
664: || TO_CHAR (i)
665: || ' = '
666: || pbl_value (i)); --HXT115
667: END LOOP;

Line 671: hxt_util.DEBUG ( 'batch_sequence = '

667: END LOOP;
668:
669: -- Get next sequence number
670: -- l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence (p_batch_id);
671: hxt_util.DEBUG ( 'batch_sequence = '
672: || TO_CHAR (p_batch_sequence)); --HXT115
673:
674: -- Add new hours data
675: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_line

Line 743: hxt_util.DEBUG (

739: p_batch_line_id := l_batch_line_id;
740: EXCEPTION
741: WHEN g_lookup_not_found
742: THEN
743: hxt_util.DEBUG (
744: 'Oops...g_lookup_not_found in insert_pay_batch_lines'
745: ); --HXT115
746: RAISE g_lookup_not_found; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
747: WHEN OTHERS

Line 749: hxt_util.DEBUG (SQLERRM); --HXT115

745: ); --HXT115
746: RAISE g_lookup_not_found; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
747: WHEN OTHERS
748: THEN
749: hxt_util.DEBUG (SQLERRM); --HXT115
750: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115
751: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');
752: fnd_message.set_token ('SQLERR', SQLERRM);
753: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure

Line 750: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115

746: RAISE g_lookup_not_found; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
747: WHEN OTHERS
748: THEN
749: hxt_util.DEBUG (SQLERRM); --HXT115
750: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115
751: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');
752: fnd_message.set_token ('SQLERR', SQLERRM);
753: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
754: END insert_pay_batch_lines;

Line 1286: hxt_util.DEBUG ('retro_mix started.'); -- debug only --HXT115

1282:
1283: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
1284:
1285: BEGIN
1286: hxt_util.DEBUG ('retro_mix started.'); -- debug only --HXT115
1287:
1288: /************************************************************/
1289: -- Step 1 - retro processing where hours<>0, amount=0
1290: /************************************************************/

Line 1305: hxt_util.DEBUG (

1301:
1302: -- bug 3217343 fix END
1303: FOR l_hours_rec IN current_hours (p_tim_id)
1304: LOOP
1305: hxt_util.DEBUG (
1306: 'retro row is '
1307: || l_hours_rec.element_name
1308: || ' '
1309: || TO_CHAR (l_hours_rec.hours_worked)

Line 1340: hxt_util.DEBUG (

1336: FETCH prev_hours INTO l_prev_hours_rec;
1337:
1338: IF prev_hours%FOUND
1339: THEN
1340: hxt_util.DEBUG (
1341: 'orig row is '
1342: || TO_CHAR (l_prev_hours_rec.hours_worked)
1343: || ' '
1344: ); -- debug only --HXT115

Line 1371: hxt_util.DEBUG ( ' hours to send - '

1367:
1368: -- end OHM199
1369: END IF;
1370:
1371: hxt_util.DEBUG ( ' hours to send - '
1372: || TO_CHAR (l_hours_to_send)); -- debug only --HXT115
1373: l_location := 'Step 1C';
1374:
1375: IF (l_hours_to_send <> 0)

Line 1432: hxt_util.DEBUG (' insert hours to paymix.'); -- debug only --HXT115

1428: -- INTO l_nextval
1429: -- FROM DUAL;
1430:
1431: l_location := 'Step 1D';
1432: hxt_util.DEBUG (' insert hours to paymix.'); -- debug only --HXT115
1433:
1434: --BEGIN GLOBAL
1435: -- INSERT into pay_pdt_batch_lines
1436: -- (batch_id, line_id,

Line 1564: hxt_util.DEBUG (

1560: l_batch_sequence := l_batch_sequence + 1;
1561:
1562: FOR l_amount_rec IN current_amount (p_tim_id)
1563: LOOP
1564: hxt_util.DEBUG (
1565: 'retro row is '
1566: || l_amount_rec.element_name
1567: || ' '
1568: || TO_CHAR (l_amount_rec.amount)

Line 1600: hxt_util.DEBUG (

1596: FETCH prev_amount INTO l_prev_amount_rec;
1597:
1598: IF prev_amount%FOUND
1599: THEN
1600: hxt_util.DEBUG (
1601: 'orig row is '
1602: || TO_CHAR (l_prev_amount_rec.amount)
1603: || ' '
1604: ); -- debug only --HXT115

Line 1631: hxt_util.DEBUG ( ' amount to send - '

1627:
1628: -- end OHM199
1629: END IF;
1630:
1631: hxt_util.DEBUG ( ' amount to send - '
1632: || TO_CHAR (l_amount_to_send)); -- debug only --HXT115
1633: l_location := 'Step 2C';
1634:
1635: IF (l_amount_to_send <> 0)

Line 1759: hxt_util.DEBUG (' insert amount to paymix.'); -- debug only --HXT115

1755: );
1756:
1757: --END GLOBAL
1758: l_location := 'Step 2E';
1759: hxt_util.DEBUG (' insert amount to paymix.'); -- debug only --HXT115
1760:
1761:
1762: -- begin OHM180
1763: UPDATE hxt_det_hours_worked_f

Line 1805: hxt_util.DEBUG (

1801: RETURN;
1802: EXCEPTION
1803: WHEN g_lookup_not_found
1804: THEN --SIR517 PWM 18FEB00
1805: hxt_util.DEBUG (
1806: 'Oops...g_lookup_not_found in procedure retro_sum_to_mix'
1807: ); --HXT115
1808: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
1809: hxt_batch_process.insert_pay_batch_errors (

Line 1818: hxt_util.DEBUG ('Error attempting to insert paymix information'); -- debug only --HXT115

1814: );
1815: RETURN;
1816: WHEN g_error_ins_batch_lines
1817: THEN --SIR517 PWM 18FEB00
1818: hxt_util.DEBUG ('Error attempting to insert paymix information'); -- debug only --HXT115
1819: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO'); --HXT111
1820: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
1821: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
1822: hxt_batch_process.insert_pay_batch_errors (

Line 1828: hxt_util.DEBUG (' back from calling insert_pay_batch_errors'); -- debug only --HXT115

1824: 'VE', -- RETROPAY
1825: '',
1826: l_return
1827: );
1828: hxt_util.DEBUG (' back from calling insert_pay_batch_errors'); -- debug only --HXT115
1829: RETURN;
1830: WHEN OTHERS
1831: THEN
1832: hxt_util.DEBUG (

Line 1832: hxt_util.DEBUG (

1828: hxt_util.DEBUG (' back from calling insert_pay_batch_errors'); -- debug only --HXT115
1829: RETURN;
1830: WHEN OTHERS
1831: THEN
1832: hxt_util.DEBUG (
1833: ' exception received at '
1834: || l_location
1835: || '. '
1836: || SQLERRM

Line 1853: hxt_util.DEBUG (' back from calling insert_pay_batch_errors'); -- debug only --HXT115

1849: --HXT111 'Error attempting to insert paymix information: (' || sqlerrm || ')',
1850: '', --HXT111
1851: l_return
1852: );
1853: hxt_util.DEBUG (' back from calling insert_pay_batch_errors'); -- debug only --HXT115
1854: RETURN;
1855: END retro_sum_to_mix;
1856:
1857: PROCEDURE mark_prev_hours_rows (p_tim_id IN NUMBER)