[Home] [Help]
43: l_api_updating boolean;
44: --
45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_esp_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_elig_sp_clng_prg_prte_id => p_elig_sp_clng_prg_prte_id,
72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_elig_sp_clng_prg_prte_id;
79: --
80: -- ----------------------------------------------------------------------------
112: l_api_updating boolean;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_esp_shd.api_updating
119: (p_elig_sp_clng_prg_prte_id => p_elig_sp_clng_prg_prte_id,
120: p_effective_date => p_effective_date,
141: end if;
142: --
143: end if;
144: --
145: hr_utility.set_location('Leaving:'||l_proc,10);
146: --
147: end chk_excld_flag;
148:
149:
162: ldummy varchar2(1) ;
163: --
164: Begin
165: --
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: --
168: l_api_updating := ben_esp_shd.api_updating
169: (p_elig_sp_clng_prg_prte_id => p_elig_sp_clng_prg_prte_id,
170: p_effective_date => p_effective_date,
177: --
178: -- check if value of lookup falls within lookup type.
179: --
180: --
181: hr_utility.set_location(' updating' ,99);
182:
183: open psps ;
184: fetch psps into ldummy ;
185: if psps%notfound then
193: --
194: --
195: end if;
196: --
197: hr_utility.set_location('Leaving:'||l_proc,10);
198: --
199: end chk_special_ceiling_step_id;
200: --
201: -- ----------------------------------------------------------------------------
239: l_integrity_error Exception;
240: l_table_name all_tables.table_name%TYPE;
241: --
242: Begin
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: -- Ensure that the p_datetrack_mode argument is not null
246: --
247: hr_api.mandatory_arg_error
288: End If;
289: --
290: End If;
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: Exception
294: When l_integrity_error Then
295: --
296: -- A referential integrity check was violated therefore
353: l_rows_exist Exception;
354: l_table_name all_tables.table_name%TYPE;
355: --
356: Begin
357: hr_utility.set_location('Entering:'||l_proc, 5);
358: --
359: -- Ensure that the p_datetrack_mode argument is not null
360: --
361: hr_api.mandatory_arg_error
390: --
391: --
392: End If;
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 10);
395: Exception
396: When l_rows_exist Then
397: --
398: -- A referential integrity check was violated therefore
422: --
423: l_proc varchar2(72) := g_package||'insert_validate';
424: --
425: Begin
426: hr_utility.set_location('Entering:'||l_proc, 5);
427: --
428: -- Call all supporting business operations
429: --
430: chk_elig_sp_clng_prg_prte_id
445:
446: --
447: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 10);
450: End insert_validate;
451: --
452: -- ----------------------------------------------------------------------------
453: -- |---------------------------< update_validate >----------------------------|
461: --
462: l_proc varchar2(72) := g_package||'update_validate';
463: --
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: -- Call all supporting business operations
468: --
469: chk_elig_sp_clng_prg_prte_id
494: p_datetrack_mode => p_datetrack_mode,
495: p_validation_start_date => p_validation_start_date,
496: p_validation_end_date => p_validation_end_date);
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 10);
499: End update_validate;
500: --
501: -- ----------------------------------------------------------------------------
502: -- |---------------------------< delete_validate >----------------------------|
510: --
511: l_proc varchar2(72) := g_package||'delete_validate';
512: --
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: -- Call all supporting business operations
517: --
518: dt_delete_validate
520: p_validation_start_date => p_validation_start_date,
521: p_validation_end_date => p_validation_end_date,
522: p_elig_sp_clng_prg_prte_id => p_rec.elig_sp_clng_prg_prte_id);
523: --
524: hr_utility.set_location(' Leaving:'||l_proc, 10);
525: End delete_validate;
526: --
527: --
528: -- ---------------------------------------------------------------------------
547: l_proc varchar2(72) := g_package||'return_legislation_code';
548: --
549: begin
550: --
551: hr_utility.set_location('Entering:'|| l_proc, 10);
552: --
553: -- Ensure that all the mandatory parameter are not null
554: --
555: hr_api.mandatory_arg_error(p_api_name => l_proc,
572: end if;
573: --
574: close csr_leg_code;
575: --
576: hr_utility.set_location(' Leaving:'|| l_proc, 20);
577: --
578: return l_legislation_code;
579: --
580: end return_legislation_code;