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

Line 90: When hr_api.check_integrity_violated Then

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

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

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

Line 95: When hr_api.parent_integrity_violated Then

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

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

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

Line 100: When hr_api.unique_integrity_violated Then

96: -- Parent integrity has been violated
97: --
98: ota_ftu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: ota_ftu_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: ota_ftu_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --
107: Raise;
108: End update_dml;

Line 227: when hr_api.cannot_find_prog_unit then

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

Line 229: hr_api.cannot_find_prog_unit_error

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

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

288: -- p_rec plsql record structure
289: -- to see if a system default is being used. If a system default
290: -- is being used then we must set to the 'current' argument value.
291: --
292: If (p_rec.business_group_id = hr_api.g_number) then
293: p_rec.business_group_id :=
294: ota_ftu_shd.g_old_rec.business_group_id;
295: End If;
296: If (p_rec.author_person_id = hr_api.g_number) then

Line 296: If (p_rec.author_person_id = hr_api.g_number) then

292: If (p_rec.business_group_id = hr_api.g_number) then
293: p_rec.business_group_id :=
294: ota_ftu_shd.g_old_rec.business_group_id;
295: End If;
296: If (p_rec.author_person_id = hr_api.g_number) then
297: p_rec.author_person_id :=
298: ota_ftu_shd.g_old_rec.author_person_id;
299: End If;
300: If (p_rec.author_contact_id = hr_api.g_number) then

Line 300: If (p_rec.author_contact_id = hr_api.g_number) then

296: If (p_rec.author_person_id = hr_api.g_number) then
297: p_rec.author_person_id :=
298: ota_ftu_shd.g_old_rec.author_person_id;
299: End If;
300: If (p_rec.author_contact_id = hr_api.g_number) then
301: p_rec.author_contact_id :=
302: ota_ftu_shd.g_old_rec.author_contact_id;
303: End If;
304: --

Line 374: ,p_business_group_id in number default hr_api.g_number

370: ,p_forum_id in number
371: ,p_person_id in number
372: ,p_contact_id in number
373: ,p_object_version_number in out nocopy number
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_author_person_id in number default hr_api.g_number
376: ,p_author_contact_id in number default hr_api.g_number
377: ) is
378: --

Line 375: ,p_author_person_id in number default hr_api.g_number

371: ,p_person_id in number
372: ,p_contact_id in number
373: ,p_object_version_number in out nocopy number
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_author_person_id in number default hr_api.g_number
376: ,p_author_contact_id in number default hr_api.g_number
377: ) is
378: --
379: l_rec ota_ftu_shd.g_rec_type;

Line 376: ,p_author_contact_id in number default hr_api.g_number

372: ,p_contact_id in number
373: ,p_object_version_number in out nocopy number
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_author_person_id in number default hr_api.g_number
376: ,p_author_contact_id in number default hr_api.g_number
377: ) is
378: --
379: l_rec ota_ftu_shd.g_rec_type;
380: l_proc varchar2(72) := g_package||'upd';