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_RTM_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_rtm_shd.api_updating
47: (p_role_template_id => p_role_template_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_role_template_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.template_id = p_template_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_rtm_shd.api_updating
119: (p_role_template_id => p_role_template_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_template_id;
151: --
152: -- ----------------------------------------------------------------------------

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

188: where a.transaction_category_id = p_transaction_category_id;
189: --
190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_rtm_shd.api_updating
195: (p_role_template_id => p_role_template_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_transaction_category_id;
226: --
227: -- ----------------------------------------------------------------------------

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

263: where a.role_id = p_role_id;
264: --
265: Begin
266: --
267: hr_utility.set_location('Entering:'||l_proc,5);
268: --
269: l_api_updating := pqh_rtm_shd.api_updating
270: (p_role_template_id => p_role_template_id,
271: p_object_version_number => p_object_version_number);

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

294: close c1;
295: --
296: end if;
297: --
298: hr_utility.set_location('Leaving:'||l_proc,10);
299: --
300: End chk_role_id;
301: --
302: -- ----------------------------------------------------------------------------

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

340: from pqh_roles
341: where role_id=p_role_id;
342: Begin
343: --
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: l_api_updating := pqh_rtm_shd.api_updating
347: (p_role_template_id => p_role_template_id,
348: p_object_version_number => p_object_version_number);

Line 365: hr_utility.set_message(8302,'PQH_ENABLE_LOOKUP_DOES_NOT_EXIST');

361: p_effective_date => p_effective_date) then
362: --
363: -- raise error as does not exist as lookup
364: --
365: hr_utility.set_message(8302,'PQH_ENABLE_LOOKUP_DOES_NOT_EXIST');
366: hr_utility.raise_error;
367: --
368: if p_enable_flag = 'Y' then
369: open c_role_enable_flag(p_role_id);

Line 366: hr_utility.raise_error;

362: --
363: -- raise error as does not exist as lookup
364: --
365: hr_utility.set_message(8302,'PQH_ENABLE_LOOKUP_DOES_NOT_EXIST');
366: hr_utility.raise_error;
367: --
368: if p_enable_flag = 'Y' then
369: open c_role_enable_flag(p_role_id);
370: fetch c_role_enable_flag into l_role_enable_flag;

Line 373: hr_utility.set_message(8302,'PQH_ROLE_DIS_CANT_ENABLE_RTM');

369: open c_role_enable_flag(p_role_id);
370: fetch c_role_enable_flag into l_role_enable_flag;
371: close c_role_enable_flag;
372: if nvl(l_role_enable_flag,'N') = 'N' then
373: hr_utility.set_message(8302,'PQH_ROLE_DIS_CANT_ENABLE_RTM');
374: hr_utility.raise_error;
375: end if;
376: end if;
377: end if;

Line 374: hr_utility.raise_error;

370: fetch c_role_enable_flag into l_role_enable_flag;
371: close c_role_enable_flag;
372: if nvl(l_role_enable_flag,'N') = 'N' then
373: hr_utility.set_message(8302,'PQH_ROLE_DIS_CANT_ENABLE_RTM');
374: hr_utility.raise_error;
375: end if;
376: end if;
377: end if;
378: --

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

377: end if;
378: --
379: end if;
380: --
381: hr_utility.set_location('Leaving:'||l_proc,10);
382: --
383: end chk_enable_flag;
384: --
385: --

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

408: and rct.transaction_category_id=ptc.transaction_category_id;
409: --
410: Begin
411: --
412: hr_utility.set_location('Entering:'||l_proc, 5);
413: --
414: for r_txn_cat in c_txn_cats(p_role_id)
415: loop
416: --

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

430: end if;
431: --
432: end loop;
433: --
434: hr_utility.set_location('Leaving:'||l_proc,10);
435: --
436: return 'N';
437: end chk_for_pending_txns;
438: --

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

478: and a.template_id = p_template_id;
479: --
480: Begin
481: --
482: hr_utility.set_location('Entering:'||l_proc,5);
483: --
484: l_api_updating := pqh_rtm_shd.api_updating
485: (p_role_template_id => p_role_template_id,
486: p_object_version_number => p_object_version_number);

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

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

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

551: l_dummy varchar2(1);
552: --
553: Begin
554: --
555: hr_utility.set_location('Entering:'||l_proc,5);
556: --
557: l_api_updating := pqh_rtm_shd.api_updating
558: (p_role_template_id => p_rec.role_template_id,
559: p_object_version_number => p_rec.object_version_number);

Line 562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

558: (p_role_template_id => p_rec.role_template_id,
559: p_object_version_number => p_rec.object_version_number);
560: --
561: if (not l_api_updating ) then
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message('PROCEDURE', l_proc);
564: hr_utility.set_message('STEP', '10');
565: end if;
566: --

Line 563: hr_utility.set_message('PROCEDURE', l_proc);

559: p_object_version_number => p_rec.object_version_number);
560: --
561: if (not l_api_updating ) then
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message('PROCEDURE', l_proc);
564: hr_utility.set_message('STEP', '10');
565: end if;
566: --
567: hr_utility.set_location('Leaving:'||l_proc,20);

Line 564: hr_utility.set_message('STEP', '10');

560: --
561: if (not l_api_updating ) then
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message('PROCEDURE', l_proc);
564: hr_utility.set_message('STEP', '10');
565: end if;
566: --
567: hr_utility.set_location('Leaving:'||l_proc,20);
568:

Line 567: hr_utility.set_location('Leaving:'||l_proc,20);

563: hr_utility.set_message('PROCEDURE', l_proc);
564: hr_utility.set_message('STEP', '10');
565: end if;
566: --
567: hr_utility.set_location('Leaving:'||l_proc,20);
568:
569: if nvl(p_rec.transaction_category_id,hr_api.g_number) <>
570: nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number) then
571: l_argument := 'transaction_category_id';

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

570: nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number) then
571: l_argument := 'transaction_category_id';
572: raise l_error;
573: end if;
574: hr_utility.set_location(l_proc,30);
575: exception
576: when l_error then
577: hr_api.argument_changed_error
578: (p_api_name => l_proc

Line 583: hr_utility.set_location(' Leaving:'||l_proc,50);

579: ,p_argument => l_argument
580: );
581: when others then
582: raise;
583: hr_utility.set_location(' Leaving:'||l_proc,50);
584: --
585: End chk_non_updateable_args;
586: --
587: --

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

593: --
594: l_proc varchar2(72) := g_package||'insert_validate';
595: --
596: Begin
597: hr_utility.set_location('Entering:'||l_proc, 5);
598: --
599: -- Call all supporting business operations
600: --
601: chk_role_template_id

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

631: p_object_version_number => p_rec.object_version_number);
632: --
633: --
634: --
635: hr_utility.set_location(' Leaving:'||l_proc, 10);
636: End insert_validate;
637: --
638: -- ----------------------------------------------------------------------------
639: -- |---------------------------< update_validate >----------------------------|

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

643: --
644: l_proc varchar2(72) := g_package||'update_validate';
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: -- Call all supporting business operations
650: --
651: chk_non_updateable_args(p_rec);

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

682: p_effective_date => p_effective_date,
683: p_object_version_number => p_rec.object_version_number);
684: --
685: --
686: hr_utility.set_location(' Leaving:'||l_proc, 10);
687: End update_validate;
688: --
689: -- ----------------------------------------------------------------------------
690: -- |---------------------------< delete_validate >----------------------------|

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

694: --
695: l_proc varchar2(72) := g_package||'delete_validate';
696: --
697: Begin
698: hr_utility.set_location('Entering:'||l_proc, 5);
699: --
700: -- Call all supporting business operations
701: --
702: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

698: hr_utility.set_location('Entering:'||l_proc, 5);
699: --
700: -- Call all supporting business operations
701: --
702: hr_utility.set_location(' Leaving:'||l_proc, 10);
703: End delete_validate;
704: --
705: end pqh_rtm_bus;