DBA Data[Home] [Help]

APPS.IRC_NOTES_API dependencies on HR_UTILITY

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

22: l_note_id number(15);
23: l_object_version_number number(9);
24: l_proc varchar2(72) := g_package||'CREATE_NOTE';
25: begin
26: hr_utility.set_location('Entering:'|| l_proc, 10);
27: --
28: -- Issue a savepoint
29: --
30: savepoint CREATE_NOTE;

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

84: --
85: p_note_id := l_note_id;
86: p_object_version_number := l_object_version_number;
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 70);
89: exception
90: when hr_api.validate_enabled then
91: --
92: -- As the Validate_Enabled exception has been raised

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

99: -- when validation only mode is being used.)
100: --
101: p_note_id := null;
102: p_object_version_number := null;
103: hr_utility.set_location(' Leaving:'||l_proc, 80);
104: when others then
105: --
106: -- A validation or unexpected error has occured
107: --

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

111: -- OUT parameters, including warnings, to null
112: --
113: p_note_id := null;
114: p_object_version_number := null;
115: hr_utility.set_location(' Leaving:'||l_proc, 90);
116: raise;
117: end CREATE_NOTE;
118: --
119: --

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

133: --
134: l_object_version_number number(9);
135: l_proc varchar2(72) := g_package||'UPDATE_NOTE';
136: begin
137: hr_utility.set_location('Entering:'|| l_proc, 10);
138: --
139: -- Issue a savepoint
140: --
141: savepoint UPDATE_NOTE;

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

198: -- Set all IN OUT and OUT parameters with out values
199: --
200: p_object_version_number := l_object_version_number;
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 70);
203: exception
204: when hr_api.validate_enabled then
205: --
206: -- As the Validate_Enabled exception has been raised

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

212: -- (Any key or derived arguments must be set to null
213: -- when validation only mode is being used.)
214: --
215: p_object_version_number := null;
216: hr_utility.set_location(' Leaving:'||l_proc, 80);
217: when others then
218: --
219: -- A validation or unexpected error has occured
220: --

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

223: -- Reset IN OUT parameters and set all
224: -- OUT parameters, including warnings, to null
225: --
226: p_object_version_number := null;
227: hr_utility.set_location(' Leaving:'||l_proc, 90);
228: raise;
229: end UPDATE_NOTE;
230: --
231: --

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

242: -- Declare cursors and local variables
243: --
244: l_proc varchar2(72) := g_package||'DELETE_NOTE';
245: begin
246: hr_utility.set_location('Entering:'|| l_proc, 10);
247: --
248: -- Issue a savepoint
249: --
250: savepoint DELETE_NOTE;

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

294: if p_validate then
295: raise hr_api.validate_enabled;
296: end if;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 70);
299: exception
300: when hr_api.validate_enabled then
301: --
302: -- As the Validate_Enabled exception has been raised

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

303: -- we must rollback to the savepoint
304: --
305: rollback to DELETE_NOTE;
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 80);
308: when others then
309: --
310: -- A validation or unexpected error has occured
311: --

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

310: -- A validation or unexpected error has occured
311: --
312: rollback to DELETE_NOTE;
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 90);
315: raise;
316: end DELETE_NOTE;
317: --
318: end IRC_NOTES_API;