455:
456:
457: BEGIN
458: /* Add a new line */
459: WF_NOTIFICATION.WriteToClob(document,NL );
460:
461: OPEN C1;
462: LOOP
463:
487: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM',l_sample_uom);
488: FND_MESSAGE.SET_TOKEN('STORAGE_DATE',l_date);
489:
490:
491: WF_NOTIFICATION.WriteToClob(document, FND_MESSAGE.GET() );
492: WF_NOTIFICATION.WriteToClob(document, NL );
493: WF_NOTIFICATION.WriteToClob(document, NL );
494:
495:
488: FND_MESSAGE.SET_TOKEN('STORAGE_DATE',l_date);
489:
490:
491: WF_NOTIFICATION.WriteToClob(document, FND_MESSAGE.GET() );
492: WF_NOTIFICATION.WriteToClob(document, NL );
493: WF_NOTIFICATION.WriteToClob(document, NL );
494:
495:
496: END LOOP;
489:
490:
491: WF_NOTIFICATION.WriteToClob(document, FND_MESSAGE.GET() );
492: WF_NOTIFICATION.WriteToClob(document, NL );
493: WF_NOTIFICATION.WriteToClob(document, NL );
494:
495:
496: END LOOP;
497: CLOSE C1;