DBA Data[Home] [Help]

APPS.BEN_PDL_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_pdl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ptd_lmt_id => p_ptd_lmt_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_ptd_lmt_id;
78: --
79: -- ----------------------------------------------------------------------------

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

123: between a.effective_start_date
124: and a.effective_end_date;
125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: l_api_updating := ben_pdl_shd.api_updating
130: (p_ptd_lmt_id => p_ptd_lmt_id,
131: p_effective_date => p_effective_date,

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

144: fnd_message.raise_error;
145: end if;
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc, 15);
149: End chk_name_unique;
150: --
151: -- ----------------------------------------------------------------------------
152: -- |------< chk_comp_lvl_fctr_id >------|

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

189: where a.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
190: --
191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc,5);
194: --
195: l_api_updating := ben_pdl_shd.api_updating
196: (p_effective_date => p_effective_date,
197: p_ptd_lmt_id => p_ptd_lmt_id,

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

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

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

268: where a.balance_type_id = p_balance_type_id;
269: --
270: Begin
271: --
272: hr_utility.set_location('Entering:'||l_proc,5);
273: --
274: l_api_updating := ben_pdl_shd.api_updating
275: (p_ptd_lmt_id => p_ptd_lmt_id,
276: p_effective_date => p_effective_date,

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

302: close c1;
303: --
304: end if;
305: --
306: hr_utility.set_location('Leaving:'||l_proc,10);
307: --
308: End chk_balance_type_id;
309: --
310: -- ----------------------------------------------------------------------------

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

342: l_api_updating boolean;
343: --
344: Begin
345: --
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: l_api_updating := ben_pdl_shd.api_updating
349: (p_ptd_lmt_id => p_ptd_lmt_id,
350: p_effective_date => p_effective_date,

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

373: end if;
374: --
375: end if;
376: --
377: hr_utility.set_location('Leaving:'||l_proc,10);
378: --
379: end chk_lmt_det_cd;
380: --
381: -- ----------------------------------------------------------------------------

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

430: and ff.effective_end_date;
431: --
432: Begin
433: --
434: hr_utility.set_location('Entering:'||l_proc, 5);
435: --
436: l_api_updating := ben_pdl_shd.api_updating
437: (p_ptd_lmt_id => p_ptd_lmt_id,
438: p_effective_date => p_effective_date,

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

468: close c1;
469: --
470: end if;
471: --
472: hr_utility.set_location('Leaving:'||l_proc,10);
473: --
474: end chk_ptd_lmt_calc_rl;
475: --
476: -- ----------------------------------------------------------------------------

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

512: l_integrity_error Exception;
513: l_table_name all_tables.table_name%TYPE;
514: --
515: Begin
516: hr_utility.set_location('Entering:'||l_proc, 5);
517: --
518: -- Ensure that the p_datetrack_mode argument is not null
519: --
520: hr_api.mandatory_arg_error

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

542: --
543: --
544: End If;
545: --
546: hr_utility.set_location(' Leaving:'||l_proc, 10);
547: Exception
548: When l_integrity_error Then
549: --
550: -- A referential integrity check was violated therefore

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

608: l_rows_exist Exception;
609: l_table_name all_tables.table_name%TYPE;
610: --
611: Begin
612: hr_utility.set_location('Entering:'||l_proc, 5);
613: --
614: -- Ensure that the p_datetrack_mode argument is not null
615: --
616: hr_api.mandatory_arg_error

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

653: End If;
654: --
655: End If;
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 10);
658: Exception
659: When l_rows_exist Then
660: --
661: -- A referential integrity check was violated therefore

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

686: --
687: l_proc varchar2(72) := g_package||'insert_validate';
688: --
689: Begin
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: -- Call all supporting business operations
693: --
694: --

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

728: p_business_group_id => p_rec.business_group_id,
729: p_effective_date => p_effective_date,
730: p_object_version_number => p_rec.object_version_number);
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 10);
733: End insert_validate;
734: --
735: -- ----------------------------------------------------------------------------
736: -- |---------------------------< update_validate >----------------------------|

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

744: --
745: l_proc varchar2(72) := g_package||'update_validate';
746: --
747: Begin
748: hr_utility.set_location('Entering:'||l_proc, 5);
749: --
750: -- Call all supporting business operations
751: --
752: --

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

794: p_datetrack_mode => p_datetrack_mode,
795: p_validation_start_date => p_validation_start_date,
796: p_validation_end_date => p_validation_end_date);
797: --
798: hr_utility.set_location(' Leaving:'||l_proc, 10);
799: End update_validate;
800: --
801: -- ----------------------------------------------------------------------------
802: -- |---------------------------< delete_validate >----------------------------|

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

810: --
811: l_proc varchar2(72) := g_package||'delete_validate';
812: --
813: Begin
814: hr_utility.set_location('Entering:'||l_proc, 5);
815: --
816: -- Call all supporting business operations
817: --
818: dt_delete_validate

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

820: p_validation_start_date => p_validation_start_date,
821: p_validation_end_date => p_validation_end_date,
822: p_ptd_lmt_id => p_rec.ptd_lmt_id);
823: --
824: hr_utility.set_location(' Leaving:'||l_proc, 10);
825: End delete_validate;
826: --
827: --
828: -- ---------------------------------------------------------------------------

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

847: l_proc varchar2(72) := g_package||'return_legislation_code';
848: --
849: begin
850: --
851: hr_utility.set_location('Entering:'|| l_proc, 10);
852: --
853: -- Ensure that all the mandatory parameter are not null
854: --
855: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

872: end if;
873: --
874: close csr_leg_code;
875: --
876: hr_utility.set_location(' Leaving:'|| l_proc, 20);
877: --
878: return l_legislation_code;
879: --
880: end return_legislation_code;