250: ,x_msg_count => l_msg_count
251: ,x_msg_data => l_msg_data
252: );
253:
254: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
255: FND_FILE.PUT_LINE (FND_FILE.LOG, 'OKL Create AR Adjustment Process Program');
256: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
257: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||sysdate);
258: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
251: ,x_msg_data => l_msg_data
252: );
253:
254: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
255: FND_FILE.PUT_LINE (FND_FILE.LOG, 'OKL Create AR Adjustment Process Program');
256: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
257: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||sysdate);
258: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
259: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
252: );
253:
254: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
255: FND_FILE.PUT_LINE (FND_FILE.LOG, 'OKL Create AR Adjustment Process Program');
256: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
257: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||sysdate);
258: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
259: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
260: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Message For Each Processed Line ...');
253:
254: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
255: FND_FILE.PUT_LINE (FND_FILE.LOG, 'OKL Create AR Adjustment Process Program');
256: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
257: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||sysdate);
258: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
259: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
260: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Message For Each Processed Line ...');
261: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
254: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
255: FND_FILE.PUT_LINE (FND_FILE.LOG, 'OKL Create AR Adjustment Process Program');
256: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
257: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||sysdate);
258: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
259: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
260: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Message For Each Processed Line ...');
261: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
262:
255: FND_FILE.PUT_LINE (FND_FILE.LOG, 'OKL Create AR Adjustment Process Program');
256: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
257: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||sysdate);
258: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
259: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
260: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Message For Each Processed Line ...');
261: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
262:
263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
256: FND_FILE.PUT_LINE (FND_FILE.LOG, '*****************************************');
257: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||sysdate);
258: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
259: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
260: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Message For Each Processed Line ...');
261: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
262:
263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
264: );
257: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||sysdate);
258: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
259: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
260: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Message For Each Processed Line ...');
261: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
262:
263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
264: );
265: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Create AR Adjustment Process Program')
259: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
260: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Message For Each Processed Line ...');
261: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
262:
263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
264: );
265: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Create AR Adjustment Process Program')
266: ;
267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
261: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
262:
263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
264: );
265: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Create AR Adjustment Process Program')
266: ;
267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
268: );
269: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
264: );
265: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Create AR Adjustment Process Program')
266: ;
267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
268: );
269: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
270: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '******************************************
271: *****');
265: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Create AR Adjustment Process Program')
266: ;
267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
268: );
269: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
270: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '******************************************
271: *****');
272: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '******************************************
273: *****');
266: ;
267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*****************************************'
268: );
269: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
270: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '******************************************
271: *****');
272: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '******************************************
273: *****');
274: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Message For Each Processed
268: );
269: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
270: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '******************************************
271: *****');
272: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '******************************************
273: *****');
274: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Message For Each Processed
275: Line ...');
276: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------
270: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '******************************************
271: *****');
272: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '******************************************
273: *****');
274: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Message For Each Processed
275: Line ...');
276: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------
277: ----------------------------------');
278:
272: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '******************************************
273: *****');
274: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Detailed Error Message For Each Processed
275: Line ...');
276: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------------------
277: ----------------------------------');
278:
279: BEGIN
280:
281: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
282: IF (l_error_msg_rec.COUNT > 0) THEN
283: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
284: LOOP
285: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
286: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
287:
288: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));
289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------
282: IF (l_error_msg_rec.COUNT > 0) THEN
283: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
284: LOOP
285: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
286: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
287:
288: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));
289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------
290: ----------------------------------------------');
284: LOOP
285: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
286: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
287:
288: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));
289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------
290: ----------------------------------------------');
291: END LOOP;
292: END IF;
285: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
286: FND_FILE.PUT_LINE (FND_FILE.LOG, '----------------------------------------------------------------------------');
287:
288: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));
289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '------------------------------
290: ----------------------------------------------');
291: END LOOP;
292: END IF;
293: /*
296: p_encoded => 'F',
297: p_data => lx_msg_data,
298: p_msg_index_out => l_msg_index_out);
299:
300: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,to_char(i) || ': ' || lx_msg_data);
301: END LOOP;
302: */
303: EXCEPTION
304: WHEN OTHERS THEN
301: END LOOP;
302: */
303: EXCEPTION
304: WHEN OTHERS THEN
305: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
306:
307: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
308: END;
309:
303: EXCEPTION
304: WHEN OTHERS THEN
305: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
306:
307: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
308: END;
309:
310:
311: EXCEPTION