DBA Data[Home] [Help]

APPS.FND_SOA_UTIL dependencies on FND_SOA_RUNTIME_ERROR

Line 70: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RUNTIME_ERROR - '||deleted_error_count);

66: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_BODY_PIECE - '||deleted_att_count);
67:
68: /* Purge Function to delete all Error Data */
69: deleted_error_count := delete_error_by_date_range(v_strt_date,v_end_date);
70: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RUNTIME_ERROR - '||deleted_error_count);
71:
72: errbuf := '';
73: retcode := '0';
74:

Line 242: DELETE FROM FND_SOA_RUNTIME_ERROR RE

238: BEGIN
239: LOOP
240: BEGIN
241:
242: DELETE FROM FND_SOA_RUNTIME_ERROR RE
243: WHERE (message_id NOT IN
244: (SELECT message_id FROM FND_SOA_REQUEST))
245: AND rownum <= 20000;
246:

Line 264: 'Deleted '|| rowcount ||' rows from FND_SOA_RUNTIME_ERROR');

260: END IF;
261: END;
262: END LOOP;
263: fnd_file.put_line(fnd_file.output,
264: 'Deleted '|| rowcount ||' rows from FND_SOA_RUNTIME_ERROR');
265: RETURN rowcount;
266: END;
267:
268: /* Purge function to delete all Log Data */