225: Disable_Debug;
226: END IF;
227:
228: IF (G_Process = 'PLSQL') then
229: Select decode(G_WriteFile,'LOG',FND_FILE.LOG,FND_FILE.OUTPUT )
230: Into G_WriteFileID
231: From dual;
232: ELSIF (G_Process = 'REPORT') then
233: Enable_Debug; /* If REPORT is used, then need to enable debug */
261: END IF; -- IF (rest IS NULL)
262:
263: IF G_Process = 'PLSQL' then
264: IF NVL(x_Write_File,G_WriteFile) = 'OUT' then
265: FND_FILE.PUT(FND_FILE.OUTPUT,rest1);
266: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
267: ELSIF NVL(x_Write_File,G_WriteFile) = 'LOG' then
268: FND_FILE.PUT(FND_FILE.LOG,rest1);
269: FND_FILE.NEW_LINE(FND_FILE.LOG);
262:
263: IF G_Process = 'PLSQL' then
264: IF NVL(x_Write_File,G_WriteFile) = 'OUT' then
265: FND_FILE.PUT(FND_FILE.OUTPUT,rest1);
266: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
267: ELSIF NVL(x_Write_File,G_WriteFile) = 'LOG' then
268: FND_FILE.PUT(FND_FILE.LOG,rest1);
269: FND_FILE.NEW_LINE(FND_FILE.LOG);
270: ELSE
264: IF NVL(x_Write_File,G_WriteFile) = 'OUT' then
265: FND_FILE.PUT(FND_FILE.OUTPUT,rest1);
266: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
267: ELSIF NVL(x_Write_File,G_WriteFile) = 'LOG' then
268: FND_FILE.PUT(FND_FILE.LOG,rest1);
269: FND_FILE.NEW_LINE(FND_FILE.LOG);
270: ELSE
271: FND_FILE.PUT(G_WriteFileID,rest1);
272: FND_FILE.NEW_LINE(G_WriteFileID);
265: FND_FILE.PUT(FND_FILE.OUTPUT,rest1);
266: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
267: ELSIF NVL(x_Write_File,G_WriteFile) = 'LOG' then
268: FND_FILE.PUT(FND_FILE.LOG,rest1);
269: FND_FILE.NEW_LINE(FND_FILE.LOG);
270: ELSE
271: FND_FILE.PUT(G_WriteFileID,rest1);
272: FND_FILE.NEW_LINE(G_WriteFileID);
273: END IF;
267: ELSIF NVL(x_Write_File,G_WriteFile) = 'LOG' then
268: FND_FILE.PUT(FND_FILE.LOG,rest1);
269: FND_FILE.NEW_LINE(FND_FILE.LOG);
270: ELSE
271: FND_FILE.PUT(G_WriteFileID,rest1);
272: FND_FILE.NEW_LINE(G_WriteFileID);
273: END IF;
274: ELSIF G_Process = 'SQL' then
275: /* DBMS_OUTPUT.PUT_LINE(rest1); */
268: FND_FILE.PUT(FND_FILE.LOG,rest1);
269: FND_FILE.NEW_LINE(FND_FILE.LOG);
270: ELSE
271: FND_FILE.PUT(G_WriteFileID,rest1);
272: FND_FILE.NEW_LINE(G_WriteFileID);
273: END IF;
274: ELSIF G_Process = 'SQL' then
275: /* DBMS_OUTPUT.PUT_LINE(rest1); */
276: NULL;