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 WF_NOTIFICATION
Line 510: WF_NOTIFICATION.WriteToClob(document, ' ');
506: end if;
507:
508: if(l_document_status is null or
509: l_document_status in ('IN PROCESS', 'INCOMPLETE', 'REQUIRES REAPPROVAL')) then
510: WF_NOTIFICATION.WriteToClob(document, ' ');
511: return;
512: end if;
513:
514: --
Line 1924: WF_NOTIFICATION.WriteToClob(document, l_document);
1920:
1921: END IF;
1922:
1923: /* writing the email body into a clob variable */
1924: WF_NOTIFICATION.WriteToClob(document, l_document);
1925: l_document := null;
1926:
1927: end loop;
1928:
Line 1960: WF_NOTIFICATION.WriteToClob(document, l_document);
1956: end if;
1957:
1958: l_document := l_document || '
' || NL;
1959:
1960: WF_NOTIFICATION.WriteToClob(document, l_document);
1961: end if;
1962:
1963: ELSE
1964:
Line 2537: WF_NOTIFICATION.WriteToClob(document, l_document);
2533: -- l_document := l_document || 'Shipment-level attachment' || NL;
2534:
2535: l_document := l_document || NL;
2536:
2537: WF_NOTIFICATION.WriteToClob(document, l_document);
2538: l_document := null;
2539: end loop;
2540:
2541: IF (l_document_type = 'PO') THEN
Line 2558: WF_NOTIFICATION.WriteToClob(document, l_document);
2554: l_document := l_document || '(' || l_currency_code || ')' ||
2555: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
2556: || NL;
2557: l_document := l_document || NL;
2558: WF_NOTIFICATION.WriteToClob(document, l_document);
2559: end if;
2560:
2561: END IF;
2562:
Line 2568: WF_NOTIFICATION.WriteToClob(document, 'failed');
2564:
2565: EXCEPTION
2566: WHEN OTHERS THEN
2567:
2568: WF_NOTIFICATION.WriteToClob(document, 'failed');
2569:
2570: RAISE;
2571:
2572: END;
Line 4613: For older wf notifications that send in documentid and documenttypecode instead of
4609:
4610:
4611: /* EMAILPO FPH START
4612: set the context so fnd_profile.get methods work correctly
4613: For older wf notifications that send in documentid and documenttypecode instead of
4614: itemtype and itemkey combination the following code to get the user_id, app_id and
4615: resp_id will fail. Will trap and ignore it. The consequence is that tandc profile
4616: options will only be considered at site level(consistent with Previous Behaviour/Bug)
4617: */
Line 4677: WF_NOTIFICATION.WriteToClob(document, ' ');
4673: --
4674:
4675: if(l_document_status is null or
4676: l_document_status in ('IN PROCESS', 'INCOMPLETE', 'REQUIRES REAPPROVAL')) then
4677: WF_NOTIFICATION.WriteToClob(document, ' ');
4678: return;
4679: end if;
4680:
4681:
Line 4729: WF_NOTIFICATION.WriteToClob(document, l_document);
4725: l_document := '
';
4726: else
4727: l_document := ' ';
4728: end if;
4729: WF_NOTIFICATION.WriteToClob(document, l_document);
4730: ELSE
4731:
4732: x_progress := '001';
4733:
Line 4764: WF_NOTIFICATION.WriteToClob(document, l_document);
4760: /* write the contents into the document */
4761: UTL_FILE.GET_LINE(v_filehandle,v_terms);
4762: l_document := l_document || v_terms || NL;
4763: l_document := l_document || '
' || NL;
4764: WF_NOTIFICATION.WriteToClob(document, l_document);
4765: l_document := null;
4766:
4767: x_progress := '004';
4768:
Line 4777: WF_NOTIFICATION.WriteToClob(document, '');
4773:
4774: end loop;
4775:
4776: if l_document is null then
4777: WF_NOTIFICATION.WriteToClob(document, '
');
4778: end if;
4779:
4780: ELSE
4781:
Line 4789: WF_NOTIFICATION.WriteToClob(document, l_document);
4785: x_progress := '003';
4786: /* write the contents into the document */
4787: UTL_FILE.GET_LINE(v_filehandle,v_terms);
4788: l_document := l_document || v_terms || NL;
4789: WF_NOTIFICATION.WriteToClob(document, l_document);
4790: x_progress := '004';
4791:
4792: exception
4793: when no_data_found then
Line 4815: WF_NOTIFICATION.WriteToClob(document, l_document);
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);
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;
Line 4824: WF_NOTIFICATION.WriteToClob(document, l_document);
4820: UTL_FILE.FCLOSE(v_filehandle);
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;
Line 4833: WF_NOTIFICATION.WriteToClob(document, l_document);
4829: UTL_FILE.FCLOSE(v_filehandle);
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;
Line 4842: WF_NOTIFICATION.WriteToClob(document, l_document);
4838: UTL_FILE.FCLOSE(v_filehandle);
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;
Line 4851: WF_NOTIFICATION.WriteToClob(document, l_document);
4847: UTL_FILE.FCLOSE(v_filehandle);
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;
Line 4860: WF_NOTIFICATION.WriteToClob(document, l_document);
4856: UTL_FILE.FCLOSE(v_filehandle);
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;
Line 4869: WF_NOTIFICATION.WriteToClob(document, l_document);
4865: UTL_FILE.FCLOSE(v_filehandle);
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;