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 FND_MESSAGE

Line 35: fnd_message.set_name( application => 'FND'

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' ) ;
39: bis_collection_utilities.put_line(fnd_message.get) ;

Line 37: fnd_message.set_token( token => 'ROUTINE'

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' ) ;
39: bis_collection_utilities.put_line(fnd_message.get) ;
40: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
41: END rlog;

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 56: fnd_message.set_name( application => 'FND'

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 ' ) ;
60: bis_collection_utilities.put_line(fnd_message.get) ;

Line 58: fnd_message.set_token( token => 'ROUTINE'

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 ' ) ;
60: bis_collection_utilities.put_line(fnd_message.get) ;
61: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
62: END rout;

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 114: errbuf := fnd_message.get;

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);
117: END IF;
118:

Line 186: fnd_message.set_name( application => 'FND'

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'
190: , value => 'OKI_DBI_LOAD_CLEB_PVT.INITIAL_LOAD ' ) ;

Line 188: fnd_message.set_token(

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'
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;

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 255: fnd_message.set_name( application => 'FND'

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'
259: , value => 'OKI_DBI_LOAD_CLEB_PVT.RESET_BASE_TABLES ' ) ;

Line 257: fnd_message.set_token(

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'
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;

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 314: errbuf := fnd_message.get;

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);
317: END IF;
318:

Line 471: fnd_message.set_name( application => 'FND'

467: errbuf || ': ' || retcode,
468: OKI_DBI_LOAD_CLEB_PVT.g_start_date,
469: OKI_DBI_LOAD_CLEB_PVT.g_end_date
470: ) ;
471: fnd_message.set_name( application => 'FND'
472: , name => 'CRM-DEBUG ERROR' ) ;
473: fnd_message.set_token(
474: token => 'ROUTINE'
475: , value => 'OKI_DBI_LOAD_CLEB_PVT.populate_base_tables ' ) ;

Line 473: fnd_message.set_token(

469: OKI_DBI_LOAD_CLEB_PVT.g_end_date
470: ) ;
471: fnd_message.set_name( application => 'FND'
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;

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 1040: fnd_message.set_name( application => 'FND'

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'
1044: , value => 'OKI_DBI_LOAD_CLEB_PVT.POPULATE_INC_TABLE_INIT ' ) ;

Line 1042: fnd_message.set_token(

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'
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 ;

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 1702: fnd_message.set_name( application => 'FND'

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'
1706: , value => 'OKI_DBI_LOAD_CLEB_PVT.POPULATE_INC_TABLE_INC ' ) ;

Line 1704: fnd_message.set_token(

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'
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 ;

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 1783: fnd_message.set_name( application => 'FND'

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' ) ;
1787: bis_collection_utilities.put_line(fnd_message.get) ;

Line 1785: fnd_message.set_token( token => 'ROUTINE'

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' ) ;
1787: bis_collection_utilities.put_line(fnd_message.get) ;
1788: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1789:

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 2105: fnd_message.set_name( application => 'FND'

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'
2109: , value => 'OKI_DBI_LOAD_CLEB_PVT.report_missing_currencies ' ) ;

Line 2107: fnd_message.set_token(

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'
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 ;

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 2171: fnd_message.set_name( application => 'FND'

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'
2175: , value => 'OKI_DBI_LOAD_CLEB_PVT.PROCESS_DELETES ' ) ;

Line 2173: fnd_message.set_token(

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'
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;

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 2981: fnd_message.set_name( application => 'FND'

2977: WHEN OTHERS THEN
2978: rlog('Error during load_staging: ' || l_location || ' Failed' , 0);
2979: rlog(sqlerrm ||' '||sqlcode, 0) ;
2980: rlog(l_location , 0) ;
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) ;

Line 2983: fnd_message.set_token( token => 'ROUTINE'

2979: rlog(sqlerrm ||' '||sqlcode, 0) ;
2980: rlog(l_location , 0) ;
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;

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 3204: fnd_message.set_name( application => 'FND'

3200: WHEN OTHERS THEN
3201: rlog('Error in populate_ren_rel: Insert into OKI_DBI_REN_INC FAILED', 0);
3202: rlog(sqlerrm ||' '||sqlcode, 0);
3203: rlog(l_location , 0);
3204: fnd_message.set_name( application => 'FND'
3205: , name => 'CRM-DEBUG ERROR' ) ;
3206: fnd_message.set_token(
3207: token => 'ROUTINE'
3208: , value => 'OKI_DBI_LOAD_CLEB_PVT.POPULATE_REN_REL' ) ;

Line 3206: fnd_message.set_token(

3202: rlog(sqlerrm ||' '||sqlcode, 0);
3203: rlog(l_location , 0);
3204: fnd_message.set_name( application => 'FND'
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;

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 3281: fnd_message.set_name( application => 'FND'

3277: WHEN OTHERS THEN
3278: rlog('Error in update_RHS: ',0);
3279: rlog(SQLERRM ||' '||SQLCODE, 0) ;
3280: rlog(l_location || ' Failed', 0) ;
3281: fnd_message.set_name( application => 'FND'
3282: , name => 'CRM-DEBUG ERROR' ) ;
3283: fnd_message.set_token(
3284: token => 'ROUTINE'
3285: , value => 'OKI_DBI_LOAD_CLEB_PVT.Update_RHS ' ) ;

Line 3283: fnd_message.set_token(

3279: rlog(SQLERRM ||' '||SQLCODE, 0) ;
3280: rlog(l_location || ' Failed', 0) ;
3281: fnd_message.set_name( application => 'FND'
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 ;

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 3405: fnd_message.set_name( application => 'FND'

3401: WHEN OTHERS THEN
3402: rlog('Error in update_LHS: Updating LHS information in OKI_DBI_CLE_B_OLD FAILED',0);
3403: rlog(sqlerrm ||' '||sqlcode, 0) ;
3404: rlog(l_location , 0) ;
3405: fnd_message.set_name( application => 'FND'
3406: , name => 'CRM-DEBUG ERROR' ) ;
3407: fnd_message.set_token(
3408: token => 'ROUTINE'
3409: , value => 'OKI_DBI_LOAD_CLEB_PVT.Update_LHS ' ) ;

Line 3407: fnd_message.set_token(

3403: rlog(sqlerrm ||' '||sqlcode, 0) ;
3404: rlog(l_location , 0) ;
3405: fnd_message.set_name( application => 'FND'
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 ;

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 4505: fnd_message.set_name( application => 'FND'

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'
4509: , value => 'OKI_DBI_LOAD_CLEB_PVT.INCR_LOAD' ) ;

Line 4507: fnd_message.set_token(

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'
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 ;

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 5673: fnd_message.set_name( application => 'FND'

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 ' ) ;
5677: bis_collection_utilities.put_line(fnd_message.get) ;

Line 5675: fnd_message.set_token( token => 'ROUTINE'

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 ' ) ;
5677: bis_collection_utilities.put_line(fnd_message.get) ;
5678: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5679: END 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 5953: fnd_message.set_name( application => 'FND'

5949: WHEN OTHERS THEN
5950: rlog('Error in delta_changes: ',0);
5951: rlog(SQLERRM ||' '||SQLCODE, 0) ;
5952: rlog(l_location || ' Failed', 0) ;
5953: fnd_message.set_name( application => 'FND'
5954: , name => 'CRM-DEBUG ERROR' ) ;
5955: fnd_message.set_token(
5956: token => 'ROUTINE'
5957: , value => 'OKI_DBI_LOAD_CLEB_PVT.delta_changes ' ) ;

Line 5955: fnd_message.set_token(

5951: rlog(SQLERRM ||' '||SQLCODE, 0) ;
5952: rlog(l_location || ' Failed', 0) ;
5953: fnd_message.set_name( application => 'FND'
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 ;

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 6356: fnd_message.set_name( application => 'FND'

6352: WHEN OTHERS THEN
6353: rlog('Error in update_staging : ',0);
6354: rlog(SQLERRM ||' '||SQLCODE, 0) ;
6355: rlog(l_location || ' Failed', 0) ;
6356: fnd_message.set_name( application => 'FND'
6357: , name => 'CRM-DEBUG ERROR' ) ;
6358: fnd_message.set_token(
6359: token => 'ROUTINE'
6360: , value => 'OKI_DBI_LOAD_CLEB_PVT.update_staging ' ) ;

Line 6358: fnd_message.set_token(

6354: rlog(SQLERRM ||' '||SQLCODE, 0) ;
6355: rlog(l_location || ' Failed', 0) ;
6356: fnd_message.set_name( application => 'FND'
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 ;

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 6484: fnd_message.set_name( application => 'FND'

6480: WHEN OTHERS THEN
6481: rlog('Error in populate_prev_inc: ',0);
6482: rlog(SQLERRM ||' '||SQLCODE, 0) ;
6483: rlog(l_location || ' Failed', 0) ;
6484: fnd_message.set_name( application => 'FND'
6485: , name => 'CRM-DEBUG ERROR' ) ;
6486: fnd_message.set_token(
6487: token => 'ROUTINE'
6488: , value => 'OKI_DBI_LOAD_CLEB_PVT.populate_prev_inc ' ) ;

Line 6486: fnd_message.set_token(

6482: rlog(SQLERRM ||' '||SQLCODE, 0) ;
6483: rlog(l_location || ' Failed', 0) ;
6484: fnd_message.set_name( application => 'FND'
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 ;

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: