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 FND_LOG

Line 77: --dbms_output.put_line ('Value of runtime level is '||FND_LOG.G_CURRENT_RUNTIME_LEVEL);

73: --END LOOP;
74:
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:

Line 78: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

74:
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

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 88: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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;
91:
92: --Error'd out in API or No SR Security Check API found so return.

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 135: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

131: i := p_table.NEXT(i);
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));

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 161: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

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 171: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

167: WHERE application_id=170 AND version=1.0 ;
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));

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 200: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

196: USING l_srKeyName,p_srnum,IN OUT p_table, OUT x_return_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));

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 210: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

206: END;
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;

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: