DBA Data[Home] [Help]

APPS.PQH_DE_VLDOPR_SWI dependencies on HR_UTILITY

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

22: --
23: -- Other variables
24: l_proc varchar2(72) := g_package ||'delete_vldtn_oprn';
25: Begin
26: hr_utility.set_location(' Entering:' || l_proc,10);
27: --
28: -- Issue a savepoint
29: --
30: savepoint delete_vldtn_oprn_swi;

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

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
72: --

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

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
86: -- any Application specific or other unexpected

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

89: -- error.
90: --
91: rollback to delete_vldtn_oprn_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: --
97: -- Reset IN OUT and set OUT parameters

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

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_vldtn_oprn;
102: -- ----------------------------------------------------------------------------
103: -- |---------------------------< insert_vldtn_oprn >--------------------------|
104: -- ----------------------------------------------------------------------------

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

122: --
123: -- Other variables
124: l_proc varchar2(72) := g_package ||'insert_vldtn_oprn';
125: Begin
126: hr_utility.set_location(' Entering:' || l_proc,10);
127: --
128: -- Issue a savepoint
129: --
130: savepoint insert_vldtn_oprn_swi;

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

173: -- messages of any type exist in the Multiple Message List.
174: -- Also disable Multiple Message Detection.
175: --
176: p_return_status := hr_multi_message.get_return_status_disable;
177: hr_utility.set_location(' Leaving:' || l_proc,20);
178: --
179: exception
180: when hr_multi_message.error_message_exist then
181: --

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

189: --
190: p_wrkplc_vldtn_op_id := null;
191: p_object_version_number := null;
192: p_return_status := hr_multi_message.get_return_status_disable;
193: hr_utility.set_location(' Leaving:' || l_proc, 30);
194: when others then
195: --
196: -- When Multiple Message Detection is enabled catch
197: -- any Application specific or other unexpected

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

200: -- error.
201: --
202: rollback to insert_vldtn_oprn_swi;
203: if hr_multi_message.unexpected_error_add(l_proc) then
204: hr_utility.set_location(' Leaving:' || l_proc,40);
205: raise;
206: end if;
207: --
208: -- Reset IN OUT and set OUT parameters

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

209: --
210: p_wrkplc_vldtn_op_id := null;
211: p_object_version_number := null;
212: p_return_status := hr_multi_message.get_return_status_disable;
213: hr_utility.set_location(' Leaving:' || l_proc,50);
214: end insert_vldtn_oprn;
215: -- ----------------------------------------------------------------------------
216: -- |---------------------------< update_vldtn_oprn >--------------------------|
217: -- ----------------------------------------------------------------------------

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

236: --
237: -- Other variables
238: l_proc varchar2(72) := g_package ||'update_vldtn_oprn';
239: Begin
240: hr_utility.set_location(' Entering:' || l_proc,10);
241: --
242: -- Issue a savepoint
243: --
244: savepoint update_vldtn_oprn_swi;

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

285: -- messages of any type exist in the Multiple Message List.
286: -- Also disable Multiple Message Detection.
287: --
288: p_return_status := hr_multi_message.get_return_status_disable;
289: hr_utility.set_location(' Leaving:' || l_proc,20);
290: --
291: exception
292: when hr_multi_message.error_message_exist then
293: --

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

300: -- Reset IN OUT parameters and set OUT parameters
301: --
302: p_object_version_number := l_object_version_number;
303: p_return_status := hr_multi_message.get_return_status_disable;
304: hr_utility.set_location(' Leaving:' || l_proc, 30);
305: when others then
306: --
307: -- When Multiple Message Detection is enabled catch
308: -- any Application specific or other unexpected

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

311: -- error.
312: --
313: rollback to update_vldtn_oprn_swi;
314: if hr_multi_message.unexpected_error_add(l_proc) then
315: hr_utility.set_location(' Leaving:' || l_proc,40);
316: raise;
317: end if;
318: --
319: -- Reset IN OUT and set OUT parameters

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

319: -- Reset IN OUT and set OUT parameters
320: --
321: p_object_version_number := l_object_version_number;
322: p_return_status := hr_multi_message.get_return_status_disable;
323: hr_utility.set_location(' Leaving:' || l_proc,50);
324: end update_vldtn_oprn;
325: end pqh_de_vldopr_swi;