52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy hxc_err_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72);
60: --
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));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: --
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));
109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: --
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));
114: When Others Then
115: --
116: Raise;
148: --
149: -- {End Of Comments}
150: -- ----------------------------------------------------------------------------
151: Procedure pre_update
152: (p_rec in hxc_err_shd.g_rec_type
153: ) is
154: --
155: l_proc varchar2(72);
156: --
195: --
196: -- {End Of Comments}
197: -- ----------------------------------------------------------------------------
198: Procedure post_update
199: (p_rec in hxc_err_shd.g_rec_type
200: ) is
201: --
202: l_proc varchar2(72);
203: --
233: => p_rec.application_short_name
234: ,p_object_version_number
235: => p_rec.object_version_number
236: ,p_transaction_detail_id_o
237: => hxc_err_shd.g_old_rec.transaction_detail_id
238: ,p_time_building_block_id_o
239: => hxc_err_shd.g_old_rec.time_building_block_id
240: ,p_time_building_block_ovn_o
241: => hxc_err_shd.g_old_rec.time_building_block_ovn
235: => p_rec.object_version_number
236: ,p_transaction_detail_id_o
237: => hxc_err_shd.g_old_rec.transaction_detail_id
238: ,p_time_building_block_id_o
239: => hxc_err_shd.g_old_rec.time_building_block_id
240: ,p_time_building_block_ovn_o
241: => hxc_err_shd.g_old_rec.time_building_block_ovn
242: ,p_time_attribute_id_o
243: => hxc_err_shd.g_old_rec.time_attribute_id
237: => hxc_err_shd.g_old_rec.transaction_detail_id
238: ,p_time_building_block_id_o
239: => hxc_err_shd.g_old_rec.time_building_block_id
240: ,p_time_building_block_ovn_o
241: => hxc_err_shd.g_old_rec.time_building_block_ovn
242: ,p_time_attribute_id_o
243: => hxc_err_shd.g_old_rec.time_attribute_id
244: ,p_time_attribute_ovn_o
245: => hxc_err_shd.g_old_rec.time_attribute_ovn
239: => hxc_err_shd.g_old_rec.time_building_block_id
240: ,p_time_building_block_ovn_o
241: => hxc_err_shd.g_old_rec.time_building_block_ovn
242: ,p_time_attribute_id_o
243: => hxc_err_shd.g_old_rec.time_attribute_id
244: ,p_time_attribute_ovn_o
245: => hxc_err_shd.g_old_rec.time_attribute_ovn
246: ,p_message_name_o
247: => hxc_err_shd.g_old_rec.message_name
241: => hxc_err_shd.g_old_rec.time_building_block_ovn
242: ,p_time_attribute_id_o
243: => hxc_err_shd.g_old_rec.time_attribute_id
244: ,p_time_attribute_ovn_o
245: => hxc_err_shd.g_old_rec.time_attribute_ovn
246: ,p_message_name_o
247: => hxc_err_shd.g_old_rec.message_name
248: ,p_message_level_o
249: => hxc_err_shd.g_old_rec.message_level
243: => hxc_err_shd.g_old_rec.time_attribute_id
244: ,p_time_attribute_ovn_o
245: => hxc_err_shd.g_old_rec.time_attribute_ovn
246: ,p_message_name_o
247: => hxc_err_shd.g_old_rec.message_name
248: ,p_message_level_o
249: => hxc_err_shd.g_old_rec.message_level
250: ,p_message_field_o
251: => hxc_err_shd.g_old_rec.message_field
245: => hxc_err_shd.g_old_rec.time_attribute_ovn
246: ,p_message_name_o
247: => hxc_err_shd.g_old_rec.message_name
248: ,p_message_level_o
249: => hxc_err_shd.g_old_rec.message_level
250: ,p_message_field_o
251: => hxc_err_shd.g_old_rec.message_field
252: ,p_message_tokens_o
253: => hxc_err_shd.g_old_rec.message_tokens
247: => hxc_err_shd.g_old_rec.message_name
248: ,p_message_level_o
249: => hxc_err_shd.g_old_rec.message_level
250: ,p_message_field_o
251: => hxc_err_shd.g_old_rec.message_field
252: ,p_message_tokens_o
253: => hxc_err_shd.g_old_rec.message_tokens
254: ,p_application_short_name_o
255: => hxc_err_shd.g_old_rec.application_short_name
249: => hxc_err_shd.g_old_rec.message_level
250: ,p_message_field_o
251: => hxc_err_shd.g_old_rec.message_field
252: ,p_message_tokens_o
253: => hxc_err_shd.g_old_rec.message_tokens
254: ,p_application_short_name_o
255: => hxc_err_shd.g_old_rec.application_short_name
256: ,p_object_version_number_o
257: => hxc_err_shd.g_old_rec.object_version_number
251: => hxc_err_shd.g_old_rec.message_field
252: ,p_message_tokens_o
253: => hxc_err_shd.g_old_rec.message_tokens
254: ,p_application_short_name_o
255: => hxc_err_shd.g_old_rec.application_short_name
256: ,p_object_version_number_o
257: => hxc_err_shd.g_old_rec.object_version_number
258: );
259: */
253: => hxc_err_shd.g_old_rec.message_tokens
254: ,p_application_short_name_o
255: => hxc_err_shd.g_old_rec.application_short_name
256: ,p_object_version_number_o
257: => hxc_err_shd.g_old_rec.object_version_number
258: );
259: */
260: null;
261:
318: --
319: -- {End Of Comments}
320: -- ----------------------------------------------------------------------------
321: Procedure convert_defs
322: (p_rec in out nocopy hxc_err_shd.g_rec_type
323: ) is
324: --
325: Begin
326: --
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
337: p_rec.time_building_block_id :=
338: hxc_err_shd.g_old_rec.time_building_block_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
341: p_rec.time_building_block_ovn :=
342: hxc_err_shd.g_old_rec.time_building_block_ovn;
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
345: p_rec.time_attribute_id :=
346: hxc_err_shd.g_old_rec.time_attribute_id;
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
349: p_rec.time_attribute_ovn :=
350: hxc_err_shd.g_old_rec.time_attribute_ovn;
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
353: p_rec.message_name :=
354: hxc_err_shd.g_old_rec.message_name;
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
357: p_rec.message_level :=
358: hxc_err_shd.g_old_rec.message_level;
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
361: p_rec.message_field :=
362: hxc_err_shd.g_old_rec.message_field;
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
365: p_rec.message_tokens :=
366: hxc_err_shd.g_old_rec.message_tokens;
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
369: p_rec.application_short_name :=
370: hxc_err_shd.g_old_rec.application_short_name;
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: --
373: End convert_defs;
374: --
375: -- ----------------------------------------------------------------------------
376: -- |---------------------------------< upd >----------------------------------|
377: -- ----------------------------------------------------------------------------
378: Procedure upd
379: (p_rec in out nocopy hxc_err_shd.g_rec_type
380: ) is
381: --
382: l_proc varchar2(72);
383: --
389: end if;
390: --
391: -- We must lock the row which we need to update.
392: --
393: hxc_err_shd.lck
394: (p_rec.error_id
395: ,p_rec.object_version_number
396: );
397: --
446: ,p_date_from in date
447: ,p_date_to in date
448: ) is
449: --
450: l_rec hxc_err_shd.g_rec_type;
451: l_proc varchar2(72);
452: --
453: Begin
454: g_debug:=hr_utility.debug_enabled;
460: -- Call conversion function to turn arguments into the
461: -- l_rec structure.
462: --
463: l_rec :=
464: hxc_err_shd.convert_args
465: (p_error_id
466: ,p_transaction_detail_id
467: ,p_time_building_block_id
468: ,p_time_building_block_ovn