APPS.PAY_US_ACTION_ARCH dependencies on HR_UTILITY

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

402: lv_error_message VARCHAR2(200);
403: ln_step NUMBER;
404:
405: BEGIN
406: hr_utility.set_location(gv_package || lv_procedure_name, 10);
407: ln_step := 1;
408: open c_payroll_action_info(p_payroll_action_id);
409: fetch c_payroll_action_info into ld_end_date,
410: ld_start_date,

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

412: ln_cons_set_id,
413: ln_payroll_id;
414: close c_payroll_action_info;
415:
416: hr_utility.set_location(gv_package || lv_procedure_name, 30);
417: p_end_date := ld_end_date;
418: p_start_date := ld_start_date;
419: p_business_group_id := ln_business_group_id;
420: p_cons_set_id := ln_cons_set_id;

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

418: p_start_date := ld_start_date;
419: p_business_group_id := ln_business_group_id;
420: p_cons_set_id := ln_cons_set_id;
421: p_payroll_id := ln_payroll_id;
422: hr_utility.set_location(gv_package || lv_procedure_name, 50);
423: ln_step := 2;
424:
425: EXCEPTION
426: when others then

Line 430: hr_utility.trace(lv_error_message || '-' || sqlerrm);

426: when others then
427: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
428: gv_package || lv_procedure_name;
429:
430: hr_utility.trace(lv_error_message || '-' || sqlerrm);
431:
432: lv_error_message :=
433: pay_emp_action_arch.set_error_message(lv_error_message);
434:

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

431:
432: lv_error_message :=
433: pay_emp_action_arch.set_error_message(lv_error_message);
434:
435: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
436: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
437: hr_utility.raise_error;
438:
439: END get_payroll_action_info;

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

432: lv_error_message :=
433: pay_emp_action_arch.set_error_message(lv_error_message);
434:
435: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
436: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
437: hr_utility.raise_error;
438:
439: END get_payroll_action_info;
440:

Line 437: hr_utility.raise_error;

433: pay_emp_action_arch.set_error_message(lv_error_message);
434:
435: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
436: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
437: hr_utility.raise_error;
438:
439: END get_payroll_action_info;
440:
441:

Line 484: hr_utility.trace('opened c_get_defined_balance');

480:
481: ln_defined_balance_id NUMBER;
482:
483: BEGIN
484: hr_utility.trace('opened c_get_defined_balance');
485: open c_get_defined_balance_id(p_business_group_id,
486: p_balance_name,
487: p_balance_dimension);
488:

Line 491: hr_utility.trace('Defined balance Id not found');

487: p_balance_dimension);
488:
489: fetch c_get_defined_balance_id into ln_defined_balance_id;
490: if c_get_defined_balance_id%notfound then
491: hr_utility.trace('Defined balance Id not found');
492: -- Do not error out if the defined_balance_id does not exist
493: -- Pass Null instead.
494: end if;
495: close c_get_defined_balance_id;

Line 496: hr_utility.trace('ln_defined_balance_id = ' ||

492: -- Do not error out if the defined_balance_id does not exist
493: -- Pass Null instead.
494: end if;
495: close c_get_defined_balance_id;
496: hr_utility.trace('ln_defined_balance_id = ' ||
497: to_char(ln_defined_balance_id));
498:
499: return (ln_defined_balance_id);
500:

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

523: lv_sql_string VARCHAR2(32000);
524: lv_procedure_name VARCHAR2(100) := '.action_range_cursor';
525:
526: BEGIN
527: hr_utility.set_location(gv_package || lv_procedure_name, 10);
528: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
529: ,p_start_date => ld_start_date
530: ,p_end_date => ld_end_date
531: ,p_business_group_id => ln_business_group_id

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

530: ,p_end_date => ld_end_date
531: ,p_business_group_id => ln_business_group_id
532: ,p_cons_set_id => ln_cons_set_id
533: ,p_payroll_id => ln_payroll_id);
534: hr_utility.set_location(gv_package || lv_procedure_name, 20);
535:
536: lv_sql_string :=
537: 'select distinct paf.person_id
538: from pay_assignment_actions paa,

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

568: and ppa1.report_type = ''XFR_INTERFACE'')
569: and :payroll_action_id is not null
570: order by paf.person_id';
571:
572: hr_utility.set_location(gv_package || lv_procedure_name, 30);
573: p_sqlstr := lv_sql_string;
574: hr_utility.set_location(gv_package || lv_procedure_name, 50);
575:
576: END action_range_cursor;

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

570: order by paf.person_id';
571:
572: hr_utility.set_location(gv_package || lv_procedure_name, 30);
573: p_sqlstr := lv_sql_string;
574: hr_utility.set_location(gv_package || lv_procedure_name, 50);
575:
576: END action_range_cursor;
577:
578:

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

738:
739: begin
740: ln_step := 1;
741: pay_emp_action_arch.gv_error_message := NULL;
742: hr_utility.set_location(gv_package || lv_procedure_name, 10);
743:
744: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
745: ,p_start_date => ld_start_date
746: ,p_end_date => ld_end_date

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

746: ,p_end_date => ld_end_date
747: ,p_business_group_id => ln_business_group_id
748: ,p_cons_set_id => ln_cons_set_id
749: ,p_payroll_id => ln_payroll_id);
750: hr_utility.set_location(gv_package || lv_procedure_name, 20);
751:
752: lb_range_person := pay_ac_utility.range_person_on(
753: p_report_type => 'XFR_INTERFACE'
754: ,p_report_format => 'TAXARCH'

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

774: ,ld_end_date);
775: end if;
776:
777: -- Loop for all rows returned for SQL statement.
778: hr_utility.set_location(gv_package || lv_procedure_name, 30);
779: loop
780: if lb_range_person then
781: fetch c_get_xfr_range_emp into ln_assignment_id,
782: ln_tax_unit_id,

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

798:
799: exit when c_get_xfr_emp%notfound;
800: end if;
801:
802: hr_utility.set_location(gv_package || lv_procedure_name, 40);
803: hr_utility.trace('ln_assignment_id = ' ||
804: to_char(ln_assignment_id));
805:
806: /********************************************************

Line 803: hr_utility.trace('ln_assignment_id = ' ||

799: exit when c_get_xfr_emp%notfound;
800: end if;
801:
802: hr_utility.set_location(gv_package || lv_procedure_name, 40);
803: hr_utility.trace('ln_assignment_id = ' ||
804: to_char(ln_assignment_id));
805:
806: /********************************************************
807: ** If Balance Adjustment, only create one assignment

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

818: ld_effective_date = ld_prev_effective_date and
819: lv_action_type = 'B' and
820: ln_asg_action_id <> ln_prev_asg_action_id then
821:
822: hr_utility.set_location(gv_package || lv_procedure_name, 50);
823: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
824: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
825: hr_nonrun_asact.insint(ln_xfr_action_id
826: ,ln_asg_action_id);

Line 823: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);

819: lv_action_type = 'B' and
820: ln_asg_action_id <> ln_prev_asg_action_id then
821:
822: hr_utility.set_location(gv_package || lv_procedure_name, 50);
823: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
824: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
825: hr_nonrun_asact.insint(ln_xfr_action_id
826: ,ln_asg_action_id);
827: else

Line 824: hr_utility.trace('Locked Action = ' || ln_asg_action_id);

820: ln_asg_action_id <> ln_prev_asg_action_id then
821:
822: hr_utility.set_location(gv_package || lv_procedure_name, 50);
823: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
824: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
825: hr_nonrun_asact.insint(ln_xfr_action_id
826: ,ln_asg_action_id);
827: else
828: hr_utility.set_location(gv_package || lv_procedure_name, 60);

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

824: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
825: hr_nonrun_asact.insint(ln_xfr_action_id
826: ,ln_asg_action_id);
827: else
828: hr_utility.set_location(gv_package || lv_procedure_name, 60);
829: hr_utility.trace('Action_type = '||lv_action_type );
830:
831: select pay_assignment_actions_s.nextval
832: into ln_xfr_action_id

Line 829: hr_utility.trace('Action_type = '||lv_action_type );

825: hr_nonrun_asact.insint(ln_xfr_action_id
826: ,ln_asg_action_id);
827: else
828: hr_utility.set_location(gv_package || lv_procedure_name, 60);
829: hr_utility.trace('Action_type = '||lv_action_type );
830:
831: select pay_assignment_actions_s.nextval
832: into ln_xfr_action_id
833: from dual;

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

840: ln_tax_unit_id,
841: null,
842: 'U',
843: null);
844: hr_utility.set_location(gv_package || lv_procedure_name, 70);
845: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
846: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
847: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
848: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);

Line 845: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);

841: null,
842: 'U',
843: null);
844: hr_utility.set_location(gv_package || lv_procedure_name, 70);
845: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
846: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
847: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
848: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
849: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 846: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);

842: 'U',
843: null);
844: hr_utility.set_location(gv_package || lv_procedure_name, 70);
845: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
846: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
847: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
848: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
849: hr_utility.set_location(gv_package || lv_procedure_name, 80);
850:

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

843: null);
844: hr_utility.set_location(gv_package || lv_procedure_name, 70);
845: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
846: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
847: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
848: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
849: hr_utility.set_location(gv_package || lv_procedure_name, 80);
850:
851: -- insert an interlock to this action

Line 848: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);

844: hr_utility.set_location(gv_package || lv_procedure_name, 70);
845: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
846: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
847: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
848: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
849: hr_utility.set_location(gv_package || lv_procedure_name, 80);
850:
851: -- insert an interlock to this action
852: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);

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

845: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
846: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
847: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
848: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
849: hr_utility.set_location(gv_package || lv_procedure_name, 80);
850:
851: -- insert an interlock to this action
852: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
853: hr_utility.trace('Locked Action = ' || ln_asg_action_id);

Line 852: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);

848: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
849: hr_utility.set_location(gv_package || lv_procedure_name, 80);
850:
851: -- insert an interlock to this action
852: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
853: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
854: hr_nonrun_asact.insint(ln_xfr_action_id,
855: ln_asg_action_id);
856:

Line 853: hr_utility.trace('Locked Action = ' || ln_asg_action_id);

849: hr_utility.set_location(gv_package || lv_procedure_name, 80);
850:
851: -- insert an interlock to this action
852: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
853: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
854: hr_nonrun_asact.insint(ln_xfr_action_id,
855: ln_asg_action_id);
856:
857: hr_utility.set_location(gv_package || lv_procedure_name, 90);

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

853: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
854: hr_nonrun_asact.insint(ln_xfr_action_id,
855: ln_asg_action_id);
856:
857: hr_utility.set_location(gv_package || lv_procedure_name, 90);
858:
859: /********************************************************
860: ** For Balance Adj we put only the first assignment action
861: ********************************************************/

Line 869: hr_utility.set_location(gv_package || lv_procedure_name, 100);

865: update pay_assignment_actions
866: set serial_number = lv_serial_number
867: where assignment_action_id = ln_xfr_action_id;
868:
869: hr_utility.set_location(gv_package || lv_procedure_name, 100);
870:
871: end if ; --ln_assignment_id ...
872:
873: ln_prev_tax_unit_id := ln_tax_unit_id;

Line 892: hr_utility.trace(lv_error_message || '-' || sqlerrm);

888: when others then
889: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
890: gv_package || lv_procedure_name;
891:
892: hr_utility.trace(lv_error_message || '-' || sqlerrm);
893:
894: lv_error_message :=
895: pay_emp_action_arch.set_error_message(lv_error_message);
896:

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

893:
894: lv_error_message :=
895: pay_emp_action_arch.set_error_message(lv_error_message);
896:
897: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
898: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
899: hr_utility.raise_error;
900:
901: END action_action_creation;

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

894: lv_error_message :=
895: pay_emp_action_arch.set_error_message(lv_error_message);
896:
897: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
898: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
899: hr_utility.raise_error;
900:
901: END action_action_creation;
902:

Line 899: hr_utility.raise_error;

895: pay_emp_action_arch.set_error_message(lv_error_message);
896:
897: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
898: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
899: hr_utility.raise_error;
900:
901: END action_action_creation;
902:
903:

Line 1010: hr_utility.set_location(gv_package || lv_procedure_name, 1);

1006: where parameter_name = 'INIT_PAY_ARCHIVE';
1007:
1008: BEGIN
1009: ln_step := 1;
1010: hr_utility.set_location(gv_package || lv_procedure_name, 1);
1011: pay_emp_action_arch.gv_error_message := NULL;
1012:
1013: hr_utility.set_location(gv_package || lv_procedure_name, 2);
1014: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

Line 1013: hr_utility.set_location(gv_package || lv_procedure_name, 2);

1009: ln_step := 1;
1010: hr_utility.set_location(gv_package || lv_procedure_name, 1);
1011: pay_emp_action_arch.gv_error_message := NULL;
1012:
1013: hr_utility.set_location(gv_package || lv_procedure_name, 2);
1014: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
1015: ,p_start_date => ld_start_date
1016: ,p_end_date => ld_end_date
1017: ,p_business_group_id => ln_business_group_id

Line 1020: hr_utility.set_location(gv_package || lv_procedure_name, 3);

1016: ,p_end_date => ld_end_date
1017: ,p_business_group_id => ln_business_group_id
1018: ,p_cons_set_id => ln_cons_set_id
1019: ,p_payroll_id => ln_payroll_id);
1020: hr_utility.set_location(gv_package || lv_procedure_name, 3);
1021:
1022: /*********************************************************************
1023: ** This cursor is used to call first_time_process from process_actions
1024: ** whenever it is set to either Y or end date of External Process

Line 1052: hr_utility.trace('pay_emp_action_arch.gv_multi_leg_rule = ' ||

1048: lv_pymt_dimension := '_PAYMENTS';
1049: lv_jd_pymt_dimension := '_PAYMENTS_JD';
1050: lv_subj_pymt_dimension := '_SUBJECT_TO_TAX_PAYMENTS';
1051: end if;
1052: hr_utility.trace('pay_emp_action_arch.gv_multi_leg_rule = ' ||
1053: pay_emp_action_arch.gv_multi_leg_rule);
1054: hr_utility.trace('lv_pymt_dimension = ' || lv_pymt_dimension);
1055: hr_utility.trace('lv_jd_pymt_dimension = ' || lv_jd_pymt_dimension);
1056: hr_utility.trace('lv_subj_pymt_dimension = ' || lv_subj_pymt_dimension);

Line 1054: hr_utility.trace('lv_pymt_dimension = ' || lv_pymt_dimension);

1050: lv_subj_pymt_dimension := '_SUBJECT_TO_TAX_PAYMENTS';
1051: end if;
1052: hr_utility.trace('pay_emp_action_arch.gv_multi_leg_rule = ' ||
1053: pay_emp_action_arch.gv_multi_leg_rule);
1054: hr_utility.trace('lv_pymt_dimension = ' || lv_pymt_dimension);
1055: hr_utility.trace('lv_jd_pymt_dimension = ' || lv_jd_pymt_dimension);
1056: hr_utility.trace('lv_subj_pymt_dimension = ' || lv_subj_pymt_dimension);
1057:
1058: ln_step := 5;

Line 1055: hr_utility.trace('lv_jd_pymt_dimension = ' || lv_jd_pymt_dimension);

1051: end if;
1052: hr_utility.trace('pay_emp_action_arch.gv_multi_leg_rule = ' ||
1053: pay_emp_action_arch.gv_multi_leg_rule);
1054: hr_utility.trace('lv_pymt_dimension = ' || lv_pymt_dimension);
1055: hr_utility.trace('lv_jd_pymt_dimension = ' || lv_jd_pymt_dimension);
1056: hr_utility.trace('lv_subj_pymt_dimension = ' || lv_subj_pymt_dimension);
1057:
1058: ln_step := 5;
1059: open c_asg_actions(p_payroll_action_id);

Line 1056: hr_utility.trace('lv_subj_pymt_dimension = ' || lv_subj_pymt_dimension);

1052: hr_utility.trace('pay_emp_action_arch.gv_multi_leg_rule = ' ||
1053: pay_emp_action_arch.gv_multi_leg_rule);
1054: hr_utility.trace('lv_pymt_dimension = ' || lv_pymt_dimension);
1055: hr_utility.trace('lv_jd_pymt_dimension = ' || lv_jd_pymt_dimension);
1056: hr_utility.trace('lv_subj_pymt_dimension = ' || lv_subj_pymt_dimension);
1057:
1058: ln_step := 5;
1059: open c_asg_actions(p_payroll_action_id);
1060: fetch c_asg_actions into ld_effective_date;

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

1058: ln_step := 5;
1059: open c_asg_actions(p_payroll_action_id);
1060: fetch c_asg_actions into ld_effective_date;
1061: if c_asg_actions%notfound then
1062: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1063: lv_error_message := 'No Assignment Actions were picked by ' ||
1064: 'External Archive Process.';
1065:
1066: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

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

1062: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1063: lv_error_message := 'No Assignment Actions were picked by ' ||
1064: 'External Archive Process.';
1065:
1066: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1067: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
1068: --hr_utility.raise_error;
1069: end if;
1070: close c_asg_actions;

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

1063: lv_error_message := 'No Assignment Actions were picked by ' ||
1064: 'External Archive Process.';
1065:
1066: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1067: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
1068: --hr_utility.raise_error;
1069: end if;
1070: close c_asg_actions;
1071:

Line 1068: --hr_utility.raise_error;

1064: 'External Archive Process.';
1065:
1066: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1067: hr_utility.set_message_token('FORMULA_TEXT',lv_error_message);
1068: --hr_utility.raise_error;
1069: end if;
1070: close c_asg_actions;
1071:
1072: hr_utility.set_location(gv_package || lv_procedure_name, 20);

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

1068: --hr_utility.raise_error;
1069: end if;
1070: close c_asg_actions;
1071:
1072: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1073:
1074: /* Get Federal Balances */
1075: ln_step := 10;
1076: open c_get_balances('US FEDERAL');

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

1076: open c_get_balances('US FEDERAL');
1077: loop
1078: fetch c_get_balances into lv_balance_name, ln_balance_type_id;
1079: if c_get_balances%NOTFOUND then
1080: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1081: exit;
1082: end if;
1083: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1084: hr_utility.trace('lv_balance_name = ' || lv_balance_name);

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

1079: if c_get_balances%NOTFOUND then
1080: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1081: exit;
1082: end if;
1083: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1084: hr_utility.trace('lv_balance_name = ' || lv_balance_name);
1085:
1086: ln_fed_count := ln_fed_count + 1;
1087: hr_utility.trace('ln_fed_count = '||ln_fed_count);

Line 1084: hr_utility.trace('lv_balance_name = ' || lv_balance_name);

1080: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1081: exit;
1082: end if;
1083: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1084: hr_utility.trace('lv_balance_name = ' || lv_balance_name);
1085:
1086: ln_fed_count := ln_fed_count + 1;
1087: hr_utility.trace('ln_fed_count = '||ln_fed_count);
1088:

Line 1087: hr_utility.trace('ln_fed_count = '||ln_fed_count);

1083: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1084: hr_utility.trace('lv_balance_name = ' || lv_balance_name);
1085:
1086: ln_fed_count := ln_fed_count + 1;
1087: hr_utility.trace('ln_fed_count = '||ln_fed_count);
1088:
1089: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1090: := 'US FEDERAL';
1091: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name

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

1104: 'Pre Tax Deductions for FUTA',
1105: 'Supplemental Earnings for EIC',
1106: 'Pre Tax Deductions for EIC') then
1107:
1108: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1109: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1110: := get_defined_balance_id(ln_business_group_id,
1111: lv_balance_name,
1112: lv_subj_pymt_dimension);

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

1121: lv_balance_name,
1122: '_SUBJECT_TO_TAX_ASG_GRE_YTD');
1123:
1124: else
1125: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1126: hr_utility.trace('lv_pymt_dimension = '||lv_pymt_dimension);
1127: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1128: := get_defined_balance_id(ln_business_group_id,
1129: lv_balance_name,

Line 1126: hr_utility.trace('lv_pymt_dimension = '||lv_pymt_dimension);

1122: '_SUBJECT_TO_TAX_ASG_GRE_YTD');
1123:
1124: else
1125: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1126: hr_utility.trace('lv_pymt_dimension = '||lv_pymt_dimension);
1127: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1128: := get_defined_balance_id(ln_business_group_id,
1129: lv_balance_name,
1130: lv_pymt_dimension);

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

1139: lv_balance_name,
1140: '_ASG_GRE_YTD');
1141:
1142: end if;
1143: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1144: end loop;
1145:
1146: close c_get_balances;
1147:

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

1150: Public Sector Payroll changes. The following code has
1151: been added to display and archive the FIT Alien Balances
1152: *****************************************************************/
1153: ln_step := 15;
1154: hr_utility.set_location(gv_package || lv_procedure_name, 75);
1155:
1156: ln_fed_count := ln_fed_count + 1;
1157:
1158: for c_rec in c_get_balance_type_id ('Non W2 FIT Withheld')

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

1159: loop
1160: ln_balance_type_id := c_rec.balance_type_id;
1161: end loop;
1162:
1163: hr_utility.trace('ln_fed_count = ' || to_char(ln_fed_count));
1164: hr_utility.trace('ln_blance_type_id = ' || to_char(ln_balance_type_id));
1165:
1166: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1167: := 'US FEDERAL';

Line 1164: hr_utility.trace('ln_blance_type_id = ' || to_char(ln_balance_type_id));

1160: ln_balance_type_id := c_rec.balance_type_id;
1161: end loop;
1162:
1163: hr_utility.trace('ln_fed_count = ' || to_char(ln_fed_count));
1164: hr_utility.trace('ln_blance_type_id = ' || to_char(ln_balance_type_id));
1165:
1166: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1167: := 'US FEDERAL';
1168: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name

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

1206: /****************************************************************
1207: End Public Sector Payroll changes.
1208: *****************************************************************/
1209:
1210: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1211:
1212:
1213: /* Get State Balances */
1214: ln_step := 20;

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

1215: open c_get_balances('US STATE');
1216: loop
1217: fetch c_get_balances into lv_balance_name, ln_balance_type_id;
1218: if c_get_balances%NOTFOUND then
1219: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1220: exit;
1221: end if;
1222: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1223: hr_utility.trace('lv_balance_name is '||lv_balance_name);

Line 1222: hr_utility.set_location(gv_package || lv_procedure_name, 100);

1218: if c_get_balances%NOTFOUND then
1219: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1220: exit;
1221: end if;
1222: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1223: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1224:
1225: ln_state_count := ln_state_count + 1;
1226:

Line 1223: hr_utility.trace('lv_balance_name is '||lv_balance_name);

1219: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1220: exit;
1221: end if;
1222: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1223: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1224:
1225: ln_state_count := ln_state_count + 1;
1226:
1227: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category

Line 1249: hr_utility.set_location(gv_package || lv_procedure_name, 110);

1245: := get_defined_balance_id(ln_business_group_id,
1246: lv_balance_name,
1247: '_ASG_JD_GRE_YTD');
1248:
1249: hr_utility.set_location(gv_package || lv_procedure_name, 110);
1250: end loop;
1251: close c_get_balances;
1252:
1253: hr_utility.set_location(gv_package || lv_procedure_name, 120);

Line 1253: hr_utility.set_location(gv_package || lv_procedure_name, 120);

1249: hr_utility.set_location(gv_package || lv_procedure_name, 110);
1250: end loop;
1251: close c_get_balances;
1252:
1253: hr_utility.set_location(gv_package || lv_procedure_name, 120);
1254:
1255: /****************************************************************
1256: Public Sector Payroll changes. The following code has
1257: been added to display and archive the SIT Alien Balances

Line 1260: hr_utility.set_location(gv_package || lv_procedure_name, 125);

1256: Public Sector Payroll changes. The following code has
1257: been added to display and archive the SIT Alien Balances
1258: *****************************************************************/
1259: ln_step := 25;
1260: hr_utility.set_location(gv_package || lv_procedure_name, 125);
1261:
1262: ln_state_count := ln_state_count + 1;
1263:
1264: for c_rec in c_get_balance_type_id ('SIT Alien Withheld')

Line 1294: hr_utility.set_location(gv_package || lv_procedure_name, 126);

1290:
1291: /****************************************************************
1292: End Public Sector Payroll changes.
1293: *****************************************************************/
1294: hr_utility.set_location(gv_package || lv_procedure_name, 126);
1295:
1296:
1297: /* Get County Balances */
1298: ln_step := 30;

Line 1303: hr_utility.set_location(gv_package || lv_procedure_name, 130);

1299: open c_get_balances('US COUNTY');
1300: loop
1301: fetch c_get_balances into lv_balance_name, ln_balance_type_id;
1302: if c_get_balances%NOTFOUND then
1303: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1304: exit;
1305: end if;
1306: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1307: hr_utility.trace('lv_balance_name is '||lv_balance_name);

Line 1306: hr_utility.set_location(gv_package || lv_procedure_name, 140);

1302: if c_get_balances%NOTFOUND then
1303: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1304: exit;
1305: end if;
1306: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1307: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1308:
1309: ln_county_count := ln_county_count + 1;
1310:

Line 1307: hr_utility.trace('lv_balance_name is '||lv_balance_name);

1303: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1304: exit;
1305: end if;
1306: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1307: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1308:
1309: ln_county_count := ln_county_count + 1;
1310:
1311: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).action_info_category

Line 1331: hr_utility.set_location(gv_package || lv_procedure_name, 150);

1327: := get_defined_balance_id(ln_business_group_id,
1328: lv_balance_name,
1329: '_ASG_JD_GRE_YTD');
1330:
1331: hr_utility.set_location(gv_package || lv_procedure_name, 150);
1332: end loop;
1333: close c_get_balances;
1334: --
1335: hr_utility.trace('Entering County Loop ' );

Line 1335: hr_utility.trace('Entering County Loop ' );

1331: hr_utility.set_location(gv_package || lv_procedure_name, 150);
1332: end loop;
1333: close c_get_balances;
1334: --
1335: hr_utility.trace('Entering County Loop ' );
1336: ln_step := 35;
1337: for i in pay_us_action_arch.ltr_county_tax_bal.first ..
1338: pay_us_action_arch.ltr_county_tax_bal.last loop
1339:

Line 1340: hr_utility.trace('Count = ' || to_char(i));

1336: ln_step := 35;
1337: for i in pay_us_action_arch.ltr_county_tax_bal.first ..
1338: pay_us_action_arch.ltr_county_tax_bal.last loop
1339:
1340: hr_utility.trace('Count = ' || to_char(i));
1341: hr_utility.trace('Category = ' ||
1342: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);
1343: hr_utility.trace('Balance Name = ' ||
1344: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);

Line 1341: hr_utility.trace('Category = ' ||

1337: for i in pay_us_action_arch.ltr_county_tax_bal.first ..
1338: pay_us_action_arch.ltr_county_tax_bal.last loop
1339:
1340: hr_utility.trace('Count = ' || to_char(i));
1341: hr_utility.trace('Category = ' ||
1342: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);
1343: hr_utility.trace('Balance Name = ' ||
1344: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1345: hr_utility.trace('pay_def_bal_id ' ||

Line 1343: hr_utility.trace('Balance Name = ' ||

1339:
1340: hr_utility.trace('Count = ' || to_char(i));
1341: hr_utility.trace('Category = ' ||
1342: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);
1343: hr_utility.trace('Balance Name = ' ||
1344: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1345: hr_utility.trace('pay_def_bal_id ' ||
1346: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1347: hr_utility.trace('asg_run_def_bal_id = ' ||

Line 1345: hr_utility.trace('pay_def_bal_id ' ||

1341: hr_utility.trace('Category = ' ||
1342: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);
1343: hr_utility.trace('Balance Name = ' ||
1344: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1345: hr_utility.trace('pay_def_bal_id ' ||
1346: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1347: hr_utility.trace('asg_run_def_bal_id = ' ||
1348: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);
1349: hr_utility.trace('ytd_def_bal_id = ' ||

Line 1347: hr_utility.trace('asg_run_def_bal_id = ' ||

1343: hr_utility.trace('Balance Name = ' ||
1344: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1345: hr_utility.trace('pay_def_bal_id ' ||
1346: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1347: hr_utility.trace('asg_run_def_bal_id = ' ||
1348: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);
1349: hr_utility.trace('ytd_def_bal_id = ' ||
1350: pay_us_action_arch.ltr_county_tax_bal(i).ytd_def_bal_id);
1351: end loop;

Line 1349: hr_utility.trace('ytd_def_bal_id = ' ||

1345: hr_utility.trace('pay_def_bal_id ' ||
1346: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1347: hr_utility.trace('asg_run_def_bal_id = ' ||
1348: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);
1349: hr_utility.trace('ytd_def_bal_id = ' ||
1350: pay_us_action_arch.ltr_county_tax_bal(i).ytd_def_bal_id);
1351: end loop;
1352: hr_utility.trace('Leaving County Loop ' );
1353: --

Line 1352: hr_utility.trace('Leaving County Loop ' );

1348: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);
1349: hr_utility.trace('ytd_def_bal_id = ' ||
1350: pay_us_action_arch.ltr_county_tax_bal(i).ytd_def_bal_id);
1351: end loop;
1352: hr_utility.trace('Leaving County Loop ' );
1353: --
1354:
1355: hr_utility.set_location(gv_package || lv_procedure_name, 160);
1356: /* Get City Balances */

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

1351: end loop;
1352: hr_utility.trace('Leaving County Loop ' );
1353: --
1354:
1355: hr_utility.set_location(gv_package || lv_procedure_name, 160);
1356: /* Get City Balances */
1357: ln_step := 40;
1358: open c_get_balances('US CITY');
1359: loop

Line 1362: hr_utility.set_location(gv_package || lv_procedure_name, 170);

1358: open c_get_balances('US CITY');
1359: loop
1360: fetch c_get_balances into lv_balance_name, ln_balance_type_id;
1361: if c_get_balances%notfound then
1362: hr_utility.set_location(gv_package || lv_procedure_name, 170);
1363: exit;
1364: end if;
1365: hr_utility.set_location(gv_package || lv_procedure_name, 180);
1366: hr_utility.trace('lv_balance_name is '||lv_balance_name);

Line 1365: hr_utility.set_location(gv_package || lv_procedure_name, 180);

1361: if c_get_balances%notfound then
1362: hr_utility.set_location(gv_package || lv_procedure_name, 170);
1363: exit;
1364: end if;
1365: hr_utility.set_location(gv_package || lv_procedure_name, 180);
1366: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1367:
1368: ln_city_count := ln_city_count + 1;
1369:

Line 1366: hr_utility.trace('lv_balance_name is '||lv_balance_name);

1362: hr_utility.set_location(gv_package || lv_procedure_name, 170);
1363: exit;
1364: end if;
1365: hr_utility.set_location(gv_package || lv_procedure_name, 180);
1366: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1367:
1368: ln_city_count := ln_city_count + 1;
1369:
1370: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).action_info_category

Line 1390: hr_utility.set_location(gv_package || lv_procedure_name, 190);

1386: := get_defined_balance_id(ln_business_group_id,
1387: lv_balance_name,
1388: '_ASG_JD_GRE_YTD');
1389:
1390: hr_utility.set_location(gv_package || lv_procedure_name, 190);
1391: end loop;
1392: close c_get_balances;
1393:
1394: hr_utility.set_location(gv_package || lv_procedure_name, 200);

Line 1394: hr_utility.set_location(gv_package || lv_procedure_name, 200);

1390: hr_utility.set_location(gv_package || lv_procedure_name, 190);
1391: end loop;
1392: close c_get_balances;
1393:
1394: hr_utility.set_location(gv_package || lv_procedure_name, 200);
1395: /* Get School District Balances */
1396: ln_step := 45;
1397: open c_get_balances('US SCHOOL DISTRICT');
1398: loop

Line 1401: hr_utility.set_location(gv_package || lv_procedure_name, 210);

1397: open c_get_balances('US SCHOOL DISTRICT');
1398: loop
1399: fetch c_get_balances into lv_balance_name, ln_balance_type_id;
1400: if c_get_balances%notfound then
1401: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1402: exit;
1403: end if;
1404: hr_utility.set_location(gv_package || lv_procedure_name, 220);
1405: hr_utility.trace('lv_balance_name is '||lv_balance_name);

Line 1404: hr_utility.set_location(gv_package || lv_procedure_name, 220);

1400: if c_get_balances%notfound then
1401: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1402: exit;
1403: end if;
1404: hr_utility.set_location(gv_package || lv_procedure_name, 220);
1405: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1406:
1407: ln_schdist_count := ln_schdist_count + 1;
1408:

Line 1405: hr_utility.trace('lv_balance_name is '||lv_balance_name);

1401: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1402: exit;
1403: end if;
1404: hr_utility.set_location(gv_package || lv_procedure_name, 220);
1405: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1406:
1407: ln_schdist_count := ln_schdist_count + 1;
1408:
1409: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).action_info_category

Line 1429: hr_utility.set_location(gv_package || lv_procedure_name, 230);

1425: := get_defined_balance_id(ln_business_group_id,
1426: lv_balance_name,
1427: '_ASG_JD_GRE_YTD');
1428:
1429: hr_utility.set_location(gv_package || lv_procedure_name, 230);
1430: end loop;
1431: close c_get_balances;
1432:
1433: hr_utility.set_location(gv_package || lv_procedure_name, 240);

Line 1433: hr_utility.set_location(gv_package || lv_procedure_name, 240);

1429: hr_utility.set_location(gv_package || lv_procedure_name, 230);
1430: end loop;
1431: close c_get_balances;
1432:
1433: hr_utility.set_location(gv_package || lv_procedure_name, 240);
1434: hr_utility.trace('Fed Balance Loop Count = ' ||
1435: pay_us_action_arch.ltr_fed_tax_bal.count);
1436: hr_utility.trace('State Balance Loop Count = ' ||
1437: pay_us_action_arch.ltr_state_tax_bal.count);

Line 1434: hr_utility.trace('Fed Balance Loop Count = ' ||

1430: end loop;
1431: close c_get_balances;
1432:
1433: hr_utility.set_location(gv_package || lv_procedure_name, 240);
1434: hr_utility.trace('Fed Balance Loop Count = ' ||
1435: pay_us_action_arch.ltr_fed_tax_bal.count);
1436: hr_utility.trace('State Balance Loop Count = ' ||
1437: pay_us_action_arch.ltr_state_tax_bal.count);
1438: hr_utility.trace('County Balance Loop Count = ' ||

Line 1436: hr_utility.trace('State Balance Loop Count = ' ||

1432:
1433: hr_utility.set_location(gv_package || lv_procedure_name, 240);
1434: hr_utility.trace('Fed Balance Loop Count = ' ||
1435: pay_us_action_arch.ltr_fed_tax_bal.count);
1436: hr_utility.trace('State Balance Loop Count = ' ||
1437: pay_us_action_arch.ltr_state_tax_bal.count);
1438: hr_utility.trace('County Balance Loop Count = ' ||
1439: pay_us_action_arch.ltr_county_tax_bal.count);
1440: hr_utility.trace('City Balance Loop Count = ' ||

Line 1438: hr_utility.trace('County Balance Loop Count = ' ||

1434: hr_utility.trace('Fed Balance Loop Count = ' ||
1435: pay_us_action_arch.ltr_fed_tax_bal.count);
1436: hr_utility.trace('State Balance Loop Count = ' ||
1437: pay_us_action_arch.ltr_state_tax_bal.count);
1438: hr_utility.trace('County Balance Loop Count = ' ||
1439: pay_us_action_arch.ltr_county_tax_bal.count);
1440: hr_utility.trace('City Balance Loop Count = ' ||
1441: pay_us_action_arch.ltr_city_tax_bal.count);
1442: hr_utility.trace('School Dsts Balance Loop Count = ' ||

Line 1440: hr_utility.trace('City Balance Loop Count = ' ||

1436: hr_utility.trace('State Balance Loop Count = ' ||
1437: pay_us_action_arch.ltr_state_tax_bal.count);
1438: hr_utility.trace('County Balance Loop Count = ' ||
1439: pay_us_action_arch.ltr_county_tax_bal.count);
1440: hr_utility.trace('City Balance Loop Count = ' ||
1441: pay_us_action_arch.ltr_city_tax_bal.count);
1442: hr_utility.trace('School Dsts Balance Loop Count = ' ||
1443: pay_us_action_arch.ltr_schdist_tax_bal.count);
1444: hr_utility.set_location(gv_package || lv_procedure_name, 250);

Line 1442: hr_utility.trace('School Dsts Balance Loop Count = ' ||

1438: hr_utility.trace('County Balance Loop Count = ' ||
1439: pay_us_action_arch.ltr_county_tax_bal.count);
1440: hr_utility.trace('City Balance Loop Count = ' ||
1441: pay_us_action_arch.ltr_city_tax_bal.count);
1442: hr_utility.trace('School Dsts Balance Loop Count = ' ||
1443: pay_us_action_arch.ltr_schdist_tax_bal.count);
1444: hr_utility.set_location(gv_package || lv_procedure_name, 250);
1445:
1446:

Line 1444: hr_utility.set_location(gv_package || lv_procedure_name, 250);

1440: hr_utility.trace('City Balance Loop Count = ' ||
1441: pay_us_action_arch.ltr_city_tax_bal.count);
1442: hr_utility.trace('School Dsts Balance Loop Count = ' ||
1443: pay_us_action_arch.ltr_schdist_tax_bal.count);
1444: hr_utility.set_location(gv_package || lv_procedure_name, 250);
1445:
1446:
1447: /****************************************************
1448: ** Build a PL/SQL table which has state tax info

Line 1451: hr_utility.set_location(gv_package || lv_procedure_name, 300);

1447: /****************************************************
1448: ** Build a PL/SQL table which has state tax info
1449: ** for all states
1450: ****************************************************/
1451: hr_utility.set_location(gv_package || lv_procedure_name, 300);
1452: ln_step := 50;
1453: open c_get_states_jit(ld_effective_date);
1454: loop
1455: fetch c_get_states_jit into lv_state_code, lv_sit_exists,

Line 1459: hr_utility.set_location(gv_package || lv_procedure_name, 310);

1455: fetch c_get_states_jit into lv_state_code, lv_sit_exists,
1456: lv_sui_ee_exists, lv_sui_er_exists,
1457: lv_sdi_ee_exists, lv_sdi_er_exists;
1458: if c_get_states_jit%notfound then
1459: hr_utility.set_location(gv_package || lv_procedure_name, 310);
1460: exit;
1461: end if;
1462: hr_utility.set_location(gv_package || lv_procedure_name, 320);
1463: hr_utility.trace('lv_state_code = ' || lv_state_code);

Line 1462: hr_utility.set_location(gv_package || lv_procedure_name, 320);

1458: if c_get_states_jit%notfound then
1459: hr_utility.set_location(gv_package || lv_procedure_name, 310);
1460: exit;
1461: end if;
1462: hr_utility.set_location(gv_package || lv_procedure_name, 320);
1463: hr_utility.trace('lv_state_code = ' || lv_state_code);
1464: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
1465: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
1466: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);

Line 1463: hr_utility.trace('lv_state_code = ' || lv_state_code);

1459: hr_utility.set_location(gv_package || lv_procedure_name, 310);
1460: exit;
1461: end if;
1462: hr_utility.set_location(gv_package || lv_procedure_name, 320);
1463: hr_utility.trace('lv_state_code = ' || lv_state_code);
1464: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
1465: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
1466: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
1467: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);

Line 1464: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);

1460: exit;
1461: end if;
1462: hr_utility.set_location(gv_package || lv_procedure_name, 320);
1463: hr_utility.trace('lv_state_code = ' || lv_state_code);
1464: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
1465: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
1466: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
1467: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
1468: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);

Line 1465: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);

1461: end if;
1462: hr_utility.set_location(gv_package || lv_procedure_name, 320);
1463: hr_utility.trace('lv_state_code = ' || lv_state_code);
1464: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
1465: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
1466: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
1467: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
1468: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
1469:

Line 1466: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);

1462: hr_utility.set_location(gv_package || lv_procedure_name, 320);
1463: hr_utility.trace('lv_state_code = ' || lv_state_code);
1464: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
1465: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
1466: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
1467: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
1468: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
1469:
1470: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists

Line 1467: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);

1463: hr_utility.trace('lv_state_code = ' || lv_state_code);
1464: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
1465: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
1466: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
1467: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
1468: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
1469:
1470: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists
1471: := lv_sit_exists;

Line 1468: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);

1464: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
1465: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
1466: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
1467: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
1468: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
1469:
1470: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists
1471: := lv_sit_exists;
1472: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists

Line 1484: hr_utility.set_location(gv_package || lv_procedure_name, 350);

1480:
1481: end loop;
1482: close c_get_states_jit;
1483:
1484: hr_utility.set_location(gv_package || lv_procedure_name, 350);
1485: ln_step := 55;
1486: open c_get_county_jit(ld_effective_date);
1487: loop
1488: fetch c_get_county_jit into lv_jurisdiction_code,

Line 1493: hr_utility.set_location(gv_package || lv_procedure_name, 360);

1489: lv_county_tax_exists,
1490: lv_county_sd_tax_exists,
1491: lv_county_head_tax_exists;
1492: if c_get_county_jit%notfound then
1493: hr_utility.set_location(gv_package || lv_procedure_name, 360);
1494: exit;
1495: end if;
1496: hr_utility.set_location(gv_package || lv_procedure_name, 370);
1497: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);

Line 1496: hr_utility.set_location(gv_package || lv_procedure_name, 370);

1492: if c_get_county_jit%notfound then
1493: hr_utility.set_location(gv_package || lv_procedure_name, 360);
1494: exit;
1495: end if;
1496: hr_utility.set_location(gv_package || lv_procedure_name, 370);
1497: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);
1498:
1499: ln_index := pay_us_action_arch.ltr_county_tax_info.count;
1500:

Line 1497: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);

1493: hr_utility.set_location(gv_package || lv_procedure_name, 360);
1494: exit;
1495: end if;
1496: hr_utility.set_location(gv_package || lv_procedure_name, 370);
1497: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);
1498:
1499: ln_index := pay_us_action_arch.ltr_county_tax_info.count;
1500:
1501: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code

Line 1513: hr_utility.set_location(gv_package || lv_procedure_name, 400);

1509:
1510: end loop;
1511: close c_get_county_jit;
1512:
1513: hr_utility.set_location(gv_package || lv_procedure_name, 400);
1514: ln_step := 60;
1515:
1516: exception
1517: when others then

Line 1518: hr_utility.set_location(gv_package || lv_procedure_name, 500);

1514: ln_step := 60;
1515:
1516: exception
1517: when others then
1518: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1519: lv_error_message := 'Error at step ' || ln_step ||
1520: ' in ' || gv_package || lv_procedure_name;
1521: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1522:

Line 1521: hr_utility.trace(lv_error_message || '-' || sqlerrm);

1517: when others then
1518: hr_utility.set_location(gv_package || lv_procedure_name, 500);
1519: lv_error_message := 'Error at step ' || ln_step ||
1520: ' in ' || gv_package || lv_procedure_name;
1521: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1522:
1523: lv_error_message :=
1524: pay_emp_action_arch.set_error_message(lv_error_message);
1525:

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

1522:
1523: lv_error_message :=
1524: pay_emp_action_arch.set_error_message(lv_error_message);
1525:
1526: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1527: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1528: hr_utility.raise_error;
1529:
1530: END action_archinit;

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

1523: lv_error_message :=
1524: pay_emp_action_arch.set_error_message(lv_error_message);
1525:
1526: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1527: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1528: hr_utility.raise_error;
1529:
1530: END action_archinit;
1531:

Line 1528: hr_utility.raise_error;

1524: pay_emp_action_arch.set_error_message(lv_error_message);
1525:
1526: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1527: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1528: hr_utility.raise_error;
1529:
1530: END action_archinit;
1531:
1532:

Line 1602: --hr_utility.trace_on(null, 'HBR');

1598: ln_retro_payvalue NUMBER(15,5);
1599: ln_retro_element_entry NUMBER;
1600:
1601: BEGIN
1602: --hr_utility.trace_on(null, 'HBR');
1603: lv_procedure_name := '.populate_emp_hours_by_rate';
1604: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1605: ln_rate := 0;
1606: ln_hours := 0;

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

1600:
1601: BEGIN
1602: --hr_utility.trace_on(null, 'HBR');
1603: lv_procedure_name := '.populate_emp_hours_by_rate';
1604: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1605: ln_rate := 0;
1606: ln_hours := 0;
1607: ln_multiple := 1;
1608:

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

1614: ,ln_rate
1615: ,ln_multiple
1616: ,ln_hours
1617: ,ln_amount;
1618: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1619: if c_hbr%notfound then
1620: hr_utility.set_location(gv_package || lv_procedure_name, 25);
1621: exit;
1622: end if;

Line 1620: hr_utility.set_location(gv_package || lv_procedure_name, 25);

1616: ,ln_hours
1617: ,ln_amount;
1618: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1619: if c_hbr%notfound then
1620: hr_utility.set_location(gv_package || lv_procedure_name, 25);
1621: exit;
1622: end if;
1623:
1624: if c_hbr%found then

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

1621: exit;
1622: end if;
1623:
1624: if c_hbr%found then
1625: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1626: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1627: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1628: := 'EMPLOYEE HOURS BY RATE';
1629: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 1680: hr_utility.trace('*******Element in Hours By Rate *************');

1676: close c_hbr;
1677:
1678: if ltr_hours_x_rate.count > 0 then
1679: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
1680: hr_utility.trace('*******Element in Hours By Rate *************');
1681: hr_utility.trace('HBR element name = ' || ltr_hours_x_rate(z).element_name);
1682: hr_utility.trace('HBR element hour = ' || ltr_hours_x_rate(z).hours);
1683: hr_utility.trace('HBR element rate = ' || ltr_hours_x_rate(z).rate);
1684: hr_utility.trace('HBR element payvalue = ' || ltr_hours_x_rate(z).amount);

Line 1681: hr_utility.trace('HBR element name = ' || ltr_hours_x_rate(z).element_name);

1677:
1678: if ltr_hours_x_rate.count > 0 then
1679: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
1680: hr_utility.trace('*******Element in Hours By Rate *************');
1681: hr_utility.trace('HBR element name = ' || ltr_hours_x_rate(z).element_name);
1682: hr_utility.trace('HBR element hour = ' || ltr_hours_x_rate(z).hours);
1683: hr_utility.trace('HBR element rate = ' || ltr_hours_x_rate(z).rate);
1684: hr_utility.trace('HBR element payvalue = ' || ltr_hours_x_rate(z).amount);
1685: end loop;

Line 1682: hr_utility.trace('HBR element hour = ' || ltr_hours_x_rate(z).hours);

1678: if ltr_hours_x_rate.count > 0 then
1679: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
1680: hr_utility.trace('*******Element in Hours By Rate *************');
1681: hr_utility.trace('HBR element name = ' || ltr_hours_x_rate(z).element_name);
1682: hr_utility.trace('HBR element hour = ' || ltr_hours_x_rate(z).hours);
1683: hr_utility.trace('HBR element rate = ' || ltr_hours_x_rate(z).rate);
1684: hr_utility.trace('HBR element payvalue = ' || ltr_hours_x_rate(z).amount);
1685: end loop;
1686: end if;

Line 1683: hr_utility.trace('HBR element rate = ' || ltr_hours_x_rate(z).rate);

1679: for z in ltr_hours_x_rate.first .. ltr_hours_x_rate.last loop
1680: hr_utility.trace('*******Element in Hours By Rate *************');
1681: hr_utility.trace('HBR element name = ' || ltr_hours_x_rate(z).element_name);
1682: hr_utility.trace('HBR element hour = ' || ltr_hours_x_rate(z).hours);
1683: hr_utility.trace('HBR element rate = ' || ltr_hours_x_rate(z).rate);
1684: hr_utility.trace('HBR element payvalue = ' || ltr_hours_x_rate(z).amount);
1685: end loop;
1686: end if;
1687:

Line 1684: hr_utility.trace('HBR element payvalue = ' || ltr_hours_x_rate(z).amount);

1680: hr_utility.trace('*******Element in Hours By Rate *************');
1681: hr_utility.trace('HBR element name = ' || ltr_hours_x_rate(z).element_name);
1682: hr_utility.trace('HBR element hour = ' || ltr_hours_x_rate(z).hours);
1683: hr_utility.trace('HBR element rate = ' || ltr_hours_x_rate(z).rate);
1684: hr_utility.trace('HBR element payvalue = ' || ltr_hours_x_rate(z).amount);
1685: end loop;
1686: end if;
1687:
1688: if ltr_hours_x_rate.count > 0 then

Line 1704: hr_utility.trace('HBR diff ' || ltr_hours_x_rate(z).element_name ||

1700: pay_ac_action_arch.lrr_act_tab(i).act_info11) OR
1701: (ltr_hours_x_rate(z).amount <>
1702: pay_ac_action_arch.lrr_act_tab(i).act_info8)) then
1703: --call function to get the retro data
1704: hr_utility.trace('HBR diff ' || ltr_hours_x_rate(z).element_name ||
1705: ' Element ID=' || ltr_hours_x_rate(z).element_type_id ||
1706: ' AC HBR=' ||
1707: pay_ac_action_arch.lrr_act_tab(i).act_info11 ||
1708: ' HBR Hours=' || ltr_hours_x_rate(z).hours ||

Line 1712: hr_utility.set_location(gv_package || lv_procedure_name, 57);

1708: ' HBR Hours=' || ltr_hours_x_rate(z).hours ||
1709: ' p_run_action_id='||p_run_action_id);
1710: open c_retro(p_run_action_id, ltr_hours_x_rate(z).element_type_id);
1711: loop
1712: hr_utility.set_location(gv_package || lv_procedure_name, 57);
1713: fetch c_retro into ln_retro_element_entry
1714: ,ln_retro_payvalue
1715: ,ln_retro_hours
1716: ,ln_retro_multiple

Line 1722: hr_utility.trace('HBR Retro Values');

1718: if c_retro%notfound then
1719: exit;
1720: end if;
1721:
1722: hr_utility.trace('HBR Retro Values');
1723: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1724: hr_utility.trace('Hours ='|| ln_retro_hours);
1725: hr_utility.trace('Rate ='|| ln_retro_rate);
1726: hr_utility.trace('Multiple ='|| ln_retro_multiple);

Line 1723: hr_utility.trace('Pay Value='|| ln_retro_payvalue);

1719: exit;
1720: end if;
1721:
1722: hr_utility.trace('HBR Retro Values');
1723: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1724: hr_utility.trace('Hours ='|| ln_retro_hours);
1725: hr_utility.trace('Rate ='|| ln_retro_rate);
1726: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1727: if ln_retro_multiple = 0 then

Line 1724: hr_utility.trace('Hours ='|| ln_retro_hours);

1720: end if;
1721:
1722: hr_utility.trace('HBR Retro Values');
1723: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1724: hr_utility.trace('Hours ='|| ln_retro_hours);
1725: hr_utility.trace('Rate ='|| ln_retro_rate);
1726: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1727: if ln_retro_multiple = 0 then
1728: ln_retro_multiple := 1;

Line 1725: hr_utility.trace('Rate ='|| ln_retro_rate);

1721:
1722: hr_utility.trace('HBR Retro Values');
1723: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1724: hr_utility.trace('Hours ='|| ln_retro_hours);
1725: hr_utility.trace('Rate ='|| ln_retro_rate);
1726: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1727: if ln_retro_multiple = 0 then
1728: ln_retro_multiple := 1;
1729: end if;

Line 1726: hr_utility.trace('Multiple ='|| ln_retro_multiple);

1722: hr_utility.trace('HBR Retro Values');
1723: hr_utility.trace('Pay Value='|| ln_retro_payvalue);
1724: hr_utility.trace('Hours ='|| ln_retro_hours);
1725: hr_utility.trace('Rate ='|| ln_retro_rate);
1726: hr_utility.trace('Multiple ='|| ln_retro_multiple);
1727: if ln_retro_multiple = 0 then
1728: ln_retro_multiple := 1;
1729: end if;
1730:

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

1750: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1751: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));
1752: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1753: := fnd_number.number_to_canonical(ln_retro_payvalue);
1754: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1755: end loop;
1756: close c_retro;
1757: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1758: end if;

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

1753: := fnd_number.number_to_canonical(ln_retro_payvalue);
1754: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1755: end loop;
1756: close c_retro;
1757: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1758: end if;
1759: exit;
1760: end if;
1761: end loop;

Line 1766: hr_utility.set_location(gv_package || lv_procedure_name, 100);

1762: end if;
1763: end loop;
1764: end if;
1765:
1766: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1767: --hr_utility.trace_off;
1768:
1769: EXCEPTION
1770: when others then

Line 1767: --hr_utility.trace_off;

1763: end loop;
1764: end if;
1765:
1766: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1767: --hr_utility.trace_off;
1768:
1769: EXCEPTION
1770: when others then
1771: lv_error_message := 'Error in ' ||

Line 1774: hr_utility.trace(lv_error_message || '-' || sqlerrm);

1770: when others then
1771: lv_error_message := 'Error in ' ||
1772: gv_package || lv_procedure_name;
1773:
1774: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1775:
1776: lv_error_message :=
1777: pay_emp_action_arch.set_error_message(lv_error_message);
1778:

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

1775:
1776: lv_error_message :=
1777: pay_emp_action_arch.set_error_message(lv_error_message);
1778:
1779: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1780: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1781: hr_utility.raise_error;
1782:
1783: END populate_emp_hours_by_rate;

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

1776: lv_error_message :=
1777: pay_emp_action_arch.set_error_message(lv_error_message);
1778:
1779: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1780: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1781: hr_utility.raise_error;
1782:
1783: END populate_emp_hours_by_rate;
1784:

Line 1781: hr_utility.raise_error;

1777: pay_emp_action_arch.set_error_message(lv_error_message);
1778:
1779: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1780: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1781: hr_utility.raise_error;
1782:
1783: END populate_emp_hours_by_rate;
1784:
1785:

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

1799: lv_procedure_name VARCHAR2(100) := '.update_federal_values';
1800: lv_error_message VARCHAR2(200);
1801:
1802: BEGIN
1803: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1804: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1805: hr_utility.trace('p_balance = '|| p_balance);
1806: hr_utility.trace('ln_bal_value = ' || p_bal_value);
1807:

Line 1804: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

1800: lv_error_message VARCHAR2(200);
1801:
1802: BEGIN
1803: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1804: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1805: hr_utility.trace('p_balance = '|| p_balance);
1806: hr_utility.trace('ln_bal_value = ' || p_bal_value);
1807:
1808: pay_ac_action_arch.lrr_act_tab(p_index).action_info_category

Line 1805: hr_utility.trace('p_balance = '|| p_balance);

1801:
1802: BEGIN
1803: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1804: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1805: hr_utility.trace('p_balance = '|| p_balance);
1806: hr_utility.trace('ln_bal_value = ' || p_bal_value);
1807:
1808: pay_ac_action_arch.lrr_act_tab(p_index).action_info_category
1809: := p_category;

Line 1806: hr_utility.trace('ln_bal_value = ' || p_bal_value);

1802: BEGIN
1803: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1804: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1805: hr_utility.trace('p_balance = '|| p_balance);
1806: hr_utility.trace('ln_bal_value = ' || p_bal_value);
1807:
1808: pay_ac_action_arch.lrr_act_tab(p_index).action_info_category
1809: := p_category;
1810: pay_ac_action_arch.lrr_act_tab(p_index).jurisdiction_code

Line 1919: hr_utility.set_location(gv_package || lv_procedure_name, 100);

1915: nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0)
1916: + p_bal_value;
1917: end if;
1918:
1919: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1920:
1921: EXCEPTION
1922: when others then
1923: lv_error_message := 'Error in ' ||

Line 1926: hr_utility.trace(lv_error_message || '-' || sqlerrm);

1922: when others then
1923: lv_error_message := 'Error in ' ||
1924: gv_package || lv_procedure_name;
1925:
1926: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1927:
1928: lv_error_message :=
1929: pay_emp_action_arch.set_error_message(lv_error_message);
1930:

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

1927:
1928: lv_error_message :=
1929: pay_emp_action_arch.set_error_message(lv_error_message);
1930:
1931: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1932: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1933: hr_utility.raise_error;
1934:
1935: END update_federal_values;

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

1928: lv_error_message :=
1929: pay_emp_action_arch.set_error_message(lv_error_message);
1930:
1931: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1932: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1933: hr_utility.raise_error;
1934:
1935: END update_federal_values;
1936:

Line 1933: hr_utility.raise_error;

1929: pay_emp_action_arch.set_error_message(lv_error_message);
1930:
1931: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1932: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1933: hr_utility.raise_error;
1934:
1935: END update_federal_values;
1936:
1937:

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

1950: lv_procedure_name VARCHAR2(100) := '.update_sit_values';
1951: lv_error_message VARCHAR2(200);
1952:
1953: BEGIN
1954: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1955: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1956: hr_utility.trace('p_balance = '|| p_balance);
1957: hr_utility.trace('p_bal_value = ' || p_bal_value);
1958:

Line 1955: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

1951: lv_error_message VARCHAR2(200);
1952:
1953: BEGIN
1954: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1955: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1956: hr_utility.trace('p_balance = '|| p_balance);
1957: hr_utility.trace('p_bal_value = ' || p_bal_value);
1958:
1959: if p_balance = 'SIT Withheld' then

Line 1956: hr_utility.trace('p_balance = '|| p_balance);

1952:
1953: BEGIN
1954: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1955: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1956: hr_utility.trace('p_balance = '|| p_balance);
1957: hr_utility.trace('p_bal_value = ' || p_bal_value);
1958:
1959: if p_balance = 'SIT Withheld' then
1960: pay_ac_action_arch.lrr_act_tab(p_index).act_info1

Line 1957: hr_utility.trace('p_bal_value = ' || p_bal_value);

1953: BEGIN
1954: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1955: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
1956: hr_utility.trace('p_balance = '|| p_balance);
1957: hr_utility.trace('p_bal_value = ' || p_bal_value);
1958:
1959: if p_balance = 'SIT Withheld' then
1960: pay_ac_action_arch.lrr_act_tab(p_index).act_info1
1961: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +

Line 1981: hr_utility.set_location(gv_package || lv_procedure_name, 100);

1977: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info17,0) +
1978: p_bal_value ;
1979: end if;
1980:
1981: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1982:
1983: EXCEPTION
1984: when others then
1985: lv_error_message := 'Error in ' ||

Line 1988: hr_utility.trace(lv_error_message || '-' || sqlerrm);

1984: when others then
1985: lv_error_message := 'Error in ' ||
1986: gv_package || lv_procedure_name;
1987:
1988: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1989:
1990: lv_error_message :=
1991: pay_emp_action_arch.set_error_message(lv_error_message);
1992:

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

1989:
1990: lv_error_message :=
1991: pay_emp_action_arch.set_error_message(lv_error_message);
1992:
1993: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1994: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1995: hr_utility.raise_error;
1996:
1997: END update_sit_values;

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

1990: lv_error_message :=
1991: pay_emp_action_arch.set_error_message(lv_error_message);
1992:
1993: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1994: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1995: hr_utility.raise_error;
1996:
1997: END update_sit_values;
1998:

Line 1995: hr_utility.raise_error;

1991: pay_emp_action_arch.set_error_message(lv_error_message);
1992:
1993: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1994: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1995: hr_utility.raise_error;
1996:
1997: END update_sit_values;
1998:
1999:

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

2012: lv_procedure_name VARCHAR2(100) := '.update_sdi_ee_values';
2013: lv_error_message VARCHAR2(200);
2014:
2015: BEGIN
2016: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2017: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2018: hr_utility.trace('p_balance = '|| p_balance);
2019: hr_utility.trace('p_bal_value = ' || p_bal_value);
2020:

Line 2017: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2013: lv_error_message VARCHAR2(200);
2014:
2015: BEGIN
2016: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2017: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2018: hr_utility.trace('p_balance = '|| p_balance);
2019: hr_utility.trace('p_bal_value = ' || p_bal_value);
2020:
2021: if p_balance = 'SDI EE Withheld' then

Line 2018: hr_utility.trace('p_balance = '|| p_balance);

2014:
2015: BEGIN
2016: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2017: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2018: hr_utility.trace('p_balance = '|| p_balance);
2019: hr_utility.trace('p_bal_value = ' || p_bal_value);
2020:
2021: if p_balance = 'SDI EE Withheld' then
2022: pay_ac_action_arch.lrr_act_tab(p_index).act_info5

Line 2019: hr_utility.trace('p_bal_value = ' || p_bal_value);

2015: BEGIN
2016: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2017: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2018: hr_utility.trace('p_balance = '|| p_balance);
2019: hr_utility.trace('p_bal_value = ' || p_bal_value);
2020:
2021: if p_balance = 'SDI EE Withheld' then
2022: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2023: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +

Line 2043: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2039: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info26,0) +
2040: p_bal_value ;
2041: end if;
2042:
2043: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2044:
2045: EXCEPTION
2046: when others then
2047: lv_error_message := 'Error in ' ||

Line 2050: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2046: when others then
2047: lv_error_message := 'Error in ' ||
2048: gv_package || lv_procedure_name;
2049:
2050: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2051:
2052: lv_error_message :=
2053: pay_emp_action_arch.set_error_message(lv_error_message);
2054:

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

2051:
2052: lv_error_message :=
2053: pay_emp_action_arch.set_error_message(lv_error_message);
2054:
2055: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2056: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2057: hr_utility.raise_error;
2058:
2059:

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

2052: lv_error_message :=
2053: pay_emp_action_arch.set_error_message(lv_error_message);
2054:
2055: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2056: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2057: hr_utility.raise_error;
2058:
2059:
2060: END update_sdi_ee_values;

Line 2057: hr_utility.raise_error;

2053: pay_emp_action_arch.set_error_message(lv_error_message);
2054:
2055: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2056: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2057: hr_utility.raise_error;
2058:
2059:
2060: END update_sdi_ee_values;
2061:

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

2076: lv_procedure_name VARCHAR2(100) := '.update_sdi_ee_values';
2077: lv_error_message VARCHAR2(200);
2078:
2079: BEGIN
2080: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2081: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2082: hr_utility.trace('p_balance = '|| p_balance);
2083: hr_utility.trace('p_bal_value = ' || p_bal_value);
2084:

Line 2081: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2077: lv_error_message VARCHAR2(200);
2078:
2079: BEGIN
2080: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2081: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2082: hr_utility.trace('p_balance = '|| p_balance);
2083: hr_utility.trace('p_bal_value = ' || p_bal_value);
2084:
2085: if p_balance = 'SDI ER Liability' then

Line 2082: hr_utility.trace('p_balance = '|| p_balance);

2078:
2079: BEGIN
2080: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2081: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2082: hr_utility.trace('p_balance = '|| p_balance);
2083: hr_utility.trace('p_bal_value = ' || p_bal_value);
2084:
2085: if p_balance = 'SDI ER Liability' then
2086: pay_ac_action_arch.lrr_act_tab(p_index).act_info9

Line 2083: hr_utility.trace('p_bal_value = ' || p_bal_value);

2079: BEGIN
2080: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2081: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2082: hr_utility.trace('p_balance = '|| p_balance);
2083: hr_utility.trace('p_bal_value = ' || p_bal_value);
2084:
2085: if p_balance = 'SDI ER Liability' then
2086: pay_ac_action_arch.lrr_act_tab(p_index).act_info9
2087: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info9,0) +

Line 2107: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2103: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info27,0) +
2104: p_bal_value;
2105: end if;
2106:
2107: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2108:
2109: EXCEPTION
2110: when others then
2111: lv_error_message := 'Error in ' ||

Line 2114: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2110: when others then
2111: lv_error_message := 'Error in ' ||
2112: gv_package || lv_procedure_name;
2113:
2114: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2115:
2116: lv_error_message :=
2117: pay_emp_action_arch.set_error_message(lv_error_message);
2118:

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

2115:
2116: lv_error_message :=
2117: pay_emp_action_arch.set_error_message(lv_error_message);
2118:
2119: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2120: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2121: hr_utility.raise_error;
2122:
2123: END update_sdi_er_values;

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

2116: lv_error_message :=
2117: pay_emp_action_arch.set_error_message(lv_error_message);
2118:
2119: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2120: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2121: hr_utility.raise_error;
2122:
2123: END update_sdi_er_values;
2124:

Line 2121: hr_utility.raise_error;

2117: pay_emp_action_arch.set_error_message(lv_error_message);
2118:
2119: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2120: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2121: hr_utility.raise_error;
2122:
2123: END update_sdi_er_values;
2124:
2125:

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

2138: lv_procedure_name VARCHAR2(100) := '.update_sui_ee_values';
2139: lv_error_message VARCHAR2(200);
2140:
2141: BEGIN
2142: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2143: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2144: hr_utility.trace('p_balance = '|| p_balance);
2145: hr_utility.trace('p_bal_value = ' || p_bal_value);
2146:

Line 2143: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2139: lv_error_message VARCHAR2(200);
2140:
2141: BEGIN
2142: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2143: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2144: hr_utility.trace('p_balance = '|| p_balance);
2145: hr_utility.trace('p_bal_value = ' || p_bal_value);
2146:
2147: if p_balance = 'SUI EE Withheld' then

Line 2144: hr_utility.trace('p_balance = '|| p_balance);

2140:
2141: BEGIN
2142: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2143: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2144: hr_utility.trace('p_balance = '|| p_balance);
2145: hr_utility.trace('p_bal_value = ' || p_bal_value);
2146:
2147: if p_balance = 'SUI EE Withheld' then
2148: pay_ac_action_arch.lrr_act_tab(p_index).act_info13

Line 2145: hr_utility.trace('p_bal_value = ' || p_bal_value);

2141: BEGIN
2142: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2143: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2144: hr_utility.trace('p_balance = '|| p_balance);
2145: hr_utility.trace('p_bal_value = ' || p_bal_value);
2146:
2147: if p_balance = 'SUI EE Withheld' then
2148: pay_ac_action_arch.lrr_act_tab(p_index).act_info13
2149: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info13,0) +

Line 2168: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2164: pay_ac_action_arch.lrr_act_tab(p_index).act_info28
2165: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info28,0) +
2166: p_bal_value;
2167: end if;
2168: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2169:
2170: EXCEPTION
2171: when others then
2172: lv_error_message := 'Error in ' ||

Line 2175: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2171: when others then
2172: lv_error_message := 'Error in ' ||
2173: gv_package || lv_procedure_name;
2174:
2175: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2176:
2177: lv_error_message :=
2178: pay_emp_action_arch.set_error_message(lv_error_message);
2179:

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

2176:
2177: lv_error_message :=
2178: pay_emp_action_arch.set_error_message(lv_error_message);
2179:
2180: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2181: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2182: hr_utility.raise_error;
2183:
2184: END update_sui_ee_values;

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

2177: lv_error_message :=
2178: pay_emp_action_arch.set_error_message(lv_error_message);
2179:
2180: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2181: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2182: hr_utility.raise_error;
2183:
2184: END update_sui_ee_values;
2185:

Line 2182: hr_utility.raise_error;

2178: pay_emp_action_arch.set_error_message(lv_error_message);
2179:
2180: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2181: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2182: hr_utility.raise_error;
2183:
2184: END update_sui_ee_values;
2185:
2186:

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

2199: lv_procedure_name VARCHAR2(100) := '.update_sui_er_values';
2200: lv_error_message VARCHAR2(200);
2201:
2202: BEGIN
2203: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2204: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2205: hr_utility.trace('p_balance = '|| p_balance);
2206: hr_utility.trace('p_bal_value = ' || p_bal_value);
2207:

Line 2204: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2200: lv_error_message VARCHAR2(200);
2201:
2202: BEGIN
2203: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2204: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2205: hr_utility.trace('p_balance = '|| p_balance);
2206: hr_utility.trace('p_bal_value = ' || p_bal_value);
2207:
2208: if p_balance = 'SUI ER Taxable' then

Line 2205: hr_utility.trace('p_balance = '|| p_balance);

2201:
2202: BEGIN
2203: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2204: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2205: hr_utility.trace('p_balance = '|| p_balance);
2206: hr_utility.trace('p_bal_value = ' || p_bal_value);
2207:
2208: if p_balance = 'SUI ER Taxable' then
2209: pay_ac_action_arch.lrr_act_tab(p_index).act_info18

Line 2206: hr_utility.trace('p_bal_value = ' || p_bal_value);

2202: BEGIN
2203: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2204: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2205: hr_utility.trace('p_balance = '|| p_balance);
2206: hr_utility.trace('p_bal_value = ' || p_bal_value);
2207:
2208: if p_balance = 'SUI ER Taxable' then
2209: pay_ac_action_arch.lrr_act_tab(p_index).act_info18
2210: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info18,0)

Line 2229: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2225: pay_ac_action_arch.lrr_act_tab(p_index).act_info29
2226: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info29,0)
2227: + p_bal_value;
2228: end if;
2229: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2230:
2231: EXCEPTION
2232: when others then
2233: lv_error_message := 'Error in ' ||

Line 2236: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2232: when others then
2233: lv_error_message := 'Error in ' ||
2234: gv_package || lv_procedure_name;
2235:
2236: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2237:
2238: lv_error_message :=
2239: pay_emp_action_arch.set_error_message(lv_error_message);
2240:

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

2237:
2238: lv_error_message :=
2239: pay_emp_action_arch.set_error_message(lv_error_message);
2240:
2241: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2242: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2243: hr_utility.raise_error;
2244:
2245: END update_sui_er_values;

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

2238: lv_error_message :=
2239: pay_emp_action_arch.set_error_message(lv_error_message);
2240:
2241: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2242: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2243: hr_utility.raise_error;
2244:
2245: END update_sui_er_values;
2246:

Line 2243: hr_utility.raise_error;

2239: pay_emp_action_arch.set_error_message(lv_error_message);
2240:
2241: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2242: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2243: hr_utility.raise_error;
2244:
2245: END update_sui_er_values;
2246:
2247:

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

2260: lv_procedure_name VARCHAR2(100) := '.update_work_comp_values';
2261: lv_error_message VARCHAR2(200);
2262:
2263: BEGIN
2264: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2265: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2266: hr_utility.trace('p_balance = '|| p_balance);
2267: hr_utility.trace('p_bal_value = ' || p_bal_value);
2268:

Line 2265: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2261: lv_error_message VARCHAR2(200);
2262:
2263: BEGIN
2264: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2265: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2266: hr_utility.trace('p_balance = '|| p_balance);
2267: hr_utility.trace('p_bal_value = ' || p_bal_value);
2268:
2269: if p_balance = 'Workers Comp Withheld' then

Line 2266: hr_utility.trace('p_balance = '|| p_balance);

2262:
2263: BEGIN
2264: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2265: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2266: hr_utility.trace('p_balance = '|| p_balance);
2267: hr_utility.trace('p_bal_value = ' || p_bal_value);
2268:
2269: if p_balance = 'Workers Comp Withheld' then
2270: pay_ac_action_arch.lrr_act_tab(p_index).act_info22

Line 2267: hr_utility.trace('p_bal_value = ' || p_bal_value);

2263: BEGIN
2264: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2265: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2266: hr_utility.trace('p_balance = '|| p_balance);
2267: hr_utility.trace('p_bal_value = ' || p_bal_value);
2268:
2269: if p_balance = 'Workers Comp Withheld' then
2270: pay_ac_action_arch.lrr_act_tab(p_index).act_info22
2271: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info22,0) +

Line 2286: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2282: pay_ac_action_arch.lrr_act_tab(p_index).act_info25
2283: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info25,0) +
2284: p_bal_value;
2285: end if;
2286: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2287:
2288: EXCEPTION
2289: when others then
2290: lv_error_message := 'Error in ' ||

Line 2293: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2289: when others then
2290: lv_error_message := 'Error in ' ||
2291: gv_package || lv_procedure_name;
2292:
2293: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2294:
2295: lv_error_message :=
2296: pay_emp_action_arch.set_error_message(lv_error_message);
2297:

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

2294:
2295: lv_error_message :=
2296: pay_emp_action_arch.set_error_message(lv_error_message);
2297:
2298: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2299: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2300: hr_utility.raise_error;
2301:
2302: END update_work_comp_values;

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

2295: lv_error_message :=
2296: pay_emp_action_arch.set_error_message(lv_error_message);
2297:
2298: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2299: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2300: hr_utility.raise_error;
2301:
2302: END update_work_comp_values;
2303:

Line 2300: hr_utility.raise_error;

2296: pay_emp_action_arch.set_error_message(lv_error_message);
2297:
2298: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2299: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2300: hr_utility.raise_error;
2301:
2302: END update_work_comp_values;
2303:
2304: /*Bug 3231253*/

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

2317: lv_procedure_name VARCHAR2(100) := '.update_steic_values';
2318: lv_error_message VARCHAR2(200);
2319:
2320: BEGIN
2321: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2322: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2323: hr_utility.trace('p_balance = '|| p_balance);
2324: hr_utility.trace('p_bal_value = ' || p_bal_value);
2325:

Line 2322: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2318: lv_error_message VARCHAR2(200);
2319:
2320: BEGIN
2321: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2322: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2323: hr_utility.trace('p_balance = '|| p_balance);
2324: hr_utility.trace('p_bal_value = ' || p_bal_value);
2325:
2326: if p_balance = 'STEIC Advance' then

Line 2323: hr_utility.trace('p_balance = '|| p_balance);

2319:
2320: BEGIN
2321: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2322: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2323: hr_utility.trace('p_balance = '|| p_balance);
2324: hr_utility.trace('p_bal_value = ' || p_bal_value);
2325:
2326: if p_balance = 'STEIC Advance' then
2327: pay_ac_action_arch.lrr_act_tab(p_index).act_info30

Line 2324: hr_utility.trace('p_bal_value = ' || p_bal_value);

2320: BEGIN
2321: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2322: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2323: hr_utility.trace('p_balance = '|| p_balance);
2324: hr_utility.trace('p_bal_value = ' || p_bal_value);
2325:
2326: if p_balance = 'STEIC Advance' then
2327: pay_ac_action_arch.lrr_act_tab(p_index).act_info30
2328: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info30,0) +

Line 2332: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2328: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info30,0) +
2329: p_bal_value ;
2330: end if;
2331:
2332: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2333:
2334: EXCEPTION
2335: when others then
2336: lv_error_message := 'Error in ' ||

Line 2339: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2335: when others then
2336: lv_error_message := 'Error in ' ||
2337: gv_package || lv_procedure_name;
2338:
2339: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2340:
2341: lv_error_message :=
2342: pay_emp_action_arch.set_error_message(lv_error_message);
2343:

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

2340:
2341: lv_error_message :=
2342: pay_emp_action_arch.set_error_message(lv_error_message);
2343:
2344: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2345: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2346: hr_utility.raise_error;
2347:
2348: END update_steic_values;

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

2341: lv_error_message :=
2342: pay_emp_action_arch.set_error_message(lv_error_message);
2343:
2344: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2345: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2346: hr_utility.raise_error;
2347:
2348: END update_steic_values;
2349:

Line 2346: hr_utility.raise_error;

2342: pay_emp_action_arch.set_error_message(lv_error_message);
2343:
2344: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2345: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2346: hr_utility.raise_error;
2347:
2348: END update_steic_values;
2349:
2350:

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

2363: lv_procedure_name VARCHAR2(100) := '.update_county_values';
2364: lv_error_message VARCHAR2(200);
2365:
2366: BEGIN
2367: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2368: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2369: hr_utility.trace('p_balance = '|| p_balance);
2370: hr_utility.trace('p_bal_value = ' || p_bal_value);
2371:

Line 2368: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2364: lv_error_message VARCHAR2(200);
2365:
2366: BEGIN
2367: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2368: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2369: hr_utility.trace('p_balance = '|| p_balance);
2370: hr_utility.trace('p_bal_value = ' || p_bal_value);
2371:
2372: if p_balance = 'County Withheld' then

Line 2369: hr_utility.trace('p_balance = '|| p_balance);

2365:
2366: BEGIN
2367: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2368: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2369: hr_utility.trace('p_balance = '|| p_balance);
2370: hr_utility.trace('p_bal_value = ' || p_bal_value);
2371:
2372: if p_balance = 'County Withheld' then
2373: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1

Line 2370: hr_utility.trace('p_bal_value = ' || p_bal_value);

2366: BEGIN
2367: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2368: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2369: hr_utility.trace('p_balance = '|| p_balance);
2370: hr_utility.trace('p_bal_value = ' || p_bal_value);
2371:
2372: if p_balance = 'County Withheld' then
2373: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2374: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +

Line 2393: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2389: pay_ac_action_arch.lrr_act_tab(p_index).act_info7
2390: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2391: p_bal_value ;
2392: end if;
2393: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2394:
2395: EXCEPTION
2396: when others then
2397: lv_error_message := 'Error in ' ||

Line 2400: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2396: when others then
2397: lv_error_message := 'Error in ' ||
2398: gv_package || lv_procedure_name;
2399:
2400: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2401:
2402: lv_error_message :=
2403: pay_emp_action_arch.set_error_message(lv_error_message);
2404:

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

2401:
2402: lv_error_message :=
2403: pay_emp_action_arch.set_error_message(lv_error_message);
2404:
2405: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2406: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2407: hr_utility.raise_error;
2408:
2409: END update_county_values;

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

2402: lv_error_message :=
2403: pay_emp_action_arch.set_error_message(lv_error_message);
2404:
2405: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2406: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2407: hr_utility.raise_error;
2408:
2409: END update_county_values;
2410:

Line 2407: hr_utility.raise_error;

2403: pay_emp_action_arch.set_error_message(lv_error_message);
2404:
2405: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2406: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2407: hr_utility.raise_error;
2408:
2409: END update_county_values;
2410:
2411:

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

2424: lv_procedure_name VARCHAR2(100) := '.update_county_head_values';
2425: lv_error_message VARCHAR2(200);
2426:
2427: BEGIN
2428: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2429: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2430: hr_utility.trace('p_balance = '|| p_balance);
2431: hr_utility.trace('p_bal_value = ' || p_bal_value);
2432:

Line 2429: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2425: lv_error_message VARCHAR2(200);
2426:
2427: BEGIN
2428: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2429: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2430: hr_utility.trace('p_balance = '|| p_balance);
2431: hr_utility.trace('p_bal_value = ' || p_bal_value);
2432:
2433: if p_balance = 'Head Tax Liability' then

Line 2430: hr_utility.trace('p_balance = '|| p_balance);

2426:
2427: BEGIN
2428: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2429: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2430: hr_utility.trace('p_balance = '|| p_balance);
2431: hr_utility.trace('p_bal_value = ' || p_bal_value);
2432:
2433: if p_balance = 'Head Tax Liability' then
2434: pay_ac_action_arch.lrr_act_tab(p_index).act_info5

Line 2431: hr_utility.trace('p_bal_value = ' || p_bal_value);

2427: BEGIN
2428: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2429: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2430: hr_utility.trace('p_balance = '|| p_balance);
2431: hr_utility.trace('p_bal_value = ' || p_bal_value);
2432:
2433: if p_balance = 'Head Tax Liability' then
2434: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2435: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +

Line 2442: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2438: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2439: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2440: p_bal_value;
2441: end if;
2442: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2443:
2444: EXCEPTION
2445: when others then
2446: lv_error_message := 'Error in ' ||

Line 2449: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2445: when others then
2446: lv_error_message := 'Error in ' ||
2447: gv_package || lv_procedure_name;
2448:
2449: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2450:
2451: lv_error_message :=
2452: pay_emp_action_arch.set_error_message(lv_error_message);
2453:

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

2450:
2451: lv_error_message :=
2452: pay_emp_action_arch.set_error_message(lv_error_message);
2453:
2454: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2455: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2456: hr_utility.raise_error;
2457:
2458: END update_county_head_values;

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

2451: lv_error_message :=
2452: pay_emp_action_arch.set_error_message(lv_error_message);
2453:
2454: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2455: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2456: hr_utility.raise_error;
2457:
2458: END update_county_head_values;
2459:

Line 2456: hr_utility.raise_error;

2452: pay_emp_action_arch.set_error_message(lv_error_message);
2453:
2454: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2455: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2456: hr_utility.raise_error;
2457:
2458: END update_county_head_values;
2459:
2460:

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

2473: lv_procedure_name VARCHAR2(100) := '.update_city_values';
2474: lv_error_message VARCHAR2(200);
2475:
2476: BEGIN
2477: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2478: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2479: hr_utility.trace('p_balance = '|| p_balance);
2480: hr_utility.trace('p_bal_value = ' || p_bal_value);
2481:

Line 2478: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2474: lv_error_message VARCHAR2(200);
2475:
2476: BEGIN
2477: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2478: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2479: hr_utility.trace('p_balance = '|| p_balance);
2480: hr_utility.trace('p_bal_value = ' || p_bal_value);
2481:
2482: if p_balance = 'City Withheld' then

Line 2479: hr_utility.trace('p_balance = '|| p_balance);

2475:
2476: BEGIN
2477: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2478: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2479: hr_utility.trace('p_balance = '|| p_balance);
2480: hr_utility.trace('p_bal_value = ' || p_bal_value);
2481:
2482: if p_balance = 'City Withheld' then
2483: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1

Line 2480: hr_utility.trace('p_bal_value = ' || p_bal_value);

2476: BEGIN
2477: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2478: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2479: hr_utility.trace('p_balance = '|| p_balance);
2480: hr_utility.trace('p_bal_value = ' || p_bal_value);
2481:
2482: if p_balance = 'City Withheld' then
2483: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2484: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +

Line 2503: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2499: pay_ac_action_arch.lrr_act_tab(p_index ).act_info7
2500: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info7,0) +
2501: p_bal_value;
2502: end if;
2503: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2504:
2505: EXCEPTION
2506: when others then
2507: lv_error_message := 'Error in ' ||

Line 2510: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2506: when others then
2507: lv_error_message := 'Error in ' ||
2508: gv_package || lv_procedure_name;
2509:
2510: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2511:
2512: lv_error_message :=
2513: pay_emp_action_arch.set_error_message(lv_error_message);
2514:

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

2511:
2512: lv_error_message :=
2513: pay_emp_action_arch.set_error_message(lv_error_message);
2514:
2515: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2516: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2517: hr_utility.raise_error;
2518:
2519: END update_city_values;

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

2512: lv_error_message :=
2513: pay_emp_action_arch.set_error_message(lv_error_message);
2514:
2515: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2516: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2517: hr_utility.raise_error;
2518:
2519: END update_city_values;
2520:

Line 2517: hr_utility.raise_error;

2513: pay_emp_action_arch.set_error_message(lv_error_message);
2514:
2515: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2516: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2517: hr_utility.raise_error;
2518:
2519: END update_city_values;
2520:
2521:

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

2534: lv_procedure_name VARCHAR2(100) := '.update_city_head_values';
2535: lv_error_message VARCHAR2(200);
2536:
2537: BEGIN
2538: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2539: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2540: hr_utility.trace('p_balance = '|| p_balance);
2541: hr_utility.trace('p_bal_value = ' || p_bal_value);
2542:

Line 2539: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2535: lv_error_message VARCHAR2(200);
2536:
2537: BEGIN
2538: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2539: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2540: hr_utility.trace('p_balance = '|| p_balance);
2541: hr_utility.trace('p_bal_value = ' || p_bal_value);
2542:
2543: if p_balance = 'Head Tax Liability' then

Line 2540: hr_utility.trace('p_balance = '|| p_balance);

2536:
2537: BEGIN
2538: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2539: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2540: hr_utility.trace('p_balance = '|| p_balance);
2541: hr_utility.trace('p_bal_value = ' || p_bal_value);
2542:
2543: if p_balance = 'Head Tax Liability' then
2544: pay_ac_action_arch.lrr_act_tab(p_index).act_info5

Line 2541: hr_utility.trace('p_bal_value = ' || p_bal_value);

2537: BEGIN
2538: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2539: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2540: hr_utility.trace('p_balance = '|| p_balance);
2541: hr_utility.trace('p_bal_value = ' || p_bal_value);
2542:
2543: if p_balance = 'Head Tax Liability' then
2544: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2545: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +

Line 2552: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2548: pay_ac_action_arch.lrr_act_tab(p_index).act_info6
2549: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info6,0) +
2550: p_bal_value;
2551: end if;
2552: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2553:
2554: EXCEPTION
2555: when others then
2556: lv_error_message := 'Error in ' ||

Line 2559: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2555: when others then
2556: lv_error_message := 'Error in ' ||
2557: gv_package || lv_procedure_name;
2558:
2559: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2560:
2561: lv_error_message :=
2562: pay_emp_action_arch.set_error_message(lv_error_message);
2563:

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

2560:
2561: lv_error_message :=
2562: pay_emp_action_arch.set_error_message(lv_error_message);
2563:
2564: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2565: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2566: hr_utility.raise_error;
2567:
2568: END update_city_head_values;

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

2561: lv_error_message :=
2562: pay_emp_action_arch.set_error_message(lv_error_message);
2563:
2564: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2565: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2566: hr_utility.raise_error;
2567:
2568: END update_city_head_values;
2569:

Line 2566: hr_utility.raise_error;

2562: pay_emp_action_arch.set_error_message(lv_error_message);
2563:
2564: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2565: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2566: hr_utility.raise_error;
2567:
2568: END update_city_head_values;
2569:
2570:

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

2583: lv_procedure_name VARCHAR2(100) := '.update_school_values';
2584: lv_error_message VARCHAR2(200);
2585:
2586: BEGIN
2587: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2588: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2589: hr_utility.trace('p_balance = '|| p_balance);
2590: hr_utility.trace('p_bal_value = ' || p_bal_value);
2591:

Line 2588: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);

2584: lv_error_message VARCHAR2(200);
2585:
2586: BEGIN
2587: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2588: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2589: hr_utility.trace('p_balance = '|| p_balance);
2590: hr_utility.trace('p_bal_value = ' || p_bal_value);
2591:
2592: if p_balance = 'School Withheld' then

Line 2589: hr_utility.trace('p_balance = '|| p_balance);

2585:
2586: BEGIN
2587: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2588: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2589: hr_utility.trace('p_balance = '|| p_balance);
2590: hr_utility.trace('p_bal_value = ' || p_bal_value);
2591:
2592: if p_balance = 'School Withheld' then
2593: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1

Line 2590: hr_utility.trace('p_bal_value = ' || p_bal_value);

2586: BEGIN
2587: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2588: hr_utility.trace('p_index = '|| pay_ac_action_arch.lrr_act_tab.count);
2589: hr_utility.trace('p_balance = '|| p_balance);
2590: hr_utility.trace('p_bal_value = ' || p_bal_value);
2591:
2592: if p_balance = 'School Withheld' then
2593: pay_ac_action_arch.lrr_act_tab(p_index ).act_info1
2594: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info1,0) +

Line 2613: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2609: pay_ac_action_arch.lrr_act_tab(p_index).act_info5
2610: := nvl(pay_ac_action_arch.lrr_act_tab(p_index).act_info5,0) +
2611: p_bal_value;
2612: end if;
2613: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2614:
2615: EXCEPTION
2616: when others then
2617: lv_error_message := 'Error in ' ||

Line 2620: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2616: when others then
2617: lv_error_message := 'Error in ' ||
2618: gv_package || lv_procedure_name;
2619:
2620: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2621:
2622: lv_error_message :=
2623: pay_emp_action_arch.set_error_message(lv_error_message);
2624:

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

2621:
2622: lv_error_message :=
2623: pay_emp_action_arch.set_error_message(lv_error_message);
2624:
2625: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2626: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2627: hr_utility.raise_error;
2628:
2629: END update_school_values;

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

2622: lv_error_message :=
2623: pay_emp_action_arch.set_error_message(lv_error_message);
2624:
2625: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2626: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2627: hr_utility.raise_error;
2628:
2629: END update_school_values;
2630:

Line 2627: hr_utility.raise_error;

2623: pay_emp_action_arch.set_error_message(lv_error_message);
2624:
2625: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2626: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2627: hr_utility.raise_error;
2628:
2629: END update_school_values;
2630:
2631:

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

2646: lv_procedure_name VARCHAR2(100) := '.get_city_tax_info';
2647: lv_error_message VARCHAR2(200);
2648:
2649: BEGIN
2650: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2651: lv_city_tax_exists := pay_us_payroll_utils.get_tax_exists(
2652: p_tax_type => 'CITY'
2653: ,p_jurisdiction_code => p_emp_city_jurisdiction
2654: ,p_effective_date => p_effective_date) ;

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

2659: ,p_effective_date => p_effective_date) ;
2660:
2661: p_city_tax_exists := lv_city_tax_exists ;
2662: p_city_head_tax_exists := lv_city_head_tax_exists;
2663: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2664:
2665: EXCEPTION
2666: when others then
2667: lv_error_message := 'Error in ' ||

Line 2670: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2666: when others then
2667: lv_error_message := 'Error in ' ||
2668: gv_package || lv_procedure_name;
2669:
2670: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2671:
2672: lv_error_message :=
2673: pay_emp_action_arch.set_error_message(lv_error_message);
2674:

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

2671:
2672: lv_error_message :=
2673: pay_emp_action_arch.set_error_message(lv_error_message);
2674:
2675: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2676: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2677: hr_utility.raise_error;
2678:
2679: END get_city_tax_info;

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

2672: lv_error_message :=
2673: pay_emp_action_arch.set_error_message(lv_error_message);
2674:
2675: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2676: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2677: hr_utility.raise_error;
2678:
2679: END get_city_tax_info;
2680:

Line 2677: hr_utility.raise_error;

2673: pay_emp_action_arch.set_error_message(lv_error_message);
2674:
2675: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2676: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2677: hr_utility.raise_error;
2678:
2679: END get_city_tax_info;
2680:
2681:

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

2717: lv_procedure_name VARCHAR2(100) := '.get_school_parent_jd';
2718: lv_error_message VARCHAR2(200);
2719:
2720: BEGIN
2721: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2722: open c_get_city_school_district;
2723: fetch c_get_city_school_district into lv_parent_jurisdiction_code ;
2724: if c_get_city_school_district%notfound then
2725: hr_utility.set_location(gv_package || lv_procedure_name, 20);

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

2721: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2722: open c_get_city_school_district;
2723: fetch c_get_city_school_district into lv_parent_jurisdiction_code ;
2724: if c_get_city_school_district%notfound then
2725: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2726: open c_get_county_school_district;
2727: fetch c_get_county_school_district into lv_parent_jurisdiction_code ;
2728: close c_get_county_school_district;
2729: end if;

Line 2732: hr_utility.trace('lv_parent_jurisdiction_code = '||

2728: close c_get_county_school_district;
2729: end if;
2730: close c_get_city_school_district;
2731:
2732: hr_utility.trace('lv_parent_jurisdiction_code = '||
2733: lv_parent_jurisdiction_code);
2734: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2735:
2736: return(lv_parent_jurisdiction_code);

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

2730: close c_get_city_school_district;
2731:
2732: hr_utility.trace('lv_parent_jurisdiction_code = '||
2733: lv_parent_jurisdiction_code);
2734: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2735:
2736: return(lv_parent_jurisdiction_code);
2737: EXCEPTION
2738: when others then

Line 2742: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2738: when others then
2739: lv_error_message := 'Error in ' ||
2740: gv_package || lv_procedure_name;
2741:
2742: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2743:
2744: lv_error_message :=
2745: pay_emp_action_arch.set_error_message(lv_error_message);
2746:

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

2743:
2744: lv_error_message :=
2745: pay_emp_action_arch.set_error_message(lv_error_message);
2746:
2747: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2748: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2749: hr_utility.raise_error;
2750:
2751: END get_school_parent_jd;

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

2744: lv_error_message :=
2745: pay_emp_action_arch.set_error_message(lv_error_message);
2746:
2747: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2748: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2749: hr_utility.raise_error;
2750:
2751: END get_school_parent_jd;
2752:

Line 2749: hr_utility.raise_error;

2745: pay_emp_action_arch.set_error_message(lv_error_message);
2746:
2747: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2748: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2749: hr_utility.raise_error;
2750:
2751: END get_school_parent_jd;
2752:
2753:

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

2808: lv_procedure_name VARCHAR2(100) := '.get_emp_residence';
2809: lv_error_message VARCHAR2(200);
2810:
2811: BEGIN
2812: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2813: /* get the assignments resident city,county,state jurisdictions */
2814: open c_get_emp_res_dtls(p_assignment_id
2815: ,p_run_effective_date);
2816: fetch c_get_emp_res_dtls into lv_resident_county,

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

2828:
2829: p_resident_state_jd := lv_resident_state_jd;
2830: p_resident_county_jd := lv_resident_cnty_jd;
2831: p_resident_city_jd := lv_resident_city_jd;
2832: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2833:
2834: EXCEPTION
2835: when others then
2836: lv_error_message := 'Error in ' ||

Line 2839: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2835: when others then
2836: lv_error_message := 'Error in ' ||
2837: gv_package || lv_procedure_name;
2838:
2839: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2840:
2841: lv_error_message :=
2842: pay_emp_action_arch.set_error_message(lv_error_message);
2843:

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

2840:
2841: lv_error_message :=
2842: pay_emp_action_arch.set_error_message(lv_error_message);
2843:
2844: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2845: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2846: hr_utility.raise_error;
2847:
2848: END get_emp_residence;

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

2841: lv_error_message :=
2842: pay_emp_action_arch.set_error_message(lv_error_message);
2843:
2844: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2845: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2846: hr_utility.raise_error;
2847:
2848: END get_emp_residence;
2849:

Line 2846: hr_utility.raise_error;

2842: pay_emp_action_arch.set_error_message(lv_error_message);
2843:
2844: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2845: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2846: hr_utility.raise_error;
2847:
2848: END get_emp_residence;
2849:
2850:

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

2895: lv_procedure_name VARCHAR2(100) := '.update_ytd_withheld';
2896: lv_error_message VARCHAR2(200);
2897:
2898: BEGIN
2899: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2900: if p_curr_withheld <> 0 or p_ytd_withheld <> 0 then -- Bug 3561821
2901:
2902: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2903: hr_utility.trace('ln_index = ' || ln_index);

Line 2903: hr_utility.trace('ln_index = ' || ln_index);

2899: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2900: if p_curr_withheld <> 0 or p_ytd_withheld <> 0 then -- Bug 3561821
2901:
2902: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2903: hr_utility.trace('ln_index = ' || ln_index);
2904:
2905: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2906: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2907: := 'Tax Deductions';

Line 2940: hr_utility.trace('get_display_name inside if' || lv_display_name);

2936: FETCH get_display_name INTO lv_display_name ;
2937: IF get_display_name%FOUND THEN
2938: IF substr(lv_display_name , -7,5) = 'BLANK' THEN
2939: lv_display_name := substr(lv_display_name , 1, length(lv_display_name)-8);
2940: hr_utility.trace('get_display_name inside if' || lv_display_name);
2941: END IF;
2942: ELSE
2943: lv_display_name := ' ';
2944: END IF;

Line 2951: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2947: END IF;
2948: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
2949: := lv_display_name ;
2950: end if;
2951: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2952:
2953: EXCEPTION
2954: when others then
2955: lv_error_message := 'Error in ' ||

Line 2958: hr_utility.trace(lv_error_message || '-' || sqlerrm);

2954: when others then
2955: lv_error_message := 'Error in ' ||
2956: gv_package || lv_procedure_name;
2957:
2958: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2959:
2960: lv_error_message :=
2961: pay_emp_action_arch.set_error_message(lv_error_message);
2962:

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

2959:
2960: lv_error_message :=
2961: pay_emp_action_arch.set_error_message(lv_error_message);
2962:
2963: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2964: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2965: hr_utility.raise_error;
2966:
2967: END update_ytd_withheld;

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

2960: lv_error_message :=
2961: pay_emp_action_arch.set_error_message(lv_error_message);
2962:
2963: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2964: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2965: hr_utility.raise_error;
2966:
2967: END update_ytd_withheld;
2968:

Line 2965: hr_utility.raise_error;

2961: pay_emp_action_arch.set_error_message(lv_error_message);
2962:
2963: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2964: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2965: hr_utility.raise_error;
2966:
2967: END update_ytd_withheld;
2968:
2969:

Line 3007: hr_utility.trace('ln_table_index = '|| ln_table_index);

3003:
3004: if lv_index_flag <> 'Y' then
3005: ln_table_index := pay_ac_action_arch.lrr_act_tab.count;
3006: end if;
3007: hr_utility.trace('ln_table_index = '|| ln_table_index);
3008:
3009: return(ln_table_index);
3010:
3011: END get_table_index;

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

3075: lv_error_message VARCHAR2(200);
3076: ln_step NUMBER;
3077:
3078: BEGIN
3079: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3080: ln_step := 1;
3081:
3082: ln_index := get_table_index('00-000-0000');
3083:

Line 3084: hr_utility.trace('Fed Loop Count = ' || ln_index);

3080: ln_step := 1;
3081:
3082: ln_index := get_table_index('00-000-0000');
3083:
3084: hr_utility.trace('Fed Loop Count = ' || ln_index);
3085: for i in pay_us_action_arch.ltr_fed_tax_bal.first..
3086: pay_us_action_arch.ltr_fed_tax_bal.last LOOP
3087:
3088: lv_balance_name

Line 3099: hr_utility.trace('lv_balance_name = ' || lv_balance_name);

3095: := pay_us_action_arch.ltr_fed_tax_bal(i).ytd_def_bal_id;
3096: ln_run_def_bal_id
3097: := pay_us_action_arch.ltr_fed_tax_bal(i).asg_run_def_bal_id;
3098:
3099: hr_utility.trace('lv_balance_name = ' || lv_balance_name);
3100: hr_utility.trace('ln_pymt_def_bal_id = ' || ln_pymt_def_bal_id);
3101: hr_utility.trace('ln_ytd_def_bal_id = ' || ln_ytd_def_bal_id);
3102: hr_utility.trace('ln_run_def_bal_id = ' || ln_run_def_bal_id);
3103:

Line 3100: hr_utility.trace('ln_pymt_def_bal_id = ' || ln_pymt_def_bal_id);

3096: ln_run_def_bal_id
3097: := pay_us_action_arch.ltr_fed_tax_bal(i).asg_run_def_bal_id;
3098:
3099: hr_utility.trace('lv_balance_name = ' || lv_balance_name);
3100: hr_utility.trace('ln_pymt_def_bal_id = ' || ln_pymt_def_bal_id);
3101: hr_utility.trace('ln_ytd_def_bal_id = ' || ln_ytd_def_bal_id);
3102: hr_utility.trace('ln_run_def_bal_id = ' || ln_run_def_bal_id);
3103:
3104: ln_step := 5;

Line 3101: hr_utility.trace('ln_ytd_def_bal_id = ' || ln_ytd_def_bal_id);

3097: := pay_us_action_arch.ltr_fed_tax_bal(i).asg_run_def_bal_id;
3098:
3099: hr_utility.trace('lv_balance_name = ' || lv_balance_name);
3100: hr_utility.trace('ln_pymt_def_bal_id = ' || ln_pymt_def_bal_id);
3101: hr_utility.trace('ln_ytd_def_bal_id = ' || ln_ytd_def_bal_id);
3102: hr_utility.trace('ln_run_def_bal_id = ' || ln_run_def_bal_id);
3103:
3104: ln_step := 5;
3105: if p_action_type in ( 'U', 'P') then

Line 3102: hr_utility.trace('ln_run_def_bal_id = ' || ln_run_def_bal_id);

3098:
3099: hr_utility.trace('lv_balance_name = ' || lv_balance_name);
3100: hr_utility.trace('ln_pymt_def_bal_id = ' || ln_pymt_def_bal_id);
3101: hr_utility.trace('ln_ytd_def_bal_id = ' || ln_ytd_def_bal_id);
3102: hr_utility.trace('ln_run_def_bal_id = ' || ln_run_def_bal_id);
3103:
3104: ln_step := 5;
3105: if p_action_type in ( 'U', 'P') then
3106: if lv_balance_name not in ('SS ER Taxable',

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

3107: /*'SS ER Liability',
3108: 'Medicare ER Liability',*/
3109: 'Medicare ER Taxable',
3110: 'Non W2 FIT Withheld') then
3111: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3112:
3113: ln_step := 6;
3114: ln_bal_value := get_balance_value(
3115: p_defined_balance_id => ln_pymt_def_bal_id

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

3132: -- := pay_ac_action_arch.lrr_act_tab(ln_index).act_info14;
3133: end if;
3134:
3135: else
3136: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3137: ln_step := 10;
3138: ln_bal_value := get_balance_value(
3139: p_defined_balance_id => ln_run_def_bal_id
3140: ,p_balcall_aaid => p_rqp_action_id);

Line 3143: hr_utility.trace('ln_bal_value is'||to_char(ln_bal_value));

3139: p_defined_balance_id => ln_run_def_bal_id
3140: ,p_balcall_aaid => p_rqp_action_id);
3141: end if;
3142:
3143: hr_utility.trace('ln_bal_value is'||to_char(ln_bal_value));
3144: update_federal_values(p_balance => lv_balance_name
3145: ,p_bal_value => ln_bal_value
3146: ,p_index => ln_index
3147: ,p_category => 'US FEDERAL');

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

3145: ,p_bal_value => ln_bal_value
3146: ,p_index => ln_index
3147: ,p_category => 'US FEDERAL');
3148:
3149: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3150:
3151: /*****************************************************************
3152: ** Insert data for Payslip
3153: ******************************************************************/

Line 3215: hr_utility.set_location(gv_package || lv_procedure_name||

3211: elsif lv_balance_name = 'Non W2 FIT Withheld' then
3212:
3213: ln_step := 18;
3214: if check_alien(p_xfr_action_id) = 'TRUE' then
3215: hr_utility.set_location(gv_package || lv_procedure_name||
3216: ' Chk Alien ', 20);
3217:
3218: ln_bal_value := get_balance_value(
3219: p_defined_balance_id => ln_pymt_def_bal_id

Line 3224: hr_utility.trace('NonW2FIT Pymt def balid = ' ||

3220: ,p_balcall_aaid => p_pymt_balcall_aaid);
3221:
3222: ln_curr_withheld := ln_bal_value;
3223:
3224: hr_utility.trace('NonW2FIT Pymt def balid = ' ||
3225: to_char(ln_pymt_def_bal_id));
3226: hr_utility.trace('NonW2FIT Cur = ' ||
3227: to_char(ln_curr_withheld));
3228:

Line 3226: hr_utility.trace('NonW2FIT Cur = ' ||

3222: ln_curr_withheld := ln_bal_value;
3223:
3224: hr_utility.trace('NonW2FIT Pymt def balid = ' ||
3225: to_char(ln_pymt_def_bal_id));
3226: hr_utility.trace('NonW2FIT Cur = ' ||
3227: to_char(ln_curr_withheld));
3228:
3229: ln_ytd_withheld := get_balance_value(
3230: p_defined_balance_id => ln_ytd_def_bal_id

Line 3233: hr_utility.trace('NonW2FIT YTD def balid = ' ||

3229: ln_ytd_withheld := get_balance_value(
3230: p_defined_balance_id => ln_ytd_def_bal_id
3231: ,p_balcall_aaid => p_ytd_balcall_aaid);
3232:
3233: hr_utility.trace('NonW2FIT YTD def balid = ' ||
3234: to_char(ln_ytd_def_bal_id));
3235: hr_utility.trace('NonW2FIT YTD = ' ||
3236: to_char(ln_ytd_withheld));
3237:

Line 3235: hr_utility.trace('NonW2FIT YTD = ' ||

3231: ,p_balcall_aaid => p_ytd_balcall_aaid);
3232:
3233: hr_utility.trace('NonW2FIT YTD def balid = ' ||
3234: to_char(ln_ytd_def_bal_id));
3235: hr_utility.trace('NonW2FIT YTD = ' ||
3236: to_char(ln_ytd_withheld));
3237:
3238: update_ytd_withheld(
3239: p_xfr_action_id => p_xfr_action_id

Line 3250: hr_utility.set_location(gv_package || lv_procedure_name, 100);

3246: end if;
3247:
3248: end loop;
3249:
3250: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3251: ln_step := 20;
3252:
3253: EXCEPTION
3254: when others then

Line 3258: hr_utility.trace(lv_error_message || '-' || sqlerrm);

3254: when others then
3255: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
3256: gv_package || lv_procedure_name;
3257:
3258: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3259:
3260: lv_error_message :=
3261: pay_emp_action_arch.set_error_message(lv_error_message);
3262:

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

3259:
3260: lv_error_message :=
3261: pay_emp_action_arch.set_error_message(lv_error_message);
3262:
3263: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3264: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3265: hr_utility.raise_error;
3266:
3267: END populate_federal_tax_balances;

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

3260: lv_error_message :=
3261: pay_emp_action_arch.set_error_message(lv_error_message);
3262:
3263: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3264: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3265: hr_utility.raise_error;
3266:
3267: END populate_federal_tax_balances;
3268:

Line 3265: hr_utility.raise_error;

3261: pay_emp_action_arch.set_error_message(lv_error_message);
3262:
3263: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3264: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3265: hr_utility.raise_error;
3266:
3267: END populate_federal_tax_balances;
3268:
3269:

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

3306:
3307:
3308: BEGIN
3309: ln_step := 1;
3310: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3311:
3312: hr_utility.trace('State Balance Loop Count = ' ||
3313: p_jurisdiction_tab.count);
3314: if p_jurisdiction_tab.count > 0 then

Line 3312: hr_utility.trace('State Balance Loop Count = ' ||

3308: BEGIN
3309: ln_step := 1;
3310: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3311:
3312: hr_utility.trace('State Balance Loop Count = ' ||
3313: p_jurisdiction_tab.count);
3314: if p_jurisdiction_tab.count > 0 then
3315: /*(*/
3316: for i in p_jurisdiction_tab.first..

Line 3339: hr_utility.trace('p_action_type = ' || p_action_type);

3335: lv_sdi_er_exists
3336: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists;
3337: end if;
3338:
3339: hr_utility.trace('p_action_type = ' || p_action_type);
3340: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
3341: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
3342: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
3343: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);

Line 3340: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);

3336: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists;
3337: end if;
3338:
3339: hr_utility.trace('p_action_type = ' || p_action_type);
3340: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
3341: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
3342: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
3343: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
3344: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);

Line 3341: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);

3337: end if;
3338:
3339: hr_utility.trace('p_action_type = ' || p_action_type);
3340: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
3341: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
3342: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
3343: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
3344: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
3345: hr_utility.trace('Archiving for Jurisdiction = ' ||

Line 3342: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);

3338:
3339: hr_utility.trace('p_action_type = ' || p_action_type);
3340: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
3341: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
3342: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
3343: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
3344: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
3345: hr_utility.trace('Archiving for Jurisdiction = ' ||
3346: p_jurisdiction_tab(i).emp_jd);

Line 3343: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);

3339: hr_utility.trace('p_action_type = ' || p_action_type);
3340: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
3341: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
3342: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
3343: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
3344: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
3345: hr_utility.trace('Archiving for Jurisdiction = ' ||
3346: p_jurisdiction_tab(i).emp_jd);
3347:

Line 3344: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);

3340: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);
3341: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
3342: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
3343: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
3344: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
3345: hr_utility.trace('Archiving for Jurisdiction = ' ||
3346: p_jurisdiction_tab(i).emp_jd);
3347:
3348: pay_balance_pkg.set_context('JURISDICTION_CODE',

Line 3345: hr_utility.trace('Archiving for Jurisdiction = ' ||

3341: hr_utility.trace('lv_sui_ee_exists = ' || lv_sui_ee_exists);
3342: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
3343: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
3344: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
3345: hr_utility.trace('Archiving for Jurisdiction = ' ||
3346: p_jurisdiction_tab(i).emp_jd);
3347:
3348: pay_balance_pkg.set_context('JURISDICTION_CODE',
3349: p_jurisdiction_tab(i).emp_jd);

Line 3357: hr_utility.trace('ln_index for state is '||to_char(ln_index));

3353: ln_ytd_withheld := 0;
3354:
3355: ln_step := 2;
3356: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd);
3357: hr_utility.trace('ln_index for state is '||to_char(ln_index));
3358:
3359: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3360: := 'US STATE';
3361: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 3374: hr_utility.trace('lv_balance_name =' || lv_balance_name);

3370: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3371: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3372: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3373:
3374: hr_utility.trace('lv_balance_name =' || lv_balance_name);
3375: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);
3376: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
3377: hr_utility.trace('ln_run_def_bal_id =' || ln_run_def_bal_id);
3378:

Line 3375: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);

3371: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3372: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3373:
3374: hr_utility.trace('lv_balance_name =' || lv_balance_name);
3375: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);
3376: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
3377: hr_utility.trace('ln_run_def_bal_id =' || ln_run_def_bal_id);
3378:
3379: --SIT

Line 3376: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);

3372: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3373:
3374: hr_utility.trace('lv_balance_name =' || lv_balance_name);
3375: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);
3376: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
3377: hr_utility.trace('ln_run_def_bal_id =' || ln_run_def_bal_id);
3378:
3379: --SIT
3380: ln_step := 3;

Line 3377: hr_utility.trace('ln_run_def_bal_id =' || ln_run_def_bal_id);

3373:
3374: hr_utility.trace('lv_balance_name =' || lv_balance_name);
3375: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);
3376: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);
3377: hr_utility.trace('ln_run_def_bal_id =' || ln_run_def_bal_id);
3378:
3379: --SIT
3380: ln_step := 3;
3381: if substr(lv_balance_name, 1,3) = 'SIT' then

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

3379: --SIT
3380: ln_step := 3;
3381: if substr(lv_balance_name, 1,3) = 'SIT' then
3382: if lv_sit_exists = 'Y' then
3383: hr_utility.set_location(gv_package || lv_procedure_name,
3384: 110);
3385: if p_action_type in ('U', 'P') then
3386: -- SIT Alien
3387: if lv_balance_name = 'SIT Alien Withheld' then

Line 3396: hr_utility.trace('NonW2SIT Cur = ' || ln_curr_withheld);

3392: p_defined_balance_id => ln_pymt_def_bal_id
3393: ,p_balcall_aaid => p_pymt_balcall_aaid);
3394:
3395: ln_curr_withheld := ln_bal_value;
3396: hr_utility.trace('NonW2SIT Cur = ' || ln_curr_withheld);
3397:
3398: ln_ytd_withheld := get_balance_value(
3399: p_defined_balance_id => ln_ytd_def_bal_id
3400: ,p_balcall_aaid => p_ytd_balcall_aaid);

Line 3401: hr_utility.trace('NonW2SIT YTD = ' || ln_ytd_withheld);

3397:
3398: ln_ytd_withheld := get_balance_value(
3399: p_defined_balance_id => ln_ytd_def_bal_id
3400: ,p_balcall_aaid => p_ytd_balcall_aaid);
3401: hr_utility.trace('NonW2SIT YTD = ' || ln_ytd_withheld);
3402:
3403: update_ytd_withheld(
3404: p_xfr_action_id => p_xfr_action_id
3405: ,p_balance_name => lv_balance_name

Line 3443: hr_utility.trace('ln_bal_value = ' || ln_bal_value);

3439: p_defined_balance_id => ln_run_def_bal_id
3440: ,p_balcall_aaid => p_rqp_action_id);
3441: end if;
3442:
3443: hr_utility.trace('ln_bal_value = ' || ln_bal_value);
3444: ln_step := 8;
3445: update_sit_values(p_balance => lv_balance_name
3446: ,p_bal_value => ln_bal_value
3447: ,p_index => ln_index);

Line 3602: hr_utility.trace('State Balance value is '|| ln_bal_value);

3598: ln_bal_value := get_balance_value(
3599: p_defined_balance_id => ln_run_def_bal_id
3600: ,p_balcall_aaid => p_rqp_action_id);
3601: end if;
3602: hr_utility.trace('State Balance value is '|| ln_bal_value);
3603:
3604: update_work_comp_values(p_balance => lv_balance_name
3605: ,p_bal_value => ln_bal_value
3606: ,p_index => ln_index);

Line 3640: hr_utility.trace('STEIC State Balance value is '|| ln_bal_value);

3636: ln_bal_value := get_balance_value(
3637: p_defined_balance_id => ln_run_def_bal_id
3638: ,p_balcall_aaid => p_rqp_action_id);
3639: end if;
3640: hr_utility.trace('STEIC State Balance value is '|| ln_bal_value);
3641:
3642: update_steic_values(p_balance => lv_balance_name
3643: ,p_bal_value => ln_bal_value
3644: ,p_index => ln_index);

Line 3655: hr_utility.set_location(gv_package || lv_procedure_name, 150);

3651: end if; -- of ltr_state_tax_bal.taxtype
3652: end loop; -- )state jurisdiction loop
3653: end if;
3654:
3655: hr_utility.set_location(gv_package || lv_procedure_name, 150);
3656:
3657: EXCEPTION
3658: when others then
3659: lv_error_message := 'Error at step ' || ln_step || ' in ' ||

Line 3662: hr_utility.trace(lv_error_message || '-' || sqlerrm);

3658: when others then
3659: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
3660: gv_package || lv_procedure_name;
3661:
3662: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3663:
3664: lv_error_message :=
3665: pay_emp_action_arch.set_error_message(lv_error_message);
3666:

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

3663:
3664: lv_error_message :=
3665: pay_emp_action_arch.set_error_message(lv_error_message);
3666:
3667: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3668: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3669: hr_utility.raise_error;
3670:
3671: END populate_state_tax_balances;

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

3664: lv_error_message :=
3665: pay_emp_action_arch.set_error_message(lv_error_message);
3666:
3667: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3668: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3669: hr_utility.raise_error;
3670:
3671: END populate_state_tax_balances;
3672:

Line 3669: hr_utility.raise_error;

3665: pay_emp_action_arch.set_error_message(lv_error_message);
3666:
3667: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3668: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3669: hr_utility.raise_error;
3670:
3671: END populate_state_tax_balances;
3672:
3673:

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

3708: ln_step NUMBER;
3709:
3710:
3711: BEGIN
3712: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3713: hr_utility.trace('County Balance Loop Count = ' ||
3714: pay_us_action_arch.ltr_county_tax_bal.count);
3715:
3716: if p_jurisdiction_tab.count > 0 then

Line 3713: hr_utility.trace('County Balance Loop Count = ' ||

3709:
3710:
3711: BEGIN
3712: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3713: hr_utility.trace('County Balance Loop Count = ' ||
3714: pay_us_action_arch.ltr_county_tax_bal.count);
3715:
3716: if p_jurisdiction_tab.count > 0 then
3717: for i in p_jurisdiction_tab.first..

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

3716: if p_jurisdiction_tab.count > 0 then
3717: for i in p_jurisdiction_tab.first..
3718: p_jurisdiction_tab.last loop
3719:
3720: hr_utility.set_location(gv_package || lv_procedure_name, 160);
3721: if pay_us_action_arch.ltr_county_tax_info.count > 0 then
3722: if p_action_type = 'B' then
3723: lv_county_tax_exists := 'Y';
3724: lv_county_head_tax_exists := 'Y';

Line 3740: hr_utility.trace('COUNTY lv_county_tax_exists = ' ||

3736: end loop;
3737: end if;
3738: end if;
3739:
3740: hr_utility.trace('COUNTY lv_county_tax_exists = ' ||
3741: lv_county_tax_exists);
3742: hr_utility.trace('COUNTY lv_county_head_tax_exists = ' ||
3743: lv_county_head_tax_exists);
3744: hr_utility.trace('COUNTY Archiving for Jurisdiction = ' ||

Line 3742: hr_utility.trace('COUNTY lv_county_head_tax_exists = ' ||

3738: end if;
3739:
3740: hr_utility.trace('COUNTY lv_county_tax_exists = ' ||
3741: lv_county_tax_exists);
3742: hr_utility.trace('COUNTY lv_county_head_tax_exists = ' ||
3743: lv_county_head_tax_exists);
3744: hr_utility.trace('COUNTY Archiving for Jurisdiction = ' ||
3745: p_jurisdiction_tab(i).emp_jd);
3746:

Line 3744: hr_utility.trace('COUNTY Archiving for Jurisdiction = ' ||

3740: hr_utility.trace('COUNTY lv_county_tax_exists = ' ||
3741: lv_county_tax_exists);
3742: hr_utility.trace('COUNTY lv_county_head_tax_exists = ' ||
3743: lv_county_head_tax_exists);
3744: hr_utility.trace('COUNTY Archiving for Jurisdiction = ' ||
3745: p_jurisdiction_tab(i).emp_jd);
3746:
3747: pay_balance_pkg.set_context('JURISDICTION_CODE',
3748: p_jurisdiction_tab(i).emp_jd);

Line 3773: hr_utility.trace('lv_balance_name = '||lv_balance_name);

3769: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
3770: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
3771: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
3772:
3773: hr_utility.trace('lv_balance_name = '||lv_balance_name);
3774: hr_utility.trace('ln_pymt_def_bal_id = '||ln_pymt_def_bal_id);
3775: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);
3776: hr_utility.trace('ln_run_def_bal_id = '||ln_run_def_bal_id);
3777:

Line 3774: hr_utility.trace('ln_pymt_def_bal_id = '||ln_pymt_def_bal_id);

3770: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
3771: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
3772:
3773: hr_utility.trace('lv_balance_name = '||lv_balance_name);
3774: hr_utility.trace('ln_pymt_def_bal_id = '||ln_pymt_def_bal_id);
3775: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);
3776: hr_utility.trace('ln_run_def_bal_id = '||ln_run_def_bal_id);
3777:
3778: if substr(lv_balance_name, 1, 6) = 'County' then

Line 3775: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);

3771: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
3772:
3773: hr_utility.trace('lv_balance_name = '||lv_balance_name);
3774: hr_utility.trace('ln_pymt_def_bal_id = '||ln_pymt_def_bal_id);
3775: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);
3776: hr_utility.trace('ln_run_def_bal_id = '||ln_run_def_bal_id);
3777:
3778: if substr(lv_balance_name, 1, 6) = 'County' then
3779: if lv_county_tax_exists = 'Y' then

Line 3776: hr_utility.trace('ln_run_def_bal_id = '||ln_run_def_bal_id);

3772:
3773: hr_utility.trace('lv_balance_name = '||lv_balance_name);
3774: hr_utility.trace('ln_pymt_def_bal_id = '||ln_pymt_def_bal_id);
3775: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);
3776: hr_utility.trace('ln_run_def_bal_id = '||ln_run_def_bal_id);
3777:
3778: if substr(lv_balance_name, 1, 6) = 'County' then
3779: if lv_county_tax_exists = 'Y' then
3780: if p_action_type in ( 'U', 'P') then

Line 3856: hr_utility.set_location(gv_package || lv_procedure_name, 100);

3852: end if; -- ltr_county_tax_bal
3853:
3854: end loop; -- of jurisdiction)
3855: end if; -- of jurisdiction)
3856: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3857:
3858: EXCEPTION
3859: when others then
3860: lv_error_message := 'Error in ' ||

Line 3863: hr_utility.trace(lv_error_message || '-' || sqlerrm);

3859: when others then
3860: lv_error_message := 'Error in ' ||
3861: gv_package || lv_procedure_name;
3862:
3863: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3864:
3865: lv_error_message :=
3866: pay_emp_action_arch.set_error_message(lv_error_message);
3867:

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

3864:
3865: lv_error_message :=
3866: pay_emp_action_arch.set_error_message(lv_error_message);
3867:
3868: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3869: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3870: hr_utility.raise_error;
3871: END populate_county_tax_balances;
3872:

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

3865: lv_error_message :=
3866: pay_emp_action_arch.set_error_message(lv_error_message);
3867:
3868: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3869: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3870: hr_utility.raise_error;
3871: END populate_county_tax_balances;
3872:
3873:

Line 3870: hr_utility.raise_error;

3866: pay_emp_action_arch.set_error_message(lv_error_message);
3867:
3868: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3869: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3870: hr_utility.raise_error;
3871: END populate_county_tax_balances;
3872:
3873:
3874: /******************************************************************

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

3909: ln_step NUMBER;
3910:
3911:
3912: BEGIN
3913: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3914:
3915: if p_jurisdiction_tab.count > 0 then
3916: for i in p_jurisdiction_tab.first..
3917: p_jurisdiction_tab.last loop

Line 3928: hr_utility.trace('CITY Archiving for Jurisdiction = ' ||

3924: lv_city_tax_exists,
3925: lv_city_head_tax_exists);
3926: end if;
3927:
3928: hr_utility.trace('CITY Archiving for Jurisdiction = ' ||
3929: p_jurisdiction_tab(i).emp_jd);
3930:
3931: pay_balance_pkg.set_context('JURISDICTION_CODE',
3932: p_jurisdiction_tab(i).emp_jd);

Line 3935: hr_utility.trace('Index = '|| ln_index);

3931: pay_balance_pkg.set_context('JURISDICTION_CODE',
3932: p_jurisdiction_tab(i).emp_jd);
3933:
3934: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd);
3935: hr_utility.trace('Index = '|| ln_index);
3936:
3937: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3938: := p_jurisdiction_tab(i).emp_jd;
3939: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

Line 3973: hr_utility.trace('lv_balance_name ='||lv_balance_name);

3969: pay_us_action_arch.ltr_city_tax_bal(k).ytd_def_bal_id;
3970: ln_run_def_bal_id :=
3971: pay_us_action_arch.ltr_city_tax_bal(k).asg_run_def_bal_id;
3972:
3973: hr_utility.trace('lv_balance_name ='||lv_balance_name);
3974: hr_utility.trace('ln_pymt_def_bal_id='||ln_pymt_def_bal_id);
3975: hr_utility.trace('ln_ytd_def_bal_id ='||ln_ytd_def_bal_id);
3976: hr_utility.trace('ln_run_def_bal_id ='||ln_run_def_bal_id);
3977:

Line 3974: hr_utility.trace('ln_pymt_def_bal_id='||ln_pymt_def_bal_id);

3970: ln_run_def_bal_id :=
3971: pay_us_action_arch.ltr_city_tax_bal(k).asg_run_def_bal_id;
3972:
3973: hr_utility.trace('lv_balance_name ='||lv_balance_name);
3974: hr_utility.trace('ln_pymt_def_bal_id='||ln_pymt_def_bal_id);
3975: hr_utility.trace('ln_ytd_def_bal_id ='||ln_ytd_def_bal_id);
3976: hr_utility.trace('ln_run_def_bal_id ='||ln_run_def_bal_id);
3977:
3978: if substr(lv_balance_name,1,4) = 'City' then

Line 3975: hr_utility.trace('ln_ytd_def_bal_id ='||ln_ytd_def_bal_id);

3971: pay_us_action_arch.ltr_city_tax_bal(k).asg_run_def_bal_id;
3972:
3973: hr_utility.trace('lv_balance_name ='||lv_balance_name);
3974: hr_utility.trace('ln_pymt_def_bal_id='||ln_pymt_def_bal_id);
3975: hr_utility.trace('ln_ytd_def_bal_id ='||ln_ytd_def_bal_id);
3976: hr_utility.trace('ln_run_def_bal_id ='||ln_run_def_bal_id);
3977:
3978: if substr(lv_balance_name,1,4) = 'City' then
3979: if lv_city_tax_exists = 'Y' then

Line 3976: hr_utility.trace('ln_run_def_bal_id ='||ln_run_def_bal_id);

3972:
3973: hr_utility.trace('lv_balance_name ='||lv_balance_name);
3974: hr_utility.trace('ln_pymt_def_bal_id='||ln_pymt_def_bal_id);
3975: hr_utility.trace('ln_ytd_def_bal_id ='||ln_ytd_def_bal_id);
3976: hr_utility.trace('ln_run_def_bal_id ='||ln_run_def_bal_id);
3977:
3978: if substr(lv_balance_name,1,4) = 'City' then
3979: if lv_city_tax_exists = 'Y' then
3980: if p_action_type in ('U', 'P') then

Line 4004: hr_utility.trace('ln_bal_value = '|| ln_bal_value);

4000: ln_bal_value := get_balance_value(
4001: p_defined_balance_id => ln_run_def_bal_id
4002: ,p_balcall_aaid => p_rqp_action_id);
4003: end if;
4004: hr_utility.trace('ln_bal_value = '|| ln_bal_value);
4005:
4006: update_city_values(
4007: p_balance => lv_balance_name
4008: ,p_bal_value => ln_bal_value

Line 4039: hr_utility.trace('ln_bal_value = '|| ln_bal_value);

4035: ln_bal_value := get_balance_value(
4036: p_defined_balance_id => ln_run_def_bal_id
4037: ,p_balcall_aaid => p_rqp_action_id);
4038: end if;
4039: hr_utility.trace('ln_bal_value = '|| ln_bal_value);
4040:
4041: update_city_head_values(
4042: p_balance => lv_balance_name
4043: ,p_bal_value => ln_bal_value

Line 4057: hr_utility.set_location(gv_package || lv_procedure_name, 100);

4053: end if; -- ltr_city_tax_bal
4054: end loop; -- of city jurisdiction
4055: end if; -- of city jurisdiction
4056:
4057: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4058:
4059: EXCEPTION
4060: when others then
4061: lv_error_message := 'Error in ' ||

Line 4064: hr_utility.trace(lv_error_message || '-' || sqlerrm);

4060: when others then
4061: lv_error_message := 'Error in ' ||
4062: gv_package || lv_procedure_name;
4063:
4064: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4065:
4066: lv_error_message :=
4067: pay_emp_action_arch.set_error_message(lv_error_message);
4068:

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

4065:
4066: lv_error_message :=
4067: pay_emp_action_arch.set_error_message(lv_error_message);
4068:
4069: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4070: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4071: hr_utility.raise_error;
4072: END populate_city_tax_balances;
4073:

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

4066: lv_error_message :=
4067: pay_emp_action_arch.set_error_message(lv_error_message);
4068:
4069: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4070: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4071: hr_utility.raise_error;
4072: END populate_city_tax_balances;
4073:
4074: /******************************************************************

Line 4071: hr_utility.raise_error;

4067: pay_emp_action_arch.set_error_message(lv_error_message);
4068:
4069: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4070: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4071: hr_utility.raise_error;
4072: END populate_city_tax_balances;
4073:
4074: /******************************************************************
4075: Name : populate_school_tax_balances

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

4102: lv_procedure_name VARCHAR2(100) := '.populate_school_tax_balances';
4103: lv_error_message VARCHAR2(200);
4104:
4105: BEGIN
4106: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4107:
4108: if p_jurisdiction_tab.count > 0 then
4109: for j in p_jurisdiction_tab.first..
4110: p_jurisdiction_tab.last loop

Line 4112: hr_utility.trace(' Archiving for School Dist = ' ||

4108: if p_jurisdiction_tab.count > 0 then
4109: for j in p_jurisdiction_tab.first..
4110: p_jurisdiction_tab.last loop
4111:
4112: hr_utility.trace(' Archiving for School Dist = ' ||
4113: p_jurisdiction_tab(j).emp_jd);
4114: hr_utility.trace(' Parent JD for School Dist = ' ||
4115: p_jurisdiction_tab(j).emp_parent_jd);
4116:

Line 4114: hr_utility.trace(' Parent JD for School Dist = ' ||

4110: p_jurisdiction_tab.last loop
4111:
4112: hr_utility.trace(' Archiving for School Dist = ' ||
4113: p_jurisdiction_tab(j).emp_jd);
4114: hr_utility.trace(' Parent JD for School Dist = ' ||
4115: p_jurisdiction_tab(j).emp_parent_jd);
4116:
4117: pay_balance_pkg.set_context('JURISDICTION_CODE',
4118: p_jurisdiction_tab(j).emp_jd);

Line 4145: hr_utility.trace('lv_balance_name = '||lv_balance_name);

4141: := pay_us_action_arch.ltr_schdist_tax_bal(k).ytd_def_bal_id;
4142: ln_run_def_bal_id
4143: := pay_us_action_arch.ltr_schdist_tax_bal(k).asg_run_def_bal_id;
4144:
4145: hr_utility.trace('lv_balance_name = '||lv_balance_name);
4146: hr_utility.trace('ln_pymt_def_bal_id= '||ln_pymt_def_bal_id);
4147: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);
4148: hr_utility.trace('ln_run_def_bal_id = '||ln_run_def_bal_id);
4149:

Line 4146: hr_utility.trace('ln_pymt_def_bal_id= '||ln_pymt_def_bal_id);

4142: ln_run_def_bal_id
4143: := pay_us_action_arch.ltr_schdist_tax_bal(k).asg_run_def_bal_id;
4144:
4145: hr_utility.trace('lv_balance_name = '||lv_balance_name);
4146: hr_utility.trace('ln_pymt_def_bal_id= '||ln_pymt_def_bal_id);
4147: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);
4148: hr_utility.trace('ln_run_def_bal_id = '||ln_run_def_bal_id);
4149:
4150: if p_action_type in ( 'U', 'P') then

Line 4147: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);

4143: := pay_us_action_arch.ltr_schdist_tax_bal(k).asg_run_def_bal_id;
4144:
4145: hr_utility.trace('lv_balance_name = '||lv_balance_name);
4146: hr_utility.trace('ln_pymt_def_bal_id= '||ln_pymt_def_bal_id);
4147: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);
4148: hr_utility.trace('ln_run_def_bal_id = '||ln_run_def_bal_id);
4149:
4150: if p_action_type in ( 'U', 'P') then
4151: ln_bal_value := get_balance_value(

Line 4148: hr_utility.trace('ln_run_def_bal_id = '||ln_run_def_bal_id);

4144:
4145: hr_utility.trace('lv_balance_name = '||lv_balance_name);
4146: hr_utility.trace('ln_pymt_def_bal_id= '||ln_pymt_def_bal_id);
4147: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);
4148: hr_utility.trace('ln_run_def_bal_id = '||ln_run_def_bal_id);
4149:
4150: if p_action_type in ( 'U', 'P') then
4151: ln_bal_value := get_balance_value(
4152: p_defined_balance_id => ln_pymt_def_bal_id

Line 4174: hr_utility.trace('ln_bal_value for school dist is '||

4170: p_defined_balance_id => ln_run_def_bal_id
4171: ,p_balcall_aaid => p_rqp_action_id);
4172: end if;
4173:
4174: hr_utility.trace('ln_bal_value for school dist is '||
4175: ln_bal_value);
4176:
4177: update_school_values(
4178: p_balance => lv_balance_name

Line 4190: hr_utility.set_location(gv_package || lv_procedure_name, 100);

4186: end loop; -- ltr_schdist_tax_bal
4187: end if; -- ltr_schdist_tax_bal
4188: end loop; -- of sd jurisdiction
4189: end if; -- of sd jurisdiction
4190: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4191:
4192: EXCEPTION
4193: when others then
4194: lv_error_message := 'Error in ' ||

Line 4197: hr_utility.trace(lv_error_message || '-' || sqlerrm);

4193: when others then
4194: lv_error_message := 'Error in ' ||
4195: gv_package || lv_procedure_name;
4196:
4197: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4198:
4199: lv_error_message :=
4200: pay_emp_action_arch.set_error_message(lv_error_message);
4201:

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

4198:
4199: lv_error_message :=
4200: pay_emp_action_arch.set_error_message(lv_error_message);
4201:
4202: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4203: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4204: hr_utility.raise_error;
4205: END populate_school_tax_balances;
4206:

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

4199: lv_error_message :=
4200: pay_emp_action_arch.set_error_message(lv_error_message);
4201:
4202: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4203: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4204: hr_utility.raise_error;
4205: END populate_school_tax_balances;
4206:
4207: /*********************************************************************

Line 4204: hr_utility.raise_error;

4200: pay_emp_action_arch.set_error_message(lv_error_message);
4201:
4202: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4203: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4204: hr_utility.raise_error;
4205: END populate_school_tax_balances;
4206:
4207: /*********************************************************************
4208: Name : check_tax_exists

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

4245:
4246: BEGIN
4247:
4248: ln_step := 1;
4249: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4250:
4251: if length(p_jurisdiction_code) > 8 then
4252: if length(p_jurisdiction_code) = 11 and
4253: substr(p_jurisdiction_code, 4) = '000-0000' then

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

4251: if length(p_jurisdiction_code) > 8 then
4252: if length(p_jurisdiction_code) = 11 and
4253: substr(p_jurisdiction_code, 4) = '000-0000' then
4254:
4255: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4256: ln_step := 2;
4257: lv_tax_type(1) := 'SIT_WK';
4258: lv_tax_type(2) := 'SIT_RS';
4259: lv_tax_type(3) := 'SUI';

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

4282: elsif length(p_jurisdiction_code) = 11 and
4283: substr(p_jurisdiction_code,8) = '0000' and
4284: substr(p_jurisdiction_code,4,3) <> '000' then
4285:
4286: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4287: ln_step := 5;
4288: lv_tax_type(1) := 'COUNTY_WK';
4289: lv_tax_type(2) := 'COUNTY_RS';
4290:

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

4311:
4312: elsif length(p_jurisdiction_code) = 11 and
4313: substr(p_jurisdiction_code,8) <> '0000' then
4314:
4315: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4316: ln_step := 8;
4317: lv_tax_type(1) := 'CITY_WK';
4318: lv_tax_type(2) := 'CITY_RS';
4319: lv_tax_type(3) := 'HT_WK';

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

4335: open c_get_head_tax(p_jurisdiction_code,p_run_effective_date);
4336: lv_tax_exists := ' ';
4337: fetch c_get_head_tax into lv_tax_exists;
4338: if c_get_head_tax%notfound then
4339: hr_utility.set_location(gv_package||lv_procedure_name,10);
4340: lv_error_message := 'No row in JIT Tables ' ||
4341: 'for this Jurisdiction ';
4342: lv_tax_exists := 'N';
4343: --hr_utility.raise_error;

Line 4343: --hr_utility.raise_error;

4339: hr_utility.set_location(gv_package||lv_procedure_name,10);
4340: lv_error_message := 'No row in JIT Tables ' ||
4341: 'for this Jurisdiction ';
4342: lv_tax_exists := 'N';
4343: --hr_utility.raise_error;
4344: end if;
4345: close c_get_head_tax;
4346:
4347: end if;

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

4358: end if;
4359:
4360: elsif length(p_jurisdiction_code) = 8 then
4361:
4362: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4363: ln_step := 11;
4364: lv_tax_exists := 'Y';
4365: return(lv_tax_exists);
4366:

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

4365: return(lv_tax_exists);
4366:
4367: end if;
4368:
4369: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4370: return(lv_tax_exists);
4371:
4372: EXCEPTION
4373: when others then

Line 4377: hr_utility.trace(lv_error_message || '-' || sqlerrm);

4373: when others then
4374: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
4375: gv_package || lv_procedure_name;
4376:
4377: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4378:
4379: lv_error_message :=
4380: pay_emp_action_arch.set_error_message(lv_error_message);
4381:

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

4378:
4379: lv_error_message :=
4380: pay_emp_action_arch.set_error_message(lv_error_message);
4381:
4382: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4383: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4384: hr_utility.raise_error;
4385:
4386: END check_tax_exists;

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

4379: lv_error_message :=
4380: pay_emp_action_arch.set_error_message(lv_error_message);
4381:
4382: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4383: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4384: hr_utility.raise_error;
4385:
4386: END check_tax_exists;
4387:

Line 4384: hr_utility.raise_error;

4380: pay_emp_action_arch.set_error_message(lv_error_message);
4381:
4382: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4383: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4384: hr_utility.raise_error;
4385:
4386: END check_tax_exists;
4387:
4388: /******************************************************************

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

4441: lv_procedure_name VARCHAR2(100) := '.populate_puv_tax_balances';
4442: lv_error_message VARCHAR2(200);
4443:
4444: BEGIN
4445: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4446:
4447: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
4448:
4449: /*****************************************************************

Line 4454: hr_utility.trace('c_get_rr_jd parameters are---------');

4450: ** Get Jurisdictions from pay_run_results for all locked actions
4451: ** actions of the U,P,V case and then populating different PLSQL
4452: ** tables for State, County, City, School Dist
4453: *****************************************************************/
4454: hr_utility.trace('c_get_rr_jd parameters are---------');
4455: hr_utility.trace('p_rqp_action_id = '||p_rqp_action_id);
4456: hr_utility.trace('p_assignment_id = '||p_assignment_id);
4457: hr_utility.trace('p_sepchk_run_type_id = '||p_sepchk_run_type_id);
4458: hr_utility.trace('p_run_effective_date = '||p_run_effective_date);

Line 4455: hr_utility.trace('p_rqp_action_id = '||p_rqp_action_id);

4451: ** actions of the U,P,V case and then populating different PLSQL
4452: ** tables for State, County, City, School Dist
4453: *****************************************************************/
4454: hr_utility.trace('c_get_rr_jd parameters are---------');
4455: hr_utility.trace('p_rqp_action_id = '||p_rqp_action_id);
4456: hr_utility.trace('p_assignment_id = '||p_assignment_id);
4457: hr_utility.trace('p_sepchk_run_type_id = '||p_sepchk_run_type_id);
4458: hr_utility.trace('p_run_effective_date = '||p_run_effective_date);
4459: hr_utility.trace('-----------------------------------------');

Line 4456: hr_utility.trace('p_assignment_id = '||p_assignment_id);

4452: ** tables for State, County, City, School Dist
4453: *****************************************************************/
4454: hr_utility.trace('c_get_rr_jd parameters are---------');
4455: hr_utility.trace('p_rqp_action_id = '||p_rqp_action_id);
4456: hr_utility.trace('p_assignment_id = '||p_assignment_id);
4457: hr_utility.trace('p_sepchk_run_type_id = '||p_sepchk_run_type_id);
4458: hr_utility.trace('p_run_effective_date = '||p_run_effective_date);
4459: hr_utility.trace('-----------------------------------------');
4460:

Line 4457: hr_utility.trace('p_sepchk_run_type_id = '||p_sepchk_run_type_id);

4453: *****************************************************************/
4454: hr_utility.trace('c_get_rr_jd parameters are---------');
4455: hr_utility.trace('p_rqp_action_id = '||p_rqp_action_id);
4456: hr_utility.trace('p_assignment_id = '||p_assignment_id);
4457: hr_utility.trace('p_sepchk_run_type_id = '||p_sepchk_run_type_id);
4458: hr_utility.trace('p_run_effective_date = '||p_run_effective_date);
4459: hr_utility.trace('-----------------------------------------');
4460:
4461: open c_get_jd( p_assignment_id

Line 4458: hr_utility.trace('p_run_effective_date = '||p_run_effective_date);

4454: hr_utility.trace('c_get_rr_jd parameters are---------');
4455: hr_utility.trace('p_rqp_action_id = '||p_rqp_action_id);
4456: hr_utility.trace('p_assignment_id = '||p_assignment_id);
4457: hr_utility.trace('p_sepchk_run_type_id = '||p_sepchk_run_type_id);
4458: hr_utility.trace('p_run_effective_date = '||p_run_effective_date);
4459: hr_utility.trace('-----------------------------------------');
4460:
4461: open c_get_jd( p_assignment_id
4462: ,p_tax_unit_id );

Line 4459: hr_utility.trace('-----------------------------------------');

4455: hr_utility.trace('p_rqp_action_id = '||p_rqp_action_id);
4456: hr_utility.trace('p_assignment_id = '||p_assignment_id);
4457: hr_utility.trace('p_sepchk_run_type_id = '||p_sepchk_run_type_id);
4458: hr_utility.trace('p_run_effective_date = '||p_run_effective_date);
4459: hr_utility.trace('-----------------------------------------');
4460:
4461: open c_get_jd( p_assignment_id
4462: ,p_tax_unit_id );
4463:

Line 4472: hr_utility.trace('lv_rr_jurisdiction_code = '||lv_rr_jurisdiction_code);

4468: if check_tax_exists(p_assignment_id, p_tax_unit_id,
4469: p_run_effective_date, lv_rr_jurisdiction_code) = 'Y'
4470: then
4471:
4472: hr_utility.trace('lv_rr_jurisdiction_code = '||lv_rr_jurisdiction_code);
4473:
4474: /*************************************************************
4475: ** Populate the PLSQL table emp_state_jd with this jd
4476: *************************************************************/

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

4522: end if;
4523: end loop;
4524: close c_get_jd;
4525:
4526: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4527:
4528:
4529: /*****************************************************************
4530: ** Get Employee Resident Jurisdiction

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

4546: ,p_pymt_balcall_aaid => p_pymt_balcall_aaid
4547: ,p_ytd_balcall_aaid => p_ytd_balcall_aaid
4548: ,p_rqp_action_id => p_rqp_action_id
4549: ,p_action_type => p_action_type);
4550: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4551:
4552: /*****************************************************************
4553: ** State Information Archiving
4554: *****************************************************************/

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

4558: ,p_ytd_balcall_aaid => p_ytd_balcall_aaid
4559: ,p_rqp_action_id => p_rqp_action_id
4560: ,p_action_type => p_action_type
4561: ,p_jurisdiction_tab => pay_ac_action_arch.emp_state_jd);
4562: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4563:
4564: /*****************************************************************
4565: ** County Information Archiving
4566: *****************************************************************/

Line 4610: hr_utility.trace(lv_error_message || '-' || sqlerrm);

4606: when others then
4607: lv_error_message := 'Error in ' ||
4608: gv_package || lv_procedure_name;
4609:
4610: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4611:
4612: lv_error_message :=
4613: pay_emp_action_arch.set_error_message(lv_error_message);
4614:

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

4611:
4612: lv_error_message :=
4613: pay_emp_action_arch.set_error_message(lv_error_message);
4614:
4615: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4616: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4617: hr_utility.raise_error;
4618:
4619: END populate_puv_tax_balances;

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

4612: lv_error_message :=
4613: pay_emp_action_arch.set_error_message(lv_error_message);
4614:
4615: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4616: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4617: hr_utility.raise_error;
4618:
4619: END populate_puv_tax_balances;
4620:

Line 4617: hr_utility.raise_error;

4613: pay_emp_action_arch.set_error_message(lv_error_message);
4614:
4615: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4616: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4617: hr_utility.raise_error;
4618:
4619: END populate_puv_tax_balances;
4620:
4621:

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

4666: lv_procedure_name VARCHAR2(100) := '.populate_adj_tax_balances';
4667: lv_error_message VARCHAR2(200);
4668:
4669: BEGIN
4670: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4671:
4672: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
4673:
4674: open c_get_emp_adjbal(p_xfr_action_id);

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

4674: open c_get_emp_adjbal(p_xfr_action_id);
4675: loop
4676: fetch c_get_emp_adjbal into ln_baladj_action_id;
4677: if c_get_emp_adjbal%notfound then
4678: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4679: exit;
4680: end if;
4681: hr_utility.trace('ln_baladj_action_id = '|| ln_baladj_action_id);
4682:

Line 4681: hr_utility.trace('ln_baladj_action_id = '|| ln_baladj_action_id);

4677: if c_get_emp_adjbal%notfound then
4678: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4679: exit;
4680: end if;
4681: hr_utility.trace('ln_baladj_action_id = '|| ln_baladj_action_id);
4682:
4683: open c_get_baladj_jd(ln_baladj_action_id
4684: ,p_run_effective_date);
4685: loop

Line 4688: hr_utility.set_location(gv_package || '.archive_date', 222);

4684: ,p_run_effective_date);
4685: loop
4686: fetch c_get_baladj_jd into lv_baladj_jurisdiction_code;
4687: if c_get_baladj_jd%notfound or lv_baladj_jurisdiction_code is null then
4688: hr_utility.set_location(gv_package || '.archive_date', 222);
4689: exit;
4690: end if;
4691: hr_utility.trace('lv_baladj_jurisdiction_code = '||
4692: lv_baladj_jurisdiction_code);

Line 4691: hr_utility.trace('lv_baladj_jurisdiction_code = '||

4687: if c_get_baladj_jd%notfound or lv_baladj_jurisdiction_code is null then
4688: hr_utility.set_location(gv_package || '.archive_date', 222);
4689: exit;
4690: end if;
4691: hr_utility.trace('lv_baladj_jurisdiction_code = '||
4692: lv_baladj_jurisdiction_code);
4693:
4694: /*************************************************************
4695: ** Populate the PLSQL table emp_state_jd with this jd

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

4732: pay_ac_action_arch.emp_school_jd(ln_index).emp_parent_jd := lv_rr_sd_parent_jd;
4733: end if;
4734: end loop;
4735: close c_get_baladj_jd;
4736: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4737:
4738: /*****************************************************************
4739: ** Get Employee Resident Jurisdiction
4740: *****************************************************************/

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

4743: ,p_run_effective_date => p_run_effective_date
4744: ,p_resident_state_jd => lv_resident_state
4745: ,p_resident_county_jd => lv_resident_county
4746: ,p_resident_city_jd => lv_resident_city);
4747: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4748: hr_utility.trace('lv_resident_state = ' || lv_resident_state);
4749: hr_utility.trace('lv_resident_county = ' || lv_resident_county);
4750: hr_utility.trace('lv_resident_city = ' || lv_resident_city);
4751:

Line 4748: hr_utility.trace('lv_resident_state = ' || lv_resident_state);

4744: ,p_resident_state_jd => lv_resident_state
4745: ,p_resident_county_jd => lv_resident_county
4746: ,p_resident_city_jd => lv_resident_city);
4747: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4748: hr_utility.trace('lv_resident_state = ' || lv_resident_state);
4749: hr_utility.trace('lv_resident_county = ' || lv_resident_county);
4750: hr_utility.trace('lv_resident_city = ' || lv_resident_city);
4751:
4752: /*****************************************************************

Line 4749: hr_utility.trace('lv_resident_county = ' || lv_resident_county);

4745: ,p_resident_county_jd => lv_resident_county
4746: ,p_resident_city_jd => lv_resident_city);
4747: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4748: hr_utility.trace('lv_resident_state = ' || lv_resident_state);
4749: hr_utility.trace('lv_resident_county = ' || lv_resident_county);
4750: hr_utility.trace('lv_resident_city = ' || lv_resident_city);
4751:
4752: /*****************************************************************
4753: ** Federal Information Archiving

Line 4750: hr_utility.trace('lv_resident_city = ' || lv_resident_city);

4746: ,p_resident_city_jd => lv_resident_city);
4747: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4748: hr_utility.trace('lv_resident_state = ' || lv_resident_state);
4749: hr_utility.trace('lv_resident_county = ' || lv_resident_county);
4750: hr_utility.trace('lv_resident_city = ' || lv_resident_city);
4751:
4752: /*****************************************************************
4753: ** Federal Information Archiving
4754: *****************************************************************/

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

4754: *****************************************************************/
4755: populate_federal_tax_balances(p_xfr_action_id => p_xfr_action_id
4756: ,p_rqp_action_id => ln_baladj_action_id
4757: ,p_action_type => p_action_type);
4758: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4759:
4760: /*****************************************************************
4761: ** State Information Archiving
4762: *****************************************************************/

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

4764: p_xfr_action_id => p_xfr_action_id
4765: ,p_rqp_action_id => ln_baladj_action_id
4766: ,p_action_type => p_action_type
4767: ,p_jurisdiction_tab => pay_ac_action_arch.emp_state_jd);
4768: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4769:
4770: /*****************************************************************
4771: ** County Information Archiving
4772: *****************************************************************/

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

4777: ,p_resident_county => lv_resident_county
4778: ,p_resident_city => lv_resident_city
4779: ,p_action_type => p_action_type
4780: ,p_jurisdiction_tab => pay_ac_action_arch.emp_county_jd);
4781: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4782:
4783: /*****************************************************************
4784: ** City Information Archiving
4785: *****************************************************************/

Line 4795: hr_utility.set_location(gv_package || lv_procedure_name, 100);

4791: ,p_resident_county => lv_resident_county
4792: ,p_resident_city => lv_resident_city
4793: ,p_effective_date => p_end_date
4794: ,p_jurisdiction_tab => pay_ac_action_arch.emp_city_jd);
4795: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4796:
4797: /*****************************************************************
4798: ** School District Information Archiving
4799: *****************************************************************/

Line 4805: hr_utility.set_location(gv_package || lv_procedure_name, 110);

4801: p_xfr_action_id => p_xfr_action_id
4802: ,p_rqp_action_id => ln_baladj_action_id
4803: ,p_action_type => p_action_type
4804: ,p_jurisdiction_tab => pay_ac_action_arch.emp_school_jd);
4805: hr_utility.set_location(gv_package || lv_procedure_name, 110);
4806:
4807: /*****************************************************************
4808: ** Initialize the PL/SQL tables for State, County, City and School
4809: *****************************************************************/

Line 4814: hr_utility.set_location(gv_package || lv_procedure_name, 120);

4810: pay_ac_action_arch.emp_state_jd.delete;
4811: pay_ac_action_arch.emp_city_jd.delete;
4812: pay_ac_action_arch.emp_county_jd.delete;
4813: pay_ac_action_arch.emp_school_jd.delete;
4814: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4815:
4816: end loop;
4817: close c_get_emp_adjbal;
4818: hr_utility.set_location(gv_package || lv_procedure_name, 130);

Line 4818: hr_utility.set_location(gv_package || lv_procedure_name, 130);

4814: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4815:
4816: end loop;
4817: close c_get_emp_adjbal;
4818: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4819:
4820: hr_utility.trace('Leaving populate_adj_tax_balances');
4821:
4822: EXCEPTION

Line 4820: hr_utility.trace('Leaving populate_adj_tax_balances');

4816: end loop;
4817: close c_get_emp_adjbal;
4818: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4819:
4820: hr_utility.trace('Leaving populate_adj_tax_balances');
4821:
4822: EXCEPTION
4823: when others then
4824: lv_error_message := 'Error in ' ||

Line 4827: hr_utility.trace(lv_error_message || '-' || sqlerrm);

4823: when others then
4824: lv_error_message := 'Error in ' ||
4825: gv_package || lv_procedure_name;
4826:
4827: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4828:
4829: lv_error_message :=
4830: pay_emp_action_arch.set_error_message(lv_error_message);
4831:

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

4828:
4829: lv_error_message :=
4830: pay_emp_action_arch.set_error_message(lv_error_message);
4831:
4832: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4833: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4834: hr_utility.raise_error;
4835:
4836: END populate_adj_tax_balances;

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

4829: lv_error_message :=
4830: pay_emp_action_arch.set_error_message(lv_error_message);
4831:
4832: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4833: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4834: hr_utility.raise_error;
4835:
4836: END populate_adj_tax_balances;
4837:

Line 4834: hr_utility.raise_error;

4830: pay_emp_action_arch.set_error_message(lv_error_message);
4831:
4832: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4833: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4834: hr_utility.raise_error;
4835:
4836: END populate_adj_tax_balances;
4837:
4838:

Line 4892: hr_utility.trace('Action_Context_ID = ' || p_action_context_id);

4888: lv_error_message VARCHAR2(200);
4889:
4890:
4891: BEGIN
4892: hr_utility.trace('Action_Context_ID = ' || p_action_context_id);
4893: hr_utility.trace('Asg ID = ' || p_assignment_id);
4894: open c_get_archive_info(p_action_context_id, p_assignment_id);
4895: loop
4896: fetch c_get_archive_info into ln_action_information_id,

Line 4893: hr_utility.trace('Asg ID = ' || p_assignment_id);

4889:
4890:
4891: BEGIN
4892: hr_utility.trace('Action_Context_ID = ' || p_action_context_id);
4893: hr_utility.trace('Asg ID = ' || p_assignment_id);
4894: open c_get_archive_info(p_action_context_id, p_assignment_id);
4895: loop
4896: fetch c_get_archive_info into ln_action_information_id,
4897: ld_effective_date,

Line 4903: hr_utility.trace('Action_info_id = ' || ln_action_information_id);

4899: if c_get_archive_info%notfound then
4900: exit;
4901: end if;
4902:
4903: hr_utility.trace('Action_info_id = ' || ln_action_information_id);
4904: hr_utility.trace('ld_eff_date = ' || to_char(ld_effective_date, 'dd-mon-yyyy'));
4905:
4906: open c_get_employee_info(p_assignment_id, ld_effective_date);
4907: fetch c_get_employee_info into lv_employee_name;

Line 4904: hr_utility.trace('ld_eff_date = ' || to_char(ld_effective_date, 'dd-mon-yyyy'));

4900: exit;
4901: end if;
4902:
4903: hr_utility.trace('Action_info_id = ' || ln_action_information_id);
4904: hr_utility.trace('ld_eff_date = ' || to_char(ld_effective_date, 'dd-mon-yyyy'));
4905:
4906: open c_get_employee_info(p_assignment_id, ld_effective_date);
4907: fetch c_get_employee_info into lv_employee_name;
4908: close c_get_employee_info;

Line 4910: hr_utility.trace('lv_employee_name = *' || lv_employee_name ||'*');

4906: open c_get_employee_info(p_assignment_id, ld_effective_date);
4907: fetch c_get_employee_info into lv_employee_name;
4908: close c_get_employee_info;
4909:
4910: hr_utility.trace('lv_employee_name = *' || lv_employee_name ||'*');
4911:
4912: pay_action_information_api.update_action_information
4913: (p_action_information_id => ln_action_information_id
4914: ,p_object_version_number => ln_ovn

Line 4926: hr_utility.trace(lv_error_message || '-' || sqlerrm);

4922: when others then
4923: lv_error_message := 'Error in ' ||
4924: gv_package || lv_procedure_name;
4925:
4926: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4927:
4928: lv_error_message :=
4929: pay_emp_action_arch.set_error_message(lv_error_message);
4930:

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

4927:
4928: lv_error_message :=
4929: pay_emp_action_arch.set_error_message(lv_error_message);
4930:
4931: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4932: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4933: hr_utility.raise_error;
4934:
4935: END update_employee_information;

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

4928: lv_error_message :=
4929: pay_emp_action_arch.set_error_message(lv_error_message);
4930:
4931: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4932: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4933: hr_utility.raise_error;
4934:
4935: END update_employee_information;
4936:

Line 4933: hr_utility.raise_error;

4929: pay_emp_action_arch.set_error_message(lv_error_message);
4930:
4931: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4932: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4933: hr_utility.raise_error;
4934:
4935: END update_employee_information;
4936:
4937:

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

5018: lv_error_message VARCHAR2(200);
5019:
5020:
5021: BEGIN
5022: hr_utility.set_location(gv_package || lv_procedure_name, 10);
5023: open c_emp_fed_info(p_assignment_id,
5024: p_run_effective_date);
5025: hr_utility.trace('Opened c_emp_fed_info cursor of get_withholding_info');
5026: fetch c_emp_fed_info into lv_fit_filing_status_code,

Line 5025: hr_utility.trace('Opened c_emp_fed_info cursor of get_withholding_info');

5021: BEGIN
5022: hr_utility.set_location(gv_package || lv_procedure_name, 10);
5023: open c_emp_fed_info(p_assignment_id,
5024: p_run_effective_date);
5025: hr_utility.trace('Opened c_emp_fed_info cursor of get_withholding_info');
5026: fetch c_emp_fed_info into lv_fit_filing_status_code,
5027: lv_fit_filing_status,
5028: ln_fit_withholding_allowances,
5029: ln_fit_additional_wa_amount,

Line 5033: hr_utility.trace('Going to write get_withholding_info record for fed');

5029: ln_fit_additional_wa_amount,
5030: ln_fit_override_amount,
5031: ln_fit_override_rate;
5032: if c_emp_fed_info%found then
5033: hr_utility.trace('Going to write get_withholding_info record for fed');
5034:
5035: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5036:
5037: hr_utility.trace('ln_index in get_withholding_info proc is '

Line 5037: hr_utility.trace('ln_index in get_withholding_info proc is '

5033: hr_utility.trace('Going to write get_withholding_info record for fed');
5034:
5035: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5036:
5037: hr_utility.trace('ln_index in get_withholding_info proc is '
5038: || pay_ac_action_arch.lrr_act_tab.count);
5039:
5040: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5041: := 'US WITHHOLDINGS';

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

5056: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5057: := ln_fit_override_rate;
5058: end if;
5059: close c_emp_fed_info;
5060: hr_utility.set_location(gv_package || lv_procedure_name, 30);
5061:
5062:
5063: open c_fnd_session;
5064: fetch c_fnd_session into ld_session_date;

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

5078: ,p_run_effective_date);
5079: fetch c_get_asg_work_at_home into lv_asg_work_at_home;
5080: close c_get_asg_work_at_home;
5081:
5082: hr_utility.set_location(gv_package || lv_procedure_name, 30);
5083: if lv_asg_work_at_home = 'Y' then
5084: open c_emp_state_info(p_assignment_id,
5085: substr(p_resident_jurisdiction,1,2) || '-000-0000');
5086: else

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

5098: ln_sit_override_amount,
5099: ln_sit_override_rate;
5100:
5101: if c_emp_state_info%notfound then
5102: hr_utility.set_location(gv_package || lv_procedure_name, 40);
5103: exit;
5104: end if;
5105:
5106: hr_utility.set_location(gv_package || lv_procedure_name, 50);

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

5102: hr_utility.set_location(gv_package || lv_procedure_name, 40);
5103: exit;
5104: end if;
5105:
5106: hr_utility.set_location(gv_package || lv_procedure_name, 50);
5107: if ((lv_time_in_state > 0) or
5108: (lv_time_in_state = 0 and
5109: substr(lv_jurisdiction_code, 1,2) = substr(p_resident_jurisdiction,1,2))) then
5110:

Line 5112: hr_utility.trace('ln_index = ' || ln_index);

5108: (lv_time_in_state = 0 and
5109: substr(lv_jurisdiction_code, 1,2) = substr(p_resident_jurisdiction,1,2))) then
5110:
5111: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5112: hr_utility.trace('ln_index = ' || ln_index);
5113:
5114: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5115: := 'US WITHHOLDINGS';
5116: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 5135: hr_utility.set_location(gv_package || lv_procedure_name, 100);

5131: end if;
5132: end loop;
5133: close c_emp_state_info;
5134:
5135: hr_utility.set_location(gv_package || lv_procedure_name, 100);
5136:
5137: EXCEPTION
5138: when others then
5139: lv_error_message := 'Error in ' ||

Line 5142: hr_utility.trace(lv_error_message || '-' || sqlerrm);

5138: when others then
5139: lv_error_message := 'Error in ' ||
5140: gv_package || lv_procedure_name;
5141:
5142: hr_utility.trace(lv_error_message || '-' || sqlerrm);
5143:
5144: lv_error_message :=
5145: pay_emp_action_arch.set_error_message(lv_error_message);
5146:

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

5143:
5144: lv_error_message :=
5145: pay_emp_action_arch.set_error_message(lv_error_message);
5146:
5147: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5148: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5149: hr_utility.raise_error;
5150:
5151: END get_employee_withholding_info;

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

5144: lv_error_message :=
5145: pay_emp_action_arch.set_error_message(lv_error_message);
5146:
5147: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5148: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5149: hr_utility.raise_error;
5150:
5151: END get_employee_withholding_info;
5152:

Line 5149: hr_utility.raise_error;

5145: pay_emp_action_arch.set_error_message(lv_error_message);
5146:
5147: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5148: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5149: hr_utility.raise_error;
5150:
5151: END get_employee_withholding_info;
5152:
5153:

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

5242: lv_procedure_name VARCHAR2(100) := '.process_actions';
5243: lv_error_message VARCHAR2(200);
5244:
5245: BEGIN
5246: hr_utility.set_location(gv_package || lv_procedure_name, 10);
5247: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
5248: /****************************************************************
5249: ** For Seperate Check we do the YTD balance calls with the Run
5250: ** Action ID. So, we do not need to get the max. action which is

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

5255: ****************************************************************/
5256: ln_ytd_balcall_aaid := p_payment_action_id;
5257: if p_seperate_check_flag = 'N' and
5258: p_action_type in ('U', 'P') then
5259: hr_utility.set_location(gv_package || lv_procedure_name, 40);
5260: open c_ytd_aaid(p_rqp_action_id,
5261: p_assignment_id,
5262: p_sepcheck_run_type_id);
5263: fetch c_ytd_aaid into ln_ytd_balcall_aaid;

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

5261: p_assignment_id,
5262: p_sepcheck_run_type_id);
5263: fetch c_ytd_aaid into ln_ytd_balcall_aaid;
5264: if c_ytd_aaid%notfound then
5265: hr_utility.set_location(gv_package || lv_procedure_name, 50);
5266: hr_utility.raise_error;
5267: end if;
5268: close c_ytd_aaid;
5269: end if;

Line 5266: hr_utility.raise_error;

5262: p_sepcheck_run_type_id);
5263: fetch c_ytd_aaid into ln_ytd_balcall_aaid;
5264: if c_ytd_aaid%notfound then
5265: hr_utility.set_location(gv_package || lv_procedure_name, 50);
5266: hr_utility.raise_error;
5267: end if;
5268: close c_ytd_aaid;
5269: end if;
5270:

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

5267: end if;
5268: close c_ytd_aaid;
5269: end if;
5270:
5271: hr_utility.set_location(gv_package || lv_procedure_name, 60);
5272:
5273: open c_time_period(p_payment_action_id);
5274: fetch c_time_period into ln_time_period_id,
5275: ld_run_date_earned,

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

5275: ld_run_date_earned,
5276: ld_run_effective_date;
5277: close c_time_period;
5278:
5279: hr_utility.set_location(gv_package || lv_procedure_name, 70);
5280: pay_ac_action_arch.get_last_xfr_info(
5281: p_assignment_id => p_assignment_id
5282: ,p_curr_effective_date => p_xfr_end_date
5283: ,p_action_info_category => 'EMPLOYEE DETAILS'

Line 5317: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);

5313:
5314: p_last_xfr_eff_date := ld_last_xfr_eff_date;
5315: p_last_xfr_action_id := ln_last_xfr_action_id;
5316:
5317: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
5318: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
5319: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
5320: hr_utility.trace('p_action_type = ' || p_action_type);
5321: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);

Line 5318: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);

5314: p_last_xfr_eff_date := ld_last_xfr_eff_date;
5315: p_last_xfr_action_id := ln_last_xfr_action_id;
5316:
5317: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
5318: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
5319: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
5320: hr_utility.trace('p_action_type = ' || p_action_type);
5321: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
5322: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);

Line 5319: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);

5315: p_last_xfr_action_id := ln_last_xfr_action_id;
5316:
5317: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
5318: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
5319: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
5320: hr_utility.trace('p_action_type = ' || p_action_type);
5321: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
5322: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
5323: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);

Line 5320: hr_utility.trace('p_action_type = ' || p_action_type);

5316:
5317: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
5318: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
5319: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
5320: hr_utility.trace('p_action_type = ' || p_action_type);
5321: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
5322: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
5323: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
5324: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);

Line 5321: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);

5317: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
5318: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
5319: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
5320: hr_utility.trace('p_action_type = ' || p_action_type);
5321: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
5322: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
5323: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
5324: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
5325: hr_utility.trace('p_assignment_id = ' || p_assignment_id);

Line 5322: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);

5318: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
5319: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
5320: hr_utility.trace('p_action_type = ' || p_action_type);
5321: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
5322: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
5323: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
5324: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
5325: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
5326: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );

Line 5323: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);

5319: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
5320: hr_utility.trace('p_action_type = ' || p_action_type);
5321: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
5322: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
5323: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
5324: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
5325: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
5326: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
5327: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );

Line 5324: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);

5320: hr_utility.trace('p_action_type = ' || p_action_type);
5321: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
5322: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
5323: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
5324: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
5325: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
5326: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
5327: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
5328: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);

Line 5325: hr_utility.trace('p_assignment_id = ' || p_assignment_id);

5321: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
5322: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
5323: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
5324: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
5325: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
5326: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
5327: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
5328: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
5329: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);

Line 5326: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );

5322: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
5323: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
5324: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
5325: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
5326: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
5327: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
5328: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
5329: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
5330: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);

Line 5327: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );

5323: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
5324: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
5325: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
5326: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
5327: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
5328: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
5329: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
5330: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
5331: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);

Line 5328: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);

5324: hr_utility.trace('p_sepcheck_run_type_id = '|| p_sepcheck_run_type_id);
5325: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
5326: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
5327: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
5328: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
5329: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
5330: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
5331: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
5332: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);

Line 5329: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);

5325: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
5326: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
5327: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
5328: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
5329: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
5330: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
5331: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
5332: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
5333: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);

Line 5330: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);

5326: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
5327: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
5328: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
5329: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
5330: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
5331: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
5332: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
5333: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
5334: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);

Line 5331: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);

5327: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
5328: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
5329: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
5330: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
5331: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
5332: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
5333: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
5334: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
5335:

Line 5332: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);

5328: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
5329: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
5330: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
5331: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
5332: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
5333: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
5334: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
5335:
5336: pay_ac_action_arch.initialization_process;

Line 5333: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);

5329: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
5330: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
5331: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
5332: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
5333: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
5334: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
5335:
5336: pay_ac_action_arch.initialization_process;
5337:

Line 5334: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);

5330: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
5331: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
5332: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
5333: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
5334: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
5335:
5336: pay_ac_action_arch.initialization_process;
5337:
5338: /*********************************************************************

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

5360: ,p_sepchk_run_type_id => p_sepcheck_run_type_id
5361: ,p_sepchk_flag => p_seperate_check_flag
5362: ,p_resident_jurisdiction => lv_resident_jurisdiction
5363: );
5364: hr_utility.set_location(gv_package || lv_procedure_name, 90);
5365:
5366: /******************************************************************
5367: ** For seperate check cases, the ld_last_xfr_eff_date is never null
5368: ** as the master is always processed before the child actions. The

Line 5373: hr_utility.set_location(gv_package || lv_procedure_name, 100);

5369: ** master data is already in the archive table and as it is in the
5370: ** same session the process will always go to the else statement
5371: ******************************************************************/
5372: if ld_last_xfr_eff_date is null then
5373: hr_utility.set_location(gv_package || lv_procedure_name, 100);
5374: pay_ac_action_arch.first_time_process(
5375: p_xfr_action_id => p_xfr_action_id
5376: ,p_assignment_id => p_assignment_id
5377: ,p_curr_pymt_action_id => p_rqp_action_id

Line 5389: hr_utility.set_location(gv_package || lv_procedure_name, 110);

5385: ,p_legislation_code => p_legislation_code
5386: );
5387:
5388: else
5389: hr_utility.set_location(gv_package || lv_procedure_name, 110);
5390: pay_ac_action_arch.get_current_elements(
5391: p_xfr_action_id => p_xfr_action_id
5392: ,p_curr_pymt_action_id => p_rqp_action_id
5393: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date

Line 5404: hr_utility.set_location(gv_package || lv_procedure_name, 120);

5400: ,p_legislation_code => p_legislation_code);
5401:
5402: end if;
5403:
5404: hr_utility.set_location(gv_package || lv_procedure_name, 120);
5405:
5406: else
5407:
5408: /*****************************************************************

Line 5414: hr_utility.set_location(gv_package || lv_procedure_name, 130);

5410: ** call populate_puv_tax_balances which returns
5411: ** lv_resident_jurisdiction. This value is used when archiving
5412: ** W4 Information.
5413: *****************************************************************/
5414: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5415: get_emp_residence(p_assignment_id => p_assignment_id
5416: ,p_end_date => p_xfr_end_date
5417: ,p_run_effective_date => ld_run_effective_date
5418: ,p_resident_state_jd => lv_resident_state

Line 5428: hr_utility.set_location(gv_package || lv_procedure_name, 135);

5424: lv_resident_city;
5425:
5426: end if; /* p_archive_balance_info = 'Y' */
5427:
5428: hr_utility.set_location(gv_package || lv_procedure_name, 135);
5429: pay_ac_action_arch.get_xfr_elements(
5430: p_xfr_action_id => p_xfr_action_id
5431: ,p_last_xfr_action_id => ln_last_xfr_action_id
5432: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid

Line 5438: hr_utility.set_location(gv_package || lv_procedure_name, 140);

5434: ,p_legislation_code => p_legislation_code
5435: ,p_sepchk_flag => p_seperate_check_flag
5436: ,p_assignment_id => p_assignment_id);
5437:
5438: hr_utility.set_location(gv_package || lv_procedure_name, 140);
5439: pay_ac_action_arch.get_last_pymt_info(
5440: p_assignment_id => p_assignment_id
5441: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
5442: ,p_last_pymt_eff_date => ld_last_pymt_eff_date

Line 5446: hr_utility.set_location(gv_package || lv_procedure_name, 145);

5442: ,p_last_pymt_eff_date => ld_last_pymt_eff_date
5443: ,p_last_pymt_action_id => ln_last_pymt_action_id);
5444:
5445: if ld_last_xfr_eff_date <> ld_last_pymt_eff_date then
5446: hr_utility.set_location(gv_package || lv_procedure_name, 145);
5447: pay_ac_action_arch.get_missing_xfr_info(
5448: p_xfr_action_id => p_xfr_action_id
5449: ,p_tax_unit_id => p_tax_unit_id
5450: ,p_assignment_id => p_assignment_id

Line 5460: hr_utility.set_location(gv_package || lv_procedure_name, 155);

5456: ,p_legislation_code => p_legislation_code);
5457: end if;
5458:
5459:
5460: hr_utility.set_location(gv_package || lv_procedure_name, 155);
5461: pay_emp_action_arch.get_personal_information(
5462: p_payroll_action_id => p_xfr_payroll_action_id
5463: ,p_assactid => p_xfr_action_id
5464: ,p_assignment_id => p_assignment_id

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

5472: ,p_run_action_id => p_payment_action_id
5473: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
5474: );
5475:
5476: hr_utility.set_location(gv_package || lv_procedure_name, 160);
5477: get_employee_withholding_info(
5478: p_assignment_id => p_assignment_id
5479: ,p_run_effective_date => ld_run_effective_date
5480: ,p_resident_jurisdiction => lv_resident_jurisdiction);

Line 5483: hr_utility.set_location(gv_package || lv_procedure_name, 170);

5479: ,p_run_effective_date => ld_run_effective_date
5480: ,p_resident_jurisdiction => lv_resident_jurisdiction);
5481:
5482: if p_seperate_check_flag = 'N' then
5483: hr_utility.set_location(gv_package || lv_procedure_name, 170);
5484: -- Archive element processed in balance adjustment. This only
5485: -- needs to be done for master action as once the element is
5486: -- in archive, it will be carried forward.
5487: pay_ac_action_arch.process_baladj_elements(

Line 5501: hr_utility.set_location(gv_package || lv_procedure_name, 175);

5497: ,p_consolidation_set_id => p_consolidation_set_id
5498: ,p_legislation_code => p_legislation_code
5499: ,p_tax_unit_id => p_tax_unit_id);
5500:
5501: hr_utility.set_location(gv_package || lv_procedure_name, 175);
5502:
5503: open c_ytd_aaid(p_rqp_action_id,
5504: p_assignment_id,
5505: p_sepcheck_run_type_id);

Line 5509: hr_utility.set_location(gv_package || lv_procedure_name, 180);

5505: p_sepcheck_run_type_id);
5506: loop
5507: fetch c_ytd_aaid into ln_run_action_id;
5508: if c_ytd_aaid%notfound then
5509: hr_utility.set_location(gv_package || lv_procedure_name, 180);
5510: exit;
5511: end if;
5512:
5513: hr_utility.set_location(gv_package || lv_procedure_name, 190);

Line 5513: hr_utility.set_location(gv_package || lv_procedure_name, 190);

5509: hr_utility.set_location(gv_package || lv_procedure_name, 180);
5510: exit;
5511: end if;
5512:
5513: hr_utility.set_location(gv_package || lv_procedure_name, 190);
5514: populate_emp_hours_by_rate(
5515: p_action_context_id => p_xfr_action_id
5516: ,p_assignment_id => p_assignment_id
5517: ,p_run_action_id => ln_run_action_id);

Line 5522: hr_utility.set_location(gv_package || lv_procedure_name, 200);

5518:
5519: end loop;
5520: close c_ytd_aaid;
5521: else
5522: hr_utility.set_location(gv_package || lv_procedure_name, 200);
5523: populate_emp_hours_by_rate(
5524: p_action_context_id => p_xfr_action_id
5525: ,p_assignment_id => p_assignment_id
5526: ,p_run_action_id => p_payment_action_id);

Line 5529: hr_utility.set_location(gv_package || lv_procedure_name, 205);

5525: ,p_assignment_id => p_assignment_id
5526: ,p_run_action_id => p_payment_action_id);
5527: end if;
5528:
5529: hr_utility.set_location(gv_package || lv_procedure_name, 205);
5530: pay_ac_action_arch.populate_summary(
5531: p_xfr_action_id => p_xfr_action_id);
5532: change_processing_priority;
5533:

Line 5534: hr_utility.set_location(gv_package || lv_procedure_name, 210);

5530: pay_ac_action_arch.populate_summary(
5531: p_xfr_action_id => p_xfr_action_id);
5532: change_processing_priority;
5533:
5534: hr_utility.set_location(gv_package || lv_procedure_name, 210);
5535: pay_emp_action_arch.insert_rows_thro_api_process(
5536: p_action_context_id => p_xfr_action_id
5537: ,p_action_context_type=> 'AAP'
5538: ,p_assignment_id => p_assignment_id

Line 5544: hr_utility.set_location(gv_package || lv_procedure_name, 220);

5540: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
5541: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
5542: );
5543:
5544: hr_utility.set_location(gv_package || lv_procedure_name, 220);
5545: update_employee_information(
5546: p_action_context_id => p_xfr_action_id
5547: ,p_assignment_id => p_assignment_id);
5548:

Line 5549: hr_utility.set_location(gv_package || lv_procedure_name, 250);

5545: update_employee_information(
5546: p_action_context_id => p_xfr_action_id
5547: ,p_assignment_id => p_assignment_id);
5548:
5549: hr_utility.set_location(gv_package || lv_procedure_name, 250);
5550:
5551: EXCEPTION
5552: when others then
5553: lv_error_message := 'Error in ' ||

Line 5556: hr_utility.trace(lv_error_message || '-' || sqlerrm);

5552: when others then
5553: lv_error_message := 'Error in ' ||
5554: gv_package || lv_procedure_name;
5555:
5556: hr_utility.trace(lv_error_message || '-' || sqlerrm);
5557:
5558: lv_error_message :=
5559: pay_emp_action_arch.set_error_message(lv_error_message);
5560:

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

5557:
5558: lv_error_message :=
5559: pay_emp_action_arch.set_error_message(lv_error_message);
5560:
5561: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5562: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5563: hr_utility.raise_error;
5564:
5565: END process_actions;

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

5558: lv_error_message :=
5559: pay_emp_action_arch.set_error_message(lv_error_message);
5560:
5561: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5562: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5563: hr_utility.raise_error;
5564:
5565: END process_actions;
5566:

Line 5563: hr_utility.raise_error;

5559: pay_emp_action_arch.set_error_message(lv_error_message);
5560:
5561: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
5562: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
5563: hr_utility.raise_error;
5564:
5565: END process_actions;
5566:
5567: /************************************************************

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

5817: ln_last_xfr_action_id NUMBER;
5818:
5819: BEGIN
5820: pay_emp_action_arch.gv_error_message := NULL;
5821: hr_utility.set_location(gv_package || lv_procedure_name, 10);
5822: ln_step := 1;
5823: open c_xfr_info (p_xfr_action_id);
5824: fetch c_xfr_info into ln_xfr_payroll_action_id,
5825: ln_xfr_master_action_id,

Line 5840: hr_utility.set_location(gv_package || lv_procedure_name, 15);

5836: ,p_business_group_id => ln_business_group_id
5837: ,p_cons_set_id => ln_cons_set_id
5838: ,p_payroll_id => ln_payroll_id);
5839:
5840: hr_utility.set_location(gv_package || lv_procedure_name, 15);
5841:
5842: ln_step := 205;
5843: pay_emp_action_arch.gv_multi_payroll_pymt
5844: := pay_emp_action_arch.get_multi_assignment_flag(

Line 5848: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||

5844: := pay_emp_action_arch.get_multi_assignment_flag(
5845: p_payroll_id => ln_payroll_id
5846: ,p_effective_date => ld_end_date);
5847:
5848: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
5849: pay_emp_action_arch.gv_multi_payroll_pymt);
5850:
5851: ln_step := 3;
5852: open c_legislation (ln_business_group_id);

Line 5855: hr_utility.trace('Business Group for Interface Process Not Found');

5851: ln_step := 3;
5852: open c_legislation (ln_business_group_id);
5853: fetch c_legislation into lv_legislation_code ;
5854: if c_legislation%notfound then
5855: hr_utility.trace('Business Group for Interface Process Not Found');
5856: hr_utility.raise_error;
5857: end if;
5858: close c_legislation;
5859: hr_utility.trace('lv_legislation_code '||lv_legislation_code);

Line 5856: hr_utility.raise_error;

5852: open c_legislation (ln_business_group_id);
5853: fetch c_legislation into lv_legislation_code ;
5854: if c_legislation%notfound then
5855: hr_utility.trace('Business Group for Interface Process Not Found');
5856: hr_utility.raise_error;
5857: end if;
5858: close c_legislation;
5859: hr_utility.trace('lv_legislation_code '||lv_legislation_code);
5860:

Line 5859: hr_utility.trace('lv_legislation_code '||lv_legislation_code);

5855: hr_utility.trace('Business Group for Interface Process Not Found');
5856: hr_utility.raise_error;
5857: end if;
5858: close c_legislation;
5859: hr_utility.trace('lv_legislation_code '||lv_legislation_code);
5860:
5861: ln_step := 4;
5862: open c_sepchk_ryn_type;
5863: fetch c_sepchk_ryn_type into ln_sepchk_run_type_id;

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

5861: ln_step := 4;
5862: open c_sepchk_ryn_type;
5863: fetch c_sepchk_ryn_type into ln_sepchk_run_type_id;
5864: if c_sepchk_ryn_type%notfound then
5865: hr_utility.set_location(gv_package || lv_procedure_name, 20);
5866: hr_utility.raise_error;
5867: end if;
5868: close c_sepchk_ryn_type;
5869:

Line 5866: hr_utility.raise_error;

5862: open c_sepchk_ryn_type;
5863: fetch c_sepchk_ryn_type into ln_sepchk_run_type_id;
5864: if c_sepchk_ryn_type%notfound then
5865: hr_utility.set_location(gv_package || lv_procedure_name, 20);
5866: hr_utility.raise_error;
5867: end if;
5868: close c_sepchk_ryn_type;
5869:
5870: -- process the master_action

Line 5881: hr_utility.trace('PayrollAction for InterfaceProcess NotFound');

5877: ln_step := 5;
5878: open c_pymt_eff_date(ln_asg_action_id);
5879: fetch c_pymt_eff_date into ld_curr_pymt_eff_date;
5880: if c_pymt_eff_date%notfound then
5881: hr_utility.trace('PayrollAction for InterfaceProcess NotFound');
5882: hr_utility.raise_error;
5883: end if;
5884: close c_pymt_eff_date;
5885:

Line 5882: hr_utility.raise_error;

5878: open c_pymt_eff_date(ln_asg_action_id);
5879: fetch c_pymt_eff_date into ld_curr_pymt_eff_date;
5880: if c_pymt_eff_date%notfound then
5881: hr_utility.trace('PayrollAction for InterfaceProcess NotFound');
5882: hr_utility.raise_error;
5883: end if;
5884: close c_pymt_eff_date;
5885:
5886: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));

Line 5886: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));

5882: hr_utility.raise_error;
5883: end if;
5884: close c_pymt_eff_date;
5885:
5886: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));
5887: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));
5888: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));
5889: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);
5890: hr_utility.trace('ln_xfr_payroll_action_id ='||to_char(ln_xfr_payroll_action_id));

Line 5887: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));

5883: end if;
5884: close c_pymt_eff_date;
5885:
5886: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));
5887: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));
5888: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));
5889: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);
5890: hr_utility.trace('ln_xfr_payroll_action_id ='||to_char(ln_xfr_payroll_action_id));
5891:

Line 5888: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));

5884: close c_pymt_eff_date;
5885:
5886: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));
5887: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));
5888: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));
5889: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);
5890: hr_utility.trace('ln_xfr_payroll_action_id ='||to_char(ln_xfr_payroll_action_id));
5891:
5892: ln_step := 6;

Line 5889: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);

5885:
5886: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));
5887: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));
5888: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));
5889: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);
5890: hr_utility.trace('ln_xfr_payroll_action_id ='||to_char(ln_xfr_payroll_action_id));
5891:
5892: ln_step := 6;
5893: if lv_master_action_type in ( 'P','U') then

Line 5890: hr_utility.trace('ln_xfr_payroll_action_id ='||to_char(ln_xfr_payroll_action_id));

5886: hr_utility.trace('End Date=' || to_char(ld_end_date, 'dd-mon-yyyy'));
5887: hr_utility.trace('Start Date='||to_char(ld_start_date, 'dd-mon-yyyy'));
5888: hr_utility.trace('Business Group Id='||to_char(ln_business_group_id));
5889: hr_utility.trace('Serial Number='||lv_xfr_master_serial_number);
5890: hr_utility.trace('ln_xfr_payroll_action_id ='||to_char(ln_xfr_payroll_action_id));
5891:
5892: ln_step := 6;
5893: if lv_master_action_type in ( 'P','U') then
5894: /************************************************************

Line 5909: hr_utility.trace('archive_data:payment_info:ln_asg_action_id = ' ||

5905: ,ln_source_action_id
5906: ,ln_asg_action_id;
5907: exit when c_payment_info%notfound;
5908:
5909: hr_utility.trace('archive_data:payment_info:ln_asg_action_id = ' ||
5910: ln_asg_action_id );
5911: hr_utility.trace('archive_data:payment_info:ln_assignment_id = ' ||
5912: ln_assignment_id );
5913: hr_utility.trace('archive_data:payment_info:ln_tax_unit_id = ' ||

Line 5911: hr_utility.trace('archive_data:payment_info:ln_assignment_id = ' ||

5907: exit when c_payment_info%notfound;
5908:
5909: hr_utility.trace('archive_data:payment_info:ln_asg_action_id = ' ||
5910: ln_asg_action_id );
5911: hr_utility.trace('archive_data:payment_info:ln_assignment_id = ' ||
5912: ln_assignment_id );
5913: hr_utility.trace('archive_data:payment_info:ln_tax_unit_id = ' ||
5914: ln_tax_unit_id );
5915: hr_utility.trace('archive_data:payment_info:ln_source_action_id = ' ||

Line 5913: hr_utility.trace('archive_data:payment_info:ln_tax_unit_id = ' ||

5909: hr_utility.trace('archive_data:payment_info:ln_asg_action_id = ' ||
5910: ln_asg_action_id );
5911: hr_utility.trace('archive_data:payment_info:ln_assignment_id = ' ||
5912: ln_assignment_id );
5913: hr_utility.trace('archive_data:payment_info:ln_tax_unit_id = ' ||
5914: ln_tax_unit_id );
5915: hr_utility.trace('archive_data:payment_info:ln_source_action_id = ' ||
5916: ln_source_action_id );
5917:

Line 5915: hr_utility.trace('archive_data:payment_info:ln_source_action_id = ' ||

5911: hr_utility.trace('archive_data:payment_info:ln_assignment_id = ' ||
5912: ln_assignment_id );
5913: hr_utility.trace('archive_data:payment_info:ln_tax_unit_id = ' ||
5914: ln_tax_unit_id );
5915: hr_utility.trace('archive_data:payment_info:ln_source_action_id = ' ||
5916: ln_source_action_id );
5917:
5918: ln_step := 8;
5919:

Line 5941: hr_utility.trace('GRE ln_run_aa_id = ' || ln_run_aa_id);

5937: end if;
5938: close c_run_aa_id;
5939:
5940: ln_step := 10;
5941: hr_utility.trace('GRE ln_run_aa_id = ' || ln_run_aa_id);
5942:
5943: if ln_run_source_action_id is not null then
5944: ln_master_run_aa_id := ln_run_source_action_id; -- Normal Chk
5945: else

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

5982: select pay_assignment_actions_s.nextval
5983: into ln_child_xfr_action_id
5984: from dual;
5985:
5986: hr_utility.set_location(gv_package || lv_procedure_name, 30);
5987:
5988: -- insert into pay_assignment_actions.
5989: ln_step := 13;
5990: hr_nonrun_asact.insact(ln_child_xfr_action_id,

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

5995: null,
5996: 'C',
5997: p_xfr_action_id);
5998:
5999: hr_utility.set_location(gv_package || lv_procedure_name, 40);
6000:
6001: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);
6002: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);
6003:

Line 6001: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);

5997: p_xfr_action_id);
5998:
5999: hr_utility.set_location(gv_package || lv_procedure_name, 40);
6000:
6001: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);
6002: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);
6003:
6004: -- insert an interlock to this action
6005: ln_step := 14;

Line 6002: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);

5998:
5999: hr_utility.set_location(gv_package || lv_procedure_name, 40);
6000:
6001: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);
6002: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);
6003:
6004: -- insert an interlock to this action
6005: ln_step := 14;
6006: hr_nonrun_asact.insint(ln_child_xfr_action_id,

Line 6020: hr_utility.trace('Processing Child action ' ||

6016: update pay_assignment_actions
6017: set serial_number = lv_serial_number
6018: where assignment_action_id = ln_child_xfr_action_id;
6019:
6020: hr_utility.trace('Processing Child action ' ||
6021: p_xfr_action_id);
6022:
6023: else
6024: ln_step := 17;

Line 6090: hr_utility.trace('archive_data:payment_info: ln_earnings = ' ||

6086: lv_archive_balance_info := 'Y';
6087: end if;
6088:
6089: /* Bug 3452149 */
6090: hr_utility.trace('archive_data:payment_info: ln_earnings = ' ||
6091: ln_earnings);
6092: hr_utility.trace('archive_data:payment_info: lv_archive_balance_info = ' ||
6093: lv_archive_balance_info);
6094: if ln_earnings <> 0 then

Line 6092: hr_utility.trace('archive_data:payment_info: lv_archive_balance_info = ' ||

6088:
6089: /* Bug 3452149 */
6090: hr_utility.trace('archive_data:payment_info: ln_earnings = ' ||
6091: ln_earnings);
6092: hr_utility.trace('archive_data:payment_info: lv_archive_balance_info = ' ||
6093: lv_archive_balance_info);
6094: if ln_earnings <> 0 then
6095: process_actions(p_xfr_payroll_action_id => ln_xfr_payroll_action_id
6096: ,p_xfr_action_id => ln_child_xfr_action_id

Line 6120: hr_utility.trace('---------Check for un-processed asignments --------');

6116:
6117: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
6118: nvl(lv_master_sepcheck_flag, 'N') = 'N' and
6119: ld_last_xfr_eff_date is not null then
6120: hr_utility.trace('---------Check for un-processed asignments --------');
6121: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
6122: hr_utility.trace('ld_curr_pymt_eff_date = '||ld_curr_pymt_eff_date);
6123: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);
6124: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);

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

6117: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
6118: nvl(lv_master_sepcheck_flag, 'N') = 'N' and
6119: ld_last_xfr_eff_date is not null then
6120: hr_utility.trace('---------Check for un-processed asignments --------');
6121: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
6122: hr_utility.trace('ld_curr_pymt_eff_date = '||ld_curr_pymt_eff_date);
6123: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);
6124: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
6125:

Line 6122: hr_utility.trace('ld_curr_pymt_eff_date = '||ld_curr_pymt_eff_date);

6118: nvl(lv_master_sepcheck_flag, 'N') = 'N' and
6119: ld_last_xfr_eff_date is not null then
6120: hr_utility.trace('---------Check for un-processed asignments --------');
6121: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
6122: hr_utility.trace('ld_curr_pymt_eff_date = '||ld_curr_pymt_eff_date);
6123: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);
6124: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
6125:
6126: /***************************************************************

Line 6123: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);

6119: ld_last_xfr_eff_date is not null then
6120: hr_utility.trace('---------Check for un-processed asignments --------');
6121: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
6122: hr_utility.trace('ld_curr_pymt_eff_date = '||ld_curr_pymt_eff_date);
6123: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);
6124: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
6125:
6126: /***************************************************************
6127: Find out if any assignments have been un-processed. If so,

Line 6124: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);

6120: hr_utility.trace('---------Check for un-processed asignments --------');
6121: hr_utility.trace('ln_assignment_id = '||ln_assignment_id);
6122: hr_utility.trace('ld_curr_pymt_eff_date = '||ld_curr_pymt_eff_date);
6123: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);
6124: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
6125:
6126: /***************************************************************
6127: Find out if any assignments have been un-processed. If so,
6128: archive elements processed in the un-processed assignment

Line 6137: hr_utility.trace('ln_np_asg_id ='||ln_np_asg_id);

6133: p_xfr_action_id,
6134: ln_asg_action_id);
6135: loop
6136: fetch c_get_unproc_asg into ln_np_asg_id, ln_np_asg_action_id;
6137: hr_utility.trace('ln_np_asg_id ='||ln_np_asg_id);
6138: hr_utility.trace('ln_np_asg_action_id ='||ln_np_asg_action_id);
6139:
6140: exit when c_get_unproc_asg%NOTFOUND;
6141:

Line 6138: hr_utility.trace('ln_np_asg_action_id ='||ln_np_asg_action_id);

6134: ln_asg_action_id);
6135: loop
6136: fetch c_get_unproc_asg into ln_np_asg_id, ln_np_asg_action_id;
6137: hr_utility.trace('ln_np_asg_id ='||ln_np_asg_id);
6138: hr_utility.trace('ln_np_asg_action_id ='||ln_np_asg_action_id);
6139:
6140: exit when c_get_unproc_asg%NOTFOUND;
6141:
6142: -- An assignment only needs to be processed once as that will

Line 6153: hr_utility.trace('PrevRun ln_np_asg_id := ' || ln_np_asg_id);

6149: -- last archive date. If they are the same, the element just
6150: -- needs to be moved forward otherwise we need to get the
6151: -- data from run results
6152:
6153: hr_utility.trace('PrevRun ln_np_asg_id := ' || ln_np_asg_id);
6154: hr_utility.trace('PrevRun ln_child_xfr_action_id := ' || ln_child_xfr_action_id);
6155: hr_utility.trace('PrevRun ld_curr_pymt_eff_date := ' || ld_curr_pymt_eff_date);
6156:
6157: open c_prev_run_information(ln_np_asg_id

Line 6154: hr_utility.trace('PrevRun ln_child_xfr_action_id := ' || ln_child_xfr_action_id);

6150: -- needs to be moved forward otherwise we need to get the
6151: -- data from run results
6152:
6153: hr_utility.trace('PrevRun ln_np_asg_id := ' || ln_np_asg_id);
6154: hr_utility.trace('PrevRun ln_child_xfr_action_id := ' || ln_child_xfr_action_id);
6155: hr_utility.trace('PrevRun ld_curr_pymt_eff_date := ' || ld_curr_pymt_eff_date);
6156:
6157: open c_prev_run_information(ln_np_asg_id
6158: ,ln_child_xfr_action_id

Line 6155: hr_utility.trace('PrevRun ld_curr_pymt_eff_date := ' || ld_curr_pymt_eff_date);

6151: -- data from run results
6152:
6153: hr_utility.trace('PrevRun ln_np_asg_id := ' || ln_np_asg_id);
6154: hr_utility.trace('PrevRun ln_child_xfr_action_id := ' || ln_child_xfr_action_id);
6155: hr_utility.trace('PrevRun ld_curr_pymt_eff_date := ' || ld_curr_pymt_eff_date);
6156:
6157: open c_prev_run_information(ln_np_asg_id
6158: ,ln_child_xfr_action_id
6159: ,ld_curr_pymt_eff_date);

Line 6163: hr_utility.trace('ld_np_last_xfr_eff_date='||ld_np_last_xfr_eff_date);

6159: ,ld_curr_pymt_eff_date);
6160: fetch c_prev_run_information into ld_np_last_xfr_eff_date;
6161: close c_prev_run_information;
6162:
6163: hr_utility.trace('ld_np_last_xfr_eff_date='||ld_np_last_xfr_eff_date);
6164: hr_utility.trace('ld_last_xfr_eff_date ='||ld_last_xfr_eff_date);
6165:
6166: if ld_np_last_xfr_eff_date >= ld_last_xfr_eff_date then
6167: -- To be Changed

Line 6164: hr_utility.trace('ld_last_xfr_eff_date ='||ld_last_xfr_eff_date);

6160: fetch c_prev_run_information into ld_np_last_xfr_eff_date;
6161: close c_prev_run_information;
6162:
6163: hr_utility.trace('ld_np_last_xfr_eff_date='||ld_np_last_xfr_eff_date);
6164: hr_utility.trace('ld_last_xfr_eff_date ='||ld_last_xfr_eff_date);
6165:
6166: if ld_np_last_xfr_eff_date >= ld_last_xfr_eff_date then
6167: -- To be Changed
6168: pay_ac_action_arch.get_xfr_elements(

Line 6211: hr_utility.trace('archive_data:payment_info:DONE');

6207: end if; -- ln_earnings
6208:
6209: end loop; -- c_payment_info
6210: close c_payment_info;
6211: hr_utility.trace('archive_data:payment_info:DONE');
6212:
6213: end if; /* P,U */
6214:
6215:

Line 6219: hr_utility.trace('Reversal ln_pymt_balcall_aaid'

6215:
6216: ln_step := 11;
6217: if lv_master_action_type = 'V' then
6218: ln_pymt_balcall_aaid := ln_asg_action_id ;
6219: hr_utility.trace('Reversal ln_pymt_balcall_aaid'
6220: ||to_char(ln_pymt_balcall_aaid));
6221: ln_step := 12;
6222: pay_ac_action_arch.initialization_process;
6223: ln_step := 13;

Line 6253: hr_utility.trace('Reversal ln_pymt_balcall_aaid'

6249: end if;
6250:
6251: ln_step := 15;
6252: if lv_master_action_type = 'B' then
6253: hr_utility.trace('Reversal ln_pymt_balcall_aaid'
6254: ||to_char(ln_pymt_balcall_aaid));
6255: pay_ac_action_arch.initialization_process;
6256: ln_step := 16;
6257: populate_adj_tax_balances(

Line 6285: hr_utility.set_location(gv_package || lv_procedure_name,210);

6281: ** Archive all the payroll action level data once only when
6282: ** chunk number is 1. Also check if this has not been archived
6283: ** earlier
6284: *****************************************************************/
6285: hr_utility.set_location(gv_package || lv_procedure_name,210);
6286: ln_step := 20;
6287: open c_check_pay_action(ln_xfr_payroll_action_id);
6288: fetch c_check_pay_action into ln_pay_action_count;
6289: close c_check_pay_action;

Line 6291: hr_utility.set_location(gv_package || lv_procedure_name,210);

6287: open c_check_pay_action(ln_xfr_payroll_action_id);
6288: fetch c_check_pay_action into ln_pay_action_count;
6289: close c_check_pay_action;
6290: if ln_pay_action_count = 0 then
6291: hr_utility.set_location(gv_package || lv_procedure_name,210);
6292: if ln_chunk_number = 1 then
6293: ln_step := 25;
6294: pay_emp_action_arch.arch_pay_action_level_data(
6295: p_payroll_action_id => ln_xfr_payroll_action_id

Line 6308: hr_utility.trace(lv_error_message || '-' || sqlerrm);

6304: when others then
6305: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
6306: gv_package || lv_procedure_name;
6307:
6308: hr_utility.trace(lv_error_message || '-' || sqlerrm);
6309:
6310: lv_error_message :=
6311: pay_emp_action_arch.set_error_message(lv_error_message);
6312:

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

6309:
6310: lv_error_message :=
6311: pay_emp_action_arch.set_error_message(lv_error_message);
6312:
6313: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
6314: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
6315: hr_utility.raise_error;
6316:
6317: end action_archive_data;

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

6310: lv_error_message :=
6311: pay_emp_action_arch.set_error_message(lv_error_message);
6312:
6313: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
6314: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
6315: hr_utility.raise_error;
6316:
6317: end action_archive_data;
6318:

Line 6315: hr_utility.raise_error;

6311: pay_emp_action_arch.set_error_message(lv_error_message);
6312:
6313: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
6314: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
6315: hr_utility.raise_error;
6316:
6317: end action_archive_data;
6318:
6319:

Line 6343: hr_utility.trace('opened c_get_assignment_id');

6339: from pay_assignment_actions
6340: where assignment_action_id = cp_assignment_action_id;
6341:
6342: BEGIN
6343: hr_utility.trace('opened c_get_assignment_id');
6344:
6345: open c_get_assignment_id(p_assignment_action_id);
6346: fetch c_get_assignment_id into ln_assignment_id;
6347: close c_get_assignment_id;

Line 6349: hr_utility.trace('ln_assignment_id = ' ||

6345: open c_get_assignment_id(p_assignment_action_id);
6346: fetch c_get_assignment_id into ln_assignment_id;
6347: close c_get_assignment_id;
6348:
6349: hr_utility.trace('ln_assignment_id = ' ||
6350: to_char(ln_assignment_id));
6351:
6352: return pqp_us_ff_functions.is_windstar(p_assignment_id => ln_assignment_id);
6353:

Line 6359: hr_utility.trace(lv_error_message || '-' || sqlerrm);

6355: when others then
6356: lv_error_message := 'Error in ' ||
6357: gv_package || lv_procedure_name;
6358:
6359: hr_utility.trace(lv_error_message || '-' || sqlerrm);
6360:
6361: lv_error_message :=
6362: pay_emp_action_arch.set_error_message(lv_error_message);
6363:

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

6360:
6361: lv_error_message :=
6362: pay_emp_action_arch.set_error_message(lv_error_message);
6363:
6364: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
6365: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
6366: hr_utility.raise_error;
6367: END check_alien;
6368:

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

6361: lv_error_message :=
6362: pay_emp_action_arch.set_error_message(lv_error_message);
6363:
6364: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
6365: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
6366: hr_utility.raise_error;
6367: END check_alien;
6368:
6369: --begin

Line 6366: hr_utility.raise_error;

6362: pay_emp_action_arch.set_error_message(lv_error_message);
6363:
6364: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
6365: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
6366: hr_utility.raise_error;
6367: END check_alien;
6368:
6369: --begin
6370: --hr_utility.trace_on (null, 'XFR');

Line 6370: --hr_utility.trace_on (null, 'XFR');

6366: hr_utility.raise_error;
6367: END check_alien;
6368:
6369: --begin
6370: --hr_utility.trace_on (null, 'XFR');
6371:
6372: end pay_us_action_arch;