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

Line 32: g_debug constant boolean := hr_utility.debug_enabled;

28: l_dummy_taxable_income number default 0;
29: label number default 0;
30: l_row_count number default 0;
31: l_spec_actual_amount number default 0;
32: g_debug constant boolean := hr_utility.debug_enabled;
33: -- End of Bug 9393732
34: --
35: l_credit_card_exp number default 0; -- Bug 11665554
36: -- Bug 3901912

Line 295: hr_utility.trace('* Insert Donation Details *');

291: --
292: begin
293: --
294: if g_debug then
295: hr_utility.trace('*** Insert Donation Details ***');
296: end if;
297: --
298: open get_donation_details;
299: fetch get_donation_details into

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

308: l_ovn;
309: close get_donation_details;
310: --
311: if g_debug then
312: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
313: hr_utility.trace('l_donation_code = '||l_donation_code);
314: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
315: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
316: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));

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

309: close get_donation_details;
310: --
311: if g_debug then
312: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
313: hr_utility.trace('l_donation_code = '||l_donation_code);
314: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
315: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
316: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
317: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));

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

310: --
311: if g_debug then
312: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
313: hr_utility.trace('l_donation_code = '||l_donation_code);
314: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
315: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
316: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
317: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
318: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);

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

311: if g_debug then
312: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
313: hr_utility.trace('l_donation_code = '||l_donation_code);
314: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
315: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
316: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
317: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
318: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
319: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);

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

312: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
313: hr_utility.trace('l_donation_code = '||l_donation_code);
314: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
315: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
316: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
317: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
318: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
319: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);
320: hr_utility.trace('l_ovn = '||to_char(l_ovn));

Line 317: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));

313: hr_utility.trace('l_donation_code = '||l_donation_code);
314: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
315: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
316: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
317: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
318: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
319: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);
320: hr_utility.trace('l_ovn = '||to_char(l_ovn));
321: end if;

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

314: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
315: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
316: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
317: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
318: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
319: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);
320: hr_utility.trace('l_ovn = '||to_char(l_ovn));
321: end if;
322: --

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

315: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
316: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
317: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
318: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
319: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);
320: hr_utility.trace('l_ovn = '||to_char(l_ovn));
321: end if;
322: --
323: if l_donation_code = '31' then

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

316: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
317: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
318: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
319: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);
320: hr_utility.trace('l_ovn = '||to_char(l_ovn));
321: end if;
322: --
323: if l_donation_code = '31' then
324: if (l_donation_year + 3) > to_number(to_char(p_effective_date, 'YYYY')) then

Line 372: hr_utility.trace('Updating the records for the asg_info_id : '||to_char(p_asg_info_id));

368:
369: if p_asg_info_id is not null then
370: --
371: if g_debug then
372: hr_utility.trace('Updating the records for the asg_info_id : '||to_char(p_asg_info_id));
373: end if;
374: --
375: hr_assignment_extra_info_api.update_assignment_extra_info(
376: p_validate => false,

Line 411: hr_utility.trace('end of updating '||to_char(p_asg_info_id));

407: p_aei_information29 => null,
408: p_aei_information30 => null
409: );
410: --
411: hr_utility.trace('end of updating '||to_char(p_asg_info_id));
412: end if;
413: --
414: -- Creating a new row for the next year.
415: if l_carryoveramt > 0 then

Line 418: hr_utility.trace('Check if the records already exist for this donation type');

414: -- Creating a new row for the next year.
415: if l_carryoveramt > 0 then
416: --
417: if g_debug then
418: hr_utility.trace('Check if the records already exist for this donation type');
419: end if;
420: --
421: open check_records_exists(l_donation_year,l_donation_code);
422: fetch check_records_exists into l_asgInfoId,l_ovn1;

Line 426: hr_utility.trace('Create record if already not present for this donation type');

422: fetch check_records_exists into l_asgInfoId,l_ovn1;
423: if check_records_exists%NOTFOUND then
424: --
425: if g_debug then
426: hr_utility.trace('Create record if already not present for this donation type');
427: end if;
428: --
429: if p_yea_info.create_don_rec_flag = 'Y' then
430: hr_assignment_extra_info_api.create_assignment_extra_info(

Line 473: hr_utility.trace('Update record if already present for this donation type');

469: --
470: else
471: --
472: if g_debug then
473: hr_utility.trace('Update record if already present for this donation type');
474: end if;
475: --
476: hr_assignment_extra_info_api.update_assignment_extra_info(
477: p_validate => false,

Line 559: hr_utility.trace('* Update Donation Details *');

555:
556: begin
557: --
558: if g_debug then
559: hr_utility.trace('*** Update Donation Details ***');
560: end if;
561: --
562: open get_donation_details;
563: fetch get_donation_details into

Line 574: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));

570: l_ovn;
571: close get_donation_details;
572: --
573: if g_debug then
574: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
575: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
576: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
577: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
578: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));

Line 575: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);

571: close get_donation_details;
572: --
573: if g_debug then
574: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
575: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
576: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
577: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
578: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
579: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));

Line 576: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));

572: --
573: if g_debug then
574: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
575: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
576: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
577: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
578: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
579: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
580: hr_utility.trace('l_ovn = '||to_char(l_ovn));

Line 577: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));

573: if g_debug then
574: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
575: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
576: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
577: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
578: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
579: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
580: hr_utility.trace('l_ovn = '||to_char(l_ovn));
581: end if;

Line 578: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));

574: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
575: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
576: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
577: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
578: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
579: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
580: hr_utility.trace('l_ovn = '||to_char(l_ovn));
581: end if;
582: --

Line 579: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));

575: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
576: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
577: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
578: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
579: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
580: hr_utility.trace('l_ovn = '||to_char(l_ovn));
581: end if;
582: --
583: -- Updating the records for the target year

Line 580: hr_utility.trace('l_ovn = '||to_char(l_ovn));

576: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
577: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
578: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
579: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
580: hr_utility.trace('l_ovn = '||to_char(l_ovn));
581: end if;
582: --
583: -- Updating the records for the target year
584: if l_asg_info_id is not null then

Line 587: hr_utility.trace('Updating the records for the asg_info_id : '||to_char(l_asg_info_id));

583: -- Updating the records for the target year
584: if l_asg_info_id is not null then
585: --
586: if g_debug then
587: hr_utility.trace('Updating the records for the asg_info_id : '||to_char(l_asg_info_id));
588: end if;
589: --
590: hr_assignment_extra_info_api.update_assignment_extra_info(
591: p_validate => false,

Line 746: hr_utility.trace('* Inside Yea Package *');

742: end;
743: begin
744: --
745: if g_debug then
746: hr_utility.trace('*** Inside Yea Package ***');
747: end if;
748: --
749: ----------------------------------------------------------------------------+
750: -- Populating Local variables with Global values

Line 875: hr_utility.trace('*** p_yea_info.nationality : '||p_yea_info.nationality);

871: l_card_exp_not_exempted := 0 ; -- Bug 6763554
872: --
873: p_tax_adj_warning := false;
874: -- Bug 3172960
875: hr_utility.trace('*** p_yea_info.nationality : '||p_yea_info.nationality);
876: hr_utility.trace('*** p_yea_info.fixed_tax_rate : '||p_yea_info.fixed_tax_rate);
877: if (p_yea_info.nationality = 'F' and p_yea_info.fixed_tax_rate = 'Y' and p_effective_date < c_20130101) then
878: --
879: p_yea_info.taxable := p_yea_info.taxable + p_yea_info.non_taxable + p_yea_info.non_rep_non_taxable; --Bug 12807687

Line 876: hr_utility.trace('*** p_yea_info.fixed_tax_rate : '||p_yea_info.fixed_tax_rate);

872: --
873: p_tax_adj_warning := false;
874: -- Bug 3172960
875: hr_utility.trace('*** p_yea_info.nationality : '||p_yea_info.nationality);
876: hr_utility.trace('*** p_yea_info.fixed_tax_rate : '||p_yea_info.fixed_tax_rate);
877: if (p_yea_info.nationality = 'F' and p_yea_info.fixed_tax_rate = 'Y' and p_effective_date < c_20130101) then
878: --
879: p_yea_info.taxable := p_yea_info.taxable + p_yea_info.non_taxable + p_yea_info.non_rep_non_taxable; --Bug 12807687
880: p_yea_info.taxable_income := p_yea_info.taxable;

Line 1107: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));

1103: end if;
1104: end loop;
1105: p_yea_info.taxable_income2 := p_yea_info.taxable_income2 - nvl(p_yea_info.corp_pension_prem_tax_exem,0) - nvl(p_yea_info.scientific_technician_tax_exem,0);
1106:
1107: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1108: ----------------------------------------------------------------
1109: -- Supplemental Tax Exemption
1110: ----------------------------------------------------------------
1111: /* Bug 5734313 : Obsoleted code for Supplemental Tax Exemption */

Line 1161: hr_utility.trace('p_yea_info.hi_prem_tax_exem = '||to_char(p_yea_info.hi_prem_tax_exem));

1157: + p_yea_info.ei_prem_tax_exem
1158: + p_yea_info.pers_ins_prem_tax_exem
1159: + p_yea_info.disabled_ins_prem_tax_exem;
1160:
1161: hr_utility.trace('p_yea_info.hi_prem_tax_exem = '||to_char(p_yea_info.hi_prem_tax_exem));
1162: hr_utility.trace('long_term_ins_prem_tax_exem = '||to_char(p_yea_info.long_term_ins_prem_tax_exem ));
1163: hr_utility.trace('p_yea_info.ei_prem_tax_exem = '||to_char(p_yea_info.ei_prem_tax_exem));
1164:
1165: -- Bug 3971542

Line 1162: hr_utility.trace('long_term_ins_prem_tax_exem = '||to_char(p_yea_info.long_term_ins_prem_tax_exem ));

1158: + p_yea_info.pers_ins_prem_tax_exem
1159: + p_yea_info.disabled_ins_prem_tax_exem;
1160:
1161: hr_utility.trace('p_yea_info.hi_prem_tax_exem = '||to_char(p_yea_info.hi_prem_tax_exem));
1162: hr_utility.trace('long_term_ins_prem_tax_exem = '||to_char(p_yea_info.long_term_ins_prem_tax_exem ));
1163: hr_utility.trace('p_yea_info.ei_prem_tax_exem = '||to_char(p_yea_info.ei_prem_tax_exem));
1164:
1165: -- Bug 3971542
1166: -- l_cuml_special_exem := l_cuml_special_exem + p_yea_info.ins_prem_tax_exem ;

Line 1163: hr_utility.trace('p_yea_info.ei_prem_tax_exem = '||to_char(p_yea_info.ei_prem_tax_exem));

1159: + p_yea_info.disabled_ins_prem_tax_exem;
1160:
1161: hr_utility.trace('p_yea_info.hi_prem_tax_exem = '||to_char(p_yea_info.hi_prem_tax_exem));
1162: hr_utility.trace('long_term_ins_prem_tax_exem = '||to_char(p_yea_info.long_term_ins_prem_tax_exem ));
1163: hr_utility.trace('p_yea_info.ei_prem_tax_exem = '||to_char(p_yea_info.ei_prem_tax_exem));
1164:
1165: -- Bug 3971542
1166: -- l_cuml_special_exem := l_cuml_special_exem + p_yea_info.ins_prem_tax_exem ;
1167: -- End of 3971542

Line 1268: hr_utility.trace('* Housing Expense Tax Exemption *');

1264: -- Housing Expense Tax Exemption
1265: ----------------------------------------------------------------
1266: --
1267: if g_debug then
1268: hr_utility.trace('*** Housing Expense Tax Exemption ***');
1269: end if;
1270: --
1271: l_dummy := 0;
1272: for i in 1..p_yea_info.hou_saving_type_tbl.count loop

Line 1277: hr_utility.trace('p_yea_info.house_holder_flag : '||p_yea_info.house_holder_flag);

1273: if p_yea_info.hou_saving_type_tbl(i) <> 'HST2' then
1274: l_dummy := l_dummy + nvl(p_yea_info.hou_saving_cont_amount_tbl(i),0);
1275: end if;
1276: end loop;
1277: hr_utility.trace('p_yea_info.house_holder_flag : '||p_yea_info.house_holder_flag);
1278: hr_utility.trace('p_yea_info.house_holder_exception_flag : '|| p_yea_info.house_holder_exception_flag);
1279:
1280: if (p_yea_info.house_holder_flag = 'Y' or p_yea_info.house_holder_exception_flag = 'Y') then -- Bug 9737699
1281: hr_utility.trace('*** INSIDE house_holder_flag ***');

Line 1278: hr_utility.trace('p_yea_info.house_holder_exception_flag : '|| p_yea_info.house_holder_exception_flag);

1274: l_dummy := l_dummy + nvl(p_yea_info.hou_saving_cont_amount_tbl(i),0);
1275: end if;
1276: end loop;
1277: hr_utility.trace('p_yea_info.house_holder_flag : '||p_yea_info.house_holder_flag);
1278: hr_utility.trace('p_yea_info.house_holder_exception_flag : '|| p_yea_info.house_holder_exception_flag);
1279:
1280: if (p_yea_info.house_holder_flag = 'Y' or p_yea_info.house_holder_exception_flag = 'Y') then -- Bug 9737699
1281: hr_utility.trace('*** INSIDE house_holder_flag ***');
1282: if l_dummy > 0

Line 1281: hr_utility.trace('* INSIDE house_holder_flag *');

1277: hr_utility.trace('p_yea_info.house_holder_flag : '||p_yea_info.house_holder_flag);
1278: hr_utility.trace('p_yea_info.house_holder_exception_flag : '|| p_yea_info.house_holder_exception_flag);
1279:
1280: if (p_yea_info.house_holder_flag = 'Y' or p_yea_info.house_holder_exception_flag = 'Y') then -- Bug 9737699
1281: hr_utility.trace('*** INSIDE house_holder_flag ***');
1282: if l_dummy > 0
1283: or p_yea_info.housing_loan_repay > 0
1284: or p_yea_info.housing_prv_loan_repay > 0
1285: or p_yea_info.lt_housing_loan_interest_repay > 0

Line 1424: hr_utility.trace('p_yea_info.lt_housing_loan_int_rep_exem1 = '||to_char(p_yea_info.lt_housing_loan_int_rep_exem1 ));

1420: -- End of Bug -- 7142620
1421:
1422: end if;
1423:
1424: hr_utility.trace('p_yea_info.lt_housing_loan_int_rep_exem1 = '||to_char(p_yea_info.lt_housing_loan_int_rep_exem1 ));
1425:
1426:
1427: -- Long term loan due 15 - 29 years
1428: --

Line 1496: hr_utility.trace('Taxable Income just before Donation: '||to_char(p_yea_info.taxation_base));

1492: --
1493: -- Calculate for Statutory Donation
1494: --
1495: if g_debug then
1496: hr_utility.trace('Taxable Income just before Donation: '||to_char(p_yea_info.taxation_base));
1497: hr_utility.trace('*** Calculate Statutory Donation ***');
1498: end if;
1499: --
1500: l_political2_exem := 0;

Line 1497: hr_utility.trace('* Calculate Statutory Donation *');

1493: -- Calculate for Statutory Donation
1494: --
1495: if g_debug then
1496: hr_utility.trace('Taxable Income just before Donation: '||to_char(p_yea_info.taxation_base));
1497: hr_utility.trace('*** Calculate Statutory Donation ***');
1498: end if;
1499: --
1500: l_political2_exem := 0;
1501: --

Line 1502: hr_utility.trace('p_yea_info.taxation_base = '||p_yea_info.taxation_base);

1498: end if;
1499: --
1500: l_political2_exem := 0;
1501: --
1502: hr_utility.trace('p_yea_info.taxation_base = '||p_yea_info.taxation_base);
1503: p_yea_info.taxable_income2 := greatest(p_yea_info.taxation_base,0);
1504: l_actual_max_donation_dummy := greatest(p_yea_info.taxation_base,0);
1505: --
1506: p_yea_info.donation1_tax_exem := 0;

Line 1510: hr_utility.trace('* Calculate Political Donation *');

1506: p_yea_info.donation1_tax_exem := 0;
1507: --
1508:
1509: if g_debug then
1510: hr_utility.trace('*** Calculate Political Donation ***');
1511: end if;
1512: --
1513: if p_yea_info.political_donation1 > 0 then
1514: p_yea_info.donation1_tax_exem := p_yea_info.donation1_tax_exem + least(l_actual_max_donation_dummy,p_yea_info.taxable_income2,greatest(p_yea_info.political_donation1 - l_political_tax_brk_lim2004, 0));

Line 1559: hr_utility.trace('* Calculate Special Donation *');

1555: -- Bug 7142612: Added Public Legal Entity Donation Trust to Tax Law Amount
1556: --
1557: --
1558: if g_debug then
1559: hr_utility.trace('*** Calculate Special Donation ***');
1560: end if;
1561: --
1562: p_yea_info.donation3_tax_exem := 0;
1563: l_max_donation3_dummy := 0;

Line 1611: hr_utility.trace('* Calculate ESOA Donation *');

1607: --
1608: -- Calculate for ESOA Donation
1609: --
1610: if g_debug then
1611: hr_utility.trace('*** Calculate ESOA Donation ***');
1612: end if;
1613: --
1614: if p_yea_info.esoa_don2004 > 0 then
1615: if p_yea_info.taxable_income2 > (p_yea_info.donation1_tax_exem + p_yea_info.donation3_tax_exem) then

Line 1632: hr_utility.trace('* Calculate Specified and Religious Donation *');

1628: -- Calculate for Specified and Religious Donation
1629: --
1630: --
1631: if g_debug then
1632: hr_utility.trace('*** Calculate Specified and Religious Donation ***');
1633: end if;
1634: --
1635: l_max_donation2_dummy := 0;
1636: p_yea_info.donation2_tax_exem := 0;

Line 1997: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));

1993: -- Now calculate total political donation income exemption
1994: p_yea_info.donation_tax_exem := p_yea_info.donation1_tax_exem + p_yea_info.donation2_tax_exem + p_yea_info.donation3_tax_exem + p_yea_info.esoa_don_tax_exem2004 ;
1995: --
1996: if g_debug then
1997: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
1998: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
1999: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
2000: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
2001: end if;

Line 1998: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));

1994: p_yea_info.donation_tax_exem := p_yea_info.donation1_tax_exem + p_yea_info.donation2_tax_exem + p_yea_info.donation3_tax_exem + p_yea_info.esoa_don_tax_exem2004 ;
1995: --
1996: if g_debug then
1997: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
1998: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
1999: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
2000: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
2001: end if;
2002: --

Line 1999: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));

1995: --
1996: if g_debug then
1997: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
1998: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
1999: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
2000: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
2001: end if;
2002: --
2003: --

Line 2000: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));

1996: if g_debug then
1997: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
1998: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
1999: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
2000: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
2001: end if;
2002: --
2003: --
2004: -- Bug 4119483: Apply upper limit based on cumulative special exemption

Line 2015: hr_utility.trace('p_yea_info.taxable_income2: = '||p_yea_info.taxable_income2);

2011: --
2012: l_cuml_special_exem := l_cuml_special_exem + p_yea_info.donation_tax_exem ;
2013: p_yea_info.taxable_income2 := greatest(0,p_yea_info.taxable_income2 - p_yea_info.donation_tax_exem);
2014: --
2015: hr_utility.trace('p_yea_info.taxable_income2: = '||p_yea_info.taxable_income2);
2016: --
2017: check_donation_details(p_assignment_id,
2018: p_effective_date);
2019:

Line 2036: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));

2032: + p_yea_info.housing_exp_tax_exem
2033: + p_yea_info.donation_tax_exem
2034: + p_yea_info.marr_fun_relo_exemption;
2035:
2036: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));
2037: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
2038: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
2039: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
2040: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));

Line 2037: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));

2033: + p_yea_info.donation_tax_exem
2034: + p_yea_info.marr_fun_relo_exemption;
2035:
2036: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));
2037: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
2038: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
2039: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
2040: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));
2041: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));

Line 2038: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));

2034: + p_yea_info.marr_fun_relo_exemption;
2035:
2036: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));
2037: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
2038: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
2039: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
2040: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));
2041: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));
2042:

Line 2039: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));

2035:
2036: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));
2037: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
2038: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
2039: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
2040: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));
2041: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));
2042:
2043:

Line 2040: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));

2036: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));
2037: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
2038: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
2039: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
2040: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));
2041: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));
2042:
2043:
2044: p_yea_info.taxable_income2 := p_yea_info.taxable_income2 + p_yea_info.sp_tax_exem;

Line 2041: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));

2037: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
2038: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
2039: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
2040: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));
2041: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));
2042:
2043:
2044: p_yea_info.taxable_income2 := p_yea_info.taxable_income2 + p_yea_info.sp_tax_exem;
2045: if (p_yea_info.sp_tax_exem < l_std_sp_tax_exem ) then -- Bug 11768555

Line 2053: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));

2049:
2050: p_yea_info.taxable_income2 := greatest(p_yea_info.taxable_income2 - p_yea_info.sp_tax_exem - p_yea_info.std_sp_tax_exem,0);
2051: --
2052: if g_debug then
2053: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));
2054: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));
2055: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
2056: end if;
2057: --

Line 2054: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));

2050: p_yea_info.taxable_income2 := greatest(p_yea_info.taxable_income2 - p_yea_info.sp_tax_exem - p_yea_info.std_sp_tax_exem,0);
2051: --
2052: if g_debug then
2053: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));
2054: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));
2055: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
2056: end if;
2057: --
2058: end if;

Line 2055: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));

2051: --
2052: if g_debug then
2053: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));
2054: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));
2055: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
2056: end if;
2057: --
2058: end if;
2059: