DBA Data[Home] [Help]

APPS.XDP_CONTROLLER_CORE dependencies on XDP_ADAPTER_CORE

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 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 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 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 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 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 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 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 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 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 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 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 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 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;