DBA Data[Home] [Help]

APPS.PQH_FYI_NOTIFY_API dependencies on HR_UTILITY

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

30: l_object_version_number pqh_fyi_notify.object_version_number%TYPE;
31: --
32: begin
33: --
34: hr_utility.set_location('Entering:'|| l_proc, 10);
35: --
36: -- Issue a savepoint if operating in validation only mode
37: --
38: savepoint create_fyi_notify;

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

36: -- Issue a savepoint if operating in validation only mode
37: --
38: savepoint create_fyi_notify;
39: --
40: hr_utility.set_location(l_proc, 20);
41: --
42: -- Process Logic
43: --
44: begin

Line 113: hr_utility.set_location(l_proc, 60);

109: -- End of API User Hook for the after hook of create_fyi_notify
110: --
111: end;
112: --
113: hr_utility.set_location(l_proc, 60);
114: --
115: -- When in validation only mode raise the Validate_Enabled exception
116: --
117: if p_validate then

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

122: --
123: p_fyi_notified_id := l_fyi_notified_id;
124: p_object_version_number := l_object_version_number;
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 70);
127: --
128: exception
129: --
130: when hr_api.validate_enabled then

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

139: -- when validation only mode is being used.)
140: --
141: p_fyi_notified_id := null;
142: p_object_version_number := null;
143: hr_utility.set_location(' Leaving:'||l_proc, 80);
144: --
145: when others then
146: p_fyi_notified_id := null;
147: p_object_version_number := null;

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

176: l_object_version_number pqh_fyi_notify.object_version_number%TYPE;
177: --
178: begin
179: --
180: hr_utility.set_location('Entering:'|| l_proc, 10);
181: --
182: -- Issue a savepoint if operating in validation only mode
183: --
184: savepoint update_fyi_notify;

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

182: -- Issue a savepoint if operating in validation only mode
183: --
184: savepoint update_fyi_notify;
185: --
186: hr_utility.set_location(l_proc, 20);
187: --
188: -- Process Logic
189: --
190: l_object_version_number := p_object_version_number;

Line 262: hr_utility.set_location(l_proc, 60);

258: -- End of API User Hook for the after hook of update_fyi_notify
259: --
260: end;
261: --
262: hr_utility.set_location(l_proc, 60);
263: --
264: -- When in validation only mode raise the Validate_Enabled exception
265: --
266: if p_validate then

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

270: -- Set all output arguments
271: --
272: p_object_version_number := l_object_version_number;
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 70);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then

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

285: -- Only set output warning arguments
286: -- (Any key or derived arguments must be set to null
287: -- when validation only mode is being used.)
288: --
289: hr_utility.set_location(' Leaving:'||l_proc, 80);
290: --
291: when others then
292: p_object_version_number := l_object_version_number;
293: --

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

314: l_object_version_number pqh_fyi_notify.object_version_number%TYPE;
315: --
316: begin
317: --
318: hr_utility.set_location('Entering:'|| l_proc, 10);
319: --
320: -- Issue a savepoint if operating in validation only mode
321: --
322: savepoint delete_fyi_notify;

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

320: -- Issue a savepoint if operating in validation only mode
321: --
322: savepoint delete_fyi_notify;
323: --
324: hr_utility.set_location(l_proc, 20);
325: --
326: -- Process Logic
327: --
328: l_object_version_number := p_object_version_number;

Line 380: hr_utility.set_location(l_proc, 60);

376: -- End of API User Hook for the after hook of delete_fyi_notify
377: --
378: end;
379: --
380: hr_utility.set_location(l_proc, 60);
381: --
382: -- When in validation only mode raise the Validate_Enabled exception
383: --
384: if p_validate then

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

384: if p_validate then
385: raise hr_api.validate_enabled;
386: end if;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 70);
389: --
390: exception
391: --
392: when hr_api.validate_enabled then

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

426: l_proc varchar2(72) := g_package||'lck';
427: --
428: begin
429: --
430: hr_utility.set_location('Entering:'|| l_proc, 10);
431: --
432: pqh_fyn_shd.lck
433: (
434: p_fyi_notified_id => p_fyi_notified_id

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

434: p_fyi_notified_id => p_fyi_notified_id
435: ,p_object_version_number => p_object_version_number
436: );
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 70);
439: --
440: end lck;
441: --
442: end pqh_fyi_notify_api;