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

842: l_proc varchar2(72) := g_package||'return_legislation_code';
843: --
844: Begin
845: --
846: hr_utility.set_location('Entering:'|| l_proc, 10);
847: --
848: -- Ensure that all the mandatory parameter are not null
849: --
850: hr_api.mandatory_arg_error

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

860: -- call to this function. Just return the value in the global
861: -- variable.
862: --
863: l_legislation_code := hr_ori_bus.g_legislation_code;
864: hr_utility.set_location(l_proc, 20);
865: else
866: --
867: -- The ID is different to the last call to this function
868: -- or this is the first call to this function.

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

877: close csr_leg_code;
878: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
879: fnd_message.raise_error;
880: end if;
881: hr_utility.set_location(l_proc,30);
882: --
883: -- Set the global variables so the values are
884: -- available for the next call to this function.
885: --

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

886: close csr_leg_code;
887: hr_ori_bus.g_org_information_id:= p_org_information_id;
888: hr_ori_bus.g_legislation_code := l_legislation_code;
889: end if;
890: hr_utility.set_location(' Leaving:'|| l_proc, 40);
891: return l_legislation_code;
892: end return_legislation_code;
893: -- ----------------------------------------------------------------------------
894: -- |-------------------------< chk_name >-------------------------------------|

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

913: l_name hr_all_organization_units.name%TYPE;
914: l_exists number;
915: BEGIN
916: --
917: hr_utility.set_location('Entering:'|| l_proc, 10);
918: --
919: --
920: --
921: hr_utility.set_location(l_proc, 20);

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

917: hr_utility.set_location('Entering:'|| l_proc, 10);
918: --
919: --
920: --
921: hr_utility.set_location(l_proc, 20);
922: --
923: --
924: -- Check that the business group name is unique if we are adding or updating to
925: -- a business group classification

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

939: and i.org_information_context='CLASS'
940: and i.org_information2 ='Y'
941: and u.name = l_name;
942: if l_exists >0 then
943: hr_utility.set_message(800, 'HR_289381_DUPLICATE_BG');
944: hr_utility.raise_error;
945: end if;
946: end if;
947: exception

Line 944: hr_utility.raise_error;

940: and i.org_information2 ='Y'
941: and u.name = l_name;
942: if l_exists >0 then
943: hr_utility.set_message(800, 'HR_289381_DUPLICATE_BG');
944: hr_utility.raise_error;
945: end if;
946: end if;
947: exception
948: when no_data_found then

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

945: end if;
946: end if;
947: exception
948: when no_data_found then
949: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');
950: hr_utility.raise_error;
951:
952: end chk_name;
953:

Line 950: hr_utility.raise_error;

946: end if;
947: exception
948: when no_data_found then
949: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');
950: hr_utility.raise_error;
951:
952: end chk_name;
953:
954: -- ----------------------------------------------------------------------------

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

985: --
986: l_proc varchar2(72) := g_package || 'chk_ddf';
987: --
988: begin
989: hr_utility.set_location('Entering:'||l_proc,10);
990: --
991: if ((p_rec.org_information_id is not null) and (
992: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>
993: nvl(p_rec.org_information_id, hr_api.g_number) or

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

1039: -- a) During update, the structure column value or any
1040: -- of the attribute values have actually changed.
1041: -- b) During insert.
1042: --
1043: hr_utility.set_location('context = '||p_rec.org_information_context,20);
1044: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1045: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1046: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1047: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);

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

1040: -- of the attribute values have actually changed.
1041: -- b) During insert.
1042: --
1043: hr_utility.set_location('context = '||p_rec.org_information_context,20);
1044: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1045: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1046: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1047: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);
1048: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);

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

1041: -- b) During insert.
1042: --
1043: hr_utility.set_location('context = '||p_rec.org_information_context,20);
1044: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1045: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1046: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1047: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);
1048: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);
1049:

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

1042: --
1043: hr_utility.set_location('context = '||p_rec.org_information_context,20);
1044: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1045: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1046: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1047: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);
1048: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);
1049:
1050: /*

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

1043: hr_utility.set_location('context = '||p_rec.org_information_context,20);
1044: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1045: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1046: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1047: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);
1048: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);
1049:
1050: /*
1051: ** Some valuesets used by this flexfield require additional information

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

1044: hr_utility.set_location('org_information1 = '||p_rec.org_information1,30);
1045: hr_utility.set_location('org_information2 = '||p_rec.org_information2,40);
1046: hr_utility.set_location('org_information3 = '||p_rec.org_information3,50);
1047: hr_utility.set_location('org_information4 = '||p_rec.org_information4,60);
1048: hr_utility.set_location('org_information5 = '||p_rec.org_information5,70);
1049:
1050: /*
1051: ** Some valuesets used by this flexfield require additional information
1052: ** this will be passed using profile options. We will create these and

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

1054: */
1055: fnd_profile.put('PER_ORGANIZATION_ID',p_rec.organization_id);
1056: fnd_profile.put('PER_ORG_INFORMATION_ID',
1057: nvl(to_number(p_rec.org_information_id),-1));
1058: hr_utility.set_location('PER_ORG_INFORMATION_ID'||
1059: fnd_profile.value('PER_ORG_INFORMATION_ID'),80);
1060: hr_utility.set_location('PER_ORGANIZATION_ID'||
1061: fnd_profile.value('PER_ORGANIZATION_ID'),80);
1062:

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

1056: fnd_profile.put('PER_ORG_INFORMATION_ID',
1057: nvl(to_number(p_rec.org_information_id),-1));
1058: hr_utility.set_location('PER_ORG_INFORMATION_ID'||
1059: fnd_profile.value('PER_ORG_INFORMATION_ID'),80);
1060: hr_utility.set_location('PER_ORGANIZATION_ID'||
1061: fnd_profile.value('PER_ORGANIZATION_ID'),80);
1062:
1063: hr_dflex_utility.ins_or_upd_descflex_attribs
1064: (p_appl_short_name => 'PER'

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

1106: ,p_attribute20_value => p_rec.org_information20
1107: );
1108: end if;
1109: --
1110: hr_utility.set_location(' Leaving:'||l_proc,100);
1111: end chk_ddf;
1112: --
1113: -- ----------------------------------------------------------------------------
1114: -- |------------------------------< chk_df >----------------------------------|

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

1144: --
1145: l_proc varchar2(72) := g_package || 'chk_df';
1146: --
1147: begin
1148: hr_utility.set_location('Entering:'||l_proc,10);
1149: --
1150: if ((p_rec.org_information_id is not null) and (
1151: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1152: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1243: ,p_attribute20_value => p_rec.attribute20
1244: );
1245: end if;
1246: --
1247: hr_utility.set_location(' Leaving:'||l_proc,20);
1248: end chk_df;
1249: --
1250: -- ----------------------------------------------------------------------------
1251: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1357: l_exists VARCHAR2(1) := 'N';
1358: --
1359: BEGIN
1360: --
1361: hr_utility.set_location('Entering:'|| l_proc, 10);
1362: --
1363: --
1364: -- Check organization_id presence
1365: --

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

1374: EXCEPTION
1375: WHEN NO_DATA_FOUND THEN NULL;
1376: END;
1377: --
1378: hr_utility.set_location(l_proc, 20);
1379: --
1380: IF l_exists = 'N' THEN
1381: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');
1382: hr_utility.raise_error;

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

1377: --
1378: hr_utility.set_location(l_proc, 20);
1379: --
1380: IF l_exists = 'N' THEN
1381: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');
1382: hr_utility.raise_error;
1383: END IF;
1384: --
1385: --

Line 1382: hr_utility.raise_error;

1378: hr_utility.set_location(l_proc, 20);
1379: --
1380: IF l_exists = 'N' THEN
1381: hr_utility.set_message(800, 'HR_289002_INV_ORG_ID');
1382: hr_utility.raise_error;
1383: END IF;
1384: --
1385: --
1386: hr_utility.set_location('Leaving:'||l_proc, 30);

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

1382: hr_utility.raise_error;
1383: END IF;
1384: --
1385: --
1386: hr_utility.set_location('Leaving:'||l_proc, 30);
1387: --
1388: END chk_organization_id;
1389: --
1390: -- ----------------------------------------------------------------------------

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

1438: AND nvl(end_date_active,p_effective_date);
1439: --
1440: BEGIN
1441: --
1442: hr_utility.set_location('Entering:'|| l_proc, 10);
1443: --
1444: --
1445: -- Check classification
1446: --

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

1445: -- Check classification
1446: --
1447: IF p_org_information_context = 'CLASS' THEN
1448: IF p_org_information1 IS null THEN
1449: hr_utility.set_message(800, 'HR_52760_NULL_CLSF');
1450: hr_utility.raise_error;
1451: ELSE
1452: OPEN csr_cls_valid;
1453: FETCH csr_cls_valid INTO l_exists;

Line 1450: hr_utility.raise_error;

1446: --
1447: IF p_org_information_context = 'CLASS' THEN
1448: IF p_org_information1 IS null THEN
1449: hr_utility.set_message(800, 'HR_52760_NULL_CLSF');
1450: hr_utility.raise_error;
1451: ELSE
1452: OPEN csr_cls_valid;
1453: FETCH csr_cls_valid INTO l_exists;
1454: --

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

1451: ELSE
1452: OPEN csr_cls_valid;
1453: FETCH csr_cls_valid INTO l_exists;
1454: --
1455: hr_utility.set_location(l_proc, 20);
1456: --
1457: IF csr_cls_valid%notfound THEN
1458: CLOSE csr_cls_valid;
1459: hr_utility.set_message(800, 'HR_52759_INV_CLSF');

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

1455: hr_utility.set_location(l_proc, 20);
1456: --
1457: IF csr_cls_valid%notfound THEN
1458: CLOSE csr_cls_valid;
1459: hr_utility.set_message(800, 'HR_52759_INV_CLSF');
1460: hr_utility.raise_error;
1461: ELSE
1462: CLOSE csr_cls_valid;
1463: END IF;

Line 1460: hr_utility.raise_error;

1456: --
1457: IF csr_cls_valid%notfound THEN
1458: CLOSE csr_cls_valid;
1459: hr_utility.set_message(800, 'HR_52759_INV_CLSF');
1460: hr_utility.raise_error;
1461: ELSE
1462: CLOSE csr_cls_valid;
1463: END IF;
1464: END IF;

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

1464: END IF;
1465: END IF;
1466: --
1467: --
1468: hr_utility.set_location('Leaving:'||l_proc, 30);
1469: --
1470: END chk_cls_valid;
1471: --
1472: -- ----------------------------------------------------------------------------

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

1509: l_exists VARCHAR2(1) := 'N';
1510: --
1511: BEGIN
1512: --
1513: hr_utility.set_location('Entering:'|| l_proc, 10);
1514: --
1515: --
1516: -- Check classification presence
1517: --

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

1528: EXCEPTION
1529: WHEN NO_DATA_FOUND THEN null;
1530: END;
1531: --
1532: hr_utility.set_location(l_proc, 20);
1533: --
1534: IF l_exists = 'Y' THEN
1535: hr_utility.set_message(800, 'HR_52761_ORG_CLSF_EXISTS');
1536: hr_utility.raise_error;

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

1531: --
1532: hr_utility.set_location(l_proc, 20);
1533: --
1534: IF l_exists = 'Y' THEN
1535: hr_utility.set_message(800, 'HR_52761_ORG_CLSF_EXISTS');
1536: hr_utility.raise_error;
1537: END IF;
1538: --
1539: --

Line 1536: hr_utility.raise_error;

1532: hr_utility.set_location(l_proc, 20);
1533: --
1534: IF l_exists = 'Y' THEN
1535: hr_utility.set_message(800, 'HR_52761_ORG_CLSF_EXISTS');
1536: hr_utility.raise_error;
1537: END IF;
1538: --
1539: --
1540: hr_utility.set_location('Leaving:'||l_proc, 30);

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

1536: hr_utility.raise_error;
1537: END IF;
1538: --
1539: --
1540: hr_utility.set_location('Leaving:'||l_proc, 30);
1541: --
1542: END chk_cls_unique;
1543: --
1544: --

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

1583: l_exists VARCHAR2(1) := 'N';
1584: --
1585: BEGIN
1586: --
1587: hr_utility.set_location('Entering:'|| l_proc, 10);
1588: --
1589: --
1590: -- Check info type presence
1591: --

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

1622: -- ,hr_all_organization_units haou
1623: -- WHERE haou.organization_id = p_organization_id
1624: -- AND haou.business_group_id = pbg.business_group_id)
1625: --
1626: hr_utility.set_location(l_proc, 20);
1627: --
1628: IF l_exists = 'N' THEN
1629: hr_utility.set_message(800, 'HR_289003_INV_INFO_TYPE');
1630: hr_utility.raise_error;

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

1625: --
1626: hr_utility.set_location(l_proc, 20);
1627: --
1628: IF l_exists = 'N' THEN
1629: hr_utility.set_message(800, 'HR_289003_INV_INFO_TYPE');
1630: hr_utility.raise_error;
1631: END IF;
1632: --
1633: --

Line 1630: hr_utility.raise_error;

1626: hr_utility.set_location(l_proc, 20);
1627: --
1628: IF l_exists = 'N' THEN
1629: hr_utility.set_message(800, 'HR_289003_INV_INFO_TYPE');
1630: hr_utility.raise_error;
1631: END IF;
1632: --
1633: --
1634: hr_utility.set_location('Leaving:'||l_proc, 30);

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

1630: hr_utility.raise_error;
1631: END IF;
1632: --
1633: --
1634: hr_utility.set_location('Leaving:'||l_proc, 30);
1635: --
1636: END chk_info_type_valid;
1637: --
1638: --

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

1676: l_exists VARCHAR2(1) := 'N';
1677: --
1678: BEGIN
1679: --
1680: hr_utility.set_location('Entering:'|| l_proc, 10);
1681: --
1682: --
1683: -- Check info type presence
1684: --

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

1697: EXCEPTION
1698: WHEN NO_DATA_FOUND THEN null;
1699: END;
1700: --
1701: hr_utility.set_location(l_proc, 20);
1702: --
1703: IF l_exists = 'Y' THEN
1704: hr_utility.set_message(800, 'HR_289004_INFO_TYPE_EXISTS');
1705: hr_utility.raise_error;

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

1700: --
1701: hr_utility.set_location(l_proc, 20);
1702: --
1703: IF l_exists = 'Y' THEN
1704: hr_utility.set_message(800, 'HR_289004_INFO_TYPE_EXISTS');
1705: hr_utility.raise_error;
1706: END IF;
1707: --
1708: --

Line 1705: hr_utility.raise_error;

1701: hr_utility.set_location(l_proc, 20);
1702: --
1703: IF l_exists = 'Y' THEN
1704: hr_utility.set_message(800, 'HR_289004_INFO_TYPE_EXISTS');
1705: hr_utility.raise_error;
1706: END IF;
1707: --
1708: --
1709: hr_utility.set_location('Leaving:'||l_proc, 30);

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

1705: hr_utility.raise_error;
1706: END IF;
1707: --
1708: --
1709: hr_utility.set_location('Leaving:'||l_proc, 30);
1710: --
1711: END chk_info_type_unique;
1712: --
1713: -- Bug 3456540 Start

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

1728: fetch csr_location into l_location_id;
1729: close csr_location;
1730: --
1731: if l_location_id is null then
1732: hr_utility.set_message(800, 'HR_6612_ORG_LEGAL_NO_LOCATION');
1733: hr_utility.raise_error;
1734: end if;
1735: --
1736: end chk_location;

Line 1733: hr_utility.raise_error;

1729: close csr_location;
1730: --
1731: if l_location_id is null then
1732: hr_utility.set_message(800, 'HR_6612_ORG_LEGAL_NO_LOCATION');
1733: hr_utility.raise_error;
1734: end if;
1735: --
1736: end chk_location;
1737: --

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

1817: AND a.assignment_type = 'E'
1818: AND a.soft_coding_keyflex_id = sck.soft_coding_keyflex_id );
1819:
1820: Begin
1821: hr_utility.set_location('Entering:'||l_proc, 10);
1822:
1823: --
1824: -- get original values
1825: --

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

1832: IF ((l_state_code <> X_org_information1) OR
1833: (NVL(l_carrier_id, X_org_information8) <> X_org_information8) OR
1834: X_org_information8 IS NULL)
1835: THEN
1836: hr_utility.set_location('Entering:'||l_proc, 20);
1837: OPEN check_override;
1838: FETCH check_override into l_dummy;
1839: IF check_override%FOUND
1840: THEN

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

1837: OPEN check_override;
1838: FETCH check_override into l_dummy;
1839: IF check_override%FOUND
1840: THEN
1841: hr_utility.set_location(l_proc, 30);
1842: hr_utility.set_message(800,'HR_51039_ORG_WC_OVRRD_RATE_REF');
1843: hr_utility.raise_error;
1844: END IF;
1845: CLOSE check_override;

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

1838: FETCH check_override into l_dummy;
1839: IF check_override%FOUND
1840: THEN
1841: hr_utility.set_location(l_proc, 30);
1842: hr_utility.set_message(800,'HR_51039_ORG_WC_OVRRD_RATE_REF');
1843: hr_utility.raise_error;
1844: END IF;
1845: CLOSE check_override;
1846: hr_utility.set_location(l_proc, 40);

Line 1843: hr_utility.raise_error;

1839: IF check_override%FOUND
1840: THEN
1841: hr_utility.set_location(l_proc, 30);
1842: hr_utility.set_message(800,'HR_51039_ORG_WC_OVRRD_RATE_REF');
1843: hr_utility.raise_error;
1844: END IF;
1845: CLOSE check_override;
1846: hr_utility.set_location(l_proc, 40);
1847: END IF;

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

1842: hr_utility.set_message(800,'HR_51039_ORG_WC_OVRRD_RATE_REF');
1843: hr_utility.raise_error;
1844: END IF;
1845: CLOSE check_override;
1846: hr_utility.set_location(l_proc, 40);
1847: END IF;
1848: hr_utility.set_location('Leaving :'||l_proc, 50);
1849: END check_state_tax_rules;
1850: --

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

1844: END IF;
1845: CLOSE check_override;
1846: hr_utility.set_location(l_proc, 40);
1847: END IF;
1848: hr_utility.set_location('Leaving :'||l_proc, 50);
1849: END check_state_tax_rules;
1850: --
1851: -- End of bug No 2586522
1852: --

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

1914: l_proc varchar2(72) := g_package||'insert_validate';
1915: l_bg_id number;
1916: --
1917: Begin
1918: hr_utility.set_location('Entering:'||l_proc, 5);
1919: --
1920: -- Call all supporting business operations
1921:
1922: hr_api.mandatory_arg_error

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

2072: if(p_rec.org_information_context<>'CLASS') then
2073: hr_ori_bus.chk_df(p_rec);
2074: end if;
2075: --
2076: hr_utility.set_location(' Leaving:'||l_proc, 10);
2077: End insert_validate;
2078: --
2079: -- ----------------------------------------------------------------------------
2080: -- |---------------------------< update_validate >----------------------------|

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

2093: l_startdate date;
2094: l_enddate date;
2095: --
2096: Begin
2097: hr_utility.set_location('Entering:'||l_proc, 5);
2098: --
2099: -- Call all supporting business operations
2100: --
2101: --

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

2214: --
2215:
2216: --Added for 3034234.Start of fix.
2217: IF (p_rec.org_information_context = 'Organization Name Alias') then
2218: hr_utility.set_location('The person:'|| p_rec.org_information2,333);
2219: open c_date(to_number(p_rec.org_information2));
2220: fetch c_date into l_startdate,l_enddate;
2221: hr_utility.set_location('Start:'||l_startdate||' Enddate :'||l_enddate,555);
2222: if c_date%notfound then

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

2217: IF (p_rec.org_information_context = 'Organization Name Alias') then
2218: hr_utility.set_location('The person:'|| p_rec.org_information2,333);
2219: open c_date(to_number(p_rec.org_information2));
2220: fetch c_date into l_startdate,l_enddate;
2221: hr_utility.set_location('Start:'||l_startdate||' Enddate :'||l_enddate,555);
2222: if c_date%notfound then
2223: close c_date;
2224: if(fnd_date.canonical_to_date(p_rec.org_information4) > fnd_date.date_to_canonical(l_enddate)) then
2225:

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

2236: end if;
2237: -- End of fix for 3034234
2238: --
2239: hr_ori_bus.chk_df(p_rec);
2240: hr_utility.set_location(' Leaving:'||l_proc, 10);
2241: --
2242: End update_validate;
2243: --
2244: -- ----------------------------------------------------------------------------

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

2250: --
2251: l_proc varchar2(72) := g_package||'delete_validate';
2252: --
2253: Begin
2254: hr_utility.set_location('Entering:'||l_proc, 5);
2255: --
2256: -- Call all supporting business operations
2257: --
2258: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

2254: hr_utility.set_location('Entering:'||l_proc, 5);
2255: --
2256: -- Call all supporting business operations
2257: --
2258: hr_utility.set_location(' Leaving:'||l_proc, 10);
2259: End delete_validate;
2260: --
2261: end hr_ori_bus;