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

Line 6: g_debug BOOLEAN := hr_utility.debug_enabled;

2: /* $Header: pydkstatsr.pkb 120.11.12000000.6 2007/06/08 11:49:28 nprasath noship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_STATSR_PKG.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7: g_err_num NUMBER;
8:
9:
10:

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

44: l_delimiter VARCHAR2(1):=' ';
45:
46: BEGIN
47: IF g_debug THEN
48: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
49: END IF;
50:
51: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
52:

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

70: END IF;
71:
72: RETURN l_parameter;
73: IF g_debug THEN
74: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
75: END IF;
76:
77: END GET_PARAMETER;
78:

Line 110: hr_utility.set_location(' Entering procedure '||l_proc,10);

106: --
107: BEGIN
108:
109: IF g_debug THEN
110: hr_utility.set_location(' Entering procedure '||l_proc,10);
111: END IF;
112:
113: OPEN csr_parameter_info (p_payroll_action_id);
114:

Line 126: hr_utility.set_location(' Leaving procedure '||l_proc,20);

122: ,p_business_group_id;
123: CLOSE csr_parameter_info;
124: --
125: IF g_debug THEN
126: hr_utility.set_location(' Leaving procedure '||l_proc,20);
127: END IF;
128: END GET_ALL_PARAMETERS;
129:
130: ----------------------------------------------------

Line 151: hr_utility.set_location('Entering:'|| l_proc, 1);

147: l_proc varchar2(72) := g_package||'get_global_value';
148:
149: BEGIN
150: IF g_debug THEN
151: hr_utility.set_location('Entering:'|| l_proc, 1);
152: END IF;
153:
154: OPEN csr_globals;
155: FETCH csr_globals INTO l_global_value;

Line 159: hr_utility.set_location('Entering:'|| l_proc, 2);

155: FETCH csr_globals INTO l_global_value;
156: CLOSE csr_globals;
157:
158: IF g_debug THEN
159: hr_utility.set_location('Entering:'|| l_proc, 2);
160: END IF;
161:
162: RETURN l_global_value;
163: END GET_GLOBAL_VALUE;

Line 399: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);

395:
396: BEGIN
397:
398: IF g_debug THEN
399: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
400: END IF;
401:
402:
403: -- The sql string to return

Line 560: hr_utility.set_location(' Leaving Procedure RANGE_CODE',20);

556:
557: END IF;
558:
559: IF g_debug THEN
560: hr_utility.set_location(' Leaving Procedure RANGE_CODE',20);
561: END IF;
562:
563: EXCEPTION WHEN e_no_da_sys_no THEN
564: fnd_message.set_name('PAY','PAY_377058_DK_NO_DA_CODE_ERR');

Line 860: hr_utility.trace('Inside the Statistics Report');

856:
857: l_bal_todate DATE;
858: l_hourly_salaried per_all_assignments_f.hourly_salaried_code%TYPE ;
859: BEGIN
860: hr_utility.trace('Inside the Statistics Report');
861:
862: IF g_debug THEN
863: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
864: END IF;

Line 863: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);

859: BEGIN
860: hr_utility.trace('Inside the Statistics Report');
861:
862: IF g_debug THEN
863: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
864: END IF;
865:
866: SELECT PAY_DK_STATSR_PKG.GET_PARAMETER(legislative_parameters,'SPAN_RPT')
867: INTO l_span

Line 951: hr_utility.trace(' * Intializing the old variables ');

947: and for Archiving the data Bug Fix-5003220*/
948: -- nprasath added for Multiple Records
949: IF (csr_rec.asg_id <> l_asgid) THEN
950:
951: hr_utility.trace(' ***** Intializing the old variables **** ');
952:
953: l_old_iltype_0010_bal := 0;
954: l_old_iltype_0011_bal := 0;
955: l_old_iltype_0013_bal := 0;

Line 1493: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',20);

1489: END LOOP;
1490:
1491:
1492: IF g_debug THEN
1493: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',20);
1494: END IF;
1495:
1496: EXCEPTION
1497: WHEN e_too_many_hours THEN

Line 1520: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',10);

1516:
1517: NULL;
1518:
1519: IF g_debug THEN
1520: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',10);
1521: END IF;
1522:
1523:
1524: IF g_debug THEN

Line 1525: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',20);

1521: END IF;
1522:
1523:
1524: IF g_debug THEN
1525: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',20);
1526: END IF;
1527:
1528: EXCEPTION WHEN OTHERS THEN
1529: g_err_num := SQLCODE;

Line 1532: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',30);

1528: EXCEPTION WHEN OTHERS THEN
1529: g_err_num := SQLCODE;
1530:
1531: IF g_debug THEN
1532: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',30);
1533: END IF;
1534:
1535: END INITIALIZATION_CODE;
1536:

Line 1546: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',10);

1542: IS
1543:
1544: BEGIN
1545: IF g_debug THEN
1546: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',10);
1547: END IF;
1548:
1549: IF g_debug THEN
1550: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',20);

Line 1550: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',20);

1546: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',10);
1547: END IF;
1548:
1549: IF g_debug THEN
1550: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',20);
1551: END IF;
1552:
1553: END ARCHIVE_CODE;
1554:

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

1677:
1678: l_payroll_action_id :=p_payroll_action_id;
1679:
1680: END IF;
1681: hr_utility.set_location('Entered Procedure GETDATA',10);
1682:
1683: /* Get the File Start and End Record Information */
1684: OPEN csr_get_hdr_info(l_payroll_action_id);
1685: FETCH csr_get_hdr_info INTO rec_get_hdr_info;

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

1684: OPEN csr_get_hdr_info(l_payroll_action_id);
1685: FETCH csr_get_hdr_info INTO rec_get_hdr_info;
1686: CLOSE csr_get_hdr_info;
1687:
1688: hr_utility.set_location('Before populating pl/sql table',20);
1689:
1690: xml_tab(l_counter).TagName :='FILE_HEADER_FOOTER_START';
1691: xml_tab(l_counter).TagValue :='FILE_HEADER_FOOTER_START';
1692: l_counter := l_counter + 1;

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

2062: xml_tab(l_counter).TagName :='FILE_HEADER_FOOTER_START';
2063: xml_tab(l_counter).TagValue :='FILE_HEADER_FOOTER_END';
2064: l_counter := l_counter + 1;
2065:
2066: hr_utility.set_location('After populating pl/sql table',30);
2067: hr_utility.set_location('Entered Procedure GETDATA',10);
2068:
2069:
2070: WritetoCLOB (p_xml );

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

2063: xml_tab(l_counter).TagValue :='FILE_HEADER_FOOTER_END';
2064: l_counter := l_counter + 1;
2065:
2066: hr_utility.set_location('After populating pl/sql table',30);
2067: hr_utility.set_location('Entered Procedure GETDATA',10);
2068:
2069:
2070: WritetoCLOB (p_xml );
2071:

Line 2095: hr_utility.set_location('Entering WritetoCLOB ',10);

2091: current_index pls_integer;
2092:
2093: BEGIN
2094:
2095: hr_utility.set_location('Entering WritetoCLOB ',10);
2096: l_IANA_charset :=PAY_DK_GENERAL.get_IANA_charset ;
2097: --l_str1 := ' ' ;
2098: l_str1 := ' ';
2099: l_str2 := '<';

Line 2172: hr_utility.set_location('Leaving WritetoCLOB ',20);

2168: END IF;
2169:
2170: p_xfdf_clob := l_xfdf_string;
2171:
2172: hr_utility.set_location('Leaving WritetoCLOB ',20);
2173:
2174:
2175: EXCEPTION
2176: WHEN OTHERS then

Line 2177: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);

2173:
2174:
2175: EXCEPTION
2176: WHEN OTHERS then
2177: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
2178: HR_UTILITY.RAISE_ERROR;
2179: END WritetoCLOB;
2180:
2181: END PAY_DK_STATSR_PKG;

Line 2178: HR_UTILITY.RAISE_ERROR;

2174:
2175: EXCEPTION
2176: WHEN OTHERS then
2177: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
2178: HR_UTILITY.RAISE_ERROR;
2179: END WritetoCLOB;
2180:
2181: END PAY_DK_STATSR_PKG;