469: l_storage_spec, l_storage_spec_vers, l_date,
470: l_formula, l_formula_vers, l_package ;
471: EXIT when c1%notfound;
472:
473: /*Use an FND message and populate it */
474: FND_MESSAGE.SET_NAME('GMD','GMD_SS_LOT_BODY');
475: FND_MESSAGE.SET_TOKEN('BATCH', L_BATCH_NO);
476: FND_MESSAGE.SET_TOKEN('RECIPE', l_Recipe_no);
477: FND_MESSAGE.SET_TOKEN('RCP_VERSION', l_recipe_vers);
470: l_formula, l_formula_vers, l_package ;
471: EXIT when c1%notfound;
472:
473: /*Use an FND message and populate it */
474: FND_MESSAGE.SET_NAME('GMD','GMD_SS_LOT_BODY');
475: FND_MESSAGE.SET_TOKEN('BATCH', L_BATCH_NO);
476: FND_MESSAGE.SET_TOKEN('RECIPE', l_Recipe_no);
477: FND_MESSAGE.SET_TOKEN('RCP_VERSION', l_recipe_vers);
478: FND_MESSAGE.SET_TOKEN('STORAGE_SPEC', l_storage_spec);
471: EXIT when c1%notfound;
472:
473: /*Use an FND message and populate it */
474: FND_MESSAGE.SET_NAME('GMD','GMD_SS_LOT_BODY');
475: FND_MESSAGE.SET_TOKEN('BATCH', L_BATCH_NO);
476: FND_MESSAGE.SET_TOKEN('RECIPE', l_Recipe_no);
477: FND_MESSAGE.SET_TOKEN('RCP_VERSION', l_recipe_vers);
478: FND_MESSAGE.SET_TOKEN('STORAGE_SPEC', l_storage_spec);
479: FND_MESSAGE.SET_TOKEN('STOR_SPEC_VERSION', l_storage_spec_vers);
472:
473: /*Use an FND message and populate it */
474: FND_MESSAGE.SET_NAME('GMD','GMD_SS_LOT_BODY');
475: FND_MESSAGE.SET_TOKEN('BATCH', L_BATCH_NO);
476: FND_MESSAGE.SET_TOKEN('RECIPE', l_Recipe_no);
477: FND_MESSAGE.SET_TOKEN('RCP_VERSION', l_recipe_vers);
478: FND_MESSAGE.SET_TOKEN('STORAGE_SPEC', l_storage_spec);
479: FND_MESSAGE.SET_TOKEN('STOR_SPEC_VERSION', l_storage_spec_vers);
480: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resource);
473: /*Use an FND message and populate it */
474: FND_MESSAGE.SET_NAME('GMD','GMD_SS_LOT_BODY');
475: FND_MESSAGE.SET_TOKEN('BATCH', L_BATCH_NO);
476: FND_MESSAGE.SET_TOKEN('RECIPE', l_Recipe_no);
477: FND_MESSAGE.SET_TOKEN('RCP_VERSION', l_recipe_vers);
478: FND_MESSAGE.SET_TOKEN('STORAGE_SPEC', l_storage_spec);
479: FND_MESSAGE.SET_TOKEN('STOR_SPEC_VERSION', l_storage_spec_vers);
480: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resource);
481: FND_MESSAGE.SET_TOKEN('STORAGE_SUBINVENTORY',l_storage_subinventory);
474: FND_MESSAGE.SET_NAME('GMD','GMD_SS_LOT_BODY');
475: FND_MESSAGE.SET_TOKEN('BATCH', L_BATCH_NO);
476: FND_MESSAGE.SET_TOKEN('RECIPE', l_Recipe_no);
477: FND_MESSAGE.SET_TOKEN('RCP_VERSION', l_recipe_vers);
478: FND_MESSAGE.SET_TOKEN('STORAGE_SPEC', l_storage_spec);
479: FND_MESSAGE.SET_TOKEN('STOR_SPEC_VERSION', l_storage_spec_vers);
480: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resource);
481: FND_MESSAGE.SET_TOKEN('STORAGE_SUBINVENTORY',l_storage_subinventory);
482: FND_MESSAGE.SET_TOKEN('STORAGE_LOCATOR',l_storage_locator);
475: FND_MESSAGE.SET_TOKEN('BATCH', L_BATCH_NO);
476: FND_MESSAGE.SET_TOKEN('RECIPE', l_Recipe_no);
477: FND_MESSAGE.SET_TOKEN('RCP_VERSION', l_recipe_vers);
478: FND_MESSAGE.SET_TOKEN('STORAGE_SPEC', l_storage_spec);
479: FND_MESSAGE.SET_TOKEN('STOR_SPEC_VERSION', l_storage_spec_vers);
480: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resource);
481: FND_MESSAGE.SET_TOKEN('STORAGE_SUBINVENTORY',l_storage_subinventory);
482: FND_MESSAGE.SET_TOKEN('STORAGE_LOCATOR',l_storage_locator);
483: FND_MESSAGE.SET_TOKEN('PACKAGE',l_package);
476: FND_MESSAGE.SET_TOKEN('RECIPE', l_Recipe_no);
477: FND_MESSAGE.SET_TOKEN('RCP_VERSION', l_recipe_vers);
478: FND_MESSAGE.SET_TOKEN('STORAGE_SPEC', l_storage_spec);
479: FND_MESSAGE.SET_TOKEN('STOR_SPEC_VERSION', l_storage_spec_vers);
480: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resource);
481: FND_MESSAGE.SET_TOKEN('STORAGE_SUBINVENTORY',l_storage_subinventory);
482: FND_MESSAGE.SET_TOKEN('STORAGE_LOCATOR',l_storage_locator);
483: FND_MESSAGE.SET_TOKEN('PACKAGE',l_package);
484: FND_MESSAGE.SET_TOKEN('FORMULA',l_formula);
477: FND_MESSAGE.SET_TOKEN('RCP_VERSION', l_recipe_vers);
478: FND_MESSAGE.SET_TOKEN('STORAGE_SPEC', l_storage_spec);
479: FND_MESSAGE.SET_TOKEN('STOR_SPEC_VERSION', l_storage_spec_vers);
480: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resource);
481: FND_MESSAGE.SET_TOKEN('STORAGE_SUBINVENTORY',l_storage_subinventory);
482: FND_MESSAGE.SET_TOKEN('STORAGE_LOCATOR',l_storage_locator);
483: FND_MESSAGE.SET_TOKEN('PACKAGE',l_package);
484: FND_MESSAGE.SET_TOKEN('FORMULA',l_formula);
485: FND_MESSAGE.SET_TOKEN('FORM_VER',l_formula_vers);
478: FND_MESSAGE.SET_TOKEN('STORAGE_SPEC', l_storage_spec);
479: FND_MESSAGE.SET_TOKEN('STOR_SPEC_VERSION', l_storage_spec_vers);
480: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resource);
481: FND_MESSAGE.SET_TOKEN('STORAGE_SUBINVENTORY',l_storage_subinventory);
482: FND_MESSAGE.SET_TOKEN('STORAGE_LOCATOR',l_storage_locator);
483: FND_MESSAGE.SET_TOKEN('PACKAGE',l_package);
484: FND_MESSAGE.SET_TOKEN('FORMULA',l_formula);
485: FND_MESSAGE.SET_TOKEN('FORM_VER',l_formula_vers);
486: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY',l_sample_qty);
479: FND_MESSAGE.SET_TOKEN('STOR_SPEC_VERSION', l_storage_spec_vers);
480: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resource);
481: FND_MESSAGE.SET_TOKEN('STORAGE_SUBINVENTORY',l_storage_subinventory);
482: FND_MESSAGE.SET_TOKEN('STORAGE_LOCATOR',l_storage_locator);
483: FND_MESSAGE.SET_TOKEN('PACKAGE',l_package);
484: FND_MESSAGE.SET_TOKEN('FORMULA',l_formula);
485: FND_MESSAGE.SET_TOKEN('FORM_VER',l_formula_vers);
486: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY',l_sample_qty);
487: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM',l_sample_uom);
480: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resource);
481: FND_MESSAGE.SET_TOKEN('STORAGE_SUBINVENTORY',l_storage_subinventory);
482: FND_MESSAGE.SET_TOKEN('STORAGE_LOCATOR',l_storage_locator);
483: FND_MESSAGE.SET_TOKEN('PACKAGE',l_package);
484: FND_MESSAGE.SET_TOKEN('FORMULA',l_formula);
485: FND_MESSAGE.SET_TOKEN('FORM_VER',l_formula_vers);
486: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY',l_sample_qty);
487: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM',l_sample_uom);
488: FND_MESSAGE.SET_TOKEN('STORAGE_DATE',l_date);
481: FND_MESSAGE.SET_TOKEN('STORAGE_SUBINVENTORY',l_storage_subinventory);
482: FND_MESSAGE.SET_TOKEN('STORAGE_LOCATOR',l_storage_locator);
483: FND_MESSAGE.SET_TOKEN('PACKAGE',l_package);
484: FND_MESSAGE.SET_TOKEN('FORMULA',l_formula);
485: FND_MESSAGE.SET_TOKEN('FORM_VER',l_formula_vers);
486: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY',l_sample_qty);
487: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM',l_sample_uom);
488: FND_MESSAGE.SET_TOKEN('STORAGE_DATE',l_date);
489:
482: FND_MESSAGE.SET_TOKEN('STORAGE_LOCATOR',l_storage_locator);
483: FND_MESSAGE.SET_TOKEN('PACKAGE',l_package);
484: FND_MESSAGE.SET_TOKEN('FORMULA',l_formula);
485: FND_MESSAGE.SET_TOKEN('FORM_VER',l_formula_vers);
486: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY',l_sample_qty);
487: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM',l_sample_uom);
488: FND_MESSAGE.SET_TOKEN('STORAGE_DATE',l_date);
489:
490:
483: FND_MESSAGE.SET_TOKEN('PACKAGE',l_package);
484: FND_MESSAGE.SET_TOKEN('FORMULA',l_formula);
485: FND_MESSAGE.SET_TOKEN('FORM_VER',l_formula_vers);
486: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY',l_sample_qty);
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() );
484: FND_MESSAGE.SET_TOKEN('FORMULA',l_formula);
485: FND_MESSAGE.SET_TOKEN('FORM_VER',l_formula_vers);
486: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY',l_sample_qty);
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 );
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: