[Home] [Help]
67:
68: BEGIN
69: lv_procedure_name := '.get_payroll_action_info';
70:
71: hr_utility.set_location(gv_package || lv_procedure_name, 10);
72: ln_step := 1;
73: OPEN c_payroll_action_info(p_payroll_action_id);
74: FETCH c_payroll_action_info INTO ld_end_date,
75: ld_start_date,
77: ln_cons_set_id,
78: ln_payroll_id;
79: CLOSE c_payroll_action_info;
80:
81: hr_utility.set_location(gv_package || lv_procedure_name, 30);
82: p_end_date := ld_end_date;
83: p_start_date := ld_start_date;
84: p_business_group_id := ln_business_group_id;
85: p_cons_set_id := ln_cons_set_id;
83: p_start_date := ld_start_date;
84: p_business_group_id := ln_business_group_id;
85: p_cons_set_id := ln_cons_set_id;
86: p_payroll_id := ln_payroll_id;
87: hr_utility.set_location(gv_package || lv_procedure_name, 50);
88: ln_step := 2;
89:
90: EXCEPTION
91: WHEN OTHERS THEN
91: WHEN OTHERS THEN
92: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||
93: gv_package || lv_procedure_name;
94:
95: hr_utility.trace(lv_error_message || '-' || SQLERRM);
96:
97: lv_error_message :=
98: pay_emp_action_arch.set_error_message(lv_error_message);
99:
96:
97: lv_error_message :=
98: pay_emp_action_arch.set_error_message(lv_error_message);
99:
100: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
101: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
102: hr_utility.raise_error;
103:
104: END get_payroll_action_info;
97: lv_error_message :=
98: pay_emp_action_arch.set_error_message(lv_error_message);
99:
100: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
101: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
102: hr_utility.raise_error;
103:
104: END get_payroll_action_info;
105:
98: pay_emp_action_arch.set_error_message(lv_error_message);
99:
100: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
101: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
102: hr_utility.raise_error;
103:
104: END get_payroll_action_info;
105:
106: /******************************************************************
198: lv_action_category := 'AC DEDUCTIONS';
199: lv_procedure_name := '.populate_elements';
200:
201: ln_step := 1;
202: hr_utility.set_location(gv_package || lv_procedure_name, 10);
203: hr_utility.trace('p_pymt_assignment_action_id '
204: ||to_char(p_pymt_assignment_action_id));
205: hr_utility.trace('p_pymt_eff_date '
206: ||to_char(p_pymt_eff_date));
199: lv_procedure_name := '.populate_elements';
200:
201: ln_step := 1;
202: hr_utility.set_location(gv_package || lv_procedure_name, 10);
203: hr_utility.trace('p_pymt_assignment_action_id '
204: ||to_char(p_pymt_assignment_action_id));
205: hr_utility.trace('p_pymt_eff_date '
206: ||to_char(p_pymt_eff_date));
207: hr_utility.trace('p_primary_balance_id '
201: ln_step := 1;
202: hr_utility.set_location(gv_package || lv_procedure_name, 10);
203: hr_utility.trace('p_pymt_assignment_action_id '
204: ||to_char(p_pymt_assignment_action_id));
205: hr_utility.trace('p_pymt_eff_date '
206: ||to_char(p_pymt_eff_date));
207: hr_utility.trace('p_primary_balance_id '
208: ||to_char(p_primary_balance_id));
209: hr_utility.trace('p_reporting_name '
203: hr_utility.trace('p_pymt_assignment_action_id '
204: ||to_char(p_pymt_assignment_action_id));
205: hr_utility.trace('p_pymt_eff_date '
206: ||to_char(p_pymt_eff_date));
207: hr_utility.trace('p_primary_balance_id '
208: ||to_char(p_primary_balance_id));
209: hr_utility.trace('p_reporting_name '
210: ||p_reporting_name);
211: hr_utility.trace('p_ytd_balcall_aaid '
205: hr_utility.trace('p_pymt_eff_date '
206: ||to_char(p_pymt_eff_date));
207: hr_utility.trace('p_primary_balance_id '
208: ||to_char(p_primary_balance_id));
209: hr_utility.trace('p_reporting_name '
210: ||p_reporting_name);
211: hr_utility.trace('p_ytd_balcall_aaid '
212: ||to_char(p_ytd_balcall_aaid));
213: hr_utility.trace('p_pymt_balcall_aaid '
207: hr_utility.trace('p_primary_balance_id '
208: ||to_char(p_primary_balance_id));
209: hr_utility.trace('p_reporting_name '
210: ||p_reporting_name);
211: hr_utility.trace('p_ytd_balcall_aaid '
212: ||to_char(p_ytd_balcall_aaid));
213: hr_utility.trace('p_pymt_balcall_aaid '
214: ||to_char(p_pymt_balcall_aaid));
215: hr_utility.trace('p_legislation_code '
209: hr_utility.trace('p_reporting_name '
210: ||p_reporting_name);
211: hr_utility.trace('p_ytd_balcall_aaid '
212: ||to_char(p_ytd_balcall_aaid));
213: hr_utility.trace('p_pymt_balcall_aaid '
214: ||to_char(p_pymt_balcall_aaid));
215: hr_utility.trace('p_legislation_code '
216: ||p_legislation_code);
217: hr_utility.trace('p_hours_balance_id '
211: hr_utility.trace('p_ytd_balcall_aaid '
212: ||to_char(p_ytd_balcall_aaid));
213: hr_utility.trace('p_pymt_balcall_aaid '
214: ||to_char(p_pymt_balcall_aaid));
215: hr_utility.trace('p_legislation_code '
216: ||p_legislation_code);
217: hr_utility.trace('p_hours_balance_id '
218: ||to_char(p_hours_balance_id));
219: hr_utility.trace('p_days_balance_id '
213: hr_utility.trace('p_pymt_balcall_aaid '
214: ||to_char(p_pymt_balcall_aaid));
215: hr_utility.trace('p_legislation_code '
216: ||p_legislation_code);
217: hr_utility.trace('p_hours_balance_id '
218: ||to_char(p_hours_balance_id));
219: hr_utility.trace('p_days_balance_id '
220: ||to_char(p_days_balance_id));
221:
215: hr_utility.trace('p_legislation_code '
216: ||p_legislation_code);
217: hr_utility.trace('p_hours_balance_id '
218: ||to_char(p_hours_balance_id));
219: hr_utility.trace('p_days_balance_id '
220: ||to_char(p_days_balance_id));
221:
222: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
223: pay_emp_action_arch.gv_multi_leg_rule
245: p_primary_balance_id,
246: gv_ytd_balance_dimension,
247: p_legislation_code);
248:
249: hr_utility.trace('ln_ytd_defined_balance_id = ' ||
250: ln_ytd_defined_balance_id);
251:
252: ln_step := 4;
253: IF p_hours_balance_id IS NOT NULL THEN
250: ln_ytd_defined_balance_id);
251:
252: ln_step := 4;
253: IF p_hours_balance_id IS NOT NULL THEN
254: hr_utility.set_location(gv_package || lv_procedure_name, 20);
255: ln_ytd_hours_balance_id
256: := pay_emp_action_arch.get_defined_balance_id(
257: p_hours_balance_id,
258: gv_ytd_balance_dimension,
257: p_hours_balance_id,
258: gv_ytd_balance_dimension,
259: p_legislation_code);
260:
261: hr_utility.trace('ln_ytd_hours_balance_id = ' ||
262: ln_ytd_hours_balance_id);
263:
264: END IF;
265:
263:
264: END IF;
265:
266: IF p_days_balance_id IS NOT NULL THEN
267: hr_utility.set_location(gv_package || lv_procedure_name, 20);
268: ln_ytd_days_balance_id
269: := pay_emp_action_arch.get_defined_balance_id(
270: p_days_balance_id,
271: gv_ytd_balance_dimension,
270: p_days_balance_id,
271: gv_ytd_balance_dimension,
272: p_legislation_code);
273:
274: hr_utility.trace('ln_ytd_days_balance_id = ' ||
275: ln_ytd_days_balance_id);
276:
277: END IF;
278:
276:
277: END IF;
278:
279: ln_step := 5;
280: hr_utility.set_location(gv_package || lv_procedure_name, 30);
281:
282: ln_step := 6;
283: lv_rate_exists := 'N';
284:
296: END IF;
297: END LOOP;
298: END IF;
299:
300: hr_utility.trace('lv_rate_exists = ' || lv_rate_exists);
301:
302: IF lv_rate_exists = 'N' THEN
303: ln_step := 7;
304: hr_utility.set_location(gv_package || lv_procedure_name, 40);
300: hr_utility.trace('lv_rate_exists = ' || lv_rate_exists);
301:
302: IF lv_rate_exists = 'N' THEN
303: ln_step := 7;
304: hr_utility.set_location(gv_package || lv_procedure_name, 40);
305: IF ln_ytd_defined_balance_id IS NOT NULL THEN
306: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
307: ln_ytd_defined_balance_id,
308: p_ytd_balcall_aaid),0);
308: p_ytd_balcall_aaid),0);
309: END IF;
310:
311: IF p_hours_balance_id IS NOT NULL THEN
312: hr_utility.set_location(gv_package || lv_procedure_name, 50);
313: IF ln_ytd_hours_balance_id IS NOT NULL THEN
314: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
315: ln_ytd_hours_balance_id,
316: p_ytd_balcall_aaid),0);
313: IF ln_ytd_hours_balance_id IS NOT NULL THEN
314: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
315: ln_ytd_hours_balance_id,
316: p_ytd_balcall_aaid),0);
317: hr_utility.set_location(gv_package || lv_procedure_name, 60);
318: END IF;
319: END IF; --Hours
320:
321: IF p_days_balance_id IS NOT NULL THEN
318: END IF;
319: END IF; --Hours
320:
321: IF p_days_balance_id IS NOT NULL THEN
322: hr_utility.set_location(gv_package || lv_procedure_name, 50);
323: IF ln_ytd_days_balance_id IS NOT NULL THEN
324: ln_ytd_days := NVL(pay_balance_pkg.get_value(
325: ln_ytd_days_balance_id,
326: p_ytd_balcall_aaid),0);
323: IF ln_ytd_days_balance_id IS NOT NULL THEN
324: ln_ytd_days := NVL(pay_balance_pkg.get_value(
325: ln_ytd_days_balance_id,
326: p_ytd_balcall_aaid),0);
327: hr_utility.set_location(gv_package || lv_procedure_name, 60);
328: END IF;
329: END IF; --Days
330:
331: ln_step := 8;
352: p_legislation_code);
353: END IF;
354: END IF; -- p_action_type IN ('B','V')
355: /* END of addition FOR Reversals AND bal adjustments */
356: hr_utility.trace('ln_pymt_defined_balance_id ' ||
357: ln_pymt_defined_balance_id);
358: IF ln_pymt_defined_balance_id IS NOT NULL THEN
359: ln_payments_amount := NVL(pay_balance_pkg.get_value(
360: ln_pymt_defined_balance_id,
358: IF ln_pymt_defined_balance_id IS NOT NULL THEN
359: ln_payments_amount := NVL(pay_balance_pkg.get_value(
360: ln_pymt_defined_balance_id,
361: p_pymt_balcall_aaid),0);
362: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
363: END IF;
364:
365: IF p_hours_balance_id IS NOT NULL THEN
366: IF p_action_type IN ('B','V') THEN
384: ,p_legislation_code);
385: END IF;
386: END IF; -- p_action_type IN ('B','V')
387:
388: hr_utility.trace('ln_pymt_hours_balance_id ' ||
389: ln_pymt_hours_balance_id);
390: IF ln_pymt_hours_balance_id IS NOT NULL THEN
391: ln_current_hours := NVL(pay_balance_pkg.get_value(
392: ln_pymt_hours_balance_id,
391: ln_current_hours := NVL(pay_balance_pkg.get_value(
392: ln_pymt_hours_balance_id,
393: p_pymt_balcall_aaid),0);
394: END IF;
395: hr_utility.set_location(gv_package || lv_procedure_name, 120);
396: END IF; --Hours
397:
398: IF p_days_balance_id IS NOT NULL THEN
399: IF p_action_type IN ('B','V') THEN
417: ,p_legislation_code);
418: END IF;
419: END IF; -- p_action_type in ('B','V')
420:
421: hr_utility.trace('ln_pymt_days_balance_id ' ||
422: ln_pymt_days_balance_id);
423: IF ln_pymt_days_balance_id IS NOT NULL THEN
424: ln_current_days := NVL(pay_balance_pkg.get_value(
425: ln_pymt_days_balance_id,
424: ln_current_days := NVL(pay_balance_pkg.get_value(
425: ln_pymt_days_balance_id,
426: p_pymt_balcall_aaid),0);
427: END IF;
428: hr_utility.set_location(gv_package || lv_procedure_name, 120);
429: END IF; --Days
430:
431: END IF; -- p_pymt_balcall_aaid is not NULL
432:
436:
437: IF p_attribute_name IN ('Employee Earnings', 'Hourly Earnings',
438: 'Taxable Benefits') THEN
439:
440: hr_utility.set_location(gv_package || lv_procedure_name, 125);
441: lv_action_category := 'AC EARNINGS';
442: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
443: := fnd_number.number_to_canonical(ln_current_hours);
444: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
450: := fnd_number.number_to_canonical(ln_ytd_days);
451:
452: END IF;
453:
454: hr_utility.set_location(gv_package || lv_procedure_name, 130);
455: /* Insert this into the plsql table if Current or YTD
456: amount is not Zero */
457: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
458: := lv_action_category;
473:
474: END IF;
475: END IF; -- lv_rate_exists = 'N'
476:
477: hr_utility.set_location(gv_package || lv_procedure_name, 150);
478: ln_step := 20;
479:
480: EXCEPTION
481: WHEN OTHERS THEN
478: ln_step := 20;
479:
480: EXCEPTION
481: WHEN OTHERS THEN
482: hr_utility.set_location(gv_package || lv_procedure_name, 200);
483: lv_error_message := 'Error at step ' || ln_step ||
484: ' IN ' || gv_package || lv_procedure_name;
485:
486: hr_utility.trace(lv_error_message || '-' || SQLERRM);
482: hr_utility.set_location(gv_package || lv_procedure_name, 200);
483: lv_error_message := 'Error at step ' || ln_step ||
484: ' IN ' || gv_package || lv_procedure_name;
485:
486: hr_utility.trace(lv_error_message || '-' || SQLERRM);
487:
488: lv_error_message :=
489: pay_emp_action_arch.set_error_message(lv_error_message);
490:
487:
488: lv_error_message :=
489: pay_emp_action_arch.set_error_message(lv_error_message);
490:
491: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
492: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
493: hr_utility.raise_error;
494:
495: END populate_elements;
488: lv_error_message :=
489: pay_emp_action_arch.set_error_message(lv_error_message);
490:
491: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
492: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
493: hr_utility.raise_error;
494:
495: END populate_elements;
496:
489: pay_emp_action_arch.set_error_message(lv_error_message);
490:
491: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
492: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
493: hr_utility.raise_error;
494:
495: END populate_elements;
496:
497:
658: lv_element_archived := 'N';
659: lv_procedure_name := '.get_missing_xfr_info';
660:
661: ln_step := 1;
662: hr_utility.set_location(gv_package || lv_procedure_name, 10);
663: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
664: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
665: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );
666: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);
659: lv_procedure_name := '.get_missing_xfr_info';
660:
661: ln_step := 1;
662: hr_utility.set_location(gv_package || lv_procedure_name, 10);
663: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
664: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
665: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );
666: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);
667:
660:
661: ln_step := 1;
662: hr_utility.set_location(gv_package || lv_procedure_name, 10);
663: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
664: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
665: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );
666: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);
667:
668: lv_run_bal_status := NULL;
661: ln_step := 1;
662: hr_utility.set_location(gv_package || lv_procedure_name, 10);
663: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
664: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
665: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );
666: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);
667:
668: lv_run_bal_status := NULL;
669:
662: hr_utility.set_location(gv_package || lv_procedure_name, 10);
663: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
664: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
665: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );
666: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);
667:
668: lv_run_bal_status := NULL;
669:
670: IF run_bal_stat.COUNT >0 THEN
730: ln_primary_balance_id,
731: ln_hours_balance_id,
732: ln_days_balance_id;
733: IF c_prev_elements_RR%NOTFOUND THEN
734: hr_utility.set_location(gv_package || lv_procedure_name, 15);
735: EXIT;
736: END IF;
737: hr_utility.set_location(gv_package || lv_procedure_name, 20);
738:
733: IF c_prev_elements_RR%NOTFOUND THEN
734: hr_utility.set_location(gv_package || lv_procedure_name, 15);
735: EXIT;
736: END IF;
737: hr_utility.set_location(gv_package || lv_procedure_name, 20);
738:
739: ELSE
740:
741: FETCH c_prev_elements INTO lv_reporting_name,
744: ln_primary_balance_id,
745: ln_hours_balance_id,
746: ln_days_balance_id;
747: IF c_prev_elements%NOTFOUND THEN
748: hr_utility.set_location(gv_package || lv_procedure_name, 25);
749: EXIT;
750: END IF;
751: hr_utility.set_location(gv_package || lv_procedure_name, 30);
752:
747: IF c_prev_elements%NOTFOUND THEN
748: hr_utility.set_location(gv_package || lv_procedure_name, 25);
749: EXIT;
750: END IF;
751: hr_utility.set_location(gv_package || lv_procedure_name, 30);
752:
753: END IF;
754:
755: IF lv_attribute_name IN ('Deductions', 'Employee Taxes',
798: pay_emp_action_arch.get_defined_balance_id
799: (ln_primary_balance_id,
800: gv_ytd_balance_dimension,
801: p_legislation_code);
802: hr_utility.set_location(gv_package || lv_procedure_name, 60);
803: IF ln_ytd_defined_balance_id IS NOT NULL THEN
804: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
805: ln_ytd_defined_balance_id,
806: p_ytd_balcall_aaid),0);
803: IF ln_ytd_defined_balance_id IS NOT NULL THEN
804: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
805: ln_ytd_defined_balance_id,
806: p_ytd_balcall_aaid),0);
807: hr_utility.set_location(gv_package || lv_procedure_name, 70);
808: END IF;
809: IF ln_hours_balance_id IS NOT NULL THEN
810: ln_ytd_hours_balance_id :=
811: pay_emp_action_arch.get_defined_balance_id
811: pay_emp_action_arch.get_defined_balance_id
812: (ln_hours_balance_id,
813: gv_ytd_balance_dimension,
814: p_legislation_code);
815: hr_utility.set_location(gv_package || lv_procedure_name, 80);
816: IF ln_ytd_hours_balance_id IS NOT NULL THEN
817: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
818: ln_ytd_hours_balance_id,
819: p_ytd_balcall_aaid),0);
816: IF ln_ytd_hours_balance_id IS NOT NULL THEN
817: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
818: ln_ytd_hours_balance_id,
819: p_ytd_balcall_aaid),0);
820: hr_utility.set_location(gv_package || lv_procedure_name, 90);
821: END IF;
822: END IF; -- Hours
823:
824: IF ln_days_balance_id IS NOT NULL THEN
826: pay_emp_action_arch.get_defined_balance_id
827: (ln_days_balance_id,
828: gv_ytd_balance_dimension,
829: p_legislation_code);
830: hr_utility.set_location(gv_package || lv_procedure_name, 80);
831: IF ln_ytd_days_balance_id IS NOT NULL THEN
832: ln_ytd_days := NVL(pay_balance_pkg.get_value(
833: ln_ytd_days_balance_id,
834: p_ytd_balcall_aaid),0);
831: IF ln_ytd_days_balance_id IS NOT NULL THEN
832: ln_ytd_days := NVL(pay_balance_pkg.get_value(
833: ln_ytd_days_balance_id,
834: p_ytd_balcall_aaid),0);
835: hr_utility.set_location(gv_package || lv_procedure_name, 90);
836: END IF;
837: END IF; -- Days
838:
839: hr_utility.set_location(gv_package || lv_procedure_name, 100);
835: hr_utility.set_location(gv_package || lv_procedure_name, 90);
836: END IF;
837: END IF; -- Days
838:
839: hr_utility.set_location(gv_package || lv_procedure_name, 100);
840:
841: IF NVL(ln_ytd_amount, 0) <> 0 OR NVL(ln_payments_amount, 0) <> 0 THEN
842:
843: ln_index := pay_ac_action_arch.lrr_act_tab.count;
840:
841: IF NVL(ln_ytd_amount, 0) <> 0 OR NVL(ln_payments_amount, 0) <> 0 THEN
842:
843: ln_index := pay_ac_action_arch.lrr_act_tab.count;
844: hr_utility.trace('ln_index = ' || ln_index);
845:
846: IF lv_attribute_name IN ('Employee Earnings',
847: 'Hourly Earnings',
848: 'Taxable Benefits') THEN
888: ELSE
889: CLOSE c_prev_elements;
890: END IF;
891:
892: hr_utility.set_location(gv_package || lv_procedure_name, 150);
893:
894: ln_step := 30;
895:
896:
899:
900: lv_error_message := 'Error at step ' || ln_step ||
901: ' IN ' || gv_package || lv_procedure_name;
902:
903: hr_utility.trace(lv_error_message || '-' || SQLERRM);
904:
905: lv_error_message :=
906: pay_emp_action_arch.set_error_message(lv_error_message);
907:
904:
905: lv_error_message :=
906: pay_emp_action_arch.set_error_message(lv_error_message);
907:
908: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
909: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
910: hr_utility.raise_error;
911:
912: END get_missing_xfr_info;
905: lv_error_message :=
906: pay_emp_action_arch.set_error_message(lv_error_message);
907:
908: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
909: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
910: hr_utility.raise_error;
911:
912: END get_missing_xfr_info;
913:
906: pay_emp_action_arch.set_error_message(lv_error_message);
907:
908: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
909: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
910: hr_utility.raise_error;
911:
912: END get_missing_xfr_info;
913:
914:
1056: lv_action_info_category := 'AC DEDUCTIONS';
1057: lv_procedure_name := '.get_xfr_elements';
1058:
1059: ln_step:= 1;
1060: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1061: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1062: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1063: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1064: hr_utility.trace('gv_multi_payroll_pymt = '||
1057: lv_procedure_name := '.get_xfr_elements';
1058:
1059: ln_step:= 1;
1060: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1061: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1062: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1063: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1064: hr_utility.trace('gv_multi_payroll_pymt = '||
1065: pay_emp_action_arch.gv_multi_payroll_pymt);
1058:
1059: ln_step:= 1;
1060: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1061: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1062: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1063: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1064: hr_utility.trace('gv_multi_payroll_pymt = '||
1065: pay_emp_action_arch.gv_multi_payroll_pymt);
1066: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
1059: ln_step:= 1;
1060: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1061: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1062: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1063: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1064: hr_utility.trace('gv_multi_payroll_pymt = '||
1065: pay_emp_action_arch.gv_multi_payroll_pymt);
1066: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
1067:
1060: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1061: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1062: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1063: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1064: hr_utility.trace('gv_multi_payroll_pymt = '||
1065: pay_emp_action_arch.gv_multi_payroll_pymt);
1066: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
1067:
1068: cn_last_xfr_action_id := p_last_xfr_action_id;
1062: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1063: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1064: hr_utility.trace('gv_multi_payroll_pymt = '||
1065: pay_emp_action_arch.gv_multi_payroll_pymt);
1066: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
1067:
1068: cn_last_xfr_action_id := p_last_xfr_action_id;
1069:
1070: IF pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' AND
1072:
1073: OPEN c_last_per_xfr_run;
1074: FETCH c_last_per_xfr_run INTO ln_last_per_xfr_action_id;
1075: IF c_last_per_xfr_run%FOUND THEN
1076: hr_utility.trace('found ln_last_per_xfr_action_id = '||
1077: ln_last_per_xfr_action_id);
1078: cn_last_xfr_action_id := ln_last_per_xfr_action_id;
1079: END IF;
1080: CLOSE c_last_per_xfr_run;
1078: cn_last_xfr_action_id := ln_last_per_xfr_action_id;
1079: END IF;
1080: CLOSE c_last_per_xfr_run;
1081:
1082: hr_utility.trace('New cn_last_xfr_action_id = '||cn_last_xfr_action_id);
1083: END IF;
1084:
1085:
1086: OPEN c_last_xfr_elements(cn_last_xfr_action_id, p_legislation_code);
1095: ln_ytd_hours,
1096: ln_ytd_days,
1097: lv_attribute_name;
1098:
1099: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1100: IF c_last_xfr_elements%NOTFOUND THEN
1101: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1102: EXIT;
1103: END IF;
1097: lv_attribute_name;
1098:
1099: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1100: IF c_last_xfr_elements%NOTFOUND THEN
1101: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1102: EXIT;
1103: END IF;
1104:
1105: ln_step := 5;
1109: CLOSE c_get_balance;
1110: ln_primary_balance_id := ln_t_primary_balance_id;
1111: END IF;
1112:
1113: hr_utility.trace('Reporting Name =' || lv_reporting_name);
1114: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
1115:
1116: ln_step := 6;
1117:
1110: ln_primary_balance_id := ln_t_primary_balance_id;
1111: END IF;
1112:
1113: hr_utility.trace('Reporting Name =' || lv_reporting_name);
1114: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
1115:
1116: ln_step := 6;
1117:
1118: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
1114: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
1115:
1116: ln_step := 6;
1117:
1118: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
1119: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
1120:
1121: IF ((pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' ) AND
1122: (p_sepchk_flag = 'Y') AND
1115:
1116: ln_step := 6;
1117:
1118: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
1119: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
1120:
1121: IF ((pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' ) AND
1122: (p_sepchk_flag = 'Y') AND
1123: (ln_assignment_id <> p_assignment_id)) THEN
1121: IF ((pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' ) AND
1122: (p_sepchk_flag = 'Y') AND
1123: (ln_assignment_id <> p_assignment_id)) THEN
1124:
1125: hr_utility.trace('action_info_category = ' ||lv_act_info_category);
1126: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
1127: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
1128:
1129: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1122: (p_sepchk_flag = 'Y') AND
1123: (ln_assignment_id <> p_assignment_id)) THEN
1124:
1125: hr_utility.trace('action_info_category = ' ||lv_act_info_category);
1126: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
1127: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
1128:
1129: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1130:
1123: (ln_assignment_id <> p_assignment_id)) THEN
1124:
1125: hr_utility.trace('action_info_category = ' ||lv_act_info_category);
1126: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
1127: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
1128:
1129: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1130:
1131: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1168: END IF;
1169:
1170: ln_step := 10;
1171: IF lv_element_archived = 'N' THEN
1172: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1173: /**************************************************************
1174: ** Check to see if the element is still effective
1175: ** the primary balance IS there before archiving
1176: ** the value when picking elements which have
1224: := pay_emp_action_arch.get_defined_balance_id
1225: (ln_primary_balance_id,
1226: gv_ytd_balance_dimension,
1227: p_legislation_code);
1228: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1229: IF ln_ytd_defined_balance_id IS NOT NULL THEN
1230: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
1231: ln_ytd_defined_balance_id,
1232: p_ytd_balcall_aaid),0);
1230: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
1231: ln_ytd_defined_balance_id,
1232: p_ytd_balcall_aaid),0);
1233: END IF;
1234: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1235: IF ln_hours_balance_id IS NOT NULL THEN
1236: ln_ytd_hours_balance_id
1237: := pay_emp_action_arch.get_defined_balance_id
1238: (ln_hours_balance_id,
1237: := pay_emp_action_arch.get_defined_balance_id
1238: (ln_hours_balance_id,
1239: gv_ytd_balance_dimension,
1240: p_legislation_code);
1241: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1242: IF ln_ytd_hours_balance_id IS NOT NULL THEN
1243: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
1244: ln_ytd_hours_balance_id,
1245: p_ytd_balcall_aaid),0);
1242: IF ln_ytd_hours_balance_id IS NOT NULL THEN
1243: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
1244: ln_ytd_hours_balance_id,
1245: p_ytd_balcall_aaid),0);
1246: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1247: END IF;
1248: END IF;
1249:
1250: IF ln_days_balance_id IS NOT NULL THEN
1252: := pay_emp_action_arch.get_defined_balance_id
1253: (ln_days_balance_id,
1254: gv_ytd_balance_dimension,
1255: p_legislation_code);
1256: hr_utility.set_location(gv_package || lv_procedure_name, 93);
1257: IF ln_ytd_days_balance_id IS NOT NULL THEN
1258: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
1259: ln_ytd_days_balance_id,
1260: p_ytd_balcall_aaid),0);
1257: IF ln_ytd_days_balance_id IS NOT NULL THEN
1258: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
1259: ln_ytd_days_balance_id,
1260: p_ytd_balcall_aaid),0);
1261: hr_utility.set_location(gv_package || lv_procedure_name, 96);
1262: END IF;
1263: END IF;
1264:
1265: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
1261: hr_utility.set_location(gv_package || lv_procedure_name, 96);
1262: END IF;
1263: END IF;
1264:
1265: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
1266: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
1267: hr_utility.trace('ln_ytd_days = '||ln_ytd_days);
1268:
1269: IF (( NVL(ln_ytd_amount, 0) + NVL(ln_payments_amount, 0) <> 0 ) OR
1262: END IF;
1263: END IF;
1264:
1265: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
1266: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
1267: hr_utility.trace('ln_ytd_days = '||ln_ytd_days);
1268:
1269: IF (( NVL(ln_ytd_amount, 0) + NVL(ln_payments_amount, 0) <> 0 ) OR
1270: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) THEN
1263: END IF;
1264:
1265: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
1266: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
1267: hr_utility.trace('ln_ytd_days = '||ln_ytd_days);
1268:
1269: IF (( NVL(ln_ytd_amount, 0) + NVL(ln_payments_amount, 0) <> 0 ) OR
1270: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) THEN
1271:
1268:
1269: IF (( NVL(ln_ytd_amount, 0) + NVL(ln_payments_amount, 0) <> 0 ) OR
1270: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) THEN
1271:
1272: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1273: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1274: hr_utility.trace('ln_index = ' || ln_index);
1275: ln_step := 20;
1276: IF lv_attribute_name IN ('Employee Earnings',
1270: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) THEN
1271:
1272: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1273: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1274: hr_utility.trace('ln_index = ' || ln_index);
1275: ln_step := 20;
1276: IF lv_attribute_name IN ('Employee Earnings',
1277: 'Hourly Earnings',
1278: 'Taxable Benefits') THEN
1315: END LOOP;
1316:
1317: CLOSE c_last_xfr_elements;
1318:
1319: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1320: ln_step := 25;
1321:
1322:
1323:
1325: WHEN OTHERS THEN
1326: lv_error_message := 'Error at step ' || ln_step ||
1327: ' IN ' || gv_package || lv_procedure_name;
1328:
1329: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1330:
1331: lv_error_message :=
1332: pay_emp_action_arch.set_error_message(lv_error_message);
1333:
1330:
1331: lv_error_message :=
1332: pay_emp_action_arch.set_error_message(lv_error_message);
1333:
1334: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1335: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1336: hr_utility.raise_error;
1337:
1338: END get_xfr_elements;
1331: lv_error_message :=
1332: pay_emp_action_arch.set_error_message(lv_error_message);
1333:
1334: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1335: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1336: hr_utility.raise_error;
1337:
1338: END get_xfr_elements;
1339:
1332: pay_emp_action_arch.set_error_message(lv_error_message);
1333:
1334: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1335: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1336: hr_utility.raise_error;
1337:
1338: END get_xfr_elements;
1339:
1340:
1593: BEGIN
1594: lv_procedure_name := '.get_current_elements';
1595:
1596: ln_step := 1;
1597: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1598: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1599: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1600: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1601: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1594: lv_procedure_name := '.get_current_elements';
1595:
1596: ln_step := 1;
1597: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1598: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1599: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1600: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1601: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1602: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1595:
1596: ln_step := 1;
1597: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1598: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1599: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1600: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1601: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1602: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1603: hr_utility.trace('p_curr_pymt_action_id '
1596: ln_step := 1;
1597: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1598: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1599: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1600: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1601: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1602: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1603: hr_utility.trace('p_curr_pymt_action_id '
1604: ||to_char(p_curr_pymt_action_id ));
1597: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1598: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1599: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1600: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1601: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1602: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1603: hr_utility.trace('p_curr_pymt_action_id '
1604: ||to_char(p_curr_pymt_action_id ));
1605: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1598: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1599: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1600: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1601: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1602: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1603: hr_utility.trace('p_curr_pymt_action_id '
1604: ||to_char(p_curr_pymt_action_id ));
1605: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1606: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1599: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1600: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1601: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1602: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1603: hr_utility.trace('p_curr_pymt_action_id '
1604: ||to_char(p_curr_pymt_action_id ));
1605: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1606: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1607: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1601: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1602: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1603: hr_utility.trace('p_curr_pymt_action_id '
1604: ||to_char(p_curr_pymt_action_id ));
1605: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1606: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1607: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1608:
1609: lv_run_bal_status := NULL;
1602: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1603: hr_utility.trace('p_curr_pymt_action_id '
1604: ||to_char(p_curr_pymt_action_id ));
1605: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1606: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1607: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1608:
1609: lv_run_bal_status := NULL;
1610:
1603: hr_utility.trace('p_curr_pymt_action_id '
1604: ||to_char(p_curr_pymt_action_id ));
1605: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1606: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1607: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1608:
1609: lv_run_bal_status := NULL;
1610:
1611: ln_step := 6;
1698: ln_hours_balance_id,
1699: ln_days_balance_id;
1700:
1701: IF c_cur_sp_action_elements_RR%NOTFOUND THEN
1702: hr_utility.set_location(gv_package || lv_procedure_name, 25);
1703: EXIT;
1704: END IF;
1705:
1706: ELSE
1712: ln_hours_balance_id,
1713: ln_days_balance_id;
1714:
1715: IF c_cur_sp_action_elements%NOTFOUND THEN
1716: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1717: EXIT;
1718: END IF;
1719:
1720: END IF;
1729: ln_hours_balance_id,
1730: ln_days_balance_id;
1731:
1732: IF c_cur_action_elements_RR%NOTFOUND THEN
1733: hr_utility.set_location(gv_package || lv_procedure_name, 33);
1734: EXIT;
1735: END IF;
1736:
1737: ELSE
1743: ln_hours_balance_id,
1744: ln_days_balance_id;
1745:
1746: IF c_cur_action_elements%NOTFOUND THEN
1747: hr_utility.set_location(gv_package || lv_procedure_name, 36);
1748: EXIT;
1749: END IF;
1750:
1751: END IF;
1751: END IF;
1752:
1753: END IF;
1754:
1755: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1756: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
1757:
1758: ln_step := 15;
1759: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
1752:
1753: END IF;
1754:
1755: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1756: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
1757:
1758: ln_step := 15;
1759: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
1760: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
1763: := lv_reporting_name;
1764: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
1765: := ln_hours_balance_id;
1766:
1767: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1768: ln_step := 20;
1769:
1770: populate_elements(p_xfr_action_id => p_xfr_action_id
1771: ,p_pymt_assignment_action_id => p_curr_pymt_action_id
1795: ELSE
1796: CLOSE c_cur_action_elements;
1797: END IF;
1798: END IF;
1799: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1800: ln_step := 25;
1801:
1802: EXCEPTION
1803: WHEN OTHERS THEN
1803: WHEN OTHERS THEN
1804: lv_error_message := 'Error at step ' || ln_step ||
1805: ' IN ' || gv_package || lv_procedure_name;
1806:
1807: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1808:
1809: lv_error_message :=
1810: pay_emp_action_arch.set_error_message(lv_error_message);
1811:
1808:
1809: lv_error_message :=
1810: pay_emp_action_arch.set_error_message(lv_error_message);
1811:
1812: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1813: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1814: hr_utility.raise_error;
1815:
1816: END get_current_elements;
1809: lv_error_message :=
1810: pay_emp_action_arch.set_error_message(lv_error_message);
1811:
1812: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1813: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1814: hr_utility.raise_error;
1815:
1816: END get_current_elements;
1817:
1810: pay_emp_action_arch.set_error_message(lv_error_message);
1811:
1812: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1813: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1814: hr_utility.raise_error;
1815:
1816: END get_current_elements;
1817:
1818:
1955: lv_run_bal_status := NULL;
1956: lv_element_archived := 'N';
1957: lv_procedure_name := '.first_time_process';
1958:
1959: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1960: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
1961: hr_utility.trace('p_assignment_id '|| p_assignment_id);
1962: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
1963: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1956: lv_element_archived := 'N';
1957: lv_procedure_name := '.first_time_process';
1958:
1959: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1960: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
1961: hr_utility.trace('p_assignment_id '|| p_assignment_id);
1962: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
1963: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1964: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1957: lv_procedure_name := '.first_time_process';
1958:
1959: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1960: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
1961: hr_utility.trace('p_assignment_id '|| p_assignment_id);
1962: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
1963: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1964: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1965: hr_utility.trace('p_legislation_code ' || p_legislation_code);
1958:
1959: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1960: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
1961: hr_utility.trace('p_assignment_id '|| p_assignment_id);
1962: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
1963: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1964: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1965: hr_utility.trace('p_legislation_code ' || p_legislation_code);
1966: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1959: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1960: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
1961: hr_utility.trace('p_assignment_id '|| p_assignment_id);
1962: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
1963: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1964: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1965: hr_utility.trace('p_legislation_code ' || p_legislation_code);
1966: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1967: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
1960: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
1961: hr_utility.trace('p_assignment_id '|| p_assignment_id);
1962: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
1963: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1964: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1965: hr_utility.trace('p_legislation_code ' || p_legislation_code);
1966: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1967: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
1968: hr_utility.trace('p_curr_pymt_action_id '
1961: hr_utility.trace('p_assignment_id '|| p_assignment_id);
1962: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
1963: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1964: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1965: hr_utility.trace('p_legislation_code ' || p_legislation_code);
1966: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1967: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
1968: hr_utility.trace('p_curr_pymt_action_id '
1969: ||to_char(p_curr_pymt_action_id ));
1962: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
1963: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1964: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1965: hr_utility.trace('p_legislation_code ' || p_legislation_code);
1966: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1967: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
1968: hr_utility.trace('p_curr_pymt_action_id '
1969: ||to_char(p_curr_pymt_action_id ));
1970:
1963: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1964: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1965: hr_utility.trace('p_legislation_code ' || p_legislation_code);
1966: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1967: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
1968: hr_utility.trace('p_curr_pymt_action_id '
1969: ||to_char(p_curr_pymt_action_id ));
1970:
1971: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1964: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1965: hr_utility.trace('p_legislation_code ' || p_legislation_code);
1966: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1967: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
1968: hr_utility.trace('p_curr_pymt_action_id '
1969: ||to_char(p_curr_pymt_action_id ));
1970:
1971: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1972: get_current_elements(p_xfr_action_id => p_xfr_action_id
1967: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
1968: hr_utility.trace('p_curr_pymt_action_id '
1969: ||to_char(p_curr_pymt_action_id ));
1970:
1971: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1972: get_current_elements(p_xfr_action_id => p_xfr_action_id
1973: ,p_curr_pymt_action_id => p_curr_pymt_action_id
1974: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
1975: ,p_assignment_id => p_assignment_id
1977: ,p_sepchk_flag => p_sepchk_flag
1978: ,p_pymt_balcall_aaid => p_pymt_balcall_aaid
1979: ,p_ytd_balcall_aaid => p_ytd_balcall_aaid
1980: ,p_legislation_code => p_legislation_code);
1981: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1982:
1983: -- Populating the PL/SQL table run_bal_stat_tab with the validity status
1984: -- of various attributes. If already populated, we use that to check the
1985: -- validity
2045: ln_hours_balance_id,
2046: ln_days_balance_id;
2047:
2048: IF c_prev_ytd_action_elem_rbr%NOTFOUND THEN
2049: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2050: EXIT;
2051: END IF;
2052: ELSE
2053: FETCH c_prev_ytd_action_elements INTO
2058: ln_hours_balance_id,
2059: ln_days_balance_id;
2060:
2061: IF c_prev_ytd_action_elements%NOTFOUND THEN
2062: hr_utility.set_location(gv_package || lv_procedure_name, 45);
2063: EXIT;
2064: END IF;
2065: END IF;
2066:
2063: EXIT;
2064: END IF;
2065: END IF;
2066:
2067: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2068: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
2069: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2070: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
2071:
2064: END IF;
2065: END IF;
2066:
2067: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2068: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
2069: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2070: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
2071:
2072: IF lv_attribute_name IN ('Deductions',
2065: END IF;
2066:
2067: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2068: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
2069: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2070: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
2071:
2072: IF lv_attribute_name IN ('Deductions',
2073: 'Employee Taxes',
2066:
2067: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2068: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
2069: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2070: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
2071:
2072: IF lv_attribute_name IN ('Deductions',
2073: 'Employee Taxes',
2074: 'Tax Calculation Details') THEN
2091: = ln_primary_balance_id AND
2092: NVL(pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code,
2093: -999) = NVL(lv_jurisdiction_code, -999) THEN
2094:
2095: hr_utility.set_location(gv_package || lv_procedure_name, 65);
2096: lv_element_archived := 'Y';
2097: EXIT;
2098: END IF;
2099: END LOOP;
2099: END LOOP;
2100:
2101: IF lv_element_archived = 'N' THEN
2102: ln_step := 20;
2103: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2104: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2105: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2106: := lv_reporting_name;
2107: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2114: /*****************************************************************
2115: ** The Payment Assignemnt Action is not passed to this procedure
2116: ** as we do not want to call the Payment Balance.
2117: *****************************************************************/
2118: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2119:
2120: ln_step := 25;
2121: populate_elements(p_xfr_action_id => p_xfr_action_id
2122: ,p_pymt_assignment_action_id => p_curr_pymt_action_id
2147: ELSE
2148: CLOSE c_prev_ytd_action_elements;
2149: END IF;
2150:
2151: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2152:
2153:
2154: ln_step := 30;
2155: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
2155: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
2156: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..
2157: pay_ac_action_arch.lrr_act_tab.last LOOP
2158:
2159: hr_utility.trace('after populate_elements ftp' ||
2160: ' action_context_id IS ' ||
2161: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
2162: hr_utility.trace('action_info_category ' ||
2163: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
2158:
2159: hr_utility.trace('after populate_elements ftp' ||
2160: ' action_context_id IS ' ||
2161: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
2162: hr_utility.trace('action_info_category ' ||
2163: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
2164: hr_utility.trace('act_info1 IS ' ||
2165: pay_ac_action_arch.lrr_act_tab(i).act_info1);
2166: hr_utility.trace('act_info10 ' ||
2160: ' action_context_id IS ' ||
2161: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
2162: hr_utility.trace('action_info_category ' ||
2163: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
2164: hr_utility.trace('act_info1 IS ' ||
2165: pay_ac_action_arch.lrr_act_tab(i).act_info1);
2166: hr_utility.trace('act_info10 ' ||
2167: pay_ac_action_arch.lrr_act_tab(i).act_info10);
2168: hr_utility.trace('act_info3 ' ||
2162: hr_utility.trace('action_info_category ' ||
2163: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
2164: hr_utility.trace('act_info1 IS ' ||
2165: pay_ac_action_arch.lrr_act_tab(i).act_info1);
2166: hr_utility.trace('act_info10 ' ||
2167: pay_ac_action_arch.lrr_act_tab(i).act_info10);
2168: hr_utility.trace('act_info3 ' ||
2169: pay_ac_action_arch.lrr_act_tab(i).act_info3);
2170: hr_utility.trace('act_info4 ' ||
2164: hr_utility.trace('act_info1 IS ' ||
2165: pay_ac_action_arch.lrr_act_tab(i).act_info1);
2166: hr_utility.trace('act_info10 ' ||
2167: pay_ac_action_arch.lrr_act_tab(i).act_info10);
2168: hr_utility.trace('act_info3 ' ||
2169: pay_ac_action_arch.lrr_act_tab(i).act_info3);
2170: hr_utility.trace('act_info4 ' ||
2171: pay_ac_action_arch.lrr_act_tab(i).act_info4);
2172: hr_utility.trace('act_info5 ' ||
2166: hr_utility.trace('act_info10 ' ||
2167: pay_ac_action_arch.lrr_act_tab(i).act_info10);
2168: hr_utility.trace('act_info3 ' ||
2169: pay_ac_action_arch.lrr_act_tab(i).act_info3);
2170: hr_utility.trace('act_info4 ' ||
2171: pay_ac_action_arch.lrr_act_tab(i).act_info4);
2172: hr_utility.trace('act_info5 ' ||
2173: pay_ac_action_arch.lrr_act_tab(i).act_info5);
2174: hr_utility.trace('act_info6 ' ||
2168: hr_utility.trace('act_info3 ' ||
2169: pay_ac_action_arch.lrr_act_tab(i).act_info3);
2170: hr_utility.trace('act_info4 ' ||
2171: pay_ac_action_arch.lrr_act_tab(i).act_info4);
2172: hr_utility.trace('act_info5 ' ||
2173: pay_ac_action_arch.lrr_act_tab(i).act_info5);
2174: hr_utility.trace('act_info6 ' ||
2175: pay_ac_action_arch.lrr_act_tab(i).act_info6);
2176: hr_utility.trace('act_info7 ' ||
2170: hr_utility.trace('act_info4 ' ||
2171: pay_ac_action_arch.lrr_act_tab(i).act_info4);
2172: hr_utility.trace('act_info5 ' ||
2173: pay_ac_action_arch.lrr_act_tab(i).act_info5);
2174: hr_utility.trace('act_info6 ' ||
2175: pay_ac_action_arch.lrr_act_tab(i).act_info6);
2176: hr_utility.trace('act_info7 ' ||
2177: pay_ac_action_arch.lrr_act_tab(i).act_info7);
2178: hr_utility.trace('act_info8 ' ||
2172: hr_utility.trace('act_info5 ' ||
2173: pay_ac_action_arch.lrr_act_tab(i).act_info5);
2174: hr_utility.trace('act_info6 ' ||
2175: pay_ac_action_arch.lrr_act_tab(i).act_info6);
2176: hr_utility.trace('act_info7 ' ||
2177: pay_ac_action_arch.lrr_act_tab(i).act_info7);
2178: hr_utility.trace('act_info8 ' ||
2179: pay_ac_action_arch.lrr_act_tab(i).act_info8);
2180:
2174: hr_utility.trace('act_info6 ' ||
2175: pay_ac_action_arch.lrr_act_tab(i).act_info6);
2176: hr_utility.trace('act_info7 ' ||
2177: pay_ac_action_arch.lrr_act_tab(i).act_info7);
2178: hr_utility.trace('act_info8 ' ||
2179: pay_ac_action_arch.lrr_act_tab(i).act_info8);
2180:
2181: END LOOP;
2182: END IF;
2180:
2181: END LOOP;
2182: END IF;
2183:
2184: hr_utility.set_location(gv_package || lv_procedure_name, 110);
2185:
2186:
2187: EXCEPTION
2188: WHEN OTHERS THEN
2189:
2190: lv_error_message := 'Error at step ' || ln_step ||
2191: ' IN ' || gv_package || lv_procedure_name;
2192:
2193: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2194:
2195: lv_error_message :=
2196: pay_emp_action_arch.set_error_message(lv_error_message);
2197:
2194:
2195: lv_error_message :=
2196: pay_emp_action_arch.set_error_message(lv_error_message);
2197:
2198: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2199: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2200: hr_utility.raise_error;
2201:
2202: END first_time_process;
2195: lv_error_message :=
2196: pay_emp_action_arch.set_error_message(lv_error_message);
2197:
2198: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2199: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2200: hr_utility.raise_error;
2201:
2202: END first_time_process;
2203:
2196: pay_emp_action_arch.set_error_message(lv_error_message);
2197:
2198: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2199: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2200: hr_utility.raise_error;
2201:
2202: END first_time_process;
2203:
2204:
2226:
2227: BEGIN
2228: lv_procedure_name := '.range_code';
2229:
2230: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2231: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
2232: ,p_start_date => ld_start_date
2233: ,p_end_date => ld_end_date
2234: ,p_business_group_id => ln_business_group_id
2233: ,p_end_date => ld_end_date
2234: ,p_business_group_id => ln_business_group_id
2235: ,p_cons_set_id => ln_cons_set_id
2236: ,p_payroll_id => ln_payroll_id);
2237: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2238:
2239: lv_sql_string :=
2240: 'SELECT DISTINCT paf.person_id
2241: FROM pay_assignment_actions paa,
2270: AND ppa1.report_type = ''MX_PAYSLIP_ARCHIVE'')
2271: AND :payroll_action_id > 0 -- Bug 4202702
2272: ORDER BY paf.person_id';
2273:
2274: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2275: p_sqlstr := lv_sql_string;
2276: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2277:
2278: END range_code;
2272: ORDER BY paf.person_id';
2273:
2274: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2275: p_sqlstr := lv_sql_string;
2276: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2277:
2278: END range_code;
2279:
2280:
2438: lv_procedure_name := '.assignment_action_code';
2439:
2440: ln_step := 1;
2441: pay_emp_action_arch.gv_error_message := NULL;
2442: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2443:
2444: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
2445: ,p_start_date => ld_start_date
2446: ,p_end_date => ld_end_date
2446: ,p_end_date => ld_end_date
2447: ,p_business_group_id => ln_business_group_id
2448: ,p_cons_set_id => ln_cons_set_id
2449: ,p_payroll_id => ln_payroll_id);
2450: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2451:
2452: lb_range_person := pay_ac_utility.range_person_on(
2453: p_report_type => 'MX_PAYSLIP_ARCHIVE'
2454: ,p_report_format => 'MX_PAYSLIP_ARCHIVE'
2474: ,ld_end_date);
2475: END IF;
2476:
2477: -- Loop for all rows returned for SQL statement.
2478: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2479: LOOP
2480: IF lb_range_person THEN
2481: FETCH c_get_arch_range_emp INTO ln_assignment_id,
2482: ln_tax_unit_id,
2498:
2499: EXIT WHEN c_get_arch_emp%NOTFOUND;
2500: END IF;
2501:
2502: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2503: hr_utility.trace('ln_assignment_id = ' ||
2504: TO_CHAR(ln_assignment_id));
2505:
2506: /********************************************************
2499: EXIT WHEN c_get_arch_emp%NOTFOUND;
2500: END IF;
2501:
2502: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2503: hr_utility.trace('ln_assignment_id = ' ||
2504: TO_CHAR(ln_assignment_id));
2505:
2506: /********************************************************
2507: ** If Balance Adjustment, only create one assignment
2518: ld_effective_date = ld_prev_effective_date AND
2519: lv_action_type = 'B' AND
2520: ln_asg_action_id <> ln_prev_asg_action_id THEN
2521:
2522: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2523: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2524: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2525: hr_nonrun_asact.insint(ln_xfr_action_id
2526: ,ln_asg_action_id);
2519: lv_action_type = 'B' AND
2520: ln_asg_action_id <> ln_prev_asg_action_id THEN
2521:
2522: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2523: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2524: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2525: hr_nonrun_asact.insint(ln_xfr_action_id
2526: ,ln_asg_action_id);
2527: ELSE
2520: ln_asg_action_id <> ln_prev_asg_action_id THEN
2521:
2522: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2523: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2524: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2525: hr_nonrun_asact.insint(ln_xfr_action_id
2526: ,ln_asg_action_id);
2527: ELSE
2528: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2524: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2525: hr_nonrun_asact.insint(ln_xfr_action_id
2526: ,ln_asg_action_id);
2527: ELSE
2528: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2529: hr_utility.trace('Action_type = '||lv_action_type );
2530:
2531: SELECT pay_assignment_actions_s.NEXTVAL
2532: INTO ln_xfr_action_id
2525: hr_nonrun_asact.insint(ln_xfr_action_id
2526: ,ln_asg_action_id);
2527: ELSE
2528: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2529: hr_utility.trace('Action_type = '||lv_action_type );
2530:
2531: SELECT pay_assignment_actions_s.NEXTVAL
2532: INTO ln_xfr_action_id
2533: FROM dual;
2540: ln_tax_unit_id,
2541: NULL,
2542: 'U',
2543: NULL);
2544: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2545: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2546: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2547: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2548: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2541: NULL,
2542: 'U',
2543: NULL);
2544: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2545: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2546: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2547: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2548: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2549: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2542: 'U',
2543: NULL);
2544: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2545: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2546: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2547: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2548: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2549: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2550:
2543: NULL);
2544: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2545: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2546: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2547: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2548: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2549: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2550:
2551: -- insert an interlock to this action
2544: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2545: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2546: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2547: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2548: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2549: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2550:
2551: -- insert an interlock to this action
2552: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2545: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2546: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2547: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2548: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2549: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2550:
2551: -- insert an interlock to this action
2552: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2553: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2548: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2549: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2550:
2551: -- insert an interlock to this action
2552: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2553: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2554: hr_nonrun_asact.insint(ln_xfr_action_id,
2555: ln_asg_action_id);
2556:
2549: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2550:
2551: -- insert an interlock to this action
2552: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2553: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2554: hr_nonrun_asact.insint(ln_xfr_action_id,
2555: ln_asg_action_id);
2556:
2557: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2553: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2554: hr_nonrun_asact.insint(ln_xfr_action_id,
2555: ln_asg_action_id);
2556:
2557: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2558:
2559: /********************************************************
2560: ** For Balance Adj we put only the first assignment action
2561: ********************************************************/
2565: UPdate pay_assignment_actions
2566: SET serial_number = lv_serial_number
2567: WHERE assignment_action_id = ln_xfr_action_id;
2568:
2569: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2570:
2571: END IF ; --ln_assignment_id ...
2572:
2573: ln_prev_tax_unit_id := ln_tax_unit_id;
2588: WHEN OTHERS THEN
2589: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||
2590: gv_package || lv_procedure_name;
2591:
2592: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2593:
2594: lv_error_message :=
2595: pay_emp_action_arch.set_error_message(lv_error_message);
2596:
2593:
2594: lv_error_message :=
2595: pay_emp_action_arch.set_error_message(lv_error_message);
2596:
2597: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2598: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2599: hr_utility.raise_error;
2600:
2601: END assignment_action_code;
2594: lv_error_message :=
2595: pay_emp_action_arch.set_error_message(lv_error_message);
2596:
2597: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2598: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2599: hr_utility.raise_error;
2600:
2601: END assignment_action_code;
2602:
2595: pay_emp_action_arch.set_error_message(lv_error_message);
2596:
2597: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2598: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2599: hr_utility.raise_error;
2600:
2601: END assignment_action_code;
2602:
2603:
2674: j NUMBER;
2675:
2676: BEGIN
2677: lv_procedure_name := '.initialization_code';
2678: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2679: pay_emp_action_arch.gv_error_message := NULL;
2680: lv_reporting_level := Null;
2681: i := 0;
2682: j := 0;
2722: pay_emp_action_arch.gv_multi_leg_rule
2723: := pay_emp_action_arch.get_multi_legislative_rule('MX');
2724: END IF;
2725:
2726: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
2727: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
2728: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2729:
2730: ln_step := 30;
2723: := pay_emp_action_arch.get_multi_legislative_rule('MX');
2724: END IF;
2725:
2726: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
2727: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
2728: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2729:
2730: ln_step := 30;
2731: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN
2724: END IF;
2725:
2726: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
2727: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
2728: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2729:
2730: ln_step := 30;
2731: IF pay_emp_action_arch.gv_multi_leg_rule = 'Y' THEN
2732: lv_pymt_dimension := '_ASG_PAYMENTS';
2795: i := i + 1;
2796:
2797: END LOOP;
2798:
2799: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2800: i := 0;
2801:
2802: ln_step := 160;
2803: FOR i IN dbt.first..dbt.last LOOP
2800: i := 0;
2801:
2802: ln_step := 160;
2803: FOR i IN dbt.first..dbt.last LOOP
2804: hr_utility.trace(dbt(i).act_info_category);
2805: hr_utility.trace(dbt(i).bal_name);
2806: hr_utility.trace(dbt(i).bal_type_id);
2807: hr_utility.trace(dbt(i).pymt_def_bal_id);
2808: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
2801:
2802: ln_step := 160;
2803: FOR i IN dbt.first..dbt.last LOOP
2804: hr_utility.trace(dbt(i).act_info_category);
2805: hr_utility.trace(dbt(i).bal_name);
2806: hr_utility.trace(dbt(i).bal_type_id);
2807: hr_utility.trace(dbt(i).pymt_def_bal_id);
2808: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
2809: hr_utility.trace(dbt(i).run_def_bal_id);
2802: ln_step := 160;
2803: FOR i IN dbt.first..dbt.last LOOP
2804: hr_utility.trace(dbt(i).act_info_category);
2805: hr_utility.trace(dbt(i).bal_name);
2806: hr_utility.trace(dbt(i).bal_type_id);
2807: hr_utility.trace(dbt(i).pymt_def_bal_id);
2808: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
2809: hr_utility.trace(dbt(i).run_def_bal_id);
2810: hr_utility.trace(dbt(i).jurisdiction_cd);
2803: FOR i IN dbt.first..dbt.last LOOP
2804: hr_utility.trace(dbt(i).act_info_category);
2805: hr_utility.trace(dbt(i).bal_name);
2806: hr_utility.trace(dbt(i).bal_type_id);
2807: hr_utility.trace(dbt(i).pymt_def_bal_id);
2808: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
2809: hr_utility.trace(dbt(i).run_def_bal_id);
2810: hr_utility.trace(dbt(i).jurisdiction_cd);
2811: END LOOP;
2804: hr_utility.trace(dbt(i).act_info_category);
2805: hr_utility.trace(dbt(i).bal_name);
2806: hr_utility.trace(dbt(i).bal_type_id);
2807: hr_utility.trace(dbt(i).pymt_def_bal_id);
2808: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
2809: hr_utility.trace(dbt(i).run_def_bal_id);
2810: hr_utility.trace(dbt(i).jurisdiction_cd);
2811: END LOOP;
2812:
2805: hr_utility.trace(dbt(i).bal_name);
2806: hr_utility.trace(dbt(i).bal_type_id);
2807: hr_utility.trace(dbt(i).pymt_def_bal_id);
2808: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
2809: hr_utility.trace(dbt(i).run_def_bal_id);
2810: hr_utility.trace(dbt(i).jurisdiction_cd);
2811: END LOOP;
2812:
2813: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2806: hr_utility.trace(dbt(i).bal_type_id);
2807: hr_utility.trace(dbt(i).pymt_def_bal_id);
2808: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
2809: hr_utility.trace(dbt(i).run_def_bal_id);
2810: hr_utility.trace(dbt(i).jurisdiction_cd);
2811: END LOOP;
2812:
2813: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2814:
2809: hr_utility.trace(dbt(i).run_def_bal_id);
2810: hr_utility.trace(dbt(i).jurisdiction_cd);
2811: END LOOP;
2812:
2813: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2814:
2815: EXCEPTION
2816: WHEN OTHERS THEN
2817: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2813: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2814:
2815: EXCEPTION
2816: WHEN OTHERS THEN
2817: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2818: lv_error_message := 'Error at step ' || ln_step ||
2819: ' IN ' || gv_package || lv_procedure_name;
2820: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2821:
2816: WHEN OTHERS THEN
2817: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2818: lv_error_message := 'Error at step ' || ln_step ||
2819: ' IN ' || gv_package || lv_procedure_name;
2820: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2821:
2822: lv_error_message :=
2823: pay_emp_action_arch.set_error_message(lv_error_message);
2824:
2821:
2822: lv_error_message :=
2823: pay_emp_action_arch.set_error_message(lv_error_message);
2824:
2825: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2826: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2827: hr_utility.raise_error;
2828:
2829: END initialization_code;
2822: lv_error_message :=
2823: pay_emp_action_arch.set_error_message(lv_error_message);
2824:
2825: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2826: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2827: hr_utility.raise_error;
2828:
2829: END initialization_code;
2830:
2823: pay_emp_action_arch.set_error_message(lv_error_message);
2824:
2825: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2826: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2827: hr_utility.raise_error;
2828:
2829: END initialization_code;
2830:
2831:
2869:
2870: BEGIN
2871: ln_step := 1;
2872: lv_procedure_name := '.populate_tax_and_summary';
2873: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2874: i := 0;
2875: j := 0;
2876:
2877: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
2875: j := 0;
2876:
2877: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
2878:
2879: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2880: ln_step := 2;
2881: FOR i IN dbt.first..dbt.last LOOP
2882:
2883: ln_pymt_amount := 0;
2911: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
2912: dbt(i).gre_ytd_def_bal_id,
2913: p_ytd_balcall_aaid),0);
2914:
2915: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2916: ln_step := 8;
2917:
2918: IF dbt(i).act_info_category = 'MX SUMMARY' THEN
2919:
2940: END IF;
2941:
2942: ELSIF ( ln_pymt_amount + ln_ytd_amount <> 0 ) THEN
2943:
2944: hr_utility.trace('lv_lookup_code : '||lv_lookup_code);
2945: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2946:
2947:
2948: lv_reporting_name := dbt(i).bal_name; -- MX specific
2941:
2942: ELSIF ( ln_pymt_amount + ln_ytd_amount <> 0 ) THEN
2943:
2944: hr_utility.trace('lv_lookup_code : '||lv_lookup_code);
2945: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2946:
2947:
2948: lv_reporting_name := dbt(i).bal_name; -- MX specific
2949:
2947:
2948: lv_reporting_name := dbt(i).bal_name; -- MX specific
2949:
2950: /*Insert this into the plsql table */
2951: -- hr_utility.trace('Tax Balance Name : '|| dbt(i).bal_name );
2952: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
2953: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2954:
2955: ln_step := 10;
2948: lv_reporting_name := dbt(i).bal_name; -- MX specific
2949:
2950: /*Insert this into the plsql table */
2951: -- hr_utility.trace('Tax Balance Name : '|| dbt(i).bal_name );
2952: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
2953: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2954:
2955: ln_step := 10;
2956: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2949:
2950: /*Insert this into the plsql table */
2951: -- hr_utility.trace('Tax Balance Name : '|| dbt(i).bal_name );
2952: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
2953: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2954:
2955: ln_step := 10;
2956: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2957:
2954:
2955: ln_step := 10;
2956: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2957:
2958: hr_utility.trace('ln_index IS '
2959: || pay_ac_action_arch.lrr_act_tab.count);
2960:
2961: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2962: := dbt(i).act_info_category;
2979:
2980: END IF;
2981:
2982:
2983: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2984:
2985: ln_step := 11;
2986: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2987: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2990: := dbt(i).bal_name;
2991: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2992: := dbt(i).bal_type_id;
2993:
2994: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2995:
2996:
2997: END IF;
2998:
3014: := fnd_number.number_to_canonical(ln_net_pay);
3015:
3016: END IF;
3017:
3018: hr_utility.set_location(gv_package || lv_procedure_name, 75);
3019:
3020: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3021:
3022: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3030: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3031: := fnd_number.number_to_canonical(ln_ytd_net_pay);
3032:
3033:
3034: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3035:
3036: EXCEPTION
3037: WHEN OTHERS THEN
3038: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3034: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3035:
3036: EXCEPTION
3037: WHEN OTHERS THEN
3038: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3039: lv_error_message := 'Error at step ' || ln_step ||
3040: ' IN ' || gv_package || lv_procedure_name;
3041: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3042:
3037: WHEN OTHERS THEN
3038: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3039: lv_error_message := 'Error at step ' || ln_step ||
3040: ' IN ' || gv_package || lv_procedure_name;
3041: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3042:
3043: lv_error_message :=
3044: pay_emp_action_arch.set_error_message(lv_error_message);
3045:
3042:
3043: lv_error_message :=
3044: pay_emp_action_arch.set_error_message(lv_error_message);
3045:
3046: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3047: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3048: hr_utility.raise_error;
3049:
3050: END populate_tax_and_summary;
3043: lv_error_message :=
3044: pay_emp_action_arch.set_error_message(lv_error_message);
3045:
3046: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3047: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3048: hr_utility.raise_error;
3049:
3050: END populate_tax_and_summary;
3051:
3044: pay_emp_action_arch.set_error_message(lv_error_message);
3045:
3046: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3047: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3048: hr_utility.raise_error;
3049:
3050: END populate_tax_and_summary;
3051:
3052:
3116:
3117: BEGIN
3118: lv_procedure_name := '.update_employee_information';
3119:
3120: hr_utility.trace('Action_Context_ID = ' || p_action_context_id);
3121: hr_utility.trace('Asg ID = ' || p_assignment_id);
3122: OPEN c_get_archive_info(p_action_context_id, p_assignment_id);
3123: LOOP
3124: FETCH c_get_archive_info INTO ln_action_information_id,
3117: BEGIN
3118: lv_procedure_name := '.update_employee_information';
3119:
3120: hr_utility.trace('Action_Context_ID = ' || p_action_context_id);
3121: hr_utility.trace('Asg ID = ' || p_assignment_id);
3122: OPEN c_get_archive_info(p_action_context_id, p_assignment_id);
3123: LOOP
3124: FETCH c_get_archive_info INTO ln_action_information_id,
3125: ld_effective_date,
3134:
3135: ln_legal_employer_id :=
3136: hr_mx_utility.get_legal_employer(ln_business_group_id,
3137: ln_tax_unit_id);
3138: hr_utility.trace('ln_legal_employer_id = ' || ln_legal_employer_id);
3139:
3140:
3141: hr_utility.trace('Action_info_id = ' || ln_action_information_id);
3142: hr_utility.trace('ld_eff_date = ' ||
3137: ln_tax_unit_id);
3138: hr_utility.trace('ln_legal_employer_id = ' || ln_legal_employer_id);
3139:
3140:
3141: hr_utility.trace('Action_info_id = ' || ln_action_information_id);
3142: hr_utility.trace('ld_eff_date = ' ||
3143: fnd_date.date_to_canonical(ld_effective_date));
3144:
3145: OPEN c_get_employee_info(p_assignment_id, ld_effective_date);
3138: hr_utility.trace('ln_legal_employer_id = ' || ln_legal_employer_id);
3139:
3140:
3141: hr_utility.trace('Action_info_id = ' || ln_action_information_id);
3142: hr_utility.trace('ld_eff_date = ' ||
3143: fnd_date.date_to_canonical(ld_effective_date));
3144:
3145: OPEN c_get_employee_info(p_assignment_id, ld_effective_date);
3146: FETCH c_get_employee_info INTO lv_employee_name;
3145: OPEN c_get_employee_info(p_assignment_id, ld_effective_date);
3146: FETCH c_get_employee_info INTO lv_employee_name;
3147: CLOSE c_get_employee_info;
3148:
3149: hr_utility.trace('lv_employee_name = *' || lv_employee_name ||'*');
3150:
3151: pay_action_information_api.update_action_information
3152: (p_action_information_id => ln_action_information_id
3153: ,p_object_version_number => ln_ovn
3162: WHEN OTHERS THEN
3163: lv_error_message := 'Error IN ' ||
3164: gv_package || lv_procedure_name;
3165:
3166: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3167:
3168: lv_error_message :=
3169: pay_emp_action_arch.set_error_message(lv_error_message);
3170:
3167:
3168: lv_error_message :=
3169: pay_emp_action_arch.set_error_message(lv_error_message);
3170:
3171: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3172: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3173: hr_utility.raise_error;
3174:
3175: END update_employee_information;
3168: lv_error_message :=
3169: pay_emp_action_arch.set_error_message(lv_error_message);
3170:
3171: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3172: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3173: hr_utility.raise_error;
3174:
3175: END update_employee_information;
3176:
3169: pay_emp_action_arch.set_error_message(lv_error_message);
3170:
3171: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3172: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3173: hr_utility.raise_error;
3174:
3175: END update_employee_information;
3176:
3177: /**********************************************************************
3270: BEGIN
3271: lv_procedure_name := 'get_mx_personal_information';
3272: lv_exists := 'N';
3273:
3274: hr_utility.trace('Entered get_mx_personal_information');
3275: ln_step := 1;
3276: pay_emp_action_arch.initialization_process;
3277:
3278: hr_utility.trace('p_assactid = ' || p_assactid);--
3274: hr_utility.trace('Entered get_mx_personal_information');
3275: ln_step := 1;
3276: pay_emp_action_arch.initialization_process;
3277:
3278: hr_utility.trace('p_assactid = ' || p_assactid);--
3279: hr_utility.trace('p_assignment_id = ' || p_assignment_id);--
3280: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
3281: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);--
3282: hr_utility.trace('p_date_earned = ' || p_date_earned);
3275: ln_step := 1;
3276: pay_emp_action_arch.initialization_process;
3277:
3278: hr_utility.trace('p_assactid = ' || p_assactid);--
3279: hr_utility.trace('p_assignment_id = ' || p_assignment_id);--
3280: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
3281: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);--
3282: hr_utility.trace('p_date_earned = ' || p_date_earned);
3283: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);--
3276: pay_emp_action_arch.initialization_process;
3277:
3278: hr_utility.trace('p_assactid = ' || p_assactid);--
3279: hr_utility.trace('p_assignment_id = ' || p_assignment_id);--
3280: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
3281: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);--
3282: hr_utility.trace('p_date_earned = ' || p_date_earned);
3283: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);--
3284: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);--
3277:
3278: hr_utility.trace('p_assactid = ' || p_assactid);--
3279: hr_utility.trace('p_assignment_id = ' || p_assignment_id);--
3280: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
3281: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);--
3282: hr_utility.trace('p_date_earned = ' || p_date_earned);
3283: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);--
3284: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);--
3285: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
3278: hr_utility.trace('p_assactid = ' || p_assactid);--
3279: hr_utility.trace('p_assignment_id = ' || p_assignment_id);--
3280: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
3281: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);--
3282: hr_utility.trace('p_date_earned = ' || p_date_earned);
3283: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);--
3284: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);--
3285: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
3286: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
3279: hr_utility.trace('p_assignment_id = ' || p_assignment_id);--
3280: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
3281: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);--
3282: hr_utility.trace('p_date_earned = ' || p_date_earned);
3283: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);--
3284: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);--
3285: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
3286: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
3287:
3280: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
3281: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);--
3282: hr_utility.trace('p_date_earned = ' || p_date_earned);
3283: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);--
3284: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);--
3285: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
3286: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
3287:
3288: OPEN c_employee_details(p_assignment_id,p_curr_eff_date);
3281: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);--
3282: hr_utility.trace('p_date_earned = ' || p_date_earned);
3283: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);--
3284: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);--
3285: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
3286: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
3287:
3288: OPEN c_employee_details(p_assignment_id,p_curr_eff_date);
3289: ln_step := 2;
3282: hr_utility.trace('p_date_earned = ' || p_date_earned);
3283: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);--
3284: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);--
3285: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
3286: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
3287:
3288: OPEN c_employee_details(p_assignment_id,p_curr_eff_date);
3289: ln_step := 2;
3290: FETCH c_employee_details INTO lv_ee_rfc_id,
3290: FETCH c_employee_details INTO lv_ee_rfc_id,
3291: lv_ee_ss_id;
3292:
3293: IF c_employee_details%NOTFOUND THEN
3294: hr_utility.raise_error;
3295: END IF;
3296:
3297: hr_utility.trace('lv_ee_rfc_id = ' || lv_ee_rfc_id);
3298: hr_utility.trace('lv_ee_ss_id = ' || lv_ee_ss_id);
3293: IF c_employee_details%NOTFOUND THEN
3294: hr_utility.raise_error;
3295: END IF;
3296:
3297: hr_utility.trace('lv_ee_rfc_id = ' || lv_ee_rfc_id);
3298: hr_utility.trace('lv_ee_ss_id = ' || lv_ee_ss_id);
3299:
3300: CLOSE c_employee_details;
3301:
3294: hr_utility.raise_error;
3295: END IF;
3296:
3297: hr_utility.trace('lv_ee_rfc_id = ' || lv_ee_rfc_id);
3298: hr_utility.trace('lv_ee_ss_id = ' || lv_ee_ss_id);
3299:
3300: CLOSE c_employee_details;
3301:
3302: ln_step := 3;
3309:
3310: --
3311: ln_index := pay_emp_action_arch.lrr_act_tab.count;
3312:
3313: hr_utility.trace('ln_index IN get_mx_personal_information proc IS '
3314: || pay_emp_action_arch.lrr_act_tab.count);
3315:
3316: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
3317: := 'MX EMPLOYEE DETAILS';
3339: WHEN OTHERS THEN
3340: lv_error_message := 'Error IN step ' ||ln_step|| ' of '||
3341: gv_package || lv_procedure_name;
3342:
3343: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3344:
3345: lv_error_message :=
3346: pay_emp_action_arch.set_error_message(lv_error_message);
3347:
3344:
3345: lv_error_message :=
3346: pay_emp_action_arch.set_error_message(lv_error_message);
3347:
3348: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3349: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3350: hr_utility.raise_error;
3351:
3352: END get_mx_personal_information;
3345: lv_error_message :=
3346: pay_emp_action_arch.set_error_message(lv_error_message);
3347:
3348: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3349: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3350: hr_utility.raise_error;
3351:
3352: END get_mx_personal_information;
3353:
3346: pay_emp_action_arch.set_error_message(lv_error_message);
3347:
3348: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3349: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3350: hr_utility.raise_error;
3351:
3352: END get_mx_personal_information;
3353:
3354: /******************************************************************
3381:
3382: BEGIN
3383: lv_procedure_name := '.populate_summary';
3384: ln_step := 1;
3385: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3386: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
3387: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3388:
3389: ln_step := 2;
3383: lv_procedure_name := '.populate_summary';
3384: ln_step := 1;
3385: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3386: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
3387: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3388:
3389: ln_step := 2;
3390: FOR i IN pay_ac_action_arch.lrr_act_tab.first ..
3391: pay_ac_action_arch.lrr_act_tab.last LOOP
3405: --
3406: IF pay_ac_action_arch.lrr_act_tab(i).act_info16
3407: = 'Taxable Benefits' THEN
3408:
3409: hr_utility.set_location(gv_package || lv_procedure_name, 25);
3410: lv_imputed_earnings :=
3411: lv_imputed_earnings +
3412: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3413:
3416: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3417:
3418: END IF;
3419:
3420: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3421: ln_step := 3;
3422: lv_gross_earnings
3423: := lv_gross_earnings +
3424: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3426: := lv_ytd_gross_earnings +
3427: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3428: ELSIF pay_ac_action_arch.lrr_act_tab(i).act_info16
3429: = 'Employee Taxes' THEN
3430: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3431: ln_step := 4;
3432: lv_tax_deductions
3433: := lv_tax_deductions +
3434: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3436: := lv_ytd_tax_deductions +
3437: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info9,0);
3438: ELSIF pay_ac_action_arch.lrr_act_tab(i).act_info16
3439: = 'Deductions' THEN
3440: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3441: ln_step := 5;
3442: lv_deductions
3443: := lv_deductions +
3444: NVL(pay_ac_action_arch.lrr_act_tab(i).act_info8,0);
3451: END IF;
3452: END LOOP;
3453: END IF;
3454:
3455: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3456: -- Insert one row for CURRENT and one for YTD
3457: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
3458: ln_step := 6;
3459: -- CURRENT
3457: IF pay_ac_action_arch.lrr_act_tab.count > 0 THEN
3458: ln_step := 6;
3459: -- CURRENT
3460: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3461: hr_utility.trace('ln_index = ' || ln_index);
3462: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3463: := 'MX SUMMARY CURRENT';
3464: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3465: := fnd_number.number_to_canonical(lv_gross_earnings);
3474: lv_tax_deductions -
3475: lv_deductions);
3476:
3477:
3478: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3479: -- YTD
3480: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3481: hr_utility.trace('ln_index = ' || ln_index);
3482: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3477:
3478: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3479: -- YTD
3480: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3481: hr_utility.trace('ln_index = ' || ln_index);
3482: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3483: := 'MX SUMMARY YTD';
3484: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3485: := fnd_number.number_to_canonical(lv_ytd_gross_earnings);
3495: lv_ytd_deductions);
3496:
3497: END IF;
3498:
3499: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3500: ln_step := 10;
3501:
3502: EXCEPTION
3503: WHEN OTHERS THEN
3504:
3505: lv_error_message := 'Error at step ' || ln_step ||
3506: ' in ' || gv_package || lv_procedure_name;
3507:
3508: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3509:
3510: lv_error_message :=
3511: pay_emp_action_arch.set_error_message(lv_error_message);
3512:
3509:
3510: lv_error_message :=
3511: pay_emp_action_arch.set_error_message(lv_error_message);
3512:
3513: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3514: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3515: hr_utility.raise_error;
3516:
3517: END populate_summary;
3510: lv_error_message :=
3511: pay_emp_action_arch.set_error_message(lv_error_message);
3512:
3513: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3514: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3515: hr_utility.raise_error;
3516:
3517: END populate_summary;
3518: */
3511: pay_emp_action_arch.set_error_message(lv_error_message);
3512:
3513: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3514: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3515: hr_utility.raise_error;
3516:
3517: END populate_summary;
3518: */
3519:
3596:
3597: BEGIN
3598: lv_procedure_name := '.process_actions';
3599:
3600: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3601: ln_step := 1;
3602: /****************************************************************
3603: ** For Seperate Check we do the YTD balance calls with the Run
3604: ** Action ID. So, we do not need to get the MAX. action which IS
3609: ****************************************************************/
3610: ln_ytd_balcall_aaid := p_payment_action_id;
3611: IF p_seperate_check_flag = 'N' AND
3612: p_action_type IN ('U', 'P') THEN
3613: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3614: ln_step := 2;
3615: OPEN c_ytd_aaid(p_rqp_action_id,
3616: p_assignment_id);
3617: FETCH c_ytd_aaid INTO ln_ytd_balcall_aaid;
3615: OPEN c_ytd_aaid(p_rqp_action_id,
3616: p_assignment_id);
3617: FETCH c_ytd_aaid INTO ln_ytd_balcall_aaid;
3618: IF c_ytd_aaid%NOTFOUND THEN
3619: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3620: hr_utility.raise_error;
3621: END IF;
3622: CLOSE c_ytd_aaid;
3623: END IF;
3616: p_assignment_id);
3617: FETCH c_ytd_aaid INTO ln_ytd_balcall_aaid;
3618: IF c_ytd_aaid%NOTFOUND THEN
3619: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3620: hr_utility.raise_error;
3621: END IF;
3622: CLOSE c_ytd_aaid;
3623: END IF;
3624:
3621: END IF;
3622: CLOSE c_ytd_aaid;
3623: END IF;
3624:
3625: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3626: ln_step := 3;
3627:
3628: OPEN c_time_period(p_payment_action_id);
3629: FETCH c_time_period INTO ln_time_period_id,
3630: ld_run_date_earned,
3631: ld_run_effective_date;
3632: CLOSE c_time_period;
3633:
3634: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3635: ln_step := 4;
3636: pay_ac_action_arch.get_last_xfr_info(
3637: p_assignment_id => p_assignment_id
3638: ,p_curr_effective_date => p_xfr_end_date
3665: ld_last_xfr_eff_date := NULL;
3666: END IF;
3667: END IF;
3668:
3669: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
3670: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3671: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3672: hr_utility.trace('p_action_type = ' || p_action_type);
3673: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3666: END IF;
3667: END IF;
3668:
3669: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
3670: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3671: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3672: hr_utility.trace('p_action_type = ' || p_action_type);
3673: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3674: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3667: END IF;
3668:
3669: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
3670: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3671: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3672: hr_utility.trace('p_action_type = ' || p_action_type);
3673: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3674: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3675: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3668:
3669: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
3670: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3671: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3672: hr_utility.trace('p_action_type = ' || p_action_type);
3673: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3674: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3675: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3676: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3669: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
3670: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3671: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3672: hr_utility.trace('p_action_type = ' || p_action_type);
3673: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3674: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3675: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3676: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3677: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3670: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3671: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3672: hr_utility.trace('p_action_type = ' || p_action_type);
3673: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3674: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3675: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3676: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3677: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3678: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3671: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3672: hr_utility.trace('p_action_type = ' || p_action_type);
3673: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3674: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3675: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3676: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3677: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3678: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3679: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3672: hr_utility.trace('p_action_type = ' || p_action_type);
3673: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3674: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3675: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3676: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3677: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3678: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3679: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3680: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3673: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3674: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3675: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3676: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3677: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3678: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3679: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3680: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3681: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3674: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3675: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3676: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3677: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3678: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3679: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3680: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3681: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3682: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3675: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3676: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3677: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3678: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3679: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3680: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3681: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3682: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3683: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3676: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3677: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3678: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3679: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3680: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3681: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3682: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3683: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3684: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3677: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3678: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3679: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3680: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3681: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3682: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3683: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3684: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3685: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3678: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3679: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3680: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3681: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3682: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3683: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3684: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3685: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3686:
3679: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3680: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3681: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3682: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3683: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3684: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3685: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3686:
3687: ln_step := 6;
3680: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3681: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3682: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3683: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3684: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3685: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3686:
3687: ln_step := 6;
3688: pay_ac_action_arch.initialization_process;
3681: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3682: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3683: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3684: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3685: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3686:
3687: ln_step := 6;
3688: pay_ac_action_arch.initialization_process;
3689:
3700: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
3701: );
3702:
3703:
3704: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3705: ln_step := 8;
3706: /******************************************************************
3707: ** For seperate check cases, the ld_last_xfr_eff_date is never NULL
3708: ** as the master is always processed before the child actions. The
3709: ** master data is already in the archive table and as it is in the
3710: ** same session the process will always go to the ELSE statement
3711: ******************************************************************/
3712: IF ld_last_xfr_eff_date IS NULL THEN
3713: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3714: first_time_process(
3715: p_xfr_action_id => p_xfr_action_id
3716: ,p_assignment_id => p_assignment_id
3717: ,p_curr_pymt_action_id => p_rqp_action_id
3769: END IF;
3770:
3771: END IF;
3772:
3773: -- hr_utility.set_location(gv_package || lv_procedure_name, 145);
3774: -- ln_step := 13;
3775: -- populate_summary(p_xfr_action_id => p_xfr_action_id);
3776:
3777: END IF; /* p_archive_balance_info = 'Y' */
3775: -- populate_summary(p_xfr_action_id => p_xfr_action_id);
3776:
3777: END IF; /* p_archive_balance_info = 'Y' */
3778:
3779: hr_utility.set_location(gv_package || lv_procedure_name, 150);
3780: ln_step := 14;
3781: pay_emp_action_arch.get_personal_information(
3782: p_payroll_action_id => p_xfr_payroll_action_id
3783: ,p_assactid => p_xfr_action_id
3808: ,p_run_action_id => p_payment_action_id
3809: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
3810: );
3811:
3812: hr_utility.set_location(gv_package || lv_procedure_name, 210);
3813: ln_step := 16;
3814: pay_emp_action_arch.insert_rows_thro_api_process(
3815: p_action_context_id => p_xfr_action_id
3816: ,p_action_context_type=> 'AAP'
3819: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3820: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
3821: );
3822:
3823: hr_utility.set_location(gv_package || lv_procedure_name, 220);
3824: ln_step := 17;
3825: update_employee_information(
3826: p_action_context_id => p_xfr_action_id
3827: ,p_assignment_id => p_assignment_id);
3825: update_employee_information(
3826: p_action_context_id => p_xfr_action_id
3827: ,p_assignment_id => p_assignment_id);
3828:
3829: hr_utility.set_location(gv_package || lv_procedure_name, 250);
3830:
3831: EXCEPTION
3832: WHEN OTHERS THEN
3833: lv_error_message := 'Error IN step ' ||ln_step|| ' of '||
3832: WHEN OTHERS THEN
3833: lv_error_message := 'Error IN step ' ||ln_step|| ' of '||
3834: gv_package || lv_procedure_name;
3835:
3836: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3837:
3838: lv_error_message :=
3839: pay_emp_action_arch.set_error_message(lv_error_message);
3840:
3837:
3838: lv_error_message :=
3839: pay_emp_action_arch.set_error_message(lv_error_message);
3840:
3841: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3842: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3843: hr_utility.raise_error;
3844:
3845: END process_actions;
3838: lv_error_message :=
3839: pay_emp_action_arch.set_error_message(lv_error_message);
3840:
3841: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3842: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3843: hr_utility.raise_error;
3844:
3845: END process_actions;
3846:
3839: pay_emp_action_arch.set_error_message(lv_error_message);
3840:
3841: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3842: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3843: hr_utility.raise_error;
3844:
3845: END process_actions;
3846:
3847: /******************************************************************
3924: lv_er_rfc_id,
3925: lv_er_ss_id;
3926: CLOSE c_get_legal_er_details;
3927:
3928: hr_utility.trace('lv_legal_employer_name: ' || lv_legal_employer_name);
3929: hr_utility.trace('lv_er_rfc_id ' || lv_er_rfc_id);
3930: hr_utility.trace('lv_er_ss_id ' || lv_er_ss_id);
3931:
3932: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3925: lv_er_ss_id;
3926: CLOSE c_get_legal_er_details;
3927:
3928: hr_utility.trace('lv_legal_employer_name: ' || lv_legal_employer_name);
3929: hr_utility.trace('lv_er_rfc_id ' || lv_er_rfc_id);
3930: hr_utility.trace('lv_er_ss_id ' || lv_er_ss_id);
3931:
3932: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3933: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3926: CLOSE c_get_legal_er_details;
3927:
3928: hr_utility.trace('lv_legal_employer_name: ' || lv_legal_employer_name);
3929: hr_utility.trace('lv_er_rfc_id ' || lv_er_rfc_id);
3930: hr_utility.trace('lv_er_ss_id ' || lv_er_ss_id);
3931:
3932: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3933: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3934: := 'MX EMPLOYER DETAILS';
3968: OPEN c_get_gre_details;
3969: FETCH c_get_gre_details INTO lv_er_ss_id;
3970: CLOSE c_get_gre_details;
3971:
3972: hr_utility.trace('lv_er_ss_id ' || lv_er_ss_id);
3973:
3974: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3975: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3976: := 'MX EMPLOYER DETAILS';
4013:
4014: OPEN c_get_other_info(p_organization_id
4015: ,'Organization:Payslip Info') ;
4016: LOOP
4017: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4018: FETCH c_get_other_info INTO lv_org_information1
4019: ,lv_org_information2
4020: ,lv_org_information3
4021: ,lv_org_information4
4022: ,lv_org_information5
4023: ,lv_org_information6
4024: ,lv_org_information7;
4025: IF c_get_other_info%NOTFOUND THEN
4026: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4027: EXIT;
4028: END IF;
4029:
4030:
4027: EXIT;
4028: END IF;
4029:
4030:
4031: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4032:
4033: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4034: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4035: := 'EMPLOYEE OTHER INFORMATION';
4047: := lv_org_information6;
4048: END LOOP ;
4049: CLOSE c_get_other_info;
4050:
4051: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4052: OPEN c_get_other_info(p_business_group_id
4053: ,'Business Group:Payslip Info') ;
4054: LOOP
4055: hr_utility.set_location(gv_package || lv_procedure_name, 110);
4051: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4052: OPEN c_get_other_info(p_business_group_id
4053: ,'Business Group:Payslip Info') ;
4054: LOOP
4055: hr_utility.set_location(gv_package || lv_procedure_name, 110);
4056: FETCH c_get_other_info INTO lv_org_information1
4057: ,lv_org_information2
4058: ,lv_org_information3
4059: ,lv_org_information4
4060: ,lv_org_information5
4061: ,lv_org_information6
4062: ,lv_org_information7;
4063: IF c_get_other_info%NOTFOUND THEN
4064: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4065: EXIT;
4066: END IF;
4067:
4068: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4064: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4065: EXIT;
4066: END IF;
4067:
4068: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4069: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4070: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4071: := 'EMPLOYEE OTHER INFORMATION';
4072: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code
4082: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
4083: := lv_org_information6;
4084: END LOOP ;
4085: CLOSE c_get_other_info;
4086: hr_utility.set_location(gv_package || lv_procedure_name, 140);
4087:
4088: END get_org_other_info;
4089:
4090:
4122: lv_exists := 'N';
4123: lv_procedure_name := '.arch_pay_action_level_data:get_legal_ER_address';
4124:
4125: -- Get Employer address
4126: hr_utility.set_location(gv_package || lv_procedure_name, 210);
4127: OPEN c_addr_line(p_organization_id);
4128: FETCH c_addr_line INTO lv_er_address_line_1
4129: ,lv_er_address_line_2
4130: ,lv_er_address_line_3
4135: ,lv_er_postal_code
4136: ,lv_er_country
4137: ,lv_er_telephone;
4138: CLOSE c_addr_line;
4139: hr_utility.set_location(gv_package || lv_procedure_name, 250);
4140:
4141: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN
4142: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
4143: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP
4151: END LOOP;
4152: END IF;
4153:
4154: IF lv_exists = 'N' THEN
4155: hr_utility.set_location(gv_package || lv_procedure_name, 260);
4156: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
4157:
4158: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
4159: := 'ADDRESS DETAILS';
4187:
4188: BEGIN
4189: lv_procedure_name := '.arch_pay_action_level_data';
4190:
4191: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4192: OPEN c_get_organization(p_payroll_id, p_effective_date);
4193: LOOP
4194: FETCH c_get_organization INTO ln_organization_id,
4195: ln_business_group_id;
4197: EXIT;
4198: END IF;
4199:
4200: get_org_other_info(ln_organization_id, ln_business_group_id);
4201: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4202:
4203: END LOOP;
4204: CLOSE c_get_organization;
4205:
4210: --
4211: OPEN c_get_legal_ER;
4212: LOOP
4213: FETCH c_get_legal_ER INTO ln_organization_id;
4214: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4215:
4216: IF c_get_legal_ER%NOTFOUND THEN
4217: EXIT;
4218: END IF;
4217: EXIT;
4218: END IF;
4219:
4220: get_legal_ER_address(ln_organization_id);
4221: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4222:
4223: get_legal_ER_details(ln_organization_id);
4224: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4225:
4220: get_legal_ER_address(ln_organization_id);
4221: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4222:
4223: get_legal_ER_details(ln_organization_id);
4224: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4225:
4226: END LOOP;
4227: CLOSE c_get_legal_ER;
4228:
4232: --
4233: OPEN c_get_gre;
4234: LOOP
4235: FETCH c_get_gre INTO ln_organization_id;
4236: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4237:
4238: IF c_get_gre%NOTFOUND THEN
4239: EXIT;
4240: END IF;
4239: EXIT;
4240: END IF;
4241:
4242: get_gre_details(ln_organization_id);
4243: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4244:
4245: END LOOP;
4246: CLOSE c_get_gre;
4247:
4245: END LOOP;
4246: CLOSE c_get_gre;
4247:
4248:
4249: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4250:
4251: -- insert rows in pay_action_information table
4252: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN
4253: pay_emp_action_arch.insert_rows_thro_api_process(
4260: );
4261: END IF;
4262: EXCEPTION
4263: WHEN OTHERS THEN
4264: hr_utility.trace('Error in ' || gv_package || '.'
4265: || lv_procedure_name || '-'
4266: || TO_CHAR(SQLCODE) || '-' || SQLERRM);
4267: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4268: RAISE hr_utility.hr_error;
4263: WHEN OTHERS THEN
4264: hr_utility.trace('Error in ' || gv_package || '.'
4265: || lv_procedure_name || '-'
4266: || TO_CHAR(SQLCODE) || '-' || SQLERRM);
4267: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4268: RAISE hr_utility.hr_error;
4269:
4270: END arch_pay_action_level_data;
4271:
4264: hr_utility.trace('Error in ' || gv_package || '.'
4265: || lv_procedure_name || '-'
4266: || TO_CHAR(SQLCODE) || '-' || SQLERRM);
4267: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4268: RAISE hr_utility.hr_error;
4269:
4270: END arch_pay_action_level_data;
4271:
4272:
4430: AND ppa.effective_date <= cp_curr_eff_date
4431: ORDER BY 1;
4432:
4433: BEGIN
4434: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4435: lv_procedure_name := '.process_additional_elements';
4436: lv_action_category := 'AC DEDUCTIONS';
4437:
4438:
4506: ln_hours_balance_id,
4507: ln_days_balance_id;
4508:
4509: IF c_prev_ytd_action_elem_rbr%NOTFOUND THEN
4510: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4511: EXIT;
4512: END IF;
4513: ELSE
4514: FETCH c_prev_ytd_action_elements INTO
4519: ln_hours_balance_id,
4520: ln_days_balance_id;
4521:
4522: IF c_prev_ytd_action_elements%NOTFOUND THEN
4523: hr_utility.set_location(gv_package || lv_procedure_name, 45);
4524: EXIT;
4525: END IF;
4526: END IF;
4527:
4524: EXIT;
4525: END IF;
4526: END IF;
4527:
4528: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4529: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
4530: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
4531: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
4532:
4525: END IF;
4526: END IF;
4527:
4528: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4529: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
4530: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
4531: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
4532:
4533: IF lv_attribute_name IN ('Deductions',
4526: END IF;
4527:
4528: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4529: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
4530: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
4531: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
4532:
4533: IF lv_attribute_name IN ('Deductions',
4534: 'Employee Taxes',
4527:
4528: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4529: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
4530: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
4531: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
4532:
4533: IF lv_attribute_name IN ('Deductions',
4534: 'Employee Taxes',
4535: 'Tax Calculation Details') THEN
4548:
4549:
4550: IF ln_hours_balance_id IS NOT NULL THEN
4551: ln_step := 40;
4552: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4553: ln_ytd_hours_balance_id
4554: := pay_emp_action_arch.get_defined_balance_id(
4555: ln_hours_balance_id,
4556: gv_ytd_balance_dimension,
4554: := pay_emp_action_arch.get_defined_balance_id(
4555: ln_hours_balance_id,
4556: gv_ytd_balance_dimension,
4557: p_legislation_code);
4558: hr_utility.trace('ln_ytd_hours_balance_id = '||
4559: ln_ytd_hours_balance_id);
4560: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4561:
4562: ln_step := 50;
4556: gv_ytd_balance_dimension,
4557: p_legislation_code);
4558: hr_utility.trace('ln_ytd_hours_balance_id = '||
4559: ln_ytd_hours_balance_id);
4560: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4561:
4562: ln_step := 50;
4563: IF ln_ytd_hours_balance_id IS NOT NULL THEN
4564: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
4563: IF ln_ytd_hours_balance_id IS NOT NULL THEN
4564: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
4565: ln_ytd_hours_balance_id,
4566: p_assignment_action_id),0);
4567: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4568: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4569: END IF;
4570: END IF; --Hours
4571:
4564: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
4565: ln_ytd_hours_balance_id,
4566: p_assignment_action_id),0);
4567: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4568: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4569: END IF;
4570: END IF; --Hours
4571:
4572:
4572:
4573:
4574: IF ln_days_balance_id IS NOT NULL THEN
4575: ln_step := 60;
4576: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4577: ln_ytd_days_balance_id
4578: := pay_emp_action_arch.get_defined_balance_id(
4579: ln_days_balance_id,
4580: gv_ytd_balance_dimension,
4578: := pay_emp_action_arch.get_defined_balance_id(
4579: ln_days_balance_id,
4580: gv_ytd_balance_dimension,
4581: p_legislation_code);
4582: hr_utility.trace('ln_ytd_days_balance_id = '||
4583: ln_ytd_days_balance_id);
4584: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4585:
4586: ln_step := 70;
4580: gv_ytd_balance_dimension,
4581: p_legislation_code);
4582: hr_utility.trace('ln_ytd_days_balance_id = '||
4583: ln_ytd_days_balance_id);
4584: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4585:
4586: ln_step := 70;
4587: IF ln_ytd_days_balance_id IS NOT NULL THEN
4588: ln_ytd_days := NVL(pay_balance_pkg.get_value(
4587: IF ln_ytd_days_balance_id IS NOT NULL THEN
4588: ln_ytd_days := NVL(pay_balance_pkg.get_value(
4589: ln_ytd_days_balance_id,
4590: p_assignment_action_id),0);
4591: hr_utility.trace('ln_ytd_days = '||ln_ytd_days);
4592: hr_utility.set_location(gv_package || lv_procedure_name, 110);
4593: END IF;
4594: END IF; --Days
4595:
4588: ln_ytd_days := NVL(pay_balance_pkg.get_value(
4589: ln_ytd_days_balance_id,
4590: p_assignment_action_id),0);
4591: hr_utility.trace('ln_ytd_days = '||ln_ytd_days);
4592: hr_utility.set_location(gv_package || lv_procedure_name, 110);
4593: END IF;
4594: END IF; --Days
4595:
4596:
4600: := pay_emp_action_arch.get_defined_balance_id
4601: (ln_primary_balance_id,
4602: gv_ytd_balance_dimension,
4603: p_legislation_code);
4604: hr_utility.trace('ln_ytd_defined_balance_id = '||
4605: ln_ytd_defined_balance_id);
4606: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4607: IF ln_ytd_defined_balance_id IS NOT NULL THEN
4608: ln_step := 90;
4602: gv_ytd_balance_dimension,
4603: p_legislation_code);
4604: hr_utility.trace('ln_ytd_defined_balance_id = '||
4605: ln_ytd_defined_balance_id);
4606: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4607: IF ln_ytd_defined_balance_id IS NOT NULL THEN
4608: ln_step := 90;
4609: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
4610: ln_ytd_defined_balance_id,
4608: ln_step := 90;
4609: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
4610: ln_ytd_defined_balance_id,
4611: p_assignment_action_id),0);
4612: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4613: END IF;
4614: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4615:
4616:
4610: ln_ytd_defined_balance_id,
4611: p_assignment_action_id),0);
4612: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4613: END IF;
4614: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4615:
4616:
4617: IF NVL(ln_ytd_amount, 0) <> 0 THEN
4618: ln_step := 100;
4617: IF NVL(ln_ytd_amount, 0) <> 0 THEN
4618: ln_step := 100;
4619: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
4620:
4621: hr_utility.trace('ln_element_index = '||ln_element_index);
4622:
4623: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4624: := lv_reporting_name;
4625: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4630: := lv_jurisdiction_code;
4631:
4632:
4633: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4634: hr_utility.trace('ln_index = '||ln_index);
4635: IF lv_attribute_name IN ('Employee Earnings', 'Hourly Earnings',
4636: 'Taxable Benefits') THEN
4637: hr_utility.set_location(gv_package || lv_procedure_name, 140);
4638: lv_action_category := 'AC EARNINGS';
4633: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4634: hr_utility.trace('ln_index = '||ln_index);
4635: IF lv_attribute_name IN ('Employee Earnings', 'Hourly Earnings',
4636: 'Taxable Benefits') THEN
4637: hr_utility.set_location(gv_package || lv_procedure_name, 140);
4638: lv_action_category := 'AC EARNINGS';
4639: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4640: hr_utility.trace('ln_ytd_hours = ' ||ln_ytd_hours);
4641: hr_utility.trace('ln_current_days = ' ||ln_current_days);
4635: IF lv_attribute_name IN ('Employee Earnings', 'Hourly Earnings',
4636: 'Taxable Benefits') THEN
4637: hr_utility.set_location(gv_package || lv_procedure_name, 140);
4638: lv_action_category := 'AC EARNINGS';
4639: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4640: hr_utility.trace('ln_ytd_hours = ' ||ln_ytd_hours);
4641: hr_utility.trace('ln_current_days = ' ||ln_current_days);
4642: hr_utility.trace('ln_ytd_days = ' ||ln_ytd_days);
4643: ln_step := 120;
4636: 'Taxable Benefits') THEN
4637: hr_utility.set_location(gv_package || lv_procedure_name, 140);
4638: lv_action_category := 'AC EARNINGS';
4639: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4640: hr_utility.trace('ln_ytd_hours = ' ||ln_ytd_hours);
4641: hr_utility.trace('ln_current_days = ' ||ln_current_days);
4642: hr_utility.trace('ln_ytd_days = ' ||ln_ytd_days);
4643: ln_step := 120;
4644: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4637: hr_utility.set_location(gv_package || lv_procedure_name, 140);
4638: lv_action_category := 'AC EARNINGS';
4639: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4640: hr_utility.trace('ln_ytd_hours = ' ||ln_ytd_hours);
4641: hr_utility.trace('ln_current_days = ' ||ln_current_days);
4642: hr_utility.trace('ln_ytd_days = ' ||ln_ytd_days);
4643: ln_step := 120;
4644: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4645: := fnd_number.number_to_canonical(ln_current_hours);
4638: lv_action_category := 'AC EARNINGS';
4639: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4640: hr_utility.trace('ln_ytd_hours = ' ||ln_ytd_hours);
4641: hr_utility.trace('ln_current_days = ' ||ln_current_days);
4642: hr_utility.trace('ln_ytd_days = ' ||ln_ytd_days);
4643: ln_step := 120;
4644: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4645: := fnd_number.number_to_canonical(ln_current_hours);
4646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4651: := fnd_number.number_to_canonical(ln_ytd_days);
4652: ELSE
4653: lv_action_category := 'AC DEDUCTIONS';
4654: END IF;
4655: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4656: hr_utility.trace('lv_action_category = '||lv_action_category);
4657: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4658: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4659: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4652: ELSE
4653: lv_action_category := 'AC DEDUCTIONS';
4654: END IF;
4655: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4656: hr_utility.trace('lv_action_category = '||lv_action_category);
4657: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4658: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4659: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4660: ln_step := 130;
4653: lv_action_category := 'AC DEDUCTIONS';
4654: END IF;
4655: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4656: hr_utility.trace('lv_action_category = '||lv_action_category);
4657: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4658: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4659: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4660: ln_step := 130;
4661:
4654: END IF;
4655: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4656: hr_utility.trace('lv_action_category = '||lv_action_category);
4657: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4658: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4659: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4660: ln_step := 130;
4661:
4662: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4655: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4656: hr_utility.trace('lv_action_category = '||lv_action_category);
4657: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4658: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4659: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4660: ln_step := 130;
4661:
4662: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4663: := lv_action_category;
4674: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4675: := lv_reporting_name;
4676:
4677: END IF;
4678: hr_utility.set_location(gv_package || lv_procedure_name, 160);
4679:
4680: END LOOP;
4681: IF lv_run_bal_status = 'Y' THEN
4682: CLOSE c_prev_ytd_action_elem_rbr;
4697: ,p_ytd_balcall_aaid => p_assignment_action_id
4698: );
4699:
4700: ln_step := 150;
4701: hr_utility.trace('------------Looping to see pl/sql table --------');
4702: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4703: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4704:
4705: hr_utility.trace('ln_check_count = '||ln_check_count);
4701: hr_utility.trace('------------Looping to see pl/sql table --------');
4702: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4703: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4704:
4705: hr_utility.trace('ln_check_count = '||ln_check_count);
4706: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4707: hr_utility.trace('============= End of Processing '||p_assignment_id||
4708: '=============');
4709: hr_utility.set_location(gv_package || lv_procedure_name,170);
4702: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4703: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4704:
4705: hr_utility.trace('ln_check_count = '||ln_check_count);
4706: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4707: hr_utility.trace('============= End of Processing '||p_assignment_id||
4708: '=============');
4709: hr_utility.set_location(gv_package || lv_procedure_name,170);
4710:
4703: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4704:
4705: hr_utility.trace('ln_check_count = '||ln_check_count);
4706: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4707: hr_utility.trace('============= End of Processing '||p_assignment_id||
4708: '=============');
4709: hr_utility.set_location(gv_package || lv_procedure_name,170);
4710:
4711: EXCEPTION
4705: hr_utility.trace('ln_check_count = '||ln_check_count);
4706: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4707: hr_utility.trace('============= End of Processing '||p_assignment_id||
4708: '=============');
4709: hr_utility.set_location(gv_package || lv_procedure_name,170);
4710:
4711: EXCEPTION
4712: WHEN OTHERS THEN
4713:
4713:
4714: lv_error_message := 'Error at step ' || ln_step ||
4715: ' in ' || gv_package || lv_procedure_name;
4716:
4717: hr_utility.trace(lv_error_message || '-' || SQLERRM);
4718:
4719: lv_error_message :=
4720: pay_emp_action_arch.set_error_message(lv_error_message);
4721:
4718:
4719: lv_error_message :=
4720: pay_emp_action_arch.set_error_message(lv_error_message);
4721:
4722: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4723: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4724: hr_utility.raise_error;
4725:
4726: END process_additional_elements;
4719: lv_error_message :=
4720: pay_emp_action_arch.set_error_message(lv_error_message);
4721:
4722: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4723: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4724: hr_utility.raise_error;
4725:
4726: END process_additional_elements;
4727:
4720: pay_emp_action_arch.set_error_message(lv_error_message);
4721:
4722: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4723: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4724: hr_utility.raise_error;
4725:
4726: END process_additional_elements;
4727:
4728:
4932: lv_archive_balance_info := 'Y';
4933:
4934:
4935: pay_emp_action_arch.gv_error_message := NULL;
4936: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4937: ln_step := 1;
4938: OPEN c_xfr_info (p_xfr_action_id);
4939: FETCH c_xfr_info INTO ln_xfr_payroll_action_id,
4940: ln_xfr_master_action_id,
4951: ,p_business_group_id => ln_business_group_id
4952: ,p_cons_set_id => ln_cons_set_id
4953: ,p_payroll_id => ln_payroll_id);
4954:
4955: hr_utility.set_location(gv_package || lv_procedure_name, 15);
4956:
4957: ln_step := 205;
4958: pay_emp_action_arch.gv_multi_payroll_pymt
4959: := pay_emp_action_arch.get_multi_assignment_flag(
4959: := pay_emp_action_arch.get_multi_assignment_flag(
4960: p_payroll_id => ln_payroll_id
4961: ,p_effective_date => ld_end_date);
4962:
4963: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
4964: pay_emp_action_arch.gv_multi_payroll_pymt);
4965:
4966: ln_step := 3;
4967: OPEN c_legislation (ln_business_group_id);
4966: ln_step := 3;
4967: OPEN c_legislation (ln_business_group_id);
4968: FETCH c_legislation INTO lv_legislation_code ;
4969: IF c_legislation%NOTFOUND THEN
4970: hr_utility.trace('Business Group FOR Archiver Process Not Found');
4971: hr_utility.raise_error;
4972: END IF;
4973: CLOSE c_legislation;
4974: hr_utility.trace('lv_legislation_code '||lv_legislation_code);
4967: OPEN c_legislation (ln_business_group_id);
4968: FETCH c_legislation INTO lv_legislation_code ;
4969: IF c_legislation%NOTFOUND THEN
4970: hr_utility.trace('Business Group FOR Archiver Process Not Found');
4971: hr_utility.raise_error;
4972: END IF;
4973: CLOSE c_legislation;
4974: hr_utility.trace('lv_legislation_code '||lv_legislation_code);
4975:
4970: hr_utility.trace('Business Group FOR Archiver Process Not Found');
4971: hr_utility.raise_error;
4972: END IF;
4973: CLOSE c_legislation;
4974: hr_utility.trace('lv_legislation_code '||lv_legislation_code);
4975:
4976: ln_step := 4;
4977:
4978: -- process the master_action
4985: ln_step := 5;
4986: OPEN c_pymt_eff_date(ln_asg_action_id);
4987: FETCH c_pymt_eff_date INTO ld_curr_pymt_eff_date;
4988: IF c_pymt_eff_date%NOTFOUND THEN
4989: hr_utility.trace('Payroll Action FOR Archiver Process Not Found');
4990: hr_utility.raise_error;
4991: END IF;
4992: CLOSE c_pymt_eff_date;
4993:
4986: OPEN c_pymt_eff_date(ln_asg_action_id);
4987: FETCH c_pymt_eff_date INTO ld_curr_pymt_eff_date;
4988: IF c_pymt_eff_date%NOTFOUND THEN
4989: hr_utility.trace('Payroll Action FOR Archiver Process Not Found');
4990: hr_utility.raise_error;
4991: END IF;
4992: CLOSE c_pymt_eff_date;
4993:
4994: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4990: hr_utility.raise_error;
4991: END IF;
4992: CLOSE c_pymt_eff_date;
4993:
4994: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4995: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4996: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4997: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);
4998: hr_utility.trace('ln_xfr_payroll_action_id =' ||
4991: END IF;
4992: CLOSE c_pymt_eff_date;
4993:
4994: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4995: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4996: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4997: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);
4998: hr_utility.trace('ln_xfr_payroll_action_id =' ||
4999: TO_CHAR(ln_xfr_payroll_action_id));
4992: CLOSE c_pymt_eff_date;
4993:
4994: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4995: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4996: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4997: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);
4998: hr_utility.trace('ln_xfr_payroll_action_id =' ||
4999: TO_CHAR(ln_xfr_payroll_action_id));
5000:
4993:
4994: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4995: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4996: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4997: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);
4998: hr_utility.trace('ln_xfr_payroll_action_id =' ||
4999: TO_CHAR(ln_xfr_payroll_action_id));
5000:
5001: ln_step := 6;
4994: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4995: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4996: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4997: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);
4998: hr_utility.trace('ln_xfr_payroll_action_id =' ||
4999: TO_CHAR(ln_xfr_payroll_action_id));
5000:
5001: ln_step := 6;
5002: IF lv_master_action_type IN ( 'P','U') THEN
5014: ,ln_source_action_id
5015: ,ln_asg_action_id;
5016: EXIT WHEN c_payment_info%NOTFOUND;
5017:
5018: hr_utility.trace('archive_code:payment_info: ln_asg_action_id' ||
5019: ln_asg_action_id );
5020: hr_utility.trace('archive_code:payment_info: ln_assignment_id' ||
5021: ln_assignment_id );
5022: hr_utility.trace('archive_code:payment_info: ln_tax_unit_id' ||
5016: EXIT WHEN c_payment_info%NOTFOUND;
5017:
5018: hr_utility.trace('archive_code:payment_info: ln_asg_action_id' ||
5019: ln_asg_action_id );
5020: hr_utility.trace('archive_code:payment_info: ln_assignment_id' ||
5021: ln_assignment_id );
5022: hr_utility.trace('archive_code:payment_info: ln_tax_unit_id' ||
5023: ln_tax_unit_id );
5024: hr_utility.trace('archive_code:payment_info: ln_source_action_id' ||
5018: hr_utility.trace('archive_code:payment_info: ln_asg_action_id' ||
5019: ln_asg_action_id );
5020: hr_utility.trace('archive_code:payment_info: ln_assignment_id' ||
5021: ln_assignment_id );
5022: hr_utility.trace('archive_code:payment_info: ln_tax_unit_id' ||
5023: ln_tax_unit_id );
5024: hr_utility.trace('archive_code:payment_info: ln_source_action_id' ||
5025: ln_source_action_id );
5026:
5020: hr_utility.trace('archive_code:payment_info: ln_assignment_id' ||
5021: ln_assignment_id );
5022: hr_utility.trace('archive_code:payment_info: ln_tax_unit_id' ||
5023: ln_tax_unit_id );
5024: hr_utility.trace('archive_code:payment_info: ln_source_action_id' ||
5025: ln_source_action_id );
5026:
5027: ln_step := 8;
5028:
5049: END IF;
5050: CLOSE c_run_aa_id;
5051:
5052: ln_step := 10;
5053: hr_utility.trace('GRE ln_run_aa_id = ' || ln_run_aa_id);
5054:
5055: IF ln_run_source_action_id IS NOT NULL THEN
5056: ln_master_run_aa_id := ln_run_source_action_id; -- Normal Chk
5057: ELSE
5099: SELECT pay_assignment_actions_s.nextval
5100: INTO ln_child_xfr_action_id
5101: FROM dual;
5102:
5103: hr_utility.set_location(gv_package || lv_procedure_name, 30);
5104:
5105: -- insert into pay_assignment_actions.
5106:
5107: ln_step := 13;
5115: NULL,
5116: 'C',
5117: p_xfr_action_id);
5118:
5119: hr_utility.set_location(gv_package || lv_procedure_name, 40);
5120:
5121: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);
5122: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);
5123:
5117: p_xfr_action_id);
5118:
5119: hr_utility.set_location(gv_package || lv_procedure_name, 40);
5120:
5121: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);
5122: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);
5123:
5124: -- insert an interlock to this action
5125:
5118:
5119: hr_utility.set_location(gv_package || lv_procedure_name, 40);
5120:
5121: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);
5122: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);
5123:
5124: -- insert an interlock to this action
5125:
5126: ln_step := 14;
5138: update pay_assignment_actions
5139: set serial_number = lv_serial_number
5140: WHERE assignment_action_id = ln_child_xfr_action_id;
5141:
5142: hr_utility.trace('Processing Child action ' ||
5143: p_xfr_action_id);
5144:
5145: ELSE
5146: ln_step := 17;
5232: END LOOP; -- c_payment_info
5233:
5234: CLOSE c_payment_info;
5235:
5236: hr_utility.trace('pay_ac_action_arch.g_xfr_run_exists = '||
5237: pay_ac_action_arch.g_xfr_run_exists );
5238:
5239: /***
5240: ** Removed cursor c_get_term_asg as it gets executed when
5249:
5250: IF lv_master_action_type = 'V' THEN
5251: /* ln_asg_action_id is nothing but reversal run action id */
5252: ln_pymt_balcall_aaid := ln_asg_action_id ;
5253: hr_utility.trace('Reversal ln_pymt_balcall_aaid'
5254: ||to_char(ln_pymt_balcall_aaid));
5255: ln_step := 25;
5256: pay_ac_action_arch.initialization_process;
5257:
5254: ||to_char(ln_pymt_balcall_aaid));
5255: ln_step := 25;
5256: pay_ac_action_arch.initialization_process;
5257:
5258: hr_utility.trace('Populating Tax Balances FOR Reversals');
5259: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
5260: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
5261: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
5262: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
5255: ln_step := 25;
5256: pay_ac_action_arch.initialization_process;
5257:
5258: hr_utility.trace('Populating Tax Balances FOR Reversals');
5259: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
5260: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
5261: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
5262: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
5263:
5256: pay_ac_action_arch.initialization_process;
5257:
5258: hr_utility.trace('Populating Tax Balances FOR Reversals');
5259: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
5260: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
5261: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
5262: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
5263:
5264:
5257:
5258: hr_utility.trace('Populating Tax Balances FOR Reversals');
5259: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
5260: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
5261: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
5262: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
5263:
5264:
5265: ln_step := 26;
5258: hr_utility.trace('Populating Tax Balances FOR Reversals');
5259: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
5260: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
5261: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
5262: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
5263:
5264:
5265: ln_step := 26;
5266: populate_tax_and_summary( p_xfr_action_id => p_xfr_action_id
5274: ,p_ytd_balcall_aaid => ln_pymt_balcall_aaid
5275: );
5276:
5277: ln_step := 27;
5278: hr_utility.trace('Populating Current Elements FOR Reversals');
5279: get_current_elements(
5280: p_xfr_action_id => p_xfr_action_id
5281: ,p_curr_pymt_action_id => ln_pymt_balcall_aaid
5282: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
5287: ,p_sepchk_flag => lv_master_sepcheck_flag
5288: ,p_legislation_code => lv_legislation_code
5289: ,p_action_type => lv_master_action_type);
5290:
5291: hr_utility.trace('Done Populating Tax Balances FOR Reversals');
5292: ln_step := 28;
5293: pay_emp_action_arch.insert_rows_thro_api_process(
5294: p_action_context_id => p_xfr_action_id
5295: ,p_action_context_type=> 'AAP'
5304:
5305: ln_step := 29;
5306:
5307: IF lv_master_action_type = 'B' THEN
5308: hr_utility.trace('Populating Current Elements FOR Balance Adjustments');
5309: /* ln_asg_action_id is nothing but Balance Adjustment run action id */
5310: ln_asg_action_id := -1;
5311: pay_ac_action_arch.initialization_process;
5312:
5315: FETCH c_get_emp_adjbal INTO ln_asg_action_id;
5316: EXIT WHEN c_get_emp_adjbal%NOTFOUND;
5317:
5318: ln_pymt_balcall_aaid := ln_asg_action_id ;
5319: hr_utility.trace('Bal Adjustment ln_pymt_balcall_aaid'
5320: ||to_char(ln_pymt_balcall_aaid));
5321:
5322: ln_step := 30;
5323:
5320: ||to_char(ln_pymt_balcall_aaid));
5321:
5322: ln_step := 30;
5323:
5324: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
5325: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
5326: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
5327: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
5328:
5321:
5322: ln_step := 30;
5323:
5324: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
5325: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
5326: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
5327: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
5328:
5329: /* Need to pass Payslip Archiver Assignment_Action_id to
5322: ln_step := 30;
5323:
5324: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
5325: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
5326: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
5327: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
5328:
5329: /* Need to pass Payslip Archiver Assignment_Action_id to
5330: p_curr_pymt_action_id because we have to archive Bal Adjustments
5323:
5324: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
5325: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
5326: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
5327: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
5328:
5329: /* Need to pass Payslip Archiver Assignment_Action_id to
5330: p_curr_pymt_action_id because we have to archive Bal Adjustments
5331: that are not marked for 'Pre-Payment', Otherwise nothing
5365: ** Archive all the payroll action level data once only when
5366: ** chunk number is 1. Also check if this has not been archived
5367: ** earlier
5368: *****************************************************************/
5369: hr_utility.set_location(gv_package || lv_procedure_name,210);
5370: ln_step := 33;
5371: OPEN c_check_pay_action(ln_xfr_payroll_action_id);
5372: FETCH c_check_pay_action INTO ln_pay_action_count;
5373: CLOSE c_check_pay_action;
5371: OPEN c_check_pay_action(ln_xfr_payroll_action_id);
5372: FETCH c_check_pay_action INTO ln_pay_action_count;
5373: CLOSE c_check_pay_action;
5374: IF ln_pay_action_count = 0 THEN
5375: hr_utility.set_location(gv_package || lv_procedure_name,210);
5376: IF ln_chunk_number = 1 THEN
5377: ln_step := 34;
5378: arch_pay_action_level_data(
5379: p_payroll_action_id => ln_xfr_payroll_action_id
5388: WHEN OTHERS THEN
5389: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||
5390: gv_package || lv_procedure_name;
5391:
5392: hr_utility.trace(lv_error_message || '-' || SQLERRM);
5393:
5394: lv_error_message :=
5395: pay_emp_action_arch.set_error_message(lv_error_message);
5396:
5393:
5394: lv_error_message :=
5395: pay_emp_action_arch.set_error_message(lv_error_message);
5396:
5397: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5398: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5399: hr_utility.raise_error;
5400:
5401: END archive_code;
5394: lv_error_message :=
5395: pay_emp_action_arch.set_error_message(lv_error_message);
5396:
5397: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5398: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5399: hr_utility.raise_error;
5400:
5401: END archive_code;
5402:
5395: pay_emp_action_arch.set_error_message(lv_error_message);
5396:
5397: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5398: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5399: hr_utility.raise_error;
5400:
5401: END archive_code;
5402:
5403:
5401: END archive_code;
5402:
5403:
5404: BEGIN
5405: --hr_utility.trace_on (NULL, 'MX_PAYSLIP_ARCHIVE');
5406: gv_package := 'pay_mx_payroll_arch';
5407: gv_dim_asg_gre_ytd := '_ASG_GRE_YTD';
5408: gv_dim_asg_jd_gre_ytd := '_ASG_JD_GRE_YTD';
5409: gv_ytd_balance_dimension := '_ASG_GRE_YTD';