[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_edi_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_dpnt_cvrd_plip_id => p_elig_dpnt_cvrd_plip_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_dpnt_cvrd_plip_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_edi_shd.api_updating
118: (p_elig_dpnt_cvrd_plip_id => p_elig_dpnt_cvrd_plip_id,
119: p_effective_date => p_effective_date,
143: end if;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: end chk_enrl_det_dt_cd;
150: --
151: -- ----------------------------------------------------------------------------
183: l_api_updating boolean;
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_edi_shd.api_updating
190: (p_elig_dpnt_cvrd_plip_id => p_elig_dpnt_cvrd_plip_id,
191: 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_excld_flag;
222: --
223: --Bug:5054189
264: and ordr_num = p_ordr_num
265: and business_group_id = p_business_group_id;
266: --
267: Begin
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: --
270: open c1;
271: fetch c1 into l_dummy;
272: if c1%found then
275: fnd_message.raise_error;
276: end if;
277: close c1;
278: --
279: hr_utility.set_location('Leaving:'||l_proc, 15);
280: End chk_duplicate_ordr_num;
281: -- ----------------------------------------------------------------------------
282: -- |--------------------------< dt_update_validate >--------------------------|
283: -- ----------------------------------------------------------------------------
318: l_integrity_error Exception;
319: l_table_name all_tables.table_name%TYPE;
320: --
321: Begin
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: -- Ensure that the p_datetrack_mode argument is not null
325: --
326: hr_api.mandatory_arg_error
367: End If;
368: --
369: End If;
370: --
371: hr_utility.set_location(' Leaving:'||l_proc, 10);
372: Exception
373: When l_integrity_error Then
374: --
375: -- A referential integrity check was violated therefore
434: l_rows_exist Exception;
435: l_table_name all_tables.table_name%TYPE;
436: --
437: Begin
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: -- Ensure that the p_datetrack_mode argument is not null
441: --
442: hr_api.mandatory_arg_error
471: --
472: --
473: End If;
474: --
475: hr_utility.set_location(' Leaving:'||l_proc, 10);
476: Exception
477: When l_rows_exist Then
478: --
479: -- A referential integrity check was violated therefore
505: --
506: l_proc varchar2(72) := g_package||'insert_validate';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Call all supporting business operations
512: --
513: chk_elig_dpnt_cvrd_plip_id
534: ,p_business_group_id => p_rec.business_group_id);
535: --
536: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 10);
539: End insert_validate;
540: --
541: -- ----------------------------------------------------------------------------
542: -- |---------------------------< update_validate >----------------------------|
550: --
551: l_proc varchar2(72) := g_package||'update_validate';
552: --
553: Begin
554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: -- Call all supporting business operations
557: --
558: chk_elig_dpnt_cvrd_plip_id
588: p_datetrack_mode => p_datetrack_mode,
589: p_validation_start_date => p_validation_start_date,
590: p_validation_end_date => p_validation_end_date);
591: --
592: hr_utility.set_location(' Leaving:'||l_proc, 10);
593: End update_validate;
594: --
595: -- ----------------------------------------------------------------------------
596: -- |---------------------------< delete_validate >----------------------------|
604: --
605: l_proc varchar2(72) := g_package||'delete_validate';
606: --
607: Begin
608: hr_utility.set_location('Entering:'||l_proc, 5);
609: --
610: -- Call all supporting business operations
611: --
612: dt_delete_validate
614: p_validation_start_date => p_validation_start_date,
615: p_validation_end_date => p_validation_end_date,
616: p_elig_dpnt_cvrd_plip_id => p_rec.elig_dpnt_cvrd_plip_id);
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 10);
619: End delete_validate;
620: --
621: --
622: -- ---------------------------------------------------------------------------
641: l_proc varchar2(72) := g_package||'return_legislation_code';
642: --
643: begin
644: --
645: hr_utility.set_location('Entering:'|| l_proc, 10);
646: --
647: -- Ensure that all the mandatory parameter are not null
648: --
649: hr_api.mandatory_arg_error(p_api_name => l_proc,
666: end if;
667: --
668: close csr_leg_code;
669: --
670: hr_utility.set_location(' Leaving:'|| l_proc, 20);
671: --
672: return l_legislation_code;
673: --
674: end return_legislation_code;