DBA Data[Home] [Help]

APPS.PQH_ROLE_TEMPLATES_API dependencies on HR_UTILITY

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

27: l_object_version_number pqh_role_templates.object_version_number%TYPE;
28: --
29: begin
30: --
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Issue a savepoint if operating in validation only mode
34: --
35: savepoint create_role_template;

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

33: -- Issue a savepoint if operating in validation only mode
34: --
35: savepoint create_role_template;
36: --
37: hr_utility.set_location(l_proc, 20);
38: --
39: -- Process Logic
40: --
41: begin

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

97: -- End of API User Hook for the after hook of create_role_template
98: --
99: end;
100: --
101: hr_utility.set_location(l_proc, 60);
102: --
103: -- When in validation only mode raise the Validate_Enabled exception
104: --
105: if p_validate then

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

110: --
111: p_role_template_id := l_role_template_id;
112: p_object_version_number := l_object_version_number;
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 70);
115: --
116: exception
117: --
118: when hr_api.validate_enabled then

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

127: -- when validation only mode is being used.)
128: --
129: p_role_template_id := null;
130: p_object_version_number := null;
131: hr_utility.set_location(' Leaving:'||l_proc, 80);
132: --
133: when others then
134: p_role_template_id := null;
135: p_object_version_number := null;

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

162: p_transaction_category_id number(15) := hr_api.g_number;
163: --
164: begin
165: --
166: hr_utility.set_location('Entering:'|| l_proc, 10);
167: --
168: -- Issue a savepoint if operating in validation only mode
169: --
170: savepoint update_role_template;

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

168: -- Issue a savepoint if operating in validation only mode
169: --
170: savepoint update_role_template;
171: --
172: hr_utility.set_location(l_proc, 20);
173: --
174: -- Process Logic
175: --
176: l_object_version_number := p_object_version_number;

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

234: -- End of API User Hook for the after hook of update_role_template
235: --
236: end;
237: --
238: hr_utility.set_location(l_proc, 60);
239: --
240: -- When in validation only mode raise the Validate_Enabled exception
241: --
242: if p_validate then

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

246: -- Set all output arguments
247: --
248: p_object_version_number := l_object_version_number;
249: --
250: hr_utility.set_location(' Leaving:'||l_proc, 70);
251: --
252: exception
253: --
254: when hr_api.validate_enabled then

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

261: -- Only set output warning arguments
262: -- (Any key or derived arguments must be set to null
263: -- when validation only mode is being used.)
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 80);
266: --
267: when others then
268: p_object_version_number := l_object_version_number;
269: --

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

290: l_object_version_number pqh_role_templates.object_version_number%TYPE;
291: --
292: begin
293: --
294: hr_utility.set_location('Entering:'|| l_proc, 10);
295: --
296: -- Issue a savepoint if operating in validation only mode
297: --
298: savepoint delete_role_template;

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

296: -- Issue a savepoint if operating in validation only mode
297: --
298: savepoint delete_role_template;
299: --
300: hr_utility.set_location(l_proc, 20);
301: --
302: -- Process Logic
303: --
304: l_object_version_number := p_object_version_number;

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

352: -- End of API User Hook for the after hook of delete_role_template
353: --
354: end;
355: --
356: hr_utility.set_location(l_proc, 60);
357: --
358: -- When in validation only mode raise the Validate_Enabled exception
359: --
360: if p_validate then

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

360: if p_validate then
361: raise hr_api.validate_enabled;
362: end if;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 70);
365: --
366: exception
367: --
368: when hr_api.validate_enabled then

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

402: l_proc varchar2(72) := g_package||'lck';
403: --
404: begin
405: --
406: hr_utility.set_location('Entering:'|| l_proc, 10);
407: --
408: pqh_rtm_shd.lck
409: (
410: p_role_template_id => p_role_template_id

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

410: p_role_template_id => p_role_template_id
411: ,p_object_version_number => p_object_version_number
412: );
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 70);
415: --
416: end lck;
417: --
418: end PQH_ROLE_TEMPLATES_api;