42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_dpc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_dpnt_cvrd_anthr_pl_cvg_id => p_dpnt_cvrd_anthr_pl_cvg_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_dpnt_cvrd_anthr_pl_cvg_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_dpc_shd.api_updating
118: (p_dpnt_cvrd_anthr_pl_cvg_id => p_dpnt_cvrd_anthr_pl_cvg_id,
119: p_effective_date => p_effective_date,
142: end if;
143: --
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc,10);
147: --
148: end chk_excld_flag;
149: --
150: -- ----------------------------------------------------------------------------
182: l_api_updating boolean;
183: --
184: Begin
185: --
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: l_api_updating := ben_dpc_shd.api_updating
189: (p_dpnt_cvrd_anthr_pl_cvg_id => p_dpnt_cvrd_anthr_pl_cvg_id,
190: p_effective_date => p_effective_date,
213: end if;
214: --
215: end if;
216: --
217: hr_utility.set_location('Leaving:'||l_proc,10);
218: --
219: end chk_cvg_det_dt_cd;
220: --
221: --
266:
267: --
268: Begin
269: --
270: hr_utility.set_location('Entering:'||l_proc, 6);
271: --
272: open c1;
273: fetch c1 into dummy;
274: if c1%found then
277: fnd_message.raise_error;
278: end if;
279: close c1;
280: --
281: hr_utility.set_location('Leaving:'||l_proc, 10);
282: --
283: End chk_duplicate_rows;
284: ---
285: --
331: and business_group_id + 0 = p_business_group_id
332: and ordr_num = p_ordr_num;
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336:
337: --
338: open c1;
339: fetch c1 into l_dummy;
343: fnd_message.raise_error;
344: end if;
345: close c1;
346: --
347: hr_utility.set_location('Leaving:'||l_proc, 15);
348: End chk_duplicate_ordr_num;
349: --
350:
351: ---
389: l_integrity_error Exception;
390: l_table_name all_tables.table_name%TYPE;
391: --
392: Begin
393: hr_utility.set_location('Entering:'||l_proc, 5);
394: --
395: -- Ensure that the p_datetrack_mode argument is not null
396: --
397: hr_api.mandatory_arg_error
438: End If;
439: --
440: End If;
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 10);
443: Exception
444: When l_integrity_error Then
445: --
446: -- A referential integrity check was violated therefore
503: l_rows_exist Exception;
504: l_table_name all_tables.table_name%TYPE;
505: --
506: Begin
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --
509: -- Ensure that the p_datetrack_mode argument is not null
510: --
511: hr_api.mandatory_arg_error
540: --
541: --
542: End If;
543: --
544: hr_utility.set_location(' Leaving:'||l_proc, 10);
545: Exception
546: When l_rows_exist Then
547: --
548: -- A referential integrity check was violated therefore
574: --
575: l_proc varchar2(72) := g_package||'insert_validate';
576: --
577: Begin
578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: -- Call all supporting business operations
581: --
582: --
615: ,p_validation_end_date =>p_validation_end_date
616: ,p_business_group_id => p_rec.business_group_id);
617:
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 10);
620: End insert_validate;
621: --
622: -- ----------------------------------------------------------------------------
623: -- |---------------------------< update_validate >----------------------------|
631: --
632: l_proc varchar2(72) := g_package||'update_validate';
633: --
634: Begin
635: hr_utility.set_location('Entering:'||l_proc, 5);
636: --
637: -- Call all supporting business operations
638: --
639: --
681: p_datetrack_mode => p_datetrack_mode,
682: p_validation_start_date => p_validation_start_date,
683: p_validation_end_date => p_validation_end_date);
684: --
685: hr_utility.set_location(' Leaving:'||l_proc, 10);
686: End update_validate;
687: --
688: -- ----------------------------------------------------------------------------
689: -- |---------------------------< delete_validate >----------------------------|
697: --
698: l_proc varchar2(72) := g_package||'delete_validate';
699: --
700: Begin
701: hr_utility.set_location('Entering:'||l_proc, 5);
702: --
703: -- Call all supporting business operations
704: --
705: dt_delete_validate
707: p_validation_start_date => p_validation_start_date,
708: p_validation_end_date => p_validation_end_date,
709: p_dpnt_cvrd_anthr_pl_cvg_id => p_rec.dpnt_cvrd_anthr_pl_cvg_id);
710: --
711: hr_utility.set_location(' Leaving:'||l_proc, 10);
712: End delete_validate;
713: --
714: --
715: -- ---------------------------------------------------------------------------
734: l_proc varchar2(72) := g_package||'return_legislation_code';
735: --
736: begin
737: --
738: hr_utility.set_location('Entering:'|| l_proc, 10);
739: --
740: -- Ensure that all the mandatory parameter are not null
741: --
742: hr_api.mandatory_arg_error(p_api_name => l_proc,
759: end if;
760: --
761: close csr_leg_code;
762: --
763: hr_utility.set_location(' Leaving:'|| l_proc, 20);
764: --
765: return l_legislation_code;
766: --
767: end return_legislation_code;