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 2007/07/19 09:49:49 rravi noship $ */
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 878: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);

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

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

1690: WHEN OTHERS
1691: THEN
1692: IF g_debug
1693: THEN
1694: hr_utility.set_location ('error raised assignment_action_code '
1695: , 5
1696: );
1697: END IF;
1698:

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

1716: l_prev_prepay NUMBER := 0;
1717: BEGIN
1718: IF g_debug
1719: THEN
1720: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'
1721: , 80
1722: );
1723: END IF;
1724:

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

1734:
1735:
1736: IF g_debug
1737: THEN
1738: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'
1739: , 90
1740: );
1741: END IF;
1742: EXCEPTION

Line 1749: hr_utility.set_location ( 'ORA_ERR: '

1745: g_err_num := SQLCODE;
1746:
1747: IF g_debug
1748: THEN
1749: hr_utility.set_location ( 'ORA_ERR: '
1750: || g_err_num
1751: || 'In INITIALIZATION_CODE'
1752: , 180
1753: );

Line 1776: hr_utility.set_location

1772: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1773: BEGIN
1774: IF g_debug
1775: THEN
1776: hr_utility.set_location
1777: (' Entering Function GET_DEFINED_BALANCE_ID'
1778: , 240
1779: );
1780: END IF;

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

1789: RETURN l_defined_balance_id;
1790:
1791: IF g_debug
1792: THEN
1793: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'
1794: , 250
1795: );
1796: END IF;
1797: END get_defined_balance_id;

Line 1822: hr_utility.set_location

1818: l_return_balance_value NUMBER;
1819: BEGIN
1820: IF g_debug
1821: THEN
1822: hr_utility.set_location
1823: (' Entering Function GET_DEFINED_BALANCE_VALUE'
1824: , 240
1825: );
1826: END IF;

Line 1848: hr_utility.set_location

1844: RETURN l_return_balance_value;
1845:
1846: IF g_debug
1847: THEN
1848: hr_utility.set_location
1849: (' Leaving Function GET_DEFINED_BALANCE_VALUE'
1850: , 250
1851: );
1852: END IF;

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

1861: begin
1862:
1863: IF g_debug
1864: THEN
1865: hr_utility.set_location (' Leaving Procedure ARCHIVE_CODE', 390);
1866: END IF;
1867: END archive_code;
1868:
1869: --- Report XML generating code

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

1885: l_iana_charset VARCHAR2 (50);
1886: BEGIN
1887: l_iana_charset := hr_se_utility.get_iana_charset;
1888:
1889: -- hr_utility.set_location ('Entering WritetoCLOB ', 70);
1890: l_str1 :=
1891: ' 1892: || l_iana_charset
1893: || '"?> ';

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

1986: ELSE
1987: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1988: END IF;
1989: p_xfdf_clob := l_xfdf_string;
1990: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1991: EXCEPTION
1992: WHEN OTHERS
1993: THEN
1994: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

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

1990: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1991: EXCEPTION
1992: WHEN OTHERS
1993: THEN
1994: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
1995: hr_utility.raise_error;
1996: END writetoclob;
1997:
1998: -----------------------------------------------------------------------------------

Line 1995: hr_utility.raise_error;

1991: EXCEPTION
1992: WHEN OTHERS
1993: THEN
1994: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
1995: hr_utility.raise_error;
1996: END writetoclob;
1997:
1998: -----------------------------------------------------------------------------------
1999: -- POPULATE_DATA_DETAIL generates xml for the reports.

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

2252: , g_report_year
2253: );
2254:
2255:
2256: hr_utility.set_location('Entered Procedure GETDATA',10);
2257:
2258: /* xml_tab(l_counter).TagName :='LU_DETAILS';
2259: xml_tab(l_counter).TagValue :='LU_DETAILS';*/
2260: /* l_counter:=l_counter+1;*/

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

2263: OPEN csr_report_year(l_payroll_action_id);
2264: FETCH csr_report_year INTO l_report_year;
2265: CLOSE csr_report_year;
2266:
2267: hr_utility.set_location('Before populating pl/sql table',20);
2268: FOR csr_salary IN csr_salary_statistics(l_payroll_action_id) LOOP
2269:
2270: xml_tab(l_counter).TagName :='SSST_DETAILS';
2271: xml_tab(l_counter).TagValue :='SSST_DETAILS';