DBA Data[Home] [Help]

APPS.BEN_EDC_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_edc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_dsbld_stat_cvg_id => p_elig_dsbld_stat_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_dsbld_stat_cvg_id;
78: --
79: -- ----------------------------------------------------------------------------

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_edc_shd.api_updating
118: (p_elig_dsbld_stat_cvg_id => p_elig_dsbld_stat_cvg_id,
119: p_effective_date => p_effective_date,

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

140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_dsbld_cd;
147: --
148: -- ----------------------------------------------------------------------------

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

189: and ff.effective_end_date;
190: --
191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: l_api_updating := ben_edc_shd.api_updating
196: (p_elig_dsbld_stat_cvg_id => p_elig_dsbld_stat_cvg_id,
197: p_effective_date => p_effective_date,

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_cvg_thru_rl;
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_edc_shd.api_updating
272: (p_elig_dsbld_stat_cvg_id => p_elig_dsbld_stat_cvg_id,
273: p_effective_date => p_effective_date,

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

294: end if;
295: --
296: end if;
297: --
298: hr_utility.set_location('Leaving:'||l_proc,10);
299: --
300: end chk_cvg_thru_cd;
301: --
302: -- ----------------------------------------------------------------------------

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

343: and ff.effective_end_date;
344: --
345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: l_api_updating := ben_edc_shd.api_updating
350: (p_elig_dsbld_stat_cvg_id => p_elig_dsbld_stat_cvg_id,
351: p_effective_date => p_effective_date,

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

379: close c1;
380: --
381: end if;
382: --
383: hr_utility.set_location('Leaving:'||l_proc,10);
384: --
385: end chk_cvg_strt_rl;
386: --
387: -- ----------------------------------------------------------------------------

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

419: l_api_updating boolean;
420: --
421: Begin
422: --
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: l_api_updating := ben_edc_shd.api_updating
426: (p_elig_dsbld_stat_cvg_id => p_elig_dsbld_stat_cvg_id,
427: p_effective_date => p_effective_date,

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

448: end if;
449: --
450: end if;
451: --
452: hr_utility.set_location('Leaving:'||l_proc,10);
453: --
454: end chk_cvg_strt_cd;
455:
456: --

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

494: l_api_updating boolean;
495: --
496: Begin
497: --
498: hr_utility.set_location('Entering:'||l_proc, 5);
499: --
500: l_api_updating := ben_edc_shd.api_updating
501: (p_elig_dsbld_stat_cvg_id => p_elig_dsbld_stat_cvg_id,
502: p_effective_date => p_effective_date,

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

527:
528: --
529: -- Leaving Procedure.
530: --
531: hr_utility.set_location('Leaving:'||l_proc,10);
532: --
533: end chk_cvg_strt_dt_dependency;
534:
535: --

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

573: l_api_updating boolean;
574: --
575: Begin
576: --
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: l_api_updating := ben_edc_shd.api_updating
580: (p_elig_dsbld_stat_cvg_id => p_elig_dsbld_stat_cvg_id,
581: p_effective_date => p_effective_date,

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

606:
607: --
608: -- Leaving Procedure.
609: --
610: hr_utility.set_location('Leaving:'|| l_proc, 10);
611: --
612: end chk_cvg_thru_dt_dependency;
613: --
614: --

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

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

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

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

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

714: l_integrity_error Exception;
715: l_table_name all_tables.table_name%TYPE;
716: --
717: Begin
718: hr_utility.set_location('Entering:'||l_proc, 5);
719: --
720: -- Ensure that the p_datetrack_mode argument is not null
721: --
722: hr_api.mandatory_arg_error

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

753: End If;
754: --
755: End If;
756: --
757: hr_utility.set_location(' Leaving:'||l_proc, 10);
758: Exception
759: When l_integrity_error Then
760: --
761: -- A referential integrity check was violated therefore

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

819: l_rows_exist Exception;
820: l_table_name all_tables.table_name%TYPE;
821: --
822: Begin
823: hr_utility.set_location('Entering:'||l_proc, 5);
824: --
825: -- Ensure that the p_datetrack_mode argument is not null
826: --
827: hr_api.mandatory_arg_error

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

856: --
857: --
858: End If;
859: --
860: hr_utility.set_location(' Leaving:'||l_proc, 10);
861: Exception
862: When l_rows_exist Then
863: --
864: -- A referential integrity check was violated therefore

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

889: --
890: l_proc varchar2(72) := g_package||'insert_validate';
891: --
892: Begin
893: hr_utility.set_location('Entering:'||l_proc, 5);
894: --
895: -- Call all supporting business operations
896: --
897: --

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

953: p_cvg_thru_rl => p_rec.cvg_thru_rl,
954: p_effective_date => p_effective_date,
955: p_object_version_number => p_rec.object_version_number);
956: --
957: hr_utility.set_location(' Leaving:'||l_proc, 10);
958: End insert_validate;
959: --
960: -- ----------------------------------------------------------------------------
961: -- |---------------------------< update_validate >----------------------------|

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

969: --
970: l_proc varchar2(72) := g_package||'update_validate';
971: --
972: Begin
973: hr_utility.set_location('Entering:'||l_proc, 5);
974: --
975: -- Call all supporting business operations
976: --
977: --

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

1040: p_datetrack_mode => p_datetrack_mode,
1041: p_validation_start_date => p_validation_start_date,
1042: p_validation_end_date => p_validation_end_date);
1043: --
1044: hr_utility.set_location(' Leaving:'||l_proc, 10);
1045: End update_validate;
1046: --
1047: -- ----------------------------------------------------------------------------
1048: -- |---------------------------< delete_validate >----------------------------|

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

1056: --
1057: l_proc varchar2(72) := g_package||'delete_validate';
1058: --
1059: Begin
1060: hr_utility.set_location('Entering:'||l_proc, 5);
1061: --
1062: -- Call all supporting business operations
1063: --
1064: dt_delete_validate

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

1066: p_validation_start_date => p_validation_start_date,
1067: p_validation_end_date => p_validation_end_date,
1068: p_elig_dsbld_stat_cvg_id => p_rec.elig_dsbld_stat_cvg_id);
1069: --
1070: hr_utility.set_location(' Leaving:'||l_proc, 10);
1071: End delete_validate;
1072: --
1073: --
1074: -- ---------------------------------------------------------------------------

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

1093: l_proc varchar2(72) := g_package||'return_legislation_code';
1094: --
1095: begin
1096: --
1097: hr_utility.set_location('Entering:'|| l_proc, 10);
1098: --
1099: -- Ensure that all the mandatory parameter are not null
1100: --
1101: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1118: end if;
1119: --
1120: close csr_leg_code;
1121: --
1122: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1123: --
1124: return l_legislation_code;
1125: --
1126: end return_legislation_code;