APPS.HXC_HAS_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_has_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_has_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_has_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_has_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_has_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_has_shd.constraint_error

Line 103: When hr_api.parent_integrity_violated Then

99: -- A check constraint has been violated
100: hxc_has_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_has_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_has_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_has_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_has_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_has_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_has_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_has_shd.constraint_error

Line 108: When hr_api.unique_integrity_violated Then

104: -- Parent integrity has been violated
105: hxc_has_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_has_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_has_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_has_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_has_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_has_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: hxc_has_shd.g_api_dml := false; -- Unset the api dml status
115: Raise;
116: End update_dml;

Line 249: when hr_api.cannot_find_prog_unit then

245: );
246: --
247: exception
248: --
249: when hr_api.cannot_find_prog_unit then
250: --
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'HXC_APPROVAL_STYLES'
253: ,p_hook_type => 'AU');

Line 251: hr_api.cannot_find_prog_unit_error

247: exception
248: --
249: when hr_api.cannot_find_prog_unit then
250: --
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'HXC_APPROVAL_STYLES'
253: ,p_hook_type => 'AU');
254: --
255: end;

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

312: -- p_rec plsql record structure
313: -- to see if a system default is being used. If a system default
314: -- is being used then we must set to the 'current' argument value.
315: --
316: If (p_rec.name = hr_api.g_varchar2) then
317: p_rec.name :=
318: hxc_has_shd.g_old_rec.name;
319: End If;
320: If (p_rec.business_group_id = hr_api.g_number) then

Line 320: If (p_rec.business_group_id = hr_api.g_number) then

316: If (p_rec.name = hr_api.g_varchar2) then
317: p_rec.name :=
318: hxc_has_shd.g_old_rec.name;
319: End If;
320: If (p_rec.business_group_id = hr_api.g_number) then
321: p_rec.business_group_id :=
322: hxc_has_shd.g_old_rec.business_group_id;
323: End If;
324: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 324: If (p_rec.legislation_code = hr_api.g_varchar2) then

320: If (p_rec.business_group_id = hr_api.g_number) then
321: p_rec.business_group_id :=
322: hxc_has_shd.g_old_rec.business_group_id;
323: End If;
324: If (p_rec.legislation_code = hr_api.g_varchar2) then
325: p_rec.legislation_code :=
326: hxc_has_shd.g_old_rec.legislation_code;
327: End If;
328: If (p_rec.description = hr_api.g_varchar2) then

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

324: If (p_rec.legislation_code = hr_api.g_varchar2) then
325: p_rec.legislation_code :=
326: hxc_has_shd.g_old_rec.legislation_code;
327: End If;
328: If (p_rec.description = hr_api.g_varchar2) then
329: p_rec.description :=
330: hxc_has_shd.g_old_rec.description;
331: End If;
332: If (p_rec.run_recipient_extensions = hr_api.g_varchar2) then

Line 332: If (p_rec.run_recipient_extensions = hr_api.g_varchar2) then

328: If (p_rec.description = hr_api.g_varchar2) then
329: p_rec.description :=
330: hxc_has_shd.g_old_rec.description;
331: End If;
332: If (p_rec.run_recipient_extensions = hr_api.g_varchar2) then
333: p_rec.run_recipient_extensions :=
334: hxc_has_shd.g_old_rec.run_recipient_extensions;
335: End If;
336: If (p_rec.admin_role = hr_api.g_varchar2) then

Line 336: If (p_rec.admin_role = hr_api.g_varchar2) then

332: If (p_rec.run_recipient_extensions = hr_api.g_varchar2) then
333: p_rec.run_recipient_extensions :=
334: hxc_has_shd.g_old_rec.run_recipient_extensions;
335: End If;
336: If (p_rec.admin_role = hr_api.g_varchar2) then
337: p_rec.admin_role :=
338: hxc_has_shd.g_old_rec.admin_role;
339: End If;
340: If (p_rec.error_admin_role = hr_api.g_varchar2) then

Line 340: If (p_rec.error_admin_role = hr_api.g_varchar2) then

336: If (p_rec.admin_role = hr_api.g_varchar2) then
337: p_rec.admin_role :=
338: hxc_has_shd.g_old_rec.admin_role;
339: End If;
340: If (p_rec.error_admin_role = hr_api.g_varchar2) then
341: p_rec.error_admin_role :=
342: hxc_has_shd.g_old_rec.error_admin_role;
343: End If;
344: --

Line 402: ,p_name in varchar2 default hr_api.g_varchar2

398: -- ----------------------------------------------------------------------------
399: Procedure upd
400: (p_approval_style_id in number
401: ,p_object_version_number in out nocopy number
402: ,p_name in varchar2 default hr_api.g_varchar2
403: ,p_business_group_id in number default hr_api.g_number
404: ,p_legislation_code in varchar2 default hr_api.g_varchar2
405: ,p_description in varchar2 default hr_api.g_varchar2
406: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2

Line 403: ,p_business_group_id in number default hr_api.g_number

399: Procedure upd
400: (p_approval_style_id in number
401: ,p_object_version_number in out nocopy number
402: ,p_name in varchar2 default hr_api.g_varchar2
403: ,p_business_group_id in number default hr_api.g_number
404: ,p_legislation_code in varchar2 default hr_api.g_varchar2
405: ,p_description in varchar2 default hr_api.g_varchar2
406: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
407: ,p_admin_role in varchar2 default hr_api.g_varchar2

Line 404: ,p_legislation_code in varchar2 default hr_api.g_varchar2

400: (p_approval_style_id in number
401: ,p_object_version_number in out nocopy number
402: ,p_name in varchar2 default hr_api.g_varchar2
403: ,p_business_group_id in number default hr_api.g_number
404: ,p_legislation_code in varchar2 default hr_api.g_varchar2
405: ,p_description in varchar2 default hr_api.g_varchar2
406: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
407: ,p_admin_role in varchar2 default hr_api.g_varchar2
408: ,p_error_admin_role in varchar2 default hr_api.g_varchar2

Line 405: ,p_description in varchar2 default hr_api.g_varchar2

401: ,p_object_version_number in out nocopy number
402: ,p_name in varchar2 default hr_api.g_varchar2
403: ,p_business_group_id in number default hr_api.g_number
404: ,p_legislation_code in varchar2 default hr_api.g_varchar2
405: ,p_description in varchar2 default hr_api.g_varchar2
406: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
407: ,p_admin_role in varchar2 default hr_api.g_varchar2
408: ,p_error_admin_role in varchar2 default hr_api.g_varchar2
409: ) is

Line 406: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2

402: ,p_name in varchar2 default hr_api.g_varchar2
403: ,p_business_group_id in number default hr_api.g_number
404: ,p_legislation_code in varchar2 default hr_api.g_varchar2
405: ,p_description in varchar2 default hr_api.g_varchar2
406: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
407: ,p_admin_role in varchar2 default hr_api.g_varchar2
408: ,p_error_admin_role in varchar2 default hr_api.g_varchar2
409: ) is
410: --

Line 407: ,p_admin_role in varchar2 default hr_api.g_varchar2

403: ,p_business_group_id in number default hr_api.g_number
404: ,p_legislation_code in varchar2 default hr_api.g_varchar2
405: ,p_description in varchar2 default hr_api.g_varchar2
406: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
407: ,p_admin_role in varchar2 default hr_api.g_varchar2
408: ,p_error_admin_role in varchar2 default hr_api.g_varchar2
409: ) is
410: --
411: l_rec hxc_has_shd.g_rec_type;

Line 408: ,p_error_admin_role in varchar2 default hr_api.g_varchar2

404: ,p_legislation_code in varchar2 default hr_api.g_varchar2
405: ,p_description in varchar2 default hr_api.g_varchar2
406: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
407: ,p_admin_role in varchar2 default hr_api.g_varchar2
408: ,p_error_admin_role in varchar2 default hr_api.g_varchar2
409: ) is
410: --
411: l_rec hxc_has_shd.g_rec_type;
412: l_proc varchar2(72);