DBA Data[Home] [Help]

APPS.PQH_DE_LEVEL_NUMBERS_SWI dependencies on HR_MULTI_MESSAGE

Line 34: hr_multi_message.enable_message_list;

30: savepoint delete_level_numbers_swi;
31: --
32: -- Initialise Multiple Message Detection
33: --
34: hr_multi_message.enable_message_list;
35: --
36: -- Remember IN OUT parameter IN values
37: --
38: --

Line 67: p_return_status := hr_multi_message.get_return_status_disable;

63: -- Derive the API return status value based on whether
64: -- messages of any type exist in the Multiple Message List.
65: -- Also disable Multiple Message Detection.
66: --
67: p_return_status := hr_multi_message.get_return_status_disable;
68: hr_utility.set_location(' Leaving:' || l_proc,20);
69: --
70: exception
71: when hr_multi_message.error_message_exist then

Line 71: when hr_multi_message.error_message_exist then

67: p_return_status := hr_multi_message.get_return_status_disable;
68: hr_utility.set_location(' Leaving:' || l_proc,20);
69: --
70: exception
71: when hr_multi_message.error_message_exist then
72: --
73: -- Catch the Multiple Message List exception which
74: -- indicates API processing has been aborted because
75: -- at least one message exists in the list.

Line 81: p_return_status := hr_multi_message.get_return_status_disable;

77: rollback to delete_level_numbers_swi;
78: --
79: -- Reset IN OUT parameters and set OUT parameters
80: --
81: p_return_status := hr_multi_message.get_return_status_disable;
82: hr_utility.set_location(' Leaving:' || l_proc, 30);
83: when others then
84: --
85: -- When Multiple Message Detection is enabled catch

Line 92: if hr_multi_message.unexpected_error_add(l_proc) then

88: -- Multiple Message List. Otherwise re-raise the
89: -- error.
90: --
91: rollback to delete_level_numbers_swi;
92: if hr_multi_message.unexpected_error_add(l_proc) then
93: hr_utility.set_location(' Leaving:' || l_proc,40);
94: raise;
95: end if;
96: --

Line 99: p_return_status := hr_multi_message.get_return_status_disable;

95: end if;
96: --
97: -- Reset IN OUT and set OUT parameters
98: --
99: p_return_status := hr_multi_message.get_return_status_disable;
100: hr_utility.set_location(' Leaving:' || l_proc,50);
101: end delete_level_numbers;
102: -- ----------------------------------------------------------------------------
103: -- |-------------------------< insert_level_numbers >-------------------------|

Line 131: hr_multi_message.enable_message_list;

127: savepoint insert_level_numbers_swi;
128: --
129: -- Initialise Multiple Message Detection
130: --
131: hr_multi_message.enable_message_list;
132: --
133: -- Remember IN OUT parameter IN values
134: --
135: --

Line 170: p_return_status := hr_multi_message.get_return_status_disable;

166: -- Derive the API return status value based on whether
167: -- messages of any type exist in the Multiple Message List.
168: -- Also disable Multiple Message Detection.
169: --
170: p_return_status := hr_multi_message.get_return_status_disable;
171: hr_utility.set_location(' Leaving:' || l_proc,20);
172: --
173: exception
174: when hr_multi_message.error_message_exist then

Line 174: when hr_multi_message.error_message_exist then

170: p_return_status := hr_multi_message.get_return_status_disable;
171: hr_utility.set_location(' Leaving:' || l_proc,20);
172: --
173: exception
174: when hr_multi_message.error_message_exist then
175: --
176: -- Catch the Multiple Message List exception which
177: -- indicates API processing has been aborted because
178: -- at least one message exists in the list.

Line 186: p_return_status := hr_multi_message.get_return_status_disable;

182: -- Reset IN OUT parameters and set OUT parameters
183: --
184: p_level_number_id := null;
185: p_object_version_number := null;
186: p_return_status := hr_multi_message.get_return_status_disable;
187: hr_utility.set_location(' Leaving:' || l_proc, 30);
188: when others then
189: --
190: -- When Multiple Message Detection is enabled catch

Line 197: if hr_multi_message.unexpected_error_add(l_proc) then

193: -- Multiple Message List. Otherwise re-raise the
194: -- error.
195: --
196: rollback to insert_level_numbers_swi;
197: if hr_multi_message.unexpected_error_add(l_proc) then
198: hr_utility.set_location(' Leaving:' || l_proc,40);
199: raise;
200: end if;
201: --

Line 206: p_return_status := hr_multi_message.get_return_status_disable;

202: -- Reset IN OUT and set OUT parameters
203: --
204: p_level_number_id := null;
205: p_object_version_number := null;
206: p_return_status := hr_multi_message.get_return_status_disable;
207: hr_utility.set_location(' Leaving:' || l_proc,50);
208: end insert_level_numbers;
209: -- ----------------------------------------------------------------------------
210: -- |-------------------------< update_level_numbers >-------------------------|

Line 239: hr_multi_message.enable_message_list;

235: savepoint update_level_numbers_swi;
236: --
237: -- Initialise Multiple Message Detection
238: --
239: hr_multi_message.enable_message_list;
240: --
241: -- Remember IN OUT parameter IN values
242: --
243: l_object_version_number := p_object_version_number;

Line 276: p_return_status := hr_multi_message.get_return_status_disable;

272: -- Derive the API return status value based on whether
273: -- messages of any type exist in the Multiple Message List.
274: -- Also disable Multiple Message Detection.
275: --
276: p_return_status := hr_multi_message.get_return_status_disable;
277: hr_utility.set_location(' Leaving:' || l_proc,20);
278: --
279: exception
280: when hr_multi_message.error_message_exist then

Line 280: when hr_multi_message.error_message_exist then

276: p_return_status := hr_multi_message.get_return_status_disable;
277: hr_utility.set_location(' Leaving:' || l_proc,20);
278: --
279: exception
280: when hr_multi_message.error_message_exist then
281: --
282: -- Catch the Multiple Message List exception which
283: -- indicates API processing has been aborted because
284: -- at least one message exists in the list.

Line 291: p_return_status := hr_multi_message.get_return_status_disable;

287: --
288: -- Reset IN OUT parameters and set OUT parameters
289: --
290: p_object_version_number := l_object_version_number;
291: p_return_status := hr_multi_message.get_return_status_disable;
292: hr_utility.set_location(' Leaving:' || l_proc, 30);
293: when others then
294: --
295: -- When Multiple Message Detection is enabled catch

Line 302: if hr_multi_message.unexpected_error_add(l_proc) then

298: -- Multiple Message List. Otherwise re-raise the
299: -- error.
300: --
301: rollback to update_level_numbers_swi;
302: if hr_multi_message.unexpected_error_add(l_proc) then
303: hr_utility.set_location(' Leaving:' || l_proc,40);
304: raise;
305: end if;
306: --

Line 310: p_return_status := hr_multi_message.get_return_status_disable;

306: --
307: -- Reset IN OUT 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,50);
312: end update_level_numbers;
313: end pqh_de_level_numbers_swi;