DBA Data[Home] [Help]

APPS.BEN_PRG_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_prg_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pl_regn_id => p_pl_regn_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_pl_regn_id;
78:
79: -- ----------------------------------------------------------------------------

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

120: and nvl(bnr.business_group_id,p_business_group_id) <> p_business_group_id ;
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc,5);
125: --
126: -- check if rptg_grp_id value exists in ben_rptg_grp table
127: --
128: open c1;

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

140: --
141: close c1;
142: --
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: End chk_parent_rec_exists;
147: --
148:

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

187: where a.rptg_grp_id = p_rptg_grp_id;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := ben_prg_shd.api_updating
194: (p_pl_regn_id => p_pl_regn_id,
195: p_effective_date => p_effective_date,

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

219: close c1;
220: --
221: end if;
222: --
223: hr_utility.set_location('Leaving:'||l_proc,10);
224: --
225: End chk_rptg_grp_id;
226: -- ----------------------------------------------------------------------------
227: -- |--------------------< chk_hghly_compd_det_rl >----------------------------|

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

275: and ff.effective_end_date;
276: --
277: Begin
278: --
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: l_api_updating := ben_prg_shd.api_updating
282: (p_pl_regn_id => p_pl_regn_id ,
283: p_effective_date => p_effective_date,

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

311: close c1;
312: --
313: end if;
314: --
315: hr_utility.set_location('Leaving:'||l_proc,10);
316: --
317: end chk_hghly_compd_det_rl ;
318: -- ----------------------------------------------------------------------------
319: -- |--------------------< chk_key_ee_det_rl >---------------------------------|

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

367: and ff.effective_end_date;
368: --
369: Begin
370: --
371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: l_api_updating := ben_prg_shd.api_updating
374: (p_pl_regn_id => p_pl_regn_id,
375: p_effective_date => p_effective_date,

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

403: close c1;
404: --
405: end if;
406: --
407: hr_utility.set_location('Leaving:'||l_proc,10);
408: --
409: end chk_key_ee_det_rl;
410: -- ----------------------------------------------------------------------------
411: -- |--------------------< chk_cntr_nndscrn_rl >-------------------------------|

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

459: and ff.effective_end_date;
460: --
461: Begin
462: --
463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: l_api_updating := ben_prg_shd.api_updating
466: (p_pl_regn_id => p_pl_regn_id,
467: p_effective_date => p_effective_date,

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

495: close c1;
496: --
497: end if;
498: --
499: hr_utility.set_location('Leaving:'||l_proc,10);
500: --
501: end chk_cntr_nndscrn_rl ;
502: -- ----------------------------------------------------------------------------
503: -- |--------------------< chk_cvg_nndscrn_rl >--------------------------------|

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

551: and ff.effective_end_date;
552: --
553: Begin
554: --
555: hr_utility.set_location('Entering:'||l_proc, 5);
556: --
557: l_api_updating := ben_prg_shd.api_updating
558: (p_pl_regn_id => p_pl_regn_id ,
559: p_effective_date => p_effective_date,

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

587: close c1;
588: --
589: end if;
590: --
591: hr_utility.set_location('Leaving:'||l_proc,10);
592: --
593: end chk_cvg_nndscrn_rl;
594: -- ----------------------------------------------------------------------------
595: -- |--------------------< chk_five_pct_ownr_rl >------------------------------|

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

643: and ff.effective_end_date;
644: --
645: Begin
646: --
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: l_api_updating := ben_prg_shd.api_updating
650: (p_pl_regn_id => p_pl_regn_id,
651: p_effective_date => p_effective_date,

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

679: close c1;
680: --
681: end if;
682: --
683: hr_utility.set_location('Leaving:'||l_proc,10);
684: --
685: end chk_five_pct_ownr_rl;
686:
687: -- ----------------------------------------------------------------------------

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

719: l_api_updating boolean;
720: --
721: Begin
722: --
723: hr_utility.set_location('Entering:'||l_proc, 5);
724: --
725: l_api_updating := ben_prg_shd.api_updating
726: (p_pl_regn_id => p_pl_regn_id,
727: p_effective_date => p_effective_date,

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

747: end if;
748: --
749: end if;
750: --
751: hr_utility.set_location('Leaving:'||l_proc,10);
752: --
753: end chk_regy_pl_typ_cd;
754:
755: -- ----------------------------------------------------------------------------

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

797: l_integrity_error Exception;
798: l_table_name all_tables.table_name%TYPE;
799: --
800: Begin
801: hr_utility.set_location('Entering:'||l_proc, 5);
802: --
803: -- Ensure that the p_datetrack_mode argument is not null
804: --
805: hr_api.mandatory_arg_error

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

896: End If;
897: --
898: End If;
899: --
900: hr_utility.set_location(' Leaving:'||l_proc, 10);
901: Exception
902: When l_integrity_error Then
903: --
904: -- A referential integrity check was violated therefore

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

963: l_rows_exist Exception;
964: l_table_name all_tables.table_name%TYPE;
965: --
966: Begin
967: hr_utility.set_location('Entering:'||l_proc, 5);
968: --
969: -- Ensure that the p_datetrack_mode argument is not null
970: --
971: hr_api.mandatory_arg_error

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

1000: --
1001: --
1002: End If;
1003: --
1004: hr_utility.set_location(' Leaving:'||l_proc, 10);
1005: Exception
1006: When l_rows_exist Then
1007: --
1008: -- A referential integrity check was violated therefore

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

1034: --
1035: l_proc varchar2(72) := g_package||'insert_validate';
1036: --
1037: Begin
1038: hr_utility.set_location('Entering:'||l_proc, 5);
1039: --
1040: -- Call all supporting business operations
1041: --
1042: --CWB Changes

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

1110: p_effective_date => p_effective_date,
1111: p_object_version_number => p_rec.object_version_number);
1112:
1113: --
1114: hr_utility.set_location(' Leaving:'||l_proc, 10);
1115: End insert_validate;
1116: --
1117: -- ----------------------------------------------------------------------------
1118: -- |---------------------------< update_validate >----------------------------|

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

1126: --
1127: l_proc varchar2(72) := g_package||'update_validate';
1128: --
1129: Begin
1130: hr_utility.set_location('Entering:'||l_proc, 5);
1131: --
1132: -- Call all supporting business operations
1133: --
1134: -- CWB Changes

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

1215: p_datetrack_mode => p_datetrack_mode,
1216: p_validation_start_date => p_validation_start_date,
1217: p_validation_end_date => p_validation_end_date);
1218: --
1219: hr_utility.set_location(' Leaving:'||l_proc, 10);
1220: End update_validate;
1221: --
1222: -- ----------------------------------------------------------------------------
1223: -- |---------------------------< delete_validate >----------------------------|

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

1231: --
1232: l_proc varchar2(72) := g_package||'delete_validate';
1233: --
1234: Begin
1235: hr_utility.set_location('Entering:'||l_proc, 5);
1236: --
1237: -- Call all supporting business operations
1238: --
1239: dt_delete_validate

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

1241: p_validation_start_date => p_validation_start_date,
1242: p_validation_end_date => p_validation_end_date,
1243: p_pl_regn_id => p_rec.pl_regn_id);
1244: --
1245: hr_utility.set_location(' Leaving:'||l_proc, 10);
1246: End delete_validate;
1247: -- ---------------------------------------------------------------------------
1248: -- |---------------------< return_legislation_code >-------------------------|
1249: -- ---------------------------------------------------------------------------

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

1266: l_proc varchar2(72) := g_package||'return_legislation_code';
1267: --
1268: begin
1269: --
1270: hr_utility.set_location('Entering:'|| l_proc, 10);
1271: --
1272: -- Ensure that all the mandatory parameter are not null
1273: --
1274: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1293: --
1294: */
1295: close csr_leg_code;
1296: --
1297: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1298: --
1299: return l_legislation_code;
1300: --
1301: end return_legislation_code;