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 4811: -- in the FND_LOG_MESSAGES table.
4807: -- Bug 2792156
4808: -- When any type of exception occurs during the generation of the Terms and Conditions file,
4809: -- it will no longer be raised. Instead, the Email notification will be sent out as
4810: -- normal but without any attachment of Terms and Conditions and a message will be logged
4811: -- in the FND_LOG_MESSAGES table.
4812: EXCEPTION
4813: WHEN UTL_FILE.INVALID_PATH THEN
4814: l_document := '
';
4815: WF_NOTIFICATION.WriteToClob(document, l_document);
Line 4816: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4812: EXCEPTION
4813: WHEN UTL_FILE.INVALID_PATH THEN
4814: l_document := '
';
4815: WF_NOTIFICATION.WriteToClob(document, l_document);
4816: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4817: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4818: 'generate_terms: Exception Type: INVALID_PATH' ||x_progress||sqlcode);
4819: END IF;
4820: UTL_FILE.FCLOSE(v_filehandle);
Line 4817: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4813: WHEN UTL_FILE.INVALID_PATH THEN
4814: l_document := '
';
4815: WF_NOTIFICATION.WriteToClob(document, l_document);
4816: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4817: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4818: 'generate_terms: Exception Type: INVALID_PATH' ||x_progress||sqlcode);
4819: END IF;
4820: UTL_FILE.FCLOSE(v_filehandle);
4821:
Line 4825: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4821:
4822: WHEN UTL_FILE.INVALID_MODE THEN
4823: l_document := '
';
4824: WF_NOTIFICATION.WriteToClob(document, l_document);
4825: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4826: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4827: 'generate_terms: Exception Type: INVALID_MODE' ||x_progress||sqlcode);
4828: END IF;
4829: UTL_FILE.FCLOSE(v_filehandle);
Line 4826: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4822: WHEN UTL_FILE.INVALID_MODE THEN
4823: l_document := '
';
4824: WF_NOTIFICATION.WriteToClob(document, l_document);
4825: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4826: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4827: 'generate_terms: Exception Type: INVALID_MODE' ||x_progress||sqlcode);
4828: END IF;
4829: UTL_FILE.FCLOSE(v_filehandle);
4830:
Line 4834: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4830:
4831: WHEN UTL_FILE.INTERNAL_ERROR THEN
4832: l_document := '
';
4833: WF_NOTIFICATION.WriteToClob(document, l_document);
4834: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4835: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4836: 'generate_terms: Exception Type: INTERNAL_ERROR' ||x_progress||sqlcode);
4837: END IF;
4838: UTL_FILE.FCLOSE(v_filehandle);
Line 4835: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4831: WHEN UTL_FILE.INTERNAL_ERROR THEN
4832: l_document := '
';
4833: WF_NOTIFICATION.WriteToClob(document, l_document);
4834: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4835: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4836: 'generate_terms: Exception Type: INTERNAL_ERROR' ||x_progress||sqlcode);
4837: END IF;
4838: UTL_FILE.FCLOSE(v_filehandle);
4839:
Line 4843: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4839:
4840: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
4841: l_document := '
';
4842: WF_NOTIFICATION.WriteToClob(document, l_document);
4843: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4844: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4845: 'generate_terms: Exception Type: INVALID_FILEHANDLE' ||x_progress||sqlcode);
4846: END IF;
4847: UTL_FILE.FCLOSE(v_filehandle);
Line 4844: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4840: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
4841: l_document := '
';
4842: WF_NOTIFICATION.WriteToClob(document, l_document);
4843: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4844: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4845: 'generate_terms: Exception Type: INVALID_FILEHANDLE' ||x_progress||sqlcode);
4846: END IF;
4847: UTL_FILE.FCLOSE(v_filehandle);
4848:
Line 4852: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4848:
4849: WHEN UTL_FILE.INVALID_OPERATION THEN
4850: l_document := '
';
4851: WF_NOTIFICATION.WriteToClob(document, l_document);
4852: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4853: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4854: 'generate_terms: Exception Type: INVALID_OPERATION' ||x_progress||sqlcode);
4855: END IF;
4856: UTL_FILE.FCLOSE(v_filehandle);
Line 4853: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4849: WHEN UTL_FILE.INVALID_OPERATION THEN
4850: l_document := '
';
4851: WF_NOTIFICATION.WriteToClob(document, l_document);
4852: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4853: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4854: 'generate_terms: Exception Type: INVALID_OPERATION' ||x_progress||sqlcode);
4855: END IF;
4856: UTL_FILE.FCLOSE(v_filehandle);
4857:
Line 4861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4857:
4858: WHEN UTL_FILE.READ_ERROR THEN
4859: l_document := '
';
4860: WF_NOTIFICATION.WriteToClob(document, l_document);
4861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4862: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4863: 'generate_terms: Exception Type: READ_ERROR' ||x_progress||sqlcode);
4864: END IF;
4865: UTL_FILE.FCLOSE(v_filehandle);
Line 4862: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4858: WHEN UTL_FILE.READ_ERROR THEN
4859: l_document := '
';
4860: WF_NOTIFICATION.WriteToClob(document, l_document);
4861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4862: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4863: 'generate_terms: Exception Type: READ_ERROR' ||x_progress||sqlcode);
4864: END IF;
4865: UTL_FILE.FCLOSE(v_filehandle);
4866:
Line 4870: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4866:
4867: WHEN OTHERS THEN
4868: l_document := '
';
4869: WF_NOTIFICATION.WriteToClob(document, l_document);
4870: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4871: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4872: 'generate_terms: Exception Type: OTHERS' ||x_progress||sqlcode);
4873: END IF;
4874: UTL_FILE.FCLOSE(v_filehandle);
Line 4871: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4867: WHEN OTHERS THEN
4868: l_document := '
';
4869: WF_NOTIFICATION.WriteToClob(document, l_document);
4870: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
4871: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, c_log_head || l_api_name ||'.EXCEPTION',
4872: 'generate_terms: Exception Type: OTHERS' ||x_progress||sqlcode);
4873: END IF;
4874: UTL_FILE.FCLOSE(v_filehandle);
4875: END;