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_EXT_AGNCY_PUB dependencies on FND_API

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

42: ,x_msg_count => l_msg_count
43: ,x_return_status => l_return_status
44: ,p_ieav_rec => lp_ieav_rec
45: ,x_ieav_rec => lx_ieav_rec) ;
46: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
47: RAISE FND_API.G_EXC_ERROR;
48: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;

Line 47: RAISE FND_API.G_EXC_ERROR;

43: ,x_return_status => l_return_status
44: ,p_ieav_rec => lp_ieav_rec
45: ,x_ieav_rec => lx_ieav_rec) ;
46: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
47: RAISE FND_API.G_EXC_ERROR;
48: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:

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

44: ,p_ieav_rec => lp_ieav_rec
45: ,x_ieav_rec => lx_ieav_rec) ;
46: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
47: RAISE FND_API.G_EXC_ERROR;
48: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: --Copy value of OUT record type variable in the IN record type

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

63: ,x_msg_count => l_msg_count
64: ,x_return_status => l_return_status
65: ,p_ieav_rec => lp_ieav_rec
66: ,x_ieav_rec => lx_ieav_rec );
67: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
68: RAISE FND_API.G_EXC_ERROR;
69: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;

Line 68: RAISE FND_API.G_EXC_ERROR;

64: ,x_return_status => l_return_status
65: ,p_ieav_rec => lp_ieav_rec
66: ,x_ieav_rec => lx_ieav_rec );
67: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
68: RAISE FND_API.G_EXC_ERROR;
69: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:

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

65: ,p_ieav_rec => lp_ieav_rec
66: ,x_ieav_rec => lx_ieav_rec );
67: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
68: RAISE FND_API.G_EXC_ERROR;
69: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: --Copy value of OUT variable in the IN record type

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66: ,x_ieav_rec => lx_ieav_rec );
67: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
68: RAISE FND_API.G_EXC_ERROR;
69: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: --Copy value of OUT variable in the IN record type
74: lp_ieav_rec := lx_ieav_rec;

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

85: ,l_msg_data
86: ,lp_ieav_rec
87: ,lx_ieav_rec);
88:
89: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
90: RAISE FND_API.G_EXC_ERROR;
91: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;

Line 90: RAISE FND_API.G_EXC_ERROR;

86: ,lp_ieav_rec
87: ,lx_ieav_rec);
88:
89: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
90: RAISE FND_API.G_EXC_ERROR;
91: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:

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

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

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

102: ,x_msg_data => l_msg_data
103: ,x_msg_count => l_msg_count
104: ,x_return_status => l_return_status
105: ,p_ieav_rec => lp_ieav_rec);
106: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
107: RAISE FND_API.G_EXC_ERROR;
108: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;

Line 107: RAISE FND_API.G_EXC_ERROR;

103: ,x_msg_count => l_msg_count
104: ,x_return_status => l_return_status
105: ,p_ieav_rec => lp_ieav_rec);
106: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
107: RAISE FND_API.G_EXC_ERROR;
108: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111: END IF;

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

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

Line 109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

119: ,x_msg_data => l_msg_data
120: ,x_msg_count => l_msg_count
121: ,x_return_status => l_return_status
122: ,p_ieav_rec => lp_ieav_rec);
123: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;

Line 124: RAISE FND_API.G_EXC_ERROR;

120: ,x_msg_count => l_msg_count
121: ,x_return_status => l_return_status
122: ,p_ieav_rec => lp_ieav_rec);
123: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128: END IF;

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

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

Line 126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 140: WHEN FND_API.G_EXC_ERROR THEN

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

Line 142: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

154: p_count => x_msg_count
155: ,p_data => x_msg_data);
156: WHEN OTHERS THEN
157: ROLLBACK TO ext_agncy_insert;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: x_msg_count := l_msg_count ;
160: x_msg_data := l_msg_data ;
161: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','insert_ext_agncy');
162: FND_MSG_PUB.count_and_get(

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

203: ,x_msg_count => l_msg_count
204: ,x_return_status => l_return_status
205: ,p_ieav_tbl => lp_ieav_tbl
206: ,x_ieav_tbl => lx_ieav_tbl);
207: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;

Line 208: RAISE FND_API.G_EXC_ERROR;

204: ,x_return_status => l_return_status
205: ,p_ieav_tbl => lp_ieav_tbl
206: ,x_ieav_tbl => lx_ieav_tbl);
207: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:

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

205: ,p_ieav_tbl => lp_ieav_tbl
206: ,x_ieav_tbl => lx_ieav_tbl);
207: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: --Copy value of OUT variable in the IN record type

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

222: ,x_msg_count => l_msg_count
223: ,x_return_status => l_return_status
224: ,p_ieav_tbl => lp_ieav_tbl
225: ,x_ieav_tbl => lx_ieav_tbl);
226: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
227: RAISE FND_API.G_EXC_ERROR;
228: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;

Line 227: RAISE FND_API.G_EXC_ERROR;

223: ,x_return_status => l_return_status
224: ,p_ieav_tbl => lp_ieav_tbl
225: ,x_ieav_tbl => lx_ieav_tbl);
226: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
227: RAISE FND_API.G_EXC_ERROR;
228: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231:

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

224: ,p_ieav_tbl => lp_ieav_tbl
225: ,x_ieav_tbl => lx_ieav_tbl);
226: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
227: RAISE FND_API.G_EXC_ERROR;
228: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231:
232: --Copy value of OUT variable in the IN record type

Line 229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

225: ,x_ieav_tbl => lx_ieav_tbl);
226: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
227: RAISE FND_API.G_EXC_ERROR;
228: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231:
232: --Copy value of OUT variable in the IN record type
233: lp_ieav_tbl := lx_ieav_tbl;

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

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

Line 250: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 267: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 283: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 299: WHEN FND_API.G_EXC_ERROR THEN

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

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 344: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 352: WHEN FND_API.G_EXC_ERROR THEN

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

Line 356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 386: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 394: WHEN FND_API.G_EXC_ERROR THEN

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

Line 398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

446: ,x_msg_count => l_msg_count
447: ,x_return_status => l_return_status
448: ,p_ieav_rec => lp_ieav_rec
449: ,x_ieav_rec => lx_ieav_rec) ;
450: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;

Line 451: RAISE FND_API.G_EXC_ERROR;

447: ,x_return_status => l_return_status
448: ,p_ieav_rec => lp_ieav_rec
449: ,x_ieav_rec => lx_ieav_rec) ;
450: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:

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

448: ,p_ieav_rec => lp_ieav_rec
449: ,x_ieav_rec => lx_ieav_rec) ;
450: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: --Copy value of OUT variable in the IN record type

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

466: ,x_msg_count => l_msg_count
467: ,x_return_status => l_return_status
468: ,p_ieav_rec => lp_ieav_rec
469: ,x_ieav_rec => lx_ieav_rec) ;
470: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
471: RAISE FND_API.G_EXC_ERROR;
472: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;

Line 471: RAISE FND_API.G_EXC_ERROR;

467: ,x_return_status => l_return_status
468: ,p_ieav_rec => lp_ieav_rec
469: ,x_ieav_rec => lx_ieav_rec) ;
470: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
471: RAISE FND_API.G_EXC_ERROR;
472: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:

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

468: ,p_ieav_rec => lp_ieav_rec
469: ,x_ieav_rec => lx_ieav_rec) ;
470: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
471: RAISE FND_API.G_EXC_ERROR;
472: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476: --Copy value of OUT variable in the IN record type

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: ,x_ieav_rec => lx_ieav_rec) ;
470: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
471: RAISE FND_API.G_EXC_ERROR;
472: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476: --Copy value of OUT variable in the IN record type
477: lp_ieav_rec := lx_ieav_rec;

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

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

Line 494: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 511: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 528: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 544: WHEN FND_API.G_EXC_ERROR THEN

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

Line 546: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

558: p_count => x_msg_count
559: ,p_data => x_msg_data);
560: WHEN OTHERS THEN
561: ROLLBACK TO ext_agncy_update;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: x_msg_count := l_msg_count ;
564: x_msg_data := l_msg_data ;
565: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','update_ext_agncy');
566: 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_ieav_tbl => lp_ieav_tbl
610: ,x_ieav_tbl => lx_ieav_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_ieav_tbl => lp_ieav_tbl
610: ,x_ieav_tbl => lx_ieav_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_ieav_tbl => lp_ieav_tbl
610: ,x_ieav_tbl => lx_ieav_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 variable in the IN record type

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610: ,x_ieav_tbl => lx_ieav_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 variable in the IN record type
618: lp_ieav_tbl := lx_ieav_tbl;

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

627: ,x_msg_count => l_msg_count
628: ,x_return_status => l_return_status
629: ,p_ieav_tbl => lp_ieav_tbl
630: ,x_ieav_tbl => lx_ieav_tbl) ;
631: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;

Line 632: RAISE FND_API.G_EXC_ERROR;

628: ,x_return_status => l_return_status
629: ,p_ieav_tbl => lp_ieav_tbl
630: ,x_ieav_tbl => lx_ieav_tbl) ;
631: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:

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

629: ,p_ieav_tbl => lp_ieav_tbl
630: ,x_ieav_tbl => lx_ieav_tbl) ;
631: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:
637: --Copy value of OUT variable in the IN record type

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: ,x_ieav_tbl => lx_ieav_tbl) ;
631: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
632: RAISE FND_API.G_EXC_ERROR;
633: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636:
637: --Copy value of OUT variable in the IN record type
638: lp_ieav_tbl := lx_ieav_tbl;

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

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

Line 654: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 671: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 687: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 703: WHEN FND_API.G_EXC_ERROR THEN

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

Line 705: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

717: p_count => x_msg_count
718: ,p_data => x_msg_data);
719: WHEN OTHERS THEN
720: ROLLBACK TO ext_agncy_update;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: x_msg_count := l_msg_count ;
723: x_msg_data := l_msg_data ;
724: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','update_ext_agncy');
725: FND_MSG_PUB.count_and_get(

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

766: ,x_msg_count => l_msg_count
767: ,x_return_status => l_return_status
768: ,p_ieav_rec => lp_ieav_rec
769: ,x_ieav_rec => lx_ieav_rec) ;
770: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
771: RAISE FND_API.G_EXC_ERROR;
772: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;

Line 771: RAISE FND_API.G_EXC_ERROR;

767: ,x_return_status => l_return_status
768: ,p_ieav_rec => lp_ieav_rec
769: ,x_ieav_rec => lx_ieav_rec) ;
770: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
771: RAISE FND_API.G_EXC_ERROR;
772: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;
775:

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

768: ,p_ieav_rec => lp_ieav_rec
769: ,x_ieav_rec => lx_ieav_rec) ;
770: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
771: RAISE FND_API.G_EXC_ERROR;
772: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;
775:
776: --Copy value of OUT variable in the IN record type

Line 773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

769: ,x_ieav_rec => lx_ieav_rec) ;
770: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
771: RAISE FND_API.G_EXC_ERROR;
772: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;
775:
776: --Copy value of OUT variable in the IN record type
777: lp_ieav_rec := lx_ieav_rec;

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

786: ,x_msg_count => l_msg_count
787: ,x_return_status => l_return_status
788: ,p_ieav_rec => lp_ieav_rec
789: ,x_ieav_rec => lx_ieav_rec) ;
790: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
791: RAISE FND_API.G_EXC_ERROR;
792: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;

Line 791: RAISE FND_API.G_EXC_ERROR;

787: ,x_return_status => l_return_status
788: ,p_ieav_rec => lp_ieav_rec
789: ,x_ieav_rec => lx_ieav_rec) ;
790: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
791: RAISE FND_API.G_EXC_ERROR;
792: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795:

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

788: ,p_ieav_rec => lp_ieav_rec
789: ,x_ieav_rec => lx_ieav_rec) ;
790: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
791: RAISE FND_API.G_EXC_ERROR;
792: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795:
796: --Copy value of OUT variable in the IN record type

Line 793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

789: ,x_ieav_rec => lx_ieav_rec) ;
790: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
791: RAISE FND_API.G_EXC_ERROR;
792: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795:
796: --Copy value of OUT variable in the IN record type
797: lp_ieav_rec := lx_ieav_rec;

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

808: ,l_msg_count
809: ,l_msg_data
810: ,lp_ieav_rec);
811:
812: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
813: RAISE FND_API.G_EXC_ERROR;
814: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;

Line 813: RAISE FND_API.G_EXC_ERROR;

809: ,l_msg_data
810: ,lp_ieav_rec);
811:
812: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
813: RAISE FND_API.G_EXC_ERROR;
814: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817:

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

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

Line 815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

811:
812: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
813: RAISE FND_API.G_EXC_ERROR;
814: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817:
818:
819: --START FOR BUG 4741980

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

824: ,x_msg_data => l_msg_data
825: ,x_msg_count => l_msg_count
826: ,x_return_status => l_return_status
827: ,p_ieav_rec => lp_ieav_rec) ;
828: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
829: RAISE FND_API.G_EXC_ERROR;
830: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;

Line 829: RAISE FND_API.G_EXC_ERROR;

825: ,x_msg_count => l_msg_count
826: ,x_return_status => l_return_status
827: ,p_ieav_rec => lp_ieav_rec) ;
828: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
829: RAISE FND_API.G_EXC_ERROR;
830: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833: END IF;

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

826: ,x_return_status => l_return_status
827: ,p_ieav_rec => lp_ieav_rec) ;
828: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
829: RAISE FND_API.G_EXC_ERROR;
830: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833: END IF;
834:

Line 831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

839: ,x_msg_data => l_msg_data
840: ,x_msg_count => l_msg_count
841: ,x_return_status => l_return_status
842: ,p_ieav_rec => lp_ieav_rec) ;
843: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
844: RAISE FND_API.G_EXC_ERROR;
845: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;

Line 844: RAISE FND_API.G_EXC_ERROR;

840: ,x_msg_count => l_msg_count
841: ,x_return_status => l_return_status
842: ,p_ieav_rec => lp_ieav_rec) ;
843: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
844: RAISE FND_API.G_EXC_ERROR;
845: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848: END IF;

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

841: ,x_return_status => l_return_status
842: ,p_ieav_rec => lp_ieav_rec) ;
843: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
844: RAISE FND_API.G_EXC_ERROR;
845: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848: END IF;
849:

Line 846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

842: ,p_ieav_rec => lp_ieav_rec) ;
843: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
844: RAISE FND_API.G_EXC_ERROR;
845: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848: END IF;
849:
850: --END FOR BUG 4741980

Line 859: WHEN FND_API.G_EXC_ERROR THEN

855: x_return_status := l_return_status ;
856:
857: EXCEPTION
858:
859: WHEN FND_API.G_EXC_ERROR THEN
860: ROLLBACK TO ext_agncy_delete_rec;
861: x_return_status := FND_API.G_RET_STS_ERROR;
862: x_msg_count := l_msg_count ;
863: x_msg_data := l_msg_data ;

Line 861: x_return_status := FND_API.G_RET_STS_ERROR;

857: EXCEPTION
858:
859: WHEN FND_API.G_EXC_ERROR THEN
860: ROLLBACK TO ext_agncy_delete_rec;
861: x_return_status := FND_API.G_RET_STS_ERROR;
862: x_msg_count := l_msg_count ;
863: x_msg_data := l_msg_data ;
864: FND_MSG_PUB.count_and_get(
865: p_count => x_msg_count

Line 867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

863: x_msg_data := l_msg_data ;
864: FND_MSG_PUB.count_and_get(
865: p_count => x_msg_count
866: ,p_data => x_msg_data);
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: ROLLBACK TO ext_agncy_delete_rec;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: x_msg_count := l_msg_count ;
871: x_msg_data := l_msg_data ;

Line 869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

873: p_count => x_msg_count
874: ,p_data => x_msg_data);
875: WHEN OTHERS THEN
876: ROLLBACK TO ext_agncy_delete_rec;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: x_msg_count := l_msg_count ;
879: x_msg_data := l_msg_data ;
880: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','delete_ext_agncy');
881: FND_MSG_PUB.count_and_get(

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

921: ,x_msg_count => l_msg_count
922: ,x_return_status => l_return_status
923: ,p_ieav_tbl => lp_ieav_tbl
924: ,x_ieav_tbl => lx_ieav_tbl) ;
925: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
926: RAISE FND_API.G_EXC_ERROR;
927: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;

Line 926: RAISE FND_API.G_EXC_ERROR;

922: ,x_return_status => l_return_status
923: ,p_ieav_tbl => lp_ieav_tbl
924: ,x_ieav_tbl => lx_ieav_tbl) ;
925: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
926: RAISE FND_API.G_EXC_ERROR;
927: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;
930:

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

923: ,p_ieav_tbl => lp_ieav_tbl
924: ,x_ieav_tbl => lx_ieav_tbl) ;
925: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
926: RAISE FND_API.G_EXC_ERROR;
927: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;
930:
931: --Copy value of OUT variable in the IN record type

Line 928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

924: ,x_ieav_tbl => lx_ieav_tbl) ;
925: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
926: RAISE FND_API.G_EXC_ERROR;
927: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;
930:
931: --Copy value of OUT variable in the IN record type
932: lp_ieav_tbl := lx_ieav_tbl;

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

943: ,x_msg_count => l_msg_count
944: ,x_return_status => l_return_status
945: ,p_ieav_tbl => lp_ieav_tbl
946: ,x_ieav_tbl => lx_ieav_tbl) ;
947: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
948: RAISE FND_API.G_EXC_ERROR;
949: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: END IF;

Line 948: RAISE FND_API.G_EXC_ERROR;

944: ,x_return_status => l_return_status
945: ,p_ieav_tbl => lp_ieav_tbl
946: ,x_ieav_tbl => lx_ieav_tbl) ;
947: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
948: RAISE FND_API.G_EXC_ERROR;
949: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: END IF;
952:

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

945: ,p_ieav_tbl => lp_ieav_tbl
946: ,x_ieav_tbl => lx_ieav_tbl) ;
947: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
948: RAISE FND_API.G_EXC_ERROR;
949: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: END IF;
952:
953: --Copy value of OUT variable in the IN record type

Line 950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

946: ,x_ieav_tbl => lx_ieav_tbl) ;
947: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
948: RAISE FND_API.G_EXC_ERROR;
949: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: END IF;
952:
953: --Copy value of OUT variable in the IN record type
954: lp_ieav_tbl := lx_ieav_tbl;

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

976: EXIT WHEN (i = lp_ieav_tbl.LAST);
977: i := p_ieav_tbl.NEXT(i);
978: END LOOP;
979: END IF;
980: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
981: RAISE FND_API.G_EXC_ERROR;
982: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: END IF;

Line 981: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

993: ,x_msg_data => l_msg_data
994: ,x_msg_count => l_msg_count
995: ,x_return_status => l_return_status
996: ,p_ieav_tbl => lp_ieav_tbl) ;
997: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END IF;

Line 998: RAISE FND_API.G_EXC_ERROR;

994: ,x_msg_count => l_msg_count
995: ,x_return_status => l_return_status
996: ,p_ieav_tbl => lp_ieav_tbl) ;
997: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END IF;
1002: END IF;

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

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

Line 1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

1010: ,x_msg_data => l_msg_data
1011: ,x_msg_count => l_msg_count
1012: ,x_return_status => l_return_status
1013: ,p_ieav_tbl => lp_ieav_tbl) ;
1014: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1015: RAISE FND_API.G_EXC_ERROR;
1016: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1018: END IF;

Line 1015: RAISE FND_API.G_EXC_ERROR;

1011: ,x_msg_count => l_msg_count
1012: ,x_return_status => l_return_status
1013: ,p_ieav_tbl => lp_ieav_tbl) ;
1014: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1015: RAISE FND_API.G_EXC_ERROR;
1016: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1018: END IF;
1019: END IF;

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

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

Line 1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1030: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1032: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1044: p_count => x_msg_count
1045: ,p_data => x_msg_data);
1046: WHEN OTHERS THEN
1047: ROLLBACK TO ext_agncy_delete_tbl;
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: x_msg_count := l_msg_count ;
1050: x_msg_data := l_msg_data ;
1051: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','delete_ext_agncy');
1052: FND_MSG_PUB.count_and_get(

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

1091: ,x_msg_count => l_msg_count
1092: ,x_return_status => l_return_status
1093: ,p_ieav_rec => lp_ieav_rec
1094: ,x_ieav_rec => lx_ieav_rec) ;
1095: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: END IF;

Line 1096: RAISE FND_API.G_EXC_ERROR;

1092: ,x_return_status => l_return_status
1093: ,p_ieav_rec => lp_ieav_rec
1094: ,x_ieav_rec => lx_ieav_rec) ;
1095: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: END IF;
1100:

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

1093: ,p_ieav_rec => lp_ieav_rec
1094: ,x_ieav_rec => lx_ieav_rec) ;
1095: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: END IF;
1100:
1101: --Copy value of OUT variable in the IN record type

Line 1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

1113: ,x_msg_count => l_msg_count
1114: ,x_return_status => l_return_status
1115: ,p_ieav_rec => lp_ieav_rec
1116: ,x_ieav_rec => lx_ieav_rec) ;
1117: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1121: END IF;

Line 1118: RAISE FND_API.G_EXC_ERROR;

1114: ,x_return_status => l_return_status
1115: ,p_ieav_rec => lp_ieav_rec
1116: ,x_ieav_rec => lx_ieav_rec) ;
1117: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1121: END IF;
1122:

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

1115: ,p_ieav_rec => lp_ieav_rec
1116: ,x_ieav_rec => lx_ieav_rec) ;
1117: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1121: END IF;
1122:
1123: --Copy value of OUT variable in the IN record type

Line 1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1141: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1139:
1140: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1141: RAISE FND_API.G_EXC_ERROR;
1142: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: END IF;
1145:
1146: --Copy value of OUT variable in the IN record type
1147: lp_ieav_rec := lx_ieav_rec;

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

1154: ,x_msg_data => l_msg_data
1155: ,x_msg_count => l_msg_count
1156: ,x_return_status => l_return_status
1157: ,p_ieav_rec => lp_ieav_rec) ;
1158: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1159: RAISE FND_API.G_EXC_ERROR;
1160: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1162: END IF;

Line 1159: RAISE FND_API.G_EXC_ERROR;

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

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

1156: ,x_return_status => l_return_status
1157: ,p_ieav_rec => lp_ieav_rec) ;
1158: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1159: RAISE FND_API.G_EXC_ERROR;
1160: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1162: END IF;
1163: END IF;
1164:

Line 1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1157: ,p_ieav_rec => lp_ieav_rec) ;
1158: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1159: RAISE FND_API.G_EXC_ERROR;
1160: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1162: END IF;
1163: END IF;
1164:
1165:

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

1174: ,x_msg_data => l_msg_data
1175: ,x_msg_count => l_msg_count
1176: ,x_return_status => l_return_status
1177: ,p_ieav_rec => lp_ieav_rec) ;
1178: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;

Line 1179: RAISE FND_API.G_EXC_ERROR;

1175: ,x_msg_count => l_msg_count
1176: ,x_return_status => l_return_status
1177: ,p_ieav_rec => lp_ieav_rec) ;
1178: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183: END IF;

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

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

Line 1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1194: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1196: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1208: p_count => x_msg_count
1209: ,p_data => x_msg_data);
1210: WHEN OTHERS THEN
1211: ROLLBACK TO ext_agncy_validate;
1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1213: x_msg_count := l_msg_count ;
1214: x_msg_data := l_msg_data ;
1215: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','validate_ext_agncy');
1216: FND_MSG_PUB.count_and_get(

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

1254: ,x_msg_count => l_msg_count
1255: ,x_return_status => l_return_status
1256: ,p_ieav_tbl => lp_ieav_tbl
1257: ,x_ieav_tbl => lx_ieav_tbl) ;
1258: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1259: RAISE FND_API.G_EXC_ERROR;
1260: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: END IF;

Line 1259: RAISE FND_API.G_EXC_ERROR;

1255: ,x_return_status => l_return_status
1256: ,p_ieav_tbl => lp_ieav_tbl
1257: ,x_ieav_tbl => lx_ieav_tbl) ;
1258: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1259: RAISE FND_API.G_EXC_ERROR;
1260: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: END IF;
1263:

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

1256: ,p_ieav_tbl => lp_ieav_tbl
1257: ,x_ieav_tbl => lx_ieav_tbl) ;
1258: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1259: RAISE FND_API.G_EXC_ERROR;
1260: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: END IF;
1263:
1264: --Copy value of OUT variable in the IN record type

Line 1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1257: ,x_ieav_tbl => lx_ieav_tbl) ;
1258: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1259: RAISE FND_API.G_EXC_ERROR;
1260: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: END IF;
1263:
1264: --Copy value of OUT variable in the IN record type
1265: lp_ieav_tbl := lx_ieav_tbl;

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

1275: ,x_msg_count => l_msg_count
1276: ,x_return_status => l_return_status
1277: ,p_ieav_tbl => lp_ieav_tbl
1278: ,x_ieav_tbl => lx_ieav_tbl) ;
1279: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1280: RAISE FND_API.G_EXC_ERROR;
1281: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;

Line 1280: RAISE FND_API.G_EXC_ERROR;

1276: ,x_return_status => l_return_status
1277: ,p_ieav_tbl => lp_ieav_tbl
1278: ,x_ieav_tbl => lx_ieav_tbl) ;
1279: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1280: RAISE FND_API.G_EXC_ERROR;
1281: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;
1284:

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

1277: ,p_ieav_tbl => lp_ieav_tbl
1278: ,x_ieav_tbl => lx_ieav_tbl) ;
1279: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1280: RAISE FND_API.G_EXC_ERROR;
1281: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;
1284:
1285: --Copy value of OUT variable in the IN record type

Line 1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1278: ,x_ieav_tbl => lx_ieav_tbl) ;
1279: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1280: RAISE FND_API.G_EXC_ERROR;
1281: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;
1284:
1285: --Copy value of OUT variable in the IN record type
1286: lp_ieav_tbl := lx_ieav_tbl;

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

1297: ,x_msg_count
1298: ,x_msg_data
1299: ,lp_ieav_tbl);
1300:
1301: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;

Line 1302: RAISE FND_API.G_EXC_ERROR;

1298: ,x_msg_data
1299: ,lp_ieav_tbl);
1300:
1301: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;
1306:

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

1299: ,lp_ieav_tbl);
1300:
1301: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;
1306:
1307: --Copy value of OUT variable in the IN record type

Line 1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1300:
1301: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;
1306:
1307: --Copy value of OUT variable in the IN record type
1308: lp_ieav_tbl := lx_ieav_tbl;

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

1314: ,x_msg_data => l_msg_data
1315: ,x_msg_count => l_msg_count
1316: ,x_return_status => l_return_status
1317: ,p_ieav_tbl => lp_ieav_tbl) ;
1318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1322: END IF;

Line 1319: RAISE FND_API.G_EXC_ERROR;

1315: ,x_msg_count => l_msg_count
1316: ,x_return_status => l_return_status
1317: ,p_ieav_tbl => lp_ieav_tbl) ;
1318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1322: END IF;
1323: END IF;

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

1316: ,x_return_status => l_return_status
1317: ,p_ieav_tbl => lp_ieav_tbl) ;
1318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1322: END IF;
1323: END IF;
1324: --Vertical post-processing user hook call end

Line 1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1317: ,p_ieav_tbl => lp_ieav_tbl) ;
1318: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1322: END IF;
1323: END IF;
1324: --Vertical post-processing user hook call end
1325: --Customer post-processing user hook call start

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

1329: ,x_msg_data => l_msg_data
1330: ,x_msg_count => l_msg_count
1331: ,x_return_status => l_return_status
1332: ,p_ieav_tbl => lp_ieav_tbl) ;
1333: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1334: RAISE FND_API.G_EXC_ERROR;
1335: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;

Line 1334: RAISE FND_API.G_EXC_ERROR;

1330: ,x_msg_count => l_msg_count
1331: ,x_return_status => l_return_status
1332: ,p_ieav_tbl => lp_ieav_tbl) ;
1333: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1334: RAISE FND_API.G_EXC_ERROR;
1335: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338: END IF;

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

1331: ,x_return_status => l_return_status
1332: ,p_ieav_tbl => lp_ieav_tbl) ;
1333: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1334: RAISE FND_API.G_EXC_ERROR;
1335: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338: END IF;
1339:

Line 1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1332: ,p_ieav_tbl => lp_ieav_tbl) ;
1333: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1334: RAISE FND_API.G_EXC_ERROR;
1335: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338: END IF;
1339:
1340: */

Line 1352: WHEN FND_API.G_EXC_ERROR THEN

1348: x_return_status := l_return_status ;
1349:
1350: EXCEPTION
1351:
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: ROLLBACK TO ext_agncy_validate;
1354: x_return_status := FND_API.G_RET_STS_ERROR;
1355: x_msg_count := l_msg_count ;
1356: x_msg_data := l_msg_data ;

Line 1354: x_return_status := FND_API.G_RET_STS_ERROR;

1350: EXCEPTION
1351:
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: ROLLBACK TO ext_agncy_validate;
1354: x_return_status := FND_API.G_RET_STS_ERROR;
1355: x_msg_count := l_msg_count ;
1356: x_msg_data := l_msg_data ;
1357: FND_MSG_PUB.count_and_get(
1358: p_count => x_msg_count

Line 1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1356: x_msg_data := l_msg_data ;
1357: FND_MSG_PUB.count_and_get(
1358: p_count => x_msg_count
1359: ,p_data => x_msg_data);
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: ROLLBACK TO ext_agncy_validate;
1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1363: x_msg_count := l_msg_count ;
1364: x_msg_data := l_msg_data ;

Line 1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1358: p_count => x_msg_count
1359: ,p_data => x_msg_data);
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: ROLLBACK TO ext_agncy_validate;
1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1363: x_msg_count := l_msg_count ;
1364: x_msg_data := l_msg_data ;
1365: FND_MSG_PUB.count_and_get(
1366: p_count => x_msg_count

Line 1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1366: p_count => x_msg_count
1367: ,p_data => x_msg_data);
1368: WHEN OTHERS THEN
1369: ROLLBACK TO ext_agncy_validate;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: x_msg_count := l_msg_count ;
1372: x_msg_data := l_msg_data ;
1373: FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','validate_ext_agncy');
1374: FND_MSG_PUB.count_and_get(