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_LOAD_RBK_PVT dependencies on FND_MESSAGE

Line 132: fnd_message.set_name( application => 'OKI'

128:
129: -- Set return code TO error
130: x_retcode := '2';
131:
132: fnd_message.set_name( application => 'OKI'
133: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
134:
135: fnd_message.set_token( token => 'TABLE_NAME'
136: , value => 'OKI_RNWL_BOOKINGS' ) ;

Line 135: fnd_message.set_token( token => 'TABLE_NAME'

131:
132: fnd_message.set_name( application => 'OKI'
133: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
134:
135: fnd_message.set_token( token => 'TABLE_NAME'
136: , value => 'OKI_RNWL_BOOKINGS' ) ;
137:
138: fnd_file.put_line( which => fnd_file.log
139: , buff => fnd_message.get ) ;

Line 139: , buff => fnd_message.get ) ;

135: fnd_message.set_token( token => 'TABLE_NAME'
136: , value => 'OKI_RNWL_BOOKINGS' ) ;
137:
138: fnd_file.put_line( which => fnd_file.log
139: , buff => fnd_message.get ) ;
140:
141: fnd_file.put_line( which => fnd_file.log
142: , buff => l_sqlcode||' '|| l_sqlerrm ) ;
143: END ins_rnwl_bkng ;

Line 194: fnd_message.set_name( application => 'OKI'

190:
191: -- Set return code to error
192: x_retcode := '2';
193:
194: fnd_message.set_name( application => 'OKI'
195: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
196:
197: fnd_message.set_token( token => 'OBJECT_NAME'
198: , value => 'OKI_LOAD_RBK_PVT.UPD_RNWL_BKNG' ) ;

Line 197: fnd_message.set_token( token => 'OBJECT_NAME'

193:
194: fnd_message.set_name( application => 'OKI'
195: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
196:
197: fnd_message.set_token( token => 'OBJECT_NAME'
198: , value => 'OKI_LOAD_RBK_PVT.UPD_RNWL_BKNG' ) ;
199:
200: fnd_file.put_line( which => fnd_file.log
201: , buff => fnd_message.get );

Line 201: , buff => fnd_message.get );

197: fnd_message.set_token( token => 'OBJECT_NAME'
198: , value => 'OKI_LOAD_RBK_PVT.UPD_RNWL_BKNG' ) ;
199:
200: fnd_file.put_line( which => fnd_file.log
201: , buff => fnd_message.get );
202:
203: fnd_file.put_line( which => fnd_file.log
204: , buff => l_sqlcode||' '|| l_sqlerrm ) ;
205: END upd_rnwl_bkng ;

Line 1193: fnd_message.set_name( application => 'OKI'

1189: -- Set return code TO error
1190: x_retcode := '2' ;
1191:
1192: -- Log the location within the procedure where the error occurred
1193: fnd_message.set_name( application => 'OKI'
1194: , name => 'OKI_LOC_IN_PROG_FAILURE');
1195:
1196: fnd_message.set_token( token => 'LOCATION'
1197: , value => l_loc);

Line 1196: fnd_message.set_token( token => 'LOCATION'

1192: -- Log the location within the procedure where the error occurred
1193: fnd_message.set_name( application => 'OKI'
1194: , name => 'OKI_LOC_IN_PROG_FAILURE');
1195:
1196: fnd_message.set_token( token => 'LOCATION'
1197: , value => l_loc);
1198:
1199: fnd_file.put_line( which => fnd_file.log
1200: , buff => fnd_message.get);

Line 1200: , buff => fnd_message.get);

1196: fnd_message.set_token( token => 'LOCATION'
1197: , value => l_loc);
1198:
1199: fnd_file.put_line( which => fnd_file.log
1200: , buff => fnd_message.get);
1201:
1202: fnd_file.put_line( which => fnd_file.log
1203: , buff => l_sqlcode || ' ' || l_sqlerrm );
1204:

Line 1212: fnd_message.set_name( application => 'OKI'

1208: l_sqlerrm := SQLERRM ;
1209: -- Set return code TO error
1210: x_retcode := '2' ;
1211:
1212: fnd_message.set_name( application => 'OKI'
1213: , name => 'OKI_UNEXPECTED_FAILURE');
1214:
1215: fnd_message.set_token( token => 'OBJECT_NAME'
1216: , value => 'OKI_LOAD_RBK_PVT.CALC_RBK_DLTL1');

Line 1215: fnd_message.set_token( token => 'OBJECT_NAME'

1211:
1212: fnd_message.set_name( application => 'OKI'
1213: , name => 'OKI_UNEXPECTED_FAILURE');
1214:
1215: fnd_message.set_token( token => 'OBJECT_NAME'
1216: , value => 'OKI_LOAD_RBK_PVT.CALC_RBK_DLTL1');
1217:
1218: fnd_file.put_line( which => fnd_file.log
1219: , buff => fnd_message.get);

Line 1219: , buff => fnd_message.get);

1215: fnd_message.set_token( token => 'OBJECT_NAME'
1216: , value => 'OKI_LOAD_RBK_PVT.CALC_RBK_DLTL1');
1217:
1218: fnd_file.put_line( which => fnd_file.log
1219: , buff => fnd_message.get);
1220:
1221: -- Log the location within the procedure where the error occurred
1222: fnd_message.set_name( application => 'OKI'
1223: , name => 'OKI_LOC_IN_PROG_FAILURE');

Line 1222: fnd_message.set_name( application => 'OKI'

1218: fnd_file.put_line( which => fnd_file.log
1219: , buff => fnd_message.get);
1220:
1221: -- Log the location within the procedure where the error occurred
1222: fnd_message.set_name( application => 'OKI'
1223: , name => 'OKI_LOC_IN_PROG_FAILURE');
1224:
1225: fnd_message.set_token( token => 'LOCATION'
1226: , value => l_loc);

Line 1225: fnd_message.set_token( token => 'LOCATION'

1221: -- Log the location within the procedure where the error occurred
1222: fnd_message.set_name( application => 'OKI'
1223: , name => 'OKI_LOC_IN_PROG_FAILURE');
1224:
1225: fnd_message.set_token( token => 'LOCATION'
1226: , value => l_loc);
1227:
1228: fnd_file.put_line( which => fnd_file.log
1229: , buff => fnd_message.get);

Line 1229: , buff => fnd_message.get);

1225: fnd_message.set_token( token => 'LOCATION'
1226: , value => l_loc);
1227:
1228: fnd_file.put_line( which => fnd_file.log
1229: , buff => fnd_message.get);
1230:
1231: fnd_file.put_line( which => fnd_file.log
1232: , buff => l_sqlcode||' '|| l_sqlerrm );
1233: END calc_rbk_dtl1 ;

Line 2229: fnd_message.set_name( application => 'OKI'

2225: -- Set return code TO error
2226: x_retcode := '2' ;
2227:
2228: -- Log the location within the procedure where the error occurred
2229: fnd_message.set_name( application => 'OKI'
2230: , name => 'OKI_LOC_IN_PROG_FAILURE');
2231:
2232: fnd_message.set_token( token => 'LOCATION'
2233: , value => l_loc);

Line 2232: fnd_message.set_token( token => 'LOCATION'

2228: -- Log the location within the procedure where the error occurred
2229: fnd_message.set_name( application => 'OKI'
2230: , name => 'OKI_LOC_IN_PROG_FAILURE');
2231:
2232: fnd_message.set_token( token => 'LOCATION'
2233: , value => l_loc);
2234:
2235: fnd_file.put_line( which => fnd_file.log
2236: , buff => fnd_message.get);

Line 2236: , buff => fnd_message.get);

2232: fnd_message.set_token( token => 'LOCATION'
2233: , value => l_loc);
2234:
2235: fnd_file.put_line( which => fnd_file.log
2236: , buff => fnd_message.get);
2237:
2238: fnd_file.put_line( which => fnd_file.log
2239: , buff => l_sqlcode || ' ' || l_sqlerrm );
2240:

Line 2249: fnd_message.set_name( application => 'OKI'

2245:
2246: -- Set return code TO error
2247: x_retcode := '2' ;
2248:
2249: fnd_message.set_name( application => 'OKI'
2250: , name => 'OKI_UNEXPECTED_FAILURE');
2251:
2252: fnd_message.set_token( token => 'OBJECT_NAME'
2253: , value => 'OKI_LOAD_RBK_PVT.CALC_RBK_SUM');

Line 2252: fnd_message.set_token( token => 'OBJECT_NAME'

2248:
2249: fnd_message.set_name( application => 'OKI'
2250: , name => 'OKI_UNEXPECTED_FAILURE');
2251:
2252: fnd_message.set_token( token => 'OBJECT_NAME'
2253: , value => 'OKI_LOAD_RBK_PVT.CALC_RBK_SUM');
2254:
2255: fnd_file.put_line( which => fnd_file.log
2256: , buff => fnd_message.get);

Line 2256: , buff => fnd_message.get);

2252: fnd_message.set_token( token => 'OBJECT_NAME'
2253: , value => 'OKI_LOAD_RBK_PVT.CALC_RBK_SUM');
2254:
2255: fnd_file.put_line( which => fnd_file.log
2256: , buff => fnd_message.get);
2257:
2258: -- Log the location within the procedure where the error occurred
2259: fnd_message.set_name( application => 'OKI'
2260: , name => 'OKI_LOC_IN_PROG_FAILURE');

Line 2259: fnd_message.set_name( application => 'OKI'

2255: fnd_file.put_line( which => fnd_file.log
2256: , buff => fnd_message.get);
2257:
2258: -- Log the location within the procedure where the error occurred
2259: fnd_message.set_name( application => 'OKI'
2260: , name => 'OKI_LOC_IN_PROG_FAILURE');
2261:
2262: fnd_message.set_token( token => 'LOCATION'
2263: , value => l_loc);

Line 2262: fnd_message.set_token( token => 'LOCATION'

2258: -- Log the location within the procedure where the error occurred
2259: fnd_message.set_name( application => 'OKI'
2260: , name => 'OKI_LOC_IN_PROG_FAILURE');
2261:
2262: fnd_message.set_token( token => 'LOCATION'
2263: , value => l_loc);
2264:
2265: fnd_file.put_line( which => fnd_file.log
2266: , buff => fnd_message.get);

Line 2266: , buff => fnd_message.get);

2262: fnd_message.set_token( token => 'LOCATION'
2263: , value => l_loc);
2264:
2265: fnd_file.put_line( which => fnd_file.log
2266: , buff => fnd_message.get);
2267:
2268: fnd_file.put_line( which => fnd_file.log
2269: , buff => l_sqlcode||' '|| l_sqlerrm );
2270: END calc_rbk_sum ;

Line 2366: fnd_message.set_name( application => 'OKI'

2362:
2363:
2364: -- Table loaded successfully. Log message IN concurrent manager
2365: -- log indicating successful load.
2366: fnd_message.set_name( application => 'OKI'
2367: , name => 'OKI_TABLE_LOAD_SUCCESS');
2368:
2369: fnd_message.set_token( token => 'TABLE_NAME'
2370: , value => l_table_name );

Line 2369: fnd_message.set_token( token => 'TABLE_NAME'

2365: -- log indicating successful load.
2366: fnd_message.set_name( application => 'OKI'
2367: , name => 'OKI_TABLE_LOAD_SUCCESS');
2368:
2369: fnd_message.set_token( token => 'TABLE_NAME'
2370: , value => l_table_name );
2371:
2372: fnd_file.put_line( which => fnd_file.log
2373: , buff => fnd_message.get);

Line 2373: , buff => fnd_message.get);

2369: fnd_message.set_token( token => 'TABLE_NAME'
2370: , value => l_table_name );
2371:
2372: fnd_file.put_line( which => fnd_file.log
2373: , buff => fnd_message.get);
2374:
2375: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
2376:
2377: IF l_retcode in ('1', '2') THEN

Line 2411: fnd_message.set_name( application => 'OKI'

2407: -- ROLLBACK all transactions
2408: ROLLBACK TO oki_etr_rnwl_bkng ;
2409:
2410:
2411: fnd_message.set_name( application => 'OKI'
2412: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
2413:
2414: fnd_message.set_token( token => 'OBJECT_NAME'
2415: , value => 'OKI_LOAD_RBK_PVT.CRT_RNWL_BKNG' ) ;

Line 2414: fnd_message.set_token( token => 'OBJECT_NAME'

2410:
2411: fnd_message.set_name( application => 'OKI'
2412: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
2413:
2414: fnd_message.set_token( token => 'OBJECT_NAME'
2415: , value => 'OKI_LOAD_RBK_PVT.CRT_RNWL_BKNG' ) ;
2416:
2417: fnd_file.put_line( which => fnd_file.log
2418: , buff => fnd_message.get ) ;

Line 2418: , buff => fnd_message.get ) ;

2414: fnd_message.set_token( token => 'OBJECT_NAME'
2415: , value => 'OKI_LOAD_RBK_PVT.CRT_RNWL_BKNG' ) ;
2416:
2417: fnd_file.put_line( which => fnd_file.log
2418: , buff => fnd_message.get ) ;
2419:
2420: fnd_file.put_line( which => fnd_file.log
2421: , buff => l_sqlcode||' '||l_sqlerrm ) ;
2422: END crt_rnwl_bkng ;