DBA Data[Home] [Help]

APPS.IRC_SAVED_SEARCH_CRITERIA_API dependencies on HR_UTILITY

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

30: l_proc varchar2(72) := g_package||'create_search_criteria';
31: l_cursor_ret_val varchar2(10) := 'N';
32:
33: begin
34: hr_utility.set_location('Entering:'|| l_proc, 10);
35:
36:
37: --
38: -- Issue a savepoint

Line 49: hr_utility.set_location(l_proc, 20);

45: --
46: -- Truncate the time portion from all IN date parameters
47: --
48:
49: hr_utility.set_location(l_proc, 20);
50: --
51: -- Call Before Process User Hook
52: --
53: --Comment below To be removed

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

51: -- Call Before Process User Hook
52: --
53: --Comment below To be removed
54:
55: hr_utility.set_location(l_proc, 30);
56: --
57: -- Validation in addition to Row Handlers
58: --
59:

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

78: End If;
79:
80:
81:
82: hr_utility.set_location(' Leaving:'||l_proc, 50);
83: --
84: -- Call After Process User Hook
85: --
86: --Comment below To be removed

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

96: --
97: p_saved_search_criteria_id := l_saved_search_criteria_id;
98: p_object_version_number := l_object_version_number;
99: --
100: hr_utility.set_location(' Leaving:'||l_proc, 70);
101: exception
102: when hr_api.validate_enabled then
103: --
104: -- As the Validate_Enabled exception has been raised

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

112: --
113: p_saved_search_criteria_id := null;
114: p_object_version_number := null;
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 80);
117: when others then
118: --
119: -- A validation or unexpected error has occured
120: --

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

125: --
126: p_saved_search_criteria_id := null;
127: p_object_version_number := null;
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 90);
130: raise;
131: end create_search_criteria;
132: --
133: -- ----------------------------------------------------------------------------

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

148: l_object_version_number irc_saved_search_criteria.object_version_number%TYPE;
149: l_proc varchar2(72) := g_package||'update_search_criteria';
150:
151: begin
152: hr_utility.set_location('Entering:'|| l_proc, 10);
153: --
154: -- Issue a savepoint
155: --
156: savepoint update_search_criteria;

Line 167: hr_utility.set_location(l_proc, 20);

163: --
164: -- Truncate the time portion from all IN date parameters
165: --
166:
167: hr_utility.set_location(l_proc, 20);
168: --
169: -- Call Before Process User Hook
170: --
171: begin

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

180: (p_module_name => 'update_search_criteria'
181: ,p_hook_type => 'BP'
182: );
183: end;
184: hr_utility.set_location(l_proc, 30);
185: --
186: -- Validation in addition to Row Handlers
187: --
188:

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

193: (p_vacancy_id => p_vacancy_id
194: ,p_saved_search_criteria_id => l_saved_search_criteria_id
195: ,p_object_version_number => l_object_version_number
196: );
197: hr_utility.set_location(' Leaving:'||l_proc, 50);
198: --
199: -- Call After Process User Hook
200: --
201: begin

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

222: --
223: p_saved_search_criteria_id := l_saved_search_criteria_id;
224: p_object_version_number := l_object_version_number;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 70);
227: exception
228: when hr_api.validate_enabled then
229: --
230: -- As the Validate_Enabled exception has been raised

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

238: --
239: p_saved_search_criteria_id := p_saved_search_criteria_id;
240: p_object_version_number := p_object_version_number;
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 80);
243: when others then
244: --
245: -- A validation or unexpected error has occured
246: --

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

251: --
252: p_saved_search_criteria_id := p_saved_search_criteria_id;
253: p_object_version_number := p_object_version_number;
254: --
255: hr_utility.set_location(' Leaving:'||l_proc, 90);
256: raise;
257: end update_search_criteria;
258: --
259:

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

271: -- Declare cursors and local variables
272: --
273: l_proc varchar2(72) := g_package||'delete_search_criteria';
274: begin
275: hr_utility.set_location('Entering:'|| l_proc, 10);
276: --
277: -- Issue a savepoint
278: --
279: savepoint delete_search_criteria;

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

324: if p_validate then
325: raise hr_api.validate_enabled;
326: end if;
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 70);
329: exception
330: when hr_api.validate_enabled then
331: --
332: -- As the Validate_Enabled exception has been raised

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

333: -- we must rollback to the savepoint
334: --
335: rollback to delete_search_criteria;
336: --
337: hr_utility.set_location(' Leaving:'||l_proc, 80);
338: when others then
339: --
340: -- A validation or unexpected error has occured
341: --

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

340: -- A validation or unexpected error has occured
341: --
342: rollback to delete_search_criteria;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 90);
345: raise;
346: end delete_search_criteria;
347: --
348: end irc_saved_search_criteria_api;