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

Line 44: hr_utility.set_location('Entering:'||l_proc, 5);

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_dfs_shd.api_updating
47: (p_dflt_fund_src_id => p_dflt_fund_src_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_dflt_fund_src_id;
75: --
76: -- ----------------------------------------------------------------------------

Line 116: hr_utility.set_location('Entering:'||l_proc,5);

112: where a.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_dfs_shd.api_updating
119: (p_dflt_fund_src_id => p_dflt_fund_src_id,
120: p_object_version_number => p_object_version_number);

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

144: close c1;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: End chk_cost_allocation_keyflex_id;
151: --
152: -- ----------------------------------------------------------------------------

Line 192: hr_utility.set_location('Entering:'||l_proc,5);

188: where a.dflt_budget_element_id = p_dflt_budget_element_id;
189: --
190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_dfs_shd.api_updating
195: (p_dflt_fund_src_id => p_dflt_fund_src_id,
196: p_object_version_number => p_object_version_number);

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

219: close c1;
220: --
221: end if;
222: --
223: hr_utility.set_location('Leaving:'||l_proc,10);
224: --
225: End chk_dflt_budget_element_id;
226: --
227: -- ----------------------------------------------------------------------------

Line 258: hr_utility.set_location('Entering:'||l_proc, 5);

254: ;
255:
256: Begin
257: --
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: open csr_src;
261: fetch csr_src into l_dummy;
262: close csr_src;

Line 266: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_SRCS');

262: close csr_src;
263:
264: if nvl(l_dummy ,'Y') = 'X' then
265: --
266: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_SRCS');
267: hr_utility.raise_error;
268: --
269: end if;
270: if p_cost_allocation_keyflex_id is not null then

Line 267: hr_utility.raise_error;

263:
264: if nvl(l_dummy ,'Y') = 'X' then
265: --
266: hr_utility.set_message(8302,'PQH_DUPLICATE_BUDGET_SRCS');
267: hr_utility.raise_error;
268: --
269: end if;
270: if p_cost_allocation_keyflex_id is not null then
271: if p_project_id is not null

Line 276: hr_utility.set_message(8302,'PQH_BUDGET_SRC_GL_GMS');

272: or p_award_id is not null
273: or p_task_id is not null
274: or p_expenditure_type is not null
275: or p_organization_id is not null then
276: hr_utility.set_message(8302,'PQH_BUDGET_SRC_GL_GMS');
277: hr_utility.raise_error;
278: end if;
279: else
280: if p_project_id is null

Line 277: hr_utility.raise_error;

273: or p_task_id is not null
274: or p_expenditure_type is not null
275: or p_organization_id is not null then
276: hr_utility.set_message(8302,'PQH_BUDGET_SRC_GL_GMS');
277: hr_utility.raise_error;
278: end if;
279: else
280: if p_project_id is null
281: or p_award_id is null

Line 285: hr_utility.set_message(8302,'PQH_BUDGET_SRC_MANDATORY');

281: or p_award_id is null
282: or p_task_id is null
283: or p_expenditure_type is null
284: or p_organization_id is null then
285: hr_utility.set_message(8302,'PQH_BUDGET_SRC_MANDATORY');
286: hr_utility.raise_error;
287: end if;
288: end if;
289: --

Line 286: hr_utility.raise_error;

282: or p_task_id is null
283: or p_expenditure_type is null
284: or p_organization_id is null then
285: hr_utility.set_message(8302,'PQH_BUDGET_SRC_MANDATORY');
286: hr_utility.raise_error;
287: end if;
288: end if;
289: --
290: hr_utility.set_location('Leaving:'||l_proc,10);

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

286: hr_utility.raise_error;
287: end if;
288: end if;
289: --
290: hr_utility.set_location('Leaving:'||l_proc,10);
291: --
292: end chk_duplicate_src;
293: --
294: -- ----------------------------------------------------------------------------

Line 311: hr_utility.set_location('Entering:'||l_proc, 5);

307: where dflt_budget_element_id = p_dflt_budget_element_id;
308:
309: Begin
310: --
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: open csr_element;
314: fetch csr_element into l_sum;
315: close csr_element;

Line 320: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM');

316:
317: if l_sum > 100 then
318: -- sum cannot be more then 100
319: --
320: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM');
321: hr_utility.raise_error;
322: --
323: end if;
324:

Line 321: hr_utility.raise_error;

317: if l_sum > 100 then
318: -- sum cannot be more then 100
319: --
320: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM');
321: hr_utility.raise_error;
322: --
323: end if;
324:
325: --

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

322: --
323: end if;
324:
325: --
326: hr_utility.set_location('Leaving:'||l_proc,10);
327: --
328: end chk_sum;
329: --
330: -- ----------------------------------------------------------------------------

Line 340: hr_utility.set_location('Entering:'||l_proc, 5);

336: --
337:
338: Begin
339: --
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: --
342: if NVL(p_dflt_dist_percentage,0) < 0 then
343: -- percentage cannot be less then zero
344: --

Line 345: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRC_PERCENT');

341: --
342: if NVL(p_dflt_dist_percentage,0) < 0 then
343: -- percentage cannot be less then zero
344: --
345: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRC_PERCENT');
346: hr_utility.raise_error;
347: --
348: end if;
349:

Line 346: hr_utility.raise_error;

342: if NVL(p_dflt_dist_percentage,0) < 0 then
343: -- percentage cannot be less then zero
344: --
345: hr_utility.set_message(8302,'PQH_WKS_INVALID_SRC_PERCENT');
346: hr_utility.raise_error;
347: --
348: end if;
349:
350: --

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

347: --
348: end if;
349:
350: --
351: hr_utility.set_location('Leaving:'||l_proc,10);
352: --
353: end chk_percentage;
354: --
355: -- ----------------------------------------------------------------------------

Line 363: hr_utility.set_location('Entering:'||l_proc, 5);

359: --
360: l_proc varchar2(72) := g_package||'insert_validate';
361: --
362: Begin
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: -- Call all supporting business operations
366: --
367: chk_dflt_fund_src_id

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

391: --
392: chk_percentage
393: (p_dflt_dist_percentage => p_rec.dflt_dist_percentage );
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: End insert_validate;
397: --
398: -- ----------------------------------------------------------------------------
399: -- |---------------------------< update_validate >----------------------------|

Line 406: hr_utility.set_location('Entering:'||l_proc, 5);

402: --
403: l_proc varchar2(72) := g_package||'update_validate';
404: --
405: Begin
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: -- Call all supporting business operations
409: --
410: chk_dflt_fund_src_id

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

436: (p_dflt_dist_percentage => p_rec.dflt_dist_percentage );
437: --
438: --
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: End update_validate;
442: --
443: -- ----------------------------------------------------------------------------
444: -- |---------------------------< delete_validate >----------------------------|

Line 451: hr_utility.set_location('Entering:'||l_proc, 5);

447: --
448: l_proc varchar2(72) := g_package||'delete_validate';
449: --
450: Begin
451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- Call all supporting business operations
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- Call all supporting business operations
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 10);
456: End delete_validate;
457: --
458: end pqh_dfs_bus;