DBA Data[Home] [Help]

APPS.XDP_CONTROLLER_CORE dependencies on XDP_ADAPTER_CORE_DB

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