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_RLM_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_rlm_shd.api_updating
47: (p_routing_list_member_id => p_routing_list_member_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_routing_list_member_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.routing_list_id = p_routing_list_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_rlm_shd.api_updating
119: (p_routing_list_member_id => p_routing_list_member_id,
120: p_object_version_number => p_object_version_number);

Line 139: hr_utility.set_message(8302, 'PQH_INVALID_ROUTING_LIST');

135: --
136: -- raise error as FK does not relate to PK in pqh_routing_lists
137: -- table.
138: --
139: hr_utility.set_message(8302, 'PQH_INVALID_ROUTING_LIST');
140: hr_utility.raise_error;
141:
142: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK2');
143: --

Line 140: hr_utility.raise_error;

136: -- raise error as FK does not relate to PK in pqh_routing_lists
137: -- table.
138: --
139: hr_utility.set_message(8302, 'PQH_INVALID_ROUTING_LIST');
140: hr_utility.raise_error;
141:
142: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK2');
143: --
144: end if;

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

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

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

196: where user_id = nvl(p_user_id, -1)
197: and role_id = p_role_id;
198: Begin
199: --
200: hr_utility.set_location('Entering:'||l_proc,5);
201: --
202: l_api_updating := pqh_rlm_shd.api_updating
203: (p_routing_list_member_id => p_routing_list_member_id,
204: p_object_version_number => p_object_version_number);

Line 227: hr_utility.set_message(8302,'PQH_INVALID_ROLE');

223: --
224: -- raise error as FK does not relate to PK in pqh_roles
225: -- table.
226: --
227: hr_utility.set_message(8302,'PQH_INVALID_ROLE');
228: hr_utility.raise_error;
229: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');
230: --
231: end if;

Line 228: hr_utility.raise_error;

224: -- raise error as FK does not relate to PK in pqh_roles
225: -- table.
226: --
227: hr_utility.set_message(8302,'PQH_INVALID_ROLE');
228: hr_utility.raise_error;
229: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');
230: --
231: end if;
232: --

Line 249: hr_utility.set_message(8302,'PQH_USER_NOT_OF_CUR_ROLE');

245: --
246: -- raise error as user_id is not assigned to role
247: -- table.
248: --
249: hr_utility.set_message(8302,'PQH_USER_NOT_OF_CUR_ROLE');
250: hr_utility.raise_error;
251: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');
252: --
253: end if;

Line 250: hr_utility.raise_error;

246: -- raise error as user_id is not assigned to role
247: -- table.
248: --
249: hr_utility.set_message(8302,'PQH_USER_NOT_OF_CUR_ROLE');
250: hr_utility.raise_error;
251: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');
252: --
253: end if;
254: --

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

256: end if;
257: --
258: end if;
259: --
260: hr_utility.set_location('Leaving:'||l_proc,10);
261: --
262: End chk_role_user_id;
263: --
264: -- ----------------------------------------------------------------------------

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

304: and nvl(a.user_id,-1) = nvl(p_user_id, -1);
305: --
306: Begin
307: --
308: hr_utility.set_location('Entering:'||l_proc,5);
309: --
310: l_api_updating := pqh_rlm_shd.api_updating
311: (p_routing_list_member_id => p_routing_list_member_id,
312: p_object_version_number => p_object_version_number);

Line 336: hr_utility.set_message(8302,'PQH_DUP_RLM_NOT_ALLOWED');

332: --
333: -- raise error as UK failed
334: -- table.
335: --
336: hr_utility.set_message(8302,'PQH_DUP_RLM_NOT_ALLOWED');
337: hr_utility.raise_error;
338: -- pqh_rtm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_UK1');
339: --
340: end if;

Line 337: hr_utility.raise_error;

333: -- raise error as UK failed
334: -- table.
335: --
336: hr_utility.set_message(8302,'PQH_DUP_RLM_NOT_ALLOWED');
337: hr_utility.raise_error;
338: -- pqh_rtm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_UK1');
339: --
340: end if;
341: --

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

342: close c1;
343: --
344: end if;
345: --
346: hr_utility.set_location('Leaving:'||l_proc,10);
347: --
348: End chk_rlist_role_user_uk1;
349: --
350: -- ----------------------------------------------------------------------------

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

385: and a.seq_no = p_seq_no;
386: --
387: Begin
388: --
389: hr_utility.set_location('Entering:'||l_proc,5);
390: --
391: l_api_updating := pqh_rlm_shd.api_updating
392: (p_routing_list_member_id => p_routing_list_member_id,
393: p_object_version_number => p_object_version_number);

Line 414: hr_utility.set_message(8302,'PQH_DUP_RLM_SEQ_NOT_ALLOWED');

410: --
411: -- raise error as UK failed
412: -- table.
413: --
414: hr_utility.set_message(8302,'PQH_DUP_RLM_SEQ_NOT_ALLOWED');
415: hr_utility.raise_error;
416: --
417: end if;
418: --

Line 415: hr_utility.raise_error;

411: -- raise error as UK failed
412: -- table.
413: --
414: hr_utility.set_message(8302,'PQH_DUP_RLM_SEQ_NOT_ALLOWED');
415: hr_utility.raise_error;
416: --
417: end if;
418: --
419: close c1;

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

419: close c1;
420: --
421: end if;
422: --
423: hr_utility.set_location('Leaving:'||l_proc,10);
424: --
425: End chk_rlist_seq_uk2;
426: --
427: --

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

460: l_api_updating boolean;
461: --
462: Begin
463: --
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: l_api_updating := pqh_rlm_shd.api_updating
467: (p_routing_list_member_id => p_routing_list_member_id,
468: p_object_version_number => p_object_version_number);

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

481: p_effective_date => p_effective_date) then
482: --
483: -- raise error as does not exist as lookup
484: --
485: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
486: hr_utility.raise_error;
487: --
488: end if;
489: --

Line 486: hr_utility.raise_error;

482: --
483: -- raise error as does not exist as lookup
484: --
485: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
486: hr_utility.raise_error;
487: --
488: end if;
489: --
490: end if;

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

488: end if;
489: --
490: end if;
491: --
492: hr_utility.set_location('Leaving:'||l_proc,10);
493: --
494: end chk_approver_flag;
495: --
496: --

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

552: and user_id = p_user_id;
553: --
554: Begin
555: --
556: hr_utility.set_location('Entering:'||l_proc, 5);
557: --
558: l_api_updating := pqh_rlm_shd.api_updating
559: (p_routing_list_member_id => p_routing_list_member_id,
560: p_object_version_number => p_object_version_number);

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

573: p_effective_date => p_effective_date) then
574: --
575: -- raise error as does not exist as lookup
576: --
577: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
578: hr_utility.raise_error;
579: --
580: end if;
581: --

Line 578: hr_utility.raise_error;

574: --
575: -- raise error as does not exist as lookup
576: --
577: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
578: hr_utility.raise_error;
579: --
580: end if;
581: --
582: if p_enable_flag = 'Y' then

Line 589: hr_utility.set_message(8302,'PQH_CANT_ENABLE_RLM_RL_DIS');

585: fetch c_routing_list_enable_flag into l_routing_list_enable_flag;
586: close c_routing_list_enable_flag;
587: --
588: if nvl(l_routing_list_enable_flag,'N') ='N' then
589: hr_utility.set_message(8302,'PQH_CANT_ENABLE_RLM_RL_DIS');
590: hr_utility.raise_error;
591: end if;
592: --
593: --

Line 590: hr_utility.raise_error;

586: close c_routing_list_enable_flag;
587: --
588: if nvl(l_routing_list_enable_flag,'N') ='N' then
589: hr_utility.set_message(8302,'PQH_CANT_ENABLE_RLM_RL_DIS');
590: hr_utility.raise_error;
591: end if;
592: --
593: --
594: open c_role_enable_flag(p_role_id);

Line 599: hr_utility.set_message(8302,'PQH_CANT_ENABLE_RLM_RLS_DIS');

595: fetch c_role_enable_flag into l_role_enable_flag;
596: close c_role_enable_flag;
597: --
598: if nvl(l_role_enable_flag,'N') = 'N' then
599: hr_utility.set_message(8302,'PQH_CANT_ENABLE_RLM_RLS_DIS');
600: hr_utility.raise_error;
601: end if;
602: --
603: --

Line 600: hr_utility.raise_error;

596: close c_role_enable_flag;
597: --
598: if nvl(l_role_enable_flag,'N') = 'N' then
599: hr_utility.set_message(8302,'PQH_CANT_ENABLE_RLM_RLS_DIS');
600: hr_utility.raise_error;
601: end if;
602: --
603: --
604: if p_user_id is not null then

Line 610: hr_utility.set_message(8302,'PQH_CANT_ENBL_RLM_RLSUSR_DIS');

606: fetch c_role_user_enable_flag into l_dummy;
607: --
608: if c_role_user_enable_flag%notfound then
609: close c_role_user_enable_flag;
610: hr_utility.set_message(8302,'PQH_CANT_ENBL_RLM_RLSUSR_DIS');
611: hr_utility.raise_error;
612: else
613: close c_role_user_enable_flag;
614: end if;

Line 611: hr_utility.raise_error;

607: --
608: if c_role_user_enable_flag%notfound then
609: close c_role_user_enable_flag;
610: hr_utility.set_message(8302,'PQH_CANT_ENBL_RLM_RLSUSR_DIS');
611: hr_utility.raise_error;
612: else
613: close c_role_user_enable_flag;
614: end if;
615: --

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

618: end if;
619: --
620: end if;
621: --
622: hr_utility.set_location('Leaving:'||l_proc,10);
623: --
624: end chk_enable_flag;
625: --
626: -- ----------------------------------------------------------------------------

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

663: and rct.transaction_category_id = ptc.transaction_category_id;
664: --
665: Begin
666: --
667: hr_utility.set_location('Entering:'||l_proc, 5);
668: --
669: for r_txn_cat in c_txn_cats(p_routing_list_id)
670: loop
671: --

Line 674: hr_utility.set_message(8302,'PQH_CANT_DEL_RLM_PNDG_TXN');

670: loop
671: --
672: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')
673: = 'Y' then
674: hr_utility.set_message(8302,'PQH_CANT_DEL_RLM_PNDG_TXN');
675: hr_utility.set_message_token('TRANSACTION_CATEGORY', r_txn_cat.transaction_category_name);
676: if (r_txn_cat.business_group_id is not null) then
677: l_bus_grp_name := hr_general.DECODE_ORGANIZATION(r_txn_cat.business_group_id);
678: else

Line 675: hr_utility.set_message_token('TRANSACTION_CATEGORY', r_txn_cat.transaction_category_name);

671: --
672: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')
673: = 'Y' then
674: hr_utility.set_message(8302,'PQH_CANT_DEL_RLM_PNDG_TXN');
675: hr_utility.set_message_token('TRANSACTION_CATEGORY', r_txn_cat.transaction_category_name);
676: if (r_txn_cat.business_group_id is not null) then
677: l_bus_grp_name := hr_general.DECODE_ORGANIZATION(r_txn_cat.business_group_id);
678: else
679: l_bus_grp_name := hr_general.decode_lookup('PQH_TCT_SCOPE', 'GLOBAL');

Line 682: hr_utility.set_message_token('BUSINESS_GROUP', l_bus_grp_name);

678: else
679: l_bus_grp_name := hr_general.decode_lookup('PQH_TCT_SCOPE', 'GLOBAL');
680: end if;
681:
682: hr_utility.set_message_token('BUSINESS_GROUP', l_bus_grp_name);
683: hr_utility.raise_error;
684: end if;
685: --
686: end loop;

Line 683: hr_utility.raise_error;

679: l_bus_grp_name := hr_general.decode_lookup('PQH_TCT_SCOPE', 'GLOBAL');
680: end if;
681:
682: hr_utility.set_message_token('BUSINESS_GROUP', l_bus_grp_name);
683: hr_utility.raise_error;
684: end if;
685: --
686: end loop;
687: --

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

684: end if;
685: --
686: end loop;
687: --
688: hr_utility.set_location('Leaving:'||l_proc,10);
689: --
690: end chk_for_pending_txns;
691: --
692: function chk_txn_cat_freeze_status(p_transaction_category_id in number) return varchar2 is

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

720:
721: --
722: Begin
723: --
724: hr_utility.set_location('Entering:'||l_proc, 5);
725: --
726: for r_txn_cat in c_txn_cats(p_routing_list_member_id)
727: loop
728: --

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

729: return chk_txn_cat_freeze_status(r_txn_cat.transaction_category_id);
730: --
731: end loop;
732: --
733: hr_utility.set_location('Leaving:'||l_proc,10);
734: --
735: end chk_rlm_txn_cat_frozen;
736: --
737: -- ----------------------------------------------------------------------------

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

742: --
743: l_proc varchar2(72) := g_package||'insert_validate';
744: --
745: Begin
746: hr_utility.set_location('Entering:'||l_proc, 5);
747: --
748: -- Call all supporting business operations
749: --
750: chk_routing_list_member_id

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

790: p_seq_no => p_rec.seq_no,
791: p_object_version_number => p_rec.object_version_number);
792: --
793: --
794: hr_utility.set_location(' Leaving:'||l_proc, 10);
795: End insert_validate;
796: --
797: -- ----------------------------------------------------------------------------
798: -- |---------------------------< update_validate >----------------------------|

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

802: --
803: l_proc varchar2(72) := g_package||'update_validate';
804: --
805: Begin
806: hr_utility.set_location('Entering:'||l_proc, 5);
807: --
808: -- Call all supporting business operations
809: --
810: --

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

851: p_routing_list_id => p_rec.routing_list_id,
852: p_seq_no => p_rec.seq_no,
853: p_object_version_number => p_rec.object_version_number);
854: --
855: hr_utility.set_location(' Leaving:'||l_proc, 10);
856: End update_validate;
857: --
858: -- ----------------------------------------------------------------------------
859: -- |---------------------------< delete_validate >----------------------------|

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

863: --
864: l_proc varchar2(72) := g_package||'delete_validate';
865: --
866: Begin
867: hr_utility.set_location('Entering:'||l_proc, 5);
868: --
869: -- Call all supporting business operations
870: --
871: chk_for_pending_txns(p_routing_list_member_id => p_rec.routing_list_member_id,

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

870: --
871: chk_for_pending_txns(p_routing_list_member_id => p_rec.routing_list_member_id,
872: p_routing_list_id => p_rec.routing_list_id,
873: p_object_version_number => p_rec.object_version_number);
874: hr_utility.set_location(' Leaving:'||l_proc, 10);
875: End delete_validate;
876: --
877: end pqh_rlm_bus;