APPS.PAY_ARCHIVER_REPORT_PKG dependencies on HR_UTILITY

Line 266: hr_utility.set_location(gv_package_name||'.emp_detail_static_header',20);

262: ,p_output_file_type => p_output_file_type)
263: ;
264:
265: p_emp_static_label := l_emp_detail_format;
266: hr_utility.set_location(gv_package_name||'.emp_detail_static_header',20);
267: END;
268:
269: PROCEDURE emp_sum_static_header(
270: p_output_file_type in varchar2

Line 299: hr_utility.set_location(gv_package_name||'.emp_sum_static_header',20);

295: ,p_output_file_type => p_output_file_type)
296: ;
297:
298: p_emp_static_label := l_emp_sum_format;
299: hr_utility.set_location(gv_package_name||'.emp_sum_static_header',20);
300: END;
301:
302: PROCEDURE fed_static_header(
303: p_output_file_type in varchar2

Line 310: -- hr_utility.set_location(gv_package_name || '.fed_static_header', 10);

306: IS
307: l_fed_format varchar2(32000);
308: BEGIN
309:
310: -- hr_utility.set_location(gv_package_name || '.fed_static_header', 10);
311: l_fed_format :=
312: data_string (p_input_string => 'GRE Name'
313: ,p_bold => 'Y'
314: ,p_output_file_type => p_output_file_type) ||

Line 360: hr_utility.set_location(gv_package_name||'.fed_static_header',20);

356: ,p_output_file_type => p_output_file_type)
357: ;
358:
359: p_fed_static_label := l_fed_format;
360: hr_utility.set_location(gv_package_name||'.fed_static_header',20);
361:
362: END;
363:
364: PROCEDURE state_static_header ( p_output_file_type in varchar2

Line 369: -- hr_utility.set_location(gv_package_name||'.state_static_header',10);

365: ,p_state_static_label out nocopy varchar2)
366: IS
367: l_state_format varchar2(32000);
368: BEGIN
369: -- hr_utility.set_location(gv_package_name||'.state_static_header',10);
370:
371: l_state_format :=
372: data_string (p_input_string => 'GRE Name'
373: ,p_bold => 'Y'

Line 426: hr_utility.set_location(gv_package_name||'.state_static_header',20);

422: ,p_output_file_type => p_output_file_type)
423: ;
424:
425: p_state_static_label := l_state_format;
426: hr_utility.set_location(gv_package_name||'.state_static_header',20);
427:
428: END;
429:
430: PROCEDURE county_static_header ( p_output_file_type in varchar2

Line 435: -- hr_utility.set_location(gv_package_name||'.county_static_header',10);

431: ,p_county_static_label out nocopy varchar2)
432: IS
433: l_county_format varchar2(32000);
434: BEGIN
435: -- hr_utility.set_location(gv_package_name||'.county_static_header',10);
436:
437: l_county_format :=
438: data_string (p_input_string => 'GRE Name'
439: ,p_bold => 'Y'

Line 465: --hr_utility.trace('Static County label = '||l_county_format);

461: ,p_output_file_type => p_output_file_type)
462: ;
463:
464: p_county_static_label := l_county_format;
465: --hr_utility.trace('Static County label = '||l_county_format);
466: hr_utility.set_location(gv_package_name||'.county_static_header',20);
467:
468: END;
469:

Line 466: hr_utility.set_location(gv_package_name||'.county_static_header',20);

462: ;
463:
464: p_county_static_label := l_county_format;
465: --hr_utility.trace('Static County label = '||l_county_format);
466: hr_utility.set_location(gv_package_name||'.county_static_header',20);
467:
468: END;
469:
470: PROCEDURE city_static_header ( p_output_file_type in varchar2

Line 475: -- hr_utility.set_location(gv_package_name||'.city_static_header',10);

471: ,p_city_static_label out nocopy varchar2)
472: IS
473: l_city_format varchar2(32000);
474: BEGIN
475: -- hr_utility.set_location(gv_package_name||'.city_static_header',10);
476:
477: l_city_format :=
478: data_string (p_input_string => 'GRE Name'
479: ,p_bold => 'Y'

Line 505: --hr_utility.trace('Static City label = '||l_city_format);

501: ,p_output_file_type => p_output_file_type)
502: ;
503:
504: p_city_static_label := l_city_format;
505: --hr_utility.trace('Static City label = '||l_city_format);
506: hr_utility.set_location(gv_package_name||'.city_static_header',20);
507: END;
508:
509: PROCEDURE school_static_header ( p_output_file_type in varchar2

Line 506: hr_utility.set_location(gv_package_name||'.city_static_header',20);

502: ;
503:
504: p_city_static_label := l_city_format;
505: --hr_utility.trace('Static City label = '||l_city_format);
506: hr_utility.set_location(gv_package_name||'.city_static_header',20);
507: END;
508:
509: PROCEDURE school_static_header ( p_output_file_type in varchar2
510: ,p_school_static_label out nocopy varchar2)

Line 514: -- hr_utility.set_location(gv_package_name||'.school_static_header',10);

510: ,p_school_static_label out nocopy varchar2)
511: IS
512: l_school_format varchar2(32000);
513: BEGIN
514: -- hr_utility.set_location(gv_package_name||'.school_static_header',10);
515:
516: l_school_format :=
517: data_string (p_input_string => 'GRE Name'
518: ,p_bold => 'Y'

Line 538: --hr_utility.trace('Static school label = '||l_school_format);

534: ,p_output_file_type => p_output_file_type)
535: ;
536:
537: p_school_static_label := l_school_format;
538: --hr_utility.trace('Static school label = '||l_school_format);
539: hr_utility.set_location(gv_package_name||'.school_static_header',20);
540: END;
541:
542: /******* Done with creating Static Header *****/

Line 539: hr_utility.set_location(gv_package_name||'.school_static_header',20);

535: ;
536:
537: p_school_static_label := l_school_format;
538: --hr_utility.trace('Static school label = '||l_school_format);
539: hr_utility.set_location(gv_package_name||'.school_static_header',20);
540: END;
541:
542: /******* Done with creating Static Header *****/
543:

Line 573: hr_utility.set_location(gv_package_name || '.emp_static_data', 10);

569: l_emp_static_data VARCHAR2(32000);
570:
571: BEGIN
572:
573: hr_utility.set_location(gv_package_name || '.emp_static_data', 10);
574: l_emp_static_data :=
575: data_string (p_input_string => p_last_name
576: ,p_output_file_type => p_output_file_type) ||
577: data_string (p_input_string => p_first_name

Line 613: --hr_utility.trace('Employee Header = '||l_emp_static_data);

609: ;
610:
611: p_employee_data := l_emp_static_data;
612:
613: --hr_utility.trace('Employee Header = '||l_emp_static_data);
614: hr_utility.set_location(gv_package_name || '.emp_static_data', 20);
615: END;
616:
617: PROCEDURE emp_sum_static_data (

Line 614: hr_utility.set_location(gv_package_name || '.emp_static_data', 20);

610:
611: p_employee_data := l_emp_static_data;
612:
613: --hr_utility.trace('Employee Header = '||l_emp_static_data);
614: hr_utility.set_location(gv_package_name || '.emp_static_data', 20);
615: END;
616:
617: PROCEDURE emp_sum_static_data (
618: p_last_name in varchar2

Line 633: hr_utility.set_location(gv_package_name || '.emp_static_data', 10);

629: l_emp_sum_static_data VARCHAR2(32000);
630:
631: BEGIN
632:
633: hr_utility.set_location(gv_package_name || '.emp_static_data', 10);
634: l_emp_sum_static_data :=
635: data_string (p_input_string => p_last_name
636: ,p_output_file_type => p_output_file_type) ||
637: data_string (p_input_string => p_first_name

Line 651: --hr_utility.trace('Employee Header = '||l_emp_static_data);

647: ;
648:
649: p_employee_data := l_emp_sum_static_data;
650:
651: --hr_utility.trace('Employee Header = '||l_emp_static_data);
652: hr_utility.set_location(gv_package_name || '.emp_static_data', 20);
653: END;
654:
655: PROCEDURE fed_static_data (

Line 652: hr_utility.set_location(gv_package_name || '.emp_static_data', 20);

648:
649: p_employee_data := l_emp_sum_static_data;
650:
651: --hr_utility.trace('Employee Header = '||l_emp_static_data);
652: hr_utility.set_location(gv_package_name || '.emp_static_data', 20);
653: END;
654:
655: PROCEDURE fed_static_data (
656: p_gre_name in varchar2

Line 678: --hr_utility.set_location(gv_package_name || '.fit_static_data', 10);

674: IS
675: l_fed_static_data varchar2(32000);
676:
677: BEGIN
678: --hr_utility.set_location(gv_package_name || '.fit_static_data', 10);
679: l_fed_static_data :=
680: data_string (p_input_string => p_gre_name
681: ,p_output_file_type => p_output_file_type) ||
682: data_string (p_input_string => p_fit_gross

Line 728: -- hr_utility.trace('Federal Data = '||p_federal_data);

724: ;
725:
726:
727: p_federal_data := l_fed_static_data;
728: -- hr_utility.trace('Federal Data = '||p_federal_data);
729: hr_utility.set_location(gv_package_name || '.fit_static_data', 20);
730: END;
731:
732: PROCEDURE state_static_data(

Line 729: hr_utility.set_location(gv_package_name || '.fit_static_data', 20);

725:
726:
727: p_federal_data := l_fed_static_data;
728: -- hr_utility.trace('Federal Data = '||p_federal_data);
729: hr_utility.set_location(gv_package_name || '.fit_static_data', 20);
730: END;
731:
732: PROCEDURE state_static_data(
733: p_gre_name in varchar2

Line 757: --hr_utility.set_location(gv_package_name || '.state_static_data', 10);

753: IS
754: l_state_static_data varchar2(32000);
755:
756: BEGIN
757: --hr_utility.set_location(gv_package_name || '.state_static_data', 10);
758: l_state_static_data :=
759: data_string (p_input_string => p_gre_name
760: ,p_output_file_type => p_output_file_type) ||
761: data_string (p_input_string => p_state_ein

Line 810: -- hr_utility.trace('State data = '||p_state_data);

806: ;
807:
808: p_state_data := l_state_static_data;
809:
810: -- hr_utility.trace('State data = '||p_state_data);
811: hr_utility.set_location(gv_package_name || '.state__static_data', 20);
812: END;
813:
814:

Line 811: hr_utility.set_location(gv_package_name || '.state__static_data', 20);

807:
808: p_state_data := l_state_static_data;
809:
810: -- hr_utility.trace('State data = '||p_state_data);
811: hr_utility.set_location(gv_package_name || '.state__static_data', 20);
812: END;
813:
814:
815: PROCEDURE county_static_data(

Line 831: -- hr_utility.set_location(gv_package_name || '.county_static_data', 10);

827: IS
828: l_county_static_data varchar2(32000);
829:
830: BEGIN
831: -- hr_utility.set_location(gv_package_name || '.county_static_data', 10);
832: l_county_static_data :=
833: data_string (p_input_string => p_gre_name
834: ,p_output_file_type => p_output_file_type) ||
835: data_string (p_input_string => p_jurisdiction

Line 855: -- hr_utility.trace('County data = '||p_county_data);

851: data_string (p_input_string => p_non_resident_flag
852: ,p_output_file_type => p_output_file_type)
853: ;
854: p_county_data := l_county_static_data;
855: -- hr_utility.trace('County data = '||p_county_data);
856: hr_utility.set_location(gv_package_name || '.county_static_data', 20);
857: END;
858:
859:

Line 856: hr_utility.set_location(gv_package_name || '.county_static_data', 20);

852: ,p_output_file_type => p_output_file_type)
853: ;
854: p_county_data := l_county_static_data;
855: -- hr_utility.trace('County data = '||p_county_data);
856: hr_utility.set_location(gv_package_name || '.county_static_data', 20);
857: END;
858:
859:
860: PROCEDURE city_static_data(

Line 875: --hr_utility.set_location(gv_package_name || '.city_static_data', 10);

871: )
872: IS
873: l_city_static_data varchar2(32000);
874: BEGIN
875: --hr_utility.set_location(gv_package_name || '.city_static_data', 10);
876: l_city_static_data :=
877: data_string (p_input_string => p_gre_name
878: ,p_output_file_type => p_output_file_type) ||
879: data_string (p_input_string => p_jurisdiction

Line 900: -- hr_utility.trace('City data = '||p_city_data);

896: ,p_output_file_type => p_output_file_type)
897: ;
898:
899: p_city_data := l_city_static_data;
900: -- hr_utility.trace('City data = '||p_city_data);
901: hr_utility.set_location(gv_package_name || '.city_static_data', 20);
902: END;
903:
904: PROCEDURE school_static_data(

Line 901: hr_utility.set_location(gv_package_name || '.city_static_data', 20);

897: ;
898:
899: p_city_data := l_city_static_data;
900: -- hr_utility.trace('City data = '||p_city_data);
901: hr_utility.set_location(gv_package_name || '.city_static_data', 20);
902: END;
903:
904: PROCEDURE school_static_data(
905: p_gre_name in varchar2

Line 918: -- hr_utility.set_location(gv_package_name || '.school_static_data', 10);

914: IS
915: l_school_static_data varchar2(32000);
916:
917: BEGIN
918: -- hr_utility.set_location(gv_package_name || '.school_static_data', 10);
919: l_school_static_data :=
920: data_string (p_input_string => p_gre_name
921: ,p_output_file_type => p_output_file_type) ||
922: data_string (p_input_string => p_jurisdiction

Line 938: -- hr_utility.trace('School data = '||p_school_data);

934: ,p_output_file_type => p_output_file_type)
935: ;
936:
937: p_school_data := l_school_static_data;
938: -- hr_utility.trace('School data = '||p_school_data);
939: hr_utility.set_location(gv_package_name || '.school_static_data', 20);
940: END;
941:
942:

Line 939: hr_utility.set_location(gv_package_name || '.school_static_data', 20);

935: ;
936:
937: p_school_data := l_school_static_data;
938: -- hr_utility.trace('School data = '||p_school_data);
939: hr_utility.set_location(gv_package_name || '.school_static_data', 20);
940: END;
941:
942:
943: /*****************************************************************

Line 1421: hr_utility.set_location(gv_package_name || '.archiver_extract', 10);

1417: city_bal city_tab;
1418: school_bal school_tab;
1419:
1420: BEGIN
1421: hr_utility.set_location(gv_package_name || '.archiver_extract', 10);
1422: ld_beginning_date := fnd_date.canonical_to_date(p_beginning_date);
1423: ld_end_date := fnd_date.canonical_to_date(p_end_date);
1424:
1425: /* Create Headers for each column */

Line 1435: hr_utility.trace('----------Done with Static Header Lables ------------');

1431: county_static_header(p_output_file_type, lv_county_header);
1432: city_static_header(p_output_file_type, lv_city_header);
1433: school_static_header(p_output_file_type, lv_school_header);
1434:
1435: hr_utility.trace('----------Done with Static Header Lables ------------');
1436:
1437: IF p_detail_level = '01' THEN
1438: if p_jurisdiction_level = '01' -- Federal
1439: then

Line 1473: hr_utility.set_location(gv_package_name || '.archiver_extract', 70);

1469: lv_header_label := lv_emp_sum_header||lv_school_header;
1470: end if;
1471: END IF;
1472:
1473: hr_utility.set_location(gv_package_name || '.archiver_extract', 70);
1474:
1475: /* write the title of the report based on the output file type */
1476:
1477: fnd_file.put_line(fnd_file.output,

Line 1481: hr_utility.set_location(gv_package_name || '.archiver_extract', 90);

1477: fnd_file.put_line(fnd_file.output,
1478: title_string( gv_title
1479: ,p_output_file_type));
1480:
1481: hr_utility.set_location(gv_package_name || '.archiver_extract', 90);
1482: /****************************************************************
1483: ** Print the Header Information. If the format is HTML then open
1484: ** the body and table before printing the header info, otherwise
1485: ** just print the header information.

Line 1487: hr_utility.trace('Output File Type = '||p_output_file_type);

1483: ** Print the Header Information. If the format is HTML then open
1484: ** the body and table before printing the header info, otherwise
1485: ** just print the header information.
1486: ****************************************************************/
1487: hr_utility.trace('Output File Type = '||p_output_file_type);
1488:
1489: if p_output_file_type ='HTML' then
1490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1501: hr_utility.set_location(gv_package_name || '.archiver_extract', 100);

1497: if p_output_file_type ='HTML' then
1498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1499: end if;
1500:
1501: hr_utility.set_location(gv_package_name || '.archiver_extract', 100);
1502:
1503: /*****************************************************
1504: ** Start of the Data Section of the Report
1505: *****************************************************/

Line 1506: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);

1502:
1503: /*****************************************************
1504: ** Start of the Data Section of the Report
1505: *****************************************************/
1506: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1507: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1508: hr_utility.trace('Ending Date = '||ld_end_date);
1509: hr_utility.trace('Payroll id = '||p_payroll_id);
1510: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);

Line 1507: hr_utility.trace('Beginning Date = '||ld_beginning_date);

1503: /*****************************************************
1504: ** Start of the Data Section of the Report
1505: *****************************************************/
1506: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1507: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1508: hr_utility.trace('Ending Date = '||ld_end_date);
1509: hr_utility.trace('Payroll id = '||p_payroll_id);
1510: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1511: hr_utility.trace('Organization id = '||p_organization_id);

Line 1508: hr_utility.trace('Ending Date = '||ld_end_date);

1504: ** Start of the Data Section of the Report
1505: *****************************************************/
1506: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1507: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1508: hr_utility.trace('Ending Date = '||ld_end_date);
1509: hr_utility.trace('Payroll id = '||p_payroll_id);
1510: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1511: hr_utility.trace('Organization id = '||p_organization_id);
1512: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);

Line 1509: hr_utility.trace('Payroll id = '||p_payroll_id);

1505: *****************************************************/
1506: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1507: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1508: hr_utility.trace('Ending Date = '||ld_end_date);
1509: hr_utility.trace('Payroll id = '||p_payroll_id);
1510: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1511: hr_utility.trace('Organization id = '||p_organization_id);
1512: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1513: hr_utility.trace('Location id = '||p_location_id);

Line 1510: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);

1506: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1507: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1508: hr_utility.trace('Ending Date = '||ld_end_date);
1509: hr_utility.trace('Payroll id = '||p_payroll_id);
1510: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1511: hr_utility.trace('Organization id = '||p_organization_id);
1512: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1513: hr_utility.trace('Location id = '||p_location_id);
1514: hr_utility.trace('Business Group id = '||p_business_group_id);

Line 1511: hr_utility.trace('Organization id = '||p_organization_id);

1507: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1508: hr_utility.trace('Ending Date = '||ld_end_date);
1509: hr_utility.trace('Payroll id = '||p_payroll_id);
1510: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1511: hr_utility.trace('Organization id = '||p_organization_id);
1512: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1513: hr_utility.trace('Location id = '||p_location_id);
1514: hr_utility.trace('Business Group id = '||p_business_group_id);
1515: hr_utility.trace('State Id = '||p_state_id);

Line 1512: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);

1508: hr_utility.trace('Ending Date = '||ld_end_date);
1509: hr_utility.trace('Payroll id = '||p_payroll_id);
1510: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1511: hr_utility.trace('Organization id = '||p_organization_id);
1512: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1513: hr_utility.trace('Location id = '||p_location_id);
1514: hr_utility.trace('Business Group id = '||p_business_group_id);
1515: hr_utility.trace('State Id = '||p_state_id);
1516: hr_utility.trace('County Id = '||p_county_id);

Line 1513: hr_utility.trace('Location id = '||p_location_id);

1509: hr_utility.trace('Payroll id = '||p_payroll_id);
1510: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1511: hr_utility.trace('Organization id = '||p_organization_id);
1512: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1513: hr_utility.trace('Location id = '||p_location_id);
1514: hr_utility.trace('Business Group id = '||p_business_group_id);
1515: hr_utility.trace('State Id = '||p_state_id);
1516: hr_utility.trace('County Id = '||p_county_id);
1517: hr_utility.trace('City Id = '||p_city_id);

Line 1514: hr_utility.trace('Business Group id = '||p_business_group_id);

1510: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1511: hr_utility.trace('Organization id = '||p_organization_id);
1512: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1513: hr_utility.trace('Location id = '||p_location_id);
1514: hr_utility.trace('Business Group id = '||p_business_group_id);
1515: hr_utility.trace('State Id = '||p_state_id);
1516: hr_utility.trace('County Id = '||p_county_id);
1517: hr_utility.trace('City Id = '||p_city_id);
1518: hr_utility.trace('School Id = '||p_school_id);

Line 1515: hr_utility.trace('State Id = '||p_state_id);

1511: hr_utility.trace('Organization id = '||p_organization_id);
1512: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1513: hr_utility.trace('Location id = '||p_location_id);
1514: hr_utility.trace('Business Group id = '||p_business_group_id);
1515: hr_utility.trace('State Id = '||p_state_id);
1516: hr_utility.trace('County Id = '||p_county_id);
1517: hr_utility.trace('City Id = '||p_city_id);
1518: hr_utility.trace('School Id = '||p_school_id);
1519:

Line 1516: hr_utility.trace('County Id = '||p_county_id);

1512: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1513: hr_utility.trace('Location id = '||p_location_id);
1514: hr_utility.trace('Business Group id = '||p_business_group_id);
1515: hr_utility.trace('State Id = '||p_state_id);
1516: hr_utility.trace('County Id = '||p_county_id);
1517: hr_utility.trace('City Id = '||p_city_id);
1518: hr_utility.trace('School Id = '||p_school_id);
1519:
1520: ln_prev_person := -1;

Line 1517: hr_utility.trace('City Id = '||p_city_id);

1513: hr_utility.trace('Location id = '||p_location_id);
1514: hr_utility.trace('Business Group id = '||p_business_group_id);
1515: hr_utility.trace('State Id = '||p_state_id);
1516: hr_utility.trace('County Id = '||p_county_id);
1517: hr_utility.trace('City Id = '||p_city_id);
1518: hr_utility.trace('School Id = '||p_school_id);
1519:
1520: ln_prev_person := -1;
1521: ln_prev_gre := -1;

Line 1518: hr_utility.trace('School Id = '||p_school_id);

1514: hr_utility.trace('Business Group id = '||p_business_group_id);
1515: hr_utility.trace('State Id = '||p_state_id);
1516: hr_utility.trace('County Id = '||p_county_id);
1517: hr_utility.trace('City Id = '||p_city_id);
1518: hr_utility.trace('School Id = '||p_school_id);
1519:
1520: ln_prev_person := -1;
1521: ln_prev_gre := -1;
1522: /*

Line 1534: hr_utility.trace('ln_person_id = '||ln_person_id);

1530: ,p_business_group_id);
1531:
1532: LOOP
1533: fetch c_employee_count into ln_person_id, lv_last_name, ln_action_number;
1534: hr_utility.trace('ln_person_id = '||ln_person_id);
1535: hr_utility.trace('lv_last_name = '||lv_last_name);
1536: hr_utility.trace('ln_action_number = '||ln_action_number);
1537: exit when c_employee_count%NOTFOUND;
1538: END LOOP;

Line 1535: hr_utility.trace('lv_last_name = '||lv_last_name);

1531:
1532: LOOP
1533: fetch c_employee_count into ln_person_id, lv_last_name, ln_action_number;
1534: hr_utility.trace('ln_person_id = '||ln_person_id);
1535: hr_utility.trace('lv_last_name = '||lv_last_name);
1536: hr_utility.trace('ln_action_number = '||ln_action_number);
1537: exit when c_employee_count%NOTFOUND;
1538: END LOOP;
1539: close c_employee_count;

Line 1536: hr_utility.trace('ln_action_number = '||ln_action_number);

1532: LOOP
1533: fetch c_employee_count into ln_person_id, lv_last_name, ln_action_number;
1534: hr_utility.trace('ln_person_id = '||ln_person_id);
1535: hr_utility.trace('lv_last_name = '||lv_last_name);
1536: hr_utility.trace('ln_action_number = '||ln_action_number);
1537: exit when c_employee_count%NOTFOUND;
1538: END LOOP;
1539: close c_employee_count;
1540: */

Line 1575: hr_utility.trace('-----------------------------------------------');

1571: lv_action_type,
1572: ln_person_id,
1573: ld_effective_date;
1574: EXIT WHEN c_employee%NOTFOUND;
1575: hr_utility.trace('-----------------------------------------------');
1576: hr_utility.trace('C_EMPLOYEE CURSOR');
1577: hr_utility.trace('ln_action_number = '||ln_action_number);
1578: hr_utility.trace('lv_last_name = '||lv_last_name);
1579: hr_utility.trace('ln_person_id = '||ln_person_id);

Line 1576: hr_utility.trace('C_EMPLOYEE CURSOR');

1572: ln_person_id,
1573: ld_effective_date;
1574: EXIT WHEN c_employee%NOTFOUND;
1575: hr_utility.trace('-----------------------------------------------');
1576: hr_utility.trace('C_EMPLOYEE CURSOR');
1577: hr_utility.trace('ln_action_number = '||ln_action_number);
1578: hr_utility.trace('lv_last_name = '||lv_last_name);
1579: hr_utility.trace('ln_person_id = '||ln_person_id);
1580: hr_utility.trace('-----------------------------------------------');

Line 1577: hr_utility.trace('ln_action_number = '||ln_action_number);

1573: ld_effective_date;
1574: EXIT WHEN c_employee%NOTFOUND;
1575: hr_utility.trace('-----------------------------------------------');
1576: hr_utility.trace('C_EMPLOYEE CURSOR');
1577: hr_utility.trace('ln_action_number = '||ln_action_number);
1578: hr_utility.trace('lv_last_name = '||lv_last_name);
1579: hr_utility.trace('ln_person_id = '||ln_person_id);
1580: hr_utility.trace('-----------------------------------------------');
1581:

Line 1578: hr_utility.trace('lv_last_name = '||lv_last_name);

1574: EXIT WHEN c_employee%NOTFOUND;
1575: hr_utility.trace('-----------------------------------------------');
1576: hr_utility.trace('C_EMPLOYEE CURSOR');
1577: hr_utility.trace('ln_action_number = '||ln_action_number);
1578: hr_utility.trace('lv_last_name = '||lv_last_name);
1579: hr_utility.trace('ln_person_id = '||ln_person_id);
1580: hr_utility.trace('-----------------------------------------------');
1581:
1582: if ln_prev_person = -1 then

Line 1579: hr_utility.trace('ln_person_id = '||ln_person_id);

1575: hr_utility.trace('-----------------------------------------------');
1576: hr_utility.trace('C_EMPLOYEE CURSOR');
1577: hr_utility.trace('ln_action_number = '||ln_action_number);
1578: hr_utility.trace('lv_last_name = '||lv_last_name);
1579: hr_utility.trace('ln_person_id = '||ln_person_id);
1580: hr_utility.trace('-----------------------------------------------');
1581:
1582: if ln_prev_person = -1 then
1583: ln_prev_person := ln_person_id;

Line 1580: hr_utility.trace('-----------------------------------------------');

1576: hr_utility.trace('C_EMPLOYEE CURSOR');
1577: hr_utility.trace('ln_action_number = '||ln_action_number);
1578: hr_utility.trace('lv_last_name = '||lv_last_name);
1579: hr_utility.trace('ln_person_id = '||ln_person_id);
1580: hr_utility.trace('-----------------------------------------------');
1581:
1582: if ln_prev_person = -1 then
1583: ln_prev_person := ln_person_id;
1584: end if;

Line 1590: hr_utility.trace('EMPLOYEE NOT FOUND');

1586: ln_prev_gre := ln_tax_unit_id;
1587: end if;
1588:
1589: if c_employee%notfound then
1590: hr_utility.trace('EMPLOYEE NOT FOUND');
1591: hr_utility.set_location(gv_package_name || '.archiver_extract', 105);
1592: exit;
1593: else
1594: hr_utility.trace('EMPLOYEE FOUND');

Line 1591: hr_utility.set_location(gv_package_name || '.archiver_extract', 105);

1587: end if;
1588:
1589: if c_employee%notfound then
1590: hr_utility.trace('EMPLOYEE NOT FOUND');
1591: hr_utility.set_location(gv_package_name || '.archiver_extract', 105);
1592: exit;
1593: else
1594: hr_utility.trace('EMPLOYEE FOUND');
1595: -- hr_utility.trace('Employee action_number = '||ln_action_number);

Line 1594: hr_utility.trace('EMPLOYEE FOUND');

1590: hr_utility.trace('EMPLOYEE NOT FOUND');
1591: hr_utility.set_location(gv_package_name || '.archiver_extract', 105);
1592: exit;
1593: else
1594: hr_utility.trace('EMPLOYEE FOUND');
1595: -- hr_utility.trace('Employee action_number = '||ln_action_number);
1596: -- hr_utility.trace('Employee Last Name = '||lv_last_name);
1597: -- hr_utility.trace('Employee First Name = '||lv_first_name);
1598: end if;

Line 1595: -- hr_utility.trace('Employee action_number = '||ln_action_number);

1591: hr_utility.set_location(gv_package_name || '.archiver_extract', 105);
1592: exit;
1593: else
1594: hr_utility.trace('EMPLOYEE FOUND');
1595: -- hr_utility.trace('Employee action_number = '||ln_action_number);
1596: -- hr_utility.trace('Employee Last Name = '||lv_last_name);
1597: -- hr_utility.trace('Employee First Name = '||lv_first_name);
1598: end if;
1599:

Line 1596: -- hr_utility.trace('Employee Last Name = '||lv_last_name);

1592: exit;
1593: else
1594: hr_utility.trace('EMPLOYEE FOUND');
1595: -- hr_utility.trace('Employee action_number = '||ln_action_number);
1596: -- hr_utility.trace('Employee Last Name = '||lv_last_name);
1597: -- hr_utility.trace('Employee First Name = '||lv_first_name);
1598: end if;
1599:
1600: /*----------------------------------------------------------

Line 1597: -- hr_utility.trace('Employee First Name = '||lv_first_name);

1593: else
1594: hr_utility.trace('EMPLOYEE FOUND');
1595: -- hr_utility.trace('Employee action_number = '||ln_action_number);
1596: -- hr_utility.trace('Employee Last Name = '||lv_last_name);
1597: -- hr_utility.trace('Employee First Name = '||lv_first_name);
1598: end if;
1599:
1600: /*----------------------------------------------------------
1601: -- If Assignment Set is used, pick up only those employee

Line 1604: hr_utility.set_location(gv_package_name || '.archiver_extract', 110);

1600: /*----------------------------------------------------------
1601: -- If Assignment Set is used, pick up only those employee
1602: -- assignments which are part of the Assignment Set
1603: -----------------------------------------------------------*/
1604: hr_utility.set_location(gv_package_name || '.archiver_extract', 110);
1605:
1606: if hr_assignment_set.assignment_in_set(p_assignment_set_id
1607: ,ln_assignment_id) = 'Y' then
1608:

Line 1609: hr_utility.set_location(gv_package_name || '.archiver_extract', 120);

1605:
1606: if hr_assignment_set.assignment_in_set(p_assignment_set_id
1607: ,ln_assignment_id) = 'Y' then
1608:
1609: hr_utility.set_location(gv_package_name || '.archiver_extract', 120);
1610:
1611: /************************************/
1612: /*** FEDERAL balances ***/
1613: /************************************/

Line 1636: hr_utility.trace('Fetched FEDERAL balance ---------------');

1632: ln_medicare_er_liability,
1633: ln_eic_advance;
1634: EXIT WHEN c_federal_balances%NOTFOUND;
1635:
1636: hr_utility.trace('Fetched FEDERAL balance ---------------');
1637: hr_utility.trace('Detail Level in FED = '||p_detail_level);
1638: hr_utility.trace('ln_action_number = '||ln_action_number);
1639: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1640: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);

Line 1637: hr_utility.trace('Detail Level in FED = '||p_detail_level);

1633: ln_eic_advance;
1634: EXIT WHEN c_federal_balances%NOTFOUND;
1635:
1636: hr_utility.trace('Fetched FEDERAL balance ---------------');
1637: hr_utility.trace('Detail Level in FED = '||p_detail_level);
1638: hr_utility.trace('ln_action_number = '||ln_action_number);
1639: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1640: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1641:

Line 1638: hr_utility.trace('ln_action_number = '||ln_action_number);

1634: EXIT WHEN c_federal_balances%NOTFOUND;
1635:
1636: hr_utility.trace('Fetched FEDERAL balance ---------------');
1637: hr_utility.trace('Detail Level in FED = '||p_detail_level);
1638: hr_utility.trace('ln_action_number = '||ln_action_number);
1639: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1640: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1641:
1642: IF p_detail_level = '01' THEN -- By Run

Line 1639: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);

1635:
1636: hr_utility.trace('Fetched FEDERAL balance ---------------');
1637: hr_utility.trace('Detail Level in FED = '||p_detail_level);
1638: hr_utility.trace('ln_action_number = '||ln_action_number);
1639: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1640: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1641:
1642: IF p_detail_level = '01' THEN -- By Run
1643: emp_static_data(

Line 1640: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);

1636: hr_utility.trace('Fetched FEDERAL balance ---------------');
1637: hr_utility.trace('Detail Level in FED = '||p_detail_level);
1638: hr_utility.trace('ln_action_number = '||ln_action_number);
1639: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1640: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1641:
1642: IF p_detail_level = '01' THEN -- By Run
1643: emp_static_data(
1644: lv_last_name,

Line 1684: --hr_utility.trace('FED static data = '||lv_federal_data);

1680: nvl(ln_eic_advance,0),
1681: p_output_file_type,
1682: lv_federal_data);
1683: lv_data_row := lv_data_row||lv_federal_data;
1684: --hr_utility.trace('FED static data = '||lv_federal_data);
1685: --hr_utility.trace('Data Row = '||lv_data_row);
1686:
1687: if p_output_file_type = 'HTML' then
1688: lv_data_row := '

'||lv_data_row||'';

Line 1685: --hr_utility.trace('Data Row = '||lv_data_row);

1681: p_output_file_type,
1682: lv_federal_data);
1683: lv_data_row := lv_data_row||lv_federal_data;
1684: --hr_utility.trace('FED static data = '||lv_federal_data);
1685: --hr_utility.trace('Data Row = '||lv_data_row);
1686:
1687: if p_output_file_type = 'HTML' then
1688: lv_data_row := '

'||lv_data_row||'';
1689: end if;

Line 1698: hr_utility.trace('------------------------------------------');

1694:
1695: /******* Federal Summary Level ********/
1696:
1697: IF p_detail_level = '02' THEN
1698: hr_utility.trace('------------------------------------------');
1699: hr_utility.trace('Federal by summary.......................');
1700: hr_utility.trace('ln_prev_person = '||ln_prev_person);
1701: hr_utility.trace('ln_person_id = '||ln_person_id);
1702:

Line 1699: hr_utility.trace('Federal by summary.......................');

1695: /******* Federal Summary Level ********/
1696:
1697: IF p_detail_level = '02' THEN
1698: hr_utility.trace('------------------------------------------');
1699: hr_utility.trace('Federal by summary.......................');
1700: hr_utility.trace('ln_prev_person = '||ln_prev_person);
1701: hr_utility.trace('ln_person_id = '||ln_person_id);
1702:
1703: IF ln_prev_person = ln_person_id then

Line 1700: hr_utility.trace('ln_prev_person = '||ln_prev_person);

1696:
1697: IF p_detail_level = '02' THEN
1698: hr_utility.trace('------------------------------------------');
1699: hr_utility.trace('Federal by summary.......................');
1700: hr_utility.trace('ln_prev_person = '||ln_prev_person);
1701: hr_utility.trace('ln_person_id = '||ln_person_id);
1702:
1703: IF ln_prev_person = ln_person_id then
1704: emp_sum_static_data( lv_last_name,

Line 1701: hr_utility.trace('ln_person_id = '||ln_person_id);

1697: IF p_detail_level = '02' THEN
1698: hr_utility.trace('------------------------------------------');
1699: hr_utility.trace('Federal by summary.......................');
1700: hr_utility.trace('ln_prev_person = '||ln_prev_person);
1701: hr_utility.trace('ln_person_id = '||ln_person_id);
1702:
1703: IF ln_prev_person = ln_person_id then
1704: emp_sum_static_data( lv_last_name,
1705: lv_first_name,

Line 1717: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);

1713: lv_data_row := lv_employee_data;
1714:
1715: lv_found := 'N';
1716:
1717: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1718: hr_utility.trace('ln_fit_gross_sum BEFORE adding = '||
1719: ln_fit_gross_sum);
1720: hr_utility.trace('ln_prev_gre = '||ln_prev_gre);
1721: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);

Line 1718: hr_utility.trace('ln_fit_gross_sum BEFORE adding = '||

1714:
1715: lv_found := 'N';
1716:
1717: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1718: hr_utility.trace('ln_fit_gross_sum BEFORE adding = '||
1719: ln_fit_gross_sum);
1720: hr_utility.trace('ln_prev_gre = '||ln_prev_gre);
1721: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
1722:

Line 1720: hr_utility.trace('ln_prev_gre = '||ln_prev_gre);

1716:
1717: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1718: hr_utility.trace('ln_fit_gross_sum BEFORE adding = '||
1719: ln_fit_gross_sum);
1720: hr_utility.trace('ln_prev_gre = '||ln_prev_gre);
1721: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
1722:
1723: IF federal_bal.count > 0 THEN
1724: FOR k in federal_bal.first..federal_bal.last LOOP

Line 1721: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);

1717: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1718: hr_utility.trace('ln_fit_gross_sum BEFORE adding = '||
1719: ln_fit_gross_sum);
1720: hr_utility.trace('ln_prev_gre = '||ln_prev_gre);
1721: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
1722:
1723: IF federal_bal.count > 0 THEN
1724: FOR k in federal_bal.first..federal_bal.last LOOP
1725: IF federal_bal(k).tax_unit_id = ln_tax_unit_id THEN

Line 1801: hr_utility.trace('Inside FED ELSE...........');

1797: federal_bal(1).eic_advance := nvl(ln_eic_advance,0);
1798: END IF; /* federal_bal.count check */
1799:
1800: ELSE /* New person fetched */
1801: hr_utility.trace('Inside FED ELSE...........');
1802: hr_utility.trace('New Person fetched ..........');
1803:
1804: lv_prev_emp_data_row := lv_data_row;
1805: IF federal_bal.count>0 THEN

Line 1802: hr_utility.trace('New Person fetched ..........');

1798: END IF; /* federal_bal.count check */
1799:
1800: ELSE /* New person fetched */
1801: hr_utility.trace('Inside FED ELSE...........');
1802: hr_utility.trace('New Person fetched ..........');
1803:
1804: lv_prev_emp_data_row := lv_data_row;
1805: IF federal_bal.count>0 THEN
1806: FOR k in federal_bal.first..federal_bal.last LOOP

Line 1848: hr_utility.trace('resetting summary for Federal ...........');

1844: ln_prev_person := ln_person_id;
1845:
1846: /******* rest sum to currently fetched person *****/
1847:
1848: hr_utility.trace('resetting summary for Federal ...........');
1849: IF federal_bal.count > 0 THEN
1850: FOR k in federal_bal.first..federal_bal.last LOOP
1851: federal_bal(k).tax_unit_id := -1;
1852: federal_bal(k).gre_name := '';

Line 1901: hr_utility.trace('-------------------------------------');

1897: /*** STATE balances ***/
1898: /****************************************/
1899:
1900: IF p_jurisdiction_level = '02' THEN
1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('.......... In STATE..................');
1903: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
1904: hr_utility.trace('p_state_id = '||p_state_id);
1905: hr_utility.trace('ln_action_number = '||ln_action_number);

Line 1902: hr_utility.trace('.......... In STATE..................');

1898: /****************************************/
1899:
1900: IF p_jurisdiction_level = '02' THEN
1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('.......... In STATE..................');
1903: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
1904: hr_utility.trace('p_state_id = '||p_state_id);
1905: hr_utility.trace('ln_action_number = '||ln_action_number);
1906: hr_utility.trace('-------------------------------------');

Line 1903: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);

1899:
1900: IF p_jurisdiction_level = '02' THEN
1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('.......... In STATE..................');
1903: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
1904: hr_utility.trace('p_state_id = '||p_state_id);
1905: hr_utility.trace('ln_action_number = '||ln_action_number);
1906: hr_utility.trace('-------------------------------------');
1907:

Line 1904: hr_utility.trace('p_state_id = '||p_state_id);

1900: IF p_jurisdiction_level = '02' THEN
1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('.......... In STATE..................');
1903: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
1904: hr_utility.trace('p_state_id = '||p_state_id);
1905: hr_utility.trace('ln_action_number = '||ln_action_number);
1906: hr_utility.trace('-------------------------------------');
1907:
1908: open c_state_balances(ln_action_number,

Line 1905: hr_utility.trace('ln_action_number = '||ln_action_number);

1901: hr_utility.trace('-------------------------------------');
1902: hr_utility.trace('.......... In STATE..................');
1903: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
1904: hr_utility.trace('p_state_id = '||p_state_id);
1905: hr_utility.trace('ln_action_number = '||ln_action_number);
1906: hr_utility.trace('-------------------------------------');
1907:
1908: open c_state_balances(ln_action_number,
1909: p_state_id);

Line 1906: hr_utility.trace('-------------------------------------');

1902: hr_utility.trace('.......... In STATE..................');
1903: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
1904: hr_utility.trace('p_state_id = '||p_state_id);
1905: hr_utility.trace('ln_action_number = '||ln_action_number);
1906: hr_utility.trace('-------------------------------------');
1907:
1908: open c_state_balances(ln_action_number,
1909: p_state_id);
1910: hr_utility.trace('State first cursor OPEN ');

Line 1910: hr_utility.trace('State first cursor OPEN ');

1906: hr_utility.trace('-------------------------------------');
1907:
1908: open c_state_balances(ln_action_number,
1909: p_state_id);
1910: hr_utility.trace('State first cursor OPEN ');
1911:
1912: LOOP
1913:
1914: hr_utility.trace('Fetching STATE balance ...............');

Line 1914: hr_utility.trace('Fetching STATE balance ...............');

1910: hr_utility.trace('State first cursor OPEN ');
1911:
1912: LOOP
1913:
1914: hr_utility.trace('Fetching STATE balance ...............');
1915:
1916: fetch c_state_balances into lv_jurisdiction,
1917: lv_jurisdiction_name,
1918: ln_sit_gross,

Line 1937: hr_utility.trace('----------------------------------------');

1933:
1934: lv_state_ein := f_state_ein(ln_tax_unit_id,
1935: substr(lv_jurisdiction,1,2));
1936:
1937: hr_utility.trace('----------------------------------------');
1938: hr_utility.trace('Fetched STATE record...............');
1939: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);
1940: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);
1941: hr_utility.trace('----------------------------------------');

Line 1938: hr_utility.trace('Fetched STATE record...............');

1934: lv_state_ein := f_state_ein(ln_tax_unit_id,
1935: substr(lv_jurisdiction,1,2));
1936:
1937: hr_utility.trace('----------------------------------------');
1938: hr_utility.trace('Fetched STATE record...............');
1939: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);
1940: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);
1941: hr_utility.trace('----------------------------------------');
1942:

Line 1939: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);

1935: substr(lv_jurisdiction,1,2));
1936:
1937: hr_utility.trace('----------------------------------------');
1938: hr_utility.trace('Fetched STATE record...............');
1939: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);
1940: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);
1941: hr_utility.trace('----------------------------------------');
1942:
1943: /******* State Balance By Run *****/

Line 1940: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);

1936:
1937: hr_utility.trace('----------------------------------------');
1938: hr_utility.trace('Fetched STATE record...............');
1939: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);
1940: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);
1941: hr_utility.trace('----------------------------------------');
1942:
1943: /******* State Balance By Run *****/
1944:

Line 1941: hr_utility.trace('----------------------------------------');

1937: hr_utility.trace('----------------------------------------');
1938: hr_utility.trace('Fetched STATE record...............');
1939: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);
1940: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);
1941: hr_utility.trace('----------------------------------------');
1942:
1943: /******* State Balance By Run *****/
1944:
1945: IF p_detail_level = '01' THEN

Line 1947: hr_utility.trace('----------------------------------------');

1943: /******* State Balance By Run *****/
1944:
1945: IF p_detail_level = '01' THEN
1946:
1947: hr_utility.trace('----------------------------------------');
1948: hr_utility.trace('State by run out put....................');
1949: hr_utility.trace('ln_action_number = '||ln_action_number);
1950: hr_utility.trace('----------------------------------------');
1951:

Line 1948: hr_utility.trace('State by run out put....................');

1944:
1945: IF p_detail_level = '01' THEN
1946:
1947: hr_utility.trace('----------------------------------------');
1948: hr_utility.trace('State by run out put....................');
1949: hr_utility.trace('ln_action_number = '||ln_action_number);
1950: hr_utility.trace('----------------------------------------');
1951:
1952: emp_static_data(

Line 1949: hr_utility.trace('ln_action_number = '||ln_action_number);

1945: IF p_detail_level = '01' THEN
1946:
1947: hr_utility.trace('----------------------------------------');
1948: hr_utility.trace('State by run out put....................');
1949: hr_utility.trace('ln_action_number = '||ln_action_number);
1950: hr_utility.trace('----------------------------------------');
1951:
1952: emp_static_data(
1953: lv_last_name,

Line 1950: hr_utility.trace('----------------------------------------');

1946:
1947: hr_utility.trace('----------------------------------------');
1948: hr_utility.trace('State by run out put....................');
1949: hr_utility.trace('ln_action_number = '||ln_action_number);
1950: hr_utility.trace('----------------------------------------');
1951:
1952: emp_static_data(
1953: lv_last_name,
1954: lv_first_name,

Line 2005: hr_utility.trace('---------State by Summary --------------');

2001:
2002:
2003: /********* State Balance by Summary(by jurisdiction level) *****/
2004:
2005: hr_utility.trace('---------State by Summary --------------');
2006: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2007: hr_utility.trace('ln_person_id = '||ln_person_id);
2008: hr_utility.trace('----------------------------------------');
2009:

Line 2006: hr_utility.trace('ln_prev_person = '||ln_prev_person);

2002:
2003: /********* State Balance by Summary(by jurisdiction level) *****/
2004:
2005: hr_utility.trace('---------State by Summary --------------');
2006: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2007: hr_utility.trace('ln_person_id = '||ln_person_id);
2008: hr_utility.trace('----------------------------------------');
2009:
2010: IF p_detail_level = '02' then

Line 2007: hr_utility.trace('ln_person_id = '||ln_person_id);

2003: /********* State Balance by Summary(by jurisdiction level) *****/
2004:
2005: hr_utility.trace('---------State by Summary --------------');
2006: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2007: hr_utility.trace('ln_person_id = '||ln_person_id);
2008: hr_utility.trace('----------------------------------------');
2009:
2010: IF p_detail_level = '02' then
2011:

Line 2008: hr_utility.trace('----------------------------------------');

2004:
2005: hr_utility.trace('---------State by Summary --------------');
2006: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2007: hr_utility.trace('ln_person_id = '||ln_person_id);
2008: hr_utility.trace('----------------------------------------');
2009:
2010: IF p_detail_level = '02' then
2011:
2012: IF ln_prev_person = ln_person_id Then

Line 2029: hr_utility.trace('lv_state_id = '||lv_state_id);

2025: ELSE
2026: lv_state_id := p_state_id;
2027: END IF;
2028:
2029: hr_utility.trace('lv_state_id = '||lv_state_id);
2030:
2031: lv_found := 'N';
2032: hr_utility.trace('state_bal.count = '||state_bal.count);
2033: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);

Line 2032: hr_utility.trace('state_bal.count = '||state_bal.count);

2028:
2029: hr_utility.trace('lv_state_id = '||lv_state_id);
2030:
2031: lv_found := 'N';
2032: hr_utility.trace('state_bal.count = '||state_bal.count);
2033: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2034: IF state_bal.count > 0 THEN
2035: FOR k in state_bal.first..state_bal.last LOOP
2036: IF (state_bal(k).jurisdiction_code = lv_jurisdiction

Line 2033: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);

2029: hr_utility.trace('lv_state_id = '||lv_state_id);
2030:
2031: lv_found := 'N';
2032: hr_utility.trace('state_bal.count = '||state_bal.count);
2033: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2034: IF state_bal.count > 0 THEN
2035: FOR k in state_bal.first..state_bal.last LOOP
2036: IF (state_bal(k).jurisdiction_code = lv_jurisdiction
2037: AND

Line 2074: hr_utility.trace('end of Loop');

2070: nvl(ln_workers_comp2_withheld ,0)+
2071: state_bal(k).workers_comp2_withheld;
2072: END IF;
2073: END LOOP;
2074: hr_utility.trace('end of Loop');
2075: hr_utility.trace('lv_found := '||lv_found);
2076: IF lv_found = 'N' THEN
2077: ln_next_tab := state_bal.count + 1;
2078: state_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;

Line 2075: hr_utility.trace('lv_found := '||lv_found);

2071: state_bal(k).workers_comp2_withheld;
2072: END IF;
2073: END LOOP;
2074: hr_utility.trace('end of Loop');
2075: hr_utility.trace('lv_found := '||lv_found);
2076: IF lv_found = 'N' THEN
2077: ln_next_tab := state_bal.count + 1;
2078: state_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;
2079: state_bal(ln_next_tab).gre_name := lv_gre_name;

Line 2112: hr_utility.trace('STATE first fetch .................');

2108: nvl(ln_workers_comp2_withheld,0) ;
2109: END IF;
2110:
2111: ELSE /* state_bal.count = 0, first fetch **/
2112: hr_utility.trace('STATE first fetch .................');
2113: state_bal(1).tax_unit_id := ln_tax_unit_id;
2114: state_bal(1).gre_name := lv_gre_name;
2115: state_bal(1).state_ein := lv_state_ein;
2116: state_bal(1).jurisdiction_code := lv_jurisdiction;

Line 2135: hr_utility.trace('.....State ELSE New Person Fetched .......');

2131: state_bal(1).workers_comp2_withheld:=
2132: nvl(ln_workers_comp2_withheld,0);
2133: END IF;
2134: ELSE /** New Person Fetched, write out prev person **/
2135: hr_utility.trace('.....State ELSE New Person Fetched .......');
2136: hr_utility.trace('Write out the previous person.............');
2137:
2138: lv_prev_emp_data_row := lv_data_row;
2139:

Line 2136: hr_utility.trace('Write out the previous person.............');

2132: nvl(ln_workers_comp2_withheld,0);
2133: END IF;
2134: ELSE /** New Person Fetched, write out prev person **/
2135: hr_utility.trace('.....State ELSE New Person Fetched .......');
2136: hr_utility.trace('Write out the previous person.............');
2137:
2138: lv_prev_emp_data_row := lv_data_row;
2139:
2140: IF state_bal.count > 0 THEN

Line 2170: hr_utility.trace('Before building new emp header');

2166: end if;
2167: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2168: END LOOP;
2169: END IF; /* state_bal.count */
2170: hr_utility.trace('Before building new emp header');
2171:
2172: /** Now, build employee static header with the new
2173: fetched record **/
2174:

Line 2189: hr_utility.trace('Resetting Summary for State .............');

2185: ln_prev_person := ln_person_id;
2186:
2187: /******** reset Sum to currently fetched record *******/
2188:
2189: hr_utility.trace('Resetting Summary for State .............');
2190: IF state_bal.count > 0 THEN
2191: FOR i in state_bal.first..state_bal.last LOOP
2192: state_bal(i).tax_unit_id := -1;
2193: state_bal(i).gre_name := null;

Line 2235: hr_utility.trace('New state summary for '||

2231: nvl(ln_workers_comp_withheld,0) ;
2232: state_bal(1).workers_comp2_withheld:=
2233: nvl(ln_workers_comp2_withheld,0);
2234:
2235: hr_utility.trace('New state summary for '||
2236: ln_person_id|| ' sit_gross = '||
2237: state_bal(1).sit_gross);
2238: END IF; /* Person Check */
2239: END IF; /* detail level check */

Line 2251: hr_utility.trace('----------------------------------------');

2247: /******************************************/
2248:
2249: IF p_jurisdiction_level = '03' THEN
2250:
2251: hr_utility.trace('----------------------------------------');
2252: hr_utility.trace('.............In COUNTY..................');
2253: hr_utility.trace('p_state_id = '||p_state_id);
2254: hr_utility.trace('p_county_id = '||p_county_id);
2255: hr_utility.trace('ln_action_number = '||ln_action_number);

Line 2252: hr_utility.trace('.............In COUNTY..................');

2248:
2249: IF p_jurisdiction_level = '03' THEN
2250:
2251: hr_utility.trace('----------------------------------------');
2252: hr_utility.trace('.............In COUNTY..................');
2253: hr_utility.trace('p_state_id = '||p_state_id);
2254: hr_utility.trace('p_county_id = '||p_county_id);
2255: hr_utility.trace('ln_action_number = '||ln_action_number);
2256: hr_utility.trace('jurisdiction = '||p_state_id||'-'||

Line 2253: hr_utility.trace('p_state_id = '||p_state_id);

2249: IF p_jurisdiction_level = '03' THEN
2250:
2251: hr_utility.trace('----------------------------------------');
2252: hr_utility.trace('.............In COUNTY..................');
2253: hr_utility.trace('p_state_id = '||p_state_id);
2254: hr_utility.trace('p_county_id = '||p_county_id);
2255: hr_utility.trace('ln_action_number = '||ln_action_number);
2256: hr_utility.trace('jurisdiction = '||p_state_id||'-'||
2257: nvl(p_county_id,'%')||'-0000');

Line 2254: hr_utility.trace('p_county_id = '||p_county_id);

2250:
2251: hr_utility.trace('----------------------------------------');
2252: hr_utility.trace('.............In COUNTY..................');
2253: hr_utility.trace('p_state_id = '||p_state_id);
2254: hr_utility.trace('p_county_id = '||p_county_id);
2255: hr_utility.trace('ln_action_number = '||ln_action_number);
2256: hr_utility.trace('jurisdiction = '||p_state_id||'-'||
2257: nvl(p_county_id,'%')||'-0000');
2258: hr_utility.trace('----------------------------------------');

Line 2255: hr_utility.trace('ln_action_number = '||ln_action_number);

2251: hr_utility.trace('----------------------------------------');
2252: hr_utility.trace('.............In COUNTY..................');
2253: hr_utility.trace('p_state_id = '||p_state_id);
2254: hr_utility.trace('p_county_id = '||p_county_id);
2255: hr_utility.trace('ln_action_number = '||ln_action_number);
2256: hr_utility.trace('jurisdiction = '||p_state_id||'-'||
2257: nvl(p_county_id,'%')||'-0000');
2258: hr_utility.trace('----------------------------------------');
2259:

Line 2256: hr_utility.trace('jurisdiction = '||p_state_id||'-'||

2252: hr_utility.trace('.............In COUNTY..................');
2253: hr_utility.trace('p_state_id = '||p_state_id);
2254: hr_utility.trace('p_county_id = '||p_county_id);
2255: hr_utility.trace('ln_action_number = '||ln_action_number);
2256: hr_utility.trace('jurisdiction = '||p_state_id||'-'||
2257: nvl(p_county_id,'%')||'-0000');
2258: hr_utility.trace('----------------------------------------');
2259:
2260: OPEN c_county_balances(ln_action_number, p_state_id, p_county_id);

Line 2258: hr_utility.trace('----------------------------------------');

2254: hr_utility.trace('p_county_id = '||p_county_id);
2255: hr_utility.trace('ln_action_number = '||ln_action_number);
2256: hr_utility.trace('jurisdiction = '||p_state_id||'-'||
2257: nvl(p_county_id,'%')||'-0000');
2258: hr_utility.trace('----------------------------------------');
2259:
2260: OPEN c_county_balances(ln_action_number, p_state_id, p_county_id);
2261: LOOP
2262: hr_utility.trace('Fetching COUNTY records .................');

Line 2262: hr_utility.trace('Fetching COUNTY records .................');

2258: hr_utility.trace('----------------------------------------');
2259:
2260: OPEN c_county_balances(ln_action_number, p_state_id, p_county_id);
2261: LOOP
2262: hr_utility.trace('Fetching COUNTY records .................');
2263: fetch c_county_balances into lv_jurisdiction,
2264: lv_jurisdiction_name,
2265: ln_county_gross,
2266: ln_county_reduced_subject,

Line 2273: hr_utility.trace('Fetched records are .................');

2269: lv_non_resident_flag;
2270:
2271: EXIT WHEN c_county_balances%NOTFOUND;
2272:
2273: hr_utility.trace('Fetched records are .................');
2274: hr_utility.trace(' ');
2275: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2276: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2277: hr_utility.trace('ln_county_gross = '||ln_county_gross);

Line 2274: hr_utility.trace(' ');

2270:
2271: EXIT WHEN c_county_balances%NOTFOUND;
2272:
2273: hr_utility.trace('Fetched records are .................');
2274: hr_utility.trace(' ');
2275: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2276: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2277: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2278: hr_utility.trace('ln_county_reduced_subject = '||

Line 2275: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);

2271: EXIT WHEN c_county_balances%NOTFOUND;
2272:
2273: hr_utility.trace('Fetched records are .................');
2274: hr_utility.trace(' ');
2275: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2276: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2277: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2278: hr_utility.trace('ln_county_reduced_subject = '||
2279: ln_county_reduced_subject);

Line 2276: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);

2272:
2273: hr_utility.trace('Fetched records are .................');
2274: hr_utility.trace(' ');
2275: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2276: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2277: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2278: hr_utility.trace('ln_county_reduced_subject = '||
2279: ln_county_reduced_subject);
2280: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);

Line 2277: hr_utility.trace('ln_county_gross = '||ln_county_gross);

2273: hr_utility.trace('Fetched records are .................');
2274: hr_utility.trace(' ');
2275: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2276: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2277: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2278: hr_utility.trace('ln_county_reduced_subject = '||
2279: ln_county_reduced_subject);
2280: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);
2281: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);

Line 2278: hr_utility.trace('ln_county_reduced_subject = '||

2274: hr_utility.trace(' ');
2275: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2276: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2277: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2278: hr_utility.trace('ln_county_reduced_subject = '||
2279: ln_county_reduced_subject);
2280: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);
2281: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2282: hr_utility.trace('----------------------------------------');

Line 2280: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);

2276: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2277: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2278: hr_utility.trace('ln_county_reduced_subject = '||
2279: ln_county_reduced_subject);
2280: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);
2281: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2282: hr_utility.trace('----------------------------------------');
2283:
2284: /******** County Balances by run *******/

Line 2281: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);

2277: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2278: hr_utility.trace('ln_county_reduced_subject = '||
2279: ln_county_reduced_subject);
2280: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);
2281: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2282: hr_utility.trace('----------------------------------------');
2283:
2284: /******** County Balances by run *******/
2285:

Line 2282: hr_utility.trace('----------------------------------------');

2278: hr_utility.trace('ln_county_reduced_subject = '||
2279: ln_county_reduced_subject);
2280: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);
2281: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2282: hr_utility.trace('----------------------------------------');
2283:
2284: /******** County Balances by run *******/
2285:
2286: IF p_detail_level = '01' THEN

Line 2288: hr_utility.trace('----------------------------------------');

2284: /******** County Balances by run *******/
2285:
2286: IF p_detail_level = '01' THEN
2287:
2288: hr_utility.trace('----------------------------------------');
2289: hr_utility.trace('County by run output....................');
2290: hr_utility.trace('ln_action_number = '||ln_action_number);
2291: hr_utility.trace('----------------------------------------');
2292:

Line 2289: hr_utility.trace('County by run output....................');

2285:
2286: IF p_detail_level = '01' THEN
2287:
2288: hr_utility.trace('----------------------------------------');
2289: hr_utility.trace('County by run output....................');
2290: hr_utility.trace('ln_action_number = '||ln_action_number);
2291: hr_utility.trace('----------------------------------------');
2292:
2293: emp_static_data(

Line 2290: hr_utility.trace('ln_action_number = '||ln_action_number);

2286: IF p_detail_level = '01' THEN
2287:
2288: hr_utility.trace('----------------------------------------');
2289: hr_utility.trace('County by run output....................');
2290: hr_utility.trace('ln_action_number = '||ln_action_number);
2291: hr_utility.trace('----------------------------------------');
2292:
2293: emp_static_data(
2294: lv_last_name,

Line 2291: hr_utility.trace('----------------------------------------');

2287:
2288: hr_utility.trace('----------------------------------------');
2289: hr_utility.trace('County by run output....................');
2290: hr_utility.trace('ln_action_number = '||ln_action_number);
2291: hr_utility.trace('----------------------------------------');
2292:
2293: emp_static_data(
2294: lv_last_name,
2295: lv_first_name,

Line 2339: hr_utility.trace('----------------------------------------');

2335: /******* County Balances by Summary (by Jurisdiction) ******/
2336:
2337: IF p_detail_level = '02' THEN
2338:
2339: hr_utility.trace('----------------------------------------');
2340: hr_utility.trace('County by Summary....................');
2341: hr_utility.trace('ln_action_number = '||ln_action_number);
2342: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2343: hr_utility.trace('ln_person_id = '||ln_person_id);

Line 2340: hr_utility.trace('County by Summary....................');

2336:
2337: IF p_detail_level = '02' THEN
2338:
2339: hr_utility.trace('----------------------------------------');
2340: hr_utility.trace('County by Summary....................');
2341: hr_utility.trace('ln_action_number = '||ln_action_number);
2342: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2343: hr_utility.trace('ln_person_id = '||ln_person_id);
2344: hr_utility.trace('----------------------------------------');

Line 2341: hr_utility.trace('ln_action_number = '||ln_action_number);

2337: IF p_detail_level = '02' THEN
2338:
2339: hr_utility.trace('----------------------------------------');
2340: hr_utility.trace('County by Summary....................');
2341: hr_utility.trace('ln_action_number = '||ln_action_number);
2342: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2343: hr_utility.trace('ln_person_id = '||ln_person_id);
2344: hr_utility.trace('----------------------------------------');
2345:

Line 2342: hr_utility.trace('ln_prev_person = '||ln_prev_person);

2338:
2339: hr_utility.trace('----------------------------------------');
2340: hr_utility.trace('County by Summary....................');
2341: hr_utility.trace('ln_action_number = '||ln_action_number);
2342: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2343: hr_utility.trace('ln_person_id = '||ln_person_id);
2344: hr_utility.trace('----------------------------------------');
2345:
2346: IF ln_prev_person = ln_person_id THEN

Line 2343: hr_utility.trace('ln_person_id = '||ln_person_id);

2339: hr_utility.trace('----------------------------------------');
2340: hr_utility.trace('County by Summary....................');
2341: hr_utility.trace('ln_action_number = '||ln_action_number);
2342: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2343: hr_utility.trace('ln_person_id = '||ln_person_id);
2344: hr_utility.trace('----------------------------------------');
2345:
2346: IF ln_prev_person = ln_person_id THEN
2347: emp_sum_static_data( lv_last_name,

Line 2344: hr_utility.trace('----------------------------------------');

2340: hr_utility.trace('County by Summary....................');
2341: hr_utility.trace('ln_action_number = '||ln_action_number);
2342: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2343: hr_utility.trace('ln_person_id = '||ln_person_id);
2344: hr_utility.trace('----------------------------------------');
2345:
2346: IF ln_prev_person = ln_person_id THEN
2347: emp_sum_static_data( lv_last_name,
2348: lv_first_name,

Line 2363: hr_utility.trace('p_state_id = '||p_state_id);

2359: ELSE
2360: lv_county_id := p_county_id;
2361: END IF;
2362:
2363: hr_utility.trace('p_state_id = '||p_state_id);
2364: hr_utility.trace('lv_county_id = '||lv_county_id);
2365: hr_utility.trace('county_bal.count = '||county_bal.count);
2366:
2367: lv_found := 'N';

Line 2364: hr_utility.trace('lv_county_id = '||lv_county_id);

2360: lv_county_id := p_county_id;
2361: END IF;
2362:
2363: hr_utility.trace('p_state_id = '||p_state_id);
2364: hr_utility.trace('lv_county_id = '||lv_county_id);
2365: hr_utility.trace('county_bal.count = '||county_bal.count);
2366:
2367: lv_found := 'N';
2368:

Line 2365: hr_utility.trace('county_bal.count = '||county_bal.count);

2361: END IF;
2362:
2363: hr_utility.trace('p_state_id = '||p_state_id);
2364: hr_utility.trace('lv_county_id = '||lv_county_id);
2365: hr_utility.trace('county_bal.count = '||county_bal.count);
2366:
2367: lv_found := 'N';
2368:
2369: IF county_bal.count > 0 THEN

Line 2387: hr_utility.trace('lv_found := '||lv_found);

2383: nvl(ln_head_tax_withheld,0) +
2384: county_bal(k).county_head_tax_withheld;
2385: END IF;
2386: END LOOP;
2387: hr_utility.trace('lv_found := '||lv_found);
2388: IF lv_found = 'N' THEN
2389: ln_next_tab := county_bal.count +1;
2390: county_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;
2391: county_bal(ln_next_tab).gre_name := lv_gre_name;

Line 2408: hr_utility.trace('COUNTY first fetch ..........');

2404: END IF;
2405:
2406:
2407: ELSE /** county_bal = 0, first fetch **/
2408: hr_utility.trace('COUNTY first fetch ..........');
2409: county_bal(1).tax_unit_id := ln_tax_unit_id;
2410: county_bal(1).gre_name := lv_gre_name;
2411: county_bal(1).jurisdiction_code :=
2412: lv_jurisdiction;

Line 2427: hr_utility.trace('.......County ELSE New Person Fetched .......');

2423:
2424: END IF;
2425:
2426: ELSE /** New Person Fetched, write out prev person **/
2427: hr_utility.trace('.......County ELSE New Person Fetched .......');
2428: hr_utility.trace('Write out the previous person................');
2429:
2430: lv_prev_emp_data_row := lv_data_row;
2431:

Line 2428: hr_utility.trace('Write out the previous person................');

2424: END IF;
2425:
2426: ELSE /** New Person Fetched, write out prev person **/
2427: hr_utility.trace('.......County ELSE New Person Fetched .......');
2428: hr_utility.trace('Write out the previous person................');
2429:
2430: lv_prev_emp_data_row := lv_data_row;
2431:
2432: IF county_bal.count>0 THEN

Line 2451: hr_utility.trace('End of printing COUNTY sum.....');

2447: end if;
2448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2449: END LOOP;
2450: END IF; --county_bal.count
2451: hr_utility.trace('End of printing COUNTY sum.....');
2452:
2453: /**** Now, build employee static header with the new fetched ***/
2454: /**** Person record ***/
2455:

Line 2471: hr_utility.trace('Resetting Summary for county................');

2467: ln_prev_person := ln_person_id;
2468:
2469: /*** Reset sum to currently Fetched Record ***/
2470:
2471: hr_utility.trace('Resetting Summary for county................');
2472: IF county_bal.count > 0 THEN
2473: FOR k in county_bal.first..county_bal.last LOOP
2474: county_bal(k).tax_unit_id := -1;
2475: county_bal(k).gre_name := '';

Line 2495: hr_utility.trace('New County summary for '||

2491: county_bal(1).county_reduced_subject := nvl(ln_county_reduced_subject,0);
2492: county_bal(1).county_withheld := nvl(ln_county_withheld,0);
2493: county_bal(1).county_head_tax_withheld := nvl(ln_head_tax_withheld,0);
2494:
2495: hr_utility.trace('New County summary for '||
2496: ln_person_id||' county_gross = '||
2497: county_bal(1).county_gross);
2498:
2499: END IF; /** Person Check **/

Line 2512: hr_utility.trace('-----------------------------------------');

2508: /*************************************************/
2509:
2510: IF p_jurisdiction_level = '04' THEN
2511:
2512: hr_utility.trace('-----------------------------------------');
2513: hr_utility.trace('.........In CITY balances ...............');
2514: hr_utility.trace('ln_action_number = '||ln_action_number);
2515: hr_utility.trace('Jurisdiction Code = '||
2516: p_state_id||'-'||p_county_id||'-'||nvl(p_city_id,'%'));

Line 2513: hr_utility.trace('.........In CITY balances ...............');

2509:
2510: IF p_jurisdiction_level = '04' THEN
2511:
2512: hr_utility.trace('-----------------------------------------');
2513: hr_utility.trace('.........In CITY balances ...............');
2514: hr_utility.trace('ln_action_number = '||ln_action_number);
2515: hr_utility.trace('Jurisdiction Code = '||
2516: p_state_id||'-'||p_county_id||'-'||nvl(p_city_id,'%'));
2517: hr_utility.trace('-----------------------------------------');

Line 2514: hr_utility.trace('ln_action_number = '||ln_action_number);

2510: IF p_jurisdiction_level = '04' THEN
2511:
2512: hr_utility.trace('-----------------------------------------');
2513: hr_utility.trace('.........In CITY balances ...............');
2514: hr_utility.trace('ln_action_number = '||ln_action_number);
2515: hr_utility.trace('Jurisdiction Code = '||
2516: p_state_id||'-'||p_county_id||'-'||nvl(p_city_id,'%'));
2517: hr_utility.trace('-----------------------------------------');
2518:

Line 2515: hr_utility.trace('Jurisdiction Code = '||

2511:
2512: hr_utility.trace('-----------------------------------------');
2513: hr_utility.trace('.........In CITY balances ...............');
2514: hr_utility.trace('ln_action_number = '||ln_action_number);
2515: hr_utility.trace('Jurisdiction Code = '||
2516: p_state_id||'-'||p_county_id||'-'||nvl(p_city_id,'%'));
2517: hr_utility.trace('-----------------------------------------');
2518:
2519: open c_city_balances(ln_action_number,

Line 2517: hr_utility.trace('-----------------------------------------');

2513: hr_utility.trace('.........In CITY balances ...............');
2514: hr_utility.trace('ln_action_number = '||ln_action_number);
2515: hr_utility.trace('Jurisdiction Code = '||
2516: p_state_id||'-'||p_county_id||'-'||nvl(p_city_id,'%'));
2517: hr_utility.trace('-----------------------------------------');
2518:
2519: open c_city_balances(ln_action_number,
2520: p_state_id,
2521: p_county_id,

Line 2524: hr_utility.trace('Fetching CITY balance.............');

2520: p_state_id,
2521: p_county_id,
2522: p_city_id);
2523: LOOP
2524: hr_utility.trace('Fetching CITY balance.............');
2525: fetch c_city_balances into lv_jurisdiction,
2526: lv_jurisdiction_name,
2527: ln_city_gross,
2528: ln_city_reduced_subject,

Line 2535: hr_utility.trace('-----------------------------------------');

2531: lv_non_resident_flag;
2532:
2533: EXIT WHEN c_city_balances%NOTFOUND;
2534:
2535: hr_utility.trace('-----------------------------------------');
2536: hr_utility.trace('Fetched CITY balance.............');
2537: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2538: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2539: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);

Line 2536: hr_utility.trace('Fetched CITY balance.............');

2532:
2533: EXIT WHEN c_city_balances%NOTFOUND;
2534:
2535: hr_utility.trace('-----------------------------------------');
2536: hr_utility.trace('Fetched CITY balance.............');
2537: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2538: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2539: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2540: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);

Line 2537: hr_utility.trace('ln_city_gross = '||ln_city_gross);

2533: EXIT WHEN c_city_balances%NOTFOUND;
2534:
2535: hr_utility.trace('-----------------------------------------');
2536: hr_utility.trace('Fetched CITY balance.............');
2537: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2538: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2539: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2540: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2541: hr_utility.trace('-----------------------------------------');

Line 2538: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);

2534:
2535: hr_utility.trace('-----------------------------------------');
2536: hr_utility.trace('Fetched CITY balance.............');
2537: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2538: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2539: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2540: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2541: hr_utility.trace('-----------------------------------------');
2542:

Line 2539: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);

2535: hr_utility.trace('-----------------------------------------');
2536: hr_utility.trace('Fetched CITY balance.............');
2537: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2538: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2539: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2540: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2541: hr_utility.trace('-----------------------------------------');
2542:
2543: /****** City Balances By Run ********/

Line 2540: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);

2536: hr_utility.trace('Fetched CITY balance.............');
2537: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2538: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2539: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2540: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2541: hr_utility.trace('-----------------------------------------');
2542:
2543: /****** City Balances By Run ********/
2544:

Line 2541: hr_utility.trace('-----------------------------------------');

2537: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2538: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2539: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2540: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2541: hr_utility.trace('-----------------------------------------');
2542:
2543: /****** City Balances By Run ********/
2544:
2545: IF p_detail_level = '01' THEN

Line 2547: hr_utility.trace('-----------------------------------------');

2543: /****** City Balances By Run ********/
2544:
2545: IF p_detail_level = '01' THEN
2546:
2547: hr_utility.trace('-----------------------------------------');
2548: hr_utility.trace('City by Run output.......................');
2549: hr_utility.trace('ln_action_number = '||ln_action_number);
2550: hr_utility.trace('-----------------------------------------');
2551:

Line 2548: hr_utility.trace('City by Run output.......................');

2544:
2545: IF p_detail_level = '01' THEN
2546:
2547: hr_utility.trace('-----------------------------------------');
2548: hr_utility.trace('City by Run output.......................');
2549: hr_utility.trace('ln_action_number = '||ln_action_number);
2550: hr_utility.trace('-----------------------------------------');
2551:
2552: emp_static_data( lv_last_name,

Line 2549: hr_utility.trace('ln_action_number = '||ln_action_number);

2545: IF p_detail_level = '01' THEN
2546:
2547: hr_utility.trace('-----------------------------------------');
2548: hr_utility.trace('City by Run output.......................');
2549: hr_utility.trace('ln_action_number = '||ln_action_number);
2550: hr_utility.trace('-----------------------------------------');
2551:
2552: emp_static_data( lv_last_name,
2553: lv_first_name,

Line 2550: hr_utility.trace('-----------------------------------------');

2546:
2547: hr_utility.trace('-----------------------------------------');
2548: hr_utility.trace('City by Run output.......................');
2549: hr_utility.trace('ln_action_number = '||ln_action_number);
2550: hr_utility.trace('-----------------------------------------');
2551:
2552: emp_static_data( lv_last_name,
2553: lv_first_name,
2554: lv_middle_name,

Line 2597: hr_utility.trace('----------------------------------------');

2593: /********* City Balances by Summary (by Jurisdiction) *******/
2594:
2595: IF p_detail_level = '02' THEN
2596:
2597: hr_utility.trace('----------------------------------------');
2598: hr_utility.trace('City by Summary....................');
2599: hr_utility.trace('ln_action_number = '||ln_action_number);
2600: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2601: hr_utility.trace('ln_person_id = '||ln_person_id);

Line 2598: hr_utility.trace('City by Summary....................');

2594:
2595: IF p_detail_level = '02' THEN
2596:
2597: hr_utility.trace('----------------------------------------');
2598: hr_utility.trace('City by Summary....................');
2599: hr_utility.trace('ln_action_number = '||ln_action_number);
2600: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2601: hr_utility.trace('ln_person_id = '||ln_person_id);
2602: hr_utility.trace('----------------------------------------');

Line 2599: hr_utility.trace('ln_action_number = '||ln_action_number);

2595: IF p_detail_level = '02' THEN
2596:
2597: hr_utility.trace('----------------------------------------');
2598: hr_utility.trace('City by Summary....................');
2599: hr_utility.trace('ln_action_number = '||ln_action_number);
2600: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2601: hr_utility.trace('ln_person_id = '||ln_person_id);
2602: hr_utility.trace('----------------------------------------');
2603:

Line 2600: hr_utility.trace('ln_prev_person = '||ln_prev_person);

2596:
2597: hr_utility.trace('----------------------------------------');
2598: hr_utility.trace('City by Summary....................');
2599: hr_utility.trace('ln_action_number = '||ln_action_number);
2600: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2601: hr_utility.trace('ln_person_id = '||ln_person_id);
2602: hr_utility.trace('----------------------------------------');
2603:
2604: IF ln_prev_person = ln_person_id THEN

Line 2601: hr_utility.trace('ln_person_id = '||ln_person_id);

2597: hr_utility.trace('----------------------------------------');
2598: hr_utility.trace('City by Summary....................');
2599: hr_utility.trace('ln_action_number = '||ln_action_number);
2600: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2601: hr_utility.trace('ln_person_id = '||ln_person_id);
2602: hr_utility.trace('----------------------------------------');
2603:
2604: IF ln_prev_person = ln_person_id THEN
2605: emp_sum_static_data( lv_last_name,

Line 2602: hr_utility.trace('----------------------------------------');

2598: hr_utility.trace('City by Summary....................');
2599: hr_utility.trace('ln_action_number = '||ln_action_number);
2600: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2601: hr_utility.trace('ln_person_id = '||ln_person_id);
2602: hr_utility.trace('----------------------------------------');
2603:
2604: IF ln_prev_person = ln_person_id THEN
2605: emp_sum_static_data( lv_last_name,
2606: lv_first_name,

Line 2621: hr_utility.trace('city_bal.count = '||city_bal.count);

2617: lv_city_id := substr(lv_jurisdiction,8,4);
2618: ELSE
2619: lv_city_id := p_city_id;
2620: END IF;
2621: hr_utility.trace('city_bal.count = '||city_bal.count);
2622:
2623: lv_found := 'N';
2624: IF city_bal.count > 0 THEN
2625: FOR k in city_bal.first..city_bal.last LOOP

Line 2642: hr_utility.trace('lv_found := '||lv_found);

2638: nvl(ln_head_tax_withheld,0) +
2639: city_bal(k).head_tax_withheld;
2640: END IF;
2641: END LOOP;
2642: hr_utility.trace('lv_found := '||lv_found);
2643: IF lv_found = 'N' THEN
2644: ln_next_tab := city_bal.count +1;
2645: city_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;
2646: city_bal(ln_next_tab).gre_name := lv_gre_name;

Line 2660: hr_utility.trace('CITY first fetch ..........');

2656: nvl(ln_head_tax_withheld,0);
2657: END IF;
2658:
2659: ELSE /** city_bal = 0, first fetch **/
2660: hr_utility.trace('CITY first fetch ..........');
2661: city_bal(1).tax_unit_id := ln_tax_unit_id;
2662: city_bal(1).gre_name := lv_gre_name;
2663: city_bal(1).jurisdiction_code := lv_jurisdiction;
2664: city_bal(1).jurisdiction_name := lv_jurisdiction_name;

Line 2671: hr_utility.trace('.......City ELSE New Person Fetched .......');

2667: city_bal(1).city_withheld := nvl(ln_city_withheld,0);
2668: city_bal(1).head_tax_withheld := nvl(ln_head_tax_withheld,0);
2669: END IF;
2670: ELSE /*** New person fetched, write out prev person **/
2671: hr_utility.trace('.......City ELSE New Person Fetched .......');
2672: hr_utility.trace('Write out the previous person................');
2673:
2674: lv_prev_emp_data_row := lv_data_row;
2675:

Line 2672: hr_utility.trace('Write out the previous person................');

2668: city_bal(1).head_tax_withheld := nvl(ln_head_tax_withheld,0);
2669: END IF;
2670: ELSE /*** New person fetched, write out prev person **/
2671: hr_utility.trace('.......City ELSE New Person Fetched .......');
2672: hr_utility.trace('Write out the previous person................');
2673:
2674: lv_prev_emp_data_row := lv_data_row;
2675:
2676: IF city_bal.count>0 THEN

Line 2695: hr_utility.trace('End of printing COUNTY sum.....');

2691: end if;
2692: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2693: END LOOP;
2694: END IF; -- city_bal.count
2695: hr_utility.trace('End of printing COUNTY sum.....');
2696:
2697: /**** Now, build employee static header with the new fetched ***/
2698: /**** Person record ***/
2699:

Line 2714: hr_utility.trace('Resetting Summary for city................');

2710: ln_prev_person := ln_person_id;
2711:
2712: /*** Reset sum to currently Fetched Record ***/
2713:
2714: hr_utility.trace('Resetting Summary for city................');
2715: IF city_bal.count > 0 THEN
2716: FOR k in city_bal.first..city_bal.last LOOP
2717: city_bal(k).tax_unit_id := -1;
2718: city_bal(k).gre_name := '';

Line 2738: hr_utility.trace('New City summary for '||

2734: city_bal(1).city_reduced_subject := nvl(ln_city_reduced_subject,0);
2735: city_bal(1).city_withheld := nvl(ln_city_withheld,0);
2736: city_bal(1).head_tax_withheld := nvl(ln_head_tax_withheld,0);
2737:
2738: hr_utility.trace('New City summary for '||
2739: ln_person_id||' city_gross = '||
2740: city_bal(1).city_gross);
2741:
2742: END IF; /** Person Check **/

Line 2755: hr_utility.trace('-------------------------------------');

2751: /*********************************************/
2752:
2753: IF p_jurisdiction_level = '05' THEN
2754:
2755: hr_utility.trace('-------------------------------------');
2756: hr_utility.trace('............In SCHOOL DIST...........');
2757: hr_utility.trace('p_city_id = '||p_city_id);
2758: hr_utility.trace('Jurisdiction Code = '||
2759: p_state_id||'-'||nvl(p_school_id,'%'));

Line 2756: hr_utility.trace('............In SCHOOL DIST...........');

2752:
2753: IF p_jurisdiction_level = '05' THEN
2754:
2755: hr_utility.trace('-------------------------------------');
2756: hr_utility.trace('............In SCHOOL DIST...........');
2757: hr_utility.trace('p_city_id = '||p_city_id);
2758: hr_utility.trace('Jurisdiction Code = '||
2759: p_state_id||'-'||nvl(p_school_id,'%'));
2760:

Line 2757: hr_utility.trace('p_city_id = '||p_city_id);

2753: IF p_jurisdiction_level = '05' THEN
2754:
2755: hr_utility.trace('-------------------------------------');
2756: hr_utility.trace('............In SCHOOL DIST...........');
2757: hr_utility.trace('p_city_id = '||p_city_id);
2758: hr_utility.trace('Jurisdiction Code = '||
2759: p_state_id||'-'||nvl(p_school_id,'%'));
2760:
2761: open c_school_balances(ln_action_number,

Line 2758: hr_utility.trace('Jurisdiction Code = '||

2754:
2755: hr_utility.trace('-------------------------------------');
2756: hr_utility.trace('............In SCHOOL DIST...........');
2757: hr_utility.trace('p_city_id = '||p_city_id);
2758: hr_utility.trace('Jurisdiction Code = '||
2759: p_state_id||'-'||nvl(p_school_id,'%'));
2760:
2761: open c_school_balances(ln_action_number,
2762: p_state_id,

Line 2766: hr_utility.trace('Fetching SCHOOL balance ................');

2762: p_state_id,
2763: p_school_id);
2764: LOOP
2765:
2766: hr_utility.trace('Fetching SCHOOL balance ................');
2767: fetch c_school_balances into lv_jurisdiction,
2768: lv_jurisdiction_name,
2769: ln_school_gross,
2770: ln_school_reduced_subject,

Line 2775: hr_utility.trace('Fetched SCHOOL balance.............');

2771: ln_school_withheld;
2772:
2773: EXIT WHEN c_school_balances%NOTFOUND;
2774:
2775: hr_utility.trace('Fetched SCHOOL balance.............');
2776: hr_utility.trace('----------------------------------------');
2777: hr_utility.trace('ln_school_gross = '||ln_school_gross);
2778: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);
2779: hr_utility.trace('----------------------------------------');

Line 2776: hr_utility.trace('----------------------------------------');

2772:
2773: EXIT WHEN c_school_balances%NOTFOUND;
2774:
2775: hr_utility.trace('Fetched SCHOOL balance.............');
2776: hr_utility.trace('----------------------------------------');
2777: hr_utility.trace('ln_school_gross = '||ln_school_gross);
2778: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);
2779: hr_utility.trace('----------------------------------------');
2780:

Line 2777: hr_utility.trace('ln_school_gross = '||ln_school_gross);

2773: EXIT WHEN c_school_balances%NOTFOUND;
2774:
2775: hr_utility.trace('Fetched SCHOOL balance.............');
2776: hr_utility.trace('----------------------------------------');
2777: hr_utility.trace('ln_school_gross = '||ln_school_gross);
2778: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);
2779: hr_utility.trace('----------------------------------------');
2780:
2781: /******* School Balance By Run *****/

Line 2778: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);

2774:
2775: hr_utility.trace('Fetched SCHOOL balance.............');
2776: hr_utility.trace('----------------------------------------');
2777: hr_utility.trace('ln_school_gross = '||ln_school_gross);
2778: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);
2779: hr_utility.trace('----------------------------------------');
2780:
2781: /******* School Balance By Run *****/
2782:

Line 2779: hr_utility.trace('----------------------------------------');

2775: hr_utility.trace('Fetched SCHOOL balance.............');
2776: hr_utility.trace('----------------------------------------');
2777: hr_utility.trace('ln_school_gross = '||ln_school_gross);
2778: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);
2779: hr_utility.trace('----------------------------------------');
2780:
2781: /******* School Balance By Run *****/
2782:
2783: IF p_detail_level = '01' THEN

Line 2785: hr_utility.trace('-----------------------------------');

2781: /******* School Balance By Run *****/
2782:
2783: IF p_detail_level = '01' THEN
2784:
2785: hr_utility.trace('-----------------------------------');
2786: hr_utility.trace('School Dist by Run output..........');
2787: hr_utility.trace('ln_action_number = '||ln_action_number);
2788: hr_utility.trace('-----------------------------------');
2789:

Line 2786: hr_utility.trace('School Dist by Run output..........');

2782:
2783: IF p_detail_level = '01' THEN
2784:
2785: hr_utility.trace('-----------------------------------');
2786: hr_utility.trace('School Dist by Run output..........');
2787: hr_utility.trace('ln_action_number = '||ln_action_number);
2788: hr_utility.trace('-----------------------------------');
2789:
2790: emp_static_data( lv_last_name,

Line 2787: hr_utility.trace('ln_action_number = '||ln_action_number);

2783: IF p_detail_level = '01' THEN
2784:
2785: hr_utility.trace('-----------------------------------');
2786: hr_utility.trace('School Dist by Run output..........');
2787: hr_utility.trace('ln_action_number = '||ln_action_number);
2788: hr_utility.trace('-----------------------------------');
2789:
2790: emp_static_data( lv_last_name,
2791: lv_first_name,

Line 2788: hr_utility.trace('-----------------------------------');

2784:
2785: hr_utility.trace('-----------------------------------');
2786: hr_utility.trace('School Dist by Run output..........');
2787: hr_utility.trace('ln_action_number = '||ln_action_number);
2788: hr_utility.trace('-----------------------------------');
2789:
2790: emp_static_data( lv_last_name,
2791: lv_first_name,
2792: lv_middle_name,

Line 2832: hr_utility.trace('----------------------------------------');

2828:
2829: /***** School balance by Summary (by jurisdiction) *****/
2830:
2831: IF p_detail_level = '02' THEN
2832: hr_utility.trace('----------------------------------------');
2833: hr_utility.trace('City by Summary....................');
2834: hr_utility.trace('ln_action_number = '||ln_action_number);
2835: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2836: hr_utility.trace('ln_person_id = '||ln_person_id);

Line 2833: hr_utility.trace('City by Summary....................');

2829: /***** School balance by Summary (by jurisdiction) *****/
2830:
2831: IF p_detail_level = '02' THEN
2832: hr_utility.trace('----------------------------------------');
2833: hr_utility.trace('City by Summary....................');
2834: hr_utility.trace('ln_action_number = '||ln_action_number);
2835: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2836: hr_utility.trace('ln_person_id = '||ln_person_id);
2837: hr_utility.trace('----------------------------------------');

Line 2834: hr_utility.trace('ln_action_number = '||ln_action_number);

2830:
2831: IF p_detail_level = '02' THEN
2832: hr_utility.trace('----------------------------------------');
2833: hr_utility.trace('City by Summary....................');
2834: hr_utility.trace('ln_action_number = '||ln_action_number);
2835: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2836: hr_utility.trace('ln_person_id = '||ln_person_id);
2837: hr_utility.trace('----------------------------------------');
2838: IF ln_prev_person = ln_person_id THEN

Line 2835: hr_utility.trace('ln_prev_person = '||ln_prev_person);

2831: IF p_detail_level = '02' THEN
2832: hr_utility.trace('----------------------------------------');
2833: hr_utility.trace('City by Summary....................');
2834: hr_utility.trace('ln_action_number = '||ln_action_number);
2835: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2836: hr_utility.trace('ln_person_id = '||ln_person_id);
2837: hr_utility.trace('----------------------------------------');
2838: IF ln_prev_person = ln_person_id THEN
2839: emp_sum_static_data( lv_last_name,

Line 2836: hr_utility.trace('ln_person_id = '||ln_person_id);

2832: hr_utility.trace('----------------------------------------');
2833: hr_utility.trace('City by Summary....................');
2834: hr_utility.trace('ln_action_number = '||ln_action_number);
2835: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2836: hr_utility.trace('ln_person_id = '||ln_person_id);
2837: hr_utility.trace('----------------------------------------');
2838: IF ln_prev_person = ln_person_id THEN
2839: emp_sum_static_data( lv_last_name,
2840: lv_first_name,

Line 2837: hr_utility.trace('----------------------------------------');

2833: hr_utility.trace('City by Summary....................');
2834: hr_utility.trace('ln_action_number = '||ln_action_number);
2835: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2836: hr_utility.trace('ln_person_id = '||ln_person_id);
2837: hr_utility.trace('----------------------------------------');
2838: IF ln_prev_person = ln_person_id THEN
2839: emp_sum_static_data( lv_last_name,
2840: lv_first_name,
2841: lv_middle_name,

Line 2849: hr_utility.trace('p_state_id = '||p_state_id);

2845: p_output_file_type,
2846: lv_employee_data);
2847:
2848: lv_data_row := lv_employee_data;
2849: hr_utility.trace('p_state_id = '||p_state_id);
2850: hr_utility.trace('p_county_id = '||p_county_id);
2851: hr_utility.trace('p_city_id = '||p_city_id);
2852: hr_utility.trace('school_bal.count = '||school_bal.count);
2853:

Line 2850: hr_utility.trace('p_county_id = '||p_county_id);

2846: lv_employee_data);
2847:
2848: lv_data_row := lv_employee_data;
2849: hr_utility.trace('p_state_id = '||p_state_id);
2850: hr_utility.trace('p_county_id = '||p_county_id);
2851: hr_utility.trace('p_city_id = '||p_city_id);
2852: hr_utility.trace('school_bal.count = '||school_bal.count);
2853:
2854: lv_found := 'N';

Line 2851: hr_utility.trace('p_city_id = '||p_city_id);

2847:
2848: lv_data_row := lv_employee_data;
2849: hr_utility.trace('p_state_id = '||p_state_id);
2850: hr_utility.trace('p_county_id = '||p_county_id);
2851: hr_utility.trace('p_city_id = '||p_city_id);
2852: hr_utility.trace('school_bal.count = '||school_bal.count);
2853:
2854: lv_found := 'N';
2855: IF school_bal.count > 0 THEN

Line 2852: hr_utility.trace('school_bal.count = '||school_bal.count);

2848: lv_data_row := lv_employee_data;
2849: hr_utility.trace('p_state_id = '||p_state_id);
2850: hr_utility.trace('p_county_id = '||p_county_id);
2851: hr_utility.trace('p_city_id = '||p_city_id);
2852: hr_utility.trace('school_bal.count = '||school_bal.count);
2853:
2854: lv_found := 'N';
2855: IF school_bal.count > 0 THEN
2856: FOR k in school_bal.first..school_bal.last LOOP

Line 2870: hr_utility.trace('lv_found := '||lv_found);

2866: school_bal(k).school_withheld;
2867: END IF;
2868: END LOOP;
2869:
2870: hr_utility.trace('lv_found := '||lv_found);
2871: IF lv_found = 'N' THEN
2872: ln_next_tab := school_bal.count +1;
2873: school_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;
2874: school_bal(ln_next_tab).gre_name := lv_gre_name;

Line 2885: hr_utility.trace('SCHOOL first fetch ..........');

2881: school_bal(ln_next_tab).school_withheld := nvl(ln_school_withheld,0);
2882: END IF;
2883:
2884: ELSE /** city_bal = 0, first fetch **/
2885: hr_utility.trace('SCHOOL first fetch ..........');
2886: school_bal(1).tax_unit_id := ln_tax_unit_id;
2887: school_bal(1).gre_name := lv_gre_name;
2888: school_bal(1).jurisdiction_code := lv_jurisdiction;
2889: school_bal(1).jurisdiction_name := lv_jurisdiction_name;

Line 2896: hr_utility.trace('.......School ELSE New Person Fetched .......');

2892: nvl(ln_school_reduced_subject,0);
2893: school_bal(1).school_withheld := nvl(ln_school_withheld,0);
2894: END IF;
2895: ELSE /*** New person fetched, write out prev person **/
2896: hr_utility.trace('.......School ELSE New Person Fetched .......');
2897: hr_utility.trace('Write out the previous person................');
2898:
2899: lv_prev_emp_data_row := lv_data_row;
2900:

Line 2897: hr_utility.trace('Write out the previous person................');

2893: school_bal(1).school_withheld := nvl(ln_school_withheld,0);
2894: END IF;
2895: ELSE /*** New person fetched, write out prev person **/
2896: hr_utility.trace('.......School ELSE New Person Fetched .......');
2897: hr_utility.trace('Write out the previous person................');
2898:
2899: lv_prev_emp_data_row := lv_data_row;
2900:
2901: IF school_bal.count>0 THEN

Line 2918: hr_utility.trace('End of printing SCHOOL sum.....');

2914: end if;
2915: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2916: END LOOP;
2917: END IF; -- school_bal.count
2918: hr_utility.trace('End of printing SCHOOL sum.....');
2919: /**** Now, build employee static header with the new fetched ***/
2920: /**** Person record ***/
2921:
2922: emp_sum_static_data( lv_last_name,

Line 2935: hr_utility.trace('Resetting Summary for school................');

2931: /* Set the prev person to this fetched person */
2932: ln_prev_person := ln_person_id;
2933: /*** Reset sum to currently Fetched Record ***/
2934:
2935: hr_utility.trace('Resetting Summary for school................');
2936: IF school_bal.count > 0 THEN
2937: FOR k in school_bal.first..school_bal.last LOOP
2938: school_bal(k).tax_unit_id := -1;
2939: school_bal(k).gre_name := '';

Line 2957: hr_utility.trace('New School summary for '||

2953: school_bal(1).school_gross := nvl(ln_school_gross,0);
2954: school_bal(1).school_reduced_subject := nvl(ln_school_reduced_subject,0);
2955: school_bal(1).school_withheld := nvl(ln_school_withheld,0);
2956:
2957: hr_utility.trace('New School summary for '||
2958: ln_person_id||' school_withheld = '||
2959: school_bal(1).school_withheld);
2960:
2961: END IF; /** Person Check **/

Line 2971: hr_utility.trace('Getting Next employee ........ ');

2967: END IF; /**** End of Assignment Set ****/
2968:
2969: /** Reset the previous person to the current person
2970: before fetching another person **/
2971: hr_utility.trace('Getting Next employee ........ ');
2972:
2973: --ln_prev_person := ln_person_id; /* 2974109 fix */
2974:
2975: END LOOP; /** End of Employee Loop */

Line 2981: hr_utility.trace('Inside FINAL write out for FED');

2977:
2978: /**** Write out the last fetched record ****/
2979:
2980: IF (p_jurisdiction_level = '01' and p_detail_level = '02') then
2981: hr_utility.trace('Inside FINAL write out for FED');
2982:
2983: lv_emp_data_row := lv_data_row;
2984: IF federal_bal.count > 0 THEN
2985: FOR k in federal_bal.first..federal_bal.last LOOP

Line 3016: hr_utility.trace('Inside FINAL write out for STATE');

3012: END IF;
3013: END IF;
3014:
3015: IF (p_jurisdiction_level = '02' and p_detail_level = '02') then
3016: hr_utility.trace('Inside FINAL write out for STATE');
3017:
3018: lv_emp_data_row := lv_data_row;
3019:
3020: IF state_bal.count > 0 THEN

Line 3054: hr_utility.trace('Inside FINAL write out for COUNTY');

3050:
3051: END IF;
3052:
3053: IF (p_jurisdiction_level = '03' and p_detail_level = '02') then
3054: hr_utility.trace('Inside FINAL write out for COUNTY');
3055: lv_emp_data_row := lv_data_row;
3056:
3057: IF county_bal.count>0 THEN
3058: FOR j in county_bal.first..county_bal.last LOOP

Line 3081: hr_utility.trace('Inside FINAL write out for CITY');

3077: END IF; -- county_bal.count
3078: END IF;
3079:
3080: IF (p_jurisdiction_level = '04' and p_detail_level = '02') then
3081: hr_utility.trace('Inside FINAL write out for CITY');
3082: lv_emp_data_row := lv_data_row;
3083:
3084: IF city_bal.count>0 THEN
3085: FOR j in city_bal.first..city_bal.last LOOP

Line 3108: hr_utility.trace('Inside FINAL write out for SCHOOL');

3104: END IF; -- city_bal.count
3105: END IF;
3106:
3107: IF (p_jurisdiction_level = '05' and p_detail_level = '02') then
3108: hr_utility.trace('Inside FINAL write out for SCHOOL');
3109: lv_emp_data_row := lv_data_row;
3110:
3111: IF school_bal.count>0 THEN
3112: FOR j in school_bal.first..school_bal.last LOOP

Line 3135: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);

3131:
3132: if p_output_file_type ='HTML' then
3133: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3134: end if;
3135: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
3136:
3137: /**********************************************************
3138: ** Not Required as the output file type is HTML by default
3139: ***********************************************************/

Line 3152: -- hr_utility.trace_on('Y', 'EMPPDTL');

3148:
3149: END ;
3150:
3151: --BEGIN
3152: -- hr_utility.trace_on('Y', 'EMPPDTL');
3153: END pay_archiver_report_pkg;