26: -- Other variables
27: l_quest_answer_val_id number;
28: l_proc varchar2(72) := g_package ||'insert_quest_answer_val';
29: Begin
30: hr_utility.set_location(' Entering:' || l_proc,10);
31: --
32: -- Issue a savepoint
33: --
34: savepoint insert_quest_answer_val;
79: rollback to insert_quest_answer_val;
80: End If;
81: --
82: p_return_status := hr_multi_message.get_return_status_disable;
83: hr_utility.set_location(' Leaving:' || l_proc,20);
84: --
85: exception
86: when hr_multi_message.error_message_exist then
87: --
94: -- Reset IN OUT parameters and set OUT parameters
95: --
96: p_object_version_number := null;
97: p_return_status := hr_multi_message.get_return_status_disable;
98: hr_utility.set_location(' Leaving:' || l_proc, 30);
99: when others then
100: --
101: -- When Multiple Message Detection is enabled catch
102: -- any Application specific or other unexpected
105: -- error.
106: --
107: rollback to insert_quest_answer_val;
108: if hr_multi_message.unexpected_error_add(l_proc) then
109: hr_utility.set_location(' Leaving:' || l_proc,40);
110: raise;
111: end if;
112: --
113: -- Reset IN OUT and set OUT parameters
113: -- Reset IN OUT and set OUT parameters
114: --
115: p_object_version_number := null;
116: p_return_status := hr_multi_message.get_return_status_disable;
117: hr_utility.set_location(' Leaving:' || l_proc,50);
118: end insert_quest_answer_val;
119: -- ----------------------------------------------------------------------------
120: -- |--------------------------< set_base_key_value >--------------------------|
121: -- ----------------------------------------------------------------------------
130: --
131: -- Other variables
132: l_proc varchar2(72) := g_package ||'set_base_key_value';
133: Begin
134: hr_utility.set_location(' Entering:' || l_proc,10);
135: --
136: -- Issue a savepoint
137: --
138: savepoint set_base_key_value_swi;
167: -- messages of any type exist in the Multiple Message List.
168: -- Also disable Multiple Message Detection.
169: --
170: p_return_status := hr_multi_message.get_return_status_disable;
171: hr_utility.set_location(' Leaving:' || l_proc,20);
172: --
173: exception
174: when hr_multi_message.error_message_exist then
175: --
181: --
182: -- Reset IN OUT parameters and set OUT parameters
183: --
184: p_return_status := hr_multi_message.get_return_status_disable;
185: hr_utility.set_location(' Leaving:' || l_proc, 30);
186: when others then
187: --
188: -- When Multiple Message Detection is enabled catch
189: -- any Application specific or other unexpected
192: -- error.
193: --
194: rollback to set_base_key_value_swi;
195: if hr_multi_message.unexpected_error_add(l_proc) then
196: hr_utility.set_location(' Leaving:' || l_proc,40);
197: raise;
198: end if;
199: --
200: -- Reset IN OUT and set OUT parameters
199: --
200: -- Reset IN OUT and set OUT parameters
201: --
202: p_return_status := hr_multi_message.get_return_status_disable;
203: hr_utility.set_location(' Leaving:' || l_proc,50);
204: end set_base_key_value;
205: --
206: --
207: -- ----------------------------------------------------------------------------
221: --
222: -- Other variables
223: l_proc varchar2(72) := g_package ||'delete_quest_answer_val';
224: Begin
225: hr_utility.set_location(' Entering:' || l_proc,10);
226: --
227: -- Issue a savepoint
228: --
229: savepoint delete_quest_answer_val;
266: rollback to delete_quest_answer_val;
267: End If;
268: --
269: p_return_status := hr_multi_message.get_return_status_disable;
270: hr_utility.set_location(' Leaving:' || l_proc,20);
271: --
272: exception
273: when hr_multi_message.error_message_exist then
274: --
280: --
281: -- Reset IN OUT parameters and set OUT parameters
282: --
283: p_return_status := hr_multi_message.get_return_status_disable;
284: hr_utility.set_location(' Leaving:' || l_proc, 30);
285: when others then
286: --
287: -- When Multiple Message Detection is enabled catch
288: -- any Application specific or other unexpected
291: -- error.
292: --
293: rollback to delete_quest_answer_val;
294: if hr_multi_message.unexpected_error_add(l_proc) then
295: hr_utility.set_location(' Leaving:' || l_proc,40);
296: raise;
297: end if;
298: --
299: -- Reset IN OUT and set OUT parameters
298: --
299: -- Reset IN OUT and set OUT parameters
300: --
301: p_return_status := hr_multi_message.get_return_status_disable;
302: hr_utility.set_location(' Leaving:' || l_proc,50);
303: end delete_quest_answer_val;
304: --
305: -- ----------------------------------------------------------------------------
306: -- |------------------------< update_quest_answer_val >-----------------------|
321: --
322: -- Other variables
323: l_proc varchar2(72) := g_package ||'update_quest_answer_val';
324: Begin
325: hr_utility.set_location(' Entering:' || l_proc,10);
326: --
327: -- Issue a savepoint
328: --
329: savepoint update_quest_answer_val;
368: rollback to update_quest_answer_val;
369: End If;
370: --
371: p_return_status := hr_multi_message.get_return_status_disable;
372: hr_utility.set_location(' Leaving:' || l_proc,20);
373: --
374: exception
375: when hr_multi_message.error_message_exist then
376: --
383: -- Reset IN OUT parameters and set OUT parameters
384: --
385: p_object_version_number := l_object_version_number;
386: p_return_status := hr_multi_message.get_return_status_disable;
387: hr_utility.set_location(' Leaving:' || l_proc, 30);
388: when others then
389: --
390: -- When Multiple Message Detection is enabled catch
391: -- any Application specific or other unexpected
394: -- error.
395: --
396: rollback to update_quest_answer_val;
397: if hr_multi_message.unexpected_error_add(l_proc) then
398: hr_utility.set_location(' Leaving:' || l_proc,40);
399: raise;
400: end if;
401: --
402: -- Reset IN OUT and set OUT parameters
402: -- Reset IN OUT and set OUT parameters
403: --
404: p_object_version_number := l_object_version_number;
405: p_return_status := hr_multi_message.get_return_status_disable;
406: hr_utility.set_location(' Leaving:' || l_proc,50);
407: end update_quest_answer_val;
408:
409: -- ----------------------------------------------------------------------------
410: -- |---------------------------< process_api >--------------------------------|
427: l_proc varchar2(72) := g_package || 'process_api';
428:
429: BEGIN
430:
431: hr_utility.set_location(' Entering:' || l_proc,10);
432: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
433:
434: l_parser := xmlparser.newParser;
435: xmlparser.ParseCLOB(l_parser,p_document);
428:
429: BEGIN
430:
431: hr_utility.set_location(' Entering:' || l_proc,10);
432: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
433:
434: l_parser := xmlparser.newParser;
435: xmlparser.ParseCLOB(l_parser,p_document);
436: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
434: l_parser := xmlparser.newParser;
435: xmlparser.ParseCLOB(l_parser,p_document);
436: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
437:
438: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
439:
440: l_commitElement := xmldom.makeElement(l_CommitNode);
441: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
442: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
475: p_return_status := l_return_status;
476:
477: end if;
478:
479: hr_utility.set_location('Exiting:' || l_proc,40);
480:
481: END process_api;
482:
483: end hr_quest_ans_val_swi;