APPS.PQH_DE_LOCAL_COST_LIVING_PKG dependencies on HR_UTILITY

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

143:
144: BEGIN
145:
146:
147: hr_utility.set_location('Entering '||l_proc,10);
148:
149: -- Cursor to get the grade id for the given pay Grade
150:
151: open c_person_id (p_ASSIGNMENT_ID ,p_effective_date );

Line 155: hr_utility.set_location('Entering '||l_proc,20);

151: open c_person_id (p_ASSIGNMENT_ID ,p_effective_date );
152: fetch c_person_id into p_person_id ;
153: close c_person_id ;
154:
155: hr_utility.set_location('Entering '||l_proc,20);
156:
157:
158: -- Cursor to get the grade id for the given pay Grade
159:

Line 164: hr_utility.set_location('Entering '||l_proc,30);

160: open c_grade_id (p_pay_grade ,p_business_group_id ,p_effective_date );
161: fetch c_grade_id into l_grade_id;
162: close c_grade_id;
163:
164: hr_utility.set_location('Entering '||l_proc,30);
165:
166: -- Cursor to get the additional amount information for the given pay Grade, tariff group in
167: -- Hierarchy structure .
168:

Line 174: hr_utility.set_location('Entering '||l_proc,30);

170: fetch c_tariff_class into
171: l_information1,l_information2,l_information3,l_information4,l_information5,l_information6;
172: close c_tariff_class;
173:
174: hr_utility.set_location('Entering '||l_proc,30);
175:
176: -- Loop for calculation of additional amount
177:
178: For c_count in c_seq_number(P_person_id ,p_business_group_id ,p_effective_date)

Line 188: hr_utility.set_location('Entering '||l_proc,40);

184: end if ;
185: count_child := count_child +1;
186: end loop;
187:
188: hr_utility.set_location('Entering '||l_proc,40);
189:
190: -- End Loop for calculation of additional amount
191:
192: -- To get total amount of money to be paid based on number of Children.

Line 212: hr_utility.set_location('Entering '||l_proc,50);

208: open c_alimony_amount (P_person_id,p_business_group_id,p_effective_date);
209: fetch c_alimony_amount into l_alimony_amount;
210: close c_alimony_amount;
211:
212: hr_utility.set_location('Entering '||l_proc,50);
213:
214: -- Cursor to get the Marital Status of the employee
215:
216: open c_marital_status (P_person_id,p_business_group_id,p_effective_date);

Line 221: hr_utility.set_location('Entering '||l_proc,60);

217: fetch c_marital_status into l_marital_status;
218: close c_marital_status;
219:
220:
221: hr_utility.set_location('Entering '||l_proc,60);
222:
223: if l_marital_status ='M' then
224: l_sum_amount := l_sum_amount + Total + to_number(nvl(l_Information5,0)) - to_number(nvl(l_Information4,0)) ;
225: elsif l_marital_status ='S' then