42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_clr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_comp_lvl_rt_id => p_comp_lvl_rt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_comp_lvl_rt_id;
78: --
79: -- |--------------------< chk_duplicate_ordr_num >----------------------------|
118: and business_group_id + 0 = p_business_group_id
119: and ordr_num = p_ordr_num;
120: --
121: Begin
122: hr_utility.set_location('Entering:'||l_proc, 5);
123:
124: --
125: open c1;
126: fetch c1 into l_dummy;
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);
135: End chk_duplicate_ordr_num;
136:
137: --
138: -- ----------------------------------------------------------------------------
170: l_api_updating boolean;
171: --
172: Begin
173: --
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --
176: l_api_updating := ben_clr_shd.api_updating
177: (p_comp_lvl_rt_id => p_comp_lvl_rt_id,
178: p_effective_date => p_effective_date,
192: p_effective_date => p_effective_date) then
193: --
194: -- raise error as does not exist as lookup
195: --
196: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
197: hr_utility.raise_error;
198: --
199: end if;
200: --
193: --
194: -- raise error as does not exist as lookup
195: --
196: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
197: hr_utility.raise_error;
198: --
199: end if;
200: --
201: end if;
199: end if;
200: --
201: end if;
202: --
203: hr_utility.set_location('Leaving:'||l_proc,10);
204: --
205: end chk_excld_flag;
206: --
207: -- ----------------------------------------------------------------------------
241: --
242:
243: Begin
244: --
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: if p_comp_lvl_fctr_id is not null then
248: open c1;
249: fetch c1 into l_dummy;
247: if p_comp_lvl_fctr_id is not null then
248: open c1;
249: fetch c1 into l_dummy;
250: if c1%notfound then
251: hr_utility.set_message(801,'Comp_Lvl_Fctr_NotExist');
252: hr_utility.raise_error;
253: end if;
254: close c1;
255: end if;
248: open c1;
249: fetch c1 into l_dummy;
250: if c1%notfound then
251: hr_utility.set_message(801,'Comp_Lvl_Fctr_NotExist');
252: hr_utility.raise_error;
253: end if;
254: close c1;
255: end if;
256: --
253: end if;
254: close c1;
255: end if;
256: --
257: hr_utility.set_location('Leaving:'||l_proc, 10);
258: --
259: End chk_comp_lvl_fctr_id;
260:
261: -- ----------------------------------------------------------------------------
314: and p_validation_end_date >= effective_start_date;
315: --
316: BEGIN
317: --
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: l_api_updating := ben_clr_shd.api_updating
321: (p_comp_lvl_rt_id => p_comp_lvl_rt_id,
322: p_effective_date => p_effective_date,
341: end if;
342: close c_dup;
343: --
344: end if;
345: hr_utility.set_location('Leaving:'||l_proc,10);
346: --
347: END chk_dup_record;
348:
349:
387: l_integrity_error Exception;
388: l_table_name all_tables.table_name%TYPE;
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: -- Ensure that the p_datetrack_mode argument is not null
394: --
395: hr_api.mandatory_arg_error
426: End If;
427: --
428: End If;
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 10);
431: Exception
432: When l_integrity_error Then
433: --
434: -- A referential integrity check was violated therefore
440: --
441: -- An unhandled or unexpected error has occurred which
442: -- we must report
443: --
444: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
445: hr_utility.set_message_token('PROCEDURE', l_proc);
446: hr_utility.set_message_token('STEP','15');
447: hr_utility.raise_error;
448: End dt_update_validate;
441: -- An unhandled or unexpected error has occurred which
442: -- we must report
443: --
444: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
445: hr_utility.set_message_token('PROCEDURE', l_proc);
446: hr_utility.set_message_token('STEP','15');
447: hr_utility.raise_error;
448: End dt_update_validate;
449: --
442: -- we must report
443: --
444: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
445: hr_utility.set_message_token('PROCEDURE', l_proc);
446: hr_utility.set_message_token('STEP','15');
447: hr_utility.raise_error;
448: End dt_update_validate;
449: --
450: -- ----------------------------------------------------------------------------
443: --
444: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
445: hr_utility.set_message_token('PROCEDURE', l_proc);
446: hr_utility.set_message_token('STEP','15');
447: hr_utility.raise_error;
448: End dt_update_validate;
449: --
450: -- ----------------------------------------------------------------------------
451: -- |--------------------------< dt_delete_validate >--------------------------|
492: l_rows_exist Exception;
493: l_table_name all_tables.table_name%TYPE;
494: --
495: Begin
496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: -- Ensure that the p_datetrack_mode argument is not null
499: --
500: hr_api.mandatory_arg_error
529: --
530: --
531: End If;
532: --
533: hr_utility.set_location(' Leaving:'||l_proc, 10);
534: Exception
535: When l_rows_exist Then
536: --
537: -- A referential integrity check was violated therefore
543: --
544: -- An unhandled or unexpected error has occurred which
545: -- we must report
546: --
547: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
548: hr_utility.set_message_token('PROCEDURE', l_proc);
549: hr_utility.set_message_token('STEP','15');
550: hr_utility.raise_error;
551: End dt_delete_validate;
544: -- An unhandled or unexpected error has occurred which
545: -- we must report
546: --
547: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
548: hr_utility.set_message_token('PROCEDURE', l_proc);
549: hr_utility.set_message_token('STEP','15');
550: hr_utility.raise_error;
551: End dt_delete_validate;
552: --
545: -- we must report
546: --
547: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
548: hr_utility.set_message_token('PROCEDURE', l_proc);
549: hr_utility.set_message_token('STEP','15');
550: hr_utility.raise_error;
551: End dt_delete_validate;
552: --
553: -- ----------------------------------------------------------------------------
546: --
547: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
548: hr_utility.set_message_token('PROCEDURE', l_proc);
549: hr_utility.set_message_token('STEP','15');
550: hr_utility.raise_error;
551: End dt_delete_validate;
552: --
553: -- ----------------------------------------------------------------------------
554: -- |---------------------------< insert_validate >----------------------------|
562: --
563: l_proc varchar2(72) := g_package||'insert_validate';
564: --
565: Begin
566: hr_utility.set_location('Entering:'||l_proc, 5);
567: --
568: -- Call all supporting business operations
569: --
570: --
600: ,p_effective_date => p_effective_date
601: ,p_business_group_id => p_rec.business_group_id
602: ,p_comp_lvl_rt_id => p_rec.comp_lvl_rt_id);
603: --
604: hr_utility.set_location(' Leaving:'||l_proc, 10);
605: End insert_validate;
606: --
607: -- ----------------------------------------------------------------------------
608: -- |---------------------------< update_validate >----------------------------|
616: --
617: l_proc varchar2(72) := g_package||'update_validate';
618: --
619: Begin
620: hr_utility.set_location('Entering:'||l_proc, 5);
621: --
622: -- Call all supporting business operations
623: --
624: --
662: ,p_effective_date => p_effective_date
663: ,p_business_group_id => p_rec.business_group_id
664: ,p_comp_lvl_rt_id => p_rec.comp_lvl_rt_id);
665: --
666: hr_utility.set_location(' Leaving:'||l_proc, 10);
667: End update_validate;
668: --
669: -- ----------------------------------------------------------------------------
670: -- |---------------------------< delete_validate >----------------------------|
678: --
679: l_proc varchar2(72) := g_package||'delete_validate';
680: --
681: Begin
682: hr_utility.set_location('Entering:'||l_proc, 5);
683: --
684: -- Call all supporting business operations
685: --
686: dt_delete_validate
688: p_validation_start_date => p_validation_start_date,
689: p_validation_end_date => p_validation_end_date,
690: p_comp_lvl_rt_id => p_rec.comp_lvl_rt_id);
691: --
692: hr_utility.set_location(' Leaving:'||l_proc, 10);
693: End delete_validate;
694: --
695: --
696: -- ---------------------------------------------------------------------------
715: l_proc varchar2(72) := g_package||'return_legislation_code';
716: --
717: begin
718: --
719: hr_utility.set_location('Entering:'|| l_proc, 10);
720: --
721: -- Ensure that all the mandatory parameter are not null
722: --
723: hr_api.mandatory_arg_error(p_api_name => l_proc,
733: close csr_leg_code;
734: --
735: -- The primary key is invalid therefore we must error
736: --
737: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
738: hr_utility.raise_error;
739: --
740: end if;
741: --
734: --
735: -- The primary key is invalid therefore we must error
736: --
737: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
738: hr_utility.raise_error;
739: --
740: end if;
741: --
742: close csr_leg_code;
740: end if;
741: --
742: close csr_leg_code;
743: --
744: hr_utility.set_location(' Leaving:'|| l_proc, 20);
745: --
746: return l_legislation_code;
747: --
748: end return_legislation_code;