DBA Data[Home] [Help]

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.8.12010000.2 2008/08/05 09:50:55 ubhat 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 2266: g_debug :=hr_utility.debug_enabled;

2262: FROM hxt_det_hours_worked_f hdhw
2263: WHERE hdhw.retro_batch_id = pbh.batch_id));
2264: l_dummy VARCHAR2 (1);
2265: BEGIN
2266: g_debug :=hr_utility.debug_enabled;
2267: --hr_utility.trace_on(null,'Y');
2268: if g_debug then
2269: hr_utility.trace('inside def');
2270: end if;

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

2263: WHERE hdhw.retro_batch_id = pbh.batch_id));
2264: l_dummy VARCHAR2 (1);
2265: BEGIN
2266: g_debug :=hr_utility.debug_enabled;
2267: --hr_utility.trace_on(null,'Y');
2268: if g_debug then
2269: hr_utility.trace('inside def');
2270: end if;
2271: OPEN c_chk_tc_exists;

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

2265: BEGIN
2266: g_debug :=hr_utility.debug_enabled;
2267: --hr_utility.trace_on(null,'Y');
2268: if g_debug then
2269: hr_utility.trace('inside def');
2270: end if;
2271: OPEN c_chk_tc_exists;
2272: FETCH c_chk_tc_exists INTO l_dummy;
2273:

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

2273:
2274: IF (c_chk_tc_exists%FOUND)
2275: THEN
2276: if g_debug then
2277: hr_utility.trace('inside def1');
2278: end if;
2279: HR_UTILITY.SET_MESSAGE(808, 'HXT_39144_CANT_DELETE_BATCH'); --This message is
2280: --not the actuall message, it is just meant for testing purpose
2281: CLOSE c_chk_tc_exists;

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

2275: THEN
2276: if g_debug then
2277: hr_utility.trace('inside def1');
2278: end if;
2279: HR_UTILITY.SET_MESSAGE(808, 'HXT_39144_CANT_DELETE_BATCH'); --This message is
2280: --not the actuall message, it is just meant for testing purpose
2281: CLOSE c_chk_tc_exists;
2282: hr_utility.raise_error;
2283:

Line 2282: hr_utility.raise_error;

2278: end if;
2279: HR_UTILITY.SET_MESSAGE(808, 'HXT_39144_CANT_DELETE_BATCH'); --This message is
2280: --not the actuall message, it is just meant for testing purpose
2281: CLOSE c_chk_tc_exists;
2282: hr_utility.raise_error;
2283:
2284: END IF;
2285: CLOSE c_chk_tc_exists;
2286: END check_batch_states;

Line 2332: g_debug :=hr_utility.debug_enabled;

2328: c_hours_format CONSTANT VARCHAR2 (6) := 'HH24MI';
2329:
2330: BEGIN
2331:
2332: g_debug :=hr_utility.debug_enabled;
2333: if g_debug then
2334: l_proc := 'is_valid_time_entry';
2335:
2336: hr_utility.set_location ( 'Entering: ' || l_proc, 10);

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

2332: g_debug :=hr_utility.debug_enabled;
2333: if g_debug then
2334: l_proc := 'is_valid_time_entry';
2335:
2336: hr_utility.set_location ( 'Entering: ' || l_proc, 10);
2337: end if;
2338:
2339: IF ( ( (TO_CHAR (p_raw_time_in, c_hours_format) <
2340: TO_CHAR (p_raw_time_out, c_hours_format)

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

2349: AND (TO_CHAR (p_rounded_time_in, c_hours_format) <
2350: TO_CHAR (p_rounded_time_out, c_hours_format)
2351: ) ) ) THEN
2352: if g_debug then
2353: hr_utility.set_location ( 'Invalid entry: ' || l_proc, 20);
2354: end if;
2355: l_valid_entry := FALSE;
2356: ELSE
2357: if g_debug then

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

2354: end if;
2355: l_valid_entry := FALSE;
2356: ELSE
2357: if g_debug then
2358: hr_utility.set_location ( 'Valid entry: ' || l_proc, 30);
2359: end if;
2360: l_valid_entry := TRUE;
2361: END IF;
2362:

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

2360: l_valid_entry := TRUE;
2361: END IF;
2362:
2363: if g_debug then
2364: hr_utility.set_location ( 'Leaving: ' || l_proc, 100);
2365: end if;
2366:
2367: RETURN l_valid_entry;
2368:

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

2393:
2394: IF (csr_chk_tc_exists_hxt%FOUND)
2395: THEN
2396: CLOSE csr_chk_tc_exists_hxt;
2397: hr_utility.set_message (808, 'HXT_CANT_DEL_PERSON');
2398: hr_utility.raise_error;
2399: ElSE
2400:
2401: CLOSE csr_chk_tc_exists_hxt;

Line 2398: hr_utility.raise_error;

2394: IF (csr_chk_tc_exists_hxt%FOUND)
2395: THEN
2396: CLOSE csr_chk_tc_exists_hxt;
2397: hr_utility.set_message (808, 'HXT_CANT_DEL_PERSON');
2398: hr_utility.raise_error;
2399: ElSE
2400:
2401: CLOSE csr_chk_tc_exists_hxt;
2402:

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

2405:
2406: IF (csr_chk_tc_exists_ss%FOUND)
2407: THEN
2408: CLOSE csr_chk_tc_exists_ss;
2409: hr_utility.set_message (808, 'HXT_CANT_DEL_PERSON');
2410: hr_utility.raise_error;
2411: END IF;
2412:
2413: CLOSE csr_chk_tc_exists_ss;

Line 2410: hr_utility.raise_error;

2406: IF (csr_chk_tc_exists_ss%FOUND)
2407: THEN
2408: CLOSE csr_chk_tc_exists_ss;
2409: hr_utility.set_message (808, 'HXT_CANT_DEL_PERSON');
2410: hr_utility.raise_error;
2411: END IF;
2412:
2413: CLOSE csr_chk_tc_exists_ss;
2414: