71: gmd_debug.put_line(' p_seq_id : ' || p_seq_id);
72: END IF;
73:
74: -- Initialize API return status to success
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: -- First clear the TEMP table.
78: DELETE FROM gmd_mass_results_gt;
79:
536:
537: -- All systems GO...
538:
539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: x_return_status := FND_API.G_RET_STS_ERROR ;
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544: WHEN OTHERS THEN
537: -- All systems GO...
538:
539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: x_return_status := FND_API.G_RET_STS_ERROR ;
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544: WHEN OTHERS THEN
545: GMD_API_PUB.Log_Message('GMD_API_ERROR',
538:
539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: x_return_status := FND_API.G_RET_STS_ERROR ;
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544: WHEN OTHERS THEN
545: GMD_API_PUB.Log_Message('GMD_API_ERROR',
546: 'PACKAGE','POPULATE_RESULTS',
539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: x_return_status := FND_API.G_RET_STS_ERROR ;
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544: WHEN OTHERS THEN
545: GMD_API_PUB.Log_Message('GMD_API_ERROR',
546: 'PACKAGE','POPULATE_RESULTS',
547: 'ERROR', SUBSTR(SQLERRM,1,100));
544: WHEN OTHERS THEN
545: GMD_API_PUB.Log_Message('GMD_API_ERROR',
546: 'PACKAGE','POPULATE_RESULTS',
547: 'ERROR', SUBSTR(SQLERRM,1,100));
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
549:
550: END populate_results;
551:
552: