42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_lre_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ler_rqrs_enrt_ctfn_id => p_ler_rqrs_enrt_ctfn_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_ler_rqrs_enrt_ctfn_id;
78: --
79: -- ----------------------------------------------------------------------------
112: l_api_updating boolean;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_lre_shd.api_updating
119: (p_ler_rqrs_enrt_ctfn_id => p_ler_rqrs_enrt_ctfn_id,
120: p_effective_date => p_effective_date,
144: end if;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: end chk_ctfn_rqd_when_rl;
151: --
152: -- ----------------------------------------------------------------------------
184: l_api_updating boolean;
185: --
186: Begin
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: l_api_updating := ben_lre_shd.api_updating
191: (p_ler_rqrs_enrt_ctfn_id => p_ler_rqrs_enrt_ctfn_id,
192: p_effective_date => p_effective_date,
215: end if;
216: --
217: end if;
218: --
219: hr_utility.set_location('Leaving:'||l_proc,10);
220: --
221: end chk_excld_flag;
222: --
223: -- ----------------------------------------------------------------------------
261: l_integrity_error Exception;
262: l_table_name all_tables.table_name%TYPE;
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: -- Ensure that the p_datetrack_mode argument is not null
268: --
269: hr_api.mandatory_arg_error
320: End If;
321: --
322: End If;
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: Exception
326: When l_integrity_error Then
327: --
328: -- A referential integrity check was violated therefore
387: l_rows_exist Exception;
388: l_table_name all_tables.table_name%TYPE;
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: -- Ensure that the p_datetrack_mode argument is not null
394: --
395: hr_api.mandatory_arg_error
432: End If;
433: --
434: End If;
435: --
436: hr_utility.set_location(' Leaving:'||l_proc, 10);
437: Exception
438: When l_rows_exist Then
439: --
440: -- A referential integrity check was violated therefore
466: --
467: l_proc varchar2(72) := g_package||'insert_validate';
468: --
469: Begin
470: hr_utility.set_location('Entering:'||l_proc, 5);
471: --
472: -- Call all supporting business operations
473: --
474: --
491: p_excld_flag => p_rec.excld_flag,
492: p_effective_date => p_effective_date,
493: p_object_version_number => p_rec.object_version_number);
494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 10);
496: End insert_validate;
497: --
498: -- ----------------------------------------------------------------------------
499: -- |---------------------------< update_validate >----------------------------|
507: --
508: l_proc varchar2(72) := g_package||'update_validate';
509: --
510: Begin
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: --
513: -- Call all supporting business operations
514: --
515: --
542: p_datetrack_mode => p_datetrack_mode,
543: p_validation_start_date => p_validation_start_date,
544: p_validation_end_date => p_validation_end_date);
545: --
546: hr_utility.set_location(' Leaving:'||l_proc, 10);
547: End update_validate;
548: --
549: -- ----------------------------------------------------------------------------
550: -- |---------------------------< delete_validate >----------------------------|
558: --
559: l_proc varchar2(72) := g_package||'delete_validate';
560: --
561: Begin
562: hr_utility.set_location('Entering:'||l_proc, 5);
563: --
564: -- Call all supporting business operations
565: --
566: dt_delete_validate
568: p_validation_start_date => p_validation_start_date,
569: p_validation_end_date => p_validation_end_date,
570: p_ler_rqrs_enrt_ctfn_id => p_rec.ler_rqrs_enrt_ctfn_id);
571: --
572: hr_utility.set_location(' Leaving:'||l_proc, 10);
573: End delete_validate;
574: --
575: --
576: -- ---------------------------------------------------------------------------
595: l_proc varchar2(72) := g_package||'return_legislation_code';
596: --
597: begin
598: --
599: hr_utility.set_location('Entering:'|| l_proc, 10);
600: --
601: -- Ensure that all the mandatory parameter are not null
602: --
603: hr_api.mandatory_arg_error(p_api_name => l_proc,
620: end if;
621: --
622: close csr_leg_code;
623: --
624: hr_utility.set_location(' Leaving:'|| l_proc, 20);
625: --
626: return l_legislation_code;
627: --
628: end return_legislation_code;