57: -- notify caller of an UNEXPECTED error
58: x_return_status := FND_API.G_RET_STS_ERROR;
59:
60: -- store SQL error message on message stack for caller
61: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
62: p_count => x_msg_count,
63: p_data => x_msg_data);
64:
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
66: -- notify caller of an UNEXPECTED error
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
68:
69: -- store SQL error message on message stack for caller
70: FND_MSG_PUB.Count_and_get(p_encoded => OKC_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: -- notify caller of an UNEXPECTED error
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: FND_MSG_PUB.ADD_EXC_MSG('OKL_VENDOR_PROGRAM_PUB','create_program');
78:
79: -- store SQL error message on message stack for caller
80: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
81: p_count => x_msg_count,
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: FND_MSG_PUB.ADD_EXC_MSG('OKL_VENDOR_PROGRAM_PUB','create_program');
78:
79: -- store SQL error message on message stack for caller
80: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
81: p_count => x_msg_count,
82: p_data => x_msg_data);
83: END create_program;
84:
133: -- notify caller of an UNEXPECTED error
134: x_return_status := FND_API.G_RET_STS_ERROR;
135:
136: -- store SQL error message on message stack for caller
137: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
138: p_count => x_msg_count,
139: p_data => x_msg_data);
140:
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142: -- notify caller of an UNEXPECTED error
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144:
145: -- store SQL error message on message stack for caller
146: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
147: p_count => x_msg_count,
148: p_data => x_msg_data);
149:
150: WHEN OTHERS THEN
149:
150: WHEN OTHERS THEN
151: -- notify caller of an UNEXPECTED error
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.ADD_EXC_MSG('OKL_VENDOR_PROGRAM_PUB','update_program');
154:
155: -- store SQL error message on message stack for caller
156: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
157: p_count => x_msg_count,
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.ADD_EXC_MSG('OKL_VENDOR_PROGRAM_PUB','update_program');
154:
155: -- store SQL error message on message stack for caller
156: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
157: p_count => x_msg_count,
158: p_data => x_msg_data);
159: END update_program;
160: