51: --
52: -- Other variables
53: l_proc varchar2(72) := g_package ||'create_performance_rating';
54: Begin
55: hr_utility.set_location(' Entering:' || l_proc,10);
56: --
57: -- Issue a savepoint
58: --
59: savepoint create_performance_rating_swi;
125: -- messages of any type exist in the Multiple Message List.
126: -- Also disable Multiple Message Detection.
127: --
128: p_return_status := hr_multi_message.get_return_status_disable;
129: hr_utility.set_location(' Leaving:' || l_proc,20);
130: --
131: exception
132: when hr_multi_message.error_message_exist then
133: --
140: -- Reset IN OUT parameters and set OUT parameters
141: --
142: p_object_version_number := null;
143: p_return_status := hr_multi_message.get_return_status_disable;
144: hr_utility.set_location(' Leaving:' || l_proc, 30);
145: when others then
146: --
147: -- When Multiple Message Detection is enabled catch
148: -- any Application specific or other unexpected
151: -- error.
152: --
153: rollback to create_performance_rating_swi;
154: if hr_multi_message.unexpected_error_add(l_proc) then
155: hr_utility.set_location(' Leaving:' || l_proc,40);
156: raise;
157: end if;
158: --
159: -- Reset IN OUT and set OUT parameters
159: -- Reset IN OUT and set OUT parameters
160: --
161: p_object_version_number := null;
162: p_return_status := hr_multi_message.get_return_status_disable;
163: hr_utility.set_location(' Leaving:' || l_proc,50);
164: end create_performance_rating;
165: -- ----------------------------------------------------------------------------
166: -- |-----------------------< delete_performance_rating >----------------------|
167: -- ----------------------------------------------------------------------------
179: --
180: -- Other variables
181: l_proc varchar2(72) := g_package ||'delete_performance_rating';
182: Begin
183: hr_utility.set_location(' Entering:' || l_proc,10);
184: --
185: -- Issue a savepoint
186: --
187: savepoint delete_performance_rating_swi;
221: -- messages of any type exist in the Multiple Message List.
222: -- Also disable Multiple Message Detection.
223: --
224: p_return_status := hr_multi_message.get_return_status_disable;
225: hr_utility.set_location(' Leaving:' || l_proc,20);
226: --
227: exception
228: when hr_multi_message.error_message_exist then
229: --
235: --
236: -- Reset IN OUT parameters and set OUT parameters
237: --
238: p_return_status := hr_multi_message.get_return_status_disable;
239: hr_utility.set_location(' Leaving:' || l_proc, 30);
240: when others then
241: --
242: -- When Multiple Message Detection is enabled catch
243: -- any Application specific or other unexpected
246: -- error.
247: --
248: rollback to delete_performance_rating_swi;
249: if hr_multi_message.unexpected_error_add(l_proc) then
250: hr_utility.set_location(' Leaving:' || l_proc,40);
251: raise;
252: end if;
253: --
254: -- Reset IN OUT and set OUT parameters
253: --
254: -- Reset IN OUT and set OUT parameters
255: --
256: p_return_status := hr_multi_message.get_return_status_disable;
257: hr_utility.set_location(' Leaving:' || l_proc,50);
258: end delete_performance_rating;
259: -- ----------------------------------------------------------------------------
260: -- |-----------------------< update_performance_rating >----------------------|
261: -- ----------------------------------------------------------------------------
302: --
303: -- Other variables
304: l_proc varchar2(72) := g_package ||'update_performance_rating';
305: Begin
306: hr_utility.set_location(' Entering:' || l_proc,10);
307: --
308: -- Issue a savepoint
309: --
310: savepoint update_performance_rating_swi;
373: -- messages of any type exist in the Multiple Message List.
374: -- Also disable Multiple Message Detection.
375: --
376: p_return_status := hr_multi_message.get_return_status_disable;
377: hr_utility.set_location(' Leaving:' || l_proc,20);
378: --
379: exception
380: when hr_multi_message.error_message_exist then
381: --
388: -- Reset IN OUT parameters and set OUT parameters
389: --
390: p_object_version_number := l_object_version_number;
391: p_return_status := hr_multi_message.get_return_status_disable;
392: hr_utility.set_location(' Leaving:' || l_proc, 30);
393: when others then
394: --
395: -- When Multiple Message Detection is enabled catch
396: -- any Application specific or other unexpected
399: -- error.
400: --
401: rollback to update_performance_rating_swi;
402: if hr_multi_message.unexpected_error_add(l_proc) then
403: hr_utility.set_location(' Leaving:' || l_proc,40);
404: raise;
405: end if;
406: --
407: -- Reset IN OUT and set OUT parameters
407: -- Reset IN OUT and set OUT parameters
408: --
409: p_object_version_number := l_object_version_number;
410: p_return_status := hr_multi_message.get_return_status_disable;
411: hr_utility.set_location(' Leaving:' || l_proc,50);
412: end update_performance_rating;
413:
414: -- ----------------------------------------------------------------------------
415: -- |---------------------------< process_api >--------------------------------|
431: l_proc varchar2(72) := g_package || 'process_api';
432:
433: BEGIN
434:
435: hr_utility.set_location(' Entering:' || l_proc,10);
436: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
437:
438: l_parser := xmlparser.newParser;
439: xmlparser.ParseCLOB(l_parser,p_document);
432:
433: BEGIN
434:
435: hr_utility.set_location(' Entering:' || l_proc,10);
436: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
437:
438: l_parser := xmlparser.newParser;
439: xmlparser.ParseCLOB(l_parser,p_document);
440: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
438: l_parser := xmlparser.newParser;
439: xmlparser.ParseCLOB(l_parser,p_document);
440: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
441:
442: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
443:
444: l_commitElement := xmldom.makeElement(l_CommitNode);
445: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
446: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
531: p_return_status := l_return_status;
532:
533: end if;
534:
535: hr_utility.set_location('Exiting:' || l_proc,40);
536:
537: END process_api;
538:
539: end hr_performance_ratings_swi;