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 103: hxt_util.DEBUG (

99: AND enabled_flag = 'Y'
100: AND p_date_active BETWEEN NVL (start_date_active, p_date_active)
101: AND NVL (end_date_active, p_date_active);
102: BEGIN
103: hxt_util.DEBUG (
104: 'get_lookup_ code for meaning = '
105: || p_meaning
106: || ' type = '
107: || 'NAME_TRANSLATIONS'

Line 154: hxt_util.DEBUG (

150: AND fcl.enabled_flag = 'Y'
151: AND p_date BETWEEN NVL (fcl.start_date_active, p_date)
152: AND NVL (fcl.end_date_active, p_date);
153: BEGIN
154: hxt_util.DEBUG (
155: 'convert_lookup - code = '
156: || p_lookup_code
157: || ' type = '
158: || p_lookup_type

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

388: if g_debug then
389: hr_utility.set_location ('insert_pay_batch_lines', 20);
390: end if;
391: -- Place OTM data into BEE values per input values
392: hxt_util.DEBUG ('Putting OTM data into BEE values per input values'); --HXT115
393:
394:
395: --
396: -- In order to get the input-value logic work in diiferent legislations we need

Line 841: hxt_util.DEBUG ( 'value_'

837:
838: if g_debug then
839: hr_utility.set_location ('insert_pay_batch_lines', 170);
840: end if;
841: hxt_util.DEBUG ( 'value_'
842: || TO_CHAR (i)
843: || ' = '
844: || pbl_value (i)); --HXT115
845: END LOOP;

Line 849: hxt_util.DEBUG ( 'batch_sequence = '

845: END LOOP;
846:
847: -- Get next sequence number
848: -- l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence (p_batch_id);
849: hxt_util.DEBUG ( 'batch_sequence = '
850: || TO_CHAR (p_batch_sequence)); --HXT115
851:
852: -- Add new hours data
853: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_line

Line 930: hxt_util.DEBUG (

926:
927: EXCEPTION
928: WHEN g_lookup_not_found
929: THEN
930: hxt_util.DEBUG (
931: 'Oops...g_lookup_not_found in insert_pay_batch_lines'
932: ); --HXT115
933: RAISE g_lookup_not_found; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
934: WHEN OTHERS

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

932: ); --HXT115
933: RAISE g_lookup_not_found; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
934: WHEN OTHERS
935: THEN
936: hxt_util.DEBUG (SQLERRM); --HXT115
937: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115
938: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');
939: fnd_message.set_token ('SQLERR', SQLERRM);
940: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure

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

933: RAISE g_lookup_not_found; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
934: WHEN OTHERS
935: THEN
936: hxt_util.DEBUG (SQLERRM); --HXT115
937: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115
938: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');
939: fnd_message.set_token ('SQLERR', SQLERRM);
940: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
941: END insert_pay_batch_lines;

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

1567: -- Bug 8888777
1568:
1569: g_iv_upgrade := hxt_batch_process.get_upgrade_status(p_batch_id);
1570:
1571: hxt_util.DEBUG ('retro_mix started.'); -- debug only --HXT115
1572:
1573: /************************************************************/
1574: -- Step 1 - retro processing where hours<>0, amount=0
1575: /************************************************************/

Line 1590: hxt_util.DEBUG (

1586:
1587: -- bug 3217343 fix END
1588: FOR l_hours_rec IN current_hours (p_tim_id)
1589: LOOP
1590: hxt_util.DEBUG (
1591: 'retro row is '
1592: || l_hours_rec.element_name
1593: || ' '
1594: || TO_CHAR (l_hours_rec.hours_worked)

Line 1673: hxt_util.DEBUG (

1669: FETCH prev_hours INTO l_prev_hours_rec;
1670:
1671: IF prev_hours%FOUND
1672: THEN
1673: hxt_util.DEBUG (
1674: 'orig row is '
1675: || TO_CHAR (l_prev_hours_rec.hours_worked)
1676: || ' '
1677: ); -- debug only --HXT115

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

1709:
1710: -- end OHM199
1711: END IF;
1712:
1713: hxt_util.DEBUG ( ' hours to send - '
1714: || TO_CHAR (l_hours_to_send)); -- debug only --HXT115
1715: l_location := 'Step 1C';
1716:
1717: IF (l_hours_to_send <> 0)

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

1770: -- INTO l_nextval
1771: -- FROM DUAL;
1772:
1773: l_location := 'Step 1D';
1774: hxt_util.DEBUG (' insert hours to paymix.'); -- debug only --HXT115
1775:
1776: --BEGIN GLOBAL
1777: -- INSERT into pay_pdt_batch_lines
1778: -- (batch_id, line_id,

Line 1909: hxt_util.DEBUG (

1905: l_batch_sequence := l_batch_sequence + 1;
1906:
1907: FOR l_amount_rec IN current_amount (p_tim_id)
1908: LOOP
1909: hxt_util.DEBUG (
1910: 'retro row is '
1911: || l_amount_rec.element_name
1912: || ' '
1913: || TO_CHAR (l_amount_rec.amount)

Line 1945: hxt_util.DEBUG (

1941: FETCH prev_amount INTO l_prev_amount_rec;
1942:
1943: IF prev_amount%FOUND
1944: THEN
1945: hxt_util.DEBUG (
1946: 'orig row is '
1947: || TO_CHAR (l_prev_amount_rec.amount)
1948: || ' '
1949: ); -- debug only --HXT115

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

1972:
1973: -- end OHM199
1974: END IF;
1975:
1976: hxt_util.DEBUG ( ' amount to send - '
1977: || TO_CHAR (l_amount_to_send)); -- debug only --HXT115
1978: l_location := 'Step 2C';
1979:
1980: IF (l_amount_to_send <> 0)

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

2100: );
2101:
2102: --END GLOBAL
2103: l_location := 'Step 2E';
2104: hxt_util.DEBUG (' insert amount to paymix.'); -- debug only --HXT115
2105:
2106:
2107: -- begin OHM180
2108: UPDATE hxt_det_hours_worked_f

Line 2156: hxt_util.DEBUG (

2152: RETURN;
2153: EXCEPTION
2154: WHEN g_lookup_not_found
2155: THEN --SIR517 PWM 18FEB00
2156: hxt_util.DEBUG (
2157: 'Oops...g_lookup_not_found in procedure retro_sum_to_mix'
2158: ); --HXT115
2159: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
2160: hxt_batch_process.insert_pay_batch_errors (

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

2165: );
2166: RETURN;
2167: WHEN g_error_ins_batch_lines
2168: THEN --SIR517 PWM 18FEB00
2169: hxt_util.DEBUG ('Error attempting to insert paymix information'); -- debug only --HXT115
2170: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO'); --HXT111
2171: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
2172: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
2173: hxt_batch_process.insert_pay_batch_errors (

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

2175: 'VE', -- RETROPAY
2176: '',
2177: l_return
2178: );
2179: hxt_util.DEBUG (' back from calling insert_pay_batch_errors'); -- debug only --HXT115
2180: RETURN;
2181: WHEN OTHERS
2182: THEN
2183: hxt_util.DEBUG (

Line 2183: hxt_util.DEBUG (

2179: hxt_util.DEBUG (' back from calling insert_pay_batch_errors'); -- debug only --HXT115
2180: RETURN;
2181: WHEN OTHERS
2182: THEN
2183: hxt_util.DEBUG (
2184: ' exception received at '
2185: || l_location
2186: || '. '
2187: || SQLERRM

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

2200: --HXT111 'Error attempting to insert paymix information: (' || sqlerrm || ')',
2201: '', --HXT111
2202: l_return
2203: );
2204: hxt_util.DEBUG (' back from calling insert_pay_batch_errors'); -- debug only --HXT115
2205: RETURN;
2206: END retro_sum_to_mix;
2207:
2208: PROCEDURE mark_prev_hours_rows (p_tim_id IN NUMBER)