DBA Data[Home] [Help]

APPS.BEN_PEI_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_pei_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pl_extract_identifier_id => p_pl_extract_identifier_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_pl_extract_identifier_id;
78: --
79: -- ----------------------------------------------------------------------------

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

86: l_proc varchar2(72) := g_package||'chk_pl_plip_oipl_id';
87: --
88: Begin
89: --
90: hr_utility.set_location('Entering:'||l_proc, 5);
91: --
92: if p_pl_id is null then
93: --
94: fnd_message.set_name('BEN','BEN_93975_PL_OR_OIPL_NOT_BOTH');

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

102: fnd_message.raise_error;
103: --
104: end if;
105: --
106: hr_utility.set_location('Leaving:'||l_proc, 10);
107: --
108: End chk_pl_plip_oipl_id;
109: --
110: --

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

160: nvl(p_rec.home_zip, '~~NULL~~') = nvl(home_zip, '~~NULL~~');
161: --
162: Begin
163: --
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: --
167: open c1;
168: fetch c1 into l_dummy;

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

174: --
175: end if;
176: close c1;
177: --
178: hr_utility.set_location('Leaving:'||l_proc, 10);
179: --
180: End chk_uniq_ext_id_for_critera;
181: --
182: -- ----------------------------------------------------------------------------

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

215: l_dummy varchar2(30);
216: --
217: Begin
218: --
219: hr_utility.set_location('Entering:'||l_proc, 5);
220: --
221: l_api_updating := ben_pei_shd.api_updating
222: (p_pl_extract_identifier_id => p_pl_extract_identifier_id,
223: p_effective_date => p_effective_date,

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

247: end if;
248: --
249: end if;
250: --
251: hr_utility.set_location('Leaving:'||l_proc,10);
252: --
253: end chk_all_lookups;
254: --
255: -- ----------------------------------------------------------------------------

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

293: l_integrity_error Exception;
294: l_table_name all_tables.table_name%TYPE;
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: -- Ensure that the p_datetrack_mode argument is not null
300: --
301: hr_api.mandatory_arg_error

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

352: End If;
353: --
354: End If;
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 10);
357: Exception
358: When l_integrity_error Then
359: --
360: -- A referential integrity check was violated therefore

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

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

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

453: p_argument_value => p_pl_extract_identifier_id);
454: --
455: End If;
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 10);
458: Exception
459: When l_rows_exist Then
460: --
461: -- A referential integrity check was violated therefore

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

486: --
487: l_proc varchar2(72) := g_package||'insert_validate';
488: --
489: Begin
490: hr_utility.set_location('Entering:'||l_proc, 5);
491: --
492: -- Call all supporting business operations
493: --
494: if p_rec.business_group_id is not null then

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

514: p_home_state => p_rec.home_state,
515: p_effective_date => p_effective_date,
516: p_object_version_number => p_rec.object_version_number);
517: --
518: hr_utility.set_location(' Leaving:'||l_proc, 10);
519: --
520: End insert_validate;
521: --
522: -- ----------------------------------------------------------------------------

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

531: --
532: l_proc varchar2(72) := g_package||'update_validate';
533: --
534: Begin
535: hr_utility.set_location('Entering:'||l_proc, 5);
536: --
537: -- Call all supporting business operations
538: --
539: if p_rec.business_group_id is not null then

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

570: p_home_state => p_rec.home_state,
571: p_effective_date => p_effective_date,
572: p_object_version_number => p_rec.object_version_number);
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: --
576: End update_validate;
577: --
578: -- ----------------------------------------------------------------------------

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

587: --
588: l_proc varchar2(72) := g_package||'delete_validate';
589: --
590: Begin
591: hr_utility.set_location('Entering:'||l_proc, 5);
592: --
593: -- Call all supporting business operations
594: --
595: dt_delete_validate

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

597: p_validation_start_date => p_validation_start_date,
598: p_validation_end_date => p_validation_end_date,
599: p_pl_extract_identifier_id => p_rec.pl_extract_identifier_id);
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: End delete_validate;
603: --
604: -- ---------------------------------------------------------------------------
605: -- |---------------------< return_legislation_code >-------------------------|

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

624:
625: --
626: begin
627: --
628: hr_utility.set_location('Entering:'|| l_proc, 10);
629: --
630: -- Ensure that all the mandatory parameter are not null
631: --
632: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

649: end if;
650: --
651: close csr_leg_code;
652: --
653: hr_utility.set_location(' Leaving:'|| l_proc, 20);
654: --
655: return l_legislation_code;
656:
657: --