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.EDW_GL_ACCT_M_C dependencies on EDW_LOG

Line 33: edw_log.debug_line(p_log);

29: p_log varchar2)
30: IS
31: BEGIN
32: if( g_debug) then
33: edw_log.debug_line(p_log);
34: end if;
35: END VBHDEBUG ;
36:
37: -- simple timing tools, setTimer and logTime.

Line 54: edw_log.put_line('Process Time for '|| p_process || ' : ' || edw_log.duration(l_duration));

50: IS
51: l_duration number := null;
52: BEGIN
53: l_duration := sysdate - p_log_timstamp;
54: edw_log.put_line('Process Time for '|| p_process || ' : ' || edw_log.duration(l_duration));
55: edw_log.put_line('');
56: END;
57:
58: procedure lookup_value_set_id(

Line 55: edw_log.put_line('');

51: l_duration number := null;
52: BEGIN
53: l_duration := sysdate - p_log_timstamp;
54: edw_log.put_line('Process Time for '|| p_process || ' : ' || edw_log.duration(l_duration));
55: edw_log.put_line('');
56: END;
57:
58: procedure lookup_value_set_id(
59: p_set_of_books_id IN number

Line 1269: edw_log.put_line( 'invalid dimension number '||p_dimension_no);

1265:
1266: VBHDEBUG('Got g_target_link ' || g_target_link );
1267:
1268: IF (p_dimension_no<1) or (p_dimension_no>10) THEN
1269: edw_log.put_line( 'invalid dimension number '||p_dimension_no);
1270: Return;
1271: END IF;
1272: edw_log.put_line('Collect program for '|| p_dimension_name ||' dimension');
1273: edw_log.put_line('Dimension number '|| p_dimension_no);

Line 1272: edw_log.put_line('Collect program for '|| p_dimension_name ||' dimension');

1268: IF (p_dimension_no<1) or (p_dimension_no>10) THEN
1269: edw_log.put_line( 'invalid dimension number '||p_dimension_no);
1270: Return;
1271: END IF;
1272: edw_log.put_line('Collect program for '|| p_dimension_name ||' dimension');
1273: edw_log.put_line('Dimension number '|| p_dimension_no);
1274: edw_log.put_line('Dimension physical name : '||g_dimension_name);
1275:
1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,

Line 1273: edw_log.put_line('Dimension number '|| p_dimension_no);

1269: edw_log.put_line( 'invalid dimension number '||p_dimension_no);
1270: Return;
1271: END IF;
1272: edw_log.put_line('Collect program for '|| p_dimension_name ||' dimension');
1273: edw_log.put_line('Dimension number '|| p_dimension_no);
1274: edw_log.put_line('Dimension physical name : '||g_dimension_name);
1275:
1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,
1277: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

Line 1274: edw_log.put_line('Dimension physical name : '||g_dimension_name);

1270: Return;
1271: END IF;
1272: edw_log.put_line('Collect program for '|| p_dimension_name ||' dimension');
1273: edw_log.put_line('Dimension number '|| p_dimension_no);
1274: edw_log.put_line('Dimension physical name : '||g_dimension_name);
1275:
1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,
1277: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1278: EDW_GL_ACCT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

Line 1279: EDW_LOG.PUT_LINE( 'The collection range is from '||to_char(EDW_GL_ACCT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||to_char(EDW_GL_ACCT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

1275:
1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,
1277: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1278: EDW_GL_ACCT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1279: EDW_LOG.PUT_LINE( 'The collection range is from '||to_char(EDW_GL_ACCT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||to_char(EDW_GL_ACCT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
1280: EDW_LOG.PUT_LINE(' ');
1281:
1282: select FND_PROFILE.VALUE('EDW_PARALLEL_SRC') into g_parallel_level from dual;
1283: if ( g_parallel_level is not null ) then

Line 1280: EDW_LOG.PUT_LINE(' ');

1276: EDW_GL_ACCT_M_C.g_push_date_range1 := nvl(l_from_date,
1277: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1278: EDW_GL_ACCT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1279: EDW_LOG.PUT_LINE( 'The collection range is from '||to_char(EDW_GL_ACCT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||to_char(EDW_GL_ACCT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
1280: EDW_LOG.PUT_LINE(' ');
1281:
1282: select FND_PROFILE.VALUE('EDW_PARALLEL_SRC') into g_parallel_level from dual;
1283: if ( g_parallel_level is not null ) then
1284: EDW_LOG.PUT_LINE('parallelism is set to ' || g_parallel_level);

Line 1284: EDW_LOG.PUT_LINE('parallelism is set to ' || g_parallel_level);

1280: EDW_LOG.PUT_LINE(' ');
1281:
1282: select FND_PROFILE.VALUE('EDW_PARALLEL_SRC') into g_parallel_level from dual;
1283: if ( g_parallel_level is not null ) then
1284: EDW_LOG.PUT_LINE('parallelism is set to ' || g_parallel_level);
1285: else
1286: EDW_LOG.PUT_LINE('no parallelism');
1287: end if;
1288: EDW_LOG.PUT_LINE(' ');

Line 1286: EDW_LOG.PUT_LINE('no parallelism');

1282: select FND_PROFILE.VALUE('EDW_PARALLEL_SRC') into g_parallel_level from dual;
1283: if ( g_parallel_level is not null ) then
1284: EDW_LOG.PUT_LINE('parallelism is set to ' || g_parallel_level);
1285: else
1286: EDW_LOG.PUT_LINE('no parallelism');
1287: end if;
1288: EDW_LOG.PUT_LINE(' ');
1289:
1290:

Line 1288: EDW_LOG.PUT_LINE(' ');

1284: EDW_LOG.PUT_LINE('parallelism is set to ' || g_parallel_level);
1285: else
1286: EDW_LOG.PUT_LINE('no parallelism');
1287: end if;
1288: EDW_LOG.PUT_LINE(' ');
1289:
1290:
1291: -- -----------------------------------------------------------------------------
1292: -- Start of Collection , Developer Customizable Section

Line 1294: edw_log.put_line(' ');

1290:
1291: -- -----------------------------------------------------------------------------
1292: -- Start of Collection , Developer Customizable Section
1293: -- -----------------------------------------------------------------------------
1294: edw_log.put_line(' ');
1295: edw_log.put_line('Start pushing data');
1296: l_temp_date := sysdate;
1297:
1298: create_value_temp_table;

Line 1295: edw_log.put_line('Start pushing data');

1291: -- -----------------------------------------------------------------------------
1292: -- Start of Collection , Developer Customizable Section
1293: -- -----------------------------------------------------------------------------
1294: edw_log.put_line(' ');
1295: edw_log.put_line('Start pushing data');
1296: l_temp_date := sysdate;
1297:
1298: create_value_temp_table;
1299: create_vbh_val_set_temp_tbl;

Line 1309: edw_log.put_line( 'No data found in EDW_LOCAL_INSTANCE table.');

1305: into g_instance_code
1306: from edw_local_instance;
1307: exception
1308: when no_data_found then
1309: edw_log.put_line( 'No data found in EDW_LOCAL_INSTANCE table.');
1310: return;
1311: when others then
1312: edw_log.put_line( 'Error: When looking up instance code in EDW_LOCAL_INSTANCE table.');
1313: return;

Line 1312: edw_log.put_line( 'Error: When looking up instance code in EDW_LOCAL_INSTANCE table.');

1308: when no_data_found then
1309: edw_log.put_line( 'No data found in EDW_LOCAL_INSTANCE table.');
1310: return;
1311: when others then
1312: edw_log.put_line( 'Error: When looking up instance code in EDW_LOCAL_INSTANCE table.');
1313: return;
1314: end;
1315:
1316: prepare_source_temp_table(l_source_temp_table_name, l_target_temp_table_name);

Line 1319: edw_log.put_line('');

1315:
1316: prepare_source_temp_table(l_source_temp_table_name, l_target_temp_table_name);
1317: l_temp_table_name := l_source_temp_table_name;
1318:
1319: edw_log.put_line('');
1320: edw_log.put_line('Pushing data from '||g_instance_code||'...');
1321: edw_log.put_line('');
1322: clean_up_temp_table(l_temp_table_name);
1323:

Line 1320: edw_log.put_line('Pushing data from '||g_instance_code||'...');

1316: prepare_source_temp_table(l_source_temp_table_name, l_target_temp_table_name);
1317: l_temp_table_name := l_source_temp_table_name;
1318:
1319: edw_log.put_line('');
1320: edw_log.put_line('Pushing data from '||g_instance_code||'...');
1321: edw_log.put_line('');
1322: clean_up_temp_table(l_temp_table_name);
1323:
1324:

Line 1321: edw_log.put_line('');

1317: l_temp_table_name := l_source_temp_table_name;
1318:
1319: edw_log.put_line('');
1320: edw_log.put_line('Pushing data from '||g_instance_code||'...');
1321: edw_log.put_line('');
1322: clean_up_temp_table(l_temp_table_name);
1323:
1324:
1325: l_temp_insert_count := bulk_push_parent_child_pair( l_temp_table_name);

Line 1431: edw_log.put_line('Error:'||l_parent_value||

1427: WHERE flex_value_set_id=:s1
1428: AND flex_value=:s2' using l_parent_value_set_id,l_parent_value;
1429: fetch cur_desc into l_parent_desc;
1430: if cur_desc%NOTFOUND then
1431: edw_log.put_line('Error:'||l_parent_value||
1432: ' returned by the consolidation funcation is not found in value set '
1433: ||l_parent_value_set_id);
1434: end if;
1435: close cur_desc;

Line 1451: edw_log.put_line('inserted '|| l_rows_inserted||' consolidation relationships between '||

1447: END IF; -- for l_parent_desc is not null
1448: END IF;--for parent value is not null
1449: END LOOP;--for cur_cons_from_flex_value
1450: CLOSE cur_flex_value_desc;
1451: edw_log.put_line('inserted '|| l_rows_inserted||' consolidation relationships between '||
1452: l_set_of_books.set_of_books_name||' and '|| l_parent_set_of_books.set_of_books_name||
1453: ' into '|| l_temp_table_name);
1454: edw_log.put_line('');
1455:

Line 1454: edw_log.put_line('');

1450: CLOSE cur_flex_value_desc;
1451: edw_log.put_line('inserted '|| l_rows_inserted||' consolidation relationships between '||
1452: l_set_of_books.set_of_books_name||' and '|| l_parent_set_of_books.set_of_books_name||
1453: ' into '|| l_temp_table_name);
1454: edw_log.put_line('');
1455:
1456: END LOOP; --for parent set of books loop
1457: CLOSE cur_parent_set_of_books;
1458: logTime('Consolidations', l_log_timstamp);

Line 1472: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

1468:
1469: l_rows_replicated := rep_from_src_to_target(l_source_temp_table_name, l_target_temp_table_name);
1470:
1471: l_duration := sysdate - l_temp_date;
1472: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
1473: edw_log.put_line(' ');
1474: edw_log.put_line(g_row_count||' rows inserted');
1475: edw_log.put_line(l_dups_removed ||' duplicates removed');
1476: edw_log.put_line(l_rows_replicated ||' rows replicated from source temp to target');

Line 1473: edw_log.put_line(' ');

1469: l_rows_replicated := rep_from_src_to_target(l_source_temp_table_name, l_target_temp_table_name);
1470:
1471: l_duration := sysdate - l_temp_date;
1472: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
1473: edw_log.put_line(' ');
1474: edw_log.put_line(g_row_count||' rows inserted');
1475: edw_log.put_line(l_dups_removed ||' duplicates removed');
1476: edw_log.put_line(l_rows_replicated ||' rows replicated from source temp to target');
1477:

Line 1474: edw_log.put_line(g_row_count||' rows inserted');

1470:
1471: l_duration := sysdate - l_temp_date;
1472: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
1473: edw_log.put_line(' ');
1474: edw_log.put_line(g_row_count||' rows inserted');
1475: edw_log.put_line(l_dups_removed ||' duplicates removed');
1476: edw_log.put_line(l_rows_replicated ||' rows replicated from source temp to target');
1477:
1478:

Line 1475: edw_log.put_line(l_dups_removed ||' duplicates removed');

1471: l_duration := sysdate - l_temp_date;
1472: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
1473: edw_log.put_line(' ');
1474: edw_log.put_line(g_row_count||' rows inserted');
1475: edw_log.put_line(l_dups_removed ||' duplicates removed');
1476: edw_log.put_line(l_rows_replicated ||' rows replicated from source temp to target');
1477:
1478:
1479: -- ---------------------------------------------------------------------------

Line 1476: edw_log.put_line(l_rows_replicated ||' rows replicated from source temp to target');

1472: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
1473: edw_log.put_line(' ');
1474: edw_log.put_line(g_row_count||' rows inserted');
1475: edw_log.put_line(l_dups_removed ||' duplicates removed');
1476: edw_log.put_line(l_rows_replicated ||' rows replicated from source temp to target');
1477:
1478:
1479: -- ---------------------------------------------------------------------------
1480: -- END OF Collection , Developer Customizable Section