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

Line 3: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_SE_FORA AS
2: /* $Header: pysefora.pkb 120.0.12010000.3 2008/11/11 10:10:15 rmurahar ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (
6: archive_assact_id NUMBER
7: );

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

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

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

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

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

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

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

616:
617:
618: IF g_debug
619: THEN
620: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);
621: END IF;
622:
623: p_sql :=
624: 'SELECT DISTINCT person_id

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

1520: END IF;
1521: END IF;
1522: IF g_debug
1523: THEN
1524: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
1525: END IF;
1526: EXCEPTION
1527: WHEN OTHERS
1528: THEN

Line 1545: hr_utility.set_location

1541: IS
1542: BEGIN
1543: IF g_debug
1544: THEN
1545: hr_utility.set_location
1546: (' Entering Procedure ASSIGNMENT_ACTION_CODE'
1547: , 60
1548: );
1549: END IF;

Line 1554: hr_utility.set_location

1550:
1551:
1552: IF g_debug
1553: THEN
1554: hr_utility.set_location
1555: (' Leaving Procedure ASSIGNMENT_ACTION_CODE'
1556: , 70
1557: );
1558: END IF;

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

1560: WHEN OTHERS
1561: THEN
1562: IF g_debug
1563: THEN
1564: hr_utility.set_location ('error raised assignment_action_code '
1565: , 5
1566: );
1567: END IF;
1568:

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

1586: l_prev_prepay NUMBER := 0;
1587: BEGIN
1588: IF g_debug
1589: THEN
1590: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'
1591: , 80
1592: );
1593: END IF;
1594:

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

1615: );
1616:
1617: IF g_debug
1618: THEN
1619: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'
1620: , 90
1621: );
1622: END IF;
1623: EXCEPTION

Line 1630: hr_utility.set_location ( 'ORA_ERR: '

1626: g_err_num := SQLCODE;
1627:
1628: IF g_debug
1629: THEN
1630: hr_utility.set_location ( 'ORA_ERR: '
1631: || g_err_num
1632: || 'In INITIALIZATION_CODE'
1633: , 180
1634: );

Line 1657: hr_utility.set_location

1653: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1654: BEGIN
1655: IF g_debug
1656: THEN
1657: hr_utility.set_location
1658: (' Entering Function GET_DEFINED_BALANCE_ID'
1659: , 240
1660: );
1661: END IF;

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

1670: RETURN l_defined_balance_id;
1671:
1672: IF g_debug
1673: THEN
1674: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'
1675: , 250
1676: );
1677: END IF;
1678: END get_defined_balance_id;

Line 1703: hr_utility.set_location

1699: l_return_balance_value NUMBER;
1700: BEGIN
1701: IF g_debug
1702: THEN
1703: hr_utility.set_location
1704: (' Entering Function GET_DEFINED_BALANCE_VALUE'
1705: , 240
1706: );
1707: END IF;

Line 1729: hr_utility.set_location

1725: RETURN l_return_balance_value;
1726:
1727: IF g_debug
1728: THEN
1729: hr_utility.set_location
1730: (' Leaving Function GET_DEFINED_BALANCE_VALUE'
1731: , 250
1732: );
1733: END IF;

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

1741: IS
1742: BEGIN
1743: IF g_debug
1744: THEN
1745: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
1746: END IF;
1747:
1748:
1749:

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

1748:
1749:
1750: IF g_debug
1751: THEN
1752: hr_utility.set_location (' Leaving Procedure ARCHIVE_CODE', 390);
1753: END IF;
1754: END archive_code;
1755:
1756: --- Report XML generating code

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

1772: l_iana_charset VARCHAR2 (50);
1773: BEGIN
1774: l_iana_charset := hr_se_utility.get_iana_charset;
1775:
1776: -- hr_utility.set_location ('Entering WritetoCLOB ', 70);
1777: l_str1 :=
1778: ' 1779: || l_iana_charset
1780: || '"?> ';

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

1877: ELSE
1878: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1879: END IF;
1880: p_xfdf_clob := l_xfdf_string;
1881: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1882: EXCEPTION
1883: WHEN OTHERS
1884: THEN
1885: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

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

1881: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1882: EXCEPTION
1883: WHEN OTHERS
1884: THEN
1885: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
1886: hr_utility.raise_error;
1887: END writetoclob;
1888:
1889: PROCEDURE get_xml_for_report (

Line 1886: hr_utility.raise_error;

1882: EXCEPTION
1883: WHEN OTHERS
1884: THEN
1885: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
1886: hr_utility.raise_error;
1887: END writetoclob;
1888:
1889: PROCEDURE get_xml_for_report (
1890: p_business_group_id IN NUMBER

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

2278: , g_local_unit_id
2279: , g_year
2280: );
2281:
2282: hr_utility.set_location('Entered Procedure GETDATA',10);
2283:
2284: /* xml_tab(l_counter).TagName :='LU_DETAILS';
2285: xml_tab(l_counter).TagValue :='LU_DETAILS';*/
2286: /* l_counter:=l_counter+1;*/

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

2285: xml_tab(l_counter).TagValue :='LU_DETAILS';*/
2286: /* l_counter:=l_counter+1;*/
2287:
2288: /* Get the File Header Information */
2289: hr_utility.set_location('Before populating pl/sql table',20);
2290: l_lu_salary:=0;
2291: IF p_employee_category IN ('B','W') THEN
2292: xml_tab(l_counter).TagName :='EMP_CAT_DETAILS';
2293: xml_tab(l_counter).TagValue :='EMP_CAT_DETAILS';

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

2299: xml_tab(l_counter).TagValue :='LU_DETAILS';
2300: l_counter:=l_counter+1;
2301: -- fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);
2302:
2303: hr_utility.set_location('Entered Procedure GETDATA',10);
2304:
2305: xml_tab(l_counter).TagName :='LEGAL_EMPLOYER';
2306: xml_tab(l_counter).TagValue := csr_local.Legal_Employer;
2307: l_counter:=l_counter+1;

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

2433: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2434:
2435: l_lu_salary:=0;
2436:
2437: hr_utility.set_location('After populating pl/sql table',30);
2438: hr_utility.set_location('Entered Procedure GETDATA',10);
2439:
2440: xml_tab(l_counter).TagName :='LU_DETAILS';
2441: xml_tab(l_counter).TagValue :='END_LU_DETAILS';

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

2434:
2435: l_lu_salary:=0;
2436:
2437: hr_utility.set_location('After populating pl/sql table',30);
2438: hr_utility.set_location('Entered Procedure GETDATA',10);
2439:
2440: xml_tab(l_counter).TagName :='LU_DETAILS';
2441: xml_tab(l_counter).TagValue :='END_LU_DETAILS';
2442: l_counter := l_counter + 1;

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

2476: xml_tab(l_counter).TagValue :='LU_DETAILS';
2477: l_counter:=l_counter+1;
2478: -- fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);
2479:
2480: hr_utility.set_location('Entered Procedure GETDATA',10);
2481:
2482: xml_tab(l_counter).TagName :='LEGAL_EMPLOYER';
2483: xml_tab(l_counter).TagValue := csr_local.Legal_Employer;
2484: l_counter:=l_counter+1;

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

2616: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2617:
2618: l_lu_salary:=0;
2619:
2620: hr_utility.set_location('After populating pl/sql table',30);
2621: hr_utility.set_location('Entered Procedure GETDATA',10);
2622:
2623: xml_tab(l_counter).TagName :='LU_DETAILS';
2624: xml_tab(l_counter).TagValue :='END_LU_DETAILS';

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

2617:
2618: l_lu_salary:=0;
2619:
2620: hr_utility.set_location('After populating pl/sql table',30);
2621: hr_utility.set_location('Entered Procedure GETDATA',10);
2622:
2623: xml_tab(l_counter).TagName :='LU_DETAILS';
2624: xml_tab(l_counter).TagValue :='END_LU_DETAILS';
2625: l_counter := l_counter + 1;