72: ,p_balance_dimension_id => l_balance_dimension_id
73: ) ;
74: --
75: exception
76: when hr_api.cannot_find_prog_unit then
77: hr_api.cannot_find_prog_unit_error
78: (p_module_name => 'create_balance_dimension'
79: ,p_hook_type => 'AP'
80: );
73: ) ;
74: --
75: exception
76: when hr_api.cannot_find_prog_unit then
77: hr_api.cannot_find_prog_unit_error
78: (p_module_name => 'create_balance_dimension'
79: ,p_hook_type => 'AP'
80: );
81: end;
82: --
83: -- When in validation only mode raise the Validate_Enabled exception
84: --
85: if p_validate then
86: raise hr_api.validate_enabled;
87: end if;
88:
89: --
90: p_balance_dimension_id := l_balance_dimension_id;
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
101: -- we must rollback to the savepoint
102: --
183: --
184: -- When in validation only mode raise the Validate_Enabled exception
185: --
186: if p_validate then
187: raise hr_api.validate_enabled;
188: end if;
189: --
190: --
191: --For MLS-----------------------------------------------------------------------
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: --
252: --
253: -- When in validation only mode raise the Validate_Enabled exception
254: --
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
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: --