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

689: l_legislation_code varchar2(150);
690: -- 6329528
691:
692: Begin
693: hr_utility.set_location('Entering:'||l_proc, 5);
694: --
695: -- As this data is not within the context of a business group
696: -- the set_security_group_id procedure has zero passed
697: -- to it as the default security_group_id.

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

704: close csr_sec_grp;
705: hr_api.set_security_group_id(p_security_group_id => l_security_group_id);
706: --
707: --
708: hr_utility.set_location('Entering:'||l_proc, 6);
709: --
710: -- Call all supporting business operations
711: --
712: -- 1) Call chk_location_id to validate location_id

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

727: -- Call ddf procedure to validate Developer Descritive Flex Fields
728: --
729: hr_lei_bus.chk_ddf(p_rec => p_rec);
730: --
731: hr_utility.set_location(l_proc, 10);
732: --
733: -- Call df procedure to validate Descritive Flex Fields
734: --
735: hr_lei_bus.chk_df(p_rec => p_rec);

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

733: -- Call df procedure to validate Descritive Flex Fields
734: --
735: hr_lei_bus.chk_df(p_rec => p_rec);
736: --
737: hr_utility.set_location(' Leaving:'||l_proc, 20);
738: --
739: --
740: End insert_validate;
741: --

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

757: l_security_group_id number;
758: l_legislation_code varchar2(150);
759: -- bug 6329528
760: Begin
761: hr_utility.set_location('Entering:'||l_proc, 5);
762: --
763: -- As this data is not within the context of a business group
764: -- the set_security_group_id procedure has zero passed
765: -- to it as the default security_group_id.

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

774: hr_api.set_security_group_id(p_security_group_id => l_security_group_id);
775: --
776:
777: --
778: hr_utility.set_location('Entering:'||l_proc, 6);
779: --
780: -- Call all supporting business operations
781: --
782: -- 1) Check those columns which cannot be updated have not changed.

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

780: -- Call all supporting business operations
781: --
782: -- 1) Check those columns which cannot be updated have not changed.
783: --
784: hr_utility.set_location(l_proc, 10);
785: --
786: chk_non_updateable_args (p_rec => p_rec);
787: --
788: -- Call ddf procedure to validate Developer Descritive Flex Fields

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

788: -- Call ddf procedure to validate Developer Descritive Flex Fields
789: --
790: hr_lei_bus.chk_ddf(p_rec => p_rec);
791: --
792: hr_utility.set_location(l_proc, 10);
793: --
794: -- Call df procedure to validate Descritive Flex Fields
795: --
796: hr_lei_bus.chk_df(p_rec => p_rec);

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

794: -- Call df procedure to validate Descritive Flex Fields
795: --
796: hr_lei_bus.chk_df(p_rec => p_rec);
797: --
798: hr_utility.set_location('Leaving: '||l_proc, 25);
799: --
800: --
801: End update_validate;
802: --

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

807: --
808: l_proc varchar2(72) := g_package||'delete_validate';
809: --
810: Begin
811: hr_utility.set_location('Entering:'||l_proc, 5);
812: --
813: -- Call all supporting business operations
814: --
815: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

811: hr_utility.set_location('Entering:'||l_proc, 5);
812: --
813: -- Call all supporting business operations
814: --
815: hr_utility.set_location(' Leaving:'||l_proc, 10);
816: End delete_validate;
817: --
818: end hr_lei_bus;