26: --
27: l_effective_date date;
28: l_proc varchar2(72) := g_package||'insert_quest_fields';
29: begin
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: --
32: -- Issue a savepoint
33: --
34: savepoint insert_quest_fields;
118: -- Set all IN OUT and OUT parameters with out values
119: --
120:
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 70);
123: exception
124: when hr_api.validate_enabled then
125: --
126: -- As the Validate_Enabled exception has been raised
134: --
135: p_field_id := null;
136: p_object_version_number := null;
137:
138: hr_utility.set_location(' Leaving:'||l_proc, 80);
139: when others then
140: --
141: -- A validation or unexpected error has occured
142: --
147: --
148: p_field_id := null;
149: p_object_version_number := null;
150:
151: hr_utility.set_location(' Leaving:'||l_proc, 90);
152: raise;
153: end insert_quest_fields;
154: --
155:
176: l_effective_date date;
177: l_object_version_number number;
178: l_proc varchar2(72) := g_package||'update_quest_fields';
179: begin
180: hr_utility.set_location('Entering:'|| l_proc, 10);
181: --
182: -- Issue a savepoint
183: --
184: savepoint update_quest_fields;
264: -- Set all IN OUT and OUT parameters with out values
265: --
266:
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 70);
269: exception
270: when hr_api.validate_enabled then
271: --
272: -- As the Validate_Enabled exception has been raised
279: -- when validation only mode is being used.)
280: --
281: p_object_version_number := l_object_version_number;
282:
283: hr_utility.set_location(' Leaving:'||l_proc, 80);
284: when others then
285: --
286: -- A validation or unexpected error has occured
287: --
292: --
293:
294: p_object_version_number := l_object_version_number;
295:
296: hr_utility.set_location(' Leaving:'||l_proc, 90);
297: raise;
298: end update_quest_fields;
299: --
300:
318:
319: l_proc varchar2(72) := g_package||'delete_quest_fields';
320:
321: begin
322: hr_utility.set_location('Entering:'|| l_proc, 10);
323: --
324: -- Issue a savepoint
325: --
326: savepoint delete_quest_fields;
404: -- Set all IN OUT and OUT parameters with out values
405: --
406:
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: exception
410: when hr_api.validate_enabled then
411: --
412: -- As the Validate_Enabled exception has been raised
418: -- (Any key or derived arguments must be set to null
419: -- when validation only mode is being used.)
420: --
421:
422: hr_utility.set_location(' Leaving:'||l_proc, 80);
423: when others then
424: --
425: -- A validation or unexpected error has occured
426: --
429: -- Reset IN OUT parameters and set all
430: -- OUT parameters, including warnings, to null
431: --
432:
433: hr_utility.set_location(' Leaving:'||l_proc, 90);
434: raise;
435:
436: end delete_quest_fields;
437: --