DBA Data[Home] [Help]

APPS.PQH_DE_VLDVER_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_vern';
25: Begin
26: hr_utility.set_location(' Entering:' || l_proc,10);
27: --
28: -- Issue a savepoint
29: --
30: savepoint delete_vldtn_vern_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_vern_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_vern;
102: -- ----------------------------------------------------------------------------
103: -- |---------------------------< insert_vldtn_vern >--------------------------|
104: -- ----------------------------------------------------------------------------

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

132: --
133: -- Other variables
134: l_proc varchar2(72) := g_package ||'insert_vldtn_vern';
135: Begin
136: hr_utility.set_location(' Entering:' || l_proc,10);
137: --
138: -- Issue a savepoint
139: --
140: savepoint insert_vldtn_vern_swi;

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

193: -- messages of any type exist in the Multiple Message List.
194: -- Also disable Multiple Message Detection.
195: --
196: p_return_status := hr_multi_message.get_return_status_disable;
197: hr_utility.set_location(' Leaving:' || l_proc,20);
198: --
199: exception
200: when hr_multi_message.error_message_exist then
201: --

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

209: --
210: p_wrkplc_vldtn_ver_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, 30);
214: when others then
215: --
216: -- When Multiple Message Detection is enabled catch
217: -- any Application specific or other unexpected

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

220: -- error.
221: --
222: rollback to insert_vldtn_vern_swi;
223: if hr_multi_message.unexpected_error_add(l_proc) then
224: hr_utility.set_location(' Leaving:' || l_proc,40);
225: raise;
226: end if;
227: --
228: -- Reset IN OUT and set OUT parameters

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

229: --
230: p_wrkplc_vldtn_ver_id := null;
231: p_object_version_number := null;
232: p_return_status := hr_multi_message.get_return_status_disable;
233: hr_utility.set_location(' Leaving:' || l_proc,50);
234: end insert_vldtn_vern;
235: -- ----------------------------------------------------------------------------
236: -- |---------------------------< update_vldtn_vern >--------------------------|
237: -- ----------------------------------------------------------------------------

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

266: --
267: -- Other variables
268: l_proc varchar2(72) := g_package ||'update_vldtn_vern';
269: Begin
270: hr_utility.set_location(' Entering:' || l_proc,10);
271: --
272: -- Issue a savepoint
273: --
274: savepoint update_vldtn_vern_swi;

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

325: -- messages of any type exist in the Multiple Message List.
326: -- Also disable Multiple Message Detection.
327: --
328: p_return_status := hr_multi_message.get_return_status_disable;
329: hr_utility.set_location(' Leaving:' || l_proc,20);
330: --
331: exception
332: when hr_multi_message.error_message_exist then
333: --

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

340: -- Reset IN OUT parameters and set OUT parameters
341: --
342: p_object_version_number := l_object_version_number;
343: p_return_status := hr_multi_message.get_return_status_disable;
344: hr_utility.set_location(' Leaving:' || l_proc, 30);
345: when others then
346: --
347: -- When Multiple Message Detection is enabled catch
348: -- any Application specific or other unexpected

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

351: -- error.
352: --
353: rollback to update_vldtn_vern_swi;
354: if hr_multi_message.unexpected_error_add(l_proc) then
355: hr_utility.set_location(' Leaving:' || l_proc,40);
356: raise;
357: end if;
358: --
359: -- Reset IN OUT and set OUT parameters

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

359: -- Reset IN OUT and set OUT parameters
360: --
361: p_object_version_number := l_object_version_number;
362: p_return_status := hr_multi_message.get_return_status_disable;
363: hr_utility.set_location(' Leaving:' || l_proc,50);
364: end update_vldtn_vern;
365: end pqh_de_vldver_swi;