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

Line 67: Name : HR_UTILITY_TRACE

63: g_debug boolean;
64: g_document_type varchar2(50);
65:
66: /****************************************************************************
67: Name : HR_UTILITY_TRACE
68: Description : This procedure prints debug messages.
69: *****************************************************************************/
70:
71: PROCEDURE HR_UTILITY_TRACE

Line 71: PROCEDURE HR_UTILITY_TRACE

67: Name : HR_UTILITY_TRACE
68: Description : This procedure prints debug messages.
69: *****************************************************************************/
70:
71: PROCEDURE HR_UTILITY_TRACE
72: (
73: P_TRC_DATA varchar2
74: ) AS
75: BEGIN

Line 77: hr_utility.trace(p_trc_data);

73: P_TRC_DATA varchar2
74: ) AS
75: BEGIN
76: IF g_debug THEN
77: hr_utility.trace(p_trc_data);
78: END IF;
79: END HR_UTILITY_TRACE;
80:
81: FUNCTION convert_special_char( p_data varchar2)

Line 79: END HR_UTILITY_TRACE;

75: BEGIN
76: IF g_debug THEN
77: hr_utility.trace(p_trc_data);
78: END IF;
79: END HR_UTILITY_TRACE;
80:
81: FUNCTION convert_special_char( p_data varchar2)
82: RETURN varchar2 IS
83: l_data VARCHAR2(2000);

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

136: --
137: -- Following Loop structure used to debug the Tag Values
138: --
139: FOR I IN 1 .. g_ra_no_of_tag LOOP
140: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '||ltr_ra_data_tag(i));
141: END LOOP;
142: END populate_ra_data_tag;
143:
144:

Line 621: -- HR_UTILITY_TRACE(l_final_xml_string);

617: FOR I IN 1 .. g_ra_no_of_tag LOOP
618: l_final_xml_string := l_final_xml_string || '<'||g_ra_record(I).submitter_tag||'>'||
619: convert_special_char(g_ra_record(I).submitter_data)
620: ||''|| EOL;
621: -- HR_UTILITY_TRACE(l_final_xml_string);
622: END LOOP;
623: HR_UTILITY_TRACE(l_final_xml_string);
624: p_final_string := l_final_xml_string;
625: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);

Line 623: HR_UTILITY_TRACE(l_final_xml_string);

619: convert_special_char(g_ra_record(I).submitter_data)
620: ||''|| EOL;
621: -- HR_UTILITY_TRACE(l_final_xml_string);
622: END LOOP;
623: HR_UTILITY_TRACE(l_final_xml_string);
624: p_final_string := l_final_xml_string;
625: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);
626: --pay_core_files.write_to_magtape_lob(l_final_xml_string);
627: --}

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

685: --
686: -- Following Loop structure used to debug the Tag Values
687: --
688: FOR I IN ltr_re_data_tag.first .. ltr_re_data_tag.last LOOP
689: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '||ltr_re_data_tag(i));
690: END LOOP;
691:
692: END populate_re_data_tag;
693:

Line 1186: -- HR_UTILITY_TRACE(l_final_xml_string);

1182: FOR I IN 1 .. 39 LOOP
1183: l_final_xml_string := l_final_xml_string || '<'||g_re_record(I).employer_tag||'>'||
1184: convert_special_char(g_re_record(I).employer_data)
1185: ||''|| EOL;
1186: -- HR_UTILITY_TRACE(l_final_xml_string);
1187: END LOOP;
1188: HR_UTILITY_TRACE(l_final_xml_string);
1189: p_final_string := l_final_xml_string;
1190: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);

Line 1188: HR_UTILITY_TRACE(l_final_xml_string);

1184: convert_special_char(g_re_record(I).employer_data)
1185: ||''|| EOL;
1186: -- HR_UTILITY_TRACE(l_final_xml_string);
1187: END LOOP;
1188: HR_UTILITY_TRACE(l_final_xml_string);
1189: p_final_string := l_final_xml_string;
1190: --pay_us_mmref_local_xml.write_to_magtape_lob(l_final_xml_string);
1191: --pay_core_files.write_to_magtape_lob(l_final_xml_string);
1192: --}

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

1290: -- Following Loop structure used to debug the Tag Values
1291: --
1292: FOR I IN ltr_ee_data_tag.first .. ltr_ee_data_tag.last
1293: LOOP
1294: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '|| ltr_ee_data_tag(i));
1295: END LOOP;
1296: END populate_ee_data_tag;
1297:
1298: --

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

1330: -- Following Loop structure used to debug the Tag Values
1331: --
1332: FOR I IN ltr_ee_locality_tag.first .. ltr_ee_locality_tag.last
1333: LOOP
1334: HR_UTILITY_TRACE('Tag'||to_char(i)|| ' : '|| ltr_ee_locality_tag(i));
1335: END LOOP;
1336: END populate_ee_locality_tag;
1337:
1338: --

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

2159: --
2160: -- End of setting User Entities to PL/Table
2161: --
2162:
2163: HR_UTILITY_TRACE('DBI Count '||to_char(ltr_ue_name_table.count));
2164: HR_UTILITY_TRACE('YE Archive Assignment Action Id '||
2165: to_char(p_ye_assignment_action_id));
2166:
2167: IF ltr_ue_name_table.count > 0 then

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

2160: -- End of setting User Entities to PL/Table
2161: --
2162:
2163: HR_UTILITY_TRACE('DBI Count '||to_char(ltr_ue_name_table.count));
2164: HR_UTILITY_TRACE('YE Archive Assignment Action Id '||
2165: to_char(p_ye_assignment_action_id));
2166:
2167: IF ltr_ue_name_table.count > 0 then
2168: FOR j IN ltr_ue_name_table.first .. ltr_ue_name_table.last

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

2218: ltr_ue_name_table(j).ue_name);
2219: ELSE
2220: ltr_ue_name_table(j).ue_value := ' ';
2221: END IF;
2222: HR_UTILITY_TRACE('DBI ' || ltr_ue_name_table(J).ue_data_level ||
2223: ' -('||to_char(j)|| ') : < '||ltr_ue_name_table(j).ue_name||
2224: ' > VALUE : < '|| ltr_ue_name_table(j).ue_value||' >');
2225: END LOOP;
2226: HR_UTILITY_TRACE('Status of Employee Record ' || l_status);

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

2222: HR_UTILITY_TRACE('DBI ' || ltr_ue_name_table(J).ue_data_level ||
2223: ' -('||to_char(j)|| ') : < '||ltr_ue_name_table(j).ue_name||
2224: ' > VALUE : < '|| ltr_ue_name_table(j).ue_value||' >');
2225: END LOOP;
2226: HR_UTILITY_TRACE('Status of Employee Record ' || l_status);
2227: END IF;
2228:
2229: /* ==================================================
2230: Get Employer or transmitter Company Information releated Submitter

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

2276: /* Deriving all data Items that are used for RW record */
2277:
2278: /* Record Identifier */
2279: g_ee_record(RW_RECORD_IDENTIFIER).employee_data := 'RW';
2280: HR_UTILITY_TRACE(g_ee_record(1).employee_tag || ' : '
2281: || g_ee_record(RW_RECORD_IDENTIFIER).employee_data);
2282: /* Employee, Social Security Number (SSN) */
2283: g_ee_record(EE_SSN).employee_data :=
2284: ltr_ue_name_table(1).ue_value;

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

2281: || g_ee_record(RW_RECORD_IDENTIFIER).employee_data);
2282: /* Employee, Social Security Number (SSN) */
2283: g_ee_record(EE_SSN).employee_data :=
2284: ltr_ue_name_table(1).ue_value;
2285: HR_UTILITY_TRACE(g_ee_record(EE_SSN).employee_tag || ' : '
2286: || g_ee_record(EE_SSN).employee_data);
2287:
2288: /* Employee, First Name */
2289: /* Bug 7427138 */

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

2288: /* Employee, First Name */
2289: /* Bug 7427138 */
2290: --g_ee_record(EE_FIRST_NAME).employee_data := ltr_ue_name_table(2).ue_value;
2291: g_ee_record(EE_FIRST_NAME).employee_data := upper(ltr_ue_name_table(2).ue_value);
2292: HR_UTILITY_TRACE(g_ee_record(EE_FIRST_NAME).employee_tag || ' : '
2293: || g_ee_record(EE_FIRST_NAME).employee_data);
2294:
2295: /* Employee, Middle Name or Initial */
2296: /* Bug 7427138 */

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

2295: /* Employee, Middle Name or Initial */
2296: /* Bug 7427138 */
2297: --g_ee_record(EE_MIDDLE_INITIAL).employee_data := ltr_ue_name_table(3).ue_value;
2298: g_ee_record(EE_MIDDLE_INITIAL).employee_data := upper(ltr_ue_name_table(3).ue_value);
2299: HR_UTILITY_TRACE(g_ee_record(EE_MIDDLE_INITIAL).employee_tag || ' : '
2300: || g_ee_record(EE_MIDDLE_INITIAL).employee_data);
2301:
2302: /* Employee, Last Name */
2303: /* Bug 7427138 */

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

2302: /* Employee, Last Name */
2303: /* Bug 7427138 */
2304: --g_ee_record(EE_LAST_NAME).employee_data := ltr_ue_name_table(4).ue_value;
2305: g_ee_record(EE_LAST_NAME).employee_data := upper(ltr_ue_name_table(4).ue_value);
2306: HR_UTILITY_TRACE(g_ee_record(EE_LAST_NAME).employee_tag || ' : '
2307: || g_ee_record(EE_LAST_NAME).employee_data);
2308:
2309: /* Employee, Name Suffix */
2310: /* Bug 7427138 */

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

2309: /* Employee, Name Suffix */
2310: /* Bug 7427138 */
2311: --g_ee_record(EE_SUFFIX).employee_data := ltr_ue_name_table(5).ue_value;
2312: g_ee_record(EE_SUFFIX).employee_data := upper(ltr_ue_name_table(5).ue_value);
2313: HR_UTILITY_TRACE(g_ee_record(EE_SUFFIX).employee_tag || ' : '
2314: || g_ee_record(EE_SUFFIX).employee_data);
2315:
2316: /* Employee, Location Address */
2317: g_ee_record(EE_LOCATION_ADDRESS).employee_data := empe_out_1;

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

2314: || g_ee_record(EE_SUFFIX).employee_data);
2315:
2316: /* Employee, Location Address */
2317: g_ee_record(EE_LOCATION_ADDRESS).employee_data := empe_out_1;
2318: HR_UTILITY_TRACE(g_ee_record(EE_LOCATION_ADDRESS).employee_tag || ' : '
2319: || g_ee_record(EE_LOCATION_ADDRESS).employee_data);
2320:
2321: /* Pos: 88 Len: 22 Desc: Employee, Delivery Address */
2322: g_ee_record(EE_DELIVERY_ADDRESS).employee_data := empe_out_2;

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

2319: || g_ee_record(EE_LOCATION_ADDRESS).employee_data);
2320:
2321: /* Pos: 88 Len: 22 Desc: Employee, Delivery Address */
2322: g_ee_record(EE_DELIVERY_ADDRESS).employee_data := empe_out_2;
2323: HR_UTILITY_TRACE(g_ee_record(EE_DELIVERY_ADDRESS).employee_tag || ' : '
2324: || g_ee_record(EE_DELIVERY_ADDRESS).employee_data);
2325:
2326: /* Employee, City */
2327: g_ee_record(EE_CITY).employee_data := empe_out_3;

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

2324: || g_ee_record(EE_DELIVERY_ADDRESS).employee_data);
2325:
2326: /* Employee, City */
2327: g_ee_record(EE_CITY).employee_data := empe_out_3;
2328: HR_UTILITY_TRACE(g_ee_record(EE_CITY).employee_tag || ' : '
2329: || g_ee_record(EE_CITY).employee_data);
2330:
2331: /* Employee, State Abbreviation */
2332: g_ee_record(EE_STATE_ABBREVIATION).employee_data := empe_out_4;

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

2329: || g_ee_record(EE_CITY).employee_data);
2330:
2331: /* Employee, State Abbreviation */
2332: g_ee_record(EE_STATE_ABBREVIATION).employee_data := empe_out_4;
2333: HR_UTILITY_TRACE(g_ee_record(EE_STATE_ABBREVIATION).employee_tag || ' : '
2334: || g_ee_record(EE_STATE_ABBREVIATION).employee_data);
2335:
2336: /* Employee, Zip Code */
2337: g_ee_record(EE_ZIP_CODE).employee_data := empe_out_5;

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

2334: || g_ee_record(EE_STATE_ABBREVIATION).employee_data);
2335:
2336: /* Employee, Zip Code */
2337: g_ee_record(EE_ZIP_CODE).employee_data := empe_out_5;
2338: HR_UTILITY_TRACE(g_ee_record(EE_ZIP_CODE).employee_tag || ' : '
2339: || g_ee_record(EE_ZIP_CODE).employee_data);
2340:
2341: /* Employee, Zip Code Extension */
2342: g_ee_record(EE_ZIP_CODE_EXTENSION).employee_data :=

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

2340:
2341: /* Employee, Zip Code Extension */
2342: g_ee_record(EE_ZIP_CODE_EXTENSION).employee_data :=
2343: empe_out_6;
2344: HR_UTILITY_TRACE(g_ee_record(EE_ZIP_CODE_EXTENSION).employee_tag || ' : '
2345: || g_ee_record(EE_ZIP_CODE_EXTENSION).employee_data);
2346:
2347: /* Employee, Foreign State - Province */
2348: g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data

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

2346:
2347: /* Employee, Foreign State - Province */
2348: g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data
2349: := empe_out_7;
2350: HR_UTILITY_TRACE(g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_tag || ' : '
2351: || g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data);
2352:
2353: /* Employee, Foreign Postal Code */
2354: g_ee_record(EE_FOREIGN_POSTAL_CODE).employee_data

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

2352:
2353: /* Employee, Foreign Postal Code */
2354: g_ee_record(EE_FOREIGN_POSTAL_CODE).employee_data
2355: := empe_out_8;
2356: HR_UTILITY_TRACE(g_ee_record(EE_FOREIGN_POSTAL_CODE).employee_tag || ' : '
2357: || g_ee_record(EE_FOREIGN_STATE_PROVINCE).employee_data);
2358:
2359: /* Pos: 186 Len: 2 Desc: Employee, Country Code */
2360: g_ee_record(EE_COUNTRY_CODE).employee_data

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

2358:
2359: /* Pos: 186 Len: 2 Desc: Employee, Country Code */
2360: g_ee_record(EE_COUNTRY_CODE).employee_data
2361: := empe_out_9;
2362: HR_UTILITY_TRACE(g_ee_record(EE_COUNTRY_CODE).employee_tag || ' : '
2363: || g_ee_record(EE_COUNTRY_CODE).employee_data);
2364:
2365: /* Pos: 188 Len: 11 Desc: Wages, Tips and Other Compensation */
2366:

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

2392: to_number(ltr_ue_name_table(45).ue_value));
2393:
2394: END IF;
2395:
2396: HR_UTILITY_TRACE(g_ee_record(FIT_GROSS_WAGES).employee_tag || ' : '
2397: || g_ee_record(FIT_GROSS_WAGES).employee_data);
2398:
2399: /*
2400: FIT_GROSS_WAGES = A_REGULAR_EARNINGS_PER_GRE_YTD +

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

2406: */
2407:
2408: /* Federal Income Tax Withheld */
2409: g_ee_record(FIT_WITHHELD).employee_data := ltr_ue_name_table(7).ue_value;
2410: HR_UTILITY_TRACE(g_ee_record(FIT_WITHHELD).employee_tag || ' : '
2411: || g_ee_record(FIT_WITHHELD).employee_data);
2412:
2413: /* Pos: 210 Len: 11 Desc: Social Security Wages
2414: SS_WAGES := A_SS_EE_TAXABLE_PER_GRE_YTD

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

2415: - A_W2_BOX_7_PER_GRE_YTD
2416: */
2417: g_ee_record(SS_WAGES).employee_data := to_char(to_number(ltr_ue_name_table(8).ue_value)
2418: - to_number(ltr_ue_name_table(12).ue_value));
2419: HR_UTILITY_TRACE(g_ee_record(SS_WAGES).employee_tag || ' : '
2420: || g_ee_record(SS_WAGES).employee_data);
2421:
2422: /* Social Security Tax Withheld */
2423: g_ee_record(SS_TAX_WITHHELD).employee_data := ltr_ue_name_table(9).ue_value;

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

2435: g_ee_record(EIC_ADVANCE).employee_data := ltr_ue_name_table(13).ue_value;
2436:
2437: /* Dependent Care Benefits */
2438: g_ee_record(W2_DEPENDENT_CARE).employee_data := ltr_ue_name_table(14).ue_value;
2439: HR_UTILITY_TRACE(g_ee_record(W2_DEPENDENT_CARE).employee_tag || ' : '
2440: || g_ee_record(W2_DEPENDENT_CARE).employee_data);
2441:
2442: /* Deferred Compensation Contributions to Section 401(k) */
2443: g_ee_record(W2_401K).employee_data := ltr_ue_name_table(15).ue_value;

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

2449: g_ee_record(W2_408K).employee_data := ltr_ue_name_table(17).ue_value;
2450:
2451: /* Deferred Compensation Contributions to Section 457(b) */
2452: g_ee_record(W2_457).employee_data := ltr_ue_name_table(18).ue_value;
2453: HR_UTILITY_TRACE(g_ee_record(W2_457).employee_tag || ' : '
2454: || g_ee_record(W2_457).employee_data);
2455:
2456: /* Deferred Compensation Contributions to Section 501(c)(18)(D) */
2457: g_ee_record(W2_501C).employee_data := ltr_ue_name_table(19).ue_value;

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

2477: */
2478: g_ee_record(NON_QUAL_NOT_457).employee_data :=
2479: to_char(to_number(ltr_ue_name_table(20).ue_value) -
2480: to_number(ltr_ue_name_table(21).ue_value));
2481: HR_UTILITY_TRACE(g_ee_record(NON_QUAL_NOT_457).employee_tag || ' : '
2482: || g_ee_record(NON_QUAL_NOT_457).employee_data);
2483:
2484: /* Non-Taxable Combat Pay (Not for Puerto Rico) */
2485: g_ee_record(W2_NONTAX_COMBAT).employee_data := ltr_ue_name_table(39).ue_value;

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

2494: g_ee_record(W2_NONQUAL_DEF_COMP).employee_data := ltr_ue_name_table(40).ue_value;
2495:
2496: /* Designated Roth Contributions to a section 401(k) Plan */
2497: g_ee_record(W2_ROTH_401K).employee_data := ltr_ue_name_table(41).ue_value;
2498: HR_UTILITY_TRACE(g_ee_record(W2_ROTH_401K).employee_tag || ' : '
2499: || g_ee_record(W2_ROTH_401K).employee_data);
2500:
2501: /* Designated Roth Contributions Und sec 403(b) Plan */
2502: g_ee_record(W2_ROTH_403B).employee_data := ltr_ue_name_table(42).ue_value;

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

2499: || g_ee_record(W2_ROTH_401K).employee_data);
2500:
2501: /* Designated Roth Contributions Und sec 403(b) Plan */
2502: g_ee_record(W2_ROTH_403B).employee_data := ltr_ue_name_table(42).ue_value;
2503: HR_UTILITY_TRACE(g_ee_record(W2_ROTH_403B).employee_tag || ' : '
2504: || g_ee_record(W2_ROTH_403B).employee_data);
2505:
2506: /* Statutory Employee Indicator */
2507: IF ltr_ue_name_table(24).ue_value = 'Y' THEN

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

2508: g_ee_record(W2_ASG_STATUTORY_EMPLOYEE).employee_data := '1';
2509: ELSE
2510: g_ee_record(W2_ASG_STATUTORY_EMPLOYEE).employee_data := '0';
2511: END IF;
2512: HR_UTILITY_TRACE(g_ee_record(W2_ASG_STATUTORY_EMPLOYEE).employee_tag || ' : '
2513: || g_ee_record(W2_ASG_STATUTORY_EMPLOYEE).employee_data);
2514:
2515: /* Retirement Plan Indicator */
2516: IF (( to_number(ltr_ue_name_table(25).ue_value) > 0) OR

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

2522: g_ee_record(RETIREMENT_PLAN_INDICATOR).employee_data := '1';
2523: ELSE
2524: g_ee_record(RETIREMENT_PLAN_INDICATOR).employee_data := '0';
2525: END IF;
2526: HR_UTILITY_TRACE(g_ee_record(RETIREMENT_PLAN_INDICATOR).employee_tag || ' : '
2527: || g_ee_record(RETIREMENT_PLAN_INDICATOR).employee_data);
2528:
2529: /* Third-Party Sick Pay Indicator */
2530: IF to_number(ltr_ue_name_table(38).ue_value) > 0

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

2532: g_ee_record(W2_TP_SICK_PAY_IND).employee_data := '1';
2533: ELSE
2534: g_ee_record(W2_TP_SICK_PAY_IND).employee_data := '0';
2535: END IF;
2536: HR_UTILITY_TRACE(g_ee_record(W2_TP_SICK_PAY_IND).employee_tag || ' : '
2537: || g_ee_record(W2_TP_SICK_PAY_IND).employee_data);
2538:
2539: /* Income Tax Withheld by Third Party Payer
2540: This balance is not reported in RW record but summ total is reported at the GRE level in RT record

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

2539: /* Income Tax Withheld by Third Party Payer
2540: This balance is not reported in RW record but summ total is reported at the GRE level in RT record
2541: */
2542: g_ee_record(FIT_WITHHELD_THIRD_PARTY).employee_data := ltr_ue_name_table(27).ue_value;
2543: HR_UTILITY_TRACE(g_ee_record(FIT_WITHHELD_THIRD_PARTY).employee_tag || ' : '
2544: || g_ee_record(FIT_WITHHELD_THIRD_PARTY).employee_data);
2545:
2546: /* Bug 13419620 : A_W2_HEALTH_COVERAGE_PER_GRE_YTD */
2547: g_ee_record(W2_HEALTH_COVERAGE).employee_data := ltr_ue_name_table(78).ue_value;

Line 2548: HR_UTILITY_TRACE(g_ee_record(W2_HEALTH_COVERAGE).employee_tag || ' : '

2544: || g_ee_record(FIT_WITHHELD_THIRD_PARTY).employee_data);
2545:
2546: /* Bug 13419620 : A_W2_HEALTH_COVERAGE_PER_GRE_YTD */
2547: g_ee_record(W2_HEALTH_COVERAGE).employee_data := ltr_ue_name_table(78).ue_value;
2548: HR_UTILITY_TRACE(g_ee_record(W2_HEALTH_COVERAGE).employee_tag || ' : '
2549: || g_ee_record(W2_HEALTH_COVERAGE).employee_data);
2550:
2551: /* RO Record Data Items fetched to build XML components */
2552: out_ret_contrib_perjdgreytd :=

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

2610: END IF;
2611:
2612: /* RO Record Identifier */
2613: g_ee_record(RO_RECORD_IDENTIFIER).employee_data := 'RO';
2614: HR_UTILITY_TRACE(g_ee_record(RO_RECORD_IDENTIFIER).employee_tag || ' : '
2615: || g_ee_record(RO_RECORD_IDENTIFIER).employee_data);
2616:
2617: /* Allocated Tips */
2618: g_ee_record(RO_W2_BOX_8).employee_data := ltr_ue_name_table(46).ue_value;

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

2615: || g_ee_record(RO_RECORD_IDENTIFIER).employee_data);
2616:
2617: /* Allocated Tips */
2618: g_ee_record(RO_W2_BOX_8).employee_data := ltr_ue_name_table(46).ue_value;
2619: HR_UTILITY_TRACE(g_ee_record(RO_W2_BOX_8).employee_tag || ' : '
2620: || g_ee_record(RO_W2_BOX_8).employee_data);
2621:
2622: /* Uncollected Employee Tax on Tips */
2623: g_ee_record(RO_UNCOLLECT_TAX_ON_TIPS).employee_data :=

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

2622: /* Uncollected Employee Tax on Tips */
2623: g_ee_record(RO_UNCOLLECT_TAX_ON_TIPS).employee_data :=
2624: to_char(to_number(ltr_ue_name_table(47).ue_value) +
2625: to_number(ltr_ue_name_table(48).ue_value));
2626: HR_UTILITY_TRACE(g_ee_record(RO_UNCOLLECT_TAX_ON_TIPS).employee_tag || ' : '
2627: || g_ee_record(RO_UNCOLLECT_TAX_ON_TIPS).employee_data);
2628:
2629: /****************************************************************************/
2630: /* Locations 34 to 66 Do not apply to Puerto Rico, Virgin Islands, American */

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

2632: /****************************************************************************/
2633: /* Medical Savings Account */
2634: g_ee_record(RO_W2_MSA).employee_data :=
2635: ltr_ue_name_table(49).ue_value;
2636: HR_UTILITY_TRACE(g_ee_record(RO_W2_MSA).employee_tag || ' : '
2637: || g_ee_record(RO_W2_MSA).employee_data);
2638:
2639: /* Simple Retirement Account */
2640: g_ee_record(RO_W2_408P).employee_data :=

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

2638:
2639: /* Simple Retirement Account */
2640: g_ee_record(RO_W2_408P).employee_data :=
2641: ltr_ue_name_table(50).ue_value;
2642: HR_UTILITY_TRACE(g_ee_record(RO_W2_408P).employee_tag || ' : '
2643: || g_ee_record(RO_W2_408P).employee_data);
2644:
2645: /* Qualified Adoption Expenses */
2646: g_ee_record(RO_W2_ADOPTION).employee_data :=

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

2644:
2645: /* Qualified Adoption Expenses */
2646: g_ee_record(RO_W2_ADOPTION).employee_data :=
2647: ltr_ue_name_table(51).ue_value;
2648: HR_UTILITY_TRACE(g_ee_record(RO_W2_ADOPTION).employee_tag || ' : '
2649: || g_ee_record(RO_W2_ADOPTION).employee_data);
2650: /****************************************************************************/
2651: /* Uncollected Social Security or RPTA Tax on Cost
2652: of Group Term Life Insurance Over $50,000 */

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

2651: /* Uncollected Social Security or RPTA Tax on Cost
2652: of Group Term Life Insurance Over $50,000 */
2653: g_ee_record(RO_W2_UNCOLL_SS_GTL).employee_data :=
2654: ltr_ue_name_table(52).ue_value;
2655: HR_UTILITY_TRACE(g_ee_record(RO_W2_UNCOLL_SS_GTL).employee_tag || ' : '
2656: || g_ee_record(RO_W2_UNCOLL_SS_GTL).employee_data);
2657: /* Uncollected Medicare Tax on Cost of Group Term Life Insurance Over $50,000 */
2658: g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_data :=
2659: ltr_ue_name_table(53).ue_value;

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

2656: || g_ee_record(RO_W2_UNCOLL_SS_GTL).employee_data);
2657: /* Uncollected Medicare Tax on Cost of Group Term Life Insurance Over $50,000 */
2658: g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_data :=
2659: ltr_ue_name_table(53).ue_value;
2660: HR_UTILITY_TRACE(g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_tag || ' : '
2661: || g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_data);
2662: /* Income Under Sec 409A on Non-Qual Def Comp Plan */
2663: g_ee_record(RO_W2_409A_NONQUAL_INCOM).employee_data :=
2664: ltr_ue_name_table(54).ue_value;

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

2661: || g_ee_record(RO_W2_UNCOLL_MED_GTL).employee_data);
2662: /* Income Under Sec 409A on Non-Qual Def Comp Plan */
2663: g_ee_record(RO_W2_409A_NONQUAL_INCOM).employee_data :=
2664: ltr_ue_name_table(54).ue_value;
2665: HR_UTILITY_TRACE(g_ee_record(RO_W2_409A_NONQUAL_INCOM).employee_tag || ' : '
2666: || g_ee_record(RO_W2_409A_NONQUAL_INCOM).employee_data);
2667:
2668: /****************************************************************************/
2669: /* Locations 265 to 362 are for Puerto Rico Employees ONLY. */

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

2673: l_tax_tax_jurisdiction :=
2674: hr_us_w2_rep.get_w2_tax_unit_item (p_tax_unit_id,
2675: p_payroll_action_id,
2676: 'A_LC_W2_REPORTING_RULES_ORG_TAX_JURISDICTION');
2677: HR_UTILITY_TRACE('Tax Jurisdiction Code '||l_tax_tax_jurisdiction);
2678:
2679: IF l_tax_tax_jurisdiction = 'P' THEN
2680: g_ee_record(RO_CIVIL_STATUS).employee_data := ro_out_6;
2681: ELSE

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

2680: g_ee_record(RO_CIVIL_STATUS).employee_data := ro_out_6;
2681: ELSE
2682: g_ee_record(RO_CIVIL_STATUS).employee_data := ' ';
2683: END IF;
2684: HR_UTILITY_TRACE(g_ee_record(RO_CIVIL_STATUS).employee_tag || ' : '
2685: || g_ee_record(RO_CIVIL_STATUS).employee_data);
2686:
2687: /* Spouse Social Security Number (SSN) */
2688: g_ee_record(RO_SPOUSE_SSN).employee_data := ro_out_7;

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

2685: || g_ee_record(RO_CIVIL_STATUS).employee_data);
2686:
2687: /* Spouse Social Security Number (SSN) */
2688: g_ee_record(RO_SPOUSE_SSN).employee_data := ro_out_7;
2689: HR_UTILITY_TRACE(g_ee_record(RO_SPOUSE_SSN).employee_tag || ' : '
2690: || g_ee_record(RO_SPOUSE_SSN).employee_data);
2691:
2692: /* Wages Subject to Puerto Rico Tax */
2693: g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_data := to_char(nout_wages_subject);

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

2690: || g_ee_record(RO_SPOUSE_SSN).employee_data);
2691:
2692: /* Wages Subject to Puerto Rico Tax */
2693: g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_data := to_char(nout_wages_subject);
2694: HR_UTILITY_TRACE(g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_tag || ' : '
2695: || g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_data);
2696:
2697: /* Commissions Subject to Puerto Rico Tax */
2698: g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabale_com_per);

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

2695: || g_ee_record(RO_WAGES_SUBJ_PR_TAX).employee_data);
2696:
2697: /* Commissions Subject to Puerto Rico Tax */
2698: g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabale_com_per);
2699: HR_UTILITY_TRACE(g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_tag || ' : '
2700: || g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_data);
2701:
2702: /* Allowances Subject to Puerto Rico Tax */
2703: g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabable_allow_per);

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

2700: || g_ee_record(RO_COMM_SUBJ_PR_TAX).employee_data);
2701:
2702: /* Allowances Subject to Puerto Rico Tax */
2703: g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabable_allow_per);
2704: HR_UTILITY_TRACE(g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_tag || ' : '
2705: || g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_data);
2706:
2707: /* Tips Subject to Puerto Rico Tax */
2708: g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabale_tips_per);

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

2705: || g_ee_record(RO_ALLOWANCE_SUBJ_PR_TAX).employee_data);
2706:
2707: /* Tips Subject to Puerto Rico Tax */
2708: g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_data := to_char(nout_terr_taxabale_tips_per);
2709: HR_UTILITY_TRACE(g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_tag || ' : '
2710: || g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_data);
2711:
2712: /* Total Wages, Commissions, Tips, and Allowances Subject to Puerto Rico Tax */
2713: g_ee_record(RO_W2_STATE_WAGES).employee_data := to_char(nout_total_w2_state_wages);

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

2710: || g_ee_record(RO_TIPS_SUBJ_PR_TAX).employee_data);
2711:
2712: /* Total Wages, Commissions, Tips, and Allowances Subject to Puerto Rico Tax */
2713: g_ee_record(RO_W2_STATE_WAGES).employee_data := to_char(nout_total_w2_state_wages);
2714: HR_UTILITY_TRACE(g_ee_record(RO_W2_STATE_WAGES).employee_tag || ' : '
2715: || g_ee_record(RO_W2_STATE_WAGES).employee_data);
2716:
2717: /* Puerto Rico Tax Withheld */
2718: g_ee_record(RO_PR_TAX_WITHHELD).employee_data := to_char(nout_sit_with_per);

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

2715: || g_ee_record(RO_W2_STATE_WAGES).employee_data);
2716:
2717: /* Puerto Rico Tax Withheld */
2718: g_ee_record(RO_PR_TAX_WITHHELD).employee_data := to_char(nout_sit_with_per);
2719: HR_UTILITY_TRACE(g_ee_record(RO_PR_TAX_WITHHELD).employee_tag || ' : '
2720: || g_ee_record(RO_PR_TAX_WITHHELD).employee_data);
2721:
2722: /* Retirement Fund Annual Contributions */
2723: g_ee_record(RO_RETIREMENT_CONTRIB).employee_data := to_char(nout_ret_contrib_perjdgreytd);

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

2720: || g_ee_record(RO_PR_TAX_WITHHELD).employee_data);
2721:
2722: /* Retirement Fund Annual Contributions */
2723: g_ee_record(RO_RETIREMENT_CONTRIB).employee_data := to_char(nout_ret_contrib_perjdgreytd);
2724: HR_UTILITY_TRACE(g_ee_record(RO_RETIREMENT_CONTRIB).employee_tag || ' : '
2725: || g_ee_record(RO_RETIREMENT_CONTRIB).employee_data);
2726:
2727: /* Bug 13419620 : A_W2_ROTH_457B_PER_GRE_YTD */
2728: g_ee_record(RO_W2_ROTH_457B).employee_data := ltr_ue_name_table(79).ue_value;

Line 2729: HR_UTILITY_TRACE(g_ee_record(RO_W2_ROTH_457B).employee_tag || ' : '

2725: || g_ee_record(RO_RETIREMENT_CONTRIB).employee_data);
2726:
2727: /* Bug 13419620 : A_W2_ROTH_457B_PER_GRE_YTD */
2728: g_ee_record(RO_W2_ROTH_457B).employee_data := ltr_ue_name_table(79).ue_value;
2729: HR_UTILITY_TRACE(g_ee_record(RO_W2_ROTH_457B).employee_tag || ' : '
2730: || g_ee_record(RO_W2_ROTH_457B).employee_data);
2731:
2732: /* Formating RS Record Data Items */
2733:

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

2732: /* Formating RS Record Data Items */
2733:
2734: /* Retirement Fund Annual Contributions */
2735: g_ee_record(RS_TAXING_ENTITY_CODE).employee_data := ' ';
2736: HR_UTILITY_TRACE(g_ee_record(RS_TAXING_ENTITY_CODE).employee_tag || ' : '
2737: || g_ee_record(RS_TAXING_ENTITY_CODE).employee_data);
2738:
2739: /* Optional Code */
2740: g_ee_record(RS_OPTIONAL_CODE).employee_data := ' ';

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

2737: || g_ee_record(RS_TAXING_ENTITY_CODE).employee_data);
2738:
2739: /* Optional Code */
2740: g_ee_record(RS_OPTIONAL_CODE).employee_data := ' ';
2741: HR_UTILITY_TRACE(g_ee_record(RS_OPTIONAL_CODE).employee_tag || ' : '
2742: || g_ee_record(RS_OPTIONAL_CODE).employee_data);
2743:
2744: /* Reporting Period */
2745: g_ee_record(RS_REPORTING_PERIOD).employee_data := l_reporting_period;

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

2742: || g_ee_record(RS_OPTIONAL_CODE).employee_data);
2743:
2744: /* Reporting Period */
2745: g_ee_record(RS_REPORTING_PERIOD).employee_data := l_reporting_period;
2746: HR_UTILITY_TRACE(g_ee_record(RS_REPORTING_PERIOD).employee_tag || ' : '
2747: || g_ee_record(RS_REPORTING_PERIOD).employee_data);
2748:
2749: /* State Quarterly Unemployment Insurance Total Wages */
2750: g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_data := '0';

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

2747: || g_ee_record(RS_REPORTING_PERIOD).employee_data);
2748:
2749: /* State Quarterly Unemployment Insurance Total Wages */
2750: g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_data := '0';
2751: HR_UTILITY_TRACE(g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_tag || ' : '
2752: || g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_data);
2753:
2754: /* State Quarterly Unemployment Total Taxable Wages */
2755: g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_data := '0';

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

2752: || g_ee_record(RS_SQWL_UNEMP_INS_WAGES).employee_data);
2753:
2754: /* State Quarterly Unemployment Total Taxable Wages */
2755: g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_data := '0';
2756: HR_UTILITY_TRACE(g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_tag || ' : '
2757: || g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_data);
2758:
2759: /* Number of Weeks Worked */
2760: g_ee_record(RS_WEEKS_WORKED).employee_data := ' ';

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

2757: || g_ee_record(RS_SQWL_UNEMP_TXBL_WAGES).employee_data);
2758:
2759: /* Number of Weeks Worked */
2760: g_ee_record(RS_WEEKS_WORKED).employee_data := ' ';
2761: HR_UTILITY_TRACE(g_ee_record(RS_WEEKS_WORKED).employee_tag || ' : '
2762: || g_ee_record(RS_WEEKS_WORKED).employee_data);
2763:
2764: /* Date First Employed */
2765: g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_data := ltr_ue_name_table(55).ue_value;

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

2762: || g_ee_record(RS_WEEKS_WORKED).employee_data);
2763:
2764: /* Date First Employed */
2765: g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_data := ltr_ue_name_table(55).ue_value;
2766: HR_UTILITY_TRACE(g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_tag || ' : '
2767: || g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_data);
2768:
2769: /* Date of Separation */
2770: g_ee_record(RS_DATE_OF_SEPARATION).employee_data := NVL(trim(ltr_ue_name_table(56).ue_value),' ');

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

2767: || g_ee_record(RS_DATE_FIRST_EMPLOYED).employee_data);
2768:
2769: /* Date of Separation */
2770: g_ee_record(RS_DATE_OF_SEPARATION).employee_data := NVL(trim(ltr_ue_name_table(56).ue_value),' ');
2771: HR_UTILITY_TRACE(g_ee_record(RS_DATE_OF_SEPARATION).employee_tag || ' : '
2772: || g_ee_record(RS_DATE_OF_SEPARATION).employee_data);
2773:
2774: /* State Employer Account Number */
2775: g_ee_record(RS_STATE_ER_ACCT_NUM).employee_data :=

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

2773:
2774: /* State Employer Account Number */
2775: g_ee_record(RS_STATE_ER_ACCT_NUM).employee_data :=
2776: replace(replace(nvl(replace(ltr_ue_name_table(73).ue_value,' '), ' ') ,'-'),'/');
2777: HR_UTILITY_TRACE(g_ee_record(RS_STATE_ER_ACCT_NUM).employee_tag || ' : '
2778: || g_ee_record(RS_STATE_ER_ACCT_NUM).employee_data);
2779:
2780: /* State Code */
2781:

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

2779:
2780: /* State Code */
2781:
2782: g_ee_record(RS_STATE_CODE).employee_data := ltr_ue_name_table(72).ue_value;
2783: HR_UTILITY_TRACE(g_ee_record(RS_STATE_CODE).employee_tag || ' : '
2784: || g_ee_record(RS_STATE_CODE).employee_data);
2785:
2786: /* State Taxable Wages
2787: A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD +

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

2792: to_number(ltr_ue_name_table(64).ue_value) -
2793: to_number(ltr_ue_name_table(65).ue_value);
2794:
2795: g_ee_record(RS_STATE_WAGES).employee_data := to_char(l_state_wages);
2796: HR_UTILITY_TRACE(g_ee_record(RS_STATE_WAGES).employee_tag || ' : '
2797: || g_ee_record(RS_STATE_WAGES).employee_data);
2798:
2799: /* SIT Withheld */
2800: g_ee_record(RS_SIT_WITHHELD).employee_data := ltr_ue_name_table(68).ue_value;

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

2797: || g_ee_record(RS_STATE_WAGES).employee_data);
2798:
2799: /* SIT Withheld */
2800: g_ee_record(RS_SIT_WITHHELD).employee_data := ltr_ue_name_table(68).ue_value;
2801: HR_UTILITY_TRACE(g_ee_record(RS_SIT_WITHHELD).employee_tag || ' : '
2802: || g_ee_record(RS_SIT_WITHHELD).employee_data);
2803:
2804: /* Other State Data*/
2805: g_ee_record(RS_OTHER_STATE_DATA).employee_data := ' ';

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

2802: || g_ee_record(RS_SIT_WITHHELD).employee_data);
2803:
2804: /* Other State Data*/
2805: g_ee_record(RS_OTHER_STATE_DATA).employee_data := ' ';
2806: HR_UTILITY_TRACE(g_ee_record(RS_OTHER_STATE_DATA).employee_tag || ' : '
2807: || g_ee_record(RS_OTHER_STATE_DATA).employee_data);
2808:
2809: /* State EIC Advance*/
2810: g_ee_record(RS_STEIC_ADVANCE).employee_data :=ltr_ue_name_table(69).ue_value;

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

2807: || g_ee_record(RS_OTHER_STATE_DATA).employee_data);
2808:
2809: /* State EIC Advance*/
2810: g_ee_record(RS_STEIC_ADVANCE).employee_data :=ltr_ue_name_table(69).ue_value;
2811: HR_UTILITY_TRACE(g_ee_record(RS_STEIC_ADVANCE).employee_tag || ' : '
2812: || g_ee_record(RS_STEIC_ADVANCE).employee_data);
2813:
2814: /* SUI Employee Withheld */
2815: g_ee_record(RS_SUI_EE_WITHHELD).employee_data := ltr_ue_name_table(70).ue_value;

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

2812: || g_ee_record(RS_STEIC_ADVANCE).employee_data);
2813:
2814: /* SUI Employee Withheld */
2815: g_ee_record(RS_SUI_EE_WITHHELD).employee_data := ltr_ue_name_table(70).ue_value;
2816: HR_UTILITY_TRACE(g_ee_record(RS_SUI_EE_WITHHELD).employee_tag || ' : '
2817: || g_ee_record(RS_SUI_EE_WITHHELD).employee_data);
2818:
2819: /* SDI Employee Withheld */
2820: g_ee_record(RS_SDI_EE_WITHHELD).employee_data := ltr_ue_name_table(71).ue_value;

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

2817: || g_ee_record(RS_SUI_EE_WITHHELD).employee_data);
2818:
2819: /* SDI Employee Withheld */
2820: g_ee_record(RS_SDI_EE_WITHHELD).employee_data := ltr_ue_name_table(71).ue_value;
2821: HR_UTILITY_TRACE(g_ee_record(RS_SDI_EE_WITHHELD).employee_tag || ' : '
2822: || g_ee_record(RS_SDI_EE_WITHHELD).employee_data);
2823:
2824: /* Supplemental Data 1 */
2825: g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_data := ' ';

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

2822: || g_ee_record(RS_SDI_EE_WITHHELD).employee_data);
2823:
2824: /* Supplemental Data 1 */
2825: g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_data := ' ';
2826: HR_UTILITY_TRACE(g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_tag || ' : '
2827: || g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_data);
2828:
2829: /* Supplemental Data 2 */
2830: g_ee_record(RS_SUPPLEMENTAL_DATA_2).employee_data := ' ';

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

2827: || g_ee_record(RS_SUPPLEMENTAL_DATA_1).employee_data);
2828:
2829: /* Supplemental Data 2 */
2830: g_ee_record(RS_SUPPLEMENTAL_DATA_2).employee_data := ' ';
2831: HR_UTILITY_TRACE(g_ee_record(RS_SUPPLEMENTAL_DATA_2).employee_tag || ' : '
2832: || g_ee_record(RS_SUPPLEMENTAL_DATA_2).employee_data);
2833:
2834: /* Bug 7456383 : RS_STATE_CONTROL_NUMBER */
2835: g_ee_record(RS_STATE_CONTROL_NUMBER).employee_data := ' ';

Line 2836: HR_UTILITY_TRACE(g_ee_record(RS_STATE_CONTROL_NUMBER).employee_tag || ' : '

2832: || g_ee_record(RS_SUPPLEMENTAL_DATA_2).employee_data);
2833:
2834: /* Bug 7456383 : RS_STATE_CONTROL_NUMBER */
2835: g_ee_record(RS_STATE_CONTROL_NUMBER).employee_data := ' ';
2836: HR_UTILITY_TRACE(g_ee_record(RS_STATE_CONTROL_NUMBER).employee_tag || ' : '
2837: || g_ee_record(RS_STATE_CONTROL_NUMBER).employee_data);
2838:
2839: --
2840: -- Locality Data Items

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

2838:
2839: --
2840: -- Locality Data Items
2841: --
2842: HR_UTILITY_TRACE('Processing Locality Level Data for the Employee');
2843:
2844: IF p_locality_code = 'NULL' THEN
2845: l_locality_code := NULL;
2846: ELSE

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

2911: ltr_ue_locality(k).negative_check := 'Y';
2912:
2913:
2914:
2915: HR_UTILITY_TRACE('YE Assignment_Action_Id '|| to_char(p_ye_assignment_action_id));
2916: HR_UTILITY_TRACE('State Code '|| lpad(p_state_code,2,'0'));
2917: HR_UTILITY_TRACE('Locality Code '|| l_locality_code);
2918:
2919: OPEN c_locality_jurisdiction(p_ye_assignment_action_id,

Line 2916: HR_UTILITY_TRACE('State Code '|| lpad(p_state_code,2,'0'));

2912:
2913:
2914:
2915: HR_UTILITY_TRACE('YE Assignment_Action_Id '|| to_char(p_ye_assignment_action_id));
2916: HR_UTILITY_TRACE('State Code '|| lpad(p_state_code,2,'0'));
2917: HR_UTILITY_TRACE('Locality Code '|| l_locality_code);
2918:
2919: OPEN c_locality_jurisdiction(p_ye_assignment_action_id,
2920: /* Bug 7592972 : State Code should be passed as two character

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

2913:
2914:
2915: HR_UTILITY_TRACE('YE Assignment_Action_Id '|| to_char(p_ye_assignment_action_id));
2916: HR_UTILITY_TRACE('State Code '|| lpad(p_state_code,2,'0'));
2917: HR_UTILITY_TRACE('Locality Code '|| l_locality_code);
2918:
2919: OPEN c_locality_jurisdiction(p_ye_assignment_action_id,
2920: /* Bug 7592972 : State Code should be passed as two character
2921: long Code to the cursor c_locality_jurisdiction

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

2924: l_locality_code);
2925: LOOP
2926: l_jurisdiction_code := NULL;
2927: FETCH c_locality_jurisdiction INTO l_jurisdiction_code;
2928: HR_UTILITY_TRACE('Processing Jurisdiction '|| l_jurisdiction_code);
2929: EXIT WHEN c_locality_jurisdiction%NOTFOUND;
2930: IF l_jurisdiction_code IS NOT NULL
2931: THEN
2932: --{

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

2970:
2971: ELSE
2972: ltr_ue_locality(j).ue_value := '0';
2973: END IF;
2974: HR_UTILITY_TRACE('DBI ' || ltr_ue_locality(J).ue_data_level ||
2975: ' -('||to_char(j)|| ') : < ' || ltr_ue_locality(j).ue_name||
2976: ' > VALUE : < '|| ltr_ue_locality(j).ue_value||' >');
2977:
2978: END LOOP;

Line 3001: HR_UTILITY.trace('l_jurisdiction_code' || l_jurisdiction_code);

2997: i := to_number(substr(l_jurisdiction_code,1,2) ||
2998: substr(l_jurisdiction_code,4,3) ||
2999: substr(l_jurisdiction_code,8,4) );
3000:
3001: HR_UTILITY.trace('l_jurisdiction_code' || l_jurisdiction_code);
3002: on_visa := 'N';
3003: non_state_res := 'N';
3004:
3005: IF ltr_local_record.EXISTS(i) THEN

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

3069: ltr_local_record(i).locality_tax := l_city_tax_withheld;
3070: END IF;
3071:
3072:
3073: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);
3074: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
3075: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
3076: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
3077: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);

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

3070: END IF;
3071:
3072:
3073: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);
3074: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
3075: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
3076: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
3077: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
3078: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);

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

3071:
3072:
3073: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);
3074: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
3075: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
3076: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
3077: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
3078: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);
3079: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);

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

3072:
3073: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);
3074: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
3075: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
3076: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
3077: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
3078: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);
3079: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);
3080: --}

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

3073: HR_UTILITY_TRACE('Locality Jurisdiction :' || ltr_local_record(i).jurisdiction);
3074: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
3075: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
3076: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
3077: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
3078: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);
3079: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);
3080: --}
3081: END IF;

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

3074: HR_UTILITY_TRACE(' City Name :' || ltr_local_record(i).city_name);
3075: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
3076: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
3077: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
3078: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);
3079: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);
3080: --}
3081: END IF;
3082: END IF;

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

3075: HR_UTILITY_TRACE(' County Name :' || ltr_local_record(i).county_name);
3076: HR_UTILITY_TRACE(' Tax Type :' || ltr_local_record(i).tax_type);
3077: HR_UTILITY_TRACE(' City Code :' || ltr_local_record(i).locality_code);
3078: HR_UTILITY_TRACE(' City Wages :' || ltr_local_record(i).locality_wages);
3079: HR_UTILITY_TRACE(' City Withheld :' || ltr_local_record(i).locality_tax);
3080: --}
3081: END IF;
3082: END IF;
3083:

Line 3102: HR_UTILITY_TRACE(l_data_item_xml);

3098: l_data_item_xml := '<'||g_ee_record(I).employee_tag||'>'||
3099: convert_special_char(nvl(g_ee_record(I).employee_data,' '))
3100: ||''|| EOL;
3101: l_final_xml_string := l_final_xml_string || l_data_item_xml;
3102: HR_UTILITY_TRACE(l_data_item_xml);
3103: END LOOP;
3104: /*
3105: This got added for FIT Withheld at 3rd Party Payer
3106: This Balance is not reported in RW record but total is reported in RT record

Line 3117: HR_UTILITY_TRACE(l_data_item_xml);

3113: l_data_item_xml := '<'||g_ee_record(W2_HEALTH_COVERAGE).employee_tag||'>'||
3114: convert_special_char(nvl(g_ee_record(W2_HEALTH_COVERAGE).employee_data,' '))
3115: ||''|| EOL;
3116: l_final_xml_string := l_final_xml_string || l_data_item_xml;
3117: HR_UTILITY_TRACE(l_data_item_xml);
3118:
3119: l_final_xml_string := l_final_xml_string || '' || EOL;
3120: EXCEPTION
3121: WHEN OTHERS THEN

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

3118:
3119: l_final_xml_string := l_final_xml_string || '' || EOL;
3120: EXCEPTION
3121: WHEN OTHERS THEN
3122: HR_UTILITY_TRACE('Error Encountered While formating RW Record Data Item');
3123: END;
3124: HR_UTILITY_TRACE(' RW Record Formatted Successfully Length '|| length(l_final_xml_string));
3125:
3126: /* Merge RO Record Data Compoents to XML Construct */

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

3120: EXCEPTION
3121: WHEN OTHERS THEN
3122: HR_UTILITY_TRACE('Error Encountered While formating RW Record Data Item');
3123: END;
3124: HR_UTILITY_TRACE(' RW Record Formatted Successfully Length '|| length(l_final_xml_string));
3125:
3126: /* Merge RO Record Data Compoents to XML Construct */
3127: l_final_xml_string := l_final_xml_string
3128: || '<'||convert_special_char(g_ee_record(43).employee_data)||'>';

Line 3143: HR_UTILITY_TRACE(l_data_item_xml);

3139: LOOP
3140: l_data_item_xml := '<'||g_ee_record(I).employee_tag||'>'||
3141: convert_special_char(nvl(g_ee_record(I).employee_data,' '))
3142: ||''|| EOL;
3143: HR_UTILITY_TRACE(l_data_item_xml);
3144: l_final_xml_string := l_final_xml_string || l_data_item_xml;
3145: END LOOP;
3146:
3147: /* Bug 13419620 : A_W2_ROTH_457B_PER_GRE_YTD */

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

3152: l_final_xml_string := l_final_xml_string || ' 3153: || '>' || EOL;
3154: EXCEPTION
3155: WHEN OTHERS THEN
3156: HR_UTILITY_TRACE('Error Encountered While formating RO Record Data Item');
3157: END;
3158: HR_UTILITY_TRACE(' RO Record Formatted Successfully Length '|| length(l_final_xml_string));
3159:
3160: /* Merge RS Record Data Compoents to XML Construct */

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

3154: EXCEPTION
3155: WHEN OTHERS THEN
3156: HR_UTILITY_TRACE('Error Encountered While formating RO Record Data Item');
3157: END;
3158: HR_UTILITY_TRACE(' RO Record Formatted Successfully Length '|| length(l_final_xml_string));
3159:
3160: /* Merge RS Record Data Compoents to XML Construct */
3161: l_final_xml_string := l_final_xml_string || '';
3162: BEGIN

Line 3168: HR_UTILITY_TRACE(l_data_item_xml);

3164: LOOP
3165: l_data_item_xml := '<'||g_ee_record(I).employee_tag||'>'||
3166: convert_special_char(nvl(g_ee_record(I).employee_data,' '))
3167: ||''|| EOL;
3168: HR_UTILITY_TRACE(l_data_item_xml);
3169: l_final_xml_string := l_final_xml_string || l_data_item_xml;
3170: END LOOP;
3171:
3172: /* Bug 7456383 : RS_STATE_CONTROL_NUMBER */

Line 3176: HR_UTILITY_TRACE(l_data_item_xml);

3172: /* Bug 7456383 : RS_STATE_CONTROL_NUMBER */
3173: l_data_item_xml := '<'||g_ee_record(RS_STATE_CONTROL_NUMBER).employee_tag||'>'||
3174: convert_special_char(nvl(g_ee_record(RS_STATE_CONTROL_NUMBER).employee_data,' '))||
3175: ''|| EOL;
3176: HR_UTILITY_TRACE(l_data_item_xml);
3177: l_final_xml_string := l_final_xml_string || l_data_item_xml;
3178:
3179: l_final_xml_string := l_final_xml_string || '' || EOL;
3180:

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

3179: l_final_xml_string := l_final_xml_string || '' || EOL;
3180:
3181: EXCEPTION
3182: WHEN OTHERS THEN
3183: HR_UTILITY_TRACE('Error Encountered While formating RS Record Data Item');
3184: END;
3185: HR_UTILITY_TRACE(' RS Record Formatted Successfully Length '|| length(l_final_xml_string));
3186: --
3187: -- Following Procedure will initialize Locality Data Item Tags

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

3181: EXCEPTION
3182: WHEN OTHERS THEN
3183: HR_UTILITY_TRACE('Error Encountered While formating RS Record Data Item');
3184: END;
3185: HR_UTILITY_TRACE(' RS Record Formatted Successfully Length '|| length(l_final_xml_string));
3186: --
3187: -- Following Procedure will initialize Locality Data Item Tags
3188: --
3189: populate_ee_locality_tag;

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

3187: -- Following Procedure will initialize Locality Data Item Tags
3188: --
3189: populate_ee_locality_tag;
3190:
3191: HR_UTILITY_TRACE(' Formating Locality Records for Employee ');
3192: -- l_final_xml_string := l_final_xml_string || '';
3193:
3194: IF ltr_local_record.COUNT >= 1
3195: THEN

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

3228: || '<'|| ltr_ee_locality_tag(13)||'>'||
3229: convert_special_char(nvl(ltr_local_record(i).locality_tax ,' '))
3230: ||''|| EOL
3231: ||'' || EOL;
3232: HR_UTILITY_TRACE('SD XML '|| l_data_item_xml);
3233:
3234: ELSE l_data_item_xml := ''||
3235: '<'|| ltr_ee_locality_tag(CITY_JURISDICTION)||'>'||
3236: convert_special_char(nvl(ltr_local_record(i).jurisdiction ,' '))

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

3268: || '<'|| ltr_ee_locality_tag(18)||'>'||
3269: convert_special_char(nvl(ltr_local_record(i).NON_STATE_WITHHELD ,' '))
3270: ||''|| EOL
3271: ||'' || EOL; -- 2180670
3272: HR_UTILITY_TRACE('Locality XML '|| l_data_item_xml);
3273: --}
3274: END IF;
3275:
3276: -- Bug # 6117216 SD Reporting Changes END

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

3286: p_final_string := l_final_xml_string;
3287: --}
3288: EXCEPTION
3289: WHEN OTHERS THEN
3290: HR_UTILITY_TRACE('Error Encountered in procedure populate_arch_employee');
3291: END populate_arch_employee; -- End of Procedure populate_arch_employee
3292:
3293:
3294: BEGIN

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

3291: END populate_arch_employee; -- End of Procedure populate_arch_employee
3292:
3293:
3294: BEGIN
3295: -- hr_utility.trace_on(null, 'USLOCALW2');
3296: g_proc_name := 'pay_us_w2_generic_extract.';
3297: g_debug := hr_utility.debug_enabled;
3298: g_document_type := 'LOCAL_W2_XML';
3299: END pay_us_w2_generic_extract;

Line 3297: g_debug := hr_utility.debug_enabled;

3293:
3294: BEGIN
3295: -- hr_utility.trace_on(null, 'USLOCALW2');
3296: g_proc_name := 'pay_us_w2_generic_extract.';
3297: g_debug := hr_utility.debug_enabled;
3298: g_document_type := 'LOCAL_W2_XML';
3299: END pay_us_w2_generic_extract;