DBA Data[Home] [Help]

APPS.OKI_LOAD_RBK_PVT dependencies on FND_FILE

Line 138: fnd_file.put_line( which => fnd_file.log

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 ) ;
140:
141: fnd_file.put_line( which => fnd_file.log
142: , buff => l_sqlcode||' '|| l_sqlerrm ) ;

Line 141: fnd_file.put_line( which => fnd_file.log

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 ;
144: --------------------------------------------------------------------------------
145: --

Line 200: fnd_file.put_line( which => fnd_file.log

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 );
202:
203: fnd_file.put_line( which => fnd_file.log
204: , buff => l_sqlcode||' '|| l_sqlerrm ) ;

Line 203: fnd_file.put_line( which => fnd_file.log

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 ;
206:
207: --------------------------------------------------------------------------------

Line 1199: fnd_file.put_line( which => fnd_file.log

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);
1201:
1202: fnd_file.put_line( which => fnd_file.log
1203: , buff => l_sqlcode || ' ' || l_sqlerrm );

Line 1202: fnd_file.put_line( which => fnd_file.log

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:
1205: WHEN OTHERS THEN
1206:

Line 1218: fnd_file.put_line( which => fnd_file.log

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);
1220:
1221: -- Log the location within the procedure where the error occurred
1222: fnd_message.set_name( application => 'OKI'

Line 1228: fnd_file.put_line( which => fnd_file.log

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);
1230:
1231: fnd_file.put_line( which => fnd_file.log
1232: , buff => l_sqlcode||' '|| l_sqlerrm );

Line 1231: fnd_file.put_line( which => fnd_file.log

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 ;
1234:
1235: --------------------------------------------------------------------------------

Line 2235: fnd_file.put_line( which => fnd_file.log

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);
2237:
2238: fnd_file.put_line( which => fnd_file.log
2239: , buff => l_sqlcode || ' ' || l_sqlerrm );

Line 2238: fnd_file.put_line( which => fnd_file.log

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:
2241: WHEN OTHERS THEN
2242:

Line 2255: fnd_file.put_line( which => fnd_file.log

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);
2257:
2258: -- Log the location within the procedure where the error occurred
2259: fnd_message.set_name( application => 'OKI'

Line 2265: fnd_file.put_line( which => fnd_file.log

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);
2267:
2268: fnd_file.put_line( which => fnd_file.log
2269: , buff => l_sqlcode||' '|| l_sqlerrm );

Line 2268: fnd_file.put_line( which => fnd_file.log

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 ;
2271: --------------------------------------------------------------------------------
2272: --

Line 2372: fnd_file.put_line( which => fnd_file.log

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);
2374:
2375: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
2376:

Line 2417: fnd_file.put_line( which => fnd_file.log

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 ) ;
2419:
2420: fnd_file.put_line( which => fnd_file.log
2421: , buff => l_sqlcode||' '||l_sqlerrm ) ;

Line 2420: fnd_file.put_line( which => fnd_file.log

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 ;
2423:
2424: BEGIN