DBA Data[Home] [Help]

APPS.OKI_LOAD_OKV_PVT dependencies on FND_MESSAGE

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

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

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

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

Line 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:

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

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

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

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

Line 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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 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:

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

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

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

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

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

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

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

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

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

Line 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:

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

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

Line 1635: fnd_message.set_token( token => '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);

Line 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:

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

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

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

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

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