[Home] [Help]
40: l_legislation_code varchar2(150);
41: --
42: begin
43: --
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error
81: --
82: hr_api.set_legislation_context(l_legislation_code);
83: end if;
84: --
85: hr_utility.set_location(' Leaving:'|| l_proc, 20);
86: --
87: end set_security_group_id;
88: --
89: -- ---------------------------------------------------------------------------
111: l_proc varchar2(72) := g_package||'return_legislation_code';
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'|| l_proc, 10);
116: --
117: -- Ensure that all the mandatory parameter are not null
118: --
119: hr_api.mandatory_arg_error
132: -- call to this function. Just return the value in the global
133: -- variable.
134: --
135: l_legislation_code := ota_srt_bus.g_legislation_code;
136: hr_utility.set_location(l_proc, 20);
137: else
138: --
139: -- The ID is different to the last call to this function
140: -- or this is the first call to this function.
149: close csr_leg_code;
150: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
151: fnd_message.raise_error;
152: end if;
153: hr_utility.set_location(l_proc,30);
154: --
155: -- Set the global variables so the values are
156: -- available for the next call to this function.
157: --
159: ota_srt_bus.g_supplied_resource_id := p_supplied_resource_id;
160: ota_srt_bus.g_language := p_language;
161: ota_srt_bus.g_legislation_code := l_legislation_code;
162: end if;
163: hr_utility.set_location(' Leaving:'|| l_proc, 40);
164: return l_legislation_code;
165: end return_legislation_code;
166: --
167: -- ----------------------------------------------------------------------------
252: --
253: l_proc varchar2(72) := g_package||'check_unique_name';
254: --
255: begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: if p_business_group_id is null or p_resource_type is null then
259: open csr_tsr_bsg_type ;
260: fetch csr_tsr_bsg_type into l_business_group_id, l_resource_type ;
276: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
277: fnd_message.raise_error;
278: end if;
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
281: end check_unique_name;
282: --
283: -- ----------------------------------------------------------------------------
284: -- |---------------------------< insert_validate >----------------------------|
291: --
292: l_proc varchar2(72) := g_package||'insert_validate';
293: --
294: Begin
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- Call all supporting business operations
298: --
299: --
305: ,p_language => p_rec.language
306: ) ;
307: --
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 10);
310: End insert_validate;
311: --
312: -- ----------------------------------------------------------------------------
313: -- |---------------------------< update_validate >----------------------------|
319: --
320: l_proc varchar2(72) := g_package||'update_validate';
321: --
322: Begin
323: hr_utility.set_location('Entering:'||l_proc, 5);
324: --
325: -- Call all supporting business operations
326: --
327: --
338: ,p_rec => p_rec
339: );
340: --
341: --
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: End update_validate;
344: --
345: -- ----------------------------------------------------------------------------
346: -- |---------------------------< delete_validate >----------------------------|
351: --
352: l_proc varchar2(72) := g_package||'delete_validate';
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);
356: --
357: -- Call all supporting business operations
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: hr_utility.set_location('Entering:'||l_proc, 5);
356: --
357: -- Call all supporting business operations
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: End delete_validate;
361: --
362:
363: --