DBA Data[Home] [Help]

APPS.PSP_TEMPLATE_DETAILS_SWI dependencies on HR_UTILITY

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

33: -- Other variables
34: l_template_detail_id number;
35: l_proc varchar2(72) := g_package ||'create_template_details';
36: Begin
37: hr_utility.set_location(' Entering:' || l_proc,10);
38: --
39: -- Issue a savepoint
40: --
41: savepoint create_template_details_swi;

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

99: -- messages of any type exist in the Multiple Message List.
100: -- Also disable Multiple Message Detection.
101: --
102: p_return_status := hr_multi_message.get_return_status_disable;
103: hr_utility.set_location(' Leaving:' || l_proc,20);
104: --
105: exception
106: when hr_multi_message.error_message_exist then
107: --

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

115: --
116: p_object_version_number := null;
117: p_return_status := null;
118: p_return_status := hr_multi_message.get_return_status_disable;
119: hr_utility.set_location(' Leaving:' || l_proc, 30);
120: when others then
121: --
122: -- When Multiple Message Detection is enabled catch
123: -- any Application specific or other unexpected

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

126: -- error.
127: --
128: rollback to create_template_details_swi;
129: if hr_multi_message.unexpected_error_add(l_proc) then
130: hr_utility.set_location(' Leaving:' || l_proc,40);
131: raise;
132: end if;
133: --
134: -- Reset IN OUT and set OUT parameters

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

135: --
136: p_object_version_number := null;
137: p_return_status := null;
138: p_return_status := hr_multi_message.get_return_status_disable;
139: hr_utility.set_location(' Leaving:' || l_proc,50);
140: end create_template_details;
141: -- ----------------------------------------------------------------------------
142: -- |------------------------< update_template_details >-----------------------|
143: -- ----------------------------------------------------------------------------

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

167: --
168: -- Other variables
169: l_proc varchar2(72) := g_package ||'update_template_details';
170: Begin
171: hr_utility.set_location(' Entering:' || l_proc,10);
172: --
173: -- Issue a savepoint
174: --
175: savepoint update_template_details_swi;

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

232: -- messages of any type exist in the Multiple Message List.
233: -- Also disable Multiple Message Detection.
234: --
235: p_return_status := hr_multi_message.get_return_status_disable;
236: hr_utility.set_location(' Leaving:' || l_proc,20);
237: --
238: exception
239: when hr_multi_message.error_message_exist then
240: --

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

249: p_template_detail_id := l_template_detail_id;
250: p_object_version_number := l_object_version_number;
251: p_return_status := null;
252: p_return_status := hr_multi_message.get_return_status_disable;
253: hr_utility.set_location(' Leaving:' || l_proc, 30);
254: when others then
255: --
256: -- When Multiple Message Detection is enabled catch
257: -- any Application specific or other unexpected

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

260: -- error.
261: --
262: rollback to update_template_details_swi;
263: if hr_multi_message.unexpected_error_add(l_proc) then
264: hr_utility.set_location(' Leaving:' || l_proc,40);
265: raise;
266: end if;
267: --
268: -- Reset IN OUT and set OUT parameters

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

270: p_template_detail_id := l_template_detail_id;
271: p_object_version_number := l_object_version_number;
272: p_return_status := null;
273: p_return_status := hr_multi_message.get_return_status_disable;
274: hr_utility.set_location(' Leaving:' || l_proc,50);
275: end update_template_details;
276: -- ----------------------------------------------------------------------------
277: -- |------------------------< delete_template_details >-----------------------|
278: -- ----------------------------------------------------------------------------

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

292: --
293: -- Other variables
294: l_proc varchar2(72) := g_package ||'delete_template_details';
295: Begin
296: hr_utility.set_location(' Entering:' || l_proc,10);
297: --
298: -- Issue a savepoint
299: --
300: savepoint delete_template_details_swi;

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

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

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

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

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

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

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

370: -- Reset IN OUT and set OUT parameters
371: --
372: p_object_version_number := l_object_version_number;
373: p_return_status := hr_multi_message.get_return_status_disable;
374: hr_utility.set_location(' Leaving:' || l_proc,50);
375: end delete_template_details;
376: end psp_template_details_swi;