31: -- Other variables
32: l_document_id number;
33: l_proc varchar2(72) := g_package ||'create_document';
34: Begin
35: hr_utility.set_location(' Entering:' || l_proc,10);
36: --
37: -- Issue a savepoint
38: --
39: savepoint create_document_swi;
84: -- messages of any type exist in the Multiple Message List.
85: -- Also disable Multiple Message Detection.
86: --
87: p_return_status := hr_multi_message.get_return_status_disable;
88: hr_utility.set_location(' Leaving:' || l_proc,20);
89: --
90: exception
91: when hr_multi_message.error_message_exist then
92: --
99: -- Reset IN OUT parameters and set OUT parameters
100: --
101: p_object_version_number := null;
102: p_return_status := hr_multi_message.get_return_status_disable;
103: hr_utility.set_location(' Leaving:' || l_proc, 30);
104: when others then
105: --
106: -- When Multiple Message Detection is enabled catch
107: -- any Application specific or other unexpected
110: -- error.
111: --
112: rollback to create_document_swi;
113: if hr_multi_message.unexpected_error_add(l_proc) then
114: hr_utility.set_location(' Leaving:' || l_proc,40);
115: raise;
116: end if;
117: --
118: -- Reset IN OUT and set OUT parameters
118: -- Reset IN OUT and set OUT parameters
119: --
120: p_object_version_number := null;
121: p_return_status := hr_multi_message.get_return_status_disable;
122: hr_utility.set_location(' Leaving:' || l_proc,50);
123: end create_document;
124: -- ----------------------------------------------------------------------------
125: -- |----------------------------< delete_document >---------------------------|
126: -- ----------------------------------------------------------------------------
145: l_proc varchar2(72) := g_package ||'delete_document';
146: Begin
147:
148:
149: hr_utility.set_location(' Entering:' || l_proc,10);
150: --
151: -- Issue a savepoint
152: --
153: savepoint delete_document_swi;
192: -- messages of any type exist in the Multiple Message List.
193: -- Also disable Multiple Message Detection.
194: --
195: p_return_status := hr_multi_message.get_return_status_disable;
196: hr_utility.set_location(' Leaving:' || l_proc,20);
197: --
198:
199: --
200: exception
208: --
209: -- Reset IN OUT parameters and set OUT parameters
210: --
211: p_return_status := hr_multi_message.get_return_status_disable;
212: hr_utility.set_location(' Leaving:' || l_proc, 30);
213: when others then
214: --
215: -- When Multiple Message Detection is enabled catch
216: -- any Application specific or other unexpected
219: -- error.
220: --
221: rollback to delete_document_swi;
222: if hr_multi_message.unexpected_error_add(l_proc) then
223: hr_utility.set_location(' Leaving:' || l_proc,40);
224: raise;
225: end if;
226: --
227: -- Reset IN OUT and set OUT parameters
226: --
227: -- Reset IN OUT and set OUT parameters
228: --
229: p_return_status := hr_multi_message.get_return_status_disable;
230: hr_utility.set_location(' Leaving:' || l_proc,50);
231:
232:
233: end delete_document;
234: -- ----------------------------------------------------------------------------
259: --
260: -- Other variables
261: l_proc varchar2(72) := g_package ||'update_document';
262: Begin
263: hr_utility.set_location(' Entering:' || l_proc,10);
264: --
265:
266: -- Issue a savepoint
267: --
313: -- messages of any type exist in the Multiple Message List.
314: -- Also disable Multiple Message Detection.
315: --
316: p_return_status := hr_multi_message.get_return_status_disable;
317: hr_utility.set_location(' Leaving:' || l_proc,20);
318: --
319: exception
320: when hr_multi_message.error_message_exist then
321: --
328: -- Reset IN OUT parameters and set OUT parameters
329: --
330: p_object_version_number := l_object_version_number;
331: p_return_status := hr_multi_message.get_return_status_disable;
332: hr_utility.set_location(' Leaving:' || l_proc, 30);
333: when others then
334: --
335: -- When Multiple Message Detection is enabled catch
336: -- any Application specific or other unexpected
339: -- error.
340: --
341: rollback to update_document_swi;
342: if hr_multi_message.unexpected_error_add(l_proc) then
343: hr_utility.set_location(' Leaving:' || l_proc,40);
344: raise;
345: end if;
346: --
347: -- Reset IN OUT and set OUT parameters
347: -- Reset IN OUT and set OUT parameters
348: --
349: p_object_version_number := l_object_version_number;
350: p_return_status := hr_multi_message.get_return_status_disable;
351: hr_utility.set_location(' Leaving:' || l_proc,50);
352: end update_document;
353: end irc_document_swi;