42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_pbm_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pl_r_oipl_prem_by_mo_id => p_pl_r_oipl_prem_by_mo_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_pl_r_oipl_prem_by_mo_id;
78: --
79: -- ----------------------------------------------------------------------------
111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_pbm_shd.api_updating
118: (p_pl_r_oipl_prem_by_mo_id => p_pl_r_oipl_prem_by_mo_id,
119: p_effective_date => p_effective_date,
142: end if;
143: --
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc,10);
147: --
148: end chk_mnl_adj_flag;
149: --
150: -- |------< chk_uom >------|
184: where currency_code = p_uom;
185: --
186: Begin
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: l_api_updating := ben_pbm_shd.api_updating
191: (p_pl_r_oipl_prem_by_mo_id => p_pl_r_oipl_prem_by_mo_id,
192: p_effective_date => p_effective_date,
215: end if;
216: --
217: end if;
218: --
219: hr_utility.set_location('Leaving:'||l_proc,10);
220: --
221: end chk_uom;
222: -- ----------------------------------------------------------------------------
223: -- ----------------------------------------------------------------------------
259: l_integrity_error Exception;
260: l_table_name all_tables.table_name%TYPE;
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: -- Ensure that the p_datetrack_mode argument is not null
266: --
267: hr_api.mandatory_arg_error
298: End If;
299: --
300: End If;
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 10);
303: Exception
304: When l_integrity_error Then
305: --
306: -- A referential integrity check was violated therefore
363: l_rows_exist Exception;
364: l_table_name all_tables.table_name%TYPE;
365: --
366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: -- Ensure that the p_datetrack_mode argument is not null
370: --
371: hr_api.mandatory_arg_error
400: --
401: --
402: End If;
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 10);
405: Exception
406: When l_rows_exist Then
407: --
408: -- A referential integrity check was violated therefore
432: --
433: l_proc varchar2(72) := g_package||'insert_validate';
434: --
435: Begin
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: -- Call all supporting business operations
439: --
440: --
456: p_uom => p_rec.uom,
457: p_effective_date => p_effective_date,
458: p_object_version_number => p_rec.object_version_number);
459: --
460: hr_utility.set_location(' Leaving:'||l_proc, 10);
461: End insert_validate;
462: --
463: -- ----------------------------------------------------------------------------
464: -- |---------------------------< update_validate >----------------------------|
472: --
473: l_proc varchar2(72) := g_package||'update_validate';
474: --
475: Begin
476: hr_utility.set_location('Entering:'||l_proc, 5);
477: --
478: -- Call all supporting business operations
479: --
480: --
504: p_datetrack_mode => p_datetrack_mode,
505: p_validation_start_date => p_validation_start_date,
506: p_validation_end_date => p_validation_end_date);
507: --
508: hr_utility.set_location(' Leaving:'||l_proc, 10);
509: End update_validate;
510: --
511: -- ----------------------------------------------------------------------------
512: -- |---------------------------< delete_validate >----------------------------|
520: --
521: l_proc varchar2(72) := g_package||'delete_validate';
522: --
523: Begin
524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: -- Call all supporting business operations
527: --
528: dt_delete_validate
530: p_validation_start_date => p_validation_start_date,
531: p_validation_end_date => p_validation_end_date,
532: p_pl_r_oipl_prem_by_mo_id => p_rec.pl_r_oipl_prem_by_mo_id);
533: --
534: hr_utility.set_location(' Leaving:'||l_proc, 10);
535: End delete_validate;
536: --
537: --
538: -- ---------------------------------------------------------------------------
557: l_proc varchar2(72) := g_package||'return_legislation_code';
558: --
559: begin
560: --
561: hr_utility.set_location('Entering:'|| l_proc, 10);
562: --
563: -- Ensure that all the mandatory parameter are not null
564: --
565: hr_api.mandatory_arg_error(p_api_name => l_proc,
582: end if;
583: --
584: close csr_leg_code;
585: --
586: hr_utility.set_location(' Leaving:'|| l_proc, 20);
587: --
588: return l_legislation_code;
589: --
590: end return_legislation_code;