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_WKS_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_wks_shd.api_updating
47: (p_worksheet_id => p_worksheet_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_worksheet_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.budget_version_id = p_budget_version_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_wks_shd.api_updating
119: (p_worksheet_id => p_worksheet_id,
120: p_object_version_number => p_object_version_number);

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

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

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

187: where a.budget_id = p_budget_id;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := pqh_wks_shd.api_updating
194: (p_worksheet_id => p_worksheet_id,
195: p_object_version_number => p_object_version_number);

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

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

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

258: l_api_updating boolean;
259: --
260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: l_api_updating := pqh_wks_shd.api_updating
265: (p_worksheet_id => p_worksheet_id,
266: p_object_version_number => p_object_version_number);

Line 283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

279: p_effective_date => p_effective_date) then
280: --
281: -- raise error as does not exist as lookup
282: --
283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
284: hr_utility.raise_error;
285: --
286: end if;
287: --

Line 284: hr_utility.raise_error;

280: --
281: -- raise error as does not exist as lookup
282: --
283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
284: hr_utility.raise_error;
285: --
286: end if;
287: --
288: end if;

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

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

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

326: l_api_updating boolean;
327: --
328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := pqh_wks_shd.api_updating
333: (p_worksheet_id => p_worksheet_id,
334: p_object_version_number => p_object_version_number);

Line 351: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

347: p_effective_date => p_effective_date) then
348: --
349: -- raise error as does not exist as lookup
350: --
351: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
352: hr_utility.raise_error;
353: --
354: end if;
355: --

Line 352: hr_utility.raise_error;

348: --
349: -- raise error as does not exist as lookup
350: --
351: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
352: hr_utility.raise_error;
353: --
354: end if;
355: --
356: end if;

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

354: end if;
355: --
356: end if;
357: --
358: hr_utility.set_location('Leaving:'||l_proc,10);
359: --
360: end chk_transaction_status;
361: --
362: -- ----------------------------------------------------------------------------

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

394: l_api_updating boolean;
395: --
396: Begin
397: --
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: l_api_updating := pqh_wks_shd.api_updating
401: (p_worksheet_id => p_worksheet_id,
402: p_object_version_number => p_object_version_number);

Line 419: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

415: p_effective_date => p_effective_date) then
416: --
417: -- raise error as does not exist as lookup
418: --
419: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
420: hr_utility.raise_error;
421: --
422: end if;
423: --

Line 420: hr_utility.raise_error;

416: --
417: -- raise error as does not exist as lookup
418: --
419: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
420: hr_utility.raise_error;
421: --
422: end if;
423: --
424: end if;

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

422: end if;
423: --
424: end if;
425: --
426: hr_utility.set_location('Leaving:'||l_proc,10);
427: --
428: end chk_propagation_method;
429: --
430: -- ----------------------------------------------------------------------------

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

470: where a.budget_id = p_budget_id
471: AND a.version_number = p_version_number;
472: Begin
473: --
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: l_api_updating := pqh_wks_shd.api_updating
477: (p_worksheet_id => p_worksheet_id,
478: p_object_version_number => p_object_version_number);

Line 492: hr_utility.set_message(8302,'PQH_NO_BDGT_ID_FOR_VERSION_NO');

488: If p_budget_id IS NULL then
489: --
490: -- There can be no version number without budget id
491: --
492: hr_utility.set_message(8302,'PQH_NO_BDGT_ID_FOR_VERSION_NO');
493: hr_utility.raise_error;
494: Else
495: --
496: -- Check if the version exists for the budget id.

Line 493: hr_utility.raise_error;

489: --
490: -- There can be no version number without budget id
491: --
492: hr_utility.set_message(8302,'PQH_NO_BDGT_ID_FOR_VERSION_NO');
493: hr_utility.raise_error;
494: Else
495: --
496: -- Check if the version exists for the budget id.
497: --

Line 505: hr_utility.set_message(8302,'PQH_INVALID_VERSION_FOR_BDGT');

501: --
502: If c1%notfound then
503: --
504: Close c1;
505: hr_utility.set_message(8302,'PQH_INVALID_VERSION_FOR_BDGT');
506: hr_utility.raise_error;
507: --
508: End if;
509: --

Line 506: hr_utility.raise_error;

502: If c1%notfound then
503: --
504: Close c1;
505: hr_utility.set_message(8302,'PQH_INVALID_VERSION_FOR_BDGT');
506: hr_utility.raise_error;
507: --
508: End if;
509: --
510: Close c1;

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

512: End if;
513: --
514: end if;
515: --
516: hr_utility.set_location('Leaving:'||l_proc,10);
517: --
518: end chk_version_number;
519: --
520: -- ----------------------------------------------------------------------------

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

553: l_api_updating boolean;
554: --
555: Begin
556: --
557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: If nvl(p_date_to,to_date('31/12/4712','dd/mm/RRRR')) <
560: nvl(p_date_from,to_date('31/12/4712','dd/mm/RRRR')) then
561: --

Line 562: hr_utility.set_message(8302,'PQH_TO_DT_LESS_THAN_FROM_DT');

558: --
559: If nvl(p_date_to,to_date('31/12/4712','dd/mm/RRRR')) <
560: nvl(p_date_from,to_date('31/12/4712','dd/mm/RRRR')) then
561: --
562: hr_utility.set_message(8302,'PQH_TO_DT_LESS_THAN_FROM_DT');
563: hr_utility.raise_error;
564: end if;
565: --
566: hr_utility.set_location('Leaving:'||l_proc,10);

Line 563: hr_utility.raise_error;

559: If nvl(p_date_to,to_date('31/12/4712','dd/mm/RRRR')) <
560: nvl(p_date_from,to_date('31/12/4712','dd/mm/RRRR')) then
561: --
562: hr_utility.set_message(8302,'PQH_TO_DT_LESS_THAN_FROM_DT');
563: hr_utility.raise_error;
564: end if;
565: --
566: hr_utility.set_location('Leaving:'||l_proc,10);
567: --

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

562: hr_utility.set_message(8302,'PQH_TO_DT_LESS_THAN_FROM_DT');
563: hr_utility.raise_error;
564: end if;
565: --
566: hr_utility.set_location('Leaving:'||l_proc,10);
567: --
568: end chk_dates;
569: --
570: -- ----------------------------------------------------------------------------

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

575: --
576: l_proc varchar2(72) := g_package||'insert_validate';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: -- Call all supporting business operations
582: --
583: chk_worksheet_id

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

626: p_effective_date => p_effective_date,
627: p_object_version_number => p_rec.object_version_number);
628: --
629: --
630: hr_utility.set_location(' Leaving:'||l_proc, 10);
631: End insert_validate;
632: --
633: -- ----------------------------------------------------------------------------
634: -- |---------------------------< update_validate >----------------------------|

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

638: --
639: l_proc varchar2(72) := g_package||'update_validate';
640: --
641: Begin
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: --
644: -- Call all supporting business operations
645: --
646: chk_worksheet_id

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

691: p_object_version_number => p_rec.object_version_number);
692: --
693: --
694: --
695: hr_utility.set_location(' Leaving:'||l_proc, 10);
696: End update_validate;
697: --
698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< delete_validate >----------------------------|

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

703: --
704: l_proc varchar2(72) := g_package||'delete_validate';
705: --
706: Begin
707: hr_utility.set_location('Entering:'||l_proc, 5);
708: --
709: -- Call all supporting business operations
710: --
711: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

707: hr_utility.set_location('Entering:'||l_proc, 5);
708: --
709: -- Call all supporting business operations
710: --
711: hr_utility.set_location(' Leaving:'||l_proc, 10);
712: End delete_validate;
713: --
714: end pqh_wks_bus;