APPS.PAY_BDT_UPD dependencies on HR_API

Line 84: When hr_api.check_integrity_violated Then

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

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

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

Line 89: When hr_api.parent_integrity_violated Then

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

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

89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
92: pay_bdt_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: pay_bdt_shd.constraint_error

Line 94: When hr_api.unique_integrity_violated Then

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

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

94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: pay_bdt_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --
101: Raise;
102: End update_dml;

Line 215: when hr_api.cannot_find_prog_unit then

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

Line 217: hr_api.cannot_find_prog_unit_error

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

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

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

Line 284: If (p_rec.dimension_name = hr_api.g_varchar2) then

280: If (p_rec.source_lang = hr_api.g_varchar2) then
281: p_rec.source_lang :=
282: pay_bdt_shd.g_old_rec.source_lang;
283: End If;
284: If (p_rec.dimension_name = hr_api.g_varchar2) then
285: p_rec.dimension_name :=
286: pay_bdt_shd.g_old_rec.dimension_name;
287: End If;
288: If (p_rec.database_item_suffix = hr_api.g_varchar2) then

Line 288: If (p_rec.database_item_suffix = hr_api.g_varchar2) then

284: If (p_rec.dimension_name = hr_api.g_varchar2) then
285: p_rec.dimension_name :=
286: pay_bdt_shd.g_old_rec.dimension_name;
287: End If;
288: If (p_rec.database_item_suffix = hr_api.g_varchar2) then
289: p_rec.database_item_suffix :=
290: pay_bdt_shd.g_old_rec.database_item_suffix;
291: End If;
292: If (p_rec.description = hr_api.g_varchar2) then

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

288: If (p_rec.database_item_suffix = hr_api.g_varchar2) then
289: p_rec.database_item_suffix :=
290: pay_bdt_shd.g_old_rec.database_item_suffix;
291: End If;
292: If (p_rec.description = hr_api.g_varchar2) then
293: p_rec.description :=
294: pay_bdt_shd.g_old_rec.description;
295: End If;
296: --

Line 354: ,p_source_lang in varchar2 default hr_api.g_varchar2

350: -- ----------------------------------------------------------------------------
351: Procedure upd
352: (p_balance_dimension_id in number
353: ,p_language in varchar2
354: ,p_source_lang in varchar2 default hr_api.g_varchar2
355: ,p_dimension_name in varchar2 default hr_api.g_varchar2
356: ,p_database_item_suffix in varchar2 default hr_api.g_varchar2
357: ,p_description in varchar2 default hr_api.g_varchar2
358: ) is

Line 355: ,p_dimension_name in varchar2 default hr_api.g_varchar2

351: Procedure upd
352: (p_balance_dimension_id in number
353: ,p_language in varchar2
354: ,p_source_lang in varchar2 default hr_api.g_varchar2
355: ,p_dimension_name in varchar2 default hr_api.g_varchar2
356: ,p_database_item_suffix in varchar2 default hr_api.g_varchar2
357: ,p_description in varchar2 default hr_api.g_varchar2
358: ) is
359: --

Line 356: ,p_database_item_suffix in varchar2 default hr_api.g_varchar2

352: (p_balance_dimension_id in number
353: ,p_language in varchar2
354: ,p_source_lang in varchar2 default hr_api.g_varchar2
355: ,p_dimension_name in varchar2 default hr_api.g_varchar2
356: ,p_database_item_suffix in varchar2 default hr_api.g_varchar2
357: ,p_description in varchar2 default hr_api.g_varchar2
358: ) is
359: --
360: l_rec pay_bdt_shd.g_rec_type;

Line 357: ,p_description in varchar2 default hr_api.g_varchar2

353: ,p_language in varchar2
354: ,p_source_lang in varchar2 default hr_api.g_varchar2
355: ,p_dimension_name in varchar2 default hr_api.g_varchar2
356: ,p_database_item_suffix in varchar2 default hr_api.g_varchar2
357: ,p_description in varchar2 default hr_api.g_varchar2
358: ) is
359: --
360: l_rec pay_bdt_shd.g_rec_type;
361: l_proc varchar2(72) := g_package||'upd';

Line 397: ,p_dimension_name in varchar2 default hr_api.g_varchar2

393: -- ----------------------------------------------------------------------------
394: Procedure upd_tl
395: (p_language_code in varchar2
396: ,p_balance_dimension_id in number
397: ,p_dimension_name in varchar2 default hr_api.g_varchar2
398: ,p_database_item_suffix in varchar2 default hr_api.g_varchar2
399: ,p_description in varchar2 default hr_api.g_varchar2
400: ,p_record_dbi_changes in boolean default false
401: ) is

Line 398: ,p_database_item_suffix in varchar2 default hr_api.g_varchar2

394: Procedure upd_tl
395: (p_language_code in varchar2
396: ,p_balance_dimension_id in number
397: ,p_dimension_name in varchar2 default hr_api.g_varchar2
398: ,p_database_item_suffix in varchar2 default hr_api.g_varchar2
399: ,p_description in varchar2 default hr_api.g_varchar2
400: ,p_record_dbi_changes in boolean default false
401: ) is
402: --

Line 399: ,p_description in varchar2 default hr_api.g_varchar2

395: (p_language_code in varchar2
396: ,p_balance_dimension_id in number
397: ,p_dimension_name in varchar2 default hr_api.g_varchar2
398: ,p_database_item_suffix in varchar2 default hr_api.g_varchar2
399: ,p_description in varchar2 default hr_api.g_varchar2
400: ,p_record_dbi_changes in boolean default false
401: ) is
402: --
403: -- Cursor to obtain the translation rows where the language or