[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_opr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_othr_ptip_rt_id => p_othr_ptip_rt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_othr_ptip_rt_id;
78: --
79: -- ----------------------------------------------------------------------------
136: and p_validation_end_date >= opr.effective_start_date;
137: --
138: Begin
139: --
140: hr_utility.set_location('Entering:'||l_proc,5);
141: --
142: l_api_updating := ben_opr_shd.api_updating
143: (p_othr_ptip_rt_id => p_othr_ptip_rt_id,
144: p_effective_date => p_effective_date,
183: end if;
184: close c3;
185: --
186: --
187: hr_utility.set_location('Leaving:'||l_proc,10);
188: --
189: End chk_ptip_id;
190: --
191: -- ----------------------------------------------------------------------------
223: l_api_updating boolean;
224: --
225: Begin
226: --
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: l_api_updating := ben_opr_shd.api_updating
230: (p_othr_ptip_rt_id => p_othr_ptip_rt_id,
231: p_effective_date => p_effective_date,
254: end if;
255: --
256: end if;
257: --
258: hr_utility.set_location('Leaving:'||l_proc,10);
259: --
260: end chk_only_pls_subj_cobra_flag;
261: --
262: -- ----------------------------------------------------------------------------
294: l_api_updating boolean;
295: --
296: Begin
297: --
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: l_api_updating := ben_opr_shd.api_updating
301: (p_othr_ptip_rt_id => p_othr_ptip_rt_id,
302: p_effective_date => p_effective_date,
325: end if;
326: --
327: end if;
328: --
329: hr_utility.set_location('Leaving:'||l_proc,10);
330: --
331: end chk_excld_flag;
332: --
333: --
382: and business_group_id + 0 = p_business_group_id
383: and ordr_num = p_ordr_num;
384: --
385: Begin
386: hr_utility.set_location('Entering:'||l_proc, 5);
387:
388: --
389: open c1;
390: fetch c1 into l_dummy;
394: fnd_message.raise_error;
395: end if;
396: close c1;
397: --
398: hr_utility.set_location('Leaving:'||l_proc, 15);
399: End chk_duplicate_ordr_num;
400:
401:
402:
440: l_integrity_error Exception;
441: l_table_name all_tables.table_name%TYPE;
442: --
443: Begin
444: hr_utility.set_location('Entering:'||l_proc, 5);
445: --
446: -- Ensure that the p_datetrack_mode argument is not null
447: --
448: hr_api.mandatory_arg_error
489: End If;
490: --
491: End If;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: Exception
495: When l_integrity_error Then
496: --
497: -- A referential integrity check was violated therefore
554: l_rows_exist Exception;
555: l_table_name all_tables.table_name%TYPE;
556: --
557: Begin
558: hr_utility.set_location('Entering:'||l_proc, 5);
559: --
560: -- Ensure that the p_datetrack_mode argument is not null
561: --
562: hr_api.mandatory_arg_error
591: --
592: --
593: End If;
594: --
595: hr_utility.set_location(' Leaving:'||l_proc, 10);
596: Exception
597: When l_rows_exist Then
598: --
599: -- A referential integrity check was violated therefore
625: --
626: l_proc varchar2(72) := g_package||'insert_validate';
627: --
628: Begin
629: hr_utility.set_location('Entering:'||l_proc, 5);
630: --
631: -- Call all supporting business operations
632: --
633: --
669: ,p_validation_end_date => p_validation_end_date
670: ,p_business_group_id => p_rec.business_group_id);
671:
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
674: End insert_validate;
675: --
676: -- ----------------------------------------------------------------------------
677: -- |---------------------------< update_validate >----------------------------|
685: --
686: l_proc varchar2(72) := g_package||'update_validate';
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: -- Call all supporting business operations
692: --
693: --
738: p_datetrack_mode => p_datetrack_mode,
739: p_validation_start_date => p_validation_start_date,
740: p_validation_end_date => p_validation_end_date);
741: --
742: hr_utility.set_location(' Leaving:'||l_proc, 10);
743: End update_validate;
744: --
745: -- ----------------------------------------------------------------------------
746: -- |---------------------------< delete_validate >----------------------------|
754: --
755: l_proc varchar2(72) := g_package||'delete_validate';
756: --
757: Begin
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: -- Call all supporting business operations
761: --
762: dt_delete_validate
764: p_validation_start_date => p_validation_start_date,
765: p_validation_end_date => p_validation_end_date,
766: p_othr_ptip_rt_id => p_rec.othr_ptip_rt_id);
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 10);
769: End delete_validate;
770: --
771: --
772: -- ---------------------------------------------------------------------------
791: l_proc varchar2(72) := g_package||'return_legislation_code';
792: --
793: begin
794: --
795: hr_utility.set_location('Entering:'|| l_proc, 10);
796: --
797: -- Ensure that all the mandatory parameter are not null
798: --
799: hr_api.mandatory_arg_error(p_api_name => l_proc,
816: end if;
817: --
818: close csr_leg_code;
819: --
820: hr_utility.set_location(' Leaving:'|| l_proc, 20);
821: --
822: return l_legislation_code;
823: --
824: end return_legislation_code;