DBA Data[Home] [Help]

APPS.BEN_CMT_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_cmt_shd.api_updating
48: (p_cm_dlvry_mthd_typ_id => p_cm_dlvry_mthd_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_cm_dlvry_mthd_typ_id;
76: --
77: -- ----------------------------------------------------------------------------

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

113: where a.cm_typ_id = p_cm_typ_id;
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'||l_proc,5);
118: --
119: l_api_updating := ben_cmt_shd.api_updating
120: (p_cm_dlvry_mthd_typ_id => p_cm_dlvry_mthd_typ_id,
121: p_object_version_number => p_object_version_number);

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

145: close c1;
146: --
147: end if;
148: --
149: hr_utility.set_location('Leaving:'||l_proc,10);
150: --
151: End chk_cm_typ_id;
152: --
153: -- ----------------------------------------------------------------------------

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

185: l_api_updating boolean;
186: --
187: Begin
188: --
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: l_api_updating := ben_cmt_shd.api_updating
192: (p_cm_dlvry_mthd_typ_id => p_cm_dlvry_mthd_typ_id,
193: p_object_version_number => p_object_version_number);

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

213: end if;
214: --
215: end if;
216: --
217: hr_utility.set_location('Leaving:'||l_proc,10);
218: --
219: end chk_dflt_flag;
220: --
221: -- ----------------------------------------------------------------------------

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

253: l_api_updating boolean;
254: --
255: Begin
256: --
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: l_api_updating := ben_cmt_shd.api_updating
260: (p_cm_dlvry_mthd_typ_id => p_cm_dlvry_mthd_typ_id,
261: p_object_version_number => p_object_version_number);

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

281: end if;
282: --
283: end if;
284: --
285: hr_utility.set_location('Leaving:'||l_proc,10);
286: --
287: end chk_rqd_flag;
288: --
289: -- ----------------------------------------------------------------------------

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

322: l_api_updating boolean;
323: --
324: Begin
325: --
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: l_api_updating := ben_cmt_shd.api_updating
329: (p_cm_dlvry_mthd_typ_id => p_cm_dlvry_mthd_typ_id,
330: p_object_version_number => p_object_version_number);

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

350: end if;
351: --
352: end if;
353: --
354: hr_utility.set_location('Leaving:'||l_proc,10);
355: --
356: end chk_cm_dlvry_mthd_typ_cd;
357: --
358: -- --------------------------------------------------------------------------

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

406: and business_group_id + 0 = p_business_group_id ;
407: --
408: Begin
409: --
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: l_api_updating := ben_cmt_shd.api_updating
413: ( p_cm_dlvry_mthd_typ_id => p_cm_dlvry_mthd_typ_id,
414: p_object_version_number => p_object_version_number);

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

417: and p_cm_dlvry_mthd_typ_cd <> ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd)
418: or
419: not l_api_updating then
420: --
421: hr_utility.set_location('Entering:'||l_proc, 10);
422: --
423: -- check if this code is already exist
424: --
425: open crs_cm_dlvry_mthd;

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

438: close crs_cm_dlvry_mthd;
439: --
440: end if;
441: --
442: hr_utility.set_location('Leaving:'||l_proc, 20);
443: --
444: End chk_dupl_cm_dlvry_mthd;
445:
446: -- ----------------------------------------------------------------------------

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

451: --
452: l_proc varchar2(72) := g_package||'insert_validate';
453: --
454: Begin
455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: -- Call all supporting business operations
458: --
459: --

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

493: p_effective_date => p_effective_date,
494: p_business_group_id => p_rec.business_group_id,
495: p_object_version_number => p_rec.object_version_number);
496: --
497: hr_utility.set_location(' Leaving:'||l_proc, 10);
498: End insert_validate;
499: --
500: -- ----------------------------------------------------------------------------
501: -- |---------------------------< update_validate >----------------------------|

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

505: --
506: l_proc varchar2(72) := g_package||'update_validate';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Call all supporting business operations
512: --
513: --

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

547: p_effective_date => p_effective_date,
548: p_business_group_id => p_rec.business_group_id,
549: p_object_version_number => p_rec.object_version_number);
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 10);
552: End update_validate;
553: --
554: -- ----------------------------------------------------------------------------
555: -- |---------------------------< delete_validate >----------------------------|

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

559: --
560: l_proc varchar2(72) := g_package||'delete_validate';
561: --
562: Begin
563: hr_utility.set_location('Entering:'||l_proc, 5);
564: --
565: -- Call all supporting business operations
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

563: hr_utility.set_location('Entering:'||l_proc, 5);
564: --
565: -- Call all supporting business operations
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 10);
568: End delete_validate;
569: --
570: --
571: -- ---------------------------------------------------------------------------

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

590: l_proc varchar2(72) := g_package||'return_legislation_code';
591: --
592: begin
593: --
594: hr_utility.set_location('Entering:'|| l_proc, 10);
595: --
596: -- Ensure that all the mandatory parameter are not null
597: --
598: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

608: close csr_leg_code;
609: --
610: -- The primary key is invalid therefore we must error
611: --
612: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
613: hr_utility.raise_error;
614: --
615: end if;
616: --

Line 613: hr_utility.raise_error;

609: --
610: -- The primary key is invalid therefore we must error
611: --
612: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
613: hr_utility.raise_error;
614: --
615: end if;
616: --
617: close csr_leg_code;

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

615: end if;
616: --
617: close csr_leg_code;
618: --
619: hr_utility.set_location(' Leaving:'|| l_proc, 20);
620: --
621: return l_legislation_code;
622: --
623: end return_legislation_code;