eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_HAN_UPD dependencies on HR_API

Line 107: When hr_api.check_integrity_violated Then

103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: end if;
105: --
106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: hxc_han_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: hxc_han_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: hxc_han_shd.constraint_error

Line 112: When hr_api.parent_integrity_violated Then

108: -- A check constraint has been violated
109: --
110: hxc_han_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: hxc_han_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: hxc_han_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: hxc_han_shd.constraint_error

Line 117: When hr_api.unique_integrity_violated Then

113: -- Parent integrity has been violated
114: --
115: hxc_han_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: hxc_han_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: hxc_han_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: --
124: Raise;
125: End update_dml;

Line 244: when hr_api.cannot_find_prog_unit then

240: );
241: --
242: exception
243: --
244: when hr_api.cannot_find_prog_unit then
245: --
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'HXC_APP_COMP_NOTIFICATIONS'
248: ,p_hook_type => 'AU');

Line 246: hr_api.cannot_find_prog_unit_error

242: exception
243: --
244: when hr_api.cannot_find_prog_unit then
245: --
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'HXC_APP_COMP_NOTIFICATIONS'
248: ,p_hook_type => 'AU');
249: --
250: end;

Line 311: If (p_rec.notification_number_retries = hr_api.g_number) then

307: -- p_rec plsql record structure
308: -- to see if a system default is being used. If a system default
309: -- is being used then we must set to the 'current' argument value.
310: --
311: If (p_rec.notification_number_retries = hr_api.g_number) then
312: p_rec.notification_number_retries :=
313: hxc_han_shd.g_old_rec.notification_number_retries;
314: End If;
315: If (p_rec.notification_timeout_value = hr_api.g_number) then

Line 315: If (p_rec.notification_timeout_value = hr_api.g_number) then

311: If (p_rec.notification_number_retries = hr_api.g_number) then
312: p_rec.notification_number_retries :=
313: hxc_han_shd.g_old_rec.notification_number_retries;
314: End If;
315: If (p_rec.notification_timeout_value = hr_api.g_number) then
316: p_rec.notification_timeout_value :=
317: hxc_han_shd.g_old_rec.notification_timeout_value;
318: End If;
319: If (p_rec.notification_action_code = hr_api.g_varchar2) then

Line 319: If (p_rec.notification_action_code = hr_api.g_varchar2) then

315: If (p_rec.notification_timeout_value = hr_api.g_number) then
316: p_rec.notification_timeout_value :=
317: hxc_han_shd.g_old_rec.notification_timeout_value;
318: End If;
319: If (p_rec.notification_action_code = hr_api.g_varchar2) then
320: p_rec.notification_action_code :=
321: hxc_han_shd.g_old_rec.notification_action_code;
322: End If;
323: If (p_rec.notification_recipient_code = hr_api.g_varchar2) then

Line 323: If (p_rec.notification_recipient_code = hr_api.g_varchar2) then

319: If (p_rec.notification_action_code = hr_api.g_varchar2) then
320: p_rec.notification_action_code :=
321: hxc_han_shd.g_old_rec.notification_action_code;
322: End If;
323: If (p_rec.notification_recipient_code = hr_api.g_varchar2) then
324: p_rec.notification_recipient_code :=
325: hxc_han_shd.g_old_rec.notification_recipient_code;
326: End If;
327: --

Line 391: ,p_notification_number_retries in number default hr_api.g_number

387: -- ----------------------------------------------------------------------------
388: Procedure upd
389: (p_comp_notification_id in number
390: ,p_object_version_number in out nocopy number
391: ,p_notification_number_retries in number default hr_api.g_number
392: ,p_notification_timeout_value in number default hr_api.g_number
393: ,p_notification_action_code in varchar2 default hr_api.g_varchar2
394: ,p_notification_recipient_code in varchar2 default hr_api.g_varchar2
395: ) is

Line 392: ,p_notification_timeout_value in number default hr_api.g_number

388: Procedure upd
389: (p_comp_notification_id in number
390: ,p_object_version_number in out nocopy number
391: ,p_notification_number_retries in number default hr_api.g_number
392: ,p_notification_timeout_value in number default hr_api.g_number
393: ,p_notification_action_code in varchar2 default hr_api.g_varchar2
394: ,p_notification_recipient_code in varchar2 default hr_api.g_varchar2
395: ) is
396: --

Line 393: ,p_notification_action_code in varchar2 default hr_api.g_varchar2

389: (p_comp_notification_id in number
390: ,p_object_version_number in out nocopy number
391: ,p_notification_number_retries in number default hr_api.g_number
392: ,p_notification_timeout_value in number default hr_api.g_number
393: ,p_notification_action_code in varchar2 default hr_api.g_varchar2
394: ,p_notification_recipient_code in varchar2 default hr_api.g_varchar2
395: ) is
396: --
397: l_rec hxc_han_shd.g_rec_type;

Line 394: ,p_notification_recipient_code in varchar2 default hr_api.g_varchar2

390: ,p_object_version_number in out nocopy number
391: ,p_notification_number_retries in number default hr_api.g_number
392: ,p_notification_timeout_value in number default hr_api.g_number
393: ,p_notification_action_code in varchar2 default hr_api.g_varchar2
394: ,p_notification_recipient_code in varchar2 default hr_api.g_varchar2
395: ) is
396: --
397: l_rec hxc_han_shd.g_rec_type;
398: l_proc varchar2(72) := g_package||'upd';