178: rec.last_update_login);
179: END LOOP;
180:
181: IF ctr = 0 THEN
182: fnd_file.put_line(FND_FILE.OUTPUT,'******* NO DATA FOUND ******');
183: ELSE
184: COMMIT;
185: END IF;
186:
183: ELSE
184: COMMIT;
185: END IF;
186:
187: fnd_file.put_line(FND_FILE.OUTPUT,'Concurrent Request Processed Successfully...');
188: retcode := 0;
189:
190: EXCEPTION
191: WHEN OTHERS THEN
189:
190: EXCEPTION
191: WHEN OTHERS THEN
192: retcode := 2;
193: fnd_file.put_line(FND_FILE.LOG,'Error occurred during extract process...');
194: ROLLBACK;
195:
196: END JE_AP_TURNOVER_EXTRACT;
197:
388:
389: END LOOP;
390:
391: IF ctr = 0 THEN
392: fnd_file.put_line(FND_FILE.OUTPUT,'******* NO DATA FOUND ******');
393: retcode := 2;
394: ELSE
395: COMMIT;
396: END IF;
394: ELSE
395: COMMIT;
396: END IF;
397:
398: fnd_file.put_line(FND_FILE.OUTPUT,'Concurrent Request Processed Successfully...');
399: retcode := 0;
400:
401: EXCEPTION
402:
401: EXCEPTION
402:
403: WHEN OTHERS THEN
404: retcode := 2;
405: fnd_file.put_line(FND_FILE.LOG,'Error occurred during extract process...');
406: ROLLBACK;
407:
408: END JE_AR_TURNOVER_EXTRACT;
409:
504: p_last_update_login);
505: EXCEPTION
506:
507: WHEN OTHERS THEN
508: fnd_file.put_line(FND_FILE.log,'While Inserting the Record into Interface Table');
509: retcode := 2;
510:
511: END GENERIC_INSERT_TO_ITF;
512: