DBA Data[Home] [Help]

APPS.BEN_DRR_BUS dependencies on HR_UTILITY

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

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

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

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

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

118: and a.effective_end_date;
119: --
120: Begin
121: --
122: hr_utility.set_location('Entering:'||l_proc,5);
123: --
124: l_api_updating := ben_drr_shd.api_updating
125: (p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id,
126: p_object_version_number => p_object_version_number);

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

149: close c1;
150: --
151: end if;
152: --
153: hr_utility.set_location('Leaving:'||l_proc,10);
154: --
155: End chk_dsgn_rqmt_id;
156: --
157: -- ----------------------------------------------------------------------------

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

222: );
223: --
224: Begin
225: --
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: l_api_updating := ben_drr_shd.api_updating
229: (p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id,
230: p_object_version_number => p_object_version_number);

Line 248: --Bug 2736727 Changed parameter to 805 frm 'BEN' in hr_utility call.

244: p_effective_date => p_effective_date) then
245: --
246: -- raise error as does not exist as lookup
247: --
248: --Bug 2736727 Changed parameter to 805 frm 'BEN' in hr_utility call.
249:
250: hr_utility.set_message(805,'BEN_91964_INVLD_RLSHP_TYP');
251: hr_utility.raise_error;
252: --

Line 250: hr_utility.set_message(805,'BEN_91964_INVLD_RLSHP_TYP');

246: -- raise error as does not exist as lookup
247: --
248: --Bug 2736727 Changed parameter to 805 frm 'BEN' in hr_utility call.
249:
250: hr_utility.set_message(805,'BEN_91964_INVLD_RLSHP_TYP');
251: hr_utility.raise_error;
252: --
253: end if;
254: */

Line 251: hr_utility.raise_error;

247: --
248: --Bug 2736727 Changed parameter to 805 frm 'BEN' in hr_utility call.
249:
250: hr_utility.set_message(805,'BEN_91964_INVLD_RLSHP_TYP');
251: hr_utility.raise_error;
252: --
253: end if;
254: */
255: open c_lookup_exists (cv_business_group_id => p_business_group_id,

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

271: close c_lookup_exists;
272: --
273: end if;
274: --
275: hr_utility.set_location('Leaving:'||l_proc,10);
276: --
277: end chk_rlshp_typ_cd;
278: --
279: --

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

325: and dsgn_rqmt_rlshp_typ_id <> nvl(p_dsgn_rqmt_rlshp_typ_id, -999);
326: --
327: Begin
328: --
329: hr_utility.set_location('Entering:'||l_proc,5);
330: --
331: --
332: -- check if dsgn_rqmt_id value exists in ben_dsgn_rqmt_f table
333: --

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

346: --
347: end if;
348: --
349: --
350: hr_utility.set_location('Leaving:'||l_proc,10);
351: --
352: End chk_dsgn_rqmt_rlshp_uniq;
353: --
354: -- end bug 2837189

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

361: --
362: l_proc varchar2(72) := g_package||'insert_validate';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: -- Call all supporting business operations
368: --
369: --

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

387: p_dsgn_rqmt_id => p_rec.dsgn_rqmt_id,
388: p_business_group_id => p_rec.business_group_id,
389: p_object_version_number => p_rec.object_version_number );
390: --
391: hr_utility.set_location(' Leaving:'||l_proc, 10);
392: End insert_validate;
393: --
394: -- ----------------------------------------------------------------------------
395: -- |---------------------------< update_validate >----------------------------|

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

399: --
400: l_proc varchar2(72) := g_package||'update_validate';
401: --
402: Begin
403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: -- Call all supporting business operations
406: --
407: --

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

425: p_dsgn_rqmt_id => p_rec.dsgn_rqmt_id,
426: p_business_group_id => p_rec.business_group_id,
427: p_object_version_number => p_rec.object_version_number );
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 10);
430: End update_validate;
431: --
432: -- ----------------------------------------------------------------------------
433: -- |---------------------------< delete_validate >----------------------------|

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

437: --
438: l_proc varchar2(72) := g_package||'delete_validate';
439: --
440: Begin
441: hr_utility.set_location('Entering:'||l_proc, 5);
442: --
443: -- Call all supporting business operations
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

441: hr_utility.set_location('Entering:'||l_proc, 5);
442: --
443: -- Call all supporting business operations
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 10);
446: End delete_validate;
447: --
448: --
449: -- ---------------------------------------------------------------------------

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

468: l_proc varchar2(72) := g_package||'return_legislation_code';
469: --
470: begin
471: --
472: hr_utility.set_location('Entering:'|| l_proc, 10);
473: --
474: -- Ensure that all the mandatory parameter are not null
475: --
476: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 490: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

486: close csr_leg_code;
487: --
488: -- The primary key is invalid therefore we must error
489: --
490: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
491: hr_utility.raise_error;
492: --
493: end if;
494: --

Line 491: hr_utility.raise_error;

487: --
488: -- The primary key is invalid therefore we must error
489: --
490: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
491: hr_utility.raise_error;
492: --
493: end if;
494: --
495: close csr_leg_code;

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

493: end if;
494: --
495: close csr_leg_code;
496: --
497: hr_utility.set_location(' Leaving:'|| l_proc, 20);
498: --
499: return l_legislation_code;
500: --
501: end return_legislation_code;