1360: return;
1361: end if;
1362: end if;
1363:
1364: fnd_message.set_name('FND', 'PURGING_UP_TO_DATE');
1365: fnd_message.set_token('ENTITY', 'FND_LOG_MESSAGES');
1366: if (last_date is NULL) then
1367: fnd_message.set_token('DATE', 'WF_ALL', TRUE);
1368: else
1361: end if;
1362: end if;
1363:
1364: fnd_message.set_name('FND', 'PURGING_UP_TO_DATE');
1365: fnd_message.set_token('ENTITY', 'FND_LOG_MESSAGES');
1366: if (last_date is NULL) then
1367: fnd_message.set_token('DATE', 'WF_ALL', TRUE);
1368: else
1369: fnd_message.set_token('DATE', last_date);
1363:
1364: fnd_message.set_name('FND', 'PURGING_UP_TO_DATE');
1365: fnd_message.set_token('ENTITY', 'FND_LOG_MESSAGES');
1366: if (last_date is NULL) then
1367: fnd_message.set_token('DATE', 'WF_ALL', TRUE);
1368: else
1369: fnd_message.set_token('DATE', last_date);
1370: end if;
1371: msgbuf := fnd_message.get;
1365: fnd_message.set_token('ENTITY', 'FND_LOG_MESSAGES');
1366: if (last_date is NULL) then
1367: fnd_message.set_token('DATE', 'WF_ALL', TRUE);
1368: else
1369: fnd_message.set_token('DATE', last_date);
1370: end if;
1371: msgbuf := fnd_message.get;
1372: FND_FILE.put_line(FND_FILE.log, msgbuf);
1373:
1367: fnd_message.set_token('DATE', 'WF_ALL', TRUE);
1368: else
1369: fnd_message.set_token('DATE', last_date);
1370: end if;
1371: msgbuf := fnd_message.get;
1372: FND_FILE.put_line(FND_FILE.log, msgbuf);
1373:
1374: /* Delete from the date back in time */
1375: numrows := delete_by_date_range(NULL, last_dt);
1373:
1374: /* Delete from the date back in time */
1375: numrows := delete_by_date_range(NULL, last_dt);
1376:
1377: fnd_message.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1378: fnd_message.set_token('ROWS', numrows);
1379: msgbuf := fnd_message.get;
1380: FND_FILE.put_line(FND_FILE.log, msgbuf);
1381:
1374: /* Delete from the date back in time */
1375: numrows := delete_by_date_range(NULL, last_dt);
1376:
1377: fnd_message.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1378: fnd_message.set_token('ROWS', numrows);
1379: msgbuf := fnd_message.get;
1380: FND_FILE.put_line(FND_FILE.log, msgbuf);
1381:
1382: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1375: numrows := delete_by_date_range(NULL, last_dt);
1376:
1377: fnd_message.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1378: fnd_message.set_token('ROWS', numrows);
1379: msgbuf := fnd_message.get;
1380: FND_FILE.put_line(FND_FILE.log, msgbuf);
1381:
1382: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1383: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,