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.ECE_FLATFILE_PVT dependencies on EC_DEBUG

Line 60: ec_debug.pl(0,'EC','ECE_ERROR_DOCUMENT',

56: BEGIN
57: FOR n_index IN 1..t_tran_attribute_tbl.COUNT LOOP
58: if t_tran_attribute_tbl(n_index).value is not null
59: then
60: ec_debug.pl(0,'EC','ECE_ERROR_DOCUMENT',
61: 'KEY_COLUMN_NAME',
62: t_tran_attribute_tbl(n_index).key_column_name,
63: 'DOCUMENT_NUMBER',
64: t_tran_attribute_tbl(n_index).value);

Line 127: if EC_DEBUG.G_debug_level >= 2 then

123: ORDER BY eic.record_number,
124: eic.position;
125:
126: BEGIN
127: if EC_DEBUG.G_debug_level >= 2 then
128: ec_debug.push('ECE_FLATFILE_PVT.SELECT_CLAUSE');
129: end if;
130:
131: IF cMapCode IS NULL THEN

Line 128: ec_debug.push('ECE_FLATFILE_PVT.SELECT_CLAUSE');

124: eic.position;
125:
126: BEGIN
127: if EC_DEBUG.G_debug_level >= 2 then
128: ec_debug.push('ECE_FLATFILE_PVT.SELECT_CLAUSE');
129: end if;
130:
131: IF cMapCode IS NULL THEN
132: SELECT map_id INTO iMap_ID

Line 140: if EC_DEBUG.G_debug_level = 3 then

136: SELECT map_id INTO iMap_ID
137: FROM ece_mappings
138: WHERE map_code = cMapCode;
139: END IF;
140: if EC_DEBUG.G_debug_level = 3 then
141: ec_debug.pl(3,'iMap_ID',iMap_ID);
142: end if;
143: xProgress := 'FILEB-10-1020';
144: FOR c1_rec IN c1(iMap_ID) LOOP

Line 141: ec_debug.pl(3,'iMap_ID',iMap_ID);

137: FROM ece_mappings
138: WHERE map_code = cMapCode;
139: END IF;
140: if EC_DEBUG.G_debug_level = 3 then
141: ec_debug.pl(3,'iMap_ID',iMap_ID);
142: end if;
143: xProgress := 'FILEB-10-1020';
144: FOR c1_rec IN c1(iMap_ID) LOOP
145: -- **************************************

Line 167: if EC_DEBUG.G_debug_level = 3 then

163: xProgress := 'FILEB-10-1100';
164: p_Interface_tbl(iColumn_count).layout_code := c1_rec.Record_layout_code;
165: xProgress := 'FILEB-10-1110';
166: p_Interface_tbl(iColumn_count).record_qualifier := c1_rec.record_layout_qualifier;
167: if EC_DEBUG.G_debug_level = 3 then
168: ec_debug.pl(3,
169: iColumn_count||' '||
170: p_Interface_tbl(iColumn_count).interface_column_id||' '||
171: p_Interface_tbl(iColumn_count).interface_table_name||' '||

Line 168: ec_debug.pl(3,

164: p_Interface_tbl(iColumn_count).layout_code := c1_rec.Record_layout_code;
165: xProgress := 'FILEB-10-1110';
166: p_Interface_tbl(iColumn_count).record_qualifier := c1_rec.record_layout_qualifier;
167: if EC_DEBUG.G_debug_level = 3 then
168: ec_debug.pl(3,
169: iColumn_count||' '||
170: p_Interface_tbl(iColumn_count).interface_column_id||' '||
171: p_Interface_tbl(iColumn_count).interface_table_name||' '||
172: p_Interface_tbl(iColumn_count).interface_column_name||' '||

Line 242: if EC_DEBUG.G_debug_level = 3 then

238: ' = ' || cExtension_table || '.'|| 'TRANSACTION_RECORD_ID(+)';
239:
240: xProgress := 'FILEB-10-1220';
241: cSelect_string := RTRIM(cSelect_stmt, ',');
242: if EC_DEBUG.G_debug_level = 3 then
243: ec_debug.pl(3,'Select statement : ',cSelect_string);
244: end if;
245: xProgress := 'FILEB-10-1230';
246: cFrom_string := cFrom_stmt;

Line 243: ec_debug.pl(3,'Select statement : ',cSelect_string);

239:
240: xProgress := 'FILEB-10-1220';
241: cSelect_string := RTRIM(cSelect_stmt, ',');
242: if EC_DEBUG.G_debug_level = 3 then
243: ec_debug.pl(3,'Select statement : ',cSelect_string);
244: end if;
245: xProgress := 'FILEB-10-1230';
246: cFrom_string := cFrom_stmt;
247: if EC_DEBUG.G_debug_level = 3 then

Line 247: if EC_DEBUG.G_debug_level = 3 then

243: ec_debug.pl(3,'Select statement : ',cSelect_string);
244: end if;
245: xProgress := 'FILEB-10-1230';
246: cFrom_string := cFrom_stmt;
247: if EC_DEBUG.G_debug_level = 3 then
248: ec_debug.pl(3,'From statement : ',cFrom_string);
249: end if;
250: xProgress := 'FILEB-10-1240';
251: cWhere_string := cWhere_stmt;

Line 248: ec_debug.pl(3,'From statement : ',cFrom_string);

244: end if;
245: xProgress := 'FILEB-10-1230';
246: cFrom_string := cFrom_stmt;
247: if EC_DEBUG.G_debug_level = 3 then
248: ec_debug.pl(3,'From statement : ',cFrom_string);
249: end if;
250: xProgress := 'FILEB-10-1240';
251: cWhere_string := cWhere_stmt;
252: if EC_DEBUG.G_debug_level = 3 then

Line 252: if EC_DEBUG.G_debug_level = 3 then

248: ec_debug.pl(3,'From statement : ',cFrom_string);
249: end if;
250: xProgress := 'FILEB-10-1240';
251: cWhere_string := cWhere_stmt;
252: if EC_DEBUG.G_debug_level = 3 then
253: ec_debug.pl(3,'Where statement : ',cWhere_string);
254: end if;
255: xProgress := 'FILEB-10-1250';
256: cExt_Table := cExtension_Table;

Line 253: ec_debug.pl(3,'Where statement : ',cWhere_string);

249: end if;
250: xProgress := 'FILEB-10-1240';
251: cWhere_string := cWhere_stmt;
252: if EC_DEBUG.G_debug_level = 3 then
253: ec_debug.pl(3,'Where statement : ',cWhere_string);
254: end if;
255: xProgress := 'FILEB-10-1250';
256: cExt_Table := cExtension_Table;
257: if EC_DEBUG.G_debug_level = 3 then

Line 257: if EC_DEBUG.G_debug_level = 3 then

253: ec_debug.pl(3,'Where statement : ',cWhere_string);
254: end if;
255: xProgress := 'FILEB-10-1250';
256: cExt_Table := cExtension_Table;
257: if EC_DEBUG.G_debug_level = 3 then
258: ec_debug.pl(3,'cExt_Table : ',cExt_Table);
259: end if;
260:
261: if EC_DEBUG.G_debug_level >= 2 then

Line 258: ec_debug.pl(3,'cExt_Table : ',cExt_Table);

254: end if;
255: xProgress := 'FILEB-10-1250';
256: cExt_Table := cExtension_Table;
257: if EC_DEBUG.G_debug_level = 3 then
258: ec_debug.pl(3,'cExt_Table : ',cExt_Table);
259: end if;
260:
261: if EC_DEBUG.G_debug_level >= 2 then
262: ec_debug.pop('ECE_FLATFILE_PVT.SELECT_CLAUSE');

Line 261: if EC_DEBUG.G_debug_level >= 2 then

257: if EC_DEBUG.G_debug_level = 3 then
258: ec_debug.pl(3,'cExt_Table : ',cExt_Table);
259: end if;
260:
261: if EC_DEBUG.G_debug_level >= 2 then
262: ec_debug.pop('ECE_FLATFILE_PVT.SELECT_CLAUSE');
263: end if;
264:
265: EXCEPTION

Line 262: ec_debug.pop('ECE_FLATFILE_PVT.SELECT_CLAUSE');

258: ec_debug.pl(3,'cExt_Table : ',cExt_Table);
259: end if;
260:
261: if EC_DEBUG.G_debug_level >= 2 then
262: ec_debug.pop('ECE_FLATFILE_PVT.SELECT_CLAUSE');
263: end if;
264:
265: EXCEPTION
266: WHEN OTHERS THEN

Line 267: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.SELECT_CLAUSE');

263: end if;
264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.SELECT_CLAUSE');
268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
269: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
270: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
271: app_exception.raise_exception;

Line 268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.SELECT_CLAUSE');
268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
269: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
270: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
271: app_exception.raise_exception;
272:

Line 269: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

265: EXCEPTION
266: WHEN OTHERS THEN
267: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.SELECT_CLAUSE');
268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
269: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
270: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
271: app_exception.raise_exception;
272:
273: END select_clause;

Line 270: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

266: WHEN OTHERS THEN
267: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.SELECT_CLAUSE');
268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
269: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
270: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
271: app_exception.raise_exception;
272:
273: END select_clause;
274:

Line 304: if EC_DEBUG.G_debug_level >= 2 then

300: l_common_key VARCHAR2(255) := p_common_key;
301: l_count NUMBER;
302:
303: BEGIN
304: if EC_DEBUG.G_debug_level >= 2 then
305: ec_debug.push('ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
306: end if;
307: xProgress := 'FILEB-WR-1020';
308: FOR i IN 1..iData_count LOOP

Line 305: ec_debug.push('ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');

301: l_count NUMBER;
302:
303: BEGIN
304: if EC_DEBUG.G_debug_level >= 2 then
305: ec_debug.push('ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
306: end if;
307: xProgress := 'FILEB-WR-1020';
308: FOR i IN 1..iData_count LOOP
309: xProgress := 'FILEB-WR-1030';

Line 318: if EC_DEBUG.G_debug_level >= 3 then

314: p_Interface_tbl(i).position IS NOT NULL AND
315: p_Interface_tbl(i).data_length IS NOT NULL THEN
316: xProgress := 'FILEB-WR-1050';
317: iRow_num := i;
318: if EC_DEBUG.G_debug_level >= 3 then
319: ec_debug.pl(3,'iRow_num : ',iRow_num);
320: end if;
321: xProgress := 'FILEB-WR-1060';
322:

Line 319: ec_debug.pl(3,'iRow_num : ',iRow_num);

315: p_Interface_tbl(i).data_length IS NOT NULL THEN
316: xProgress := 'FILEB-WR-1050';
317: iRow_num := i;
318: if EC_DEBUG.G_debug_level >= 3 then
319: ec_debug.pl(3,'iRow_num : ',iRow_num);
320: end if;
321: xProgress := 'FILEB-WR-1060';
322:
323: cInsert_stmt := cInsert_stmt || substr(rpad(nvl(p_Interface_tbl(i).value,' '),

Line 368: if EC_DEBUG.G_debug_level >= 2 then

364: END IF;
365: END IF;
366: END LOOP;
367:
368: if EC_DEBUG.G_debug_level >= 2 then
369: ec_debug.pop('ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
370: end if;
371:
372: EXCEPTION

Line 369: ec_debug.pop('ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');

365: END IF;
366: END LOOP;
367:
368: if EC_DEBUG.G_debug_level >= 2 then
369: ec_debug.pop('ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
370: end if;
371:
372: EXCEPTION
373: WHEN OTHERS THEN

Line 374: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');

370: end if;
371:
372: EXCEPTION
373: WHEN OTHERS THEN
374: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
375: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
376: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
377: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
378:

Line 375: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

371:
372: EXCEPTION
373: WHEN OTHERS THEN
374: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
375: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
376: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
377: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
378:
379: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');

Line 376: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

372: EXCEPTION
373: WHEN OTHERS THEN
374: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
375: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
376: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
377: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
378:
379: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');
380: ec_debug.pl(0,'EC','ECE_PLSQL_VALUE','COLUMN_NAME', 'p_interface_tbl(l_count).value');

Line 377: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

373: WHEN OTHERS THEN
374: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
375: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
376: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
377: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
378:
379: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');
380: ec_debug.pl(0,'EC','ECE_PLSQL_VALUE','COLUMN_NAME', 'p_interface_tbl(l_count).value');
381: ec_debug.pl(0,'EC','ECE_PLSQL_DATA_TYPE','COLUMN_NAME', 'p_interface_tbl(l_count).data_type');

Line 379: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');

375: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
376: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
377: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
378:
379: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');
380: ec_debug.pl(0,'EC','ECE_PLSQL_VALUE','COLUMN_NAME', 'p_interface_tbl(l_count).value');
381: ec_debug.pl(0,'EC','ECE_PLSQL_DATA_TYPE','COLUMN_NAME', 'p_interface_tbl(l_count).data_type');
382: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'p_interface_tbl(l_count).base_column');
383: app_exception.raise_exception;

Line 380: ec_debug.pl(0,'EC','ECE_PLSQL_VALUE','COLUMN_NAME', 'p_interface_tbl(l_count).value');

376: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
377: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
378:
379: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');
380: ec_debug.pl(0,'EC','ECE_PLSQL_VALUE','COLUMN_NAME', 'p_interface_tbl(l_count).value');
381: ec_debug.pl(0,'EC','ECE_PLSQL_DATA_TYPE','COLUMN_NAME', 'p_interface_tbl(l_count).data_type');
382: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'p_interface_tbl(l_count).base_column');
383: app_exception.raise_exception;
384:

Line 381: ec_debug.pl(0,'EC','ECE_PLSQL_DATA_TYPE','COLUMN_NAME', 'p_interface_tbl(l_count).data_type');

377: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
378:
379: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');
380: ec_debug.pl(0,'EC','ECE_PLSQL_VALUE','COLUMN_NAME', 'p_interface_tbl(l_count).value');
381: ec_debug.pl(0,'EC','ECE_PLSQL_DATA_TYPE','COLUMN_NAME', 'p_interface_tbl(l_count).data_type');
382: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'p_interface_tbl(l_count).base_column');
383: app_exception.raise_exception;
384:
385: END write_to_ece_output;

Line 382: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'p_interface_tbl(l_count).base_column');

378:
379: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');
380: ec_debug.pl(0,'EC','ECE_PLSQL_VALUE','COLUMN_NAME', 'p_interface_tbl(l_count).value');
381: ec_debug.pl(0,'EC','ECE_PLSQL_DATA_TYPE','COLUMN_NAME', 'p_interface_tbl(l_count).data_type');
382: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'p_interface_tbl(l_count).base_column');
383: app_exception.raise_exception;
384:
385: END write_to_ece_output;
386:

Line 400: if EC_DEBUG.G_debug_level >= 2 then

396: POS_NOT_FOUND EXCEPTION;
397: cOutput_path VARCHAR2(120);
398: BEGIN
399:
400: if EC_DEBUG.G_debug_level >= 2 then
401: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.Find_pos');
402: EC_DEBUG.PL(3, 'Search text : ', cSearch_text);
403: EC_DEBUG.PL(3, 'nColumn_count : ', nColumn_count);
404: end if;

Line 401: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.Find_pos');

397: cOutput_path VARCHAR2(120);
398: BEGIN
399:
400: if EC_DEBUG.G_debug_level >= 2 then
401: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.Find_pos');
402: EC_DEBUG.PL(3, 'Search text : ', cSearch_text);
403: EC_DEBUG.PL(3, 'nColumn_count : ', nColumn_count);
404: end if;
405: For k in 1..nColumn_count loop

Line 402: EC_DEBUG.PL(3, 'Search text : ', cSearch_text);

398: BEGIN
399:
400: if EC_DEBUG.G_debug_level >= 2 then
401: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.Find_pos');
402: EC_DEBUG.PL(3, 'Search text : ', cSearch_text);
403: EC_DEBUG.PL(3, 'nColumn_count : ', nColumn_count);
404: end if;
405: For k in 1..nColumn_count loop
406: if UPPER(p_Interface_tbl(k).interface_column_name) = cIn_string then

Line 403: EC_DEBUG.PL(3, 'nColumn_count : ', nColumn_count);

399:
400: if EC_DEBUG.G_debug_level >= 2 then
401: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.Find_pos');
402: EC_DEBUG.PL(3, 'Search text : ', cSearch_text);
403: EC_DEBUG.PL(3, 'nColumn_count : ', nColumn_count);
404: end if;
405: For k in 1..nColumn_count loop
406: if UPPER(p_Interface_tbl(k).interface_column_name) = cIn_string then
407: nPos := k;

Line 408: if EC_DEBUG.G_debug_level >= 3 then

404: end if;
405: For k in 1..nColumn_count loop
406: if UPPER(p_Interface_tbl(k).interface_column_name) = cIn_string then
407: nPos := k;
408: if EC_DEBUG.G_debug_level >= 3 then
409: EC_DEBUG.PL(3, 'Position : ', nColumn_count);
410: end if;
411: b_found := TRUE;
412: exit;

Line 409: EC_DEBUG.PL(3, 'Position : ', nColumn_count);

405: For k in 1..nColumn_count loop
406: if UPPER(p_Interface_tbl(k).interface_column_name) = cIn_string then
407: nPos := k;
408: if EC_DEBUG.G_debug_level >= 3 then
409: EC_DEBUG.PL(3, 'Position : ', nColumn_count);
410: end if;
411: b_found := TRUE;
412: exit;
413: end if;

Line 419: if EC_DEBUG.G_debug_level >= 2 then

415:
416: if NOT b_found then
417: Raise POS_NOT_FOUND;
418: end if;
419: if EC_DEBUG.G_debug_level >= 2 then
420: EC_DEBUG.POP('ECE_FLATFILE_PVT.Find_pos');
421: end if;
422: EXCEPTION
423: WHEN POS_NOT_FOUND THEN

Line 420: EC_DEBUG.POP('ECE_FLATFILE_PVT.Find_pos');

416: if NOT b_found then
417: Raise POS_NOT_FOUND;
418: end if;
419: if EC_DEBUG.G_debug_level >= 2 then
420: EC_DEBUG.POP('ECE_FLATFILE_PVT.Find_pos');
421: end if;
422: EXCEPTION
423: WHEN POS_NOT_FOUND THEN
424: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'cIn_string');

Line 424: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'cIn_string');

420: EC_DEBUG.POP('ECE_FLATFILE_PVT.Find_pos');
421: end if;
422: EXCEPTION
423: WHEN POS_NOT_FOUND THEN
424: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'cIn_string');
425: app_exception.raise_exception;
426:
427: WHEN OTHERS THEN
428: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.FIND_POS');

Line 428: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.FIND_POS');

424: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'cIn_string');
425: app_exception.raise_exception;
426:
427: WHEN OTHERS THEN
428: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.FIND_POS');
429: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
430: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
431: app_exception.raise_exception;
432: END Find_pos;

Line 429: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

425: app_exception.raise_exception;
426:
427: WHEN OTHERS THEN
428: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.FIND_POS');
429: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
430: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
431: app_exception.raise_exception;
432: END Find_pos;
433: /*

Line 430: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

426:
427: WHEN OTHERS THEN
428: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.FIND_POS');
429: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
430: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
431: app_exception.raise_exception;
432: END Find_pos;
433: /*
434: PROCEDURE match_data_loc_id(

Line 442: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_data_loc_id');

438:
439: IS
440:
441: BEGIN
442: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_data_loc_id');
443: if EC_DEBUG.G_debug_level >= 3 then
444: EC_DEBUG.PL(3, 'Data loc id : ', p_data_loc_id);
445: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);
446: end if;

Line 443: if EC_DEBUG.G_debug_level >= 3 then

439: IS
440:
441: BEGIN
442: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_data_loc_id');
443: if EC_DEBUG.G_debug_level >= 3 then
444: EC_DEBUG.PL(3, 'Data loc id : ', p_data_loc_id);
445: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);
446: end if;
447: For k in 1..p_Interface_tbl.count

Line 444: EC_DEBUG.PL(3, 'Data loc id : ', p_data_loc_id);

440:
441: BEGIN
442: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_data_loc_id');
443: if EC_DEBUG.G_debug_level >= 3 then
444: EC_DEBUG.PL(3, 'Data loc id : ', p_data_loc_id);
445: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);
446: end if;
447: For k in 1..p_Interface_tbl.count
448: loop

Line 445: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);

441: BEGIN
442: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_data_loc_id');
443: if EC_DEBUG.G_debug_level >= 3 then
444: EC_DEBUG.PL(3, 'Data loc id : ', p_data_loc_id);
445: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);
446: end if;
447: For k in 1..p_Interface_tbl.count
448: loop
449: if p_Interface_tbl(k).data_loc_id = p_data_loc_id

Line 452: if EC_DEBUG.G_debug_level >= 3 then

448: loop
449: if p_Interface_tbl(k).data_loc_id = p_data_loc_id
450: then
451: p_Pos := k;
452: if EC_DEBUG.G_debug_level >= 3 then
453: EC_DEBUG.PL(3, 'Position : ', p_Pos);
454: end if;
455: exit;
456: end if;

Line 453: EC_DEBUG.PL(3, 'Position : ', p_Pos);

449: if p_Interface_tbl(k).data_loc_id = p_data_loc_id
450: then
451: p_Pos := k;
452: if EC_DEBUG.G_debug_level >= 3 then
453: EC_DEBUG.PL(3, 'Position : ', p_Pos);
454: end if;
455: exit;
456: end if;
457: end loop;

Line 458: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_data_loc_id');

454: end if;
455: exit;
456: end if;
457: end loop;
458: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_data_loc_id');
459: END match_data_loc_id;
460:
461: -- *******************************************
462: */

Line 471: if EC_DEBUG.G_debug_level >= 2 then

467:
468: IS
469:
470: BEGIN
471: if EC_DEBUG.G_debug_level >= 2 then
472: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_interface_column_id');
473: EC_DEBUG.PL(3, 'Interface_column_id : ', p_Interface_column_id);
474: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);
475: end if;

Line 472: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_interface_column_id');

468: IS
469:
470: BEGIN
471: if EC_DEBUG.G_debug_level >= 2 then
472: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_interface_column_id');
473: EC_DEBUG.PL(3, 'Interface_column_id : ', p_Interface_column_id);
474: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);
475: end if;
476: For k in 1..p_Interface_tbl.count

Line 473: EC_DEBUG.PL(3, 'Interface_column_id : ', p_Interface_column_id);

469:
470: BEGIN
471: if EC_DEBUG.G_debug_level >= 2 then
472: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_interface_column_id');
473: EC_DEBUG.PL(3, 'Interface_column_id : ', p_Interface_column_id);
474: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);
475: end if;
476: For k in 1..p_Interface_tbl.count
477: loop

Line 474: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);

470: BEGIN
471: if EC_DEBUG.G_debug_level >= 2 then
472: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_interface_column_id');
473: EC_DEBUG.PL(3, 'Interface_column_id : ', p_Interface_column_id);
474: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);
475: end if;
476: For k in 1..p_Interface_tbl.count
477: loop
478: if p_Interface_tbl(k).interface_column_id = p_Interface_column_id

Line 481: if EC_DEBUG.G_debug_level >= 3 then

477: loop
478: if p_Interface_tbl(k).interface_column_id = p_Interface_column_id
479: then
480: p_Pos := k;
481: if EC_DEBUG.G_debug_level >= 3 then
482: EC_DEBUG.PL(3, 'Position : ', p_Pos);
483: end if;
484: exit;
485: end if;

Line 482: EC_DEBUG.PL(3, 'Position : ', p_Pos);

478: if p_Interface_tbl(k).interface_column_id = p_Interface_column_id
479: then
480: p_Pos := k;
481: if EC_DEBUG.G_debug_level >= 3 then
482: EC_DEBUG.PL(3, 'Position : ', p_Pos);
483: end if;
484: exit;
485: end if;
486: end loop;

Line 487: if EC_DEBUG.G_debug_level >= 2 then

483: end if;
484: exit;
485: end if;
486: end loop;
487: if EC_DEBUG.G_debug_level >= 2 then
488: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_interface_column_id');
489: end if;
490: END match_interface_column_id;
491:

Line 488: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_interface_column_id');

484: exit;
485: end if;
486: end loop;
487: if EC_DEBUG.G_debug_level >= 2 then
488: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_interface_column_id');
489: end if;
490: END match_interface_column_id;
491:
492: -- *******************************************

Line 508: if EC_DEBUG.G_debug_level >= 2 then

504: cOutput_path VARCHAR2(120);
505:
506: BEGIN
507: xProgress := 'FILEB-MA-1000';
508: if EC_DEBUG.G_debug_level >= 2 then
509: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_conversion_group_id');
510:
511: EC_DEBUG.PL(3, 'Conversion id : ', p_conversion_id);
512: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);

Line 509: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_conversion_group_id');

505:
506: BEGIN
507: xProgress := 'FILEB-MA-1000';
508: if EC_DEBUG.G_debug_level >= 2 then
509: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_conversion_group_id');
510:
511: EC_DEBUG.PL(3, 'Conversion id : ', p_conversion_id);
512: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
513: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);

Line 511: EC_DEBUG.PL(3, 'Conversion id : ', p_conversion_id);

507: xProgress := 'FILEB-MA-1000';
508: if EC_DEBUG.G_debug_level >= 2 then
509: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_conversion_group_id');
510:
511: EC_DEBUG.PL(3, 'Conversion id : ', p_conversion_id);
512: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
513: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
514: end if;
515: For k in 1..p_gateway_tbl.count

Line 512: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);

508: if EC_DEBUG.G_debug_level >= 2 then
509: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_conversion_group_id');
510:
511: EC_DEBUG.PL(3, 'Conversion id : ', p_conversion_id);
512: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
513: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
514: end if;
515: For k in 1..p_gateway_tbl.count
516: loop

Line 513: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);

509: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_conversion_group_id');
510:
511: EC_DEBUG.PL(3, 'Conversion id : ', p_conversion_id);
512: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
513: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
514: end if;
515: For k in 1..p_gateway_tbl.count
516: loop
517: xProgress := 'FILEB-MA-1010';

Line 524: if EC_DEBUG.G_debug_level >= 2 then

520: and p_gateway_tbl(k).conversion_seq = p_sequence_num
521: then
522: xProgress := 'FILEB-MA-1020';
523: p_pos := k;
524: if EC_DEBUG.G_debug_level >= 2 then
525: EC_DEBUG.PL(3, 'Position : ', p_pos);
526: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');
527: end if;
528: b_found := TRUE;

Line 525: EC_DEBUG.PL(3, 'Position : ', p_pos);

521: then
522: xProgress := 'FILEB-MA-1020';
523: p_pos := k;
524: if EC_DEBUG.G_debug_level >= 2 then
525: EC_DEBUG.PL(3, 'Position : ', p_pos);
526: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');
527: end if;
528: b_found := TRUE;
529: return b_found;

Line 526: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');

522: xProgress := 'FILEB-MA-1020';
523: p_pos := k;
524: if EC_DEBUG.G_debug_level >= 2 then
525: EC_DEBUG.PL(3, 'Position : ', p_pos);
526: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');
527: end if;
528: b_found := TRUE;
529: return b_found;
530: end if;

Line 536: if EC_DEBUG.G_debug_level >= 2 then

532: xProgress := 'FILEB-MA-1030';
533: IF NOT b_found THEN
534: RAISE POS_NOT_FOUND;
535: END IF;
536: if EC_DEBUG.G_debug_level >= 2 then
537: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');
538: end if;
539: EXCEPTION
540: WHEN POS_NOT_FOUND THEN

Line 537: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');

533: IF NOT b_found THEN
534: RAISE POS_NOT_FOUND;
535: END IF;
536: if EC_DEBUG.G_debug_level >= 2 then
537: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');
538: end if;
539: EXCEPTION
540: WHEN POS_NOT_FOUND THEN
541: EC_DEBUG.PL(0,'EC','ECE_CONVERSION_ID_NOT_FOUND','CONVERSION_ID', 'p_conversion_id', 'SEQUENCE', 'p_sequence_num');

Line 541: EC_DEBUG.PL(0,'EC','ECE_CONVERSION_ID_NOT_FOUND','CONVERSION_ID', 'p_conversion_id', 'SEQUENCE', 'p_sequence_num');

537: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');
538: end if;
539: EXCEPTION
540: WHEN POS_NOT_FOUND THEN
541: EC_DEBUG.PL(0,'EC','ECE_CONVERSION_ID_NOT_FOUND','CONVERSION_ID', 'p_conversion_id', 'SEQUENCE', 'p_sequence_num');
542: app_exception.raise_exception;
543:
544: WHEN OTHERS THEN
545: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');

Line 545: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');

541: EC_DEBUG.PL(0,'EC','ECE_CONVERSION_ID_NOT_FOUND','CONVERSION_ID', 'p_conversion_id', 'SEQUENCE', 'p_sequence_num');
542: app_exception.raise_exception;
543:
544: WHEN OTHERS THEN
545: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
546: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
547: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
548: app_exception.raise_exception;
549:

Line 546: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

542: app_exception.raise_exception;
543:
544: WHEN OTHERS THEN
545: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
546: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
547: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
548: app_exception.raise_exception;
549:
550: END match_conversion_group_id;

Line 547: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

543:
544: WHEN OTHERS THEN
545: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
546: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
547: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
548: app_exception.raise_exception;
549:
550: END match_conversion_group_id;
551:

Line 563: if EC_DEBUG.G_debug_level >= 2 then

559: IS
560: b_found BOOLEAN := FALSE;
561:
562: BEGIN
563: if EC_DEBUG.G_debug_level >= 2 then
564: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
565: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
566: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
567: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);

Line 564: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');

560: b_found BOOLEAN := FALSE;
561:
562: BEGIN
563: if EC_DEBUG.G_debug_level >= 2 then
564: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
565: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
566: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
567: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
568: end if;

Line 565: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);

561:
562: BEGIN
563: if EC_DEBUG.G_debug_level >= 2 then
564: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
565: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
566: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
567: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
568: end if;
569: For k in 1..p_gateway_tbl.count

Line 566: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);

562: BEGIN
563: if EC_DEBUG.G_debug_level >= 2 then
564: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
565: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
566: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
567: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
568: end if;
569: For k in 1..p_gateway_tbl.count
570: loop

Line 567: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);

563: if EC_DEBUG.G_debug_level >= 2 then
564: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
565: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
566: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
567: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
568: end if;
569: For k in 1..p_gateway_tbl.count
570: loop
571: if p_gateway_tbl(k).conversion_group_id = p_conversion_group

Line 575: if EC_DEBUG.G_debug_level >= 3 then

571: if p_gateway_tbl(k).conversion_group_id = p_conversion_group
572: and p_gateway_tbl(k).conversion_seq = p_sequence_num
573: then
574: p_Pos := k;
575: if EC_DEBUG.G_debug_level >= 3 then
576: EC_DEBUG.PL(3, 'Position : ', p_Pos);
577: end if;
578: b_found := TRUE;
579: exit;

Line 576: EC_DEBUG.PL(3, 'Position : ', p_Pos);

572: and p_gateway_tbl(k).conversion_seq = p_sequence_num
573: then
574: p_Pos := k;
575: if EC_DEBUG.G_debug_level >= 3 then
576: EC_DEBUG.PL(3, 'Position : ', p_Pos);
577: end if;
578: b_found := TRUE;
579: exit;
580: end if;

Line 582: if EC_DEBUG.G_debug_level >= 2 then

578: b_found := TRUE;
579: exit;
580: end if;
581: end loop;
582: if EC_DEBUG.G_debug_level >= 2 then
583: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');
584: end if;
585: return b_found;
586:

Line 583: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');

579: exit;
580: end if;
581: end loop;
582: if EC_DEBUG.G_debug_level >= 2 then
583: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');
584: end if;
585: return b_found;
586:
587: END match_xref_conv_seq;

Line 602: if EC_DEBUG.G_debug_level >= 2 then

598: hash_value pls_integer;
599: hash_string varchar2(3200);
600: tbl_pos pls_integer;
601: BEGIN
602: if EC_DEBUG.G_debug_level >= 2 then
603: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
604: EC_DEBUG.PL(3, 'p_level group : ', p_level);
605: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
606: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);

Line 603: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');

599: hash_string varchar2(3200);
600: tbl_pos pls_integer;
601: BEGIN
602: if EC_DEBUG.G_debug_level >= 2 then
603: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
604: EC_DEBUG.PL(3, 'p_level group : ', p_level);
605: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
606: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
607: ec_debug.pl(3, 'file_start_pos',ec_utils.g_ext_levels(p_level).file_start_pos);

Line 604: EC_DEBUG.PL(3, 'p_level group : ', p_level);

600: tbl_pos pls_integer;
601: BEGIN
602: if EC_DEBUG.G_debug_level >= 2 then
603: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
604: EC_DEBUG.PL(3, 'p_level group : ', p_level);
605: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
606: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
607: ec_debug.pl(3, 'file_start_pos',ec_utils.g_ext_levels(p_level).file_start_pos);
608: ec_debug.pl(3, 'file_end_pos',ec_utils.g_ext_levels(p_level).file_end_pos);

Line 605: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);

601: BEGIN
602: if EC_DEBUG.G_debug_level >= 2 then
603: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
604: EC_DEBUG.PL(3, 'p_level group : ', p_level);
605: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
606: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
607: ec_debug.pl(3, 'file_start_pos',ec_utils.g_ext_levels(p_level).file_start_pos);
608: ec_debug.pl(3, 'file_end_pos',ec_utils.g_ext_levels(p_level).file_end_pos);
609: end if;

Line 606: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);

602: if EC_DEBUG.G_debug_level >= 2 then
603: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
604: EC_DEBUG.PL(3, 'p_level group : ', p_level);
605: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
606: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
607: ec_debug.pl(3, 'file_start_pos',ec_utils.g_ext_levels(p_level).file_start_pos);
608: ec_debug.pl(3, 'file_end_pos',ec_utils.g_ext_levels(p_level).file_end_pos);
609: end if;
610:

Line 607: ec_debug.pl(3, 'file_start_pos',ec_utils.g_ext_levels(p_level).file_start_pos);

603: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
604: EC_DEBUG.PL(3, 'p_level group : ', p_level);
605: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
606: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
607: ec_debug.pl(3, 'file_start_pos',ec_utils.g_ext_levels(p_level).file_start_pos);
608: ec_debug.pl(3, 'file_end_pos',ec_utils.g_ext_levels(p_level).file_end_pos);
609: end if;
610:
611: /*

Line 608: ec_debug.pl(3, 'file_end_pos',ec_utils.g_ext_levels(p_level).file_end_pos);

604: EC_DEBUG.PL(3, 'p_level group : ', p_level);
605: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
606: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
607: ec_debug.pl(3, 'file_start_pos',ec_utils.g_ext_levels(p_level).file_start_pos);
608: ec_debug.pl(3, 'file_end_pos',ec_utils.g_ext_levels(p_level).file_end_pos);
609: end if;
610:
611: /*
612: Bug 2112028 -Reverting this fix back to 115.16 as the change done in 1853627 causes

Line 678: if EC_DEBUG.G_debug_level >= 2 then

674: end loop;
675: end if;
676: */
677:
678: if EC_DEBUG.G_debug_level >= 2 then
679: EC_DEBUG.PL(3, 'p_Pos', p_Pos);
680: EC_DEBUG.PL(3, 'b_found', b_found);
681: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');
682: end if;

Line 679: EC_DEBUG.PL(3, 'p_Pos', p_Pos);

675: end if;
676: */
677:
678: if EC_DEBUG.G_debug_level >= 2 then
679: EC_DEBUG.PL(3, 'p_Pos', p_Pos);
680: EC_DEBUG.PL(3, 'b_found', b_found);
681: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');
682: end if;
683: return b_found;

Line 680: EC_DEBUG.PL(3, 'b_found', b_found);

676: */
677:
678: if EC_DEBUG.G_debug_level >= 2 then
679: EC_DEBUG.PL(3, 'p_Pos', p_Pos);
680: EC_DEBUG.PL(3, 'b_found', b_found);
681: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');
682: end if;
683: return b_found;
684:

Line 681: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');

677:
678: if EC_DEBUG.G_debug_level >= 2 then
679: EC_DEBUG.PL(3, 'p_Pos', p_Pos);
680: EC_DEBUG.PL(3, 'b_found', b_found);
681: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');
682: end if;
683: return b_found;
684:
685: END match_xref_conv_seq;

Line 709: if EC_DEBUG.G_debug_level >= 2 then

705: b_match_found BOOLEAN := FALSE;
706: l_total_unit NUMBER := 0;
707: cOutput_path varchar2(120);
708: BEGIN
709: if EC_DEBUG.G_debug_level >= 2 then
710: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_record_num');
711: EC_DEBUG.PL(3, 'Record num : ', p_Record_num);
712: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
713: end if;

Line 710: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_record_num');

706: l_total_unit NUMBER := 0;
707: cOutput_path varchar2(120);
708: BEGIN
709: if EC_DEBUG.G_debug_level >= 2 then
710: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_record_num');
711: EC_DEBUG.PL(3, 'Record num : ', p_Record_num);
712: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
713: end if;
714: For k in 1..p_gateway_tbl.count

Line 711: EC_DEBUG.PL(3, 'Record num : ', p_Record_num);

707: cOutput_path varchar2(120);
708: BEGIN
709: if EC_DEBUG.G_debug_level >= 2 then
710: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_record_num');
711: EC_DEBUG.PL(3, 'Record num : ', p_Record_num);
712: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
713: end if;
714: For k in 1..p_gateway_tbl.count
715: loop

Line 712: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);

708: BEGIN
709: if EC_DEBUG.G_debug_level >= 2 then
710: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_record_num');
711: EC_DEBUG.PL(3, 'Record num : ', p_Record_num);
712: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
713: end if;
714: For k in 1..p_gateway_tbl.count
715: loop
716: if p_gateway_tbl(k).Record_num = p_Record_num

Line 720: if EC_DEBUG.G_debug_level >= 3 then

716: if p_gateway_tbl(k).Record_num = p_Record_num
717: and (not b_match_found)
718: then
719: p_Pos := k;
720: if EC_DEBUG.G_debug_level >= 3 then
721: EC_DEBUG.PL(3, 'Position : ', p_Pos);
722: end if;
723: l_total_unit := l_total_unit + 1;
724: b_match_found := TRUE;

Line 721: EC_DEBUG.PL(3, 'Position : ', p_Pos);

717: and (not b_match_found)
718: then
719: p_Pos := k;
720: if EC_DEBUG.G_debug_level >= 3 then
721: EC_DEBUG.PL(3, 'Position : ', p_Pos);
722: end if;
723: l_total_unit := l_total_unit + 1;
724: b_match_found := TRUE;
725:

Line 742: if EC_DEBUG.G_debug_level >= 2 then

738: end if;
739: end loop;
740:
741: p_total_unit := l_total_unit;
742: if EC_DEBUG.G_debug_level >= 2 then
743: EC_DEBUG.PL(3, 'Total records found : ', p_total_unit);
744: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_record_num');
745: end if;
746: return b_match_found;

Line 743: EC_DEBUG.PL(3, 'Total records found : ', p_total_unit);

739: end loop;
740:
741: p_total_unit := l_total_unit;
742: if EC_DEBUG.G_debug_level >= 2 then
743: EC_DEBUG.PL(3, 'Total records found : ', p_total_unit);
744: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_record_num');
745: end if;
746: return b_match_found;
747: EXCEPTION

Line 744: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_record_num');

740:
741: p_total_unit := l_total_unit;
742: if EC_DEBUG.G_debug_level >= 2 then
743: EC_DEBUG.PL(3, 'Total records found : ', p_total_unit);
744: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_record_num');
745: end if;
746: return b_match_found;
747: EXCEPTION
748: when others

Line 750: EC_DEBUG.PL(0,'EC','ECE_RECORD_NUM_NOT_FOUND','RECORD_NUM','to_char(p_Record_num)');

746: return b_match_found;
747: EXCEPTION
748: when others
749: then
750: EC_DEBUG.PL(0,'EC','ECE_RECORD_NUM_NOT_FOUND','RECORD_NUM','to_char(p_Record_num)');
751: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
752: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
753: app_exception.raise_exception;
754: END match_record_num;

Line 751: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

747: EXCEPTION
748: when others
749: then
750: EC_DEBUG.PL(0,'EC','ECE_RECORD_NUM_NOT_FOUND','RECORD_NUM','to_char(p_Record_num)');
751: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
752: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
753: app_exception.raise_exception;
754: END match_record_num;
755:

Line 752: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

748: when others
749: then
750: EC_DEBUG.PL(0,'EC','ECE_RECORD_NUM_NOT_FOUND','RECORD_NUM','to_char(p_Record_num)');
751: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
752: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
753: app_exception.raise_exception;
754: END match_record_num;
755:
756: PROCEDURE init_table(

Line 801: if EC_DEBUG.G_debug_level >= 2 then

797: iMap_ID INTEGER;
798: cOutput_path VARCHAR2(120);
799:
800: BEGIN
801: if EC_DEBUG.G_debug_level >= 2 then
802: ec_debug.push('ECE_FLATFILE_PVT.INIT_TABLE');
803: end if;
804: IF cMapCode IS NULL THEN
805: SELECT map_id INTO iMap_ID

Line 802: ec_debug.push('ECE_FLATFILE_PVT.INIT_TABLE');

798: cOutput_path VARCHAR2(120);
799:
800: BEGIN
801: if EC_DEBUG.G_debug_level >= 2 then
802: ec_debug.push('ECE_FLATFILE_PVT.INIT_TABLE');
803: end if;
804: IF cMapCode IS NULL THEN
805: SELECT map_id INTO iMap_ID
806: FROM ece_mappings

Line 813: if EC_DEBUG.G_debug_level >= 3 then

809: SELECT map_id INTO iMap_ID
810: FROM ece_mappings
811: WHERE map_code = cMapCode;
812: END IF;
813: if EC_DEBUG.G_debug_level >= 3 then
814: ec_debug.pl(3,'iMap_ID',iMap_ID);
815: end if;
816:
817: FOR c_rec IN c_source_data(iMap_ID) LOOP

Line 814: ec_debug.pl(3,'iMap_ID',iMap_ID);

810: FROM ece_mappings
811: WHERE map_code = cMapCode;
812: END IF;
813: if EC_DEBUG.G_debug_level >= 3 then
814: ec_debug.pl(3,'iMap_ID',iMap_ID);
815: end if;
816:
817: FOR c_rec IN c_source_data(iMap_ID) LOOP
818: i_count := i_count + 1;

Line 838: if EC_DEBUG.G_debug_level = 3 then

834: cInterface_tbl(i_count).position := c_rec.position;
835: cInterface_tbl(i_count).layout_code := c_rec.record_layout_code;
836: cInterface_tbl(i_count).record_qualifier := c_rec.record_layout_qualifier;
837: cInterface_tbl(i_count).ext_column_name := c_rec.ext_column_name; -- bug 2823215
838: if EC_DEBUG.G_debug_level = 3 then
839: ec_debug.pl(3,
840: i_count||' '||
841: cInterface_tbl(i_count).interface_table_name||' '||
842: cInterface_tbl(i_count).interface_column_name||' '||

Line 839: ec_debug.pl(3,

835: cInterface_tbl(i_count).layout_code := c_rec.record_layout_code;
836: cInterface_tbl(i_count).record_qualifier := c_rec.record_layout_qualifier;
837: cInterface_tbl(i_count).ext_column_name := c_rec.ext_column_name; -- bug 2823215
838: if EC_DEBUG.G_debug_level = 3 then
839: ec_debug.pl(3,
840: i_count||' '||
841: cInterface_tbl(i_count).interface_table_name||' '||
842: cInterface_tbl(i_count).interface_column_name||' '||
843: cInterface_tbl(i_count).base_table_name||' '||

Line 882: if EC_DEBUG.G_debug_level = 3 then

878:
879:
880:
881:
882: if EC_DEBUG.G_debug_level = 3 then
883: ec_debug.pl(3,
884: iKey_count||' '||
885: ckey_tbl(iKey_count).interface_table_name||' '||
886: ckey_tbl(iKey_count).interface_column_name||' '||

Line 883: ec_debug.pl(3,

879:
880:
881:
882: if EC_DEBUG.G_debug_level = 3 then
883: ec_debug.pl(3,
884: iKey_count||' '||
885: ckey_tbl(iKey_count).interface_table_name||' '||
886: ckey_tbl(iKey_count).interface_column_name||' '||
887: ckey_tbl(iKey_count).base_table_name||' '||

Line 898: if EC_DEBUG.G_debug_level >= 2 then

894: END IF;
895:
896: END LOOP;
897:
898: if EC_DEBUG.G_debug_level >= 2 then
899: ec_debug.pop('ECE_FLATFILE_PVT.INIT_TABLE');
900: end if;
901:
902: EXCEPTION

Line 899: ec_debug.pop('ECE_FLATFILE_PVT.INIT_TABLE');

895:
896: END LOOP;
897:
898: if EC_DEBUG.G_debug_level >= 2 then
899: ec_debug.pop('ECE_FLATFILE_PVT.INIT_TABLE');
900: end if;
901:
902: EXCEPTION
903: WHEN OTHERS THEN

Line 904: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.init_table');

900: end if;
901:
902: EXCEPTION
903: WHEN OTHERS THEN
904: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.init_table');
905: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
906: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
907: ec_debug.pl(0,'EC','ECE_PLSQL_TABLE_NAME','TABLE_NAME', 'cInterface_tbl(i_count).base_table_name');
908: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'cInterface_tbl(i_count).base_column_name');

Line 905: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

901:
902: EXCEPTION
903: WHEN OTHERS THEN
904: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.init_table');
905: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
906: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
907: ec_debug.pl(0,'EC','ECE_PLSQL_TABLE_NAME','TABLE_NAME', 'cInterface_tbl(i_count).base_table_name');
908: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'cInterface_tbl(i_count).base_column_name');
909: app_exception.raise_exception;

Line 906: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

902: EXCEPTION
903: WHEN OTHERS THEN
904: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.init_table');
905: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
906: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
907: ec_debug.pl(0,'EC','ECE_PLSQL_TABLE_NAME','TABLE_NAME', 'cInterface_tbl(i_count).base_table_name');
908: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'cInterface_tbl(i_count).base_column_name');
909: app_exception.raise_exception;
910:

Line 907: ec_debug.pl(0,'EC','ECE_PLSQL_TABLE_NAME','TABLE_NAME', 'cInterface_tbl(i_count).base_table_name');

903: WHEN OTHERS THEN
904: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.init_table');
905: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
906: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
907: ec_debug.pl(0,'EC','ECE_PLSQL_TABLE_NAME','TABLE_NAME', 'cInterface_tbl(i_count).base_table_name');
908: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'cInterface_tbl(i_count).base_column_name');
909: app_exception.raise_exception;
910:
911: END init_table;

Line 908: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'cInterface_tbl(i_count).base_column_name');

904: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.init_table');
905: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
906: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
907: ec_debug.pl(0,'EC','ECE_PLSQL_TABLE_NAME','TABLE_NAME', 'cInterface_tbl(i_count).base_table_name');
908: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'cInterface_tbl(i_count).base_column_name');
909: app_exception.raise_exception;
910:
911: END init_table;
912:

Line 916: if EC_DEBUG.G_debug_level >= 2 then

912:
913: PROCEDURE ADD_TO_WHERE_CLAUSE (cString IN OUT NOCOPY VARCHAR2,
914: cAdd IN VARCHAR2) IS
915: BEGIN
916: if EC_DEBUG.G_debug_level >= 2 then
917: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');
918: EC_DEBUG.PL(3, 'Add string : ', cAdd);
919: end if;
920:

Line 917: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');

913: PROCEDURE ADD_TO_WHERE_CLAUSE (cString IN OUT NOCOPY VARCHAR2,
914: cAdd IN VARCHAR2) IS
915: BEGIN
916: if EC_DEBUG.G_debug_level >= 2 then
917: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');
918: EC_DEBUG.PL(3, 'Add string : ', cAdd);
919: end if;
920:
921: cString := cString || ' AND '|| cAdd;

Line 918: EC_DEBUG.PL(3, 'Add string : ', cAdd);

914: cAdd IN VARCHAR2) IS
915: BEGIN
916: if EC_DEBUG.G_debug_level >= 2 then
917: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');
918: EC_DEBUG.PL(3, 'Add string : ', cAdd);
919: end if;
920:
921: cString := cString || ' AND '|| cAdd;
922:

Line 923: if EC_DEBUG.G_debug_level >= 2 then

919: end if;
920:
921: cString := cString || ' AND '|| cAdd;
922:
923: if EC_DEBUG.G_debug_level >= 2 then
924: EC_DEBUG.PL(3, 'String : ', cString);
925: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');
926: end if;
927: END ADD_TO_WHERE_CLAUSE;

Line 924: EC_DEBUG.PL(3, 'String : ', cString);

920:
921: cString := cString || ' AND '|| cAdd;
922:
923: if EC_DEBUG.G_debug_level >= 2 then
924: EC_DEBUG.PL(3, 'String : ', cString);
925: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');
926: end if;
927: END ADD_TO_WHERE_CLAUSE;
928:

Line 925: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');

921: cString := cString || ' AND '|| cAdd;
922:
923: if EC_DEBUG.G_debug_level >= 2 then
924: EC_DEBUG.PL(3, 'String : ', cString);
925: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');
926: end if;
927: END ADD_TO_WHERE_CLAUSE;
928:
929: PROCEDURE ADD_TO_FROM_CLAUSE (cString IN OUT NOCOPY VARCHAR2,

Line 932: if EC_DEBUG.G_debug_level >= 2 then

928:
929: PROCEDURE ADD_TO_FROM_CLAUSE (cString IN OUT NOCOPY VARCHAR2,
930: cAdd IN VARCHAR2) IS
931: BEGIN
932: if EC_DEBUG.G_debug_level >= 2 then
933: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');
934: EC_DEBUG.PL(3, 'Add string : ', cAdd);
935: end if;
936: cString := cString || cAdd || ', ';

Line 933: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');

929: PROCEDURE ADD_TO_FROM_CLAUSE (cString IN OUT NOCOPY VARCHAR2,
930: cAdd IN VARCHAR2) IS
931: BEGIN
932: if EC_DEBUG.G_debug_level >= 2 then
933: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');
934: EC_DEBUG.PL(3, 'Add string : ', cAdd);
935: end if;
936: cString := cString || cAdd || ', ';
937: if EC_DEBUG.G_debug_level >= 3 then

Line 934: EC_DEBUG.PL(3, 'Add string : ', cAdd);

930: cAdd IN VARCHAR2) IS
931: BEGIN
932: if EC_DEBUG.G_debug_level >= 2 then
933: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');
934: EC_DEBUG.PL(3, 'Add string : ', cAdd);
935: end if;
936: cString := cString || cAdd || ', ';
937: if EC_DEBUG.G_debug_level >= 3 then
938: EC_DEBUG.PL(3, 'String : ', cString);

Line 937: if EC_DEBUG.G_debug_level >= 3 then

933: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');
934: EC_DEBUG.PL(3, 'Add string : ', cAdd);
935: end if;
936: cString := cString || cAdd || ', ';
937: if EC_DEBUG.G_debug_level >= 3 then
938: EC_DEBUG.PL(3, 'String : ', cString);
939: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');
940: end if;
941: END ADD_TO_FROM_CLAUSE;

Line 938: EC_DEBUG.PL(3, 'String : ', cString);

934: EC_DEBUG.PL(3, 'Add string : ', cAdd);
935: end if;
936: cString := cString || cAdd || ', ';
937: if EC_DEBUG.G_debug_level >= 3 then
938: EC_DEBUG.PL(3, 'String : ', cString);
939: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');
940: end if;
941: END ADD_TO_FROM_CLAUSE;
942:

Line 939: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');

935: end if;
936: cString := cString || cAdd || ', ';
937: if EC_DEBUG.G_debug_level >= 3 then
938: EC_DEBUG.PL(3, 'String : ', cString);
939: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');
940: end if;
941: END ADD_TO_FROM_CLAUSE;
942:
943: PROCEDURE DEFINE_INTERFACE_COLUMN_TYPE (

Line 950: if EC_DEBUG.G_debug_level >= 2 then

946: iCol_size IN INTEGER,
947: p_tbl IN ece_flatfile_pvt.Interface_tbl_type)
948: IS
949: BEGIN
950: if EC_DEBUG.G_debug_level >= 2 then
951: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');
952: EC_DEBUG.PL(3, 'Column value: ', c);
953: EC_DEBUG.PL(3, 'Column : ', cCol);
954: EC_DEBUG.PL(3, 'Column size: ', iCol_size);

Line 951: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');

947: p_tbl IN ece_flatfile_pvt.Interface_tbl_type)
948: IS
949: BEGIN
950: if EC_DEBUG.G_debug_level >= 2 then
951: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');
952: EC_DEBUG.PL(3, 'Column value: ', c);
953: EC_DEBUG.PL(3, 'Column : ', cCol);
954: EC_DEBUG.PL(3, 'Column size: ', iCol_size);
955: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);

Line 952: EC_DEBUG.PL(3, 'Column value: ', c);

948: IS
949: BEGIN
950: if EC_DEBUG.G_debug_level >= 2 then
951: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');
952: EC_DEBUG.PL(3, 'Column value: ', c);
953: EC_DEBUG.PL(3, 'Column : ', cCol);
954: EC_DEBUG.PL(3, 'Column size: ', iCol_size);
955: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
956: end if;

Line 953: EC_DEBUG.PL(3, 'Column : ', cCol);

949: BEGIN
950: if EC_DEBUG.G_debug_level >= 2 then
951: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');
952: EC_DEBUG.PL(3, 'Column value: ', c);
953: EC_DEBUG.PL(3, 'Column : ', cCol);
954: EC_DEBUG.PL(3, 'Column size: ', iCol_size);
955: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
956: end if;
957:

Line 954: EC_DEBUG.PL(3, 'Column size: ', iCol_size);

950: if EC_DEBUG.G_debug_level >= 2 then
951: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');
952: EC_DEBUG.PL(3, 'Column value: ', c);
953: EC_DEBUG.PL(3, 'Column : ', cCol);
954: EC_DEBUG.PL(3, 'Column size: ', iCol_size);
955: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
956: end if;
957:
958: For k IN 1..p_tbl.count loop

Line 955: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);

951: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');
952: EC_DEBUG.PL(3, 'Column value: ', c);
953: EC_DEBUG.PL(3, 'Column : ', cCol);
954: EC_DEBUG.PL(3, 'Column size: ', iCol_size);
955: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
956: end if;
957:
958: For k IN 1..p_tbl.count loop
959: dbms_sql.define_column(c, k, cCol, iCol_size);

Line 962: if EC_DEBUG.G_debug_level >= 2 then

958: For k IN 1..p_tbl.count loop
959: dbms_sql.define_column(c, k, cCol, iCol_size);
960: End Loop;
961:
962: if EC_DEBUG.G_debug_level >= 2 then
963: EC_DEBUG.POP('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');
964: end if;
965: EXCEPTION
966: when others then

Line 963: EC_DEBUG.POP('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');

959: dbms_sql.define_column(c, k, cCol, iCol_size);
960: End Loop;
961:
962: if EC_DEBUG.G_debug_level >= 2 then
963: EC_DEBUG.POP('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');
964: end if;
965: EXCEPTION
966: when others then
967: app_exception.raise_exception;

Line 975: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');

971: c IN INTEGER,
972: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)
973: IS
974: BEGIN
975: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
976: if EC_DEBUG.G_debug_level >= 3 then
977: EC_DEBUG.PL(3, 'Column value: ', c);
978: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
979: end if;

Line 976: if EC_DEBUG.G_debug_level >= 3 then

972: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)
973: IS
974: BEGIN
975: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
976: if EC_DEBUG.G_debug_level >= 3 then
977: EC_DEBUG.PL(3, 'Column value: ', c);
978: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
979: end if;
980: for k in 1..p_tbl.count loop

Line 977: EC_DEBUG.PL(3, 'Column value: ', c);

973: IS
974: BEGIN
975: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
976: if EC_DEBUG.G_debug_level >= 3 then
977: EC_DEBUG.PL(3, 'Column value: ', c);
978: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
979: end if;
980: for k in 1..p_tbl.count loop
981: dbms_sql.column_value(c, k, p_tbl(k).value);

Line 978: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);

974: BEGIN
975: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
976: if EC_DEBUG.G_debug_level >= 3 then
977: EC_DEBUG.PL(3, 'Column value: ', c);
978: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
979: end if;
980: for k in 1..p_tbl.count loop
981: dbms_sql.column_value(c, k, p_tbl(k).value);
982: end loop;

Line 984: EC_DEBUG.POP('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');

980: for k in 1..p_tbl.count loop
981: dbms_sql.column_value(c, k, p_tbl(k).value);
982: end loop;
983:
984: EC_DEBUG.POP('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
985: EXCEPTION
986: when others then
987: app_exception.raise_exception;
988: END ASSIGN_COLUMN_VALUE_TO_TBL;

Line 997: if EC_DEBUG.G_debug_level >= 2 then

993: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
994: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)
995: IS
996: BEGIN
997: if EC_DEBUG.G_debug_level >= 2 then
998: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
999: EC_DEBUG.PL(3, 'Column : ', c);
1000: EC_DEBUG.PL(3, 'iCount : ', iCount);
1001: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);

Line 998: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');

994: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)
995: IS
996: BEGIN
997: if EC_DEBUG.G_debug_level >= 2 then
998: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
999: EC_DEBUG.PL(3, 'Column : ', c);
1000: EC_DEBUG.PL(3, 'iCount : ', iCount);
1001: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
1002: end if;

Line 999: EC_DEBUG.PL(3, 'Column : ', c);

995: IS
996: BEGIN
997: if EC_DEBUG.G_debug_level >= 2 then
998: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
999: EC_DEBUG.PL(3, 'Column : ', c);
1000: EC_DEBUG.PL(3, 'iCount : ', iCount);
1001: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
1002: end if;
1003: for k in 1..p_tbl.count loop

Line 1000: EC_DEBUG.PL(3, 'iCount : ', iCount);

996: BEGIN
997: if EC_DEBUG.G_debug_level >= 2 then
998: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
999: EC_DEBUG.PL(3, 'Column : ', c);
1000: EC_DEBUG.PL(3, 'iCount : ', iCount);
1001: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
1002: end if;
1003: for k in 1..p_tbl.count loop
1004: dbms_sql.column_value(c, k, p_tbl(k).value);

Line 1001: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);

997: if EC_DEBUG.G_debug_level >= 2 then
998: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
999: EC_DEBUG.PL(3, 'Column : ', c);
1000: EC_DEBUG.PL(3, 'iCount : ', iCount);
1001: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
1002: end if;
1003: for k in 1..p_tbl.count loop
1004: dbms_sql.column_value(c, k, p_tbl(k).value);
1005: dbms_sql.column_value(c, k, p_key_tbl(k+iCount).value);

Line 1008: if EC_DEBUG.G_debug_level >= 2 then

1004: dbms_sql.column_value(c, k, p_tbl(k).value);
1005: dbms_sql.column_value(c, k, p_key_tbl(k+iCount).value);
1006: end loop;
1007:
1008: if EC_DEBUG.G_debug_level >= 2 then
1009: EC_DEBUG.POP('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
1010: end if;
1011: EXCEPTION
1012: when others then

Line 1009: EC_DEBUG.POP('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');

1005: dbms_sql.column_value(c, k, p_key_tbl(k+iCount).value);
1006: end loop;
1007:
1008: if EC_DEBUG.G_debug_level >= 2 then
1009: EC_DEBUG.POP('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
1010: end if;
1011: EXCEPTION
1012: when others then
1013: app_exception.raise_exception;

Line 1025: if EC_DEBUG.G_debug_level >= 2 then

1021: b_found BOOLEAN := FALSE;
1022: pos_not_found EXCEPTION;
1023: cOutput_path VARCHAR2(120);
1024: BEGIN
1025: if EC_DEBUG.G_debug_level >= 2 then
1026: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.POS_OF');
1027: EC_DEBUG.PL(3, 'Row_count : ', l_Row_count);
1028: end if;
1029: For k in 1..l_Row_count loop

Line 1026: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.POS_OF');

1022: pos_not_found EXCEPTION;
1023: cOutput_path VARCHAR2(120);
1024: BEGIN
1025: if EC_DEBUG.G_debug_level >= 2 then
1026: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.POS_OF');
1027: EC_DEBUG.PL(3, 'Row_count : ', l_Row_count);
1028: end if;
1029: For k in 1..l_Row_count loop
1030: if UPPER(nvl(pInterface_tbl(k).interface_column_name, 'NULL')) = UPPER(cCol_name) then

Line 1027: EC_DEBUG.PL(3, 'Row_count : ', l_Row_count);

1023: cOutput_path VARCHAR2(120);
1024: BEGIN
1025: if EC_DEBUG.G_debug_level >= 2 then
1026: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.POS_OF');
1027: EC_DEBUG.PL(3, 'Row_count : ', l_Row_count);
1028: end if;
1029: For k in 1..l_Row_count loop
1030: if UPPER(nvl(pInterface_tbl(k).interface_column_name, 'NULL')) = UPPER(cCol_name) then
1031: b_found := TRUE;

Line 1032: if EC_DEBUG.G_debug_level >= 2 then

1028: end if;
1029: For k in 1..l_Row_count loop
1030: if UPPER(nvl(pInterface_tbl(k).interface_column_name, 'NULL')) = UPPER(cCol_name) then
1031: b_found := TRUE;
1032: if EC_DEBUG.G_debug_level >= 2 then
1033: EC_DEBUG.PL(3, 'Position : ', k);
1034: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');
1035: end if;
1036: return(k);

Line 1033: EC_DEBUG.PL(3, 'Position : ', k);

1029: For k in 1..l_Row_count loop
1030: if UPPER(nvl(pInterface_tbl(k).interface_column_name, 'NULL')) = UPPER(cCol_name) then
1031: b_found := TRUE;
1032: if EC_DEBUG.G_debug_level >= 2 then
1033: EC_DEBUG.PL(3, 'Position : ', k);
1034: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');
1035: end if;
1036: return(k);
1037: exit;

Line 1034: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');

1030: if UPPER(nvl(pInterface_tbl(k).interface_column_name, 'NULL')) = UPPER(cCol_name) then
1031: b_found := TRUE;
1032: if EC_DEBUG.G_debug_level >= 2 then
1033: EC_DEBUG.PL(3, 'Position : ', k);
1034: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');
1035: end if;
1036: return(k);
1037: exit;
1038: end if;

Line 1046: if EC_DEBUG.G_debug_level >= 2 then

1042: then
1043: raise pos_not_found;
1044: end if;
1045:
1046: if EC_DEBUG.G_debug_level >= 2 then
1047: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');
1048: end if;
1049: EXCEPTION
1050: WHEN pos_not_found THEN

Line 1047: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');

1043: raise pos_not_found;
1044: end if;
1045:
1046: if EC_DEBUG.G_debug_level >= 2 then
1047: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');
1048: end if;
1049: EXCEPTION
1050: WHEN pos_not_found THEN
1051: fnd_message.set_name('EC','ECE_PLSQL_POS_NOT_FOUND');

Line 1055: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.POS_OF');

1051: fnd_message.set_name('EC','ECE_PLSQL_POS_NOT_FOUND');
1052: fnd_message.set_token('COLUMN_NAME', upper(cCol_name));
1053: raise;
1054: WHEN OTHERS THEN
1055: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.POS_OF');
1056: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1057: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1058: app_exception.raise_exception;
1059:

Line 1056: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

1052: fnd_message.set_token('COLUMN_NAME', upper(cCol_name));
1053: raise;
1054: WHEN OTHERS THEN
1055: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.POS_OF');
1056: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1057: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1058: app_exception.raise_exception;
1059:
1060: END POS_OF;

Line 1057: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1053: raise;
1054: WHEN OTHERS THEN
1055: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.POS_OF');
1056: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1057: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1058: app_exception.raise_exception;
1059:
1060: END POS_OF;
1061: