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.OPI_DBI_COGS_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 87: bis_collection_utilities.put_line('Enter gather_stats() '||

83:
84: data_no_found exception;
85: BEGIN
86:
87: bis_collection_utilities.put_line('Enter gather_stats() '||
88: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
89:
90: -- Find owner of the table passed to procedure
91: open get_table_owner;

Line 107: bis_collection_utilities.put_line('Exit gather_stats '||

103:
104: fnd_stats.gather_table_stats(l_table_owner, p_table_name,
105: percent=>10, degree=>4, cascade=>TRUE);
106:
107: bis_collection_utilities.put_line('Exit gather_stats '||
108: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
109:
110:
111: END gather_stats;

Line 134: bis_collection_utilities.put_line('Enter check_setup_globals() '||

130: l_max_miss_date date;
131:
132: BEGIN
133:
134: bis_collection_utilities.put_line('Enter check_setup_globals() '||
135: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
136:
137: -- Initialization block
138: l_missing_day_flag := FALSE;

Line 184: bis_collection_utilities.put_line ('The global secondary currency code setup is incorrect. ' ||

180: g_secondary_rate_type IS NULL) ) THEN
181: --{
182: retcode := g_error;
183: errbuf := 'Please check log file for details';
184: bis_collection_utilities.put_line ('The global secondary currency code setup is incorrect. ' ||
185: 'The secondary currency code cannot be null when the secondary ' ||
186: 'rate type is defined and vice versa.');
187: --}
188:

Line 205: bis_collection_utilities.put_line('There are missing date in time dimension.');

201: IF l_missing_day_flag THEN
202: --{
203: retcode := g_error;
204: errbuf := 'Please check log file for details. ';
205: bis_collection_utilities.put_line('There are missing date in time dimension.');
206: bis_collection_utilities.put_line( 'The range is from '
207: || l_min_miss_date
208: ||' to ' || l_max_miss_date );
209: --}

Line 206: bis_collection_utilities.put_line( 'The range is from '

202: --{
203: retcode := g_error;
204: errbuf := 'Please check log file for details. ';
205: bis_collection_utilities.put_line('There are missing date in time dimension.');
206: bis_collection_utilities.put_line( 'The range is from '
207: || l_min_miss_date
208: ||' to ' || l_max_miss_date );
209: --}
210: END IF;

Line 216: bis_collection_utilities.put_line('Global Parameters are not setup.');

212: ELSE
213: --{
214: retcode := g_error;
215: errbuf := 'Please check log file for details. ';
216: bis_collection_utilities.put_line('Global Parameters are not setup.');
217:
218: bis_collection_utilities.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE, BIS_GLOBAL_START_DATE, BIS_PRIMARY_RATE_TYPE are setup.');
219: --}
220: END IF;

Line 218: bis_collection_utilities.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE, BIS_GLOBAL_START_DATE, BIS_PRIMARY_RATE_TYPE are setup.');

214: retcode := g_error;
215: errbuf := 'Please check log file for details. ';
216: bis_collection_utilities.put_line('Global Parameters are not setup.');
217:
218: bis_collection_utilities.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE, BIS_GLOBAL_START_DATE, BIS_PRIMARY_RATE_TYPE are setup.');
219: --}
220: END IF;
221:
222: bis_collection_utilities.put_line('Exit check_setup_globals() '||

Line 222: bis_collection_utilities.put_line('Exit check_setup_globals() '||

218: bis_collection_utilities.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE, BIS_GLOBAL_START_DATE, BIS_PRIMARY_RATE_TYPE are setup.');
219: --}
220: END IF;
221:
222: bis_collection_utilities.put_line('Exit check_setup_globals() '||
223: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
224:
225: EXCEPTION
226: WHEN OTHERS THEN

Line 231: bis_collection_utilities.put_line('Error Number: ' || retcode);

227: --{
228: retcode := SQLCODE;
229: errbuf := 'Error in opi_dbi_cogs_pkg.check_setup_globals ' || substr(SQLERRM, 1,200);
230:
231: bis_collection_utilities.put_line('Error Number: ' || retcode);
232: bis_collection_utilities.put_line('Error Message: ' || errbuf);
233: --}
234: END check_setup_globals;
235:

Line 232: bis_collection_utilities.put_line('Error Message: ' || errbuf);

228: retcode := SQLCODE;
229: errbuf := 'Error in opi_dbi_cogs_pkg.check_setup_globals ' || substr(SQLERRM, 1,200);
230:
231: bis_collection_utilities.put_line('Error Number: ' || retcode);
232: bis_collection_utilities.put_line('Error Message: ' || errbuf);
233: --}
234: END check_setup_globals;
235:
236:

Line 251: bis_collection_utilities.put_line('Enter init_opi_cogs() '||

247: retcode IN OUT NOCOPY VARCHAR2 ) IS
248:
249: BEGIN
250:
251: bis_collection_utilities.put_line('Enter init_opi_cogs() '||
252: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
253:
254:
255: retcode := 0;

Line 419: bis_collection_utilities.put_line('Exit init_opi_cogs() '||

415: AND item.organization_id = p_lines.ship_from_org_id;
416:
417: COMMIT;
418:
419: bis_collection_utilities.put_line('Exit init_opi_cogs() '||
420: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
421:
422: EXCEPTION WHEN OTHERS THEN
423: --{

Line 429: bis_collection_utilities.put_line('Exception in init_opi_cogs ' || errbuf );

425: retcode:= SQLCODE;
426:
427: ROLLBACK;
428:
429: bis_collection_utilities.put_line('Exception in init_opi_cogs ' || errbuf );
430: --}
431: END init_opi_cogs;
432:
433:

Line 449: bis_collection_utilities.put_line('Enter incremental_opi_cogs() '||

445: retcode IN OUT NOCOPY VARCHAR2 ) IS
446:
447: BEGIN
448:
449: bis_collection_utilities.put_line('Enter incremental_opi_cogs() '||
450: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
451:
452: retcode := 0;
453:

Line 606: bis_collection_utilities.put_line('Exit incremental_opi_cogs() '||

602: ;
603:
604: COMMIT;
605:
606: bis_collection_utilities.put_line('Exit incremental_opi_cogs() '||
607: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
608:
609: EXCEPTION WHEN OTHERS THEN
610: --{

Line 616: bis_collection_utilities.put_line('Exception in incremental_opi_cogs() ' || errbuf );

612: retcode:= SQLCODE;
613:
614: ROLLBACK;
615:
616: bis_collection_utilities.put_line('Exception in incremental_opi_cogs() ' || errbuf );
617: --}
618: END incremental_opi_cogs;
619:
620:

Line 637: bis_collection_utilities.put_line('Enter initial_opm_cogs() ' ||

633: retcode IN OUT NOCOPY VARCHAR2) IS
634:
635: BEGIN
636:
637: bis_collection_utilities.put_line('Enter initial_opm_cogs() ' ||
638: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
639:
640: retcode := 0;
641:

Line 834: bis_collection_utilities.put_line('Exit initial_opm_cogs() ' ||

830:
831:
832: COMMIT;
833:
834: bis_collection_utilities.put_line('Exit initial_opm_cogs() ' ||
835: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
836:
837: EXCEPTION WHEN OTHERS THEN
838: --{

Line 844: bis_collection_utilities.put_line('Error in initial_opm_cogs()' || errbuf);

840: retcode := 1;
841:
842: ROLLBACK;
843:
844: bis_collection_utilities.put_line('Error in initial_opm_cogs()' || errbuf);
845: --}
846: END initial_opm_cogs;
847:
848:

Line 871: bis_collection_utilities.put_line('Enter initial_load_opm_cogs() ' ||

867:
868: no_bounds_found exception;
869: BEGIN
870:
871: bis_collection_utilities.put_line('Enter initial_load_opm_cogs() ' ||
872: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
873:
874: -- Initialization block
875: retcode := 0;

Line 918: bis_collection_utilities.put_line ('Loading Ledger data into temp table');

914: END;
915:
916: -- Call API to load ledger data into Global temp table
917: -- This temp table will be joined to extract process adjustments
918: bis_collection_utilities.put_line ('Loading Ledger data into temp table');
919: opi_dbi_bounds_pkg.load_opm_org_ledger_data;
920:
921: -- Committing the data. Since the temp table is made with On Commit preserve rows
922: -- there will be no problem.

Line 932: bis_collection_utilities.put_line('Exit initial_load_opm_cogs() ' ||

928: retcode => retcode);
929:
930: COMMIT;
931:
932: bis_collection_utilities.put_line('Exit initial_load_opm_cogs() ' ||
933: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
934:
935: EXCEPTION WHEN OTHERS THEN
936: --{

Line 939: bis_collection_utilities.put_line('Error in initial_load_opm_cogs() ' || Sqlerrm );

935: EXCEPTION WHEN OTHERS THEN
936: --{
937: ROLLBACK;
938:
939: bis_collection_utilities.put_line('Error in initial_load_opm_cogs() ' || Sqlerrm );
940: errbuf := Sqlerrm;
941: retcode := -1;
942: --}
943: END initial_load_opm_cogs;

Line 964: bis_collection_utilities.put_line('Enter incremental_opm_cogs() ' ||

960: retcode IN OUT NOCOPY VARCHAR2 ) IS
961:
962: BEGIN
963:
964: bis_collection_utilities.put_line('Enter incremental_opm_cogs() ' ||
965: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
966: retcode := 0;
967:
968: INSERT /*+ append */ INTO opi_dbi_cogs_fstg m (

Line 1234: bis_collection_utilities.put_line('Exit incremental_opm_cogs() ' ||

1230: AND item.organization_id = p_lines.ship_from_org_id;
1231:
1232: COMMIT;
1233:
1234: bis_collection_utilities.put_line('Exit incremental_opm_cogs() ' ||
1235: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1236:
1237: EXCEPTION WHEN OTHERS THEN
1238: --{

Line 1242: bis_collection_utilities.put_line(' Error in incremental_opm_cogs()');

1238: --{
1239: ROLLBACK;
1240:
1241: retcode := -1;
1242: bis_collection_utilities.put_line(' Error in incremental_opm_cogs()');
1243: bis_collection_utilities.put_line( Sqlerrm );
1244: --}
1245: END incremental_opm_cogs;
1246:

Line 1243: bis_collection_utilities.put_line( Sqlerrm );

1239: ROLLBACK;
1240:
1241: retcode := -1;
1242: bis_collection_utilities.put_line(' Error in incremental_opm_cogs()');
1243: bis_collection_utilities.put_line( Sqlerrm );
1244: --}
1245: END incremental_opm_cogs;
1246:
1247:

Line 1267: bis_collection_utilities.put_line('Enter incremental_load_opm_cogs() ' ||

1263: no_bounds_found exception;
1264:
1265: BEGIN
1266:
1267: bis_collection_utilities.put_line('Enter incremental_load_opm_cogs() ' ||
1268: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1269:
1270: -- Initialization
1271: retcode := 0;

Line 1292: bis_collection_utilities.put_line ('Loading Ledger data into temp table');

1288: END;
1289:
1290: -- Call API to load ledger data into Global temp table
1291: -- This temp table will be joined to extract process adjustments
1292: bis_collection_utilities.put_line ('Loading Ledger data into temp table');
1293: opi_dbi_bounds_pkg.load_opm_org_ledger_data;
1294:
1295: -- Committing the data. Since the temp table is made with On Commit preserve rows
1296: -- there will be no problem.

Line 1306: bis_collection_utilities.put_line('Exit incremental_load_opm_cogs() ' ||

1302: retcode => retcode);
1303:
1304: COMMIT;
1305:
1306: bis_collection_utilities.put_line('Exit incremental_load_opm_cogs() ' ||
1307: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1308: EXCEPTION WHEN OTHERS THEN
1309: --{
1310: ROLLBACK;

Line 1312: bis_collection_utilities.put_line ('Error in incremental_load_opm_cogs() '|| Sqlerrm );

1308: EXCEPTION WHEN OTHERS THEN
1309: --{
1310: ROLLBACK;
1311:
1312: bis_collection_utilities.put_line ('Error in incremental_load_opm_cogs() '|| Sqlerrm );
1313: errbuf := Sqlerrm;
1314: retcode := -1;
1315: --}
1316: END incremental_load_opm_cogs;

Line 1423: bis_collection_utilities.put_line('Enter get_cogs_conversion_rate() '||

1419:
1420:
1421: BEGIN
1422:
1423: bis_collection_utilities.put_line('Enter get_cogs_conversion_rate() '||
1424: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1425:
1426: l_stmt_num := 0;
1427: -- initialization block

Line 1526: bis_collection_utilities.put_line('missing conversion rates');

1522: OPEN invalid_rates_exist_csr;
1523: FETCH invalid_rates_exist_csr INTO invalid_rates_exist_rec;
1524: IF (invalid_rates_exist_csr%FOUND) THEN
1525: --{
1526: bis_collection_utilities.put_line('missing conversion rates');
1527:
1528: -- there are missing rates - prepare to report them.
1529: no_currency_rate_flag := 1;
1530: bis_collection_utilities.writeMissingRateHeader;

Line 1530: bis_collection_utilities.writeMissingRateHeader;

1526: bis_collection_utilities.put_line('missing conversion rates');
1527:
1528: -- there are missing rates - prepare to report them.
1529: no_currency_rate_flag := 1;
1530: bis_collection_utilities.writeMissingRateHeader;
1531:
1532: l_stmt_num := 60;
1533: FOR get_missing_rates_rec IN get_missing_rates_c (l_pri_sec_curr_same)
1534: LOOP

Line 1536: bis_collection_utilities.writemissingrate (

1532: l_stmt_num := 60;
1533: FOR get_missing_rates_rec IN get_missing_rates_c (l_pri_sec_curr_same)
1534: LOOP
1535:
1536: bis_collection_utilities.writemissingrate (
1537: get_missing_rates_rec.rate_type,
1538: get_missing_rates_rec.func_currency_code,
1539: get_missing_rates_rec.curr_code,
1540: get_missing_rates_rec.cogs_date);

Line 1550: bis_collection_utilities.put_line('ERROR: Please setup conversion rate for all missing rates reported');

1546:
1547:
1548: l_stmt_num := 70; /* check no_currency_rate_flag */
1549: IF (no_currency_rate_flag = 1) THEN /* missing rate found */
1550: bis_collection_utilities.put_line('ERROR: Please setup conversion rate for all missing rates reported');
1551:
1552: retcode := g_error;
1553: END IF;
1554:

Line 1555: bis_collection_utilities.put_line('Exit get_cogs_conversion_rate() '||

1551:
1552: retcode := g_error;
1553: END IF;
1554:
1555: bis_collection_utilities.put_line('Exit get_cogs_conversion_rate() '||
1556: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1557:
1558: EXCEPTION
1559: WHEN OTHERS THEN

Line 1566: bis_collection_utilities.put_line('Error at statement ('

1562: retcode := SQLCODE;
1563: errbuf := 'REPORT_MISSING_RATE (' || to_char(l_stmt_num)
1564: || '): '|| substr(SQLERRM, 1,200);
1565:
1566: bis_collection_utilities.put_line('Error at statement ('
1567: || to_char(l_stmt_num)
1568: || ')');
1569:
1570: bis_collection_utilities.put_line('Error Number: ' || retcode );

Line 1570: bis_collection_utilities.put_line('Error Number: ' || retcode );

1566: bis_collection_utilities.put_line('Error at statement ('
1567: || to_char(l_stmt_num)
1568: || ')');
1569:
1570: bis_collection_utilities.put_line('Error Number: ' || retcode );
1571: bis_collection_utilities.put_line('Error Message: ' || errbuf );
1572: --}
1573: END get_cogs_conversion_rate;
1574:

Line 1571: bis_collection_utilities.put_line('Error Message: ' || errbuf );

1567: || to_char(l_stmt_num)
1568: || ')');
1569:
1570: bis_collection_utilities.put_line('Error Number: ' || retcode );
1571: bis_collection_utilities.put_line('Error Message: ' || errbuf );
1572: --}
1573: END get_cogs_conversion_rate;
1574:
1575:

Line 1679: bis_collection_utilities.put_line('Enter get_cogs_conversion_rate_incr() '||

1675:
1676:
1677: BEGIN
1678:
1679: bis_collection_utilities.put_line('Enter get_cogs_conversion_rate_incr() '||
1680: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1681:
1682: -- Initialization block
1683: l_stmt_num := 0;

Line 1784: bis_collection_utilities.writeMissingRateHeader;

1780: IF (invalid_rates_exist_csr%FOUND) THEN
1781: --{
1782: -- there are missing rates - prepare to report them.
1783: no_currency_rate_flag := 1;
1784: bis_collection_utilities.writeMissingRateHeader;
1785:
1786: l_stmt_num := 60;
1787: FOR get_missing_rates_rec IN get_missing_rates_c (l_pri_sec_curr_same)
1788: LOOP

Line 1790: bis_collection_utilities.writemissingrate (

1786: l_stmt_num := 60;
1787: FOR get_missing_rates_rec IN get_missing_rates_c (l_pri_sec_curr_same)
1788: LOOP
1789:
1790: bis_collection_utilities.writemissingrate (
1791: get_missing_rates_rec.rate_type,
1792: get_missing_rates_rec.func_currency_code,
1793: get_missing_rates_rec.curr_code,
1794: get_missing_rates_rec.cogs_date);

Line 1805: bis_collection_utilities.put_line('ERROR: Please setup conversion rate for all missing rates reported');

1801:
1802: l_stmt_num := 70; /* check no_currency_rate_flag */
1803: IF (no_currency_rate_flag = 1) THEN /* missing rate found */
1804: --{
1805: bis_collection_utilities.put_line('ERROR: Please setup conversion rate for all missing rates reported');
1806:
1807: retcode := g_error;
1808: --}
1809: END IF;

Line 1811: bis_collection_utilities.put_line('Exit get_cogs_conversion_rate_incr() '||

1807: retcode := g_error;
1808: --}
1809: END IF;
1810:
1811: bis_collection_utilities.put_line('Exit get_cogs_conversion_rate_incr() '||
1812: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1813:
1814: EXCEPTION
1815: WHEN OTHERS THEN

Line 1822: bis_collection_utilities.put_line('Error at statement ('

1818: retcode := SQLCODE;
1819: errbuf := 'REPORT_MISSING_RATE (' || to_char(l_stmt_num)
1820: || '): '|| substr(SQLERRM, 1,200);
1821:
1822: bis_collection_utilities.put_line('Error at statement ('
1823: || to_char(l_stmt_num)
1824: || ')');
1825:
1826: bis_collection_utilities.put_line('Error Number: ' || retcode );

Line 1826: bis_collection_utilities.put_line('Error Number: ' || retcode );

1822: bis_collection_utilities.put_line('Error at statement ('
1823: || to_char(l_stmt_num)
1824: || ')');
1825:
1826: bis_collection_utilities.put_line('Error Number: ' || retcode );
1827: bis_collection_utilities.put_line('Error Message: ' || errbuf );
1828: --}
1829: END get_cogs_conversion_rate_incr;
1830:

Line 1827: bis_collection_utilities.put_line('Error Message: ' || errbuf );

1823: || to_char(l_stmt_num)
1824: || ')');
1825:
1826: bis_collection_utilities.put_line('Error Number: ' || retcode );
1827: bis_collection_utilities.put_line('Error Message: ' || errbuf );
1828: --}
1829: END get_cogs_conversion_rate_incr;
1830:
1831: /*======================================================================

Line 1857: bis_collection_utilities.put_line('Enter initial_load_cogs() '||

1853:
1854: schema_info_not_found exception;
1855: BEGIN
1856:
1857: bis_collection_utilities.put_line('Enter initial_load_cogs() '||
1858: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1859: -- Initialization
1860: l_error_flag := FALSE;
1861: retcode := 0;

Line 1863: bis_collection_utilities.put_line ('Initial Load COGS starts at '

1859: -- Initialization
1860: l_error_flag := FALSE;
1861: retcode := 0;
1862:
1863: bis_collection_utilities.put_line ('Initial Load COGS starts at '
1864: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1865:
1866: IF bis_collection_utilities.setup('OPI_DBI_COGS_F' ) = false THEN
1867: --{

Line 1866: IF bis_collection_utilities.setup('OPI_DBI_COGS_F' ) = false THEN

1862:
1863: bis_collection_utilities.put_line ('Initial Load COGS starts at '
1864: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1865:
1866: IF bis_collection_utilities.setup('OPI_DBI_COGS_F' ) = false THEN
1867: --{
1868: RAISE_APPLICATION_ERROR(-20000, errbuf);
1869: --}
1870: END IF;

Line 1944: bis_collection_utilities.put_line('Load OPI cogs into stg '

1940:
1941: -- Load discrete cogs into staging table
1942: l_stmt_num := 60;
1943:
1944: bis_collection_utilities.put_line('Load OPI cogs into stg '
1945: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1946:
1947: init_opi_cogs( errbuf => errbuf, retcode => retcode);
1948:

Line 1960: bis_collection_utilities.put_line('Load OPM cogs into stg '

1956:
1957: -- Load process cogs into staging table
1958: l_stmt_num :=70;
1959:
1960: bis_collection_utilities.put_line('Load OPM cogs into stg '
1961: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1962:
1963: initial_load_opm_cogs(errbuf => errbuf, retcode => retcode);
1964:

Line 2071: bis_collection_utilities.put_line('Loaded ' || l_row_count || ' rows into opi_dbi_cogs_f.');

2067: stg.turns_cogs_flag,
2068: stg.internal_flag;
2069: l_row_count := sql%rowcount;
2070:
2071: bis_collection_utilities.put_line('Loaded ' || l_row_count || ' rows into opi_dbi_cogs_f.');
2072:
2073: -- Report etl success
2074: l_stmt_num := 100;
2075:

Line 2084: bis_collection_utilities.put_line('COGS Initial Load found uncosted transactions.');

2080: -- if uncosted transactions were found, return a warning.
2081: l_stmt_num :=110;
2082: IF (l_bounds_warning) THEN
2083: --{
2084: bis_collection_utilities.put_line('COGS Initial Load found uncosted transactions.');
2085: retcode := g_WARNING;
2086: errbuf := 'COGS Initial Load Found Uncosted Transactions. ';
2087: --}
2088: END IF;

Line 2100: bis_collection_utilities.wrapup(p_status => TRUE,

2096:
2097: execute immediate 'truncate table ' || l_opi_schema
2098: || '.opi_dbi_cogs_fstg ';
2099:
2100: bis_collection_utilities.wrapup(p_status => TRUE,
2101: p_count => l_row_count,
2102: p_message => 'successful in initial_load_cogs.');
2103: --}
2104: ELSE

Line 2109: bis_collection_utilities.wrapup(p_status => FALSE,

2105: --{
2106: rollback;
2107: retcode := g_error ;
2108: errbuf := 'Please check log file for details.';
2109: bis_collection_utilities.wrapup(p_status => FALSE,
2110: p_count => 0,
2111: p_message => 'failed in initial_load_cogs.');
2112: --}
2113: END IF;

Line 2115: bis_collection_utilities.put_line('Exit initial_load_cogs() '||

2111: p_message => 'failed in initial_load_cogs.');
2112: --}
2113: END IF;
2114:
2115: bis_collection_utilities.put_line('Exit initial_load_cogs() '||
2116: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2117:
2118: EXCEPTION WHEN OTHERS THEN
2119:

Line 2124: bis_collection_utilities.put_line('Error in initial_load_cogs() at ' || l_stmt_num);

2120: errbuf:= Sqlerrm;
2121: retcode:= SQLCODE;
2122:
2123: ROLLBACK;
2124: bis_collection_utilities.put_line('Error in initial_load_cogs() at ' || l_stmt_num);
2125: bis_collection_utilities.wrapup(p_status => FALSE,
2126: p_count => 0,
2127: p_message => 'failed in initial_load_cogs.');
2128:

Line 2125: bis_collection_utilities.wrapup(p_status => FALSE,

2121: retcode:= SQLCODE;
2122:
2123: ROLLBACK;
2124: bis_collection_utilities.put_line('Error in initial_load_cogs() at ' || l_stmt_num);
2125: bis_collection_utilities.wrapup(p_status => FALSE,
2126: p_count => 0,
2127: p_message => 'failed in initial_load_cogs.');
2128:
2129: RAISE_APPLICATION_ERROR(-20000,errbuf);

Line 2160: bis_collection_utilities.put_line('Enter incremental_load_cogs() '||

2156:
2157: schema_info_not_found EXCEPTION;
2158: BEGIN
2159:
2160: bis_collection_utilities.put_line('Enter incremental_load_cogs() '||
2161: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2162:
2163: -- Initialization
2164: l_error_flag := false;

Line 2167: bis_collection_utilities.put_line('Incrmental Load COGS starts at '

2163: -- Initialization
2164: l_error_flag := false;
2165: retcode :=0;
2166:
2167: bis_collection_utilities.put_line('Incrmental Load COGS starts at '
2168: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2169:
2170: IF bis_collection_utilities.setup( 'OPI_DBI_COGS_F' ) = false THEN
2171: --{

Line 2170: IF bis_collection_utilities.setup( 'OPI_DBI_COGS_F' ) = false THEN

2166:
2167: bis_collection_utilities.put_line('Incrmental Load COGS starts at '
2168: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2169:
2170: IF bis_collection_utilities.setup( 'OPI_DBI_COGS_F' ) = false THEN
2171: --{
2172: RAISE_APPLICATION_ERROR(-20000, errbuf);
2173: --}
2174: END IF;

Line 2235: bis_collection_utilities.put_line('Load discrete cogs into stg '

2231:
2232: -- Load discrete cogs into staging table
2233: l_stmt_num :=60;
2234:
2235: bis_collection_utilities.put_line('Load discrete cogs into stg '
2236: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2237:
2238: incremental_opi_cogs( errbuf => errbuf, retcode => retcode);
2239:

Line 2250: bis_collection_utilities.put_line('Load process cogs into stg '

2246:
2247: -- Load process cogs into staging table
2248: l_stmt_num := 70;
2249:
2250: bis_collection_utilities.put_line('Load process cogs into stg '
2251: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2252:
2253: incremental_load_opm_cogs( errbuf => errbuf, retcode => retcode);
2254:

Line 2392: bis_collection_utilities.put_line('Loaded ' || l_row_count || ' rows into opi_dbi_cogs_f.');

2388:
2389:
2390: l_row_count := sql%rowcount;
2391:
2392: bis_collection_utilities.put_line('Loaded ' || l_row_count || ' rows into opi_dbi_cogs_f.');
2393: -- Report etl success
2394: l_stmt_num := 100;
2395:
2396: opi_dbi_bounds_pkg.set_load_successful(p_etl_type => 'COGS', p_load_type => 'INCR');

Line 2404: bis_collection_utilities.put_line('COGS Incremental Load found uncosted transactions.');

2400: -- if uncosted transactions were found, return a warning.
2401: l_stmt_num := 110;
2402: IF (l_bounds_warning) THEN
2403: --{
2404: bis_collection_utilities.put_line('COGS Incremental Load found uncosted transactions.');
2405: retcode := g_WARNING;
2406: errbuf := ' COGS Incremental Load Found Uncosted Transactions. ';
2407: --}
2408: END IF;

Line 2419: bis_collection_utilities.wrapup( p_status => TRUE,

2415:
2416: execute immediate 'truncate table ' || l_opi_schema
2417: || '.opi_dbi_cogs_fstg ';
2418:
2419: bis_collection_utilities.wrapup( p_status => TRUE,
2420: p_count => l_row_count,
2421: p_message => 'successful in incremental_load_cogs.');
2422: --}
2423: ELSE

Line 2428: bis_collection_utilities.wrapup(p_status => FALSE,

2424: --{
2425: rollback;
2426: retcode := g_error ;
2427: errbuf := 'Please check log file for details.';
2428: bis_collection_utilities.wrapup(p_status => FALSE,
2429: p_count => 0,
2430: p_message => 'failed in incremental_load_cogs.'
2431: );
2432: --}

Line 2435: bis_collection_utilities.put_line('Exit incremental_load_cogs() '||

2431: );
2432: --}
2433: END IF;
2434:
2435: bis_collection_utilities.put_line('Exit incremental_load_cogs() '||
2436: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2437:
2438: EXCEPTION WHEN OTHERS THEN
2439: --{

Line 2444: bis_collection_utilities.put_line('Error in incremental_load_cogs() at ' || l_stmt_num);

2440: errbuf:= Sqlerrm;
2441: retcode:= SQLCODE;
2442:
2443: ROLLBACK;
2444: bis_collection_utilities.put_line('Error in incremental_load_cogs() at ' || l_stmt_num);
2445: bis_collection_utilities.wrapup(p_status => FALSE,
2446: p_count => 0,
2447: p_message => 'failed in incremental_load_cogs.'
2448: );

Line 2445: bis_collection_utilities.wrapup(p_status => FALSE,

2441: retcode:= SQLCODE;
2442:
2443: ROLLBACK;
2444: bis_collection_utilities.put_line('Error in incremental_load_cogs() at ' || l_stmt_num);
2445: bis_collection_utilities.wrapup(p_status => FALSE,
2446: p_count => 0,
2447: p_message => 'failed in incremental_load_cogs.'
2448: );
2449: