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 464: WF_NOTIFICATION.WriteToClob(document, ' ');
460: end if;
461:
462: if(l_document_status is null or
463: l_document_status in ('IN PROCESS', 'INCOMPLETE', 'REQUIRES REAPPROVAL')) then
464: WF_NOTIFICATION.WriteToClob(document, ' ');
465: return;
466: end if;
467:
468:
Line 1730: WF_NOTIFICATION.WriteToClob(document, l_document);
1726:
1727: END IF;
1728:
1729: /* writing the email body into a clob variable */
1730: WF_NOTIFICATION.WriteToClob(document, l_document);
1731: l_document := null;
1732:
1733: end loop;
1734:
Line 1766: WF_NOTIFICATION.WriteToClob(document, l_document);
1762: end if;
1763:
1764: l_document := l_document || '
' || NL;
1765:
1766: WF_NOTIFICATION.WriteToClob(document, l_document);
1767: end if;
1768:
1769: ELSE
1770:
Line 2316: WF_NOTIFICATION.WriteToClob(document, l_document);
2312: -- l_document := l_document || 'Shipment-level attachment' || NL;
2313:
2314: l_document := l_document || NL;
2315:
2316: WF_NOTIFICATION.WriteToClob(document, l_document);
2317: l_document := null;
2318: end loop;
2319:
2320: IF (l_document_type = 'PO') THEN
Line 2337: WF_NOTIFICATION.WriteToClob(document, l_document);
2333: l_document := l_document || '(' || l_currency_code || ')' ||
2334: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
2335: || NL;
2336: l_document := l_document || NL;
2337: WF_NOTIFICATION.WriteToClob(document, l_document);
2338: end if;
2339:
2340: END IF;
2341:
Line 2347: WF_NOTIFICATION.WriteToClob(document, 'failed');
2343:
2344: EXCEPTION
2345: WHEN OTHERS THEN
2346:
2347: WF_NOTIFICATION.WriteToClob(document, 'failed');
2348:
2349: RAISE;
2350:
2351: END;
Line 4146: For older wf notifications that send in documentid and documenttypecode instead of
4142:
4143:
4144: /* EMAILPO FPH START
4145: set the context so fnd_profile.get methods work correctly
4146: For older wf notifications that send in documentid and documenttypecode instead of
4147: itemtype and itemkey combination the following code to get the user_id, app_id and
4148: resp_id will fail. Will trap and ignore it. The consequence is that tandc profile
4149: options will only be considered at site level(consistent with Previous Behaviour/Bug)
4150: */
Line 4184: WF_NOTIFICATION.WriteToClob(document, ' ');
4180: end if;
4181:
4182: if(l_document_status is null or
4183: l_document_status in ('IN PROCESS', 'INCOMPLETE', 'REQUIRES REAPPROVAL')) then
4184: WF_NOTIFICATION.WriteToClob(document, ' ');
4185: return;
4186: end if;
4187:
4188:
Line 4229: WF_NOTIFICATION.WriteToClob(document, l_document);
4225: l_document := '
';
4226: else
4227: l_document := ' ';
4228: end if;
4229: WF_NOTIFICATION.WriteToClob(document, l_document);
4230: ELSE
4231:
4232: x_progress := '001';
4233:
Line 4264: WF_NOTIFICATION.WriteToClob(document, l_document);
4260: /* write the contents into the document */
4261: UTL_FILE.GET_LINE(v_filehandle,v_terms);
4262: l_document := l_document || v_terms || NL;
4263: l_document := l_document || '
' || NL;
4264: WF_NOTIFICATION.WriteToClob(document, l_document);
4265: l_document := null;
4266:
4267: x_progress := '004';
4268:
Line 4277: WF_NOTIFICATION.WriteToClob(document, '');
4273:
4274: end loop;
4275:
4276: if l_document is null then
4277: WF_NOTIFICATION.WriteToClob(document, '
');
4278: end if;
4279:
4280: ELSE
4281:
Line 4289: WF_NOTIFICATION.WriteToClob(document, l_document);
4285: x_progress := '003';
4286: /* write the contents into the document */
4287: UTL_FILE.GET_LINE(v_filehandle,v_terms);
4288: l_document := l_document || v_terms || NL;
4289: WF_NOTIFICATION.WriteToClob(document, l_document);
4290: x_progress := '004';
4291:
4292: exception
4293: when no_data_found then
Line 4315: WF_NOTIFICATION.WriteToClob(document, l_document);
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);
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;
Line 4324: WF_NOTIFICATION.WriteToClob(document, l_document);
4320: UTL_FILE.FCLOSE(v_filehandle);
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;
Line 4333: WF_NOTIFICATION.WriteToClob(document, l_document);
4329: UTL_FILE.FCLOSE(v_filehandle);
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;
Line 4342: WF_NOTIFICATION.WriteToClob(document, l_document);
4338: UTL_FILE.FCLOSE(v_filehandle);
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;
Line 4351: WF_NOTIFICATION.WriteToClob(document, l_document);
4347: UTL_FILE.FCLOSE(v_filehandle);
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;
Line 4360: WF_NOTIFICATION.WriteToClob(document, l_document);
4356: UTL_FILE.FCLOSE(v_filehandle);
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;
Line 4369: WF_NOTIFICATION.WriteToClob(document, l_document);
4365: UTL_FILE.FCLOSE(v_filehandle);
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;