[Home] [Help]
37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
69: hr_api.set_security_group_id
70: (p_security_group_id => l_security_group_id
71: );
72: --
73: hr_utility.set_location(' Leaving:'|| l_proc, 20);
74: --
75: end set_security_group_id;
76: --
77: -- ---------------------------------------------------------------------------
102: l_proc varchar2(72) := g_package||'return_legislation_code';
103: --
104: Begin
105: --
106: hr_utility.set_location('Entering:'|| l_proc, 10);
107: --
108: -- Ensure that all the mandatory parameter are not null
109: --
110: hr_api.mandatory_arg_error
123: -- call to this function. Just return the value in the global
124: -- variable.
125: --
126: l_legislation_code := pay_opt_bus.g_legislation_code;
127: hr_utility.set_location(l_proc, 20);
128: else
129: --
130: -- The ID is different to the last call to this function
131: -- or this is the first call to this function.
140: close csr_leg_code;
141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: end if;
144: hr_utility.set_location(l_proc,30);
145: --
146: -- Set the global variables so the values are
147: -- available for the next call to this function.
148: --
150: pay_opt_bus.g_org_payment_method_id:= p_org_payment_method_id;
151: pay_opt_bus.g_language := p_language;
152: pay_opt_bus.g_legislation_code := l_legislation_code;
153: end if;
154: hr_utility.set_location(' Leaving:'|| l_proc, 40);
155: return l_legislation_code;
156: end return_legislation_code;
157: --
158: -- ----------------------------------------------------------------------------
266: and opm1.business_group_id = opm.business_group_id);
267: --
268: --
269: Begin
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: -- Check mandatory org_payment_method_name exists
273: --
274: hr_api.mandatory_arg_error
277: ,p_argument_value => p_org_payment_method_name
278: );
279: --
280: --
281: hr_utility.set_location(l_proc,10);
282: --
283: -- Only proceed with SQL validation if absolutely necessary
284: --
285: if ( nvl(pay_opm_shd.g_old_rec.org_payment_method_name,hr_api.g_varchar2) <>
284: --
285: if ( nvl(pay_opm_shd.g_old_rec.org_payment_method_name,hr_api.g_varchar2) <>
286: nvl(p_org_payment_method_name,hr_api.g_varchar2)) then
287: --
288: hr_utility.set_location(l_proc,20);
289: --
290: --
291: open csr_org_pay_meth_name_exists;
292: fetch csr_org_pay_meth_name_exists into l_dummy;
298: fnd_message.raise_error;
299: end if;
300: close csr_org_pay_meth_name_exists;
301: --
302: hr_utility.set_location(l_proc,30);
303: --
304: end if;
305: --
306: --
303: --
304: end if;
305: --
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 100);
308: End chk_org_payment_method_name;
309: --
310: -- ----------------------------------------------------------------------------
311: -- |---------------------------< insert_validate >----------------------------|
316: --
317: l_proc varchar2(72) := g_package||'insert_validate';
318: --
319: Begin
320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: -- Call all supporting business operations
323: --
324: --
324: --
325: pay_opt_bus.set_security_group_id(p_org_payment_method_id
326: => p_rec.org_payment_method_id);
327: --
328: hr_utility.set_location(l_proc,30);
329: --
330: pay_opt_bus.chk_org_payment_method_name(p_org_payment_method_name => p_rec.org_payment_method_name
331: ,p_language => p_rec.language
332: ,p_org_payment_method_id => p_rec.org_payment_method_id);
330: pay_opt_bus.chk_org_payment_method_name(p_org_payment_method_name => p_rec.org_payment_method_name
331: ,p_language => p_rec.language
332: ,p_org_payment_method_id => p_rec.org_payment_method_id);
333: --
334: hr_utility.set_location(l_proc,40);
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 10);
337: End insert_validate;
338: --
332: ,p_org_payment_method_id => p_rec.org_payment_method_id);
333: --
334: hr_utility.set_location(l_proc,40);
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 10);
337: End insert_validate;
338: --
339: -- ----------------------------------------------------------------------------
340: -- |---------------------------< update_validate >----------------------------|
345: --
346: l_proc varchar2(72) := g_package||'update_validate';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- Call all supporting business operations
352: --
353: --
362: (p_rec => p_rec
363: );
364: --
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End update_validate;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |---------------------------< delete_validate >----------------------------|
375: --
376: l_proc varchar2(72) := g_package||'delete_validate';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: -- Call all supporting business operations
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: -- Call all supporting business operations
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End delete_validate;
385: --
386: end pay_opt_bus;