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 XDP_ADAPTER_CORE_DB

Line 97: l_FeID := XDP_ADAPTER_CORE_DB.Get_Fe_Id_For_Name (p_FeName);

93: if l_count > 0 then
94: raise e_DisplayNameNotUnique;
95: end if;
96:
97: l_FeID := XDP_ADAPTER_CORE_DB.Get_Fe_Id_For_Name (p_FeName);
98:
99: select application_mode, adapter_class, connection_required_flag, inbound_required_flag
100: into l_ApplicationMode, l_AdapterClass, l_ConnReqFlag, l_InboundReqFlag
101: from xdp_adapter_types_b

Line 147: XDP_ADAPTER_CORE_DB.Are_Adapter_Generics_Available (

143: --
144: -- Validate software versions available
145: --
146:
147: XDP_ADAPTER_CORE_DB.Are_Adapter_Generics_Available (
148: p_fe_id => l_FeID,
149: p_AdapterType => p_AdapterType,
150: p_GenCountActive => l_GenCountActive,
151: p_GenCountFuture => l_GenCountFuture);

Line 168: XDP_ADAPTER_CORE_DB.CreateNewAdapterChannel(p_FeName, l_ChannelName);

164: end if;
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;

Line 184: XDP_ADAPTER_CORE_DB.LoadNewAdapter( l_ChannelName,

180:
181: -- Append .log to the log file name if not present already
182: l_LogFileName := Add_Log_File_Extension(p_LogFileName);
183:
184: XDP_ADAPTER_CORE_DB.LoadNewAdapter( l_ChannelName,
185: l_FeID,
186: p_AdapterType,
187: l_AdapterName,
188: p_AdapterDispName,

Line 344: l_AdapterLocked := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName);

340: raise e_InvalidAdapterState;
341: end if;
342:
343: --TODO do we really need to take lock, state is already one of the STOPPED
344: l_AdapterLocked := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName);
345: if l_AdapterLocked = 'N' then
346: raise e_UnabletoLockAdapter;
347: end if;
348:

Line 409: XDP_ADAPTER_CORE_DB.UpdateAdapter(

405: -- Append .log to the log file name if not present already
406: l_LogFileName := Add_Log_File_Extension(p_LogFileName);
407:
408:
409: XDP_ADAPTER_CORE_DB.UpdateAdapter(
410: p_ChannelName => p_ChannelName,
411: p_AdapterName => p_AdapterName,
412: p_AdapterDispName => p_AdapterDispName,
413: p_SvcInstId => p_ConcQID,

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

421: p_CmdLineOpts => p_CmdLineOpts,
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;

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

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

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

503: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
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;

Line 572: l_AdapterLocked := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName);

568: raise e_InvalidAdapterState;
569: end if;
570:
571: --TODO do we really need to take lock, state is already one of the STOPPED
572: l_AdapterLocked := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName);
573: if l_AdapterLocked = 'N' then
574: raise e_UnabletoLockAdapter;
575: end if;
576:

Line 577: XDP_ADAPTER_CORE_DB.Delete_Adapter (p_channel_name => p_ChannelName);

573: if l_AdapterLocked = 'N' then
574: raise e_UnabletoLockAdapter;
575: end if;
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',

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

575: end if;
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;

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

613: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
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;

Line 652: l_FeID := XDP_ADAPTER_CORE_DB.Get_Fe_Id_For_Name (p_FeName);

648: end if;
649: p_retcode := 0;
650: p_errbuf := '';
651:
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

Line 654: l_Flag := XDP_ADAPTER_CORE_DB.Is_FE_Adapter_Running (p_fe_id => l_FeID);

650: p_errbuf := '';
651:
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);

Line 663: XDP_ADAPTER_CORE_DB.Delete_Adapters_For_FE (p_fe_id => l_FeID);

659: end if;
660: raise e_FEAdapterRunning;
661: END IF;
662:
663: XDP_ADAPTER_CORE_DB.Delete_Adapters_For_FE (p_fe_id => l_FeID);
664:
665: exception
666:
667: when e_FEAdapterRunning then

Line 720: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then

716: if p_retcode <> 0 then
717: return;
718: END IF;
719:
720: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
721:
722: l_CmdString := p_ChannelName || pv_SMParamDelimiter ||
723: p_OperationName || pv_SMParamDelimiter ||
724: p_OperationParam || pv_SMParamDelimiter;

Line 786: XDP_ADAPTER_CORE_DB.SubmitAdapterAdminReq(

782: end if;
783: raise e_InvalidRequestDate;
784: end if;
785:
786: XDP_ADAPTER_CORE_DB.SubmitAdapterAdminReq(
787: p_ChannelName => p_ChannelName,
788: p_RequestType => p_RequestType,
789: p_RequestDate => p_RequestDate,
790: p_RequestedBy => p_RequestedBy,

Line 856: XDP_ADAPTER_CORE_DB.UpdateAdapterAdminReq(

852: end if;
853: raise e_InvalidRequestDate;
854: end if;
855:
856: XDP_ADAPTER_CORE_DB.UpdateAdapterAdminReq(
857: p_RequestID => Update_Admin_Request.p_RequestID,
858: p_RequestDate => Update_Admin_Request.p_RequestDate,
859: p_RequestedBy => Update_Admin_Request.p_RequestedBy,
860: p_Freq => Update_Admin_Request.p_Freq);

Line 912: XDP_ADAPTER_CORE_DB.RemoveAdapterAdminReq(

908: end if;
909: raise e_RequiredInputDataNotPassed;
910: end if;
911:
912: XDP_ADAPTER_CORE_DB.RemoveAdapterAdminReq(
913: p_RequestID => Delete_Admin_Request.p_RequestID);
914:
915: exception
916: when others then

Line 982: l_AdapterLocked := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName);

978: raise e_InvalidAdapterState;
979: end if;
980:
981: --TODO do we really need to take lock, state is already one of the STOPPED
982: l_AdapterLocked := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName);
983: if l_AdapterLocked = 'N' then
984: raise e_UnabletoLockAdapter;
985: end if;
986:

Line 987: XDP_ADAPTER_CORE_DB.FetchAdapterStartupInfo(

983: if l_AdapterLocked = 'N' then
984: raise e_UnabletoLockAdapter;
985: end if;
986:
987: XDP_ADAPTER_CORE_DB.FetchAdapterStartupInfo(
988: p_ChannelName,
989: l_CmdOptions,
990: l_CmdArgs,
991: l_ControlChannelName,

Line 1001: l_FeID := XDP_ADAPTER_CORE_DB.Get_Fe_Id_For_Name (l_FeName);

997: l_ConcQID,
998: l_InboundChannelName,
999: l_LogFileName);
1000:
1001: l_FeID := XDP_ADAPTER_CORE_DB.Get_Fe_Id_For_Name (l_FeName);
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

Line 1003: l_Flag := XDP_ADAPTER_CORE_DB.Is_Max_Connection_Reached (l_FeID);

999: l_LogFileName);
1000:
1001: l_FeID := XDP_ADAPTER_CORE_DB.Get_Fe_Id_For_Name (l_FeName);
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',

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

1001: l_FeID := XDP_ADAPTER_CORE_DB.Get_Fe_Id_For_Name (l_FeName);
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;

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

1032: l_CmdArgs || pv_SMParamDelimiter;
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;

Line 1046: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then

1042:
1043: raise e_ControllerNotRunning;
1044: end if;
1045:
1046: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1047:
1048: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1049: p_ChannelName => p_ChannelName,
1050: p_Status => pv_statusStarting);

Line 1048: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1044: end if;
1045:
1046: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1047:
1048: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1049: p_ChannelName => p_ChannelName,
1050: p_Status => pv_statusStarting);
1051:
1052: XDP_ADAPTER_CORE_PIPE.CleanupPipe(p_ChannelName => p_ChannelName);

Line 1057: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1053: XDP_CONTROLLER_CORE.LaunchAdapter(l_CPID, l_SMParamString);
1054:
1055: --dbms_output.put_line(substr(l_SMParamString, 1,255));
1056: else
1057: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1058: p_ChannelName => p_ChannelName,
1059: p_Status => pv_statusRunning);
1060:
1061: XDPCORE_FA.HandOverChannel (ChannelName => p_ChannelName,

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

1069: if (XDP_ADAPTER.pv_callerContext = XDP_ADAPTER.pv_CallerContextUser) then
1070:
1071: -- Reset start error count to 0 for Automatic adapters
1072:
1073: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then
1074:
1075: XDP_ERRORS_PKG.UPDATE_ERROR_COUNT (
1076: p_object_type => XDP_ADAPTER.pv_errorObjectTypeAdapter,
1077: p_object_key => p_ChannelName);

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

1077: p_object_key => p_ChannelName);
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;

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

1123: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
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;

Line 1179: l_JobID := XDP_ADAPTER_CORE_DB.DoesSystemReqAlreadyExist(

1175: -- we submit adapter admin request
1176:
1177: -- Submit a adapter admin request
1178: -- Commit should be done by the Caller
1179: l_JobID := XDP_ADAPTER_CORE_DB.DoesSystemReqAlreadyExist(
1180: p_ChannelName => p_ChannelName,
1181: p_RequestType => XDP_ADAPTER.pv_opStop,
1182: p_RequestDate => sysdate);
1183: if (l_JobID = 0) then

Line 1184: XDP_ADAPTER_CORE_DB.SubmitAdapterAdminReq (

1180: p_ChannelName => p_ChannelName,
1181: p_RequestType => XDP_ADAPTER.pv_opStop,
1182: p_RequestDate => sysdate);
1183: if (l_JobID = 0) then
1184: XDP_ADAPTER_CORE_DB.SubmitAdapterAdminReq (
1185: p_ChannelName => p_ChannelName,
1186: p_RequestType => XDP_ADAPTER.pv_opStop,
1187: p_RequestedBy => XDP_ADAPTER.pv_adminReqBySystem,
1188: p_RequestID => l_RequestID,

Line 1197: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then

1193: elsif p_retcode <> 0 then
1194: return;
1195: end if;
1196:
1197: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1198:
1199: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1200: p_ChannelName => p_ChannelName,
1201: p_Status => pv_statusStopping);

Line 1199: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1195: end if;
1196:
1197: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1198:
1199: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1200: p_ChannelName => p_ChannelName,
1201: p_Status => pv_statusStopping);
1202:
1203: l_CmdString := p_ChannelName || pv_SMParamDelimiter;

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

1201: p_Status => pv_statusStopping);
1202:
1203: l_CmdString := p_ChannelName || pv_SMParamDelimiter;
1204:
1205: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then
1206: if (XDP_ADAPTER.pv_callerContext = XDP_ADAPTER.pv_CallerContextUser) then
1207: l_CmdString := l_CmdString ||
1208: XDP_ADAPTER.pv_CallerContextUser ||
1209: pv_SMParamDelimiter;

Line 1220: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1216:
1217: XDP_CONTROLLER_CORE.StopAdapter(l_CPID, l_CmdString);
1218:
1219: else
1220: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1221: p_ChannelName => p_ChannelName,
1222: p_Status => pv_statusStopped);
1223:
1224: -- Deactivate the automatic adapter in case user stops it.

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

1223:
1224: -- Deactivate the automatic adapter in case user stops it.
1225: if (XDP_ADAPTER.pv_callerContext = XDP_ADAPTER.pv_CallerContextUser) then
1226:
1227: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then
1228:
1229: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1230: p_ChannelName => p_ChannelName,
1231: p_Status => pv_statusDeactivated);

Line 1229: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1225: if (XDP_ADAPTER.pv_callerContext = XDP_ADAPTER.pv_CallerContextUser) then
1226:
1227: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then
1228:
1229: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1230: p_ChannelName => p_ChannelName,
1231: p_Status => pv_statusDeactivated);
1232: END IF;
1233: END IF;

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

1233: END IF;
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;

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

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

Line 1303: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then

1299: if p_retcode <> 0 then
1300: return;
1301: END IF;
1302:
1303: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1304:
1305: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1306: p_ChannelName => p_ChannelName,
1307: p_Status => pv_statusSuspending);

Line 1305: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1301: END IF;
1302:
1303: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1304:
1305: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1306: p_ChannelName => p_ChannelName,
1307: p_Status => pv_statusSuspending);
1308:
1309: l_CmdString := p_ChannelName || pv_SMParamDelimiter;

Line 1314: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1310:
1311: XDP_CONTROLLER_CORE.SuspendAdapter(l_CPID, l_CmdString);
1312:
1313: else
1314: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1315: p_ChannelName => p_ChannelName,
1316: p_Status => pv_statusSuspended);
1317: end if;
1318:

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

1315: p_ChannelName => p_ChannelName,
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;

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

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

Line 1375: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then

1371: if p_retcode <> 0 then
1372: return;
1373: END IF;
1374:
1375: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1376:
1377: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1378: p_ChannelName => p_ChannelName,
1379: p_Status => pv_statusResuming);

Line 1377: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1373: END IF;
1374:
1375: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1376:
1377: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1378: p_ChannelName => p_ChannelName,
1379: p_Status => pv_statusResuming);
1380:
1381: l_CmdString := p_ChannelName || pv_SMParamDelimiter;

Line 1388: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1384:
1385: --HandOverChannel needs to be done by Controller
1386:
1387: else
1388: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1389: p_ChannelName => p_ChannelName,
1390: p_Status => pv_statusRunning);
1391:
1392: XDPCORE_FA.HandOverChannel (ChannelName => p_ChannelName,

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

1396: ErrCode => p_retcode,
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;

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

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

Line 1457: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then

1453: if p_retcode <> 0 then
1454: return;
1455: END IF;
1456:
1457: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1458:
1459: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1460: p_ChannelName => p_ChannelName,
1461: p_Status => pv_statusConnecting);

Line 1459: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1455: END IF;
1456:
1457: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1458:
1459: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1460: p_ChannelName => p_ChannelName,
1461: p_Status => pv_statusConnecting);
1462:
1463: l_CmdString := p_ChannelName || pv_SMParamDelimiter;

Line 1470: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1466:
1467: --HandOverChannel needs to be done by Controller
1468:
1469: else
1470: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1471: p_ChannelName => p_ChannelName,
1472: p_Status => pv_statusRunning);
1473:
1474: XDPCORE_FA.HandOverChannel (ChannelName => p_ChannelName,

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

1478: ErrCode => p_retcode,
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;

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

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

Line 1538: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then

1534: if p_retcode <> 0 then
1535: return;
1536: END IF;
1537:
1538: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1539:
1540: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1541: p_ChannelName => p_ChannelName,
1542: p_Status => pv_statusDisconnecting);

Line 1540: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1536: END IF;
1537:
1538: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1539:
1540: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1541: p_ChannelName => p_ChannelName,
1542: p_Status => pv_statusDisconnecting);
1543:
1544: l_CmdString := p_ChannelName || pv_SMParamDelimiter;

Line 1549: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1545:
1546: XDP_CONTROLLER_CORE.DisconnectAdapter(l_CPID, l_CmdString);
1547:
1548: else
1549: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1550: p_ChannelName => p_ChannelName,
1551: p_Status => pv_statusDisconnected);
1552: end if;
1553:

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

1550: p_ChannelName => p_ChannelName,
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;

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

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

Line 1611: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then

1607: if p_retcode <> 0 then
1608: return;
1609: END IF;
1610:
1611: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1612:
1613: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1614: p_ChannelName => p_ChannelName,
1615: p_Status => pv_statusTerminating);

Line 1613: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1609: END IF;
1610:
1611: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1612:
1613: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1614: p_ChannelName => p_ChannelName,
1615: p_Status => pv_statusTerminating);
1616:
1617: l_CmdString := p_ChannelName || pv_SMParamDelimiter ||

Line 1622: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1618: l_ProcessID || pv_SMParamDelimiter;
1619:
1620: XDP_CONTROLLER_CORE.TerminateAdapter(l_CPID, l_CmdString);
1621: else
1622: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1623: p_ChannelName => p_ChannelName,
1624: p_Status => pv_statusTerminated,
1625: p_ErrorMsg => 'XDP_ADAPTER_TERMINATED');
1626: end if;

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

1624: p_Status => pv_statusTerminated,
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;

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

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

Line 1679: XDP_ADAPTER_CORE_DB.LoadNewAdapterType(p_AdapterType,

1675: is
1676:
1677: begin
1678:
1679: XDP_ADAPTER_CORE_DB.LoadNewAdapterType(p_AdapterType,
1680: p_AdapterClass,
1681: p_ApplicationMode,
1682: p_InboundReqFlag,
1683: p_SyncBufSize,

Line 1804: --l_AdapterLocked := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName);

1800: raise e_InvalidAdapterState;
1801: end if;
1802:
1803: --Hold session lock only for state change operations - bug3300862
1804: --l_AdapterLocked := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName);
1805: --if l_AdapterLocked = 'N' then
1806: -- raise e_UnabletoLockAdapter;
1807: --end if;
1808:

Line 1809: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then

1805: --if l_AdapterLocked = 'N' then
1806: -- raise e_UnabletoLockAdapter;
1807: --end if;
1808:
1809: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1810:
1811: l_AdapterLocked1 := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify('SESSION_'||p_ChannelName);
1812:
1813: if l_AdapterLocked1 = 'Y' then

Line 1811: l_AdapterLocked1 := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify('SESSION_'||p_ChannelName);

1807: --end if;
1808:
1809: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
1810:
1811: l_AdapterLocked1 := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify('SESSION_'||p_ChannelName);
1812:
1813: if l_AdapterLocked1 = 'Y' then
1814:
1815: -- Adapter NOT running, release the SESSION lock

Line 1820: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock('SESSION_'||p_ChannelName) = 'N' then

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

Line 1827: XDP_ADAPTER_CORE_DB.FetchAdapterInfo(

1823: 'Could not release SESSION lock, Channel name: '||p_ChannelName);
1824: end if;
1825: end if;
1826:
1827: XDP_ADAPTER_CORE_DB.FetchAdapterInfo(
1828: p_ChannelName => p_ChannelName,
1829: p_FEID => l_FeID,
1830: p_ProcessID => l_ProcessID,
1831: p_ConcQID => l_ConcQID);

Line 1833: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(

1829: p_FEID => l_FeID,
1830: p_ProcessID => l_ProcessID,
1831: p_ConcQID => l_ConcQID);
1832:
1833: XDP_ADAPTER_CORE_DB.Update_Adapter_Status(
1834: p_ChannelName,
1835: pv_statusStoppedError,
1836: 'XDP_ADAPTER_ABNORMAL_EXIT',
1837: 'PROCESS_ID='||l_ProcessID||'#XDP#');

Line 1845: XDP_ADAPTER_CORE_DB.UpdateAdapter (

1841: --dbms_output.put_line('Did not get SESSION lock for: ' || p_ChannelName);
1842: --dbms_output.put_line('Adapter RUNNING');
1843:
1844: -- Could not get lock, Adapter running, update last_verified_date
1845: XDP_ADAPTER_CORE_DB.UpdateAdapter (
1846: p_ChannelName => p_ChannelName,
1847: p_LastVerified => sysdate);
1848: end if;
1849: else

Line 1851: XDP_ADAPTER_CORE_DB.UpdateAdapter (

1847: p_LastVerified => sysdate);
1848: end if;
1849: else
1850: -- Adapter not implemented, so Adapter is 'running', update last_verified_date
1851: XDP_ADAPTER_CORE_DB.UpdateAdapter (
1852: p_ChannelName => p_ChannelName,
1853: p_LastVerified => sysdate);
1854: end if;
1855:

Line 1880: if XDP_ADAPTER_CORE_DB.ReleaseAdapterLock('SESSION_'||p_ChannelName) = 'N' then

1876: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
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;

Line 1915: for v_AdapterPID in XDP_ADAPTER_CORE_DB.G_Get_Running_Adapters

1911:
1912: x_adapter_info := 'NONE';
1913: p_retcode := 0;
1914:
1915: for v_AdapterPID in XDP_ADAPTER_CORE_DB.G_Get_Running_Adapters
1916: (p_controller_instance_id) loop
1917:
1918: if (v_AdapterPID.is_implemented = 'Y') then
1919:

Line 2028: for v_GetSvcID in XDP_ADAPTER_CORE_DB.G_Get_Controller_Instances loop

2024:
2025: BEGIN
2026: p_retcode := 0;
2027:
2028: for v_GetSvcID in XDP_ADAPTER_CORE_DB.G_Get_Controller_Instances loop
2029:
2030: l_CustomParamList := 'NONE';
2031:
2032: XDP_ADAPTER.Verify_Running_Adapters (

Line 2174: l_AdapterLocked := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName);

2170:
2171: l_AdapterLocked varchar2(1) := 'N';
2172:
2173: BEGIN
2174: l_AdapterLocked := XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName);
2175: if l_AdapterLocked = 'N' then
2176: return;
2177: else
2178: if (p_ResetStatusFlag) then

Line 2179: XDP_ADAPTER_CORE_DB.UpdateAdapter(

2175: if l_AdapterLocked = 'N' then
2176: return;
2177: else
2178: if (p_ResetStatusFlag) then
2179: XDP_ADAPTER_CORE_DB.UpdateAdapter(
2180: p_ChannelName => p_ChannelName,
2181: p_Status => pv_statusStopped);
2182: END IF;
2183:

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

2186: XDP_ERRORS_PKG.UPDATE_ERROR_COUNT (
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;

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

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

Line 2223: for v_SysDeactivatedAdapter in XDP_ADAPTER_CORE_DB.G_Get_SysDeactivated_Adapters

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
2225:
2226: if (v_SysDeactivatedAdapter.adapter_status = XDP_ADAPTER.pv_statusDeactivatedSystem) then
2227:

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

2282: END IF;
2283:
2284: --Hold session lock only for state change operations - bug3300862
2285: if (p_Operation <> XDP_ADAPTER.pv_opGeneric) then
2286: if (XDP_ADAPTER_CORE_DB.ObtainAdapterLock_Verify(p_ChannelName) = 'N') then
2287: raise e_UnabletoLockAdapter;
2288: end if;
2289: END IF;
2290:

Line 2294: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then

2290:
2291: -- Though Controller is only needed for implemented adapter types but to give consistent
2292: -- response for non-implemented adapter types we should always check if Controller
2293: -- is up.
2294: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
2295:
2296: -- We need to retrieve process id, Verify_Adapter could set it to -1
2297: XDP_ADAPTER_CORE_DB.FetchAdapterInfo(
2298: p_ChannelName => p_ChannelName,

Line 2297: XDP_ADAPTER_CORE_DB.FetchAdapterInfo(

2293: -- is up.
2294: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Implemented (p_ChannelName)) then
2295:
2296: -- We need to retrieve process id, Verify_Adapter could set it to -1
2297: XDP_ADAPTER_CORE_DB.FetchAdapterInfo(
2298: p_ChannelName => p_ChannelName,
2299: p_FEID => l_FeID,
2300: p_ProcessID => p_ProcessID,
2301: p_ConcQID => l_ConcQID);

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

2302:
2303: --Verify adapter state for operation only if operation is not Start
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);

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

2303: --Verify adapter state for operation only if operation is not Start
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;

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

2316: END IF;
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;

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

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