[Home] [Help]
49: l_api_updating boolean;
50: --
51: Begin
52: --
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: l_api_updating := ben_otp_shd.api_updating
56: (p_effective_date => p_effective_date,
57: p_optip_id => p_optip_id,
77: end if;
78: --
79: end if;
80: --
81: hr_utility.set_location('Leaving:'||l_proc, 10);
82: --
83: End chk_optip_id;
84: --
85: -- ----------------------------------------------------------------------------
126: and optip.pl_typ_id = p_pl_typ_id
127: and optip.opt_id = p_opt_id
128: and optip.effective_start_date > p_effective_date ;
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: -- raise error as the record already exists
133: open c_uniq_optip ;
134: fetch c_uniq_optip into l_dummy ;
134: fetch c_uniq_optip into l_dummy ;
135: --
136: if c_uniq_optip%found then
137: --
138: hr_utility.set_location('Future record exists.Cannot insert ', 8 ) ;
139: close c_uniq_optip ;
140: fnd_message.set_name('PER','HR_7211_DT_UPD_ROWS_IN_FUTURE');
141: fnd_message.raise_error;
142: --
142: --
143: end if;
144: close c_uniq_optip ;
145: --
146: hr_utility.set_location('Leaving:'||l_proc, 10);
147: --
148: End chk_uniq_optip;
149: --
150: -- ---------------------------------------------------------------------------
170: l_proc varchar2(72) := g_package||'set_security_group_id';
171: --
172: begin
173: --
174: hr_utility.set_location('Entering:'|| l_proc, 10);
175: --
176: -- Ensure that all the mandatory parameter are not null
177: --
178: hr_api.mandatory_arg_error
201: hr_api.set_security_group_id
202: (p_security_group_id => l_security_group_id
203: );
204: --
205: hr_utility.set_location(' Leaving:'|| l_proc, 20);
206: --
207: end set_security_group_id;
208: --
209: -- ---------------------------------------------------------------------------
232: l_proc varchar2(72) := g_package||'return_legislation_code';
233: --
234: Begin
235: --
236: hr_utility.set_location('Entering:'|| l_proc, 10);
237: --
238: -- Ensure that all the mandatory parameter are not null
239: --
240: hr_api.mandatory_arg_error
251: -- variable.
252: --
253: l_legislation_code := ben_otp_bus.g_legislation_code;
254:
255: hr_utility.set_location(l_proc, 20);
256: else
257: --
258: -- The ID is different to the last call to this function
259: -- or this is the first call to this function.
269: close csr_leg_code;
270: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
271: fnd_message.raise_error;
272: end if;
273: hr_utility.set_location(l_proc,30);
274: --
275: -- Set the global variables so the values are
276: -- available for the next call to this function.
277: --
279: ben_otp_bus.g_optip_id := p_optip_id;
280: ben_otp_bus.g_legislation_code := l_legislation_code;
281:
282: end if;
283: hr_utility.set_location(' Leaving:'|| l_proc, 40);
284: return l_legislation_code;
285:
286: end return_legislation_code;
287:
321: --
322: l_proc varchar2(72) := g_package || 'chk_df';
323: --
324: begin
325: hr_utility.set_location('Entering:'||l_proc,10);
326: --
327: if ((p_rec.optip_id is not null) and (
328: nvl(ben_otp_shd.g_old_rec.legislation_code, hr_api.g_varchar2) <>
329: nvl(ben_otp_shd.g_old_rec.legislation_subgroup, hr_api.g_varchar2) <>
466: ,p_attribute30_value => p_rec.otp_attribute30
467: );
468: end if;
469: --
470: hr_utility.set_location(' Leaving:'||l_proc,20);
471: end chk_df;
472: */
473: --
474: /*
777: --
778: l_proc varchar2(72) := g_package||'insert_validate';
779: --
780: Begin
781: hr_utility.set_location('Entering:'||l_proc, 5);
782: --
783: -- Call all supporting business operations
784: --
785: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
799: p_pl_typ_id =>p_rec.pl_typ_id,
800: p_opt_id =>p_rec.opt_id,
801: p_effective_date =>p_effective_date,
802: p_object_version_number => p_rec.object_version_number);
803: hr_utility.set_location(' Leaving:'||l_proc, 10);
804: End insert_validate;
805: --
806: -- ----------------------------------------------------------------------------
807: -- |---------------------------< update_validate >----------------------------|
816: --
817: l_proc varchar2(72) := g_package||'update_validate';
818: --
819: Begin
820: hr_utility.set_location('Entering:'||l_proc, 5);
821: --
822: -- Call all supporting business operations
823: --
824: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
850: --
851: --
852: --ben_otp_bus.chk_df(p_rec);
853: --
854: hr_utility.set_location(' Leaving:'||l_proc, 10);
855: End update_validate;
856: --
857: -- ----------------------------------------------------------------------------
858: -- |---------------------------< delete_validate >----------------------------|
867: --
868: l_proc varchar2(72) := g_package||'delete_validate';
869: --
870: Begin
871: hr_utility.set_location('Entering:'||l_proc, 5);
872: --
873: -- Call all supporting business operations
874: --
875: dt_delete_validate
878: ,p_validation_end_date => p_validation_end_date
879: ,p_optip_id => p_rec.optip_id
880: );
881: --
882: hr_utility.set_location(' Leaving:'||l_proc, 10);
883: End delete_validate;
884: --
885: end ben_otp_bus;