DBA Data[Home] [Help]

APPS.AME_AGL_UPD dependencies on HR_API

Line 92: When hr_api.check_integrity_violated Then

88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --
95: ame_agl_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --
95: ame_agl_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --
100: ame_agl_shd.constraint_error

Line 97: When hr_api.parent_integrity_violated Then

93: -- A check constraint has been violated
94: --
95: ame_agl_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --
100: ame_agl_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --
100: ame_agl_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --
105: ame_agl_shd.constraint_error

Line 102: When hr_api.unique_integrity_violated Then

98: -- Parent integrity has been violated
99: --
100: ame_agl_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --
105: ame_agl_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --
105: ame_agl_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: --
109: Raise;
110: End update_dml;

Line 219: when hr_api.cannot_find_prog_unit then

215: );
216: --
217: exception
218: --
219: when hr_api.cannot_find_prog_unit then
220: --
221: hr_api.cannot_find_prog_unit_error
222: (p_module_name => 'AME_APPROVAL_GROUPS_TL'
223: ,p_hook_type => 'AU');

Line 221: hr_api.cannot_find_prog_unit_error

217: exception
218: --
219: when hr_api.cannot_find_prog_unit then
220: --
221: hr_api.cannot_find_prog_unit_error
222: (p_module_name => 'AME_APPROVAL_GROUPS_TL'
223: ,p_hook_type => 'AU');
224: --
225: end;

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

280: -- p_rec plsql record structure
281: -- to see if a system default is being used. If a system default
282: -- is being used then we must set to the 'current' argument value.
283: --
284: If (p_rec.source_lang = hr_api.g_varchar2) then
285: p_rec.source_lang :=
286: ame_agl_shd.g_old_rec.source_lang;
287: End If;
288: If (p_rec.user_approval_group_name = hr_api.g_varchar2) then

Line 288: If (p_rec.user_approval_group_name = hr_api.g_varchar2) then

284: If (p_rec.source_lang = hr_api.g_varchar2) then
285: p_rec.source_lang :=
286: ame_agl_shd.g_old_rec.source_lang;
287: End If;
288: If (p_rec.user_approval_group_name = hr_api.g_varchar2) then
289: p_rec.user_approval_group_name :=
290: ame_agl_shd.g_old_rec.user_approval_group_name;
291: End If;
292: If (p_rec.description = hr_api.g_varchar2) then

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

288: If (p_rec.user_approval_group_name = hr_api.g_varchar2) then
289: p_rec.user_approval_group_name :=
290: ame_agl_shd.g_old_rec.user_approval_group_name;
291: End If;
292: If (p_rec.description = hr_api.g_varchar2) then
293: p_rec.description :=
294: ame_agl_shd.g_old_rec.description;
295: End If;
296: --

Line 356: ,p_source_lang in varchar2 default hr_api.g_varchar2

352: -- ----------------------------------------------------------------------------
353: Procedure upd
354: (p_approval_group_id in number
355: ,p_language in varchar2
356: ,p_source_lang in varchar2 default hr_api.g_varchar2
357: ,p_user_approval_group_name in varchar2 default hr_api.g_varchar2
358: ,p_description in varchar2 default hr_api.g_varchar2
359: ) is
360: --

Line 357: ,p_user_approval_group_name in varchar2 default hr_api.g_varchar2

353: Procedure upd
354: (p_approval_group_id in number
355: ,p_language in varchar2
356: ,p_source_lang in varchar2 default hr_api.g_varchar2
357: ,p_user_approval_group_name in varchar2 default hr_api.g_varchar2
358: ,p_description in varchar2 default hr_api.g_varchar2
359: ) is
360: --
361: l_rec ame_agl_shd.g_rec_type;

Line 358: ,p_description in varchar2 default hr_api.g_varchar2

354: (p_approval_group_id in number
355: ,p_language in varchar2
356: ,p_source_lang in varchar2 default hr_api.g_varchar2
357: ,p_user_approval_group_name in varchar2 default hr_api.g_varchar2
358: ,p_description in varchar2 default hr_api.g_varchar2
359: ) is
360: --
361: l_rec ame_agl_shd.g_rec_type;
362: l_proc varchar2(72) := g_package||'upd';

Line 397: ,p_user_approval_group_name in varchar2 default hr_api.g_varchar2

393: -- ----------------------------------------------------------------------------
394: Procedure upd_tl
395: (p_language_code in varchar2
396: ,p_approval_group_id in number
397: ,p_user_approval_group_name in varchar2 default hr_api.g_varchar2
398: ,p_description in varchar2 default hr_api.g_varchar2
399: ) is
400: --
401: -- Cursor to obtain the translation rows where the language or

Line 398: ,p_description in varchar2 default hr_api.g_varchar2

394: Procedure upd_tl
395: (p_language_code in varchar2
396: ,p_approval_group_id in number
397: ,p_user_approval_group_name in varchar2 default hr_api.g_varchar2
398: ,p_description in varchar2 default hr_api.g_varchar2
399: ) is
400: --
401: -- Cursor to obtain the translation rows where the language or
402: -- source_lang match the specified language.