DBA Data[Home] [Help]

APPS.BEN_ECY_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_ecy_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ELIG_COMPTNCY_PRTE_id => p_ELIG_COMPTNCY_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_COMPTNCY_PRTE_id;
78: --
79: --

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

120: and p_effective_date between nvl(date_from, p_effective_date) and nvl(date_to, p_effective_date);
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc,5);
125: --
126: hr_api.mandatory_arg_error(p_api_name => l_proc,
127: p_argument => 'competence_id',
128: p_argument_value => p_competence_id);

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

158: close c1;
159: --
160: end if;
161: --
162: hr_utility.set_location('Leaving:'||l_proc,10);
163: --
164: End chk_competence_id;
165: --
166: --

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

218: and rtl.rating_level_id = p_rating_level_id;
219: --
220: Begin
221: --
222: hr_utility.set_location('Entering:'||l_proc,5);
223: --
224: hr_api.mandatory_arg_error(p_api_name => l_proc,
225: p_argument => 'rating_level_id',
226: p_argument_value => p_rating_level_id);

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

256: close c1;
257: --
258: end if;
259: --
260: hr_utility.set_location('Leaving:'||l_proc,10);
261: --
262: End chk_rating_level_id;
263: --
264: -- ----------------------------------------------------------------------------

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

296: l_api_updating boolean;
297: --
298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: l_api_updating := ben_ecy_shd.api_updating
303: (p_ELIG_COMPTNCY_PRTE_id => p_ELIG_COMPTNCY_PRTE_id,
304: p_effective_date => p_effective_date,

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

325: end if;
326: --
327: end if;
328: --
329: hr_utility.set_location('Leaving:'||l_proc,10);
330: --
331: end chk_excld_flag;
332: --
333: -- ---------------------------------------------------------------------------

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

373: and ordr_num = p_ordr_num
374: and business_group_id = p_business_group_id;
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: open c1;
380: fetch c1 into l_dummy;
381: if c1%found then

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

384: fnd_message.raise_error;
385: end if;
386: close c1;
387: --
388: hr_utility.set_location('Leaving:'||l_proc, 15);
389: End chk_duplicate_ordr_num;
390: --
391: -- ----------------------------------------------------------------------------
392: -- |--------------------------< dt_update_validate >--------------------------|

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

428: l_integrity_error Exception;
429: l_table_name all_tables.table_name%TYPE;
430: --
431: Begin
432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: -- Ensure that the p_datetrack_mode argument is not null
435: --
436: hr_api.mandatory_arg_error

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

467: End If;
468: --
469: End If;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
472: Exception
473: When l_integrity_error Then
474: --
475: -- A referential integrity check was violated therefore

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

532: l_rows_exist Exception;
533: l_table_name all_tables.table_name%TYPE;
534: --
535: Begin
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: -- Ensure that the p_datetrack_mode argument is not null
539: --
540: hr_api.mandatory_arg_error

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

569: --
570: --
571: End If;
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 10);
574: Exception
575: When l_rows_exist Then
576: --
577: -- A referential integrity check was violated therefore

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

601: --
602: l_proc varchar2(72) := g_package||'insert_validate';
603: --
604: Begin
605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607: -- Call all supporting business operations
608: --
609: chk_ELIG_COMPTNCY_PRTE_id

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

639: p_business_group_id => p_rec.business_group_id);
640: --
641: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
642: --
643: hr_utility.set_location(' Leaving:'||l_proc, 10);
644: End insert_validate;
645: --
646: -- ----------------------------------------------------------------------------
647: -- |---------------------------< update_validate >----------------------------|

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

655: --
656: l_proc varchar2(72) := g_package||'update_validate';
657: --
658: Begin
659: hr_utility.set_location('Entering:'||l_proc, 5);
660: --
661: -- Call all supporting business operations
662: --
663: chk_ELIG_COMPTNCY_PRTE_id

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

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

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

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

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

728: p_validation_start_date => p_validation_start_date,
729: p_validation_end_date => p_validation_end_date,
730: p_ELIG_COMPTNCY_PRTE_id => p_rec.ELIG_COMPTNCY_PRTE_id);
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 10);
733: End delete_validate;
734: --
735: --
736: -- ---------------------------------------------------------------------------

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

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

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

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