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

Line 36: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);

32:
33: lv_format varchar2(32000);
34:
35: BEGIN
36: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
37: if p_output_file_type = 'CSV' then
38: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
39:
40: lv_format := gc_csv_data_delimiter || p_input_string ||

Line 38: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);

34:
35: BEGIN
36: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
37: if p_output_file_type = 'CSV' then
38: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
39:
40: lv_format := gc_csv_data_delimiter || p_input_string ||
41: gc_csv_data_delimiter || gc_csv_delimiter;
42:

Line 45: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);

41: gc_csv_data_delimiter || gc_csv_delimiter;
42:
43: end if;
44:
45: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
46: return lv_format;
47:
48: END formated_data_string;
49:

Line 66: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);

62: lv_format2 varchar2(32000);
63:
64: BEGIN
65:
66: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
67: IF gv_report_type = 'SMWL' THEN /* Condition added for Bug 14456648 */
68:
69: lv_format1 :=
70: formated_data_string (p_input_string => 'GRE'

Line 206: hr_utility.set_location(gv_package_name || '.formated_static_header_NM', 10);

202: lv_format2 varchar2(32000);
203:
204: BEGIN
205:
206: hr_utility.set_location(gv_package_name || '.formated_static_header_NM', 10);
207: lv_format1 :=
208: formated_data_string (p_input_string => 'GRE'
209: ,p_bold => 'Y'
210: ,p_output_file_type => p_output_file_type) ||

Line 291: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);

287: lv_format2 varchar2(32000);
288:
289: BEGIN
290:
291: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
292: lv_format1 :=
293: formated_data_string (p_input_string => 'GRE'
294: ,p_bold => 'Y'
295: ,p_output_file_type => p_output_file_type) ||

Line 381: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);

377: lv_format2 varchar2(32000);
378:
379: BEGIN
380:
381: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
382: lv_format1 :=
383: formated_data_string (p_input_string => 'GRE'
384: ,p_bold => 'Y'
385: ,p_output_file_type => p_output_file_type) ||

Line 492: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);

488:
489:
490: BEGIN
491:
492: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
493: lv_format1 :=
494: formated_data_string (p_input_string => p_tax_unit_name
495: ,p_output_file_type => p_output_file_type)||
496: formated_data_string (p_input_string => p_organization_name

Line 533: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);

529: ,p_output_file_type => p_output_file_type) ||
530: formated_data_string (p_input_string => p_weeks_worked
531: ,p_output_file_type => p_output_file_type) ;
532:
533: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
534:
535:
536: -- p_static_data1 := lv_format1;
537: -- p_static_data2 := lv_format2;

Line 538: hr_utility.trace('Static Data1 = ' || lv_format1);

534:
535:
536: -- p_static_data1 := lv_format1;
537: -- p_static_data2 := lv_format2;
538: hr_utility.trace('Static Data1 = ' || lv_format1);
539: hr_utility.trace('Static Data2 = ' || lv_format2);
540: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
541:
542: return (lv_format1);

Line 539: hr_utility.trace('Static Data2 = ' || lv_format2);

535:
536: -- p_static_data1 := lv_format1;
537: -- p_static_data2 := lv_format2;
538: hr_utility.trace('Static Data1 = ' || lv_format1);
539: hr_utility.trace('Static Data2 = ' || lv_format2);
540: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
541:
542: return (lv_format1);
543: END;

Line 540: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

536: -- p_static_data1 := lv_format1;
537: -- p_static_data2 := lv_format2;
538: hr_utility.trace('Static Data1 = ' || lv_format1);
539: hr_utility.trace('Static Data2 = ' || lv_format2);
540: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
541:
542: return (lv_format1);
543: END;
544:

Line 582: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);

578:
579:
580: BEGIN
581:
582: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
583: lv_format1 :=
584: formated_data_string (p_input_string => p_tax_unit_name
585: ,p_output_file_type => p_output_file_type)||
586: formated_data_string (p_input_string => p_organization_name

Line 631: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);

627: ,p_output_file_type => p_output_file_type) ||
628: formated_data_string (p_input_string => p_hours_worked
629: ,p_output_file_type => p_output_file_type) ;
630:
631: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
632:
633:
634: hr_utility.trace('Static Data1 = ' || lv_format1);
635: hr_utility.trace('Static Data2 = ' || lv_format2);

Line 634: hr_utility.trace('Static Data1 = ' || lv_format1);

630:
631: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
632:
633:
634: hr_utility.trace('Static Data1 = ' || lv_format1);
635: hr_utility.trace('Static Data2 = ' || lv_format2);
636: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
637:
638: return (lv_format1);

Line 635: hr_utility.trace('Static Data2 = ' || lv_format2);

631: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
632:
633:
634: hr_utility.trace('Static Data1 = ' || lv_format1);
635: hr_utility.trace('Static Data2 = ' || lv_format2);
636: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
637:
638: return (lv_format1);
639: END;

Line 636: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

632:
633:
634: hr_utility.trace('Static Data1 = ' || lv_format1);
635: hr_utility.trace('Static Data2 = ' || lv_format2);
636: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
637:
638: return (lv_format1);
639: END;
640:

Line 680: hr_utility.set_location(gv_package_name || '.formated_static_data_NM', 10);

676:
677:
678: BEGIN
679:
680: hr_utility.set_location(gv_package_name || '.formated_static_data_NM', 10);
681: lv_format1 :=
682: formated_data_string (p_input_string => p_tax_unit_name
683: ,p_output_file_type => p_output_file_type)||
684: formated_data_string (p_input_string => p_organization_name

Line 737: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);

733: ,p_output_file_type => p_output_file_type)||
734: formated_data_string (p_input_string => p_workers_comp_withheld
735: ,p_output_file_type => p_output_file_type) ;
736:
737: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
738:
739: hr_utility.trace('Static Data1 = ' || lv_format1);
740: hr_utility.trace('Static Data2 = ' || lv_format2);
741: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

Line 739: hr_utility.trace('Static Data1 = ' || lv_format1);

735: ,p_output_file_type => p_output_file_type) ;
736:
737: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
738:
739: hr_utility.trace('Static Data1 = ' || lv_format1);
740: hr_utility.trace('Static Data2 = ' || lv_format2);
741: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
742:
743: return (lv_format1);

Line 740: hr_utility.trace('Static Data2 = ' || lv_format2);

736:
737: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
738:
739: hr_utility.trace('Static Data1 = ' || lv_format1);
740: hr_utility.trace('Static Data2 = ' || lv_format2);
741: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
742:
743: return (lv_format1);
744: END;

Line 741: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

737: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
738:
739: hr_utility.trace('Static Data1 = ' || lv_format1);
740: hr_utility.trace('Static Data2 = ' || lv_format2);
741: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
742:
743: return (lv_format1);
744: END;
745:

Line 783: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);

779:
780:
781: BEGIN
782:
783: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
784: lv_format1 :=
785: formated_data_string (p_input_string => p_tax_unit_name
786: ,p_output_file_type => p_output_file_type)||
787: formated_data_string (p_input_string => p_organization_name

Line 835: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);

831: formated_data_string (p_input_string => p_pre_tax_dedns_pgy
832: ,p_output_file_type => p_output_file_type);
833:
834:
835: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
836:
837:
838: hr_utility.trace('Static Data1 = ' || lv_format1);
839: hr_utility.trace('Static Data2 = ' || lv_format2);

Line 838: hr_utility.trace('Static Data1 = ' || lv_format1);

834:
835: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
836:
837:
838: hr_utility.trace('Static Data1 = ' || lv_format1);
839: hr_utility.trace('Static Data2 = ' || lv_format2);
840: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
841:
842: return (lv_format1);

Line 839: hr_utility.trace('Static Data2 = ' || lv_format2);

835: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
836:
837:
838: hr_utility.trace('Static Data1 = ' || lv_format1);
839: hr_utility.trace('Static Data2 = ' || lv_format2);
840: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
841:
842: return (lv_format1);
843: END;

Line 840: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

836:
837:
838: hr_utility.trace('Static Data1 = ' || lv_format1);
839: hr_utility.trace('Static Data2 = ' || lv_format2);
840: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
841:
842: return (lv_format1);
843: END;
844:

Line 1054: --hr_utility.trace_on (null, 'SQWLNEG');

1050:
1051:
1052: BEGIN
1053:
1054: --hr_utility.trace_on (null, 'SQWLNEG');
1055: hr_utility.trace ('Entered Main package');
1056: hr_utility.trace ('Payroll Action Id = '||to_char(p_payroll_action_id));
1057: hr_utility.trace ('Qtrname = '||p_qtrname);
1058:

Line 1055: hr_utility.trace ('Entered Main package');

1051:
1052: BEGIN
1053:
1054: --hr_utility.trace_on (null, 'SQWLNEG');
1055: hr_utility.trace ('Entered Main package');
1056: hr_utility.trace ('Payroll Action Id = '||to_char(p_payroll_action_id));
1057: hr_utility.trace ('Qtrname = '||p_qtrname);
1058:
1059: /* Change for Bug 14456648 starts */

Line 1056: hr_utility.trace ('Payroll Action Id = '||to_char(p_payroll_action_id));

1052: BEGIN
1053:
1054: --hr_utility.trace_on (null, 'SQWLNEG');
1055: hr_utility.trace ('Entered Main package');
1056: hr_utility.trace ('Payroll Action Id = '||to_char(p_payroll_action_id));
1057: hr_utility.trace ('Qtrname = '||p_qtrname);
1058:
1059: /* Change for Bug 14456648 starts */
1060: open c_get_report_type(p_payroll_action_id);

Line 1057: hr_utility.trace ('Qtrname = '||p_qtrname);

1053:
1054: --hr_utility.trace_on (null, 'SQWLNEG');
1055: hr_utility.trace ('Entered Main package');
1056: hr_utility.trace ('Payroll Action Id = '||to_char(p_payroll_action_id));
1057: hr_utility.trace ('Qtrname = '||p_qtrname);
1058:
1059: /* Change for Bug 14456648 starts */
1060: open c_get_report_type(p_payroll_action_id);
1061: fetch c_get_report_type into gv_report_type;

Line 1071: hr_utility.trace ('Opened c_assignment cursor');

1067:
1068:
1069:
1070: open c_assignments(p_payroll_action_id);
1071: hr_utility.trace ('Opened c_assignment cursor');
1072: loop
1073:
1074: /* Initialixe variables */
1075:

Line 1146: hr_utility.trace('Into Row Count = 0 ');

1142: lv_report_category;
1143:
1144: if c_assignments%NOTFOUND then
1145: if c_assignments%ROWCOUNT = 0 then
1146: hr_utility.trace('Into Row Count = 0 ');
1147: lv_state_abbrev := null;
1148:
1149: open c_state(p_payroll_action_id);
1150: fetch c_state into lv_state_abbrev,lv_bgrp_id;

Line 1183: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));

1179: exit;
1180: end if;
1181: lv_full_name := replace(lv_full_name_wc,',');
1182:
1183: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));
1184: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1185: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1186: hr_utility.trace('lv_full_name ='||lv_full_name);
1187: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);

Line 1184: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));

1180: end if;
1181: lv_full_name := replace(lv_full_name_wc,',');
1182:
1183: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));
1184: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1185: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1186: hr_utility.trace('lv_full_name ='||lv_full_name);
1187: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1188: hr_utility.trace('lv_state_code ='||lv_state_code);

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

1181: lv_full_name := replace(lv_full_name_wc,',');
1182:
1183: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));
1184: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1185: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1186: hr_utility.trace('lv_full_name ='||lv_full_name);
1187: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1188: hr_utility.trace('lv_state_code ='||lv_state_code);
1189: hr_utility.trace('lv_report_category ='||lv_report_category);

Line 1186: hr_utility.trace('lv_full_name ='||lv_full_name);

1182:
1183: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));
1184: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1185: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1186: hr_utility.trace('lv_full_name ='||lv_full_name);
1187: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1188: hr_utility.trace('lv_state_code ='||lv_state_code);
1189: hr_utility.trace('lv_report_category ='||lv_report_category);
1190:

Line 1187: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);

1183: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));
1184: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1185: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1186: hr_utility.trace('lv_full_name ='||lv_full_name);
1187: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1188: hr_utility.trace('lv_state_code ='||lv_state_code);
1189: hr_utility.trace('lv_report_category ='||lv_report_category);
1190:
1191: open c_archive_dtls(ln_asg_act_id,

Line 1188: hr_utility.trace('lv_state_code ='||lv_state_code);

1184: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1185: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1186: hr_utility.trace('lv_full_name ='||lv_full_name);
1187: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1188: hr_utility.trace('lv_state_code ='||lv_state_code);
1189: hr_utility.trace('lv_report_category ='||lv_report_category);
1190:
1191: open c_archive_dtls(ln_asg_act_id,
1192: ln_tax_unit_id,

Line 1189: hr_utility.trace('lv_report_category ='||lv_report_category);

1185: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1186: hr_utility.trace('lv_full_name ='||lv_full_name);
1187: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1188: hr_utility.trace('lv_state_code ='||lv_state_code);
1189: hr_utility.trace('lv_report_category ='||lv_report_category);
1190:
1191: open c_archive_dtls(ln_asg_act_id,
1192: ln_tax_unit_id,
1193: lv_state_code);

Line 1194: hr_utility.trace('Opened c_archive_dtls');

1190:
1191: open c_archive_dtls(ln_asg_act_id,
1192: ln_tax_unit_id,
1193: lv_state_code);
1194: hr_utility.trace('Opened c_archive_dtls');
1195: loop
1196: fetch c_archive_dtls into lv_user_name
1197: ,lv_value;
1198:

Line 1328: hr_utility.trace('Opened c_archive_dtls_fed');

1324:
1325:
1326: open c_archive_dtls_fed(ln_asg_act_id,
1327: ln_tax_unit_id);
1328: hr_utility.trace('Opened c_archive_dtls_fed');
1329: loop
1330: fetch c_archive_dtls_fed into lv_user_name
1331: ,lv_value;
1332:

Line 1367: hr_utility.trace('Getting A_SCL_ASG_US_WORK_SCHEDULE ');

1363:
1364: FOR I in c_get_asg_details(ln_asg_act_id, ln_asg_id)
1365: LOOP
1366: IF I.user_name = 'A_SCL_ASG_US_WORK_SCHEDULE' THEN
1367: hr_utility.trace('Getting A_SCL_ASG_US_WORK_SCHEDULE ');
1368: lv_work_schedule := I.value;
1369: ELSIF I.user_name = 'A_ASG_HOURS' THEN
1370: lv_asg_hours := I.value;
1371: ELSIF I.user_name = 'A_ASG_FREQ' THEN

Line 1376: hr_utility.trace('A_SCL_ASG_US_WORK_SCHEDULE ' ||lv_work_schedule);

1372: lv_asg_freq := I.value;
1373: END IF;
1374: END LOOP;
1375:
1376: hr_utility.trace('A_SCL_ASG_US_WORK_SCHEDULE ' ||lv_work_schedule);
1377: hr_utility.trace('A_ASG_HOURS ' ||lv_asg_hours);
1378: hr_utility.trace('A_ASG_FREQ ' ||lv_asg_freq);
1379:
1380: /* Need business group id for calculating weeks worked */

Line 1377: hr_utility.trace('A_ASG_HOURS ' ||lv_asg_hours);

1373: END IF;
1374: END LOOP;
1375:
1376: hr_utility.trace('A_SCL_ASG_US_WORK_SCHEDULE ' ||lv_work_schedule);
1377: hr_utility.trace('A_ASG_HOURS ' ||lv_asg_hours);
1378: hr_utility.trace('A_ASG_FREQ ' ||lv_asg_freq);
1379:
1380: /* Need business group id for calculating weeks worked */
1381:

Line 1378: hr_utility.trace('A_ASG_FREQ ' ||lv_asg_freq);

1374: END LOOP;
1375:
1376: hr_utility.trace('A_SCL_ASG_US_WORK_SCHEDULE ' ||lv_work_schedule);
1377: hr_utility.trace('A_ASG_HOURS ' ||lv_asg_hours);
1378: hr_utility.trace('A_ASG_FREQ ' ||lv_asg_freq);
1379:
1380: /* Need business group id for calculating weeks worked */
1381:
1382: OPEN c_state(p_payroll_action_id);

Line 1390: hr_utility.trace('Going to calculate derived balances');

1386: END IF;
1387: CLOSE c_state;
1388:
1389: /* calculate the derived balances here */
1390: hr_utility.trace('Going to calculate derived balances');
1391:
1392: lv_sui_qtr_wages := lv_sui_er_subjwh - lv_sui_er_pre_tax_redns;
1393: lv_sui_excess := lv_sui_qtr_wages - lv_sui_er_taxable;
1394: lv_sit_qtr_wages := lv_sit_subjwh + lv_sit_subjnwh - lv_sit_pre_tax_redns;

Line 1398: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);

1394: lv_sit_qtr_wages := lv_sit_subjwh + lv_sit_subjnwh - lv_sit_pre_tax_redns;
1395: lv_sdi_qtr_wages := lv_sdi_subjwh - lv_sdi_pre_tax_redns;
1396: lv_sdi_excess := lv_sdi_subjwh - lv_sdi_pre_tax_redns - lv_sdi_taxable;
1397:
1398: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);
1399: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1400: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1401: hr_utility.trace('Qtrname ='||p_qtrname);
1402: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);

Line 1399: hr_utility.trace('lv_organization_name ='||lv_organization_name);

1395: lv_sdi_qtr_wages := lv_sdi_subjwh - lv_sdi_pre_tax_redns;
1396: lv_sdi_excess := lv_sdi_subjwh - lv_sdi_pre_tax_redns - lv_sdi_taxable;
1397:
1398: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);
1399: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1400: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1401: hr_utility.trace('Qtrname ='||p_qtrname);
1402: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1403: hr_utility.trace('lv_full_name ='||lv_full_name);

Line 1400: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);

1396: lv_sdi_excess := lv_sdi_subjwh - lv_sdi_pre_tax_redns - lv_sdi_taxable;
1397:
1398: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);
1399: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1400: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1401: hr_utility.trace('Qtrname ='||p_qtrname);
1402: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1403: hr_utility.trace('lv_full_name ='||lv_full_name);
1404: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);

Line 1401: hr_utility.trace('Qtrname ='||p_qtrname);

1397:
1398: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);
1399: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1400: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1401: hr_utility.trace('Qtrname ='||p_qtrname);
1402: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1403: hr_utility.trace('lv_full_name ='||lv_full_name);
1404: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1405: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);

Line 1402: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);

1398: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);
1399: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1400: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1401: hr_utility.trace('Qtrname ='||p_qtrname);
1402: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1403: hr_utility.trace('lv_full_name ='||lv_full_name);
1404: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1405: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1406: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);

Line 1403: hr_utility.trace('lv_full_name ='||lv_full_name);

1399: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1400: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1401: hr_utility.trace('Qtrname ='||p_qtrname);
1402: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1403: hr_utility.trace('lv_full_name ='||lv_full_name);
1404: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1405: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1406: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1407: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);

Line 1404: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);

1400: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1401: hr_utility.trace('Qtrname ='||p_qtrname);
1402: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1403: hr_utility.trace('lv_full_name ='||lv_full_name);
1404: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1405: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1406: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1407: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1408: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);

Line 1405: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);

1401: hr_utility.trace('Qtrname ='||p_qtrname);
1402: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1403: hr_utility.trace('lv_full_name ='||lv_full_name);
1404: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1405: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1406: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1407: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1408: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1409: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);

Line 1406: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);

1402: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1403: hr_utility.trace('lv_full_name ='||lv_full_name);
1404: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1405: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1406: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1407: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1408: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1409: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1410: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);

Line 1407: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);

1403: hr_utility.trace('lv_full_name ='||lv_full_name);
1404: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1405: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1406: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1407: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1408: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1409: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1410: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1411: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);

Line 1408: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);

1404: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1405: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1406: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1407: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1408: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1409: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1410: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1411: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1412: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);

Line 1409: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);

1405: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1406: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1407: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1408: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1409: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1410: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1411: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1412: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1413: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);

Line 1410: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);

1406: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1407: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1408: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1409: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1410: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1411: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1412: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1413: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1414: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);

Line 1411: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);

1407: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1408: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1409: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1410: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1411: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1412: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1413: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1414: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1415: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);

Line 1412: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);

1408: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1409: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1410: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1411: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1412: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1413: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1414: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1415: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1416: hr_utility.trace('lv_sit_125 ='||lv_sit_125);

Line 1413: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);

1409: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1410: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1411: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1412: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1413: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1414: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1415: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1416: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1417: hr_utility.trace('lv_sit_401 ='||lv_sit_401);

Line 1414: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);

1410: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1411: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1412: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1413: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1414: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1415: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1416: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1417: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1418: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);

Line 1415: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);

1411: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1412: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1413: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1414: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1415: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1416: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1417: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1418: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1419: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);

Line 1416: hr_utility.trace('lv_sit_125 ='||lv_sit_125);

1412: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1413: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1414: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1415: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1416: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1417: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1418: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1419: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1420: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);

Line 1417: hr_utility.trace('lv_sit_401 ='||lv_sit_401);

1413: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1414: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1415: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1416: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1417: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1418: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1419: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1420: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1421: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);

Line 1418: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);

1414: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1415: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1416: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1417: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1418: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1419: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1420: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1421: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1422: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);

Line 1419: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);

1415: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1416: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1417: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1418: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1419: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1420: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1421: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1422: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1423: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);

Line 1420: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);

1416: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1417: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1418: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1419: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1420: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1421: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1422: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1423: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1424: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);

Line 1421: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);

1417: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1418: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1419: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1420: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1421: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1422: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1423: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1424: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1425: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);

Line 1422: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);

1418: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1419: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1420: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1421: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1422: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1423: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1424: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1425: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1426: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);

Line 1423: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);

1419: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1420: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1421: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1422: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1423: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1424: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1425: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1426: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1427: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);

Line 1424: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);

1420: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1421: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1422: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1423: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1424: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1425: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1426: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1427: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1428: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);

Line 1425: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);

1421: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1422: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1423: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1424: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1425: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1426: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1427: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1428: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1429: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);

Line 1426: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);

1422: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1423: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1424: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1425: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1426: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1427: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1428: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1429: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1430: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);

Line 1427: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);

1423: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1424: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1425: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1426: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1427: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1428: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1429: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1430: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1431: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );

Line 1428: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);

1424: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1425: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1426: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1427: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1428: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1429: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1430: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1431: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1432: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);

Line 1429: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);

1425: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1426: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1427: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1428: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1429: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1430: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1431: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1432: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1433: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);

Line 1430: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);

1426: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1427: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1428: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1429: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1430: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1431: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1432: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1433: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1434: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);

Line 1431: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );

1427: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1428: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1429: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1430: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1431: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1432: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1433: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1434: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1435: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);

Line 1432: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);

1428: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1429: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1430: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1431: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1432: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1433: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1434: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1435: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);
1436: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);

Line 1433: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);

1429: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1430: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1431: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1432: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1433: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1434: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1435: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);
1436: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);
1437:

Line 1434: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);

1430: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1431: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1432: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1433: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1434: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1435: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);
1436: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);
1437:
1438:

Line 1435: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);

1431: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1432: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1433: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1434: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1435: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);
1436: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);
1437:
1438:
1439: /* regular hours */

Line 1436: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);

1432: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1433: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1434: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1435: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);
1436: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);
1437:
1438:
1439: /* regular hours */
1440:

Line 1452: hr_utility.trace('NO Data found. So setting c_get_hour_calc_method to default value');

1448: /* Bug:3044939 */
1449: IF c_get_hour_calc_method%NOTFOUND THEN
1450:
1451: lv_Hours_Worked_Calc_Method := 'W'; --Default Value
1452: hr_utility.trace('NO Data found. So setting c_get_hour_calc_method to default value');
1453:
1454: END IF;
1455:
1456: CLOSE c_get_hour_calc_method;

Line 1458: hr_utility.trace('lv_hours_worked_calc_method '||lv_hours_worked_calc_method);

1454: END IF;
1455:
1456: CLOSE c_get_hour_calc_method;
1457:
1458: hr_utility.trace('lv_hours_worked_calc_method '||lv_hours_worked_calc_method);
1459:
1460: /* We have the Calculation Method. Lets calculate the hours and weeks worked */
1461:
1462: IF nvl(lv_Hours_Worked_Calc_Method,'W') = 'W' then

Line 1477: hr_utility.trace('lv_hours_worked =' || lv_hours_worked);

1473: + nvl(to_number(lv_sui_overtime_hours),0);
1474:
1475: END IF;
1476:
1477: hr_utility.trace('lv_hours_worked =' || lv_hours_worked);
1478: hr_utility.trace('lv_work_schedule =' || lv_work_schedule);
1479: hr_utility.trace('lv_asg_freq =' || lv_asg_freq);
1480: hr_utility.trace('lv_asg_hours =' || lv_asg_hours);
1481:

Line 1478: hr_utility.trace('lv_work_schedule =' || lv_work_schedule);

1474:
1475: END IF;
1476:
1477: hr_utility.trace('lv_hours_worked =' || lv_hours_worked);
1478: hr_utility.trace('lv_work_schedule =' || lv_work_schedule);
1479: hr_utility.trace('lv_asg_freq =' || lv_asg_freq);
1480: hr_utility.trace('lv_asg_hours =' || lv_asg_hours);
1481:
1482:

Line 1479: hr_utility.trace('lv_asg_freq =' || lv_asg_freq);

1475: END IF;
1476:
1477: hr_utility.trace('lv_hours_worked =' || lv_hours_worked);
1478: hr_utility.trace('lv_work_schedule =' || lv_work_schedule);
1479: hr_utility.trace('lv_asg_freq =' || lv_asg_freq);
1480: hr_utility.trace('lv_asg_hours =' || lv_asg_hours);
1481:
1482:
1483: IF (lv_work_schedule is null ) then

Line 1480: hr_utility.trace('lv_asg_hours =' || lv_asg_hours);

1476:
1477: hr_utility.trace('lv_hours_worked =' || lv_hours_worked);
1478: hr_utility.trace('lv_work_schedule =' || lv_work_schedule);
1479: hr_utility.trace('lv_asg_freq =' || lv_asg_freq);
1480: hr_utility.trace('lv_asg_hours =' || lv_asg_hours);
1481:
1482:
1483: IF (lv_work_schedule is null ) then
1484: lv_add_days := fffunc.add_days(sysdate,6);

Line 1489: hr_utility.trace('lv_add_days = '||lv_add_days);

1485: lv_hours_per_week := hr_us_ff_udfs.standard_hours_worked( lv_asg_hours,
1486: sysdate,
1487: lv_add_days,
1488: lv_asg_freq);
1489: hr_utility.trace('lv_add_days = '||lv_add_days);
1490: hr_utility.trace('lv_hours_per_week = '||to_char(lv_hours_per_week));
1491: ELSE
1492: lv_hours_per_week := hr_us_ff_udfs.work_schedule_total_hours(lv_bgrp_id,
1493: lv_work_schedule,

Line 1490: hr_utility.trace('lv_hours_per_week = '||to_char(lv_hours_per_week));

1486: sysdate,
1487: lv_add_days,
1488: lv_asg_freq);
1489: hr_utility.trace('lv_add_days = '||lv_add_days);
1490: hr_utility.trace('lv_hours_per_week = '||to_char(lv_hours_per_week));
1491: ELSE
1492: lv_hours_per_week := hr_us_ff_udfs.work_schedule_total_hours(lv_bgrp_id,
1493: lv_work_schedule,
1494: null,

Line 1496: hr_utility.trace('Work Schedule found = '||lv_work_schedule);

1492: lv_hours_per_week := hr_us_ff_udfs.work_schedule_total_hours(lv_bgrp_id,
1493: lv_work_schedule,
1494: null,
1495: null);
1496: hr_utility.trace('Work Schedule found = '||lv_work_schedule);
1497: hr_utility.trace('lv_hours_per_week = '||to_char(lv_hours_per_week));
1498: END IF;
1499:
1500: /* calculating the Weeks Worked */

Line 1497: hr_utility.trace('lv_hours_per_week = '||to_char(lv_hours_per_week));

1493: lv_work_schedule,
1494: null,
1495: null);
1496: hr_utility.trace('Work Schedule found = '||lv_work_schedule);
1497: hr_utility.trace('lv_hours_per_week = '||to_char(lv_hours_per_week));
1498: END IF;
1499:
1500: /* calculating the Weeks Worked */
1501: IF nvl(lv_hours_per_week,0) <> 0 THEN

Line 1502: hr_utility.trace('lv_hours_per_week <> 0 ');

1498: END IF;
1499:
1500: /* calculating the Weeks Worked */
1501: IF nvl(lv_hours_per_week,0) <> 0 THEN
1502: hr_utility.trace('lv_hours_per_week <> 0 ');
1503: lv_weeks_worked := round(lv_hours_worked/lv_hours_per_week);
1504: hr_utility.trace('lv_weeks_worked = '||to_char(lv_weeks_worked));
1505:
1506: IF lv_weeks_worked > 14 THEN

Line 1504: hr_utility.trace('lv_weeks_worked = '||to_char(lv_weeks_worked));

1500: /* calculating the Weeks Worked */
1501: IF nvl(lv_hours_per_week,0) <> 0 THEN
1502: hr_utility.trace('lv_hours_per_week <> 0 ');
1503: lv_weeks_worked := round(lv_hours_worked/lv_hours_per_week);
1504: hr_utility.trace('lv_weeks_worked = '||to_char(lv_weeks_worked));
1505:
1506: IF lv_weeks_worked > 14 THEN
1507: lv_weeks_worked := 14;
1508: END IF;

Line 1546: hr_utility.trace('Entered negative reporting loop');

1542: (lv_state_abbrev in ('MN' ,'VT' ,'OR' ,'WA' ,'WY' ) and lv_hours_worked < 0) or
1543: (lv_state_abbrev in ('MA','DE','OH') and lv_weeks_worked < 0)
1544: ) THEN
1545:
1546: hr_utility.trace('Entered negative reporting loop');
1547:
1548: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1549:
1550: if lv_neg_asg_count = 1 then

Line 1637: hr_utility.trace('Entered negative reporting loop');

1633: lv_sit_gross < 0 or
1634: lv_sit_withheld < 0 or
1635: lv_weeks_worked < 0) then
1636:
1637: hr_utility.trace('Entered negative reporting loop');
1638:
1639: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1640: if lv_neg_asg_count = 1 then
1641: fnd_file.put_line(fnd_file.output,formated_Static_header('CSV'));

Line 1722: hr_utility.trace('Entered negative reporting loop');

1718: lv_sui_excess < 0 or
1719: lv_sit_qtr_wages < 0 or
1720: lv_sit_withheld < 0 ) then
1721:
1722: hr_utility.trace('Entered negative reporting loop');
1723:
1724: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1725:
1726: if lv_neg_asg_count = 1 then

Line 1812: hr_utility.trace('Entered negative reporting loop');

1808: lv_workers_comp2_withheld < 0 or
1809: lv_workers_comp_withheld < 0
1810: ) then
1811:
1812: hr_utility.trace('Entered negative reporting loop');
1813:
1814: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1815:
1816: if lv_neg_asg_count = 1 then

Line 1915: hr_utility.trace('Entered negative reporting loop');

1911: lv_sui_excess < 0 or
1912: lv_sit_qtr_wages < 0 or
1913: lv_sit_withheld < 0 ) then
1914:
1915: hr_utility.trace('Entered negative reporting loop');
1916:
1917: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1918:
1919: if lv_neg_asg_count = 1 then

Line 2007: hr_utility.trace('Entered negative reporting loop');

2003: lv_sit_qtr_wages < 0 or
2004: lv_sit_withheld < 0 or
2005: lv_weeks_worked < 0) then
2006:
2007: hr_utility.trace('Entered negative reporting loop');
2008:
2009: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
2010:
2011: if lv_neg_asg_count = 1 then

Line 2098: hr_utility.trace('Entered negative reporting loop');

2094: lv_sui_er_taxable < 0 or
2095: lv_sit_qtr_wages < 0 or
2096: lv_sit_gross < 0 ) then
2097:
2098: hr_utility.trace('Entered negative reporting loop');
2099:
2100: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
2101:
2102: if lv_neg_asg_count = 1 then

Line 2192: hr_utility.trace('Entered negative reporting loop');

2188: lv_sit_qtr_wages < 0 or
2189: lv_sit_withheld < 0 or
2190: lv_hours_worked < 0 ) then
2191:
2192: hr_utility.trace('Entered negative reporting loop');
2193:
2194: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
2195:
2196: if lv_neg_asg_count = 1 then

Line 2200: hr_utility.trace('Inserted header in pay_us_rpt_totals');

2196: if lv_neg_asg_count = 1 then
2197:
2198: fnd_file.put_line(fnd_file.output,formated_Static_header('CSV'));
2199:
2200: hr_utility.trace('Inserted header in pay_us_rpt_totals');
2201:
2202: end if;
2203:
2204:

Line 2240: hr_utility.trace('Inserted header in pay_us_rpt_totals');

2236: if lv_neg_asg_count = 1 then
2237:
2238: fnd_file.put_line(fnd_file.output,formated_Static_header('CSV'));
2239:
2240: hr_utility.trace('Inserted header in pay_us_rpt_totals');
2241:
2242: end if;
2243:
2244:

Line 2297: hr_utility.trace('Entered negative reporting loop');

2293: lv_sdi_qtr_wages < 0 or
2294: lv_sdi_taxable < 0 or
2295: lv_sdi_excess < 0 ) then
2296:
2297: hr_utility.trace('Entered negative reporting loop');
2298:
2299: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
2300:
2301: if lv_neg_asg_count = 1 then

Line 2400: hr_utility.trace('lv_annual_gross_wages as cal = '||lv_annual_gross_wages);

2396: lv_char_value := to_number(lv_sit_withheld_pjgy);
2397: lv_char_value := to_number(lv_annual_gross_wages);
2398:
2399:
2400: hr_utility.trace('lv_annual_gross_wages as cal = '||lv_annual_gross_wages);
2401:
2402: if (lv_sui_qtr_wages < 0 or
2403: lv_sui_excess < 0 or
2404: lv_sui_er_taxable < 0 or

Line 2410: hr_utility.trace('Entered negative reporting loop');

2406: lv_sit_withheld < 0 or
2407: lv_sit_withheld_pjgy < 0 or
2408: lv_annual_gross_wages < 0 ) then
2409:
2410: hr_utility.trace('Entered negative reporting loop');
2411:
2412:
2413: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
2414: