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.OKC_REP_CONTRACT_SEARCH_PVT dependencies on FND_LOG

Line 72: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

68:
69: l_api_name := 'update_text_index';
70: l_api_version := 1.0;
71:
72: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
73: FND_LOG.STRING(
74: FND_LOG.LEVEL_PROCEDURE,
75: G_MODULE||l_api_name,
76: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index');

Line 73: FND_LOG.STRING(

69: l_api_name := 'update_text_index';
70: l_api_version := 1.0;
71:
72: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
73: FND_LOG.STRING(
74: FND_LOG.LEVEL_PROCEDURE,
75: G_MODULE||l_api_name,
76: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index');
77: END IF;

Line 74: FND_LOG.LEVEL_PROCEDURE,

70: l_api_version := 1.0;
71:
72: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
73: FND_LOG.STRING(
74: FND_LOG.LEVEL_PROCEDURE,
75: G_MODULE||l_api_name,
76: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index');
77: END IF;
78:

Line 95: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

91: ad_ctx_ddl.sync_index(G_CONTRACT_VERS_INDEX);
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(
97: FND_LOG.LEVEL_PROCEDURE,
98: G_MODULE||l_api_name,
99: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.syncronize_text_index');

Line 96: FND_LOG.STRING(

92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(
97: FND_LOG.LEVEL_PROCEDURE,
98: G_MODULE||l_api_name,
99: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.syncronize_text_index');
100: END IF;

Line 97: FND_LOG.LEVEL_PROCEDURE,

93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(
97: FND_LOG.LEVEL_PROCEDURE,
98: G_MODULE||l_api_name,
99: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.syncronize_text_index');
100: END IF;
101: EXCEPTION

Line 103: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

99: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.syncronize_text_index');
100: END IF;
101: EXCEPTION
102: WHEN OTHERS THEN
103: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: fnd_log.string(
105: FND_LOG.LEVEL_EXCEPTION,
106: G_MODULE || l_api_name,
107: 'Leaving update_text_index because of EXCEPTION: ' || SQLERRM);

Line 104: fnd_log.string(

100: END IF;
101: EXCEPTION
102: WHEN OTHERS THEN
103: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: fnd_log.string(
105: FND_LOG.LEVEL_EXCEPTION,
106: G_MODULE || l_api_name,
107: 'Leaving update_text_index because of EXCEPTION: ' || SQLERRM);
108: END IF;

Line 105: FND_LOG.LEVEL_EXCEPTION,

101: EXCEPTION
102: WHEN OTHERS THEN
103: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: fnd_log.string(
105: FND_LOG.LEVEL_EXCEPTION,
106: G_MODULE || l_api_name,
107: 'Leaving update_text_index because of EXCEPTION: ' || SQLERRM);
108: END IF;
109: Okc_Api.Set_Message(

Line 152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

148: l_api_name := 'optimize_text_index';
149: l_api_version := 1.0;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151:
152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(
154: FND_LOG.LEVEL_PROCEDURE,
155: G_MODULE||l_api_name,
156: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');

Line 153: FND_LOG.STRING(

149: l_api_version := 1.0;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151:
152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(
154: FND_LOG.LEVEL_PROCEDURE,
155: G_MODULE||l_api_name,
156: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');
157: END IF;

Line 154: FND_LOG.LEVEL_PROCEDURE,

150: x_return_status := FND_API.G_RET_STS_ERROR;
151:
152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(
154: FND_LOG.LEVEL_PROCEDURE,
155: G_MODULE||l_api_name,
156: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');
157: END IF;
158:

Line 183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

179: );
180:
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING(
185: FND_LOG.LEVEL_PROCEDURE,
186: G_MODULE||l_api_name,
187: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');

Line 184: FND_LOG.STRING(

180:
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING(
185: FND_LOG.LEVEL_PROCEDURE,
186: G_MODULE||l_api_name,
187: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');
188: END IF;

Line 185: FND_LOG.LEVEL_PROCEDURE,

181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING(
185: FND_LOG.LEVEL_PROCEDURE,
186: G_MODULE||l_api_name,
187: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');
188: END IF;
189: EXCEPTION

Line 191: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

187: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');
188: END IF;
189: EXCEPTION
190: WHEN OTHERS THEN
191: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
192: fnd_log.string(
193: FND_LOG.LEVEL_EXCEPTION,
194: G_MODULE || l_api_name,
195: 'Leaving optimize_text_index because of EXCEPTION: ' || SQLERRM);

Line 192: fnd_log.string(

188: END IF;
189: EXCEPTION
190: WHEN OTHERS THEN
191: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
192: fnd_log.string(
193: FND_LOG.LEVEL_EXCEPTION,
194: G_MODULE || l_api_name,
195: 'Leaving optimize_text_index because of EXCEPTION: ' || SQLERRM);
196: END IF;

Line 193: FND_LOG.LEVEL_EXCEPTION,

189: EXCEPTION
190: WHEN OTHERS THEN
191: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
192: fnd_log.string(
193: FND_LOG.LEVEL_EXCEPTION,
194: G_MODULE || l_api_name,
195: 'Leaving optimize_text_index because of EXCEPTION: ' || SQLERRM);
196: END IF;
197: Okc_Api.Set_Message(

Line 237: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

233: l_return_status VARCHAR2(2000);
234: BEGIN
235: retcode := G_RETURN_CODE_ERROR;
236:
237: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
238: FND_LOG.STRING(
239: FND_LOG.LEVEL_PROCEDURE,
240: G_MODULE||l_api_name,
241: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');

Line 238: FND_LOG.STRING(

234: BEGIN
235: retcode := G_RETURN_CODE_ERROR;
236:
237: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
238: FND_LOG.STRING(
239: FND_LOG.LEVEL_PROCEDURE,
240: G_MODULE||l_api_name,
241: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');
242: END IF;

Line 239: FND_LOG.LEVEL_PROCEDURE,

235: retcode := G_RETURN_CODE_ERROR;
236:
237: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
238: FND_LOG.STRING(
239: FND_LOG.LEVEL_PROCEDURE,
240: G_MODULE||l_api_name,
241: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');
242: END IF;
243:

Line 260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

256: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
257: retcode := G_RETURN_CODE_SUCCESS;
258: END IF;
259:
260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
261: FND_LOG.STRING(
262: FND_LOG.LEVEL_PROCEDURE,
263: G_MODULE||l_api_name,
264: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');

Line 261: FND_LOG.STRING(

257: retcode := G_RETURN_CODE_SUCCESS;
258: END IF;
259:
260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
261: FND_LOG.STRING(
262: FND_LOG.LEVEL_PROCEDURE,
263: G_MODULE||l_api_name,
264: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');
265: END IF;

Line 262: FND_LOG.LEVEL_PROCEDURE,

258: END IF;
259:
260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
261: FND_LOG.STRING(
262: FND_LOG.LEVEL_PROCEDURE,
263: G_MODULE||l_api_name,
264: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.update_text_index_ctx');
265: END IF;
266:

Line 269: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

265: END IF;
266:
267: EXCEPTION
268: WHEN OTHERS THEN
269: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
270: fnd_log.string(
271: FND_LOG.LEVEL_EXCEPTION,
272: G_MODULE || l_api_name,
273: 'Leaving update_text_index_ctx because of EXCEPTION: ' || SQLERRM);

Line 270: fnd_log.string(

266:
267: EXCEPTION
268: WHEN OTHERS THEN
269: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
270: fnd_log.string(
271: FND_LOG.LEVEL_EXCEPTION,
272: G_MODULE || l_api_name,
273: 'Leaving update_text_index_ctx because of EXCEPTION: ' || SQLERRM);
274: errbuf := substr(SQLERRM, 1, 200);

Line 271: FND_LOG.LEVEL_EXCEPTION,

267: EXCEPTION
268: WHEN OTHERS THEN
269: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
270: fnd_log.string(
271: FND_LOG.LEVEL_EXCEPTION,
272: G_MODULE || l_api_name,
273: 'Leaving update_text_index_ctx because of EXCEPTION: ' || SQLERRM);
274: errbuf := substr(SQLERRM, 1, 200);
275: END IF;

Line 302: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

298: l_msg_data VARCHAR2(2000);
299: l_msg_count NUMBER;
300: l_return_status VARCHAR2(2000);
301: BEGIN
302: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.STRING(
304: FND_LOG.LEVEL_PROCEDURE,
305: G_MODULE||l_api_name,
306: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index_ctx');

Line 303: FND_LOG.STRING(

299: l_msg_count NUMBER;
300: l_return_status VARCHAR2(2000);
301: BEGIN
302: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.STRING(
304: FND_LOG.LEVEL_PROCEDURE,
305: G_MODULE||l_api_name,
306: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index_ctx');
307: END IF;

Line 304: FND_LOG.LEVEL_PROCEDURE,

300: l_return_status VARCHAR2(2000);
301: BEGIN
302: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.STRING(
304: FND_LOG.LEVEL_PROCEDURE,
305: G_MODULE||l_api_name,
306: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index_ctx');
307: END IF;
308:

Line 327: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

323: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
324: retcode := G_RETURN_CODE_SUCCESS;
325: END IF;
326:
327: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.STRING(
329: FND_LOG.LEVEL_PROCEDURE,
330: G_MODULE||l_api_name,
331: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index_ctx');

Line 328: FND_LOG.STRING(

324: retcode := G_RETURN_CODE_SUCCESS;
325: END IF;
326:
327: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.STRING(
329: FND_LOG.LEVEL_PROCEDURE,
330: G_MODULE||l_api_name,
331: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index_ctx');
332: END IF;

Line 329: FND_LOG.LEVEL_PROCEDURE,

325: END IF;
326:
327: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
328: FND_LOG.STRING(
329: FND_LOG.LEVEL_PROCEDURE,
330: G_MODULE||l_api_name,
331: 'Leaving OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index_ctx');
332: END IF;
333:

Line 336: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

332: END IF;
333:
334: EXCEPTION
335: WHEN OTHERS THEN
336: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: fnd_log.string(
338: FND_LOG.LEVEL_EXCEPTION,
339: G_MODULE || l_api_name,
340: 'Leaving optimize_text_index_ctx because of EXCEPTION: ' || SQLERRM);

Line 337: fnd_log.string(

333:
334: EXCEPTION
335: WHEN OTHERS THEN
336: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: fnd_log.string(
338: FND_LOG.LEVEL_EXCEPTION,
339: G_MODULE || l_api_name,
340: 'Leaving optimize_text_index_ctx because of EXCEPTION: ' || SQLERRM);
341: errbuf := substr(SQLERRM, 1, 200);

Line 338: FND_LOG.LEVEL_EXCEPTION,

334: EXCEPTION
335: WHEN OTHERS THEN
336: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: fnd_log.string(
338: FND_LOG.LEVEL_EXCEPTION,
339: G_MODULE || l_api_name,
340: 'Leaving optimize_text_index_ctx because of EXCEPTION: ' || SQLERRM);
341: errbuf := substr(SQLERRM, 1, 200);
342: END IF;