APPS.AME_CVL_UPD dependencies on HR_API

Line 83: When hr_api.check_integrity_violated Then

79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: --
86: ame_cvl_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: --
86: ame_cvl_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: --
91: ame_cvl_shd.constraint_error

Line 88: When hr_api.parent_integrity_violated Then

84: -- A check constraint has been violated
85: --
86: ame_cvl_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: --
91: ame_cvl_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.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: --
91: ame_cvl_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: --
96: ame_cvl_shd.constraint_error

Line 93: When hr_api.unique_integrity_violated Then

89: -- Parent integrity has been violated
90: --
91: ame_cvl_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: --
96: ame_cvl_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.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: --
96: ame_cvl_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: --
100: Raise;
101: End update_dml;

Line 202: when hr_api.cannot_find_prog_unit then

198: );
199: --
200: exception
201: --
202: when hr_api.cannot_find_prog_unit then
203: --
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'AME_CONFIG_VARS_TL'
206: ,p_hook_type => 'AU');

Line 204: hr_api.cannot_find_prog_unit_error

200: exception
201: --
202: when hr_api.cannot_find_prog_unit then
203: --
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'AME_CONFIG_VARS_TL'
206: ,p_hook_type => 'AU');
207: --
208: end;

Line 267: If (p_rec.source_lang = hr_api.g_varchar2) then

263: -- p_rec plsql record structure
264: -- to see if a system default is being used. If a system default
265: -- is being used then we must set to the 'current' argument value.
266: --
267: If (p_rec.source_lang = hr_api.g_varchar2) then
268: p_rec.source_lang :=
269: ame_cvl_shd.g_old_rec.source_lang;
270: End If;
271: If (p_rec.user_config_var_name = hr_api.g_varchar2) then

Line 271: If (p_rec.user_config_var_name = hr_api.g_varchar2) then

267: If (p_rec.source_lang = hr_api.g_varchar2) then
268: p_rec.source_lang :=
269: ame_cvl_shd.g_old_rec.source_lang;
270: End If;
271: If (p_rec.user_config_var_name = hr_api.g_varchar2) then
272: p_rec.user_config_var_name :=
273: ame_cvl_shd.g_old_rec.user_config_var_name;
274: End If;
275: If (p_rec.description = hr_api.g_varchar2) then

Line 275: If (p_rec.description = hr_api.g_varchar2) then

271: If (p_rec.user_config_var_name = hr_api.g_varchar2) then
272: p_rec.user_config_var_name :=
273: ame_cvl_shd.g_old_rec.user_config_var_name;
274: End If;
275: If (p_rec.description = hr_api.g_varchar2) then
276: p_rec.description :=
277: ame_cvl_shd.g_old_rec.description;
278: End If;
279: --

Line 339: ,p_source_lang in varchar2 default hr_api.g_varchar2

335: -- ----------------------------------------------------------------------------
336: Procedure upd
337: (p_variable_name in varchar2
338: ,p_language in varchar2
339: ,p_source_lang in varchar2 default hr_api.g_varchar2
340: ,p_user_config_var_name in varchar2 default hr_api.g_varchar2
341: ,p_description in varchar2 default hr_api.g_varchar2
342: ) is
343: --

Line 340: ,p_user_config_var_name in varchar2 default hr_api.g_varchar2

336: Procedure upd
337: (p_variable_name in varchar2
338: ,p_language in varchar2
339: ,p_source_lang in varchar2 default hr_api.g_varchar2
340: ,p_user_config_var_name in varchar2 default hr_api.g_varchar2
341: ,p_description in varchar2 default hr_api.g_varchar2
342: ) is
343: --
344: l_rec ame_cvl_shd.g_rec_type;

Line 341: ,p_description in varchar2 default hr_api.g_varchar2

337: (p_variable_name in varchar2
338: ,p_language in varchar2
339: ,p_source_lang in varchar2 default hr_api.g_varchar2
340: ,p_user_config_var_name in varchar2 default hr_api.g_varchar2
341: ,p_description in varchar2 default hr_api.g_varchar2
342: ) is
343: --
344: l_rec ame_cvl_shd.g_rec_type;
345: l_proc varchar2(72) := g_package||'upd';

Line 380: ,p_user_config_var_name in varchar2 default hr_api.g_varchar2

376: -- ----------------------------------------------------------------------------
377: Procedure upd_tl
378: (p_language_code in varchar2
379: ,p_variable_name in varchar2
380: ,p_user_config_var_name in varchar2 default hr_api.g_varchar2
381: ,p_description in varchar2 default hr_api.g_varchar2
382: ) is
383: --
384: -- Cursor to obtain the translation rows where the language or

Line 381: ,p_description in varchar2 default hr_api.g_varchar2

377: Procedure upd_tl
378: (p_language_code in varchar2
379: ,p_variable_name in varchar2
380: ,p_user_config_var_name in varchar2 default hr_api.g_varchar2
381: ,p_description in varchar2 default hr_api.g_varchar2
382: ) is
383: --
384: -- Cursor to obtain the translation rows where the language or
385: -- source_lang match the specified language.