51: l_conference_server_id number;
52: l_object_version_number number;
53: l_effective_date date;
54: begin
55: hr_utility.set_location('Entering:'|| l_proc, 10);
56: --
57: -- Issue a savepoint
58: --
59: savepoint CREATE_CONFERENCE_SERVER;
219: --
220: p_conference_server_id := l_conference_server_id;
221: p_object_version_number := l_object_version_number;
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 70);
224: exception
225: when hr_api.validate_enabled then
226: --
227: -- As the Validate_Enabled exception has been raised
234: -- when validation only mode is being used.)
235: --
236: p_conference_server_id := null;
237: p_object_version_number := null;
238: hr_utility.set_location(' Leaving:'||l_proc, 80);
239: when others then
240: --
241: -- A validation or unexpected error has occured
242: --
242: --
243: rollback to CREATE_CONFERENCE_SERVER;
244: p_conference_server_id := null;
245: p_object_version_number := null;
246: hr_utility.set_location(' Leaving:'||l_proc, 90);
247: raise;
248: end create_conference_server;
249: --
250: -- ----------------------------------------------------------------------------
292: l_proc varchar2(72) := g_package||' Update Conference Server';
293: l_effective_date date;
294: l_object_version_number number := p_object_version_number;
295: begin
296: hr_utility.set_location('Entering:'|| l_proc, 10);
297: --
298: -- Issue a savepoint
299: --
300: savepoint UPDATE_CONFERENCE_SERVER;
454: end if;
455: --
456: -- Set all output arguments
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 70);
459: exception
460: when hr_api.validate_enabled then
461: --
462: -- As the Validate_Enabled exception has been raised
468: -- (Any key or derived arguments must be set to null
469: -- when validation only mode is being used.)
470: --
471: p_object_version_number := null;
472: hr_utility.set_location(' Leaving:'||l_proc, 80);
473: when others then
474: --
475: -- A validation or unexpected error has occured
476: --
475: -- A validation or unexpected error has occured
476: --
477: rollback to UPDATE_CONFERENCE_SERVER;
478: p_object_version_number := l_object_version_number;
479: hr_utility.set_location(' Leaving:'||l_proc, 90);
480: raise;
481: end update_conference_server;
482: --
483: -- ----------------------------------------------------------------------------
496: l_object_version_id number;
497: --
498: --
499: begin
500: hr_utility.set_location('Entering:'|| l_proc, 10);
501: --
502: -- Issue a savepoint
503: --
504: savepoint DELETE_CONFERENCE_SERVER;
564: --
565: -- Set all output arguments
566: --
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 170);
569: exception
570: when hr_api.validate_enabled then
571: --
572: -- As the Validate_Enabled exception has been raised
577: -- Only set output warning arguments
578: -- (Any key or derived arguments must be set to null
579: -- when validation only mode is being used.)
580: --
581: hr_utility.set_location(' Leaving:'||l_proc, 180);
582: when others then
583: --
584: -- A validation or unexpected error has occured
585: --
583: --
584: -- A validation or unexpected error has occured
585: --
586: rollback to DELETE_CONFERENCE_SERVER;
587: hr_utility.set_location(' Leaving:'||l_proc, 190);
588: raise;
589: end delete_conference_server;
590: --
591: end ota_conference_server_api;