[Home] [Help]
226: begin
227: lv_context_value := '-1';
228: ln_step := 1;
229: lv_procedure_name := '.get_context_value';
230: hr_utility.set_location(gv_package || lv_procedure_name, 10);
231:
232: open cur_context;
233: fetch cur_context into lv_context_value;
234: close cur_context;
232: open cur_context;
233: fetch cur_context into lv_context_value;
234: close cur_context;
235:
236: hr_utility.set_location(gv_package || lv_procedure_name, 20);
237: ln_step := 2;
238: if lv_context_value = 'No Tax Group' then
239: lv_context_value := '-1';
240: end if;
241: return(lv_context_value);
242:
243: EXCEPTION
244: when others then
245: hr_utility.set_location(gv_package || lv_procedure_name, 500);
246: lv_error_message := 'Error at step ' || ln_step ||
247: ' in ' || gv_package || lv_procedure_name;
248: hr_utility.trace(lv_error_message || '-' || sqlerrm);
249:
244: when others then
245: hr_utility.set_location(gv_package || lv_procedure_name, 500);
246: lv_error_message := 'Error at step ' || ln_step ||
247: ' in ' || gv_package || lv_procedure_name;
248: hr_utility.trace(lv_error_message || '-' || sqlerrm);
249:
250: lv_error_message :=
251: pay_emp_action_arch.set_error_message(lv_error_message);
252:
249:
250: lv_error_message :=
251: pay_emp_action_arch.set_error_message(lv_error_message);
252:
253: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
254: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
255: hr_utility.raise_error;
256: return(lv_context_value);
257:
250: lv_error_message :=
251: pay_emp_action_arch.set_error_message(lv_error_message);
252:
253: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
254: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
255: hr_utility.raise_error;
256: return(lv_context_value);
257:
258: end get_context_val;
251: pay_emp_action_arch.set_error_message(lv_error_message);
252:
253: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
254: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
255: hr_utility.raise_error;
256: return(lv_context_value);
257:
258: end get_context_val;
259:
354: BEGIN
355:
356: ln_step := 1;
357: lv_procedure_name := '.get_payroll_action_info';
358: hr_utility.set_location(gv_package || lv_procedure_name, 10);
359: open c_payroll_action_info(p_payroll_action_id);
360: fetch c_payroll_action_info into ld_end_date,
361: ld_start_date,
362: ln_business_group_id,
364: ln_payroll_id;
365: close c_payroll_action_info;
366:
367: ln_step := 2;
368: hr_utility.set_location(gv_package || lv_procedure_name, 30);
369: p_end_date := ld_end_date;
370: p_start_date := ld_start_date;
371: p_business_group_id := ln_business_group_id;
372: p_cons_set_id := ln_cons_set_id;
370: p_start_date := ld_start_date;
371: p_business_group_id := ln_business_group_id;
372: p_cons_set_id := ln_cons_set_id;
373: p_payroll_id := ln_payroll_id;
374: hr_utility.set_location(gv_package || lv_procedure_name, 50);
375:
376: EXCEPTION
377: when others then
378: hr_utility.set_location(gv_package || lv_procedure_name, 500);
374: hr_utility.set_location(gv_package || lv_procedure_name, 50);
375:
376: EXCEPTION
377: when others then
378: hr_utility.set_location(gv_package || lv_procedure_name, 500);
379: lv_error_message := 'Error at step ' || ln_step ||
380: ' in ' || gv_package || lv_procedure_name;
381: hr_utility.trace(lv_error_message || '-' || sqlerrm);
382:
377: when others then
378: hr_utility.set_location(gv_package || lv_procedure_name, 500);
379: lv_error_message := 'Error at step ' || ln_step ||
380: ' in ' || gv_package || lv_procedure_name;
381: hr_utility.trace(lv_error_message || '-' || sqlerrm);
382:
383: lv_error_message :=
384: pay_emp_action_arch.set_error_message(lv_error_message);
385:
382:
383: lv_error_message :=
384: pay_emp_action_arch.set_error_message(lv_error_message);
385:
386: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
387: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
388: hr_utility.raise_error;
389:
390: END get_payroll_action_info;
383: lv_error_message :=
384: pay_emp_action_arch.set_error_message(lv_error_message);
385:
386: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
387: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
388: hr_utility.raise_error;
389:
390: END get_payroll_action_info;
391:
384: pay_emp_action_arch.set_error_message(lv_error_message);
385:
386: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
387: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
388: hr_utility.raise_error;
389:
390: END get_payroll_action_info;
391:
392:
419:
420: BEGIN
421: ln_step := 1;
422: lv_procedure_name := '.populate_fed_prov_bal';
423: hr_utility.set_location(gv_package || lv_procedure_name, 10);
424: i := 0;
425: j := 0;
426:
427: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
429: else
430: pay_balance_pkg.set_context('TAX_UNIT_ID', gn_taxgrp_gre_id);
431: end if;
432:
433: hr_utility.set_location(gv_package || lv_procedure_name, 20);
434: ln_step := 2;
435: for i in dbt.first..dbt.last loop
436:
437: ln_pymt_amount := 0;
481: dbt(i).gre_ytd_def_bal_id,
482: p_ytd_balcall_aaid),0);
483: end if;
484:
485: hr_utility.set_location(gv_package || lv_procedure_name, 30);
486: ln_step := 8;
487: if ( ln_pymt_amount + ln_ytd_amount <> 0 ) then
488:
489:
486: ln_step := 8;
487: if ( ln_pymt_amount + ln_ytd_amount <> 0 ) then
488:
489:
490: hr_utility.trace('lv_lookup_code : '||lv_lookup_code);
491: hr_utility.set_location(gv_package || lv_procedure_name, 40);
492:
493: ln_step := 9;
494: j := 0;
487: if ( ln_pymt_amount + ln_ytd_amount <> 0 ) then
488:
489:
490: hr_utility.trace('lv_lookup_code : '||lv_lookup_code);
491: hr_utility.set_location(gv_package || lv_procedure_name, 40);
492:
493: ln_step := 9;
494: j := 0;
495: for j in tax.first..tax.last loop
501: end if;
502: end loop;
503:
504: /*Insert this into the plsql table */
505: hr_utility.trace('Tax Balance Name : '|| dbt(i).bal_name );
506: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
507: hr_utility.set_location(gv_package || lv_procedure_name, 50);
508:
509: ln_step := 10;
502: end loop;
503:
504: /*Insert this into the plsql table */
505: hr_utility.trace('Tax Balance Name : '|| dbt(i).bal_name );
506: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
507: hr_utility.set_location(gv_package || lv_procedure_name, 50);
508:
509: ln_step := 10;
510: ln_index := pay_ac_action_arch.lrr_act_tab.count;
503:
504: /*Insert this into the plsql table */
505: hr_utility.trace('Tax Balance Name : '|| dbt(i).bal_name );
506: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
507: hr_utility.set_location(gv_package || lv_procedure_name, 50);
508:
509: ln_step := 10;
510: ln_index := pay_ac_action_arch.lrr_act_tab.count;
511:
508:
509: ln_step := 10;
510: ln_index := pay_ac_action_arch.lrr_act_tab.count;
511:
512: hr_utility.trace('ln_index is '
513: || pay_ac_action_arch.lrr_act_tab.count);
514:
515: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
516: := 'AC DEDUCTIONS';
534: := fnd_number.number_to_canonical(ln_ytd_amount);
535: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
536: := lv_reporting_name; --lv_reporting_name bug#2077373;
537:
538: hr_utility.set_location(gv_package || lv_procedure_name, 60);
539:
540: ln_step := 11;
541: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
542: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
547: := dbt(i).bal_name;
548: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
549: := dbt(i).bal_type_id;
550:
551: hr_utility.set_location(gv_package || lv_procedure_name, 70);
552:
553:
554: end if;
555:
554: end if;
555:
556: end loop;
557:
558: hr_utility.set_location(gv_package || lv_procedure_name, 80);
559:
560: EXCEPTION
561: when others then
562: hr_utility.set_location(gv_package || lv_procedure_name, 500);
558: hr_utility.set_location(gv_package || lv_procedure_name, 80);
559:
560: EXCEPTION
561: when others then
562: hr_utility.set_location(gv_package || lv_procedure_name, 500);
563: lv_error_message := 'Error at step ' || ln_step ||
564: ' in ' || gv_package || lv_procedure_name;
565: hr_utility.trace(lv_error_message || '-' || sqlerrm);
566:
561: when others then
562: hr_utility.set_location(gv_package || lv_procedure_name, 500);
563: lv_error_message := 'Error at step ' || ln_step ||
564: ' in ' || gv_package || lv_procedure_name;
565: hr_utility.trace(lv_error_message || '-' || sqlerrm);
566:
567: lv_error_message :=
568: pay_emp_action_arch.set_error_message(lv_error_message);
569:
566:
567: lv_error_message :=
568: pay_emp_action_arch.set_error_message(lv_error_message);
569:
570: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
571: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
572: hr_utility.raise_error;
573:
574: END populate_fed_prov_bal;
567: lv_error_message :=
568: pay_emp_action_arch.set_error_message(lv_error_message);
569:
570: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
571: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
572: hr_utility.raise_error;
573:
574: END populate_fed_prov_bal;
575:
568: pay_emp_action_arch.set_error_message(lv_error_message);
569:
570: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
571: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
572: hr_utility.raise_error;
573:
574: END populate_fed_prov_bal;
575:
576: --payslip
612: ln_step NUMBER;
613:
614: BEGIN
615:
616: hr_utility.trace('Entering get_last_pymt_info');
617: lv_procedure_name := '.get_last_pymt_info';
618:
619: ln_step := 1;
620: open c_last_payment_info(p_assignment_id,p_curr_pymt_eff_date);
623: ln_last_pymt_ass_act_id ;
624:
625: if c_last_payment_info%NOTFOUND then
626:
627: hr_utility.trace('This process has not been run earlier');
628:
629: end if;
630: close c_last_payment_info ;
631:
632:
633: p_last_pymt_eff_date := ld_last_pymt_eff_date;
634: p_last_pymt_ass_act_id := ln_last_pymt_ass_act_id;
635:
636: hr_utility.trace('Leaving get_last_pymt_info');
637:
638: EXCEPTION
639: when others then
640: hr_utility.set_location(gv_package || lv_procedure_name, 500);
636: hr_utility.trace('Leaving get_last_pymt_info');
637:
638: EXCEPTION
639: when others then
640: hr_utility.set_location(gv_package || lv_procedure_name, 500);
641: lv_error_message := 'Error at step ' || ln_step ||
642: ' in ' || gv_package || lv_procedure_name;
643: hr_utility.trace(lv_error_message || '-' || sqlerrm);
644:
639: when others then
640: hr_utility.set_location(gv_package || lv_procedure_name, 500);
641: lv_error_message := 'Error at step ' || ln_step ||
642: ' in ' || gv_package || lv_procedure_name;
643: hr_utility.trace(lv_error_message || '-' || sqlerrm);
644:
645: lv_error_message :=
646: pay_emp_action_arch.set_error_message(lv_error_message);
647:
644:
645: lv_error_message :=
646: pay_emp_action_arch.set_error_message(lv_error_message);
647:
648: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
649: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
650: hr_utility.raise_error;
651:
652: END get_last_pymt_info;
645: lv_error_message :=
646: pay_emp_action_arch.set_error_message(lv_error_message);
647:
648: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
649: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
650: hr_utility.raise_error;
651:
652: END get_last_pymt_info;
653:
646: pay_emp_action_arch.set_error_message(lv_error_message);
647:
648: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
649: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
650: hr_utility.raise_error;
651:
652: END get_last_pymt_info;
653:
654:
787: lv_procedure_name := '.process_actions';
788: lv_person_lang := 'US';
789: ln_taxgrp_gre_id := -1;
790:
791: hr_utility.set_location(gv_package || lv_procedure_name, 10);
792: ln_step := 1;
793:
794: /****************************************************************
795: ** For Seperate Check we do the YTD balance calls with the Run
805: if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
806:
807: -- if pay_ac_action_arch.gv_reporting_level = 'GRE' then
808: --
809: -- hr_utility.set_location(gv_package || lv_procedure_name, 40);
810: -- ln_step := 2;
811: -- open c_ytd_aaid_for_gre(p_rqp_action_id,
812: -- p_assignment_id,
813: -- p_tax_unit_id,
813: -- p_tax_unit_id,
814: -- p_sepcheck_run_type_id);
815: -- fetch c_ytd_aaid_for_gre into ln_ytd_balcall_aaid;
816: -- if c_ytd_aaid_for_gre%notfound then
817: -- hr_utility.set_location(gv_package || lv_procedure_name, 50);
818: -- hr_utility.raise_error;
819: -- end if;
820: -- close c_ytd_aaid_for_gre;
821: --
814: -- p_sepcheck_run_type_id);
815: -- fetch c_ytd_aaid_for_gre into ln_ytd_balcall_aaid;
816: -- if c_ytd_aaid_for_gre%notfound then
817: -- hr_utility.set_location(gv_package || lv_procedure_name, 50);
818: -- hr_utility.raise_error;
819: -- end if;
820: -- close c_ytd_aaid_for_gre;
821: --
822: -- else
820: -- close c_ytd_aaid_for_gre;
821: --
822: -- else
823:
824: hr_utility.set_location(gv_package || lv_procedure_name, 40);
825: ln_step := 2;
826: open c_ytd_aaid(p_rqp_action_id,
827: p_assignment_id,
828: p_sepcheck_run_type_id);
827: p_assignment_id,
828: p_sepcheck_run_type_id);
829: fetch c_ytd_aaid into ln_ytd_balcall_aaid;
830: --if c_ytd_aaid%notfound then
831: -- hr_utility.set_location(gv_package || lv_procedure_name, 50);
832: -- hr_utility.raise_error;
833: --end if;
834: close c_ytd_aaid;
835:
828: p_sepcheck_run_type_id);
829: fetch c_ytd_aaid into ln_ytd_balcall_aaid;
830: --if c_ytd_aaid%notfound then
831: -- hr_utility.set_location(gv_package || lv_procedure_name, 50);
832: -- hr_utility.raise_error;
833: --end if;
834: close c_ytd_aaid;
835:
836: -- end if;
838: end if;
839:
840: end if;
841:
842: hr_utility.set_location(gv_package || lv_procedure_name, 60);
843:
844: ln_step := 3;
845: -- if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
846: open c_time_period(ln_ytd_balcall_aaid);
848: ld_run_date_earned,
849: ld_run_effective_date;
850: close c_time_period;
851:
852: hr_utility.set_location(gv_package || lv_procedure_name, 70);
853: -- end if;
854: open cur_get_base_lang;
855: fetch cur_get_base_lang into lv_base_lang;
856: close cur_get_base_lang;
873: pay_ac_action_arch.gv_person_lang := lv_person_lang;
874: /* Bug 3559626 */
875: pay_emp_action_arch.gv_correspondence_language := lv_person_lang;
876:
877: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);
878: hr_utility.trace('ln_ytd_balcall_aaid: '|| ln_ytd_balcall_aaid);
879:
880: -- if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
881: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
874: /* Bug 3559626 */
875: pay_emp_action_arch.gv_correspondence_language := lv_person_lang;
876:
877: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);
878: hr_utility.trace('ln_ytd_balcall_aaid: '|| ln_ytd_balcall_aaid);
879:
880: -- if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
881: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
882: ln_step := 5;
891: end if;
892:
893: gn_taxgrp_gre_id := ln_taxgrp_gre_id;
894:
895: hr_utility.trace('Reporting Level : '|| pay_ac_action_arch.gv_reporting_level);
896: hr_utility.trace('gv_taxgrp_gre_id : '|| gn_taxgrp_gre_id);
897:
898: ln_step := 7;
899: gv_jurisdiction_cd := get_context_val(
892:
893: gn_taxgrp_gre_id := ln_taxgrp_gre_id;
894:
895: hr_utility.trace('Reporting Level : '|| pay_ac_action_arch.gv_reporting_level);
896: hr_utility.trace('gv_taxgrp_gre_id : '|| gn_taxgrp_gre_id);
897:
898: ln_step := 7;
899: gv_jurisdiction_cd := get_context_val(
900: p_context_name => 'JURISDICTION_CODE'
900: p_context_name => 'JURISDICTION_CODE'
901: , p_assignment_id => p_assignment_id
902: , p_asg_act_id => ln_ytd_balcall_aaid);
903:
904: hr_utility.trace('gv_jurisdiction_cd : ' || gv_jurisdiction_cd);
905:
906: ln_step := 8;
907:
908: -- end if;
916: ,p_last_xfr_eff_date => ld_last_xfr_eff_date
917: ,p_last_xfr_action_id => ln_last_xfr_action_id
918: );
919:
920: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
921: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
922: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
923: hr_utility.trace('p_action_type = ' || p_action_type);
924: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
917: ,p_last_xfr_action_id => ln_last_xfr_action_id
918: );
919:
920: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
921: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
922: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
923: hr_utility.trace('p_action_type = ' || p_action_type);
924: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
925: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
918: );
919:
920: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
921: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
922: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
923: hr_utility.trace('p_action_type = ' || p_action_type);
924: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
925: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
926: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
919:
920: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
921: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
922: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
923: hr_utility.trace('p_action_type = ' || p_action_type);
924: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
925: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
926: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
927: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
920: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
921: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
922: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
923: hr_utility.trace('p_action_type = ' || p_action_type);
924: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
925: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
926: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
927: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
928: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
921: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
922: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
923: hr_utility.trace('p_action_type = ' || p_action_type);
924: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
925: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
926: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
927: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
928: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
929: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
922: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
923: hr_utility.trace('p_action_type = ' || p_action_type);
924: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
925: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
926: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
927: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
928: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
929: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
930: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
923: hr_utility.trace('p_action_type = ' || p_action_type);
924: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
925: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
926: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
927: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
928: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
929: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
930: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
931: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
924: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
925: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
926: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
927: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
928: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
929: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
930: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
931: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
932: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
925: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
926: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
927: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
928: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
929: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
930: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
931: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
932: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
933: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
926: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
927: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
928: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
929: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
930: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
931: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
932: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
933: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
934: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
927: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
928: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
929: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
930: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
931: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
932: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
933: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
934: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
935: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
928: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
929: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
930: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
931: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
932: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
933: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
934: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
935: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
936: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
929: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
930: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
931: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
932: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
933: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
934: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
935: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
936: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
937: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
930: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
931: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
932: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
933: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
934: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
935: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
936: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
937: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
938:
931: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
932: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
933: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
934: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
935: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
936: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
937: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
938:
939: ln_step := 9;
932: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
933: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
934: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
935: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
936: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
937: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
938:
939: ln_step := 9;
940: pay_ac_action_arch.initialization_process;
933: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
934: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
935: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
936: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
937: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
938:
939: ln_step := 9;
940: pay_ac_action_arch.initialization_process;
941:
962: ****************************************************/
963: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
964: end if;
965:
966: hr_utility.set_location(gv_package || lv_procedure_name, 90);
967:
968: /******************************************************************
969: ** For seperate check cases, the ld_last_xfr_eff_date is never null
970: ** as the master is always processed before the child actions. The
973: ******************************************************************/
974: ln_step := 12;
975: -- if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
976: if ld_last_xfr_eff_date is null then
977: hr_utility.set_location(gv_package || lv_procedure_name, 100);
978: ln_step := 13;
979: pay_ac_action_arch.first_time_process(
980: p_xfr_action_id => p_xfr_action_id
981: ,p_assignment_id => p_assignment_id
1059: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
1060: );
1061:
1062:
1063: hr_utility.set_location(gv_package || lv_procedure_name, 160);
1064:
1065: pay_emp_action_arch.insert_rows_thro_api_process(
1066: p_action_context_id => p_xfr_action_id
1067: ,p_action_context_type=> 'AAP'
1072: );
1073:
1074: EXCEPTION
1075: when others then
1076: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1077: lv_error_message := 'Error at step ' || ln_step ||
1078: ' in ' || gv_package || lv_procedure_name;
1079: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1080:
1075: when others then
1076: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1077: lv_error_message := 'Error at step ' || ln_step ||
1078: ' in ' || gv_package || lv_procedure_name;
1079: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1080:
1081: lv_error_message :=
1082: pay_emp_action_arch.set_error_message(lv_error_message);
1083:
1080:
1081: lv_error_message :=
1082: pay_emp_action_arch.set_error_message(lv_error_message);
1083:
1084: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1085: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1086: hr_utility.raise_error;
1087:
1088: END process_actions;
1081: lv_error_message :=
1082: pay_emp_action_arch.set_error_message(lv_error_message);
1083:
1084: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1085: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1086: hr_utility.raise_error;
1087:
1088: END process_actions;
1089:
1082: pay_emp_action_arch.set_error_message(lv_error_message);
1083:
1084: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1085: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1086: hr_utility.raise_error;
1087:
1088: END process_actions;
1089:
1090: /************************************************************
1206:
1207: BEGIN
1208:
1209: lv_procedure_name := '.create_child_act_for_taxgrp';
1210: hr_utility.set_location('Entering create_child_act_for_taxgrp ', 10 );
1211: hr_utility.trace('GRE p_master_prepay_action_id : ' ||
1212: p_master_prepay_action_id);
1213:
1214: /* Initialising local variables to avoid GSCC warnings */
1207: BEGIN
1208:
1209: lv_procedure_name := '.create_child_act_for_taxgrp';
1210: hr_utility.set_location('Entering create_child_act_for_taxgrp ', 10 );
1211: hr_utility.trace('GRE p_master_prepay_action_id : ' ||
1212: p_master_prepay_action_id);
1213:
1214: /* Initialising local variables to avoid GSCC warnings */
1215: ln_step := 1;
1252: /* Added this to archive Bal Adj's 'B' current amounts with
1253: pre-payments for Tax Group reporting. Bug#3498653 */
1254:
1255: if c_run_master_aa_id%found then
1256: hr_utility.trace('c_run_master_aa_id ran, ln_master_run_aa_id = '||to_char(ln_master_run_aa_id));
1257:
1258: if lv_run_action_type = 'B' then
1259: ln_master_run_aa_id := ln_prepay_asg_act_id;
1260: end if;
1261: end if;
1262: /* End of addition bug#3498653 */
1263: close c_run_master_aa_id;
1264:
1265: hr_utility.trace('TAXGRP ln_master_run_aa_id = ' ||
1266: ln_master_run_aa_id);
1267:
1268: ln_rqp_action_id := ln_prepay_asg_act_id;
1269: ln_ppp_source_action_id := NULL;
1296: ln_ppp_source_action_id := ln_source_action_id; -- Sep Chk
1297:
1298: end if;
1299:
1300: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1301: hr_utility.trace('TAXGRP ln_prepay_asg_act_id : '||ln_prepay_asg_act_id);
1302: hr_utility.trace('TAXGRP ln_assignment_id : ' || ln_assignment_id);
1303: hr_utility.trace('TAXGRP ln_source_action_id : ' || ln_source_action_id);
1304: hr_utility.trace('TAXGRP lv_seperate_check_flag : ' ||
1297:
1298: end if;
1299:
1300: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1301: hr_utility.trace('TAXGRP ln_prepay_asg_act_id : '||ln_prepay_asg_act_id);
1302: hr_utility.trace('TAXGRP ln_assignment_id : ' || ln_assignment_id);
1303: hr_utility.trace('TAXGRP ln_source_action_id : ' || ln_source_action_id);
1304: hr_utility.trace('TAXGRP lv_seperate_check_flag : ' ||
1305: lv_seperate_check_flag);
1298: end if;
1299:
1300: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1301: hr_utility.trace('TAXGRP ln_prepay_asg_act_id : '||ln_prepay_asg_act_id);
1302: hr_utility.trace('TAXGRP ln_assignment_id : ' || ln_assignment_id);
1303: hr_utility.trace('TAXGRP ln_source_action_id : ' || ln_source_action_id);
1304: hr_utility.trace('TAXGRP lv_seperate_check_flag : ' ||
1305: lv_seperate_check_flag);
1306:
1299:
1300: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1301: hr_utility.trace('TAXGRP ln_prepay_asg_act_id : '||ln_prepay_asg_act_id);
1302: hr_utility.trace('TAXGRP ln_assignment_id : ' || ln_assignment_id);
1303: hr_utility.trace('TAXGRP ln_source_action_id : ' || ln_source_action_id);
1304: hr_utility.trace('TAXGRP lv_seperate_check_flag : ' ||
1305: lv_seperate_check_flag);
1306:
1307: ln_step := 2;
1300: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1301: hr_utility.trace('TAXGRP ln_prepay_asg_act_id : '||ln_prepay_asg_act_id);
1302: hr_utility.trace('TAXGRP ln_assignment_id : ' || ln_assignment_id);
1303: hr_utility.trace('TAXGRP ln_source_action_id : ' || ln_source_action_id);
1304: hr_utility.trace('TAXGRP lv_seperate_check_flag : ' ||
1305: lv_seperate_check_flag);
1306:
1307: ln_step := 2;
1308:
1320: select pay_assignment_actions_s.nextval
1321: into ln_child_xfr_action_id
1322: from dual;
1323:
1324: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1325:
1326: -- insert into pay_assignment_actions.
1327:
1328: ln_step := 3;
1335: null,
1336: 'C',
1337: p_master_xfr_action_id);
1338:
1339: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1340:
1341: hr_utility.trace('GRE Locking Action = ' || ln_child_xfr_action_id);
1342: hr_utility.trace('GRE Locked Action = ' || ln_prepay_asg_act_id);
1343:
1337: p_master_xfr_action_id);
1338:
1339: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1340:
1341: hr_utility.trace('GRE Locking Action = ' || ln_child_xfr_action_id);
1342: hr_utility.trace('GRE Locked Action = ' || ln_prepay_asg_act_id);
1343:
1344: -- insert an interlock to this action
1345:
1338:
1339: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1340:
1341: hr_utility.trace('GRE Locking Action = ' || ln_child_xfr_action_id);
1342: hr_utility.trace('GRE Locked Action = ' || ln_prepay_asg_act_id);
1343:
1344: -- insert an interlock to this action
1345:
1346: ln_step := 4;
1361: update pay_assignment_actions
1362: set serial_number = lv_serial_number
1363: where assignment_action_id = ln_child_xfr_action_id;
1364:
1365: hr_utility.trace('Processing Child action for Master for Multi GRE ' ||
1366: p_master_xfr_action_id);
1367:
1368:
1369: end if;
1367:
1368:
1369: end if;
1370:
1371: hr_utility.trace('GRE ln_master_run_aa_id = ' ||
1372: ln_master_run_aa_id);
1373: hr_utility.trace('GRE B4 Calling Process Actions ln_prepay_asg_act_id : '
1374: || ln_prepay_asg_act_id);
1375:
1369: end if;
1370:
1371: hr_utility.trace('GRE ln_master_run_aa_id = ' ||
1372: ln_master_run_aa_id);
1373: hr_utility.trace('GRE B4 Calling Process Actions ln_prepay_asg_act_id : '
1374: || ln_prepay_asg_act_id);
1375:
1376: /****************************************************************
1377: ** Archive the data for the Child Action
1376: /****************************************************************
1377: ** Archive the data for the Child Action
1378: ****************************************************************/
1379:
1380: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1381: ln_step := 7;
1382:
1383: process_actions(p_xfr_payroll_action_id => p_xfr_payroll_action_id
1384: ,p_xfr_action_id => ln_child_xfr_action_id
1402: end loop; -- c_payment_info
1403:
1404: close c_payment_info;
1405:
1406: hr_utility.set_location('Leaving create_child_act_for_taxgrp ',60 );
1407:
1408: EXCEPTION
1409: when others then
1410: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1406: hr_utility.set_location('Leaving create_child_act_for_taxgrp ',60 );
1407:
1408: EXCEPTION
1409: when others then
1410: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1411: lv_error_message := 'Error at step ' || ln_step ||
1412: ' in ' || gv_package || lv_procedure_name;
1413: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1414:
1409: when others then
1410: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1411: lv_error_message := 'Error at step ' || ln_step ||
1412: ' in ' || gv_package || lv_procedure_name;
1413: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1414:
1415: lv_error_message :=
1416: pay_emp_action_arch.set_error_message(lv_error_message);
1417:
1414:
1415: lv_error_message :=
1416: pay_emp_action_arch.set_error_message(lv_error_message);
1417:
1418: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1419: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1420: hr_utility.raise_error;
1421:
1422:
1415: lv_error_message :=
1416: pay_emp_action_arch.set_error_message(lv_error_message);
1417:
1418: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1419: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1420: hr_utility.raise_error;
1421:
1422:
1423: END create_child_act_for_taxgrp;
1416: pay_emp_action_arch.set_error_message(lv_error_message);
1417:
1418: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1419: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1420: hr_utility.raise_error;
1421:
1422:
1423: END create_child_act_for_taxgrp;
1424:
1537:
1538:
1539: BEGIN
1540:
1541: -- hr_utility.trace_on (null, 'PYARCH');
1542: lv_procedure_name := '.create_child_actions_for_gre';
1543: hr_utility.set_location('Entering create_child_actions_for_gre ', 10 );
1544: hr_utility.trace('GRE p_master_prepay_action_id : ' ||
1545: p_master_prepay_action_id);
1539: BEGIN
1540:
1541: -- hr_utility.trace_on (null, 'PYARCH');
1542: lv_procedure_name := '.create_child_actions_for_gre';
1543: hr_utility.set_location('Entering create_child_actions_for_gre ', 10 );
1544: hr_utility.trace('GRE p_master_prepay_action_id : ' ||
1545: p_master_prepay_action_id);
1546:
1547: ln_step := 1;
1540:
1541: -- hr_utility.trace_on (null, 'PYARCH');
1542: lv_procedure_name := '.create_child_actions_for_gre';
1543: hr_utility.set_location('Entering create_child_actions_for_gre ', 10 );
1544: hr_utility.trace('GRE p_master_prepay_action_id : ' ||
1545: p_master_prepay_action_id);
1546:
1547: ln_step := 1;
1548: /* Initialising local variables to avoid GSCC warnings */
1627: ,ln_assignment_id
1628: ,ln_tax_unit_id);
1629: fetch c_run_aa_id into ln_run_aa_id
1630: ,ln_run_source_aa_id;
1631: hr_utility.trace('GRE ln_run_aa_id = ' || ln_run_aa_id);
1632: hr_utility.trace('GRE ln_run_source_aa_id = ' || ln_run_source_aa_id); /* Balance Adjustments source_action_id is null, even if we
1633: correct the c_run_aa_id cursor, it will pass the balance
1634: adjustment run asg_act_id for balance calls to archive.
1635: But ASG_PAYMENTS will not return any value with balance
1628: ,ln_tax_unit_id);
1629: fetch c_run_aa_id into ln_run_aa_id
1630: ,ln_run_source_aa_id;
1631: hr_utility.trace('GRE ln_run_aa_id = ' || ln_run_aa_id);
1632: hr_utility.trace('GRE ln_run_source_aa_id = ' || ln_run_source_aa_id); /* Balance Adjustments source_action_id is null, even if we
1633: correct the c_run_aa_id cursor, it will pass the balance
1634: adjustment run asg_act_id for balance calls to archive.
1635: But ASG_PAYMENTS will not return any value with balance
1636: adjustments run asg_act_id, we have to pass the balance
1640: will be assigned the ln_prepay_asg_act_id that is nothing
1641: but balance adjustment pre-payment asg_act_id. Bug#3498653 */
1642:
1643: if c_run_aa_id%NOTFOUND then
1644: hr_utility.trace('Procedure name: '||lv_procedure_name);
1645: hr_utility.trace('c_run_aa_id%NOT FOUND satisfied with action type B');
1646: ln_master_run_aa_id := ln_prepay_asg_act_id;
1647: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1648: else
1641: but balance adjustment pre-payment asg_act_id. Bug#3498653 */
1642:
1643: if c_run_aa_id%NOTFOUND then
1644: hr_utility.trace('Procedure name: '||lv_procedure_name);
1645: hr_utility.trace('c_run_aa_id%NOT FOUND satisfied with action type B');
1646: ln_master_run_aa_id := ln_prepay_asg_act_id;
1647: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1648: else
1649: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1643: if c_run_aa_id%NOTFOUND then
1644: hr_utility.trace('Procedure name: '||lv_procedure_name);
1645: hr_utility.trace('c_run_aa_id%NOT FOUND satisfied with action type B');
1646: ln_master_run_aa_id := ln_prepay_asg_act_id;
1647: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1648: else
1649: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1650: hr_utility.trace('Procedure name: '||lv_procedure_name);
1651: hr_utility.trace('gv_multi_gre_payment = N satisfied');
1646: ln_master_run_aa_id := ln_prepay_asg_act_id;
1647: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1648: else
1649: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1650: hr_utility.trace('Procedure name: '||lv_procedure_name);
1651: hr_utility.trace('gv_multi_gre_payment = N satisfied');
1652:
1653: ln_master_run_aa_id := ln_run_aa_id; -- Sub Master for Multi GRE
1654: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1647: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1648: else
1649: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1650: hr_utility.trace('Procedure name: '||lv_procedure_name);
1651: hr_utility.trace('gv_multi_gre_payment = N satisfied');
1652:
1653: ln_master_run_aa_id := ln_run_aa_id; -- Sub Master for Multi GRE
1654: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1655: else
1650: hr_utility.trace('Procedure name: '||lv_procedure_name);
1651: hr_utility.trace('gv_multi_gre_payment = N satisfied');
1652:
1653: ln_master_run_aa_id := ln_run_aa_id; -- Sub Master for Multi GRE
1654: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1655: else
1656: hr_utility.trace('gv_multi_gre_payment = N did not satisfied');
1657: ln_master_run_aa_id := ln_run_source_aa_id; -- Main Master
1658: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1652:
1653: ln_master_run_aa_id := ln_run_aa_id; -- Sub Master for Multi GRE
1654: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1655: else
1656: hr_utility.trace('gv_multi_gre_payment = N did not satisfied');
1657: ln_master_run_aa_id := ln_run_source_aa_id; -- Main Master
1658: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1659: end if;
1660: end if; -- c_run_aa_id%NOTFOUND
1654: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1655: else
1656: hr_utility.trace('gv_multi_gre_payment = N did not satisfied');
1657: ln_master_run_aa_id := ln_run_source_aa_id; -- Main Master
1658: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1659: end if;
1660: end if; -- c_run_aa_id%NOTFOUND
1661: close c_run_aa_id;
1662:
1660: end if; -- c_run_aa_id%NOTFOUND
1661: close c_run_aa_id;
1662:
1663: /* Old code before bug#3498653 fix
1664: hr_utility.trace('GRE ln_run_aa_id = ' || ln_run_aa_id);
1665: hr_utility.trace('GRE ln_run_source_aa_id = ' || ln_run_source_aa_id);
1666:
1667: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1668: ln_master_run_aa_id := ln_run_aa_id; -- Sub Master for Multi GRE
1661: close c_run_aa_id;
1662:
1663: /* Old code before bug#3498653 fix
1664: hr_utility.trace('GRE ln_run_aa_id = ' || ln_run_aa_id);
1665: hr_utility.trace('GRE ln_run_source_aa_id = ' || ln_run_source_aa_id);
1666:
1667: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1668: ln_master_run_aa_id := ln_run_aa_id; -- Sub Master for Multi GRE
1669: else
1759: lv_archive_balance_info := 'Y';
1760: end if;
1761: /* Bug 3960157 */
1762:
1763: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1764: hr_utility.trace('GRE ln_prepay_asg_act_id : ' || ln_prepay_asg_act_id);
1765: hr_utility.trace('GRE ln_tax_unit_id : ' || ln_tax_unit_id);
1766: hr_utility.trace('GRE ln_assignment_id : ' || ln_assignment_id);
1767: hr_utility.trace('GRE ln_source_action_id : ' || ln_source_action_id);
1760: end if;
1761: /* Bug 3960157 */
1762:
1763: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1764: hr_utility.trace('GRE ln_prepay_asg_act_id : ' || ln_prepay_asg_act_id);
1765: hr_utility.trace('GRE ln_tax_unit_id : ' || ln_tax_unit_id);
1766: hr_utility.trace('GRE ln_assignment_id : ' || ln_assignment_id);
1767: hr_utility.trace('GRE ln_source_action_id : ' || ln_source_action_id);
1768: hr_utility.trace('GRE lv_seperate_check_flag : ' ||
1761: /* Bug 3960157 */
1762:
1763: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1764: hr_utility.trace('GRE ln_prepay_asg_act_id : ' || ln_prepay_asg_act_id);
1765: hr_utility.trace('GRE ln_tax_unit_id : ' || ln_tax_unit_id);
1766: hr_utility.trace('GRE ln_assignment_id : ' || ln_assignment_id);
1767: hr_utility.trace('GRE ln_source_action_id : ' || ln_source_action_id);
1768: hr_utility.trace('GRE lv_seperate_check_flag : ' ||
1769: lv_seperate_check_flag);
1762:
1763: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1764: hr_utility.trace('GRE ln_prepay_asg_act_id : ' || ln_prepay_asg_act_id);
1765: hr_utility.trace('GRE ln_tax_unit_id : ' || ln_tax_unit_id);
1766: hr_utility.trace('GRE ln_assignment_id : ' || ln_assignment_id);
1767: hr_utility.trace('GRE ln_source_action_id : ' || ln_source_action_id);
1768: hr_utility.trace('GRE lv_seperate_check_flag : ' ||
1769: lv_seperate_check_flag);
1770:
1763: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1764: hr_utility.trace('GRE ln_prepay_asg_act_id : ' || ln_prepay_asg_act_id);
1765: hr_utility.trace('GRE ln_tax_unit_id : ' || ln_tax_unit_id);
1766: hr_utility.trace('GRE ln_assignment_id : ' || ln_assignment_id);
1767: hr_utility.trace('GRE ln_source_action_id : ' || ln_source_action_id);
1768: hr_utility.trace('GRE lv_seperate_check_flag : ' ||
1769: lv_seperate_check_flag);
1770:
1771: ln_step := 2;
1764: hr_utility.trace('GRE ln_prepay_asg_act_id : ' || ln_prepay_asg_act_id);
1765: hr_utility.trace('GRE ln_tax_unit_id : ' || ln_tax_unit_id);
1766: hr_utility.trace('GRE ln_assignment_id : ' || ln_assignment_id);
1767: hr_utility.trace('GRE ln_source_action_id : ' || ln_source_action_id);
1768: hr_utility.trace('GRE lv_seperate_check_flag : ' ||
1769: lv_seperate_check_flag);
1770:
1771: ln_step := 2;
1772:
1787: select pay_assignment_actions_s.nextval
1788: into ln_child_xfr_action_id
1789: from dual;
1790:
1791: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1792:
1793: -- insert into pay_assignment_actions.
1794:
1795: ln_step := 3;
1802: null,
1803: 'C',
1804: p_master_xfr_action_id);
1805:
1806: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1807:
1808: hr_utility.trace('GRE Locking Action = ' || ln_child_xfr_action_id);
1809: hr_utility.trace('GRE Locked Action = ' || ln_prepay_asg_act_id);
1810:
1804: p_master_xfr_action_id);
1805:
1806: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1807:
1808: hr_utility.trace('GRE Locking Action = ' || ln_child_xfr_action_id);
1809: hr_utility.trace('GRE Locked Action = ' || ln_prepay_asg_act_id);
1810:
1811: -- insert an interlock to this action
1812:
1805:
1806: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1807:
1808: hr_utility.trace('GRE Locking Action = ' || ln_child_xfr_action_id);
1809: hr_utility.trace('GRE Locked Action = ' || ln_prepay_asg_act_id);
1810:
1811: -- insert an interlock to this action
1812:
1813: ln_step := 4;
1828: update pay_assignment_actions
1829: set serial_number = lv_serial_number
1830: where assignment_action_id = ln_child_xfr_action_id;
1831:
1832: hr_utility.trace('Processing Child action for Master for Multi GRE ' ||
1833: p_master_xfr_action_id);
1834:
1835:
1836: end if;
1834:
1835:
1836: end if;
1837:
1838: hr_utility.trace('GRE ln_master_run_aa_id = ' ||
1839: ln_master_run_aa_id);
1840: hr_utility.trace('GRE B4 Calling Process Actions ln_prepay_asg_act_id : '
1841: || ln_prepay_asg_act_id);
1842:
1836: end if;
1837:
1838: hr_utility.trace('GRE ln_master_run_aa_id = ' ||
1839: ln_master_run_aa_id);
1840: hr_utility.trace('GRE B4 Calling Process Actions ln_prepay_asg_act_id : '
1841: || ln_prepay_asg_act_id);
1842:
1843: /****************************************************************
1844: ** Archive the data for the Child Action
1843: /****************************************************************
1844: ** Archive the data for the Child Action
1845: ****************************************************************/
1846:
1847: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1848: ln_step := 7;
1849: end if;
1850:
1851:
1879: end loop; -- c_payment_info
1880:
1881: close c_payment_info;
1882:
1883: hr_utility.set_location('Leaving create_child_actions_for_gre ',60 );
1884:
1885: EXCEPTION
1886: when others then
1887: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1883: hr_utility.set_location('Leaving create_child_actions_for_gre ',60 );
1884:
1885: EXCEPTION
1886: when others then
1887: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1888: lv_error_message := 'Error at step ' || ln_step ||
1889: ' in ' || gv_package || lv_procedure_name;
1890: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1891:
1886: when others then
1887: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1888: lv_error_message := 'Error at step ' || ln_step ||
1889: ' in ' || gv_package || lv_procedure_name;
1890: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1891:
1892: lv_error_message :=
1893: pay_emp_action_arch.set_error_message(lv_error_message);
1894:
1891:
1892: lv_error_message :=
1893: pay_emp_action_arch.set_error_message(lv_error_message);
1894:
1895: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1896: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1897: hr_utility.raise_error;
1898:
1899:
1892: lv_error_message :=
1893: pay_emp_action_arch.set_error_message(lv_error_message);
1894:
1895: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1896: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1897: hr_utility.raise_error;
1898:
1899:
1900: END create_child_actions_for_gre;
1893: pay_emp_action_arch.set_error_message(lv_error_message);
1894:
1895: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1896: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1897: hr_utility.raise_error;
1898:
1899:
1900: END create_child_actions_for_gre;
1901:
1993:
1994: BEGIN
1995:
1996: lv_procedure_name := '.create_chld_act_for_multi_gre';
1997: hr_utility.set_location('Entering create_chld_act_for_multi_gre ', 10 );
1998: hr_utility.trace('MG p_master_prepay_action_id : ' ||
1999: p_master_prepay_action_id);
2000:
2001: ln_step := 1;
1994: BEGIN
1995:
1996: lv_procedure_name := '.create_chld_act_for_multi_gre';
1997: hr_utility.set_location('Entering create_chld_act_for_multi_gre ', 10 );
1998: hr_utility.trace('MG p_master_prepay_action_id : ' ||
1999: p_master_prepay_action_id);
2000:
2001: ln_step := 1;
2002: ln_child_aa_count := 0;
2026:
2027: ln_child_aa_count := ln_child_aa_count + 1;
2028:
2029: ln_step := 2;
2030: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2031:
2032: if ln_tax_unit_id is null then
2033: open c_tax_unit(ln_pp_asg_act_id);
2034: fetch c_tax_unit into ln_tax_unit_id;
2034: fetch c_tax_unit into ln_tax_unit_id;
2035: close c_tax_unit;
2036: end if;
2037:
2038: hr_utility.trace('MG ln_pp_asg_act_id : ' || ln_pp_asg_act_id);
2039: hr_utility.trace('MG ln_tax_unit_id : ' || ln_tax_unit_id);
2040:
2041: select pay_assignment_actions_s.nextval
2042: into ln_child_xfr_action_id
2035: close c_tax_unit;
2036: end if;
2037:
2038: hr_utility.trace('MG ln_pp_asg_act_id : ' || ln_pp_asg_act_id);
2039: hr_utility.trace('MG ln_tax_unit_id : ' || ln_tax_unit_id);
2040:
2041: select pay_assignment_actions_s.nextval
2042: into ln_child_xfr_action_id
2043: from dual;
2041: select pay_assignment_actions_s.nextval
2042: into ln_child_xfr_action_id
2043: from dual;
2044:
2045: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2046:
2047: -- insert into pay_assignment_actions.
2048:
2049: ln_step := 3;
2056: null,
2057: 'C',
2058: p_master_xfr_action_id);
2059:
2060: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2061:
2062: hr_utility.trace('MG Locking Action = ' || ln_child_xfr_action_id);
2063: hr_utility.trace('MG Locked Action = ' || ln_pp_asg_act_id);
2064:
2058: p_master_xfr_action_id);
2059:
2060: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2061:
2062: hr_utility.trace('MG Locking Action = ' || ln_child_xfr_action_id);
2063: hr_utility.trace('MG Locked Action = ' || ln_pp_asg_act_id);
2064:
2065: -- insert an interlock to this action
2066:
2059:
2060: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2061:
2062: hr_utility.trace('MG Locking Action = ' || ln_child_xfr_action_id);
2063: hr_utility.trace('MG Locked Action = ' || ln_pp_asg_act_id);
2064:
2065: -- insert an interlock to this action
2066:
2067: ln_step := 4;
2076: update pay_assignment_actions
2077: set serial_number = lv_serial_number
2078: where assignment_action_id = ln_child_xfr_action_id;
2079:
2080: hr_utility.trace('Processing Child action for Master for Multi GRE ' ||
2081: p_master_xfr_action_id);
2082:
2083: ln_step := 6;
2084:
2086: fetch c_run_aa_id into ln_run_aa_id
2087: ,ln_source_aa_id;
2088: close c_run_aa_id;
2089:
2090: hr_utility.trace('MG ln_run_aa_id = ' || ln_run_aa_id);
2091: hr_utility.trace('MG ln_source_aa_id = ' || ln_source_aa_id);
2092:
2093: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
2094: ln_master_run_aa_id := ln_run_aa_id;
2087: ,ln_source_aa_id;
2088: close c_run_aa_id;
2089:
2090: hr_utility.trace('MG ln_run_aa_id = ' || ln_run_aa_id);
2091: hr_utility.trace('MG ln_source_aa_id = ' || ln_source_aa_id);
2092:
2093: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
2094: ln_master_run_aa_id := ln_run_aa_id;
2095: else
2099: --ln_sub_master_run_aa_id := ln_run_aa_id;
2100:
2101: --ln_master_run_aa_id := ln_pp_asg_act_id;
2102:
2103: hr_utility.trace('MG ln_master_run_aa_id = ' ||
2104: ln_master_run_aa_id);
2105:
2106: /****************************************************************
2107: ** Archive the data for the Child Action
2106: /****************************************************************
2107: ** Archive the data for the Child Action
2108: ****************************************************************/
2109:
2110: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2111: ln_step := 7;
2112:
2113: process_actions(p_xfr_payroll_action_id => p_xfr_payroll_action_id
2114: ,p_xfr_action_id => ln_child_xfr_action_id
2129: end loop;
2130:
2131: close c_prepay_act;
2132:
2133: hr_utility.set_location('Leaving create_chld_act_for_multi_gre ',60 );
2134:
2135: EXCEPTION
2136: when others then
2137: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2133: hr_utility.set_location('Leaving create_chld_act_for_multi_gre ',60 );
2134:
2135: EXCEPTION
2136: when others then
2137: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2138: lv_error_message := 'Error at step ' || ln_step ||
2139: ' in ' || gv_package || lv_procedure_name;
2140: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2141:
2136: when others then
2137: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2138: lv_error_message := 'Error at step ' || ln_step ||
2139: ' in ' || gv_package || lv_procedure_name;
2140: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2141:
2142: lv_error_message :=
2143: pay_emp_action_arch.set_error_message(lv_error_message);
2144:
2141:
2142: lv_error_message :=
2143: pay_emp_action_arch.set_error_message(lv_error_message);
2144:
2145: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2146: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2147: hr_utility.raise_error;
2148:
2149: END create_chld_act_for_multi_gre;
2142: lv_error_message :=
2143: pay_emp_action_arch.set_error_message(lv_error_message);
2144:
2145: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2146: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2147: hr_utility.raise_error;
2148:
2149: END create_chld_act_for_multi_gre;
2150:
2143: pay_emp_action_arch.set_error_message(lv_error_message);
2144:
2145: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2146: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2147: hr_utility.raise_error;
2148:
2149: END create_chld_act_for_multi_gre;
2150:
2151: /************************************************************
2262: ln_step NUMBER;
2263:
2264: BEGIN
2265: lv_procedure_name := '.create_child_actions';
2266: hr_utility.set_location('Entering create_child_actions ', 10 );
2267:
2268: ln_step := 1;
2269: -- Initialising local variables to avoid GSCC warnings
2270: ln_assignment_id := 0;
2276: ,p_end_date => ld_end_date
2277: ,p_business_group_id => ln_business_group_id
2278: ,p_cons_set_id => ln_cons_set_id
2279: ,p_payroll_id => ln_payroll_id);
2280: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2281:
2282: ln_step := 2;
2283: pay_emp_action_arch.gv_multi_payroll_pymt
2284: := pay_emp_action_arch.get_multi_assignment_flag(
2284: := pay_emp_action_arch.get_multi_assignment_flag(
2285: p_payroll_id => ln_payroll_id
2286: ,p_effective_date => ld_end_date);
2287:
2288: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2289: pay_emp_action_arch.gv_multi_payroll_pymt);
2290: ln_step := 3;
2291: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2292: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2291: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2292: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2293: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2294:
2295: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2296: hr_utility.trace('ln_master_prepay_action_id ' ||
2297: p_master_prepay_action_id);
2298: ln_step := 4;
2299: open c_asg_child_action(p_master_prepay_action_id
2292: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2293: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2294:
2295: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2296: hr_utility.trace('ln_master_prepay_action_id ' ||
2297: p_master_prepay_action_id);
2298: ln_step := 4;
2299: open c_asg_child_action(p_master_prepay_action_id
2300: ,p_curr_pymt_eff_date);
2298: ln_step := 4;
2299: open c_asg_child_action(p_master_prepay_action_id
2300: ,p_curr_pymt_eff_date);
2301: else
2302: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2303: ln_step := 5;
2304: open c_multi_asg_child_action(
2305: p_master_prepay_action_id
2306: ,ln_cons_set_id
2309: ,ld_start_date
2310: ,ld_end_date
2311: ,p_curr_pymt_eff_date);
2312: end if;
2313: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2314:
2315: ln_step := 6;
2316: loop
2317: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2317: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2318: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2319: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2320:
2321: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2322: ln_step := 7;
2323: fetch c_asg_child_action into ln_assignment_id,
2324: ln_tax_unit_id,
2325: ln_asg_action_id,
2326: ln_run_action_id;
2327: exit when c_asg_child_action%notfound;
2328: else
2329: ln_step := 8;
2330: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2331: fetch c_multi_asg_child_action into ln_assignment_id,
2332: ln_tax_unit_id,
2333: ln_asg_action_id,
2334: ln_run_action_id;
2333: ln_asg_action_id,
2334: ln_run_action_id;
2335: exit when c_multi_asg_child_action%notfound;
2336: end if;
2337: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2338:
2339: if ln_tax_unit_id is null then
2340: ln_step := 81;
2341: open c_tax_unit(ln_run_action_id);
2348: select pay_assignment_actions_s.nextval
2349: into ln_child_xfr_action_id
2350: from dual;
2351:
2352: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2353: -- insert into pay_assignment_actions.
2354: ln_step := 10;
2355: hr_nonrun_asact.insact(ln_child_xfr_action_id,
2356: ln_assignment_id,
2359: ln_tax_unit_id,
2360: null,
2361: 'C',
2362: p_master_xfr_action_id);
2363: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2364: hr_utility.trace('Locking Action = ' || ln_child_xfr_action_id);
2365: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2366: -- insert an interlock to this action
2367: ln_step := 11;
2360: null,
2361: 'C',
2362: p_master_xfr_action_id);
2363: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2364: hr_utility.trace('Locking Action = ' || ln_child_xfr_action_id);
2365: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2366: -- insert an interlock to this action
2367: ln_step := 11;
2368: hr_nonrun_asact.insint(ln_child_xfr_action_id,
2361: 'C',
2362: p_master_xfr_action_id);
2363: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2364: hr_utility.trace('Locking Action = ' || ln_child_xfr_action_id);
2365: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2366: -- insert an interlock to this action
2367: ln_step := 11;
2368: hr_nonrun_asact.insint(ln_child_xfr_action_id,
2369: ln_asg_action_id);
2367: ln_step := 11;
2368: hr_nonrun_asact.insint(ln_child_xfr_action_id,
2369: ln_asg_action_id);
2370:
2371: hr_utility.set_location(gv_package || lv_procedure_name, 110);
2372: -- if pay_ac_action_arch.gv_multi_asg_enabled = 'Y' then
2373: -- open c_pre_pay_run_action (ln_asg_action_id, p_sepchk_run_type_id);
2374: -- fetch c_pre_pay_run_action into ln_run_action_id;
2375: -- close c_pre_pay_run_action;
2381: update pay_assignment_actions
2382: set serial_number = lv_serial_number
2383: where assignment_action_id = ln_child_xfr_action_id;
2384:
2385: hr_utility.trace('Processing Child action for Master ' ||
2386: p_master_xfr_action_id);
2387:
2388: /****************************************************************
2389: ** Archive the data for the Child Action
2406: ,p_ppp_source_action_id => ln_run_action_id
2407: );
2408:
2409: end loop;
2410: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2411:
2412: ln_step := 14;
2413: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2414: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2416: close c_asg_child_action;
2417: else
2418: close c_multi_asg_child_action;
2419: end if;
2420: hr_utility.set_location('Leaving create_child_actions ',130 );
2421:
2422: EXCEPTION
2423: when others then
2424: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2420: hr_utility.set_location('Leaving create_child_actions ',130 );
2421:
2422: EXCEPTION
2423: when others then
2424: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2425: lv_error_message := 'Error at step ' || ln_step ||
2426: ' in ' || gv_package || lv_procedure_name;
2427: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2428:
2423: when others then
2424: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2425: lv_error_message := 'Error at step ' || ln_step ||
2426: ' in ' || gv_package || lv_procedure_name;
2427: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2428:
2429: lv_error_message :=
2430: pay_emp_action_arch.set_error_message(lv_error_message);
2431:
2428:
2429: lv_error_message :=
2430: pay_emp_action_arch.set_error_message(lv_error_message);
2431:
2432: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2433: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2434: hr_utility.raise_error;
2435:
2436: END create_child_actions;
2429: lv_error_message :=
2430: pay_emp_action_arch.set_error_message(lv_error_message);
2431:
2432: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2433: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2434: hr_utility.raise_error;
2435:
2436: END create_child_actions;
2437:
2430: pay_emp_action_arch.set_error_message(lv_error_message);
2431:
2432: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2433: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2434: hr_utility.raise_error;
2435:
2436: END create_child_actions;
2437:
2438: /************************************************************
2580: BEGIN
2581:
2582: lv_procedure_name := '.action_archive_data';
2583: pay_emp_action_arch.gv_error_message := NULL;
2584: hr_utility.trace('Entered py_archive_data');
2585: hr_utility.trace('p_xfr_action_id '||to_char(p_xfr_action_id));
2586: hr_utility.trace('Cursor c_xfr_info');
2587:
2588: ln_step := 1;
2581:
2582: lv_procedure_name := '.action_archive_data';
2583: pay_emp_action_arch.gv_error_message := NULL;
2584: hr_utility.trace('Entered py_archive_data');
2585: hr_utility.trace('p_xfr_action_id '||to_char(p_xfr_action_id));
2586: hr_utility.trace('Cursor c_xfr_info');
2587:
2588: ln_step := 1;
2589: open c_xfr_info (p_xfr_action_id);
2582: lv_procedure_name := '.action_archive_data';
2583: pay_emp_action_arch.gv_error_message := NULL;
2584: hr_utility.trace('Entered py_archive_data');
2585: hr_utility.trace('p_xfr_action_id '||to_char(p_xfr_action_id));
2586: hr_utility.trace('Cursor c_xfr_info');
2587:
2588: ln_step := 1;
2589: open c_xfr_info (p_xfr_action_id);
2590: fetch c_xfr_info into ln_xfr_payroll_action_id,
2608: := pay_emp_action_arch.get_multi_assignment_flag(
2609: p_payroll_id => ln_payroll_id
2610: ,p_effective_date => ld_end_date);
2611:
2612: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
2613: pay_emp_action_arch.gv_multi_payroll_pymt);
2614:
2615: ln_step := 3;
2616: open c_legislation (ln_business_group_id);
2615: ln_step := 3;
2616: open c_legislation (ln_business_group_id);
2617: fetch c_legislation into lv_legislation_code ;
2618: if c_legislation%notfound then
2619: hr_utility.trace('Business Group for Interface Process Not Found');
2620: hr_utility.raise_error;
2621: end if;
2622: close c_legislation;
2623: hr_utility.trace('lv_legislation_code '||lv_legislation_code);
2616: open c_legislation (ln_business_group_id);
2617: fetch c_legislation into lv_legislation_code ;
2618: if c_legislation%notfound then
2619: hr_utility.trace('Business Group for Interface Process Not Found');
2620: hr_utility.raise_error;
2621: end if;
2622: close c_legislation;
2623: hr_utility.trace('lv_legislation_code '||lv_legislation_code);
2624:
2619: hr_utility.trace('Business Group for Interface Process Not Found');
2620: hr_utility.raise_error;
2621: end if;
2622: close c_legislation;
2623: hr_utility.trace('lv_legislation_code '||lv_legislation_code);
2624:
2625: ln_step := 4;
2626: open c_sepchk_run_type;
2627: fetch c_sepchk_run_type into ln_sepchk_run_type_id;
2625: ln_step := 4;
2626: open c_sepchk_run_type;
2627: fetch c_sepchk_run_type into ln_sepchk_run_type_id;
2628: if c_sepchk_run_type%notfound then
2629: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2630: hr_utility.raise_error;
2631: end if;
2632: close c_sepchk_run_type;
2633:
2626: open c_sepchk_run_type;
2627: fetch c_sepchk_run_type into ln_sepchk_run_type_id;
2628: if c_sepchk_run_type%notfound then
2629: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2630: hr_utility.raise_error;
2631: end if;
2632: close c_sepchk_run_type;
2633:
2634: ln_step := 5;
2642: ln_step := 6;
2643: open c_pymt_eff_date(ln_asg_action_id);
2644: fetch c_pymt_eff_date into ld_curr_pymt_eff_date;
2645: if c_pymt_eff_date%notfound then
2646: hr_utility.trace('PayrollAction for InterfaceProcess NotFound');
2647: hr_utility.raise_error;
2648: end if;
2649: close c_pymt_eff_date;
2650:
2643: open c_pymt_eff_date(ln_asg_action_id);
2644: fetch c_pymt_eff_date into ld_curr_pymt_eff_date;
2645: if c_pymt_eff_date%notfound then
2646: hr_utility.trace('PayrollAction for InterfaceProcess NotFound');
2647: hr_utility.raise_error;
2648: end if;
2649: close c_pymt_eff_date;
2650:
2651: ln_step := 7;
2648: end if;
2649: close c_pymt_eff_date;
2650:
2651: ln_step := 7;
2652: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));
2653: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));
2654: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));
2655: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);
2656: hr_utility.trace('ln_xfr_payroll_action_id ='||
2649: close c_pymt_eff_date;
2650:
2651: ln_step := 7;
2652: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));
2653: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));
2654: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));
2655: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);
2656: hr_utility.trace('ln_xfr_payroll_action_id ='||
2657: to_char(ln_xfr_payroll_action_id));
2650:
2651: ln_step := 7;
2652: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));
2653: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));
2654: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));
2655: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);
2656: hr_utility.trace('ln_xfr_payroll_action_id ='||
2657: to_char(ln_xfr_payroll_action_id));
2658:
2651: ln_step := 7;
2652: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));
2653: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));
2654: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));
2655: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);
2656: hr_utility.trace('ln_xfr_payroll_action_id ='||
2657: to_char(ln_xfr_payroll_action_id));
2658:
2659: if lv_master_action_type in ( 'P','U') then
2652: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));
2653: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));
2654: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));
2655: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);
2656: hr_utility.trace('ln_xfr_payroll_action_id ='||
2657: to_char(ln_xfr_payroll_action_id));
2658:
2659: if lv_master_action_type in ( 'P','U') then
2660: /************************************************************
2663: *************************************************************/
2664: lv_run_action_type := Null;
2665: open c_master_run_action_type(ln_asg_action_id,ln_assignment_id);
2666: fetch c_master_run_action_type into lv_run_action_type;
2667: hr_utility.trace('lv_run_action_type ='||lv_run_action_type);
2668:
2669: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
2670: /* Added this validation to avoid creating child assignment actions,
2671: when reversals to be picked up based on Pre-payments. Reversals
2687: ,p_xfr_end_date => ld_end_date
2688: ,p_chunk => ln_chunk_number
2689: );
2690: else
2691: hr_utility.trace('Dont create child actions for Reversals: '||
2692: 'py_archive_date Tax Gruop level');
2693: null;
2694:
2695: end if; -- c_master_run_action_type%found
2714: ,p_xfr_end_date => ld_end_date
2715: ,p_chunk => ln_chunk_number
2716: );
2717: else
2718: hr_utility.trace('Dont create child actions for Reversals: '||
2719: 'py_archive_date GRE level');
2720: null;
2721: end if; -- c_master_run_action_type%found
2722: close c_master_run_action_type;
2762: -- fetch c_master_run_action into ln_master_run_action_id,
2763: -- ln_master_run_pact_id,
2764: -- lv_master_run_action_type;
2765: -- if c_master_run_action%notfound then
2766: -- hr_utility.raise_error;
2767: -- end if;
2768: -- close c_master_run_action;
2769: --
2770: -- ln_step := 10;
2817: ln_step := 13;
2818: if lv_master_action_type = 'V' then
2819: /* ln_asg_action_id is nothing but reversal run action id */
2820: ln_pymt_balcall_aaid := ln_asg_action_id ;
2821: hr_utility.trace('Reversal ln_pymt_balcall_aaid'
2822: ||to_char(ln_pymt_balcall_aaid));
2823: /* Added this code to archive the tax balances and other elements
2824: for reversals in Canada. Bug#3498653 */
2825: ln_step := 14;
2824: for reversals in Canada. Bug#3498653 */
2825: ln_step := 14;
2826: pay_ac_action_arch.initialization_process;
2827:
2828: hr_utility.trace('Populating Tax Balances for Reversals');
2829: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
2830: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
2831: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
2832: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
2825: ln_step := 14;
2826: pay_ac_action_arch.initialization_process;
2827:
2828: hr_utility.trace('Populating Tax Balances for Reversals');
2829: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
2830: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
2831: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
2832: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
2833:
2826: pay_ac_action_arch.initialization_process;
2827:
2828: hr_utility.trace('Populating Tax Balances for Reversals');
2829: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
2830: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
2831: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
2832: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
2833:
2834: /* Added this to support tax group level reporting for
2827:
2828: hr_utility.trace('Populating Tax Balances for Reversals');
2829: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
2830: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
2831: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
2832: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
2833:
2834: /* Added this to support tax group level reporting for
2835: Reversals. Need to set both contexts for
2828: hr_utility.trace('Populating Tax Balances for Reversals');
2829: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
2830: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
2831: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
2832: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
2833:
2834: /* Added this to support tax group level reporting for
2835: Reversals. Need to set both contexts for
2836: Tax Group reporting because for current amounts we
2881: ,p_ytd_balcall_aaid => ln_pymt_balcall_aaid
2882: );
2883:
2884: ln_step := 16;
2885: hr_utility.trace('Populating Current Elements for Reversals');
2886: pay_ac_action_arch.get_current_elements(
2887: p_xfr_action_id => p_xfr_action_id
2888: ,p_curr_pymt_action_id => ln_pymt_balcall_aaid
2889: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
2895: ,p_sepchk_flag => lv_master_sepcheck_flag
2896: ,p_legislation_code => lv_legislation_code
2897: ,p_action_type => lv_master_action_type);
2898:
2899: hr_utility.trace('Done Populating Tax Balances for Reversals');
2900: ln_step := 17;
2901: pay_emp_action_arch.insert_rows_thro_api_process(
2902: p_action_context_id => p_xfr_action_id
2903: ,p_action_context_type=> 'AAP'
2914: Payslip Archiver, this will be useful for historical reporting
2915: purposes when run_results table is purged. Bug#3498653 */
2916:
2917: if lv_master_action_type = 'B' then
2918: hr_utility.trace('Populating Current Elements for Balance Adjustments');
2919: /* ln_asg_action_id is nothing but Balance Adjustment run action id */
2920: ln_asg_action_id := -1;
2921: pay_ac_action_arch.initialization_process;
2922: open c_get_emp_adjbal(p_xfr_action_id);
2924: fetch c_get_emp_adjbal into ln_asg_action_id;
2925: exit when c_get_emp_adjbal%NOTFOUND;
2926:
2927: ln_pymt_balcall_aaid := ln_asg_action_id ;
2928: hr_utility.trace('Bal Adjustment ln_pymt_balcall_aaid'
2929: ||to_char(ln_pymt_balcall_aaid));
2930:
2931: ln_step := 18;
2932:
2929: ||to_char(ln_pymt_balcall_aaid));
2930:
2931: ln_step := 18;
2932:
2933: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
2934: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
2935: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
2936: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
2937:
2930:
2931: ln_step := 18;
2932:
2933: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
2934: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
2935: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
2936: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
2937:
2938: /* Added this to support tax group level reporting for
2931: ln_step := 18;
2932:
2933: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
2934: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
2935: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
2936: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
2937:
2938: /* Added this to support tax group level reporting for
2939: Balance Adjustments. Need to set both contexts for
2932:
2933: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
2934: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
2935: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
2936: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
2937:
2938: /* Added this to support tax group level reporting for
2939: Balance Adjustments. Need to set both contexts for
2940: Tax Group reporting because for current amounts we
3016: ** chunk number is 1. Also check if this has not been archived
3017: ** earlier
3018: *****************************************************************/
3019: ln_step := 21;
3020: hr_utility.set_location(gv_package || lv_procedure_name,210);
3021: open c_check_pay_action( ln_xfr_payroll_action_id);
3022: fetch c_check_pay_action into ln_pay_action_count;
3023: close c_check_pay_action;
3024: if ln_pay_action_count = 0 then
3021: open c_check_pay_action( ln_xfr_payroll_action_id);
3022: fetch c_check_pay_action into ln_pay_action_count;
3023: close c_check_pay_action;
3024: if ln_pay_action_count = 0 then
3025: hr_utility.set_location(gv_package || lv_procedure_name,215);
3026: ln_step := 22;
3027: if ln_chunk_number = 1 then
3028: pay_emp_action_arch.arch_pay_action_level_data(
3029: p_payroll_action_id => ln_xfr_payroll_action_id
3035: end if;
3036:
3037: EXCEPTION
3038: when others then
3039: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3040: lv_error_message := 'Error at step ' || ln_step ||
3041: ' in ' || gv_package || lv_procedure_name;
3042: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3043:
3038: when others then
3039: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3040: lv_error_message := 'Error at step ' || ln_step ||
3041: ' in ' || gv_package || lv_procedure_name;
3042: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3043:
3044: lv_error_message :=
3045: pay_emp_action_arch.set_error_message(lv_error_message);
3046:
3043:
3044: lv_error_message :=
3045: pay_emp_action_arch.set_error_message(lv_error_message);
3046:
3047: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3048: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3049: hr_utility.raise_error;
3050:
3051: END py_archive_data;
3044: lv_error_message :=
3045: pay_emp_action_arch.set_error_message(lv_error_message);
3046:
3047: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3048: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3049: hr_utility.raise_error;
3050:
3051: END py_archive_data;
3052:
3045: pay_emp_action_arch.set_error_message(lv_error_message);
3046:
3047: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3048: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3049: hr_utility.raise_error;
3050:
3051: END py_archive_data;
3052:
3053: /******************************************************************
3075:
3076: begin
3077:
3078: lv_procedure_name := '.py_range_cursor';
3079: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3080: pay_emp_action_arch.gv_error_message := NULL;
3081:
3082: ln_step := 1;
3083: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
3085: ,p_end_date => ld_end_date
3086: ,p_business_group_id => ln_business_group_id
3087: ,p_cons_set_id => ln_cons_set_id
3088: ,p_payroll_id => ln_payroll_id);
3089: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3090:
3091: ln_step := 2;
3092: /* removed the reversal validation from range cursor SQL STMT
3093: ''V'', nvl(ppa.future_process_mode, ''Y''). Bug#3498653 */
3122: and ppa1.report_type = ''PY_ARCHIVER'')
3123: and :payroll_action_id > 0
3124: order by paa.assignment_id';
3125:
3126: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3127: ln_step := 3;
3128: p_sqlstr := lv_sql_string;
3129: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3130:
3125:
3126: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3127: ln_step := 3;
3128: p_sqlstr := lv_sql_string;
3129: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3130:
3131: EXCEPTION
3132: when others then
3133: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3129: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3130:
3131: EXCEPTION
3132: when others then
3133: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3134: lv_error_message := 'Error at step ' || ln_step ||
3135: ' in ' || gv_package || lv_procedure_name;
3136: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3137:
3132: when others then
3133: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3134: lv_error_message := 'Error at step ' || ln_step ||
3135: ' in ' || gv_package || lv_procedure_name;
3136: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3137:
3138: lv_error_message :=
3139: pay_emp_action_arch.set_error_message(lv_error_message);
3140:
3137:
3138: lv_error_message :=
3139: pay_emp_action_arch.set_error_message(lv_error_message);
3140:
3141: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3142: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3143: hr_utility.raise_error;
3144:
3145: END py_range_cursor;
3138: lv_error_message :=
3139: pay_emp_action_arch.set_error_message(lv_error_message);
3140:
3141: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3142: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3143: hr_utility.raise_error;
3144:
3145: END py_range_cursor;
3146:
3139: pay_emp_action_arch.set_error_message(lv_error_message);
3140:
3141: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3142: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3143: hr_utility.raise_error;
3144:
3145: END py_range_cursor;
3146:
3147:
3253: ln_step NUMBER;
3254:
3255: BEGIN
3256:
3257: --- hr_utility.trace_on(null, 'PYARCH');
3258:
3259: lv_procedure_name := '.py_action_creation';
3260: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3261: pay_emp_action_arch.gv_error_message := NULL;
3256:
3257: --- hr_utility.trace_on(null, 'PYARCH');
3258:
3259: lv_procedure_name := '.py_action_creation';
3260: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3261: pay_emp_action_arch.gv_error_message := NULL;
3262:
3263: ln_step := 1;
3264: /* Initialising local variables to avoid GSCC warnings */
3279: ,p_end_date => ld_end_date
3280: ,p_business_group_id => ln_business_group_id
3281: ,p_cons_set_id => ln_cons_set_id
3282: ,p_payroll_id => ln_payroll_id);
3283: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3284:
3285: hr_utility.trace('ld_start_date '||ld_start_date);
3286: hr_utility.trace('ld_end_date '||ld_end_date);
3287: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
3281: ,p_cons_set_id => ln_cons_set_id
3282: ,p_payroll_id => ln_payroll_id);
3283: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3284:
3285: hr_utility.trace('ld_start_date '||ld_start_date);
3286: hr_utility.trace('ld_end_date '||ld_end_date);
3287: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
3288: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
3289: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
3282: ,p_payroll_id => ln_payroll_id);
3283: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3284:
3285: hr_utility.trace('ld_start_date '||ld_start_date);
3286: hr_utility.trace('ld_end_date '||ld_end_date);
3287: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
3288: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
3289: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
3290:
3283: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3284:
3285: hr_utility.trace('ld_start_date '||ld_start_date);
3286: hr_utility.trace('ld_end_date '||ld_end_date);
3287: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
3288: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
3289: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
3290:
3291:
3284:
3285: hr_utility.trace('ld_start_date '||ld_start_date);
3286: hr_utility.trace('ld_end_date '||ld_end_date);
3287: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
3288: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
3289: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
3290:
3291:
3292: ln_step := 2;
3285: hr_utility.trace('ld_start_date '||ld_start_date);
3286: hr_utility.trace('ld_end_date '||ld_end_date);
3287: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
3288: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
3289: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
3290:
3291:
3292: ln_step := 2;
3293: open c_get_xfr_emp( p_start_assignment_id
3298: ,ld_start_date
3299: ,ld_end_date);
3300:
3301: -- Loop for all rows returned for SQL statement.
3302: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3303: loop
3304: ln_step := 3;
3305: fetch c_get_xfr_emp into ln_assignment_id,
3306: ln_tax_unit_id,
3311: ln_payroll_action_id;
3312:
3313: exit when c_get_xfr_emp%notfound;
3314:
3315: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3316: hr_utility.trace('ln_assignment_id = ' ||
3317: to_char(ln_assignment_id));
3318:
3319: /********************************************************
3312:
3313: exit when c_get_xfr_emp%notfound;
3314:
3315: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3316: hr_utility.trace('ln_assignment_id = ' ||
3317: to_char(ln_assignment_id));
3318:
3319: /********************************************************
3320: ** If Balance Adjustment, only create one assignment
3333: lv_action_type = 'B' and
3334: ln_asg_action_id <> ln_prev_asg_action_id then
3335:
3336: ln_step := 5;
3337: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3338: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
3339: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
3340: hr_nonrun_asact.insint(ln_xfr_action_id
3341: ,ln_asg_action_id);
3334: ln_asg_action_id <> ln_prev_asg_action_id then
3335:
3336: ln_step := 5;
3337: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3338: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
3339: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
3340: hr_nonrun_asact.insint(ln_xfr_action_id
3341: ,ln_asg_action_id);
3342: else
3335:
3336: ln_step := 5;
3337: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3338: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
3339: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
3340: hr_nonrun_asact.insint(ln_xfr_action_id
3341: ,ln_asg_action_id);
3342: else
3343: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3339: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
3340: hr_nonrun_asact.insint(ln_xfr_action_id
3341: ,ln_asg_action_id);
3342: else
3343: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3344: hr_utility.trace('Action_type = '||lv_action_type );
3345:
3346: ln_step := 6;
3347: select pay_assignment_actions_s.nextval
3340: hr_nonrun_asact.insint(ln_xfr_action_id
3341: ,ln_asg_action_id);
3342: else
3343: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3344: hr_utility.trace('Action_type = '||lv_action_type );
3345:
3346: ln_step := 6;
3347: select pay_assignment_actions_s.nextval
3348: into ln_xfr_action_id
3357: ln_tax_unit_id,
3358: null,
3359: 'U',
3360: null);
3361: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3362: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
3363: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
3364: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
3365: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
3358: null,
3359: 'U',
3360: null);
3361: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3362: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
3363: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
3364: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
3365: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
3366: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3359: 'U',
3360: null);
3361: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3362: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
3363: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
3364: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
3365: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
3366: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3367:
3360: null);
3361: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3362: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
3363: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
3364: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
3365: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
3366: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3367:
3368: -- insert an interlock to this action
3361: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3362: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
3363: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
3364: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
3365: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
3366: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3367:
3368: -- insert an interlock to this action
3369: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
3362: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
3363: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
3364: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
3365: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
3366: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3367:
3368: -- insert an interlock to this action
3369: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
3370: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
3365: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
3366: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3367:
3368: -- insert an interlock to this action
3369: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
3370: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
3371: ln_step := 8;
3372: hr_nonrun_asact.insint(ln_xfr_action_id,
3373: ln_asg_action_id);
3366: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3367:
3368: -- insert an interlock to this action
3369: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
3370: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
3371: ln_step := 8;
3372: hr_nonrun_asact.insint(ln_xfr_action_id,
3373: ln_asg_action_id);
3374:
3371: ln_step := 8;
3372: hr_nonrun_asact.insint(ln_xfr_action_id,
3373: ln_asg_action_id);
3374:
3375: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3376:
3377: for lock_pp_aa in c_lock_chld_pp_aa(ln_asg_action_id)
3378: loop
3379:
3376:
3377: for lock_pp_aa in c_lock_chld_pp_aa(ln_asg_action_id)
3378: loop
3379:
3380: hr_utility.trace('Locked Action by Master = ' ||
3381: lock_pp_aa.assignment_action_id);
3382: hr_nonrun_asact.insint(ln_xfr_action_id,
3383: lock_pp_aa.assignment_action_id);
3384:
3394: update pay_assignment_actions
3395: set serial_number = lv_serial_number
3396: where assignment_action_id = ln_xfr_action_id;
3397:
3398: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3399:
3400: end if ; --ln_assignment_id ...
3401:
3402: ln_step := 10;
3409: close c_get_xfr_emp;
3410:
3411: EXCEPTION
3412: when others then
3413: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3414: lv_error_message := 'Error at step ' || ln_step ||
3415: ' in ' || gv_package || lv_procedure_name;
3416: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3417:
3412: when others then
3413: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3414: lv_error_message := 'Error at step ' || ln_step ||
3415: ' in ' || gv_package || lv_procedure_name;
3416: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3417:
3418: lv_error_message :=
3419: pay_emp_action_arch.set_error_message(lv_error_message);
3420:
3417:
3418: lv_error_message :=
3419: pay_emp_action_arch.set_error_message(lv_error_message);
3420:
3421: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3422: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3423: hr_utility.raise_error;
3424:
3425: END py_action_creation;
3418: lv_error_message :=
3419: pay_emp_action_arch.set_error_message(lv_error_message);
3420:
3421: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3422: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3423: hr_utility.raise_error;
3424:
3425: END py_action_creation;
3426:
3419: pay_emp_action_arch.set_error_message(lv_error_message);
3420:
3421: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3422: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3423: hr_utility.raise_error;
3424:
3425: END py_action_creation;
3426:
3427: /************************************************************
3501: j number;
3502:
3503: BEGIN
3504: lv_procedure_name := '.py_archinit';
3505: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3506: pay_emp_action_arch.gv_error_message := NULL;
3507: lv_reporting_level := Null;
3508: i := 0;
3509: j := 0;
3553: pay_emp_action_arch.gv_multi_leg_rule
3554: := pay_emp_action_arch.get_multi_legislative_rule('CA');
3555: end if;
3556:
3557: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
3558: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
3559: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3560:
3561: ln_step := 30;
3554: := pay_emp_action_arch.get_multi_legislative_rule('CA');
3555: end if;
3556:
3557: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
3558: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
3559: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3560:
3561: ln_step := 30;
3562: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
3555: end if;
3556:
3557: hr_utility.trace('lv_reporting_level : '|| lv_reporting_level);
3558: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
3559: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3560:
3561: ln_step := 30;
3562: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
3563: lv_pymt_dimension := '_ASG_PAYMENTS';
3661: dbt(i).jurisdiction_cd := 'NU';
3662: else
3663: dbt(i).jurisdiction_cd := 'QC';
3664: end if;
3665: hr_utility.trace(dbt(i).jurisdiction_cd);
3666: i := i + 1;
3667: end loop;
3668: elsif ( c_dbt.balance_name = 'QPP EE Withheld' ) then
3669: ln_step := 130;
3706: end if;
3707:
3708: end loop;
3709:
3710: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3711: i := 0;
3712:
3713: ln_step := 160;
3714: for tax_short_name in cur_tax_name loop
3716: tax(i).language := tax_short_name.language;
3717: tax(i).lookup_code := tax_short_name.lookup_code;
3718: tax(i).meaning := tax_short_name.meaning;
3719:
3720: hr_utility.trace(tax(i).language);
3721: hr_utility.trace(tax(i).lookup_code);
3722: hr_utility.trace(tax(i).meaning);
3723:
3724: i := i + 1;
3717: tax(i).lookup_code := tax_short_name.lookup_code;
3718: tax(i).meaning := tax_short_name.meaning;
3719:
3720: hr_utility.trace(tax(i).language);
3721: hr_utility.trace(tax(i).lookup_code);
3722: hr_utility.trace(tax(i).meaning);
3723:
3724: i := i + 1;
3725:
3718: tax(i).meaning := tax_short_name.meaning;
3719:
3720: hr_utility.trace(tax(i).language);
3721: hr_utility.trace(tax(i).lookup_code);
3722: hr_utility.trace(tax(i).meaning);
3723:
3724: i := i + 1;
3725:
3726: end loop;
3726: end loop;
3727:
3728: ln_step := 170;
3729: for i in dbt.first..dbt.last loop
3730: hr_utility.trace(dbt(i).bal_name);
3731: hr_utility.trace(dbt(i).disp_sequence);
3732: hr_utility.trace(dbt(i).bal_type_id);
3733: hr_utility.trace(dbt(i).pymt_def_bal_id);
3734: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
3727:
3728: ln_step := 170;
3729: for i in dbt.first..dbt.last loop
3730: hr_utility.trace(dbt(i).bal_name);
3731: hr_utility.trace(dbt(i).disp_sequence);
3732: hr_utility.trace(dbt(i).bal_type_id);
3733: hr_utility.trace(dbt(i).pymt_def_bal_id);
3734: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
3735: hr_utility.trace(dbt(i).tg_ytd_def_bal_id);
3728: ln_step := 170;
3729: for i in dbt.first..dbt.last loop
3730: hr_utility.trace(dbt(i).bal_name);
3731: hr_utility.trace(dbt(i).disp_sequence);
3732: hr_utility.trace(dbt(i).bal_type_id);
3733: hr_utility.trace(dbt(i).pymt_def_bal_id);
3734: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
3735: hr_utility.trace(dbt(i).tg_ytd_def_bal_id);
3736: -- Added run_def_bal_id for reversals in canada Bug#3498653
3729: for i in dbt.first..dbt.last loop
3730: hr_utility.trace(dbt(i).bal_name);
3731: hr_utility.trace(dbt(i).disp_sequence);
3732: hr_utility.trace(dbt(i).bal_type_id);
3733: hr_utility.trace(dbt(i).pymt_def_bal_id);
3734: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
3735: hr_utility.trace(dbt(i).tg_ytd_def_bal_id);
3736: -- Added run_def_bal_id for reversals in canada Bug#3498653
3737: hr_utility.trace(dbt(i).run_def_bal_id);
3730: hr_utility.trace(dbt(i).bal_name);
3731: hr_utility.trace(dbt(i).disp_sequence);
3732: hr_utility.trace(dbt(i).bal_type_id);
3733: hr_utility.trace(dbt(i).pymt_def_bal_id);
3734: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
3735: hr_utility.trace(dbt(i).tg_ytd_def_bal_id);
3736: -- Added run_def_bal_id for reversals in canada Bug#3498653
3737: hr_utility.trace(dbt(i).run_def_bal_id);
3738: hr_utility.trace(dbt(i).jurisdiction_cd);
3731: hr_utility.trace(dbt(i).disp_sequence);
3732: hr_utility.trace(dbt(i).bal_type_id);
3733: hr_utility.trace(dbt(i).pymt_def_bal_id);
3734: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
3735: hr_utility.trace(dbt(i).tg_ytd_def_bal_id);
3736: -- Added run_def_bal_id for reversals in canada Bug#3498653
3737: hr_utility.trace(dbt(i).run_def_bal_id);
3738: hr_utility.trace(dbt(i).jurisdiction_cd);
3739: end loop;
3733: hr_utility.trace(dbt(i).pymt_def_bal_id);
3734: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
3735: hr_utility.trace(dbt(i).tg_ytd_def_bal_id);
3736: -- Added run_def_bal_id for reversals in canada Bug#3498653
3737: hr_utility.trace(dbt(i).run_def_bal_id);
3738: hr_utility.trace(dbt(i).jurisdiction_cd);
3739: end loop;
3740:
3741: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3734: hr_utility.trace(dbt(i).gre_ytd_def_bal_id);
3735: hr_utility.trace(dbt(i).tg_ytd_def_bal_id);
3736: -- Added run_def_bal_id for reversals in canada Bug#3498653
3737: hr_utility.trace(dbt(i).run_def_bal_id);
3738: hr_utility.trace(dbt(i).jurisdiction_cd);
3739: end loop;
3740:
3741: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3742:
3737: hr_utility.trace(dbt(i).run_def_bal_id);
3738: hr_utility.trace(dbt(i).jurisdiction_cd);
3739: end loop;
3740:
3741: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3742:
3743: EXCEPTION
3744: when others then
3745: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3741: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3742:
3743: EXCEPTION
3744: when others then
3745: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3746: lv_error_message := 'Error at step ' || ln_step ||
3747: ' in ' || gv_package || lv_procedure_name;
3748: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3749:
3744: when others then
3745: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3746: lv_error_message := 'Error at step ' || ln_step ||
3747: ' in ' || gv_package || lv_procedure_name;
3748: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3749:
3750: lv_error_message :=
3751: pay_emp_action_arch.set_error_message(lv_error_message);
3752:
3749:
3750: lv_error_message :=
3751: pay_emp_action_arch.set_error_message(lv_error_message);
3752:
3753: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3754: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3755: hr_utility.raise_error;
3756:
3757: END py_archinit;
3750: lv_error_message :=
3751: pay_emp_action_arch.set_error_message(lv_error_message);
3752:
3753: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3754: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3755: hr_utility.raise_error;
3756:
3757: END py_archinit;
3758:
3751: pay_emp_action_arch.set_error_message(lv_error_message);
3752:
3753: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3754: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3755: hr_utility.raise_error;
3756:
3757: END py_archinit;
3758:
3759: --begin
3756:
3757: END py_archinit;
3758:
3759: --begin
3760: --hr_utility.trace_on (null, 'PYARCH');
3761:
3762: end pay_ca_payroll_arch;