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

Line 30: edw_log.put_line(' ');

26: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
27: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.'||table_name;
28: EXECUTE IMMEDIATE l_stmt;
29: END IF;
30: edw_log.put_line(' ');
31: edw_log.put_line('Truncating '|| table_name||' table');
32:
33:
34: END;

Line 31: edw_log.put_line('Truncating '|| table_name||' table');

27: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.'||table_name;
28: EXECUTE IMMEDIATE l_stmt;
29: END IF;
30: edw_log.put_line(' ');
31: edw_log.put_line('Truncating '|| table_name||' table');
32:
33:
34: END;
35:

Line 96: edw_log.put_line(' ');

92: g_missing_rates := 1;
93: END IF;
94: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
95:
96: edw_log.put_line(' ');
97: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
98: edw_log.put_line('g_retcode is '||g_retcode);
99: END;
100:

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

93: END IF;
94: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
95:
96: edw_log.put_line(' ');
97: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
98: edw_log.put_line('g_retcode is '||g_retcode);
99: END;
100:
101:

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

94: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
95:
96: edw_log.put_line(' ');
97: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
98: edw_log.put_line('g_retcode is '||g_retcode);
99: END;
100:
101:
102: --------------------------------------------------

Line 466: edw_log.put_line('g_row_count');

462: RCV_TRANSACTION_ID -- Added for bug#3116554
463: from FII_AP_INV_LINES_FCV;
464:
465: fii_flex_mapping.free_mem_all;
466: edw_log.put_line('g_row_count');
467: edw_log.put_line(TO_CHAR(sql%rowcount));
468: RETURN(sql%rowcount);
469:
470: EXCEPTION

Line 467: edw_log.put_line(TO_CHAR(sql%rowcount));

463: from FII_AP_INV_LINES_FCV;
464:
465: fii_flex_mapping.free_mem_all;
466: edw_log.put_line('g_row_count');
467: edw_log.put_line(TO_CHAR(sql%rowcount));
468: RETURN(sql%rowcount);
469:
470: EXCEPTION
471: WHEN OTHERS THEN

Line 474: edw_log.put_line('inside exception of local push');

470: EXCEPTION
471: WHEN OTHERS THEN
472: g_errbuf:=sqlerrm;
473: g_retcode:=sqlcode;
474: edw_log.put_line('inside exception of local push');
475: rollback;
476: RETURN(-1);
477:
478: END;

Line 505: edw_log.put_line('Updating credit amount information in local staging table');

501: l_industry VARCHAR2(30);
502:
503: BEGIN
504:
505: edw_log.put_line('Updating credit amount information in local staging table');
506: edw_log.put_line('');
507:
508: -- get minimum accountable unit of the warehouse currency;
509:

Line 506: edw_log.put_line('');

502:
503: BEGIN
504:
505: edw_log.put_line('Updating credit amount information in local staging table');
506: edw_log.put_line('');
507:
508: -- get minimum accountable unit of the warehouse currency;
509:
510: l_mau := nvl( edw_currency.get_mau, 0.01);

Line 543: edw_log.put_line ('Process Time for Insert into TMP: '||edw_log.duration(l_duration));

539: from fii_ap_inv_lines_fstg fstg
540: where fstg.collection_status = 'LOCAL READY';
541:
542: l_duration := sysdate - l_temp_date;
543: edw_log.put_line ('Process Time for Insert into TMP: '||edw_log.duration(l_duration));
544:
545: -- populate Discount Amounts into fii_ap_tmp_line_pk
546:
547: l_temp_date := sysdate;

Line 606: edw_log.put_line ('Process Time for Insert into TMP w/ Discount: ' ||

602: AND xah.ledger_id = apk.primary_key4
603: group by apk.primary_key_char1;
604:
605: l_duration := sysdate - l_temp_date;
606: edw_log.put_line ('Process Time for Insert into TMP w/ Discount: ' ||
607: edw_log.duration(l_duration));
608:
609: -- update fii_ap_inv_lines_fstg from fii_ap_tmp_line_pk
610:

Line 607: edw_log.duration(l_duration));

603: group by apk.primary_key_char1;
604:
605: l_duration := sysdate - l_temp_date;
606: edw_log.put_line ('Process Time for Insert into TMP w/ Discount: ' ||
607: edw_log.duration(l_duration));
608:
609: -- update fii_ap_inv_lines_fstg from fii_ap_tmp_line_pk
610:
611: l_temp_date := sysdate;

Line 633: edw_log.put_line ('Process Time for Update: ' || edw_log.duration(l_duration));

629: set DISCOUNT_AMT_G = 0
630: where DISCOUNT_AMT_B = 0;
631:
632: l_duration := sysdate - l_temp_date;
633: edw_log.put_line ('Process Time for Update: ' || edw_log.duration(l_duration));
634: edw_log.put_line ('# of Updated Records: ' || l_count);
635:
636: -- fii_util.stop_timer;
637: -- fii_util.print_timer('Duration');

Line 634: edw_log.put_line ('# of Updated Records: ' || l_count);

630: where DISCOUNT_AMT_B = 0;
631:
632: l_duration := sysdate - l_temp_date;
633: edw_log.put_line ('Process Time for Update: ' || edw_log.duration(l_duration));
634: edw_log.put_line ('# of Updated Records: ' || l_count);
635:
636: -- fii_util.stop_timer;
637: -- fii_util.print_timer('Duration');
638:

Line 1070: edw_log.debug_line('');

1066:
1067:
1068:
1069: --** Added for iExpense Enhancement,12-DEC-02
1070: edw_log.debug_line('');
1071: edw_log.debug_line(l_stmt);
1072: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
1073: g_push_date_range1,g_push_date_range2,
1074: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,

Line 1071: edw_log.debug_line(l_stmt);

1067:
1068:
1069: --** Added for iExpense Enhancement,12-DEC-02
1070: edw_log.debug_line('');
1071: edw_log.debug_line(l_stmt);
1072: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
1073: g_push_date_range1,g_push_date_range2,
1074: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
1075: g_push_date_range1,g_push_date_range2,

Line 1083: edw_log.debug_line( 'NO OF ROWS CHANGED '||

1079:
1080: p_count := sql%rowcount;
1081:
1082:
1083: edw_log.debug_line( 'NO OF ROWS CHANGED '||
1084: to_char(p_count));
1085:
1086: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
1087: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_fii_schema,

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

1257: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1258: FII_AP_INV_LINES_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1259: l_date1 := g_push_date_range1;
1260: l_date2 := g_push_date_range2;
1261: edw_log.put_line( 'The collection range is from '||
1262: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
1263: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
1264: edw_log.put_line(' ');
1265:

Line 1264: edw_log.put_line(' ');

1260: l_date2 := g_push_date_range2;
1261: edw_log.put_line( 'The collection range is from '||
1262: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
1263: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
1264: edw_log.put_line(' ');
1265:
1266:
1267: --bug#3818907
1268: --Check whether missing rates table has data or not. If not then copy missing rates

Line 1321: edw_log.put_line(' ');

1317: -- --------------------------------------------------------
1318: -- 1. Clean up any records left from previous process in
1319: -- the local staging table.
1320: -- --------------------------------------------------------
1321: edw_log.put_line(' ');
1322: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
1323: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
1324: TRUNCATE_TABLE('FII_AP_INV_LINES_FSTG');
1325: ELSE

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

1318: -- 1. Clean up any records left from previous process in
1319: -- the local staging table.
1320: -- --------------------------------------------------------
1321: edw_log.put_line(' ');
1322: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
1323: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
1324: TRUNCATE_TABLE('FII_AP_INV_LINES_FSTG');
1325: ELSE
1326: DELETE_STG;

Line 1333: edw_log.put_line(' ');

1329:
1330: -- --------------------------------------------------------
1331: -- 2. Identify Changed AP Invoice Lines record
1332: -- --------------------------------------------------------
1333: edw_log.put_line(' ');
1334: edw_log.put_line('Identifying changed AP Invoice Lines record');
1335: fii_util.start_timer;
1336: IDENTIFY_CHANGE(l_row_count);
1337: fii_util.stop_timer;

Line 1334: edw_log.put_line('Identifying changed AP Invoice Lines record');

1330: -- --------------------------------------------------------
1331: -- 2. Identify Changed AP Invoice Lines record
1332: -- --------------------------------------------------------
1333: edw_log.put_line(' ');
1334: edw_log.put_line('Identifying changed AP Invoice Lines record');
1335: fii_util.start_timer;
1336: IDENTIFY_CHANGE(l_row_count);
1337: fii_util.stop_timer;
1338: fii_util.print_timer('Identified '||l_row_count||' changed records');

Line 1344: edw_log.put_line(' ');

1340: -- --------------------------------------------------------
1341: -- 3. Pushing data to local staging table
1342: -- --------------------------------------------------------
1343:
1344: edw_log.put_line(' ');
1345: edw_log.put_line('Pushing data');
1346: fii_util.start_timer;
1347: g_row_count := PUSH_TO_LOCAL;
1348: fii_util.stop_timer;

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

1341: -- 3. Pushing data to local staging table
1342: -- --------------------------------------------------------
1343:
1344: edw_log.put_line(' ');
1345: edw_log.put_line('Pushing data');
1346: fii_util.start_timer;
1347: g_row_count := PUSH_TO_LOCAL;
1348: fii_util.stop_timer;
1349: fii_util.print_timer('Process Time');

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

1351: IF (g_row_count = -1) THEN
1352: RAISE L_push_local_failure;
1353: END IF;
1354:
1355: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1356: ' rows into the local staging table');
1357: edw_log.put_line(' ');
1358:
1359: -- --------------------------------------------------------

Line 1357: edw_log.put_line(' ');

1353: END IF;
1354:
1355: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1356: ' rows into the local staging table');
1357: edw_log.put_line(' ');
1358:
1359: -- --------------------------------------------------------
1360: -- 3.5 Populating the discount_amt_t, discount_amt_b,
1361: -- discount_amt_g columns in the local staging table

Line 1365: edw_log.put_line(' ');

1361: -- discount_amt_g columns in the local staging table
1362: -- add this procedure call for merill lynch, nov/12/2002
1363: -- --------------------------------------------------------
1364:
1365: edw_log.put_line(' ');
1366: edw_log.put_line('Populate discount_amt columns');
1367: fii_util.start_timer;
1368:
1369: UPDATE_DIST_CCID; -- added for SLA-AP Uptake

Line 1366: edw_log.put_line('Populate discount_amt columns');

1362: -- add this procedure call for merill lynch, nov/12/2002
1363: -- --------------------------------------------------------
1364:
1365: edw_log.put_line(' ');
1366: edw_log.put_line('Populate discount_amt columns');
1367: fii_util.start_timer;
1368:
1369: UPDATE_DIST_CCID; -- added for SLA-AP Uptake
1370:

Line 1486: edw_log.put_line(' ');

1482: -- We move data from local to remote staging table
1483: -- and clean up local staging
1484: -- -----------------------------------------------
1485:
1486: edw_log.put_line(' ');
1487: edw_log.put_line('Moving data from local staging table to remote staging table');
1488: fii_util.start_timer;
1489: g_row_count := PUSH_REMOTE;
1490: fii_util.stop_timer;

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

1483: -- and clean up local staging
1484: -- -----------------------------------------------
1485:
1486: edw_log.put_line(' ');
1487: edw_log.put_line('Moving data from local staging table to remote staging table');
1488: fii_util.start_timer;
1489: g_row_count := PUSH_REMOTE;
1490: fii_util.stop_timer;
1491: fii_util.print_timer('Duration');

Line 1495: edw_log.put_line(' ');

1491: fii_util.print_timer('Duration');
1492:
1493: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1494:
1495: edw_log.put_line(' ');
1496: edw_log.put_line('Cleaning local staging table');
1497:
1498: fii_util.start_timer;
1499: TRUNCATE_table('FII_AP_INV_LINES_FSTG');

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

1492:
1493: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1494:
1495: edw_log.put_line(' ');
1496: edw_log.put_line('Cleaning local staging table');
1497:
1498: fii_util.start_timer;
1499: TRUNCATE_table('FII_AP_INV_LINES_FSTG');
1500: fii_util.stop_timer;

Line 1510: edw_log.put_line(' ');

1506: -- as the source OLTP. We set the status of all our
1507: -- records status 'LOCAL READY' to 'READY'
1508: -- -----------------------------------------------
1509:
1510: edw_log.put_line(' ');
1511: edw_log.put_line('Marking records in staging table with READY status');
1512:
1513: fii_util.start_timer;
1514: g_row_count := SET_STATUS_READY;

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

1507: -- records status 'LOCAL READY' to 'READY'
1508: -- -----------------------------------------------
1509:
1510: edw_log.put_line(' ');
1511: edw_log.put_line('Marking records in staging table with READY status');
1512:
1513: fii_util.start_timer;
1514: g_row_count := SET_STATUS_READY;
1515: fii_util.stop_timer;

Line 1543: edw_log.put_line(' ');

1539: -- -----------------------------------------------
1540: -- Successful. Commit and call
1541: -- wrapup to commit and insert messages into logs
1542: -- -----------------------------------------------
1543: edw_log.put_line(' ');
1544: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1545: ' rows into the staging table');
1546: edw_log.put_line(' ');
1547: -- COMMIT;

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

1540: -- Successful. Commit and call
1541: -- wrapup to commit and insert messages into logs
1542: -- -----------------------------------------------
1543: edw_log.put_line(' ');
1544: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1545: ' rows into the staging table');
1546: edw_log.put_line(' ');
1547: -- COMMIT;
1548: edw_log.put_line(' ');

Line 1546: edw_log.put_line(' ');

1542: -- -----------------------------------------------
1543: edw_log.put_line(' ');
1544: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1545: ' rows into the staging table');
1546: edw_log.put_line(' ');
1547: -- COMMIT;
1548: edw_log.put_line(' ');
1549: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1550: ' rows into the staging table');

Line 1548: edw_log.put_line(' ');

1544: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1545: ' rows into the staging table');
1546: edw_log.put_line(' ');
1547: -- COMMIT;
1548: edw_log.put_line(' ');
1549: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1550: ' rows into the staging table');
1551: edw_log.put_line(' ');
1552: Retcode := g_retcode;

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

1545: ' rows into the staging table');
1546: edw_log.put_line(' ');
1547: -- COMMIT;
1548: edw_log.put_line(' ');
1549: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1550: ' rows into the staging table');
1551: edw_log.put_line(' ');
1552: Retcode := g_retcode;
1553:

Line 1551: edw_log.put_line(' ');

1547: -- COMMIT;
1548: edw_log.put_line(' ');
1549: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1550: ' rows into the staging table');
1551: edw_log.put_line(' ');
1552: Retcode := g_retcode;
1553:
1554:
1555:

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

1554:
1555:
1556: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
1557: if (g_missing_rates >0) then
1558: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
1559: end if;
1560: commit;
1561: --bug#3818907
1562: --Program is on the verge of completing successfully,so clean up

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

1573: WHEN L_IDEN_CHANGE_FAILURE THEN
1574: Errbuf:=g_errbuf;
1575: Retcode:=g_retcode;
1576: l_exception_msg := Retcode || ':' || Errbuf;
1577: edw_log.put_line('Identifying changed records have Failed');
1578: rollback;
1579: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1580: /* Set the completion status to error. bug#3207823 */
1581: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

1583: WHEN L_PUSH_LOCAL_FAILURE THEN
1584: Errbuf:=g_errbuf;
1585: Retcode:=g_retcode;
1586: l_exception_msg := Retcode || ':' || Errbuf;
1587: edw_log.put_line('Inserting into local staging have failed');
1588: rollback;
1589: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1590: /* Set the completion status to error. bug#3207823 */
1591: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

1593: WHEN L_PUSH_REMOTE_FAILURE THEN
1594: Errbuf:=g_errbuf;
1595: Retcode:=g_retcode;
1596: l_exception_msg := Retcode || ':' || Errbuf;
1597: edw_log.put_line('Data migration from local to remote staging have failed');
1598: rollback;
1599: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1600: /* Set the completion status to error. bug#3207823 */
1601: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

1603: WHEN L_SET_STATUS_FAILURE THEN
1604: Errbuf:=g_errbuf;
1605: Retcode:=g_retcode;
1606: l_exception_msg := Retcode || ':' || Errbuf;
1607: edw_log.put_line('Setting status to READY have failed');
1608: rollback;
1609: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1610: /* Set the completion status to error. bug#3207823 */
1611: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);