DBA Data[Home] [Help]

APPS.BEN_PRV_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_prv_shd.api_updating
47: (p_prtt_rt_val_id => p_prtt_rt_val_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_prtt_rt_val_id;
75: --
76: -- ----------------------------------------------------------------------------

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

117: and a.effective_end_date;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_prv_shd.api_updating
124: (p_prtt_rt_val_id => p_prtt_rt_val_id,
125: p_object_version_number => p_object_version_number);

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

148: close c1;
149: --
150: end if;
151: --
152: hr_utility.set_location('Leaving:'||l_proc,10);
153: --
154: End chk_prtt_enrt_rslt_id;
155: --
156: -- ----------------------------------------------------------------------------

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

197: and a.effective_end_date;
198: --
199: Begin
200: --
201: hr_utility.set_location('Entering:'||l_proc,5);
202: --
203: l_api_updating := ben_prv_shd.api_updating
204: (p_prtt_rt_val_id => p_prtt_rt_val_id,
205: p_object_version_number => p_object_version_number);

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

228: close c1;
229: --
230: end if;
231: --
232: hr_utility.set_location('Leaving:'||l_proc,10);
233: --
234: End chk_element_entry_value_id;
235: --
236: -- ----------------------------------------------------------------------------

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

268: l_api_updating boolean;
269: --
270: Begin
271: --
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: l_api_updating := ben_prv_shd.api_updating
275: (p_prtt_rt_val_id => p_prtt_rt_val_id,
276: p_object_version_number => p_object_version_number);

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

298: end if;
299: --
300: end if;
301: --
302: hr_utility.set_location('Leaving:'||l_proc,10);
303: --
304: end chk_cmcd_ref_perd_cd;
305: -- ----------------------------------------------------------------------------
306: -- |------< chk_prtt_rt_val_stat_cd >------|

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_prv_shd.api_updating
344: (p_prtt_rt_val_id => p_prtt_rt_val_id,
345: p_object_version_number => p_object_version_number);

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

367: end if;
368: --
369: end if;
370: --
371: hr_utility.set_location('Leaving:'||l_proc,10);
372: --
373: end chk_prtt_rt_val_stat_cd;
374: --
375: -- ----------------------------------------------------------------------------

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

407: l_api_updating boolean;
408: --
409: Begin
410: --
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: l_api_updating := ben_prv_shd.api_updating
414: (p_prtt_rt_val_id => p_prtt_rt_val_id,
415: p_object_version_number => p_object_version_number);

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

437: end if;
438: --
439: end if;
440: --
441: hr_utility.set_location('Leaving:'||l_proc,10);
442: --
443: end chk_bnft_rt_typ_cd;
444: --
445: -- ----------------------------------------------------------------------------

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

477: l_api_updating boolean;
478: --
479: Begin
480: --
481: hr_utility.set_location('Entering:'||l_proc, 5);
482: --
483: l_api_updating := ben_prv_shd.api_updating
484: (p_prtt_rt_val_id => p_prtt_rt_val_id,
485: p_object_version_number => p_object_version_number);

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

507: end if;
508: --
509: end if;
510: --
511: hr_utility.set_location('Leaving:'||l_proc,10);
512: --
513: end chk_acty_ref_perd_cd;
514: --
515: -- ----------------------------------------------------------------------------

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

547: l_api_updating boolean;
548: --
549: Begin
550: --
551: hr_utility.set_location('Entering:'||l_proc, 5);
552: --
553: l_api_updating := ben_prv_shd.api_updating
554: (p_prtt_rt_val_id => p_prtt_rt_val_id,
555: p_object_version_number => p_object_version_number);

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

577: end if;
578: --
579: end if;
580: --
581: hr_utility.set_location('Leaving:'||l_proc,10);
582: --
583: end chk_mlt_cd;
584: --
585: -- ----------------------------------------------------------------------------

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

617: l_api_updating boolean;
618: --
619: Begin
620: --
621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623: l_api_updating := ben_prv_shd.api_updating
624: (p_prtt_rt_val_id => p_prtt_rt_val_id,
625: p_object_version_number => p_object_version_number);

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

647: end if;
648: --
649: end if;
650: --
651: hr_utility.set_location('Leaving:'||l_proc,10);
652: --
653: end chk_acty_typ_cd;
654: --
655: -- ----------------------------------------------------------------------------

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

687: l_api_updating boolean;
688: --
689: Begin
690: --
691: hr_utility.set_location('Entering:'||l_proc, 5);
692: --
693: l_api_updating := ben_prv_shd.api_updating
694: (p_prtt_rt_val_id => p_prtt_rt_val_id,
695: p_object_version_number => p_object_version_number);

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

717: end if;
718: --
719: end if;
720: --
721: hr_utility.set_location('Leaving:'||l_proc,10);
722: --
723: end chk_tx_typ_cd;
724: --
725: -- ----------------------------------------------------------------------------

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

757: l_api_updating boolean;
758: --
759: Begin
760: --
761: hr_utility.set_location('Entering:'||l_proc, 5);
762: --
763: l_api_updating := ben_prv_shd.api_updating
764: (p_prtt_rt_val_id => p_prtt_rt_val_id,
765: p_object_version_number => p_object_version_number);

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

787: end if;
788: --
789: end if;
790: --
791: hr_utility.set_location('Leaving:'||l_proc,10);
792: --
793: end chk_rt_typ_cd;
794: --
795: -- ----------------------------------------------------------------------------

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

827: l_api_updating boolean;
828: --
829: Begin
830: --
831: hr_utility.set_location('Entering:'||l_proc, 5);
832: --
833: l_api_updating := ben_prv_shd.api_updating
834: (p_prtt_rt_val_id => p_prtt_rt_val_id,
835: p_object_version_number => p_object_version_number);

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

857: end if;
858: --
859: end if;
860: --
861: hr_utility.set_location('Leaving:'||l_proc,10);
862: --
863: end chk_rt_ovridn_flag;
864: --
865: -- ----------------------------------------------------------------------------

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

897: l_api_updating boolean;
898: --
899: Begin
900: --
901: hr_utility.set_location('Entering:'||l_proc, 5);
902: --
903: l_api_updating := ben_prv_shd.api_updating
904: (p_prtt_rt_val_id => p_prtt_rt_val_id,
905: p_object_version_number => p_object_version_number);

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

927: end if;
928: --
929: end if;
930: --
931: hr_utility.set_location('Leaving:'||l_proc,10);
932: --
933: end chk_dsply_on_enrt_flag;
934:
935: --

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

1023: l_clm_balance number := 0;
1024: l_elig_per_elctbl_chc_id number :=0;
1025: Begin
1026: --
1027: hr_utility.set_location('Entering:'||l_proc, 5);
1028: --
1029: l_api_updating := ben_prv_shd.api_updating
1030: (p_prtt_rt_val_id => p_prtt_rt_val_id,
1031: p_object_version_number => p_object_version_number);

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

1165: END IF;
1166: End if;
1167: End if;
1168: --
1169: hr_utility.set_location('Leaving:'||l_proc,10);
1170: --
1171: end chk_ann_min_max_val;
1172: -- ----------------------------------------------------------------------------
1173: -- |------< chk_min_max_incrt_val >------|

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

1271: l_elig_per_elctbl_chc_id number :=0;
1272:
1273: Begin
1274: --
1275: hr_utility.set_location('Entering:'||l_proc, 5);
1276: --
1277: l_api_updating := ben_prv_shd.api_updating
1278: (p_prtt_rt_val_id => p_prtt_rt_val_id,
1279: p_object_version_number => p_object_version_number);

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

1405: end if;
1406: --
1407: end if;
1408:
1409: hr_utility.set_location('Leaving:'||l_proc,10);
1410:
1411: end chk_min_max_incrt_val;
1412: --
1413: -- ----------------------------------------------------------------------------

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

1452: and p_effective_date between effective_start_date
1453: and effective_end_date;
1454: Begin
1455: --
1456: hr_utility.set_location('Entering:'||l_proc, 5);
1457: --
1458: l_api_updating := ben_prv_shd.api_updating
1459: (p_prtt_rt_val_id => p_prtt_rt_val_id,
1460: p_object_version_number => p_object_version_number);

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

1481: fnd_message.raise_error;
1482: end if;
1483: end if;
1484: --
1485: hr_utility.set_location('Leaving:'||l_proc,10);
1486: --
1487: end chk_acty_base_rt_id;
1488: --
1489: /*--Bug#5088571

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

1510: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
1511: --
1512: Begin
1513: --
1514: hr_utility.set_location('Entering:'||l_proc, 5);
1515: --
1516: open c_person_id;
1517: fetch c_person_id into l_person_id;
1518: close c_person_id;

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

1527: ,p_person_id => l_person_id
1528: );
1529: end if;
1530: --
1531: hr_utility.set_location('Leaving:'||l_proc,10);
1532: --
1533: end chk_rt_strt_end_dt;
1534: --
1535: --Bug#5088571 */

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

1543: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
1544: l_effective_date date;
1545:
1546: Begin
1547: hr_utility.set_location('Entering:'||l_proc, 5);
1548: --
1549: -- Call context sensitive validate bgp cache routine
1550: --
1551: ben_batch_dt_api.batch_validate_bgp_id

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

1663: p_rt_end_dt => p_rec.rt_end_dt,
1664: p_prtt_enrt_rslt_id => p_rec.prtt_enrt_rslt_id
1665: );*/
1666: --
1667: hr_utility.set_location(' Leaving:'||l_proc, 10);
1668: End insert_validate;
1669:
1670: -- ----------------------------------------------------------------------------
1671: -- |---------------------------< update_validate >----------------------------|

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

1677: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
1678: l_effective_date date;
1679:
1680: Begin
1681: hr_utility.set_location('Entering:'||l_proc, 5);
1682: --
1683: -- Call context sensitive validate bgp cache routine
1684: --
1685: ben_batch_dt_api.batch_validate_bgp_id

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

1795: p_rt_end_dt => p_rec.rt_end_dt,
1796: p_prtt_enrt_rslt_id => p_rec.prtt_enrt_rslt_id
1797: );*/
1798: --
1799: hr_utility.set_location(' Leaving:'||l_proc, 10);
1800: End update_validate;
1801:
1802: -- ----------------------------------------------------------------------------
1803: -- |---------------------------< delete_validate >----------------------------|

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

1806: --
1807: l_proc varchar2(72) := g_package||'delete_validate';
1808: --
1809: Begin
1810: hr_utility.set_location('Entering:'||l_proc, 5);
1811: --
1812: -- Call all supporting business operations
1813: --
1814: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1810: hr_utility.set_location('Entering:'||l_proc, 5);
1811: --
1812: -- Call all supporting business operations
1813: --
1814: hr_utility.set_location(' Leaving:'||l_proc, 10);
1815: End delete_validate;
1816: --
1817: -- ---------------------------------------------------------------------------
1818: -- |---------------------< return_legislation_code >-------------------------|

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

1836: l_proc varchar2(72) := g_package||'return_legislation_code';
1837: --
1838: begin
1839: --
1840: hr_utility.set_location('Entering:'|| l_proc, 10);
1841: --
1842: -- Ensure that all the mandatory parameter are not null
1843: --
1844: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1861: end if;
1862: --
1863: close csr_leg_code;
1864: --
1865: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1866: --
1867: return l_legislation_code;
1868: --
1869: end return_legislation_code;