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.5 2010/02/02 17:52:58 vijranga 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 2283: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);

2279:
2280: -- *****************************************************************************
2281: IF g_debug
2282: THEN
2283: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
2284: END IF;
2285: EXCEPTION
2286: WHEN others THEN
2287: fnd_file.put_line (fnd_file.LOG, 'Error for archive'||substr(sqlerrm,1,30));

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

2324: l_prev_prepay NUMBER := 0;
2325: BEGIN
2326: IF g_debug
2327: THEN
2328: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'
2329: ,80
2330: );
2331: END IF;
2332:

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

2350: );
2351:
2352: IF g_debug
2353: THEN
2354: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'
2355: ,90
2356: );
2357: END IF;
2358: EXCEPTION

Line 2365: hr_utility.set_location ( 'ORA_ERR: '

2361: g_err_num := SQLCODE;
2362:
2363: IF g_debug
2364: THEN
2365: hr_utility.set_location ( 'ORA_ERR: '
2366: || g_err_num
2367: || 'In INITIALIZATION_CODE'
2368: ,180
2369: );

Line 2393: hr_utility.set_location

2389: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
2390: BEGIN
2391: IF g_debug
2392: THEN
2393: hr_utility.set_location
2394: (' Entering Function GET_DEFINED_BALANCE_ID'
2395: ,240
2396: );
2397: END IF;

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

2406: RETURN l_defined_balance_id;
2407:
2408: IF g_debug
2409: THEN
2410: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'
2411: ,250
2412: );
2413: END IF;
2414: END get_defined_balance_id;

Line 2442: hr_utility.set_location

2438: l_return_balance_value NUMBER;
2439: BEGIN
2440: IF g_debug
2441: THEN
2442: hr_utility.set_location
2443: (' Entering Function GET_DEFINED_BALANCE_VALUE'
2444: ,240
2445: );
2446: END IF;

Line 2474: hr_utility.set_location

2470: RETURN l_return_balance_value;
2471:
2472: IF g_debug
2473: THEN
2474: hr_utility.set_location
2475: (' Leaving Function GET_DEFINED_BALANCE_VALUE'
2476: ,250
2477: );
2478: END IF;

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

2507: current_index PLS_INTEGER;
2508: l_iana_charset VARCHAR2 (50);
2509: BEGIN
2510: l_iana_charset := hr_se_utility.get_iana_charset;
2511: hr_utility.set_location ('Entering WritetoCLOB ', 70);
2512: l_str1 :=
2513: ' 2514: || l_iana_charset
2515: || '"?> ';

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

2622: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
2623: END IF;
2624:
2625: p_xfdf_clob := l_xfdf_string;
2626: hr_utility.set_location ('Leaving WritetoCLOB ', 40);
2627: EXCEPTION
2628: WHEN OTHERS
2629: THEN
2630: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

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

2626: hr_utility.set_location ('Leaving WritetoCLOB ', 40);
2627: EXCEPTION
2628: WHEN OTHERS
2629: THEN
2630: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
2631: hr_utility.raise_error;
2632: END writetoclob;
2633:
2634: -----------------------------------------------------------------------------------------------------------------

Line 2631: hr_utility.raise_error;

2627: EXCEPTION
2628: WHEN OTHERS
2629: THEN
2630: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
2631: hr_utility.raise_error;
2632: END writetoclob;
2633:
2634: -----------------------------------------------------------------------------------------------------------------
2635: --Procedure to Break the digits of a Person Number