DBA Data[Home] [Help]

APPS.PQH_DOCUMENT_ATTRIBUTES_API dependencies on HR_UTILITY

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

31: l_effective_start_date pqh_document_attributes_f.effective_start_date%TYPE;
32: l_effective_end_date pqh_document_attributes_f.effective_end_date%TYPE;
33: --
34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Issue a savepoint
38: --
39: savepoint CREATE_DOCUMENT_ATTRIBUTE;

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

110: p_object_version_number := l_object_version_number;
111: p_effective_start_date := l_effective_start_date;
112: p_effective_end_date := l_effective_end_date;
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 70);
115: exception
116: when hr_api.validate_enabled then
117: --
118: -- As the Validate_Enabled exception has been raised

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

127: p_document_attribute_id := null;
128: p_object_version_number := null;
129: p_effective_start_date := null;
130: p_effective_end_date := null;
131: hr_utility.set_location(' Leaving:'||l_proc, 80);
132: --
133: when others then
134: --
135: -- A validation or unexpected error has occured

Line 143: hr_utility.set_location(' Leaving:'||l_proc, 90);

139: p_effective_start_date := null;
140: p_effective_end_date := null;
141:
142: rollback to CREATE_DOCUMENT_ATTRIBUTE;
143: hr_utility.set_location(' Leaving:'||l_proc, 90);
144: raise;
145: end create_document_attribute;
146:
147: --

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

172: l_effective_end_date pqh_DOCUMENT_ATTRIBUTES_f.effective_end_date%TYPE;
173: l_object_version_number number := p_object_version_number;
174: --
175: begin
176: hr_utility.set_location('Entering:'|| l_proc, 10);
177: --
178: -- Issue a savepoint
179: --
180: savepoint UPDATE_DOCUMENT_ATTRIBUTE;

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

257: p_object_version_number := l_object_version_number;
258: p_effective_start_date := l_effective_start_date;
259: p_effective_end_date := l_effective_end_date;
260: --
261: hr_utility.set_location(' Leaving:'||l_proc, 70);
262: exception
263: when hr_api.validate_enabled then
264: --
265: -- As the Validate_Enabled exception has been raised

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

274: -- p_document_id := null;
275: p_object_version_number := null;
276: p_effective_start_date := null;
277: p_effective_end_date := null;
278: hr_utility.set_location(' Leaving:'||l_proc, 80);
279: --
280: when others then
281: --
282: -- A validation or unexpected error has occured

Line 290: hr_utility.set_location(' Leaving:'||l_proc, 90);

286: p_effective_start_date := null;
287: p_effective_end_date := null;
288:
289: rollback to UPDATE_DOCUMENT_ATTRIBUTE;
290: hr_utility.set_location(' Leaving:'||l_proc, 90);
291: raise;
292: end update_document_attribute;
293:
294:

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

339: l_effective_end_date pqh_DOCUMENT_ATTRIBUTES_f.effective_end_date%TYPE;
340: l_object_version_number number := p_object_version_number;
341: --
342: begin
343: hr_utility.set_location('Entering:'|| l_proc, 10);
344: --
345: -- Issue a savepoint
346: --
347: savepoint DELETE_DOCUMENT_ATTRIBUTE;

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

410: p_effective_start_date := l_effective_start_date;
411: p_effective_end_date := l_effective_end_date;
412: --
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 70);
415: exception
416: when hr_api.validate_enabled then
417: --
418: -- As the Validate_Enabled exception has been raised

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

427: p_object_version_number := l_object_version_number;
428: p_effective_start_date := null;
429: p_effective_end_date := null;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 80);
432: when others then
433: --
434: -- A validation or unexpected error has occured
435: --

Line 441: hr_utility.set_location(' Leaving:'||l_proc, 90);

437: p_effective_start_date := null;
438: p_effective_end_date := null;
439:
440: rollback to DELETE_DOCUMENT_ATTRIBUTE;
441: hr_utility.set_location(' Leaving:'||l_proc, 90);
442: raise;
443: --
444: end delete_document_attribute;
445: --