DBA Data[Home] [Help]

APPS.OKL_COPY_TEMPLATE_PUB dependencies on OKL_API

Line 21: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 47: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 49: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

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:

Line 63: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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

Line 70: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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

Line 77: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

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: