47: x_msg_data => l_msg_data);
48: -- Private API Call end
49:
50:
51: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
52: RAISE FND_API.G_EXC_ERROR;
53: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
48: -- Private API Call end
49:
50:
51: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
52: RAISE FND_API.G_EXC_ERROR;
53: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
49:
50:
51: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
52: RAISE FND_API.G_EXC_ERROR;
53: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: --Copy value of OUT variable in the IN record type
50:
51: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
52: RAISE FND_API.G_EXC_ERROR;
53: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: --Copy value of OUT variable in the IN record type
58: lp_oinv_rec := lx_oinv_rec;
66: x_msg_data := l_msg_data ;
67:
68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71: ROLLBACK TO insert_pending_int;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;
68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71: ROLLBACK TO insert_pending_int;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.count_and_get(
76: p_count => x_msg_count
74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.count_and_get(
76: p_count => x_msg_count
77: ,p_data => x_msg_data);
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: ROLLBACK TO insert_pending_int;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: x_msg_count := l_msg_count ;
82: x_msg_data := l_msg_data ;
76: p_count => x_msg_count
77: ,p_data => x_msg_data);
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: ROLLBACK TO insert_pending_int;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: x_msg_count := l_msg_count ;
82: x_msg_data := l_msg_data ;
83: FND_MSG_PUB.count_and_get(
84: p_count => x_msg_count
84: p_count => x_msg_count
85: ,p_data => x_msg_data);
86: WHEN OTHERS THEN
87: ROLLBACK TO insert_pending_int;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','insert_pending_int');
92: FND_MSG_PUB.count_and_get(
163: x_msg_data => l_msg_data);
164: -- Private API Call end
165:
166:
167: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
168: RAISE FND_API.G_EXC_ERROR;
169: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: END IF;
164: -- Private API Call end
165:
166:
167: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
168: RAISE FND_API.G_EXC_ERROR;
169: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172:
165:
166:
167: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
168: RAISE FND_API.G_EXC_ERROR;
169: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172:
173: --Copy value of OUT variable in the IN record type
166:
167: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
168: RAISE FND_API.G_EXC_ERROR;
169: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172:
173: --Copy value of OUT variable in the IN record type
174: lp_oinv_rec := lx_oinv_rec;
182: x_msg_data := l_msg_data ;
183:
184: EXCEPTION
185:
186: WHEN FND_API.G_EXC_ERROR THEN
187: ROLLBACK TO process_pending_int;
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: x_msg_count := l_msg_count ;
190: x_msg_data := l_msg_data ;
184: EXCEPTION
185:
186: WHEN FND_API.G_EXC_ERROR THEN
187: ROLLBACK TO process_pending_int;
188: x_return_status := FND_API.G_RET_STS_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
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO process_pending_int;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: x_msg_count := l_msg_count ;
198: x_msg_data := l_msg_data ;
192: p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO process_pending_int;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: x_msg_count := l_msg_count ;
198: x_msg_data := l_msg_data ;
199: FND_MSG_PUB.count_and_get(
200: p_count => x_msg_count
200: p_count => x_msg_count
201: ,p_data => x_msg_data);
202: WHEN OTHERS THEN
203: ROLLBACK TO process_pending_int;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: x_msg_count := l_msg_count ;
206: x_msg_data := l_msg_data ;
207: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','insert_pending_int');
208: FND_MSG_PUB.count_and_get(