[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_ecl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_comp_lvl_prte_id => p_elig_comp_lvl_prte_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_comp_lvl_prte_id;
78: --
79: -- ----------------------------------------------------------------------------
134: where a.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
135: --
136: Begin
137: --
138: hr_utility.set_location('Entering:'||l_proc,5);
139: --
140: l_api_updating := ben_ecl_shd.api_updating
141: (p_elig_comp_lvl_prte_id => p_elig_comp_lvl_prte_id,
142: p_effective_date => p_effective_date,
180: --
181: --
182: end if;
183: --
184: hr_utility.set_location('Leaving:'||l_proc,10);
185: --
186: End chk_comp_lvl_fctr_id;
187: --
188: --
236: and b.excld_flag = 'N';
237: --
238: Begin
239: --
240: hr_utility.set_location('Entering:'||l_proc,5);
241: --
242: open c1;
243: --
244: fetch c1 into l_dummy;
258: --
259: close c1;
260: --
261: --
262: hr_utility.set_location('Leaving:'||l_proc,10);
263: --
264: End chk_valid_fctr;
265: --
266: --
302: and b.excld_flag = 'N';
303: --
304: Begin
305: --
306: hr_utility.set_location('Entering:'||l_proc,5);
307: --
308: open c1;
309: --
310: fetch c1 into l_dummy;
324: --
325: close c1;
326: --
327: --
328: hr_utility.set_location('Leaving:'||l_proc,10);
329: --
330: End chk_valid_fctr_for_stat;
331: --
332: --
365: l_api_updating boolean;
366: --
367: Begin
368: --
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: l_api_updating := ben_ecl_shd.api_updating
372: (p_elig_comp_lvl_prte_id => p_elig_comp_lvl_prte_id,
373: p_effective_date => p_effective_date,
394: end if;
395: --
396: end if;
397: --
398: hr_utility.set_location('Leaving:'||l_proc,10);
399: --
400: end chk_excld_flag;
401: --
402: --Bug:5054189
443: and ordr_num = p_ordr_num
444: and business_group_id = p_business_group_id;
445: --
446: Begin
447: hr_utility.set_location('Entering:'||l_proc, 5);
448: --
449: open c1;
450: fetch c1 into l_dummy;
451: if c1%found then
454: fnd_message.raise_error;
455: end if;
456: close c1;
457: --
458: hr_utility.set_location('Leaving:'||l_proc, 15);
459: End chk_duplicate_ordr_num;
460: -- ----------------------------------------------------------------------------
461: -- |--------------------------< dt_update_validate >--------------------------|
462: -- ----------------------------------------------------------------------------
496: l_integrity_error Exception;
497: l_table_name all_tables.table_name%TYPE;
498: --
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: -- Ensure that the p_datetrack_mode argument is not null
503: --
504: hr_api.mandatory_arg_error
535: End If;
536: --
537: End If;
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 10);
540: Exception
541: When l_integrity_error Then
542: --
543: -- A referential integrity check was violated therefore
601: l_rows_exist Exception;
602: l_table_name all_tables.table_name%TYPE;
603: --
604: Begin
605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607: -- Ensure that the p_datetrack_mode argument is not null
608: --
609: hr_api.mandatory_arg_error
638: --
639: --
640: End If;
641: --
642: hr_utility.set_location(' Leaving:'||l_proc, 10);
643: Exception
644: When l_rows_exist Then
645: --
646: -- A referential integrity check was violated therefore
671: --
672: l_proc varchar2(72) := g_package||'insert_validate';
673: --
674: Begin
675: hr_utility.set_location('Entering:'||l_proc, 5);
676: --
677: -- Call all supporting business operations
678: --
679: --
709: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
710: ,p_ordr_num => p_rec.ordr_num
711: ,p_business_group_id => p_rec.business_group_id);
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 10);
714: End insert_validate;
715: --
716: -- ----------------------------------------------------------------------------
717: -- |---------------------------< update_validate >----------------------------|
725: --
726: l_proc varchar2(72) := g_package||'update_validate';
727: --
728: Begin
729: hr_utility.set_location('Entering:'||l_proc, 5);
730: --
731: -- Call all supporting business operations
732: --
733: --
767: p_datetrack_mode => p_datetrack_mode,
768: p_validation_start_date => p_validation_start_date,
769: p_validation_end_date => p_validation_end_date);
770: --
771: hr_utility.set_location(' Leaving:'||l_proc, 10);
772: End update_validate;
773: --
774: -- ----------------------------------------------------------------------------
775: -- |---------------------------< delete_validate >----------------------------|
783: --
784: l_proc varchar2(72) := g_package||'delete_validate';
785: --
786: Begin
787: hr_utility.set_location('Entering:'||l_proc, 5);
788: --
789: -- Call all supporting business operations
790: --
791: dt_delete_validate
793: p_validation_start_date => p_validation_start_date,
794: p_validation_end_date => p_validation_end_date,
795: p_elig_comp_lvl_prte_id => p_rec.elig_comp_lvl_prte_id);
796: --
797: hr_utility.set_location(' Leaving:'||l_proc, 10);
798: End delete_validate;
799: --
800: --
801: -- ---------------------------------------------------------------------------
820: l_proc varchar2(72) := g_package||'return_legislation_code';
821: --
822: begin
823: --
824: hr_utility.set_location('Entering:'|| l_proc, 10);
825: --
826: -- Ensure that all the mandatory parameter are not null
827: --
828: hr_api.mandatory_arg_error(p_api_name => l_proc,
845: end if;
846: --
847: close csr_leg_code;
848: --
849: hr_utility.set_location(' Leaving:'|| l_proc, 20);
850: --
851: return l_legislation_code;
852: --
853: end return_legislation_code;