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

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

33: END IF;
34: FII_AP_INV_TYPE_M_C.g_push_date_range1 := nvl(l_from_date,
35: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
36: FII_AP_INV_TYPE_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
37: edw_log.put_line( 'The collection range is from '||
38: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
39: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
40: edw_log.put_line(' ');
41:

Line 40: edw_log.put_line(' ');

36: FII_AP_INV_TYPE_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
37: edw_log.put_line( 'The collection range is from '||
38: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
39: to_char(FII_AP_INV_TYPE_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
40: edw_log.put_line(' ');
41:
42: -- -----------------------------
43: -- Read in profile option value --**Added for Merrill Lynch, 03-DEC-02
44: -- -----------------------------

Line 51: edw_log.put_line(' ');

47: -- -----------------------------------------------------------------------------
48: -- Start of Collection , Developer Customizable Section
49: -- -----------------------------------------------------------------------------
50:
51: edw_log.put_line(' ');
52: edw_log.put_line('Pushing data');
53:
54: l_temp_date := sysdate;
55:

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

48: -- Start of Collection , Developer Customizable Section
49: -- -----------------------------------------------------------------------------
50:
51: edw_log.put_line(' ');
52: edw_log.put_line('Pushing data');
53:
54: l_temp_date := sysdate;
55:
56:

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

59:
60:
61: l_duration := sysdate - l_temp_date;
62:
63: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
64: edw_log.put_line(' ');
65: -- ---------------------------------------------------------------------------
66: -- END OF Collection , Developer Customizable Section
67: -- ---------------------------------------------------------------------------

Line 64: edw_log.put_line(' ');

60:
61: l_duration := sysdate - l_temp_date;
62:
63: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
64: edw_log.put_line(' ');
65: -- ---------------------------------------------------------------------------
66: -- END OF Collection , Developer Customizable Section
67: -- ---------------------------------------------------------------------------
68: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);

Line 92: edw_log.put_line('Starting Push_EDW_IVTY_INV_LSTG');

88: l_stmt VARCHAR2(5000); -- Added for Merrill Lynch,04-DEC-02
89: l_er_stmt varchar2(100) :=NULL; -- Added for Merrill Lynch,04-DEC-02
90:
91: BEGIN
92: edw_log.put_line('Starting Push_EDW_IVTY_INV_LSTG');
93: l_date1 := p_from_date;
94: l_date2 := p_to_date;
95:
96: IF (g_collect_er <> 'Y') THEN

Line 144: edw_log.debug_line('');

140: where last_update_date between :l_date1 and :l_date2'||l_er_stmt;
141: --**
142:
143: --** Added for Merrill Lynch,04-DEC-02
144: edw_log.debug_line('');
145: edw_log.debug_line(l_stmt);
146: execute immediate l_stmt using l_date1,l_date2;
147: --**
148:

Line 145: edw_log.debug_line(l_stmt);

141: --**
142:
143: --** Added for Merrill Lynch,04-DEC-02
144: edw_log.debug_line('');
145: edw_log.debug_line(l_stmt);
146: execute immediate l_stmt using l_date1,l_date2;
147: --**
148:
149: l_rows_inserted := sql%rowcount;

Line 151: edw_log.debug_line('Inserted '|| l_rows_inserted ||' rows into EDW_IVTY_INV_LSTG table'); -- Added for Merrill Lynch,04-DEC-02

147: --**
148:
149: l_rows_inserted := sql%rowcount;
150:
151: edw_log.debug_line('Inserted '|| l_rows_inserted ||' rows into EDW_IVTY_INV_LSTG table'); -- Added for Merrill Lynch,04-DEC-02
152:
153: g_row_count := g_row_count + l_rows_inserted ;
154: edw_log.put_line('Commiting records for EDW_IVTY_INV_LSTG');
155: commit;

Line 154: edw_log.put_line('Commiting records for EDW_IVTY_INV_LSTG');

150:
151: edw_log.debug_line('Inserted '|| l_rows_inserted ||' rows into EDW_IVTY_INV_LSTG table'); -- Added for Merrill Lynch,04-DEC-02
152:
153: g_row_count := g_row_count + l_rows_inserted ;
154: edw_log.put_line('Commiting records for EDW_IVTY_INV_LSTG');
155: commit;
156:
157: edw_log.put_line('Completed Push_EDW_IVTY_INV_LSTG');
158: Exception When others then

Line 157: edw_log.put_line('Completed Push_EDW_IVTY_INV_LSTG');

153: g_row_count := g_row_count + l_rows_inserted ;
154: edw_log.put_line('Commiting records for EDW_IVTY_INV_LSTG');
155: commit;
156:
157: edw_log.put_line('Completed Push_EDW_IVTY_INV_LSTG');
158: Exception When others then
159: raise;
160: commit;
161: END;

Line 173: edw_log.put_line('Starting Push_EDW_IVTY_INV_TYPE_LSTG');

169: l_stmt VARCHAR2(5000); -- Added for Merrill Lynch,04-DEC-02
170: l_er_stmt VARCHAR2(100) := NULL; -- Added for Merrill Lynch,04-DEC-02
171:
172: BEGIN
173: edw_log.put_line('Starting Push_EDW_IVTY_INV_TYPE_LSTG');
174: l_date1 := p_from_date;
175: l_date2 := p_to_date;
176:
177: IF (g_collect_er <> 'Y') THEN -- Added for Merrill Lynch,04-DEC-02

Line 220: edw_log.debug_line('');

216: from FII_AP_IVTY_INV_TYPE_LCV'||l_er_stmt;
217: --**
218:
219: --** Added for Merrill Lynch,04-DEC-02
220: edw_log.debug_line('');
221: edw_log.debug_line(l_stmt);
222: execute immediate l_stmt;
223:
224: edw_log.debug_line('Inserted '||sql%rowcount||' rows into EDW_IVTY_INV_TYPE_LSTG table');

Line 221: edw_log.debug_line(l_stmt);

217: --**
218:
219: --** Added for Merrill Lynch,04-DEC-02
220: edw_log.debug_line('');
221: edw_log.debug_line(l_stmt);
222: execute immediate l_stmt;
223:
224: edw_log.debug_line('Inserted '||sql%rowcount||' rows into EDW_IVTY_INV_TYPE_LSTG table');
225: --**

Line 224: edw_log.debug_line('Inserted '||sql%rowcount||' rows into EDW_IVTY_INV_TYPE_LSTG table');

220: edw_log.debug_line('');
221: edw_log.debug_line(l_stmt);
222: execute immediate l_stmt;
223:
224: edw_log.debug_line('Inserted '||sql%rowcount||' rows into EDW_IVTY_INV_TYPE_LSTG table');
225: --**
226:
227: edw_log.put_line('Commiting records for EDW_IVTY_INV_TYPE_LSTG');
228: commit;

Line 227: edw_log.put_line('Commiting records for EDW_IVTY_INV_TYPE_LSTG');

223:
224: edw_log.debug_line('Inserted '||sql%rowcount||' rows into EDW_IVTY_INV_TYPE_LSTG table');
225: --**
226:
227: edw_log.put_line('Commiting records for EDW_IVTY_INV_TYPE_LSTG');
228: commit;
229:
230: edw_log.put_line('Completed Push_EDW_IVTY_INV_TYPE_LSTG');
231: Exception When others then

Line 230: edw_log.put_line('Completed Push_EDW_IVTY_INV_TYPE_LSTG');

226:
227: edw_log.put_line('Commiting records for EDW_IVTY_INV_TYPE_LSTG');
228: commit;
229:
230: edw_log.put_line('Completed Push_EDW_IVTY_INV_TYPE_LSTG');
231: Exception When others then
232: raise;
233: commit;
234: END;