42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_epf_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_pct_fl_tm_prte_id => p_elig_pct_fl_tm_prte_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_pct_fl_tm_prte_id;
78: --
79: -- ----------------------------------------------------------------------------
135: ;
136: --
137: Begin
138: --
139: hr_utility.set_location('Entering:'||l_proc,5);
140: --
141: l_api_updating := ben_epf_shd.api_updating
142: (p_elig_pct_fl_tm_prte_id => p_elig_pct_fl_tm_prte_id,
143: p_effective_date => p_effective_date,
181: close c3;
182: --
183: end if;
184: --
185: hr_utility.set_location('Leaving:'||l_proc,10);
186: --
187: End chk_pct_fl_tm_fctr_id;
188: --
189: -- ----------------------------------------------------------------------------
221: l_api_updating boolean;
222: --
223: Begin
224: --
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: l_api_updating := ben_epf_shd.api_updating
228: (p_elig_pct_fl_tm_prte_id => p_elig_pct_fl_tm_prte_id,
229: p_effective_date => p_effective_date,
243: p_effective_date => p_effective_date) then
244: --
245: -- raise error as does not exist as lookup
246: --
247: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
248: hr_utility.raise_error;
249: --
250: end if;
251: --
244: --
245: -- raise error as does not exist as lookup
246: --
247: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
248: hr_utility.raise_error;
249: --
250: end if;
251: --
252: end if;
250: end if;
251: --
252: end if;
253: --
254: hr_utility.set_location('Leaving:'||l_proc,10);
255: --
256: end chk_excld_flag;
257: --
258: --Bug:5054189
299: and ordr_num = p_ordr_num
300: and business_group_id = p_business_group_id;
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: open c1;
306: fetch c1 into l_dummy;
307: if c1%found then
310: fnd_message.raise_error;
311: end if;
312: close c1;
313: --
314: hr_utility.set_location('Leaving:'||l_proc, 15);
315: End chk_duplicate_ordr_num;
316: -- ----------------------------------------------------------------------------
317: -- |--------------------------< dt_update_validate >--------------------------|
318: -- ----------------------------------------------------------------------------
352: l_integrity_error Exception;
353: l_table_name all_tables.table_name%TYPE;
354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: -- Ensure that the p_datetrack_mode argument is not null
359: --
360: hr_api.mandatory_arg_error
391: End If;
392: --
393: End If;
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: Exception
397: When l_integrity_error Then
398: --
399: -- A referential integrity check was violated therefore
398: --
399: -- A referential integrity check was violated therefore
400: -- we must error
401: --
402: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
403: hr_utility.set_message_token('TABLE_NAME', l_table_name);
404: hr_utility.raise_error;
405: When Others Then
406: --
399: -- A referential integrity check was violated therefore
400: -- we must error
401: --
402: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
403: hr_utility.set_message_token('TABLE_NAME', l_table_name);
404: hr_utility.raise_error;
405: When Others Then
406: --
407: -- An unhandled or unexpected error has occurred which
400: -- we must error
401: --
402: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
403: hr_utility.set_message_token('TABLE_NAME', l_table_name);
404: hr_utility.raise_error;
405: When Others Then
406: --
407: -- An unhandled or unexpected error has occurred which
408: -- we must report
406: --
407: -- An unhandled or unexpected error has occurred which
408: -- we must report
409: --
410: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
411: hr_utility.set_message_token('PROCEDURE', l_proc);
412: hr_utility.set_message_token('STEP','15');
413: hr_utility.raise_error;
414: End dt_update_validate;
407: -- An unhandled or unexpected error has occurred which
408: -- we must report
409: --
410: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
411: hr_utility.set_message_token('PROCEDURE', l_proc);
412: hr_utility.set_message_token('STEP','15');
413: hr_utility.raise_error;
414: End dt_update_validate;
415: --
408: -- we must report
409: --
410: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
411: hr_utility.set_message_token('PROCEDURE', l_proc);
412: hr_utility.set_message_token('STEP','15');
413: hr_utility.raise_error;
414: End dt_update_validate;
415: --
416: -- ----------------------------------------------------------------------------
409: --
410: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
411: hr_utility.set_message_token('PROCEDURE', l_proc);
412: hr_utility.set_message_token('STEP','15');
413: hr_utility.raise_error;
414: End dt_update_validate;
415: --
416: -- ----------------------------------------------------------------------------
417: -- |--------------------------< dt_delete_validate >--------------------------|
458: l_rows_exist Exception;
459: l_table_name all_tables.table_name%TYPE;
460: --
461: Begin
462: hr_utility.set_location('Entering:'||l_proc, 5);
463: --
464: -- Ensure that the p_datetrack_mode argument is not null
465: --
466: hr_api.mandatory_arg_error
495: --
496: --
497: End If;
498: --
499: hr_utility.set_location(' Leaving:'||l_proc, 10);
500: Exception
501: When l_rows_exist Then
502: --
503: -- A referential integrity check was violated therefore
502: --
503: -- A referential integrity check was violated therefore
504: -- we must error
505: --
506: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
507: hr_utility.set_message_token('TABLE_NAME', l_table_name);
508: hr_utility.raise_error;
509: When Others Then
510: --
503: -- A referential integrity check was violated therefore
504: -- we must error
505: --
506: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
507: hr_utility.set_message_token('TABLE_NAME', l_table_name);
508: hr_utility.raise_error;
509: When Others Then
510: --
511: -- An unhandled or unexpected error has occurred which
504: -- we must error
505: --
506: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
507: hr_utility.set_message_token('TABLE_NAME', l_table_name);
508: hr_utility.raise_error;
509: When Others Then
510: --
511: -- An unhandled or unexpected error has occurred which
512: -- we must report
510: --
511: -- An unhandled or unexpected error has occurred which
512: -- we must report
513: --
514: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
515: hr_utility.set_message_token('PROCEDURE', l_proc);
516: hr_utility.set_message_token('STEP','15');
517: hr_utility.raise_error;
518: End dt_delete_validate;
511: -- An unhandled or unexpected error has occurred which
512: -- we must report
513: --
514: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
515: hr_utility.set_message_token('PROCEDURE', l_proc);
516: hr_utility.set_message_token('STEP','15');
517: hr_utility.raise_error;
518: End dt_delete_validate;
519: --
512: -- we must report
513: --
514: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
515: hr_utility.set_message_token('PROCEDURE', l_proc);
516: hr_utility.set_message_token('STEP','15');
517: hr_utility.raise_error;
518: End dt_delete_validate;
519: --
520: -- ----------------------------------------------------------------------------
513: --
514: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
515: hr_utility.set_message_token('PROCEDURE', l_proc);
516: hr_utility.set_message_token('STEP','15');
517: hr_utility.raise_error;
518: End dt_delete_validate;
519: --
520: -- ----------------------------------------------------------------------------
521: -- |---------------------------< insert_validate >----------------------------|
529: --
530: l_proc varchar2(72) := g_package||'insert_validate';
531: --
532: Begin
533: hr_utility.set_location('Entering:'||l_proc, 5);
534: --
535: -- Call all supporting business operations
536: --
537: --
563: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
564: ,p_ordr_num => p_rec.ordr_num
565: ,p_business_group_id => p_rec.business_group_id);
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 10);
568: End insert_validate;
569: --
570: -- ----------------------------------------------------------------------------
571: -- |---------------------------< update_validate >----------------------------|
579: --
580: l_proc varchar2(72) := g_package||'update_validate';
581: --
582: Begin
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: -- Call all supporting business operations
586: --
587: --
621: p_datetrack_mode => p_datetrack_mode,
622: p_validation_start_date => p_validation_start_date,
623: p_validation_end_date => p_validation_end_date);
624: --
625: hr_utility.set_location(' Leaving:'||l_proc, 10);
626: End update_validate;
627: --
628: -- ----------------------------------------------------------------------------
629: -- |---------------------------< delete_validate >----------------------------|
637: --
638: l_proc varchar2(72) := g_package||'delete_validate';
639: --
640: Begin
641: hr_utility.set_location('Entering:'||l_proc, 5);
642: --
643: -- Call all supporting business operations
644: --
645: dt_delete_validate
647: p_validation_start_date => p_validation_start_date,
648: p_validation_end_date => p_validation_end_date,
649: p_elig_pct_fl_tm_prte_id => p_rec.elig_pct_fl_tm_prte_id);
650: --
651: hr_utility.set_location(' Leaving:'||l_proc, 10);
652: End delete_validate;
653: --
654: --
655: -- ---------------------------------------------------------------------------
674: l_proc varchar2(72) := g_package||'return_legislation_code';
675: --
676: begin
677: --
678: hr_utility.set_location('Entering:'|| l_proc, 10);
679: --
680: -- Ensure that all the mandatory parameter are not null
681: --
682: hr_api.mandatory_arg_error(p_api_name => l_proc,
692: close csr_leg_code;
693: --
694: -- The primary key is invalid therefore we must error
695: --
696: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
697: hr_utility.raise_error;
698: --
699: end if;
700: --
693: --
694: -- The primary key is invalid therefore we must error
695: --
696: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
697: hr_utility.raise_error;
698: --
699: end if;
700: --
701: close csr_leg_code;
699: end if;
700: --
701: close csr_leg_code;
702: --
703: hr_utility.set_location(' Leaving:'|| l_proc, 20);
704: --
705: return l_legislation_code;
706: --
707: end return_legislation_code;