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;
230: ROLLBACK TO trx_create_terminate_quote;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: x_msg_count := l_msg_count ;
233: x_msg_data := l_msg_data ;
234: FND_MSG_PUB.count_and_get(
235: p_count => x_msg_count
236: ,p_data => x_msg_data);
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: IF (is_debug_exception_on) THEN
241: ROLLBACK TO trx_create_terminate_quote;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243: x_msg_count := l_msg_count ;
244: x_msg_data := l_msg_data ;
245: FND_MSG_PUB.count_and_get(
246: p_count => x_msg_count
247: ,p_data => x_msg_data);
248: WHEN OTHERS THEN
249: IF (is_debug_exception_on) THEN
253: ROLLBACK TO trx_create_terminate_quote;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: x_msg_count := l_msg_count ;
256: x_msg_data := l_msg_data ;
257: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CREATE_QUOTE_PUB','create_terminate_quote');
258: FND_MSG_PUB.count_and_get(
259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261:
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: x_msg_count := l_msg_count ;
256: x_msg_data := l_msg_data ;
257: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CREATE_QUOTE_PUB','create_terminate_quote');
258: FND_MSG_PUB.count_and_get(
259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261:
262: END create_terminate_quote;