[Home] [Help]
39: l_in_out_parameter number;
40: l_proc varchar2(72) :=g_package||'create_balance_dimension';
41: --
42: begin
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Issue a savepoint
46: l_in_out_parameter := p_description;
47: savepoint create_balance_dimension;
92: pay_bdt_ins.ins_tl(userenv('lang'),p_balance_dimension_id,p_dimension_name,
93: p_database_item_suffix,p_description);
94: --------------------------------------------------------------------------------
95: g_dml_status := FALSE;
96: hr_utility.set_location(' Leaving:'||l_proc, 70);
97: exception
98: when hr_api.validate_enabled then
99: --
100: -- As the Validate_Enabled exception has been raised
100: -- As the Validate_Enabled exception has been raised
101: -- we must rollback to the savepoint
102: --
103: rollback to create_balance_dimension;
104: hr_utility.set_location(' Leaving:'||l_proc, 80);
105: when others then
106: --
107: -- A validation or unexpected error has occured
108: --
110: --
111: -- Reset IN OUT parameters and set all
112: -- OUT parameters, including warnings, to null
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 90);
115: g_dml_status := FALSE;
116: raise;
117:
118: end create_balance_dimension;
146: ) is
147: --
148: l_proc varchar2(72) :=g_package||'create_balance_dimension';
149: begin
150: hr_utility.set_location('Entering:'|| l_proc, 10);
151: --
152: -- Issue a savepoint
153: --
154: savepoint update_balance_dimension;
192: pay_bdt_upd.upd_tl(userenv('lang'),p_balance_dimension_id,p_dimension_name,
193: p_database_item_suffix,p_description);
194: --------------------------------------------------------------------------------
195: g_dml_status := FALSE;
196: hr_utility.set_location(' Leaving:'||l_proc, 70);
197: exception
198: when hr_api.validate_enabled then
199: --
200: -- As the Validate_Enabled exception has been raised
201: -- we must rollback to the savepoint
202: --
203: rollback to update_balance_dimension;
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 80);
206: when others then
207: --
208: -- A validation or unexpected error has occured
209: --
208: -- A validation or unexpected error has occured
209: --
210: rollback to update_balance_dimension;
211:
212: hr_utility.set_location(' Leaving:'||l_proc, 90);
213: g_dml_status := FALSE;
214: raise;
215: end update_balance_dimension;
216: --
232: l_effective_start_date date;
233: l_effective_end_date date;
234: --
235: begin
236: hr_utility.set_location('Entering:'|| l_proc, 10);
237: --
238: -- Issue a savepoint
239: --
240: savepoint delete_balance_dimension;
255: if p_validate then
256: raise hr_api.validate_enabled;
257: end if;
258: g_dml_status := FALSE;
259: hr_utility.set_location(' Leaving:'||l_proc, 70);
260: exception
261: when hr_api.validate_enabled then
262: --
263: -- As the Validate_Enabled exception has been raised
264: -- we must rollback to the savepoint
265: --
266: rollback to delete_balance_dimension;
267:
268: hr_utility.set_location(' Leaving:'||l_proc, 80);
269: g_dml_status := FALSE;
270: when others then
271: --
272: -- A validation or unexpected error has occured
272: -- A validation or unexpected error has occured
273: --
274: rollback to delete_balance_dimension;
275:
276: hr_utility.set_location(' Leaving:'||l_proc, 90);
277: raise;
278:
279: end delete_balance_dimension;
280: --