APPS.HXC_HTS_UPD dependencies on HR_API

Line 95: When hr_api.check_integrity_violated Then

91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: end if;
93: --
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: hxc_hts_shd.g_api_dml := false; -- Unset the api dml status
98: hxc_hts_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: hxc_hts_shd.g_api_dml := false; -- Unset the api dml status
98: hxc_hts_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: hxc_hts_shd.g_api_dml := false; -- Unset the api dml status
103: hxc_hts_shd.constraint_error

Line 100: When hr_api.parent_integrity_violated Then

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

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

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

Line 105: When hr_api.unique_integrity_violated Then

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

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

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

Line 228: when hr_api.cannot_find_prog_unit then

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

Line 230: hr_api.cannot_find_prog_unit_error

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

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

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

Line 362: ,p_name in varchar2 default hr_api.g_varchar2

358: Procedure upd
359: (p_effective_date in date
360: ,p_time_source_id in number
361: ,p_object_version_number in out nocopy number
362: ,p_name in varchar2 default hr_api.g_varchar2
363: ) is
364: --
365: l_rec hxc_hts_shd.g_rec_type;
366: l_proc varchar2(72);