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

Line 243: hr_utility.set_location('Entering:'||l_proc, 10);

239: --
240:
241: BEGIN
242: --
243: hr_utility.set_location('Entering:'||l_proc, 10);
244: --
245:
246: IF p_org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
247: AND p_org_information1 = 'CA' THEN

Line 260: hr_utility.set_location(l_proc, 20);

256:
257:
258: END LOOP;
259:
260: hr_utility.set_location(l_proc, 20);
261:
262:
263: --
264: -- raise error if the count > 1 or count = 0

Line 269: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');

265: --
266:
267: IF l_count <> 1 THEN
268:
269: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
270: hr_utility.set_message_token('FORMAT',' with at least 1 and only 1 marked as default');
271:
272: hr_utility.raise_error;
273:

Line 270: hr_utility.set_message_token('FORMAT',' with at least 1 and only 1 marked as default');

266:
267: IF l_count <> 1 THEN
268:
269: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
270: hr_utility.set_message_token('FORMAT',' with at least 1 and only 1 marked as default');
271:
272: hr_utility.raise_error;
273:
274: END IF;

Line 272: hr_utility.raise_error;

268:
269: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
270: hr_utility.set_message_token('FORMAT',' with at least 1 and only 1 marked as default');
271:
272: hr_utility.raise_error;
273:
274: END IF;
275:
276:

Line 286: hr_utility.set_location(l_proc, 20);

282:
283:
284: END LOOP;
285:
286: hr_utility.set_location(l_proc, 20);
287:
288:
289: --
290: -- raise error if the count > 1 or count = 0

Line 295: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');

291: --
292:
293: IF l_count > 0 THEN
294:
295: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
296: hr_utility.set_message_token('FORMAT',' with unique tax type and state code');
297:
298: hr_utility.raise_error;
299:

Line 296: hr_utility.set_message_token('FORMAT',' with unique tax type and state code');

292:
293: IF l_count > 0 THEN
294:
295: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
296: hr_utility.set_message_token('FORMAT',' with unique tax type and state code');
297:
298: hr_utility.raise_error;
299:
300: END IF;

Line 298: hr_utility.raise_error;

294:
295: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
296: hr_utility.set_message_token('FORMAT',' with unique tax type and state code');
297:
298: hr_utility.raise_error;
299:
300: END IF;
301:
302:

Line 306: hr_utility.set_location(' Leaving:'||l_proc, 50);

302:
303: END IF;
304:
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 50);
307: --
308: END chk_for_default_wp;
309: --
310:

Line 357: hr_utility.set_location('Entering:'||l_proc, 10);

353: --
354:
355: BEGIN
356: --
357: hr_utility.set_location('Entering:'||l_proc, 10);
358: --
359:
360: IF p_tax_unit_id IS NOT NULL THEN
361: l_tax_unit_id := p_tax_unit_id;

Line 380: hr_utility.set_location(' Leaving:'||l_proc, 50);

376: l_yes_no := FALSE;
377: END IF;
378: END LOOP;
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 50);
381: --
382:
383: RETURN l_yes_no;
384:

Line 419: hr_utility.set_location('Entering:'||l_proc, 10);

415: --
416:
417: BEGIN
418: --
419: hr_utility.set_location('Entering:'||l_proc, 10);
420: --
421:
422: IF p_ss_wh = 0 and p_medicare_wh > 0 THEN
423: l_code := 'Q';

Line 429: hr_utility.set_location(' Leaving:'||l_proc, 50);

425: l_code := 'R';
426: END IF;
427:
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 50);
430: --
431:
432: RETURN l_code;
433:

Line 482: hr_utility.set_location('Entering:'||l_proc, 10);

478: AND arch.context1 = p_assignment_action_id;
479:
480: BEGIN
481: --
482: hr_utility.set_location('Entering:'||l_proc, 10);
483: --
484:
485:
486: -- Get the user entity id for A_ASG_GRE_EMPLOYMENT_TYPE_CODE

Line 508: hr_utility.set_location(' Leaving:'||l_proc, 50);

504:
505: END LOOP;
506:
507: --
508: hr_utility.set_location(' Leaving:'||l_proc, 50);
509: --
510:
511: RETURN l_code;
512:

Line 670: hr_utility.trace('Entering get_out_of_state_code');

666: fl_jurisdiction_code varchar2(11);
667:
668: BEGIN
669:
670: hr_utility.trace('Entering get_out_of_state_code');
671: hr_utility.trace('Parameters Passed are');
672: hr_utility.trace('p_assignment_id'||p_assignment_id);
673: hr_utility.trace('p_tax_unit_id'||p_tax_unit_id);
674: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);

Line 671: hr_utility.trace('Parameters Passed are');

667:
668: BEGIN
669:
670: hr_utility.trace('Entering get_out_of_state_code');
671: hr_utility.trace('Parameters Passed are');
672: hr_utility.trace('p_assignment_id'||p_assignment_id);
673: hr_utility.trace('p_tax_unit_id'||p_tax_unit_id);
674: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);
675: hr_utility.trace('p_reporting_date'||to_char(p_reporting_date));

Line 672: hr_utility.trace('p_assignment_id'||p_assignment_id);

668: BEGIN
669:
670: hr_utility.trace('Entering get_out_of_state_code');
671: hr_utility.trace('Parameters Passed are');
672: hr_utility.trace('p_assignment_id'||p_assignment_id);
673: hr_utility.trace('p_tax_unit_id'||p_tax_unit_id);
674: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);
675: hr_utility.trace('p_reporting_date'||to_char(p_reporting_date));
676:

Line 673: hr_utility.trace('p_tax_unit_id'||p_tax_unit_id);

669:
670: hr_utility.trace('Entering get_out_of_state_code');
671: hr_utility.trace('Parameters Passed are');
672: hr_utility.trace('p_assignment_id'||p_assignment_id);
673: hr_utility.trace('p_tax_unit_id'||p_tax_unit_id);
674: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);
675: hr_utility.trace('p_reporting_date'||to_char(p_reporting_date));
676:
677: l_year_start_date := trunc(p_reporting_date,'YEAR');

Line 674: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);

670: hr_utility.trace('Entering get_out_of_state_code');
671: hr_utility.trace('Parameters Passed are');
672: hr_utility.trace('p_assignment_id'||p_assignment_id);
673: hr_utility.trace('p_tax_unit_id'||p_tax_unit_id);
674: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);
675: hr_utility.trace('p_reporting_date'||to_char(p_reporting_date));
676:
677: l_year_start_date := trunc(p_reporting_date,'YEAR');
678: l_quarter_start_date := add_months(last_day(p_reporting_date),-3)+1;

Line 675: hr_utility.trace('p_reporting_date'||to_char(p_reporting_date));

671: hr_utility.trace('Parameters Passed are');
672: hr_utility.trace('p_assignment_id'||p_assignment_id);
673: hr_utility.trace('p_tax_unit_id'||p_tax_unit_id);
674: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);
675: hr_utility.trace('p_reporting_date'||to_char(p_reporting_date));
676:
677: l_year_start_date := trunc(p_reporting_date,'YEAR');
678: l_quarter_start_date := add_months(last_day(p_reporting_date),-3)+1;
679: l_quarter_end_date := last_day(p_reporting_date);

Line 710: hr_utility.trace('Modified l_reporting_date'||to_char(l_reporting_date));

706: FETCH get_effective_date INTO l_reporting_date;
707:
708: CLOSE get_effective_date;
709:
710: hr_utility.trace('Modified l_reporting_date'||to_char(l_reporting_date));
711:
712: ELSE
713:
714: l_reporting_date := p_reporting_date;

Line 716: hr_utility.trace('Use original l_reporting_date'||to_char(l_reporting_date));

712: ELSE
713:
714: l_reporting_date := p_reporting_date;
715:
716: hr_utility.trace('Use original l_reporting_date'||to_char(l_reporting_date));
717:
718: END IF;
719:
720: /*End Bug#9561700*/

Line 729: hr_utility.trace('Not able to find Defined Balance for combination of SUI ER Taxable and Person within Government Reporting Entity Year to Date');

725: FETCH get_defined_balance_id INTO l_defined_balance_id;
726:
727: IF get_defined_balance_id%NOTFOUND THEN
728:
729: hr_utility.trace('Not able to find Defined Balance for combination of SUI ER Taxable and Person within Government Reporting Entity Year to Date');
730:
731: END IF;
732:
733: CLOSE get_defined_balance_id;

Line 741: hr_utility.trace('Total SUI Taxable till this Quarter'||l_total_state_taxable);

737: l_total_state_taxable := pay_balance_pkg.get_value( l_defined_balance_id,
738: p_assignment_id,
739: l_reporting_date);
740:
741: hr_utility.trace('Total SUI Taxable till this Quarter'||l_total_state_taxable);
742:
743:
744: OPEN get_defined_balance_id('Person in JD within GRE Year to Date');
745: FETCH get_defined_balance_id INTO l_defined_balance_id;

Line 749: hr_utility.trace('Not able to find Defined Balance for combination of SUI ER Taxable and Person in JD within GRE Year to Date');

745: FETCH get_defined_balance_id INTO l_defined_balance_id;
746:
747: IF get_defined_balance_id%NOTFOUND THEN
748:
749: hr_utility.trace('Not able to find Defined Balance for combination of SUI ER Taxable and Person in JD within GRE Year to Date');
750:
751: END IF;
752:
753: CLOSE get_defined_balance_id;

Line 764: hr_utility.trace('Total Out of State SUI Taxable till this Quarter'||l_total_out_of_state_taxable);

760: pay_balance_pkg.get_value( l_defined_balance_id,
761: p_assignment_id,
762: l_reporting_date);
763:
764: hr_utility.trace('Total Out of State SUI Taxable till this Quarter'||l_total_out_of_state_taxable);
765:
766: hr_utility.trace('p_out_of_state_taxable passed into function'||p_out_of_state_taxable);
767:
768: p_out_of_state_taxable := l_total_out_of_state_taxable;

Line 766: hr_utility.trace('p_out_of_state_taxable passed into function'||p_out_of_state_taxable);

762: l_reporting_date);
763:
764: hr_utility.trace('Total Out of State SUI Taxable till this Quarter'||l_total_out_of_state_taxable);
765:
766: hr_utility.trace('p_out_of_state_taxable passed into function'||p_out_of_state_taxable);
767:
768: p_out_of_state_taxable := l_total_out_of_state_taxable;
769:
770: hr_utility.trace('p_out_of_state_taxable passed out of function'||p_out_of_state_taxable);

Line 770: hr_utility.trace('p_out_of_state_taxable passed out of function'||p_out_of_state_taxable);

766: hr_utility.trace('p_out_of_state_taxable passed into function'||p_out_of_state_taxable);
767:
768: p_out_of_state_taxable := l_total_out_of_state_taxable;
769:
770: hr_utility.trace('p_out_of_state_taxable passed out of function'||p_out_of_state_taxable);
771:
772: l_count := 0;
773:
774: l_out_of_state_taxable := 0;

Line 784: hr_utility.trace('StateCode Fetched'||l_state_code);

780: WHILE get_emp_state_codes%FOUND
781:
782: LOOP
783:
784: hr_utility.trace('StateCode Fetched'||l_state_code);
785: hr_utility.trace('State Fetched'||l_state_abbrev);
786:
787: IF l_state_abbrev <> 'FL'
788: THEN

Line 785: hr_utility.trace('State Fetched'||l_state_abbrev);

781:
782: LOOP
783:
784: hr_utility.trace('StateCode Fetched'||l_state_code);
785: hr_utility.trace('State Fetched'||l_state_abbrev);
786:
787: IF l_state_abbrev <> 'FL'
788: THEN
789:

Line 800: hr_utility.trace('State Earnings YTD'||l_state_earnings);

796: l_reporting_date);
797:
798: l_out_of_state_taxable := l_out_of_state_taxable + l_state_earnings;
799:
800: hr_utility.trace('State Earnings YTD'||l_state_earnings);
801: hr_utility.trace('l_out_of_state_taxable'||l_out_of_state_taxable);
802:
803: IF l_state_earnings > 0 THEN
804:

Line 801: hr_utility.trace('l_out_of_state_taxable'||l_out_of_state_taxable);

797:
798: l_out_of_state_taxable := l_out_of_state_taxable + l_state_earnings;
799:
800: hr_utility.trace('State Earnings YTD'||l_state_earnings);
801: hr_utility.trace('l_out_of_state_taxable'||l_out_of_state_taxable);
802:
803: IF l_state_earnings > 0 THEN
804:
805: l_out_of_state_code := l_state_abbrev;

Line 808: hr_utility.trace('Found State with YTD Taxable more than 0 and not Florida, Increase out of states count by 1');

804:
805: l_out_of_state_code := l_state_abbrev;
806: l_count := l_count + 1;
807:
808: hr_utility.trace('Found State with YTD Taxable more than 0 and not Florida, Increase out of states count by 1');
809:
810: END IF;
811:
812:

Line 819: hr_utility.trace('Number of States other than Florida'||l_count);

815: FETCH get_emp_state_codes INTO l_state_code,l_state_abbrev;
816:
817: END LOOP;
818:
819: hr_utility.trace('Number of States other than Florida'||l_count);
820: hr_utility.trace('Out of State Taxable as of now'||l_out_of_state_taxable);
821: hr_utility.trace('Actual Out of State Taxable'||p_out_of_state_taxable);
822:
823: IF l_out_of_state_taxable <> p_out_of_state_taxable THEN

Line 820: hr_utility.trace('Out of State Taxable as of now'||l_out_of_state_taxable);

816:
817: END LOOP;
818:
819: hr_utility.trace('Number of States other than Florida'||l_count);
820: hr_utility.trace('Out of State Taxable as of now'||l_out_of_state_taxable);
821: hr_utility.trace('Actual Out of State Taxable'||p_out_of_state_taxable);
822:
823: IF l_out_of_state_taxable <> p_out_of_state_taxable THEN
824:

Line 821: hr_utility.trace('Actual Out of State Taxable'||p_out_of_state_taxable);

817: END LOOP;
818:
819: hr_utility.trace('Number of States other than Florida'||l_count);
820: hr_utility.trace('Out of State Taxable as of now'||l_out_of_state_taxable);
821: hr_utility.trace('Actual Out of State Taxable'||p_out_of_state_taxable);
822:
823: IF l_out_of_state_taxable <> p_out_of_state_taxable THEN
824:
825: hr_utility.trace('Missed some of the Out of States.Get them Now');

Line 825: hr_utility.trace('Missed some of the Out of States.Get them Now');

821: hr_utility.trace('Actual Out of State Taxable'||p_out_of_state_taxable);
822:
823: IF l_out_of_state_taxable <> p_out_of_state_taxable THEN
824:
825: hr_utility.trace('Missed some of the Out of States.Get them Now');
826:
827: OPEN get_missed_emp_state_codes(l_person_id,l_year_start_date,l_quarter_end_date);
828:
829: FETCH get_missed_emp_state_codes INTO l_state_code,l_state_abbrev;

Line 835: hr_utility.trace('StateCode Fetched'||l_state_code);

831: WHILE get_missed_emp_state_codes%FOUND
832:
833: LOOP
834:
835: hr_utility.trace('StateCode Fetched'||l_state_code);
836: hr_utility.trace('State Fetched'||l_state_abbrev);
837:
838: IF l_state_abbrev <> 'FL'
839: THEN

Line 836: hr_utility.trace('State Fetched'||l_state_abbrev);

832:
833: LOOP
834:
835: hr_utility.trace('StateCode Fetched'||l_state_code);
836: hr_utility.trace('State Fetched'||l_state_abbrev);
837:
838: IF l_state_abbrev <> 'FL'
839: THEN
840:

Line 851: hr_utility.trace('State Earnings YTD'||l_state_earnings);

847: l_reporting_date);
848:
849: l_out_of_state_taxable := l_out_of_state_taxable + l_state_earnings;
850:
851: hr_utility.trace('State Earnings YTD'||l_state_earnings);
852: hr_utility.trace('l_out_of_state_taxable'||l_out_of_state_taxable);
853:
854: IF l_state_earnings > 0 THEN
855:

Line 852: hr_utility.trace('l_out_of_state_taxable'||l_out_of_state_taxable);

848:
849: l_out_of_state_taxable := l_out_of_state_taxable + l_state_earnings;
850:
851: hr_utility.trace('State Earnings YTD'||l_state_earnings);
852: hr_utility.trace('l_out_of_state_taxable'||l_out_of_state_taxable);
853:
854: IF l_state_earnings > 0 THEN
855:
856: l_out_of_state_code := l_state_abbrev;

Line 859: hr_utility.trace('Found State with YTD Taxable more than 0 and not Florida, Increase out of states count by 1');

855:
856: l_out_of_state_code := l_state_abbrev;
857: l_count := l_count + 1;
858:
859: hr_utility.trace('Found State with YTD Taxable more than 0 and not Florida, Increase out of states count by 1');
860:
861: END IF;
862:
863:

Line 885: hr_utility.trace('Out of State Code returned'||l_out_of_state_code);

881: END IF;
882:
883: CLOSE get_emp_state_codes;
884:
885: hr_utility.trace('Out of State Code returned'||l_out_of_state_code);
886:
887: RETURN l_out_of_state_code;
888:
889: EXCEPTION

Line 892: hr_utility.trace('Error ORA-'||TO_CHAR(SQLCODE));

888:
889: EXCEPTION
890:
891: when others then
892: hr_utility.trace('Error ORA-'||TO_CHAR(SQLCODE));
893: hr_utility.raise_error;
894:
895: END get_out_of_state_code;
896:

Line 893: hr_utility.raise_error;

889: EXCEPTION
890:
891: when others then
892: hr_utility.trace('Error ORA-'||TO_CHAR(SQLCODE));
893: hr_utility.raise_error;
894:
895: END get_out_of_state_code;
896:
897: /* Bug 9356247 : Function to get reporting unit number which is defined at

Line 948: hr_utility.trace('Entering get_reporting_unit_no');

944: l_location_id NUMBER;
945:
946: BEGIN
947:
948: hr_utility.trace('Entering get_reporting_unit_no');
949: hr_utility.trace('Parameters Passed are');
950: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);
951: -- hr_utility.trace('p_location_id'||p_location_id);
952:

Line 949: hr_utility.trace('Parameters Passed are');

945:
946: BEGIN
947:
948: hr_utility.trace('Entering get_reporting_unit_no');
949: hr_utility.trace('Parameters Passed are');
950: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);
951: -- hr_utility.trace('p_location_id'||p_location_id);
952:
953: OPEN c_get_location_id;

Line 950: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);

946: BEGIN
947:
948: hr_utility.trace('Entering get_reporting_unit_no');
949: hr_utility.trace('Parameters Passed are');
950: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);
951: -- hr_utility.trace('p_location_id'||p_location_id);
952:
953: OPEN c_get_location_id;
954: FETCH c_get_location_id into l_location_id;

Line 951: -- hr_utility.trace('p_location_id'||p_location_id);

947:
948: hr_utility.trace('Entering get_reporting_unit_no');
949: hr_utility.trace('Parameters Passed are');
950: hr_utility.trace('p_assignment_action_id'||p_assignment_action_id);
951: -- hr_utility.trace('p_location_id'||p_location_id);
952:
953: OPEN c_get_location_id;
954: FETCH c_get_location_id into l_location_id;
955:

Line 964: hr_utility.trace('l_reporting_unit_no'||l_reporting_unit_no);

960: l_reporting_unit_no := '0001';
961: END IF;
962:
963: CLOSE c_get_reporting_unit_no;
964: hr_utility.trace('l_reporting_unit_no'||l_reporting_unit_no);
965:
966:
967: CLOSE c_get_location_id;
968: hr_utility.trace('1_location_id'||l_location_id);

Line 968: hr_utility.trace('1_location_id'||l_location_id);

964: hr_utility.trace('l_reporting_unit_no'||l_reporting_unit_no);
965:
966:
967: CLOSE c_get_location_id;
968: hr_utility.trace('1_location_id'||l_location_id);
969: RETURN l_reporting_unit_no;
970: EXCEPTION
971:
972: when others then

Line 973: hr_utility.trace('Error ORA-'||TO_CHAR(SQLCODE));

969: RETURN l_reporting_unit_no;
970: EXCEPTION
971:
972: when others then
973: hr_utility.trace('Error ORA-'||TO_CHAR(SQLCODE));
974: hr_utility.raise_error;
975:
976: END get_reporting_unit_no;
977:

Line 974: hr_utility.raise_error;

970: EXCEPTION
971:
972: when others then
973: hr_utility.trace('Error ORA-'||TO_CHAR(SQLCODE));
974: hr_utility.raise_error;
975:
976: END get_reporting_unit_no;
977:
978: /* Added for Bug#14368821 */

Line 1017: hr_utility.trace('Error while getting the ar out of state code' || to_char(sqlcode));

1013: RETURN l_ar_out_of_state_code;
1014:
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: hr_utility.trace('Error while getting the ar out of state code' || to_char(sqlcode));
1018: raise hr_utility.hr_error;
1019:
1020: END get_ar_out_of_state_code;
1021:

Line 1018: raise hr_utility.hr_error;

1014:
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: hr_utility.trace('Error while getting the ar out of state code' || to_char(sqlcode));
1018: raise hr_utility.hr_error;
1019:
1020: END get_ar_out_of_state_code;
1021:
1022: /* Bug 14008507 start */

Line 1036: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employer_count') ;

1032: p_state varchar2 default null
1033: ) RETURN number IS
1034: lv_employer_count number ;
1035: BEGIN
1036: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employer_count') ;
1037: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
1038:
1039: select count(distinct tax_unit_id)
1040: into lv_employer_count

Line 1037: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;

1033: ) RETURN number IS
1034: lv_employer_count number ;
1035: BEGIN
1036: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employer_count') ;
1037: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
1038:
1039: select count(distinct tax_unit_id)
1040: into lv_employer_count
1041: from pay_payroll_actions ppa,

Line 1046: hr_utility.trace('lv_employer_count := '||lv_employer_count) ;

1042: pay_assignment_actions paa
1043: where ppa.payroll_action_id = p_payroll_action_id
1044: and ppa.payroll_action_id = paa.payroll_action_id ;
1045:
1046: hr_utility.trace('lv_employer_count := '||lv_employer_count) ;
1047: RETURN lv_employer_count ;
1048:
1049: END get_employer_count ;
1050:

Line 1069: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employer_total_wages') ;

1065: ) RETURN number IS
1066: lv_employer_total_wages number ;
1067: BEGIN
1068:
1069: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employer_total_wages') ;
1070: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
1071: hr_utility.trace('p_state := ' || p_state) ;
1072:
1073: lv_employer_total_wages := 0 ;

Line 1070: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;

1066: lv_employer_total_wages number ;
1067: BEGIN
1068:
1069: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employer_total_wages') ;
1070: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
1071: hr_utility.trace('p_state := ' || p_state) ;
1072:
1073: lv_employer_total_wages := 0 ;
1074:

Line 1071: hr_utility.trace('p_state := ' || p_state) ;

1067: BEGIN
1068:
1069: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employer_total_wages') ;
1070: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
1071: hr_utility.trace('p_state := ' || p_state) ;
1072:
1073: lv_employer_total_wages := 0 ;
1074:
1075: IF p_state = 'MI' THEN

Line 1118: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_excess_wages') ;

1114: lv_excess_wages number ;
1115:
1116: BEGIN
1117:
1118: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_excess_wages') ;
1119: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
1120: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
1121: hr_utility.trace('p_state := ' || p_state) ;
1122:

Line 1119: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;

1115:
1116: BEGIN
1117:
1118: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_excess_wages') ;
1119: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
1120: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
1121: hr_utility.trace('p_state := ' || p_state) ;
1122:
1123: lv_excess_wages := 0 ;

Line 1120: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;

1116: BEGIN
1117:
1118: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_excess_wages') ;
1119: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
1120: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
1121: hr_utility.trace('p_state := ' || p_state) ;
1122:
1123: lv_excess_wages := 0 ;
1124:

Line 1121: hr_utility.trace('p_state := ' || p_state) ;

1117:
1118: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_excess_wages') ;
1119: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
1120: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
1121: hr_utility.trace('p_state := ' || p_state) ;
1122:
1123: lv_excess_wages := 0 ;
1124:
1125:

Line 1207: hr_utility.trace('Actual SUI Taxable Amount'||p_sui_taxable);

1203: and fdi3.user_name = 'A_SUI_ER_GROSS_PER_JD_GRE_MONTH'
1204: and length(translate(trim(fai.value),' .0123456789',' ')) is null
1205: and length(translate(trim(fai2.value),' .0123456789',' ')) is null ;
1206:
1207: hr_utility.trace('Actual SUI Taxable Amount'||p_sui_taxable);
1208:
1209:
1210: return(0);
1211: