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_UTIL dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HXT_UTIL AS
2: /* $Header: hxtutl.pkb 120.12.12020000.5 2013/01/28 11:27:38 asrajago ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: --BEGIN HXT11i1
6: FUNCTION GetPersonID(p_TIM_ID NUMBER) RETURN NUMBER; -- ER230
7: FUNCTION GetPayrollID(p_PTP_ID NUMBER) RETURN NUMBER; -- ER230
8: --END HXT11i1

Line 13: g_debug :=hr_utility.debug_enabled;

9:
10: --BEGIN HXT115
11: Procedure DEBUG(p_string IN VARCHAR2) IS
12: BEGIN
13: g_debug :=hr_utility.debug_enabled;
14: -- Uncomment line below to turn-on OTM package debug messages.
15: if g_debug then
16: hr_utility.trace(p_string);
17: end if;

Line 16: hr_utility.trace(p_string);

12: BEGIN
13: g_debug :=hr_utility.debug_enabled;
14: -- Uncomment line below to turn-on OTM package debug messages.
15: if g_debug then
16: hr_utility.trace(p_string);
17: end if;
18: -- NULL;
19: END DEBUG;
20: --END HXT115

Line 108: hr_utility.trace(dbms_utility.format_error_backtrace);

104:
105: EXCEPTION
106: WHEN others THEN
107: -- Bug 12919783
108: hr_utility.trace(dbms_utility.format_error_backtrace);
109: FND_MESSAGE.SET_NAME('HXT','HXT_39469_ERR_INS_HXT_ERR');
110: l_error := SQLERRM;
111: insert into hxt_errors_f(id, error_msg, creation_date, location,
112: created_by, err_type, PPB_ID, TIM_ID, HRW_ID, PTP_ID, ora_message

Line 204: hr_utility.trace(dbms_utility.format_error_backtrace);

200: );
201: EXCEPTION
202: WHEN others THEN
203: -- Bug 12919783
204: hr_utility.trace(dbms_utility.format_error_backtrace);
205: FND_MESSAGE.SET_NAME('HXT','HXT_39469_ERR_INS_HXT_ERR');
206: l_error := SQLERRM;
207: insert into hxt_errors_f(id, error_msg, creation_date, location,
208: created_by, err_type, TIM_ID, HRW_ID, PTP_ID, ora_message

Line 1007: hr_utility.trace('P_tim_id :'||p_tim_id);

1003: END IF;
1004:
1005: IF g_debug
1006: THEN
1007: hr_utility.trace('P_tim_id :'||p_tim_id);
1008: hr_utility.trace('Retro batch id '||l_retro_id);
1009: END IF;
1010:
1011: return (l_retro_id);

Line 1008: hr_utility.trace('Retro batch id '||l_retro_id);

1004:
1005: IF g_debug
1006: THEN
1007: hr_utility.trace('P_tim_id :'||p_tim_id);
1008: hr_utility.trace('Retro batch id '||l_retro_id);
1009: END IF;
1010:
1011: return (l_retro_id);
1012:

Line 1562: hr_utility.trace(dbms_utility.format_error_backtrace);

1558: DEBUG('Cost Allocation Flexfield needs to be frozen and compiled');
1559: RETURN 1;
1560: WHEN OTHERS THEN
1561: -- Bug 12919783
1562: hr_utility.trace(dbms_utility.format_error_backtrace);
1563: o_error_msg := SQLERRM;
1564: DEBUG(SQLERRM); --HXT115
1565: RETURN 2;
1566:

Line 2209: hr_utility.trace(dbms_utility.format_error_backtrace);

2205:
2206: EXCEPTION
2207: WHEN others THEN
2208: -- Bug 12919783
2209: hr_utility.trace(dbms_utility.format_error_backtrace);
2210: l_error := SQLERRM;
2211:
2212: FND_MESSAGE.SET_NAME('HXT','HXT_39469_ERR_INS_HXT_ERR');
2213: insert into hxt_errors_f(

Line 2348: g_debug :=hr_utility.debug_enabled;

2344: FROM hxt_det_hours_worked_f hdhw
2345: WHERE hdhw.retro_batch_id = pbh.batch_id));
2346: l_dummy VARCHAR2 (1);
2347: BEGIN
2348: g_debug :=hr_utility.debug_enabled;
2349: --hr_utility.trace_on(null,'Y');
2350: if g_debug then
2351: hr_utility.trace('inside def');
2352: end if;

Line 2349: --hr_utility.trace_on(null,'Y');

2345: WHERE hdhw.retro_batch_id = pbh.batch_id));
2346: l_dummy VARCHAR2 (1);
2347: BEGIN
2348: g_debug :=hr_utility.debug_enabled;
2349: --hr_utility.trace_on(null,'Y');
2350: if g_debug then
2351: hr_utility.trace('inside def');
2352: end if;
2353: OPEN c_chk_tc_exists;

Line 2351: hr_utility.trace('inside def');

2347: BEGIN
2348: g_debug :=hr_utility.debug_enabled;
2349: --hr_utility.trace_on(null,'Y');
2350: if g_debug then
2351: hr_utility.trace('inside def');
2352: end if;
2353: OPEN c_chk_tc_exists;
2354: FETCH c_chk_tc_exists INTO l_dummy;
2355:

Line 2359: hr_utility.trace('inside def1');

2355:
2356: IF (c_chk_tc_exists%FOUND)
2357: THEN
2358: if g_debug then
2359: hr_utility.trace('inside def1');
2360: end if;
2361: HR_UTILITY.SET_MESSAGE(808, 'HXT_39144_CANT_DELETE_BATCH'); --This message is
2362: --not the actuall message, it is just meant for testing purpose
2363: CLOSE c_chk_tc_exists;

Line 2361: HR_UTILITY.SET_MESSAGE(808, 'HXT_39144_CANT_DELETE_BATCH'); --This message is

2357: THEN
2358: if g_debug then
2359: hr_utility.trace('inside def1');
2360: end if;
2361: HR_UTILITY.SET_MESSAGE(808, 'HXT_39144_CANT_DELETE_BATCH'); --This message is
2362: --not the actuall message, it is just meant for testing purpose
2363: CLOSE c_chk_tc_exists;
2364: hr_utility.raise_error;
2365:

Line 2364: hr_utility.raise_error;

2360: end if;
2361: HR_UTILITY.SET_MESSAGE(808, 'HXT_39144_CANT_DELETE_BATCH'); --This message is
2362: --not the actuall message, it is just meant for testing purpose
2363: CLOSE c_chk_tc_exists;
2364: hr_utility.raise_error;
2365:
2366: END IF;
2367: CLOSE c_chk_tc_exists;
2368: END check_batch_states;

Line 2417: g_debug :=hr_utility.debug_enabled;

2413: c_hours_format CONSTANT VARCHAR2 (6) := 'HH24MI';
2414:
2415: BEGIN
2416:
2417: g_debug :=hr_utility.debug_enabled;
2418: if g_debug then
2419: l_proc := 'is_valid_time_entry';
2420:
2421: hr_utility.set_location ( 'Entering: ' || l_proc, 10);

Line 2421: hr_utility.set_location ( 'Entering: ' || l_proc, 10);

2417: g_debug :=hr_utility.debug_enabled;
2418: if g_debug then
2419: l_proc := 'is_valid_time_entry';
2420:
2421: hr_utility.set_location ( 'Entering: ' || l_proc, 10);
2422: end if;
2423: --Modified for the bug 12601255
2424: if (p_rounded_time_in is not null and p_rounded_time_out is not null)
2425: then

Line 2453: hr_utility.set_location ( 'Leaving: ' || l_proc, 100);

2449: end if;
2450:
2451:
2452: if g_debug then
2453: hr_utility.set_location ( 'Leaving: ' || l_proc, 100);
2454: end if;
2455:
2456: RETURN l_valid_entry;
2457:

Line 2504: g_debug :=hr_utility.debug_enabled;

2500:
2501:
2502:
2503:
2504: g_debug :=hr_utility.debug_enabled;
2505: if g_debug then
2506: l_proc := 'is_valid_time_entry';
2507:
2508: hr_utility.set_location ( 'Entering: ' || l_proc, 10);

Line 2508: hr_utility.set_location ( 'Entering: ' || l_proc, 10);

2504: g_debug :=hr_utility.debug_enabled;
2505: if g_debug then
2506: l_proc := 'is_valid_time_entry';
2507:
2508: hr_utility.set_location ( 'Entering: ' || l_proc, 10);
2509: end if;
2510:
2511: if g_debug then
2512: hr_utility.trace('Input Params - ');

Line 2512: hr_utility.trace('Input Params - ');

2508: hr_utility.set_location ( 'Entering: ' || l_proc, 10);
2509: end if;
2510:
2511: if g_debug then
2512: hr_utility.trace('Input Params - ');
2513: hr_utility.trace('p_raw_time_in = '||p_raw_time_in);
2514: hr_utility.trace('p_rounded_time_in = '||p_rounded_time_in);
2515: hr_utility.trace('p_raw_time_out = '||p_raw_time_out);
2516: hr_utility.trace('p_rounded_time_out = '||p_rounded_time_out);

Line 2513: hr_utility.trace('p_raw_time_in = '||p_raw_time_in);

2509: end if;
2510:
2511: if g_debug then
2512: hr_utility.trace('Input Params - ');
2513: hr_utility.trace('p_raw_time_in = '||p_raw_time_in);
2514: hr_utility.trace('p_rounded_time_in = '||p_rounded_time_in);
2515: hr_utility.trace('p_raw_time_out = '||p_raw_time_out);
2516: hr_utility.trace('p_rounded_time_out = '||p_rounded_time_out);
2517: hr_utility.trace('----------- ');

Line 2514: hr_utility.trace('p_rounded_time_in = '||p_rounded_time_in);

2510:
2511: if g_debug then
2512: hr_utility.trace('Input Params - ');
2513: hr_utility.trace('p_raw_time_in = '||p_raw_time_in);
2514: hr_utility.trace('p_rounded_time_in = '||p_rounded_time_in);
2515: hr_utility.trace('p_raw_time_out = '||p_raw_time_out);
2516: hr_utility.trace('p_rounded_time_out = '||p_rounded_time_out);
2517: hr_utility.trace('----------- ');
2518: hr_utility.trace('Hour Values - ');

Line 2515: hr_utility.trace('p_raw_time_out = '||p_raw_time_out);

2511: if g_debug then
2512: hr_utility.trace('Input Params - ');
2513: hr_utility.trace('p_raw_time_in = '||p_raw_time_in);
2514: hr_utility.trace('p_rounded_time_in = '||p_rounded_time_in);
2515: hr_utility.trace('p_raw_time_out = '||p_raw_time_out);
2516: hr_utility.trace('p_rounded_time_out = '||p_rounded_time_out);
2517: hr_utility.trace('----------- ');
2518: hr_utility.trace('Hour Values - ');
2519: hr_utility.trace('l_raw_time_in = '||l_raw_time_in);

Line 2516: hr_utility.trace('p_rounded_time_out = '||p_rounded_time_out);

2512: hr_utility.trace('Input Params - ');
2513: hr_utility.trace('p_raw_time_in = '||p_raw_time_in);
2514: hr_utility.trace('p_rounded_time_in = '||p_rounded_time_in);
2515: hr_utility.trace('p_raw_time_out = '||p_raw_time_out);
2516: hr_utility.trace('p_rounded_time_out = '||p_rounded_time_out);
2517: hr_utility.trace('----------- ');
2518: hr_utility.trace('Hour Values - ');
2519: hr_utility.trace('l_raw_time_in = '||l_raw_time_in);
2520: hr_utility.trace('l_rounded_time_in = '||l_rounded_time_in);

Line 2517: hr_utility.trace('----------- ');

2513: hr_utility.trace('p_raw_time_in = '||p_raw_time_in);
2514: hr_utility.trace('p_rounded_time_in = '||p_rounded_time_in);
2515: hr_utility.trace('p_raw_time_out = '||p_raw_time_out);
2516: hr_utility.trace('p_rounded_time_out = '||p_rounded_time_out);
2517: hr_utility.trace('----------- ');
2518: hr_utility.trace('Hour Values - ');
2519: hr_utility.trace('l_raw_time_in = '||l_raw_time_in);
2520: hr_utility.trace('l_rounded_time_in = '||l_rounded_time_in);
2521: hr_utility.trace('l_raw_time_out = '||l_raw_time_out);

Line 2518: hr_utility.trace('Hour Values - ');

2514: hr_utility.trace('p_rounded_time_in = '||p_rounded_time_in);
2515: hr_utility.trace('p_raw_time_out = '||p_raw_time_out);
2516: hr_utility.trace('p_rounded_time_out = '||p_rounded_time_out);
2517: hr_utility.trace('----------- ');
2518: hr_utility.trace('Hour Values - ');
2519: hr_utility.trace('l_raw_time_in = '||l_raw_time_in);
2520: hr_utility.trace('l_rounded_time_in = '||l_rounded_time_in);
2521: hr_utility.trace('l_raw_time_out = '||l_raw_time_out);
2522: hr_utility.trace('l_rounded_time_out = '||l_rounded_time_out);

Line 2519: hr_utility.trace('l_raw_time_in = '||l_raw_time_in);

2515: hr_utility.trace('p_raw_time_out = '||p_raw_time_out);
2516: hr_utility.trace('p_rounded_time_out = '||p_rounded_time_out);
2517: hr_utility.trace('----------- ');
2518: hr_utility.trace('Hour Values - ');
2519: hr_utility.trace('l_raw_time_in = '||l_raw_time_in);
2520: hr_utility.trace('l_rounded_time_in = '||l_rounded_time_in);
2521: hr_utility.trace('l_raw_time_out = '||l_raw_time_out);
2522: hr_utility.trace('l_rounded_time_out = '||l_rounded_time_out);
2523: hr_utility.trace('----------- ');

Line 2520: hr_utility.trace('l_rounded_time_in = '||l_rounded_time_in);

2516: hr_utility.trace('p_rounded_time_out = '||p_rounded_time_out);
2517: hr_utility.trace('----------- ');
2518: hr_utility.trace('Hour Values - ');
2519: hr_utility.trace('l_raw_time_in = '||l_raw_time_in);
2520: hr_utility.trace('l_rounded_time_in = '||l_rounded_time_in);
2521: hr_utility.trace('l_raw_time_out = '||l_raw_time_out);
2522: hr_utility.trace('l_rounded_time_out = '||l_rounded_time_out);
2523: hr_utility.trace('----------- ');
2524: end if;

Line 2521: hr_utility.trace('l_raw_time_out = '||l_raw_time_out);

2517: hr_utility.trace('----------- ');
2518: hr_utility.trace('Hour Values - ');
2519: hr_utility.trace('l_raw_time_in = '||l_raw_time_in);
2520: hr_utility.trace('l_rounded_time_in = '||l_rounded_time_in);
2521: hr_utility.trace('l_raw_time_out = '||l_raw_time_out);
2522: hr_utility.trace('l_rounded_time_out = '||l_rounded_time_out);
2523: hr_utility.trace('----------- ');
2524: end if;
2525:

Line 2522: hr_utility.trace('l_rounded_time_out = '||l_rounded_time_out);

2518: hr_utility.trace('Hour Values - ');
2519: hr_utility.trace('l_raw_time_in = '||l_raw_time_in);
2520: hr_utility.trace('l_rounded_time_in = '||l_rounded_time_in);
2521: hr_utility.trace('l_raw_time_out = '||l_raw_time_out);
2522: hr_utility.trace('l_rounded_time_out = '||l_rounded_time_out);
2523: hr_utility.trace('----------- ');
2524: end if;
2525:
2526: IF ( (

Line 2523: hr_utility.trace('----------- ');

2519: hr_utility.trace('l_raw_time_in = '||l_raw_time_in);
2520: hr_utility.trace('l_rounded_time_in = '||l_rounded_time_in);
2521: hr_utility.trace('l_raw_time_out = '||l_raw_time_out);
2522: hr_utility.trace('l_rounded_time_out = '||l_rounded_time_out);
2523: hr_utility.trace('----------- ');
2524: end if;
2525:
2526: IF ( (
2527: (l_raw_time_in < l_raw_time_out)

Line 2541: hr_utility.set_location ( 'Invalid entry: ' || l_proc, 20);

2537: (l_rounded_time_in < l_rounded_time_out)
2538: )
2539: ) THEN
2540: if g_debug then
2541: hr_utility.set_location ( 'Invalid entry: ' || l_proc, 20);
2542: end if;
2543: l_valid_entry := FALSE;
2544: ELSE
2545: if g_debug then

Line 2546: hr_utility.set_location ( 'Valid entry: ' || l_proc, 30);

2542: end if;
2543: l_valid_entry := FALSE;
2544: ELSE
2545: if g_debug then
2546: hr_utility.set_location ( 'Valid entry: ' || l_proc, 30);
2547: end if;
2548: l_valid_entry := TRUE;
2549: END IF;
2550:

Line 2552: hr_utility.set_location ( 'Leaving: ' || l_proc, 100);

2548: l_valid_entry := TRUE;
2549: END IF;
2550:
2551: if g_debug then
2552: hr_utility.set_location ( 'Leaving: ' || l_proc, 100);
2553: end if;
2554:
2555: RETURN l_valid_entry;
2556:

Line 2587: hr_utility.set_message (808, 'HXT_CANT_DEL_PERSON');

2583:
2584: IF (csr_chk_tc_exists_hxt%FOUND)
2585: THEN
2586: CLOSE csr_chk_tc_exists_hxt;
2587: hr_utility.set_message (808, 'HXT_CANT_DEL_PERSON');
2588: hr_utility.raise_error;
2589: ElSE
2590:
2591: CLOSE csr_chk_tc_exists_hxt;

Line 2588: hr_utility.raise_error;

2584: IF (csr_chk_tc_exists_hxt%FOUND)
2585: THEN
2586: CLOSE csr_chk_tc_exists_hxt;
2587: hr_utility.set_message (808, 'HXT_CANT_DEL_PERSON');
2588: hr_utility.raise_error;
2589: ElSE
2590:
2591: CLOSE csr_chk_tc_exists_hxt;
2592:

Line 2599: hr_utility.set_message (808, 'HXT_CANT_DEL_PERSON');

2595:
2596: IF (csr_chk_tc_exists_ss%FOUND)
2597: THEN
2598: CLOSE csr_chk_tc_exists_ss;
2599: hr_utility.set_message (808, 'HXT_CANT_DEL_PERSON');
2600: hr_utility.raise_error;
2601: END IF;
2602:
2603: CLOSE csr_chk_tc_exists_ss;

Line 2600: hr_utility.raise_error;

2596: IF (csr_chk_tc_exists_ss%FOUND)
2597: THEN
2598: CLOSE csr_chk_tc_exists_ss;
2599: hr_utility.set_message (808, 'HXT_CANT_DEL_PERSON');
2600: hr_utility.raise_error;
2601: END IF;
2602:
2603: CLOSE csr_chk_tc_exists_ss;
2604: