APPS.OPI_DBI_INV_VALUE_UTL_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 178: BIS_COLLECTION_UTILITIES.PUT_LINE ('Get_conversion_rates: #0: Computing conversion rates for the inventory data extraction.');

174: i_err_msg VARCHAR2(255);
175:
176: BEGIN
177:
178: BIS_COLLECTION_UTILITIES.PUT_LINE ('Get_conversion_rates: #0: Computing conversion rates for the inventory data extraction.');
179:
180: -- initialization block
181: l_stmt_id := 0;
182: l_all_rates_found := true;

Line 195: BIS_COLLECTION_UTILITIES.put_line (

191: return -1;
192: END IF;
193: EXECUTE IMMEDIATE 'truncate table ' || l_opi_schema ||
194: '.OPI_DBI_CONVERSION_RATES';
195: BIS_COLLECTION_UTILITIES.put_line (
196: 'OPI_DBI_CONVERSION_RATES table truncated.');
197:
198:
199: l_stmt_id := 10;

Line 209: BIS_COLLECTION_UTILITIES.PUT_LINE (

205:
206: l_stmt_id := 20;
207: -- global currency and rate type must be set up
208: IF (s_global_curr_code IS NULL OR s_global_rate_type IS NULL) THEN
209: BIS_COLLECTION_UTILITIES.PUT_LINE (
210: l_proc_name || ':# ' || l_stmt_id || ': ' ||
211: 'Please set up the global currency and global rate type before running any DBI collection.');
212: return -1;
213: END IF;

Line 222: BIS_COLLECTION_UTILITIES.PUT_LINE (

218: IF ( (s_secondary_curr_code IS NULL AND
219: s_secondary_rate_type IS NOT NULL)
220: OR (s_secondary_curr_code IS NOT NULL AND
221: s_secondary_rate_type IS NULL) ) THEN
222: BIS_COLLECTION_UTILITIES.PUT_LINE (
223: l_proc_name || ':# ' || l_stmt_id || ': ' ||
224: 'Please make sure that both the secondary currency and rate type are defined, or that neither is defined.');
225: return -1;
226: END IF;

Line 365: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

361: FETCH invalid_rates_exist_csr INTO invalid_rates_exist_rec;
362: IF (invalid_rates_exist_csr%FOUND) THEN
363:
364: -- print the header out
365: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
366:
367: -- all rates not found
368: l_all_rates_found := false;
369:

Line 373: BIS_COLLECTION_UTILITIES.writeMissingRate(

369:
370: FOR invalid_rate_rec IN invalid_rates_csr (l_pri_sec_curr_same)
371: LOOP
372:
373: BIS_COLLECTION_UTILITIES.writeMissingRate(
374: invalid_rate_rec.rate_type,
375: invalid_rate_rec.f_currency_code,
376: invalid_rate_rec.curr_code,
377: invalid_rate_rec.transaction_date);

Line 402: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_INV_VALUE_UTL_PKG.GET_CONVERSION_RATE - Error at statement ('

398: || to_char(l_stmt_id)
399: || '): '
400: || substr(SQLERRM, 1,200);
401:
402: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_INV_VALUE_UTL_PKG.GET_CONVERSION_RATE - Error at statement ('
403: || to_char(l_stmt_id)
404: || ')');
405:
406: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));

Line 406: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));

402: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_INV_VALUE_UTL_PKG.GET_CONVERSION_RATE - Error at statement ('
403: || to_char(l_stmt_id)
404: || ')');
405:
406: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));
407: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || i_err_msg);
408:
409: RETURN -1;
410:

Line 407: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || i_err_msg);

403: || to_char(l_stmt_id)
404: || ')');
405:
406: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));
407: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || i_err_msg);
408:
409: RETURN -1;
410:
411: END Get_Conversion_Rate;