88: ROLLBACK TO trx_adv_contract_search;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: x_msg_count := l_msg_count ;
91: x_msg_data := l_msg_data ;
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96:
101: ROLLBACK TO trx_adv_contract_search;
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
103: x_msg_count := l_msg_count ;
104: x_msg_data := l_msg_data ;
105: FND_MSG_PUB.count_and_get(
106: p_count => x_msg_count
107: ,p_data => x_msg_data);
108: WHEN OTHERS THEN
109: IF (is_debug_exception_on) THEN
113: ROLLBACK TO trx_adv_contract_search;
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: x_msg_count := l_msg_count ;
116: x_msg_data := l_msg_data ;
117: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CREATE_QUOTE_PUB','advance_contract_search');
118: FND_MSG_PUB.count_and_get(
119: p_count => x_msg_count
120: ,p_data => x_msg_data);
121:
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: x_msg_count := l_msg_count ;
116: x_msg_data := l_msg_data ;
117: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CREATE_QUOTE_PUB','advance_contract_search');
118: FND_MSG_PUB.count_and_get(
119: p_count => x_msg_count
120: ,p_data => x_msg_data);
121:
122: END advance_contract_search;
228: ROLLBACK TO trx_create_terminate_quote;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: x_msg_count := l_msg_count ;
231: x_msg_data := l_msg_data ;
232: FND_MSG_PUB.count_and_get(
233: p_count => x_msg_count
234: ,p_data => x_msg_data);
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: IF (is_debug_exception_on) THEN
239: ROLLBACK TO trx_create_terminate_quote;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: x_msg_count := l_msg_count ;
242: x_msg_data := l_msg_data ;
243: FND_MSG_PUB.count_and_get(
244: p_count => x_msg_count
245: ,p_data => x_msg_data);
246: WHEN OTHERS THEN
247: IF (is_debug_exception_on) THEN
251: ROLLBACK TO trx_create_terminate_quote;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: x_msg_count := l_msg_count ;
254: x_msg_data := l_msg_data ;
255: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CREATE_QUOTE_PUB','create_terminate_quote');
256: FND_MSG_PUB.count_and_get(
257: p_count => x_msg_count
258: ,p_data => x_msg_data);
259:
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: x_msg_count := l_msg_count ;
254: x_msg_data := l_msg_data ;
255: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CREATE_QUOTE_PUB','create_terminate_quote');
256: FND_MSG_PUB.count_and_get(
257: p_count => x_msg_count
258: ,p_data => x_msg_data);
259:
260: END create_terminate_quote;