[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_bnb_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_bnfts_bal_id => p_bnfts_bal_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_bnfts_bal_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_bnb_shd.api_updating
118: (p_bnfts_bal_id => p_bnfts_bal_id,
119: p_effective_date => p_effective_date,
140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_bnfts_bal_usg_cd;
147: --
148: -- |------< chk_nnmntry_uom >------|
179: l_api_updating boolean;
180: --
181: Begin
182: --
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: l_api_updating := ben_bnb_shd.api_updating
186: (p_bnfts_bal_id => p_bnfts_bal_id,
187: p_effective_date => p_effective_date,
208: end if;
209: --
210: end if;
211: --
212: hr_utility.set_location('Leaving:'||l_proc,10);
213: --
214: end chk_nnmntry_uom;
215:
216: -- |------< chk_uom >------|
251: where currency_code = p_uom;
252: --
253: Begin
254: --
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: l_api_updating := ben_bnb_shd.api_updating
258: (p_bnfts_bal_id => p_bnfts_bal_id,
259: p_effective_date => p_effective_date,
288: end if;
289: --
290: end if;
291: --
292: hr_utility.set_location('Leaving:'||l_proc,10);
293: --
294: end chk_uom;
295: -- ----------------------------------------------------------------------------
296: -- |------------------------< chk_name_unique >---------------------------------|
330: and name = p_name
331: and business_group_id = p_business_group_id;
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: open c1;
337: fetch c1 into l_dummy;
338: if c1%found then
340: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
341: fnd_message.raise_error;
342: end if;
343: --
344: hr_utility.set_location('Leaving:'||l_proc, 15);
345: End chk_name_unique;
346: --
347: -- ----------------------------------------------------------------------------
348: -- |--------------------------< dt_update_validate >--------------------------|
383: l_integrity_error Exception;
384: l_table_name all_tables.table_name%TYPE;
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: -- Ensure that the p_datetrack_mode argument is not null
390: --
391: hr_api.mandatory_arg_error
413: --
414: --
415: End If;
416: --
417: hr_utility.set_location(' Leaving:'||l_proc, 10);
418: Exception
419: When l_integrity_error Then
420: --
421: -- A referential integrity check was violated therefore
478: l_rows_exist Exception;
479: l_table_name all_tables.table_name%TYPE;
480: --
481: Begin
482: hr_utility.set_location('Entering:'||l_proc, 5);
483: --
484: -- Ensure that the p_datetrack_mode argument is not null
485: --
486: hr_api.mandatory_arg_error
523: End If;
524: --
525: End If;
526: --
527: hr_utility.set_location(' Leaving:'||l_proc, 10);
528: Exception
529: When l_rows_exist Then
530: --
531: -- A referential integrity check was violated therefore
555: --
556: l_proc varchar2(72) := g_package||'insert_validate';
557: --
558: Begin
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: --
561: -- Call all supporting business operations
562: --
563: --
592: (p_bnfts_bal_id => p_rec.bnfts_bal_id,
593: p_name => p_rec.name,
594: p_business_group_id => p_rec.business_group_id);
595: --
596: hr_utility.set_location(' Leaving:'||l_proc, 10);
597: End insert_validate;
598: --
599: -- ----------------------------------------------------------------------------
600: -- |---------------------------< update_validate >----------------------------|
608: --
609: l_proc varchar2(72) := g_package||'update_validate';
610: --
611: Begin
612: hr_utility.set_location('Entering:'||l_proc, 5);
613: --
614: -- Call all supporting business operations
615: --
616: --
653: p_datetrack_mode => p_datetrack_mode,
654: p_validation_start_date => p_validation_start_date,
655: p_validation_end_date => p_validation_end_date);
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 10);
658: End update_validate;
659: --
660: -- ----------------------------------------------------------------------------
661: -- |---------------------------< delete_validate >----------------------------|
669: --
670: l_proc varchar2(72) := g_package||'delete_validate';
671: --
672: Begin
673: hr_utility.set_location('Entering:'||l_proc, 5);
674: --
675: -- Call all supporting business operations
676: --
677: dt_delete_validate
679: p_validation_start_date => p_validation_start_date,
680: p_validation_end_date => p_validation_end_date,
681: p_bnfts_bal_id => p_rec.bnfts_bal_id);
682: --
683: hr_utility.set_location(' Leaving:'||l_proc, 10);
684: End delete_validate;
685: --
686: --
687: -- ---------------------------------------------------------------------------
706: l_proc varchar2(72) := g_package||'return_legislation_code';
707: --
708: begin
709: --
710: hr_utility.set_location('Entering:'|| l_proc, 10);
711: --
712: -- Ensure that all the mandatory parameter are not null
713: --
714: hr_api.mandatory_arg_error(p_api_name => l_proc,
731: end if;
732: --
733: close csr_leg_code;
734: --
735: hr_utility.set_location(' Leaving:'|| l_proc, 20);
736: --
737: return l_legislation_code;
738: --
739: end return_legislation_code;