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

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

40:
41: EDW_UNSPSC_M_C.g_push_date_range2 := nvl(l_to_date,
42: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_UNSPSC_M_C.g_push_date_range1,
46: 'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_UNSPSC_M_C.g_push_date_range2,
48: 'MM/DD/YYYY HH24:MI:SS'));

Line 50: edw_log.put_line(' ');

46: 'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_UNSPSC_M_C.g_push_date_range2,
48: 'MM/DD/YYYY HH24:MI:SS'));
49:
50: edw_log.put_line(' ');
51: edw_log.put_line('Pushing data');
52:
53: Push_EDW_DNB_POA_ITEMS();
54: Push_EDW_UNSPSC_CLASS_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,

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

47: to_char(EDW_UNSPSC_M_C.g_push_date_range2,
48: 'MM/DD/YYYY HH24:MI:SS'));
49:
50: edw_log.put_line(' ');
51: edw_log.put_line('Pushing data');
52:
53: Push_EDW_DNB_POA_ITEMS();
54: Push_EDW_UNSPSC_CLASS_LSTG(EDW_UNSPSC_M_C.g_push_date_range1,
55: EDW_UNSPSC_M_C.g_push_date_range2);

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

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

Line 72: edw_log.put_line(' ');

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

Line 143: edw_log.put_line('Starting Push_EDW_UNSPSC_CLASS_LSTG');

139: l_date1 DATE;
140: l_date2 DATE;
141: l_rows_inserted NUMBER :=0;
142: BEGIN
143: edw_log.put_line('Starting Push_EDW_UNSPSC_CLASS_LSTG');
144: l_date1 := p_from_date;
145: l_date2 := p_to_date;
146: Insert Into
147: EDW_SPSC_CLASS_LSTG(

Line 169: edw_log.put_line('Commiting records for EDW_SPSC_CLASS_LSTG');

165: from POA_UNSPSC_INTERFACE dnb;
166:
167: l_rows_inserted := sql%rowcount;
168: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
169: edw_log.put_line('Commiting records for EDW_SPSC_CLASS_LSTG');
170: commit;
171:
172: edw_log.put_line('Completed Push_EDW_UNSPSC_CLASS_LSTG');
173: Exception When others then

Line 172: edw_log.put_line('Completed Push_EDW_UNSPSC_CLASS_LSTG');

168: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
169: edw_log.put_line('Commiting records for EDW_SPSC_CLASS_LSTG');
170: commit;
171:
172: edw_log.put_line('Completed Push_EDW_UNSPSC_CLASS_LSTG');
173: Exception When others then
174: raise;
175: commit;
176: END Push_EDW_UNSPSC_CLASS_LSTG;

Line 186: edw_log.put_line('Starting Push_UNSPSC_COMMODITY_LSTG');

182: l_date1 DATE;
183: l_date2 DATE;
184: l_rows_inserted NUMBER :=0;
185: BEGIN
186: edw_log.put_line('Starting Push_UNSPSC_COMMODITY_LSTG');
187: l_date1 := p_from_date;
188: l_date2 := p_to_date;
189: Insert Into
190: EDW_SPSC_COMMODITY_LSTG(

Line 216: edw_log.put_line('Commiting records for EDW_SPSC_COMMODITY_LSTG');

212: from POA_UNSPSC_INTERFACE dnb;
213:
214: l_rows_inserted := sql%rowcount;
215: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
216: edw_log.put_line('Commiting records for EDW_SPSC_COMMODITY_LSTG');
217: commit;
218:
219: edw_log.put_line('Completed Push_EDW_UNSPSC_COMMODITY_LSTG');
220: Exception When others then

Line 219: edw_log.put_line('Completed Push_EDW_UNSPSC_COMMODITY_LSTG');

215: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
216: edw_log.put_line('Commiting records for EDW_SPSC_COMMODITY_LSTG');
217: commit;
218:
219: edw_log.put_line('Completed Push_EDW_UNSPSC_COMMODITY_LSTG');
220: Exception When others then
221: raise;
222: commit;
223: END Push_EDW_UNSPSC_COMMODITY_LSTG;

Line 235: edw_log.put_line('Starting Push_EDW_UNSPSC_FAMILY_LSTG');

231: l_date1 DATE;
232: l_date2 DATE;
233: l_rows_inserted NUMBER :=0;
234: BEGIN
235: edw_log.put_line('Starting Push_EDW_UNSPSC_FAMILY_LSTG');
236: l_date1 := p_from_date;
237: l_date2 := p_to_date;
238: Insert Into
239: EDW_SPSC_FAMILY_LSTG(

Line 261: edw_log.put_line('Commiting records for EDW_SPSC_FAMILY_LSTG');

257: from POA_UNSPSC_INTERFACE dnb;
258:
259: l_rows_inserted := sql%rowcount;
260: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
261: edw_log.put_line('Commiting records for EDW_SPSC_FAMILY_LSTG');
262: commit;
263:
264: edw_log.put_line('Completed Push_EDW_UNSPSC_FAMILY_LSTG');
265: Exception When others then

Line 264: edw_log.put_line('Completed Push_EDW_UNSPSC_FAMILY_LSTG');

260: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
261: edw_log.put_line('Commiting records for EDW_SPSC_FAMILY_LSTG');
262: commit;
263:
264: edw_log.put_line('Completed Push_EDW_UNSPSC_FAMILY_LSTG');
265: Exception When others then
266: raise;
267: commit;
268: END Push_EDW_UNSPSC_FAMILY_LSTG;

Line 277: edw_log.put_line('Starting Push_EDW_UNSPSC_FUNCTION_LSTG_LSTG');

273: l_date1 DATE;
274: l_date2 DATE;
275: l_rows_inserted NUMBER :=0;
276: BEGIN
277: edw_log.put_line('Starting Push_EDW_UNSPSC_FUNCTION_LSTG_LSTG');
278: l_date1 := p_from_date;
279: l_date2 := p_to_date;
280:
281: -- Set the Update Fact Flag

Line 320: edw_log.put_line('Commiting records for EDW_SPSC_FUNCTION_LSTG');

316: where (dnb.Item_PK = poa.Item_PK);
317:
318: l_rows_inserted := sql%rowcount;
319: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
320: edw_log.put_line('Commiting records for EDW_SPSC_FUNCTION_LSTG');
321: commit;
322:
323: edw_log.put_line('Completed Push_EDW_UNSPSC_FUNCTION_LSTG');
324: Exception When others then

Line 323: edw_log.put_line('Completed Push_EDW_UNSPSC_FUNCTION_LSTG');

319: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
320: edw_log.put_line('Commiting records for EDW_SPSC_FUNCTION_LSTG');
321: commit;
322:
323: edw_log.put_line('Completed Push_EDW_UNSPSC_FUNCTION_LSTG');
324: Exception When others then
325: raise;
326: commit;
327: END Push_EDW_UNSPSC_FUNCTION_LSTG;

Line 338: edw_log.put_line('Starting Push_EDW_UNSPSC_SEGMENT_LSTG');

334: l_date1 DATE;
335: l_date2 DATE;
336: l_rows_inserted NUMBER :=0;
337: BEGIN
338: edw_log.put_line('Starting Push_EDW_UNSPSC_SEGMENT_LSTG');
339: l_date1 := p_from_date;
340: l_date2 := p_to_date;
341:
342: Insert Into

Line 365: edw_log.put_line('Commiting records for EDW_SPSC_SEGMENT_LSTG');

361: from POA_UNSPSC_INTERFACE dnb;
362:
363: l_rows_inserted := sql%rowcount;
364: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
365: edw_log.put_line('Commiting records for EDW_SPSC_SEGMENT_LSTG');
366: commit;
367:
368: edw_log.put_line('Completed Push_EDW_UNSPSC_SEGMENT_LSTG');
369: Exception When others then

Line 368: edw_log.put_line('Completed Push_EDW_UNSPSC_SEGMENT_LSTG');

364: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;
365: edw_log.put_line('Commiting records for EDW_SPSC_SEGMENT_LSTG');
366: commit;
367:
368: edw_log.put_line('Completed Push_EDW_UNSPSC_SEGMENT_LSTG');
369: Exception When others then
370: raise;
371: END Push_EDW_UNSPSC_SEGMENT_LSTG;
372: