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.PAY_SE_SALARY_STRUCTURE_STATS dependencies on HR_UTILITY

Line 3: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_SE_SALARY_STRUCTURE_STATS AS
2: /* $Header: pysessst.pkb 120.1.12010000.2 2009/04/14 07:08:20 rrajaman ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (
6: archive_assact_id NUMBER
7: );

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

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

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

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

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

173:
174:
175: IF g_debug
176: THEN
177: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS'
178: , 30);
179: END IF;
180: END get_all_parameters;
181:

Line 354: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);

350:
351:
352: IF g_debug
353: THEN
354: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);
355: END IF;
356:
357: p_sql :=
358: 'SELECT DISTINCT person_id

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

523: -- END IF;
524: --END IF;
525: IF g_debug
526: THEN
527: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
528: END IF;
529: EXCEPTION
530: WHEN OTHERS
531: THEN

Line 880: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);

876:
877: BEGIN
878: IF g_debug
879: THEN
880: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
881: END IF;
882: --The codes used in the package
883: /*
884: 001- Hours worked (September)

Line 1723: hr_utility.set_location ('error raised assignment_action_code '

1719: WHEN OTHERS
1720: THEN
1721: IF g_debug
1722: THEN
1723: hr_utility.set_location ('error raised assignment_action_code '
1724: , 5
1725: );
1726: END IF;
1727:

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

1745: l_prev_prepay NUMBER := 0;
1746: BEGIN
1747: IF g_debug
1748: THEN
1749: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'
1750: , 80
1751: );
1752: END IF;
1753:

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

1763:
1764:
1765: IF g_debug
1766: THEN
1767: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'
1768: , 90
1769: );
1770: END IF;
1771: EXCEPTION

Line 1778: hr_utility.set_location ( 'ORA_ERR: '

1774: g_err_num := SQLCODE;
1775:
1776: IF g_debug
1777: THEN
1778: hr_utility.set_location ( 'ORA_ERR: '
1779: || g_err_num
1780: || 'In INITIALIZATION_CODE'
1781: , 180
1782: );

Line 1805: hr_utility.set_location

1801: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1802: BEGIN
1803: IF g_debug
1804: THEN
1805: hr_utility.set_location
1806: (' Entering Function GET_DEFINED_BALANCE_ID'
1807: , 240
1808: );
1809: END IF;

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

1818: RETURN l_defined_balance_id;
1819:
1820: IF g_debug
1821: THEN
1822: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'
1823: , 250
1824: );
1825: END IF;
1826: END get_defined_balance_id;

Line 1851: hr_utility.set_location

1847: l_return_balance_value NUMBER;
1848: BEGIN
1849: IF g_debug
1850: THEN
1851: hr_utility.set_location
1852: (' Entering Function GET_DEFINED_BALANCE_VALUE'
1853: , 240
1854: );
1855: END IF;

Line 1877: hr_utility.set_location

1873: RETURN l_return_balance_value;
1874:
1875: IF g_debug
1876: THEN
1877: hr_utility.set_location
1878: (' Leaving Function GET_DEFINED_BALANCE_VALUE'
1879: , 250
1880: );
1881: END IF;

Line 1894: hr_utility.set_location (' Leaving Procedure ARCHIVE_CODE', 390);

1890: begin
1891:
1892: IF g_debug
1893: THEN
1894: hr_utility.set_location (' Leaving Procedure ARCHIVE_CODE', 390);
1895: END IF;
1896: END archive_code;
1897:
1898: --- Report XML generating code

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

1914: l_iana_charset VARCHAR2 (50);
1915: BEGIN
1916: l_iana_charset := hr_se_utility.get_iana_charset;
1917:
1918: -- hr_utility.set_location ('Entering WritetoCLOB ', 70);
1919: l_str1 :=
1920: ' 1921: || l_iana_charset
1922: || '"?> ';

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

2015: ELSE
2016: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
2017: END IF;
2018: p_xfdf_clob := l_xfdf_string;
2019: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
2020: EXCEPTION
2021: WHEN OTHERS
2022: THEN
2023: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

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

2019: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
2020: EXCEPTION
2021: WHEN OTHERS
2022: THEN
2023: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
2024: hr_utility.raise_error;
2025: END writetoclob;
2026:
2027: -----------------------------------------------------------------------------------

Line 2024: hr_utility.raise_error;

2020: EXCEPTION
2021: WHEN OTHERS
2022: THEN
2023: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
2024: hr_utility.raise_error;
2025: END writetoclob;
2026:
2027: -----------------------------------------------------------------------------------
2028: -- POPULATE_DATA_DETAIL generates xml for the reports.

Line 2322: hr_utility.set_location('Entered Procedure GETDATA',10);

2318: , g_report_year
2319: );
2320:
2321:
2322: hr_utility.set_location('Entered Procedure GETDATA',10);
2323:
2324: /* xml_tab(l_counter).TagName :='LU_DETAILS';
2325: xml_tab(l_counter).TagValue :='LU_DETAILS';*/
2326: /* l_counter:=l_counter+1;*/

Line 2333: hr_utility.set_location('Before populating pl/sql table',20);

2329: OPEN csr_report_year(l_payroll_action_id);
2330: FETCH csr_report_year INTO l_report_year;
2331: CLOSE csr_report_year;
2332:
2333: hr_utility.set_location('Before populating pl/sql table',20);
2334: FOR csr_salary IN csr_salary_statistics(l_payroll_action_id) LOOP
2335:
2336: xml_tab(l_counter).TagName :='SSST_DETAILS';
2337: xml_tab(l_counter).TagValue :='SSST_DETAILS';