APPS.PSP_PRT_INS dependencies on HR_API

Line 140: When hr_api.check_integrity_violated Then

136: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
143: psp_prt_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
143: psp_prt_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
148: psp_prt_shd.constraint_error

Line 145: When hr_api.parent_integrity_violated Then

141: -- A check constraint has been violated
142: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
143: psp_prt_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
148: psp_prt_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
148: psp_prt_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
153: psp_prt_shd.constraint_error

Line 150: When hr_api.unique_integrity_violated Then

146: -- Parent integrity has been violated
147: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
148: psp_prt_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
153: psp_prt_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
153: psp_prt_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End insert_dml;

Line 341: when hr_api.cannot_find_prog_unit then

337: );
338: --
339: exception
340: --
341: when hr_api.cannot_find_prog_unit then
342: --
343: hr_api.cannot_find_prog_unit_error
344: (p_module_name => 'PSP_REPORT_TEMPLATES'
345: ,p_hook_type => 'AI');

Line 343: hr_api.cannot_find_prog_unit_error

339: exception
340: --
341: when hr_api.cannot_find_prog_unit then
342: --
343: hr_api.cannot_find_prog_unit_error
344: (p_module_name => 'PSP_REPORT_TEMPLATES'
345: ,p_hook_type => 'AI');
346: --
347: end;