DBA Data[Home] [Help]

APPS.XNP_TIMER_MGR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 52

  failed_to_update_status	EXCEPTION;
Line: 97

	/* 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);
Line: 106

		RAISE failed_to_update_status;
Line: 136

		/* 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);
Line: 156

			RAISE failed_to_update_status;
Line: 177

		xnp_message.update_status(l_msg_header.message_id,
				'FAILED',
				l_fnd_message) ;
Line: 199

		xnp_message.update_status(l_msg_header.message_id,
				'FAILED',
				l_fnd_message) ;
Line: 220

		xnp_message.update_status(l_msg_header.message_id,
				'FAILED',
				l_fnd_message) ;
Line: 224

	/* failed to update timer status in registry */

    	WHEN failed_to_update_status THEN

		ROLLBACK TO dequeue_timer ;
Line: 230

         	fnd_message.set_name ('XNP', 'UPDATE_TIMER_STATUS_FAILED') ;
Line: 243

		xnp_message.update_status(l_msg_header.message_id,
				'FAILED',
				l_fnd_message) ;
Line: 274

  failed_to_update_status	EXCEPTION;
Line: 305

	/* 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);
Line: 314

		RAISE failed_to_update_status;
Line: 344

		/* 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);
Line: 364

			RAISE failed_to_update_status;
Line: 385

		xnp_message.update_status(l_msg_header.message_id,
				'FAILED',
				l_fnd_message) ;
Line: 407

		xnp_message.update_status(l_msg_header.message_id,
				'FAILED',
				l_fnd_message) ;
Line: 428

		xnp_message.update_status(l_msg_header.message_id,
				'FAILED',
				l_fnd_message) ;
Line: 432

	/* failed to update timer status in registry */

    	WHEN failed_to_update_status THEN

		ROLLBACK TO dequeue_timer ;
Line: 438

         	fnd_message.set_name ('XNP', 'UPDATE_TIMER_STATUS_FAILED') ;
Line: 451

		xnp_message.update_status(l_msg_header.message_id,
				'FAILED',
				l_fnd_message) ;