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

Line 29: edw_log.put_line( 'p_from_date = ' || p_from_date );

25: Begin
26: Errbuf :=NULL;
27: Retcode:=0;
28:
29: edw_log.put_line( 'p_from_date = ' || p_from_date );
30: edw_log.put_line( 'p_to_date = ' || p_to_date );
31:
32: edw_log.put_line( 'About to set l_from_date' );
33: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');

Line 30: edw_log.put_line( 'p_to_date = ' || p_to_date );

26: Errbuf :=NULL;
27: Retcode:=0;
28:
29: edw_log.put_line( 'p_from_date = ' || p_from_date );
30: edw_log.put_line( 'p_to_date = ' || p_to_date );
31:
32: edw_log.put_line( 'About to set l_from_date' );
33: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
34:

Line 32: edw_log.put_line( 'About to set l_from_date' );

28:
29: edw_log.put_line( 'p_from_date = ' || p_from_date );
30: edw_log.put_line( 'p_to_date = ' || p_to_date );
31:
32: edw_log.put_line( 'About to set l_from_date' );
33: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
34:
35: edw_log.put_line( 'About to set l_to_date' );
36: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');

Line 35: edw_log.put_line( 'About to set l_to_date' );

31:
32: edw_log.put_line( 'About to set l_from_date' );
33: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
34:
35: edw_log.put_line( 'About to set l_to_date' );
36: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
37:
38: edw_log.put_line( 'Both date variables are set' );
39:

Line 38: edw_log.put_line( 'Both date variables are set' );

34:
35: edw_log.put_line( 'About to set l_to_date' );
36: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
37:
38: edw_log.put_line( 'Both date variables are set' );
39:
40: IF (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) THEN
41: errbuf := fnd_message.get;
42: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);

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

44:
45: FII_GL_BOOK_M_C.g_push_date_range1 := nvl(l_from_date,
46: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
47: FII_GL_BOOK_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
48: edw_log.put_line( 'The collection range is from '||
49: to_char(FII_GL_BOOK_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
50: to_char(FII_GL_BOOK_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
51: edw_log.put_line(' ');
52:

Line 51: edw_log.put_line(' ');

47: FII_GL_BOOK_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
48: edw_log.put_line( 'The collection range is from '||
49: to_char(FII_GL_BOOK_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
50: to_char(FII_GL_BOOK_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
51: edw_log.put_line(' ');
52:
53: -- -----------------------------------------------------------------------------
54: -- Start of Collection , Developer Customizable Section
55: -- -----------------------------------------------------------------------------

Line 57: edw_log.put_line(' ');

53: -- -----------------------------------------------------------------------------
54: -- Start of Collection , Developer Customizable Section
55: -- -----------------------------------------------------------------------------
56:
57: edw_log.put_line(' ');
58: edw_log.put_line('Pushing data');
59:
60: l_temp_date := sysdate;
61:

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

54: -- Start of Collection , Developer Customizable Section
55: -- -----------------------------------------------------------------------------
56:
57: edw_log.put_line(' ');
58: edw_log.put_line('Pushing data');
59:
60: l_temp_date := sysdate;
61:
62:

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

65:
66:
67: l_duration := sysdate - l_temp_date;
68:
69: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
70: edw_log.put_line(' ');
71: -- ---------------------------------------------------------------------------
72: -- END OF Collection , Developer Customizable Section
73: -- ---------------------------------------------------------------------------

Line 70: edw_log.put_line(' ');

66:
67: l_duration := sysdate - l_temp_date;
68:
69: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
70: edw_log.put_line(' ');
71: -- ---------------------------------------------------------------------------
72: -- END OF Collection , Developer Customizable Section
73: -- ---------------------------------------------------------------------------
74: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);

Line 95: edw_log.put_line('Starting Push_EDW_GL_BOOK_FA_BOOK_LSTG');

91: l_date2 DATE;
92: l_rows_inserted NUMBER :=0;
93:
94: BEGIN
95: edw_log.put_line('Starting Push_EDW_GL_BOOK_FA_BOOK_LSTG');
96: l_date1 := p_from_date;
97: l_date2 := p_to_date;
98:
99: Insert Into EDW_GL_BOOK_FA_BOOK_LSTG(

Line 144: edw_log.put_line('Commiting records for EDW_GL_BOOK_FA_BOOK_LSTG');

140: where last_update_date between l_date1 and l_date2;
141:
142: l_rows_inserted := sql%rowcount;
143: g_row_count := g_row_count + l_rows_inserted ;
144: edw_log.put_line('Commiting records for EDW_GL_BOOK_FA_BOOK_LSTG');
145: commit;
146:
147: edw_log.put_line('Completed Push_EDW_GL_BOOK_FA_BOOK_LSTG');
148:

Line 147: edw_log.put_line('Completed Push_EDW_GL_BOOK_FA_BOOK_LSTG');

143: g_row_count := g_row_count + l_rows_inserted ;
144: edw_log.put_line('Commiting records for EDW_GL_BOOK_FA_BOOK_LSTG');
145: commit;
146:
147: edw_log.put_line('Completed Push_EDW_GL_BOOK_FA_BOOK_LSTG');
148:
149: Exception When others then
150: raise;
151: commit;

Line 162: edw_log.put_line('Starting Push_EDW_GL_BOOK_BOOK_LSTG');

158: l_rows_inserted NUMBER :=0;
159:
160: BEGIN
161:
162: edw_log.put_line('Starting Push_EDW_GL_BOOK_BOOK_LSTG');
163: l_date1 := p_from_date;
164: l_date2 := p_to_date;
165:
166: Insert Into EDW_GL_BOOK_BOOK_LSTG(

Line 213: edw_log.put_line('Commiting records for EDW_GL_BOOK_BOOK_LSTG');

209: trunc(sysdate)
210: from FII_GL_BOOK_BOOK_LCV
211: where last_update_date between l_date1 and l_date2;
212:
213: edw_log.put_line('Commiting records for EDW_GL_BOOK_BOOK_LSTG');
214: commit;
215:
216: edw_log.put_line('Completed Push_EDW_GL_BOOK_BOOK_LSTG');
217:

Line 216: edw_log.put_line('Completed Push_EDW_GL_BOOK_BOOK_LSTG');

212:
213: edw_log.put_line('Commiting records for EDW_GL_BOOK_BOOK_LSTG');
214: commit;
215:
216: edw_log.put_line('Completed Push_EDW_GL_BOOK_BOOK_LSTG');
217:
218: Exception When others then
219: raise;
220: commit;