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

Line 42: edw_log.put_line(' ');

38: IF (NOT FND_INSTALLATION.GET_APP_INFO('PO', g_status, g_industry, g_schema)) THEN
39: RAISE_APPLICATION_ERROR (-20001, '***There is not POA schema set up***');
40: END IF;
41:
42: edw_log.put_line(' ');
43: edw_log.put_line('Truncating Vendor Hierarchies table...');
44:
45: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.EDW_PO_VENDOR_HIERARCHIES';
46: EXECUTE IMMEDIATE g_stmt;

Line 43: edw_log.put_line('Truncating Vendor Hierarchies table...');

39: RAISE_APPLICATION_ERROR (-20001, '***There is not POA schema set up***');
40: END IF;
41:
42: edw_log.put_line(' ');
43: edw_log.put_line('Truncating Vendor Hierarchies table...');
44:
45: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.EDW_PO_VENDOR_HIERARCHIES';
46: EXECUTE IMMEDIATE g_stmt;
47:

Line 48: edw_log.put_line(' ');

44:
45: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.EDW_PO_VENDOR_HIERARCHIES';
46: EXECUTE IMMEDIATE g_stmt;
47:
48: edw_log.put_line(' ');
49: edw_log.put_line('Populating Vendor Hierachies table...');
50:
51: l_temp_date := sysdate;
52:

Line 49: edw_log.put_line('Populating Vendor Hierachies table...');

45: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.EDW_PO_VENDOR_HIERARCHIES';
46: EXECUTE IMMEDIATE g_stmt;
47:
48: edw_log.put_line(' ');
49: edw_log.put_line('Populating Vendor Hierachies table...');
50:
51: l_temp_date := sysdate;
52:
53: Insert Into EDW_PO_VENDOR_HIERARCHIES (

Line 74: edw_log.put_line('Inserted ' || to_char(nvl(l_rows_inserted, 0))||

70:
71: l_rows_inserted := sql%rowcount;
72: l_duration := sysdate - l_temp_date;
73:
74: edw_log.put_line('Inserted ' || to_char(nvl(l_rows_inserted, 0))||
75: ' rows into the HIERARCHY table: EDW_PO_VENDOR_HIERARCHIES');
76: edw_log.put_line('Process Time: ' || edw_log.duration(l_duration));
77: edw_log.put_line(' ');
78:

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

72: l_duration := sysdate - l_temp_date;
73:
74: edw_log.put_line('Inserted ' || to_char(nvl(l_rows_inserted, 0))||
75: ' rows into the HIERARCHY table: EDW_PO_VENDOR_HIERARCHIES');
76: edw_log.put_line('Process Time: ' || edw_log.duration(l_duration));
77: edw_log.put_line(' ');
78:
79: Exception When others then
80: Errbuf := sqlerrm;

Line 77: edw_log.put_line(' ');

73:
74: edw_log.put_line('Inserted ' || to_char(nvl(l_rows_inserted, 0))||
75: ' rows into the HIERARCHY table: EDW_PO_VENDOR_HIERARCHIES');
76: edw_log.put_line('Process Time: ' || edw_log.duration(l_duration));
77: edw_log.put_line(' ');
78:
79: Exception When others then
80: Errbuf := sqlerrm;
81: Retcode := sqlcode;

Line 200: edw_log.put_line('***Exceptions in update_hierarchy5 : ' ||

196: END IF;
197:
198: EXCEPTION
199: when others then
200: edw_log.put_line('***Exceptions in update_hierarchy5 : ' ||
201: sqlerrm || ' ***');
202: return;
203: END update_hierarchy5;
204:

Line 240: edw_log.put_line(' ');

236:
237: -- -----------------------------------------------------------------------------
238: -- Start of Collection , Developer Customizable Section
239: -- -----------------------------------------------------------------------------
240: edw_log.put_line(' ');
241: edw_log.put_line('Pushing data for TP Location Staging Table...');
242:
243: l_temp_date := sysdate;
244:

Line 241: edw_log.put_line('Pushing data for TP Location Staging Table...');

237: -- -----------------------------------------------------------------------------
238: -- Start of Collection , Developer Customizable Section
239: -- -----------------------------------------------------------------------------
240: edw_log.put_line(' ');
241: edw_log.put_line('Pushing data for TP Location Staging Table...');
242:
243: l_temp_date := sysdate;
244:
245: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',

Line 249: edw_log.put_line('Warning : No Look Code Found From GET_LEVEL_DP in Pushing TP Location');

245: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
246: 'EDW_TRD_PARTNER_M_TPLO');
247:
248: if (l_tmp_str1 IS NULL) THEN
249: edw_log.put_line('***Warning*** : No Look Code Found From GET_LEVEL_DP in Pushing TP Location');
250: end if;
251:
252: Insert Into EDW_TPRT_TPARTNER_LOC_LSTG(
253: TPARTNER_LOC_PK,

Line 372: edw_log.put_line('Inserted ' || to_char(nvl(l_rows_inserted, 0))||

368:
369: l_rows_inserted := sql%rowcount;
370: l_duration := sysdate - l_temp_date;
371:
372: edw_log.put_line('Inserted ' || to_char(nvl(l_rows_inserted, 0))||
373: ' rows into the staging table: ' || l_staging_table_name);
374: edw_log.put_line('Process Time: ' || edw_log.duration(l_duration));
375: edw_log.put_line(' ');
376:

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

370: l_duration := sysdate - l_temp_date;
371:
372: edw_log.put_line('Inserted ' || to_char(nvl(l_rows_inserted, 0))||
373: ' rows into the staging table: ' || l_staging_table_name);
374: edw_log.put_line('Process Time: ' || edw_log.duration(l_duration));
375: edw_log.put_line(' ');
376:
377: -- ---------------------------------------------------------------------------
378: -- END OF Collection , Developer Customizable Section

Line 375: edw_log.put_line(' ');

371:
372: edw_log.put_line('Inserted ' || to_char(nvl(l_rows_inserted, 0))||
373: ' rows into the staging table: ' || l_staging_table_name);
374: edw_log.put_line('Process Time: ' || edw_log.duration(l_duration));
375: edw_log.put_line(' ');
376:
377: -- ---------------------------------------------------------------------------
378: -- END OF Collection , Developer Customizable Section
379: -- ---------------------------------------------------------------------------

Line 423: edw_log.put_line(' ');

419:
420: -- -----------------------------------------------------------------------------
421: -- Start of Collection , Developer Customizable Section
422: -- -----------------------------------------------------------------------------
423: edw_log.put_line(' ');
424: edw_log.put_line('Pushing data for Trading Partner Staging Table...');
425:
426: l_push_date_range1 := p_from_date;
427: l_push_date_range2 := p_to_date;

Line 424: edw_log.put_line('Pushing data for Trading Partner Staging Table...');

420: -- -----------------------------------------------------------------------------
421: -- Start of Collection , Developer Customizable Section
422: -- -----------------------------------------------------------------------------
423: edw_log.put_line(' ');
424: edw_log.put_line('Pushing data for Trading Partner Staging Table...');
425:
426: l_push_date_range1 := p_from_date;
427: l_push_date_range2 := p_to_date;
428:

Line 575: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||

571:
572: l_rows_inserted := sql%rowcount;
573: l_duration := sysdate - l_temp_date;
574:
575: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
576: ' rows into the staging table: ' || l_staging_table_name);
577: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
578: edw_log.put_line(' ');
579:

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

573: l_duration := sysdate - l_temp_date;
574:
575: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
576: ' rows into the staging table: ' || l_staging_table_name);
577: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
578: edw_log.put_line(' ');
579:
580: -- ---------------------------------------------------------------------------
581: -- END OF Collection , Developer Customizable Section

Line 578: edw_log.put_line(' ');

574:
575: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
576: ' rows into the staging table: ' || l_staging_table_name);
577: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
578: edw_log.put_line(' ');
579:
580: -- ---------------------------------------------------------------------------
581: -- END OF Collection , Developer Customizable Section
582: -- ---------------------------------------------------------------------------

Line 624: edw_log.put_line(' ');

620:
621: l_push_date_range1 := p_from_date;
622: l_push_date_range2 := p_to_date;
623:
624: edw_log.put_line(' ');
625: edw_log.put_line('Pushing data for TP Parent 1 Staging Table...');
626:
627: l_temp_date := sysdate;
628: Insert Into EDW_TPRT_P1_TPARTNER_LSTG(

Line 625: edw_log.put_line('Pushing data for TP Parent 1 Staging Table...');

621: l_push_date_range1 := p_from_date;
622: l_push_date_range2 := p_to_date;
623:
624: edw_log.put_line(' ');
625: edw_log.put_line('Pushing data for TP Parent 1 Staging Table...');
626:
627: l_temp_date := sysdate;
628: Insert Into EDW_TPRT_P1_TPARTNER_LSTG(
629: ALLOW_SUB_RECEIPT,

Line 698: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||

694:
695: l_rows_inserted := sql%rowcount;
696: l_duration := sysdate - l_temp_date;
697:
698: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
699: ' rows into the staging table: ' || l_staging_table_name);
700: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
701: edw_log.put_line(' ');
702:

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

696: l_duration := sysdate - l_temp_date;
697:
698: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
699: ' rows into the staging table: ' || l_staging_table_name);
700: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
701: edw_log.put_line(' ');
702:
703: -- ---------------------------------------------------------------------------
704: -- END OF Collection , Developer Customizable Section

Line 701: edw_log.put_line(' ');

697:
698: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
699: ' rows into the staging table: ' || l_staging_table_name);
700: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
701: edw_log.put_line(' ');
702:
703: -- ---------------------------------------------------------------------------
704: -- END OF Collection , Developer Customizable Section
705: -- ---------------------------------------------------------------------------

Line 745: edw_log.put_line(' ');

741:
742: -- -----------------------------------------------------------------------------
743: -- Start of Collection , Developer Customizable Section
744: -- -----------------------------------------------------------------------------
745: edw_log.put_line(' ');
746: edw_log.put_line('Pushing data for TP Parent 2 Staging Table...');
747:
748: l_temp_date := sysdate;
749: Insert Into EDW_TPRT_P2_TPARTNER_LSTG(

Line 746: edw_log.put_line('Pushing data for TP Parent 2 Staging Table...');

742: -- -----------------------------------------------------------------------------
743: -- Start of Collection , Developer Customizable Section
744: -- -----------------------------------------------------------------------------
745: edw_log.put_line(' ');
746: edw_log.put_line('Pushing data for TP Parent 2 Staging Table...');
747:
748: l_temp_date := sysdate;
749: Insert Into EDW_TPRT_P2_TPARTNER_LSTG(
750: ALLOW_SUB_RECEIPT,

Line 819: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||

815:
816: l_rows_inserted := sql%rowcount;
817: l_duration := sysdate - l_temp_date;
818:
819: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
820: ' rows into the staging table: ' || l_staging_table_name);
821: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
822: edw_log.put_line(' ');
823:

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

817: l_duration := sysdate - l_temp_date;
818:
819: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
820: ' rows into the staging table: ' || l_staging_table_name);
821: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
822: edw_log.put_line(' ');
823:
824: -- ---------------------------------------------------------------------------
825: -- END OF Collection , Developer Customizable Section

Line 822: edw_log.put_line(' ');

818:
819: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
820: ' rows into the staging table: ' || l_staging_table_name);
821: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
822: edw_log.put_line(' ');
823:
824: -- ---------------------------------------------------------------------------
825: -- END OF Collection , Developer Customizable Section
826: -- ---------------------------------------------------------------------------

Line 866: edw_log.put_line(' ');

862:
863: -- -----------------------------------------------------------------------------
864: -- Start of Collection , Developer Customizable Section
865: -- -----------------------------------------------------------------------------
866: edw_log.put_line(' ');
867: edw_log.put_line('Pushing data for TP Parent 3 Staging Table...');
868:
869: l_temp_date := sysdate;
870: Insert Into EDW_TPRT_P3_TPARTNER_LSTG(

Line 867: edw_log.put_line('Pushing data for TP Parent 3 Staging Table...');

863: -- -----------------------------------------------------------------------------
864: -- Start of Collection , Developer Customizable Section
865: -- -----------------------------------------------------------------------------
866: edw_log.put_line(' ');
867: edw_log.put_line('Pushing data for TP Parent 3 Staging Table...');
868:
869: l_temp_date := sysdate;
870: Insert Into EDW_TPRT_P3_TPARTNER_LSTG(
871: ALLOW_SUB_RECEIPT,

Line 941: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted, 0))||

937:
938: l_rows_inserted := sql%rowcount;
939: l_duration := sysdate - l_temp_date;
940:
941: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted, 0))||
942: ' rows into the staging table: ' || l_staging_table_name);
943: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
944: edw_log.put_line(' ');
945:

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

939: l_duration := sysdate - l_temp_date;
940:
941: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted, 0))||
942: ' rows into the staging table: ' || l_staging_table_name);
943: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
944: edw_log.put_line(' ');
945:
946: -- ---------------------------------------------------------------------------
947: -- END OF Collection , Developer Customizable Section

Line 944: edw_log.put_line(' ');

940:
941: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted, 0))||
942: ' rows into the staging table: ' || l_staging_table_name);
943: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
944: edw_log.put_line(' ');
945:
946: -- ---------------------------------------------------------------------------
947: -- END OF Collection , Developer Customizable Section
948: -- ---------------------------------------------------------------------------

Line 988: edw_log.put_line(' ');

984:
985: -- -----------------------------------------------------------------------------
986: -- Start of Collection , Developer Customizable Section
987: -- -----------------------------------------------------------------------------
988: edw_log.put_line(' ');
989: edw_log.put_line('Pushing data for TP Parent 4 Staging Table...');
990:
991: l_temp_date := sysdate;
992: Insert Into EDW_TPRT_P4_TPARTNER_LSTG(

Line 989: edw_log.put_line('Pushing data for TP Parent 4 Staging Table...');

985: -- -----------------------------------------------------------------------------
986: -- Start of Collection , Developer Customizable Section
987: -- -----------------------------------------------------------------------------
988: edw_log.put_line(' ');
989: edw_log.put_line('Pushing data for TP Parent 4 Staging Table...');
990:
991: l_temp_date := sysdate;
992: Insert Into EDW_TPRT_P4_TPARTNER_LSTG(
993: ALLOW_SUB_RECEIPT,

Line 1062: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||

1058:
1059: l_rows_inserted := sql%rowcount;
1060: l_duration := sysdate - l_temp_date;
1061:
1062: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
1063: ' rows into the staging table: ' || l_staging_table_name);
1064: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
1065: edw_log.put_line(' ');
1066:

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

1060: l_duration := sysdate - l_temp_date;
1061:
1062: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
1063: ' rows into the staging table: ' || l_staging_table_name);
1064: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
1065: edw_log.put_line(' ');
1066:
1067: -- ---------------------------------------------------------------------------
1068: -- END OF Collection , Developer Customizable Section

Line 1065: edw_log.put_line(' ');

1061:
1062: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
1063: ' rows into the staging table: ' || l_staging_table_name);
1064: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
1065: edw_log.put_line(' ');
1066:
1067: -- ---------------------------------------------------------------------------
1068: -- END OF Collection , Developer Customizable Section
1069: -- ---------------------------------------------------------------------------

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

1107:
1108: L_PUSH_DATE_RANGE1 := nvl (l_from_date,
1109: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1110: L_PUSH_DATE_RANGE2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1111: edw_log.put_line('The collection range is from ' ||
1112: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to ' ||
1113: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
1114: edw_log.put_line(' ');
1115:

Line 1114: edw_log.put_line(' ');

1110: L_PUSH_DATE_RANGE2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1111: edw_log.put_line('The collection range is from ' ||
1112: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to ' ||
1113: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
1114: edw_log.put_line(' ');
1115:
1116:
1117: l_proc_name := 'EDW_TRD_PARTNER_M_C.populate_hierarchies';
1118: EDW_TRD_PARTNER_M_C.populate_hierarchies(L_PUSH_DATE_RANGE1,L_PUSH_DATE_RANGE2);