eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_ADAPTER SQL Statements

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

Line: 91


	select count(*) into l_count from xdp_adapter_reg
		where adapter_display_name = p_AdapterDispName;

Line: 99


        select application_mode, adapter_class, connection_required_flag, inbound_required_flag
        into l_ApplicationMode, l_AdapterClass, l_ConnReqFlag, l_InboundReqFlag
        from xdp_adapter_types_b
        where adapter_type = p_AdapterType;

Line: 281


Procedure Update_Adapter(p_ChannelName in varchar2,
			    p_AdapterName in varchar2,
			    p_AdapterDispName in varchar2,
			    p_ConcQID in number,
			    p_StartupMode in varchar2 default 'MANUAL',
			    p_UsageCode in varchar2 default 'NORMAL',
			    p_LogLevel in varchar2 default 'ERROR',
			    p_CODFlag in varchar2 default 'N',
			    p_MaxIdleTime in number default 0,
			    p_LogFileName in varchar2 default NULL,
			    p_SeqInFE in number default null,
			    p_CmdLineOpts in varchar2 default NULL,
                            p_CmdLineArgs in varchar2 default NULL,
			    p_retcode	OUT NOCOPY NUMBER,
			    p_errbuf	OUT NOCOPY VARCHAR2
			)
is
 l_AdapterLocked varchar2(1) := 'N';

Line: 314


	    FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.UPDATE_ADAPTER',
				'BEGIN:p_ChannelName: '||p_ChannelName);

Line: 331


		FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
					'Required parameters are not passed');

Line: 338


					XDP_ADAPTER.pv_opUpdate,
					l_CurrentStatus) then
		raise e_InvalidAdapterState;

Line: 352


	select count(*) into l_count from xdp_adapter_reg
		where adapter_display_name = p_AdapterDispName and
		channel_name <> p_ChannelName;

Line: 359


        select xat.application_mode, xat.adapter_class, xat.connection_required_flag, xat.inbound_required_flag
        into l_ApplicationMode, l_AdapterClass, l_ConnReqFlag, l_InboundReqFlag
        from xdp_adapter_types_b xat, xdp_adapter_reg xar
        where xat.adapter_type = xar.adapter_type
          and xar.channel_name = p_ChannelName;

Line: 409


	XDP_ADAPTER_CORE_DB.UpdateAdapter(
				p_ChannelName => p_ChannelName,
				p_AdapterName => p_AdapterName,
				p_AdapterDispName => p_AdapterDispName,
				p_SvcInstId => p_ConcQID,
				p_StartupMode => p_StartupMode,
				p_UsageCode => p_UsageCode,
			    	p_LogLevel => p_LogLevel,
				p_CODFlag => p_CODFlag,
				p_MaxIdleTime => p_MaxIdleTime,
			    	p_LogFileName => l_LogFileName,
			    	p_SeqInFE => p_SeqInFE,
				p_CmdLineOpts => p_CmdLineOpts,
				p_CmdLineArgs => p_CmdLineArgs
				);

Line: 427


		FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',
			'Could not release the lock, Channel name: '||p_ChannelName);

Line: 437


		FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',
			'Could not release the lock, Channel name: '||p_ChannelName);

Line: 447


	    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
		'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 456


	    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
		'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 465


	    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
		'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 472


        fnd_message.set_token('OPERATION', 'Update');

Line: 509


		FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',
			'Could not release the lock, Channel name: '||p_ChannelName);

Line: 522


    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
	'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 525


END Update_Adapter;

Line: 527


Procedure Delete_Adapter(p_ChannelName in varchar2,
		   	 p_retcode OUT NOCOPY NUMBER,
			 p_errbuf OUT NOCOPY VARCHAR2
			)
is

 l_AdapterLocked varchar2(1) := 'N';

Line: 542


	    FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ADAPTER',
				'BEGIN:p_ChannelName: '||p_ChannelName);

Line: 559


		FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
					'Required parameters are not passed');

Line: 566


					XDP_ADAPTER.pv_opDelete,
					l_CurrentStatus) then
		raise e_InvalidAdapterState;

Line: 577


	XDP_ADAPTER_CORE_DB.Delete_Adapter (p_channel_name => p_ChannelName);

Line: 581


		FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DELETE_ADAPTER',
			'Could not release the lock, Channel name: '||p_ChannelName);

Line: 593


	    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
		'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 602


    	    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
		'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 609


        fnd_message.set_token('OPERATION', 'Delete');

Line: 619


		FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DELETE_ADAPTER',
			'Could not release the lock, Channel name: '||p_ChannelName);

Line: 632


    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
	'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 635


end Delete_Adapter;

Line: 637


Procedure Delete_All_For_FE (p_FeName in varchar2,
		   	 	  p_retcode OUT NOCOPY NUMBER,
			 	  p_errbuf OUT NOCOPY VARCHAR2)
is
 l_FeID number := -1;

Line: 646


	    FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
				'BEGIN:p_FeName: '||p_FeName);

Line: 657


		FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
				'Some adapters are running for the FE: '||p_FeName);

Line: 663


	XDP_ADAPTER_CORE_DB.Delete_Adapters_For_FE (p_fe_id => l_FeID);

Line: 673


	    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
		'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 686


    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
	'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 689


end Delete_All_For_FE;

Line: 819


Procedure Update_Admin_Request (p_RequestID in number,
				p_RequestDate in date default sysdate,
				p_RequestedBy in varchar2 default null,
				p_Freq in number default null,
				p_retcode	OUT NOCOPY NUMBER,
				p_errbuf	OUT NOCOPY VARCHAR2
				)
is

 e_InvalidRequestDate  EXCEPTION;

Line: 832


	    FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
				'BEGIN:p_RequestID: '||p_RequestID);

Line: 841


					'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
					'Required parameters are not passed');

Line: 856


	XDP_ADAPTER_CORE_DB.UpdateAdapterAdminReq(
		p_RequestID => Update_Admin_Request.p_RequestID,
		p_RequestDate => Update_Admin_Request.p_RequestDate,
		p_RequestedBy => Update_Admin_Request.p_RequestedBy,
		p_Freq => Update_Admin_Request.p_Freq);

Line: 869


	    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
		'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 882


    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
	'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 885


end Update_Admin_Request;

Line: 887


Procedure Delete_Admin_Request (p_RequestID in number,
		   	 	 p_retcode OUT NOCOPY NUMBER,
			 	 p_errbuf OUT NOCOPY VARCHAR2)
is
 l_dummy varchar2(80);

Line: 897


	    FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ADMIN_REQUEST',
				'BEGIN:p_RequestID: '||p_RequestID);

Line: 906


					'XDP_ADAPTER.DELETE_ADMIN_REQUEST',
					'Required parameters are not passed');

Line: 913


		p_RequestID => Delete_Admin_Request.p_RequestID);

Line: 925


    FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADMIN_REQUEST',
	'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);

Line: 928


end Delete_Admin_Request;

Line: 1048


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusStarting);

Line: 1057


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusRunning);

Line: 1075


			XDP_ERRORS_PKG.UPDATE_ERROR_COUNT (
				p_object_type => XDP_ADAPTER.pv_errorObjectTypeAdapter,
				p_object_key => p_ChannelName);

Line: 1199


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusStopping);

Line: 1220


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusStopped);

Line: 1229


				XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
					p_ChannelName => p_ChannelName,
					p_Status => pv_statusDeactivated);

Line: 1305


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusSuspending);

Line: 1314


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusSuspended);

Line: 1377


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusResuming);

Line: 1388


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusRunning);

Line: 1459


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusConnecting);

Line: 1470


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusRunning);

Line: 1540


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusDisconnecting);

Line: 1549


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusDisconnected);

Line: 1613


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
				p_ChannelName => p_ChannelName,
				p_Status => pv_statusTerminating);

Line: 1622


		XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
			p_ChannelName => p_ChannelName,
			p_Status => pv_statusTerminated,
			p_ErrorMsg => 'XDP_ADAPTER_TERMINATED');

Line: 1701


    SELECT 'x' FROM
          xdp_fes,
          xdp_adapter_reg
    WHERE xdp_fes.fe_id = p_fe_id
    AND   xdp_fes.fe_id = xdp_adapter_reg.fe_id;

Line: 1736


  SELECT log_file_name, target_node
  INTO l_log_file_name, l_target_node
  FROM xdp_adapter_reg_v
  WHERE channel_name = p_channel_name;

Line: 1833


			XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
					p_ChannelName,
					pv_statusStoppedError,
					'XDP_ADAPTER_ABNORMAL_EXIT',
					'PROCESS_ID='||l_ProcessID||'#XDP#');

Line: 1844


			-- Could not get lock, Adapter running, update last_verified_date
			XDP_ADAPTER_CORE_DB.UpdateAdapter (
					p_ChannelName => p_ChannelName,
					p_LastVerified => sysdate);

Line: 1850


		-- Adapter not implemented, so Adapter is 'running', update last_verified_date
		XDP_ADAPTER_CORE_DB.UpdateAdapter (
				p_ChannelName => p_ChannelName,
				p_LastVerified => sysdate);

Line: 2092


		sql_stmt := 'select CHANNEL_NAME, PROCESS_ID, ADAPTER_STATUS, STATUS_ACTIVE_TIME from XDP_ADAPTER_REG_V a, XDP_ADAPTER_TYPES_B b where ADAPTER_STATUS not in ';

Line: 2179


			XDP_ADAPTER_CORE_DB.UpdateAdapter(
				p_ChannelName => p_ChannelName,
				p_Status => pv_statusStopped);

Line: 2186


		XDP_ERRORS_PKG.UPDATE_ERROR_COUNT (
			p_object_type => XDP_ADAPTER.pv_errorObjectTypeAdapter,
			p_object_key => p_ChannelName);