[Home] [Help]
25: l_link_id number;
26: l_object_version_number number;
27: l_effective_date date;
28: begin
29: hr_utility.set_location('Entering:'|| l_proc, 10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint create_linked_candidate;
91: --
92: p_link_id := l_link_id;
93: p_object_version_number := l_object_version_number;
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 70);
96: exception
97: when hr_api.validate_enabled then
98: --
99: -- As the Validate_Enabled exception has been raised
106: -- when validation only mode is being used.)
107: --
108: p_link_id := null;
109: p_object_version_number := null;
110: hr_utility.set_location(' Leaving:'||l_proc, 80);
111: when others then
112: --
113: -- A validation or unexpected error has occured
114: --
118: -- OUT parameters, including warnings, to null
119: --
120: p_link_id := null;
121: p_object_version_number := null;
122: hr_utility.set_location(' Leaving:'||l_proc, 90);
123: raise;
124: end create_linked_candidate;
125: --
126: --
143: l_object_version_number number;
144: l_effective_date date;
145: l_proc varchar2(72) := g_package||'UPDATE_LINKED_CANDIDATE';
146: begin
147: hr_utility.set_location('Entering:'|| l_proc, 10);
148: --
149: -- Issue a savepoint
150: --
151: savepoint update_linked_candidate;
216: -- Set all IN OUT and OUT parameters with out values
217: --
218: p_object_version_number := l_object_version_number;
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 70);
221: exception
222: when hr_api.validate_enabled then
223: --
224: -- As the Validate_Enabled exception has been raised
229: -- Reset IN OUT parameters and set OUT parameters
230: -- (Any key or derived arguments must be set to null
231: -- when validation only mode is being used.)
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 80);
234: when others then
235: --
236: -- A validation or unexpected error has occured
237: --
239: --
240: -- Reset IN OUT parameters and set all
241: -- OUT parameters, including warnings, to null
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 90);
244: raise;
245: end update_linked_candidate;
246: --
247: --
258: -- Declare cursors and local variables
259: --
260: l_proc varchar2(72) := g_package||'DELETE_LINKED_CANDIDATE';
261: begin
262: hr_utility.set_location('Entering:'|| l_proc, 10);
263: --
264: -- Issue a savepoint
265: --
266: savepoint delete_linked_candidate;
268: -- Process Logic
269: --
270: if p_link_id is null then
271: -- RAISE ERROR SAYING INVALID link_ID
272: hr_utility.set_location('Invalid Link Id '|| l_proc, 20);
273: fnd_message.set_name('PER', 'IRC_XXXX_INV_LINK_ID');
274: fnd_message.raise_error;
275: end if;
276: --
273: fnd_message.set_name('PER', 'IRC_XXXX_INV_LINK_ID');
274: fnd_message.raise_error;
275: end if;
276: --
277: hr_utility.set_location('Calling Delete Link Id '|| l_proc, 30);
278: --
279: irc_ilc_del.del(p_link_id => p_link_id
280: ,p_object_version_number => p_object_version_number
281: );
285: if p_validate then
286: raise hr_api.validate_enabled;
287: end if;
288: --
289: hr_utility.set_location(' Leaving:'||l_proc, 40);
290: exception
291: when hr_api.validate_enabled then
292: --
293: -- As the Validate_Enabled exception has been raised
294: -- we must rollback to the savepoint
295: --
296: rollback to delete_linked_candidate;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 50);
299: --
300: when others then
301: --
302: -- A validation or unexpected error has occured
302: -- A validation or unexpected error has occured
303: --
304: rollback to delete_linked_candidate;
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 60);
307: --
308: raise;
309: end delete_linked_candidate;
310: --