DBA Data[Home] [Help]

APPS.XDP_CONTROLLER_CORE dependencies on XDP_ADAPTER

Line 163: XDP_ADAPTER.pv_callerContext := XDP_ADAPTER.pv_callerContextAdmin;

159:
160: --***************************************************************
161: --********* SET THE CONTEXT ************************************
162:
163: XDP_ADAPTER.pv_callerContext := XDP_ADAPTER.pv_callerContextAdmin;
164:
165: --***************************************************************
166: --***************************************************************
167:

Line 168: XDP_ADAPTER.Verify_Running_Adapters (

164:
165: --***************************************************************
166: --***************************************************************
167:
168: XDP_ADAPTER.Verify_Running_Adapters (
169: p_controller_instance_id => l_ConcQID,
170: x_adapter_info => p_AdapterInfo,
171: p_retcode => l_RetCode,
172: p_errbuf => l_ErrorMsg

Line 179: 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS returned error: '||

175: if (l_RetCode <> 0) then
176: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
177: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
178: 'XDP_CONTROLLER_CORE.PERFORM_STOP_PROCESSING',
179: 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS returned error: '||
180: l_RetCode||', Desc: '||l_ErrorMsg);
181: end if;
182: END IF;
183:

Line 189: for v_AdapterPID in XDP_ADAPTER_CORE_DB.G_Get_Running_Adapters (l_ConcQID) loop

185: -- PIDs
186:
187: p_AdapterInfo := 'NONE';
188:
189: for v_AdapterPID in XDP_ADAPTER_CORE_DB.G_Get_Running_Adapters (l_ConcQID) loop
190:
191: if (((v_AdapterPID.is_implemented = 'Y') and (v_AdapterPID.process_id > 0)) or
192: (v_AdapterPID.is_implemented = 'N')) then
193: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

Line 203: XDP_ADAPTER.Stop_Adapter (v_AdapterPID.channel_name,

199:
200: if v_AdapterPID.is_implemented = 'N' then
201: -- This will also submit the job incase we are not able to
202: -- lock, so no need to submit job to stop adapter
203: XDP_ADAPTER.Stop_Adapter (v_AdapterPID.channel_name,
204: l_RetCode, l_ErrorMsg);
205: else
206: -- We shouldnt call Stop_Adapter API for implemented adapters
207: -- as that will submit CUSTOM request on Controller queue

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

216: -- pv_retAdapterAbnormalExit/CommFailed -- will stop on its own
217: -- when other errors -- ERROR
218:
219: if ((l_RetCode <> 0) and
220: (l_retcode <> XDP_ADAPTER.pv_retAdapterInvalidState) and
221: (l_retcode <> XDP_ADAPTER.pv_retAdapterCommFailed) and
222: (l_retcode <> XDP_ADAPTER.pv_retAdapterCannotLockReqSub)) THEN
223:
224: -- dbms_output.put_line('l_Retcode: ' || l_RetCode);

Line 221: (l_retcode <> XDP_ADAPTER.pv_retAdapterCommFailed) and

217: -- when other errors -- ERROR
218:
219: if ((l_RetCode <> 0) and
220: (l_retcode <> XDP_ADAPTER.pv_retAdapterInvalidState) and
221: (l_retcode <> XDP_ADAPTER.pv_retAdapterCommFailed) and
222: (l_retcode <> XDP_ADAPTER.pv_retAdapterCannotLockReqSub)) THEN
223:
224: -- dbms_output.put_line('l_Retcode: ' || l_RetCode);
225: -- dbms_output.put_line('l_ErrorMsg: ' || l_ErrorMsg);

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

218:
219: if ((l_RetCode <> 0) and
220: (l_retcode <> XDP_ADAPTER.pv_retAdapterInvalidState) and
221: (l_retcode <> XDP_ADAPTER.pv_retAdapterCommFailed) and
222: (l_retcode <> XDP_ADAPTER.pv_retAdapterCannotLockReqSub)) THEN
223:
224: -- dbms_output.put_line('l_Retcode: ' || l_RetCode);
225: -- dbms_output.put_line('l_ErrorMsg: ' || l_ErrorMsg);
226:

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

230: 'XDP_CONTROLLER_CORE.PERFORM_STOP_PROCESSING',
231: 'Adapter stop failed with error: '||l_RetCode||', error msg: '||l_ErrorMsg);
232: end if;
233:
234: elsif (l_retcode = XDP_ADAPTER.pv_retAdapterCannotLockReqSub) then
235: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
236: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
237: 'XDP_CONTROLLER_CORE.PERFORM_STOP_PROCESSING',
238: 'Adapter stop request submitted');

Line 279: if l_retcode = XDP_ADAPTER.pv_retAdapterCannotLockReqSub then

275: l_term_adapters_list(l_term_adapter_count).channel_name :=
276: v_AdapterPID.channel_name;
277: l_term_adapters_list(l_term_adapter_count).process_id :=
278: v_AdapterPID.process_id;
279: if l_retcode = XDP_ADAPTER.pv_retAdapterCannotLockReqSub then
280: l_term_adapters_list(l_term_adapter_count).lock_retry :=
281: 'Y';
282: else
283: l_term_adapters_list(l_term_adapter_count).lock_retry :=

Line 306: (l_retcode = XDP_ADAPTER.pv_retAdapterInvalidState) or

302: l_RetCode, l_ErrorMsg);
303: commit;
304:
305: if ((l_RetCode = 0) or
306: (l_retcode = XDP_ADAPTER.pv_retAdapterInvalidState) or
307: (l_retcode = XDP_ADAPTER.pv_retAdapterCommFailed)) THEN
308: l_term_adapters_list(i).process_id := -1;
309: END IF;
310: END IF;

Line 307: (l_retcode = XDP_ADAPTER.pv_retAdapterCommFailed)) THEN

303: commit;
304:
305: if ((l_RetCode = 0) or
306: (l_retcode = XDP_ADAPTER.pv_retAdapterInvalidState) or
307: (l_retcode = XDP_ADAPTER.pv_retAdapterCommFailed)) THEN
308: l_term_adapters_list(i).process_id := -1;
309: END IF;
310: END IF;
311: END LOOP;

Line 399: XDP_ADAPTER.Verify_Running_Adapters (

395: ConcQName => l_ConcQName);
396:
397: if l_ConcQID > 0 then
398:
399: XDP_ADAPTER.Verify_Running_Adapters (
400: p_controller_instance_id => l_ConcQID,
401: x_adapter_info => p_AdapterInfo,
402: p_retcode => l_RetCode,
403: p_errbuf => l_ErrorMsg

Line 416: 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS returned error: '||

412: else
413: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
414: FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
415: 'XDP_CONTROLLER_CORE.PERFORM_START_PROCESSING',
416: 'XDP_ADAPTER.VERIFY_RUNNING_ADAPTERS returned error: '||
417: l_RetCode||', Desc: '||l_ErrorMsg);
418: end if;
419: END IF;
420:

Line 426: XDP_ADAPTER.Reset_SysDeactivated_Adapters (p_controller_instance_id => l_ConcQID);

422: -- PIDs
423:
424: p_AdapterInfo := 'NONE';
425:
426: XDP_ADAPTER.Reset_SysDeactivated_Adapters (p_controller_instance_id => l_ConcQID);
427:
428: else
429: -- dbms_output.put_line('ConcQID: ' || l_ConcQID);
430: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05

Line 458: p_Status := XDP_ADAPTER_CORE.pv_AdapterResponseSuccess;

454: l_ErrorMsg VARCHAR2 (4000);
455: l_RetCode NUMBER := 0;
456: begin
457:
458: p_Status := XDP_ADAPTER_CORE.pv_AdapterResponseSuccess;
459: p_ErrorMessage := '';
460:
461: -- Lock adapter incase p_Operation is pv_opConnect or pv_opResume
462: if p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then

Line 462: if p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then

458: p_Status := XDP_ADAPTER_CORE.pv_AdapterResponseSuccess;
459: p_ErrorMessage := '';
460:
461: -- Lock adapter incase p_Operation is pv_opConnect or pv_opResume
462: if p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then
463: if (XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName) = 'N') then
464: --Should not happen
465: --raise e_UnabletoLockAdapter;
466: null;

Line 463: if (XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName) = 'N') then

459: p_ErrorMessage := '';
460:
461: -- Lock adapter incase p_Operation is pv_opConnect or pv_opResume
462: if p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then
463: if (XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName) = 'N') then
464: --Should not happen
465: --raise e_UnabletoLockAdapter;
466: null;
467: end if;

Line 470: XDP_ADAPTER_CORE.ProcessControlCommand (

466: null;
467: end if;
468: END IF;
469:
470: XDP_ADAPTER_CORE.ProcessControlCommand (
471: p_ChannelName => p_ChannelName,
472: p_Operation => p_Operation,
473: p_OpData => p_OpData,
474: p_Status => p_Status,

Line 477: if p_Status = XDP_ADAPTER_CORE.pv_AdapterResponseSuccess then

473: p_OpData => p_OpData,
474: p_Status => p_Status,
475: p_ErrorMessage => p_ErrorMessage);
476:
477: if p_Status = XDP_ADAPTER_CORE.pv_AdapterResponseSuccess then
478:
479: -- Deactivate the automatic adapter in case user stops it.
480: if p_Operation = XDP_ADAPTER.pv_opStop then
481:

Line 480: if p_Operation = XDP_ADAPTER.pv_opStop then

476:
477: if p_Status = XDP_ADAPTER_CORE.pv_AdapterResponseSuccess then
478:
479: -- Deactivate the automatic adapter in case user stops it.
480: if p_Operation = XDP_ADAPTER.pv_opStop then
481:
482: if (p_Caller = XDP_ADAPTER.pv_CallerContextUser) then
483:
484: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then

Line 482: if (p_Caller = XDP_ADAPTER.pv_CallerContextUser) then

478:
479: -- Deactivate the automatic adapter in case user stops it.
480: if p_Operation = XDP_ADAPTER.pv_opStop then
481:
482: if (p_Caller = XDP_ADAPTER.pv_CallerContextUser) then
483:
484: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then
485:
486: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

Line 484: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then

480: if p_Operation = XDP_ADAPTER.pv_opStop then
481:
482: if (p_Caller = XDP_ADAPTER.pv_CallerContextUser) then
483:
484: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then
485:
486: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
487: p_ChannelName => p_ChannelName,
488: p_Status => XDP_ADAPTER.pv_statusDeactivated);

Line 486: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

482: if (p_Caller = XDP_ADAPTER.pv_CallerContextUser) then
483:
484: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then
485:
486: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
487: p_ChannelName => p_ChannelName,
488: p_Status => XDP_ADAPTER.pv_statusDeactivated);
489: END IF;
490: END IF;

Line 488: p_Status => XDP_ADAPTER.pv_statusDeactivated);

484: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then
485:
486: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
487: p_ChannelName => p_ChannelName,
488: p_Status => XDP_ADAPTER.pv_statusDeactivated);
489: END IF;
490: END IF;
491:
492: elsif p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then

Line 492: elsif p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then

488: p_Status => XDP_ADAPTER.pv_statusDeactivated);
489: END IF;
490: END IF;
491:
492: elsif p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then
493: -- Handover the channel
494: XDPCORE_FA.HandOverChannel (ChannelName => p_ChannelName,
495: FeID => 0,
496: ChannelUsageCode => NULL,

Line 502: p_Status := XDP_ADAPTER_CORE.pv_ProcessCommandError;

498: ErrCode => l_RetCode,
499: ErrStr => l_ErrorMsg);
500: if l_RetCode <> 0 then
501: rollback;
502: p_Status := XDP_ADAPTER_CORE.pv_ProcessCommandError;
503: p_ErrorMessage := 'Error in HandOverChannel, error: '||substr(l_ErrorMsg,1,255);
504: end if;
505: END IF;
506:

Line 507: elsif p_Status = XDP_ADAPTER_CORE.pv_AdapterResponseFailure then

503: p_ErrorMessage := 'Error in HandOverChannel, error: '||substr(l_ErrorMsg,1,255);
504: end if;
505: END IF;
506:
507: elsif p_Status = XDP_ADAPTER_CORE.pv_AdapterResponseFailure then
508: -- p_ErrorMessage will already be set by Adapter
509: -- Adapter will go down on its own
510: -- Do nothing
511: null;

Line 513: elsif p_Status = XDP_ADAPTER_CORE.pv_ProcessCommandTimedout then

509: -- Adapter will go down on its own
510: -- Do nothing
511: null;
512:
513: elsif p_Status = XDP_ADAPTER_CORE.pv_ProcessCommandTimedout then
514:
515: p_ErrorMessage := 'Operation timed out';
516: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
517: p_ChannelName => p_ChannelName,

Line 516: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

512:
513: elsif p_Status = XDP_ADAPTER_CORE.pv_ProcessCommandTimedout then
514:
515: p_ErrorMessage := 'Operation timed out';
516: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
517: p_ChannelName => p_ChannelName,
518: p_Status => XDP_ADAPTER.pv_statusStoppedError,
519: p_ErrorMsg => 'XDP_ADAPTER_OP_COMM_FAILURE');
520:

Line 518: p_Status => XDP_ADAPTER.pv_statusStoppedError,

514:
515: p_ErrorMessage := 'Operation timed out';
516: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
517: p_ChannelName => p_ChannelName,
518: p_Status => XDP_ADAPTER.pv_statusStoppedError,
519: p_ErrorMsg => 'XDP_ADAPTER_OP_COMM_FAILURE');
520:
521: -- elsif p_Status = XDP_ADAPTER_CORE.pv_ProcessCommandError then
522: else

Line 519: p_ErrorMsg => 'XDP_ADAPTER_OP_COMM_FAILURE');

515: p_ErrorMessage := 'Operation timed out';
516: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
517: p_ChannelName => p_ChannelName,
518: p_Status => XDP_ADAPTER.pv_statusStoppedError,
519: p_ErrorMsg => 'XDP_ADAPTER_OP_COMM_FAILURE');
520:
521: -- elsif p_Status = XDP_ADAPTER_CORE.pv_ProcessCommandError then
522: else
523: p_ErrorMessage := 'dbms_pipe error';

Line 521: -- elsif p_Status = XDP_ADAPTER_CORE.pv_ProcessCommandError then

517: p_ChannelName => p_ChannelName,
518: p_Status => XDP_ADAPTER.pv_statusStoppedError,
519: p_ErrorMsg => 'XDP_ADAPTER_OP_COMM_FAILURE');
520:
521: -- elsif p_Status = XDP_ADAPTER_CORE.pv_ProcessCommandError then
522: else
523: p_ErrorMessage := 'dbms_pipe error';
524: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
525: p_ChannelName => p_ChannelName,

Line 524: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

520:
521: -- elsif p_Status = XDP_ADAPTER_CORE.pv_ProcessCommandError then
522: else
523: p_ErrorMessage := 'dbms_pipe error';
524: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
525: p_ChannelName => p_ChannelName,
526: p_Status => XDP_ADAPTER.pv_statusStoppedError,
527: p_ErrorMsg => 'XDP_ADAPTER_PIPE_ERROR');
528:

Line 526: p_Status => XDP_ADAPTER.pv_statusStoppedError,

522: else
523: p_ErrorMessage := 'dbms_pipe error';
524: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
525: p_ChannelName => p_ChannelName,
526: p_Status => XDP_ADAPTER.pv_statusStoppedError,
527: p_ErrorMsg => 'XDP_ADAPTER_PIPE_ERROR');
528:
529: end if;
530:

Line 527: p_ErrorMsg => 'XDP_ADAPTER_PIPE_ERROR');

523: p_ErrorMessage := 'dbms_pipe error';
524: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
525: p_ChannelName => p_ChannelName,
526: p_Status => XDP_ADAPTER.pv_statusStoppedError,
527: p_ErrorMsg => 'XDP_ADAPTER_PIPE_ERROR');
528:
529: end if;
530:
531: if p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then

Line 531: if p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then

527: p_ErrorMsg => 'XDP_ADAPTER_PIPE_ERROR');
528:
529: end if;
530:
531: if p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then
532: -- Release adapter lock
533: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
534: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
535: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

Line 533: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then

529: end if;
530:
531: if p_Operation = XDP_ADAPTER.pv_opConnect or p_Operation = XDP_ADAPTER.pv_opResume then
532: -- Release adapter lock
533: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
534: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
535: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
536: 'XDP_CONTROLLER_CORE.PROCESS_CONTROL_COMMAND',
537: 'Could not release the lock, Channel name: '||p_ChannelName);

Line 546: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then

542: commit;
543:
544: exception
545: when others then
546: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
547: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
548: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
549: 'XDP_CONTROLLER_CORE.PROCESS_CONTROL_COMMAND',
550: 'Could not release the lock, Channel name: '||p_ChannelName);

Line 558: p_Status := XDP_ADAPTER_CORE.pv_ProcessCommandError;

554: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_CONTROLLER_CORE.PROCESS_CONTROL_COMMAND',
555: 'Unhandled error, SQLCODE: '||SQLCODE);
556: end if;
557: rollback;
558: p_Status := XDP_ADAPTER_CORE.pv_ProcessCommandError;
559: p_ErrorMessage := 'Unhandled error, SQLCODE: '||SQLCODE;
560:
561: end Process_Control_Command;
562:

Line 572: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.STOP_IMPL_ADAPTER',

568: l_Status varchar2(4000);
569:
570: begin
571: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
572: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_ADAPTER.STOP_IMPL_ADAPTER',
573: 'BEGIN:p_ChannelName: '||p_ChannelName);
574: end if;
575: p_retcode := 0;
576: p_errbuf := '';

Line 578: if not XDP_ADAPTER_CORE.VerifyAdapterOperation(p_ChannelName, XDP_ADAPTER.pv_OpStop,

574: end if;
575: p_retcode := 0;
576: p_errbuf := '';
577:
578: if not XDP_ADAPTER_CORE.VerifyAdapterOperation(p_ChannelName, XDP_ADAPTER.pv_OpStop,
579: l_Status) then
580: p_retcode := XDP_ADAPTER.pv_retAdapterInvalidState;
581: return;
582: end if;

Line 580: p_retcode := XDP_ADAPTER.pv_retAdapterInvalidState;

576: p_errbuf := '';
577:
578: if not XDP_ADAPTER_CORE.VerifyAdapterOperation(p_ChannelName, XDP_ADAPTER.pv_OpStop,
579: l_Status) then
580: p_retcode := XDP_ADAPTER.pv_retAdapterInvalidState;
581: return;
582: end if;
583:
584: if (XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName) = 'N') then

Line 584: if (XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName) = 'N') then

580: p_retcode := XDP_ADAPTER.pv_retAdapterInvalidState;
581: return;
582: end if;
583:
584: if (XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName) = 'N') then
585: p_retcode := XDP_ADAPTER.pv_retAdapterCannotLockReqSub;
586: return;
587: end if;
588:

Line 585: p_retcode := XDP_ADAPTER.pv_retAdapterCannotLockReqSub;

581: return;
582: end if;
583:
584: if (XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName) = 'N') then
585: p_retcode := XDP_ADAPTER.pv_retAdapterCannotLockReqSub;
586: return;
587: end if;
588:
589: -- Cannot use Verify_Adapter API as call to update row has to be autonomous

Line 590: if not XDP_ADAPTER_CORE_DB.Verify_Adapter (p_ChannelName) then

586: return;
587: end if;
588:
589: -- Cannot use Verify_Adapter API as call to update row has to be autonomous
590: if not XDP_ADAPTER_CORE_DB.Verify_Adapter (p_ChannelName) then
591: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
592: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
593: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',
594: 'Could not release the lock, Channel name: '||p_ChannelName);

Line 591: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then

587: end if;
588:
589: -- Cannot use Verify_Adapter API as call to update row has to be autonomous
590: if not XDP_ADAPTER_CORE_DB.Verify_Adapter (p_ChannelName) then
591: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
592: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
593: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',
594: 'Could not release the lock, Channel name: '||p_ChannelName);
595: end if;

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

589: -- Cannot use Verify_Adapter API as call to update row has to be autonomous
590: if not XDP_ADAPTER_CORE_DB.Verify_Adapter (p_ChannelName) then
591: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then
592: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
593: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',
594: 'Could not release the lock, Channel name: '||p_ChannelName);
595: end if;
596: end if;
597: p_retCode := XDP_ADAPTER.pv_retAdapterCommFailed;

Line 597: p_retCode := XDP_ADAPTER.pv_retAdapterCommFailed;

593: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.VALIDATE_OPERATION',
594: 'Could not release the lock, Channel name: '||p_ChannelName);
595: end if;
596: end if;
597: p_retCode := XDP_ADAPTER.pv_retAdapterCommFailed;
598: return;
599: END IF;
600:
601: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

Line 601: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

597: p_retCode := XDP_ADAPTER.pv_retAdapterCommFailed;
598: return;
599: END IF;
600:
601: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
602: p_ChannelName => p_ChannelName,
603: p_Status => XDP_ADAPTER.pv_statusStopping);
604:
605: Process_Control_Command(p_ChannelName => p_ChannelName,

Line 603: p_Status => XDP_ADAPTER.pv_statusStopping);

599: END IF;
600:
601: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
602: p_ChannelName => p_ChannelName,
603: p_Status => XDP_ADAPTER.pv_statusStopping);
604:
605: Process_Control_Command(p_ChannelName => p_ChannelName,
606: p_Operation => XDP_ADAPTER.pv_opStop,
607: p_Caller => XDP_ADAPTER.pv_callerContextAdmin,

Line 606: p_Operation => XDP_ADAPTER.pv_opStop,

602: p_ChannelName => p_ChannelName,
603: p_Status => XDP_ADAPTER.pv_statusStopping);
604:
605: Process_Control_Command(p_ChannelName => p_ChannelName,
606: p_Operation => XDP_ADAPTER.pv_opStop,
607: p_Caller => XDP_ADAPTER.pv_callerContextAdmin,
608: p_Status => l_Status,
609: p_ErrorMessage => p_errbuf);
610:

Line 607: p_Caller => XDP_ADAPTER.pv_callerContextAdmin,

603: p_Status => XDP_ADAPTER.pv_statusStopping);
604:
605: Process_Control_Command(p_ChannelName => p_ChannelName,
606: p_Operation => XDP_ADAPTER.pv_opStop,
607: p_Caller => XDP_ADAPTER.pv_callerContextAdmin,
608: p_Status => l_Status,
609: p_ErrorMessage => p_errbuf);
610:
611: -- pv_AdapterResponseFailure means handshake happened with adapter, adapter will go down

Line 612: if ((l_Status <> XDP_ADAPTER_CORE.pv_AdapterResponseSuccess) and

608: p_Status => l_Status,
609: p_ErrorMessage => p_errbuf);
610:
611: -- pv_AdapterResponseFailure means handshake happened with adapter, adapter will go down
612: if ((l_Status <> XDP_ADAPTER_CORE.pv_AdapterResponseSuccess) and
613: (l_Status <> XDP_ADAPTER_CORE.pv_AdapterResponseFailure)) then
614: p_retCode := XDP_ADAPTER.pv_retAdapterOtherError;
615: END IF;
616:

Line 613: (l_Status <> XDP_ADAPTER_CORE.pv_AdapterResponseFailure)) then

609: p_ErrorMessage => p_errbuf);
610:
611: -- pv_AdapterResponseFailure means handshake happened with adapter, adapter will go down
612: if ((l_Status <> XDP_ADAPTER_CORE.pv_AdapterResponseSuccess) and
613: (l_Status <> XDP_ADAPTER_CORE.pv_AdapterResponseFailure)) then
614: p_retCode := XDP_ADAPTER.pv_retAdapterOtherError;
615: END IF;
616:
617: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then

Line 614: p_retCode := XDP_ADAPTER.pv_retAdapterOtherError;

610:
611: -- pv_AdapterResponseFailure means handshake happened with adapter, adapter will go down
612: if ((l_Status <> XDP_ADAPTER_CORE.pv_AdapterResponseSuccess) and
613: (l_Status <> XDP_ADAPTER_CORE.pv_AdapterResponseFailure)) then
614: p_retCode := XDP_ADAPTER.pv_retAdapterOtherError;
615: END IF;
616:
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

Line 617: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N' then

613: (l_Status <> XDP_ADAPTER_CORE.pv_AdapterResponseFailure)) then
614: p_retCode := XDP_ADAPTER.pv_retAdapterOtherError;
615: END IF;
616:
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.STOP_IMPL_ADAPTER',
620: 'Could not release the lock, Channel name: '||p_ChannelName);
621: end if;

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

615: END IF;
616:
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.STOP_IMPL_ADAPTER',
620: 'Could not release the lock, Channel name: '||p_ChannelName);
621: end if;
622: end if;
623:

Line 627: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then

623:
624: exception
625:
626: when others then
627: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
628: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
629: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.STOP_IMPL_ADAPTER',
630: 'Could not release the lock, Channel name: '||p_ChannelName);
631: end if;

Line 629: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.STOP_IMPL_ADAPTER',

625:
626: when others then
627: if (XDP_ADAPTER_CORE_DB.ReleaseAdapterLock(p_ChannelName) = 'N') then
628: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
629: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED, 'XDP_ADAPTER.STOP_IMPL_ADAPTER',
630: 'Could not release the lock, Channel name: '||p_ChannelName);
631: end if;
632: end if;
633:

Line 637: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.STOP_IMPL_ADAPTER',

633:
634: p_retCode := SQLCODE;
635: p_errbuf := SQLERRM;
636: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then --Fix Bug: 4256771, dputhiye, 28 Apr 05
637: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_ADAPTER.STOP_IMPL_ADAPTER',
638: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
639: end if;
640: end Stop_Impl_Adapter;
641: