47: ,p_business_group_id => p_business_group_id
48: ,p_justification_text => p_justification_text
49: );
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (p_module_name => 'CREATE_BKNG_JUSTIFICATION'
54: ,p_hook_type => 'BP'
55: );
48: ,p_justification_text => p_justification_text
49: );
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (p_module_name => 'CREATE_BKNG_JUSTIFICATION'
54: ,p_hook_type => 'BP'
55: );
56: end;
94: ,p_business_group_id => p_business_group_id
95: ,p_justification_text => p_justification_text
96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'CREATE_BKNG_JUSTIFICATION'
101: ,p_hook_type => 'AP'
102: );
95: ,p_justification_text => p_justification_text
96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'CREATE_BKNG_JUSTIFICATION'
101: ,p_hook_type => 'AP'
102: );
103: end;
106: --
107: -- When in validation only mode raise the Validate_Enabled exception
108: --
109: if p_validate then
110: raise hr_api.validate_enabled;
111: end if;
112:
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
114: exception
111: end if;
112:
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
114: exception
115: when hr_api.validate_enabled then
116: --
117: -- As the Validate_Enabled exception has been raised
118: -- we must rollback to the savepoint
119: --
180: );
181:
182:
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'UPDATE_BKNG_JUSTIFICATION'
187: ,p_hook_type => 'BP'
188: );
181:
182:
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'UPDATE_BKNG_JUSTIFICATION'
187: ,p_hook_type => 'BP'
188: );
189: end;
224: );
225:
226:
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'UPDATE_BKNG_JUSTIFICATION'
231: ,p_hook_type => 'AP'
232: );
225:
226:
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'UPDATE_BKNG_JUSTIFICATION'
231: ,p_hook_type => 'AP'
232: );
233: end;
235: --
236: -- When in validation only mode raise the Validate_Enabled exception
237: --
238: if p_validate then
239: raise hr_api.validate_enabled;
240: end if;
241: --
242: -- Set all output arguments
243: --
242: -- Set all output arguments
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 70);
245: exception
246: when hr_api.validate_enabled then
247: --
248: -- As the Validate_Enabled exception has been raised
249: -- we must rollback to the savepoint
250: --
298: (p_booking_justification_id => p_booking_justification_id
299: ,p_object_version_number => p_object_version_number
300: );
301: exception
302: when hr_api.cannot_find_prog_unit then
303: hr_api.cannot_find_prog_unit_error
304: (p_module_name => 'DELETE_BKNG_JUSTIFICATION'
305: ,p_hook_type => 'BP'
306: );
299: ,p_object_version_number => p_object_version_number
300: );
301: exception
302: when hr_api.cannot_find_prog_unit then
303: hr_api.cannot_find_prog_unit_error
304: (p_module_name => 'DELETE_BKNG_JUSTIFICATION'
305: ,p_hook_type => 'BP'
306: );
307: end;
325: (p_booking_justification_id => p_booking_justification_id
326: ,p_object_version_number => p_object_version_number
327: );
328: exception
329: when hr_api.cannot_find_prog_unit then
330: hr_api.cannot_find_prog_unit_error
331: (p_module_name => 'DELETE_BKNG_JUSTIFICATION'
332: ,p_hook_type => 'AP'
333: );
326: ,p_object_version_number => p_object_version_number
327: );
328: exception
329: when hr_api.cannot_find_prog_unit then
330: hr_api.cannot_find_prog_unit_error
331: (p_module_name => 'DELETE_BKNG_JUSTIFICATION'
332: ,p_hook_type => 'AP'
333: );
334: end;
336: --
337: -- When in validation only mode raise the Validate_Enabled exception
338: --
339: if p_validate then
340: raise hr_api.validate_enabled;
341: end if;
342: --
343: -- Set all output arguments
344: --
344: --
345: --
346: hr_utility.set_location(' Leaving:'||l_proc, 170);
347: exception
348: when hr_api.validate_enabled then
349: --
350: -- As the Validate_Enabled exception has been raised
351: -- we must rollback to the savepoint
352: --