DBA Data[Home] [Help]

APPS.BEN_DCR_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_dcr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_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_dpnt_cvg_rqd_rlshp_id;
78: --
79: -- ----------------------------------------------------------------------------

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

112: l_dummy varchar2(1);
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := ben_dcr_shd.api_updating
119: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
120: p_effective_date => p_effective_date,

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

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

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

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

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

227: close c1;
228: --
229: end if;
230: --
231: hr_utility.set_location('Leaving:'||l_proc,10);
232: --
233: end chk_cvg_strt_dt_rl;
234: --
235: -- ----------------------------------------------------------------------------

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

267: l_api_updating boolean;
268: --
269: Begin
270: --
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: --
273: l_api_updating := ben_dcr_shd.api_updating
274: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
275: p_effective_date => p_effective_date,

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

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

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

346: and ff.effective_end_date;
347: --
348: Begin
349: --
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: l_api_updating := ben_dcr_shd.api_updating
353: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
354: p_effective_date => p_effective_date,

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

383: close c1;
384: --
385: end if;
386: --
387: hr_utility.set_location('Leaving:'||l_proc,10);
388: --
389: end chk_cvg_thru_dt_rl;
390: --
391: -- ----------------------------------------------------------------------------

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

423: l_api_updating boolean;
424: --
425: Begin
426: --
427: hr_utility.set_location('Entering:'||l_proc, 5);
428: --
429: l_api_updating := ben_dcr_shd.api_updating
430: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
431: p_effective_date => p_effective_date,

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

453: end if;
454: --
455: end if;
456: --
457: hr_utility.set_location('Leaving:'||l_proc,10);
458: --
459: end chk_cvg_strt_dt_cd;
460:
461: --

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

499: l_api_updating boolean;
500: --
501: Begin
502: --
503: hr_utility.set_location('Entering:'||l_proc, 5);
504: --
505: l_api_updating := ben_dcr_shd.api_updating
506: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
507: p_effective_date => p_effective_date,

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

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

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

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

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

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

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

657: l_api_updating boolean;
658: --
659: Begin
660: --
661: hr_utility.set_location('Entering:'||l_proc, 5);
662: --
663: l_api_updating := ben_dcr_shd.api_updating
664: (p_dpnt_cvg_rqd_rlshp_id => p_dpnt_cvg_rqd_rlshp_id,
665: p_effective_date => p_effective_date,

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

689:
690: --
691: -- Leaving Procedure.
692: --
693: hr_utility.set_location('Leaving:'||l_proc,10);
694: --
695: end chk_strt_thru_dt;
696:
697: --

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

742:
743: --
744: Begin
745: --
746: hr_utility.set_location('Entering:'||l_proc, 6);
747: --
748: open c1;
749: fetch c1 into dummy;
750: if c1%found then

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

753: fnd_message.raise_error;
754: end if;
755: close c1;
756: --
757: hr_utility.set_location('Leaving:'||l_proc, 10);
758: --
759: End chk_duplicate_rows;
760:
761:

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

798: l_integrity_error Exception;
799: l_table_name all_tables.table_name%TYPE;
800: --
801: Begin
802: hr_utility.set_location('Entering:'||l_proc, 5);
803: --
804: -- Ensure that the p_datetrack_mode argument is not null
805: --
806: hr_api.mandatory_arg_error

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

837: End If;
838: --
839: End If;
840: --
841: hr_utility.set_location(' Leaving:'||l_proc, 10);
842: Exception
843: When l_integrity_error Then
844: --
845: -- A referential integrity check was violated therefore

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

903: l_rows_exist Exception;
904: l_table_name all_tables.table_name%TYPE;
905: --
906: Begin
907: hr_utility.set_location('Entering:'||l_proc, 5);
908: --
909: -- Ensure that the p_datetrack_mode argument is not null
910: --
911: hr_api.mandatory_arg_error

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

940: --
941: --
942: End If;
943: --
944: hr_utility.set_location(' Leaving:'||l_proc, 10);
945: Exception
946: When l_rows_exist Then
947: --
948: -- A referential integrity check was violated therefore

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

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

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

1036: p_cvg_thru_dt_rl => p_rec.cvg_thru_dt_rl,
1037: p_effective_date => p_effective_date,
1038: p_object_version_number => p_rec.object_version_number);
1039: --
1040: hr_utility.set_location(' Leaving:'||l_proc, 10);
1041: End insert_validate;
1042: --
1043: -- ----------------------------------------------------------------------------
1044: -- |---------------------------< update_validate >----------------------------|

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

1052: --
1053: l_proc varchar2(72) := g_package||'update_validate';
1054: --
1055: Begin
1056: hr_utility.set_location('Entering:'||l_proc, 5);
1057: --
1058: -- Call all supporting business operations
1059: --
1060: --

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

1124: p_datetrack_mode => p_datetrack_mode,
1125: p_validation_start_date => p_validation_start_date,
1126: p_validation_end_date => p_validation_end_date);
1127: --
1128: hr_utility.set_location(' Leaving:'||l_proc, 10);
1129: End update_validate;
1130: --
1131: -- ----------------------------------------------------------------------------
1132: -- |---------------------------< delete_validate >----------------------------|

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

1140: --
1141: l_proc varchar2(72) := g_package||'delete_validate';
1142: --
1143: Begin
1144: hr_utility.set_location('Entering:'||l_proc, 5);
1145: --
1146: -- Call all supporting business operations
1147: --
1148: dt_delete_validate

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

1150: p_validation_start_date => p_validation_start_date,
1151: p_validation_end_date => p_validation_end_date,
1152: p_dpnt_cvg_rqd_rlshp_id => p_rec.dpnt_cvg_rqd_rlshp_id);
1153: --
1154: hr_utility.set_location(' Leaving:'||l_proc, 10);
1155: End delete_validate;
1156: --
1157: --
1158: -- ---------------------------------------------------------------------------

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

1177: l_proc varchar2(72) := g_package||'return_legislation_code';
1178: --
1179: begin
1180: --
1181: hr_utility.set_location('Entering:'|| l_proc, 10);
1182: --
1183: -- Ensure that all the mandatory parameter are not null
1184: --
1185: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1202: end if;
1203: --
1204: close csr_leg_code;
1205: --
1206: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1207: --
1208: return l_legislation_code;
1209: --
1210: end return_legislation_code;