85: -- notify caller of an UNEXPECTED error
86: x_return_status := FND_API.G_RET_STS_ERROR;
87:
88: -- store SQL error message on message stack for caller
89: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
90: p_count => x_msg_count,
91: p_data => x_msg_data);
92:
93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95: -- notify caller of an UNEXPECTED error
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97:
98: -- store SQL error message on message stack for caller
99: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
100: p_count => x_msg_count,
101: p_data => x_msg_data);
102:
103: WHEN OTHERS THEN
102:
103: WHEN OTHERS THEN
104: -- notify caller of an UNEXPECTED error
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPDTTEMPLATES_PUB','insert_pdttemplates');
107:
108: -- store SQL error message on message stack for caller
109: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
110: p_count => x_msg_count,
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPDTTEMPLATES_PUB','insert_pdttemplates');
107:
108: -- store SQL error message on message stack for caller
109: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
110: p_count => x_msg_count,
111: p_data => x_msg_data);
112: END insert_pdttemplates;
113:
160: -- notify caller of an UNEXPECTED error
161: x_return_status := FND_API.G_RET_STS_ERROR;
162:
163: -- store SQL error message on message stack for caller
164: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
165: p_count => x_msg_count,
166: p_data => x_msg_data);
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: -- notify caller of an UNEXPECTED error
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172:
173: -- store SQL error message on message stack for caller
174: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
175: p_count => x_msg_count,
176: p_data => x_msg_data);
177:
178: WHEN OTHERS THEN
177:
178: WHEN OTHERS THEN
179: -- notify caller of an UNEXPECTED error
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPDTTEMPLATES_PUB','update_pdttemplates');
182:
183: -- store SQL error message on message stack for caller
184: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
185: p_count => x_msg_count,
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPDTTEMPLATES_PUB','update_pdttemplates');
182:
183: -- store SQL error message on message stack for caller
184: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
185: p_count => x_msg_count,
186: p_data => x_msg_data);
187: END update_pdttemplates;
188: