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.PER_EST_BUS dependencies on HR_UTILITY

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

51: and a.location = p_location;
52: --
53: begin
54: --
55: hr_utility.set_location('Entering:'||l_proc,5);
56: --
57: l_api_updating := per_est_shd.api_updating
58: (p_establishment_id => p_establishment_id,
59: p_object_version_number => p_object_version_number);

Line 74: hr_utility.set_message(801,'HR_51487_EST_CHK_NAME_NOT_NULL');

70: if p_name is null then
71: --
72: -- raise error as name must be not null
73: --
74: hr_utility.set_message(801,'HR_51487_EST_CHK_NAME_NOT_NULL');
75: hr_utility.raise_error;
76: --
77: end if;
78: --

Line 75: hr_utility.raise_error;

71: --
72: -- raise error as name must be not null
73: --
74: hr_utility.set_message(801,'HR_51487_EST_CHK_NAME_NOT_NULL');
75: hr_utility.raise_error;
76: --
77: end if;
78: --
79: if p_location is null then

Line 83: hr_utility.set_message(801,'HR_51488_EST_CHK_LOC_NOT_NULL');

79: if p_location is null then
80: --
81: -- raise error as location must be not null
82: --
83: hr_utility.set_message(801,'HR_51488_EST_CHK_LOC_NOT_NULL');
84: hr_utility.raise_error;
85: --
86: end if;
87: --

Line 84: hr_utility.raise_error;

80: --
81: -- raise error as location must be not null
82: --
83: hr_utility.set_message(801,'HR_51488_EST_CHK_LOC_NOT_NULL');
84: hr_utility.raise_error;
85: --
86: end if;
87: --
88: -- check if establishment and location are unique.

Line 107: hr_utility.set_location('Leaving:'||l_proc,5);

103: close c1;
104: --
105: end if;
106: --
107: hr_utility.set_location('Leaving:'||l_proc,5);
108: --
109: end chk_name_location_unique;
110: -- ----------------------------------------------------------------------------
111: -- |-------------------------< chk_establishment_id >-------------------------|

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

137: l_api_updating boolean;
138: --
139: Begin
140: --
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: l_api_updating := per_est_shd.api_updating
144: (p_establishment_id => p_establishment_id,
145: p_object_version_number => p_object_version_number);

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

163: per_est_shd.constraint_error('PER_ESTABLISHMENTS_PK');
164: --
165: end if;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: --
169: end chk_establishment_id;
170: --
171: -- ----------------------------------------------------------------------------

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

202: where per.establishment_id = p_establishment_id;
203: --
204: Begin
205: --
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: -- check if the establishment_id is referenced in the per_estab_attendances
209: -- table
210: --

Line 219: hr_utility.set_message(801,'HR_51486_EST_CHK_DELETE_EST');

215: if c1%found then
216: --
217: -- raise error as records exist that reference this primary key
218: --
219: hr_utility.set_message(801,'HR_51486_EST_CHK_DELETE_EST');
220: hr_utility.raise_error;
221: --
222: end if;
223: --

Line 220: hr_utility.raise_error;

216: --
217: -- raise error as records exist that reference this primary key
218: --
219: hr_utility.set_message(801,'HR_51486_EST_CHK_DELETE_EST');
220: hr_utility.raise_error;
221: --
222: end if;
223: --
224: close c1;

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

222: end if;
223: --
224: close c1;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: --
228: end chk_estab_delete;
229: --
230: -- -----------------------------------------------------------------------

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

259: --
260: l_proc varchar2(72) := g_package||'chk_df';
261: --
262: begin
263: hr_utility.set_location('Entering:'||l_proc, 10);
264: --
265: if ((p_rec.establishment_id is not null) and (
266: nvl(per_est_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

359: ,p_attribute20_value => p_rec.attribute20
360: );
361: end if;
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 20);
364:
365: end chk_df;
366: -- ----------------------------------------------------------------------------
367: -- |-----------------------------< chk_ddf >----------------------------------|

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

397: --
398: l_proc varchar2(72) := g_package || 'chk_ddf';
399: --
400: begin
401: hr_utility.set_location('Entering:'||l_proc,10);
402: --
403: if ((p_rec.establishment_id is not null) and (
404: nvl(per_est_shd.g_old_rec.est_information_category, hr_api.g_varchar2) <>
405: nvl(p_rec.est_information_category, hr_api.g_varchar2) or

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

496: ,p_attribute20_value => p_rec.est_information20
497: );
498: end if;
499: --
500: hr_utility.set_location(' Leaving:'||l_proc,20);
501: end chk_ddf;
502: -- ----------------------------------------------------------------------------
503: -- |---------------------------< insert_validate >----------------------------|
504: -- ----------------------------------------------------------------------------

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

506: --
507: l_proc varchar2(72) := g_package||'insert_validate';
508: --
509: Begin
510: hr_utility.set_location('Entering:'||l_proc, 5);
511: --
512: -- As this data is not within the context of a business group
513: -- the set_security_group_id procedure has zero passed
514: -- to it as the default security_group_id.

Line 522: hr_utility.set_location('Entering:'||l_proc, 7);

518: Else
519: hr_api.set_security_group_id(p_security_group_id => 0);
520: End If;
521: --
522: hr_utility.set_location('Entering:'||l_proc, 7);
523: --
524: -- Call all supporting business operations
525: --
526: -- Business Rule Mapping

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

544: per_est_bus.chk_df(p_rec => p_rec);
545: --
546: per_est_bus.chk_ddf(p_rec);
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);
549: End insert_validate;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |---------------------------< update_validate >----------------------------|

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

555: --
556: l_proc varchar2(72) := g_package||'update_validate';
557: --
558: Begin
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: --
561: -- As this data is not within the context of a business group
562: -- the set_security_group_id procedure has zero passed
563: -- to it as the default security_group_id.

Line 571: hr_utility.set_location('Entering:'||l_proc, 7);

567: Else
568: hr_api.set_security_group_id(p_security_group_id => 0);
569: End If;
570: --
571: hr_utility.set_location('Entering:'||l_proc, 7);
572: --
573: -- Call all supporting business operations
574: --
575: -- Business Rule Mapping

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

593: per_est_bus.chk_df(p_rec => p_rec);
594: --
595: per_est_bus.chk_ddf(p_rec);
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 10);
598: End update_validate;
599: --
600: -- ----------------------------------------------------------------------------
601: -- |---------------------------< delete_validate >----------------------------|

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

604: --
605: l_proc varchar2(72) := g_package||'delete_validate';
606: --
607: Begin
608: hr_utility.set_location('Entering:'||l_proc, 5);
609: --
610: -- Call all supporting business operations
611: --
612: -- Business Rule Mapping

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

614: -- CHK_ESTAB_DELETE
615: --
616: chk_estab_delete(p_rec.establishment_id);
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 10);
619: End delete_validate;
620: --
621: end per_est_bus;