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.ENI_DBI_UCO_LOAD_PKG dependencies on ENI_DBI_UTIL_PKG

Line 62: eni_dbi_util_pkg.log('Inserted ' ||sql%ROWCOUNT || ' currency rates into rates table');

58: FROM (SELECT DISTINCT currency_code ,
59: effective_date FROM eni_dbi_item_cost_stg);
60: END IF;
61:
62: eni_dbi_util_pkg.log('Inserted ' ||sql%ROWCOUNT || ' currency rates into rates table');
63:
64: commit;
65:
66: EXCEPTION

Line 72: eni_dbi_util_pkg.log('Error Number: ' || to_char(l_err_num));

68: rollback;
69: l_err_num := SQLCODE;
70: l_err_msg := 'POPULATE_RATES_TABLE: ' || substr(l_err_num, 1,200);
71:
72: eni_dbi_util_pkg.log('Error Number: ' || to_char(l_err_num));
73: eni_dbi_util_pkg.log('Error Message: ' || l_err_msg);
74: RAISE;
75: END populate_rates_table;
76:

Line 73: eni_dbi_util_pkg.log('Error Message: ' || l_err_msg);

69: l_err_num := SQLCODE;
70: l_err_msg := 'POPULATE_RATES_TABLE: ' || substr(l_err_num, 1,200);
71:
72: eni_dbi_util_pkg.log('Error Number: ' || to_char(l_err_num));
73: eni_dbi_util_pkg.log('Error Message: ' || l_err_msg);
74: RAISE;
75: END populate_rates_table;
76:
77:

Line 101: eni_dbi_util_pkg.log('Truncating the cost staging, rates staging and cost fact tables');

97: IF(FND_INSTALLATION.GET_APP_INFO('ENI', l_status, l_industry, g_eni_schema))
98: THEN NULL;
99: END IF;
100:
101: eni_dbi_util_pkg.log('Truncating the cost staging, rates staging and cost fact tables');
102: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_item_cost_f';
103: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_item_cost_stg';
104: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
105:

Line 113: eni_dbi_util_pkg.log('The date range for Initial cost collection is ' || l_start_date || ' to ' || l_end_date);

109: Bug: 4956685 Initial load should pick all records from global start date to sysdate
110: l_start_date := trunc(TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS'));
111: l_end_date := trunc(TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS'));
112: **/
113: eni_dbi_util_pkg.log('The date range for Initial cost collection is ' || l_start_date || ' to ' || l_end_date);
114:
115: if BIS_COLLECTION_UTILITIES.SETUP(
116: p_object_name => 'eni_dbi_item_cost_f',
117: p_parallel => 1) = false then

Line 150: eni_dbi_util_pkg.log('There are Standard Costing orgs, hence starting initial cost collection into stage table for them');

146: from sys.dual;
147:
148: -- Get the cost history for standard costing orgs from cst_elemental_costs
149: if (l_exists_sc_orgs = 1) then
150: eni_dbi_util_pkg.log('There are Standard Costing orgs, hence starting initial cost collection into stage table for them');
151:
152: insert /*+ append parallel(a) */ into eni_dbi_item_cost_stg a
153: (effective_date,
154: inventory_item_id,

Line 216: eni_dbi_util_pkg.log('There are Avg/LIFO/FIFO Costing orgs, hence starting initial cost collection into stage table for them');

212:
213: -- Get the cost history for average/LIFO/FIFO costing orgs from mtl_cst_actual_cost_details.
214: if (l_exists_ac_orgs = 1) then
215:
216: eni_dbi_util_pkg.log('There are Avg/LIFO/FIFO Costing orgs, hence starting initial cost collection into stage table for them');
217:
218: insert /*+ append parallel(a) */ into eni_dbi_item_cost_stg a
219: (effective_date,
220: inventory_item_id, organization_id, item_cost, material_cost,

Line 280: eni_dbi_util_pkg.log('Committing initial cost collection into staging table');

276:
277:
278: end if;
279:
280: eni_dbi_util_pkg.log('Committing initial cost collection into staging table');
281: COMMIT;
282:
283: eni_dbi_util_pkg.log('Retreiving currency conversion rates into rates table');
284: populate_rates_table('INITIAL');

Line 283: eni_dbi_util_pkg.log('Retreiving currency conversion rates into rates table');

279:
280: eni_dbi_util_pkg.log('Committing initial cost collection into staging table');
281: COMMIT;
282:
283: eni_dbi_util_pkg.log('Retreiving currency conversion rates into rates table');
284: populate_rates_table('INITIAL');
285:
286: eni_dbi_util_pkg.log('Checking if any missing conversion rates are present');
287:

Line 286: eni_dbi_util_pkg.log('Checking if any missing conversion rates are present');

282:
283: eni_dbi_util_pkg.log('Retreiving currency conversion rates into rates table');
284: populate_rates_table('INITIAL');
285:
286: eni_dbi_util_pkg.log('Checking if any missing conversion rates are present');
287:
288: l_report_missing_rate := report_missing_rate();
289:
290: IF (l_report_missing_rate = 0) THEN -- initial collection completed normally.

Line 333: eni_dbi_util_pkg.log('Initial cost collection Complete and Successful');

329:
330: COMMIT;
331:
332:
333: eni_dbi_util_pkg.log('Initial cost collection Complete and Successful');
334: o_error_code := 0;
335: o_error_msg := 'Initial Cost Collection is Complete and Successful';
336: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_item_cost_stg';
337: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';

Line 369: eni_dbi_util_pkg.log('Initial cost collection has completed with errors in the conversion rates.');

365: p_attribute4 => l_processed_cost_id
366: );
367:
368: ELSE
369: eni_dbi_util_pkg.log('Initial cost collection has completed with errors in the conversion rates.');
370: eni_dbi_util_pkg.log('Please modify the conversion rates and execute the incremental collection.');
371: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
372: o_error_code := 1;
373: o_error_msg := 'Initial Cost Collection has completed with conversion rate errors';

Line 370: eni_dbi_util_pkg.log('Please modify the conversion rates and execute the incremental collection.');

366: );
367:
368: ELSE
369: eni_dbi_util_pkg.log('Initial cost collection has completed with errors in the conversion rates.');
370: eni_dbi_util_pkg.log('Please modify the conversion rates and execute the incremental collection.');
371: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
372: o_error_code := 1;
373: o_error_msg := 'Initial Cost Collection has completed with conversion rate errors';
374: END IF;

Line 383: eni_dbi_util_pkg.log('An error prevented the initial cost collection from completing successfully');

379:
380: o_error_code := sqlcode;
381: o_error_msg := sqlerrm;
382:
383: eni_dbi_util_pkg.log('An error prevented the initial cost collection from completing successfully');
384: eni_dbi_util_pkg.log(o_error_code||':'||o_error_msg);
385: Rollback;
386: BIS_COLLECTION_UTILITIES.WRAPUP(
387: p_status => false,

Line 384: eni_dbi_util_pkg.log(o_error_code||':'||o_error_msg);

380: o_error_code := sqlcode;
381: o_error_msg := sqlerrm;
382:
383: eni_dbi_util_pkg.log('An error prevented the initial cost collection from completing successfully');
384: eni_dbi_util_pkg.log(o_error_code||':'||o_error_msg);
385: Rollback;
386: BIS_COLLECTION_UTILITIES.WRAPUP(
387: p_status => false,
388: p_period_from => l_start_date,

Line 451: eni_dbi_util_pkg.log('Primary currency code has not been setup, so not checking for missing primary currency conversion rates');

447: -- do not try reporting missing secondary currency conversion rates
448:
449: IF (l_prim_currency_code IS NULL)
450: THEN
451: eni_dbi_util_pkg.log('Primary currency code has not been setup, so not checking for missing primary currency conversion rates');
452: END IF;
453:
454: IF (l_sec_currency_code IS NULL)
455: THEN

Line 456: eni_dbi_util_pkg.log('Secondary currency code has not been setup, so not checking for missing secondary currency conversion rates');

452: END IF;
453:
454: IF (l_sec_currency_code IS NULL)
455: THEN
456: eni_dbi_util_pkg.log('Secondary currency code has not been setup, so not checking for missing secondary currency conversion rates');
457: END IF;
458:
459: -- Logging all the Missing Rates into the Output file.
460:

Line 531: eni_dbi_util_pkg.log('Please setup conversion rate for all missing rates reported in the output file');

527: CLOSE get_missing_rate_c;
528:
529: l_stmt_num := 34; /* check l_no_currency_rate_flag */
530: IF (l_no_currency_rate_flag = 1) THEN /* missing rate found */
531: eni_dbi_util_pkg.log('Please setup conversion rate for all missing rates reported in the output file');
532: return (-1);
533: END IF;
534: return (0);
535:

Line 543: -- eni_dbi_util_pkg.log('ENI_DBI_UCO_LOAD_PKG.REPORT_MISSING_RATE - Error at statement ('

539: l_err_num := SQLCODE;
540: l_err_msg := 'REPORT_MISSING_RATE (' || to_char(l_stmt_num)
541: || '): '|| substr(l_err_num, 1,200);
542:
543: -- eni_dbi_util_pkg.log('ENI_DBI_UCO_LOAD_PKG.REPORT_MISSING_RATE - Error at statement ('
544: -- || to_char(l_stmt_num) || ')');
545:
546: eni_dbi_util_pkg.log('Error Number: ' || to_char(l_err_num));
547: eni_dbi_util_pkg.log('Error Message: ' || l_err_msg);

Line 546: eni_dbi_util_pkg.log('Error Number: ' || to_char(l_err_num));

542:
543: -- eni_dbi_util_pkg.log('ENI_DBI_UCO_LOAD_PKG.REPORT_MISSING_RATE - Error at statement ('
544: -- || to_char(l_stmt_num) || ')');
545:
546: eni_dbi_util_pkg.log('Error Number: ' || to_char(l_err_num));
547: eni_dbi_util_pkg.log('Error Message: ' || l_err_msg);
548: RAISE;
549:
550: END REPORT_MISSING_RATE ;

Line 547: eni_dbi_util_pkg.log('Error Message: ' || l_err_msg);

543: -- eni_dbi_util_pkg.log('ENI_DBI_UCO_LOAD_PKG.REPORT_MISSING_RATE - Error at statement ('
544: -- || to_char(l_stmt_num) || ')');
545:
546: eni_dbi_util_pkg.log('Error Number: ' || to_char(l_err_num));
547: eni_dbi_util_pkg.log('Error Message: ' || l_err_msg);
548: RAISE;
549:
550: END REPORT_MISSING_RATE ;
551:

Line 594: eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));

590: INTO l_processed_txn_id, l_processed_cost_id
591: FROM bis_refresh_log brl
592: WHERE brl.object_name = 'eni_dbi_item_cost_f';
593:
594: eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
595: eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
596: eni_dbi_util_pkg.log('Last processed transaction_id from mtl_material_transactions table as stored in bis_refresh_log table is:' || l_processed_txn_id);
597: eni_dbi_util_pkg.log('Last processed cost update_id from cst_elemental_costs table as stored in bis_refresh_log table is:' || l_processed_cost_id);
598:

Line 595: eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');

591: FROM bis_refresh_log brl
592: WHERE brl.object_name = 'eni_dbi_item_cost_f';
593:
594: eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
595: eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
596: eni_dbi_util_pkg.log('Last processed transaction_id from mtl_material_transactions table as stored in bis_refresh_log table is:' || l_processed_txn_id);
597: eni_dbi_util_pkg.log('Last processed cost update_id from cst_elemental_costs table as stored in bis_refresh_log table is:' || l_processed_cost_id);
598:
599: --eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));

Line 596: eni_dbi_util_pkg.log('Last processed transaction_id from mtl_material_transactions table as stored in bis_refresh_log table is:' || l_processed_txn_id);

592: WHERE brl.object_name = 'eni_dbi_item_cost_f';
593:
594: eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
595: eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
596: eni_dbi_util_pkg.log('Last processed transaction_id from mtl_material_transactions table as stored in bis_refresh_log table is:' || l_processed_txn_id);
597: eni_dbi_util_pkg.log('Last processed cost update_id from cst_elemental_costs table as stored in bis_refresh_log table is:' || l_processed_cost_id);
598:
599: --eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
600: --eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');

Line 597: eni_dbi_util_pkg.log('Last processed cost update_id from cst_elemental_costs table as stored in bis_refresh_log table is:' || l_processed_cost_id);

593:
594: eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
595: eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
596: eni_dbi_util_pkg.log('Last processed transaction_id from mtl_material_transactions table as stored in bis_refresh_log table is:' || l_processed_txn_id);
597: eni_dbi_util_pkg.log('Last processed cost update_id from cst_elemental_costs table as stored in bis_refresh_log table is:' || l_processed_cost_id);
598:
599: --eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
600: --eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
601: select FND_GLOBAL.USER_ID

Line 599: --eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));

595: eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
596: eni_dbi_util_pkg.log('Last processed transaction_id from mtl_material_transactions table as stored in bis_refresh_log table is:' || l_processed_txn_id);
597: eni_dbi_util_pkg.log('Last processed cost update_id from cst_elemental_costs table as stored in bis_refresh_log table is:' || l_processed_cost_id);
598:
599: --eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
600: --eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
601: select FND_GLOBAL.USER_ID
602: into l_application_user_id
603: from sys.dual;

Line 600: --eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');

596: eni_dbi_util_pkg.log('Last processed transaction_id from mtl_material_transactions table as stored in bis_refresh_log table is:' || l_processed_txn_id);
597: eni_dbi_util_pkg.log('Last processed cost update_id from cst_elemental_costs table as stored in bis_refresh_log table is:' || l_processed_cost_id);
598:
599: --eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
600: --eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
601: select FND_GLOBAL.USER_ID
602: into l_application_user_id
603: from sys.dual;
604:

Line 616: eni_dbi_util_pkg.log('The initial collection in the previous runs did not

612:
613: IF (rows_in_stage = 0) THEN
614: run_incremental := TRUE;
615: ELSE
616: eni_dbi_util_pkg.log('The initial collection in the previous runs did not
617: complete successfully. Hence at first shot, trying to collect the initial collection information');
618:
619: -- Calling if any of the conversion rates are still erroneous.
620:

Line 621: eni_dbi_util_pkg.log('Retreiving currency conversion rates into rates table');

617: complete successfully. Hence at first shot, trying to collect the initial collection information');
618:
619: -- Calling if any of the conversion rates are still erroneous.
620:
621: eni_dbi_util_pkg.log('Retreiving currency conversion rates into rates table');
622: populate_rates_table('INITIAL');
623:
624: l_report_missing_Rate := report_missing_rate();
625:

Line 670: eni_dbi_util_pkg.log('Initial cost collection Complete and Successful');

666: -- edicstg.inventory_item_id,
667: -- edicstg.organization_id;
668:
669: COMMIT;
670: eni_dbi_util_pkg.log('Initial cost collection Complete and Successful');
671: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_item_cost_stg';
672: -- Bug#3994228 This table should be truncated too
673: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
674: COMMIT;

Line 677: eni_dbi_util_pkg.log('Initial cost collection of previous runs has completed with errors.');

673: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
674: COMMIT;
675: ELSIF (l_report_missing_rate = -1) THEN -- there were missing rates.
676: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
677: eni_dbi_util_pkg.log('Initial cost collection of previous runs has completed with errors.');
678: eni_dbi_util_pkg.log('Please modify the conversion rates and execute the incremental collection again');
679: o_error_code := 1;
680: o_error_msg := 'Initial Cost Collection has completed with conversion rate errors';
681: RETURN;

Line 678: eni_dbi_util_pkg.log('Please modify the conversion rates and execute the incremental collection again');

674: COMMIT;
675: ELSIF (l_report_missing_rate = -1) THEN -- there were missing rates.
676: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
677: eni_dbi_util_pkg.log('Initial cost collection of previous runs has completed with errors.');
678: eni_dbi_util_pkg.log('Please modify the conversion rates and execute the incremental collection again');
679: o_error_code := 1;
680: o_error_msg := 'Initial Cost Collection has completed with conversion rate errors';
681: RETURN;
682: END IF;

Line 711: eni_dbi_util_pkg.log('There are Standard Costing orgs, hence starting incremental cost collection for them');

707: );
708:
709: -- Get the cost history for standard costing orgs from cst_elemental_costs
710: if (l_exists_sc_orgs = 1) then
711: eni_dbi_util_pkg.log('There are Standard Costing orgs, hence starting incremental cost collection for them');
712:
713: -- Inserting the changed records into stage
714: /**
715: Bug: 4936377 If the last Processed cost id cannot be queried from bis_refresh_log table compute it

Line 725: eni_dbi_util_pkg.log('Processing cst_elemental_costs.cost_update_id greater than ' || l_processed_cost_id);

721: FROM cst_elemental_costs cec
722: WHERE cec.last_update_date < l_last_run_to_date;
723: END IF; -- l_processed_cost_id
724:
725: eni_dbi_util_pkg.log('Processing cst_elemental_costs.cost_update_id greater than ' || l_processed_cost_id);
726:
727: insert /*+ append parallel(a) */ into eni_dbi_item_cost_stg a
728: (effective_date,
729: inventory_item_id,

Line 788: eni_dbi_util_pkg.log('There are Avg/LIFO/FIFO Costing orgs, hence starting incremental cost collection for them');

784:
785: -- Get the cost changes for average/LIFO/FIFO costing orgs from mtl_cst_actual_cost_details.
786: if (l_exists_ac_orgs = 1) then
787:
788: eni_dbi_util_pkg.log('There are Avg/LIFO/FIFO Costing orgs, hence starting incremental cost collection for them');
789:
790: -- Inserting the changed records into stage
791: /**
792: Bug: 4956685 If the last Processed txn id cannot be queried from bis_refresh_log table compute it

Line 807: eni_dbi_util_pkg.log('Processing mtl_material_transactions.transaction_id greater than ' || l_processed_txn_id);

803: Bug: 4956685 We have the last Processed transaction_id from mmt table
804: This modified query will have a different nested query on the mmt table
805: with a predicate on transaction_id instead of last_run_date
806: */
807: eni_dbi_util_pkg.log('Processing mtl_material_transactions.transaction_id greater than ' || l_processed_txn_id);
808:
809: insert /*+ append parallel(a) */ into eni_dbi_item_cost_stg a
810: (effective_date,
811: inventory_item_id, organization_id, item_cost, material_cost,

Line 872: eni_dbi_util_pkg.log('Retreiving currency conversion rates into rates table');

868: end if;
869:
870: commit;
871:
872: eni_dbi_util_pkg.log('Retreiving currency conversion rates into rates table');
873: populate_rates_table('INCREMENTAL');
874:
875: eni_dbi_util_pkg.log('Checking if any missing conversion rates are present');
876: l_report_missing_rate := report_missing_rate();

Line 875: eni_dbi_util_pkg.log('Checking if any missing conversion rates are present');

871:
872: eni_dbi_util_pkg.log('Retreiving currency conversion rates into rates table');
873: populate_rates_table('INCREMENTAL');
874:
875: eni_dbi_util_pkg.log('Checking if any missing conversion rates are present');
876: l_report_missing_rate := report_missing_rate();
877: IF (l_report_missing_rate = 0) THEN -- initial collection completed normally.
878: merge into eni_dbi_item_cost_f old_costs
879: using

Line 956: eni_dbi_util_pkg.log('Incremental cost collection is Complete and Successful');

952: , l_application_user_id
953: , l_application_user_id
954: );
955: COMMIT;
956: eni_dbi_util_pkg.log('Incremental cost collection is Complete and Successful');
957: o_error_code := 0;
958: o_error_msg := 'Incremental Cost Collection is Complete and Successful';
959:
960: --Bug: 4956685 Query the max txn id from mmt table

Line 983: eni_dbi_util_pkg.log('Incremental cost collection has completed with errors in the conversion rates.');

979: --execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_item_cost_stg';
980: --execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
981:
982: ELSE
983: eni_dbi_util_pkg.log('Incremental cost collection has completed with errors in the conversion rates.');
984: eni_dbi_util_pkg.log('Please modify the conversion rates and execute the incremental collection again.');
985: o_error_code := 1;
986: o_error_msg := 'Incremental Cost Collection has completed with conversion rate errors';
987: END IF;

Line 984: eni_dbi_util_pkg.log('Please modify the conversion rates and execute the incremental collection again.');

980: --execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
981:
982: ELSE
983: eni_dbi_util_pkg.log('Incremental cost collection has completed with errors in the conversion rates.');
984: eni_dbi_util_pkg.log('Please modify the conversion rates and execute the incremental collection again.');
985: o_error_code := 1;
986: o_error_msg := 'Incremental Cost Collection has completed with conversion rate errors';
987: END IF;
988:

Line 1000: eni_dbi_util_pkg.log('An error prevented the incremental cost collection from completing successfully');

996:
997: o_error_code := sqlcode;
998: o_error_msg := sqlerrm;
999:
1000: eni_dbi_util_pkg.log('An error prevented the incremental cost collection from completing successfully');
1001: eni_dbi_util_pkg.log(o_error_code||':'||o_error_msg);
1002: Rollback;
1003: BIS_COLLECTION_UTILITIES.WRAPUP(
1004: p_status => false,

Line 1001: eni_dbi_util_pkg.log(o_error_code||':'||o_error_msg);

997: o_error_code := sqlcode;
998: o_error_msg := sqlerrm;
999:
1000: eni_dbi_util_pkg.log('An error prevented the incremental cost collection from completing successfully');
1001: eni_dbi_util_pkg.log(o_error_code||':'||o_error_msg);
1002: Rollback;
1003: BIS_COLLECTION_UTILITIES.WRAPUP(
1004: p_status => false,
1005: p_period_from => l_last_run_to_date,