[Home] [Help]
43: l_api_updating boolean;
44: --
45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_eqt_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_elig_qual_titl_prte_id => p_elig_qual_titl_prte_id,
72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_elig_qual_titl_prte_id;
79: --
80: -- ----------------------------------------------------------------------------
112: l_api_updating boolean;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_eqt_shd.api_updating
119: (p_elig_qual_titl_prte_id => p_elig_qual_titl_prte_id,
120: p_effective_date => p_effective_date,
144: end if;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: end chk_excld_flag;
151: --
152: -- ----------------------------------------------------------------------------
190: where typ.qualification_type_id = p_qualification_type_id;
191: --
192: Begin
193: --
194: hr_utility.set_location('Entering:'||l_proc,5);
195: --
196: l_api_updating := ben_eqt_shd.api_updating
197: (p_elig_qual_titl_prte_id => p_elig_qual_titl_prte_id,
198: p_effective_date => p_effective_date,
224: close c1;
225: --
226: end if;
227: --
228: hr_utility.set_location('Leaving:'||l_proc,10);
229: --
230: End chk_qualification_type_id;
231: --
232: -- ----------------------------------------------------------------------------
283:
284: --
285: Begin
286: --
287: hr_utility.set_location('Entering:'||l_proc,5);
288: --
289: open c1;
290: --
291: fetch c1 into l_dummy;
300: --
301: end if;
302: close c1;
303: --
304: hr_utility.set_location('Leaving:'||l_proc,10);
305: --
306: End chk_dup_title_criteria;
307: --
308: -- ---------------------------------------------------------------------------
348: and ordr_num = p_ordr_num
349: and business_group_id = p_business_group_id;
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: --
354: open c1;
355: fetch c1 into l_dummy;
356: if c1%found then
359: fnd_message.raise_error;
360: end if;
361: close c1;
362: --
363: hr_utility.set_location('Leaving:'||l_proc, 15);
364: End chk_duplicate_ordr_num;
365: --
366: -- ----------------------------------------------------------------------------
367: -- |--------------------------< dt_update_validate >--------------------------|
402: l_integrity_error Exception;
403: l_table_name all_tables.table_name%TYPE;
404: --
405: Begin
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: -- Ensure that the p_datetrack_mode argument is not null
409: --
410: hr_api.mandatory_arg_error
441: End If;
442: --
443: End If;
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 10);
446: Exception
447: When l_integrity_error Then
448: --
449: -- A referential integrity check was violated therefore
507: l_rows_exist Exception;
508: l_table_name all_tables.table_name%TYPE;
509: --
510: Begin
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: --
513: -- Ensure that the p_datetrack_mode argument is not null
514: --
515: hr_api.mandatory_arg_error
544: --
545: --
546: End If;
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);
549: Exception
550: When l_rows_exist Then
551: --
552: -- A referential integrity check was violated therefore
578: --
579: l_proc varchar2(72) := g_package||'insert_validate';
580: --
581: Begin
582: hr_utility.set_location('Entering:'||l_proc, 5);
583: --
584: -- Call all supporting business operations
585: --
586: --
619: p_validation_end_date => p_validation_end_date,
620: p_business_group_id => p_rec.business_group_id);
621:
622: --
623: hr_utility.set_location(' Leaving:'||l_proc, 10);
624: End insert_validate;
625: --
626: -- ----------------------------------------------------------------------------
627: -- |---------------------------< update_validate >----------------------------|
635: --
636: l_proc varchar2(72) := g_package||'update_validate';
637: --
638: Begin
639: hr_utility.set_location('Entering:'||l_proc, 5);
640: --
641: -- Call all supporting business operations
642: --
643: --
683: p_datetrack_mode => p_datetrack_mode,
684: p_validation_start_date => p_validation_start_date,
685: p_validation_end_date => p_validation_end_date);
686: --
687: hr_utility.set_location(' Leaving:'||l_proc, 10);
688: End update_validate;
689: --
690: -- ----------------------------------------------------------------------------
691: -- |---------------------------< delete_validate >----------------------------|
699: --
700: l_proc varchar2(72) := g_package||'delete_validate';
701: --
702: Begin
703: hr_utility.set_location('Entering:'||l_proc, 5);
704: --
705: -- Call all supporting business operations
706: --
707: dt_delete_validate
709: p_validation_start_date => p_validation_start_date,
710: p_validation_end_date => p_validation_end_date,
711: p_elig_qual_titl_prte_id => p_rec.elig_qual_titl_prte_id);
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 10);
714: End delete_validate;
715: --
716: --
717: -- ---------------------------------------------------------------------------
736: l_proc varchar2(72) := g_package||'return_legislation_code';
737: --
738: begin
739: --
740: hr_utility.set_location('Entering:'|| l_proc, 10);
741: --
742: -- Ensure that all the mandatory parameter are not null
743: --
744: hr_api.mandatory_arg_error(p_api_name => l_proc,
761: end if;
762: --
763: close csr_leg_code;
764: --
765: hr_utility.set_location(' Leaving:'|| l_proc, 20);
766: --
767: return l_legislation_code;
768: --
769: end return_legislation_code;