DBA Data[Home] [Help]

APPS.PQH_DE_INS_END_REASONS_SWI dependencies on HR_UTILITY

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

25: Begin
26:
27:
28:
29: hr_utility.set_location(' Entering:' || l_proc,10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint delete_pension_end_reasons_swi;

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

67: -- messages of any type exist in the Multiple Message List.
68: -- Also disable Multiple Message Detection.
69: --
70: p_return_status := hr_multi_message.get_return_status_disable;
71: hr_utility.set_location(' Leaving:' || l_proc,20);
72: --
73: exception
74: when hr_multi_message.error_message_exist then
75: --

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

81: --
82: -- Reset IN OUT parameters and set OUT parameters
83: --
84: p_return_status := hr_multi_message.get_return_status_disable;
85: hr_utility.set_location(' Leaving:' || l_proc, 30);
86: when others then
87: --
88: -- When Multiple Message Detection is enabled catch
89: -- any Application specific or other unexpected

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

92: -- error.
93: --
94: rollback to delete_pension_end_reasons_swi;
95: if hr_multi_message.unexpected_error_add(l_proc) then
96: hr_utility.set_location(' Leaving:' || l_proc,40);
97: raise;
98: end if;
99: --
100: -- Reset IN OUT and set OUT parameters

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

99: --
100: -- Reset IN OUT and set OUT parameters
101: --
102: p_return_status := hr_multi_message.get_return_status_disable;
103: hr_utility.set_location(' Leaving:' || l_proc,50);
104: end delete_pension_end_reasons;
105: -- ----------------------------------------------------------------------------
106: -- |----------------------< insert_pension_end_reasons >----------------------|
107: -- ----------------------------------------------------------------------------

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

125: --
126: -- Other variables
127: l_proc varchar2(72) := g_package ||'insert_pension_end_reasons';
128: Begin
129: hr_utility.set_location(' Entering:' || l_proc,10);
130: --
131: -- Issue a savepoint
132: --
133: savepoint insert_pension_end_reasons_swi;

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

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

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

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

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

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

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

212: --
213: p_ins_end_reason_id := null;
214: p_object_version_number := null;
215: p_return_status := hr_multi_message.get_return_status_disable;
216: hr_utility.set_location(' Leaving:' || l_proc,50);
217: end insert_pension_end_reasons;
218: -- ----------------------------------------------------------------------------
219: -- |----------------------< update_pension_end_reasons >----------------------|
220: -- ----------------------------------------------------------------------------

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

239: --
240: -- Other variables
241: l_proc varchar2(72) := g_package ||'update_pension_end_reasons';
242: Begin
243: hr_utility.set_location(' Entering:' || l_proc,10);
244: --
245: -- Issue a savepoint
246: --
247: savepoint update_pension_end_reasons_swi;

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

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

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

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

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

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

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

322: -- Reset IN OUT and set OUT parameters
323: --
324: p_object_version_number := l_object_version_number;
325: p_return_status := hr_multi_message.get_return_status_disable;
326: hr_utility.set_location(' Leaving:' || l_proc,50);
327: end update_pension_end_reasons;
328: end pqh_de_ins_end_reasons_swi;