584:
585: BEGIN
586:
587: IF fnd_global.conc_request_id > 0 THEN
588: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);
589: ELSE
590: NULL;
591: END IF;
592:
634: '','','','','','','','','','');
635:
636: IF l_conc_id = 0 THEN
637: G_log_text := FND_MESSAGE.GET;
638: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
639: ELSE
640: COMMIT ;
641: END IF;
642:
709:
710: LOOP
711: IF l_len > l_limit THEN
712: file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
713: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
714: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
715: file_varchar2 := NULL;
716: l_limit:= l_limit + 100;
717: ELSE
710: LOOP
711: IF l_len > l_limit THEN
712: file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
713: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
714: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
715: file_varchar2 := NULL;
716: l_limit:= l_limit + 100;
717: ELSE
718: file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
715: file_varchar2 := NULL;
716: l_limit:= l_limit + 100;
717: ELSE
718: file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
719: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
720: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
721: file_varchar2 := NULL;
722: EXIT;
723: END IF;
716: l_limit:= l_limit + 100;
717: ELSE
718: file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
719: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
720: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
721: file_varchar2 := NULL;
722: EXIT;
723: END IF;
724: END LOOP;