DBA Data[Home] [Help]

APPS.PQH_FR_VALIDATION_PERIODS_SWI dependencies on HR_UTILITY

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

20: --
21: -- Other variables
22: l_proc varchar2(72) := g_package ||'delete_validation_period';
23: Begin
24: hr_utility.set_location(' Entering:' || l_proc,10);
25: --
26: -- Issue a savepoint
27: --
28: savepoint delete_validation_period_swi;

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

58: -- messages of any type exist in the Multiple Message List.
59: -- Also disable Multiple Message Detection.
60: --
61: p_return_status := hr_multi_message.get_return_status_disable;
62: hr_utility.set_location(' Leaving:' || l_proc,20);
63: --
64: exception
65: when hr_multi_message.error_message_exist then
66: --

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

72: --
73: -- Reset IN OUT parameters and set OUT parameters
74: --
75: p_return_status := hr_multi_message.get_return_status_disable;
76: hr_utility.set_location(' Leaving:' || l_proc, 30);
77: when others then
78: --
79: -- When Multiple Message Detection is enabled catch
80: -- any Application specific or other unexpected

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

83: -- error.
84: --
85: rollback to delete_validation_period_swi;
86: if hr_multi_message.unexpected_error_add(l_proc) then
87: hr_utility.set_location(' Leaving:' || l_proc,40);
88: raise;
89: end if;
90: --
91: -- Reset IN OUT and set OUT parameters

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

90: --
91: -- Reset IN OUT and set OUT parameters
92: --
93: p_return_status := hr_multi_message.get_return_status_disable;
94: hr_utility.set_location(' Leaving:' || l_proc,50);
95: end delete_validation_period;
96: -- ----------------------------------------------------------------------------
97: -- |-----------------------< insert_validation_period >-----------------------|
98: -- ----------------------------------------------------------------------------

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

121: --
122: -- Other variables
123: l_proc varchar2(72) := g_package ||'insert_validation_period';
124: Begin
125: hr_utility.set_location(' Entering:' || l_proc,10);
126: --
127: -- Issue a savepoint
128: --
129: savepoint insert_validation_period_swi;

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

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

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

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

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

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

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

211: --
212: p_validation_period_id := null;
213: p_object_version_number := null;
214: p_return_status := hr_multi_message.get_return_status_disable;
215: hr_utility.set_location(' Leaving:' || l_proc,50);
216: end insert_validation_period;
217: -- ----------------------------------------------------------------------------
218: -- |-----------------------< update_validation_period >-----------------------|
219: -- ----------------------------------------------------------------------------

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

243: --
244: -- Other variables
245: l_proc varchar2(72) := g_package ||'update_validation_period';
246: Begin
247: hr_utility.set_location(' Entering:' || l_proc,10);
248: --
249: -- Issue a savepoint
250: --
251: savepoint update_validation_period_swi;

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

295: -- messages of any type exist in the Multiple Message List.
296: -- Also disable Multiple Message Detection.
297: --
298: p_return_status := hr_multi_message.get_return_status_disable;
299: hr_utility.set_location(' Leaving:' || l_proc,20);
300: --
301: exception
302: when hr_multi_message.error_message_exist then
303: --

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

310: -- Reset IN OUT parameters and set OUT parameters
311: --
312: p_object_version_number := l_object_version_number;
313: p_return_status := hr_multi_message.get_return_status_disable;
314: hr_utility.set_location(' Leaving:' || l_proc, 30);
315: when others then
316: --
317: -- When Multiple Message Detection is enabled catch
318: -- any Application specific or other unexpected

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

321: -- error.
322: --
323: rollback to update_validation_period_swi;
324: if hr_multi_message.unexpected_error_add(l_proc) then
325: hr_utility.set_location(' Leaving:' || l_proc,40);
326: raise;
327: end if;
328: --
329: -- Reset IN OUT and set OUT parameters

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

329: -- Reset IN OUT and set OUT parameters
330: --
331: p_object_version_number := l_object_version_number;
332: p_return_status := hr_multi_message.get_return_status_disable;
333: hr_utility.set_location(' Leaving:' || l_proc,50);
334: end update_validation_period;
335: end pqh_fr_validation_periods_swi;