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

Line 404: hr_utility.trace('Exception in get_all_parameters SQLERRM: '||SQLERRM);

400: p_end_date := l_param.effective_date;
401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: hr_utility.trace('Exception in get_all_parameters SQLERRM: '||SQLERRM);
405: log_tech_exception(p_action_context_id => p_payroll_action_id,
406: p_err_msg => 'get_all_parameters : '|| substr (sqlerrm, 1, 180)); --14793405
407: END get_all_parameters;
408:

Line 484: hr_utility.trace('+====chk_rr_exist============================================+');

480: l_dummy NUMBER;
481:
482:
483: BEGIN
484: hr_utility.trace('+====chk_rr_exist============================================+');
485: hr_utility.trace('Ass Act is : '||p_ass_act_id);
486: hr_utility.trace('Element Type is : '||p_element_type_id);
487:
488: OPEN csr_ass_act;

Line 485: hr_utility.trace('Ass Act is : '||p_ass_act_id);

481:
482:
483: BEGIN
484: hr_utility.trace('+====chk_rr_exist============================================+');
485: hr_utility.trace('Ass Act is : '||p_ass_act_id);
486: hr_utility.trace('Element Type is : '||p_element_type_id);
487:
488: OPEN csr_ass_act;
489: FETCH csr_ass_act INTO l_dummy;

Line 486: hr_utility.trace('Element Type is : '||p_element_type_id);

482:
483: BEGIN
484: hr_utility.trace('+====chk_rr_exist============================================+');
485: hr_utility.trace('Ass Act is : '||p_ass_act_id);
486: hr_utility.trace('Element Type is : '||p_element_type_id);
487:
488: OPEN csr_ass_act;
489: FETCH csr_ass_act INTO l_dummy;
490: IF csr_ass_act%FOUND THEN

Line 491: hr_utility.trace('Run Results found : ');

487:
488: OPEN csr_ass_act;
489: FETCH csr_ass_act INTO l_dummy;
490: IF csr_ass_act%FOUND THEN
491: hr_utility.trace('Run Results found : ');
492: CLOSE csr_ass_act;
493: RETURN TRUE;
494: ELSE
495: hr_utility.trace('Run Results not found : ');

Line 495: hr_utility.trace('Run Results not found : ');

491: hr_utility.trace('Run Results found : ');
492: CLOSE csr_ass_act;
493: RETURN TRUE;
494: ELSE
495: hr_utility.trace('Run Results not found : ');
496: CLOSE csr_ass_act;
497: RETURN FALSE;
498: END IF;
499:

Line 500: hr_utility.trace('X====chk_rr_exist============================================X');

496: CLOSE csr_ass_act;
497: RETURN FALSE;
498: END IF;
499:
500: hr_utility.trace('X====chk_rr_exist============================================X');
501: EXCEPTION
502: WHEN OTHERS THEN
503: hr_utility.trace('Exception in chk_rr_exist '||SQLERRM);
504: log_tech_exception(p_action_context_id => g_payroll_action_id,

Line 503: hr_utility.trace('Exception in chk_rr_exist '||SQLERRM);

499:
500: hr_utility.trace('X====chk_rr_exist============================================X');
501: EXCEPTION
502: WHEN OTHERS THEN
503: hr_utility.trace('Exception in chk_rr_exist '||SQLERRM);
504: log_tech_exception(p_action_context_id => g_payroll_action_id,
505: p_err_msg => 'chk_rr_exist : '|| substr (sqlerrm, 1, 180)); --14793405
506: RETURN FALSE;
507: END chk_rr_exist;

Line 564: hr_utility.trace('+====chk_asg_term_py============================================+');

560: )
561: );
562:
563: BEGIN
564: hr_utility.trace('+====chk_asg_term_py============================================+');
565: hr_utility.trace('...Assignment Id is : '||p_assignment_id);
566: hr_utility.trace('...Value of p_ext_st is : '||p_ext_st);
567:
568: OPEN csr_get_term_date;

Line 565: hr_utility.trace('...Assignment Id is : '||p_assignment_id);

561: );
562:
563: BEGIN
564: hr_utility.trace('+====chk_asg_term_py============================================+');
565: hr_utility.trace('...Assignment Id is : '||p_assignment_id);
566: hr_utility.trace('...Value of p_ext_st is : '||p_ext_st);
567:
568: OPEN csr_get_term_date;
569: FETCH csr_get_term_date INTO l_asg_term_dt;

Line 566: hr_utility.trace('...Value of p_ext_st is : '||p_ext_st);

562:
563: BEGIN
564: hr_utility.trace('+====chk_asg_term_py============================================+');
565: hr_utility.trace('...Assignment Id is : '||p_assignment_id);
566: hr_utility.trace('...Value of p_ext_st is : '||p_ext_st);
567:
568: OPEN csr_get_term_date;
569: FETCH csr_get_term_date INTO l_asg_term_dt;
570: IF csr_get_term_date%NOTFOUND THEN

Line 571: hr_utility.trace('...Termination Date Not found : ');

567:
568: OPEN csr_get_term_date;
569: FETCH csr_get_term_date INTO l_asg_term_dt;
570: IF csr_get_term_date%NOTFOUND THEN
571: hr_utility.trace('...Termination Date Not found : ');
572: CLOSE csr_get_term_date;
573: RETURN FALSE;
574: ELSE
575: CLOSE csr_get_term_date;

Line 579: hr_utility.trace('...Condition met return TRUE : ');

575: CLOSE csr_get_term_date;
576: fnd_file.put_line(fnd_file.log,'...Termination Date found : ');
577: IF to_number(to_char(nvl(l_asg_term_dt,p_ext_st),'YYYY')) <
578: to_number(to_char(p_ext_st,'YYYY')) THEN
579: hr_utility.trace('...Condition met return TRUE : ');
580: RETURN TRUE;
581: ELSE
582: hr_utility.trace('...Condition not met return FALSE : ');
583: RETURN FALSE;

Line 582: hr_utility.trace('...Condition not met return FALSE : ');

578: to_number(to_char(p_ext_st,'YYYY')) THEN
579: hr_utility.trace('...Condition met return TRUE : ');
580: RETURN TRUE;
581: ELSE
582: hr_utility.trace('...Condition not met return FALSE : ');
583: RETURN FALSE;
584: END IF;
585:
586: END IF;

Line 587: hr_utility.trace('X====chk_asg_term_py============================================X');

583: RETURN FALSE;
584: END IF;
585:
586: END IF;
587: hr_utility.trace('X====chk_asg_term_py============================================X');
588: EXCEPTION
589: WHEN OTHERS THEN
590: hr_utility.trace('Exception in chk_asg_term_py '||SQLERRM);
591: log_tech_exception(p_action_context_id => g_payroll_action_id,

Line 590: hr_utility.trace('Exception in chk_asg_term_py '||SQLERRM);

586: END IF;
587: hr_utility.trace('X====chk_asg_term_py============================================X');
588: EXCEPTION
589: WHEN OTHERS THEN
590: hr_utility.trace('Exception in chk_asg_term_py '||SQLERRM);
591: log_tech_exception(p_action_context_id => g_payroll_action_id,
592: p_err_msg => 'chk_asg_term_py : '|| substr (sqlerrm, 1, 180)); --14793405
593: RETURN FALSE;
594:

Line 662: hr_utility.trace('+====get_balance_value============================================+');

658: );
659:
660: BEGIN
661:
662: hr_utility.trace('+====get_balance_value============================================+');
663:
664: OPEN csr_defined_bal(p_balance_name,p_dim_name,p_bg_id);
665: FETCH csr_defined_bal INTO l_balance_id;
666: CLOSE csr_defined_bal;

Line 699: hr_utility.trace('X====get_balance_value============================================X');

695: END IF;
696: END IF;
697: END IF;
698:
699: hr_utility.trace('X====get_balance_value============================================X');
700:
701: RETURN l_balance_amount;
702:
703: EXCEPTION

Line 705: hr_utility.trace('Exception in get_balance_value '||SQLERRM);

701: RETURN l_balance_amount;
702:
703: EXCEPTION
704: WHEN OTHERS THEN
705: hr_utility.trace('Exception in get_balance_value '||SQLERRM);
706: log_tech_exception(p_action_context_id => g_payroll_action_id,
707: p_err_msg => 'get_balance_value : '|| substr (sqlerrm, 1, 180)); --14793405
708: RETURN -1;
709:

Line 770: hr_utility.trace('+====get_avg_ptp============================================+');

766: l_avg_ptp NUMBER;
767:
768: BEGIN
769:
770: hr_utility.trace('+====get_avg_ptp============================================+');
771:
772: OPEN csr_get_asg_start_date(p_assignment_id,p_period_start_date,p_period_end_date);
773: FETCH csr_get_asg_start_date INTO l_effective_date;
774: CLOSE csr_get_asg_start_date;

Line 833: hr_utility.trace('X====get_avg_ptp============================================X');

829: l_pt_perc := l_pt_perc/l_days_in_pp;
830:
831: l_avg_ptp := LEAST(l_pt_perc,125);
832:
833: hr_utility.trace('X====get_avg_ptp============================================X');
834:
835: RETURN l_avg_ptp;
836:
837: EXCEPTION

Line 839: hr_utility.trace('Exception in get_retro_avg_ptp SQL-ERRM : '||SQLERRM);

835: RETURN l_avg_ptp;
836:
837: EXCEPTION
838: WHEN OTHERS THEN
839: hr_utility.trace('Exception in get_retro_avg_ptp SQL-ERRM : '||SQLERRM);
840: log_tech_exception(p_action_context_id => g_payroll_action_id,
841: p_err_msg => 'get_avg_ptp : '|| substr (sqlerrm, 1, 180)); --14793405
842: RETURN -1;
843: END get_avg_ptp;

Line 865: hr_utility.trace('+====chk_asg_late_hire============================================+');

861: l_def_bal_id NUMBER;
862:
863: BEGIN
864:
865: hr_utility.trace('+====chk_asg_late_hire============================================+');
866:
867: l_late_hire_ind := 0;
868: l_def_bal_id := -1;
869:

Line 889: hr_utility.trace('X====chk_asg_late_hire============================================X');

885: ,p_defined_balance_id => l_def_bal_id
886: ,p_virtual_date => p_end_date);
887: END IF;
888:
889: hr_utility.trace('X====chk_asg_late_hire============================================X');
890:
891: IF l_late_hire_ind <> 0 THEN
892: RETURN TRUE;
893: ELSE

Line 899: hr_utility.trace('X====Exception in chk_asg_late_hire===================X'||SQLERRM);

895: END IF;
896:
897: EXCEPTION
898: WHEN OTHERS THEN
899: hr_utility.trace('X====Exception in chk_asg_late_hire===================X'||SQLERRM);
900: log_tech_exception(p_action_context_id => g_payroll_action_id,
901: p_err_msg => 'chk_asg_late_hire : '|| substr (sqlerrm, 1, 180)); --14793405
902: RETURN FALSE;
903: END chk_asg_late_hire;

Line 938: hr_utility.trace('+====Get_Pension_Salary==========================================+');

934: l_pension_salary NUMBER := 0;
935:
936: BEGIN
937:
938: hr_utility.trace('+====Get_Pension_Salary==========================================+');
939: hr_utility.trace('p_end_date '||p_end_date);
940: --
941: -- Fetch the overridden value if there is any override at the ASG EIT
942: --

Line 939: hr_utility.trace('p_end_date '||p_end_date);

935:
936: BEGIN
937:
938: hr_utility.trace('+====Get_Pension_Salary==========================================+');
939: hr_utility.trace('p_end_date '||p_end_date);
940: --
941: -- Fetch the overridden value if there is any override at the ASG EIT
942: --
943: OPEN csr_get_override_salary(p_assignment_id,p_end_date);

Line 972: hr_utility.trace('X====Get_Pension_Salary==========================================X');

968: ,p_end_date => p_end_date
969: ,p_balance_name => 'ABP Pension Salary'
970: ,p_dim_name => l_dim_name);
971:
972: hr_utility.trace('X====Get_Pension_Salary==========================================X');
973:
974: RETURN l_pension_salary;
975:
976: EXCEPTION

Line 978: hr_utility.trace('X====Exception in get_pension_salary========================X'||SQLERRM);

974: RETURN l_pension_salary;
975:
976: EXCEPTION
977: WHEN Others THEN
978: hr_utility.trace('X====Exception in get_pension_salary========================X'||SQLERRM);
979: log_tech_exception(p_action_context_id => g_payroll_action_id,
980: p_err_msg => 'get_pension_salary : '|| substr (sqlerrm, 1, 180)); --14793405
981: RETURN -1;
982:

Line 1011: hr_utility.trace('+====get_curr_ptp======================================+');

1007: l_extra_hours_pct NUMBER := 0;
1008: l_curr_ptp NUMBER :=0;
1009: BEGIN
1010:
1011: hr_utility.trace('+====get_curr_ptp======================================+');
1012:
1013: l_ptp:= get_balance_value(p_assignment_id => p_assignment_id
1014: ,p_bg_id => p_bg_id
1015: ,p_payroll_id => p_payroll_id

Line 1031: hr_utility.trace('l_ptp '||l_ptp);

1027: ,p_end_date => p_end_date
1028: ,p_balance_name => 'ABP Extra Hours Worked'
1029: ,p_dim_name => 'Assignment Period To Date');
1030:
1031: hr_utility.trace('l_ptp '||l_ptp);
1032: hr_utility.trace('l_extra_hours '||l_extra_hours);
1033:
1034: OPEN csr_get_reg_working_hours(p_assignment_id,p_end_date);
1035: FETCH csr_get_reg_working_hours INTO l_reg_working_hours;

Line 1032: hr_utility.trace('l_extra_hours '||l_extra_hours);

1028: ,p_balance_name => 'ABP Extra Hours Worked'
1029: ,p_dim_name => 'Assignment Period To Date');
1030:
1031: hr_utility.trace('l_ptp '||l_ptp);
1032: hr_utility.trace('l_extra_hours '||l_extra_hours);
1033:
1034: OPEN csr_get_reg_working_hours(p_assignment_id,p_end_date);
1035: FETCH csr_get_reg_working_hours INTO l_reg_working_hours;
1036: CLOSE csr_get_reg_working_hours;

Line 1045: hr_utility.trace('X====get_curr_ptp======================================X');

1041: END IF;
1042:
1043: l_curr_ptp := least(l_ptp,125);
1044:
1045: hr_utility.trace('X====get_curr_ptp======================================X');
1046:
1047: RETURN l_curr_ptp;
1048:
1049: EXCEPTION

Line 1051: hr_utility.trace('X====Exception in get_curr_ptp=====================X'||SQLERRM);

1047: RETURN l_curr_ptp;
1048:
1049: EXCEPTION
1050: WHEN OTHERS THEN
1051: hr_utility.trace('X====Exception in get_curr_ptp=====================X'||SQLERRM);
1052: log_tech_exception(p_action_context_id => g_payroll_action_id,
1053: p_err_msg => 'get_curr_ptp : '|| substr (sqlerrm, 1, 180)); --14793405
1054: RETURN -1;
1055: END get_curr_ptp;

Line 1311: hr_utility.trace('+====get_retro_ptp======================================+');

1307: l_prior_hourly_ee_ptp NUMBER;
1308: l_avg_ptp NUMBER;
1309:
1310: BEGIN
1311: hr_utility.trace('+====get_retro_ptp======================================+');
1312: -- ============================================================================
1313: -- BEGIN Populate Retro PTP change information
1314: -- ============================================================================
1315:

Line 1468: hr_utility.trace('X====get_retro_ptp======================================X');

1464: CLOSE csr_ude_rec;
1465: END IF;
1466: --7361922
1467:
1468: hr_utility.trace('X====get_retro_ptp======================================X');
1469: EXCEPTION
1470: WHEN OTHERS THEN
1471: hr_utility.trace('Exception in get_retro_ptp'||SQLERRM);
1472: log_tech_exception(p_action_context_id => g_payroll_action_id,

Line 1471: hr_utility.trace('Exception in get_retro_ptp'||SQLERRM);

1467:
1468: hr_utility.trace('X====get_retro_ptp======================================X');
1469: EXCEPTION
1470: WHEN OTHERS THEN
1471: hr_utility.trace('Exception in get_retro_ptp'||SQLERRM);
1472: log_tech_exception(p_action_context_id => g_payroll_action_id,
1473: p_err_msg => 'get_retro_ptp : '|| substr (sqlerrm, 1, 180));
1474: END get_retro_ptp;
1475:

Line 1545: hr_utility.trace('+====pension_basis======================================+');

1541: l_prev_basis_amt NUMBER;
1542: l_chg_rep csr_get_prev_hire_info%ROWTYPE;
1543:
1544: BEGIN
1545: hr_utility.trace('+====pension_basis======================================+');
1546:
1547: -- ==============================================================================
1548: -- BEGIN Populate Contribution Basis details for Current period,Retro current year
1549: -- ==============================================================================

Line 1572: hr_utility.trace('Current element : '||l_contr_basis(i).element_type_id);

1568: FOR i IN l_contr_basis.FIRST..l_contr_basis.LAST
1569: LOOP
1570: l_rr_exists := 0;
1571:
1572: hr_utility.trace('Current element : '||l_contr_basis(i).element_type_id);
1573: hr_utility.trace('Assignment Id : '||p_assignment_id);
1574: hr_utility.trace('Payroll id : '||p_payroll_id);
1575: hr_utility.trace('Start date : '||p_start_date);
1576: hr_utility.trace('End date : '||p_end_date);

Line 1573: hr_utility.trace('Assignment Id : '||p_assignment_id);

1569: LOOP
1570: l_rr_exists := 0;
1571:
1572: hr_utility.trace('Current element : '||l_contr_basis(i).element_type_id);
1573: hr_utility.trace('Assignment Id : '||p_assignment_id);
1574: hr_utility.trace('Payroll id : '||p_payroll_id);
1575: hr_utility.trace('Start date : '||p_start_date);
1576: hr_utility.trace('End date : '||p_end_date);
1577:

Line 1574: hr_utility.trace('Payroll id : '||p_payroll_id);

1570: l_rr_exists := 0;
1571:
1572: hr_utility.trace('Current element : '||l_contr_basis(i).element_type_id);
1573: hr_utility.trace('Assignment Id : '||p_assignment_id);
1574: hr_utility.trace('Payroll id : '||p_payroll_id);
1575: hr_utility.trace('Start date : '||p_start_date);
1576: hr_utility.trace('End date : '||p_end_date);
1577:
1578: FOR act_rec IN csr_asg_act (

Line 1575: hr_utility.trace('Start date : '||p_start_date);

1571:
1572: hr_utility.trace('Current element : '||l_contr_basis(i).element_type_id);
1573: hr_utility.trace('Assignment Id : '||p_assignment_id);
1574: hr_utility.trace('Payroll id : '||p_payroll_id);
1575: hr_utility.trace('Start date : '||p_start_date);
1576: hr_utility.trace('End date : '||p_end_date);
1577:
1578: FOR act_rec IN csr_asg_act (
1579: c_assignment_id => p_assignment_id

Line 1576: hr_utility.trace('End date : '||p_end_date);

1572: hr_utility.trace('Current element : '||l_contr_basis(i).element_type_id);
1573: hr_utility.trace('Assignment Id : '||p_assignment_id);
1574: hr_utility.trace('Payroll id : '||p_payroll_id);
1575: hr_utility.trace('Start date : '||p_start_date);
1576: hr_utility.trace('End date : '||p_end_date);
1577:
1578: FOR act_rec IN csr_asg_act (
1579: c_assignment_id => p_assignment_id
1580: ,c_payroll_id => p_payroll_id

Line 1585: hr_utility.trace('Asg act id : '||act_rec.assignment_action_id);

1581: ,c_con_set_id => NULL
1582: ,c_start_date => p_start_date
1583: ,c_end_date => p_end_date)
1584: LOOP
1585: hr_utility.trace('Asg act id : '||act_rec.assignment_action_id);
1586: --
1587: -- Current Year Retro
1588: --
1589: FOR temp_rec IN csr_get_retro_entry

Line 1594: hr_utility.trace('Found current year retro entries - Contr Basis');

1590: (c_element_type_id => fnd_number.canonical_to_number(
1591: l_contr_basis(i).cy_retro_element_id)
1592: ,c_assignment_action_id => act_rec.assignment_action_id)
1593: LOOP
1594: hr_utility.trace('Found current year retro entries - Contr Basis');
1595: --
1596: -- Fetch the input value id for ABP Employee Pension Basis input value
1597: --
1598: OPEN csr_get_iv_id(c_element_type_id =>

Line 1645: hr_utility.trace('Run results exist for current period - Contr Basis');

1641: --
1642: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
1643: ,p_element_type_id => l_contr_basis(i).element_type_id ) THEN
1644: -- Call pay_balance_pkg
1645: hr_utility.trace('Run results exist for current period - Contr Basis');
1646:
1647: IF l_contr_basis(i).defined_bal_id <> -1 THEN
1648: p_contr_basis_values(k).pension_type := l_contr_basis(i).pension_type;
1649: p_contr_basis_values(k).pension_type_variant := NULL;

Line 1655: hr_utility.trace('Defined bal id used :'||l_contr_basis(i).defined_bal_id);

1651: pay_balance_pkg.get_value
1652: (p_defined_balance_id => l_contr_basis(i).defined_bal_id
1653: ,p_assignment_action_id => act_rec.assignment_action_id);
1654:
1655: hr_utility.trace('Defined bal id used :'||l_contr_basis(i).defined_bal_id);
1656:
1657: p_contr_basis_values(k).date_earned := trunc(act_rec.date_earned,'MM'); --p_start_date;--Bug 16301893
1658:
1659: k := k + 1;

Line 1719: hr_utility.trace('current element : '||l_contr_basis(i).element_type_id);

1715: IF l_contr_basis.count > 0 THEN
1716: FOR i IN l_contr_basis.FIRST..l_contr_basis.LAST
1717: LOOP
1718: l_rr_exists := 0;
1719: hr_utility.trace('current element : '||l_contr_basis(i).element_type_id);
1720: hr_utility.trace('asg id : '||p_assignment_id);
1721:
1722: FOR act_rec IN csr_asg_act (
1723: c_assignment_id => p_assignment_id

Line 1720: hr_utility.trace('asg id : '||p_assignment_id);

1716: FOR i IN l_contr_basis.FIRST..l_contr_basis.LAST
1717: LOOP
1718: l_rr_exists := 0;
1719: hr_utility.trace('current element : '||l_contr_basis(i).element_type_id);
1720: hr_utility.trace('asg id : '||p_assignment_id);
1721:
1722: FOR act_rec IN csr_asg_act (
1723: c_assignment_id => p_assignment_id
1724: ,c_payroll_id => p_payroll_id

Line 1742: hr_utility.trace('defined bal id used :'||l_contr_basis(i).defined_bal_id);

1738: p_contr_basis_values(k).contr_base :=
1739: pay_balance_pkg.get_value
1740: (p_defined_balance_id => l_contr_basis(i).defined_bal_id
1741: ,p_assignment_action_id => act_rec.assignment_action_id);
1742: hr_utility.trace('defined bal id used :'||l_contr_basis(i).defined_bal_id);
1743:
1744: p_contr_basis_values(k).date_earned := l_beg_new_st;
1745:
1746: k := k + 1;

Line 1791: hr_utility.trace('current element : '||l_contr_basis(i).element_type_id);

1787: IF l_contr_basis.count > 0 THEN
1788: FOR i IN l_contr_basis.FIRST..l_contr_basis.LAST
1789: LOOP
1790: l_rr_exists := 0;
1791: hr_utility.trace('current element : '||l_contr_basis(i).element_type_id);
1792: hr_utility.trace('asg id : '||p_assignment_id);
1793:
1794: FOR act_rec IN csr_asg_act (
1795: c_assignment_id => p_assignment_id

Line 1792: hr_utility.trace('asg id : '||p_assignment_id);

1788: FOR i IN l_contr_basis.FIRST..l_contr_basis.LAST
1789: LOOP
1790: l_rr_exists := 0;
1791: hr_utility.trace('current element : '||l_contr_basis(i).element_type_id);
1792: hr_utility.trace('asg id : '||p_assignment_id);
1793:
1794: FOR act_rec IN csr_asg_act (
1795: c_assignment_id => p_assignment_id
1796: ,c_payroll_id => p_payroll_id

Line 1814: hr_utility.trace('defined bal id used :'||l_contr_basis(i).defined_bal_id);

1810: p_contr_basis_values(k).contr_base :=
1811: pay_balance_pkg.get_value
1812: (p_defined_balance_id => l_contr_basis(i).defined_bal_id
1813: ,p_assignment_action_id => act_rec.assignment_action_id);
1814: hr_utility.trace('defined bal id used :'||l_contr_basis(i).defined_bal_id);
1815:
1816: p_contr_basis_values(k).date_earned := l_beg_new_st;
1817: -- substr(fnd_date.date_to_canonical(l_end_new_st),1,10);
1818:

Line 1862: hr_utility.trace('X====pension_basis======================================X');

1858: END LOOP; -- Loop through the period
1859: END IF; -- new start date < old start dt
1860: END IF; -- dates are not null
1861:
1862: hr_utility.trace('X====pension_basis======================================X');
1863:
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: hr_utility.trace('X====Exception in pension_basis========X'||SQLERRM);

Line 1866: hr_utility.trace('X====Exception in pension_basis========X'||SQLERRM);

1862: hr_utility.trace('X====pension_basis======================================X');
1863:
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: hr_utility.trace('X====Exception in pension_basis========X'||SQLERRM);
1867: log_tech_exception(p_action_context_id => g_payroll_action_id,
1868: p_err_msg => 'pension_basis : '|| substr (sqlerrm, 1, 180)); --14793405
1869: END pension_basis;
1870:

Line 1920: hr_utility.trace('+====pension_contr======================================+');

1916: l_prev_contr_amt NUMBER;
1917: l_chg_rep csr_get_prev_hire_info%ROWTYPE;
1918:
1919: BEGIN
1920: hr_utility.trace('+====pension_contr======================================+');
1921:
1922: OPEN csr_hire_dt_chg(c_person_id => p_person_id
1923: ,c_start_date => p_start_date
1924: ,c_end_date => p_end_date);

Line 2263: hr_utility.trace('X====pension_contr======================================X');

2259: -- ============================================================================
2260: -- END Populating Contribution Amount for change in hire dates
2261: -- ============================================================================
2262:
2263: hr_utility.trace('X====pension_contr======================================X');
2264:
2265: EXCEPTION
2266: WHEN OTHERS THEN
2267: hr_utility.trace('X====Exception in pension_contr========X'||SQLERRM);

Line 2267: hr_utility.trace('X====Exception in pension_contr========X'||SQLERRM);

2263: hr_utility.trace('X====pension_contr======================================X');
2264:
2265: EXCEPTION
2266: WHEN OTHERS THEN
2267: hr_utility.trace('X====Exception in pension_contr========X'||SQLERRM);
2268: log_tech_exception(p_action_context_id => g_payroll_action_id,
2269: p_err_msg => 'pension_contr : '|| substr (sqlerrm, 1, 180)); --14793405
2270: END pension_contr;
2271:

Line 2279: hr_utility.trace('+====range_code============================================+');

2275: -- =============================================================================
2276: PROCEDURE range_code (pactid IN NUMBER
2277: ,sqlstr OUT NOCOPY VARCHAR2) is
2278: BEGIN
2279: hr_utility.trace('+====range_code============================================+');
2280:
2281: g_payroll_action_id := pactid; --14793405
2282:
2283: sqlstr := 'SELECT DISTINCT person_id

Line 2290: hr_utility.trace('X====range_code============================================X');

2286: WHERE ppa.payroll_action_id = :payroll_action_id
2287: AND ppa.business_group_id = pap.business_group_id
2288: ORDER BY pap.person_id';
2289:
2290: hr_utility.trace('X====range_code============================================X');
2291:
2292: EXCEPTION
2293: WHEN OTHERS THEN
2294: -- Return cursor that selects no rows

Line 2295: hr_utility.trace('Exception in range_code SQL-ERRM : '||SQLERRM);

2291:
2292: EXCEPTION
2293: WHEN OTHERS THEN
2294: -- Return cursor that selects no rows
2295: hr_utility.trace('Exception in range_code SQL-ERRM : '||SQLERRM);
2296: log_tech_exception(p_action_context_id => g_payroll_action_id,
2297: p_err_msg => 'range_code : '|| substr (sqlerrm, 1, 180)); --14793405
2298: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
2299: END range_code;

Line 2345: hr_utility.trace('+====initialization_code===================================+');

2341: l_bg_id NUMBER;
2342: l_start_date DATE;
2343:
2344: BEGIN
2345: hr_utility.trace('+====initialization_code===================================+');
2346:
2347: hr_utility.trace('X====initialization_code===================================X');
2348: EXCEPTION
2349: WHEN OTHERS THEN

Line 2347: hr_utility.trace('X====initialization_code===================================X');

2343:
2344: BEGIN
2345: hr_utility.trace('+====initialization_code===================================+');
2346:
2347: hr_utility.trace('X====initialization_code===================================X');
2348: EXCEPTION
2349: WHEN OTHERS THEN
2350: hr_utility.trace('Exception in initialization_code SQL-ERRM : '||SQLERRM);
2351: log_tech_exception(p_action_context_id => g_payroll_action_id,

Line 2350: hr_utility.trace('Exception in initialization_code SQL-ERRM : '||SQLERRM);

2346:
2347: hr_utility.trace('X====initialization_code===================================X');
2348: EXCEPTION
2349: WHEN OTHERS THEN
2350: hr_utility.trace('Exception in initialization_code SQL-ERRM : '||SQLERRM);
2351: log_tech_exception(p_action_context_id => g_payroll_action_id,
2352: p_err_msg => 'initialization_code : '|| substr (sqlerrm, 1, 180)); --14793405
2353: END initialization_code;
2354:

Line 2584: hr_utility.trace('Exception in ins_assg_act SQL-ERRM : '||SQLERRM);

2580: ,chunk => p_chunk
2581: ,greid => p_org_id);
2582: EXCEPTION
2583: WHEN others THEN
2584: hr_utility.trace('Exception in ins_assg_act SQL-ERRM : '||SQLERRM);
2585: log_tech_exception(p_action_context_id => g_payroll_action_id,
2586: p_err_msg => 'ins_assg_act : '|| substr (sqlerrm, 1, 180)); --14793405
2587: END ins_assg_act;
2588: --=========================================================================

Line 2593: hr_utility.trace('+====assignment_action_code================================+');

2589:
2590: BEGIN
2591: g_payroll_action_id := p_payroll_action_id;
2592:
2593: hr_utility.trace('+====assignment_action_code================================+');
2594: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
2595: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
2596:
2597: get_all_parameters (

Line 2594: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );

2590: BEGIN
2591: g_payroll_action_id := p_payroll_action_id;
2592:
2593: hr_utility.trace('+====assignment_action_code================================+');
2594: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
2595: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
2596:
2597: get_all_parameters (
2598: p_payroll_action_id => p_payroll_action_id

Line 2595: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );

2591: g_payroll_action_id := p_payroll_action_id;
2592:
2593: hr_utility.trace('+====assignment_action_code================================+');
2594: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
2595: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
2596:
2597: get_all_parameters (
2598: p_payroll_action_id => p_payroll_action_id
2599: ,p_org_struct_id => l_org_struct_id

Line 2607: hr_utility.trace('Start Date : ' ||l_start_date);

2603: ,p_bg_id => l_bg_id
2604: ,p_start_date => l_start_date
2605: ,p_end_date => l_end_date);
2606:
2607: hr_utility.trace('Start Date : ' ||l_start_date);
2608: hr_utility.trace('End Date : ' ||l_end_date);
2609: hr_utility.trace('Valid Start Date : ' ||g_valid_start_date);
2610:
2611: abp_org_id := l_org_id;

Line 2608: hr_utility.trace('End Date : ' ||l_end_date);

2604: ,p_start_date => l_start_date
2605: ,p_end_date => l_end_date);
2606:
2607: hr_utility.trace('Start Date : ' ||l_start_date);
2608: hr_utility.trace('End Date : ' ||l_end_date);
2609: hr_utility.trace('Valid Start Date : ' ||g_valid_start_date);
2610:
2611: abp_org_id := l_org_id;
2612: OPEN csr_chk_er_details(abp_org_id);

Line 2609: hr_utility.trace('Valid Start Date : ' ||g_valid_start_date);

2605: ,p_end_date => l_end_date);
2606:
2607: hr_utility.trace('Start Date : ' ||l_start_date);
2608: hr_utility.trace('End Date : ' ||l_end_date);
2609: hr_utility.trace('Valid Start Date : ' ||g_valid_start_date);
2610:
2611: abp_org_id := l_org_id;
2612: OPEN csr_chk_er_details(abp_org_id);
2613: FETCH csr_chk_er_details INTO l_chk_er_details;

Line 2622: hr_utility.trace('....No value found at HR org level,searching up the tree');

2618: ELSE
2619: CLOSE csr_chk_er_details;
2620: -- ABP Employer details not found at this org level,traverse up the
2621: -- org hierarchy to find a value at the parent level
2622: hr_utility.trace('....No value found at HR org level,searching up the tree');
2623:
2624: l_version_id := pqp_pension_functions.get_version_id(l_bg_id,l_end_date);
2625: hr_utility.trace(' l_version_id '||l_version_id);
2626:

Line 2625: hr_utility.trace(' l_version_id '||l_version_id);

2621: -- org hierarchy to find a value at the parent level
2622: hr_utility.trace('....No value found at HR org level,searching up the tree');
2623:
2624: l_version_id := pqp_pension_functions.get_version_id(l_bg_id,l_end_date);
2625: hr_utility.trace(' l_version_id '||l_version_id);
2626:
2627: IF l_version_id = -99 THEN
2628: abp_provider_found := 'No';
2629: END IF;

Line 2640: hr_utility.trace('searching at parent : '||abp_org_id);

2636: -- Find the parent of this org
2637: OPEN csr_find_parent_id(abp_org_id,l_version_id,l_bg_id);
2638: FETCH csr_find_parent_id INTO abp_org_id;
2639: IF csr_find_parent_id%FOUND THEN
2640: hr_utility.trace('searching at parent : '||abp_org_id);
2641: CLOSE csr_find_parent_id;
2642: OPEN csr_chk_er_details(abp_org_id);
2643: FETCH csr_chk_er_details INTO l_chk_er_details;
2644: IF csr_chk_er_details%FOUND THEN

Line 2646: hr_utility.trace('ABP Employer details found at : '||abp_org_id);

2642: OPEN csr_chk_er_details(abp_org_id);
2643: FETCH csr_chk_er_details INTO l_chk_er_details;
2644: IF csr_chk_er_details%FOUND THEN
2645: abp_provider_found := 'Yes';
2646: hr_utility.trace('ABP Employer details found at : '||abp_org_id);
2647: CLOSE csr_chk_er_details;
2648: l_loop_again := 0;
2649: ELSE
2650: CLOSE csr_chk_er_details;

Line 2666: hr_utility.trace('Assignment Id : ' ||v_csr_get_asg_org.assignment_id);

2662: , p_start_person_id, p_end_person_id, p_payroll_action_id
2663: , l_start_date, l_end_date)
2664: LOOP
2665: l_process := 'Y';
2666: hr_utility.trace('Assignment Id : ' ||v_csr_get_asg_org.assignment_id);
2667:
2668: OPEN csr_get_payroll_id(v_csr_get_asg_org.assignment_id);
2669: FETCH csr_get_payroll_id INTO l_payroll_id;
2670: CLOSE csr_get_payroll_id;

Line 2675: hr_utility.trace('Termination Details found : ');

2671:
2672: OPEN csr_term_chk(v_csr_get_asg_org.assignment_id,l_bg_id,l_start_date);
2673: FETCH csr_term_chk INTO l_chk;
2674: IF csr_term_chk%FOUND THEN
2675: hr_utility.trace('Termination Details found : ');
2676: l_process := 'N';
2677: END IF;
2678: CLOSE csr_term_chk;
2679:

Line 2684: hr_utility.trace('Rehire Details found : ');

2680: IF l_process = 'Y' THEN
2681: OPEN csr_rehire_chk(v_csr_get_asg_org.person_id,l_end_date);
2682: FETCH csr_rehire_chk INTO l_chk;
2683: IF csr_rehire_chk%FOUND THEN
2684: hr_utility.trace('Rehire Details found : ');
2685: l_process := 'N';
2686: OPEN csr_is_payroll_run(v_csr_get_asg_org.assignment_id, l_bg_id, l_payroll_id,NULL,l_start_date,l_end_date);
2687: FETCH csr_is_payroll_run INTO l_chk;
2688: IF csr_is_payroll_run%FOUND THEN

Line 2692: hr_utility.trace('Payroll Details found : ');

2688: IF csr_is_payroll_run%FOUND THEN
2689: OPEN csr_ele_entries(v_csr_get_asg_org.assignment_id,l_start_date,l_end_date);
2690: FETCH csr_ele_entries INTO l_chk;
2691: IF csr_ele_entries%FOUND THEN
2692: hr_utility.trace('Payroll Details found : ');
2693: l_process := 'Y';
2694: END IF;
2695: CLOSE csr_ele_entries;
2696: END IF;

Line 2699: hr_utility.trace('Rehire Details not found : ');

2695: CLOSE csr_ele_entries;
2696: END IF;
2697: CLOSE csr_is_payroll_run;
2698: ELSE
2699: hr_utility.trace('Rehire Details not found : ');
2700: l_process:= 'Y';
2701: END IF;
2702: CLOSE csr_rehire_chk;
2703: END IF;

Line 2709: hr_utility.trace('Assignment id '||v_csr_get_asg_org.assignment_id);

2705: IF l_process = 'Y' THEN
2706: FOR v_csr_get_er_pyrls IN csr_get_er_pyrls(l_org_id,l_bg_id,l_start_date,abp_org_id)
2707: LOOP
2708: IF v_csr_get_er_pyrls.payroll_id = l_payroll_id THEN
2709: hr_utility.trace('Assignment id '||v_csr_get_asg_org.assignment_id);
2710: ins_assg_act(v_csr_get_asg_org.assignment_id,p_payroll_action_id,p_chunk,abp_org_id);
2711: EXIT;
2712: END IF;
2713: END LOOP;

Line 2717: hr_utility.trace('X====assignment_action_code================================X');

2713: END LOOP;
2714: END IF;
2715: END LOOP;
2716: END IF;
2717: hr_utility.trace('X====assignment_action_code================================X');
2718: EXCEPTION
2719: WHEN others THEN
2720: hr_utility.trace('Exception in assignment_action_code SQL-ERRM : '||SQLERRM);
2721: log_tech_exception(p_action_context_id => p_payroll_action_id,

Line 2720: hr_utility.trace('Exception in assignment_action_code SQL-ERRM : '||SQLERRM);

2716: END IF;
2717: hr_utility.trace('X====assignment_action_code================================X');
2718: EXCEPTION
2719: WHEN others THEN
2720: hr_utility.trace('Exception in assignment_action_code SQL-ERRM : '||SQLERRM);
2721: log_tech_exception(p_action_context_id => p_payroll_action_id,
2722: p_err_msg => 'assignment_action_code : '|| substr (sqlerrm, 1, 180)); --14793405
2723: END assignment_action_code;
2724:

Line 3384: hr_utility.trace('+====pay_period_archive==========================================+');

3380: lv_ptp := NULL;
3381: l_pension_st_date:= NULL;
3382:
3383:
3384: hr_utility.trace('+====pay_period_archive==========================================+');
3385:
3386: hr_utility.trace('l_assignment_id: '|| l_assignment_id);
3387: hr_utility.trace('l_person_id: '|| l_person_id);
3388: hr_utility.trace('l_bg_id: '|| l_bg_id);

Line 3386: hr_utility.trace('l_assignment_id: '|| l_assignment_id);

3382:
3383:
3384: hr_utility.trace('+====pay_period_archive==========================================+');
3385:
3386: hr_utility.trace('l_assignment_id: '|| l_assignment_id);
3387: hr_utility.trace('l_person_id: '|| l_person_id);
3388: hr_utility.trace('l_bg_id: '|| l_bg_id);
3389: hr_utility.trace('l_payroll_id: '|| l_payroll_id);
3390: hr_utility.trace('l_start_date: '|| l_start_date);

Line 3387: hr_utility.trace('l_person_id: '|| l_person_id);

3383:
3384: hr_utility.trace('+====pay_period_archive==========================================+');
3385:
3386: hr_utility.trace('l_assignment_id: '|| l_assignment_id);
3387: hr_utility.trace('l_person_id: '|| l_person_id);
3388: hr_utility.trace('l_bg_id: '|| l_bg_id);
3389: hr_utility.trace('l_payroll_id: '|| l_payroll_id);
3390: hr_utility.trace('l_start_date: '|| l_start_date);
3391: hr_utility.trace('l_end_date: '|| l_end_date);

Line 3388: hr_utility.trace('l_bg_id: '|| l_bg_id);

3384: hr_utility.trace('+====pay_period_archive==========================================+');
3385:
3386: hr_utility.trace('l_assignment_id: '|| l_assignment_id);
3387: hr_utility.trace('l_person_id: '|| l_person_id);
3388: hr_utility.trace('l_bg_id: '|| l_bg_id);
3389: hr_utility.trace('l_payroll_id: '|| l_payroll_id);
3390: hr_utility.trace('l_start_date: '|| l_start_date);
3391: hr_utility.trace('l_end_date: '|| l_end_date);
3392: --Bug 16301893

Line 3389: hr_utility.trace('l_payroll_id: '|| l_payroll_id);

3385:
3386: hr_utility.trace('l_assignment_id: '|| l_assignment_id);
3387: hr_utility.trace('l_person_id: '|| l_person_id);
3388: hr_utility.trace('l_bg_id: '|| l_bg_id);
3389: hr_utility.trace('l_payroll_id: '|| l_payroll_id);
3390: hr_utility.trace('l_start_date: '|| l_start_date);
3391: hr_utility.trace('l_end_date: '|| l_end_date);
3392: --Bug 16301893
3393: FOR rec_pay_periods IN csr_pay_periods (

Line 3390: hr_utility.trace('l_start_date: '|| l_start_date);

3386: hr_utility.trace('l_assignment_id: '|| l_assignment_id);
3387: hr_utility.trace('l_person_id: '|| l_person_id);
3388: hr_utility.trace('l_bg_id: '|| l_bg_id);
3389: hr_utility.trace('l_payroll_id: '|| l_payroll_id);
3390: hr_utility.trace('l_start_date: '|| l_start_date);
3391: hr_utility.trace('l_end_date: '|| l_end_date);
3392: --Bug 16301893
3393: FOR rec_pay_periods IN csr_pay_periods (
3394: c_assignment_id => l_assignment_id

Line 3391: hr_utility.trace('l_end_date: '|| l_end_date);

3387: hr_utility.trace('l_person_id: '|| l_person_id);
3388: hr_utility.trace('l_bg_id: '|| l_bg_id);
3389: hr_utility.trace('l_payroll_id: '|| l_payroll_id);
3390: hr_utility.trace('l_start_date: '|| l_start_date);
3391: hr_utility.trace('l_end_date: '|| l_end_date);
3392: --Bug 16301893
3393: FOR rec_pay_periods IN csr_pay_periods (
3394: c_assignment_id => l_assignment_id
3395: ,c_person_id => l_person_id

Line 3418: hr_utility.trace('Pension Salary : '||l_pension_salary);

3414: ,p_payroll_id => l_payroll_id
3415: ,p_start_date => l_start_date
3416: ,p_end_date => l_end_date
3417: ,p_asg_act => p_assignment_action_id);
3418: hr_utility.trace('Pension Salary : '||l_pension_salary);
3419:
3420: l_ptp:=get_curr_ptp(p_assignment_id => l_assignment_id
3421: ,p_bg_id => l_bg_id
3422: ,p_payroll_id => l_payroll_id

Line 3426: hr_utility.trace('PTP : '||l_ptp);

3422: ,p_payroll_id => l_payroll_id
3423: ,p_start_date => l_start_date
3424: ,p_end_date => last_day(l_end_date)
3425: ,p_asg_act => p_assignment_action_id);
3426: hr_utility.trace('PTP : '||l_ptp);
3427:
3428: get_retro_ptp(p_assignment_id => l_assignment_id
3429: ,p_start_date => l_start_date
3430: ,p_effective_date => l_start_date

Line 3435: hr_utility.trace('Pension Basis: ');

3431: ,p_bg_id => l_bg_id
3432: ,p_payroll_id => l_payroll_id
3433: ,retro_ptp_data => rPTPData);
3434:
3435: hr_utility.trace('Pension Basis: ');
3436:
3437: FOR i in 1..rPTPData.count + 1 LOOP
3438: l_empty_pay_period := 'ja';
3439:

Line 3462: hr_utility.trace('Pension count 1: '||l_contr_amt_values.count);

3458: ,p_start_date => lv_start_date
3459: ,p_end_date => lv_end_date
3460: ,p_contr_basis_values => l_contr_amt_values);
3461:
3462: hr_utility.trace('Pension count 1: '||l_contr_amt_values.count);
3463:
3464: hr_utility.trace('Pension Contribution : ');
3465: pension_contr(p_assignment_id => l_assignment_id
3466: ,p_person_id => l_person_id

Line 3464: hr_utility.trace('Pension Contribution : ');

3460: ,p_contr_basis_values => l_contr_amt_values);
3461:
3462: hr_utility.trace('Pension count 1: '||l_contr_amt_values.count);
3463:
3464: hr_utility.trace('Pension Contribution : ');
3465: pension_contr(p_assignment_id => l_assignment_id
3466: ,p_person_id => l_person_id
3467: ,p_bg_id => l_bg_id
3468: ,p_payroll_id => l_payroll_id

Line 3472: hr_utility.trace('Pension count 2: '||l_contr_amt_values.count);

3468: ,p_payroll_id => l_payroll_id
3469: ,p_start_date => lv_start_date
3470: ,p_end_date => lv_end_date
3471: ,p_contr_amt_values => l_contr_amt_values);
3472: hr_utility.trace('Pension count 2: '||l_contr_amt_values.count);
3473:
3474: hr_utility.trace('Pay Period Details ');
3475: OPEN csr_income_code(l_assignment_id,greatest(lv_start_date,l_asg_start_date));
3476: FETCH csr_income_code INTO l_income_code;

Line 3474: hr_utility.trace('Pay Period Details ');

3470: ,p_end_date => lv_end_date
3471: ,p_contr_amt_values => l_contr_amt_values);
3472: hr_utility.trace('Pension count 2: '||l_contr_amt_values.count);
3473:
3474: hr_utility.trace('Pay Period Details ');
3475: OPEN csr_income_code(l_assignment_id,greatest(lv_start_date,l_asg_start_date));
3476: FETCH csr_income_code INTO l_income_code;
3477: CLOSE csr_income_code;
3478:

Line 3569: hr_utility.trace('1.Archiving Pay Period Details-WNE');

3565: l_kop_end_date := NULL;
3566: END IF;
3567:
3568: IF l_wne_start_date IS NOT NULL AND l_wne_end_date IS NOT NULL AND l_wne_start_date < l_end_date THEN
3569: hr_utility.trace('1.Archiving Pay Period Details-WNE');
3570: pay_action_information_api.create_action_information
3571: (
3572: p_action_information_id => l_action_info_id
3573: , p_action_context_id => l_child_aa_id

Line 3588: hr_utility.trace('l_kop_report: '||l_kop_report);

3584: , p_action_information4 => l_income_code
3585: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)
3586: , p_action_information6 => l_empty_pay_period
3587: );
3588: hr_utility.trace('l_kop_report: '||l_kop_report);
3589: IF l_kop_report = 'Y' THEN
3590: l_kop_report := 'N';
3591: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
3592: fnd_message.set_token('VALUE','WNE');

Line 3628: hr_utility.trace('1.Archiving Pay Period Details-!WNE');

3624: lv_spl_date := l_kop_end_date;
3625: END IF;
3626: END IF;
3627:
3628: hr_utility.trace('1.Archiving Pay Period Details-!WNE');
3629: pay_action_information_api.create_action_information
3630: (
3631: p_action_information_id => l_action_info_id
3632: , p_action_context_id => l_child_aa_id

Line 3687: hr_utility.trace('2.Archiving Pay Period Details- WNE');

3683: l_wne_end_date := l_asg_end_date;
3684: ELSE
3685: l_wne_end_date := NULL;
3686: END IF;
3687: hr_utility.trace('2.Archiving Pay Period Details- WNE');
3688: pay_action_information_api.create_action_information
3689: (
3690: p_action_information_id => l_action_info_id
3691: , p_action_context_id => l_child_aa_id

Line 3767: hr_utility.trace('X====NL_ABP_WITHDRAWAL_INFO=======================X: '||p_person_id);

3763:
3764: FOR rec_wth_old_start IN csr_hire_dt_chg_wth(c_person_id => p_person_id
3765: ,c_start_date => p_start_date
3766: ,c_end_date => p_end_date) LOOP
3767: hr_utility.trace('X====NL_ABP_WITHDRAWAL_INFO=======================X: '||p_person_id);
3768: hr_utility.trace('lv_wth_old_start: '||rec_wth_old_start.date_earned);
3769: pay_action_information_api.create_action_information
3770: (
3771: p_action_information_id => l_action_info_id

Line 3768: hr_utility.trace('lv_wth_old_start: '||rec_wth_old_start.date_earned);

3764: FOR rec_wth_old_start IN csr_hire_dt_chg_wth(c_person_id => p_person_id
3765: ,c_start_date => p_start_date
3766: ,c_end_date => p_end_date) LOOP
3767: hr_utility.trace('X====NL_ABP_WITHDRAWAL_INFO=======================X: '||p_person_id);
3768: hr_utility.trace('lv_wth_old_start: '||rec_wth_old_start.date_earned);
3769: pay_action_information_api.create_action_information
3770: (
3771: p_action_information_id => l_action_info_id
3772: , p_action_context_id => l_child_aa_id

Line 3788: hr_utility.trace('X====pay_period_archive==========================================X');

3784: , p_action_information5 => l_code_withdrawal
3785: );
3786: END LOOP;
3787:
3788: hr_utility.trace('X====pay_period_archive==========================================X');
3789: EXCEPTION
3790: WHEN others THEN
3791: hr_utility.trace('Exception in pay_period_archive SQL-ERRM : '||SQLERRM);
3792: log_tech_exception(p_action_context_id => g_payroll_action_id,

Line 3791: hr_utility.trace('Exception in pay_period_archive SQL-ERRM : '||SQLERRM);

3787:
3788: hr_utility.trace('X====pay_period_archive==========================================X');
3789: EXCEPTION
3790: WHEN others THEN
3791: hr_utility.trace('Exception in pay_period_archive SQL-ERRM : '||SQLERRM);
3792: log_tech_exception(p_action_context_id => g_payroll_action_id,
3793: p_err_msg => 'pay_period_archive : '|| substr (sqlerrm, 1, 180));
3794: END pay_period_archive;
3795: --=========================================================================

Line 3798: hr_utility.trace('+====archive_code==========================================+');

3794: END pay_period_archive;
3795: --=========================================================================
3796:
3797: BEGIN
3798: hr_utility.trace('+====archive_code==========================================+');
3799: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
3800: hr_utility.trace('p_effective_date : '||p_effective_date);
3801:
3802: l_contr_amt_values.delete;

Line 3799: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);

3795: --=========================================================================
3796:
3797: BEGIN
3798: hr_utility.trace('+====archive_code==========================================+');
3799: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
3800: hr_utility.trace('p_effective_date : '||p_effective_date);
3801:
3802: l_contr_amt_values.delete;
3803: l_all_contr_amt_values.delete;

Line 3800: hr_utility.trace('p_effective_date : '||p_effective_date);

3796:
3797: BEGIN
3798: hr_utility.trace('+====archive_code==========================================+');
3799: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
3800: hr_utility.trace('p_effective_date : '||p_effective_date);
3801:
3802: l_contr_amt_values.delete;
3803: l_all_contr_amt_values.delete;
3804:

Line 3809: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);

3805: OPEN csr_get_pact_chunk(p_assignment_action_id);
3806: FETCH csr_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
3807: CLOSE csr_get_pact_chunk;
3808:
3809: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
3810: hr_utility.trace('l_chunk_number : '||l_chunk_number);
3811:
3812: get_all_parameters (
3813: p_payroll_action_id => l_payroll_action_id

Line 3810: hr_utility.trace('l_chunk_number : '||l_chunk_number);

3806: FETCH csr_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
3807: CLOSE csr_get_pact_chunk;
3808:
3809: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
3810: hr_utility.trace('l_chunk_number : '||l_chunk_number);
3811:
3812: get_all_parameters (
3813: p_payroll_action_id => l_payroll_action_id
3814: ,p_org_struct_id => l_org_struct_id

Line 3822: hr_utility.trace('Org Struct Id : ' ||l_org_struct_id);

3818: ,p_bg_id => l_bg_id
3819: ,p_start_date => l_start_date
3820: ,p_end_date => l_end_date);
3821:
3822: hr_utility.trace('Org Struct Id : ' ||l_org_struct_id);
3823: hr_utility.trace('Org Id : ' ||l_org_id);
3824: hr_utility.trace('Report Type : ' ||l_report_type);
3825: hr_utility.trace('Business Group Id : '||l_bg_id);
3826: hr_utility.trace('Start Date : ' ||l_start_date);

Line 3823: hr_utility.trace('Org Id : ' ||l_org_id);

3819: ,p_start_date => l_start_date
3820: ,p_end_date => l_end_date);
3821:
3822: hr_utility.trace('Org Struct Id : ' ||l_org_struct_id);
3823: hr_utility.trace('Org Id : ' ||l_org_id);
3824: hr_utility.trace('Report Type : ' ||l_report_type);
3825: hr_utility.trace('Business Group Id : '||l_bg_id);
3826: hr_utility.trace('Start Date : ' ||l_start_date);
3827: hr_utility.trace('End Date : ' ||l_end_date);

Line 3824: hr_utility.trace('Report Type : ' ||l_report_type);

3820: ,p_end_date => l_end_date);
3821:
3822: hr_utility.trace('Org Struct Id : ' ||l_org_struct_id);
3823: hr_utility.trace('Org Id : ' ||l_org_id);
3824: hr_utility.trace('Report Type : ' ||l_report_type);
3825: hr_utility.trace('Business Group Id : '||l_bg_id);
3826: hr_utility.trace('Start Date : ' ||l_start_date);
3827: hr_utility.trace('End Date : ' ||l_end_date);
3828:

Line 3825: hr_utility.trace('Business Group Id : '||l_bg_id);

3821:
3822: hr_utility.trace('Org Struct Id : ' ||l_org_struct_id);
3823: hr_utility.trace('Org Id : ' ||l_org_id);
3824: hr_utility.trace('Report Type : ' ||l_report_type);
3825: hr_utility.trace('Business Group Id : '||l_bg_id);
3826: hr_utility.trace('Start Date : ' ||l_start_date);
3827: hr_utility.trace('End Date : ' ||l_end_date);
3828:
3829: OPEN csr_asg_id(p_assignment_action_id,l_payroll_action_id);

Line 3826: hr_utility.trace('Start Date : ' ||l_start_date);

3822: hr_utility.trace('Org Struct Id : ' ||l_org_struct_id);
3823: hr_utility.trace('Org Id : ' ||l_org_id);
3824: hr_utility.trace('Report Type : ' ||l_report_type);
3825: hr_utility.trace('Business Group Id : '||l_bg_id);
3826: hr_utility.trace('Start Date : ' ||l_start_date);
3827: hr_utility.trace('End Date : ' ||l_end_date);
3828:
3829: OPEN csr_asg_id(p_assignment_action_id,l_payroll_action_id);
3830: FETCH csr_asg_id into l_assignment_id;

Line 3827: hr_utility.trace('End Date : ' ||l_end_date);

3823: hr_utility.trace('Org Id : ' ||l_org_id);
3824: hr_utility.trace('Report Type : ' ||l_report_type);
3825: hr_utility.trace('Business Group Id : '||l_bg_id);
3826: hr_utility.trace('Start Date : ' ||l_start_date);
3827: hr_utility.trace('End Date : ' ||l_end_date);
3828:
3829: OPEN csr_asg_id(p_assignment_action_id,l_payroll_action_id);
3830: FETCH csr_asg_id into l_assignment_id;
3831: CLOSE csr_asg_id;

Line 3833: hr_utility.trace('Assignment Id : ' ||l_assignment_id);

3829: OPEN csr_asg_id(p_assignment_action_id,l_payroll_action_id);
3830: FETCH csr_asg_id into l_assignment_id;
3831: CLOSE csr_asg_id;
3832:
3833: hr_utility.trace('Assignment Id : ' ||l_assignment_id);
3834:
3835: OPEN csr_get_person_id(l_assignment_id);
3836: FETCH csr_get_person_id into l_person_id;
3837: CLOSE csr_get_person_id;

Line 3839: hr_utility.trace('Person Id : ' ||l_person_id);

3835: OPEN csr_get_person_id(l_assignment_id);
3836: FETCH csr_get_person_id into l_person_id;
3837: CLOSE csr_get_person_id;
3838:
3839: hr_utility.trace('Person Id : ' ||l_person_id);
3840:
3841: IF l_payroll_id IS NULL THEN
3842: OPEN csr_get_payroll_id(l_assignment_id);
3843: FETCH csr_get_payroll_id INTO l_payroll_id;

Line 3847: hr_utility.trace('Payroll Id : ' ||l_payroll_id);

3843: FETCH csr_get_payroll_id INTO l_payroll_id;
3844: CLOSE csr_get_payroll_id;
3845: END IF;
3846:
3847: hr_utility.trace('Payroll Id : ' ||l_payroll_id);
3848:
3849: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
3850:
3851: hr_nonrun_asact.insact(

Line 3859: hr_utility.trace('Child Asg Action Id : ' ||l_child_aa_id);

3855: , chunk => l_chunk_number
3856: , status => 'C'
3857: , source_act => p_assignment_action_id);
3858:
3859: hr_utility.trace('Child Asg Action Id : ' ||l_child_aa_id);
3860:
3861: OPEN csr_get_asg_period(l_assignment_id);
3862: FETCH csr_get_asg_period into l_asg_start_date,l_asg_end_date;
3863: CLOSE csr_get_asg_period;

Line 3865: hr_utility.trace('Asg Start date '||l_asg_start_date);

3861: OPEN csr_get_asg_period(l_assignment_id);
3862: FETCH csr_get_asg_period into l_asg_start_date,l_asg_end_date;
3863: CLOSE csr_get_asg_period;
3864:
3865: hr_utility.trace('Asg Start date '||l_asg_start_date);
3866: hr_utility.trace('Asg End date '||l_asg_end_date);
3867:
3868: /* --15859347
3869: OPEN csr_get_asg_term_date(l_bg_id,l_end_date,l_assignment_id);

Line 3866: hr_utility.trace('Asg End date '||l_asg_end_date);

3862: FETCH csr_get_asg_period into l_asg_start_date,l_asg_end_date;
3863: CLOSE csr_get_asg_period;
3864:
3865: hr_utility.trace('Asg Start date '||l_asg_start_date);
3866: hr_utility.trace('Asg End date '||l_asg_end_date);
3867:
3868: /* --15859347
3869: OPEN csr_get_asg_term_date(l_bg_id,l_end_date,l_assignment_id);
3870: FETCH csr_get_asg_term_date INTO l_asg_term_date,l_term_pos_id;

Line 3891: hr_utility.trace('Asg End date '||l_asg_end_date);

3887: l_asg_end_date := l_asg_term_date;
3888: END IF;
3889: --15859347
3890:
3891: hr_utility.trace('Asg End date '||l_asg_end_date);
3892:
3893: IF l_asg_end_date IS NOT NULL THEN
3894: --asg is terminated. Get the termination reason
3895: OPEN csr_get_end_reason(l_assignment_id,l_asg_end_date);

Line 3903: hr_utility.trace('End Date : '||l_end_date);

3899: l_end_date := least(l_end_date,l_asg_end_date);
3900: END IF;
3901: END IF;
3902:
3903: hr_utility.trace('End Date : '||l_end_date);
3904:
3905: OPEN csr_get_person_info(l_person_id,l_bg_id,nvl(l_asg_end_date,l_end_date));
3906: FETCH csr_get_person_info into l_person_info;
3907: CLOSE csr_get_person_info;

Line 4079: hr_utility.trace('Termination Date has changed - Less' );

4075: IF l_asg_end_date < nvl(l_prev_asg_info.term_date,l_prev_asg_info.start_date) THEN
4076: -- Termination date is less than the prev reported value.
4077: -- Withdrawal Pay period to be reported.
4078:
4079: hr_utility.trace('Termination Date has changed - Less' );
4080: hr_utility.trace('Prev Period Start Date ' ||l_prev_asg_info.start_date);
4081: hr_utility.trace('Prev Termination Date ' ||l_prev_asg_info.term_date);
4082: hr_utility.trace('End Date ' ||l_asg_end_date);
4083:

Line 4080: hr_utility.trace('Prev Period Start Date ' ||l_prev_asg_info.start_date);

4076: -- Termination date is less than the prev reported value.
4077: -- Withdrawal Pay period to be reported.
4078:
4079: hr_utility.trace('Termination Date has changed - Less' );
4080: hr_utility.trace('Prev Period Start Date ' ||l_prev_asg_info.start_date);
4081: hr_utility.trace('Prev Termination Date ' ||l_prev_asg_info.term_date);
4082: hr_utility.trace('End Date ' ||l_asg_end_date);
4083:
4084: pay_action_information_api.create_action_information

Line 4081: hr_utility.trace('Prev Termination Date ' ||l_prev_asg_info.term_date);

4077: -- Withdrawal Pay period to be reported.
4078:
4079: hr_utility.trace('Termination Date has changed - Less' );
4080: hr_utility.trace('Prev Period Start Date ' ||l_prev_asg_info.start_date);
4081: hr_utility.trace('Prev Termination Date ' ||l_prev_asg_info.term_date);
4082: hr_utility.trace('End Date ' ||l_asg_end_date);
4083:
4084: pay_action_information_api.create_action_information
4085: (

Line 4082: hr_utility.trace('End Date ' ||l_asg_end_date);

4078:
4079: hr_utility.trace('Termination Date has changed - Less' );
4080: hr_utility.trace('Prev Period Start Date ' ||l_prev_asg_info.start_date);
4081: hr_utility.trace('Prev Termination Date ' ||l_prev_asg_info.term_date);
4082: hr_utility.trace('End Date ' ||l_asg_end_date);
4083:
4084: pay_action_information_api.create_action_information
4085: (
4086: p_action_information_id => l_action_info_id

Line 4103: hr_utility.trace('Termination Less : Entry for '||l_prev_asg_info.start_date);

4099: , p_action_information5 => fnd_date.date_to_canonical(l_start_date)
4100: , p_action_information6 => fnd_date.date_to_canonical(l_end_date)
4101: );
4102: IF l_prev_asg_info.start_date <= l_asg_end_date THEN
4103: hr_utility.trace('Termination Less : Entry for '||l_prev_asg_info.start_date);
4104: pay_period_data(l_pay_period_count) := l_prev_asg_info.start_date;
4105: l_pay_period_count := l_pay_period_count + 1;
4106: END IF;
4107: l_flag:=1;

Line 4113: hr_utility.trace('Termination Date has changed - Greater' );

4109: END LOOP;
4110:
4111: FOR l_prev_asg_info2 IN csr_get_prev_asg_info2(l_assignment_id) LOOP
4112: IF l_asg_end_date > l_prev_asg_info2.term_date THEN
4113: hr_utility.trace('Termination Date has changed - Greater' );
4114: hr_utility.trace('Termination Greater : Entry for '||l_prev_asg_info2.start_date);
4115: -- Termination date is greater than the prev reported value.
4116: pay_period_data(l_pay_period_count) := l_prev_asg_info2.start_date;
4117: l_pay_period_count := l_pay_period_count + 1;

Line 4114: hr_utility.trace('Termination Greater : Entry for '||l_prev_asg_info2.start_date);

4110:
4111: FOR l_prev_asg_info2 IN csr_get_prev_asg_info2(l_assignment_id) LOOP
4112: IF l_asg_end_date > l_prev_asg_info2.term_date THEN
4113: hr_utility.trace('Termination Date has changed - Greater' );
4114: hr_utility.trace('Termination Greater : Entry for '||l_prev_asg_info2.start_date);
4115: -- Termination date is greater than the prev reported value.
4116: pay_period_data(l_pay_period_count) := l_prev_asg_info2.start_date;
4117: l_pay_period_count := l_pay_period_count + 1;
4118: l_flag:=1;

Line 4124: hr_utility.trace('Termination Date Change - Either : Entry for '||l_asg_end_date);

4120: END LOOP;
4121:
4122: IF (l_flag = 1 OR l_asg_end_date < l_start_date ) AND l_asg_end_date >= g_valid_start_date THEN
4123: --Either termination date is less or greater than current value
4124: hr_utility.trace('Termination Date Change - Either : Entry for '||l_asg_end_date);
4125: pay_period_data(l_pay_period_count) := l_asg_end_date;
4126: l_pay_period_count := l_pay_period_count + 1;
4127: END IF;
4128:

Line 4134: hr_utility.trace('Termination Reversal : Entry for '||l_prev_asg_info3.start_date);

4130: --Asg end date is null.
4131: --The following check is done to see if termination has been reversed.
4132: --Fetch all periods with incorrect term date
4133: FOR l_prev_asg_info3 IN csr_get_prev_asg_info3(l_assignment_id) LOOP
4134: hr_utility.trace('Termination Reversal : Entry for '||l_prev_asg_info3.start_date);
4135: pay_period_data(l_pay_period_count) := l_prev_asg_info3.start_date;
4136: l_pay_period_count := l_pay_period_count + 1;
4137: END LOOP;
4138:

Line 4140: hr_utility.trace('Termination Reversal - Current: Entry for '||l_start_date);

4136: l_pay_period_count := l_pay_period_count + 1;
4137: END LOOP;
4138:
4139: IF l_pay_period_count > 1 THEN
4140: hr_utility.trace('Termination Reversal - Current: Entry for '||l_start_date);
4141: pay_period_data(l_pay_period_count) := l_start_date;
4142: l_pay_period_count := l_pay_period_count + 1;
4143: END IF;
4144:

Line 4147: /*hr_utility.trace('Employee Number/Asg Num/Asg Start Date/Asg End Date/Termination Reason/Emp Kind: '

4143: END IF;
4144:
4145: END IF;
4146:
4147: /*hr_utility.trace('Employee Number/Asg Num/Asg Start Date/Asg End Date/Termination Reason/Emp Kind: '
4148: ||l_person_info.employee_number||' '
4149: ||nvl(l_numiv_override,l_asg_seq)||' '
4150: ||l_asg_start_date||' '
4151: ||l_asg_end_date||' '

Line 4155: hr_utility.trace('Archiving Assignment Info : ');

4151: ||l_asg_end_date||' '
4152: ||l_term_reason||' '
4153: ||l_kind_emp);*/
4154:
4155: hr_utility.trace('Archiving Assignment Info : ');
4156:
4157: pay_action_information_api.create_action_information
4158: (
4159: p_action_information_id => l_action_info_id

Line 4219: hr_utility.trace('Dutch Address Found : ');

4215: OPEN csr_get_person_addr(l_person_id,nvl(l_asg_end_date,l_end_date));
4216: FETCH csr_get_person_addr INTO l_person_addr;
4217: IF csr_get_person_addr%FOUND THEN
4218: IF l_person_addr.style = 'NL' THEN
4219: hr_utility.trace('Dutch Address Found : ');
4220: l_street := substr(l_person_addr.region, 1, 24);
4221: l_house_number := l_person_addr.nl_hno;
4222: l_house_number_addition := l_person_addr.nl_hnoa;
4223: l_location := l_person_addr.nl_location;

Line 4227: hr_utility.trace('Foreign Address Found : ');

4223: l_location := l_person_addr.nl_location;
4224: l_postal_code := REPLACE(l_person_addr.postal,' ','');
4225: l_city := l_person_addr.city;
4226: ELSIF l_person_addr.style = 'NL_GLB' THEN
4227: hr_utility.trace('Foreign Address Found : ');
4228: l_street := l_person_addr.glb_street;
4229: l_house_number := l_person_addr.glb_hno;
4230: l_location := l_person_addr.glb_location;
4231: l_postal_code := substr(l_person_addr.postal, 1, 9);

Line 4377: hr_utility.trace('Archiving Person Data : ');

4373: OPEN csr_prin_obj(l_assignment_id,nvl(l_asg_end_date,l_end_date));
4374: FETCH csr_prin_obj into l_individual_exem;
4375: CLOSE csr_prin_obj;
4376:
4377: hr_utility.trace('Archiving Person Data : ');
4378:
4379: pay_action_information_api.create_action_information
4380: (
4381: p_action_information_id => l_action_info_id

Line 4421: hr_utility.trace('Pay Period Count '||pay_period_data.count);

4417: , p_action_information28 => l_person_data
4418: );
4419:
4420:
4421: hr_utility.trace('Pay Period Count '||pay_period_data.count);
4422: l_kop_report := 'Y';
4423: IF pay_period_data.count > 0 THEN
4424: l_temp_dates.delete;
4425: l_temp := 0;

Line 4439: hr_utility.trace('Pay period start date : '||l_start_date);

4435: IF l_asg_end_date > l_start_date THEN
4436: l_end_date := least(l_asg_end_date,l_end_date);
4437: END IF;
4438:
4439: hr_utility.trace('Pay period start date : '||l_start_date);
4440: hr_utility.trace('Pay period end date : '||l_end_date);
4441:
4442: l_fetch := 'Y';
4443: IF l_temp_dates.count > 0 THEN

Line 4440: hr_utility.trace('Pay period end date : '||l_end_date);

4436: l_end_date := least(l_asg_end_date,l_end_date);
4437: END IF;
4438:
4439: hr_utility.trace('Pay period start date : '||l_start_date);
4440: hr_utility.trace('Pay period end date : '||l_end_date);
4441:
4442: l_fetch := 'Y';
4443: IF l_temp_dates.count > 0 THEN
4444: FOR l IN l_temp_dates.FIRST..l_temp_dates.LAST LOOP

Line 4451: hr_utility.trace('l_fetch : '||l_fetch);

4447: END IF;
4448: END LOOP;
4449: END IF;
4450:
4451: hr_utility.trace('l_fetch : '||l_fetch);
4452:
4453: IF l_fetch = 'Y' AND (l_asg_end_date IS NULL OR l_asg_end_date > l_start_date) THEN
4454: l_temp_dates(l_temp) := l_start_date;
4455: l_temp := l_temp + 1;

Line 4479: hr_utility.trace('Assignment Withdrawal flag set: '||l_assignment_id);

4475: END IF;
4476: END IF;--l_person_data = 'Y'
4477:
4478: ELSE --Assignment Withdrawal flag set
4479: hr_utility.trace('Assignment Withdrawal flag set: '||l_assignment_id);
4480: --check if previously withdrawn details sent
4481: OPEN csr_prev_withdrawn(l_assignment_id);
4482: FETCH csr_prev_withdrawn INTO l_prev_withdrawn;
4483: IF csr_prev_withdrawn%NOTFOUND THEN

Line 4492: hr_utility.trace('months_between(l_wth_prd_start_date,l_asg_start_date) : '||months_between(l_wth_prd_start_date,l_asg_start_date));

4488: l_wth_prd_end_date := last_day(l_end_date);
4489:
4490: WHILE l_wth_prd_start_date <= l_wth_prd_end_date
4491: LOOP
4492: hr_utility.trace('months_between(l_wth_prd_start_date,l_asg_start_date) : '||months_between(l_wth_prd_start_date,l_asg_start_date));
4493: IF l_pay_period_det_cnt = months_between(trunc(l_wth_prd_start_date,'MM'),trunc(l_asg_start_date,'MM')) THEN
4494: l_code_withdrawal := 'ja';
4495: END IF;
4496: pay_action_information_api.create_action_information

Line 4518: hr_utility.trace('X====archive_code==========================================X');

4514: END LOOP;
4515: END IF;
4516: CLOSE csr_prev_withdrawn;
4517: END IF;
4518: hr_utility.trace('X====archive_code==========================================X');
4519: EXCEPTION
4520:
4521: WHEN TOO_MANY_ROWS THEN
4522: hr_utility.trace('Too Many Rows Exception in archive_code');

Line 4522: hr_utility.trace('Too Many Rows Exception in archive_code');

4518: hr_utility.trace('X====archive_code==========================================X');
4519: EXCEPTION
4520:
4521: WHEN TOO_MANY_ROWS THEN
4522: hr_utility.trace('Too Many Rows Exception in archive_code');
4523: log_tech_exception(p_action_context_id => g_payroll_action_id,
4524: p_err_msg => 'archive_code : '|| substr (sqlerrm, 1, 180)); --14793405
4525:
4526: WHEN NO_DATA_FOUND THEN

Line 4527: hr_utility.trace('No Data Found Exception in archive_code');

4523: log_tech_exception(p_action_context_id => g_payroll_action_id,
4524: p_err_msg => 'archive_code : '|| substr (sqlerrm, 1, 180)); --14793405
4525:
4526: WHEN NO_DATA_FOUND THEN
4527: hr_utility.trace('No Data Found Exception in archive_code');
4528: log_tech_exception(p_action_context_id => g_payroll_action_id,
4529: p_err_msg => 'archive_code : '|| substr (sqlerrm, 1, 180)); --14793405
4530:
4531: WHEN others THEN

Line 4532: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);

4528: log_tech_exception(p_action_context_id => g_payroll_action_id,
4529: p_err_msg => 'archive_code : '|| substr (sqlerrm, 1, 180)); --14793405
4530:
4531: WHEN others THEN
4532: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
4533: log_tech_exception(p_action_context_id => g_payroll_action_id,
4534: p_err_msg => 'archive_code : '|| substr (sqlerrm, 1, 180)); --14793405
4535:
4536: END archive_code;