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

Line 55: edw_log.put_line(' ');

51: END IF;
52:
53: -- Generates "Warning" message in the Status column
54: -- of Concurrent Manager "Requests" table
55: edw_log.put_line(' ');
56: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) ||
57: ' rows into poa_edw_sup_perf_inc table');
58: END;
59:

Line 56: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) ||

52:
53: -- Generates "Warning" message in the Status column
54: -- of Concurrent Manager "Requests" table
55: edw_log.put_line(' ');
56: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) ||
57: ' rows into poa_edw_sup_perf_inc table');
58: END;
59:
60: -----------------------------------------------------------

Line 110: edw_log.put_line('The best price is calculated for target prices');

106:
107:
108: IF(fnd_profile.value('POA_TARGET_PRICE_TXN') = 'Y') then
109:
110: edw_log.put_line('***The best price is calculated for target prices***');
111:
112: Insert Into POA_EDW_SUP_PERF_FSTG(
113: DUNS_FK,
114: UNSPSC_FK,

Line 312: edw_log.put_line('The target prices are set to NULL');

308: AND seq_id = p_seq_id;
309:
310: ELSE
311:
312: edw_log.put_line('***The target prices are set to NULL***');
313:
314: Insert Into POA_EDW_SUP_PERF_FSTG(
315: DUNS_FK,
316: UNSPSC_FK,

Line 626: edw_log.put_line( 'Updated ' || p_count || ' records');

622: SET seq_id = l_seq_id
623: WHERE seq_id IS NULL;
624:
625: p_count := sql%rowcount;
626: edw_log.put_line( 'Updated ' || p_count || ' records');
627:
628: INSERT
629: into poa_edw_sup_perf_inc(primary_key, seq_id)
630: SELECT pll.line_location_id, l_seq_id

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

738:
739: g_push_to_date := nvl(l_to_date,
740: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
741:
742: edw_log.put_line( 'The collection range is from '||
743: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
744: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
745: edw_log.put_line(' ');
746:

Line 745: edw_log.put_line(' ');

741:
742: edw_log.put_line( 'The collection range is from '||
743: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
744: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
745: edw_log.put_line(' ');
746:
747:
748: -- --------------------------------------------
749: -- Identify Change

Line 751: edw_log.put_line(' ');

747:
748: -- --------------------------------------------
749: -- Identify Change
750: -- --------------------------------------------
751: edw_log.put_line(' ');
752: edw_log.put_line('Identifying changes...');
753: l_seq_id1 := IDENTIFY_CHANGE1(1,l_row_count);
754:
755: if (l_seq_id1 = -1) THEN

Line 752: edw_log.put_line('Identifying changes...');

748: -- --------------------------------------------
749: -- Identify Change
750: -- --------------------------------------------
751: edw_log.put_line(' ');
752: edw_log.put_line('Identifying changes...');
753: l_seq_id1 := IDENTIFY_CHANGE1(1,l_row_count);
754:
755: if (l_seq_id1 = -1) THEN
756: RAISE l_iden_change_failure;

Line 758: edw_log.put_line('Identified '||l_row_count||' changed records');

754:
755: if (l_seq_id1 = -1) THEN
756: RAISE l_iden_change_failure;
757: end if;
758: edw_log.put_line('Identified '||l_row_count||' changed records');
759:
760: -- -------------------------------------------------------------
761: -- Identify line locations for which receipts have been modified
762: -- -------------------------------------------------------------

Line 763: edw_log.put_line('Calling insert_rcpt...');

759:
760: -- -------------------------------------------------------------
761: -- Identify line locations for which receipts have been modified
762: -- -------------------------------------------------------------
763: edw_log.put_line('Calling insert_rcpt...');
764: l_no_rcpt := INSERT_RCPT(l_seq_id1);
765:
766: if (l_no_rcpt = -1) THEN
767: RAISE l_insert_rcpt_failure;

Line 769: edw_log.put_line('Inserted ' || l_no_rcpt || ' records');

765:
766: if (l_no_rcpt = -1) THEN
767: RAISE l_insert_rcpt_failure;
768: end if;
769: edw_log.put_line('Inserted ' || l_no_rcpt || ' records');
770:
771: -- -------------------------------------------
772: -- Delete delicates in the Inc Table
773: -- --------------------------------------------

Line 775: edw_log.put_line('Duplicate records deleted in Inc Table');

771: -- -------------------------------------------
772: -- Delete delicates in the Inc Table
773: -- --------------------------------------------
774: DELETE_DUPLICATES;
775: edw_log.put_line('Duplicate records deleted in Inc Table');
776:
777: -- --------------------------------------------
778: -- Push to local staging table for view type 1
779: -- --------------------------------------------

Line 781: edw_log.put_line(' ');

777: -- --------------------------------------------
778: -- Push to local staging table for view type 1
779: -- --------------------------------------------
780:
781: edw_log.put_line(' ');
782: edw_log.put_line('Inserting into local staging table for view type 1');
783: l_row_count1 := PUSH_TO_LOCAL(1, l_seq_id1);
784:
785: IF (l_row_count1 = -1) THEN RAISE L_push_local_failure; END IF;

Line 782: edw_log.put_line('Inserting into local staging table for view type 1');

778: -- Push to local staging table for view type 1
779: -- --------------------------------------------
780:
781: edw_log.put_line(' ');
782: edw_log.put_line('Inserting into local staging table for view type 1');
783: l_row_count1 := PUSH_TO_LOCAL(1, l_seq_id1);
784:
785: IF (l_row_count1 = -1) THEN RAISE L_push_local_failure; END IF;
786:

Line 787: edw_log.put_line('Inserted '||nvl(l_row_count1,0)||

783: l_row_count1 := PUSH_TO_LOCAL(1, l_seq_id1);
784:
785: IF (l_row_count1 = -1) THEN RAISE L_push_local_failure; END IF;
786:
787: edw_log.put_line('Inserted '||nvl(l_row_count1,0)||
788: ' rows into the local staging table for view type 1');
789: edw_log.put_line(' ');
790:
791: g_row_count := g_row_count + nvl(l_row_count1,0);

Line 789: edw_log.put_line(' ');

785: IF (l_row_count1 = -1) THEN RAISE L_push_local_failure; END IF;
786:
787: edw_log.put_line('Inserted '||nvl(l_row_count1,0)||
788: ' rows into the local staging table for view type 1');
789: edw_log.put_line(' ');
790:
791: g_row_count := g_row_count + nvl(l_row_count1,0);
792:
793: -- --------------------------------------------

Line 819: edw_log.put_line(' ');

815: end loop;
816:
817: close Invalid_Rates;
818:
819: edw_log.put_line(' ');
820: edw_log.put_line('Report created for records with Missing Rates');
821: edw_log.put_line(' ');
822:
823: -- --------------------------------------------

Line 820: edw_log.put_line('Report created for records with Missing Rates');

816:
817: close Invalid_Rates;
818:
819: edw_log.put_line(' ');
820: edw_log.put_line('Report created for records with Missing Rates');
821: edw_log.put_line(' ');
822:
823: -- --------------------------------------------
824: -- Delete records with missing rates from local staging table

Line 821: edw_log.put_line(' ');

817: close Invalid_Rates;
818:
819: edw_log.put_line(' ');
820: edw_log.put_line('Report created for records with Missing Rates');
821: edw_log.put_line(' ');
822:
823: -- --------------------------------------------
824: -- Delete records with missing rates from local staging table
825: -- --------------------------------------------

Line 832: edw_log.put_line(' ');

828: -- --------------------------------------------
829: -- No exception raised so far. Call wrapup to transport
830: -- data to target database, and insert messages into logs
831: -- -----------------------------------------------
832: edw_log.put_line(' ');
833: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
834: ' rows into the staging table');
835: edw_log.put_line(' ');
836:

Line 833: edw_log.put_line('Inserted '||nvl(g_row_count,0)||

829: -- No exception raised so far. Call wrapup to transport
830: -- data to target database, and insert messages into logs
831: -- -----------------------------------------------
832: edw_log.put_line(' ');
833: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
834: ' rows into the staging table');
835: edw_log.put_line(' ');
836:
837: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,

Line 835: edw_log.put_line(' ');

831: -- -----------------------------------------------
832: edw_log.put_line(' ');
833: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
834: ' rows into the staging table');
835: edw_log.put_line(' ');
836:
837: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
838: g_push_from_date, g_push_to_date);
839:

Line 857: edw_log.put_line('Inserting into local staging have failed');

853: end if;
854:
855: l_exception_msg := Retcode || ':' || Errbuf;
856: rollback; -- Rollback insert into local staging
857: edw_log.put_line('Inserting into local staging have failed');
858: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
859: g_push_from_date, g_push_to_date);
860: raise;
861:

Line 872: edw_log.put_line('Identifying changed records have Failed');

868: end if;
869:
870: l_exception_msg := Retcode || ':' || Errbuf;
871: TRUNCATE_INC;
872: edw_log.put_line('Identifying changed records have Failed');
873: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
874: g_push_from_date, g_push_to_date);
875: raise;
876:

Line 887: edw_log.put_line('Insert_rcpt has failed');

883: end if;
884:
885: l_exception_msg := Retcode || ':' || Errbuf;
886: rollback;
887: edw_log.put_line('Insert_rcpt has failed');
888: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
889: g_push_from_date, g_push_to_date);
890: raise;
891:

Line 902: edw_log.put_line('Other errors');

898: end if;
899:
900: l_exception_msg := Retcode || ':' || Errbuf;
901: rollback;
902: edw_log.put_line('Other errors');
903: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
904: g_push_from_date, g_push_to_date);
905: raise;
906: