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

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

25: l_actual_max_donation_dummy number default 0;
26: l_dummy_taxable_income number default 0;
27: label number default 0;
28: l_row_count number default 0;
29: g_debug constant boolean := hr_utility.debug_enabled;
30: -- End of Bug 9393732
31: --
32: l_credit_card_exp number default 0; -- Bug 11665554
33: -- Bug 3901912

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

279: --
280: begin
281: --
282: if g_debug then
283: hr_utility.trace('*** Insert Donation Details ***');
284: end if;
285: --
286: open get_donation_details;
287: fetch get_donation_details into

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

294: l_ovn;
295: close get_donation_details;
296: --
297: if g_debug then
298: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
299: hr_utility.trace('l_donation_code = '||l_donation_code);
300: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
301: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
302: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));

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

295: close get_donation_details;
296: --
297: if g_debug then
298: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
299: hr_utility.trace('l_donation_code = '||l_donation_code);
300: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
301: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
302: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
303: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));

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

296: --
297: if g_debug then
298: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
299: hr_utility.trace('l_donation_code = '||l_donation_code);
300: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
301: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
302: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
303: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
304: hr_utility.trace('l_ovn = '||to_char(l_ovn));

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

297: if g_debug then
298: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
299: hr_utility.trace('l_donation_code = '||l_donation_code);
300: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
301: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
302: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
303: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
304: hr_utility.trace('l_ovn = '||to_char(l_ovn));
305: end if;

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

298: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
299: hr_utility.trace('l_donation_code = '||l_donation_code);
300: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
301: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
302: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
303: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
304: hr_utility.trace('l_ovn = '||to_char(l_ovn));
305: end if;
306: --

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

299: hr_utility.trace('l_donation_code = '||l_donation_code);
300: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
301: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
302: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
303: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
304: hr_utility.trace('l_ovn = '||to_char(l_ovn));
305: end if;
306: --
307: if l_donation_code = '31' then

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

300: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
301: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
302: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
303: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
304: hr_utility.trace('l_ovn = '||to_char(l_ovn));
305: end if;
306: --
307: if l_donation_code = '31' then
308: if (l_donation_year + 3) > to_number(to_char(p_effective_date, 'YYYY')) then

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

349: -- Updating the records for the target year
350: if p_asg_info_id is not null then
351: --
352: if g_debug then
353: hr_utility.trace('Updating the records for the asg_info_id : '||to_char(p_asg_info_id));
354: end if;
355: --
356: hr_assignment_extra_info_api.update_assignment_extra_info(
357: p_validate => false,

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

395: -- Creating a new row for the next year.
396: if l_carryoveramt > 0 then
397: --
398: if g_debug then
399: hr_utility.trace('Check if the records already exist for this donation type');
400: end if;
401: --
402: open check_records_exists(l_donation_year,l_donation_code);
403: fetch check_records_exists into l_asgInfoId,l_ovn1;

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

403: fetch check_records_exists into l_asgInfoId,l_ovn1;
404: if check_records_exists%NOTFOUND then
405: --
406: if g_debug then
407: hr_utility.trace('Create record if already not present for this donation type');
408: end if;
409: --
410: if p_yea_info.create_don_rec_flag = 'Y' then
411: hr_assignment_extra_info_api.create_assignment_extra_info(

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

450: --
451: else
452: --
453: if g_debug then
454: hr_utility.trace('Update record if already present for this donation type');
455: end if;
456: --
457: hr_assignment_extra_info_api.update_assignment_extra_info(
458: p_validate => false,

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

536:
537: begin
538: --
539: if g_debug then
540: hr_utility.trace('*** Update Donation Details ***');
541: end if;
542: --
543: open get_donation_details;
544: fetch get_donation_details into

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

551: l_ovn;
552: close get_donation_details;
553: --
554: if g_debug then
555: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
556: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
557: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
558: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
559: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));

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

552: close get_donation_details;
553: --
554: if g_debug then
555: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
556: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
557: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
558: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
559: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
560: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));

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

553: --
554: if g_debug then
555: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
556: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
557: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
558: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
559: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
560: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
561: hr_utility.trace('l_ovn = '||to_char(l_ovn));

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

554: if g_debug then
555: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
556: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
557: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
558: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
559: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
560: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
561: hr_utility.trace('l_ovn = '||to_char(l_ovn));
562: end if;

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

555: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
556: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
557: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
558: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
559: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
560: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
561: hr_utility.trace('l_ovn = '||to_char(l_ovn));
562: end if;
563: --

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

556: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
557: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
558: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
559: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
560: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
561: hr_utility.trace('l_ovn = '||to_char(l_ovn));
562: end if;
563: --
564: -- Updating the records for the target year

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

557: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
558: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
559: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
560: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
561: hr_utility.trace('l_ovn = '||to_char(l_ovn));
562: end if;
563: --
564: -- Updating the records for the target year
565: if l_asg_info_id is not null then

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

564: -- Updating the records for the target year
565: if l_asg_info_id is not null then
566: --
567: if g_debug then
568: hr_utility.trace('Updating the records for the asg_info_id : '||to_char(l_asg_info_id));
569: end if;
570: --
571: hr_assignment_extra_info_api.update_assignment_extra_info(
572: p_validate => false,

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

723: end;
724: begin
725: --
726: if g_debug then
727: hr_utility.trace('*** Inside Yea Package ***');
728: end if;
729: --
730: ----------------------------------------------------------------------------+
731: -- Populating Local variables with Global values

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

1187: -- Housing Expense Tax Exemption
1188: ----------------------------------------------------------------
1189: --
1190: if g_debug then
1191: hr_utility.trace('*** Housing Expense Tax Exemption ***');
1192: end if;
1193: --
1194: l_dummy := 0;
1195: for i in 1..p_yea_info.hou_saving_type_tbl.count loop

Line 1370: hr_utility.trace('Entering while loop : '||to_char(label));

1366: while(label < 2) loop
1367:
1368: --
1369: if g_debug then
1370: hr_utility.trace('Entering while loop : '||to_char(label));
1371: hr_utility.trace('Taxable Income2 = '||to_char(l_dummy_taxable_income));
1372: end if;
1373: --
1374:

Line 1371: hr_utility.trace('Taxable Income2 = '||to_char(l_dummy_taxable_income));

1367:
1368: --
1369: if g_debug then
1370: hr_utility.trace('Entering while loop : '||to_char(label));
1371: hr_utility.trace('Taxable Income2 = '||to_char(l_dummy_taxable_income));
1372: end if;
1373: --
1374:
1375: p_yea_info.taxable_income2 := l_dummy_taxable_income;

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

1389: end if;
1390: p_yea_info.taxable_income2 := p_yea_info.taxable_income2 - p_yea_info.sp_tax_exem - p_yea_info.std_sp_tax_exem;
1391: --
1392: if g_debug then
1393: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));
1394: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));
1395: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1396: end if;
1397: --

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

1390: p_yea_info.taxable_income2 := p_yea_info.taxable_income2 - p_yea_info.sp_tax_exem - p_yea_info.std_sp_tax_exem;
1391: --
1392: if g_debug then
1393: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));
1394: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));
1395: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1396: end if;
1397: --
1398: end if;

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

1391: --
1392: if g_debug then
1393: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));
1394: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));
1395: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1396: end if;
1397: --
1398: end if;
1399:

Line 1739: hr_utility.trace('Deleting future carry over details for donation (if any)');

1735: if label = 0 then
1736:
1737: --
1738: if g_debug then
1739: hr_utility.trace('Deleting future carry over details for donation (if any)');
1740: end if;
1741: --
1742: delete_future_details(p_assignment_id,
1743: p_effective_date);

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

1755: --
1756: -- Calculate for Statutory Donation
1757: --
1758: if g_debug then
1759: hr_utility.trace('Taxable Income just before Donation: '||to_char(p_yea_info.taxation_base));
1760: hr_utility.trace('*** Calculate Statutory Donation ***');
1761: end if;
1762: --
1763: l_political2_exem := 0;

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

1756: -- Calculate for Statutory Donation
1757: --
1758: if g_debug then
1759: hr_utility.trace('Taxable Income just before Donation: '||to_char(p_yea_info.taxation_base));
1760: hr_utility.trace('*** Calculate Statutory Donation ***');
1761: end if;
1762: --
1763: l_political2_exem := 0;
1764: --

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

1766: --
1767: p_yea_info.donation1_tax_exem := 0;
1768: --
1769: if g_debug then
1770: hr_utility.trace('*** Calculate Political Donation ***');
1771: end if;
1772: --
1773: if p_yea_info.political_donation1 > 0 then
1774: p_yea_info.donation1_tax_exem := p_yea_info.donation1_tax_exem + least(l_actual_max_donation_dummy,p_yea_info.taxable_income,greatest(p_yea_info.political_donation1 - l_political_tax_brk_lim2004, 0));

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

1815: -- Bug 7142612: Added Public Legal Entity Donation Trust to Tax Law Amount
1816: --
1817: --
1818: if g_debug then
1819: hr_utility.trace('*** Calculate Special Donation ***');
1820: end if;
1821: --
1822: p_yea_info.donation3_tax_exem := 0;
1823: l_max_donation3_dummy := 0;

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

1870: --
1871: -- Calculate for ESOA Donation
1872: --
1873: if g_debug then
1874: hr_utility.trace('*** Calculate ESOA Donation ***');
1875: end if;
1876: --
1877: if p_yea_info.esoa_don2004 > 0 then
1878: if p_yea_info.taxable_income > (p_yea_info.donation1_tax_exem + p_yea_info.donation3_tax_exem) then

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

1890: -- Calculate for Specified and Religious Donation
1891: --
1892: --
1893: if g_debug then
1894: hr_utility.trace('*** Calculate Specified and Religious Donation ***');
1895: end if;
1896: --
1897: l_max_donation2_dummy := 0;
1898: p_yea_info.donation2_tax_exem := 0;

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

2073: -- Now calculate total political donation income exemption
2074: 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 ;
2075: --
2076: if g_debug then
2077: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
2078: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
2079: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
2080: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
2081: end if;

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

2074: 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 ;
2075: --
2076: if g_debug then
2077: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
2078: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
2079: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
2080: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
2081: end if;
2082: --

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

2075: --
2076: if g_debug then
2077: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
2078: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
2079: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
2080: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
2081: end if;
2082: --
2083: --

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

2076: if g_debug then
2077: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
2078: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
2079: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
2080: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
2081: end if;
2082: --
2083: --
2084: -- Bug 4119483: Apply upper limit based on cumulative special exemption