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_OPI_PRDL_M_C dependencies on EDW_LOG

Line 53: edw_log.put_line( 'The collection range is from '||

49: EDW_OPI_PRDL_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
50: END IF;
51:
52:
53: edw_log.put_line( 'The collection range is from '||
54: to_char(EDW_OPI_PRDL_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
55: to_char(EDW_OPI_PRDL_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
56: edw_log.put_line(' ');
57:

Line 56: edw_log.put_line(' ');

52:
53: edw_log.put_line( 'The collection range is from '||
54: to_char(EDW_OPI_PRDL_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
55: to_char(EDW_OPI_PRDL_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
56: edw_log.put_line(' ');
57:
58: -- -----------------------------------------------------------------------------
59: -- Start of Collection , Developer Customizable Section
60: -- -----------------------------------------------------------------------------

Line 62: edw_log.put_line(' ');

58: -- -----------------------------------------------------------------------------
59: -- Start of Collection , Developer Customizable Section
60: -- -----------------------------------------------------------------------------
61:
62: edw_log.put_line(' ');
63: edw_log.put_line('Pushing data');
64:
65: l_temp_date := sysdate;
66:

Line 63: edw_log.put_line('Pushing data');

59: -- Start of Collection , Developer Customizable Section
60: -- -----------------------------------------------------------------------------
61:
62: edw_log.put_line(' ');
63: edw_log.put_line('Pushing data');
64:
65: l_temp_date := sysdate;
66:
67:

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

69:
70:
71: l_duration := sysdate - l_temp_date;
72:
73: edw_log.put_line('Total rows inserted : '||g_row_count);
74: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
75: edw_log.put_line(' ');
76: -- ---------------------------------------------------------------------------
77: -- END OF Collection , Developer Customizable Section

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

70:
71: l_duration := sysdate - l_temp_date;
72:
73: edw_log.put_line('Total rows inserted : '||g_row_count);
74: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
75: edw_log.put_line(' ');
76: -- ---------------------------------------------------------------------------
77: -- END OF Collection , Developer Customizable Section
78: -- ---------------------------------------------------------------------------

Line 75: edw_log.put_line(' ');

71: l_duration := sysdate - l_temp_date;
72:
73: edw_log.put_line('Total rows inserted : '||g_row_count);
74: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
75: edw_log.put_line(' ');
76: -- ---------------------------------------------------------------------------
77: -- END OF Collection , Developer Customizable Section
78: -- ---------------------------------------------------------------------------
79: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,

Line 104: edw_log.put_line('Starting Push_EDW_OPI_PRDL_PRDL_LSTG');

100: l_date1 DATE;
101: l_date2 DATE;
102: l_rows_inserted NUMBER :=0;
103: BEGIN
104: edw_log.put_line('Starting Push_EDW_OPI_PRDL_PRDL_LSTG');
105: l_date1 := p_from_date;
106: l_date2 := p_to_date;
107:
108: Insert Into EDW_OPI_PRDL_PRDL_LSTG@EDW_APPS_TO_WH (

Line 147: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

143:
144:
145: l_rows_inserted := sql%rowcount;
146: EDW_OPI_PRDL_M_C.g_row_count := EDW_OPI_PRDL_M_C.g_row_count + l_rows_inserted ;
147: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
148: ' rows into the staging table');
149: edw_log.put_line('Commiting records for EDW_OPI_PRDL_PRDL_LSTG');
150: commit;
151:

Line 149: edw_log.put_line('Commiting records for EDW_OPI_PRDL_PRDL_LSTG');

145: l_rows_inserted := sql%rowcount;
146: EDW_OPI_PRDL_M_C.g_row_count := EDW_OPI_PRDL_M_C.g_row_count + l_rows_inserted ;
147: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
148: ' rows into the staging table');
149: edw_log.put_line('Commiting records for EDW_OPI_PRDL_PRDL_LSTG');
150: commit;
151:
152: edw_log.put_line('Completed Push_EDW_OPI_PRDL_PRDL_LSTG');
153: Exception When others then

Line 152: edw_log.put_line('Completed Push_EDW_OPI_PRDL_PRDL_LSTG');

148: ' rows into the staging table');
149: edw_log.put_line('Commiting records for EDW_OPI_PRDL_PRDL_LSTG');
150: commit;
151:
152: edw_log.put_line('Completed Push_EDW_OPI_PRDL_PRDL_LSTG');
153: Exception When others then
154: raise;
155: commit;
156: END;