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

Line 64: hr_utility.trace('Entering ' ||gv_package || lv_procedure_name);

60:
61: BEGIN
62: lv_procedure_name := '.get_payroll_action_info';
63:
64: hr_utility.trace('Entering ' ||gv_package || lv_procedure_name);
65: ln_step := 1;
66: OPEN c_payroll_action_info(p_payroll_action_id);
67: FETCH c_payroll_action_info INTO ld_start_date,
68: ld_effective_date,

Line 75: hr_utility.set_location(gv_package || lv_procedure_name, 10);

71: ln_legal_er_id,
72: ln_asg_set_id;
73: CLOSE c_payroll_action_info;
74:
75: hr_utility.set_location(gv_package || lv_procedure_name, 10);
76:
77: p_start_date := ld_start_date;
78: p_effective_date := ld_effective_date;
79: p_business_group_id := ln_business_group_id;

Line 89: hr_utility.trace('Leaving ' ||gv_package || lv_procedure_name);

85:
86: g_start_date := ld_start_date; --Bug:9753792
87: g_end_date := add_months(ld_start_date, 12) - 1; --Bug:9753792
88:
89: hr_utility.trace('Leaving ' ||gv_package || lv_procedure_name);
90:
91: EXCEPTION
92: WHEN OTHERS THEN
93: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||

Line 96: hr_utility.trace(lv_error_message || '-' || SQLERRM);

92: WHEN OTHERS THEN
93: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||
94: gv_package || lv_procedure_name;
95:
96: hr_utility.trace(lv_error_message || '-' || SQLERRM);
97:
98: lv_error_message :=
99: pay_emp_action_arch.set_error_message(lv_error_message);
100:

Line 101: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

97:
98: lv_error_message :=
99: pay_emp_action_arch.set_error_message(lv_error_message);
100:
101: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
102: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
103: hr_utility.raise_error;
104:
105: END get_payroll_action_info;

Line 102: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

98: lv_error_message :=
99: pay_emp_action_arch.set_error_message(lv_error_message);
100:
101: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
102: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
103: hr_utility.raise_error;
104:
105: END get_payroll_action_info;
106:

Line 103: hr_utility.raise_error;

99: pay_emp_action_arch.set_error_message(lv_error_message);
100:
101: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
102: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
103: hr_utility.raise_error;
104:
105: END get_payroll_action_info;
106:
107: -------------------------------------------------------------------------------

Line 154: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);

150: ln_days_in_year_le NUMBER;
151:
152: BEGIN
153: lv_procedure_name := '.get_capped_average_earnings';
154: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
155:
156: lv_ptu_calc_method := p_ptu_calc_method;
157: ln_days_in_year := p_days_in_year;
158: ln_business_group_id := p_business_group_id;

Line 172: hr_utility.set_location(gv_package || lv_procedure_name,10);

168: * portion of profit share based on wages.
169: */
170: IF (ln_factor_C / ln_factor_B) > ln_factor_D THEN
171:
172: hr_utility.set_location(gv_package || lv_procedure_name,10);
173: ln_factor_E := ln_factor_D;
174:
175: ELSE
176:

Line 177: hr_utility.set_location(gv_package || lv_procedure_name,20);

173: ln_factor_E := ln_factor_D;
174:
175: ELSE
176:
177: hr_utility.set_location(gv_package || lv_procedure_name,20);
178: ln_factor_E := ROUND( ln_factor_C / ln_factor_B, 4 );
179:
180: END IF;
181:

Line 192: hr_utility.set_location(gv_package || lv_procedure_name,30);

188: * number of days in the year specified at the
189: * Legal Employer level
190: */
191:
192: hr_utility.set_location(gv_package || lv_procedure_name,30);
193: pay_mx_utility.get_no_of_days_for_org
194: (ln_business_group_id,
195: ln_legal_employer_id,
196: 'LE',

Line 201: hr_utility.set_location(gv_package || lv_procedure_name,40);

197: ln_days_in_month_le,
198: ln_days_in_year_le) ;
199:
200: IF (ln_days_in_year_le IS NOT NULL) THEN /*bug 8461411 */
201: hr_utility.set_location(gv_package || lv_procedure_name,40);
202: ln_days_in_year := ln_days_in_year_le;
203: END IF;
204:
205: ln_factor_D := ln_factor_D * ln_days_in_year;

Line 206: hr_utility.trace('ln_factor_D = ' || to_char(ln_factor_D));

202: ln_days_in_year := ln_days_in_year_le;
203: END IF;
204:
205: ln_factor_D := ln_factor_D * ln_days_in_year;
206: hr_utility.trace('ln_factor_D = ' || to_char(ln_factor_D));
207:
208: IF (ln_factor_C > ln_factor_D) THEN
209: hr_utility.set_location(gv_package || lv_procedure_name,50);
210: ln_factor_E := ln_factor_D;

Line 209: hr_utility.set_location(gv_package || lv_procedure_name,50);

205: ln_factor_D := ln_factor_D * ln_days_in_year;
206: hr_utility.trace('ln_factor_D = ' || to_char(ln_factor_D));
207:
208: IF (ln_factor_C > ln_factor_D) THEN
209: hr_utility.set_location(gv_package || lv_procedure_name,50);
210: ln_factor_E := ln_factor_D;
211: ELSE
212: hr_utility.set_location(gv_package || lv_procedure_name,60);
213: ln_factor_E := ln_factor_C;

Line 212: hr_utility.set_location(gv_package || lv_procedure_name,60);

208: IF (ln_factor_C > ln_factor_D) THEN
209: hr_utility.set_location(gv_package || lv_procedure_name,50);
210: ln_factor_E := ln_factor_D;
211: ELSE
212: hr_utility.set_location(gv_package || lv_procedure_name,60);
213: ln_factor_E := ln_factor_C;
214: END IF;
215:
216: ELSIF (lv_ptu_calc_method = 'PRORATE') THEN

Line 228: hr_utility.set_location(gv_package || lv_procedure_name,70);

224: * the limit should be adjusted to the amount that
225: * the highest paid employee would have made if he
226: * had worked the same number of days.
227: */
228: hr_utility.set_location(gv_package || lv_procedure_name,70);
229: ln_factor_D := ln_factor_D * ln_factor_B;
230: IF (ln_factor_C > ln_factor_D) THEN
231: hr_utility.set_location(gv_package || lv_procedure_name,80);
232: ln_factor_E := ln_factor_D;

Line 231: hr_utility.set_location(gv_package || lv_procedure_name,80);

227: */
228: hr_utility.set_location(gv_package || lv_procedure_name,70);
229: ln_factor_D := ln_factor_D * ln_factor_B;
230: IF (ln_factor_C > ln_factor_D) THEN
231: hr_utility.set_location(gv_package || lv_procedure_name,80);
232: ln_factor_E := ln_factor_D;
233: ELSE
234: hr_utility.set_location(gv_package || lv_procedure_name,90);
235: ln_factor_E := ln_factor_C;

Line 234: hr_utility.set_location(gv_package || lv_procedure_name,90);

230: IF (ln_factor_C > ln_factor_D) THEN
231: hr_utility.set_location(gv_package || lv_procedure_name,80);
232: ln_factor_E := ln_factor_D;
233: ELSE
234: hr_utility.set_location(gv_package || lv_procedure_name,90);
235: ln_factor_E := ln_factor_C;
236: END IF;
237:
238: END IF;

Line 242: hr_utility.trace('p_factor_D = ' || TO_CHAR(p_factor_D));

238: END IF;
239:
240: p_factor_D_used := ln_factor_D;
241: p_factor_E := ln_factor_E;
242: hr_utility.trace('p_factor_D = ' || TO_CHAR(p_factor_D));
243: hr_utility.trace('p_factor_E = ' || TO_CHAR(p_factor_E));
244: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
245: END get_capped_average_earnings;
246: /******************************************************************

Line 243: hr_utility.trace('p_factor_E = ' || TO_CHAR(p_factor_E));

239:
240: p_factor_D_used := ln_factor_D;
241: p_factor_E := ln_factor_E;
242: hr_utility.trace('p_factor_D = ' || TO_CHAR(p_factor_D));
243: hr_utility.trace('p_factor_E = ' || TO_CHAR(p_factor_E));
244: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
245: END get_capped_average_earnings;
246: /******************************************************************
247: Name : range_code

Line 244: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);

240: p_factor_D_used := ln_factor_D;
241: p_factor_E := ln_factor_E;
242: hr_utility.trace('p_factor_D = ' || TO_CHAR(p_factor_D));
243: hr_utility.trace('p_factor_E = ' || TO_CHAR(p_factor_E));
244: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
245: END get_capped_average_earnings;
246: /******************************************************************
247: Name : range_code
248: Purpose : This returns the select statement that is

Line 279: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);

275:
276: BEGIN
277: lv_procedure_name := '.range_code';
278:
279: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
280: hr_utility.set_location(gv_package || lv_procedure_name, 10);
281:
282: ln_step := 1;
283: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

Line 280: hr_utility.set_location(gv_package || lv_procedure_name, 10);

276: BEGIN
277: lv_procedure_name := '.range_code';
278:
279: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
280: hr_utility.set_location(gv_package || lv_procedure_name, 10);
281:
282: ln_step := 1;
283: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
284: ,p_start_date => ld_start_date

Line 298: hr_utility.set_location(gv_package || lv_procedure_name, 20);

294: -- ELSE
295: -- ln_min_days_worked := 0;
296: -- END IF;
297:
298: hr_utility.set_location(gv_package || lv_procedure_name, 20);
299:
300: ld_end_date := add_months(ld_start_date, 12) - 1;
301:
302: ln_step := 2;

Line 379: hr_utility.set_location(gv_package || lv_procedure_name, 30);

375: ORDER BY paf.person_id';
376:
377: END IF; -- ln_asg_set_id is null
378:
379: hr_utility.set_location(gv_package || lv_procedure_name, 30);
380: p_sqlstr := lv_sql_string;
381: hr_utility.trace ('SQL string :' ||p_sqlstr);
382: hr_utility.set_location(gv_package || lv_procedure_name, 50);
383: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);

Line 381: hr_utility.trace ('SQL string :' ||p_sqlstr);

377: END IF; -- ln_asg_set_id is null
378:
379: hr_utility.set_location(gv_package || lv_procedure_name, 30);
380: p_sqlstr := lv_sql_string;
381: hr_utility.trace ('SQL string :' ||p_sqlstr);
382: hr_utility.set_location(gv_package || lv_procedure_name, 50);
383: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);
384:
385: EXCEPTION

Line 382: hr_utility.set_location(gv_package || lv_procedure_name, 50);

378:
379: hr_utility.set_location(gv_package || lv_procedure_name, 30);
380: p_sqlstr := lv_sql_string;
381: hr_utility.trace ('SQL string :' ||p_sqlstr);
382: hr_utility.set_location(gv_package || lv_procedure_name, 50);
383: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);
384:
385: EXCEPTION
386:

Line 383: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);

379: hr_utility.set_location(gv_package || lv_procedure_name, 30);
380: p_sqlstr := lv_sql_string;
381: hr_utility.trace ('SQL string :' ||p_sqlstr);
382: hr_utility.set_location(gv_package || lv_procedure_name, 50);
383: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);
384:
385: EXCEPTION
386:
387: WHEN OTHERS THEN

Line 391: hr_utility.trace(lv_error_message || '-' || SQLERRM);

387: WHEN OTHERS THEN
388: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||
389: gv_package || lv_procedure_name;
390:
391: hr_utility.trace(lv_error_message || '-' || SQLERRM);
392:
393: lv_error_message :=
394: pay_emp_action_arch.set_error_message(lv_error_message);
395:

Line 396: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

392:
393: lv_error_message :=
394: pay_emp_action_arch.set_error_message(lv_error_message);
395:
396: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
397: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
398: hr_utility.raise_error;
399:
400:

Line 397: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

393: lv_error_message :=
394: pay_emp_action_arch.set_error_message(lv_error_message);
395:
396: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
397: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
398: hr_utility.raise_error;
399:
400:
401: END range_code;

Line 398: hr_utility.raise_error;

394: pay_emp_action_arch.set_error_message(lv_error_message);
395:
396: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
397: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
398: hr_utility.raise_error;
399:
400:
401: END range_code;
402:

Line 614: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);

610: lv_EE_no per_all_people_f.employee_number%TYPE;
611:
612: BEGIN
613: lv_procedure_name := '.assignment_action_code';
614: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
615:
616: ln_person_id := -1;
617: ln_prev_person_id := -1;
618: lv_excl_flag := '-1';

Line 621: hr_utility.trace('p_payroll_action_id = '|| p_payroll_action_id);

617: ln_prev_person_id := -1;
618: lv_excl_flag := '-1';
619: lb_action_created := FALSE;
620:
621: hr_utility.trace('p_payroll_action_id = '|| p_payroll_action_id);
622: hr_utility.trace('p_start_person_id = '|| p_start_person_id);
623: hr_utility.trace('p_end_person_id = '|| p_end_person_id);
624: hr_utility.trace('p_chunk = '|| p_chunk);
625:

Line 622: hr_utility.trace('p_start_person_id = '|| p_start_person_id);

618: lv_excl_flag := '-1';
619: lb_action_created := FALSE;
620:
621: hr_utility.trace('p_payroll_action_id = '|| p_payroll_action_id);
622: hr_utility.trace('p_start_person_id = '|| p_start_person_id);
623: hr_utility.trace('p_end_person_id = '|| p_end_person_id);
624: hr_utility.trace('p_chunk = '|| p_chunk);
625:
626: ln_step := 1;

Line 623: hr_utility.trace('p_end_person_id = '|| p_end_person_id);

619: lb_action_created := FALSE;
620:
621: hr_utility.trace('p_payroll_action_id = '|| p_payroll_action_id);
622: hr_utility.trace('p_start_person_id = '|| p_start_person_id);
623: hr_utility.trace('p_end_person_id = '|| p_end_person_id);
624: hr_utility.trace('p_chunk = '|| p_chunk);
625:
626: ln_step := 1;
627: -- pay_emp_action_arch.gv_error_message := NULL;

Line 624: hr_utility.trace('p_chunk = '|| p_chunk);

620:
621: hr_utility.trace('p_payroll_action_id = '|| p_payroll_action_id);
622: hr_utility.trace('p_start_person_id = '|| p_start_person_id);
623: hr_utility.trace('p_end_person_id = '|| p_end_person_id);
624: hr_utility.trace('p_chunk = '|| p_chunk);
625:
626: ln_step := 1;
627: -- pay_emp_action_arch.gv_error_message := NULL;
628: hr_utility.set_location(gv_package || lv_procedure_name, 10);

Line 628: hr_utility.set_location(gv_package || lv_procedure_name, 10);

624: hr_utility.trace('p_chunk = '|| p_chunk);
625:
626: ln_step := 1;
627: -- pay_emp_action_arch.gv_error_message := NULL;
628: hr_utility.set_location(gv_package || lv_procedure_name, 10);
629:
630: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
631: ,p_start_date => ld_start_date
632: ,p_effective_date => ld_date_earned

Line 695: hr_utility.set_location(gv_package || lv_procedure_name, 20);

691: 'MX');
692:
693:
694: IF ln_min_days_worked > 0 THEN
695: hr_utility.set_location(gv_package || lv_procedure_name, 20);
696:
697: ELSE
698: hr_utility.set_location(gv_package || lv_procedure_name, 30);
699: ln_min_days_worked := 0;

Line 698: hr_utility.set_location(gv_package || lv_procedure_name, 30);

694: IF ln_min_days_worked > 0 THEN
695: hr_utility.set_location(gv_package || lv_procedure_name, 20);
696:
697: ELSE
698: hr_utility.set_location(gv_package || lv_procedure_name, 30);
699: ln_min_days_worked := 0;
700: END IF;
701:
702: hr_utility.set_location(gv_package || lv_procedure_name, 40);

Line 702: hr_utility.set_location(gv_package || lv_procedure_name, 40);

698: hr_utility.set_location(gv_package || lv_procedure_name, 30);
699: ln_min_days_worked := 0;
700: END IF;
701:
702: hr_utility.set_location(gv_package || lv_procedure_name, 40);
703:
704: ln_step := 3;
705: IF pay_mx_yrend_arch.g_gre_tab.count() = 0 THEN
706:

Line 707: hr_utility.set_location(gv_package || lv_procedure_name, 50);

703:
704: ln_step := 3;
705: IF pay_mx_yrend_arch.g_gre_tab.count() = 0 THEN
706:
707: hr_utility.set_location(gv_package || lv_procedure_name, 50);
708:
709: --------------------------------------------------------------
710: -- Load the cache with the GREs under the given Legal Employer
711: --------------------------------------------------------------

Line 739: hr_utility.trace('Values from PTU Factors Table IN ACTION_CODE');

735: WHEN NO_DATA_FOUND THEN
736: ln_factor_G := NULL;
737: END;
738:
739: hr_utility.trace('Values from PTU Factors Table IN ACTION_CODE');
740: hr_utility.trace('Factor F: ' || ln_factor_F);
741: hr_utility.trace('Factor G: ' || ln_factor_G);
742:
743: IF NVL(ln_factor_F, 0) = 0 THEN

Line 740: hr_utility.trace('Factor F: ' || ln_factor_F);

736: ln_factor_G := NULL;
737: END;
738:
739: hr_utility.trace('Values from PTU Factors Table IN ACTION_CODE');
740: hr_utility.trace('Factor F: ' || ln_factor_F);
741: hr_utility.trace('Factor G: ' || ln_factor_G);
742:
743: IF NVL(ln_factor_F, 0) = 0 THEN
744: ln_factor_F_found := FALSE;

Line 741: hr_utility.trace('Factor G: ' || ln_factor_G);

737: END;
738:
739: hr_utility.trace('Values from PTU Factors Table IN ACTION_CODE');
740: hr_utility.trace('Factor F: ' || ln_factor_F);
741: hr_utility.trace('Factor G: ' || ln_factor_G);
742:
743: IF NVL(ln_factor_F, 0) = 0 THEN
744: ln_factor_F_found := FALSE;
745: ELSE

Line 769: hr_utility.set_location(gv_package || lv_procedure_name, 60);

765: -- pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
766: -- LOOP
767:
768: IF lb_range_person THEN
769: hr_utility.set_location(gv_package || lv_procedure_name, 60);
770:
771: OPEN c_get_emp_asg_range(ln_business_group_id,
772: lv_incl_temp_EEs,
773: ld_start_date,

Line 776: hr_utility.set_location(gv_package || lv_procedure_name, 70);

772: lv_incl_temp_EEs,
773: ld_start_date,
774: ld_end_date);
775: ELSE
776: hr_utility.set_location(gv_package || lv_procedure_name, 70);
777:
778: OPEN c_get_emp_asg (ln_business_group_id,
779: lv_incl_temp_EEs,
780: ld_start_date,

Line 799: hr_utility.trace('Previous person ID = ' || ln_prev_person_id);

795: ln_tax_unit_id;
796: EXIT WHEN c_get_emp_asg%NOTFOUND;
797: END IF;
798:
799: hr_utility.trace('Previous person ID = ' || ln_prev_person_id);
800: hr_utility.trace('Current person ID = ' || ln_person_id);
801: hr_utility.trace('Assignment ID= ' || ln_assignment_id);
802: hr_utility.trace('Employment Category= ' || ln_employment_category);
803:

Line 800: hr_utility.trace('Current person ID = ' || ln_person_id);

796: EXIT WHEN c_get_emp_asg%NOTFOUND;
797: END IF;
798:
799: hr_utility.trace('Previous person ID = ' || ln_prev_person_id);
800: hr_utility.trace('Current person ID = ' || ln_person_id);
801: hr_utility.trace('Assignment ID= ' || ln_assignment_id);
802: hr_utility.trace('Employment Category= ' || ln_employment_category);
803:
804: IF ln_person_id <> ln_prev_person_id THEN

Line 801: hr_utility.trace('Assignment ID= ' || ln_assignment_id);

797: END IF;
798:
799: hr_utility.trace('Previous person ID = ' || ln_prev_person_id);
800: hr_utility.trace('Current person ID = ' || ln_person_id);
801: hr_utility.trace('Assignment ID= ' || ln_assignment_id);
802: hr_utility.trace('Employment Category= ' || ln_employment_category);
803:
804: IF ln_person_id <> ln_prev_person_id THEN
805:

Line 802: hr_utility.trace('Employment Category= ' || ln_employment_category);

798:
799: hr_utility.trace('Previous person ID = ' || ln_prev_person_id);
800: hr_utility.trace('Current person ID = ' || ln_person_id);
801: hr_utility.trace('Assignment ID= ' || ln_assignment_id);
802: hr_utility.trace('Employment Category= ' || ln_employment_category);
803:
804: IF ln_person_id <> ln_prev_person_id THEN
805:
806: hr_utility.set_location(gv_package || lv_procedure_name,80);

Line 806: hr_utility.set_location(gv_package || lv_procedure_name,80);

802: hr_utility.trace('Employment Category= ' || ln_employment_category);
803:
804: IF ln_person_id <> ln_prev_person_id THEN
805:
806: hr_utility.set_location(gv_package || lv_procedure_name,80);
807: ln_step := 5;
808:
809: OPEN c_get_ytd_aaid(ld_start_date,
810: ld_end_date,

Line 819: hr_utility.set_location(gv_package ||lv_procedure_name,90);

815:
816: IF ln_employment_category IN ('MX2_TEMP_WRK',
817: 'MX3_TEMP_CONSTRCT_WRK') THEN
818:
819: hr_utility.set_location(gv_package ||lv_procedure_name,90);
820:
821: --------------------------------------------------------
822: -- Check if worked days exceed the minimum limit.
823: --------------------------------------------------------

Line 840: hr_utility.set_location(gv_package ||

836: -- The temporary worker hasn't worked the stipulated
837: -- number of days during the Profit Sharing year
838: -- and is therefore ineligible for PTU.
839: ----------------------------------------------------
840: hr_utility.set_location(gv_package ||
841: lv_procedure_name, 95);
842: lv_excl_flag := 'X';
843:
844: END IF;

Line 861: hr_utility.set_location(gv_package ||

857: ------------------------------------------------------------
858:
859: IF ln_factor_G_found = FALSE OR ln_factor_F_found = FALSE THEN
860:
861: hr_utility.set_location(gv_package ||
862: lv_procedure_name, 999);
863:
864: /* bug 8437173 area 2*/
865: FOR cntr_gre IN

Line 875: hr_utility.set_location(gv_package ||

871: g_worked_days_def_bal_id,
872: ln_ytd_aaid), 0);
873: END LOOP;
874:
875: hr_utility.set_location(gv_package ||
876: lv_procedure_name, 998);
877:
878: IF ( ln_factor_B <> 0 ) THEN
879:

Line 907: hr_utility.set_message(801,

903: ld_end_date) ;
904:
905: EXCEPTION
906: WHEN NO_DATA_FOUND THEN
907: hr_utility.set_message(801,
908: 'PAY_MX_PTU_INPUTS_MISSING');
909: hr_utility.raise_error;
910: END;
911:

Line 909: hr_utility.raise_error;

905: EXCEPTION
906: WHEN NO_DATA_FOUND THEN
907: hr_utility.set_message(801,
908: 'PAY_MX_PTU_INPUTS_MISSING');
909: hr_utility.raise_error;
910: END;
911:
912: IF NVL(ln_factor_D, 0) = 0 THEN
913:

Line 914: hr_utility.set_message(801,

910: END;
911:
912: IF NVL(ln_factor_D, 0) = 0 THEN
913:
914: hr_utility.set_message(801,
915: 'PAY_MX_PTU_INPUTS_MISSING');
916: hr_utility.raise_error;
917:
918: END IF;

Line 916: hr_utility.raise_error;

912: IF NVL(ln_factor_D, 0) = 0 THEN
913:
914: hr_utility.set_message(801,
915: 'PAY_MX_PTU_INPUTS_MISSING');
916: hr_utility.raise_error;
917:
918: END IF;
919:
920: get_capped_average_earnings(

Line 938: hr_utility.set_location(gv_package ||

934: ln_factor_E;
935:
936: --IF ln_factor_F_found = FALSE THEN
937:
938: hr_utility.set_location(gv_package ||
939: lv_procedure_name, 888);
940: -- ln_factor_F_total := ROUND( nvl(ln_factor_F_total,0) +
941: -- ln_factor_B, 4);
942:

Line 953: hr_utility.set_location(gv_package ||

949: END IF;
950:
951: IF ln_asg_set_id IS NOT NULL THEN
952:
953: hr_utility.set_location(gv_package ||
954: lv_procedure_name, 100);
955: ------------------------------------------------------
956: -- Check if the assignment set excludes this person
957: ------------------------------------------------------

Line 972: hr_utility.set_location(gv_package ||

968: -----------------------------------------------------------
969: -- No assignment set exclusions apply.
970: -----------------------------------------------------------
971:
972: hr_utility.set_location(gv_package ||
973: lv_procedure_name, 110);
974:
975: OPEN c_chk_asg_valid(ln_assignment_id,
976: ld_start_date,

Line 983: hr_utility.set_location(gv_package ||lv_procedure_name,

979: CLOSE c_chk_asg_valid;
980:
981: IF lv_excl_flag <> 'X' THEN
982:
983: hr_utility.set_location(gv_package ||lv_procedure_name,
984: 120);
985: ln_prev_person_id := ln_person_id;
986:
987: IF NOT lb_valid_pri_asg_found AND

Line 995: hr_utility.set_location(gv_package ||

991: -- The Previous person doesn't have a single valid
992: -- primary assignment as on the Profit Sharing Date
993: -- Paid. Log a message for the same.
994: ---------------------------------------------------
995: hr_utility.set_location(gv_package ||
996: lv_procedure_name, 130);
997:
998: OPEN c_get_EE_no(ln_skipped_person_id);
999: FETCH c_get_EE_no INTO lv_EE_no;

Line 1032: hr_utility.set_location(gv_package ||

1028: pay_mx_tax_functions.g_temp_object_actions := TRUE;
1029: pay_mx_tax_functions.g_ptu_start_date := ld_start_date; --Bug:9753792
1030: pay_mx_tax_functions.g_ptu_end_date := ld_end_date; --Bug:9753792
1031:
1032: hr_utility.set_location(gv_package ||
1033: lv_procedure_name, 140);
1034:
1035: hr_utility.trace('PTU asg action ' ||
1036: ln_PTU_action_id || ' created.');

Line 1035: hr_utility.trace('PTU asg action ' ||

1031:
1032: hr_utility.set_location(gv_package ||
1033: lv_procedure_name, 140);
1034:
1035: hr_utility.trace('PTU asg action ' ||
1036: ln_PTU_action_id || ' created.');
1037:
1038: ELSE
1039: -------------------------------------------------------

Line 1045: hr_utility.set_location(gv_package ||

1041: -- Sharing Date Paid. Set a flag to check if any other
1042: -- primary assignment exists on that date for that
1043: -- person.
1044: -------------------------------------------------------
1045: hr_utility.set_location(gv_package ||
1046: lv_procedure_name, 150);
1047: lb_valid_pri_asg_found := FALSE;
1048: ln_skipped_person_id := ln_person_id;
1049: lv_excl_flag := '-1';

Line 1054: hr_utility.trace('Assignment is excluded in asg set.');

1050:
1051: END IF;
1052:
1053: ELSE
1054: hr_utility.trace('Assignment is excluded in asg set.');
1055: ln_prev_person_id := ln_person_id;
1056: lv_excl_flag := '-1';
1057: END IF;
1058: ELSE

Line 1059: hr_utility.trace('Temporary worker criterion not satisfied');

1055: ln_prev_person_id := ln_person_id;
1056: lv_excl_flag := '-1';
1057: END IF;
1058: ELSE
1059: hr_utility.trace('Temporary worker criterion not satisfied');
1060: lv_excl_flag := '-1';
1061: END IF;
1062: ELSE
1063: hr_utility.trace('The assignment action creation has been ' ||

Line 1063: hr_utility.trace('The assignment action creation has been ' ||

1059: hr_utility.trace('Temporary worker criterion not satisfied');
1060: lv_excl_flag := '-1';
1061: END IF;
1062: ELSE
1063: hr_utility.trace('The assignment action creation has been ' ||
1064: 'either already done or skipped for this ' ||
1065: 'person.');
1066: END IF;
1067: END LOOP;

Line 1082: hr_utility.set_location(gv_package || lv_procedure_name, 160);

1078: -- The Last person didn't have a single valid
1079: -- primary assignment as on the Profit Sharing Date
1080: -- Paid. Log a message for the same.
1081: ---------------------------------------------------------
1082: hr_utility.set_location(gv_package || lv_procedure_name, 160);
1083:
1084: OPEN c_get_EE_no(ln_skipped_person_id);
1085: FETCH c_get_EE_no INTO lv_EE_no;
1086: CLOSE c_get_EE_no;

Line 1142: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);

1138: p_object_version_number => ln_ovn);
1139:
1140: END IF;
1141:
1142: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);
1143:
1144: EXCEPTION
1145: WHEN BATCH_EXISTS THEN
1146:

Line 1147: hr_utility.set_message(800, 'HR_BATCH_NAME_ALREADY_EXISTS');

1143:
1144: EXCEPTION
1145: WHEN BATCH_EXISTS THEN
1146:
1147: hr_utility.set_message(800, 'HR_BATCH_NAME_ALREADY_EXISTS');
1148: hr_utility.raise_error;
1149:
1150: WHEN OTHERS THEN
1151:

Line 1148: hr_utility.raise_error;

1144: EXCEPTION
1145: WHEN BATCH_EXISTS THEN
1146:
1147: hr_utility.set_message(800, 'HR_BATCH_NAME_ALREADY_EXISTS');
1148: hr_utility.raise_error;
1149:
1150: WHEN OTHERS THEN
1151:
1152: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||

Line 1155: hr_utility.trace(lv_error_message || '-' || SQLERRM);

1151:
1152: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||
1153: gv_package || lv_procedure_name;
1154:
1155: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1156:
1157: lv_error_message :=
1158: pay_emp_action_arch.set_error_message(lv_error_message);
1159:

Line 1160: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1156:
1157: lv_error_message :=
1158: pay_emp_action_arch.set_error_message(lv_error_message);
1159:
1160: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1161: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1162: hr_utility.raise_error;
1163:
1164: END assignment_action_code;

Line 1161: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

1157: lv_error_message :=
1158: pay_emp_action_arch.set_error_message(lv_error_message);
1159:
1160: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1161: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1162: hr_utility.raise_error;
1163:
1164: END assignment_action_code;
1165:

Line 1162: hr_utility.raise_error;

1158: pay_emp_action_arch.set_error_message(lv_error_message);
1159:
1160: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1161: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1162: hr_utility.raise_error;
1163:
1164: END assignment_action_code;
1165:
1166: /************************************************************

Line 1254: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1250: lv_procedure_name := '.initialization_code';
1251:
1252: ln_step := 1;
1253:
1254: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1255:
1256: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1257: ,p_start_date => ld_start_date
1258: ,p_effective_date => ld_date_earned

Line 1276: hr_utility.set_location(gv_package || lv_procedure_name, 20);

1272: CLOSE c_get_batch_id;
1273:
1274: IF pay_mx_yrend_arch.g_gre_tab.count() = 0 THEN
1275:
1276: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1277:
1278: --------------------------------------------------------------
1279: -- Load the cache with the GREs under the given Legal Employer
1280: --------------------------------------------------------------

Line 1288: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1284: END IF;
1285: /*bug 8437173 area 4 */
1286: IF g_worked_days_def_bal_id IS NULL THEN
1287:
1288: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1289:
1290: g_worked_days_def_bal_id := pay_ac_utility.get_defined_balance_id(
1291: 'Eligible Worked Days for Profit Sharing',
1292: '_PER_GRE_YTD',

Line 1305: hr_utility.set_location(gv_package || lv_procedure_name, 40);

1301: 'MX');
1302:
1303: lv_legal_ER_name := hr_general.decode_organization(ln_legal_employer_id);
1304:
1305: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1306:
1307: OPEN c_get_PTU_ele_details;
1308: FETCH c_get_PTU_ele_details INTO g_PTU_ele_type_id;
1309: CLOSE c_get_PTU_ele_details;

Line 1312: -- hr_utility.set_location(gv_package || lv_procedure_name, 50);

1308: FETCH c_get_PTU_ele_details INTO g_PTU_ele_type_id;
1309: CLOSE c_get_PTU_ele_details;
1310:
1311: -- IF ln_min_days_worked > 0 THEN
1312: -- hr_utility.set_location(gv_package || lv_procedure_name, 50);
1313:
1314: -- ELSE
1315: -- hr_utility.set_location(gv_package || lv_procedure_name, 60);
1316: -- ln_min_days_worked := 0;

Line 1315: -- hr_utility.set_location(gv_package || lv_procedure_name, 60);

1311: -- IF ln_min_days_worked > 0 THEN
1312: -- hr_utility.set_location(gv_package || lv_procedure_name, 50);
1313:
1314: -- ELSE
1315: -- hr_utility.set_location(gv_package || lv_procedure_name, 60);
1316: -- ln_min_days_worked := 0;
1317: -- END IF;
1318:
1319: ln_step := 2;

Line 1329: hr_utility.set_message(801,'PAY_MX_PTU_INPUTS_MISSING');

1325: lv_legal_ER_name,
1326: ld_end_date);
1327: EXCEPTION
1328: WHEN NO_DATA_FOUND THEN
1329: hr_utility.set_message(801,'PAY_MX_PTU_INPUTS_MISSING');
1330: hr_utility.raise_error;
1331: END;
1332:
1333: ln_factor_A := ln_tot_share_amt / 2;

Line 1330: hr_utility.raise_error;

1326: ld_end_date);
1327: EXCEPTION
1328: WHEN NO_DATA_FOUND THEN
1329: hr_utility.set_message(801,'PAY_MX_PTU_INPUTS_MISSING');
1330: hr_utility.raise_error;
1331: END;
1332:
1333: ln_factor_A := ln_tot_share_amt / 2;
1334:

Line 1344: hr_utility.set_message(801,'PAY_MX_PTU_INPUTS_MISSING');

1340: lv_legal_ER_name,
1341: ld_end_date);
1342: EXCEPTION
1343: WHEN NO_DATA_FOUND THEN
1344: hr_utility.set_message(801,'PAY_MX_PTU_INPUTS_MISSING');
1345: hr_utility.raise_error;
1346: END;
1347:
1348: BEGIN

Line 1345: hr_utility.raise_error;

1341: ld_end_date);
1342: EXCEPTION
1343: WHEN NO_DATA_FOUND THEN
1344: hr_utility.set_message(801,'PAY_MX_PTU_INPUTS_MISSING');
1345: hr_utility.raise_error;
1346: END;
1347:
1348: BEGIN
1349: ln_factor_F := hruserdt.get_table_value(ln_business_group_id,

Line 1370: hr_utility.trace('Values from PTU Factors Table');

1366: WHEN NO_DATA_FOUND THEN
1367: ln_factor_G := NULL;
1368: END;
1369:
1370: hr_utility.trace('Values from PTU Factors Table');
1371: hr_utility.trace('Factor A: ' || ln_factor_A);
1372: hr_utility.trace('Factor D: ' || ln_factor_D);
1373: hr_utility.trace('Factor F: ' || ln_factor_F);
1374: hr_utility.trace('Factor G: ' || ln_factor_G);

Line 1371: hr_utility.trace('Factor A: ' || ln_factor_A);

1367: ln_factor_G := NULL;
1368: END;
1369:
1370: hr_utility.trace('Values from PTU Factors Table');
1371: hr_utility.trace('Factor A: ' || ln_factor_A);
1372: hr_utility.trace('Factor D: ' || ln_factor_D);
1373: hr_utility.trace('Factor F: ' || ln_factor_F);
1374: hr_utility.trace('Factor G: ' || ln_factor_G);
1375: ln_step := 3;

Line 1372: hr_utility.trace('Factor D: ' || ln_factor_D);

1368: END;
1369:
1370: hr_utility.trace('Values from PTU Factors Table');
1371: hr_utility.trace('Factor A: ' || ln_factor_A);
1372: hr_utility.trace('Factor D: ' || ln_factor_D);
1373: hr_utility.trace('Factor F: ' || ln_factor_F);
1374: hr_utility.trace('Factor G: ' || ln_factor_G);
1375: ln_step := 3;
1376:

Line 1373: hr_utility.trace('Factor F: ' || ln_factor_F);

1369:
1370: hr_utility.trace('Values from PTU Factors Table');
1371: hr_utility.trace('Factor A: ' || ln_factor_A);
1372: hr_utility.trace('Factor D: ' || ln_factor_D);
1373: hr_utility.trace('Factor F: ' || ln_factor_F);
1374: hr_utility.trace('Factor G: ' || ln_factor_G);
1375: ln_step := 3;
1376:
1377: hr_utility.set_location(gv_package || lv_procedure_name, 70);

Line 1374: hr_utility.trace('Factor G: ' || ln_factor_G);

1370: hr_utility.trace('Values from PTU Factors Table');
1371: hr_utility.trace('Factor A: ' || ln_factor_A);
1372: hr_utility.trace('Factor D: ' || ln_factor_D);
1373: hr_utility.trace('Factor F: ' || ln_factor_F);
1374: hr_utility.trace('Factor G: ' || ln_factor_G);
1375: ln_step := 3;
1376:
1377: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1378:

Line 1377: hr_utility.set_location(gv_package || lv_procedure_name, 70);

1373: hr_utility.trace('Factor F: ' || ln_factor_F);
1374: hr_utility.trace('Factor G: ' || ln_factor_G);
1375: ln_step := 3;
1376:
1377: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1378:
1379: IF NVL(ln_factor_A, 0) = 0 OR NVL(ln_factor_D, 0) = 0 THEN
1380: hr_utility.set_message(801,'PAY_MX_PTU_INPUTS_MISSING');
1381: hr_utility.raise_error;

Line 1380: hr_utility.set_message(801,'PAY_MX_PTU_INPUTS_MISSING');

1376:
1377: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1378:
1379: IF NVL(ln_factor_A, 0) = 0 OR NVL(ln_factor_D, 0) = 0 THEN
1380: hr_utility.set_message(801,'PAY_MX_PTU_INPUTS_MISSING');
1381: hr_utility.raise_error;
1382: END IF;
1383:
1384: --

Line 1381: hr_utility.raise_error;

1377: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1378:
1379: IF NVL(ln_factor_A, 0) = 0 OR NVL(ln_factor_D, 0) = 0 THEN
1380: hr_utility.set_message(801,'PAY_MX_PTU_INPUTS_MISSING');
1381: hr_utility.raise_error;
1382: END IF;
1383:
1384: --
1385: IF NVL(ln_factor_G, 0) = 0 OR NVL(ln_factor_F, 0) = 0 THEN

Line 1438: hr_utility.trace('Global Values for PTU Factors');

1434: g_factor_G := ln_factor_G;
1435: g_factor_H := ln_factor_H;
1436: g_factor_I := ln_factor_I;
1437:
1438: hr_utility.trace('Global Values for PTU Factors');
1439: hr_utility.trace('g_factor_A: ' || g_factor_A);
1440: hr_utility.trace('g_factor_D: ' || g_factor_D);
1441: hr_utility.trace('g_factor_F: ' || g_factor_F);
1442: hr_utility.trace('g_factor_G: ' || g_factor_G);

Line 1439: hr_utility.trace('g_factor_A: ' || g_factor_A);

1435: g_factor_H := ln_factor_H;
1436: g_factor_I := ln_factor_I;
1437:
1438: hr_utility.trace('Global Values for PTU Factors');
1439: hr_utility.trace('g_factor_A: ' || g_factor_A);
1440: hr_utility.trace('g_factor_D: ' || g_factor_D);
1441: hr_utility.trace('g_factor_F: ' || g_factor_F);
1442: hr_utility.trace('g_factor_G: ' || g_factor_G);
1443: hr_utility.trace('g_factor_H: ' || g_factor_H);

Line 1440: hr_utility.trace('g_factor_D: ' || g_factor_D);

1436: g_factor_I := ln_factor_I;
1437:
1438: hr_utility.trace('Global Values for PTU Factors');
1439: hr_utility.trace('g_factor_A: ' || g_factor_A);
1440: hr_utility.trace('g_factor_D: ' || g_factor_D);
1441: hr_utility.trace('g_factor_F: ' || g_factor_F);
1442: hr_utility.trace('g_factor_G: ' || g_factor_G);
1443: hr_utility.trace('g_factor_H: ' || g_factor_H);
1444: hr_utility.trace('g_factor_I: ' || g_factor_I);

Line 1441: hr_utility.trace('g_factor_F: ' || g_factor_F);

1437:
1438: hr_utility.trace('Global Values for PTU Factors');
1439: hr_utility.trace('g_factor_A: ' || g_factor_A);
1440: hr_utility.trace('g_factor_D: ' || g_factor_D);
1441: hr_utility.trace('g_factor_F: ' || g_factor_F);
1442: hr_utility.trace('g_factor_G: ' || g_factor_G);
1443: hr_utility.trace('g_factor_H: ' || g_factor_H);
1444: hr_utility.trace('g_factor_I: ' || g_factor_I);
1445:

Line 1442: hr_utility.trace('g_factor_G: ' || g_factor_G);

1438: hr_utility.trace('Global Values for PTU Factors');
1439: hr_utility.trace('g_factor_A: ' || g_factor_A);
1440: hr_utility.trace('g_factor_D: ' || g_factor_D);
1441: hr_utility.trace('g_factor_F: ' || g_factor_F);
1442: hr_utility.trace('g_factor_G: ' || g_factor_G);
1443: hr_utility.trace('g_factor_H: ' || g_factor_H);
1444: hr_utility.trace('g_factor_I: ' || g_factor_I);
1445:
1446: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);

Line 1443: hr_utility.trace('g_factor_H: ' || g_factor_H);

1439: hr_utility.trace('g_factor_A: ' || g_factor_A);
1440: hr_utility.trace('g_factor_D: ' || g_factor_D);
1441: hr_utility.trace('g_factor_F: ' || g_factor_F);
1442: hr_utility.trace('g_factor_G: ' || g_factor_G);
1443: hr_utility.trace('g_factor_H: ' || g_factor_H);
1444: hr_utility.trace('g_factor_I: ' || g_factor_I);
1445:
1446: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);
1447:

Line 1444: hr_utility.trace('g_factor_I: ' || g_factor_I);

1440: hr_utility.trace('g_factor_D: ' || g_factor_D);
1441: hr_utility.trace('g_factor_F: ' || g_factor_F);
1442: hr_utility.trace('g_factor_G: ' || g_factor_G);
1443: hr_utility.trace('g_factor_H: ' || g_factor_H);
1444: hr_utility.trace('g_factor_I: ' || g_factor_I);
1445:
1446: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);
1447:
1448: EXCEPTION

Line 1446: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);

1442: hr_utility.trace('g_factor_G: ' || g_factor_G);
1443: hr_utility.trace('g_factor_H: ' || g_factor_H);
1444: hr_utility.trace('g_factor_I: ' || g_factor_I);
1445:
1446: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);
1447:
1448: EXCEPTION
1449: WHEN OTHERS THEN
1450: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||

Line 1453: hr_utility.trace(lv_error_message || '-' || SQLERRM);

1449: WHEN OTHERS THEN
1450: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||
1451: gv_package || lv_procedure_name;
1452:
1453: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1454:
1455: lv_error_message :=
1456: pay_emp_action_arch.set_error_message(lv_error_message);
1457:

Line 1458: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1454:
1455: lv_error_message :=
1456: pay_emp_action_arch.set_error_message(lv_error_message);
1457:
1458: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1459: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1460: hr_utility.raise_error;
1461:
1462: END initialization_code;

Line 1459: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

1455: lv_error_message :=
1456: pay_emp_action_arch.set_error_message(lv_error_message);
1457:
1458: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1459: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1460: hr_utility.raise_error;
1461:
1462: END initialization_code;
1463:

Line 1460: hr_utility.raise_error;

1456: pay_emp_action_arch.set_error_message(lv_error_message);
1457:
1458: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1459: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1460: hr_utility.raise_error;
1461:
1462: END initialization_code;
1463:
1464: /************************************************************

Line 1542: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);

1538: WHERE lookup_type = 'YES_NO'
1539: AND lookup_code = 'Y';
1540: BEGIN
1541: lv_procedure_name := '.archive_code';
1542: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
1543:
1544: OPEN c_get_person (g_start_date, g_end_date);
1545: FETCH c_get_person INTO ln_assignment_id,
1546: lv_assignment_number,

Line 1552: hr_utility.trace('Assignment ID: ' || ln_assignment_id);

1548: ln_business_group_id,
1549: ln_payroll_action_id;
1550: CLOSE c_get_person;
1551:
1552: hr_utility.trace('Assignment ID: ' || ln_assignment_id);
1553: hr_utility.trace('Person ID: ' || ln_person_id);
1554:
1555: hr_utility.trace('gd_start_date: '||gd_start_date);
1556: hr_utility.trace('gd_end_date: '||gd_end_date);

Line 1553: hr_utility.trace('Person ID: ' || ln_person_id);

1549: ln_payroll_action_id;
1550: CLOSE c_get_person;
1551:
1552: hr_utility.trace('Assignment ID: ' || ln_assignment_id);
1553: hr_utility.trace('Person ID: ' || ln_person_id);
1554:
1555: hr_utility.trace('gd_start_date: '||gd_start_date);
1556: hr_utility.trace('gd_end_date: '||gd_end_date);
1557:

Line 1555: hr_utility.trace('gd_start_date: '||gd_start_date);

1551:
1552: hr_utility.trace('Assignment ID: ' || ln_assignment_id);
1553: hr_utility.trace('Person ID: ' || ln_person_id);
1554:
1555: hr_utility.trace('gd_start_date: '||gd_start_date);
1556: hr_utility.trace('gd_end_date: '||gd_end_date);
1557:
1558: get_payroll_action_info(p_payroll_action_id => ln_payroll_action_id
1559: ,p_start_date => ld_start_date

Line 1556: hr_utility.trace('gd_end_date: '||gd_end_date);

1552: hr_utility.trace('Assignment ID: ' || ln_assignment_id);
1553: hr_utility.trace('Person ID: ' || ln_person_id);
1554:
1555: hr_utility.trace('gd_start_date: '||gd_start_date);
1556: hr_utility.trace('gd_end_date: '||gd_end_date);
1557:
1558: get_payroll_action_info(p_payroll_action_id => ln_payroll_action_id
1559: ,p_start_date => ld_start_date
1560: ,p_effective_date => ld_date_earned

Line 1570: hr_utility.trace('ld_end_date: '||ld_end_date);

1566: ld_end_date := ADD_MONTHS(ld_start_date, 12) - 1;
1567:
1568: lv_legal_ER_name := hr_general.decode_organization(ln_legal_employer_id);
1569:
1570: hr_utility.trace('ld_end_date: '||ld_end_date);
1571: hr_utility.trace('lv_legal_ER_name: '||lv_legal_ER_name);
1572:
1573: BEGIN
1574: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,

Line 1571: hr_utility.trace('lv_legal_ER_name: '||lv_legal_ER_name);

1567:
1568: lv_legal_ER_name := hr_general.decode_organization(ln_legal_employer_id);
1569:
1570: hr_utility.trace('ld_end_date: '||ld_end_date);
1571: hr_utility.trace('lv_legal_ER_name: '||lv_legal_ER_name);
1572:
1573: BEGIN
1574: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,
1575: 'PTU Factors',

Line 1585: hr_utility.trace('g_ptu_calc_method: '||g_ptu_calc_method);

1581: WHEN NO_DATA_FOUND THEN
1582: g_ptu_calc_method := 'DAILY_WAGE';
1583: END;
1584:
1585: hr_utility.trace('g_ptu_calc_method: '||g_ptu_calc_method);
1586:
1587: OPEN c_get_ytd_aaid(gd_start_date,
1588: gd_end_date,
1589: ln_person_id);

Line 1593: hr_utility.trace('YTD AA ID: ' || ln_ytd_asg_act_id );

1589: ln_person_id);
1590: FETCH c_get_ytd_aaid INTO ln_ytd_asg_act_id;
1591: CLOSE c_get_ytd_aaid;
1592:
1593: hr_utility.trace('YTD AA ID: ' || ln_ytd_asg_act_id );
1594:
1595: ln_step := 1;
1596: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1597:

Line 1596: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1592:
1593: hr_utility.trace('YTD AA ID: ' || ln_ytd_asg_act_id );
1594:
1595: ln_step := 1;
1596: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1597:
1598: /*bug 8437173 area 5*/
1599: FOR cntr_gre IN
1600: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()

Line 1698: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);

1694: p_object_version_number => ln_ovn);
1695:
1696: END IF;
1697:
1698: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);
1699:
1700: EXCEPTION
1701: WHEN OTHERS THEN
1702: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||

Line 1705: hr_utility.trace(lv_error_message || '-' || SQLERRM);

1701: WHEN OTHERS THEN
1702: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||
1703: gv_package || lv_procedure_name;
1704:
1705: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1706:
1707: lv_error_message :=
1708: pay_emp_action_arch.set_error_message(lv_error_message);
1709:

Line 1710: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1706:
1707: lv_error_message :=
1708: pay_emp_action_arch.set_error_message(lv_error_message);
1709:
1710: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1711: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1712: hr_utility.raise_error;
1713:
1714: END archive_code;

Line 1711: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

1707: lv_error_message :=
1708: pay_emp_action_arch.set_error_message(lv_error_message);
1709:
1710: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1711: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1712: hr_utility.raise_error;
1713:
1714: END archive_code;
1715:

Line 1712: hr_utility.raise_error;

1708: pay_emp_action_arch.set_error_message(lv_error_message);
1709:
1710: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1711: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1712: hr_utility.raise_error;
1713:
1714: END archive_code;
1715:
1716: /************************************************************

Line 1733: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);

1729: ln_step NUMBER;
1730:
1731: BEGIN
1732: lv_procedure_name := '.deinit_code';
1733: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
1734:
1735: ln_step := 1;
1736: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1737:

Line 1736: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1732: lv_procedure_name := '.deinit_code';
1733: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
1734:
1735: ln_step := 1;
1736: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1737:
1738: DELETE
1739: FROM pay_action_information
1740: WHERE action_information_category = 'MX PROFIT SHARING FACTORS'

Line 1744: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);

1740: WHERE action_information_category = 'MX PROFIT SHARING FACTORS'
1741: AND action_context_id = p_payroll_action_id
1742: AND action_context_type = 'PA';
1743:
1744: hr_utility.trace('Leaving ' || gv_package || lv_procedure_name);
1745:
1746: EXCEPTION
1747: WHEN OTHERS THEN
1748: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||

Line 1751: hr_utility.trace(lv_error_message || '-' || SQLERRM);

1747: WHEN OTHERS THEN
1748: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||
1749: gv_package || lv_procedure_name;
1750:
1751: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1752:
1753: lv_error_message :=
1754: pay_emp_action_arch.set_error_message(lv_error_message);
1755:

Line 1756: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1752:
1753: lv_error_message :=
1754: pay_emp_action_arch.set_error_message(lv_error_message);
1755:
1756: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1757: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1758: hr_utility.raise_error;
1759:
1760: END deinit_code;

Line 1757: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

1753: lv_error_message :=
1754: pay_emp_action_arch.set_error_message(lv_error_message);
1755:
1756: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1757: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1758: hr_utility.raise_error;
1759:
1760: END deinit_code;
1761:

Line 1758: hr_utility.raise_error;

1754: pay_emp_action_arch.set_error_message(lv_error_message);
1755:
1756: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1757: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1758: hr_utility.raise_error;
1759:
1760: END deinit_code;
1761:
1762: BEGIN

Line 1763: --hr_utility.trace_on (NULL, 'MX_IDC');

1759:
1760: END deinit_code;
1761:
1762: BEGIN
1763: --hr_utility.trace_on (NULL, 'MX_IDC');
1764: gv_package := 'pay_mx_PTU_calc';
1765: END pay_mx_PTU_calc;