[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_qtr_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_qual_titl_rt_id => p_qual_titl_rt_id,
72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_qual_titl_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_qtr_shd.api_updating
119: (p_qual_titl_rt_id => p_qual_titl_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: -- ----------------------------------------------------------------------------
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_qtr_shd.api_updating
197: (p_qual_titl_rt_id => p_qual_titl_rt_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;
302: --
303: end if;
304: close c1;
305: --
306: hr_utility.set_location('Leaving:'||l_proc,10);
307: --
308: End chk_dup_title_criteria;
309: --
310: -- added for Bug 5078478 .. add this procedure to check the duplicate seq no
358: and business_group_id + 0 = p_business_group_id
359: and ordr_num = p_ordr_num;
360: --
361: Begin
362: hr_utility.set_location('Entering:'||l_proc, 5);
363:
364: --
365: open c1;
366: fetch c1 into l_dummy;
370: fnd_message.raise_error;
371: end if;
372: close c1;
373: --
374: hr_utility.set_location('Leaving:'||l_proc, 15);
375: End chk_duplicate_ordr_num;
376: --
377: -- ----------------------------------------------------------------------------
378: -- |--------------------------< dt_update_validate >--------------------------|
413: l_integrity_error Exception;
414: l_table_name all_tables.table_name%TYPE;
415: --
416: Begin
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: -- Ensure that the p_datetrack_mode argument is not null
420: --
421: hr_api.mandatory_arg_error
452: End If;
453: --
454: End If;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: Exception
458: When l_integrity_error Then
459: --
460: -- A referential integrity check was violated therefore
518: l_rows_exist Exception;
519: l_table_name all_tables.table_name%TYPE;
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: -- Ensure that the p_datetrack_mode argument is not null
525: --
526: hr_api.mandatory_arg_error
555: --
556: --
557: End If;
558: --
559: hr_utility.set_location(' Leaving:'||l_proc, 10);
560: Exception
561: When l_rows_exist Then
562: --
563: -- A referential integrity check was violated therefore
589: --
590: l_proc varchar2(72) := g_package||'insert_validate';
591: --
592: Begin
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: --
595: -- Call all supporting business operations
596: --
597: --
633: ,p_validation_end_date => p_validation_end_date
634: ,p_business_group_id => p_rec.business_group_id);
635:
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 10);
638: End insert_validate;
639: --
640: -- ----------------------------------------------------------------------------
641: -- |---------------------------< update_validate >----------------------------|
649: --
650: l_proc varchar2(72) := g_package||'update_validate';
651: --
652: Begin
653: hr_utility.set_location('Entering:'||l_proc, 5);
654: --
655: -- Call all supporting business operations
656: --
657: --
700: ,p_validation_start_date => p_validation_start_date
701: ,p_validation_end_date => p_validation_end_date
702: ,p_business_group_id => p_rec.business_group_id);
703:
704: hr_utility.set_location(' Leaving:'||l_proc, 10);
705: End update_validate;
706: --
707: -- ----------------------------------------------------------------------------
708: -- |---------------------------< delete_validate >----------------------------|
716: --
717: l_proc varchar2(72) := g_package||'delete_validate';
718: --
719: Begin
720: hr_utility.set_location('Entering:'||l_proc, 5);
721: --
722: -- Call all supporting business operations
723: --
724: dt_delete_validate
726: p_validation_start_date => p_validation_start_date,
727: p_validation_end_date => p_validation_end_date,
728: p_qual_titl_rt_id => p_rec.qual_titl_rt_id);
729: --
730: hr_utility.set_location(' Leaving:'||l_proc, 10);
731: End delete_validate;
732: --
733: --
734: -- ---------------------------------------------------------------------------
753: l_proc varchar2(72) := g_package||'return_legislation_code';
754: --
755: begin
756: --
757: hr_utility.set_location('Entering:'|| l_proc, 10);
758: --
759: -- Ensure that all the mandatory parameter are not null
760: --
761: hr_api.mandatory_arg_error(p_api_name => l_proc,
778: end if;
779: --
780: close csr_leg_code;
781: --
782: hr_utility.set_location(' Leaving:'|| l_proc, 20);
783: --
784: return l_legislation_code;
785: --
786: end return_legislation_code;