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

Line 84: edw_log.put_line(' ');

80: g_missing_rates := 1;
81: END IF;
82: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
83:
84: edw_log.put_line(' ');
85: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
86: edw_log.put_line('g_retcode is '||g_retcode);
87: END;
88:

Line 85: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');

81: END IF;
82: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
83:
84: edw_log.put_line(' ');
85: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
86: edw_log.put_line('g_retcode is '||g_retcode);
87: END;
88:
89:

Line 86: edw_log.put_line('g_retcode is '||g_retcode);

82: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
83:
84: edw_log.put_line(' ');
85: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
86: edw_log.put_line('g_retcode is '||g_retcode);
87: END;
88:
89:
90: --------------------------------------------------

Line 588: edw_log.debug_line('');

584:
585: p_count := sql%rowcount;
586:
587: --** Added for iExpense Enhancement,12-DEC-02
588: edw_log.debug_line('');
589: edw_log.debug_line(l_stmt);
590: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
591: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2;
592: --**

Line 589: edw_log.debug_line(l_stmt);

585: p_count := sql%rowcount;
586:
587: --** Added for iExpense Enhancement,12-DEC-02
588: edw_log.debug_line('');
589: edw_log.debug_line(l_stmt);
590: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
591: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2;
592: --**
593:

Line 594: edw_log.put_line( 'NO OF ROWS CHANGED '||

590: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
591: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2;
592: --**
593:
594: edw_log.put_line( 'NO OF ROWS CHANGED '||
595: to_char(p_count));
596:
597:
598: EXCEPTION

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

687: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
688: FII_AP_HOLD_DATA_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
689: l_date1 := g_push_date_range1;
690: l_date2 := g_push_date_range2;
691: edw_log.put_line( 'The collection range is from '||
692: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
693: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
694: edw_log.put_line(' ');
695:

Line 694: edw_log.put_line(' ');

690: l_date2 := g_push_date_range2;
691: edw_log.put_line( 'The collection range is from '||
692: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
693: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
694: edw_log.put_line(' ');
695:
696:
697: --bug#3947925
698: --Check whether missing rates table has data or not. If not then copy missing rates

Line 747: edw_log.put_line(' ');

743: -- --------------------------------------------------------
744: -- 1. Clean up any records left from previous process in
745: -- the local staging table.
746: -- --------------------------------------------------------
747: edw_log.put_line(' ');
748: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
749: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
750: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');
751: ELSE

Line 748: edw_log.put_line('Cleaning up unprocessed records left in local staging table');

744: -- 1. Clean up any records left from previous process in
745: -- the local staging table.
746: -- --------------------------------------------------------
747: edw_log.put_line(' ');
748: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
749: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
750: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');
751: ELSE
752: DELETE_STG;

Line 758: edw_log.put_line(' ');

754:
755: -- --------------------------------------------------------
756: -- 2. Identify Changed AP Holds record and AP Invoices record
757: -- --------------------------------------------------------
758: edw_log.put_line(' ');
759: edw_log.put_line('Identifying changed AP Holds record and AP Invoices record');
760: fii_util.start_timer;
761: IDENTIFY_CHANGE(l_row_count);
762: fii_util.stop_timer;

Line 759: edw_log.put_line('Identifying changed AP Holds record and AP Invoices record');

755: -- --------------------------------------------------------
756: -- 2. Identify Changed AP Holds record and AP Invoices record
757: -- --------------------------------------------------------
758: edw_log.put_line(' ');
759: edw_log.put_line('Identifying changed AP Holds record and AP Invoices record');
760: fii_util.start_timer;
761: IDENTIFY_CHANGE(l_row_count);
762: fii_util.stop_timer;
763: fii_util.print_timer('Identified '||l_row_count||' changed records');

Line 769: edw_log.put_line(' ');

765: -- --------------------------------------------------------
766: -- 3. Pushing data to local staging table
767: -- --------------------------------------------------------
768:
769: edw_log.put_line(' ');
770: edw_log.put_line('Pushing data');
771: fii_util.start_timer;
772: g_row_count := PUSH_TO_LOCAL;
773: fii_util.stop_timer;

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

766: -- 3. Pushing data to local staging table
767: -- --------------------------------------------------------
768:
769: edw_log.put_line(' ');
770: edw_log.put_line('Pushing data');
771: fii_util.start_timer;
772: g_row_count := PUSH_TO_LOCAL;
773: fii_util.stop_timer;
774: fii_util.print_timer('Process Time');

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

776: IF (g_row_count = -1) THEN
777: RAISE L_push_local_failure;
778: END IF;
779:
780: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
781: ' rows into the local staging table');
782: edw_log.put_line(' ');
783:
784: -- --------------------------------------------------------

Line 782: edw_log.put_line(' ');

778: END IF;
779:
780: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
781: ' rows into the local staging table');
782: edw_log.put_line(' ');
783:
784: -- --------------------------------------------------------
785: -- 4. Delete all temp table records
786: -- --------------------------------------------------------

Line 790: edw_log.put_line('Number of rows in tmp_pk after truncating or deleting '||rows );

786: -- --------------------------------------------------------
787:
788: TRUNCATE_TABLE('fii_ap_tmp_hold_pk');
789: select count(*) into rows from FII_AP_TMP_HOLD_PK;
790: edw_log.put_line('Number of rows in tmp_pk after truncating or deleting '||rows );
791:
792: -- ------------------------------------------------------------------------------------------------
793: -- 4A. Insert missing rates from local fstg into tmp_pk table printing data to file
794: -- ------------------------------------------------------------------------------------------------

Line 900: edw_log.put_line(' ');

896: -- We move data from local to remote staging table
897: -- and clean up local staging
898: -- -----------------------------------------------
899:
900: edw_log.put_line(' ');
901: edw_log.put_line('Moving data from local staging table to remote staging table');
902: fii_util.start_timer;
903: g_row_count := PUSH_REMOTE;
904: fii_util.stop_timer;

Line 901: edw_log.put_line('Moving data from local staging table to remote staging table');

897: -- and clean up local staging
898: -- -----------------------------------------------
899:
900: edw_log.put_line(' ');
901: edw_log.put_line('Moving data from local staging table to remote staging table');
902: fii_util.start_timer;
903: g_row_count := PUSH_REMOTE;
904: fii_util.stop_timer;
905: fii_util.print_timer('Duration');

Line 909: edw_log.put_line(' ');

905: fii_util.print_timer('Duration');
906:
907: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
908:
909: edw_log.put_line(' ');
910: edw_log.put_line('Cleaning local staging table');
911:
912: fii_util.start_timer;
913: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');

Line 910: edw_log.put_line('Cleaning local staging table');

906:
907: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
908:
909: edw_log.put_line(' ');
910: edw_log.put_line('Cleaning local staging table');
911:
912: fii_util.start_timer;
913: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');
914: fii_util.stop_timer;

Line 924: edw_log.put_line(' ');

920: -- as the source OLTP. We set the status of all our
921: -- records status 'LOCAL READY' to 'READY'
922: -- -----------------------------------------------
923:
924: edw_log.put_line(' ');
925: edw_log.put_line('Marking records in staging table with READY status');
926:
927: fii_util.start_timer;
928: g_row_count := SET_STATUS_READY;

Line 925: edw_log.put_line('Marking records in staging table with READY status');

921: -- records status 'LOCAL READY' to 'READY'
922: -- -----------------------------------------------
923:
924: edw_log.put_line(' ');
925: edw_log.put_line('Marking records in staging table with READY status');
926:
927: fii_util.start_timer;
928: g_row_count := SET_STATUS_READY;
929: fii_util.stop_timer;

Line 955: edw_log.put_line(' ');

951: -- -----------------------------------------------
952: -- Successful. Commit and call
953: -- wrapup to commit and insert messages into logs
954: -- -----------------------------------------------
955: edw_log.put_line(' ');
956: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
957: ' rows into the staging table');
958: edw_log.put_line(' ');
959:

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

952: -- Successful. Commit and call
953: -- wrapup to commit and insert messages into logs
954: -- -----------------------------------------------
955: edw_log.put_line(' ');
956: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
957: ' rows into the staging table');
958: edw_log.put_line(' ');
959:
960: -- COMMIT;

Line 958: edw_log.put_line(' ');

954: -- -----------------------------------------------
955: edw_log.put_line(' ');
956: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
957: ' rows into the staging table');
958: edw_log.put_line(' ');
959:
960: -- COMMIT;
961: edw_log.put_line(' ');
962: edw_log.put_line('Inserted '||nvl(g_row_count,0)||

Line 961: edw_log.put_line(' ');

957: ' rows into the staging table');
958: edw_log.put_line(' ');
959:
960: -- COMMIT;
961: edw_log.put_line(' ');
962: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
963: ' rows into the staging table');
964: edw_log.put_line(' ');
965: Retcode := g_retcode;

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

958: edw_log.put_line(' ');
959:
960: -- COMMIT;
961: edw_log.put_line(' ');
962: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
963: ' rows into the staging table');
964: edw_log.put_line(' ');
965: Retcode := g_retcode;
966: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);

Line 964: edw_log.put_line(' ');

960: -- COMMIT;
961: edw_log.put_line(' ');
962: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
963: ' rows into the staging table');
964: edw_log.put_line(' ');
965: Retcode := g_retcode;
966: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
967: if (g_missing_rates >0) then
968: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');

Line 968: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');

964: edw_log.put_line(' ');
965: Retcode := g_retcode;
966: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
967: if (g_missing_rates >0) then
968: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
969: end if;
970: commit;
971: --bug#3947925
972: --Program is on the verge of completing successfully,so clean up

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

982: WHEN L_IDEN_CHANGE_FAILURE THEN
983: Errbuf:=g_errbuf;
984: Retcode:=g_retcode;
985: l_exception_msg := Retcode || ':' || Errbuf;
986: edw_log.put_line('Identifying changed records have Failed');
987: rollback;
988: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
989: /* Set the completion status to error. bug#3207823 */
990: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

992: WHEN L_PUSH_LOCAL_FAILURE THEN
993: Errbuf:=g_errbuf;
994: Retcode:=g_retcode;
995: l_exception_msg := Retcode || ':' || Errbuf;
996: edw_log.put_line('Inserting into local staging have failed');
997: rollback;
998: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
999: /* Set the completion status to error. bug#3207823 */
1000: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

Line 1006: edw_log.put_line('Data migration from local to remote staging have failed');

1002: WHEN L_PUSH_REMOTE_FAILURE THEN
1003: Errbuf:=g_errbuf;
1004: Retcode:=g_retcode;
1005: l_exception_msg := Retcode || ':' || Errbuf;
1006: edw_log.put_line('Data migration from local to remote staging have failed');
1007: rollback;
1008: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1009: /* Set the completion status to error. bug#3207823 */
1010: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

Line 1016: edw_log.put_line('Setting status to READY have failed');

1012: WHEN L_SET_STATUS_FAILURE THEN
1013: Errbuf:=g_errbuf;
1014: Retcode:=g_retcode;
1015: l_exception_msg := Retcode || ':' || Errbuf;
1016: edw_log.put_line('Setting status to READY have failed');
1017: rollback;
1018: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1019: raise;
1020: WHEN OTHERS THEN