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.GCS_LEX_MAP_API_PKG dependencies on FND_MESSAGE

Line 196: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_HEADER');

192: PROCEDURE Write_Header_Output( Idt_Name VARCHAR2,
193: Staging_Table VARCHAR2,
194: Filter_Text VARCHAR2) IS
195: BEGIN
196: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_HEADER');
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
199:
200: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_IDT');

Line 197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

193: Staging_Table VARCHAR2,
194: Filter_Text VARCHAR2) IS
195: BEGIN
196: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_HEADER');
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
199:
200: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_IDT');
201: FND_MESSAGE.set_token('IDT_NAME', idt_name);

Line 200: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_IDT');

196: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_HEADER');
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
199:
200: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_IDT');
201: FND_MESSAGE.set_token('IDT_NAME', idt_name);
202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
203:
204: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_STG_TBL');

Line 201: FND_MESSAGE.set_token('IDT_NAME', idt_name);

197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
199:
200: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_IDT');
201: FND_MESSAGE.set_token('IDT_NAME', idt_name);
202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
203:
204: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_STG_TBL');
205: FND_MESSAGE.set_token('STG_TBL', staging_table);

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

198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
199:
200: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_IDT');
201: FND_MESSAGE.set_token('IDT_NAME', idt_name);
202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
203:
204: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_STG_TBL');
205: FND_MESSAGE.set_token('STG_TBL', staging_table);
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 204: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_STG_TBL');

200: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_IDT');
201: FND_MESSAGE.set_token('IDT_NAME', idt_name);
202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
203:
204: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_STG_TBL');
205: FND_MESSAGE.set_token('STG_TBL', staging_table);
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
207:
208: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_FILTER');

Line 205: FND_MESSAGE.set_token('STG_TBL', staging_table);

201: FND_MESSAGE.set_token('IDT_NAME', idt_name);
202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
203:
204: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_STG_TBL');
205: FND_MESSAGE.set_token('STG_TBL', staging_table);
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
207:
208: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_FILTER');
209: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);

Line 206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
203:
204: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_STG_TBL');
205: FND_MESSAGE.set_token('STG_TBL', staging_table);
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
207:
208: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_FILTER');
209: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 208: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_FILTER');

204: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_STG_TBL');
205: FND_MESSAGE.set_token('STG_TBL', staging_table);
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
207:
208: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_FILTER');
209: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
211:
212: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_REQ_ID');

Line 209: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);

205: FND_MESSAGE.set_token('STG_TBL', staging_table);
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
207:
208: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_FILTER');
209: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
211:
212: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_REQ_ID');
213: FND_MESSAGE.set_token('REQ_ID', fnd_global.conc_request_id);

Line 210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
207:
208: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_FILTER');
209: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
211:
212: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_REQ_ID');
213: FND_MESSAGE.set_token('REQ_ID', fnd_global.conc_request_id);
214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 212: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_REQ_ID');

208: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_FILTER');
209: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
211:
212: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_REQ_ID');
213: FND_MESSAGE.set_token('REQ_ID', fnd_global.conc_request_id);
214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
215: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
216:

Line 213: FND_MESSAGE.set_token('REQ_ID', fnd_global.conc_request_id);

209: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);
210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
211:
212: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_REQ_ID');
213: FND_MESSAGE.set_token('REQ_ID', fnd_global.conc_request_id);
214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
215: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
216:
217: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SEPARATOR');

Line 214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

210: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
211:
212: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_REQ_ID');
213: FND_MESSAGE.set_token('REQ_ID', fnd_global.conc_request_id);
214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
215: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
216:
217: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SEPARATOR');
218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 217: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SEPARATOR');

213: FND_MESSAGE.set_token('REQ_ID', fnd_global.conc_request_id);
214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
215: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
216:
217: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SEPARATOR');
218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
219: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
220: END Write_Header_Output;
221:

Line 218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
215: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
216:
217: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SEPARATOR');
218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
219: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
220: END Write_Header_Output;
221:
222:

Line 241: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL');

237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
238: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
239: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
240:
241: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
243:
244: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL_SEPARATOR');
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

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

238: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
239: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
240:
241: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
243:
244: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL_SEPARATOR');
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
246:

Line 244: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL_SEPARATOR');

240:
241: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
243:
244: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL_SEPARATOR');
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
246:
247: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX01_LEGEND');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

241: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
243:
244: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL_SEPARATOR');
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
246:
247: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX01_LEGEND');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
249:

Line 247: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX01_LEGEND');

243:
244: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL_SEPARATOR');
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
246:
247: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX01_LEGEND');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
249:
250: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX02_LEGEND');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

244: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TAIL_SEPARATOR');
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
246:
247: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX01_LEGEND');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
249:
250: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX02_LEGEND');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
252:

Line 250: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX02_LEGEND');

246:
247: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX01_LEGEND');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
249:
250: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX02_LEGEND');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
252:
253: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX03_LEGEND');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

247: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX01_LEGEND');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
249:
250: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX02_LEGEND');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
252:
253: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX03_LEGEND');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
255:

Line 253: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX03_LEGEND');

249:
250: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX02_LEGEND');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
252:
253: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX03_LEGEND');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
255:
256: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX04_LEGEND');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

250: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX02_LEGEND');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
252:
253: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX03_LEGEND');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
255:
256: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX04_LEGEND');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
258:

Line 256: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX04_LEGEND');

252:
253: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX03_LEGEND');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
255:
256: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX04_LEGEND');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
258:
259: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX05_LEGEND');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

253: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX03_LEGEND');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
255:
256: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX04_LEGEND');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
258:
259: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX05_LEGEND');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
261:

Line 259: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX05_LEGEND');

255:
256: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX04_LEGEND');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
258:
259: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX05_LEGEND');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
261:
262: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX99_LEGEND');
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

256: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX04_LEGEND');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
258:
259: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX05_LEGEND');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
261:
262: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX99_LEGEND');
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
264: END Write_Tail_Output;

Line 262: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX99_LEGEND');

258:
259: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX05_LEGEND');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
261:
262: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX99_LEGEND');
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
264: END Write_Tail_Output;
265:
266:

Line 263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

259: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX05_LEGEND');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
261:
262: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_EX99_LEGEND');
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
264: END Write_Tail_Output;
265:
266:
267: --

Line 284: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_IDT');

280: PROCEDURE Write_Header_Log( Idt_Name VARCHAR2,
281: Staging_Table VARCHAR2,
282: Filter_Text VARCHAR2) IS
283: BEGIN
284: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_IDT');
285: FND_MESSAGE.set_token('IDT_NAME', idt_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
287:
288: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_STG_TBL');

Line 285: FND_MESSAGE.set_token('IDT_NAME', idt_name);

281: Staging_Table VARCHAR2,
282: Filter_Text VARCHAR2) IS
283: BEGIN
284: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_IDT');
285: FND_MESSAGE.set_token('IDT_NAME', idt_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
287:
288: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_STG_TBL');
289: FND_MESSAGE.set_token('STG_TBL', staging_table);

Line 286: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);

282: Filter_Text VARCHAR2) IS
283: BEGIN
284: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_IDT');
285: FND_MESSAGE.set_token('IDT_NAME', idt_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
287:
288: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_STG_TBL');
289: FND_MESSAGE.set_token('STG_TBL', staging_table);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);

Line 288: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_STG_TBL');

284: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_IDT');
285: FND_MESSAGE.set_token('IDT_NAME', idt_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
287:
288: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_STG_TBL');
289: FND_MESSAGE.set_token('STG_TBL', staging_table);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
291:
292: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_FILTER');

Line 289: FND_MESSAGE.set_token('STG_TBL', staging_table);

285: FND_MESSAGE.set_token('IDT_NAME', idt_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
287:
288: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_STG_TBL');
289: FND_MESSAGE.set_token('STG_TBL', staging_table);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
291:
292: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_FILTER');
293: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);

Line 290: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);

286: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
287:
288: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_STG_TBL');
289: FND_MESSAGE.set_token('STG_TBL', staging_table);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
291:
292: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_FILTER');
293: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);

Line 292: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_FILTER');

288: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_STG_TBL');
289: FND_MESSAGE.set_token('STG_TBL', staging_table);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
291:
292: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_FILTER');
293: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
295: END Write_Header_Log;
296:

Line 293: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);

289: FND_MESSAGE.set_token('STG_TBL', staging_table);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
291:
292: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_FILTER');
293: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
295: END Write_Header_Log;
296:
297: --

Line 294: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);

290: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
291:
292: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_FILTER');
293: FND_MESSAGE.set_token('FILTER_TEXT', filter_text);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
295: END Write_Header_Log;
296:
297: --
298: -- Procedure

Line 351: -- is that the message has already been built by the fnd_message API.

347: -- Purpose
348: -- Adds a message to both the log file and log repository, if appropriate.
349: -- It uses the module passed in for the log repository. It will write to
350: -- the log file if the File_Write parameter is set to 'Y'. The assumption
351: -- is that the message has already been built by the fnd_message API.
352: -- Arguments
353: -- Module Name of the Module that failed.
354: -- File_Write 'Y' if writing to a log file.
355: -- Example

Line 368: encoded_message := FND_MESSAGE.get_encoded;

364: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED THEN
365: FND_LOG.message(FND_LOG.LEVEL_UNEXPECTED, module);
366: END IF;
367: IF File_Write = 'Y' THEN
368: encoded_message := FND_MESSAGE.get_encoded;
369: FND_MESSAGE.set_encoded(encoded_message);
370: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
371: FND_MESSAGE.set_encoded(encoded_message);
372: END IF;

Line 369: FND_MESSAGE.set_encoded(encoded_message);

365: FND_LOG.message(FND_LOG.LEVEL_UNEXPECTED, module);
366: END IF;
367: IF File_Write = 'Y' THEN
368: encoded_message := FND_MESSAGE.get_encoded;
369: FND_MESSAGE.set_encoded(encoded_message);
370: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
371: FND_MESSAGE.set_encoded(encoded_message);
372: END IF;
373: FND_MSG_PUB.add;

Line 370: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);

366: END IF;
367: IF File_Write = 'Y' THEN
368: encoded_message := FND_MESSAGE.get_encoded;
369: FND_MESSAGE.set_encoded(encoded_message);
370: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
371: FND_MESSAGE.set_encoded(encoded_message);
372: END IF;
373: FND_MSG_PUB.add;
374: END Write_To_Log;

Line 371: FND_MESSAGE.set_encoded(encoded_message);

367: IF File_Write = 'Y' THEN
368: encoded_message := FND_MESSAGE.get_encoded;
369: FND_MESSAGE.set_encoded(encoded_message);
370: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
371: FND_MESSAGE.set_encoded(encoded_message);
372: END IF;
373: FND_MSG_PUB.add;
374: END Write_To_Log;
375:

Line 422: FND_MESSAGE.set_name('GCS', message_name);

418: AND rstg.rule_stage_id = r.rule_stage_id
419: AND r.target_column_id = mc.column_id
420: AND r.rule_id = add_deriv_proc_failed_msg.rule_id;
421:
422: FND_MESSAGE.set_name('GCS', message_name);
423: FND_MESSAGE.set_token('IDT_NAME', idt_name);
424: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
425: FND_MESSAGE.set_token('COL_NAME', col_name);
426: IF deriv_num <> -1 THEN

Line 423: FND_MESSAGE.set_token('IDT_NAME', idt_name);

419: AND r.target_column_id = mc.column_id
420: AND r.rule_id = add_deriv_proc_failed_msg.rule_id;
421:
422: FND_MESSAGE.set_name('GCS', message_name);
423: FND_MESSAGE.set_token('IDT_NAME', idt_name);
424: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
425: FND_MESSAGE.set_token('COL_NAME', col_name);
426: IF deriv_num <> -1 THEN
427: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);

Line 424: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

420: AND r.rule_id = add_deriv_proc_failed_msg.rule_id;
421:
422: FND_MESSAGE.set_name('GCS', message_name);
423: FND_MESSAGE.set_token('IDT_NAME', idt_name);
424: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
425: FND_MESSAGE.set_token('COL_NAME', col_name);
426: IF deriv_num <> -1 THEN
427: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
428: END IF;

Line 425: FND_MESSAGE.set_token('COL_NAME', col_name);

421:
422: FND_MESSAGE.set_name('GCS', message_name);
423: FND_MESSAGE.set_token('IDT_NAME', idt_name);
424: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
425: FND_MESSAGE.set_token('COL_NAME', col_name);
426: IF deriv_num <> -1 THEN
427: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
428: END IF;
429: Write_To_Log(module, file_write);

Line 427: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);

423: FND_MESSAGE.set_token('IDT_NAME', idt_name);
424: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
425: FND_MESSAGE.set_token('COL_NAME', col_name);
426: IF deriv_num <> -1 THEN
427: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
428: END IF;
429: Write_To_Log(module, file_write);
430: END Add_Deriv_Proc_Failed_Msg;
431:

Line 479: FND_MESSAGE.set_name('GCS', message_name);

475: AND r.rule_id = d.rule_id
476: AND r.target_column_id = mc.column_id
477: AND d.derivation_id = add_deriv_failed_msg.derivation_id;
478:
479: FND_MESSAGE.set_name('GCS', message_name);
480: FND_MESSAGE.set_token('IDT_NAME', idt_name);
481: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
482: FND_MESSAGE.set_token('COL_NAME', col_name);
483: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);

Line 480: FND_MESSAGE.set_token('IDT_NAME', idt_name);

476: AND r.target_column_id = mc.column_id
477: AND d.derivation_id = add_deriv_failed_msg.derivation_id;
478:
479: FND_MESSAGE.set_name('GCS', message_name);
480: FND_MESSAGE.set_token('IDT_NAME', idt_name);
481: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
482: FND_MESSAGE.set_token('COL_NAME', col_name);
483: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
484: Write_To_Log(module, file_write);

Line 481: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

477: AND d.derivation_id = add_deriv_failed_msg.derivation_id;
478:
479: FND_MESSAGE.set_name('GCS', message_name);
480: FND_MESSAGE.set_token('IDT_NAME', idt_name);
481: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
482: FND_MESSAGE.set_token('COL_NAME', col_name);
483: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
484: Write_To_Log(module, file_write);
485: END Add_Deriv_Failed_Msg;

Line 482: FND_MESSAGE.set_token('COL_NAME', col_name);

478:
479: FND_MESSAGE.set_name('GCS', message_name);
480: FND_MESSAGE.set_token('IDT_NAME', idt_name);
481: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
482: FND_MESSAGE.set_token('COL_NAME', col_name);
483: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
484: Write_To_Log(module, file_write);
485: END Add_Deriv_Failed_Msg;
486:

Line 483: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);

479: FND_MESSAGE.set_name('GCS', message_name);
480: FND_MESSAGE.set_token('IDT_NAME', idt_name);
481: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
482: FND_MESSAGE.set_token('COL_NAME', col_name);
483: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
484: Write_To_Log(module, file_write);
485: END Add_Deriv_Failed_Msg;
486:
487: --

Line 537: FND_MESSAGE.set_name('GCS', message_name);

533: AND r.rule_id = d.rule_id
534: AND r.target_column_id = mc.column_id
535: AND d.derivation_id = add_plsql_deriv_failed_msg.derivation_id;
536:
537: FND_MESSAGE.set_name('GCS', message_name);
538: FND_MESSAGE.set_token('IDT_NAME', idt_name);
539: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
540: FND_MESSAGE.set_token('COL_NAME', col_name);
541: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);

Line 538: FND_MESSAGE.set_token('IDT_NAME', idt_name);

534: AND r.target_column_id = mc.column_id
535: AND d.derivation_id = add_plsql_deriv_failed_msg.derivation_id;
536:
537: FND_MESSAGE.set_name('GCS', message_name);
538: FND_MESSAGE.set_token('IDT_NAME', idt_name);
539: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
540: FND_MESSAGE.set_token('COL_NAME', col_name);
541: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
542: FND_MESSAGE.set_token('FUNC_NAME', func_name);

Line 539: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

535: AND d.derivation_id = add_plsql_deriv_failed_msg.derivation_id;
536:
537: FND_MESSAGE.set_name('GCS', message_name);
538: FND_MESSAGE.set_token('IDT_NAME', idt_name);
539: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
540: FND_MESSAGE.set_token('COL_NAME', col_name);
541: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
542: FND_MESSAGE.set_token('FUNC_NAME', func_name);
543: Write_To_Log(module, file_write);

Line 540: FND_MESSAGE.set_token('COL_NAME', col_name);

536:
537: FND_MESSAGE.set_name('GCS', message_name);
538: FND_MESSAGE.set_token('IDT_NAME', idt_name);
539: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
540: FND_MESSAGE.set_token('COL_NAME', col_name);
541: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
542: FND_MESSAGE.set_token('FUNC_NAME', func_name);
543: Write_To_Log(module, file_write);
544: END Add_PLSQL_Deriv_Failed_Msg;

Line 541: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);

537: FND_MESSAGE.set_name('GCS', message_name);
538: FND_MESSAGE.set_token('IDT_NAME', idt_name);
539: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
540: FND_MESSAGE.set_token('COL_NAME', col_name);
541: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
542: FND_MESSAGE.set_token('FUNC_NAME', func_name);
543: Write_To_Log(module, file_write);
544: END Add_PLSQL_Deriv_Failed_Msg;
545:

Line 542: FND_MESSAGE.set_token('FUNC_NAME', func_name);

538: FND_MESSAGE.set_token('IDT_NAME', idt_name);
539: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
540: FND_MESSAGE.set_token('COL_NAME', col_name);
541: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
542: FND_MESSAGE.set_token('FUNC_NAME', func_name);
543: Write_To_Log(module, file_write);
544: END Add_PLSQL_Deriv_Failed_Msg;
545:
546: --

Line 588: FND_MESSAGE.set_name('GCS', message_name);

584: AND rstg.rule_stage_id = r.rule_stage_id
585: AND r.target_column_id = mc.column_id
586: AND r.rule_id = add_rule_failed_msg.rule_id;
587:
588: FND_MESSAGE.set_name('GCS', message_name);
589: FND_MESSAGE.set_token('IDT_NAME', idt_name);
590: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
591: FND_MESSAGE.set_token('COL_NAME', col_name);
592: Write_To_Log(module, file_write);

Line 589: FND_MESSAGE.set_token('IDT_NAME', idt_name);

585: AND r.target_column_id = mc.column_id
586: AND r.rule_id = add_rule_failed_msg.rule_id;
587:
588: FND_MESSAGE.set_name('GCS', message_name);
589: FND_MESSAGE.set_token('IDT_NAME', idt_name);
590: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
591: FND_MESSAGE.set_token('COL_NAME', col_name);
592: Write_To_Log(module, file_write);
593: END Add_Rule_Failed_Msg;

Line 590: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

586: AND r.rule_id = add_rule_failed_msg.rule_id;
587:
588: FND_MESSAGE.set_name('GCS', message_name);
589: FND_MESSAGE.set_token('IDT_NAME', idt_name);
590: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
591: FND_MESSAGE.set_token('COL_NAME', col_name);
592: Write_To_Log(module, file_write);
593: END Add_Rule_Failed_Msg;
594:

Line 591: FND_MESSAGE.set_token('COL_NAME', col_name);

587:
588: FND_MESSAGE.set_name('GCS', message_name);
589: FND_MESSAGE.set_token('IDT_NAME', idt_name);
590: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
591: FND_MESSAGE.set_token('COL_NAME', col_name);
592: Write_To_Log(module, file_write);
593: END Add_Rule_Failed_Msg;
594:
595: --

Line 617: FND_MESSAGE.set_name('GCS', message_name);

613: Module VARCHAR2,
614: File_Write VARCHAR2)
615: IS
616: BEGIN
617: FND_MESSAGE.set_name('GCS', message_name);
618: FND_MESSAGE.set_token('RULE_NAME', rule_name);
619: Write_To_Log(module, file_write);
620: END Add_VRS_Rule_Failed_Msg;
621:

Line 618: FND_MESSAGE.set_token('RULE_NAME', rule_name);

614: File_Write VARCHAR2)
615: IS
616: BEGIN
617: FND_MESSAGE.set_name('GCS', message_name);
618: FND_MESSAGE.set_token('RULE_NAME', rule_name);
619: Write_To_Log(module, file_write);
620: END Add_VRS_Rule_Failed_Msg;
621:
622: --

Line 656: FND_MESSAGE.set_name('GCS', message_name);

652: gcs_lex_map_rule_stages rstg
653: WHERE rst.rule_set_id = rstg.rule_set_id
654: AND rstg.rule_stage_id = add_stage_failed_msg.rule_stage_id;
655:
656: FND_MESSAGE.set_name('GCS', message_name);
657: FND_MESSAGE.set_token('IDT_NAME', idt_name);
658: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
659: Write_To_Log(module, file_write);
660: END Add_Stage_Failed_Msg;

Line 657: FND_MESSAGE.set_token('IDT_NAME', idt_name);

653: WHERE rst.rule_set_id = rstg.rule_set_id
654: AND rstg.rule_stage_id = add_stage_failed_msg.rule_stage_id;
655:
656: FND_MESSAGE.set_name('GCS', message_name);
657: FND_MESSAGE.set_token('IDT_NAME', idt_name);
658: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
659: Write_To_Log(module, file_write);
660: END Add_Stage_Failed_Msg;
661:

Line 658: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

654: AND rstg.rule_stage_id = add_stage_failed_msg.rule_stage_id;
655:
656: FND_MESSAGE.set_name('GCS', message_name);
657: FND_MESSAGE.set_token('IDT_NAME', idt_name);
658: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
659: Write_To_Log(module, file_write);
660: END Add_Stage_Failed_Msg;
661:
662: --

Line 702: FND_MESSAGE.set_name('GCS', message_name);

698: gcs_lex_map_rule_stages rstg
699: WHERE rst.rule_set_id = rstg.rule_set_id
700: AND rstg.rule_stage_id = add_rows_changed_msg.rule_stage_id;
701:
702: FND_MESSAGE.set_name('GCS', message_name);
703: FND_MESSAGE.set_token('IDT_NAME', idt_name);
704: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
705: FND_MESSAGE.set_token('CURR_ROWS', current_rows);
706: FND_MESSAGE.set_token('PREV_ROWS', previous_rows);

Line 703: FND_MESSAGE.set_token('IDT_NAME', idt_name);

699: WHERE rst.rule_set_id = rstg.rule_set_id
700: AND rstg.rule_stage_id = add_rows_changed_msg.rule_stage_id;
701:
702: FND_MESSAGE.set_name('GCS', message_name);
703: FND_MESSAGE.set_token('IDT_NAME', idt_name);
704: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
705: FND_MESSAGE.set_token('CURR_ROWS', current_rows);
706: FND_MESSAGE.set_token('PREV_ROWS', previous_rows);
707: Write_To_Log(module, file_write);

Line 704: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

700: AND rstg.rule_stage_id = add_rows_changed_msg.rule_stage_id;
701:
702: FND_MESSAGE.set_name('GCS', message_name);
703: FND_MESSAGE.set_token('IDT_NAME', idt_name);
704: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
705: FND_MESSAGE.set_token('CURR_ROWS', current_rows);
706: FND_MESSAGE.set_token('PREV_ROWS', previous_rows);
707: Write_To_Log(module, file_write);
708: END Add_Rows_Changed_Msg;

Line 705: FND_MESSAGE.set_token('CURR_ROWS', current_rows);

701:
702: FND_MESSAGE.set_name('GCS', message_name);
703: FND_MESSAGE.set_token('IDT_NAME', idt_name);
704: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
705: FND_MESSAGE.set_token('CURR_ROWS', current_rows);
706: FND_MESSAGE.set_token('PREV_ROWS', previous_rows);
707: Write_To_Log(module, file_write);
708: END Add_Rows_Changed_Msg;
709:

Line 706: FND_MESSAGE.set_token('PREV_ROWS', previous_rows);

702: FND_MESSAGE.set_name('GCS', message_name);
703: FND_MESSAGE.set_token('IDT_NAME', idt_name);
704: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
705: FND_MESSAGE.set_token('CURR_ROWS', current_rows);
706: FND_MESSAGE.set_token('PREV_ROWS', previous_rows);
707: Write_To_Log(module, file_write);
708: END Add_Rows_Changed_Msg;
709:
710: --

Line 738: FND_MESSAGE.set_name('GCS', message_name);

734: INTO idt_name
735: FROM gcs_lex_map_rule_sets rst
736: WHERE rst.rule_set_id = add_idt_failed_msg.rule_set_id;
737:
738: FND_MESSAGE.set_name('GCS', message_name);
739: FND_MESSAGE.set_token('IDT_NAME', idt_name);
740: Write_To_Log(module, file_write);
741: END Add_IDT_Failed_Msg;
742:

Line 739: FND_MESSAGE.set_token('IDT_NAME', idt_name);

735: FROM gcs_lex_map_rule_sets rst
736: WHERE rst.rule_set_id = add_idt_failed_msg.rule_set_id;
737:
738: FND_MESSAGE.set_name('GCS', message_name);
739: FND_MESSAGE.set_token('IDT_NAME', idt_name);
740: Write_To_Log(module, file_write);
741: END Add_IDT_Failed_Msg;
742:
743: --

Line 774: FND_MESSAGE.set_name('GCS', message_name);

770: gcs_lex_map_structs ms
771: WHERE rst.structure_id = ms.structure_id
772: AND rst.rule_set_id = add_structure_failed_msg.rule_set_id;
773:
774: FND_MESSAGE.set_name('GCS', message_name);
775: FND_MESSAGE.set_token('STRUCT_NAME', struct_name);
776: Write_To_Log(module, file_write);
777: END Add_Structure_Failed_Msg;
778:

Line 775: FND_MESSAGE.set_token('STRUCT_NAME', struct_name);

771: WHERE rst.structure_id = ms.structure_id
772: AND rst.rule_set_id = add_structure_failed_msg.rule_set_id;
773:
774: FND_MESSAGE.set_name('GCS', message_name);
775: FND_MESSAGE.set_token('STRUCT_NAME', struct_name);
776: Write_To_Log(module, file_write);
777: END Add_Structure_Failed_Msg;
778:
779: --

Line 826: FND_MESSAGE.set_name('GCS', message_name);

822: AND r.target_column_id = mc.column_id
823: AND r.value_set_id = ffvs.flex_value_set_id
824: AND r.rule_id = add_value_set_failed_msg.rule_id;
825:
826: FND_MESSAGE.set_name('GCS', message_name);
827: FND_MESSAGE.set_token('IDT_NAME', idt_name);
828: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
829: FND_MESSAGE.set_token('COL_NAME', col_name);
830: FND_MESSAGE.set_token('VS_NAME', vs_name);

Line 827: FND_MESSAGE.set_token('IDT_NAME', idt_name);

823: AND r.value_set_id = ffvs.flex_value_set_id
824: AND r.rule_id = add_value_set_failed_msg.rule_id;
825:
826: FND_MESSAGE.set_name('GCS', message_name);
827: FND_MESSAGE.set_token('IDT_NAME', idt_name);
828: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
829: FND_MESSAGE.set_token('COL_NAME', col_name);
830: FND_MESSAGE.set_token('VS_NAME', vs_name);
831: Write_To_Log(module, file_write);

Line 828: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

824: AND r.rule_id = add_value_set_failed_msg.rule_id;
825:
826: FND_MESSAGE.set_name('GCS', message_name);
827: FND_MESSAGE.set_token('IDT_NAME', idt_name);
828: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
829: FND_MESSAGE.set_token('COL_NAME', col_name);
830: FND_MESSAGE.set_token('VS_NAME', vs_name);
831: Write_To_Log(module, file_write);
832: END Add_Value_Set_Failed_Msg;

Line 829: FND_MESSAGE.set_token('COL_NAME', col_name);

825:
826: FND_MESSAGE.set_name('GCS', message_name);
827: FND_MESSAGE.set_token('IDT_NAME', idt_name);
828: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
829: FND_MESSAGE.set_token('COL_NAME', col_name);
830: FND_MESSAGE.set_token('VS_NAME', vs_name);
831: Write_To_Log(module, file_write);
832: END Add_Value_Set_Failed_Msg;
833:

Line 830: FND_MESSAGE.set_token('VS_NAME', vs_name);

826: FND_MESSAGE.set_name('GCS', message_name);
827: FND_MESSAGE.set_token('IDT_NAME', idt_name);
828: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
829: FND_MESSAGE.set_token('COL_NAME', col_name);
830: FND_MESSAGE.set_token('VS_NAME', vs_name);
831: Write_To_Log(module, file_write);
832: END Add_Value_Set_Failed_Msg;
833:
834: --

Line 881: FND_MESSAGE.set_name('GCS', message_name);

877: AND r.target_column_id = mc.column_id
878: AND r.lookup_table_id = lutms.structure_id
879: AND r.rule_id = add_rule_lut_failed_msg.rule_id;
880:
881: FND_MESSAGE.set_name('GCS', message_name);
882: FND_MESSAGE.set_token('IDT_NAME', idt_name);
883: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
884: FND_MESSAGE.set_token('COL_NAME', col_name);
885: FND_MESSAGE.set_token('LUT_NAME', lut_name);

Line 882: FND_MESSAGE.set_token('IDT_NAME', idt_name);

878: AND r.lookup_table_id = lutms.structure_id
879: AND r.rule_id = add_rule_lut_failed_msg.rule_id;
880:
881: FND_MESSAGE.set_name('GCS', message_name);
882: FND_MESSAGE.set_token('IDT_NAME', idt_name);
883: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
884: FND_MESSAGE.set_token('COL_NAME', col_name);
885: FND_MESSAGE.set_token('LUT_NAME', lut_name);
886: Write_To_Log(module, file_write);

Line 883: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

879: AND r.rule_id = add_rule_lut_failed_msg.rule_id;
880:
881: FND_MESSAGE.set_name('GCS', message_name);
882: FND_MESSAGE.set_token('IDT_NAME', idt_name);
883: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
884: FND_MESSAGE.set_token('COL_NAME', col_name);
885: FND_MESSAGE.set_token('LUT_NAME', lut_name);
886: Write_To_Log(module, file_write);
887: END Add_Rule_LUT_Failed_Msg;

Line 884: FND_MESSAGE.set_token('COL_NAME', col_name);

880:
881: FND_MESSAGE.set_name('GCS', message_name);
882: FND_MESSAGE.set_token('IDT_NAME', idt_name);
883: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
884: FND_MESSAGE.set_token('COL_NAME', col_name);
885: FND_MESSAGE.set_token('LUT_NAME', lut_name);
886: Write_To_Log(module, file_write);
887: END Add_Rule_LUT_Failed_Msg;
888:

Line 885: FND_MESSAGE.set_token('LUT_NAME', lut_name);

881: FND_MESSAGE.set_name('GCS', message_name);
882: FND_MESSAGE.set_token('IDT_NAME', idt_name);
883: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
884: FND_MESSAGE.set_token('COL_NAME', col_name);
885: FND_MESSAGE.set_token('LUT_NAME', lut_name);
886: Write_To_Log(module, file_write);
887: END Add_Rule_LUT_Failed_Msg;
888:
889: --

Line 944: FND_MESSAGE.set_name('GCS', message_name);

940: AND d.lookup_result_column_id = lutmc.column_id
941: AND lutmc.structure_id = lutms.structure_id
942: AND d.derivation_id = add_deriv_lut_failed_msg.derivation_id;
943:
944: FND_MESSAGE.set_name('GCS', message_name);
945: FND_MESSAGE.set_token('IDT_NAME', idt_name);
946: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
947: FND_MESSAGE.set_token('COL_NAME', col_name);
948: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);

Line 945: FND_MESSAGE.set_token('IDT_NAME', idt_name);

941: AND lutmc.structure_id = lutms.structure_id
942: AND d.derivation_id = add_deriv_lut_failed_msg.derivation_id;
943:
944: FND_MESSAGE.set_name('GCS', message_name);
945: FND_MESSAGE.set_token('IDT_NAME', idt_name);
946: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
947: FND_MESSAGE.set_token('COL_NAME', col_name);
948: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
949: FND_MESSAGE.set_token('LUT_NAME', lut_name);

Line 946: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

942: AND d.derivation_id = add_deriv_lut_failed_msg.derivation_id;
943:
944: FND_MESSAGE.set_name('GCS', message_name);
945: FND_MESSAGE.set_token('IDT_NAME', idt_name);
946: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
947: FND_MESSAGE.set_token('COL_NAME', col_name);
948: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
949: FND_MESSAGE.set_token('LUT_NAME', lut_name);
950: Write_To_Log(module, file_write);

Line 947: FND_MESSAGE.set_token('COL_NAME', col_name);

943:
944: FND_MESSAGE.set_name('GCS', message_name);
945: FND_MESSAGE.set_token('IDT_NAME', idt_name);
946: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
947: FND_MESSAGE.set_token('COL_NAME', col_name);
948: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
949: FND_MESSAGE.set_token('LUT_NAME', lut_name);
950: Write_To_Log(module, file_write);
951: END Add_Deriv_LUT_Failed_Msg;

Line 948: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);

944: FND_MESSAGE.set_name('GCS', message_name);
945: FND_MESSAGE.set_token('IDT_NAME', idt_name);
946: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
947: FND_MESSAGE.set_token('COL_NAME', col_name);
948: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
949: FND_MESSAGE.set_token('LUT_NAME', lut_name);
950: Write_To_Log(module, file_write);
951: END Add_Deriv_LUT_Failed_Msg;
952:

Line 949: FND_MESSAGE.set_token('LUT_NAME', lut_name);

945: FND_MESSAGE.set_token('IDT_NAME', idt_name);
946: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
947: FND_MESSAGE.set_token('COL_NAME', col_name);
948: FND_MESSAGE.set_token('DERIV_NUM', deriv_num);
949: FND_MESSAGE.set_token('LUT_NAME', lut_name);
950: Write_To_Log(module, file_write);
951: END Add_Deriv_LUT_Failed_Msg;
952:
953: --

Line 975: FND_MESSAGE.set_name('GCS', message_name);

971: Module VARCHAR2,
972: File_Write VARCHAR2)
973: IS
974: BEGIN
975: FND_MESSAGE.set_name('GCS', message_name);
976: FND_MESSAGE.set_token('IDNUM', id_value);
977: Write_To_Log(module, file_write);
978: END Add_ID_Value_Failed_Msg;
979:

Line 976: FND_MESSAGE.set_token('IDNUM', id_value);

972: File_Write VARCHAR2)
973: IS
974: BEGIN
975: FND_MESSAGE.set_name('GCS', message_name);
976: FND_MESSAGE.set_token('IDNUM', id_value);
977: Write_To_Log(module, file_write);
978: END Add_ID_Value_Failed_Msg;
979:
980: --

Line 1002: FND_MESSAGE.set_name('GCS', message_name);

998: Module VARCHAR2,
999: File_Write VARCHAR2)
1000: IS
1001: BEGIN
1002: FND_MESSAGE.set_name('GCS', message_name);
1003: FND_MESSAGE.set_token('CODE_VAL', code_value);
1004: Write_To_Log(module, file_write);
1005: END Add_Code_Value_Failed_Msg;
1006:

Line 1003: FND_MESSAGE.set_token('CODE_VAL', code_value);

999: File_Write VARCHAR2)
1000: IS
1001: BEGIN
1002: FND_MESSAGE.set_name('GCS', message_name);
1003: FND_MESSAGE.set_token('CODE_VAL', code_value);
1004: Write_To_Log(module, file_write);
1005: END Add_Code_Value_Failed_Msg;
1006:
1007: --

Line 1029: FND_MESSAGE.set_name('GCS', message_name);

1025: Module VARCHAR2,
1026: File_Write VARCHAR2)
1027: IS
1028: BEGIN
1029: FND_MESSAGE.set_name('GCS', message_name);
1030: FND_MESSAGE.set_token('COL_NAME', column_name);
1031: Write_To_Log(module, file_write);
1032: END Add_Column_Failed_Msg;
1033:

Line 1030: FND_MESSAGE.set_token('COL_NAME', column_name);

1026: File_Write VARCHAR2)
1027: IS
1028: BEGIN
1029: FND_MESSAGE.set_name('GCS', message_name);
1030: FND_MESSAGE.set_token('COL_NAME', column_name);
1031: Write_To_Log(module, file_write);
1032: END Add_Column_Failed_Msg;
1033:
1034: --

Line 1054: FND_MESSAGE.set_name('GCS', message_name);

1050: Module VARCHAR2,
1051: File_Write VARCHAR2)
1052: IS
1053: BEGIN
1054: FND_MESSAGE.set_name('GCS', message_name);
1055: Write_To_Log(module, file_write);
1056: END Add_Simple_Failed_Msg;
1057:
1058: --

Line 1081: FND_MESSAGE.set_name('GCS', message_name);

1077: Module VARCHAR2,
1078: File_Write VARCHAR2)
1079: IS
1080: BEGIN
1081: FND_MESSAGE.set_name('GCS', message_name);
1082: FND_MESSAGE.set_token('STG_TBL', table_name);
1083: Write_To_Log(module, file_write);
1084: END Add_Staging_Table_Failed_Msg;
1085:

Line 1082: FND_MESSAGE.set_token('STG_TBL', table_name);

1078: File_Write VARCHAR2)
1079: IS
1080: BEGIN
1081: FND_MESSAGE.set_name('GCS', message_name);
1082: FND_MESSAGE.set_token('STG_TBL', table_name);
1083: Write_To_Log(module, file_write);
1084: END Add_Staging_Table_Failed_Msg;
1085:
1086: --

Line 1122: FND_MESSAGE.set_name('GCS', message_name);

1118: WHERE rst.structure_id = mc.structure_id
1119: AND mc.error_code_column_flag = 'Y'
1120: AND rst.rule_set_id = add_error_code_failed_msg.rule_set_id;
1121:
1122: FND_MESSAGE.set_name('GCS', message_name);
1123: FND_MESSAGE.set_token('STG_TBL', staging_table);
1124: FND_MESSAGE.set_token('COL_NAME', error_code_col_name);
1125: Write_To_Log(module, file_write);
1126: END Add_Error_Code_Failed_Msg;

Line 1123: FND_MESSAGE.set_token('STG_TBL', staging_table);

1119: AND mc.error_code_column_flag = 'Y'
1120: AND rst.rule_set_id = add_error_code_failed_msg.rule_set_id;
1121:
1122: FND_MESSAGE.set_name('GCS', message_name);
1123: FND_MESSAGE.set_token('STG_TBL', staging_table);
1124: FND_MESSAGE.set_token('COL_NAME', error_code_col_name);
1125: Write_To_Log(module, file_write);
1126: END Add_Error_Code_Failed_Msg;
1127:

Line 1124: FND_MESSAGE.set_token('COL_NAME', error_code_col_name);

1120: AND rst.rule_set_id = add_error_code_failed_msg.rule_set_id;
1121:
1122: FND_MESSAGE.set_name('GCS', message_name);
1123: FND_MESSAGE.set_token('STG_TBL', staging_table);
1124: FND_MESSAGE.set_token('COL_NAME', error_code_col_name);
1125: Write_To_Log(module, file_write);
1126: END Add_Error_Code_Failed_Msg;
1127:
1128: --

Line 2761: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_CURRENT_STAGE');

2757:
2758: log_file_module_write(module, g_module_enter);
2759:
2760: -- Put down in the log file which stage we are in.
2761: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_CURRENT_STAGE');
2762: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
2763: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
2764:
2765:

Line 2762: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

2758: log_file_module_write(module, g_module_enter);
2759:
2760: -- Put down in the log file which stage we are in.
2761: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_CURRENT_STAGE');
2762: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
2763: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
2764:
2765:
2766: -- This savepoint is used to roll back to just before the last stage, so

Line 2763: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);

2759:
2760: -- Put down in the log file which stage we are in.
2761: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_CURRENT_STAGE');
2762: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
2763: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
2764:
2765:
2766: -- This savepoint is used to roll back to just before the last stage, so
2767: -- that information on the source values that led to some error can be

Line 3362: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_NUM_ROWS_AFFECTED');

3358: v_debug_mode);
3359: END LOOP;
3360:
3361: -- Put down in the log file how many rows were affected.
3362: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_NUM_ROWS_AFFECTED');
3363: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3364: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);
3365: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
3366:

Line 3363: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);

3359: END LOOP;
3360:
3361: -- Put down in the log file how many rows were affected.
3362: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_NUM_ROWS_AFFECTED');
3363: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3364: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);
3365: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
3366:
3367: IF FND_API.to_boolean(v_commit) THEN

Line 3364: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);

3360:
3361: -- Put down in the log file how many rows were affected.
3362: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_NUM_ROWS_AFFECTED');
3363: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3364: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);
3365: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
3366:
3367: IF FND_API.to_boolean(v_commit) THEN
3368: COMMIT;

Line 3365: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);

3361: -- Put down in the log file how many rows were affected.
3362: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XL_NUM_ROWS_AFFECTED');
3363: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3364: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);
3365: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
3366:
3367: IF FND_API.to_boolean(v_commit) THEN
3368: COMMIT;
3369: END IF;

Line 3380: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_SUCCESS');

3376:
3377: log_file_module_write(module, g_module_success);
3378:
3379: write_header_output(idt_name, p_staging_table_name, filter_text);
3380: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_SUCCESS');
3381: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3383: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NUM_ROWS_AFFECTED');
3384: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);

Line 3381: FND_MESSAGE.set_token('IDT_NAME', idt_name);

3377: log_file_module_write(module, g_module_success);
3378:
3379: write_header_output(idt_name, p_staging_table_name, filter_text);
3380: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_SUCCESS');
3381: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3383: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NUM_ROWS_AFFECTED');
3384: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3385: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);

Line 3382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3378:
3379: write_header_output(idt_name, p_staging_table_name, filter_text);
3380: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_SUCCESS');
3381: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3383: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NUM_ROWS_AFFECTED');
3384: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3385: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);
3386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 3383: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NUM_ROWS_AFFECTED');

3379: write_header_output(idt_name, p_staging_table_name, filter_text);
3380: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_SUCCESS');
3381: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3383: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NUM_ROWS_AFFECTED');
3384: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3385: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);
3386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3387:

Line 3384: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);

3380: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_SUCCESS');
3381: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3383: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NUM_ROWS_AFFECTED');
3384: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3385: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);
3386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3387:
3388: write_tail_output;

Line 3385: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);

3381: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3383: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NUM_ROWS_AFFECTED');
3384: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3385: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);
3386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3387:
3388: write_tail_output;
3389: EXCEPTION

Line 3386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3383: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NUM_ROWS_AFFECTED');
3384: FND_MESSAGE.set_token('NUM_ROWS', num_rows_affected);
3385: FND_MESSAGE.set_token('STG_TBL', p_staging_table_name);
3386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3387:
3388: write_tail_output;
3389: EXCEPTION
3390: WHEN gcs_lex_error_column_not_set OR

Line 3417: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_FAILURE');

3413: p_count => x_msg_count,
3414: p_data => x_msg_data);
3415: IF error_table.COUNT > 0 THEN
3416: write_header_output(idt_name, p_staging_table_name, filter_text);
3417: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_FAILURE');
3418: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3419: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3420: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 3418: FND_MESSAGE.set_token('IDT_NAME', idt_name);

3414: p_data => x_msg_data);
3415: IF error_table.COUNT > 0 THEN
3416: write_header_output(idt_name, p_staging_table_name, filter_text);
3417: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_FAILURE');
3418: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3419: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3420: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3422:

Line 3419: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3415: IF error_table.COUNT > 0 THEN
3416: write_header_output(idt_name, p_staging_table_name, filter_text);
3417: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_FAILURE');
3418: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3419: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3420: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3422:
3423: -- List all validation errors. No need to sort the error table since

Line 3448: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_VSV_HEADER');

3444: AND r.value_set_id = ffv.flex_value_set_id
3445: AND r.target_column_id = mc.column_id
3446: AND r.rule_id = error_table(i).rule_id;
3447:
3448: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_VSV_HEADER');
3449: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3450: FND_MESSAGE.set_token('COL_NAME', col_name);
3451: FND_MESSAGE.set_token('VS_NAME', vs_name);
3452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 3449: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

3445: AND r.target_column_id = mc.column_id
3446: AND r.rule_id = error_table(i).rule_id;
3447:
3448: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_VSV_HEADER');
3449: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3450: FND_MESSAGE.set_token('COL_NAME', col_name);
3451: FND_MESSAGE.set_token('VS_NAME', vs_name);
3452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3453: ELSIF error_table(i).error_code = g_error_lutv_failed THEN

Line 3450: FND_MESSAGE.set_token('COL_NAME', col_name);

3446: AND r.rule_id = error_table(i).rule_id;
3447:
3448: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_VSV_HEADER');
3449: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3450: FND_MESSAGE.set_token('COL_NAME', col_name);
3451: FND_MESSAGE.set_token('VS_NAME', vs_name);
3452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3453: ELSIF error_table(i).error_code = g_error_lutv_failed THEN
3454: SELECT mc.column_name,

Line 3451: FND_MESSAGE.set_token('VS_NAME', vs_name);

3447:
3448: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_VSV_HEADER');
3449: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3450: FND_MESSAGE.set_token('COL_NAME', col_name);
3451: FND_MESSAGE.set_token('VS_NAME', vs_name);
3452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3453: ELSIF error_table(i).error_code = g_error_lutv_failed THEN
3454: SELECT mc.column_name,
3455: rstg.stage_number,

Line 3452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3448: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_VSV_HEADER');
3449: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3450: FND_MESSAGE.set_token('COL_NAME', col_name);
3451: FND_MESSAGE.set_token('VS_NAME', vs_name);
3452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3453: ELSIF error_table(i).error_code = g_error_lutv_failed THEN
3454: SELECT mc.column_name,
3455: rstg.stage_number,
3456: lutms.structure_name

Line 3469: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_LUTV_HEADER');

3465: AND r.lookup_table_id = lutms.structure_id
3466: AND r.target_column_id = mc.column_id
3467: AND r.rule_id = error_table(i).rule_id;
3468:
3469: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_LUTV_HEADER');
3470: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3471: FND_MESSAGE.set_token('COL_NAME', col_name);
3472: FND_MESSAGE.set_token('LUT_NAME', lut_name);
3473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 3470: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

3466: AND r.target_column_id = mc.column_id
3467: AND r.rule_id = error_table(i).rule_id;
3468:
3469: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_LUTV_HEADER');
3470: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3471: FND_MESSAGE.set_token('COL_NAME', col_name);
3472: FND_MESSAGE.set_token('LUT_NAME', lut_name);
3473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3474: END IF;

Line 3471: FND_MESSAGE.set_token('COL_NAME', col_name);

3467: AND r.rule_id = error_table(i).rule_id;
3468:
3469: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_LUTV_HEADER');
3470: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3471: FND_MESSAGE.set_token('COL_NAME', col_name);
3472: FND_MESSAGE.set_token('LUT_NAME', lut_name);
3473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3474: END IF;
3475:

Line 3472: FND_MESSAGE.set_token('LUT_NAME', lut_name);

3468:
3469: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_LUTV_HEADER');
3470: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3471: FND_MESSAGE.set_token('COL_NAME', col_name);
3472: FND_MESSAGE.set_token('LUT_NAME', lut_name);
3473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3474: END IF;
3475:
3476: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SHORT_SEPARATOR');

Line 3473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3469: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_LUTV_HEADER');
3470: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3471: FND_MESSAGE.set_token('COL_NAME', col_name);
3472: FND_MESSAGE.set_token('LUT_NAME', lut_name);
3473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3474: END IF;
3475:
3476: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SHORT_SEPARATOR');
3477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 3476: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SHORT_SEPARATOR');

3472: FND_MESSAGE.set_token('LUT_NAME', lut_name);
3473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3474: END IF;
3475:
3476: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SHORT_SEPARATOR');
3477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3478: END IF;
3479:
3480: EXECUTE IMMEDIATE 'SELECT ' || col_name || ' FROM ' ||

Line 3477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3474: END IF;
3475:
3476: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SHORT_SEPARATOR');
3477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3478: END IF;
3479:
3480: EXECUTE IMMEDIATE 'SELECT ' || col_name || ' FROM ' ||
3481: p_staging_table_name || ' WHERE rowid = :row_id'

Line 3504: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_FAILURE');

3500: p_count => x_msg_count,
3501: p_data => x_msg_data);
3502: IF error_table.COUNT > 0 THEN
3503: write_header_output(idt_name, p_staging_table_name, filter_text);
3504: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_FAILURE');
3505: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3507: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3508: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 3505: FND_MESSAGE.set_token('IDT_NAME', idt_name);

3501: p_data => x_msg_data);
3502: IF error_table.COUNT > 0 THEN
3503: write_header_output(idt_name, p_staging_table_name, filter_text);
3504: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_FAILURE');
3505: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3507: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3508: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3509:

Line 3506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3502: IF error_table.COUNT > 0 THEN
3503: write_header_output(idt_name, p_staging_table_name, filter_text);
3504: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_COMPLETED_FAILURE');
3505: FND_MESSAGE.set_token('IDT_NAME', idt_name);
3506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3507: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3508: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3509:
3510: -- Sort out the error table by rule_id, deriv_num, and error_code. This

Line 3541: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TMR_HEADER');

3537: AND r.target_column_id = mc.column_id
3538: AND r.rule_id = error_table(i).rule_id;
3539:
3540: IF error_table(i).error_code = g_error_lookup_tmr THEN
3541: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TMR_HEADER');
3542: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3543: FND_MESSAGE.set_token('COL_NAME', col_name);
3544: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 3542: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

3538: AND r.rule_id = error_table(i).rule_id;
3539:
3540: IF error_table(i).error_code = g_error_lookup_tmr THEN
3541: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TMR_HEADER');
3542: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3543: FND_MESSAGE.set_token('COL_NAME', col_name);
3544: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3546: ELSIF error_table(i).error_code = g_error_lookup_ndf THEN

Line 3543: FND_MESSAGE.set_token('COL_NAME', col_name);

3539:
3540: IF error_table(i).error_code = g_error_lookup_tmr THEN
3541: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TMR_HEADER');
3542: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3543: FND_MESSAGE.set_token('COL_NAME', col_name);
3544: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3546: ELSIF error_table(i).error_code = g_error_lookup_ndf THEN
3547: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NR_HEADER');

Line 3544: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);

3540: IF error_table(i).error_code = g_error_lookup_tmr THEN
3541: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TMR_HEADER');
3542: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3543: FND_MESSAGE.set_token('COL_NAME', col_name);
3544: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3546: ELSIF error_table(i).error_code = g_error_lookup_ndf THEN
3547: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NR_HEADER');
3548: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

Line 3545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3541: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TMR_HEADER');
3542: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3543: FND_MESSAGE.set_token('COL_NAME', col_name);
3544: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3546: ELSIF error_table(i).error_code = g_error_lookup_ndf THEN
3547: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NR_HEADER');
3548: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3549: FND_MESSAGE.set_token('COL_NAME', col_name);

Line 3547: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NR_HEADER');

3543: FND_MESSAGE.set_token('COL_NAME', col_name);
3544: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3546: ELSIF error_table(i).error_code = g_error_lookup_ndf THEN
3547: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NR_HEADER');
3548: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3549: FND_MESSAGE.set_token('COL_NAME', col_name);
3550: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 3548: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

3544: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3546: ELSIF error_table(i).error_code = g_error_lookup_ndf THEN
3547: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NR_HEADER');
3548: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3549: FND_MESSAGE.set_token('COL_NAME', col_name);
3550: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3552: ELSIF error_table(i).error_code = g_error_type_mismatch THEN

Line 3549: FND_MESSAGE.set_token('COL_NAME', col_name);

3545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3546: ELSIF error_table(i).error_code = g_error_lookup_ndf THEN
3547: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NR_HEADER');
3548: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3549: FND_MESSAGE.set_token('COL_NAME', col_name);
3550: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3552: ELSIF error_table(i).error_code = g_error_type_mismatch THEN
3553: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TYPE_HEADER');

Line 3550: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);

3546: ELSIF error_table(i).error_code = g_error_lookup_ndf THEN
3547: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NR_HEADER');
3548: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3549: FND_MESSAGE.set_token('COL_NAME', col_name);
3550: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3552: ELSIF error_table(i).error_code = g_error_type_mismatch THEN
3553: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TYPE_HEADER');
3554: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

Line 3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3547: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_NR_HEADER');
3548: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3549: FND_MESSAGE.set_token('COL_NAME', col_name);
3550: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3552: ELSIF error_table(i).error_code = g_error_type_mismatch THEN
3553: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TYPE_HEADER');
3554: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3555: FND_MESSAGE.set_token('COL_NAME', col_name);

Line 3553: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TYPE_HEADER');

3549: FND_MESSAGE.set_token('COL_NAME', col_name);
3550: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3552: ELSIF error_table(i).error_code = g_error_type_mismatch THEN
3553: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TYPE_HEADER');
3554: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3555: FND_MESSAGE.set_token('COL_NAME', col_name);
3556: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 3554: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

3550: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3552: ELSIF error_table(i).error_code = g_error_type_mismatch THEN
3553: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TYPE_HEADER');
3554: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3555: FND_MESSAGE.set_token('COL_NAME', col_name);
3556: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3558: ELSIF error_table(i).error_code = g_error_unexpected THEN

Line 3555: FND_MESSAGE.set_token('COL_NAME', col_name);

3551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3552: ELSIF error_table(i).error_code = g_error_type_mismatch THEN
3553: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TYPE_HEADER');
3554: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3555: FND_MESSAGE.set_token('COL_NAME', col_name);
3556: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3558: ELSIF error_table(i).error_code = g_error_unexpected THEN
3559: IF error_table(i).deriv_num = -1 THEN

Line 3556: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);

3552: ELSIF error_table(i).error_code = g_error_type_mismatch THEN
3553: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TYPE_HEADER');
3554: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3555: FND_MESSAGE.set_token('COL_NAME', col_name);
3556: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3558: ELSIF error_table(i).error_code = g_error_unexpected THEN
3559: IF error_table(i).deriv_num = -1 THEN
3560: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER_NODRV');

Line 3557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3553: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_TYPE_HEADER');
3554: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3555: FND_MESSAGE.set_token('COL_NAME', col_name);
3556: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3558: ELSIF error_table(i).error_code = g_error_unexpected THEN
3559: IF error_table(i).deriv_num = -1 THEN
3560: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER_NODRV');
3561: ELSE

Line 3560: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER_NODRV');

3556: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3558: ELSIF error_table(i).error_code = g_error_unexpected THEN
3559: IF error_table(i).deriv_num = -1 THEN
3560: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER_NODRV');
3561: ELSE
3562: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER');
3563: END IF;
3564: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

Line 3562: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER');

3558: ELSIF error_table(i).error_code = g_error_unexpected THEN
3559: IF error_table(i).deriv_num = -1 THEN
3560: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER_NODRV');
3561: ELSE
3562: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER');
3563: END IF;
3564: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3565: FND_MESSAGE.set_token('COL_NAME', col_name);
3566: IF error_table(i).deriv_num <> -1 THEN

Line 3564: FND_MESSAGE.set_token('STAGE_NUM', stage_num);

3560: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER_NODRV');
3561: ELSE
3562: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER');
3563: END IF;
3564: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3565: FND_MESSAGE.set_token('COL_NAME', col_name);
3566: IF error_table(i).deriv_num <> -1 THEN
3567: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3568: END IF;

Line 3565: FND_MESSAGE.set_token('COL_NAME', col_name);

3561: ELSE
3562: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_UNEXP_HEADER');
3563: END IF;
3564: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3565: FND_MESSAGE.set_token('COL_NAME', col_name);
3566: IF error_table(i).deriv_num <> -1 THEN
3567: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3568: END IF;
3569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 3567: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);

3563: END IF;
3564: FND_MESSAGE.set_token('STAGE_NUM', stage_num);
3565: FND_MESSAGE.set_token('COL_NAME', col_name);
3566: IF error_table(i).deriv_num <> -1 THEN
3567: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3568: END IF;
3569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3570: END IF;
3571:

Line 3569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3565: FND_MESSAGE.set_token('COL_NAME', col_name);
3566: IF error_table(i).deriv_num <> -1 THEN
3567: FND_MESSAGE.set_token('DERIV_NUM', error_table(i).deriv_num);
3568: END IF;
3569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3570: END IF;
3571:
3572: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SHORT_SEPARATOR');
3573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

Line 3572: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SHORT_SEPARATOR');

3568: END IF;
3569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3570: END IF;
3571:
3572: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SHORT_SEPARATOR');
3573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3574:
3575: -- Get the header parameter list
3576: param_list := create_param_list(error_table(i).rule_id, 'H', 'Y');

Line 3573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);

3569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3570: END IF;
3571:
3572: FND_MESSAGE.set_name('GCS', 'GCS_IDT_XR_SHORT_SEPARATOR');
3573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.get);
3574:
3575: -- Get the header parameter list
3576: param_list := create_param_list(error_table(i).rule_id, 'H', 'Y');
3577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, param_list);

Line 3923: FND_MESSAGE.set_name('GCS', 'GCS_IDT_VRS_NUM_ROWS_AFFECTED');

3919: INTO x_return_status;
3920:
3921:
3922: -- Put down in the log file how many rows were validated
3923: FND_MESSAGE.set_name('GCS', 'GCS_IDT_VRS_NUM_ROWS_AFFECTED');
3924: FND_MESSAGE.set_token('NUM_ROWS', num_rows_total);
3925: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT THEN
3926: FND_LOG.message(FND_LOG.LEVEL_EVENT, module);
3927: END IF;

Line 3924: FND_MESSAGE.set_token('NUM_ROWS', num_rows_total);

3920:
3921:
3922: -- Put down in the log file how many rows were validated
3923: FND_MESSAGE.set_name('GCS', 'GCS_IDT_VRS_NUM_ROWS_AFFECTED');
3924: FND_MESSAGE.set_token('NUM_ROWS', num_rows_total);
3925: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT THEN
3926: FND_LOG.message(FND_LOG.LEVEL_EVENT, module);
3927: END IF;
3928:

Line 3930: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);

3926: FND_LOG.message(FND_LOG.LEVEL_EVENT, module);
3927: END IF;
3928:
3929: IF v_debug_mode = 'Y' THEN
3930: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get);
3931: END IF;
3932:
3933: IF FND_API.to_boolean(v_commit) THEN
3934: COMMIT;