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.PQH_REALLOCATION_PKG dependencies on HR_UTILITY

Line 219: hr_utility.set_location('mode passed'||p_type,10);

215: calc_end_date date;
216: --
217: begin
218: --
219: hr_utility.set_location('mode passed'||p_type,10);
220: if p_type = 'RCVD' then
221: l_txn_type := 'RD';
222: elsif p_type in ('DNTD','RSRVD') then
223: l_txn_type := 'DD';

Line 225: hr_utility.set_location('wrong mode passed'||p_type,10);

221: l_txn_type := 'RD';
222: elsif p_type in ('DNTD','RSRVD') then
223: l_txn_type := 'DD';
224: else
225: hr_utility.set_location('wrong mode passed'||p_type,10);
226: end if;
227: for l_reallocation in c_reallocation loop
228: calc_start_date := greatest(l_reallocation.budget_start_date, p_start_date);
229: calc_end_date := least(l_reallocation.budget_end_date, p_end_date);

Line 233: hr_utility.set_location('period set name '||l_reallocation.period_set_name,20);

229: calc_end_date := least(l_reallocation.budget_end_date, p_end_date);
230: --
231: -- Calculate the prorate ratio
232: --
233: hr_utility.set_location('period set name '||l_reallocation.period_set_name,20);
234: l_prorate_ratio := pqh_budgeted_salary_pkg.get_prorate_ratio
235: ( calc_start_date
236: , calc_end_date
237: , l_reallocation.period_set_name

Line 241: hr_utility.set_location('prorate ratio is'||to_char(l_prorate_ratio),20);

237: , l_reallocation.period_set_name
238: , l_reallocation.budget_start_date
239: , l_reallocation.budget_end_date
240: );
241: hr_utility.set_location('prorate ratio is'||to_char(l_prorate_ratio),20);
242: if p_type in ('RCVD','DNTD') then
243: l_total_realloc := l_total_realloc + (nvl(l_reallocation.reallocation_amt,0) * l_prorate_ratio);
244: hr_utility.set_location('realoc amt is'||to_char(l_reallocation.reallocation_amt),20);
245: hr_utility.set_location('total realloc amt is'||to_char(l_total_realloc),20);

Line 244: hr_utility.set_location('realoc amt is'||to_char(l_reallocation.reallocation_amt),20);

240: );
241: hr_utility.set_location('prorate ratio is'||to_char(l_prorate_ratio),20);
242: if p_type in ('RCVD','DNTD') then
243: l_total_realloc := l_total_realloc + (nvl(l_reallocation.reallocation_amt,0) * l_prorate_ratio);
244: hr_utility.set_location('realoc amt is'||to_char(l_reallocation.reallocation_amt),20);
245: hr_utility.set_location('total realloc amt is'||to_char(l_total_realloc),20);
246: elsif p_type = 'RSRVD' then
247: l_total_reserve := l_total_reserve + (nvl(l_reallocation.reserved_amt,0) * l_prorate_ratio);
248: hr_utility.set_location('reserve amt is'||to_char(l_reallocation.reserved_amt),20);

Line 245: hr_utility.set_location('total realloc amt is'||to_char(l_total_realloc),20);

241: hr_utility.set_location('prorate ratio is'||to_char(l_prorate_ratio),20);
242: if p_type in ('RCVD','DNTD') then
243: l_total_realloc := l_total_realloc + (nvl(l_reallocation.reallocation_amt,0) * l_prorate_ratio);
244: hr_utility.set_location('realoc amt is'||to_char(l_reallocation.reallocation_amt),20);
245: hr_utility.set_location('total realloc amt is'||to_char(l_total_realloc),20);
246: elsif p_type = 'RSRVD' then
247: l_total_reserve := l_total_reserve + (nvl(l_reallocation.reserved_amt,0) * l_prorate_ratio);
248: hr_utility.set_location('reserve amt is'||to_char(l_reallocation.reserved_amt),20);
249: hr_utility.set_location('total reserve amt is'||to_char(l_total_reserve),20);

Line 248: hr_utility.set_location('reserve amt is'||to_char(l_reallocation.reserved_amt),20);

244: hr_utility.set_location('realoc amt is'||to_char(l_reallocation.reallocation_amt),20);
245: hr_utility.set_location('total realloc amt is'||to_char(l_total_realloc),20);
246: elsif p_type = 'RSRVD' then
247: l_total_reserve := l_total_reserve + (nvl(l_reallocation.reserved_amt,0) * l_prorate_ratio);
248: hr_utility.set_location('reserve amt is'||to_char(l_reallocation.reserved_amt),20);
249: hr_utility.set_location('total reserve amt is'||to_char(l_total_reserve),20);
250: end if;
251: end loop;
252:

Line 249: hr_utility.set_location('total reserve amt is'||to_char(l_total_reserve),20);

245: hr_utility.set_location('total realloc amt is'||to_char(l_total_realloc),20);
246: elsif p_type = 'RSRVD' then
247: l_total_reserve := l_total_reserve + (nvl(l_reallocation.reserved_amt,0) * l_prorate_ratio);
248: hr_utility.set_location('reserve amt is'||to_char(l_reallocation.reserved_amt),20);
249: hr_utility.set_location('total reserve amt is'||to_char(l_total_reserve),20);
250: end if;
251: end loop;
252:
253: if p_type in ('RCVD','DNTD') then