DBA Data[Home] [Help]

APPS.PQP_INI_BAL dependencies on HR_UTILITY

Line 429: hr_utility.set_location('***** ADDL PROCESSED AMT2: ',p_bal_info(balind).Addl_Pasg_Amt);

425: g_sum_bal_info(sumind).NI_Amt :=NVL(g_sum_bal_info(sumind).NI_Amt,0)
426: + NVL(p_bal_info(balind).NI_Amt,0);
427: g_sum_bal_info(sumind).Taxable_Amt :=NVL(g_sum_bal_info(sumind).Taxable_Amt,0)
428: + NVL(p_bal_info(balind).Taxable_Amt,0);
429: hr_utility.set_location('***** ADDL PROCESSED AMT2: ',p_bal_info(balind).Addl_Pasg_Amt);
430: g_sum_bal_info(sumind).Addl_Pasg_Amt :=NVL(g_sum_bal_info(sumind).Addl_Pasg_Amt,0)
431: + NVL(p_bal_info(balind).Addl_Pasg_Amt,0);
432: g_sum_bal_info(sumind).Addl_Ni_Amt :=NVL(g_sum_bal_info(sumind).Addl_Ni_Amt,0)
433: + NVL(p_bal_info(balind).Addl_Ni_Amt,0);

Line 902: hr_utility.set_location(l_proc,10);

898: l_get_payroll_det c_get_payroll_det%ROWTYPE;
899: l_effective_date DATE;
900: l_proc varchar2(72) ;--:= g_package ||'get_effective_date';
901: BEGIN
902: hr_utility.set_location(l_proc,10);
903: OPEN c_get_max_date ( p_assignment_id
904: ,p_business_group_id
905: );
906: FETCH c_get_max_date INTO l_effective_date;

Line 913: hr_utility.set_location(l_proc,20);

909: ,p_business_group_id
910: ,l_effective_date
911: );
912: FETCH c_get_payroll_det INTO l_get_payroll_det;
913: hr_utility.set_location(l_proc,20);
914: CLOSE c_get_payroll_det;
915: p_payroll_id :=l_get_payroll_det.payroll_id;
916: p_consolidation_set_id := l_get_payroll_det.consolidation_set_id;
917: RETURN(l_effective_date);

Line 918: hr_utility.set_location(l_proc,30);

914: CLOSE c_get_payroll_det;
915: p_payroll_id :=l_get_payroll_det.payroll_id;
916: p_consolidation_set_id := l_get_payroll_det.consolidation_set_id;
917: RETURN(l_effective_date);
918: hr_utility.set_location(l_proc,30);
919: END;
920:
921: -- This function returns the element_type_id given the Element Name
922: FUNCTION get_element_id (p_business_group_id IN NUMBER

Line 1054: hr_utility.set_location('Entering Query for Element Id: '||p_element_name,dbms_utility.get_time);

1050: g_payroll_det_cache(1).consolidation_set_id := l_consol_set_id;
1051: g_payroll_det_cache(1).effective_date := l_effective_date;
1052: END IF;
1053:
1054: hr_utility.set_location('Entering Query for Element Id: '||p_element_name,dbms_utility.get_time);
1055:
1056: --Check the Element Cache for Element Type Id
1057: FOR i in 1..g_element_cache.count
1058: LOOP

Line 1165: hr_utility.set_location('Exiting Function Call for Element Link: '||l_element_link_id,dbms_utility.get_time);

1161: ,p_element_id =>l_element_type_id
1162: ,p_effective_date =>l_effective_date
1163: );
1164:
1165: hr_utility.set_location('Exiting Function Call for Element Link: '||l_element_link_id,dbms_utility.get_time);
1166:
1167: if l_element_type_id is not null then
1168: l_effective_start_date := NULL;
1169: l_effective_end_date := NULL;

Line 1170: hr_utility.set_location('Entering Function to Create Adjustment: '||l_effective_date,dbms_utility.get_time);

1166:
1167: if l_element_type_id is not null then
1168: l_effective_start_date := NULL;
1169: l_effective_end_date := NULL;
1170: hr_utility.set_location('Entering Function to Create Adjustment: '||l_effective_date,dbms_utility.get_time);
1171: -- Create the Balance Adjustment Entry
1172: pay_balance_adjustment_api.create_adjustment(
1173: p_effective_date =>l_effective_date
1174: ,p_assignment_id =>p_assignment_id

Line 1653: hr_utility.set_location('Up Grade Status '||l_prev_upgrade_status,1);

1649: l_status_count := 0;
1650: END IF;
1651:
1652: l_prev_upgrade_status := NVL(l_prev_upgrade_status,'N');
1653: hr_utility.set_location('Up Grade Status '||l_prev_upgrade_status,1);
1654:
1655: IF l_prev_upgrade_status in ('N','P') THEN
1656: OPEN c_upgrade_patch_status;
1657: FETCH c_upgrade_patch_status INTO l_update_date;

Line 1779: hr_utility.set_location('***** PROCESSED AMT: ',l_proc_amt);

1775: ,p_element_entry_id =>l_get_info.element_entry_id
1776: ,p_assignment_action_id =>l_get_info.assignment_action_id
1777: );
1778:
1779: hr_utility.set_location('***** PROCESSED AMT: ',l_proc_amt);
1780:
1781: --Get the IRAM Amt for the particular Entry
1782: l_iram_amt :=pqp_clm_bal.get_vehicletype_balance
1783: (p_assignment_id =>l_get_info.assignment_id

Line 1860: hr_utility.set_location('***** ADDL PROCESSED AMT: ',l_addl_pass_amt);

1856: l_addl_tax_amt := -l_bal_info(i).Addl_Tax_Amt;
1857: EXIT;
1858: END IF;
1859: END LOOP;
1860: hr_utility.set_location('***** ADDL PROCESSED AMT: ',l_addl_pass_amt);
1861: END IF;
1862:
1863: hr_utility.set_location('Addl Pass Amt **'||l_addl_pass_amt,3);
1864: l_bal_info(l_count+1).Addl_Pasg_Amt :=l_addl_pass_amt;

Line 1863: hr_utility.set_location('Addl Pass Amt **'||l_addl_pass_amt,3);

1859: END LOOP;
1860: hr_utility.set_location('***** ADDL PROCESSED AMT: ',l_addl_pass_amt);
1861: END IF;
1862:
1863: hr_utility.set_location('Addl Pass Amt **'||l_addl_pass_amt,3);
1864: l_bal_info(l_count+1).Addl_Pasg_Amt :=l_addl_pass_amt;
1865: l_bal_info(l_count+1).Addl_Ni_Amt :=l_addl_ni_amt;
1866: l_bal_info(l_count+1).Addl_Tax_Amt :=l_addl_tax_amt;
1867: l_bal_info(l_count+1).Addl_Pasg_Miles :=l_proc_miles;

Line 2007: hr_utility.set_location('***** PROCESSED AMT: ',l_proc_amt);

2003: EXIT;
2004: END IF;
2005: END LOOP;
2006: END IF;
2007: hr_utility.set_location('***** PROCESSED AMT: ',l_proc_amt);
2008:
2009:
2010: IF l_get_info.additional_passenger <> 0 THEN
2011: IF l_get_info.source_type <> 'R' and l_get_info.source_type <> 'V'THEN

Line 2036: hr_utility.set_location('***** ADDL PROCESSED AMT: ',l_addl_pass_amt);

2032: l_bal_info(l_count+1).Addl_Tax_Amt := 0;
2033: l_bal_info(l_count+1).Addl_Pasg_Miles := l_get_info.Claimed_Mileage;
2034: l_bal_info(l_count+1).Addl_Pasg_Act_Miles :=0;
2035: END IF;
2036: hr_utility.set_location('***** ADDL PROCESSED AMT: ',l_addl_pass_amt);
2037:
2038: l_bal_info(l_count+1).NI_Amt := 0;
2039: l_bal_info(l_count+1).Taxable_Amt := 0;
2040: l_bal_info(l_count+1).PAYE_Taxable :='Y';