151:
152:
153: -- standard call to get message count and if count is 1, get message info
154: FND_MSG_PUB.count_and_get(
155: p_encoded => FND_API.G_FALSE,
156: p_count => x_msg_count,
157: p_data => x_msg_data
158: );
159:
158: );
159:
160: --standard exception catching for main body
161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
163:
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: FND_MSG_PUB.count_and_get(
166: p_encoded => FND_API.G_FALSE,
160: --standard exception catching for main body
161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
163:
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: FND_MSG_PUB.count_and_get(
166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data
162: WHEN FND_API.G_EXC_ERROR THEN
163:
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: FND_MSG_PUB.count_and_get(
166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170: x_debug_buf := x_debug_buf || 'G_EXC_ERROR exception';
174: x_debug_buf := x_debug_buf || 'error text : '|| SQLERRM;
175:
176: ROLLBACK TO Update_Person_Language;
177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: FND_MSG_PUB.count_and_get(
182: p_encoded => FND_API.G_FALSE,
176: ROLLBACK TO Update_Person_Language;
177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: FND_MSG_PUB.count_and_get(
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: FND_MSG_PUB.count_and_get(
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186:
195: WHEN OTHERS THEN
196:
197:
198:
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: FND_MSG_PUB.count_and_get(
201: p_encoded => FND_API.G_FALSE,
202: p_count => x_msg_count,
203: p_data => x_msg_data
197:
198:
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: FND_MSG_PUB.count_and_get(
201: p_encoded => FND_API.G_FALSE,
202: p_count => x_msg_count,
203: p_data => x_msg_data
204: );
205: x_debug_buf := x_debug_buf || 'OTHER exception';