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 dependencies on FND_LOG

Line 57: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

53: e_AdapterConfigNA EXCEPTION;
54: l_count number := 0;
55:
56: begin
57: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
58: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.CREATE_ADAPTER',
59: 'BEGIN:p_AdapterDispName: '||p_AdapterDispName);
60: end if;
61: p_retcode := 0;

Line 58: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.CREATE_ADAPTER',

54: l_count number := 0;
55:
56: begin
57: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
58: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.CREATE_ADAPTER',
59: 'BEGIN:p_AdapterDispName: '||p_AdapterDispName);
60: end if;
61: p_retcode := 0;
62: p_errbuf := '';

Line 81: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

77: if p_FeName is null or
78: p_AdapterType is null or
79: p_AdapterDispName is null or
80: p_ConcQID is null then
81: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
82: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
83: 'Required parameters are not passed');
84: end if;
85: raise e_RequiredInputDataNotPassed;

Line 82: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

78: p_AdapterType is null or
79: p_AdapterDispName is null or
80: p_ConcQID is null then
81: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
82: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
83: 'Required parameters are not passed');
84: end if;
85: raise e_RequiredInputDataNotPassed;
86: end if;

Line 161: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

157: if l_GenCountActive > 0 then
158: l_StartStatus := pv_statusStopped;
159: else
160: l_StartStatus := pv_statusNotAvailable;
161: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
162: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_ADAPTER.CREATE_ADAPTER',
163: 'Adapter is not available');
164: end if;
165: end if;

Line 162: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_ADAPTER.CREATE_ADAPTER',

158: l_StartStatus := pv_statusStopped;
159: else
160: l_StartStatus := pv_statusNotAvailable;
161: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
162: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_ADAPTER.CREATE_ADAPTER',
163: 'Adapter is not available');
164: end if;
165: end if;
166: end if;

Line 169: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

165: end if;
166: end if;
167:
168: XDP_ADAPTER_CORE_DB.CreateNewAdapterChannel(p_FeName, l_ChannelName);
169: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
170: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_ADAPTER.CREATE_ADAPTER',
171: 'Channel name is: '||l_ChannelName);
172: end if;
173:

Line 170: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_ADAPTER.CREATE_ADAPTER',

166: end if;
167:
168: XDP_ADAPTER_CORE_DB.CreateNewAdapterChannel(p_FeName, l_ChannelName);
169: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
170: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_ADAPTER.CREATE_ADAPTER',
171: 'Channel name is: '||l_ChannelName);
172: end if;
173:
174: -- Fill in the Consumer Name

Line 208: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

204: p_retCode := pv_retAdapterOtherError;
205: FND_MESSAGE.CLEAR;
206: fnd_message.set_name('FND','UNIQUE-DUPLICATE NAME');
207: p_errbuf := FND_MESSAGE.GET;
208: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
209: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
210: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
211: end if;
212: when e_NoGenericExists then

Line 209: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

205: FND_MESSAGE.CLEAR;
206: fnd_message.set_name('FND','UNIQUE-DUPLICATE NAME');
207: p_errbuf := FND_MESSAGE.GET;
208: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
209: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
210: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
211: end if;
212: when e_NoGenericExists then
213: p_retCode := pv_retAdapterNoGenExists;

Line 217: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

213: p_retCode := pv_retAdapterNoGenExists;
214: FND_MESSAGE.CLEAR;
215: fnd_message.set_name('XDP','XDP_ADAPTER_NO_SW_GEN_EXISTS');
216: p_errbuf := FND_MESSAGE.GET;
217: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
218: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
219: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
220: end if;
221: when e_AdapterConfigNA then

Line 218: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

214: FND_MESSAGE.CLEAR;
215: fnd_message.set_name('XDP','XDP_ADAPTER_NO_SW_GEN_EXISTS');
216: p_errbuf := FND_MESSAGE.GET;
217: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
218: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
219: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
220: end if;
221: when e_AdapterConfigNA then
222: p_retCode := pv_retAdapterConfigNA;

Line 227: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

223: FND_MESSAGE.CLEAR;
224: fnd_message.set_name('XDP','XDP_ADAPTER_NOT_CONFIGURABLE');
225: fnd_message.set_token('OPERATION', 'Create');
226: p_errbuf := FND_MESSAGE.GET;
227: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
228: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
229: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
230: end if;
231: --when e_AsyncParamWrong then

Line 228: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

224: fnd_message.set_name('XDP','XDP_ADAPTER_NOT_CONFIGURABLE');
225: fnd_message.set_token('OPERATION', 'Create');
226: p_errbuf := FND_MESSAGE.GET;
227: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
228: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
229: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
230: end if;
231: --when e_AsyncParamWrong then
232: -- p_retCode := pv_retAdapterAsyncParamWrong;

Line 236: -- FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

232: -- p_retCode := pv_retAdapterAsyncParamWrong;
233: -- FND_MESSAGE.CLEAR;
234: -- fnd_message.set_name('XDP','XDP_ADAPTER_ASYNC_PARAM_WRONG');
235: -- p_errbuf := FND_MESSAGE.GET;
236: -- FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
237: -- 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
238: when e_InboundParamWrong then
239: p_retCode := pv_retAdapterInboundParamWrong;
240: FND_MESSAGE.CLEAR;

Line 243: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

239: p_retCode := pv_retAdapterInboundParamWrong;
240: FND_MESSAGE.CLEAR;
241: fnd_message.set_name('XDP','XDP_ADAPTER_INBND_PARAM_WRONG');
242: p_errbuf := FND_MESSAGE.GET;
243: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
244: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
245: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
246: end if;
247: when e_ImplParamWrong then

Line 244: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

240: FND_MESSAGE.CLEAR;
241: fnd_message.set_name('XDP','XDP_ADAPTER_INBND_PARAM_WRONG');
242: p_errbuf := FND_MESSAGE.GET;
243: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
244: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
245: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
246: end if;
247: when e_ImplParamWrong then
248: p_retCode := pv_retAdapterImplParamWrong;

Line 252: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

248: p_retCode := pv_retAdapterImplParamWrong;
249: FND_MESSAGE.CLEAR;
250: fnd_message.set_name('XDP','XDP_ADAPTER_IMPL_PARAM_WRONG');
251: p_errbuf := FND_MESSAGE.GET;
252: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
253: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
254: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
255: end if;
256: when e_ConnParamWrong then

Line 253: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

249: FND_MESSAGE.CLEAR;
250: fnd_message.set_name('XDP','XDP_ADAPTER_IMPL_PARAM_WRONG');
251: p_errbuf := FND_MESSAGE.GET;
252: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
253: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
254: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
255: end if;
256: when e_ConnParamWrong then
257: p_retCode := pv_retAdapterConnParamWrong;

Line 261: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

257: p_retCode := pv_retAdapterConnParamWrong;
258: FND_MESSAGE.CLEAR;
259: fnd_message.set_name('XDP','XDP_ADAPTER_CONN_PARAM_WRONG');
260: p_errbuf := FND_MESSAGE.GET;
261: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
262: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
263: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
264: end if;
265: when others then

Line 262: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

258: FND_MESSAGE.CLEAR;
259: fnd_message.set_name('XDP','XDP_ADAPTER_CONN_PARAM_WRONG');
260: p_errbuf := FND_MESSAGE.GET;
261: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
262: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
263: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
264: end if;
265: when others then
266: if SQLCODE <> 0 then

Line 273: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

269: else
270: p_retCode := pv_retAdapterOtherError;
271: p_errbuf := 'Other non-SQL error';
272: END IF;
273: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
274: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
275: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
276: end if;
277: end Create_Adapter;

Line 274: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

270: p_retCode := pv_retAdapterOtherError;
271: p_errbuf := 'Other non-SQL error';
272: END IF;
273: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
274: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
275: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
276: end if;
277: end Create_Adapter;
278:

Line 313: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

309:
310: l_count number := 0;
311:
312: BEGIN
313: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
314: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.UPDATE_ADAPTER',
315: 'BEGIN:p_ChannelName: '||p_ChannelName);
316: end if;
317: p_retcode := 0;

Line 314: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.UPDATE_ADAPTER',

310: l_count number := 0;
311:
312: BEGIN
313: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
314: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.UPDATE_ADAPTER',
315: 'BEGIN:p_ChannelName: '||p_ChannelName);
316: end if;
317: p_retcode := 0;
318: p_errbuf := '';

Line 330: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

326: END IF;
327: -- **********
328:
329: if p_ChannelName is null then
330: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
331: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
332: 'Required parameters are not passed');
333: end if;
334: raise e_RequiredInputDataNotPassed;

Line 331: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',

327: -- **********
328:
329: if p_ChannelName is null then
330: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
331: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
332: 'Required parameters are not passed');
333: end if;
334: raise e_RequiredInputDataNotPassed;
335: end if;

Line 426: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

422: p_CmdLineArgs => p_CmdLineArgs
423: );
424:
425: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
426: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
427: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',
428: 'Could not release the lock, Channel name: '||p_ChannelName);
429: end if;
430: end if;

Line 427: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',

423: );
424:
425: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
426: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
427: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',
428: 'Could not release the lock, Channel name: '||p_ChannelName);
429: end if;
430: end if;
431:

Line 436: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

432: exception
433: when e_DisplayNameNotUnique then
434: if l_AdapterLocked = 'Y' then
435: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
436: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
437: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',
438: 'Could not release the lock, Channel name: '||p_ChannelName);
439: end if;
440: end if;

Line 437: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',

433: when e_DisplayNameNotUnique then
434: if l_AdapterLocked = 'Y' then
435: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
436: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
437: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',
438: 'Could not release the lock, Channel name: '||p_ChannelName);
439: end if;
440: end if;
441: end if;

Line 446: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

442: p_retCode := pv_retAdapterOtherError;
443: FND_MESSAGE.CLEAR;
444: fnd_message.set_name('FND','UNIQUE-DUPLICATE NAME');
445: p_errbuf := FND_MESSAGE.GET;
446: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
447: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
448: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
449: end if;
450: when e_InvalidAdapterState then

Line 447: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',

443: FND_MESSAGE.CLEAR;
444: fnd_message.set_name('FND','UNIQUE-DUPLICATE NAME');
445: p_errbuf := FND_MESSAGE.GET;
446: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
447: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
448: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
449: end if;
450: when e_InvalidAdapterState then
451: p_retCode := pv_retAdapterInvalidState;

Line 455: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

451: p_retCode := pv_retAdapterInvalidState;
452: FND_MESSAGE.CLEAR;
453: fnd_message.set_name('XDP','XDP_INVALID_ADAPTER_STATE');
454: p_errbuf := FND_MESSAGE.GET;
455: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
456: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
457: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
458: end if;
459: when e_UnabletoLockAdapter then

Line 456: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',

452: FND_MESSAGE.CLEAR;
453: fnd_message.set_name('XDP','XDP_INVALID_ADAPTER_STATE');
454: p_errbuf := FND_MESSAGE.GET;
455: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
456: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
457: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
458: end if;
459: when e_UnabletoLockAdapter then
460: p_retCode := pv_retAdapterCannotLock;

Line 464: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

460: p_retCode := pv_retAdapterCannotLock;
461: FND_MESSAGE.CLEAR;
462: fnd_message.set_name('XDP','XDP_ADAPTER_UNLOCKABLE');
463: p_errbuf := FND_MESSAGE.GET;
464: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
465: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
466: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
467: end if;
468: when e_AdapterConfigNA then

Line 465: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',

461: FND_MESSAGE.CLEAR;
462: fnd_message.set_name('XDP','XDP_ADAPTER_UNLOCKABLE');
463: p_errbuf := FND_MESSAGE.GET;
464: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
465: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
466: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
467: end if;
468: when e_AdapterConfigNA then
469: p_retCode := pv_retAdapterConfigNA;

Line 474: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

470: FND_MESSAGE.CLEAR;
471: fnd_message.set_name('XDP','XDP_ADAPTER_NOT_CONFIGURABLE');
472: fnd_message.set_token('OPERATION', 'Update');
473: p_errbuf := FND_MESSAGE.GET;
474: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
475: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
476: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
477: end if;
478: when e_ImplParamWrong then

Line 475: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

471: fnd_message.set_name('XDP','XDP_ADAPTER_NOT_CONFIGURABLE');
472: fnd_message.set_token('OPERATION', 'Update');
473: p_errbuf := FND_MESSAGE.GET;
474: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
475: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
476: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
477: end if;
478: when e_ImplParamWrong then
479: p_retCode := pv_retAdapterImplParamWrong;

Line 483: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

479: p_retCode := pv_retAdapterImplParamWrong;
480: FND_MESSAGE.CLEAR;
481: fnd_message.set_name('XDP','XDP_ADAPTER_IMPL_PARAM_WRONG');
482: p_errbuf := FND_MESSAGE.GET;
483: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
484: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
485: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
486: end if;
487: when e_InboundParamWrong then

Line 484: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

480: FND_MESSAGE.CLEAR;
481: fnd_message.set_name('XDP','XDP_ADAPTER_IMPL_PARAM_WRONG');
482: p_errbuf := FND_MESSAGE.GET;
483: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
484: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
485: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
486: end if;
487: when e_InboundParamWrong then
488: p_retCode := pv_retAdapterInboundParamWrong;

Line 492: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

488: p_retCode := pv_retAdapterInboundParamWrong;
489: FND_MESSAGE.CLEAR;
490: fnd_message.set_name('XDP','XDP_ADAPTER_INBND_PARAM_WRONG');
491: p_errbuf := FND_MESSAGE.GET;
492: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
493: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
494: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
495: end if;
496: when e_ConnParamWrong then

Line 493: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

489: FND_MESSAGE.CLEAR;
490: fnd_message.set_name('XDP','XDP_ADAPTER_INBND_PARAM_WRONG');
491: p_errbuf := FND_MESSAGE.GET;
492: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
493: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
494: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
495: end if;
496: when e_ConnParamWrong then
497: p_retCode := pv_retAdapterConnParamWrong;

Line 501: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

497: p_retCode := pv_retAdapterConnParamWrong;
498: FND_MESSAGE.CLEAR;
499: fnd_message.set_name('XDP','XDP_ADAPTER_CONN_PARAM_WRONG');
500: p_errbuf := FND_MESSAGE.GET;
501: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
502: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
503: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
504: end if;
505: when others then

Line 502: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

498: FND_MESSAGE.CLEAR;
499: fnd_message.set_name('XDP','XDP_ADAPTER_CONN_PARAM_WRONG');
500: p_errbuf := FND_MESSAGE.GET;
501: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
502: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
503: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
504: end if;
505: when others then
506: if l_AdapterLocked = 'Y' then

Line 508: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

504: end if;
505: when others then
506: if l_AdapterLocked = 'Y' then
507: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
508: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
509: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',
510: 'Could not release the lock, Channel name: '||p_ChannelName);
511: end if;
512: end if;

Line 509: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',

505: when others then
506: if l_AdapterLocked = 'Y' then
507: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
508: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
509: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.UPDATE_ADAPTER',
510: 'Could not release the lock, Channel name: '||p_ChannelName);
511: end if;
512: end if;
513: end if;

Line 521: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

517: else
518: p_retCode := pv_retAdapterOtherError;
519: p_errbuf := 'Other non-SQL error';
520: END IF;
521: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
522: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
523: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
524: end if;
525: END Update_Adapter;

Line 522: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',

518: p_retCode := pv_retAdapterOtherError;
519: p_errbuf := 'Other non-SQL error';
520: END IF;
521: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
522: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADAPTER',
523: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
524: end if;
525: END Update_Adapter;
526:

Line 541: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

537:
538: e_AdapterConfigNA EXCEPTION;
539:
540: begin
541: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
542: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ADAPTER',
543: 'BEGIN:p_ChannelName: '||p_ChannelName);
544: end if;
545: p_retcode := 0;

Line 542: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ADAPTER',

538: e_AdapterConfigNA EXCEPTION;
539:
540: begin
541: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
542: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ADAPTER',
543: 'BEGIN:p_ChannelName: '||p_ChannelName);
544: end if;
545: p_retcode := 0;
546: p_errbuf := '';

Line 558: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

554: END IF;
555: -- **********
556:
557: if p_ChannelName is null then
558: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
559: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
560: 'Required parameters are not passed');
561: end if;
562: raise e_RequiredInputDataNotPassed;

Line 559: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',

555: -- **********
556:
557: if p_ChannelName is null then
558: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
559: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
560: 'Required parameters are not passed');
561: end if;
562: raise e_RequiredInputDataNotPassed;
563: end if;

Line 580: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

576:
577: XDP_ADAPTER_CORE_DB.Delete_Adapter (p_channel_name => p_ChannelName);
578:
579: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
580: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
581: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DELETE_ADAPTER',
582: 'Could not release the lock, Channel name: '||p_ChannelName);
583: end if;
584: end if;

Line 581: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DELETE_ADAPTER',

577: XDP_ADAPTER_CORE_DB.Delete_Adapter (p_channel_name => p_ChannelName);
578:
579: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
580: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
581: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DELETE_ADAPTER',
582: 'Could not release the lock, Channel name: '||p_ChannelName);
583: end if;
584: end if;
585:

Line 592: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

588: p_retCode := pv_retAdapterInvalidState;
589: FND_MESSAGE.CLEAR;
590: fnd_message.set_name('XDP','XDP_INVALID_ADAPTER_STATE');
591: p_errbuf := FND_MESSAGE.GET;
592: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
593: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
594: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
595: end if;
596: when e_UnabletoLockAdapter then

Line 593: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',

589: FND_MESSAGE.CLEAR;
590: fnd_message.set_name('XDP','XDP_INVALID_ADAPTER_STATE');
591: p_errbuf := FND_MESSAGE.GET;
592: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
593: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
594: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
595: end if;
596: when e_UnabletoLockAdapter then
597: p_retCode := pv_retAdapterCannotLock;

Line 601: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

597: p_retCode := pv_retAdapterCannotLock;
598: FND_MESSAGE.CLEAR;
599: fnd_message.set_name('XDP','XDP_ADAPTER_UNLOCKABLE');
600: p_errbuf := FND_MESSAGE.GET;
601: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
602: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
603: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
604: end if;
605: when e_AdapterConfigNA then

Line 602: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',

598: FND_MESSAGE.CLEAR;
599: fnd_message.set_name('XDP','XDP_ADAPTER_UNLOCKABLE');
600: p_errbuf := FND_MESSAGE.GET;
601: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
602: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
603: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
604: end if;
605: when e_AdapterConfigNA then
606: p_retCode := pv_retAdapterConfigNA;

Line 611: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

607: FND_MESSAGE.CLEAR;
608: fnd_message.set_name('XDP','XDP_ADAPTER_NOT_CONFIGURABLE');
609: fnd_message.set_token('OPERATION', 'Delete');
610: p_errbuf := FND_MESSAGE.GET;
611: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
612: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
613: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
614: end if;
615: when others then

Line 612: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',

608: fnd_message.set_name('XDP','XDP_ADAPTER_NOT_CONFIGURABLE');
609: fnd_message.set_token('OPERATION', 'Delete');
610: p_errbuf := FND_MESSAGE.GET;
611: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
612: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADAPTER',
613: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
614: end if;
615: when others then
616: if l_AdapterLocked = 'Y' then

Line 618: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

614: end if;
615: when others then
616: if l_AdapterLocked = 'Y' then
617: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
618: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
619: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DELETE_ADAPTER',
620: 'Could not release the lock, Channel name: '||p_ChannelName);
621: end if;
622: end if;

Line 619: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DELETE_ADAPTER',

615: when others then
616: if l_AdapterLocked = 'Y' then
617: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
618: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
619: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DELETE_ADAPTER',
620: 'Could not release the lock, Channel name: '||p_ChannelName);
621: end if;
622: end if;
623: end if;

Line 631: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05

627: else
628: p_retCode := pv_retAdapterOtherError;
629: p_errbuf := 'Other non-SQL error';
630: END IF;
631: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
632: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
633: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
634: end if;
635: end Delete_Adapter;

Line 632: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',

628: p_retCode := pv_retAdapterOtherError;
629: p_errbuf := 'Other non-SQL error';
630: END IF;
631: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 27 Apr 05
632: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADAPTER',
633: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
634: end if;
635: end Delete_Adapter;
636:

Line 645: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

641: l_FeID number := -1;
642: l_Flag boolean := FALSE;
643: e_FEAdapterRunning EXCEPTION;
644: begin
645: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
646: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
647: 'BEGIN:p_FeName: '||p_FeName);
648: end if;
649: p_retcode := 0;

Line 646: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',

642: l_Flag boolean := FALSE;
643: e_FEAdapterRunning EXCEPTION;
644: begin
645: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
646: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
647: 'BEGIN:p_FeName: '||p_FeName);
648: end if;
649: p_retcode := 0;
650: p_errbuf := '';

Line 656: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

652: l_FeID := XDP_ADAPTER_CORE_DB.Get_Fe_Id_For_Name (p_FeName);
653:
654: l_Flag := XDP_ADAPTER_CORE_DB.Is_FE_Adapter_Running (p_fe_id => l_FeID);
655: if (l_Flag) then
656: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
657: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
658: 'Some adapters are running for the FE: '||p_FeName);
659: end if;
660: raise e_FEAdapterRunning;

Line 657: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',

653:
654: l_Flag := XDP_ADAPTER_CORE_DB.Is_FE_Adapter_Running (p_fe_id => l_FeID);
655: if (l_Flag) then
656: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
657: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
658: 'Some adapters are running for the FE: '||p_FeName);
659: end if;
660: raise e_FEAdapterRunning;
661: END IF;

Line 672: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

668: p_retcode := pv_retFEAdapterRunning;
669: FND_MESSAGE.CLEAR;
670: fnd_message.set_name('XDP','XDP_FE_RUNNING');
671: p_errbuf := FND_MESSAGE.GET;
672: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
673: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
674: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
675: end if;
676:

Line 673: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',

669: FND_MESSAGE.CLEAR;
670: fnd_message.set_name('XDP','XDP_FE_RUNNING');
671: p_errbuf := FND_MESSAGE.GET;
672: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
673: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
674: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
675: end if;
676:
677: when others then

Line 685: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

681: else
682: p_retCode := pv_retAdapterOtherError;
683: p_errbuf := 'Other non-SQL error';
684: END IF;
685: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
686: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
687: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
688: end if;
689: end Delete_All_For_FE;

Line 686: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',

682: p_retCode := pv_retAdapterOtherError;
683: p_errbuf := 'Other non-SQL error';
684: END IF;
685: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
686: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ALL_FOR_FE',
687: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
688: end if;
689: end Delete_All_For_FE;
690:

Line 702: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

698: l_CPID number;
699: l_ProcessID number;
700: l_CmdString varchar2(2000);
701: begin
702: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
703: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.GENERIC_OPERATION',
704: 'BEGIN:p_ChannelName: '||p_ChannelName);
705: end if;
706: p_retcode := 0;

Line 703: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.GENERIC_OPERATION',

699: l_ProcessID number;
700: l_CmdString varchar2(2000);
701: begin
702: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
703: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.GENERIC_OPERATION',
704: 'BEGIN:p_ChannelName: '||p_ChannelName);
705: end if;
706: p_retcode := 0;
707: p_errbuf := '';

Line 739: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

735: else
736: p_retCode := pv_retAdapterOtherError;
737: p_errbuf := 'Other non-SQL error';
738: END IF;
739: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
740: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.GENERIC_OPERATION',
741: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
742: end if;
743: END Generic_Operation;

Line 740: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.GENERIC_OPERATION',

736: p_retCode := pv_retAdapterOtherError;
737: p_errbuf := 'Other non-SQL error';
738: END IF;
739: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
740: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.GENERIC_OPERATION',
741: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
742: end if;
743: END Generic_Operation;
744:

Line 761: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

757: is
758: e_InvalidRequestDate EXCEPTION;
759:
760: begin
761: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
762: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
763: 'BEGIN:p_ChannelName: '||p_ChannelName);
764: end if;
765: p_retcode := 0;

Line 762: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',

758: e_InvalidRequestDate EXCEPTION;
759:
760: begin
761: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
762: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
763: 'BEGIN:p_ChannelName: '||p_ChannelName);
764: end if;
765: p_retcode := 0;
766: p_errbuf := '';

Line 769: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

765: p_retcode := 0;
766: p_errbuf := '';
767:
768: if p_ChannelName is null then
769: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
770: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
771: 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
772: 'Required parameters are not passed');
773: end if;

Line 770: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,

766: p_errbuf := '';
767:
768: if p_ChannelName is null then
769: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
770: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
771: 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
772: 'Required parameters are not passed');
773: end if;
774: raise e_RequiredInputDataNotPassed;

Line 778: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

774: raise e_RequiredInputDataNotPassed;
775: end if;
776:
777: if p_RequestDate < sysdate then
778: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
779: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
780: 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
781: 'Request date is less than the sysdate');
782: end if;

Line 779: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,

775: end if;
776:
777: if p_RequestDate < sysdate then
778: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
779: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
780: 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
781: 'Request date is less than the sysdate');
782: end if;
783: raise e_InvalidRequestDate;

Line 801: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

797: p_retcode := pv_retAdapterInvalidReqDate;
798: FND_MESSAGE.CLEAR;
799: fnd_message.set_name('XDP','XDP_SCHED_REQ_FUTURE');
800: p_errbuf := FND_MESSAGE.GET;
801: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
802: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
803: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
804: end if;
805: when others then

Line 802: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',

798: FND_MESSAGE.CLEAR;
799: fnd_message.set_name('XDP','XDP_SCHED_REQ_FUTURE');
800: p_errbuf := FND_MESSAGE.GET;
801: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
802: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
803: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
804: end if;
805: when others then
806: if SQLCODE <> 0 then

Line 813: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

809: else
810: p_retCode := pv_retAdapterOtherError;
811: p_errbuf := 'Other non-SQL error';
812: END IF;
813: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
814: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
815: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
816: end if;
817: end Create_Admin_Request;

Line 814: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',

810: p_retCode := pv_retAdapterOtherError;
811: p_errbuf := 'Other non-SQL error';
812: END IF;
813: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
814: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
815: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
816: end if;
817: end Create_Admin_Request;
818:

Line 831: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

827:
828: e_InvalidRequestDate EXCEPTION;
829:
830: begin
831: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
832: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
833: 'BEGIN:p_RequestID: '||p_RequestID);
834: end if;
835: p_retcode := 0;

Line 832: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',

828: e_InvalidRequestDate EXCEPTION;
829:
830: begin
831: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
832: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
833: 'BEGIN:p_RequestID: '||p_RequestID);
834: end if;
835: p_retcode := 0;
836: p_errbuf := '';

Line 839: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

835: p_retcode := 0;
836: p_errbuf := '';
837:
838: if p_RequestID is null then
839: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
840: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
841: 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
842: 'Required parameters are not passed');
843: end if;

Line 840: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,

836: p_errbuf := '';
837:
838: if p_RequestID is null then
839: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
840: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
841: 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
842: 'Required parameters are not passed');
843: end if;
844: raise e_RequiredInputDataNotPassed;

Line 848: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

844: raise e_RequiredInputDataNotPassed;
845: end if;
846:
847: if p_RequestDate < sysdate then
848: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
849: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
850: 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
851: 'Request date is less than the sysdate');
852: end if;

Line 849: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,

845: end if;
846:
847: if p_RequestDate < sysdate then
848: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
849: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
850: 'XDP_ADAPTER.CREATE_ADMIN_REQUEST',
851: 'Request date is less than the sysdate');
852: end if;
853: raise e_InvalidRequestDate;

Line 868: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

864: p_retcode := pv_retAdapterInvalidReqDate;
865: FND_MESSAGE.CLEAR;
866: fnd_message.set_name('XDP','XDP_SCHED_REQ_FUTURE');
867: p_errbuf := FND_MESSAGE.GET;
868: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
869: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
870: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
871: end if;
872:

Line 869: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',

865: FND_MESSAGE.CLEAR;
866: fnd_message.set_name('XDP','XDP_SCHED_REQ_FUTURE');
867: p_errbuf := FND_MESSAGE.GET;
868: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
869: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
870: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
871: end if;
872:
873: when others then

Line 881: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

877: else
878: p_retCode := pv_retAdapterOtherError;
879: p_errbuf := 'Other non-SQL error';
880: END IF;
881: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
882: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
883: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
884: end if;
885: end Update_Admin_Request;

Line 882: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',

878: p_retCode := pv_retAdapterOtherError;
879: p_errbuf := 'Other non-SQL error';
880: END IF;
881: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
882: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.UPDATE_ADMIN_REQUEST',
883: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
884: end if;
885: end Update_Admin_Request;
886:

Line 896: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

892: l_dummynum number;
893: l_dummydate date;
894: l_jobID number;
895: begin
896: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
897: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ADMIN_REQUEST',
898: 'BEGIN:p_RequestID: '||p_RequestID);
899: end if;
900: p_retcode := 0;

Line 897: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ADMIN_REQUEST',

893: l_dummydate date;
894: l_jobID number;
895: begin
896: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
897: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DELETE_ADMIN_REQUEST',
898: 'BEGIN:p_RequestID: '||p_RequestID);
899: end if;
900: p_retcode := 0;
901: p_errbuf := '';

Line 904: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

900: p_retcode := 0;
901: p_errbuf := '';
902:
903: if p_RequestID is null then
904: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
905: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
906: 'XDP_ADAPTER.DELETE_ADMIN_REQUEST',
907: 'Required parameters are not passed');
908: end if;

Line 905: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,

901: p_errbuf := '';
902:
903: if p_RequestID is null then
904: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
905: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
906: 'XDP_ADAPTER.DELETE_ADMIN_REQUEST',
907: 'Required parameters are not passed');
908: end if;
909: raise e_RequiredInputDataNotPassed;

Line 924: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

920: else
921: p_retCode := pv_retAdapterOtherError;
922: p_errbuf := 'Other non-SQL error';
923: END IF;
924: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
925: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADMIN_REQUEST',
926: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
927: end if;
928: end Delete_Admin_Request;

Line 925: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADMIN_REQUEST',

921: p_retCode := pv_retAdapterOtherError;
922: p_errbuf := 'Other non-SQL error';
923: END IF;
924: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
925: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DELETE_ADMIN_REQUEST',
926: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
927: end if;
928: end Delete_Admin_Request;
929:

Line 960: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

956: l_CurrentStatus varchar2(30);
957:
958: e_MaxAdaptersReached EXCEPTION;
959: begin
960: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
961: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.START_ADAPTER',
962: 'BEGIN:p_ChannelName: '||p_ChannelName);
963: end if;
964: p_retcode := 0;

Line 961: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.START_ADAPTER',

957:
958: e_MaxAdaptersReached EXCEPTION;
959: begin
960: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
961: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.START_ADAPTER',
962: 'BEGIN:p_ChannelName: '||p_ChannelName);
963: end if;
964: p_retcode := 0;
965: p_errbuf := '';

Line 968: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

964: p_retcode := 0;
965: p_errbuf := '';
966:
967: if p_ChannelName is null then
968: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
969: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
970: 'Required parameters are not passed');
971: end if;
972: raise e_RequiredInputDataNotPassed;

Line 969: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',

965: p_errbuf := '';
966:
967: if p_ChannelName is null then
968: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
969: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
970: 'Required parameters are not passed');
971: end if;
972: raise e_RequiredInputDataNotPassed;
973: end if;

Line 1006: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1002:
1003: l_Flag := XDP_ADAPTER_CORE_DB.Is_Max_Connection_Reached (l_FeID);
1004: if (l_Flag = FALSE) then
1005: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1006: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1007: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',
1008: 'Could not release the lock, Channel name: '||p_ChannelName);
1009: end if;
1010: end if;

Line 1007: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',

1003: l_Flag := XDP_ADAPTER_CORE_DB.Is_Max_Connection_Reached (l_FeID);
1004: if (l_Flag = FALSE) then
1005: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1006: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1007: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',
1008: 'Could not release the lock, Channel name: '||p_ChannelName);
1009: end if;
1010: end if;
1011:

Line 1037: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1033:
1034: XDP_CONTROLLER_CORE.VerifyControllerStatus(l_ConcQID, l_CPID, l_ControllerFlag);
1035: if l_ControllerFlag = 'N' then
1036: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1037: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1038: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',
1039: 'Could not release the lock, Channel name: '||p_ChannelName);
1040: end if;
1041: end if;

Line 1038: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',

1034: XDP_CONTROLLER_CORE.VerifyControllerStatus(l_ConcQID, l_CPID, l_ControllerFlag);
1035: if l_ControllerFlag = 'N' then
1036: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1037: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1038: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',
1039: 'Could not release the lock, Channel name: '||p_ChannelName);
1040: end if;
1041: end if;
1042:

Line 1082: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1078: END IF;
1079: END IF;
1080:
1081: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1082: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1083: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',
1084: 'Could not release the lock, Channel name: '||p_ChannelName);
1085: end if;
1086: end if;

Line 1083: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',

1079: END IF;
1080:
1081: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1082: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1083: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',
1084: 'Could not release the lock, Channel name: '||p_ChannelName);
1085: end if;
1086: end if;
1087:

Line 1094: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1090: p_retcode := pv_retAdapterMaxNumReached;
1091: FND_MESSAGE.CLEAR;
1092: fnd_message.set_name('XDP','XDP_MAX_NUM_CONN');
1093: p_errbuf := FND_MESSAGE.GET;
1094: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1095: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
1096: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1097: end if;
1098: when e_InvalidAdapterState then

Line 1095: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',

1091: FND_MESSAGE.CLEAR;
1092: fnd_message.set_name('XDP','XDP_MAX_NUM_CONN');
1093: p_errbuf := FND_MESSAGE.GET;
1094: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1095: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
1096: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1097: end if;
1098: when e_InvalidAdapterState then
1099: p_retCode := pv_retAdapterInvalidState;

Line 1103: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1099: p_retCode := pv_retAdapterInvalidState;
1100: FND_MESSAGE.CLEAR;
1101: fnd_message.set_name('XDP','XDP_INVALID_ADAPTER_STATE');
1102: p_errbuf := FND_MESSAGE.GET;
1103: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1104: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
1105: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1106: end if;
1107: when e_UnabletoLockAdapter then

Line 1104: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',

1100: FND_MESSAGE.CLEAR;
1101: fnd_message.set_name('XDP','XDP_INVALID_ADAPTER_STATE');
1102: p_errbuf := FND_MESSAGE.GET;
1103: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1104: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
1105: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1106: end if;
1107: when e_UnabletoLockAdapter then
1108: p_retCode := pv_retAdapterCannotLock;

Line 1112: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1108: p_retCode := pv_retAdapterCannotLock;
1109: FND_MESSAGE.CLEAR;
1110: fnd_message.set_name('XDP','XDP_ADAPTER_UNLOCKABLE');
1111: p_errbuf := FND_MESSAGE.GET;
1112: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1113: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
1114: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1115: end if;
1116: when e_ControllerNotRunning then

Line 1113: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',

1109: FND_MESSAGE.CLEAR;
1110: fnd_message.set_name('XDP','XDP_ADAPTER_UNLOCKABLE');
1111: p_errbuf := FND_MESSAGE.GET;
1112: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1113: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
1114: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1115: end if;
1116: when e_ControllerNotRunning then
1117: p_retCode := pv_retAdapterCtrlNotRunning;

Line 1121: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1117: p_retCode := pv_retAdapterCtrlNotRunning;
1118: FND_MESSAGE.CLEAR;
1119: fnd_message.set_name('XDP','XDP_CONTROLLER_NOT_RUNNING');
1120: p_errbuf := FND_MESSAGE.GET;
1121: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1122: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
1123: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1124: end if;
1125: when others then

Line 1122: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',

1118: FND_MESSAGE.CLEAR;
1119: fnd_message.set_name('XDP','XDP_CONTROLLER_NOT_RUNNING');
1120: p_errbuf := FND_MESSAGE.GET;
1121: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1122: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
1123: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1124: end if;
1125: when others then
1126: if l_AdapterLocked = 'Y' then

Line 1128: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1124: end if;
1125: when others then
1126: if l_AdapterLocked = 'Y' then
1127: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1128: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1129: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',
1130: 'Could not release the lock, Channel name: '||p_ChannelName);
1131: end if;
1132: end if;

Line 1129: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',

1125: when others then
1126: if l_AdapterLocked = 'Y' then
1127: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1128: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1129: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.START_ADAPTER',
1130: 'Could not release the lock, Channel name: '||p_ChannelName);
1131: end if;
1132: end if;
1133: end if;

Line 1141: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1137: else
1138: p_retCode := pv_retAdapterOtherError;
1139: p_errbuf := 'Other non-SQL error';
1140: END IF;
1141: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1142: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
1143: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1144: end if;
1145: End Start_Adapter;

Line 1142: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',

1138: p_retCode := pv_retAdapterOtherError;
1139: p_errbuf := 'Other non-SQL error';
1140: END IF;
1141: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1142: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.START_ADAPTER',
1143: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1144: end if;
1145: End Start_Adapter;
1146:

Line 1158: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1154: l_CPID number;
1155: l_ProcessID number;
1156: l_CmdString varchar2(2000);
1157: begin
1158: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.STOP_ADAPTER',
1160: 'BEGIN:p_ChannelName: '||p_ChannelName);
1161: end if;
1162: p_retcode := 0;

Line 1159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.STOP_ADAPTER',

1155: l_ProcessID number;
1156: l_CmdString varchar2(2000);
1157: begin
1158: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.STOP_ADAPTER',
1160: 'BEGIN:p_ChannelName: '||p_ChannelName);
1161: end if;
1162: p_retcode := 0;
1163: p_errbuf := '';

Line 1238: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1234:
1235: end if;
1236:
1237: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1238: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1239: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.STOP_ADAPTER',
1240: 'Could not release the lock, Channel name: '||p_ChannelName);
1241: end if;
1242: end if;

Line 1239: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.STOP_ADAPTER',

1235: end if;
1236:
1237: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1238: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1239: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.STOP_ADAPTER',
1240: 'Could not release the lock, Channel name: '||p_ChannelName);
1241: end if;
1242: end if;
1243:

Line 1252: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1248: FND_MESSAGE.CLEAR;
1249: fnd_message.set_name('XDP','XDP_ADAPTER_UNLOCKABLE_REQ_SUB');
1250: fnd_message.set_token('JOB_ID', l_JobID);
1251: p_errbuf := FND_MESSAGE.GET;
1252: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1253: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.STOP_ADAPTER',
1254: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1255: end if;
1256: when others then

Line 1253: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.STOP_ADAPTER',

1249: fnd_message.set_name('XDP','XDP_ADAPTER_UNLOCKABLE_REQ_SUB');
1250: fnd_message.set_token('JOB_ID', l_JobID);
1251: p_errbuf := FND_MESSAGE.GET;
1252: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1253: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.STOP_ADAPTER',
1254: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1255: end if;
1256: when others then
1257: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then

Line 1258: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1254: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1255: end if;
1256: when others then
1257: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1258: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1259: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.STOP_ADAPTER',
1260: 'Could not release the lock, Channel name: '||p_ChannelName);
1261: end if;
1262: end if;

Line 1259: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.STOP_ADAPTER',

1255: end if;
1256: when others then
1257: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1258: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1259: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.STOP_ADAPTER',
1260: 'Could not release the lock, Channel name: '||p_ChannelName);
1261: end if;
1262: end if;
1263: if SQLCODE <> 0 then

Line 1270: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1266: else
1267: p_retCode := pv_retAdapterOtherError;
1268: p_errbuf := 'Other non-SQL error';
1269: END IF;
1270: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1271: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.STOP_ADAPTER',
1272: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1273: end if;
1274: end Stop_Adapter;

Line 1271: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.STOP_ADAPTER',

1267: p_retCode := pv_retAdapterOtherError;
1268: p_errbuf := 'Other non-SQL error';
1269: END IF;
1270: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1271: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.STOP_ADAPTER',
1272: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1273: end if;
1274: end Stop_Adapter;
1275:

Line 1285: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1281: l_CPID number;
1282: l_ProcessID number;
1283: l_CmdString varchar2(2000);
1284: begin
1285: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1286: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.SUSPEND_ADAPTER',
1287: 'BEGIN:p_ChannelName: '||p_ChannelName);
1288: end if;
1289: p_retcode := 0;

Line 1286: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.SUSPEND_ADAPTER',

1282: l_ProcessID number;
1283: l_CmdString varchar2(2000);
1284: begin
1285: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1286: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.SUSPEND_ADAPTER',
1287: 'BEGIN:p_ChannelName: '||p_ChannelName);
1288: end if;
1289: p_retcode := 0;
1290: p_errbuf := '';

Line 1320: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1316: p_Status => pv_statusSuspended);
1317: end if;
1318:
1319: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1320: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1321: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.SUSPEND_ADAPTER',
1322: 'Could not release the lock, Channel name: '||p_ChannelName);
1323: end if;
1324: end if;

Line 1321: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.SUSPEND_ADAPTER',

1317: end if;
1318:
1319: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1320: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1321: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.SUSPEND_ADAPTER',
1322: 'Could not release the lock, Channel name: '||p_ChannelName);
1323: end if;
1324: end if;
1325:

Line 1330: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1326: exception
1327:
1328: when others then
1329: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1330: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1331: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.SUSPEND_ADAPTER',
1332: 'Could not release the lock, Channel name: '||p_ChannelName);
1333: end if;
1334: end if;

Line 1331: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.SUSPEND_ADAPTER',

1327:
1328: when others then
1329: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1330: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1331: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.SUSPEND_ADAPTER',
1332: 'Could not release the lock, Channel name: '||p_ChannelName);
1333: end if;
1334: end if;
1335: if SQLCODE <> 0 then

Line 1342: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1338: else
1339: p_retCode := pv_retAdapterOtherError;
1340: p_errbuf := 'Other non-SQL error';
1341: END IF;
1342: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1343: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.SUSPEND_ADAPTER',
1344: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1345: end if;
1346: end Suspend_Adapter;

Line 1343: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.SUSPEND_ADAPTER',

1339: p_retCode := pv_retAdapterOtherError;
1340: p_errbuf := 'Other non-SQL error';
1341: END IF;
1342: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1343: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.SUSPEND_ADAPTER',
1344: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1345: end if;
1346: end Suspend_Adapter;
1347:

Line 1357: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1353: l_CPID number;
1354: l_ProcessID number;
1355: l_CmdString varchar2(2000);
1356: begin
1357: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1358: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.RESUME_ADAPTER',
1359: 'BEGIN:p_ChannelName: '||p_ChannelName);
1360: end if;
1361: p_retcode := 0;

Line 1358: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.RESUME_ADAPTER',

1354: l_ProcessID number;
1355: l_CmdString varchar2(2000);
1356: begin
1357: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1358: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.RESUME_ADAPTER',
1359: 'BEGIN:p_ChannelName: '||p_ChannelName);
1360: end if;
1361: p_retcode := 0;
1362: p_errbuf := '';

Line 1401: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1397: ErrStr => p_errbuf);
1398: end if;
1399:
1400: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1401: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1402: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESUME_ADAPTER',
1403: 'Could not release the lock, Channel name: '||p_ChannelName);
1404: end if;
1405: end if;

Line 1402: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESUME_ADAPTER',

1398: end if;
1399:
1400: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1401: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1402: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESUME_ADAPTER',
1403: 'Could not release the lock, Channel name: '||p_ChannelName);
1404: end if;
1405: end if;
1406:

Line 1411: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1407: exception
1408:
1409: when others then
1410: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1411: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1412: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESUME_ADAPTER',
1413: 'Could not release the lock, Channel name: '||p_ChannelName);
1414: end if;
1415: end if;

Line 1412: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESUME_ADAPTER',

1408:
1409: when others then
1410: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1411: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1412: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESUME_ADAPTER',
1413: 'Could not release the lock, Channel name: '||p_ChannelName);
1414: end if;
1415: end if;
1416: if SQLCODE <> 0 then

Line 1423: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1419: else
1420: p_retCode := pv_retAdapterOtherError;
1421: p_errbuf := 'Other non-SQL error';
1422: END IF;
1423: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1424: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.RESUME_ADAPTER',
1425: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1426: end if;
1427: end Resume_Adapter;

Line 1424: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.RESUME_ADAPTER',

1420: p_retCode := pv_retAdapterOtherError;
1421: p_errbuf := 'Other non-SQL error';
1422: END IF;
1423: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1424: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.RESUME_ADAPTER',
1425: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1426: end if;
1427: end Resume_Adapter;
1428:

Line 1439: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1435: l_ProcessID number;
1436: l_CmdString varchar2(2000);
1437:
1438: begin
1439: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1440: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.CONNECT_ADAPTER',
1441: 'BEGIN:p_ChannelName: '||p_ChannelName);
1442: end if;
1443: p_retcode := 0;

Line 1440: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.CONNECT_ADAPTER',

1436: l_CmdString varchar2(2000);
1437:
1438: begin
1439: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1440: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.CONNECT_ADAPTER',
1441: 'BEGIN:p_ChannelName: '||p_ChannelName);
1442: end if;
1443: p_retcode := 0;
1444: p_errbuf := '';

Line 1483: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1479: ErrStr => p_errbuf);
1480: end if;
1481:
1482: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1483: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1484: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.CONNECT_ADAPTER',
1485: 'Could not release the lock, Channel name: '||p_ChannelName);
1486: end if;
1487: end if;

Line 1484: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.CONNECT_ADAPTER',

1480: end if;
1481:
1482: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1483: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1484: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.CONNECT_ADAPTER',
1485: 'Could not release the lock, Channel name: '||p_ChannelName);
1486: end if;
1487: end if;
1488:

Line 1493: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1489: exception
1490:
1491: when others then
1492: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1493: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1494: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.CONNECT_ADAPTER',
1495: 'Could not release the lock, Channel name: '||p_ChannelName);
1496: end if;
1497: end if;

Line 1494: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.CONNECT_ADAPTER',

1490:
1491: when others then
1492: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1493: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1494: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.CONNECT_ADAPTER',
1495: 'Could not release the lock, Channel name: '||p_ChannelName);
1496: end if;
1497: end if;
1498: if SQLCODE <> 0 then

Line 1505: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1501: else
1502: p_retCode := pv_retAdapterOtherError;
1503: p_errbuf := 'Other non-SQL error';
1504: END IF;
1505: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1506: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CONNECT_ADAPTER',
1507: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1508: end if;
1509: end Connect_Adapter;

Line 1506: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CONNECT_ADAPTER',

1502: p_retCode := pv_retAdapterOtherError;
1503: p_errbuf := 'Other non-SQL error';
1504: END IF;
1505: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1506: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.CONNECT_ADAPTER',
1507: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1508: end if;
1509: end Connect_Adapter;
1510:

Line 1520: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1516: l_CPID number;
1517: l_ProcessID number;
1518: l_CmdString varchar2(2000);
1519: begin
1520: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1521: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DISCONNECT_ADAPTER',
1522: 'BEGIN:p_ChannelName: '||p_ChannelName);
1523: end if;
1524: p_retcode := 0;

Line 1521: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DISCONNECT_ADAPTER',

1517: l_ProcessID number;
1518: l_CmdString varchar2(2000);
1519: begin
1520: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1521: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.DISCONNECT_ADAPTER',
1522: 'BEGIN:p_ChannelName: '||p_ChannelName);
1523: end if;
1524: p_retcode := 0;
1525: p_errbuf := '';

Line 1555: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1551: p_Status => pv_statusDisconnected);
1552: end if;
1553:
1554: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1555: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1556: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DISCONNECT_ADAPTER',
1557: 'Could not release the lock, Channel name: '||p_ChannelName);
1558: end if;
1559: end if;

Line 1556: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DISCONNECT_ADAPTER',

1552: end if;
1553:
1554: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1555: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1556: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DISCONNECT_ADAPTER',
1557: 'Could not release the lock, Channel name: '||p_ChannelName);
1558: end if;
1559: end if;
1560:

Line 1565: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1561: exception
1562:
1563: when others then
1564: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1565: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1566: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DISCONNECT_ADAPTER',
1567: 'Could not release the lock, Channel name: '||p_ChannelName);
1568: end if;
1569: end if;

Line 1566: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DISCONNECT_ADAPTER',

1562:
1563: when others then
1564: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1565: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1566: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.DISCONNECT_ADAPTER',
1567: 'Could not release the lock, Channel name: '||p_ChannelName);
1568: end if;
1569: end if;
1570: if SQLCODE <> 0 then

Line 1577: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1573: else
1574: p_retCode := pv_retAdapterOtherError;
1575: p_errbuf := 'Other non-SQL error';
1576: END IF;
1577: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1578: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DISCONNECT_ADAPTER',
1579: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1580: end if;
1581: end Disconnect_Adapter;

Line 1578: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DISCONNECT_ADAPTER',

1574: p_retCode := pv_retAdapterOtherError;
1575: p_errbuf := 'Other non-SQL error';
1576: END IF;
1577: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1578: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.DISCONNECT_ADAPTER',
1579: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1580: end if;
1581: end Disconnect_Adapter;
1582:

Line 1593: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1589: l_CPID number;
1590: l_CmdString varchar2(2000);
1591: l_ProcessID number;
1592: begin
1593: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1594: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.TERMINATE_ADAPTER',
1595: 'BEGIN:p_ChannelName: '||p_ChannelName);
1596: end if;
1597: p_retcode := 0;

Line 1594: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.TERMINATE_ADAPTER',

1590: l_CmdString varchar2(2000);
1591: l_ProcessID number;
1592: begin
1593: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1594: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.TERMINATE_ADAPTER',
1595: 'BEGIN:p_ChannelName: '||p_ChannelName);
1596: end if;
1597: p_retcode := 0;
1598: p_errbuf := '';

Line 1629: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1625: p_ErrorMsg => 'XDP_ADAPTER_TERMINATED');
1626: end if;
1627:
1628: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1629: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1630: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.TERMINATE_ADAPTER',
1631: 'Could not release the lock, Channel name: '||p_ChannelName);
1632: end if;
1633: end if;

Line 1630: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.TERMINATE_ADAPTER',

1626: end if;
1627:
1628: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
1629: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1630: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.TERMINATE_ADAPTER',
1631: 'Could not release the lock, Channel name: '||p_ChannelName);
1632: end if;
1633: end if;
1634:

Line 1639: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1635: exception
1636:
1637: when others then
1638: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1639: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1640: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.TERMINATE_ADAPTER',
1641: 'Could not release the lock, Channel name: '||p_ChannelName);
1642: end if;
1643: end if;

Line 1640: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.TERMINATE_ADAPTER',

1636:
1637: when others then
1638: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
1639: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1640: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.TERMINATE_ADAPTER',
1641: 'Could not release the lock, Channel name: '||p_ChannelName);
1642: end if;
1643: end if;
1644: if SQLCODE <> 0 then

Line 1651: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1647: else
1648: p_retCode := pv_retAdapterOtherError;
1649: p_errbuf := 'Other non-SQL error';
1650: END IF;
1651: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1652: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.TERMINATE_ADAPTER',
1653: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1654: end if;
1655: end Terminate_Adapter;

Line 1652: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.TERMINATE_ADAPTER',

1648: p_retCode := pv_retAdapterOtherError;
1649: p_errbuf := 'Other non-SQL error';
1650: END IF;
1651: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1652: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.TERMINATE_ADAPTER',
1653: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1654: end if;
1655: end Terminate_Adapter;
1656:

Line 1782: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1778: l_AdapterLocked1 varchar2(1) := 'N';
1779: l_CurrentStatus varchar2(30);
1780:
1781: begin
1782: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1783: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.VERIFY_ADAPTER',
1784: 'BEGIN:p_ChannelName: '||p_ChannelName);
1785: end if;
1786: p_retcode := 0;

Line 1783: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.VERIFY_ADAPTER',

1779: l_CurrentStatus varchar2(30);
1780:
1781: begin
1782: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1783: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.VERIFY_ADAPTER',
1784: 'BEGIN:p_ChannelName: '||p_ChannelName);
1785: end if;
1786: p_retcode := 0;
1787: p_errbuf := '';

Line 1790: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1786: p_retcode := 0;
1787: p_errbuf := '';
1788:
1789: if p_ChannelName is null then
1790: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1791: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',
1792: 'Required parameters are not passed');
1793: end if;
1794: raise e_RequiredInputDataNotPassed;

Line 1791: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',

1787: p_errbuf := '';
1788:
1789: if p_ChannelName is null then
1790: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1791: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',
1792: 'Required parameters are not passed');
1793: end if;
1794: raise e_RequiredInputDataNotPassed;
1795: end if;

Line 1821: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1817: --dbms_output.put_line('Got SESSION lock for: ' || p_ChannelName);
1818: --dbms_output.put_line('Adapter NOT RUNNING');
1819:
1820: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock('SESSION_'||p_ChannelName) = 'N' then
1821: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1822: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VERIFY_ADAPTER',
1823: 'Could not release SESSION lock, Channel name: '||p_ChannelName);
1824: end if;
1825: end if;

Line 1822: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VERIFY_ADAPTER',

1818: --dbms_output.put_line('Adapter NOT RUNNING');
1819:
1820: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock('SESSION_'||p_ChannelName) = 'N' then
1821: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1822: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VERIFY_ADAPTER',
1823: 'Could not release SESSION lock, Channel name: '||p_ChannelName);
1824: end if;
1825: end if;
1826:

Line 1863: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1859: p_retCode := pv_retAdapterInvalidState;
1860: FND_MESSAGE.CLEAR;
1861: fnd_message.set_name('XDP','XDP_INVALID_ADAPTER_STATE');
1862: p_errbuf := FND_MESSAGE.GET;
1863: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1864: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',
1865: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1866: end if;
1867:

Line 1864: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',

1860: FND_MESSAGE.CLEAR;
1861: fnd_message.set_name('XDP','XDP_INVALID_ADAPTER_STATE');
1862: p_errbuf := FND_MESSAGE.GET;
1863: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1864: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',
1865: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1866: end if;
1867:
1868: when e_OperationFailure then

Line 1874: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1870: FND_MESSAGE.CLEAR;
1871: fnd_message.set_name('XDP','XDP_ADAPTER_ABNORMAL_EXIT');
1872: fnd_message.set_token('PROCESS_ID' , l_ProcessID);
1873: p_errbuf := FND_MESSAGE.GET;
1874: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1875: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',
1876: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1877: end if;
1878: when others then

Line 1875: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',

1871: fnd_message.set_name('XDP','XDP_ADAPTER_ABNORMAL_EXIT');
1872: fnd_message.set_token('PROCESS_ID' , l_ProcessID);
1873: p_errbuf := FND_MESSAGE.GET;
1874: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1875: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',
1876: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1877: end if;
1878: when others then
1879: if l_AdapterLocked1 = 'Y' then

Line 1881: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1877: end if;
1878: when others then
1879: if l_AdapterLocked1 = 'Y' then
1880: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock('SESSION_'||p_ChannelName) = 'N' then
1881: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1882: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VERIFY_ADAPTER',
1883: 'Could not release SESSION lock, Channel name: '||p_ChannelName);
1884: end if;
1885: end if;

Line 1882: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VERIFY_ADAPTER',

1878: when others then
1879: if l_AdapterLocked1 = 'Y' then
1880: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock('SESSION_'||p_ChannelName) = 'N' then
1881: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1882: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VERIFY_ADAPTER',
1883: 'Could not release SESSION lock, Channel name: '||p_ChannelName);
1884: end if;
1885: end if;
1886: end if;

Line 1895: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1891: else
1892: p_retCode := pv_retAdapterOtherError;
1893: p_errbuf := 'Other non-SQL error';
1894: END IF;
1895: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1896: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',
1897: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1898: end if;
1899: end Verify_Adapter;

Line 1896: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',

1892: p_retCode := pv_retAdapterOtherError;
1893: p_errbuf := 'Other non-SQL error';
1894: END IF;
1895: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1896: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTER',
1897: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1898: end if;
1899: end Verify_Adapter;
1900:

Line 1908: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1904: p_errbuf OUT NOCOPY VARCHAR2)
1905: is
1906:
1907: BEGIN
1908: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1909: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS', 'BEGIN:');
1910: end if;
1911:
1912: x_adapter_info := 'NONE';

Line 1909: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS', 'BEGIN:');

1905: is
1906:
1907: BEGIN
1908: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1909: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS', 'BEGIN:');
1910: end if;
1911:
1912: x_adapter_info := 'NONE';
1913: p_retcode := 0;

Line 1943: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1939: -- OK case for this
1940:
1941: -- There are only 2 possibilities now, "CannotLock"
1942: -- or some "when others" error
1943: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1944: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1945: 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',
1946: 'XDP_ADAPTER.Verify_Adapter errored ChannelName: '||
1947: v_AdapterPID.channel_name||', Errorcode: '||

Line 1944: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

1940:
1941: -- There are only 2 possibilities now, "CannotLock"
1942: -- or some "when others" error
1943: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1944: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1945: 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',
1946: 'XDP_ADAPTER.Verify_Adapter errored ChannelName: '||
1947: v_AdapterPID.channel_name||', Errorcode: '||
1948: p_retcode||', ErrorDesc: '||

Line 1976: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1972:
1973: commit;
1974:
1975: else
1976: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1977: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1978: 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',
1979: 'Adapter verification ignored ChannelName: '||
1980: v_AdapterPID.channel_name||', process id: '||

Line 1977: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

1973: commit;
1974:
1975: else
1976: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1977: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1978: 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',
1979: 'Adapter verification ignored ChannelName: '||
1980: v_AdapterPID.channel_name||', process id: '||
1981: v_AdapterPID.process_id||', AdapterStatus: '||

Line 1990: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1986: end if;
1987: end loop;
1988:
1989: p_retcode := 0;
1990: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1991: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',
1992: 'Adapters still required to be verified: '||x_adapter_info);
1993: end if;
1994: exception

Line 1991: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',

1987: end loop;
1988:
1989: p_retcode := 0;
1990: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1991: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',
1992: 'Adapters still required to be verified: '||x_adapter_info);
1993: end if;
1994: exception
1995: when e_OperationFailure then

Line 1998: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

1994: exception
1995: when e_OperationFailure then
1996: x_adapter_info := 'NONE';
1997: -- p_retcode and p_errbuf are already set
1998: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1999: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',
2000: 'Verify_Adapter returned Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2001: end if;
2002: when others then

Line 1999: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',

1995: when e_OperationFailure then
1996: x_adapter_info := 'NONE';
1997: -- p_retcode and p_errbuf are already set
1998: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
1999: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',
2000: 'Verify_Adapter returned Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2001: end if;
2002: when others then
2003: x_adapter_info := 'NONE';

Line 2011: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2007: else
2008: p_retCode := pv_retAdapterOtherError;
2009: p_errbuf := 'Other non-SQL error';
2010: END IF;
2011: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2012: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',
2013: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2014: end if;
2015: end Verify_Running_Adapters;

Line 2012: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',

2008: p_retCode := pv_retAdapterOtherError;
2009: p_errbuf := 'Other non-SQL error';
2010: END IF;
2011: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2012: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS',
2013: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2014: end if;
2015: end Verify_Running_Adapters;
2016:

Line 2050: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2046:
2047: exception
2048: when e_OperationFailure then
2049: -- p_retcode and p_errbuf are already set
2050: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2051: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ALL_ADAPTERS',
2052: 'Verify_Running_Adapters returned Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2053: end if;
2054: when others then

Line 2051: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ALL_ADAPTERS',

2047: exception
2048: when e_OperationFailure then
2049: -- p_retcode and p_errbuf are already set
2050: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2051: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ALL_ADAPTERS',
2052: 'Verify_Running_Adapters returned Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2053: end if;
2054: when others then
2055: if SQLCODE <> 0 then

Line 2062: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2058: else
2059: p_retCode := pv_retAdapterOtherError;
2060: p_errbuf := 'Other non-SQL error';
2061: END IF;
2062: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2063: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ALL_ADAPTERS',
2064: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2065: end if;
2066: END Verify_All_Adapters;

Line 2063: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ALL_ADAPTERS',

2059: p_retCode := pv_retAdapterOtherError;
2060: p_errbuf := 'Other non-SQL error';
2061: END IF;
2062: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2063: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ALL_ADAPTERS',
2064: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2065: end if;
2066: END Verify_All_Adapters;
2067:

Line 2140: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2136: if cv_ChannelName%ISOPEN then
2137: CLOSE cv_ChannelName;
2138: END IF;
2139: -- p_retcode and p_errbuf are already set
2140: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2141: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTERS',
2142: 'Verify_Adapter returned Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2143: end if;
2144: when others then

Line 2141: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTERS',

2137: CLOSE cv_ChannelName;
2138: END IF;
2139: -- p_retcode and p_errbuf are already set
2140: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2141: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTERS',
2142: 'Verify_Adapter returned Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2143: end if;
2144: when others then
2145: if cv_ChannelName%ISOPEN then

Line 2156: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2152: else
2153: p_retCode := pv_retAdapterOtherError;
2154: p_errbuf := 'Other non-SQL error';
2155: END IF;
2156: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2157: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTERS',
2158: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2159: end if;
2160: END Verify_Adapters;

Line 2157: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTERS',

2153: p_retCode := pv_retAdapterOtherError;
2154: p_errbuf := 'Other non-SQL error';
2155: END IF;
2156: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2157: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VERIFY_ADAPTERS',
2158: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2159: end if;
2160: END Verify_Adapters;
2161:

Line 2191: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2187: p_object_type => XDP_ADAPTER.pv_errorObjectTypeAdapter,
2188: p_object_key => p_ChannelName);
2189:
2190: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
2191: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2192: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTER',
2193: 'Could not release the lock, Channel name: '||p_ChannelName);
2194: end if;
2195: end if;

Line 2192: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTER',

2188: p_object_key => p_ChannelName);
2189:
2190: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
2191: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2192: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTER',
2193: 'Could not release the lock, Channel name: '||p_ChannelName);
2194: end if;
2195: end if;
2196: end if;

Line 2204: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2200: when others then
2201:
2202: if l_AdapterLocked = 'Y' then
2203: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
2204: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2205: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTER',
2206: 'Could not release the lock, Channel name: '||p_ChannelName);
2207: end if;
2208: end if;

Line 2205: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTER',

2201:
2202: if l_AdapterLocked = 'Y' then
2203: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
2204: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2205: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTER',
2206: 'Could not release the lock, Channel name: '||p_ChannelName);
2207: end if;
2208: end if;
2209: end if;

Line 2210: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2206: 'Could not release the lock, Channel name: '||p_ChannelName);
2207: end if;
2208: end if;
2209: end if;
2210: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2211: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTER',
2212: 'Unhandled error, SQLCODE: '||SQLCODE);
2213: end if;
2214: END Reset_SysDeactivated_Adapter;

Line 2211: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTER',

2207: end if;
2208: end if;
2209: end if;
2210: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2211: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTER',
2212: 'Unhandled error, SQLCODE: '||SQLCODE);
2213: end if;
2214: END Reset_SysDeactivated_Adapter;
2215:

Line 2219: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2215:
2216: PROCEDURE Reset_SysDeactivated_Adapters (p_controller_instance_id IN NUMBER)
2217: is
2218: BEGIN
2219: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2220: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTERS', 'BEGIN:');
2221: end if;
2222:
2223: for v_SysDeactivatedAdapter in XDP_ADAPTER_CORE_DB.G_Get_SysDeactivated_Adapters

Line 2220: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTERS', 'BEGIN:');

2216: PROCEDURE Reset_SysDeactivated_Adapters (p_controller_instance_id IN NUMBER)
2217: is
2218: BEGIN
2219: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2220: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTERS', 'BEGIN:');
2221: end if;
2222:
2223: for v_SysDeactivatedAdapter in XDP_ADAPTER_CORE_DB.G_Get_SysDeactivated_Adapters
2224: (p_controller_instance_id) loop

Line 2243: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2239:
2240: exception
2241:
2242: when others then
2243: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2244: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTERS',
2245: 'Unhandled error, SQLCODE: '||SQLCODE);
2246: end if;
2247: end RESET_SYSDEACTIVATED_ADAPTERS;

Line 2244: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTERS',

2240: exception
2241:
2242: when others then
2243: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2244: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.RESET_SYSDEACTIVATED_ADAPTERS',
2245: 'Unhandled error, SQLCODE: '||SQLCODE);
2246: end if;
2247: end RESET_SYSDEACTIVATED_ADAPTERS;
2248:

Line 2261: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2257: l_FeID number;
2258: l_ConcQID number;
2259: l_Flag varchar2(10);
2260: begin
2261: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2262: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.VALIDATE_OPERATION',
2263: 'BEGIN:p_ChannelName: '||p_ChannelName);
2264: end if;
2265: p_retcode := 0;

Line 2262: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.VALIDATE_OPERATION',

2258: l_ConcQID number;
2259: l_Flag varchar2(10);
2260: begin
2261: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2262: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.VALIDATE_OPERATION',
2263: 'BEGIN:p_ChannelName: '||p_ChannelName);
2264: end if;
2265: p_retcode := 0;
2266: p_errbuf := '';

Line 2269: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2265: p_retcode := 0;
2266: p_errbuf := '';
2267:
2268: if p_ChannelName is null then
2269: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2270: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2271: 'Required parameters are not passed');
2272: end if;
2273: raise e_RequiredInputDataNotPassed;

Line 2270: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',

2266: p_errbuf := '';
2267:
2268: if p_ChannelName is null then
2269: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2270: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2271: 'Required parameters are not passed');
2272: end if;
2273: raise e_RequiredInputDataNotPassed;
2274: end if;

Line 2308: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2304: if (p_Operation <> XDP_ADAPTER.pv_opStartup) then
2305: -- Cannot use Verify_Adapter API as call to update row has to be autonomous
2306: if not XDP_ADAPTER_CORE_DB.Verify_Adapter (p_ChannelName) then
2307: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
2308: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2309: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',
2310: 'Could not release the lock, Channel name: '||p_ChannelName);
2311: end if;
2312: end if;

Line 2309: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',

2305: -- Cannot use Verify_Adapter API as call to update row has to be autonomous
2306: if not XDP_ADAPTER_CORE_DB.Verify_Adapter (p_ChannelName) then
2307: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
2308: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2309: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',
2310: 'Could not release the lock, Channel name: '||p_ChannelName);
2311: end if;
2312: end if;
2313:

Line 2321: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2317:
2318: XDP_CONTROLLER_CORE.VerifyControllerStatus(l_ConcQID, p_CPID, l_Flag);
2319: if l_Flag = 'N' then
2320: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
2321: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2322: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',
2323: 'Could not release the lock, Channel name: '||p_ChannelName);
2324: end if;
2325: end if;

Line 2322: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',

2318: XDP_CONTROLLER_CORE.VerifyControllerStatus(l_ConcQID, p_CPID, l_Flag);
2319: if l_Flag = 'N' then
2320: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
2321: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2322: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',
2323: 'Could not release the lock, Channel name: '||p_ChannelName);
2324: end if;
2325: end if;
2326:

Line 2341: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2337: fnd_message.set_name('XDP','XDP_ADAPTER_ABNORMAL_EXIT');
2338: fnd_message.set_token('PROCESS_ID' , p_ProcessID);
2339:
2340: p_errbuf := FND_MESSAGE.GET;
2341: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2342: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2343: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2344: end if;
2345:

Line 2342: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',

2338: fnd_message.set_token('PROCESS_ID' , p_ProcessID);
2339:
2340: p_errbuf := FND_MESSAGE.GET;
2341: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2342: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2343: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2344: end if;
2345:
2346: when e_InvalidAdapterState then

Line 2351: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2347: p_retCode := pv_retAdapterInvalidState;
2348: FND_MESSAGE.CLEAR;
2349: fnd_message.set_name('XDP','XDP_INVALID_ADAPTER_STATE');
2350: p_errbuf := FND_MESSAGE.GET;
2351: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2352: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2353: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2354: end if;
2355: when e_UnabletoLockAdapter then

Line 2352: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',

2348: FND_MESSAGE.CLEAR;
2349: fnd_message.set_name('XDP','XDP_INVALID_ADAPTER_STATE');
2350: p_errbuf := FND_MESSAGE.GET;
2351: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2352: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2353: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2354: end if;
2355: when e_UnabletoLockAdapter then
2356: p_retCode := pv_retAdapterCannotLock;

Line 2360: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2356: p_retCode := pv_retAdapterCannotLock;
2357: FND_MESSAGE.CLEAR;
2358: fnd_message.set_name('XDP','XDP_ADAPTER_UNLOCKABLE');
2359: p_errbuf := FND_MESSAGE.GET;
2360: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2361: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2362: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2363: end if;
2364: when e_ControllerNotRunning then

Line 2361: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',

2357: FND_MESSAGE.CLEAR;
2358: fnd_message.set_name('XDP','XDP_ADAPTER_UNLOCKABLE');
2359: p_errbuf := FND_MESSAGE.GET;
2360: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2361: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2362: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2363: end if;
2364: when e_ControllerNotRunning then
2365: p_retCode := pv_retAdapterCtrlNotRunning;

Line 2369: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2365: p_retCode := pv_retAdapterCtrlNotRunning;
2366: FND_MESSAGE.CLEAR;
2367: fnd_message.set_name('XDP','XDP_CONTROLLER_NOT_RUNNING');
2368: p_errbuf := FND_MESSAGE.GET;
2369: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2370: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2371: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2372: end if;
2373: when others then

Line 2370: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',

2366: FND_MESSAGE.CLEAR;
2367: fnd_message.set_name('XDP','XDP_CONTROLLER_NOT_RUNNING');
2368: p_errbuf := FND_MESSAGE.GET;
2369: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2370: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2371: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2372: end if;
2373: when others then
2374: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then

Line 2375: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2371: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2372: end if;
2373: when others then
2374: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
2375: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2376: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',
2377: 'Could not release the lock, Channel name: '||p_ChannelName);
2378: end if;
2379: end if;

Line 2376: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',

2372: end if;
2373: when others then
2374: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
2375: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2376: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',
2377: 'Could not release the lock, Channel name: '||p_ChannelName);
2378: end if;
2379: end if;
2380: if SQLCODE <> 0 then

Line 2387: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

2383: else
2384: p_retCode := pv_retAdapterOtherError;
2385: p_errbuf := 'Other non-SQL error';
2386: END IF;
2387: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2388: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2389: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2390: end if;
2391: end validate_operation;

Line 2388: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',

2384: p_retCode := pv_retAdapterOtherError;
2385: p_errbuf := 'Other non-SQL error';
2386: END IF;
2387: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
2388: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.VALIDATE_OPERATION',
2389: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
2390: end if;
2391: end validate_operation;
2392: