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 OKC_API

Line 40: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: /* *****************************************************************************
44: Procedure:rout

Line 61: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: /* *****************************************************************************
65: Procedure:gather_table_stats

Line 180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

176: WHEN OTHERS THEN
177: rlog('Unable to calculate load ran time ', 0);
178: END;
179: EXCEPTION
180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
181: RAISE;
182: WHEN OTHERS THEN
183: errbuf := SQLERRM ;
184: retcode := SQLCODE ;

Line 192: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /* *****************************************************************************
196: Procedure:reset_base_tables

Line 248: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

244: rlog( 'Completed resetting base tables and BIS log file ' || fnd_date.date_to_displayDT(sysdate),1);
245: END IF;
246:
247: EXCEPTION
248: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
249: RAISE;
250: WHEN OTHERS
251: THEN
252: errbuf := sqlerrm;

Line 261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /* *****************************************************************************
265: Procedure:populate_base_tables

Line 459: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

455: END;
456: END IF;
457:
458: EXCEPTION
459: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
460: RAISE;
461: WHEN OTHERS
462: THEN
463: retcode := SQLCODE ;

Line 477: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /* *****************************************************************************
481: Procedure:populate_inc_table_init

Line 1035: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1031: rlog('Load of Incremental Table OKI_DBI_CHR_INC completed - ' ||
1032: fnd_date.date_to_displayDT(SYSDATE),1) ;
1033:
1034: EXCEPTION
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 ) ;

Line 1046: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /* *****************************************************************************
1050: Procedure:populate_inc_table_inc

Line 1697: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1693:
1694: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_INC') ;
1695: END IF ;
1696: EXCEPTION
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 ) ;

Line 1708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /* *****************************************************************************
1712: Procedure:load_currencies

Line 1777: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1773:
1774:
1775:
1776: EXCEPTION
1777: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
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);

Line 1788: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:
1792: /* *****************************************************************************

Line 2101: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2097: END IF;
2098: /**************changes for secondary global currency conversion ends here*******/
2099:
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'

Line 2111: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /* *****************************************************************************
2115: Procedure:process_deletes

Line 2167: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2163: COMMIT;
2164: END IF ;
2165:
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'

Line 2177: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /* *****************************************************************************
2181: Procedure:load_staging

Line 2975: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2971: ||fnd_date.date_to_displayDT(sysdate), 1) ;
2972: COMMIT;
2973:
2974: EXCEPTION
2975: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2976: RAISE;
2977: WHEN OTHERS THEN
2978: rlog('Error during load_staging: ' || l_location || ' Failed' , 0);
2979: rlog(sqlerrm ||' '||sqlcode, 0) ;

Line 2986: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;

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: /*******************************************************************************
2990: Procedure: populate_ren_rel

Line 3198: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3194: GATHER_TABLE_STATS( TABNAME=>'OKI_DBI_REN_INC' );
3195:
3196:
3197: EXCEPTION
3198: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3199: RAISE;
3200: WHEN OTHERS THEN
3201: rlog('Error in populate_ren_rel: Insert into OKI_DBI_REN_INC FAILED', 0);
3202: rlog(sqlerrm ||' '||sqlcode, 0);

Line 3210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /*******************************************************************************
3214: Procedure: UPdate_RHS

Line 3287: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /*******************************************************************************
3291: Procedure: UPdate_LHS

Line 3411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /*******************************************************************************
3415: Procedure: incr_load

Line 4500: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4496: rlog('Updation of summary table OKI_DBI_CLE_B from OKI_DBI_CLE_B_OLD completed: '
4497: ||fnd_date.date_to_displayDT(sysdate), 1) ;
4498:
4499: EXCEPTION
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 ) ;

Line 4511: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /* *****************************************************************************
4515: Procedure : direct_load

Line 5667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5663: rlog('Load of Base Summary Table OKI_DBI_CLE_B Completed - ' ||
5664: fnd_date.date_to_displayDT(SYSDATE),1) ;
5665:
5666: EXCEPTION
5667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
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);

Line 5678: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: /*******************************************************************************
5682: Procedure: worker

Line 5959: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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:
5963: /*******************************************************************************

Line 6362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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: /*******************************************************************************
6366: Procedure: populate_prev_inc

Line 6490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_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:
6494: