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_EXP_NTF_PVT dependencies on FND_LOG

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

91: AND c1.contract_expiration_date <= TRUNC(SYSDATE) + c1.expire_ntf_period
92: AND c1.wf_exp_ntf_item_key IS NULL
93: );
94: BEGIN
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: 'Entering OKC_REP_EXP_NTF_PVT.contract_expiration_notifier');

Line 96: FND_LOG.STRING(

92: AND c1.wf_exp_ntf_item_key IS NULL
93: );
94: BEGIN
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: 'Entering OKC_REP_EXP_NTF_PVT.contract_expiration_notifier');
100: END IF;

Line 97: FND_LOG.LEVEL_PROCEDURE,

93: );
94: BEGIN
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: 'Entering OKC_REP_EXP_NTF_PVT.contract_expiration_notifier');
100: END IF;
101:

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

125: x_return_status => x_return_status
126: );
127: END LOOP;
128:
129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
130: FND_LOG.STRING(
131: FND_LOG.LEVEL_PROCEDURE,
132: G_MODULE||l_api_name,
133: 'Leaving OKC_REP_EXP_NTF_PVT.contract_expiration_notifier');

Line 130: FND_LOG.STRING(

126: );
127: END LOOP;
128:
129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
130: FND_LOG.STRING(
131: FND_LOG.LEVEL_PROCEDURE,
132: G_MODULE||l_api_name,
133: 'Leaving OKC_REP_EXP_NTF_PVT.contract_expiration_notifier');
134: END IF;

Line 131: FND_LOG.LEVEL_PROCEDURE,

127: END LOOP;
128:
129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
130: FND_LOG.STRING(
131: FND_LOG.LEVEL_PROCEDURE,
132: G_MODULE||l_api_name,
133: 'Leaving OKC_REP_EXP_NTF_PVT.contract_expiration_notifier');
134: END IF;
135:

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

134: END IF;
135:
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
139: fnd_log.string(
140: FND_LOG.LEVEL_EXCEPTION,
141: G_MODULE || l_api_name,
142: 'Leaving contract_expiration_notifier:FND_API.G_EXC_ERROR Exception');

Line 139: fnd_log.string(

135:
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
139: fnd_log.string(
140: FND_LOG.LEVEL_EXCEPTION,
141: G_MODULE || l_api_name,
142: 'Leaving contract_expiration_notifier:FND_API.G_EXC_ERROR Exception');
143: END IF;

Line 140: FND_LOG.LEVEL_EXCEPTION,

136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
139: fnd_log.string(
140: FND_LOG.LEVEL_EXCEPTION,
141: G_MODULE || l_api_name,
142: 'Leaving contract_expiration_notifier:FND_API.G_EXC_ERROR Exception');
143: END IF;
144: --close cursors

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

152: p_data => x_msg_data
153: );
154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: fnd_log.string(
158: FND_LOG.LEVEL_EXCEPTION,
159: G_MODULE || l_api_name,
160: 'Leaving contract_expiration_notifier:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 157: fnd_log.string(

153: );
154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: fnd_log.string(
158: FND_LOG.LEVEL_EXCEPTION,
159: G_MODULE || l_api_name,
160: 'Leaving contract_expiration_notifier:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
161: END IF;

Line 158: FND_LOG.LEVEL_EXCEPTION,

154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: fnd_log.string(
158: FND_LOG.LEVEL_EXCEPTION,
159: G_MODULE || l_api_name,
160: 'Leaving contract_expiration_notifier:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
161: END IF;
162: --close cursors

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

170: p_data => x_msg_data
171: );
172:
173: WHEN OTHERS THEN
174: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: fnd_log.string(
176: FND_LOG.LEVEL_EXCEPTION,
177: G_MODULE || l_api_name,
178: 'Leaving contract_expiration_notifier because of EXCEPTION: ' || sqlerrm);

Line 175: fnd_log.string(

171: );
172:
173: WHEN OTHERS THEN
174: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: fnd_log.string(
176: FND_LOG.LEVEL_EXCEPTION,
177: G_MODULE || l_api_name,
178: 'Leaving contract_expiration_notifier because of EXCEPTION: ' || sqlerrm);
179: END IF;

Line 176: FND_LOG.LEVEL_EXCEPTION,

172:
173: WHEN OTHERS THEN
174: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: fnd_log.string(
176: FND_LOG.LEVEL_EXCEPTION,
177: G_MODULE || l_api_name,
178: 'Leaving contract_expiration_notifier because of EXCEPTION: ' || sqlerrm);
179: END IF;
180: Okc_Api.Set_Message(

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

223: l_return_status VARCHAR2(2000);
224: BEGIN
225: retcode := G_RETURN_CODE_ERROR;
226:
227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
228: FND_LOG.STRING(
229: FND_LOG.LEVEL_PROCEDURE,
230: G_MODULE||l_api_name,
231: 'Entering OKC_REP_EXP_NTF_PVT.contract_expiration_manager');

Line 228: FND_LOG.STRING(

224: BEGIN
225: retcode := G_RETURN_CODE_ERROR;
226:
227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
228: FND_LOG.STRING(
229: FND_LOG.LEVEL_PROCEDURE,
230: G_MODULE||l_api_name,
231: 'Entering OKC_REP_EXP_NTF_PVT.contract_expiration_manager');
232: END IF;

Line 229: FND_LOG.LEVEL_PROCEDURE,

225: retcode := G_RETURN_CODE_ERROR;
226:
227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
228: FND_LOG.STRING(
229: FND_LOG.LEVEL_PROCEDURE,
230: G_MODULE||l_api_name,
231: 'Entering OKC_REP_EXP_NTF_PVT.contract_expiration_manager');
232: END IF;
233:

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

244: );
245:
246: retcode := G_RETURN_CODE_SUCCESS;
247:
248: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.STRING(
250: FND_LOG.LEVEL_PROCEDURE,
251: G_MODULE||l_api_name,
252: 'Leaving OKC_REP_EXP_NTF_PVT.contract_expiration_manager');

Line 249: FND_LOG.STRING(

245:
246: retcode := G_RETURN_CODE_SUCCESS;
247:
248: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.STRING(
250: FND_LOG.LEVEL_PROCEDURE,
251: G_MODULE||l_api_name,
252: 'Leaving OKC_REP_EXP_NTF_PVT.contract_expiration_manager');
253: END IF;

Line 250: FND_LOG.LEVEL_PROCEDURE,

246: retcode := G_RETURN_CODE_SUCCESS;
247:
248: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.STRING(
250: FND_LOG.LEVEL_PROCEDURE,
251: G_MODULE||l_api_name,
252: 'Leaving OKC_REP_EXP_NTF_PVT.contract_expiration_manager');
253: END IF;
254:

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

253: END IF;
254:
255: EXCEPTION
256: WHEN OTHERS THEN
257: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
258: fnd_log.string(
259: FND_LOG.LEVEL_EXCEPTION,
260: G_MODULE || l_api_name,
261: 'Leaving contract_expiration_manager because of EXCEPTION: ' || SQLERRM);

Line 258: fnd_log.string(

254:
255: EXCEPTION
256: WHEN OTHERS THEN
257: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
258: fnd_log.string(
259: FND_LOG.LEVEL_EXCEPTION,
260: G_MODULE || l_api_name,
261: 'Leaving contract_expiration_manager because of EXCEPTION: ' || SQLERRM);
262: errbuf := substr(SQLERRM, 1, 200);

Line 259: FND_LOG.LEVEL_EXCEPTION,

255: EXCEPTION
256: WHEN OTHERS THEN
257: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
258: fnd_log.string(
259: FND_LOG.LEVEL_EXCEPTION,
260: G_MODULE || l_api_name,
261: 'Leaving contract_expiration_manager because of EXCEPTION: ' || SQLERRM);
262: errbuf := substr(SQLERRM, 1, 200);
263: END IF;