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 101: hr_utility.set_location('Entering:'|| l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 472: -- hr_utility.raise_error;

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

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

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

Line 481: -- hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 568: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 642: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 728: hr_utility.raise_error;

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

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

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

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

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

Line 755: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 826: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 901: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 988: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 1064: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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