[Home] [Help]
42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_reg_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_regn_id => p_regn_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_regn_id;
78: --
79: -- ----------------------------------------------------------------------------
128: --
129: --
130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_reg_shd.api_updating
135: (p_effective_date => p_effective_date,
136: p_regn_id => p_regn_id,
139: if (l_api_updating
140: and p_name <> ben_reg_shd.g_old_rec.name) or
141: not l_api_updating then
142: --
143: hr_utility.set_location('Entering:'||l_proc, 10);
144: --
145: -- check if this name already exist
146: --
147: open csr_name;
156: end if;
157: --
158: end if;
159: --
160: hr_utility.set_location('Leaving:'||l_proc, 20);
161: --
162: End chk_name;
163: --
164: -- ----------------------------------------------------------------------------
200: l_integrity_error Exception;
201: l_table_name all_tables.table_name%TYPE;
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: -- Ensure that the p_datetrack_mode argument is not null
207: --
208: hr_api.mandatory_arg_error
230: --
231: --
232: End If;
233: --
234: hr_utility.set_location(' Leaving:'||l_proc, 10);
235: Exception
236: When l_integrity_error Then
237: --
238: -- A referential integrity check was violated therefore
297: l_rows_exist Exception;
298: l_table_name all_tables.table_name%TYPE;
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- Ensure that the p_datetrack_mode argument is not null
304: --
305: hr_api.mandatory_arg_error
351: End If;
352: --
353: End If;
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 10);
356: Exception
357: When l_rows_exist Then
358: --
359: -- A referential integrity check was violated therefore
385: --
386: l_proc varchar2(72) := g_package||'insert_validate';
387: --
388: Begin
389: hr_utility.set_location('Entering:'||l_proc, 5);
390: --
391: -- Call all supporting business operations
392: --
393: --
406: p_validation_end_date => p_validation_end_date,
407: p_business_group_id => p_rec.business_group_id,
408: p_object_version_number => p_rec.object_version_number);
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 10);
411: End insert_validate;
412: --
413: -- ----------------------------------------------------------------------------
414: -- |---------------------------< update_validate >----------------------------|
422: --
423: l_proc varchar2(72) := g_package||'update_validate';
424: --
425: Begin
426: hr_utility.set_location('Entering:'||l_proc, 5);
427: --
428: -- Call all supporting business operations
429: --
430: --
452: p_datetrack_mode => p_datetrack_mode,
453: p_validation_start_date => p_validation_start_date,
454: p_validation_end_date => p_validation_end_date);
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: End update_validate;
458: --
459: -- ----------------------------------------------------------------------------
460: -- |---------------------------< delete_validate >----------------------------|
468: --
469: l_proc varchar2(72) := g_package||'delete_validate';
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- Call all supporting business operations
475: --
476: dt_delete_validate
478: p_validation_start_date => p_validation_start_date,
479: p_validation_end_date => p_validation_end_date,
480: p_regn_id => p_rec.regn_id);
481: --
482: hr_utility.set_location(' Leaving:'||l_proc, 10);
483: End delete_validate;
484: --
485: --
486: -- ---------------------------------------------------------------------------
505: l_proc varchar2(72) := g_package||'return_legislation_code';
506: --
507: begin
508: --
509: hr_utility.set_location('Entering:'|| l_proc, 10);
510: --
511: -- Ensure that all the mandatory parameter are not null
512: --
513: hr_api.mandatory_arg_error(p_api_name => l_proc,
530: end if;
531: --
532: close csr_leg_code;
533: --
534: hr_utility.set_location(' Leaving:'|| l_proc, 20);
535: --
536: return l_legislation_code;
537: --
538: end return_legislation_code;