51: x_return_status => l_return_status,
52: p_qtev_tbl => lp_qtev_tbl,
53: x_cons_rec => lx_cons_rec);
54:
55: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
56: RAISE FND_API.G_EXC_ERROR;
57: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
52: p_qtev_tbl => lp_qtev_tbl,
53: x_cons_rec => lx_cons_rec);
54:
55: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
56: RAISE FND_API.G_EXC_ERROR;
57: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
53: x_cons_rec => lx_cons_rec);
54:
55: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
56: RAISE FND_API.G_EXC_ERROR;
57: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61:
54:
55: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
56: RAISE FND_API.G_EXC_ERROR;
57: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61:
62:
67: x_cons_rec := lx_cons_rec;
68:
69: EXCEPTION
70:
71: WHEN FND_API.G_EXC_ERROR THEN
72: ROLLBACK TO trx_create_consolidate_quote;
73: x_return_status := FND_API.G_RET_STS_ERROR;
74: x_msg_count := l_msg_count ;
75: x_msg_data := l_msg_data ;
69: EXCEPTION
70:
71: WHEN FND_API.G_EXC_ERROR THEN
72: ROLLBACK TO trx_create_consolidate_quote;
73: x_return_status := FND_API.G_RET_STS_ERROR;
74: x_msg_count := l_msg_count ;
75: x_msg_data := l_msg_data ;
76: FND_MSG_PUB.count_and_get(
77: p_count => x_msg_count,
76: FND_MSG_PUB.count_and_get(
77: p_count => x_msg_count,
78: p_data => x_msg_data);
79:
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
81: ROLLBACK TO trx_create_consolidate_quote;
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
83: x_msg_count := l_msg_count ;
84: x_msg_data := l_msg_data ;
78: p_data => x_msg_data);
79:
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
81: ROLLBACK TO trx_create_consolidate_quote;
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
83: x_msg_count := l_msg_count ;
84: x_msg_data := l_msg_data ;
85: FND_MSG_PUB.count_and_get(
86: p_count => x_msg_count,
87: p_data => x_msg_data);
88:
89: WHEN OTHERS THEN
90: ROLLBACK TO trx_create_consolidate_quote;
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_msg_count := l_msg_count ;
93: x_msg_data := l_msg_data ;
94: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CONSOLIDATED_QTE_PUB','create_consolidate_quote');
95: FND_MSG_PUB.count_and_get(
153: p_cons_rec => lp_cons_rec,
154: x_cons_rec => lx_cons_rec,
155: x_qtev_tbl => lx_qtev_tbl);
156:
157: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
158: RAISE FND_API.G_EXC_ERROR;
159: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: END IF;
154: x_cons_rec => lx_cons_rec,
155: x_qtev_tbl => lx_qtev_tbl);
156:
157: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
158: RAISE FND_API.G_EXC_ERROR;
159: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: END IF;
162:
155: x_qtev_tbl => lx_qtev_tbl);
156:
157: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
158: RAISE FND_API.G_EXC_ERROR;
159: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: END IF;
162:
163: -- Copy out parameter
156:
157: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
158: RAISE FND_API.G_EXC_ERROR;
159: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: END IF;
162:
163: -- Copy out parameter
164: lp_cons_rec := lx_cons_rec;
173: x_qtev_tbl := lx_qtev_tbl;
174:
175: EXCEPTION
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO trx_update_consolidate_quote;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: x_msg_count := l_msg_count ;
181: x_msg_data := l_msg_data ;
175: EXCEPTION
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO trx_update_consolidate_quote;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: x_msg_count := l_msg_count ;
181: x_msg_data := l_msg_data ;
182: FND_MSG_PUB.count_and_get(
183: p_count => x_msg_count,
182: FND_MSG_PUB.count_and_get(
183: p_count => x_msg_count,
184: p_data => x_msg_data);
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO trx_update_consolidate_quote;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: x_msg_count := l_msg_count ;
190: x_msg_data := l_msg_data ;
184: p_data => x_msg_data);
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO trx_update_consolidate_quote;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: x_msg_count := l_msg_count ;
190: x_msg_data := l_msg_data ;
191: FND_MSG_PUB.count_and_get(
192: p_count => x_msg_count,
193: p_data => x_msg_data);
194:
195: WHEN OTHERS THEN
196: ROLLBACK TO trx_update_consolidate_quote;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: x_msg_count := l_msg_count ;
199: x_msg_data := l_msg_data ;
200: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CONSOLIDATED_QTE_PUB','update_consolidate_quote');
201: FND_MSG_PUB.count_and_get(