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