68: --
69: -- When in validation mode, raise validation enabled exception
70: IF p_validate THEN
71: hr_utility.trace('p_validate is TRUE');
72: raise hr_api.validate_enabled;
73: END IF;
74: --
75: EXCEPTION
76: WHEN hr_api.validate_enabled THEN
72: raise hr_api.validate_enabled;
73: END IF;
74: --
75: EXCEPTION
76: WHEN hr_api.validate_enabled THEN
77: -- As validate_enabled exception raised, roll back to savepoint
78: hr_utility.trace('raising hr_api.validate_enabled');
79: ROLLBACK TO ins_owner_def;
80: WHEN others THEN
74: --
75: EXCEPTION
76: WHEN hr_api.validate_enabled THEN
77: -- As validate_enabled exception raised, roll back to savepoint
78: hr_utility.trace('raising hr_api.validate_enabled');
79: ROLLBACK TO ins_owner_def;
80: WHEN others THEN
81: -- Unexpected error
82: hr_utility.trace('raising unknown error');
105: --
106: -- When in validation mode, raise validation enabled exception
107: IF p_validate THEN
108: hr_utility.trace('p_validate is TRUE');
109: RAISE hr_api.validate_enabled;
110: END IF;
111: --
112: EXCEPTION
113: WHEN hr_api.validate_enabled THEN
109: RAISE hr_api.validate_enabled;
110: END IF;
111: --
112: EXCEPTION
113: WHEN hr_api.validate_enabled THEN
114: --
115: -- Rollback to savepoint, as validate_enabled trigger has been raised
116: hr_utility.trace('raising hr_api.validate_enabled');
117: ROLLBACK TO del_owner_defs;
112: EXCEPTION
113: WHEN hr_api.validate_enabled THEN
114: --
115: -- Rollback to savepoint, as validate_enabled trigger has been raised
116: hr_utility.trace('raising hr_api.validate_enabled');
117: ROLLBACK TO del_owner_defs;
118: --
119: WHEN OTHERS THEN
120: -- Unexpected error