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

Line 114: IF BIS_COLLECTION_UTILITIES.setup (p_object_name => C_PKG_NAME) = FALSE

110: s_secondary_rate_type := NULL;
111:
112: -- Common setup API
113: l_stmt_id := 10;
114: IF BIS_COLLECTION_UTILITIES.setup (p_object_name => C_PKG_NAME) = FALSE
115: THEN
116: -- {
117: RAISE BIS_COMMON_API_FAILED;
118: -- }

Line 208: BIS_COLLECTION_UTILITIES.PUT_LINE (

204: EXCEPTION
205: -- {
206: WHEN SCHEMA_INFO_NOT_FOUND THEN
207: -- {
208: BIS_COLLECTION_UTILITIES.PUT_LINE (
209: p_text => err_mesg (p_mesg => SCHEMA_INFO_NOT_FOUND_MESG,
210: p_proc_name => l_proc_name, p_stmt_id => l_stmt_id));
211: RAISE GLOBAL_SETUP_FAILED;
212: -- }

Line 216: BIS_COLLECTION_UTILITIES.PUT_LINE (

212: -- }
213:
214: WHEN BIS_COMMON_API_FAILED THEN
215: -- {
216: BIS_COLLECTION_UTILITIES.PUT_LINE (
217: p_text => err_mesg (p_mesg => BIS_COMMON_API_FAILED_MESG,
218: p_proc_name => l_proc_name, p_stmt_id => l_stmt_id));
219: RAISE GLOBAL_SETUP_FAILED;
220: -- }

Line 224: BIS_COLLECTION_UTILITIES.PUT_LINE (

220: -- }
221:
222: WHEN EXP_TABLE_CLEANUP_FAILED THEN
223: -- {
224: BIS_COLLECTION_UTILITIES.PUT_LINE (
225: p_text => err_mesg (p_mesg => EXP_TABLE_CLEANUP_FAILED_MESG,
226: p_proc_name => l_proc_name, p_stmt_id => l_stmt_id));
227: RAISE GLOBAL_SETUP_FAILED;
228: -- }

Line 232: BIS_COLLECTION_UTILITIES.PUT_LINE (

228: -- }
229:
230: WHEN PRIMARY_CURR_SETUP_BAD THEN
231: -- {
232: BIS_COLLECTION_UTILITIES.PUT_LINE (
233: p_text => err_mesg (p_mesg => PRIMARY_CURR_SETUP_BAD_MESG,
234: p_proc_name => l_proc_name, p_stmt_id => l_stmt_id));
235: RAISE GLOBAL_SETUP_FAILED;
236: -- }

Line 240: BIS_COLLECTION_UTILITIES.PUT_LINE (

236: -- }
237:
238: WHEN NO_GLOBAL_CURR_CODE THEN
239: -- {
240: BIS_COLLECTION_UTILITIES.PUT_LINE (
241: p_text => err_mesg (p_mesg => NO_GLOBAL_CURR_CODE_MESG,
242: p_proc_name => l_proc_name, p_stmt_id => l_stmt_id));
243: RAISE GLOBAL_SETUP_FAILED;
244: -- }

Line 248: BIS_COLLECTION_UTILITIES.PUT_LINE (

244: -- }
245:
246: WHEN NO_GLOBAL_RATE_TYPE THEN
247: -- {
248: BIS_COLLECTION_UTILITIES.PUT_LINE (
249: p_text => err_mesg (p_mesg => NO_GLOBAL_RATE_TYPE_MESG,
250: p_proc_name => l_proc_name,p_stmt_id => l_stmt_id));
251: RAISE GLOBAL_SETUP_FAILED;
252: -- }

Line 256: BIS_COLLECTION_UTILITIES.PUT_LINE (

252: -- }
253:
254: WHEN SEC_CURR_SETUP_INVALID THEN
255: -- {
256: BIS_COLLECTION_UTILITIES.PUT_LINE (
257: p_text => err_mesg (p_mesg => SEC_CURR_SETUP_INVALID_MESG,
258: p_proc_name => l_proc_name,p_stmt_id => l_stmt_id));
259: RAISE GLOBAL_SETUP_FAILED;
260: -- }

Line 264: BIS_COLLECTION_UTILITIES.PUT_LINE (

260: -- }
261:
262: WHEN OTHERS THEN
263: -- {
264: BIS_COLLECTION_UTILITIES.PUT_LINE (
265: p_text => err_mesg (p_mesg => SQLERRM, p_proc_name => l_proc_name,
266: p_stmt_id => l_stmt_id));
267: RAISE GLOBAL_SETUP_FAILED;
268: -- }

Line 315: BIS_COLLECTION_UTILITIES.wrapup (

311: clear_inv_exp_tables;
312:
313: l_stmt_id := 30;
314: -- Program has failed. Call the BIS wrapup API appropriately.
315: BIS_COLLECTION_UTILITIES.wrapup (
316: p_status => FALSE,
317: p_count => p_exp_rows_collected,
318: p_message => C_CURR_INV_EXP_LOAD_ERROR_MESG);
319: -- }

Line 324: BIS_COLLECTION_UTILITIES.wrapup (TRUE, p_exp_rows_collected,

320: ELSIF (p_retcode = C_WARNING OR p_retcode = C_SUCCESS) THEN
321: -- {
322: l_stmt_id := 40;
323: -- from a BIS log perspective, program has been successful
324: BIS_COLLECTION_UTILITIES.wrapup (TRUE, p_exp_rows_collected,
325: C_SUCCESS_MESG);
326: -- }
327: END IF;
328:

Line 337: BIS_COLLECTION_UTILITIES.PUT_LINE (

333: -- {
334:
335: WHEN EXP_TABLE_CLEANUP_FAILED THEN
336: -- {
337: BIS_COLLECTION_UTILITIES.PUT_LINE (
338: p_text => err_mesg (p_mesg => EXP_TABLE_CLEANUP_FAILED_MESG,
339: p_proc_name => l_proc_name, p_stmt_id => l_stmt_id));
340: RAISE GLOBAL_WRAPUP_FAILED;
341: -- }

Line 345: BIS_COLLECTION_UTILITIES.PUT_LINE (

341: -- }
342:
343: WHEN OTHERS THEN
344: -- {
345: BIS_COLLECTION_UTILITIES.PUT_LINE (
346: p_text => err_mesg (p_mesg => SQLERRM, p_proc_name => l_proc_name,
347: p_stmt_id => l_stmt_id));
348: RAISE GLOBAL_WRAPUP_FAILED;
349: -- }

Line 388: BIS_COLLECTION_UTILITIES.PUT_LINE (

384: -- {
385:
386: WHEN OTHERS THEN
387: -- {
388: BIS_COLLECTION_UTILITIES.PUT_LINE (
389: p_text => err_mesg (p_mesg => SQLERRM, p_proc_name =>l_proc_name,
390: p_stmt_id =>l_stmt_id));
391: RAISE EXP_TABLE_CLEANUP_FAILED;
392: -- }

Line 500: BIS_COLLECTION_UTILITIES.PUT_LINE (l_formatted_message);

496: l_formatted_message := substr ((C_PKG_NAME || '.' || p_proc_name || ' #' ||
497: to_char (p_stmt_id) || ': ' || 'Done.'),
498: 1, C_ERRBUF_SIZE);
499:
500: BIS_COLLECTION_UTILITIES.PUT_LINE (l_formatted_message);
501:
502: return;
503: -- }
504: EXCEPTION

Line 509: BIS_COLLECTION_UTILITIES.PUT_LINE (

505: -- {
506: WHEN OTHERS THEN
507: -- {
508: -- the exception happened in the print function
509: BIS_COLLECTION_UTILITIES.PUT_LINE (
510: p_text => err_mesg (p_mesg => SQLERRM, p_proc_name => l_proc_name,
511: p_stmt_id => l_stmt_id));
512:
513: RAISE; -- on to wrapper

Line 852: BIS_COLLECTION_UTILITIES.PUT_LINE (

848: -- {
849:
850: WHEN OTHERS THEN
851: -- {
852: BIS_COLLECTION_UTILITIES.PUT_LINE (
853: p_text => err_mesg (p_mesg => SQLERRM, p_proc_name =>l_proc_name,
854: p_stmt_id => l_stmt_id));
855:
856: RAISE EXP_INV_EXTRACT_ERROR;

Line 989: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

985: IF (invalid_rates_exist_csr%FOUND) THEN
986: -- {
987: l_stmt_id := 30;
988: -- print the header out
989: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
990:
991: l_stmt_id := 40;
992: -- all rates not found
993: l_all_rates_found := false;

Line 1000: BIS_COLLECTION_UTILITIES.writeMissingRate(

996: FOR invalid_rate_rec IN invalid_rates_csr (l_pri_sec_curr_same)
997: LOOP
998: -- {
999: l_stmt_id := 60;
1000: BIS_COLLECTION_UTILITIES.writeMissingRate(
1001: p_rate_type => invalid_rate_rec.rate_type,
1002: p_from_currency => invalid_rate_rec.func_currency_code,
1003: p_to_currency => invalid_rate_rec.curr_code,
1004: p_date => invalid_rate_rec.run_date);

Line 1026: BIS_COLLECTION_UTILITIES.PUT_LINE (

1022: -- {
1023:
1024: WHEN MISSING_CONV_RATES THEN
1025: -- {
1026: BIS_COLLECTION_UTILITIES.PUT_LINE (
1027: p_text => err_mesg (p_mesg => MISSING_CONV_RATES_MESG,
1028: p_proc_name => l_proc_name, p_stmt_id => l_stmt_id));
1029: RAISE CONV_RATES_ERROR;
1030: -- }

Line 1034: BIS_COLLECTION_UTILITIES.PUT_LINE (

1030: -- }
1031:
1032: WHEN OTHERS THEN
1033: -- {
1034: BIS_COLLECTION_UTILITIES.PUT_LINE (
1035: p_text => err_mesg (p_mesg => SQLERRM, p_proc_name => l_proc_name,
1036: p_stmt_id => l_stmt_id));
1037:
1038: RAISE CONV_RATES_ERROR;

Line 1132: BIS_COLLECTION_UTILITIES.PUT_LINE (

1128: retcode := C_ERROR;
1129: errbuf := C_CURR_INV_EXP_LOAD_ERROR_MESG;
1130: global_wrapup (retcode, l_rows_collected);
1131:
1132: BIS_COLLECTION_UTILITIES.PUT_LINE (
1133: p_text => err_mesg (p_mesg => GLOBAL_SETUP_FAILED_MESG,
1134: p_proc_name => l_proc_name, p_stmt_id => l_stmt_id));
1135: return;
1136: -- }

Line 1145: BIS_COLLECTION_UTILITIES.PUT_LINE (

1141: retcode := C_ERROR;
1142: errbuf := C_CURR_INV_EXP_LOAD_ERROR_MESG;
1143: global_wrapup (retcode, l_rows_collected);
1144:
1145: BIS_COLLECTION_UTILITIES.PUT_LINE (
1146: p_text => err_mesg (p_mesg => EXP_INV_EXTRACT_ERROR_MESG,
1147: p_proc_name => l_proc_name,p_stmt_id => l_stmt_id));
1148: return;
1149: -- }

Line 1158: BIS_COLLECTION_UTILITIES.PUT_LINE (

1154: retcode := C_ERROR;
1155: errbuf := C_CURR_INV_EXP_LOAD_ERROR_MESG;
1156: global_wrapup (retcode, l_rows_collected);
1157:
1158: BIS_COLLECTION_UTILITIES.PUT_LINE (
1159: p_text => err_mesg (p_mesg => CONV_RATES_ERROR_MESG,
1160: p_proc_name => l_proc_name,p_stmt_id => l_stmt_id));
1161: return;
1162: -- }

Line 1172: BIS_COLLECTION_UTILITIES.PUT_LINE (

1168: errbuf := C_CURR_INV_EXP_LOAD_ERROR_MESG;
1169: -- try calling it again?? This time it'll clear the fact.
1170: global_wrapup (retcode, l_rows_collected);
1171:
1172: BIS_COLLECTION_UTILITIES.PUT_LINE (
1173: p_text => err_mesg (p_mesg => GLOBAL_WRAPUP_FAILED_MESG,
1174: p_proc_name => l_proc_name, p_stmt_id => l_stmt_id));
1175: return;
1176: -- }

Line 1185: BIS_COLLECTION_UTILITIES.PUT_LINE (

1181: retcode := C_ERROR;
1182: errbuf := C_CURR_INV_EXP_LOAD_ERROR_MESG;
1183: global_wrapup (retcode, l_rows_collected);
1184:
1185: BIS_COLLECTION_UTILITIES.PUT_LINE (
1186: p_text => err_mesg (p_mesg => SQLERRM,p_proc_name => l_proc_name,
1187: p_stmt_id => l_stmt_id));
1188:
1189: return;