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

APPS.PAY_US_PSD_GENERIC_EXTRACT dependencies on HR_UTILITY

Line 56: Name : HR_UTILITY_TRACE

52: g_debug boolean;
53: g_document_type varchar2(50);
54:
55: /****************************************************************************
56: Name : HR_UTILITY_TRACE
57: Description : This procedure prints debug messages.
58: *****************************************************************************/
59:
60: PROCEDURE HR_UTILITY_TRACE

Line 60: PROCEDURE HR_UTILITY_TRACE

56: Name : HR_UTILITY_TRACE
57: Description : This procedure prints debug messages.
58: *****************************************************************************/
59:
60: PROCEDURE HR_UTILITY_TRACE
61: (
62: P_TRC_DATA varchar2
63: ) AS
64: BEGIN

Line 66: hr_utility.trace(p_trc_data);

62: P_TRC_DATA varchar2
63: ) AS
64: BEGIN
65: IF g_debug THEN
66: hr_utility.trace(p_trc_data);
67: END IF;
68: END HR_UTILITY_TRACE;
69:
70: FUNCTION convert_special_char( p_data varchar2)

Line 68: END HR_UTILITY_TRACE;

64: BEGIN
65: IF g_debug THEN
66: hr_utility.trace(p_trc_data);
67: END IF;
68: END HR_UTILITY_TRACE;
69:
70: FUNCTION convert_special_char( p_data varchar2)
71: RETURN varchar2 IS
72: l_data VARCHAR2(2000);

Line 129: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '||ltr_ra_data_tag(i));

125: --
126: -- Following Loop structure used to debug the Tag Values
127: --
128: FOR I IN 1 .. g_ra_no_of_tag LOOP
129: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '||ltr_ra_data_tag(i));
130: END LOOP;
131: END populate_ra_data_tag;
132:
133:

Line 609: -- HR_UTILITY_TRACE(l_final_xml_string);

605: FOR I IN 1 .. g_ra_no_of_tag LOOP
606: l_final_xml_string := l_final_xml_string || '<'||g_ra_record(I).submitter_tag||'>'||
607: convert_special_char(g_ra_record(I).submitter_data)
608: ||''|| EOL;
609: -- HR_UTILITY_TRACE(l_final_xml_string);
610: END LOOP;
611: HR_UTILITY_TRACE(l_final_xml_string);
612: p_final_string := l_final_xml_string;
613: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);

Line 611: HR_UTILITY_TRACE(l_final_xml_string);

607: convert_special_char(g_ra_record(I).submitter_data)
608: ||''|| EOL;
609: -- HR_UTILITY_TRACE(l_final_xml_string);
610: END LOOP;
611: HR_UTILITY_TRACE(l_final_xml_string);
612: p_final_string := l_final_xml_string;
613: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);
614: --pay_core_files.write_to_magtape_lob(l_final_xml_string);
615: --}

Line 665: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '||ltr_re_data_tag(i));

661: --
662: -- Following Loop structure used to debug the Tag Values
663: --
664: FOR I IN ltr_re_data_tag.first .. ltr_re_data_tag.last LOOP
665: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '||ltr_re_data_tag(i));
666: END LOOP;
667:
668: END populate_re_data_tag;
669:

Line 875: HR_UTILITY_TRACE('ER_PSD_CODE: '||pay_magtape_generic.get_parameter_value('ER_PSD_CODE'));

871:
872: if ltr_ue_name_table.count > 0 then
873: for j in ltr_ue_name_table.first .. ltr_ue_name_table.last
874: loop
875: HR_UTILITY_TRACE('ER_PSD_CODE: '||pay_magtape_generic.get_parameter_value('ER_PSD_CODE'));
876: if(ltr_ue_name_table(j).ue_name in ('A_PSD_REPORTING_RULES_ORG_EMPLOYER_PSD_CODE',
877: 'A_PSD_REPORTING_RULES_ORG_EMPLOYER_TAX_ACCOUNT_NUMBER')) then
878: HR_UTILITY_TRACE('ER_PSD_CODE:'||pay_magtape_generic.get_parameter_value('ER_PSD_CODE'));
879: begin

Line 878: HR_UTILITY_TRACE('ER_PSD_CODE:'||pay_magtape_generic.get_parameter_value('ER_PSD_CODE'));

874: loop
875: HR_UTILITY_TRACE('ER_PSD_CODE: '||pay_magtape_generic.get_parameter_value('ER_PSD_CODE'));
876: if(ltr_ue_name_table(j).ue_name in ('A_PSD_REPORTING_RULES_ORG_EMPLOYER_PSD_CODE',
877: 'A_PSD_REPORTING_RULES_ORG_EMPLOYER_TAX_ACCOUNT_NUMBER')) then
878: HR_UTILITY_TRACE('ER_PSD_CODE:'||pay_magtape_generic.get_parameter_value('ER_PSD_CODE'));
879: begin
880: open c_get_psd_data(ltr_ue_name_table(j).ue_name);
881: fetch c_get_psd_data into ltr_ue_name_table(j).ue_value ;
882:

Line 885: hr_utility_trace ('populate_arch_employer: getting PSd Reporting Rules (ER) archvied values '||SQLERRM);

881: fetch c_get_psd_data into ltr_ue_name_table(j).ue_value ;
882:
883: close c_get_psd_data;
884: exception when no_data_found then
885: hr_utility_trace ('populate_arch_employer: getting PSd Reporting Rules (ER) archvied values '||SQLERRM);
886: end;
887: else
888: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,
889: l_payroll_action_id,

Line 1091: HR_UTILITY_TRACE(l_final_xml_string);

1087: FOR I IN 1 .. g_re_no_of_tag LOOP
1088: l_final_xml_string := l_final_xml_string || '<'||g_re_record(I).employer_tag||'>'||
1089: convert_special_char(g_re_record(I).employer_data)
1090: ||''|| EOL;
1091: HR_UTILITY_TRACE(l_final_xml_string);
1092: END LOOP;
1093: HR_UTILITY_TRACE(l_final_xml_string);
1094: p_final_string := l_final_xml_string;
1095: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);

Line 1093: HR_UTILITY_TRACE(l_final_xml_string);

1089: convert_special_char(g_re_record(I).employer_data)
1090: ||''|| EOL;
1091: HR_UTILITY_TRACE(l_final_xml_string);
1092: END LOOP;
1093: HR_UTILITY_TRACE(l_final_xml_string);
1094: p_final_string := l_final_xml_string;
1095: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);
1096: --pay_core_files.write_to_magtape_lob(l_final_xml_string);
1097: --}

Line 1166: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '|| ltr_ee_data_tag(i));

1162: -- Following Loop structure used to debug the Tag Values
1163: --
1164: FOR I IN ltr_ee_data_tag.first .. ltr_ee_data_tag.last
1165: LOOP
1166: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '|| ltr_ee_data_tag(i));
1167: END LOOP;
1168: END populate_ee_data_tag;
1169: --
1170: -- This Procedue would be used to fetch all the employee related data

Line 1537: HR_UTILITY_TRACE('skchalla Period type'|| l_period_type);

1533: -- End of setting User Entities to PL/Table
1534: --
1535: --Added for the Bug 14799833, getting the YTD values
1536:
1537: HR_UTILITY_TRACE('skchalla Period type'|| l_period_type);
1538:
1539: HR_UTILITY_TRACE('p_assignment_action_id is '|| p_assignment_action_id);
1540: HR_UTILITY_TRACE('p_jurisdiction_code is '|| p_jurisdiction_code);
1541:

Line 1539: HR_UTILITY_TRACE('p_assignment_action_id is '|| p_assignment_action_id);

1535: --Added for the Bug 14799833, getting the YTD values
1536:
1537: HR_UTILITY_TRACE('skchalla Period type'|| l_period_type);
1538:
1539: HR_UTILITY_TRACE('p_assignment_action_id is '|| p_assignment_action_id);
1540: HR_UTILITY_TRACE('p_jurisdiction_code is '|| p_jurisdiction_code);
1541:
1542: --Changes for the Bug 14799833
1543: IF l_period_type = 'Yearly' then

Line 1540: HR_UTILITY_TRACE('p_jurisdiction_code is '|| p_jurisdiction_code);

1536:
1537: HR_UTILITY_TRACE('skchalla Period type'|| l_period_type);
1538:
1539: HR_UTILITY_TRACE('p_assignment_action_id is '|| p_assignment_action_id);
1540: HR_UTILITY_TRACE('p_jurisdiction_code is '|| p_jurisdiction_code);
1541:
1542: --Changes for the Bug 14799833
1543: IF l_period_type = 'Yearly' then
1544:

Line 1562: HR_UTILITY_TRACE('YTD wages '|| ltr_ue_name_table(22).ue_value);

1558: END IF;
1559:
1560: close c_get_ytd_values;
1561:
1562: HR_UTILITY_TRACE('YTD wages '|| ltr_ue_name_table(22).ue_value);
1563: HR_UTILITY_TRACE('YTD withheld '|| ltr_ue_name_table(23).ue_value);
1564:
1565: END IF;
1566:

Line 1563: HR_UTILITY_TRACE('YTD withheld '|| ltr_ue_name_table(23).ue_value);

1559:
1560: close c_get_ytd_values;
1561:
1562: HR_UTILITY_TRACE('YTD wages '|| ltr_ue_name_table(22).ue_value);
1563: HR_UTILITY_TRACE('YTD withheld '|| ltr_ue_name_table(23).ue_value);
1564:
1565: END IF;
1566:
1567: HR_UTILITY_TRACE('DBI Count '||to_char(ltr_ue_name_table.count));

Line 1567: HR_UTILITY_TRACE('DBI Count '||to_char(ltr_ue_name_table.count));

1563: HR_UTILITY_TRACE('YTD withheld '|| ltr_ue_name_table(23).ue_value);
1564:
1565: END IF;
1566:
1567: HR_UTILITY_TRACE('DBI Count '||to_char(ltr_ue_name_table.count));
1568: HR_UTILITY_TRACE('YE Archive Assignment Action Id '||
1569: to_char(p_assignment_action_id));
1570:
1571: IF ltr_ue_name_table.count > 0 then

Line 1568: HR_UTILITY_TRACE('YE Archive Assignment Action Id '||

1564:
1565: END IF;
1566:
1567: HR_UTILITY_TRACE('DBI Count '||to_char(ltr_ue_name_table.count));
1568: HR_UTILITY_TRACE('YE Archive Assignment Action Id '||
1569: to_char(p_assignment_action_id));
1570:
1571: IF ltr_ue_name_table.count > 0 then
1572: FOR j IN ltr_ue_name_table.first .. ltr_ue_name_table.last

Line 1667: HR_UTILITY_TRACE('DBI ' || ltr_ue_name_table(J).ue_data_level ||

1663: ltr_ue_name_table(j).ue_name);
1664: ELSE
1665: ltr_ue_name_table(j).ue_value := ' ';
1666: END IF;
1667: HR_UTILITY_TRACE('DBI ' || ltr_ue_name_table(J).ue_data_level ||
1668: ' -('||to_char(j)|| ') : < '||ltr_ue_name_table(j).ue_name||
1669: ' > VALUE : < '|| ltr_ue_name_table(j).ue_value||' >');
1670: END LOOP;
1671: HR_UTILITY_TRACE('Status of Employee Record ' || l_status);

Line 1671: HR_UTILITY_TRACE('Status of Employee Record ' || l_status);

1667: HR_UTILITY_TRACE('DBI ' || ltr_ue_name_table(J).ue_data_level ||
1668: ' -('||to_char(j)|| ') : < '||ltr_ue_name_table(j).ue_name||
1669: ' > VALUE : < '|| ltr_ue_name_table(j).ue_value||' >');
1670: END LOOP;
1671: HR_UTILITY_TRACE('Status of Employee Record ' || l_status);
1672: END IF;
1673:
1674: /* ==================================================
1675: Get Employer or transmitter Company Information releated Submitter

Line 1726: HR_UTILITY_TRACE(g_ee_record(1).employee_tag || ' : '

1722:
1723:
1724: /* Record Identifier */
1725: g_ee_record(RS_RECORD_IDENTIFIER).employee_data := 'RS';
1726: HR_UTILITY_TRACE(g_ee_record(1).employee_tag || ' : '
1727: || g_ee_record(RS_RECORD_IDENTIFIER).employee_data);
1728:
1729: /*FIPS CODE*/
1730: g_ee_record(EE_STATE_CODE).employee_data := ltr_ue_name_table(1).ue_value;

Line 1731: HR_UTILITY_TRACE(g_ee_record(EE_STATE_CODE).employee_tag || ' : '

1727: || g_ee_record(RS_RECORD_IDENTIFIER).employee_data);
1728:
1729: /*FIPS CODE*/
1730: g_ee_record(EE_STATE_CODE).employee_data := ltr_ue_name_table(1).ue_value;
1731: HR_UTILITY_TRACE(g_ee_record(EE_STATE_CODE).employee_tag || ' : '
1732: || g_ee_record(EE_STATE_CODE).employee_data);
1733:
1734: g_ee_record(EE_TAXING_ENTITY_CODE).employee_data := '';
1735: HR_UTILITY_TRACE(g_ee_record(EE_TAXING_ENTITY_CODE).employee_tag || ' : '

Line 1735: HR_UTILITY_TRACE(g_ee_record(EE_TAXING_ENTITY_CODE).employee_tag || ' : '

1731: HR_UTILITY_TRACE(g_ee_record(EE_STATE_CODE).employee_tag || ' : '
1732: || g_ee_record(EE_STATE_CODE).employee_data);
1733:
1734: g_ee_record(EE_TAXING_ENTITY_CODE).employee_data := '';
1735: HR_UTILITY_TRACE(g_ee_record(EE_TAXING_ENTITY_CODE).employee_tag || ' : '
1736: || g_ee_record(EE_TAXING_ENTITY_CODE).employee_data);
1737:
1738: /* Employee, Social Security Number (SSN) */
1739: g_ee_record(EE_SSN).employee_data := ltr_ue_name_table(2).ue_value;

Line 1740: HR_UTILITY_TRACE(g_ee_record(EE_SSN).employee_tag || ' : '

1736: || g_ee_record(EE_TAXING_ENTITY_CODE).employee_data);
1737:
1738: /* Employee, Social Security Number (SSN) */
1739: g_ee_record(EE_SSN).employee_data := ltr_ue_name_table(2).ue_value;
1740: HR_UTILITY_TRACE(g_ee_record(EE_SSN).employee_tag || ' : '
1741: || g_ee_record(EE_SSN).employee_data);
1742:
1743: /* Employee, First Name */
1744: --g_ee_record(EE_FIRST_NAME).employee_data := ltr_ue_name_table(2).ue_value;

Line 1746: HR_UTILITY_TRACE(g_ee_record(EE_FIRST_NAME).employee_tag || ' : '

1742:
1743: /* Employee, First Name */
1744: --g_ee_record(EE_FIRST_NAME).employee_data := ltr_ue_name_table(2).ue_value;
1745: g_ee_record(EE_FIRST_NAME).employee_data := upper(ltr_ue_name_table(3).ue_value);
1746: HR_UTILITY_TRACE(g_ee_record(EE_FIRST_NAME).employee_tag || ' : '
1747: || g_ee_record(EE_FIRST_NAME).employee_data);
1748:
1749: /* Employee, Middle Name or Initial */
1750: --g_ee_record(EE_MIDDLE_INITIAL).employee_data := ltr_ue_name_table(3).ue_value;

Line 1752: HR_UTILITY_TRACE(g_ee_record(EE_MIDDLE_INITIAL).employee_tag || ' : '

1748:
1749: /* Employee, Middle Name or Initial */
1750: --g_ee_record(EE_MIDDLE_INITIAL).employee_data := ltr_ue_name_table(3).ue_value;
1751: g_ee_record(EE_MIDDLE_INITIAL).employee_data := upper(ltr_ue_name_table(4).ue_value);
1752: HR_UTILITY_TRACE(g_ee_record(EE_MIDDLE_INITIAL).employee_tag || ' : '
1753: || g_ee_record(EE_MIDDLE_INITIAL).employee_data);
1754:
1755: /* Employee, Last Name */
1756: --g_ee_record(EE_LAST_NAME).employee_data := ltr_ue_name_table(4).ue_value;

Line 1758: HR_UTILITY_TRACE(g_ee_record(EE_LAST_NAME).employee_tag || ' : '

1754:
1755: /* Employee, Last Name */
1756: --g_ee_record(EE_LAST_NAME).employee_data := ltr_ue_name_table(4).ue_value;
1757: g_ee_record(EE_LAST_NAME).employee_data := upper(ltr_ue_name_table(5).ue_value);
1758: HR_UTILITY_TRACE(g_ee_record(EE_LAST_NAME).employee_tag || ' : '
1759: || g_ee_record(EE_LAST_NAME).employee_data);
1760:
1761: /* Employee, Name Suffix */
1762: --g_ee_record(EE_SUFFIX).employee_data := ltr_ue_name_table(5).ue_value;

Line 1764: HR_UTILITY_TRACE(g_ee_record(EE_SUFFIX).employee_tag || ' : '

1760:
1761: /* Employee, Name Suffix */
1762: --g_ee_record(EE_SUFFIX).employee_data := ltr_ue_name_table(5).ue_value;
1763: g_ee_record(EE_SUFFIX).employee_data := upper(ltr_ue_name_table(6).ue_value);
1764: HR_UTILITY_TRACE(g_ee_record(EE_SUFFIX).employee_tag || ' : '
1765: || g_ee_record(EE_SUFFIX).employee_data);
1766:
1767: /* Employee, Location Address */
1768: g_ee_record(EE_LOCATION_ADDRESS).employee_data := empe_out_1;

Line 1769: HR_UTILITY_TRACE(g_ee_record(EE_LOCATION_ADDRESS).employee_tag || ' : '

1765: || g_ee_record(EE_SUFFIX).employee_data);
1766:
1767: /* Employee, Location Address */
1768: g_ee_record(EE_LOCATION_ADDRESS).employee_data := empe_out_1;
1769: HR_UTILITY_TRACE(g_ee_record(EE_LOCATION_ADDRESS).employee_tag || ' : '
1770: || g_ee_record(EE_LOCATION_ADDRESS).employee_data);
1771:
1772: /* Pos: 88 Len: 22 Desc: Employee, Delivery Address */
1773: g_ee_record(EE_DELIVERY_ADDRESS).employee_data := empe_out_2;

Line 1774: HR_UTILITY_TRACE(g_ee_record(EE_DELIVERY_ADDRESS).employee_tag || ' : '

1770: || g_ee_record(EE_LOCATION_ADDRESS).employee_data);
1771:
1772: /* Pos: 88 Len: 22 Desc: Employee, Delivery Address */
1773: g_ee_record(EE_DELIVERY_ADDRESS).employee_data := empe_out_2;
1774: HR_UTILITY_TRACE(g_ee_record(EE_DELIVERY_ADDRESS).employee_tag || ' : '
1775: || g_ee_record(EE_DELIVERY_ADDRESS).employee_data);
1776:
1777: /* Employee, City */
1778: g_ee_record(EE_CITY).employee_data := empe_out_3;

Line 1779: HR_UTILITY_TRACE(g_ee_record(EE_CITY).employee_tag || ' : '

1775: || g_ee_record(EE_DELIVERY_ADDRESS).employee_data);
1776:
1777: /* Employee, City */
1778: g_ee_record(EE_CITY).employee_data := empe_out_3;
1779: HR_UTILITY_TRACE(g_ee_record(EE_CITY).employee_tag || ' : '
1780: || g_ee_record(EE_CITY).employee_data);
1781:
1782: /* Employee, State Abbreviation */
1783: g_ee_record(EE_STATE_ABBREVIATION).employee_data := empe_out_4;

Line 1784: HR_UTILITY_TRACE(g_ee_record(EE_STATE_ABBREVIATION).employee_tag || ' : '

1780: || g_ee_record(EE_CITY).employee_data);
1781:
1782: /* Employee, State Abbreviation */
1783: g_ee_record(EE_STATE_ABBREVIATION).employee_data := empe_out_4;
1784: HR_UTILITY_TRACE(g_ee_record(EE_STATE_ABBREVIATION).employee_tag || ' : '
1785: || g_ee_record(EE_STATE_ABBREVIATION).employee_data);
1786:
1787: /* Employee, Zip Code */
1788: g_ee_record(EE_ZIP_CODE).employee_data := empe_out_5;

Line 1789: HR_UTILITY_TRACE(g_ee_record(EE_ZIP_CODE).employee_tag || ' : '

1785: || g_ee_record(EE_STATE_ABBREVIATION).employee_data);
1786:
1787: /* Employee, Zip Code */
1788: g_ee_record(EE_ZIP_CODE).employee_data := empe_out_5;
1789: HR_UTILITY_TRACE(g_ee_record(EE_ZIP_CODE).employee_tag || ' : '
1790: || g_ee_record(EE_ZIP_CODE).employee_data);
1791:
1792: /* Employee, Zip Code Extension */
1793: g_ee_record(EE_ZIP_CODE_EXTENSION).employee_data :=

Line 1795: HR_UTILITY_TRACE(g_ee_record(EE_ZIP_CODE_EXTENSION).employee_tag || ' : '

1791:
1792: /* Employee, Zip Code Extension */
1793: g_ee_record(EE_ZIP_CODE_EXTENSION).employee_data :=
1794: empe_out_6;
1795: HR_UTILITY_TRACE(g_ee_record(EE_ZIP_CODE_EXTENSION).employee_tag || ' : '
1796: || g_ee_record(EE_ZIP_CODE_EXTENSION).employee_data);
1797:
1798: /* Employee, Foreign State - Province */
1799: g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data

Line 1801: HR_UTILITY_TRACE(g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_tag || ' : '

1797:
1798: /* Employee, Foreign State - Province */
1799: g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data
1800: := empe_out_7;
1801: HR_UTILITY_TRACE(g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_tag || ' : '
1802: || g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data);
1803:
1804: /* Employee, Foreign Postal Code */
1805: g_ee_record(EE_FOREIGN_POSTAL_CODE).employee_data

Line 1807: HR_UTILITY_TRACE(g_ee_record(EE_FOREIGN_POSTAL_CODE).employee_tag || ' : '

1803:
1804: /* Employee, Foreign Postal Code */
1805: g_ee_record(EE_FOREIGN_POSTAL_CODE).employee_data
1806: := empe_out_8;
1807: HR_UTILITY_TRACE(g_ee_record(EE_FOREIGN_POSTAL_CODE).employee_tag || ' : '
1808: || g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data);
1809:
1810: /*Employee, Country Code */
1811: g_ee_record(EE_COUNTRY_CODE).employee_data

Line 1813: HR_UTILITY_TRACE(g_ee_record(EE_COUNTRY_CODE).employee_tag || ' : '

1809:
1810: /*Employee, Country Code */
1811: g_ee_record(EE_COUNTRY_CODE).employee_data
1812: := empe_out_9;
1813: HR_UTILITY_TRACE(g_ee_record(EE_COUNTRY_CODE).employee_tag || ' : '
1814: || g_ee_record(EE_COUNTRY_CODE).employee_data);
1815:
1816: /*Record Change Notice: 0 for no change, 1 to indicate a change to Name, Address, or PSD/Jurisdiction Code.*/
1817: g_ee_record(EE_RECORD_CHANGE_NOTICE).employee_data := '0';

Line 1818: HR_UTILITY_TRACE(g_ee_record(EE_RECORD_CHANGE_NOTICE).employee_tag || ' : '

1814: || g_ee_record(EE_COUNTRY_CODE).employee_data);
1815:
1816: /*Record Change Notice: 0 for no change, 1 to indicate a change to Name, Address, or PSD/Jurisdiction Code.*/
1817: g_ee_record(EE_RECORD_CHANGE_NOTICE).employee_data := '0';
1818: HR_UTILITY_TRACE(g_ee_record(EE_RECORD_CHANGE_NOTICE).employee_tag || ' : '
1819: || g_ee_record(EE_RECORD_CHANGE_NOTICE).employee_data);
1820:
1821: /* Reporting Period */
1822: g_ee_record(EE_REPORTING_PERIOD).employee_data := l_reporting_period;

Line 1823: HR_UTILITY_TRACE(g_ee_record(EE_REPORTING_PERIOD).employee_tag || ' : '

1819: || g_ee_record(EE_RECORD_CHANGE_NOTICE).employee_data);
1820:
1821: /* Reporting Period */
1822: g_ee_record(EE_REPORTING_PERIOD).employee_data := l_reporting_period;
1823: HR_UTILITY_TRACE(g_ee_record(EE_REPORTING_PERIOD).employee_tag || ' : '
1824: || g_ee_record(EE_REPORTING_PERIOD).employee_data);
1825:
1826:
1827: /* State Code */

Line 1830: HR_UTILITY_TRACE(g_ee_record(EE_STATE_CODE2).employee_tag || ' : '

1826:
1827: /* State Code */
1828:
1829: g_ee_record(EE_STATE_CODE2).employee_data := '';
1830: HR_UTILITY_TRACE(g_ee_record(EE_STATE_CODE2).employee_tag || ' : '
1831: || g_ee_record(EE_STATE_CODE2).employee_data);
1832:
1833: /* State Taxable Wages
1834: A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD +

Line 1843: HR_UTILITY_TRACE(g_ee_record(EE_STATE_WAGES).employee_tag || ' : '

1839: to_number(ltr_ue_name_table(8).ue_value) -
1840: to_number(ltr_ue_name_table(9).ue_value);
1841:
1842: g_ee_record(EE_STATE_WAGES).employee_data := to_char(l_state_wages);
1843: HR_UTILITY_TRACE(g_ee_record(EE_STATE_WAGES).employee_tag || ' : '
1844: || g_ee_record(EE_STATE_WAGES).employee_data);
1845:
1846: /* SIT Withheld */
1847: g_ee_record(EE_SIT_WITHHELD).employee_data := ltr_ue_name_table(10).ue_value;

Line 1848: HR_UTILITY_TRACE(g_ee_record(EE_SIT_WITHHELD).employee_tag || ' : '

1844: || g_ee_record(EE_STATE_WAGES).employee_data);
1845:
1846: /* SIT Withheld */
1847: g_ee_record(EE_SIT_WITHHELD).employee_data := ltr_ue_name_table(10).ue_value;
1848: HR_UTILITY_TRACE(g_ee_record(EE_SIT_WITHHELD).employee_tag || ' : '
1849: || g_ee_record(EE_SIT_WITHHELD).employee_data);
1850:
1851: /*Local Tax Type: Required. "E" = EIT, "L" = LST, "W" = W2
1852: Defaulted to 'E'*/

Line 1856: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAX_TYPE).employee_tag || ' : '

1852: Defaulted to 'E'*/
1853: --Modified for the Bug 14799833
1854: if (l_period_type <>'Yearly') then
1855: g_ee_record(EE_LOCAL_TAX_TYPE).employee_data := 'E';
1856: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAX_TYPE).employee_tag || ' : '
1857: || g_ee_record(EE_LOCAL_TAX_TYPE).employee_data);
1858: else
1859: g_ee_record(EE_LOCAL_TAX_TYPE).employee_data := 'W';
1860: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAX_TYPE).employee_tag || ' : '

Line 1860: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAX_TYPE).employee_tag || ' : '

1856: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAX_TYPE).employee_tag || ' : '
1857: || g_ee_record(EE_LOCAL_TAX_TYPE).employee_data);
1858: else
1859: g_ee_record(EE_LOCAL_TAX_TYPE).employee_data := 'W';
1860: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAX_TYPE).employee_tag || ' : '
1861: || g_ee_record(EE_LOCAL_TAX_TYPE).employee_data);
1862: end if;
1863:
1864: /*PSD Subject Withholdable and Withheld taxes*/

Line 1868: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_tag || ' : '

1864: /*PSD Subject Withholdable and Withheld taxes*/
1865: if (l_period_type='Monthly') then
1866: --PSD_SUBJ_WHABLE_MONTH
1867: g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_data := ltr_ue_name_table(11).ue_value;
1868: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_tag || ' : '
1869: || g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_data);
1870: --PSD_WITHHELD_MONTH
1871: g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_data := ltr_ue_name_table(12).ue_value;
1872: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_tag || ' : '

Line 1872: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_tag || ' : '

1868: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_tag || ' : '
1869: || g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_data);
1870: --PSD_WITHHELD_MONTH
1871: g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_data := ltr_ue_name_table(12).ue_value;
1872: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_tag || ' : '
1873: || g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_data);
1874: --
1875: elsif (l_period_type='Quarterly') then--Modified for the Bug 14799833
1876:

Line 1879: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_tag || ' : '

1875: elsif (l_period_type='Quarterly') then--Modified for the Bug 14799833
1876:
1877: --PSD_SUBJ_WHABLE_QTD
1878: g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_data := ltr_ue_name_table(13).ue_value;
1879: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_tag || ' : '
1880: || g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_data);
1881: --PSD_WITHHELD_QTD
1882: g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_data := ltr_ue_name_table(14).ue_value;
1883: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_tag || ' : '

Line 1883: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_tag || ' : '

1879: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_tag || ' : '
1880: || g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_data);
1881: --PSD_WITHHELD_QTD
1882: g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_data := ltr_ue_name_table(14).ue_value;
1883: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_tag || ' : '
1884: || g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_data);
1885:
1886: --Added for the Bug 14799833
1887: elsif (l_period_type='Yearly') then

Line 1891: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_tag || ' : '

1887: elsif (l_period_type='Yearly') then
1888:
1889: --PSD_SUBJ_WHABLE_YTD
1890: g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_data := ltr_ue_name_table(22).ue_value;
1891: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_tag || ' : '
1892: || g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_data);
1893: --PSD_WITHHELD_YTD
1894: g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_data := ltr_ue_name_table(23).ue_value;
1895: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_tag || ' : '

Line 1895: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_tag || ' : '

1891: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_tag || ' : '
1892: || g_ee_record(EE_LOCAL_TAXABLE_WAGES).employee_data);
1893: --PSD_WITHHELD_YTD
1894: g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_data := ltr_ue_name_table(23).ue_value;
1895: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_tag || ' : '
1896: || g_ee_record(EE_LOCAL_INCOME_TAX_WITHHELD).employee_data);
1897:
1898: end if;
1899:

Line 1902: HR_UTILITY_TRACE(g_ee_record(EE_STATE_CONTROL_NUMBER).employee_tag || ' : '

1898: end if;
1899:
1900: /* EE_STATE_CONTROL_NUMBER */
1901: g_ee_record(EE_STATE_CONTROL_NUMBER).employee_data := ' ';
1902: HR_UTILITY_TRACE(g_ee_record(EE_STATE_CONTROL_NUMBER).employee_tag || ' : '
1903: || g_ee_record(EE_STATE_CONTROL_NUMBER).employee_data);
1904:
1905: /*PSD code of employee's residence*/
1906: g_ee_record(EE_RESIDENCE_PSD_CODE).employee_data :=l_ee_residence_psd_code;

Line 1907: HR_UTILITY_TRACE(g_ee_record(EE_RESIDENCE_PSD_CODE).employee_tag || ' : '

1903: || g_ee_record(EE_STATE_CONTROL_NUMBER).employee_data);
1904:
1905: /*PSD code of employee's residence*/
1906: g_ee_record(EE_RESIDENCE_PSD_CODE).employee_data :=l_ee_residence_psd_code;
1907: HR_UTILITY_TRACE(g_ee_record(EE_RESIDENCE_PSD_CODE).employee_tag || ' : '
1908: || g_ee_record(EE_RESIDENCE_PSD_CODE).employee_data);
1909:
1910: g_ee_record(EE_SCHOOL_DST_ONLY_PAYMENT).employee_data := ' ';
1911: HR_UTILITY_TRACE(g_ee_record(EE_SCHOOL_DST_ONLY_PAYMENT).employee_tag || ' : '

Line 1911: HR_UTILITY_TRACE(g_ee_record(EE_SCHOOL_DST_ONLY_PAYMENT).employee_tag || ' : '

1907: HR_UTILITY_TRACE(g_ee_record(EE_RESIDENCE_PSD_CODE).employee_tag || ' : '
1908: || g_ee_record(EE_RESIDENCE_PSD_CODE).employee_data);
1909:
1910: g_ee_record(EE_SCHOOL_DST_ONLY_PAYMENT).employee_data := ' ';
1911: HR_UTILITY_TRACE(g_ee_record(EE_SCHOOL_DST_ONLY_PAYMENT).employee_tag || ' : '
1912: || g_ee_record(EE_SCHOOL_DST_ONLY_PAYMENT).employee_data);
1913:
1914: /*PSD code of employee's work location*/
1915: g_ee_record(EE_WORK_PSD_CODE).employee_data := l_ee_work_psd_code;

Line 1916: HR_UTILITY_TRACE(g_ee_record(EE_WORK_PSD_CODE).employee_tag || ' : '

1912: || g_ee_record(EE_SCHOOL_DST_ONLY_PAYMENT).employee_data);
1913:
1914: /*PSD code of employee's work location*/
1915: g_ee_record(EE_WORK_PSD_CODE).employee_data := l_ee_work_psd_code;
1916: HR_UTILITY_TRACE(g_ee_record(EE_WORK_PSD_CODE).employee_tag || ' : '
1917: || g_ee_record(EE_WORK_PSD_CODE).employee_data);
1918:
1919: /*The Tax paid by the employee is Resident/ Non-Resident*/
1920: if (ltr_ue_name_table(15).ue_value>0) then

Line 1923: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_tag || ' : '

1919: /*The Tax paid by the employee is Resident/ Non-Resident*/
1920: if (ltr_ue_name_table(15).ue_value>0) then
1921: --Non Resident
1922: g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_data := 'ENR';
1923: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_tag || ' : '
1924: || g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_data);
1925: else
1926: --Resident
1927: g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_data := 'EIT';

Line 1928: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_tag || ' : '

1924: || g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_data);
1925: else
1926: --Resident
1927: g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_data := 'EIT';
1928: HR_UTILITY_TRACE(g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_tag || ' : '
1929: || g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_data);
1930: end if;
1931:
1932: g_ee_record(EE_PSD_SUBJ_WHABLE_MONTH).employee_data := ltr_ue_name_table(11).ue_value;

Line 1933: HR_UTILITY_TRACE(g_ee_record(EE_PSD_SUBJ_WHABLE_MONTH).employee_tag || ' : '

1929: || g_ee_record(EE_LOCAL_TAX_TYPE_R_NR).employee_data);
1930: end if;
1931:
1932: g_ee_record(EE_PSD_SUBJ_WHABLE_MONTH).employee_data := ltr_ue_name_table(11).ue_value;
1933: HR_UTILITY_TRACE(g_ee_record(EE_PSD_SUBJ_WHABLE_MONTH).employee_tag || ' : '
1934: || g_ee_record(EE_PSD_SUBJ_WHABLE_MONTH).employee_data);
1935: g_ee_record(EE_PSD_WITHHELD_MONTH).employee_data := ltr_ue_name_table(12).ue_value;
1936: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_MONTH).employee_tag || ' : '
1937: || g_ee_record(EE_PSD_WITHHELD_MONTH).employee_data);

Line 1936: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_MONTH).employee_tag || ' : '

1932: g_ee_record(EE_PSD_SUBJ_WHABLE_MONTH).employee_data := ltr_ue_name_table(11).ue_value;
1933: HR_UTILITY_TRACE(g_ee_record(EE_PSD_SUBJ_WHABLE_MONTH).employee_tag || ' : '
1934: || g_ee_record(EE_PSD_SUBJ_WHABLE_MONTH).employee_data);
1935: g_ee_record(EE_PSD_WITHHELD_MONTH).employee_data := ltr_ue_name_table(12).ue_value;
1936: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_MONTH).employee_tag || ' : '
1937: || g_ee_record(EE_PSD_WITHHELD_MONTH).employee_data);
1938: g_ee_record(EE_PSD_SUBJ_WHABLE_QTD).employee_data := ltr_ue_name_table(13).ue_value;
1939: HR_UTILITY_TRACE(g_ee_record(EE_PSD_SUBJ_WHABLE_QTD).employee_tag || ' : '
1940: || g_ee_record(EE_PSD_SUBJ_WHABLE_QTD).employee_data);

Line 1939: HR_UTILITY_TRACE(g_ee_record(EE_PSD_SUBJ_WHABLE_QTD).employee_tag || ' : '

1935: g_ee_record(EE_PSD_WITHHELD_MONTH).employee_data := ltr_ue_name_table(12).ue_value;
1936: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_MONTH).employee_tag || ' : '
1937: || g_ee_record(EE_PSD_WITHHELD_MONTH).employee_data);
1938: g_ee_record(EE_PSD_SUBJ_WHABLE_QTD).employee_data := ltr_ue_name_table(13).ue_value;
1939: HR_UTILITY_TRACE(g_ee_record(EE_PSD_SUBJ_WHABLE_QTD).employee_tag || ' : '
1940: || g_ee_record(EE_PSD_SUBJ_WHABLE_QTD).employee_data);
1941: g_ee_record(EE_PSD_WITHHELD_QTD).employee_data := ltr_ue_name_table(14).ue_value;
1942: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_QTD).employee_tag || ' : '
1943: || g_ee_record(EE_PSD_WITHHELD_QTD).employee_data);

Line 1942: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_QTD).employee_tag || ' : '

1938: g_ee_record(EE_PSD_SUBJ_WHABLE_QTD).employee_data := ltr_ue_name_table(13).ue_value;
1939: HR_UTILITY_TRACE(g_ee_record(EE_PSD_SUBJ_WHABLE_QTD).employee_tag || ' : '
1940: || g_ee_record(EE_PSD_SUBJ_WHABLE_QTD).employee_data);
1941: g_ee_record(EE_PSD_WITHHELD_QTD).employee_data := ltr_ue_name_table(14).ue_value;
1942: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_QTD).employee_tag || ' : '
1943: || g_ee_record(EE_PSD_WITHHELD_QTD).employee_data);
1944:
1945: g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_MONTH).employee_data := ltr_ue_name_table(16).ue_value;
1946: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_MONTH).employee_tag || ' : '

Line 1946: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_MONTH).employee_tag || ' : '

1942: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_QTD).employee_tag || ' : '
1943: || g_ee_record(EE_PSD_WITHHELD_QTD).employee_data);
1944:
1945: g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_MONTH).employee_data := ltr_ue_name_table(16).ue_value;
1946: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_MONTH).employee_tag || ' : '
1947: || g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_MONTH).employee_data);
1948: g_ee_record(EE_CITY_PSD_WITHHELD_MONTH).employee_data := ltr_ue_name_table(17).ue_value;
1949: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_WITHHELD_MONTH).employee_tag || ' : '
1950: || g_ee_record(EE_CITY_PSD_WITHHELD_MONTH).employee_data);

Line 1949: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_WITHHELD_MONTH).employee_tag || ' : '

1945: g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_MONTH).employee_data := ltr_ue_name_table(16).ue_value;
1946: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_MONTH).employee_tag || ' : '
1947: || g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_MONTH).employee_data);
1948: g_ee_record(EE_CITY_PSD_WITHHELD_MONTH).employee_data := ltr_ue_name_table(17).ue_value;
1949: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_WITHHELD_MONTH).employee_tag || ' : '
1950: || g_ee_record(EE_CITY_PSD_WITHHELD_MONTH).employee_data);
1951: g_ee_record(EE_SCHOOL_PSD_WITHHELD_MONTH).employee_data := ltr_ue_name_table(18).ue_value;
1952: HR_UTILITY_TRACE(g_ee_record(EE_SCHOOL_PSD_WITHHELD_MONTH).employee_tag || ' : '
1953: || g_ee_record(EE_SCHOOL_PSD_WITHHELD_MONTH).employee_data);

Line 1952: HR_UTILITY_TRACE(g_ee_record(EE_SCHOOL_PSD_WITHHELD_MONTH).employee_tag || ' : '

1948: g_ee_record(EE_CITY_PSD_WITHHELD_MONTH).employee_data := ltr_ue_name_table(17).ue_value;
1949: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_WITHHELD_MONTH).employee_tag || ' : '
1950: || g_ee_record(EE_CITY_PSD_WITHHELD_MONTH).employee_data);
1951: g_ee_record(EE_SCHOOL_PSD_WITHHELD_MONTH).employee_data := ltr_ue_name_table(18).ue_value;
1952: HR_UTILITY_TRACE(g_ee_record(EE_SCHOOL_PSD_WITHHELD_MONTH).employee_tag || ' : '
1953: || g_ee_record(EE_SCHOOL_PSD_WITHHELD_MONTH).employee_data);
1954: g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_QTD).employee_data := ltr_ue_name_table(19).ue_value;
1955: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_QTD).employee_tag || ' : '
1956: || g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_QTD).employee_data);

Line 1955: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_QTD).employee_tag || ' : '

1951: g_ee_record(EE_SCHOOL_PSD_WITHHELD_MONTH).employee_data := ltr_ue_name_table(18).ue_value;
1952: HR_UTILITY_TRACE(g_ee_record(EE_SCHOOL_PSD_WITHHELD_MONTH).employee_tag || ' : '
1953: || g_ee_record(EE_SCHOOL_PSD_WITHHELD_MONTH).employee_data);
1954: g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_QTD).employee_data := ltr_ue_name_table(19).ue_value;
1955: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_QTD).employee_tag || ' : '
1956: || g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_QTD).employee_data);
1957: g_ee_record(EE_CITY_PSD_WITHHELD_QTD).employee_data := ltr_ue_name_table(20).ue_value;
1958: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_WITHHELD_QTD).employee_tag || ' : '
1959: || g_ee_record(EE_CITY_PSD_WITHHELD_QTD).employee_data);

Line 1958: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_WITHHELD_QTD).employee_tag || ' : '

1954: g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_QTD).employee_data := ltr_ue_name_table(19).ue_value;
1955: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_QTD).employee_tag || ' : '
1956: || g_ee_record(EE_CITY_PSD_SUBJ_WHABLE_QTD).employee_data);
1957: g_ee_record(EE_CITY_PSD_WITHHELD_QTD).employee_data := ltr_ue_name_table(20).ue_value;
1958: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_WITHHELD_QTD).employee_tag || ' : '
1959: || g_ee_record(EE_CITY_PSD_WITHHELD_QTD).employee_data);
1960: g_ee_record(EE_SCHOOL_PSD_WITHHELD_QTD).employee_data := ltr_ue_name_table(21).ue_value;
1961: HR_UTILITY_TRACE(g_ee_record(EE_SCHOOL_PSD_WITHHELD_QTD).employee_tag || ' : '
1962: || g_ee_record(EE_SCHOOL_PSD_WITHHELD_QTD).employee_data);

Line 1961: HR_UTILITY_TRACE(g_ee_record(EE_SCHOOL_PSD_WITHHELD_QTD).employee_tag || ' : '

1957: g_ee_record(EE_CITY_PSD_WITHHELD_QTD).employee_data := ltr_ue_name_table(20).ue_value;
1958: HR_UTILITY_TRACE(g_ee_record(EE_CITY_PSD_WITHHELD_QTD).employee_tag || ' : '
1959: || g_ee_record(EE_CITY_PSD_WITHHELD_QTD).employee_data);
1960: g_ee_record(EE_SCHOOL_PSD_WITHHELD_QTD).employee_data := ltr_ue_name_table(21).ue_value;
1961: HR_UTILITY_TRACE(g_ee_record(EE_SCHOOL_PSD_WITHHELD_QTD).employee_tag || ' : '
1962: || g_ee_record(EE_SCHOOL_PSD_WITHHELD_QTD).employee_data);
1963: --Added for the Bug#14799833
1964:
1965: g_ee_record(EE_PSD_SUBJ_WHABLE_YTD).employee_data := ltr_ue_name_table(22).ue_value;

Line 1966: HR_UTILITY_TRACE(g_ee_record(EE_PSD_SUBJ_WHABLE_YTD).employee_tag || ' : '

1962: || g_ee_record(EE_SCHOOL_PSD_WITHHELD_QTD).employee_data);
1963: --Added for the Bug#14799833
1964:
1965: g_ee_record(EE_PSD_SUBJ_WHABLE_YTD).employee_data := ltr_ue_name_table(22).ue_value;
1966: HR_UTILITY_TRACE(g_ee_record(EE_PSD_SUBJ_WHABLE_YTD).employee_tag || ' : '
1967: || g_ee_record(EE_PSD_SUBJ_WHABLE_YTD).employee_data);
1968: g_ee_record(EE_PSD_WITHHELD_YTD).employee_data := ltr_ue_name_table(23).ue_value;
1969: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_YTD).employee_tag || ' : '
1970: || g_ee_record(EE_PSD_WITHHELD_YTD).employee_data);

Line 1969: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_YTD).employee_tag || ' : '

1965: g_ee_record(EE_PSD_SUBJ_WHABLE_YTD).employee_data := ltr_ue_name_table(22).ue_value;
1966: HR_UTILITY_TRACE(g_ee_record(EE_PSD_SUBJ_WHABLE_YTD).employee_tag || ' : '
1967: || g_ee_record(EE_PSD_SUBJ_WHABLE_YTD).employee_data);
1968: g_ee_record(EE_PSD_WITHHELD_YTD).employee_data := ltr_ue_name_table(23).ue_value;
1969: HR_UTILITY_TRACE(g_ee_record(EE_PSD_WITHHELD_YTD).employee_tag || ' : '
1970: || g_ee_record(EE_PSD_WITHHELD_YTD).employee_data);
1971:
1972: /*Work At Home Flag*/
1973: open c_get_wah_flag(p_assignment_action_id, p_date_earned);

Line 1978: HR_UTILITY_TRACE(g_ee_record(EE_WORK_AT_HOME).employee_tag || ' : '

1974: fetch c_get_wah_flag into l_wah_flag;
1975: close c_get_wah_flag;
1976: if(l_wah_flag = 'Y') then
1977: g_ee_record(EE_WORK_AT_HOME).employee_data := 'Y';
1978: HR_UTILITY_TRACE(g_ee_record(EE_WORK_AT_HOME).employee_tag || ' : '
1979: || g_ee_record(EE_WORK_AT_HOME).employee_data);
1980: else
1981: g_ee_record(EE_WORK_AT_HOME).employee_data := 'N';
1982: HR_UTILITY_TRACE(g_ee_record(EE_WORK_AT_HOME).employee_tag || ' : '

Line 1982: HR_UTILITY_TRACE(g_ee_record(EE_WORK_AT_HOME).employee_tag || ' : '

1978: HR_UTILITY_TRACE(g_ee_record(EE_WORK_AT_HOME).employee_tag || ' : '
1979: || g_ee_record(EE_WORK_AT_HOME).employee_data);
1980: else
1981: g_ee_record(EE_WORK_AT_HOME).employee_data := 'N';
1982: HR_UTILITY_TRACE(g_ee_record(EE_WORK_AT_HOME).employee_tag || ' : '
1983: || g_ee_record(EE_WORK_AT_HOME).employee_data);
1984: end if;
1985:
1986: /*Employee's Tax Collection District Code*/

Line 1988: HR_UTILITY_TRACE(g_ee_record(EE_TCD_CODE).employee_tag || ' : '

1984: end if;
1985:
1986: /*Employee's Tax Collection District Code*/
1987: g_ee_record(EE_TCD_CODE).employee_data := substr(l_ee_work_psd_code,1,2);
1988: HR_UTILITY_TRACE(g_ee_record(EE_TCD_CODE).employee_tag || ' : '
1989: || g_ee_record(EE_TCD_CODE).employee_data);
1990:
1991: /*Employee Number*/
1992: g_ee_record(EE_EMPLOYEE_NUMBER).employee_data := empe_out_10;

Line 1993: HR_UTILITY_TRACE(g_ee_record(EE_EMPLOYEE_NUMBER).employee_tag || ' : '

1989: || g_ee_record(EE_TCD_CODE).employee_data);
1990:
1991: /*Employee Number*/
1992: g_ee_record(EE_EMPLOYEE_NUMBER).employee_data := empe_out_10;
1993: HR_UTILITY_TRACE(g_ee_record(EE_EMPLOYEE_NUMBER).employee_tag || ' : '
1994: || g_ee_record(EE_EMPLOYEE_NUMBER).employee_data);
1995:
1996: /*Tax Year*/
1997: g_ee_record(EE_TAX_YEAR).employee_data := p_reporting_year;

Line 1998: HR_UTILITY_TRACE(g_ee_record(EE_TAX_YEAR).employee_tag || ' : '

1994: || g_ee_record(EE_EMPLOYEE_NUMBER).employee_data);
1995:
1996: /*Tax Year*/
1997: g_ee_record(EE_TAX_YEAR).employee_data := p_reporting_year;
1998: HR_UTILITY_TRACE(g_ee_record(EE_TAX_YEAR).employee_tag || ' : '
1999: || g_ee_record(EE_TAX_YEAR).employee_data);
2000:
2001: /*Tax Quarterr*/
2002: g_ee_record(EE_TAX_QUARTER).employee_data := l_quarter;

Line 2003: HR_UTILITY_TRACE(g_ee_record(EE_TAX_QUARTER).employee_tag || ' : '

1999: || g_ee_record(EE_TAX_YEAR).employee_data);
2000:
2001: /*Tax Quarterr*/
2002: g_ee_record(EE_TAX_QUARTER).employee_data := l_quarter;
2003: HR_UTILITY_TRACE(g_ee_record(EE_TAX_QUARTER).employee_tag || ' : '
2004: || g_ee_record(EE_TAX_QUARTER).employee_data);
2005:
2006: open c_check_psd_code_for_gre(l_ee_work_psd_code, l_tax_unit_id);
2007: fetch c_check_psd_code_for_gre into l_psd_code_exists;

Line 2058: HR_UTILITY_TRACE(g_ee_record(EE_EXCEPTION_TCD_CODE).employee_tag || ' : '

2054: END IF;
2055:
2056: /*Exception||TCD Code*/
2057: g_ee_record(EE_EXCEPTION_TCD_CODE).employee_data := l_status||'_'||g_ee_record(EE_TCD_CODE).employee_data;
2058: HR_UTILITY_TRACE(g_ee_record(EE_EXCEPTION_TCD_CODE).employee_tag || ' : '
2059: || g_ee_record(EE_EXCEPTION_TCD_CODE).employee_data);
2060:
2061: /*WAH Flag || PSD Code Exists Flag*/
2062: g_ee_record(EE_WAH_PSD_CODE_EXISTS).employee_data := l_wah_psd_code_exists;

Line 2063: HR_UTILITY_TRACE(g_ee_record(EE_WAH_PSD_CODE_EXISTS).employee_tag || ' : '

2059: || g_ee_record(EE_EXCEPTION_TCD_CODE).employee_data);
2060:
2061: /*WAH Flag || PSD Code Exists Flag*/
2062: g_ee_record(EE_WAH_PSD_CODE_EXISTS).employee_data := l_wah_psd_code_exists;
2063: HR_UTILITY_TRACE(g_ee_record(EE_WAH_PSD_CODE_EXISTS).employee_tag || ' : '
2064: || g_ee_record(EE_WAH_PSD_CODE_EXISTS).employee_data);
2065:
2066: /*Exception|| Work PSD Code: for use in templates*/
2067: g_ee_record(EE_EXCEPTION_WORK_PSD).employee_data := l_status||l_ee_work_psd_code;

Line 2068: HR_UTILITY_TRACE(g_ee_record(EE_EXCEPTION_WORK_PSD).employee_tag || ' : '

2064: || g_ee_record(EE_WAH_PSD_CODE_EXISTS).employee_data);
2065:
2066: /*Exception|| Work PSD Code: for use in templates*/
2067: g_ee_record(EE_EXCEPTION_WORK_PSD).employee_data := l_status||l_ee_work_psd_code;
2068: HR_UTILITY_TRACE(g_ee_record(EE_EXCEPTION_WORK_PSD).employee_tag || ' : '
2069: || g_ee_record(EE_EXCEPTION_WORK_PSD).employee_data);
2070:
2071: --
2072: l_final_xml_string := '';

Line 2090: HR_UTILITY_TRACE(l_data_item_xml);

2086: l_data_item_xml := '<'||g_ee_record(I).employee_tag||'>'||
2087: convert_special_char(nvl(g_ee_record(I).employee_data,' '))
2088: ||''|| EOL;
2089: l_final_xml_string := l_final_xml_string || l_data_item_xml;
2090: HR_UTILITY_TRACE(l_data_item_xml);
2091: END LOOP;
2092: l_final_xml_string := l_final_xml_string || ' 2093: || '>' || EOL;
2094:

Line 2098: HR_UTILITY_TRACE('Error Encountered While formating RS Record Data Item');

2094:
2095: --l_final_xml_string := l_final_xml_string || '' || EOL;
2096: EXCEPTION
2097: WHEN OTHERS THEN
2098: HR_UTILITY_TRACE('Error Encountered While formating RS Record Data Item');
2099: END;
2100: HR_UTILITY_TRACE(' RS Record Formatted Successfully Length '|| length(l_final_xml_string));
2101:
2102:

Line 2100: HR_UTILITY_TRACE(' RS Record Formatted Successfully Length '|| length(l_final_xml_string));

2096: EXCEPTION
2097: WHEN OTHERS THEN
2098: HR_UTILITY_TRACE('Error Encountered While formating RS Record Data Item');
2099: END;
2100: HR_UTILITY_TRACE(' RS Record Formatted Successfully Length '|| length(l_final_xml_string));
2101:
2102:
2103: l_final_xml_string := l_final_xml_string || '' || EOL;
2104: p_final_string := l_final_xml_string;

Line 2108: HR_UTILITY_TRACE('Error Encountered in procedure populate_arch_employee');

2104: p_final_string := l_final_xml_string;
2105: --}
2106: EXCEPTION
2107: WHEN OTHERS THEN
2108: HR_UTILITY_TRACE('Error Encountered in procedure populate_arch_employee');
2109: END populate_arch_employee; -- End of Procedure populate_arch_employee
2110:
2111:
2112: BEGIN

Line 2115: g_debug := hr_utility.debug_enabled;

2111:
2112: BEGIN
2113:
2114: g_proc_name := 'pay_us_psd_generic_extract.';
2115: g_debug := hr_utility.debug_enabled;
2116: g_document_type := 'LOCAL_PSD_XML';
2117: END pay_us_psd_generic_extract;