DBA Data[Home] [Help]

APPS.BEN_ECQ_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_ecq_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_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_cbr_quald_bnf_id;
78: --
79: -- ----------------------------------------------------------------------------

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

116: where a.pgm_id = p_pgm_id;
117: --
118: Begin
119: --
120: hr_utility.set_location('Entering:'||l_proc,5);
121: --
122: l_api_updating := ben_ecq_shd.api_updating
123: (p_effective_date => p_effective_date,
124: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,

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

148: close c1;
149: --
150: end if;
151: --
152: hr_utility.set_location('Leaving:'||l_proc,10);
153: --
154: End chk_pgm_id;
155: --
156: -- ----------------------------------------------------------------------------

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

193: where a.ptip_id = p_ptip_id;
194: --
195: Begin
196: --
197: hr_utility.set_location('Entering:'||l_proc,5);
198: --
199: l_api_updating := ben_ecq_shd.api_updating
200: (p_effective_date => p_effective_date,
201: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,

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

225: close c1;
226: --
227: end if;
228: --
229: hr_utility.set_location('Leaving:'||l_proc,10);
230: --
231: End chk_ptip_id;
232: --
233: -- ----------------------------------------------------------------------------

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

265: l_api_updating boolean;
266: --
267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: l_api_updating := ben_ecq_shd.api_updating
272: (p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,
273: p_effective_date => p_effective_date,

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

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

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: -- |--------------------------< dt_update_validate >--------------------------|
364: -- ----------------------------------------------------------------------------

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 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 600: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

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

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

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

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

694: p_datetrack_mode => p_datetrack_mode,
695: p_validation_start_date => p_validation_start_date,
696: p_validation_end_date => p_validation_end_date);
697: --
698: hr_utility.set_location(' Leaving:'||l_proc, 10);
699: End update_validate;
700: --
701: -- ----------------------------------------------------------------------------
702: -- |---------------------------< delete_validate >----------------------------|

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

710: --
711: l_proc varchar2(72) := g_package||'delete_validate';
712: --
713: Begin
714: hr_utility.set_location('Entering:'||l_proc, 5);
715: --
716: -- Call all supporting business operations
717: --
718: dt_delete_validate

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

720: p_validation_start_date => p_validation_start_date,
721: p_validation_end_date => p_validation_end_date,
722: p_elig_cbr_quald_bnf_id => p_rec.elig_cbr_quald_bnf_id);
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 10);
725: End delete_validate;
726: --
727: --
728: -- ---------------------------------------------------------------------------

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

747: l_proc varchar2(72) := g_package||'return_legislation_code';
748: --
749: begin
750: --
751: hr_utility.set_location('Entering:'|| l_proc, 10);
752: --
753: -- Ensure that all the mandatory parameter are not null
754: --
755: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

772: end if;
773: --
774: close csr_leg_code;
775: --
776: hr_utility.set_location(' Leaving:'|| l_proc, 20);
777: --
778: return l_legislation_code;
779: --
780: end return_legislation_code;