57:
58: --
59: Begin
60: --
61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Issue a savepoint
64: --
65: Savepoint create_config_information;
63: -- Issue a savepoint
64: --
65: Savepoint create_config_information;
66: --
67: hr_utility.set_location(l_proc, 15);
68: --
69: -- All date input parameters must be truncated to remove time elements
70: --
71: l_effective_date := trunc (p_effective_date);
77: --
78: l_language_code := p_language_code;
79: hr_api.validate_language_code(p_language_code => l_language_code);
80: --
81: hr_utility.set_location(l_proc, 20);
82:
83: -- Process Logic
84: --
85: -- Insert non-translatable rows into PER_RI_CONFIG_LOCATION first
115: );
116: --
117:
118:
119: hr_utility.set_location(l_proc, 60);
120: --
121: -- When in validation only mode raise the Validate_Enabled exception
122: --
123: If p_validate Then
127: -- Set all output arguments
128: --
129: p_object_version_number := l_object_version_number;
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 70);
132: --
133: Exception
134: --
135: When hr_api.validate_enabled Then
143: -- (Any key or derived arguments must be set to null
144: -- when validation only mode is being used.)
145: --
146: p_object_version_number := Null;
147: hr_utility.set_location(' Leaving:'||l_proc, 80);
148: When Others Then
149: --
150: -- A validation or unexpected error has occurred
151: Rollback To create_config_information;
150: -- A validation or unexpected error has occurred
151: Rollback To create_config_information;
152: -- Set OUT parameters.
153: p_object_version_number := Null;
154: hr_utility.set_location(' Leaving:'||l_proc, 90);
155: Raise;
156: --
157: End create_location;
158: -- ----------------------------------------------------------------------------
203: l_temp_ovn number := p_object_version_number;
204: --
205: BEGIN
206: --
207: hr_utility.set_location('Entering:'|| l_proc, 10);
208: --
209: -- Issue a savepoint.
210: --
211: savepoint update_location;
221: -- passed through.
222: --
223: l_language_code := p_language_code;
224: hr_api.validate_language_code(p_language_code => l_language_code);
225: hr_utility.set_location(l_proc, 20);
226: --
227: --
228: -- Process Logic
229: --
263: );
264: --
265:
266:
267: hr_utility.set_location(l_proc, 60);
268: --
269: -- When in validation only mode raise the Validate_Enabled exception
270: --
271: If p_validate Then
276: -- never reached, so p_object_version_number is passed back unchanged.
277: --
278: p_object_version_number := l_object_version_number;
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 70);
281: --
282: Exception
283: --
284: When hr_api.validate_enabled Then
292: -- (Any key or derived arguments must be set to null
293: -- when validation only mode is being used.)
294: -- Reset IN OUT parameters.
295: p_object_version_number := l_temp_ovn;
296: hr_utility.set_location(' Leaving:'||l_proc, 80);
297: When Others Then
298: --
299: -- A validation or unexpected error has occurred
300: Rollback To update_location;
299: -- A validation or unexpected error has occurred
300: Rollback To update_location;
301: -- Reset IN OUT parameters.
302: p_object_version_number := l_temp_ovn;
303: hr_utility.set_location(' Leaving:'||l_proc, 90);
304: Raise;
305: --
306: --
307: End update_location;
322: l_proc Varchar2(72) := g_package||'delete_config_information';
323: --
324: Begin
325: --
326: hr_utility.set_location('Entering:'|| l_proc, 10);
327: --
328: -- Issue a savepoint
329: --
330: Savepoint delete_workbench_item;
331:
332:
333: --
334:
335: hr_utility.set_location( l_proc, 40);
336:
337: per_cnl_del.del(p_location_id => p_location_id
338: ,p_object_version_number => p_object_version_number);
339:
338: ,p_object_version_number => p_object_version_number);
339:
340:
341: --
342: hr_utility.set_location(' Leaving:'||l_proc, 60);
343: --
344: -- When in validation only mode raise the Validate_Enabled exception
345: --
346: If p_validate Then
360: -- Only set output warning arguments
361: -- (Any key or derived arguments must be set to null
362: -- when validation only mode is being used.)
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 80);
365: When Others Then
366: --
367: -- A validation or unexpected error has occurred
368: Rollback To delete_location;
365: When Others Then
366: --
367: -- A validation or unexpected error has occurred
368: Rollback To delete_location;
369: hr_utility.set_location(' Leaving:'||l_proc, 90);
370: Raise;
371: --
372: End delete_location;
373: