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_LEI_BUS dependencies on HR_UTILITY

Line 54: hr_utility.set_location('Entering:'||l_proc, 1);

50: from hr_locations
51: where location_id = p_location_id and location_use = 'HR';
52: --
53: Begin
54: hr_utility.set_location('Entering:'||l_proc, 1);
55: --
56: -- Check mandatory parameters have been set
57: --
58: hr_api.mandatory_arg_error

Line 64: hr_utility.set_location(l_proc, 2);

60: p_api_name => l_proc,
61: p_argument => 'location_id',
62: p_argument_value => p_location_id
63: );
64: hr_utility.set_location(l_proc, 2);
65: --
66: -- Check that the location_id is in the hr_locations table.
67: --
68: open c_valid_loc;

Line 72: hr_utility.set_message(800, 'HR_INV_LOC_ID');

68: open c_valid_loc;
69: fetch c_valid_loc into l_dummy;
70: if c_valid_loc%notfound then
71: close c_valid_loc;
72: hr_utility.set_message(800, 'HR_INV_LOC_ID');
73: hr_utility.raise_error;
74: end if;
75: close c_valid_loc;
76: --

Line 73: hr_utility.raise_error;

69: fetch c_valid_loc into l_dummy;
70: if c_valid_loc%notfound then
71: close c_valid_loc;
72: hr_utility.set_message(800, 'HR_INV_LOC_ID');
73: hr_utility.raise_error;
74: end if;
75: close c_valid_loc;
76: --
77: hr_utility.set_location(' Leaving:'||l_proc, 3);

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

73: hr_utility.raise_error;
74: end if;
75: close c_valid_loc;
76: --
77: hr_utility.set_location(' Leaving:'||l_proc, 3);
78: --
79: End chk_location_id;
80: --
81: --

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

117: l_argument varchar2(30);
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'|| l_proc,10);
122: --
123: -- Only proceed with validation if a row exists for
124: -- the current record in the HR Schema.
125: if not hr_lei_shd.api_updating

Line 129: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

125: if not hr_lei_shd.api_updating
126: (p_location_extra_info_id => p_rec.location_extra_info_id
127: ,p_object_version_number => p_rec.object_version_number
128: ) then
129: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
130: hr_utility.set_message_token('PROCEDURE', l_proc);
131: hr_utility.set_message_token('STEP', '20');
132: end if;
133: --

Line 130: hr_utility.set_message_token('PROCEDURE', l_proc);

126: (p_location_extra_info_id => p_rec.location_extra_info_id
127: ,p_object_version_number => p_rec.object_version_number
128: ) then
129: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
130: hr_utility.set_message_token('PROCEDURE', l_proc);
131: hr_utility.set_message_token('STEP', '20');
132: end if;
133: --
134: hr_utility.set_location (l_proc, 30);

Line 131: hr_utility.set_message_token('STEP', '20');

127: ,p_object_version_number => p_rec.object_version_number
128: ) then
129: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
130: hr_utility.set_message_token('PROCEDURE', l_proc);
131: hr_utility.set_message_token('STEP', '20');
132: end if;
133: --
134: hr_utility.set_location (l_proc, 30);
135: --

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

130: hr_utility.set_message_token('PROCEDURE', l_proc);
131: hr_utility.set_message_token('STEP', '20');
132: end if;
133: --
134: hr_utility.set_location (l_proc, 30);
135: --
136: if nvl(p_rec.location_id,hr_api.g_number)
137: <> nvl(hr_lei_shd.g_old_rec.location_id,hr_api.g_number) then
138: l_argument := 'location_id';

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

144: l_argument := 'information_type';
145: raise l_error;
146: end if;
147: --
148: hr_utility.set_location(' Leaving : '|| l_proc, 40);
149: --
150: exception
151: when l_error then
152: hr_api.argument_changed_error

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

206: WHERE lit.information_type = p_information_type
207: ;
208: --
209: Begin
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: --
213: -- Check mandatory parameters have been set
214: --

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

234: end if;
235: --
236: close c_info_type;
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: --
240: Exception
241: --
242: when l_inactive_type then

Line 244: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');

240: Exception
241: --
242: when l_inactive_type then
243: close c_info_type;
244: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
245: hr_utility.raise_error;
246: --
247: when no_data_found then
248: close c_info_type;

Line 245: hr_utility.raise_error;

241: --
242: when l_inactive_type then
243: close c_info_type;
244: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
245: hr_utility.raise_error;
246: --
247: when no_data_found then
248: close c_info_type;
249: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');

Line 249: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');

245: hr_utility.raise_error;
246: --
247: when no_data_found then
248: close c_info_type;
249: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
250: hr_utility.raise_error;
251: --
252: End chk_location_info_type;
253: --

Line 250: hr_utility.raise_error;

246: --
247: when no_data_found then
248: close c_info_type;
249: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
250: hr_utility.raise_error;
251: --
252: End chk_location_info_type;
253: --
254: --

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

304: WHERE lei.information_type = p_information_type
305: AND lei.location_id = p_location_id ;
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: if p_multiple_occurences_flag = 'N' then
311: --
312: -- Check mandatory parameters have been set

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

335: raise l_success;
336: end if;
337: end if;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: Exception
341: when l_success then
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: when l_failure then

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

338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: Exception
341: when l_success then
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: when l_failure then
344: hr_utility.set_message(800, 'HR_INFO_TYPE_ALLOWS_1_ROW');
345: hr_utility.raise_error;
346:

Line 344: hr_utility.set_message(800, 'HR_INFO_TYPE_ALLOWS_1_ROW');

340: Exception
341: when l_success then
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: when l_failure then
344: hr_utility.set_message(800, 'HR_INFO_TYPE_ALLOWS_1_ROW');
345: hr_utility.raise_error;
346:
347: End chk_count_rows;
348: --

Line 345: hr_utility.raise_error;

341: when l_success then
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: when l_failure then
344: hr_utility.set_message(800, 'HR_INFO_TYPE_ALLOWS_1_ROW');
345: hr_utility.raise_error;
346:
347: End chk_count_rows;
348: --
349: -- -----------------------------------------------------------------------

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

382: --
383: l_proc varchar2(72) := g_package||'chk_df';
384: --
385: begin
386: hr_utility.set_location('Entering:'||l_proc, 10);
387: --
388: if ((p_rec.location_extra_info_id is not null) and (
389: nvl(hr_lei_shd.g_old_rec.lei_attribute_category, hr_api.g_varchar2) <>
390: nvl(p_rec.lei_attribute_category, hr_api.g_varchar2) or

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

481: ,p_attribute20_name => 'LEI_ATTRIBUTE20'
482: ,p_attribute20_value => p_rec.lei_attribute20);
483: end if;
484: --
485: hr_utility.set_location(' Leaving:'||l_proc, 20);
486: end chk_df;
487: --
488: -- -----------------------------------------------------------------------
489: -- |------------------------------< chk_ddf >----------------------------|

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

524: l_proc varchar2(72) := g_package||'chk_ddf';
525: l_error exception;
526: --
527: Begin
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: -- Check if the row is being inserted or updated and a
531: -- value has changed
532: --

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

664: );
665: --
666: end if;
667: --
668: hr_utility.set_location(' Leaving:'||l_proc, 10);
669: end chk_ddf;
670: --
671: -- ----------------------------------------------------------------------------
672: -- |---------------------------< insert_validate >----------------------------|

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

702:
703: -- 6329528
704:
705: Begin
706: hr_utility.set_location('Entering:'||l_proc, 5);
707: --
708: -- As this data is not within the context of a business group
709: -- the set_security_group_id procedure has zero passed
710: -- to it as the default security_group_id.

Line 721: hr_utility.set_location('Entering:'||l_proc, 6);

717: close csr_sec_grp;
718: hr_api.set_security_group_id(p_security_group_id => l_security_group_id);
719: --
720: --
721: hr_utility.set_location('Entering:'||l_proc, 6);
722: --
723: -- Call all supporting business operations
724: --
725: -- 1) Call chk_location_id to validate location_id

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

740: -- Call ddf procedure to validate Developer Descritive Flex Fields
741: --
742: hr_lei_bus.chk_ddf(p_rec => p_rec);
743: --
744: hr_utility.set_location(l_proc, 10);
745: --
746: -- Call df procedure to validate Descritive Flex Fields
747: --
748: hr_lei_bus.chk_df(p_rec => p_rec);

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

746: -- Call df procedure to validate Descritive Flex Fields
747: --
748: hr_lei_bus.chk_df(p_rec => p_rec);
749: --
750: hr_utility.set_location(' Leaving:'||l_proc, 20);
751: --
752: --
753: End insert_validate;
754: --

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

782: l_security_group_id number;
783: l_legislation_code varchar2(150);
784: -- bug 6329528
785: Begin
786: hr_utility.set_location('Entering:'||l_proc, 5);
787: --
788: -- As this data is not within the context of a business group
789: -- the set_security_group_id procedure has zero passed
790: -- to it as the default security_group_id.

Line 803: hr_utility.set_location('Entering:'||l_proc, 6);

799: hr_api.set_security_group_id(p_security_group_id => l_security_group_id);
800: --
801:
802: --
803: hr_utility.set_location('Entering:'||l_proc, 6);
804: --
805: -- Call all supporting business operations
806: --
807: -- 1) Check those columns which cannot be updated have not changed.

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

805: -- Call all supporting business operations
806: --
807: -- 1) Check those columns which cannot be updated have not changed.
808: --
809: hr_utility.set_location(l_proc, 10);
810: --
811: chk_non_updateable_args (p_rec => p_rec);
812: --
813: -- Call ddf procedure to validate Developer Descritive Flex Fields

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

813: -- Call ddf procedure to validate Developer Descritive Flex Fields
814: --
815: hr_lei_bus.chk_ddf(p_rec => p_rec);
816: --
817: hr_utility.set_location(l_proc, 10);
818: --
819: -- Call df procedure to validate Descritive Flex Fields
820: --
821: hr_lei_bus.chk_df(p_rec => p_rec);

Line 823: hr_utility.set_location('Leaving: '||l_proc, 25);

819: -- Call df procedure to validate Descritive Flex Fields
820: --
821: hr_lei_bus.chk_df(p_rec => p_rec);
822: --
823: hr_utility.set_location('Leaving: '||l_proc, 25);
824: --
825: --
826: End update_validate;
827: --

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

832: --
833: l_proc varchar2(72) := g_package||'delete_validate';
834: --
835: Begin
836: hr_utility.set_location('Entering:'||l_proc, 5);
837: --
838: -- Call all supporting business operations
839: --
840: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

836: hr_utility.set_location('Entering:'||l_proc, 5);
837: --
838: -- Call all supporting business operations
839: --
840: hr_utility.set_location(' Leaving:'||l_proc, 10);
841: End delete_validate;
842: --
843: end hr_lei_bus;