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_OPM_COGS_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 95: BIS_COLLECTION_UTILITIES.PUT_LINE('There are missing dates in Time Dimension.');

91:
92: IF l_missing_day_flag THEN
93: retcode := 1;
94: errbuf := 'Please check log file for details. ';
95: BIS_COLLECTION_UTILITIES.PUT_LINE('There are missing dates in Time Dimension.');
96:
97: BIS_COLLECTION_UTILITIES.PUT_LINE('The range is from ' || l_min_miss_date
98: ||' to ' || l_max_miss_date );
99: END IF;

Line 97: BIS_COLLECTION_UTILITIES.PUT_LINE('The range is from ' || l_min_miss_date

93: retcode := 1;
94: errbuf := 'Please check log file for details. ';
95: BIS_COLLECTION_UTILITIES.PUT_LINE('There are missing dates in Time Dimension.');
96:
97: BIS_COLLECTION_UTILITIES.PUT_LINE('The range is from ' || l_min_miss_date
98: ||' to ' || l_max_miss_date );
99: END IF;
100: ELSE
101: retcode := 1;

Line 103: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');

99: END IF;
100: ELSE
101: retcode := 1;
102: errbuf := 'Please check log file for details. ';
103: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
104:
105: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
106:
107: END IF;

Line 105: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');

101: retcode := 1;
102: errbuf := 'Please check log file for details. ';
103: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
104:
105: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
106:
107: END IF;
108:
109: EXCEPTION

Line 116: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

112: l_err_num := SQLCODE;
113: l_err_msg := 'ERROR in OPI_DBI_OPM_COGS_PKG.CHECK_SETUP_GLOBALS '
114: || substr(SQLERRM, 1,200);
115:
116: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
117: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
118:
119: END check_setup_globals;
120:

Line 117: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

113: l_err_msg := 'ERROR in OPI_DBI_OPM_COGS_PKG.CHECK_SETUP_GLOBALS '
114: || substr(SQLERRM, 1,200);
115:
116: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
117: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
118:
119: END check_setup_globals;
120:
121: -- return 0 -- normal

Line 149: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

145:
146: IF (no_currency_rate_flag = 0) THEN
147: no_currency_rate_flag := 1;
148: END IF;
149: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
150: BIS_COLLECTION_UTILITIES.writemissingrate
151: (g_global_rate_type,
152: get_missing_rate_rec.cogs_currency_code,
153: global_currency_code,

Line 150: BIS_COLLECTION_UTILITIES.writemissingrate

146: IF (no_currency_rate_flag = 0) THEN
147: no_currency_rate_flag := 1;
148: END IF;
149: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
150: BIS_COLLECTION_UTILITIES.writemissingrate
151: (g_global_rate_type,
152: get_missing_rate_rec.cogs_currency_code,
153: global_currency_code,
154: get_missing_rate_rec.cogs_date);

Line 162: BIS_COLLECTION_UTILITIES.PUT_LINE('Please setup conversion rate for all missing rates reported');

158: CLOSE get_missing_rate_c;
159:
160: l_stmt_num := 30; /* check no_currency_rate_flag */
161: IF (no_currency_rate_flag = 1) THEN /* missing rate found */
162: BIS_COLLECTION_UTILITIES.PUT_LINE('Please setup conversion rate for all missing rates reported');
163: return (-1);
164: END IF;
165: return (0);
166:

Line 174: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MARGIN_VALUE_PKG.REPORT_MISSING_RATE - Error at statement ('

170: i_err_num := SQLCODE;
171: i_err_msg := 'REPORT_MISSING_RATE (' || to_char(l_stmt_num)
172: || '): '|| substr(SQLERRM, 1,200);
173:
174: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MARGIN_VALUE_PKG.REPORT_MISSING_RATE - Error at statement ('
175: || to_char(l_stmt_num)
176: || ')');
177:
178: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(i_err_num));

Line 178: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(i_err_num));

174: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MARGIN_VALUE_PKG.REPORT_MISSING_RATE - Error at statement ('
175: || to_char(l_stmt_num)
176: || ')');
177:
178: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(i_err_num));
179: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || i_err_msg);
180:
181: return -1;
182: END REPORT_MISSING_RATE ;

Line 179: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || i_err_msg);

175: || to_char(l_stmt_num)
176: || ')');
177:
178: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(i_err_num));
179: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || i_err_msg);
180:
181: return -1;
182: END REPORT_MISSING_RATE ;
183:

Line 639: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);

635: x_msg := NULL;
636: EXCEPTION WHEN OTHERS THEN
637: ROLLBACK;
638:
639: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
640: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
641: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
642: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
643: x_status := 0; -- error

Line 640: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );

636: EXCEPTION WHEN OTHERS THEN
637: ROLLBACK;
638:
639: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
640: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
641: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
642: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
643: x_status := 0; -- error
644: x_msg := Sqlerrm;

Line 641: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);

637: ROLLBACK;
638:
639: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
640: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
641: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
642: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
643: x_status := 0; -- error
644: x_msg := Sqlerrm;
645:

Line 642: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );

638:
639: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
640: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
641: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opm_subl_org_cogs at statement ' || l_stmt);
642: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
643: x_status := 0; -- error
644: x_msg := Sqlerrm;
645:
646: END refresh_opm_subl_org_cogs;

Line 725: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opi_icap_cogs ');

721: EXCEPTION WHEN OTHERS THEN
722: ROLLBACK;
723: x_status := 0; -- error
724: x_msg := Sqlerrm;
725: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opi_icap_cogs ');
726: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
727:
728: END refresh_opi_icap_cogs;
729:

Line 726: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );

722: ROLLBACK;
723: x_status := 0; -- error
724: x_msg := Sqlerrm;
725: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Refresh_opi_icap_cogs ');
726: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
727:
728: END refresh_opi_icap_cogs;
729:
730: PROCEDURE initial_opm_subl_org_cogs(

Line 1259: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);

1255: x_msg := NULL;
1256: EXCEPTION WHEN OTHERS THEN
1257: ROLLBACK;
1258:
1259: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
1260: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
1261: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
1262: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
1263: x_status := 0; -- error

Line 1260: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );

1256: EXCEPTION WHEN OTHERS THEN
1257: ROLLBACK;
1258:
1259: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
1260: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
1261: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
1262: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
1263: x_status := 0; -- error
1264: x_msg := Sqlerrm;

Line 1261: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);

1257: ROLLBACK;
1258:
1259: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
1260: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
1261: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
1262: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
1263: x_status := 0; -- error
1264: x_msg := Sqlerrm;
1265:

Line 1262: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );

1258:
1259: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
1260: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
1261: BIS_COLLECTION_UTILITIES.PUT_LINE(' Error in Initial_opm_subl_org_cogs at statement ' || l_stmt);
1262: BIS_COLLECTION_UTILITIES.PUT_LINE( Sqlerrm );
1263: x_status := 0; -- error
1264: x_msg := Sqlerrm;
1265:
1266: END initial_opm_subl_org_cogs;

Line 1305: BIS_COLLECTION_UTILITIES.PUT_LINE('S, ICAP '|| l_last_trx_id );

1301: SELECT Nvl( MIN(invoice_distribution_id), 0) INTO l_last_trx_id
1302: FROM ap_invoice_distributions_all
1303: WHERE accounting_date >= global_start_date;
1304:
1305: BIS_COLLECTION_UTILITIES.PUT_LINE('S, ICAP '|| l_last_trx_id );
1306: --l_last_trx_id := 0;
1307: END;
1308:
1309: SELECT ap_invoice_distributions_s.NEXTVAL INTO l_new_trx_id

Line 1314: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI ICAP COGS at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));

1310: FROM dual;
1311:
1312: l_batch_from_id := l_last_trx_id;
1313:
1314: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI ICAP COGS at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));
1315: LOOP
1316:
1317: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_last_trx_id );
1318:

Line 1317: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_last_trx_id );

1313:
1314: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI ICAP COGS at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));
1315: LOOP
1316:
1317: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_last_trx_id );
1318:
1319: IF (l_batch_from_id + l_rows_in_batch) >= l_new_trx_id THEN
1320: l_batch_to_id := l_new_trx_id;
1321: ELSE

Line 1357: BIS_COLLECTION_UTILITIES.PUT_LINE(' after ICAP time is ' || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));

1353: EXIT WHEN l_batch_to_id >= l_new_trx_id OR l_status = 0;
1354:
1355: END LOOP;
1356:
1357: BIS_COLLECTION_UTILITIES.PUT_LINE(' after ICAP time is ' || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1358: BIS_COLLECTION_UTILITIES.PUT_LINE('after ICAP time is ' || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1359:
1360: end refresh_icap_cogs;
1361:

Line 1358: BIS_COLLECTION_UTILITIES.PUT_LINE('after ICAP time is ' || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));

1354:
1355: END LOOP;
1356:
1357: BIS_COLLECTION_UTILITIES.PUT_LINE(' after ICAP time is ' || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1358: BIS_COLLECTION_UTILITIES.PUT_LINE('after ICAP time is ' || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1359:
1360: end refresh_icap_cogs;
1361:
1362:

Line 1393: BIS_COLLECTION_UTILITIES.PUT_LINE('completed report_missing_rate ');

1389: WHERE error_message IS NOT NULL;
1390:
1391: l_missing_rate_count := report_missing_rate;
1392:
1393: BIS_COLLECTION_UTILITIES.PUT_LINE('completed report_missing_rate ');
1394:
1395: IF l_exception_count = 0 AND l_missing_rate_count = 0 THEN
1396: BIS_COLLECTION_UTILITIES.PUT_LINE('merging into fact table');
1397: merge INTO opi_dbi_margin_f m

Line 1396: BIS_COLLECTION_UTILITIES.PUT_LINE('merging into fact table');

1392:
1393: BIS_COLLECTION_UTILITIES.PUT_LINE('completed report_missing_rate ');
1394:
1395: IF l_exception_count = 0 AND l_missing_rate_count = 0 THEN
1396: BIS_COLLECTION_UTILITIES.PUT_LINE('merging into fact table');
1397: merge INTO opi_dbi_margin_f m
1398: using (SELECT *
1399: FROM opi_dbi_cogs_stg ) c
1400: ON ( m.order_line_id = c.order_line_id

Line 1431: BIS_COLLECTION_UTILITIES.PUT_LINE('merge completed');

1427: c.source, c.ship_ou_id, c.sell_ou_id,
1428: c.turns_cogs_flag, Sysdate, Sysdate,
1429: g_user_id, g_user_id, g_login_id);
1430:
1431: BIS_COLLECTION_UTILITIES.PUT_LINE('merge completed');
1432:
1433: x_row_count := SQL%rowcount;
1434:
1435: -- truncate staging table

Line 1443: BIS_COLLECTION_UTILITIES.PUT_LINE('There are either missing conversion rates or exeception happened.');

1439: COMMIT;
1440: ELSE -- there is exception or missing rate
1441: retcode := 1;
1442: errbuf := 'Please check log file for details. ';
1443: BIS_COLLECTION_UTILITIES.PUT_LINE('There are either missing conversion rates or exeception happened.');
1444: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check the log file for details ');
1445: END IF;
1446:
1447: BIS_COLLECTION_UTILITIES.PUT_LINE('completed OPI COGS Merge time is ' || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));

Line 1444: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check the log file for details ');

1440: ELSE -- there is exception or missing rate
1441: retcode := 1;
1442: errbuf := 'Please check log file for details. ';
1443: BIS_COLLECTION_UTILITIES.PUT_LINE('There are either missing conversion rates or exeception happened.');
1444: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check the log file for details ');
1445: END IF;
1446:
1447: BIS_COLLECTION_UTILITIES.PUT_LINE('completed OPI COGS Merge time is ' || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1448:

Line 1447: BIS_COLLECTION_UTILITIES.PUT_LINE('completed OPI COGS Merge time is ' || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));

1443: BIS_COLLECTION_UTILITIES.PUT_LINE('There are either missing conversion rates or exeception happened.');
1444: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check the log file for details ');
1445: END IF;
1446:
1447: BIS_COLLECTION_UTILITIES.PUT_LINE('completed OPI COGS Merge time is ' || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1448:
1449: end check_rates_and_truncate;
1450:
1451:

Line 1481: BIS_COLLECTION_UTILITIES.PUT_LINE('OPM COGS refresh started at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));

1477: BEGIN
1478:
1479: retcode := 0;
1480:
1481: BIS_COLLECTION_UTILITIES.PUT_LINE('OPM COGS refresh started at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));
1482:
1483: -- 0. check if staging table is empty or not
1484: SELECT COUNT(*) INTO l_empty_count
1485: FROM opi_dbi_cogs_stg

Line 1532: BIS_COLLECTION_UTILITIES.PUT_LINE('S, ' ||l_last_trx_id );

1528: where tst.doc_type in ( 'OMSO', 'PORC')
1529: and tst.acct_ttl_type = 5200
1530: AND tst.gl_trans_date >= global_start_date;
1531:
1532: BIS_COLLECTION_UTILITIES.PUT_LINE('S, ' ||l_last_trx_id );
1533: BIS_COLLECTION_UTILITIES.PUT_LINE ('Incremental Refresh chosen, but Initial Load may be faster' );
1534: END;
1535:
1536:

Line 1533: BIS_COLLECTION_UTILITIES.PUT_LINE ('Incremental Refresh chosen, but Initial Load may be faster' );

1529: and tst.acct_ttl_type = 5200
1530: AND tst.gl_trans_date >= global_start_date;
1531:
1532: BIS_COLLECTION_UTILITIES.PUT_LINE('S, ' ||l_last_trx_id );
1533: BIS_COLLECTION_UTILITIES.PUT_LINE ('Incremental Refresh chosen, but Initial Load may be faster' );
1534: END;
1535:
1536:
1537:

Line 1538: BIS_COLLECTION_UTILITIES.PUT_LINE

1534: END;
1535:
1536:
1537:
1538: BIS_COLLECTION_UTILITIES.PUT_LINE
1539: ('Collecting OPM Subledger COGS for transaction ID range: ' || to_char(l_last_trx_id + 1) ||' - ' || l_new_trx_id);
1540:
1541:
1542:

Line 1543: BIS_COLLECTION_UTILITIES.PUT_LINE( ' Start at ' || To_char(Sysdate, 'hh24:mi:ss'));

1539: ('Collecting OPM Subledger COGS for transaction ID range: ' || to_char(l_last_trx_id + 1) ||' - ' || l_new_trx_id);
1540:
1541:
1542:
1543: BIS_COLLECTION_UTILITIES.PUT_LINE( ' Start at ' || To_char(Sysdate, 'hh24:mi:ss'));
1544:
1545: l_batch_from_id := l_last_trx_id;
1546: l_batch_to_id := l_new_trx_id;
1547:

Line 1548: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_batch_from_id);

1544:
1545: l_batch_from_id := l_last_trx_id;
1546: l_batch_to_id := l_new_trx_id;
1547:
1548: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_batch_from_id);
1549:
1550: refresh_opm_subl_org_cogs(
1551: l_batch_from_id + 1,
1552: l_batch_to_id,

Line 1580: BIS_COLLECTION_UTILITIES.PUT_LINE(' Subledger COGS completed at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));

1576: g_user_id, g_login_id );
1577:
1578: COMMIT; -- commit per org
1579:
1580: BIS_COLLECTION_UTILITIES.PUT_LINE(' Subledger COGS completed at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));
1581:
1582: -- 2. get Intercompany AP as COGS
1583: -- refresh_icap_cogs; --removed and called from wrapper
1584:

Line 1592: BIS_COLLECTION_UTILITIES.PUT_LINE('Error in refresh_opm_cogs ' || Sqlerrm );

1588: RETURN x_row_count;
1589: EXCEPTION WHEN OTHERS THEN
1590: ROLLBACK;
1591:
1592: BIS_COLLECTION_UTILITIES.PUT_LINE('Error in refresh_opm_cogs ' || Sqlerrm );
1593: errbuf := Sqlerrm;
1594: retcode := 1;
1595: RETURN x_row_count;
1596: END refresh_opm_cogs;

Line 1628: BIS_COLLECTION_UTILITIES.PUT_LINE('OPM COGS refresh started at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));

1624: BEGIN
1625:
1626: retcode := 0;
1627:
1628: BIS_COLLECTION_UTILITIES.PUT_LINE('OPM COGS refresh started at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));
1629:
1630:
1631: -- 1. get subledger cogs
1632:

Line 1642: BIS_COLLECTION_UTILITIES.PUT_LINE('Initial Refresh' );

1638: where tst.doc_type in ( 'OMSO', 'PORC' )
1639: and tst.acct_ttl_type = 5200
1640: AND tst.gl_trans_date >= global_start_date;
1641:
1642: BIS_COLLECTION_UTILITIES.PUT_LINE('Initial Refresh' );
1643:
1644:
1645: BIS_COLLECTION_UTILITIES.PUT_LINE
1646: ('Collecting OPM Subledger COGS for transaction ID range: ' || l_last_trx_id ||' - ' || l_new_trx_id);

Line 1645: BIS_COLLECTION_UTILITIES.PUT_LINE

1641:
1642: BIS_COLLECTION_UTILITIES.PUT_LINE('Initial Refresh' );
1643:
1644:
1645: BIS_COLLECTION_UTILITIES.PUT_LINE
1646: ('Collecting OPM Subledger COGS for transaction ID range: ' || l_last_trx_id ||' - ' || l_new_trx_id);
1647:
1648:
1649: BIS_COLLECTION_UTILITIES.PUT_LINE( ' Start at ' || To_char(Sysdate, 'hh24:mi:ss'));

Line 1649: BIS_COLLECTION_UTILITIES.PUT_LINE( ' Start at ' || To_char(Sysdate, 'hh24:mi:ss'));

1645: BIS_COLLECTION_UTILITIES.PUT_LINE
1646: ('Collecting OPM Subledger COGS for transaction ID range: ' || l_last_trx_id ||' - ' || l_new_trx_id);
1647:
1648:
1649: BIS_COLLECTION_UTILITIES.PUT_LINE( ' Start at ' || To_char(Sysdate, 'hh24:mi:ss'));
1650:
1651: l_batch_from_id := l_last_trx_id;
1652: l_batch_to_id := l_new_trx_id;
1653:

Line 1654: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_batch_from_id);

1650:
1651: l_batch_from_id := l_last_trx_id;
1652: l_batch_to_id := l_new_trx_id;
1653:
1654: BIS_COLLECTION_UTILITIES.PUT_LINE('batch_id ' || l_batch_from_id);
1655:
1656: initial_opm_subl_org_cogs(
1657: l_batch_from_id,
1658: l_batch_to_id,

Line 1687: BIS_COLLECTION_UTILITIES.PUT_LINE(' Subledger COGS completed at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));

1683: g_user_id, g_login_id );
1684:
1685: COMMIT;
1686:
1687: BIS_COLLECTION_UTILITIES.PUT_LINE(' Subledger COGS completed at ' || TO_CHAR(SYSDATE, 'hh24:mi:ss'));
1688:
1689: RETURN x_row_count;
1690: EXCEPTION WHEN OTHERS THEN
1691: ROLLBACK;

Line 1693: BIS_COLLECTION_UTILITIES.PUT_LINE('Error in refresh_opm_cogs ' || Sqlerrm );

1689: RETURN x_row_count;
1690: EXCEPTION WHEN OTHERS THEN
1691: ROLLBACK;
1692:
1693: BIS_COLLECTION_UTILITIES.PUT_LINE('Error in refresh_opm_cogs ' || Sqlerrm );
1694: errbuf := Sqlerrm;
1695: retcode := 1;
1696: RETURN 0; --x_row_count;
1697: END complete_refresh_opm_cogs;

Line 1710: /* IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_MARGIN_F' ) = false then

1706: l_industry VARCHAR2(30);
1707: l_revenue_count NUMBER := 0;
1708: l_cogs_count NUMBER := 0;
1709: BEGIN
1710: /* IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_MARGIN_F' ) = false then
1711: RAISE_APPLICATION_ERROR(-20000, errbuf);
1712: END IF;
1713: */
1714: -- setup globals

Line 1754: /* bis_collection_utilities.WRAPUP( p_status => TRUE,

1750: /* l_revenue_count := opi_dbi_cogs_margin_pkg.complete_refresh_revenue; */
1751:
1752: END IF;
1753:
1754: /* bis_collection_utilities.WRAPUP( p_status => TRUE,
1755: p_count => 0,
1756: p_message => 'successfully refreshed OPM performance Margin.'
1757: );
1758: */

Line 1765: /* bis_collection_utilities.wrapup(p_status => FALSE,

1761: Errbuf:= Sqlerrm;
1762: Retcode:= SQLCODE;
1763:
1764: ROLLBACK;
1765: /* bis_collection_utilities.wrapup(p_status => FALSE,
1766: p_count => 0,
1767: p_message => 'failed in refreshing Margin.'
1768: );
1769: */

Line 1782: /* IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_MARGIN_F' ) = false then

1778: l_revenue_count NUMBER := 0;
1779: l_cogs_count NUMBER := 0;
1780: BEGIN
1781:
1782: /* IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_MARGIN_F' ) = false then
1783: RAISE_APPLICATION_ERROR(-20000, errbuf);
1784: END IF;
1785: */
1786: check_setup_globals(errbuf, retcode);

Line 1802: /* bis_collection_utilities.WRAPUP( p_status => TRUE,

1798: /* l_revenue_count := opi_dbi_cogs_margin_pkg.refresh_revenue; */
1799: END IF;
1800: END IF;
1801:
1802: /* bis_collection_utilities.WRAPUP( p_status => TRUE,
1803: p_count => (l_revenue_count + l_cogs_count)/2,
1804: p_message => 'successfully refreshed OPM performance Margin.'
1805: );
1806: */

Line 1814: /* bis_collection_utilities.wrapup(p_status => FALSE,

1810: Errbuf:= Sqlerrm;
1811: Retcode:= SQLCODE;
1812:
1813: ROLLBACK;
1814: /* bis_collection_utilities.wrapup(p_status => FALSE,
1815: p_count => (l_revenue_count + l_cogs_count)/2,
1816: p_message => 'failed in refreshing OPM Margin.'
1817: );
1818: */