DBA Data[Home] [Help]

APPS.OKI_LOAD_ETR_PVT dependencies on FND_FILE

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

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 ) ;
147:
148: fnd_file.put_line( which => fnd_file.log
149: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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 ;
151:
152: --------------------------------------------------------------------------------

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

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 );
212:
213: fnd_file.put_line( which => fnd_file.log
214: , buff => l_sqlcode || ' ' || l_sqlerrm ) ;

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

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 ;
216:
217: --------------------------------------------------------------------------------

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

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);
1127:
1128: fnd_file.put_line( which => fnd_file.log
1129: , buff => l_sqlcode || ' ' || l_sqlerrm );

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

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
1131:
1132: l_sqlcode := SQLCODE ;

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

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

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

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);
1156:
1157: fnd_file.put_line( which => fnd_file.log
1158: , buff => l_sqlcode || ' ' || l_sqlerrm );

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

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:
1160: END calc_etr_dtl1 ;
1161:

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

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);
2058:
2059: fnd_file.put_line( which => fnd_file.log
2060: , buff => l_sqlcode || ' ' || l_sqlerrm );

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

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:
2062: WHEN OTHERS THEN
2063:

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

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

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

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);
2088:
2089: fnd_file.put_line( which => fnd_file.log
2090: , buff => l_sqlcode || ' ' || l_sqlerrm );

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

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:
2092: END calc_etr_sum ;
2093: --------------------------------------------------------------------------------

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

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);
2195:
2196: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
2197:

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

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 ) ;
2240:
2241: fnd_file.put_line( which => fnd_file.log
2242: , buff => l_sqlcode||' '||l_sqlerrm ) ;

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

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:
2244: END crt_exp_to_rnwl ;
2245: