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.OKS_AVG_SET_PUB dependencies on FND_FILE

Line 126: FND_FILE.PUT_LINE(FND_FILE.LOG,'cle_id '||p_cle_id);

122: OPEN get_curr_csr (p_hdr_id);
123: FETCH get_curr_csr into l_curr_code;
124: CLOSE get_curr_csr;
125:
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'cle_id '||p_cle_id);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,' avg '||p_avg_interval);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Dt to be averaged from '||l_date_to_average);
129:
130: /*While loop is to process multiple slots. It will take care

Line 127: FND_FILE.PUT_LINE(FND_FILE.LOG,' avg '||p_avg_interval);

123: FETCH get_curr_csr into l_curr_code;
124: CLOSE get_curr_csr;
125:
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'cle_id '||p_cle_id);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,' avg '||p_avg_interval);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Dt to be averaged from '||l_date_to_average);
129:
130: /*While loop is to process multiple slots. It will take care
131: of past periods where averaging was not run

Line 128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Dt to be averaged from '||l_date_to_average);

124: CLOSE get_curr_csr;
125:
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'cle_id '||p_cle_id);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,' avg '||p_avg_interval);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Dt to be averaged from '||l_date_to_average);
129:
130: /*While loop is to process multiple slots. It will take care
131: of past periods where averaging was not run
132: */

Line 166: FND_FILE.PUT_LINE(FND_FILE.LOG,'pricing engine amt '||l_price_rec.PROD_EXT_AMOUNT);

162: X_MSG_COUNT => l_msg_count,
163: X_MSG_DATA => l_msg_data
164: );
165:
166: FND_FILE.PUT_LINE(FND_FILE.LOG,'pricing engine amt '||l_price_rec.PROD_EXT_AMOUNT);
167:
168: l_avg_amount := l_price_rec.PROD_EXT_AMOUNT * p_avg_interval;
169:
170: FND_FILE.PUT_LINE(FND_FILE.LOG,'averaged amt '||l_avg_amount);

Line 170: FND_FILE.PUT_LINE(FND_FILE.LOG,'averaged amt '||l_avg_amount);

166: FND_FILE.PUT_LINE(FND_FILE.LOG,'pricing engine amt '||l_price_rec.PROD_EXT_AMOUNT);
167:
168: l_avg_amount := l_price_rec.PROD_EXT_AMOUNT * p_avg_interval;
169:
170: FND_FILE.PUT_LINE(FND_FILE.LOG,'averaged amt '||l_avg_amount);
171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Amount billed '||sub_line_rec.amt_billed);
172:
173:
174: IF NVL(l_avg_amount,0) < sub_line_rec.amt_billed Then

Line 171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Amount billed '||sub_line_rec.amt_billed);

167:
168: l_avg_amount := l_price_rec.PROD_EXT_AMOUNT * p_avg_interval;
169:
170: FND_FILE.PUT_LINE(FND_FILE.LOG,'averaged amt '||l_avg_amount);
171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Amount billed '||sub_line_rec.amt_billed);
172:
173:
174: IF NVL(l_avg_amount,0) < sub_line_rec.amt_billed Then
175: l_avg_amount := sub_line_rec.amt_billed - l_avg_amount;

Line 208: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl');

204: P_MSG_DATA => l_msg_data,
205: X_BCL_ID => l_bcl_id);
206:
207: IF (l_return_status <> 'S') THEN
208: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl');
209: ROLLBACK;
210: End if;
211:
212: FND_FILE.PUT_LINE( FND_FILE.LOG, 'bcl '||l_bcl_id);

Line 212: FND_FILE.PUT_LINE( FND_FILE.LOG, 'bcl '||l_bcl_id);

208: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl');
209: ROLLBACK;
210: End if;
211:
212: FND_FILE.PUT_LINE( FND_FILE.LOG, 'bcl '||l_bcl_id);
213:
214: l_cov_tbl(1).bcl_id := l_bcl_id;
215:
216: OKS_BILL_REC_PUB.Insert_all_subline

Line 229: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bsl');

225: P_MSG_DATA => l_msg_data
226: );
227:
228: IF (l_return_status <> 'S') THEN
229: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bsl');
230: ROLLBACK;
231: End if;
232:
233: End if;

Line 261: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Failed in AR FEEDER :'||p_cle_id);

257: p_billrep_err_tbl_idx => l_billrep_errtbl_idx
258: ) ;
259:
260: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
261: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Failed in AR FEEDER :'||p_cle_id);
262: ROLLBACK;
263: End if;
264: End if;
265:

Line 268: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Failed in AR FEEDER :'||p_cle_id);

264: End if;
265:
266: Exception
267: WHEN OTHERS THEN
268: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Failed in AR FEEDER :'||p_cle_id);
269: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Error is :'||sqlerrm);
270: ROLLBACK;
271:
272: END average_api;

Line 269: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Error is :'||sqlerrm);

265:
266: Exception
267: WHEN OTHERS THEN
268: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Failed in AR FEEDER :'||p_cle_id);
269: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Error is :'||sqlerrm);
270: ROLLBACK;
271:
272: END average_api;
273:

Line 302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User_Id ='||to_char(l_user_id));

298:
299: BEGIN
300:
301: l_user_id := FND_GLOBAL.USER_ID;
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User_Id ='||to_char(l_user_id));
303:
304: FOR line_Rec in line_cur(p_contract_id)
305: LOOP
306: IF (line_rec.averaging_interval IS NOT NULL) THEN

Line 315: FND_FILE.PUT_LINE( FND_FILE.LOG,

311: p_avg_interval => line_rec.averaging_interval ,
312: X_return_status => l_return_status
313: );
314: IF (l_return_status <> 'S') THEN
315: FND_FILE.PUT_LINE( FND_FILE.LOG,
316: 'Error in processing averaging for line = '||line_rec.cle_id );
317: END IF;
318:
319: END IF;

Line 327: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Failed in AR FEEDER :'||p_contract_id);

323:
324:
325: EXCEPTION
326: WHEN OTHERS THEN
327: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Failed in AR FEEDER :'||p_contract_id);
328: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Error is :'||sqlerrm);
329: ROLLBACK;
330:
331: END Average_Main;

Line 328: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Error is :'||sqlerrm);

324:
325: EXCEPTION
326: WHEN OTHERS THEN
327: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Failed in AR FEEDER :'||p_contract_id);
328: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Average => Error is :'||sqlerrm);
329: ROLLBACK;
330:
331: END Average_Main;
332: