DBA Data[Home] [Help]

APPS.BEN_LAR_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_lar_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_loa_rsn_rt_id => p_loa_rsn_rt_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_loa_rsn_rt_id;
78: --
79: -- ----------------------------------------------------------------------------

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_lar_shd.api_updating
118: (p_loa_rsn_rt_id => p_loa_rsn_rt_id,
119: p_effective_date => p_effective_date,

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

143: end if;
144: --
145: --
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: end chk_loa_rsn_cd;
150:
151: --

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

209: and p_validation_end_date >= effective_start_date;
210: --
211: BEGIN
212: --
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: l_api_updating := ben_lar_shd.api_updating
216: (p_loa_rsn_rt_id => p_loa_rsn_rt_id,
217: p_effective_date => p_effective_date,

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

238: end if;
239: close c_dup;
240: --
241: end if;
242: hr_utility.set_location('Leaving:'||l_proc,10);
243: --
244: END chk_dup_record;
245:
246: --

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

286: and business_group_id + 0 = p_business_group_id
287: and ordr_num = p_ordr_num;
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
291:
292: --
293: open c1;
294: fetch c1 into l_dummy;

Line 302: hr_utility.set_location('Leaving:'||l_proc, 15);

298: fnd_message.raise_error;
299: end if;
300: close c1;
301: --
302: hr_utility.set_location('Leaving:'||l_proc, 15);
303: End chk_duplicate_ordr_num;
304:
305: -- ----------------------------------------------------------------------------
306: -- |------< chk_excld_flag >------|

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

337: l_api_updating boolean;
338: --
339: Begin
340: --
341: hr_utility.set_location('Entering:'||l_proc, 5);
342: --
343: l_api_updating := ben_lar_shd.api_updating
344: (p_loa_rsn_rt_id => p_loa_rsn_rt_id,
345: p_effective_date => p_effective_date,

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

366: end if;
367: --
368: end if;
369: --
370: hr_utility.set_location('Leaving:'||l_proc,10);
371: --
372: end chk_excld_flag;
373: -- ----------------------------------------------------------------------------
374: -- |------< chk_absence_attendance_type_id>------|

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

412: and abs.business_group_id = p_business_group_id;
413: --
414: Begin
415: --
416: hr_utility.set_location('Entering:'||l_proc,5);
417: --
418: l_api_updating := ben_lar_shd.api_updating
419: (p_loa_rsn_rt_id => p_loa_rsn_rt_id,
420: p_effective_date => p_effective_date,

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

446: close c1;
447: --
448: end if;
449: --
450: hr_utility.set_location('Leaving:'||l_proc,10);
451: --
452: End chk_absence_attendance_type_id;
453: --
454: -- ----------------------------------------------------------------------------

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

493: and abr.business_group_id = p_business_group_id;
494: --
495: Begin
496: --
497: hr_utility.set_location('Entering:'||l_proc,5);
498: --
499: l_api_updating := ben_lar_shd.api_updating
500: (p_loa_rsn_rt_id => p_loa_rsn_rt_id,
501: p_effective_date => p_effective_date,

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

526: close c1;
527: --
528: end if;
529: --
530: hr_utility.set_location('Leaving:'||l_proc,10);
531: --
532: End chk_abs_attendance_reason_id;
533: --
534: --

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

571: l_integrity_error Exception;
572: l_table_name all_tables.table_name%TYPE;
573: --
574: Begin
575: hr_utility.set_location('Entering:'||l_proc, 5);
576: --
577: -- Ensure that the p_datetrack_mode argument is not null
578: --
579: hr_api.mandatory_arg_error

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

611: End If;
612: --
613: End If;
614: --
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: Exception
617: When l_integrity_error Then
618: --
619: -- A referential integrity check was violated therefore

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

676: l_rows_exist Exception;
677: l_table_name all_tables.table_name%TYPE;
678: --
679: Begin
680: hr_utility.set_location('Entering:'||l_proc, 5);
681: --
682: -- Ensure that the p_datetrack_mode argument is not null
683: --
684: hr_api.mandatory_arg_error

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

713: --
714: --
715: End If;
716: --
717: hr_utility.set_location(' Leaving:'||l_proc, 10);
718: Exception
719: When l_rows_exist Then
720: --
721: -- A referential integrity check was violated therefore

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

747: --
748: l_proc varchar2(72) := g_package||'insert_validate';
749: --
750: Begin
751: hr_utility.set_location('Entering:'||l_proc, 5);
752: --
753: -- Call all supporting business operations
754: --
755: --

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

804: ,p_effective_date => p_effective_date
805: ,p_business_group_id => p_rec.business_group_id
806: ,p_loa_rsn_rt_id => p_rec.loa_rsn_rt_id);
807: --
808: hr_utility.set_location(' Leaving:'||l_proc, 10);
809: End insert_validate;
810: --
811: -- ----------------------------------------------------------------------------
812: -- |---------------------------< update_validate >----------------------------|

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

820: --
821: l_proc varchar2(72) := g_package||'update_validate';
822: --
823: Begin
824: hr_utility.set_location('Entering:'||l_proc, 5);
825: --
826: -- Call all supporting business operations
827: --
828: --

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

885: ,p_effective_date => p_effective_date
886: ,p_business_group_id => p_rec.business_group_id
887: ,p_loa_rsn_rt_id => p_rec.loa_rsn_rt_id);
888: --
889: hr_utility.set_location(' Leaving:'||l_proc, 10);
890: End update_validate;
891: --
892: -- ----------------------------------------------------------------------------
893: -- |---------------------------< delete_validate >----------------------------|

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

901: --
902: l_proc varchar2(72) := g_package||'delete_validate';
903: --
904: Begin
905: hr_utility.set_location('Entering:'||l_proc, 5);
906: --
907: -- Call all supporting business operations
908: --
909: dt_delete_validate

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

911: p_validation_start_date => p_validation_start_date,
912: p_validation_end_date => p_validation_end_date,
913: p_loa_rsn_rt_id => p_rec.loa_rsn_rt_id);
914: --
915: hr_utility.set_location(' Leaving:'||l_proc, 10);
916: End delete_validate;
917: --
918: --
919: -- ---------------------------------------------------------------------------

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

938: l_proc varchar2(72) := g_package||'return_legislation_code';
939: --
940: begin
941: --
942: hr_utility.set_location('Entering:'|| l_proc, 10);
943: --
944: -- Ensure that all the mandatory parameter are not null
945: --
946: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

963: end if;
964: --
965: close csr_leg_code;
966: --
967: hr_utility.set_location(' Leaving:'|| l_proc, 20);
968: --
969: return l_legislation_code;
970: --
971: end return_legislation_code;