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 421: hr_utility.set_location('Entering: ' || c_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

626: for i in 1..l_trains.count loop
627: l_train := l_trains(i);
628: l_amount := l_train.amount * l_lcm / l_train.period;
629: --
630: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));
631: hr_utility.trace('amount : ' || l_train.amount);
632: hr_utility.trace('period : ' || l_train.period);
633: hr_utility.trace('pay_start : ' || l_train.pay_start);
634: hr_utility.trace('pay_end : ' || l_train.pay_end);

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

627: l_train := l_trains(i);
628: l_amount := l_train.amount * l_lcm / l_train.period;
629: --
630: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));
631: hr_utility.trace('amount : ' || l_train.amount);
632: hr_utility.trace('period : ' || l_train.period);
633: hr_utility.trace('pay_start : ' || l_train.pay_start);
634: hr_utility.trace('pay_end : ' || l_train.pay_end);
635: hr_utility.trace('si_start : ' || l_train.si_start);

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

628: l_amount := l_train.amount * l_lcm / l_train.period;
629: --
630: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));
631: hr_utility.trace('amount : ' || l_train.amount);
632: hr_utility.trace('period : ' || l_train.period);
633: hr_utility.trace('pay_start : ' || l_train.pay_start);
634: hr_utility.trace('pay_end : ' || l_train.pay_end);
635: hr_utility.trace('si_start : ' || l_train.si_start);
636: hr_utility.trace('si_end : ' || l_train.si_end);

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

629: --
630: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));
631: hr_utility.trace('amount : ' || l_train.amount);
632: hr_utility.trace('period : ' || l_train.period);
633: hr_utility.trace('pay_start : ' || l_train.pay_start);
634: hr_utility.trace('pay_end : ' || l_train.pay_end);
635: hr_utility.trace('si_start : ' || l_train.si_start);
636: hr_utility.trace('si_end : ' || l_train.si_end);
637: hr_utility.trace('si_month : ' || l_train.si_month);

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

630: hr_utility.trace('***** Train Info: ' || to_char(l_train.element_entry_id));
631: hr_utility.trace('amount : ' || l_train.amount);
632: hr_utility.trace('period : ' || l_train.period);
633: hr_utility.trace('pay_start : ' || l_train.pay_start);
634: hr_utility.trace('pay_end : ' || l_train.pay_end);
635: hr_utility.trace('si_start : ' || l_train.si_start);
636: hr_utility.trace('si_end : ' || l_train.si_end);
637: hr_utility.trace('si_month : ' || l_train.si_month);
638: hr_utility.trace('m_amount(lcm): ' || l_amount);

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

631: hr_utility.trace('amount : ' || l_train.amount);
632: hr_utility.trace('period : ' || l_train.period);
633: hr_utility.trace('pay_start : ' || l_train.pay_start);
634: hr_utility.trace('pay_end : ' || l_train.pay_end);
635: hr_utility.trace('si_start : ' || l_train.si_start);
636: hr_utility.trace('si_end : ' || l_train.si_end);
637: hr_utility.trace('si_month : ' || l_train.si_month);
638: hr_utility.trace('m_amount(lcm): ' || l_amount);
639: --

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

632: hr_utility.trace('period : ' || l_train.period);
633: hr_utility.trace('pay_start : ' || l_train.pay_start);
634: hr_utility.trace('pay_end : ' || l_train.pay_end);
635: hr_utility.trace('si_start : ' || l_train.si_start);
636: hr_utility.trace('si_end : ' || l_train.si_end);
637: hr_utility.trace('si_month : ' || l_train.si_month);
638: hr_utility.trace('m_amount(lcm): ' || l_amount);
639: --
640: -- Taxable/Non-taxable

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

633: hr_utility.trace('pay_start : ' || l_train.pay_start);
634: hr_utility.trace('pay_end : ' || l_train.pay_end);
635: hr_utility.trace('si_start : ' || l_train.si_start);
636: hr_utility.trace('si_end : ' || l_train.si_end);
637: hr_utility.trace('si_month : ' || l_train.si_month);
638: hr_utility.trace('m_amount(lcm): ' || l_amount);
639: --
640: -- Taxable/Non-taxable
641: --

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

634: hr_utility.trace('pay_end : ' || l_train.pay_end);
635: hr_utility.trace('si_start : ' || l_train.si_start);
636: hr_utility.trace('si_end : ' || l_train.si_end);
637: hr_utility.trace('si_month : ' || l_train.si_month);
638: hr_utility.trace('m_amount(lcm): ' || l_amount);
639: --
640: -- Taxable/Non-taxable
641: --
642: if p_effective_date between l_train.effective_start_date and l_train.effective_end_date

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

804: l_deemed_income(i).paid_sal_non_taxable_amount
805: + l_deemed_income(i).paid_mtr_non_taxable_amount
806: + l_deemed_income(i).mtr_non_taxable_amount);
807: --
808: hr_utility.trace('***** i = ' || i || ' *****');
809: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
810: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
811: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
812: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);

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

805: + l_deemed_income(i).paid_mtr_non_taxable_amount
806: + l_deemed_income(i).mtr_non_taxable_amount);
807: --
808: hr_utility.trace('***** i = ' || i || ' *****');
809: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
810: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
811: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
812: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
813: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);

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

806: + l_deemed_income(i).mtr_non_taxable_amount);
807: --
808: hr_utility.trace('***** i = ' || i || ' *****');
809: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
810: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
811: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
812: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
813: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);
814: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);

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

807: --
808: hr_utility.trace('***** i = ' || i || ' *****');
809: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
810: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
811: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
812: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
813: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);
814: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);
815: --

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

808: hr_utility.trace('***** i = ' || i || ' *****');
809: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
810: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
811: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
812: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
813: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);
814: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);
815: --
816: l_sal_taxable_amount := l_sal_taxable_amount + l_deemed_income(i).sal_taxable_amount;

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

809: hr_utility.trace('d.sal_taxable_amount : ' || l_deemed_income(i).sal_taxable_amount);
810: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
811: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
812: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
813: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);
814: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);
815: --
816: l_sal_taxable_amount := l_sal_taxable_amount + l_deemed_income(i).sal_taxable_amount;
817: l_sal_non_taxable_amount:= l_sal_non_taxable_amount + l_deemed_income(i).sal_non_taxable_amount;

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

810: hr_utility.trace('d.sal_non_taxable_amount : ' || l_deemed_income(i).sal_non_taxable_amount);
811: hr_utility.trace('d.mtr_taxable_amount : ' || l_deemed_income(i).mtr_taxable_amount);
812: hr_utility.trace('d.mtr_non_taxable_amount : ' || l_deemed_income(i).mtr_non_taxable_amount);
813: hr_utility.trace('d.paid_sal_non_taxable_amount: ' || l_deemed_income(i).paid_sal_non_taxable_amount);
814: hr_utility.trace('d.paid_mtr_non_taxable_amount: ' || l_deemed_income(i).paid_mtr_non_taxable_amount);
815: --
816: l_sal_taxable_amount := l_sal_taxable_amount + l_deemed_income(i).sal_taxable_amount;
817: l_sal_non_taxable_amount:= l_sal_non_taxable_amount + l_deemed_income(i).sal_non_taxable_amount;
818: l_mtr_taxable_amount := l_mtr_taxable_amount + l_deemed_income(i).mtr_taxable_amount;

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

820: --
821: i := l_deemed_income.next(i);
822: end loop;
823: --
824: hr_utility.trace('***** before devide by ' || l_lcm || ' *****');
825: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
826: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
827: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
828: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);

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

821: i := l_deemed_income.next(i);
822: end loop;
823: --
824: hr_utility.trace('***** before devide by ' || l_lcm || ' *****');
825: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
826: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
827: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
828: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
829: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);

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

822: end loop;
823: --
824: hr_utility.trace('***** before devide by ' || l_lcm || ' *****');
825: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
826: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
827: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
828: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
829: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
830: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);

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

823: --
824: hr_utility.trace('***** before devide by ' || l_lcm || ' *****');
825: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
826: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
827: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
828: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
829: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
830: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
831: --

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

824: hr_utility.trace('***** before devide by ' || l_lcm || ' *****');
825: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
826: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
827: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
828: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
829: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
830: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
831: --
832: -- Adjust errors of non-taxable into taxable.

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

825: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
826: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
827: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
828: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
829: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
830: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
831: --
832: -- Adjust errors of non-taxable into taxable.
833: -- mtr_non_taxable_amount/mtr_taxable_amount must be integer values, no rounding required.

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

826: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
827: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
828: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
829: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
830: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
831: --
832: -- Adjust errors of non-taxable into taxable.
833: -- mtr_non_taxable_amount/mtr_taxable_amount must be integer values, no rounding required.
834: -- If there's decimal fraction, it is coding bug and should be fixed.

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

849: --
850: l_sal_si_wage := trunc(l_sal_si_wage / l_lcm);
851: l_mtr_si_wage := trunc(l_mtr_si_wage / l_lcm);
852: --
853: hr_utility.trace('***** after devide by ' || l_lcm || ' *****');
854: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
855: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
856: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
857: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);

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

850: l_sal_si_wage := trunc(l_sal_si_wage / l_lcm);
851: l_mtr_si_wage := trunc(l_mtr_si_wage / l_lcm);
852: --
853: hr_utility.trace('***** after devide by ' || l_lcm || ' *****');
854: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
855: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
856: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
857: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
858: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);

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

851: l_mtr_si_wage := trunc(l_mtr_si_wage / l_lcm);
852: --
853: hr_utility.trace('***** after devide by ' || l_lcm || ' *****');
854: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
855: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
856: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
857: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
858: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
859: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);

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

852: --
853: hr_utility.trace('***** after devide by ' || l_lcm || ' *****');
854: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
855: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
856: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
857: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
858: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
859: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
860: hr_utility.trace('l_sal_income : ' || l_sal_income);

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

853: hr_utility.trace('***** after devide by ' || l_lcm || ' *****');
854: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
855: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
856: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
857: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
858: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
859: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
860: hr_utility.trace('l_sal_income : ' || l_sal_income);
861: hr_utility.trace('l_mtr_income : ' || l_mtr_income);

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

854: hr_utility.trace('l_sal_taxable_amount : ' || l_sal_taxable_amount);
855: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
856: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
857: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
858: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
859: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
860: hr_utility.trace('l_sal_income : ' || l_sal_income);
861: hr_utility.trace('l_mtr_income : ' || l_mtr_income);
862: --

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

855: hr_utility.trace('l_sal_non_taxable_amount: ' || l_sal_non_taxable_amount);
856: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
857: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
858: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
859: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
860: hr_utility.trace('l_sal_income : ' || l_sal_income);
861: hr_utility.trace('l_mtr_income : ' || l_mtr_income);
862: --
863: -- This is just to ensure that payment is split correctly.

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

856: hr_utility.trace('l_mtr_taxable_amount : ' || l_mtr_taxable_amount);
857: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
858: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
859: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
860: hr_utility.trace('l_sal_income : ' || l_sal_income);
861: hr_utility.trace('l_mtr_income : ' || l_mtr_income);
862: --
863: -- This is just to ensure that payment is split correctly.
864: -- Errors will never be raised.

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

857: hr_utility.trace('l_mtr_non_taxable_amount: ' || l_mtr_non_taxable_amount);
858: hr_utility.trace('l_sal_si_wage : ' || l_sal_si_wage);
859: hr_utility.trace('l_mtr_si_wage : ' || l_mtr_si_wage);
860: hr_utility.trace('l_sal_income : ' || l_sal_income);
861: hr_utility.trace('l_mtr_income : ' || l_mtr_income);
862: --
863: -- This is just to ensure that payment is split correctly.
864: -- Errors will never be raised.
865: --

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

950: p_cma_rec.ui_wage_adj := null;
951: end if;
952: end if;
953: --
954: hr_utility.trace('***** output *****');
955: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
956: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
957: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
958: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);

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

951: end if;
952: end if;
953: --
954: hr_utility.trace('***** output *****');
955: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
956: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
957: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
958: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
959: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);

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

952: end if;
953: --
954: hr_utility.trace('***** output *****');
955: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
956: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
957: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
958: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
959: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
960: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);

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

953: --
954: hr_utility.trace('***** output *****');
955: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
956: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
957: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
958: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
959: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
960: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
961: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);

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

954: hr_utility.trace('***** output *****');
955: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
956: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
957: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
958: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
959: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
960: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
961: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
962: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);

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

955: hr_utility.trace('p.taxable_amount : ' || p_cma_rec.taxable_amount);
956: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
957: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
958: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
959: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
960: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
961: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
962: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
963: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);

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

956: hr_utility.trace('p.non_taxable_amount : ' || p_cma_rec.non_taxable_amount);
957: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
958: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
959: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
960: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
961: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
962: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
963: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
964: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);

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

957: hr_utility.trace('p.mtr_taxable_amount : ' || p_cma_rec.mtr_taxable_amount);
958: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
959: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
960: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
961: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
962: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
963: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
964: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
965: if p_record_exist then

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

958: hr_utility.trace('p.mtr_non_taxable_amount : ' || p_cma_rec.mtr_non_taxable_amount);
959: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
960: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
961: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
962: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
963: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
964: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
965: if p_record_exist then
966: hr_utility.trace('p_record_exist : TRUE');

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

959: hr_utility.trace('p.si_wage : ' || p_cma_rec.si_wage);
960: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
961: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
962: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
963: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
964: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
965: if p_record_exist then
966: hr_utility.trace('p_record_exist : TRUE');
967: else

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

960: hr_utility.trace('p.si_wage_adj : ' || p_cma_rec.si_wage_adj);
961: hr_utility.trace('p.mtr_si_wage : ' || p_cma_rec.mtr_si_wage);
962: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
963: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
964: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
965: if p_record_exist then
966: hr_utility.trace('p_record_exist : TRUE');
967: else
968: hr_utility.trace('p_record_exist : FALSE');

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

962: hr_utility.trace('p.mtr_si_wage_adj : ' || p_cma_rec.mtr_si_wage_adj);
963: hr_utility.trace('p.si_fixed_wage : ' || p_cma_rec.si_fixed_wage);
964: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
965: if p_record_exist then
966: hr_utility.trace('p_record_exist : TRUE');
967: else
968: hr_utility.trace('p_record_exist : FALSE');
969: end if;
970: --

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

964: hr_utility.trace('p.ui_wage_adj : ' || p_cma_rec.ui_wage_adj);
965: if p_record_exist then
966: hr_utility.trace('p_record_exist : TRUE');
967: else
968: hr_utility.trace('p_record_exist : FALSE');
969: end if;
970: --
971: hr_utility.set_location('Leaving: ' || c_proc, 100);
972: end get_cma_info;

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

967: else
968: hr_utility.trace('p_record_exist : FALSE');
969: end if;
970: --
971: hr_utility.set_location('Leaving: ' || c_proc, 100);
972: end get_cma_info;
973: --
974: end per_jp_cma_utility_pkg;