DBA Data[Home] [Help]

APPS.PQH_TEMPLATE_ATTRIBUTES_API dependencies on HR_UTILITY

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

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

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

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

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

101: -- End of API User Hook for the after hook of create_TEMPLATE_ATTRIBUTE
102: --
103: end;
104: --
105: hr_utility.set_location(l_proc, 60);
106: --
107: -- When in validation only mode raise the Validate_Enabled exception
108: --
109: if p_validate then

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

114: --
115: p_template_attribute_id := l_template_attribute_id;
116: p_object_version_number := l_object_version_number;
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 70);
119: --
120: exception
121: --
122: when hr_api.validate_enabled then

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

131: -- when validation only mode is being used.)
132: --
133: p_template_attribute_id := null;
134: p_object_version_number := null;
135: hr_utility.set_location(' Leaving:'||l_proc, 80);
136: --
137: when others then
138: --
139: -- A validation or unexpected error has occured

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

164: l_object_version_number pqh_template_attributes.object_version_number%TYPE;
165: --
166: begin
167: --
168: hr_utility.set_location('Entering:'|| l_proc, 10);
169: --
170: -- Issue a savepoint if operating in validation only mode
171: --
172: savepoint update_TEMPLATE_ATTRIBUTES;

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

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

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

240: -- End of API User Hook for the after hook of update_TEMPLATE_ATTRIBUTE
241: --
242: end;
243: --
244: hr_utility.set_location(l_proc, 60);
245: --
246: -- When in validation only mode raise the Validate_Enabled exception
247: --
248: if p_validate then

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

252: -- Set all output arguments
253: --
254: p_object_version_number := l_object_version_number;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: --
258: exception
259: --
260: when hr_api.validate_enabled then

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

267: -- Only set output warning arguments
268: -- (Any key or derived arguments must be set to null
269: -- when validation only mode is being used.)
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 80);
272: --
273: when others then
274: --
275: -- A validation or unexpected error has occured

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

295: l_object_version_number pqh_template_attributes.object_version_number%TYPE;
296: --
297: begin
298: --
299: hr_utility.set_location('Entering:'|| l_proc, 10);
300: --
301: -- Issue a savepoint if operating in validation only mode
302: --
303: savepoint delete_TEMPLATE_ATTRIBUTES;

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

301: -- Issue a savepoint if operating in validation only mode
302: --
303: savepoint delete_TEMPLATE_ATTRIBUTES;
304: --
305: hr_utility.set_location(l_proc, 20);
306: --
307: -- Process Logic
308: --
309: l_object_version_number := p_object_version_number;

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

357: -- End of API User Hook for the after hook of delete_TEMPLATE_ATTRIBUTE
358: --
359: end;
360: --
361: hr_utility.set_location(l_proc, 60);
362: --
363: -- When in validation only mode raise the Validate_Enabled exception
364: --
365: if p_validate then

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

365: if p_validate then
366: raise hr_api.validate_enabled;
367: end if;
368: --
369: hr_utility.set_location(' Leaving:'||l_proc, 70);
370: --
371: exception
372: --
373: when hr_api.validate_enabled then

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

407: l_proc varchar2(72) := g_package||'lck';
408: --
409: begin
410: --
411: hr_utility.set_location('Entering:'|| l_proc, 10);
412: --
413: pqh_tat_shd.lck
414: (
415: p_template_attribute_id => p_template_attribute_id

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

415: p_template_attribute_id => p_template_attribute_id
416: ,p_object_version_number => p_object_version_number
417: );
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 70);
420: --
421: end lck;
422: --
423: --

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

458: l_proc varchar2(72) := g_package||'create_update_copied_attribute';
459: --
460: begin
461: --
462: hr_utility.set_location('Entering:'|| l_proc, 10);
463: --
464: For cnt in p_copied_attributes.FIRST .. p_copied_attributes.LAST loop
465: --
466: open c_select_flag(p_copied_attributes(cnt).attribute_id, p_template_id);

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

517: --
518:
519: End loop;
520: --
521: hr_utility.set_location(' Leaving:'||l_proc, 70);
522: --
523: end create_update_copied_attribute;
524: --
525: --