DBA Data[Home] [Help]

APPS.BEN_EDB_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_edb_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_dsbld_prte_id => p_elig_dsbld_prte_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_elig_dsbld_prte_id;
78: --
79: -- ---------------------------------------------------------------------------

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

119: and ordr_num = p_ordr_num
120: and business_group_id = p_business_group_id;
121: --
122: Begin
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: open c1;
126: fetch c1 into l_dummy;
127: if c1%found then

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

130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);
135: End chk_duplicate_ordr_num;
136: --
137: -- ----------------------------------------------------------------------------
138: -- |------< chk_excld_flag >------|

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

169: l_api_updating boolean;
170: --
171: Begin
172: --
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: --
175: l_api_updating := ben_edb_shd.api_updating
176: (p_elig_dsbld_prte_id => p_elig_dsbld_prte_id,
177: p_effective_date => p_effective_date,

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

198: end if;
199: --
200: end if;
201: --
202: hr_utility.set_location('Leaving:'||l_proc,10);
203: --
204: end chk_excld_flag;
205: --
206: -- ----------------------------------------------------------------------------

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

238: l_api_updating boolean;
239: --
240: Begin
241: --
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: l_api_updating := ben_edb_shd.api_updating
245: (p_elig_dsbld_prte_id => p_elig_dsbld_prte_id,
246: p_effective_date => p_effective_date,

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

267: end if;
268: --
269: end if;
270: --
271: hr_utility.set_location('Leaving:'||l_proc,10);
272: --
273: end chk_dsbld_cd;
274: --
275: -- ----------------------------------------------------------------------------

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

315: and edb.elig_dsbld_prte_id <> nvl(p_elig_dsbld_prte_id, hr_api.g_number) ;
316: --
317: Begin
318: --
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: --
321: l_api_updating := ben_edb_shd.api_updating
322: (p_elig_dsbld_prte_id => p_elig_dsbld_prte_id,
323: p_effective_date => p_effective_date,

Line 333: hr_utility.set_location(l_proc, 7);

329: fetch c_elig_dsbld_prte into l_dummy;
330: if c_elig_dsbld_prte%found then
331: --
332: close c_elig_dsbld_prte;
333: hr_utility.set_location(l_proc, 7);
334: --
335: -- raise error as duplicate criteria has been entered
336: --
337: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');

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

340: end if;
341: --
342: close c_elig_dsbld_prte;
343: --
344: hr_utility.set_location('Leaving:'||l_proc,10);
345: --
346: end chk_dup_elig_criteria;
347: --
348: -- ----------------------------------------------------------------------------

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

384: l_integrity_error Exception;
385: l_table_name all_tables.table_name%TYPE;
386: --
387: Begin
388: hr_utility.set_location('Entering:'||l_proc, 5);
389: --
390: -- Ensure that the p_datetrack_mode argument is not null
391: --
392: hr_api.mandatory_arg_error

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

423: End If;
424: --
425: End If;
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: Exception
429: When l_integrity_error Then
430: --
431: -- A referential integrity check was violated therefore

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

489: l_rows_exist Exception;
490: l_table_name all_tables.table_name%TYPE;
491: --
492: Begin
493: hr_utility.set_location('Entering:'||l_proc, 5);
494: --
495: -- Ensure that the p_datetrack_mode argument is not null
496: --
497: hr_api.mandatory_arg_error

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

526: --
527: --
528: End If;
529: --
530: hr_utility.set_location(' Leaving:'||l_proc, 10);
531: Exception
532: When l_rows_exist Then
533: --
534: -- A referential integrity check was violated therefore

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

560: --
561: l_proc varchar2(72) := g_package||'insert_validate';
562: --
563: Begin
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: -- Call all supporting business operations
567: --
568: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

596: p_dsbld_cd => p_rec.dsbld_cd,
597: p_effective_date => p_effective_date,
598: p_object_version_number => p_rec.object_version_number);
599: --
600: hr_utility.set_location(' Leaving:'||l_proc, 10);
601: End insert_validate;
602: --
603: -- ----------------------------------------------------------------------------
604: -- |---------------------------< update_validate >----------------------------|

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

612: --
613: l_proc varchar2(72) := g_package||'update_validate';
614: --
615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: -- Call all supporting business operations
619: --
620: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

656: p_datetrack_mode => p_datetrack_mode,
657: p_validation_start_date => p_validation_start_date,
658: p_validation_end_date => p_validation_end_date);
659: --
660: hr_utility.set_location(' Leaving:'||l_proc, 10);
661: End update_validate;
662: --
663: -- ----------------------------------------------------------------------------
664: -- |---------------------------< delete_validate >----------------------------|

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

672: --
673: l_proc varchar2(72) := g_package||'delete_validate';
674: --
675: Begin
676: hr_utility.set_location('Entering:'||l_proc, 5);
677: --
678: -- Call all supporting business operations
679: --
680: dt_delete_validate

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

682: p_validation_start_date => p_validation_start_date,
683: p_validation_end_date => p_validation_end_date,
684: p_elig_dsbld_prte_id => p_rec.elig_dsbld_prte_id);
685: --
686: hr_utility.set_location(' Leaving:'||l_proc, 10);
687: End delete_validate;
688: --
689: --
690: -- ---------------------------------------------------------------------------

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

709: l_proc varchar2(72) := g_package||'return_legislation_code';
710: --
711: begin
712: --
713: hr_utility.set_location('Entering:'|| l_proc, 10);
714: --
715: -- Ensure that all the mandatory parameter are not null
716: --
717: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

734: end if;
735: --
736: close csr_leg_code;
737: --
738: hr_utility.set_location(' Leaving:'|| l_proc, 20);
739: --
740: return l_legislation_code;
741: --
742: end return_legislation_code;