DBA Data[Home] [Help]

APPS.PQH_FR_VALIDATIONS_SWI dependencies on HR_UTILITY

Line 34: hr_utility.set_location(' Entering:' || l_proc,10);

30: --
31: -- Other variables
32: l_proc varchar2(72) := g_package ||'delete_validation';
33: Begin
34: hr_utility.set_location(' Entering:' || l_proc,10);
35: --
36: -- Issue a savepoint
37: --
38: savepoint delete_validation_swi;

Line 84: hr_utility.set_location(' Leaving:' || l_proc,20);

80: -- messages of any type exist in the Multiple Message List.
81: -- Also disable Multiple Message Detection.
82: --
83: p_return_status := hr_multi_message.get_return_status_disable;
84: hr_utility.set_location(' Leaving:' || l_proc,20);
85: --
86: exception
87: when hr_multi_message.error_message_exist then
88: --

Line 98: hr_utility.set_location(' Leaving:' || l_proc, 30);

94: --
95: -- Reset IN OUT parameters and set OUT parameters
96: --
97: p_return_status := hr_multi_message.get_return_status_disable;
98: hr_utility.set_location(' Leaving:' || l_proc, 30);
99: when others then
100: --
101: -- When Multiple Message Detection is enabled catch
102: -- any Application specific or other unexpected

Line 109: hr_utility.set_location(' Leaving:' || l_proc,40);

105: -- error.
106: --
107: rollback to delete_validation_swi;
108: if hr_multi_message.unexpected_error_add(l_proc) then
109: hr_utility.set_location(' Leaving:' || l_proc,40);
110: raise;
111: end if;
112: --
113: -- Reset IN OUT and set OUT parameters

Line 116: hr_utility.set_location(' Leaving:' || l_proc,50);

112: --
113: -- Reset IN OUT and set OUT parameters
114: --
115: p_return_status := hr_multi_message.get_return_status_disable;
116: hr_utility.set_location(' Leaving:' || l_proc,50);
117: end delete_validation;
118: -- ----------------------------------------------------------------------------
119: -- |---------------------------< insert_validation >--------------------------|
120: -- ----------------------------------------------------------------------------

Line 151: hr_utility.set_location(' Entering:' || l_proc,10);

147: --
148: -- Other variables
149: l_proc varchar2(72) := g_package ||'insert_validation';
150: Begin
151: hr_utility.set_location(' Entering:' || l_proc,10);
152: --
153: -- Issue a savepoint
154: --
155: savepoint insert_validation_swi;

Line 209: hr_utility.set_location(' Leaving:' || l_proc,20);

205: -- messages of any type exist in the Multiple Message List.
206: -- Also disable Multiple Message Detection.
207: --
208: p_return_status := hr_multi_message.get_return_status_disable;
209: hr_utility.set_location(' Leaving:' || l_proc,20);
210: --
211: exception
212: when hr_multi_message.error_message_exist then
213: --

Line 225: hr_utility.set_location(' Leaving:' || l_proc, 30);

221: --
222: p_validation_id := null;
223: p_object_version_number := null;
224: p_return_status := hr_multi_message.get_return_status_disable;
225: hr_utility.set_location(' Leaving:' || l_proc, 30);
226: when others then
227: --
228: -- When Multiple Message Detection is enabled catch
229: -- any Application specific or other unexpected

Line 236: hr_utility.set_location(' Leaving:' || l_proc,40);

232: -- error.
233: --
234: rollback to insert_validation_swi;
235: if hr_multi_message.unexpected_error_add(l_proc) then
236: hr_utility.set_location(' Leaving:' || l_proc,40);
237: raise;
238: end if;
239: --
240: -- Reset IN OUT and set OUT parameters

Line 245: hr_utility.set_location(' Leaving:' || l_proc,50);

241: --
242: p_validation_id := null;
243: p_object_version_number := null;
244: p_return_status := hr_multi_message.get_return_status_disable;
245: hr_utility.set_location(' Leaving:' || l_proc,50);
246: end insert_validation;
247: -- ----------------------------------------------------------------------------
248: -- |---------------------------< update_validation >--------------------------|
249: -- ----------------------------------------------------------------------------

Line 281: hr_utility.set_location(' Entering:' || l_proc,10);

277: --
278: -- Other variables
279: l_proc varchar2(72) := g_package ||'update_validation';
280: Begin
281: hr_utility.set_location(' Entering:' || l_proc,10);
282: --
283: -- Issue a savepoint
284: --
285: savepoint update_validation_swi;

Line 337: hr_utility.set_location(' Leaving:' || l_proc,20);

333: -- messages of any type exist in the Multiple Message List.
334: -- Also disable Multiple Message Detection.
335: --
336: p_return_status := hr_multi_message.get_return_status_disable;
337: hr_utility.set_location(' Leaving:' || l_proc,20);
338: --
339: exception
340: when hr_multi_message.error_message_exist then
341: --

Line 352: hr_utility.set_location(' Leaving:' || l_proc, 30);

348: -- Reset IN OUT parameters and set OUT parameters
349: --
350: p_object_version_number := l_object_version_number;
351: p_return_status := hr_multi_message.get_return_status_disable;
352: hr_utility.set_location(' Leaving:' || l_proc, 30);
353: when others then
354: --
355: -- When Multiple Message Detection is enabled catch
356: -- any Application specific or other unexpected

Line 363: hr_utility.set_location(' Leaving:' || l_proc,40);

359: -- error.
360: --
361: rollback to update_validation_swi;
362: if hr_multi_message.unexpected_error_add(l_proc) then
363: hr_utility.set_location(' Leaving:' || l_proc,40);
364: raise;
365: end if;
366: --
367: -- Reset IN OUT and set OUT parameters

Line 371: hr_utility.set_location(' Leaving:' || l_proc,50);

367: -- Reset IN OUT and set OUT parameters
368: --
369: p_object_version_number := l_object_version_number;
370: p_return_status := hr_multi_message.get_return_status_disable;
371: hr_utility.set_location(' Leaving:' || l_proc,50);
372: end update_validation;
373: end pqh_fr_validations_swi;