43: l_api_updating boolean;
44: --
45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_prr_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_perf_rtng_rt_id => p_perf_rtng_rt_id,
72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_perf_rtng_rt_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_prr_shd.api_updating
119: (p_perf_rtng_rt_id => p_perf_rtng_rt_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: -- ----------------------------------------------------------------------------
195: and h1.enabled_flag = 'Y';
196: --
197: Begin
198: --
199: hr_utility.set_location('Entering:'||l_proc,5);
200: --
201: l_api_updating := ben_prr_shd.api_updating
202: (p_perf_rtng_rt_id => p_perf_rtng_rt_id,
203: p_effective_date => p_effective_date,
231: close c1;
232: --
233: end if;
234: --
235: hr_utility.set_location('Leaving:'||l_proc,10);
236: --
237: End chk_event_type;
238: --
239:
284: and h1.enabled_flag = 'Y';
285: --
286: Begin
287: --
288: hr_utility.set_location('Entering:'||l_proc,5);
289: --
290: l_api_updating := ben_prr_shd.api_updating
291: (p_perf_rtng_rt_id => p_perf_rtng_rt_id,
292: p_effective_date => p_effective_date,
318: close c1;
319: --
320: end if;
321: --
322: hr_utility.set_location('Leaving:'||l_proc,10);
323: --
324: End chk_perf_rtng_cd;
325: --
326:
378:
379: --
380: Begin
381: --
382: hr_utility.set_location('Entering:'||l_proc,5);
383: --
384: open c1;
385: --
386: fetch c1 into l_dummy;
397: --
398: end if;
399: close c1;
400: --
401: hr_utility.set_location('Leaving:'||l_proc,10);
402: --
403: End chk_dup_perf_rtng_cd_criteria;
404: --
405: -- added for Bug 5078478 .. add this procedure to check the duplicate seq no
453: and business_group_id + 0 = p_business_group_id
454: and ordr_num = p_ordr_num;
455: --
456: Begin
457: hr_utility.set_location('Entering:'||l_proc, 5);
458:
459: --
460: open c1;
461: fetch c1 into l_dummy;
465: fnd_message.raise_error;
466: end if;
467: close c1;
468: --
469: hr_utility.set_location('Leaving:'||l_proc, 15);
470: End chk_duplicate_ordr_num;
471:
472:
473:
512: l_integrity_error Exception;
513: l_table_name all_tables.table_name%TYPE;
514: --
515: Begin
516: hr_utility.set_location('Entering:'||l_proc, 5);
517: --
518: -- Ensure that the p_datetrack_mode argument is not null
519: --
520: hr_api.mandatory_arg_error
551: End If;
552: --
553: End If;
554: --
555: hr_utility.set_location(' Leaving:'||l_proc, 10);
556: Exception
557: When l_integrity_error Then
558: --
559: -- A referential integrity check was violated therefore
617: l_rows_exist Exception;
618: l_table_name all_tables.table_name%TYPE;
619: --
620: Begin
621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623: -- Ensure that the p_datetrack_mode argument is not null
624: --
625: hr_api.mandatory_arg_error
654: --
655: --
656: End If;
657: --
658: hr_utility.set_location(' Leaving:'||l_proc, 10);
659: Exception
660: When l_rows_exist Then
661: --
662: -- A referential integrity check was violated therefore
688: --
689: l_proc varchar2(72) := g_package||'insert_validate';
690: --
691: Begin
692: hr_utility.set_location('Entering:'||l_proc, 5);
693: --
694: -- Call all supporting business operations
695: --
696: --
739: ,p_validation_end_date => p_validation_end_date
740: ,p_business_group_id => p_rec.business_group_id);
741:
742: --
743: hr_utility.set_location(' Leaving:'||l_proc, 10);
744: End insert_validate;
745: --
746: -- ----------------------------------------------------------------------------
747: -- |---------------------------< update_validate >----------------------------|
755: --
756: l_proc varchar2(72) := g_package||'update_validate';
757: --
758: Begin
759: hr_utility.set_location('Entering:'||l_proc, 5);
760: --
761: -- Call all supporting business operations
762: --
763: --
814: p_datetrack_mode => p_datetrack_mode,
815: p_validation_start_date => p_validation_start_date,
816: p_validation_end_date => p_validation_end_date);
817: --
818: hr_utility.set_location(' Leaving:'||l_proc, 10);
819: End update_validate;
820: --
821: -- ----------------------------------------------------------------------------
822: -- |---------------------------< delete_validate >----------------------------|
830: --
831: l_proc varchar2(72) := g_package||'delete_validate';
832: --
833: Begin
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: -- Call all supporting business operations
837: --
838: dt_delete_validate
840: p_validation_start_date => p_validation_start_date,
841: p_validation_end_date => p_validation_end_date,
842: p_perf_rtng_rt_id => p_rec.perf_rtng_rt_id);
843: --
844: hr_utility.set_location(' Leaving:'||l_proc, 10);
845: End delete_validate;
846: --
847: --
848: -- ---------------------------------------------------------------------------
867: l_proc varchar2(72) := g_package||'return_legislation_code';
868: --
869: begin
870: --
871: hr_utility.set_location('Entering:'|| l_proc, 10);
872: --
873: -- Ensure that all the mandatory parameter are not null
874: --
875: hr_api.mandatory_arg_error(p_api_name => l_proc,
892: end if;
893: --
894: close csr_leg_code;
895: --
896: hr_utility.set_location(' Leaving:'|| l_proc, 20);
897: --
898: return l_legislation_code;
899: --
900: end return_legislation_code;