DBA Data[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;