DBA Data[Home] [Help]

APPS.BEN_CBS_BUS dependencies on HR_UTILITY

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_cbs_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_prem_cstg_by_sgmt_id => p_prem_cstg_by_sgmt_id,

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

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

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

120: and ff.effective_end_date;
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: l_api_updating := ben_cbs_shd.api_updating
127: (p_prem_cstg_by_sgmt_id => p_prem_cstg_by_sgmt_id,
128: p_effective_date => p_effective_date,

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

156: close c1;
157: --
158: end if;
159: --
160: hr_utility.set_location('Leaving:'||l_proc,10);
161: --
162: end chk_sgmt_cstg_mthd_rl;
163: --
164: -- ----------------------------------------------------------------------------

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

196: l_api_updating boolean;
197: --
198: Begin
199: --
200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: l_api_updating := ben_cbs_shd.api_updating
203: (p_prem_cstg_by_sgmt_id => p_prem_cstg_by_sgmt_id,
204: p_effective_date => p_effective_date,

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

227: end if;
228: --
229: end if;
230: --
231: hr_utility.set_location('Leaving:'||l_proc,10);
232: --
233: end chk_sgmt_cstg_mthd_cd;
234: --
235: -- ----------------------------------------------------------------------------

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

262: l_proc varchar2(72) := g_package||'chk_code_rule_dpnd';
263: --
264: Begin
265: --
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: if p_code <> 'RL' and p_rule is not null then
269: --
270: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

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

275: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
276: fnd_message.raise_error;
277: end if;
278: -- --
279: hr_utility.set_location('Leaving:'||l_proc,10);
280: --
281: end chk_code_rule_dpnd;
282: -- ---------------------------------------------------------------------------
283: -- |-----------------------< chk_sgmt_num_unique >---------------------------|

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

321: and sgmt_num = p_sgmt_num
322: and business_group_id = p_business_group_id;
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5); --
326: open c1;
327: fetch c1 into l_dummy;
328: if c1%found then
329: close c1;

Line 334: hr_utility.set_location('Leaving:'||l_proc, 15);

330: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
331: fnd_message.raise_error;
332: end if;
333: --
334: hr_utility.set_location('Leaving:'||l_proc, 15);
335: End chk_sgmt_num_unique;
336: --
337: -- ----------------------------------------------------------------------------
338: -- |------------------------< chk_sgmt_cstg_asnmt_lvl >-----------------------|

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

378: and a.effective_end_date;
379: --
380: Begin
381: --
382: hr_utility.set_location('Entering:'||l_proc, 5);
383: --
384: if p_sgmt_cstg_mthd_cd = 'VFA' then
385: --
386: -- Check if prem_asnmt_lvl_cd is 'PLOIPL'.

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

402: close c1;
403: --
404: end if;
405: --
406: hr_utility.set_location('Leaving:'||l_proc, 10);
407: --
408: End chk_sgmt_cstg_asnmt_lvl;
409: --
410: -- ----------------------------------------------------------------------------

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

452: and a.effective_end_date;
453: --
454: Begin
455: --
456: hr_utility.set_location('Entering:'||l_proc, 5);
457: --
458: open c1;
459: --
460: fetch c1 into l_prem_asnmt_cd,l_cost_alloc_cd ;

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

484: end if;
485:
486: close c1;
487: --
488: hr_utility.set_location('Leaving:'||l_proc, 10);
489: --
490: End chk_parent_data;
491: -- ----------------------------------------------------------------------------
492: -- |--------------------------< dt_update_validate >--------------------------|

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

527: l_integrity_error Exception;
528: l_table_name all_tables.table_name%TYPE;
529: --
530: Begin
531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: -- Ensure that the p_datetrack_mode argument is not null
534: --
535: hr_api.mandatory_arg_error

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

566: End If;
567: --
568: End If;
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 10);
571: Exception
572: When l_integrity_error Then
573: --
574: -- A referential integrity check was violated therefore

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

631: l_rows_exist Exception;
632: l_table_name all_tables.table_name%TYPE;
633: --
634: Begin
635: hr_utility.set_location('Entering:'||l_proc, 5);
636: --
637: -- Ensure that the p_datetrack_mode argument is not null
638: --
639: hr_api.mandatory_arg_error

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

668: --
669: --
670: End If;
671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 10);
673: Exception
674: When l_rows_exist Then
675: --
676: -- A referential integrity check was violated therefore

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

702: --
703: l_proc varchar2(72) := g_package||'insert_validate';
704: --
705: Begin
706: hr_utility.set_location('Entering:'||l_proc, 5);
707: --
708: -- Call all supporting business operations
709: --
710: --

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

748: p_business_group_id => p_rec.business_group_id,
749: p_effective_date => p_effective_date );
750: --
751:
752: hr_utility.set_location(' Leaving:'||l_proc, 10);
753: End insert_validate;
754: --
755: -- ----------------------------------------------------------------------------
756: -- |---------------------------< update_validate >----------------------------|

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

764: --
765: l_proc varchar2(72) := g_package||'update_validate';
766: --
767: Begin
768: hr_utility.set_location('Entering:'||l_proc, 5);
769: --
770: -- Call all supporting business operations
771: --
772: --

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

817: p_datetrack_mode => p_datetrack_mode,
818: p_validation_start_date => p_validation_start_date,
819: p_validation_end_date => p_validation_end_date);
820: --
821: hr_utility.set_location(' Leaving:'||l_proc, 10);
822: End update_validate;
823: --
824: -- ----------------------------------------------------------------------------
825: -- |---------------------------< delete_validate >----------------------------|

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

833: --
834: l_proc varchar2(72) := g_package||'delete_validate';
835: --
836: Begin
837: hr_utility.set_location('Entering:'||l_proc, 5);
838: --
839: -- Call all supporting business operations
840: --
841: dt_delete_validate

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

843: p_validation_start_date => p_validation_start_date,
844: p_validation_end_date => p_validation_end_date,
845: p_prem_cstg_by_sgmt_id => p_rec.prem_cstg_by_sgmt_id);
846: --
847: hr_utility.set_location(' Leaving:'||l_proc, 10);
848: End delete_validate;
849: --
850: --
851: -- ---------------------------------------------------------------------------

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

870: l_proc varchar2(72) := g_package||'return_legislation_code';
871: --
872: begin
873: --
874: hr_utility.set_location('Entering:'|| l_proc, 10);
875: --
876: -- Ensure that all the mandatory parameter are not null
877: --
878: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

895: end if;
896: --
897: close csr_leg_code;
898: --
899: hr_utility.set_location(' Leaving:'|| l_proc, 20);
900: --
901: return l_legislation_code;
902: --
903: end return_legislation_code;