APPS.PAY_RTT_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: pay_rtt_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: pay_rtt_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: pay_rtt_shd.constraint_error

Line 88: When hr_api.parent_integrity_violated Then

84: -- A check constraint has been violated
85: --
86: pay_rtt_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: pay_rtt_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: pay_rtt_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: pay_rtt_shd.constraint_error

Line 93: When hr_api.unique_integrity_violated Then

89: -- Parent integrity has been violated
90: --
91: pay_rtt_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: pay_rtt_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: pay_rtt_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 208: when hr_api.cannot_find_prog_unit then

204: );
205: --
206: exception
207: --
208: when hr_api.cannot_find_prog_unit then
209: --
210: hr_api.cannot_find_prog_unit_error
211: (p_module_name => 'PAY_RUN_TYPES_F_TL'
212: ,p_hook_type => 'AU');

Line 210: hr_api.cannot_find_prog_unit_error

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

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

269: -- p_rec plsql record structure
270: -- to see if a system default is being used. If a system default
271: -- is being used then we must set to the 'current' argument value.
272: --
273: If (p_rec.source_lang = hr_api.g_varchar2) then
274: p_rec.source_lang :=
275: pay_rtt_shd.g_old_rec.source_lang;
276: End If;
277: If (p_rec.run_type_name = hr_api.g_varchar2) then

Line 277: If (p_rec.run_type_name = hr_api.g_varchar2) then

273: If (p_rec.source_lang = hr_api.g_varchar2) then
274: p_rec.source_lang :=
275: pay_rtt_shd.g_old_rec.source_lang;
276: End If;
277: If (p_rec.run_type_name = hr_api.g_varchar2) then
278: p_rec.run_type_name :=
279: pay_rtt_shd.g_old_rec.run_type_name;
280: End If;
281: If (p_rec.shortname = hr_api.g_varchar2) then

Line 281: If (p_rec.shortname = hr_api.g_varchar2) then

277: If (p_rec.run_type_name = hr_api.g_varchar2) then
278: p_rec.run_type_name :=
279: pay_rtt_shd.g_old_rec.run_type_name;
280: End If;
281: If (p_rec.shortname = hr_api.g_varchar2) then
282: p_rec.shortname :=
283: pay_rtt_shd.g_old_rec.shortname;
284: End If;
285: --

Line 339: ,p_source_lang in varchar2 default hr_api.g_varchar2

335: -- ----------------------------------------------------------------------------
336: Procedure upd
337: (p_run_type_id in number
338: ,p_language in varchar2
339: ,p_source_lang in varchar2 default hr_api.g_varchar2
340: ,p_run_type_name in varchar2 default hr_api.g_varchar2
341: ,p_shortname in varchar2 default hr_api.g_varchar2
342: ) is
343: --

Line 340: ,p_run_type_name in varchar2 default hr_api.g_varchar2

336: Procedure upd
337: (p_run_type_id in number
338: ,p_language in varchar2
339: ,p_source_lang in varchar2 default hr_api.g_varchar2
340: ,p_run_type_name in varchar2 default hr_api.g_varchar2
341: ,p_shortname in varchar2 default hr_api.g_varchar2
342: ) is
343: --
344: l_rec pay_rtt_shd.g_rec_type;

Line 341: ,p_shortname in varchar2 default hr_api.g_varchar2

337: (p_run_type_id in number
338: ,p_language in varchar2
339: ,p_source_lang in varchar2 default hr_api.g_varchar2
340: ,p_run_type_name in varchar2 default hr_api.g_varchar2
341: ,p_shortname in varchar2 default hr_api.g_varchar2
342: ) is
343: --
344: l_rec pay_rtt_shd.g_rec_type;
345: l_proc varchar2(72) := g_package||'upd';

Line 380: ,p_run_type_name in varchar2 default hr_api.g_varchar2

376: -- ----------------------------------------------------------------------------
377: Procedure upd_tl
378: (p_language_code in varchar2
379: ,p_run_type_id in number
380: ,p_run_type_name in varchar2 default hr_api.g_varchar2
381: ,p_shortname in varchar2 default hr_api.g_varchar2
382: ) is
383: --
384: -- Cursor to obtain the translation rows where the language or

Line 381: ,p_shortname in varchar2 default hr_api.g_varchar2

377: Procedure upd_tl
378: (p_language_code in varchar2
379: ,p_run_type_id in number
380: ,p_run_type_name in varchar2 default hr_api.g_varchar2
381: ,p_shortname in varchar2 default hr_api.g_varchar2
382: ) is
383: --
384: -- Cursor to obtain the translation rows where the language or
385: -- source_lang match the specified language.