42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_CEP_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_prtn_elig_prfl_id => p_prtn_elig_prfl_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_prtn_elig_prfl_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_CEP_shd.api_updating
118: (p_prtn_elig_prfl_id => p_prtn_elig_prfl_id,
119: p_effective_date => p_effective_date,
139: fnd_message.set_token('VALUE', p_mndtry_flag);
140: fnd_message.set_token('TYPE', 'YES_NO');
141: fnd_message.raise_error;
142:
143: --hr_utility.set_message(801,'MNDTRY_FLAG_NOT_EXIST');
144: --hr_utility.raise_error;
145: --
146: end if;
147: --
140: fnd_message.set_token('TYPE', 'YES_NO');
141: fnd_message.raise_error;
142:
143: --hr_utility.set_message(801,'MNDTRY_FLAG_NOT_EXIST');
144: --hr_utility.raise_error;
145: --
146: end if;
147: --
148: end if;
146: end if;
147: --
148: end if;
149: --
150: hr_utility.set_location('Leaving:'||l_proc,10);
151: --
152: end chk_mndtry_flag;
153: --
154: --
187: l_api_updating boolean;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: l_api_updating := ben_CEP_shd.api_updating
194: (p_prtn_elig_prfl_id => p_prtn_elig_prfl_id,
195: p_effective_date => p_effective_date,
219: end if;
220: --
221: end if;
222: --
223: hr_utility.set_location('Leaving:'||l_proc,10);
224: --
225: end chk_cmpscore_flag;
226: --
227: --
278: --
279: --
280: Begin
281: --
282: hr_utility.set_location('Entering:'||l_proc,5);
283: --
284: l_api_updating := ben_cep_shd.api_updating
285: (p_prtn_elig_prfl_id => p_prtn_elig_prfl_id,
286: p_effective_date => p_effective_date,
306: close c1;
307: --
308: end if;
309: --
310: hr_utility.set_location('Leaving:'||l_proc,10);
311: --
312: End chk_eligy_prfl_id;
313: --
314: -- bug 3876692
373: and plip.effective_end_date;
374: --
375: Begin
376: --
377: hr_utility.set_location('Entering:'||l_proc,5);
378: --
379: open c1;
380: fetch c1 into l_exists;
381: if c1%found then
405: close c2;
406: --
407: end if;
408: --
409: hr_utility.set_location('Leaving:'||l_proc,10);
410: --
411: End chk_flx_impt_extnce;
412: --
413: --
451: l_integrity_error Exception;
452: l_table_name all_tables.table_name%TYPE;
453: --
454: Begin
455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: -- Ensure that the p_datetrack_mode argument is not null
458: --
459: hr_api.mandatory_arg_error
500: End If;
501: --
502: End If;
503: --
504: hr_utility.set_location(' Leaving:'||l_proc, 10);
505: Exception
506: When l_integrity_error Then
507: --
508: -- A referential integrity check was violated therefore
507: --
508: -- A referential integrity check was violated therefore
509: -- we must error
510: --
511: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
512: hr_utility.set_message_token('TABLE_NAME', l_table_name);
513: hr_utility.raise_error;
514: When Others Then
515: --
508: -- A referential integrity check was violated therefore
509: -- we must error
510: --
511: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
512: hr_utility.set_message_token('TABLE_NAME', l_table_name);
513: hr_utility.raise_error;
514: When Others Then
515: --
516: -- An unhandled or unexpected error has occurred which
509: -- we must error
510: --
511: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
512: hr_utility.set_message_token('TABLE_NAME', l_table_name);
513: hr_utility.raise_error;
514: When Others Then
515: --
516: -- An unhandled or unexpected error has occurred which
517: -- we must report
515: --
516: -- An unhandled or unexpected error has occurred which
517: -- we must report
518: --
519: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
520: hr_utility.set_message_token('PROCEDURE', l_proc);
521: hr_utility.set_message_token('STEP','15');
522: hr_utility.raise_error;
523: End dt_update_validate;
516: -- An unhandled or unexpected error has occurred which
517: -- we must report
518: --
519: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
520: hr_utility.set_message_token('PROCEDURE', l_proc);
521: hr_utility.set_message_token('STEP','15');
522: hr_utility.raise_error;
523: End dt_update_validate;
524: --
517: -- we must report
518: --
519: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
520: hr_utility.set_message_token('PROCEDURE', l_proc);
521: hr_utility.set_message_token('STEP','15');
522: hr_utility.raise_error;
523: End dt_update_validate;
524: --
525: -- ----------------------------------------------------------------------------
518: --
519: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
520: hr_utility.set_message_token('PROCEDURE', l_proc);
521: hr_utility.set_message_token('STEP','15');
522: hr_utility.raise_error;
523: End dt_update_validate;
524: --
525: -- ----------------------------------------------------------------------------
526: -- |--------------------------< dt_delete_validate >--------------------------|
567: l_rows_exist Exception;
568: l_table_name all_tables.table_name%TYPE;
569: --
570: Begin
571: hr_utility.set_location('Entering:'||l_proc, 5);
572: --
573: -- Ensure that the p_datetrack_mode argument is not null
574: --
575: hr_api.mandatory_arg_error
618: */
619: --
620: End If;
621: --
622: hr_utility.set_location(' Leaving:'||l_proc, 10);
623: Exception
624: When l_rows_exist Then
625: --
626: -- A referential integrity check was violated therefore
625: --
626: -- A referential integrity check was violated therefore
627: -- we must error
628: --
629: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
630: hr_utility.set_message_token('TABLE_NAME', l_table_name);
631: hr_utility.raise_error;
632: When Others Then
633: --
626: -- A referential integrity check was violated therefore
627: -- we must error
628: --
629: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
630: hr_utility.set_message_token('TABLE_NAME', l_table_name);
631: hr_utility.raise_error;
632: When Others Then
633: --
634: -- An unhandled or unexpected error has occurred which
627: -- we must error
628: --
629: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
630: hr_utility.set_message_token('TABLE_NAME', l_table_name);
631: hr_utility.raise_error;
632: When Others Then
633: --
634: -- An unhandled or unexpected error has occurred which
635: -- we must report
633: --
634: -- An unhandled or unexpected error has occurred which
635: -- we must report
636: --
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE', l_proc);
639: hr_utility.set_message_token('STEP','15');
640: hr_utility.raise_error;
641: End dt_delete_validate;
634: -- An unhandled or unexpected error has occurred which
635: -- we must report
636: --
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE', l_proc);
639: hr_utility.set_message_token('STEP','15');
640: hr_utility.raise_error;
641: End dt_delete_validate;
642: --
635: -- we must report
636: --
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE', l_proc);
639: hr_utility.set_message_token('STEP','15');
640: hr_utility.raise_error;
641: End dt_delete_validate;
642: --
643: -- ----------------------------------------------------------------------------
636: --
637: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
638: hr_utility.set_message_token('PROCEDURE', l_proc);
639: hr_utility.set_message_token('STEP','15');
640: hr_utility.raise_error;
641: End dt_delete_validate;
642: --
643: -- ----------------------------------------------------------------------------
644: -- |---------------------------< insert_validate >----------------------------|
652: --
653: l_proc varchar2(72) := g_package||'insert_validate';
654: --
655: Begin
656: hr_utility.set_location('Entering:'||l_proc, 5);
657: --
658: -- Call all supporting business operations
659: --
660: --
691: --
692: chk_flx_impt_extnce(p_prtn_elig_id => p_rec.prtn_elig_id,
693: p_effective_date => p_effective_date);
694: --
695: hr_utility.set_location(' Leaving:'||l_proc, 10);
696: End insert_validate;
697: --
698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< update_validate >----------------------------|
707: --
708: l_proc varchar2(72) := g_package||'update_validate';
709: --
710: Begin
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: -- Call all supporting business operations
714: --
715: --
755: --
756: chk_flx_impt_extnce(p_prtn_elig_id => p_rec.prtn_elig_id,
757: p_effective_date => p_effective_date);
758: --
759: hr_utility.set_location(' Leaving:'||l_proc, 10);
760: End update_validate;
761: --
762: -- ----------------------------------------------------------------------------
763: -- |---------------------------< delete_validate >----------------------------|
771: --
772: l_proc varchar2(72) := g_package||'delete_validate';
773: --
774: Begin
775: hr_utility.set_location('Entering:'||l_proc, 5);
776: --
777: -- Call all supporting business operations
778: --
779: dt_delete_validate
781: p_validation_start_date => p_validation_start_date,
782: p_validation_end_date => p_validation_end_date,
783: p_prtn_elig_prfl_id => p_rec.prtn_elig_prfl_id);
784: --
785: hr_utility.set_location(' Leaving:'||l_proc, 10);
786: End delete_validate;
787: --
788: --
789: -- ---------------------------------------------------------------------------
808: l_proc varchar2(72) := g_package||'return_legislation_code';
809: --
810: begin
811: --
812: hr_utility.set_location('Entering:'|| l_proc, 10);
813: --
814: -- Ensure that all the mandatory parameter are not null
815: --
816: hr_api.mandatory_arg_error(p_api_name => l_proc,
826: close csr_leg_code;
827: --
828: -- The primary key is invalid therefore we must error
829: --
830: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
831: hr_utility.raise_error;
832: --
833: end if;
834: --
827: --
828: -- The primary key is invalid therefore we must error
829: --
830: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
831: hr_utility.raise_error;
832: --
833: end if;
834: --
835: close csr_leg_code;
833: end if;
834: --
835: close csr_leg_code;
836: --
837: hr_utility.set_location(' Leaving:'|| l_proc, 20);
838: --
839: return l_legislation_code;
840: --
841: end return_legislation_code;