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_MESSAGE

Line 158: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PUR_DATE');

154: )
155: IS
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, '');

Line 159: FND_MESSAGE.SET_TOKEN('DATE', to_char(sysdate));

155: IS
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:

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 165: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_EXECMODE');

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);
167: ELSE
168: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_EVALMODE');
169: 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 168: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_EVALMODE');

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;
171:
172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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 174: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_DATERANGE');

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'));
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
178:

Line 175: FND_MESSAGE.SET_TOKEN('START_DATE', to_char(start_date,'DD-MON-RRRR'));

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'));
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
178:
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 176: FND_MESSAGE.SET_TOKEN('END_DATE', to_char(end_date,'DD-MON-RRRR'));

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'));
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET);
178:
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
180:

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 181: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_REPORT');

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:
184: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '===============================================');
185:

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 188: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_PAGEVIEWS');

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);
191:
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 189: FND_MESSAGE.SET_TOKEN('COUNT', to_char(page_view_count));

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);
191:
192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
193:

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 194: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_VISITS');

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);
197:
198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 195: FND_MESSAGE.SET_TOKEN('COUNT', to_char(visit_count));

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);
197:
198: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
199:

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 200: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_VISITORS');

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);
203: END report_gen;
204:

Line 201: FND_MESSAGE.SET_TOKEN('COUNT', to_char(visitor_count));

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);
203: END report_gen;
204:
205:

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 235: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_NULLDATE_ERR');

231:
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: */

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 241: FND_MESSAGE.SET_NAME('IBW','IBW_TR_PURGE_DATE_ERR');

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
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

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');

Line 300: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_VISITS');

296: SELECT COUNT(site_visit_id) INTO cnt
297: FROM ibw_site_visits
298: WHERE visit_start_time between startDate AND end_date;
299:
300: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_VISITS');
301: fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));
302:
303: /** purge ibw_page_views */
304: SELECT COUNT(page_view_id) INTO cnt

Line 310: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_PAGEVIEWS');

306: WHERE 0 = (SELECT COUNT(visit_id)
307: FROM ibw_site_visits v
308: WHERE v.visit_id=pv.visit_id);
309:
310: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_PAGEVIEWS');
311: fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));
312:
313:
314: /** purge ibw_visitors */

Line 321: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_VISITORS');

317: WHERE 0 = (SELECT COUNT(visitor_id)
318: FROM ibw_site_visits visit
319: WHERE visit.visitor_id=visitors.visitor_id);
320:
321: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_VISITORS');
322: fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));
323:
324:
325: END IF;