86: EXCEPTION
87: WHEN FND_API.G_EXC_ERROR THEN
88: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: FND_MSG_PUB.count_and_get(
91: p_encoded => FND_API.G_FALSE,
92: p_count => x_msg_count,
93: p_data => x_msg_data);
94:
94:
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.count_and_get(
99: p_encoded => FND_API.G_FALSE,
100: p_count => x_msg_count,
101: p_data => x_msg_data);
102:
102:
103: WHEN OTHERS THEN
104: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
107: FND_MSG_PUB.add_exc_msg(
108: p_pkg_name => G_PKG_NAME,
109: p_procedure_name => l_api_name,
110: p_error_text => SUBSTRB(SQLERRM,1,240));
103: WHEN OTHERS THEN
104: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
107: FND_MSG_PUB.add_exc_msg(
108: p_pkg_name => G_PKG_NAME,
109: p_procedure_name => l_api_name,
110: p_error_text => SUBSTRB(SQLERRM,1,240));
111: END IF;
108: p_pkg_name => G_PKG_NAME,
109: p_procedure_name => l_api_name,
110: p_error_text => SUBSTRB(SQLERRM,1,240));
111: END IF;
112: FND_MSG_PUB.count_and_get(
113: p_encoded => FND_API.G_FALSE,
114: p_count => x_msg_count,
115: p_data => x_msg_data);
116:
250: EXCEPTION
251: WHEN FND_API.G_EXC_ERROR THEN
252: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MSG_PUB.count_and_get(
255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data);
258:
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.count_and_get(
263: p_encoded => FND_API.G_FALSE,
264: p_count => x_msg_count,
265: p_data => x_msg_data);
266:
266:
267: WHEN OTHERS THEN
268: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
271: FND_MSG_PUB.add_exc_msg(
272: p_pkg_name => G_PKG_NAME,
273: p_procedure_name => l_api_name,
274: p_error_text => SUBSTRB(SQLERRM,1,240));
267: WHEN OTHERS THEN
268: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
271: FND_MSG_PUB.add_exc_msg(
272: p_pkg_name => G_PKG_NAME,
273: p_procedure_name => l_api_name,
274: p_error_text => SUBSTRB(SQLERRM,1,240));
275: END IF;
272: p_pkg_name => G_PKG_NAME,
273: p_procedure_name => l_api_name,
274: p_error_text => SUBSTRB(SQLERRM,1,240));
275: END IF;
276: FND_MSG_PUB.count_and_get(
277: p_encoded => FND_API.G_FALSE,
278: p_count => x_msg_count,
279: p_data => x_msg_data);
280: