DBA Data[Home] [Help]

APPS.HXC_HTC_UPD dependencies on HR_API

Line 98: When hr_api.check_integrity_violated Then

94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: end if;
96: --
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_htc_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.check_integrity_violated Then
99: -- A check constraint has been violated
100: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_htc_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_htc_shd.constraint_error

Line 103: When hr_api.parent_integrity_violated Then

99: -- A check constraint has been violated
100: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_htc_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_htc_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_htc_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_htc_shd.constraint_error

Line 108: When hr_api.unique_integrity_violated Then

104: -- Parent integrity has been violated
105: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_htc_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_htc_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_htc_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
115: Raise;
116: End update_dml;

Line 233: when hr_api.cannot_find_prog_unit then

229: );
230: --
231: exception
232: --
233: when hr_api.cannot_find_prog_unit then
234: --
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'HXC_TIME_CATEGORIES'
237: ,p_hook_type => 'AU');

Line 235: hr_api.cannot_find_prog_unit_error

231: exception
232: --
233: when hr_api.cannot_find_prog_unit then
234: --
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'HXC_TIME_CATEGORIES'
237: ,p_hook_type => 'AU');
238: --
239: end;

Line 300: If (p_rec.time_category_name = hr_api.g_varchar2) then

296: -- p_rec plsql record structure
297: -- to see if a system default is being used. If a system default
298: -- is being used then we must set to the 'current' argument value.
299: --
300: If (p_rec.time_category_name = hr_api.g_varchar2) then
301: p_rec.time_category_name :=
302: hxc_htc_shd.g_old_rec.time_category_name;
303: End If;
304: --

Line 367: ,p_time_category_name in varchar2 default hr_api.g_varchar2

363: -- ----------------------------------------------------------------------------
364: Procedure upd
365: (p_time_category_id in number
366: ,p_object_version_number in out nocopy number
367: ,p_time_category_name in varchar2 default hr_api.g_varchar2
368: ,p_operator in varchar2
369: ,p_description in varchar2
370: ,p_display in varchar2
371: ) is