DBA Data[Home] [Help]

APPS.PQH_TEMPLATES_API dependencies on HR_UTILITY

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

34: l_object_version_number pqh_templates.object_version_number%TYPE;
35: --
36: begin
37: --
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
40: -- Issue a savepoint if operating in validation only mode
41: --
42: savepoint create_TEMPLATES;

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

40: -- Issue a savepoint if operating in validation only mode
41: --
42: savepoint create_TEMPLATES;
43: --
44: hr_utility.set_location(l_proc, 20);
45: --
46: -- Process Logic
47: --
48: begin

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

131: -- End of API User Hook for the after hook of create_GENERIC_TEMPLATE
132: --
133: end;
134: --
135: hr_utility.set_location(l_proc, 60);
136: --
137: -- When in validation only mode raise the Validate_Enabled exception
138: --
139: if p_validate then

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

144: --
145: p_template_id := l_template_id;
146: p_object_version_number := l_object_version_number;
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 70);
149: --
150: exception
151: --
152: when hr_api.validate_enabled then

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

161: -- when validation only mode is being used.)
162: --
163: p_template_id := null;
164: p_object_version_number := null;
165: hr_utility.set_location(' Leaving:'||l_proc, 80);
166: --
167: when others then
168: p_template_id := null;
169: p_object_version_number := null;

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

202: l_object_version_number pqh_templates.object_version_number%TYPE;
203: --
204: begin
205: --
206: hr_utility.set_location('Entering:'|| l_proc, 10);
207: --
208: -- Issue a savepoint if operating in validation only mode
209: --
210: savepoint update_TEMPLATES;

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

208: -- Issue a savepoint if operating in validation only mode
209: --
210: savepoint update_TEMPLATES;
211: --
212: hr_utility.set_location(l_proc, 20);
213: --
214: -- Process Logic
215: --
216: l_object_version_number := p_object_version_number;

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

300: -- End of API User Hook for the after hook of update_GENERIC_TEMPLATE
301: --
302: end;
303: --
304: hr_utility.set_location(l_proc, 60);
305: --
306: -- When in validation only mode raise the Validate_Enabled exception
307: --
308: if p_validate then

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

312: -- Set all output arguments
313: --
314: p_object_version_number := l_object_version_number;
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 70);
317: --
318: exception
319: --
320: when hr_api.validate_enabled then

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

327: -- Only set output warning arguments
328: -- (Any key or derived arguments must be set to null
329: -- when validation only mode is being used.)
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 80);
332: --
333: when others then
334: p_object_version_number := l_object_version_number;
335: --

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

356: l_object_version_number pqh_templates.object_version_number%TYPE;
357: --
358: begin
359: --
360: hr_utility.set_location('Entering:'|| l_proc, 10);
361: --
362: -- Issue a savepoint if operating in validation only mode
363: --
364: savepoint delete_TEMPLATES;

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

362: -- Issue a savepoint if operating in validation only mode
363: --
364: savepoint delete_TEMPLATES;
365: --
366: hr_utility.set_location(l_proc, 20);
367: --
368: -- Process Logic
369: --
370: l_object_version_number := p_object_version_number;

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

435: -- End of API User Hook for the after hook of delete_GENERIC_TEMPLATE
436: --
437: end;
438: --
439: hr_utility.set_location(l_proc, 60);
440: --
441: -- When in validation only mode raise the Validate_Enabled exception
442: --
443: if p_validate then

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

443: if p_validate then
444: raise hr_api.validate_enabled;
445: end if;
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 70);
448: --
449: exception
450: --
451: when hr_api.validate_enabled then

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

486: l_proc varchar2(72) := g_package||'lck';
487: --
488: begin
489: --
490: hr_utility.set_location('Entering:'|| l_proc, 10);
491: --
492: pqh_tem_shd.lck
493: (
494: p_template_id => p_template_id

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

494: p_template_id => p_template_id
495: ,p_object_version_number => p_object_version_number
496: );
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 70);
499: --
500: end lck;
501: --
502: **/