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

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

50: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
51:
52: l_date1 := g_push_date_range1;
53: l_date2 := g_push_date_range2;
54: edw_log.put_line( 'The collection range is from '||
55: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
56: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
57: edw_log.put_line(' ');
58:

Line 57: edw_log.put_line(' ');

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

Line 63: edw_log.put_line(' ');

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

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

60: -- Start of Collection , Developer Customizable Section
61: -- -----------------------------------------------------------------------------
62:
63: edw_log.put_line(' ');
64: edw_log.put_line('Pushing data');
65:
66: l_temp_date := sysdate;
67:
68: IF (NOT FND_INSTALLATION.GET_APP_INFO('POA', g_status, g_industry, g_schema)) THEN

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

82:
83:
84: l_duration := sysdate - l_temp_date;
85:
86: edw_log.put_line('Process Time: '|| edw_log.duration(l_duration));
87: edw_log.put_line(' ');
88: -- ---------------------------------------------------------------------------
89: -- END OF Collection , Developer Customizable Section
90: -- ---------------------------------------------------------------------------

Line 87: edw_log.put_line(' ');

83:
84: l_duration := sysdate - l_temp_date;
85:
86: edw_log.put_line('Process Time: '|| edw_log.duration(l_duration));
87: edw_log.put_line(' ');
88: -- ---------------------------------------------------------------------------
89: -- END OF Collection , Developer Customizable Section
90: -- ---------------------------------------------------------------------------
91:

Line 112: edw_log.put_line('Starting Push_EDW_GEOG_LOCATION_LSTG');

108: l_date1 DATE;
109: l_date2 DATE;
110: l_rows_inserted NUMBER :=0;
111: BEGIN
112: edw_log.put_line('Starting Push_EDW_GEOG_LOCATION_LSTG');
113: l_date1 := p_from_date;
114: l_date2 := p_to_date;
115: Insert Into
116: EDW_GEOG_LOCATION_LSTG(

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

176:
177: l_rows_inserted := sql%rowcount;
178: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
179:
180: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
181: ' rows into the staging table');
182:
183: edw_log.put_line('Completed Push_EDW_GEOG_LOCATION_LSTG');
184:

Line 183: edw_log.put_line('Completed Push_EDW_GEOG_LOCATION_LSTG');

179:
180: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
181: ' rows into the staging table');
182:
183: edw_log.put_line('Completed Push_EDW_GEOG_LOCATION_LSTG');
184:
185: EDW_GEOGRAPHY_M_C.g_row_count_m := l_rows_inserted;
186:
187: Exception When others then

Line 199: edw_log.put_line('Starting Push_EDW_GEOG_POSTCODE_CITY_LSTG');

195: l_date1 DATE;
196: l_date2 DATE;
197: l_rows_inserted NUMBER :=0;
198: BEGIN
199: edw_log.put_line('Starting Push_EDW_GEOG_POSTCODE_CITY_LSTG');
200:
201:
202: -------- To get PK info from the warehouse (bug #1757640) ------
203:

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

274:
275: l_rows_inserted := sql%rowcount;
276: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
277:
278: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
279: ' rows into the staging table');
280:
281: edw_log.put_line('Completed Push_EDW_GEOG_POSTCODE_CITY_LSTG');
282:

Line 281: edw_log.put_line('Completed Push_EDW_GEOG_POSTCODE_CITY_LSTG');

277:
278: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
279: ' rows into the staging table');
280:
281: edw_log.put_line('Completed Push_EDW_GEOG_POSTCODE_CITY_LSTG');
282:
283: Exception When others then
284: rollback;
285: raise;

Line 295: edw_log.put_line('Starting Push_EDW_GEOG_CITY_LSTG');

291: l_date1 DATE;
292: l_date2 DATE;
293: l_rows_inserted NUMBER :=0;
294: BEGIN
295: edw_log.put_line('Starting Push_EDW_GEOG_CITY_LSTG');
296:
297: -------- To get PK info from the warehouse (bug #1757640) ------
298:
299: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

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

365:
366: l_rows_inserted := sql%rowcount;
367: g_row_count := g_row_count + l_rows_inserted ;
368:
369: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
370: ' rows into the staging table');
371:
372: edw_log.put_line('Completed Push_EDW_GEOG_CITY_LSTG');
373:

Line 372: edw_log.put_line('Completed Push_EDW_GEOG_CITY_LSTG');

368:
369: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
370: ' rows into the staging table');
371:
372: edw_log.put_line('Completed Push_EDW_GEOG_CITY_LSTG');
373:
374: Exception When others then
375: rollback;
376: raise;

Line 386: edw_log.put_line('Starting Push_EDW_GEOG_POSTCODE_LSTG');

382: l_date1 DATE;
383: l_date2 DATE;
384: l_rows_inserted NUMBER :=0;
385: BEGIN
386: edw_log.put_line('Starting Push_EDW_GEOG_POSTCODE_LSTG');
387:
388: -------- To get PK info from the warehouse (bug #1757640) ------
389:
390: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

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

456:
457: l_rows_inserted := sql%rowcount;
458: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
459:
460: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
461: ' rows into the staging table');
462:
463: edw_log.put_line('Completed Push_EDW_GEOG_POSTCODE_LSTG');
464:

Line 463: edw_log.put_line('Completed Push_EDW_GEOG_POSTCODE_LSTG');

459:
460: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
461: ' rows into the staging table');
462:
463: edw_log.put_line('Completed Push_EDW_GEOG_POSTCODE_LSTG');
464:
465: Exception When others then
466: rollback;
467: raise;

Line 478: edw_log.put_line('Starting Push_EDW_GEOG_STATE_REGION_LSTG');

474: l_date2 DATE;
475: l_rows_inserted NUMBER :=0;
476: l_tmp_str VARCHAR2 (120);
477: BEGIN
478: edw_log.put_line('Starting Push_EDW_GEOG_STATE_REGION_LSTG');
479:
480: -------- To get PK info from the warehouse (bug #1757640) ------
481:
482: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

Line 499: edw_log.put_line('Warning : No Look Code Found From GET_LOOKUP_VALUE in Pushing State_Region');

495:
496: l_tmp_str := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
497: 'EDW_GEOGRAPHY_M_SREG');
498: if(l_tmp_str is NULL) THEN
499: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing State_Region');
500: end if;
501:
502: Insert Into
503: EDW_GEOG_STATE_REGION_LSTG(

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

555:
556: l_rows_inserted := sql%rowcount;
557: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
558:
559: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
560: ' rows into the staging table');
561:
562: edw_log.put_line('Completed Push_EDW_GEOG_STATE_REGION_LSTG');
563:

Line 562: edw_log.put_line('Completed Push_EDW_GEOG_STATE_REGION_LSTG');

558:
559: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
560: ' rows into the staging table');
561:
562: edw_log.put_line('Completed Push_EDW_GEOG_STATE_REGION_LSTG');
563:
564: Exception When others then
565: rollback;
566: raise;

Line 576: edw_log.put_line('Starting Push_EDW_GEOG_STATE_LSTG');

572: l_date1 DATE;
573: l_date2 DATE;
574: l_rows_inserted NUMBER :=0;
575: BEGIN
576: edw_log.put_line('Starting Push_EDW_GEOG_STATE_LSTG');
577:
578: -------- To get PK info from the warehouse (bug #1757640) ------
579:
580: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

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

647:
648: l_rows_inserted := sql%rowcount;
649: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
650:
651: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
652: ' rows into the staging table');
653:
654: edw_log.put_line('Completed Push_EDW_GEOG_STATE_LSTG');
655:

Line 654: edw_log.put_line('Completed Push_EDW_GEOG_STATE_LSTG');

650:
651: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
652: ' rows into the staging table');
653:
654: edw_log.put_line('Completed Push_EDW_GEOG_STATE_LSTG');
655:
656: Exception When others then
657: rollback;
658: raise;

Line 669: edw_log.put_line('Starting Push_EDW_GEOG_REGION_LSTG');

665: l_date2 DATE;
666: l_rows_inserted NUMBER :=0;
667: l_tmp_str VARCHAR2 (120);
668: BEGIN
669: edw_log.put_line('Starting Push_EDW_GEOG_REGION_LSTG');
670:
671: -------- To get PK info from the warehouse (bug #1757640) ------
672:
673: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

Line 690: edw_log.put_line('Warning : No Look Code Found From GET_LOOKUP_VALUE in Pushing REGION');

686:
687: l_tmp_str := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
688: 'EDW_GEOGRAPHY_M_REGN');
689: if(l_tmp_str is NULL) THEN
690: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing REGION');
691: end if;
692:
693: Insert Into
694: EDW_GEOG_REGION_LSTG(

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

746:
747: l_rows_inserted := sql%rowcount;
748: g_row_count := g_row_count + l_rows_inserted ;
749:
750: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
751: ' rows into the staging table');
752:
753: edw_log.put_line('Completed Push_EDW_GEOG_REGION_LSTG');
754:

Line 753: edw_log.put_line('Completed Push_EDW_GEOG_REGION_LSTG');

749:
750: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
751: ' rows into the staging table');
752:
753: edw_log.put_line('Completed Push_EDW_GEOG_REGION_LSTG');
754:
755: Exception When others then
756: rollback;
757: raise;

Line 767: edw_log.put_line('Starting Push_EDW_GEOG_COUNTRY_LSTG');

763: l_date1 DATE;
764: l_date2 DATE;
765: l_rows_inserted NUMBER :=0;
766: BEGIN
767: edw_log.put_line('Starting Push_EDW_GEOG_COUNTRY_LSTG');
768:
769: -------- To get PK info from the warehouse (bug #1757640) ------
770:
771: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

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

837:
838: l_rows_inserted := sql%rowcount;
839: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
840:
841: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
842: ' rows into the staging table');
843:
844: edw_log.put_line('Completed Push_EDW_GEOG_COUNTRY_LSTG');
845:

Line 844: edw_log.put_line('Completed Push_EDW_GEOG_COUNTRY_LSTG');

840:
841: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
842: ' rows into the staging table');
843:
844: edw_log.put_line('Completed Push_EDW_GEOG_COUNTRY_LSTG');
845:
846: Exception When others then
847: rollback;
848: raise;

Line 860: edw_log.put_line('Starting Push_EDW_GEOG_AREA2_LSTG');

856: l_rows_inserted NUMBER :=0;
857: l_tmp_str1 VARCHAR2 (120);
858: l_tmp_str2 VARCHAR2 (120);
859: BEGIN
860: edw_log.put_line('Starting Push_EDW_GEOG_AREA2_LSTG');
861:
862: -------- To get PK info from the warehouse (bug #1757640) ------
863:
864: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

Line 882: edw_log.put_line('Warning : No Look Code Found From GET_LOOKUP_VALUE in Pushing AREA2');

878: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
879: 'EDW_GEOGRAPHY_M_ARE2');
880: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN', 'EDW_ALL');
881: if(l_tmp_str1 is NULL or l_tmp_str2 is NULL) THEN
882: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing AREA2');
883: end if;
884:
885: Insert Into
886: EDW_GEOG_AREA2_LSTG(

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

920:
921: l_rows_inserted := sql%rowcount;
922: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
923:
924: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
925: ' rows into the staging table');
926:
927: edw_log.put_line('Completed Push_EDW_GEOG_AREA2_LSTG');
928:

Line 927: edw_log.put_line('Completed Push_EDW_GEOG_AREA2_LSTG');

923:
924: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
925: ' rows into the staging table');
926:
927: edw_log.put_line('Completed Push_EDW_GEOG_AREA2_LSTG');
928:
929: Exception When others then
930: rollback;
931: raise;

Line 943: edw_log.put_line('Starting Push_EDW_GEOG_AREA1_LSTG');

939: l_rows_inserted NUMBER :=0;
940: l_tmp_str1 VARCHAR2 (120);
941: l_tmp_str2 VARCHAR2 (120);
942: BEGIN
943: edw_log.put_line('Starting Push_EDW_GEOG_AREA1_LSTG');
944:
945: -------- To get PK info from the warehouse (bug #1757640) ------
946:
947: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

Line 965: edw_log.put_line('Warning : No Look Code Found From GET_LOOKUP_VALUE in Pushing AREA1');

961: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
962: 'EDW_GEOGRAPHY_M_ARE1');
963: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN', 'EDW_ALL');
964: if(l_tmp_str1 is NULL or l_tmp_str2 is NULL) THEN
965: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing AREA1');
966: end if;
967:
968: Insert Into
969: EDW_GEOG_AREA1_LSTG(

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

1002:
1003: l_rows_inserted := sql%rowcount;
1004: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
1005:
1006: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
1007: ' rows into the staging table');
1008:
1009: edw_log.put_line('Completed Push_EDW_GEOG_AREA1_LSTG');
1010:

Line 1009: edw_log.put_line('Completed Push_EDW_GEOG_AREA1_LSTG');

1005:
1006: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
1007: ' rows into the staging table');
1008:
1009: edw_log.put_line('Completed Push_EDW_GEOG_AREA1_LSTG');
1010:
1011: Exception When others then
1012: rollback;
1013: raise;