eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_COIDA_ARCHIVE dependencies on HR_UTILITY

Line 197: hr_utility.set_location('Entering '||l_proc,10);

193: begin
194:
195: l_proc := g_package||'range_cursor';
196: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);
197: hr_utility.set_location('Entering '||l_proc,10);
198:
199: open csr_archive_effective_date;
200: fetch csr_archive_effective_date into g_arch_effective_date;
201: close csr_archive_effective_date;

Line 323: hr_utility.set_location('Populating ZA_COID_PAYROLL_INFO',60);

319: and ppf.payroll_id = ass.payroll_id
320: and ppf.payroll_id = ppa.payroll_id
321: order by ass.person_id';
322:
323: hr_utility.set_location('Populating ZA_COID_PAYROLL_INFO',60);
324: -- Archive 'ZA_COID_PAYROLL_INFO'
325: pay_action_information_api.create_action_information
326: (
327: p_action_information_id => l_action_info_id,

Line 353: hr_utility.set_location('Leaving '||l_proc,90);

349: p_action_information17 => l_num_of_months1,
350: p_action_information18 => l_num_of_months2
351: );
352:
353: hr_utility.set_location('Leaving '||l_proc,90);
354: end range_cursor;
355:
356: procedure action_creation
357: (

Line 417: hr_utility.set_location('Entering '||l_proc, 10);

413: lockingactid number;
414: leg_param varchar2(2000);
415:
416: begin
417: hr_utility.set_location('Entering '||l_proc, 10);
418: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);
419:
420: -- Retrieve legislative parameters from the archiver payroll action
421: select legislative_parameters

Line 435: hr_utility.set_location('Assignment_id : ' || to_char(asgrec.assignment_id), 20);

431: set_globals(pactid);
432: end if;
433:
434: for asgrec in csr_assignments(l_payroll_id,l_end_prd_id,l_strt_prd_id) loop
435: hr_utility.set_location('Assignment_id : ' || to_char(asgrec.assignment_id), 20);
436: -- Remove duplicate assignments
437: if prev_asg_id <> asgrec.assignment_id then -- revisit -- check if required?
438:
439: prev_asg_id := asgrec.assignment_id;

Line 441: hr_utility.set_location('Creating action for assignment_id '||asgrec.assignment_id, 50);

437: if prev_asg_id <> asgrec.assignment_id then -- revisit -- check if required?
438:
439: prev_asg_id := asgrec.assignment_id;
440:
441: hr_utility.set_location('Creating action for assignment_id '||asgrec.assignment_id, 50);
442: select pay_assignment_actions_s.nextval
443: into lockingactid
444: from dual;
445:

Line 459: hr_utility.set_location('Leaving '||l_proc, 999);

455:
456: end if;
457: end loop;
458:
459: hr_utility.set_location('Leaving '||l_proc, 999);
460: end action_creation;
461:
462: -----------------------------------------------------------------------
463: --procedure create_act_inf

Line 497: hr_utility.set_location('Entering: '||l_proc,1);

493: l_proc varchar2(200):= g_package||'create_act_inf';
494: l_ovn number;
495: l_action_id number;
496: begin
497: hr_utility.set_location('Entering: '||l_proc,1);
498: pay_action_information_api.create_action_information
499: (
500: p_action_information_id => l_action_id,
501: p_action_context_id => p_action_context_id,

Line 529: hr_utility.set_location('Leaving: '||l_proc,1);

525: p_action_information30 => p_action_information30,
526: p_assignment_id => p_assignment_id
527: );
528:
529: hr_utility.set_location('Leaving: '||l_proc,1);
530:
531: end create_act_inf;
532:
533:

Line 588: hr_utility.set_location('Entering '||l_proc,10);

584: l_value varchar2(2);
585: l_proc varchar2(200) :=g_package||'retrieve_asg_type';
586: begin
587:
588: hr_utility.set_location('Entering '||l_proc,10);
589: if p_forgn_nat = 'Y' then
590: open csr_result_value;
591: fetch csr_result_value into l_value;
592: close csr_result_value;

Line 593: hr_utility.set_location('l_value: '||l_value,20);

589: if p_forgn_nat = 'Y' then
590: open csr_result_value;
591: fetch csr_result_value into l_value;
592: close csr_result_value;
593: hr_utility.set_location('l_value: '||l_value,20);
594: end if;
595:
596: if p_exclude_coida <> 'Y' then -- 12534150
597: if (p_nature in ('03','04','05','06','07', '08')

Line 608: hr_utility.set_location('Leaving '||l_proc,10);

604: else
605: return null;
606: end if ; -- end 12534150 to check if excluded from coida report
607:
608: hr_utility.set_location('Leaving '||l_proc,10);
609:
610: end retrieve_asg_type;
611:
612: -------------------------------------------------------------------------

Line 632: hr_utility.set_location('Entering '||l_proc,10);

628:
629: l_def_bal_id number;
630: l_proc varchar2(200):=g_package||'get_def_bal_id';
631: begin
632: hr_utility.set_location('Entering '||l_proc,10);
633: open c_get_def_bal_id;
634: fetch c_get_def_bal_id into l_def_bal_id ;
635: close c_get_def_bal_id ;
636:

Line 638: hr_utility.set_location('Leaving '||l_proc,90);

634: fetch c_get_def_bal_id into l_def_bal_id ;
635: close c_get_def_bal_id ;
636:
637: return l_def_bal_id;
638: hr_utility.set_location('Leaving '||l_proc,90);
639:
640: end get_def_bal_id;
641:
642: -----------------------------------------------------------------------

Line 692: hr_utility.set_location('Entering '||l_proc,10);

688:
689: l_per_system_status varchar2(50); -- Bug#11938675
690:
691: begin
692: hr_utility.set_location('Entering '||l_proc,10);
693: l_days_worked := p_days_worked;
694: l_tot_coid_def_id := get_def_bal_id('Total COIDAable Income','_ASG_TAX_MTD');
695: l_meal_vouc_rfi_def_id := get_def_bal_id('Meals Refreshments and Vouchers RFI' ,'_ASG_TAX_MTD');
696: l_meal_vouc_nrfi_def_id := get_def_bal_id('Meals Refreshments and Vouchers NRFI','_ASG_TAX_MTD');

Line 701: hr_utility.set_location('get_def_bal_id ',10);

697: l_free_acc_rfi_def_id := get_def_bal_id('Free or Cheap Accommodation RFI' ,'_ASG_TAX_MTD');
698: l_free_acc_nrfi_def_id := get_def_bal_id('Free or Cheap Accommodation NRFI','_ASG_TAX_MTD');
699: --Have not retrieved the value of COIDAable Normal Income as this is not used specifically anywhere
700: --Its value will add up to balance Total COIDAable Income
701: hr_utility.set_location('get_def_bal_id ',10);
702: l_start_py_adv_dt := to_date('01/'||to_char(p_date,'MM')||'/'||to_char(p_date,'YYYY'),'DD/MM/YYYY');
703: hr_utility.set_location('l_start_py_adv_dt ' || l_start_py_adv_dt,20);
704: l_run_assact_id :=0;
705: hr_utility.set_location('l_run_assact_id ' || l_run_assact_id,20);

Line 703: hr_utility.set_location('l_start_py_adv_dt ' || l_start_py_adv_dt,20);

699: --Have not retrieved the value of COIDAable Normal Income as this is not used specifically anywhere
700: --Its value will add up to balance Total COIDAable Income
701: hr_utility.set_location('get_def_bal_id ',10);
702: l_start_py_adv_dt := to_date('01/'||to_char(p_date,'MM')||'/'||to_char(p_date,'YYYY'),'DD/MM/YYYY');
703: hr_utility.set_location('l_start_py_adv_dt ' || l_start_py_adv_dt,20);
704: l_run_assact_id :=0;
705: hr_utility.set_location('l_run_assact_id ' || l_run_assact_id,20);
706: select max(paa.action_sequence)
707: into l_run_action_seq

Line 705: hr_utility.set_location('l_run_assact_id ' || l_run_assact_id,20);

701: hr_utility.set_location('get_def_bal_id ',10);
702: l_start_py_adv_dt := to_date('01/'||to_char(p_date,'MM')||'/'||to_char(p_date,'YYYY'),'DD/MM/YYYY');
703: hr_utility.set_location('l_start_py_adv_dt ' || l_start_py_adv_dt,20);
704: l_run_assact_id :=0;
705: hr_utility.set_location('l_run_assact_id ' || l_run_assact_id,20);
706: select max(paa.action_sequence)
707: into l_run_action_seq
708: from pay_assignment_actions paa,
709: pay_payroll_actions ppa,

Line 722: hr_utility.set_location('l_run_action_seq ' || l_run_action_seq,20);

718: and ptp.pay_advice_date <= p_date
719: and ptp.pay_advice_date >= l_start_py_adv_dt
720: and ptp.payroll_id = p_payroll_id; -- Bug # 12329847 and 12334564
721:
722: hr_utility.set_location('l_run_action_seq ' || l_run_action_seq,20);
723:
724: if l_run_action_seq is not null then
725:
726: hr_utility.set_location('l_run_action_seq is not null ' ,30);

Line 726: hr_utility.set_location('l_run_action_seq is not null ' ,30);

722: hr_utility.set_location('l_run_action_seq ' || l_run_action_seq,20);
723:
724: if l_run_action_seq is not null then
725:
726: hr_utility.set_location('l_run_action_seq is not null ' ,30);
727:
728: select assignment_action_id
729: into l_run_assact_id
730: from pay_assignment_actions

Line 734: hr_utility.set_location('l_run_assact_id ' || l_run_assact_id,30);

730: from pay_assignment_actions
731: where assignment_id = p_asg_id
732: and action_sequence = l_run_action_seq;
733:
734: hr_utility.set_location('l_run_assact_id ' || l_run_assact_id,30);
735: -- Bug # 12329847 and 12334564
736:
737: else
738: /* get the period for which we should check the assigment has this payroll attached */

Line 751: hr_utility.set_location('l_start_date :'||l_start_date,15);

747: and ptp.pay_advice_date >= L_START_PY_ADV_DT;
748:
749: /* If the l_start_date or l_end_date is null invalid data return without doing anything */
750:
751: hr_utility.set_location('l_start_date :'||l_start_date,15);
752: hr_utility.set_location('l_end_date :'||l_end_date,15);
753:
754: if l_start_date is null or l_end_date is null then
755:

Line 752: hr_utility.set_location('l_end_date :'||l_end_date,15);

748:
749: /* If the l_start_date or l_end_date is null invalid data return without doing anything */
750:
751: hr_utility.set_location('l_start_date :'||l_start_date,15);
752: hr_utility.set_location('l_end_date :'||l_end_date,15);
753:
754: if l_start_date is null or l_end_date is null then
755:
756: return ;

Line 772: hr_utility.set_location('l_payroll_exists :'||l_payroll_exists,15);

768: and asg.effective_start_date <= l_end_date
769: and asg.effective_end_date >= l_start_date
770: and asg.payroll_id = p_payroll_id; -- Bug#11938675
771:
772: hr_utility.set_location('l_payroll_exists :'||l_payroll_exists,15);
773: if l_payroll_exists = 0 then
774:
775: /* person does not have the provided payroll attached during the period */
776:

Line 788: hr_utility.set_location('p_date :'||p_date,15);

784:
785: -- Bug#11938675
786:
787: begin
788: hr_utility.set_location('p_date :'||p_date,15);
789: hr_utility.set_location('L_START_PY_ADV_DT :'||L_START_PY_ADV_DT,15);
790:
791: select max(past.per_system_status)
792: into l_per_system_status

Line 789: hr_utility.set_location('L_START_PY_ADV_DT :'||L_START_PY_ADV_DT,15);

785: -- Bug#11938675
786:
787: begin
788: hr_utility.set_location('p_date :'||p_date,15);
789: hr_utility.set_location('L_START_PY_ADV_DT :'||L_START_PY_ADV_DT,15);
790:
791: select max(past.per_system_status)
792: into l_per_system_status
793: from per_assignment_status_types past,

Line 801: hr_utility.set_location('l_per_system_status from query :'||l_per_system_status,15);

797: and past.per_system_status = 'ACTIVE_ASSIGN'
798: and asg.effective_start_date <= p_date
799: and asg.effective_end_date >= L_START_PY_ADV_DT;
800:
801: hr_utility.set_location('l_per_system_status from query :'||l_per_system_status,15);
802:
803: if l_per_system_status is null then
804:
805: select past.per_system_status

Line 813: hr_utility.set_location('l_per_system_status from if block :'||l_per_system_status,15);

809: where past.assignment_status_type_id = asg.assignment_status_type_id
810: and asg.assignment_id = p_asg_id
811: and p_date between asg.effective_start_date and asg.effective_end_date;
812:
813: hr_utility.set_location('l_per_system_status from if block :'||l_per_system_status,15);
814: end if;
815: exception
816: when others then
817: raise;

Line 819: hr_utility.set_location('l_per_system_status :'||l_per_system_status,15);

815: exception
816: when others then
817: raise;
818: end;
819: hr_utility.set_location('l_per_system_status :'||l_per_system_status,15);
820: -- Bug#11938675
821:
822:
823: begin

Line 839: hr_utility.set_location('l_person_type '|| l_person_type || ' :'||l_proc,20);

835: AND pptu.person_id = p_person_id
836: AND pptu.person_type_id = ppt.person_type_id
837: AND ppt.system_person_type in ('EMP','EX_EMP');
838:
839: hr_utility.set_location('l_person_type '|| l_person_type || ' :'||l_proc,20);
840:
841: if nvl(l_run_assact_id ,0) > 0 then
842: -- l_tot_coid_income := pay_balance_pkg.get_value(l_tot_coid_def_id , p_asg_id , p_date);
843: l_tot_coid_income := pay_balance_pkg.get_value(p_defined_balance_id=>l_tot_coid_def_id , p_assignment_action_id => l_run_assact_id);

Line 850: hr_utility.set_location('l_cash_component '|| l_cash_component || ' :',20);

846: l_free_acc_rfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_rfi_def_id , p_assignment_action_id => l_run_assact_id);
847: l_free_acc_nrfi := pay_balance_pkg.get_value(p_defined_balance_id=>l_free_acc_nrfi_def_id , p_assignment_action_id => l_run_assact_id);
848:
849: l_cash_component := l_meal_vouc_rfi + l_meal_vouc_nrfi + l_free_acc_rfi + l_free_acc_nrfi;
850: hr_utility.set_location('l_cash_component '|| l_cash_component || ' :',20);
851: /* Check if the p_days_worked and l_run_assact_id */
852: /* To cater for the terminated employee to be reported in the period where they have the earnings */
853: hr_utility.set_location('l_days_worked '|| l_days_worked || ' :',20);
854: if l_days_worked = 0 then

Line 853: hr_utility.set_location('l_days_worked '|| l_days_worked || ' :',20);

849: l_cash_component := l_meal_vouc_rfi + l_meal_vouc_nrfi + l_free_acc_rfi + l_free_acc_nrfi;
850: hr_utility.set_location('l_cash_component '|| l_cash_component || ' :',20);
851: /* Check if the p_days_worked and l_run_assact_id */
852: /* To cater for the terminated employee to be reported in the period where they have the earnings */
853: hr_utility.set_location('l_days_worked '|| l_days_worked || ' :',20);
854: if l_days_worked = 0 then
855: begin
856: hr_utility.set_location('getting max(PAY_ADVICE_DATE)+1 ',20);
857: select max(PAY_ADVICE_DATE)+1

Line 856: hr_utility.set_location('getting max(PAY_ADVICE_DATE)+1 ',20);

852: /* To cater for the terminated employee to be reported in the period where they have the earnings */
853: hr_utility.set_location('l_days_worked '|| l_days_worked || ' :',20);
854: if l_days_worked = 0 then
855: begin
856: hr_utility.set_location('getting max(PAY_ADVICE_DATE)+1 ',20);
857: select max(PAY_ADVICE_DATE)+1
858: into l_pay_adv_start_date
859: from per_time_periods
860: where payroll_id=p_payroll_id

Line 863: hr_utility.set_location('l_pay_adv_start_date '|| l_pay_adv_start_date || ' :',30);

859: from per_time_periods
860: where payroll_id=p_payroll_id
861: and PAY_ADVICE_DATE < l_start_py_adv_dt;
862:
863: hr_utility.set_location('l_pay_adv_start_date '|| l_pay_adv_start_date || ' :',30);
864:
865: l_pay_adv_start_date:= nvl(l_pay_adv_start_date,l_start_py_adv_dt); -- Bug 12572065
866:
867: exception

Line 871: hr_utility.set_location('no_data_found ',70);

867: exception
868: when no_data_found then
869: --No payroll calendar exist before this date. Hence default the start date to first of this month
870: -- l_pay_adv_start_date := trunc(rec_pay_dates.pay_advice_date,'MM');
871: hr_utility.set_location('no_data_found ',70);
872: hr_utility.set_location('l_start_py_adv_dt '|| l_start_py_adv_dt || ' :',70);
873: l_pay_adv_start_date := l_start_py_adv_dt;
874:
875: end;

Line 872: hr_utility.set_location('l_start_py_adv_dt '|| l_start_py_adv_dt || ' :',70);

868: when no_data_found then
869: --No payroll calendar exist before this date. Hence default the start date to first of this month
870: -- l_pay_adv_start_date := trunc(rec_pay_dates.pay_advice_date,'MM');
871: hr_utility.set_location('no_data_found ',70);
872: hr_utility.set_location('l_start_py_adv_dt '|| l_start_py_adv_dt || ' :',70);
873: l_pay_adv_start_date := l_start_py_adv_dt;
874:
875: end;
876: hr_utility.set_location('Before py_za_coida_pkg.get_working_days',75);

Line 876: hr_utility.set_location('Before py_za_coida_pkg.get_working_days',75);

872: hr_utility.set_location('l_start_py_adv_dt '|| l_start_py_adv_dt || ' :',70);
873: l_pay_adv_start_date := l_start_py_adv_dt;
874:
875: end;
876: hr_utility.set_location('Before py_za_coida_pkg.get_working_days',75);
877: l_days_worked := py_za_coida_pkg.get_working_days
878: (
879: p_period_start => l_pay_adv_start_date
880: ,p_period_end => p_date

Line 882: hr_utility.set_location('After py_za_coida_pkg.get_working_days',75);

878: (
879: p_period_start => l_pay_adv_start_date
880: ,p_period_end => p_date
881: );
882: hr_utility.set_location('After py_za_coida_pkg.get_working_days',75);
883: end if;
884:
885:
886: /* End for terminated employee check*/

Line 913: hr_utility.set_location('Before get_act_earnings',75);

909: --Month for which the balance value is retrieved
910: l_month :=to_char(p_date,'MON'); --modified
911:
912: --Calculate the actual earnings
913: hr_utility.set_location('Before get_act_earnings',75);
914: get_act_earnings
915: (
916: p_total_return => l_total_return
917: , p_days_worked => l_days_worked

Line 922: hr_utility.set_location('After get_act_earnings',75);

918: , p_date => p_date
919: , p_act_earn1 => l_actual_earnings1
920: , p_act_earn2 => l_actual_earnings2
921: );
922: hr_utility.set_location('After get_act_earnings',75);
923: --'99999999990D99'
924:
925: hr_utility.set_location('Before populating ZA_COID_EMP_INCOME_INFO',85);
926: hr_utility.set_location('l_month :'||l_month,85);

Line 925: hr_utility.set_location('Before populating ZA_COID_EMP_INCOME_INFO',85);

921: );
922: hr_utility.set_location('After get_act_earnings',75);
923: --'99999999990D99'
924:
925: hr_utility.set_location('Before populating ZA_COID_EMP_INCOME_INFO',85);
926: hr_utility.set_location('l_month :'||l_month,85);
927: hr_utility.set_location('l_norm_income :'||l_norm_income,85);
928: hr_utility.set_location('l_dir_income :'||l_dir_income,85);
929: hr_utility.set_location('l_cash_component :'||l_cash_component,85);

Line 926: hr_utility.set_location('l_month :'||l_month,85);

922: hr_utility.set_location('After get_act_earnings',75);
923: --'99999999990D99'
924:
925: hr_utility.set_location('Before populating ZA_COID_EMP_INCOME_INFO',85);
926: hr_utility.set_location('l_month :'||l_month,85);
927: hr_utility.set_location('l_norm_income :'||l_norm_income,85);
928: hr_utility.set_location('l_dir_income :'||l_dir_income,85);
929: hr_utility.set_location('l_cash_component :'||l_cash_component,85);
930: hr_utility.set_location('l_total_return :'||l_total_return,85);

Line 927: hr_utility.set_location('l_norm_income :'||l_norm_income,85);

923: --'99999999990D99'
924:
925: hr_utility.set_location('Before populating ZA_COID_EMP_INCOME_INFO',85);
926: hr_utility.set_location('l_month :'||l_month,85);
927: hr_utility.set_location('l_norm_income :'||l_norm_income,85);
928: hr_utility.set_location('l_dir_income :'||l_dir_income,85);
929: hr_utility.set_location('l_cash_component :'||l_cash_component,85);
930: hr_utility.set_location('l_total_return :'||l_total_return,85);
931: hr_utility.set_location('l_actual_earnings1 :'||l_actual_earnings1,85);

Line 928: hr_utility.set_location('l_dir_income :'||l_dir_income,85);

924:
925: hr_utility.set_location('Before populating ZA_COID_EMP_INCOME_INFO',85);
926: hr_utility.set_location('l_month :'||l_month,85);
927: hr_utility.set_location('l_norm_income :'||l_norm_income,85);
928: hr_utility.set_location('l_dir_income :'||l_dir_income,85);
929: hr_utility.set_location('l_cash_component :'||l_cash_component,85);
930: hr_utility.set_location('l_total_return :'||l_total_return,85);
931: hr_utility.set_location('l_actual_earnings1 :'||l_actual_earnings1,85);
932: hr_utility.set_location('l_actual_earnings2 :'||l_actual_earnings2,85);

Line 929: hr_utility.set_location('l_cash_component :'||l_cash_component,85);

925: hr_utility.set_location('Before populating ZA_COID_EMP_INCOME_INFO',85);
926: hr_utility.set_location('l_month :'||l_month,85);
927: hr_utility.set_location('l_norm_income :'||l_norm_income,85);
928: hr_utility.set_location('l_dir_income :'||l_dir_income,85);
929: hr_utility.set_location('l_cash_component :'||l_cash_component,85);
930: hr_utility.set_location('l_total_return :'||l_total_return,85);
931: hr_utility.set_location('l_actual_earnings1 :'||l_actual_earnings1,85);
932: hr_utility.set_location('l_actual_earnings2 :'||l_actual_earnings2,85);
933: hr_utility.set_location('p_days_worked :'||p_days_worked,85);

Line 930: hr_utility.set_location('l_total_return :'||l_total_return,85);

926: hr_utility.set_location('l_month :'||l_month,85);
927: hr_utility.set_location('l_norm_income :'||l_norm_income,85);
928: hr_utility.set_location('l_dir_income :'||l_dir_income,85);
929: hr_utility.set_location('l_cash_component :'||l_cash_component,85);
930: hr_utility.set_location('l_total_return :'||l_total_return,85);
931: hr_utility.set_location('l_actual_earnings1 :'||l_actual_earnings1,85);
932: hr_utility.set_location('l_actual_earnings2 :'||l_actual_earnings2,85);
933: hr_utility.set_location('p_days_worked :'||p_days_worked,85);
934: hr_utility.set_location('l_days_worked :'||l_days_worked,85);

Line 931: hr_utility.set_location('l_actual_earnings1 :'||l_actual_earnings1,85);

927: hr_utility.set_location('l_norm_income :'||l_norm_income,85);
928: hr_utility.set_location('l_dir_income :'||l_dir_income,85);
929: hr_utility.set_location('l_cash_component :'||l_cash_component,85);
930: hr_utility.set_location('l_total_return :'||l_total_return,85);
931: hr_utility.set_location('l_actual_earnings1 :'||l_actual_earnings1,85);
932: hr_utility.set_location('l_actual_earnings2 :'||l_actual_earnings2,85);
933: hr_utility.set_location('p_days_worked :'||p_days_worked,85);
934: hr_utility.set_location('l_days_worked :'||l_days_worked,85);
935: hr_utility.set_location('p_asg_type :'||p_asg_type,85);

Line 932: hr_utility.set_location('l_actual_earnings2 :'||l_actual_earnings2,85);

928: hr_utility.set_location('l_dir_income :'||l_dir_income,85);
929: hr_utility.set_location('l_cash_component :'||l_cash_component,85);
930: hr_utility.set_location('l_total_return :'||l_total_return,85);
931: hr_utility.set_location('l_actual_earnings1 :'||l_actual_earnings1,85);
932: hr_utility.set_location('l_actual_earnings2 :'||l_actual_earnings2,85);
933: hr_utility.set_location('p_days_worked :'||p_days_worked,85);
934: hr_utility.set_location('l_days_worked :'||l_days_worked,85);
935: hr_utility.set_location('p_asg_type :'||p_asg_type,85);
936: hr_utility.set_location('p_person_id :'||p_person_id,85);

Line 933: hr_utility.set_location('p_days_worked :'||p_days_worked,85);

929: hr_utility.set_location('l_cash_component :'||l_cash_component,85);
930: hr_utility.set_location('l_total_return :'||l_total_return,85);
931: hr_utility.set_location('l_actual_earnings1 :'||l_actual_earnings1,85);
932: hr_utility.set_location('l_actual_earnings2 :'||l_actual_earnings2,85);
933: hr_utility.set_location('p_days_worked :'||p_days_worked,85);
934: hr_utility.set_location('l_days_worked :'||l_days_worked,85);
935: hr_utility.set_location('p_asg_type :'||p_asg_type,85);
936: hr_utility.set_location('p_person_id :'||p_person_id,85);
937: --Archive ZA_COID_EMP_INCOME_INFO

Line 934: hr_utility.set_location('l_days_worked :'||l_days_worked,85);

930: hr_utility.set_location('l_total_return :'||l_total_return,85);
931: hr_utility.set_location('l_actual_earnings1 :'||l_actual_earnings1,85);
932: hr_utility.set_location('l_actual_earnings2 :'||l_actual_earnings2,85);
933: hr_utility.set_location('p_days_worked :'||p_days_worked,85);
934: hr_utility.set_location('l_days_worked :'||l_days_worked,85);
935: hr_utility.set_location('p_asg_type :'||p_asg_type,85);
936: hr_utility.set_location('p_person_id :'||p_person_id,85);
937: --Archive ZA_COID_EMP_INCOME_INFO
938:

Line 935: hr_utility.set_location('p_asg_type :'||p_asg_type,85);

931: hr_utility.set_location('l_actual_earnings1 :'||l_actual_earnings1,85);
932: hr_utility.set_location('l_actual_earnings2 :'||l_actual_earnings2,85);
933: hr_utility.set_location('p_days_worked :'||p_days_worked,85);
934: hr_utility.set_location('l_days_worked :'||l_days_worked,85);
935: hr_utility.set_location('p_asg_type :'||p_asg_type,85);
936: hr_utility.set_location('p_person_id :'||p_person_id,85);
937: --Archive ZA_COID_EMP_INCOME_INFO
938:
939: if ((l_person_type = 'EMP')

Line 936: hr_utility.set_location('p_person_id :'||p_person_id,85);

932: hr_utility.set_location('l_actual_earnings2 :'||l_actual_earnings2,85);
933: hr_utility.set_location('p_days_worked :'||p_days_worked,85);
934: hr_utility.set_location('l_days_worked :'||l_days_worked,85);
935: hr_utility.set_location('p_asg_type :'||p_asg_type,85);
936: hr_utility.set_location('p_person_id :'||p_person_id,85);
937: --Archive ZA_COID_EMP_INCOME_INFO
938:
939: if ((l_person_type = 'EMP')
940: OR

Line 942: hr_utility.set_location('Inside if to archive ZA_COID_EMP_INCOME_INFO '||l_proc,85);

938:
939: if ((l_person_type = 'EMP')
940: OR
941: (l_person_type = 'EX_EMP' and l_total_return > 0)) then
942: hr_utility.set_location('Inside if to archive ZA_COID_EMP_INCOME_INFO '||l_proc,85);
943:
944: -- Bug # 12329847 and 12334564
945: /* condition to exclude the directors which have no coidable earnings */
946:

Line 959: hr_utility.set_location('Inside if to archive ZA_COID_EMP_INCOME_INFO after assigment check'||l_proc,86);

955: if ((l_per_system_status = 'ACTIVE_ASSIGN')
956: or
957: (l_per_system_status <>'ACTIVE_ASSIGN' and l_total_return > 0)) then
958:
959: hr_utility.set_location('Inside if to archive ZA_COID_EMP_INCOME_INFO after assigment check'||l_proc,86);
960:
961: -- Bug#11938675
962:
963:

Line 985: hr_utility.set_location('Outside failing assigment check'||l_proc,86);

981: , p_action_information30 => p_person_id
982: , p_assignment_id => p_asg_id
983: );
984: else -- Bug#11938675
985: hr_utility.set_location('Outside failing assigment check'||l_proc,86);
986: return; -- Bug#11938675
987: end if ; -- Bug#11938675
988: end if; -- Bug # 12329847 and 12334564
989:

Line 991: hr_utility.set_location('Leaving '||l_proc,90);

987: end if ; -- Bug#11938675
988: end if; -- Bug # 12329847 and 12334564
989:
990: end if;
991: hr_utility.set_location('Leaving '||l_proc,90);
992:
993: exception
994: when no_data_found then
995: --Assignment is not active in this period

Line 997: hr_utility.set_location('Assignment not active in the period',100);

993: exception
994: when no_data_found then
995: --Assignment is not active in this period
996: --Hence dont archive any row of the assignment for the particular month
997: hr_utility.set_location('Assignment not active in the period',100);
998: return;
999: end;
1000:
1001: end process_balance;

Line 1077: -- hr_utility.trace_on(null,'ZACOIDA');

1073: l_pay_adv_start_date date;
1074: leg_param varchar2(2000);
1075: pactid number;
1076: begin
1077: -- hr_utility.trace_on(null,'ZACOIDA');
1078: hr_utility.set_location('Entering '||l_proc, 10);
1079: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);
1080: hr_utility.set_location('p_assactid: '||p_assactid,10);
1081:

Line 1078: hr_utility.set_location('Entering '||l_proc, 10);

1074: leg_param varchar2(2000);
1075: pactid number;
1076: begin
1077: -- hr_utility.trace_on(null,'ZACOIDA');
1078: hr_utility.set_location('Entering '||l_proc, 10);
1079: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);
1080: hr_utility.set_location('p_assactid: '||p_assactid,10);
1081:
1082: -- Retrieve legislative parameters from the archiver payroll action

Line 1080: hr_utility.set_location('p_assactid: '||p_assactid,10);

1076: begin
1077: -- hr_utility.trace_on(null,'ZACOIDA');
1078: hr_utility.set_location('Entering '||l_proc, 10);
1079: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);
1080: hr_utility.set_location('p_assactid: '||p_assactid,10);
1081:
1082: -- Retrieve legislative parameters from the archiver payroll action
1083: select ppa.legislative_parameters, ppa.payroll_action_id
1084: into leg_param , pactid

Line 1100: hr_utility.set_location('g_arch_effective_date :'||to_char(g_arch_effective_date,'dd-mm-yyyy'),15);

1096: set_globals(pactid);
1097: end if;
1098:
1099: g_arch_effective_date :=p_effective_date;
1100: hr_utility.set_location('g_arch_effective_date :'||to_char(g_arch_effective_date,'dd-mm-yyyy'),15);
1101: hr_utility.set_location('l_payroll_id :'||l_payroll_id,15);
1102: hr_utility.set_location('l_end_prd_id :'||l_end_prd_id,15);
1103: hr_utility.set_location('l_strt_prd_id :'||l_strt_prd_id,15);
1104: hr_utility.set_location('g_coida_limit1 :'||g_coida_limit1,15);

Line 1101: hr_utility.set_location('l_payroll_id :'||l_payroll_id,15);

1097: end if;
1098:
1099: g_arch_effective_date :=p_effective_date;
1100: hr_utility.set_location('g_arch_effective_date :'||to_char(g_arch_effective_date,'dd-mm-yyyy'),15);
1101: hr_utility.set_location('l_payroll_id :'||l_payroll_id,15);
1102: hr_utility.set_location('l_end_prd_id :'||l_end_prd_id,15);
1103: hr_utility.set_location('l_strt_prd_id :'||l_strt_prd_id,15);
1104: hr_utility.set_location('g_coida_limit1 :'||g_coida_limit1,15);
1105: hr_utility.set_location('g_coida_limit2 :'||g_coida_limit2,15);

Line 1102: hr_utility.set_location('l_end_prd_id :'||l_end_prd_id,15);

1098:
1099: g_arch_effective_date :=p_effective_date;
1100: hr_utility.set_location('g_arch_effective_date :'||to_char(g_arch_effective_date,'dd-mm-yyyy'),15);
1101: hr_utility.set_location('l_payroll_id :'||l_payroll_id,15);
1102: hr_utility.set_location('l_end_prd_id :'||l_end_prd_id,15);
1103: hr_utility.set_location('l_strt_prd_id :'||l_strt_prd_id,15);
1104: hr_utility.set_location('g_coida_limit1 :'||g_coida_limit1,15);
1105: hr_utility.set_location('g_coida_limit2 :'||g_coida_limit2,15);
1106: hr_utility.set_location('g_coida_start1 :'||to_char(g_coida_start1,'dd-mm-yyyy'),15);

Line 1103: hr_utility.set_location('l_strt_prd_id :'||l_strt_prd_id,15);

1099: g_arch_effective_date :=p_effective_date;
1100: hr_utility.set_location('g_arch_effective_date :'||to_char(g_arch_effective_date,'dd-mm-yyyy'),15);
1101: hr_utility.set_location('l_payroll_id :'||l_payroll_id,15);
1102: hr_utility.set_location('l_end_prd_id :'||l_end_prd_id,15);
1103: hr_utility.set_location('l_strt_prd_id :'||l_strt_prd_id,15);
1104: hr_utility.set_location('g_coida_limit1 :'||g_coida_limit1,15);
1105: hr_utility.set_location('g_coida_limit2 :'||g_coida_limit2,15);
1106: hr_utility.set_location('g_coida_start1 :'||to_char(g_coida_start1,'dd-mm-yyyy'),15);
1107: hr_utility.set_location('g_coida_end1 :'||to_char(g_coida_end1,'dd-mm-yyyy'),15);

Line 1104: hr_utility.set_location('g_coida_limit1 :'||g_coida_limit1,15);

1100: hr_utility.set_location('g_arch_effective_date :'||to_char(g_arch_effective_date,'dd-mm-yyyy'),15);
1101: hr_utility.set_location('l_payroll_id :'||l_payroll_id,15);
1102: hr_utility.set_location('l_end_prd_id :'||l_end_prd_id,15);
1103: hr_utility.set_location('l_strt_prd_id :'||l_strt_prd_id,15);
1104: hr_utility.set_location('g_coida_limit1 :'||g_coida_limit1,15);
1105: hr_utility.set_location('g_coida_limit2 :'||g_coida_limit2,15);
1106: hr_utility.set_location('g_coida_start1 :'||to_char(g_coida_start1,'dd-mm-yyyy'),15);
1107: hr_utility.set_location('g_coida_end1 :'||to_char(g_coida_end1,'dd-mm-yyyy'),15);
1108: hr_utility.set_location('g_coida_start2 :'||to_char(g_coida_start2,'dd-mm-yyyy'),15);

Line 1105: hr_utility.set_location('g_coida_limit2 :'||g_coida_limit2,15);

1101: hr_utility.set_location('l_payroll_id :'||l_payroll_id,15);
1102: hr_utility.set_location('l_end_prd_id :'||l_end_prd_id,15);
1103: hr_utility.set_location('l_strt_prd_id :'||l_strt_prd_id,15);
1104: hr_utility.set_location('g_coida_limit1 :'||g_coida_limit1,15);
1105: hr_utility.set_location('g_coida_limit2 :'||g_coida_limit2,15);
1106: hr_utility.set_location('g_coida_start1 :'||to_char(g_coida_start1,'dd-mm-yyyy'),15);
1107: hr_utility.set_location('g_coida_end1 :'||to_char(g_coida_end1,'dd-mm-yyyy'),15);
1108: hr_utility.set_location('g_coida_start2 :'||to_char(g_coida_start2,'dd-mm-yyyy'),15);
1109: hr_utility.set_location('g_coida_end2 :'||to_char(g_coida_end2,'dd-mm-yyyy'),15);

Line 1106: hr_utility.set_location('g_coida_start1 :'||to_char(g_coida_start1,'dd-mm-yyyy'),15);

1102: hr_utility.set_location('l_end_prd_id :'||l_end_prd_id,15);
1103: hr_utility.set_location('l_strt_prd_id :'||l_strt_prd_id,15);
1104: hr_utility.set_location('g_coida_limit1 :'||g_coida_limit1,15);
1105: hr_utility.set_location('g_coida_limit2 :'||g_coida_limit2,15);
1106: hr_utility.set_location('g_coida_start1 :'||to_char(g_coida_start1,'dd-mm-yyyy'),15);
1107: hr_utility.set_location('g_coida_end1 :'||to_char(g_coida_end1,'dd-mm-yyyy'),15);
1108: hr_utility.set_location('g_coida_start2 :'||to_char(g_coida_start2,'dd-mm-yyyy'),15);
1109: hr_utility.set_location('g_coida_end2 :'||to_char(g_coida_end2,'dd-mm-yyyy'),15);
1110: hr_utility.set_location('g_start_period_date :'||to_char(g_start_period_date,'dd-mm-yyyy'),15);

Line 1107: hr_utility.set_location('g_coida_end1 :'||to_char(g_coida_end1,'dd-mm-yyyy'),15);

1103: hr_utility.set_location('l_strt_prd_id :'||l_strt_prd_id,15);
1104: hr_utility.set_location('g_coida_limit1 :'||g_coida_limit1,15);
1105: hr_utility.set_location('g_coida_limit2 :'||g_coida_limit2,15);
1106: hr_utility.set_location('g_coida_start1 :'||to_char(g_coida_start1,'dd-mm-yyyy'),15);
1107: hr_utility.set_location('g_coida_end1 :'||to_char(g_coida_end1,'dd-mm-yyyy'),15);
1108: hr_utility.set_location('g_coida_start2 :'||to_char(g_coida_start2,'dd-mm-yyyy'),15);
1109: hr_utility.set_location('g_coida_end2 :'||to_char(g_coida_end2,'dd-mm-yyyy'),15);
1110: hr_utility.set_location('g_start_period_date :'||to_char(g_start_period_date,'dd-mm-yyyy'),15);
1111: hr_utility.set_location('g_end_period_date :'||to_char(g_end_period_date,'dd-mm-yyyy'),15);

Line 1108: hr_utility.set_location('g_coida_start2 :'||to_char(g_coida_start2,'dd-mm-yyyy'),15);

1104: hr_utility.set_location('g_coida_limit1 :'||g_coida_limit1,15);
1105: hr_utility.set_location('g_coida_limit2 :'||g_coida_limit2,15);
1106: hr_utility.set_location('g_coida_start1 :'||to_char(g_coida_start1,'dd-mm-yyyy'),15);
1107: hr_utility.set_location('g_coida_end1 :'||to_char(g_coida_end1,'dd-mm-yyyy'),15);
1108: hr_utility.set_location('g_coida_start2 :'||to_char(g_coida_start2,'dd-mm-yyyy'),15);
1109: hr_utility.set_location('g_coida_end2 :'||to_char(g_coida_end2,'dd-mm-yyyy'),15);
1110: hr_utility.set_location('g_start_period_date :'||to_char(g_start_period_date,'dd-mm-yyyy'),15);
1111: hr_utility.set_location('g_end_period_date :'||to_char(g_end_period_date,'dd-mm-yyyy'),15);
1112: hr_utility.set_location('g_num_of_days :'||g_num_of_days,15);

Line 1109: hr_utility.set_location('g_coida_end2 :'||to_char(g_coida_end2,'dd-mm-yyyy'),15);

1105: hr_utility.set_location('g_coida_limit2 :'||g_coida_limit2,15);
1106: hr_utility.set_location('g_coida_start1 :'||to_char(g_coida_start1,'dd-mm-yyyy'),15);
1107: hr_utility.set_location('g_coida_end1 :'||to_char(g_coida_end1,'dd-mm-yyyy'),15);
1108: hr_utility.set_location('g_coida_start2 :'||to_char(g_coida_start2,'dd-mm-yyyy'),15);
1109: hr_utility.set_location('g_coida_end2 :'||to_char(g_coida_end2,'dd-mm-yyyy'),15);
1110: hr_utility.set_location('g_start_period_date :'||to_char(g_start_period_date,'dd-mm-yyyy'),15);
1111: hr_utility.set_location('g_end_period_date :'||to_char(g_end_period_date,'dd-mm-yyyy'),15);
1112: hr_utility.set_location('g_num_of_days :'||g_num_of_days,15);
1113:

Line 1110: hr_utility.set_location('g_start_period_date :'||to_char(g_start_period_date,'dd-mm-yyyy'),15);

1106: hr_utility.set_location('g_coida_start1 :'||to_char(g_coida_start1,'dd-mm-yyyy'),15);
1107: hr_utility.set_location('g_coida_end1 :'||to_char(g_coida_end1,'dd-mm-yyyy'),15);
1108: hr_utility.set_location('g_coida_start2 :'||to_char(g_coida_start2,'dd-mm-yyyy'),15);
1109: hr_utility.set_location('g_coida_end2 :'||to_char(g_coida_end2,'dd-mm-yyyy'),15);
1110: hr_utility.set_location('g_start_period_date :'||to_char(g_start_period_date,'dd-mm-yyyy'),15);
1111: hr_utility.set_location('g_end_period_date :'||to_char(g_end_period_date,'dd-mm-yyyy'),15);
1112: hr_utility.set_location('g_num_of_days :'||g_num_of_days,15);
1113:
1114:

Line 1111: hr_utility.set_location('g_end_period_date :'||to_char(g_end_period_date,'dd-mm-yyyy'),15);

1107: hr_utility.set_location('g_coida_end1 :'||to_char(g_coida_end1,'dd-mm-yyyy'),15);
1108: hr_utility.set_location('g_coida_start2 :'||to_char(g_coida_start2,'dd-mm-yyyy'),15);
1109: hr_utility.set_location('g_coida_end2 :'||to_char(g_coida_end2,'dd-mm-yyyy'),15);
1110: hr_utility.set_location('g_start_period_date :'||to_char(g_start_period_date,'dd-mm-yyyy'),15);
1111: hr_utility.set_location('g_end_period_date :'||to_char(g_end_period_date,'dd-mm-yyyy'),15);
1112: hr_utility.set_location('g_num_of_days :'||g_num_of_days,15);
1113:
1114:
1115:

Line 1112: hr_utility.set_location('g_num_of_days :'||g_num_of_days,15);

1108: hr_utility.set_location('g_coida_start2 :'||to_char(g_coida_start2,'dd-mm-yyyy'),15);
1109: hr_utility.set_location('g_coida_end2 :'||to_char(g_coida_end2,'dd-mm-yyyy'),15);
1110: hr_utility.set_location('g_start_period_date :'||to_char(g_start_period_date,'dd-mm-yyyy'),15);
1111: hr_utility.set_location('g_end_period_date :'||to_char(g_end_period_date,'dd-mm-yyyy'),15);
1112: hr_utility.set_location('g_num_of_days :'||g_num_of_days,15);
1113:
1114:
1115:
1116: --Retrieve employee details

Line 1122: hr_utility.set_location('l_asg_type :'||l_asg_type,15);

1118: fetch csr_person_details into rec_person_details;
1119: close csr_person_details;
1120:
1121: l_asg_type :=retrieve_asg_type(rec_person_details.ass_id, rec_person_details.nature, rec_person_details.foreign_national, rec_person_details.exclude_coida); --12534150
1122: hr_utility.set_location('l_asg_type :'||l_asg_type,15);
1123:
1124: --Archive ZA_COID_EMP_INFO
1125: create_act_inf
1126: (

Line 1142: hr_utility.set_location('Populated ZA_COID_EMP_INFO',15);

1138: , p_action_information9 => l_asg_type
1139: , p_action_information30 => rec_person_details.person_id
1140: , p_assignment_id => rec_person_details.ass_id
1141: );
1142: hr_utility.set_location('Populated ZA_COID_EMP_INFO',15);
1143:
1144: --Now retrieve the monthly balances
1145: for rec_pay_dates in csr_pay_dates(l_payroll_id)
1146: loop

Line 1153: hr_utility.set_location('l_pay_adv_start_date:'||to_char(l_pay_adv_start_date,'dd-mm-yyyy'),20);

1149: into l_pay_adv_start_date
1150: from per_time_periods
1151: where payroll_id=l_payroll_id
1152: and PAY_ADVICE_DATE < rec_pay_dates.pay_advice_date;
1153: hr_utility.set_location('l_pay_adv_start_date:'||to_char(l_pay_adv_start_date,'dd-mm-yyyy'),20);
1154: l_pay_adv_start_date := nvl(l_pay_adv_start_date,trunc(rec_pay_dates.pay_advice_date,'MM')); -- Bug 12572065
1155: hr_utility.set_location('l_pay_adv_start_date:'||to_char(l_pay_adv_start_date,'dd-mm-yyyy'),25);
1156:
1157: exception

Line 1155: hr_utility.set_location('l_pay_adv_start_date:'||to_char(l_pay_adv_start_date,'dd-mm-yyyy'),25);

1151: where payroll_id=l_payroll_id
1152: and PAY_ADVICE_DATE < rec_pay_dates.pay_advice_date;
1153: hr_utility.set_location('l_pay_adv_start_date:'||to_char(l_pay_adv_start_date,'dd-mm-yyyy'),20);
1154: l_pay_adv_start_date := nvl(l_pay_adv_start_date,trunc(rec_pay_dates.pay_advice_date,'MM')); -- Bug 12572065
1155: hr_utility.set_location('l_pay_adv_start_date:'||to_char(l_pay_adv_start_date,'dd-mm-yyyy'),25);
1156:
1157: exception
1158: when no_data_found then
1159: --No payroll calendar exist before this date. Hence default the start date to first of this month

Line 1171: hr_utility.set_location('l_pay_adv_start_date:'||to_char(l_pay_adv_start_date,'dd-mm-yyyy'),30);

1167: p_payroll_id => l_payroll_id,
1168: p_person_id => rec_person_details.person_id
1169: );
1170:
1171: hr_utility.set_location('l_pay_adv_start_date:'||to_char(l_pay_adv_start_date,'dd-mm-yyyy'),30);
1172: hr_utility.set_location('l_days_worked :'||l_days_worked,30);
1173: process_balance(p_assactid, rec_person_details.ass_id, rec_pay_dates.pay_advice_date, l_asg_type, l_days_worked, p_effective_date, rec_person_details.person_id,l_payroll_id);
1174:
1175:

Line 1172: hr_utility.set_location('l_days_worked :'||l_days_worked,30);

1168: p_person_id => rec_person_details.person_id
1169: );
1170:
1171: hr_utility.set_location('l_pay_adv_start_date:'||to_char(l_pay_adv_start_date,'dd-mm-yyyy'),30);
1172: hr_utility.set_location('l_days_worked :'||l_days_worked,30);
1173: process_balance(p_assactid, rec_person_details.ass_id, rec_pay_dates.pay_advice_date, l_asg_type, l_days_worked, p_effective_date, rec_person_details.person_id,l_payroll_id);
1174:
1175:
1176: end loop;

Line 1177: hr_utility.set_location('Leaving :'||l_proc,999);

1173: process_balance(p_assactid, rec_person_details.ass_id, rec_pay_dates.pay_advice_date, l_asg_type, l_days_worked, p_effective_date, rec_person_details.person_id,l_payroll_id);
1174:
1175:
1176: end loop;
1177: hr_utility.set_location('Leaving :'||l_proc,999);
1178: end archive_code ;
1179:
1180: -----------------------------------------------------------------------
1181: --procedure archdinit

Line 1328: hr_utility.set_location('Entering '||l_proc, 10);

1324: l_month varchar2(30);
1325: l_tax_year varchar2(30);
1326:
1327: begin
1328: hr_utility.set_location('Entering '||l_proc, 10);
1329: fnd_file.put_line(fnd_file.log,'Inside ' ||l_proc);
1330:
1331: -- Retrieve legislative parameters from the archiver payroll action
1332: select legislative_parameters

Line 1347: hr_utility.set_location('l_payroll_id ' ||l_payroll_id,15);

1343: l_end_prd_id := get_parameter('END_PERIOD_ID', leg_param);
1344: l_strt_prd_id := get_parameter('STRT_PERIOD_ID', leg_param);
1345: l_tax_year := get_parameter('TAX_YEAR', leg_param); -- Added
1346:
1347: hr_utility.set_location('l_payroll_id ' ||l_payroll_id,15);
1348: hr_utility.set_location('l_end_prd_id ' ||l_end_prd_id,15);
1349: hr_utility.set_location('l_strt_prd_id ' ||l_strt_prd_id,15);
1350: hr_utility.set_location('g_split_year ' ||g_split_year,15);
1351: hr_utility.set_location('l_tax_year ' ||l_tax_year,15); -- Added

Line 1348: hr_utility.set_location('l_end_prd_id ' ||l_end_prd_id,15);

1344: l_strt_prd_id := get_parameter('STRT_PERIOD_ID', leg_param);
1345: l_tax_year := get_parameter('TAX_YEAR', leg_param); -- Added
1346:
1347: hr_utility.set_location('l_payroll_id ' ||l_payroll_id,15);
1348: hr_utility.set_location('l_end_prd_id ' ||l_end_prd_id,15);
1349: hr_utility.set_location('l_strt_prd_id ' ||l_strt_prd_id,15);
1350: hr_utility.set_location('g_split_year ' ||g_split_year,15);
1351: hr_utility.set_location('l_tax_year ' ||l_tax_year,15); -- Added
1352: for rec_dup_person in csr_dup_person

Line 1349: hr_utility.set_location('l_strt_prd_id ' ||l_strt_prd_id,15);

1345: l_tax_year := get_parameter('TAX_YEAR', leg_param); -- Added
1346:
1347: hr_utility.set_location('l_payroll_id ' ||l_payroll_id,15);
1348: hr_utility.set_location('l_end_prd_id ' ||l_end_prd_id,15);
1349: hr_utility.set_location('l_strt_prd_id ' ||l_strt_prd_id,15);
1350: hr_utility.set_location('g_split_year ' ||g_split_year,15);
1351: hr_utility.set_location('l_tax_year ' ||l_tax_year,15); -- Added
1352: for rec_dup_person in csr_dup_person
1353: loop

Line 1350: hr_utility.set_location('g_split_year ' ||g_split_year,15);

1346:
1347: hr_utility.set_location('l_payroll_id ' ||l_payroll_id,15);
1348: hr_utility.set_location('l_end_prd_id ' ||l_end_prd_id,15);
1349: hr_utility.set_location('l_strt_prd_id ' ||l_strt_prd_id,15);
1350: hr_utility.set_location('g_split_year ' ||g_split_year,15);
1351: hr_utility.set_location('l_tax_year ' ||l_tax_year,15); -- Added
1352: for rec_dup_person in csr_dup_person
1353: loop
1354: hr_utility.set_location('rec_dup_person.person_id ' ||rec_dup_person.person_id,15);

Line 1351: hr_utility.set_location('l_tax_year ' ||l_tax_year,15); -- Added

1347: hr_utility.set_location('l_payroll_id ' ||l_payroll_id,15);
1348: hr_utility.set_location('l_end_prd_id ' ||l_end_prd_id,15);
1349: hr_utility.set_location('l_strt_prd_id ' ||l_strt_prd_id,15);
1350: hr_utility.set_location('g_split_year ' ||g_split_year,15);
1351: hr_utility.set_location('l_tax_year ' ||l_tax_year,15); -- Added
1352: for rec_dup_person in csr_dup_person
1353: loop
1354: hr_utility.set_location('rec_dup_person.person_id ' ||rec_dup_person.person_id,15);
1355: hr_utility.set_location('rec_dup_person.asg_type ' ||rec_dup_person.asg_type,15);

Line 1354: hr_utility.set_location('rec_dup_person.person_id ' ||rec_dup_person.person_id,15);

1350: hr_utility.set_location('g_split_year ' ||g_split_year,15);
1351: hr_utility.set_location('l_tax_year ' ||l_tax_year,15); -- Added
1352: for rec_dup_person in csr_dup_person
1353: loop
1354: hr_utility.set_location('rec_dup_person.person_id ' ||rec_dup_person.person_id,15);
1355: hr_utility.set_location('rec_dup_person.asg_type ' ||rec_dup_person.asg_type,15);
1356: cum_tab.delete;
1357: for rec_cum_det in csr_cumulative_details (rec_dup_person.person_id, rec_dup_person.asg_type)
1358: loop

Line 1355: hr_utility.set_location('rec_dup_person.asg_type ' ||rec_dup_person.asg_type,15);

1351: hr_utility.set_location('l_tax_year ' ||l_tax_year,15); -- Added
1352: for rec_dup_person in csr_dup_person
1353: loop
1354: hr_utility.set_location('rec_dup_person.person_id ' ||rec_dup_person.person_id,15);
1355: hr_utility.set_location('rec_dup_person.asg_type ' ||rec_dup_person.asg_type,15);
1356: cum_tab.delete;
1357: for rec_cum_det in csr_cumulative_details (rec_dup_person.person_id, rec_dup_person.asg_type)
1358: loop
1359: hr_utility.set_location('Populating cum_tab table',20);

Line 1359: hr_utility.set_location('Populating cum_tab table',20);

1355: hr_utility.set_location('rec_dup_person.asg_type ' ||rec_dup_person.asg_type,15);
1356: cum_tab.delete;
1357: for rec_cum_det in csr_cumulative_details (rec_dup_person.person_id, rec_dup_person.asg_type)
1358: loop
1359: hr_utility.set_location('Populating cum_tab table',20);
1360: hr_utility.set_location('rec_cum_det.mon: '||rec_cum_det.mon,20);
1361: cum_tab(rec_cum_det.mon).norm_inc := rec_cum_det.norm_income;
1362: cum_tab(rec_cum_det.mon).dir_inc := rec_cum_det.dir_income;
1363: cum_tab(rec_cum_det.mon).cash_comp := rec_cum_det.cash_comp;

Line 1360: hr_utility.set_location('rec_cum_det.mon: '||rec_cum_det.mon,20);

1356: cum_tab.delete;
1357: for rec_cum_det in csr_cumulative_details (rec_dup_person.person_id, rec_dup_person.asg_type)
1358: loop
1359: hr_utility.set_location('Populating cum_tab table',20);
1360: hr_utility.set_location('rec_cum_det.mon: '||rec_cum_det.mon,20);
1361: cum_tab(rec_cum_det.mon).norm_inc := rec_cum_det.norm_income;
1362: cum_tab(rec_cum_det.mon).dir_inc := rec_cum_det.dir_income;
1363: cum_tab(rec_cum_det.mon).cash_comp := rec_cum_det.cash_comp;
1364: cum_tab(rec_cum_det.mon).tot_inc := rec_cum_det.tot_income;

Line 1367: hr_utility.set_location('Populated cum_tab table for the month',20);

1363: cum_tab(rec_cum_det.mon).cash_comp := rec_cum_det.cash_comp;
1364: cum_tab(rec_cum_det.mon).tot_inc := rec_cum_det.tot_income;
1365: cum_tab(rec_cum_det.mon).pay_adv_dt:= rec_cum_det.pay_adv_date;
1366: cum_tab(rec_cum_det.mon).num_days := rec_cum_det.num_days;
1367: hr_utility.set_location('Populated cum_tab table for the month',20);
1368:
1369: --Calculate actual earnings
1370: get_act_earnings
1371: (

Line 1380: hr_utility.set_location('Populated Actual Earnings in cum_tab table',20);

1376: , p_act_earn2 => cum_tab(rec_cum_det.mon).act_earn2
1377: );
1378:
1379: end loop; --csr_cumulative_details
1380: hr_utility.set_location('Populated Actual Earnings in cum_tab table',20);
1381:
1382:
1383: --Update the first record as cumilative record. Rest of the records will be marked as duplicate
1384: l_prev_person_id :=0;

Line 1457: hr_utility.set_location('Before populating ZA_COID_TOT_MONTH_INFO',50);

1453: l_prev_person_id:=rec_dup_person.person_id;
1454: end loop;
1455: end loop;
1456:
1457: hr_utility.set_location('Before populating ZA_COID_TOT_MONTH_INFO',50);
1458: --Populate 'ZA_COID_TOT_MONTH_INFO'
1459: for rec_month_cum_det in csr_month_cumulative_details
1460: loop
1461: hr_utility.set_location('rec_month_cum_det.mon:'||rec_month_cum_det.mon,50);

Line 1461: hr_utility.set_location('rec_month_cum_det.mon:'||rec_month_cum_det.mon,50);

1457: hr_utility.set_location('Before populating ZA_COID_TOT_MONTH_INFO',50);
1458: --Populate 'ZA_COID_TOT_MONTH_INFO'
1459: for rec_month_cum_det in csr_month_cumulative_details
1460: loop
1461: hr_utility.set_location('rec_month_cum_det.mon:'||rec_month_cum_det.mon,50);
1462: create_act_inf
1463: (
1464: p_action_context_id => pactid,
1465: p_action_context_type => 'PA',

Line 1481: hr_utility.set_location('Populated ZA_COID_TOT_MONTH_INFO',50);

1477: p_action_information10 => l_tax_year -- Added
1478: );
1479:
1480: end loop;
1481: hr_utility.set_location('Populated ZA_COID_TOT_MONTH_INFO',50);
1482:
1483: --Populate 'ZA_COID_TOT_MONTH_INFO' with zero value when no employees in that period
1484: for rec_zero_total in csr_zero_totals(l_payroll_id, l_strt_prd_id, l_end_prd_id, 'D')
1485: loop

Line 1486: hr_utility.set_location('rec_zero_total.mon:'||rec_zero_total.mon,55);

1482:
1483: --Populate 'ZA_COID_TOT_MONTH_INFO' with zero value when no employees in that period
1484: for rec_zero_total in csr_zero_totals(l_payroll_id, l_strt_prd_id, l_end_prd_id, 'D')
1485: loop
1486: hr_utility.set_location('rec_zero_total.mon:'||rec_zero_total.mon,55);
1487: create_act_inf
1488: (
1489: p_action_context_id => pactid,
1490: p_action_context_type => 'PA',

Line 1505: hr_utility.set_location('Populated ZA_COID_TOT_MONTH_INFO with zero figure for Directors',60);

1501: p_action_information9 => 'D',
1502: p_action_information10 => l_tax_year -- Added
1503: );
1504: end loop;
1505: hr_utility.set_location('Populated ZA_COID_TOT_MONTH_INFO with zero figure for Directors',60);
1506:
1507:
1508: for rec_zero_total in csr_zero_totals(l_payroll_id, l_strt_prd_id, l_end_prd_id, 'N')
1509: loop

Line 1510: hr_utility.set_location('rec_zero_total.mon:'||rec_zero_total.mon,65);

1506:
1507:
1508: for rec_zero_total in csr_zero_totals(l_payroll_id, l_strt_prd_id, l_end_prd_id, 'N')
1509: loop
1510: hr_utility.set_location('rec_zero_total.mon:'||rec_zero_total.mon,65);
1511: create_act_inf
1512: (
1513: p_action_context_id => pactid,
1514: p_action_context_type => 'PA',

Line 1529: hr_utility.set_location('Populated ZA_COID_TOT_MONTH_INFO with zero figure for Normal Emp',70);

1525: p_action_information9 => 'N',
1526: p_action_information10 => l_tax_year -- Added
1527: );
1528: end loop;
1529: hr_utility.set_location('Populated ZA_COID_TOT_MONTH_INFO with zero figure for Normal Emp',70);
1530:
1531: end archdinit;
1532:
1533: end PAY_ZA_COIDA_ARCHIVE;