[Home] [Help]
2309: fnd_file.put_line(fnd_file.log, 'Period not found ');
2310: fnd_file.put_line
2311: (fnd_file.log,'Can not Continue. Returning without migrating data' );
2312:
2313: l_ret_status := fnd_concurrent.set_completion_status('ERROR','Error Period Not Found.');
2314: RETURN;
2315: END IF;
2316:
2317: /* write period validation logic here. If period passed in is already accounted then do nothing
2354: (fnd_file.log,'Cost type Or Default Lot cost type is Actual Costing and '||l_posted_cnt||' Transactions are already posted.' );
2355: fnd_file.put_line
2356: (fnd_file.log,'Can not Continue. Returning without migrating data' );
2357:
2358: l_ret_status := fnd_concurrent.set_completion_status('ERROR','Errors found during processing.'||
2359: ' Please check the log file for details.');
2360:
2361: RETURN;
2362:
2642:
2643: fnd_file.put_line
2644: (fnd_file.log,'Layer Migration finished at '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2645:
2646: l_ret_status := fnd_concurrent.set_completion_status('NORMAL','Process completed successfully.');
2647:
2648:
2649: EXCEPTION
2650: WHEN OTHERS THEN
2652: fnd_file.put_line(fnd_file.log, ' Error Running script for Batch_id '|| rec.batch_id);
2653: fnd_file.put_line(fnd_file.log, ' Please check table gme_temp_exceptions for details' );
2654: fnd_file.put_line(fnd_file.log, ' *****************************************************' );
2655: fnd_file.put_line(fnd_file.log,'ERROR: '||substr(sqlerrm,1,100) || ' While Remigrating layer data.');
2656: l_ret_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm || ' While Remigrating layer data.' );
2657:
2658: ROLLBACK;
2659:
2660: