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.OTA_FOI_UPD dependencies on HR_API

Line 88: When hr_api.check_integrity_violated Then

84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: --
91: ota_foi_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: --
91: ota_foi_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: ota_foi_shd.constraint_error

Line 93: When hr_api.parent_integrity_violated Then

89: -- A check constraint has been violated
90: --
91: ota_foi_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: ota_foi_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: ota_foi_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: ota_foi_shd.constraint_error

Line 98: When hr_api.unique_integrity_violated Then

94: -- Parent integrity has been violated
95: --
96: ota_foi_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: ota_foi_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.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: ota_foi_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: --
105: Raise;
106: End update_dml;

Line 223: when hr_api.cannot_find_prog_unit then

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

Line 225: hr_api.cannot_find_prog_unit_error

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

Line 288: If (p_rec.start_date_active = hr_api.g_date) then

284: -- p_rec plsql record structure
285: -- to see if a system default is being used. If a system default
286: -- is being used then we must set to the 'current' argument value.
287: --
288: If (p_rec.start_date_active = hr_api.g_date) then
289: p_rec.start_date_active :=
290: ota_foi_shd.g_old_rec.start_date_active;
291: End If;
292: If (p_rec.end_date_active = hr_api.g_date) then

Line 292: If (p_rec.end_date_active = hr_api.g_date) then

288: If (p_rec.start_date_active = hr_api.g_date) then
289: p_rec.start_date_active :=
290: ota_foi_shd.g_old_rec.start_date_active;
291: End If;
292: If (p_rec.end_date_active = hr_api.g_date) then
293: p_rec.end_date_active :=
294: ota_foi_shd.g_old_rec.end_date_active;
295: End If;
296: If (p_rec.primary_flag = hr_api.g_varchar2) then

Line 296: If (p_rec.primary_flag = hr_api.g_varchar2) then

292: If (p_rec.end_date_active = hr_api.g_date) then
293: p_rec.end_date_active :=
294: ota_foi_shd.g_old_rec.end_date_active;
295: End If;
296: If (p_rec.primary_flag = hr_api.g_varchar2) then
297: p_rec.primary_flag :=
298: ota_foi_shd.g_old_rec.primary_flag;
299: End If;
300: --

Line 368: ,p_start_date_active in date default hr_api.g_date

364: ,p_forum_id in number
365: ,p_object_id in number
366: ,p_object_type in varchar2
367: ,p_object_version_number in out nocopy number
368: ,p_start_date_active in date default hr_api.g_date
369: ,p_end_date_active in date default hr_api.g_date
370: ,p_primary_flag in varchar2 default hr_api.g_varchar2
371: ) is
372: --

Line 369: ,p_end_date_active in date default hr_api.g_date

365: ,p_object_id in number
366: ,p_object_type in varchar2
367: ,p_object_version_number in out nocopy number
368: ,p_start_date_active in date default hr_api.g_date
369: ,p_end_date_active in date default hr_api.g_date
370: ,p_primary_flag in varchar2 default hr_api.g_varchar2
371: ) is
372: --
373: l_rec ota_foi_shd.g_rec_type;

Line 370: ,p_primary_flag in varchar2 default hr_api.g_varchar2

366: ,p_object_type in varchar2
367: ,p_object_version_number in out nocopy number
368: ,p_start_date_active in date default hr_api.g_date
369: ,p_end_date_active in date default hr_api.g_date
370: ,p_primary_flag in varchar2 default hr_api.g_varchar2
371: ) is
372: --
373: l_rec ota_foi_shd.g_rec_type;
374: l_proc varchar2(72) := g_package||'upd';