42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_lpl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ler_per_info_cs_ler_id => p_ler_per_info_cs_ler_id,
72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_ler_per_info_cs_ler_id;
79: --
80: -- ----------------------------------------------------------------------------
141: AND p_validation_end_date >= effective_start_date;
142: --
143: Begin
144: --
145: hr_utility.set_location('Entering:'||l_proc,5);
146: --
147: if p_per_info_chg_cs_ler_id is null then
148: fnd_message.set_name('BEN', 'BEN_91016_PERSON_CHANGE_REQ');
149: fnd_message.raise_error;
190: close c2;
191: --
192: end if;
193: --
194: hr_utility.set_location('Leaving:'||l_proc,10);
195: --
196: End chk_per_info_chg_cs_ler_id;
197: --
198: -- ----------------------------------------------------------------------------
245: and ff.effective_end_date;
246: --
247: Begin
248: --
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: l_api_updating := ben_lpl_shd.api_updating
252: (p_ler_per_info_cs_ler_id => p_ler_per_info_cs_ler_id,
253: p_effective_date => p_effective_date,
281: close c1;
282: --
283: end if;
284: --
285: hr_utility.set_location('Leaving:'||l_proc,10);
286: --
287: end chk_ler_per_info_cs_ler_rl;
288: -- ----------------------------------------------------------------------------
289: -- |------< chk_ler_id >------|
336: 'DRVDHRW', 'DRVDCMP', 'DRVDTPF', 'SCHEDDO','SCHEDDA','SCHEDDU');
337: --
338: Begin
339: --
340: hr_utility.set_location('Entering:'||l_proc,5);
341: --
342:
343: --
344: -- check if the parent ler is of certain types
352: end if;
353: close c1;
354: --
355: --
356: hr_utility.set_location('Leaving:'||l_proc,10);
357: --
358: End chk_ler_id;
359: --
360: -- ----------------------------------------------------------------------------
421: and typ_cd = 'IREC';
422: --iRec
423: Begin
424: --
425: hr_utility.set_location('Entering:'||l_proc,5);
426: --
427: --iRec
428: open c3;
429: fetch c3 into l_dummy;
463: close c2;
464: end if;
465: --
466: --
467: hr_utility.set_location('Leaving:'||l_proc,10);
468: --
469: End chk_ler_typ_cd;
470: -- ----------------------------------------------------------------------------
471: -- |-----------------------< chk_not_multiple_tables >------------------------|
532: and psl.source_table <> p_source_table;
533: --
534: Begin
535: --
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: l_api_updating := ben_lpl_shd.api_updating
539: (p_ler_per_info_cs_ler_id => p_ler_per_info_cs_ler_id,
540: p_effective_date => p_effective_date,
571: close c_check_multiple;
572: --
573: end if;
574: --
575: hr_utility.set_location('Leaving:'||l_proc,10);
576: --
577: end chk_not_multiple_tables;
578: --
579: -- ----------------------------------------------------------------------------
615: l_integrity_error Exception;
616: l_table_name all_tables.table_name%TYPE;
617: --
618: Begin
619: hr_utility.set_location('Entering:'||l_proc, 5);
620: --
621: -- Ensure that the p_datetrack_mode argument is not null
622: --
623: hr_api.mandatory_arg_error
654: End If;
655: --
656: End If;
657: --
658: hr_utility.set_location(' Leaving:'||l_proc, 10);
659: Exception
660: When l_integrity_error Then
661: --
662: -- A referential integrity check was violated therefore
719: l_rows_exist Exception;
720: l_table_name all_tables.table_name%TYPE;
721: --
722: Begin
723: hr_utility.set_location('Entering:'||l_proc, 5);
724: --
725: -- Ensure that the p_datetrack_mode argument is not null
726: --
727: hr_api.mandatory_arg_error
756: --
757: --
758: End If;
759: --
760: hr_utility.set_location(' Leaving:'||l_proc, 10);
761: Exception
762: When l_rows_exist Then
763: --
764: -- A referential integrity check was violated therefore
788: --
789: l_proc varchar2(72) := g_package||'insert_validate';
790: --
791: Begin
792: hr_utility.set_location('Entering:'||l_proc, 5);
793: --
794: -- Call all supporting business operations
795: --
796: --
833: p_business_group_id => p_rec.business_group_id,
834: p_effective_date => p_effective_date,
835: p_object_version_number => p_rec.object_version_number);
836: --
837: hr_utility.set_location(' Leaving:'||l_proc, 10);
838: End insert_validate;
839: --
840: -- ----------------------------------------------------------------------------
841: -- |---------------------------< update_validate >----------------------------|
849: --
850: l_proc varchar2(72) := g_package||'update_validate';
851: --
852: Begin
853: hr_utility.set_location('Entering:'||l_proc, 5);
854: --
855: -- Call all supporting business operations
856: --
857: --
895: p_datetrack_mode => p_datetrack_mode,
896: p_validation_start_date => p_validation_start_date,
897: p_validation_end_date => p_validation_end_date);
898: --
899: hr_utility.set_location(' Leaving:'||l_proc, 10);
900: End update_validate;
901: --
902: -- ----------------------------------------------------------------------------
903: -- |---------------------------< delete_validate >----------------------------|
911: --
912: l_proc varchar2(72) := g_package||'delete_validate';
913: --
914: Begin
915: hr_utility.set_location('Entering:'||l_proc, 5);
916: --
917: -- Call all supporting business operations
918: --
919: dt_delete_validate
921: p_validation_start_date => p_validation_start_date,
922: p_validation_end_date => p_validation_end_date,
923: p_ler_per_info_cs_ler_id => p_rec.ler_per_info_cs_ler_id);
924: --
925: hr_utility.set_location(' Leaving:'||l_proc, 10);
926: End delete_validate;
927: --
928: --
929: -- ---------------------------------------------------------------------------
948: l_proc varchar2(72) := g_package||'return_legislation_code';
949: --
950: begin
951: --
952: hr_utility.set_location('Entering:'|| l_proc, 10);
953: --
954: -- Ensure that all the mandatory parameter are not null
955: --
956: hr_api.mandatory_arg_error(p_api_name => l_proc,
973: end if;
974: --
975: close csr_leg_code;
976: --
977: hr_utility.set_location(' Leaving:'|| l_proc, 20);
978: --
979: return l_legislation_code;
980: --
981: end return_legislation_code;