DBA Data[Home] [Help]

APPS.BEN_GOS_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_gos_shd.api_updating
47: (p_gd_or_svc_typ_id => p_gd_or_svc_typ_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_gd_or_svc_typ_id;
75: --
76: -- ----------------------------------------------------------------------------

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

108: l_api_updating boolean;
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := ben_gos_shd.api_updating
115: (p_gd_or_svc_typ_id => p_gd_or_svc_typ_id,
116: p_object_version_number => p_object_version_number);

Line 126: hr_utility.set_location('In:'||l_proc||'lookup_code='||p_typ_cd,8);

122: and p_typ_cd is not null then
123: --
124: -- check if value of lookup falls within lookup type.
125: --
126: hr_utility.set_location('In:'||l_proc||'lookup_code='||p_typ_cd,8);
127:
128: if hr_api.not_exists_in_hr_lookups
129: (p_lookup_type => 'BEN_GD_R_SVC_TYP',
130: p_lookup_code => p_typ_cd,

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

138: end if;
139: --
140: end if;
141: --
142: hr_utility.set_location('Leaving:'||l_proc,10);
143: --
144: end chk_typ_cd;
145: --
146: -- ----------------------------------------------------------------------------

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

187: and business_group_id + 0 = p_business_group_id;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: l_api_updating := ben_gos_shd.api_updating
194: (p_gd_or_svc_typ_id => p_gd_or_svc_typ_id,
195: p_object_version_number => p_object_version_number);

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

197: if (l_api_updating
198: and p_name <> ben_gos_shd.g_old_rec.name) or
199: not l_api_updating then
200: --
201: hr_utility.set_location('Entering:'||l_proc, 10);
202: --
203: -- check if this name already exist
204: --
205: open csr_name;

Line 208: hr_utility.set_location('Entering:'||l_proc, 15);

204: --
205: open csr_name;
206: fetch csr_name into l_exists;
207: if csr_name%found then
208: hr_utility.set_location('Entering:'||l_proc, 15);
209: close csr_name;
210: --
211: -- raise error as Name is not Unique
212: --

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

218: close csr_name;
219: --
220: end if;
221: --
222: hr_utility.set_location('Leaving:'||l_proc, 20);
223: --
224: End chk_name;
225: --
226:

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

233: --
234: l_proc varchar2(72) := g_package||'insert_validate';
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: -- Call all supporting business operations
240: --
241: --

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

256: p_name => p_rec.name,
257: p_business_group_id => p_rec.business_group_id,
258: p_object_version_number => p_rec.object_version_number);
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: End insert_validate;
262: --
263: -- ----------------------------------------------------------------------------
264: -- |---------------------------< update_validate >----------------------------|

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

268: --
269: l_proc varchar2(72) := g_package||'update_validate';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- Call all supporting business operations
275: --
276: --

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

291: p_name => p_rec.name,
292: p_business_group_id => p_rec.business_group_id,
293: p_object_version_number => p_rec.object_version_number);
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End update_validate;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |---------------------------< delete_validate >----------------------------|

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

303: --
304: l_proc varchar2(72) := g_package||'delete_validate';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: -- Call all supporting business operations
310: --
311: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: -- Call all supporting business operations
310: --
311: hr_utility.set_location(' Leaving:'||l_proc, 10);
312: End delete_validate;
313: --
314: --
315: -- ---------------------------------------------------------------------------

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

334: l_proc varchar2(72) := g_package||'return_legislation_code';
335: --
336: begin
337: --
338: hr_utility.set_location('Entering:'|| l_proc, 10);
339: --
340: -- Ensure that all the mandatory parameter are not null
341: --
342: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

359: end if;
360: --
361: close csr_leg_code;
362: --
363: hr_utility.set_location(' Leaving:'|| l_proc, 20);
364: --
365: return l_legislation_code;
366: --
367: end return_legislation_code;