The following lines contain the word 'select', 'insert', 'update' or 'delete':
failed_to_update_status EXCEPTION;
/* update dummy timer status to EXPIRED */
xnp_timer_core.update_timer_status(
p_timer_id => l_msg_header.message_id,
p_status => 'EXPIRED',
x_error_code => l_error_code,
x_error_message => l_error_message);
RAISE failed_to_update_status;
/* update dummy timer status to EXPIRED */
xnp_timer_core.update_timer_status(
p_timer_id => l_msg_header.message_id,
p_status => 'EXPIRED',
x_error_code => l_error_code,
x_error_message => l_error_message);
RAISE failed_to_update_status;
xnp_message.update_status(l_msg_header.message_id,
'FAILED',
l_fnd_message) ;
xnp_message.update_status(l_msg_header.message_id,
'FAILED',
l_fnd_message) ;
xnp_message.update_status(l_msg_header.message_id,
'FAILED',
l_fnd_message) ;
/* failed to update timer status in registry */
WHEN failed_to_update_status THEN
ROLLBACK TO dequeue_timer ;
fnd_message.set_name ('XNP', 'UPDATE_TIMER_STATUS_FAILED') ;
xnp_message.update_status(l_msg_header.message_id,
'FAILED',
l_fnd_message) ;
failed_to_update_status EXCEPTION;
/* update dummy timer status to EXPIRED */
xnp_timer_core.update_timer_status(
p_timer_id => l_msg_header.message_id,
p_status => 'EXPIRED',
x_error_code => l_error_code,
x_error_message => l_error_message);
RAISE failed_to_update_status;
/* update dummy timer status to EXPIRED */
xnp_timer_core.update_timer_status(
p_timer_id => l_msg_header.message_id,
p_status => 'EXPIRED',
x_error_code => l_error_code,
x_error_message => l_error_message);
RAISE failed_to_update_status;
xnp_message.update_status(l_msg_header.message_id,
'FAILED',
l_fnd_message) ;
xnp_message.update_status(l_msg_header.message_id,
'FAILED',
l_fnd_message) ;
xnp_message.update_status(l_msg_header.message_id,
'FAILED',
l_fnd_message) ;
/* failed to update timer status in registry */
WHEN failed_to_update_status THEN
ROLLBACK TO dequeue_timer ;
fnd_message.set_name ('XNP', 'UPDATE_TIMER_STATUS_FAILED') ;
xnp_message.update_status(l_msg_header.message_id,
'FAILED',
l_fnd_message) ;