DBA Data[Home] [Help]

APPS.CCT_SRSEC_CHECK_PUB dependencies on FND_API

Line 29: x_return_status := FND_API.G_FALSE;

25: SELECT agent_id, resp_id, app_id FROM cct_agent_rt_stats
26: WHERE agent_id IN (p_agentIDs) AND attribute1 = 'T';
27:
28: BEGIN
29: x_return_status := FND_API.G_FALSE;
30: If (p_agentIDs is null) THEN
31: return;
32: End If;
33:

Line 93: if (status = FND_API.G_FALSE) then

89: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cct.plsql.cct_srsec_check_pub.authenticate_agents', 'Status returned from CallSRSecurityCheck() API is = '||status );
90: end if;
91:
92: --Error'd out in API or No SR Security Check API found so return.
93: if (status = FND_API.G_FALSE) then
94: return;
95: end if;
96: --Build comma seperated agent list from Nested Table returned from SR SEcurity check api.
97:

Line 115: x_return_status := FND_API.G_TRUE;

111: end if;
112:
113: if (totalRec=1) then
114: if (l_agentIDs is not null) then
115: x_return_status := FND_API.G_TRUE;
116: p_agentIDs := l_agentIDs;
117: return;
118: else
119: p_agentIDs := '';

Line 138: x_return_status := FND_API.G_TRUE;

134: p_agentIDs := l_agentIDs;
135: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cct.plsql.cct_srsec_check_pub.authenticate_agents', 'AgentIDs returned are = '||p_agentIDs );
137: end if;
138: x_return_status := FND_API.G_TRUE;
139: --dbms_output.put_line('In TestSRSecurityT Proc '||SQLERRM(STATUS));
140: EXCEPTION
141: WHEN OTHERS THEN
142: FND_MESSAGE.SET_NAME('CCT','CCT_UNEXPECTED_ERROR');

Line 150: x_return_status := FND_API.G_FALSE;

146:
147: IF l_agents_csr%ISOPEN THEN
148: CLOSE l_agents_csr;
149: END IF;
150: x_return_status := FND_API.G_FALSE;
151: END authenticate_agents;
152:
153: procedure CallSRSecurityCheck(p_srnum IN Varchar2,p_table in out NOCOPY system.CCT_AGENT_RESP_APP_ID_NST, x_return_status out NOCOPY varchar2)
154: IS

Line 160: x_return_status := FND_API.G_FALSE;

156: l_srKeyName Varchar2(64);
157: status NUMERIC;
158: return_status varchar2(1);
159: BEGIN
160: x_return_status := FND_API.G_FALSE;
161: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
162: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cct.plsql.cct_srsec_check_pub.CallSRSecurityCheck.begin', '' );
163: end if;
164: BEGIN

Line 216: x_return_status := FND_API.G_TRUE;

212: end if;
213: return;
214: end if;
215:
216: x_return_status := FND_API.G_TRUE;
217: END CallSRSecurityCheck;
218:
219: END CCT_SRSEC_CHECK_PUB;