71: --
72: hr_utility.set_location (' Leaving:' || l_proc, 10);
73: --
74: EXCEPTION
75: WHEN hr_api.child_integrity_violated
76: THEN
77: -- Child integrity has been violated
78: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
79: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
75: WHEN hr_api.child_integrity_violated
76: THEN
77: -- Child integrity has been violated
78: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
79: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
80: (SQLERRM));
81: WHEN OTHERS
82: THEN
83: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
212: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
213: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage
214: );
215: EXCEPTION
216: WHEN hr_api.cannot_find_prog_unit
217: THEN
218: hr_api.cannot_find_prog_unit_error (p_module_name => 'PER_SUCCESSION_PLANNING',
219: p_hook_type => 'AD'
220: );
214: );
215: EXCEPTION
216: WHEN hr_api.cannot_find_prog_unit
217: THEN
218: hr_api.cannot_find_prog_unit_error (p_module_name => 'PER_SUCCESSION_PLANNING',
219: p_hook_type => 'AD'
220: );
221: END;
222: