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

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

155: ln_payroll_id NUMBER;
156: ln_consolidation_set_id NUMBER;
157:
158: BEGIN
159: hr_utility.set_location(gv_package || '.get_payroll_action_info', 10);
160:
161: open c_payroll_action(p_payroll_action_id);
162: fetch c_payroll_action into
163: ld_start_date, ld_end_date, ln_business_group_id,

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

163: ld_start_date, ld_end_date, ln_business_group_id,
164: lv_report_qualifier, lv_report_type,
165: lv_report_category, lv_leg_parameter;
166: if c_payroll_action%notfound then
167: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
168: hr_utility.raise_error;
169: end if;
170: close c_payroll_action;
171: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);

Line 168: hr_utility.raise_error;

164: lv_report_qualifier, lv_report_type,
165: lv_report_category, lv_leg_parameter;
166: if c_payroll_action%notfound then
167: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
168: hr_utility.raise_error;
169: end if;
170: close c_payroll_action;
171: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
172:

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

167: hr_utility.set_location( gv_package || '.get_payroll_action_info',20);
168: hr_utility.raise_error;
169: end if;
170: close c_payroll_action;
171: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
172:
173: ln_payroll_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
174: 'TRANSFER_PAYROLL_ID'
175: ,'TRANSFER_CONSOLIDATION_SET_ID'

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

173: ln_payroll_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
174: 'TRANSFER_PAYROLL_ID'
175: ,'TRANSFER_CONSOLIDATION_SET_ID'
176: ,lv_leg_parameter)));
177: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);
178: ln_consolidation_set_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
179: 'TRANSFER_CONSOLIDATION_SET_ID'
180: ,'TRANSFER_TAX_UNIT_ID'
181: ,lv_leg_parameter)));

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

178: ln_consolidation_set_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
179: 'TRANSFER_CONSOLIDATION_SET_ID'
180: ,'TRANSFER_TAX_UNIT_ID'
181: ,lv_leg_parameter)));
182: hr_utility.set_location(gv_package || '.get_payroll_action_info', 50);
183: ln_tax_unit_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
184: 'TRANSFER_TAX_UNIT_ID'
185: ,null
186: ,lv_leg_parameter)));

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

184: 'TRANSFER_TAX_UNIT_ID'
185: ,null
186: ,lv_leg_parameter)));
187:
188: hr_utility.set_location(gv_package || '.get_payroll_action_info', 60);
189: p_start_date := ld_start_date;
190: p_end_date := ld_end_date;
191: p_report_qualifier := lv_report_qualifier;
192: p_report_type := lv_report_type;

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

195: p_tax_unit_id := ln_tax_unit_id;
196: p_payroll_id := ln_payroll_id;
197: p_consolidation_set_id := ln_consolidation_set_id;
198:
199: hr_utility.set_location(gv_package || '.get_payroll_action_info', 100);
200:
201: END get_payroll_action_info;
202:
203: /*******************************************************************

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

301: ln_payroll_id NUMBER;
302: ln_consolidation_set_id NUMBER;
303:
304: BEGIN
305: hr_utility.set_location(gv_package || '.range_code', 10);
306: get_payroll_action_info (
307: p_payroll_action_id
308: ,ld_start_date
309: ,ld_end_date

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

314: ,ln_tax_unit_id
315: ,ln_payroll_id
316: ,ln_consolidation_set_id);
317:
318: hr_utility.trace('ld_start_date = ' || ld_start_date);
319: hr_utility.trace('ld_end_date = ' || ld_end_date);
320: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
321: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
322: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);

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

315: ,ln_payroll_id
316: ,ln_consolidation_set_id);
317:
318: hr_utility.trace('ld_start_date = ' || ld_start_date);
319: hr_utility.trace('ld_end_date = ' || ld_end_date);
320: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
321: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
322: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
323: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);

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

316: ,ln_consolidation_set_id);
317:
318: hr_utility.trace('ld_start_date = ' || ld_start_date);
319: hr_utility.trace('ld_end_date = ' || ld_end_date);
320: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
321: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
322: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
323: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
324: hr_utility.trace('lv_report_type = ' || lv_report_type);

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

317:
318: hr_utility.trace('ld_start_date = ' || ld_start_date);
319: hr_utility.trace('ld_end_date = ' || ld_end_date);
320: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
321: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
322: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
323: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
324: hr_utility.trace('lv_report_type = ' || lv_report_type);
325: hr_utility.trace('lv_report_category = ' || lv_report_category);

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

318: hr_utility.trace('ld_start_date = ' || ld_start_date);
319: hr_utility.trace('ld_end_date = ' || ld_end_date);
320: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
321: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
322: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
323: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
324: hr_utility.trace('lv_report_type = ' || lv_report_type);
325: hr_utility.trace('lv_report_category = ' || lv_report_category);
326:

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

319: hr_utility.trace('ld_end_date = ' || ld_end_date);
320: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
321: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
322: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
323: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
324: hr_utility.trace('lv_report_type = ' || lv_report_type);
325: hr_utility.trace('lv_report_category = ' || lv_report_category);
326:
327: hr_utility.set_location(gv_package || '.range_code', 20);

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

320: hr_utility.trace('ln_business_group_id = ' || ln_business_group_id);
321: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
322: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
323: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
324: hr_utility.trace('lv_report_type = ' || lv_report_type);
325: hr_utility.trace('lv_report_category = ' || lv_report_category);
326:
327: hr_utility.set_location(gv_package || '.range_code', 20);
328:

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

321: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
322: hr_utility.trace('ln_payroll_id = ' || ln_payroll_id);
323: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
324: hr_utility.trace('lv_report_type = ' || lv_report_type);
325: hr_utility.trace('lv_report_category = ' || lv_report_category);
326:
327: hr_utility.set_location(gv_package || '.range_code', 20);
328:
329: if ln_tax_unit_id is not null then

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

323: hr_utility.trace('lv_report_qualifier = ' || lv_report_qualifier);
324: hr_utility.trace('lv_report_type = ' || lv_report_type);
325: hr_utility.trace('lv_report_category = ' || lv_report_category);
326:
327: hr_utility.set_location(gv_package || '.range_code', 20);
328:
329: if ln_tax_unit_id is not null then
330: hr_utility.set_location(gv_package || '.range_code', 30);
331: ln_error_count := ln_error_count +

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

326:
327: hr_utility.set_location(gv_package || '.range_code', 20);
328:
329: if ln_tax_unit_id is not null then
330: hr_utility.set_location(gv_package || '.range_code', 30);
331: ln_error_count := ln_error_count +
332: check_tax_unit_fein(
333: p_tax_unit_id => ln_tax_unit_id
334: ,p_payroll_action_id => p_payroll_action_id);

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

332: check_tax_unit_fein(
333: p_tax_unit_id => ln_tax_unit_id
334: ,p_payroll_action_id => p_payroll_action_id);
335: else
336: hr_utility.set_location(gv_package || '.range_code', 40);
337: open c_arch_tax_unit( ln_business_group_id
338: ,ld_start_date
339: ,ld_end_date);
340: loop

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

343: if c_arch_tax_unit%notfound then
344: exit;
345: end if;
346:
347: hr_utility.set_location(gv_package || '.range_code', 50);
348: hr_utility.trace('ln_arch_tax_unit_id = ' || ln_arch_tax_unit_id);
349: hr_utility.trace('lv_arch_tax_unit_fein = ' || lv_arch_tax_unit_fein);
350: hr_utility.set_location(gv_package || '.range_code', 60);
351:

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

344: exit;
345: end if;
346:
347: hr_utility.set_location(gv_package || '.range_code', 50);
348: hr_utility.trace('ln_arch_tax_unit_id = ' || ln_arch_tax_unit_id);
349: hr_utility.trace('lv_arch_tax_unit_fein = ' || lv_arch_tax_unit_fein);
350: hr_utility.set_location(gv_package || '.range_code', 60);
351:
352: ln_error_count := ln_error_count +

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

345: end if;
346:
347: hr_utility.set_location(gv_package || '.range_code', 50);
348: hr_utility.trace('ln_arch_tax_unit_id = ' || ln_arch_tax_unit_id);
349: hr_utility.trace('lv_arch_tax_unit_fein = ' || lv_arch_tax_unit_fein);
350: hr_utility.set_location(gv_package || '.range_code', 60);
351:
352: ln_error_count := ln_error_count +
353: check_tax_unit_fein(

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

346:
347: hr_utility.set_location(gv_package || '.range_code', 50);
348: hr_utility.trace('ln_arch_tax_unit_id = ' || ln_arch_tax_unit_id);
349: hr_utility.trace('lv_arch_tax_unit_fein = ' || lv_arch_tax_unit_fein);
350: hr_utility.set_location(gv_package || '.range_code', 60);
351:
352: ln_error_count := ln_error_count +
353: check_tax_unit_fein(
354: p_tax_unit_id => ln_arch_tax_unit_id

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

355: ,p_payroll_action_id => p_payroll_action_id
356: ,p_tax_unit_fein => lv_arch_tax_unit_fein);
357: end loop;
358: close c_arch_tax_unit;
359: hr_utility.set_location(gv_package || '.range_code', 70);
360: end if;
361:
362: hr_utility.trace('Error Count = ' || ln_error_count);
363: if ln_error_count > 0 then

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

358: close c_arch_tax_unit;
359: hr_utility.set_location(gv_package || '.range_code', 70);
360: end if;
361:
362: hr_utility.trace('Error Count = ' || ln_error_count);
363: if ln_error_count > 0 then
364: lv_error_message := 'Please check the messages at the Payroll Action Level' ||
365: 'to find out the GRE''s with invalid FEIN.';
366:

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

363: if ln_error_count > 0 then
364: lv_error_message := 'Please check the messages at the Payroll Action Level' ||
365: 'to find out the GRE''s with invalid FEIN.';
366:
367: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
368: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
369: commit;
370: hr_utility.raise_error;
371: end if;

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

364: lv_error_message := 'Please check the messages at the Payroll Action Level' ||
365: 'to find out the GRE''s with invalid FEIN.';
366:
367: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
368: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
369: commit;
370: hr_utility.raise_error;
371: end if;
372:

Line 370: hr_utility.raise_error;

366:
367: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
368: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
369: commit;
370: hr_utility.raise_error;
371: end if;
372:
373: hr_utility.set_location(gv_package || '.range_code', 60);
374:

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

369: commit;
370: hr_utility.raise_error;
371: end if;
372:
373: hr_utility.set_location(gv_package || '.range_code', 60);
374:
375: lv_sql_string :=
376: 'select distinct paf.person_id
377: from pay_payroll_actions ppa,

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

427: ,ppa.legislative_parameters)))
428: order by paf.person_id';
429:
430: p_sql_string := lv_sql_string;
431: hr_utility.set_location(gv_package || '.range_code', 50);
432:
433: END range_cursor;
434:
435: /********************************************************

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

522:
523: ln_locking_action_id NUMBER;
524:
525: BEGIN
526: hr_utility.set_location(gv_package || '.action_creation', 10);
527: get_payroll_action_info (
528: p_payroll_action_id
529: ,ld_start_date
530: ,ld_end_date

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

535: ,ln_tax_unit_id
536: ,ln_payroll_id
537: ,ln_consolidation_set_id);
538:
539: hr_utility.set_location(gv_package || '.action_creation', 20);
540: open c_get_fls_emp( ln_tax_unit_id
541: ,ln_payroll_id
542: ,ln_consolidation_set_id
543: ,ln_business_group_id

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

545: ,ld_end_date
546: ,p_start_person
547: ,p_end_person);
548: loop
549: hr_utility.set_location(gv_package || '.action_creation', 30);
550: fetch c_get_fls_emp into ln_assignment_id, ld_effective_date,
551: ln_emp_tax_unit_id, ln_assignment_action_id;
552: if c_get_fls_emp%notfound then
553: hr_utility.set_location(gv_package || '.action_creation', 40);

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

549: hr_utility.set_location(gv_package || '.action_creation', 30);
550: fetch c_get_fls_emp into ln_assignment_id, ld_effective_date,
551: ln_emp_tax_unit_id, ln_assignment_action_id;
552: if c_get_fls_emp%notfound then
553: hr_utility.set_location(gv_package || '.action_creation', 40);
554: exit;
555: end if;
556:
557: hr_utility.set_location(gv_package || '.action_creation', 50);

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

553: hr_utility.set_location(gv_package || '.action_creation', 40);
554: exit;
555: end if;
556:
557: hr_utility.set_location(gv_package || '.action_creation', 50);
558: select pay_assignment_actions_s.nextval
559: into ln_locking_action_id
560: from dual;
561:

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

561:
562: -- insert into pay_assignment_actions.
563: hr_nonrun_asact.insact(ln_locking_action_id, ln_assignment_id,
564: p_payroll_action_id, p_chunk, ln_emp_tax_unit_id);
565: hr_utility.set_location(gv_package || '.action_creation', 60);
566:
567: -- insert an interlock to this action
568: hr_nonrun_asact.insint(ln_locking_action_id, ln_assignment_action_id);
569:

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

570: update pay_assignment_actions paa
571: set paa.serial_number = ln_assignment_action_id
572: where paa.assignment_action_id = ln_locking_action_id;
573:
574: hr_utility.set_location(gv_package || '.action_creation', 60);
575: end loop;
576: close c_get_fls_emp;
577:
578: hr_utility.set_location(gv_package || '.action_creation', 60);

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

574: hr_utility.set_location(gv_package || '.action_creation', 60);
575: end loop;
576: close c_get_fls_emp;
577:
578: hr_utility.set_location(gv_package || '.action_creation', 60);
579: END action_creation;
580:
581:
582: /*******************************************************************

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

667: lv_return VARCHAR2(1) := 'N';
668:
669: BEGIN
670:
671: hr_utility.set_location(gv_package || '.get_tax_exists', 10);
672: hr_utility.trace('Effective Date = ' || p_effective_date);
673: hr_utility.trace('Tax Type = ' || p_tax_type);
674: hr_utility.trace('JD = ' || p_jurisdiction_code);
675:

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

668:
669: BEGIN
670:
671: hr_utility.set_location(gv_package || '.get_tax_exists', 10);
672: hr_utility.trace('Effective Date = ' || p_effective_date);
673: hr_utility.trace('Tax Type = ' || p_tax_type);
674: hr_utility.trace('JD = ' || p_jurisdiction_code);
675:
676: ld_effective_date := to_date(p_effective_date, 'MM/DD/YYYY');

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

669: BEGIN
670:
671: hr_utility.set_location(gv_package || '.get_tax_exists', 10);
672: hr_utility.trace('Effective Date = ' || p_effective_date);
673: hr_utility.trace('Tax Type = ' || p_tax_type);
674: hr_utility.trace('JD = ' || p_jurisdiction_code);
675:
676: ld_effective_date := to_date(p_effective_date, 'MM/DD/YYYY');
677: hr_utility.set_location(gv_package || '.get_tax_exists', 20);

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

670:
671: hr_utility.set_location(gv_package || '.get_tax_exists', 10);
672: hr_utility.trace('Effective Date = ' || p_effective_date);
673: hr_utility.trace('Tax Type = ' || p_tax_type);
674: hr_utility.trace('JD = ' || p_jurisdiction_code);
675:
676: ld_effective_date := to_date(p_effective_date, 'MM/DD/YYYY');
677: hr_utility.set_location(gv_package || '.get_tax_exists', 20);
678:

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

673: hr_utility.trace('Tax Type = ' || p_tax_type);
674: hr_utility.trace('JD = ' || p_jurisdiction_code);
675:
676: ld_effective_date := to_date(p_effective_date, 'MM/DD/YYYY');
677: hr_utility.set_location(gv_package || '.get_tax_exists', 20);
678:
679: /* If p_tax_type_resp is null, the function is called from
680: Wages Cursor so check if there is EE or ER taxes.
681: If p_tax_type_resp is not null, the function is called

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

684: */
685:
686: -- Federal
687: if p_jurisdiction_code = '00-000-0000' then
688: hr_utility.set_location(gv_package || '.get_tax_exists', 30);
689: if p_tax_type = 'UI' and nvl(p_tax_type_resp, 'ER') = 'ER' then
690: lv_return := 'Y';
691: elsif p_tax_type in ('EIC', 'HI', 'IT', 'OASDI') then
692: lv_return := 'Y';

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

693: end if;
694: -- State
695: elsif length(p_jurisdiction_code) = 11 and
696: substr(p_jurisdiction_code,3) = '-000-0000' then
697: hr_utility.set_location(gv_package || '.get_tax_exists', 40);
698: -- MA has Health Insurance report under SDI so if SDI
699: -- is passed return N and Y for HI
700: if p_jurisdiction_code = '22-000-0000' and
701: p_tax_type = 'HI' and p_tax_type_resp is null then

Line 719: hr_utility.set_location(gv_package || '.get_tax_exists ', 42);

715: ,lv_sui_er_exists;
716: close c_state_tax_exists;
717: /* 9164356 start */
718: elsif p_tax_type = 'SDI1' then
719: hr_utility.set_location(gv_package || '.get_tax_exists ', 42);
720: open c_sdi1_state_tax_exists(p_jurisdiction_code, ld_effective_date);
721: fetch c_sdi1_state_tax_exists into lv_sdi1_ee_exists;
722: if c_sdi1_state_tax_exists%notfound then
723: lv_sdi1_ee_exists := 'N';

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

720: open c_sdi1_state_tax_exists(p_jurisdiction_code, ld_effective_date);
721: fetch c_sdi1_state_tax_exists into lv_sdi1_ee_exists;
722: if c_sdi1_state_tax_exists%notfound then
723: lv_sdi1_ee_exists := 'N';
724: hr_utility.set_location(gv_package || '.get_tax_exists', 44);
725: end if;
726: hr_utility.set_location(gv_package || '.get_tax_exists | SDI1 flag:'|| lv_sdi1_ee_exists, 46);
727: close c_sdi1_state_tax_exists;
728: /* 9164356 end */

Line 726: hr_utility.set_location(gv_package || '.get_tax_exists | SDI1 flag:'|| lv_sdi1_ee_exists, 46);

722: if c_sdi1_state_tax_exists%notfound then
723: lv_sdi1_ee_exists := 'N';
724: hr_utility.set_location(gv_package || '.get_tax_exists', 44);
725: end if;
726: hr_utility.set_location(gv_package || '.get_tax_exists | SDI1 flag:'|| lv_sdi1_ee_exists, 46);
727: close c_sdi1_state_tax_exists;
728: /* 9164356 end */
729: end if;
730: -- County

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

730: -- County
731: elsif substr(p_jurisdiction_code,7,5) = '-0000' and
732: substr(p_jurisdiction_code,3,4) <> '-000' then
733:
734: hr_utility.set_location(gv_package || '.get_tax_exists', 50);
735: if p_tax_type in ('OPT', 'IT') then
736: open c_county_tax_exists(p_jurisdiction_code, ld_effective_date);
737: fetch c_county_tax_exists into lv_it_exists
738: ,lv_head_tax_exists

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

742: -- City
743: elsif length(p_jurisdiction_code) = 11 and
744: substr(p_jurisdiction_code,3) <> '-000-0000' then
745:
746: hr_utility.set_location(gv_package || '.get_tax_exists', 60);
747: if p_tax_type in ('OPT', 'IT') then
748: open c_city_tax_exists(p_jurisdiction_code, ld_effective_date);
749: fetch c_city_tax_exists into lv_it_exists
750: ,lv_head_tax_exists

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

754: end if;
755:
756: if length(p_jurisdiction_code) = 8 and
757: p_tax_type in ('IT') then
758: hr_utility.set_location(gv_package || '.get_tax_exists', 70);
759: lv_return := 'Y';
760: elsif p_jurisdiction_code <> '00-000-0000' then
761: hr_utility.set_location(gv_package || '.get_tax_exists', 80);
762: if p_tax_type = 'IT' then

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

757: p_tax_type in ('IT') then
758: hr_utility.set_location(gv_package || '.get_tax_exists', 70);
759: lv_return := 'Y';
760: elsif p_jurisdiction_code <> '00-000-0000' then
761: hr_utility.set_location(gv_package || '.get_tax_exists', 80);
762: if p_tax_type = 'IT' then
763: lv_return := lv_it_exists;
764: elsif ((p_tax_type = 'SDI') or
765: (p_jurisdiction_code = '22-000-0000' and

Line 798: hr_utility.set_location(gv_package || '.get_tax_exists', 82);

794: elsif p_tax_type = 'OPT' then
795: lv_return := lv_head_tax_exists;
796: /*9164356 start*/
797: elsif (p_tax_type = 'SDI1') then
798: hr_utility.set_location(gv_package || '.get_tax_exists', 82);
799: if (p_tax_type_resp is null or (p_tax_type_resp = 'EE')) then
800: if lv_sdi1_ee_exists = 'Y' then
801: hr_utility.set_location(gv_package || '.get_tax_exists', 84);
802: lv_return := 'Y';

Line 801: hr_utility.set_location(gv_package || '.get_tax_exists', 84);

797: elsif (p_tax_type = 'SDI1') then
798: hr_utility.set_location(gv_package || '.get_tax_exists', 82);
799: if (p_tax_type_resp is null or (p_tax_type_resp = 'EE')) then
800: if lv_sdi1_ee_exists = 'Y' then
801: hr_utility.set_location(gv_package || '.get_tax_exists', 84);
802: lv_return := 'Y';
803: end if;
804: end if;
805: /*9164356 end*/

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

805: /*9164356 end*/
806: end if;
807: end if;
808:
809: hr_utility.set_location(gv_package || '.get_tax_exists', 90);
810: hr_utility.trace('Returned Value = ' || lv_return);
811: hr_utility.set_location(gv_package || '.get_tax_exists', 100);
812:
813: return(lv_return);

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

806: end if;
807: end if;
808:
809: hr_utility.set_location(gv_package || '.get_tax_exists', 90);
810: hr_utility.trace('Returned Value = ' || lv_return);
811: hr_utility.set_location(gv_package || '.get_tax_exists', 100);
812:
813: return(lv_return);
814:

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

807: end if;
808:
809: hr_utility.set_location(gv_package || '.get_tax_exists', 90);
810: hr_utility.trace('Returned Value = ' || lv_return);
811: hr_utility.set_location(gv_package || '.get_tax_exists', 100);
812:
813: return(lv_return);
814:
815: END get_tax_exists;

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

828: lv_jurisdiction_name VARCHAR2(200);
829:
830: BEGIN
831:
832: hr_utility.set_location(gv_package || '.get_jurisdiction_name', 10);
833: hr_utility.trace('JD =' || p_jurisdiction_code);
834:
835: if p_jurisdiction_code = '00-000-0000' then
836: lv_jurisdiction_name := 'Federal';

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

829:
830: BEGIN
831:
832: hr_utility.set_location(gv_package || '.get_jurisdiction_name', 10);
833: hr_utility.trace('JD =' || p_jurisdiction_code);
834:
835: if p_jurisdiction_code = '00-000-0000' then
836: lv_jurisdiction_name := 'Federal';
837: else

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

943: ld_effective_date DATE;
944:
945: BEGIN
946:
947: hr_utility.set_location(gv_package || '.get_fls_agency_code', 10);
948: hr_utility.trace('JD =' || p_jurisdiction_code);
949: hr_utility.trace('Eff Date =' || p_effective_date);
950:
951: ld_effective_date := to_date(p_effective_date, 'mm/dd/yyyy');

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

944:
945: BEGIN
946:
947: hr_utility.set_location(gv_package || '.get_fls_agency_code', 10);
948: hr_utility.trace('JD =' || p_jurisdiction_code);
949: hr_utility.trace('Eff Date =' || p_effective_date);
950:
951: ld_effective_date := to_date(p_effective_date, 'mm/dd/yyyy');
952:

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

945: BEGIN
946:
947: hr_utility.set_location(gv_package || '.get_fls_agency_code', 10);
948: hr_utility.trace('JD =' || p_jurisdiction_code);
949: hr_utility.trace('Eff Date =' || p_effective_date);
950:
951: ld_effective_date := to_date(p_effective_date, 'mm/dd/yyyy');
952:
953: hr_utility.set_location(gv_package || '.get_fls_agency_code', 20);

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

949: hr_utility.trace('Eff Date =' || p_effective_date);
950:
951: ld_effective_date := to_date(p_effective_date, 'mm/dd/yyyy');
952:
953: hr_utility.set_location(gv_package || '.get_fls_agency_code', 20);
954:
955: -- Federal
956: if p_jurisdiction_code = '00-000-0000' then
957: hr_utility.set_location(gv_package || '.get_fls_agency_code', 30);

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

953: hr_utility.set_location(gv_package || '.get_fls_agency_code', 20);
954:
955: -- Federal
956: if p_jurisdiction_code = '00-000-0000' then
957: hr_utility.set_location(gv_package || '.get_fls_agency_code', 30);
958: open c_federal_agency_code(ld_effective_date);
959: fetch c_federal_agency_code into lv_agency_code,
960: lv_futa_agency_code;
961: close c_federal_agency_code;

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

965: end if;
966:
967: -- State
968: elsif substr(p_jurisdiction_code,3) = '-000-0000' then
969: hr_utility.set_location(gv_package || '.get_fls_agency_code', 40);
970: open c_state_agency_code(p_jurisdiction_code, ld_effective_date);
971: fetch c_state_agency_code into lv_agency_code;
972: close c_state_agency_code;
973: -- County

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

972: close c_state_agency_code;
973: -- County
974: elsif substr(p_jurisdiction_code,7,5) = '-0000' and
975: substr(p_jurisdiction_code,3,4) <> '-000' then
976: hr_utility.set_location(gv_package || '.get_fls_agency_code', 50);
977: open c_county_agency_code(p_jurisdiction_code, ld_effective_date);
978: fetch c_county_agency_code into lv_agency_code,
979: lv_opt_agency_code;
980: close c_county_agency_code;

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

989:
990: -- City
991: elsif length(p_jurisdiction_code) = 11 and
992: substr(p_jurisdiction_code,3) <> '-000-0000' then
993: hr_utility.set_location(gv_package || '.get_fls_agency_code', 60);
994: open c_city_agency_code(p_jurisdiction_code, ld_effective_date);
995: fetch c_city_agency_code into lv_agency_code, lv_opt_agency_code;
996: close c_city_agency_code;
997:

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

1004: end if;
1005:
1006: -- School
1007: elsif length(p_jurisdiction_code) = 8 then
1008: hr_utility.set_location(gv_package || '.get_fls_agency_code', 70);
1009: open c_school_agency_code( p_jurisdiction_code
1010: ,p_resident_jurisdiction
1011: ,ld_effective_date);
1012: fetch c_school_agency_code into lv_agency_code;

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

1011: ,ld_effective_date);
1012: fetch c_school_agency_code into lv_agency_code;
1013: close c_school_agency_code;
1014: end if;
1015: hr_utility.set_location(gv_package || '.get_fls_agency_code', 100);
1016:
1017: return (lv_agency_code);
1018:
1019: END get_fls_agency_code;

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

1143:
1144: i_count NUMBER := 0;
1145:
1146: BEGIN
1147: hr_utility.set_location(gv_package || '.get_fls_jd_values', 10);
1148:
1149: /* Reset the PL/SQL tables */
1150: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1151: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..

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

1188: end loop;
1189: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1190: end if;
1191:
1192: hr_utility.trace('Payroll Action ID=' || p_payroll_action_id);
1193: hr_utility.trace('Tax Unit ID=' || p_tax_unit_id);
1194: for action_rec in c_action_info(p_tax_unit_id, p_payroll_action_id)
1195: loop
1196: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);

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

1189: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1190: end if;
1191:
1192: hr_utility.trace('Payroll Action ID=' || p_payroll_action_id);
1193: hr_utility.trace('Tax Unit ID=' || p_tax_unit_id);
1194: for action_rec in c_action_info(p_tax_unit_id, p_payroll_action_id)
1195: loop
1196: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);
1197: /* Commented out because of DB issue. Bug 1822467 */

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

1192: hr_utility.trace('Payroll Action ID=' || p_payroll_action_id);
1193: hr_utility.trace('Tax Unit ID=' || p_tax_unit_id);
1194: for action_rec in c_action_info(p_tax_unit_id, p_payroll_action_id)
1195: loop
1196: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);
1197: /* Commented out because of DB issue. Bug 1822467 */
1198: --pay_us_fls_reporting_pkg.ltr_action_info(i_count) := action_rec;
1199: pay_us_fls_reporting_pkg.ltr_action_info(i_count).jurisdiction_code
1200: := action_rec.jurisdiction_code;

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

1267: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information33 --Added for Bug#9872952
1268: := action_rec.action_information33;
1269:
1270: i_count := i_count + 1;
1271: hr_utility.set_location(gv_package || '.get_fls_jd_values', 30);
1272: end loop;
1273:
1274: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1275: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then

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

1270: i_count := i_count + 1;
1271: hr_utility.set_location(gv_package || '.get_fls_jd_values', 30);
1272: end loop;
1273:
1274: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1275: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1276: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1277: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1278: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);

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

1274: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1275: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1276: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1277: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1278: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1279: end loop;
1280: end if;
1281: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1282:

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

1277: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1278: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1279: end loop;
1280: end if;
1281: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1282:
1283: hr_utility.set_location(gv_package || '.get_fls_jd_values', 100);
1284: return (1);
1285: END get_fls_jd_values;

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

1279: end loop;
1280: end if;
1281: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1282:
1283: hr_utility.set_location(gv_package || '.get_fls_jd_values', 100);
1284: return (1);
1285: END get_fls_jd_values;
1286:
1287: /*******************************************************************

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

1323:
1324: lv_return VARCHAR2(200);
1325:
1326: BEGIN
1327: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);
1328: hr_utility.trace('Tax Type Code=' || p_tax_type);
1329: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1330: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1331:

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

1324: lv_return VARCHAR2(200);
1325:
1326: BEGIN
1327: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);
1328: hr_utility.trace('Tax Type Code=' || p_tax_type);
1329: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1330: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1331:
1332: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..

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

1325:
1326: BEGIN
1327: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);
1328: hr_utility.trace('Tax Type Code=' || p_tax_type);
1329: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1330: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1331:
1332: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1333: pay_us_fls_reporting_pkg.ltr_action_info.last loop

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

1326: BEGIN
1327: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);
1328: hr_utility.trace('Tax Type Code=' || p_tax_type);
1329: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1330: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1331:
1332: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1333: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1334:

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

1331:
1332: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1333: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1334:
1335: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1336: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1337:
1338: hr_utility.trace('PL/SQL Action30 is= ' ||
1339: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30);

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

1334:
1335: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1336: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1337:
1338: hr_utility.trace('PL/SQL Action30 is= ' ||
1339: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30);
1340:
1341: hr_utility.trace('PL/SQL p_jurisdiction is= ' ||
1342: p_jurisdiction);

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

1337:
1338: hr_utility.trace('PL/SQL Action30 is= ' ||
1339: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30);
1340:
1341: hr_utility.trace('PL/SQL p_jurisdiction is= ' ||
1342: p_jurisdiction);
1343:
1344: hr_utility.trace('PL/SQL p_resident_jurisdiction is = ' ||
1345: nvl(p_resident_jurisdiction,'NOT ARCHIVED'));

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

1340:
1341: hr_utility.trace('PL/SQL p_jurisdiction is= ' ||
1342: p_jurisdiction);
1343:
1344: hr_utility.trace('PL/SQL p_resident_jurisdiction is = ' ||
1345: nvl(p_resident_jurisdiction,'NOT ARCHIVED'));
1346:
1347: if pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code = p_jurisdiction then
1348:

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

1345: nvl(p_resident_jurisdiction,'NOT ARCHIVED'));
1346:
1347: if pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code = p_jurisdiction then
1348:
1349: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 20);
1350:
1351: if p_jurisdiction = '00-000-0000' then
1352: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 30);
1353:

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

1348:
1349: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 20);
1350:
1351: if p_jurisdiction = '00-000-0000' then
1352: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 30);
1353:
1354: if p_tax_type <> 'IT' THEN -- If clause added for Bug#9872952
1355: -- Regular Earnings
1356: ln_amt1 := ln_amt1 +

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

1367: if p_tax_type = 'IT' then
1368: -- Added for Bug#9872952
1369: /*Brought in the Complete calculation for FIT so that the values are affected
1370: only for FIT Wages based on the FIT Exempt from Wage Accumulation Flag*/
1371: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 40);
1372: -- Regular Earnings
1373: ln_amt1 := ln_amt1 +
1374: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31;
1375: -- Gross Earnings

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

1392: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1393: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1394:
1395: elsif p_tax_type = 'UI' then
1396: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 50);
1397: -- Supp Earning for FUTA
1398: ln_amt4 := ln_amt4 +
1399: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1400: -- Pre Tax Deduction for FUTA

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

1407: ln_r_er_tax_amt := ln_r_er_tax_amt +
1408: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22;
1409:
1410: elsif p_tax_type = 'OASDI' then
1411: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 60);
1412: -- Supp Earning for SS
1413: ln_amt4 := ln_amt4 +
1414: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1415: -- Pre Tax Deduction for SS

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

1424: -- SS ER Liability
1425: ln_r_er_tax_amt := ln_r_er_tax_amt +
1426: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1427: elsif p_tax_type = 'HI' then
1428: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 70);
1429: -- Supp Earning for Medicare
1430: ln_amt4 := ln_amt4 +
1431: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1432: -- Pre Tax Deduction for Medicare

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

1441: -- Medicare ER Liability
1442: ln_r_er_tax_amt := ln_r_er_tax_amt +
1443: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1444: elsif p_tax_type = 'EIC' then
1445: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 80);
1446: ln_amt1 := 0;
1447: ln_amt2 := 0;
1448: ln_amt3 := 0;
1449: -- EIC Advance

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

1455: -- State Jurisdiction code
1456: elsif substr(p_jurisdiction,3) = '-000-0000' and
1457: p_jurisdiction <> '00-000-0000' then
1458:
1459: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 110);
1460:
1461: if p_tax_type = 'IT' then
1462: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 120);
1463: --SIT Gross

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

1458:
1459: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 110);
1460:
1461: if p_tax_type = 'IT' then
1462: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 120);
1463: --SIT Gross
1464: ln_amt2 := ln_amt2 +
1465: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1466: -- SIT Subj Whable

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

1476: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1477: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1478:
1479: elsif p_tax_type = 'UI' then
1480: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 130);
1481: /* Always report the ER component if it is there. -- 4335410
1482: In case ER is null report EE.
1483: SUI and SDI ER Liability is always passed as 0.
1484: Doing an if to get EE or ER Wages instead on NVL as the PL/SQL table will

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

1485: have a Zero value if there is a NULL in the table. */
1486:
1487: -- SUI EE Gross, SUI ER Gross
1488: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29,0) <> 0 then
1489: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 140);
1490: ln_amt2 := ln_amt2 +
1491: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29;
1492: else
1493: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 150);

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

1489: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 140);
1490: ln_amt2 := ln_amt2 +
1491: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29;
1492: else
1493: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 150);
1494: ln_amt2 := ln_amt2 +
1495: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28;
1496: end if;
1497:

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

1496: end if;
1497:
1498: -- nvl(SUI EE Subj Whable, SUI ER Subj Whable)
1499: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19,0) <> 0 then
1500: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 160);
1501: ln_amt4 := ln_amt4 +
1502: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1503: else
1504: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 170);

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

1500: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 160);
1501: ln_amt4 := ln_amt4 +
1502: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1503: else
1504: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 170);
1505: ln_amt4 := ln_amt4 +
1506: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1507: end if;
1508:

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

1507: end if;
1508:
1509: -- nvl(SUI EE Pre Tax Redns, SUI ER Pre Tax Redns)
1510: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20,0) <> 0 then
1511: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 180);
1512: ln_amt3 := ln_amt3 +
1513: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1514: else
1515: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 190);

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

1511: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 180);
1512: ln_amt3 := ln_amt3 +
1513: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1514: else
1515: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 190);
1516: ln_amt3 := ln_amt3 +
1517: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16;
1518: end if;
1519:

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

1518: end if;
1519:
1520: -- nvl(SUI EE Taxable, SUI ER Taxable)
1521: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18,0) <> 0 then
1522: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 200);
1523: ln_amt7 := ln_amt7 +
1524: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1525: else
1526: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 210);

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

1522: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 200);
1523: ln_amt7 := ln_amt7 +
1524: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1525: else
1526: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 210);
1527: ln_amt7 := ln_amt7 +
1528: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1529: end if;
1530:

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

1535: ln_r_er_tax_amt := ln_r_er_tax_amt +
1536: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1537:
1538: elsif p_tax_type in ('SDI','SDI1','HI') then -- Added 'SDI1' bug 9164356
1539: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 220);
1540: /******************************************************
1541: Checking for SDI and HI because for MA the tax_type
1542: will be HI. The HI balances are stored in the same SDI
1543: balances as all other states.

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

1548: SDI ER Liability is always passed as 0
1549: *******************************************************/
1550: --SDI EE Gross, SDI ER Gross
1551: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27,0) <> 0 then
1552: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 230);
1553: ln_amt2 := ln_amt2 +
1554: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27;
1555: else
1556: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 240);

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

1552: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 230);
1553: ln_amt2 := ln_amt2 +
1554: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27;
1555: else
1556: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 240);
1557: ln_amt2 := ln_amt2 +
1558: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26;
1559: end if;
1560:

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

1559: end if;
1560:
1561: -- nvl(SDI EE Subj Whable, SDI ER Subj Whable)
1562: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11,0) <> 0 then
1563: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 250);
1564: ln_amt4 := ln_amt4 +
1565: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1566: else
1567: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 260);

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

1563: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 250);
1564: ln_amt4 := ln_amt4 +
1565: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1566: else
1567: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 260);
1568: ln_amt4 := ln_amt4 +
1569: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1570: end if;
1571:

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

1570: end if;
1571:
1572: -- nvl(SDI EE Pre Tax Redns, SDI ER Pre Tax Redns)
1573: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12,0) <> 0 then
1574: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 270);
1575: ln_amt3 := ln_amt3 +
1576: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1577: else
1578: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 280);

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

1574: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 270);
1575: ln_amt3 := ln_amt3 +
1576: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1577: else
1578: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 280);
1579: ln_amt3 := ln_amt3 +
1580: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1581: end if;
1582:

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

1581: end if;
1582:
1583: -- nvl(SDI EE Taxable, SDI ER Taxable)
1584: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10,0) <> 0 then
1585: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 290);
1586: ln_amt7 := ln_amt7 +
1587: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10;
1588: else
1589: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 300);

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

1585: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 290);
1586: ln_amt7 := ln_amt7 +
1587: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10;
1588: else
1589: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 300);
1590: ln_amt7 := ln_amt7 +
1591: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1592: end if;
1593:

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

1615: ln_r_er_tax_amt := ln_r_er_tax_amt +
1616: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1617: end if;
1618: elsif p_tax_type = 'WC' then
1619: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 350);
1620: null;
1621: /*
1622: -- WC Withheld
1623: ln_r_ee_tax_amt := ln_r_ee_tax_amt +

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

1628: exit;
1629: -- County Jurisdiction code
1630: elsif substr(p_jurisdiction,7) = '-0000' and
1631: substr(p_jurisdiction,3,4) <> '-000'then
1632: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 400);
1633: -- Gross Earnings
1634: ln_amt2 := ln_amt2 +
1635: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1636:

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

1634: ln_amt2 := ln_amt2 +
1635: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1636:
1637: if p_tax_type = 'IT' then
1638: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 410);
1639: -- County Subj Whable
1640: ln_amt4 := ln_amt4 +
1641: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1642: -- County Subj NWhable

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

1647: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1648: -- County Withheld
1649: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1650: = 'R' then
1651: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);
1652: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1653: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1654: ln_r_flag := 'Y';
1655: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')

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

1653: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1654: ln_r_flag := 'Y';
1655: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1656: = 'NR' then
1657: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 430);
1658: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1659: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1660: ln_nr_flag := 'Y';
1661: end if;

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

1660: ln_nr_flag := 'Y';
1661: end if;
1662:
1663: elsif p_tax_type = 'OPT' then
1664: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 440);
1665: -- Head Tax Subj Whable
1666: ln_amt4 := ln_amt4 +
1667: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1668: -- Head Tax Subj NWhable

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

1673: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1674:
1675: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1676: = 'R' then
1677: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 450);
1678: -- Head Tax Withheld
1679: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1680: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1681: -- Head Tax Liability

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

1683: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1684: ln_r_flag := 'Y';
1685: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1686: = 'NR' then
1687: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 460);
1688: -- Head Tax Withheld
1689: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1690: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1691: -- Head Tax Liability

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

1701: -- City Jurisdiction code
1702: elsif length(p_jurisdiction) = 11 and
1703: substr(p_jurisdiction,3) <> '-000-0000'then
1704: -- Gross Earnings
1705: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 500);
1706: ln_amt2 := ln_amt2 +
1707: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1708:
1709: if p_tax_type = 'IT' then

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

1706: ln_amt2 := ln_amt2 +
1707: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1708:
1709: if p_tax_type = 'IT' then
1710: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 510);
1711: -- City Subj Whable
1712: ln_amt4 := ln_amt4 +
1713: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1714: -- City Subj NWhable

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

1718: ln_amt3 := ln_amt3 +
1719: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1720: -- City Withheld
1721: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1722: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);
1723: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1724: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1725: ln_r_flag := 'Y';
1726: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then

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

1729: ln_nr_flag := 'Y';
1730: end if;
1731:
1732: elsif p_tax_type = 'OPT' then
1733: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 530);
1734: -- Head Tax Subj Whable
1735: ln_amt4 := ln_amt4 +
1736: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1737: -- Head Tax Subj NWhable

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

1741: ln_amt3 := ln_amt3 +
1742: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1743: -- Head Tax Withheld
1744: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1745: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 540);
1746: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1747: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1748: -- Head Tax Liability
1749: ln_r_er_tax_amt := ln_r_er_tax_amt +

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

1749: ln_r_er_tax_amt := ln_r_er_tax_amt +
1750: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1751: ln_r_flag := 'Y';
1752: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1753: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 550);
1754: -- Head Tax Withheld
1755: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1756: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1757: -- Head Tax Liability

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

1765: end if;
1766:
1767: -- School Jurisdiction code
1768: elsif length(p_jurisdiction) = 8 then
1769: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1770: if nvl(Pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1771: = nvl(p_resident_jurisdiction, 'R') then
1772:
1773: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);

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

1769: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1770: if nvl(Pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1771: = nvl(p_resident_jurisdiction, 'R') then
1772:
1773: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1774: hr_utility.trace('ANK Gross val = ' ||
1775: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5);
1776: -- Gross Earnings
1777: ln_amt2 := ln_amt2 +

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

1770: if nvl(Pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1771: = nvl(p_resident_jurisdiction, 'R') then
1772:
1773: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1774: hr_utility.trace('ANK Gross val = ' ||
1775: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5);
1776: -- Gross Earnings
1777: ln_amt2 := ln_amt2 +
1778: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;

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

1777: ln_amt2 := ln_amt2 +
1778: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1779:
1780: if p_tax_type = 'IT' then
1781: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 610);
1782: -- School Subj Whable
1783: ln_amt4 := ln_amt4 +
1784: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1785: -- School Subj NWhable

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

1798: end if; /* End of Jurisdiction Check */
1799: end if; /* End of PL/SQL Table and Parameter JD check */
1800: end loop; /* End of PL/SQL Table Loop */
1801:
1802: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);
1803: hr_utility.trace('Amt1=' || ln_amt1);
1804: hr_utility.trace('Amt2=' || ln_amt2);
1805: hr_utility.trace('Amt3=' || ln_amt3);
1806: hr_utility.trace('Amt4=' || ln_amt4);

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

1799: end if; /* End of PL/SQL Table and Parameter JD check */
1800: end loop; /* End of PL/SQL Table Loop */
1801:
1802: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);
1803: hr_utility.trace('Amt1=' || ln_amt1);
1804: hr_utility.trace('Amt2=' || ln_amt2);
1805: hr_utility.trace('Amt3=' || ln_amt3);
1806: hr_utility.trace('Amt4=' || ln_amt4);
1807: hr_utility.trace('Amt5=' || ln_amt5);

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

1800: end loop; /* End of PL/SQL Table Loop */
1801:
1802: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);
1803: hr_utility.trace('Amt1=' || ln_amt1);
1804: hr_utility.trace('Amt2=' || ln_amt2);
1805: hr_utility.trace('Amt3=' || ln_amt3);
1806: hr_utility.trace('Amt4=' || ln_amt4);
1807: hr_utility.trace('Amt5=' || ln_amt5);
1808: hr_utility.trace('Amt6=' || ln_amt6);

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

1801:
1802: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);
1803: hr_utility.trace('Amt1=' || ln_amt1);
1804: hr_utility.trace('Amt2=' || ln_amt2);
1805: hr_utility.trace('Amt3=' || ln_amt3);
1806: hr_utility.trace('Amt4=' || ln_amt4);
1807: hr_utility.trace('Amt5=' || ln_amt5);
1808: hr_utility.trace('Amt6=' || ln_amt6);
1809: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);

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

1802: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 700);
1803: hr_utility.trace('Amt1=' || ln_amt1);
1804: hr_utility.trace('Amt2=' || ln_amt2);
1805: hr_utility.trace('Amt3=' || ln_amt3);
1806: hr_utility.trace('Amt4=' || ln_amt4);
1807: hr_utility.trace('Amt5=' || ln_amt5);
1808: hr_utility.trace('Amt6=' || ln_amt6);
1809: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);
1810:

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

1803: hr_utility.trace('Amt1=' || ln_amt1);
1804: hr_utility.trace('Amt2=' || ln_amt2);
1805: hr_utility.trace('Amt3=' || ln_amt3);
1806: hr_utility.trace('Amt4=' || ln_amt4);
1807: hr_utility.trace('Amt5=' || ln_amt5);
1808: hr_utility.trace('Amt6=' || ln_amt6);
1809: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);
1810:
1811: ln_gross_amt := ln_amt2;

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

1804: hr_utility.trace('Amt2=' || ln_amt2);
1805: hr_utility.trace('Amt3=' || ln_amt3);
1806: hr_utility.trace('Amt4=' || ln_amt4);
1807: hr_utility.trace('Amt5=' || ln_amt5);
1808: hr_utility.trace('Amt6=' || ln_amt6);
1809: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);
1810:
1811: ln_gross_amt := ln_amt2;
1812: if p_tax_type in ('IT', 'OPT', 'EIC') then

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

1805: hr_utility.trace('Amt3=' || ln_amt3);
1806: hr_utility.trace('Amt4=' || ln_amt4);
1807: hr_utility.trace('Amt5=' || ln_amt5);
1808: hr_utility.trace('Amt6=' || ln_amt6);
1809: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 710);
1810:
1811: ln_gross_amt := ln_amt2;
1812: if p_tax_type in ('IT', 'OPT', 'EIC') then
1813: ln_subject_amt := ln_amt1 + ln_amt4 + ln_amt5;

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

1822: p_jurisdiction <> '00-000-0000' then
1823: ln_r_er_tax_amt := 0;
1824: end if;
1825:
1826: hr_utility.trace('Gross=' || ln_gross_amt);
1827: hr_utility.trace('Subj=' || ln_subject_amt);
1828: hr_utility.trace('Taxable=' || ln_taxable_amt);
1829: hr_utility.trace('Withheld='|| ln_r_ee_tax_amt);
1830:

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

1823: ln_r_er_tax_amt := 0;
1824: end if;
1825:
1826: hr_utility.trace('Gross=' || ln_gross_amt);
1827: hr_utility.trace('Subj=' || ln_subject_amt);
1828: hr_utility.trace('Taxable=' || ln_taxable_amt);
1829: hr_utility.trace('Withheld='|| ln_r_ee_tax_amt);
1830:
1831: /* Return the formatted values */

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

1824: end if;
1825:
1826: hr_utility.trace('Gross=' || ln_gross_amt);
1827: hr_utility.trace('Subj=' || ln_subject_amt);
1828: hr_utility.trace('Taxable=' || ln_taxable_amt);
1829: hr_utility.trace('Withheld='|| ln_r_ee_tax_amt);
1830:
1831: /* Return the formatted values */
1832: select ltrim(rtrim(to_char(ln_gross_amt, decode(sign(ln_gross_amt),

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

1825:
1826: hr_utility.trace('Gross=' || ln_gross_amt);
1827: hr_utility.trace('Subj=' || ln_subject_amt);
1828: hr_utility.trace('Taxable=' || ln_taxable_amt);
1829: hr_utility.trace('Withheld='|| ln_r_ee_tax_amt);
1830:
1831: /* Return the formatted values */
1832: select ltrim(rtrim(to_char(ln_gross_amt, decode(sign(ln_gross_amt),
1833: -1, '0000000000.00',

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

1848: -1, '0000000000.00',
1849: '00000000000.00'))))
1850: into lv_return from dual;
1851:
1852: hr_utility.trace('Return Value=' || lv_return);
1853: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 800);
1854: return(lv_return);
1855: END get_fls_tax_type_values;
1856:

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

1849: '00000000000.00'))))
1850: into lv_return from dual;
1851:
1852: hr_utility.trace('Return Value=' || lv_return);
1853: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 800);
1854: return(lv_return);
1855: END get_fls_tax_type_values;
1856:
1857: --BEGIN

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

1854: return(lv_return);
1855: END get_fls_tax_type_values;
1856:
1857: --BEGIN
1858: -- hr_utility.trace_on(null, 'FLSP');
1859:
1860: END pay_us_fls_reporting_pkg;