[Home] [Help]
559:
560: l_stmt_num := 40;
561:
562: -- Initialize API return status to success
563: -- l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', l_error_message);
564:
565: l_stmt_num := 50;
566: -- API starts
567: l_error_code := 9999;
1103: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1104: 'End Worker for Asset Import. Time now is ' ||
1105: to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
1106: end if;
1107: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', l_error_message);
1108:
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: l_error_message := 'UNEXPECTED ERROR IN OUTER BLOCK: ' || SQLERRM;
1108:
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: l_error_message := 'UNEXPECTED ERROR IN OUTER BLOCK: ' || SQLERRM;
1112: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_error_message);
1113:
1114: if (l_exlog) then
1115: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,l_error_message);
1116: end if;