46: savepoint create_time_definition_swi;
47: --
48: -- Initialise Multiple Message Detection
49: --
50: hr_multi_message.enable_message_list;
51: --
52: -- Remember IN OUT parameter IN values
53: --
54: --
97: -- Derive the API return status value based on whether
98: -- messages of any type exist in the Multiple Message List.
99: -- Also disable Multiple Message Detection.
100: --
101: p_return_status := hr_multi_message.get_return_status_disable;
102: hr_utility.set_location(' Leaving:' || l_proc,20);
103: --
104: exception
105: when hr_multi_message.error_message_exist then
101: p_return_status := hr_multi_message.get_return_status_disable;
102: hr_utility.set_location(' Leaving:' || l_proc,20);
103: --
104: exception
105: when hr_multi_message.error_message_exist then
106: --
107: -- Catch the Multiple Message List exception which
108: -- indicates API processing has been aborted because
109: -- at least one message exists in the list.
112: --
113: -- Reset IN OUT parameters and set OUT parameters
114: --
115: p_object_version_number := null;
116: p_return_status := hr_multi_message.get_return_status_disable;
117: hr_utility.set_location(' Leaving:' || l_proc, 30);
118: when others then
119: --
120: -- When Multiple Message Detection is enabled catch
123: -- Multiple Message List. Otherwise re-raise the
124: -- error.
125: --
126: rollback to create_time_definition_swi;
127: if hr_multi_message.unexpected_error_add(l_proc) then
128: hr_utility.set_location(' Leaving:' || l_proc,40);
129: raise;
130: end if;
131: --
131: --
132: -- Reset IN OUT and set OUT parameters
133: --
134: p_object_version_number := null;
135: p_return_status := hr_multi_message.get_return_status_disable;
136: hr_utility.set_location(' Leaving:' || l_proc,50);
137: end create_time_definition;
138: -- ----------------------------------------------------------------------------
139: -- |------------------------< update_time_definition >------------------------|
172: savepoint update_time_definition_swi;
173: --
174: -- Initialise Multiple Message Detection
175: --
176: hr_multi_message.enable_message_list;
177: --
178: -- Remember IN OUT parameter IN values
179: --
180: l_object_version_number := p_object_version_number;
217: -- Derive the API return status value based on whether
218: -- messages of any type exist in the Multiple Message List.
219: -- Also disable Multiple Message Detection.
220: --
221: p_return_status := hr_multi_message.get_return_status_disable;
222: hr_utility.set_location(' Leaving:' || l_proc,20);
223: --
224: exception
225: when hr_multi_message.error_message_exist then
221: p_return_status := hr_multi_message.get_return_status_disable;
222: hr_utility.set_location(' Leaving:' || l_proc,20);
223: --
224: exception
225: when hr_multi_message.error_message_exist then
226: --
227: -- Catch the Multiple Message List exception which
228: -- indicates API processing has been aborted because
229: -- at least one message exists in the list.
232: --
233: -- Reset IN OUT parameters and set OUT parameters
234: --
235: p_object_version_number := l_object_version_number;
236: p_return_status := hr_multi_message.get_return_status_disable;
237: hr_utility.set_location(' Leaving:' || l_proc, 30);
238: when others then
239: --
240: -- When Multiple Message Detection is enabled catch
243: -- Multiple Message List. Otherwise re-raise the
244: -- error.
245: --
246: rollback to update_time_definition_swi;
247: if hr_multi_message.unexpected_error_add(l_proc) then
248: hr_utility.set_location(' Leaving:' || l_proc,40);
249: raise;
250: end if;
251: --
251: --
252: -- Reset IN OUT and set OUT parameters
253: --
254: p_object_version_number := l_object_version_number;
255: p_return_status := hr_multi_message.get_return_status_disable;
256: hr_utility.set_location(' Leaving:' || l_proc,50);
257: end update_time_definition;
258: -- ----------------------------------------------------------------------------
259: -- |------------------------< delete_time_definition >------------------------|
281: savepoint delete_time_definition_swi;
282: --
283: -- Initialise Multiple Message Detection
284: --
285: hr_multi_message.enable_message_list;
286: --
287: -- Remember IN OUT parameter IN values
288: --
289: --
315: -- Derive the API return status value based on whether
316: -- messages of any type exist in the Multiple Message List.
317: -- Also disable Multiple Message Detection.
318: --
319: p_return_status := hr_multi_message.get_return_status_disable;
320: hr_utility.set_location(' Leaving:' || l_proc,20);
321: --
322: exception
323: when hr_multi_message.error_message_exist then
319: p_return_status := hr_multi_message.get_return_status_disable;
320: hr_utility.set_location(' Leaving:' || l_proc,20);
321: --
322: exception
323: when hr_multi_message.error_message_exist then
324: --
325: -- Catch the Multiple Message List exception which
326: -- indicates API processing has been aborted because
327: -- at least one message exists in the list.
329: rollback to delete_time_definition_swi;
330: --
331: -- Reset IN OUT parameters and set OUT parameters
332: --
333: p_return_status := hr_multi_message.get_return_status_disable;
334: hr_utility.set_location(' Leaving:' || l_proc, 30);
335: when others then
336: --
337: -- When Multiple Message Detection is enabled catch
340: -- Multiple Message List. Otherwise re-raise the
341: -- error.
342: --
343: rollback to delete_time_definition_swi;
344: if hr_multi_message.unexpected_error_add(l_proc) then
345: hr_utility.set_location(' Leaving:' || l_proc,40);
346: raise;
347: end if;
348: --
347: end if;
348: --
349: -- Reset IN OUT and set OUT parameters
350: --
351: p_return_status := hr_multi_message.get_return_status_disable;
352: hr_utility.set_location(' Leaving:' || l_proc,50);
353: end delete_time_definition;
354: -- ----------------------------------------------------------------------------
355: -- |---------------------------< chk_time_def_usage >-------------------------|