30: --
31: -- Other variables
32: l_proc varchar2(72) := g_package ||'create_user_column_instance';
33: Begin
34: hr_utility.set_location(' Entering:' || l_proc,10);
35: --
36: -- Issue a savepoint
37: savepoint create_user_column_instance;
38: --
79: -- messages of any type exist in the Multiple Message List.
80: -- Also disable Multiple Message Detection.
81: --
82: p_return_status := hr_multi_message.get_return_status_disable;
83: hr_utility.set_location(' Leaving:' || l_proc,20);
84: --
85: exception
86: when hr_multi_message.error_message_exist then
87: --
97: p_object_version_number := null;
98: p_effective_start_date := null;
99: p_effective_end_date := 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_user_column_instance;
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
119: p_object_version_number := null;
120: p_effective_start_date := null;
121: p_effective_end_date := null;
122: p_return_status := hr_multi_message.get_return_status_disable;
123: hr_utility.set_location(' Leaving:' || l_proc,50);
124: end create_user_column_instance;
125: -- ----------------------------------------------------------------------------
126: -- |----------------------< update_user_column_instance >---------------------|
127: -- ----------------------------------------------------------------------------
145: --
146: -- Other variables
147: l_proc varchar2(72) := g_package ||'update_user_column_instance';
148: Begin
149: hr_utility.set_location(' Entering:' || l_proc,10);
150: --
151: -- Issue a savepoint
152: --
153: savepoint update_user_column_instance;
193: -- messages of any type exist in the Multiple Message List.
194: -- Also disable Multiple Message Detection.
195: --
196: p_return_status := hr_multi_message.get_return_status_disable;
197: hr_utility.set_location(' Leaving:' || l_proc,20);
198: --
199: exception
200: when hr_multi_message.error_message_exist then
201: --
210: p_object_version_number := l_object_version_number;
211: p_effective_start_date := null;
212: p_effective_end_date := null;
213: p_return_status := hr_multi_message.get_return_status_disable;
214: hr_utility.set_location(' Leaving:' || l_proc, 30);
215: when others then
216: --
217: -- When Multiple Message Detection is enabled catch
218: -- any Application specific or other unexpected
221: -- error.
222: --
223: rollback to update_user_column_instance;
224: if hr_multi_message.unexpected_error_add(l_proc) then
225: hr_utility.set_location(' Leaving:' || l_proc,40);
226: raise;
227: end if;
228: --
229: -- Reset IN OUT and set OUT parameters
231: p_object_version_number := l_object_version_number;
232: p_effective_start_date := null;
233: p_effective_end_date := null;
234: p_return_status := hr_multi_message.get_return_status_disable;
235: hr_utility.set_location(' Leaving:' || l_proc,50);
236: end update_user_column_instance;
237: -- ----------------------------------------------------------------------------
238: -- |----------------------< delete_user_column_instance >---------------------|
239: -- ----------------------------------------------------------------------------
256: --
257: -- Other variables
258: l_proc varchar2(72) := g_package ||'delete_user_column_instance';
259: Begin
260: hr_utility.set_location(' Entering:' || l_proc,10);
261: --
262: -- Issue a savepoint
263: --
264: savepoint delete_user_column_instance;
303: -- messages of any type exist in the Multiple Message List.
304: -- Also disable Multiple Message Detection.
305: --
306: p_return_status := hr_multi_message.get_return_status_disable;
307: hr_utility.set_location(' Leaving:' || l_proc,20);
308: --
309: exception
310: when hr_multi_message.error_message_exist then
311: --
320: p_object_version_number := l_object_version_number;
321: p_effective_start_date := null;
322: p_effective_end_date := null;
323: p_return_status := hr_multi_message.get_return_status_disable;
324: hr_utility.set_location(' Leaving:' || l_proc, 30);
325: when others then
326: --
327: -- When Multiple Message Detection is enabled catch
328: -- any Application specific or other unexpected
331: -- error.
332: --
333: rollback to delete_user_column_instance;
334: if hr_multi_message.unexpected_error_add(l_proc) then
335: hr_utility.set_location(' Leaving:' || l_proc,40);
336: raise;
337: end if;
338: --
339: -- Reset IN OUT and set OUT parameters
341: p_object_version_number := l_object_version_number;
342: p_effective_start_date := null;
343: p_effective_end_date := null;
344: p_return_status := hr_multi_message.get_return_status_disable;
345: hr_utility.set_location(' Leaving:' || l_proc,50);
346: end delete_user_column_instance;
347: end pay_user_column_instance_swi;