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.5 2010/03/22 12:32: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 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 623: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);

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

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

1546: END IF;
1547: END IF;
1548: IF g_debug
1549: THEN
1550: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
1551: END IF;
1552: EXCEPTION
1553: WHEN OTHERS
1554: THEN

Line 1571: hr_utility.set_location

1567: IS
1568: BEGIN
1569: IF g_debug
1570: THEN
1571: hr_utility.set_location
1572: (' Entering Procedure ASSIGNMENT_ACTION_CODE'
1573: , 60
1574: );
1575: END IF;

Line 1580: hr_utility.set_location

1576:
1577:
1578: IF g_debug
1579: THEN
1580: hr_utility.set_location
1581: (' Leaving Procedure ASSIGNMENT_ACTION_CODE'
1582: , 70
1583: );
1584: END IF;

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

1586: WHEN OTHERS
1587: THEN
1588: IF g_debug
1589: THEN
1590: hr_utility.set_location ('error raised assignment_action_code '
1591: , 5
1592: );
1593: END IF;
1594:

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

1612: l_prev_prepay NUMBER := 0;
1613: BEGIN
1614: IF g_debug
1615: THEN
1616: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'
1617: , 80
1618: );
1619: END IF;
1620:

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

1641: );
1642:
1643: IF g_debug
1644: THEN
1645: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'
1646: , 90
1647: );
1648: END IF;
1649: EXCEPTION

Line 1656: hr_utility.set_location ( 'ORA_ERR: '

1652: g_err_num := SQLCODE;
1653:
1654: IF g_debug
1655: THEN
1656: hr_utility.set_location ( 'ORA_ERR: '
1657: || g_err_num
1658: || 'In INITIALIZATION_CODE'
1659: , 180
1660: );

Line 1683: hr_utility.set_location

1679: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1680: BEGIN
1681: IF g_debug
1682: THEN
1683: hr_utility.set_location
1684: (' Entering Function GET_DEFINED_BALANCE_ID'
1685: , 240
1686: );
1687: END IF;

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

1696: RETURN l_defined_balance_id;
1697:
1698: IF g_debug
1699: THEN
1700: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'
1701: , 250
1702: );
1703: END IF;
1704: END get_defined_balance_id;

Line 1729: hr_utility.set_location

1725: l_return_balance_value NUMBER;
1726: BEGIN
1727: IF g_debug
1728: THEN
1729: hr_utility.set_location
1730: (' Entering Function GET_DEFINED_BALANCE_VALUE'
1731: , 240
1732: );
1733: END IF;

Line 1755: hr_utility.set_location

1751: RETURN l_return_balance_value;
1752:
1753: IF g_debug
1754: THEN
1755: hr_utility.set_location
1756: (' Leaving Function GET_DEFINED_BALANCE_VALUE'
1757: , 250
1758: );
1759: END IF;

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

1767: IS
1768: BEGIN
1769: IF g_debug
1770: THEN
1771: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
1772: END IF;
1773:
1774:
1775:

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

1774:
1775:
1776: IF g_debug
1777: THEN
1778: hr_utility.set_location (' Leaving Procedure ARCHIVE_CODE', 390);
1779: END IF;
1780: END archive_code;
1781:
1782: --- Report XML generating code

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

1798: l_iana_charset VARCHAR2 (50);
1799: BEGIN
1800: l_iana_charset := hr_se_utility.get_iana_charset;
1801:
1802: -- hr_utility.set_location ('Entering WritetoCLOB ', 70);
1803: l_str1 :=
1804: ' 1805: || l_iana_charset
1806: || '"?> ';

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

1903: ELSE
1904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1905: END IF;
1906: p_xfdf_clob := l_xfdf_string;
1907: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1908: EXCEPTION
1909: WHEN OTHERS
1910: THEN
1911: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

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

1907: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1908: EXCEPTION
1909: WHEN OTHERS
1910: THEN
1911: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
1912: hr_utility.raise_error;
1913: END writetoclob;
1914:
1915: PROCEDURE get_xml_for_report (

Line 1912: hr_utility.raise_error;

1908: EXCEPTION
1909: WHEN OTHERS
1910: THEN
1911: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
1912: hr_utility.raise_error;
1913: END writetoclob;
1914:
1915: PROCEDURE get_xml_for_report (
1916: p_business_group_id IN NUMBER

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

2307: , g_local_unit_id
2308: , g_year
2309: );
2310:
2311: hr_utility.set_location('Entered Procedure GETDATA',10);
2312:
2313: /* xml_tab(l_counter).TagName :='LU_DETAILS';
2314: xml_tab(l_counter).TagValue :='LU_DETAILS';*/
2315: /* l_counter:=l_counter+1;*/

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

2314: xml_tab(l_counter).TagValue :='LU_DETAILS';*/
2315: /* l_counter:=l_counter+1;*/
2316:
2317: /* Get the File Header Information */
2318: hr_utility.set_location('Before populating pl/sql table',20);
2319: l_lu_salary:=0;
2320: IF p_employee_category IN ('B','W') THEN
2321: xml_tab(l_counter).TagName :='EMP_CAT_DETAILS';
2322: xml_tab(l_counter).TagValue :='EMP_CAT_DETAILS';

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

2328: xml_tab(l_counter).TagValue :='LU_DETAILS';
2329: l_counter:=l_counter+1;
2330: -- fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);
2331:
2332: hr_utility.set_location('Entered Procedure GETDATA',10);
2333:
2334: xml_tab(l_counter).TagName :='LEGAL_EMPLOYER';
2335: xml_tab(l_counter).TagValue := csr_local.Legal_Employer;
2336: l_counter:=l_counter+1;

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

2481: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2482:
2483: l_lu_salary:=0;
2484:
2485: hr_utility.set_location('After populating pl/sql table',30);
2486: hr_utility.set_location('Entered Procedure GETDATA',10);
2487:
2488: xml_tab(l_counter).TagName :='LU_DETAILS';
2489: xml_tab(l_counter).TagValue :='END_LU_DETAILS';

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

2482:
2483: l_lu_salary:=0;
2484:
2485: hr_utility.set_location('After populating pl/sql table',30);
2486: hr_utility.set_location('Entered Procedure GETDATA',10);
2487:
2488: xml_tab(l_counter).TagName :='LU_DETAILS';
2489: xml_tab(l_counter).TagValue :='END_LU_DETAILS';
2490: l_counter := l_counter + 1;

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

2524: xml_tab(l_counter).TagValue :='LU_DETAILS';
2525: l_counter:=l_counter+1;
2526: -- fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);
2527:
2528: hr_utility.set_location('Entered Procedure GETDATA',10);
2529:
2530: xml_tab(l_counter).TagName :='LEGAL_EMPLOYER';
2531: xml_tab(l_counter).TagValue := csr_local.Legal_Employer;
2532: l_counter:=l_counter+1;

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

2687: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2688:
2689: l_lu_salary:=0;
2690:
2691: hr_utility.set_location('After populating pl/sql table',30);
2692: hr_utility.set_location('Entered Procedure GETDATA',10);
2693:
2694: xml_tab(l_counter).TagName :='LU_DETAILS';
2695: xml_tab(l_counter).TagValue :='END_LU_DETAILS';

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

2688:
2689: l_lu_salary:=0;
2690:
2691: hr_utility.set_location('After populating pl/sql table',30);
2692: hr_utility.set_location('Entered Procedure GETDATA',10);
2693:
2694: xml_tab(l_counter).TagName :='LU_DETAILS';
2695: xml_tab(l_counter).TagValue :='END_LU_DETAILS';
2696: l_counter := l_counter + 1;