[Home] [Help]
74: --
75:
76: -- End of Before Process User Hook call
77: --
78: hr_utility.set_location(l_proc, 7);
79: --
80: --
81: -- Validate the language parameter. l_language_code should be passed to functions
82: -- instead of p_language_code from now on, to allow an IN OUT parameter to
84: --
85: l_language_code := p_language_code;
86: --hr_api.validate_language_code(p_language_code => l_language_code);
87: --
88: hr_utility.set_location(l_proc, 20);
89:
90: --
91: -- Process Logic
92: --
123:
124: p_object_version_number := l_object_version_number;
125: p_document_type_id := l_document_type_id;
126: --
127: hr_utility.set_location(l_proc, 8);
128: --
129: -- Call After Process User Hook
130: --
131:
164: if p_validate then
165: raise hr_api.validate_enabled;
166: end if;
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 11);
169: exception
170: when hr_api.validate_enabled then
171: --
172: -- As the Validate_Enabled exception has been raised
180: --
181: p_document_type_id := null;
182: p_object_version_number := null;
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 12);
185: --
186: when others then
187: --
188: -- A validation or unexpected error has occurred
232: l_object_version_number hr_document_types.object_version_number%TYPE;
233: l_ovn hr_document_types.object_version_number%TYPE := p_object_version_number;
234: --
235: begin
236: hr_utility.set_location('Entering:'|| l_proc, 5);
237: --
238: -- Issue a savepoint
239: --
240: savepoint update_document_type;
271: --
272: -- End of Before Process User Hook call
273: --
274: --
275: hr_utility.set_location(l_proc, 7);
276: --
277: -- Store the original ovn in case we rollback when p_validate is true
278: --
279: l_object_version_number := p_object_version_number;
304: p_document_type_id => p_document_type_id,
305: p_description => p_description,
306: p_document_type =>p_document_type
307: );
308: hr_utility.set_location(l_proc, 8);
309: --
310: -- Call After Process User Hook
311: --
312: begin
344: if p_validate then
345: raise hr_api.validate_enabled;
346: end if;
347: --
348: hr_utility.set_location(' Leaving:'||l_proc, 11);
349: exception
350: when hr_api.validate_enabled then
351: --
352: -- As the Validate_Enabled exception has been raised
359: -- when validation only mode is being used.)
360: --
361: p_object_version_number := l_object_version_number;
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 12);
364: --
365: when others then
366: --
367: -- A validation or unexpected error has occurred
391: --
392: l_proc varchar2(72) := g_package||'delete_document_type';
393: --
394: begin
395: hr_utility.set_location('Entering:'|| l_proc, 5);
396: --
397: -- Issue a savepoint
398: --
399: savepoint delete_document_type;
414: end;
415: --
416: -- End of Before Process User Hook call
417: --
418: hr_utility.set_location(l_proc, 7);
419: --
420: -- Process Logic - Delete Person Extra Info details
421: --
422: hr_dty_del.del
427: hr_dtt_del.del_tl
428: (
429: p_document_type_id => p_document_type_id
430: );
431: hr_utility.set_location(l_proc, 8);
432: --
433: -- Call Before Process User Hook
434: --
435: begin
452: if p_validate then
453: raise hr_api.validate_enabled;
454: end if;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 11);
457: exception
458: when hr_api.validate_enabled then
459: --
460: -- As the Validate_Enabled exception has been raised
461: -- we must rollback to the savepoint
462: --
463: ROLLBACK TO delete_person_extra_info;
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 12);
466: --
467: when others then
468: --
469: -- A validation or unexpected error has occurred