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

Line 87: When hr_api.check_integrity_violated Then

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

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

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

Line 92: When hr_api.parent_integrity_violated Then

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

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

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

Line 97: When hr_api.unique_integrity_violated Then

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

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

97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: ota_ont_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: --
104: Raise;
105: End update_dml;

Line 217: when hr_api.cannot_find_prog_unit then

213: null;
214: --
215: exception
216: --
217: when hr_api.cannot_find_prog_unit then
218: --
219: hr_api.cannot_find_prog_unit_error
220: (p_module_name => 'OTA_OFFERINGS_TL'
221: ,p_hook_type => 'AU');

Line 219: hr_api.cannot_find_prog_unit_error

215: exception
216: --
217: when hr_api.cannot_find_prog_unit then
218: --
219: hr_api.cannot_find_prog_unit_error
220: (p_module_name => 'OTA_OFFERINGS_TL'
221: ,p_hook_type => 'AU');
222: --
223: end;

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

278: -- p_rec plsql record structure
279: -- to see if a system default is being used. If a system default
280: -- is being used then we must set to the 'current' argument value.
281: --
282: If (p_rec.name = hr_api.g_varchar2) then
283: p_rec.name :=
284: ota_ont_shd.g_old_rec.name;
285: End If;
286: If (p_rec.description = hr_api.g_varchar2) then

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

282: If (p_rec.name = hr_api.g_varchar2) then
283: p_rec.name :=
284: ota_ont_shd.g_old_rec.name;
285: End If;
286: If (p_rec.description = hr_api.g_varchar2) then
287: p_rec.description :=
288: ota_ont_shd.g_old_rec.description;
289: End If;
290: If (p_rec.source_lang = hr_api.g_varchar2) then

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

286: If (p_rec.description = hr_api.g_varchar2) then
287: p_rec.description :=
288: ota_ont_shd.g_old_rec.description;
289: End If;
290: If (p_rec.source_lang = hr_api.g_varchar2) then
291: p_rec.source_lang :=
292: ota_ont_shd.g_old_rec.source_lang;
293: End If;
294: --

Line 358: ,p_name in varchar2 default hr_api.g_varchar2

354: Procedure upd
355: (p_effective_date in date
356: ,p_offering_id in number
357: ,p_language in varchar2
358: ,p_name in varchar2 default hr_api.g_varchar2
359: ,p_source_lang in varchar2 default hr_api.g_varchar2
360: ,p_description in varchar2 default hr_api.g_varchar2
361: ) is
362: --

Line 359: ,p_source_lang in varchar2 default hr_api.g_varchar2

355: (p_effective_date in date
356: ,p_offering_id in number
357: ,p_language in varchar2
358: ,p_name in varchar2 default hr_api.g_varchar2
359: ,p_source_lang in varchar2 default hr_api.g_varchar2
360: ,p_description in varchar2 default hr_api.g_varchar2
361: ) is
362: --
363: l_rec ota_ont_shd.g_rec_type;

Line 360: ,p_description in varchar2 default hr_api.g_varchar2

356: ,p_offering_id in number
357: ,p_language in varchar2
358: ,p_name in varchar2 default hr_api.g_varchar2
359: ,p_source_lang in varchar2 default hr_api.g_varchar2
360: ,p_description in varchar2 default hr_api.g_varchar2
361: ) is
362: --
363: l_rec ota_ont_shd.g_rec_type;
364: l_proc varchar2(72) := g_package||'upd';

Line 401: ,p_name in varchar2 default hr_api.g_varchar2

397: Procedure upd_tl
398: (p_effective_date in date
399: ,p_language_code in varchar2
400: ,p_offering_id in number
401: ,p_name in varchar2 default hr_api.g_varchar2
402: ,p_description in varchar2 default hr_api.g_varchar2
403: ) is
404: --
405: -- Cursor to obtain the translation rows where the language or

Line 402: ,p_description in varchar2 default hr_api.g_varchar2

398: (p_effective_date in date
399: ,p_language_code in varchar2
400: ,p_offering_id in number
401: ,p_name in varchar2 default hr_api.g_varchar2
402: ,p_description in varchar2 default hr_api.g_varchar2
403: ) is
404: --
405: -- Cursor to obtain the translation rows where the language or
406: -- source_lang match the specified language.