DBA Data[Home] [Help]

APPS.BEN_PIL_ASSIGNMENT_SWI dependencies on HR_UTILITY

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

25: --
26: -- Other variables
27: l_proc varchar2(72) := g_package ||'create_pil_assignment';
28: Begin
29: hr_utility.set_location(' Entering:' || l_proc,10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint create_pil_assignment_swi;

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

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

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

86: --
87: p_pil_assignment_id := null;
88: p_object_version_number := null;
89: p_return_status := hr_multi_message.get_return_status_disable;
90: hr_utility.set_location(' Leaving:' || l_proc, 30);
91: when others then
92: --
93: -- When Multiple Message Detection is enabled catch
94: -- any Application specific or other unexpected

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

97: -- error.
98: --
99: rollback to create_pil_assignment_swi;
100: if hr_multi_message.unexpected_error_add(l_proc) then
101: hr_utility.set_location(' Leaving:' || l_proc,40);
102: raise;
103: end if;
104: --
105: -- Reset IN OUT and set OUT parameters

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

106: --
107: p_pil_assignment_id := null;
108: p_object_version_number := null;
109: p_return_status := hr_multi_message.get_return_status_disable;
110: hr_utility.set_location(' Leaving:' || l_proc,50);
111: end create_pil_assignment;
112: -- ----------------------------------------------------------------------------
113: -- |-------------------------< delete_pil_assignment >------------------------|
114: -- ----------------------------------------------------------------------------

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

127: --
128: -- Other variables
129: l_proc varchar2(72) := g_package ||'delete_pil_assignment';
130: Begin
131: hr_utility.set_location(' Entering:' || l_proc,10);
132: --
133: -- Issue a savepoint
134: --
135: savepoint delete_pil_assignment_swi;

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

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

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

185: -- Reset IN OUT parameters and set OUT parameters
186: --
187: p_object_version_number := l_object_version_number;
188: p_return_status := hr_multi_message.get_return_status_disable;
189: hr_utility.set_location(' Leaving:' || l_proc, 30);
190: when others then
191: --
192: -- When Multiple Message Detection is enabled catch
193: -- any Application specific or other unexpected

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

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

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

204: -- Reset IN OUT and set OUT parameters
205: --
206: p_object_version_number := l_object_version_number;
207: p_return_status := hr_multi_message.get_return_status_disable;
208: hr_utility.set_location(' Leaving:' || l_proc,50);
209: end delete_pil_assignment;
210: -- ----------------------------------------------------------------------------
211: -- |----------------------------------< lck >---------------------------------|
212: -- ----------------------------------------------------------------------------

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

222: --
223: -- Other variables
224: l_proc varchar2(72) := g_package ||'lck';
225: Begin
226: hr_utility.set_location(' Entering:' || l_proc,10);
227: --
228: -- Issue a savepoint
229: --
230: savepoint lck_swi;

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

260: -- messages of any type exist in the Multiple Message List.
261: -- Also disable Multiple Message Detection.
262: --
263: p_return_status := hr_multi_message.get_return_status_disable;
264: hr_utility.set_location(' Leaving:' || l_proc,20);
265: --
266: exception
267: when hr_multi_message.error_message_exist then
268: --

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

274: --
275: -- Reset IN OUT parameters and set OUT parameters
276: --
277: p_return_status := hr_multi_message.get_return_status_disable;
278: hr_utility.set_location(' Leaving:' || l_proc, 30);
279: when others then
280: --
281: -- When Multiple Message Detection is enabled catch
282: -- any Application specific or other unexpected

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

285: -- error.
286: --
287: rollback to lck_swi;
288: if hr_multi_message.unexpected_error_add(l_proc) then
289: hr_utility.set_location(' Leaving:' || l_proc,40);
290: raise;
291: end if;
292: --
293: -- Reset IN OUT and set OUT parameters

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

292: --
293: -- Reset IN OUT and set OUT parameters
294: --
295: p_return_status := hr_multi_message.get_return_status_disable;
296: hr_utility.set_location(' Leaving:' || l_proc,50);
297: end lck;
298: -- ----------------------------------------------------------------------------
299: -- |-------------------------< update_pil_assignment >------------------------|
300: -- ----------------------------------------------------------------------------

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

316: --
317: -- Other variables
318: l_proc varchar2(72) := g_package ||'update_pil_assignment';
319: Begin
320: hr_utility.set_location(' Entering:' || l_proc,10);
321: --
322: -- Issue a savepoint
323: --
324: savepoint update_pil_assignment_swi;

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

362: -- messages of any type exist in the Multiple Message List.
363: -- Also disable Multiple Message Detection.
364: --
365: p_return_status := hr_multi_message.get_return_status_disable;
366: hr_utility.set_location(' Leaving:' || l_proc,20);
367: --
368: exception
369: when hr_multi_message.error_message_exist then
370: --

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

377: -- Reset IN OUT parameters and set OUT parameters
378: --
379: p_object_version_number := l_object_version_number;
380: p_return_status := hr_multi_message.get_return_status_disable;
381: hr_utility.set_location(' Leaving:' || l_proc, 30);
382: when others then
383: --
384: -- When Multiple Message Detection is enabled catch
385: -- any Application specific or other unexpected

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

388: -- error.
389: --
390: rollback to update_pil_assignment_swi;
391: if hr_multi_message.unexpected_error_add(l_proc) then
392: hr_utility.set_location(' Leaving:' || l_proc,40);
393: raise;
394: end if;
395: --
396: -- Reset IN OUT and set OUT parameters

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

396: -- Reset IN OUT and set OUT parameters
397: --
398: p_object_version_number := l_object_version_number;
399: p_return_status := hr_multi_message.get_return_status_disable;
400: hr_utility.set_location(' Leaving:' || l_proc,50);
401: end update_pil_assignment;
402: end ben_pil_assignment_swi;