25: --
26: -- Other variables
27: l_proc varchar2(72) := g_package ||'create_balance_attribute';
28: Begin
29: hr_utility.set_location(' Entering:' || l_proc,10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint create_balance_attribute_swi;
70: -- messages of any type exist in the Multiple Message List.
71: -- Also disable Multiple Message Detection.
72: --
73: p_return_status := hr_multi_message.get_return_status_disable;
74: hr_utility.set_location(' Leaving:' || l_proc,20);
75: --
76: exception
77: when hr_multi_message.error_message_exist then
78: --
85: -- Reset IN OUT parameters and set OUT parameters
86: --
87: p_balance_attribute_id := null;
88: p_return_status := hr_multi_message.get_return_status_disable;
89: hr_utility.set_location(' Leaving:' || l_proc, 30);
90: when others then
91: --
92: -- When Multiple Message Detection is enabled catch
93: -- any Application specific or other unexpected
96: -- error.
97: --
98: rollback to create_balance_attribute_swi;
99: if hr_multi_message.unexpected_error_add(l_proc) then
100: hr_utility.set_location(' Leaving:' || l_proc,40);
101: raise;
102: end if;
103: --
104: -- Reset IN OUT and set OUT parameters
104: -- Reset IN OUT and set OUT parameters
105: --
106: p_balance_attribute_id := null;
107: p_return_status := hr_multi_message.get_return_status_disable;
108: hr_utility.set_location(' Leaving:' || l_proc,50);
109: end create_balance_attribute;
110: -- ----------------------------------------------------------------------------
111: -- |-----------------------< delete_balance_attribute >-----------------------|
112: -- ----------------------------------------------------------------------------
125: --
126: -- Other variables
127: l_proc varchar2(72) := g_package ||'delete_balance_attribute';
128: Begin
129: hr_utility.set_location(' Entering:' || l_proc,10);
130: --
131: -- Issue a savepoint
132: --
133: savepoint delete_balance_attribute_swi;
168: -- messages of any type exist in the Multiple Message List.
169: -- Also disable Multiple Message Detection.
170: --
171: p_return_status := hr_multi_message.get_return_status_disable;
172: hr_utility.set_location(' Leaving:' || l_proc,20);
173: --
174: exception
175: when hr_multi_message.error_message_exist then
176: --
182: --
183: -- Reset IN OUT parameters and set OUT parameters
184: --
185: p_return_status := hr_multi_message.get_return_status_disable;
186: hr_utility.set_location(' Leaving:' || l_proc, 30);
187: when others then
188: --
189: -- When Multiple Message Detection is enabled catch
190: -- any Application specific or other unexpected
193: -- error.
194: --
195: rollback to delete_balance_attribute_swi;
196: if hr_multi_message.unexpected_error_add(l_proc) then
197: hr_utility.set_location(' Leaving:' || l_proc,40);
198: raise;
199: end if;
200: --
201: -- Reset IN OUT and set OUT parameters
200: --
201: -- Reset IN OUT and set OUT parameters
202: --
203: p_return_status := hr_multi_message.get_return_status_disable;
204: hr_utility.set_location(' Leaving:' || l_proc,50);
205: end delete_balance_attribute;
206: end pay_balance_attribute_swi;