DBA Data[Home] [Help]

APPS.BEN_EPS_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_eps_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_pstn_prte_id => p_elig_pstn_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_pstn_prte_id;
78: --
79: --

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

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

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

154: close c1;
155: --
156: end if;
157: --
158: hr_utility.set_location('Leaving:'||l_proc,10);
159: --
160: End chk_position_id;
161: --
162: -- ----------------------------------------------------------------------------

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

194: l_api_updating boolean;
195: --
196: Begin
197: --
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: l_api_updating := ben_eps_shd.api_updating
201: (p_elig_pstn_prte_id => p_elig_pstn_prte_id,
202: p_effective_date => p_effective_date,

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

223: end if;
224: --
225: end if;
226: --
227: hr_utility.set_location('Leaving:'||l_proc,10);
228: --
229: end chk_excld_flag;
230: --
231: -- ----------------------------------------------------------------------------

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

271: and eps.elig_pstn_prte_id <> nvl(p_elig_pstn_prte_id, hr_api.g_number) ;
272: --
273: Begin
274: --
275: hr_utility.set_location('Entering:'||l_proc, 5);
276: --
277: l_api_updating := ben_eps_shd.api_updating
278: (p_elig_pstn_prte_id => p_elig_pstn_prte_id,
279: p_effective_date => p_effective_date,

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

285: fetch c_elig_pstn_prte into l_dummy;
286: if c_elig_pstn_prte%found then
287: --
288: close c_elig_pstn_prte;
289: hr_utility.set_location(l_proc, 7);
290: --
291: -- raise error as duplicate criteria has been entered
292: --
293: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');

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

296: end if;
297: --
298: close c_elig_pstn_prte;
299: --
300: hr_utility.set_location('Leaving:'||l_proc,10);
301: --
302: end chk_dup_elig_criteria;
303: --
304: -- ---------------------------------------------------------------------------

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

344: and ordr_num = p_ordr_num
345: and business_group_id = p_business_group_id;
346: --
347: Begin
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: open c1;
351: fetch c1 into l_dummy;
352: if c1%found then

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

355: fnd_message.raise_error;
356: end if;
357: close c1;
358: --
359: hr_utility.set_location('Leaving:'||l_proc, 15);
360: End chk_duplicate_ordr_num;
361: --
362: -- ----------------------------------------------------------------------------
363: -- |--------------------------< dt_update_validate >--------------------------|

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

400: l_integrity_error Exception;
401: l_table_name all_tables.table_name%TYPE;
402: --
403: Begin
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: -- Ensure that the p_datetrack_mode argument is not null
407: --
408: hr_api.mandatory_arg_error

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

439: End If;
440: --
441: End If;
442: --
443: hr_utility.set_location(' Leaving:'||l_proc, 10);
444: Exception
445: When l_integrity_error Then
446: --
447: -- A referential integrity check was violated therefore

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

504: l_rows_exist Exception;
505: l_table_name all_tables.table_name%TYPE;
506: --
507: Begin
508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: -- Ensure that the p_datetrack_mode argument is not null
511: --
512: hr_api.mandatory_arg_error

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

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

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

573: --
574: l_proc varchar2(72) := g_package||'insert_validate';
575: --
576: Begin
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: -- Call all supporting business operations
580: --
581: chk_elig_pstn_prte_id

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

603: p_object_version_number => p_rec.object_version_number);
604: --
605: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
606: --
607: hr_utility.set_location(' Leaving:'||l_proc, 10);
608: End insert_validate;
609: --
610: -- ----------------------------------------------------------------------------
611: -- |---------------------------< update_validate >----------------------------|

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

619: --
620: l_proc varchar2(72) := g_package||'update_validate';
621: --
622: Begin
623: hr_utility.set_location('Entering:'||l_proc, 5);
624: --
625: -- Call all supporting business operations
626: --
627: chk_elig_pstn_prte_id

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

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

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

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

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

685: p_validation_start_date => p_validation_start_date,
686: p_validation_end_date => p_validation_end_date,
687: p_elig_pstn_prte_id => p_rec.elig_pstn_prte_id);
688: --
689: hr_utility.set_location(' Leaving:'||l_proc, 10);
690: End delete_validate;
691: --
692: --
693: -- ---------------------------------------------------------------------------

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

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

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

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