DBA Data[Home] [Help]

APPS.HR_QUEST_FIELDS_SWI dependencies on HR_UTILITY

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

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

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

85: rollback to insert_quest_fields;
86: End If;
87: --
88: p_return_status := hr_multi_message.get_return_status_disable;
89: hr_utility.set_location(' Leaving:' || l_proc,20);
90: --
91: exception
92: when hr_multi_message.error_message_exist then
93: --

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

100: -- Reset IN OUT parameters and set OUT parameters
101: --
102: p_object_version_number := null;
103: p_return_status := hr_multi_message.get_return_status_disable;
104: hr_utility.set_location(' Leaving:' || l_proc, 30);
105: when others then
106: --
107: -- When Multiple Message Detection is enabled catch
108: -- any Application specific or other unexpected

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

111: -- error.
112: --
113: rollback to insert_quest_fields;
114: if hr_multi_message.unexpected_error_add(l_proc) then
115: hr_utility.set_location(' Leaving:' || l_proc,40);
116: raise;
117: end if;
118: --
119: -- Reset IN OUT and set OUT parameters

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

119: -- Reset IN OUT and set OUT parameters
120: --
121: p_object_version_number := null;
122: p_return_status := hr_multi_message.get_return_status_disable;
123: hr_utility.set_location(' Leaving:' || l_proc,50);
124: end insert_quest_fields;
125:
126: -- ----------------------------------------------------------------------------
127: -- |---------------------------< update_quest_fields >------------------------|

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

143: --
144: -- Other variables
145: l_proc varchar2(72) := g_package ||'update_quest_fields';
146: Begin
147: hr_utility.set_location(' Entering:' || l_proc,10);
148: --
149: -- Issue a savepoint
150: --
151: savepoint update_quest_fields;

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

191: rollback to update_quest_fields;
192: End If;
193: --
194: p_return_status := hr_multi_message.get_return_status_disable;
195: hr_utility.set_location(' Leaving:' || l_proc,20);
196: --
197: exception
198: when hr_multi_message.error_message_exist then
199: --

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

206: -- Reset IN OUT parameters and set OUT parameters
207: --
208: p_object_version_number := l_object_version_number;
209: p_return_status := hr_multi_message.get_return_status_disable;
210: hr_utility.set_location(' Leaving:' || l_proc, 30);
211: when others then
212: --
213: -- When Multiple Message Detection is enabled catch
214: -- any Application specific or other unexpected

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

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

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

225: -- Reset IN OUT and set OUT parameters
226: --
227: p_object_version_number := l_object_version_number;
228: p_return_status := hr_multi_message.get_return_status_disable;
229: hr_utility.set_location(' Leaving:' || l_proc,50);
230: end update_quest_fields;
231:
232: -- ----------------------------------------------------------------------------
233: -- |-------------------------< delete_quest_fields >--------------------------|

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

246: --
247: -- Other variables
248: l_proc varchar2(72) := g_package ||'delete_quest_fields';
249: Begin
250: hr_utility.set_location(' Entering:' || l_proc,10);
251: --
252: -- Issue a savepoint
253: --
254: savepoint delete_quest_fields;

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

291: rollback to delete_quest_fields;
292: End If;
293: --
294: p_return_status := hr_multi_message.get_return_status_disable;
295: hr_utility.set_location(' Leaving:' || l_proc,20);
296: --
297: exception
298: when hr_multi_message.error_message_exist then
299: --

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

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

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

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

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

323: --
324: -- Reset IN OUT and set OUT parameters
325: --
326: p_return_status := hr_multi_message.get_return_status_disable;
327: hr_utility.set_location(' Leaving:' || l_proc,50);
328: end delete_quest_fields;
329:
330: -- ----------------------------------------------------------------------------
331: -- |-------------------------< delete_quest_fields >--------------------------|

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

350: from hr_quest_fields
351: where field_id <= fldId;
352: --
353: Begin
354: hr_utility.set_location(' Entering:' || l_proc,10);
355: --
356: -- Issue a savepoint
357: --
358: savepoint delete_fields;

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

384: -- error.
385: --
386: rollback to delete_fields;
387: if hr_multi_message.unexpected_error_add(l_proc) then
388: hr_utility.set_location(' Leaving:' || l_proc,40);
389: raise;
390: end if;
391: --
392: -- Reset IN OUT and set OUT parameters

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

391: --
392: -- Reset IN OUT and set OUT parameters
393: --
394: p_return_status := hr_multi_message.get_return_status_disable;
395: hr_utility.set_location(' Leaving:' || l_proc,50);
396:
397: end delete_quest_fields;
398:
399: end hr_quest_fields_swi;