DBA Data[Home] [Help]

APPS.PQH_BPL_INS dependencies on HR_API

Line 118: When hr_api.check_integrity_violated Then

114: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
121: hr_utility.set_location(' Leaving:'||l_proc, 20);
122: pqh_bpl_shd.constraint_error

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

119: -- A check constraint has been violated
120: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
121: hr_utility.set_location(' Leaving:'||l_proc, 20);
122: pqh_bpl_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
127: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 124: When hr_api.parent_integrity_violated Then

120: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
121: hr_utility.set_location(' Leaving:'||l_proc, 20);
122: pqh_bpl_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
127: hr_utility.set_location(' Leaving:'||l_proc, 30);
128: pqh_bpl_shd.constraint_error

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

125: -- Parent integrity has been violated
126: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
127: hr_utility.set_location(' Leaving:'||l_proc, 30);
128: pqh_bpl_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
133: hr_utility.set_location(' Leaving:'||l_proc, 40);

Line 130: When hr_api.unique_integrity_violated Then

126: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
127: hr_utility.set_location(' Leaving:'||l_proc, 30);
128: pqh_bpl_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
133: hr_utility.set_location(' Leaving:'||l_proc, 40);
134: pqh_bpl_shd.constraint_error

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

131: -- Unique integrity has been violated
132: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
133: hr_utility.set_location(' Leaving:'||l_proc, 40);
134: pqh_bpl_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: pqh_bpl_shd.g_api_dml := false; -- Unset the api dml status
138: Raise;
139: End insert_dml;

Line 302: when hr_api.cannot_find_prog_unit then

298: );
299: --
300: exception
301: --
302: when hr_api.cannot_find_prog_unit then
303: --
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'PQH_BUDGET_POOLS'
306: ,p_hook_type => 'AI');

Line 304: hr_api.cannot_find_prog_unit_error

300: exception
301: --
302: when hr_api.cannot_find_prog_unit then
303: --
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'PQH_BUDGET_POOLS'
306: ,p_hook_type => 'AI');
307: --
308: end;