DBA Data[Home] [Help]

APPS.PQH_REF_TEMPLATES_API dependencies on HR_UTILITY

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

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

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

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

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

93: -- End of API User Hook for the after hook of create_REF_TEMPLATE
94: --
95: end;
96: --
97: hr_utility.set_location(l_proc, 60);
98: --
99: -- When in validation only mode raise the Validate_Enabled exception
100: --
101: if p_validate then

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

106: --
107: p_ref_template_id := l_ref_template_id;
108: p_object_version_number := l_object_version_number;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 70);
111: --
112: exception
113: --
114: when hr_api.validate_enabled then

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

123: -- when validation only mode is being used.)
124: --
125: p_ref_template_id := null;
126: p_object_version_number := null;
127: hr_utility.set_location(' Leaving:'||l_proc, 80);
128: --
129: when others then
130: p_ref_template_id := null;
131: p_object_version_number := null;

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

156: l_object_version_number pqh_ref_templates.object_version_number%TYPE;
157: --
158: begin
159: --
160: hr_utility.set_location('Entering:'|| l_proc, 10);
161: --
162: -- Issue a savepoint if operating in validation only mode
163: --
164: savepoint update_REF_TEMPLATES;

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

162: -- Issue a savepoint if operating in validation only mode
163: --
164: savepoint update_REF_TEMPLATES;
165: --
166: hr_utility.set_location(l_proc, 20);
167: --
168: -- Process Logic
169: --
170: l_object_version_number := p_object_version_number;

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

229: -- End of API User Hook for the after hook of update_REF_TEMPLATE
230: --
231: end;
232: --
233: hr_utility.set_location(l_proc, 60);
234: --
235: -- When in validation only mode raise the Validate_Enabled exception
236: --
237: if p_validate then

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

241: -- Set all output arguments
242: --
243: p_object_version_number := l_object_version_number;
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 70);
246: --
247: exception
248: --
249: when hr_api.validate_enabled then

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

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

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

285: l_object_version_number pqh_ref_templates.object_version_number%TYPE;
286: --
287: begin
288: --
289: hr_utility.set_location('Entering:'|| l_proc, 10);
290: --
291: -- Issue a savepoint if operating in validation only mode
292: --
293: savepoint delete_REF_TEMPLATES;

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

291: -- Issue a savepoint if operating in validation only mode
292: --
293: savepoint delete_REF_TEMPLATES;
294: --
295: hr_utility.set_location(l_proc, 20);
296: --
297: -- Process Logic
298: --
299: l_object_version_number := p_object_version_number;

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

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

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

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

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

400: l_proc varchar2(72) := g_package||'lck';
401: --
402: begin
403: --
404: hr_utility.set_location('Entering:'|| l_proc, 10);
405: --
406: pqh_rft_shd.lck
407: (
408: p_ref_template_id => p_ref_template_id

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

408: p_ref_template_id => p_ref_template_id
409: ,p_object_version_number => p_object_version_number
410: );
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 70);
413: --
414: end lck;
415: --
416: end pqh_REF_TEMPLATES_api;