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 34: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);

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

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

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

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

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

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

60: lv_format2 varchar2(32000);
61:
62: BEGIN
63:
64: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
65: lv_format1 :=
66: formated_data_string (p_input_string => 'GRE'
67: ,p_bold => 'Y'
68: ,p_output_file_type => p_output_file_type) ||

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

135: lv_format2 varchar2(32000);
136:
137: BEGIN
138:
139: hr_utility.set_location(gv_package_name || '.formated_static_header_NM', 10);
140: lv_format1 :=
141: formated_data_string (p_input_string => 'GRE'
142: ,p_bold => 'Y'
143: ,p_output_file_type => p_output_file_type) ||

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

220: lv_format2 varchar2(32000);
221:
222: BEGIN
223:
224: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
225: lv_format1 :=
226: formated_data_string (p_input_string => 'GRE'
227: ,p_bold => 'Y'
228: ,p_output_file_type => p_output_file_type) ||

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

310: lv_format2 varchar2(32000);
311:
312: BEGIN
313:
314: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
315: lv_format1 :=
316: formated_data_string (p_input_string => 'GRE'
317: ,p_bold => 'Y'
318: ,p_output_file_type => p_output_file_type) ||

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

421:
422:
423: BEGIN
424:
425: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
426: lv_format1 :=
427: formated_data_string (p_input_string => p_tax_unit_name
428: ,p_output_file_type => p_output_file_type)||
429: formated_data_string (p_input_string => p_organization_name

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

462: ,p_output_file_type => p_output_file_type) ||
463: formated_data_string (p_input_string => p_weeks_worked
464: ,p_output_file_type => p_output_file_type) ;
465:
466: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
467:
468:
469: -- p_static_data1 := lv_format1;
470: -- p_static_data2 := lv_format2;

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

467:
468:
469: -- p_static_data1 := lv_format1;
470: -- p_static_data2 := lv_format2;
471: hr_utility.trace('Static Data1 = ' || lv_format1);
472: hr_utility.trace('Static Data2 = ' || lv_format2);
473: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
474:
475: return (lv_format1);

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

468:
469: -- p_static_data1 := lv_format1;
470: -- p_static_data2 := lv_format2;
471: hr_utility.trace('Static Data1 = ' || lv_format1);
472: hr_utility.trace('Static Data2 = ' || lv_format2);
473: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
474:
475: return (lv_format1);
476: END;

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

469: -- p_static_data1 := lv_format1;
470: -- p_static_data2 := lv_format2;
471: hr_utility.trace('Static Data1 = ' || lv_format1);
472: hr_utility.trace('Static Data2 = ' || lv_format2);
473: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
474:
475: return (lv_format1);
476: END;
477:

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

511:
512:
513: BEGIN
514:
515: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
516: lv_format1 :=
517: formated_data_string (p_input_string => p_tax_unit_name
518: ,p_output_file_type => p_output_file_type)||
519: formated_data_string (p_input_string => p_organization_name

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

560: ,p_output_file_type => p_output_file_type) ||
561: formated_data_string (p_input_string => p_hours_worked
562: ,p_output_file_type => p_output_file_type) ;
563:
564: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
565:
566:
567: hr_utility.trace('Static Data1 = ' || lv_format1);
568: hr_utility.trace('Static Data2 = ' || lv_format2);

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

563:
564: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
565:
566:
567: hr_utility.trace('Static Data1 = ' || lv_format1);
568: hr_utility.trace('Static Data2 = ' || lv_format2);
569: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
570:
571: return (lv_format1);

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

564: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
565:
566:
567: hr_utility.trace('Static Data1 = ' || lv_format1);
568: hr_utility.trace('Static Data2 = ' || lv_format2);
569: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
570:
571: return (lv_format1);
572: END;

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

565:
566:
567: hr_utility.trace('Static Data1 = ' || lv_format1);
568: hr_utility.trace('Static Data2 = ' || lv_format2);
569: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
570:
571: return (lv_format1);
572: END;
573:

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

609:
610:
611: BEGIN
612:
613: hr_utility.set_location(gv_package_name || '.formated_static_data_NM', 10);
614: lv_format1 :=
615: formated_data_string (p_input_string => p_tax_unit_name
616: ,p_output_file_type => p_output_file_type)||
617: formated_data_string (p_input_string => p_organization_name

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

666: ,p_output_file_type => p_output_file_type)||
667: formated_data_string (p_input_string => p_workers_comp_withheld
668: ,p_output_file_type => p_output_file_type) ;
669:
670: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
671:
672: hr_utility.trace('Static Data1 = ' || lv_format1);
673: hr_utility.trace('Static Data2 = ' || lv_format2);
674: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

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

668: ,p_output_file_type => p_output_file_type) ;
669:
670: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
671:
672: hr_utility.trace('Static Data1 = ' || lv_format1);
673: hr_utility.trace('Static Data2 = ' || lv_format2);
674: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
675:
676: return (lv_format1);

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

669:
670: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
671:
672: hr_utility.trace('Static Data1 = ' || lv_format1);
673: hr_utility.trace('Static Data2 = ' || lv_format2);
674: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
675:
676: return (lv_format1);
677: END;

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

670: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
671:
672: hr_utility.trace('Static Data1 = ' || lv_format1);
673: hr_utility.trace('Static Data2 = ' || lv_format2);
674: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
675:
676: return (lv_format1);
677: END;
678:

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

712:
713:
714: BEGIN
715:
716: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
717: lv_format1 :=
718: formated_data_string (p_input_string => p_tax_unit_name
719: ,p_output_file_type => p_output_file_type)||
720: formated_data_string (p_input_string => p_organization_name

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

764: formated_data_string (p_input_string => p_pre_tax_dedns_pgy
765: ,p_output_file_type => p_output_file_type);
766:
767:
768: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
769:
770:
771: hr_utility.trace('Static Data1 = ' || lv_format1);
772: hr_utility.trace('Static Data2 = ' || lv_format2);

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

767:
768: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
769:
770:
771: hr_utility.trace('Static Data1 = ' || lv_format1);
772: hr_utility.trace('Static Data2 = ' || lv_format2);
773: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
774:
775: return (lv_format1);

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

768: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
769:
770:
771: hr_utility.trace('Static Data1 = ' || lv_format1);
772: hr_utility.trace('Static Data2 = ' || lv_format2);
773: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
774:
775: return (lv_format1);
776: END;

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

769:
770:
771: hr_utility.trace('Static Data1 = ' || lv_format1);
772: hr_utility.trace('Static Data2 = ' || lv_format2);
773: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
774:
775: return (lv_format1);
776: END;
777:

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

974: lv_add_days DATE;
975:
976: BEGIN
977:
978: --hr_utility.trace_on (null, 'SQWLNEG');
979: hr_utility.trace ('Entered Main package');
980: hr_utility.trace ('Payroll Action Id = '||to_char(p_payroll_action_id));
981: hr_utility.trace ('Qtrname = '||p_qtrname);
982:

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

975:
976: BEGIN
977:
978: --hr_utility.trace_on (null, 'SQWLNEG');
979: hr_utility.trace ('Entered Main package');
980: hr_utility.trace ('Payroll Action Id = '||to_char(p_payroll_action_id));
981: hr_utility.trace ('Qtrname = '||p_qtrname);
982:
983:

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

976: BEGIN
977:
978: --hr_utility.trace_on (null, 'SQWLNEG');
979: hr_utility.trace ('Entered Main package');
980: hr_utility.trace ('Payroll Action Id = '||to_char(p_payroll_action_id));
981: hr_utility.trace ('Qtrname = '||p_qtrname);
982:
983:
984: open c_assignments(p_payroll_action_id);

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

977:
978: --hr_utility.trace_on (null, 'SQWLNEG');
979: hr_utility.trace ('Entered Main package');
980: hr_utility.trace ('Payroll Action Id = '||to_char(p_payroll_action_id));
981: hr_utility.trace ('Qtrname = '||p_qtrname);
982:
983:
984: open c_assignments(p_payroll_action_id);
985: hr_utility.trace ('Opened c_assignment cursor');

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

981: hr_utility.trace ('Qtrname = '||p_qtrname);
982:
983:
984: open c_assignments(p_payroll_action_id);
985: hr_utility.trace ('Opened c_assignment cursor');
986: loop
987:
988: /* Initialixe variables */
989:

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

1056: lv_report_category;
1057:
1058: if c_assignments%NOTFOUND then
1059: if c_assignments%ROWCOUNT = 0 then
1060: hr_utility.trace('Into Row Count = 0 ');
1061: lv_state_abbrev := null;
1062:
1063: open c_state(p_payroll_action_id);
1064: fetch c_state into lv_state_abbrev,lv_bgrp_id;

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

1093: exit;
1094: end if;
1095: lv_full_name := replace(lv_full_name_wc,',');
1096:
1097: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));
1098: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1099: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1100: hr_utility.trace('lv_full_name ='||lv_full_name);
1101: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);

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

1094: end if;
1095: lv_full_name := replace(lv_full_name_wc,',');
1096:
1097: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));
1098: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1099: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1100: hr_utility.trace('lv_full_name ='||lv_full_name);
1101: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1102: hr_utility.trace('lv_state_code ='||lv_state_code);

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

1095: lv_full_name := replace(lv_full_name_wc,',');
1096:
1097: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));
1098: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1099: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1100: hr_utility.trace('lv_full_name ='||lv_full_name);
1101: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1102: hr_utility.trace('lv_state_code ='||lv_state_code);
1103: hr_utility.trace('lv_report_category ='||lv_report_category);

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

1096:
1097: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));
1098: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1099: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1100: hr_utility.trace('lv_full_name ='||lv_full_name);
1101: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1102: hr_utility.trace('lv_state_code ='||lv_state_code);
1103: hr_utility.trace('lv_report_category ='||lv_report_category);
1104:

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

1097: hr_utility.trace('ln_asg_id ='||to_char(ln_asg_id));
1098: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1099: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1100: hr_utility.trace('lv_full_name ='||lv_full_name);
1101: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1102: hr_utility.trace('lv_state_code ='||lv_state_code);
1103: hr_utility.trace('lv_report_category ='||lv_report_category);
1104:
1105: open c_archive_dtls(ln_asg_act_id,

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

1098: hr_utility.trace('ln_asg_act_id ='||to_char(ln_asg_act_id));
1099: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1100: hr_utility.trace('lv_full_name ='||lv_full_name);
1101: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1102: hr_utility.trace('lv_state_code ='||lv_state_code);
1103: hr_utility.trace('lv_report_category ='||lv_report_category);
1104:
1105: open c_archive_dtls(ln_asg_act_id,
1106: ln_tax_unit_id,

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

1099: hr_utility.trace('ln_tax_unit_id ='||to_char(ln_tax_unit_id));
1100: hr_utility.trace('lv_full_name ='||lv_full_name);
1101: hr_utility.trace('lv_full_name_wc ='||lv_full_name_wc);
1102: hr_utility.trace('lv_state_code ='||lv_state_code);
1103: hr_utility.trace('lv_report_category ='||lv_report_category);
1104:
1105: open c_archive_dtls(ln_asg_act_id,
1106: ln_tax_unit_id,
1107: lv_state_code);

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

1104:
1105: open c_archive_dtls(ln_asg_act_id,
1106: ln_tax_unit_id,
1107: lv_state_code);
1108: hr_utility.trace('Opened c_archive_dtls');
1109: loop
1110: fetch c_archive_dtls into lv_user_name
1111: ,lv_value;
1112:

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

1178:
1179:
1180: open c_archive_dtls_fed(ln_asg_act_id,
1181: ln_tax_unit_id);
1182: hr_utility.trace('Opened c_archive_dtls_fed');
1183: loop
1184: fetch c_archive_dtls_fed into lv_user_name
1185: ,lv_value;
1186:

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

1217:
1218: FOR I in c_get_asg_details(ln_asg_act_id, ln_asg_id)
1219: LOOP
1220: IF I.user_name = 'A_SCL_ASG_US_WORK_SCHEDULE' THEN
1221: hr_utility.trace('Getting A_SCL_ASG_US_WORK_SCHEDULE ');
1222: lv_work_schedule := I.value;
1223: ELSIF I.user_name = 'A_ASG_HOURS' THEN
1224: lv_asg_hours := I.value;
1225: ELSIF I.user_name = 'A_ASG_FREQ' THEN

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

1226: lv_asg_freq := I.value;
1227: END IF;
1228: END LOOP;
1229:
1230: hr_utility.trace('A_SCL_ASG_US_WORK_SCHEDULE ' ||lv_work_schedule);
1231: hr_utility.trace('A_ASG_HOURS ' ||lv_asg_hours);
1232: hr_utility.trace('A_ASG_FREQ ' ||lv_asg_freq);
1233:
1234: /* Need business group id for calculating weeks worked */

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

1227: END IF;
1228: END LOOP;
1229:
1230: hr_utility.trace('A_SCL_ASG_US_WORK_SCHEDULE ' ||lv_work_schedule);
1231: hr_utility.trace('A_ASG_HOURS ' ||lv_asg_hours);
1232: hr_utility.trace('A_ASG_FREQ ' ||lv_asg_freq);
1233:
1234: /* Need business group id for calculating weeks worked */
1235:

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

1228: END LOOP;
1229:
1230: hr_utility.trace('A_SCL_ASG_US_WORK_SCHEDULE ' ||lv_work_schedule);
1231: hr_utility.trace('A_ASG_HOURS ' ||lv_asg_hours);
1232: hr_utility.trace('A_ASG_FREQ ' ||lv_asg_freq);
1233:
1234: /* Need business group id for calculating weeks worked */
1235:
1236: OPEN c_state(p_payroll_action_id);

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

1240: END IF;
1241: CLOSE c_state;
1242:
1243: /* calculate the derived balances here */
1244: hr_utility.trace('Going to calculate derived balances');
1245:
1246: lv_sui_qtr_wages := lv_sui_er_subjwh - lv_sui_er_pre_tax_redns;
1247: lv_sui_excess := lv_sui_qtr_wages - lv_sui_er_taxable;
1248: lv_sit_qtr_wages := lv_sit_subjwh + lv_sit_subjnwh - lv_sit_pre_tax_redns;

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

1248: lv_sit_qtr_wages := lv_sit_subjwh + lv_sit_subjnwh - lv_sit_pre_tax_redns;
1249: lv_sdi_qtr_wages := lv_sdi_subjwh - lv_sdi_pre_tax_redns;
1250: lv_sdi_excess := lv_sdi_subjwh - lv_sdi_pre_tax_redns - lv_sdi_taxable;
1251:
1252: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);
1253: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1254: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1255: hr_utility.trace('Qtrname ='||p_qtrname);
1256: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);

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

1249: lv_sdi_qtr_wages := lv_sdi_subjwh - lv_sdi_pre_tax_redns;
1250: lv_sdi_excess := lv_sdi_subjwh - lv_sdi_pre_tax_redns - lv_sdi_taxable;
1251:
1252: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);
1253: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1254: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1255: hr_utility.trace('Qtrname ='||p_qtrname);
1256: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1257: hr_utility.trace('lv_full_name ='||lv_full_name);

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

1250: lv_sdi_excess := lv_sdi_subjwh - lv_sdi_pre_tax_redns - lv_sdi_taxable;
1251:
1252: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);
1253: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1254: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1255: hr_utility.trace('Qtrname ='||p_qtrname);
1256: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1257: hr_utility.trace('lv_full_name ='||lv_full_name);
1258: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);

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

1251:
1252: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);
1253: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1254: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1255: hr_utility.trace('Qtrname ='||p_qtrname);
1256: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1257: hr_utility.trace('lv_full_name ='||lv_full_name);
1258: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1259: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);

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

1252: hr_utility.trace('lv_tax_unit_name ='||lv_tax_unit_name);
1253: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1254: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1255: hr_utility.trace('Qtrname ='||p_qtrname);
1256: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1257: hr_utility.trace('lv_full_name ='||lv_full_name);
1258: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1259: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1260: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);

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

1253: hr_utility.trace('lv_organization_name ='||lv_organization_name);
1254: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1255: hr_utility.trace('Qtrname ='||p_qtrname);
1256: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1257: hr_utility.trace('lv_full_name ='||lv_full_name);
1258: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1259: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1260: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1261: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);

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

1254: hr_utility.trace('lv_state_abbrev ='||lv_state_abbrev);
1255: hr_utility.trace('Qtrname ='||p_qtrname);
1256: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1257: hr_utility.trace('lv_full_name ='||lv_full_name);
1258: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1259: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1260: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1261: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1262: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);

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

1255: hr_utility.trace('Qtrname ='||p_qtrname);
1256: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1257: hr_utility.trace('lv_full_name ='||lv_full_name);
1258: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1259: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1260: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1261: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1262: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1263: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);

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

1256: hr_utility.trace('lv_assignment_number ='||lv_assignment_number);
1257: hr_utility.trace('lv_full_name ='||lv_full_name);
1258: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1259: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1260: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1261: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1262: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1263: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1264: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);

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

1257: hr_utility.trace('lv_full_name ='||lv_full_name);
1258: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1259: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1260: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1261: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1262: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1263: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1264: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1265: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);

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

1258: hr_utility.trace('lv_gross_earnings ='||lv_gross_earnings);
1259: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1260: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1261: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1262: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1263: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1264: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1265: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1266: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);

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

1259: hr_utility.trace('lv_sui_er_gross ='||lv_sui_er_gross);
1260: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1261: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1262: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1263: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1264: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1265: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1266: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1267: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);

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

1260: hr_utility.trace('lv_sui_er_125 ='||lv_sui_er_125);
1261: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1262: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1263: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1264: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1265: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1266: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1267: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1268: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);

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

1261: hr_utility.trace('lv_sui_er_401 ='||lv_sui_er_401);
1262: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1263: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1264: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1265: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1266: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1267: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1268: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1269: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);

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

1262: hr_utility.trace('lv_sui_er_depcare ='||lv_sui_er_depcare);
1263: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1264: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1265: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1266: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1267: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1268: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1269: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1270: hr_utility.trace('lv_sit_125 ='||lv_sit_125);

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

1263: hr_utility.trace('lv_sui_er_subjwh ='||lv_sui_er_subjwh);
1264: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1265: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1266: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1267: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1268: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1269: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1270: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1271: hr_utility.trace('lv_sit_401 ='||lv_sit_401);

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

1264: hr_utility.trace('lv_sui_er_taxable ='||lv_sui_er_taxable);
1265: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1266: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1267: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1268: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1269: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1270: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1271: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1272: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);

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

1265: hr_utility.trace('lv_sui_qtr_wages ='||lv_sui_qtr_wages);
1266: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1267: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1268: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1269: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1270: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1271: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1272: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1273: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);

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

1266: hr_utility.trace('lv_sui_excess ='||lv_sui_excess);
1267: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1268: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1269: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1270: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1271: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1272: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1273: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1274: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);

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

1267: hr_utility.trace('lv_sit_gross ='||lv_sit_gross);
1268: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1269: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1270: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1271: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1272: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1273: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1274: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1275: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);

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

1268: hr_utility.trace('lv_sit_subjwh ='||lv_sit_subjwh);
1269: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1270: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1271: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1272: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1273: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1274: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1275: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1276: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);

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

1269: hr_utility.trace('lv_sit_subjnwh ='||lv_sit_subjnwh);
1270: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1271: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1272: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1273: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1274: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1275: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1276: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1277: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);

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

1270: hr_utility.trace('lv_sit_125 ='||lv_sit_125);
1271: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1272: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1273: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1274: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1275: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1276: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1277: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1278: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);

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

1271: hr_utility.trace('lv_sit_401 ='||lv_sit_401);
1272: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1273: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1274: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1275: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1276: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1277: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1278: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1279: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);

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

1272: hr_utility.trace('lv_sit_depcare ='||lv_sit_depcare);
1273: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1274: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1275: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1276: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1277: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1278: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1279: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1280: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);

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

1273: hr_utility.trace('lv_sit_withheld ='||lv_sit_withheld);
1274: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1275: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1276: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1277: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1278: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1279: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1280: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1281: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);

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

1274: hr_utility.trace('lv_sit_qtr_wages ='||lv_sit_qtr_wages);
1275: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1276: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1277: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1278: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1279: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1280: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1281: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1282: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);

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

1275: hr_utility.trace('lv_hours_worked ='||lv_hours_worked);
1276: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1277: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1278: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1279: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1280: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1281: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1282: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1283: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);

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

1276: hr_utility.trace('lv_annual_gross_wages ='||lv_annual_gross_wages);
1277: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1278: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1279: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1280: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1281: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1282: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1283: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1284: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);

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

1277: hr_utility.trace('lv_regular_earngs_pgy='||lv_regular_earnings_pgy);
1278: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1279: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1280: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1281: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1282: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1283: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1284: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1285: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );

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

1278: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1279: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1280: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1281: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1282: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1283: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1284: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1285: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1286: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);

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

1279: hr_utility.trace('lv_supp_fit_stt_pgy ='||lv_supp_fit_stt_pgy);
1280: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1281: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1282: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1283: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1284: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1285: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1286: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1287: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);

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

1280: hr_utility.trace('lv_supp_nwfit_stt_pgy ='||lv_supp_nwfit_stt_pgy);
1281: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1282: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1283: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1284: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1285: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1286: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1287: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1288: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);

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

1281: hr_utility.trace('lv_def_comp_401_pry ='||lv_def_comp_401_pry);
1282: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1283: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1284: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1285: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1286: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1287: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1288: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1289: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);

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

1282: hr_utility.trace('lv_sec_125_pgy ='||lv_sec_125_pgy);
1283: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1284: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1285: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1286: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1287: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1288: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1289: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);
1290: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);

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

1283: hr_utility.trace('lv_sit_withheld_pjgy ='||lv_sit_withheld_pjgy);
1284: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1285: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1286: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1287: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1288: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1289: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);
1290: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);
1291:

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

1284: hr_utility.trace('lv_dep_care_pgy ='||lv_dep_care_pgy);
1285: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1286: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1287: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1288: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1289: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);
1290: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);
1291:
1292:

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

1285: hr_utility.trace('lv_hours_worked_calculation_method='|| lv_hours_worked_calc_method );
1286: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1287: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1288: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1289: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);
1290: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);
1291:
1292:
1293: /* regular hours */

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

1286: hr_utility.trace('lv_sui_sick_hours_by_state_per_jd_gre_qtd ='|| lv_sui_sick_hours);
1287: hr_utility.trace('lv_sui_vacation_hours_by_state_per_jd_gre_qtd =' || lv_sui_vacation_hours);
1288: hr_utility.trace('lv_sui_regular_hours_by_state_per_jd_gre_qtd =' || lv_sui_regular_hours);
1289: hr_utility.trace('lv_sui_overtime_hours_by_state_per_jd_gre_qtd =' || lv_sui_overtime_hours);
1290: hr_utility.trace('lv_work_schedule ='||lv_work_schedule);
1291:
1292:
1293: /* regular hours */
1294:

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

1302: /* Bug:3044939 */
1303: IF c_get_hour_calc_method%NOTFOUND THEN
1304:
1305: lv_Hours_Worked_Calc_Method := 'W'; --Default Value
1306: hr_utility.trace('NO Data found. So setting c_get_hour_calc_method to default value');
1307:
1308: END IF;
1309:
1310: CLOSE c_get_hour_calc_method;

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

1308: END IF;
1309:
1310: CLOSE c_get_hour_calc_method;
1311:
1312: hr_utility.trace('lv_hours_worked_calc_method '||lv_hours_worked_calc_method);
1313:
1314: /* We have the Calculation Method. Lets calculate the hours and weeks worked */
1315:
1316: IF nvl(lv_Hours_Worked_Calc_Method,'W') = 'W' then

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

1327: + nvl(to_number(lv_sui_overtime_hours),0);
1328:
1329: END IF;
1330:
1331: hr_utility.trace('lv_hours_worked =' || lv_hours_worked);
1332: hr_utility.trace('lv_work_schedule =' || lv_work_schedule);
1333: hr_utility.trace('lv_asg_freq =' || lv_asg_freq);
1334: hr_utility.trace('lv_asg_hours =' || lv_asg_hours);
1335:

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

1328:
1329: END IF;
1330:
1331: hr_utility.trace('lv_hours_worked =' || lv_hours_worked);
1332: hr_utility.trace('lv_work_schedule =' || lv_work_schedule);
1333: hr_utility.trace('lv_asg_freq =' || lv_asg_freq);
1334: hr_utility.trace('lv_asg_hours =' || lv_asg_hours);
1335:
1336:

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

1329: END IF;
1330:
1331: hr_utility.trace('lv_hours_worked =' || lv_hours_worked);
1332: hr_utility.trace('lv_work_schedule =' || lv_work_schedule);
1333: hr_utility.trace('lv_asg_freq =' || lv_asg_freq);
1334: hr_utility.trace('lv_asg_hours =' || lv_asg_hours);
1335:
1336:
1337: IF (lv_work_schedule is null ) then

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

1330:
1331: hr_utility.trace('lv_hours_worked =' || lv_hours_worked);
1332: hr_utility.trace('lv_work_schedule =' || lv_work_schedule);
1333: hr_utility.trace('lv_asg_freq =' || lv_asg_freq);
1334: hr_utility.trace('lv_asg_hours =' || lv_asg_hours);
1335:
1336:
1337: IF (lv_work_schedule is null ) then
1338: lv_add_days := fffunc.add_days(sysdate,6);

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

1339: lv_hours_per_week := hr_us_ff_udfs.standard_hours_worked( lv_asg_hours,
1340: sysdate,
1341: lv_add_days,
1342: lv_asg_freq);
1343: hr_utility.trace('lv_add_days = '||lv_add_days);
1344: hr_utility.trace('lv_hours_per_week = '||to_char(lv_hours_per_week));
1345: ELSE
1346: lv_hours_per_week := hr_us_ff_udfs.work_schedule_total_hours(lv_bgrp_id,
1347: lv_work_schedule,

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

1340: sysdate,
1341: lv_add_days,
1342: lv_asg_freq);
1343: hr_utility.trace('lv_add_days = '||lv_add_days);
1344: hr_utility.trace('lv_hours_per_week = '||to_char(lv_hours_per_week));
1345: ELSE
1346: lv_hours_per_week := hr_us_ff_udfs.work_schedule_total_hours(lv_bgrp_id,
1347: lv_work_schedule,
1348: null,

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

1346: lv_hours_per_week := hr_us_ff_udfs.work_schedule_total_hours(lv_bgrp_id,
1347: lv_work_schedule,
1348: null,
1349: null);
1350: hr_utility.trace('Work Schedule found = '||lv_work_schedule);
1351: hr_utility.trace('lv_hours_per_week = '||to_char(lv_hours_per_week));
1352: END IF;
1353:
1354: /* calculating the Weeks Worked */

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

1347: lv_work_schedule,
1348: null,
1349: null);
1350: hr_utility.trace('Work Schedule found = '||lv_work_schedule);
1351: hr_utility.trace('lv_hours_per_week = '||to_char(lv_hours_per_week));
1352: END IF;
1353:
1354: /* calculating the Weeks Worked */
1355: IF nvl(lv_hours_per_week,0) <> 0 THEN

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

1352: END IF;
1353:
1354: /* calculating the Weeks Worked */
1355: IF nvl(lv_hours_per_week,0) <> 0 THEN
1356: hr_utility.trace('lv_hours_per_week <> 0 ');
1357: lv_weeks_worked := round(lv_hours_worked/lv_hours_per_week);
1358: hr_utility.trace('lv_weeks_worked = '||to_char(lv_weeks_worked));
1359:
1360: IF lv_weeks_worked > 14 THEN

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

1354: /* calculating the Weeks Worked */
1355: IF nvl(lv_hours_per_week,0) <> 0 THEN
1356: hr_utility.trace('lv_hours_per_week <> 0 ');
1357: lv_weeks_worked := round(lv_hours_worked/lv_hours_per_week);
1358: hr_utility.trace('lv_weeks_worked = '||to_char(lv_weeks_worked));
1359:
1360: IF lv_weeks_worked > 14 THEN
1361: lv_weeks_worked := 14;
1362: END IF;

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

1396: (lv_state_abbrev in ('MN' ,'VT' ,'OR' ,'WA' ,'WY' ) and lv_hours_worked < 0) or
1397: (lv_state_abbrev in ('MA','DE','OH') and lv_weeks_worked < 0)
1398: ) THEN
1399:
1400: hr_utility.trace('Entered negative reporting loop');
1401:
1402: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1403:
1404: if lv_neg_asg_count = 1 then

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

1487: lv_sit_gross < 0 or
1488: lv_sit_withheld < 0 or
1489: lv_weeks_worked < 0) then
1490:
1491: hr_utility.trace('Entered negative reporting loop');
1492:
1493: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1494: if lv_neg_asg_count = 1 then
1495: fnd_file.put_line(fnd_file.output,formated_Static_header('CSV'));

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

1572: lv_sui_excess < 0 or
1573: lv_sit_qtr_wages < 0 or
1574: lv_sit_withheld < 0 ) then
1575:
1576: hr_utility.trace('Entered negative reporting loop');
1577:
1578: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1579:
1580: if lv_neg_asg_count = 1 then

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

1662: lv_workers_comp2_withheld < 0 or
1663: lv_workers_comp_withheld < 0
1664: ) then
1665:
1666: hr_utility.trace('Entered negative reporting loop');
1667:
1668: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1669:
1670: if lv_neg_asg_count = 1 then

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

1765: lv_sui_excess < 0 or
1766: lv_sit_qtr_wages < 0 or
1767: lv_sit_withheld < 0 ) then
1768:
1769: hr_utility.trace('Entered negative reporting loop');
1770:
1771: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1772:
1773: if lv_neg_asg_count = 1 then

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

1857: lv_sit_qtr_wages < 0 or
1858: lv_sit_withheld < 0 or
1859: lv_weeks_worked < 0) then
1860:
1861: hr_utility.trace('Entered negative reporting loop');
1862:
1863: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1864:
1865: if lv_neg_asg_count = 1 then

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

1948: lv_sui_er_taxable < 0 or
1949: lv_sit_qtr_wages < 0 or
1950: lv_sit_gross < 0 ) then
1951:
1952: hr_utility.trace('Entered negative reporting loop');
1953:
1954: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
1955:
1956: if lv_neg_asg_count = 1 then

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

2042: lv_sit_qtr_wages < 0 or
2043: lv_sit_withheld < 0 or
2044: lv_hours_worked < 0 ) then
2045:
2046: hr_utility.trace('Entered negative reporting loop');
2047:
2048: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
2049:
2050: if lv_neg_asg_count = 1 then

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

2050: if lv_neg_asg_count = 1 then
2051:
2052: fnd_file.put_line(fnd_file.output,formated_Static_header('CSV'));
2053:
2054: hr_utility.trace('Inserted header in pay_us_rpt_totals');
2055:
2056: end if;
2057:
2058:

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

2090: if lv_neg_asg_count = 1 then
2091:
2092: fnd_file.put_line(fnd_file.output,formated_Static_header('CSV'));
2093:
2094: hr_utility.trace('Inserted header in pay_us_rpt_totals');
2095:
2096: end if;
2097:
2098:

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

2147: lv_sdi_qtr_wages < 0 or
2148: lv_sdi_taxable < 0 or
2149: lv_sdi_excess < 0 ) then
2150:
2151: hr_utility.trace('Entered negative reporting loop');
2152:
2153: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
2154:
2155: if lv_neg_asg_count = 1 then

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

2250: lv_char_value := to_number(lv_sit_withheld_pjgy);
2251: lv_char_value := to_number(lv_annual_gross_wages);
2252:
2253:
2254: hr_utility.trace('lv_annual_gross_wages as cal = '||lv_annual_gross_wages);
2255:
2256: if (lv_sui_qtr_wages < 0 or
2257: lv_sui_excess < 0 or
2258: lv_sui_er_taxable < 0 or

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

2260: lv_sit_withheld < 0 or
2261: lv_sit_withheld_pjgy < 0 or
2262: lv_annual_gross_wages < 0 ) then
2263:
2264: hr_utility.trace('Entered negative reporting loop');
2265:
2266:
2267: lv_neg_asg_count :=lv_neg_asg_count + 1 ;
2268: