APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on HR_UTILITY

Line 3: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY pay_se_work_time_certificate AS
2: /* $Header: pysewtcr.pkb 120.0.12010000.2 2008/08/06 08:18:54 ubhat ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (
6: archive_assact_id NUMBER
7: );

Line 65: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);

61: BEGIN
62: --
63: IF g_debug
64: THEN
65: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);
66: END IF;
67:
68: l_start_pos :=
69: INSTR (' ' || p_parameter_string, l_delimiter || p_token || '=');

Line 108: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);

104:
105: --
106: IF g_debug
107: THEN
108: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);
109: END IF;
110:
111: RETURN l_parameter;
112: END;

Line 190: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS'

186:
187:
188: IF g_debug
189: THEN
190: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS'
191: ,30);
192: END IF;
193: END get_all_parameters;
194:

Line 2243: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);

2239:
2240: -- *****************************************************************************
2241: IF g_debug
2242: THEN
2243: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
2244: END IF;
2245: EXCEPTION
2246: WHEN others THEN
2247: fnd_file.put_line (fnd_file.LOG, 'Error for archive'||substr(sqlerrm,1,30));

Line 2288: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'

2284: l_prev_prepay NUMBER := 0;
2285: BEGIN
2286: IF g_debug
2287: THEN
2288: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'
2289: ,80
2290: );
2291: END IF;
2292:

Line 2314: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'

2310: );
2311:
2312: IF g_debug
2313: THEN
2314: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'
2315: ,90
2316: );
2317: END IF;
2318: EXCEPTION

Line 2325: hr_utility.set_location ( 'ORA_ERR: '

2321: g_err_num := SQLCODE;
2322:
2323: IF g_debug
2324: THEN
2325: hr_utility.set_location ( 'ORA_ERR: '
2326: || g_err_num
2327: || 'In INITIALIZATION_CODE'
2328: ,180
2329: );

Line 2353: hr_utility.set_location

2349: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
2350: BEGIN
2351: IF g_debug
2352: THEN
2353: hr_utility.set_location
2354: (' Entering Function GET_DEFINED_BALANCE_ID'
2355: ,240
2356: );
2357: END IF;

Line 2370: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'

2366: RETURN l_defined_balance_id;
2367:
2368: IF g_debug
2369: THEN
2370: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'
2371: ,250
2372: );
2373: END IF;
2374: END get_defined_balance_id;

Line 2402: hr_utility.set_location

2398: l_return_balance_value NUMBER;
2399: BEGIN
2400: IF g_debug
2401: THEN
2402: hr_utility.set_location
2403: (' Entering Function GET_DEFINED_BALANCE_VALUE'
2404: ,240
2405: );
2406: END IF;

Line 2434: hr_utility.set_location

2430: RETURN l_return_balance_value;
2431:
2432: IF g_debug
2433: THEN
2434: hr_utility.set_location
2435: (' Leaving Function GET_DEFINED_BALANCE_VALUE'
2436: ,250
2437: );
2438: END IF;

Line 2471: hr_utility.set_location ('Entering WritetoCLOB ', 70);

2467: current_index PLS_INTEGER;
2468: l_iana_charset VARCHAR2 (50);
2469: BEGIN
2470: l_iana_charset := hr_se_utility.get_iana_charset;
2471: hr_utility.set_location ('Entering WritetoCLOB ', 70);
2472: l_str1 :=
2473: ' 2474: || l_iana_charset
2475: || '"?> ';

Line 2586: hr_utility.set_location ('Leaving WritetoCLOB ', 40);

2582: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
2583: END IF;
2584:
2585: p_xfdf_clob := l_xfdf_string;
2586: hr_utility.set_location ('Leaving WritetoCLOB ', 40);
2587: EXCEPTION
2588: WHEN OTHERS
2589: THEN
2590: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

Line 2590: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

2586: hr_utility.set_location ('Leaving WritetoCLOB ', 40);
2587: EXCEPTION
2588: WHEN OTHERS
2589: THEN
2590: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
2591: hr_utility.raise_error;
2592: END writetoclob;
2593:
2594: -----------------------------------------------------------------------------------------------------------------

Line 2591: hr_utility.raise_error;

2587: EXCEPTION
2588: WHEN OTHERS
2589: THEN
2590: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
2591: hr_utility.raise_error;
2592: END writetoclob;
2593:
2594: -----------------------------------------------------------------------------------------------------------------
2595: --Procedure to Break the digits of a Person Number