eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on HR_UTILITY

Line 150: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);

146: ln_payroll_id NUMBER;
147: ln_consolidation_set_id NUMBER;
148:
149: BEGIN
150: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);
151:
152: open c_payroll_action(p_payroll_action_id);
153: fetch c_payroll_action into
154: ld_start_date, ld_end_date, ln_business_group_id,

Line 158: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);

154: ld_start_date, ld_end_date, ln_business_group_id,
155: lv_report_qualifier, lv_report_type,
156: lv_report_category, lv_leg_parameter;
157: if c_payroll_action%notfound then
158: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
159: hr_utility.raise_error;
160: end if;
161: close c_payroll_action;
162: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);

Line 159: hr_utility.raise_error;

155: lv_report_qualifier, lv_report_type,
156: lv_report_category, lv_leg_parameter;
157: if c_payroll_action%notfound then
158: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
159: hr_utility.raise_error;
160: end if;
161: close c_payroll_action;
162: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
163:

Line 162: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);

158: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
159: hr_utility.raise_error;
160: end if;
161: close c_payroll_action;
162: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
163:
164: ln_payroll_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
165: 'TRANSFER_PAYROLL_ID'
166: ,'TRANSFER_CONSOLIDATION_SET_ID'

Line 168: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);

164: ln_payroll_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
165: 'TRANSFER_PAYROLL_ID'
166: ,'TRANSFER_CONSOLIDATION_SET_ID'
167: ,lv_leg_parameter)));
168: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);
169: ln_consolidation_set_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
170: 'TRANSFER_CONSOLIDATION_SET_ID'
171: ,'TRANSFER_TAX_UNIT_ID'
172: ,lv_leg_parameter)));

Line 173: hr_utility.set_location(gv_package || '.get_payroll_action_info', 50);

169: ln_consolidation_set_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
170: 'TRANSFER_CONSOLIDATION_SET_ID'
171: ,'TRANSFER_TAX_UNIT_ID'
172: ,lv_leg_parameter)));
173: hr_utility.set_location(gv_package || '.get_payroll_action_info', 50);
174: ln_tax_unit_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
175: 'TRANSFER_TAX_UNIT_ID'
176: ,null
177: ,lv_leg_parameter)));

Line 179: hr_utility.set_location(gv_package || '.get_payroll_action_info', 60);

175: 'TRANSFER_TAX_UNIT_ID'
176: ,null
177: ,lv_leg_parameter)));
178:
179: hr_utility.set_location(gv_package || '.get_payroll_action_info', 60);
180: p_start_date := ld_start_date;
181: p_end_date := ld_end_date;
182: p_report_qualifier := lv_report_qualifier;
183: p_report_type := lv_report_type;

Line 190: hr_utility.set_location(gv_package || '.get_payroll_action_info', 100);

186: p_tax_unit_id := ln_tax_unit_id;
187: p_payroll_id := ln_payroll_id;
188: p_consolidation_set_id := ln_consolidation_set_id;
189:
190: hr_utility.set_location(gv_package || '.get_payroll_action_info', 100);
191:
192: END get_payroll_action_info;
193:
194: /*******************************************************************

Line 296: hr_utility.set_location(gv_package || '.range_code', 10);

292: ln_payroll_id NUMBER;
293: ln_consolidation_set_id NUMBER;
294:
295: BEGIN
296: hr_utility.set_location(gv_package || '.range_code', 10);
297: get_payroll_action_info (
298: p_payroll_action_id
299: ,ld_start_date
300: ,ld_end_date

Line 309: hr_utility.trace('ld_start_date = ' || ld_start_date);

305: ,ln_tax_unit_id
306: ,ln_payroll_id
307: ,ln_consolidation_set_id);
308:
309: hr_utility.trace('ld_start_date = ' || ld_start_date);
310: hr_utility.trace('ld_end_date = ' || ld_end_date);
311: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
312: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
313: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);

Line 310: hr_utility.trace('ld_end_date = ' || ld_end_date);

306: ,ln_payroll_id
307: ,ln_consolidation_set_id);
308:
309: hr_utility.trace('ld_start_date = ' || ld_start_date);
310: hr_utility.trace('ld_end_date = ' || ld_end_date);
311: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
312: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
313: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
314: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);

Line 311: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);

307: ,ln_consolidation_set_id);
308:
309: hr_utility.trace('ld_start_date = ' || ld_start_date);
310: hr_utility.trace('ld_end_date = ' || ld_end_date);
311: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
312: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
313: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
314: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
315: hr_utility.trace('lv_report_type = ' || lv_report_type);

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

308:
309: hr_utility.trace('ld_start_date = ' || ld_start_date);
310: hr_utility.trace('ld_end_date = ' || ld_end_date);
311: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
312: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
313: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
314: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
315: hr_utility.trace('lv_report_type = ' || lv_report_type);
316: hr_utility.trace('lv_report_category = ' || lv_report_category);

Line 313: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);

309: hr_utility.trace('ld_start_date = ' || ld_start_date);
310: hr_utility.trace('ld_end_date = ' || ld_end_date);
311: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
312: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
313: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
314: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
315: hr_utility.trace('lv_report_type = ' || lv_report_type);
316: hr_utility.trace('lv_report_category = ' || lv_report_category);
317:

Line 314: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);

310: hr_utility.trace('ld_end_date = ' || ld_end_date);
311: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
312: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
313: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
314: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
315: hr_utility.trace('lv_report_type = ' || lv_report_type);
316: hr_utility.trace('lv_report_category = ' || lv_report_category);
317:
318: hr_utility.set_location(gv_package || '.range_code', 20);

Line 315: hr_utility.trace('lv_report_type = ' || lv_report_type);

311: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
312: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
313: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
314: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
315: hr_utility.trace('lv_report_type = ' || lv_report_type);
316: hr_utility.trace('lv_report_category = ' || lv_report_category);
317:
318: hr_utility.set_location(gv_package || '.range_code', 20);
319:

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

312: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
313: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
314: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
315: hr_utility.trace('lv_report_type = ' || lv_report_type);
316: hr_utility.trace('lv_report_category = ' || lv_report_category);
317:
318: hr_utility.set_location(gv_package || '.range_code', 20);
319:
320: if ln_tax_unit_id is not null then

Line 318: hr_utility.set_location(gv_package || '.range_code', 20);

314: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
315: hr_utility.trace('lv_report_type = ' || lv_report_type);
316: hr_utility.trace('lv_report_category = ' || lv_report_category);
317:
318: hr_utility.set_location(gv_package || '.range_code', 20);
319:
320: if ln_tax_unit_id is not null then
321: hr_utility.set_location(gv_package || '.range_code', 30);
322: ln_error_count := ln_error_count +

Line 321: hr_utility.set_location(gv_package || '.range_code', 30);

317:
318: hr_utility.set_location(gv_package || '.range_code', 20);
319:
320: if ln_tax_unit_id is not null then
321: hr_utility.set_location(gv_package || '.range_code', 30);
322: ln_error_count := ln_error_count +
323: check_tax_unit_fein(
324: p_tax_unit_id => ln_tax_unit_id
325: ,p_payroll_action_id => p_payroll_action_id);

Line 327: hr_utility.set_location(gv_package || '.range_code', 40);

323: check_tax_unit_fein(
324: p_tax_unit_id => ln_tax_unit_id
325: ,p_payroll_action_id => p_payroll_action_id);
326: else
327: hr_utility.set_location(gv_package || '.range_code', 40);
328: open c_arch_tax_unit( ln_business_group_id
329: ,ld_start_date
330: ,ld_end_date);
331: loop

Line 338: hr_utility.set_location(gv_package || '.range_code', 50);

334: if c_arch_tax_unit%notfound then
335: exit;
336: end if;
337:
338: hr_utility.set_location(gv_package || '.range_code', 50);
339: hr_utility.trace('ln_arch_tax_unit_id = ' || ln_arch_tax_unit_id);
340: hr_utility.trace('lv_arch_tax_unit_fein = ' || lv_arch_tax_unit_fein);
341: hr_utility.set_location(gv_package || '.range_code', 60);
342:

Line 339: hr_utility.trace('ln_arch_tax_unit_id = ' || ln_arch_tax_unit_id);

335: exit;
336: end if;
337:
338: hr_utility.set_location(gv_package || '.range_code', 50);
339: hr_utility.trace('ln_arch_tax_unit_id = ' || ln_arch_tax_unit_id);
340: hr_utility.trace('lv_arch_tax_unit_fein = ' || lv_arch_tax_unit_fein);
341: hr_utility.set_location(gv_package || '.range_code', 60);
342:
343: ln_error_count := ln_error_count +

Line 340: hr_utility.trace('lv_arch_tax_unit_fein = ' || lv_arch_tax_unit_fein);

336: end if;
337:
338: hr_utility.set_location(gv_package || '.range_code', 50);
339: hr_utility.trace('ln_arch_tax_unit_id = ' || ln_arch_tax_unit_id);
340: hr_utility.trace('lv_arch_tax_unit_fein = ' || lv_arch_tax_unit_fein);
341: hr_utility.set_location(gv_package || '.range_code', 60);
342:
343: ln_error_count := ln_error_count +
344: check_tax_unit_fein(

Line 341: hr_utility.set_location(gv_package || '.range_code', 60);

337:
338: hr_utility.set_location(gv_package || '.range_code', 50);
339: hr_utility.trace('ln_arch_tax_unit_id = ' || ln_arch_tax_unit_id);
340: hr_utility.trace('lv_arch_tax_unit_fein = ' || lv_arch_tax_unit_fein);
341: hr_utility.set_location(gv_package || '.range_code', 60);
342:
343: ln_error_count := ln_error_count +
344: check_tax_unit_fein(
345: p_tax_unit_id => ln_arch_tax_unit_id

Line 350: hr_utility.set_location(gv_package || '.range_code', 70);

346: ,p_payroll_action_id => p_payroll_action_id
347: ,p_tax_unit_fein => lv_arch_tax_unit_fein);
348: end loop;
349: close c_arch_tax_unit;
350: hr_utility.set_location(gv_package || '.range_code', 70);
351: end if;
352:
353: hr_utility.trace('Error Count = ' || ln_error_count);
354: if ln_error_count > 0 then

Line 353: hr_utility.trace('Error Count = ' || ln_error_count);

349: close c_arch_tax_unit;
350: hr_utility.set_location(gv_package || '.range_code', 70);
351: end if;
352:
353: hr_utility.trace('Error Count = ' || ln_error_count);
354: if ln_error_count > 0 then
355: lv_error_message := 'Please check the messages at the Payroll Action Level' ||
356: 'to find out the GRE''s with invalid FEIN.';
357:

Line 358: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

354: if ln_error_count > 0 then
355: lv_error_message := 'Please check the messages at the Payroll Action Level' ||
356: 'to find out the GRE''s with invalid FEIN.';
357:
358: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
359: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
360: commit;
361: hr_utility.raise_error;
362: end if;

Line 359: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);

355: lv_error_message := 'Please check the messages at the Payroll Action Level' ||
356: 'to find out the GRE''s with invalid FEIN.';
357:
358: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
359: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
360: commit;
361: hr_utility.raise_error;
362: end if;
363:

Line 361: hr_utility.raise_error;

357:
358: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
359: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
360: commit;
361: hr_utility.raise_error;
362: end if;
363:
364: hr_utility.set_location(gv_package || '.range_code', 60);
365:

Line 364: hr_utility.set_location(gv_package || '.range_code', 60);

360: commit;
361: hr_utility.raise_error;
362: end if;
363:
364: hr_utility.set_location(gv_package || '.range_code', 60);
365:
366: lv_sql_string :=
367: 'select distinct paf.person_id
368: from pay_payroll_actions ppa,

Line 422: hr_utility.set_location(gv_package || '.range_code', 50);

418: ,ppa.legislative_parameters)))
419: order by paf.person_id';
420:
421: p_sql_string := lv_sql_string;
422: hr_utility.set_location(gv_package || '.range_code', 50);
423:
424: END range_cursor;
425:
426: /********************************************************

Line 517: hr_utility.set_location(gv_package || '.action_creation', 10);

513:
514: ln_locking_action_id NUMBER;
515:
516: BEGIN
517: hr_utility.set_location(gv_package || '.action_creation', 10);
518: get_payroll_action_info (
519: p_payroll_action_id
520: ,ld_start_date
521: ,ld_end_date

Line 530: hr_utility.set_location(gv_package || '.action_creation', 20);

526: ,ln_tax_unit_id
527: ,ln_payroll_id
528: ,ln_consolidation_set_id);
529:
530: hr_utility.set_location(gv_package || '.action_creation', 20);
531: open c_get_fls_emp( ln_tax_unit_id
532: ,ln_payroll_id
533: ,ln_consolidation_set_id
534: ,ln_business_group_id

Line 540: hr_utility.set_location(gv_package || '.action_creation', 30);

536: ,ld_end_date
537: ,p_start_person
538: ,p_end_person);
539: loop
540: hr_utility.set_location(gv_package || '.action_creation', 30);
541: fetch c_get_fls_emp into ln_assignment_id, ld_effective_date,
542: ln_emp_tax_unit_id, ln_assignment_action_id;
543: if c_get_fls_emp%notfound then
544: hr_utility.set_location(gv_package || '.action_creation', 40);

Line 544: hr_utility.set_location(gv_package || '.action_creation', 40);

540: hr_utility.set_location(gv_package || '.action_creation', 30);
541: fetch c_get_fls_emp into ln_assignment_id, ld_effective_date,
542: ln_emp_tax_unit_id, ln_assignment_action_id;
543: if c_get_fls_emp%notfound then
544: hr_utility.set_location(gv_package || '.action_creation', 40);
545: exit;
546: end if;
547:
548: hr_utility.set_location(gv_package || '.action_creation', 50);

Line 548: hr_utility.set_location(gv_package || '.action_creation', 50);

544: hr_utility.set_location(gv_package || '.action_creation', 40);
545: exit;
546: end if;
547:
548: hr_utility.set_location(gv_package || '.action_creation', 50);
549: select pay_assignment_actions_s.nextval
550: into ln_locking_action_id
551: from dual;
552:

Line 556: hr_utility.set_location(gv_package || '.action_creation', 60);

552:
553: -- insert into pay_assignment_actions.
554: hr_nonrun_asact.insact(ln_locking_action_id, ln_assignment_id,
555: p_payroll_action_id, p_chunk, ln_emp_tax_unit_id);
556: hr_utility.set_location(gv_package || '.action_creation', 60);
557:
558: -- insert an interlock to this action
559: hr_nonrun_asact.insint(ln_locking_action_id, ln_assignment_action_id);
560:

Line 565: hr_utility.set_location(gv_package || '.action_creation', 60);

561: update pay_assignment_actions paa
562: set paa.serial_number = ln_assignment_action_id
563: where paa.assignment_action_id = ln_locking_action_id;
564:
565: hr_utility.set_location(gv_package || '.action_creation', 60);
566: end loop;
567: close c_get_fls_emp;
568:
569: hr_utility.set_location(gv_package || '.action_creation', 60);

Line 569: hr_utility.set_location(gv_package || '.action_creation', 60);

565: hr_utility.set_location(gv_package || '.action_creation', 60);
566: end loop;
567: close c_get_fls_emp;
568:
569: hr_utility.set_location(gv_package || '.action_creation', 60);
570: END action_creation;
571:
572:
573: /*******************************************************************

Line 649: hr_utility.set_location(gv_package || '.get_tax_exists', 10);

645: lv_return VARCHAR2(1) := 'N';
646:
647: BEGIN
648:
649: hr_utility.set_location(gv_package || '.get_tax_exists', 10);
650: hr_utility.trace('Effective Date = ' || p_effective_date);
651: hr_utility.trace('Tax Type = ' || p_tax_type);
652: hr_utility.trace('JD = ' || p_jurisdiction_code);
653:

Line 650: hr_utility.trace('Effective Date = ' || p_effective_date);

646:
647: BEGIN
648:
649: hr_utility.set_location(gv_package || '.get_tax_exists', 10);
650: hr_utility.trace('Effective Date = ' || p_effective_date);
651: hr_utility.trace('Tax Type = ' || p_tax_type);
652: hr_utility.trace('JD = ' || p_jurisdiction_code);
653:
654: ld_effective_date := to_date(p_effective_date, 'MM/DD/YYYY');

Line 651: hr_utility.trace('Tax Type = ' || p_tax_type);

647: BEGIN
648:
649: hr_utility.set_location(gv_package || '.get_tax_exists', 10);
650: hr_utility.trace('Effective Date = ' || p_effective_date);
651: hr_utility.trace('Tax Type = ' || p_tax_type);
652: hr_utility.trace('JD = ' || p_jurisdiction_code);
653:
654: ld_effective_date := to_date(p_effective_date, 'MM/DD/YYYY');
655: hr_utility.set_location(gv_package || '.get_tax_exists', 20);

Line 652: hr_utility.trace('JD = ' || p_jurisdiction_code);

648:
649: hr_utility.set_location(gv_package || '.get_tax_exists', 10);
650: hr_utility.trace('Effective Date = ' || p_effective_date);
651: hr_utility.trace('Tax Type = ' || p_tax_type);
652: hr_utility.trace('JD = ' || p_jurisdiction_code);
653:
654: ld_effective_date := to_date(p_effective_date, 'MM/DD/YYYY');
655: hr_utility.set_location(gv_package || '.get_tax_exists', 20);
656:

Line 655: hr_utility.set_location(gv_package || '.get_tax_exists', 20);

651: hr_utility.trace('Tax Type = ' || p_tax_type);
652: hr_utility.trace('JD = ' || p_jurisdiction_code);
653:
654: ld_effective_date := to_date(p_effective_date, 'MM/DD/YYYY');
655: hr_utility.set_location(gv_package || '.get_tax_exists', 20);
656:
657: /* If p_tax_type_resp is null, the function is called from
658: Wages Cursor so check if there is EE or ER taxes.
659: If p_tax_type_resp is not null, the function is called

Line 666: hr_utility.set_location(gv_package || '.get_tax_exists', 30);

662: */
663:
664: -- Federal
665: if p_jurisdiction_code = '00-000-0000' then
666: hr_utility.set_location(gv_package || '.get_tax_exists', 30);
667: if p_tax_type = 'UI' and nvl(p_tax_type_resp, 'ER') = 'ER' then
668: lv_return := 'Y';
669: elsif p_tax_type in ('EIC', 'HI', 'IT', 'OASDI') then
670: lv_return := 'Y';

Line 675: hr_utility.set_location(gv_package || '.get_tax_exists', 40);

671: end if;
672: -- State
673: elsif length(p_jurisdiction_code) = 11 and
674: substr(p_jurisdiction_code,3) = '-000-0000' then
675: hr_utility.set_location(gv_package || '.get_tax_exists', 40);
676: -- MA has Health Insurance report under SDI so if SDI
677: -- is passed return N and Y for HI
678: if p_jurisdiction_code = '22-000-0000' and
679: p_tax_type = 'HI' and p_tax_type_resp is null then

Line 700: hr_utility.set_location(gv_package || '.get_tax_exists', 50);

696: -- County
697: elsif substr(p_jurisdiction_code,7,5) = '-0000' and
698: substr(p_jurisdiction_code,3,4) <> '-000' then
699:
700: hr_utility.set_location(gv_package || '.get_tax_exists', 50);
701: if p_tax_type in ('OPT', 'IT') then
702: open c_county_tax_exists(p_jurisdiction_code, ld_effective_date);
703: fetch c_county_tax_exists into lv_it_exists
704: ,lv_head_tax_exists

Line 712: hr_utility.set_location(gv_package || '.get_tax_exists', 60);

708: -- City
709: elsif length(p_jurisdiction_code) = 11 and
710: substr(p_jurisdiction_code,3) <> '-000-0000' then
711:
712: hr_utility.set_location(gv_package || '.get_tax_exists', 60);
713: if p_tax_type in ('OPT', 'IT') then
714: open c_city_tax_exists(p_jurisdiction_code, ld_effective_date);
715: fetch c_city_tax_exists into lv_it_exists
716: ,lv_head_tax_exists

Line 724: hr_utility.set_location(gv_package || '.get_tax_exists', 70);

720: end if;
721:
722: if length(p_jurisdiction_code) = 8 and
723: p_tax_type in ('IT') then
724: hr_utility.set_location(gv_package || '.get_tax_exists', 70);
725: lv_return := 'Y';
726: elsif p_jurisdiction_code <> '00-000-0000' then
727: hr_utility.set_location(gv_package || '.get_tax_exists', 80);
728: if p_tax_type = 'IT' then

Line 727: hr_utility.set_location(gv_package || '.get_tax_exists', 80);

723: p_tax_type in ('IT') then
724: hr_utility.set_location(gv_package || '.get_tax_exists', 70);
725: lv_return := 'Y';
726: elsif p_jurisdiction_code <> '00-000-0000' then
727: hr_utility.set_location(gv_package || '.get_tax_exists', 80);
728: if p_tax_type = 'IT' then
729: lv_return := lv_it_exists;
730: elsif ((p_tax_type = 'SDI') or
731: (p_jurisdiction_code = '22-000-0000' and

Line 765: hr_utility.set_location(gv_package || '.get_tax_exists', 90);

761: lv_return := lv_head_tax_exists;
762: end if;
763: end if;
764:
765: hr_utility.set_location(gv_package || '.get_tax_exists', 90);
766: hr_utility.trace('Returned Value = ' || lv_return);
767: hr_utility.set_location(gv_package || '.get_tax_exists', 100);
768:
769: return(lv_return);

Line 766: hr_utility.trace('Returned Value = ' || lv_return);

762: end if;
763: end if;
764:
765: hr_utility.set_location(gv_package || '.get_tax_exists', 90);
766: hr_utility.trace('Returned Value = ' || lv_return);
767: hr_utility.set_location(gv_package || '.get_tax_exists', 100);
768:
769: return(lv_return);
770:

Line 767: hr_utility.set_location(gv_package || '.get_tax_exists', 100);

763: end if;
764:
765: hr_utility.set_location(gv_package || '.get_tax_exists', 90);
766: hr_utility.trace('Returned Value = ' || lv_return);
767: hr_utility.set_location(gv_package || '.get_tax_exists', 100);
768:
769: return(lv_return);
770:
771: END get_tax_exists;

Line 788: hr_utility.set_location(gv_package || '.get_jurisdiction_name', 10);

784: lv_jurisdiction_name VARCHAR2(200);
785:
786: BEGIN
787:
788: hr_utility.set_location(gv_package || '.get_jurisdiction_name', 10);
789: hr_utility.trace('JD =' || p_jurisdiction_code);
790:
791: if p_jurisdiction_code = '00-000-0000' then
792: lv_jurisdiction_name := 'Federal';

Line 789: hr_utility.trace('JD =' || p_jurisdiction_code);

785:
786: BEGIN
787:
788: hr_utility.set_location(gv_package || '.get_jurisdiction_name', 10);
789: hr_utility.trace('JD =' || p_jurisdiction_code);
790:
791: if p_jurisdiction_code = '00-000-0000' then
792: lv_jurisdiction_name := 'Federal';
793: else

Line 903: hr_utility.set_location(gv_package || '.get_fls_agency_code', 10);

899: ld_effective_date DATE;
900:
901: BEGIN
902:
903: hr_utility.set_location(gv_package || '.get_fls_agency_code', 10);
904: hr_utility.trace('JD =' || p_jurisdiction_code);
905: hr_utility.trace('Eff Date =' || p_effective_date);
906:
907: ld_effective_date := to_date(p_effective_date, 'mm/dd/yyyy');

Line 904: hr_utility.trace('JD =' || p_jurisdiction_code);

900:
901: BEGIN
902:
903: hr_utility.set_location(gv_package || '.get_fls_agency_code', 10);
904: hr_utility.trace('JD =' || p_jurisdiction_code);
905: hr_utility.trace('Eff Date =' || p_effective_date);
906:
907: ld_effective_date := to_date(p_effective_date, 'mm/dd/yyyy');
908:

Line 905: hr_utility.trace('Eff Date =' || p_effective_date);

901: BEGIN
902:
903: hr_utility.set_location(gv_package || '.get_fls_agency_code', 10);
904: hr_utility.trace('JD =' || p_jurisdiction_code);
905: hr_utility.trace('Eff Date =' || p_effective_date);
906:
907: ld_effective_date := to_date(p_effective_date, 'mm/dd/yyyy');
908:
909: hr_utility.set_location(gv_package || '.get_fls_agency_code', 20);

Line 909: hr_utility.set_location(gv_package || '.get_fls_agency_code', 20);

905: hr_utility.trace('Eff Date =' || p_effective_date);
906:
907: ld_effective_date := to_date(p_effective_date, 'mm/dd/yyyy');
908:
909: hr_utility.set_location(gv_package || '.get_fls_agency_code', 20);
910:
911: -- Federal
912: if p_jurisdiction_code = '00-000-0000' then
913: hr_utility.set_location(gv_package || '.get_fls_agency_code', 30);

Line 913: hr_utility.set_location(gv_package || '.get_fls_agency_code', 30);

909: hr_utility.set_location(gv_package || '.get_fls_agency_code', 20);
910:
911: -- Federal
912: if p_jurisdiction_code = '00-000-0000' then
913: hr_utility.set_location(gv_package || '.get_fls_agency_code', 30);
914: open c_federal_agency_code(ld_effective_date);
915: fetch c_federal_agency_code into lv_agency_code,
916: lv_futa_agency_code;
917: close c_federal_agency_code;

Line 925: hr_utility.set_location(gv_package || '.get_fls_agency_code', 40);

921: end if;
922:
923: -- State
924: elsif substr(p_jurisdiction_code,3) = '-000-0000' then
925: hr_utility.set_location(gv_package || '.get_fls_agency_code', 40);
926: open c_state_agency_code(p_jurisdiction_code, ld_effective_date);
927: fetch c_state_agency_code into lv_agency_code;
928: close c_state_agency_code;
929: -- County

Line 932: hr_utility.set_location(gv_package || '.get_fls_agency_code', 50);

928: close c_state_agency_code;
929: -- County
930: elsif substr(p_jurisdiction_code,7,5) = '-0000' and
931: substr(p_jurisdiction_code,3,4) <> '-000' then
932: hr_utility.set_location(gv_package || '.get_fls_agency_code', 50);
933: open c_county_agency_code(p_jurisdiction_code, ld_effective_date);
934: fetch c_county_agency_code into lv_agency_code,
935: lv_opt_agency_code;
936: close c_county_agency_code;

Line 949: hr_utility.set_location(gv_package || '.get_fls_agency_code', 60);

945:
946: -- City
947: elsif length(p_jurisdiction_code) = 11 and
948: substr(p_jurisdiction_code,3) <> '-000-0000' then
949: hr_utility.set_location(gv_package || '.get_fls_agency_code', 60);
950: open c_city_agency_code(p_jurisdiction_code, ld_effective_date);
951: fetch c_city_agency_code into lv_agency_code, lv_opt_agency_code;
952: close c_city_agency_code;
953:

Line 964: hr_utility.set_location(gv_package || '.get_fls_agency_code', 70);

960: end if;
961:
962: -- School
963: elsif length(p_jurisdiction_code) = 8 then
964: hr_utility.set_location(gv_package || '.get_fls_agency_code', 70);
965: open c_school_agency_code( p_jurisdiction_code
966: ,p_resident_jurisdiction
967: ,ld_effective_date);
968: fetch c_school_agency_code into lv_agency_code;

Line 971: hr_utility.set_location(gv_package || '.get_fls_agency_code', 100);

967: ,ld_effective_date);
968: fetch c_school_agency_code into lv_agency_code;
969: close c_school_agency_code;
970: end if;
971: hr_utility.set_location(gv_package || '.get_fls_agency_code', 100);
972:
973: return (lv_agency_code);
974:
975: END get_fls_agency_code;

Line 1042: hr_utility.set_location(gv_package || '.get_fls_jd_values', 10);

1038:
1039: i_count NUMBER := 0;
1040:
1041: BEGIN
1042: hr_utility.set_location(gv_package || '.get_fls_jd_values', 10);
1043:
1044: /* Reset the PL/SQL tables */
1045: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1046: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..

Line 1083: hr_utility.trace('Payroll Action ID=' || p_payroll_action_id);

1079: end loop;
1080: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1081: end if;
1082:
1083: hr_utility.trace('Payroll Action ID=' || p_payroll_action_id);
1084: hr_utility.trace('Tax Unit ID=' || p_tax_unit_id);
1085: for action_rec in c_action_info(p_tax_unit_id, p_payroll_action_id)
1086: loop
1087: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);

Line 1084: hr_utility.trace('Tax Unit ID=' || p_tax_unit_id);

1080: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1081: end if;
1082:
1083: hr_utility.trace('Payroll Action ID=' || p_payroll_action_id);
1084: hr_utility.trace('Tax Unit ID=' || p_tax_unit_id);
1085: for action_rec in c_action_info(p_tax_unit_id, p_payroll_action_id)
1086: loop
1087: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);
1088: /* Commented out because of DB issue. Bug 1822467 */

Line 1087: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);

1083: hr_utility.trace('Payroll Action ID=' || p_payroll_action_id);
1084: hr_utility.trace('Tax Unit ID=' || p_tax_unit_id);
1085: for action_rec in c_action_info(p_tax_unit_id, p_payroll_action_id)
1086: loop
1087: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);
1088: /* Commented out because of DB issue. Bug 1822467 */
1089: --pay_us_fls_reporting_pkg.ltr_action_info(i_count) := action_rec;
1090: pay_us_fls_reporting_pkg.ltr_action_info(i_count).jurisdiction_code
1091: := action_rec.jurisdiction_code;

Line 1154: hr_utility.set_location(gv_package || '.get_fls_jd_values', 30);

1150: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information30
1151: := action_rec.action_information30;
1152:
1153: i_count := i_count + 1;
1154: hr_utility.set_location(gv_package || '.get_fls_jd_values', 30);
1155: end loop;
1156:
1157: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1158: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then

Line 1157: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);

1153: i_count := i_count + 1;
1154: hr_utility.set_location(gv_package || '.get_fls_jd_values', 30);
1155: end loop;
1156:
1157: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1158: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1159: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1160: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1161: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);

Line 1161: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);

1157: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1158: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1159: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1160: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1161: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1162: end loop;
1163: end if;
1164: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1165:

Line 1164: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');

1160: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1161: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1162: end loop;
1163: end if;
1164: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1165:
1166: hr_utility.set_location(gv_package || '.get_fls_jd_values', 100);
1167: return (1);
1168: END get_fls_jd_values;

Line 1166: hr_utility.set_location(gv_package || '.get_fls_jd_values', 100);

1162: end loop;
1163: end if;
1164: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1165:
1166: hr_utility.set_location(gv_package || '.get_fls_jd_values', 100);
1167: return (1);
1168: END get_fls_jd_values;
1169:
1170: /*******************************************************************

Line 1210: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);

1206:
1207: lv_return VARCHAR2(200);
1208:
1209: BEGIN
1210: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);
1211: hr_utility.trace('Tax Type Code=' || p_tax_type);
1212: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1213: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1214:

Line 1211: hr_utility.trace('Tax Type Code=' || p_tax_type);

1207: lv_return VARCHAR2(200);
1208:
1209: BEGIN
1210: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);
1211: hr_utility.trace('Tax Type Code=' || p_tax_type);
1212: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1213: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1214:
1215: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..

Line 1212: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);

1208:
1209: BEGIN
1210: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);
1211: hr_utility.trace('Tax Type Code=' || p_tax_type);
1212: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1213: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1214:
1215: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1216: pay_us_fls_reporting_pkg.ltr_action_info.last loop

Line 1213: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);

1209: BEGIN
1210: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);
1211: hr_utility.trace('Tax Type Code=' || p_tax_type);
1212: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1213: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1214:
1215: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1216: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1217:

Line 1218: hr_utility.trace('PL/SQL Jurisdiction Code=' ||

1214:
1215: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1216: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1217:
1218: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1219: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1220:
1221: hr_utility.trace('PL/SQL Action30 is= ' ||
1222: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30);

Line 1221: hr_utility.trace('PL/SQL Action30 is= ' ||

1217:
1218: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1219: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1220:
1221: hr_utility.trace('PL/SQL Action30 is= ' ||
1222: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30);
1223:
1224: hr_utility.trace('PL/SQL p_jurisdiction is= ' ||
1225: p_jurisdiction);

Line 1224: hr_utility.trace('PL/SQL p_jurisdiction is= ' ||

1220:
1221: hr_utility.trace('PL/SQL Action30 is= ' ||
1222: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30);
1223:
1224: hr_utility.trace('PL/SQL p_jurisdiction is= ' ||
1225: p_jurisdiction);
1226:
1227: hr_utility.trace('PL/SQL p_resident_jurisdiction is = ' ||
1228: nvl(p_resident_jurisdiction,'NOT ARCHIVED'));

Line 1227: hr_utility.trace('PL/SQL p_resident_jurisdiction is = ' ||

1223:
1224: hr_utility.trace('PL/SQL p_jurisdiction is= ' ||
1225: p_jurisdiction);
1226:
1227: hr_utility.trace('PL/SQL p_resident_jurisdiction is = ' ||
1228: nvl(p_resident_jurisdiction,'NOT ARCHIVED'));
1229:
1230: if pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code = p_jurisdiction then
1231:

Line 1232: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 20);

1228: nvl(p_resident_jurisdiction,'NOT ARCHIVED'));
1229:
1230: if pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code = p_jurisdiction then
1231:
1232: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 20);
1233:
1234: if p_jurisdiction = '00-000-0000' then
1235: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 30);
1236: -- Regular Earnings

Line 1235: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 30);

1231:
1232: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 20);
1233:
1234: if p_jurisdiction = '00-000-0000' then
1235: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 30);
1236: -- Regular Earnings
1237: ln_amt1 := ln_amt1 +
1238: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1239: -- Gross Earnings

Line 1247: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 40);

1243: ln_amt3 := ln_amt3 +
1244: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1245:
1246: if p_tax_type = 'IT' then
1247: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 40);
1248: -- Supp Earning for FIT
1249: ln_amt4 := ln_amt4 +
1250: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1251: -- Supp Earning for NWFIT

Line 1262: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 50);

1258: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1259: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1260:
1261: elsif p_tax_type = 'UI' then
1262: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 50);
1263: -- Supp Earning for FUTA
1264: ln_amt4 := ln_amt4 +
1265: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1266: -- Pre Tax Deduction for FUTA

Line 1277: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 60);

1273: ln_r_er_tax_amt := ln_r_er_tax_amt +
1274: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22;
1275:
1276: elsif p_tax_type = 'OASDI' then
1277: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 60);
1278: -- Supp Earning for SS
1279: ln_amt4 := ln_amt4 +
1280: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1281: -- Pre Tax Deduction for SS

Line 1294: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 70);

1290: -- SS ER Liability
1291: ln_r_er_tax_amt := ln_r_er_tax_amt +
1292: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1293: elsif p_tax_type = 'HI' then
1294: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 70);
1295: -- Supp Earning for Medicare
1296: ln_amt4 := ln_amt4 +
1297: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1298: -- Pre Tax Deduction for Medicare

Line 1311: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 80);

1307: -- Medicare ER Liability
1308: ln_r_er_tax_amt := ln_r_er_tax_amt +
1309: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1310: elsif p_tax_type = 'EIC' then
1311: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 80);
1312: ln_amt1 := 0;
1313: ln_amt2 := 0;
1314: ln_amt3 := 0;
1315: -- EIC Advance

Line 1325: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 110);

1321: -- State Jurisdiction code
1322: elsif substr(p_jurisdiction,3) = '-000-0000' and
1323: p_jurisdiction <> '00-000-0000' then
1324:
1325: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 110);
1326:
1327: if p_tax_type = 'IT' then
1328: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 120);
1329: --SIT Gross

Line 1328: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 120);

1324:
1325: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 110);
1326:
1327: if p_tax_type = 'IT' then
1328: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 120);
1329: --SIT Gross
1330: ln_amt2 := ln_amt2 +
1331: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1332: -- SIT Subj Whable

Line 1346: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 130);

1342: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1343: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1344:
1345: elsif p_tax_type = 'UI' then
1346: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 130);
1347: /* Always report the ER component if it is there. -- 4335410
1348: In case ER is null report EE.
1349: SUI and SDI ER Liability is always passed as 0.
1350: Doing an if to get EE or ER Wages instead on NVL as the PL/SQL table will

Line 1355: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 140);

1351: have a Zero value if there is a NULL in the table. */
1352:
1353: -- SUI EE Gross, SUI ER Gross
1354: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29,0) <> 0 then
1355: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 140);
1356: ln_amt2 := ln_amt2 +
1357: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29;
1358: else
1359: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 150);

Line 1359: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 150);

1355: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 140);
1356: ln_amt2 := ln_amt2 +
1357: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29;
1358: else
1359: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 150);
1360: ln_amt2 := ln_amt2 +
1361: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28;
1362: end if;
1363:

Line 1366: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 160);

1362: end if;
1363:
1364: -- nvl(SUI EE Subj Whable, SUI ER Subj Whable)
1365: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19,0) <> 0 then
1366: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 160);
1367: ln_amt4 := ln_amt4 +
1368: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1369: else
1370: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 170);

Line 1370: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 170);

1366: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 160);
1367: ln_amt4 := ln_amt4 +
1368: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1369: else
1370: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 170);
1371: ln_amt4 := ln_amt4 +
1372: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1373: end if;
1374:

Line 1377: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 180);

1373: end if;
1374:
1375: -- nvl(SUI EE Pre Tax Redns, SUI ER Pre Tax Redns)
1376: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20,0) <> 0 then
1377: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 180);
1378: ln_amt3 := ln_amt3 +
1379: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1380: else
1381: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 190);

Line 1381: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 190);

1377: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 180);
1378: ln_amt3 := ln_amt3 +
1379: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1380: else
1381: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 190);
1382: ln_amt3 := ln_amt3 +
1383: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16;
1384: end if;
1385:

Line 1388: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 200);

1384: end if;
1385:
1386: -- nvl(SUI EE Taxable, SUI ER Taxable)
1387: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18,0) <> 0 then
1388: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 200);
1389: ln_amt7 := ln_amt7 +
1390: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1391: else
1392: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 210);

Line 1392: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 210);

1388: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 200);
1389: ln_amt7 := ln_amt7 +
1390: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1391: else
1392: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 210);
1393: ln_amt7 := ln_amt7 +
1394: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1395: end if;
1396:

Line 1405: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 220);

1401: ln_r_er_tax_amt := ln_r_er_tax_amt +
1402: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1403:
1404: elsif p_tax_type in ('SDI', 'HI') then
1405: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 220);
1406: /******************************************************
1407: Checking for SDI and HI because for MA the tax_type
1408: will be HI. The HI balances are stored in the same SDI
1409: balances as all other states.

Line 1418: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 230);

1414: SDI ER Liability is always passed as 0
1415: *******************************************************/
1416: --SDI EE Gross, SDI ER Gross
1417: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27,0) <> 0 then
1418: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 230);
1419: ln_amt2 := ln_amt2 +
1420: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27;
1421: else
1422: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 240);

Line 1422: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 240);

1418: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 230);
1419: ln_amt2 := ln_amt2 +
1420: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27;
1421: else
1422: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 240);
1423: ln_amt2 := ln_amt2 +
1424: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26;
1425: end if;
1426:

Line 1429: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 250);

1425: end if;
1426:
1427: -- nvl(SDI EE Subj Whable, SDI ER Subj Whable)
1428: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11,0) <> 0 then
1429: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 250);
1430: ln_amt4 := ln_amt4 +
1431: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1432: else
1433: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 260);

Line 1433: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 260);

1429: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 250);
1430: ln_amt4 := ln_amt4 +
1431: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1432: else
1433: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 260);
1434: ln_amt4 := ln_amt4 +
1435: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1436: end if;
1437:

Line 1440: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 270);

1436: end if;
1437:
1438: -- nvl(SDI EE Pre Tax Redns, SDI ER Pre Tax Redns)
1439: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12,0) <> 0 then
1440: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 270);
1441: ln_amt3 := ln_amt3 +
1442: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1443: else
1444: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 280);

Line 1444: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 280);

1440: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 270);
1441: ln_amt3 := ln_amt3 +
1442: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1443: else
1444: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 280);
1445: ln_amt3 := ln_amt3 +
1446: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1447: end if;
1448:

Line 1451: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 290);

1447: end if;
1448:
1449: -- nvl(SDI EE Taxable, SDI ER Taxable)
1450: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10,0) <> 0 then
1451: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 290);
1452: ln_amt7 := ln_amt7 +
1453: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10;
1454: else
1455: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 300);

Line 1455: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 300);

1451: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 290);
1452: ln_amt7 := ln_amt7 +
1453: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10;
1454: else
1455: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 300);
1456: ln_amt7 := ln_amt7 +
1457: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1458: end if;
1459:

Line 1467: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 350);

1463: -- SDI ER Liability
1464: ln_r_er_tax_amt := ln_r_er_tax_amt +
1465: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1466: elsif p_tax_type = 'WC' then
1467: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 350);
1468: null;
1469: /*
1470: -- WC Withheld
1471: ln_r_ee_tax_amt := ln_r_ee_tax_amt +

Line 1480: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 400);

1476: exit;
1477: -- County Jurisdiction code
1478: elsif substr(p_jurisdiction,7) = '-0000' and
1479: substr(p_jurisdiction,3,4) <> '-000'then
1480: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 400);
1481: -- Gross Earnings
1482: ln_amt2 := ln_amt2 +
1483: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1484:

Line 1486: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 410);

1482: ln_amt2 := ln_amt2 +
1483: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1484:
1485: if p_tax_type = 'IT' then
1486: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 410);
1487: -- County Subj Whable
1488: ln_amt4 := ln_amt4 +
1489: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1490: -- County Subj NWhable

Line 1499: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);

1495: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1496: -- County Withheld
1497: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1498: = 'R' then
1499: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);
1500: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1501: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1502: ln_r_flag := 'Y';
1503: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')

Line 1505: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 430);

1501: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1502: ln_r_flag := 'Y';
1503: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1504: = 'NR' then
1505: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 430);
1506: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1507: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1508: ln_nr_flag := 'Y';
1509: end if;

Line 1512: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 440);

1508: ln_nr_flag := 'Y';
1509: end if;
1510:
1511: elsif p_tax_type = 'OPT' then
1512: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 440);
1513: -- Head Tax Subj Whable
1514: ln_amt4 := ln_amt4 +
1515: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1516: -- Head Tax Subj NWhable

Line 1525: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 450);

1521: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1522:
1523: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1524: = 'R' then
1525: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 450);
1526: -- Head Tax Withheld
1527: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1528: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1529: -- Head Tax Liability

Line 1535: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 460);

1531: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1532: ln_r_flag := 'Y';
1533: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1534: = 'NR' then
1535: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 460);
1536: -- Head Tax Withheld
1537: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1538: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1539: -- Head Tax Liability

Line 1553: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 500);

1549: -- City Jurisdiction code
1550: elsif length(p_jurisdiction) = 11 and
1551: substr(p_jurisdiction,3) <> '-000-0000'then
1552: -- Gross Earnings
1553: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 500);
1554: ln_amt2 := ln_amt2 +
1555: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1556:
1557: if p_tax_type = 'IT' then

Line 1558: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 510);

1554: ln_amt2 := ln_amt2 +
1555: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1556:
1557: if p_tax_type = 'IT' then
1558: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 510);
1559: -- City Subj Whable
1560: ln_amt4 := ln_amt4 +
1561: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1562: -- City Subj NWhable

Line 1570: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);

1566: ln_amt3 := ln_amt3 +
1567: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1568: -- City Withheld
1569: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1570: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);
1571: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1572: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1573: ln_r_flag := 'Y';
1574: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then

Line 1581: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 530);

1577: ln_nr_flag := 'Y';
1578: end if;
1579:
1580: elsif p_tax_type = 'OPT' then
1581: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 530);
1582: -- Head Tax Subj Whable
1583: ln_amt4 := ln_amt4 +
1584: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1585: -- Head Tax Subj NWhable

Line 1593: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 540);

1589: ln_amt3 := ln_amt3 +
1590: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1591: -- Head Tax Withheld
1592: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1593: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 540);
1594: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1595: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1596: -- Head Tax Liability
1597: ln_r_er_tax_amt := ln_r_er_tax_amt +

Line 1601: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 550);

1597: ln_r_er_tax_amt := ln_r_er_tax_amt +
1598: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1599: ln_r_flag := 'Y';
1600: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1601: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 550);
1602: -- Head Tax Withheld
1603: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1604: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1605: -- Head Tax Liability

Line 1617: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);

1613: end if;
1614:
1615: -- School Jurisdiction code
1616: elsif length(p_jurisdiction) = 8 then
1617: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1618: if nvl(Pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1619: = nvl(p_resident_jurisdiction, 'R') then
1620:
1621: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);

Line 1621: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);

1617: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1618: if nvl(Pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1619: = nvl(p_resident_jurisdiction, 'R') then
1620:
1621: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1622: hr_utility.trace('ANK Gross val = ' ||
1623: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5);
1624: -- Gross Earnings
1625: ln_amt2 := ln_amt2 +

Line 1622: hr_utility.trace('ANK Gross val = ' ||

1618: if nvl(Pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1619: = nvl(p_resident_jurisdiction, 'R') then
1620:
1621: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1622: hr_utility.trace('ANK Gross val = ' ||
1623: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5);
1624: -- Gross Earnings
1625: ln_amt2 := ln_amt2 +
1626: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;

Line 1629: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 610);

1625: ln_amt2 := ln_amt2 +
1626: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1627:
1628: if p_tax_type = 'IT' then
1629: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 610);
1630: -- School Subj Whable
1631: ln_amt4 := ln_amt4 +
1632: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1633: -- School Subj NWhable

Line 1650: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);

1646: end if; /* End of Jurisdiction Check */
1647: end if; /* End of PL/SQL Table and Parameter JD check */
1648: end loop; /* End of PL/SQL Table Loop */
1649:
1650: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);
1651: hr_utility.trace('Amt1=' || ln_amt1);
1652: hr_utility.trace('Amt2=' || ln_amt2);
1653: hr_utility.trace('Amt3=' || ln_amt3);
1654: hr_utility.trace('Amt4=' || ln_amt4);

Line 1651: hr_utility.trace('Amt1=' || ln_amt1);

1647: end if; /* End of PL/SQL Table and Parameter JD check */
1648: end loop; /* End of PL/SQL Table Loop */
1649:
1650: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);
1651: hr_utility.trace('Amt1=' || ln_amt1);
1652: hr_utility.trace('Amt2=' || ln_amt2);
1653: hr_utility.trace('Amt3=' || ln_amt3);
1654: hr_utility.trace('Amt4=' || ln_amt4);
1655: hr_utility.trace('Amt5=' || ln_amt5);

Line 1652: hr_utility.trace('Amt2=' || ln_amt2);

1648: end loop; /* End of PL/SQL Table Loop */
1649:
1650: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);
1651: hr_utility.trace('Amt1=' || ln_amt1);
1652: hr_utility.trace('Amt2=' || ln_amt2);
1653: hr_utility.trace('Amt3=' || ln_amt3);
1654: hr_utility.trace('Amt4=' || ln_amt4);
1655: hr_utility.trace('Amt5=' || ln_amt5);
1656: hr_utility.trace('Amt6=' || ln_amt6);

Line 1653: hr_utility.trace('Amt3=' || ln_amt3);

1649:
1650: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);
1651: hr_utility.trace('Amt1=' || ln_amt1);
1652: hr_utility.trace('Amt2=' || ln_amt2);
1653: hr_utility.trace('Amt3=' || ln_amt3);
1654: hr_utility.trace('Amt4=' || ln_amt4);
1655: hr_utility.trace('Amt5=' || ln_amt5);
1656: hr_utility.trace('Amt6=' || ln_amt6);
1657: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);

Line 1654: hr_utility.trace('Amt4=' || ln_amt4);

1650: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);
1651: hr_utility.trace('Amt1=' || ln_amt1);
1652: hr_utility.trace('Amt2=' || ln_amt2);
1653: hr_utility.trace('Amt3=' || ln_amt3);
1654: hr_utility.trace('Amt4=' || ln_amt4);
1655: hr_utility.trace('Amt5=' || ln_amt5);
1656: hr_utility.trace('Amt6=' || ln_amt6);
1657: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);
1658:

Line 1655: hr_utility.trace('Amt5=' || ln_amt5);

1651: hr_utility.trace('Amt1=' || ln_amt1);
1652: hr_utility.trace('Amt2=' || ln_amt2);
1653: hr_utility.trace('Amt3=' || ln_amt3);
1654: hr_utility.trace('Amt4=' || ln_amt4);
1655: hr_utility.trace('Amt5=' || ln_amt5);
1656: hr_utility.trace('Amt6=' || ln_amt6);
1657: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);
1658:
1659: ln_gross_amt := ln_amt2;

Line 1656: hr_utility.trace('Amt6=' || ln_amt6);

1652: hr_utility.trace('Amt2=' || ln_amt2);
1653: hr_utility.trace('Amt3=' || ln_amt3);
1654: hr_utility.trace('Amt4=' || ln_amt4);
1655: hr_utility.trace('Amt5=' || ln_amt5);
1656: hr_utility.trace('Amt6=' || ln_amt6);
1657: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);
1658:
1659: ln_gross_amt := ln_amt2;
1660: if p_tax_type in ('IT', 'OPT', 'EIC') then

Line 1657: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);

1653: hr_utility.trace('Amt3=' || ln_amt3);
1654: hr_utility.trace('Amt4=' || ln_amt4);
1655: hr_utility.trace('Amt5=' || ln_amt5);
1656: hr_utility.trace('Amt6=' || ln_amt6);
1657: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);
1658:
1659: ln_gross_amt := ln_amt2;
1660: if p_tax_type in ('IT', 'OPT', 'EIC') then
1661: ln_subject_amt := ln_amt1 + ln_amt4 + ln_amt5;

Line 1674: hr_utility.trace('Gross=' || ln_gross_amt);

1670: p_jurisdiction <> '00-000-0000' then
1671: ln_r_er_tax_amt := 0;
1672: end if;
1673:
1674: hr_utility.trace('Gross=' || ln_gross_amt);
1675: hr_utility.trace('Subj=' || ln_subject_amt);
1676: hr_utility.trace('Taxable=' || ln_taxable_amt);
1677: hr_utility.trace('Withheld='|| ln_r_ee_tax_amt);
1678:

Line 1675: hr_utility.trace('Subj=' || ln_subject_amt);

1671: ln_r_er_tax_amt := 0;
1672: end if;
1673:
1674: hr_utility.trace('Gross=' || ln_gross_amt);
1675: hr_utility.trace('Subj=' || ln_subject_amt);
1676: hr_utility.trace('Taxable=' || ln_taxable_amt);
1677: hr_utility.trace('Withheld='|| ln_r_ee_tax_amt);
1678:
1679: /* Return the formatted values */

Line 1676: hr_utility.trace('Taxable=' || ln_taxable_amt);

1672: end if;
1673:
1674: hr_utility.trace('Gross=' || ln_gross_amt);
1675: hr_utility.trace('Subj=' || ln_subject_amt);
1676: hr_utility.trace('Taxable=' || ln_taxable_amt);
1677: hr_utility.trace('Withheld='|| ln_r_ee_tax_amt);
1678:
1679: /* Return the formatted values */
1680: select ltrim(rtrim(to_char(ln_gross_amt, decode(sign(ln_gross_amt),

Line 1677: hr_utility.trace('Withheld='|| ln_r_ee_tax_amt);

1673:
1674: hr_utility.trace('Gross=' || ln_gross_amt);
1675: hr_utility.trace('Subj=' || ln_subject_amt);
1676: hr_utility.trace('Taxable=' || ln_taxable_amt);
1677: hr_utility.trace('Withheld='|| ln_r_ee_tax_amt);
1678:
1679: /* Return the formatted values */
1680: select ltrim(rtrim(to_char(ln_gross_amt, decode(sign(ln_gross_amt),
1681: -1, '0000000000.00',

Line 1700: hr_utility.trace('Return Value=' || lv_return);

1696: -1, '0000000000.00',
1697: '00000000000.00'))))
1698: into lv_return from dual;
1699:
1700: hr_utility.trace('Return Value=' || lv_return);
1701: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 800);
1702: return(lv_return);
1703: END get_fls_tax_type_values;
1704:

Line 1701: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 800);

1697: '00000000000.00'))))
1698: into lv_return from dual;
1699:
1700: hr_utility.trace('Return Value=' || lv_return);
1701: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 800);
1702: return(lv_return);
1703: END get_fls_tax_type_values;
1704:
1705: --BEGIN

Line 1706: -- hr_utility.trace_on(null, 'FLSP');

1702: return(lv_return);
1703: END get_fls_tax_type_values;
1704:
1705: --BEGIN
1706: -- hr_utility.trace_on(null, 'FLSP');
1707:
1708: END pay_us_fls_reporting_pkg;