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

Line 59: hr_utility.set_message(8302,'PQH_SSHR_BOTH_EDIT_PRFL_ERR');

55: -- message('Dummy ' ||dummy);pause;
56: if dummy = 'Y' then -- other record is found
57: -- throw message
58:
59: hr_utility.set_message(8302,'PQH_SSHR_BOTH_EDIT_PRFL_ERR');
60: hr_utility.raise_error;
61:
62: end if;
63: end if;

Line 60: hr_utility.raise_error;

56: if dummy = 'Y' then -- other record is found
57: -- throw message
58:
59: hr_utility.set_message(8302,'PQH_SSHR_BOTH_EDIT_PRFL_ERR');
60: hr_utility.raise_error;
61:
62: end if;
63: end if;
64: end;

Line 91: hr_utility.set_location('Entering:'|| l_proc,10);

87: l_proc varchar2(72) := g_package||'set_security_group_id';
88: --
89: begin
90: --
91: hr_utility.set_location('Entering:'|| l_proc,10);
92: --
93: -- Ensure that all the mandatory parameter are not null
94: --
95: hr_api.mandatory_arg_error

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

118: hr_api.set_security_group_id
119: (p_security_group_id => l_security_group_id
120: );
121: --
122: hr_utility.set_location(' Leaving:'|| l_proc,20);
123: --
124: end set_security_group_id;
125: --
126: -- ---------------------------------------------------------------------------

Line 152: hr_utility.set_location('Entering:'|| l_proc,10);

148: l_proc varchar2(72) := g_package||'return_legislation_code';
149: --
150: Begin
151: --
152: hr_utility.set_location('Entering:'|| l_proc,10);
153: --
154: -- Ensure that all the mandatory parameter are not null
155: --
156: hr_api.mandatory_arg_error

Line 170: hr_utility.set_location(l_proc,20);

166: -- call to this function. Just return the value in the global
167: -- variable.
168: --
169: l_legislation_code := pqh_rls_bus.g_legislation_code;
170: hr_utility.set_location(l_proc,20);
171: else
172: --
173: -- The ID is different to the last call to this function
174: -- or this is the first call to this function.

Line 187: hr_utility.set_location(l_proc,0);

183: close csr_leg_code;
184: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
185: fnd_message.raise_error;
186: end if;
187: hr_utility.set_location(l_proc,0);
188: --
189: -- Set the global variables so the values are
190: -- available for the next call to this function.
191: --

Line 196: hr_utility.set_location(' Leaving:'|| l_proc,40);

192: close csr_leg_code;
193: pqh_rls_bus.g_role_id := p_role_id;
194: pqh_rls_bus.g_legislation_code := l_legislation_code;
195: end if;
196: hr_utility.set_location(' Leaving:'|| l_proc,40);
197: return l_legislation_code;
198: end return_legislation_code;
199: --
200: -- ----------------------------------------------------------------------------

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

296: l_api_updating boolean;
297: --
298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc,5);
301: --
302: l_api_updating := pqh_rls_shd.api_updating
303: (p_role_id => p_role_id,
304: p_object_version_number => p_object_version_number);

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

324: end if;
325: --
326: end if;
327: --
328: hr_utility.set_location('Leaving:'||l_proc,10);
329: --
330: End chk_role_id;
331: --
332: -- ----------------------------------------------------------------------------

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

377: l_posn_count NUMBER(15) := 0;
378: l_role_name pqh_roles.role_name%TYPE;
379: Begin
380: --
381: hr_utility.set_location('Entering:'||l_proc,5);
382: --
383: l_api_updating := pqh_rls_shd.api_updating
384: (p_role_id => p_role_id,
385: p_object_version_number => p_object_version_number);

Line 402: hr_utility.set_message(8302,'PQH_INVALID_ENABLE_FLAG');

398: p_effective_date => p_effective_date) then
399: --
400: -- raise error as does not exist as lookup
401: --
402: hr_utility.set_message(8302,'PQH_INVALID_ENABLE_FLAG');
403: hr_utility.raise_error;
404: --
405: end if;
406: /*

Line 403: hr_utility.raise_error;

399: --
400: -- raise error as does not exist as lookup
401: --
402: hr_utility.set_message(8302,'PQH_INVALID_ENABLE_FLAG');
403: hr_utility.raise_error;
404: --
405: end if;
406: /*
407: --

Line 428: hr_utility.set_message(8302,'PQH_ROLE_ENABLE_FLAG');

424:
425: --
426: -- raise error as posn attached to the role
427: --
428: hr_utility.set_message(8302,'PQH_ROLE_ENABLE_FLAG');
429: hr_utility.set_message_token('ROLENAME',p_role_name);
430: hr_utility.raise_error;
431: --
432: end if; -- for posn > 0

Line 429: hr_utility.set_message_token('ROLENAME',p_role_name);

425: --
426: -- raise error as posn attached to the role
427: --
428: hr_utility.set_message(8302,'PQH_ROLE_ENABLE_FLAG');
429: hr_utility.set_message_token('ROLENAME',p_role_name);
430: hr_utility.raise_error;
431: --
432: end if; -- for posn > 0
433:

Line 430: hr_utility.raise_error;

426: -- raise error as posn attached to the role
427: --
428: hr_utility.set_message(8302,'PQH_ROLE_ENABLE_FLAG');
429: hr_utility.set_message_token('ROLENAME',p_role_name);
430: hr_utility.raise_error;
431: --
432: end if; -- for posn > 0
433:
434: end if; -- role is disabled

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

436: */
437:
438: end if;
439: --
440: hr_utility.set_location('Leaving:'||l_proc,0);
441: --
442: end chk_enable_flag;
443: --
444: -- ----------------------------------------------------------------------------

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

476: l_api_updating boolean;
477: --
478: Begin
479: --
480: hr_utility.set_location('Entering:'||l_proc,5);
481: --
482: l_api_updating := pqh_rls_shd.api_updating
483: (p_role_id => p_role_id,
484: p_object_version_number => p_object_version_number);

Line 501: hr_utility.set_message(801,'PQH_INVALID_ROLE_TYPE');

497: p_effective_date => p_effective_date) then
498: --
499: -- raise error as does not exist as lookup
500: --
501: hr_utility.set_message(801,'PQH_INVALID_ROLE_TYPE');
502: hr_utility.raise_error;
503: --
504: end if;
505: --

Line 502: hr_utility.raise_error;

498: --
499: -- raise error as does not exist as lookup
500: --
501: hr_utility.set_message(801,'PQH_INVALID_ROLE_TYPE');
502: hr_utility.raise_error;
503: --
504: end if;
505: --
506: end if;

Line 508: hr_utility.set_location('Leaving:'||l_proc,0);

504: end if;
505: --
506: end if;
507: --
508: hr_utility.set_location('Leaving:'||l_proc,0);
509: --
510: end chk_role_type_cd;
511: --
512: -- ----------------------------------------------------------------------------

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

544: l_role_assign_count number(25) :=0;
545: --
546: Begin
547: --
548: hr_utility.set_location('Entering:'||l_proc,5);
549: --
550: begin
551: select count(*) into l_role_assign_count
552: from per_people_extra_info pei

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

556: if l_role_assign_count >0 then
557: --
558: -- raise error as does not exist as lookup
559: --
560: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
561: hr_utility.raise_error;
562: end if;
563: --
564: end;

Line 561: hr_utility.raise_error;

557: --
558: -- raise error as does not exist as lookup
559: --
560: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
561: hr_utility.raise_error;
562: end if;
563: --
564: end;
565: --

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

562: end if;
563: --
564: end;
565: --
566: hr_utility.set_location('Leaving:'||l_proc,0);
567: --
568: end chk_role_assignment;
569: --
570: -- ----------------------------------------------------------------------------

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

584: and role_id <> nvl(p_role_id,0);
585:
586: Begin
587: --
588: hr_utility.set_location('Entering:'||l_proc,5);
589: --
590: open csr_role_name;
591: fetch csr_role_name into l_dummy;
592: close csr_role_name;

Line 596: hr_utility.set_message(8302,'PQH_DUPLICATE_ROLE_NAME');

592: close csr_role_name;
593:
594: if nvl(l_dummy ,'Y') = 'X' then
595: --
596: hr_utility.set_message(8302,'PQH_DUPLICATE_ROLE_NAME');
597: hr_utility.raise_error;
598: --
599: end if;
600:

Line 597: hr_utility.raise_error;

593:
594: if nvl(l_dummy ,'Y') = 'X' then
595: --
596: hr_utility.set_message(8302,'PQH_DUPLICATE_ROLE_NAME');
597: hr_utility.raise_error;
598: --
599: end if;
600:
601: --

Line 602: hr_utility.set_location('Leaving:'||l_proc,0);

598: --
599: end if;
600:
601: --
602: hr_utility.set_location('Leaving:'||l_proc,0);
603: --
604: end chk_role_name;
605: --
606: -- ----------------------------------------------------------------------------

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

638: where role_id = NVL(p_role_id,0);
639: --
640: Begin
641: --
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: --
644: open csr_cnt_templates;
645: fetch csr_cnt_templates into l_cnt_templates;
646: close csr_cnt_templates;

Line 662: hr_utility.set_message(8302,'PQH_DELETE_ROLE');

658: close csr_cnt_routing_lists;
659: --
660: if nvl(l_cnt_templates ,0) <> 0 then
661: --
662: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
663: hr_utility.set_message_token('ENTITY','Templates');
664: hr_utility.raise_error;
665: --
666: end if;

Line 663: hr_utility.set_message_token('ENTITY','Templates');

659: --
660: if nvl(l_cnt_templates ,0) <> 0 then
661: --
662: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
663: hr_utility.set_message_token('ENTITY','Templates');
664: hr_utility.raise_error;
665: --
666: end if;
667: --

Line 664: hr_utility.raise_error;

660: if nvl(l_cnt_templates ,0) <> 0 then
661: --
662: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
663: hr_utility.set_message_token('ENTITY','Templates');
664: hr_utility.raise_error;
665: --
666: end if;
667: --
668: if nvl(l_cnt_positions ,0) <> 0 then

Line 670: hr_utility.set_message(8302,'PQH_DELETE_ROLE');

666: end if;
667: --
668: if nvl(l_cnt_positions ,0) <> 0 then
669: --
670: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
671: hr_utility.set_message_token('ENTITY','Positions');
672: hr_utility.raise_error;
673: --
674: end if;

Line 671: hr_utility.set_message_token('ENTITY','Positions');

667: --
668: if nvl(l_cnt_positions ,0) <> 0 then
669: --
670: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
671: hr_utility.set_message_token('ENTITY','Positions');
672: hr_utility.raise_error;
673: --
674: end if;
675: --

Line 672: hr_utility.raise_error;

668: if nvl(l_cnt_positions ,0) <> 0 then
669: --
670: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
671: hr_utility.set_message_token('ENTITY','Positions');
672: hr_utility.raise_error;
673: --
674: end if;
675: --
676: if nvl(l_cnt_users ,0) <> 0 then

Line 678: hr_utility.set_message(8302,'PQH_DELETE_ROLE');

674: end if;
675: --
676: if nvl(l_cnt_users ,0) <> 0 then
677: --
678: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
679: hr_utility.set_message_token('ENTITY','Users');
680: hr_utility.raise_error;
681: --
682: end if;

Line 679: hr_utility.set_message_token('ENTITY','Users');

675: --
676: if nvl(l_cnt_users ,0) <> 0 then
677: --
678: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
679: hr_utility.set_message_token('ENTITY','Users');
680: hr_utility.raise_error;
681: --
682: end if;
683: --

Line 680: hr_utility.raise_error;

676: if nvl(l_cnt_users ,0) <> 0 then
677: --
678: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
679: hr_utility.set_message_token('ENTITY','Users');
680: hr_utility.raise_error;
681: --
682: end if;
683: --
684: if nvl(l_cnt_routing_lists ,0) <> 0 then

Line 686: hr_utility.set_message(8302,'PQH_DELETE_ROLE');

682: end if;
683: --
684: if nvl(l_cnt_routing_lists ,0) <> 0 then
685: --
686: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
687: hr_utility.set_message_token('ENTITY','Routing Lists');
688: hr_utility.raise_error;
689: --
690: end if;

Line 687: hr_utility.set_message_token('ENTITY','Routing Lists');

683: --
684: if nvl(l_cnt_routing_lists ,0) <> 0 then
685: --
686: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
687: hr_utility.set_message_token('ENTITY','Routing Lists');
688: hr_utility.raise_error;
689: --
690: end if;
691: --

Line 688: hr_utility.raise_error;

684: if nvl(l_cnt_routing_lists ,0) <> 0 then
685: --
686: hr_utility.set_message(8302,'PQH_DELETE_ROLE');
687: hr_utility.set_message_token('ENTITY','Routing Lists');
688: hr_utility.raise_error;
689: --
690: end if;
691: --
692:

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

689: --
690: end if;
691: --
692:
693: hr_utility.set_location('Leaving:'||l_proc,10);
694: --
695: end chk_role_delete;
696: --
697: -- ---------------------------------------------------------------------------

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

715: and rct.transaction_category_id=ptc.transaction_category_id;
716: --
717: Begin
718: --
719: hr_utility.set_location('Entering:'||l_proc, 5);
720: --
721: for r_txn_cat in c_txn_cats(p_role_id)
722: loop
723: --

Line 727: hr_utility.set_message(8302,'PQH_CANT_DEL_RLS_PNDG_TXN');

723: --
724: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')
725: = 'Y' then
726: --
727: hr_utility.set_message(8302,'PQH_CANT_DEL_RLS_PNDG_TXN');
728: hr_utility.set_message_token('TRANSACTION_CATEGORY', r_txn_cat.transaction_category);
729: if (r_txn_cat.business_group_id is not null) then
730: l_bus_grp_name := hr_general.DECODE_ORGANIZATION(r_txn_cat.business_group_id);
731: else

Line 728: hr_utility.set_message_token('TRANSACTION_CATEGORY', r_txn_cat.transaction_category);

724: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')
725: = 'Y' then
726: --
727: hr_utility.set_message(8302,'PQH_CANT_DEL_RLS_PNDG_TXN');
728: hr_utility.set_message_token('TRANSACTION_CATEGORY', r_txn_cat.transaction_category);
729: if (r_txn_cat.business_group_id is not null) then
730: l_bus_grp_name := hr_general.DECODE_ORGANIZATION(r_txn_cat.business_group_id);
731: else
732: l_bus_grp_name := hr_general.decode_lookup('PQH_TCT_SCOPE', 'GLOBAL');

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

731: else
732: l_bus_grp_name := hr_general.decode_lookup('PQH_TCT_SCOPE', 'GLOBAL');
733: end if;
734: --
735: hr_utility.set_message_token('BUSINESS_GROUP', l_bus_grp_name);
736: --
737: hr_utility.raise_error;
738: end if;
739: --

Line 737: hr_utility.raise_error;

733: end if;
734: --
735: hr_utility.set_message_token('BUSINESS_GROUP', l_bus_grp_name);
736: --
737: hr_utility.raise_error;
738: end if;
739: --
740: end loop;
741: --

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

738: end if;
739: --
740: end loop;
741: --
742: hr_utility.set_location('Leaving:'||l_proc,10);
743: --
744: end chk_for_pending_txns;
745: --
746: -- ---------------------------------------------------------------------------

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

763: or (rct.override_user_id = p_user_id and rct.override_role_id = p_role_id) ;
764: --
765: Begin
766: --
767: hr_utility.set_location('Entering:'||l_proc, 5);
768: --
769: for r_txn_cat in c_txn_cats(p_role_id, p_user_id)
770: loop
771: --

Line 774: hr_utility.set_message(8302,'PQH_CANT_DEL_USR_PNDG_TXN');

770: loop
771: --
772: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')
773: = 'Y' then
774: hr_utility.set_message(8302,'PQH_CANT_DEL_USR_PNDG_TXN');
775: hr_utility.raise_error;
776: end if;
777: --
778: end loop;

Line 775: hr_utility.raise_error;

771: --
772: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')
773: = 'Y' then
774: hr_utility.set_message(8302,'PQH_CANT_DEL_USR_PNDG_TXN');
775: hr_utility.raise_error;
776: end if;
777: --
778: end loop;
779: --

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

776: end if;
777: --
778: end loop;
779: --
780: hr_utility.set_location('Leaving:'||l_proc,10);
781: --
782: end chk_user_pending_txns;
783: --
784:

Line 819: hr_utility.set_location('Entering:'||l_proc,10);

815: --
816: l_proc varchar2(72) := g_package||'chk_ddf';
817: --
818: begin
819: hr_utility.set_location('Entering:'||l_proc,10);
820: --
821:
822: if ((p_rec.role_id is not null) and (
823: nvl(pqh_rls_shd.g_old_rec.information_category,hr_api.g_varchar2) <>

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

956: ,p_attribute30_value => p_rec.information30
957: );
958: end if;
959:
960: hr_utility.set_location(' Leaving:'||l_proc,20);
961:
962: end chk_ddf;
963:
964: -- ----------------------------------------------------------------------------

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

971: --
972: l_proc varchar2(72) := g_package||'insert_validate';
973: --
974: Begin
975: hr_utility.set_location('Entering:'||l_proc,5);
976: --
977: -- Call all supporting business operations
978: --
979: chk_role_id

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

1012: p_role_type_cd => p_rec.role_type_cd,
1013: p_business_group_id => p_rec.business_group_id,
1014: p_enable_flag => p_rec.enable_flag );
1015: --
1016: hr_utility.set_location(' Leaving:'||l_proc,10);
1017:
1018: End insert_validate;
1019: --
1020: -- ----------------------------------------------------------------------------

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

1027: --
1028: l_proc varchar2(72) := g_package||'update_validate';
1029: --
1030: Begin
1031: hr_utility.set_location('Entering:'||l_proc,5);
1032: --
1033: -- Call all supporting business operations
1034: --
1035: chk_role_id

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

1075: p_role_type_cd => p_rec.role_type_cd,
1076: p_business_group_id => p_rec.business_group_id,
1077: p_enable_flag => p_rec.enable_flag );
1078: --
1079: hr_utility.set_location(' Leaving:'||l_proc,10);
1080: End update_validate;
1081: --
1082: -- ----------------------------------------------------------------------------
1083: -- |---------------------------< delete_validate >----------------------------|

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

1089: --
1090: l_proc varchar2(72) := g_package||'delete_validate';
1091: --
1092: Begin
1093: hr_utility.set_location('Entering:'||l_proc,5);
1094: --
1095: -- Call all supporting business operations
1096: --
1097: /* Commented to allow role deletion and the other data

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

1103: p_effective_date => p_effective_date,
1104: p_object_version_number => p_rec.object_version_number);
1105: */
1106: --
1107: hr_utility.set_location(' Leaving:'||l_proc,10);
1108: End delete_validate;
1109: --
1110: end pqh_rls_bus;