25: --
26: -- Other variables
27: l_proc varchar2(72) := g_package ||'create_txn_cat_document';
28: Begin
29: hr_utility.set_location(' Entering:' || l_proc,10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint create_txn_cat_document_swi;
70: -- messages of any type exist in the Multiple Message List.
71: -- Also disable Multiple Message Detection.
72: --
73: p_return_status := hr_multi_message.get_return_status_disable;
74: hr_utility.set_location(' Leaving:' || l_proc,20);
75: --
76: exception
77: when hr_multi_message.error_message_exist then
78: --
85: -- Reset IN OUT parameters and set OUT parameters
86: --
87: p_object_version_number := null;
88: p_return_status := hr_multi_message.get_return_status_disable;
89: hr_utility.set_location(' Leaving:' || l_proc, 30);
90: when others then
91: --
92: -- When Multiple Message Detection is enabled catch
93: -- any Application specific or other unexpected
96: -- error.
97: --
98: rollback to create_txn_cat_document_swi;
99: if hr_multi_message.unexpected_error_add(l_proc) then
100: hr_utility.set_location(' Leaving:' || l_proc,40);
101: raise;
102: end if;
103: --
104: -- Reset IN OUT and set OUT parameters
104: -- Reset IN OUT and set OUT parameters
105: --
106: p_object_version_number := null;
107: p_return_status := hr_multi_message.get_return_status_disable;
108: hr_utility.set_location(' Leaving:' || l_proc,50);
109: end create_txn_cat_document;
110: -- ----------------------------------------------------------------------------
111: -- |------------------------< delete_txn_cat_document >-----------------------|
112: -- ----------------------------------------------------------------------------
125: --
126: -- Other variables
127: l_proc varchar2(72) := g_package ||'delete_txn_cat_document';
128: Begin
129: hr_utility.set_location(' Entering:' || l_proc,10);
130: --
131: -- Issue a savepoint
132: --
133: savepoint delete_txn_cat_document_swi;
168: -- messages of any type exist in the Multiple Message List.
169: -- Also disable Multiple Message Detection.
170: --
171: p_return_status := hr_multi_message.get_return_status_disable;
172: hr_utility.set_location(' Leaving:' || l_proc,20);
173: --
174: exception
175: when hr_multi_message.error_message_exist then
176: --
182: --
183: -- Reset IN OUT parameters and set OUT parameters
184: --
185: p_return_status := hr_multi_message.get_return_status_disable;
186: hr_utility.set_location(' Leaving:' || l_proc, 30);
187: when others then
188: --
189: -- When Multiple Message Detection is enabled catch
190: -- any Application specific or other unexpected
193: -- error.
194: --
195: rollback to delete_txn_cat_document_swi;
196: if hr_multi_message.unexpected_error_add(l_proc) then
197: hr_utility.set_location(' Leaving:' || l_proc,40);
198: raise;
199: end if;
200: --
201: -- Reset IN OUT and set OUT parameters
200: --
201: -- Reset IN OUT and set OUT parameters
202: --
203: p_return_status := hr_multi_message.get_return_status_disable;
204: hr_utility.set_location(' Leaving:' || l_proc,50);
205: end delete_txn_cat_document;
206: --- svorugan--
207:
208: -- ----------------------------------------------------------------------------
230: from pqh_txn_category_documents
231: where transaction_category_id = p_transaction_category_id;
232:
233: Begin
234: hr_utility.set_location(' Entering:' || l_proc,10);
235: --
236: -- Issue a savepoint
237: --
238: savepoint delete_txn_cat_document_swi;
288: -- messages of any type exist in the Multiple Message List.
289: -- Also disable Multiple Message Detection.
290: --
291: p_return_status := hr_multi_message.get_return_status_disable;
292: hr_utility.set_location(' Leaving:' || l_proc,20);
293: --
294: exception
295: when hr_multi_message.error_message_exist then
296: --
302: --
303: -- Reset IN OUT parameters and set OUT parameters
304: --
305: p_return_status := hr_multi_message.get_return_status_disable;
306: hr_utility.set_location(' Leaving:' || l_proc, 30);
307: when others then
308: --
309: -- When Multiple Message Detection is enabled catch
310: -- any Application specific or other unexpected
313: -- error.
314: --
315: rollback to delete_txn_cat_document_swi;
316: if hr_multi_message.unexpected_error_add(l_proc) then
317: hr_utility.set_location(' Leaving:' || l_proc,40);
318: raise;
319: end if;
320: --
321: -- Reset IN OUT and set OUT parameters
320: --
321: -- Reset IN OUT and set OUT parameters
322: --
323: p_return_status := hr_multi_message.get_return_status_disable;
324: hr_utility.set_location(' Leaving:' || l_proc,50);
325: end delete_group;
326: -- ----------------------------------------------------------------------------
327:
328:
348: --
349: -- Other variables
350: l_proc varchar2(72) := g_package ||'update_txn_cat_document';
351: Begin
352: hr_utility.set_location(' Entering:' || l_proc,10);
353: --
354: -- Issue a savepoint
355: --
356: savepoint update_txn_cat_document_swi;
394: -- messages of any type exist in the Multiple Message List.
395: -- Also disable Multiple Message Detection.
396: --
397: p_return_status := hr_multi_message.get_return_status_disable;
398: hr_utility.set_location(' Leaving:' || l_proc,20);
399: --
400: exception
401: when hr_multi_message.error_message_exist then
402: --
409: -- Reset IN OUT parameters and set OUT parameters
410: --
411: p_object_version_number := l_object_version_number;
412: p_return_status := hr_multi_message.get_return_status_disable;
413: hr_utility.set_location(' Leaving:' || l_proc, 30);
414: when others then
415: --
416: -- When Multiple Message Detection is enabled catch
417: -- any Application specific or other unexpected
420: -- error.
421: --
422: rollback to update_txn_cat_document_swi;
423: if hr_multi_message.unexpected_error_add(l_proc) then
424: hr_utility.set_location(' Leaving:' || l_proc,40);
425: raise;
426: end if;
427: --
428: -- Reset IN OUT and set OUT parameters
428: -- Reset IN OUT and set OUT parameters
429: --
430: p_object_version_number := l_object_version_number;
431: p_return_status := hr_multi_message.get_return_status_disable;
432: hr_utility.set_location(' Leaving:' || l_proc,50);
433: end update_txn_cat_document;
434: end pqh_txn_cat_documents_swi;