[Home] [Help]
38: -- Other variables
39: l_time_definition_id number;
40: l_proc varchar2(72) := g_package ||'create_time_definition';
41: Begin
42: hr_utility.set_location(' Entering:' || l_proc,10);
43: --
44: -- Issue a savepoint
45: --
46: savepoint create_time_definition_swi;
98: -- messages of any type exist in the Multiple Message List.
99: -- Also disable Multiple Message Detection.
100: --
101: p_return_status := hr_multi_message.get_return_status_disable;
102: hr_utility.set_location(' Leaving:' || l_proc,20);
103: --
104: exception
105: when hr_multi_message.error_message_exist then
106: --
113: -- Reset IN OUT parameters and set OUT parameters
114: --
115: p_object_version_number := null;
116: p_return_status := hr_multi_message.get_return_status_disable;
117: hr_utility.set_location(' Leaving:' || l_proc, 30);
118: when others then
119: --
120: -- When Multiple Message Detection is enabled catch
121: -- any Application specific or other unexpected
124: -- error.
125: --
126: rollback to create_time_definition_swi;
127: if hr_multi_message.unexpected_error_add(l_proc) then
128: hr_utility.set_location(' Leaving:' || l_proc,40);
129: raise;
130: end if;
131: --
132: -- Reset IN OUT and set OUT parameters
132: -- Reset IN OUT and set OUT parameters
133: --
134: p_object_version_number := null;
135: p_return_status := hr_multi_message.get_return_status_disable;
136: hr_utility.set_location(' Leaving:' || l_proc,50);
137: end create_time_definition;
138: -- ----------------------------------------------------------------------------
139: -- |------------------------< update_time_definition >------------------------|
140: -- ----------------------------------------------------------------------------
164: --
165: -- Other variables
166: l_proc varchar2(72) := g_package ||'update_time_definition';
167: Begin
168: hr_utility.set_location(' Entering:' || l_proc,10);
169: --
170: -- Issue a savepoint
171: --
172: savepoint update_time_definition_swi;
218: -- messages of any type exist in the Multiple Message List.
219: -- Also disable Multiple Message Detection.
220: --
221: p_return_status := hr_multi_message.get_return_status_disable;
222: hr_utility.set_location(' Leaving:' || l_proc,20);
223: --
224: exception
225: when hr_multi_message.error_message_exist then
226: --
233: -- Reset IN OUT parameters and set OUT parameters
234: --
235: p_object_version_number := l_object_version_number;
236: p_return_status := hr_multi_message.get_return_status_disable;
237: hr_utility.set_location(' Leaving:' || l_proc, 30);
238: when others then
239: --
240: -- When Multiple Message Detection is enabled catch
241: -- any Application specific or other unexpected
244: -- error.
245: --
246: rollback to update_time_definition_swi;
247: if hr_multi_message.unexpected_error_add(l_proc) then
248: hr_utility.set_location(' Leaving:' || l_proc,40);
249: raise;
250: end if;
251: --
252: -- Reset IN OUT and set OUT parameters
252: -- Reset IN OUT and set OUT parameters
253: --
254: p_object_version_number := l_object_version_number;
255: p_return_status := hr_multi_message.get_return_status_disable;
256: hr_utility.set_location(' Leaving:' || l_proc,50);
257: end update_time_definition;
258: -- ----------------------------------------------------------------------------
259: -- |------------------------< delete_time_definition >------------------------|
260: -- ----------------------------------------------------------------------------
273: --
274: -- Other variables
275: l_proc varchar2(72) := g_package ||'delete_time_definition';
276: Begin
277: hr_utility.set_location(' Entering:' || l_proc,10);
278: --
279: -- Issue a savepoint
280: --
281: savepoint delete_time_definition_swi;
316: -- messages of any type exist in the Multiple Message List.
317: -- Also disable Multiple Message Detection.
318: --
319: p_return_status := hr_multi_message.get_return_status_disable;
320: hr_utility.set_location(' Leaving:' || l_proc,20);
321: --
322: exception
323: when hr_multi_message.error_message_exist then
324: --
330: --
331: -- Reset IN OUT parameters and set OUT parameters
332: --
333: p_return_status := hr_multi_message.get_return_status_disable;
334: hr_utility.set_location(' Leaving:' || l_proc, 30);
335: when others then
336: --
337: -- When Multiple Message Detection is enabled catch
338: -- any Application specific or other unexpected
341: -- error.
342: --
343: rollback to delete_time_definition_swi;
344: if hr_multi_message.unexpected_error_add(l_proc) then
345: hr_utility.set_location(' Leaving:' || l_proc,40);
346: raise;
347: end if;
348: --
349: -- Reset IN OUT and set OUT parameters
348: --
349: -- Reset IN OUT and set OUT parameters
350: --
351: p_return_status := hr_multi_message.get_return_status_disable;
352: hr_utility.set_location(' Leaving:' || l_proc,50);
353: end delete_time_definition;
354: -- ----------------------------------------------------------------------------
355: -- |---------------------------< chk_time_def_usage >-------------------------|
356: -- ----------------------------------------------------------------------------
364: l_time_def_usage_number number;
365:
366: l_proc varchar2(72) := g_package ||'chk_time_def_usage';
367: Begin
368: hr_utility.set_location(' Entering:' || l_proc,10);
369:
370: l_time_def_usage_boolean := pay_tdf_bus.chk_time_def_usage
371: ( p_time_definition_id => p_time_definition_id
372: ,p_definition_type => p_definition_type
374:
375: l_time_def_usage_number := hr_api.boolean_to_constant
376: (p_boolean_value => l_time_def_usage_boolean);
377:
378: hr_utility.set_location(' Leaving:' || l_proc,20);
379:
380: return l_time_def_usage_number;
381: --
382: end chk_time_def_usage;