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

Line 93: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

89:
90: l_mr_rec mr_details_csr_type%rowtype;
91:
92: BEGIN
93: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
94: fnd_log.string
95: (
96: fnd_log.level_procedure,
97: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 94: fnd_log.string

90: l_mr_rec mr_details_csr_type%rowtype;
91:
92: BEGIN
93: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
94: fnd_log.string
95: (
96: fnd_log.level_procedure,
97: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
98: 'At the start of PLSQL procedure'

Line 96: fnd_log.level_procedure,

92: BEGIN
93: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
94: fnd_log.string
95: (
96: fnd_log.level_procedure,
97: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
98: 'At the start of PLSQL procedure'
99: );
100: END IF;

Line 127: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

123: IF g_appln_usage is null
124: THEN
125: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
126: FND_MSG_PUB.ADD;
127: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
128: fnd_log.string
129: (
130: fnd_log.level_error,
131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 128: fnd_log.string

124: THEN
125: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
126: FND_MSG_PUB.ADD;
127: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
128: fnd_log.string
129: (
130: fnd_log.level_error,
131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
132: 'Error -- Application usage code is null'

Line 130: fnd_log.level_error,

126: FND_MSG_PUB.ADD;
127: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
128: fnd_log.string
129: (
130: fnd_log.level_error,
131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
132: 'Error -- Application usage code is null'
133: );
134: END IF;

Line 138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

134: END IF;
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:
138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
139: fnd_log.string
140: (
141: fnd_log.level_statement,
142: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 139: fnd_log.string

135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:
138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
139: fnd_log.string
140: (
141: fnd_log.level_statement,
142: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
143: 'Before doing value to id conversion.....'

Line 141: fnd_log.level_statement,

137:
138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
139: fnd_log.string
140: (
141: fnd_log.level_statement,
142: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
143: 'Before doing value to id conversion.....'
144: );
145: END IF;

Line 159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

155: p_lookup_meaning => p_x_association_tbl(i).object_type_desc,
156: p_x_lookup_code => p_x_association_tbl(i).object_type_code
157: );
158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
160: fnd_log.string
161: (
162: fnd_log.level_statement,
163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 160: fnd_log.string

156: p_x_lookup_code => p_x_association_tbl(i).object_type_code
157: );
158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
160: fnd_log.string
161: (
162: fnd_log.level_statement,
163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
164: 'Error -- Invalid lookup specified'

Line 162: fnd_log.level_statement,

158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
160: fnd_log.string
161: (
162: fnd_log.level_statement,
163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
164: 'Error -- Invalid lookup specified'
165: );
166: END IF;

Line 179: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

175: x_mr_header_id => p_x_association_tbl(i).mr_header_id,
176: x_return_status => x_return_status
177: );
178: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
179: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
180: fnd_log.string
181: (
182: fnd_log.level_error,
183: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 180: fnd_log.string

176: x_return_status => x_return_status
177: );
178: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
179: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
180: fnd_log.string
181: (
182: fnd_log.level_error,
183: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
184: 'Invalid MR Title, Version Number provided'

Line 182: fnd_log.level_error,

178: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
179: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
180: fnd_log.string
181: (
182: fnd_log.level_error,
183: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
184: 'Invalid MR Title, Version Number provided'
185: );
186: END IF;

Line 203: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

199: IF mr_details_csr_type%NOTFOUND
200: THEN
201: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASSO_UPDATE_ERROR');
202: FND_MSG_PUB.ADD;
203: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
204: fnd_log.string
205: (
206: fnd_log.level_error,
207: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 204: fnd_log.string

200: THEN
201: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASSO_UPDATE_ERROR');
202: FND_MSG_PUB.ADD;
203: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
204: fnd_log.string
205: (
206: fnd_log.level_error,
207: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
208: 'Invalid MR Info..'

Line 206: fnd_log.level_error,

202: FND_MSG_PUB.ADD;
203: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
204: fnd_log.string
205: (
206: fnd_log.level_error,
207: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
208: 'Invalid MR Info..'
209: );
210: END IF;

Line 220: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

216: IF l_mr_rec.type_code='PROGRAM'
217: THEN
218: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TYPE_CODE_PROGRAM');
219: FND_MSG_PUB.ADD;
220: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
221: fnd_log.string
222: (
223: fnd_log.level_error,
224: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 221: fnd_log.string

217: THEN
218: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TYPE_CODE_PROGRAM');
219: FND_MSG_PUB.ADD;
220: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
221: fnd_log.string
222: (
223: fnd_log.level_error,
224: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
225: 'Application usage code PM is invalid for MR with program type'||

Line 223: fnd_log.level_error,

219: FND_MSG_PUB.ADD;
220: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
221: fnd_log.string
222: (
223: fnd_log.level_error,
224: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
225: 'Application usage code PM is invalid for MR with program type'||
226: l_mr_rec.type_code
227: );

Line 239: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

235:
236: END LOOP;
237: END IF;
238:
239: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
240: fnd_log.string
241: (
242: fnd_log.level_statement,
243: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 240: fnd_log.string

236: END LOOP;
237: END IF;
238:
239: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
240: fnd_log.string
241: (
242: fnd_log.level_statement,
243: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
244: 'Before copying mr table of records into doc table of records'

Line 242: fnd_log.level_statement,

238:
239: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
240: fnd_log.string
241: (
242: fnd_log.level_statement,
243: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
244: 'Before copying mr table of records into doc table of records'
245: );
246: END IF;

Line 254: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

250: p_x_association_tbl => p_x_association_tbl,
251: p_x_doc_assos_tbl => l_x_doc_assos_tbl
252: );
253:
254: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
255: fnd_log.string
256: (
257: fnd_log.level_statement,
258: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 255: fnd_log.string

251: p_x_doc_assos_tbl => l_x_doc_assos_tbl
252: );
253:
254: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
255: fnd_log.string
256: (
257: fnd_log.level_statement,
258: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
259: 'Before calling AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION..'

Line 257: fnd_log.level_statement,

253:
254: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
255: fnd_log.string
256: (
257: fnd_log.level_statement,
258: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
259: 'Before calling AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION..'
260: );
261: END IF;

Line 279: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

275: x_msg_data => x_msg_data ,
276: p_x_association_tbl => l_x_doc_assos_tbl
277: ) ;
278:
279: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
280: fnd_log.string
281: (
282: fnd_log.level_statement,
283: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 280: fnd_log.string

276: p_x_association_tbl => l_x_doc_assos_tbl
277: ) ;
278:
279: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
280: fnd_log.string
281: (
282: fnd_log.level_statement,
283: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
284: 'After calling AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION'

Line 282: fnd_log.level_statement,

278:
279: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
280: fnd_log.string
281: (
282: fnd_log.level_statement,
283: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
284: 'After calling AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION'
285: );
286: END IF;

Line 290: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

286: END IF;
287:
288: -- If any severe error occurs, then, abort API.
289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
290: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
291: fnd_log.string
292: (
293: fnd_log.level_statement,
294: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 291: fnd_log.string

287:
288: -- If any severe error occurs, then, abort API.
289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
290: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
291: fnd_log.string
292: (
293: fnd_log.level_statement,
294: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
295: 'Invalid MR Title, Version Number provided'

Line 293: fnd_log.level_statement,

289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
290: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
291: fnd_log.string
292: (
293: fnd_log.level_statement,
294: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
295: 'Invalid MR Title, Version Number provided'
296: );
297: END IF;

Line 300: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

296: );
297: END IF;
298: RAISE FND_API.G_EXC_ERROR;
299: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
300: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
301: fnd_log.string
302: (
303: fnd_log.level_statement,
304: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 301: fnd_log.string

297: END IF;
298: RAISE FND_API.G_EXC_ERROR;
299: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
300: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
301: fnd_log.string
302: (
303: fnd_log.level_statement,
304: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
305: 'Invalid MR Title, Version Number provided'

Line 303: fnd_log.level_statement,

299: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
300: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
301: fnd_log.string
302: (
303: fnd_log.level_statement,
304: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
305: 'Invalid MR Title, Version Number provided'
306: );
307: END IF;

Line 317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

313: THEN
314: COMMIT;
315: END IF;
316:
317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
318: fnd_log.string
319: (
320: fnd_log.level_procedure,
321: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 318: fnd_log.string

314: COMMIT;
315: END IF;
316:
317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
318: fnd_log.string
319: (
320: fnd_log.level_procedure,
321: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
322: 'At the end of PLSQL procedure'

Line 320: fnd_log.level_procedure,

316:
317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
318: fnd_log.string
319: (
320: fnd_log.level_procedure,
321: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
322: 'At the end of PLSQL procedure'
323: );
324: END IF;

Line 333: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

329: Rollback to process_association_pvt;
330: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => fnd_api.g_false);
333: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
334: fnd_log.string
335: (
336: fnd_log.level_statement,
337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 334: fnd_log.string

330: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => fnd_api.g_false);
333: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
334: fnd_log.string
335: (
336: fnd_log.level_statement,
337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
338: 'FND_API.G_EXC_ERROR!!'

Line 336: fnd_log.level_statement,

332: p_encoded => fnd_api.g_false);
333: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
334: fnd_log.string
335: (
336: fnd_log.level_statement,
337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
338: 'FND_API.G_EXC_ERROR!!'
339: );
340: END IF;

Line 349: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

345: Rollback to process_association_pvt;
346: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
347: p_data => x_msg_data,
348: p_encoded => fnd_api.g_false);
349: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
350: fnd_log.string
351: (
352: fnd_log.level_statement,
353: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 350: fnd_log.string

346: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
347: p_data => x_msg_data,
348: p_encoded => fnd_api.g_false);
349: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
350: fnd_log.string
351: (
352: fnd_log.level_statement,
353: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
354: 'FND_API.G_EXC_UNEXPECTED_ERROR!!'

Line 352: fnd_log.level_statement,

348: p_encoded => fnd_api.g_false);
349: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
350: fnd_log.string
351: (
352: fnd_log.level_statement,
353: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
354: 'FND_API.G_EXC_UNEXPECTED_ERROR!!'
355: );
356: END IF;

Line 369: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

365: END IF;
366: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
367: p_data => x_msg_data,
368: p_encoded => fnd_api.g_false);
369: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
370: fnd_log.string
371: (
372: fnd_log.level_statement,
373: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 370: fnd_log.string

366: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
367: p_data => x_msg_data,
368: p_encoded => fnd_api.g_false);
369: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
370: fnd_log.string
371: (
372: fnd_log.level_statement,
373: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
374: 'Un expected error(other errors)!!'

Line 372: fnd_log.level_statement,

368: p_encoded => fnd_api.g_false);
369: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
370: fnd_log.string
371: (
372: fnd_log.level_statement,
373: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
374: 'Un expected error(other errors)!!'
375: );
376: END IF;