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_TKGQ_UPD dependencies on HR_API

Line 89: When hr_api.check_integrity_violated Then

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

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

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

Line 94: When hr_api.parent_integrity_violated Then

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

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

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

Line 99: When hr_api.unique_integrity_violated Then

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

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

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

Line 225: when hr_api.cannot_find_prog_unit then

221: );
222: --
223: exception
224: --
225: when hr_api.cannot_find_prog_unit then
226: --
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'HXC_TK_GROUP_QUERY'
229: ,p_hook_type => 'AU');

Line 227: hr_api.cannot_find_prog_unit_error

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

Line 290: If (p_rec.group_query_name = hr_api.g_varchar2) then

286: -- p_rec plsql record structure
287: -- to see if a system default is being used. If a system default
288: -- is being used then we must set to the 'current' argument value.
289: --
290: If (p_rec.group_query_name = hr_api.g_varchar2) then
291: p_rec.group_query_name :=
292: hxc_tkgq_shd.g_old_rec.group_query_name;
293: End If;
294: If (p_rec.tk_group_id = hr_api.g_number) then

Line 294: If (p_rec.tk_group_id = hr_api.g_number) then

290: If (p_rec.group_query_name = hr_api.g_varchar2) then
291: p_rec.group_query_name :=
292: hxc_tkgq_shd.g_old_rec.group_query_name;
293: End If;
294: If (p_rec.tk_group_id = hr_api.g_number) then
295: p_rec.tk_group_id :=
296: hxc_tkgq_shd.g_old_rec.tk_group_id;
297: End If;
298: If (p_rec.include_exclude = hr_api.g_varchar2) then

Line 298: If (p_rec.include_exclude = hr_api.g_varchar2) then

294: If (p_rec.tk_group_id = hr_api.g_number) then
295: p_rec.tk_group_id :=
296: hxc_tkgq_shd.g_old_rec.tk_group_id;
297: End If;
298: If (p_rec.include_exclude = hr_api.g_varchar2) then
299: p_rec.include_exclude :=
300: hxc_tkgq_shd.g_old_rec.include_exclude;
301: End If;
302: If (p_rec.system_user = hr_api.g_varchar2) then

Line 302: If (p_rec.system_user = hr_api.g_varchar2) then

298: If (p_rec.include_exclude = hr_api.g_varchar2) then
299: p_rec.include_exclude :=
300: hxc_tkgq_shd.g_old_rec.include_exclude;
301: End If;
302: If (p_rec.system_user = hr_api.g_varchar2) then
303: p_rec.system_user :=
304: hxc_tkgq_shd.g_old_rec.system_user;
305: End If;
306: