30: -- Other variables
31: l_period_frequency_id number;
32: l_proc varchar2(72) := g_package ||'create_period_frequency';
33: Begin
34: hr_utility.set_location(' Entering:' || l_proc,10);
35: --
36: -- Issue a savepoint
37: --
38: savepoint create_period_frequency_swi;
82: -- messages of any type exist in the Multiple Message List.
83: -- Also disable Multiple Message Detection.
84: --
85: p_return_status := hr_multi_message.get_return_status_disable;
86: hr_utility.set_location(' Leaving:' || l_proc,20);
87: --
88: exception
89: when hr_multi_message.error_message_exist then
90: --
97: -- Reset IN OUT parameters and set OUT parameters
98: --
99: p_object_version_number := null;
100: p_return_status := hr_multi_message.get_return_status_disable;
101: hr_utility.set_location(' Leaving:' || l_proc, 30);
102: when others then
103: --
104: -- When Multiple Message Detection is enabled catch
105: -- any Application specific or other unexpected
108: -- error.
109: --
110: rollback to create_period_frequency_swi;
111: if hr_multi_message.unexpected_error_add(l_proc) then
112: hr_utility.set_location(' Leaving:' || l_proc,40);
113: raise;
114: end if;
115: --
116: -- Reset IN OUT and set OUT parameters
116: -- Reset IN OUT and set OUT parameters
117: --
118: p_object_version_number := null;
119: p_return_status := hr_multi_message.get_return_status_disable;
120: hr_utility.set_location(' Leaving:' || l_proc,50);
121: end create_period_frequency;
122: -- ----------------------------------------------------------------------------
123: -- |------------------------< update_period_frequency >-----------------------|
124: -- ----------------------------------------------------------------------------
143: --
144: -- Other variables
145: l_proc varchar2(72) := g_package ||'update_period_frequency';
146: Begin
147: hr_utility.set_location(' Entering:' || l_proc,10);
148: --
149: -- Issue a savepoint
150: --
151: savepoint update_period_frequency_swi;
192: -- messages of any type exist in the Multiple Message List.
193: -- Also disable Multiple Message Detection.
194: --
195: p_return_status := hr_multi_message.get_return_status_disable;
196: hr_utility.set_location(' Leaving:' || l_proc,20);
197: --
198: exception
199: when hr_multi_message.error_message_exist then
200: --
207: -- Reset IN OUT parameters and set OUT parameters
208: --
209: p_object_version_number := l_object_version_number;
210: p_return_status := hr_multi_message.get_return_status_disable;
211: hr_utility.set_location(' Leaving:' || l_proc, 30);
212: when others then
213: --
214: -- When Multiple Message Detection is enabled catch
215: -- any Application specific or other unexpected
218: -- error.
219: --
220: rollback to update_period_frequency_swi;
221: if hr_multi_message.unexpected_error_add(l_proc) then
222: hr_utility.set_location(' Leaving:' || l_proc,40);
223: raise;
224: end if;
225: --
226: -- Reset IN OUT and set OUT parameters
226: -- Reset IN OUT and set OUT parameters
227: --
228: p_object_version_number := l_object_version_number;
229: p_return_status := hr_multi_message.get_return_status_disable;
230: hr_utility.set_location(' Leaving:' || l_proc,50);
231: end update_period_frequency;
232: -- ----------------------------------------------------------------------------
233: -- |------------------------< delete_period_frequency >-----------------------|
234: -- ----------------------------------------------------------------------------
248: --
249: -- Other variables
250: l_proc varchar2(72) := g_package ||'delete_period_frequency';
251: Begin
252: hr_utility.set_location(' Entering:' || l_proc,10);
253: --
254: -- Issue a savepoint
255: --
256: savepoint delete_period_frequency_swi;
292: -- messages of any type exist in the Multiple Message List.
293: -- Also disable Multiple Message Detection.
294: --
295: p_return_status := hr_multi_message.get_return_status_disable;
296: hr_utility.set_location(' Leaving:' || l_proc,20);
297: --
298: exception
299: when hr_multi_message.error_message_exist then
300: --
307: -- Reset IN OUT parameters and set OUT parameters
308: --
309: p_object_version_number := l_object_version_number;
310: p_return_status := hr_multi_message.get_return_status_disable;
311: hr_utility.set_location(' Leaving:' || l_proc, 30);
312: when others then
313: --
314: -- When Multiple Message Detection is enabled catch
315: -- any Application specific or other unexpected
318: -- error.
319: --
320: rollback to delete_period_frequency_swi;
321: if hr_multi_message.unexpected_error_add(l_proc) then
322: hr_utility.set_location(' Leaving:' || l_proc,40);
323: raise;
324: end if;
325: --
326: -- Reset IN OUT and set OUT parameters
326: -- Reset IN OUT and set OUT parameters
327: --
328: p_object_version_number := l_object_version_number;
329: p_return_status := hr_multi_message.get_return_status_disable;
330: hr_utility.set_location(' Leaving:' || l_proc,50);
331: end delete_period_frequency;
332: end psp_period_frequency_swi;