[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_psl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_per_info_chg_cs_ler_id => p_per_info_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_per_info_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_psl_shd.api_updating
133: (p_per_info_chg_cs_ler_id => p_per_info_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_per_info_chg_cs_ler_rl;
169: --
170: -- ----------------------------------------------------------------------------
238: l_dummy varchar2(1);
239: --
240: Begin
241: --
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: if p_source_table is null then
245: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');
246: fnd_message.raise_error;
266: end if;
267: close c1;
268: end if;
269: --
270: hr_utility.set_location('Leaving:'||l_proc, 10);
271: --
272: End chk_table_column_val;
273: --
274: -- ----------------------------------------------------------------------------
321: l_dummy varchar2(1);
322: --
323: Begin
324: --
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: -- check name is unique
328: --
329: open c1
338: fnd_message.raise_error;
339: end if;
340: close c1;
341: --
342: hr_utility.set_location('Leaving:'||l_proc, 10);
343: --
344: End chk_name_unique;
345: --
346: -- ----------------------------------------------------------------------------
389: l_dummy varchar2(1);
390: --
391: Begin
392: --
393: hr_utility.set_location('Entering:'||l_proc, 5);
394: --
395: -- check what if label is unique
396: --
397: if p_whatif_lbl_txt is not null then
394: --
395: -- check what if label is unique
396: --
397: if p_whatif_lbl_txt is not null then
398: hr_utility.set_location(' What IF Label is not null'||l_proc, 5);
399: open c1(p_per_info_chg_cs_ler_id => p_per_info_chg_cs_ler_id
400: ,p_whatif_lbl_txt => p_whatif_lbl_txt
401: ,p_effective_date => p_effective_date
402: ,p_business_group_id => p_business_group_id) ;
408: end if;
409: close c1;
410: --
411: end if;
412: hr_utility.set_location('Leaving:'||l_proc, 10);
413: --
414: End chk_whatif_lbl_unique;
415: -- ----------------------------------------------------------------------------
416: -- |--------------------------< dt_update_validate >--------------------------|
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
481: --
482: --
483: End If;
484: --
485: hr_utility.set_location(' Leaving:'||l_proc, 10);
486: Exception
487: When l_integrity_error Then
488: --
489: -- A referential integrity check was violated therefore
546: l_rows_exist Exception;
547: l_table_name all_tables.table_name%TYPE;
548: --
549: Begin
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: -- Ensure that the p_datetrack_mode argument is not null
553: --
554: hr_api.mandatory_arg_error
591: End If;
592: --
593: End If;
594: --
595: hr_utility.set_location(' Leaving:'||l_proc, 10);
596: Exception
597: When l_rows_exist Then
598: --
599: -- A referential integrity check was violated therefore
623: --
624: l_proc varchar2(72) := g_package||'insert_validate';
625: --
626: Begin
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: -- Call all supporting business operations
630: --
631: --
666: p_business_group_id => p_rec.business_group_id,
667: p_effective_date => p_effective_date);
668:
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 10);
671: End insert_validate;
672: --
673: -- ----------------------------------------------------------------------------
674: -- |---------------------------< update_validate >----------------------------|
682: --
683: l_proc varchar2(72) := g_package||'update_validate';
684: --
685: Begin
686: hr_utility.set_location('Entering:'||l_proc, 5);
687: --
688: -- Call all supporting business operations
689: --
690: --
733: p_datetrack_mode => p_datetrack_mode,
734: p_validation_start_date => p_validation_start_date,
735: p_validation_end_date => p_validation_end_date);
736: --
737: hr_utility.set_location(' Leaving:'||l_proc, 10);
738: End update_validate;
739: --
740: -- ----------------------------------------------------------------------------
741: -- |---------------------------< delete_validate >----------------------------|
749: --
750: l_proc varchar2(72) := g_package||'delete_validate';
751: --
752: Begin
753: hr_utility.set_location('Entering:'||l_proc, 5);
754: --
755: -- Call all supporting business operations
756: --
757: dt_delete_validate
759: p_validation_start_date => p_validation_start_date,
760: p_validation_end_date => p_validation_end_date,
761: p_per_info_chg_cs_ler_id => p_rec.per_info_chg_cs_ler_id);
762: --
763: hr_utility.set_location(' Leaving:'||l_proc, 10);
764: End delete_validate;
765: --
766: --
767: -- ---------------------------------------------------------------------------
786: l_proc varchar2(72) := g_package||'return_legislation_code';
787: --
788: begin
789: --
790: hr_utility.set_location('Entering:'|| l_proc, 10);
791: --
792: -- Ensure that all the mandatory parameter are not null
793: --
794: hr_api.mandatory_arg_error(p_api_name => l_proc,
811: end if;
812: --
813: close csr_leg_code;
814: --
815: hr_utility.set_location(' Leaving:'|| l_proc, 20);
816: --
817: return l_legislation_code;
818: --
819: end return_legislation_code;