DBA Data[Home] [Help]

APPS.PQH_TXN_CAT_ATTRIBUTES_API dependencies on HR_UTILITY

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

34: l_object_version_number pqh_txn_category_attributes.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_TXN_CAT_ATTRIBUTE;

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

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

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

125: -- End of API User Hook for the after hook of create_TXN_CAT_ATTRIBUTE
126: --
127: end;
128: --
129: hr_utility.set_location(l_proc, 60);
130: --
131: -- When in validation only mode raise the Validate_Enabled exception
132: --
133: if p_validate then

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

138: --
139: p_txn_category_attribute_id := l_txn_category_attribute_id;
140: p_object_version_number := l_object_version_number;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: --
144: exception
145: --
146: when hr_api.validate_enabled then

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

155: -- when validation only mode is being used.)
156: --
157: p_txn_category_attribute_id := null;
158: p_object_version_number := null;
159: hr_utility.set_location(' Leaving:'||l_proc, 80);
160: --
161: when others then
162: p_txn_category_attribute_id := l_txn_category_attribute_id;
163: p_object_version_number := l_object_version_number;

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

197: l_object_version_number pqh_txn_category_attributes.object_version_number%TYPE;
198: --
199: begin
200: --
201: hr_utility.set_location('Entering:'|| l_proc, 10);
202: --
203: -- Issue a savepoint if operating in validation only mode
204: --
205: savepoint update_TXN_CAT_ATTRIBUTE;

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

203: -- Issue a savepoint if operating in validation only mode
204: --
205: savepoint update_TXN_CAT_ATTRIBUTE;
206: --
207: hr_utility.set_location(l_proc, 20);
208: --
209: -- Process Logic
210: --
211: l_object_version_number := p_object_version_number;

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

292: -- End of API User Hook for the after hook of update_TXN_CAT_ATTRIBUTE
293: --
294: end;
295: --
296: hr_utility.set_location(l_proc, 60);
297: --
298: -- When in validation only mode raise the Validate_Enabled exception
299: --
300: if p_validate then

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

304: -- Set all output arguments
305: --
306: p_object_version_number := l_object_version_number;
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 70);
309: --
310: exception
311: --
312: when hr_api.validate_enabled then

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

319: -- Only set output warning arguments
320: -- (Any key or derived arguments must be set to null
321: -- when validation only mode is being used.)
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 80);
324: --
325: when others then
326: p_object_version_number := l_object_version_number;
327: --

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

349: l_object_version_number pqh_txn_category_attributes.object_version_number%TYPE;
350: --
351: begin
352: --
353: hr_utility.set_location('Entering:'|| l_proc, 10);
354: --
355: -- Issue a savepoint if operating in validation only mode
356: --
357: savepoint delete_TXN_CAT_ATTRIBUTE;

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

355: -- Issue a savepoint if operating in validation only mode
356: --
357: savepoint delete_TXN_CAT_ATTRIBUTE;
358: --
359: hr_utility.set_location(l_proc, 20);
360: --
361: -- Process Logic
362: --
363: l_object_version_number := p_object_version_number;

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

411: -- End of API User Hook for the after hook of delete_TXN_CAT_ATTRIBUTE
412: --
413: end;
414: --
415: hr_utility.set_location(l_proc, 60);
416: --
417: -- When in validation only mode raise the Validate_Enabled exception
418: --
419: if p_validate then

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

419: if p_validate then
420: raise hr_api.validate_enabled;
421: end if;
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 70);
424: --
425: exception
426: --
427: when hr_api.validate_enabled then

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

461: l_proc varchar2(72) := g_package||'lck';
462: --
463: begin
464: --
465: hr_utility.set_location('Entering:'|| l_proc, 10);
466: --
467: pqh_tca_shd.lck
468: (
469: p_txn_category_attribute_id => p_txn_category_attribute_id

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

469: p_txn_category_attribute_id => p_txn_category_attribute_id
470: ,p_object_version_number => p_object_version_number
471: );
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 70);
474: --
475: end lck;
476: --
477: --