53: -- Lookup validation added here so that there are no numeric or value
54: -- errors for scale.
55: --
56: if p_scale is not null
57: and hr_api.NOT_EXISTS_IN_HR_LOOKUPS
58: (p_effective_date => p_effective_date
59: ,p_lookup_type => 'ADD_SUBTRACT'
60: ,p_lookup_code => p_scale
61: ) then
77: ,p_scale => p_scale
78: ,p_legislation_subgroup => p_legislation_subgroup
79: );
80: exception
81: when hr_api.cannot_find_prog_unit then
82: hr_api.cannot_find_prog_unit_error
83: (p_module_name => 'create_balance_feed'
84: ,p_hook_type => 'BP'
85: );
78: ,p_legislation_subgroup => p_legislation_subgroup
79: );
80: exception
81: when hr_api.cannot_find_prog_unit then
82: hr_api.cannot_find_prog_unit_error
83: (p_module_name => 'create_balance_feed'
84: ,p_hook_type => 'BP'
85: );
86: end;
123: ,p_object_version_number => l_object_version_number
124: ,p_exist_run_result_warning => l_exist_run_result_warning
125: );
126: exception
127: when hr_api.cannot_find_prog_unit then
128: hr_api.cannot_find_prog_unit_error
129: (p_module_name => 'create_balance_feed'
130: ,p_hook_type => 'AP'
131: );
124: ,p_exist_run_result_warning => l_exist_run_result_warning
125: );
126: exception
127: when hr_api.cannot_find_prog_unit then
128: hr_api.cannot_find_prog_unit_error
129: (p_module_name => 'create_balance_feed'
130: ,p_hook_type => 'AP'
131: );
132: end;
133: --
134: -- When in validation only mode raise the Validate_Enabled exception
135: --
136: if p_validate then
137: raise hr_api.validate_enabled;
138: end if;
139: --
140: -- Set all output arguments
141: --
146: p_exist_run_result_warning := l_exist_run_result_warning;
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 70);
149: exception
150: when hr_api.validate_enabled then
151: --
152: -- As the Validate_Enabled exception has been raised
153: -- we must rollback to the savepoint
154: --
189: (p_validate in boolean default false
190: ,p_effective_date in date
191: ,p_datetrack_update_mode in varchar2
192: ,p_balance_feed_id in number
193: ,p_scale in varchar2 default hr_api.g_number
194: ,p_object_version_number in out nocopy number
195: ,p_effective_start_date out nocopy date
196: ,p_effective_end_date out nocopy date
197: ,p_exist_run_result_warning out nocopy boolean
236: --
237: -- Lookup validation added here so that there are no numeric or value
238: -- errors for scale.
239: --
240: if nvl(p_scale, hr_api.g_number) <> hr_api.g_number
241: and hr_api.NOT_EXISTS_IN_HR_LOOKUPS
242: (p_effective_date => p_effective_date
243: ,p_lookup_type => 'ADD_SUBTRACT'
244: ,p_lookup_code => p_scale
237: -- Lookup validation added here so that there are no numeric or value
238: -- errors for scale.
239: --
240: if nvl(p_scale, hr_api.g_number) <> hr_api.g_number
241: and hr_api.NOT_EXISTS_IN_HR_LOOKUPS
242: (p_effective_date => p_effective_date
243: ,p_lookup_type => 'ADD_SUBTRACT'
244: ,p_lookup_code => p_scale
245: ) then
258: ,p_balance_feed_id => p_balance_feed_id
259: ,p_scale => p_scale
260: );
261: exception
262: when hr_api.cannot_find_prog_unit then
263: hr_api.cannot_find_prog_unit_error
264: (p_module_name => 'update_balance_feed'
265: ,p_hook_type => 'BP'
266: );
259: ,p_scale => p_scale
260: );
261: exception
262: when hr_api.cannot_find_prog_unit then
263: hr_api.cannot_find_prog_unit_error
264: (p_module_name => 'update_balance_feed'
265: ,p_hook_type => 'BP'
266: );
267: end;
311: ,p_exist_run_result_warning => l_exist_run_result_warning
312: );
313:
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'update_balance_feed'
318: ,p_hook_type => 'AP'
319: );
312: );
313:
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'update_balance_feed'
318: ,p_hook_type => 'AP'
319: );
320: end;
321: --
322: -- When in validation only mode raise the Validate_Enabled exception
323: --
324: if p_validate then
325: raise hr_api.validate_enabled;
326: end if;
327: --
328: -- Set all output arguments
329: --
333: p_exist_run_result_warning := l_exist_run_result_warning;
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 70);
336: exception
337: when hr_api.validate_enabled then
338: --
339: -- As the Validate_Enabled exception has been raised
340: -- we must rollback to the savepoint
341: --
414: ,p_balance_feed_id => p_balance_feed_id
415: ,p_object_version_number => l_object_version_number
416: );
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'delete_balance_feed'
421: ,p_hook_type => 'BP'
422: );
415: ,p_object_version_number => l_object_version_number
416: );
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'delete_balance_feed'
421: ,p_hook_type => 'BP'
422: );
423: end;
448: ,p_effective_end_date => l_effective_end_date
449: ,p_exist_run_result_warning => l_exist_run_result_warning
450: );
451: exception
452: when hr_api.cannot_find_prog_unit then
453: hr_api.cannot_find_prog_unit_error
454: (p_module_name => 'delete_balance_feed'
455: ,p_hook_type => 'AP'
456: );
449: ,p_exist_run_result_warning => l_exist_run_result_warning
450: );
451: exception
452: when hr_api.cannot_find_prog_unit then
453: hr_api.cannot_find_prog_unit_error
454: (p_module_name => 'delete_balance_feed'
455: ,p_hook_type => 'AP'
456: );
457: end;
458: --
459: -- When in validation only mode raise the Validate_Enabled exception
460: --
461: if p_validate then
462: raise hr_api.validate_enabled;
463: end if;
464: --
465: -- Set all output arguments
466: --
470: p_exist_run_result_warning := l_exist_run_result_warning;
471: --
472: hr_utility.set_location(' Leaving:'||l_proc, 70);
473: exception
474: when hr_api.validate_enabled then
475: --
476: -- As the Validate_Enabled exception has been raised
477: -- we must rollback to the savepoint
478: --