42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_bvr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_bnft_vrbl_rt_id => p_bnft_vrbl_rt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_bnft_vrbl_rt_id;
78: --
79: -- ---------------------------------------------------------------------------
118: and ordr_num = p_ordr_num
119: and business_group_id = p_business_group_id;
120: --
121: Begin
122: hr_utility.set_location('Entering:'||l_proc, 5);
123: --
124: open c1;
125: fetch c1 into l_dummy;
126: if c1%found then
128: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
129: fnd_message.raise_error;
130: end if;
131: --
132: hr_utility.set_location('Leaving:'||l_proc, 15);
133: End chk_ordr_num_unique;
134: --
135: -- ----------------------------------------------------------------------------
136: -- |------------------------< chk_brr_bvr_mutexcl >--------------------------|
181: and a.effective_end_date;
182: --
183: Begin
184: --
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: l_api_updating := ben_bvr_shd.api_updating
188: (p_effective_date => p_effective_date,
189: p_bnft_vrbl_rt_id => p_bnft_vrbl_rt_id,
211: close c1;
212: --
213: end if;
214: --
215: hr_utility.set_location('Leaving:'||l_proc, 10);
216: --
217: End chk_brr_bvr_mutexcl;
218: --
219: -- ----------------------------------------------------------------------------
256: l_integrity_error Exception;
257: l_table_name all_tables.table_name%TYPE;
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: -- Ensure that the p_datetrack_mode argument is not null
263: --
264: hr_api.mandatory_arg_error
305: End If;
306: --
307: End If;
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 10);
310: Exception
311: When l_integrity_error Then
312: --
313: -- A referential integrity check was violated therefore
319: --
320: -- An unhandled or unexpected error has occurred which
321: -- we must report
322: --
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE', l_proc);
325: hr_utility.set_message_token('STEP','15');
326: hr_utility.raise_error;
327: End dt_update_validate;
320: -- An unhandled or unexpected error has occurred which
321: -- we must report
322: --
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE', l_proc);
325: hr_utility.set_message_token('STEP','15');
326: hr_utility.raise_error;
327: End dt_update_validate;
328: --
321: -- we must report
322: --
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE', l_proc);
325: hr_utility.set_message_token('STEP','15');
326: hr_utility.raise_error;
327: End dt_update_validate;
328: --
329: -- ----------------------------------------------------------------------------
322: --
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE', l_proc);
325: hr_utility.set_message_token('STEP','15');
326: hr_utility.raise_error;
327: End dt_update_validate;
328: --
329: -- ----------------------------------------------------------------------------
330: -- |--------------------------< dt_delete_validate >--------------------------|
371: l_rows_exist Exception;
372: l_table_name all_tables.table_name%TYPE;
373: --
374: Begin
375: hr_utility.set_location('Entering:'||l_proc, 5);
376: --
377: -- Ensure that the p_datetrack_mode argument is not null
378: --
379: hr_api.mandatory_arg_error
408: --
409: --
410: End If;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: Exception
414: When l_rows_exist Then
415: --
416: -- A referential integrity check was violated therefore
422: --
423: -- An unhandled or unexpected error has occurred which
424: -- we must report
425: --
426: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
427: hr_utility.set_message_token('PROCEDURE', l_proc);
428: hr_utility.set_message_token('STEP','15');
429: hr_utility.raise_error;
430: End dt_delete_validate;
423: -- An unhandled or unexpected error has occurred which
424: -- we must report
425: --
426: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
427: hr_utility.set_message_token('PROCEDURE', l_proc);
428: hr_utility.set_message_token('STEP','15');
429: hr_utility.raise_error;
430: End dt_delete_validate;
431: --
424: -- we must report
425: --
426: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
427: hr_utility.set_message_token('PROCEDURE', l_proc);
428: hr_utility.set_message_token('STEP','15');
429: hr_utility.raise_error;
430: End dt_delete_validate;
431: --
432: -- ----------------------------------------------------------------------------
425: --
426: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
427: hr_utility.set_message_token('PROCEDURE', l_proc);
428: hr_utility.set_message_token('STEP','15');
429: hr_utility.raise_error;
430: End dt_delete_validate;
431: --
432: -- ----------------------------------------------------------------------------
433: -- |---------------------------< insert_validate >----------------------------|
441: --
442: l_proc varchar2(72) := g_package||'insert_validate';
443: --
444: Begin
445: hr_utility.set_location('Entering:'||l_proc, 5);
446: --
447: -- Call all supporting business operations
448: --
449: --
466: p_effective_date => p_effective_date,
467: p_business_group_id => p_rec.business_group_id,
468: p_object_version_number => p_rec.object_version_number);
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 10);
471: End insert_validate;
472: --
473: -- ----------------------------------------------------------------------------
474: -- |---------------------------< update_validate >----------------------------|
482: --
483: l_proc varchar2(72) := g_package||'update_validate';
484: --
485: Begin
486: hr_utility.set_location('Entering:'||l_proc, 5);
487: --
488: -- Call all supporting business operations
489: --
490: --
516: p_datetrack_mode => p_datetrack_mode,
517: p_validation_start_date => p_validation_start_date,
518: p_validation_end_date => p_validation_end_date);
519: --
520: hr_utility.set_location(' Leaving:'||l_proc, 10);
521: End update_validate;
522: --
523: -- ----------------------------------------------------------------------------
524: -- |---------------------------< delete_validate >----------------------------|
532: --
533: l_proc varchar2(72) := g_package||'delete_validate';
534: --
535: Begin
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: -- Call all supporting business operations
539: --
540: dt_delete_validate
542: p_validation_start_date => p_validation_start_date,
543: p_validation_end_date => p_validation_end_date,
544: p_bnft_vrbl_rt_id => p_rec.bnft_vrbl_rt_id);
545: --
546: hr_utility.set_location(' Leaving:'||l_proc, 10);
547: End delete_validate;
548: --
549: --
550: -- ---------------------------------------------------------------------------
569: l_proc varchar2(72) := g_package||'return_legislation_code';
570: --
571: begin
572: --
573: hr_utility.set_location('Entering:'|| l_proc, 10);
574: --
575: -- Ensure that all the mandatory parameter are not null
576: --
577: hr_api.mandatory_arg_error(p_api_name => l_proc,
587: close csr_leg_code;
588: --
589: -- The primary key is invalid therefore we must error
590: --
591: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
592: hr_utility.raise_error;
593: --
594: end if;
595: --
588: --
589: -- The primary key is invalid therefore we must error
590: --
591: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
592: hr_utility.raise_error;
593: --
594: end if;
595: --
596: close csr_leg_code;
594: end if;
595: --
596: close csr_leg_code;
597: --
598: hr_utility.set_location(' Leaving:'|| l_proc, 20);
599: --
600: return l_legislation_code;
601: --
602: end return_legislation_code;