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_EEO4_PKG dependencies on FND_FILE

Line 248: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

244: ELSIF p_function_code = 150 THEN
245: l_xml_string := convert_into_xml('G_FUN_15_CHECK_VAL','true','D');
246: END IF;
247:
248: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
250: END check_function;
251:
252: -- Added Bug# 5415136

Line 249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

245: l_xml_string := convert_into_xml('G_FUN_15_CHECK_VAL','true','D');
246: END IF;
247:
248: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
250: END check_function;
251:
252: -- Added Bug# 5415136
253: /*****************************************************************************

Line 305: --fnd_file.put_line(fnd_file.log, p_text);

301: PROCEDURE write_to_concurrent_out (p_text VARCHAR2) IS
302: --
303: BEGIN
304: -- Write to the concurrent request log
305: --fnd_file.put_line(fnd_file.log, p_text);
306: -- Write to the concurrent request out
307: fnd_file.put_line(fnd_file.OUTPUT, p_text);
308:
309: END write_to_concurrent_out;

Line 307: fnd_file.put_line(fnd_file.OUTPUT, p_text);

303: BEGIN
304: -- Write to the concurrent request log
305: --fnd_file.put_line(fnd_file.log, p_text);
306: -- Write to the concurrent request out
307: fnd_file.put_line(fnd_file.OUTPUT, p_text);
308:
309: END write_to_concurrent_out;
310:
311: PROCEDURE generate_sql(p_job_codes IN VARCHAR2 , p_dynamic_where IN VARCHAR2) IS

Line 320: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql: '|| g_nh_sql);

316: ||' AND job.job_information7 in (' || p_job_codes || ')'
317: ||' AND hl.lookup_code = :1 '
318: ||' AND ass.employment_category in (''FR'')' || g_group_order_by;
319:
320: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql: '|| g_nh_sql);
321:
322: g_ft_emp_sql := 'SELECT hl.lookup_code job_category_code,
323: hl.meaning job_category_name,'
324: ||g_select_clause || g_from_where_clause|| g_ft_effective_dates

Line 331: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql: '|| g_ft_emp_sql);

327: || p_dynamic_where
328: ||' AND ass.employment_category in (''FR'')'
329: || g_group_order_by;
330:
331: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql: '|| g_ft_emp_sql);
332:
333: g_oft_sql := 'SELECT hl.lookup_code job_category_code,
334: hl.meaning job_category_name,'
335: ||g_select_clause||g_from_where_clause||g_ft_effective_dates

Line 341: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql: '|| g_oft_sql);

337: ||' AND hl.lookup_code = :1 '
338: ||' AND ass.employment_category NOT IN (''FR'')'
339: ||g_group_order_by;
340:
341: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql: '|| g_oft_sql);
342:
343:
344: --Bug# 5593259
345: g_tmr_nh_sql := 'SELECT hl.lookup_code job_category_code,

Line 352: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_nh_sql: '|| g_tmr_nh_sql);

348: ||' AND job.job_information7 in (' || p_job_codes || ')'
349: ||' AND hl.lookup_code = :1 '
350: ||' AND ass.employment_category in (''FR'')' || g_group_order_by;
351:
352: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_nh_sql: '|| g_tmr_nh_sql);
353:
354: g_tmr_ft_emp_sql := 'SELECT hl.lookup_code job_category_code,
355: hl.meaning job_category_name,'
356: || g_tmraces_select_clause || g_tmraces_where_clause|| g_ft_effective_dates

Line 363: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_ft_emp_sql: '|| g_tmr_ft_emp_sql);

359: || p_dynamic_where
360: ||' AND ass.employment_category in (''FR'')'
361: || g_group_order_by;
362:
363: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_ft_emp_sql: '|| g_tmr_ft_emp_sql);
364:
365: g_tmr_oft_sql := 'SELECT hl.lookup_code job_category_code,
366: hl.meaning job_category_name,'
367: || g_tmraces_select_clause || g_tmraces_where_clause ||g_ft_effective_dates

Line 373: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_oft_sql: '|| g_tmr_oft_sql);

369: ||' AND hl.lookup_code = :1 '
370: ||' AND ass.employment_category NOT IN (''FR'')'
371: ||g_group_order_by;
372:
373: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_oft_sql: '|| g_tmr_oft_sql);
374:
375: END generate_sql;
376:
377: PROCEDURE generate_xml_data(errbuf OUT NOCOPY VARCHAR2

Line 570: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ft_emp_count: ' || l_ft_emp_count);

566: rows_processed := dbms_sql.EXECUTE(source_cursor);
567:
568: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
569: dbms_sql.column_value(source_cursor, 1, l_ft_emp_count);
570: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ft_emp_count: ' || l_ft_emp_count);
571:
572: END IF;
573:
574: dbms_sql.close_cursor(source_cursor);

Line 578: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);

574: dbms_sql.close_cursor(source_cursor);
575:
576: l_query_text := 'Select job.job_information7 l_function_code,
577: count(1) l_function_count ' || g_from_where_clause || g_ft_effective_dates || ' group by job.job_information7 ';
578: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);
579: source_cursor := dbms_sql.open_cursor;
580: dbms_sql.parse(source_cursor,l_query_text,2);
581: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
582: dbms_sql.define_column(source_cursor,2,l_function_count);

Line 604: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN IF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count <= 14)');

600: b) Populate second_order_func_table for the rest
601: */
602:
603: IF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count <= 14) THEN
604: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN IF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count <= 14)');
605: g_dynamic_where := g_dynamic_where || ',' || l_function_code;
606:
607: -- Commented the folowing to fix the bug# 5410130
608: /*

Line 621: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN ELSIF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count > 14) THEN');

617:
618: -- Commented the folowing to fix the bug# 5410130
619: /*
620: ELSIF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count > 14) THEN
621: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN ELSIF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count > 14) THEN');
622: l_fo_funct_counter := l_fo_funct_counter + 1;
623: first_order_func_table(l_fo_funct_counter).job_function := l_function_code;
624: first_order_func_table(l_fo_funct_counter).description := l_function_desc;
625: */

Line 634: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN IF (l_ft_emp_count < p_full_time_emp_count AND l_function_count >= p_emp_count_for_function) THEN ');

630: a) Populate first_order_func_table, if the function has more than 100 employees
631: b) Populate second_order_func_table for all functions
632: */
633: IF (l_ft_emp_count < p_full_time_emp_count AND l_function_count >= p_emp_count_for_function) THEN
634: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN IF (l_ft_emp_count < p_full_time_emp_count AND l_function_count >= p_emp_count_for_function) THEN ');
635: g_dynamic_where := g_dynamic_where || ',' || l_function_code;
636: -- Commented the folowing to fix the bug# 5397638
637: /*
638: l_fo_funct_counter := l_fo_funct_counter + 1;

Line 646: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN ELSIF (l_ft_emp_count < p_full_time_emp_count AND l_function_count < p_emp_count_for_function) THEN');

642: l_so_funct_counter := l_so_funct_counter + 1;
643: second_order_func_table(l_so_funct_counter).job_function := l_function_code;
644: second_order_func_table(l_so_funct_counter).description := l_function_desc;
645: ELSIF (l_ft_emp_count < p_full_time_emp_count AND l_function_count < p_emp_count_for_function) THEN
646: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN ELSIF (l_ft_emp_count < p_full_time_emp_count AND l_function_count < p_emp_count_for_function) THEN');
647: l_fo_funct_counter := l_fo_funct_counter + 1;
648: first_order_func_table(l_fo_funct_counter).job_function := l_function_code;
649: first_order_func_table(l_fo_funct_counter).description := l_function_desc;
650: END IF;

Line 679: --FND_FILE.PUT_LINE(FND_FILE.LOG,' I am in FOR i IN 1 .. first_order_func_table.count LOOP');

675: FOR i IN 1 .. first_order_func_table.count LOOP -- For Each Function
676: l_function := first_order_func_table(i).job_function;
677: l_function_desc := first_order_func_table(i).description;
678: IF l_function <> l_current_function THEN
679: --FND_FILE.PUT_LINE(FND_FILE.LOG,' I am in FOR i IN 1 .. first_order_func_table.count LOOP');
680: l_current_function := l_function;
681:
682: IF g_job_code = '''X''' THEN
683: g_job_code := ''''|| l_current_function ||'''';

Line 692: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_job_code: '||g_job_code);

688: END IF;
689: END IF;
690: END LOOP; -- For Each Function
691:
692: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_job_code: '||g_job_code);
693: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_func_desc: '||g_func_desc);
694:
695: g_for_all_emp := 'T';
696:

Line 693: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_func_desc: '||g_func_desc);

689: END IF;
690: END LOOP; -- For Each Function
691:
692: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_job_code: '||g_job_code);
693: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_func_desc: '||g_func_desc);
694:
695: g_for_all_emp := 'T';
696:
697: -- Bug# 5410130

Line 700: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);

696:
697: -- Bug# 5410130
698: --IF g_job_code <> '''X''' THEN
699: --generate_sql(g_job_code);
700: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
701: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
702: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
703: populate_ft_emp_data(g_job_code);
704: populate_oft_emp_data(g_job_code);

Line 701: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);

697: -- Bug# 5410130
698: --IF g_job_code <> '''X''' THEN
699: --generate_sql(g_job_code);
700: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
701: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
702: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
703: populate_ft_emp_data(g_job_code);
704: populate_oft_emp_data(g_job_code);
705: populate_nh_emp_data(g_job_code);

Line 702: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);

698: --IF g_job_code <> '''X''' THEN
699: --generate_sql(g_job_code);
700: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
701: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
702: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
703: populate_ft_emp_data(g_job_code);
704: populate_oft_emp_data(g_job_code);
705: populate_nh_emp_data(g_job_code);
706: --END IF;

Line 711: --FND_FILE.PUT_LINE(FND_FILE.LOG,'FOR i IN 1 .. second_order_func_table.count LOOP');

707:
708: g_for_all_emp := 'F';
709:
710: FOR i IN 1 .. second_order_func_table.count LOOP
711: --FND_FILE.PUT_LINE(FND_FILE.LOG,'FOR i IN 1 .. second_order_func_table.count LOOP');
712: l_function := second_order_func_table(i).job_function;
713: l_function_desc := second_order_func_table(i).description;
714: IF l_function <> l_current_function THEN
715: l_current_function := l_function;

Line 718: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);

714: IF l_function <> l_current_function THEN
715: l_current_function := l_function;
716: l_funct_counter := l_funct_counter + 1;
717: --generate_sql(l_current_function);
718: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
719: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
720: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
721: populate_ft_emp_data(l_current_function);
722: populate_oft_emp_data(l_current_function);

Line 719: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);

715: l_current_function := l_function;
716: l_funct_counter := l_funct_counter + 1;
717: --generate_sql(l_current_function);
718: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
719: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
720: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
721: populate_ft_emp_data(l_current_function);
722: populate_oft_emp_data(l_current_function);
723: populate_nh_emp_data(l_current_function);

Line 720: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);

716: l_funct_counter := l_funct_counter + 1;
717: --generate_sql(l_current_function);
718: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
719: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
720: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
721: populate_ft_emp_data(l_current_function);
722: populate_oft_emp_data(l_current_function);
723: populate_nh_emp_data(l_current_function);
724: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_function : '||l_function ||' inserted into func_table');

Line 724: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_function : '||l_function ||' inserted into func_table');

720: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
721: populate_ft_emp_data(l_current_function);
722: populate_oft_emp_data(l_current_function);
723: populate_nh_emp_data(l_current_function);
724: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_function : '||l_function ||' inserted into func_table');
725: END IF;
726: END LOOP; -- end of second_order_func_table */
727:
728: -- Show the functions data whose data should be displayed first

Line 755: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

751:
752: -- Show the functions data whose data should be displayed first
753: l_xml_string := '';
754:
755: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
756: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
757: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Calling create_xml for the function: '||g_job_code||' with description: '||g_func_desc);
758:
759: -- Bug# 5415136

Line 756: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

752: -- Show the functions data whose data should be displayed first
753: l_xml_string := '';
754:
755: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
756: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
757: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Calling create_xml for the function: '||g_job_code||' with description: '||g_func_desc);
758:
759: -- Bug# 5415136
760: g_function_numbers := '''X''';

Line 757: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Calling create_xml for the function: '||g_job_code||' with description: '||g_func_desc);

753: l_xml_string := '';
754:
755: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
756: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
757: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Calling create_xml for the function: '||g_job_code||' with description: '||g_func_desc);
758:
759: -- Bug# 5415136
760: g_function_numbers := '''X''';
761:

Line 762: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_function_numbers: ' || g_function_numbers);

758:
759: -- Bug# 5415136
760: g_function_numbers := '''X''';
761:
762: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_function_numbers: ' || g_function_numbers);
763:
764: FOR i IN 1 .. first_order_func_table.count LOOP
765:
766: l_current_function := first_order_func_table(i).job_function;

Line 784: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

780:
781: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');
782: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
783:
784: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
786:
787:
788: -- Bug# 5409988

Line 785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

781: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');
782: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
783:
784: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
786:
787:
788: -- Bug# 5409988
789: FOR i IN 1 .. first_order_func_table.count LOOP

Line 797: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

793: END IF;
794: END LOOP;
795:
796: l_xml_string := '';
797: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
798: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
799:
800: -- Bug# 5410233.
801: g_line_number := 0;

Line 798: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

794: END LOOP;
795:
796: l_xml_string := '';
797: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
798: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
799:
800: -- Bug# 5410233.
801: g_line_number := 0;
802:

Line 809: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

805: g_for_all_emp := 'F';
806:
807: l_xml_string := '';
808:
809: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
810: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
811:
812: ELSIF report_type = 2 THEN
813:

Line 810: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

806:
807: l_xml_string := '';
808:
809: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
810: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
811:
812: ELSIF report_type = 2 THEN
813:
814: -- Show the functions data whose data should be displayed later

Line 825: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

821: -- Bug# 5415136
822: g_function_numbers := get_function_number(l_current_function);
823:
824: l_xml_string := '';
825: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
826: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
827: generate_juris_cert_xml_data();
828:
829: -- Bug# 5415136

Line 826: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

822: g_function_numbers := get_function_number(l_current_function);
823:
824: l_xml_string := '';
825: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
826: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
827: generate_juris_cert_xml_data();
828:
829: -- Bug# 5415136
830: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');

Line 833: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

829: -- Bug# 5415136
830: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');
831: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
832:
833: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
835:
836: -- Bug# 5409988
837: check_function(to_number(l_current_function));

Line 834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

830: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');
831: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
832:
833: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
835:
836: -- Bug# 5409988
837: check_function(to_number(l_current_function));
838:

Line 840: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

836: -- Bug# 5409988
837: check_function(to_number(l_current_function));
838:
839: l_xml_string := '';
840: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
842:
843: -- Bug# 5410233.
844: g_line_number := 0;

Line 841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

837: check_function(to_number(l_current_function));
838:
839: l_xml_string := '';
840: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
842:
843: -- Bug# 5410233.
844: g_line_number := 0;
845:

Line 851: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

847: create_xml(l_current_function);
848:
849: l_xml_string := '';
850:
851: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
853: END LOOP; -- For Each Function
854: END IF;
855:

Line 852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

848:
849: l_xml_string := '';
850:
851: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
853: END LOOP; -- For Each Function
854: END IF;
855:
856: END create_report;

Line 864: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

860: BEGIN
861:
862: l_xml_string := ' ';
863:
864: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
866:
867: END generate_header_xml_data;
868:

Line 865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

861:
862: l_xml_string := ' ';
863:
864: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
866:
867: END generate_header_xml_data;
868:
869: PROCEDURE generate_footer_xml_data IS

Line 892: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

888: || '
889:
890:
891: ';
892: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
894:
895: END generate_footer_xml_data;
896:

Line 893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

889:
890:
891: ';
892: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
894:
895: END generate_footer_xml_data;
896:
897: PROCEDURE generate_juris_cert_xml_data IS

Line 974: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

970: END LOOP;
971:
972: l_xml_string := l_xml_string || '';
973:
974: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
976:
977:
978: l_xml_string := '';

Line 975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

971:
972: l_xml_string := l_xml_string || '';
973:
974: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
976:
977:
978: l_xml_string := '';
979:

Line 997: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

993: END LOOP;
994:
995: l_xml_string := l_xml_string || '';
996:
997: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
998: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
999:
1000: END generate_juris_cert_xml_data;
1001:

Line 998: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

994:
995: l_xml_string := l_xml_string || '';
996:
997: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
998: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
999:
1000: END generate_juris_cert_xml_data;
1001:
1002:

Line 1012: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1008: -- Replaced p_current_function with g_function_numbers.
1009: l_xml_string := l_xml_string || g_function_numbers;
1010: l_xml_string := l_xml_string || '';
1011:
1012: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1014:
1015: g_line_number := g_line_number + 1;
1016:

Line 1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1009: l_xml_string := l_xml_string || g_function_numbers;
1010: l_xml_string := l_xml_string || '';
1011:
1012: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1014:
1015: g_line_number := g_line_number + 1;
1016:
1017: -- Genarate full time emp xml data

Line 1033: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1029:
1030: l_xml_string := ' '
1031: || convert_into_xml('CF_SET_FUNCTION_DESC',g_func_desc,'D')
1032: || '';
1033: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1034: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1035: END create_xml;
1036:
1037:

Line 1034: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1030: l_xml_string := ' '
1031: || convert_into_xml('CF_SET_FUNCTION_DESC',g_func_desc,'D')
1032: || '';
1033: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1034: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1035: END create_xml;
1036:
1037:
1038: -- This method populates ft_emp_table

Line 1561: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_function in populate_nh_emp_data: ' || l_function_code);

1557:
1558: BEGIN
1559:
1560: l_function_code := p_function_code;
1561: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_function in populate_nh_emp_data: ' || l_function_code);
1562:
1563: FOR i IN get_eeo4_lookup_details LOOP -- for each job category
1564:
1565: g_lookup_code := i.lookup_code;

Line 1794: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1790: l_xml_string := '';
1791: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','1. FULL-TIME EMPLOYEES (Temporary employees are not included)','D');
1792: l_xml_string := l_xml_string || '';
1793:
1794: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1796:
1797: FOR i IN get_eeo4_lookup_details LOOP -- for each job category
1798:

Line 1795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1791: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','1. FULL-TIME EMPLOYEES (Temporary employees are not included)','D');
1792: l_xml_string := l_xml_string || '';
1793:
1794: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1796:
1797: FOR i IN get_eeo4_lookup_details LOOP -- for each job category
1798:
1799: l_lookup_code := i.lookup_code;

Line 1842: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1838: END IF;
1839:
1840: l_xml_string := l_xml_string || '';
1841:
1842: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1843: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1844:
1845: END IF;
1846:

Line 1843: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1839:
1840: l_xml_string := l_xml_string || '';
1841:
1842: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1843: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1844:
1845: END IF;
1846:
1847:

Line 1877: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1873: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_IFEMALE_EMPS',ft_emp_table(counter).no_cons_ifemale_emps,'D');
1874:
1875: l_xml_string := l_xml_string || '';
1876:
1877: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1878: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1879: -- Increment the line number
1880: g_line_number := g_line_number + 1 ;
1881: END IF; -- End of qualifying condition

Line 1878: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1874:
1875: l_xml_string := l_xml_string || '';
1876:
1877: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1878: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1879: -- Increment the line number
1880: g_line_number := g_line_number + 1 ;
1881: END IF; -- End of qualifying condition
1882: END LOOP; -- End of Fetch from ft_emp_table

Line 1885: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1881: END IF; -- End of qualifying condition
1882: END LOOP; -- End of Fetch from ft_emp_table
1883: END LOOP; -- End of for each salary range
1884: l_xml_string := '';
1885: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1887: END LOOP; -- for each job category
1888:
1889: l_xml_string := '';

Line 1886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1882: END LOOP; -- End of Fetch from ft_emp_table
1883: END LOOP; -- End of for each salary range
1884: l_xml_string := '';
1885: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1887: END LOOP; -- for each job category
1888:
1889: l_xml_string := '';
1890: l_xml_string := l_xml_string || convert_into_xml('CF_TOTAL_TITLE',g_line_number||'. TOTAL FULL-TIME (LINES 1-64)','D');

Line 1904: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1900: l_xml_string := l_xml_string || convert_into_xml('CS_NO_IFEMALE_EMPS', l_cs_no_ifemale_emps,'D');
1901: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
1902: l_xml_string := l_xml_string || '';
1903:
1904: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1905: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1906: END;
1907:
1908: PROCEDURE generate_oft_xml_data(p_function_code VARCHAR2) IS

Line 1905: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1901: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
1902: l_xml_string := l_xml_string || '';
1903:
1904: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1905: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1906: END;
1907:
1908: PROCEDURE generate_oft_xml_data(p_function_code VARCHAR2) IS
1909:

Line 1948: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1944: -- 2. OTHER THAN FULL-TIME EMPLOYEES (Including temporary employees)
1945: l_xml_string := '';
1946: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','2. OTHER THAN FULL-TIME EMPLOYEES (Including temporary employees)','D');
1947: l_xml_string := l_xml_string || '';
1948: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1949: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1950:
1951:
1952: FOR counter in 1 .. other_ft_emp_table.count LOOP -- Fetch from other_ft_emp_table

Line 1949: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1945: l_xml_string := '';
1946: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','2. OTHER THAN FULL-TIME EMPLOYEES (Including temporary employees)','D');
1947: l_xml_string := l_xml_string || '';
1948: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1949: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1950:
1951:
1952: FOR counter in 1 .. other_ft_emp_table.count LOOP -- Fetch from other_ft_emp_table
1953:

Line 1987: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1983: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_HFEMALE_EMPS',other_ft_emp_table(counter).no_cons_hfemale_emps,'D');
1984: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_AFEMALE_EMPS',other_ft_emp_table(counter).no_cons_afemale_emps,'D');
1985: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_IFEMALE_EMPS',other_ft_emp_table(counter).no_cons_ifemale_emps,'D');
1986: l_xml_string := l_xml_string || '';
1987: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1989: g_line_number := g_line_number + 1;
1990: END IF;
1991: END LOOP; -- Fetch other than full emp table

Line 1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1984: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_AFEMALE_EMPS',other_ft_emp_table(counter).no_cons_afemale_emps,'D');
1985: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_IFEMALE_EMPS',other_ft_emp_table(counter).no_cons_ifemale_emps,'D');
1986: l_xml_string := l_xml_string || '';
1987: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1989: g_line_number := g_line_number + 1;
1990: END IF;
1991: END LOOP; -- Fetch other than full emp table
1992:

Line 2008: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2004: l_xml_string := l_xml_string || convert_into_xml('CS_NO_AFEMALE_EMPS', l_cs_no_afemale_emps,'D');
2005: l_xml_string := l_xml_string || convert_into_xml('CS_NO_IFEMALE_EMPS', l_cs_no_ifemale_emps,'D');
2006: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
2007: l_xml_string := l_xml_string || '';
2008: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2010: END;
2011:
2012: PROCEDURE generate_nh_xml_data(p_function_code IN VARCHAR2) IS

Line 2009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

2005: l_xml_string := l_xml_string || convert_into_xml('CS_NO_IFEMALE_EMPS', l_cs_no_ifemale_emps,'D');
2006: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
2007: l_xml_string := l_xml_string || '';
2008: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2010: END;
2011:
2012: PROCEDURE generate_nh_xml_data(p_function_code IN VARCHAR2) IS
2013:

Line 2053: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2049:
2050: l_xml_string := '';
2051: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','3. NEW HIRES DURING FISCAL YEAR - Permanent full time only JULY 1 - JUNE 30','D');
2052: l_xml_string := l_xml_string || '';
2053: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2055:
2056: FOR counter in 1 .. new_hire_table.count LOOP -- Fetch from other_ft_emp_table
2057:

Line 2054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

2050: l_xml_string := '';
2051: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','3. NEW HIRES DURING FISCAL YEAR - Permanent full time only JULY 1 - JUNE 30','D');
2052: l_xml_string := l_xml_string || '';
2053: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2055:
2056: FOR counter in 1 .. new_hire_table.count LOOP -- Fetch from other_ft_emp_table
2057:
2058:

Line 2091: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2087: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_AFEMALE_EMPS',new_hire_table(counter).no_cons_afemale_emps,'D');
2088: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_IFEMALE_EMPS',new_hire_table(counter).no_cons_ifemale_emps,'D');
2089: l_xml_string := l_xml_string || '';
2090:
2091: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2093:
2094: g_line_number := g_line_number + 1;
2095: END IF;

Line 2092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

2088: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_IFEMALE_EMPS',new_hire_table(counter).no_cons_ifemale_emps,'D');
2089: l_xml_string := l_xml_string || '';
2090:
2091: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2093:
2094: g_line_number := g_line_number + 1;
2095: END IF;
2096: END LOOP; -- End of Fetch from other_ft_emp_table

Line 2113: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2109: l_xml_string := l_xml_string || convert_into_xml('CS_NO_IFEMALE_EMPS', l_cs_no_ifemale_emps,'D');
2110: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
2111: l_xml_string := l_xml_string || '';
2112:
2113: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2114: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2115:
2116: END;
2117: END PER_US_EEO4_PKG;

Line 2114: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

2110: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
2111: l_xml_string := l_xml_string || '';
2112:
2113: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2114: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2115:
2116: END;
2117: END PER_US_EEO4_PKG;
2118: