APPS.HR_ITL_UPD dependencies on HR_API

Line 83: When hr_api.check_integrity_violated Then

79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: --
86: hr_itl_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: --
86: hr_itl_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: --
91: hr_itl_shd.constraint_error

Line 88: When hr_api.parent_integrity_violated Then

84: -- A check constraint has been violated
85: --
86: hr_itl_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: --
91: hr_itl_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.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: --
91: hr_itl_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: --
96: hr_itl_shd.constraint_error

Line 93: When hr_api.unique_integrity_violated Then

89: -- Parent integrity has been violated
90: --
91: hr_itl_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: --
96: hr_itl_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.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: --
96: hr_itl_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: --
100: Raise;
101: End update_dml;

Line 211: when hr_api.cannot_find_prog_unit then

207: );
208: --
209: exception
210: --
211: when hr_api.cannot_find_prog_unit then
212: --
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'HR_KI_INTEGRATIONS_TL'
215: ,p_hook_type => 'AU');

Line 213: hr_api.cannot_find_prog_unit_error

209: exception
210: --
211: when hr_api.cannot_find_prog_unit then
212: --
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'HR_KI_INTEGRATIONS_TL'
215: ,p_hook_type => 'AU');
216: --
217:

Line 278: If (p_rec.partner_name = hr_api.g_varchar2) then

274: -- p_rec plsql record structure
275: -- to see if a system default is being used. If a system default
276: -- is being used then we must set to the 'current' argument value.
277: --
278: If (p_rec.partner_name = hr_api.g_varchar2) then
279: p_rec.partner_name :=
280: hr_itl_shd.g_old_rec.partner_name;
281: End If;
282: If (p_rec.service_name = hr_api.g_varchar2) then

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

278: If (p_rec.partner_name = hr_api.g_varchar2) then
279: p_rec.partner_name :=
280: hr_itl_shd.g_old_rec.partner_name;
281: End If;
282: If (p_rec.service_name = hr_api.g_varchar2) then
283: p_rec.service_name :=
284: hr_itl_shd.g_old_rec.service_name;
285: End If;
286: If (p_rec.source_lang = hr_api.g_varchar2) then

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

282: If (p_rec.service_name = hr_api.g_varchar2) then
283: p_rec.service_name :=
284: hr_itl_shd.g_old_rec.service_name;
285: End If;
286: If (p_rec.source_lang = hr_api.g_varchar2) then
287: p_rec.source_lang :=
288: hr_itl_shd.g_old_rec.source_lang;
289: End If;
290: --

Line 350: ,p_partner_name in varchar2 default hr_api.g_varchar2

346: -- |---------------------------------< upd >----------------------------------|
347: -- ----------------------------------------------------------------------------
348: Procedure upd
349: (p_integration_id in number
350: ,p_partner_name in varchar2 default hr_api.g_varchar2
351: ,p_service_name in varchar2 default hr_api.g_varchar2
352: ,p_language in varchar2
353: ,p_source_lang in varchar2 default hr_api.g_varchar2
354: ) is

Line 351: ,p_service_name in varchar2 default hr_api.g_varchar2

347: -- ----------------------------------------------------------------------------
348: Procedure upd
349: (p_integration_id in number
350: ,p_partner_name in varchar2 default hr_api.g_varchar2
351: ,p_service_name in varchar2 default hr_api.g_varchar2
352: ,p_language in varchar2
353: ,p_source_lang in varchar2 default hr_api.g_varchar2
354: ) is
355: --

Line 353: ,p_source_lang in varchar2 default hr_api.g_varchar2

349: (p_integration_id in number
350: ,p_partner_name in varchar2 default hr_api.g_varchar2
351: ,p_service_name in varchar2 default hr_api.g_varchar2
352: ,p_language in varchar2
353: ,p_source_lang in varchar2 default hr_api.g_varchar2
354: ) is
355: --
356: l_rec hr_itl_shd.g_rec_type;
357: l_proc varchar2(72) := g_package||'upd';

Line 392: ,p_partner_name in varchar2 default hr_api.g_varchar2

388: -- ----------------------------------------------------------------------------
389: Procedure upd_tl
390: (p_language_code in varchar2
391: ,p_integration_id in number
392: ,p_partner_name in varchar2 default hr_api.g_varchar2
393: ,p_service_name in varchar2 default hr_api.g_varchar2
394: ) is
395: --
396: -- Cursor to obtain the translation rows where the language or

Line 393: ,p_service_name in varchar2 default hr_api.g_varchar2

389: Procedure upd_tl
390: (p_language_code in varchar2
391: ,p_integration_id in number
392: ,p_partner_name in varchar2 default hr_api.g_varchar2
393: ,p_service_name in varchar2 default hr_api.g_varchar2
394: ) is
395: --
396: -- Cursor to obtain the translation rows where the language or
397: -- source_lang match the specified language.