DBA Data[Home] [Help]

APPS.BEN_BLI_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_bli_shd.api_updating
47: (p_batch_ler_id => p_batch_ler_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_batch_ler_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_bli_shd.api_updating
124: (p_batch_ler_id => p_batch_ler_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_ler_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_bli_shd.api_updating
204: (p_batch_ler_id => p_batch_ler_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_person_id;
235: --
236: -- ----------------------------------------------------------------------------

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

272: where a.benefit_action_id = p_benefit_action_id;
273: --
274: Begin
275: --
276: hr_utility.set_location('Entering:'||l_proc,5);
277: --
278: l_api_updating := ben_bli_shd.api_updating
279: (p_batch_ler_id => p_batch_ler_id,
280: p_object_version_number => p_object_version_number);

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

303: close c1;
304: --
305: end if;
306: --
307: hr_utility.set_location('Leaving:'||l_proc,10);
308: --
309: End chk_benefit_action_id;
310: --
311: -- ----------------------------------------------------------------------------

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

343: l_api_updating boolean;
344: --
345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: l_api_updating := ben_bli_shd.api_updating
350: (p_batch_ler_id => p_batch_ler_id,
351: p_object_version_number => p_object_version_number);

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

373: end if;
374: --
375: end if;
376: --
377: hr_utility.set_location('Leaving:'||l_proc,10);
378: --
379: end chk_dltd_flag;
380: --
381: -- ----------------------------------------------------------------------------

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

413: l_api_updating boolean;
414: --
415: Begin
416: --
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: l_api_updating := ben_bli_shd.api_updating
420: (p_batch_ler_id => p_batch_ler_id,
421: p_object_version_number => p_object_version_number);

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

443: end if;
444: --
445: end if;
446: --
447: hr_utility.set_location('Leaving:'||l_proc,10);
448: --
449: end chk_tmprl_flag;
450: --
451: -- ----------------------------------------------------------------------------

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

483: l_api_updating boolean;
484: --
485: Begin
486: --
487: hr_utility.set_location('Entering:'||l_proc, 5);
488: --
489: l_api_updating := ben_bli_shd.api_updating
490: (p_batch_ler_id => p_batch_ler_id,
491: p_object_version_number => p_object_version_number);

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

513: end if;
514: --
515: end if;
516: --
517: hr_utility.set_location('Leaving:'||l_proc,10);
518: --
519: end chk_crtd_flag;
520: --
521: -- ----------------------------------------------------------------------------

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

553: l_api_updating boolean;
554: --
555: Begin
556: --
557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: l_api_updating := ben_bli_shd.api_updating
560: (p_batch_ler_id => p_batch_ler_id,
561: p_object_version_number => p_object_version_number);

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

583: end if;
584: --
585: end if;
586: --
587: hr_utility.set_location('Leaving:'||l_proc,10);
588: --
589: end chk_clpsd_flag;
590: -- ----------------------------------------------------------------------------
591: -- |--------------------------< chk_clsn_flag >-------------------------------|

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

622: l_api_updating boolean;
623: --
624: Begin
625: --
626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: l_api_updating := ben_bli_shd.api_updating
629: (p_batch_ler_id => p_batch_ler_id,
630: p_object_version_number => p_object_version_number);

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

652: end if;
653: --
654: end if;
655: --
656: hr_utility.set_location('Leaving:'||l_proc,10);
657: --
658: end chk_clsn_flag;
659: -- ----------------------------------------------------------------------------
660: -- |--------------------------< chk_no_effect_flag >--------------------------|

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

691: l_api_updating boolean;
692: --
693: Begin
694: --
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: --
697: l_api_updating := ben_bli_shd.api_updating
698: (p_batch_ler_id => p_batch_ler_id,
699: p_object_version_number => p_object_version_number);

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

721: end if;
722: --
723: end if;
724: --
725: hr_utility.set_location('Leaving:'||l_proc,10);
726: --
727: end chk_no_effect_flag;
728: -- ----------------------------------------------------------------------------
729: -- |--------------------------< chk_cvrge_rt_prem_flag >----------------------|

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

760: l_api_updating boolean;
761: --
762: Begin
763: --
764: hr_utility.set_location('Entering:'||l_proc, 5);
765: --
766: l_api_updating := ben_bli_shd.api_updating
767: (p_batch_ler_id => p_batch_ler_id,
768: p_object_version_number => p_object_version_number);

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

790: end if;
791: --
792: end if;
793: --
794: hr_utility.set_location('Leaving:'||l_proc,10);
795: --
796: end chk_cvrge_rt_prem_flag;
797: -- ----------------------------------------------------------------------------
798: -- |----------------------------< chk_replcd_flag >---------------------------|

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

829: l_api_updating boolean;
830: --
831: Begin
832: --
833: hr_utility.set_location('Entering:'||l_proc, 5);
834: --
835: l_api_updating := ben_bli_shd.api_updating
836: (p_batch_ler_id => p_batch_ler_id,
837: p_object_version_number => p_object_version_number);

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

859: end if;
860: --
861: end if;
862: --
863: hr_utility.set_location('Leaving:'||l_proc,10);
864: --
865: end chk_replcd_flag;
866: --
867: -- ----------------------------------------------------------------------------

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

899: l_api_updating boolean;
900: --
901: Begin
902: --
903: hr_utility.set_location('Entering:'||l_proc, 5);
904: --
905: l_api_updating := ben_bli_shd.api_updating
906: (p_batch_ler_id => p_batch_ler_id,
907: p_object_version_number => p_object_version_number);

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

929: end if;
930: --
931: end if;
932: --
933: hr_utility.set_location('Leaving:'||l_proc,10);
934: --
935: end chk_open_and_clsd_flag;
936: -- ----------------------------------------------------------------------------
937: -- |----------------------------< chk_clsd_flag >-----------------------------|

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

968: l_api_updating boolean;
969: --
970: Begin
971: --
972: hr_utility.set_location('Entering:'||l_proc, 5);
973: --
974: l_api_updating := ben_bli_shd.api_updating
975: (p_batch_ler_id => p_batch_ler_id,
976: p_object_version_number => p_object_version_number);

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

998: end if;
999: --
1000: end if;
1001: --
1002: hr_utility.set_location('Leaving:'||l_proc,10);
1003: --
1004: end chk_clsd_flag;
1005: -- ----------------------------------------------------------------------------
1006: -- |----------------------------< chk_not_crtd_flag >-------------------------|

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

1037: l_api_updating boolean;
1038: --
1039: Begin
1040: --
1041: hr_utility.set_location('Entering:'||l_proc, 5);
1042: --
1043: l_api_updating := ben_bli_shd.api_updating
1044: (p_batch_ler_id => p_batch_ler_id,
1045: p_object_version_number => p_object_version_number);

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

1067: end if;
1068: --
1069: end if;
1070: --
1071: hr_utility.set_location('Leaving:'||l_proc,10);
1072: --
1073: end chk_not_crtd_flag;
1074: -- ----------------------------------------------------------------------------
1075: -- |----------------------------< chk_stl_actv_flag >-------------------------|

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

1106: l_api_updating boolean;
1107: --
1108: Begin
1109: --
1110: hr_utility.set_location('Entering:'||l_proc, 5);
1111: --
1112: l_api_updating := ben_bli_shd.api_updating
1113: (p_batch_ler_id => p_batch_ler_id,
1114: p_object_version_number => p_object_version_number);

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

1136: end if;
1137: --
1138: end if;
1139: --
1140: hr_utility.set_location('Leaving:'||l_proc,10);
1141: --
1142: end chk_stl_actv_flag;
1143: -- ----------------------------------------------------------------------------
1144: -- |---------------------------< insert_validate >----------------------------|

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

1148: --
1149: l_proc varchar2(72) := g_package||'insert_validate';
1150: --
1151: Begin
1152: hr_utility.set_location('Entering:'||l_proc, 5);
1153: --
1154: -- Call all supporting business operations
1155: --
1156: --

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

1248: p_cvrge_rt_prem_flag => p_rec.cvrge_rt_prem_flag,
1249: p_effective_date => p_effective_date,
1250: p_object_version_number => p_rec.object_version_number);
1251: --
1252: hr_utility.set_location(' Leaving:'||l_proc, 10);
1253: End insert_validate;
1254: --
1255: -- ----------------------------------------------------------------------------
1256: -- |---------------------------< update_validate >----------------------------|

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

1260: --
1261: l_proc varchar2(72) := g_package||'update_validate';
1262: --
1263: Begin
1264: hr_utility.set_location('Entering:'||l_proc, 5);
1265: --
1266: -- Call all supporting business operations
1267: --
1268: --

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

1360: p_cvrge_rt_prem_flag => p_rec.cvrge_rt_prem_flag,
1361: p_effective_date => p_effective_date,
1362: p_object_version_number => p_rec.object_version_number);
1363: --
1364: hr_utility.set_location(' Leaving:'||l_proc, 10);
1365: End update_validate;
1366: --
1367: -- ----------------------------------------------------------------------------
1368: -- |---------------------------< delete_validate >----------------------------|

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

1372: --
1373: l_proc varchar2(72) := g_package||'delete_validate';
1374: --
1375: Begin
1376: hr_utility.set_location('Entering:'||l_proc, 5);
1377: --
1378: -- Call all supporting business operations
1379: --
1380: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1376: hr_utility.set_location('Entering:'||l_proc, 5);
1377: --
1378: -- Call all supporting business operations
1379: --
1380: hr_utility.set_location(' Leaving:'||l_proc, 10);
1381: End delete_validate;
1382: --
1383: -- ---------------------------------------------------------------------------
1384: -- |---------------------< return_legislation_code >-------------------------|

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

1402: l_proc varchar2(72) := g_package||'return_legislation_code';
1403: --
1404: begin
1405: --
1406: hr_utility.set_location('Entering:'|| l_proc, 10);
1407: --
1408: -- Ensure that all the mandatory parameter are not null
1409: --
1410: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1424: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

1420: close csr_leg_code;
1421: --
1422: -- The primary key is invalid therefore we must error
1423: --
1424: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1425: hr_utility.raise_error;
1426: --
1427: end if;
1428: --

Line 1425: hr_utility.raise_error;

1421: --
1422: -- The primary key is invalid therefore we must error
1423: --
1424: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1425: hr_utility.raise_error;
1426: --
1427: end if;
1428: --
1429: close csr_leg_code;

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

1427: end if;
1428: --
1429: close csr_leg_code;
1430: --
1431: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1432: --
1433: return l_legislation_code;
1434: --
1435: end return_legislation_code;