168:
169: -- Set return code to error
170: x_retcode := '2';
171:
172: fnd_message.set_name( application => 'OKI'
173: , name => 'OKI_TABLE_LOAD_FAILURE');
174:
175: fnd_message.set_token( token => 'TABLE_NAME'
176: , value => 'OKI_PERF_MEASURES');
171:
172: fnd_message.set_name( application => 'OKI'
173: , name => 'OKI_TABLE_LOAD_FAILURE');
174:
175: fnd_message.set_token( token => 'TABLE_NAME'
176: , value => 'OKI_PERF_MEASURES');
177:
178: fnd_file.put_line( which => fnd_file.log
179: , buff => fnd_message.get);
175: fnd_message.set_token( token => 'TABLE_NAME'
176: , value => 'OKI_PERF_MEASURES');
177:
178: fnd_file.put_line( which => fnd_file.log
179: , buff => fnd_message.get);
180:
181: fnd_file.put_line( which => fnd_file.log
182: , buff => l_sqlcode||' '||l_sqlerrm );
183:
188:
189: -- Set return code to error
190: x_retcode := '2';
191:
192: fnd_message.set_name( application => 'OKI'
193: , name => 'OKI_TABLE_LOAD_FAILURE');
194:
195: fnd_message.set_token( token => 'TABLE_NAME'
196: , value => 'OKI_PERF_MEASURES');
191:
192: fnd_message.set_name( application => 'OKI'
193: , name => 'OKI_TABLE_LOAD_FAILURE');
194:
195: fnd_message.set_token( token => 'TABLE_NAME'
196: , value => 'OKI_PERF_MEASURES');
197:
198: fnd_file.put_line( which => fnd_file.log
199: , buff => fnd_message.get);
195: fnd_message.set_token( token => 'TABLE_NAME'
196: , value => 'OKI_PERF_MEASURES');
197:
198: fnd_file.put_line( which => fnd_file.log
199: , buff => fnd_message.get);
200:
201: fnd_file.put_line( which => fnd_file.log
202: , buff => l_sqlcode||' '||l_sqlerrm );
203:
240:
241: -- Set return code to error
242: x_retcode := '2';
243:
244: fnd_message.set_name( application => 'OKI'
245: , name => 'OKI_UNEXPECTED_FAILURE');
246:
247: fnd_message.set_token( token => 'OBJECT_NAME'
248: , value => 'OKI_LOAD_OKV_PVT.OKI_UPD_PERF_MEAS');
243:
244: fnd_message.set_name( application => 'OKI'
245: , name => 'OKI_UNEXPECTED_FAILURE');
246:
247: fnd_message.set_token( token => 'OBJECT_NAME'
248: , value => 'OKI_LOAD_OKV_PVT.OKI_UPD_PERF_MEAS');
249:
250: fnd_file.put_line( which => fnd_file.log
251: , buff => fnd_message.get);
247: fnd_message.set_token( token => 'OBJECT_NAME'
248: , value => 'OKI_LOAD_OKV_PVT.OKI_UPD_PERF_MEAS');
249:
250: fnd_file.put_line( which => fnd_file.log
251: , buff => fnd_message.get);
252:
253: fnd_file.put_line( which => fnd_file.log
254: , buff => l_sqlcode||' '||l_sqlerrm );
255: END upd_perf_meas ;
676:
677: -- Set return code TO error
678: x_retcode := '2' ;
679:
680: fnd_message.set_name( application => 'OKI'
681: , name => 'OKI_UNEXPECTED_FAILURE');
682:
683: fnd_message.set_token( token => 'OBJECT_NAME'
684: , value => 'OKI_LOAD_OKV_PVT.CALC_OKV_DTL1');
679:
680: fnd_message.set_name( application => 'OKI'
681: , name => 'OKI_UNEXPECTED_FAILURE');
682:
683: fnd_message.set_token( token => 'OBJECT_NAME'
684: , value => 'OKI_LOAD_OKV_PVT.CALC_OKV_DTL1');
685:
686: fnd_file.put_line( which => fnd_file.log
687: , buff => fnd_message.get);
683: fnd_message.set_token( token => 'OBJECT_NAME'
684: , value => 'OKI_LOAD_OKV_PVT.CALC_OKV_DTL1');
685:
686: fnd_file.put_line( which => fnd_file.log
687: , buff => fnd_message.get);
688:
689: -- Log the location within the procedure where the error occurred
690: fnd_message.set_name( application => 'OKI'
691: , name => 'OKI_LOC_IN_PROG_FAILURE');
686: fnd_file.put_line( which => fnd_file.log
687: , buff => fnd_message.get);
688:
689: -- Log the location within the procedure where the error occurred
690: fnd_message.set_name( application => 'OKI'
691: , name => 'OKI_LOC_IN_PROG_FAILURE');
692:
693: fnd_message.set_token( token => 'LOCATION'
694: , value => l_loc);
689: -- Log the location within the procedure where the error occurred
690: fnd_message.set_name( application => 'OKI'
691: , name => 'OKI_LOC_IN_PROG_FAILURE');
692:
693: fnd_message.set_token( token => 'LOCATION'
694: , value => l_loc);
695:
696: fnd_file.put_line( which => fnd_file.log
697: , buff => fnd_message.get);
693: fnd_message.set_token( token => 'LOCATION'
694: , value => l_loc);
695:
696: fnd_file.put_line( which => fnd_file.log
697: , buff => fnd_message.get);
698:
699: fnd_file.put_line( which => fnd_file.log
700: , buff => l_sqlcode||' '||l_sqlerrm );
701: END calc_okv_dtl1 ;
1106:
1107: -- Set return code TO error
1108: x_retcode := '2' ;
1109:
1110: fnd_message.set_name( application => 'OKI'
1111: , name => 'OKI_UNEXPECTED_FAILURE');
1112:
1113: fnd_message.set_token( token => 'OBJECT_NAME'
1114: , value => 'OKI_LOAD_OKV_PVT.CALC_OKV_DTL2');
1109:
1110: fnd_message.set_name( application => 'OKI'
1111: , name => 'OKI_UNEXPECTED_FAILURE');
1112:
1113: fnd_message.set_token( token => 'OBJECT_NAME'
1114: , value => 'OKI_LOAD_OKV_PVT.CALC_OKV_DTL2');
1115:
1116: fnd_file.put_line( which => fnd_file.log
1117: , buff => fnd_message.get);
1113: fnd_message.set_token( token => 'OBJECT_NAME'
1114: , value => 'OKI_LOAD_OKV_PVT.CALC_OKV_DTL2');
1115:
1116: fnd_file.put_line( which => fnd_file.log
1117: , buff => fnd_message.get);
1118:
1119: -- Log the location within the procedure where the error occurred
1120: fnd_message.set_name( application => 'OKI'
1121: , name => 'OKI_LOC_IN_PROG_FAILURE');
1116: fnd_file.put_line( which => fnd_file.log
1117: , buff => fnd_message.get);
1118:
1119: -- Log the location within the procedure where the error occurred
1120: fnd_message.set_name( application => 'OKI'
1121: , name => 'OKI_LOC_IN_PROG_FAILURE');
1122:
1123: fnd_message.set_token( token => 'LOCATION'
1124: , value => l_loc);
1119: -- Log the location within the procedure where the error occurred
1120: fnd_message.set_name( application => 'OKI'
1121: , name => 'OKI_LOC_IN_PROG_FAILURE');
1122:
1123: fnd_message.set_token( token => 'LOCATION'
1124: , value => l_loc);
1125:
1126: fnd_file.put_line( which => fnd_file.log
1127: , buff => fnd_message.get);
1123: fnd_message.set_token( token => 'LOCATION'
1124: , value => l_loc);
1125:
1126: fnd_file.put_line( which => fnd_file.log
1127: , buff => fnd_message.get);
1128:
1129: fnd_file.put_line( which => fnd_file.log
1130: , buff => l_sqlcode||' '||l_sqlerrm );
1131:
1516:
1517: -- Set return code TO error
1518: x_retcode := '2' ;
1519:
1520: fnd_message.set_name( application => 'OKI'
1521: , name => 'OKI_UNEXPECTED_FAILURE');
1522:
1523: fnd_message.set_token( token => 'OBJECT_NAME'
1524: , value => 'OKI_LOAD_OKV_PVT.CALC_OKV_SUM');
1519:
1520: fnd_message.set_name( application => 'OKI'
1521: , name => 'OKI_UNEXPECTED_FAILURE');
1522:
1523: fnd_message.set_token( token => 'OBJECT_NAME'
1524: , value => 'OKI_LOAD_OKV_PVT.CALC_OKV_SUM');
1525:
1526: fnd_file.put_line( which => fnd_file.log
1527: , buff => fnd_message.get);
1523: fnd_message.set_token( token => 'OBJECT_NAME'
1524: , value => 'OKI_LOAD_OKV_PVT.CALC_OKV_SUM');
1525:
1526: fnd_file.put_line( which => fnd_file.log
1527: , buff => fnd_message.get);
1528:
1529: -- Log the location within the procedure where the error occurred
1530: fnd_message.set_name( application => 'OKI'
1531: , name => 'OKI_LOC_IN_PROG_FAILURE');
1526: fnd_file.put_line( which => fnd_file.log
1527: , buff => fnd_message.get);
1528:
1529: -- Log the location within the procedure where the error occurred
1530: fnd_message.set_name( application => 'OKI'
1531: , name => 'OKI_LOC_IN_PROG_FAILURE');
1532:
1533: fnd_message.set_token( token => 'LOCATION'
1534: , value => l_loc);
1529: -- Log the location within the procedure where the error occurred
1530: fnd_message.set_name( application => 'OKI'
1531: , name => 'OKI_LOC_IN_PROG_FAILURE');
1532:
1533: fnd_message.set_token( token => 'LOCATION'
1534: , value => l_loc);
1535:
1536: fnd_file.put_line( which => fnd_file.log
1537: , buff => fnd_message.get);
1533: fnd_message.set_token( token => 'LOCATION'
1534: , value => l_loc);
1535:
1536: fnd_file.put_line( which => fnd_file.log
1537: , buff => fnd_message.get);
1538:
1539: fnd_file.put_line( which => fnd_file.log
1540: , buff => l_sqlcode||' '||l_sqlerrm );
1541:
1628: SAVEPOINT oki_load_okv_pvt_upd_refresh ;
1629:
1630: -- Table loaded successfully. Log message in concurrent manager
1631: -- log indicating successful load.
1632: fnd_message.set_name( application => 'OKI'
1633: , name => 'OKI_TABLE_LOAD_SUCCESS');
1634:
1635: fnd_message.set_token( token => 'TABLE_NAME'
1636: , value => l_table_name );
1631: -- log indicating successful load.
1632: fnd_message.set_name( application => 'OKI'
1633: , name => 'OKI_TABLE_LOAD_SUCCESS');
1634:
1635: fnd_message.set_token( token => 'TABLE_NAME'
1636: , value => l_table_name );
1637:
1638: fnd_file.put_line( which => fnd_file.log
1639: , buff => fnd_message.get);
1635: fnd_message.set_token( token => 'TABLE_NAME'
1636: , value => l_table_name );
1637:
1638: fnd_file.put_line( which => fnd_file.log
1639: , buff => fnd_message.get);
1640:
1641: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
1642:
1643:
1673: -- ROLLBACK all transactions
1674: ROLLBACK TO oki_load_okv_pvt_crt_perf_meas ;
1675:
1676:
1677: fnd_message.set_name( application => 'OKI'
1678: , name => 'OKI_UNEXPECTED_FAILURE');
1679:
1680: fnd_message.set_token( token => 'OBJECT_NAME'
1681: , value => 'OKI_LOAD_OKV_PVT.CREATE_PERF_MEASURES');
1676:
1677: fnd_message.set_name( application => 'OKI'
1678: , name => 'OKI_UNEXPECTED_FAILURE');
1679:
1680: fnd_message.set_token( token => 'OBJECT_NAME'
1681: , value => 'OKI_LOAD_OKV_PVT.CREATE_PERF_MEASURES');
1682:
1683: fnd_file.put_line( which => fnd_file.log
1684: , buff => fnd_message.get);
1680: fnd_message.set_token( token => 'OBJECT_NAME'
1681: , value => 'OKI_LOAD_OKV_PVT.CREATE_PERF_MEASURES');
1682:
1683: fnd_file.put_line( which => fnd_file.log
1684: , buff => fnd_message.get);
1685:
1686: fnd_file.put_line( which => fnd_file.log
1687: , buff => l_sqlcode||' '||l_sqlerrm );
1688: END create_perf_measures ;