DBA Data[Home] [Help]

APPS.IRC_OFFER_STATUS_HISTORY_API dependencies on HR_UTILITY

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

32: l_note_id number;
33: l_note_ovn number;
34: --
35: begin
36: hr_utility.set_location('Entering:'|| l_proc, 10);
37: --
38: -- Issue a savepoint
39: --
40: savepoint CREATE_OFFER_STATUS_HISTORY;

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

149: -- when validation only mode is being used.)
150: --
151: p_offer_status_history_id := null;
152: p_object_version_number := null;
153: hr_utility.set_location(' Leaving:'||l_proc, 80);
154: when others then
155: --
156: -- A validation or unexpected error has occured
157: --

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

161: -- OUT parameters, including warnings, to null
162: --
163: p_offer_status_history_id := null;
164: p_object_version_number := null;
165: hr_utility.set_location(' Leaving:'||l_proc, 90);
166: raise;
167: end CREATE_OFFER_STATUS_HISTORY;
168: --
169: -- ----------------------------------------------------------------------------

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

194: l_effective_date date;
195: l_status_change_date date;
196: --
197: begin
198: hr_utility.set_location('Entering:'|| l_proc, 10);
199: --
200: -- Issue a savepoint
201: --
202: savepoint UPDATE_OFFER_STATUS_HISTORY;

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

284: -- Set all IN OUT and OUT parameters with out values
285: --
286: p_object_version_number := l_object_version_number;
287: --
288: hr_utility.set_location(' Leaving:'||l_proc, 70);
289: exception
290: when hr_api.validate_enabled then
291: --
292: -- As the Validate_Enabled exception has been raised

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

298: -- (Any key or derived arguments must be set to null
299: -- when validation only mode is being used.)
300: --
301: p_object_version_number := null;
302: hr_utility.set_location(' Leaving:'||l_proc, 80);
303: when others then
304: --
305: -- A validation or unexpected error has occured
306: --

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

309: -- Reset IN OUT parameters and set all
310: -- OUT parameters, including warnings, to null
311: --
312: p_object_version_number := null;
313: hr_utility.set_location(' Leaving:'||l_proc, 90);
314: raise;
315: end UPDATE_OFFER_STATUS_HISTORY;
316: --
317: --

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

337: where offer_id = p_offer_id;
338:
339: begin
340:
341: hr_utility.set_location('Entering:'|| l_proc, 10);
342: --
343: -- Issue a savepoint
344: --
345: savepoint DELETE_OFFER_STATUS_HISTORY;

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

392: if p_validate then
393: raise hr_api.validate_enabled;
394: end if;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 70);
397: end loop;
398: exception
399: when hr_api.validate_enabled then
400: --

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

402: -- we must rollback to the savepoint
403: --
404: rollback to DELETE_OFFER_STATUS_HISTORY;
405: --
406: hr_utility.set_location(' Leaving:'||l_proc, 80);
407: when others then
408: --
409: -- A validation or unexpected error has occured
410: --

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

409: -- A validation or unexpected error has occured
410: --
411: rollback to DELETE_OFFER_STATUS_HISTORY;
412: --
413: hr_utility.set_location(' Leaving:'||l_proc, 90);
414: raise;
415: end DELETE_OFFER_STATUS_HISTORY;
416: --
417: end IRC_OFFER_STATUS_HISTORY_API;