DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PUB dependencies on FND_API

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

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;

Line 52: RAISE FND_API.G_EXC_ERROR;

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:

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

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

Line 54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 70: WHEN FND_API.G_EXC_ERROR THEN

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 ;

Line 72: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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(

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

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;

Line 168: RAISE FND_API.G_EXC_ERROR;

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:

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

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

Line 170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 186: WHEN FND_API.G_EXC_ERROR THEN

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 ;

Line 188: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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(