APPS.HXC_APS_UPD dependencies on HR_API

Line 91: When hr_api.check_integrity_violated Then

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

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

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

Line 96: When hr_api.parent_integrity_violated Then

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

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

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

Line 101: When hr_api.unique_integrity_violated Then

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

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

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

Line 218: when hr_api.cannot_find_prog_unit then

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

Line 220: hr_api.cannot_find_prog_unit_error

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

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

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

Line 347: ,p_name in varchar2 default hr_api.g_varchar2

343: -- ----------------------------------------------------------------------------
344: Procedure upd
345: (p_approval_period_set_id in number
346: ,p_object_version_number in out nocopy number
347: ,p_name in varchar2 default hr_api.g_varchar2
348: ) is
349: --
350: l_rec hxc_aps_shd.g_rec_type;
351: l_proc varchar2(72);