DBA Data[Home] [Help]

APPS.HR_ASSESSMENTS_SWI dependencies on HR_UTILITY

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

59: --
60: -- Other variables
61: l_proc varchar2(72) := g_package ||'create_assessment';
62: Begin
63: hr_utility.set_location(' Entering:' || l_proc,10);
64: --
65: -- Issue a savepoint
66: --
67: savepoint create_assessment_swi;

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

140: -- messages of any type exist in the Multiple Message List.
141: -- Also disable Multiple Message Detection.
142: --
143: p_return_status := hr_multi_message.get_return_status_disable;
144: hr_utility.set_location(' Leaving:' || l_proc,20);
145: --
146: exception
147: when hr_multi_message.error_message_exist then
148: --

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

155: -- Reset IN OUT parameters and set OUT parameters
156: --
157: p_object_version_number := null;
158: p_return_status := hr_multi_message.get_return_status_disable;
159: hr_utility.set_location(' Leaving:' || l_proc, 30);
160: when others then
161: --
162: -- When Multiple Message Detection is enabled catch
163: -- any Application specific or other unexpected

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

166: -- error.
167: --
168: rollback to create_assessment_swi;
169: if hr_multi_message.unexpected_error_add(l_proc) then
170: hr_utility.set_location(' Leaving:' || l_proc,40);
171: raise;
172: end if;
173: --
174: -- Reset IN OUT and set OUT parameters

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

174: -- Reset IN OUT and set OUT parameters
175: --
176: p_object_version_number := null;
177: p_return_status := hr_multi_message.get_return_status_disable;
178: hr_utility.set_location(' Leaving:' || l_proc,50);
179: end create_assessment;
180: -- ----------------------------------------------------------------------------
181: -- |---------------------------< delete_assessment >--------------------------|
182: -- ----------------------------------------------------------------------------

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

194: --
195: -- Other variables
196: l_proc varchar2(72) := g_package ||'delete_assessment';
197: Begin
198: hr_utility.set_location(' Entering:' || l_proc,10);
199: --
200: -- Issue a savepoint
201: --
202: savepoint delete_assessment_swi;

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

236: -- messages of any type exist in the Multiple Message List.
237: -- Also disable Multiple Message Detection.
238: --
239: p_return_status := hr_multi_message.get_return_status_disable;
240: hr_utility.set_location(' Leaving:' || l_proc,20);
241: --
242: exception
243: when hr_multi_message.error_message_exist then
244: --

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

250: --
251: -- Reset IN OUT parameters and set OUT parameters
252: --
253: p_return_status := hr_multi_message.get_return_status_disable;
254: hr_utility.set_location(' Leaving:' || l_proc, 30);
255: when others then
256: --
257: -- When Multiple Message Detection is enabled catch
258: -- any Application specific or other unexpected

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

261: -- error.
262: --
263: rollback to delete_assessment_swi;
264: if hr_multi_message.unexpected_error_add(l_proc) then
265: hr_utility.set_location(' Leaving:' || l_proc,40);
266: raise;
267: end if;
268: --
269: -- Reset IN OUT and set OUT parameters

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

268: --
269: -- Reset IN OUT and set OUT parameters
270: --
271: p_return_status := hr_multi_message.get_return_status_disable;
272: hr_utility.set_location(' Leaving:' || l_proc,50);
273: end delete_assessment;
274: -- ----------------------------------------------------------------------------
275: -- |---------------------------< update_assessment >--------------------------|
276: -- ----------------------------------------------------------------------------

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

322: l_proc varchar2(72) := g_package ||'update_assessment';
323: cursor csr_get_object_version_number is
324: select object_version_number from per_assessments where assessment_id = p_assessment_id;
325: Begin
326: hr_utility.set_location(' Entering:' || l_proc,10);
327: --
328: -- Issue a savepoint
329: --
330: savepoint update_assessment_swi;

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

407: -- messages of any type exist in the Multiple Message List.
408: -- Also disable Multiple Message Detection.
409: --
410: p_return_status := hr_multi_message.get_return_status_disable;
411: hr_utility.set_location(' Leaving:' || l_proc,20);
412: --
413: exception
414: when hr_multi_message.error_message_exist then
415: --

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

422: -- Reset IN OUT parameters and set OUT parameters
423: --
424: p_object_version_number := l_object_version_number;
425: p_return_status := hr_multi_message.get_return_status_disable;
426: hr_utility.set_location(' Leaving:' || l_proc, 30);
427: when others then
428: --
429: -- When Multiple Message Detection is enabled catch
430: -- any Application specific or other unexpected

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

433: -- error.
434: --
435: rollback to update_assessment_swi;
436: if hr_multi_message.unexpected_error_add(l_proc) then
437: hr_utility.set_location(' Leaving:' || l_proc,40);
438: raise;
439: end if;
440: --
441: -- Reset IN OUT and set OUT parameters

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

441: -- Reset IN OUT and set OUT parameters
442: --
443: p_object_version_number := l_object_version_number;
444: p_return_status := hr_multi_message.get_return_status_disable;
445: hr_utility.set_location(' Leaving:' || l_proc,50);
446: end update_assessment;
447:
448: -- ----------------------------------------------------------------------------
449: -- |---------------------------< process_api >--------------------------------|

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

465: l_object_version_number number;
466:
467: BEGIN
468:
469: hr_utility.set_location(' Entering:' || l_proc,10);
470: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
471:
472: l_parser := xmlparser.newParser;
473: xmlparser.ParseCLOB(l_parser,p_document);

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

466:
467: BEGIN
468:
469: hr_utility.set_location(' Entering:' || l_proc,10);
470: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
471:
472: l_parser := xmlparser.newParser;
473: xmlparser.ParseCLOB(l_parser,p_document);
474: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

472: l_parser := xmlparser.newParser;
473: xmlparser.ParseCLOB(l_parser,p_document);
474: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
475:
476: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
477:
478: l_commitElement := xmldom.makeElement(l_CommitNode);
479: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
480: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

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

575: p_return_status := l_return_status;
576:
577: end if;
578:
579: hr_utility.set_location('Exiting:' || l_proc,40);
580:
581: END process_api;
582: end hr_assessments_swi;