[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_dcp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_dpnt_cvrd_plip_rt_id => p_dpnt_cvrd_plip_rt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_dpnt_cvrd_plip_rt_id;
78: --
79: -- ----------------------------------------------------------------------------
111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_dcp_shd.api_updating
118: (p_dpnt_cvrd_plip_rt_id => p_dpnt_cvrd_plip_rt_id,
119: p_effective_date => p_effective_date,
143: end if;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: end chk_enrl_det_dt_cd;
150: --
151: -- ----------------------------------------------------------------------------
183: l_api_updating boolean;
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_dcp_shd.api_updating
190: (p_dpnt_cvrd_plip_rt_id => p_dpnt_cvrd_plip_rt_id,
191: p_effective_date => p_effective_date,
215: end if;
216: --
217: end if;
218: --
219: hr_utility.set_location('Leaving:'||l_proc,10);
220: --
221: end chk_excld_flag;
222: -- ----------------------------------------------------------------------------
223: -- |------< chk_dup_record >------|
277: and p_validation_end_date >= effective_start_date;
278: --
279: BEGIN
280: --
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: l_api_updating := ben_dcp_shd.api_updating
284: (p_dpnt_cvrd_plip_rt_id => p_dpnt_cvrd_plip_rt_id,
285: p_effective_date => p_effective_date,
306: end if;
307: close c_dup;
308: --
309: end if;
310: hr_utility.set_location('Leaving:'||l_proc,10);
311: --
312: END chk_dup_record;
313:
314: --
363: and business_group_id + 0 = p_business_group_id
364: and ordr_num = p_ordr_num;
365: --
366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);
368:
369: --
370: open c1;
371: fetch c1 into l_dummy;
375: fnd_message.raise_error;
376: end if;
377: close c1;
378: --
379: hr_utility.set_location('Leaving:'||l_proc, 15);
380: End chk_duplicate_ordr_num;
381:
382: --
383: -- ----------------------------------------------------------------------------
420: l_integrity_error Exception;
421: l_table_name all_tables.table_name%TYPE;
422: --
423: Begin
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: -- Ensure that the p_datetrack_mode argument is not null
427: --
428: 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
536: l_rows_exist Exception;
537: l_table_name all_tables.table_name%TYPE;
538: --
539: Begin
540: hr_utility.set_location('Entering:'||l_proc, 5);
541: --
542: -- Ensure that the p_datetrack_mode argument is not null
543: --
544: hr_api.mandatory_arg_error
573: --
574: --
575: End If;
576: --
577: hr_utility.set_location(' Leaving:'||l_proc, 10);
578: Exception
579: When l_rows_exist Then
580: --
581: -- A referential integrity check was violated therefore
607: --
608: l_proc varchar2(72) := g_package||'insert_validate';
609: --
610: Begin
611: hr_utility.set_location('Entering:'||l_proc, 5);
612: --
613: -- Call all supporting business operations
614: --
615: chk_dpnt_cvrd_plip_rt_id
651:
652: --
653: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 10);
656: End insert_validate;
657: --
658: -- ----------------------------------------------------------------------------
659: -- |---------------------------< update_validate >----------------------------|
667: --
668: l_proc varchar2(72) := g_package||'update_validate';
669: --
670: Begin
671: hr_utility.set_location('Entering:'||l_proc, 5);
672: --
673: -- Call all supporting business operations
674: --
675: chk_dpnt_cvrd_plip_rt_id
719: p_datetrack_mode => p_datetrack_mode,
720: p_validation_start_date => p_validation_start_date,
721: p_validation_end_date => p_validation_end_date);
722: --
723: hr_utility.set_location(' Leaving:'||l_proc, 10);
724: End update_validate;
725: --
726: -- ----------------------------------------------------------------------------
727: -- |---------------------------< delete_validate >----------------------------|
735: --
736: l_proc varchar2(72) := g_package||'delete_validate';
737: --
738: Begin
739: hr_utility.set_location('Entering:'||l_proc, 5);
740: --
741: -- Call all supporting business operations
742: --
743: dt_delete_validate
745: p_validation_start_date => p_validation_start_date,
746: p_validation_end_date => p_validation_end_date,
747: p_dpnt_cvrd_plip_rt_id => p_rec.dpnt_cvrd_plip_rt_id);
748: --
749: hr_utility.set_location(' Leaving:'||l_proc, 10);
750: End delete_validate;
751: --
752: --
753: -- ---------------------------------------------------------------------------
772: l_proc varchar2(72) := g_package||'return_legislation_code';
773: --
774: begin
775: --
776: hr_utility.set_location('Entering:'|| l_proc, 10);
777: --
778: -- Ensure that all the mandatory parameter are not null
779: --
780: hr_api.mandatory_arg_error(p_api_name => l_proc,
797: end if;
798: --
799: close csr_leg_code;
800: --
801: hr_utility.set_location(' Leaving:'|| l_proc, 20);
802: --
803: return l_legislation_code;
804: --
805: end return_legislation_code;