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

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

142:
143: -- Set return code to error
144: x_retcode := '2';
145:
146: fnd_message.set_name( application => 'OKI'
147: , name => 'OKI_TABLE_LOAD_FAILURE') ;
148:
149: fnd_message.set_token( token => 'TABLE_NAME'
150: , value => 'OKI_RENEW_BY_STATUSES' ) ;

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

145:
146: fnd_message.set_name( application => 'OKI'
147: , name => 'OKI_TABLE_LOAD_FAILURE') ;
148:
149: fnd_message.set_token( token => 'TABLE_NAME'
150: , value => 'OKI_RENEW_BY_STATUSES' ) ;
151:
152: fnd_file.put_line( which => fnd_file.log
153: , buff => fnd_message.get) ;

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

149: fnd_message.set_token( token => 'TABLE_NAME'
150: , value => 'OKI_RENEW_BY_STATUSES' ) ;
151:
152: fnd_file.put_line( which => fnd_file.log
153: , buff => fnd_message.get) ;
154:
155: fnd_file.put_line( which => fnd_file.log
156: , buff => l_sqlcode||' '||l_sqlerrm ) ;
157:

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

161:
162: -- Set return code to error
163: x_retcode := '2';
164:
165: fnd_message.set_name( application => 'OKI'
166: , name => 'OKI_TABLE_LOAD_FAILURE') ;
167:
168: fnd_message.set_token( token => 'TABLE_NAME'
169: , value => 'OKI_RENEW_BY_STATUSES' ) ;

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

164:
165: fnd_message.set_name( application => 'OKI'
166: , name => 'OKI_TABLE_LOAD_FAILURE') ;
167:
168: fnd_message.set_token( token => 'TABLE_NAME'
169: , value => 'OKI_RENEW_BY_STATUSES' ) ;
170:
171: fnd_file.put_line( which => fnd_file.log
172: , buff => fnd_message.get) ;

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

168: fnd_message.set_token( token => 'TABLE_NAME'
169: , value => 'OKI_RENEW_BY_STATUSES' ) ;
170:
171: fnd_file.put_line( which => fnd_file.log
172: , buff => fnd_message.get) ;
173:
174: fnd_file.put_line( which => fnd_file.log
175: , buff => l_sqlcode||' '||l_sqlerrm ) ;
176: END ins_rnwl_by_stat ;

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

216:
217: -- Set return code to error
218: x_retcode := '2';
219:
220: fnd_message.set_name( application => 'OKI'
221: , name => 'OKI_UNEXPECTED_FAILURE');
222:
223: fnd_message.set_token( token => 'OBJECT_NAME'
224: , value => 'OKI_LOAD_RBS_PVT.UPD_RNWL_BY_STAT');

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

219:
220: fnd_message.set_name( application => 'OKI'
221: , name => 'OKI_UNEXPECTED_FAILURE');
222:
223: fnd_message.set_token( token => 'OBJECT_NAME'
224: , value => 'OKI_LOAD_RBS_PVT.UPD_RNWL_BY_STAT');
225:
226: fnd_file.put_line( which => fnd_file.log
227: , buff => fnd_message.get);

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

223: fnd_message.set_token( token => 'OBJECT_NAME'
224: , value => 'OKI_LOAD_RBS_PVT.UPD_RNWL_BY_STAT');
225:
226: fnd_file.put_line( which => fnd_file.log
227: , buff => fnd_message.get);
228:
229: fnd_file.put_line( which => fnd_file.log
230: , buff => l_sqlcode||' '||l_sqlerrm );
231: END upd_rnwl_by_stat ;

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

666:
667: -- Set return code to error
668: x_retcode := '2';
669:
670: fnd_message.set_name( application => 'OKI'
671: , name => 'OKI_UNEXPECTED_FAILURE');
672:
673: fnd_message.set_token( token => 'OBJECT_NAME'
674: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_DTL1' );

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

669:
670: fnd_message.set_name( application => 'OKI'
671: , name => 'OKI_UNEXPECTED_FAILURE');
672:
673: fnd_message.set_token( token => 'OBJECT_NAME'
674: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_DTL1' );
675:
676: fnd_file.put_line( which => fnd_file.log
677: , buff => fnd_message.get);

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

673: fnd_message.set_token( token => 'OBJECT_NAME'
674: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_DTL1' );
675:
676: fnd_file.put_line( which => fnd_file.log
677: , buff => fnd_message.get);
678:
679: -- Log the location within the procedure where the error occurred
680: fnd_message.set_name( application => 'OKI'
681: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

676: fnd_file.put_line( which => fnd_file.log
677: , buff => fnd_message.get);
678:
679: -- Log the location within the procedure where the error occurred
680: fnd_message.set_name( application => 'OKI'
681: , name => 'OKI_LOC_IN_PROG_FAILURE');
682:
683: fnd_message.set_token( token => 'LOCATION'
684: , value => l_loc);

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

679: -- Log the location within the procedure where the error occurred
680: fnd_message.set_name( application => 'OKI'
681: , name => 'OKI_LOC_IN_PROG_FAILURE');
682:
683: fnd_message.set_token( token => 'LOCATION'
684: , value => l_loc);
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 => 'LOCATION'
684: , value => l_loc);
685:
686: fnd_file.put_line( which => fnd_file.log
687: , buff => fnd_message.get);
688:
689:
690: fnd_file.put_line( which => fnd_file.log
691: , buff => l_sqlcode||' '||l_sqlerrm );

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

1116:
1117: -- Set return code to error
1118: x_retcode := '2';
1119:
1120: fnd_message.set_name( application => 'OKI'
1121: , name => 'OKI_UNEXPECTED_FAILURE');
1122:
1123: fnd_message.set_token( token => 'OBJECT_NAME'
1124: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_DTL1');

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

1119:
1120: fnd_message.set_name( application => 'OKI'
1121: , name => 'OKI_UNEXPECTED_FAILURE');
1122:
1123: fnd_message.set_token( token => 'OBJECT_NAME'
1124: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_DTL1');
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 => 'OBJECT_NAME'
1124: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_DTL1');
1125:
1126: fnd_file.put_line( which => fnd_file.log
1127: , buff => fnd_message.get);
1128:
1129: -- Log the location within the procedure where the error occurred
1130: fnd_message.set_name( application => 'OKI'
1131: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

1126: fnd_file.put_line( which => fnd_file.log
1127: , buff => fnd_message.get);
1128:
1129: -- Log the location within the procedure where the error occurred
1130: fnd_message.set_name( application => 'OKI'
1131: , name => 'OKI_LOC_IN_PROG_FAILURE');
1132:
1133: fnd_message.set_token( token => 'LOCATION'
1134: , value => l_loc);

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

1129: -- Log the location within the procedure where the error occurred
1130: fnd_message.set_name( application => 'OKI'
1131: , name => 'OKI_LOC_IN_PROG_FAILURE');
1132:
1133: fnd_message.set_token( token => 'LOCATION'
1134: , value => l_loc);
1135:
1136: fnd_file.put_line( which => fnd_file.log
1137: , buff => fnd_message.get);

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

1133: fnd_message.set_token( token => 'LOCATION'
1134: , value => l_loc);
1135:
1136: fnd_file.put_line( which => fnd_file.log
1137: , buff => fnd_message.get);
1138:
1139:
1140: fnd_file.put_line( which => fnd_file.log
1141: , buff => l_sqlcode||' '||l_sqlerrm );

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

1522:
1523: -- Set return code to error
1524: x_retcode := '2';
1525:
1526: fnd_message.set_name( application => 'OKI'
1527: , name => 'OKI_UNEXPECTED_FAILURE');
1528:
1529: fnd_message.set_token( token => 'OBJECT_NAME'
1530: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_SUM');

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

1525:
1526: fnd_message.set_name( application => 'OKI'
1527: , name => 'OKI_UNEXPECTED_FAILURE');
1528:
1529: fnd_message.set_token( token => 'OBJECT_NAME'
1530: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_SUM');
1531:
1532: fnd_file.put_line( which => fnd_file.log
1533: , buff => fnd_message.get);

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

1529: fnd_message.set_token( token => 'OBJECT_NAME'
1530: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_SUM');
1531:
1532: fnd_file.put_line( which => fnd_file.log
1533: , buff => fnd_message.get);
1534:
1535: -- Log the location within the procedure where the error occurred
1536: fnd_message.set_name( application => 'OKI'
1537: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

1532: fnd_file.put_line( which => fnd_file.log
1533: , buff => fnd_message.get);
1534:
1535: -- Log the location within the procedure where the error occurred
1536: fnd_message.set_name( application => 'OKI'
1537: , name => 'OKI_LOC_IN_PROG_FAILURE');
1538:
1539: fnd_message.set_token( token => 'LOCATION'
1540: , value => l_loc);

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

1535: -- Log the location within the procedure where the error occurred
1536: fnd_message.set_name( application => 'OKI'
1537: , name => 'OKI_LOC_IN_PROG_FAILURE');
1538:
1539: fnd_message.set_token( token => 'LOCATION'
1540: , value => l_loc);
1541:
1542: fnd_file.put_line( which => fnd_file.log
1543: , buff => fnd_message.get);

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

1539: fnd_message.set_token( token => 'LOCATION'
1540: , value => l_loc);
1541:
1542: fnd_file.put_line( which => fnd_file.log
1543: , buff => fnd_message.get);
1544:
1545:
1546: fnd_file.put_line( which => fnd_file.log
1547: , buff => l_sqlcode||' '||l_sqlerrm );

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

1635: SAVEPOINT oki_load_rbs_pvt_upd_refresh ;
1636:
1637: -- Table loaded successfully. Log message in concurrent manager
1638: -- log indicating successful load.
1639: fnd_message.set_name( application => 'OKI'
1640: , name => 'OKI_TABLE_LOAD_SUCCESS');
1641:
1642: fnd_message.set_token( token => 'TABLE_NAME'
1643: , value => l_table_name );

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

1638: -- log indicating successful load.
1639: fnd_message.set_name( application => 'OKI'
1640: , name => 'OKI_TABLE_LOAD_SUCCESS');
1641:
1642: fnd_message.set_token( token => 'TABLE_NAME'
1643: , value => l_table_name );
1644:
1645: fnd_file.put_line( which => fnd_file.log
1646: , buff => fnd_message.get);

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

1642: fnd_message.set_token( token => 'TABLE_NAME'
1643: , value => l_table_name );
1644:
1645: fnd_file.put_line( which => fnd_file.log
1646: , buff => fnd_message.get);
1647:
1648: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
1649:
1650: IF l_retcode in ('1', '2') THEN

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

1681: -- rollback all transactions
1682: ROLLBACK to oki_load_rbs_pvt_crt_rnwl_cst ;
1683:
1684:
1685: fnd_message.set_name( application => 'OKI'
1686: , name => 'OKI_UNEXPECTED_FAILURE');
1687:
1688: fnd_message.set_token( token => 'OBJECT_NAME'
1689: , value => 'OKI_LOAD_RBS_PVT.CRT_RNWL_BY_STAT');

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

1684:
1685: fnd_message.set_name( application => 'OKI'
1686: , name => 'OKI_UNEXPECTED_FAILURE');
1687:
1688: fnd_message.set_token( token => 'OBJECT_NAME'
1689: , value => 'OKI_LOAD_RBS_PVT.CRT_RNWL_BY_STAT');
1690:
1691: fnd_file.put_line( which => fnd_file.log
1692: , buff => fnd_message.get);

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

1688: fnd_message.set_token( token => 'OBJECT_NAME'
1689: , value => 'OKI_LOAD_RBS_PVT.CRT_RNWL_BY_STAT');
1690:
1691: fnd_file.put_line( which => fnd_file.log
1692: , buff => fnd_message.get);
1693:
1694: fnd_file.put_line( which => fnd_file.log
1695: , buff => l_sqlcode||' '||l_sqlerrm );
1696: end crt_rnwl_by_stat ;