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_RNG_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_rng_shd.api_updating
47: (p_attribute_range_id => p_attribute_range_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_attribute_range_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.position_id = p_position_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_rng_shd.api_updating
119: (p_attribute_range_id => p_attribute_range_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_position_id;
151: --
152: -- ----------------------------------------------------------------------------

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

195: from pqh_transaction_categories a
196: where a.transaction_category_id = l_tcat;
197: Begin
198: --
199: hr_utility.set_location('Entering:'||l_proc,5);
200: --
201: l_api_updating := pqh_rng_shd.api_updating
202: (p_attribute_range_id => p_attribute_range_id,
203: p_object_version_number => p_object_version_number);

Line 236: hr_utility.set_message(8302, 'PQH_INVALID_RNG_OPERATION');

232: Fetch c2 into l_freeze_status_cd;
233: close c2;
234:
235: if l_freeze_status_cd = 'FREEZE_CATEGORY' then
236: hr_utility.set_message(8302, 'PQH_INVALID_RNG_OPERATION');
237: hr_utility.raise_error;
238: End if;
239: hr_utility.set_location('Leaving:'||l_proc,10);
240: --

Line 237: hr_utility.raise_error;

233: close c2;
234:
235: if l_freeze_status_cd = 'FREEZE_CATEGORY' then
236: hr_utility.set_message(8302, 'PQH_INVALID_RNG_OPERATION');
237: hr_utility.raise_error;
238: End if;
239: hr_utility.set_location('Leaving:'||l_proc,10);
240: --
241: End chk_routing_category_id;

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

235: if l_freeze_status_cd = 'FREEZE_CATEGORY' then
236: hr_utility.set_message(8302, 'PQH_INVALID_RNG_OPERATION');
237: hr_utility.raise_error;
238: End if;
239: hr_utility.set_location('Leaving:'||l_proc,10);
240: --
241: End chk_routing_category_id;
242: --
243:

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

280: where a.routing_list_member_id = p_routing_list_member_id;
281: --
282: Begin
283: --
284: hr_utility.set_location('Entering:'||l_proc,5);
285: --
286: l_api_updating := pqh_rng_shd.api_updating
287: (p_attribute_range_id => p_attribute_range_id,
288: p_object_version_number => p_object_version_number);

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

312: close c1;
313: --
314: end if;
315: --
316: hr_utility.set_location('Leaving:'||l_proc,10);
317: --
318: End chk_routing_list_member_id;
319: --
320: -- ----------------------------------------------------------------------------

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

397: l_proc varchar2(72) := g_package||'chk_valid_list_member_id';
398: --
399: Begin
400: --
401: hr_utility.set_location('Entering:'||l_proc,5);
402: --
403: -- Select the routing list / position structure associated with the
404: -- routingcategory.
405: --

Line 430: hr_utility.set_message(8302,'PQH_INVALID_ROUTING_LIST_MEM');

426: -- Raise error if the member does not belong to the same routing list
427: -- as the one attached to the routing category.
428: --
429: If l_rlist_id1 <> l_rlist_id2 then
430: hr_utility.set_message(8302,'PQH_INVALID_ROUTING_LIST_MEM');
431: hr_utility.raise_error;
432: End if;
433:
434: If l_enable_flag <> 'Y' then

Line 431: hr_utility.raise_error;

427: -- as the one attached to the routing category.
428: --
429: If l_rlist_id1 <> l_rlist_id2 then
430: hr_utility.set_message(8302,'PQH_INVALID_ROUTING_LIST_MEM');
431: hr_utility.raise_error;
432: End if;
433:
434: If l_enable_flag <> 'Y' then
435: If not l_api_updating then

Line 440: hr_utility.set_message(8302,'PQH_AUTHORIZER_NOT_ENABLED');

436:
437: open csr_new_attr_in_rule;
438: fetch csr_new_attr_in_rule into l_dummy;
439: If csr_new_attr_in_rule%found then
440: hr_utility.set_message(8302,'PQH_AUTHORIZER_NOT_ENABLED');
441: hr_utility.raise_error;
442: End if;
443: Close csr_new_attr_in_rule;
444: Else

Line 441: hr_utility.raise_error;

437: open csr_new_attr_in_rule;
438: fetch csr_new_attr_in_rule into l_dummy;
439: If csr_new_attr_in_rule%found then
440: hr_utility.set_message(8302,'PQH_AUTHORIZER_NOT_ENABLED');
441: hr_utility.raise_error;
442: End if;
443: Close csr_new_attr_in_rule;
444: Else
445: hr_utility.set_message(8302,'PQH_AUTHORIZER_NOT_ENABLED');

Line 445: hr_utility.set_message(8302,'PQH_AUTHORIZER_NOT_ENABLED');

441: hr_utility.raise_error;
442: End if;
443: Close csr_new_attr_in_rule;
444: Else
445: hr_utility.set_message(8302,'PQH_AUTHORIZER_NOT_ENABLED');
446: hr_utility.raise_error;
447: End if;
448: End if;
449:

Line 446: hr_utility.raise_error;

442: End if;
443: Close csr_new_attr_in_rule;
444: Else
445: hr_utility.set_message(8302,'PQH_AUTHORIZER_NOT_ENABLED');
446: hr_utility.raise_error;
447: End if;
448: End if;
449:
450: If p_position_id IS NOT NULL OR p_assignment_id IS NOT NULL then

Line 451: hr_utility.set_message(8302,'PQH_MULTIPLE_MEMBER_TYPES');

447: End if;
448: End if;
449:
450: If p_position_id IS NOT NULL OR p_assignment_id IS NOT NULL then
451: hr_utility.set_message(8302,'PQH_MULTIPLE_MEMBER_TYPES');
452: hr_utility.raise_error;
453: End if;
454: --
455: end if;

Line 452: hr_utility.raise_error;

448: End if;
449:
450: If p_position_id IS NOT NULL OR p_assignment_id IS NOT NULL then
451: hr_utility.set_message(8302,'PQH_MULTIPLE_MEMBER_TYPES');
452: hr_utility.raise_error;
453: End if;
454: --
455: end if;
456: --

Line 479: hr_utility.set_message(8302,'PQH_POS_NOT_IN_POS_HIER');

475: -- raise error if the position does not belong to the same position
476: -- structure as the one associated with the routing category.
477: --
478: close csr_pos_in_pos_hier;
479: hr_utility.set_message(8302,'PQH_POS_NOT_IN_POS_HIER');
480: hr_utility.raise_error;
481: --
482: end if;
483: --

Line 480: hr_utility.raise_error;

476: -- structure as the one associated with the routing category.
477: --
478: close csr_pos_in_pos_hier;
479: hr_utility.set_message(8302,'PQH_POS_NOT_IN_POS_HIER');
480: hr_utility.raise_error;
481: --
482: end if;
483: --
484: Close csr_pos_in_pos_hier;

Line 489: hr_utility.set_message(8302,'PQH_MULTIPLE_MEMBER_TYPES');

485: --
486: If p_routing_list_member_id IS NOT NULL OR
487: p_assignment_id IS NOT NULL then
488: --
489: hr_utility.set_message(8302,'PQH_MULTIPLE_MEMBER_TYPES');
490: hr_utility.raise_error;
491: --
492: End if;
493: --

Line 490: hr_utility.raise_error;

486: If p_routing_list_member_id IS NOT NULL OR
487: p_assignment_id IS NOT NULL then
488: --
489: hr_utility.set_message(8302,'PQH_MULTIPLE_MEMBER_TYPES');
490: hr_utility.raise_error;
491: --
492: End if;
493: --
494: end if;

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

501: or not l_api_updating) and
502: p_assignment_id is not null then
503: --
504: If p_routing_list_member_id IS NOT NULL OR p_position_id IS NOT NULL then
505: hr_utility.set_message(8302,'PQH_MULTIPLE_MEMBER_TYPES');
506: hr_utility.raise_error;
507: End if;
508: --
509: end if;

Line 506: hr_utility.raise_error;

502: p_assignment_id is not null then
503: --
504: If p_routing_list_member_id IS NOT NULL OR p_position_id IS NOT NULL then
505: hr_utility.set_message(8302,'PQH_MULTIPLE_MEMBER_TYPES');
506: hr_utility.raise_error;
507: End if;
508: --
509: end if;
510: --

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

508: --
509: end if;
510: --
511: --
512: hr_utility.set_location('Leaving:'||l_proc,10);
513: --
514: End chk_valid_list_member_id;
515: --
516: -- ----------------------------------------------------------------------------

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

552: where a.attribute_id = p_attribute_id;
553: --
554: Begin
555: --
556: hr_utility.set_location('Entering:'||l_proc,5);
557: --
558: l_api_updating := pqh_rng_shd.api_updating
559: (p_attribute_range_id => p_attribute_range_id,
560: p_object_version_number => p_object_version_number);

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

584: close c1;
585: --
586: end if;
587: --
588: hr_utility.set_location('Leaving:'||l_proc,10);
589: --
590: End chk_attribute_id;
591: --
592: -- ----------------------------------------------------------------------------

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

662: AND tca.transaction_category_id = p_transaction_category_id;
663: --
664: Begin
665: --
666: hr_utility.set_location('Entering:'||l_proc,5);
667: --
668: l_api_updating := pqh_rng_shd.api_updating
669: (p_attribute_range_id => p_attribute_range_id,
670: p_object_version_number => p_object_version_number);

Line 698: hr_utility.set_message(8302,'PQH_RNG_TCT_MISMATCH');

694: --
695: -- raise error as this attribute does not belong to the same transaction
696: -- category id as the routing category.
697: --
698: hr_utility.set_message(8302,'PQH_RNG_TCT_MISMATCH');
699: hr_utility.set_message_token('ATTRIBUTE_NAME', l_attribute_name);
700: hr_utility.raise_error;
701: --
702: End if;

Line 699: hr_utility.set_message_token('ATTRIBUTE_NAME', l_attribute_name);

695: -- raise error as this attribute does not belong to the same transaction
696: -- category id as the routing category.
697: --
698: hr_utility.set_message(8302,'PQH_RNG_TCT_MISMATCH');
699: hr_utility.set_message_token('ATTRIBUTE_NAME', l_attribute_name);
700: hr_utility.raise_error;
701: --
702: End if;
703: --

Line 700: hr_utility.raise_error;

696: -- category id as the routing category.
697: --
698: hr_utility.set_message(8302,'PQH_RNG_TCT_MISMATCH');
699: hr_utility.set_message_token('ATTRIBUTE_NAME', l_attribute_name);
700: hr_utility.raise_error;
701: --
702: End if;
703: --
704: Close c2;

Line 713: hr_utility.set_message(8302,'PQH_NOT_LIST_IDENTIFIER');

709: If p_routing_list_member_id IS NULL AND
710: p_position_id IS NULL AND
711: p_assignment_id IS NULL then
712: if l_list_identifier <> 'Y' then
713: hr_utility.set_message(8302,'PQH_NOT_LIST_IDENTIFIER');
714: hr_utility.raise_error;
715: End if;
716: Else
717: if l_member_identifier <> 'Y' then

Line 714: hr_utility.raise_error;

710: p_position_id IS NULL AND
711: p_assignment_id IS NULL then
712: if l_list_identifier <> 'Y' then
713: hr_utility.set_message(8302,'PQH_NOT_LIST_IDENTIFIER');
714: hr_utility.raise_error;
715: End if;
716: Else
717: if l_member_identifier <> 'Y' then
718: hr_utility.set_message(8302,'PQH_NOT_MEMBER_IDENTIFIER');

Line 718: hr_utility.set_message(8302,'PQH_NOT_MEMBER_IDENTIFIER');

714: hr_utility.raise_error;
715: End if;
716: Else
717: if l_member_identifier <> 'Y' then
718: hr_utility.set_message(8302,'PQH_NOT_MEMBER_IDENTIFIER');
719: hr_utility.raise_error;
720: End if;
721: End if;
722: --

Line 719: hr_utility.raise_error;

715: End if;
716: Else
717: if l_member_identifier <> 'Y' then
718: hr_utility.set_message(8302,'PQH_NOT_MEMBER_IDENTIFIER');
719: hr_utility.raise_error;
720: End if;
721: End if;
722: --
723: -- Check if valid From and To range values are entered.

Line 729: hr_utility.set_message(8302,'PQH_INVALID_TO_RANGE');

725: If l_col_type = 'V' then
726: --
727: if p_from_char IS NOT NULL and p_to_char IS NOT NULL and
728: p_to_char < p_from_char then
729: hr_utility.set_message(8302,'PQH_INVALID_TO_RANGE');
730: hr_utility.raise_error;
731: End if;
732: --
733: if p_from_date IS NOT NULL OR p_to_date IS NOT NULL

Line 730: hr_utility.raise_error;

726: --
727: if p_from_char IS NOT NULL and p_to_char IS NOT NULL and
728: p_to_char < p_from_char then
729: hr_utility.set_message(8302,'PQH_INVALID_TO_RANGE');
730: hr_utility.raise_error;
731: End if;
732: --
733: if p_from_date IS NOT NULL OR p_to_date IS NOT NULL
734: OR p_from_number IS NOT NULL OR p_to_number IS NOT NULL then

Line 735: hr_utility.set_message(8302,'PQH_INVALID_RANGE_VALUES');

731: End if;
732: --
733: if p_from_date IS NOT NULL OR p_to_date IS NOT NULL
734: OR p_from_number IS NOT NULL OR p_to_number IS NOT NULL then
735: hr_utility.set_message(8302,'PQH_INVALID_RANGE_VALUES');
736: hr_utility.raise_error;
737: End if;
738: --
739: Elsif l_col_type = 'N' then

Line 736: hr_utility.raise_error;

732: --
733: if p_from_date IS NOT NULL OR p_to_date IS NOT NULL
734: OR p_from_number IS NOT NULL OR p_to_number IS NOT NULL then
735: hr_utility.set_message(8302,'PQH_INVALID_RANGE_VALUES');
736: hr_utility.raise_error;
737: End if;
738: --
739: Elsif l_col_type = 'N' then
740: --

Line 744: hr_utility.set_message(8302,'PQH_INVALID_TO_RANGE');

740: --
741: if p_from_number IS NOT NULL and p_to_number IS NOT NULL and
742: p_to_number < p_from_number then
743:
744: hr_utility.set_message(8302,'PQH_INVALID_TO_RANGE');
745: hr_utility.raise_error;
746: End if;
747: --
748: if p_from_date IS NOT NULL OR p_to_date IS NOT NULL

Line 745: hr_utility.raise_error;

741: if p_from_number IS NOT NULL and p_to_number IS NOT NULL and
742: p_to_number < p_from_number then
743:
744: hr_utility.set_message(8302,'PQH_INVALID_TO_RANGE');
745: hr_utility.raise_error;
746: End if;
747: --
748: if p_from_date IS NOT NULL OR p_to_date IS NOT NULL
749: OR p_from_char IS NOT NULL OR p_to_char IS NOT NULL then

Line 750: hr_utility.set_message(8302,'PQH_INVALID_RANGE_VALUES');

746: End if;
747: --
748: if p_from_date IS NOT NULL OR p_to_date IS NOT NULL
749: OR p_from_char IS NOT NULL OR p_to_char IS NOT NULL then
750: hr_utility.set_message(8302,'PQH_INVALID_RANGE_VALUES');
751: hr_utility.raise_error;
752: End if;
753: --
754: Elsif l_col_type = 'D' then

Line 751: hr_utility.raise_error;

747: --
748: if p_from_date IS NOT NULL OR p_to_date IS NOT NULL
749: OR p_from_char IS NOT NULL OR p_to_char IS NOT NULL then
750: hr_utility.set_message(8302,'PQH_INVALID_RANGE_VALUES');
751: hr_utility.raise_error;
752: End if;
753: --
754: Elsif l_col_type = 'D' then
755: --

Line 759: hr_utility.set_message(8302,'PQH_INVALID_TO_RANGE');

755: --
756: --
757: if p_from_date IS NOT NULL and p_to_date IS NOT NULL and
758: p_to_date < p_from_date then
759: hr_utility.set_message(8302,'PQH_INVALID_TO_RANGE');
760: hr_utility.raise_error;
761: End if;
762: --
763: if p_from_char IS NOT NULL OR p_to_char IS NOT NULL

Line 760: hr_utility.raise_error;

756: --
757: if p_from_date IS NOT NULL and p_to_date IS NOT NULL and
758: p_to_date < p_from_date then
759: hr_utility.set_message(8302,'PQH_INVALID_TO_RANGE');
760: hr_utility.raise_error;
761: End if;
762: --
763: if p_from_char IS NOT NULL OR p_to_char IS NOT NULL
764: OR p_from_number IS NOT NULL OR p_to_number IS NOT NULL then

Line 765: hr_utility.set_message(8302,'PQH_INVALID_RANGE_VALUES');

761: End if;
762: --
763: if p_from_char IS NOT NULL OR p_to_char IS NOT NULL
764: OR p_from_number IS NOT NULL OR p_to_number IS NOT NULL then
765: hr_utility.set_message(8302,'PQH_INVALID_RANGE_VALUES');
766: hr_utility.raise_error;
767: End if;
768: --
769: End if;

Line 766: hr_utility.raise_error;

762: --
763: if p_from_char IS NOT NULL OR p_to_char IS NOT NULL
764: OR p_from_number IS NOT NULL OR p_to_number IS NOT NULL then
765: hr_utility.set_message(8302,'PQH_INVALID_RANGE_VALUES');
766: hr_utility.raise_error;
767: End if;
768: --
769: End if;
770: --

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

769: End if;
770: --
771: End if; -- p_attribute_id IS NOT NULL
772: --
773: hr_utility.set_location('Leaving:'||l_proc,10);
774: --
775: End chk_if_valid_identifiers;
776: --
777: -- ----------------------------------------------------------------------------

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

809: l_api_updating boolean;
810: --
811: Begin
812: --
813: hr_utility.set_location('Entering:'||l_proc, 5);
814: --
815: l_api_updating := pqh_rng_shd.api_updating
816: (p_attribute_range_id => p_attribute_range_id,
817: p_object_version_number => p_object_version_number);

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

830: p_effective_date => p_effective_date) then
831: --
832: -- raise error as does not exist as lookup
833: --
834: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
835: hr_utility.raise_error;
836: --
837: end if;
838: --

Line 835: hr_utility.raise_error;

831: --
832: -- raise error as does not exist as lookup
833: --
834: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
835: hr_utility.raise_error;
836: --
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_approver_flag;
844: --
845: --

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

858: l_proc varchar2(72) := g_package||'chk_if_member_enabled';
859: --
860: Begin
861: --
862: hr_utility.set_location('Entering:'||l_proc,5);
863: --
864: Open csr_member_enabled;
865: --
866: Fetch csr_member_enabled into l_enable_flag;

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

870: If l_enable_flag <> 'Y' then
871: RETURN 1;
872: End if;
873: --
874: hr_utility.set_location('Leaving:'||l_proc,10);
875: --
876: RETURN 0;
877: --
878: End;

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

923: l_api_updating boolean;
924: --
925: Begin
926: --
927: hr_utility.set_location('Entering:'||l_proc, 5);
928: --
929: l_api_updating := pqh_rng_shd.api_updating
930: (p_attribute_range_id => p_attribute_range_id,
931: p_object_version_number => p_object_version_number);

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

944: p_effective_date => p_effective_date) then
945: --
946: -- raise error as does not exist as lookup
947: --
948: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
949: hr_utility.raise_error;
950: --
951: end if;
952: --

Line 949: hr_utility.raise_error;

945: --
946: -- raise error as does not exist as lookup
947: --
948: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
949: hr_utility.raise_error;
950: --
951: end if;
952: --
953: end if;

Line 974: hr_utility.set_message(8302,'PQH_CANNOT_ENABLE_AUTH_RULE');

970: p_routing_list_member_id => p_routing_list_member_id);
971: --
972: If l_error_code = 1 then
973: --
974: hr_utility.set_message(8302,'PQH_CANNOT_ENABLE_AUTH_RULE');
975: hr_utility.raise_error;
976: --
977: End if;
978: --

Line 975: hr_utility.raise_error;

971: --
972: If l_error_code = 1 then
973: --
974: hr_utility.set_message(8302,'PQH_CANNOT_ENABLE_AUTH_RULE');
975: hr_utility.raise_error;
976: --
977: End if;
978: --
979: end if;

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

979: end if;
980: --
981: end if;
982: --
983: hr_utility.set_location('Leaving:'||l_proc,10);
984: --
985: end chk_enable_flag;
986: --
987: --

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_rng_shd.api_updating
1027: (p_attribute_range_id => p_attribute_range_id,
1028: p_object_version_number => p_object_version_number);

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

1041: p_effective_date => p_effective_date) then
1042: --
1043: -- raise error as does not exist as lookup
1044: --
1045: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1046: hr_utility.raise_error;
1047: --
1048: end if;
1049: --

Line 1046: hr_utility.raise_error;

1042: --
1043: -- raise error as does not exist as lookup
1044: --
1045: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1046: hr_utility.raise_error;
1047: --
1048: end if;
1049: --
1050: end if;

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

1049: --
1050: end if;
1051: --
1052: --
1053: hr_utility.set_location('Leaving:'||l_proc,10);
1054: --
1055: end chk_delete_flag;
1056: --
1057: -- ----------------------------------------------------------------------------

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

1062: --
1063: l_proc varchar2(72) := g_package||'insert_validate';
1064: --
1065: Begin
1066: hr_utility.set_location('Entering:'||l_proc, 5);
1067: --
1068: -- Call all supporting business operations
1069: --
1070: chk_attribute_range_id

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

1137: p_object_version_number => p_rec.object_version_number);
1138: --
1139: --
1140: --
1141: hr_utility.set_location(' Leaving:'||l_proc, 10);
1142: End insert_validate;
1143: --
1144: -- ----------------------------------------------------------------------------
1145: -- |---------------------------< update_validate >----------------------------|

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

1149: --
1150: l_proc varchar2(72) := g_package||'update_validate';
1151: --
1152: Begin
1153: hr_utility.set_location('Entering:'||l_proc, 5);
1154: --
1155: -- Call all supporting business operations
1156: --
1157: chk_attribute_range_id

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

1224: p_to_date => p_rec.to_date,
1225: p_object_version_number => p_rec.object_version_number);
1226: --
1227: --
1228: hr_utility.set_location(' Leaving:'||l_proc, 10);
1229: End update_validate;
1230: --
1231: -- ----------------------------------------------------------------------------
1232: -- |---------------------------< delete_validate >----------------------------|

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

1236: --
1237: l_proc varchar2(72) := g_package||'delete_validate';
1238: --
1239: Begin
1240: hr_utility.set_location('Entering:'||l_proc, 5);
1241: --
1242: -- Call all supporting business operations
1243: --
1244: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1240: hr_utility.set_location('Entering:'||l_proc, 5);
1241: --
1242: -- Call all supporting business operations
1243: --
1244: hr_utility.set_location(' Leaving:'||l_proc, 10);
1245: End delete_validate;
1246: --
1247: end pqh_rng_bus;