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.
[Home] [Help]
APPS.PO_EMAIL_GENERATE dependencies on FND_LOG
Line 4311: -- in the FND_LOG_MESSAGES table.
4307: -- Bug 2792156
4308: -- When any type of exception occurs during the generation of the Terms and Conditions file,
4309: -- it will no longer be raised. Instead, the Email notification will be sent out as
4310: -- normal but without any attachment of Terms and Conditions and a message will be logged
4311: -- in the FND_LOG_MESSAGES table.
4312: EXCEPTION
4313: WHEN UTL_FILE.INVALID_PATH THEN
4314: l_document := '
';
4315: WF_NOTIFICATION.WriteToClob(document, l_document);
Line 4316: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4312: EXCEPTION
4313: WHEN UTL_FILE.INVALID_PATH THEN
4314: l_document := '
';
4315: WF_NOTIFICATION.WriteToClob(document, l_document);
4316: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4317: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4318: 'generate_terms: Exception Type: INVALID_PATH' ||x_progress||sqlcode);
4319: END IF;
4320: UTL_FILE.FCLOSE(v_filehandle);
Line 4317: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4313: WHEN UTL_FILE.INVALID_PATH THEN
4314: l_document := '
';
4315: WF_NOTIFICATION.WriteToClob(document, l_document);
4316: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4317: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4318: 'generate_terms: Exception Type: INVALID_PATH' ||x_progress||sqlcode);
4319: END IF;
4320: UTL_FILE.FCLOSE(v_filehandle);
4321:
Line 4325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4321:
4322: WHEN UTL_FILE.INVALID_MODE THEN
4323: l_document := '
';
4324: WF_NOTIFICATION.WriteToClob(document, l_document);
4325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4326: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4327: 'generate_terms: Exception Type: INVALID_MODE' ||x_progress||sqlcode);
4328: END IF;
4329: UTL_FILE.FCLOSE(v_filehandle);
Line 4326: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4322: WHEN UTL_FILE.INVALID_MODE THEN
4323: l_document := '
';
4324: WF_NOTIFICATION.WriteToClob(document, l_document);
4325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4326: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4327: 'generate_terms: Exception Type: INVALID_MODE' ||x_progress||sqlcode);
4328: END IF;
4329: UTL_FILE.FCLOSE(v_filehandle);
4330:
Line 4334: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4330:
4331: WHEN UTL_FILE.INTERNAL_ERROR THEN
4332: l_document := '
';
4333: WF_NOTIFICATION.WriteToClob(document, l_document);
4334: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4335: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4336: 'generate_terms: Exception Type: INTERNAL_ERROR' ||x_progress||sqlcode);
4337: END IF;
4338: UTL_FILE.FCLOSE(v_filehandle);
Line 4335: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4331: WHEN UTL_FILE.INTERNAL_ERROR THEN
4332: l_document := '
';
4333: WF_NOTIFICATION.WriteToClob(document, l_document);
4334: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4335: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4336: 'generate_terms: Exception Type: INTERNAL_ERROR' ||x_progress||sqlcode);
4337: END IF;
4338: UTL_FILE.FCLOSE(v_filehandle);
4339:
Line 4343: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4339:
4340: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
4341: l_document := '
';
4342: WF_NOTIFICATION.WriteToClob(document, l_document);
4343: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4344: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4345: 'generate_terms: Exception Type: INVALID_FILEHANDLE' ||x_progress||sqlcode);
4346: END IF;
4347: UTL_FILE.FCLOSE(v_filehandle);
Line 4344: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4340: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
4341: l_document := '
';
4342: WF_NOTIFICATION.WriteToClob(document, l_document);
4343: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4344: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4345: 'generate_terms: Exception Type: INVALID_FILEHANDLE' ||x_progress||sqlcode);
4346: END IF;
4347: UTL_FILE.FCLOSE(v_filehandle);
4348:
Line 4352: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4348:
4349: WHEN UTL_FILE.INVALID_OPERATION THEN
4350: l_document := '
';
4351: WF_NOTIFICATION.WriteToClob(document, l_document);
4352: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4353: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4354: 'generate_terms: Exception Type: INVALID_OPERATION' ||x_progress||sqlcode);
4355: END IF;
4356: UTL_FILE.FCLOSE(v_filehandle);
Line 4353: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4349: WHEN UTL_FILE.INVALID_OPERATION THEN
4350: l_document := '
';
4351: WF_NOTIFICATION.WriteToClob(document, l_document);
4352: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4353: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4354: 'generate_terms: Exception Type: INVALID_OPERATION' ||x_progress||sqlcode);
4355: END IF;
4356: UTL_FILE.FCLOSE(v_filehandle);
4357:
Line 4361: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4357:
4358: WHEN UTL_FILE.READ_ERROR THEN
4359: l_document := '
';
4360: WF_NOTIFICATION.WriteToClob(document, l_document);
4361: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4362: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4363: 'generate_terms: Exception Type: READ_ERROR' ||x_progress||sqlcode);
4364: END IF;
4365: UTL_FILE.FCLOSE(v_filehandle);
Line 4362: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4358: WHEN UTL_FILE.READ_ERROR THEN
4359: l_document := '
';
4360: WF_NOTIFICATION.WriteToClob(document, l_document);
4361: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4362: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4363: 'generate_terms: Exception Type: READ_ERROR' ||x_progress||sqlcode);
4364: END IF;
4365: UTL_FILE.FCLOSE(v_filehandle);
4366:
Line 4370: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4366:
4367: WHEN OTHERS THEN
4368: l_document := '
';
4369: WF_NOTIFICATION.WriteToClob(document, l_document);
4370: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4371: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4372: 'generate_terms: Exception Type: OTHERS' ||x_progress||sqlcode);
4373: END IF;
4374: UTL_FILE.FCLOSE(v_filehandle);
Line 4371: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4367: WHEN OTHERS THEN
4368: l_document := '
';
4369: WF_NOTIFICATION.WriteToClob(document, l_document);
4370: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4371: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4372: 'generate_terms: Exception Type: OTHERS' ||x_progress||sqlcode);
4373: END IF;
4374: UTL_FILE.FCLOSE(v_filehandle);
4375: END;