DBA Data[Home] [Help]

APPS.HR_QUEST_ANS_VAL_SWI dependencies on HR_UTILITY

Line 30: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 83: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 98: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 109: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 117: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ----------------------------------------------------------------------------

Line 134: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 171: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 185: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 196: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 203: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ----------------------------------------------------------------------------

Line 225: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 270: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 284: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 295: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 302: hr_utility.set_location(' Leaving:' || l_proc,50);

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 >-----------------------|

Line 325: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 372: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 387: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 398: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 406: hr_utility.set_location(' Leaving:' || l_proc,50);

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 >--------------------------------|

Line 431: hr_utility.set_location(' Entering:' || l_proc,10);

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);

Line 432: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);

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)));

Line 438: hr_utility.set_location('Extracting the PostState:' || l_proc,20);

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');

Line 479: hr_utility.set_location('Exiting:' || l_proc,40);

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;