21:
22:
23: SAVEPOINT INT_RATE_IMPORT;
24:
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26:
27: -- customer pre-processing
28:
29:
39: x_msg_data => x_msg_data);
40:
41:
42: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
45: RAISE FND_API.G_EXC_ERROR;
46: END IF;
47:
41:
42: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
45: RAISE FND_API.G_EXC_ERROR;
46: END IF;
47:
48:
49:
50:
51:
52: EXCEPTION
53:
54: WHEN FND_API.G_EXC_ERROR THEN
55: ROLLBACK TO INT_RATE_IMPORT;
56: x_return_status := FND_API.G_RET_STS_ERROR;
57:
58: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
52: EXCEPTION
53:
54: WHEN FND_API.G_EXC_ERROR THEN
55: ROLLBACK TO INT_RATE_IMPORT;
56: x_return_status := FND_API.G_RET_STS_ERROR;
57:
58: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
59: ,p_count => x_msg_count
60: ,p_data => x_msg_data);
58: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
59: ,p_count => x_msg_count
60: ,p_data => x_msg_data);
61:
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
63: ROLLBACK TO INT_RATE_IMPORT;
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
66: ,p_count => x_msg_count
60: ,p_data => x_msg_data);
61:
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
63: ROLLBACK TO INT_RATE_IMPORT;
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
66: ,p_count => x_msg_count
67: ,p_data => x_msg_data);
68:
71: FND_MSG_PUB.ADD_EXC_MSG('OKL_INTEREST_IMP_PUB','INT_RATE_IMPORT');
72: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
73: ,p_count => x_msg_count
74: ,p_data => x_msg_data);
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76:
77:
78:
79: END INT_RATE_IMPORT;