[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_ehw_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_hrs_wkd_prte_id => p_elig_hrs_wkd_prte_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_hrs_wkd_prte_id;
78: --
79: -- ----------------------------------------------------------------------------
133: and p_validation_end_date >= effective_start_date
134: ;
135: Begin
136: --
137: hr_utility.set_location('Entering:'||l_proc,5);
138: --
139: l_api_updating := ben_ehw_shd.api_updating
140: (p_elig_hrs_wkd_prte_id => p_elig_hrs_wkd_prte_id,
141: p_effective_date => p_effective_date,
179: close c3;
180: --
181: end if;
182: --
183: hr_utility.set_location('Leaving:'||l_proc,10);
184: --
185: End chk_hrs_wkd_in_perd_fctr_id;
186: --
187: -- ----------------------------------------------------------------------------
219: l_api_updating boolean;
220: --
221: Begin
222: --
223: hr_utility.set_location('Entering:'||l_proc, 5);
224: --
225: l_api_updating := ben_ehw_shd.api_updating
226: (p_elig_hrs_wkd_prte_id => p_elig_hrs_wkd_prte_id,
227: p_effective_date => p_effective_date,
248: end if;
249: --
250: end if;
251: --
252: hr_utility.set_location('Leaving:'||l_proc,10);
253: --
254: end chk_excld_flag;
255: --
256: --Bug:5054189
297: and ordr_num = p_ordr_num
298: and business_group_id = p_business_group_id;
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: open c1;
304: fetch c1 into l_dummy;
305: if c1%found then
308: fnd_message.raise_error;
309: end if;
310: close c1;
311: --
312: hr_utility.set_location('Leaving:'||l_proc, 15);
313: End chk_duplicate_ordr_num;
314: -- ----------------------------------------------------------------------------
315: -- |--------------------------< dt_update_validate >--------------------------|
316: -- ----------------------------------------------------------------------------
350: l_integrity_error Exception;
351: l_table_name all_tables.table_name%TYPE;
352: --
353: Begin
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: -- Ensure that the p_datetrack_mode argument is not null
357: --
358: hr_api.mandatory_arg_error
389: End If;
390: --
391: End If;
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: Exception
395: When l_integrity_error Then
396: --
397: -- A referential integrity check was violated therefore
456: l_rows_exist Exception;
457: l_table_name all_tables.table_name%TYPE;
458: --
459: Begin
460: hr_utility.set_location('Entering:'||l_proc, 5);
461: --
462: -- Ensure that the p_datetrack_mode argument is not null
463: --
464: hr_api.mandatory_arg_error
493: --
494: --
495: End If;
496: --
497: hr_utility.set_location(' Leaving:'||l_proc, 10);
498: Exception
499: When l_rows_exist Then
500: --
501: -- A referential integrity check was violated therefore
527: --
528: l_proc varchar2(72) := g_package||'insert_validate';
529: --
530: Begin
531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: -- Call all supporting business operations
534: --
535: --
561: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
562: ,p_ordr_num => p_rec.ordr_num
563: ,p_business_group_id => p_rec.business_group_id);
564: --
565: hr_utility.set_location(' Leaving:'||l_proc, 10);
566: End insert_validate;
567: --
568: -- ----------------------------------------------------------------------------
569: -- |---------------------------< update_validate >----------------------------|
577: --
578: l_proc varchar2(72) := g_package||'update_validate';
579: --
580: Begin
581: hr_utility.set_location('Entering:'||l_proc, 5);
582: --
583: -- Call all supporting business operations
584: --
585: --
619: p_datetrack_mode => p_datetrack_mode,
620: p_validation_start_date => p_validation_start_date,
621: p_validation_end_date => p_validation_end_date);
622: --
623: hr_utility.set_location(' Leaving:'||l_proc, 10);
624: End update_validate;
625: --
626: -- ----------------------------------------------------------------------------
627: -- |---------------------------< delete_validate >----------------------------|
635: --
636: l_proc varchar2(72) := g_package||'delete_validate';
637: --
638: Begin
639: hr_utility.set_location('Entering:'||l_proc, 5);
640: --
641: -- Call all supporting business operations
642: --
643: dt_delete_validate
645: p_validation_start_date => p_validation_start_date,
646: p_validation_end_date => p_validation_end_date,
647: p_elig_hrs_wkd_prte_id => p_rec.elig_hrs_wkd_prte_id);
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 10);
650: End delete_validate;
651: --
652: --
653: -- ---------------------------------------------------------------------------
672: l_proc varchar2(72) := g_package||'return_legislation_code';
673: --
674: begin
675: --
676: hr_utility.set_location('Entering:'|| l_proc, 10);
677: --
678: -- Ensure that all the mandatory parameter are not null
679: --
680: hr_api.mandatory_arg_error(p_api_name => l_proc,
697: end if;
698: --
699: close csr_leg_code;
700: --
701: hr_utility.set_location(' Leaving:'|| l_proc, 20);
702: --
703: return l_legislation_code;
704: --
705: end return_legislation_code;