eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_OPEN_INT_HST_PUB dependencies on FND_API

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

43: ,x_msg_count => l_msg_count
44: ,x_return_status => l_return_status
45: ,p_iohv_rec => lp_iohv_rec
46: ,x_iohv_rec => lx_iohv_rec) ;
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;

Line 48: RAISE FND_API.G_EXC_ERROR;

44: ,x_return_status => l_return_status
45: ,p_iohv_rec => lp_iohv_rec
46: ,x_iohv_rec => lx_iohv_rec) ;
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:

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

45: ,p_iohv_rec => lp_iohv_rec
46: ,x_iohv_rec => lx_iohv_rec) ;
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: --Copy value of OUT NOCOPY record type variable in the IN record type

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

46: ,x_iohv_rec => lx_iohv_rec) ;
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: --Copy value of OUT NOCOPY record type variable in the IN record type
54: lp_iohv_rec := lx_iohv_rec;

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

66: ,x_msg_count => l_msg_count
67: ,x_return_status => l_return_status
68: ,p_iohv_rec => lp_iohv_rec
69: ,x_iohv_rec => lx_iohv_rec );
70: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
71: RAISE FND_API.G_EXC_ERROR;
72: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;

Line 71: RAISE FND_API.G_EXC_ERROR;

67: ,x_return_status => l_return_status
68: ,p_iohv_rec => lp_iohv_rec
69: ,x_iohv_rec => lx_iohv_rec );
70: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
71: RAISE FND_API.G_EXC_ERROR;
72: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75:

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

68: ,p_iohv_rec => lp_iohv_rec
69: ,x_iohv_rec => lx_iohv_rec );
70: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
71: RAISE FND_API.G_EXC_ERROR;
72: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75:
76: --Copy value of OUT NOCOPY variable in the IN record type

Line 73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

69: ,x_iohv_rec => lx_iohv_rec );
70: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
71: RAISE FND_API.G_EXC_ERROR;
72: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75:
76: --Copy value of OUT NOCOPY variable in the IN record type
77: lp_iohv_rec := lx_iohv_rec;

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

87: ,l_msg_data
88: ,lp_iohv_rec
89: ,lx_iohv_rec);
90:
91: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
92: RAISE FND_API.G_EXC_ERROR;
93: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;

Line 92: RAISE FND_API.G_EXC_ERROR;

88: ,lp_iohv_rec
89: ,lx_iohv_rec);
90:
91: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
92: RAISE FND_API.G_EXC_ERROR;
93: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:

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

89: ,lx_iohv_rec);
90:
91: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
92: RAISE FND_API.G_EXC_ERROR;
93: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: --Copy value of OUT NOCOPY variable in the IN record type

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90:
91: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
92: RAISE FND_API.G_EXC_ERROR;
93: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: --Copy value of OUT NOCOPY variable in the IN record type
98: lp_iohv_rec := lx_iohv_rec;

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

104: ,x_msg_data => l_msg_data
105: ,x_msg_count => l_msg_count
106: ,x_return_status => l_return_status
107: ,p_iohv_rec => lp_iohv_rec);
108: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
109: RAISE FND_API.G_EXC_ERROR;
110: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;

Line 109: RAISE FND_API.G_EXC_ERROR;

105: ,x_msg_count => l_msg_count
106: ,x_return_status => l_return_status
107: ,p_iohv_rec => lp_iohv_rec);
108: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
109: RAISE FND_API.G_EXC_ERROR;
110: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113: END IF;

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

106: ,x_return_status => l_return_status
107: ,p_iohv_rec => lp_iohv_rec);
108: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
109: RAISE FND_API.G_EXC_ERROR;
110: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113: END IF;
114: --Vertical post processing user hook call end

Line 111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

107: ,p_iohv_rec => lp_iohv_rec);
108: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
109: RAISE FND_API.G_EXC_ERROR;
110: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113: END IF;
114: --Vertical post processing user hook call end
115:

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

121: ,x_msg_data => l_msg_data
122: ,x_msg_count => l_msg_count
123: ,x_return_status => l_return_status
124: ,p_iohv_rec => lp_iohv_rec);
125: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
126: RAISE FND_API.G_EXC_ERROR;
127: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;

Line 126: RAISE FND_API.G_EXC_ERROR;

122: ,x_msg_count => l_msg_count
123: ,x_return_status => l_return_status
124: ,p_iohv_rec => lp_iohv_rec);
125: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
126: RAISE FND_API.G_EXC_ERROR;
127: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: END IF;

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

123: ,x_return_status => l_return_status
124: ,p_iohv_rec => lp_iohv_rec);
125: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
126: RAISE FND_API.G_EXC_ERROR;
127: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: END IF;
131: --Customer post processing user hook call end

Line 128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

124: ,p_iohv_rec => lp_iohv_rec);
125: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
126: RAISE FND_API.G_EXC_ERROR;
127: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: END IF;
131: --Customer post processing user hook call end
132:

Line 142: WHEN FND_API.G_EXC_ERROR THEN

138: x_msg_data := l_msg_data ;
139:
140: EXCEPTION
141:
142: WHEN FND_API.G_EXC_ERROR THEN
143: ROLLBACK TO open_int_hst_insert;
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: x_msg_count := l_msg_count ;
146: x_msg_data := l_msg_data ;

Line 144: x_return_status := FND_API.G_RET_STS_ERROR;

140: EXCEPTION
141:
142: WHEN FND_API.G_EXC_ERROR THEN
143: ROLLBACK TO open_int_hst_insert;
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: x_msg_count := l_msg_count ;
146: x_msg_data := l_msg_data ;
147: FND_MSG_PUB.count_and_get(
148: p_count => x_msg_count

Line 150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

146: x_msg_data := l_msg_data ;
147: FND_MSG_PUB.count_and_get(
148: p_count => x_msg_count
149: ,p_data => x_msg_data);
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: ROLLBACK TO open_int_hst_insert;
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: x_msg_count := l_msg_count ;
154: x_msg_data := l_msg_data ;

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

148: p_count => x_msg_count
149: ,p_data => x_msg_data);
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: ROLLBACK TO open_int_hst_insert;
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: x_msg_count := l_msg_count ;
154: x_msg_data := l_msg_data ;
155: FND_MSG_PUB.count_and_get(
156: p_count => x_msg_count

Line 160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

156: p_count => x_msg_count
157: ,p_data => x_msg_data);
158: WHEN OTHERS THEN
159: ROLLBACK TO open_int_hst_insert;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: x_msg_count := l_msg_count ;
162: x_msg_data := l_msg_data ;
163: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','insert_open_int_hst');
164: FND_MSG_PUB.count_and_get(

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

204: ,x_msg_count => l_msg_count
205: ,x_return_status => l_return_status
206: ,p_iohv_tbl => lp_iohv_tbl
207: ,x_iohv_tbl => lx_iohv_tbl);
208: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;

Line 209: RAISE FND_API.G_EXC_ERROR;

205: ,x_return_status => l_return_status
206: ,p_iohv_tbl => lp_iohv_tbl
207: ,x_iohv_tbl => lx_iohv_tbl);
208: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:

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

206: ,p_iohv_tbl => lp_iohv_tbl
207: ,x_iohv_tbl => lx_iohv_tbl);
208: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: --Copy value of OUT NOCOPY variable in the IN record type

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207: ,x_iohv_tbl => lx_iohv_tbl);
208: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: --Copy value of OUT NOCOPY variable in the IN record type
215: lp_iohv_tbl := lx_iohv_tbl;

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

225: ,x_msg_count => l_msg_count
226: ,x_return_status => l_return_status
227: ,p_iohv_tbl => lp_iohv_tbl
228: ,x_iohv_tbl => lx_iohv_tbl);
229: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;

Line 230: RAISE FND_API.G_EXC_ERROR;

226: ,x_return_status => l_return_status
227: ,p_iohv_tbl => lp_iohv_tbl
228: ,x_iohv_tbl => lx_iohv_tbl);
229: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:

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

227: ,p_iohv_tbl => lp_iohv_tbl
228: ,x_iohv_tbl => lx_iohv_tbl);
229: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: --Copy value of OUT NOCOPY variable in the IN record type

Line 232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

228: ,x_iohv_tbl => lx_iohv_tbl);
229: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: --Copy value of OUT NOCOPY variable in the IN record type
236: lp_iohv_tbl := lx_iohv_tbl;

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

246: ,l_msg_data
247: ,lp_iohv_tbl
248: ,lx_iohv_tbl);
249:
250: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
251: RAISE FND_API.G_EXC_ERROR;
252: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;

Line 251: RAISE FND_API.G_EXC_ERROR;

247: ,lp_iohv_tbl
248: ,lx_iohv_tbl);
249:
250: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
251: RAISE FND_API.G_EXC_ERROR;
252: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:

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

248: ,lx_iohv_tbl);
249:
250: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
251: RAISE FND_API.G_EXC_ERROR;
252: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:
256: --Copy value of OUT NOCOPY variable in the IN record type

Line 253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249:
250: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
251: RAISE FND_API.G_EXC_ERROR;
252: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:
256: --Copy value of OUT NOCOPY variable in the IN record type
257: lp_iohv_tbl := lx_iohv_tbl;

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

263: ,x_msg_data => l_msg_data
264: ,x_msg_count => l_msg_count
265: ,x_return_status => l_return_status
266: ,p_iohv_tbl => lp_iohv_tbl) ;
267: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
268: RAISE FND_API.G_EXC_ERROR;
269: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;

Line 268: RAISE FND_API.G_EXC_ERROR;

264: ,x_msg_count => l_msg_count
265: ,x_return_status => l_return_status
266: ,p_iohv_tbl => lp_iohv_tbl) ;
267: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
268: RAISE FND_API.G_EXC_ERROR;
269: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272: END IF;

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

265: ,x_return_status => l_return_status
266: ,p_iohv_tbl => lp_iohv_tbl) ;
267: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
268: RAISE FND_API.G_EXC_ERROR;
269: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272: END IF;
273: --Vertical post-processing user hook call end

Line 270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

266: ,p_iohv_tbl => lp_iohv_tbl) ;
267: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
268: RAISE FND_API.G_EXC_ERROR;
269: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272: END IF;
273: --Vertical post-processing user hook call end
274:

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

279: ,x_msg_data => l_msg_data
280: ,x_msg_count => l_msg_count
281: ,x_return_status => l_return_status
282: ,p_iohv_tbl => lp_iohv_tbl) ;
283: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;

Line 284: RAISE FND_API.G_EXC_ERROR;

280: ,x_msg_count => l_msg_count
281: ,x_return_status => l_return_status
282: ,p_iohv_tbl => lp_iohv_tbl) ;
283: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288: END IF;

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

281: ,x_return_status => l_return_status
282: ,p_iohv_tbl => lp_iohv_tbl) ;
283: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288: END IF;
289: --Customer post-processing user hook call end

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282: ,p_iohv_tbl => lp_iohv_tbl) ;
283: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288: END IF;
289: --Customer post-processing user hook call end
290: */

Line 300: WHEN FND_API.G_EXC_ERROR THEN

296:
297:
298: EXCEPTION
299:
300: WHEN FND_API.G_EXC_ERROR THEN
301: ROLLBACK TO open_int_hst_insert;
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: x_msg_count := l_msg_count ;
304: x_msg_data := l_msg_data ;

Line 302: x_return_status := FND_API.G_RET_STS_ERROR;

298: EXCEPTION
299:
300: WHEN FND_API.G_EXC_ERROR THEN
301: ROLLBACK TO open_int_hst_insert;
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: x_msg_count := l_msg_count ;
304: x_msg_data := l_msg_data ;
305: FND_MSG_PUB.count_and_get(
306: p_count => x_msg_count

Line 308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

304: x_msg_data := l_msg_data ;
305: FND_MSG_PUB.count_and_get(
306: p_count => x_msg_count
307: ,p_data => x_msg_data);
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309: ROLLBACK TO open_int_hst_insert;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: x_msg_count := l_msg_count ;
312: x_msg_data := l_msg_data ;

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

306: p_count => x_msg_count
307: ,p_data => x_msg_data);
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309: ROLLBACK TO open_int_hst_insert;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: x_msg_count := l_msg_count ;
312: x_msg_data := l_msg_data ;
313: FND_MSG_PUB.count_and_get(
314: p_count => x_msg_count

Line 318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

314: p_count => x_msg_count
315: ,p_data => x_msg_data);
316: WHEN OTHERS THEN
317: ROLLBACK TO open_int_hst_insert;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: x_msg_count := l_msg_count ;
320: x_msg_data := l_msg_data ;
321: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','insert_open_int_hst');
322: FND_MSG_PUB.count_and_get(

Line 344: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

340: x_msg_count,
341: x_msg_data,
342: p_iohv_rec);
343:
344: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
345: RAISE FND_API.G_EXC_ERROR;
346: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END IF;

Line 345: RAISE FND_API.G_EXC_ERROR;

341: x_msg_data,
342: p_iohv_rec);
343:
344: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
345: RAISE FND_API.G_EXC_ERROR;
346: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END IF;
349:

Line 346: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

342: p_iohv_rec);
343:
344: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
345: RAISE FND_API.G_EXC_ERROR;
346: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END IF;
349:
350:

Line 347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

343:
344: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
345: RAISE FND_API.G_EXC_ERROR;
346: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END IF;
349:
350:
351: EXCEPTION

Line 353: WHEN FND_API.G_EXC_ERROR THEN

349:
350:
351: EXCEPTION
352:
353: WHEN FND_API.G_EXC_ERROR THEN
354: FND_MSG_PUB.count_and_get(
355: p_count => x_msg_count
356: ,p_data => x_msg_data);
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

353: WHEN FND_API.G_EXC_ERROR THEN
354: FND_MSG_PUB.count_and_get(
355: p_count => x_msg_count
356: ,p_data => x_msg_data);
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
358: FND_MSG_PUB.count_and_get(
359: p_count => x_msg_count
360: ,p_data => x_msg_data);
361: WHEN OTHERS THEN

Line 362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

358: FND_MSG_PUB.count_and_get(
359: p_count => x_msg_count
360: ,p_data => x_msg_data);
361: WHEN OTHERS THEN
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','lock_open_int_hst');
364: FND_MSG_PUB.count_and_get(
365: p_count => x_msg_count
366: ,p_data => x_msg_data);

Line 386: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

382: x_msg_count,
383: x_msg_data,
384: p_iohv_tbl);
385:
386: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
387: RAISE FND_API.G_EXC_ERROR;
388: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;

Line 387: RAISE FND_API.G_EXC_ERROR;

383: x_msg_data,
384: p_iohv_tbl);
385:
386: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
387: RAISE FND_API.G_EXC_ERROR;
388: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391:

Line 388: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

384: p_iohv_tbl);
385:
386: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
387: RAISE FND_API.G_EXC_ERROR;
388: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391:
392:

Line 389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

385:
386: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
387: RAISE FND_API.G_EXC_ERROR;
388: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391:
392:
393: EXCEPTION

Line 395: WHEN FND_API.G_EXC_ERROR THEN

391:
392:
393: EXCEPTION
394:
395: WHEN FND_API.G_EXC_ERROR THEN
396: FND_MSG_PUB.count_and_get(
397: p_count => x_msg_count
398: ,p_data => x_msg_data);
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

395: WHEN FND_API.G_EXC_ERROR THEN
396: FND_MSG_PUB.count_and_get(
397: p_count => x_msg_count
398: ,p_data => x_msg_data);
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: FND_MSG_PUB.count_and_get(
401: p_count => x_msg_count
402: ,p_data => x_msg_data);
403: WHEN OTHERS THEN

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

400: FND_MSG_PUB.count_and_get(
401: p_count => x_msg_count
402: ,p_data => x_msg_data);
403: WHEN OTHERS THEN
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','lock_open_int_hst');
406: FND_MSG_PUB.count_and_get(
407: p_count => x_msg_count
408: ,p_data => x_msg_data);

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

447: ,x_msg_count => l_msg_count
448: ,x_return_status => l_return_status
449: ,p_iohv_rec => lp_iohv_rec
450: ,x_iohv_rec => lx_iohv_rec) ;
451: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
452: RAISE FND_API.G_EXC_ERROR;
453: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;

Line 452: RAISE FND_API.G_EXC_ERROR;

448: ,x_return_status => l_return_status
449: ,p_iohv_rec => lp_iohv_rec
450: ,x_iohv_rec => lx_iohv_rec) ;
451: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
452: RAISE FND_API.G_EXC_ERROR;
453: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:

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

449: ,p_iohv_rec => lp_iohv_rec
450: ,x_iohv_rec => lx_iohv_rec) ;
451: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
452: RAISE FND_API.G_EXC_ERROR;
453: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457: --Copy value of OUT NOCOPY variable in the IN record type

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450: ,x_iohv_rec => lx_iohv_rec) ;
451: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
452: RAISE FND_API.G_EXC_ERROR;
453: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457: --Copy value of OUT NOCOPY variable in the IN record type
458: lp_iohv_rec := lx_iohv_rec;

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

469: ,x_msg_count => l_msg_count
470: ,x_return_status => l_return_status
471: ,p_iohv_rec => lp_iohv_rec
472: ,x_iohv_rec => lx_iohv_rec) ;
473: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
474: RAISE FND_API.G_EXC_ERROR;
475: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;

Line 474: RAISE FND_API.G_EXC_ERROR;

470: ,x_return_status => l_return_status
471: ,p_iohv_rec => lp_iohv_rec
472: ,x_iohv_rec => lx_iohv_rec) ;
473: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
474: RAISE FND_API.G_EXC_ERROR;
475: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;
478:

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

471: ,p_iohv_rec => lp_iohv_rec
472: ,x_iohv_rec => lx_iohv_rec) ;
473: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
474: RAISE FND_API.G_EXC_ERROR;
475: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;
478:
479: --Copy value of OUT NOCOPY variable in the IN record type

Line 476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

472: ,x_iohv_rec => lx_iohv_rec) ;
473: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
474: RAISE FND_API.G_EXC_ERROR;
475: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;
478:
479: --Copy value of OUT NOCOPY variable in the IN record type
480: lp_iohv_rec := lx_iohv_rec;

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

490: ,l_msg_data
491: ,lp_iohv_rec
492: ,lx_iohv_rec);
493:
494: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;

Line 495: RAISE FND_API.G_EXC_ERROR;

491: ,lp_iohv_rec
492: ,lx_iohv_rec);
493:
494: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:

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

492: ,lx_iohv_rec);
493:
494: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: --Copy value of OUT NOCOPY variable in the IN record type

Line 497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493:
494: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
495: RAISE FND_API.G_EXC_ERROR;
496: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: --Copy value of OUT NOCOPY variable in the IN record type
501: lp_iohv_rec := lx_iohv_rec;

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

507: ,x_msg_data => l_msg_data
508: ,x_msg_count => l_msg_count
509: ,x_return_status => l_return_status
510: ,p_iohv_rec => lp_iohv_rec) ;
511: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;

Line 512: RAISE FND_API.G_EXC_ERROR;

508: ,x_msg_count => l_msg_count
509: ,x_return_status => l_return_status
510: ,p_iohv_rec => lp_iohv_rec) ;
511: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516: END IF;

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

509: ,x_return_status => l_return_status
510: ,p_iohv_rec => lp_iohv_rec) ;
511: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516: END IF;
517: --Vertical post-processing user hook call end

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510: ,p_iohv_rec => lp_iohv_rec) ;
511: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516: END IF;
517: --Vertical post-processing user hook call end
518:

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

524: ,x_msg_data => l_msg_data
525: ,x_msg_count => l_msg_count
526: ,x_return_status => l_return_status
527: ,p_iohv_rec => lp_iohv_rec) ;
528: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;

Line 529: RAISE FND_API.G_EXC_ERROR;

525: ,x_msg_count => l_msg_count
526: ,x_return_status => l_return_status
527: ,p_iohv_rec => lp_iohv_rec) ;
528: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533: END IF;

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

526: ,x_return_status => l_return_status
527: ,p_iohv_rec => lp_iohv_rec) ;
528: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533: END IF;
534: --Customer post-processing user hook call end

Line 531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

527: ,p_iohv_rec => lp_iohv_rec) ;
528: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533: END IF;
534: --Customer post-processing user hook call end
535: */

Line 545: WHEN FND_API.G_EXC_ERROR THEN

541:
542:
543: EXCEPTION
544:
545: WHEN FND_API.G_EXC_ERROR THEN
546: ROLLBACK TO open_int_hst_update;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: x_msg_count := l_msg_count ;
549: x_msg_data := l_msg_data ;

Line 547: x_return_status := FND_API.G_RET_STS_ERROR;

543: EXCEPTION
544:
545: WHEN FND_API.G_EXC_ERROR THEN
546: ROLLBACK TO open_int_hst_update;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: x_msg_count := l_msg_count ;
549: x_msg_data := l_msg_data ;
550: FND_MSG_PUB.count_and_get(
551: p_count => x_msg_count

Line 553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

549: x_msg_data := l_msg_data ;
550: FND_MSG_PUB.count_and_get(
551: p_count => x_msg_count
552: ,p_data => x_msg_data);
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO open_int_hst_update;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: x_msg_count := l_msg_count ;
557: x_msg_data := l_msg_data ;

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

551: p_count => x_msg_count
552: ,p_data => x_msg_data);
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO open_int_hst_update;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: x_msg_count := l_msg_count ;
557: x_msg_data := l_msg_data ;
558: FND_MSG_PUB.count_and_get(
559: p_count => x_msg_count

Line 563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

559: p_count => x_msg_count
560: ,p_data => x_msg_data);
561: WHEN OTHERS THEN
562: ROLLBACK TO open_int_hst_update;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: x_msg_count := l_msg_count ;
565: x_msg_data := l_msg_data ;
566: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','update_open_int_hst');
567: FND_MSG_PUB.count_and_get(

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

607: ,x_msg_count => l_msg_count
608: ,x_return_status => l_return_status
609: ,p_iohv_tbl => lp_iohv_tbl
610: ,x_iohv_tbl => lx_iohv_tbl) ;
611: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;

Line 612: RAISE FND_API.G_EXC_ERROR;

608: ,x_return_status => l_return_status
609: ,p_iohv_tbl => lp_iohv_tbl
610: ,x_iohv_tbl => lx_iohv_tbl) ;
611: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:

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

609: ,p_iohv_tbl => lp_iohv_tbl
610: ,x_iohv_tbl => lx_iohv_tbl) ;
611: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:
617: --Copy value of OUT NOCOPY variable in the IN record type

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610: ,x_iohv_tbl => lx_iohv_tbl) ;
611: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:
617: --Copy value of OUT NOCOPY variable in the IN record type
618: lp_iohv_tbl := lx_iohv_tbl;

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

629: ,x_msg_count => l_msg_count
630: ,x_return_status => l_return_status
631: ,p_iohv_tbl => lp_iohv_tbl
632: ,x_iohv_tbl => lx_iohv_tbl) ;
633: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
634: RAISE FND_API.G_EXC_ERROR;
635: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;

Line 634: RAISE FND_API.G_EXC_ERROR;

630: ,x_return_status => l_return_status
631: ,p_iohv_tbl => lp_iohv_tbl
632: ,x_iohv_tbl => lx_iohv_tbl) ;
633: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
634: RAISE FND_API.G_EXC_ERROR;
635: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638:

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

631: ,p_iohv_tbl => lp_iohv_tbl
632: ,x_iohv_tbl => lx_iohv_tbl) ;
633: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
634: RAISE FND_API.G_EXC_ERROR;
635: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638:
639: --Copy value of OUT NOCOPY variable in the IN record type

Line 636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

632: ,x_iohv_tbl => lx_iohv_tbl) ;
633: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
634: RAISE FND_API.G_EXC_ERROR;
635: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638:
639: --Copy value of OUT NOCOPY variable in the IN record type
640: lp_iohv_tbl := lx_iohv_tbl;

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

650: ,l_msg_data
651: ,lp_iohv_tbl
652: ,lx_iohv_tbl);
653:
654: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;

Line 655: RAISE FND_API.G_EXC_ERROR;

651: ,lp_iohv_tbl
652: ,lx_iohv_tbl);
653:
654: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659:

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

652: ,lx_iohv_tbl);
653:
654: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659:
660: --Copy value of OUT NOCOPY variable in the IN record type

Line 657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

653:
654: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659:
660: --Copy value of OUT NOCOPY variable in the IN record type
661: lp_iohv_tbl := lx_iohv_tbl;

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

667: ,x_msg_data => l_msg_data
668: ,x_msg_count => l_msg_count
669: ,x_return_status => l_return_status
670: ,p_iohv_tbl => lp_iohv_tbl) ;
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;

Line 672: RAISE FND_API.G_EXC_ERROR;

668: ,x_msg_count => l_msg_count
669: ,x_return_status => l_return_status
670: ,p_iohv_tbl => lp_iohv_tbl) ;
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: END IF;

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

669: ,x_return_status => l_return_status
670: ,p_iohv_tbl => lp_iohv_tbl) ;
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: END IF;
677: --Vertical post-processing user hook call end

Line 674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

670: ,p_iohv_tbl => lp_iohv_tbl) ;
671: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: END IF;
677: --Vertical post-processing user hook call end
678:

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

683: ,x_msg_data => l_msg_data
684: ,x_msg_count => l_msg_count
685: ,x_return_status => l_return_status
686: ,p_iohv_tbl => lp_iohv_tbl) ;
687: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
688: RAISE FND_API.G_EXC_ERROR;
689: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;

Line 688: RAISE FND_API.G_EXC_ERROR;

684: ,x_msg_count => l_msg_count
685: ,x_return_status => l_return_status
686: ,p_iohv_tbl => lp_iohv_tbl) ;
687: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
688: RAISE FND_API.G_EXC_ERROR;
689: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692: END IF;

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

685: ,x_return_status => l_return_status
686: ,p_iohv_tbl => lp_iohv_tbl) ;
687: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
688: RAISE FND_API.G_EXC_ERROR;
689: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692: END IF;
693: --Customer post-processing user hook call end

Line 690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

686: ,p_iohv_tbl => lp_iohv_tbl) ;
687: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
688: RAISE FND_API.G_EXC_ERROR;
689: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692: END IF;
693: --Customer post-processing user hook call end
694: */

Line 705: WHEN FND_API.G_EXC_ERROR THEN

701:
702:
703: EXCEPTION
704:
705: WHEN FND_API.G_EXC_ERROR THEN
706: ROLLBACK TO open_int_hst_update;
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: x_msg_count := l_msg_count ;
709: x_msg_data := l_msg_data ;

Line 707: x_return_status := FND_API.G_RET_STS_ERROR;

703: EXCEPTION
704:
705: WHEN FND_API.G_EXC_ERROR THEN
706: ROLLBACK TO open_int_hst_update;
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: x_msg_count := l_msg_count ;
709: x_msg_data := l_msg_data ;
710: FND_MSG_PUB.count_and_get(
711: p_count => x_msg_count

Line 713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

709: x_msg_data := l_msg_data ;
710: FND_MSG_PUB.count_and_get(
711: p_count => x_msg_count
712: ,p_data => x_msg_data);
713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
714: ROLLBACK TO open_int_hst_update;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: x_msg_count := l_msg_count ;
717: x_msg_data := l_msg_data ;

Line 715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

711: p_count => x_msg_count
712: ,p_data => x_msg_data);
713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
714: ROLLBACK TO open_int_hst_update;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: x_msg_count := l_msg_count ;
717: x_msg_data := l_msg_data ;
718: FND_MSG_PUB.count_and_get(
719: p_count => x_msg_count

Line 723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

719: p_count => x_msg_count
720: ,p_data => x_msg_data);
721: WHEN OTHERS THEN
722: ROLLBACK TO open_int_hst_update;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: x_msg_count := l_msg_count ;
725: x_msg_data := l_msg_data ;
726: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','update_open_int_hst');
727: FND_MSG_PUB.count_and_get(

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

768: ,x_msg_count => l_msg_count
769: ,x_return_status => l_return_status
770: ,p_iohv_rec => lp_iohv_rec
771: ,x_iohv_rec => lx_iohv_rec) ;
772: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
773: RAISE FND_API.G_EXC_ERROR;
774: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;

Line 773: RAISE FND_API.G_EXC_ERROR;

769: ,x_return_status => l_return_status
770: ,p_iohv_rec => lp_iohv_rec
771: ,x_iohv_rec => lx_iohv_rec) ;
772: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
773: RAISE FND_API.G_EXC_ERROR;
774: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:

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

770: ,p_iohv_rec => lp_iohv_rec
771: ,x_iohv_rec => lx_iohv_rec) ;
772: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
773: RAISE FND_API.G_EXC_ERROR;
774: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: --Copy value of OUT NOCOPY variable in the IN record type

Line 775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

771: ,x_iohv_rec => lx_iohv_rec) ;
772: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
773: RAISE FND_API.G_EXC_ERROR;
774: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: --Copy value of OUT NOCOPY variable in the IN record type
779: lp_iohv_rec := lx_iohv_rec;

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

790: ,x_msg_count => l_msg_count
791: ,x_return_status => l_return_status
792: ,p_iohv_rec => lp_iohv_rec
793: ,x_iohv_rec => lx_iohv_rec) ;
794: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
795: RAISE FND_API.G_EXC_ERROR;
796: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
798: END IF;

Line 795: RAISE FND_API.G_EXC_ERROR;

791: ,x_return_status => l_return_status
792: ,p_iohv_rec => lp_iohv_rec
793: ,x_iohv_rec => lx_iohv_rec) ;
794: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
795: RAISE FND_API.G_EXC_ERROR;
796: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
798: END IF;
799:

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

792: ,p_iohv_rec => lp_iohv_rec
793: ,x_iohv_rec => lx_iohv_rec) ;
794: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
795: RAISE FND_API.G_EXC_ERROR;
796: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
798: END IF;
799:
800: --Copy value of OUT NOCOPY variable in the IN record type

Line 797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

793: ,x_iohv_rec => lx_iohv_rec) ;
794: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
795: RAISE FND_API.G_EXC_ERROR;
796: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
798: END IF;
799:
800: --Copy value of OUT NOCOPY variable in the IN record type
801: lp_iohv_rec := lx_iohv_rec;

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

811: ,l_msg_count
812: ,l_msg_data
813: ,lp_iohv_rec);
814:
815: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;

Line 816: RAISE FND_API.G_EXC_ERROR;

812: ,l_msg_data
813: ,lp_iohv_rec);
814:
815: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820:

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

813: ,lp_iohv_rec);
814:
815: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820:
821: /*

Line 818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

814:
815: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820:
821: /*
822: --Vertical post-processing user hook call start

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

826: ,x_msg_data => l_msg_data
827: ,x_msg_count => l_msg_count
828: ,x_return_status => l_return_status
829: ,p_iohv_rec => lp_iohv_rec) ;
830: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
831: RAISE FND_API.G_EXC_ERROR;
832: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END IF;

Line 831: RAISE FND_API.G_EXC_ERROR;

827: ,x_msg_count => l_msg_count
828: ,x_return_status => l_return_status
829: ,p_iohv_rec => lp_iohv_rec) ;
830: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
831: RAISE FND_API.G_EXC_ERROR;
832: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END IF;
835: END IF;

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

828: ,x_return_status => l_return_status
829: ,p_iohv_rec => lp_iohv_rec) ;
830: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
831: RAISE FND_API.G_EXC_ERROR;
832: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END IF;
835: END IF;
836: --Vertical post-processing user hook call end

Line 833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

829: ,p_iohv_rec => lp_iohv_rec) ;
830: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
831: RAISE FND_API.G_EXC_ERROR;
832: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END IF;
835: END IF;
836: --Vertical post-processing user hook call end
837:

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

843: ,x_msg_data => l_msg_data
844: ,x_msg_count => l_msg_count
845: ,x_return_status => l_return_status
846: ,p_iohv_rec => lp_iohv_rec) ;
847: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
848: RAISE FND_API.G_EXC_ERROR;
849: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;

Line 848: RAISE FND_API.G_EXC_ERROR;

844: ,x_msg_count => l_msg_count
845: ,x_return_status => l_return_status
846: ,p_iohv_rec => lp_iohv_rec) ;
847: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
848: RAISE FND_API.G_EXC_ERROR;
849: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: END IF;

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

845: ,x_return_status => l_return_status
846: ,p_iohv_rec => lp_iohv_rec) ;
847: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
848: RAISE FND_API.G_EXC_ERROR;
849: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: END IF;
853: --Customer post-processing user hook call end

Line 850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

846: ,p_iohv_rec => lp_iohv_rec) ;
847: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
848: RAISE FND_API.G_EXC_ERROR;
849: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: END IF;
853: --Customer post-processing user hook call end
854: */

Line 862: WHEN FND_API.G_EXC_ERROR THEN

858: x_return_status := l_return_status ;
859:
860: EXCEPTION
861:
862: WHEN FND_API.G_EXC_ERROR THEN
863: ROLLBACK TO open_int_hst_delete_rec;
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: x_msg_count := l_msg_count ;
866: x_msg_data := l_msg_data ;

Line 864: x_return_status := FND_API.G_RET_STS_ERROR;

860: EXCEPTION
861:
862: WHEN FND_API.G_EXC_ERROR THEN
863: ROLLBACK TO open_int_hst_delete_rec;
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: x_msg_count := l_msg_count ;
866: x_msg_data := l_msg_data ;
867: FND_MSG_PUB.count_and_get(
868: p_count => x_msg_count

Line 870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

866: x_msg_data := l_msg_data ;
867: FND_MSG_PUB.count_and_get(
868: p_count => x_msg_count
869: ,p_data => x_msg_data);
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871: ROLLBACK TO open_int_hst_delete_rec;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873: x_msg_count := l_msg_count ;
874: x_msg_data := l_msg_data ;

Line 872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

868: p_count => x_msg_count
869: ,p_data => x_msg_data);
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871: ROLLBACK TO open_int_hst_delete_rec;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873: x_msg_count := l_msg_count ;
874: x_msg_data := l_msg_data ;
875: FND_MSG_PUB.count_and_get(
876: p_count => x_msg_count

Line 880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

876: p_count => x_msg_count
877: ,p_data => x_msg_data);
878: WHEN OTHERS THEN
879: ROLLBACK TO open_int_hst_delete_rec;
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: x_msg_count := l_msg_count ;
882: x_msg_data := l_msg_data ;
883: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','delete_open_int_hst');
884: FND_MSG_PUB.count_and_get(

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

925: ,x_msg_count => l_msg_count
926: ,x_return_status => l_return_status
927: ,p_iohv_tbl => lp_iohv_tbl
928: ,x_iohv_tbl => lx_iohv_tbl) ;
929: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
930: RAISE FND_API.G_EXC_ERROR;
931: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;

Line 930: RAISE FND_API.G_EXC_ERROR;

926: ,x_return_status => l_return_status
927: ,p_iohv_tbl => lp_iohv_tbl
928: ,x_iohv_tbl => lx_iohv_tbl) ;
929: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
930: RAISE FND_API.G_EXC_ERROR;
931: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934:

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

927: ,p_iohv_tbl => lp_iohv_tbl
928: ,x_iohv_tbl => lx_iohv_tbl) ;
929: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
930: RAISE FND_API.G_EXC_ERROR;
931: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934:
935: --Copy value of OUT NOCOPY variable in the IN record type

Line 932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

928: ,x_iohv_tbl => lx_iohv_tbl) ;
929: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
930: RAISE FND_API.G_EXC_ERROR;
931: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934:
935: --Copy value of OUT NOCOPY variable in the IN record type
936: lp_iohv_tbl := lx_iohv_tbl;

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

947: ,x_msg_count => l_msg_count
948: ,x_return_status => l_return_status
949: ,p_iohv_tbl => lp_iohv_tbl
950: ,x_iohv_tbl => lx_iohv_tbl) ;
951: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
952: RAISE FND_API.G_EXC_ERROR;
953: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;

Line 952: RAISE FND_API.G_EXC_ERROR;

948: ,x_return_status => l_return_status
949: ,p_iohv_tbl => lp_iohv_tbl
950: ,x_iohv_tbl => lx_iohv_tbl) ;
951: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
952: RAISE FND_API.G_EXC_ERROR;
953: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956:

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

949: ,p_iohv_tbl => lp_iohv_tbl
950: ,x_iohv_tbl => lx_iohv_tbl) ;
951: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
952: RAISE FND_API.G_EXC_ERROR;
953: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956:
957: --Copy value of OUT NOCOPY variable in the IN record type

Line 954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

950: ,x_iohv_tbl => lx_iohv_tbl) ;
951: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
952: RAISE FND_API.G_EXC_ERROR;
953: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956:
957: --Copy value of OUT NOCOPY variable in the IN record type
958: lp_iohv_tbl := lx_iohv_tbl;

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

978: EXIT WHEN (i = lp_iohv_tbl.LAST);
979: i := p_iohv_tbl.NEXT(i);
980: END LOOP;
981: END IF;
982: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
983: RAISE FND_API.G_EXC_ERROR;
984: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;

Line 983: RAISE FND_API.G_EXC_ERROR;

979: i := p_iohv_tbl.NEXT(i);
980: END LOOP;
981: END IF;
982: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
983: RAISE FND_API.G_EXC_ERROR;
984: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;
987:

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

980: END LOOP;
981: END IF;
982: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
983: RAISE FND_API.G_EXC_ERROR;
984: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;
987:
988: END;

Line 985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

981: END IF;
982: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
983: RAISE FND_API.G_EXC_ERROR;
984: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;
987:
988: END;
989:

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

995: ,x_msg_data => l_msg_data
996: ,x_msg_count => l_msg_count
997: ,x_return_status => l_return_status
998: ,p_iohv_tbl => lp_iohv_tbl) ;
999: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;

Line 1000: RAISE FND_API.G_EXC_ERROR;

996: ,x_msg_count => l_msg_count
997: ,x_return_status => l_return_status
998: ,p_iohv_tbl => lp_iohv_tbl) ;
999: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004: END IF;

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

997: ,x_return_status => l_return_status
998: ,p_iohv_tbl => lp_iohv_tbl) ;
999: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004: END IF;
1005: --Vertical post-processing user hook call end

Line 1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

998: ,p_iohv_tbl => lp_iohv_tbl) ;
999: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004: END IF;
1005: --Vertical post-processing user hook call end
1006:

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

1012: ,x_msg_data => l_msg_data
1013: ,x_msg_count => l_msg_count
1014: ,x_return_status => l_return_status
1015: ,p_iohv_tbl => lp_iohv_tbl) ;
1016: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;

Line 1017: RAISE FND_API.G_EXC_ERROR;

1013: ,x_msg_count => l_msg_count
1014: ,x_return_status => l_return_status
1015: ,p_iohv_tbl => lp_iohv_tbl) ;
1016: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021: END IF;

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

1014: ,x_return_status => l_return_status
1015: ,p_iohv_tbl => lp_iohv_tbl) ;
1016: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021: END IF;
1022: --Customer post-processing user hook call end

Line 1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1015: ,p_iohv_tbl => lp_iohv_tbl) ;
1016: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021: END IF;
1022: --Customer post-processing user hook call end
1023: */

Line 1032: WHEN FND_API.G_EXC_ERROR THEN

1028: x_return_status := l_return_status ;
1029:
1030: EXCEPTION
1031:
1032: WHEN FND_API.G_EXC_ERROR THEN
1033: ROLLBACK TO open_int_hst_delete_tbl;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: x_msg_count := l_msg_count ;
1036: x_msg_data := l_msg_data ;

Line 1034: x_return_status := FND_API.G_RET_STS_ERROR;

1030: EXCEPTION
1031:
1032: WHEN FND_API.G_EXC_ERROR THEN
1033: ROLLBACK TO open_int_hst_delete_tbl;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: x_msg_count := l_msg_count ;
1036: x_msg_data := l_msg_data ;
1037: FND_MSG_PUB.count_and_get(
1038: p_count => x_msg_count

Line 1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1036: x_msg_data := l_msg_data ;
1037: FND_MSG_PUB.count_and_get(
1038: p_count => x_msg_count
1039: ,p_data => x_msg_data);
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041: ROLLBACK TO open_int_hst_delete_tbl;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: x_msg_count := l_msg_count ;
1044: x_msg_data := l_msg_data ;

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038: p_count => x_msg_count
1039: ,p_data => x_msg_data);
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041: ROLLBACK TO open_int_hst_delete_tbl;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: x_msg_count := l_msg_count ;
1044: x_msg_data := l_msg_data ;
1045: FND_MSG_PUB.count_and_get(
1046: p_count => x_msg_count

Line 1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1046: p_count => x_msg_count
1047: ,p_data => x_msg_data);
1048: WHEN OTHERS THEN
1049: ROLLBACK TO open_int_hst_delete_tbl;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: x_msg_count := l_msg_count ;
1052: x_msg_data := l_msg_data ;
1053: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','delete_open_int_hst');
1054: FND_MSG_PUB.count_and_get(

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

1092: ,x_msg_count => l_msg_count
1093: ,x_return_status => l_return_status
1094: ,p_iohv_rec => lp_iohv_rec
1095: ,x_iohv_rec => lx_iohv_rec) ;
1096: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;

Line 1097: RAISE FND_API.G_EXC_ERROR;

1093: ,x_return_status => l_return_status
1094: ,p_iohv_rec => lp_iohv_rec
1095: ,x_iohv_rec => lx_iohv_rec) ;
1096: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101:

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

1094: ,p_iohv_rec => lp_iohv_rec
1095: ,x_iohv_rec => lx_iohv_rec) ;
1096: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101:
1102: --Copy value of OUT NOCOPY variable in the IN record type

Line 1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1095: ,x_iohv_rec => lx_iohv_rec) ;
1096: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101:
1102: --Copy value of OUT NOCOPY variable in the IN record type
1103: lp_iohv_rec := lx_iohv_rec;

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

1114: ,x_msg_count => l_msg_count
1115: ,x_return_status => l_return_status
1116: ,p_iohv_rec => lp_iohv_rec
1117: ,x_iohv_rec => lx_iohv_rec) ;
1118: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1119: RAISE FND_API.G_EXC_ERROR;
1120: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;

Line 1119: RAISE FND_API.G_EXC_ERROR;

1115: ,x_return_status => l_return_status
1116: ,p_iohv_rec => lp_iohv_rec
1117: ,x_iohv_rec => lx_iohv_rec) ;
1118: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1119: RAISE FND_API.G_EXC_ERROR;
1120: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;
1123:

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

1116: ,p_iohv_rec => lp_iohv_rec
1117: ,x_iohv_rec => lx_iohv_rec) ;
1118: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1119: RAISE FND_API.G_EXC_ERROR;
1120: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;
1123:
1124: --Copy value of OUT NOCOPY variable in the IN record type

Line 1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1117: ,x_iohv_rec => lx_iohv_rec) ;
1118: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1119: RAISE FND_API.G_EXC_ERROR;
1120: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;
1123:
1124: --Copy value of OUT NOCOPY variable in the IN record type
1125: lp_iohv_rec := lx_iohv_rec;

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

1134: ,l_msg_count
1135: ,l_msg_data
1136: ,lp_iohv_rec);
1137:
1138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1139: RAISE FND_API.G_EXC_ERROR;
1140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1142: END IF;

Line 1139: RAISE FND_API.G_EXC_ERROR;

1135: ,l_msg_data
1136: ,lp_iohv_rec);
1137:
1138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1139: RAISE FND_API.G_EXC_ERROR;
1140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1142: END IF;
1143:

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

1136: ,lp_iohv_rec);
1137:
1138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1139: RAISE FND_API.G_EXC_ERROR;
1140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1142: END IF;
1143:
1144: --Copy value of OUT NOCOPY variable in the IN record type

Line 1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1137:
1138: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1139: RAISE FND_API.G_EXC_ERROR;
1140: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1142: END IF;
1143:
1144: --Copy value of OUT NOCOPY variable in the IN record type
1145: lp_iohv_rec := lx_iohv_rec;

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

1152: ,x_msg_data => l_msg_data
1153: ,x_msg_count => l_msg_count
1154: ,x_return_status => l_return_status
1155: ,p_iohv_rec => lp_iohv_rec) ;
1156: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1157: RAISE FND_API.G_EXC_ERROR;
1158: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: END IF;

Line 1157: RAISE FND_API.G_EXC_ERROR;

1153: ,x_msg_count => l_msg_count
1154: ,x_return_status => l_return_status
1155: ,p_iohv_rec => lp_iohv_rec) ;
1156: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1157: RAISE FND_API.G_EXC_ERROR;
1158: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: END IF;
1161: END IF;

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

1154: ,x_return_status => l_return_status
1155: ,p_iohv_rec => lp_iohv_rec) ;
1156: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1157: RAISE FND_API.G_EXC_ERROR;
1158: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: END IF;
1161: END IF;
1162:

Line 1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1155: ,p_iohv_rec => lp_iohv_rec) ;
1156: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1157: RAISE FND_API.G_EXC_ERROR;
1158: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: END IF;
1161: END IF;
1162:
1163:

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

1172: ,x_msg_data => l_msg_data
1173: ,x_msg_count => l_msg_count
1174: ,x_return_status => l_return_status
1175: ,p_iohv_rec => lp_iohv_rec) ;
1176: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;

Line 1177: RAISE FND_API.G_EXC_ERROR;

1173: ,x_msg_count => l_msg_count
1174: ,x_return_status => l_return_status
1175: ,p_iohv_rec => lp_iohv_rec) ;
1176: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;
1181: END IF;

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

1174: ,x_return_status => l_return_status
1175: ,p_iohv_rec => lp_iohv_rec) ;
1176: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;
1181: END IF;
1182: --Customer post-processing user hook call end

Line 1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1175: ,p_iohv_rec => lp_iohv_rec) ;
1176: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;
1181: END IF;
1182: --Customer post-processing user hook call end
1183: */

Line 1192: WHEN FND_API.G_EXC_ERROR THEN

1188: x_return_status := l_return_status ;
1189:
1190: EXCEPTION
1191:
1192: WHEN FND_API.G_EXC_ERROR THEN
1193: ROLLBACK TO open_int_hst_validate;
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: x_msg_count := l_msg_count ;
1196: x_msg_data := l_msg_data ;

Line 1194: x_return_status := FND_API.G_RET_STS_ERROR;

1190: EXCEPTION
1191:
1192: WHEN FND_API.G_EXC_ERROR THEN
1193: ROLLBACK TO open_int_hst_validate;
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: x_msg_count := l_msg_count ;
1196: x_msg_data := l_msg_data ;
1197: FND_MSG_PUB.count_and_get(
1198: p_count => x_msg_count

Line 1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1196: x_msg_data := l_msg_data ;
1197: FND_MSG_PUB.count_and_get(
1198: p_count => x_msg_count
1199: ,p_data => x_msg_data);
1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1201: ROLLBACK TO open_int_hst_validate;
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1203: x_msg_count := l_msg_count ;
1204: x_msg_data := l_msg_data ;

Line 1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1198: p_count => x_msg_count
1199: ,p_data => x_msg_data);
1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1201: ROLLBACK TO open_int_hst_validate;
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1203: x_msg_count := l_msg_count ;
1204: x_msg_data := l_msg_data ;
1205: FND_MSG_PUB.count_and_get(
1206: p_count => x_msg_count

Line 1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1206: p_count => x_msg_count
1207: ,p_data => x_msg_data);
1208: WHEN OTHERS THEN
1209: ROLLBACK TO open_int_hst_validate;
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: x_msg_count := l_msg_count ;
1212: x_msg_data := l_msg_data ;
1213: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','validate_open_int_hst');
1214: FND_MSG_PUB.count_and_get(

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

1251: ,x_msg_count => l_msg_count
1252: ,x_return_status => l_return_status
1253: ,p_iohv_tbl => lp_iohv_tbl
1254: ,x_iohv_tbl => lx_iohv_tbl) ;
1255: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1256: RAISE FND_API.G_EXC_ERROR;
1257: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1259: END IF;

Line 1256: RAISE FND_API.G_EXC_ERROR;

1252: ,x_return_status => l_return_status
1253: ,p_iohv_tbl => lp_iohv_tbl
1254: ,x_iohv_tbl => lx_iohv_tbl) ;
1255: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1256: RAISE FND_API.G_EXC_ERROR;
1257: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1259: END IF;
1260:

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

1253: ,p_iohv_tbl => lp_iohv_tbl
1254: ,x_iohv_tbl => lx_iohv_tbl) ;
1255: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1256: RAISE FND_API.G_EXC_ERROR;
1257: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1259: END IF;
1260:
1261: --Copy value of OUT NOCOPY variable in the IN record type

Line 1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1254: ,x_iohv_tbl => lx_iohv_tbl) ;
1255: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1256: RAISE FND_API.G_EXC_ERROR;
1257: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1259: END IF;
1260:
1261: --Copy value of OUT NOCOPY variable in the IN record type
1262: lp_iohv_tbl := lx_iohv_tbl;

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

1272: ,x_msg_count => l_msg_count
1273: ,x_return_status => l_return_status
1274: ,p_iohv_tbl => lp_iohv_tbl
1275: ,x_iohv_tbl => lx_iohv_tbl) ;
1276: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1277: RAISE FND_API.G_EXC_ERROR;
1278: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;

Line 1277: RAISE FND_API.G_EXC_ERROR;

1273: ,x_return_status => l_return_status
1274: ,p_iohv_tbl => lp_iohv_tbl
1275: ,x_iohv_tbl => lx_iohv_tbl) ;
1276: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1277: RAISE FND_API.G_EXC_ERROR;
1278: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281:

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

1274: ,p_iohv_tbl => lp_iohv_tbl
1275: ,x_iohv_tbl => lx_iohv_tbl) ;
1276: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1277: RAISE FND_API.G_EXC_ERROR;
1278: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281:
1282: --Copy value of OUT NOCOPY variable in the IN record type

Line 1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1275: ,x_iohv_tbl => lx_iohv_tbl) ;
1276: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1277: RAISE FND_API.G_EXC_ERROR;
1278: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281:
1282: --Copy value of OUT NOCOPY variable in the IN record type
1283: lp_iohv_tbl := lx_iohv_tbl;

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

1292: ,x_msg_count
1293: ,x_msg_data
1294: ,lp_iohv_tbl);
1295:
1296: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1297: RAISE FND_API.G_EXC_ERROR;
1298: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1300: END IF;

Line 1297: RAISE FND_API.G_EXC_ERROR;

1293: ,x_msg_data
1294: ,lp_iohv_tbl);
1295:
1296: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1297: RAISE FND_API.G_EXC_ERROR;
1298: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1300: END IF;
1301:

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

1294: ,lp_iohv_tbl);
1295:
1296: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1297: RAISE FND_API.G_EXC_ERROR;
1298: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1300: END IF;
1301:
1302: --Copy value of OUT NOCOPY variable in the IN record type

Line 1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1295:
1296: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1297: RAISE FND_API.G_EXC_ERROR;
1298: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1300: END IF;
1301:
1302: --Copy value of OUT NOCOPY variable in the IN record type
1303: lp_iohv_tbl := lx_iohv_tbl;

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

1309: ,x_msg_data => l_msg_data
1310: ,x_msg_count => l_msg_count
1311: ,x_return_status => l_return_status
1312: ,p_iohv_tbl => lp_iohv_tbl) ;
1313: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1317: END IF;

Line 1314: RAISE FND_API.G_EXC_ERROR;

1310: ,x_msg_count => l_msg_count
1311: ,x_return_status => l_return_status
1312: ,p_iohv_tbl => lp_iohv_tbl) ;
1313: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1317: END IF;
1318: END IF;

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

1311: ,x_return_status => l_return_status
1312: ,p_iohv_tbl => lp_iohv_tbl) ;
1313: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1317: END IF;
1318: END IF;
1319: --Vertical post-processing user hook call end

Line 1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1312: ,p_iohv_tbl => lp_iohv_tbl) ;
1313: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1317: END IF;
1318: END IF;
1319: --Vertical post-processing user hook call end
1320: --Customer post-processing user hook call start

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

1324: ,x_msg_data => l_msg_data
1325: ,x_msg_count => l_msg_count
1326: ,x_return_status => l_return_status
1327: ,p_iohv_tbl => lp_iohv_tbl) ;
1328: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;

Line 1329: RAISE FND_API.G_EXC_ERROR;

1325: ,x_msg_count => l_msg_count
1326: ,x_return_status => l_return_status
1327: ,p_iohv_tbl => lp_iohv_tbl) ;
1328: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333: END IF;

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

1326: ,x_return_status => l_return_status
1327: ,p_iohv_tbl => lp_iohv_tbl) ;
1328: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333: END IF;
1334:

Line 1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1327: ,p_iohv_tbl => lp_iohv_tbl) ;
1328: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333: END IF;
1334:
1335:

Line 1347: WHEN FND_API.G_EXC_ERROR THEN

1343: x_return_status := l_return_status ;
1344:
1345: EXCEPTION
1346:
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: ROLLBACK TO open_int_hst_validate;
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: x_msg_count := l_msg_count ;
1351: x_msg_data := l_msg_data ;

Line 1349: x_return_status := FND_API.G_RET_STS_ERROR;

1345: EXCEPTION
1346:
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: ROLLBACK TO open_int_hst_validate;
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: x_msg_count := l_msg_count ;
1351: x_msg_data := l_msg_data ;
1352: FND_MSG_PUB.count_and_get(
1353: p_count => x_msg_count

Line 1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1351: x_msg_data := l_msg_data ;
1352: FND_MSG_PUB.count_and_get(
1353: p_count => x_msg_count
1354: ,p_data => x_msg_data);
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1356: ROLLBACK TO open_int_hst_validate;
1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1358: x_msg_count := l_msg_count ;
1359: x_msg_data := l_msg_data ;

Line 1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1353: p_count => x_msg_count
1354: ,p_data => x_msg_data);
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1356: ROLLBACK TO open_int_hst_validate;
1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1358: x_msg_count := l_msg_count ;
1359: x_msg_data := l_msg_data ;
1360: FND_MSG_PUB.count_and_get(
1361: p_count => x_msg_count

Line 1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1361: p_count => x_msg_count
1362: ,p_data => x_msg_data);
1363: WHEN OTHERS THEN
1364: ROLLBACK TO open_int_hst_validate;
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1366: x_msg_count := l_msg_count ;
1367: x_msg_data := l_msg_data ;
1368: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','validate_open_int_hst');
1369: FND_MSG_PUB.count_and_get(