[Home] [Help]
39: l_object_version_number pay_balance_feeds_f.object_version_number%type;
40: l_exist_run_result_warning boolean;
41:
42: begin
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Issue a savepoint
46: --
47: savepoint create_balance_feed;
144: p_effective_end_date := l_effective_end_date;
145: p_object_version_number := l_object_version_number;
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
163: p_effective_end_date := null;
164: p_object_version_number := null;
165: p_exist_run_result_warning := l_exist_run_result_warning;
166:
167: hr_utility.set_location(' Leaving:'||l_proc, 80);
168: when others then
169: --
170: -- A validation or unexpected error has occured
171: --
176: p_effective_end_date := null;
177: p_object_version_number := null;
178: p_exist_run_result_warning := null;
179:
180: hr_utility.set_location(' Leaving:'||l_proc, 90);
181: raise;
182: end create_balance_feed;
183: --
184: -- ----------------------------------------------------------------------------
222: l_business_group_id pay_balance_feeds_f.business_group_id%type;
223: l_legislation_subgroup pay_balance_feeds_f.legislation_subgroup%type;
224:
225: begin
226: hr_utility.set_location('Entering:'|| l_proc, 10);
227: --
228: -- Issue a savepoint
229: --
230: savepoint update_balance_feed;
331: p_effective_end_date := l_effective_end_date;
332: p_object_version_number := l_object_version_number;
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
349: p_effective_end_date := null;
350: p_object_version_number := l_object_version_number;
351: p_exist_run_result_warning := l_exist_run_result_warning;
352:
353: hr_utility.set_location(' Leaving:'||l_proc, 80);
354: when others then
355: --
356: -- A validation or unexpected error has occured
357: --
361: p_effective_end_date := null;
362: p_object_version_number := l_object_version_number;
363: p_exist_run_result_warning := null;
364:
365: hr_utility.set_location(' Leaving:'||l_proc, 90);
366: raise;
367: end update_balance_feed;
368: --
369: -- ----------------------------------------------------------------------------
393: l_object_version_number pay_balance_feeds_f.object_version_number%type;
394: l_exist_run_result_warning boolean;
395:
396: begin
397: hr_utility.set_location('Entering:'|| l_proc, 10);
398: --
399: -- Issue a savepoint
400: --
401: savepoint delete_balance_feed;
468: p_effective_end_date := l_effective_end_date;
469: p_object_version_number := l_object_version_number;
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
486: p_effective_end_date := null;
487: p_object_version_number := l_object_version_number;
488: p_exist_run_result_warning := l_exist_run_result_warning;
489:
490: hr_utility.set_location(' Leaving:'||l_proc, 80);
491: when others then
492: --
493: -- A validation or unexpected error has occured
494: --
498: p_effective_end_date := null;
499: p_object_version_number := l_object_version_number;
500: p_exist_run_result_warning := null;
501:
502: hr_utility.set_location(' Leaving:'||l_proc, 90);
503: raise;
504: end delete_balance_feed;
505: --
506: end PAY_BALANCE_FEEDS_API;