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

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

61: l_api_updating boolean;
62: --
63: Begin
64: --
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: --
67: l_api_updating := pqh_rst_shd.api_updating
68: (p_rule_set_id => p_rule_set_id,
69: p_object_version_number => p_object_version_number);

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

89: end if;
90: --
91: end if;
92: --
93: hr_utility.set_location('Leaving:'||l_proc, 10);
94: --
95: End chk_rule_set_id;
96: --
97: -- ----------------------------------------------------------------------------

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

133: l_proc varchar2(72) := g_package||'chk_rule_set_name';
134: --
135: Begin
136: --
137: hr_utility.set_location('Entering:'||l_proc, 5);
138: --
139: l_api_updating := pqh_rst_shd.api_updating
140: (p_rule_set_id => p_rule_set_id,
141: p_object_version_number => p_object_version_number);

Line 154: hr_utility.set_message(8302,'PQH_DUPLICATE_RULE_SET_NAME');

150: Open csr_rst_name;
151: Fetch csr_rst_name into l_dummy;
152: If csr_rst_name%found then
153: Close csr_rst_name;
154: hr_utility.set_message(8302,'PQH_DUPLICATE_RULE_SET_NAME');
155: hr_utility.raise_error;
156: End if;
157: Close csr_rst_name;
158: --

Line 155: hr_utility.raise_error;

151: Fetch csr_rst_name into l_dummy;
152: If csr_rst_name%found then
153: Close csr_rst_name;
154: hr_utility.set_message(8302,'PQH_DUPLICATE_RULE_SET_NAME');
155: hr_utility.raise_error;
156: End if;
157: Close csr_rst_name;
158: --
159: end if;

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

157: Close csr_rst_name;
158: --
159: end if;
160: --
161: hr_utility.set_location('Leaving:'||l_proc, 10);
162: --
163: End chk_rule_set_name;
164: --
165: -- ----------------------------------------------------------------------------

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

204: where rule_set_id = p_referenced_rule_set_id;
205: --
206: Begin
207: --
208: hr_utility.set_location('Entering:'||l_proc,5);
209: --
210: l_api_updating := pqh_rst_shd.api_updating
211: (p_rule_set_id => p_rule_set_id,
212: p_object_version_number => p_object_version_number);

Line 230: hr_utility.set_location ('rule category does not match with reference rule',10);

226: pqh_rst_shd.constraint_error('PQH_RULE_SETS_FK4');
227: else
228: close c1;
229: if l_rule_category <> p_rule_category then
230: hr_utility.set_location ('rule category does not match with reference rule',10);
231: hr_utility.set_message(8302,'PQH_CBR_RULE_CAT_REF');
232: hr_utility.set_message_token('CATEGORY_REF',l_rule_category);
233: hr_utility.set_message_token('CATEGORY_RULS',p_rule_category);
234: hr_utility.raise_error;

Line 231: hr_utility.set_message(8302,'PQH_CBR_RULE_CAT_REF');

227: else
228: close c1;
229: if l_rule_category <> p_rule_category then
230: hr_utility.set_location ('rule category does not match with reference rule',10);
231: hr_utility.set_message(8302,'PQH_CBR_RULE_CAT_REF');
232: hr_utility.set_message_token('CATEGORY_REF',l_rule_category);
233: hr_utility.set_message_token('CATEGORY_RULS',p_rule_category);
234: hr_utility.raise_error;
235: end if;

Line 232: hr_utility.set_message_token('CATEGORY_REF',l_rule_category);

228: close c1;
229: if l_rule_category <> p_rule_category then
230: hr_utility.set_location ('rule category does not match with reference rule',10);
231: hr_utility.set_message(8302,'PQH_CBR_RULE_CAT_REF');
232: hr_utility.set_message_token('CATEGORY_REF',l_rule_category);
233: hr_utility.set_message_token('CATEGORY_RULS',p_rule_category);
234: hr_utility.raise_error;
235: end if;
236: if l_seeded_rule_flag <> 'Y' then

Line 233: hr_utility.set_message_token('CATEGORY_RULS',p_rule_category);

229: if l_rule_category <> p_rule_category then
230: hr_utility.set_location ('rule category does not match with reference rule',10);
231: hr_utility.set_message(8302,'PQH_CBR_RULE_CAT_REF');
232: hr_utility.set_message_token('CATEGORY_REF',l_rule_category);
233: hr_utility.set_message_token('CATEGORY_RULS',p_rule_category);
234: hr_utility.raise_error;
235: end if;
236: if l_seeded_rule_flag <> 'Y' then
237: hr_utility.set_location ('user defined rule is being made reference rule',10);

Line 234: hr_utility.raise_error;

230: hr_utility.set_location ('rule category does not match with reference rule',10);
231: hr_utility.set_message(8302,'PQH_CBR_RULE_CAT_REF');
232: hr_utility.set_message_token('CATEGORY_REF',l_rule_category);
233: hr_utility.set_message_token('CATEGORY_RULS',p_rule_category);
234: hr_utility.raise_error;
235: end if;
236: if l_seeded_rule_flag <> 'Y' then
237: hr_utility.set_location ('user defined rule is being made reference rule',10);
238: hr_utility.set_message(8302,'PQH_CBR_USER_DEF_REF');

Line 237: hr_utility.set_location ('user defined rule is being made reference rule',10);

233: hr_utility.set_message_token('CATEGORY_RULS',p_rule_category);
234: hr_utility.raise_error;
235: end if;
236: if l_seeded_rule_flag <> 'Y' then
237: hr_utility.set_location ('user defined rule is being made reference rule',10);
238: hr_utility.set_message(8302,'PQH_CBR_USER_DEF_REF');
239: hr_utility.set_message_token('REFERENCE_RULE_SET',l_ref_rule_set_name);
240: hr_utility.raise_error;
241: end if;

Line 238: hr_utility.set_message(8302,'PQH_CBR_USER_DEF_REF');

234: hr_utility.raise_error;
235: end if;
236: if l_seeded_rule_flag <> 'Y' then
237: hr_utility.set_location ('user defined rule is being made reference rule',10);
238: hr_utility.set_message(8302,'PQH_CBR_USER_DEF_REF');
239: hr_utility.set_message_token('REFERENCE_RULE_SET',l_ref_rule_set_name);
240: hr_utility.raise_error;
241: end if;
242: end if;

Line 239: hr_utility.set_message_token('REFERENCE_RULE_SET',l_ref_rule_set_name);

235: end if;
236: if l_seeded_rule_flag <> 'Y' then
237: hr_utility.set_location ('user defined rule is being made reference rule',10);
238: hr_utility.set_message(8302,'PQH_CBR_USER_DEF_REF');
239: hr_utility.set_message_token('REFERENCE_RULE_SET',l_ref_rule_set_name);
240: hr_utility.raise_error;
241: end if;
242: end if;
243: else

Line 240: hr_utility.raise_error;

236: if l_seeded_rule_flag <> 'Y' then
237: hr_utility.set_location ('user defined rule is being made reference rule',10);
238: hr_utility.set_message(8302,'PQH_CBR_USER_DEF_REF');
239: hr_utility.set_message_token('REFERENCE_RULE_SET',l_ref_rule_set_name);
240: hr_utility.raise_error;
241: end if;
242: end if;
243: else
244: if p_rule_category <> 'REALLOCATION' then

Line 245: hr_utility.set_location('Reference rule has to be there',20);

241: end if;
242: end if;
243: else
244: if p_rule_category <> 'REALLOCATION' then
245: hr_utility.set_location('Reference rule has to be there',20);
246: hr_utility.set_message(8302,'PQH_CBR_BGT_REALLOC_NO_REF');
247: hr_utility.raise_error;
248: end if;
249: end if;

Line 246: hr_utility.set_message(8302,'PQH_CBR_BGT_REALLOC_NO_REF');

242: end if;
243: else
244: if p_rule_category <> 'REALLOCATION' then
245: hr_utility.set_location('Reference rule has to be there',20);
246: hr_utility.set_message(8302,'PQH_CBR_BGT_REALLOC_NO_REF');
247: hr_utility.raise_error;
248: end if;
249: end if;
250: end if;

Line 247: hr_utility.raise_error;

243: else
244: if p_rule_category <> 'REALLOCATION' then
245: hr_utility.set_location('Reference rule has to be there',20);
246: hr_utility.set_message(8302,'PQH_CBR_BGT_REALLOC_NO_REF');
247: hr_utility.raise_error;
248: end if;
249: end if;
250: end if;
251: --

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

248: end if;
249: end if;
250: end if;
251: --
252: hr_utility.set_location('Leaving:'||l_proc,10);
253: --
254: End chk_referenced_rule_set_id;
255: --
256: -- ----------------------------------------------------------------------------

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

292: where a.organization_id = p_business_group_id;
293: --
294: Begin
295: --
296: hr_utility.set_location('Entering:'||l_proc,5);
297: --
298: l_api_updating := pqh_rst_shd.api_updating
299: (p_rule_set_id => p_rule_set_id,
300: p_object_version_number => p_object_version_number);

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

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

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

388:
389: --
390: Begin
391: --
392: hr_utility.set_location('Entering:'||l_proc,5);
393: --
394: l_api_updating := pqh_rst_shd.api_updating
395: (p_rule_set_id => p_rule_set_id,
396: p_object_version_number => p_object_version_number);

Line 416: hr_utility.set_message(8302,'PQH_DUP_RULE_SET');

412: close c1;
413: --
414: l_rule_set_name := get_rule_set_name(p_rule_set_id);
415: --
416: hr_utility.set_message(8302,'PQH_DUP_RULE_SET');
417: hr_utility.set_message_token('REFERENCE_RULE_SET',l_rule_set_name);
418: hr_utility.raise_error;
419: --
420: end if;

Line 417: hr_utility.set_message_token('REFERENCE_RULE_SET',l_rule_set_name);

413: --
414: l_rule_set_name := get_rule_set_name(p_rule_set_id);
415: --
416: hr_utility.set_message(8302,'PQH_DUP_RULE_SET');
417: hr_utility.set_message_token('REFERENCE_RULE_SET',l_rule_set_name);
418: hr_utility.raise_error;
419: --
420: end if;
421: --

Line 418: hr_utility.raise_error;

414: l_rule_set_name := get_rule_set_name(p_rule_set_id);
415: --
416: hr_utility.set_message(8302,'PQH_DUP_RULE_SET');
417: hr_utility.set_message_token('REFERENCE_RULE_SET',l_rule_set_name);
418: hr_utility.raise_error;
419: --
420: end if;
421: --
422: close c1;

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

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

Line 485: HR_UTILITY.set_location('Entering: '||l_proc,5);

481: AND NVL(p_seeded_rule_flag,'N') = 'N';
482: --
483: BEGIN
484: --
485: HR_UTILITY.set_location('Entering: '||l_proc,5);
486: --
487: OPEN c1;
488: FETCH c1 into l_rule_set_id;
489: IF c1%FOUND THEN

Line 492: HR_UTILITY.set_message(8302,'PQH_DUP_RULE_SET');

488: FETCH c1 into l_rule_set_id;
489: IF c1%FOUND THEN
490: CLOSE c1;
491: l_ref_rule_set_name := get_rule_set_name(p_referenced_rule_set_id);
492: HR_UTILITY.set_message(8302,'PQH_DUP_RULE_SET');
493: HR_UTILITY.set_message_token('REFERENCE_RULE_SET',l_ref_rule_set_name);
494: HR_UTILITY.raise_error;
495: END IF;
496: CLOSE c1;

Line 493: HR_UTILITY.set_message_token('REFERENCE_RULE_SET',l_ref_rule_set_name);

489: IF c1%FOUND THEN
490: CLOSE c1;
491: l_ref_rule_set_name := get_rule_set_name(p_referenced_rule_set_id);
492: HR_UTILITY.set_message(8302,'PQH_DUP_RULE_SET');
493: HR_UTILITY.set_message_token('REFERENCE_RULE_SET',l_ref_rule_set_name);
494: HR_UTILITY.raise_error;
495: END IF;
496: CLOSE c1;
497: --

Line 494: HR_UTILITY.raise_error;

490: CLOSE c1;
491: l_ref_rule_set_name := get_rule_set_name(p_referenced_rule_set_id);
492: HR_UTILITY.set_message(8302,'PQH_DUP_RULE_SET');
493: HR_UTILITY.set_message_token('REFERENCE_RULE_SET',l_ref_rule_set_name);
494: HR_UTILITY.raise_error;
495: END IF;
496: CLOSE c1;
497: --
498: HR_UTILITY.set_location('Leaving: '||l_proc,10);

Line 498: HR_UTILITY.set_location('Leaving: '||l_proc,10);

494: HR_UTILITY.raise_error;
495: END IF;
496: CLOSE c1;
497: --
498: HR_UTILITY.set_location('Leaving: '||l_proc,10);
499: --
500: END chk_dup_rule_set;
501: --
502: --

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

541: where a.organization_id = p_organization_id;
542: --
543: Begin
544: --
545: hr_utility.set_location('Entering:'||l_proc,5);
546: --
547: l_api_updating := pqh_rst_shd.api_updating
548: (p_rule_set_id => p_rule_set_id,
549: p_object_version_number => p_object_version_number);

Line 574: hr_utility.set_message(8302,'PQH_ORG_NOT_VALID');

570: --
571: -- raise error as FK does not relate to PK in hr_all_organization_units
572: -- table.
573: --
574: hr_utility.set_message(8302,'PQH_ORG_NOT_VALID');
575: hr_utility.raise_error;
576: --
577: end if;
578: --

Line 575: hr_utility.raise_error;

571: -- raise error as FK does not relate to PK in hr_all_organization_units
572: -- table.
573: --
574: hr_utility.set_message(8302,'PQH_ORG_NOT_VALID');
575: hr_utility.raise_error;
576: --
577: end if;
578: --
579: close c1;

Line 587: hr_utility.set_message(8302,'PQH_ORG_NOT_IN_BG');

583: -- As the passed business_group
584: --
585: If l_business_group_id <> p_business_group_id then
586: --
587: hr_utility.set_message(8302,'PQH_ORG_NOT_IN_BG');
588: hr_utility.raise_error;
589: --
590: End if;
591: --

Line 588: hr_utility.raise_error;

584: --
585: If l_business_group_id <> p_business_group_id then
586: --
587: hr_utility.set_message(8302,'PQH_ORG_NOT_IN_BG');
588: hr_utility.raise_error;
589: --
590: End if;
591: --
592: end if;

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

590: End if;
591: --
592: end if;
593: --
594: hr_utility.set_location('Leaving:'||l_proc,10);
595: --
596: End chk_organization_id;
597: --
598: -- ----------------------------------------------------------------------------

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

637: where a.organization_structure_id = p_organization_structure_id;
638: --
639: Begin
640: --
641: hr_utility.set_location('Entering:'||l_proc,5);
642: --
643: l_api_updating := pqh_rst_shd.api_updating
644: (p_rule_set_id => p_rule_set_id,
645: p_object_version_number => p_object_version_number);

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

674: -- Check if the organization_structure belongs to the same business_group
675: -- As the passed business_group
676: --
677: If l_business_group_id <> p_business_group_id then
678: hr_utility.set_message(8302,'PQH_ORG_STRUCT_NOT_IN_BG');
679: hr_utility.raise_error;
680: End if;
681: --
682:

Line 679: hr_utility.raise_error;

675: -- As the passed business_group
676: --
677: If l_business_group_id <> p_business_group_id then
678: hr_utility.set_message(8302,'PQH_ORG_STRUCT_NOT_IN_BG');
679: hr_utility.raise_error;
680: End if;
681: --
682:
683: end if;

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

681: --
682:
683: end if;
684: --
685: hr_utility.set_location('Leaving:'||l_proc,10);
686: --
687: End chk_organization_structure_id;
688: --
689: -- ----------------------------------------------------------------------------

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

721: l_api_updating boolean;
722: --
723: Begin
724: --
725: hr_utility.set_location('Entering:'||l_proc, 5);
726: --
727: l_api_updating := pqh_rst_shd.api_updating
728: (p_rule_set_id => p_rule_set_id,
729: p_object_version_number => p_object_version_number);

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

742: p_effective_date => p_effective_date) then
743: --
744: -- raise error as does not exist as lookup
745: --
746: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
747: hr_utility.raise_error;
748: --
749: end if;
750: --

Line 747: hr_utility.raise_error;

743: --
744: -- raise error as does not exist as lookup
745: --
746: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
747: hr_utility.raise_error;
748: --
749: end if;
750: --
751: end if;

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

749: end if;
750: --
751: end if;
752: --
753: hr_utility.set_location('Leaving:'||l_proc,10);
754: --
755: end chk_rule_level_cd;
756: --
757: --

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

792: l_rule_category_meaning varchar2(240);
793: --
794: Begin
795: --
796: hr_utility.set_location('Entering:'||l_proc, 5);
797: --
798: l_api_updating := pqh_rst_shd.api_updating
799: (p_rule_set_id => p_rule_set_id,
800: p_object_version_number => p_object_version_number);

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

813: p_effective_date => p_effective_date) then
814: --
815: -- raise error as does not exist as lookup
816: --
817: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
818: hr_utility.raise_error;
819: --
820: end if;
821: if p_rule_category ='REALLOCATION' then

Line 818: hr_utility.raise_error;

814: --
815: -- raise error as does not exist as lookup
816: --
817: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
818: hr_utility.raise_error;
819: --
820: end if;
821: if p_rule_category ='REALLOCATION' then
822: if p_rule_applicability not in ('DONOR','RECEIVER') then

Line 823: hr_utility.set_message(8302,'PQH_CBR_BR_APPL_MISMATCH');

819: --
820: end if;
821: if p_rule_category ='REALLOCATION' then
822: if p_rule_applicability not in ('DONOR','RECEIVER') then
823: hr_utility.set_message(8302,'PQH_CBR_BR_APPL_MISMATCH');
824: hr_utility.raise_error;
825: end if;
826: else
827: if p_rule_applicability not in ('NONE') then

Line 824: hr_utility.raise_error;

820: end if;
821: if p_rule_category ='REALLOCATION' then
822: if p_rule_applicability not in ('DONOR','RECEIVER') then
823: hr_utility.set_message(8302,'PQH_CBR_BR_APPL_MISMATCH');
824: hr_utility.raise_error;
825: end if;
826: else
827: if p_rule_applicability not in ('NONE') then
828: select hr_general.decode_lookup('PQH_CBR_RULE_CATEGORY', p_rule_category)

Line 833: hr_utility.set_message(8302,'PQH_CBR_OTHER_APPL_MISMATCH');

829: into l_rule_category_meaning from dual;
830: if l_rule_category_meaning is not null then
831: l_rule_category_meaning := '"'||l_rule_category_meaning||'"';
832: end if;
833: hr_utility.set_message(8302,'PQH_CBR_OTHER_APPL_MISMATCH');
834: hr_utility.set_message_token('CATEGORY_RULE', l_rule_category_meaning);
835: hr_utility.raise_error;
836: end if;
837: end if;

Line 834: hr_utility.set_message_token('CATEGORY_RULE', l_rule_category_meaning);

830: if l_rule_category_meaning is not null then
831: l_rule_category_meaning := '"'||l_rule_category_meaning||'"';
832: end if;
833: hr_utility.set_message(8302,'PQH_CBR_OTHER_APPL_MISMATCH');
834: hr_utility.set_message_token('CATEGORY_RULE', l_rule_category_meaning);
835: hr_utility.raise_error;
836: end if;
837: end if;
838: --

Line 835: hr_utility.raise_error;

831: l_rule_category_meaning := '"'||l_rule_category_meaning||'"';
832: end if;
833: hr_utility.set_message(8302,'PQH_CBR_OTHER_APPL_MISMATCH');
834: hr_utility.set_message_token('CATEGORY_RULE', l_rule_category_meaning);
835: hr_utility.raise_error;
836: end if;
837: end if;
838: --
839: end if;

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

837: end if;
838: --
839: end if;
840: --
841: hr_utility.set_location('Leaving:'||l_proc,10);
842: --
843: end chk_rule_applicability;
844: --
845: --

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

878: l_api_updating boolean;
879: --
880: Begin
881: --
882: hr_utility.set_location('Entering:'||l_proc, 5);
883: --
884: l_api_updating := pqh_rst_shd.api_updating
885: (p_rule_set_id => p_rule_set_id,
886: p_object_version_number => p_object_version_number);

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

899: p_effective_date => p_effective_date) then
900: --
901: -- raise error as does not exist as lookup
902: --
903: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
904: hr_utility.raise_error;
905: --
906: end if;
907: --

Line 904: hr_utility.raise_error;

900: --
901: -- raise error as does not exist as lookup
902: --
903: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
904: hr_utility.raise_error;
905: --
906: end if;
907: --
908: end if;

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

906: end if;
907: --
908: end if;
909: --
910: hr_utility.set_location('Leaving:'||l_proc,10);
911: --
912: end chk_rule_category;
913: --
914: ----------------------------Extra API checks----------------------------------

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

967: AND b.organization_id_parent = p_starting_organization_id;
968: --
969: Begin
970: --
971: hr_utility.set_location('Entering:'||l_proc, 5);
972: --
973: l_api_updating := pqh_rst_shd.api_updating
974: (p_rule_set_id => p_rule_set_id,
975: p_object_version_number => p_object_version_number);

Line 998: hr_utility.set_message(8302, 'PQH_ORG_NOT_IN_ORG_STRUCT');

994: Fetch c1 into l_dummy;
995: --
996: If c1%notfound then
997: Close c1;
998: hr_utility.set_message(8302, 'PQH_ORG_NOT_IN_ORG_STRUCT');
999: hr_utility.raise_error;
1000: End if;
1001: --
1002: Close c1;

Line 999: hr_utility.raise_error;

995: --
996: If c1%notfound then
997: Close c1;
998: hr_utility.set_message(8302, 'PQH_ORG_NOT_IN_ORG_STRUCT');
999: hr_utility.raise_error;
1000: End if;
1001: --
1002: Close c1;
1003: --

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

1004: End if;
1005: --
1006: End if;
1007: --
1008: hr_utility.set_location(' Leaving:'||l_proc, 10);
1009: --
1010: End;
1011: --
1012: --

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

1020: l_api_updating boolean;
1021: --
1022: Begin
1023: --
1024: hr_utility.set_location('Entering:'||l_proc, 5);
1025: --
1026: l_api_updating := pqh_rst_shd.api_updating
1027: (p_rule_set_id => p_rule_set_id,
1028: p_object_version_number => p_object_version_number);

Line 1040: hr_utility.set_location('org hier entered, org must be null',20);

1036: <> nvl(pqh_rst_shd.g_old_rec.organization_structure_id,hr_api.g_number))
1037: or not l_api_updating) then
1038: --
1039: if p_organization_structure_id is not null and p_organization_id is not null then
1040: hr_utility.set_location('org hier entered, org must be null',20);
1041: hr_utility.set_message(8302, 'PQH_ORG_WITH_ORG_STRUCT');
1042: hr_utility.raise_error;
1043: end if;
1044: end if;

Line 1041: hr_utility.set_message(8302, 'PQH_ORG_WITH_ORG_STRUCT');

1037: or not l_api_updating) then
1038: --
1039: if p_organization_structure_id is not null and p_organization_id is not null then
1040: hr_utility.set_location('org hier entered, org must be null',20);
1041: hr_utility.set_message(8302, 'PQH_ORG_WITH_ORG_STRUCT');
1042: hr_utility.raise_error;
1043: end if;
1044: end if;
1045: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1042: hr_utility.raise_error;

1038: --
1039: if p_organization_structure_id is not null and p_organization_id is not null then
1040: hr_utility.set_location('org hier entered, org must be null',20);
1041: hr_utility.set_message(8302, 'PQH_ORG_WITH_ORG_STRUCT');
1042: hr_utility.raise_error;
1043: end if;
1044: end if;
1045: hr_utility.set_location(' Leaving:'||l_proc, 10);
1046: --

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

1041: hr_utility.set_message(8302, 'PQH_ORG_WITH_ORG_STRUCT');
1042: hr_utility.raise_error;
1043: end if;
1044: end if;
1045: hr_utility.set_location(' Leaving:'||l_proc, 10);
1046: --
1047: End;
1048: --
1049: -- The foll procedures are written to check for org_structure overlap

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

1063: l_proc varchar2(72) := g_package||'get_ref_rule_set_name';
1064: --
1065: Begin
1066: --
1067: hr_utility.set_location(' Entering:'||l_proc, 5);
1068: --
1069: Open csr_ref;
1070: --
1071: Fetch csr_ref into p_rule_set_name;

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

1071: Fetch csr_ref into p_rule_set_name;
1072: --
1073: Close csr_ref;
1074: --
1075: hr_utility.set_location(' Leaving:'||l_proc, 10);
1076: --
1077: End;
1078: --
1079: --

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

1086: --
1087: l_proc varchar2(72) := g_package||'insert_validate';
1088: --
1089: Begin
1090: hr_utility.set_location('Entering:'||l_proc, 5);
1091: --
1092: -- Call all supporting business operations
1093: --
1094: chk_rule_set_id

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

1180: -- call hr_api.validate_bus_grp_id
1181: --
1182: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1183: --
1184: hr_utility.set_location(' Leaving:'||l_proc, 10);
1185: End insert_validate;
1186: --
1187: -- ----------------------------------------------------------------------------
1188: -- |---------------------------< update_validate >----------------------------|

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

1192: --
1193: l_proc varchar2(72) := g_package||'update_validate';
1194: --
1195: Begin
1196: hr_utility.set_location('Entering:'||l_proc, 5);
1197: --
1198: -- Call all supporting business operations
1199: --
1200: chk_rule_set_id

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

1286: -- call hr_api.validate_bus_grp_id
1287: --
1288: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1289: --
1290: hr_utility.set_location(' Leaving:'||l_proc, 10);
1291: End update_validate;
1292: --
1293: -- ----------------------------------------------------------------------------
1294: -- |---------------------------< delete_validate >----------------------------|

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

1298: --
1299: l_proc varchar2(72) := g_package||'delete_validate';
1300: --
1301: Begin
1302: hr_utility.set_location('Entering:'||l_proc, 5);
1303: --
1304: -- Call all supporting business operations
1305: --
1306: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1302: hr_utility.set_location('Entering:'||l_proc, 5);
1303: --
1304: -- Call all supporting business operations
1305: --
1306: hr_utility.set_location(' Leaving:'||l_proc, 10);
1307: End delete_validate;
1308: --
1309: --
1310: -- ---------------------------------------------------------------------------

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

1329: l_proc varchar2(72) := g_package||'return_legislation_code';
1330: --
1331: begin
1332: --
1333: hr_utility.set_location('Entering:'|| l_proc, 10);
1334: --
1335: -- Ensure that all the mandatory parameter are not null
1336: --
1337: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1351: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

1347: close csr_leg_code;
1348: --
1349: -- The primary key is invalid therefore we must error
1350: --
1351: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1352: hr_utility.raise_error;
1353: --
1354: end if;
1355: --

Line 1352: hr_utility.raise_error;

1348: --
1349: -- The primary key is invalid therefore we must error
1350: --
1351: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1352: hr_utility.raise_error;
1353: --
1354: end if;
1355: --
1356: close csr_leg_code;

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

1354: end if;
1355: --
1356: close csr_leg_code;
1357: --
1358: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1359: --
1360: return l_legislation_code;
1361: --
1362: end return_legislation_code;