[Home] [Help]
44: l_proc varchar2(72) := g_package||'set_security_group_id';
45: --
46: begin
47: --
48: hr_utility.set_location('Entering:'|| l_proc, 10);
49: --
50: -- Ensure that all the mandatory parameter are not null
51: --
52: hr_api.mandatory_arg_error
76: hr_api.set_security_group_id
77: (p_security_group_id => l_security_group_id
78: );
79: --
80: hr_utility.set_location(' Leaving:'|| l_proc, 20);
81: --
82: end set_security_group_id;
83: --
84: -- ---------------------------------------------------------------------------
113: l_proc varchar2(72) := g_package||'return_legislation_code';
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Ensure that all the mandatory parameter are not null
120: --
121: hr_api.mandatory_arg_error
134: -- call to this function. Just return the value in the global
135: -- variable.
136: --
137: l_legislation_code := hr_ort_bus.g_legislation_code;
138: hr_utility.set_location(l_proc, 20);
139: else
140: --
141: -- The ID is different to the last call to this function
142: -- or this is the first call to this function.
151: close csr_leg_code;
152: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: end if;
155: hr_utility.set_location(l_proc,30);
156: --
157: -- Set the global variables so the values are
158: -- available for the next call to this function.
159: --
161: hr_ort_bus.g_organization_id := p_organization_id;
162: hr_ort_bus.g_language := p_language;
163: hr_ort_bus.g_legislation_code := l_legislation_code;
164: end if;
165: hr_utility.set_location(' Leaving:'|| l_proc, 40);
166: return l_legislation_code;
167: end return_legislation_code;
168: --
169: -- ----------------------------------------------------------------------------
237: --
238: l_proc varchar2(72) := g_package||'insert_validate';
239: --
240: Begin
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: -- Call all supporting business operations
244: --
245: --
250: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."
251: -- "-- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."
252: --
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 10);
255: End insert_validate;
256: --
257: -- ----------------------------------------------------------------------------
258: -- |---------------------------< update_validate >----------------------------|
263: --
264: l_proc varchar2(72) := g_package||'update_validate';
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: --
269: -- Call all supporting business operations
270: --
271: -- EDIT_HERE: As this table does not have a mandatory business_group_id
279: (p_rec => p_rec
280: );
281: --
282: --
283: hr_utility.set_location(' Leaving:'||l_proc, 10);
284: End update_validate;
285: --
286: -- ----------------------------------------------------------------------------
287: -- |---------------------------< delete_validate >----------------------------|
292: --
293: l_proc varchar2(72) := g_package||'delete_validate';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: -- Call all supporting business operations
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: -- Call all supporting business operations
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301: End delete_validate;
302: --
303: end hr_ort_bus;