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

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

135:
136: -- Set return code TO error
137: x_retcode := '2';
138:
139: fnd_message.set_name( application => 'OKI'
140: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
141:
142: fnd_message.set_token( token => 'TABLE_NAME'
143: , value => 'OKI_EXP_TO_RNWL' ) ;

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

138:
139: fnd_message.set_name( application => 'OKI'
140: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
141:
142: fnd_message.set_token( token => 'TABLE_NAME'
143: , value => 'OKI_EXP_TO_RNWL' ) ;
144:
145: fnd_file.put_line( which => fnd_file.log
146: , buff => fnd_message.get ) ;

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

142: fnd_message.set_token( token => 'TABLE_NAME'
143: , value => 'OKI_EXP_TO_RNWL' ) ;
144:
145: fnd_file.put_line( which => fnd_file.log
146: , buff => fnd_message.get ) ;
147:
148: fnd_file.put_line( which => fnd_file.log
149: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
150: END ins_exp_to_rnwl ;

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

200:
201: -- Set return code to error
202: x_retcode := '2';
203:
204: fnd_message.set_name( application => 'OKI'
205: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
206:
207: fnd_message.set_token( token => 'OBJECT_NAME'
208: , value => 'OKI_LOAD_ETR_PVT.UPD_EXP_TO_RNWL' ) ;

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

203:
204: fnd_message.set_name( application => 'OKI'
205: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
206:
207: fnd_message.set_token( token => 'OBJECT_NAME'
208: , value => 'OKI_LOAD_ETR_PVT.UPD_EXP_TO_RNWL' ) ;
209:
210: fnd_file.put_line( which => fnd_file.log
211: , buff => fnd_message.get );

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

207: fnd_message.set_token( token => 'OBJECT_NAME'
208: , value => 'OKI_LOAD_ETR_PVT.UPD_EXP_TO_RNWL' ) ;
209:
210: fnd_file.put_line( which => fnd_file.log
211: , buff => fnd_message.get );
212:
213: fnd_file.put_line( which => fnd_file.log
214: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;
215: END upd_exp_to_rnwl ;

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

1115: -- Set return code TO error
1116: x_retcode := '2' ;
1117:
1118: -- Log the location within the procedure where the error occurred
1119: fnd_message.set_name( application => 'OKI'
1120: , name => 'OKI_LOC_IN_PROG_FAILURE');
1121:
1122: fnd_message.set_token( token => 'LOCATION'
1123: , value => l_loc);

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

1118: -- Log the location within the procedure where the error occurred
1119: fnd_message.set_name( application => 'OKI'
1120: , name => 'OKI_LOC_IN_PROG_FAILURE');
1121:
1122: fnd_message.set_token( token => 'LOCATION'
1123: , value => l_loc);
1124:
1125: fnd_file.put_line( which => fnd_file.log
1126: , buff => fnd_message.get);

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

1122: fnd_message.set_token( token => 'LOCATION'
1123: , value => l_loc);
1124:
1125: fnd_file.put_line( which => fnd_file.log
1126: , buff => fnd_message.get);
1127:
1128: fnd_file.put_line( which => fnd_file.log
1129: , buff => l_sqlcode || ' ' || l_sqlerrm );
1130: WHEN OTHERS THEN

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

1134:
1135: -- Set return code TO error
1136: x_retcode := '2' ;
1137:
1138: fnd_message.set_name( application => 'OKI'
1139: , name => 'OKI_UNEXPECTED_FAILURE');
1140:
1141: fnd_message.set_token( token => 'OBJECT_NAME'
1142: , value => 'OKI_LOAD_ETR_PVT.CALC_ETR_DTL1');

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

1137:
1138: fnd_message.set_name( application => 'OKI'
1139: , name => 'OKI_UNEXPECTED_FAILURE');
1140:
1141: fnd_message.set_token( token => 'OBJECT_NAME'
1142: , value => 'OKI_LOAD_ETR_PVT.CALC_ETR_DTL1');
1143:
1144: fnd_file.put_line( which => fnd_file.log
1145: , buff => fnd_message.get);

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

1141: fnd_message.set_token( token => 'OBJECT_NAME'
1142: , value => 'OKI_LOAD_ETR_PVT.CALC_ETR_DTL1');
1143:
1144: fnd_file.put_line( which => fnd_file.log
1145: , buff => fnd_message.get);
1146:
1147: -- Log the location within the procedure where the error occurred
1148: fnd_message.set_name( application => 'OKI'
1149: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

1144: fnd_file.put_line( which => fnd_file.log
1145: , buff => fnd_message.get);
1146:
1147: -- Log the location within the procedure where the error occurred
1148: fnd_message.set_name( application => 'OKI'
1149: , name => 'OKI_LOC_IN_PROG_FAILURE');
1150:
1151: fnd_message.set_token( token => 'LOCATION'
1152: , value => l_loc);

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

1147: -- Log the location within the procedure where the error occurred
1148: fnd_message.set_name( application => 'OKI'
1149: , name => 'OKI_LOC_IN_PROG_FAILURE');
1150:
1151: fnd_message.set_token( token => 'LOCATION'
1152: , value => l_loc);
1153:
1154: fnd_file.put_line( which => fnd_file.log
1155: , buff => fnd_message.get);

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

1151: fnd_message.set_token( token => 'LOCATION'
1152: , value => l_loc);
1153:
1154: fnd_file.put_line( which => fnd_file.log
1155: , buff => fnd_message.get);
1156:
1157: fnd_file.put_line( which => fnd_file.log
1158: , buff => l_sqlcode || ' ' || l_sqlerrm );
1159:

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

2046: -- Set return code TO error
2047: x_retcode := '2' ;
2048:
2049: -- Log the location within the procedure where the error occurred
2050: fnd_message.set_name( application => 'OKI'
2051: , name => 'OKI_LOC_IN_PROG_FAILURE');
2052:
2053: fnd_message.set_token( token => 'LOCATION'
2054: , value => l_loc);

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

2049: -- Log the location within the procedure where the error occurred
2050: fnd_message.set_name( application => 'OKI'
2051: , name => 'OKI_LOC_IN_PROG_FAILURE');
2052:
2053: fnd_message.set_token( token => 'LOCATION'
2054: , value => l_loc);
2055:
2056: fnd_file.put_line( which => fnd_file.log
2057: , buff => fnd_message.get);

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

2053: fnd_message.set_token( token => 'LOCATION'
2054: , value => l_loc);
2055:
2056: fnd_file.put_line( which => fnd_file.log
2057: , buff => fnd_message.get);
2058:
2059: fnd_file.put_line( which => fnd_file.log
2060: , buff => l_sqlcode || ' ' || l_sqlerrm );
2061:

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

2066:
2067: -- Set return code TO error
2068: x_retcode := '2' ;
2069:
2070: fnd_message.set_name( application => 'OKI'
2071: , name => 'OKI_UNEXPECTED_FAILURE');
2072:
2073: fnd_message.set_token( token => 'OBJECT_NAME'
2074: , value => 'OKI_LOAD_ETR_PVT.CALC_ETR_SUM');

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

2069:
2070: fnd_message.set_name( application => 'OKI'
2071: , name => 'OKI_UNEXPECTED_FAILURE');
2072:
2073: fnd_message.set_token( token => 'OBJECT_NAME'
2074: , value => 'OKI_LOAD_ETR_PVT.CALC_ETR_SUM');
2075:
2076: fnd_file.put_line( which => fnd_file.log
2077: , buff => fnd_message.get);

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

2073: fnd_message.set_token( token => 'OBJECT_NAME'
2074: , value => 'OKI_LOAD_ETR_PVT.CALC_ETR_SUM');
2075:
2076: fnd_file.put_line( which => fnd_file.log
2077: , buff => fnd_message.get);
2078:
2079: -- Log the location within the procedure where the error occurred
2080: fnd_message.set_name( application => 'OKI'
2081: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

2076: fnd_file.put_line( which => fnd_file.log
2077: , buff => fnd_message.get);
2078:
2079: -- Log the location within the procedure where the error occurred
2080: fnd_message.set_name( application => 'OKI'
2081: , name => 'OKI_LOC_IN_PROG_FAILURE');
2082:
2083: fnd_message.set_token( token => 'LOCATION'
2084: , value => l_loc);

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

2079: -- Log the location within the procedure where the error occurred
2080: fnd_message.set_name( application => 'OKI'
2081: , name => 'OKI_LOC_IN_PROG_FAILURE');
2082:
2083: fnd_message.set_token( token => 'LOCATION'
2084: , value => l_loc);
2085:
2086: fnd_file.put_line( which => fnd_file.log
2087: , buff => fnd_message.get);

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

2083: fnd_message.set_token( token => 'LOCATION'
2084: , value => l_loc);
2085:
2086: fnd_file.put_line( which => fnd_file.log
2087: , buff => fnd_message.get);
2088:
2089: fnd_file.put_line( which => fnd_file.log
2090: , buff => l_sqlcode || ' ' || l_sqlerrm );
2091:

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

2183:
2184:
2185: -- Table loaded successfully. Log message IN concurrent manager
2186: -- log indicating successful load.
2187: fnd_message.set_name( application => 'OKI'
2188: , name => 'OKI_TABLE_LOAD_SUCCESS');
2189:
2190: fnd_message.set_token( token => 'TABLE_NAME'
2191: , value => l_table_name );

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

2186: -- log indicating successful load.
2187: fnd_message.set_name( application => 'OKI'
2188: , name => 'OKI_TABLE_LOAD_SUCCESS');
2189:
2190: fnd_message.set_token( token => 'TABLE_NAME'
2191: , value => l_table_name );
2192:
2193: fnd_file.put_line( which => fnd_file.log
2194: , buff => fnd_message.get);

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

2190: fnd_message.set_token( token => 'TABLE_NAME'
2191: , value => l_table_name );
2192:
2193: fnd_file.put_line( which => fnd_file.log
2194: , buff => fnd_message.get);
2195:
2196: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
2197:
2198: IF l_retcode in ('1', '2') THEN

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

2228: -- ROLLBACK all transactions
2229: ROLLBACK TO oki_etr_exp_to_rnwl ;
2230:
2231:
2232: fnd_message.set_name( application => 'OKI'
2233: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
2234:
2235: fnd_message.set_token( token => 'OBJECT_NAME'
2236: , value => 'OKI_LOAD_ETR_PVT.CRT_EXP_TO_RNWL' ) ;

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

2231:
2232: fnd_message.set_name( application => 'OKI'
2233: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
2234:
2235: fnd_message.set_token( token => 'OBJECT_NAME'
2236: , value => 'OKI_LOAD_ETR_PVT.CRT_EXP_TO_RNWL' ) ;
2237:
2238: fnd_file.put_line( which => fnd_file.log
2239: , buff => fnd_message.get ) ;

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

2235: fnd_message.set_token( token => 'OBJECT_NAME'
2236: , value => 'OKI_LOAD_ETR_PVT.CRT_EXP_TO_RNWL' ) ;
2237:
2238: fnd_file.put_line( which => fnd_file.log
2239: , buff => fnd_message.get ) ;
2240:
2241: fnd_file.put_line( which => fnd_file.log
2242: , buff => l_sqlcode||' '||l_sqlerrm ) ;
2243: