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_US_W2_GENERIC_EXTRACT dependencies on HR_UTILITY

Line 37: Name : HR_UTILITY_TRACE

33: g_debug boolean;
34: g_document_type varchar2(50);
35:
36: /****************************************************************************
37: Name : HR_UTILITY_TRACE
38: Description : This procedure prints debug messages.
39: *****************************************************************************/
40:
41: PROCEDURE HR_UTILITY_TRACE

Line 41: PROCEDURE HR_UTILITY_TRACE

37: Name : HR_UTILITY_TRACE
38: Description : This procedure prints debug messages.
39: *****************************************************************************/
40:
41: PROCEDURE HR_UTILITY_TRACE
42: (
43: P_TRC_DATA varchar2
44: ) AS
45: BEGIN

Line 47: hr_utility.trace(p_trc_data);

43: P_TRC_DATA varchar2
44: ) AS
45: BEGIN
46: IF g_debug THEN
47: hr_utility.trace(p_trc_data);
48: END IF;
49: END HR_UTILITY_TRACE;
50:
51: FUNCTION convert_special_char( p_data varchar2)

Line 49: END HR_UTILITY_TRACE;

45: BEGIN
46: IF g_debug THEN
47: hr_utility.trace(p_trc_data);
48: END IF;
49: END HR_UTILITY_TRACE;
50:
51: FUNCTION convert_special_char( p_data varchar2)
52: RETURN varchar2 IS
53: l_data VARCHAR2(2000);

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

106: --
107: -- Following Loop structure used to debug the Tag Values
108: --
109: FOR I IN 1 .. g_ra_no_of_tag LOOP
110: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '||ltr_ra_data_tag(i));
111: END LOOP;
112: END populate_ra_data_tag;
113:
114:

Line 591: -- HR_UTILITY_TRACE(l_final_xml_string);

587: FOR I IN 1 .. g_ra_no_of_tag LOOP
588: l_final_xml_string := l_final_xml_string || '<'||g_ra_record(I).submitter_tag||'>'||
589: convert_special_char(g_ra_record(I).submitter_data)
590: ||''|| EOL;
591: -- HR_UTILITY_TRACE(l_final_xml_string);
592: END LOOP;
593: HR_UTILITY_TRACE(l_final_xml_string);
594: p_final_string := l_final_xml_string;
595: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);

Line 593: HR_UTILITY_TRACE(l_final_xml_string);

589: convert_special_char(g_ra_record(I).submitter_data)
590: ||''|| EOL;
591: -- HR_UTILITY_TRACE(l_final_xml_string);
592: END LOOP;
593: HR_UTILITY_TRACE(l_final_xml_string);
594: p_final_string := l_final_xml_string;
595: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);
596: --pay_core_files.write_to_magtape_lob(l_final_xml_string);
597: --}

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

653: --
654: -- Following Loop structure used to debug the Tag Values
655: --
656: FOR I IN ltr_re_data_tag.first .. ltr_re_data_tag.last LOOP
657: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '||ltr_re_data_tag(i));
658: END LOOP;
659:
660: END populate_re_data_tag;
661:

Line 1134: -- HR_UTILITY_TRACE(l_final_xml_string);

1130: FOR I IN 1 .. g_ra_no_of_tag LOOP
1131: l_final_xml_string := l_final_xml_string || '<'||g_re_record(I).employer_tag||'>'||
1132: convert_special_char(g_re_record(I).employer_data)
1133: ||''|| EOL;
1134: -- HR_UTILITY_TRACE(l_final_xml_string);
1135: END LOOP;
1136: HR_UTILITY_TRACE(l_final_xml_string);
1137: p_final_string := l_final_xml_string;
1138: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);

Line 1136: HR_UTILITY_TRACE(l_final_xml_string);

1132: convert_special_char(g_re_record(I).employer_data)
1133: ||''|| EOL;
1134: -- HR_UTILITY_TRACE(l_final_xml_string);
1135: END LOOP;
1136: HR_UTILITY_TRACE(l_final_xml_string);
1137: p_final_string := l_final_xml_string;
1138: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);
1139: --pay_core_files.write_to_magtape_lob(l_final_xml_string);
1140: --}

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

1232: -- Following Loop structure used to debug the Tag Values
1233: --
1234: FOR I IN ltr_ee_data_tag.first .. ltr_ee_data_tag.last
1235: LOOP
1236: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '|| ltr_ee_data_tag(i));
1237: END LOOP;
1238: END populate_ee_data_tag;
1239:
1240: --

Line 1269: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '|| ltr_ee_locality_tag(i));

1265: -- Following Loop structure used to debug the Tag Values
1266: --
1267: FOR I IN ltr_ee_locality_tag.first .. ltr_ee_locality_tag.last
1268: LOOP
1269: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '|| ltr_ee_locality_tag(i));
1270: END LOOP;
1271: END populate_ee_locality_tag;
1272:
1273: --

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

2043: --
2044: -- End of setting User Entities to PL/Table
2045: --
2046:
2047: HR_UTILITY_TRACE('DBI Count '||to_char(ltr_ue_name_table.count));
2048: HR_UTILITY_TRACE('YE Archive Assignment Action Id '||
2049: to_char(p_ye_assignment_action_id));
2050:
2051: IF ltr_ue_name_table.count > 0 then

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

2044: -- End of setting User Entities to PL/Table
2045: --
2046:
2047: HR_UTILITY_TRACE('DBI Count '||to_char(ltr_ue_name_table.count));
2048: HR_UTILITY_TRACE('YE Archive Assignment Action Id '||
2049: to_char(p_ye_assignment_action_id));
2050:
2051: IF ltr_ue_name_table.count > 0 then
2052: FOR j IN ltr_ue_name_table.first .. ltr_ue_name_table.last

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

2090: ltr_ue_name_table(j).ue_name);
2091: ELSE
2092: ltr_ue_name_table(j).ue_value := ' ';
2093: END IF;
2094: HR_UTILITY_TRACE('DBI ' || ltr_ue_name_table(J).ue_data_level ||
2095: ' -('||to_char(j)|| ') : < '||ltr_ue_name_table(j).ue_name||
2096: ' > VALUE : < '|| ltr_ue_name_table(j).ue_value||' >');
2097: END LOOP;
2098: HR_UTILITY_TRACE('Status of Employee Record ' || l_status);

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

2094: HR_UTILITY_TRACE('DBI ' || ltr_ue_name_table(J).ue_data_level ||
2095: ' -('||to_char(j)|| ') : < '||ltr_ue_name_table(j).ue_name||
2096: ' > VALUE : < '|| ltr_ue_name_table(j).ue_value||' >');
2097: END LOOP;
2098: HR_UTILITY_TRACE('Status of Employee Record ' || l_status);
2099: END IF;
2100:
2101: /* ==================================================
2102: Get Employer or transmitter Company Information releated Submitter

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

2148: /* Deriving all data Items that are used for RW record */
2149:
2150: /* Record Identifier */
2151: g_ee_record(RW_RECORD_IDENTIFIER).employee_data := 'RW';
2152: HR_UTILITY_TRACE(g_ee_record(1).employee_tag || ' : '
2153: || g_ee_record(RW_RECORD_IDENTIFIER).employee_data);
2154: /* Employee, Social Security Number (SSN) */
2155: g_ee_record(EE_SSN).employee_data :=
2156: ltr_ue_name_table(1).ue_value;

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

2153: || g_ee_record(RW_RECORD_IDENTIFIER).employee_data);
2154: /* Employee, Social Security Number (SSN) */
2155: g_ee_record(EE_SSN).employee_data :=
2156: ltr_ue_name_table(1).ue_value;
2157: HR_UTILITY_TRACE(g_ee_record(EE_SSN).employee_tag || ' : '
2158: || g_ee_record(EE_SSN).employee_data);
2159:
2160: /* Employee, First Name */
2161: g_ee_record(EE_FIRST_NAME).employee_data :=

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

2159:
2160: /* Employee, First Name */
2161: g_ee_record(EE_FIRST_NAME).employee_data :=
2162: ltr_ue_name_table(2).ue_value;
2163: HR_UTILITY_TRACE(g_ee_record(EE_FIRST_NAME).employee_tag || ' : '
2164: || g_ee_record(EE_FIRST_NAME).employee_data);
2165:
2166: /* Employee, Middle Name or Initial */
2167: g_ee_record(EE_MIDDLE_INITIAL).employee_data :=

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

2165:
2166: /* Employee, Middle Name or Initial */
2167: g_ee_record(EE_MIDDLE_INITIAL).employee_data :=
2168: ltr_ue_name_table(3).ue_value;
2169: HR_UTILITY_TRACE(g_ee_record(EE_MIDDLE_INITIAL).employee_tag || ' : '
2170: || g_ee_record(EE_MIDDLE_INITIAL).employee_data);
2171:
2172: /* Employee, Last Name */
2173: g_ee_record(EE_LAST_NAME).employee_data :=

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

2171:
2172: /* Employee, Last Name */
2173: g_ee_record(EE_LAST_NAME).employee_data :=
2174: ltr_ue_name_table(4).ue_value;
2175: HR_UTILITY_TRACE(g_ee_record(EE_LAST_NAME).employee_tag || ' : '
2176: || g_ee_record(EE_LAST_NAME).employee_data);
2177:
2178: /* Employee, Name Suffix */
2179: g_ee_record(EE_SUFFIX).employee_data :=

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

2177:
2178: /* Employee, Name Suffix */
2179: g_ee_record(EE_SUFFIX).employee_data :=
2180: ltr_ue_name_table(5).ue_value;
2181: HR_UTILITY_TRACE(g_ee_record(EE_SUFFIX).employee_tag || ' : '
2182: || g_ee_record(EE_SUFFIX).employee_data);
2183:
2184: /* Employee, Location Address */
2185: g_ee_record(EE_LOCATION_ADDRESS).employee_data := empe_out_1;

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

2182: || g_ee_record(EE_SUFFIX).employee_data);
2183:
2184: /* Employee, Location Address */
2185: g_ee_record(EE_LOCATION_ADDRESS).employee_data := empe_out_1;
2186: HR_UTILITY_TRACE(g_ee_record(EE_LOCATION_ADDRESS).employee_tag || ' : '
2187: || g_ee_record(EE_LOCATION_ADDRESS).employee_data);
2188:
2189: /* Pos: 88 Len: 22 Desc: Employee, Delivery Address */
2190: g_ee_record(EE_DELIVERY_ADDRESS).employee_data := empe_out_2;

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

2187: || g_ee_record(EE_LOCATION_ADDRESS).employee_data);
2188:
2189: /* Pos: 88 Len: 22 Desc: Employee, Delivery Address */
2190: g_ee_record(EE_DELIVERY_ADDRESS).employee_data := empe_out_2;
2191: HR_UTILITY_TRACE(g_ee_record(EE_DELIVERY_ADDRESS).employee_tag || ' : '
2192: || g_ee_record(EE_DELIVERY_ADDRESS).employee_data);
2193:
2194: /* Employee, City */
2195: g_ee_record(EE_CITY).employee_data := empe_out_3;

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

2192: || g_ee_record(EE_DELIVERY_ADDRESS).employee_data);
2193:
2194: /* Employee, City */
2195: g_ee_record(EE_CITY).employee_data := empe_out_3;
2196: HR_UTILITY_TRACE(g_ee_record(EE_CITY).employee_tag || ' : '
2197: || g_ee_record(EE_CITY).employee_data);
2198:
2199: /* Employee, State Abbreviation */
2200: g_ee_record(EE_STATE_ABBREVIATION).employee_data := empe_out_4;

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

2197: || g_ee_record(EE_CITY).employee_data);
2198:
2199: /* Employee, State Abbreviation */
2200: g_ee_record(EE_STATE_ABBREVIATION).employee_data := empe_out_4;
2201: HR_UTILITY_TRACE(g_ee_record(EE_STATE_ABBREVIATION).employee_tag || ' : '
2202: || g_ee_record(EE_STATE_ABBREVIATION).employee_data);
2203:
2204: /* Employee, Zip Code */
2205: g_ee_record(EE_ZIP_CODE).employee_data := empe_out_5;

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

2202: || g_ee_record(EE_STATE_ABBREVIATION).employee_data);
2203:
2204: /* Employee, Zip Code */
2205: g_ee_record(EE_ZIP_CODE).employee_data := empe_out_5;
2206: HR_UTILITY_TRACE(g_ee_record(EE_ZIP_CODE).employee_tag || ' : '
2207: || g_ee_record(EE_ZIP_CODE).employee_data);
2208:
2209: /* Employee, Zip Code Extension */
2210: g_ee_record(EE_ZIP_CODE_EXTENSION).employee_data :=

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

2208:
2209: /* Employee, Zip Code Extension */
2210: g_ee_record(EE_ZIP_CODE_EXTENSION).employee_data :=
2211: empe_out_6;
2212: HR_UTILITY_TRACE(g_ee_record(EE_ZIP_CODE_EXTENSION).employee_tag || ' : '
2213: || g_ee_record(EE_ZIP_CODE_EXTENSION).employee_data);
2214:
2215: /* Employee, Foreign State - Province */
2216: g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data

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

2214:
2215: /* Employee, Foreign State - Province */
2216: g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data
2217: := empe_out_7;
2218: HR_UTILITY_TRACE(g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_tag || ' : '
2219: || g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data);
2220:
2221: /* Employee, Foreign Postal Code */
2222: g_ee_record(EE_FOREIGN_POSTAL_CODE).employee_data

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

2220:
2221: /* Employee, Foreign Postal Code */
2222: g_ee_record(EE_FOREIGN_POSTAL_CODE).employee_data
2223: := empe_out_8;
2224: HR_UTILITY_TRACE(g_ee_record(EE_FOREIGN_POSTAL_CODE).employee_tag || ' : '
2225: || g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data);
2226:
2227: /* Pos: 186 Len: 2 Desc: Employee, Country Code */
2228: g_ee_record(EE_COUNTRY_CODE).employee_data

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

2226:
2227: /* Pos: 186 Len: 2 Desc: Employee, Country Code */
2228: g_ee_record(EE_COUNTRY_CODE).employee_data
2229: := empe_out_9;
2230: HR_UTILITY_TRACE(g_ee_record(EE_COUNTRY_CODE).employee_tag || ' : '
2231: || g_ee_record(EE_COUNTRY_CODE).employee_data);
2232:
2233: /* Pos: 188 Len: 11 Desc: Wages, Tips and Other Compensation */
2234: g_ee_record(FIT_GROSS_WAGES).employee_data :=

Line 2242: HR_UTILITY_TRACE(g_ee_record(FIT_GROSS_WAGES).employee_tag || ' : '

2238: to_number(ltr_ue_name_table(43).ue_value) +
2239: to_number(ltr_ue_name_table(44).ue_value) +
2240: to_number(ltr_ue_name_table(45).ue_value));
2241:
2242: HR_UTILITY_TRACE(g_ee_record(FIT_GROSS_WAGES).employee_tag || ' : '
2243: || g_ee_record(FIT_GROSS_WAGES).employee_data);
2244:
2245: /*
2246: FIT_GROSS_WAGES = A_REGULAR_EARNINGS_PER_GRE_YTD +

Line 2256: HR_UTILITY_TRACE(g_ee_record(FIT_WITHHELD).employee_tag || ' : '

2252: */
2253:
2254: /* Federal Income Tax Withheld */
2255: g_ee_record(FIT_WITHHELD).employee_data := ltr_ue_name_table(7).ue_value;
2256: HR_UTILITY_TRACE(g_ee_record(FIT_WITHHELD).employee_tag || ' : '
2257: || g_ee_record(FIT_WITHHELD).employee_data);
2258:
2259: /* Pos: 210 Len: 11 Desc: Social Security Wages
2260: SS_WAGES := A_SS_EE_TAXABLE_PER_GRE_YTD

Line 2265: HR_UTILITY_TRACE(g_ee_record(SS_WAGES).employee_tag || ' : '

2261: - A_W2_BOX_7_PER_GRE_YTD
2262: */
2263: g_ee_record(SS_WAGES).employee_data := to_char(to_number(ltr_ue_name_table(8).ue_value)
2264: - to_number(ltr_ue_name_table(12).ue_value));
2265: HR_UTILITY_TRACE(g_ee_record(SS_WAGES).employee_tag || ' : '
2266: || g_ee_record(SS_WAGES).employee_data);
2267:
2268: /* Social Security Tax Withheld */
2269: g_ee_record(SS_TAX_WITHHELD).employee_data := ltr_ue_name_table(9).ue_value;

Line 2285: HR_UTILITY_TRACE(g_ee_record(W2_DEPENDENT_CARE).employee_tag || ' : '

2281: g_ee_record(EIC_ADVANCE).employee_data := ltr_ue_name_table(13).ue_value;
2282:
2283: /* Dependent Care Benefits */
2284: g_ee_record(W2_DEPENDENT_CARE).employee_data := ltr_ue_name_table(14).ue_value;
2285: HR_UTILITY_TRACE(g_ee_record(W2_DEPENDENT_CARE).employee_tag || ' : '
2286: || g_ee_record(W2_DEPENDENT_CARE).employee_data);
2287:
2288: /* Deferred Compensation Contributions to Section 401(k) */
2289: g_ee_record(W2_401K).employee_data := ltr_ue_name_table(15).ue_value;

Line 2299: HR_UTILITY_TRACE(g_ee_record(W2_457).employee_tag || ' : '

2295: g_ee_record(W2_408K).employee_data := ltr_ue_name_table(17).ue_value;
2296:
2297: /* Deferred Compensation Contributions to Section 457(b) */
2298: g_ee_record(W2_457).employee_data := ltr_ue_name_table(18).ue_value;
2299: HR_UTILITY_TRACE(g_ee_record(W2_457).employee_tag || ' : '
2300: || g_ee_record(W2_457).employee_data);
2301:
2302: /* Deferred Compensation Contributions to Section 501(c)(18)(D) */
2303: g_ee_record(W2_501C).employee_data := ltr_ue_name_table(19).ue_value;

Line 2327: HR_UTILITY_TRACE(g_ee_record(NON_QUAL_NOT_457).employee_tag || ' : '

2323: */
2324: g_ee_record(NON_QUAL_NOT_457).employee_data :=
2325: to_char(to_number(ltr_ue_name_table(20).ue_value) -
2326: to_number(ltr_ue_name_table(21).ue_value));
2327: HR_UTILITY_TRACE(g_ee_record(NON_QUAL_NOT_457).employee_tag || ' : '
2328: || g_ee_record(NON_QUAL_NOT_457).employee_data);
2329:
2330: /* Non-Taxable Combat Pay (Not for Puerto Rico) */
2331: g_ee_record(W2_NONTAX_COMBAT).employee_data := ltr_ue_name_table(39).ue_value;

Line 2344: HR_UTILITY_TRACE(g_ee_record(W2_ROTH_401K).employee_tag || ' : '

2340: g_ee_record(W2_NONQUAL_DEF_COMP).employee_data := ltr_ue_name_table(40).ue_value;
2341:
2342: /* Designated Roth Contributions to a section 401(k) Plan */
2343: g_ee_record(W2_ROTH_401K).employee_data := ltr_ue_name_table(41).ue_value;
2344: HR_UTILITY_TRACE(g_ee_record(W2_ROTH_401K).employee_tag || ' : '
2345: || g_ee_record(W2_ROTH_401K).employee_data);
2346:
2347: /* Designated Roth Contributions Und sec 403(b) Plan */
2348: g_ee_record(W2_ROTH_403B).employee_data := ltr_ue_name_table(42).ue_value;

Line 2349: HR_UTILITY_TRACE(g_ee_record(W2_ROTH_403B).employee_tag || ' : '

2345: || g_ee_record(W2_ROTH_401K).employee_data);
2346:
2347: /* Designated Roth Contributions Und sec 403(b) Plan */
2348: g_ee_record(W2_ROTH_403B).employee_data := ltr_ue_name_table(42).ue_value;
2349: HR_UTILITY_TRACE(g_ee_record(W2_ROTH_403B).employee_tag || ' : '
2350: || g_ee_record(W2_ROTH_403B).employee_data);
2351:
2352: /* Statutory Employee Indicator */
2353: IF ltr_ue_name_table(24).ue_value = 'Y' THEN

Line 2358: HR_UTILITY_TRACE(g_ee_record(W2_ASG_STATUTORY_EMPLOYEE).employee_tag || ' : '

2354: g_ee_record(W2_ASG_STATUTORY_EMPLOYEE).employee_data := '1';
2355: ELSE
2356: g_ee_record(W2_ASG_STATUTORY_EMPLOYEE).employee_data := '0';
2357: END IF;
2358: HR_UTILITY_TRACE(g_ee_record(W2_ASG_STATUTORY_EMPLOYEE).employee_tag || ' : '
2359: || g_ee_record(W2_ASG_STATUTORY_EMPLOYEE).employee_data);
2360:
2361: /* Retirement Plan Indicator */
2362: IF (( to_number(ltr_ue_name_table(25).ue_value) > 0) OR

Line 2372: HR_UTILITY_TRACE(g_ee_record(RETIREMENT_PLAN_INDICATOR).employee_tag || ' : '

2368: g_ee_record(RETIREMENT_PLAN_INDICATOR).employee_data := '1';
2369: ELSE
2370: g_ee_record(RETIREMENT_PLAN_INDICATOR).employee_data := '0';
2371: END IF;
2372: HR_UTILITY_TRACE(g_ee_record(RETIREMENT_PLAN_INDICATOR).employee_tag || ' : '
2373: || g_ee_record(RETIREMENT_PLAN_INDICATOR).employee_data);
2374:
2375: /* Third-Party Sick Pay Indicator */
2376: IF to_number(ltr_ue_name_table(38).ue_value) > 0

Line 2382: HR_UTILITY_TRACE(g_ee_record(W2_TP_SICK_PAY_IND).employee_tag || ' : '

2378: g_ee_record(W2_TP_SICK_PAY_IND).employee_data := '1';
2379: ELSE
2380: g_ee_record(W2_TP_SICK_PAY_IND).employee_data := '0';
2381: END IF;
2382: HR_UTILITY_TRACE(g_ee_record(W2_TP_SICK_PAY_IND).employee_tag || ' : '
2383: || g_ee_record(W2_TP_SICK_PAY_IND).employee_data);
2384:
2385: /* Income Tax Withheld by Third Party Payer
2386: This balance is not reported in RW record but summ total is reported at the GRE level in RT record

Line 2389: HR_UTILITY_TRACE(g_ee_record(FIT_WITHHELD_THIRD_PARTY).employee_tag || ' : '

2385: /* Income Tax Withheld by Third Party Payer
2386: This balance is not reported in RW record but summ total is reported at the GRE level in RT record
2387: */
2388: g_ee_record(FIT_WITHHELD_THIRD_PARTY).employee_data := ltr_ue_name_table(27).ue_value;
2389: HR_UTILITY_TRACE(g_ee_record(FIT_WITHHELD_THIRD_PARTY).employee_tag || ' : '
2390: || g_ee_record(FIT_WITHHELD_THIRD_PARTY).employee_data);
2391:
2392: /* RO Record Data Items fetched to build XML components */
2393: out_ret_contrib_perjdgreytd :=

Line 2455: HR_UTILITY_TRACE(g_ee_record(RO_RECORD_IDENTIFIER).employee_tag || ' : '

2451: END IF;
2452:
2453: /* RO Record Identifier */
2454: g_ee_record(RO_RECORD_IDENTIFIER).employee_data := 'RO';
2455: HR_UTILITY_TRACE(g_ee_record(RO_RECORD_IDENTIFIER).employee_tag || ' : '
2456: || g_ee_record(RO_RECORD_IDENTIFIER).employee_data);
2457:
2458: /* Allocated Tips */
2459: g_ee_record(RO_W2_BOX_8).employee_data := ltr_ue_name_table(46).ue_value;

Line 2460: HR_UTILITY_TRACE(g_ee_record(RO_W2_BOX_8).employee_tag || ' : '

2456: || g_ee_record(RO_RECORD_IDENTIFIER).employee_data);
2457:
2458: /* Allocated Tips */
2459: g_ee_record(RO_W2_BOX_8).employee_data := ltr_ue_name_table(46).ue_value;
2460: HR_UTILITY_TRACE(g_ee_record(RO_W2_BOX_8).employee_tag || ' : '
2461: || g_ee_record(RO_W2_BOX_8).employee_data);
2462:
2463: /* Uncollected Employee Tax on Tips */
2464: g_ee_record(RO_UNCOLLECT_TAX_ON_TIPS).employee_data :=

Line 2467: HR_UTILITY_TRACE(g_ee_record(RO_UNCOLLECT_TAX_ON_TIPS).employee_tag || ' : '

2463: /* Uncollected Employee Tax on Tips */
2464: g_ee_record(RO_UNCOLLECT_TAX_ON_TIPS).employee_data :=
2465: to_char(to_number(ltr_ue_name_table(47).ue_value) +
2466: to_number(ltr_ue_name_table(48).ue_value));
2467: HR_UTILITY_TRACE(g_ee_record(RO_UNCOLLECT_TAX_ON_TIPS).employee_tag || ' : '
2468: || g_ee_record(RO_UNCOLLECT_TAX_ON_TIPS).employee_data);
2469:
2470: /****************************************************************************/
2471: /* Locations 34 to 66 Do not apply to Puerto Rico, Virgin Islands, American */

Line 2477: HR_UTILITY_TRACE(g_ee_record(RO_W2_MSA).employee_tag || ' : '

2473: /****************************************************************************/
2474: /* Medical Savings Account */
2475: g_ee_record(RO_W2_MSA).employee_data :=
2476: ltr_ue_name_table(49).ue_value;
2477: HR_UTILITY_TRACE(g_ee_record(RO_W2_MSA).employee_tag || ' : '
2478: || g_ee_record(RO_W2_MSA).employee_data);
2479:
2480: /* Simple Retirement Account */
2481: g_ee_record(RO_W2_408P).employee_data :=

Line 2483: HR_UTILITY_TRACE(g_ee_record(RO_W2_408P).employee_tag || ' : '

2479:
2480: /* Simple Retirement Account */
2481: g_ee_record(RO_W2_408P).employee_data :=
2482: ltr_ue_name_table(50).ue_value;
2483: HR_UTILITY_TRACE(g_ee_record(RO_W2_408P).employee_tag || ' : '
2484: || g_ee_record(RO_W2_408P).employee_data);
2485:
2486: /* Qualified Adoption Expenses */
2487: g_ee_record(RO_W2_ADOPTION).employee_data :=

Line 2489: HR_UTILITY_TRACE(g_ee_record(RO_W2_ADOPTION).employee_tag || ' : '

2485:
2486: /* Qualified Adoption Expenses */
2487: g_ee_record(RO_W2_ADOPTION).employee_data :=
2488: ltr_ue_name_table(51).ue_value;
2489: HR_UTILITY_TRACE(g_ee_record(RO_W2_ADOPTION).employee_tag || ' : '
2490: || g_ee_record(RO_W2_ADOPTION).employee_data);
2491: /****************************************************************************/
2492: /* Uncollected Social Security or RPTA Tax on Cost
2493: of Group Term Life Insurance Over $50,000 */

Line 2496: HR_UTILITY_TRACE(g_ee_record(RO_W2_UNCOLL_SS_GTL).employee_tag || ' : '

2492: /* Uncollected Social Security or RPTA Tax on Cost
2493: of Group Term Life Insurance Over $50,000 */
2494: g_ee_record(RO_W2_UNCOLL_SS_GTL).employee_data :=
2495: ltr_ue_name_table(52).ue_value;
2496: HR_UTILITY_TRACE(g_ee_record(RO_W2_UNCOLL_SS_GTL).employee_tag || ' : '
2497: || g_ee_record(RO_W2_UNCOLL_SS_GTL).employee_data);
2498: /* Uncollected Medicare Tax on Cost of Group Term Life Insurance Over $50,000 */
2499: g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_data :=
2500: ltr_ue_name_table(53).ue_value;

Line 2501: HR_UTILITY_TRACE(g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_tag || ' : '

2497: || g_ee_record(RO_W2_UNCOLL_SS_GTL).employee_data);
2498: /* Uncollected Medicare Tax on Cost of Group Term Life Insurance Over $50,000 */
2499: g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_data :=
2500: ltr_ue_name_table(53).ue_value;
2501: HR_UTILITY_TRACE(g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_tag || ' : '
2502: || g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_data);
2503: /* Income Under Sec 409A on Non-Qual Def Comp Plan */
2504: g_ee_record(RO_W2_409A_NONQUAL_INCOM).employee_data :=
2505: ltr_ue_name_table(54).ue_value;

Line 2506: HR_UTILITY_TRACE(g_ee_record(RO_W2_409A_NONQUAL_INCOM).employee_tag || ' : '

2502: || g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_data);
2503: /* Income Under Sec 409A on Non-Qual Def Comp Plan */
2504: g_ee_record(RO_W2_409A_NONQUAL_INCOM).employee_data :=
2505: ltr_ue_name_table(54).ue_value;
2506: HR_UTILITY_TRACE(g_ee_record(RO_W2_409A_NONQUAL_INCOM).employee_tag || ' : '
2507: || g_ee_record(RO_W2_409A_NONQUAL_INCOM).employee_data);
2508:
2509: /****************************************************************************/
2510: /* Locations 265 to 362 are for Puerto Rico Employees ONLY. */

Line 2518: HR_UTILITY_TRACE('Tax Jurisdiction Code '||l_tax_tax_jurisdiction);

2514: l_tax_tax_jurisdiction :=
2515: hr_us_w2_rep.get_w2_tax_unit_item (p_tax_unit_id,
2516: p_payroll_action_id,
2517: 'A_LC_W2_REPORTING_RULES_ORG_TAX_JURISDICTION');
2518: HR_UTILITY_TRACE('Tax Jurisdiction Code '||l_tax_tax_jurisdiction);
2519:
2520: IF l_tax_tax_jurisdiction = 'P' THEN
2521: g_ee_record(RO_CIVIL_STATUS).employee_data := ro_out_6;
2522: ELSE

Line 2525: HR_UTILITY_TRACE(g_ee_record(RO_CIVIL_STATUS).employee_tag || ' : '

2521: g_ee_record(RO_CIVIL_STATUS).employee_data := ro_out_6;
2522: ELSE
2523: g_ee_record(RO_CIVIL_STATUS).employee_data := ' ';
2524: END IF;
2525: HR_UTILITY_TRACE(g_ee_record(RO_CIVIL_STATUS).employee_tag || ' : '
2526: || g_ee_record(RO_CIVIL_STATUS).employee_data);
2527:
2528: /* Spouse Social Security Number (SSN) */
2529: g_ee_record(RO_SPOUSE_SSN).employee_data := ro_out_7;

Line 2530: HR_UTILITY_TRACE(g_ee_record(RO_SPOUSE_SSN).employee_tag || ' : '

2526: || g_ee_record(RO_CIVIL_STATUS).employee_data);
2527:
2528: /* Spouse Social Security Number (SSN) */
2529: g_ee_record(RO_SPOUSE_SSN).employee_data := ro_out_7;
2530: HR_UTILITY_TRACE(g_ee_record(RO_SPOUSE_SSN).employee_tag || ' : '
2531: || g_ee_record(RO_SPOUSE_SSN).employee_data);
2532:
2533: /* Wages Subject to Puerto Rico Tax */
2534: g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_data := to_char(nout_wages_subject);

Line 2535: HR_UTILITY_TRACE(g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_tag || ' : '

2531: || g_ee_record(RO_SPOUSE_SSN).employee_data);
2532:
2533: /* Wages Subject to Puerto Rico Tax */
2534: g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_data := to_char(nout_wages_subject);
2535: HR_UTILITY_TRACE(g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_tag || ' : '
2536: || g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_data);
2537:
2538: /* Commissions Subject to Puerto Rico Tax */
2539: g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabale_com_per);

Line 2540: HR_UTILITY_TRACE(g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_tag || ' : '

2536: || g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_data);
2537:
2538: /* Commissions Subject to Puerto Rico Tax */
2539: g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabale_com_per);
2540: HR_UTILITY_TRACE(g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_tag || ' : '
2541: || g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_data);
2542:
2543: /* Allowances Subject to Puerto Rico Tax */
2544: g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabable_allow_per);

Line 2545: HR_UTILITY_TRACE(g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_tag || ' : '

2541: || g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_data);
2542:
2543: /* Allowances Subject to Puerto Rico Tax */
2544: g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabable_allow_per);
2545: HR_UTILITY_TRACE(g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_tag || ' : '
2546: || g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_data);
2547:
2548: /* Tips Subject to Puerto Rico Tax */
2549: g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabale_tips_per);

Line 2550: HR_UTILITY_TRACE(g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_tag || ' : '

2546: || g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_data);
2547:
2548: /* Tips Subject to Puerto Rico Tax */
2549: g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabale_tips_per);
2550: HR_UTILITY_TRACE(g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_tag || ' : '
2551: || g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_data);
2552:
2553: /* Total Wages, Commissions, Tips, and Allowances Subject to Puerto Rico Tax */
2554: g_ee_record(RO_W2_STATE_WAGES).employee_data := to_char(nout_total_w2_state_wages);

Line 2555: HR_UTILITY_TRACE(g_ee_record(RO_W2_STATE_WAGES).employee_tag || ' : '

2551: || g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_data);
2552:
2553: /* Total Wages, Commissions, Tips, and Allowances Subject to Puerto Rico Tax */
2554: g_ee_record(RO_W2_STATE_WAGES).employee_data := to_char(nout_total_w2_state_wages);
2555: HR_UTILITY_TRACE(g_ee_record(RO_W2_STATE_WAGES).employee_tag || ' : '
2556: || g_ee_record(RO_W2_STATE_WAGES).employee_data);
2557:
2558: /* Puerto Rico Tax Withheld */
2559: g_ee_record(RO_PR_TAX_WITHHELD).employee_data := to_char(nout_sit_with_per);

Line 2560: HR_UTILITY_TRACE(g_ee_record(RO_PR_TAX_WITHHELD).employee_tag || ' : '

2556: || g_ee_record(RO_W2_STATE_WAGES).employee_data);
2557:
2558: /* Puerto Rico Tax Withheld */
2559: g_ee_record(RO_PR_TAX_WITHHELD).employee_data := to_char(nout_sit_with_per);
2560: HR_UTILITY_TRACE(g_ee_record(RO_PR_TAX_WITHHELD).employee_tag || ' : '
2561: || g_ee_record(RO_PR_TAX_WITHHELD).employee_data);
2562:
2563: /* Retirement Fund Annual Contributions */
2564: g_ee_record(RO_RETIREMENT_CONTRIB).employee_data := to_char(nout_ret_contrib_perjdgreytd);

Line 2565: HR_UTILITY_TRACE(g_ee_record(RO_RETIREMENT_CONTRIB).employee_tag || ' : '

2561: || g_ee_record(RO_PR_TAX_WITHHELD).employee_data);
2562:
2563: /* Retirement Fund Annual Contributions */
2564: g_ee_record(RO_RETIREMENT_CONTRIB).employee_data := to_char(nout_ret_contrib_perjdgreytd);
2565: HR_UTILITY_TRACE(g_ee_record(RO_RETIREMENT_CONTRIB).employee_tag || ' : '
2566: || g_ee_record(RO_RETIREMENT_CONTRIB).employee_data);
2567:
2568: /* Formating RS Record Data Items */
2569:

Line 2572: HR_UTILITY_TRACE(g_ee_record(RS_TAXING_ENTITY_CODE).employee_tag || ' : '

2568: /* Formating RS Record Data Items */
2569:
2570: /* Retirement Fund Annual Contributions */
2571: g_ee_record(RS_TAXING_ENTITY_CODE).employee_data := ' ';
2572: HR_UTILITY_TRACE(g_ee_record(RS_TAXING_ENTITY_CODE).employee_tag || ' : '
2573: || g_ee_record(RS_TAXING_ENTITY_CODE).employee_data);
2574:
2575: /* Optional Code */
2576: g_ee_record(RS_OPTIONAL_CODE).employee_data := ' ';

Line 2577: HR_UTILITY_TRACE(g_ee_record(RS_OPTIONAL_CODE).employee_tag || ' : '

2573: || g_ee_record(RS_TAXING_ENTITY_CODE).employee_data);
2574:
2575: /* Optional Code */
2576: g_ee_record(RS_OPTIONAL_CODE).employee_data := ' ';
2577: HR_UTILITY_TRACE(g_ee_record(RS_OPTIONAL_CODE).employee_tag || ' : '
2578: || g_ee_record(RS_OPTIONAL_CODE).employee_data);
2579:
2580: /* Reporting Period */
2581: g_ee_record(RS_REPORTING_PERIOD).employee_data := l_reporting_period;

Line 2582: HR_UTILITY_TRACE(g_ee_record(RS_REPORTING_PERIOD).employee_tag || ' : '

2578: || g_ee_record(RS_OPTIONAL_CODE).employee_data);
2579:
2580: /* Reporting Period */
2581: g_ee_record(RS_REPORTING_PERIOD).employee_data := l_reporting_period;
2582: HR_UTILITY_TRACE(g_ee_record(RS_REPORTING_PERIOD).employee_tag || ' : '
2583: || g_ee_record(RS_REPORTING_PERIOD).employee_data);
2584:
2585: /* State Quarterly Unemployment Insurance Total Wages */
2586: g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_data := '0';

Line 2587: HR_UTILITY_TRACE(g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_tag || ' : '

2583: || g_ee_record(RS_REPORTING_PERIOD).employee_data);
2584:
2585: /* State Quarterly Unemployment Insurance Total Wages */
2586: g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_data := '0';
2587: HR_UTILITY_TRACE(g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_tag || ' : '
2588: || g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_data);
2589:
2590: /* State Quarterly Unemployment Total Taxable Wages */
2591: g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_data := '0';

Line 2592: HR_UTILITY_TRACE(g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_tag || ' : '

2588: || g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_data);
2589:
2590: /* State Quarterly Unemployment Total Taxable Wages */
2591: g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_data := '0';
2592: HR_UTILITY_TRACE(g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_tag || ' : '
2593: || g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_data);
2594:
2595: /* Number of Weeks Worked */
2596: g_ee_record(RS_WEEKS_WORKED).employee_data := ' ';

Line 2597: HR_UTILITY_TRACE(g_ee_record(RS_WEEKS_WORKED).employee_tag || ' : '

2593: || g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_data);
2594:
2595: /* Number of Weeks Worked */
2596: g_ee_record(RS_WEEKS_WORKED).employee_data := ' ';
2597: HR_UTILITY_TRACE(g_ee_record(RS_WEEKS_WORKED).employee_tag || ' : '
2598: || g_ee_record(RS_WEEKS_WORKED).employee_data);
2599:
2600: /* Date First Employed */
2601: g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_data := ltr_ue_name_table(55).ue_value;

Line 2602: HR_UTILITY_TRACE(g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_tag || ' : '

2598: || g_ee_record(RS_WEEKS_WORKED).employee_data);
2599:
2600: /* Date First Employed */
2601: g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_data := ltr_ue_name_table(55).ue_value;
2602: HR_UTILITY_TRACE(g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_tag || ' : '
2603: || g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_data);
2604:
2605: /* Date of Separation */
2606: g_ee_record(RS_DATE_OF_SEPARATION).employee_data := NVL(trim(ltr_ue_name_table(56).ue_value),' ');

Line 2607: HR_UTILITY_TRACE(g_ee_record(RS_DATE_OF_SEPARATION).employee_tag || ' : '

2603: || g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_data);
2604:
2605: /* Date of Separation */
2606: g_ee_record(RS_DATE_OF_SEPARATION).employee_data := NVL(trim(ltr_ue_name_table(56).ue_value),' ');
2607: HR_UTILITY_TRACE(g_ee_record(RS_DATE_OF_SEPARATION).employee_tag || ' : '
2608: || g_ee_record(RS_DATE_OF_SEPARATION).employee_data);
2609:
2610: /* State Employer Account Number */
2611: g_ee_record(RS_STATE_ER_ACCT_NUM).employee_data :=

Line 2613: HR_UTILITY_TRACE(g_ee_record(RS_STATE_ER_ACCT_NUM).employee_tag || ' : '

2609:
2610: /* State Employer Account Number */
2611: g_ee_record(RS_STATE_ER_ACCT_NUM).employee_data :=
2612: replace(replace(nvl(replace(ltr_ue_name_table(73).ue_value,' '), ' ') ,'-'),'/');
2613: HR_UTILITY_TRACE(g_ee_record(RS_STATE_ER_ACCT_NUM).employee_tag || ' : '
2614: || g_ee_record(RS_STATE_ER_ACCT_NUM).employee_data);
2615:
2616: /* State Code */
2617:

Line 2619: HR_UTILITY_TRACE(g_ee_record(RS_STATE_CODE).employee_tag || ' : '

2615:
2616: /* State Code */
2617:
2618: g_ee_record(RS_STATE_CODE).employee_data := ltr_ue_name_table(72).ue_value;
2619: HR_UTILITY_TRACE(g_ee_record(RS_STATE_CODE).employee_tag || ' : '
2620: || g_ee_record(RS_STATE_CODE).employee_data);
2621:
2622: /* State Taxable Wages
2623: A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD +

Line 2632: HR_UTILITY_TRACE(g_ee_record(RS_STATE_WAGES).employee_tag || ' : '

2628: to_number(ltr_ue_name_table(64).ue_value) -
2629: to_number(ltr_ue_name_table(65).ue_value);
2630:
2631: g_ee_record(RS_STATE_WAGES).employee_data := to_char(l_state_wages);
2632: HR_UTILITY_TRACE(g_ee_record(RS_STATE_WAGES).employee_tag || ' : '
2633: || g_ee_record(RS_STATE_WAGES).employee_data);
2634:
2635: /* SIT Withheld */
2636: g_ee_record(RS_SIT_WITHHELD).employee_data := ltr_ue_name_table(68).ue_value;

Line 2637: HR_UTILITY_TRACE(g_ee_record(RS_SIT_WITHHELD).employee_tag || ' : '

2633: || g_ee_record(RS_STATE_WAGES).employee_data);
2634:
2635: /* SIT Withheld */
2636: g_ee_record(RS_SIT_WITHHELD).employee_data := ltr_ue_name_table(68).ue_value;
2637: HR_UTILITY_TRACE(g_ee_record(RS_SIT_WITHHELD).employee_tag || ' : '
2638: || g_ee_record(RS_SIT_WITHHELD).employee_data);
2639:
2640: /* Other State Data*/
2641: g_ee_record(RS_OTHER_STATE_DATA).employee_data := ' ';

Line 2642: HR_UTILITY_TRACE(g_ee_record(RS_OTHER_STATE_DATA).employee_tag || ' : '

2638: || g_ee_record(RS_SIT_WITHHELD).employee_data);
2639:
2640: /* Other State Data*/
2641: g_ee_record(RS_OTHER_STATE_DATA).employee_data := ' ';
2642: HR_UTILITY_TRACE(g_ee_record(RS_OTHER_STATE_DATA).employee_tag || ' : '
2643: || g_ee_record(RS_OTHER_STATE_DATA).employee_data);
2644:
2645: /* State EIC Advance*/
2646: g_ee_record(RS_STEIC_ADVANCE).employee_data :=ltr_ue_name_table(69).ue_value;

Line 2647: HR_UTILITY_TRACE(g_ee_record(RS_STEIC_ADVANCE).employee_tag || ' : '

2643: || g_ee_record(RS_OTHER_STATE_DATA).employee_data);
2644:
2645: /* State EIC Advance*/
2646: g_ee_record(RS_STEIC_ADVANCE).employee_data :=ltr_ue_name_table(69).ue_value;
2647: HR_UTILITY_TRACE(g_ee_record(RS_STEIC_ADVANCE).employee_tag || ' : '
2648: || g_ee_record(RS_STEIC_ADVANCE).employee_data);
2649:
2650: /* SUI Employee Withheld */
2651: g_ee_record(RS_SUI_EE_WITHHELD).employee_data := ltr_ue_name_table(70).ue_value;

Line 2652: HR_UTILITY_TRACE(g_ee_record(RS_SUI_EE_WITHHELD).employee_tag || ' : '

2648: || g_ee_record(RS_STEIC_ADVANCE).employee_data);
2649:
2650: /* SUI Employee Withheld */
2651: g_ee_record(RS_SUI_EE_WITHHELD).employee_data := ltr_ue_name_table(70).ue_value;
2652: HR_UTILITY_TRACE(g_ee_record(RS_SUI_EE_WITHHELD).employee_tag || ' : '
2653: || g_ee_record(RS_SUI_EE_WITHHELD).employee_data);
2654:
2655: /* SDI Employee Withheld */
2656: g_ee_record(RS_SDI_EE_WITHHELD).employee_data := ltr_ue_name_table(71).ue_value;

Line 2657: HR_UTILITY_TRACE(g_ee_record(RS_SDI_EE_WITHHELD).employee_tag || ' : '

2653: || g_ee_record(RS_SUI_EE_WITHHELD).employee_data);
2654:
2655: /* SDI Employee Withheld */
2656: g_ee_record(RS_SDI_EE_WITHHELD).employee_data := ltr_ue_name_table(71).ue_value;
2657: HR_UTILITY_TRACE(g_ee_record(RS_SDI_EE_WITHHELD).employee_tag || ' : '
2658: || g_ee_record(RS_SDI_EE_WITHHELD).employee_data);
2659:
2660: /* Supplemental Data 1 */
2661: g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_data := ' ';

Line 2662: HR_UTILITY_TRACE(g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_tag || ' : '

2658: || g_ee_record(RS_SDI_EE_WITHHELD).employee_data);
2659:
2660: /* Supplemental Data 1 */
2661: g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_data := ' ';
2662: HR_UTILITY_TRACE(g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_tag || ' : '
2663: || g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_data);
2664:
2665: /* Supplemental Data 2 */
2666: g_ee_record(RS_SUPPLEMENTAL_DATA_2).employee_data := ' ';

Line 2667: HR_UTILITY_TRACE(g_ee_record(RS_SUPPLEMENTAL_DATA_2).employee_tag || ' : '

2663: || g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_data);
2664:
2665: /* Supplemental Data 2 */
2666: g_ee_record(RS_SUPPLEMENTAL_DATA_2).employee_data := ' ';
2667: HR_UTILITY_TRACE(g_ee_record(RS_SUPPLEMENTAL_DATA_2).employee_tag || ' : '
2668: || g_ee_record(RS_SUPPLEMENTAL_DATA_2).employee_data);
2669:
2670: --
2671: -- Locality Data Items

Line 2673: HR_UTILITY_TRACE('Processing Locality Level Data for the Employee');

2669:
2670: --
2671: -- Locality Data Items
2672: --
2673: HR_UTILITY_TRACE('Processing Locality Level Data for the Employee');
2674:
2675: IF p_locality_code = 'NULL' THEN
2676: l_locality_code := NULL;
2677: ELSE

Line 2728: HR_UTILITY_TRACE('YE Assignment_Action_Id '|| to_char(p_ye_assignment_action_id));

2724: ltr_ue_locality(k).negative_check := 'Y';
2725:
2726:
2727:
2728: HR_UTILITY_TRACE('YE Assignment_Action_Id '|| to_char(p_ye_assignment_action_id));
2729: HR_UTILITY_TRACE('State Code '|| p_state_code);
2730: HR_UTILITY_TRACE('Locality Code '|| l_locality_code);
2731:
2732: OPEN c_locality_jurisdiction( p_ye_assignment_action_id,

Line 2729: HR_UTILITY_TRACE('State Code '|| p_state_code);

2725:
2726:
2727:
2728: HR_UTILITY_TRACE('YE Assignment_Action_Id '|| to_char(p_ye_assignment_action_id));
2729: HR_UTILITY_TRACE('State Code '|| p_state_code);
2730: HR_UTILITY_TRACE('Locality Code '|| l_locality_code);
2731:
2732: OPEN c_locality_jurisdiction( p_ye_assignment_action_id,
2733: p_state_code,

Line 2730: HR_UTILITY_TRACE('Locality Code '|| l_locality_code);

2726:
2727:
2728: HR_UTILITY_TRACE('YE Assignment_Action_Id '|| to_char(p_ye_assignment_action_id));
2729: HR_UTILITY_TRACE('State Code '|| p_state_code);
2730: HR_UTILITY_TRACE('Locality Code '|| l_locality_code);
2731:
2732: OPEN c_locality_jurisdiction( p_ye_assignment_action_id,
2733: p_state_code,
2734: l_locality_code);

Line 2738: HR_UTILITY_TRACE('Processing Jurisdiction '|| l_jurisdiction_code);

2734: l_locality_code);
2735: LOOP
2736: l_jurisdiction_code := NULL;
2737: FETCH c_locality_jurisdiction INTO l_jurisdiction_code;
2738: HR_UTILITY_TRACE('Processing Jurisdiction '|| l_jurisdiction_code);
2739: EXIT WHEN c_locality_jurisdiction%NOTFOUND;
2740: IF l_jurisdiction_code IS NOT NULL
2741: THEN
2742: --{

Line 2778: HR_UTILITY_TRACE('DBI ' || ltr_ue_locality(J).ue_data_level ||

2774:
2775: ELSE
2776: ltr_ue_locality(j).ue_value := '0';
2777: END IF;
2778: HR_UTILITY_TRACE('DBI ' || ltr_ue_locality(J).ue_data_level ||
2779: ' -('||to_char(j)|| ') : < ' || ltr_ue_locality(j).ue_name||
2780: ' > VALUE : < '|| ltr_ue_locality(j).ue_value||' >');
2781:
2782: END LOOP;

Line 2849: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);

2845: ltr_local_record(i).locality_tax := l_city_tax_withheld;
2846: END IF;
2847:
2848:
2849: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);
2850: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
2851: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
2852: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
2853: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);

Line 2850: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);

2846: END IF;
2847:
2848:
2849: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);
2850: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
2851: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
2852: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
2853: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
2854: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);

Line 2851: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);

2847:
2848:
2849: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);
2850: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
2851: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
2852: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
2853: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
2854: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);
2855: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);

Line 2852: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);

2848:
2849: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);
2850: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
2851: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
2852: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
2853: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
2854: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);
2855: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);
2856: --}

Line 2853: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);

2849: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);
2850: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
2851: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
2852: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
2853: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
2854: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);
2855: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);
2856: --}
2857: END IF;

Line 2854: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);

2850: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
2851: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
2852: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
2853: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
2854: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);
2855: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);
2856: --}
2857: END IF;
2858: END IF;

Line 2855: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);

2851: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
2852: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
2853: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
2854: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);
2855: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);
2856: --}
2857: END IF;
2858: END IF;
2859:

Line 2875: HR_UTILITY_TRACE(l_data_item_xml);

2871: l_data_item_xml := '<'||g_ee_record(I).employee_tag||'>'||
2872: convert_special_char(nvl(g_ee_record(I).employee_data,' '))
2873: ||''|| EOL;
2874: l_final_xml_string := l_final_xml_string || l_data_item_xml;
2875: HR_UTILITY_TRACE(l_data_item_xml);
2876: END LOOP;
2877: /*
2878: This got added for FIT Withheld at 3rd Party Payer
2879: This Balance is not reported in RW record but total is reported in RT record

Line 2885: HR_UTILITY_TRACE(l_data_item_xml);

2881: l_data_item_xml := '<'||g_ee_record(FIT_WITHHELD_THIRD_PARTY).employee_tag||'>'||
2882: convert_special_char(nvl(g_ee_record(FIT_WITHHELD_THIRD_PARTY).employee_data,' '))
2883: ||''|| EOL;
2884: l_final_xml_string := l_final_xml_string || l_data_item_xml;
2885: HR_UTILITY_TRACE(l_data_item_xml);
2886:
2887: l_final_xml_string := l_final_xml_string || '' || EOL;
2888: EXCEPTION
2889: WHEN OTHERS THEN

Line 2890: HR_UTILITY_TRACE('Error Encountered While formating RW Record Data Item');

2886:
2887: l_final_xml_string := l_final_xml_string || '' || EOL;
2888: EXCEPTION
2889: WHEN OTHERS THEN
2890: HR_UTILITY_TRACE('Error Encountered While formating RW Record Data Item');
2891: END;
2892: HR_UTILITY_TRACE(' RW Record Formatted Successfully Length '|| length(l_final_xml_string));
2893:
2894: /* Merge RO Record Data Compoents to XML Construct */

Line 2892: HR_UTILITY_TRACE(' RW Record Formatted Successfully Length '|| length(l_final_xml_string));

2888: EXCEPTION
2889: WHEN OTHERS THEN
2890: HR_UTILITY_TRACE('Error Encountered While formating RW Record Data Item');
2891: END;
2892: HR_UTILITY_TRACE(' RW Record Formatted Successfully Length '|| length(l_final_xml_string));
2893:
2894: /* Merge RO Record Data Compoents to XML Construct */
2895: l_final_xml_string := l_final_xml_string
2896: || '<'||convert_special_char(g_ee_record(43).employee_data)||'>';

Line 2911: HR_UTILITY_TRACE(l_data_item_xml);

2907: LOOP
2908: l_data_item_xml := '<'||g_ee_record(I).employee_tag||'>'||
2909: convert_special_char(nvl(g_ee_record(I).employee_data,' '))
2910: ||''|| EOL;
2911: HR_UTILITY_TRACE(l_data_item_xml);
2912: l_final_xml_string := l_final_xml_string || l_data_item_xml;
2913: END LOOP;
2914: l_final_xml_string := l_final_xml_string || ' 2915: || '>' || EOL;

Line 2918: HR_UTILITY_TRACE('Error Encountered While formating RO Record Data Item');

2914: l_final_xml_string := l_final_xml_string || ' 2915: || '>' || EOL;
2916: EXCEPTION
2917: WHEN OTHERS THEN
2918: HR_UTILITY_TRACE('Error Encountered While formating RO Record Data Item');
2919: END;
2920: HR_UTILITY_TRACE(' RO Record Formatted Successfully Length '|| length(l_final_xml_string));
2921:
2922: /* Merge RS Record Data Compoents to XML Construct */

Line 2920: HR_UTILITY_TRACE(' RO Record Formatted Successfully Length '|| length(l_final_xml_string));

2916: EXCEPTION
2917: WHEN OTHERS THEN
2918: HR_UTILITY_TRACE('Error Encountered While formating RO Record Data Item');
2919: END;
2920: HR_UTILITY_TRACE(' RO Record Formatted Successfully Length '|| length(l_final_xml_string));
2921:
2922: /* Merge RS Record Data Compoents to XML Construct */
2923: l_final_xml_string := l_final_xml_string || '';
2924: BEGIN

Line 2930: HR_UTILITY_TRACE(l_data_item_xml);

2926: LOOP
2927: l_data_item_xml := '<'||g_ee_record(I).employee_tag||'>'||
2928: convert_special_char(nvl(g_ee_record(I).employee_data,' '))
2929: ||''|| EOL;
2930: HR_UTILITY_TRACE(l_data_item_xml);
2931: l_final_xml_string := l_final_xml_string || l_data_item_xml;
2932: END LOOP;
2933: l_final_xml_string := l_final_xml_string || '' || EOL;
2934:

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

2933: l_final_xml_string := l_final_xml_string || '' || EOL;
2934:
2935: EXCEPTION
2936: WHEN OTHERS THEN
2937: HR_UTILITY_TRACE('Error Encountered While formating RS Record Data Item');
2938: END;
2939: HR_UTILITY_TRACE(' RS Record Formatted Successfully Length '|| length(l_final_xml_string));
2940: --
2941: -- Following Procedure will initialize Locality Data Item Tags

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

2935: EXCEPTION
2936: WHEN OTHERS THEN
2937: HR_UTILITY_TRACE('Error Encountered While formating RS Record Data Item');
2938: END;
2939: HR_UTILITY_TRACE(' RS Record Formatted Successfully Length '|| length(l_final_xml_string));
2940: --
2941: -- Following Procedure will initialize Locality Data Item Tags
2942: --
2943: populate_ee_locality_tag;

Line 2945: HR_UTILITY_TRACE(' Formating Locality Records for Employee ');

2941: -- Following Procedure will initialize Locality Data Item Tags
2942: --
2943: populate_ee_locality_tag;
2944:
2945: HR_UTILITY_TRACE(' Formating Locality Records for Employee ');
2946: -- l_final_xml_string := l_final_xml_string || '';
2947:
2948: IF ltr_local_record.COUNT >= 1
2949: THEN

Line 2986: HR_UTILITY_TRACE('SD XML '|| l_data_item_xml);

2982: || '<'|| ltr_ee_locality_tag(13)||'>'||
2983: convert_special_char(nvl(ltr_local_record(i).locality_tax ,' '))
2984: ||''|| EOL
2985: ||'' || EOL;
2986: HR_UTILITY_TRACE('SD XML '|| l_data_item_xml);
2987:
2988: ELSE l_data_item_xml := ''||
2989: '<'|| ltr_ee_locality_tag(CITY_JURISDICTION)||'>'||
2990: convert_special_char(nvl(ltr_local_record(i).jurisdiction ,' '))

Line 3011: HR_UTILITY_TRACE('Locality XML '|| l_data_item_xml);

3007: || '<'|| ltr_ee_locality_tag(CITY_TAX_WITHHELD)||'>'||
3008: convert_special_char(nvl(ltr_local_record(i).locality_tax ,' '))
3009: ||''|| EOL
3010: ||'' || EOL;
3011: HR_UTILITY_TRACE('Locality XML '|| l_data_item_xml);
3012: --}
3013: END IF;
3014:
3015: -- Bug # 6117216 SD Reporting Changes END

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

3025: p_final_string := l_final_xml_string;
3026: --}
3027: EXCEPTION
3028: WHEN OTHERS THEN
3029: HR_UTILITY_TRACE('Error Encountered in procedure populate_arch_employee');
3030: END populate_arch_employee; -- End of Procedure populate_arch_employee
3031:
3032:
3033: BEGIN

Line 3034: -- hr_utility.trace_on(null, 'USLOCALW2');

3030: END populate_arch_employee; -- End of Procedure populate_arch_employee
3031:
3032:
3033: BEGIN
3034: -- hr_utility.trace_on(null, 'USLOCALW2');
3035: g_proc_name := 'pay_us_w2_generic_extract.';
3036: g_debug := hr_utility.debug_enabled;
3037: g_document_type := 'LOCAL_W2_XML';
3038: END pay_us_w2_generic_extract;

Line 3036: g_debug := hr_utility.debug_enabled;

3032:
3033: BEGIN
3034: -- hr_utility.trace_on(null, 'USLOCALW2');
3035: g_proc_name := 'pay_us_w2_generic_extract.';
3036: g_debug := hr_utility.debug_enabled;
3037: g_document_type := 'LOCAL_W2_XML';
3038: END pay_us_w2_generic_extract;