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.PER_VACANCY_SWI dependencies on HR_UTILITY

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

80: -- Other variables
81: l_vacancy_id number;
82: l_proc varchar2(72) := g_package ||'create_vacancy';
83: Begin
84: hr_utility.set_location(' Entering:' || l_proc,10);
85: --
86: -- Issue a savepoint
87: --
88: savepoint create_vacancy_swi;

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

201: -- messages of any type exist in the Multiple Message List.
202: -- Also disable Multiple Message Detection.
203: --
204: p_return_status := hr_multi_message.get_return_status_disable;
205: hr_utility.set_location(' Leaving:' || l_proc,20);
206: --
207: exception
208: when hr_multi_message.error_message_exist then
209: --

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

216: -- Reset IN OUT paramters and set OUT parameters
217: --
218: p_object_version_number := null;
219: p_return_status := hr_multi_message.get_return_status_disable;
220: hr_utility.set_location(' Leaving:' || l_proc,30);
221: when others then
222: --
223: -- When Multiple Message Detection is enabled catch
224: -- any Application specific or other unexpected

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

227: -- the error.
228: --
229: rollback to create_vacancy_swi;
230: if hr_multi_message.unexpected_error_add(l_proc) then
231: hr_utility.set_location(' Leaving:' || l_proc, 40);
232: raise;
233: end if;
234: --
235: -- Reset IN OUT parameters and set OUT parameters

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

235: -- Reset IN OUT parameters and set OUT parameters
236: --
237: p_object_version_number := null;
238: p_return_status := hr_multi_message.get_return_status_disable;
239: hr_utility.set_location(' Leaving: ' || l_proc, 50);
240: end create_vacancy;
241: -- ----------------------------------------------------------------------------
242: -- |----------------------------< delete_vacancy >----------------------------|
243: -- ----------------------------------------------------------------------------

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

255: --
256: -- Other variables
257: l_proc varchar2(72) := g_package ||'delete_vacancy';
258: Begin
259: hr_utility.set_location(' Entering:' || l_proc,10);
260: --
261: -- Issue a savepoint
262: --
263: savepoint delete_vacancy_swi;

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

297: -- messages of any type exist in the Multiple Message List.
298: -- Also disable Multiple Message Detection.
299: --
300: p_return_status := hr_multi_message.get_return_status_disable;
301: hr_utility.set_location(' Leaving:' || l_proc,20);
302: --
303: exception
304: when hr_multi_message.error_message_exist then
305: --

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

311: --
312: -- Reset IN OUT paramters and set OUT parameters
313: --
314: p_return_status := hr_multi_message.get_return_status_disable;
315: hr_utility.set_location(' Leaving:' || l_proc,30);
316: when others then
317: --
318: -- When Multiple Message Detection is enabled catch
319: -- any Application specific or other unexpected

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

322: -- the error.
323: --
324: rollback to delete_vacancy_swi;
325: if hr_multi_message.unexpected_error_add(l_proc) then
326: hr_utility.set_location(' Leaving:' || l_proc, 40);
327: raise;
328: end if;
329: --
330: -- Reset IN OUT parameters and set OUT parameters

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

329: --
330: -- Reset IN OUT parameters and set OUT parameters
331: --
332: p_return_status := hr_multi_message.get_return_status_disable;
333: hr_utility.set_location(' Leaving: ' || l_proc, 50);
334: end delete_vacancy;
335: -- ----------------------------------------------------------------------------
336: -- |----------------------------< update_vacancy >----------------------------|
337: -- ----------------------------------------------------------------------------

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

405: --
406: -- Other variables
407: l_proc varchar2(72) := g_package ||'update_vacancy';
408: Begin
409: hr_utility.set_location(' Entering:' || l_proc,10);
410: --
411: -- Issue a savepoint
412: --
413: savepoint update_vacancy_swi;

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

525: -- messages of any type exist in the Multiple Message List.
526: -- Also disable Multiple Message Detection.
527: --
528: p_return_status := hr_multi_message.get_return_status_disable;
529: hr_utility.set_location(' Leaving:' || l_proc,20);
530: --
531: exception
532: when hr_multi_message.error_message_exist then
533: --

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

541: --
542: p_object_version_number := l_object_version_number;
543: p_assignment_changed := null;
544: p_return_status := hr_multi_message.get_return_status_disable;
545: hr_utility.set_location(' Leaving:' || l_proc,30);
546: when others then
547: --
548: -- When Multiple Message Detection is enabled catch
549: -- any Application specific or other unexpected

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

552: -- the error.
553: --
554: rollback to update_vacancy_swi;
555: if hr_multi_message.unexpected_error_add(l_proc) then
556: hr_utility.set_location(' Leaving:' || l_proc, 40);
557: raise;
558: end if;
559: --
560: -- Reset IN OUT parameters and set OUT parameters

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

561: --
562: p_object_version_number := l_object_version_number;
563: p_assignment_changed := null;
564: p_return_status := hr_multi_message.get_return_status_disable;
565: hr_utility.set_location(' Leaving: ' || l_proc, 50);
566: end update_vacancy;
567: --
568: procedure process_api
569: (

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

590: --
591:
592: BEGIN
593: --
594: hr_utility.set_location(' Entering:' || l_proc,10);
595: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
596: --
597: g_commiting_via_workflow:='TRUE';
598: l_parser := xmlparser.newParser;

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

591:
592: BEGIN
593: --
594: hr_utility.set_location(' Entering:' || l_proc,10);
595: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
596: --
597: g_commiting_via_workflow:='TRUE';
598: l_parser := xmlparser.newParser;
599: xmlparser.ParseCLOB(l_parser,p_document);

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

598: l_parser := xmlparser.newParser;
599: xmlparser.ParseCLOB(l_parser,p_document);
600: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
601: --
602: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
603: l_commitElement := xmldom.makeElement(l_CommitNode);
604: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
605: --
606: --Get the values for in/out parameters

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

625: end if;
626: --
627: if l_postState = '0' then
628: --
629: hr_utility.set_location('creating :' || l_proc,30);
630: --
631: create_vacancy
632: (p_validate => p_validate
633: ,p_effective_date => l_effective_date

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

690: );
691: --
692: elsif l_postState = '2' then
693: --
694: hr_utility.set_location('updating :' || l_proc,32);
695: --
696: -- call update vacancy
697: --
698: update_vacancy

Line 762: hr_utility.set_location

758:
759: p_return_status := l_return_status;
760: g_commiting_via_workflow:='FALSE';
761:
762: hr_utility.set_location
763: ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
764: exception
765: when others then
766: g_commiting_via_workflow:='FALSE';

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

779: l_proc varchar2(72) := g_package || 'getNumberValue';
780: --
781: Begin
782: --
783: hr_utility.set_location(' Entering:' || l_proc,10);
784: l_number := xslprocessor.valueof(commitNode,attributeName);
785: l_element := xmldom.makeElement(commitNode);
786: l_isNull := xmldom.getAttribute(l_element, 'null');
787: if l_isNull = 'true' then

Line 792: hr_utility.set_location(' Exiting :' || l_proc,15);

788: l_number := NULL;
789: else
790: l_number := NVL(l_number, gmisc_value);
791: end if;
792: hr_utility.set_location(' Exiting :' || l_proc,15);
793: --
794: return l_number;
795: --
796: End getNumberValueP2;

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

802: procedure handleAttachmentsWhenCommit(p_vacancy_id in number) is
803: PRAGMA AUTONOMOUS_TRANSACTION;
804: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenCommit';
805: begin
806: hr_utility.set_location(' Entering:' || l_proc,10);
807: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
808: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
809:
810: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);

Line 816: hr_utility.set_location(' Exiting:' || l_proc,20);

812:
813: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
814: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
815: commit;
816: hr_utility.set_location(' Exiting:' || l_proc,20);
817: end;
818: --
819: -- ----------------------------------------------------------------------------
820: -- |-----------------------------< handleAttachmentsWhenRejected >-------------|

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

823: procedure handleAttachmentsWhenRejected(p_vacancy_id in number) is
824: PRAGMA AUTONOMOUS_TRANSACTION;
825: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenRejected';
826: begin
827: hr_utility.set_location(' Entering:' || l_proc,10);
828: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
829: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
830: commit;
831: hr_utility.set_location(' Exiting:' || l_proc,20);

Line 831: hr_utility.set_location(' Exiting:' || l_proc,20);

827: hr_utility.set_location(' Entering:' || l_proc,10);
828: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
829: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
830: commit;
831: hr_utility.set_location(' Exiting:' || l_proc,20);
832: end;
833:
834: -- ---------------------------------------------------------------------------
835: -- |-----------------------------< handleAttachmentsWhenEditing >--------------|

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

838: procedure handleAttachmentsWhenEdit(p_vacancy_id in number) is
839: PRAGMA AUTONOMOUS_TRANSACTION;
840: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenEdit';
841: begin
842: hr_utility.set_location(' Entering:' || l_proc,10);
843:
844: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
845: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
846:

Line 850: hr_utility.set_location(' Exiting:' || l_proc,20);

846:
847: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_vacancy_id);
848: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_vacancy_id);
849: commit;
850: hr_utility.set_location(' Exiting:' || l_proc,20);
851: end;
852:
853: -- ---------------------------------------------------------------------------
854: -- |-----------------------------< copyAttachments >---------------------------|

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

857: procedure copyAttachments(p_from_vacancy_id in number,p_to_vacancy_id in number) is
858: PRAGMA AUTONOMOUS_TRANSACTION;
859: l_proc varchar2(72) := g_package || 'copyAttachments';
860: begin
861: hr_utility.set_location(' Entering:' || l_proc,10);
862:
863: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_from_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_to_vacancy_id);
864: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_from_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_to_vacancy_id);
865: commit;

Line 866: hr_utility.set_location(' Exiting:' || l_proc,20);

862:
863: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_from_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_to_vacancy_id);
864: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_from_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_to_vacancy_id);
865: commit;
866: hr_utility.set_location(' Exiting:' || l_proc,20);
867: end;
868:
869: -- --------------------------------------------------------------------------
870: -- |-----------------------------< finalize_transaction >---------------------|

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

887: where hrt.transaction_id = p_transaction_id;
888: --
889: begin
890: --
891: hr_utility.set_location(' Entering:' || l_proc,10);
892: hr_utility.set_location(l_proc || ' Event:' || p_event,20);
893: --
894: open csr_vacancy_id;
895: fetch csr_vacancy_id into l_vacancy_id;

Line 892: hr_utility.set_location(l_proc || ' Event:' || p_event,20);

888: --
889: begin
890: --
891: hr_utility.set_location(' Entering:' || l_proc,10);
892: hr_utility.set_location(l_proc || ' Event:' || p_event,20);
893: --
894: open csr_vacancy_id;
895: fetch csr_vacancy_id into l_vacancy_id;
896:

Line 900: hr_utility.set_location(l_proc,30);

896:
897: if csr_vacancy_id%found then
898: close csr_vacancy_id;
899: --
900: hr_utility.set_location(l_proc,30);
901:
902: if p_event = 'APPROVED' then
903: hr_utility.set_location(l_proc, 40);
904: handleAttachmentsWhenCommit(l_vacancy_id);

Line 903: hr_utility.set_location(l_proc, 40);

899: --
900: hr_utility.set_location(l_proc,30);
901:
902: if p_event = 'APPROVED' then
903: hr_utility.set_location(l_proc, 40);
904: handleAttachmentsWhenCommit(l_vacancy_id);
905:
906: elsif p_event = 'REJECTED' OR p_event = 'DELETED' OR p_event = 'CANCEL' then
907: hr_utility.set_location(l_proc, 50);

Line 907: hr_utility.set_location(l_proc, 50);

903: hr_utility.set_location(l_proc, 40);
904: handleAttachmentsWhenCommit(l_vacancy_id);
905:
906: elsif p_event = 'REJECTED' OR p_event = 'DELETED' OR p_event = 'CANCEL' then
907: hr_utility.set_location(l_proc, 50);
908: handleAttachmentsWhenRejected(l_vacancy_id);
909: end if;
910:
911: end if;

Line 915: hr_utility.set_location('Exiting:' || l_proc,60);

911: end if;
912: --
913: close csr_vacancy_id;
914: p_return_status := hr_multi_message.get_return_status_disable;
915: hr_utility.set_location('Exiting:' || l_proc,60);
916: --
917: end finalize_transaction;
918:
919: