42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_pst_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pstn_rt_id => p_pstn_rt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_pstn_rt_id;
78: --
79: --
120: and p_effective_date >= date_effective ;
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc,5);
125: --
126: l_api_updating := ben_pst_shd.api_updating
127: (p_pstn_rt_id => p_pstn_rt_id,
128: p_effective_date => p_effective_date,
154: close c1;
155: --
156: end if;
157: --
158: hr_utility.set_location('Leaving:'||l_proc,10);
159: --
160: End chk_position_id;
161:
162: -- ----------------------------------------------------------------------------
215: and p_validation_end_date >= effective_start_date;
216: --
217: BEGIN
218: --
219: hr_utility.set_location('Entering:'||l_proc, 5);
220: --
221: l_api_updating := ben_pst_shd.api_updating
222: (p_pstn_rt_id => p_pstn_rt_id,
223: p_effective_date => p_effective_date,
242: end if;
243: close c_dup;
244: --
245: end if;
246: hr_utility.set_location('Leaving:'||l_proc,10);
247: --
248: END chk_dup_record;
249: --
250:
284: l_api_updating boolean;
285: --
286: Begin
287: --
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: l_api_updating := ben_pst_shd.api_updating
291: (p_pstn_rt_id => p_pstn_rt_id,
292: p_effective_date => p_effective_date,
313: end if;
314: --
315: end if;
316: --
317: hr_utility.set_location('Leaving:'||l_proc,10);
318: --
319: end chk_excld_flag;
320: --
321: --
370: and business_group_id + 0 = p_business_group_id
371: and ordr_num = p_ordr_num;
372: --
373: Begin
374: hr_utility.set_location('Entering:'||l_proc, 5);
375:
376: --
377: open c1;
378: fetch c1 into l_dummy;
382: fnd_message.raise_error;
383: end if;
384: close c1;
385: --
386: hr_utility.set_location('Leaving:'||l_proc, 15);
387: End chk_duplicate_ordr_num;
388:
389:
390:
430: l_integrity_error Exception;
431: l_table_name all_tables.table_name%TYPE;
432: --
433: Begin
434: hr_utility.set_location('Entering:'||l_proc, 5);
435: --
436: -- Ensure that the p_datetrack_mode argument is not null
437: --
438: hr_api.mandatory_arg_error
469: End If;
470: --
471: End If;
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 10);
474: Exception
475: When l_integrity_error Then
476: --
477: -- A referential integrity check was violated therefore
534: l_rows_exist Exception;
535: l_table_name all_tables.table_name%TYPE;
536: --
537: Begin
538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: -- Ensure that the p_datetrack_mode argument is not null
541: --
542: hr_api.mandatory_arg_error
571: --
572: --
573: End If;
574: --
575: hr_utility.set_location(' Leaving:'||l_proc, 10);
576: Exception
577: When l_rows_exist Then
578: --
579: -- A referential integrity check was violated therefore
603: --
604: l_proc varchar2(72) := g_package||'insert_validate';
605: --
606: Begin
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: --
609: -- Call all supporting business operations
610: --
611: chk_pstn_rt_id
646:
647: --
648: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
649: --
650: hr_utility.set_location(' Leaving:'||l_proc, 10);
651: End insert_validate;
652: --
653: -- ----------------------------------------------------------------------------
654: -- |---------------------------< update_validate >----------------------------|
662: --
663: l_proc varchar2(72) := g_package||'update_validate';
664: --
665: Begin
666: hr_utility.set_location('Entering:'||l_proc, 5);
667: --
668: -- Call all supporting business operations
669: --
670: chk_pstn_rt_id
715: p_datetrack_mode => p_datetrack_mode,
716: p_validation_start_date => p_validation_start_date,
717: p_validation_end_date => p_validation_end_date);
718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 10);
720: End update_validate;
721: --
722: -- ----------------------------------------------------------------------------
723: -- |---------------------------< delete_validate >----------------------------|
731: --
732: l_proc varchar2(72) := g_package||'delete_validate';
733: --
734: Begin
735: hr_utility.set_location('Entering:'||l_proc, 5);
736: --
737: -- Call all supporting business operations
738: --
739: dt_delete_validate
741: p_validation_start_date => p_validation_start_date,
742: p_validation_end_date => p_validation_end_date,
743: p_pstn_rt_id => p_rec.pstn_rt_id);
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 10);
746: End delete_validate;
747: --
748: --
749: -- ---------------------------------------------------------------------------
768: l_proc varchar2(72) := g_package||'return_legislation_code';
769: --
770: begin
771: --
772: hr_utility.set_location('Entering:'|| l_proc, 10);
773: --
774: -- Ensure that all the mandatory parameter are not null
775: --
776: hr_api.mandatory_arg_error(p_api_name => l_proc,
793: end if;
794: --
795: close csr_leg_code;
796: --
797: hr_utility.set_location(' Leaving:'|| l_proc, 20);
798: --
799: return l_legislation_code;
800: --
801: end return_legislation_code;