DBA Data[Home] [Help]

APPS.BEN_LPL_BUS dependencies on HR_UTILITY

Line 46: hr_utility.set_location('Entering:'||l_proc, 5);

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,

Line 76: hr_utility.set_location('Leaving:'||l_proc, 10);

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: -- ----------------------------------------------------------------------------

Line 145: hr_utility.set_location('Entering:'||l_proc,5);

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;

Line 194: hr_utility.set_location('Leaving:'||l_proc,10);

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: -- ----------------------------------------------------------------------------

Line 249: hr_utility.set_location('Entering:'||l_proc, 5);

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,

Line 285: hr_utility.set_location('Leaving:'||l_proc,10);

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 >------|

Line 340: hr_utility.set_location('Entering:'||l_proc,5);

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

Line 356: hr_utility.set_location('Leaving:'||l_proc,10);

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: -- ----------------------------------------------------------------------------

Line 425: hr_utility.set_location('Entering:'||l_proc,5);

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;

Line 467: hr_utility.set_location('Leaving:'||l_proc,10);

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 >------------------------|

Line 536: hr_utility.set_location('Entering:'||l_proc, 5);

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,

Line 575: hr_utility.set_location('Leaving:'||l_proc,10);

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: -- ----------------------------------------------------------------------------

Line 619: hr_utility.set_location('Entering:'||l_proc, 5);

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

Line 658: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

Line 723: hr_utility.set_location('Entering:'||l_proc, 5);

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

Line 760: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

Line 792: hr_utility.set_location('Entering:'||l_proc, 5);

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: --

Line 837: hr_utility.set_location(' Leaving:'||l_proc, 10);

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 >----------------------------|

Line 853: hr_utility.set_location('Entering:'||l_proc, 5);

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: --

Line 899: hr_utility.set_location(' Leaving:'||l_proc, 10);

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 >----------------------------|

Line 915: hr_utility.set_location('Entering:'||l_proc, 5);

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

Line 925: hr_utility.set_location(' Leaving:'||l_proc, 10);

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: -- ---------------------------------------------------------------------------

Line 952: hr_utility.set_location('Entering:'|| l_proc, 10);

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,

Line 977: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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;