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.IBW_PURGE_PVT dependencies on FND_FILE

Line 160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

156: BEGIN
157:
158: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PUR_DATE');
159: FND_MESSAGE.SET_TOKEN('DATE', to_char(sysdate));
160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
161:
162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
163:
164: IF execmode = 'Y' THEN

Line 162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

158: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PUR_DATE');
159: FND_MESSAGE.SET_TOKEN('DATE', to_char(sysdate));
160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
161:
162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
163:
164: IF execmode = 'Y' THEN
165: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_EXECMODE');
166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

Line 166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
163:
164: IF execmode = 'Y' THEN
165: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_EXECMODE');
166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
167: ELSE
168: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_EVALMODE');
169: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
170: END IF;

Line 169: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

165: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_EXECMODE');
166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
167: ELSE
168: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_EVALMODE');
169: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
170: END IF;
171:
172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
173:

Line 172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

168: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_EVALMODE');
169: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
170: END IF;
171:
172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
173:
174: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_DATERANGE');
175: FND_MESSAGE.SET_TOKEN('START_DATE', to_char(start_date,'DD-MON-RRRR'));
176: FND_MESSAGE.SET_TOKEN('END_DATE', to_char(end_date,'DD-MON-RRRR'));

Line 177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

173:
174: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_DATERANGE');
175: FND_MESSAGE.SET_TOKEN('START_DATE', to_char(start_date,'DD-MON-RRRR'));
176: FND_MESSAGE.SET_TOKEN('END_DATE', to_char(end_date,'DD-MON-RRRR'));
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
178:
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
180:
181: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_REPORT');

Line 179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

175: FND_MESSAGE.SET_TOKEN('START_DATE', to_char(start_date,'DD-MON-RRRR'));
176: FND_MESSAGE.SET_TOKEN('END_DATE', to_char(end_date,'DD-MON-RRRR'));
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
178:
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
180:
181: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_REPORT');
182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
183:

Line 182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

178:
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
180:
181: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_REPORT');
182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
183:
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '===============================================');
185:
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '===============================================');

180:
181: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_REPORT');
182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
183:
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '===============================================');
185:
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
187:
188: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_PAGEVIEWS');

Line 186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
183:
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '===============================================');
185:
186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
187:
188: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_PAGEVIEWS');
189: FND_MESSAGE.SET_TOKEN('COUNT', to_char(page_view_count));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

Line 190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
187:
188: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_PAGEVIEWS');
189: FND_MESSAGE.SET_TOKEN('COUNT', to_char(page_view_count));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
191:
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
193:
194: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_VISITS');

Line 192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

188: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_PAGEVIEWS');
189: FND_MESSAGE.SET_TOKEN('COUNT', to_char(page_view_count));
190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
191:
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
193:
194: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_VISITS');
195: FND_MESSAGE.SET_TOKEN('COUNT', to_char(visit_count));
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

Line 196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
193:
194: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_VISITS');
195: FND_MESSAGE.SET_TOKEN('COUNT', to_char(visit_count));
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
197:
198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
199:
200: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_VISITORS');

Line 198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

194: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_VISITS');
195: FND_MESSAGE.SET_TOKEN('COUNT', to_char(visit_count));
196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
197:
198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
199:
200: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_VISITORS');
201: FND_MESSAGE.SET_TOKEN('COUNT', to_char(visitor_count));
202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

Line 202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
199:
200: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_VISITORS');
201: FND_MESSAGE.SET_TOKEN('COUNT', to_char(visitor_count));
202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
203: END report_gen;
204:
205:
206: PROCEDURE data_purge (

Line 236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

232: /** If end_date is null, then exit the procedure
233: */
234: IF end_date=null THEN
235: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_NULLDATE_ERR');
236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
237: raise INVALID_DATE;
238: /** If start_date is greater than the end_date, then exit the procedure.
239: */
240: ELSIF startDate >= end_date THEN

Line 242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);

238: /** If start_date is greater than the end_date, then exit the procedure.
239: */
240: ELSIF startDate >= end_date THEN
241: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_DATE_ERR');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
243: raise INVALID_DATE;
244:
245: ELSE
246: sDate := to_date(startDate, 'RRRR/MM/DD HH24:MI:SS');