71: -- Other variables
72: l_comp_element_outcome_id number;
73: l_proc varchar2(72) := g_package ||'create_element_outcome';
74: Begin
75: hr_utility.set_location(' Entering:' || l_proc,10);
76: --
77: -- Issue a savepoint
78: --
79: savepoint create_element_outcome_swi;
172: -- messages of any type exist in the Multiple Message List.
173: -- Also disable Multiple Message Detection.
174: --
175: p_return_status := hr_multi_message.get_return_status_disable;
176: hr_utility.set_location(' Leaving:' || l_proc,20);
177: --
178: exception
179: when hr_multi_message.error_message_exist then
180: --
187: -- Reset IN OUT parameters and set OUT parameters
188: --
189: p_object_version_number := null;
190: p_return_status := hr_multi_message.get_return_status_disable;
191: hr_utility.set_location(' Leaving:' || l_proc, 30);
192: when others then
193: --
194: -- When Multiple Message Detection is enabled catch
195: -- any Application specific or other unexpected
198: -- error.
199: --
200: rollback to create_element_outcome_swi;
201: if hr_multi_message.unexpected_error_add(l_proc) then
202: hr_utility.set_location(' Leaving:' || l_proc,40);
203: raise;
204: end if;
205: --
206: -- Reset IN OUT and set OUT parameters
206: -- Reset IN OUT and set OUT parameters
207: --
208: p_object_version_number := null;
209: p_return_status := hr_multi_message.get_return_status_disable;
210: hr_utility.set_location(' Leaving:' || l_proc,50);
211: end create_element_outcome;
212: -- ----------------------------------------------------------------------------
213: -- |------------------------< update_element_outcome >------------------------|
214: -- ----------------------------------------------------------------------------
279: l_effective_date_to date;
280: l_datetrack_update_mode varchar2(10);
281: l_proc varchar2(72) := g_package ||'update_element_outcome';
282: Begin
283: hr_utility.set_location(' Entering:' || l_proc,10);
284: --
285: -- Issue a savepoint
286: --
287: savepoint update_element_outcome_swi;
502: -- messages of any type exist in the Multiple Message List.
503: -- Also disable Multiple Message Detection.
504: --
505: p_return_status := hr_multi_message.get_return_status_disable;
506: hr_utility.set_location(' Leaving:' || l_proc,20);
507: --
508: exception
509: when hr_multi_message.error_message_exist then
510: --
517: -- Reset IN OUT parameters and set OUT parameters
518: --
519: p_object_version_number := l_object_version_number;
520: p_return_status := hr_multi_message.get_return_status_disable;
521: hr_utility.set_location(' Leaving:' || l_proc, 30);
522: when others then
523: --
524: -- When Multiple Message Detection is enabled catch
525: -- any Application specific or other unexpected
528: -- error.
529: --
530: rollback to update_element_outcome_swi;
531: if hr_multi_message.unexpected_error_add(l_proc) then
532: hr_utility.set_location(' Leaving:' || l_proc,40);
533: raise;
534: end if;
535: --
536: -- Reset IN OUT and set OUT parameters
536: -- Reset IN OUT and set OUT parameters
537: --
538: p_object_version_number := l_object_version_number;
539: p_return_status := hr_multi_message.get_return_status_disable;
540: hr_utility.set_location(' Leaving:' || l_proc,50);
541: end update_element_outcome;
542: -- ----------------------------------------------------------------------------
543: -- |------------------------< delete_element_outcome >------------------------|
544: -- ----------------------------------------------------------------------------
557: --
558: -- Other variables
559: l_proc varchar2(72) := g_package ||'delete_element_outcome';
560: Begin
561: hr_utility.set_location(' Entering:' || l_proc,10);
562: --
563: -- Issue a savepoint
564: --
565: savepoint delete_element_outcome_swi;
600: -- messages of any type exist in the Multiple Message List.
601: -- Also disable Multiple Message Detection.
602: --
603: p_return_status := hr_multi_message.get_return_status_disable;
604: hr_utility.set_location(' Leaving:' || l_proc,20);
605: --
606: exception
607: when hr_multi_message.error_message_exist then
608: --
615: -- Reset IN OUT parameters and set OUT parameters
616: --
617: p_object_version_number := l_object_version_number;
618: p_return_status := hr_multi_message.get_return_status_disable;
619: hr_utility.set_location(' Leaving:' || l_proc, 30);
620: when others then
621: --
622: -- When Multiple Message Detection is enabled catch
623: -- any Application specific or other unexpected
626: -- error.
627: --
628: rollback to delete_element_outcome_swi;
629: if hr_multi_message.unexpected_error_add(l_proc) then
630: hr_utility.set_location(' Leaving:' || l_proc,40);
631: raise;
632: end if;
633: --
634: -- Reset IN OUT and set OUT parameters
634: -- Reset IN OUT and set OUT parameters
635: --
636: p_object_version_number := l_object_version_number;
637: p_return_status := hr_multi_message.get_return_status_disable;
638: hr_utility.set_location(' Leaving:' || l_proc,50);
639: end delete_element_outcome;
640:
641: Procedure process_api
642: ( p_document in CLOB
654: l_proc varchar2(72) := g_package || 'process_api';
655:
656: BEGIN
657:
658: hr_utility.set_location(' Entering:' || l_proc,10);
659: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
660:
661: l_parser := xmlparser.newParser;
662: xmlparser.ParseCLOB(l_parser,p_document);
655:
656: BEGIN
657:
658: hr_utility.set_location(' Entering:' || l_proc,10);
659: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
660:
661: l_parser := xmlparser.newParser;
662: xmlparser.ParseCLOB(l_parser,p_document);
663: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
661: l_parser := xmlparser.newParser;
662: xmlparser.ParseCLOB(l_parser,p_document);
663: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
664:
665: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
666:
667: l_commitElement := xmldom.makeElement(l_CommitNode);
668: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
669: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
791: end if;
792:
793: p_return_status := l_return_status;
794:
795: hr_utility.set_location('Exiting:' || l_proc,40);
796:
797:
798: END process_api;
799: