DBA Data[Home] [Help]

APPS.HR_QUEST_ANSWER_SWI dependencies on HR_UTILITY

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

27: -- Other variables
28: l_questionnaire_answer_id number;
29: l_proc varchar2(72) := g_package || 'create_quest_answer';
30: Begin
31: hr_utility.set_location(' Entering:' || l_proc,10);
32: --
33: -- Issue a savepoint
34: --
35: savepoint create_quest_answer;

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

81: rollback to create_quest_answer;
82: End If;
83: --
84: p_return_status := hr_multi_message.get_return_status_disable;
85: hr_utility.set_location(' Leaving:' || l_proc,20);
86: --
87: exception
88: when hr_multi_message.error_message_exist then
89: --

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

95: --
96: -- Reset IN OUT parameters and set OUT parameters
97: --
98: p_return_status := hr_multi_message.get_return_status_disable;
99: hr_utility.set_location(' Leaving:' || l_proc, 30);
100: when others then
101: --
102: -- When Multiple Message Detection is enabled catch
103: -- any Application specific or other unexpected

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

106: -- error.
107: --
108: rollback to create_quest_answer;
109: if hr_multi_message.unexpected_error_add(l_proc) then
110: hr_utility.set_location(' Leaving:' || l_proc,40);
111: raise;
112: end if;
113: --
114: -- Reset IN OUT and set OUT parameters

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

113: --
114: -- Reset IN OUT and set OUT parameters
115: --
116: p_return_status := hr_multi_message.get_return_status_disable;
117: hr_utility.set_location(' Leaving:' || l_proc,50);
118: end create_quest_answer;
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: -- |-------------------------< update_quest_answer >--------------------------|

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

224: --
225: -- Other variables
226: l_proc varchar2(72) := g_package ||'update_quest_answer';
227: Begin
228: hr_utility.set_location(' Entering:' || l_proc,10);
229: --
230: -- Issue a savepoint
231: --
232: savepoint update_quest_answer;

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

273: rollback to update_quest_answer;
274: End If;
275: --
276: p_return_status := hr_multi_message.get_return_status_disable;
277: hr_utility.set_location(' Leaving:' || l_proc,20);
278: --
279: exception
280: when hr_multi_message.error_message_exist then
281: --

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

287: --
288: -- Reset IN OUT parameters and set OUT parameters
289: --
290: p_return_status := hr_multi_message.get_return_status_disable;
291: hr_utility.set_location(' Leaving:' || l_proc, 30);
292: when others then
293: --
294: -- When Multiple Message Detection is enabled catch
295: -- any Application specific or other unexpected

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

298: -- error.
299: --
300: rollback to update_quest_answer;
301: if hr_multi_message.unexpected_error_add(l_proc) then
302: hr_utility.set_location(' Leaving:' || l_proc,40);
303: raise;
304: end if;
305: --
306: -- Reset IN OUT and set OUT parameters

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

305: --
306: -- Reset IN OUT and set OUT parameters
307: --
308: p_return_status := hr_multi_message.get_return_status_disable;
309: hr_utility.set_location(' Leaving:' || l_proc,50);
310: end update_quest_answer;
311: --
312: -- ----------------------------------------------------------------------------
313: -- |--------------------------< delete_quest_answer >-------------------------|

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

325: --
326: -- Other variables
327: l_proc varchar2(72) := g_package || 'delete_quest_answer';
328: Begin
329: hr_utility.set_location(' Entering:' || l_proc,10);
330: --
331: -- Issue a savepoint
332: --
333: savepoint delete_quest_answer;

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

369: rollback to delete_quest_answer;
370: End If;
371: --
372: p_return_status := hr_multi_message.get_return_status_disable;
373: hr_utility.set_location(' Leaving:' || l_proc,20);
374: --
375: exception
376: when hr_multi_message.error_message_exist then
377: --

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

383: --
384: -- Reset IN OUT parameters and set OUT parameters
385: --
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 delete_quest_answer;
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 405: hr_utility.set_location(' Leaving:' || l_proc,50);

401: --
402: -- Reset IN OUT and set OUT parameters
403: --
404: p_return_status := hr_multi_message.get_return_status_disable;
405: hr_utility.set_location(' Leaving:' || l_proc,50);
406: end delete_quest_answer;
407:
408: -- ----------------------------------------------------------------------------
409: -- |---------------------------< process_api >--------------------------------|

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

426: l_proc varchar2(72) := g_package || 'process_api';
427:
428: BEGIN
429:
430: hr_utility.set_location(' Entering:' || l_proc,10);
431: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
432:
433: l_parser := xmlparser.newParser;
434: xmlparser.ParseCLOB(l_parser,p_document);

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

427:
428: BEGIN
429:
430: hr_utility.set_location(' Entering:' || l_proc,10);
431: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
432:
433: l_parser := xmlparser.newParser;
434: xmlparser.ParseCLOB(l_parser,p_document);
435: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

433: l_parser := xmlparser.newParser;
434: xmlparser.ParseCLOB(l_parser,p_document);
435: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
436:
437: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
438:
439: l_commitElement := xmldom.makeElement(l_CommitNode);
440: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
441:

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

476: p_return_status := l_return_status;
477:
478: end if;
479:
480: hr_utility.set_location('Exiting:' || l_proc,40);
481:
482: END process_api;
483:
484: end hr_quest_answer_swi;