APPS.OPI_DBI_RES_PKG dependencies on BIS_COLLECTION_UTILITIES

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

71:
72: l_table_owner VARCHAR2(32);
73:
74: BEGIN
75: bis_collection_utilities.put_line('Enter gather_stats() ' ||
76: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
77:
78: -- Find owner of the table passed to procedure
79:

Line 91: bis_collection_utilities.put_line('Exit gather_stats() ' ||

87:
88: FND_STATS.GATHER_TABLE_STATS(l_table_owner,P_TABLE_NAME,
89: PERCENT=>10,DEGREE=>4,CASCADE=>TRUE);
90:
91: bis_collection_utilities.put_line('Exit gather_stats() ' ||
92: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
93: END gather_stats;
94:
95: /*===============================================================

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

116: l_max_miss_date DATE;
117:
118: BEGIN
119:
120: bis_collection_utilities.put_line('Enter check_setup_globals() ' ||
121: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
122:
123: -- initialization block
124: l_missing_day_flag := false;

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

167: g_secondary_rate_type IS NULL) ) THEN
168: --{
169: retcode := g_error;
170: errbuf := 'Please check log file for details.';
171: bis_collection_utilities.put_line ('The global secondary currency code setup is incorrect.' ||
172: 'The secondary currency code cannot be null when the ' ||
173: 'secondary rate type is defined and vice versa.');
174: --}
175: END IF;

Line 188: bis_collection_utilities.put_line( 'There are missing date in Time Dimension.');

184: IF l_missing_day_flag THEN
185: --{
186: retcode := g_error;
187: errbuf := 'Please check log file for details. ';
188: bis_collection_utilities.put_line( 'There are missing date in Time Dimension.');
189:
190: bis_collection_utilities.put_line ( 'The range is from ' || l_min_miss_date
191: ||' to ' || l_max_miss_date );
192: --}

Line 190: bis_collection_utilities.put_line ( 'The range is from ' || l_min_miss_date

186: retcode := g_error;
187: errbuf := 'Please check log file for details. ';
188: bis_collection_utilities.put_line( 'There are missing date in Time Dimension.');
189:
190: bis_collection_utilities.put_line ( 'The range is from ' || l_min_miss_date
191: ||' to ' || l_max_miss_date );
192: --}
193: END IF;
194: --}

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

195: ELSE
196: --{
197: retcode := g_error;
198: errbuf := 'Please check log file for details. ';
199: bis_collection_utilities.put_line('Global Parameters are not setup.');
200:
201: bis_collection_utilities.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
202: --}
203: END IF;

Line 201: bis_collection_utilities.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');

197: retcode := g_error;
198: errbuf := 'Please check log file for details. ';
199: bis_collection_utilities.put_line('Global Parameters are not setup.');
200:
201: bis_collection_utilities.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
202: --}
203: END IF;
204:
205: bis_collection_utilities.put_line('Exit check_setup_globals() ' ||

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

201: bis_collection_utilities.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
202: --}
203: END IF;
204:
205: bis_collection_utilities.put_line('Exit check_setup_globals() ' ||
206: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
207:
208: EXCEPTION
209: WHEN OTHERS THEN

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

210: --{
211: retcode := SQLCODE;
212: errbuf := 'ERROR in OPI_DBI_RES_PKG.CHECK_SETUP_GLOBALS ' ||
213: substr(SQLERRM, 1,200);
214: bis_collection_utilities.put_line('Error Number: ' || retcode);
215: bis_collection_utilities.put_line('Error Message: ' || errbuf);
216: --}
217: END check_setup_globals;
218:

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

211: retcode := SQLCODE;
212: errbuf := 'ERROR in OPI_DBI_RES_PKG.CHECK_SETUP_GLOBALS ' ||
213: substr(SQLERRM, 1,200);
214: bis_collection_utilities.put_line('Error Number: ' || retcode);
215: bis_collection_utilities.put_line('Error Message: ' || errbuf);
216: --}
217: END check_setup_globals;
218:
219:

Line 393: bis_collection_utilities.put_line('Enter get_res_conversion_rate() ' ||

389:
390: BEGIN
391:
392:
393: bis_collection_utilities.put_line('Enter get_res_conversion_rate() ' ||
394: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
395:
396: -- initialization block
397: l_pri_sec_curr_same := 0;

Line 504: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

500: IF (invalid_rates_exist_csr%FOUND) THEN
501: --{
502: -- there are missing rates - prepare to report them.
503: no_currency_rate_flag := 1;
504: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
505:
506: l_stmt_num := 60;
507: FOR get_missing_rates_rec IN get_missing_rates_c (
508: l_pri_sec_curr_same,

Line 515: BIS_COLLECTION_UTILITIES.writemissingrate (

511: g_secondary_currency_code,
512: g_secondary_rate_type)
513: LOOP
514:
515: BIS_COLLECTION_UTILITIES.writemissingrate (
516: get_missing_rates_rec.rate_type,
517: get_missing_rates_rec.func_currency_code,
518: get_missing_rates_rec.curr_code,
519: get_missing_rates_rec.transaction_date);

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

526:
527: l_stmt_num := 70; /* check no_currency_rate_flag */
528: IF (no_currency_rate_flag = 1) THEN /* missing rate found */
529: --{
530: bis_collection_utilities.put_line('ERROR: Please setup conversion rate for all missing rates reported');
531:
532: retcode := g_error;
533: --}
534: END IF;

Line 536: bis_collection_utilities.put_line('Exit get_res_conversion_rate() ' ||

532: retcode := g_error;
533: --}
534: END IF;
535:
536: bis_collection_utilities.put_line('Exit get_res_conversion_rate() ' ||
537: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
538: return;
539:
540: EXCEPTION

Line 548: bis_collection_utilities.put_line('opi_dbi_res_pkg.get_res_conversion_rate - Error at statement ('

544: retcode := SQLCODE;
545: errbuf := 'REPORT_MISSING_RATE (' || to_char(l_stmt_num)
546: || '): '|| substr(SQLERRM, 1,200);
547:
548: bis_collection_utilities.put_line('opi_dbi_res_pkg.get_res_conversion_rate - Error at statement ('
549: || to_char(l_stmt_num) || ')');
550:
551: bis_collection_utilities.put_line('Error Number: ' || retcode );
552: bis_collection_utilities.put_line('Error Message: ' || errbuf );

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

547:
548: bis_collection_utilities.put_line('opi_dbi_res_pkg.get_res_conversion_rate - Error at statement ('
549: || to_char(l_stmt_num) || ')');
550:
551: bis_collection_utilities.put_line('Error Number: ' || retcode );
552: bis_collection_utilities.put_line('Error Message: ' || errbuf );
553: --}
554: END get_res_conversion_rate;
555:

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

548: bis_collection_utilities.put_line('opi_dbi_res_pkg.get_res_conversion_rate - Error at statement ('
549: || to_char(l_stmt_num) || ')');
550:
551: bis_collection_utilities.put_line('Error Number: ' || retcode );
552: bis_collection_utilities.put_line('Error Message: ' || errbuf );
553: --}
554: END get_res_conversion_rate;
555:
556:

Line 578: bis_collection_utilities.put_line('Enter initial_opi_res_avail() ' ||

574: l_count NUMBER;
575:
576: BEGIN
577:
578: bis_collection_utilities.put_line('Enter initial_opi_res_avail() ' ||
579: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
580:
581: retcode := g_ok;
582: l_stmt_num := 10;

Line 643: bis_collection_utilities.put_line('24 hr available resource '|| l_count ||

639: l_count := sql%rowcount;
640:
641: commit;
642:
643: bis_collection_utilities.put_line('24 hr available resource '|| l_count ||
644: ' rows into stg, completed at ' ||
645: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
646:
647: l_stmt_num := 20;

Line 725: bis_collection_utilities.put_line('shift based available resource '||

721:
722: l_count := sql%rowcount;
723:
724: COMMIT;
725: bis_collection_utilities.put_line('shift based available resource '||
726: l_count ||' rows into stg, completed at ' ||
727: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
728:
729: bis_collection_utilities.put_line('initial_opi_res_avail() ' ||

Line 729: bis_collection_utilities.put_line('initial_opi_res_avail() ' ||

725: bis_collection_utilities.put_line('shift based available resource '||
726: l_count ||' rows into stg, completed at ' ||
727: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
728:
729: bis_collection_utilities.put_line('initial_opi_res_avail() ' ||
730: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
731:
732: EXCEPTION WHEN OTHERS THEN
733: --{

Line 739: bis_collection_utilities.put_line('Exception in initial_opi_res_avail ' || errbuf );

735: Retcode:= SQLCODE;
736:
737: ROLLBACK;
738:
739: bis_collection_utilities.put_line('Exception in initial_opi_res_avail ' || errbuf );
740: --}
741: END initial_opi_res_avail;
742:
743:

Line 760: bis_collection_utilities.put_line('Enter initial_opi_res_actual() ' ||

756: l_count number;
757:
758: BEGIN
759:
760: bis_collection_utilities.put_line('Enter initial_opi_res_actual() ' ||
761: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
762:
763: retcode := g_ok;
764:

Line 836: bis_collection_utilities.put_line('resource actual '|| l_count ||

832: wt.primary_item_id;
833:
834: l_count := sql%rowcount;
835:
836: bis_collection_utilities.put_line('resource actual '|| l_count ||
837: ' rows into stg, completed at ' ||
838: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
839:
840: bis_collection_utilities.put_line('Exit initial_opi_res_actual() ' ||

Line 840: bis_collection_utilities.put_line('Exit initial_opi_res_actual() ' ||

836: bis_collection_utilities.put_line('resource actual '|| l_count ||
837: ' rows into stg, completed at ' ||
838: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
839:
840: bis_collection_utilities.put_line('Exit initial_opi_res_actual() ' ||
841: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
842:
843: COMMIT;
844:

Line 852: bis_collection_utilities.put_line('Exception in initial_opi_res_actual ' || errbuf );

848: Retcode:= SQLCODE;
849:
850: ROLLBACK;
851:
852: bis_collection_utilities.put_line('Exception in initial_opi_res_actual ' || errbuf );
853: --}
854:
855: END initial_opi_res_actual;
856:

Line 881: bis_collection_utilities.put_line('Enter incremental_opi_res_avail() ' ||

877: l_end_date date;
878:
879: BEGIN
880:
881: bis_collection_utilities.put_line('Enter incremental_opi_res_avail() ' ||
882: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
883:
884: retcode := g_ok;
885:

Line 952: bis_collection_utilities.put_line('24 hr available resource '|| l_count ||

948: ;
949:
950: l_count := sql%rowcount;
951:
952: bis_collection_utilities.put_line('24 hr available resource '|| l_count ||
953: ' rows into stg, completed at ' ||
954: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
955:
956: l_stmt_num := 20;

Line 1033: bis_collection_utilities.put_line('shift based available resource '||

1029: bsd.shift_date;
1030:
1031: l_count := sql%rowcount;
1032:
1033: bis_collection_utilities.put_line('shift based available resource '||
1034: l_count ||' rows into stg, completed at ' ||
1035: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1036:
1037: bis_collection_utilities.put_line('Exit incremental_opi_res_avail() ' ||

Line 1037: bis_collection_utilities.put_line('Exit incremental_opi_res_avail() ' ||

1033: bis_collection_utilities.put_line('shift based available resource '||
1034: l_count ||' rows into stg, completed at ' ||
1035: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1036:
1037: bis_collection_utilities.put_line('Exit incremental_opi_res_avail() ' ||
1038: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1039:
1040: EXCEPTION WHEN OTHERS THEN
1041: --{

Line 1047: bis_collection_utilities.put_line('Exception in incremental_opi_res_avail ' || errbuf );

1043: Retcode:= SQLCODE;
1044:
1045: ROLLBACK;
1046:
1047: bis_collection_utilities.put_line('Exception in incremental_opi_res_avail ' || errbuf );
1048: --}
1049: END incremental_opi_res_avail;
1050:
1051:

Line 1069: bis_collection_utilities.put_line('Enter incremental_opi_res_actual() ' ||

1065: l_count number;
1066:
1067: BEGIN
1068:
1069: bis_collection_utilities.put_line('Enter incremental_opi_res_actual() ' ||
1070: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1071:
1072: retcode := g_ok;
1073:

Line 1147: bis_collection_utilities.put_line('incremental load of actual resource '||

1143: wt.primary_item_id;
1144:
1145: l_count := sql%rowcount;
1146:
1147: bis_collection_utilities.put_line('incremental load of actual resource '||
1148: l_count ||' rows into stg, completed at ' ||
1149: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1150:
1151: bis_collection_utilities.put_line('Exit incremental_opi_res_actual() ' ||

Line 1151: bis_collection_utilities.put_line('Exit incremental_opi_res_actual() ' ||

1147: bis_collection_utilities.put_line('incremental load of actual resource '||
1148: l_count ||' rows into stg, completed at ' ||
1149: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1150:
1151: bis_collection_utilities.put_line('Exit incremental_opi_res_actual() ' ||
1152: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1153:
1154: EXCEPTION WHEN OTHERS THEN
1155: --{

Line 1161: bis_collection_utilities.put_line('Exception in incremental_opi_res_actual ' || errbuf );

1157: Retcode:= SQLCODE;
1158:
1159: ROLLBACK;
1160:
1161: bis_collection_utilities.put_line('Exception in incremental_opi_res_actual ' || errbuf );
1162: --}
1163: END incremental_opi_res_actual;
1164:
1165:

Line 1183: bis_collection_utilities.put_line('Enter initial_opm_res_actual() ' ||

1179: l_rowcount NUMBER;
1180:
1181: BEGIN
1182:
1183: bis_collection_utilities.put_line('Enter initial_opm_res_actual() ' ||
1184: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1185:
1186: retcode := g_ok;
1187:

Line 1267: bis_collection_utilities.put_line('OPM Resource Actual: ' ||

1263:
1264: commit;
1265: l_rowcount := sql%rowcount;
1266:
1267: bis_collection_utilities.put_line('OPM Resource Actual: ' ||
1268: l_rowcount || ' rows initially collected into staging table at '||
1269: to_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1270:
1271: bis_collection_utilities.put_line('Exit initial_opm_res_actual() ' ||

Line 1271: bis_collection_utilities.put_line('Exit initial_opm_res_actual() ' ||

1267: bis_collection_utilities.put_line('OPM Resource Actual: ' ||
1268: l_rowcount || ' rows initially collected into staging table at '||
1269: to_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1270:
1271: bis_collection_utilities.put_line('Exit initial_opm_res_actual() ' ||
1272: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1273:
1274:
1275: EXCEPTION WHEN OTHERS THEN

Line 1282: bis_collection_utilities.put_line('Exception in initial_opm_res_actual ' || errbuf );

1278: Retcode:= SQLCODE;
1279:
1280: ROLLBACK;
1281:
1282: bis_collection_utilities.put_line('Exception in initial_opm_res_actual ' || errbuf );
1283: --}
1284: END initial_opm_res_actual;
1285:
1286:

Line 1309: bis_collection_utilities.put_line('Enter initial_opm_res_avail() ' ||

1305: l_rowcount NUMBER;
1306:
1307: BEGIN
1308:
1309: bis_collection_utilities.put_line('Enter initial_opm_res_avail() ' ||
1310: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1311:
1312: retcode := g_ok;
1313: l_stmt_num := 10;

Line 1417: bis_collection_utilities.put_line('OPM Resource Availability: ' ||

1413: l_rowcount := sql%rowcount;
1414:
1415: COMMIT;
1416:
1417: bis_collection_utilities.put_line('OPM Resource Availability: ' ||
1418: l_rowcount || ' rows initially collected into staging table at '||
1419: to_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1420:
1421: bis_collection_utilities.put_line('Exit initial_opm_res_avail() ' ||

Line 1421: bis_collection_utilities.put_line('Exit initial_opm_res_avail() ' ||

1417: bis_collection_utilities.put_line('OPM Resource Availability: ' ||
1418: l_rowcount || ' rows initially collected into staging table at '||
1419: to_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1420:
1421: bis_collection_utilities.put_line('Exit initial_opm_res_avail() ' ||
1422: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1423:
1424: EXCEPTION WHEN OTHERS THEN
1425: --{

Line 1431: bis_collection_utilities.put_line('Exception in initial_opm_res_avail ' || errbuf );

1427: retcode:= SQLCODE;
1428:
1429: ROLLBACK;
1430:
1431: bis_collection_utilities.put_line('Exception in initial_opm_res_avail ' || errbuf );
1432: --}
1433: END initial_opm_res_avail;
1434:
1435:

Line 1452: bis_collection_utilities.put_line('Enter incremental_opm_res_actual() ' ||

1448: l_rowcount NUMBER;
1449:
1450: BEGIN
1451:
1452: bis_collection_utilities.put_line('Enter incremental_opm_res_actual() ' ||
1453: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1454:
1455: retcode := g_ok;
1456:

Line 1551: bis_collection_utilities.put_line('OPM resource actuals: ' ||

1547: l_rowcount := sql%rowcount;
1548:
1549: COMMIT;
1550:
1551: bis_collection_utilities.put_line('OPM resource actuals: ' ||
1552: l_rowcount || ' rows incrementally collected into staging table at ' ||
1553: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1554:
1555: bis_collection_utilities.put_line('Exit incremental_opm_res_actual() ' ||

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

1551: bis_collection_utilities.put_line('OPM resource actuals: ' ||
1552: l_rowcount || ' rows incrementally collected into staging table at ' ||
1553: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1554:
1555: bis_collection_utilities.put_line('Exit incremental_opm_res_actual() ' ||
1556: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1557:
1558: EXCEPTION WHEN OTHERS THEN
1559: --{

Line 1565: bis_collection_utilities.put_line('Exception in incremental_opm_res_actual ' || errbuf );

1561: retcode:= SQLCODE;
1562:
1563: ROLLBACK;
1564:
1565: bis_collection_utilities.put_line('Exception in incremental_opm_res_actual ' || errbuf );
1566: --}
1567: END incremental_opm_res_actual;
1568:
1569:

Line 1594: bis_collection_utilities.put_line('Enter incremental_opm_res_avail() ' ||

1590: l_end_date DATE;
1591:
1592: BEGIN
1593:
1594: bis_collection_utilities.put_line('Enter incremental_opm_res_avail() ' ||
1595: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1596:
1597: retcode := g_ok;
1598: l_stmt_num := 10;

Line 1712: bis_collection_utilities.put_line('OPM resource availability: ' ||

1708: l_rowcount := sql%rowcount;
1709:
1710: COMMIT;
1711:
1712: bis_collection_utilities.put_line('OPM resource availability: ' ||
1713: l_rowcount || ' rows incrementally collected into staging table at ' ||
1714: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1715:
1716: bis_collection_utilities.put_line('Exit incremental_opm_res_avail() ' ||

Line 1716: bis_collection_utilities.put_line('Exit incremental_opm_res_avail() ' ||

1712: bis_collection_utilities.put_line('OPM resource availability: ' ||
1713: l_rowcount || ' rows incrementally collected into staging table at ' ||
1714: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1715:
1716: bis_collection_utilities.put_line('Exit incremental_opm_res_avail() ' ||
1717: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1718:
1719: EXCEPTION WHEN OTHERS THEN
1720: --{

Line 1726: bis_collection_utilities.put_line('Exception in incremental_opm_res_avail ' || errbuf );

1722: retcode:= SQLCODE;
1723:
1724: ROLLBACK;
1725:
1726: bis_collection_utilities.put_line('Exception in incremental_opm_res_avail ' || errbuf );
1727: --}
1728: END incremental_opm_res_avail;
1729:
1730:

Line 1749: bis_collection_utilities.put_line('Enter initial_opm_res_std() ' ||

1745: l_rowcount NUMBER;
1746:
1747: BEGIN
1748:
1749: bis_collection_utilities.put_line('Enter initial_opm_res_std() ' ||
1750: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1751:
1752: INSERT INTO opi_dbi_res_std_f (
1753: resource_id,

Line 1918: bis_collection_utilities.put_line('OPM resource std: ' ||

1914: l_rowcount := SQL%ROWCOUNT;
1915:
1916: COMMIT;
1917:
1918: bis_collection_utilities.put_line('OPM resource std: ' ||
1919: l_rowcount || ' rows initially collected into fact table at ' ||
1920: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1921:
1922: bis_collection_utilities.put_line('Exit initial_opm_res_std() ' ||

Line 1922: bis_collection_utilities.put_line('Exit initial_opm_res_std() ' ||

1918: bis_collection_utilities.put_line('OPM resource std: ' ||
1919: l_rowcount || ' rows initially collected into fact table at ' ||
1920: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1921:
1922: bis_collection_utilities.put_line('Exit initial_opm_res_std() ' ||
1923: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1924:
1925: EXCEPTION WHEN OTHERS THEN
1926:

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

1927: errbuf:= Sqlerrm;
1928: retcode:= SQLCODE;
1929:
1930: ROLLBACK;
1931: bis_collection_utilities.wrapup(p_status => FALSE,
1932: p_count => 0,
1933: p_message => 'Failed in initial_opm_res_std.');
1934:
1935: RAISE_APPLICATION_ERROR(-20000,errbuf);

Line 1956: bis_collection_utilities.put_line('Enter incremental_opm_res_std() ' ||

1952:
1953:
1954: BEGIN
1955:
1956: bis_collection_utilities.put_line('Enter incremental_opm_res_std() ' ||
1957: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1958:
1959: DELETE opi_dbi_res_std_f std
1960: WHERE (job_id, job_type)

Line 2142: bis_collection_utilities.put_line('OPM resource std: ' ||

2138: jobitem.source;
2139:
2140: l_rowcount := sql%rowcount;
2141:
2142: bis_collection_utilities.put_line('OPM resource std: ' ||
2143: l_rowcount || ' rows incrementally collected into staging table at ' ||
2144: to_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2145:
2146: bis_collection_utilities.put_line('Exit incremental_opm_res_std() ' ||

Line 2146: bis_collection_utilities.put_line('Exit incremental_opm_res_std() ' ||

2142: bis_collection_utilities.put_line('OPM resource std: ' ||
2143: l_rowcount || ' rows incrementally collected into staging table at ' ||
2144: to_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2145:
2146: bis_collection_utilities.put_line('Exit incremental_opm_res_std() ' ||
2147: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2148:
2149: EXCEPTION WHEN OTHERS THEN
2150: --{

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

2151: errbuf:= Sqlerrm;
2152: retcode:= SQLCODE;
2153:
2154: ROLLBACK;
2155: bis_collection_utilities.wrapup(p_status => FALSE,
2156: p_count => 0,
2157: p_message => 'Failed in incremental_opm_res_std.'
2158: );
2159:

Line 2213: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_RES_AVAIL_F' ) = false then

2209: l_comm_opm_avail_flag := FALSE;
2210: l_comm_opi_actual_flag := FALSE;
2211: l_comm_opm_actual_flag := FALSE;
2212:
2213: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_RES_AVAIL_F' ) = false then
2214: --{
2215: RAISE_APPLICATION_ERROR(-20000, errbuf);
2216: --}
2217: END IF;

Line 2223: bis_collection_utilities.put_line('Initial Load starts at '

2219: -- Performance tuning change
2220: execute immediate 'alter session set hash_area_size=100000000 ';
2221: execute immediate 'alter session set sort_area_size=100000000 ';
2222:
2223: bis_collection_utilities.put_line('Initial Load starts at '
2224: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2225:
2226: -- setup globals
2227: bis_collection_utilities.put_line('Setup Global Parameters ....');

Line 2227: bis_collection_utilities.put_line('Setup Global Parameters ....');

2223: bis_collection_utilities.put_line('Initial Load starts at '
2224: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2225:
2226: -- setup globals
2227: bis_collection_utilities.put_line('Setup Global Parameters ....');
2228: l_stmt_num :=10;
2229: check_setup_globals(errbuf => errbuf, retcode => retcode);
2230:
2231: IF retcode <> 0 THEN

Line 2267: bis_collection_utilities.put_line('Load discrete resource actual into staging ...');

2263:
2264: /*** Collect Actual Resource Usage Data ***/
2265:
2266: -- Load discrete actual data to Staging table
2267: bis_collection_utilities.put_line('Load discrete resource actual into staging ...');
2268:
2269: l_stmt_num := 30;
2270: initial_opi_res_actual(errbuf => errbuf, retcode => retcode);
2271:

Line 2295: bis_collection_utilities.put_line('Load process pre-r12 resource actual into staging ... ');

2291: END;
2292:
2293: IF (g_global_start_date < l_r12_mgr_date) THEN
2294: --{
2295: bis_collection_utilities.put_line('Load process pre-r12 resource actual into staging ... ');
2296: opi_dbi_pre_r12_res_pkg.pre_r12_opm_res_actual(errbuf => errbuf, retcode => retcode);
2297: --}
2298: END IF;
2299:

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

2301: l_stmt_num := 35;
2302:
2303: -- Call API to load ledger data into Global temp table
2304: -- This temp table will be joined to extract process adjustments
2305: bis_collection_utilities.put_line('Loading Ledger data into temp table');
2306: opi_dbi_bounds_pkg.load_opm_org_ledger_data;
2307:
2308: -- Committing the data. Since the temp table is made with On Commit preserve rows
2309: -- there will be no problem.

Line 2313: bis_collection_utilities.put_line('Load process resource actual into staging ... ');

2309: -- there will be no problem.
2310: commit;
2311:
2312: l_stmt_num := 40;
2313: bis_collection_utilities.put_line('Load process resource actual into staging ... ');
2314: initial_opm_res_actual(errbuf => errbuf, retcode => retcode);
2315:
2316: IF retcode <> 0 THEN
2317: --{

Line 2359: bis_collection_utilities.put_line('Load discrete res avail into staging ');

2355: END;
2356:
2357:
2358: -- Load discrete availability data into Staging table
2359: bis_collection_utilities.put_line('Load discrete res avail into staging ');
2360:
2361: l_stmt_num := 60;
2362: initial_opi_res_avail(p_start_date => l_opi_start_date,
2363: p_end_date => l_opi_end_date,

Line 2375: bis_collection_utilities.put_line('Load process res avail into staging ');

2371: END IF;
2372:
2373:
2374: -- Load process availability data into Staging table
2375: bis_collection_utilities.put_line('Load process res avail into staging ');
2376:
2377: l_stmt_num := 70;
2378: initial_opm_res_avail(p_start_date => l_opm_start_date,
2379: p_end_date => l_opm_end_date,

Line 2410: bis_collection_utilities.put_line('Initially load actual data from staging to actual fact ...');

2406: --{
2407: -- load Actual data into Fact
2408: l_stmt_num := 80;
2409:
2410: bis_collection_utilities.put_line('Initially load actual data from staging to actual fact ...');
2411:
2412: INSERT /*+ append parallel(c) */
2413: INTO opi_dbi_res_actual_f c (
2414: resource_id,

Line 2486: bis_collection_utilities.put_line('Load res actual ' || l_row_count ||

2482: stg.uom;
2483:
2484: l_row_count := sql%rowcount;
2485:
2486: bis_collection_utilities.put_line('Load res actual ' || l_row_count ||
2487: ' rows into FACT '
2488: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2489: --}
2490: ELSE

Line 2492: bis_collection_utilities.put_line('Failed to load res actual data to fact');

2488: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2489: --}
2490: ELSE
2491: --{
2492: bis_collection_utilities.put_line('Failed to load res actual data to fact');
2493: -->
2494: END IF;
2495:
2496:

Line 2503: bis_collection_utilities.put_line('Initially load actual and avail data from staging to avail fact ...');

2499: IF l_error_flag <> TRUE THEN
2500: --{
2501: l_stmt_num := 90;
2502:
2503: bis_collection_utilities.put_line('Initially load actual and avail data from staging to avail fact ...');
2504:
2505: INSERT /*+ append parallel(b) */
2506: INTO opi_dbi_res_avail_f b (
2507: resource_id,

Line 2630: bis_collection_utilities.put_line('Load res avail into FACT ' ||

2626: res.organization_id,
2627: res.transaction_date;
2628:
2629: l_row_count := SQL%rowcount;
2630: bis_collection_utilities.put_line('Load res avail into FACT ' ||
2631: l_row_count || ' rows, completed at '
2632: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2633:
2634:

Line 2660: bis_collection_utilities.WRAPUP(p_status => TRUE,

2656:
2657: execute immediate 'truncate table ' || l_opi_schema
2658: || '.opi_dbi_res_actual_stg ';
2659:
2660: bis_collection_utilities.WRAPUP(p_status => TRUE,
2661: p_count => l_row_count,
2662: p_message => 'successful in initial_load_res_utl.');
2663: --}
2664: ELSE

Line 2671: bis_collection_utilities.put_line('Error in initial_load_res_utl at ' || l_stmt_num);

2667: errbuf := 'Error in report to common modules. Please check log file for details.';
2668:
2669: rollback;
2670:
2671: bis_collection_utilities.put_line('Error in initial_load_res_utl at ' || l_stmt_num);
2672: bis_collection_utilities.wrapup(p_status => FALSE,
2673: p_count => 0,
2674: p_message => 'failed in initial_load_res_utl.'
2675: );

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

2668:
2669: rollback;
2670:
2671: bis_collection_utilities.put_line('Error in initial_load_res_utl at ' || l_stmt_num);
2672: bis_collection_utilities.wrapup(p_status => FALSE,
2673: p_count => 0,
2674: p_message => 'failed in initial_load_res_utl.'
2675: );
2676: --}

Line 2683: bis_collection_utilities.put_line('Error in initial_load_res_utl at ' || l_stmt_num);

2679: --{
2680: rollback;
2681: retcode := g_error ;
2682: errbuf := 'Please check log file for details.';
2683: bis_collection_utilities.put_line('Error in initial_load_res_utl at ' || l_stmt_num);
2684: bis_collection_utilities.wrapup(p_status => FALSE,
2685: p_count => 0,
2686: p_message => 'failed in initial_load_res_utl.');
2687: --}

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

2680: rollback;
2681: retcode := g_error ;
2682: errbuf := 'Please check log file for details.';
2683: bis_collection_utilities.put_line('Error in initial_load_res_utl at ' || l_stmt_num);
2684: bis_collection_utilities.wrapup(p_status => FALSE,
2685: p_count => 0,
2686: p_message => 'failed in initial_load_res_utl.');
2687: --}
2688: END IF;

Line 2690: bis_collection_utilities.put_line('Exit initial_load_res_utl() ' ||

2686: p_message => 'failed in initial_load_res_utl.');
2687: --}
2688: END IF;
2689:
2690: bis_collection_utilities.put_line('Exit initial_load_res_utl() ' ||
2691: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2692:
2693:
2694: EXCEPTION

Line 2698: bis_collection_utilities.put_line('Schema information was not found.');

2694: EXCEPTION
2695: --{
2696: WHEN SCHEMA_INFO_NOT_FOUND THEN
2697: --{
2698: bis_collection_utilities.put_line('Schema information was not found.');
2699: --}
2700: WHEN OTHERS THEN
2701: --{
2702: Errbuf:= Sqlerrm;

Line 2705: bis_collection_utilities.put_line('Error in initial_load_res_utl at ' || l_stmt_num);

2701: --{
2702: Errbuf:= Sqlerrm;
2703: Retcode:= SQLCODE;
2704: ROLLBACK;
2705: bis_collection_utilities.put_line('Error in initial_load_res_utl at ' || l_stmt_num);
2706: bis_collection_utilities.wrapup(p_status => FALSE,
2707: p_count => 0,
2708: p_message => 'failed in initial_load_res_utl.'
2709: );

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

2702: Errbuf:= Sqlerrm;
2703: Retcode:= SQLCODE;
2704: ROLLBACK;
2705: bis_collection_utilities.put_line('Error in initial_load_res_utl at ' || l_stmt_num);
2706: bis_collection_utilities.wrapup(p_status => FALSE,
2707: p_count => 0,
2708: p_message => 'failed in initial_load_res_utl.'
2709: );
2710:

Line 2732: bis_collection_utilities.put_line('Enter incremental_opi_res_std() ' ||

2728: l_count number;
2729:
2730: BEGIN
2731:
2732: bis_collection_utilities.put_line('Enter incremental_opi_res_std() ' ||
2733: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2734:
2735: retcode := 0;
2736:

Line 2853: bis_collection_utilities.put_line('Load OPI res std into FACT ' ||

2849:
2850:
2851: l_count := sql%rowcount;
2852:
2853: bis_collection_utilities.put_line('Load OPI res std into FACT ' ||
2854: l_count || ' rows, completed at '
2855: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2856:
2857: bis_collection_utilities.put_line('Exit incremental_opi_res_std() ' ||

Line 2857: bis_collection_utilities.put_line('Exit incremental_opi_res_std() ' ||

2853: bis_collection_utilities.put_line('Load OPI res std into FACT ' ||
2854: l_count || ' rows, completed at '
2855: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2856:
2857: bis_collection_utilities.put_line('Exit incremental_opi_res_std() ' ||
2858: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2859:
2860: EXCEPTION WHEN OTHERS THEN
2861: --{

Line 2865: bis_collection_utilities.put_line('Exception in incremental_opi_res_std ' || sqlerrm );

2861: --{
2862: Errbuf:= Sqlerrm;
2863: Retcode:= SQLCODE;
2864:
2865: bis_collection_utilities.put_line('Exception in incremental_opi_res_std ' || sqlerrm );
2866: --}
2867: END incremental_opi_res_std;
2868:
2869:

Line 2911: bis_collection_utilities.put_line('Enter incremental_load_res_utl() ' ||

2907: NO_DATA_FOUND exception;
2908:
2909: BEGIN
2910:
2911: bis_collection_utilities.put_line('Enter incremental_load_res_utl() ' ||
2912: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2913:
2914: -- initialization block
2915: l_error_flag := FALSE;

Line 2922: IF bis_collection_utilities.setup( 'OPI_DBI_RES_AVAIL_F' ) = false THEN

2918: l_comm_opi_actual_flag := FALSE;
2919: l_comm_opm_actual_flag := FALSE;
2920:
2921:
2922: IF bis_collection_utilities.setup( 'OPI_DBI_RES_AVAIL_F' ) = false THEN
2923: --{
2924: RAISE_APPLICATION_ERROR(-20000, errbuf);
2925: --}
2926: END IF;

Line 2930: bis_collection_utilities.put_line('Setup global parameters ...');

2926: END IF;
2927:
2928:
2929: -- setup globals
2930: bis_collection_utilities.put_line('Setup global parameters ...');
2931:
2932: l_stmt_num := 10;
2933:
2934: check_setup_globals(errbuf => errbuf, retcode => retcode);

Line 2969: bis_collection_utilities.put_line('Load discrete resource std into staging ...');

2965:
2966: /*** Collect Standard Resource Usage ***/
2967:
2968: -- Incrementally load resource standard usage fact for discrete
2969: bis_collection_utilities.put_line('Load discrete resource std into staging ...');
2970: l_stmt_num := 30;
2971:
2972: incremental_opi_res_std(errbuf => errbuf, retcode => retcode);
2973:

Line 2982: bis_collection_utilities.put_line('Load process resource std into staging ...');

2978: END IF;
2979:
2980:
2981: -- Incrementally load resource standard usage fact for process
2982: bis_collection_utilities.put_line('Load process resource std into staging ...');
2983: l_stmt_num := 40;
2984:
2985: incremental_opm_res_std(errbuf => errbuf, retcode => retcode);
2986:

Line 3009: bis_collection_utilities.put_line('Load discrete res actual into staging ... ');

3005: /*** Collect Actual Resource Usage ***/
3006:
3007: -- Load discrete resource actual data into Staging table
3008:
3009: bis_collection_utilities.put_line('Load discrete res actual into staging ... ');
3010: l_stmt_num := 60;
3011: incremental_opi_res_actual(errbuf => errbuf, retcode => retcode);
3012:
3013: IF retcode <> 0 THEN

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

3023: l_stmt_num := 65;
3024:
3025: -- Call API to load ledger data into Global temp table
3026: -- This temp table will be joined to extract process adjustments
3027: bis_collection_utilities.put_line ('Loading Ledger data into temp table');
3028: opi_dbi_bounds_pkg.load_opm_org_ledger_data;
3029:
3030: -- Committing the data. Since the temp table is made with On Commit preserve rows
3031: -- there will be no problem.

Line 3034: bis_collection_utilities.put_line('Load process res actual into staging ... ');

3030: -- Committing the data. Since the temp table is made with On Commit preserve rows
3031: -- there will be no problem.
3032: commit;
3033:
3034: bis_collection_utilities.put_line('Load process res actual into staging ... ');
3035: l_stmt_num := 70;
3036: incremental_opm_res_actual(errbuf => errbuf, retcode => retcode);
3037:
3038: IF retcode <> 0 THEN

Line 3100: bis_collection_utilities.put_line('Load discrete res avail into staging ... ');

3096: --}
3097: END IF;
3098:
3099: -- Load discrete availability data into Staging table
3100: bis_collection_utilities.put_line('Load discrete res avail into staging ... ');
3101: l_stmt_num := 100;
3102:
3103: incremental_opi_res_avail(p_start_date => l_opi_start_date,
3104: p_end_date => l_opi_end_date,

Line 3116: bis_collection_utilities.put_line('Load process res avail into staging ... ');

3112: END IF;
3113:
3114:
3115: -- Load process availability data into Staging table
3116: bis_collection_utilities.put_line('Load process res avail into staging ... ');
3117: l_stmt_num := 110;
3118:
3119: incremental_opm_res_avail(p_start_date => l_opm_start_date,
3120: p_end_date => l_opm_end_date,

Line 3150: bis_collection_utilities.put_line('Merge res actual from staging to actual fact ...');

3146:
3147: -- Incrementally load data into Actual Fact
3148: IF l_error_flag <> TRUE THEN
3149: --{
3150: bis_collection_utilities.put_line('Merge res actual from staging to actual fact ...');
3151: l_stmt_num := 120;
3152:
3153: MERGE INTO opi_dbi_res_actual_f f
3154: USING (

Line 3267: bis_collection_utilities.put_line('Load resource actual into FACT ' ||

3263: g_request_id);
3264:
3265: l_count := sql%rowcount;
3266:
3267: bis_collection_utilities.put_line('Load resource actual into FACT ' ||
3268: l_count || ' rows, completed at '
3269: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
3270: --}
3271: END IF;

Line 3277: bis_collection_utilities.put_line('Merge res actual and avail from staging to avail fact ...');

3273:
3274: -- Merge Avail and Actual data in to Avail Fact
3275: IF l_error_flag <> TRUE THEN
3276: --{
3277: bis_collection_utilities.put_line('Merge res actual and avail from staging to avail fact ...');
3278: l_stmt_num := 130;
3279:
3280: MERGE /*+ index(f, OPI_DBI_RES_AVAIL_F_N1) */
3281: INTO opi_dbi_res_avail_f f

Line 3461: bis_collection_utilities.put_line('Load resource avail into FACT ' || l_count || ' rows, completed at '

3457: g_request_id);
3458:
3459: l_count := SQL%rowcount;
3460:
3461: bis_collection_utilities.put_line('Load resource avail into FACT ' || l_count || ' rows, completed at '
3462: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
3463:
3464: -- update common modules for OPI
3465: l_comm_opi_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,

Line 3492: bis_collection_utilities.WRAPUP( p_status => TRUE,

3488: execute immediate 'truncate table ' || l_opi_schema
3489: || '.opi_dbi_res_actual_stg ';
3490:
3491:
3492: bis_collection_utilities.WRAPUP( p_status => TRUE,
3493: p_count => l_row_count,
3494: p_message => 'successful in incremental_load_res_utl.'
3495: );
3496: --}

Line 3503: bis_collection_utilities.put_line('Error in incremental_load_res_utl at ' || l_stmt_num);

3499: rollback;
3500: retcode := g_error ;
3501: errbuf := 'Error in report to common modules. Please check log file for details.';
3502:
3503: bis_collection_utilities.put_line('Error in incremental_load_res_utl at ' || l_stmt_num);
3504: bis_collection_utilities.wrapup(p_status => FALSE,
3505: p_count => 0,
3506: p_message => 'failed in incremental_load_res_utl.'
3507: );

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

3500: retcode := g_error ;
3501: errbuf := 'Error in report to common modules. Please check log file for details.';
3502:
3503: bis_collection_utilities.put_line('Error in incremental_load_res_utl at ' || l_stmt_num);
3504: bis_collection_utilities.wrapup(p_status => FALSE,
3505: p_count => 0,
3506: p_message => 'failed in incremental_load_res_utl.'
3507: );
3508: --}

Line 3517: bis_collection_utilities.put_line('Error in incremental_load_res_utl at ' || l_stmt_num);

3513: rollback;
3514: retcode := g_error;
3515: errbuf := 'Please check log file for details.';
3516:
3517: bis_collection_utilities.put_line('Error in incremental_load_res_utl at ' || l_stmt_num);
3518: bis_collection_utilities.wrapup(p_status => FALSE,
3519: p_count => 0,
3520: p_message => 'failed in incremental_load_res_utl.'
3521: );

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

3514: retcode := g_error;
3515: errbuf := 'Please check log file for details.';
3516:
3517: bis_collection_utilities.put_line('Error in incremental_load_res_utl at ' || l_stmt_num);
3518: bis_collection_utilities.wrapup(p_status => FALSE,
3519: p_count => 0,
3520: p_message => 'failed in incremental_load_res_utl.'
3521: );
3522: --}

Line 3525: bis_collection_utilities.put_line('Exit incremental_load_res_utl() ' ||

3521: );
3522: --}
3523: END IF;
3524:
3525: bis_collection_utilities.put_line('Exit incremental_load_res_utl() ' ||
3526: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
3527:
3528: EXCEPTION
3529: --{

Line 3532: bis_collection_utilities.put_line('Schema Information was not found.');

3528: EXCEPTION
3529: --{
3530: WHEN SCHEMA_INFO_NOT_FOUND THEN
3531: --{
3532: bis_collection_utilities.put_line('Schema Information was not found.');
3533: errbuf := Sqlerrm;
3534: Retcode := g_ERROR;
3535: --}
3536: WHEN OTHERS THEN

Line 3543: bis_collection_utilities.put_line('Error in incremental_load_res_utl at ' || l_stmt_num);

3539: Retcode:= SQLCODE;
3540:
3541: ROLLBACK;
3542:
3543: bis_collection_utilities.put_line('Error in incremental_load_res_utl at ' || l_stmt_num);
3544: bis_collection_utilities.wrapup(p_status => FALSE,
3545: p_count => 0,
3546: p_message => 'failed in incremental_load_res_utl.'
3547: );

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

3540:
3541: ROLLBACK;
3542:
3543: bis_collection_utilities.put_line('Error in incremental_load_res_utl at ' || l_stmt_num);
3544: bis_collection_utilities.wrapup(p_status => FALSE,
3545: p_count => 0,
3546: p_message => 'failed in incremental_load_res_utl.'
3547: );
3548:

Line 3581: bis_collection_utilities.put_line('Enter initial_load_res_std() ' ||

3577: SCHEMA_INFO_NOT_FOUND exception;
3578:
3579: BEGIN
3580:
3581: bis_collection_utilities.put_line('Enter initial_load_res_std() ' ||
3582: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
3583:
3584: -- initialization block
3585: l_error_flag := FALSE;

Line 3587: IF bis_collection_utilities.setup( 'OPI_DBI_RES_STD_F' ) = false THEN

3583:
3584: -- initialization block
3585: l_error_flag := FALSE;
3586:
3587: IF bis_collection_utilities.setup( 'OPI_DBI_RES_STD_F' ) = false THEN
3588: --{
3589: RAISE_APPLICATION_ERROR(-20000, errbuf);
3590: --}
3591: END IF;

Line 3600: bis_collection_utilities.put_line('Setup global parameters ...');

3596:
3597:
3598: -- setup globals
3599: l_stmt_num := 10;
3600: bis_collection_utilities.put_line('Setup global parameters ...');
3601:
3602: check_setup_globals(errbuf => errbuf, retcode => retcode);
3603:
3604: IF retcode <> 0 THEN

Line 3627: bis_collection_utilities.put_line('Load discrete res std into staging ...');

3623:
3624: -- If no errors, load discrete data to fact table
3625: IF l_error_flag = FALSE THEN
3626: --{
3627: bis_collection_utilities.put_line('Load discrete res std into staging ...');
3628:
3629: INSERT /*+ append parallel(opi_dbi_res_std_f) */
3630: INTO opi_dbi_res_std_f (
3631: resource_id,

Line 3748: bis_collection_utilities.put_line('Load OPI resource standard into FACT ' ||

3744: l_row_count := SQL%rowcount;
3745:
3746: COMMIT;
3747:
3748: bis_collection_utilities.put_line('Load OPI resource standard into FACT ' ||
3749: l_row_count || ' rows, completed at '
3750: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
3751:
3752:

Line 3754: bis_collection_utilities.put_line('Load process res std into staging ...');

3750: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
3751:
3752:
3753: -- load opm res std table
3754: bis_collection_utilities.put_line('Load process res std into staging ...');
3755:
3756: initial_opm_res_std (errbuf => errbuf,
3757: retcode => retcode,
3758: p_degree => p_degree);

Line 3772: bis_collection_utilities.WRAPUP( p_status => TRUE,

3768: COMMIT;
3769: --}
3770: END IF ;
3771:
3772: bis_collection_utilities.WRAPUP( p_status => TRUE,
3773: p_count => l_row_count,
3774: p_message => 'successful in initial_load_res_std.');
3775:
3776:

Line 3781: bis_collection_utilities.put_line('Schema information was not found.');

3777: EXCEPTION
3778: --{
3779: WHEN SCHEMA_INFO_NOT_FOUND THEN
3780: --{
3781: bis_collection_utilities.put_line('Schema information was not found.');
3782: --}
3783: WHEN OTHERS THEN
3784: --{
3785: Errbuf:= Sqlerrm;

Line 3789: bis_collection_utilities.put_line('Error in initial_load_res_std at ' || l_stmt_num);

3785: Errbuf:= Sqlerrm;
3786: Retcode:= SQLCODE;
3787:
3788: ROLLBACK;
3789: bis_collection_utilities.put_line('Error in initial_load_res_std at ' || l_stmt_num);
3790: bis_collection_utilities.wrapup(p_status => FALSE,
3791: p_count => 0,
3792: p_message => 'failed in initial_load_res_std'
3793: );

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

3786: Retcode:= SQLCODE;
3787:
3788: ROLLBACK;
3789: bis_collection_utilities.put_line('Error in initial_load_res_std at ' || l_stmt_num);
3790: bis_collection_utilities.wrapup(p_status => FALSE,
3791: p_count => 0,
3792: p_message => 'failed in initial_load_res_std'
3793: );
3794: