DBA Data[Home] [Help]

APPS.OKL_AM_CONSOLIDATED_QTE_PUB dependencies on FND_API

Line 55: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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;

Line 56: RAISE FND_API.G_EXC_ERROR;

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:

Line 57: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

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:

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 71: WHEN FND_API.G_EXC_ERROR THEN

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 ;

Line 73: x_return_status := FND_API.G_RET_STS_ERROR;

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,

Line 80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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(

Line 157: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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;

Line 158: RAISE FND_API.G_EXC_ERROR;

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:

Line 159: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

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

Line 160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 177: WHEN FND_API.G_EXC_ERROR THEN

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 ;

Line 179: x_return_status := FND_API.G_RET_STS_ERROR;

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,

Line 186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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(