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_SEARCH_CRITERIA_SWI dependencies on HR_UTILITY

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

113: -- Other variables
114: l_search_criteria_id number;
115: l_proc varchar2(72) := g_package ||'create_saved_search';
116: Begin
117: hr_utility.set_location(' Entering:' || l_proc,10);
118: --
119: -- Issue a savepoint
120: --
121: savepoint create_saved_search_swi;

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

248: -- messages of any type exist in the Multiple Message List.
249: -- Also disable Multiple Message Detection.
250: --
251: p_return_status := hr_multi_message.get_return_status_disable;
252: hr_utility.set_location(' Leaving:' || l_proc,20);
253: --
254: exception
255: when hr_multi_message.error_message_exist then
256: --

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

263: -- Reset IN OUT parameters and set OUT parameters
264: --
265: p_object_version_number := null;
266: p_return_status := hr_multi_message.get_return_status_disable;
267: hr_utility.set_location(' Leaving:' || l_proc, 30);
268: when others then
269: --
270: -- When Multiple Message Detection is enabled catch
271: -- any Application specific or other unexpected

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

274: -- error.
275: --
276: rollback to create_saved_search_swi;
277: if hr_multi_message.unexpected_error_add(l_proc) then
278: hr_utility.set_location(' Leaving:' || l_proc,40);
279: raise;
280: end if;
281: --
282: -- Reset IN OUT and set OUT parameters

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

282: -- Reset IN OUT and set OUT parameters
283: --
284: p_object_version_number := null;
285: p_return_status := hr_multi_message.get_return_status_disable;
286: hr_utility.set_location(' Leaving:' || l_proc,50);
287: end create_saved_search;
288: -- ----------------------------------------------------------------------------
289: -- |------------------------< create_vacancy_criteria >-----------------------|
290: -- ----------------------------------------------------------------------------

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

382: --
383: -- Other variables
384: l_proc varchar2(72) := g_package ||'create_vacancy_criteria';
385: Begin
386: hr_utility.set_location(' Entering:' || l_proc,10);
387: --
388: -- Issue a savepoint
389: --
390: savepoint create_vacancy_criteria_swi;

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

507: -- messages of any type exist in the Multiple Message List.
508: -- Also disable Multiple Message Detection.
509: --
510: p_return_status := hr_multi_message.get_return_status_disable;
511: hr_utility.set_location(' Leaving:' || l_proc,20);
512: --
513: exception
514: when hr_multi_message.error_message_exist then
515: --

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

522: -- Reset IN OUT parameters and set OUT parameters
523: --
524: p_object_version_number := null;
525: p_return_status := hr_multi_message.get_return_status_disable;
526: hr_utility.set_location(' Leaving:' || l_proc, 30);
527: when others then
528: --
529: -- When Multiple Message Detection is enabled catch
530: -- any Application specific or other unexpected

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

533: -- error.
534: --
535: rollback to create_vacancy_criteria_swi;
536: if hr_multi_message.unexpected_error_add(l_proc) then
537: hr_utility.set_location(' Leaving:' || l_proc,40);
538: raise;
539: end if;
540: --
541: -- Reset IN OUT and set OUT parameters

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

541: -- Reset IN OUT and set OUT parameters
542: --
543: p_object_version_number := null;
544: p_return_status := hr_multi_message.get_return_status_disable;
545: hr_utility.set_location(' Leaving:' || l_proc,50);
546: end create_vacancy_criteria;
547: -- ----------------------------------------------------------------------------
548: -- |--------------------------< delete_saved_search >-------------------------|
549: -- ----------------------------------------------------------------------------

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

561: --
562: -- Other variables
563: l_proc varchar2(72) := g_package ||'delete_saved_search';
564: Begin
565: hr_utility.set_location(' Entering:' || l_proc,10);
566: --
567: -- Issue a savepoint
568: --
569: savepoint delete_saved_search_swi;

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

603: -- messages of any type exist in the Multiple Message List.
604: -- Also disable Multiple Message Detection.
605: --
606: p_return_status := hr_multi_message.get_return_status_disable;
607: hr_utility.set_location(' Leaving:' || l_proc,20);
608: --
609: exception
610: when hr_multi_message.error_message_exist then
611: --

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

617: --
618: -- Reset IN OUT parameters and set OUT parameters
619: --
620: p_return_status := hr_multi_message.get_return_status_disable;
621: hr_utility.set_location(' Leaving:' || l_proc, 30);
622: when others then
623: --
624: -- When Multiple Message Detection is enabled catch
625: -- any Application specific or other unexpected

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

628: -- error.
629: --
630: rollback to delete_saved_search_swi;
631: if hr_multi_message.unexpected_error_add(l_proc) then
632: hr_utility.set_location(' Leaving:' || l_proc,40);
633: raise;
634: end if;
635: --
636: -- Reset IN OUT and set OUT parameters

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

635: --
636: -- Reset IN OUT and set OUT parameters
637: --
638: p_return_status := hr_multi_message.get_return_status_disable;
639: hr_utility.set_location(' Leaving:' || l_proc,50);
640: end delete_saved_search;
641: -- ----------------------------------------------------------------------------
642: -- |------------------------< delete_vacancy_criteria >-----------------------|
643: -- ----------------------------------------------------------------------------

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

655: --
656: -- Other variables
657: l_proc varchar2(72) := g_package ||'delete_vacancy_criteria';
658: Begin
659: hr_utility.set_location(' Entering:' || l_proc,10);
660: --
661: -- Issue a savepoint
662: --
663: savepoint delete_vacancy_criteria_swi;

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

697: -- messages of any type exist in the Multiple Message List.
698: -- Also disable Multiple Message Detection.
699: --
700: p_return_status := hr_multi_message.get_return_status_disable;
701: hr_utility.set_location(' Leaving:' || l_proc,20);
702: --
703: exception
704: when hr_multi_message.error_message_exist then
705: --

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

711: --
712: -- Reset IN OUT parameters and set OUT parameters
713: --
714: p_return_status := hr_multi_message.get_return_status_disable;
715: hr_utility.set_location(' Leaving:' || l_proc, 30);
716: when others then
717: --
718: -- When Multiple Message Detection is enabled catch
719: -- any Application specific or other unexpected

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

722: -- error.
723: --
724: rollback to delete_vacancy_criteria_swi;
725: if hr_multi_message.unexpected_error_add(l_proc) then
726: hr_utility.set_location(' Leaving:' || l_proc,40);
727: raise;
728: end if;
729: --
730: -- Reset IN OUT and set OUT parameters

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

729: --
730: -- Reset IN OUT and set OUT parameters
731: --
732: p_return_status := hr_multi_message.get_return_status_disable;
733: hr_utility.set_location(' Leaving:' || l_proc,50);
734: end delete_vacancy_criteria;
735: -- ----------------------------------------------------------------------------
736: -- |--------------------------< update_saved_search >-------------------------|
737: -- ----------------------------------------------------------------------------

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

840: --
841: -- Other variables
842: l_proc varchar2(72) := g_package ||'update_saved_search';
843: Begin
844: hr_utility.set_location(' Entering:' || l_proc,10);
845: --
846: -- Issue a savepoint
847: --
848: savepoint update_saved_search_swi;

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

973: -- messages of any type exist in the Multiple Message List.
974: -- Also disable Multiple Message Detection.
975: --
976: p_return_status := hr_multi_message.get_return_status_disable;
977: hr_utility.set_location(' Leaving:' || l_proc,20);
978: --
979: exception
980: when hr_multi_message.error_message_exist then
981: --

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

988: -- Reset IN OUT parameters and set OUT parameters
989: --
990: p_object_version_number := l_object_version_number;
991: p_return_status := hr_multi_message.get_return_status_disable;
992: hr_utility.set_location(' Leaving:' || l_proc, 30);
993: when others then
994: --
995: -- When Multiple Message Detection is enabled catch
996: -- any Application specific or other unexpected

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

999: -- error.
1000: --
1001: rollback to update_saved_search_swi;
1002: if hr_multi_message.unexpected_error_add(l_proc) then
1003: hr_utility.set_location(' Leaving:' || l_proc,40);
1004: raise;
1005: end if;
1006: --
1007: -- Reset IN OUT and set OUT parameters

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

1007: -- Reset IN OUT and set OUT parameters
1008: --
1009: p_object_version_number := l_object_version_number;
1010: p_return_status := hr_multi_message.get_return_status_disable;
1011: hr_utility.set_location(' Leaving:' || l_proc,50);
1012: end update_saved_search;
1013: -- ----------------------------------------------------------------------------
1014: -- |------------------------< update_vacancy_criteria >-----------------------|
1015: -- ----------------------------------------------------------------------------

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

1107: --
1108: -- Other variables
1109: l_proc varchar2(72) := g_package ||'update_vacancy_criteria';
1110: Begin
1111: hr_utility.set_location(' Entering:' || l_proc,10);
1112: --
1113: -- Issue a savepoint
1114: --
1115: savepoint update_vacancy_criteria_swi;

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

1229: -- messages of any type exist in the Multiple Message List.
1230: -- Also disable Multiple Message Detection.
1231: --
1232: p_return_status := hr_multi_message.get_return_status_disable;
1233: hr_utility.set_location(' Leaving:' || l_proc,20);
1234: --
1235: exception
1236: when hr_multi_message.error_message_exist then
1237: --

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

1244: -- Reset IN OUT parameters and set OUT parameters
1245: --
1246: p_object_version_number := l_object_version_number;
1247: p_return_status := hr_multi_message.get_return_status_disable;
1248: hr_utility.set_location(' Leaving:' || l_proc, 30);
1249: when others then
1250: --
1251: -- When Multiple Message Detection is enabled catch
1252: -- any Application specific or other unexpected

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

1255: -- error.
1256: --
1257: rollback to update_vacancy_criteria_swi;
1258: if hr_multi_message.unexpected_error_add(l_proc) then
1259: hr_utility.set_location(' Leaving:' || l_proc,40);
1260: raise;
1261: end if;
1262: --
1263: -- Reset IN OUT and set OUT parameters

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

1263: -- Reset IN OUT and set OUT parameters
1264: --
1265: p_object_version_number := l_object_version_number;
1266: p_return_status := hr_multi_message.get_return_status_disable;
1267: hr_utility.set_location(' Leaving:' || l_proc,50);
1268: end update_vacancy_criteria;
1269: --
1270: -- ----------------------------------------------------------------------------
1271: -- |--------------------------< create_work_choices >-------------------------|

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

1372: -- Other variables
1373: l_search_criteria_id number;
1374: l_proc varchar2(72) := g_package ||'create_work_choices';
1375: Begin
1376: hr_utility.set_location(' Entering:' || l_proc,10);
1377: --
1378: -- Issue a savepoint
1379: --
1380: savepoint create_work_choices_swi;

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

1504: -- messages of any type exist in the Multiple Message List.
1505: -- Also disable Multiple Message Detection.
1506: --
1507: p_return_status := hr_multi_message.get_return_status_disable;
1508: hr_utility.set_location(' Leaving:' || l_proc,20);
1509: --
1510: exception
1511: when hr_multi_message.error_message_exist then
1512: --

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

1519: -- Reset IN OUT parameters and set OUT parameters
1520: --
1521: p_object_version_number := null;
1522: p_return_status := hr_multi_message.get_return_status_disable;
1523: hr_utility.set_location(' Leaving:' || l_proc, 30);
1524: when others then
1525: --
1526: -- When Multiple Message Detection is enabled catch
1527: -- any Application specific or other unexpected

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

1530: -- error.
1531: --
1532: rollback to create_work_choices_swi;
1533: if hr_multi_message.unexpected_error_add(l_proc) then
1534: hr_utility.set_location(' Leaving:' || l_proc,40);
1535: raise;
1536: end if;
1537: --
1538: -- Reset IN OUT and set OUT parameters

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

1538: -- Reset IN OUT and set OUT parameters
1539: --
1540: p_object_version_number := null;
1541: p_return_status := hr_multi_message.get_return_status_disable;
1542: hr_utility.set_location(' Leaving:' || l_proc,50);
1543: end create_work_choices;
1544: -- ----------------------------------------------------------------------------
1545: -- |--------------------------< delete_work_choices >-------------------------|
1546: -- ----------------------------------------------------------------------------

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

1558: --
1559: -- Other variables
1560: l_proc varchar2(72) := g_package ||'delete_work_choices';
1561: Begin
1562: hr_utility.set_location(' Entering:' || l_proc,10);
1563: --
1564: -- Issue a savepoint
1565: --
1566: savepoint delete_work_choices_swi;

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

1600: -- messages of any type exist in the Multiple Message List.
1601: -- Also disable Multiple Message Detection.
1602: --
1603: p_return_status := hr_multi_message.get_return_status_disable;
1604: hr_utility.set_location(' Leaving:' || l_proc,20);
1605: --
1606: exception
1607: when hr_multi_message.error_message_exist then
1608: --

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

1614: --
1615: -- Reset IN OUT parameters and set OUT parameters
1616: --
1617: p_return_status := hr_multi_message.get_return_status_disable;
1618: hr_utility.set_location(' Leaving:' || l_proc, 30);
1619: when others then
1620: --
1621: -- When Multiple Message Detection is enabled catch
1622: -- any Application specific or other unexpected

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

1625: -- error.
1626: --
1627: rollback to delete_work_choices_swi;
1628: if hr_multi_message.unexpected_error_add(l_proc) then
1629: hr_utility.set_location(' Leaving:' || l_proc,40);
1630: raise;
1631: end if;
1632: --
1633: -- Reset IN OUT and set OUT parameters

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

1632: --
1633: -- Reset IN OUT and set OUT parameters
1634: --
1635: p_return_status := hr_multi_message.get_return_status_disable;
1636: hr_utility.set_location(' Leaving:' || l_proc,50);
1637: end delete_work_choices;
1638: -- ----------------------------------------------------------------------------
1639: -- |--------------------------< update_work_choices >-------------------------|
1640: -- ----------------------------------------------------------------------------

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

1739: --
1740: -- Other variables
1741: l_proc varchar2(72) := g_package ||'update_work_choices';
1742: Begin
1743: hr_utility.set_location(' Entering:' || l_proc,10);
1744: --
1745: -- Issue a savepoint
1746: --
1747: savepoint update_work_choices_swi;

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

1868: -- messages of any type exist in the Multiple Message List.
1869: -- Also disable Multiple Message Detection.
1870: --
1871: p_return_status := hr_multi_message.get_return_status_disable;
1872: hr_utility.set_location(' Leaving:' || l_proc,20);
1873: --
1874: exception
1875: when hr_multi_message.error_message_exist then
1876: --

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

1883: -- Reset IN OUT parameters and set OUT parameters
1884: --
1885: p_object_version_number := l_object_version_number;
1886: p_return_status := hr_multi_message.get_return_status_disable;
1887: hr_utility.set_location(' Leaving:' || l_proc, 30);
1888: when others then
1889: --
1890: -- When Multiple Message Detection is enabled catch
1891: -- any Application specific or other unexpected

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

1894: -- error.
1895: --
1896: rollback to update_work_choices_swi;
1897: if hr_multi_message.unexpected_error_add(l_proc) then
1898: hr_utility.set_location(' Leaving:' || l_proc,40);
1899: raise;
1900: end if;
1901: --
1902: -- Reset IN OUT and set OUT parameters

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

1902: -- Reset IN OUT and set OUT parameters
1903: --
1904: p_object_version_number := l_object_version_number;
1905: p_return_status := hr_multi_message.get_return_status_disable;
1906: hr_utility.set_location(' Leaving:' || l_proc,50);
1907: end update_work_choices;
1908:
1909: -- ----------------------------------------------------------------------------
1910: -- |------------------------< process_vacancy_api >---------------------------|

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

1930: l_effective_date date := trunc(sysdate);
1931:
1932: BEGIN
1933: --
1934: hr_utility.set_location(' Entering:' || l_proc,10);
1935: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1936: --
1937: l_parser := xmlparser.newParser;
1938: xmlparser.ParseCLOB(l_parser,p_document);

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

1931:
1932: BEGIN
1933: --
1934: hr_utility.set_location(' Entering:' || l_proc,10);
1935: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1936: --
1937: l_parser := xmlparser.newParser;
1938: xmlparser.ParseCLOB(l_parser,p_document);
1939: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

1937: l_parser := xmlparser.newParser;
1938: xmlparser.ParseCLOB(l_parser,p_document);
1939: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1940: --
1941: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1942:
1943: l_commitElement := xmldom.makeElement(l_CommitNode);
1944: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1945: --

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

1955: end if;
1956: --
1957: if l_postState = '0' then
1958: --
1959: hr_utility.set_location('creating :' || l_proc,30);
1960: --
1961: create_vacancy_criteria
1962: (p_validate => p_validate
1963: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',NULL)

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

2045: );
2046: --
2047: elsif l_postState = '2' then
2048: --
2049: hr_utility.set_location('updating :' || l_proc,32);
2050: --
2051: update_vacancy_criteria
2052: (p_validate => p_validate
2053: ,p_effective_date => l_effective_date

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

2135: );
2136: --
2137: elsif l_postState = '3' then
2138: --
2139: hr_utility.set_location('deleting :' || l_proc,33);
2140: --
2141: delete_vacancy_criteria
2142: (p_validate => p_validate
2143: ,p_object_version_number => l_object_version_number

Line 2151: hr_utility.set_location

2147: --
2148: end if;
2149: p_return_status := l_return_status;
2150:
2151: hr_utility.set_location
2152: ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
2153: --
2154: end process_vacancy_api;
2155: --