DBA Data[Home] [Help]

APPS.IRC_SEARCH_CRITERIA_API dependencies on HR_UTILITY

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

113: l_object_version_number irc_search_criteria.object_version_number%TYPE;
114: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
115:
116: begin
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Issue a savepoint
120: --
121: savepoint CREATE_SAVED_SEARCH;

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

442: --
443: p_search_criteria_id := l_search_criteria_id;
444: p_object_version_number := l_object_version_number;
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 70);
447: exception
448: when hr_api.validate_enabled then
449: --
450: -- As the Validate_Enabled exception has been raised

Line 461: hr_utility.set_location(' Leaving:'||l_proc, 80);

457: -- when validation only mode is being used.)
458: --
459: p_search_criteria_id := null;
460: p_object_version_number := null;
461: hr_utility.set_location(' Leaving:'||l_proc, 80);
462: when others then
463: --
464: -- A validation or unexpected error has occured
465: --

Line 469: hr_utility.set_location(' Leaving:'||l_proc, 90);

465: --
466: p_search_criteria_id := null;
467: p_object_version_number := null;
468: rollback to CREATE_SAVED_SEARCH;
469: hr_utility.set_location(' Leaving:'||l_proc, 90);
470: raise;
471: end CREATE_SAVED_SEARCH;
472: --
473: -- ----------------------------------------------------------------------------

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

578: l_object_version_number irc_search_criteria.object_version_number%TYPE
579: := p_object_version_number;
580:
581: begin
582: hr_utility.set_location('Entering:'|| l_proc, 10);
583: --
584: -- Issue a savepoint
585: --
586: savepoint UPDATE_SAVED_SEARCH;

Line 912: hr_utility.set_location(' Leaving:'||l_proc, 70);

908: -- Set all output arguments
909: --
910: p_object_version_number := l_object_version_number;
911: --
912: hr_utility.set_location(' Leaving:'||l_proc, 70);
913: exception
914: when hr_api.validate_enabled then
915: --
916: -- As the Validate_Enabled exception has been raised

Line 929: hr_utility.set_location(' Leaving:'||l_proc, 80);

925: --
926: -- Reset IN OUT parameters and set OUT parameters
927: --
928: p_object_version_number := l_object_version_number;
929: hr_utility.set_location(' Leaving:'||l_proc, 80);
930: when others then
931: --
932: -- A validation or unexpected error has occured
933: --

Line 939: hr_utility.set_location(' Leaving:'||l_proc, 90);

935: --
936: -- Reset IN OUT parameters and set OUT parameters
937: --
938: p_object_version_number := l_object_version_number;
939: hr_utility.set_location(' Leaving:'||l_proc, 90);
940: raise;
941: end UPDATE_SAVED_SEARCH;
942: --
943: -- ----------------------------------------------------------------------------

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

955:
956: l_proc varchar2(72) := g_package||'DELETE_SAVED_SEARCH';
957:
958: begin
959: hr_utility.set_location('Entering:'|| l_proc, 10);
960: --
961: -- Issue a savepoint
962: --
963: savepoint DELETE_SAVED_SEARCH;

Line 1015: hr_utility.set_location(' Leaving:'||l_proc, 70);

1011: --
1012: -- Set all output arguments
1013: --
1014: --
1015: hr_utility.set_location(' Leaving:'||l_proc, 70);
1016: exception
1017: when hr_api.validate_enabled then
1018: --
1019: -- As the Validate_Enabled exception has been raised

Line 1028: hr_utility.set_location(' Leaving:'||l_proc, 80);

1024: -- Only set output warning arguments
1025: -- (Any key or derived arguments must be set to null
1026: -- when validation only mode is being used.)
1027: --
1028: hr_utility.set_location(' Leaving:'||l_proc, 80);
1029: when others then
1030: --
1031: -- A validation or unexpected error has occured
1032: --

Line 1034: hr_utility.set_location(' Leaving:'||l_proc, 90);

1030: --
1031: -- A validation or unexpected error has occured
1032: --
1033: rollback to DELETE_SAVED_SEARCH;
1034: hr_utility.set_location(' Leaving:'||l_proc, 90);
1035: raise;
1036: end DELETE_SAVED_SEARCH;
1037: --
1038: -- ----------------------------------------------------------------------------

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

1131: l_object_version_number irc_search_criteria.object_version_number%TYPE;
1132: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
1133: l_effective_date date;
1134: begin
1135: hr_utility.set_location('Entering:'|| l_proc, 10);
1136: --
1137: -- Issue a savepoint
1138: --
1139: savepoint CREATE_VACANCY_CRITERIA;

Line 1431: hr_utility.set_location(' Leaving:'||l_proc, 70);

1427: --
1428: p_search_criteria_id := l_search_criteria_id;
1429: p_object_version_number := l_object_version_number;
1430: --
1431: hr_utility.set_location(' Leaving:'||l_proc, 70);
1432: exception
1433: when hr_api.validate_enabled then
1434: --
1435: -- As the Validate_Enabled exception has been raised

Line 1446: hr_utility.set_location(' Leaving:'||l_proc, 80);

1442: -- when validation only mode is being used.)
1443: --
1444: p_search_criteria_id := null;
1445: p_object_version_number := null;
1446: hr_utility.set_location(' Leaving:'||l_proc, 80);
1447: when others then
1448: --
1449: -- A validation or unexpected error has occured
1450: --

Line 1454: hr_utility.set_location(' Leaving:'||l_proc, 90);

1450: --
1451: p_search_criteria_id := null;
1452: p_object_version_number := null;
1453: rollback to CREATE_VACANCY_CRITERIA;
1454: hr_utility.set_location(' Leaving:'||l_proc, 90);
1455: raise;
1456: end CREATE_VACANCY_CRITERIA;
1457: --
1458: -- ----------------------------------------------------------------------------

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

1552: := p_object_version_number;
1553: l_effective_date date;
1554:
1555: begin
1556: hr_utility.set_location('Entering:'|| l_proc, 10);
1557: --
1558: -- Issue a savepoint
1559: --
1560: savepoint UPDATE_VACANCY_CRITERIA;

Line 1853: hr_utility.set_location(' Leaving:'||l_proc, 70);

1849: -- Set all output arguments
1850: --
1851: p_object_version_number := l_object_version_number;
1852: --
1853: hr_utility.set_location(' Leaving:'||l_proc, 70);
1854: exception
1855: when hr_api.validate_enabled then
1856: --
1857: -- As the Validate_Enabled exception has been raised

Line 1870: hr_utility.set_location(' Leaving:'||l_proc, 80);

1866: --
1867: -- Reset IN OUT parameters and set OUT parameters
1868: --
1869: p_object_version_number := l_object_version_number;
1870: hr_utility.set_location(' Leaving:'||l_proc, 80);
1871: when others then
1872: --
1873: -- A validation or unexpected error has occured
1874: --

Line 1880: hr_utility.set_location(' Leaving:'||l_proc, 90);

1876: --
1877: -- Reset IN OUT parameters and set OUT parameters
1878: --
1879: p_object_version_number := l_object_version_number;
1880: hr_utility.set_location(' Leaving:'||l_proc, 90);
1881: raise;
1882: end UPDATE_VACANCY_CRITERIA;
1883: --
1884: -- ----------------------------------------------------------------------------

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

1896:
1897: l_proc varchar2(72) := g_package||'DELETE_VACANCY_CRITERIA';
1898:
1899: begin
1900: hr_utility.set_location('Entering:'|| l_proc, 10);
1901: --
1902: -- Issue a savepoint
1903: --
1904: savepoint DELETE_VACANCY_CRITERIA;

Line 1956: hr_utility.set_location(' Leaving:'||l_proc, 70);

1952: --
1953: -- Set all output arguments
1954: --
1955: --
1956: hr_utility.set_location(' Leaving:'||l_proc, 70);
1957: exception
1958: when hr_api.validate_enabled then
1959: --
1960: -- As the Validate_Enabled exception has been raised

Line 1969: hr_utility.set_location(' Leaving:'||l_proc, 80);

1965: -- Only set output warning arguments
1966: -- (Any key or derived arguments must be set to null
1967: -- when validation only mode is being used.)
1968: --
1969: hr_utility.set_location(' Leaving:'||l_proc, 80);
1970: when others then
1971: --
1972: -- A validation or unexpected error has occured
1973: --

Line 1975: hr_utility.set_location(' Leaving:'||l_proc, 90);

1971: --
1972: -- A validation or unexpected error has occured
1973: --
1974: rollback to DELETE_VACANCY_CRITERIA;
1975: hr_utility.set_location(' Leaving:'||l_proc, 90);
1976: raise;
1977: end DELETE_VACANCY_CRITERIA;
1978: --
1979: --

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

2082: l_object_version_number irc_search_criteria.object_version_number%TYPE;
2083: l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
2084:
2085: begin
2086: hr_utility.set_location('Entering:'|| l_proc, 10);
2087: --
2088: -- Issue a savepoint
2089: --
2090: savepoint CREATE_WORK_CHOICES;

Line 2407: hr_utility.set_location(' Leaving:'||l_proc, 70);

2403: --
2404: p_search_criteria_id := l_search_criteria_id;
2405: p_object_version_number := l_object_version_number;
2406: --
2407: hr_utility.set_location(' Leaving:'||l_proc, 70);
2408: exception
2409: when hr_api.validate_enabled then
2410: --
2411: -- As the Validate_Enabled exception has been raised

Line 2422: hr_utility.set_location(' Leaving:'||l_proc, 80);

2418: -- when validation only mode is being used.)
2419: --
2420: p_search_criteria_id := null;
2421: p_object_version_number := null;
2422: hr_utility.set_location(' Leaving:'||l_proc, 80);
2423: when others then
2424: --
2425: -- A validation or unexpected error has occured
2426: --

Line 2430: hr_utility.set_location(' Leaving:'||l_proc, 90);

2426: --
2427: p_search_criteria_id := null;
2428: p_object_version_number := null;
2429: rollback to CREATE_WORK_CHOICES;
2430: hr_utility.set_location(' Leaving:'||l_proc, 90);
2431: raise;
2432: end CREATE_WORK_CHOICES;
2433: --
2434: -- ----------------------------------------------------------------------------

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

2535: l_object_version_number irc_search_criteria.object_version_number%TYPE
2536: := p_object_version_number;
2537:
2538: begin
2539: hr_utility.set_location('Entering:'|| l_proc, 10);
2540: --
2541: -- Issue a savepoint
2542: --
2543: savepoint UPDATE_WORK_CHOICES;

Line 2857: hr_utility.set_location(' Leaving:'||l_proc, 70);

2853: -- Set all output arguments
2854: --
2855: p_object_version_number := l_object_version_number;
2856: --
2857: hr_utility.set_location(' Leaving:'||l_proc, 70);
2858: exception
2859: when hr_api.validate_enabled then
2860: --
2861: -- As the Validate_Enabled exception has been raised

Line 2874: hr_utility.set_location(' Leaving:'||l_proc, 80);

2870: --
2871: -- Reset IN OUT parameters and set OUT parameters
2872: --
2873: p_object_version_number := l_object_version_number;
2874: hr_utility.set_location(' Leaving:'||l_proc, 80);
2875: when others then
2876: --
2877: -- A validation or unexpected error has occured
2878: --

Line 2884: hr_utility.set_location(' Leaving:'||l_proc, 90);

2880: --
2881: -- Reset IN OUT parameters and set OUT parameters
2882: --
2883: p_object_version_number := l_object_version_number;
2884: hr_utility.set_location(' Leaving:'||l_proc, 90);
2885: raise;
2886: end UPDATE_WORK_CHOICES;
2887: --
2888: -- ----------------------------------------------------------------------------

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

2900:
2901: l_proc varchar2(72) := g_package||'DELETE_WORK_CHOICES';
2902:
2903: begin
2904: hr_utility.set_location('Entering:'|| l_proc, 10);
2905: --
2906: -- Issue a savepoint
2907: --
2908: savepoint DELETE_WORK_CHOICES;

Line 2960: hr_utility.set_location(' Leaving:'||l_proc, 70);

2956: --
2957: -- Set all output arguments
2958: --
2959: --
2960: hr_utility.set_location(' Leaving:'||l_proc, 70);
2961: exception
2962: when hr_api.validate_enabled then
2963: --
2964: -- As the Validate_Enabled exception has been raised

Line 2973: hr_utility.set_location(' Leaving:'||l_proc, 80);

2969: -- Only set output warning arguments
2970: -- (Any key or derived arguments must be set to null
2971: -- when validation only mode is being used.)
2972: --
2973: hr_utility.set_location(' Leaving:'||l_proc, 80);
2974: when others then
2975: --
2976: -- A validation or unexpected error has occured
2977: --

Line 2979: hr_utility.set_location(' Leaving:'||l_proc, 90);

2975: --
2976: -- A validation or unexpected error has occured
2977: --
2978: rollback to DELETE_WORK_CHOICES;
2979: hr_utility.set_location(' Leaving:'||l_proc, 90);
2980: raise;
2981: end DELETE_WORK_CHOICES;
2982: --
2983: end IRC_SEARCH_CRITERIA_API;