DBA Data[Home] [Help]

APPS.HR_QUEST_FIELDS_SWI dependencies on HR_UTILITY

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

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

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

91: rollback to insert_quest_fields;
92: End If;
93: --
94: p_return_status := hr_multi_message.get_return_status_disable;
95: hr_utility.set_location(' Leaving:' || l_proc,20);
96: --
97: exception
98: when hr_multi_message.error_message_exist then
99: --

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

106: -- Reset IN OUT parameters and set OUT parameters
107: --
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, 30);
111: when others then
112: --
113: -- When Multiple Message Detection is enabled catch
114: -- any Application specific or other unexpected

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

117: -- error.
118: --
119: rollback to insert_quest_fields;
120: if hr_multi_message.unexpected_error_add(l_proc) then
121: hr_utility.set_location(' Leaving:' || l_proc,40);
122: raise;
123: end if;
124: --
125: -- Reset IN OUT and set OUT parameters

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

125: -- Reset IN OUT and set OUT parameters
126: --
127: p_object_version_number := null;
128: p_return_status := hr_multi_message.get_return_status_disable;
129: hr_utility.set_location(' Leaving:' || l_proc,50);
130: end insert_quest_fields;
131:
132: -- ----------------------------------------------------------------------------
133: -- |---------------------------< update_quest_fields >------------------------|

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

157: --
158: -- Other variables
159: l_proc varchar2(72) := g_package ||'update_quest_fields';
160: Begin
161: hr_utility.set_location(' Entering:' || l_proc,10);
162: --
163: -- Issue a savepoint
164: --
165: savepoint update_quest_fields;

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

213: rollback to update_quest_fields;
214: End If;
215: --
216: p_return_status := hr_multi_message.get_return_status_disable;
217: hr_utility.set_location(' Leaving:' || l_proc,20);
218: --
219: exception
220: when hr_multi_message.error_message_exist then
221: --

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

228: -- Reset IN OUT parameters and set OUT parameters
229: --
230: p_object_version_number := l_object_version_number;
231: p_return_status := hr_multi_message.get_return_status_disable;
232: hr_utility.set_location(' Leaving:' || l_proc, 30);
233: when others then
234: --
235: -- When Multiple Message Detection is enabled catch
236: -- any Application specific or other unexpected

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

239: -- error.
240: --
241: rollback to update_quest_fields;
242: if hr_multi_message.unexpected_error_add(l_proc) then
243: hr_utility.set_location(' Leaving:' || l_proc,40);
244: raise;
245: end if;
246: --
247: -- Reset IN OUT and set OUT parameters

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

247: -- Reset IN OUT and set OUT parameters
248: --
249: p_object_version_number := l_object_version_number;
250: p_return_status := hr_multi_message.get_return_status_disable;
251: hr_utility.set_location(' Leaving:' || l_proc,50);
252: end update_quest_fields;
253:
254: -- ----------------------------------------------------------------------------
255: -- |-------------------------< delete_quest_fields >--------------------------|

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

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

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

313: rollback to delete_quest_fields;
314: End If;
315: --
316: p_return_status := hr_multi_message.get_return_status_disable;
317: hr_utility.set_location(' Leaving:' || l_proc,20);
318: --
319: exception
320: when hr_multi_message.error_message_exist then
321: --

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

327: --
328: -- Reset IN OUT parameters and set OUT parameters
329: --
330: p_return_status := hr_multi_message.get_return_status_disable;
331: hr_utility.set_location(' Leaving:' || l_proc, 30);
332: when others then
333: --
334: -- When Multiple Message Detection is enabled catch
335: -- any Application specific or other unexpected

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

338: -- error.
339: --
340: rollback to delete_quest_fields;
341: if hr_multi_message.unexpected_error_add(l_proc) then
342: hr_utility.set_location(' Leaving:' || l_proc,40);
343: raise;
344: end if;
345: --
346: -- Reset IN OUT and set OUT parameters

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

345: --
346: -- Reset IN OUT and set OUT parameters
347: --
348: p_return_status := hr_multi_message.get_return_status_disable;
349: hr_utility.set_location(' Leaving:' || l_proc,50);
350: end delete_quest_fields;
351:
352: -- ----------------------------------------------------------------------------
353: -- |-------------------------< delete_quest_fields >--------------------------|

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

372: from hr_quest_fields
373: where field_id <= fldId;
374: --
375: Begin
376: hr_utility.set_location(' Entering:' || l_proc,10);
377: --
378: -- Issue a savepoint
379: --
380: savepoint delete_fields;

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

406: -- error.
407: --
408: rollback to delete_fields;
409: if hr_multi_message.unexpected_error_add(l_proc) then
410: hr_utility.set_location(' Leaving:' || l_proc,40);
411: raise;
412: end if;
413: --
414: -- Reset IN OUT and set OUT parameters

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

413: --
414: -- Reset IN OUT and set OUT parameters
415: --
416: p_return_status := hr_multi_message.get_return_status_disable;
417: hr_utility.set_location(' Leaving:' || l_proc,50);
418:
419: end delete_quest_fields;
420:
421: end hr_quest_fields_swi;