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

Line 51: hr_utility.set_location('Start of GET_PQP_LIMIT', 5);

47: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
48: (p_payroll_action_id));
49: END IF;
50:
51: hr_utility.set_location('Start of GET_PQP_LIMIT', 5);
52:
53: open Cur_403b_limit (l_effective_date);
54:
55: fetch Cur_403b_limit into

Line 70: hr_utility.set_message(801, 'PAY_PQP_LIMITS_NOT_DEFINED');

66:
67: if Cur_403b_limit%notfound then
68: close Cur_403b_limit;
69: -- Error : No limits defined for 403b
70: hr_utility.set_message(801, 'PAY_PQP_LIMITS_NOT_DEFINED');
71: hr_utility.raise_error;
72: return 0;
73: end if;
74:

Line 71: hr_utility.raise_error;

67: if Cur_403b_limit%notfound then
68: close Cur_403b_limit;
69: -- Error : No limits defined for 403b
70: hr_utility.set_message(801, 'PAY_PQP_LIMITS_NOT_DEFINED');
71: hr_utility.raise_error;
72: return 0;
73: end if;
74:
75: hr_utility.set_location('GET_PQP_LIMIT', 10);

Line 75: hr_utility.set_location('GET_PQP_LIMIT', 10);

71: hr_utility.raise_error;
72: return 0;
73: end if;
74:
75: hr_utility.set_location('GET_PQP_LIMIT', 10);
76:
77: l_limit_name := upper(p_limit);
78:
79: l_403b_limit := 0;

Line 103: hr_utility.set_location('GET_PQP_LIMIT',15);

99: end if;
100:
101: close Cur_403b_limit;
102:
103: hr_utility.set_location('GET_PQP_LIMIT',15);
104:
105:
106: return NVL(l_403b_limit,0);
107:

Line 126: hr_utility.set_location('Start of Calc_max_excl_allow ', 5);

122: l_effective_date date;
123: begin
124: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
125: (p_payroll_action_id));
126: hr_utility.set_location('Start of Calc_max_excl_allow ', 5);
127: max_excl_allow := (0.20 * p_ee_incld_annual_comp * p_years_of_service) -
128: p_total_er_contr_prior_years;
129:
130: hr_utility.set_location('End of Calc_max_excl_allow ', 10);

Line 130: hr_utility.set_location('End of Calc_max_excl_allow ', 10);

126: hr_utility.set_location('Start of Calc_max_excl_allow ', 5);
127: max_excl_allow := (0.20 * p_ee_incld_annual_comp * p_years_of_service) -
128: p_total_er_contr_prior_years;
129:
130: hr_utility.set_location('End of Calc_max_excl_allow ', 10);
131:
132: return max_excl_allow;
133: end;
134: --------------------------------------

Line 161: hr_utility.set_location('Start of Calc_overall_limit ', 5);

157: begin
158:
159: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
160: (p_payroll_action_id));
161: hr_utility.set_location('Start of Calc_overall_limit ', 5);
162:
163: l_incld_annual_comp_limit := pay_ff_functions.get_pqp_limit(
164: p_payroll_action_id =>p_payroll_action_id,
165: p_limit =>'includable_annual_comp_limit');

Line 187: hr_utility.set_location('End of Calc_overall_limit ',10);

183: if overall_limit > l_overall_er_limit then
184: overall_limit := l_overall_er_limit;
185: end if;
186:
187: hr_utility.set_location('End of Calc_overall_limit ',10);
188:
189: return overall_limit;
190:
191: end;

Line 215: hr_utility.set_location('Start of Calc_any_year_limit ', 5);

211: l_effective_date date; -- of the same name
212: begin
213: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
214: (p_payroll_action_id));
215: hr_utility.set_location('Start of Calc_any_year_limit ', 5);
216: l_additional_any_year_amount := pay_ff_functions.get_pqp_limit(
217: p_payroll_action_id=>p_payroll_action_id,
218: p_limit =>'additional_any_year_amount');
219:

Line 246: hr_utility.set_location('End of Calc_any_year_limit ', 5);

242: if this_limit > l_any_year_limit then
243: this_limit := l_any_year_limit;
244: end if;
245:
246: hr_utility.set_location('End of Calc_any_year_limit ', 5);
247:
248: return this_limit;
249:
250: end;

Line 349: hr_utility.set_message(801, 'PAY_YEAR_OF_SEP_LIMIT_FAILURE');

345: end if;
346:
347: exception
348: when others then
349: hr_utility.set_message(801, 'PAY_YEAR_OF_SEP_LIMIT_FAILURE');
350: -- probable cause is that the payroll has not been assigned to
351: -- the employee as of date of hire
352: hr_utility.raise_error;
353: return 0;

Line 352: hr_utility.raise_error;

348: when others then
349: hr_utility.set_message(801, 'PAY_YEAR_OF_SEP_LIMIT_FAILURE');
350: -- probable cause is that the payroll has not been assigned to
351: -- the employee as of date of hire
352: hr_utility.raise_error;
353: return 0;
354: end;
355: --
356: --

Line 622: hr_utility.set_location('Start of GET_457_LIMIT', 5);

618: ELSE
619: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
620: (p_payroll_action_id));
621: END IF;
622: hr_utility.set_location('Start of GET_457_LIMIT', 5);
623:
624: open Cur_457_limit (l_effective_date);
625:
626: fetch Cur_457_limit into

Line 634: hr_utility.set_message(801, 'PAY_PQP_LIMITS_NOT_DEFINED');

630:
631: if Cur_457_limit%notfound then
632: close Cur_457_limit;
633: -- Error : No limits defined for 457
634: hr_utility.set_message(801, 'PAY_PQP_LIMITS_NOT_DEFINED');
635: hr_utility.raise_error;
636: return 0;
637: end if;
638:

Line 635: hr_utility.raise_error;

631: if Cur_457_limit%notfound then
632: close Cur_457_limit;
633: -- Error : No limits defined for 457
634: hr_utility.set_message(801, 'PAY_PQP_LIMITS_NOT_DEFINED');
635: hr_utility.raise_error;
636: return 0;
637: end if;
638:
639: hr_utility.set_location('GET_457_LIMIT', 10);

Line 639: hr_utility.set_location('GET_457_LIMIT', 10);

635: hr_utility.raise_error;
636: return 0;
637: end if;
638:
639: hr_utility.set_location('GET_457_LIMIT', 10);
640:
641: l_limit_name := upper(p_limit);
642:
643: l_457_limit := 0;

Line 655: hr_utility.set_location('GET_457_LIMIT',15);

651: end if;
652:
653: close Cur_457_limit;
654:
655: hr_utility.set_location('GET_457_LIMIT',15);
656:
657:
658: return l_457_limit;
659:

Line 715: hr_utility.set_location('Start of get_457_calc_limit ', 5);

711: l_effective_date date;
712: begin
713: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
714: (p_payroll_action_id));
715: hr_utility.set_location('Start of get_457_calc_limit ', 5);
716:
717: l_calc_457_limit := (p_ee_incld_annual_comp / 3) ;
718:
719: hr_utility.set_location('End of get_457_calc_limit', 10);

Line 719: hr_utility.set_location('End of get_457_calc_limit', 10);

715: hr_utility.set_location('Start of get_457_calc_limit ', 5);
716:
717: l_calc_457_limit := (p_ee_incld_annual_comp / 3) ;
718:
719: hr_utility.set_location('End of get_457_calc_limit', 10);
720:
721: return l_calc_457_limit;
722: end;
723:

Line 736: hr_utility.set_location('Start of get_457_vested_amt ', 5);

732: l_effective_date date;
733: begin
734: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
735: (p_payroll_action_id));
736: hr_utility.set_location('Start of get_457_vested_amt ', 5);
737:
738: return 0;
739:
740: hr_utility.set_location('End of get_457_vested_amt', 10);

Line 740: hr_utility.set_location('End of get_457_vested_amt', 10);

736: hr_utility.set_location('Start of get_457_vested_amt ', 5);
737:
738: return 0;
739:
740: hr_utility.set_location('End of get_457_vested_amt', 10);
741:
742: end;
743:
744: --------------------------------------------------------------------------

Line 758: hr_utility.set_location('Start of Run Year ', 5);

754: l_effective_date date;
755: begin
756: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
757: (p_payroll_action_id));
758: hr_utility.set_location('Start of Run Year ', 5);
759: return to_number(to_char(l_effective_date,'YYYY'));
760: hr_utility.set_location('End of Run Year ', 10);
761:
762: end;

Line 760: hr_utility.set_location('End of Run Year ', 10);

756: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
757: (p_payroll_action_id));
758: hr_utility.set_location('Start of Run Year ', 5);
759: return to_number(to_char(l_effective_date,'YYYY'));
760: hr_utility.set_location('End of Run Year ', 10);
761:
762: end;
763: --------------------------------------------------------------------------
764:

Line 797: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);

793:
794: /*
795: * Value of the Parameters passed
796: */
797: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);
798: hr_utility.trace('Template Earnings = ' || p_template_earnings);
799: hr_utility.trace('Accrued Value = ' || p_accrued_value);
800: hr_utility.trace('Maximum Amount = ' || p_maximum_amount);
801: hr_utility.trace('Prorate Start Date = ' || p_prorate_start_date);

Line 798: hr_utility.trace('Template Earnings = ' || p_template_earnings);

794: /*
795: * Value of the Parameters passed
796: */
797: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);
798: hr_utility.trace('Template Earnings = ' || p_template_earnings);
799: hr_utility.trace('Accrued Value = ' || p_accrued_value);
800: hr_utility.trace('Maximum Amount = ' || p_maximum_amount);
801: hr_utility.trace('Prorate Start Date = ' || p_prorate_start_date);
802: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);

Line 799: hr_utility.trace('Accrued Value = ' || p_accrued_value);

795: * Value of the Parameters passed
796: */
797: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);
798: hr_utility.trace('Template Earnings = ' || p_template_earnings);
799: hr_utility.trace('Accrued Value = ' || p_accrued_value);
800: hr_utility.trace('Maximum Amount = ' || p_maximum_amount);
801: hr_utility.trace('Prorate Start Date = ' || p_prorate_start_date);
802: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);
803: hr_utility.trace('Payroll Start Date = ' || p_payroll_start_date);

Line 800: hr_utility.trace('Maximum Amount = ' || p_maximum_amount);

796: */
797: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);
798: hr_utility.trace('Template Earnings = ' || p_template_earnings);
799: hr_utility.trace('Accrued Value = ' || p_accrued_value);
800: hr_utility.trace('Maximum Amount = ' || p_maximum_amount);
801: hr_utility.trace('Prorate Start Date = ' || p_prorate_start_date);
802: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);
803: hr_utility.trace('Payroll Start Date = ' || p_payroll_start_date);
804: hr_utility.trace('Payroll End Date = ' || p_payroll_end_date);

Line 801: hr_utility.trace('Prorate Start Date = ' || p_prorate_start_date);

797: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);
798: hr_utility.trace('Template Earnings = ' || p_template_earnings);
799: hr_utility.trace('Accrued Value = ' || p_accrued_value);
800: hr_utility.trace('Maximum Amount = ' || p_maximum_amount);
801: hr_utility.trace('Prorate Start Date = ' || p_prorate_start_date);
802: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);
803: hr_utility.trace('Payroll Start Date = ' || p_payroll_start_date);
804: hr_utility.trace('Payroll End Date = ' || p_payroll_end_date);
805:

Line 802: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);

798: hr_utility.trace('Template Earnings = ' || p_template_earnings);
799: hr_utility.trace('Accrued Value = ' || p_accrued_value);
800: hr_utility.trace('Maximum Amount = ' || p_maximum_amount);
801: hr_utility.trace('Prorate Start Date = ' || p_prorate_start_date);
802: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);
803: hr_utility.trace('Payroll Start Date = ' || p_payroll_start_date);
804: hr_utility.trace('Payroll End Date = ' || p_payroll_end_date);
805:
806: /*

Line 803: hr_utility.trace('Payroll Start Date = ' || p_payroll_start_date);

799: hr_utility.trace('Accrued Value = ' || p_accrued_value);
800: hr_utility.trace('Maximum Amount = ' || p_maximum_amount);
801: hr_utility.trace('Prorate Start Date = ' || p_prorate_start_date);
802: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);
803: hr_utility.trace('Payroll Start Date = ' || p_payroll_start_date);
804: hr_utility.trace('Payroll End Date = ' || p_payroll_end_date);
805:
806: /*
807: * Resetting the Global variables whenever a new element is getting processed

Line 804: hr_utility.trace('Payroll End Date = ' || p_payroll_end_date);

800: hr_utility.trace('Maximum Amount = ' || p_maximum_amount);
801: hr_utility.trace('Prorate Start Date = ' || p_prorate_start_date);
802: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);
803: hr_utility.trace('Payroll Start Date = ' || p_payroll_start_date);
804: hr_utility.trace('Payroll End Date = ' || p_payroll_end_date);
805:
806: /*
807: * Resetting the Global variables whenever a new element is getting processed
808: */

Line 888: hr_utility.trace('Calculated Earnings = ' || ln_template_earnings);

884: p_stop_entry_flag := 'Y';
885: end if;
886: end if;
887:
888: hr_utility.trace('Calculated Earnings = ' || ln_template_earnings);
889: hr_utility.trace('');
890: -- hr_utility.trace_off();
891:
892: return to_number(ln_template_earnings);

Line 889: hr_utility.trace('');

885: end if;
886: end if;
887:
888: hr_utility.trace('Calculated Earnings = ' || ln_template_earnings);
889: hr_utility.trace('');
890: -- hr_utility.trace_off();
891:
892: return to_number(ln_template_earnings);
893: end;

Line 890: -- hr_utility.trace_off();

886: end if;
887:
888: hr_utility.trace('Calculated Earnings = ' || ln_template_earnings);
889: hr_utility.trace('');
890: -- hr_utility.trace_off();
891:
892: return to_number(ln_template_earnings);
893: end;
894:

Line 924: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);

920:
921: /*
922: * Value of the Parameters passed
923: */
924: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);
925: hr_utility.trace('Auth End Date = ' || p_auth_end_date);
926: hr_utility.trace('Prorate Start Date = ' || p_prorate_end_date);
927: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);
928:

Line 925: hr_utility.trace('Auth End Date = ' || p_auth_end_date);

921: /*
922: * Value of the Parameters passed
923: */
924: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);
925: hr_utility.trace('Auth End Date = ' || p_auth_end_date);
926: hr_utility.trace('Prorate Start Date = ' || p_prorate_end_date);
927: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);
928:
929: /*

Line 926: hr_utility.trace('Prorate Start Date = ' || p_prorate_end_date);

922: * Value of the Parameters passed
923: */
924: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);
925: hr_utility.trace('Auth End Date = ' || p_auth_end_date);
926: hr_utility.trace('Prorate Start Date = ' || p_prorate_end_date);
927: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);
928:
929: /*
930: * Get the element entry start dates and end dates

Line 927: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);

923: */
924: hr_utility.trace('Original Entry ID = ' || p_ctx_original_entry_id);
925: hr_utility.trace('Auth End Date = ' || p_auth_end_date);
926: hr_utility.trace('Prorate Start Date = ' || p_prorate_end_date);
927: hr_utility.trace('Prorate End Date = ' || p_prorate_end_date);
928:
929: /*
930: * Get the element entry start dates and end dates
931: * to correctly set the Global variables

Line 988: hr_utility.trace('Entering GET_CORRECT_FLSA_EARNINGS');

984: l_amt_difference number;
985:
986: begin
987:
988: hr_utility.trace('Entering GET_CORRECT_FLSA_EARNINGS');
989: hr_utility.trace('ASSIGNMENT ACTION ID.....' || p_ctx_asg_action_id);
990: hr_utility.trace('ORIGINAL ENTRY ID........' || p_ctx_original_entry_id);
991: hr_utility.trace('ADJUST FLAG..............' || p_adjust_flag);
992: hr_utility.trace('MAX ADJUST AMOUNT .......' || p_max_adjust_amount);

Line 989: hr_utility.trace('ASSIGNMENT ACTION ID.....' || p_ctx_asg_action_id);

985:
986: begin
987:
988: hr_utility.trace('Entering GET_CORRECT_FLSA_EARNINGS');
989: hr_utility.trace('ASSIGNMENT ACTION ID.....' || p_ctx_asg_action_id);
990: hr_utility.trace('ORIGINAL ENTRY ID........' || p_ctx_original_entry_id);
991: hr_utility.trace('ADJUST FLAG..............' || p_adjust_flag);
992: hr_utility.trace('MAX ADJUST AMOUNT .......' || p_max_adjust_amount);
993: hr_utility.trace('TOTAL EARNINGS...........' || p_total_earnings);

Line 990: hr_utility.trace('ORIGINAL ENTRY ID........' || p_ctx_original_entry_id);

986: begin
987:
988: hr_utility.trace('Entering GET_CORRECT_FLSA_EARNINGS');
989: hr_utility.trace('ASSIGNMENT ACTION ID.....' || p_ctx_asg_action_id);
990: hr_utility.trace('ORIGINAL ENTRY ID........' || p_ctx_original_entry_id);
991: hr_utility.trace('ADJUST FLAG..............' || p_adjust_flag);
992: hr_utility.trace('MAX ADJUST AMOUNT .......' || p_max_adjust_amount);
993: hr_utility.trace('TOTAL EARNINGS...........' || p_total_earnings);
994: hr_utility.trace('PERIOD EARNINGS..........' || p_period_earnings);

Line 991: hr_utility.trace('ADJUST FLAG..............' || p_adjust_flag);

987:
988: hr_utility.trace('Entering GET_CORRECT_FLSA_EARNINGS');
989: hr_utility.trace('ASSIGNMENT ACTION ID.....' || p_ctx_asg_action_id);
990: hr_utility.trace('ORIGINAL ENTRY ID........' || p_ctx_original_entry_id);
991: hr_utility.trace('ADJUST FLAG..............' || p_adjust_flag);
992: hr_utility.trace('MAX ADJUST AMOUNT .......' || p_max_adjust_amount);
993: hr_utility.trace('TOTAL EARNINGS...........' || p_total_earnings);
994: hr_utility.trace('PERIOD EARNINGS..........' || p_period_earnings);
995: hr_utility.trace('PRORATE END DATE.........' || p_prorate_end_date);

Line 992: hr_utility.trace('MAX ADJUST AMOUNT .......' || p_max_adjust_amount);

988: hr_utility.trace('Entering GET_CORRECT_FLSA_EARNINGS');
989: hr_utility.trace('ASSIGNMENT ACTION ID.....' || p_ctx_asg_action_id);
990: hr_utility.trace('ORIGINAL ENTRY ID........' || p_ctx_original_entry_id);
991: hr_utility.trace('ADJUST FLAG..............' || p_adjust_flag);
992: hr_utility.trace('MAX ADJUST AMOUNT .......' || p_max_adjust_amount);
993: hr_utility.trace('TOTAL EARNINGS...........' || p_total_earnings);
994: hr_utility.trace('PERIOD EARNINGS..........' || p_period_earnings);
995: hr_utility.trace('PRORATE END DATE.........' || p_prorate_end_date);
996: hr_utility.trace('PAYROLL END DATE.........' || p_payroll_end_date);

Line 993: hr_utility.trace('TOTAL EARNINGS...........' || p_total_earnings);

989: hr_utility.trace('ASSIGNMENT ACTION ID.....' || p_ctx_asg_action_id);
990: hr_utility.trace('ORIGINAL ENTRY ID........' || p_ctx_original_entry_id);
991: hr_utility.trace('ADJUST FLAG..............' || p_adjust_flag);
992: hr_utility.trace('MAX ADJUST AMOUNT .......' || p_max_adjust_amount);
993: hr_utility.trace('TOTAL EARNINGS...........' || p_total_earnings);
994: hr_utility.trace('PERIOD EARNINGS..........' || p_period_earnings);
995: hr_utility.trace('PRORATE END DATE.........' || p_prorate_end_date);
996: hr_utility.trace('PAYROLL END DATE.........' || p_payroll_end_date);
997: hr_utility.trace('GLB_ORIGINAL_ENTRY_ID_2..' || GLB_ORIGINAL_ENTRY_ID_2);

Line 994: hr_utility.trace('PERIOD EARNINGS..........' || p_period_earnings);

990: hr_utility.trace('ORIGINAL ENTRY ID........' || p_ctx_original_entry_id);
991: hr_utility.trace('ADJUST FLAG..............' || p_adjust_flag);
992: hr_utility.trace('MAX ADJUST AMOUNT .......' || p_max_adjust_amount);
993: hr_utility.trace('TOTAL EARNINGS...........' || p_total_earnings);
994: hr_utility.trace('PERIOD EARNINGS..........' || p_period_earnings);
995: hr_utility.trace('PRORATE END DATE.........' || p_prorate_end_date);
996: hr_utility.trace('PAYROLL END DATE.........' || p_payroll_end_date);
997: hr_utility.trace('GLB_ORIGINAL_ENTRY_ID_2..' || GLB_ORIGINAL_ENTRY_ID_2);
998: hr_utility.trace('GLB_PERIOD_EARNINGS..' || GLB_PERIOD_EARNINGS);

Line 995: hr_utility.trace('PRORATE END DATE.........' || p_prorate_end_date);

991: hr_utility.trace('ADJUST FLAG..............' || p_adjust_flag);
992: hr_utility.trace('MAX ADJUST AMOUNT .......' || p_max_adjust_amount);
993: hr_utility.trace('TOTAL EARNINGS...........' || p_total_earnings);
994: hr_utility.trace('PERIOD EARNINGS..........' || p_period_earnings);
995: hr_utility.trace('PRORATE END DATE.........' || p_prorate_end_date);
996: hr_utility.trace('PAYROLL END DATE.........' || p_payroll_end_date);
997: hr_utility.trace('GLB_ORIGINAL_ENTRY_ID_2..' || GLB_ORIGINAL_ENTRY_ID_2);
998: hr_utility.trace('GLB_PERIOD_EARNINGS..' || GLB_PERIOD_EARNINGS);
999: hr_utility.trace('GLB_ASSIGNMENT_ACTION_ID..' || GLB_ASSIGNMENT_ACTION_ID);

Line 996: hr_utility.trace('PAYROLL END DATE.........' || p_payroll_end_date);

992: hr_utility.trace('MAX ADJUST AMOUNT .......' || p_max_adjust_amount);
993: hr_utility.trace('TOTAL EARNINGS...........' || p_total_earnings);
994: hr_utility.trace('PERIOD EARNINGS..........' || p_period_earnings);
995: hr_utility.trace('PRORATE END DATE.........' || p_prorate_end_date);
996: hr_utility.trace('PAYROLL END DATE.........' || p_payroll_end_date);
997: hr_utility.trace('GLB_ORIGINAL_ENTRY_ID_2..' || GLB_ORIGINAL_ENTRY_ID_2);
998: hr_utility.trace('GLB_PERIOD_EARNINGS..' || GLB_PERIOD_EARNINGS);
999: hr_utility.trace('GLB_ASSIGNMENT_ACTION_ID..' || GLB_ASSIGNMENT_ACTION_ID);
1000:

Line 997: hr_utility.trace('GLB_ORIGINAL_ENTRY_ID_2..' || GLB_ORIGINAL_ENTRY_ID_2);

993: hr_utility.trace('TOTAL EARNINGS...........' || p_total_earnings);
994: hr_utility.trace('PERIOD EARNINGS..........' || p_period_earnings);
995: hr_utility.trace('PRORATE END DATE.........' || p_prorate_end_date);
996: hr_utility.trace('PAYROLL END DATE.........' || p_payroll_end_date);
997: hr_utility.trace('GLB_ORIGINAL_ENTRY_ID_2..' || GLB_ORIGINAL_ENTRY_ID_2);
998: hr_utility.trace('GLB_PERIOD_EARNINGS..' || GLB_PERIOD_EARNINGS);
999: hr_utility.trace('GLB_ASSIGNMENT_ACTION_ID..' || GLB_ASSIGNMENT_ACTION_ID);
1000:
1001: l_period_earnings := 0;

Line 998: hr_utility.trace('GLB_PERIOD_EARNINGS..' || GLB_PERIOD_EARNINGS);

994: hr_utility.trace('PERIOD EARNINGS..........' || p_period_earnings);
995: hr_utility.trace('PRORATE END DATE.........' || p_prorate_end_date);
996: hr_utility.trace('PAYROLL END DATE.........' || p_payroll_end_date);
997: hr_utility.trace('GLB_ORIGINAL_ENTRY_ID_2..' || GLB_ORIGINAL_ENTRY_ID_2);
998: hr_utility.trace('GLB_PERIOD_EARNINGS..' || GLB_PERIOD_EARNINGS);
999: hr_utility.trace('GLB_ASSIGNMENT_ACTION_ID..' || GLB_ASSIGNMENT_ACTION_ID);
1000:
1001: l_period_earnings := 0;
1002:

Line 999: hr_utility.trace('GLB_ASSIGNMENT_ACTION_ID..' || GLB_ASSIGNMENT_ACTION_ID);

995: hr_utility.trace('PRORATE END DATE.........' || p_prorate_end_date);
996: hr_utility.trace('PAYROLL END DATE.........' || p_payroll_end_date);
997: hr_utility.trace('GLB_ORIGINAL_ENTRY_ID_2..' || GLB_ORIGINAL_ENTRY_ID_2);
998: hr_utility.trace('GLB_PERIOD_EARNINGS..' || GLB_PERIOD_EARNINGS);
999: hr_utility.trace('GLB_ASSIGNMENT_ACTION_ID..' || GLB_ASSIGNMENT_ACTION_ID);
1000:
1001: l_period_earnings := 0;
1002:
1003: -- Resetting Global variables if required

Line 1022: hr_utility.trace('Initializing Variables');

1018: GLB_ORIGINAL_ENTRY_ID_2 := -9999;
1019: end if;
1020:
1021: if GLB_ORIGINAL_ENTRY_ID_2 <> p_ctx_original_entry_id then
1022: hr_utility.trace('Initializing Variables');
1023: GLB_ORIGINAL_ENTRY_ID_2 := p_ctx_original_entry_id;
1024: GLB_PERIOD_EARNINGS := 0;
1025: end if;
1026:

Line 1032: hr_utility.trace('Difference = ' || l_amt_difference);

1028: -- during the last FLSA Period
1029: if p_adjust_flag = 'Y' then
1030: if p_payroll_end_date = p_prorate_end_date then
1031: l_amt_difference := p_total_earnings - GLB_PERIOD_EARNINGS - p_period_earnings;
1032: hr_utility.trace('Difference = ' || l_amt_difference);
1033:
1034: /* Added condition l_amt_difference > 0 for Bug#9668801 */
1035: if (l_amt_difference < p_max_adjust_amount
1036: and l_amt_difference > 0) then

Line 1038: hr_utility.trace('l_period_earnings1 = ' || l_period_earnings);

1034: /* Added condition l_amt_difference > 0 for Bug#9668801 */
1035: if (l_amt_difference < p_max_adjust_amount
1036: and l_amt_difference > 0) then
1037: l_period_earnings := p_total_earnings - GLB_PERIOD_EARNINGS;
1038: hr_utility.trace('l_period_earnings1 = ' || l_period_earnings);
1039: else
1040: l_period_earnings := round(p_period_earnings,2);
1041: hr_utility.trace('l_period_earnings1 = ' || l_period_earnings);
1042: end if;

Line 1041: hr_utility.trace('l_period_earnings1 = ' || l_period_earnings);

1037: l_period_earnings := p_total_earnings - GLB_PERIOD_EARNINGS;
1038: hr_utility.trace('l_period_earnings1 = ' || l_period_earnings);
1039: else
1040: l_period_earnings := round(p_period_earnings,2);
1041: hr_utility.trace('l_period_earnings1 = ' || l_period_earnings);
1042: end if;
1043: else
1044: l_period_earnings := round(p_period_earnings,2);
1045: GLB_PERIOD_EARNINGS := GLB_PERIOD_EARNINGS + l_period_earnings;

Line 1046: hr_utility.trace('l_period_earnings2 = ' || l_period_earnings);

1042: end if;
1043: else
1044: l_period_earnings := round(p_period_earnings,2);
1045: GLB_PERIOD_EARNINGS := GLB_PERIOD_EARNINGS + l_period_earnings;
1046: hr_utility.trace('l_period_earnings2 = ' || l_period_earnings);
1047: hr_utility.trace('GLB_PERIOD_EARNINGS = ' || GLB_PERIOD_EARNINGS);
1048: end if; -- if p_payroll_end_date
1049: else
1050: l_period_earnings := p_period_earnings;

Line 1047: hr_utility.trace('GLB_PERIOD_EARNINGS = ' || GLB_PERIOD_EARNINGS);

1043: else
1044: l_period_earnings := round(p_period_earnings,2);
1045: GLB_PERIOD_EARNINGS := GLB_PERIOD_EARNINGS + l_period_earnings;
1046: hr_utility.trace('l_period_earnings2 = ' || l_period_earnings);
1047: hr_utility.trace('GLB_PERIOD_EARNINGS = ' || GLB_PERIOD_EARNINGS);
1048: end if; -- if p_payroll_end_date
1049: else
1050: l_period_earnings := p_period_earnings;
1051: hr_utility.trace('No Adjustment Done');

Line 1051: hr_utility.trace('No Adjustment Done');

1047: hr_utility.trace('GLB_PERIOD_EARNINGS = ' || GLB_PERIOD_EARNINGS);
1048: end if; -- if p_payroll_end_date
1049: else
1050: l_period_earnings := p_period_earnings;
1051: hr_utility.trace('No Adjustment Done');
1052: end if; -- if p_adjust_flag = 'Y'
1053:
1054: return l_period_earnings;
1055:

Line 1145: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID = ' || GLB_RR_ORIGINAL_ENTRY_ID);

1141:
1142: begin
1143:
1144: -- Value of the Parameters passed
1145: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID = ' || GLB_RR_ORIGINAL_ENTRY_ID);
1146: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = ' || GLB_RR_SAL_BASIS_ELEMENT);
1147: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1148: hr_utility.trace('stop_run_flag = ' || stop_run_flag);
1149:

Line 1146: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = ' || GLB_RR_SAL_BASIS_ELEMENT);

1142: begin
1143:
1144: -- Value of the Parameters passed
1145: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID = ' || GLB_RR_ORIGINAL_ENTRY_ID);
1146: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = ' || GLB_RR_SAL_BASIS_ELEMENT);
1147: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1148: hr_utility.trace('stop_run_flag = ' || stop_run_flag);
1149:
1150: hr_utility.trace('Original Entry ID = ' || original_entry_id);

Line 1147: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);

1143:
1144: -- Value of the Parameters passed
1145: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID = ' || GLB_RR_ORIGINAL_ENTRY_ID);
1146: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = ' || GLB_RR_SAL_BASIS_ELEMENT);
1147: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1148: hr_utility.trace('stop_run_flag = ' || stop_run_flag);
1149:
1150: hr_utility.trace('Original Entry ID = ' || original_entry_id);
1151: hr_utility.trace('Template Earning = ' || template_earning);

Line 1148: hr_utility.trace('stop_run_flag = ' || stop_run_flag);

1144: -- Value of the Parameters passed
1145: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID = ' || GLB_RR_ORIGINAL_ENTRY_ID);
1146: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = ' || GLB_RR_SAL_BASIS_ELEMENT);
1147: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1148: hr_utility.trace('stop_run_flag = ' || stop_run_flag);
1149:
1150: hr_utility.trace('Original Entry ID = ' || original_entry_id);
1151: hr_utility.trace('Template Earning = ' || template_earning);
1152: hr_utility.trace('hours_passed = ' || hours_passed);

Line 1150: hr_utility.trace('Original Entry ID = ' || original_entry_id);

1146: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = ' || GLB_RR_SAL_BASIS_ELEMENT);
1147: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1148: hr_utility.trace('stop_run_flag = ' || stop_run_flag);
1149:
1150: hr_utility.trace('Original Entry ID = ' || original_entry_id);
1151: hr_utility.trace('Template Earning = ' || template_earning);
1152: hr_utility.trace('hours_passed = ' || hours_passed);
1153: hr_utility.trace('red_reg_earnings = ' || red_reg_earnings);
1154: hr_utility.trace('red_reg_hours = ' || red_reg_hours);

Line 1151: hr_utility.trace('Template Earning = ' || template_earning);

1147: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1148: hr_utility.trace('stop_run_flag = ' || stop_run_flag);
1149:
1150: hr_utility.trace('Original Entry ID = ' || original_entry_id);
1151: hr_utility.trace('Template Earning = ' || template_earning);
1152: hr_utility.trace('hours_passed = ' || hours_passed);
1153: hr_utility.trace('red_reg_earnings = ' || red_reg_earnings);
1154: hr_utility.trace('red_reg_hours = ' || red_reg_hours);
1155: hr_utility.trace('Prorate Start Date = ' || prorate_start);

Line 1152: hr_utility.trace('hours_passed = ' || hours_passed);

1148: hr_utility.trace('stop_run_flag = ' || stop_run_flag);
1149:
1150: hr_utility.trace('Original Entry ID = ' || original_entry_id);
1151: hr_utility.trace('Template Earning = ' || template_earning);
1152: hr_utility.trace('hours_passed = ' || hours_passed);
1153: hr_utility.trace('red_reg_earnings = ' || red_reg_earnings);
1154: hr_utility.trace('red_reg_hours = ' || red_reg_hours);
1155: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1156: hr_utility.trace('Prorate End Date = ' || prorate_end);

Line 1153: hr_utility.trace('red_reg_earnings = ' || red_reg_earnings);

1149:
1150: hr_utility.trace('Original Entry ID = ' || original_entry_id);
1151: hr_utility.trace('Template Earning = ' || template_earning);
1152: hr_utility.trace('hours_passed = ' || hours_passed);
1153: hr_utility.trace('red_reg_earnings = ' || red_reg_earnings);
1154: hr_utility.trace('red_reg_hours = ' || red_reg_hours);
1155: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1156: hr_utility.trace('Prorate End Date = ' || prorate_end);
1157: hr_utility.trace('Prorate Start Date = ' || prorate_start);

Line 1154: hr_utility.trace('red_reg_hours = ' || red_reg_hours);

1150: hr_utility.trace('Original Entry ID = ' || original_entry_id);
1151: hr_utility.trace('Template Earning = ' || template_earning);
1152: hr_utility.trace('hours_passed = ' || hours_passed);
1153: hr_utility.trace('red_reg_earnings = ' || red_reg_earnings);
1154: hr_utility.trace('red_reg_hours = ' || red_reg_hours);
1155: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1156: hr_utility.trace('Prorate End Date = ' || prorate_end);
1157: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1158: hr_utility.trace('Prorate End Date = ' || prorate_end);

Line 1155: hr_utility.trace('Prorate Start Date = ' || prorate_start);

1151: hr_utility.trace('Template Earning = ' || template_earning);
1152: hr_utility.trace('hours_passed = ' || hours_passed);
1153: hr_utility.trace('red_reg_earnings = ' || red_reg_earnings);
1154: hr_utility.trace('red_reg_hours = ' || red_reg_hours);
1155: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1156: hr_utility.trace('Prorate End Date = ' || prorate_end);
1157: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1158: hr_utility.trace('Prorate End Date = ' || prorate_end);
1159: hr_utility.trace('Payroll Start Date = ' || payroll_start_date);

Line 1156: hr_utility.trace('Prorate End Date = ' || prorate_end);

1152: hr_utility.trace('hours_passed = ' || hours_passed);
1153: hr_utility.trace('red_reg_earnings = ' || red_reg_earnings);
1154: hr_utility.trace('red_reg_hours = ' || red_reg_hours);
1155: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1156: hr_utility.trace('Prorate End Date = ' || prorate_end);
1157: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1158: hr_utility.trace('Prorate End Date = ' || prorate_end);
1159: hr_utility.trace('Payroll Start Date = ' || payroll_start_date);
1160: hr_utility.trace('Payroll End Date = ' || payroll_end_date);

Line 1157: hr_utility.trace('Prorate Start Date = ' || prorate_start);

1153: hr_utility.trace('red_reg_earnings = ' || red_reg_earnings);
1154: hr_utility.trace('red_reg_hours = ' || red_reg_hours);
1155: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1156: hr_utility.trace('Prorate End Date = ' || prorate_end);
1157: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1158: hr_utility.trace('Prorate End Date = ' || prorate_end);
1159: hr_utility.trace('Payroll Start Date = ' || payroll_start_date);
1160: hr_utility.trace('Payroll End Date = ' || payroll_end_date);
1161: hr_utility.trace('Flsa_time_definition = ' || flsa_time_definition);

Line 1158: hr_utility.trace('Prorate End Date = ' || prorate_end);

1154: hr_utility.trace('red_reg_hours = ' || red_reg_hours);
1155: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1156: hr_utility.trace('Prorate End Date = ' || prorate_end);
1157: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1158: hr_utility.trace('Prorate End Date = ' || prorate_end);
1159: hr_utility.trace('Payroll Start Date = ' || payroll_start_date);
1160: hr_utility.trace('Payroll End Date = ' || payroll_end_date);
1161: hr_utility.trace('Flsa_time_definition = ' || flsa_time_definition);
1162: hr_utility.trace('red_reg_adjust_amount = ' || red_reg_adjust_amount);

Line 1159: hr_utility.trace('Payroll Start Date = ' || payroll_start_date);

1155: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1156: hr_utility.trace('Prorate End Date = ' || prorate_end);
1157: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1158: hr_utility.trace('Prorate End Date = ' || prorate_end);
1159: hr_utility.trace('Payroll Start Date = ' || payroll_start_date);
1160: hr_utility.trace('Payroll End Date = ' || payroll_end_date);
1161: hr_utility.trace('Flsa_time_definition = ' || flsa_time_definition);
1162: hr_utility.trace('red_reg_adjust_amount = ' || red_reg_adjust_amount);
1163: hr_utility.trace('red_reg_adjust_hours = ' || red_reg_adjust_hours);

Line 1160: hr_utility.trace('Payroll End Date = ' || payroll_end_date);

1156: hr_utility.trace('Prorate End Date = ' || prorate_end);
1157: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1158: hr_utility.trace('Prorate End Date = ' || prorate_end);
1159: hr_utility.trace('Payroll Start Date = ' || payroll_start_date);
1160: hr_utility.trace('Payroll End Date = ' || payroll_end_date);
1161: hr_utility.trace('Flsa_time_definition = ' || flsa_time_definition);
1162: hr_utility.trace('red_reg_adjust_amount = ' || red_reg_adjust_amount);
1163: hr_utility.trace('red_reg_adjust_hours = ' || red_reg_adjust_hours);
1164: hr_utility.trace('red_reg_raise_error = ' || red_reg_raise_error);

Line 1161: hr_utility.trace('Flsa_time_definition = ' || flsa_time_definition);

1157: hr_utility.trace('Prorate Start Date = ' || prorate_start);
1158: hr_utility.trace('Prorate End Date = ' || prorate_end);
1159: hr_utility.trace('Payroll Start Date = ' || payroll_start_date);
1160: hr_utility.trace('Payroll End Date = ' || payroll_end_date);
1161: hr_utility.trace('Flsa_time_definition = ' || flsa_time_definition);
1162: hr_utility.trace('red_reg_adjust_amount = ' || red_reg_adjust_amount);
1163: hr_utility.trace('red_reg_adjust_hours = ' || red_reg_adjust_hours);
1164: hr_utility.trace('red_reg_raise_error = ' || red_reg_raise_error);
1165:

Line 1162: hr_utility.trace('red_reg_adjust_amount = ' || red_reg_adjust_amount);

1158: hr_utility.trace('Prorate End Date = ' || prorate_end);
1159: hr_utility.trace('Payroll Start Date = ' || payroll_start_date);
1160: hr_utility.trace('Payroll End Date = ' || payroll_end_date);
1161: hr_utility.trace('Flsa_time_definition = ' || flsa_time_definition);
1162: hr_utility.trace('red_reg_adjust_amount = ' || red_reg_adjust_amount);
1163: hr_utility.trace('red_reg_adjust_hours = ' || red_reg_adjust_hours);
1164: hr_utility.trace('red_reg_raise_error = ' || red_reg_raise_error);
1165:
1166: ln_reduced_hours_passed := 0;

Line 1163: hr_utility.trace('red_reg_adjust_hours = ' || red_reg_adjust_hours);

1159: hr_utility.trace('Payroll Start Date = ' || payroll_start_date);
1160: hr_utility.trace('Payroll End Date = ' || payroll_end_date);
1161: hr_utility.trace('Flsa_time_definition = ' || flsa_time_definition);
1162: hr_utility.trace('red_reg_adjust_amount = ' || red_reg_adjust_amount);
1163: hr_utility.trace('red_reg_adjust_hours = ' || red_reg_adjust_hours);
1164: hr_utility.trace('red_reg_raise_error = ' || red_reg_raise_error);
1165:
1166: ln_reduced_hours_passed := 0;
1167: ln_reduced_template_earnings := 0;

Line 1164: hr_utility.trace('red_reg_raise_error = ' || red_reg_raise_error);

1160: hr_utility.trace('Payroll End Date = ' || payroll_end_date);
1161: hr_utility.trace('Flsa_time_definition = ' || flsa_time_definition);
1162: hr_utility.trace('red_reg_adjust_amount = ' || red_reg_adjust_amount);
1163: hr_utility.trace('red_reg_adjust_hours = ' || red_reg_adjust_hours);
1164: hr_utility.trace('red_reg_raise_error = ' || red_reg_raise_error);
1165:
1166: ln_reduced_hours_passed := 0;
1167: ln_reduced_template_earnings := 0;
1168:

Line 1178: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID = '

1174: stop_run_flag := 'N' ;
1175: ln_reduced_hours_passed := 0;
1176: ln_reduced_template_earnings := 0;
1177:
1178: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID = '
1179: || GLB_RR_ORIGINAL_ENTRY_ID);
1180: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = '
1181: || GLB_RR_SAL_BASIS_ELEMENT);
1182: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);

Line 1180: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = '

1176: ln_reduced_template_earnings := 0;
1177:
1178: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID = '
1179: || GLB_RR_ORIGINAL_ENTRY_ID);
1180: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = '
1181: || GLB_RR_SAL_BASIS_ELEMENT);
1182: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1183: hr_utility.trace('stop_run_flag = '|| stop_run_flag);
1184: end if; -- if GLB_RR_ORIGINAL_ENTRY_ID

Line 1182: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);

1178: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID = '
1179: || GLB_RR_ORIGINAL_ENTRY_ID);
1180: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = '
1181: || GLB_RR_SAL_BASIS_ELEMENT);
1182: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1183: hr_utility.trace('stop_run_flag = '|| stop_run_flag);
1184: end if; -- if GLB_RR_ORIGINAL_ENTRY_ID
1185:
1186: if GLB_RR_ORIGINAL_ENTRY_ID <> original_entry_id then

Line 1183: hr_utility.trace('stop_run_flag = '|| stop_run_flag);

1179: || GLB_RR_ORIGINAL_ENTRY_ID);
1180: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT = '
1181: || GLB_RR_SAL_BASIS_ELEMENT);
1182: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1183: hr_utility.trace('stop_run_flag = '|| stop_run_flag);
1184: end if; -- if GLB_RR_ORIGINAL_ENTRY_ID
1185:
1186: if GLB_RR_ORIGINAL_ENTRY_ID <> original_entry_id then
1187: GLB_RR_ORIGINAL_ENTRY_ID := original_entry_id ;

Line 1195: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID Reset = '

1191: stop_run_flag := 'N' ;
1192: ln_reduced_hours_passed := 0;
1193: ln_reduced_template_earnings := 0;
1194:
1195: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID Reset = '
1196: || GLB_RR_ORIGINAL_ENTRY_ID);
1197: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT Reset = '
1198: || GLB_RR_SAL_BASIS_ELEMENT);
1199: hr_utility.trace('GLB_RED_REG_ELE Reset = ' || GLB_RED_REG_ELE);

Line 1197: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT Reset = '

1193: ln_reduced_template_earnings := 0;
1194:
1195: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID Reset = '
1196: || GLB_RR_ORIGINAL_ENTRY_ID);
1197: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT Reset = '
1198: || GLB_RR_SAL_BASIS_ELEMENT);
1199: hr_utility.trace('GLB_RED_REG_ELE Reset = ' || GLB_RED_REG_ELE);
1200: hr_utility.trace('stop_run_flag Reset = ' || stop_run_flag);
1201:

Line 1199: hr_utility.trace('GLB_RED_REG_ELE Reset = ' || GLB_RED_REG_ELE);

1195: hr_utility.trace('GLB_RR_ORIGINAL_ENTRY_ID Reset = '
1196: || GLB_RR_ORIGINAL_ENTRY_ID);
1197: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT Reset = '
1198: || GLB_RR_SAL_BASIS_ELEMENT);
1199: hr_utility.trace('GLB_RED_REG_ELE Reset = ' || GLB_RED_REG_ELE);
1200: hr_utility.trace('stop_run_flag Reset = ' || stop_run_flag);
1201:
1202: open c_get_ele_type_id(original_entry_id);
1203: fetch c_get_ele_type_id into ln_element_type_id

Line 1200: hr_utility.trace('stop_run_flag Reset = ' || stop_run_flag);

1196: || GLB_RR_ORIGINAL_ENTRY_ID);
1197: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT Reset = '
1198: || GLB_RR_SAL_BASIS_ELEMENT);
1199: hr_utility.trace('GLB_RED_REG_ELE Reset = ' || GLB_RED_REG_ELE);
1200: hr_utility.trace('stop_run_flag Reset = ' || stop_run_flag);
1201:
1202: open c_get_ele_type_id(original_entry_id);
1203: fetch c_get_ele_type_id into ln_element_type_id
1204: ,lv_element_name

Line 1219: hr_utility.trace(' ln_assignment_id = ' ||to_char(ln_assignment_id));

1215: GLB_REG_ELEM := 'NONREG';
1216: end if; -- if lv_reg_elem = 'REG'
1217:
1218:
1219: hr_utility.trace(' ln_assignment_id = ' ||to_char(ln_assignment_id));
1220: hr_utility.trace('ln_element_type_id Curr = '
1221: ||to_char(ln_element_type_id));
1222: hr_utility.trace('lv_element_name Curr = ' ||lv_element_name);
1223: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);

Line 1220: hr_utility.trace('ln_element_type_id Curr = '

1216: end if; -- if lv_reg_elem = 'REG'
1217:
1218:
1219: hr_utility.trace(' ln_assignment_id = ' ||to_char(ln_assignment_id));
1220: hr_utility.trace('ln_element_type_id Curr = '
1221: ||to_char(ln_element_type_id));
1222: hr_utility.trace('lv_element_name Curr = ' ||lv_element_name);
1223: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1224:

Line 1222: hr_utility.trace('lv_element_name Curr = ' ||lv_element_name);

1218:
1219: hr_utility.trace(' ln_assignment_id = ' ||to_char(ln_assignment_id));
1220: hr_utility.trace('ln_element_type_id Curr = '
1221: ||to_char(ln_element_type_id));
1222: hr_utility.trace('lv_element_name Curr = ' ||lv_element_name);
1223: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1224:
1225: open c_get_salary_basis_element(ln_assignment_id,prorate_end);
1226: fetch c_get_salary_basis_element into ln_sal_element_type_id

Line 1223: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);

1219: hr_utility.trace(' ln_assignment_id = ' ||to_char(ln_assignment_id));
1220: hr_utility.trace('ln_element_type_id Curr = '
1221: ||to_char(ln_element_type_id));
1222: hr_utility.trace('lv_element_name Curr = ' ||lv_element_name);
1223: hr_utility.trace('GLB_RED_REG_ELE = ' || GLB_RED_REG_ELE);
1224:
1225: open c_get_salary_basis_element(ln_assignment_id,prorate_end);
1226: fetch c_get_salary_basis_element into ln_sal_element_type_id
1227: ,lv_sal_element_name;

Line 1230: hr_utility.trace('ln_sal_element_type_id SB= '

1226: fetch c_get_salary_basis_element into ln_sal_element_type_id
1227: ,lv_sal_element_name;
1228: close c_get_salary_basis_element;
1229:
1230: hr_utility.trace('ln_sal_element_type_id SB= '
1231: ||to_char(ln_sal_element_type_id));
1232: hr_utility.trace('lv_sal_element_name SB = '
1233: ||lv_sal_element_name);
1234:

Line 1232: hr_utility.trace('lv_sal_element_name SB = '

1228: close c_get_salary_basis_element;
1229:
1230: hr_utility.trace('ln_sal_element_type_id SB= '
1231: ||to_char(ln_sal_element_type_id));
1232: hr_utility.trace('lv_sal_element_name SB = '
1233: ||lv_sal_element_name);
1234:
1235: if ln_element_type_id = ln_sal_element_type_id then
1236: GLB_RR_SAL_BASIS_ELEMENT := 'Y';

Line 1237: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT Matches = '

1233: ||lv_sal_element_name);
1234:
1235: if ln_element_type_id = ln_sal_element_type_id then
1236: GLB_RR_SAL_BASIS_ELEMENT := 'Y';
1237: hr_utility.trace('GLB_RR_SAL_BASIS_ELEMENT Matches = '
1238: || GLB_RR_SAL_BASIS_ELEMENT);
1239: end if;
1240: end if; -- if GLB_RR_ORIGINAL_ENTRY_ID <>
1241:

Line 1252: hr_utility.trace('Earnigs greated than Reduce Regular');

1248: -- Regular Earnings and Reduce Regular Earnings
1249: ln_diff_earn := template_earning - red_reg_earnings +
1250: red_reg_adjust_amount;
1251: if (ln_diff_earn >= 0 or red_reg_raise_error = 'N') then
1252: hr_utility.trace('Earnigs greated than Reduce Regular');
1253:
1254: ln_reduced_template_earnings := template_earning - red_reg_earnings;
1255: if ln_reduced_template_earnings <= 0 then
1256: reduced_template_earnings := 0;

Line 1260: hr_utility.trace('Reduced Template Earnings = '

1256: reduced_template_earnings := 0;
1257: else
1258: reduced_template_earnings := ln_reduced_template_earnings;
1259: end if; -- if
1260: hr_utility.trace('Reduced Template Earnings = '
1261: ||reduced_template_earnings);
1262: else
1263: hr_utility.trace('Else of earnings FLSA');
1264: reduced_template_earnings := 0;

Line 1263: hr_utility.trace('Else of earnings FLSA');

1259: end if; -- if
1260: hr_utility.trace('Reduced Template Earnings = '
1261: ||reduced_template_earnings);
1262: else
1263: hr_utility.trace('Else of earnings FLSA');
1264: reduced_template_earnings := 0;
1265: stop_run_flag := 'Y';
1266: hr_utility.trace(' stop_run_flag = '||stop_run_flag);
1267: end if; -- if (template_earning >=

Line 1266: hr_utility.trace(' stop_run_flag = '||stop_run_flag);

1262: else
1263: hr_utility.trace('Else of earnings FLSA');
1264: reduced_template_earnings := 0;
1265: stop_run_flag := 'Y';
1266: hr_utility.trace(' stop_run_flag = '||stop_run_flag);
1267: end if; -- if (template_earning >=
1268:
1269: -- Add the adjust hours passed in and find the difference between
1270: -- Regular Hours and Reduce Regular Hours

Line 1274: hr_utility.trace('Hours greater than Red Reg Hours');

1270: -- Regular Hours and Reduce Regular Hours
1271: ln_diff_hours := hours_passed - red_reg_hours +
1272: red_reg_adjust_hours;
1273: if (ln_diff_hours >= 0 or red_reg_raise_error = 'N') then
1274: hr_utility.trace('Hours greater than Red Reg Hours');
1275:
1276: ln_reduced_hours_passed := hours_passed - red_reg_hours;
1277: if ln_reduced_hours_passed <=0 then
1278: reduced_hours_passed := 0;

Line 1282: hr_utility.trace('Reduced Hours Passed = ' ||reduced_hours_passed);

1278: reduced_hours_passed := 0;
1279: else
1280: reduced_hours_passed := ln_reduced_hours_passed;
1281: end if; -- if
1282: hr_utility.trace('Reduced Hours Passed = ' ||reduced_hours_passed);
1283: else
1284: hr_utility.trace('Else of hours FLSA');
1285: reduced_hours_passed := 0;
1286: stop_run_flag := 'Y';

Line 1284: hr_utility.trace('Else of hours FLSA');

1280: reduced_hours_passed := ln_reduced_hours_passed;
1281: end if; -- if
1282: hr_utility.trace('Reduced Hours Passed = ' ||reduced_hours_passed);
1283: else
1284: hr_utility.trace('Else of hours FLSA');
1285: reduced_hours_passed := 0;
1286: stop_run_flag := 'Y';
1287: hr_utility.trace(' stop_run_flag = '||stop_run_flag);
1288: end if; -- if hours_passed >=

Line 1287: hr_utility.trace(' stop_run_flag = '||stop_run_flag);

1283: else
1284: hr_utility.trace('Else of hours FLSA');
1285: reduced_hours_passed := 0;
1286: stop_run_flag := 'Y';
1287: hr_utility.trace(' stop_run_flag = '||stop_run_flag);
1288: end if; -- if hours_passed >=
1289: end if; -- if GLB_RED_REG_ELE = 'N'
1290:
1291: -- Override stopr_run_flag to 'N' when no error is to be raised

Line 1294: hr_utility.trace('Overriden Value of Stop Run Flag to N');

1290:
1291: -- Override stopr_run_flag to 'N' when no error is to be raised
1292: if red_reg_raise_error = 'N' then
1293: stop_run_flag := 'N';
1294: hr_utility.trace('Overriden Value of Stop Run Flag to N');
1295: end if; -- if red_reg_raise_error =
1296:
1297: hr_utility.trace('OUT stop_run_flag = ' || stop_run_flag);
1298: hr_utility.trace('OUT reduced_template_earnings = ' || reduced_template_earnings);

Line 1297: hr_utility.trace('OUT stop_run_flag = ' || stop_run_flag);

1293: stop_run_flag := 'N';
1294: hr_utility.trace('Overriden Value of Stop Run Flag to N');
1295: end if; -- if red_reg_raise_error =
1296:
1297: hr_utility.trace('OUT stop_run_flag = ' || stop_run_flag);
1298: hr_utility.trace('OUT reduced_template_earnings = ' || reduced_template_earnings);
1299: hr_utility.trace('OUT reduced_hours_passed = ' || reduced_hours_passed);
1300: -- Return Values
1301: -- 'Y' ==> Salary Element

Line 1298: hr_utility.trace('OUT reduced_template_earnings = ' || reduced_template_earnings);

1294: hr_utility.trace('Overriden Value of Stop Run Flag to N');
1295: end if; -- if red_reg_raise_error =
1296:
1297: hr_utility.trace('OUT stop_run_flag = ' || stop_run_flag);
1298: hr_utility.trace('OUT reduced_template_earnings = ' || reduced_template_earnings);
1299: hr_utility.trace('OUT reduced_hours_passed = ' || reduced_hours_passed);
1300: -- Return Values
1301: -- 'Y' ==> Salary Element
1302: -- Old formulae should work as instead of sending 'N' for

Line 1299: hr_utility.trace('OUT reduced_hours_passed = ' || reduced_hours_passed);

1295: end if; -- if red_reg_raise_error =
1296:
1297: hr_utility.trace('OUT stop_run_flag = ' || stop_run_flag);
1298: hr_utility.trace('OUT reduced_template_earnings = ' || reduced_template_earnings);
1299: hr_utility.trace('OUT reduced_hours_passed = ' || reduced_hours_passed);
1300: -- Return Values
1301: -- 'Y' ==> Salary Element
1302: -- Old formulae should work as instead of sending 'N' for
1303: -- elements that are not Salary Basis we are passing other

Line 1311: hr_utility.trace('Returning Regular Element');

1307: if GLB_RED_REG_ELE = 'N' then
1308: if GLB_RR_SAL_BASIS_ELEMENT = 'N' then
1309: if GLB_REG_ELEM = 'REG' then
1310: lv_return_val := 'REG';
1311: hr_utility.trace('Returning Regular Element');
1312: else
1313: lv_return_val := 'NONREG';
1314: hr_utility.trace('Returning Regular Element');
1315: end if; -- if GLB_REG_ELEM = 'REG'

Line 1314: hr_utility.trace('Returning Regular Element');

1310: lv_return_val := 'REG';
1311: hr_utility.trace('Returning Regular Element');
1312: else
1313: lv_return_val := 'NONREG';
1314: hr_utility.trace('Returning Regular Element');
1315: end if; -- if GLB_REG_ELEM = 'REG'
1316: else
1317: lv_return_val := 'Y';
1318: hr_utility.trace('Returning Salary Basis');

Line 1318: hr_utility.trace('Returning Salary Basis');

1314: hr_utility.trace('Returning Regular Element');
1315: end if; -- if GLB_REG_ELEM = 'REG'
1316: else
1317: lv_return_val := 'Y';
1318: hr_utility.trace('Returning Salary Basis');
1319: end if; -- if GLB_RR_SAL_BASIS_ELEMENT =
1320: else
1321: lv_return_val := 'REDREG';
1322: hr_utility.trace('Returning Reduce Regular');

Line 1322: hr_utility.trace('Returning Reduce Regular');

1318: hr_utility.trace('Returning Salary Basis');
1319: end if; -- if GLB_RR_SAL_BASIS_ELEMENT =
1320: else
1321: lv_return_val := 'REDREG';
1322: hr_utility.trace('Returning Reduce Regular');
1323: end if; -- if GLB_RED_REG_ELE =
1324:
1325: return lv_return_val;
1326:

Line 1346: hr_utility.trace(' GLB_TIME_DEFINITION_ID = '||

1342: if GLB_TIME_DEFINITION_ID is NULL then
1343: GLB_TIME_DEFINITION_ID := -9999;
1344: end if;
1345:
1346: hr_utility.trace(' GLB_TIME_DEFINITION_ID = '||
1347: to_char(GLB_TIME_DEFINITION_ID));
1348:
1349: if GLB_TIME_DEFINITION_ID <> TIME_DEFINITION_ID then
1350:

Line 1355: hr_utility.trace(' GLB_TIME_DEFINITION_NAME = '||

1351: open c_get_time_defn(TIME_DEFINITION_ID);
1352: fetch c_get_time_defn into GLB_TIME_DEFINITION_NAME;
1353: close c_get_time_defn ;
1354:
1355: hr_utility.trace(' GLB_TIME_DEFINITION_NAME = '||
1356: GLB_TIME_DEFINITION_NAME);
1357:
1358: if GLB_TIME_DEFINITION_NAME = 'Non Allocated Time Definition' then
1359: GLB_FLSA_TIME_DEFN := 'N';

Line 1365: hr_utility.trace(' GLB_FLSA_TIME_DEFN = '||

1361: GLB_FLSA_TIME_DEFN := 'Y';
1362: end if;
1363: end if;
1364:
1365: hr_utility.trace(' GLB_FLSA_TIME_DEFN = '||
1366: GLB_FLSA_TIME_DEFN);
1367: --hr_utility.trace_off;
1368:
1369: return GLB_FLSA_TIME_DEFN;

Line 1367: --hr_utility.trace_off;

1363: end if;
1364:
1365: hr_utility.trace(' GLB_FLSA_TIME_DEFN = '||
1366: GLB_FLSA_TIME_DEFN);
1367: --hr_utility.trace_off;
1368:
1369: return GLB_FLSA_TIME_DEFN;
1370:
1371: