DBA Data[Home] [Help]

APPS.PQH_DE_VLDJOBFTR_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_jobftr';
25: Begin
26: hr_utility.set_location(' Entering:' || l_proc,10);
27: --
28: -- Issue a savepoint
29: --
30: savepoint delete_vldtn_jobftr_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_jobftr_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_jobftr;
102: -- ----------------------------------------------------------------------------
103: -- |--------------------------< insert_vldtn_jobftr >-------------------------|
104: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

207: --
208: p_wrkplc_vldtn_jobftr_id := null;
209: p_object_version_number := null;
210: p_return_status := hr_multi_message.get_return_status_disable;
211: hr_utility.set_location(' Leaving:' || l_proc,50);
212: end insert_vldtn_jobftr;
213: -- ----------------------------------------------------------------------------
214: -- |--------------------------< update_vldtn_jobftr >-------------------------|
215: -- ----------------------------------------------------------------------------

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

233: --
234: -- Other variables
235: l_proc varchar2(72) := g_package ||'update_vldtn_jobftr';
236: Begin
237: hr_utility.set_location(' Entering:' || l_proc,10);
238: --
239: -- Issue a savepoint
240: --
241: savepoint update_vldtn_jobftr_swi;

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

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

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

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

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

307: -- error.
308: --
309: rollback to update_vldtn_jobftr_swi;
310: if hr_multi_message.unexpected_error_add(l_proc) then
311: hr_utility.set_location(' Leaving:' || l_proc,40);
312: raise;
313: end if;
314: --
315: -- Reset IN OUT and set OUT parameters

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

315: -- Reset IN OUT and set OUT parameters
316: --
317: p_object_version_number := l_object_version_number;
318: p_return_status := hr_multi_message.get_return_status_disable;
319: hr_utility.set_location(' Leaving:' || l_proc,50);
320: end update_vldtn_jobftr;
321: end pqh_de_vldjobftr_swi;