808: raise;
809: end if;
810: --
811: when others then
812: hr_message.provide_error;
813: if (hr_message.last_message_name = 'HR_7165_OBJECT_LOCKED') and
814: lock_wait(l_start_time, l_lock_count) then
815: --
816: rollback to action_archinit_sp;
809: end if;
810: --
811: when others then
812: hr_message.provide_error;
813: if (hr_message.last_message_name = 'HR_7165_OBJECT_LOCKED') and
814: lock_wait(l_start_time, l_lock_count) then
815: --
816: rollback to action_archinit_sp;
817: lock_sleep;
886: raise;
887: end if;
888: --
889: when others then
890: hr_message.provide_error;
891: if (hr_message.last_message_name = 'HR_7165_OBJECT_LOCKED') and
892: lock_wait(l_start_time, l_lock_count) then
893: --
894: rollback to action_range_cursor_sp;
887: end if;
888: --
889: when others then
890: hr_message.provide_error;
891: if (hr_message.last_message_name = 'HR_7165_OBJECT_LOCKED') and
892: lock_wait(l_start_time, l_lock_count) then
893: --
894: rollback to action_range_cursor_sp;
895: lock_sleep;
1166: raise;
1167: end if;
1168: --
1169: when others then
1170: hr_message.provide_error;
1171: if hr_message.last_message_name = 'HR_7165_OBJECT_LOCKED' and
1172: lock_wait(l_start_time, l_lock_count) then
1173: --
1174: rollback to action_archive_data_sp;
1167: end if;
1168: --
1169: when others then
1170: hr_message.provide_error;
1171: if hr_message.last_message_name = 'HR_7165_OBJECT_LOCKED' and
1172: lock_wait(l_start_time, l_lock_count) then
1173: --
1174: rollback to action_archive_data_sp;
1175: lock_sleep;