[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_emp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ELIG_MRTL_STS_PRTE_id => p_ELIG_MRTL_STS_PRTE_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_ELIG_MRTL_STS_PRTE_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_emp_shd.api_updating
118: (p_ELIG_MRTL_STS_PRTE_id => p_ELIG_MRTL_STS_PRTE_id,
119: p_effective_date => p_effective_date,
126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: hr_utility.set_location(' yes no ' || p_excld_flag , 99 );
131: if hr_api.not_exists_in_hr_lookups
132: (p_lookup_type => 'YES_NO',
133: p_lookup_code => p_excld_flag,
134: p_effective_date => p_effective_date) then
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:
156: l_api_updating boolean;
157: --
158: Begin
159: --
160: hr_utility.set_location('Entering:'||l_proc, 5);
161: --
162: l_api_updating := ben_emp_shd.api_updating
163: (p_ELIG_MRTL_STS_PRTE_id => p_ELIG_MRTL_STS_PRTE_id,
164: p_effective_date => p_effective_date,
171: --
172: -- check if value of lookup falls within lookup type.
173: --
174: --
175: hr_utility.set_location(' status ' || p_marital_status , 99 );
176: hr_utility.set_location(' date ' || p_effective_date , 99 );
177: if hr_api.not_exists_in_hr_lookups
178: (p_lookup_type => 'MAR_STATUS',
179: p_lookup_code => p_marital_status,
172: -- check if value of lookup falls within lookup type.
173: --
174: --
175: hr_utility.set_location(' status ' || p_marital_status , 99 );
176: hr_utility.set_location(' date ' || p_effective_date , 99 );
177: if hr_api.not_exists_in_hr_lookups
178: (p_lookup_type => 'MAR_STATUS',
179: p_lookup_code => p_marital_status,
180: p_effective_date => p_effective_date) then
187: end if;
188: --
189: end if;
190: --
191: hr_utility.set_location('Leaving:'||l_proc,10);
192: --
193: end chk_marital_status;
194:
195: -- ----------------------------------------------------------------------------
232: l_integrity_error Exception;
233: l_table_name all_tables.table_name%TYPE;
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: -- Ensure that the p_datetrack_mode argument is not null
239: --
240: hr_api.mandatory_arg_error
271: End If;
272: --
273: End If;
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 10);
276: Exception
277: When l_integrity_error Then
278: --
279: -- A referential integrity check was violated therefore
336: l_rows_exist Exception;
337: l_table_name all_tables.table_name%TYPE;
338: --
339: Begin
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: --
342: -- Ensure that the p_datetrack_mode argument is not null
343: --
344: hr_api.mandatory_arg_error
373: --
374: --
375: End If;
376: --
377: hr_utility.set_location(' Leaving:'||l_proc, 10);
378: Exception
379: When l_rows_exist Then
380: --
381: -- A referential integrity check was violated therefore
405: --
406: l_proc varchar2(72) := g_package||'insert_validate';
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: -- Call all supporting business operations
412: --
413: chk_ELIG_MRTL_STS_PRTE_id
430:
431: --
432: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 10);
435: End insert_validate;
436: --
437: -- ----------------------------------------------------------------------------
438: -- |---------------------------< update_validate >----------------------------|
446: --
447: l_proc varchar2(72) := g_package||'update_validate';
448: --
449: Begin
450: hr_utility.set_location('Entering:'||l_proc, 5);
451: --
452: -- Call all supporting business operations
453: --
454: chk_ELIG_MRTL_STS_PRTE_id
478: p_datetrack_mode => p_datetrack_mode,
479: p_validation_start_date => p_validation_start_date,
480: p_validation_end_date => p_validation_end_date);
481: --
482: hr_utility.set_location(' Leaving:'||l_proc, 10);
483: End update_validate;
484: --
485: -- ----------------------------------------------------------------------------
486: -- |---------------------------< delete_validate >----------------------------|
494: --
495: l_proc varchar2(72) := g_package||'delete_validate';
496: --
497: Begin
498: hr_utility.set_location('Entering:'||l_proc, 5);
499: --
500: -- Call all supporting business operations
501: --
502: dt_delete_validate
504: p_validation_start_date => p_validation_start_date,
505: p_validation_end_date => p_validation_end_date,
506: p_ELIG_MRTL_STS_PRTE_id => p_rec.ELIG_MRTL_STS_PRTE_id);
507: --
508: hr_utility.set_location(' Leaving:'||l_proc, 10);
509: End delete_validate;
510: --
511: --
512: -- ---------------------------------------------------------------------------
531: l_proc varchar2(72) := g_package||'return_legislation_code';
532: --
533: begin
534: --
535: hr_utility.set_location('Entering:'|| l_proc, 10);
536: --
537: -- Ensure that all the mandatory parameter are not null
538: --
539: hr_api.mandatory_arg_error(p_api_name => l_proc,
556: end if;
557: --
558: close csr_leg_code;
559: --
560: hr_utility.set_location(' Leaving:'|| l_proc, 20);
561: --
562: return l_legislation_code;
563: --
564: end return_legislation_code;