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_APPLICATION dependencies on XDP_ADAPTER

Line 127: FROM xdp_adapter_reg xar, xdp_fes fe

123:
124: CURSOR c_getAdapterInfoAll IS
125: SELECT xar.channel_name, fe.fulfillment_element_name, xar.adapter_display_name,
126: xar.fe_id, xar.adapter_status, xar.process_id
127: FROM xdp_adapter_reg xar, xdp_fes fe
128: WHERE xar.adapter_status not in (XDP_ADAPTER.pv_statusStopped,
129: XDP_ADAPTER.pv_statusStoppedError,
130: XDP_ADAPTER.pv_statusTerminated,
131: XDP_ADAPTER.pv_statusNotAvailable,

Line 128: WHERE xar.adapter_status not in (XDP_ADAPTER.pv_statusStopped,

124: CURSOR c_getAdapterInfoAll IS
125: SELECT xar.channel_name, fe.fulfillment_element_name, xar.adapter_display_name,
126: xar.fe_id, xar.adapter_status, xar.process_id
127: FROM xdp_adapter_reg xar, xdp_fes fe
128: WHERE xar.adapter_status not in (XDP_ADAPTER.pv_statusStopped,
129: XDP_ADAPTER.pv_statusStoppedError,
130: XDP_ADAPTER.pv_statusTerminated,
131: XDP_ADAPTER.pv_statusNotAvailable,
132: XDP_ADAPTER.pv_statusDeactivated,

Line 129: XDP_ADAPTER.pv_statusStoppedError,

125: SELECT xar.channel_name, fe.fulfillment_element_name, xar.adapter_display_name,
126: xar.fe_id, xar.adapter_status, xar.process_id
127: FROM xdp_adapter_reg xar, xdp_fes fe
128: WHERE xar.adapter_status not in (XDP_ADAPTER.pv_statusStopped,
129: XDP_ADAPTER.pv_statusStoppedError,
130: XDP_ADAPTER.pv_statusTerminated,
131: XDP_ADAPTER.pv_statusNotAvailable,
132: XDP_ADAPTER.pv_statusDeactivated,
133: XDP_ADAPTER.pv_statusDeactivatedSystem)

Line 130: XDP_ADAPTER.pv_statusTerminated,

126: xar.fe_id, xar.adapter_status, xar.process_id
127: FROM xdp_adapter_reg xar, xdp_fes fe
128: WHERE xar.adapter_status not in (XDP_ADAPTER.pv_statusStopped,
129: XDP_ADAPTER.pv_statusStoppedError,
130: XDP_ADAPTER.pv_statusTerminated,
131: XDP_ADAPTER.pv_statusNotAvailable,
132: XDP_ADAPTER.pv_statusDeactivated,
133: XDP_ADAPTER.pv_statusDeactivatedSystem)
134: -- and xar.startup_mode = XDP_ADAPTER.pv_startAutomatic

Line 131: XDP_ADAPTER.pv_statusNotAvailable,

127: FROM xdp_adapter_reg xar, xdp_fes fe
128: WHERE xar.adapter_status not in (XDP_ADAPTER.pv_statusStopped,
129: XDP_ADAPTER.pv_statusStoppedError,
130: XDP_ADAPTER.pv_statusTerminated,
131: XDP_ADAPTER.pv_statusNotAvailable,
132: XDP_ADAPTER.pv_statusDeactivated,
133: XDP_ADAPTER.pv_statusDeactivatedSystem)
134: -- and xar.startup_mode = XDP_ADAPTER.pv_startAutomatic
135: and xar.fe_id = fe.fe_id

Line 132: XDP_ADAPTER.pv_statusDeactivated,

128: WHERE xar.adapter_status not in (XDP_ADAPTER.pv_statusStopped,
129: XDP_ADAPTER.pv_statusStoppedError,
130: XDP_ADAPTER.pv_statusTerminated,
131: XDP_ADAPTER.pv_statusNotAvailable,
132: XDP_ADAPTER.pv_statusDeactivated,
133: XDP_ADAPTER.pv_statusDeactivatedSystem)
134: -- and xar.startup_mode = XDP_ADAPTER.pv_startAutomatic
135: and xar.fe_id = fe.fe_id
136: order by fe.fulfillment_element_name;

Line 133: XDP_ADAPTER.pv_statusDeactivatedSystem)

129: XDP_ADAPTER.pv_statusStoppedError,
130: XDP_ADAPTER.pv_statusTerminated,
131: XDP_ADAPTER.pv_statusNotAvailable,
132: XDP_ADAPTER.pv_statusDeactivated,
133: XDP_ADAPTER.pv_statusDeactivatedSystem)
134: -- and xar.startup_mode = XDP_ADAPTER.pv_startAutomatic
135: and xar.fe_id = fe.fe_id
136: order by fe.fulfillment_element_name;
137:

Line 134: -- and xar.startup_mode = XDP_ADAPTER.pv_startAutomatic

130: XDP_ADAPTER.pv_statusTerminated,
131: XDP_ADAPTER.pv_statusNotAvailable,
132: XDP_ADAPTER.pv_statusDeactivated,
133: XDP_ADAPTER.pv_statusDeactivatedSystem)
134: -- and xar.startup_mode = XDP_ADAPTER.pv_startAutomatic
135: and xar.fe_id = fe.fe_id
136: order by fe.fulfillment_element_name;
137:
138: l_temp_fe_name VARCHAR2(2000);

Line 208: -- in XDP_ADAPTER_REG table accordingly

204: IF StopOptions = 'NORMAL' then
205:
206: -- Stop adapter instance
207: -- Following package with also update the adapter instance entry
208: -- in XDP_ADAPTER_REG table accordingly
209: -- and will submit a admin request if required i.e. if the
210: -- Adapter cannot be locked
211:
212: FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||

Line 215: XDP_ADAPTER.Stop_Adapter (

211:
212: FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||
213: v_AdapterData.adapter_display_name);
214:
215: XDP_ADAPTER.Stop_Adapter (
216: v_AdapterData.channel_name,
217: l_retcode, l_errbuf);
218:
219: IF ((l_retcode <> 0) and

Line 220: (l_retcode <> XDP_ADAPTER.pv_retAdapterInvalidState) and

216: v_AdapterData.channel_name,
217: l_retcode, l_errbuf);
218:
219: IF ((l_retcode <> 0) and
220: (l_retcode <> XDP_ADAPTER.pv_retAdapterInvalidState) and
221: (l_retcode <> XDP_ADAPTER.pv_retAdapterCannotLockReqSub)) THEN
222: l_SomeError := TRUE;
223: FND_FILE.put_line(FND_FILE.log,
224: 'Error in stopping adapter '||

Line 221: (l_retcode <> XDP_ADAPTER.pv_retAdapterCannotLockReqSub)) THEN

217: l_retcode, l_errbuf);
218:
219: IF ((l_retcode <> 0) and
220: (l_retcode <> XDP_ADAPTER.pv_retAdapterInvalidState) and
221: (l_retcode <> XDP_ADAPTER.pv_retAdapterCannotLockReqSub)) THEN
222: l_SomeError := TRUE;
223: FND_FILE.put_line(FND_FILE.log,
224: 'Error in stopping adapter '||
225: v_AdapterData.adapter_display_name);

Line 227: elsif (l_retcode = XDP_ADAPTER.pv_retAdapterCannotLockReqSub) then

223: FND_FILE.put_line(FND_FILE.log,
224: 'Error in stopping adapter '||
225: v_AdapterData.adapter_display_name);
226: FND_FILE.put_line(FND_FILE.log,l_errbuf);
227: elsif (l_retcode = XDP_ADAPTER.pv_retAdapterCannotLockReqSub) then
228: FND_FILE.put_line(FND_FILE.log,
229: 'Stop request for adapter '||v_AdapterData.adapter_display_name||
230: ' successfully submitted');
231: FND_FILE.put_line(FND_FILE.log,l_errbuf);

Line 245: -- in XDP_ADAPTER_REG table accordingly

241: -- elsif StopOptions = 'ABORT' then
242: else
243: -- Stop adapter instance in abbort mode
244: -- and also update the adapter instance entry
245: -- in XDP_ADAPTER_REG table accordingly
246:
247: FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||
248: v_AdapterData.adapter_display_name||
249: ' in abort mode');

Line 251: XDP_ADAPTER.Terminate_Adapter (

247: FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||
248: v_AdapterData.adapter_display_name||
249: ' in abort mode');
250:
251: XDP_ADAPTER.Terminate_Adapter (
252: v_AdapterData.channel_name,
253: l_retcode, l_errbuf);
254:
255: IF l_retcode <> 0 THEN

Line 428: -- * XDP_ADAPTER_REGISTRATION table else TRUE

424: -- * INPUTS : None
425: -- * OUTPUTS: None
426: -- * RETURNS: FALSE if adapters and controller cannot be stoppped at this moment i.e. either
427: -- * atleast one adapter instance is BUSY or some process has acquired lock on the
428: -- * XDP_ADAPTER_REGISTRATION table else TRUE
429: -- *
430: -- * This function gracefully shuts down the adapter instances and the controller.
431: -- *
432: -- * Called by: Administration scripts used to shutdown application gracefully.

Line 455: XDP_ADAPTER.Verify_All_Adapters ( p_retcode => retCode,

451: l_SomeError BOOLEAN := FALSE;
452:
453: BEGIN
454: -- Verify / reset adapters silently
455: XDP_ADAPTER.Verify_All_Adapters ( p_retcode => retCode,
456: p_errbuf => errbuf);
457:
458: l_SomeError := FALSE;
459: retcode := 0;

Line 755: for v_GetSvcID in XDP_ADAPTER_CORE_DB.G_Get_Controller_Instances loop

751:
752: if (p_ServiceInstanceList.COUNT > 0) then
753:
754: -- We are only interested in Controller instances that are used
755: for v_GetSvcID in XDP_ADAPTER_CORE_DB.G_Get_Controller_Instances loop
756:
757: l_ControllerReqSubmitted := false;
758:
759: for i in 1..p_ServiceInstanceList.COUNT loop

Line 963: FROM xdp_adapter_reg xar, xdp_fes xfe

959:
960: CURSOR c_getAdapterInfoAll IS
961: SELECT xar.channel_name, xfe.fulfillment_element_name,
962: xar.adapter_display_name, xar.startup_mode, xar.fe_id, xar.adapter_status
963: FROM xdp_adapter_reg xar, xdp_fes xfe
964: WHERE xar.adapter_status in (XDP_ADAPTER.pv_statusStopped,
965: XDP_ADAPTER.pv_statusStoppedError,
966: XDP_ADAPTER.pv_statusTerminated,
967: XDP_ADAPTER.pv_statusDeactivated,

Line 964: WHERE xar.adapter_status in (XDP_ADAPTER.pv_statusStopped,

960: CURSOR c_getAdapterInfoAll IS
961: SELECT xar.channel_name, xfe.fulfillment_element_name,
962: xar.adapter_display_name, xar.startup_mode, xar.fe_id, xar.adapter_status
963: FROM xdp_adapter_reg xar, xdp_fes xfe
964: WHERE xar.adapter_status in (XDP_ADAPTER.pv_statusStopped,
965: XDP_ADAPTER.pv_statusStoppedError,
966: XDP_ADAPTER.pv_statusTerminated,
967: XDP_ADAPTER.pv_statusDeactivated,
968: XDP_ADAPTER.pv_statusDeactivatedSystem)

Line 965: XDP_ADAPTER.pv_statusStoppedError,

961: SELECT xar.channel_name, xfe.fulfillment_element_name,
962: xar.adapter_display_name, xar.startup_mode, xar.fe_id, xar.adapter_status
963: FROM xdp_adapter_reg xar, xdp_fes xfe
964: WHERE xar.adapter_status in (XDP_ADAPTER.pv_statusStopped,
965: XDP_ADAPTER.pv_statusStoppedError,
966: XDP_ADAPTER.pv_statusTerminated,
967: XDP_ADAPTER.pv_statusDeactivated,
968: XDP_ADAPTER.pv_statusDeactivatedSystem)
969: and xar.startup_mode in (XDP_ADAPTER.pv_startAutomatic,

Line 966: XDP_ADAPTER.pv_statusTerminated,

962: xar.adapter_display_name, xar.startup_mode, xar.fe_id, xar.adapter_status
963: FROM xdp_adapter_reg xar, xdp_fes xfe
964: WHERE xar.adapter_status in (XDP_ADAPTER.pv_statusStopped,
965: XDP_ADAPTER.pv_statusStoppedError,
966: XDP_ADAPTER.pv_statusTerminated,
967: XDP_ADAPTER.pv_statusDeactivated,
968: XDP_ADAPTER.pv_statusDeactivatedSystem)
969: and xar.startup_mode in (XDP_ADAPTER.pv_startAutomatic,
970: XDP_ADAPTER.pv_startGroup,

Line 967: XDP_ADAPTER.pv_statusDeactivated,

963: FROM xdp_adapter_reg xar, xdp_fes xfe
964: WHERE xar.adapter_status in (XDP_ADAPTER.pv_statusStopped,
965: XDP_ADAPTER.pv_statusStoppedError,
966: XDP_ADAPTER.pv_statusTerminated,
967: XDP_ADAPTER.pv_statusDeactivated,
968: XDP_ADAPTER.pv_statusDeactivatedSystem)
969: and xar.startup_mode in (XDP_ADAPTER.pv_startAutomatic,
970: XDP_ADAPTER.pv_startGroup,
971: XDP_ADAPTER.pv_startOnDemand)

Line 968: XDP_ADAPTER.pv_statusDeactivatedSystem)

964: WHERE xar.adapter_status in (XDP_ADAPTER.pv_statusStopped,
965: XDP_ADAPTER.pv_statusStoppedError,
966: XDP_ADAPTER.pv_statusTerminated,
967: XDP_ADAPTER.pv_statusDeactivated,
968: XDP_ADAPTER.pv_statusDeactivatedSystem)
969: and xar.startup_mode in (XDP_ADAPTER.pv_startAutomatic,
970: XDP_ADAPTER.pv_startGroup,
971: XDP_ADAPTER.pv_startOnDemand)
972: and xfe.fe_id = xar.fe_id

Line 969: and xar.startup_mode in (XDP_ADAPTER.pv_startAutomatic,

965: XDP_ADAPTER.pv_statusStoppedError,
966: XDP_ADAPTER.pv_statusTerminated,
967: XDP_ADAPTER.pv_statusDeactivated,
968: XDP_ADAPTER.pv_statusDeactivatedSystem)
969: and xar.startup_mode in (XDP_ADAPTER.pv_startAutomatic,
970: XDP_ADAPTER.pv_startGroup,
971: XDP_ADAPTER.pv_startOnDemand)
972: and xfe.fe_id = xar.fe_id
973: order by xfe.fulfillment_element_name;

Line 970: XDP_ADAPTER.pv_startGroup,

966: XDP_ADAPTER.pv_statusTerminated,
967: XDP_ADAPTER.pv_statusDeactivated,
968: XDP_ADAPTER.pv_statusDeactivatedSystem)
969: and xar.startup_mode in (XDP_ADAPTER.pv_startAutomatic,
970: XDP_ADAPTER.pv_startGroup,
971: XDP_ADAPTER.pv_startOnDemand)
972: and xfe.fe_id = xar.fe_id
973: order by xfe.fulfillment_element_name;
974:

Line 971: XDP_ADAPTER.pv_startOnDemand)

967: XDP_ADAPTER.pv_statusDeactivated,
968: XDP_ADAPTER.pv_statusDeactivatedSystem)
969: and xar.startup_mode in (XDP_ADAPTER.pv_startAutomatic,
970: XDP_ADAPTER.pv_startGroup,
971: XDP_ADAPTER.pv_startOnDemand)
972: and xfe.fe_id = xar.fe_id
973: order by xfe.fulfillment_element_name;
974:
975: l_temp_fe_name VARCHAR2(2000);

Line 986: XDP_ADAPTER.Verify_All_Adapters ( p_retcode => retCode,

982: l_ServiceInstanceStartedQ SERVICE_INSTANCE_REQS_TAB;
983:
984: BEGIN
985: -- Verify / reset running adapters silently
986: XDP_ADAPTER.Verify_All_Adapters ( p_retcode => retCode,
987: p_errbuf => errbuf);
988:
989: l_retCode := TRUE;
990: retcode := 0;

Line 1127: if v_AdapterData.startup_mode = XDP_ADAPTER.pv_startOnDemand then

1123: end if;
1124:
1125: if l_StartThisAdapter = TRUE then
1126:
1127: if v_AdapterData.startup_mode = XDP_ADAPTER.pv_startOnDemand then
1128:
1129:
1130: if (v_AdapterData.adapter_status = XDP_ADAPTER.pv_statusDeactivatedSystem) then
1131:

Line 1130: if (v_AdapterData.adapter_status = XDP_ADAPTER.pv_statusDeactivatedSystem) then

1126:
1127: if v_AdapterData.startup_mode = XDP_ADAPTER.pv_startOnDemand then
1128:
1129:
1130: if (v_AdapterData.adapter_status = XDP_ADAPTER.pv_statusDeactivatedSystem) then
1131:
1132: -- Reset the error count and adapter status of the DeactivatedSystem StartOnDemand Adapter
1133: XDP_ADAPTER.Reset_SysDeactivated_Adapter (
1134: p_ChannelName => v_AdapterData.channel_name);

Line 1133: XDP_ADAPTER.Reset_SysDeactivated_Adapter (

1129:
1130: if (v_AdapterData.adapter_status = XDP_ADAPTER.pv_statusDeactivatedSystem) then
1131:
1132: -- Reset the error count and adapter status of the DeactivatedSystem StartOnDemand Adapter
1133: XDP_ADAPTER.Reset_SysDeactivated_Adapter (
1134: p_ChannelName => v_AdapterData.channel_name);
1135: FND_FILE.put_line(FND_FILE.log,
1136: 'Restart count and status of Start-on-demand Adapter '||
1137: v_AdapterData.adapter_display_name||

Line 1142: XDP_ADAPTER.Reset_SysDeactivated_Adapter (

1138: ' successfully reinitialized');
1139:
1140: else
1141: -- Reset the error count of the StartOnDemand Adapter
1142: XDP_ADAPTER.Reset_SysDeactivated_Adapter (
1143: p_ChannelName => v_AdapterData.channel_name,
1144: p_ResetStatusFlag => false);
1145:
1146: FND_FILE.put_line(FND_FILE.log,

Line 1162: XDP_ADAPTER.START_ADAPTER (

1158: v_AdapterData.adapter_display_name||
1159: ': associated with FE :'||
1160: v_AdapterData.fulfillment_element_name||':');
1161:
1162: XDP_ADAPTER.START_ADAPTER (
1163: p_ChannelName => v_AdapterData.channel_name,
1164: p_retcode => retcode,
1165: p_errbuf => errbuf);
1166: