DBA Data[Home] [Help]

APPS.BEN_ECP_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_ecp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_cmbn_age_los_prte_id => p_elig_cmbn_age_los_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_cmbn_age_los_prte_id;
78: --
79: -- ----------------------------------------------------------------------------

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

135: and a.business_group_id + 0 = p_business_group_id;
136: --
137: Begin
138: --
139: hr_utility.set_location('Entering:'||l_proc,5);
140: --
141: l_api_updating := ben_ecp_shd.api_updating
142: (p_elig_cmbn_age_los_prte_id => p_elig_cmbn_age_los_prte_id,
143: p_effective_date => p_effective_date,

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

180: close c3;
181: --
182: end if;
183: --
184: hr_utility.set_location('Leaving:'||l_proc,10);
185: --
186: End chk_cmbn_age_los_fctr_id;
187: --
188: -- ----------------------------------------------------------------------------

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

220: l_api_updating boolean;
221: --
222: Begin
223: --
224: hr_utility.set_location('Entering:'||l_proc, 5);
225: --
226: l_api_updating := ben_ecp_shd.api_updating
227: (p_elig_cmbn_age_los_prte_id => p_elig_cmbn_age_los_prte_id,
228: p_effective_date => p_effective_date,

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

249: end if;
250: --
251: end if;
252: --
253: hr_utility.set_location('Leaving:'||l_proc,10);
254: --
255: end chk_mndtry_flag;
256: --
257: -- ----------------------------------------------------------------------------

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

289: l_api_updating boolean;
290: --
291: Begin
292: --
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: l_api_updating := ben_ecp_shd.api_updating
296: (p_elig_cmbn_age_los_prte_id => p_elig_cmbn_age_los_prte_id,
297: p_effective_date => p_effective_date,

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

318: end if;
319: --
320: end if;
321: --
322: hr_utility.set_location('Leaving:'||l_proc,10);
323: --
324: end chk_excld_flag;
325: --
326: --Bug:5054189

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

367: and ordr_num = p_ordr_num
368: and business_group_id = p_business_group_id;
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: open c1;
374: fetch c1 into l_dummy;
375: if c1%found then

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

378: fnd_message.raise_error;
379: end if;
380: close c1;
381: --
382: hr_utility.set_location('Leaving:'||l_proc, 15);
383: End chk_duplicate_ordr_num;
384: -- ----------------------------------------------------------------------------
385: -- |--------------------------< dt_update_validate >--------------------------|
386: -- ----------------------------------------------------------------------------

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

420: l_integrity_error Exception;
421: l_table_name all_tables.table_name%TYPE;
422: --
423: Begin
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: -- Ensure that the p_datetrack_mode argument is not null
427: --
428: hr_api.mandatory_arg_error

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

459: End If;
460: --
461: End If;
462: --
463: hr_utility.set_location(' Leaving:'||l_proc, 10);
464: Exception
465: When l_integrity_error Then
466: --
467: -- A referential integrity check was violated therefore

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

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

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

562: --
563: --
564: End If;
565: --
566: hr_utility.set_location(' Leaving:'||l_proc, 10);
567: Exception
568: When l_rows_exist Then
569: --
570: -- A referential integrity check was violated therefore

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

595: --
596: l_proc varchar2(72) := g_package||'insert_validate';
597: --
598: Begin
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: -- Call all supporting business operations
602: --
603: --

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

635: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
636: ,p_ordr_num => p_rec.ordr_num
637: ,p_business_group_id => p_rec.business_group_id);
638: --
639: hr_utility.set_location(' Leaving:'||l_proc, 10);
640: End insert_validate;
641: --
642: -- ----------------------------------------------------------------------------
643: -- |---------------------------< update_validate >----------------------------|

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

651: --
652: l_proc varchar2(72) := g_package||'update_validate';
653: --
654: Begin
655: hr_utility.set_location('Entering:'||l_proc, 5);
656: --
657: -- Call all supporting business operations
658: --
659: --

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

699: p_datetrack_mode => p_datetrack_mode,
700: p_validation_start_date => p_validation_start_date,
701: p_validation_end_date => p_validation_end_date);
702: --
703: hr_utility.set_location(' Leaving:'||l_proc, 10);
704: End update_validate;
705: --
706: -- ----------------------------------------------------------------------------
707: -- |---------------------------< delete_validate >----------------------------|

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

715: --
716: l_proc varchar2(72) := g_package||'delete_validate';
717: --
718: Begin
719: hr_utility.set_location('Entering:'||l_proc, 5);
720: --
721: -- Call all supporting business operations
722: --
723: dt_delete_validate

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

725: p_validation_start_date => p_validation_start_date,
726: p_validation_end_date => p_validation_end_date,
727: p_elig_cmbn_age_los_prte_id => p_rec.elig_cmbn_age_los_prte_id);
728: --
729: hr_utility.set_location(' Leaving:'||l_proc, 10);
730: End delete_validate;
731: --
732: --
733: -- ---------------------------------------------------------------------------

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

752: l_proc varchar2(72) := g_package||'return_legislation_code';
753: --
754: begin
755: --
756: hr_utility.set_location('Entering:'|| l_proc, 10);
757: --
758: -- Ensure that all the mandatory parameter are not null
759: --
760: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

777: end if;
778: --
779: close csr_leg_code;
780: --
781: hr_utility.set_location(' Leaving:'|| l_proc, 20);
782: --
783: return l_legislation_code;
784: --
785: end return_legislation_code;