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

[Home] [Help]

APPS.PER_JP_CMA_UTILITY_PKG dependencies on HR_UTILITY

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

415: l_deemed_income(p_index).sal_taxable_amount := 0;
416: end if;
417: end init_deemed_income;
418: begin
419: hr_utility.set_location('Entering: ' || c_proc, 10);
420: ---- bug 4029525 ----
421: l_payment_date := trunc(p_payment_date, 'MM');
422: ---------------------
423: hr_utility.trace('p_payment_date : ' || p_payment_date);

Line 423: hr_utility.trace('p_payment_date : ' || p_payment_date);

419: hr_utility.set_location('Entering: ' || c_proc, 10);
420: ---- bug 4029525 ----
421: l_payment_date := trunc(p_payment_date, 'MM');
422: ---------------------
423: hr_utility.trace('p_payment_date : ' || p_payment_date);
424: hr_utility.trace('p_effective_date: ' || p_effective_date);
425: hr_utility.trace('l_payment_date : ' || l_payment_date);
426: --
427: open csr_car;

Line 424: hr_utility.trace('p_effective_date: ' || p_effective_date);

420: ---- bug 4029525 ----
421: l_payment_date := trunc(p_payment_date, 'MM');
422: ---------------------
423: hr_utility.trace('p_payment_date : ' || p_payment_date);
424: hr_utility.trace('p_effective_date: ' || p_effective_date);
425: hr_utility.trace('l_payment_date : ' || l_payment_date);
426: --
427: open csr_car;
428: fetch csr_car bulk collect into l_cars;

Line 425: hr_utility.trace('l_payment_date : ' || l_payment_date);

421: l_payment_date := trunc(p_payment_date, 'MM');
422: ---------------------
423: hr_utility.trace('p_payment_date : ' || p_payment_date);
424: hr_utility.trace('p_effective_date: ' || p_effective_date);
425: hr_utility.trace('l_payment_date : ' || l_payment_date);
426: --
427: open csr_car;
428: fetch csr_car bulk collect into l_cars;
429: close csr_car;

Line 450: hr_utility.trace('car period: ' || l_cars(i).period);

446: -- to avoid each month amount to be decimal number.
447: --
448: l_lcm := 1;
449: for i in 1..l_cars.count loop
450: hr_utility.trace('car period: ' || l_cars(i).period);
451: p_record_exist := true;
452: l_lcm := hr_jp_standard_pkg.lcm(l_lcm, l_cars(i).period);
453: end loop;
454: --

Line 456: hr_utility.trace('train period: ' || l_trains(i).period);

452: l_lcm := hr_jp_standard_pkg.lcm(l_lcm, l_cars(i).period);
453: end loop;
454: --
455: for i in 1..l_trains.count loop
456: hr_utility.trace('train period: ' || l_trains(i).period);
457: p_record_exist := true;
458: l_lcm := hr_jp_standard_pkg.lcm(l_lcm, l_trains(i).period);
459: end loop;
460: --

Line 461: hr_utility.trace('lcm: ' || l_lcm);

457: p_record_exist := true;
458: l_lcm := hr_jp_standard_pkg.lcm(l_lcm, l_trains(i).period);
459: end loop;
460: --
461: hr_utility.trace('lcm: ' || l_lcm);
462: --
463: -- Split transportation fee for cars into each month.
464: --
465: for i in 1..l_cars.count loop

Line 472: hr_utility.trace('***** Car Info: ' || to_char(l_car.element_entry_id));

468: l_car_sal_non_taxable_amount := 0;
469: l_enforced_taxable_flag := null;
470: l_parking_taxable_flag := null;
471: --
472: hr_utility.trace('***** Car Info: ' || to_char(l_car.element_entry_id));
473: hr_utility.trace('amount : ' || l_car.amount);
474: hr_utility.trace('parking_fees: ' || l_car.parking_fees);
475: hr_utility.trace('period : ' || l_car.period);
476: hr_utility.trace('pay_start : ' || l_car.pay_start);

Line 473: hr_utility.trace('amount : ' || l_car.amount);

469: l_enforced_taxable_flag := null;
470: l_parking_taxable_flag := null;
471: --
472: hr_utility.trace('***** Car Info: ' || to_char(l_car.element_entry_id));
473: hr_utility.trace('amount : ' || l_car.amount);
474: hr_utility.trace('parking_fees: ' || l_car.parking_fees);
475: hr_utility.trace('period : ' || l_car.period);
476: hr_utility.trace('pay_start : ' || l_car.pay_start);
477: hr_utility.trace('pay_end : ' || l_car.pay_end);

Line 474: hr_utility.trace('parking_fees: ' || l_car.parking_fees);

470: l_parking_taxable_flag := null;
471: --
472: hr_utility.trace('***** Car Info: ' || to_char(l_car.element_entry_id));
473: hr_utility.trace('amount : ' || l_car.amount);
474: hr_utility.trace('parking_fees: ' || l_car.parking_fees);
475: hr_utility.trace('period : ' || l_car.period);
476: hr_utility.trace('pay_start : ' || l_car.pay_start);
477: hr_utility.trace('pay_end : ' || l_car.pay_end);
478: --

Line 475: hr_utility.trace('period : ' || l_car.period);

471: --
472: hr_utility.trace('***** Car Info: ' || to_char(l_car.element_entry_id));
473: hr_utility.trace('amount : ' || l_car.amount);
474: hr_utility.trace('parking_fees: ' || l_car.parking_fees);
475: hr_utility.trace('period : ' || l_car.period);
476: hr_utility.trace('pay_start : ' || l_car.pay_start);
477: hr_utility.trace('pay_end : ' || l_car.pay_end);
478: --
479: if l_car.amount is not null then

Line 476: hr_utility.trace('pay_start : ' || l_car.pay_start);

472: hr_utility.trace('***** Car Info: ' || to_char(l_car.element_entry_id));
473: hr_utility.trace('amount : ' || l_car.amount);
474: hr_utility.trace('parking_fees: ' || l_car.parking_fees);
475: hr_utility.trace('period : ' || l_car.period);
476: hr_utility.trace('pay_start : ' || l_car.pay_start);
477: hr_utility.trace('pay_end : ' || l_car.pay_end);
478: --
479: if l_car.amount is not null then
480: --

Line 477: hr_utility.trace('pay_end : ' || l_car.pay_end);

473: hr_utility.trace('amount : ' || l_car.amount);
474: hr_utility.trace('parking_fees: ' || l_car.parking_fees);
475: hr_utility.trace('period : ' || l_car.period);
476: hr_utility.trace('pay_start : ' || l_car.pay_start);
477: hr_utility.trace('pay_end : ' || l_car.pay_end);
478: --
479: if l_car.amount is not null then
480: --
481: -- Strictly speaking, following flag should be checked

Line 614: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));

610: for i in 1..l_trains.count loop
611: l_train := l_trains(i);
612: l_amount := l_train.amount * l_lcm / l_train.period;
613: --
614: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));
615: hr_utility.trace('amount : ' || l_train.amount);
616: hr_utility.trace('period : ' || l_train.period);
617: hr_utility.trace('pay_start : ' || l_train.pay_start);
618: hr_utility.trace('pay_end : ' || l_train.pay_end);

Line 615: hr_utility.trace('amount : ' || l_train.amount);

611: l_train := l_trains(i);
612: l_amount := l_train.amount * l_lcm / l_train.period;
613: --
614: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));
615: hr_utility.trace('amount : ' || l_train.amount);
616: hr_utility.trace('period : ' || l_train.period);
617: hr_utility.trace('pay_start : ' || l_train.pay_start);
618: hr_utility.trace('pay_end : ' || l_train.pay_end);
619: hr_utility.trace('si_start : ' || l_train.si_start);

Line 616: hr_utility.trace('period : ' || l_train.period);

612: l_amount := l_train.amount * l_lcm / l_train.period;
613: --
614: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));
615: hr_utility.trace('amount : ' || l_train.amount);
616: hr_utility.trace('period : ' || l_train.period);
617: hr_utility.trace('pay_start : ' || l_train.pay_start);
618: hr_utility.trace('pay_end : ' || l_train.pay_end);
619: hr_utility.trace('si_start : ' || l_train.si_start);
620: hr_utility.trace('si_end : ' || l_train.si_end);

Line 617: hr_utility.trace('pay_start : ' || l_train.pay_start);

613: --
614: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));
615: hr_utility.trace('amount : ' || l_train.amount);
616: hr_utility.trace('period : ' || l_train.period);
617: hr_utility.trace('pay_start : ' || l_train.pay_start);
618: hr_utility.trace('pay_end : ' || l_train.pay_end);
619: hr_utility.trace('si_start : ' || l_train.si_start);
620: hr_utility.trace('si_end : ' || l_train.si_end);
621: hr_utility.trace('si_month : ' || l_train.si_month);

Line 618: hr_utility.trace('pay_end : ' || l_train.pay_end);

614: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));
615: hr_utility.trace('amount : ' || l_train.amount);
616: hr_utility.trace('period : ' || l_train.period);
617: hr_utility.trace('pay_start : ' || l_train.pay_start);
618: hr_utility.trace('pay_end : ' || l_train.pay_end);
619: hr_utility.trace('si_start : ' || l_train.si_start);
620: hr_utility.trace('si_end : ' || l_train.si_end);
621: hr_utility.trace('si_month : ' || l_train.si_month);
622: hr_utility.trace('m_amount(lcm): ' || l_amount);

Line 619: hr_utility.trace('si_start : ' || l_train.si_start);

615: hr_utility.trace('amount : ' || l_train.amount);
616: hr_utility.trace('period : ' || l_train.period);
617: hr_utility.trace('pay_start : ' || l_train.pay_start);
618: hr_utility.trace('pay_end : ' || l_train.pay_end);
619: hr_utility.trace('si_start : ' || l_train.si_start);
620: hr_utility.trace('si_end : ' || l_train.si_end);
621: hr_utility.trace('si_month : ' || l_train.si_month);
622: hr_utility.trace('m_amount(lcm): ' || l_amount);
623: --

Line 620: hr_utility.trace('si_end : ' || l_train.si_end);

616: hr_utility.trace('period : ' || l_train.period);
617: hr_utility.trace('pay_start : ' || l_train.pay_start);
618: hr_utility.trace('pay_end : ' || l_train.pay_end);
619: hr_utility.trace('si_start : ' || l_train.si_start);
620: hr_utility.trace('si_end : ' || l_train.si_end);
621: hr_utility.trace('si_month : ' || l_train.si_month);
622: hr_utility.trace('m_amount(lcm): ' || l_amount);
623: --
624: -- Taxable/Non-taxable

Line 621: hr_utility.trace('si_month : ' || l_train.si_month);

617: hr_utility.trace('pay_start : ' || l_train.pay_start);
618: hr_utility.trace('pay_end : ' || l_train.pay_end);
619: hr_utility.trace('si_start : ' || l_train.si_start);
620: hr_utility.trace('si_end : ' || l_train.si_end);
621: hr_utility.trace('si_month : ' || l_train.si_month);
622: hr_utility.trace('m_amount(lcm): ' || l_amount);
623: --
624: -- Taxable/Non-taxable
625: --

Line 622: hr_utility.trace('m_amount(lcm): ' || l_amount);

618: hr_utility.trace('pay_end : ' || l_train.pay_end);
619: hr_utility.trace('si_start : ' || l_train.si_start);
620: hr_utility.trace('si_end : ' || l_train.si_end);
621: hr_utility.trace('si_month : ' || l_train.si_month);
622: hr_utility.trace('m_amount(lcm): ' || l_amount);
623: --
624: -- Taxable/Non-taxable
625: --
626: if p_effective_date between l_train.effective_start_date and l_train.effective_end_date

Line 792: hr_utility.trace('* i = ' || i || ' *');

788: l_deemed_income(i).paid_sal_non_taxable_amount
789: + l_deemed_income(i).paid_mtr_non_taxable_amount
790: + l_deemed_income(i).mtr_non_taxable_amount);
791: --
792: hr_utility.trace('***** i = ' || i || ' *****');
793: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
794: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
795: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
796: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);

Line 793: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);

789: + l_deemed_income(i).paid_mtr_non_taxable_amount
790: + l_deemed_income(i).mtr_non_taxable_amount);
791: --
792: hr_utility.trace('***** i = ' || i || ' *****');
793: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
794: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
795: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
796: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
797: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);

Line 794: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);

790: + l_deemed_income(i).mtr_non_taxable_amount);
791: --
792: hr_utility.trace('***** i = ' || i || ' *****');
793: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
794: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
795: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
796: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
797: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);
798: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);

Line 795: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);

791: --
792: hr_utility.trace('***** i = ' || i || ' *****');
793: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
794: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
795: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
796: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
797: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);
798: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);
799: --

Line 796: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);

792: hr_utility.trace('***** i = ' || i || ' *****');
793: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
794: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
795: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
796: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
797: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);
798: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);
799: --
800: l_sal_taxable_amount := l_sal_taxable_amount + l_deemed_income(i).sal_taxable_amount;

Line 797: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);

793: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
794: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
795: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
796: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
797: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);
798: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);
799: --
800: l_sal_taxable_amount := l_sal_taxable_amount + l_deemed_income(i).sal_taxable_amount;
801: l_sal_non_taxable_amount:= l_sal_non_taxable_amount + l_deemed_income(i).sal_non_taxable_amount;

Line 798: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);

794: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
795: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
796: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
797: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);
798: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);
799: --
800: l_sal_taxable_amount := l_sal_taxable_amount + l_deemed_income(i).sal_taxable_amount;
801: l_sal_non_taxable_amount:= l_sal_non_taxable_amount + l_deemed_income(i).sal_non_taxable_amount;
802: l_mtr_taxable_amount := l_mtr_taxable_amount + l_deemed_income(i).mtr_taxable_amount;

Line 808: hr_utility.trace('* before devide by ' || l_lcm || ' *');

804: --
805: i := l_deemed_income.next(i);
806: end loop;
807: --
808: hr_utility.trace('***** before devide by ' || l_lcm || ' *****');
809: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
810: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
811: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
812: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);

Line 809: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);

805: i := l_deemed_income.next(i);
806: end loop;
807: --
808: hr_utility.trace('***** before devide by ' || l_lcm || ' *****');
809: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
810: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
811: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
812: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
813: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);

Line 810: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);

806: end loop;
807: --
808: hr_utility.trace('***** before devide by ' || l_lcm || ' *****');
809: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
810: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
811: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
812: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
813: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
814: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);

Line 811: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);

807: --
808: hr_utility.trace('***** before devide by ' || l_lcm || ' *****');
809: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
810: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
811: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
812: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
813: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
814: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
815: --

Line 812: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);

808: hr_utility.trace('***** before devide by ' || l_lcm || ' *****');
809: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
810: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
811: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
812: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
813: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
814: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
815: --
816: -- Adjust errors of non-taxable into taxable.

Line 813: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);

809: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
810: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
811: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
812: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
813: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
814: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
815: --
816: -- Adjust errors of non-taxable into taxable.
817: -- mtr_non_taxable_amount/mtr_taxable_amount must be integer values, no rounding required.

Line 814: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);

810: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
811: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
812: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
813: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
814: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
815: --
816: -- Adjust errors of non-taxable into taxable.
817: -- mtr_non_taxable_amount/mtr_taxable_amount must be integer values, no rounding required.
818: -- If there's decimal fraction, it is coding bug and should be fixed.

Line 837: hr_utility.trace('* after devide by ' || l_lcm || ' *');

833: --
834: l_sal_si_wage := trunc(l_sal_si_wage / l_lcm);
835: l_mtr_si_wage := trunc(l_mtr_si_wage / l_lcm);
836: --
837: hr_utility.trace('***** after devide by ' || l_lcm || ' *****');
838: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
839: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
840: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
841: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);

Line 838: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);

834: l_sal_si_wage := trunc(l_sal_si_wage / l_lcm);
835: l_mtr_si_wage := trunc(l_mtr_si_wage / l_lcm);
836: --
837: hr_utility.trace('***** after devide by ' || l_lcm || ' *****');
838: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
839: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
840: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
841: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
842: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);

Line 839: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);

835: l_mtr_si_wage := trunc(l_mtr_si_wage / l_lcm);
836: --
837: hr_utility.trace('***** after devide by ' || l_lcm || ' *****');
838: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
839: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
840: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
841: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
842: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
843: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);

Line 840: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);

836: --
837: hr_utility.trace('***** after devide by ' || l_lcm || ' *****');
838: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
839: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
840: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
841: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
842: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
843: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
844: hr_utility.trace('l_sal_income : ' || l_sal_income);

Line 841: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);

837: hr_utility.trace('***** after devide by ' || l_lcm || ' *****');
838: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
839: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
840: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
841: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
842: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
843: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
844: hr_utility.trace('l_sal_income : ' || l_sal_income);
845: hr_utility.trace('l_mtr_income : ' || l_mtr_income);

Line 842: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);

838: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
839: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
840: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
841: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
842: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
843: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
844: hr_utility.trace('l_sal_income : ' || l_sal_income);
845: hr_utility.trace('l_mtr_income : ' || l_mtr_income);
846: --

Line 843: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);

839: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
840: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
841: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
842: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
843: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
844: hr_utility.trace('l_sal_income : ' || l_sal_income);
845: hr_utility.trace('l_mtr_income : ' || l_mtr_income);
846: --
847: -- This is just to ensure that payment is split correctly.

Line 844: hr_utility.trace('l_sal_income : ' || l_sal_income);

840: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
841: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
842: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
843: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
844: hr_utility.trace('l_sal_income : ' || l_sal_income);
845: hr_utility.trace('l_mtr_income : ' || l_mtr_income);
846: --
847: -- This is just to ensure that payment is split correctly.
848: -- Errors will never be raised.

Line 845: hr_utility.trace('l_mtr_income : ' || l_mtr_income);

841: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
842: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
843: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
844: hr_utility.trace('l_sal_income : ' || l_sal_income);
845: hr_utility.trace('l_mtr_income : ' || l_mtr_income);
846: --
847: -- This is just to ensure that payment is split correctly.
848: -- Errors will never be raised.
849: --

Line 938: hr_utility.trace('* output *');

934: p_cma_rec.ui_wage_adj := null;
935: end if;
936: end if;
937: --
938: hr_utility.trace('***** output *****');
939: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
940: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
941: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
942: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);

Line 939: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);

935: end if;
936: end if;
937: --
938: hr_utility.trace('***** output *****');
939: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
940: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
941: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
942: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
943: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);

Line 940: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);

936: end if;
937: --
938: hr_utility.trace('***** output *****');
939: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
940: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
941: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
942: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
943: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
944: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);

Line 941: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);

937: --
938: hr_utility.trace('***** output *****');
939: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
940: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
941: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
942: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
943: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
944: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
945: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);

Line 942: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);

938: hr_utility.trace('***** output *****');
939: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
940: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
941: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
942: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
943: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
944: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
945: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
946: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);

Line 943: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);

939: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
940: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
941: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
942: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
943: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
944: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
945: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
946: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
947: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);

Line 944: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);

940: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
941: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
942: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
943: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
944: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
945: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
946: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
947: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
948: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);

Line 945: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);

941: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
942: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
943: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
944: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
945: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
946: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
947: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
948: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
949: if p_record_exist then

Line 946: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);

942: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
943: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
944: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
945: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
946: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
947: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
948: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
949: if p_record_exist then
950: hr_utility.trace('p_record_exist : TRUE');

Line 947: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);

943: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
944: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
945: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
946: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
947: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
948: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
949: if p_record_exist then
950: hr_utility.trace('p_record_exist : TRUE');
951: else

Line 948: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);

944: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
945: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
946: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
947: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
948: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
949: if p_record_exist then
950: hr_utility.trace('p_record_exist : TRUE');
951: else
952: hr_utility.trace('p_record_exist : FALSE');

Line 950: hr_utility.trace('p_record_exist : TRUE');

946: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
947: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
948: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
949: if p_record_exist then
950: hr_utility.trace('p_record_exist : TRUE');
951: else
952: hr_utility.trace('p_record_exist : FALSE');
953: end if;
954: --

Line 952: hr_utility.trace('p_record_exist : FALSE');

948: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
949: if p_record_exist then
950: hr_utility.trace('p_record_exist : TRUE');
951: else
952: hr_utility.trace('p_record_exist : FALSE');
953: end if;
954: --
955: hr_utility.set_location('Leaving: ' || c_proc, 100);
956: end get_cma_info;

Line 955: hr_utility.set_location('Leaving: ' || c_proc, 100);

951: else
952: hr_utility.trace('p_record_exist : FALSE');
953: end if;
954: --
955: hr_utility.set_location('Leaving: ' || c_proc, 100);
956: end get_cma_info;
957: --
958: end per_jp_cma_utility_pkg;