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:
391:
392: END LOOP;
393:
394: IF ctr = 0 THEN
395: fnd_file.put_line(FND_FILE.OUTPUT,'******* NO DATA FOUND ******');
396: retcode := 2;
397: ELSE
398: COMMIT;
399: END IF;
397: ELSE
398: COMMIT;
399: END IF;
400:
401: fnd_file.put_line(FND_FILE.OUTPUT,'Concurrent Request Processed Successfully...');
402: retcode := 0;
403:
404: EXCEPTION
405:
404: EXCEPTION
405:
406: WHEN OTHERS THEN
407: retcode := 2;
408: fnd_file.put_line(FND_FILE.LOG,'Error occurred during extract process...');
409: ROLLBACK;
410:
411: END JE_AR_TURNOVER_EXTRACT;
412:
507: p_last_update_login);
508: EXCEPTION
509:
510: WHEN OTHERS THEN
511: fnd_file.put_line(FND_FILE.log,'While Inserting the Record into Interface Table');
512: retcode := 2;
513:
514: END GENERIC_INSERT_TO_ITF;
515: