1: PACKAGE BODY OPI_DBI_RES_PKG AS
2: /* $Header: OPIDRESB.pls 120.26 2007/03/12 06:57:25 hyadaval ship $ */
3:
4: /*========================================
5: Package Level Variables
208: EXCEPTION
209: WHEN OTHERS THEN
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: --}
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 );
3796: --}
3797: --}
3798: END initial_load_res_std;
3799:
3800: END opi_dbi_res_pkg;