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.OKI_DBI_LOAD_CLEB_PVT dependencies on BIS_COLLECTION_UTILITIES

Line 31: BIS_COLLECTION_UTILITIES.log(p_string,p_indent);

27: p_indent : Indentation of the message
28: ************************************************************************** */
29: PROCEDURE rlog ( p_string IN VARCHAR2, p_indent IN NUMBER ) IS
30: BEGIN
31: BIS_COLLECTION_UTILITIES.log(p_string,p_indent);
32: EXCEPTION
33: WHEN OTHERS THEN
34: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
35: fnd_message.set_name( application => 'FND'

Line 34: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

30: BEGIN
31: BIS_COLLECTION_UTILITIES.log(p_string,p_indent);
32: EXCEPTION
33: WHEN OTHERS THEN
34: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
35: fnd_message.set_name( application => 'FND'
36: , name => 'CRM-DEBUG ERROR' ) ;
37: fnd_message.set_token( token => 'ROUTINE'
38: , value => 'OKI_DBI_LOAD_CLEB_PVT.log' ) ;

Line 39: bis_collection_utilities.put_line(fnd_message.get) ;

35: fnd_message.set_name( application => 'FND'
36: , name => 'CRM-DEBUG ERROR' ) ;
37: fnd_message.set_token( token => 'ROUTINE'
38: , value => 'OKI_DBI_LOAD_CLEB_PVT.log' ) ;
39: bis_collection_utilities.put_line(fnd_message.get) ;
40: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
41: END rlog;
42:
43: /* *****************************************************************************

Line 52: BIS_COLLECTION_UTILITIES.out(p_string,p_indent);

48: ************************************************************************** */
49:
50: PROCEDURE rout ( p_string IN VARCHAR2, p_indent IN NUMBER ) IS
51: BEGIN
52: BIS_COLLECTION_UTILITIES.out(p_string,p_indent);
53: EXCEPTION
54: WHEN OTHERS THEN
55: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
56: fnd_message.set_name( application => 'FND'

Line 55: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

51: BEGIN
52: BIS_COLLECTION_UTILITIES.out(p_string,p_indent);
53: EXCEPTION
54: WHEN OTHERS THEN
55: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
56: fnd_message.set_name( application => 'FND'
57: , name => 'CRM-DEBUG ERROR' ) ;
58: fnd_message.set_token( token => 'ROUTINE'
59: , value => 'OKI_DBI_LOAD_CLEB_PVT.out ' ) ;

Line 60: bis_collection_utilities.put_line(fnd_message.get) ;

56: fnd_message.set_name( application => 'FND'
57: , name => 'CRM-DEBUG ERROR' ) ;
58: fnd_message.set_token( token => 'ROUTINE'
59: , value => 'OKI_DBI_LOAD_CLEB_PVT.out ' ) ;
60: bis_collection_utilities.put_line(fnd_message.get) ;
61: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
62: END rout;
63:
64: /* *****************************************************************************

Line 112: l_setup_ok := BIS_COLLECTION_UTILITIES.setup('OKIDBICLEB');

108: g_9999_date := to_date('12-31-9999' ,'MM-DD-YYYY');
109: g_0001_date := to_date('01-01-0001' ,'MM-DD-YYYY');
110: g_euro_start_date := to_date('01/01/1999','MM/DD/RRRR');
111: l_run_date := SYSDATE;
112: l_setup_ok := BIS_COLLECTION_UTILITIES.setup('OKIDBICLEB');
113: IF (NOT l_setup_ok) THEN
114: errbuf := fnd_message.get;
115: rlog( 'BIS Setup Failure ',0);
116: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);

Line 185: bis_collection_utilities.put_line(errbuf || '' || retcode ) ;

181: RAISE;
182: WHEN OTHERS THEN
183: errbuf := SQLERRM ;
184: retcode := SQLCODE ;
185: bis_collection_utilities.put_line(errbuf || '' || retcode ) ;
186: fnd_message.set_name( application => 'FND'
187: , name => 'CRM-DEBUG ERROR' ) ;
188: fnd_message.set_token(
189: token => 'ROUTINE'

Line 191: bis_collection_utilities.put_line(fnd_message.get) ;

187: , name => 'CRM-DEBUG ERROR' ) ;
188: fnd_message.set_token(
189: token => 'ROUTINE'
190: , value => 'OKI_DBI_LOAD_CLEB_PVT.INITIAL_LOAD ' ) ;
191: bis_collection_utilities.put_line(fnd_message.get) ;
192: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
193: END initial_load;
194:
195: /* *****************************************************************************

Line 243: BIS_COLLECTION_UTILITIES.DeleteLogForObject('OKIDBICLEB');

239: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema ||'.OKI_DBI_CLE_B';
240: EXECUTE IMMEDIATE l_sql_string;
241: rlog( 'Truncated Table OKI_DBI_CLE_B' ,2);
242:
243: BIS_COLLECTION_UTILITIES.DeleteLogForObject('OKIDBICLEB');
244: rlog( 'Completed resetting base tables and BIS log file ' || fnd_date.date_to_displayDT(sysdate),1);
245: END IF;
246:
247: EXCEPTION

Line 254: bis_collection_utilities.put_line(errbuf || '' || retcode ) ;

250: WHEN OTHERS
251: THEN
252: errbuf := sqlerrm;
253: retcode := sqlcode;
254: bis_collection_utilities.put_line(errbuf || '' || retcode ) ;
255: fnd_message.set_name( application => 'FND'
256: , name => 'CRM-DEBUG ERROR' ) ;
257: fnd_message.set_token(
258: token => 'ROUTINE'

Line 260: bis_collection_utilities.put_line(fnd_message.get) ;

256: , name => 'CRM-DEBUG ERROR' ) ;
257: fnd_message.set_token(
258: token => 'ROUTINE'
259: , value => 'OKI_DBI_LOAD_CLEB_PVT.RESET_BASE_TABLES ' ) ;
260: bis_collection_utilities.put_line(fnd_message.get) ;
261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: END reset_base_tables;
263:
264: /* *****************************************************************************

Line 312: l_setup_ok := BIS_COLLECTION_UTILITIES.setup('OKIDBICLEB');

308: g_no_of_workers := p_no_of_workers;
309:
310: IF( NVL(OKI_DBI_LOAD_CLEB_PVT.g_load_type,'INC LOAD') <> 'INITIAL LOAD')
311: THEN
312: l_setup_ok := BIS_COLLECTION_UTILITIES.setup('OKIDBICLEB');
313: IF (NOT l_setup_ok) THEN
314: errbuf := fnd_message.get;
315: rlog( 'BIS Setup Failure ',0);
316: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);

Line 323: g_debug := BIS_COLLECTION_UTILITIES.G_DEBUG;

319: rlog( 'Service Contracts Intelligence - INCREMENTAL LOAD ' || fnd_date.date_to_displayDT(sysdate),0);
320: rlog( 'Number of workers requested : ' || g_no_of_workers,0);
321: END IF;
322:
323: g_debug := BIS_COLLECTION_UTILITIES.G_DEBUG;
324:
325: -- Check to see if User entered the start date for incremental load as param.
326: -- if not default to previous last refresh of load date.(from bis_refresh_log)
327:

Line 332: l_start_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('OKIDBICLEB'))

328: IF( NVL(OKI_DBI_LOAD_CLEB_PVT.g_load_type,'INC LOAD') <> 'INITIAL LOAD')
329: THEN
330: IF(p_start_date IS NULL )
331: THEN
332: l_start_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('OKIDBICLEB'))
333: - 0.004;
334: g_true_incr :=1;
335: ELSE
336: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS') - 0.004;

Line 407: BIS_COLLECTION_UTILITIES.wrapup(TRUE,

403: IF l_count IS NULL THEN
404: l_count := 0;
405: END IF;
406:
407: BIS_COLLECTION_UTILITIES.wrapup(TRUE,
408: l_count,
409: 'OKI DBI COV LINES COLLECTION SUCCEEDED',
410: OKI_DBI_LOAD_CLEB_PVT.g_start_date,
411: OKI_DBI_LOAD_CLEB_PVT.g_end_date

Line 465: BIS_COLLECTION_UTILITIES.wrapup(FALSE,

461: WHEN OTHERS
462: THEN
463: retcode := SQLCODE ;
464: errbuf := SQLERRM ;
465: BIS_COLLECTION_UTILITIES.wrapup(FALSE,
466: l_count,
467: errbuf || ': ' || retcode,
468: OKI_DBI_LOAD_CLEB_PVT.g_start_date,
469: OKI_DBI_LOAD_CLEB_PVT.g_end_date

Line 476: bis_collection_utilities.put_line(fnd_message.get) ;

472: , name => 'CRM-DEBUG ERROR' ) ;
473: fnd_message.set_token(
474: token => 'ROUTINE'
475: , value => 'OKI_DBI_LOAD_CLEB_PVT.populate_base_tables ' ) ;
476: bis_collection_utilities.put_line(fnd_message.get) ;
477: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
478: END populate_base_tables;
479:
480: /* *****************************************************************************

Line 1039: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

1035: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1036: RAISE;
1037: WHEN OTHERS THEN
1038: rlog( 'Error : While loading Incremental Table OKI_DBI_CHR_INC ',0);
1039: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
1040: fnd_message.set_name( application => 'FND'
1041: , name => 'CRM-DEBUG ERROR' ) ;
1042: fnd_message.set_token(
1043: token => 'ROUTINE'

Line 1045: bis_collection_utilities.put_line(fnd_message.get) ;

1041: , name => 'CRM-DEBUG ERROR' ) ;
1042: fnd_message.set_token(
1043: token => 'ROUTINE'
1044: , value => 'OKI_DBI_LOAD_CLEB_PVT.POPULATE_INC_TABLE_INIT ' ) ;
1045: bis_collection_utilities.put_line(fnd_message.get) ;
1046: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
1047: END populate_inc_table_init ;
1048:
1049: /* *****************************************************************************

Line 1701: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

1697: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1698: RAISE;
1699: WHEN OTHERS THEN
1700: rlog( 'Error : while loading Incremental Table OKI_DBI_CHR_INC ',0);
1701: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
1702: fnd_message.set_name( application => 'FND'
1703: , name => 'CRM-DEBUG ERROR' ) ;
1704: fnd_message.set_token(
1705: token => 'ROUTINE'

Line 1707: bis_collection_utilities.put_line(fnd_message.get) ;

1703: , name => 'CRM-DEBUG ERROR' ) ;
1704: fnd_message.set_token(
1705: token => 'ROUTINE'
1706: , value => 'OKI_DBI_LOAD_CLEB_PVT.POPULATE_INC_TABLE_INC ' ) ;
1707: bis_collection_utilities.put_line(fnd_message.get) ;
1708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
1709: END populate_inc_table_inc ;
1710:
1711: /* *****************************************************************************

Line 1782: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

1778: RAISE;
1779: WHEN OTHERS THEN
1780: rlog('Error during load_currencies: Insert into OKI_DBI_CURR_CONV Failed' , 0);
1781: rlog(sqlerrm ||' '||sqlcode, 0);
1782: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
1783: fnd_message.set_name( application => 'FND'
1784: , name => 'CRM-DEBUG ERROR' ) ;
1785: fnd_message.set_token( token => 'ROUTINE'
1786: , value => 'OKI_DBI_LOAD_CLEB_PVT.load_currencies' ) ;

Line 1787: bis_collection_utilities.put_line(fnd_message.get) ;

1783: fnd_message.set_name( application => 'FND'
1784: , name => 'CRM-DEBUG ERROR' ) ;
1785: fnd_message.set_token( token => 'ROUTINE'
1786: , value => 'OKI_DBI_LOAD_CLEB_PVT.load_currencies' ) ;
1787: bis_collection_utilities.put_line(fnd_message.get) ;
1788: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1789:
1790: END load_currencies;
1791:

Line 1838: BIS_COLLECTION_UTILITIES.writemissingrateheader ;

1834: rout(' Missing Functional To Global Conversion Rates', 0 ) ;
1835: rout(rpad('*' ,80 ,'*'), 0 ) ;
1836: rout(' ', 0 ) ;
1837:
1838: BIS_COLLECTION_UTILITIES.writemissingrateheader ;
1839:
1840: -- Missing currency summary for converting from functional to
1841: -- global currency
1842: FOR r_cur IN (SELECT distinct to_currency func_currency,

Line 1851: BIS_COLLECTION_UTILITIES.writemissingrate(

1847: AND rate_g < 0
1848: AND rate_g NOT IN (-2,-3,-5)
1849: ORDER BY conversion_date ASC)
1850: LOOP
1851: BIS_COLLECTION_UTILITIES.writemissingrate(
1852: l_rate_type
1853: , r_cur.func_currency
1854: , l_global_currency
1855: , r_cur.conversion_date ) ;

Line 1867: BIS_COLLECTION_UTILITIES.writemissingrateheader ;

1863: rout(' Missing Functional To Secondary Global Conversion Rates', 0 ) ;
1864: rout(rpad('*' ,80 ,'*'), 0 ) ;
1865: rout(' ', 0 ) ;
1866:
1867: BIS_COLLECTION_UTILITIES.writemissingrateheader ;
1868:
1869: -- Missing currency summary for converting from functional to
1870: -- secondary global currency
1871: FOR r_cur IN (SELECT DISTINCT to_currency func_currency

Line 1880: BIS_COLLECTION_UTILITIES.writemissingrate(

1876: AND rate_sg < 0
1877: AND rate_sg NOT IN (-2,-3,-5)
1878: ORDER BY conversion_date ASC)
1879: LOOP
1880: BIS_COLLECTION_UTILITIES.writemissingrate(
1881: l_srate_type
1882: ,r_cur.func_currency
1883: ,l_sglobal_currency
1884: ,r_cur.conversion_date ) ;

Line 1898: BIS_COLLECTION_UTILITIES.writemissingrateheader ;

1894: , 0 ) ;
1895: rout(rpad('*' ,80 ,'*'), 0 ) ;
1896: rout(' ', 0 ) ;
1897:
1898: BIS_COLLECTION_UTILITIES.writemissingrateheader ;
1899:
1900: -- Missing currency summary for converting from transactional to
1901: -- functional currency
1902: FOR r_cur IN (SELECT DISTINCT rate_type AS TRX_RATE_TYPE

Line 1912: BIS_COLLECTION_UTILITIES.writemissingrate(

1908: --AND rate_type <> 'USER' --fix for 4102597
1909: AND ( rate_f <= 0 OR rate_f IS NULL)
1910: ORDER BY conversion_date ASC )
1911: LOOP
1912: BIS_COLLECTION_UTILITIES.writemissingrate(
1913: r_cur.trx_rate_type
1914: , r_cur.trx_currency
1915: , r_cur.func_currency
1916: , r_cur.conversion_date ) ;

Line 1925: bis_collection_utilities.writeMissingContractHeader ;

1921: rout(' Contracts With Missing Functional to Global Conversion Rates', 0 ) ;
1922: rout(rpad('*' ,110 ,'*'), 0 ) ;
1923: rout(' ', 0 ) ;
1924:
1925: bis_collection_utilities.writeMissingContractHeader ;
1926:
1927: FOR r_cur IN (
1928: SELECT /*+ ordered use_hash(chr) use_nl(h)
1929: parallel(inc) parallel(chr) parallel(h) */

Line 1952: bis_collection_utilities.writeMissingContract(

1948: AND chr.trx_rate_type = inc.rate_type
1949: ORDER BY conversion_date asc)
1950:
1951: LOOP
1952: bis_collection_utilities.writeMissingContract(
1953: r_cur.complete_contract_number
1954: , r_cur.sts_code
1955: , r_cur.chr_id
1956: , l_rate_type

Line 1971: bis_collection_utilities.writeMissingContractHeader ;

1967: rout(' Contracts With Missing Functional to Secondary Global Conversion Rates', 0 ) ;
1968: rout(rpad('*' ,110 ,'*'), 0 ) ;
1969: rout(' ', 0 ) ;
1970:
1971: bis_collection_utilities.writeMissingContractHeader ;
1972:
1973: FOR r_cur IN (
1974: SELECT /*+ leading(inc) use_hash(chr) use_nl(h) */
1975: distinct h.contract_number || ' ' ||

Line 1995: bis_collection_utilities.writeMissingContract(

1991: AND chr.func_currency = inc.to_currency
1992: AND chr.trx_rate_type = inc.rate_type
1993: ORDER BY conversion_date ASC )
1994: LOOP
1995: bis_collection_utilities.writeMissingContract(
1996: r_cur.complete_contract_number
1997: ,r_cur.sts_code
1998: ,r_cur.chr_id
1999: ,l_rate_type

Line 2014: bis_collection_utilities.writeMissingContractHeader ;

2010: rout(' Contracts With Missing Transactional To Functional Conversion Rates',0) ;
2011: rout(rpad('*' ,110 ,'*') ,0) ;
2012: rout(' ' ,0) ;
2013:
2014: bis_collection_utilities.writeMissingContractHeader ;
2015:
2016: -- Error occured when converting from transactional to function currency
2017: -- Write the details to the error log
2018: FOR r_cur IN (

Line 2042: bis_collection_utilities.writeMissingContract(

2038: AND chr.func_currency = inc.to_currency
2039: AND chr.trx_rate_type = inc.rate_type
2040: ORDER BY conversion_date)
2041: LOOP
2042: bis_collection_utilities.writeMissingContract(
2043: r_cur.complete_contract_number
2044: , r_cur.sts_code
2045: , r_cur.chr_id
2046: , r_cur.trx_rate_type

Line 2087: bis_collection_utilities.writeMissingContract(

2083: AND chr.trx_rate_type = inc.rate_type
2084: ORDER BY conversion_date ASC )
2085: LOOP
2086:
2087: bis_collection_utilities.writeMissingContract(
2088: r_cur.complete_contract_number
2089: ,r_cur.sts_code
2090: ,r_cur.chr_id
2091: ,l_rate_type

Line 2104: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

2100: EXCEPTION
2101: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2102: RAISE;
2103: WHEN OTHERS THEN
2104: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
2105: fnd_message.set_name( application => 'FND'
2106: , name => 'CRM-DEBUG ERROR' ) ;
2107: fnd_message.set_token(
2108: token => 'ROUTINE'

Line 2110: bis_collection_utilities.put_line(fnd_message.get) ;

2106: , name => 'CRM-DEBUG ERROR' ) ;
2107: fnd_message.set_token(
2108: token => 'ROUTINE'
2109: , value => 'OKI_DBI_LOAD_CLEB_PVT.report_missing_currencies ' ) ;
2110: bis_collection_utilities.put_line(fnd_message.get) ;
2111: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
2112: END report_missing_currencies ;
2113:
2114: /* *****************************************************************************

Line 2170: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

2166: EXCEPTION
2167: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2168: RAISE;
2169: WHEN OTHERS THEN
2170: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
2171: fnd_message.set_name( application => 'FND'
2172: , name => 'CRM-DEBUG ERROR' ) ;
2173: fnd_message.set_token(
2174: token => 'ROUTINE'

Line 2176: bis_collection_utilities.put_line(fnd_message.get) ;

2172: , name => 'CRM-DEBUG ERROR' ) ;
2173: fnd_message.set_token(
2174: token => 'ROUTINE'
2175: , value => 'OKI_DBI_LOAD_CLEB_PVT.PROCESS_DELETES ' ) ;
2176: bis_collection_utilities.put_line(fnd_message.get) ;
2177: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2178: END process_deletes;
2179:
2180: /* *****************************************************************************

Line 2985: bis_collection_utilities.put_line(fnd_message.get) ;

2981: fnd_message.set_name( application => 'FND'
2982: , name => 'CRM-DEBUG ERROR' ) ;
2983: fnd_message.set_token( token => 'ROUTINE'
2984: , value => 'OKI_DBI_LOAD_CLEB_PVT.LOAD_STAGING ' ) ;
2985: bis_collection_utilities.put_line(fnd_message.get) ;
2986: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
2987: END load_staging;
2988:
2989: /*******************************************************************************

Line 3209: bis_collection_utilities.put_line(fnd_message.get) ;

3205: , name => 'CRM-DEBUG ERROR' ) ;
3206: fnd_message.set_token(
3207: token => 'ROUTINE'
3208: , value => 'OKI_DBI_LOAD_CLEB_PVT.POPULATE_REN_REL' ) ;
3209: bis_collection_utilities.put_line(fnd_message.get) ;
3210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3211: END populate_ren_rel;
3212:
3213: /*******************************************************************************

Line 3286: bis_collection_utilities.put_line(fnd_message.get) ;

3282: , name => 'CRM-DEBUG ERROR' ) ;
3283: fnd_message.set_token(
3284: token => 'ROUTINE'
3285: , value => 'OKI_DBI_LOAD_CLEB_PVT.Update_RHS ' ) ;
3286: bis_collection_utilities.put_line(fnd_message.get) ;
3287: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
3288: END update_RHS ;
3289:
3290: /*******************************************************************************

Line 3410: bis_collection_utilities.put_line(fnd_message.get) ;

3406: , name => 'CRM-DEBUG ERROR' ) ;
3407: fnd_message.set_token(
3408: token => 'ROUTINE'
3409: , value => 'OKI_DBI_LOAD_CLEB_PVT.Update_LHS ' ) ;
3410: bis_collection_utilities.put_line(fnd_message.get) ;
3411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
3412: END Update_LHS;
3413:
3414: /*******************************************************************************

Line 4504: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

4500: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4501: RAISE;
4502: WHEN OTHERS THEN
4503: rlog (sqlerrm || ' ' || sqlcode,0);
4504: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
4505: fnd_message.set_name( application => 'FND'
4506: , name => 'CRM-DEBUG ERROR' ) ;
4507: fnd_message.set_token(
4508: token => 'ROUTINE'

Line 4510: bis_collection_utilities.put_line(fnd_message.get) ;

4506: , name => 'CRM-DEBUG ERROR' ) ;
4507: fnd_message.set_token(
4508: token => 'ROUTINE'
4509: , value => 'OKI_DBI_LOAD_CLEB_PVT.INCR_LOAD' ) ;
4510: bis_collection_utilities.put_line(fnd_message.get) ;
4511: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
4512: END incr_load;
4513:
4514: /* *****************************************************************************

Line 5672: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

5668: RAISE;
5669: WHEN OTHERS THEN
5670: rlog('Error during direct_load: Insert into OKI_DBI_CLE_B Table Failed' , 0);
5671: rlog(sqlerrm ||' '||sqlcode, 0);
5672: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
5673: fnd_message.set_name( application => 'FND'
5674: , name => 'CRM-DEBUG ERROR' ) ;
5675: fnd_message.set_token( token => 'ROUTINE'
5676: , value => 'OKI_DBI_LOAD_CLEB_PVT.direct_load ' ) ;

Line 5677: bis_collection_utilities.put_line(fnd_message.get) ;

5673: fnd_message.set_name( application => 'FND'
5674: , name => 'CRM-DEBUG ERROR' ) ;
5675: fnd_message.set_token( token => 'ROUTINE'
5676: , value => 'OKI_DBI_LOAD_CLEB_PVT.direct_load ' ) ;
5677: bis_collection_utilities.put_line(fnd_message.get) ;
5678: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5679: END direct_load;
5680:
5681: /*******************************************************************************

Line 5958: bis_collection_utilities.put_line(fnd_message.get) ;

5954: , name => 'CRM-DEBUG ERROR' ) ;
5955: fnd_message.set_token(
5956: token => 'ROUTINE'
5957: , value => 'OKI_DBI_LOAD_CLEB_PVT.delta_changes ' ) ;
5958: bis_collection_utilities.put_line(fnd_message.get) ;
5959: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
5960:
5961: END;
5962:

Line 6361: bis_collection_utilities.put_line(fnd_message.get) ;

6357: , name => 'CRM-DEBUG ERROR' ) ;
6358: fnd_message.set_token(
6359: token => 'ROUTINE'
6360: , value => 'OKI_DBI_LOAD_CLEB_PVT.update_staging ' ) ;
6361: bis_collection_utilities.put_line(fnd_message.get) ;
6362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
6363: END ;
6364:
6365: /*******************************************************************************

Line 6489: bis_collection_utilities.put_line(fnd_message.get) ;

6485: , name => 'CRM-DEBUG ERROR' ) ;
6486: fnd_message.set_token(
6487: token => 'ROUTINE'
6488: , value => 'OKI_DBI_LOAD_CLEB_PVT.populate_prev_inc ' ) ;
6489: bis_collection_utilities.put_line(fnd_message.get) ;
6490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
6491: END;
6492:
6493: