DBA Data[Home] [Help]

APPS.PER_SSM_INS dependencies on HR_API

Line 136: When hr_api.check_integrity_violated Then

132: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
133: --
134: hr_utility.set_location(' Leaving:'||l_proc, 10);
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: hr_utility.set_location(l_proc, 6);
139: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
140: per_ssm_shd.constraint_error

Line 141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

137: -- A check constraint has been violated
138: hr_utility.set_location(l_proc, 6);
139: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
140: per_ssm_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then
143: hr_utility.set_location(l_proc, 7);
144: -- Parent integrity has been violated
145: per_ssm_shd.g_api_dml := false; -- Unset the api dml status

Line 142: When hr_api.parent_integrity_violated Then

138: hr_utility.set_location(l_proc, 6);
139: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
140: per_ssm_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then
143: hr_utility.set_location(l_proc, 7);
144: -- Parent integrity has been violated
145: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
146: per_ssm_shd.constraint_error

Line 147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

143: hr_utility.set_location(l_proc, 7);
144: -- Parent integrity has been violated
145: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
146: per_ssm_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: hr_utility.set_location(l_proc, 8);
150: -- Unique integrity has been violated
151: per_ssm_shd.g_api_dml := false; -- Unset the api dml status

Line 148: When hr_api.unique_integrity_violated Then

144: -- Parent integrity has been violated
145: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
146: per_ssm_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: hr_utility.set_location(l_proc, 8);
150: -- Unique integrity has been violated
151: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
152: per_ssm_shd.constraint_error

Line 153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

149: hr_utility.set_location(l_proc, 8);
150: -- Unique integrity has been violated
151: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
152: per_ssm_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: hr_utility.set_location(l_proc, 9);
156: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;

Line 294: when hr_api.cannot_find_prog_unit then

290: p_effective_date => p_effective_date
291: );
292: --
293: exception
294: when hr_api.cannot_find_prog_unit then
295: --
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'PER_SALARY_SURVEY_MAPPINGS'
298: ,p_hook_type => 'AI'

Line 296: hr_api.cannot_find_prog_unit_error

292: --
293: exception
294: when hr_api.cannot_find_prog_unit then
295: --
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'PER_SALARY_SURVEY_MAPPINGS'
298: ,p_hook_type => 'AI'
299: );
300: end;