DBA Data[Home] [Help]

APPS.BEN_EAC_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_eac_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_age_cvg_id => p_elig_age_cvg_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_age_cvg_id;
78: --
79: -- ----------------------------------------------------------------------------

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

117: where a.age_fctr_id = p_age_fctr_id;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_eac_shd.api_updating
124: (p_elig_age_cvg_id => p_elig_age_cvg_id,
125: p_effective_date => p_effective_date,

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

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

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

199: and ff.effective_end_date;
200: --
201: Begin
202: --
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: l_api_updating := ben_eac_shd.api_updating
206: (p_elig_age_cvg_id => p_elig_age_cvg_id,
207: p_effective_date => p_effective_date,

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

235: close c1;
236: --
237: end if;
238: --
239: hr_utility.set_location('Leaving:'||l_proc,10);
240: --
241: end chk_cvg_thru_rl;
242: --
243: -- ----------------------------------------------------------------------------

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

275: l_api_updating boolean;
276: --
277: Begin
278: --
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: l_api_updating := ben_eac_shd.api_updating
282: (p_elig_age_cvg_id => p_elig_age_cvg_id,
283: p_effective_date => p_effective_date,

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

304: end if;
305: --
306: end if;
307: --
308: hr_utility.set_location('Leaving:'||l_proc,10);
309: --
310: end chk_cvg_thru_cd;
311: --
312: -- ----------------------------------------------------------------------------

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

353: and ff.effective_end_date;
354: --
355: Begin
356: --
357: hr_utility.set_location('Entering:'||l_proc, 5);
358: --
359: l_api_updating := ben_eac_shd.api_updating
360: (p_elig_age_cvg_id => p_elig_age_cvg_id,
361: p_effective_date => p_effective_date,

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

389: close c1;
390: --
391: end if;
392: --
393: hr_utility.set_location('Leaving:'||l_proc,10);
394: --
395: end chk_cvg_strt_rl;
396: --
397: -- ----------------------------------------------------------------------------

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

429: l_api_updating boolean;
430: --
431: Begin
432: --
433: hr_utility.set_location('Entering:'||l_proc, 5);
434: --
435: l_api_updating := ben_eac_shd.api_updating
436: (p_elig_age_cvg_id => p_elig_age_cvg_id,
437: p_effective_date => p_effective_date,

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

458: end if;
459: --
460: end if;
461: --
462: hr_utility.set_location('Leaving:'||l_proc,10);
463: --
464: end chk_cvg_strt_cd;
465: --
466: -- ----------------------------------------------------------------------------

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

503: l_api_updating boolean;
504: --
505: Begin
506: --
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --
509: l_api_updating := ben_eac_shd.api_updating
510: (p_elig_age_cvg_id => p_elig_age_cvg_id,
511: p_effective_date => p_effective_date,

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

534:
535: --
536: -- Leaving Procedure.
537: --
538: hr_utility.set_location('Leaving:'||l_proc,10);
539: --
540: end chk_cvg_strt_dt_dependency;
541: --
542: -- ----------------------------------------------------------------------------

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

579: l_api_updating boolean;
580: --
581: Begin
582: --
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: l_api_updating := ben_eac_shd.api_updating
586: (p_elig_age_cvg_id => p_elig_age_cvg_id,
587: p_effective_date => p_effective_date,

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

610: end if;
611: --
612: -- Leaving Procedure.
613: --
614: hr_utility.set_location('Leaving:'|| l_proc, 10);
615: --
616: end chk_cvg_thru_dt_dependency;
617: --
618: -- ----------------------------------------------------------------------------

Line 666: hr_utility.set_location('Entering:'||l_proc, 6);

662:
663: --
664: Begin
665: --
666: hr_utility.set_location('Entering:'||l_proc, 6);
667: --
668: open c1;
669: fetch c1 into dummy;
670: if c1%found then

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

673: fnd_message.raise_error;
674: end if;
675: close c1;
676: --
677: hr_utility.set_location('Leaving:'||l_proc, 10);
678: --
679: End chk_duplicate_rows;
680:
681:

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

720: l_integrity_error Exception;
721: l_table_name all_tables.table_name%TYPE;
722: --
723: Begin
724: hr_utility.set_location('Entering:'||l_proc, 5);
725: --
726: -- Ensure that the p_datetrack_mode argument is not null
727: --
728: hr_api.mandatory_arg_error

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

759: End If;
760: --
761: End If;
762: --
763: hr_utility.set_location(' Leaving:'||l_proc, 10);
764: Exception
765: When l_integrity_error Then
766: --
767: -- A referential integrity check was violated therefore

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

825: l_rows_exist Exception;
826: l_table_name all_tables.table_name%TYPE;
827: --
828: Begin
829: hr_utility.set_location('Entering:'||l_proc, 5);
830: --
831: -- Ensure that the p_datetrack_mode argument is not null
832: --
833: hr_api.mandatory_arg_error

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

862: --
863: --
864: End If;
865: --
866: hr_utility.set_location(' Leaving:'||l_proc, 10);
867: Exception
868: When l_rows_exist Then
869: --
870: -- A referential integrity check was violated therefore

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

895: --
896: l_proc varchar2(72) := g_package||'insert_validate';
897: --
898: Begin
899: hr_utility.set_location('Entering:'||l_proc, 5);
900: --
901: -- Call all supporting business operations
902: --
903: --

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

959: p_cvg_thru_rl => p_rec.cvg_thru_rl,
960: p_effective_date => p_effective_date,
961: p_object_version_number => p_rec.object_version_number);
962:
963: hr_utility.set_location(' Leaving:'||l_proc, 10);
964: End insert_validate;
965: --
966: -- ----------------------------------------------------------------------------
967: -- |---------------------------< update_validate >----------------------------|

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

975: --
976: l_proc varchar2(72) := g_package||'update_validate';
977: --
978: Begin
979: hr_utility.set_location('Entering:'||l_proc, 5);
980: --
981: -- Call all supporting business operations
982: --
983: --

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

1046: p_datetrack_mode => p_datetrack_mode,
1047: p_validation_start_date => p_validation_start_date,
1048: p_validation_end_date => p_validation_end_date);
1049: --
1050: hr_utility.set_location(' Leaving:'||l_proc, 10);
1051: End update_validate;
1052: --
1053: -- ----------------------------------------------------------------------------
1054: -- |---------------------------< delete_validate >----------------------------|

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

1062: --
1063: l_proc varchar2(72) := g_package||'delete_validate';
1064: --
1065: Begin
1066: hr_utility.set_location('Entering:'||l_proc, 5);
1067: --
1068: -- Call all supporting business operations
1069: --
1070: dt_delete_validate

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

1072: p_validation_start_date => p_validation_start_date,
1073: p_validation_end_date => p_validation_end_date,
1074: p_elig_age_cvg_id => p_rec.elig_age_cvg_id);
1075: --
1076: hr_utility.set_location(' Leaving:'||l_proc, 10);
1077: End delete_validate;
1078: --
1079: --
1080: -- ---------------------------------------------------------------------------

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

1099: l_proc varchar2(72) := g_package||'return_legislation_code';
1100: --
1101: begin
1102: --
1103: hr_utility.set_location('Entering:'|| l_proc, 10);
1104: --
1105: -- Ensure that all the mandatory parameter are not null
1106: --
1107: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1124: end if;
1125: --
1126: close csr_leg_code;
1127: --
1128: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1129: --
1130: return l_legislation_code;
1131: --
1132: end return_legislation_code;