23: BEGIN
24:
25: SAVEPOINT COPY_TEMPLATES;
26:
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: -- customer pre-processing
30:
31:
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;
52:
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:
54:
55:
56:
57: EXCEPTION
58:
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
57: EXCEPTION
58:
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);
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
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
65: ,p_data => x_msg_data);
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:
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:
82:
83:
84: END COPY_TEMPLATES;