eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_AGENCY_VACANCIES_SWI dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

343: -- error.
344: --
345: rollback to update_agency_vacancy_swi;
346: if hr_multi_message.unexpected_error_add(l_proc) then
347: hr_utility.set_location(' Leaving:' || l_proc,40);
348: raise;
349: end if;
350: --
351: -- Reset IN OUT and set OUT parameters

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

352: --
353: p_object_version_number := l_object_version_number;
354:
355: p_return_status := hr_multi_message.get_return_status_disable;
356: hr_utility.set_location(' Leaving:' || l_proc,50);
357: end update_agency_vacancy;
358: -- ----------------------------------------------------------------------------
359: -- |-------------------------< delete_agency_vacancy >------------------------|
360: -- ----------------------------------------------------------------------------

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

378: select object_version_number
379: from irc_agency_vacancies
380: where agency_vacancy_id = p_agency_vacancy_id;
381: Begin
382: hr_utility.set_location(' Entering:' || l_proc,10);
383: --
384: -- Issue a savepoint
385: --
386: savepoint delete_agency_vacancy_swi;

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

427: -- messages of any type exist in the Multiple Message List.
428: -- Also disable Multiple Message Detection.
429: --
430: p_return_status := hr_multi_message.get_return_status_disable;
431: hr_utility.set_location(' Leaving:' || l_proc,20);
432: --
433: exception
434: when hr_multi_message.error_message_exist then
435: --

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

441: --
442: -- Reset IN OUT parameters and set OUT parameters
443: --
444: p_return_status := hr_multi_message.get_return_status_disable;
445: hr_utility.set_location(' Leaving:' || l_proc, 30);
446: when others then
447: --
448: -- When Multiple Message Detection is enabled catch
449: -- any Application specific or other unexpected

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

452: -- error.
453: --
454: rollback to delete_agency_vacancy_swi;
455: if hr_multi_message.unexpected_error_add(l_proc) then
456: hr_utility.set_location(' Leaving:' || l_proc,40);
457: raise;
458: end if;
459: --
460: -- Reset IN OUT and set OUT parameters

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

459: --
460: -- Reset IN OUT and set OUT parameters
461: --
462: p_return_status := hr_multi_message.get_return_status_disable;
463: hr_utility.set_location(' Leaving:' || l_proc,50);
464: end delete_agency_vacancy;
465: --
466: -- ----------------------------------------------------------------------------
467: -- |----------------------------< process_api >-------------------------------|

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

487: l_effective_date date := trunc(sysdate);
488:
489: BEGIN
490: --
491: hr_utility.set_location(' Entering:' || l_proc,10);
492: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
493: --
494: l_parser := xmlparser.newParser;
495: xmlparser.ParseCLOB(l_parser,p_document);

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

488:
489: BEGIN
490: --
491: hr_utility.set_location(' Entering:' || l_proc,10);
492: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
493: --
494: l_parser := xmlparser.newParser;
495: xmlparser.ParseCLOB(l_parser,p_document);
496: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

494: l_parser := xmlparser.newParser;
495: xmlparser.ParseCLOB(l_parser,p_document);
496: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
497: --
498: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
499:
500: l_commitElement := xmldom.makeElement(l_CommitNode);
501: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
502: --

Line 516: hr_utility.set_location('Extracting the PostState:' || l_proc,31);

512: end if;
513: --
514: if l_postState = '0' then
515: --
516: hr_utility.set_location('Extracting the PostState:' || l_proc,31);
517: --
518: create_agency_vacancy
519: (p_validate => p_validate
520: ,p_agency_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AgencyId',NULL)

Line 564: hr_utility.set_location('Extracting the PostState:' || l_proc,32);

560: );
561: --
562: elsif l_postState = '2' then
563: --
564: hr_utility.set_location('Extracting the PostState:' || l_proc,32);
565: --
566: update_agency_vacancy
567: (p_validate => p_validate
568: ,p_agency_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AgencyVacancyId',NULL)

Line 612: hr_utility.set_location('Extracting the PostState:' || l_proc,33);

608: );
609: --
610: elsif l_postState = '3' then
611: --
612: hr_utility.set_location('Extracting the PostState:' || l_proc,33);
613: --
614: delete_agency_vacancy
615: (p_validate => p_validate
616: ,p_object_version_number => l_object_version_number

Line 624: hr_utility.set_location

620: --
621: end if;
622:
623: p_return_status := l_return_status;
624: hr_utility.set_location
625: ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
626:
627: --
628: end process_api;