DBA Data[Home] [Help]

APPS.PER_REQUISITIONS_SWI dependencies on HR_UTILITY

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

61: -- Other variables
62: l_requisition_id number;
63: l_proc varchar2(72) := g_package ||'create_requisition';
64: Begin
65: hr_utility.set_location(' Entering:' || l_proc,10);
66: --
67: -- Issue a savepoint
68: --
69: savepoint create_requisition_swi;

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

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

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

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

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

170: -- the error.
171: --
172: rollback to create_requisition_swi;
173: if hr_multi_message.unexpected_error_add(l_proc) then
174: hr_utility.set_location(' Leaving:' || l_proc, 40);
175: raise;
176: end if;
177: --
178: -- Reset IN OUT parameters and set OUT parameters

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

178: -- Reset IN OUT parameters and set OUT parameters
179: --
180: p_object_version_number := null;
181: p_return_status := hr_multi_message.get_return_status_disable;
182: hr_utility.set_location(' Leaving: ' || l_proc, 50);
183: end create_requisition;
184: -- ----------------------------------------------------------------------------
185: -- |--------------------------< update_requisition >--------------------------|
186: -- ----------------------------------------------------------------------------

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

235: --
236: -- Other variables
237: l_proc varchar2(72) := g_package ||'update_requisition';
238: Begin
239: hr_utility.set_location(' Entering:' || l_proc,10);
240: --
241: -- Issue a savepoint
242: --
243: savepoint update_requisition_swi;

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

314: -- messages of any type exist in the Multiple Message List.
315: -- Also disable Multiple Message Detection.
316: --
317: p_return_status := hr_multi_message.get_return_status_disable;
318: hr_utility.set_location(' Leaving:' || l_proc,20);
319: --
320: exception
321: when hr_multi_message.error_message_exist then
322: --

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

329: -- Reset IN OUT paramters and set OUT parameters
330: --
331: p_object_version_number := l_object_version_number;
332: p_return_status := hr_multi_message.get_return_status_disable;
333: hr_utility.set_location(' Leaving:' || l_proc,30);
334: when others then
335: --
336: -- When Multiple Message Detection is enabled catch
337: -- any Application specific or other unexpected

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

340: -- the error.
341: --
342: rollback to update_requisition_swi;
343: if hr_multi_message.unexpected_error_add(l_proc) then
344: hr_utility.set_location(' Leaving:' || l_proc, 40);
345: raise;
346: end if;
347: --
348: -- Reset IN OUT parameters and set OUT parameters

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

348: -- Reset IN OUT parameters and set OUT parameters
349: --
350: p_object_version_number := l_object_version_number;
351: p_return_status := hr_multi_message.get_return_status_disable;
352: hr_utility.set_location(' Leaving: ' || l_proc, 50);
353: end update_requisition;
354: -- ----------------------------------------------------------------------------
355: -- |--------------------------< delete_requisition >--------------------------|
356: -- ----------------------------------------------------------------------------

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

368: --
369: -- Other variables
370: l_proc varchar2(72) := g_package ||'delete_requisition';
371: Begin
372: hr_utility.set_location(' Entering:' || l_proc,10);
373: --
374: -- Issue a savepoint
375: --
376: savepoint delete_requisition_swi;

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

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

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

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

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

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

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

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

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

470: l_effective_date date := trunc(sysdate);
471:
472: BEGIN
473: --
474: hr_utility.set_location(' Entering:' || l_proc,10);
475: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
476: --
477: l_parser := xmlparser.newParser;
478: xmlparser.ParseCLOB(l_parser,p_document);

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

471:
472: BEGIN
473: --
474: hr_utility.set_location(' Entering:' || l_proc,10);
475: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
476: --
477: l_parser := xmlparser.newParser;
478: xmlparser.ParseCLOB(l_parser,p_document);
479: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

477: l_parser := xmlparser.newParser;
478: xmlparser.ParseCLOB(l_parser,p_document);
479: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
480: --
481: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
482:
483: l_commitElement := xmldom.makeElement(l_CommitNode);
484: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
485: --

Line 499: hr_utility.set_location('creating :' || l_proc,30);

495: end if;
496: --
497: if l_postState = '0' then
498: --
499: hr_utility.set_location('creating :' || l_proc,30);
500: --
501: create_requisition
502: (p_validate => p_validate
503: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',NULL)

Line 548: hr_utility.set_location('updating :' || l_proc,32);

544: );
545: --
546: elsif l_postState = '2' then
547: --
548: hr_utility.set_location('updating :' || l_proc,32);
549: --
550: update_requisition
551: (p_validate => p_validate
552: ,p_requisition_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequisitionId',NULL)

Line 595: hr_utility.set_location('deleting :' || l_proc,33);

591: );
592: --
593: elsif l_postState = '3' then
594: --
595: hr_utility.set_location('deleting :' || l_proc,33);
596: --
597: delete_requisition
598: (p_validate => p_validate
599: ,p_object_version_number => l_object_version_number

Line 608: hr_utility.set_location

604: end if;
605:
606: p_return_status := l_return_status;
607:
608: hr_utility.set_location
609: ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
610:
611: end process_api;
612: --