42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_eop_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ELIG_ANTHR_PL_PRTE_id => p_ELIG_ANTHR_PL_PRTE_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_ELIG_ANTHR_PL_PRTE_id;
78: --
79: --
121: between pln.effective_start_date and pln.effective_end_date;
122: --
123: Begin
124: --
125: hr_utility.set_location('Entering:'||l_proc,5);
126: --
127: l_api_updating := ben_eop_shd.api_updating
128: (p_ELIG_ANTHR_PL_PRTE_id => p_ELIG_ANTHR_PL_PRTE_id,
129: p_effective_date => p_effective_date,
155: close c1;
156: --
157: end if;
158: --
159: hr_utility.set_location('Leaving:'||l_proc,10);
160: --
161: End chk_pl_id;
162: --
163: -- ----------------------------------------------------------------------------
195: l_api_updating boolean;
196: --
197: Begin
198: --
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: --
201: l_api_updating := ben_eop_shd.api_updating
202: (p_ELIG_ANTHR_PL_PRTE_id => p_ELIG_ANTHR_PL_PRTE_id,
203: p_effective_date => p_effective_date,
224: end if;
225: --
226: end if;
227: --
228: hr_utility.set_location('Leaving:'||l_proc,10);
229: --
230: end chk_excld_flag;
231: --
232: -- ----------------------------------------------------------------------------
272: and eop.ELIG_ANTHR_PL_PRTE_id <> nvl(p_ELIG_ANTHR_PL_PRTE_id, hr_api.g_number) ;
273: --
274: Begin
275: --
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: --
278: l_api_updating := ben_eop_shd.api_updating
279: (p_ELIG_ANTHR_PL_PRTE_id => p_ELIG_ANTHR_PL_PRTE_id,
280: p_effective_date => p_effective_date,
286: fetch c_ELIG_ANTHR_PL_PRTE into l_dummy;
287: if c_ELIG_ANTHR_PL_PRTE%found then
288: --
289: close c_ELIG_ANTHR_PL_PRTE;
290: hr_utility.set_location(l_proc, 7);
291: --
292: -- raise error as duplicate criteria has been entered
293: --
294: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
297: end if;
298: --
299: close c_ELIG_ANTHR_PL_PRTE;
300: --
301: hr_utility.set_location('Leaving:'||l_proc,10);
302: --
303: end chk_dup_elig_criteria;
304: --
305: -- ---------------------------------------------------------------------------
345: and ordr_num = p_ordr_num
346: and business_group_id = p_business_group_id;
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: open c1;
352: fetch c1 into l_dummy;
353: if c1%found then
356: fnd_message.raise_error;
357: end if;
358: close c1;
359: --
360: hr_utility.set_location('Leaving:'||l_proc, 15);
361: End chk_duplicate_ordr_num;
362: --
363: -- ----------------------------------------------------------------------------
364: -- |--------------------------< dt_update_validate >--------------------------|
401: l_integrity_error Exception;
402: l_table_name all_tables.table_name%TYPE;
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: -- Ensure that the p_datetrack_mode argument is not null
408: --
409: hr_api.mandatory_arg_error
440: End If;
441: --
442: End If;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 10);
445: Exception
446: When l_integrity_error Then
447: --
448: -- A referential integrity check was violated therefore
505: l_rows_exist Exception;
506: l_table_name all_tables.table_name%TYPE;
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Ensure that the p_datetrack_mode argument is not null
512: --
513: hr_api.mandatory_arg_error
542: --
543: --
544: End If;
545: --
546: hr_utility.set_location(' Leaving:'||l_proc, 10);
547: Exception
548: When l_rows_exist Then
549: --
550: -- 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: chk_ELIG_ANTHR_PL_PRTE_id
611: p_object_version_number => p_rec.object_version_number);
612: --
613: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
614: --
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: End insert_validate;
617: --
618: -- ----------------------------------------------------------------------------
619: -- |---------------------------< update_validate >----------------------------|
627: --
628: l_proc varchar2(72) := g_package||'update_validate';
629: --
630: Begin
631: hr_utility.set_location('Entering:'||l_proc, 5);
632: --
633: -- Call all supporting business operations
634: --
635: chk_ELIG_ANTHR_PL_PRTE_id
674: p_datetrack_mode => p_datetrack_mode,
675: p_validation_start_date => p_validation_start_date,
676: p_validation_end_date => p_validation_end_date);
677: --
678: hr_utility.set_location(' Leaving:'||l_proc, 10);
679: End update_validate;
680: --
681: -- ----------------------------------------------------------------------------
682: -- |---------------------------< delete_validate >----------------------------|
690: --
691: l_proc varchar2(72) := g_package||'delete_validate';
692: --
693: Begin
694: hr_utility.set_location('Entering:'||l_proc, 5);
695: --
696: -- Call all supporting business operations
697: --
698: dt_delete_validate
700: p_validation_start_date => p_validation_start_date,
701: p_validation_end_date => p_validation_end_date,
702: p_ELIG_ANTHR_PL_PRTE_id => p_rec.ELIG_ANTHR_PL_PRTE_id);
703: --
704: hr_utility.set_location(' Leaving:'||l_proc, 10);
705: End delete_validate;
706: --
707: --
708: -- ---------------------------------------------------------------------------
727: l_proc varchar2(72) := g_package||'return_legislation_code';
728: --
729: begin
730: --
731: hr_utility.set_location('Entering:'|| l_proc, 10);
732: --
733: -- Ensure that all the mandatory parameter are not null
734: --
735: hr_api.mandatory_arg_error(p_api_name => l_proc,
752: end if;
753: --
754: close csr_leg_code;
755: --
756: hr_utility.set_location(' Leaving:'|| l_proc, 20);
757: --
758: return l_legislation_code;
759: --
760: end return_legislation_code;