42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_ebu_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_brgng_unit_prte_id => p_elig_brgng_unit_prte_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_brgng_unit_prte_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_ebu_shd.api_updating
118: (p_elig_brgng_unit_prte_id => p_elig_brgng_unit_prte_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_excld_flag;
147: --
148: -- ----------------------------------------------------------------------------
197: ;
198: --
199: Begin
200: --
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: l_api_updating := ben_ebu_shd.api_updating
204: (p_elig_brgng_unit_prte_id => p_elig_brgng_unit_prte_id,
205: p_effective_date => p_effective_date,
240: close c3;
241: --
242: end if;
243: --
244: hr_utility.set_location('Leaving:'||l_proc,10);
245: --
246: end chk_brgng_unit_cd;
247: --
248: --Bug:5054189
289: and ordr_num = p_ordr_num
290: and business_group_id = p_business_group_id;
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: open c1;
296: fetch c1 into l_dummy;
297: if c1%found then
300: fnd_message.raise_error;
301: end if;
302: close c1;
303: --
304: hr_utility.set_location('Leaving:'||l_proc, 15);
305: End chk_duplicate_ordr_num;
306: -- ----------------------------------------------------------------------------
307: -- |--------------------------< dt_update_validate >--------------------------|
308: -- ----------------------------------------------------------------------------
342: l_integrity_error Exception;
343: l_table_name all_tables.table_name%TYPE;
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Ensure that the p_datetrack_mode argument is not null
349: --
350: hr_api.mandatory_arg_error
381: End If;
382: --
383: End If;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);
386: Exception
387: When l_integrity_error Then
388: --
389: -- A referential integrity check was violated therefore
447: l_rows_exist Exception;
448: l_table_name all_tables.table_name%TYPE;
449: --
450: Begin
451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- Ensure that the p_datetrack_mode argument is not null
454: --
455: hr_api.mandatory_arg_error
484: --
485: --
486: End If;
487: --
488: hr_utility.set_location(' Leaving:'||l_proc, 10);
489: Exception
490: When l_rows_exist Then
491: --
492: -- A referential integrity check was violated therefore
517: --
518: l_proc varchar2(72) := g_package||'insert_validate';
519: --
520: Begin
521: hr_utility.set_location('Entering:'||l_proc, 5);
522: --
523: -- Call all supporting business operations
524: --
525: --
552: ,p_ordr_num => p_rec.ordr_num
553: ,p_business_group_id => p_rec.business_group_id);
554: --
555:
556: hr_utility.set_location(' Leaving:'||l_proc, 10);
557: End insert_validate;
558: --
559: -- ----------------------------------------------------------------------------
560: -- |---------------------------< update_validate >----------------------------|
568: --
569: l_proc varchar2(72) := g_package||'update_validate';
570: --
571: Begin
572: hr_utility.set_location('Entering:'||l_proc, 5);
573: --
574: -- Call all supporting business operations
575: --
576: --
610: p_datetrack_mode => p_datetrack_mode,
611: p_validation_start_date => p_validation_start_date,
612: p_validation_end_date => p_validation_end_date);
613: --
614: hr_utility.set_location(' Leaving:'||l_proc, 10);
615: End update_validate;
616: --
617: -- ----------------------------------------------------------------------------
618: -- |---------------------------< delete_validate >----------------------------|
626: --
627: l_proc varchar2(72) := g_package||'delete_validate';
628: --
629: Begin
630: hr_utility.set_location('Entering:'||l_proc, 5);
631: --
632: -- Call all supporting business operations
633: --
634: dt_delete_validate
636: p_validation_start_date => p_validation_start_date,
637: p_validation_end_date => p_validation_end_date,
638: p_elig_brgng_unit_prte_id => p_rec.elig_brgng_unit_prte_id);
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);
641: End delete_validate;
642: --
643: --
644: -- ---------------------------------------------------------------------------
663: l_proc varchar2(72) := g_package||'return_legislation_code';
664: --
665: begin
666: --
667: hr_utility.set_location('Entering:'|| l_proc, 10);
668: --
669: -- Ensure that all the mandatory parameter are not null
670: --
671: hr_api.mandatory_arg_error(p_api_name => l_proc,
688: end if;
689: --
690: close csr_leg_code;
691: --
692: hr_utility.set_location(' Leaving:'|| l_proc, 20);
693: --
694: return l_legislation_code;
695: --
696: end return_legislation_code;