DBA Data[Home] [Help]

APPS.PQP_ERT_UPD dependencies on HR_API

Line 104: When hr_api.check_integrity_violated Then

100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: --
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_ert_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_ert_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_ert_shd.constraint_error

Line 109: When hr_api.parent_integrity_violated Then

105: -- A check constraint has been violated
106: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_ert_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_ert_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_ert_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_ert_shd.constraint_error

Line 114: When hr_api.unique_integrity_violated Then

110: -- Parent integrity has been violated
111: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_ert_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_ert_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_ert_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;
122: 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 => 'PQP_EXCEPTION_REPORTS_TL'
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 => 'PQP_EXCEPTION_REPORTS_TL'
231: ,p_hook_type => 'AU');
232: --
233: end;

Line 292: If (p_rec.exception_report_name = hr_api.g_varchar2) 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.exception_report_name = hr_api.g_varchar2) then
293: p_rec.exception_report_name :=
294: pqp_ert_shd.g_old_rec.exception_report_name;
295: End If;
296: If (p_rec.source_lang = hr_api.g_varchar2) then

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

292: If (p_rec.exception_report_name = hr_api.g_varchar2) then
293: p_rec.exception_report_name :=
294: pqp_ert_shd.g_old_rec.exception_report_name;
295: End If;
296: If (p_rec.source_lang = hr_api.g_varchar2) then
297: p_rec.source_lang :=
298: pqp_ert_shd.g_old_rec.source_lang;
299: End If;
300: --

Line 353: ,p_exception_report_name in varchar2 default hr_api.g_varchar2

349: -- |---------------------------------< upd >----------------------------------|
350: -- ----------------------------------------------------------------------------
351: Procedure upd
352: (p_exception_report_id in number
353: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
354: ,p_language in varchar2
355: ,p_source_lang in varchar2 default hr_api.g_varchar2
356: ) is
357: --

Line 355: ,p_source_lang in varchar2 default hr_api.g_varchar2

351: Procedure upd
352: (p_exception_report_id in number
353: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
354: ,p_language in varchar2
355: ,p_source_lang in varchar2 default hr_api.g_varchar2
356: ) is
357: --
358: l_rec pqp_ert_shd.g_rec_type;
359: l_proc varchar2(72) := g_package||'upd';

Line 392: ,p_exception_report_name in varchar2 default hr_api.g_varchar2

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