DBA Data[Home] [Help]

APPS.HXC_ERR_UPD dependencies on HR_API

Line 99: When hr_api.check_integrity_violated Then

95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: end if;
97: --
98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: --
102: hxc_err_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: --
102: hxc_err_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: --
107: hxc_err_shd.constraint_error

Line 104: When hr_api.parent_integrity_violated Then

100: -- A check constraint has been violated
101: --
102: hxc_err_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: --
107: hxc_err_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.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: --
107: hxc_err_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: --
112: hxc_err_shd.constraint_error

Line 109: When hr_api.unique_integrity_violated Then

105: -- Parent integrity has been violated
106: --
107: hxc_err_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: --
112: hxc_err_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.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: --
112: hxc_err_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
115: --
116: Raise;
117: End update_dml;

Line 265: when hr_api.cannot_find_prog_unit then

261:
262: --
263: exception
264: --
265: when hr_api.cannot_find_prog_unit then
266: --
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'HXC_ERRORS'
269: ,p_hook_type => 'AU');

Line 267: hr_api.cannot_find_prog_unit_error

263: exception
264: --
265: when hr_api.cannot_find_prog_unit then
266: --
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'HXC_ERRORS'
269: ,p_hook_type => 'AU');
270: --
271: end;

Line 332: If (p_rec.transaction_detail_id = hr_api.g_number) then

328: -- p_rec plsql record structure
329: -- to see if a system default is being used. If a system default
330: -- is being used then we must set to the 'current' argument value.
331: --
332: If (p_rec.transaction_detail_id = hr_api.g_number) then
333: p_rec.transaction_detail_id :=
334: hxc_err_shd.g_old_rec.transaction_detail_id;
335: End If;
336: If (p_rec.time_building_block_id = hr_api.g_number) then

Line 336: If (p_rec.time_building_block_id = hr_api.g_number) then

332: If (p_rec.transaction_detail_id = hr_api.g_number) then
333: p_rec.transaction_detail_id :=
334: hxc_err_shd.g_old_rec.transaction_detail_id;
335: End If;
336: If (p_rec.time_building_block_id = hr_api.g_number) then
337: p_rec.time_building_block_id :=
338: hxc_err_shd.g_old_rec.time_building_block_id;
339: End If;
340: If (p_rec.time_building_block_ovn = hr_api.g_number) then

Line 340: If (p_rec.time_building_block_ovn = hr_api.g_number) then

336: If (p_rec.time_building_block_id = hr_api.g_number) then
337: p_rec.time_building_block_id :=
338: hxc_err_shd.g_old_rec.time_building_block_id;
339: End If;
340: If (p_rec.time_building_block_ovn = hr_api.g_number) then
341: p_rec.time_building_block_ovn :=
342: hxc_err_shd.g_old_rec.time_building_block_ovn;
343: End If;
344: If (p_rec.time_attribute_id = hr_api.g_number) then

Line 344: If (p_rec.time_attribute_id = hr_api.g_number) then

340: If (p_rec.time_building_block_ovn = hr_api.g_number) then
341: p_rec.time_building_block_ovn :=
342: hxc_err_shd.g_old_rec.time_building_block_ovn;
343: End If;
344: If (p_rec.time_attribute_id = hr_api.g_number) then
345: p_rec.time_attribute_id :=
346: hxc_err_shd.g_old_rec.time_attribute_id;
347: End If;
348: If (p_rec.time_attribute_ovn = hr_api.g_number) then

Line 348: If (p_rec.time_attribute_ovn = hr_api.g_number) then

344: If (p_rec.time_attribute_id = hr_api.g_number) then
345: p_rec.time_attribute_id :=
346: hxc_err_shd.g_old_rec.time_attribute_id;
347: End If;
348: If (p_rec.time_attribute_ovn = hr_api.g_number) then
349: p_rec.time_attribute_ovn :=
350: hxc_err_shd.g_old_rec.time_attribute_ovn;
351: End If;
352: If (p_rec.message_name = hr_api.g_varchar2) then

Line 352: If (p_rec.message_name = hr_api.g_varchar2) then

348: If (p_rec.time_attribute_ovn = hr_api.g_number) then
349: p_rec.time_attribute_ovn :=
350: hxc_err_shd.g_old_rec.time_attribute_ovn;
351: End If;
352: If (p_rec.message_name = hr_api.g_varchar2) then
353: p_rec.message_name :=
354: hxc_err_shd.g_old_rec.message_name;
355: End If;
356: If (p_rec.message_level = hr_api.g_varchar2) then

Line 356: If (p_rec.message_level = hr_api.g_varchar2) then

352: If (p_rec.message_name = hr_api.g_varchar2) then
353: p_rec.message_name :=
354: hxc_err_shd.g_old_rec.message_name;
355: End If;
356: If (p_rec.message_level = hr_api.g_varchar2) then
357: p_rec.message_level :=
358: hxc_err_shd.g_old_rec.message_level;
359: End If;
360: If (p_rec.message_field = hr_api.g_varchar2) then

Line 360: If (p_rec.message_field = hr_api.g_varchar2) then

356: If (p_rec.message_level = hr_api.g_varchar2) then
357: p_rec.message_level :=
358: hxc_err_shd.g_old_rec.message_level;
359: End If;
360: If (p_rec.message_field = hr_api.g_varchar2) then
361: p_rec.message_field :=
362: hxc_err_shd.g_old_rec.message_field;
363: End If;
364: If (p_rec.message_tokens = hr_api.g_varchar2) then

Line 364: If (p_rec.message_tokens = hr_api.g_varchar2) then

360: If (p_rec.message_field = hr_api.g_varchar2) then
361: p_rec.message_field :=
362: hxc_err_shd.g_old_rec.message_field;
363: End If;
364: If (p_rec.message_tokens = hr_api.g_varchar2) then
365: p_rec.message_tokens :=
366: hxc_err_shd.g_old_rec.message_tokens;
367: End If;
368: If (p_rec.application_short_name = hr_api.g_varchar2) then

Line 368: If (p_rec.application_short_name = hr_api.g_varchar2) then

364: If (p_rec.message_tokens = hr_api.g_varchar2) then
365: p_rec.message_tokens :=
366: hxc_err_shd.g_old_rec.message_tokens;
367: End If;
368: If (p_rec.application_short_name = hr_api.g_varchar2) then
369: p_rec.application_short_name :=
370: hxc_err_shd.g_old_rec.application_short_name;
371: End If;
372: --

Line 436: ,p_transaction_detail_id in number default hr_api.g_number

432: -- ----------------------------------------------------------------------------
433: Procedure upd
434: (p_error_id in number
435: ,p_object_version_number in number
436: ,p_transaction_detail_id in number default hr_api.g_number
437: ,p_time_building_block_id in number default hr_api.g_number
438: ,p_time_building_block_ovn in number default hr_api.g_number
439: ,p_time_attribute_id in number default hr_api.g_number
440: ,p_time_attribute_ovn in number default hr_api.g_number

Line 437: ,p_time_building_block_id in number default hr_api.g_number

433: Procedure upd
434: (p_error_id in number
435: ,p_object_version_number in number
436: ,p_transaction_detail_id in number default hr_api.g_number
437: ,p_time_building_block_id in number default hr_api.g_number
438: ,p_time_building_block_ovn in number default hr_api.g_number
439: ,p_time_attribute_id in number default hr_api.g_number
440: ,p_time_attribute_ovn in number default hr_api.g_number
441: ,p_message_name in varchar2 default hr_api.g_varchar2

Line 438: ,p_time_building_block_ovn in number default hr_api.g_number

434: (p_error_id in number
435: ,p_object_version_number in number
436: ,p_transaction_detail_id in number default hr_api.g_number
437: ,p_time_building_block_id in number default hr_api.g_number
438: ,p_time_building_block_ovn in number default hr_api.g_number
439: ,p_time_attribute_id in number default hr_api.g_number
440: ,p_time_attribute_ovn in number default hr_api.g_number
441: ,p_message_name in varchar2 default hr_api.g_varchar2
442: ,p_message_level in varchar2 default hr_api.g_varchar2

Line 439: ,p_time_attribute_id in number default hr_api.g_number

435: ,p_object_version_number in number
436: ,p_transaction_detail_id in number default hr_api.g_number
437: ,p_time_building_block_id in number default hr_api.g_number
438: ,p_time_building_block_ovn in number default hr_api.g_number
439: ,p_time_attribute_id in number default hr_api.g_number
440: ,p_time_attribute_ovn in number default hr_api.g_number
441: ,p_message_name in varchar2 default hr_api.g_varchar2
442: ,p_message_level in varchar2 default hr_api.g_varchar2
443: ,p_message_field in varchar2 default hr_api.g_varchar2

Line 440: ,p_time_attribute_ovn in number default hr_api.g_number

436: ,p_transaction_detail_id in number default hr_api.g_number
437: ,p_time_building_block_id in number default hr_api.g_number
438: ,p_time_building_block_ovn in number default hr_api.g_number
439: ,p_time_attribute_id in number default hr_api.g_number
440: ,p_time_attribute_ovn in number default hr_api.g_number
441: ,p_message_name in varchar2 default hr_api.g_varchar2
442: ,p_message_level in varchar2 default hr_api.g_varchar2
443: ,p_message_field in varchar2 default hr_api.g_varchar2
444: ,p_message_tokens in varchar2 default hr_api.g_varchar2

Line 441: ,p_message_name in varchar2 default hr_api.g_varchar2

437: ,p_time_building_block_id in number default hr_api.g_number
438: ,p_time_building_block_ovn in number default hr_api.g_number
439: ,p_time_attribute_id in number default hr_api.g_number
440: ,p_time_attribute_ovn in number default hr_api.g_number
441: ,p_message_name in varchar2 default hr_api.g_varchar2
442: ,p_message_level in varchar2 default hr_api.g_varchar2
443: ,p_message_field in varchar2 default hr_api.g_varchar2
444: ,p_message_tokens in varchar2 default hr_api.g_varchar2
445: ,p_application_short_name in varchar2 default hr_api.g_varchar2

Line 442: ,p_message_level in varchar2 default hr_api.g_varchar2

438: ,p_time_building_block_ovn in number default hr_api.g_number
439: ,p_time_attribute_id in number default hr_api.g_number
440: ,p_time_attribute_ovn in number default hr_api.g_number
441: ,p_message_name in varchar2 default hr_api.g_varchar2
442: ,p_message_level in varchar2 default hr_api.g_varchar2
443: ,p_message_field in varchar2 default hr_api.g_varchar2
444: ,p_message_tokens in varchar2 default hr_api.g_varchar2
445: ,p_application_short_name in varchar2 default hr_api.g_varchar2
446: ,p_date_from in date

Line 443: ,p_message_field in varchar2 default hr_api.g_varchar2

439: ,p_time_attribute_id in number default hr_api.g_number
440: ,p_time_attribute_ovn in number default hr_api.g_number
441: ,p_message_name in varchar2 default hr_api.g_varchar2
442: ,p_message_level in varchar2 default hr_api.g_varchar2
443: ,p_message_field in varchar2 default hr_api.g_varchar2
444: ,p_message_tokens in varchar2 default hr_api.g_varchar2
445: ,p_application_short_name in varchar2 default hr_api.g_varchar2
446: ,p_date_from in date
447: ,p_date_to in date

Line 444: ,p_message_tokens in varchar2 default hr_api.g_varchar2

440: ,p_time_attribute_ovn in number default hr_api.g_number
441: ,p_message_name in varchar2 default hr_api.g_varchar2
442: ,p_message_level in varchar2 default hr_api.g_varchar2
443: ,p_message_field in varchar2 default hr_api.g_varchar2
444: ,p_message_tokens in varchar2 default hr_api.g_varchar2
445: ,p_application_short_name in varchar2 default hr_api.g_varchar2
446: ,p_date_from in date
447: ,p_date_to in date
448: ) is

Line 445: ,p_application_short_name in varchar2 default hr_api.g_varchar2

441: ,p_message_name in varchar2 default hr_api.g_varchar2
442: ,p_message_level in varchar2 default hr_api.g_varchar2
443: ,p_message_field in varchar2 default hr_api.g_varchar2
444: ,p_message_tokens in varchar2 default hr_api.g_varchar2
445: ,p_application_short_name in varchar2 default hr_api.g_varchar2
446: ,p_date_from in date
447: ,p_date_to in date
448: ) is
449: --