[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_ava_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_actl_prem_vrbl_rt_rl_id => p_actl_prem_vrbl_rt_rl_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_rl_id;
78: --
79: -- ----------------------------------------------------------------------------
111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_ava_shd.api_updating
118: (p_actl_prem_vrbl_rt_rl_id => p_actl_prem_vrbl_rt_rl_id,
119: p_effective_date => p_effective_date,
140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_rt_trtmt_cd;
147: --
148: -- ----------------------------------------------------------------------------
197: and ff.effective_end_date;
198: --
199: Begin
200: --
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: l_api_updating := ben_ava_shd.api_updating
204: (p_actl_prem_vrbl_rt_rl_id => p_actl_prem_vrbl_rt_rl_id,
205: p_effective_date => p_effective_date,
234: close c1;
235: --
236: end if;
237: --
238: hr_utility.set_location('Leaving:'||l_proc,10);
239: --
240: end chk_formula_id;
241: --
242: -- ----------------------------------------------------------------------------
288: and a.effective_end_date;
289: --
290: Begin
291: --
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: l_api_updating := ben_ava_shd.api_updating
295: (p_effective_date => p_effective_date,
296: p_actl_prem_vrbl_rt_rl_id => p_actl_prem_vrbl_rt_rl_id,
318: close c1;
319: --
320: end if;
321: --
322: hr_utility.set_location('Leaving:'||l_proc, 10);
323: --
324: End chk_vrr_vrp_mutexcl;
325: --
326: -- ---------------------------------------------------------------------------
365: and ordr_to_aply_num = p_ordr_to_aply_num
366: and business_group_id = p_business_group_id;
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: open c1;
372: fetch c1 into l_dummy;
373: if c1%found then
375: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
376: fnd_message.raise_error;
377: end if;
378: --
379: hr_utility.set_location('Leaving:'||l_proc, 15);
380: End chk_ordr_to_aply_num_unique;
381: --
382: -- ----------------------------------------------------------------------------
383: -- |--------------------------< dt_update_validate >--------------------------|
418: l_integrity_error Exception;
419: l_table_name all_tables.table_name%TYPE;
420: --
421: Begin
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: -- Ensure that the p_datetrack_mode argument is not null
425: --
426: hr_api.mandatory_arg_error
457: End If;
458: --
459: End If;
460: --
461: hr_utility.set_location(' Leaving:'||l_proc, 10);
462: Exception
463: When l_integrity_error Then
464: --
465: -- A referential integrity check was violated therefore
522: l_rows_exist Exception;
523: l_table_name all_tables.table_name%TYPE;
524: --
525: Begin
526: hr_utility.set_location('Entering:'||l_proc, 5);
527: --
528: -- Ensure that the p_datetrack_mode argument is not null
529: --
530: hr_api.mandatory_arg_error
559: --
560: --
561: End If;
562: --
563: hr_utility.set_location(' Leaving:'||l_proc, 10);
564: Exception
565: When l_rows_exist Then
566: --
567: -- A referential integrity check was violated therefore
591: --
592: l_proc varchar2(72) := g_package||'insert_validate';
593: --
594: Begin
595: hr_utility.set_location('Entering:'||l_proc, 5);
596: --
597: -- Call all supporting business operations
598: --
599: --
629: p_actl_prem_id => p_rec.actl_prem_id,
630: p_ordr_to_aply_num => p_rec.ordr_to_aply_num,
631: p_business_group_id => p_rec.business_group_id);
632: --
633: hr_utility.set_location(' Leaving:'||l_proc, 10);
634: End insert_validate;
635: --
636: -- ----------------------------------------------------------------------------
637: -- |---------------------------< update_validate >----------------------------|
645: --
646: l_proc varchar2(72) := g_package||'update_validate';
647: --
648: Begin
649: hr_utility.set_location('Entering:'||l_proc, 5);
650: --
651: -- Call all supporting business operations
652: --
653: --
691: p_datetrack_mode => p_datetrack_mode,
692: p_validation_start_date => p_validation_start_date,
693: p_validation_end_date => p_validation_end_date);
694: --
695: hr_utility.set_location(' Leaving:'||l_proc, 10);
696: End update_validate;
697: --
698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< delete_validate >----------------------------|
707: --
708: l_proc varchar2(72) := g_package||'delete_validate';
709: --
710: Begin
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: -- Call all supporting business operations
714: --
715: dt_delete_validate
717: p_validation_start_date => p_validation_start_date,
718: p_validation_end_date => p_validation_end_date,
719: p_actl_prem_vrbl_rt_rl_id => p_rec.actl_prem_vrbl_rt_rl_id);
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 10);
722: End delete_validate;
723: --
724: --
725: -- ---------------------------------------------------------------------------
744: l_proc varchar2(72) := g_package||'return_legislation_code';
745: --
746: begin
747: --
748: hr_utility.set_location('Entering:'|| l_proc, 10);
749: --
750: -- Ensure that all the mandatory parameter are not null
751: --
752: hr_api.mandatory_arg_error(p_api_name => l_proc,
769: end if;
770: --
771: close csr_leg_code;
772: --
773: hr_utility.set_location(' Leaving:'|| l_proc, 20);
774: --
775: return l_legislation_code;
776: --
777: end return_legislation_code;