[Home] [Help]
42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_apv_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_actl_prem_vrbl_rt_id => p_actl_prem_vrbl_rt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_actl_prem_vrbl_rt_id;
78: -- ----------------------------------------------------------------------------
79: -- |------------------------< chk_vrr_vrp_mutexcl >--------------------------|
124: and a.effective_end_date;
125: --
126: Begin
127: --
128: hr_utility.set_location('Entering:'||l_proc, 5);
129: --
130: l_api_updating := ben_apv_shd.api_updating
131: (p_effective_date => p_effective_date,
132: p_actl_prem_vrbl_rt_id => p_actl_prem_vrbl_rt_id,
154: close c1;
155: --
156: end if;
157: --
158: hr_utility.set_location('Leaving:'||l_proc, 10);
159: --
160: End chk_vrr_vrp_mutexcl;
161: --
162: -- ---------------------------------------------------------------------------
201: and ordr_num = p_ordr_num
202: and business_group_id = p_business_group_id;
203: --
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: open c1;
208: fetch c1 into l_dummy;
209: if c1%found then
211: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
212: fnd_message.raise_error;
213: end if;
214: --
215: hr_utility.set_location('Leaving:'||l_proc, 15);
216: End chk_ordr_num_unique;
217: --
218: -- ----------------------------------------------------------------------------
219: -- |--------------------------< dt_update_validate >--------------------------|
255: l_integrity_error Exception;
256: l_table_name all_tables.table_name%TYPE;
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: -- Ensure that the p_datetrack_mode argument is not null
262: --
263: hr_api.mandatory_arg_error
304: End If;
305: --
306: End If;
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 10);
309: Exception
310: When l_integrity_error Then
311: --
312: -- A referential integrity check was violated therefore
369: l_rows_exist Exception;
370: l_table_name all_tables.table_name%TYPE;
371: --
372: Begin
373: hr_utility.set_location('Entering:'||l_proc, 5);
374: --
375: -- Ensure that the p_datetrack_mode argument is not null
376: --
377: hr_api.mandatory_arg_error
406: --
407: --
408: End If;
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 10);
411: Exception
412: When l_rows_exist Then
413: --
414: -- A referential integrity check was violated therefore
438: --
439: l_proc varchar2(72) := g_package||'insert_validate';
440: --
441: Begin
442: hr_utility.set_location('Entering:'||l_proc, 5);
443: --
444: -- Call all supporting business operations
445: --
446: --
463: p_actl_prem_id => p_rec.actl_prem_id,
464: p_ordr_num => p_rec.ordr_num,
465: p_business_group_id => p_rec.business_group_id);
466: --
467: hr_utility.set_location(' Leaving:'||l_proc, 10);
468: End insert_validate;
469: --
470: -- ----------------------------------------------------------------------------
471: -- |---------------------------< update_validate >----------------------------|
479: --
480: l_proc varchar2(72) := g_package||'update_validate';
481: --
482: Begin
483: hr_utility.set_location('Entering:'||l_proc, 5);
484: --
485: -- Call all supporting business operations
486: --
487: --
513: p_datetrack_mode => p_datetrack_mode,
514: p_validation_start_date => p_validation_start_date,
515: p_validation_end_date => p_validation_end_date);
516: --
517: hr_utility.set_location(' Leaving:'||l_proc, 10);
518: End update_validate;
519: --
520: -- ----------------------------------------------------------------------------
521: -- |---------------------------< delete_validate >----------------------------|
529: --
530: l_proc varchar2(72) := g_package||'delete_validate';
531: --
532: Begin
533: hr_utility.set_location('Entering:'||l_proc, 5);
534: --
535: -- Call all supporting business operations
536: --
537: dt_delete_validate
539: p_validation_start_date => p_validation_start_date,
540: p_validation_end_date => p_validation_end_date,
541: p_actl_prem_vrbl_rt_id => p_rec.actl_prem_vrbl_rt_id);
542: --
543: hr_utility.set_location(' Leaving:'||l_proc, 10);
544: End delete_validate;
545: --
546: --
547: -- ---------------------------------------------------------------------------
566: l_proc varchar2(72) := g_package||'return_legislation_code';
567: --
568: begin
569: --
570: hr_utility.set_location('Entering:'|| l_proc, 10);
571: --
572: -- Ensure that all the mandatory parameter are not null
573: --
574: hr_api.mandatory_arg_error(p_api_name => l_proc,
591: end if;
592: --
593: close csr_leg_code;
594: --
595: hr_utility.set_location(' Leaving:'|| l_proc, 20);
596: --
597: return l_legislation_code;
598: --
599: end return_legislation_code;