12:
13: l_api_version NUMBER := 1.0;
14:
15: l_api_name CONSTANT VARCHAR2(30) := 'INT_RATE_IMPORT';
16: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
17:
18:
19:
20: BEGIN
38: x_msg_count => x_msg_count,
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;
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:
48:
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);
61:
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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:
69: WHEN OTHERS THEN
68:
69: WHEN OTHERS THEN
70:
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: