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.HR_ORU_BUS dependencies on HR_UTILITY

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

36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error

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

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------

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

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

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

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := hr_oru_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

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

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

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

140: close csr_leg_code;
141: hr_oru_bus.g_organization_id := p_organization_id;
142: hr_oru_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------

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

179: --
180: l_proc varchar2(72) := g_package || 'chk_df';
181: --
182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.organization_id is not null) and (
186: nvl(hr_oru_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

324: );
325: end if;
326: end if;
327: --
328: hr_utility.set_location(' Leaving:'||l_proc,20);
329: end chk_df;
330: --
331: -- ----------------------------------------------------------------------------
332: -- |-----------------------< chk_non_updateable_args >------------------------|

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

451: -- WHERE organization_id = p_business_group_id
452: -- AND business_group_id = p_business_group_id;
453: --
454: --BEGIN
455: -- hr_utility.set_location('Entering:'|| l_proc, 10);
456: --
457: -- hr_api.mandatory_arg_error
458: -- (p_api_name => l_proc
459: -- ,p_argument => 'DATE_FROM'

Line 470: -- hr_utility.set_message(800, 'HR_51491_ESA_BUS_GRP_ID_FK2');

466: -- OPEN csr_bgr_date_from;
467: -- FETCH csr_bgr_date_from INTO l_bgr_date_from;
468: -- IF csr_bgr_date_from%notfound THEN
469: -- CLOSE csr_bgr_date_from;
470: -- hr_utility.set_message(800, 'HR_51491_ESA_BUS_GRP_ID_FK2');
471: -- hr_utility.raise_error;
472: -- END IF;
473: -- CLOSE csr_bgr_date_from;
474: --

Line 471: -- hr_utility.raise_error;

467: -- FETCH csr_bgr_date_from INTO l_bgr_date_from;
468: -- IF csr_bgr_date_from%notfound THEN
469: -- CLOSE csr_bgr_date_from;
470: -- hr_utility.set_message(800, 'HR_51491_ESA_BUS_GRP_ID_FK2');
471: -- hr_utility.raise_error;
472: -- END IF;
473: -- CLOSE csr_bgr_date_from;
474: --
475: -- If found, date_from must be greater or equal to business group

Line 479: -- hr_utility.set_message(800, 'HR_52757_INV_DATE_FROM');

475: -- If found, date_from must be greater or equal to business group
476: -- date_from.
477: --
478: -- IF p_date_from < l_bgr_date_from THEN
479: -- hr_utility.set_message(800, 'HR_52757_INV_DATE_FROM');
480: -- hr_utility.raise_error;
481: -- END IF;
482: --
483: -- hr_utility.set_location('Leaving:'||l_proc, 30);

Line 480: -- hr_utility.raise_error;

476: -- date_from.
477: --
478: -- IF p_date_from < l_bgr_date_from THEN
479: -- hr_utility.set_message(800, 'HR_52757_INV_DATE_FROM');
480: -- hr_utility.raise_error;
481: -- END IF;
482: --
483: -- hr_utility.set_location('Leaving:'||l_proc, 30);
484: --

Line 483: -- hr_utility.set_location('Leaving:'||l_proc, 30);

479: -- hr_utility.set_message(800, 'HR_52757_INV_DATE_FROM');
480: -- hr_utility.raise_error;
481: -- END IF;
482: --
483: -- hr_utility.set_location('Leaving:'||l_proc, 30);
484: --
485: --END chk_date_from;
486: --
487: -- ----------------------------------------------------------------------------

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

515: where (o.name = p_name OR o.organization_id = p_organization_id);
516:
517: BEGIN
518: --
519: hr_utility.set_location('Entering:'|| l_proc, 10);
520: --
521: p_duplicate_org_warning := false;
522: l_is_business_group := false;
523: l_duplicate_bg := false;

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

528: ,p_argument_value => p_name
529: );
530: --
531: --
532: hr_utility.set_location(l_proc, 20);
533: --
534: --
535: -- Check organization name uniqueness throughout business groups if
536: -- Cross business profile option is set to Y

Line 566: hr_utility.set_message(800, 'HR_52751_DUPL_NAME'); -- raise error

562: p_duplicate_org_warning :=TRUE;
563: end if;
564:
565: if (crec.business_group_id = p_business_group_id) then -- if not current row but in same business group
566: hr_utility.set_message(800, 'HR_52751_DUPL_NAME'); -- raise error
567: hr_utility.raise_error;
568: end if;
569:
570: end if;

Line 567: hr_utility.raise_error;

563: end if;
564:
565: if (crec.business_group_id = p_business_group_id) then -- if not current row but in same business group
566: hr_utility.set_message(800, 'HR_52751_DUPL_NAME'); -- raise error
567: hr_utility.raise_error;
568: end if;
569:
570: end if;
571: end loop;

Line 574: hr_utility.set_message(800, 'HR_289381_DUPLICATE_BG');-- and a different bg with the same name exists

570: end if;
571: end loop;
572:
573: if l_is_business_group and l_duplicate_bg then -- using flags set above, if current row is a BG
574: hr_utility.set_message(800, 'HR_289381_DUPLICATE_BG');-- and a different bg with the same name exists
575: hr_utility.raise_error; -- raise the duplicate BG error
576: end if;
577: --
578: --

Line 575: hr_utility.raise_error; -- raise the duplicate BG error

571: end loop;
572:
573: if l_is_business_group and l_duplicate_bg then -- using flags set above, if current row is a BG
574: hr_utility.set_message(800, 'HR_289381_DUPLICATE_BG');-- and a different bg with the same name exists
575: hr_utility.raise_error; -- raise the duplicate BG error
576: end if;
577: --
578: --
579: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 579: hr_utility.set_location('Leaving:'||l_proc, 30);

575: hr_utility.raise_error; -- raise the duplicate BG error
576: end if;
577: --
578: --
579: hr_utility.set_location('Leaving:'||l_proc, 30);
580: --
581: END chk_name;
582: --
583: -- ----------------------------------------------------------------------------

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

623: WHERE soft_coding_keyflex_id = p_soft_coding_keyflex_id;
624: --
625: BEGIN
626: --
627: hr_utility.set_location('Entering:'|| l_proc, 10);
628: --
629: --
630: -- Check soft_coding_keyflex_id uniqueness
631: --

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

632: IF p_soft_coding_keyflex_id IS NOT null THEN
633: OPEN csr_soft_coding_keyflex_id;
634: FETCH csr_soft_coding_keyflex_id INTO l_exists;
635: --
636: hr_utility.set_location(l_proc, 20);
637: --
638: IF csr_soft_coding_keyflex_id%notfound THEN
639: CLOSE csr_soft_coding_keyflex_id;
640: hr_utility.set_message(800, 'HR_52754_INV_SCL_ID');

Line 640: hr_utility.set_message(800, 'HR_52754_INV_SCL_ID');

636: hr_utility.set_location(l_proc, 20);
637: --
638: IF csr_soft_coding_keyflex_id%notfound THEN
639: CLOSE csr_soft_coding_keyflex_id;
640: hr_utility.set_message(800, 'HR_52754_INV_SCL_ID');
641: hr_utility.raise_error;
642: ELSE
643: CLOSE csr_soft_coding_keyflex_id;
644: END IF;

Line 641: hr_utility.raise_error;

637: --
638: IF csr_soft_coding_keyflex_id%notfound THEN
639: CLOSE csr_soft_coding_keyflex_id;
640: hr_utility.set_message(800, 'HR_52754_INV_SCL_ID');
641: hr_utility.raise_error;
642: ELSE
643: CLOSE csr_soft_coding_keyflex_id;
644: END IF;
645: END IF;

Line 648: hr_utility.set_location('Leaving:'||l_proc, 30);

644: END IF;
645: END IF;
646: --
647: --
648: hr_utility.set_location('Leaving:'||l_proc, 30);
649: --
650: END chk_soft_coding_kf;
651: --
652: -- ----------------------------------------------------------------------------

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

700: AND pbg.cost_allocation_structure = to_char(pcak.id_flex_num);
701: --
702: BEGIN
703: --
704: hr_utility.set_location('Entering:'|| l_proc, 10);
705: --
706: -- Check cost_allocation_keyflex_id uniqueness
707: --
708: IF p_cost_allocation_keyflex_id IS NOT NULL THEN

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

716: --
717: OPEN csr_cost_allocation_keyflex_id;
718: FETCH csr_cost_allocation_keyflex_id INTO l_exists;
719: --
720: hr_utility.set_location(l_proc, 20);
721: --
722: IF csr_cost_allocation_keyflex_id%notfound THEN
723: --
724: CLOSE csr_cost_allocation_keyflex_id;

Line 725: hr_utility.set_location(l_proc, 21);

721: --
722: IF csr_cost_allocation_keyflex_id%notfound THEN
723: --
724: CLOSE csr_cost_allocation_keyflex_id;
725: hr_utility.set_location(l_proc, 21);
726: hr_utility.set_message(800, 'HR_52755_INV_COST_ID');
727: hr_utility.raise_error;
728: --
729: ELSE

Line 726: hr_utility.set_message(800, 'HR_52755_INV_COST_ID');

722: IF csr_cost_allocation_keyflex_id%notfound THEN
723: --
724: CLOSE csr_cost_allocation_keyflex_id;
725: hr_utility.set_location(l_proc, 21);
726: hr_utility.set_message(800, 'HR_52755_INV_COST_ID');
727: hr_utility.raise_error;
728: --
729: ELSE
730: --

Line 727: hr_utility.raise_error;

723: --
724: CLOSE csr_cost_allocation_keyflex_id;
725: hr_utility.set_location(l_proc, 21);
726: hr_utility.set_message(800, 'HR_52755_INV_COST_ID');
727: hr_utility.raise_error;
728: --
729: ELSE
730: --
731: CLOSE csr_cost_allocation_keyflex_id;

Line 752: hr_utility.set_location(l_proc, 22);

748: AND org_information2 = 'Y';
749: --
750: IF l_count = 0 THEN
751: --
752: hr_utility.set_location(l_proc, 22);
753: hr_utility.set_message(800, 'HR_289484_INV_ORG_COST_ID');
754: hr_utility.raise_error;
755: --
756: END IF;

Line 753: hr_utility.set_message(800, 'HR_289484_INV_ORG_COST_ID');

749: --
750: IF l_count = 0 THEN
751: --
752: hr_utility.set_location(l_proc, 22);
753: hr_utility.set_message(800, 'HR_289484_INV_ORG_COST_ID');
754: hr_utility.raise_error;
755: --
756: END IF;
757: --

Line 754: hr_utility.raise_error;

750: IF l_count = 0 THEN
751: --
752: hr_utility.set_location(l_proc, 22);
753: hr_utility.set_message(800, 'HR_289484_INV_ORG_COST_ID');
754: hr_utility.raise_error;
755: --
756: END IF;
757: --
758: END IF;

Line 763: hr_utility.set_location('Leaving:'||l_proc, 30);

759: --
760: END IF;
761: --
762: --
763: hr_utility.set_location('Leaving:'||l_proc, 30);
764: --
765: END chk_cost_alloc_kf;
766: --
767: -- ----------------------------------------------------------------------------

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

807: WHERE location_id = p_location_id;
808: --
809: BEGIN
810: --
811: hr_utility.set_location('Entering:'|| l_proc, 10);
812: --
813: --
814: -- Check location_id uniqueness
815: --

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

816: IF p_location_id IS NOT null THEN
817: OPEN csr_location_id;
818: FETCH csr_location_id INTO l_exists;
819: --
820: hr_utility.set_location(l_proc, 20);
821: --
822: IF csr_location_id%notfound THEN
823: CLOSE csr_location_id;
824: hr_utility.set_message(800, 'HR_52756_INV_LOC_ID');

Line 824: hr_utility.set_message(800, 'HR_52756_INV_LOC_ID');

820: hr_utility.set_location(l_proc, 20);
821: --
822: IF csr_location_id%notfound THEN
823: CLOSE csr_location_id;
824: hr_utility.set_message(800, 'HR_52756_INV_LOC_ID');
825: hr_utility.raise_error;
826: ELSE
827: CLOSE csr_location_id;
828: END IF;

Line 825: hr_utility.raise_error;

821: --
822: IF csr_location_id%notfound THEN
823: CLOSE csr_location_id;
824: hr_utility.set_message(800, 'HR_52756_INV_LOC_ID');
825: hr_utility.raise_error;
826: ELSE
827: CLOSE csr_location_id;
828: END IF;
829: END IF;

Line 832: hr_utility.set_location('Leaving:'||l_proc, 30);

828: END IF;
829: END IF;
830: --
831: --
832: hr_utility.set_location('Leaving:'||l_proc, 30);
833: --
834: END chk_location_id;
835: --
836: -- ----------------------------------------------------------------------------

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

882: AND nvl(end_date_active,p_effective_date);
883: --
884: BEGIN
885: --
886: hr_utility.set_location('Entering:'|| l_proc, 10);
887: --
888: --
889: -- Check location_id uniqueness
890: --

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

891: IF p_type IS NOT null THEN
892: OPEN csr_type;
893: FETCH csr_type INTO l_exists;
894: --
895: hr_utility.set_location(l_proc, 20);
896: --
897: IF csr_type%notfound THEN
898: CLOSE csr_type;
899: hr_utility.set_message(800, 'HR_52752_INV_ORG_TYPE');

Line 899: hr_utility.set_message(800, 'HR_52752_INV_ORG_TYPE');

895: hr_utility.set_location(l_proc, 20);
896: --
897: IF csr_type%notfound THEN
898: CLOSE csr_type;
899: hr_utility.set_message(800, 'HR_52752_INV_ORG_TYPE');
900: hr_utility.raise_error;
901: ELSE
902: CLOSE csr_type;
903: END IF;

Line 900: hr_utility.raise_error;

896: --
897: IF csr_type%notfound THEN
898: CLOSE csr_type;
899: hr_utility.set_message(800, 'HR_52752_INV_ORG_TYPE');
900: hr_utility.raise_error;
901: ELSE
902: CLOSE csr_type;
903: END IF;
904: END IF;

Line 907: hr_utility.set_location('Leaving:'||l_proc, 30);

903: END IF;
904: END IF;
905: --
906: --
907: hr_utility.set_location('Leaving:'||l_proc, 30);
908: --
909: END chk_type;
910: --
911: --

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

958: AND nvl(end_date_active,p_effective_date);
959: --
960: BEGIN
961: --
962: hr_utility.set_location('Entering:'|| l_proc, 10);
963: --
964: --
965: -- Bug 4319315
966: if (hr_oru_shd.g_old_rec.internal_external_flag is not null

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

978: IF p_internal_external_flag IS NOT null THEN
979: OPEN csr_internal_external_flag;
980: FETCH csr_internal_external_flag INTO l_exists;
981: --
982: hr_utility.set_location(l_proc, 20);
983: --
984: IF csr_internal_external_flag%notfound THEN
985: CLOSE csr_internal_external_flag;
986: hr_utility.set_message(800, 'HR_52753_INV_ORG_INT_EXT_FLAG');

Line 986: hr_utility.set_message(800, 'HR_52753_INV_ORG_INT_EXT_FLAG');

982: hr_utility.set_location(l_proc, 20);
983: --
984: IF csr_internal_external_flag%notfound THEN
985: CLOSE csr_internal_external_flag;
986: hr_utility.set_message(800, 'HR_52753_INV_ORG_INT_EXT_FLAG');
987: hr_utility.raise_error;
988: ELSE
989: CLOSE csr_internal_external_flag;
990: END IF;

Line 987: hr_utility.raise_error;

983: --
984: IF csr_internal_external_flag%notfound THEN
985: CLOSE csr_internal_external_flag;
986: hr_utility.set_message(800, 'HR_52753_INV_ORG_INT_EXT_FLAG');
987: hr_utility.raise_error;
988: ELSE
989: CLOSE csr_internal_external_flag;
990: END IF;
991: END IF;

Line 994: hr_utility.set_location('Leaving:'||l_proc, 30);

990: END IF;
991: END IF;
992: --
993: --
994: hr_utility.set_location('Leaving:'||l_proc, 30);
995: --
996: END chk_int_ext_flag;
997: --
998: --

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

1033: l_exists VARCHAR2(1) := 'N';
1034: --
1035: BEGIN
1036: --
1037: hr_utility.set_location('Entering:'|| l_proc, 10);
1038: --
1039: --
1040: -- Check classification presence
1041: --

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

1055: EXCEPTION
1056: WHEN NO_DATA_FOUND THEN null;
1057: END;
1058: --
1059: hr_utility.set_location(l_proc, 20);
1060: --
1061: IF l_exists = 'Y' THEN
1062: hr_utility.set_message(800, 'HR_52758_ORG_HAS_CLSF');
1063: hr_utility.raise_error;

Line 1062: hr_utility.set_message(800, 'HR_52758_ORG_HAS_CLSF');

1058: --
1059: hr_utility.set_location(l_proc, 20);
1060: --
1061: IF l_exists = 'Y' THEN
1062: hr_utility.set_message(800, 'HR_52758_ORG_HAS_CLSF');
1063: hr_utility.raise_error;
1064: END IF;
1065: --
1066: --

Line 1063: hr_utility.raise_error;

1059: hr_utility.set_location(l_proc, 20);
1060: --
1061: IF l_exists = 'Y' THEN
1062: hr_utility.set_message(800, 'HR_52758_ORG_HAS_CLSF');
1063: hr_utility.raise_error;
1064: END IF;
1065: --
1066: --
1067: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 1067: hr_utility.set_location('Leaving:'||l_proc, 30);

1063: hr_utility.raise_error;
1064: END IF;
1065: --
1066: --
1067: hr_utility.set_location('Leaving:'||l_proc, 30);
1068: --
1069: END chk_org_delete;
1070: --
1071: -- ----------------------------------------------------------------------------

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

1079: --
1080: l_proc varchar2(72) := g_package||'insert_validate';
1081: --
1082: Begin
1083: hr_utility.set_location('Entering:'||l_proc, 5);
1084: --
1085: -- Call all supporting business operations
1086: --
1087: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1086: --
1087: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1088: --
1089: --
1090: hr_utility.set_location('Entering:'||l_proc, 10);
1091: --
1092: --
1093: -- Validate name
1094: -- =================

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

1099: p_business_group_id => p_rec.business_group_id,
1100: p_duplicate_org_warning => p_duplicate_org_warning
1101: );
1102: --
1103: hr_utility.set_location(l_proc, 20);
1104: --
1105: -- Validate date_from
1106: -- ======================
1107: -- chk_date_from

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

1110: -- p_business_group_id => p_rec.business_group_id
1111: -- );
1112: --
1113: --
1114: hr_utility.set_location(l_proc, 30);
1115: --
1116: -- Validate soft_coding_keyflex_id
1117: -- =======================
1118: chk_soft_coding_kf

Line 1121: hr_utility.set_location(l_proc, 40);

1117: -- =======================
1118: chk_soft_coding_kf
1119: (p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id);
1120: --
1121: hr_utility.set_location(l_proc, 40);
1122: -- Validate cost_allocation_keyflex_id
1123: -- =======================
1124: chk_cost_alloc_kf
1125: (p_organization_id => p_rec.organization_id,

Line 1129: hr_utility.set_location(l_proc, 50);

1125: (p_organization_id => p_rec.organization_id,
1126: p_business_group_id => p_rec.business_group_id,
1127: p_cost_allocation_keyflex_id => p_rec.cost_allocation_keyflex_id);
1128: --
1129: hr_utility.set_location(l_proc, 50);
1130: -- Validate location_id
1131: -- =======================
1132: chk_location_id
1133: (p_location_id => p_rec.location_id);

Line 1135: hr_utility.set_location(l_proc, 60);

1131: -- =======================
1132: chk_location_id
1133: (p_location_id => p_rec.location_id);
1134: --
1135: hr_utility.set_location(l_proc, 60);
1136: --
1137: -- Validate type
1138: -- ======================
1139: chk_type

Line 1143: hr_utility.set_location(l_proc, 70);

1139: chk_type
1140: (p_type => p_rec.type,
1141: p_effective_date => p_effective_date);
1142: --
1143: hr_utility.set_location(l_proc, 70);
1144: --
1145: -- Validate type
1146: -- ======================
1147: chk_int_ext_flag

Line 1151: hr_utility.set_location(l_proc, 80);

1147: chk_int_ext_flag
1148: (p_internal_external_flag => p_rec.internal_external_flag,
1149: p_effective_date => p_effective_date);
1150: --
1151: hr_utility.set_location(l_proc, 80);
1152: --
1153: --
1154: hr_oru_bus.chk_df(p_rec);
1155: --

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

1152: --
1153: --
1154: hr_oru_bus.chk_df(p_rec);
1155: --
1156: hr_utility.set_location(' Leaving:'||l_proc, 40);
1157: End insert_validate;
1158: --
1159: -- ----------------------------------------------------------------------------
1160: -- |---------------------------< update_validate >----------------------------|

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

1167: --
1168: l_proc varchar2(72) := g_package||'update_validate';
1169: --
1170: Begin
1171: hr_utility.set_location('Entering:'||l_proc, 5);
1172: --
1173: -- Call all supporting business operations
1174: --
1175: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1179: ,p_rec => p_rec
1180: );
1181: --
1182: --
1183: hr_utility.set_location(l_proc, 20);
1184: --
1185: -- Validate date_from
1186: -- ======================
1187: -- chk_date_from

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

1190: -- p_business_group_id => p_rec.business_group_id
1191: -- );
1192: --
1193: --
1194: hr_utility.set_location(l_proc, 30);
1195: --
1196: -- Validate soft_coding_keyflex_id
1197: -- =======================
1198: chk_soft_coding_kf

Line 1201: hr_utility.set_location(l_proc, 40);

1197: -- =======================
1198: chk_soft_coding_kf
1199: (p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id);
1200: --
1201: hr_utility.set_location(l_proc, 40);
1202: -- Validate cost_allocation_keyflex_id
1203: -- =======================
1204: chk_cost_alloc_kf
1205: (p_organization_id => p_rec.organization_id,

Line 1209: hr_utility.set_location(l_proc, 50);

1205: (p_organization_id => p_rec.organization_id,
1206: p_business_group_id => p_rec.business_group_id,
1207: p_cost_allocation_keyflex_id => p_rec.cost_allocation_keyflex_id);
1208: --
1209: hr_utility.set_location(l_proc, 50);
1210: -- Validate location_id
1211: -- =======================
1212: chk_location_id
1213: (p_location_id => p_rec.location_id);

Line 1221: hr_utility.set_location(l_proc, 60);

1217: ,p_effective_date => p_effective_date
1218: ,p_business_group_id => p_rec.business_group_id
1219: ,p_organization_id => p_rec.organization_id
1220: ,p_duplicate_org_warning => p_duplicate_org_warning );
1221: hr_utility.set_location(l_proc, 60);
1222: --
1223: -- Validate type
1224: -- ======================
1225: chk_type

Line 1229: hr_utility.set_location(l_proc, 70);

1225: chk_type
1226: (p_type => p_rec.type,
1227: p_effective_date => p_effective_date);
1228: --
1229: hr_utility.set_location(l_proc, 70);
1230: --
1231: -- Validate type
1232: -- ======================
1233: chk_int_ext_flag

Line 1237: hr_utility.set_location(l_proc, 80);

1233: chk_int_ext_flag
1234: (p_internal_external_flag => p_rec.internal_external_flag,
1235: p_effective_date => p_effective_date);
1236: --
1237: hr_utility.set_location(l_proc, 80);
1238: --
1239: --
1240: hr_oru_bus.chk_df(p_rec);
1241: --

Line 1242: hr_utility.set_location(' Leaving:'||l_proc, 100);

1238: --
1239: --
1240: hr_oru_bus.chk_df(p_rec);
1241: --
1242: hr_utility.set_location(' Leaving:'||l_proc, 100);
1243: End update_validate;
1244: --
1245: -- ----------------------------------------------------------------------------
1246: -- |---------------------------< delete_validate >----------------------------|

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

1260: l_industry varchar2(1);
1261: -- End of fix for bug 2881808
1262: --
1263: Begin
1264: hr_utility.set_location('Entering:'||l_proc, 5);
1265: --
1266: -- Get the Business Group id.
1267: --
1268: select business_group_id

Line 1273: hr_utility.set_location(l_proc, 10);

1269: into l_bg_id
1270: from hr_all_organization_units
1271: where organization_id = p_rec.organization_id;
1272: --
1273: hr_utility.set_location(l_proc, 10);
1274: --
1275: -- Call all supporting business operations
1276: --
1277: -- Validate classification exists

Line 1282: hr_utility.set_location(l_proc, 15);

1278: -- =======================
1279: chk_org_delete
1280: (p_organization_id => p_rec.organization_id);
1281: --
1282: hr_utility.set_location(l_proc, 15);
1283: --
1284: -- Start of fix for bug 2881808
1285: --
1286: -- Validate Job and Position exists

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

1286: -- Validate Job and Position exists
1287: -- =================================
1288: hr_job_pos.hr_jp_predelete(p_rec.organization_id,
1289: l_bg_id);
1290: hr_utility.set_location(l_proc, 20);
1291: --
1292: -- Validate Person, Org and Hierarchies exists
1293: -- ===========================================
1294: hr_organization.org_predel_check(p_rec.organization_id,

Line 1296: hr_utility.set_location(l_proc, 25);

1292: -- Validate Person, Org and Hierarchies exists
1293: -- ===========================================
1294: hr_organization.org_predel_check(p_rec.organization_id,
1295: l_bg_id);
1296: hr_utility.set_location(l_proc, 25);
1297: --
1298: -- Product specific validations
1299: -- ============================
1300:

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

1307: pa_org.pa_predel_validation(p_rec.organization_id);
1308: null;
1309: end if;
1310: pa_org.pa_org_predel_validation(p_rec.organization_id);
1311: hr_utility.set_location(l_proc, 30);
1312: --
1313: -- Inventory INV
1314: l_installed := fnd_installation.get(appl_id => 401
1315: ,dep_appl_id => 401

Line 1321: hr_utility.set_location(l_proc, 35);

1317: ,industry => l_industry);
1318: if l_inv_installed <> 'N' then
1319: inv_org.inv_predel_validation(p_rec.organization_id);
1320: end if;
1321: hr_utility.set_location(l_proc, 35);
1322: --
1323: -- Training OTA
1324: if p_rec.organization_id is not null then
1325: per_ota_predel_validation.ota_predel_org_validation(p_rec.organization_id);

Line 1328: hr_utility.set_location(l_proc, 40);

1324: if p_rec.organization_id is not null then
1325: per_ota_predel_validation.ota_predel_org_validation(p_rec.organization_id);
1326: else null;
1327: end if;
1328: hr_utility.set_location(l_proc, 40);
1329: --
1330: -- Engineering Eng
1331: l_installed := fnd_installation.get(appl_id => 703
1332: ,dep_appl_id => 703

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

1336: null;
1337: eng_org.eng_predel_validation(p_rec.organization_id);
1338: end if;
1339: -- End of fix for bug 2881808
1340: hr_utility.set_location(' Leaving:'||l_proc, 10);
1341: End delete_validate;
1342: --
1343: end hr_oru_bus;