[Home] [Help]
36: -- Other variables
37: l_document_id number;
38: l_proc varchar2(72) := g_package ||'create_document';
39: Begin
40: hr_utility.set_location(' Entering:' || l_proc,10);
41: --
42: -- Issue a savepoint
43: --
44: savepoint create_document_swi;
82: ,p_language => p_language
83: ,p_territory => p_territory
84: );
85: --
86: hr_utility.set_location(' Document Id '||l_document_id,18);
87: p_document_id := l_document_id;
88: -- Convert API warning boolean parameter values to specific
89: -- messages and add them to Multiple Message List
90: --
96: -- messages of any type exist in the Multiple Message List.
97: -- Also disable Multiple Message Detection.
98: --
99: p_return_status := hr_multi_message.get_return_status_disable;
100: hr_utility.set_location(' Leaving:' || l_proc,20);
101: --
102: exception
103: when hr_multi_message.error_message_exist then
104: --
114: p_object_version_number := null;
115: p_effective_start_date := null;
116: p_effective_end_date := null;
117: p_return_status := hr_multi_message.get_return_status_disable;
118: hr_utility.set_location(' Leaving:' || l_proc, 30);
119: when others then
120: --
121: -- When Multiple Message Detection is enabled catch
122: -- any Application specific or other unexpected
125: -- error.
126: --
127: rollback to create_document_swi;
128: if hr_multi_message.unexpected_error_add(l_proc) then
129: hr_utility.set_location(' Leaving:' || l_proc,40);
130: raise;
131: end if;
132: --
133: -- Reset IN OUT and set OUT parameters
136: p_object_version_number := null;
137: p_effective_start_date := null;
138: p_effective_end_date := null;
139: p_return_status := hr_multi_message.get_return_status_disable;
140: hr_utility.set_location(' Leaving:' || l_proc,50);
141: end create_document;
142: -- ----------------------------------------------------------------------------
143: -- |----------------------------< delete_document >---------------------------|
144: -- ----------------------------------------------------------------------------
161: --
162: -- Other variables
163: l_proc varchar2(72) := g_package ||'delete_document';
164: Begin
165: hr_utility.set_location(' Entering:' || l_proc,10);
166: --
167: -- Issue a savepoint
168: --
169: savepoint delete_document_swi;
208: -- messages of any type exist in the Multiple Message List.
209: -- Also disable Multiple Message Detection.
210: --
211: p_return_status := hr_multi_message.get_return_status_disable;
212: hr_utility.set_location(' Leaving:' || l_proc,20);
213: --
214: exception
215: when hr_multi_message.error_message_exist then
216: --
225: p_object_version_number := l_object_version_number;
226: p_effective_start_date := null;
227: p_effective_end_date := null;
228: p_return_status := hr_multi_message.get_return_status_disable;
229: hr_utility.set_location(' Leaving:' || l_proc, 30);
230: when others then
231: --
232: -- When Multiple Message Detection is enabled catch
233: -- any Application specific or other unexpected
236: -- error.
237: --
238: rollback to delete_document_swi;
239: if hr_multi_message.unexpected_error_add(l_proc) then
240: hr_utility.set_location(' Leaving:' || l_proc,40);
241: raise;
242: end if;
243: --
244: -- Reset IN OUT and set OUT parameters
246: p_object_version_number := l_object_version_number;
247: p_effective_start_date := null;
248: p_effective_end_date := null;
249: p_return_status := hr_multi_message.get_return_status_disable;
250: hr_utility.set_location(' Leaving:' || l_proc,50);
251: end delete_document;
252: -- ----------------------------------------------------------------------------
253: -- |----------------------------< update_document >---------------------------|
254: -- ----------------------------------------------------------------------------
328: l_eed date;
329: l_return_status varchar2(100);
330: l_eff_date date;
331: Begin
332: hr_utility.set_location(' Entering:' || l_proc,10);
333: --
334: -- Issue a savepoint
335: --
336: savepoint update_document_swi;
480: -- messages of any type exist in the Multiple Message List.
481: -- Also disable Multiple Message Detection.
482: --
483: p_return_status := hr_multi_message.get_return_status_disable;
484: hr_utility.set_location(' Leaving:' || l_proc,20);
485: --
486: exception
487: when hr_multi_message.error_message_exist then
488: --
497: p_object_version_number := l_object_version_number;
498: p_effective_start_date := null;
499: p_effective_end_date := null;
500: p_return_status := hr_multi_message.get_return_status_disable;
501: hr_utility.set_location(' Leaving:' || l_proc, 30);
502: when others then
503: --
504: -- When Multiple Message Detection is enabled catch
505: -- any Application specific or other unexpected
508: -- error.
509: --
510: rollback to update_document_swi;
511: if hr_multi_message.unexpected_error_add(l_proc) then
512: hr_utility.set_location(' Leaving:' || l_proc,40);
513: raise;
514: end if;
515: --
516: -- Reset IN OUT and set OUT parameters
518: p_object_version_number := l_object_version_number;
519: p_effective_start_date := null;
520: p_effective_end_date := null;
521: p_return_status := hr_multi_message.get_return_status_disable;
522: hr_utility.set_location(' Leaving:' || l_proc,50);
523: end update_document;
524: end pqh_documents_swi;