17:
18: l_aes_id_from NUMBER := p_aes_id_from;
19: l_aes_id_to NUMBER := p_aes_id_to;
20:
21: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
22:
23: BEGIN
24:
25: SAVEPOINT COPY_TEMPLATES;
43: p_aes_id_to => l_aes_id_to);
44:
45:
46:
47: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
50: RAISE FND_API.G_EXC_ERROR;
51: END IF;
45:
46:
47: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
50: RAISE FND_API.G_EXC_ERROR;
51: END IF;
52:
53:
59: WHEN FND_API.G_EXC_ERROR THEN
60: ROLLBACK TO COPY_TEMPLATES;
61: x_return_status := FND_API.G_RET_STS_ERROR;
62:
63: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
64: ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66:
67: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
66:
67: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
68: ROLLBACK TO COPY_TEMPLATES;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
71: ,p_count => x_msg_count
72: ,p_data => x_msg_data);
73:
74: WHEN OTHERS THEN
73:
74: WHEN OTHERS THEN
75:
76: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TEMPLATES');
77: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
78: ,p_count => x_msg_count
79: ,p_data => x_msg_data);
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: