DBA Data[Home] [Help]

APPS.FF_FFP_UPD dependencies on HR_API

Line 88: When hr_api.check_integrity_violated Then

84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
91: ff_ffp_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
91: ff_ffp_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
96: ff_ffp_shd.constraint_error

Line 93: When hr_api.parent_integrity_violated Then

89: -- A check constraint has been violated
90: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
91: ff_ffp_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
96: ff_ffp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
96: ff_ffp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
101: ff_ffp_shd.constraint_error

Line 98: When hr_api.unique_integrity_violated Then

94: -- Parent integrity has been violated
95: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
96: ff_ffp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
101: ff_ffp_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
101: ff_ffp_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
105: Raise;
106: End update_dml;

Line 229: when hr_api.cannot_find_prog_unit then

225: );
226: --
227: exception
228: --
229: when hr_api.cannot_find_prog_unit then
230: --
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'FF_FUNCTION_PARAMETERS'
233: ,p_hook_type => 'AU');

Line 231: hr_api.cannot_find_prog_unit_error

227: exception
228: --
229: when hr_api.cannot_find_prog_unit then
230: --
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'FF_FUNCTION_PARAMETERS'
233: ,p_hook_type => 'AU');
234: --
235: end;

Line 294: If (p_rec.class = hr_api.g_varchar2) then

290: -- p_rec plsql record structure
291: -- to see if a system default is being used. If a system default
292: -- is being used then we must set to the 'current' argument value.
293: --
294: If (p_rec.class = hr_api.g_varchar2) then
295: p_rec.class :=
296: ff_ffp_shd.g_old_rec.class;
297: End If;
298: If (p_rec.continuing_parameter = hr_api.g_varchar2) then

Line 298: If (p_rec.continuing_parameter = hr_api.g_varchar2) then

294: If (p_rec.class = hr_api.g_varchar2) then
295: p_rec.class :=
296: ff_ffp_shd.g_old_rec.class;
297: End If;
298: If (p_rec.continuing_parameter = hr_api.g_varchar2) then
299: p_rec.continuing_parameter :=
300: ff_ffp_shd.g_old_rec.continuing_parameter;
301: End If;
302: If (p_rec.data_type = hr_api.g_varchar2) then

Line 302: If (p_rec.data_type = hr_api.g_varchar2) then

298: If (p_rec.continuing_parameter = hr_api.g_varchar2) then
299: p_rec.continuing_parameter :=
300: ff_ffp_shd.g_old_rec.continuing_parameter;
301: End If;
302: If (p_rec.data_type = hr_api.g_varchar2) then
303: p_rec.data_type :=
304: ff_ffp_shd.g_old_rec.data_type;
305: End If;
306: If (p_rec.name = hr_api.g_varchar2) then

Line 306: If (p_rec.name = hr_api.g_varchar2) then

302: If (p_rec.data_type = hr_api.g_varchar2) then
303: p_rec.data_type :=
304: ff_ffp_shd.g_old_rec.data_type;
305: End If;
306: If (p_rec.name = hr_api.g_varchar2) then
307: p_rec.name :=
308: ff_ffp_shd.g_old_rec.name;
309: End If;
310: If (p_rec.optional = hr_api.g_varchar2) then

Line 310: If (p_rec.optional = hr_api.g_varchar2) then

306: If (p_rec.name = hr_api.g_varchar2) then
307: p_rec.name :=
308: ff_ffp_shd.g_old_rec.name;
309: End If;
310: If (p_rec.optional = hr_api.g_varchar2) then
311: p_rec.optional :=
312: ff_ffp_shd.g_old_rec.optional;
313: End If;
314: --

Line 380: ,p_class in varchar2 default hr_api.g_varchar2

376: (p_effective_date in date
377: ,p_function_id in number
378: ,p_sequence_number in number
379: ,p_object_version_number in out nocopy number
380: ,p_class in varchar2 default hr_api.g_varchar2
381: ,p_continuing_parameter in varchar2 default hr_api.g_varchar2
382: ,p_data_type in varchar2 default hr_api.g_varchar2
383: ,p_name in varchar2 default hr_api.g_varchar2
384: ,p_optional in varchar2 default hr_api.g_varchar2

Line 381: ,p_continuing_parameter in varchar2 default hr_api.g_varchar2

377: ,p_function_id in number
378: ,p_sequence_number in number
379: ,p_object_version_number in out nocopy number
380: ,p_class in varchar2 default hr_api.g_varchar2
381: ,p_continuing_parameter in varchar2 default hr_api.g_varchar2
382: ,p_data_type in varchar2 default hr_api.g_varchar2
383: ,p_name in varchar2 default hr_api.g_varchar2
384: ,p_optional in varchar2 default hr_api.g_varchar2
385: ) is

Line 382: ,p_data_type in varchar2 default hr_api.g_varchar2

378: ,p_sequence_number in number
379: ,p_object_version_number in out nocopy number
380: ,p_class in varchar2 default hr_api.g_varchar2
381: ,p_continuing_parameter in varchar2 default hr_api.g_varchar2
382: ,p_data_type in varchar2 default hr_api.g_varchar2
383: ,p_name in varchar2 default hr_api.g_varchar2
384: ,p_optional in varchar2 default hr_api.g_varchar2
385: ) is
386: --

Line 383: ,p_name in varchar2 default hr_api.g_varchar2

379: ,p_object_version_number in out nocopy number
380: ,p_class in varchar2 default hr_api.g_varchar2
381: ,p_continuing_parameter in varchar2 default hr_api.g_varchar2
382: ,p_data_type in varchar2 default hr_api.g_varchar2
383: ,p_name in varchar2 default hr_api.g_varchar2
384: ,p_optional in varchar2 default hr_api.g_varchar2
385: ) is
386: --
387: l_rec ff_ffp_shd.g_rec_type;

Line 384: ,p_optional in varchar2 default hr_api.g_varchar2

380: ,p_class in varchar2 default hr_api.g_varchar2
381: ,p_continuing_parameter in varchar2 default hr_api.g_varchar2
382: ,p_data_type in varchar2 default hr_api.g_varchar2
383: ,p_name in varchar2 default hr_api.g_varchar2
384: ,p_optional in varchar2 default hr_api.g_varchar2
385: ) is
386: --
387: l_rec ff_ffp_shd.g_rec_type;
388: l_proc varchar2(72) := g_package||'upd';