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.

[Home] [Help]

APPS.HR_ORI_BUS dependencies on HR_UTILITY

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

42: l_proc varchar2(72) := g_package||'set_security_group_id';
43: --
44: begin
45: --
46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error

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

73: hr_api.set_security_group_id
74: (p_security_group_id => l_security_group_id
75: );
76: --
77: hr_utility.set_location(' Leaving:'|| l_proc, 20);
78: --
79: end set_security_group_id;
80: --
81: -- ----------------------------------------------------------------------------

Line 125: hr_utility.set_location(' Entering:'|| l_proc, 20);

121: l_c1 c1%rowtype;
122: --
123: begin
124: --
125: hr_utility.set_location(' Entering:'|| l_proc, 20);
126: --
127: -- Rules are as follows
128: -- If record being inserted or updated is before the earliest start
129: -- date then compare end date to previous earliest start date.

Line 139: hr_utility.set_location(' Leaving:'|| l_proc, 11);

135: -- This is only relevant for Organization Name Alias context
136: --
137: if p_org_information_context <> 'Organization Name Alias' then
138: --
139: hr_utility.set_location(' Leaving:'|| l_proc, 11);
140: return false;
141: --
142: end if;
143: --

Line 159: hr_utility.set_location(' Leaving:'|| l_proc, 12);

155: -- This results in a gap, if its an overlap then it will be picked
156: -- up by the overlap business rule.
157: --
158: close c1;
159: hr_utility.set_location(' Leaving:'|| l_proc, 12);
160: return true;
161: --
162: end if;
163: --

Line 183: hr_utility.set_location(p_end_date|| l_proc, 13);

179: -- This results in a gap, if its an overlap then it will be picked
180: -- up by the overlap business rule.
181: --
182: close c2;
183: hr_utility.set_location(p_end_date|| l_proc, 13);
184: hr_utility.set_location(l_c2.min_start_date|| l_proc, 13);
185: hr_utility.set_location(' Leaving:'|| l_proc, 13);
186: return true;
187: --

Line 184: hr_utility.set_location(l_c2.min_start_date|| l_proc, 13);

180: -- up by the overlap business rule.
181: --
182: close c2;
183: hr_utility.set_location(p_end_date|| l_proc, 13);
184: hr_utility.set_location(l_c2.min_start_date|| l_proc, 13);
185: hr_utility.set_location(' Leaving:'|| l_proc, 13);
186: return true;
187: --
188: end if;

Line 185: hr_utility.set_location(' Leaving:'|| l_proc, 13);

181: --
182: close c2;
183: hr_utility.set_location(p_end_date|| l_proc, 13);
184: hr_utility.set_location(l_c2.min_start_date|| l_proc, 13);
185: hr_utility.set_location(' Leaving:'|| l_proc, 13);
186: return true;
187: --
188: end if;
189: --

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

190: end if;
191: --
192: close c2;
193: --
194: hr_utility.set_location(' Leaving:'|| l_proc, 20);
195: --
196: return false;
197: --
198: end chk_cost_center_gap;

Line 223: hr_utility.set_location(' Entering:'|| l_proc, 20);

219: l_end_date date;
220: --
221: begin
222: --
223: hr_utility.set_location(' Entering:'|| l_proc, 20);
224: --
225: -- Rules are as follows
226: -- Any record being inserted or updated must have a Start Date and if
227: -- entered the End Date must be on or after the Start Date.

Line 231: hr_utility.set_location(' Leaving:'|| l_proc, 11);

227: -- entered the End Date must be on or after the Start Date.
228: --
229: if p_org_information_context <> 'Organization Name Alias' then
230: --
231: hr_utility.set_location(' Leaving:'|| l_proc, 11);
232: return;
233: --
234: end if;
235: --

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

305: end if;
306: --
307: end if;
308: --
309: hr_utility.set_location(' Leaving:'|| l_proc, 20);
310: --
311: end chk_cost_center_start_date;
312: -- ----------------------------------------------------------------------------
313: -- |-------------------------< chk_cost_center_start_end_date >---------------|

Line 379: hr_utility.set_location(' Entering:'|| l_proc, 20);

375: l_c2 c2%rowtype;
376: --
377: begin
378: --
379: hr_utility.set_location(' Entering:'|| l_proc, 20);
380: --
381: -- Rules are as follows
382: -- Any Cost Center Manager being inserted or updated must have a Hire
383: -- Date that is on or before the Start Date and a Termination Date that

Line 390: hr_utility.set_location(' Leaving:'|| l_proc, 11);

386: -- This is only relevant for Organization Name Alias context
387: --
388: if p_org_information_context <> 'Organization Name Alias' then
389: --
390: hr_utility.set_location(' Leaving:'|| l_proc, 11);
391: return;
392: --
393: end if;
394: --

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

477: end if;
478: --
479: close c2;
480: --
481: hr_utility.set_location(' Leaving:'|| l_proc, 20);
482: --
483: end chk_cost_center_start_end_date;
484: -- ----------------------------------------------------------------------------
485: -- |-------------------------< chk_cost_center_valid >------------------------|

Line 521: hr_utility.set_location(' Entering:'|| l_proc, 20);

517: l_c1 c1%rowtype;
518: --
519: begin
520: --
521: hr_utility.set_location(' Entering:'|| l_proc, 20);
522: --
523: -- Rules are as follows
524: -- Any Cost Center that is being updated must be visible to the user
525: -- through the users security profile.

Line 531: hr_utility.set_location(' Leaving:'|| l_proc, 11);

527: -- This is only relevant for Organization Name Alias context
528: --
529: if p_org_information_context <> 'Organization Name Alias' then
530: --
531: hr_utility.set_location(' Leaving:'|| l_proc, 11);
532: return;
533: --
534: end if;
535: --

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

546: end if;
547: --
548: close c1;
549: --
550: hr_utility.set_location(' Leaving:'|| l_proc, 20);
551: --
552: end chk_cost_center_valid;
553: -- ----------------------------------------------------------------------------
554: -- |-------------------------< chk_cost_center_manager_valid >----------------|

Line 585: hr_utility.set_location(' Entering:'|| l_proc, 20);

581: l_c1 c1%rowtype;
582: --
583: begin
584: --
585: hr_utility.set_location(' Entering:'|| l_proc, 20);
586: --
587: -- Rules are as follows
588: -- Any Cost Center Manager that is being updated must be visible to the user
589: -- through the users security profile.

Line 595: hr_utility.set_location(' Leaving:'|| l_proc, 11);

591: -- This is only relevant for Organization Name Alias context
592: --
593: if p_org_information_context <> 'Organization Name Alias' then
594: --
595: hr_utility.set_location(' Leaving:'|| l_proc, 11);
596: return;
597: --
598: end if;
599: --

Line 604: hr_utility.set_location(' Leaving:'|| l_proc, 12);

600: -- Person can be nulled out if they are terminated for example.
601: --
602: if p_org_information2 is null then
603: --
604: hr_utility.set_location(' Leaving:'|| l_proc, 12);
605: return;
606: --
607: end if;
608: --

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

637: end if;
638: --
639: close c1;
640: --
641: hr_utility.set_location(' Leaving:'|| l_proc, 20);
642: --
643: end chk_cost_center_manager_valid;
644: -- ----------------------------------------------------------------------------
645: -- |-------------------------< chk_cost_center_man_overlap >------------------|

Line 700: hr_utility.set_location(' Entering:'|| l_proc, 20);

696: l_c2 c2%rowtype;
697: --
698: begin
699: --
700: hr_utility.set_location(' Entering:'|| l_proc, 20);
701: --
702: -- Rules are as follows
703: -- Any Cost Center Manager Relationship that is being updated must not
704: -- overlap another Cost Center Manager Relationship for the same

Line 711: hr_utility.set_location(' Leaving:'|| l_proc, 11);

707: -- This is only relevant for Organization Name Alias context
708: --
709: if p_org_information_context <> 'Organization Name Alias' then
710: --
711: hr_utility.set_location(' Leaving:'|| l_proc, 11);
712: return;
713: --
714: end if;
715: --

Line 760: hr_utility.set_location('Start Date '||l_start_date,10);

756: fnd_message.raise_error;
757: --
758: end;
759: --
760: hr_utility.set_location('Start Date '||l_start_date,10);
761: hr_utility.set_location('End Date '||l_end_date,10);
762: hr_utility.set_location('Organization_id '||p_organization_id,10);
763: hr_utility.set_location('Org_information_id '||p_org_information_id,10);
764: --

Line 761: hr_utility.set_location('End Date '||l_end_date,10);

757: --
758: end;
759: --
760: hr_utility.set_location('Start Date '||l_start_date,10);
761: hr_utility.set_location('End Date '||l_end_date,10);
762: hr_utility.set_location('Organization_id '||p_organization_id,10);
763: hr_utility.set_location('Org_information_id '||p_org_information_id,10);
764: --
765: open c1;

Line 762: hr_utility.set_location('Organization_id '||p_organization_id,10);

758: end;
759: --
760: hr_utility.set_location('Start Date '||l_start_date,10);
761: hr_utility.set_location('End Date '||l_end_date,10);
762: hr_utility.set_location('Organization_id '||p_organization_id,10);
763: hr_utility.set_location('Org_information_id '||p_org_information_id,10);
764: --
765: open c1;
766: --

Line 763: hr_utility.set_location('Org_information_id '||p_org_information_id,10);

759: --
760: hr_utility.set_location('Start Date '||l_start_date,10);
761: hr_utility.set_location('End Date '||l_end_date,10);
762: hr_utility.set_location('Organization_id '||p_organization_id,10);
763: hr_utility.set_location('Org_information_id '||p_org_information_id,10);
764: --
765: open c1;
766: --
767: fetch c1 into l_c1;

Line 781: hr_utility.set_location('Start Date '||l_start_date,10);

777: open c2;
778: --
779: fetch c2 into l_c2;
780: --
781: hr_utility.set_location('Start Date '||l_start_date,10);
782: hr_utility.set_location('End Date '||l_end_date,10);
783: hr_utility.set_location('Org Start Date '||l_c2.date_from,10);
784: hr_utility.set_location('Org End Date '||l_c2.date_to,10);
785: --

Line 782: hr_utility.set_location('End Date '||l_end_date,10);

778: --
779: fetch c2 into l_c2;
780: --
781: hr_utility.set_location('Start Date '||l_start_date,10);
782: hr_utility.set_location('End Date '||l_end_date,10);
783: hr_utility.set_location('Org Start Date '||l_c2.date_from,10);
784: hr_utility.set_location('Org End Date '||l_c2.date_to,10);
785: --
786: -- Removed the check for end date for fix of #3137148.

Line 783: hr_utility.set_location('Org Start Date '||l_c2.date_from,10);

779: fetch c2 into l_c2;
780: --
781: hr_utility.set_location('Start Date '||l_start_date,10);
782: hr_utility.set_location('End Date '||l_end_date,10);
783: hr_utility.set_location('Org Start Date '||l_c2.date_from,10);
784: hr_utility.set_location('Org End Date '||l_c2.date_to,10);
785: --
786: -- Removed the check for end date for fix of #3137148.
787: --

Line 784: hr_utility.set_location('Org End Date '||l_c2.date_to,10);

780: --
781: hr_utility.set_location('Start Date '||l_start_date,10);
782: hr_utility.set_location('End Date '||l_end_date,10);
783: hr_utility.set_location('Org Start Date '||l_c2.date_from,10);
784: hr_utility.set_location('Org End Date '||l_c2.date_to,10);
785: --
786: -- Removed the check for end date for fix of #3137148.
787: --
788: if l_start_date < l_c2.date_from then

Line 790: hr_utility.set_location(' Rel. ship start date is before Org start date '|| l_proc, 15);

786: -- Removed the check for end date for fix of #3137148.
787: --
788: if l_start_date < l_c2.date_from then
789: --
790: hr_utility.set_location(' Rel. ship start date is before Org start date '|| l_proc, 15);
791: close c2;
792: --
793: fnd_message.set_name('PER','PER_449079_CCM_BEFORE_ORG');
794: fnd_message.raise_error;

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

796: end if;
797: --
798: close c2;
799: --
800: hr_utility.set_location(' Leaving:'|| l_proc, 20);
801: --
802: end chk_cost_center_man_overlap;
803: -- ---------------------------------------------------------------------------
804: -- |---------------------< return_legislation_code >-------------------------|

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

832: l_proc varchar2(72) := g_package||'return_legislation_code';
833: --
834: Begin
835: --
836: hr_utility.set_location('Entering:'|| l_proc, 10);
837: --
838: -- Ensure that all the mandatory parameter are not null
839: --
840: hr_api.mandatory_arg_error

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

850: -- call to this function. Just return the value in the global
851: -- variable.
852: --
853: l_legislation_code := hr_ori_bus.g_legislation_code;
854: hr_utility.set_location(l_proc, 20);
855: else
856: --
857: -- The ID is different to the last call to this function
858: -- or this is the first call to this function.

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

867: close csr_leg_code;
868: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
869: fnd_message.raise_error;
870: end if;
871: hr_utility.set_location(l_proc,30);
872: --
873: -- Set the global variables so the values are
874: -- available for the next call to this function.
875: --

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

876: close csr_leg_code;
877: hr_ori_bus.g_org_information_id:= p_org_information_id;
878: hr_ori_bus.g_legislation_code := l_legislation_code;
879: end if;
880: hr_utility.set_location(' Leaving:'|| l_proc, 40);
881: return l_legislation_code;
882: end return_legislation_code;
883: -- ----------------------------------------------------------------------------
884: -- |-------------------------< chk_name >-------------------------------------|

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

903: l_name hr_all_organization_units.name%TYPE;
904: l_exists number;
905: BEGIN
906: --
907: hr_utility.set_location('Entering:'|| l_proc, 10);
908: --
909: --
910: --
911: hr_utility.set_location(l_proc, 20);

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

907: hr_utility.set_location('Entering:'|| l_proc, 10);
908: --
909: --
910: --
911: hr_utility.set_location(l_proc, 20);
912: --
913: --
914: -- Check that the business group name is unique if we are adding or updating to
915: -- a business group classification

Line 933: hr_utility.set_message(800, 'HR_289381_DUPLICATE_BG');

929: and i.org_information_context='CLASS'
930: and i.org_information2 ='Y'
931: and u.name = l_name;
932: if l_exists >0 then
933: hr_utility.set_message(800, 'HR_289381_DUPLICATE_BG');
934: hr_utility.raise_error;
935: end if;
936: end if;
937: exception

Line 934: hr_utility.raise_error;

930: and i.org_information2 ='Y'
931: and u.name = l_name;
932: if l_exists >0 then
933: hr_utility.set_message(800, 'HR_289381_DUPLICATE_BG');
934: hr_utility.raise_error;
935: end if;
936: end if;
937: exception
938: when no_data_found then

Line 939: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');

935: end if;
936: end if;
937: exception
938: when no_data_found then
939: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');
940: hr_utility.raise_error;
941:
942: end chk_name;
943:

Line 940: hr_utility.raise_error;

936: end if;
937: exception
938: when no_data_found then
939: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');
940: hr_utility.raise_error;
941:
942: end chk_name;
943:
944: -- ----------------------------------------------------------------------------

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

975: --
976: l_proc varchar2(72) := g_package || 'chk_ddf';
977: --
978: begin
979: hr_utility.set_location('Entering:'||l_proc,10);
980: --
981: if ((p_rec.org_information_id is not null) and (
982: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>
983: nvl(p_rec.org_information_id, hr_api.g_number) or

Line 1033: hr_utility.set_location('context = '||p_rec.org_information_context,20);

1029: -- a) During update, the structure column value or any
1030: -- of the attribute values have actually changed.
1031: -- b) During insert.
1032: --
1033: hr_utility.set_location('context = '||p_rec.org_information_context,20);
1034: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1035: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1036: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1037: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);

Line 1034: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);

1030: -- of the attribute values have actually changed.
1031: -- b) During insert.
1032: --
1033: hr_utility.set_location('context = '||p_rec.org_information_context,20);
1034: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1035: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1036: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1037: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);
1038: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);

Line 1035: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);

1031: -- b) During insert.
1032: --
1033: hr_utility.set_location('context = '||p_rec.org_information_context,20);
1034: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1035: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1036: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1037: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);
1038: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);
1039:

Line 1036: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);

1032: --
1033: hr_utility.set_location('context = '||p_rec.org_information_context,20);
1034: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1035: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1036: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1037: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);
1038: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);
1039:
1040: /*

Line 1037: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);

1033: hr_utility.set_location('context = '||p_rec.org_information_context,20);
1034: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1035: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1036: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1037: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);
1038: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);
1039:
1040: /*
1041: ** Some valuesets used by this flexfield require additional information

Line 1038: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);

1034: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1035: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1036: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1037: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);
1038: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);
1039:
1040: /*
1041: ** Some valuesets used by this flexfield require additional information
1042: ** this will be passed using profile options. We will create these and

Line 1048: hr_utility.set_location('PER_ORG_INFORMATION_ID'||

1044: */
1045: fnd_profile.put('PER_ORGANIZATION_ID',p_rec.organization_id);
1046: fnd_profile.put('PER_ORG_INFORMATION_ID',
1047: nvl(to_number(p_rec.org_information_id),-1));
1048: hr_utility.set_location('PER_ORG_INFORMATION_ID'||
1049: fnd_profile.value('PER_ORG_INFORMATION_ID'),80);
1050: hr_utility.set_location('PER_ORGANIZATION_ID'||
1051: fnd_profile.value('PER_ORGANIZATION_ID'),80);
1052:

Line 1050: hr_utility.set_location('PER_ORGANIZATION_ID'||

1046: fnd_profile.put('PER_ORG_INFORMATION_ID',
1047: nvl(to_number(p_rec.org_information_id),-1));
1048: hr_utility.set_location('PER_ORG_INFORMATION_ID'||
1049: fnd_profile.value('PER_ORG_INFORMATION_ID'),80);
1050: hr_utility.set_location('PER_ORGANIZATION_ID'||
1051: fnd_profile.value('PER_ORGANIZATION_ID'),80);
1052:
1053: hr_dflex_utility.ins_or_upd_descflex_attribs
1054: (p_appl_short_name => 'PER'

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

1096: ,p_attribute20_value => p_rec.org_information20
1097: );
1098: end if;
1099: --
1100: hr_utility.set_location(' Leaving:'||l_proc,100);
1101: end chk_ddf;
1102: --
1103: -- ----------------------------------------------------------------------------
1104: -- |------------------------------< chk_df >----------------------------------|

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

1134: --
1135: l_proc varchar2(72) := g_package || 'chk_df';
1136: --
1137: begin
1138: hr_utility.set_location('Entering:'||l_proc,10);
1139: --
1140: if ((p_rec.org_information_id is not null) and (
1141: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1142: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1233: ,p_attribute20_value => p_rec.attribute20
1234: );
1235: end if;
1236: --
1237: hr_utility.set_location(' Leaving:'||l_proc,20);
1238: end chk_df;
1239: --
1240: -- ----------------------------------------------------------------------------
1241: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1347: l_exists VARCHAR2(1) := 'N';
1348: --
1349: BEGIN
1350: --
1351: hr_utility.set_location('Entering:'|| l_proc, 10);
1352: --
1353: --
1354: -- Check organization_id presence
1355: --

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

1364: EXCEPTION
1365: WHEN NO_DATA_FOUND THEN NULL;
1366: END;
1367: --
1368: hr_utility.set_location(l_proc, 20);
1369: --
1370: IF l_exists = 'N' THEN
1371: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');
1372: hr_utility.raise_error;

Line 1371: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');

1367: --
1368: hr_utility.set_location(l_proc, 20);
1369: --
1370: IF l_exists = 'N' THEN
1371: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');
1372: hr_utility.raise_error;
1373: END IF;
1374: --
1375: --

Line 1372: hr_utility.raise_error;

1368: hr_utility.set_location(l_proc, 20);
1369: --
1370: IF l_exists = 'N' THEN
1371: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');
1372: hr_utility.raise_error;
1373: END IF;
1374: --
1375: --
1376: hr_utility.set_location('Leaving:'||l_proc, 30);

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

1372: hr_utility.raise_error;
1373: END IF;
1374: --
1375: --
1376: hr_utility.set_location('Leaving:'||l_proc, 30);
1377: --
1378: END chk_organization_id;
1379: --
1380: -- ----------------------------------------------------------------------------

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

1428: AND nvl(end_date_active,p_effective_date);
1429: --
1430: BEGIN
1431: --
1432: hr_utility.set_location('Entering:'|| l_proc, 10);
1433: --
1434: --
1435: -- Check classification
1436: --

Line 1439: hr_utility.set_message(800, 'HR_52760_NULL_CLSF');

1435: -- Check classification
1436: --
1437: IF p_org_information_context = 'CLASS' THEN
1438: IF p_org_information1 IS null THEN
1439: hr_utility.set_message(800, 'HR_52760_NULL_CLSF');
1440: hr_utility.raise_error;
1441: ELSE
1442: OPEN csr_cls_valid;
1443: FETCH csr_cls_valid INTO l_exists;

Line 1440: hr_utility.raise_error;

1436: --
1437: IF p_org_information_context = 'CLASS' THEN
1438: IF p_org_information1 IS null THEN
1439: hr_utility.set_message(800, 'HR_52760_NULL_CLSF');
1440: hr_utility.raise_error;
1441: ELSE
1442: OPEN csr_cls_valid;
1443: FETCH csr_cls_valid INTO l_exists;
1444: --

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

1441: ELSE
1442: OPEN csr_cls_valid;
1443: FETCH csr_cls_valid INTO l_exists;
1444: --
1445: hr_utility.set_location(l_proc, 20);
1446: --
1447: IF csr_cls_valid%notfound THEN
1448: CLOSE csr_cls_valid;
1449: hr_utility.set_message(800, 'HR_52759_INV_CLSF');

Line 1449: hr_utility.set_message(800, 'HR_52759_INV_CLSF');

1445: hr_utility.set_location(l_proc, 20);
1446: --
1447: IF csr_cls_valid%notfound THEN
1448: CLOSE csr_cls_valid;
1449: hr_utility.set_message(800, 'HR_52759_INV_CLSF');
1450: hr_utility.raise_error;
1451: ELSE
1452: CLOSE csr_cls_valid;
1453: END IF;

Line 1450: hr_utility.raise_error;

1446: --
1447: IF csr_cls_valid%notfound THEN
1448: CLOSE csr_cls_valid;
1449: hr_utility.set_message(800, 'HR_52759_INV_CLSF');
1450: hr_utility.raise_error;
1451: ELSE
1452: CLOSE csr_cls_valid;
1453: END IF;
1454: END IF;

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

1454: END IF;
1455: END IF;
1456: --
1457: --
1458: hr_utility.set_location('Leaving:'||l_proc, 30);
1459: --
1460: END chk_cls_valid;
1461: --
1462: -- ----------------------------------------------------------------------------

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

1499: l_exists VARCHAR2(1) := 'N';
1500: --
1501: BEGIN
1502: --
1503: hr_utility.set_location('Entering:'|| l_proc, 10);
1504: --
1505: --
1506: -- Check classification presence
1507: --

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

1518: EXCEPTION
1519: WHEN NO_DATA_FOUND THEN null;
1520: END;
1521: --
1522: hr_utility.set_location(l_proc, 20);
1523: --
1524: IF l_exists = 'Y' THEN
1525: hr_utility.set_message(800, 'HR_52761_ORG_CLSF_EXISTS');
1526: hr_utility.raise_error;

Line 1525: hr_utility.set_message(800, 'HR_52761_ORG_CLSF_EXISTS');

1521: --
1522: hr_utility.set_location(l_proc, 20);
1523: --
1524: IF l_exists = 'Y' THEN
1525: hr_utility.set_message(800, 'HR_52761_ORG_CLSF_EXISTS');
1526: hr_utility.raise_error;
1527: END IF;
1528: --
1529: --

Line 1526: hr_utility.raise_error;

1522: hr_utility.set_location(l_proc, 20);
1523: --
1524: IF l_exists = 'Y' THEN
1525: hr_utility.set_message(800, 'HR_52761_ORG_CLSF_EXISTS');
1526: hr_utility.raise_error;
1527: END IF;
1528: --
1529: --
1530: hr_utility.set_location('Leaving:'||l_proc, 30);

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

1526: hr_utility.raise_error;
1527: END IF;
1528: --
1529: --
1530: hr_utility.set_location('Leaving:'||l_proc, 30);
1531: --
1532: END chk_cls_unique;
1533: --
1534: --

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

1573: l_exists VARCHAR2(1) := 'N';
1574: --
1575: BEGIN
1576: --
1577: hr_utility.set_location('Entering:'|| l_proc, 10);
1578: --
1579: --
1580: -- Check info type presence
1581: --

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

1612: -- ,hr_all_organization_units haou
1613: -- WHERE haou.organization_id = p_organization_id
1614: -- AND haou.business_group_id = pbg.business_group_id)
1615: --
1616: hr_utility.set_location(l_proc, 20);
1617: --
1618: IF l_exists = 'N' THEN
1619: hr_utility.set_message(800, 'HR_289003_INV_INFO_TYPE');
1620: hr_utility.raise_error;

Line 1619: hr_utility.set_message(800, 'HR_289003_INV_INFO_TYPE');

1615: --
1616: hr_utility.set_location(l_proc, 20);
1617: --
1618: IF l_exists = 'N' THEN
1619: hr_utility.set_message(800, 'HR_289003_INV_INFO_TYPE');
1620: hr_utility.raise_error;
1621: END IF;
1622: --
1623: --

Line 1620: hr_utility.raise_error;

1616: hr_utility.set_location(l_proc, 20);
1617: --
1618: IF l_exists = 'N' THEN
1619: hr_utility.set_message(800, 'HR_289003_INV_INFO_TYPE');
1620: hr_utility.raise_error;
1621: END IF;
1622: --
1623: --
1624: hr_utility.set_location('Leaving:'||l_proc, 30);

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

1620: hr_utility.raise_error;
1621: END IF;
1622: --
1623: --
1624: hr_utility.set_location('Leaving:'||l_proc, 30);
1625: --
1626: END chk_info_type_valid;
1627: --
1628: --

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

1666: l_exists VARCHAR2(1) := 'N';
1667: --
1668: BEGIN
1669: --
1670: hr_utility.set_location('Entering:'|| l_proc, 10);
1671: --
1672: --
1673: -- Check info type presence
1674: --

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

1687: EXCEPTION
1688: WHEN NO_DATA_FOUND THEN null;
1689: END;
1690: --
1691: hr_utility.set_location(l_proc, 20);
1692: --
1693: IF l_exists = 'Y' THEN
1694: hr_utility.set_message(800, 'HR_289004_INFO_TYPE_EXISTS');
1695: hr_utility.raise_error;

Line 1694: hr_utility.set_message(800, 'HR_289004_INFO_TYPE_EXISTS');

1690: --
1691: hr_utility.set_location(l_proc, 20);
1692: --
1693: IF l_exists = 'Y' THEN
1694: hr_utility.set_message(800, 'HR_289004_INFO_TYPE_EXISTS');
1695: hr_utility.raise_error;
1696: END IF;
1697: --
1698: --

Line 1695: hr_utility.raise_error;

1691: hr_utility.set_location(l_proc, 20);
1692: --
1693: IF l_exists = 'Y' THEN
1694: hr_utility.set_message(800, 'HR_289004_INFO_TYPE_EXISTS');
1695: hr_utility.raise_error;
1696: END IF;
1697: --
1698: --
1699: hr_utility.set_location('Leaving:'||l_proc, 30);

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

1695: hr_utility.raise_error;
1696: END IF;
1697: --
1698: --
1699: hr_utility.set_location('Leaving:'||l_proc, 30);
1700: --
1701: END chk_info_type_unique;
1702: --
1703: -- Bug 3456540 Start

Line 1722: hr_utility.set_message(800, 'HR_6612_ORG_LEGAL_NO_LOCATION');

1718: fetch csr_location into l_location_id;
1719: close csr_location;
1720: --
1721: if l_location_id is null then
1722: hr_utility.set_message(800, 'HR_6612_ORG_LEGAL_NO_LOCATION');
1723: hr_utility.raise_error;
1724: end if;
1725: --
1726: end chk_location;

Line 1723: hr_utility.raise_error;

1719: close csr_location;
1720: --
1721: if l_location_id is null then
1722: hr_utility.set_message(800, 'HR_6612_ORG_LEGAL_NO_LOCATION');
1723: hr_utility.raise_error;
1724: end if;
1725: --
1726: end chk_location;
1727: --

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

1807: AND a.assignment_type = 'E'
1808: AND a.soft_coding_keyflex_id = sck.soft_coding_keyflex_id );
1809:
1810: Begin
1811: hr_utility.set_location('Entering:'||l_proc, 10);
1812:
1813: --
1814: -- get original values
1815: --

Line 1826: hr_utility.set_location('Entering:'||l_proc, 20);

1822: IF ((l_state_code <> X_org_information1) OR
1823: (NVL(l_carrier_id, X_org_information8) <> X_org_information8) OR
1824: X_org_information8 IS NULL)
1825: THEN
1826: hr_utility.set_location('Entering:'||l_proc, 20);
1827: OPEN check_override;
1828: FETCH check_override into l_dummy;
1829: IF check_override%FOUND
1830: THEN

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

1827: OPEN check_override;
1828: FETCH check_override into l_dummy;
1829: IF check_override%FOUND
1830: THEN
1831: hr_utility.set_location(l_proc, 30);
1832: hr_utility.set_message(800,'HR_51039_ORG_WC_OVRRD_RATE_REF');
1833: hr_utility.raise_error;
1834: END IF;
1835: CLOSE check_override;

Line 1832: hr_utility.set_message(800,'HR_51039_ORG_WC_OVRRD_RATE_REF');

1828: FETCH check_override into l_dummy;
1829: IF check_override%FOUND
1830: THEN
1831: hr_utility.set_location(l_proc, 30);
1832: hr_utility.set_message(800,'HR_51039_ORG_WC_OVRRD_RATE_REF');
1833: hr_utility.raise_error;
1834: END IF;
1835: CLOSE check_override;
1836: hr_utility.set_location(l_proc, 40);

Line 1833: hr_utility.raise_error;

1829: IF check_override%FOUND
1830: THEN
1831: hr_utility.set_location(l_proc, 30);
1832: hr_utility.set_message(800,'HR_51039_ORG_WC_OVRRD_RATE_REF');
1833: hr_utility.raise_error;
1834: END IF;
1835: CLOSE check_override;
1836: hr_utility.set_location(l_proc, 40);
1837: END IF;

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

1832: hr_utility.set_message(800,'HR_51039_ORG_WC_OVRRD_RATE_REF');
1833: hr_utility.raise_error;
1834: END IF;
1835: CLOSE check_override;
1836: hr_utility.set_location(l_proc, 40);
1837: END IF;
1838: hr_utility.set_location('Leaving :'||l_proc, 50);
1839: END check_state_tax_rules;
1840: --

Line 1838: hr_utility.set_location('Leaving :'||l_proc, 50);

1834: END IF;
1835: CLOSE check_override;
1836: hr_utility.set_location(l_proc, 40);
1837: END IF;
1838: hr_utility.set_location('Leaving :'||l_proc, 50);
1839: END check_state_tax_rules;
1840: --
1841: -- End of bug No 2586522
1842: --

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

1904: l_proc varchar2(72) := g_package||'insert_validate';
1905: l_bg_id number;
1906: --
1907: Begin
1908: hr_utility.set_location('Entering:'||l_proc, 5);
1909: --
1910: -- Call all supporting business operations
1911:
1912: hr_api.mandatory_arg_error

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

2062: if(p_rec.org_information_context<>'CLASS') then
2063: hr_ori_bus.chk_df(p_rec);
2064: end if;
2065: --
2066: hr_utility.set_location(' Leaving:'||l_proc, 10);
2067: End insert_validate;
2068: --
2069: -- ----------------------------------------------------------------------------
2070: -- |---------------------------< update_validate >----------------------------|

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

2083: l_startdate date;
2084: l_enddate date;
2085: --
2086: Begin
2087: hr_utility.set_location('Entering:'||l_proc, 5);
2088: --
2089: -- Call all supporting business operations
2090: --
2091: --

Line 2208: hr_utility.set_location('The person:'|| p_rec.org_information2,333);

2204: --
2205:
2206: --Added for 3034234.Start of fix.
2207: IF (p_rec.org_information_context = 'Organization Name Alias') then
2208: hr_utility.set_location('The person:'|| p_rec.org_information2,333);
2209: open c_date(to_number(p_rec.org_information2));
2210: fetch c_date into l_startdate,l_enddate;
2211: hr_utility.set_location('Start:'||l_startdate||' Enddate :'||l_enddate,555);
2212: if c_date%notfound then

Line 2211: hr_utility.set_location('Start:'||l_startdate||' Enddate :'||l_enddate,555);

2207: IF (p_rec.org_information_context = 'Organization Name Alias') then
2208: hr_utility.set_location('The person:'|| p_rec.org_information2,333);
2209: open c_date(to_number(p_rec.org_information2));
2210: fetch c_date into l_startdate,l_enddate;
2211: hr_utility.set_location('Start:'||l_startdate||' Enddate :'||l_enddate,555);
2212: if c_date%notfound then
2213: close c_date;
2214: if(fnd_date.canonical_to_date(p_rec.org_information4) > fnd_date.date_to_canonical(l_enddate)) then
2215:

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

2226: end if;
2227: -- End of fix for 3034234
2228: --
2229: hr_ori_bus.chk_df(p_rec);
2230: hr_utility.set_location(' Leaving:'||l_proc, 10);
2231: --
2232: End update_validate;
2233: --
2234: -- ----------------------------------------------------------------------------

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

2240: --
2241: l_proc varchar2(72) := g_package||'delete_validate';
2242: --
2243: Begin
2244: hr_utility.set_location('Entering:'||l_proc, 5);
2245: --
2246: -- Call all supporting business operations
2247: --
2248: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

2244: hr_utility.set_location('Entering:'||l_proc, 5);
2245: --
2246: -- Call all supporting business operations
2247: --
2248: hr_utility.set_location(' Leaving:'||l_proc, 10);
2249: End delete_validate;
2250: --
2251: end hr_ori_bus;