DBA Data[Home] [Help]

APPS.BEN_EOP_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_eop_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ELIG_ANTHR_PL_PRTE_id => p_ELIG_ANTHR_PL_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_ANTHR_PL_PRTE_id;
78: --
79: --

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

121: between pln.effective_start_date and pln.effective_end_date;
122: --
123: Begin
124: --
125: hr_utility.set_location('Entering:'||l_proc,5);
126: --
127: l_api_updating := ben_eop_shd.api_updating
128: (p_ELIG_ANTHR_PL_PRTE_id => p_ELIG_ANTHR_PL_PRTE_id,
129: p_effective_date => p_effective_date,

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

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

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

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

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

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

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

272: and eop.ELIG_ANTHR_PL_PRTE_id <> nvl(p_ELIG_ANTHR_PL_PRTE_id, hr_api.g_number) ;
273: --
274: Begin
275: --
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: --
278: l_api_updating := ben_eop_shd.api_updating
279: (p_ELIG_ANTHR_PL_PRTE_id => p_ELIG_ANTHR_PL_PRTE_id,
280: p_effective_date => p_effective_date,

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

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

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

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

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

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

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

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

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

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

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

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

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

505: l_rows_exist Exception;
506: l_table_name all_tables.table_name%TYPE;
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Ensure that the p_datetrack_mode argument is not null
512: --
513: 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_rows_exist Then
549: --
550: -- A referential integrity check was violated therefore

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

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

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

611: p_object_version_number => p_rec.object_version_number);
612: --
613: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
614: --
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: End insert_validate;
617: --
618: -- ----------------------------------------------------------------------------
619: -- |---------------------------< update_validate >----------------------------|

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

627: --
628: l_proc varchar2(72) := g_package||'update_validate';
629: --
630: Begin
631: hr_utility.set_location('Entering:'||l_proc, 5);
632: --
633: -- Call all supporting business operations
634: --
635: chk_ELIG_ANTHR_PL_PRTE_id

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

674: p_datetrack_mode => p_datetrack_mode,
675: p_validation_start_date => p_validation_start_date,
676: p_validation_end_date => p_validation_end_date);
677: --
678: hr_utility.set_location(' Leaving:'||l_proc, 10);
679: End update_validate;
680: --
681: -- ----------------------------------------------------------------------------
682: -- |---------------------------< delete_validate >----------------------------|

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

690: --
691: l_proc varchar2(72) := g_package||'delete_validate';
692: --
693: Begin
694: hr_utility.set_location('Entering:'||l_proc, 5);
695: --
696: -- Call all supporting business operations
697: --
698: dt_delete_validate

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

700: p_validation_start_date => p_validation_start_date,
701: p_validation_end_date => p_validation_end_date,
702: p_ELIG_ANTHR_PL_PRTE_id => p_rec.ELIG_ANTHR_PL_PRTE_id);
703: --
704: hr_utility.set_location(' Leaving:'||l_proc, 10);
705: End delete_validate;
706: --
707: --
708: -- ---------------------------------------------------------------------------

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

727: l_proc varchar2(72) := g_package||'return_legislation_code';
728: --
729: begin
730: --
731: hr_utility.set_location('Entering:'|| l_proc, 10);
732: --
733: -- Ensure that all the mandatory parameter are not null
734: --
735: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

752: end if;
753: --
754: close csr_leg_code;
755: --
756: hr_utility.set_location(' Leaving:'|| l_proc, 20);
757: --
758: return l_legislation_code;
759: --
760: end return_legislation_code;