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.CCT_SRSEC_CHECK_PUB dependencies on CCT_SRSEC_CHECK_PUB

Line 1: PACKAGE BODY CCT_SRSEC_CHECK_PUB as

1: PACKAGE BODY CCT_SRSEC_CHECK_PUB as
2: /* $Header: cctsrseb.pls 120.1 2005/11/14 14:01:03 ibyon noship $ */
3: procedure authenticate_agents(p_srnum IN Varchar2,
4: p_agentIDs IN OUT NOCOPY Varchar2,
5: p_isServerGroupID IN Varchar2,

Line 79: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cct.plsql.cct_srsec_check_pub.authenticate_agents', 'No of Records in Nested table p_table is = '||totalRec);

75: --It could happen that, p_table has 0 count. As none of agents were logged in.
76: totalRec := p_table.COUNT;
77: --dbms_output.put_line ('Value of runtime level is '||FND_LOG.G_CURRENT_RUNTIME_LEVEL);
78: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
79: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cct.plsql.cct_srsec_check_pub.authenticate_agents', 'No of Records in Nested table p_table is = '||totalRec);
80: end if;
81:
82: if (totalRec < 1) then
83: return;

Line 86: CCT_SRSEC_CHECK_PUB.CallSRSecurityCheck(p_srnum,p_table,status);

82: if (totalRec < 1) then
83: return;
84: end if;
85:
86: CCT_SRSEC_CHECK_PUB.CallSRSecurityCheck(p_srnum,p_table,status);
87:
88: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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;

Line 89: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cct.plsql.cct_srsec_check_pub.authenticate_agents', 'Status returned from CallSRSecurityCheck() API is = '||status );

85:
86: CCT_SRSEC_CHECK_PUB.CallSRSecurityCheck(p_srnum,p_table,status);
87:
88: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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

Line 136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cct.plsql.cct_srsec_check_pub.authenticate_agents', 'AgentIDs returned are = '||p_agentIDs );

132: END LOOP;
133: --dbms_output.put_line (' Value of returned AgentID is ' ||l_agentIDs);
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

Line 162: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cct.plsql.cct_srsec_check_pub.CallSRSecurityCheck.begin', '' );

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
165: SELECT Count(*) INTO l_ver
166: FROM cct_security_functions

Line 172: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cct.plsql.cct_srsec_check_pub.CallSRSecurityCheck', 'Exception while querying cct_security_functions table. '||SQLERRM(status) );

168: EXCEPTION
169: When Others Then
170: status := SQLCODE;
171: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
172: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cct.plsql.cct_srsec_check_pub.CallSRSecurityCheck', 'Exception while querying cct_security_functions table. '||SQLERRM(status) );
173: end if;
174:
175: --dbms_output.put_line('In CallSRSecurityCheck Proc '||SQLERRM(STATUS));
176: return;

Line 191: -- CCT_SRSEC_CHECK_PUB.validate_security(:1,:2,:3,:4);

187: --authenticate_agents API.
188: if (l_ver is not null) then
189: l_srKeyName := CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
190: BEGIN
191: -- CCT_SRSEC_CHECK_PUB.validate_security(:1,:2,:3,:4);
192: EXECUTE IMMEDIATE
193: 'BEGIN
194: sr_uwq_integ.validate_security(:1,:2,:3,:4);
195: END;'

Line 201: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cct.plsql.cct_srsec_check_pub.CallSRSecurityCheck', 'Exception was raised. '||SQLERRM(status) );

197: EXCEPTION
198: WHEN OTHERS THEN
199: status := SQLCODE;
200: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
201: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cct.plsql.cct_srsec_check_pub.CallSRSecurityCheck', 'Exception was raised. '||SQLERRM(status) );
202: end if;
203:
204: --dbms_output.put_line('Exception while executing validate_security() Proc '||SQLERRM(STATUS));
205: return;

Line 211: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cct.plsql.cct_srsec_check_pub.CallSRSecurityCheck', 'Can not find Service Request Security Check API' );

207: --raise_application_error(-20000, sqlerrm || '. Could not add column') ;
208: ELSE
209: --Couldn't find an SR Security Check API so return.
210: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
211: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cct.plsql.cct_srsec_check_pub.CallSRSecurityCheck', 'Can not find Service Request Security Check API' );
212: end if;
213: return;
214: end if;
215:

Line 219: END CCT_SRSEC_CHECK_PUB;

215:
216: x_return_status := FND_API.G_TRUE;
217: END CallSRSecurityCheck;
218:
219: END CCT_SRSEC_CHECK_PUB;