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.PER_US_EEO5_PKG dependencies on HR_UTILITY

Line 14: Name : HR_UTILITY_TRACE

10: g_meaning VARCHAR2(80);
11: g_debug BOOLEAN;
12:
13: /****************************************************************************
14: Name : HR_UTILITY_TRACE
15: Description : This function prints debug messages during diagnostics mode.
16: *****************************************************************************/
17: PROCEDURE hr_utility_trace(trc_data VARCHAR2) IS
18: BEGIN

Line 17: PROCEDURE hr_utility_trace(trc_data VARCHAR2) IS

13: /****************************************************************************
14: Name : HR_UTILITY_TRACE
15: Description : This function prints debug messages during diagnostics mode.
16: *****************************************************************************/
17: PROCEDURE hr_utility_trace(trc_data VARCHAR2) IS
18: BEGIN
19: IF g_debug THEN
20: hr_utility.trace(trc_data);
21: END IF;

Line 20: hr_utility.trace(trc_data);

16: *****************************************************************************/
17: PROCEDURE hr_utility_trace(trc_data VARCHAR2) IS
18: BEGIN
19: IF g_debug THEN
20: hr_utility.trace(trc_data);
21: END IF;
22: END hr_utility_trace;
23:
24: /*****************************************************************************

Line 22: END hr_utility_trace;

18: BEGIN
19: IF g_debug THEN
20: hr_utility.trace(trc_data);
21: END IF;
22: END hr_utility_trace;
23:
24: /*****************************************************************************
25: Name : convert_into_xml
26: Purpose : function to convert the data into an XML String

Line 147: -- hr_utility_trace(p_text);

143: -- Write to the concurrent request log
144: fnd_file.put_line(fnd_file.LOG, p_text);
145: -- Write to the concurrent request out
146: fnd_file.put_line(fnd_file.OUTPUT, p_text);
147: -- hr_utility_trace(p_text);
148: END write_to_concurrent_out;
149:
150: /*****************************************************************************
151: Name : generate_xml_data

Line 937: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);

933: ,l_ft
934: ,l_pr
935: ,l_pt);
936:
937: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);
938: hr_utility.set_location('l_fr -> '||l_fr, 5);
939: hr_utility.set_location('l_fr -> '||l_ft, 5);
940: hr_utility.set_location('l_fr -> '||l_pr, 5);
941: hr_utility.set_location('l_fr -> '||l_pt, 5);

Line 938: hr_utility.set_location('l_fr -> '||l_fr, 5);

934: ,l_pr
935: ,l_pt);
936:
937: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);
938: hr_utility.set_location('l_fr -> '||l_fr, 5);
939: hr_utility.set_location('l_fr -> '||l_ft, 5);
940: hr_utility.set_location('l_fr -> '||l_pr, 5);
941: hr_utility.set_location('l_fr -> '||l_pt, 5);
942: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);

Line 939: hr_utility.set_location('l_fr -> '||l_ft, 5);

935: ,l_pt);
936:
937: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);
938: hr_utility.set_location('l_fr -> '||l_fr, 5);
939: hr_utility.set_location('l_fr -> '||l_ft, 5);
940: hr_utility.set_location('l_fr -> '||l_pr, 5);
941: hr_utility.set_location('l_fr -> '||l_pt, 5);
942: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);
943:

Line 940: hr_utility.set_location('l_fr -> '||l_pr, 5);

936:
937: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);
938: hr_utility.set_location('l_fr -> '||l_fr, 5);
939: hr_utility.set_location('l_fr -> '||l_ft, 5);
940: hr_utility.set_location('l_fr -> '||l_pr, 5);
941: hr_utility.set_location('l_fr -> '||l_pt, 5);
942: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);
943:
944: --l_report_date is always for September.

Line 941: hr_utility.set_location('l_fr -> '||l_pt, 5);

937: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);
938: hr_utility.set_location('l_fr -> '||l_fr, 5);
939: hr_utility.set_location('l_fr -> '||l_ft, 5);
940: hr_utility.set_location('l_fr -> '||l_pr, 5);
941: hr_utility.set_location('l_fr -> '||l_pt, 5);
942: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);
943:
944: --l_report_date is always for September.
945: l_report_date := TO_DATE('30-09'||'-'||p_reporting_year,'DD-MM-RRRR');

Line 942: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);

938: hr_utility.set_location('l_fr -> '||l_fr, 5);
939: hr_utility.set_location('l_fr -> '||l_ft, 5);
940: hr_utility.set_location('l_fr -> '||l_pr, 5);
941: hr_utility.set_location('l_fr -> '||l_pt, 5);
942: hr_utility.set_location('=======in EEO5 per_us_eeo5_pkg==========='||l_fr, 5);
943:
944: --l_report_date is always for September.
945: l_report_date := TO_DATE('30-09'||'-'||p_reporting_year,'DD-MM-RRRR');
946: l_xml_string := l_xml_string ||convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','A. FULL-TIME STAFF','D');

Line 1011: hr_utility_trace('==================================================');

1007: l_sum_no_cons_bfemale_emps := l_sum_no_cons_bfemale_emps + i.no_cons_bfemale_emps + no_tmraces_bfemale_emps;
1008: l_sum_no_cons_hfemale_emps := l_sum_no_cons_hfemale_emps + i.no_cons_hfemale_emps + no_tmraces_hfemale_emps;
1009: l_sum_no_cons_afemale_emps := l_sum_no_cons_afemale_emps + i.no_cons_afemale_emps + no_tmraces_afemale_emps;
1010: l_sum_no_cons_ifemale_emps := l_sum_no_cons_ifemale_emps + i.no_cons_ifemale_emps + no_tmraces_ifemale_emps;
1011: hr_utility_trace('==================================================');
1012: hr_utility_trace(' i.job_category_name -> ' || i.job_category_name);
1013: hr_utility_trace(' l_start_code -> ' || l_start_code);
1014: hr_utility_trace(' l_end_code -> ' || l_end_code);
1015: hr_utility_trace(' l_current_code -> ' || l_current_code);

Line 1012: hr_utility_trace(' i.job_category_name -> ' || i.job_category_name);

1008: l_sum_no_cons_hfemale_emps := l_sum_no_cons_hfemale_emps + i.no_cons_hfemale_emps + no_tmraces_hfemale_emps;
1009: l_sum_no_cons_afemale_emps := l_sum_no_cons_afemale_emps + i.no_cons_afemale_emps + no_tmraces_afemale_emps;
1010: l_sum_no_cons_ifemale_emps := l_sum_no_cons_ifemale_emps + i.no_cons_ifemale_emps + no_tmraces_ifemale_emps;
1011: hr_utility_trace('==================================================');
1012: hr_utility_trace(' i.job_category_name -> ' || i.job_category_name);
1013: hr_utility_trace(' l_start_code -> ' || l_start_code);
1014: hr_utility_trace(' l_end_code -> ' || l_end_code);
1015: hr_utility_trace(' l_current_code -> ' || l_current_code);
1016: hr_utility_trace('==================================================');

Line 1013: hr_utility_trace(' l_start_code -> ' || l_start_code);

1009: l_sum_no_cons_afemale_emps := l_sum_no_cons_afemale_emps + i.no_cons_afemale_emps + no_tmraces_afemale_emps;
1010: l_sum_no_cons_ifemale_emps := l_sum_no_cons_ifemale_emps + i.no_cons_ifemale_emps + no_tmraces_ifemale_emps;
1011: hr_utility_trace('==================================================');
1012: hr_utility_trace(' i.job_category_name -> ' || i.job_category_name);
1013: hr_utility_trace(' l_start_code -> ' || l_start_code);
1014: hr_utility_trace(' l_end_code -> ' || l_end_code);
1015: hr_utility_trace(' l_current_code -> ' || l_current_code);
1016: hr_utility_trace('==================================================');
1017: l_start_code := l_current_code+1;

Line 1014: hr_utility_trace(' l_end_code -> ' || l_end_code);

1010: l_sum_no_cons_ifemale_emps := l_sum_no_cons_ifemale_emps + i.no_cons_ifemale_emps + no_tmraces_ifemale_emps;
1011: hr_utility_trace('==================================================');
1012: hr_utility_trace(' i.job_category_name -> ' || i.job_category_name);
1013: hr_utility_trace(' l_start_code -> ' || l_start_code);
1014: hr_utility_trace(' l_end_code -> ' || l_end_code);
1015: hr_utility_trace(' l_current_code -> ' || l_current_code);
1016: hr_utility_trace('==================================================');
1017: l_start_code := l_current_code+1;
1018: END LOOP;/* csr_full_time_details */

Line 1015: hr_utility_trace(' l_current_code -> ' || l_current_code);

1011: hr_utility_trace('==================================================');
1012: hr_utility_trace(' i.job_category_name -> ' || i.job_category_name);
1013: hr_utility_trace(' l_start_code -> ' || l_start_code);
1014: hr_utility_trace(' l_end_code -> ' || l_end_code);
1015: hr_utility_trace(' l_current_code -> ' || l_current_code);
1016: hr_utility_trace('==================================================');
1017: l_start_code := l_current_code+1;
1018: END LOOP;/* csr_full_time_details */
1019:

Line 1016: hr_utility_trace('==================================================');

1012: hr_utility_trace(' i.job_category_name -> ' || i.job_category_name);
1013: hr_utility_trace(' l_start_code -> ' || l_start_code);
1014: hr_utility_trace(' l_end_code -> ' || l_end_code);
1015: hr_utility_trace(' l_current_code -> ' || l_current_code);
1016: hr_utility_trace('==================================================');
1017: l_start_code := l_current_code+1;
1018: END LOOP;/* csr_full_time_details */
1019:
1020: hr_utility_trace('==================================================');

Line 1020: hr_utility_trace('==================================================');

1016: hr_utility_trace('==================================================');
1017: l_start_code := l_current_code+1;
1018: END LOOP;/* csr_full_time_details */
1019:
1020: hr_utility_trace('==================================================');
1021: hr_utility_trace(' Out of the Loop -> ');
1022: hr_utility_trace(' length(l_xml_string) -> ' || length(l_xml_string));
1023: hr_utility_trace(' l_start_code -> ' || l_start_code);
1024: hr_utility_trace(' l_end_code -> ' || l_end_code);

Line 1021: hr_utility_trace(' Out of the Loop -> ');

1017: l_start_code := l_current_code+1;
1018: END LOOP;/* csr_full_time_details */
1019:
1020: hr_utility_trace('==================================================');
1021: hr_utility_trace(' Out of the Loop -> ');
1022: hr_utility_trace(' length(l_xml_string) -> ' || length(l_xml_string));
1023: hr_utility_trace(' l_start_code -> ' || l_start_code);
1024: hr_utility_trace(' l_end_code -> ' || l_end_code);
1025: hr_utility_trace(' l_current_code -> ' || l_current_code);

Line 1022: hr_utility_trace(' length(l_xml_string) -> ' || length(l_xml_string));

1018: END LOOP;/* csr_full_time_details */
1019:
1020: hr_utility_trace('==================================================');
1021: hr_utility_trace(' Out of the Loop -> ');
1022: hr_utility_trace(' length(l_xml_string) -> ' || length(l_xml_string));
1023: hr_utility_trace(' l_start_code -> ' || l_start_code);
1024: hr_utility_trace(' l_end_code -> ' || l_end_code);
1025: hr_utility_trace(' l_current_code -> ' || l_current_code);
1026: hr_utility_trace('==================================================');

Line 1023: hr_utility_trace(' l_start_code -> ' || l_start_code);

1019:
1020: hr_utility_trace('==================================================');
1021: hr_utility_trace(' Out of the Loop -> ');
1022: hr_utility_trace(' length(l_xml_string) -> ' || length(l_xml_string));
1023: hr_utility_trace(' l_start_code -> ' || l_start_code);
1024: hr_utility_trace(' l_end_code -> ' || l_end_code);
1025: hr_utility_trace(' l_current_code -> ' || l_current_code);
1026: hr_utility_trace('==================================================');
1027:

Line 1024: hr_utility_trace(' l_end_code -> ' || l_end_code);

1020: hr_utility_trace('==================================================');
1021: hr_utility_trace(' Out of the Loop -> ');
1022: hr_utility_trace(' length(l_xml_string) -> ' || length(l_xml_string));
1023: hr_utility_trace(' l_start_code -> ' || l_start_code);
1024: hr_utility_trace(' l_end_code -> ' || l_end_code);
1025: hr_utility_trace(' l_current_code -> ' || l_current_code);
1026: hr_utility_trace('==================================================');
1027:
1028: IF l_start_code = 1 THEN

Line 1025: hr_utility_trace(' l_current_code -> ' || l_current_code);

1021: hr_utility_trace(' Out of the Loop -> ');
1022: hr_utility_trace(' length(l_xml_string) -> ' || length(l_xml_string));
1023: hr_utility_trace(' l_start_code -> ' || l_start_code);
1024: hr_utility_trace(' l_end_code -> ' || l_end_code);
1025: hr_utility_trace(' l_current_code -> ' || l_current_code);
1026: hr_utility_trace('==================================================');
1027:
1028: IF l_start_code = 1 THEN
1029: -- Cursor csr_full_time_details did not fetch any records.

Line 1026: hr_utility_trace('==================================================');

1022: hr_utility_trace(' length(l_xml_string) -> ' || length(l_xml_string));
1023: hr_utility_trace(' l_start_code -> ' || l_start_code);
1024: hr_utility_trace(' l_end_code -> ' || l_end_code);
1025: hr_utility_trace(' l_current_code -> ' || l_current_code);
1026: hr_utility_trace('==================================================');
1027:
1028: IF l_start_code = 1 THEN
1029: -- Cursor csr_full_time_details did not fetch any records.
1030: l_end_code := 18;

Line 1459: -- hr_utility.trace_on(null,'EEO5');

1455:
1456:
1457: --To put the trace just uncomment the below three lines.
1458: --BEGIN
1459: -- hr_utility.trace_on(null,'EEO5');
1460: -- g_debug := hr_utility.debug_enabled;
1461: END per_us_eeo5_pkg;

Line 1460: -- g_debug := hr_utility.debug_enabled;

1456:
1457: --To put the trace just uncomment the below three lines.
1458: --BEGIN
1459: -- hr_utility.trace_on(null,'EEO5');
1460: -- g_debug := hr_utility.debug_enabled;
1461: END per_us_eeo5_pkg;