APPS.GCS_LEX_MAP_API_PKG dependencies on FND_FILE

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 198: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

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);
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.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 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 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 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 215: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

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);
219: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

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 219: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

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

Line 236: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

232: -- Notes
233: --
234: PROCEDURE Write_Tail_Output IS
235: BEGIN
236: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
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:

Line 237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

233: --
234: PROCEDURE Write_Tail_Output IS
235: BEGIN
236: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
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');

Line 238: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

234: PROCEDURE Write_Tail_Output IS
235: BEGIN
236: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
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);

Line 239: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

235: BEGIN
236: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
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:

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 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 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 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 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 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 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 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 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 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 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 318: FND_FILE.NEW_LINE(FND_FILE.LOG);

314: IS
315: enter_exit_text VARCHAR2(10);
316: BEGIN
317: IF action_type = g_module_enter THEN
318: FND_FILE.NEW_LINE(FND_FILE.LOG);
319: enter_exit_text := '>>';
320: ELSIF action_type = g_module_success THEN
321: enter_exit_text := '<<';
322: ELSE

Line 326: FND_FILE.PUT_LINE(

322: ELSE
323: enter_exit_text := ' 324: END IF;
325:
326: FND_FILE.PUT_LINE(
327: FND_FILE.LOG,
328: enter_exit_text || ' ' ||
329: SUBSTR(module, LENGTH(g_api)+2, LENGTH(module)-LENGTH(g_api)-1) ||
330: '() ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

Line 327: FND_FILE.LOG,

323: enter_exit_text := ' 324: END IF;
325:
326: FND_FILE.PUT_LINE(
327: FND_FILE.LOG,
328: enter_exit_text || ' ' ||
329: SUBSTR(module, LENGTH(g_api)+2, LENGTH(module)-LENGTH(g_api)-1) ||
330: '() ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
331:

Line 333: FND_FILE.NEW_LINE(FND_FILE.LOG);

329: SUBSTR(module, LENGTH(g_api)+2, LENGTH(module)-LENGTH(g_api)-1) ||
330: '() ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
331:
332: IF action_type <> g_module_enter THEN
333: FND_FILE.NEW_LINE(FND_FILE.LOG);
334: END IF;
335:
336: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT THEN
337: FND_LOG.string(FND_LOG.LEVEL_EVENT, module,

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 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 2803: FND_FILE.PUT_LINE(FND_FILE.LOG, stage_text);

2799: END IF;
2800:
2801: -- Print the stage dynamic SQL text if appropriate.
2802: IF debug_mode = 'Y' THEN
2803: FND_FILE.PUT_LINE(FND_FILE.LOG, stage_text);
2804: END IF;
2805:
2806: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT THEN
2807: FND_LOG.string(FND_LOG.LEVEL_EVENT, module, stage_text);

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 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 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 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 3420: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

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
3424: -- the entries would already be sorted.

Line 3421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

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
3424: -- the entries would already be sorted.
3425: FOR i IN error_table.FIRST..error_table.LAST LOOP

Line 3429: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

3425: FOR i IN error_table.FIRST..error_table.LAST LOOP
3426: IF i = error_table.FIRST OR
3427: error_table(i).rule_id <> error_table(i-1).rule_id THEN
3428:
3429: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3430: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3431:
3432: IF error_table(i).error_code = g_error_vsv_failed THEN
3433: SELECT mc.column_name,

Line 3430: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

3426: IF i = error_table.FIRST OR
3427: error_table(i).rule_id <> error_table(i-1).rule_id THEN
3428:
3429: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3430: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3431:
3432: IF error_table(i).error_code = g_error_vsv_failed THEN
3433: SELECT mc.column_name,
3434: 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 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 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 3485: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, error_value);

3481: p_staging_table_name || ' WHERE rowid = :row_id'
3482: INTO error_value
3483: USING error_table(i).row_id;
3484:
3485: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, error_value);
3486: END LOOP;
3487:
3488: write_tail_output;
3489:

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 3507: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

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
3511: -- allows us to group the errors together and show them in a more

Line 3508: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

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
3511: -- allows us to group the errors together and show them in a more
3512: -- organized manner.

Line 3526: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

3522: error_table(i).rule_id <> error_table(i-1).rule_id OR
3523: error_table(i).deriv_num <> error_table(i-1).deriv_num OR
3524: error_table(i).error_code <> error_table(i-1).error_code THEN
3525:
3526: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3527: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3528:
3529: SELECT mc.column_name,
3530: rstg.stage_number

Line 3527: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

3523: error_table(i).deriv_num <> error_table(i-1).deriv_num OR
3524: error_table(i).error_code <> error_table(i-1).error_code THEN
3525:
3526: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3527: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3528:
3529: SELECT mc.column_name,
3530: rstg.stage_number
3531: INTO col_name,

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 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 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 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 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 3577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, param_list);

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);
3578: FOR j IN 1..LENGTH(param_list)/20 LOOP
3579: FND_FILE.PUT(FND_FILE.OUTPUT, '------------------- ');
3580: END LOOP;
3581: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 3579: FND_FILE.PUT(FND_FILE.OUTPUT, '------------------- ');

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);
3578: FOR j IN 1..LENGTH(param_list)/20 LOOP
3579: FND_FILE.PUT(FND_FILE.OUTPUT, '------------------- ');
3580: END LOOP;
3581: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3582:
3583: -- Get the query parameter list

Line 3581: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

3577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, param_list);
3578: FOR j IN 1..LENGTH(param_list)/20 LOOP
3579: FND_FILE.PUT(FND_FILE.OUTPUT, '------------------- ');
3580: END LOOP;
3581: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
3582:
3583: -- Get the query parameter list
3584: param_list := create_param_list(error_table(i).rule_id, 'Q', 'Y');
3585: END IF;

Line 3592: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, error_value);

3588: p_staging_table_name || ' WHERE rowid = :row_id'
3589: INTO error_value
3590: USING error_table(i).row_id;
3591:
3592: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, error_value);
3593: END LOOP;
3594:
3595: write_tail_output;
3596:

Line 3874: FND_FILE.PUT_LINE(FND_FILE.LOG, val_text);

3870: 'WHERE ' || filter_text;
3871: END IF;
3872:
3873: IF v_debug_mode = 'Y' THEN
3874: FND_FILE.PUT_LINE(FND_FILE.LOG, val_text);
3875: END IF;
3876:
3877: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT THEN
3878: FND_LOG.string(FND_LOG.LEVEL_EVENT, module, val_text);

Line 3904: FND_FILE.PUT_LINE(FND_FILE.LOG, val_text);

3900: 'WHERE plsgt.associated_rowid = stg.rowid) ' ||
3901: 'WHERE ' || filter_text;
3902:
3903: IF v_debug_mode = 'Y' THEN
3904: FND_FILE.PUT_LINE(FND_FILE.LOG, val_text);
3905: END IF;
3906:
3907: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT THEN
3908: FND_LOG.string(FND_LOG.LEVEL_EVENT, module, val_text);

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;