[Home] [Help]
250: ,p_purge_successful_lines => p_purge_rows
251: );
252:
253: IF ( RETCODE = FND_API.G_RET_STS_SUCCESS ) THEN
254: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('SUCCESS', 'Success: All the rows processed successfully.');
255: ELSIF ( RETCODE = G_RETCODE_SUCCESS_WITH_WARNING ) THEN
256: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details.');
257: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks.');
258: ELSIF ( RETCODE = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
253: IF ( RETCODE = FND_API.G_RET_STS_SUCCESS ) THEN
254: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('SUCCESS', 'Success: All the rows processed successfully.');
255: ELSIF ( RETCODE = G_RETCODE_SUCCESS_WITH_WARNING ) THEN
256: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details.');
257: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks.');
258: ELSIF ( RETCODE = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
259: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Error: Unexpected Error happened while processing the Interface rows in this Batch.');
260:
261: END IF;
255: ELSIF ( RETCODE = G_RETCODE_SUCCESS_WITH_WARNING ) THEN
256: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details.');
257: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks.');
258: ELSIF ( RETCODE = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
259: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Error: Unexpected Error happened while processing the Interface rows in this Batch.');
260:
261: END IF;
262:
263: end if;
551: and process_status = G_PS_IN_PROCESS
552: and transaction_type = G_TX_TYPE_CREATE;
553:
554: FND_FILE.put_line(FND_FILE.LOG, 'User does not have Create Site Privilege for creating sites. Please contact your Site/System Administrator' );
555: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks. ');
556:
557: END IF;
558:
559: end if;
2134: );
2135:
2136: If ( sql%rowcount ) > 0 then
2137: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details. ');
2138: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks. ');
2139: end if;
2140:
2141:
2142: end;
2266: ) ;
2267: Exception
2268: When Others Then
2269: Rollback;
2270: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Error: Unexpected Error occured during processing of Sites data. ');
2271:
2272: End;
2273:
2274: If ( sql%rowcount ) > 0 then
2315:
2316: Exception
2317: When Others Then
2318: Rollback;
2319: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Error: Unexpected Error occured during processing of Sites data. ');
2320:
2321: end;
2322:
2323: /*
2322:
2323: /*
2324: If ( sql%rowcount ) > 0 then
2325: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details. ');
2326: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks. ');
2327: end if;
2328: */
2329:
2330:
2367:
2368: Exception
2369: When Others Then
2370: Rollback;
2371: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Error: Unexpected Error occured during processing of Sites data. ');
2372:
2373: end;
2374:
2375: