52: savepoint create_pl_sii_details_swi;
53: --
54: -- Initialise Multiple Message Detection
55: --
56: hr_multi_message.enable_message_list;
57: --
58: --
59: -- Convert constant values to their corresponding boolean value
60: --
108: -- Derive the API return status value based on whether
109: -- messages of any type exist in the Multiple Message List.
110: -- Also disable Multiple Message Detection.
111: --
112: p_return_status := hr_multi_message.get_return_status_disable;
113: hr_utility.set_location(' Leaving:' || l_proc,20);
114: --
115: exception
116: when hr_multi_message.error_message_exist then
112: p_return_status := hr_multi_message.get_return_status_disable;
113: hr_utility.set_location(' Leaving:' || l_proc,20);
114: --
115: exception
116: when hr_multi_message.error_message_exist then
117: --
118: -- Catch the Multiple Message List exception which
119: -- indicates API processing has been aborted because
120: -- at least one message exists in the list.
126: p_object_version_number := null;
127: p_effective_start_date := null;
128: p_effective_end_date := null;
129: p_effective_date_warning := null;
130: p_return_status := hr_multi_message.get_return_status_disable;
131: hr_utility.set_location(' Leaving:' || l_proc, 30);
132: when others then
133: --
134: -- When Multiple Message Detection is enabled catch
137: -- Multiple Message List. Otherwise re-raise the
138: -- error.
139: --
140: rollback to create_pl_sii_details_swi;
141: if hr_multi_message.unexpected_error_add(l_proc) then
142: hr_utility.set_location(' Leaving:' || l_proc,40);
143: raise;
144: end if;
145: --
148: p_object_version_number := null;
149: p_effective_start_date := null;
150: p_effective_end_date := null;
151: p_effective_date_warning := null;
152: p_return_status := hr_multi_message.get_return_status_disable;
153: hr_utility.set_location(' Leaving:' || l_proc,50);
154: end create_pl_sii_details;
155: -- ----------------------------------------------------------------------------
156: -- |-------------------------< update_pl_sii_details >------------------------|
197: savepoint update_pl_sii_details_swi;
198: --
199: -- Initialise Multiple Message Detection
200: --
201: hr_multi_message.enable_message_list;
202: --
203: -- Remember IN OUT parameter IN values
204: --
205: l_object_version_number := p_object_version_number;
250: -- Derive the API return status value based on whether
251: -- messages of any type exist in the Multiple Message List.
252: -- Also disable Multiple Message Detection.
253: --
254: p_return_status := hr_multi_message.get_return_status_disable;
255: hr_utility.set_location(' Leaving:' || l_proc,20);
256: --
257: exception
258: when hr_multi_message.error_message_exist then
254: p_return_status := hr_multi_message.get_return_status_disable;
255: hr_utility.set_location(' Leaving:' || l_proc,20);
256: --
257: exception
258: when hr_multi_message.error_message_exist then
259: --
260: -- Catch the Multiple Message List exception which
261: -- indicates API processing has been aborted because
262: -- at least one message exists in the list.
267: --
268: p_object_version_number := l_object_version_number;
269: p_effective_start_date := null;
270: p_effective_end_date := null;
271: p_return_status := hr_multi_message.get_return_status_disable;
272: hr_utility.set_location(' Leaving:' || l_proc, 30);
273: when others then
274: --
275: -- When Multiple Message Detection is enabled catch
278: -- Multiple Message List. Otherwise re-raise the
279: -- error.
280: --
281: rollback to update_pl_sii_details_swi;
282: if hr_multi_message.unexpected_error_add(l_proc) then
283: hr_utility.set_location(' Leaving:' || l_proc,40);
284: raise;
285: end if;
286: --
288: --
289: p_object_version_number := l_object_version_number;
290: p_effective_start_date := null;
291: p_effective_end_date := null;
292: p_return_status := hr_multi_message.get_return_status_disable;
293: hr_utility.set_location(' Leaving:' || l_proc,50);
294: end update_pl_sii_details;
295: -- ----------------------------------------------------------------------------
296: -- |-------------------------< delete_pl_sii_details >------------------------|
322: savepoint delete_pl_sii_details_swi;
323: --
324: -- Initialise Multiple Message Detection
325: --
326: hr_multi_message.enable_message_list;
327: --
328: -- Remember IN OUT parameter IN values
329: --
330: l_object_version_number := p_object_version_number;
360: -- Derive the API return status value based on whether
361: -- messages of any type exist in the Multiple Message List.
362: -- Also disable Multiple Message Detection.
363: --
364: p_return_status := hr_multi_message.get_return_status_disable;
365: hr_utility.set_location(' Leaving:' || l_proc,20);
366: --
367: exception
368: when hr_multi_message.error_message_exist then
364: p_return_status := hr_multi_message.get_return_status_disable;
365: hr_utility.set_location(' Leaving:' || l_proc,20);
366: --
367: exception
368: when hr_multi_message.error_message_exist then
369: --
370: -- Catch the Multiple Message List exception which
371: -- indicates API processing has been aborted because
372: -- at least one message exists in the list.
377: --
378: p_object_version_number := l_object_version_number;
379: p_effective_start_date := null;
380: p_effective_end_date := null;
381: p_return_status := hr_multi_message.get_return_status_disable;
382: hr_utility.set_location(' Leaving:' || l_proc, 30);
383: when others then
384: --
385: -- When Multiple Message Detection is enabled catch
388: -- Multiple Message List. Otherwise re-raise the
389: -- error.
390: --
391: rollback to delete_pl_sii_details_swi;
392: if hr_multi_message.unexpected_error_add(l_proc) then
393: hr_utility.set_location(' Leaving:' || l_proc,40);
394: raise;
395: end if;
396: --
398: --
399: p_object_version_number := l_object_version_number;
400: p_effective_start_date := null;
401: p_effective_end_date := null;
402: p_return_status := hr_multi_message.get_return_status_disable;
403: hr_utility.set_location(' Leaving:' || l_proc,50);
404: end delete_pl_sii_details;
405: end pay_pl_sii_swi;