[Home] [Help]
36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------
96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := pay_evp_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: pay_evp_bus.g_event_procedure_id:= p_event_procedure_id;
142: pay_evp_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------
267: );
268: --
269: Begin
270: --
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: --
273: Open csr_chk_column;
274: Fetch csr_chk_column Into l_dummy;
275: If csr_chk_column%notfound Then
282: fnd_message.raise_error;
283: End If;
284: Close csr_chk_column;
285: --
286: hr_utility.set_location(' Leaving:'||l_proc, 10);
287: --
288: end chk_column;
289: --
290: -- ----------------------------------------------------------------------------
296: --
297: l_proc varchar2(72) := g_package||'insert_validate';
298: --
299: Begin
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: -- Commenting this out as business group id is a nullable column
303: --hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
304: --
303: --hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
304: --
305: chk_column (p_rec => p_rec);
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 10);
308: --
309: End insert_validate;
310: --
311: -- ----------------------------------------------------------------------------
317: --
318: l_proc varchar2(72) := g_package||'update_validate';
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: -- Commenting this out as business group id is a nullable column
324: --hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
325: --
328: );
329: --
330: chk_column (p_rec => p_rec);
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 10);
333: --
334: End update_validate;
335: --
336: -- ----------------------------------------------------------------------------
342: --
343: l_proc varchar2(72) := g_package||'delete_validate';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Call all supporting business operations
349: --
350: hr_utility.set_location(' Leaving:'||l_proc, 10);
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Call all supporting business operations
349: --
350: hr_utility.set_location(' Leaving:'||l_proc, 10);
351: End delete_validate;
352: --
353: end pay_evp_bus;