eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_ARCHIVER_REPORT_PKG dependencies on HR_UTILITY

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

306: ,p_output_file_type => p_output_file_type)
307: ;
308:
309: p_emp_static_label := l_emp_detail_format;
310: hr_utility.set_location(gv_package_name||'.emp_detail_static_header',20);
311: END;
312:
313: PROCEDURE emp_sum_static_header(
314: p_output_file_type in varchar2

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

339: ,p_output_file_type => p_output_file_type)
340: ;
341:
342: p_emp_static_label := l_emp_sum_format;
343: hr_utility.set_location(gv_package_name||'.emp_sum_static_header',20);
344: END;
345:
346: PROCEDURE fed_static_header(
347: p_output_file_type in varchar2

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

350: IS
351: l_fed_format varchar2(32000);
352: BEGIN
353:
354: -- hr_utility.set_location(gv_package_name || '.fed_static_header', 10);
355: l_fed_format :=
356: data_string (p_input_string => 'GRE Name'
357: ,p_bold => 'Y'
358: ,p_output_file_type => p_output_file_type) ||

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

403: ,p_output_file_type => p_output_file_type)
404: ; /* Added for Bug#14793173 */
405:
406: p_fed_static_label := l_fed_format;
407: hr_utility.set_location(gv_package_name||'.fed_static_header',20);
408:
409: END;
410:
411: PROCEDURE state_static_header ( p_output_file_type in varchar2

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

412: ,p_state_static_label out nocopy varchar2)
413: IS
414: l_state_format varchar2(32000);
415: BEGIN
416: -- hr_utility.set_location(gv_package_name||'.state_static_header',10);
417:
418: l_state_format :=
419: data_string (p_input_string => 'GRE Name'
420: ,p_bold => 'Y'

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

472: ,p_output_file_type => p_output_file_type)
473: ;
474:
475: p_state_static_label := l_state_format;
476: hr_utility.set_location(gv_package_name||'.state_static_header',20);
477:
478: END;
479:
480: PROCEDURE county_static_header ( p_output_file_type in varchar2

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

481: ,p_county_static_label out nocopy varchar2)
482: IS
483: l_county_format varchar2(32000);
484: BEGIN
485: -- hr_utility.set_location(gv_package_name||'.county_static_header',10);
486:
487: l_county_format :=
488: data_string (p_input_string => 'GRE Name'
489: ,p_bold => 'Y'

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

511: ,p_output_file_type => p_output_file_type)
512: ;
513:
514: p_county_static_label := l_county_format;
515: --hr_utility.trace('Static County label = '||l_county_format);
516: hr_utility.set_location(gv_package_name||'.county_static_header',20);
517:
518: END;
519:

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

512: ;
513:
514: p_county_static_label := l_county_format;
515: --hr_utility.trace('Static County label = '||l_county_format);
516: hr_utility.set_location(gv_package_name||'.county_static_header',20);
517:
518: END;
519:
520: PROCEDURE city_static_header ( p_output_file_type in varchar2

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

521: ,p_city_static_label out nocopy varchar2)
522: IS
523: l_city_format varchar2(32000);
524: BEGIN
525: -- hr_utility.set_location(gv_package_name||'.city_static_header',10);
526:
527: l_city_format :=
528: data_string (p_input_string => 'GRE Name'
529: ,p_bold => 'Y'

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

551: ,p_output_file_type => p_output_file_type)
552: ;
553:
554: p_city_static_label := l_city_format;
555: --hr_utility.trace('Static City label = '||l_city_format);
556: hr_utility.set_location(gv_package_name||'.city_static_header',20);
557: END;
558:
559: PROCEDURE school_static_header ( p_output_file_type in varchar2

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

552: ;
553:
554: p_city_static_label := l_city_format;
555: --hr_utility.trace('Static City label = '||l_city_format);
556: hr_utility.set_location(gv_package_name||'.city_static_header',20);
557: END;
558:
559: PROCEDURE school_static_header ( p_output_file_type in varchar2
560: ,p_school_static_label out nocopy varchar2)

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

560: ,p_school_static_label out nocopy varchar2)
561: IS
562: l_school_format varchar2(32000);
563: BEGIN
564: -- hr_utility.set_location(gv_package_name||'.school_static_header',10);
565:
566: l_school_format :=
567: data_string (p_input_string => 'GRE Name'
568: ,p_bold => 'Y'

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

584: ,p_output_file_type => p_output_file_type)
585: ;
586:
587: p_school_static_label := l_school_format;
588: --hr_utility.trace('Static school label = '||l_school_format);
589: hr_utility.set_location(gv_package_name||'.school_static_header',20);
590: END;
591:
592: --#11927527 added start

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

585: ;
586:
587: p_school_static_label := l_school_format;
588: --hr_utility.trace('Static school label = '||l_school_format);
589: hr_utility.set_location(gv_package_name||'.school_static_header',20);
590: END;
591:
592: --#11927527 added start
593: PROCEDURE psd_static_header ( p_output_file_type in varchar2

Line 599: hr_utility.set_location(gv_package_name||'.psd_static_header',10);

595: ,p_psd_static_label out nocopy varchar2)
596: IS
597: l_psd_format varchar2(32000);
598: BEGIN
599: hr_utility.set_location(gv_package_name||'.psd_static_header',10);
600:
601: l_psd_format :=
602: data_string (p_input_string => 'GRE Name'
603: ,p_bold => 'Y'

Line 621: hr_utility.set_location(gv_package_name||'.psd_static_header',20);

617: data_string (p_input_string => 'School PSD Withheld'
618: ,p_bold => 'Y'
619: ,p_output_file_type => p_output_file_type);
620: IF p_detail_level = '01' THEN
621: hr_utility.set_location(gv_package_name||'.psd_static_header',20);
622: l_psd_format := l_psd_format ||
623: data_string (p_input_string => 'Resident(RS) or Work(WK)'
624: ,p_bold => 'Y'
625: ,p_output_file_type => p_output_file_type);

Line 629: --hr_utility.trace('Static PSD label = '||l_psd_format);

625: ,p_output_file_type => p_output_file_type);
626: END IF;
627:
628: p_psd_static_label := l_psd_format;
629: --hr_utility.trace('Static PSD label = '||l_psd_format);
630: hr_utility.set_location(gv_package_name||'.psd_static_header',30);
631: END;
632: --#11927527 added end
633: /******* Done with creating Static Header *****/

Line 630: hr_utility.set_location(gv_package_name||'.psd_static_header',30);

626: END IF;
627:
628: p_psd_static_label := l_psd_format;
629: --hr_utility.trace('Static PSD label = '||l_psd_format);
630: hr_utility.set_location(gv_package_name||'.psd_static_header',30);
631: END;
632: --#11927527 added end
633: /******* Done with creating Static Header *****/
634:

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

660: l_emp_static_data VARCHAR2(32000);
661:
662: BEGIN
663:
664: hr_utility.set_location(gv_package_name || '.emp_static_data', 10);
665: l_emp_static_data :=
666: data_string (p_input_string => p_last_name
667: ,p_output_file_type => p_output_file_type) ||
668: data_string (p_input_string => p_first_name

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

700: ;
701:
702: p_employee_data := l_emp_static_data;
703:
704: --hr_utility.trace('Employee Header = '||l_emp_static_data);
705: hr_utility.set_location(gv_package_name || '.emp_static_data', 20);
706: END;
707:
708: PROCEDURE emp_sum_static_data (

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

701:
702: p_employee_data := l_emp_static_data;
703:
704: --hr_utility.trace('Employee Header = '||l_emp_static_data);
705: hr_utility.set_location(gv_package_name || '.emp_static_data', 20);
706: END;
707:
708: PROCEDURE emp_sum_static_data (
709: p_last_name in varchar2

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

720: l_emp_sum_static_data VARCHAR2(32000);
721:
722: BEGIN
723:
724: hr_utility.set_location(gv_package_name || '.emp_static_data', 10);
725: l_emp_sum_static_data :=
726: data_string (p_input_string => p_last_name
727: ,p_output_file_type => p_output_file_type) ||
728: data_string (p_input_string => p_first_name

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

738: ;
739:
740: p_employee_data := l_emp_sum_static_data;
741:
742: --hr_utility.trace('Employee Header = '||l_emp_static_data);
743: hr_utility.set_location(gv_package_name || '.emp_static_data', 20);
744: END;
745:
746: PROCEDURE fed_static_data (

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

739:
740: p_employee_data := l_emp_sum_static_data;
741:
742: --hr_utility.trace('Employee Header = '||l_emp_static_data);
743: hr_utility.set_location(gv_package_name || '.emp_static_data', 20);
744: END;
745:
746: PROCEDURE fed_static_data (
747: p_gre_name in varchar2

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

766: IS
767: l_fed_static_data varchar2(32000);
768:
769: BEGIN
770: --hr_utility.set_location(gv_package_name || '.fit_static_data', 10);
771: l_fed_static_data :=
772: data_string (p_input_string => p_gre_name
773: ,p_output_file_type => p_output_file_type) ||
774: data_string (p_input_string => p_fit_gross

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

819: ; /* Added for Bug#14793173 */
820:
821:
822: p_federal_data := l_fed_static_data;
823: -- hr_utility.trace('Federal Data = '||p_federal_data);
824: hr_utility.set_location(gv_package_name || '.fit_static_data', 20);
825: END;
826:
827: PROCEDURE state_static_data(

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

820:
821:
822: p_federal_data := l_fed_static_data;
823: -- hr_utility.trace('Federal Data = '||p_federal_data);
824: hr_utility.set_location(gv_package_name || '.fit_static_data', 20);
825: END;
826:
827: PROCEDURE state_static_data(
828: p_gre_name in varchar2

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

849: IS
850: l_state_static_data varchar2(32000);
851:
852: BEGIN
853: --hr_utility.set_location(gv_package_name || '.state_static_data', 10);
854: l_state_static_data :=
855: data_string (p_input_string => p_gre_name
856: ,p_output_file_type => p_output_file_type) ||
857: data_string (p_input_string => p_state_ein

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

905: ;
906:
907: p_state_data := l_state_static_data;
908:
909: -- hr_utility.trace('State data = '||p_state_data);
910: hr_utility.set_location(gv_package_name || '.state__static_data', 20);
911: END;
912:
913:

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

906:
907: p_state_data := l_state_static_data;
908:
909: -- hr_utility.trace('State data = '||p_state_data);
910: hr_utility.set_location(gv_package_name || '.state__static_data', 20);
911: END;
912:
913:
914: PROCEDURE county_static_data(

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

926: IS
927: l_county_static_data varchar2(32000);
928:
929: BEGIN
930: -- hr_utility.set_location(gv_package_name || '.county_static_data', 10);
931: l_county_static_data :=
932: data_string (p_input_string => p_gre_name
933: ,p_output_file_type => p_output_file_type) ||
934: data_string (p_input_string => p_jurisdiction

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

950: data_string (p_input_string => p_non_resident_flag
951: ,p_output_file_type => p_output_file_type)
952: ;
953: p_county_data := l_county_static_data;
954: -- hr_utility.trace('County data = '||p_county_data);
955: hr_utility.set_location(gv_package_name || '.county_static_data', 20);
956: END;
957:
958:

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

951: ,p_output_file_type => p_output_file_type)
952: ;
953: p_county_data := l_county_static_data;
954: -- hr_utility.trace('County data = '||p_county_data);
955: hr_utility.set_location(gv_package_name || '.county_static_data', 20);
956: END;
957:
958:
959: PROCEDURE city_static_data(

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

970: )
971: IS
972: l_city_static_data varchar2(32000);
973: BEGIN
974: --hr_utility.set_location(gv_package_name || '.city_static_data', 10);
975: l_city_static_data :=
976: data_string (p_input_string => p_gre_name
977: ,p_output_file_type => p_output_file_type) ||
978: data_string (p_input_string => p_jurisdiction

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

995: ,p_output_file_type => p_output_file_type)
996: ;
997:
998: p_city_data := l_city_static_data;
999: -- hr_utility.trace('City data = '||p_city_data);
1000: hr_utility.set_location(gv_package_name || '.city_static_data', 20);
1001: END;
1002:
1003: PROCEDURE school_static_data(

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

996: ;
997:
998: p_city_data := l_city_static_data;
999: -- hr_utility.trace('City data = '||p_city_data);
1000: hr_utility.set_location(gv_package_name || '.city_static_data', 20);
1001: END;
1002:
1003: PROCEDURE school_static_data(
1004: p_gre_name in varchar2

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

1013: IS
1014: l_school_static_data varchar2(32000);
1015:
1016: BEGIN
1017: -- hr_utility.set_location(gv_package_name || '.school_static_data', 10);
1018: l_school_static_data :=
1019: data_string (p_input_string => p_gre_name
1020: ,p_output_file_type => p_output_file_type) ||
1021: data_string (p_input_string => p_jurisdiction

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

1033: ,p_output_file_type => p_output_file_type)
1034: ;
1035:
1036: p_school_data := l_school_static_data;
1037: -- hr_utility.trace('School data = '||p_school_data);
1038: hr_utility.set_location(gv_package_name || '.school_static_data', 20);
1039: END;
1040:
1041: --#11927527 psd static data added start

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

1034: ;
1035:
1036: p_school_data := l_school_static_data;
1037: -- hr_utility.trace('School data = '||p_school_data);
1038: hr_utility.set_location(gv_package_name || '.school_static_data', 20);
1039: END;
1040:
1041: --#11927527 psd static data added start
1042: PROCEDURE psd_static_data(

Line 1058: hr_utility.set_location(gv_package_name || '.psd_static_data', 10);

1054: )
1055: IS
1056: l_psd_static_data varchar2(32000);
1057: BEGIN
1058: hr_utility.set_location(gv_package_name || '.psd_static_data', 10);
1059:
1060: l_psd_static_data :=
1061: data_string (p_input_string => p_gre_name
1062: ,p_output_file_type => p_output_file_type) ||

Line 1078: hr_utility.set_location(gv_package_name || '.psd_static_data', 20);

1074: data_string (p_input_string => p_school_psd_withheld
1075: ,p_format => 'Y'
1076: ,p_output_file_type => p_output_file_type);
1077: IF p_detail_level = '01' THEN --detail
1078: hr_utility.set_location(gv_package_name || '.psd_static_data', 20);
1079: l_psd_static_data := l_psd_static_data ||
1080: data_string (p_input_string => p_non_resident_flag
1081: ,p_output_file_type => p_output_file_type);
1082: END IF;

Line 1085: -- hr_utility.trace('PSD data = '||p_psd_data);

1081: ,p_output_file_type => p_output_file_type);
1082: END IF;
1083:
1084: p_psd_data := l_psd_static_data;
1085: -- hr_utility.trace('PSD data = '||p_psd_data);
1086: hr_utility.set_location(gv_package_name || '.psd_static_data', 30);
1087: END;
1088:
1089: --#11927527 added end

Line 1086: hr_utility.set_location(gv_package_name || '.psd_static_data', 30);

1082: END IF;
1083:
1084: p_psd_data := l_psd_static_data;
1085: -- hr_utility.trace('PSD data = '||p_psd_data);
1086: hr_utility.set_location(gv_package_name || '.psd_static_data', 30);
1087: END;
1088:
1089: --#11927527 added end
1090:

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

1679: school_bal school_tab;
1680: psd_bal psd_tab; ---#11927527 psd bal
1681:
1682: BEGIN
1683: hr_utility.set_location(gv_package_name || '.archiver_extract', 10);
1684: ld_beginning_date := fnd_date.canonical_to_date(p_beginning_date);
1685: ld_end_date := fnd_date.canonical_to_date(p_end_date);
1686:
1687: /* Create Headers for each column */

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

1694: city_static_header(p_output_file_type, lv_city_header);
1695: school_static_header(p_output_file_type, lv_school_header);
1696: psd_static_header(p_output_file_type, p_detail_level, lv_psd_header); --#11927527
1697:
1698: hr_utility.trace('----------Done with Static Header Lables ------------');
1699:
1700: IF p_detail_level = '01' THEN
1701: if p_jurisdiction_level = '01' -- Federal
1702: then

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

1752: ,p_output_file_type));
1753: --#11927527 start
1754: END IF;
1755:
1756: hr_utility.set_location(gv_package_name || '.archiver_extract', 70);
1757:
1758: /* write the title of the report based on the output file type */
1759:
1760: /* #11927527 Commented to change the title according to Detailed Level

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

1761: fnd_file.put_line(fnd_file.output,
1762: title_string( gv_title
1763: ,p_output_file_type)); */
1764:
1765: hr_utility.set_location(gv_package_name || '.archiver_extract', 90);
1766: /****************************************************************
1767: ** Print the Header Information. If the format is HTML then open
1768: ** the body and table before printing the header info, otherwise
1769: ** just print the header information.

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

1767: ** Print the Header Information. If the format is HTML then open
1768: ** the body and table before printing the header info, otherwise
1769: ** just print the header information.
1770: ****************************************************************/
1771: hr_utility.trace('Output File Type = '||p_output_file_type);
1772:
1773: if p_output_file_type ='HTML' then
1774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
Line 1785: hr_utility.set_location(gv_package_name || '.archiver_extract', 100);

1781: if p_output_file_type ='HTML' then
1782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1783: end if;
1784:
1785: hr_utility.set_location(gv_package_name || '.archiver_extract', 100);
1786:
1787: /*****************************************************
1788: ** Start of the Data Section of the Report
1789: *****************************************************/

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

1786:
1787: /*****************************************************
1788: ** Start of the Data Section of the Report
1789: *****************************************************/
1790: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1791: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1792: hr_utility.trace('Ending Date = '||ld_end_date);
1793: hr_utility.trace('Payroll id = '||p_payroll_id);
1794: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);

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

1787: /*****************************************************
1788: ** Start of the Data Section of the Report
1789: *****************************************************/
1790: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1791: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1792: hr_utility.trace('Ending Date = '||ld_end_date);
1793: hr_utility.trace('Payroll id = '||p_payroll_id);
1794: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1795: hr_utility.trace('Organization id = '||p_organization_id);

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

1788: ** Start of the Data Section of the Report
1789: *****************************************************/
1790: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1791: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1792: hr_utility.trace('Ending Date = '||ld_end_date);
1793: hr_utility.trace('Payroll id = '||p_payroll_id);
1794: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1795: hr_utility.trace('Organization id = '||p_organization_id);
1796: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);

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

1789: *****************************************************/
1790: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1791: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1792: hr_utility.trace('Ending Date = '||ld_end_date);
1793: hr_utility.trace('Payroll id = '||p_payroll_id);
1794: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1795: hr_utility.trace('Organization id = '||p_organization_id);
1796: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1797: hr_utility.trace('Location id = '||p_location_id);

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

1790: hr_utility.trace('Assignment Set ID = ' || p_assignment_set_id);
1791: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1792: hr_utility.trace('Ending Date = '||ld_end_date);
1793: hr_utility.trace('Payroll id = '||p_payroll_id);
1794: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1795: hr_utility.trace('Organization id = '||p_organization_id);
1796: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1797: hr_utility.trace('Location id = '||p_location_id);
1798: hr_utility.trace('Business Group id = '||p_business_group_id);

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

1791: hr_utility.trace('Beginning Date = '||ld_beginning_date);
1792: hr_utility.trace('Ending Date = '||ld_end_date);
1793: hr_utility.trace('Payroll id = '||p_payroll_id);
1794: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1795: hr_utility.trace('Organization id = '||p_organization_id);
1796: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1797: hr_utility.trace('Location id = '||p_location_id);
1798: hr_utility.trace('Business Group id = '||p_business_group_id);
1799: hr_utility.trace('State Id = '||p_state_id);

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

1792: hr_utility.trace('Ending Date = '||ld_end_date);
1793: hr_utility.trace('Payroll id = '||p_payroll_id);
1794: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1795: hr_utility.trace('Organization id = '||p_organization_id);
1796: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1797: hr_utility.trace('Location id = '||p_location_id);
1798: hr_utility.trace('Business Group id = '||p_business_group_id);
1799: hr_utility.trace('State Id = '||p_state_id);
1800: hr_utility.trace('County Id = '||p_county_id);

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

1793: hr_utility.trace('Payroll id = '||p_payroll_id);
1794: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1795: hr_utility.trace('Organization id = '||p_organization_id);
1796: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1797: hr_utility.trace('Location id = '||p_location_id);
1798: hr_utility.trace('Business Group id = '||p_business_group_id);
1799: hr_utility.trace('State Id = '||p_state_id);
1800: hr_utility.trace('County Id = '||p_county_id);
1801: hr_utility.trace('City Id = '||p_city_id);

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

1794: hr_utility.trace('Consolidation Set id = '||p_consolidation_set_id);
1795: hr_utility.trace('Organization id = '||p_organization_id);
1796: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1797: hr_utility.trace('Location id = '||p_location_id);
1798: hr_utility.trace('Business Group id = '||p_business_group_id);
1799: hr_utility.trace('State Id = '||p_state_id);
1800: hr_utility.trace('County Id = '||p_county_id);
1801: hr_utility.trace('City Id = '||p_city_id);
1802: hr_utility.trace('School Id = '||p_school_id);

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

1795: hr_utility.trace('Organization id = '||p_organization_id);
1796: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1797: hr_utility.trace('Location id = '||p_location_id);
1798: hr_utility.trace('Business Group id = '||p_business_group_id);
1799: hr_utility.trace('State Id = '||p_state_id);
1800: hr_utility.trace('County Id = '||p_county_id);
1801: hr_utility.trace('City Id = '||p_city_id);
1802: hr_utility.trace('School Id = '||p_school_id);
1803:

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

1796: hr_utility.trace('Tax Unit Id = '||p_tax_unit_id);
1797: hr_utility.trace('Location id = '||p_location_id);
1798: hr_utility.trace('Business Group id = '||p_business_group_id);
1799: hr_utility.trace('State Id = '||p_state_id);
1800: hr_utility.trace('County Id = '||p_county_id);
1801: hr_utility.trace('City Id = '||p_city_id);
1802: hr_utility.trace('School Id = '||p_school_id);
1803:
1804: ln_prev_person := -1;

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

1797: hr_utility.trace('Location id = '||p_location_id);
1798: hr_utility.trace('Business Group id = '||p_business_group_id);
1799: hr_utility.trace('State Id = '||p_state_id);
1800: hr_utility.trace('County Id = '||p_county_id);
1801: hr_utility.trace('City Id = '||p_city_id);
1802: hr_utility.trace('School Id = '||p_school_id);
1803:
1804: ln_prev_person := -1;
1805: ln_prev_gre := -1;

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

1798: hr_utility.trace('Business Group id = '||p_business_group_id);
1799: hr_utility.trace('State Id = '||p_state_id);
1800: hr_utility.trace('County Id = '||p_county_id);
1801: hr_utility.trace('City Id = '||p_city_id);
1802: hr_utility.trace('School Id = '||p_school_id);
1803:
1804: ln_prev_person := -1;
1805: ln_prev_gre := -1;
1806: /*

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

1814: ,p_business_group_id);
1815:
1816: LOOP
1817: fetch c_employee_count into ln_person_id, lv_last_name, ln_action_number;
1818: hr_utility.trace('ln_person_id = '||ln_person_id);
1819: hr_utility.trace('lv_last_name = '||lv_last_name);
1820: hr_utility.trace('ln_action_number = '||ln_action_number);
1821: exit when c_employee_count%NOTFOUND;
1822: END LOOP;

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

1815:
1816: LOOP
1817: fetch c_employee_count into ln_person_id, lv_last_name, ln_action_number;
1818: hr_utility.trace('ln_person_id = '||ln_person_id);
1819: hr_utility.trace('lv_last_name = '||lv_last_name);
1820: hr_utility.trace('ln_action_number = '||ln_action_number);
1821: exit when c_employee_count%NOTFOUND;
1822: END LOOP;
1823: close c_employee_count;

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

1816: LOOP
1817: fetch c_employee_count into ln_person_id, lv_last_name, ln_action_number;
1818: hr_utility.trace('ln_person_id = '||ln_person_id);
1819: hr_utility.trace('lv_last_name = '||lv_last_name);
1820: hr_utility.trace('ln_action_number = '||ln_action_number);
1821: exit when c_employee_count%NOTFOUND;
1822: END LOOP;
1823: close c_employee_count;
1824: */

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

1855: lv_action_type,
1856: ln_person_id,
1857: ld_effective_date;
1858: EXIT WHEN c_employee%NOTFOUND;
1859: hr_utility.trace('-----------------------------------------------');
1860: hr_utility.trace('C_EMPLOYEE CURSOR');
1861: hr_utility.trace('ln_action_number = '||ln_action_number);
1862: hr_utility.trace('lv_last_name = '||lv_last_name);
1863: hr_utility.trace('ln_person_id = '||ln_person_id);

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

1856: ln_person_id,
1857: ld_effective_date;
1858: EXIT WHEN c_employee%NOTFOUND;
1859: hr_utility.trace('-----------------------------------------------');
1860: hr_utility.trace('C_EMPLOYEE CURSOR');
1861: hr_utility.trace('ln_action_number = '||ln_action_number);
1862: hr_utility.trace('lv_last_name = '||lv_last_name);
1863: hr_utility.trace('ln_person_id = '||ln_person_id);
1864: hr_utility.trace('-----------------------------------------------');

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

1857: ld_effective_date;
1858: EXIT WHEN c_employee%NOTFOUND;
1859: hr_utility.trace('-----------------------------------------------');
1860: hr_utility.trace('C_EMPLOYEE CURSOR');
1861: hr_utility.trace('ln_action_number = '||ln_action_number);
1862: hr_utility.trace('lv_last_name = '||lv_last_name);
1863: hr_utility.trace('ln_person_id = '||ln_person_id);
1864: hr_utility.trace('-----------------------------------------------');
1865:

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

1858: EXIT WHEN c_employee%NOTFOUND;
1859: hr_utility.trace('-----------------------------------------------');
1860: hr_utility.trace('C_EMPLOYEE CURSOR');
1861: hr_utility.trace('ln_action_number = '||ln_action_number);
1862: hr_utility.trace('lv_last_name = '||lv_last_name);
1863: hr_utility.trace('ln_person_id = '||ln_person_id);
1864: hr_utility.trace('-----------------------------------------------');
1865:
1866: if ln_prev_person = -1 then

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

1859: hr_utility.trace('-----------------------------------------------');
1860: hr_utility.trace('C_EMPLOYEE CURSOR');
1861: hr_utility.trace('ln_action_number = '||ln_action_number);
1862: hr_utility.trace('lv_last_name = '||lv_last_name);
1863: hr_utility.trace('ln_person_id = '||ln_person_id);
1864: hr_utility.trace('-----------------------------------------------');
1865:
1866: if ln_prev_person = -1 then
1867: ln_prev_person := ln_person_id;

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

1860: hr_utility.trace('C_EMPLOYEE CURSOR');
1861: hr_utility.trace('ln_action_number = '||ln_action_number);
1862: hr_utility.trace('lv_last_name = '||lv_last_name);
1863: hr_utility.trace('ln_person_id = '||ln_person_id);
1864: hr_utility.trace('-----------------------------------------------');
1865:
1866: if ln_prev_person = -1 then
1867: ln_prev_person := ln_person_id;
1868: end if;

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

1870: ln_prev_gre := ln_tax_unit_id;
1871: end if;
1872:
1873: if c_employee%notfound then
1874: hr_utility.trace('EMPLOYEE NOT FOUND');
1875: hr_utility.set_location(gv_package_name || '.archiver_extract', 105);
1876: exit;
1877: else
1878: hr_utility.trace('EMPLOYEE FOUND');

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

1871: end if;
1872:
1873: if c_employee%notfound then
1874: hr_utility.trace('EMPLOYEE NOT FOUND');
1875: hr_utility.set_location(gv_package_name || '.archiver_extract', 105);
1876: exit;
1877: else
1878: hr_utility.trace('EMPLOYEE FOUND');
1879: -- hr_utility.trace('Employee action_number = '||ln_action_number);

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

1874: hr_utility.trace('EMPLOYEE NOT FOUND');
1875: hr_utility.set_location(gv_package_name || '.archiver_extract', 105);
1876: exit;
1877: else
1878: hr_utility.trace('EMPLOYEE FOUND');
1879: -- hr_utility.trace('Employee action_number = '||ln_action_number);
1880: -- hr_utility.trace('Employee Last Name = '||lv_last_name);
1881: -- hr_utility.trace('Employee First Name = '||lv_first_name);
1882: end if;

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

1875: hr_utility.set_location(gv_package_name || '.archiver_extract', 105);
1876: exit;
1877: else
1878: hr_utility.trace('EMPLOYEE FOUND');
1879: -- hr_utility.trace('Employee action_number = '||ln_action_number);
1880: -- hr_utility.trace('Employee Last Name = '||lv_last_name);
1881: -- hr_utility.trace('Employee First Name = '||lv_first_name);
1882: end if;
1883:

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

1876: exit;
1877: else
1878: hr_utility.trace('EMPLOYEE FOUND');
1879: -- hr_utility.trace('Employee action_number = '||ln_action_number);
1880: -- hr_utility.trace('Employee Last Name = '||lv_last_name);
1881: -- hr_utility.trace('Employee First Name = '||lv_first_name);
1882: end if;
1883:
1884: /*----------------------------------------------------------

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

1877: else
1878: hr_utility.trace('EMPLOYEE FOUND');
1879: -- hr_utility.trace('Employee action_number = '||ln_action_number);
1880: -- hr_utility.trace('Employee Last Name = '||lv_last_name);
1881: -- hr_utility.trace('Employee First Name = '||lv_first_name);
1882: end if;
1883:
1884: /*----------------------------------------------------------
1885: -- If Assignment Set is used, pick up only those employee

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

1884: /*----------------------------------------------------------
1885: -- If Assignment Set is used, pick up only those employee
1886: -- assignments which are part of the Assignment Set
1887: -----------------------------------------------------------*/
1888: hr_utility.set_location(gv_package_name || '.archiver_extract', 110);
1889:
1890: if hr_assignment_set.assignment_in_set(p_assignment_set_id
1891: ,ln_assignment_id) = 'Y' then
1892:

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

1889:
1890: if hr_assignment_set.assignment_in_set(p_assignment_set_id
1891: ,ln_assignment_id) = 'Y' then
1892:
1893: hr_utility.set_location(gv_package_name || '.archiver_extract', 120);
1894:
1895: /************************************/
1896: /*** FEDERAL balances ***/
1897: /************************************/

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

1917: ln_eic_advance,
1918: ln_medicare_ee_taxable_ovr_lmt; /* Added for Bug#14793173 */
1919: EXIT WHEN c_federal_balances%NOTFOUND;
1920:
1921: hr_utility.trace('Fetched FEDERAL balance ---------------');
1922: hr_utility.trace('Detail Level in FED = '||p_detail_level);
1923: hr_utility.trace('ln_action_number = '||ln_action_number);
1924: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1925: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);

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

1918: ln_medicare_ee_taxable_ovr_lmt; /* Added for Bug#14793173 */
1919: EXIT WHEN c_federal_balances%NOTFOUND;
1920:
1921: hr_utility.trace('Fetched FEDERAL balance ---------------');
1922: hr_utility.trace('Detail Level in FED = '||p_detail_level);
1923: hr_utility.trace('ln_action_number = '||ln_action_number);
1924: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1925: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1926:

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

1919: EXIT WHEN c_federal_balances%NOTFOUND;
1920:
1921: hr_utility.trace('Fetched FEDERAL balance ---------------');
1922: hr_utility.trace('Detail Level in FED = '||p_detail_level);
1923: hr_utility.trace('ln_action_number = '||ln_action_number);
1924: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1925: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1926:
1927: /*Added for Bug#9872952*/

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

1920:
1921: hr_utility.trace('Fetched FEDERAL balance ---------------');
1922: hr_utility.trace('Detail Level in FED = '||p_detail_level);
1923: hr_utility.trace('ln_action_number = '||ln_action_number);
1924: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1925: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1926:
1927: /*Added for Bug#9872952*/
1928: ln_profile_value := fnd_profile.value('PAY_DIRECT_US_FEDERAL_BALANCES');

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

1921: hr_utility.trace('Fetched FEDERAL balance ---------------');
1922: hr_utility.trace('Detail Level in FED = '||p_detail_level);
1923: hr_utility.trace('ln_action_number = '||ln_action_number);
1924: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1925: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1926:
1927: /*Added for Bug#9872952*/
1928: ln_profile_value := fnd_profile.value('PAY_DIRECT_US_FEDERAL_BALANCES');
1929:

Line 1944: hr_utility.trace('After correction for Wage Accumulation Exemption:');

1940:
1941: IF ln_wage_exempt = 'Y' THEN
1942: ln_fit_gross := 0;
1943: ln_fit_reduced_subject := 0;
1944: hr_utility.trace('After correction for Wage Accumulation Exemption:');
1945: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1946: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1947: END IF;
1948:

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

1941: IF ln_wage_exempt = 'Y' THEN
1942: ln_fit_gross := 0;
1943: ln_fit_reduced_subject := 0;
1944: hr_utility.trace('After correction for Wage Accumulation Exemption:');
1945: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1946: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1947: END IF;
1948:
1949: CLOSE c_federal_wage_exemption;

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

1942: ln_fit_gross := 0;
1943: ln_fit_reduced_subject := 0;
1944: hr_utility.trace('After correction for Wage Accumulation Exemption:');
1945: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
1946: hr_utility.trace('ln_fit_withheld = '||ln_fit_withheld);
1947: END IF;
1948:
1949: CLOSE c_federal_wage_exemption;
1950:

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

1995: nvl(ln_medicare_ee_taxable_ovr_lmt,0),
1996: p_output_file_type,
1997: lv_federal_data); /* Added for Bug#14793173 */
1998: lv_data_row := lv_data_row||lv_federal_data;
1999: --hr_utility.trace('FED static data = '||lv_federal_data);
2000: --hr_utility.trace('Data Row = '||lv_data_row);
2001:
2002: if p_output_file_type = 'HTML' then
2003: lv_data_row := '
'||lv_data_row||'';
Line 2000: --hr_utility.trace('Data Row = '||lv_data_row);

1996: p_output_file_type,
1997: lv_federal_data); /* Added for Bug#14793173 */
1998: lv_data_row := lv_data_row||lv_federal_data;
1999: --hr_utility.trace('FED static data = '||lv_federal_data);
2000: --hr_utility.trace('Data Row = '||lv_data_row);
2001:
2002: if p_output_file_type = 'HTML' then
2003: lv_data_row := '
'||lv_data_row||'';
2004: end if;
Line 2013: hr_utility.trace('------------------------------------------');

2009:
2010: /******* Federal Summary Level ********/
2011:
2012: IF p_detail_level = '02' THEN
2013: hr_utility.trace('------------------------------------------');
2014: hr_utility.trace('Federal by summary.......................');
2015: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2016: hr_utility.trace('ln_person_id = '||ln_person_id);
2017:

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

2010: /******* Federal Summary Level ********/
2011:
2012: IF p_detail_level = '02' THEN
2013: hr_utility.trace('------------------------------------------');
2014: hr_utility.trace('Federal by summary.......................');
2015: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2016: hr_utility.trace('ln_person_id = '||ln_person_id);
2017:
2018: IF ln_prev_person = ln_person_id then

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

2011:
2012: IF p_detail_level = '02' THEN
2013: hr_utility.trace('------------------------------------------');
2014: hr_utility.trace('Federal by summary.......................');
2015: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2016: hr_utility.trace('ln_person_id = '||ln_person_id);
2017:
2018: IF ln_prev_person = ln_person_id then
2019: emp_sum_static_data( lv_last_name,

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

2012: IF p_detail_level = '02' THEN
2013: hr_utility.trace('------------------------------------------');
2014: hr_utility.trace('Federal by summary.......................');
2015: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2016: hr_utility.trace('ln_person_id = '||ln_person_id);
2017:
2018: IF ln_prev_person = ln_person_id then
2019: emp_sum_static_data( lv_last_name,
2020: lv_first_name,

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

2028: lv_data_row := lv_employee_data;
2029:
2030: lv_found := 'N';
2031:
2032: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
2033: hr_utility.trace('ln_fit_gross_sum BEFORE adding = '||
2034: ln_fit_gross_sum);
2035: hr_utility.trace('ln_prev_gre = '||ln_prev_gre);
2036: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);

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

2029:
2030: lv_found := 'N';
2031:
2032: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
2033: hr_utility.trace('ln_fit_gross_sum BEFORE adding = '||
2034: ln_fit_gross_sum);
2035: hr_utility.trace('ln_prev_gre = '||ln_prev_gre);
2036: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
2037:

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

2031:
2032: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
2033: hr_utility.trace('ln_fit_gross_sum BEFORE adding = '||
2034: ln_fit_gross_sum);
2035: hr_utility.trace('ln_prev_gre = '||ln_prev_gre);
2036: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
2037:
2038: IF federal_bal.count > 0 THEN
2039: FOR k in federal_bal.first..federal_bal.last LOOP

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

2032: hr_utility.trace('ln_fit_gross = '||ln_fit_gross);
2033: hr_utility.trace('ln_fit_gross_sum BEFORE adding = '||
2034: ln_fit_gross_sum);
2035: hr_utility.trace('ln_prev_gre = '||ln_prev_gre);
2036: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
2037:
2038: IF federal_bal.count > 0 THEN
2039: FOR k in federal_bal.first..federal_bal.last LOOP
2040: IF federal_bal(k).tax_unit_id = ln_tax_unit_id THEN

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

2116: federal_bal(1).medicare_ee_taxable_ovr_lmt := nvl(ln_medicare_ee_taxable_ovr_lmt,0); /* Added for Bug#14793173 */
2117: END IF; /* federal_bal.count check */
2118:
2119: ELSE /* New person fetched */
2120: hr_utility.trace('Inside FED ELSE...........');
2121: hr_utility.trace('New Person fetched ..........');
2122:
2123: lv_prev_emp_data_row := lv_data_row;
2124: IF federal_bal.count>0 THEN

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

2117: END IF; /* federal_bal.count check */
2118:
2119: ELSE /* New person fetched */
2120: hr_utility.trace('Inside FED ELSE...........');
2121: hr_utility.trace('New Person fetched ..........');
2122:
2123: lv_prev_emp_data_row := lv_data_row;
2124: IF federal_bal.count>0 THEN
2125: FOR k in federal_bal.first..federal_bal.last LOOP

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

2164: ln_prev_person := ln_person_id;
2165:
2166: /******* rest sum to currently fetched person *****/
2167:
2168: hr_utility.trace('resetting summary for Federal ...........');
2169: IF federal_bal.count > 0 THEN
2170: FOR k in federal_bal.first..federal_bal.last LOOP
2171: federal_bal(k).tax_unit_id := -1;
2172: federal_bal(k).gre_name := '';

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

2219: /*** STATE balances ***/
2220: /****************************************/
2221:
2222: IF p_jurisdiction_level = '02' THEN
2223: hr_utility.trace('-------------------------------------');
2224: hr_utility.trace('.......... In STATE..................');
2225: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
2226: hr_utility.trace('p_state_id = '||p_state_id);
2227: hr_utility.trace('ln_action_number = '||ln_action_number);

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

2220: /****************************************/
2221:
2222: IF p_jurisdiction_level = '02' THEN
2223: hr_utility.trace('-------------------------------------');
2224: hr_utility.trace('.......... In STATE..................');
2225: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
2226: hr_utility.trace('p_state_id = '||p_state_id);
2227: hr_utility.trace('ln_action_number = '||ln_action_number);
2228: hr_utility.trace('-------------------------------------');

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

2221:
2222: IF p_jurisdiction_level = '02' THEN
2223: hr_utility.trace('-------------------------------------');
2224: hr_utility.trace('.......... In STATE..................');
2225: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
2226: hr_utility.trace('p_state_id = '||p_state_id);
2227: hr_utility.trace('ln_action_number = '||ln_action_number);
2228: hr_utility.trace('-------------------------------------');
2229:

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

2222: IF p_jurisdiction_level = '02' THEN
2223: hr_utility.trace('-------------------------------------');
2224: hr_utility.trace('.......... In STATE..................');
2225: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
2226: hr_utility.trace('p_state_id = '||p_state_id);
2227: hr_utility.trace('ln_action_number = '||ln_action_number);
2228: hr_utility.trace('-------------------------------------');
2229:
2230: open c_state_balances(ln_action_number,

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

2223: hr_utility.trace('-------------------------------------');
2224: hr_utility.trace('.......... In STATE..................');
2225: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
2226: hr_utility.trace('p_state_id = '||p_state_id);
2227: hr_utility.trace('ln_action_number = '||ln_action_number);
2228: hr_utility.trace('-------------------------------------');
2229:
2230: open c_state_balances(ln_action_number,
2231: p_state_id);

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

2224: hr_utility.trace('.......... In STATE..................');
2225: hr_utility.trace('ln_tax_unit_id = '||ln_tax_unit_id);
2226: hr_utility.trace('p_state_id = '||p_state_id);
2227: hr_utility.trace('ln_action_number = '||ln_action_number);
2228: hr_utility.trace('-------------------------------------');
2229:
2230: open c_state_balances(ln_action_number,
2231: p_state_id);
2232: hr_utility.trace('State first cursor OPEN ');

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

2228: hr_utility.trace('-------------------------------------');
2229:
2230: open c_state_balances(ln_action_number,
2231: p_state_id);
2232: hr_utility.trace('State first cursor OPEN ');
2233:
2234: LOOP
2235:
2236: hr_utility.trace('Fetching STATE balance ...............');

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

2232: hr_utility.trace('State first cursor OPEN ');
2233:
2234: LOOP
2235:
2236: hr_utility.trace('Fetching STATE balance ...............');
2237:
2238: fetch c_state_balances into lv_jurisdiction,
2239: lv_jurisdiction_name,
2240: ln_sit_gross,

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

2256:
2257: lv_state_ein := f_state_ein(ln_tax_unit_id,
2258: substr(lv_jurisdiction,1,2));
2259:
2260: hr_utility.trace('----------------------------------------');
2261: hr_utility.trace('Fetched STATE record...............');
2262: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);
2263: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);
2264: hr_utility.trace('----------------------------------------');

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

2257: lv_state_ein := f_state_ein(ln_tax_unit_id,
2258: substr(lv_jurisdiction,1,2));
2259:
2260: hr_utility.trace('----------------------------------------');
2261: hr_utility.trace('Fetched STATE record...............');
2262: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);
2263: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);
2264: hr_utility.trace('----------------------------------------');
2265:

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

2258: substr(lv_jurisdiction,1,2));
2259:
2260: hr_utility.trace('----------------------------------------');
2261: hr_utility.trace('Fetched STATE record...............');
2262: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);
2263: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);
2264: hr_utility.trace('----------------------------------------');
2265:
2266: /******* State Balance By Run *****/

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

2259:
2260: hr_utility.trace('----------------------------------------');
2261: hr_utility.trace('Fetched STATE record...............');
2262: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);
2263: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);
2264: hr_utility.trace('----------------------------------------');
2265:
2266: /******* State Balance By Run *****/
2267:

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

2260: hr_utility.trace('----------------------------------------');
2261: hr_utility.trace('Fetched STATE record...............');
2262: hr_utility.trace('ln_sit_gross = '||ln_sit_gross);
2263: hr_utility.trace('ln_sit_withheld = '||ln_sit_withheld);
2264: hr_utility.trace('----------------------------------------');
2265:
2266: /******* State Balance By Run *****/
2267:
2268: IF p_detail_level = '01' THEN

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

2266: /******* State Balance By Run *****/
2267:
2268: IF p_detail_level = '01' THEN
2269:
2270: hr_utility.trace('----------------------------------------');
2271: hr_utility.trace('State by run out put....................');
2272: hr_utility.trace('ln_action_number = '||ln_action_number);
2273: hr_utility.trace('----------------------------------------');
2274:

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

2267:
2268: IF p_detail_level = '01' THEN
2269:
2270: hr_utility.trace('----------------------------------------');
2271: hr_utility.trace('State by run out put....................');
2272: hr_utility.trace('ln_action_number = '||ln_action_number);
2273: hr_utility.trace('----------------------------------------');
2274:
2275: emp_static_data(

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

2268: IF p_detail_level = '01' THEN
2269:
2270: hr_utility.trace('----------------------------------------');
2271: hr_utility.trace('State by run out put....................');
2272: hr_utility.trace('ln_action_number = '||ln_action_number);
2273: hr_utility.trace('----------------------------------------');
2274:
2275: emp_static_data(
2276: lv_last_name,

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

2269:
2270: hr_utility.trace('----------------------------------------');
2271: hr_utility.trace('State by run out put....................');
2272: hr_utility.trace('ln_action_number = '||ln_action_number);
2273: hr_utility.trace('----------------------------------------');
2274:
2275: emp_static_data(
2276: lv_last_name,
2277: lv_first_name,

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

2325:
2326:
2327: /********* State Balance by Summary(by jurisdiction level) *****/
2328:
2329: hr_utility.trace('---------State by Summary --------------');
2330: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2331: hr_utility.trace('ln_person_id = '||ln_person_id);
2332: hr_utility.trace('----------------------------------------');
2333:

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

2326:
2327: /********* State Balance by Summary(by jurisdiction level) *****/
2328:
2329: hr_utility.trace('---------State by Summary --------------');
2330: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2331: hr_utility.trace('ln_person_id = '||ln_person_id);
2332: hr_utility.trace('----------------------------------------');
2333:
2334: IF p_detail_level = '02' then

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

2327: /********* State Balance by Summary(by jurisdiction level) *****/
2328:
2329: hr_utility.trace('---------State by Summary --------------');
2330: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2331: hr_utility.trace('ln_person_id = '||ln_person_id);
2332: hr_utility.trace('----------------------------------------');
2333:
2334: IF p_detail_level = '02' then
2335:

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

2328:
2329: hr_utility.trace('---------State by Summary --------------');
2330: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2331: hr_utility.trace('ln_person_id = '||ln_person_id);
2332: hr_utility.trace('----------------------------------------');
2333:
2334: IF p_detail_level = '02' then
2335:
2336: IF ln_prev_person = ln_person_id Then

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

2349: ELSE
2350: lv_state_id := p_state_id;
2351: END IF;
2352:
2353: hr_utility.trace('lv_state_id = '||lv_state_id);
2354:
2355: lv_found := 'N';
2356: hr_utility.trace('state_bal.count = '||state_bal.count);
2357: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);

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

2352:
2353: hr_utility.trace('lv_state_id = '||lv_state_id);
2354:
2355: lv_found := 'N';
2356: hr_utility.trace('state_bal.count = '||state_bal.count);
2357: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2358: IF state_bal.count > 0 THEN
2359: FOR k in state_bal.first..state_bal.last LOOP
2360: IF (state_bal(k).jurisdiction_code = lv_jurisdiction

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

2353: hr_utility.trace('lv_state_id = '||lv_state_id);
2354:
2355: lv_found := 'N';
2356: hr_utility.trace('state_bal.count = '||state_bal.count);
2357: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2358: IF state_bal.count > 0 THEN
2359: FOR k in state_bal.first..state_bal.last LOOP
2360: IF (state_bal(k).jurisdiction_code = lv_jurisdiction
2361: AND

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

2397: state_bal(k).sdi1_ee_withheld ;
2398:
2399: END IF;
2400: END LOOP;
2401: hr_utility.trace('end of Loop');
2402: hr_utility.trace('lv_found := '||lv_found);
2403: IF lv_found = 'N' THEN
2404: ln_next_tab := state_bal.count + 1;
2405: state_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;

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

2398:
2399: END IF;
2400: END LOOP;
2401: hr_utility.trace('end of Loop');
2402: hr_utility.trace('lv_found := '||lv_found);
2403: IF lv_found = 'N' THEN
2404: ln_next_tab := state_bal.count + 1;
2405: state_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;
2406: state_bal(ln_next_tab).gre_name := lv_gre_name;

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

2437: nvl(ln_sdi1_ee_withheld,0) ;
2438: END IF;
2439:
2440: ELSE /* state_bal.count = 0, first fetch **/
2441: hr_utility.trace('STATE first fetch .................');
2442: state_bal(1).tax_unit_id := ln_tax_unit_id;
2443: state_bal(1).gre_name := lv_gre_name;
2444: state_bal(1).state_ein := lv_state_ein;
2445: state_bal(1).jurisdiction_code := lv_jurisdiction;

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

2461: nvl(ln_workers_comp2_withheld,0);
2462: state_bal(1).sdi1_ee_withheld := nvl(ln_sdi1_ee_withheld,0) ;
2463: END IF;
2464: ELSE /** New Person Fetched, write out prev person **/
2465: hr_utility.trace('.....State ELSE New Person Fetched .......');
2466: hr_utility.trace('Write out the previous person.............');
2467:
2468: lv_prev_emp_data_row := lv_data_row;
2469:

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

2462: state_bal(1).sdi1_ee_withheld := nvl(ln_sdi1_ee_withheld,0) ;
2463: END IF;
2464: ELSE /** New Person Fetched, write out prev person **/
2465: hr_utility.trace('.....State ELSE New Person Fetched .......');
2466: hr_utility.trace('Write out the previous person.............');
2467:
2468: lv_prev_emp_data_row := lv_data_row;
2469:
2470: IF state_bal.count > 0 THEN

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

2497: end if;
2498: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2499: END LOOP;
2500: END IF; /* state_bal.count */
2501: hr_utility.trace('Before building new emp header');
2502:
2503: /** Now, build employee static header with the new
2504: fetched record **/
2505:

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

2516: ln_prev_person := ln_person_id;
2517:
2518: /******** reset Sum to currently fetched record *******/
2519:
2520: hr_utility.trace('Resetting Summary for State .............');
2521: IF state_bal.count > 0 THEN
2522: FOR i in state_bal.first..state_bal.last LOOP
2523: state_bal(i).tax_unit_id := -1;
2524: state_bal(i).gre_name := null;

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

2564: state_bal(1).workers_comp2_withheld:=
2565: nvl(ln_workers_comp2_withheld,0);
2566: state_bal(1).sdi1_ee_withheld := nvl(ln_sdi1_ee_withheld,0) ;
2567:
2568: hr_utility.trace('New state summary for '||
2569: ln_person_id|| ' sit_gross = '||
2570: state_bal(1).sit_gross);
2571: END IF; /* Person Check */
2572: END IF; /* detail level check */

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

2580: /******************************************/
2581:
2582: IF p_jurisdiction_level = '03' THEN
2583:
2584: hr_utility.trace('----------------------------------------');
2585: hr_utility.trace('.............In COUNTY..................');
2586: hr_utility.trace('p_state_id = '||p_state_id);
2587: hr_utility.trace('p_county_id = '||p_county_id);
2588: hr_utility.trace('ln_action_number = '||ln_action_number);

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

2581:
2582: IF p_jurisdiction_level = '03' THEN
2583:
2584: hr_utility.trace('----------------------------------------');
2585: hr_utility.trace('.............In COUNTY..................');
2586: hr_utility.trace('p_state_id = '||p_state_id);
2587: hr_utility.trace('p_county_id = '||p_county_id);
2588: hr_utility.trace('ln_action_number = '||ln_action_number);
2589: hr_utility.trace('jurisdiction = '||p_state_id||'-'||

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

2582: IF p_jurisdiction_level = '03' THEN
2583:
2584: hr_utility.trace('----------------------------------------');
2585: hr_utility.trace('.............In COUNTY..................');
2586: hr_utility.trace('p_state_id = '||p_state_id);
2587: hr_utility.trace('p_county_id = '||p_county_id);
2588: hr_utility.trace('ln_action_number = '||ln_action_number);
2589: hr_utility.trace('jurisdiction = '||p_state_id||'-'||
2590: nvl(p_county_id,'%')||'-0000');

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

2583:
2584: hr_utility.trace('----------------------------------------');
2585: hr_utility.trace('.............In COUNTY..................');
2586: hr_utility.trace('p_state_id = '||p_state_id);
2587: hr_utility.trace('p_county_id = '||p_county_id);
2588: hr_utility.trace('ln_action_number = '||ln_action_number);
2589: hr_utility.trace('jurisdiction = '||p_state_id||'-'||
2590: nvl(p_county_id,'%')||'-0000');
2591: hr_utility.trace('----------------------------------------');

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

2584: hr_utility.trace('----------------------------------------');
2585: hr_utility.trace('.............In COUNTY..................');
2586: hr_utility.trace('p_state_id = '||p_state_id);
2587: hr_utility.trace('p_county_id = '||p_county_id);
2588: hr_utility.trace('ln_action_number = '||ln_action_number);
2589: hr_utility.trace('jurisdiction = '||p_state_id||'-'||
2590: nvl(p_county_id,'%')||'-0000');
2591: hr_utility.trace('----------------------------------------');
2592:

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

2585: hr_utility.trace('.............In COUNTY..................');
2586: hr_utility.trace('p_state_id = '||p_state_id);
2587: hr_utility.trace('p_county_id = '||p_county_id);
2588: hr_utility.trace('ln_action_number = '||ln_action_number);
2589: hr_utility.trace('jurisdiction = '||p_state_id||'-'||
2590: nvl(p_county_id,'%')||'-0000');
2591: hr_utility.trace('----------------------------------------');
2592:
2593: OPEN c_county_balances(ln_action_number, p_state_id, p_county_id);

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

2587: hr_utility.trace('p_county_id = '||p_county_id);
2588: hr_utility.trace('ln_action_number = '||ln_action_number);
2589: hr_utility.trace('jurisdiction = '||p_state_id||'-'||
2590: nvl(p_county_id,'%')||'-0000');
2591: hr_utility.trace('----------------------------------------');
2592:
2593: OPEN c_county_balances(ln_action_number, p_state_id, p_county_id);
2594: LOOP
2595: hr_utility.trace('Fetching COUNTY records .................');

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

2591: hr_utility.trace('----------------------------------------');
2592:
2593: OPEN c_county_balances(ln_action_number, p_state_id, p_county_id);
2594: LOOP
2595: hr_utility.trace('Fetching COUNTY records .................');
2596: fetch c_county_balances into lv_jurisdiction,
2597: lv_jurisdiction_name,
2598: ln_county_gross,
2599: ln_county_reduced_subject,

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

2602: lv_non_resident_flag;
2603:
2604: EXIT WHEN c_county_balances%NOTFOUND;
2605:
2606: hr_utility.trace('Fetched records are .................');
2607: hr_utility.trace(' ');
2608: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2609: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2610: hr_utility.trace('ln_county_gross = '||ln_county_gross);

Line 2607: hr_utility.trace(' ');

2603:
2604: EXIT WHEN c_county_balances%NOTFOUND;
2605:
2606: hr_utility.trace('Fetched records are .................');
2607: hr_utility.trace(' ');
2608: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2609: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2610: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2611: hr_utility.trace('ln_county_reduced_subject = '||

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

2604: EXIT WHEN c_county_balances%NOTFOUND;
2605:
2606: hr_utility.trace('Fetched records are .................');
2607: hr_utility.trace(' ');
2608: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2609: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2610: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2611: hr_utility.trace('ln_county_reduced_subject = '||
2612: ln_county_reduced_subject);

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

2605:
2606: hr_utility.trace('Fetched records are .................');
2607: hr_utility.trace(' ');
2608: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2609: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2610: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2611: hr_utility.trace('ln_county_reduced_subject = '||
2612: ln_county_reduced_subject);
2613: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);

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

2606: hr_utility.trace('Fetched records are .................');
2607: hr_utility.trace(' ');
2608: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2609: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2610: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2611: hr_utility.trace('ln_county_reduced_subject = '||
2612: ln_county_reduced_subject);
2613: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);
2614: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);

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

2607: hr_utility.trace(' ');
2608: hr_utility.trace('lv_jurisdiction = '||lv_jurisdiction);
2609: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2610: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2611: hr_utility.trace('ln_county_reduced_subject = '||
2612: ln_county_reduced_subject);
2613: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);
2614: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2615: hr_utility.trace('----------------------------------------');

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

2609: hr_utility.trace('lv_jurisdiction_name = '||lv_jurisdiction_name);
2610: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2611: hr_utility.trace('ln_county_reduced_subject = '||
2612: ln_county_reduced_subject);
2613: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);
2614: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2615: hr_utility.trace('----------------------------------------');
2616:
2617: /******** County Balances by run *******/

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

2610: hr_utility.trace('ln_county_gross = '||ln_county_gross);
2611: hr_utility.trace('ln_county_reduced_subject = '||
2612: ln_county_reduced_subject);
2613: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);
2614: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2615: hr_utility.trace('----------------------------------------');
2616:
2617: /******** County Balances by run *******/
2618:

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

2611: hr_utility.trace('ln_county_reduced_subject = '||
2612: ln_county_reduced_subject);
2613: hr_utility.trace('ln_county_withheld = '||ln_county_withheld);
2614: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2615: hr_utility.trace('----------------------------------------');
2616:
2617: /******** County Balances by run *******/
2618:
2619: IF p_detail_level = '01' THEN

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

2617: /******** County Balances by run *******/
2618:
2619: IF p_detail_level = '01' THEN
2620:
2621: hr_utility.trace('----------------------------------------');
2622: hr_utility.trace('County by run output....................');
2623: hr_utility.trace('ln_action_number = '||ln_action_number);
2624: hr_utility.trace('----------------------------------------');
2625:

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

2618:
2619: IF p_detail_level = '01' THEN
2620:
2621: hr_utility.trace('----------------------------------------');
2622: hr_utility.trace('County by run output....................');
2623: hr_utility.trace('ln_action_number = '||ln_action_number);
2624: hr_utility.trace('----------------------------------------');
2625:
2626: emp_static_data(

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

2619: IF p_detail_level = '01' THEN
2620:
2621: hr_utility.trace('----------------------------------------');
2622: hr_utility.trace('County by run output....................');
2623: hr_utility.trace('ln_action_number = '||ln_action_number);
2624: hr_utility.trace('----------------------------------------');
2625:
2626: emp_static_data(
2627: lv_last_name,

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

2620:
2621: hr_utility.trace('----------------------------------------');
2622: hr_utility.trace('County by run output....................');
2623: hr_utility.trace('ln_action_number = '||ln_action_number);
2624: hr_utility.trace('----------------------------------------');
2625:
2626: emp_static_data(
2627: lv_last_name,
2628: lv_first_name,

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

2668: /******* County Balances by Summary (by Jurisdiction) ******/
2669:
2670: IF p_detail_level = '02' THEN
2671:
2672: hr_utility.trace('----------------------------------------');
2673: hr_utility.trace('County by Summary....................');
2674: hr_utility.trace('ln_action_number = '||ln_action_number);
2675: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2676: hr_utility.trace('ln_person_id = '||ln_person_id);

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

2669:
2670: IF p_detail_level = '02' THEN
2671:
2672: hr_utility.trace('----------------------------------------');
2673: hr_utility.trace('County by Summary....................');
2674: hr_utility.trace('ln_action_number = '||ln_action_number);
2675: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2676: hr_utility.trace('ln_person_id = '||ln_person_id);
2677: hr_utility.trace('----------------------------------------');

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

2670: IF p_detail_level = '02' THEN
2671:
2672: hr_utility.trace('----------------------------------------');
2673: hr_utility.trace('County by Summary....................');
2674: hr_utility.trace('ln_action_number = '||ln_action_number);
2675: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2676: hr_utility.trace('ln_person_id = '||ln_person_id);
2677: hr_utility.trace('----------------------------------------');
2678:

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

2671:
2672: hr_utility.trace('----------------------------------------');
2673: hr_utility.trace('County by Summary....................');
2674: hr_utility.trace('ln_action_number = '||ln_action_number);
2675: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2676: hr_utility.trace('ln_person_id = '||ln_person_id);
2677: hr_utility.trace('----------------------------------------');
2678:
2679: IF ln_prev_person = ln_person_id THEN

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

2672: hr_utility.trace('----------------------------------------');
2673: hr_utility.trace('County by Summary....................');
2674: hr_utility.trace('ln_action_number = '||ln_action_number);
2675: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2676: hr_utility.trace('ln_person_id = '||ln_person_id);
2677: hr_utility.trace('----------------------------------------');
2678:
2679: IF ln_prev_person = ln_person_id THEN
2680: emp_sum_static_data( lv_last_name,

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

2673: hr_utility.trace('County by Summary....................');
2674: hr_utility.trace('ln_action_number = '||ln_action_number);
2675: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2676: hr_utility.trace('ln_person_id = '||ln_person_id);
2677: hr_utility.trace('----------------------------------------');
2678:
2679: IF ln_prev_person = ln_person_id THEN
2680: emp_sum_static_data( lv_last_name,
2681: lv_first_name,

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

2692: ELSE
2693: lv_county_id := p_county_id;
2694: END IF;
2695:
2696: hr_utility.trace('p_state_id = '||p_state_id);
2697: hr_utility.trace('lv_county_id = '||lv_county_id);
2698: hr_utility.trace('county_bal.count = '||county_bal.count);
2699:
2700: lv_found := 'N';

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

2693: lv_county_id := p_county_id;
2694: END IF;
2695:
2696: hr_utility.trace('p_state_id = '||p_state_id);
2697: hr_utility.trace('lv_county_id = '||lv_county_id);
2698: hr_utility.trace('county_bal.count = '||county_bal.count);
2699:
2700: lv_found := 'N';
2701:

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

2694: END IF;
2695:
2696: hr_utility.trace('p_state_id = '||p_state_id);
2697: hr_utility.trace('lv_county_id = '||lv_county_id);
2698: hr_utility.trace('county_bal.count = '||county_bal.count);
2699:
2700: lv_found := 'N';
2701:
2702: IF county_bal.count > 0 THEN

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

2716: nvl(ln_head_tax_withheld,0) +
2717: county_bal(k).county_head_tax_withheld;
2718: END IF;
2719: END LOOP;
2720: hr_utility.trace('lv_found := '||lv_found);
2721: IF lv_found = 'N' THEN
2722: ln_next_tab := county_bal.count +1;
2723: county_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;
2724: county_bal(ln_next_tab).gre_name := lv_gre_name;

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

2737: END IF;
2738:
2739:
2740: ELSE /** county_bal = 0, first fetch **/
2741: hr_utility.trace('COUNTY first fetch ..........');
2742: county_bal(1).tax_unit_id := ln_tax_unit_id;
2743: county_bal(1).gre_name := lv_gre_name;
2744: county_bal(1).jurisdiction_code :=
2745: lv_jurisdiction;

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

2756:
2757: END IF;
2758:
2759: ELSE /** New Person Fetched, write out prev person **/
2760: hr_utility.trace('.......County ELSE New Person Fetched .......');
2761: hr_utility.trace('Write out the previous person................');
2762:
2763: lv_prev_emp_data_row := lv_data_row;
2764:

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

2757: END IF;
2758:
2759: ELSE /** New Person Fetched, write out prev person **/
2760: hr_utility.trace('.......County ELSE New Person Fetched .......');
2761: hr_utility.trace('Write out the previous person................');
2762:
2763: lv_prev_emp_data_row := lv_data_row;
2764:
2765: IF county_bal.count>0 THEN

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

2780: end if;
2781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
2782: END LOOP;
2783: END IF; --county_bal.count
2784: hr_utility.trace('End of printing COUNTY sum.....');
2785:
2786: /**** Now, build employee static header with the new fetched ***/
2787: /**** Person record ***/
2788:

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

2800: ln_prev_person := ln_person_id;
2801:
2802: /*** Reset sum to currently Fetched Record ***/
2803:
2804: hr_utility.trace('Resetting Summary for county................');
2805: IF county_bal.count > 0 THEN
2806: FOR k in county_bal.first..county_bal.last LOOP
2807: county_bal(k).tax_unit_id := -1;
2808: county_bal(k).gre_name := '';

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

2824: county_bal(1).county_reduced_subject := nvl(ln_county_reduced_subject,0);
2825: county_bal(1).county_withheld := nvl(ln_county_withheld,0);
2826: county_bal(1).county_head_tax_withheld := nvl(ln_head_tax_withheld,0);
2827:
2828: hr_utility.trace('New County summary for '||
2829: ln_person_id||' county_gross = '||
2830: county_bal(1).county_gross);
2831:
2832: END IF; /** Person Check **/

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

2841: /*************************************************/
2842:
2843: IF p_jurisdiction_level = '04' THEN
2844:
2845: hr_utility.trace('-----------------------------------------');
2846: hr_utility.trace('.........In CITY balances ...............');
2847: hr_utility.trace('ln_action_number = '||ln_action_number);
2848: hr_utility.trace('Jurisdiction Code = '||
2849: p_state_id||'-'||p_county_id||'-'||nvl(p_city_id,'%'));

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

2842:
2843: IF p_jurisdiction_level = '04' THEN
2844:
2845: hr_utility.trace('-----------------------------------------');
2846: hr_utility.trace('.........In CITY balances ...............');
2847: hr_utility.trace('ln_action_number = '||ln_action_number);
2848: hr_utility.trace('Jurisdiction Code = '||
2849: p_state_id||'-'||p_county_id||'-'||nvl(p_city_id,'%'));
2850: hr_utility.trace('-----------------------------------------');

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

2843: IF p_jurisdiction_level = '04' THEN
2844:
2845: hr_utility.trace('-----------------------------------------');
2846: hr_utility.trace('.........In CITY balances ...............');
2847: hr_utility.trace('ln_action_number = '||ln_action_number);
2848: hr_utility.trace('Jurisdiction Code = '||
2849: p_state_id||'-'||p_county_id||'-'||nvl(p_city_id,'%'));
2850: hr_utility.trace('-----------------------------------------');
2851:

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

2844:
2845: hr_utility.trace('-----------------------------------------');
2846: hr_utility.trace('.........In CITY balances ...............');
2847: hr_utility.trace('ln_action_number = '||ln_action_number);
2848: hr_utility.trace('Jurisdiction Code = '||
2849: p_state_id||'-'||p_county_id||'-'||nvl(p_city_id,'%'));
2850: hr_utility.trace('-----------------------------------------');
2851:
2852: open c_city_balances(ln_action_number,

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

2846: hr_utility.trace('.........In CITY balances ...............');
2847: hr_utility.trace('ln_action_number = '||ln_action_number);
2848: hr_utility.trace('Jurisdiction Code = '||
2849: p_state_id||'-'||p_county_id||'-'||nvl(p_city_id,'%'));
2850: hr_utility.trace('-----------------------------------------');
2851:
2852: open c_city_balances(ln_action_number,
2853: p_state_id,
2854: p_county_id,

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

2853: p_state_id,
2854: p_county_id,
2855: p_city_id);
2856: LOOP
2857: hr_utility.trace('Fetching CITY balance.............');
2858: fetch c_city_balances into lv_jurisdiction,
2859: lv_jurisdiction_name,
2860: ln_city_gross,
2861: ln_city_reduced_subject,

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

2864: lv_non_resident_flag;
2865:
2866: EXIT WHEN c_city_balances%NOTFOUND;
2867:
2868: hr_utility.trace('-----------------------------------------');
2869: hr_utility.trace('Fetched CITY balance.............');
2870: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2871: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2872: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);

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

2865:
2866: EXIT WHEN c_city_balances%NOTFOUND;
2867:
2868: hr_utility.trace('-----------------------------------------');
2869: hr_utility.trace('Fetched CITY balance.............');
2870: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2871: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2872: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2873: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);

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

2866: EXIT WHEN c_city_balances%NOTFOUND;
2867:
2868: hr_utility.trace('-----------------------------------------');
2869: hr_utility.trace('Fetched CITY balance.............');
2870: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2871: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2872: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2873: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2874: hr_utility.trace('-----------------------------------------');

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

2867:
2868: hr_utility.trace('-----------------------------------------');
2869: hr_utility.trace('Fetched CITY balance.............');
2870: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2871: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2872: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2873: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2874: hr_utility.trace('-----------------------------------------');
2875:

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

2868: hr_utility.trace('-----------------------------------------');
2869: hr_utility.trace('Fetched CITY balance.............');
2870: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2871: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2872: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2873: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2874: hr_utility.trace('-----------------------------------------');
2875:
2876: /****** City Balances By Run ********/

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

2869: hr_utility.trace('Fetched CITY balance.............');
2870: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2871: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2872: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2873: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2874: hr_utility.trace('-----------------------------------------');
2875:
2876: /****** City Balances By Run ********/
2877:

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

2870: hr_utility.trace('ln_city_gross = '||ln_city_gross);
2871: hr_utility.trace('ln_city_reduced_subject = '||ln_city_reduced_subject);
2872: hr_utility.trace('ln_city_withheld = '||ln_city_withheld);
2873: hr_utility.trace('ln_head_tax_withheld = '||ln_head_tax_withheld);
2874: hr_utility.trace('-----------------------------------------');
2875:
2876: /****** City Balances By Run ********/
2877:
2878: IF p_detail_level = '01' THEN

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

2876: /****** City Balances By Run ********/
2877:
2878: IF p_detail_level = '01' THEN
2879:
2880: hr_utility.trace('-----------------------------------------');
2881: hr_utility.trace('City by Run output.......................');
2882: hr_utility.trace('ln_action_number = '||ln_action_number);
2883: hr_utility.trace('-----------------------------------------');
2884:

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

2877:
2878: IF p_detail_level = '01' THEN
2879:
2880: hr_utility.trace('-----------------------------------------');
2881: hr_utility.trace('City by Run output.......................');
2882: hr_utility.trace('ln_action_number = '||ln_action_number);
2883: hr_utility.trace('-----------------------------------------');
2884:
2885: emp_static_data( lv_last_name,

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

2878: IF p_detail_level = '01' THEN
2879:
2880: hr_utility.trace('-----------------------------------------');
2881: hr_utility.trace('City by Run output.......................');
2882: hr_utility.trace('ln_action_number = '||ln_action_number);
2883: hr_utility.trace('-----------------------------------------');
2884:
2885: emp_static_data( lv_last_name,
2886: lv_first_name,

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

2879:
2880: hr_utility.trace('-----------------------------------------');
2881: hr_utility.trace('City by Run output.......................');
2882: hr_utility.trace('ln_action_number = '||ln_action_number);
2883: hr_utility.trace('-----------------------------------------');
2884:
2885: emp_static_data( lv_last_name,
2886: lv_first_name,
2887: lv_middle_name,

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

2926: /********* City Balances by Summary (by Jurisdiction) *******/
2927:
2928: IF p_detail_level = '02' THEN
2929:
2930: hr_utility.trace('----------------------------------------');
2931: hr_utility.trace('City by Summary....................');
2932: hr_utility.trace('ln_action_number = '||ln_action_number);
2933: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2934: hr_utility.trace('ln_person_id = '||ln_person_id);

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

2927:
2928: IF p_detail_level = '02' THEN
2929:
2930: hr_utility.trace('----------------------------------------');
2931: hr_utility.trace('City by Summary....................');
2932: hr_utility.trace('ln_action_number = '||ln_action_number);
2933: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2934: hr_utility.trace('ln_person_id = '||ln_person_id);
2935: hr_utility.trace('----------------------------------------');

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

2928: IF p_detail_level = '02' THEN
2929:
2930: hr_utility.trace('----------------------------------------');
2931: hr_utility.trace('City by Summary....................');
2932: hr_utility.trace('ln_action_number = '||ln_action_number);
2933: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2934: hr_utility.trace('ln_person_id = '||ln_person_id);
2935: hr_utility.trace('----------------------------------------');
2936:

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

2929:
2930: hr_utility.trace('----------------------------------------');
2931: hr_utility.trace('City by Summary....................');
2932: hr_utility.trace('ln_action_number = '||ln_action_number);
2933: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2934: hr_utility.trace('ln_person_id = '||ln_person_id);
2935: hr_utility.trace('----------------------------------------');
2936:
2937: IF ln_prev_person = ln_person_id THEN

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

2930: hr_utility.trace('----------------------------------------');
2931: hr_utility.trace('City by Summary....................');
2932: hr_utility.trace('ln_action_number = '||ln_action_number);
2933: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2934: hr_utility.trace('ln_person_id = '||ln_person_id);
2935: hr_utility.trace('----------------------------------------');
2936:
2937: IF ln_prev_person = ln_person_id THEN
2938: emp_sum_static_data( lv_last_name,

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

2931: hr_utility.trace('City by Summary....................');
2932: hr_utility.trace('ln_action_number = '||ln_action_number);
2933: hr_utility.trace('ln_prev_person = '||ln_prev_person);
2934: hr_utility.trace('ln_person_id = '||ln_person_id);
2935: hr_utility.trace('----------------------------------------');
2936:
2937: IF ln_prev_person = ln_person_id THEN
2938: emp_sum_static_data( lv_last_name,
2939: lv_first_name,

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

2950: lv_city_id := substr(lv_jurisdiction,8,4);
2951: ELSE
2952: lv_city_id := p_city_id;
2953: END IF;
2954: hr_utility.trace('city_bal.count = '||city_bal.count);
2955:
2956: lv_found := 'N';
2957: IF city_bal.count > 0 THEN
2958: FOR k in city_bal.first..city_bal.last LOOP

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

2971: nvl(ln_head_tax_withheld,0) +
2972: city_bal(k).head_tax_withheld;
2973: END IF;
2974: END LOOP;
2975: hr_utility.trace('lv_found := '||lv_found);
2976: IF lv_found = 'N' THEN
2977: ln_next_tab := city_bal.count +1;
2978: city_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;
2979: city_bal(ln_next_tab).gre_name := lv_gre_name;

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

2989: nvl(ln_head_tax_withheld,0);
2990: END IF;
2991:
2992: ELSE /** city_bal = 0, first fetch **/
2993: hr_utility.trace('CITY first fetch ..........');
2994: city_bal(1).tax_unit_id := ln_tax_unit_id;
2995: city_bal(1).gre_name := lv_gre_name;
2996: city_bal(1).jurisdiction_code := lv_jurisdiction;
2997: city_bal(1).jurisdiction_name := lv_jurisdiction_name;

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

3000: city_bal(1).city_withheld := nvl(ln_city_withheld,0);
3001: city_bal(1).head_tax_withheld := nvl(ln_head_tax_withheld,0);
3002: END IF;
3003: ELSE /*** New person fetched, write out prev person **/
3004: hr_utility.trace('.......City ELSE New Person Fetched .......');
3005: hr_utility.trace('Write out the previous person................');
3006:
3007: lv_prev_emp_data_row := lv_data_row;
3008:

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

3001: city_bal(1).head_tax_withheld := nvl(ln_head_tax_withheld,0);
3002: END IF;
3003: ELSE /*** New person fetched, write out prev person **/
3004: hr_utility.trace('.......City ELSE New Person Fetched .......');
3005: hr_utility.trace('Write out the previous person................');
3006:
3007: lv_prev_emp_data_row := lv_data_row;
3008:
3009: IF city_bal.count>0 THEN

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

3024: end if;
3025: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3026: END LOOP;
3027: END IF; -- city_bal.count
3028: hr_utility.trace('End of printing COUNTY sum.....');
3029:
3030: /**** Now, build employee static header with the new fetched ***/
3031: /**** Person record ***/
3032:

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

3043: ln_prev_person := ln_person_id;
3044:
3045: /*** Reset sum to currently Fetched Record ***/
3046:
3047: hr_utility.trace('Resetting Summary for city................');
3048: IF city_bal.count > 0 THEN
3049: FOR k in city_bal.first..city_bal.last LOOP
3050: city_bal(k).tax_unit_id := -1;
3051: city_bal(k).gre_name := '';

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

3067: city_bal(1).city_reduced_subject := nvl(ln_city_reduced_subject,0);
3068: city_bal(1).city_withheld := nvl(ln_city_withheld,0);
3069: city_bal(1).head_tax_withheld := nvl(ln_head_tax_withheld,0);
3070:
3071: hr_utility.trace('New City summary for '||
3072: ln_person_id||' city_gross = '||
3073: city_bal(1).city_gross);
3074:
3075: END IF; /** Person Check **/

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

3084: /*********************************************/
3085:
3086: IF p_jurisdiction_level = '05' THEN
3087:
3088: hr_utility.trace('-------------------------------------');
3089: hr_utility.trace('............In SCHOOL DIST...........');
3090: hr_utility.trace('p_city_id = '||p_city_id);
3091: hr_utility.trace('Jurisdiction Code = '||
3092: p_state_id||'-'||nvl(p_school_id,'%'));

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

3085:
3086: IF p_jurisdiction_level = '05' THEN
3087:
3088: hr_utility.trace('-------------------------------------');
3089: hr_utility.trace('............In SCHOOL DIST...........');
3090: hr_utility.trace('p_city_id = '||p_city_id);
3091: hr_utility.trace('Jurisdiction Code = '||
3092: p_state_id||'-'||nvl(p_school_id,'%'));
3093:

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

3086: IF p_jurisdiction_level = '05' THEN
3087:
3088: hr_utility.trace('-------------------------------------');
3089: hr_utility.trace('............In SCHOOL DIST...........');
3090: hr_utility.trace('p_city_id = '||p_city_id);
3091: hr_utility.trace('Jurisdiction Code = '||
3092: p_state_id||'-'||nvl(p_school_id,'%'));
3093:
3094: open c_school_balances(ln_action_number,

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

3087:
3088: hr_utility.trace('-------------------------------------');
3089: hr_utility.trace('............In SCHOOL DIST...........');
3090: hr_utility.trace('p_city_id = '||p_city_id);
3091: hr_utility.trace('Jurisdiction Code = '||
3092: p_state_id||'-'||nvl(p_school_id,'%'));
3093:
3094: open c_school_balances(ln_action_number,
3095: p_state_id,

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

3095: p_state_id,
3096: p_school_id);
3097: LOOP
3098:
3099: hr_utility.trace('Fetching SCHOOL balance ................');
3100: fetch c_school_balances into lv_jurisdiction,
3101: lv_jurisdiction_name,
3102: ln_school_gross,
3103: ln_school_reduced_subject,

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

3104: ln_school_withheld;
3105:
3106: EXIT WHEN c_school_balances%NOTFOUND;
3107:
3108: hr_utility.trace('Fetched SCHOOL balance.............');
3109: hr_utility.trace('----------------------------------------');
3110: hr_utility.trace('ln_school_gross = '||ln_school_gross);
3111: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);
3112: hr_utility.trace('----------------------------------------');

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

3105:
3106: EXIT WHEN c_school_balances%NOTFOUND;
3107:
3108: hr_utility.trace('Fetched SCHOOL balance.............');
3109: hr_utility.trace('----------------------------------------');
3110: hr_utility.trace('ln_school_gross = '||ln_school_gross);
3111: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);
3112: hr_utility.trace('----------------------------------------');
3113:

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

3106: EXIT WHEN c_school_balances%NOTFOUND;
3107:
3108: hr_utility.trace('Fetched SCHOOL balance.............');
3109: hr_utility.trace('----------------------------------------');
3110: hr_utility.trace('ln_school_gross = '||ln_school_gross);
3111: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);
3112: hr_utility.trace('----------------------------------------');
3113:
3114: /******* School Balance By Run *****/

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

3107:
3108: hr_utility.trace('Fetched SCHOOL balance.............');
3109: hr_utility.trace('----------------------------------------');
3110: hr_utility.trace('ln_school_gross = '||ln_school_gross);
3111: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);
3112: hr_utility.trace('----------------------------------------');
3113:
3114: /******* School Balance By Run *****/
3115:

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

3108: hr_utility.trace('Fetched SCHOOL balance.............');
3109: hr_utility.trace('----------------------------------------');
3110: hr_utility.trace('ln_school_gross = '||ln_school_gross);
3111: hr_utility.trace('ln_school_withheld = '||ln_school_withheld);
3112: hr_utility.trace('----------------------------------------');
3113:
3114: /******* School Balance By Run *****/
3115:
3116: IF p_detail_level = '01' THEN

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

3114: /******* School Balance By Run *****/
3115:
3116: IF p_detail_level = '01' THEN
3117:
3118: hr_utility.trace('-----------------------------------');
3119: hr_utility.trace('School Dist by Run output..........');
3120: hr_utility.trace('ln_action_number = '||ln_action_number);
3121: hr_utility.trace('-----------------------------------');
3122:

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

3115:
3116: IF p_detail_level = '01' THEN
3117:
3118: hr_utility.trace('-----------------------------------');
3119: hr_utility.trace('School Dist by Run output..........');
3120: hr_utility.trace('ln_action_number = '||ln_action_number);
3121: hr_utility.trace('-----------------------------------');
3122:
3123: emp_static_data( lv_last_name,

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

3116: IF p_detail_level = '01' THEN
3117:
3118: hr_utility.trace('-----------------------------------');
3119: hr_utility.trace('School Dist by Run output..........');
3120: hr_utility.trace('ln_action_number = '||ln_action_number);
3121: hr_utility.trace('-----------------------------------');
3122:
3123: emp_static_data( lv_last_name,
3124: lv_first_name,

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

3117:
3118: hr_utility.trace('-----------------------------------');
3119: hr_utility.trace('School Dist by Run output..........');
3120: hr_utility.trace('ln_action_number = '||ln_action_number);
3121: hr_utility.trace('-----------------------------------');
3122:
3123: emp_static_data( lv_last_name,
3124: lv_first_name,
3125: lv_middle_name,

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

3161:
3162: /***** School balance by Summary (by jurisdiction) *****/
3163:
3164: IF p_detail_level = '02' THEN
3165: hr_utility.trace('----------------------------------------');
3166: hr_utility.trace('City by Summary....................');
3167: hr_utility.trace('ln_action_number = '||ln_action_number);
3168: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3169: hr_utility.trace('ln_person_id = '||ln_person_id);

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

3162: /***** School balance by Summary (by jurisdiction) *****/
3163:
3164: IF p_detail_level = '02' THEN
3165: hr_utility.trace('----------------------------------------');
3166: hr_utility.trace('City by Summary....................');
3167: hr_utility.trace('ln_action_number = '||ln_action_number);
3168: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3169: hr_utility.trace('ln_person_id = '||ln_person_id);
3170: hr_utility.trace('----------------------------------------');

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

3163:
3164: IF p_detail_level = '02' THEN
3165: hr_utility.trace('----------------------------------------');
3166: hr_utility.trace('City by Summary....................');
3167: hr_utility.trace('ln_action_number = '||ln_action_number);
3168: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3169: hr_utility.trace('ln_person_id = '||ln_person_id);
3170: hr_utility.trace('----------------------------------------');
3171: IF ln_prev_person = ln_person_id THEN

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

3164: IF p_detail_level = '02' THEN
3165: hr_utility.trace('----------------------------------------');
3166: hr_utility.trace('City by Summary....................');
3167: hr_utility.trace('ln_action_number = '||ln_action_number);
3168: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3169: hr_utility.trace('ln_person_id = '||ln_person_id);
3170: hr_utility.trace('----------------------------------------');
3171: IF ln_prev_person = ln_person_id THEN
3172: emp_sum_static_data( lv_last_name,

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

3165: hr_utility.trace('----------------------------------------');
3166: hr_utility.trace('City by Summary....................');
3167: hr_utility.trace('ln_action_number = '||ln_action_number);
3168: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3169: hr_utility.trace('ln_person_id = '||ln_person_id);
3170: hr_utility.trace('----------------------------------------');
3171: IF ln_prev_person = ln_person_id THEN
3172: emp_sum_static_data( lv_last_name,
3173: lv_first_name,

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

3166: hr_utility.trace('City by Summary....................');
3167: hr_utility.trace('ln_action_number = '||ln_action_number);
3168: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3169: hr_utility.trace('ln_person_id = '||ln_person_id);
3170: hr_utility.trace('----------------------------------------');
3171: IF ln_prev_person = ln_person_id THEN
3172: emp_sum_static_data( lv_last_name,
3173: lv_first_name,
3174: lv_middle_name,

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

3178: p_output_file_type,
3179: lv_employee_data);
3180:
3181: lv_data_row := lv_employee_data;
3182: hr_utility.trace('p_state_id = '||p_state_id);
3183: hr_utility.trace('p_county_id = '||p_county_id);
3184: hr_utility.trace('p_city_id = '||p_city_id);
3185: hr_utility.trace('school_bal.count = '||school_bal.count);
3186:

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

3179: lv_employee_data);
3180:
3181: lv_data_row := lv_employee_data;
3182: hr_utility.trace('p_state_id = '||p_state_id);
3183: hr_utility.trace('p_county_id = '||p_county_id);
3184: hr_utility.trace('p_city_id = '||p_city_id);
3185: hr_utility.trace('school_bal.count = '||school_bal.count);
3186:
3187: lv_found := 'N';

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

3180:
3181: lv_data_row := lv_employee_data;
3182: hr_utility.trace('p_state_id = '||p_state_id);
3183: hr_utility.trace('p_county_id = '||p_county_id);
3184: hr_utility.trace('p_city_id = '||p_city_id);
3185: hr_utility.trace('school_bal.count = '||school_bal.count);
3186:
3187: lv_found := 'N';
3188: IF school_bal.count > 0 THEN

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

3181: lv_data_row := lv_employee_data;
3182: hr_utility.trace('p_state_id = '||p_state_id);
3183: hr_utility.trace('p_county_id = '||p_county_id);
3184: hr_utility.trace('p_city_id = '||p_city_id);
3185: hr_utility.trace('school_bal.count = '||school_bal.count);
3186:
3187: lv_found := 'N';
3188: IF school_bal.count > 0 THEN
3189: FOR k in school_bal.first..school_bal.last LOOP

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

3199: school_bal(k).school_withheld;
3200: END IF;
3201: END LOOP;
3202:
3203: hr_utility.trace('lv_found := '||lv_found);
3204: IF lv_found = 'N' THEN
3205: ln_next_tab := school_bal.count +1;
3206: school_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;
3207: school_bal(ln_next_tab).gre_name := lv_gre_name;

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

3214: school_bal(ln_next_tab).school_withheld := nvl(ln_school_withheld,0);
3215: END IF;
3216:
3217: ELSE /** city_bal = 0, first fetch **/
3218: hr_utility.trace('SCHOOL first fetch ..........');
3219: school_bal(1).tax_unit_id := ln_tax_unit_id;
3220: school_bal(1).gre_name := lv_gre_name;
3221: school_bal(1).jurisdiction_code := lv_jurisdiction;
3222: school_bal(1).jurisdiction_name := lv_jurisdiction_name;

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

3225: nvl(ln_school_reduced_subject,0);
3226: school_bal(1).school_withheld := nvl(ln_school_withheld,0);
3227: END IF;
3228: ELSE /*** New person fetched, write out prev person **/
3229: hr_utility.trace('.......School ELSE New Person Fetched .......');
3230: hr_utility.trace('Write out the previous person................');
3231:
3232: lv_prev_emp_data_row := lv_data_row;
3233:

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

3226: school_bal(1).school_withheld := nvl(ln_school_withheld,0);
3227: END IF;
3228: ELSE /*** New person fetched, write out prev person **/
3229: hr_utility.trace('.......School ELSE New Person Fetched .......');
3230: hr_utility.trace('Write out the previous person................');
3231:
3232: lv_prev_emp_data_row := lv_data_row;
3233:
3234: IF school_bal.count>0 THEN

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

3247: end if;
3248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3249: END LOOP;
3250: END IF; -- school_bal.count
3251: hr_utility.trace('End of printing SCHOOL sum.....');
3252: /**** Now, build employee static header with the new fetched ***/
3253: /**** Person record ***/
3254:
3255: emp_sum_static_data( lv_last_name,

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

3264: /* Set the prev person to this fetched person */
3265: ln_prev_person := ln_person_id;
3266: /*** Reset sum to currently Fetched Record ***/
3267:
3268: hr_utility.trace('Resetting Summary for school................');
3269: IF school_bal.count > 0 THEN
3270: FOR k in school_bal.first..school_bal.last LOOP
3271: school_bal(k).tax_unit_id := -1;
3272: school_bal(k).gre_name := '';

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

3286: school_bal(1).school_gross := nvl(ln_school_gross,0);
3287: school_bal(1).school_reduced_subject := nvl(ln_school_reduced_subject,0);
3288: school_bal(1).school_withheld := nvl(ln_school_withheld,0);
3289:
3290: hr_utility.trace('New School summary for '||
3291: ln_person_id||' school_withheld = '||
3292: school_bal(1).school_withheld);
3293:
3294: END IF; /** Person Check **/

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

3303: /*********************************************/
3304:
3305: IF p_jurisdiction_level = '06' THEN
3306:
3307: hr_utility.trace('-------------------------------------');
3308: hr_utility.trace('............In PSD DIST...........');
3309: hr_utility.trace('p_psd_id = '||p_PSD_id);
3310: hr_utility.trace('Jurisdiction Code = '||
3311: p_state_id||'-'||nvl(p_PSD_id,'%'));

Line 3308: hr_utility.trace('............In PSD DIST...........');

3304:
3305: IF p_jurisdiction_level = '06' THEN
3306:
3307: hr_utility.trace('-------------------------------------');
3308: hr_utility.trace('............In PSD DIST...........');
3309: hr_utility.trace('p_psd_id = '||p_PSD_id);
3310: hr_utility.trace('Jurisdiction Code = '||
3311: p_state_id||'-'||nvl(p_PSD_id,'%'));
3312:

Line 3309: hr_utility.trace('p_psd_id = '||p_PSD_id);

3305: IF p_jurisdiction_level = '06' THEN
3306:
3307: hr_utility.trace('-------------------------------------');
3308: hr_utility.trace('............In PSD DIST...........');
3309: hr_utility.trace('p_psd_id = '||p_PSD_id);
3310: hr_utility.trace('Jurisdiction Code = '||
3311: p_state_id||'-'||nvl(p_PSD_id,'%'));
3312:
3313: open c_PSD_balances(ln_action_number,

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

3306:
3307: hr_utility.trace('-------------------------------------');
3308: hr_utility.trace('............In PSD DIST...........');
3309: hr_utility.trace('p_psd_id = '||p_PSD_id);
3310: hr_utility.trace('Jurisdiction Code = '||
3311: p_state_id||'-'||nvl(p_PSD_id,'%'));
3312:
3313: open c_PSD_balances(ln_action_number,
3314: nvl(p_state_id,'39'),--test

Line 3318: hr_utility.trace('Fetching PSD balance ................');

3314: nvl(p_state_id,'39'),--test
3315: p_PSD_id);
3316: LOOP
3317:
3318: hr_utility.trace('Fetching PSD balance ................');
3319: fetch c_PSD_balances into lv_jurisdiction,
3320: ln_psd_withheld,
3321: ln_psd_subject,
3322: ln_city_psd_withheld,

Line 3329: hr_utility.trace('Fetched PSD balance.............');

3325: lv_non_resident_flag;
3326:
3327: EXIT WHEN c_PSD_balances%NOTFOUND;
3328:
3329: hr_utility.trace('Fetched PSD balance.............');
3330: hr_utility.trace('----------------------------------------');
3331: hr_utility.trace('ln_PSD_gross = '||ln_psd_subject);
3332: hr_utility.trace('ln_PSD_withheld = '||ln_PSD_withheld);
3333: hr_utility.trace('lv_non_resident_flag = '||lv_non_resident_flag);

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

3326:
3327: EXIT WHEN c_PSD_balances%NOTFOUND;
3328:
3329: hr_utility.trace('Fetched PSD balance.............');
3330: hr_utility.trace('----------------------------------------');
3331: hr_utility.trace('ln_PSD_gross = '||ln_psd_subject);
3332: hr_utility.trace('ln_PSD_withheld = '||ln_PSD_withheld);
3333: hr_utility.trace('lv_non_resident_flag = '||lv_non_resident_flag);
3334: hr_utility.trace('----------------------------------------');

Line 3331: hr_utility.trace('ln_PSD_gross = '||ln_psd_subject);

3327: EXIT WHEN c_PSD_balances%NOTFOUND;
3328:
3329: hr_utility.trace('Fetched PSD balance.............');
3330: hr_utility.trace('----------------------------------------');
3331: hr_utility.trace('ln_PSD_gross = '||ln_psd_subject);
3332: hr_utility.trace('ln_PSD_withheld = '||ln_PSD_withheld);
3333: hr_utility.trace('lv_non_resident_flag = '||lv_non_resident_flag);
3334: hr_utility.trace('----------------------------------------');
3335:

Line 3332: hr_utility.trace('ln_PSD_withheld = '||ln_PSD_withheld);

3328:
3329: hr_utility.trace('Fetched PSD balance.............');
3330: hr_utility.trace('----------------------------------------');
3331: hr_utility.trace('ln_PSD_gross = '||ln_psd_subject);
3332: hr_utility.trace('ln_PSD_withheld = '||ln_PSD_withheld);
3333: hr_utility.trace('lv_non_resident_flag = '||lv_non_resident_flag);
3334: hr_utility.trace('----------------------------------------');
3335:
3336: /******* PSD Balance By Run *****/

Line 3333: hr_utility.trace('lv_non_resident_flag = '||lv_non_resident_flag);

3329: hr_utility.trace('Fetched PSD balance.............');
3330: hr_utility.trace('----------------------------------------');
3331: hr_utility.trace('ln_PSD_gross = '||ln_psd_subject);
3332: hr_utility.trace('ln_PSD_withheld = '||ln_PSD_withheld);
3333: hr_utility.trace('lv_non_resident_flag = '||lv_non_resident_flag);
3334: hr_utility.trace('----------------------------------------');
3335:
3336: /******* PSD Balance By Run *****/
3337:

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

3330: hr_utility.trace('----------------------------------------');
3331: hr_utility.trace('ln_PSD_gross = '||ln_psd_subject);
3332: hr_utility.trace('ln_PSD_withheld = '||ln_PSD_withheld);
3333: hr_utility.trace('lv_non_resident_flag = '||lv_non_resident_flag);
3334: hr_utility.trace('----------------------------------------');
3335:
3336: /******* PSD Balance By Run *****/
3337:
3338: IF p_detail_level = '01' THEN

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

3336: /******* PSD Balance By Run *****/
3337:
3338: IF p_detail_level = '01' THEN
3339:
3340: hr_utility.trace('-----------------------------------');
3341: hr_utility.trace('PSD Dist by Run output..........');
3342: hr_utility.trace('ln_action_number = '||ln_action_number);
3343: hr_utility.trace('-----------------------------------');
3344:

Line 3341: hr_utility.trace('PSD Dist by Run output..........');

3337:
3338: IF p_detail_level = '01' THEN
3339:
3340: hr_utility.trace('-----------------------------------');
3341: hr_utility.trace('PSD Dist by Run output..........');
3342: hr_utility.trace('ln_action_number = '||ln_action_number);
3343: hr_utility.trace('-----------------------------------');
3344:
3345: emp_static_data( lv_last_name,

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

3338: IF p_detail_level = '01' THEN
3339:
3340: hr_utility.trace('-----------------------------------');
3341: hr_utility.trace('PSD Dist by Run output..........');
3342: hr_utility.trace('ln_action_number = '||ln_action_number);
3343: hr_utility.trace('-----------------------------------');
3344:
3345: emp_static_data( lv_last_name,
3346: lv_first_name,

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

3339:
3340: hr_utility.trace('-----------------------------------');
3341: hr_utility.trace('PSD Dist by Run output..........');
3342: hr_utility.trace('ln_action_number = '||ln_action_number);
3343: hr_utility.trace('-----------------------------------');
3344:
3345: emp_static_data( lv_last_name,
3346: lv_first_name,
3347: lv_middle_name,

Line 3364: hr_utility.trace('After PSD emp static data');

3360: lv_action_type,
3361: ld_effective_date,
3362: p_output_file_type,
3363: lv_employee_data);
3364: hr_utility.trace('After PSD emp static data');
3365: lv_data_row := lv_employee_data;
3366: hr_utility.trace('Before call to PSD static data');
3367: PSD_static_data(lv_gre_name,
3368: lv_jurisdiction,

Line 3366: hr_utility.trace('Before call to PSD static data');

3362: p_output_file_type,
3363: lv_employee_data);
3364: hr_utility.trace('After PSD emp static data');
3365: lv_data_row := lv_employee_data;
3366: hr_utility.trace('Before call to PSD static data');
3367: PSD_static_data(lv_gre_name,
3368: lv_jurisdiction,
3369: nvl(ln_psd_subject,0),
3370: nvl(ln_psd_withheld,0),

Line 3378: hr_utility.trace('After call to PSD static data');

3374: nvl(lv_non_resident_flag,''),
3375: p_output_file_type,
3376: p_detail_level,
3377: lv_PSD_data);
3378: hr_utility.trace('After call to PSD static data');
3379: lv_data_row := lv_data_row||lv_PSD_data;
3380:
3381: if p_output_file_type = 'HTML' then
3382: lv_data_row := '
'||lv_data_row||'';
Line 3390: hr_utility.trace('----------------------------------------');

3386:
3387: /***** PSD balance by Summary (by jurisdiction) *****/
3388:
3389: IF p_detail_level = '02' THEN
3390: hr_utility.trace('----------------------------------------');
3391: hr_utility.trace('City by Summary....................');
3392: hr_utility.trace('ln_action_number = '||ln_action_number);
3393: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3394: hr_utility.trace('ln_person_id = '||ln_person_id);

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

3387: /***** PSD balance by Summary (by jurisdiction) *****/
3388:
3389: IF p_detail_level = '02' THEN
3390: hr_utility.trace('----------------------------------------');
3391: hr_utility.trace('City by Summary....................');
3392: hr_utility.trace('ln_action_number = '||ln_action_number);
3393: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3394: hr_utility.trace('ln_person_id = '||ln_person_id);
3395: hr_utility.trace('----------------------------------------');

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

3388:
3389: IF p_detail_level = '02' THEN
3390: hr_utility.trace('----------------------------------------');
3391: hr_utility.trace('City by Summary....................');
3392: hr_utility.trace('ln_action_number = '||ln_action_number);
3393: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3394: hr_utility.trace('ln_person_id = '||ln_person_id);
3395: hr_utility.trace('----------------------------------------');
3396: IF ln_prev_person = ln_person_id THEN

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

3389: IF p_detail_level = '02' THEN
3390: hr_utility.trace('----------------------------------------');
3391: hr_utility.trace('City by Summary....................');
3392: hr_utility.trace('ln_action_number = '||ln_action_number);
3393: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3394: hr_utility.trace('ln_person_id = '||ln_person_id);
3395: hr_utility.trace('----------------------------------------');
3396: IF ln_prev_person = ln_person_id THEN
3397: emp_sum_static_data( lv_last_name,

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

3390: hr_utility.trace('----------------------------------------');
3391: hr_utility.trace('City by Summary....................');
3392: hr_utility.trace('ln_action_number = '||ln_action_number);
3393: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3394: hr_utility.trace('ln_person_id = '||ln_person_id);
3395: hr_utility.trace('----------------------------------------');
3396: IF ln_prev_person = ln_person_id THEN
3397: emp_sum_static_data( lv_last_name,
3398: lv_first_name,

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

3391: hr_utility.trace('City by Summary....................');
3392: hr_utility.trace('ln_action_number = '||ln_action_number);
3393: hr_utility.trace('ln_prev_person = '||ln_prev_person);
3394: hr_utility.trace('ln_person_id = '||ln_person_id);
3395: hr_utility.trace('----------------------------------------');
3396: IF ln_prev_person = ln_person_id THEN
3397: emp_sum_static_data( lv_last_name,
3398: lv_first_name,
3399: lv_middle_name,

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

3403: p_output_file_type,
3404: lv_employee_data);
3405:
3406: lv_data_row := lv_employee_data;
3407: hr_utility.trace('p_state_id = '||p_state_id);
3408: hr_utility.trace('p_county_id = '||p_county_id);
3409: hr_utility.trace('p_city_id = '||p_city_id);
3410: hr_utility.trace('PSD_bal.count = '||PSD_bal.count);
3411:

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

3404: lv_employee_data);
3405:
3406: lv_data_row := lv_employee_data;
3407: hr_utility.trace('p_state_id = '||p_state_id);
3408: hr_utility.trace('p_county_id = '||p_county_id);
3409: hr_utility.trace('p_city_id = '||p_city_id);
3410: hr_utility.trace('PSD_bal.count = '||PSD_bal.count);
3411:
3412: lv_found := 'N';

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

3405:
3406: lv_data_row := lv_employee_data;
3407: hr_utility.trace('p_state_id = '||p_state_id);
3408: hr_utility.trace('p_county_id = '||p_county_id);
3409: hr_utility.trace('p_city_id = '||p_city_id);
3410: hr_utility.trace('PSD_bal.count = '||PSD_bal.count);
3411:
3412: lv_found := 'N';
3413: IF PSD_bal.count > 0 THEN

Line 3410: hr_utility.trace('PSD_bal.count = '||PSD_bal.count);

3406: lv_data_row := lv_employee_data;
3407: hr_utility.trace('p_state_id = '||p_state_id);
3408: hr_utility.trace('p_county_id = '||p_county_id);
3409: hr_utility.trace('p_city_id = '||p_city_id);
3410: hr_utility.trace('PSD_bal.count = '||PSD_bal.count);
3411:
3412: lv_found := 'N';
3413: IF PSD_bal.count > 0 THEN
3414: FOR k in PSD_bal.first..PSD_bal.last LOOP

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

3428: PSD_bal(k).School_PSD_Withheld;
3429: END IF;
3430: END LOOP;
3431:
3432: hr_utility.trace('lv_found := '||lv_found);
3433: IF lv_found = 'N' THEN
3434: ln_next_tab := PSD_bal.count +1;
3435: PSD_bal(ln_next_tab).tax_unit_id := ln_tax_unit_id;
3436: PSD_bal(ln_next_tab).gre_name := lv_gre_name;

Line 3447: hr_utility.trace('PSD first fetch ..........');

3443: PSD_bal(ln_next_tab).School_PSD_Withheld := nvl(ln_school_psd_withheld,0);
3444: END IF;
3445:
3446: ELSE /** city_bal = 0, first fetch **/
3447: hr_utility.trace('PSD first fetch ..........');
3448: PSD_bal(1).tax_unit_id := ln_tax_unit_id;
3449: PSD_bal(1).gre_name := lv_gre_name;
3450: PSD_bal(1).jurisdiction_code := lv_jurisdiction;
3451: PSD_bal(1).PSD_withheld := nvl(ln_PSD_withheld,0);

Line 3459: hr_utility.trace('.......PSD ELSE New Person Fetched .......');

3455: PSD_bal(1).City_PSD_Withheld := nvl(ln_city_psd_withheld,0);
3456: PSD_bal(1).School_PSD_Withheld := nvl(ln_school_psd_withheld,0);
3457: END IF;
3458: ELSE /*** New person fetched, write out prev person **/
3459: hr_utility.trace('.......PSD ELSE New Person Fetched .......');
3460: hr_utility.trace('Write out the previous person................');
3461:
3462: lv_prev_emp_data_row := lv_data_row;
3463:

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

3456: PSD_bal(1).School_PSD_Withheld := nvl(ln_school_psd_withheld,0);
3457: END IF;
3458: ELSE /*** New person fetched, write out prev person **/
3459: hr_utility.trace('.......PSD ELSE New Person Fetched .......');
3460: hr_utility.trace('Write out the previous person................');
3461:
3462: lv_prev_emp_data_row := lv_data_row;
3463:
3464: IF PSD_bal.count>0 THEN

Line 3484: hr_utility.trace('End of printing PSD sum.....');

3480: end if;
3481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,lv_data_row);
3482: END LOOP;
3483: END IF; -- PSD_bal.count
3484: hr_utility.trace('End of printing PSD sum.....');
3485: /**** Now, build employee static header with the new fetched ***/
3486: /**** Person record ***/
3487:
3488: emp_sum_static_data( lv_last_name,

Line 3501: hr_utility.trace('Resetting Summary for PSD................');

3497: /* Set the prev person to this fetched person */
3498: ln_prev_person := ln_person_id;
3499: /*** Reset sum to currently Fetched Record ***/
3500:
3501: hr_utility.trace('Resetting Summary for PSD................');
3502: IF PSD_bal.count > 0 THEN
3503: FOR k in PSD_bal.first..PSD_bal.last LOOP
3504: PSD_bal(k).tax_unit_id := -1;
3505: PSD_bal(k).gre_name := '';

Line 3526: hr_utility.trace('New PSD summary for '||

3522: PSD_bal(1).City_PSD_Subj_Whable := nvl(ln_city_psd_subject,0) ;
3523: PSD_bal(1).City_PSD_Withheld := nvl(ln_city_psd_withheld,0);
3524: PSD_bal(1).School_PSD_Withheld := nvl(ln_school_psd_withheld,0);
3525:
3526: hr_utility.trace('New PSD summary for '||
3527: ln_person_id||' PSD_withheld = '||
3528: PSD_bal(1).PSD_withheld);
3529:
3530: END IF; /** Person Check **/

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

3537: END IF; /**** End of Assignment Set ****/
3538:
3539: /** Reset the previous person to the current person
3540: before fetching another person **/
3541: hr_utility.trace('Getting Next employee ........ ');
3542:
3543: --ln_prev_person := ln_person_id; /* 2974109 fix */
3544:
3545: END LOOP; /** End of Employee Loop */

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

3547:
3548: /**** Write out the last fetched record ****/
3549:
3550: IF (p_jurisdiction_level = '01' and p_detail_level = '02') then
3551: hr_utility.trace('Inside FINAL write out for FED');
3552:
3553: lv_emp_data_row := lv_data_row;
3554: IF federal_bal.count > 0 THEN
3555: FOR k in federal_bal.first..federal_bal.last LOOP

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

3583: END IF;
3584: END IF;
3585:
3586: IF (p_jurisdiction_level = '02' and p_detail_level = '02') then
3587: hr_utility.trace('Inside FINAL write out for STATE');
3588:
3589: lv_emp_data_row := lv_data_row;
3590:
3591: IF state_bal.count > 0 THEN

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

3622:
3623: END IF;
3624:
3625: IF (p_jurisdiction_level = '03' and p_detail_level = '02') then
3626: hr_utility.trace('Inside FINAL write out for COUNTY');
3627: lv_emp_data_row := lv_data_row;
3628:
3629: IF county_bal.count>0 THEN
3630: FOR j in county_bal.first..county_bal.last LOOP

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

3649: END IF; -- county_bal.count
3650: END IF;
3651:
3652: IF (p_jurisdiction_level = '04' and p_detail_level = '02') then
3653: hr_utility.trace('Inside FINAL write out for CITY');
3654: lv_emp_data_row := lv_data_row;
3655:
3656: IF city_bal.count>0 THEN
3657: FOR j in city_bal.first..city_bal.last LOOP

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

3676: END IF; -- city_bal.count
3677: END IF;
3678:
3679: IF (p_jurisdiction_level = '05' and p_detail_level = '02') then
3680: hr_utility.trace('Inside FINAL write out for SCHOOL');
3681: lv_emp_data_row := lv_data_row;
3682:
3683: IF school_bal.count>0 THEN
3684: FOR j in school_bal.first..school_bal.last LOOP

Line 3706: hr_utility.trace('Inside FINAL write out for PSD');

3702: END IF;
3703:
3704: --#11927527 Start
3705: IF (p_jurisdiction_level = '06' and p_detail_level = '02') then
3706: hr_utility.trace('Inside FINAL write out for PSD');
3707: lv_emp_data_row := lv_data_row;
3708:
3709: IF PSD_bal.count>0 THEN
3710: FOR j in PSD_bal.first..PSD_bal.last LOOP

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

3732:
3733: if p_output_file_type ='HTML' then
3734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3735: end if;
3736: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
3737:
3738: /**********************************************************
3739: ** Not Required as the output file type is HTML by default
3740: ***********************************************************/

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

3749:
3750: END ;
3751:
3752: --BEGIN
3753: -- hr_utility.trace_on('Y', 'EMPPDTL');
3754: END pay_archiver_report_pkg;