69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);
71: --
72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: pay_rfp_shd.g_api_dml := false; -- Unset the api dml status
76: pay_rfp_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: pay_rfp_shd.g_api_dml := false; -- Unset the api dml status
76: pay_rfp_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: pay_rfp_shd.g_api_dml := false; -- Unset the api dml status
80: Raise;
81: End delete_dml;