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_EMPLOYMENT_STATISTICS dependencies on HR_UTILITY

Line 3: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_SE_EMPLOYMENT_STATISTICS AS
2: /* $Header: pysestsr.pkb 120.1 2010/10/28 08:52:14 vijranga ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (
6: archive_assact_id NUMBER
7: );

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

52: BEGIN
53: --
54: IF g_debug
55: THEN
56: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);
57: END IF;
58:
59: l_start_pos :=
60: INSTR (' ' || p_parameter_string, l_delimiter || p_token || '=');

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

95:
96: --
97: IF g_debug
98: THEN
99: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);
100: END IF;
101:
102: RETURN l_parameter;
103: END;

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

197:
198:
199: IF g_debug
200: THEN
201: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS'
202: , 30);
203: END IF;
204: END get_all_parameters;
205:

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

556:
557:
558: IF g_debug
559: THEN
560: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);
561: END IF;
562:
563: p_sql :=
564: 'SELECT DISTINCT person_id

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

1622:
1623: */
1624: IF g_debug
1625: THEN
1626: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
1627: END IF;
1628: EXCEPTION
1629: WHEN OTHERS
1630: THEN

Line 1647: hr_utility.set_location

1643: IS
1644: BEGIN
1645: IF g_debug
1646: THEN
1647: hr_utility.set_location
1648: (' Entering Procedure ASSIGNMENT_ACTION_CODE'
1649: , 60
1650: );
1651: END IF;

Line 1657: hr_utility.set_location

1653:
1654:
1655: IF g_debug
1656: THEN
1657: hr_utility.set_location
1658: (' Leaving Procedure ASSIGNMENT_ACTION_CODE'
1659: , 70
1660: );
1661: END IF;

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

1663: WHEN OTHERS
1664: THEN
1665: IF g_debug
1666: THEN
1667: hr_utility.set_location ('error raised assignment_action_code '
1668: , 5
1669: );
1670: END IF;
1671:

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

1689: l_prev_prepay NUMBER := 0;
1690: BEGIN
1691: IF g_debug
1692: THEN
1693: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'
1694: , 80
1695: );
1696: END IF;
1697:

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

1718: );
1719:
1720: IF g_debug
1721: THEN
1722: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'
1723: , 90
1724: );
1725: END IF;
1726: EXCEPTION

Line 1733: hr_utility.set_location ( 'ORA_ERR: '

1729: g_err_num := SQLCODE;
1730:
1731: IF g_debug
1732: THEN
1733: hr_utility.set_location ( 'ORA_ERR: '
1734: || g_err_num
1735: || 'In INITIALIZATION_CODE'
1736: , 180
1737: );

Line 1760: hr_utility.set_location

1756: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1757: BEGIN
1758: IF g_debug
1759: THEN
1760: hr_utility.set_location
1761: (' Entering Function GET_DEFINED_BALANCE_ID'
1762: , 240
1763: );
1764: END IF;

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

1773: RETURN l_defined_balance_id;
1774:
1775: IF g_debug
1776: THEN
1777: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'
1778: , 250
1779: );
1780: END IF;
1781: END get_defined_balance_id;

Line 1806: hr_utility.set_location

1802: l_return_balance_value NUMBER;
1803: BEGIN
1804: IF g_debug
1805: THEN
1806: hr_utility.set_location
1807: (' Entering Function GET_DEFINED_BALANCE_VALUE'
1808: , 240
1809: );
1810: END IF;

Line 1832: hr_utility.set_location

1828: RETURN l_return_balance_value;
1829:
1830: IF g_debug
1831: THEN
1832: hr_utility.set_location
1833: (' Leaving Function GET_DEFINED_BALANCE_VALUE'
1834: , 250
1835: );
1836: END IF;

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

1844: IS
1845: BEGIN
1846: IF g_debug
1847: THEN
1848: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
1849: END IF;
1850:
1851:
1852:

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

1851:
1852:
1853: IF g_debug
1854: THEN
1855: hr_utility.set_location (' Leaving Procedure ARCHIVE_CODE', 390);
1856: END IF;
1857: END archive_code;
1858:
1859: --- Report XML generating code

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

1875: l_iana_charset VARCHAR2 (50);
1876: BEGIN
1877: l_iana_charset := hr_se_utility.get_iana_charset;
1878:
1879: -- hr_utility.set_location ('Entering WritetoCLOB ', 70);
1880: l_str1 :=
1881: ' 1882: || l_iana_charset
1883: || '"?> ';

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

1976: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1977: END IF;
1978:
1979: p_xfdf_clob := l_xfdf_string;
1980: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1981: EXCEPTION
1982: WHEN OTHERS
1983: THEN
1984: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

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

1980: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1981: EXCEPTION
1982: WHEN OTHERS
1983: THEN
1984: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
1985: hr_utility.raise_error;
1986: END writetoclob;
1987:
1988: PROCEDURE get_xml_for_report (

Line 1985: hr_utility.raise_error;

1981: EXCEPTION
1982: WHEN OTHERS
1983: THEN
1984: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
1985: hr_utility.raise_error;
1986: END writetoclob;
1987:
1988: PROCEDURE get_xml_for_report (
1989: p_business_group_id IN NUMBER

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

2355: , g_posting_date
2356: , g_reporting_date
2357: );
2358:
2359: hr_utility.set_location('Entered Procedure GETDATA',10);
2360:
2361: /* xml_tab(l_counter).TagName :='LU_DETAILS';
2362: xml_tab(l_counter).TagValue :='LU_DETAILS';*/
2363: /* l_counter:=l_counter+1;*/

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

2362: xml_tab(l_counter).TagValue :='LU_DETAILS';*/
2363: /* l_counter:=l_counter+1;*/
2364:
2365: /* Get the File Header Information */
2366: hr_utility.set_location('Before populating pl/sql table',20);
2367: FOR csr_local IN csr_local_unit_details(p_payroll_action_id) loop
2368:
2369: xml_tab(l_counter).TagName :='LU_DETAILS';
2370: xml_tab(l_counter).TagValue :='LU_DETAILS';

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

2370: xml_tab(l_counter).TagValue :='LU_DETAILS';
2371: l_counter:=l_counter+1;
2372:
2373:
2374: hr_utility.set_location('Entered Procedure GETDATA',10);
2375:
2376: xml_tab(l_counter).TagName :='LEGAL_EMPLOYER';
2377: xml_tab(l_counter).TagValue := csr_local.Legal_Employer;
2378: l_counter:=l_counter+1;

Line 2616: hr_utility.set_location('After populating pl/sql table',30);

2612: xml_tab(l_counter).TagName :='TOTAL_LE_EMP';
2613: xml_tab(l_counter).TagValue := l_regular_men+l_regular_women+l_temp_men+l_temp_women;
2614: l_counter:=l_counter+1;
2615:
2616: hr_utility.set_location('After populating pl/sql table',30);
2617: hr_utility.set_location('Entered Procedure GETDATA',10);
2618:
2619: xml_tab(l_counter).TagName :='LU_DETAILS';
2620: xml_tab(l_counter).TagValue :='END_LU_DETAILS';

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

2613: xml_tab(l_counter).TagValue := l_regular_men+l_regular_women+l_temp_men+l_temp_women;
2614: l_counter:=l_counter+1;
2615:
2616: hr_utility.set_location('After populating pl/sql table',30);
2617: hr_utility.set_location('Entered Procedure GETDATA',10);
2618:
2619: xml_tab(l_counter).TagName :='LU_DETAILS';
2620: xml_tab(l_counter).TagValue :='END_LU_DETAILS';
2621: l_counter := l_counter + 1;