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 85: hr_utility.set_location(' Entering:' || l_proc,10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

565: --
566: p_object_version_number := l_object_version_number;
567: p_assignment_changed := null;
568: p_return_status := hr_multi_message.get_return_status_disable;
569: hr_utility.set_location(' Leaving: ' || l_proc, 50);
570: end update_vacancy;
571: --
572: procedure process_api
573: (

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

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

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

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

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

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

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

629: end if;
630: --
631: if l_postState = '0' then
632: --
633: hr_utility.set_location('creating :' || l_proc,30);
634: --
635: create_vacancy
636: (p_validate => p_validate
637: ,p_effective_date => l_effective_date

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

695: );
696: --
697: elsif l_postState = '2' then
698: --
699: hr_utility.set_location('updating :' || l_proc,32);
700: --
701: -- call update vacancy
702: --
703: update_vacancy

Line 768: hr_utility.set_location

764:
765: p_return_status := l_return_status;
766: g_commiting_via_workflow:='FALSE';
767:
768: hr_utility.set_location
769: ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
770: exception
771: when others then
772: g_commiting_via_workflow:='FALSE';

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

785: l_proc varchar2(72) := g_package || 'getNumberValue';
786: --
787: Begin
788: --
789: hr_utility.set_location(' Entering:' || l_proc,10);
790: l_number := xslprocessor.valueof(commitNode,attributeName);
791: l_element := xmldom.makeElement(commitNode);
792: l_isNull := xmldom.getAttribute(l_element, 'null');
793: if l_isNull = 'true' then

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

794: l_number := NULL;
795: else
796: l_number := NVL(l_number, gmisc_value);
797: end if;
798: hr_utility.set_location(' Exiting :' || l_proc,15);
799: --
800: return l_number;
801: --
802: End getNumberValueP2;

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

808: procedure handleAttachmentsWhenCommit(p_vacancy_id in number) is
809: PRAGMA AUTONOMOUS_TRANSACTION;
810: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenCommit';
811: begin
812: hr_utility.set_location(' Entering:' || l_proc,10);
813: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
814: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
815:
816: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_VAC',

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

830:
831: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
832: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
833: commit;
834: hr_utility.set_location(' Exiting:' || l_proc,20);
835: end;
836: --
837: -- ----------------------------------------------------------------------------
838: -- |-----------------------------< handleAttachmentsWhenRejected >------------|

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

841: procedure handleAttachmentsWhenRejected(p_vacancy_id in number) is
842: PRAGMA AUTONOMOUS_TRANSACTION;
843: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenRejected';
844: begin
845: hr_utility.set_location(' Entering:' || l_proc,10);
846: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
847: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
848: commit;
849: hr_utility.set_location(' Exiting:' || l_proc,20);

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

845: hr_utility.set_location(' Entering:' || l_proc,10);
846: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
847: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
848: commit;
849: hr_utility.set_location(' Exiting:' || l_proc,20);
850: end;
851:
852: -- ---------------------------------------------------------------------------
853: -- |-----------------------------< handleAttachmentsWhenEdit >----------------|

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

856: procedure handleAttachmentsWhenEdit(p_vacancy_id in number) is
857: PRAGMA AUTONOMOUS_TRANSACTION;
858: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenEdit';
859: begin
860: hr_utility.set_location(' Entering:' || l_proc,10);
861:
862: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
863: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
864:

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

876: X_created_by => fnd_global.user_id,
877: X_last_update_login=> fnd_global.login_id
878: );
879: commit;
880: hr_utility.set_location(' Exiting:' || l_proc,20);
881: end;
882:
883: -- ---------------------------------------------------------------------------
884: -- |-----------------------------< copyAttachments >--------------------------|

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

887: procedure copyAttachments(p_from_vacancy_id in number,p_to_vacancy_id in number) is
888: PRAGMA AUTONOMOUS_TRANSACTION;
889: l_proc varchar2(72) := g_package || 'copyAttachments';
890: begin
891: hr_utility.set_location(' Entering:' || l_proc,10);
892:
893: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_VAC_APPROVED',
894: X_from_pk1_value => p_from_vacancy_id,
895: X_to_entity_name => 'IRC_INT_VAC',

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

904: X_created_by => fnd_global.user_id,
905: X_last_update_login=> fnd_global.login_id
906: );
907: commit;
908: hr_utility.set_location(' Exiting:' || l_proc,20);
909: end;
910:
911: -- --------------------------------------------------------------------------
912: -- |-----------------------------< finalize_transaction >--------------------|

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

929: where hrt.transaction_id = p_transaction_id;
930: --
931: begin
932: --
933: hr_utility.set_location(' Entering:' || l_proc,10);
934: hr_utility.set_location(l_proc || ' Event:' || p_event,20);
935: --
936: open csr_vacancy_id;
937: fetch csr_vacancy_id into l_vacancy_id;

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

930: --
931: begin
932: --
933: hr_utility.set_location(' Entering:' || l_proc,10);
934: hr_utility.set_location(l_proc || ' Event:' || p_event,20);
935: --
936: open csr_vacancy_id;
937: fetch csr_vacancy_id into l_vacancy_id;
938:

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

938:
939: if csr_vacancy_id%found then
940: close csr_vacancy_id;
941: --
942: hr_utility.set_location(l_proc,30);
943:
944: if p_event = 'APPROVED' then
945: hr_utility.set_location(l_proc, 40);
946: handleAttachmentsWhenCommit(l_vacancy_id);

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

941: --
942: hr_utility.set_location(l_proc,30);
943:
944: if p_event = 'APPROVED' then
945: hr_utility.set_location(l_proc, 40);
946: handleAttachmentsWhenCommit(l_vacancy_id);
947:
948: elsif p_event = 'REJECTED' OR p_event = 'DELETED' OR p_event = 'CANCEL' then
949: hr_utility.set_location(l_proc, 50);

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

945: hr_utility.set_location(l_proc, 40);
946: handleAttachmentsWhenCommit(l_vacancy_id);
947:
948: elsif p_event = 'REJECTED' OR p_event = 'DELETED' OR p_event = 'CANCEL' then
949: hr_utility.set_location(l_proc, 50);
950: handleAttachmentsWhenRejected(l_vacancy_id);
951: end if;
952:
953: end if;

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

953: end if;
954: --
955: close csr_vacancy_id;
956: p_return_status := hr_multi_message.get_return_status_disable;
957: hr_utility.set_location('Exiting:' || l_proc,60);
958: --
959: end finalize_transaction;
960:
961: