[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_epl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_pstl_cd_r_rng_cvg_id => p_elig_pstl_cd_r_rng_cvg_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_pstl_cd_r_rng_cvg_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_epl_shd.api_updating
118: (p_elig_pstl_cd_r_rng_cvg_id => p_elig_pstl_cd_r_rng_cvg_id,
119: p_effective_date => p_effective_date,
140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_excld_flag;
147: --
148: --
193:
194: --
195: Begin
196: --
197: hr_utility.set_location('Entering:'||l_proc, 6);
198: --
199: open c1;
200: fetch c1 into dummy;
201: if c1%found then
204: fnd_message.raise_error;
205: end if;
206: close c1;
207: --
208: hr_utility.set_location('Leaving:'||l_proc, 10);
209: --
210: End chk_duplicate_rows;
211:
212: --
259: and business_group_id + 0 = p_business_group_id
260: and ordr_num = p_ordr_num;
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264:
265: --
266: open c1;
267: fetch c1 into l_dummy;
271: fnd_message.raise_error;
272: end if;
273: close c1;
274: --
275: hr_utility.set_location('Leaving:'||l_proc, 15);
276: End chk_duplicate_ordr_num;
277: --
278:
279: --
318: l_integrity_error Exception;
319: l_table_name all_tables.table_name%TYPE;
320: --
321: Begin
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: -- Ensure that the p_datetrack_mode argument is not null
325: --
326: hr_api.mandatory_arg_error
367: End If;
368: --
369: End If;
370: --
371: hr_utility.set_location(' Leaving:'||l_proc, 10);
372: Exception
373: When l_integrity_error Then
374: --
375: -- A referential integrity check was violated therefore
432: l_rows_exist Exception;
433: l_table_name all_tables.table_name%TYPE;
434: --
435: Begin
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: -- Ensure that the p_datetrack_mode argument is not null
439: --
440: hr_api.mandatory_arg_error
469: --
470: --
471: End If;
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 10);
474: Exception
475: When l_rows_exist Then
476: --
477: -- A referential integrity check was violated therefore
501: --
502: l_proc varchar2(72) := g_package||'insert_validate';
503: --
504: Begin
505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: -- Call all supporting business operations
508: --
509: --
537: ,p_validation_end_date =>p_validation_end_date
538: ,p_business_group_id => p_rec.business_group_id);
539:
540: --
541: hr_utility.set_location(' Leaving:'||l_proc, 10);
542: End insert_validate;
543: --
544: -- ----------------------------------------------------------------------------
545: -- |---------------------------< update_validate >----------------------------|
553: --
554: l_proc varchar2(72) := g_package||'update_validate';
555: --
556: Begin
557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: -- Call all supporting business operations
560: --
561: --
597: p_datetrack_mode => p_datetrack_mode,
598: p_validation_start_date => p_validation_start_date,
599: p_validation_end_date => p_validation_end_date);
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: End update_validate;
603: --
604: -- ----------------------------------------------------------------------------
605: -- |---------------------------< delete_validate >----------------------------|
613: --
614: l_proc varchar2(72) := g_package||'delete_validate';
615: --
616: Begin
617: hr_utility.set_location('Entering:'||l_proc, 5);
618: --
619: -- Call all supporting business operations
620: --
621: dt_delete_validate
623: p_validation_start_date => p_validation_start_date,
624: p_validation_end_date => p_validation_end_date,
625: p_elig_pstl_cd_r_rng_cvg_id => p_rec.elig_pstl_cd_r_rng_cvg_id);
626: --
627: hr_utility.set_location(' Leaving:'||l_proc, 10);
628: End delete_validate;
629: --
630: --
631: -- ---------------------------------------------------------------------------
650: l_proc varchar2(72) := g_package||'return_legislation_code';
651: --
652: begin
653: --
654: hr_utility.set_location('Entering:'|| l_proc, 10);
655: --
656: -- Ensure that all the mandatory parameter are not null
657: --
658: hr_api.mandatory_arg_error(p_api_name => l_proc,
675: end if;
676: --
677: close csr_leg_code;
678: --
679: hr_utility.set_location(' Leaving:'|| l_proc, 20);
680: --
681: return l_legislation_code;
682: --
683: end return_legislation_code;