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.

APPS.GMD_QC_LABELS_UTIL dependencies on FND_FILE

Line 319: FND_FILE.PUT(FND_FILE.OUTPUT,'ORGN CODE '|| l_delim);

315: -- l_delim := ',';
316:
317: -- Define Static Headings
318:
319: FND_FILE.PUT(FND_FILE.OUTPUT,'ORGN CODE '|| l_delim);
320: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE NO' || l_delim);
321: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DESC' || l_delim);
322: -- FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DISPOSITION' || l_delim);
323: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE QTY' || l_delim);

Line 320: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE NO' || l_delim);

316:
317: -- Define Static Headings
318:
319: FND_FILE.PUT(FND_FILE.OUTPUT,'ORGN CODE '|| l_delim);
320: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE NO' || l_delim);
321: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DESC' || l_delim);
322: -- FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DISPOSITION' || l_delim);
323: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE QTY' || l_delim);
324: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE UOM' || l_delim);

Line 321: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DESC' || l_delim);

317: -- Define Static Headings
318:
319: FND_FILE.PUT(FND_FILE.OUTPUT,'ORGN CODE '|| l_delim);
320: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE NO' || l_delim);
321: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DESC' || l_delim);
322: -- FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DISPOSITION' || l_delim);
323: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE QTY' || l_delim);
324: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE UOM' || l_delim);
325: -- Bug 3088216: added Retain As to headings

Line 322: -- FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DISPOSITION' || l_delim);

318:
319: FND_FILE.PUT(FND_FILE.OUTPUT,'ORGN CODE '|| l_delim);
320: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE NO' || l_delim);
321: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DESC' || l_delim);
322: -- FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DISPOSITION' || l_delim);
323: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE QTY' || l_delim);
324: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE UOM' || l_delim);
325: -- Bug 3088216: added Retain As to headings
326: FND_FILE.PUT(FND_FILE.OUTPUT,'RETAIN AS ' || l_delim);

Line 323: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE QTY' || l_delim);

319: FND_FILE.PUT(FND_FILE.OUTPUT,'ORGN CODE '|| l_delim);
320: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE NO' || l_delim);
321: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DESC' || l_delim);
322: -- FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DISPOSITION' || l_delim);
323: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE QTY' || l_delim);
324: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE UOM' || l_delim);
325: -- Bug 3088216: added Retain As to headings
326: FND_FILE.PUT(FND_FILE.OUTPUT,'RETAIN AS ' || l_delim);
327: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM CODE ' || l_delim); --BUG# 4612611

Line 324: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE UOM' || l_delim);

320: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE NO' || l_delim);
321: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DESC' || l_delim);
322: -- FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DISPOSITION' || l_delim);
323: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE QTY' || l_delim);
324: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE UOM' || l_delim);
325: -- Bug 3088216: added Retain As to headings
326: FND_FILE.PUT(FND_FILE.OUTPUT,'RETAIN AS ' || l_delim);
327: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM CODE ' || l_delim); --BUG# 4612611
328: FND_FILE.PUT(FND_FILE.OUTPUT,'REVISION ' || l_delim); --BUG# 4612611

Line 326: FND_FILE.PUT(FND_FILE.OUTPUT,'RETAIN AS ' || l_delim);

322: -- FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE DISPOSITION' || l_delim);
323: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE QTY' || l_delim);
324: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE UOM' || l_delim);
325: -- Bug 3088216: added Retain As to headings
326: FND_FILE.PUT(FND_FILE.OUTPUT,'RETAIN AS ' || l_delim);
327: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM CODE ' || l_delim); --BUG# 4612611
328: FND_FILE.PUT(FND_FILE.OUTPUT,'REVISION ' || l_delim); --BUG# 4612611
329: FND_FILE.PUT(FND_FILE.OUTPUT,'PRIORITY' || l_delim);
330: FND_FILE.PUT(FND_FILE.OUTPUT,'SOURCE' || l_delim);

Line 327: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM CODE ' || l_delim); --BUG# 4612611

323: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE QTY' || l_delim);
324: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE UOM' || l_delim);
325: -- Bug 3088216: added Retain As to headings
326: FND_FILE.PUT(FND_FILE.OUTPUT,'RETAIN AS ' || l_delim);
327: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM CODE ' || l_delim); --BUG# 4612611
328: FND_FILE.PUT(FND_FILE.OUTPUT,'REVISION ' || l_delim); --BUG# 4612611
329: FND_FILE.PUT(FND_FILE.OUTPUT,'PRIORITY' || l_delim);
330: FND_FILE.PUT(FND_FILE.OUTPUT,'SOURCE' || l_delim);
331: --JD

Line 328: FND_FILE.PUT(FND_FILE.OUTPUT,'REVISION ' || l_delim); --BUG# 4612611

324: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE UOM' || l_delim);
325: -- Bug 3088216: added Retain As to headings
326: FND_FILE.PUT(FND_FILE.OUTPUT,'RETAIN AS ' || l_delim);
327: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM CODE ' || l_delim); --BUG# 4612611
328: FND_FILE.PUT(FND_FILE.OUTPUT,'REVISION ' || l_delim); --BUG# 4612611
329: FND_FILE.PUT(FND_FILE.OUTPUT,'PRIORITY' || l_delim);
330: FND_FILE.PUT(FND_FILE.OUTPUT,'SOURCE' || l_delim);
331: --JD
332: -- Changed label whse_code to subinventory.

Line 329: FND_FILE.PUT(FND_FILE.OUTPUT,'PRIORITY' || l_delim);

325: -- Bug 3088216: added Retain As to headings
326: FND_FILE.PUT(FND_FILE.OUTPUT,'RETAIN AS ' || l_delim);
327: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM CODE ' || l_delim); --BUG# 4612611
328: FND_FILE.PUT(FND_FILE.OUTPUT,'REVISION ' || l_delim); --BUG# 4612611
329: FND_FILE.PUT(FND_FILE.OUTPUT,'PRIORITY' || l_delim);
330: FND_FILE.PUT(FND_FILE.OUTPUT,'SOURCE' || l_delim);
331: --JD
332: -- Changed label whse_code to subinventory.
333: -- Changed label location to locator.

Line 330: FND_FILE.PUT(FND_FILE.OUTPUT,'SOURCE' || l_delim);

326: FND_FILE.PUT(FND_FILE.OUTPUT,'RETAIN AS ' || l_delim);
327: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM CODE ' || l_delim); --BUG# 4612611
328: FND_FILE.PUT(FND_FILE.OUTPUT,'REVISION ' || l_delim); --BUG# 4612611
329: FND_FILE.PUT(FND_FILE.OUTPUT,'PRIORITY' || l_delim);
330: FND_FILE.PUT(FND_FILE.OUTPUT,'SOURCE' || l_delim);
331: --JD
332: -- Changed label whse_code to subinventory.
333: -- Changed label location to locator.
334: -- Changed label lot_no to Parent_lot_number.

Line 337: FND_FILE.PUT(FND_FILE.OUTPUT,'SUBINVENTORY' || l_delim);

333: -- Changed label location to locator.
334: -- Changed label lot_no to Parent_lot_number.
335: -- Changed label sublot_no to lot_number.
336:
337: FND_FILE.PUT(FND_FILE.OUTPUT,'SUBINVENTORY' || l_delim);
338: FND_FILE.PUT(FND_FILE.OUTPUT,'LOCATOR' || l_delim);
339: FND_FILE.PUT(FND_FILE.OUTPUT,'PARENT LOT NUMBER' || l_delim);
340: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT NUMBER' || l_delim);
341: FND_FILE.PUT(FND_FILE.OUTPUT,'QC LAB ORGN' || l_delim);

Line 338: FND_FILE.PUT(FND_FILE.OUTPUT,'LOCATOR' || l_delim);

334: -- Changed label lot_no to Parent_lot_number.
335: -- Changed label sublot_no to lot_number.
336:
337: FND_FILE.PUT(FND_FILE.OUTPUT,'SUBINVENTORY' || l_delim);
338: FND_FILE.PUT(FND_FILE.OUTPUT,'LOCATOR' || l_delim);
339: FND_FILE.PUT(FND_FILE.OUTPUT,'PARENT LOT NUMBER' || l_delim);
340: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT NUMBER' || l_delim);
341: FND_FILE.PUT(FND_FILE.OUTPUT,'QC LAB ORGN' || l_delim);
342: FND_FILE.PUT(FND_FILE.OUTPUT,'DATE DRAWN' || l_delim);

Line 339: FND_FILE.PUT(FND_FILE.OUTPUT,'PARENT LOT NUMBER' || l_delim);

335: -- Changed label sublot_no to lot_number.
336:
337: FND_FILE.PUT(FND_FILE.OUTPUT,'SUBINVENTORY' || l_delim);
338: FND_FILE.PUT(FND_FILE.OUTPUT,'LOCATOR' || l_delim);
339: FND_FILE.PUT(FND_FILE.OUTPUT,'PARENT LOT NUMBER' || l_delim);
340: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT NUMBER' || l_delim);
341: FND_FILE.PUT(FND_FILE.OUTPUT,'QC LAB ORGN' || l_delim);
342: FND_FILE.PUT(FND_FILE.OUTPUT,'DATE DRAWN' || l_delim);
343: FND_FILE.PUT(FND_FILE.OUTPUT,'EXPIRATION DATE' || l_delim);

Line 340: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT NUMBER' || l_delim);

336:
337: FND_FILE.PUT(FND_FILE.OUTPUT,'SUBINVENTORY' || l_delim);
338: FND_FILE.PUT(FND_FILE.OUTPUT,'LOCATOR' || l_delim);
339: FND_FILE.PUT(FND_FILE.OUTPUT,'PARENT LOT NUMBER' || l_delim);
340: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT NUMBER' || l_delim);
341: FND_FILE.PUT(FND_FILE.OUTPUT,'QC LAB ORGN' || l_delim);
342: FND_FILE.PUT(FND_FILE.OUTPUT,'DATE DRAWN' || l_delim);
343: FND_FILE.PUT(FND_FILE.OUTPUT,'EXPIRATION DATE' || l_delim);
344: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT RETEST IND' || l_delim);

Line 341: FND_FILE.PUT(FND_FILE.OUTPUT,'QC LAB ORGN' || l_delim);

337: FND_FILE.PUT(FND_FILE.OUTPUT,'SUBINVENTORY' || l_delim);
338: FND_FILE.PUT(FND_FILE.OUTPUT,'LOCATOR' || l_delim);
339: FND_FILE.PUT(FND_FILE.OUTPUT,'PARENT LOT NUMBER' || l_delim);
340: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT NUMBER' || l_delim);
341: FND_FILE.PUT(FND_FILE.OUTPUT,'QC LAB ORGN' || l_delim);
342: FND_FILE.PUT(FND_FILE.OUTPUT,'DATE DRAWN' || l_delim);
343: FND_FILE.PUT(FND_FILE.OUTPUT,'EXPIRATION DATE' || l_delim);
344: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT RETEST IND' || l_delim);
345: --JD

Line 342: FND_FILE.PUT(FND_FILE.OUTPUT,'DATE DRAWN' || l_delim);

338: FND_FILE.PUT(FND_FILE.OUTPUT,'LOCATOR' || l_delim);
339: FND_FILE.PUT(FND_FILE.OUTPUT,'PARENT LOT NUMBER' || l_delim);
340: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT NUMBER' || l_delim);
341: FND_FILE.PUT(FND_FILE.OUTPUT,'QC LAB ORGN' || l_delim);
342: FND_FILE.PUT(FND_FILE.OUTPUT,'DATE DRAWN' || l_delim);
343: FND_FILE.PUT(FND_FILE.OUTPUT,'EXPIRATION DATE' || l_delim);
344: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT RETEST IND' || l_delim);
345: --JD
346: -- Changed label storage_whse_code to storage_subinventory.

Line 343: FND_FILE.PUT(FND_FILE.OUTPUT,'EXPIRATION DATE' || l_delim);

339: FND_FILE.PUT(FND_FILE.OUTPUT,'PARENT LOT NUMBER' || l_delim);
340: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT NUMBER' || l_delim);
341: FND_FILE.PUT(FND_FILE.OUTPUT,'QC LAB ORGN' || l_delim);
342: FND_FILE.PUT(FND_FILE.OUTPUT,'DATE DRAWN' || l_delim);
343: FND_FILE.PUT(FND_FILE.OUTPUT,'EXPIRATION DATE' || l_delim);
344: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT RETEST IND' || l_delim);
345: --JD
346: -- Changed label storage_whse_code to storage_subinventory.
347: -- Changed label storage_location to storage_locator.

Line 344: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT RETEST IND' || l_delim);

340: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT NUMBER' || l_delim);
341: FND_FILE.PUT(FND_FILE.OUTPUT,'QC LAB ORGN' || l_delim);
342: FND_FILE.PUT(FND_FILE.OUTPUT,'DATE DRAWN' || l_delim);
343: FND_FILE.PUT(FND_FILE.OUTPUT,'EXPIRATION DATE' || l_delim);
344: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT RETEST IND' || l_delim);
345: --JD
346: -- Changed label storage_whse_code to storage_subinventory.
347: -- Changed label storage_location to storage_locator.
348: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE ORGN' || l_delim); --BUG# 4612611

Line 348: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE ORGN' || l_delim); --BUG# 4612611

344: FND_FILE.PUT(FND_FILE.OUTPUT,'LOT RETEST IND' || l_delim);
345: --JD
346: -- Changed label storage_whse_code to storage_subinventory.
347: -- Changed label storage_location to storage_locator.
348: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE ORGN' || l_delim); --BUG# 4612611
349: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SUBINVENTORY' || l_delim);
350: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE LOCATOR' || l_delim);
351: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCES' || l_delim);
352: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCE INSTANCE' || l_delim);

Line 349: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SUBINVENTORY' || l_delim);

345: --JD
346: -- Changed label storage_whse_code to storage_subinventory.
347: -- Changed label storage_location to storage_locator.
348: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE ORGN' || l_delim); --BUG# 4612611
349: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SUBINVENTORY' || l_delim);
350: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE LOCATOR' || l_delim);
351: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCES' || l_delim);
352: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCE INSTANCE' || l_delim);
353: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE INSTANCE' || l_delim);

Line 350: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE LOCATOR' || l_delim);

346: -- Changed label storage_whse_code to storage_subinventory.
347: -- Changed label storage_location to storage_locator.
348: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE ORGN' || l_delim); --BUG# 4612611
349: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SUBINVENTORY' || l_delim);
350: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE LOCATOR' || l_delim);
351: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCES' || l_delim);
352: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCE INSTANCE' || l_delim);
353: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE INSTANCE' || l_delim);
354: --FND_FILE.PUT(FND_FILE.OUTPUT,'PLANT CODE' || l_delim); --BUG# 4612611

Line 351: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCES' || l_delim);

347: -- Changed label storage_location to storage_locator.
348: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE ORGN' || l_delim); --BUG# 4612611
349: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SUBINVENTORY' || l_delim);
350: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE LOCATOR' || l_delim);
351: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCES' || l_delim);
352: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCE INSTANCE' || l_delim);
353: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE INSTANCE' || l_delim);
354: --FND_FILE.PUT(FND_FILE.OUTPUT,'PLANT CODE' || l_delim); --BUG# 4612611
355: FND_FILE.PUT(FND_FILE.OUTPUT,'BATCH NO' || l_delim);

Line 352: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCE INSTANCE' || l_delim);

348: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE ORGN' || l_delim); --BUG# 4612611
349: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SUBINVENTORY' || l_delim);
350: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE LOCATOR' || l_delim);
351: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCES' || l_delim);
352: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCE INSTANCE' || l_delim);
353: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE INSTANCE' || l_delim);
354: --FND_FILE.PUT(FND_FILE.OUTPUT,'PLANT CODE' || l_delim); --BUG# 4612611
355: FND_FILE.PUT(FND_FILE.OUTPUT,'BATCH NO' || l_delim);
356: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA NO' || l_delim);

Line 353: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE INSTANCE' || l_delim);

349: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SUBINVENTORY' || l_delim);
350: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE LOCATOR' || l_delim);
351: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCES' || l_delim);
352: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCE INSTANCE' || l_delim);
353: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE INSTANCE' || l_delim);
354: --FND_FILE.PUT(FND_FILE.OUTPUT,'PLANT CODE' || l_delim); --BUG# 4612611
355: FND_FILE.PUT(FND_FILE.OUTPUT,'BATCH NO' || l_delim);
356: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA NO' || l_delim);
357: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA VERS' || l_delim);

Line 354: --FND_FILE.PUT(FND_FILE.OUTPUT,'PLANT CODE' || l_delim); --BUG# 4612611

350: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE LOCATOR' || l_delim);
351: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCES' || l_delim);
352: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCE INSTANCE' || l_delim);
353: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE INSTANCE' || l_delim);
354: --FND_FILE.PUT(FND_FILE.OUTPUT,'PLANT CODE' || l_delim); --BUG# 4612611
355: FND_FILE.PUT(FND_FILE.OUTPUT,'BATCH NO' || l_delim);
356: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA NO' || l_delim);
357: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA VERS' || l_delim);
358: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN NO' || l_delim);

Line 355: FND_FILE.PUT(FND_FILE.OUTPUT,'BATCH NO' || l_delim);

351: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCES' || l_delim);
352: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCE INSTANCE' || l_delim);
353: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE INSTANCE' || l_delim);
354: --FND_FILE.PUT(FND_FILE.OUTPUT,'PLANT CODE' || l_delim); --BUG# 4612611
355: FND_FILE.PUT(FND_FILE.OUTPUT,'BATCH NO' || l_delim);
356: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA NO' || l_delim);
357: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA VERS' || l_delim);
358: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN NO' || l_delim);
359: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN VERS' || l_delim);

Line 356: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA NO' || l_delim);

352: FND_FILE.PUT(FND_FILE.OUTPUT,'RESOURCE INSTANCE' || l_delim);
353: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE INSTANCE' || l_delim);
354: --FND_FILE.PUT(FND_FILE.OUTPUT,'PLANT CODE' || l_delim); --BUG# 4612611
355: FND_FILE.PUT(FND_FILE.OUTPUT,'BATCH NO' || l_delim);
356: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA NO' || l_delim);
357: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA VERS' || l_delim);
358: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN NO' || l_delim);
359: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN VERS' || l_delim);
360: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE NO' || l_delim);

Line 357: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA VERS' || l_delim);

353: FND_FILE.PUT(FND_FILE.OUTPUT,'SAMPLE INSTANCE' || l_delim);
354: --FND_FILE.PUT(FND_FILE.OUTPUT,'PLANT CODE' || l_delim); --BUG# 4612611
355: FND_FILE.PUT(FND_FILE.OUTPUT,'BATCH NO' || l_delim);
356: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA NO' || l_delim);
357: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA VERS' || l_delim);
358: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN NO' || l_delim);
359: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN VERS' || l_delim);
360: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE NO' || l_delim);
361: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE VERSION' || l_delim);

Line 358: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN NO' || l_delim);

354: --FND_FILE.PUT(FND_FILE.OUTPUT,'PLANT CODE' || l_delim); --BUG# 4612611
355: FND_FILE.PUT(FND_FILE.OUTPUT,'BATCH NO' || l_delim);
356: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA NO' || l_delim);
357: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA VERS' || l_delim);
358: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN NO' || l_delim);
359: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN VERS' || l_delim);
360: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE NO' || l_delim);
361: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE VERSION' || l_delim);
362: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING NO' || l_delim);

Line 359: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN VERS' || l_delim);

355: FND_FILE.PUT(FND_FILE.OUTPUT,'BATCH NO' || l_delim);
356: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA NO' || l_delim);
357: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA VERS' || l_delim);
358: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN NO' || l_delim);
359: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN VERS' || l_delim);
360: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE NO' || l_delim);
361: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE VERSION' || l_delim);
362: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING NO' || l_delim);
363: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING VERS' || l_delim);

Line 360: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE NO' || l_delim);

356: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA NO' || l_delim);
357: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA VERS' || l_delim);
358: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN NO' || l_delim);
359: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN VERS' || l_delim);
360: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE NO' || l_delim);
361: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE VERSION' || l_delim);
362: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING NO' || l_delim);
363: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING VERS' || l_delim);
364: FND_FILE.PUT(FND_FILE.OUTPUT,'CUSTOMER NAME' || l_delim);

Line 361: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE VERSION' || l_delim);

357: FND_FILE.PUT(FND_FILE.OUTPUT,'FORMULA VERS' || l_delim);
358: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN NO' || l_delim);
359: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN VERS' || l_delim);
360: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE NO' || l_delim);
361: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE VERSION' || l_delim);
362: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING NO' || l_delim);
363: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING VERS' || l_delim);
364: FND_FILE.PUT(FND_FILE.OUTPUT,'CUSTOMER NAME' || l_delim);
365: FND_FILE.PUT(FND_FILE.OUTPUT,'OPERATING UNIT' || l_delim);

Line 362: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING NO' || l_delim);

358: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN NO' || l_delim);
359: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN VERS' || l_delim);
360: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE NO' || l_delim);
361: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE VERSION' || l_delim);
362: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING NO' || l_delim);
363: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING VERS' || l_delim);
364: FND_FILE.PUT(FND_FILE.OUTPUT,'CUSTOMER NAME' || l_delim);
365: FND_FILE.PUT(FND_FILE.OUTPUT,'OPERATING UNIT' || l_delim);
366: FND_FILE.PUT(FND_FILE.OUTPUT,'SHIP TO SITE' || l_delim);

Line 363: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING VERS' || l_delim);

359: FND_FILE.PUT(FND_FILE.OUTPUT,'OPRN VERS' || l_delim);
360: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE NO' || l_delim);
361: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE VERSION' || l_delim);
362: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING NO' || l_delim);
363: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING VERS' || l_delim);
364: FND_FILE.PUT(FND_FILE.OUTPUT,'CUSTOMER NAME' || l_delim);
365: FND_FILE.PUT(FND_FILE.OUTPUT,'OPERATING UNIT' || l_delim);
366: FND_FILE.PUT(FND_FILE.OUTPUT,'SHIP TO SITE' || l_delim);
367: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER TYPE ' || l_delim);

Line 364: FND_FILE.PUT(FND_FILE.OUTPUT,'CUSTOMER NAME' || l_delim);

360: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE NO' || l_delim);
361: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE VERSION' || l_delim);
362: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING NO' || l_delim);
363: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING VERS' || l_delim);
364: FND_FILE.PUT(FND_FILE.OUTPUT,'CUSTOMER NAME' || l_delim);
365: FND_FILE.PUT(FND_FILE.OUTPUT,'OPERATING UNIT' || l_delim);
366: FND_FILE.PUT(FND_FILE.OUTPUT,'SHIP TO SITE' || l_delim);
367: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER TYPE ' || l_delim);
368: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER NO ' || l_delim);

Line 365: FND_FILE.PUT(FND_FILE.OUTPUT,'OPERATING UNIT' || l_delim);

361: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIPE VERSION' || l_delim);
362: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING NO' || l_delim);
363: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING VERS' || l_delim);
364: FND_FILE.PUT(FND_FILE.OUTPUT,'CUSTOMER NAME' || l_delim);
365: FND_FILE.PUT(FND_FILE.OUTPUT,'OPERATING UNIT' || l_delim);
366: FND_FILE.PUT(FND_FILE.OUTPUT,'SHIP TO SITE' || l_delim);
367: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER TYPE ' || l_delim);
368: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER NO ' || l_delim);
369: FND_FILE.PUT(FND_FILE.OUTPUT,'LINE NO ' || l_delim);

Line 366: FND_FILE.PUT(FND_FILE.OUTPUT,'SHIP TO SITE' || l_delim);

362: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING NO' || l_delim);
363: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING VERS' || l_delim);
364: FND_FILE.PUT(FND_FILE.OUTPUT,'CUSTOMER NAME' || l_delim);
365: FND_FILE.PUT(FND_FILE.OUTPUT,'OPERATING UNIT' || l_delim);
366: FND_FILE.PUT(FND_FILE.OUTPUT,'SHIP TO SITE' || l_delim);
367: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER TYPE ' || l_delim);
368: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER NO ' || l_delim);
369: FND_FILE.PUT(FND_FILE.OUTPUT,'LINE NO ' || l_delim);
370: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER CODE ' || l_delim);

Line 367: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER TYPE ' || l_delim);

363: FND_FILE.PUT(FND_FILE.OUTPUT,'ROUTING VERS' || l_delim);
364: FND_FILE.PUT(FND_FILE.OUTPUT,'CUSTOMER NAME' || l_delim);
365: FND_FILE.PUT(FND_FILE.OUTPUT,'OPERATING UNIT' || l_delim);
366: FND_FILE.PUT(FND_FILE.OUTPUT,'SHIP TO SITE' || l_delim);
367: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER TYPE ' || l_delim);
368: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER NO ' || l_delim);
369: FND_FILE.PUT(FND_FILE.OUTPUT,'LINE NO ' || l_delim);
370: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER CODE ' || l_delim);
371: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER NAME ' || l_delim);

Line 368: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER NO ' || l_delim);

364: FND_FILE.PUT(FND_FILE.OUTPUT,'CUSTOMER NAME' || l_delim);
365: FND_FILE.PUT(FND_FILE.OUTPUT,'OPERATING UNIT' || l_delim);
366: FND_FILE.PUT(FND_FILE.OUTPUT,'SHIP TO SITE' || l_delim);
367: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER TYPE ' || l_delim);
368: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER NO ' || l_delim);
369: FND_FILE.PUT(FND_FILE.OUTPUT,'LINE NO ' || l_delim);
370: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER CODE ' || l_delim);
371: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER NAME ' || l_delim);
372: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER SITE ' || l_delim);

Line 369: FND_FILE.PUT(FND_FILE.OUTPUT,'LINE NO ' || l_delim);

365: FND_FILE.PUT(FND_FILE.OUTPUT,'OPERATING UNIT' || l_delim);
366: FND_FILE.PUT(FND_FILE.OUTPUT,'SHIP TO SITE' || l_delim);
367: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER TYPE ' || l_delim);
368: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER NO ' || l_delim);
369: FND_FILE.PUT(FND_FILE.OUTPUT,'LINE NO ' || l_delim);
370: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER CODE ' || l_delim);
371: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER NAME ' || l_delim);
372: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER SITE ' || l_delim);
373: FND_FILE.PUT(FND_FILE.OUTPUT,'PO NUMBER ' || l_delim);

Line 370: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER CODE ' || l_delim);

366: FND_FILE.PUT(FND_FILE.OUTPUT,'SHIP TO SITE' || l_delim);
367: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER TYPE ' || l_delim);
368: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER NO ' || l_delim);
369: FND_FILE.PUT(FND_FILE.OUTPUT,'LINE NO ' || l_delim);
370: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER CODE ' || l_delim);
371: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER NAME ' || l_delim);
372: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER SITE ' || l_delim);
373: FND_FILE.PUT(FND_FILE.OUTPUT,'PO NUMBER ' || l_delim);
374: FND_FILE.PUT(FND_FILE.OUTPUT,'PO LINE NUMBER ' || l_delim);

Line 371: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER NAME ' || l_delim);

367: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER TYPE ' || l_delim);
368: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER NO ' || l_delim);
369: FND_FILE.PUT(FND_FILE.OUTPUT,'LINE NO ' || l_delim);
370: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER CODE ' || l_delim);
371: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER NAME ' || l_delim);
372: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER SITE ' || l_delim);
373: FND_FILE.PUT(FND_FILE.OUTPUT,'PO NUMBER ' || l_delim);
374: FND_FILE.PUT(FND_FILE.OUTPUT,'PO LINE NUMBER ' || l_delim);
375: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT NUMBER ' || l_delim);

Line 372: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER SITE ' || l_delim);

368: FND_FILE.PUT(FND_FILE.OUTPUT,'ORDER NO ' || l_delim);
369: FND_FILE.PUT(FND_FILE.OUTPUT,'LINE NO ' || l_delim);
370: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER CODE ' || l_delim);
371: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER NAME ' || l_delim);
372: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER SITE ' || l_delim);
373: FND_FILE.PUT(FND_FILE.OUTPUT,'PO NUMBER ' || l_delim);
374: FND_FILE.PUT(FND_FILE.OUTPUT,'PO LINE NUMBER ' || l_delim);
375: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT NUMBER ' || l_delim);
376: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT LINE NUMBER ');

Line 373: FND_FILE.PUT(FND_FILE.OUTPUT,'PO NUMBER ' || l_delim);

369: FND_FILE.PUT(FND_FILE.OUTPUT,'LINE NO ' || l_delim);
370: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER CODE ' || l_delim);
371: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER NAME ' || l_delim);
372: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER SITE ' || l_delim);
373: FND_FILE.PUT(FND_FILE.OUTPUT,'PO NUMBER ' || l_delim);
374: FND_FILE.PUT(FND_FILE.OUTPUT,'PO LINE NUMBER ' || l_delim);
375: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT NUMBER ' || l_delim);
376: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT LINE NUMBER ');
377:

Line 374: FND_FILE.PUT(FND_FILE.OUTPUT,'PO LINE NUMBER ' || l_delim);

370: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER CODE ' || l_delim);
371: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER NAME ' || l_delim);
372: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER SITE ' || l_delim);
373: FND_FILE.PUT(FND_FILE.OUTPUT,'PO NUMBER ' || l_delim);
374: FND_FILE.PUT(FND_FILE.OUTPUT,'PO LINE NUMBER ' || l_delim);
375: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT NUMBER ' || l_delim);
376: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT LINE NUMBER ');
377:
378: --Added for stability study

Line 375: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT NUMBER ' || l_delim);

371: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER NAME ' || l_delim);
372: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER SITE ' || l_delim);
373: FND_FILE.PUT(FND_FILE.OUTPUT,'PO NUMBER ' || l_delim);
374: FND_FILE.PUT(FND_FILE.OUTPUT,'PO LINE NUMBER ' || l_delim);
375: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT NUMBER ' || l_delim);
376: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT LINE NUMBER ');
377:
378: --Added for stability study
379: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILITY STUDY ORGN ' || l_delim);

Line 376: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT LINE NUMBER ');

372: FND_FILE.PUT(FND_FILE.OUTPUT,'SUPPLIER SITE ' || l_delim);
373: FND_FILE.PUT(FND_FILE.OUTPUT,'PO NUMBER ' || l_delim);
374: FND_FILE.PUT(FND_FILE.OUTPUT,'PO LINE NUMBER ' || l_delim);
375: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT NUMBER ' || l_delim);
376: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT LINE NUMBER ');
377:
378: --Added for stability study
379: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILITY STUDY ORGN ' || l_delim);
380: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILTY STUDY NO ' || l_delim);

Line 379: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILITY STUDY ORGN ' || l_delim);

375: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT NUMBER ' || l_delim);
376: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT LINE NUMBER ');
377:
378: --Added for stability study
379: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILITY STUDY ORGN ' || l_delim);
380: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILTY STUDY NO ' || l_delim);
381: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC ' || l_delim);
382: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC VERS ' || l_delim);
383: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SPEC ' || l_delim);

Line 380: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILTY STUDY NO ' || l_delim);

376: FND_FILE.PUT(FND_FILE.OUTPUT,'RECIEPT LINE NUMBER ');
377:
378: --Added for stability study
379: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILITY STUDY ORGN ' || l_delim);
380: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILTY STUDY NO ' || l_delim);
381: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC ' || l_delim);
382: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC VERS ' || l_delim);
383: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SPEC ' || l_delim);
384: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE_SPEC_VERSION ' || l_delim);

Line 381: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC ' || l_delim);

377:
378: --Added for stability study
379: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILITY STUDY ORGN ' || l_delim);
380: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILTY STUDY NO ' || l_delim);
381: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC ' || l_delim);
382: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC VERS ' || l_delim);
383: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SPEC ' || l_delim);
384: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE_SPEC_VERSION ' || l_delim);
385: FND_FILE.PUT(FND_FILE.OUTPUT,'VARIANT NUMBER ' || l_delim);

Line 382: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC VERS ' || l_delim);

378: --Added for stability study
379: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILITY STUDY ORGN ' || l_delim);
380: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILTY STUDY NO ' || l_delim);
381: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC ' || l_delim);
382: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC VERS ' || l_delim);
383: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SPEC ' || l_delim);
384: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE_SPEC_VERSION ' || l_delim);
385: FND_FILE.PUT(FND_FILE.OUTPUT,'VARIANT NUMBER ' || l_delim);
386: FND_FILE.PUT(FND_FILE.OUTPUT,'TIME INTERVAL NAME ' || l_delim);

Line 383: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SPEC ' || l_delim);

379: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILITY STUDY ORGN ' || l_delim);
380: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILTY STUDY NO ' || l_delim);
381: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC ' || l_delim);
382: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC VERS ' || l_delim);
383: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SPEC ' || l_delim);
384: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE_SPEC_VERSION ' || l_delim);
385: FND_FILE.PUT(FND_FILE.OUTPUT,'VARIANT NUMBER ' || l_delim);
386: FND_FILE.PUT(FND_FILE.OUTPUT,'TIME INTERVAL NAME ' || l_delim);
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'SCHEDULED START DATE ' || l_delim);

Line 384: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE_SPEC_VERSION ' || l_delim);

380: FND_FILE.PUT(FND_FILE.OUTPUT,'STABILTY STUDY NO ' || l_delim);
381: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC ' || l_delim);
382: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC VERS ' || l_delim);
383: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SPEC ' || l_delim);
384: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE_SPEC_VERSION ' || l_delim);
385: FND_FILE.PUT(FND_FILE.OUTPUT,'VARIANT NUMBER ' || l_delim);
386: FND_FILE.PUT(FND_FILE.OUTPUT,'TIME INTERVAL NAME ' || l_delim);
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'SCHEDULED START DATE ' || l_delim);
388:

Line 385: FND_FILE.PUT(FND_FILE.OUTPUT,'VARIANT NUMBER ' || l_delim);

381: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC ' || l_delim);
382: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC VERS ' || l_delim);
383: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SPEC ' || l_delim);
384: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE_SPEC_VERSION ' || l_delim);
385: FND_FILE.PUT(FND_FILE.OUTPUT,'VARIANT NUMBER ' || l_delim);
386: FND_FILE.PUT(FND_FILE.OUTPUT,'TIME INTERVAL NAME ' || l_delim);
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'SCHEDULED START DATE ' || l_delim);
388:
389:

Line 386: FND_FILE.PUT(FND_FILE.OUTPUT,'TIME INTERVAL NAME ' || l_delim);

382: FND_FILE.PUT(FND_FILE.OUTPUT,'ITEM SPEC VERS ' || l_delim);
383: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SPEC ' || l_delim);
384: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE_SPEC_VERSION ' || l_delim);
385: FND_FILE.PUT(FND_FILE.OUTPUT,'VARIANT NUMBER ' || l_delim);
386: FND_FILE.PUT(FND_FILE.OUTPUT,'TIME INTERVAL NAME ' || l_delim);
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'SCHEDULED START DATE ' || l_delim);
388:
389:
390:

Line 387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'SCHEDULED START DATE ' || l_delim);

383: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE SPEC ' || l_delim);
384: FND_FILE.PUT(FND_FILE.OUTPUT,'STORAGE_SPEC_VERSION ' || l_delim);
385: FND_FILE.PUT(FND_FILE.OUTPUT,'VARIANT NUMBER ' || l_delim);
386: FND_FILE.PUT(FND_FILE.OUTPUT,'TIME INTERVAL NAME ' || l_delim);
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'SCHEDULED START DATE ' || l_delim);
388:
389:
390:
391: FOR samp in c_get_sample LOOP

Line 410: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_sample_orgn_code|| '"' || l_delim);

406:
407: -- JD changed samp.orgn_code to l_sample_orgn_code.
408: -- JD changed samp.sample_uom to samp.sample_qty_uom.
409:
410: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_sample_orgn_code|| '"' || l_delim);
411: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_no|| '"' || l_delim);
412: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_desc|| '"' || l_delim);
413: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty|| '"' || l_delim);
414: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty_uom|| '"' || l_delim);

Line 411: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_no|| '"' || l_delim);

407: -- JD changed samp.orgn_code to l_sample_orgn_code.
408: -- JD changed samp.sample_uom to samp.sample_qty_uom.
409:
410: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_sample_orgn_code|| '"' || l_delim);
411: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_no|| '"' || l_delim);
412: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_desc|| '"' || l_delim);
413: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty|| '"' || l_delim);
414: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty_uom|| '"' || l_delim);
415: -- FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_disposition|| '"' || l_delim);

Line 412: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_desc|| '"' || l_delim);

408: -- JD changed samp.sample_uom to samp.sample_qty_uom.
409:
410: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_sample_orgn_code|| '"' || l_delim);
411: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_no|| '"' || l_delim);
412: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_desc|| '"' || l_delim);
413: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty|| '"' || l_delim);
414: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty_uom|| '"' || l_delim);
415: -- FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_disposition|| '"' || l_delim);
416:

Line 413: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty|| '"' || l_delim);

409:
410: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_sample_orgn_code|| '"' || l_delim);
411: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_no|| '"' || l_delim);
412: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_desc|| '"' || l_delim);
413: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty|| '"' || l_delim);
414: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty_uom|| '"' || l_delim);
415: -- FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_disposition|| '"' || l_delim);
416:
417: -- Bug 3088216: If retain as exists, get the value

Line 414: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty_uom|| '"' || l_delim);

410: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_sample_orgn_code|| '"' || l_delim);
411: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_no|| '"' || l_delim);
412: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_desc|| '"' || l_delim);
413: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty|| '"' || l_delim);
414: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty_uom|| '"' || l_delim);
415: -- FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_disposition|| '"' || l_delim);
416:
417: -- Bug 3088216: If retain as exists, get the value
418: IF samp.retain_as IS NOT NULL THEN

Line 415: -- FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_disposition|| '"' || l_delim);

411: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_no|| '"' || l_delim);
412: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_desc|| '"' || l_delim);
413: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty|| '"' || l_delim);
414: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_qty_uom|| '"' || l_delim);
415: -- FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_disposition|| '"' || l_delim);
416:
417: -- Bug 3088216: If retain as exists, get the value
418: IF samp.retain_as IS NOT NULL THEN
419: OPEN c_get_retain_as(samp.retain_as);

Line 422: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_retain_as || '"' || l_delim);

418: IF samp.retain_as IS NOT NULL THEN
419: OPEN c_get_retain_as(samp.retain_as);
420: FETCH c_get_retain_as INTO l_retain_as;
421: CLOSE c_get_retain_as;
422: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_retain_as || '"' || l_delim);
423: ELSE
424: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.retain_as || '"' || l_delim);
425: END IF;
426:

Line 424: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.retain_as || '"' || l_delim);

420: FETCH c_get_retain_as INTO l_retain_as;
421: CLOSE c_get_retain_as;
422: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_retain_as || '"' || l_delim);
423: ELSE
424: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.retain_as || '"' || l_delim);
425: END IF;
426:
427: OPEN c_get_item(samp.organization_id, samp.inventory_item_id); --BUG# 4612611
428: FETCH c_get_item INTO l_item_code;

Line 431: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_item_code || '"' || l_delim); --BUG# 4612611

427: OPEN c_get_item(samp.organization_id, samp.inventory_item_id); --BUG# 4612611
428: FETCH c_get_item INTO l_item_code;
429: CLOSE c_get_item;
430:
431: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_item_code || '"' || l_delim); --BUG# 4612611
432: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.revision || '"' || l_delim); --BUG# 4612611
433:
434: IF samp.priority is NOT NULL THEN
435: OPEN c_get_priority(samp.priority);

Line 432: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.revision || '"' || l_delim); --BUG# 4612611

428: FETCH c_get_item INTO l_item_code;
429: CLOSE c_get_item;
430:
431: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_item_code || '"' || l_delim); --BUG# 4612611
432: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.revision || '"' || l_delim); --BUG# 4612611
433:
434: IF samp.priority is NOT NULL THEN
435: OPEN c_get_priority(samp.priority);
436: FETCH c_get_priority INTO l_priority;

Line 438: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_priority || '"' || l_delim);

434: IF samp.priority is NOT NULL THEN
435: OPEN c_get_priority(samp.priority);
436: FETCH c_get_priority INTO l_priority;
437: CLOSE c_get_priority;
438: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_priority || '"' || l_delim);
439: ELSE
440: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.priority || '"' || l_delim);
441: END IF;
442:

Line 440: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.priority || '"' || l_delim);

436: FETCH c_get_priority INTO l_priority;
437: CLOSE c_get_priority;
438: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_priority || '"' || l_delim);
439: ELSE
440: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.priority || '"' || l_delim);
441: END IF;
442:
443: IF samp.source is NOT NULL THEN
444: OPEN c_get_source(samp.source);

Line 447: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_source || '"' || l_delim);

443: IF samp.source is NOT NULL THEN
444: OPEN c_get_source(samp.source);
445: FETCH c_get_source INTO l_source;
446: CLOSE c_get_source;
447: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_source || '"' || l_delim);
448: ELSE
449: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.source || '"' || l_delim);
450: END IF;
451: --JD changed samp.whse_code to samp.subinventory.

Line 449: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.source || '"' || l_delim);

445: FETCH c_get_source INTO l_source;
446: CLOSE c_get_source;
447: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_source || '"' || l_delim);
448: ELSE
449: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.source || '"' || l_delim);
450: END IF;
451: --JD changed samp.whse_code to samp.subinventory.
452: -- Added cursor to get locator display value.
453: -- changed location to l_segment1.

Line 482: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.subinventory|| '"' || l_delim);

478: ELSE
479: l_lab_orgn_code := NULL;
480: END IF;
481:
482: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.subinventory|| '"' || l_delim);
483: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
484: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.parent_lot_number|| '"' || l_delim);
485: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_number|| '"' || l_delim);
486: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_lab_orgn_code|| '"' || l_delim);

Line 483: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);

479: l_lab_orgn_code := NULL;
480: END IF;
481:
482: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.subinventory|| '"' || l_delim);
483: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
484: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.parent_lot_number|| '"' || l_delim);
485: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_number|| '"' || l_delim);
486: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_lab_orgn_code|| '"' || l_delim);
487: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.date_drawn|| '"' || l_delim);

Line 484: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.parent_lot_number|| '"' || l_delim);

480: END IF;
481:
482: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.subinventory|| '"' || l_delim);
483: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
484: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.parent_lot_number|| '"' || l_delim);
485: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_number|| '"' || l_delim);
486: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_lab_orgn_code|| '"' || l_delim);
487: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.date_drawn|| '"' || l_delim);
488: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.expiration_date|| '"' || l_delim);

Line 485: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_number|| '"' || l_delim);

481:
482: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.subinventory|| '"' || l_delim);
483: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
484: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.parent_lot_number|| '"' || l_delim);
485: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_number|| '"' || l_delim);
486: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_lab_orgn_code|| '"' || l_delim);
487: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.date_drawn|| '"' || l_delim);
488: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.expiration_date|| '"' || l_delim);
489: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_retest_ind|| '"' || l_delim);

Line 486: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_lab_orgn_code|| '"' || l_delim);

482: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.subinventory|| '"' || l_delim);
483: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
484: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.parent_lot_number|| '"' || l_delim);
485: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_number|| '"' || l_delim);
486: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_lab_orgn_code|| '"' || l_delim);
487: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.date_drawn|| '"' || l_delim);
488: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.expiration_date|| '"' || l_delim);
489: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_retest_ind|| '"' || l_delim);
490:

Line 487: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.date_drawn|| '"' || l_delim);

483: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
484: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.parent_lot_number|| '"' || l_delim);
485: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_number|| '"' || l_delim);
486: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_lab_orgn_code|| '"' || l_delim);
487: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.date_drawn|| '"' || l_delim);
488: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.expiration_date|| '"' || l_delim);
489: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_retest_ind|| '"' || l_delim);
490:
491: IF (samp.source ='T') THEN

Line 488: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.expiration_date|| '"' || l_delim);

484: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.parent_lot_number|| '"' || l_delim);
485: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_number|| '"' || l_delim);
486: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_lab_orgn_code|| '"' || l_delim);
487: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.date_drawn|| '"' || l_delim);
488: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.expiration_date|| '"' || l_delim);
489: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_retest_ind|| '"' || l_delim);
490:
491: IF (samp.source ='T') THEN
492: OPEN c_get_variant_storage;

Line 489: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_retest_ind|| '"' || l_delim);

485: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_number|| '"' || l_delim);
486: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_lab_orgn_code|| '"' || l_delim);
487: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.date_drawn|| '"' || l_delim);
488: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.expiration_date|| '"' || l_delim);
489: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.lot_retest_ind|| '"' || l_delim);
490:
491: IF (samp.source ='T') THEN
492: OPEN c_get_variant_storage;
493: FETCH c_get_variant_storage into c_variant_storage_row;

Line 516: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611

512: ELSE
513: l_store_segment1 := NULL;
514: END IF;
515:
516: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611
517: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.storage_subinventory|| '"' || l_delim);
518: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_store_segment1|| '"' || l_delim);
519: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.resources|| '"' || l_delim);
520: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.instance_number|| '"' || l_delim);

Line 517: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.storage_subinventory|| '"' || l_delim);

513: l_store_segment1 := NULL;
514: END IF;
515:
516: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611
517: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.storage_subinventory|| '"' || l_delim);
518: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_store_segment1|| '"' || l_delim);
519: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.resources|| '"' || l_delim);
520: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.instance_number|| '"' || l_delim);
521:

Line 518: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_store_segment1|| '"' || l_delim);

514: END IF;
515:
516: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611
517: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.storage_subinventory|| '"' || l_delim);
518: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_store_segment1|| '"' || l_delim);
519: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.resources|| '"' || l_delim);
520: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.instance_number|| '"' || l_delim);
521:
522: ELSE

Line 519: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.resources|| '"' || l_delim);

515:
516: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611
517: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.storage_subinventory|| '"' || l_delim);
518: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_store_segment1|| '"' || l_delim);
519: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.resources|| '"' || l_delim);
520: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.instance_number|| '"' || l_delim);
521:
522: ELSE
523:

Line 520: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.instance_number|| '"' || l_delim);

516: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611
517: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.storage_subinventory|| '"' || l_delim);
518: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_store_segment1|| '"' || l_delim);
519: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.resources|| '"' || l_delim);
520: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||c_variant_storage_row.instance_number|| '"' || l_delim);
521:
522: ELSE
523:
524: IF (samp.storage_organization_id IS NOT NULL) THEN --BUG# 4612611

Line 539: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611

535: FETCH get_locator INTO l_segment1;
536: CLOSE get_locator;
537: END IF;
538:
539: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611
540: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.storage_subinventory|| '"' || l_delim);
541: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
542: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.resources|| '"' || l_delim);
543: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.instance_id|| '"' || l_delim);

Line 540: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.storage_subinventory|| '"' || l_delim);

536: CLOSE get_locator;
537: END IF;
538:
539: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611
540: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.storage_subinventory|| '"' || l_delim);
541: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
542: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.resources|| '"' || l_delim);
543: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.instance_id|| '"' || l_delim);
544: END IF;

Line 541: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);

537: END IF;
538:
539: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611
540: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.storage_subinventory|| '"' || l_delim);
541: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
542: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.resources|| '"' || l_delim);
543: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.instance_id|| '"' || l_delim);
544: END IF;
545:

Line 542: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.resources|| '"' || l_delim);

538:
539: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611
540: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.storage_subinventory|| '"' || l_delim);
541: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
542: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.resources|| '"' || l_delim);
543: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.instance_id|| '"' || l_delim);
544: END IF;
545:
546: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_instance|| '"' || l_delim);

Line 543: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.instance_id|| '"' || l_delim);

539: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_smpl_storage_orgn_code|| '"' || l_delim); --BUG# 4612611
540: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.storage_subinventory|| '"' || l_delim);
541: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_segment1|| '"' || l_delim);
542: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.resources|| '"' || l_delim);
543: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.instance_id|| '"' || l_delim);
544: END IF;
545:
546: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_instance|| '"' || l_delim);
547:

Line 546: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_instance|| '"' || l_delim);

542: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.resources|| '"' || l_delim);
543: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.instance_id|| '"' || l_delim);
544: END IF;
545:
546: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||samp.sample_instance|| '"' || l_delim);
547:
548:
549:
550: IF samp.source = 'W' THEN

Line 567: --FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_plant_code|| '"' || l_delim); --BUG# 4612611

563: CLOSE c_get_batch_info;
564:
565:
566:
567: --FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_plant_code|| '"' || l_delim); --BUG# 4612611
568: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_batch_no|| '"' || l_delim);
569: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_no|| '"' || l_delim);
570: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_vers|| '"' || l_delim);
571: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_no|| '"' || l_delim);

Line 568: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_batch_no|| '"' || l_delim);

564:
565:
566:
567: --FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_plant_code|| '"' || l_delim); --BUG# 4612611
568: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_batch_no|| '"' || l_delim);
569: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_no|| '"' || l_delim);
570: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_vers|| '"' || l_delim);
571: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_no|| '"' || l_delim);
572: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_vers|| '"' || l_delim);

Line 569: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_no|| '"' || l_delim);

565:
566:
567: --FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_plant_code|| '"' || l_delim); --BUG# 4612611
568: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_batch_no|| '"' || l_delim);
569: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_no|| '"' || l_delim);
570: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_vers|| '"' || l_delim);
571: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_no|| '"' || l_delim);
572: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_vers|| '"' || l_delim);
573: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_no|| '"' || l_delim);

Line 570: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_vers|| '"' || l_delim);

566:
567: --FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_plant_code|| '"' || l_delim); --BUG# 4612611
568: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_batch_no|| '"' || l_delim);
569: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_no|| '"' || l_delim);
570: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_vers|| '"' || l_delim);
571: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_no|| '"' || l_delim);
572: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_vers|| '"' || l_delim);
573: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_no|| '"' || l_delim);
574: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_vers||'"' || l_delim);

Line 571: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_no|| '"' || l_delim);

567: --FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_plant_code|| '"' || l_delim); --BUG# 4612611
568: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_batch_no|| '"' || l_delim);
569: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_no|| '"' || l_delim);
570: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_vers|| '"' || l_delim);
571: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_no|| '"' || l_delim);
572: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_vers|| '"' || l_delim);
573: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_no|| '"' || l_delim);
574: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_vers||'"' || l_delim);
575: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_no|| '"' || l_delim);

Line 572: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_vers|| '"' || l_delim);

568: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_batch_no|| '"' || l_delim);
569: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_no|| '"' || l_delim);
570: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_vers|| '"' || l_delim);
571: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_no|| '"' || l_delim);
572: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_vers|| '"' || l_delim);
573: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_no|| '"' || l_delim);
574: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_vers||'"' || l_delim);
575: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_no|| '"' || l_delim);
576: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_vers|| '"' || l_delim);

Line 573: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_no|| '"' || l_delim);

569: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_no|| '"' || l_delim);
570: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_vers|| '"' || l_delim);
571: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_no|| '"' || l_delim);
572: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_vers|| '"' || l_delim);
573: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_no|| '"' || l_delim);
574: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_vers||'"' || l_delim);
575: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_no|| '"' || l_delim);
576: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_vers|| '"' || l_delim);
577: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name

Line 574: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_vers||'"' || l_delim);

570: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_form_vers|| '"' || l_delim);
571: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_no|| '"' || l_delim);
572: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_vers|| '"' || l_delim);
573: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_no|| '"' || l_delim);
574: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_vers||'"' || l_delim);
575: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_no|| '"' || l_delim);
576: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_vers|| '"' || l_delim);
577: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
578: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site

Line 575: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_no|| '"' || l_delim);

571: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_no|| '"' || l_delim);
572: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_vers|| '"' || l_delim);
573: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_no|| '"' || l_delim);
574: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_vers||'"' || l_delim);
575: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_no|| '"' || l_delim);
576: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_vers|| '"' || l_delim);
577: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
578: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
579: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type

Line 576: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_vers|| '"' || l_delim);

572: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oprn_vers|| '"' || l_delim);
573: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_no|| '"' || l_delim);
574: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_vers||'"' || l_delim);
575: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_no|| '"' || l_delim);
576: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_vers|| '"' || l_delim);
577: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
578: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
579: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
580: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no

Line 577: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name

573: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_no|| '"' || l_delim);
574: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_vers||'"' || l_delim);
575: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_no|| '"' || l_delim);
576: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_vers|| '"' || l_delim);
577: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
578: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
579: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
580: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
581: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no

Line 578: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site

574: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_recipe_vers||'"' || l_delim);
575: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_no|| '"' || l_delim);
576: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_vers|| '"' || l_delim);
577: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
578: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
579: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
580: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
581: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
582: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code

Line 579: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type

575: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_no|| '"' || l_delim);
576: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_vers|| '"' || l_delim);
577: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
578: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
579: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
580: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
581: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
582: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
583: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name

Line 580: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no

576: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_routing_vers|| '"' || l_delim);
577: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
578: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
579: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
580: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
581: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
582: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
583: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
584: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site

Line 581: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no

577: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
578: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
579: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
580: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
581: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
582: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
583: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
584: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
585: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number

Line 582: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code

578: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
579: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
580: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
581: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
582: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
583: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
584: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
585: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
586: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number

Line 583: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name

579: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
580: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
581: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
582: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
583: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
584: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
585: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
586: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
587: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no

Line 584: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site

580: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
581: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
582: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
583: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
584: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
585: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
586: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
587: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
588: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no

Line 585: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number

581: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
582: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
583: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
584: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
585: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
586: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
587: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
588: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
589:

Line 586: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number

582: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
583: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
584: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
585: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
586: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
587: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
588: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
589:
590: --start for stability study

Line 587: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no

583: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
584: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
585: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
586: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
587: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
588: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
589:
590: --start for stability study
591: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn

Line 588: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no

584: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
585: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
586: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
587: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
588: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
589:
590: --start for stability study
591: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
592: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no

Line 591: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn

587: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
588: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
589:
590: --start for stability study
591: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
592: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
593: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --item spec
594: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
595: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec

Line 592: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no

588: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
589:
590: --start for stability study
591: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
592: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
593: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --item spec
594: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
595: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
596: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version

Line 593: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --item spec

589:
590: --start for stability study
591: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
592: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
593: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --item spec
594: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
595: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
596: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
597: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number

Line 594: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers

590: --start for stability study
591: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
592: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
593: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --item spec
594: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
595: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
596: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
597: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
598: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name

Line 595: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec

591: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
592: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
593: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --item spec
594: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
595: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
596: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
597: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
598: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
599: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date

Line 596: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version

592: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
593: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --item spec
594: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
595: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
596: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
597: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
598: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
599: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
600: --end for stability study

Line 597: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number

593: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --item spec
594: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
595: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
596: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
597: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
598: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
599: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
600: --end for stability study
601:

Line 598: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name

594: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
595: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
596: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
597: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
598: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
599: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
600: --end for stability study
601:
602:

Line 599: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date

595: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
596: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
597: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
598: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
599: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
600: --end for stability study
601:
602:
603:

Line 617: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611

613: l_order_type,
614: l_order_no,
615: l_line_no;
616: CLOSE c_get_cust_info;
617: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
618: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
619: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
620: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
621: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no

Line 618: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no

614: l_order_no,
615: l_line_no;
616: CLOSE c_get_cust_info;
617: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
618: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
619: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
620: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
621: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
622: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers

Line 619: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no

615: l_line_no;
616: CLOSE c_get_cust_info;
617: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
618: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
619: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
620: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
621: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
622: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
623: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no

Line 620: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers

616: CLOSE c_get_cust_info;
617: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
618: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
619: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
620: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
621: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
622: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
623: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
624: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers

Line 621: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no

617: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
618: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
619: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
620: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
621: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
622: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
623: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
624: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
625: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no

Line 622: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers

618: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
619: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
620: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
621: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
622: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
623: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
624: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
625: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
626: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_cust_name|| '"' || l_delim);

Line 623: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no

619: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
620: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
621: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
622: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
623: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
624: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
625: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
626: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_cust_name|| '"' || l_delim);
627: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oper_unit|| '"' || l_delim);

Line 624: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers

620: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
621: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
622: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
623: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
624: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
625: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
626: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_cust_name|| '"' || l_delim);
627: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oper_unit|| '"' || l_delim);
628: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_ship_to|| '"' || l_delim);

Line 625: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no

621: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
622: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
623: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
624: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
625: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
626: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_cust_name|| '"' || l_delim);
627: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oper_unit|| '"' || l_delim);
628: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_ship_to|| '"' || l_delim);
629: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_type|| '"' || l_delim);

Line 626: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_cust_name|| '"' || l_delim);

622: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
623: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
624: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
625: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
626: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_cust_name|| '"' || l_delim);
627: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oper_unit|| '"' || l_delim);
628: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_ship_to|| '"' || l_delim);
629: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_type|| '"' || l_delim);
630: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_no|| '"' || l_delim);

Line 627: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oper_unit|| '"' || l_delim);

623: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
624: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
625: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
626: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_cust_name|| '"' || l_delim);
627: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oper_unit|| '"' || l_delim);
628: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_ship_to|| '"' || l_delim);
629: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_type|| '"' || l_delim);
630: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_no|| '"' || l_delim);
631: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_line_no|| '"' || l_delim);

Line 628: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_ship_to|| '"' || l_delim);

624: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
625: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
626: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_cust_name|| '"' || l_delim);
627: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oper_unit|| '"' || l_delim);
628: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_ship_to|| '"' || l_delim);
629: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_type|| '"' || l_delim);
630: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_no|| '"' || l_delim);
631: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_line_no|| '"' || l_delim);
632: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code

Line 629: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_type|| '"' || l_delim);

625: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
626: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_cust_name|| '"' || l_delim);
627: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oper_unit|| '"' || l_delim);
628: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_ship_to|| '"' || l_delim);
629: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_type|| '"' || l_delim);
630: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_no|| '"' || l_delim);
631: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_line_no|| '"' || l_delim);
632: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
633: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name

Line 630: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_no|| '"' || l_delim);

626: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_cust_name|| '"' || l_delim);
627: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oper_unit|| '"' || l_delim);
628: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_ship_to|| '"' || l_delim);
629: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_type|| '"' || l_delim);
630: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_no|| '"' || l_delim);
631: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_line_no|| '"' || l_delim);
632: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
633: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
634: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site

Line 631: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_line_no|| '"' || l_delim);

627: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_oper_unit|| '"' || l_delim);
628: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_ship_to|| '"' || l_delim);
629: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_type|| '"' || l_delim);
630: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_no|| '"' || l_delim);
631: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_line_no|| '"' || l_delim);
632: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
633: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
634: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
635: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number

Line 632: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code

628: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_ship_to|| '"' || l_delim);
629: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_type|| '"' || l_delim);
630: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_no|| '"' || l_delim);
631: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_line_no|| '"' || l_delim);
632: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
633: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
634: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
635: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
636: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number

Line 633: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name

629: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_type|| '"' || l_delim);
630: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_no|| '"' || l_delim);
631: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_line_no|| '"' || l_delim);
632: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
633: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
634: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
635: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
636: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
637: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no

Line 634: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site

630: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_order_no|| '"' || l_delim);
631: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_line_no|| '"' || l_delim);
632: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
633: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
634: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
635: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
636: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
637: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
638: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no

Line 635: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number

631: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_line_no|| '"' || l_delim);
632: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
633: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
634: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
635: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
636: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
637: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
638: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
639:

Line 636: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number

632: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
633: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
634: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
635: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
636: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
637: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
638: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
639:
640:

Line 637: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no

633: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
634: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
635: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
636: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
637: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
638: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
639:
640:
641: --start for stability study

Line 638: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no

634: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
635: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
636: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
637: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
638: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
639:
640:
641: --start for stability study
642: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn

Line 642: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn

638: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
639:
640:
641: --start for stability study
642: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
643: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
644: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
645: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
646: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec

Line 643: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no

639:
640:
641: --start for stability study
642: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
643: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
644: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
645: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
646: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
647: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version

Line 644: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec

640:
641: --start for stability study
642: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
643: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
644: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
645: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
646: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
647: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
648: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number

Line 645: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers

641: --start for stability study
642: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
643: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
644: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
645: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
646: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
647: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
648: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
649: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name

Line 646: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec

642: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
643: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
644: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
645: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
646: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
647: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
648: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
649: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
650: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date

Line 647: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version

643: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
644: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
645: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
646: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
647: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
648: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
649: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
650: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
651: --end for stability study

Line 648: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number

644: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
645: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
646: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
647: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
648: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
649: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
650: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
651: --end for stability study
652:

Line 649: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name

645: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
646: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
647: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
648: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
649: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
650: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
651: --end for stability study
652:
653: ELSIF samp.source = 'S' THEN

Line 650: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date

646: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
647: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
648: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
649: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
650: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
651: --end for stability study
652:
653: ELSIF samp.source = 'S' THEN
654: OPEN c_get_supp_info (samp.sample_id);

Line 665: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611

661: l_rcpt_no,
662: l_rcpt_lineno;
663:
664: CLOSE c_get_supp_info;
665: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
666: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
667: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
668: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
669: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no

Line 666: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no

662: l_rcpt_lineno;
663:
664: CLOSE c_get_supp_info;
665: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
666: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
667: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
668: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
669: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
670: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers

Line 667: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce

663:
664: CLOSE c_get_supp_info;
665: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
666: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
667: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
668: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
669: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
670: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
671: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no

Line 668: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce

664: CLOSE c_get_supp_info;
665: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
666: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
667: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
668: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
669: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
670: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
671: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
672: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers

Line 669: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no

665: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
666: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
667: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
668: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
669: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
670: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
671: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
672: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
673: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no

Line 670: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers

666: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
667: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
668: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
669: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
670: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
671: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
672: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
673: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
674: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers

Line 671: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no

667: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
668: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
669: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
670: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
671: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
672: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
673: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
674: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
675: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no

Line 672: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers

668: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
669: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
670: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
671: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
672: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
673: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
674: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
675: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
676: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers

Line 673: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no

669: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
670: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
671: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
672: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
673: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
674: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
675: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
676: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
677: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name

Line 674: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers

670: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
671: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
672: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
673: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
674: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
675: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
676: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
677: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
678: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site

Line 675: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no

671: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
672: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
673: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
674: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
675: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
676: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
677: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
678: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
679: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type

Line 676: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers

672: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
673: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
674: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
675: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
676: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
677: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
678: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
679: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
680: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no

Line 677: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name

673: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
674: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
675: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
676: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
677: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
678: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
679: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
680: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
681: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no

Line 678: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site

674: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
675: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
676: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
677: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
678: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
679: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
680: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
681: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
682: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_code|| '"' || l_delim);

Line 679: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type

675: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
676: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
677: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
678: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
679: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
680: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
681: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
682: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_code|| '"' || l_delim);
683: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_name|| '"' || l_delim);

Line 680: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no

676: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
677: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
678: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
679: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
680: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
681: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
682: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_code|| '"' || l_delim);
683: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_name|| '"' || l_delim);
684: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_site|| '"' || l_delim);

Line 681: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no

677: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
678: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
679: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
680: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
681: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
682: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_code|| '"' || l_delim);
683: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_name|| '"' || l_delim);
684: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_site|| '"' || l_delim);
685: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_no|| '"' || l_delim);

Line 682: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_code|| '"' || l_delim);

678: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
679: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
680: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
681: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
682: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_code|| '"' || l_delim);
683: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_name|| '"' || l_delim);
684: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_site|| '"' || l_delim);
685: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_no|| '"' || l_delim);
686: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_lineno|| '"' || l_delim);

Line 683: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_name|| '"' || l_delim);

679: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
680: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
681: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
682: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_code|| '"' || l_delim);
683: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_name|| '"' || l_delim);
684: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_site|| '"' || l_delim);
685: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_no|| '"' || l_delim);
686: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_lineno|| '"' || l_delim);
687: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_no|| '"' || l_delim);

Line 684: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_site|| '"' || l_delim);

680: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
681: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
682: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_code|| '"' || l_delim);
683: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_name|| '"' || l_delim);
684: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_site|| '"' || l_delim);
685: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_no|| '"' || l_delim);
686: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_lineno|| '"' || l_delim);
687: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_no|| '"' || l_delim);
688: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_lineno|| '"');

Line 685: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_no|| '"' || l_delim);

681: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
682: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_code|| '"' || l_delim);
683: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_name|| '"' || l_delim);
684: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_site|| '"' || l_delim);
685: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_no|| '"' || l_delim);
686: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_lineno|| '"' || l_delim);
687: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_no|| '"' || l_delim);
688: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_lineno|| '"');
689:

Line 686: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_lineno|| '"' || l_delim);

682: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_code|| '"' || l_delim);
683: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_name|| '"' || l_delim);
684: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_site|| '"' || l_delim);
685: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_no|| '"' || l_delim);
686: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_lineno|| '"' || l_delim);
687: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_no|| '"' || l_delim);
688: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_lineno|| '"');
689:
690: --start for stability study

Line 687: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_no|| '"' || l_delim);

683: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_name|| '"' || l_delim);
684: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_site|| '"' || l_delim);
685: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_no|| '"' || l_delim);
686: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_lineno|| '"' || l_delim);
687: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_no|| '"' || l_delim);
688: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_lineno|| '"');
689:
690: --start for stability study
691: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn

Line 688: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_lineno|| '"');

684: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_supp_site|| '"' || l_delim);
685: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_no|| '"' || l_delim);
686: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_po_lineno|| '"' || l_delim);
687: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_no|| '"' || l_delim);
688: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_lineno|| '"');
689:
690: --start for stability study
691: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
692: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no

Line 691: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn

687: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_no|| '"' || l_delim);
688: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_lineno|| '"');
689:
690: --start for stability study
691: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
692: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
693: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
694: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
695: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec

Line 692: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no

688: FND_FILE.PUT(FND_FILE.OUTPUT,'"' ||l_rcpt_lineno|| '"');
689:
690: --start for stability study
691: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
692: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
693: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
694: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
695: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
696: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version

Line 693: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec

689:
690: --start for stability study
691: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
692: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
693: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
694: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
695: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
696: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
697: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number

Line 694: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers

690: --start for stability study
691: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
692: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
693: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
694: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
695: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
696: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
697: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
698: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name

Line 695: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec

691: FND_FILE.PUT(FND_FILE.OUTPUT,'" " ' || l_delim); --stability study orgn
692: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
693: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
694: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
695: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
696: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
697: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
698: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
699: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date

Line 696: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version

692: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- stability study no
693: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
694: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
695: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
696: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
697: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
698: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
699: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
700: --end for stability study

Line 697: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number

693: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --item spec
694: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
695: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
696: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
697: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
698: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
699: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
700: --end for stability study
701: ELSIF samp.source = 'T' THEN

Line 698: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name

694: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- item spec vers
695: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
696: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
697: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
698: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
699: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
700: --end for stability study
701: ELSIF samp.source = 'T' THEN
702: IF (samp.time_point_id IS NOT NULL) THEN

Line 699: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date

695: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage spec
696: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --storage_spec_version
697: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --variant number
698: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --time interval name
699: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); --scheduled start date
700: --end for stability study
701: ELSIF samp.source = 'T' THEN
702: IF (samp.time_point_id IS NOT NULL) THEN
703: OPEN c_get_stbl_info (samp.sample_id);

Line 714: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611

710: END IF;
711:
712:
713:
714: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
715: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
716: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
717: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
718: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no

Line 715: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no

711:
712:
713:
714: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
715: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
716: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
717: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
718: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
719: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers

Line 716: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce

712:
713:
714: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
715: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
716: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
717: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
718: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
719: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
720: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no

Line 717: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce

713:
714: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
715: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
716: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
717: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
718: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
719: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
720: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
721: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers

Line 718: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no

714: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
715: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
716: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
717: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
718: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
719: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
720: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
721: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
722: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no

Line 719: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers

715: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
716: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
717: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
718: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
719: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
720: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
721: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
722: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
723: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers

Line 720: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no

716: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
717: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
718: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
719: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
720: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
721: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
722: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
723: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
724: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no

Line 721: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers

717: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
718: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
719: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
720: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
721: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
722: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
723: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
724: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
725: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers

Line 722: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no

718: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
719: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
720: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
721: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
722: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
723: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
724: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
725: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
726: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name

Line 723: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers

719: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
720: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
721: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
722: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
723: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
724: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
725: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
726: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
727: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site

Line 724: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no

720: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
721: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
722: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
723: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
724: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
725: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
726: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
727: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
728: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type

Line 725: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers

721: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
722: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
723: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
724: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
725: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
726: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
727: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
728: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
729: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no

Line 726: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name

722: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
723: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
724: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
725: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
726: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
727: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
728: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
729: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
730: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no

Line 727: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site

723: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
724: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
725: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
726: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
727: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
728: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
729: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
730: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
731: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code

Line 728: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type

724: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
725: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
726: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
727: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
728: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
729: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
730: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
731: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
732: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name

Line 729: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no

725: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
726: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
727: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
728: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
729: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
730: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
731: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
732: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
733: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site

Line 730: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no

726: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
727: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
728: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
729: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
730: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
731: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
732: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
733: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
734: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number

Line 731: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code

727: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
728: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
729: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
730: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
731: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
732: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
733: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
734: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
735: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number

Line 732: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name

728: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
729: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
730: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
731: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
732: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
733: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
734: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
735: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
736: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no

Line 733: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site

729: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
730: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
731: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
732: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
733: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
734: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
735: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
736: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
737: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no

Line 734: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number

730: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
731: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
732: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
733: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
734: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
735: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
736: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
737: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
738:

Line 735: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number

731: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
732: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
733: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
734: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
735: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
736: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
737: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
738:
739: IF (samp.time_point_id IS NOT NULL) THEN

Line 736: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no

732: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
733: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
734: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
735: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
736: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
737: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
738:
739: IF (samp.time_point_id IS NOT NULL) THEN
740: -- JD convert stab study organization_id to organization code for display.

Line 737: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no

733: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
734: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
735: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
736: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
737: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
738:
739: IF (samp.time_point_id IS NOT NULL) THEN
740: -- JD convert stab study organization_id to organization code for display.
741: -- change c_stbl_row.orgn_code to l_stab_orgn_code.

Line 754: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_orgn_code ||'"' || l_delim); --stability sudy orgn code

750: ELSE
751: l_stab_orgn_code := NULL;
752: END IF;
753:
754: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_orgn_code ||'"' || l_delim); --stability sudy orgn code
755: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.ss_no ||'"' || l_delim); -- ss_no
756: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec ||'"' || l_delim); --item spec
757: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec_version ||'"' || l_delim); -- item spec vers
758: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec ||'"' || l_delim); --storage spec

Line 755: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.ss_no ||'"' || l_delim); -- ss_no

751: l_stab_orgn_code := NULL;
752: END IF;
753:
754: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_orgn_code ||'"' || l_delim); --stability sudy orgn code
755: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.ss_no ||'"' || l_delim); -- ss_no
756: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec ||'"' || l_delim); --item spec
757: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec_version ||'"' || l_delim); -- item spec vers
758: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec ||'"' || l_delim); --storage spec
759: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec_version ||'"' || l_delim); --storage_spec_version

Line 756: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec ||'"' || l_delim); --item spec

752: END IF;
753:
754: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_orgn_code ||'"' || l_delim); --stability sudy orgn code
755: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.ss_no ||'"' || l_delim); -- ss_no
756: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec ||'"' || l_delim); --item spec
757: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec_version ||'"' || l_delim); -- item spec vers
758: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec ||'"' || l_delim); --storage spec
759: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec_version ||'"' || l_delim); --storage_spec_version
760: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.variant_no ||'"' || l_delim); --variant number

Line 757: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec_version ||'"' || l_delim); -- item spec vers

753:
754: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_orgn_code ||'"' || l_delim); --stability sudy orgn code
755: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.ss_no ||'"' || l_delim); -- ss_no
756: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec ||'"' || l_delim); --item spec
757: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec_version ||'"' || l_delim); -- item spec vers
758: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec ||'"' || l_delim); --storage spec
759: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec_version ||'"' || l_delim); --storage_spec_version
760: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.variant_no ||'"' || l_delim); --variant number
761: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.time_interval_name ||'"' || l_delim); --time interval name

Line 758: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec ||'"' || l_delim); --storage spec

754: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_orgn_code ||'"' || l_delim); --stability sudy orgn code
755: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.ss_no ||'"' || l_delim); -- ss_no
756: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec ||'"' || l_delim); --item spec
757: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec_version ||'"' || l_delim); -- item spec vers
758: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec ||'"' || l_delim); --storage spec
759: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec_version ||'"' || l_delim); --storage_spec_version
760: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.variant_no ||'"' || l_delim); --variant number
761: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.time_interval_name ||'"' || l_delim); --time interval name
762: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.scheduled_date ||'"' || l_delim); --scheduled start date

Line 759: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec_version ||'"' || l_delim); --storage_spec_version

755: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.ss_no ||'"' || l_delim); -- ss_no
756: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec ||'"' || l_delim); --item spec
757: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec_version ||'"' || l_delim); -- item spec vers
758: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec ||'"' || l_delim); --storage spec
759: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec_version ||'"' || l_delim); --storage_spec_version
760: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.variant_no ||'"' || l_delim); --variant number
761: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.time_interval_name ||'"' || l_delim); --time interval name
762: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.scheduled_date ||'"' || l_delim); --scheduled start date
763: ELSE

Line 760: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.variant_no ||'"' || l_delim); --variant number

756: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec ||'"' || l_delim); --item spec
757: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec_version ||'"' || l_delim); -- item spec vers
758: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec ||'"' || l_delim); --storage spec
759: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec_version ||'"' || l_delim); --storage_spec_version
760: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.variant_no ||'"' || l_delim); --variant number
761: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.time_interval_name ||'"' || l_delim); --time interval name
762: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.scheduled_date ||'"' || l_delim); --scheduled start date
763: ELSE
764: -- JD convert retain ss organization_id to organization code for display.

Line 761: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.time_interval_name ||'"' || l_delim); --time interval name

757: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.item_spec_version ||'"' || l_delim); -- item spec vers
758: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec ||'"' || l_delim); --storage spec
759: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec_version ||'"' || l_delim); --storage_spec_version
760: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.variant_no ||'"' || l_delim); --variant number
761: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.time_interval_name ||'"' || l_delim); --time interval name
762: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.scheduled_date ||'"' || l_delim); --scheduled start date
763: ELSE
764: -- JD convert retain ss organization_id to organization code for display.
765: -- change c_stbl_row_retain.orgn_code to l_stab_orgn_code.

Line 762: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.scheduled_date ||'"' || l_delim); --scheduled start date

758: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec ||'"' || l_delim); --storage spec
759: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.storage_spec_version ||'"' || l_delim); --storage_spec_version
760: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.variant_no ||'"' || l_delim); --variant number
761: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.time_interval_name ||'"' || l_delim); --time interval name
762: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row.scheduled_date ||'"' || l_delim); --scheduled start date
763: ELSE
764: -- JD convert retain ss organization_id to organization code for display.
765: -- change c_stbl_row_retain.orgn_code to l_stab_orgn_code.
766:

Line 778: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_retain_orgn_code ||'"' || l_delim); --stability sudy orgn code

774: ELSE
775: l_stab_retain_orgn_code := NULL;
776: END IF;
777:
778: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_retain_orgn_code ||'"' || l_delim); --stability sudy orgn code
779: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.ss_no ||'"' || l_delim); -- ss_no
780: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec ||'"' || l_delim); --item spec
781: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec_version ||'"' || l_delim); -- item spec vers
782: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec ||'"' || l_delim); --storage spec

Line 779: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.ss_no ||'"' || l_delim); -- ss_no

775: l_stab_retain_orgn_code := NULL;
776: END IF;
777:
778: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_retain_orgn_code ||'"' || l_delim); --stability sudy orgn code
779: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.ss_no ||'"' || l_delim); -- ss_no
780: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec ||'"' || l_delim); --item spec
781: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec_version ||'"' || l_delim); -- item spec vers
782: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec ||'"' || l_delim); --storage spec
783: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec_version ||'"' || l_delim); --storage_spec_version

Line 780: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec ||'"' || l_delim); --item spec

776: END IF;
777:
778: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_retain_orgn_code ||'"' || l_delim); --stability sudy orgn code
779: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.ss_no ||'"' || l_delim); -- ss_no
780: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec ||'"' || l_delim); --item spec
781: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec_version ||'"' || l_delim); -- item spec vers
782: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec ||'"' || l_delim); --storage spec
783: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec_version ||'"' || l_delim); --storage_spec_version
784: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.variant_no ||'"' || l_delim); --variant number

Line 781: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec_version ||'"' || l_delim); -- item spec vers

777:
778: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_retain_orgn_code ||'"' || l_delim); --stability sudy orgn code
779: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.ss_no ||'"' || l_delim); -- ss_no
780: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec ||'"' || l_delim); --item spec
781: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec_version ||'"' || l_delim); -- item spec vers
782: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec ||'"' || l_delim); --storage spec
783: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec_version ||'"' || l_delim); --storage_spec_version
784: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.variant_no ||'"' || l_delim); --variant number
785: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.time_interval_name ||'"' || l_delim); --time interval name

Line 782: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec ||'"' || l_delim); --storage spec

778: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||l_stab_retain_orgn_code ||'"' || l_delim); --stability sudy orgn code
779: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.ss_no ||'"' || l_delim); -- ss_no
780: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec ||'"' || l_delim); --item spec
781: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec_version ||'"' || l_delim); -- item spec vers
782: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec ||'"' || l_delim); --storage spec
783: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec_version ||'"' || l_delim); --storage_spec_version
784: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.variant_no ||'"' || l_delim); --variant number
785: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.time_interval_name ||'"' || l_delim); --time interval name
786: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.scheduled_date ||'"' || l_delim); --scheduled start date

Line 783: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec_version ||'"' || l_delim); --storage_spec_version

779: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.ss_no ||'"' || l_delim); -- ss_no
780: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec ||'"' || l_delim); --item spec
781: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec_version ||'"' || l_delim); -- item spec vers
782: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec ||'"' || l_delim); --storage spec
783: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec_version ||'"' || l_delim); --storage_spec_version
784: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.variant_no ||'"' || l_delim); --variant number
785: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.time_interval_name ||'"' || l_delim); --time interval name
786: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.scheduled_date ||'"' || l_delim); --scheduled start date
787: END IF;

Line 784: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.variant_no ||'"' || l_delim); --variant number

780: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec ||'"' || l_delim); --item spec
781: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec_version ||'"' || l_delim); -- item spec vers
782: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec ||'"' || l_delim); --storage spec
783: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec_version ||'"' || l_delim); --storage_spec_version
784: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.variant_no ||'"' || l_delim); --variant number
785: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.time_interval_name ||'"' || l_delim); --time interval name
786: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.scheduled_date ||'"' || l_delim); --scheduled start date
787: END IF;
788:

Line 785: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.time_interval_name ||'"' || l_delim); --time interval name

781: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.item_spec_version ||'"' || l_delim); -- item spec vers
782: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec ||'"' || l_delim); --storage spec
783: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec_version ||'"' || l_delim); --storage_spec_version
784: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.variant_no ||'"' || l_delim); --variant number
785: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.time_interval_name ||'"' || l_delim); --time interval name
786: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.scheduled_date ||'"' || l_delim); --scheduled start date
787: END IF;
788:
789: --end for stability study

Line 786: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.scheduled_date ||'"' || l_delim); --scheduled start date

782: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec ||'"' || l_delim); --storage spec
783: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.storage_spec_version ||'"' || l_delim); --storage_spec_version
784: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.variant_no ||'"' || l_delim); --variant number
785: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.time_interval_name ||'"' || l_delim); --time interval name
786: FND_FILE.PUT(FND_FILE.OUTPUT,'"'||c_stbl_row_retain.scheduled_date ||'"' || l_delim); --scheduled start date
787: END IF;
788:
789: --end for stability study
790:

Line 792: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611

788:
789: --end for stability study
790:
791: ELSE
792: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
793: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
794: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
795: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
796: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no

Line 793: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no

789: --end for stability study
790:
791: ELSE
792: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
793: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
794: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
795: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
796: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
797: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers

Line 794: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce

790:
791: ELSE
792: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
793: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
794: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
795: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
796: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
797: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
798: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no

Line 795: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce

791: ELSE
792: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
793: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
794: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
795: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
796: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
797: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
798: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
799: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers

Line 796: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no

792: --FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce --BUG# 4612611
793: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
794: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
795: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
796: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
797: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
798: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
799: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
800: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no

Line 797: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers

793: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- batch_no
794: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
795: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
796: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
797: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
798: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
799: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
800: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
801: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers

Line 798: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no

794: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
795: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
796: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
797: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
798: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
799: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
800: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
801: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
802: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no

Line 799: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers

795: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- plant_codce
796: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
797: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
798: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
799: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
800: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
801: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
802: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
803: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers

Line 800: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no

796: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_no
797: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
798: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
799: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
800: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
801: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
802: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
803: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
804: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name

Line 801: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers

797: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- formula_vers
798: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
799: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
800: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
801: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
802: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
803: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
804: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
805: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site

Line 802: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no

798: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_no
799: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
800: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
801: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
802: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
803: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
804: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
805: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
806: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type

Line 803: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers

799: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- oprn_vers
800: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
801: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
802: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
803: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
804: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
805: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
806: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
807: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no

Line 804: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name

800: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_no
801: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
802: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
803: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
804: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
805: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
806: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
807: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
808: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no

Line 805: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site

801: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- recipe_vers
802: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
803: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
804: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
805: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
806: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
807: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
808: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
809: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code

Line 806: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type

802: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_no
803: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
804: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
805: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
806: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
807: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
808: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
809: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
810: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name

Line 807: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no

803: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- routing_vers
804: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
805: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
806: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
807: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
808: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
809: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
810: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
811: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site

Line 808: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no

804: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- customer name
805: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
806: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
807: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
808: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
809: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
810: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
811: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
812: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number

Line 809: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code

805: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- ship_to_site
806: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
807: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
808: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
809: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
810: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
811: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
812: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
813: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number

Line 810: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name

806: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_type
807: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
808: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
809: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
810: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
811: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
812: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
813: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
814: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no

Line 811: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site

807: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- order_no
808: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
809: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
810: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
811: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
812: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
813: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
814: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
815: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no

Line 812: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number

808: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- line_no
809: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
810: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
811: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
812: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
813: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
814: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
815: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
816: END IF;

Line 813: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number

809: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_code
810: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
811: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
812: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
813: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
814: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
815: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
816: END IF;
817:

Line 814: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no

810: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_name
811: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
812: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
813: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
814: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
815: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
816: END IF;
817:
818: l_total_lines := l_total_lines + 1.0;

Line 815: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no

811: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- supplier_site
812: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_number
813: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- po_line_number
814: FND_FILE.PUT(FND_FILE.OUTPUT,'" "' || l_delim); -- reicpt_no
815: FND_FILE.PUT(FND_FILE.OUTPUT,'" "'); -- receipt_line_no
816: END IF;
817:
818: l_total_lines := l_total_lines + 1.0;
819:

Line 820: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

816: END IF;
817:
818: l_total_lines := l_total_lines + 1.0;
819:
820: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
821:
822: END LOOP;
823:
824: -- JD changed p_orgn_code to p_organization_id.

Line 829: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

825:
826: IF l_total_lines = 0 THEN
827: RAISE NO_SAMPLES_FOUND;
828: ELSIF (p_organization_id IS NOT NULL) THEN
829: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
830: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
831: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);

Line 830: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');

826: IF l_total_lines = 0 THEN
827: RAISE NO_SAMPLES_FOUND;
828: ELSIF (p_organization_id IS NOT NULL) THEN
829: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
830: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
831: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
834: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);

Line 831: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');

827: RAISE NO_SAMPLES_FOUND;
828: ELSIF (p_organization_id IS NOT NULL) THEN
829: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
830: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
831: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
834: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
835: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);

Line 832: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);

828: ELSIF (p_organization_id IS NOT NULL) THEN
829: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
830: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
831: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
834: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
835: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 833: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);

829: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
830: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
831: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
834: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
835: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: ELSE

Line 834: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);

830: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
831: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
834: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
835: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: ELSE
838: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 835: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);

831: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
834: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
835: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: ELSE
838: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
839: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');

Line 836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

832: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
834: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
835: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: ELSE
838: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
839: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
840: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');

Line 838: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

834: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
835: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: ELSE
838: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
839: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
840: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
841: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
842: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);

Line 839: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');

835: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: ELSE
838: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
839: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
840: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
841: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
842: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);
843: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);

Line 840: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');

836: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
837: ELSE
838: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
839: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
840: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
841: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
842: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);
843: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
844: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 841: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);

837: ELSE
838: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
839: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
840: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
841: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
842: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);
843: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
844: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
845: END IF;

Line 842: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);

838: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
839: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
840: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
841: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
842: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);
843: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
844: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
845: END IF;
846:

Line 843: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);

839: FND_FILE.PUT_LINE(FND_FILE.LOG,' Please Check View/Output For Output ');
840: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
841: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
842: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);
843: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
844: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
845: END IF;
846:
847:

Line 844: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

840: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Samples Generated => ' || l_total_lines ||' For Input Values Defined ');
841: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
842: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);
843: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
844: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
845: END IF;
846:
847:
848: EXCEPTION

Line 853: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');

849: -- JD changed p_orgn_code to p_organization_id.
850:
851: WHEN NO_SAMPLES_FOUND THEN
852: IF (p_organization_id IS NOT NULL) THEN
853: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
854: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
855: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
856: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
857: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);

Line 854: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);

850:
851: WHEN NO_SAMPLES_FOUND THEN
852: IF (p_organization_id IS NOT NULL) THEN
853: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
854: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
855: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
856: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
857: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
858: ELSE

Line 855: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);

851: WHEN NO_SAMPLES_FOUND THEN
852: IF (p_organization_id IS NOT NULL) THEN
853: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
854: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
855: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
856: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
857: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
858: ELSE
859: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');

Line 856: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);

852: IF (p_organization_id IS NOT NULL) THEN
853: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
854: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
855: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
856: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
857: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
858: ELSE
859: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
860: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);

Line 857: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);

853: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
854: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
855: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
856: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
857: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
858: ELSE
859: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
860: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
861: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);

Line 859: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');

855: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
856: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
857: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
858: ELSE
859: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
860: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
861: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);
862: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
863: END IF;

Line 860: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);

856: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
857: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
858: ELSE
859: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
860: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
861: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);
862: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
863: END IF;
864:

Line 861: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);

857: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
858: ELSE
859: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
860: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
861: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);
862: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
863: END IF;
864:
865:

Line 862: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);

858: ELSE
859: FND_FILE.PUT_LINE(FND_FILE.LOG,'No sample records found for :');
860: FND_FILE.PUT_LINE(FND_FILE.LOG,'VARIANT_ID => ' || p_variant_id);
861: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME_POINT_ID => ' || p_time_point_id);
862: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
863: END IF;
864:
865:
866:

Line 868: FND_FILE.PUT_LINE(FND_FILE.LOG,'Required Parameters Missing :');

864:
865:
866:
867: WHEN NO_PARAMETERS_DEFINED THEN
868: FND_FILE.PUT_LINE(FND_FILE.LOG,'Required Parameters Missing :');
869: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
871: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
872: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);

Line 869: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);

865:
866:
867: WHEN NO_PARAMETERS_DEFINED THEN
868: FND_FILE.PUT_LINE(FND_FILE.LOG,'Required Parameters Missing :');
869: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
871: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
872: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
873: WHEN OTHERS THEN

Line 870: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);

866:
867: WHEN NO_PARAMETERS_DEFINED THEN
868: FND_FILE.PUT_LINE(FND_FILE.LOG,'Required Parameters Missing :');
869: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
871: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
872: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
873: WHEN OTHERS THEN
874: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrant Program Raised WHEN OTHERS EXCEPTION');

Line 871: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);

867: WHEN NO_PARAMETERS_DEFINED THEN
868: FND_FILE.PUT_LINE(FND_FILE.LOG,'Required Parameters Missing :');
869: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
871: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
872: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
873: WHEN OTHERS THEN
874: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrant Program Raised WHEN OTHERS EXCEPTION');
875:

Line 872: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);

868: FND_FILE.PUT_LINE(FND_FILE.LOG,'Required Parameters Missing :');
869: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION_ID => ' || p_organization_id);
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
871: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
872: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
873: WHEN OTHERS THEN
874: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrant Program Raised WHEN OTHERS EXCEPTION');
875:
876: END SAMPLE_GEN_SRS;

Line 874: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrant Program Raised WHEN OTHERS EXCEPTION');

870: FND_FILE.PUT_LINE(FND_FILE.LOG,'FROM SAMPLE => ' || p_from_sample_no);
871: FND_FILE.PUT_LINE(FND_FILE.LOG,'TO SAMPLE => ' || p_to_sample_no);
872: FND_FILE.PUT_LINE(FND_FILE.LOG,'DELIMITER => ' || p_delimiter);
873: WHEN OTHERS THEN
874: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrant Program Raised WHEN OTHERS EXCEPTION');
875:
876: END SAMPLE_GEN_SRS;
877:
878: