[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_rcl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_rltd_per_chg_cs_ler_id => p_rltd_per_chg_cs_ler_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_rltd_per_chg_cs_ler_id;
78: --
79: -- ----------------------------------------------------------------------------
126: and ff.effective_end_date;
127: --
128: Begin
129: --
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: l_api_updating := ben_rcl_shd.api_updating
133: (p_rltd_per_chg_cs_ler_id => p_rltd_per_chg_cs_ler_id,
134: p_effective_date => p_effective_date,
162: close c1;
163: --
164: end if;
165: --
166: hr_utility.set_location('Leaving:'||l_proc,10);
167: --
168: end chk_rltd_per_chg_cs_ler_rl;
169: --
170: -- ----------------------------------------------------------------------------
236: l_dummy varchar2(1);
237: --
238: Begin
239: --
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: if p_source_table is null then
243: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');
244: fnd_message.raise_error;
263: end if;
264: close c1;
265: end if;
266: --
267: hr_utility.set_location('Leaving:'||l_proc, 10);
268: --
269: End chk_table_column_val;
270: --
271: -- ----------------------------------------------------------------------------
316: l_dummy varchar2(1);
317: --
318: Begin
319: --
320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: -- check name is unique
323: --
324: open c1
332: fnd_message.raise_error;
333: end if;
334: close c1;
335: --
336: hr_utility.set_location('Leaving:'||l_proc, 10);
337: --
338: End chk_name_unique;
339: --
340: --
385: l_dummy varchar2(1);
386: --
387: Begin
388: --
389: hr_utility.set_location('Entering:'||l_proc, 5);
390: --
391: -- check what if label is unique
392: --
393: if p_whatif_lbl_txt is not null then
390: --
391: -- check what if label is unique
392: --
393: if p_whatif_lbl_txt is not null then
394: hr_utility.set_location(' What IF Label is not null'||l_proc, 5);
395: open c1(p_rltd_per_chg_cs_ler_id => p_rltd_per_chg_cs_ler_id
396: ,p_whatif_lbl_txt => p_whatif_lbl_txt
397: ,p_effective_date => p_effective_date
398: ,p_business_group_id => p_business_group_id) ;
404: end if;
405: close c1;
406: --
407: end if;
408: hr_utility.set_location('Leaving:'||l_proc, 10);
409: --
410: End chk_whatif_lbl_unique;
411: --
412: -- ----------------------------------------------------------------------------
448: l_integrity_error Exception;
449: l_table_name all_tables.table_name%TYPE;
450: --
451: Begin
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: -- Ensure that the p_datetrack_mode argument is not null
455: --
456: hr_api.mandatory_arg_error
478: --
479: --
480: End If;
481: --
482: hr_utility.set_location(' Leaving:'||l_proc, 10);
483: Exception
484: When l_integrity_error Then
485: --
486: -- A referential integrity check was violated therefore
543: l_rows_exist Exception;
544: l_table_name all_tables.table_name%TYPE;
545: --
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- Ensure that the p_datetrack_mode argument is not null
550: --
551: hr_api.mandatory_arg_error
588: End If;
589: --
590: End If;
591: --
592: hr_utility.set_location(' Leaving:'||l_proc, 10);
593: Exception
594: When l_rows_exist Then
595: --
596: -- A referential integrity check was violated therefore
620: --
621: l_proc varchar2(72) := g_package||'insert_validate';
622: --
623: Begin
624: hr_utility.set_location('Entering:'||l_proc, 5);
625: --
626: -- Call all supporting business operations
627: --
628: --
662: p_whatif_lbl_txt => p_rec.whatif_lbl_txt,
663: p_business_group_id => p_rec.business_group_id,
664: p_effective_date => p_effective_date);
665: --
666: hr_utility.set_location(' Leaving:'||l_proc, 10);
667: End insert_validate;
668: --
669: -- ----------------------------------------------------------------------------
670: -- |---------------------------< update_validate >----------------------------|
678: --
679: l_proc varchar2(72) := g_package||'update_validate';
680: --
681: Begin
682: hr_utility.set_location('Entering:'||l_proc, 5);
683: --
684: -- Call all supporting business operations
685: --
686: --
729: p_datetrack_mode => p_datetrack_mode,
730: p_validation_start_date => p_validation_start_date,
731: p_validation_end_date => p_validation_end_date);
732: --
733: hr_utility.set_location(' Leaving:'||l_proc, 10);
734: End update_validate;
735: --
736: -- ----------------------------------------------------------------------------
737: -- |---------------------------< delete_validate >----------------------------|
745: --
746: l_proc varchar2(72) := g_package||'delete_validate';
747: --
748: Begin
749: hr_utility.set_location('Entering:'||l_proc, 5);
750: --
751: -- Call all supporting business operations
752: --
753: dt_delete_validate
755: p_validation_start_date => p_validation_start_date,
756: p_validation_end_date => p_validation_end_date,
757: p_rltd_per_chg_cs_ler_id => p_rec.rltd_per_chg_cs_ler_id);
758: --
759: hr_utility.set_location(' Leaving:'||l_proc, 10);
760: End delete_validate;
761: --
762: --
763: -- ---------------------------------------------------------------------------
782: l_proc varchar2(72) := g_package||'return_legislation_code';
783: --
784: begin
785: --
786: hr_utility.set_location('Entering:'|| l_proc, 10);
787: --
788: -- Ensure that all the mandatory parameter are not null
789: --
790: hr_api.mandatory_arg_error(p_api_name => l_proc,
807: end if;
808: --
809: close csr_leg_code;
810: --
811: hr_utility.set_location(' Leaving:'|| l_proc, 20);
812: --
813: return l_legislation_code;
814: --
815: end return_legislation_code;