APPS.IEX_REPOS_OBJECTS_PUB dependencies on FND_API

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

41: ,x_msg_count => l_msg_count
42: ,x_return_status => l_return_status
43: ,p_repv_rec => lp_repv_rec
44: ,x_repv_rec => lx_repv_rec) ;
45: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
46: RAISE FND_API.G_EXC_ERROR;
47: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: END IF;

Line 46: RAISE FND_API.G_EXC_ERROR;

42: ,x_return_status => l_return_status
43: ,p_repv_rec => lp_repv_rec
44: ,x_repv_rec => lx_repv_rec) ;
45: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
46: RAISE FND_API.G_EXC_ERROR;
47: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: END IF;
50:

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

43: ,p_repv_rec => lp_repv_rec
44: ,x_repv_rec => lx_repv_rec) ;
45: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
46: RAISE FND_API.G_EXC_ERROR;
47: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: END IF;
50:
51: --Copy value of OUT record type variable in the IN record type

Line 48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

64: ,x_msg_count => l_msg_count
65: ,x_return_status => l_return_status
66: ,p_repv_rec => lp_repv_rec
67: ,x_repv_rec => lx_repv_rec );
68: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
69: RAISE FND_API.G_EXC_ERROR;
70: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;

Line 69: RAISE FND_API.G_EXC_ERROR;

65: ,x_return_status => l_return_status
66: ,p_repv_rec => lp_repv_rec
67: ,x_repv_rec => lx_repv_rec );
68: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
69: RAISE FND_API.G_EXC_ERROR;
70: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:

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

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

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

85: ,l_msg_data
86: ,lp_repv_rec
87: ,lx_repv_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_repv_rec
87: ,lx_repv_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_repv_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_repv_rec := lx_repv_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_repv_rec => lp_repv_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_repv_rec => lp_repv_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_repv_rec => lp_repv_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_repv_rec => lp_repv_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_repv_rec => lp_repv_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_repv_rec => lp_repv_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_repv_rec => lp_repv_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_repv_rec => lp_repv_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 repos_objects_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 repos_objects_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 repos_objects_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 repos_objects_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 repos_objects_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_REPOS_OBJECTS_PUB','insert_repos_objects');
162: FND_MSG_PUB.count_and_get(

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

202: ,x_msg_count => l_msg_count
203: ,x_return_status => l_return_status
204: ,p_repv_tbl => lp_repv_tbl
205: ,x_repv_tbl => lx_repv_tbl);
206: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;

Line 207: RAISE FND_API.G_EXC_ERROR;

203: ,x_return_status => l_return_status
204: ,p_repv_tbl => lp_repv_tbl
205: ,x_repv_tbl => lx_repv_tbl);
206: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:

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

204: ,p_repv_tbl => lp_repv_tbl
205: ,x_repv_tbl => lx_repv_tbl);
206: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: --Copy value of OUT variable in the IN record type

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

223: ,x_msg_count => l_msg_count
224: ,x_return_status => l_return_status
225: ,p_repv_tbl => lp_repv_tbl
226: ,x_repv_tbl => lx_repv_tbl);
227: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
228: RAISE FND_API.G_EXC_ERROR;
229: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: END IF;

Line 228: RAISE FND_API.G_EXC_ERROR;

224: ,x_return_status => l_return_status
225: ,p_repv_tbl => lp_repv_tbl
226: ,x_repv_tbl => lx_repv_tbl);
227: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
228: RAISE FND_API.G_EXC_ERROR;
229: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: END IF;
232:

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

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

Line 230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 249: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 266: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 282: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 298: WHEN FND_API.G_EXC_ERROR THEN

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

Line 300: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 343: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 351: WHEN FND_API.G_EXC_ERROR THEN

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

Line 355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 385: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 393: WHEN FND_API.G_EXC_ERROR THEN

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

Line 397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

445: ,x_msg_count => l_msg_count
446: ,x_return_status => l_return_status
447: ,p_repv_rec => lp_repv_rec
448: ,x_repv_rec => lx_repv_rec) ;
449: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;

Line 450: RAISE FND_API.G_EXC_ERROR;

446: ,x_return_status => l_return_status
447: ,p_repv_rec => lp_repv_rec
448: ,x_repv_rec => lx_repv_rec) ;
449: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:

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

447: ,p_repv_rec => lp_repv_rec
448: ,x_repv_rec => lx_repv_rec) ;
449: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:
455: --Copy value of OUT variable in the IN record type

Line 452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

467: ,x_msg_count => l_msg_count
468: ,x_return_status => l_return_status
469: ,p_repv_rec => lp_repv_rec
470: ,x_repv_rec => lx_repv_rec) ;
471: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
472: RAISE FND_API.G_EXC_ERROR;
473: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;

Line 472: RAISE FND_API.G_EXC_ERROR;

468: ,x_return_status => l_return_status
469: ,p_repv_rec => lp_repv_rec
470: ,x_repv_rec => lx_repv_rec) ;
471: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
472: RAISE FND_API.G_EXC_ERROR;
473: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:

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

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

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 493: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 510: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 527: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 543: WHEN FND_API.G_EXC_ERROR THEN

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

Line 545: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

557: p_count => x_msg_count
558: ,p_data => x_msg_data);
559: WHEN OTHERS THEN
560: ROLLBACK TO repos_objects_update;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: x_msg_count := l_msg_count ;
563: x_msg_data := l_msg_data ;
564: FND_MSG_PUB.ADD_EXC_MSG('IEX_REPOS_OBJECTS_PUB','update_repos_objects');
565: FND_MSG_PUB.count_and_get(

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

605: ,x_msg_count => l_msg_count
606: ,x_return_status => l_return_status
607: ,p_repv_tbl => lp_repv_tbl
608: ,x_repv_tbl => lx_repv_tbl) ;
609: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
610: RAISE FND_API.G_EXC_ERROR;
611: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;

Line 610: RAISE FND_API.G_EXC_ERROR;

606: ,x_return_status => l_return_status
607: ,p_repv_tbl => lp_repv_tbl
608: ,x_repv_tbl => lx_repv_tbl) ;
609: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
610: RAISE FND_API.G_EXC_ERROR;
611: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614:

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

607: ,p_repv_tbl => lp_repv_tbl
608: ,x_repv_tbl => lx_repv_tbl) ;
609: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
610: RAISE FND_API.G_EXC_ERROR;
611: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614:
615: --Copy value of OUT variable in the IN record type

Line 612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

608: ,x_repv_tbl => lx_repv_tbl) ;
609: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
610: RAISE FND_API.G_EXC_ERROR;
611: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614:
615: --Copy value of OUT variable in the IN record type
616: lp_repv_tbl := lx_repv_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_repv_tbl => lp_repv_tbl
630: ,x_repv_tbl => lx_repv_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_repv_tbl => lp_repv_tbl
630: ,x_repv_tbl => lx_repv_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_repv_tbl => lp_repv_tbl
630: ,x_repv_tbl => lx_repv_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_repv_tbl => lx_repv_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_repv_tbl := lx_repv_tbl;

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

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

Line 653: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 670: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 686: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 702: WHEN FND_API.G_EXC_ERROR THEN

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

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

764: ,x_msg_count => l_msg_count
765: ,x_return_status => l_return_status
766: ,p_repv_rec => lp_repv_rec
767: ,x_repv_rec => lx_repv_rec) ;
768: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;

Line 769: RAISE FND_API.G_EXC_ERROR;

765: ,x_return_status => l_return_status
766: ,p_repv_rec => lp_repv_rec
767: ,x_repv_rec => lx_repv_rec) ;
768: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773:

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

766: ,p_repv_rec => lp_repv_rec
767: ,x_repv_rec => lx_repv_rec) ;
768: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773:
774: --Copy value of OUT variable in the IN record type

Line 771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

767: ,x_repv_rec => lx_repv_rec) ;
768: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773:
774: --Copy value of OUT variable in the IN record type
775: lp_repv_rec := lx_repv_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_repv_rec => lp_repv_rec
789: ,x_repv_rec => lx_repv_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_repv_rec => lp_repv_rec
789: ,x_repv_rec => lx_repv_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_repv_rec => lp_repv_rec
789: ,x_repv_rec => lx_repv_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_repv_rec => lx_repv_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_repv_rec := lx_repv_rec;

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

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

Line 812: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

810:
811: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
812: RAISE FND_API.G_EXC_ERROR;
813: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816:
817:
818: --Vertical post-processing user hook call start

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

822: ,x_msg_data => l_msg_data
823: ,x_msg_count => l_msg_count
824: ,x_return_status => l_return_status
825: ,p_repv_rec => lp_repv_rec) ;
826: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
827: RAISE FND_API.G_EXC_ERROR;
828: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
830: END IF;

Line 827: RAISE FND_API.G_EXC_ERROR;

823: ,x_msg_count => l_msg_count
824: ,x_return_status => l_return_status
825: ,p_repv_rec => lp_repv_rec) ;
826: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
827: RAISE FND_API.G_EXC_ERROR;
828: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
830: END IF;
831: END IF;

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

824: ,x_return_status => l_return_status
825: ,p_repv_rec => lp_repv_rec) ;
826: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
827: RAISE FND_API.G_EXC_ERROR;
828: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
830: END IF;
831: END IF;
832: --Vertical post-processing user hook call end

Line 829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

825: ,p_repv_rec => lp_repv_rec) ;
826: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
827: RAISE FND_API.G_EXC_ERROR;
828: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
830: END IF;
831: END IF;
832: --Vertical post-processing user hook call end
833:

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_repv_rec => lp_repv_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_repv_rec => lp_repv_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_repv_rec => lp_repv_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: --Customer post-processing user hook call end

Line 846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

842: ,p_repv_rec => lp_repv_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: --Customer post-processing user hook call end
850:

Line 858: WHEN FND_API.G_EXC_ERROR THEN

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

Line 860: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

919: ,x_msg_count => l_msg_count
920: ,x_return_status => l_return_status
921: ,p_repv_tbl => lp_repv_tbl
922: ,x_repv_tbl => lx_repv_tbl) ;
923: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
924: RAISE FND_API.G_EXC_ERROR;
925: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;

Line 924: RAISE FND_API.G_EXC_ERROR;

920: ,x_return_status => l_return_status
921: ,p_repv_tbl => lp_repv_tbl
922: ,x_repv_tbl => lx_repv_tbl) ;
923: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
924: RAISE FND_API.G_EXC_ERROR;
925: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;
928:

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

921: ,p_repv_tbl => lp_repv_tbl
922: ,x_repv_tbl => lx_repv_tbl) ;
923: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
924: RAISE FND_API.G_EXC_ERROR;
925: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;
928:
929: --Copy value of OUT variable in the IN record type

Line 926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

941: ,x_msg_count => l_msg_count
942: ,x_return_status => l_return_status
943: ,p_repv_tbl => lp_repv_tbl
944: ,x_repv_tbl => lx_repv_tbl) ;
945: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
946: RAISE FND_API.G_EXC_ERROR;
947: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END IF;

Line 946: RAISE FND_API.G_EXC_ERROR;

942: ,x_return_status => l_return_status
943: ,p_repv_tbl => lp_repv_tbl
944: ,x_repv_tbl => lx_repv_tbl) ;
945: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
946: RAISE FND_API.G_EXC_ERROR;
947: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END IF;
950:

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

943: ,p_repv_tbl => lp_repv_tbl
944: ,x_repv_tbl => lx_repv_tbl) ;
945: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
946: RAISE FND_API.G_EXC_ERROR;
947: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END IF;
950:
951: --Copy value of OUT variable in the IN record type

Line 948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

971: EXIT WHEN (i = lp_repv_tbl.LAST);
972: i := p_repv_tbl.NEXT(i);
973: END LOOP;
974: END IF;
975: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
976: RAISE FND_API.G_EXC_ERROR;
977: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
979: END IF;

Line 976: RAISE FND_API.G_EXC_ERROR;

972: i := p_repv_tbl.NEXT(i);
973: END LOOP;
974: END IF;
975: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
976: RAISE FND_API.G_EXC_ERROR;
977: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
979: END IF;
980:

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

973: END LOOP;
974: END IF;
975: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
976: RAISE FND_API.G_EXC_ERROR;
977: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
979: END IF;
980:
981: END;

Line 978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

974: END IF;
975: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
976: RAISE FND_API.G_EXC_ERROR;
977: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
979: END IF;
980:
981: END;
982:

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

988: ,x_msg_data => l_msg_data
989: ,x_msg_count => l_msg_count
990: ,x_return_status => l_return_status
991: ,p_repv_tbl => lp_repv_tbl) ;
992: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
993: RAISE FND_API.G_EXC_ERROR;
994: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END IF;

Line 993: RAISE FND_API.G_EXC_ERROR;

989: ,x_msg_count => l_msg_count
990: ,x_return_status => l_return_status
991: ,p_repv_tbl => lp_repv_tbl) ;
992: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
993: RAISE FND_API.G_EXC_ERROR;
994: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END IF;
997: END IF;

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

990: ,x_return_status => l_return_status
991: ,p_repv_tbl => lp_repv_tbl) ;
992: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
993: RAISE FND_API.G_EXC_ERROR;
994: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END IF;
997: END IF;
998: --Vertical post-processing user hook call end

Line 995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

991: ,p_repv_tbl => lp_repv_tbl) ;
992: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
993: RAISE FND_API.G_EXC_ERROR;
994: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END IF;
997: END IF;
998: --Vertical post-processing user hook call end
999:

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

1005: ,x_msg_data => l_msg_data
1006: ,x_msg_count => l_msg_count
1007: ,x_return_status => l_return_status
1008: ,p_repv_tbl => lp_repv_tbl) ;
1009: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1010: RAISE FND_API.G_EXC_ERROR;
1011: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1013: END IF;

Line 1010: RAISE FND_API.G_EXC_ERROR;

1006: ,x_msg_count => l_msg_count
1007: ,x_return_status => l_return_status
1008: ,p_repv_tbl => lp_repv_tbl) ;
1009: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1010: RAISE FND_API.G_EXC_ERROR;
1011: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1013: END IF;
1014: END IF;

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

1007: ,x_return_status => l_return_status
1008: ,p_repv_tbl => lp_repv_tbl) ;
1009: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1010: RAISE FND_API.G_EXC_ERROR;
1011: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1013: END IF;
1014: END IF;
1015: --Customer post-processing user hook call end

Line 1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1008: ,p_repv_tbl => lp_repv_tbl) ;
1009: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1010: RAISE FND_API.G_EXC_ERROR;
1011: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1013: END IF;
1014: END IF;
1015: --Customer post-processing user hook call end
1016:

Line 1025: WHEN FND_API.G_EXC_ERROR THEN

1021: x_return_status := l_return_status ;
1022:
1023: EXCEPTION
1024:
1025: WHEN FND_API.G_EXC_ERROR THEN
1026: ROLLBACK TO repos_objects_delete_tbl;
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: x_msg_count := l_msg_count ;
1029: x_msg_data := l_msg_data ;

Line 1027: x_return_status := FND_API.G_RET_STS_ERROR;

1023: EXCEPTION
1024:
1025: WHEN FND_API.G_EXC_ERROR THEN
1026: ROLLBACK TO repos_objects_delete_tbl;
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: x_msg_count := l_msg_count ;
1029: x_msg_data := l_msg_data ;
1030: FND_MSG_PUB.count_and_get(
1031: p_count => x_msg_count

Line 1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1029: x_msg_data := l_msg_data ;
1030: FND_MSG_PUB.count_and_get(
1031: p_count => x_msg_count
1032: ,p_data => x_msg_data);
1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: ROLLBACK TO repos_objects_delete_tbl;
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: x_msg_count := l_msg_count ;
1037: x_msg_data := l_msg_data ;

Line 1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1031: p_count => x_msg_count
1032: ,p_data => x_msg_data);
1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: ROLLBACK TO repos_objects_delete_tbl;
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: x_msg_count := l_msg_count ;
1037: x_msg_data := l_msg_data ;
1038: FND_MSG_PUB.count_and_get(
1039: p_count => x_msg_count

Line 1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1039: p_count => x_msg_count
1040: ,p_data => x_msg_data);
1041: WHEN OTHERS THEN
1042: ROLLBACK TO repos_objects_delete_tbl;
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: x_msg_count := l_msg_count ;
1045: x_msg_data := l_msg_data ;
1046: FND_MSG_PUB.ADD_EXC_MSG('IEX_REPOS_OBJECTS_PUB','delete_repos_objects');
1047: FND_MSG_PUB.count_and_get(

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

1085: ,x_msg_count => l_msg_count
1086: ,x_return_status => l_return_status
1087: ,p_repv_rec => lp_repv_rec
1088: ,x_repv_rec => lx_repv_rec) ;
1089: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;

Line 1090: RAISE FND_API.G_EXC_ERROR;

1086: ,x_return_status => l_return_status
1087: ,p_repv_rec => lp_repv_rec
1088: ,x_repv_rec => lx_repv_rec) ;
1089: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;
1094:

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

1087: ,p_repv_rec => lp_repv_rec
1088: ,x_repv_rec => lx_repv_rec) ;
1089: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;
1094:
1095: --Copy value of OUT variable in the IN record type

Line 1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1088: ,x_repv_rec => lx_repv_rec) ;
1089: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: END IF;
1094:
1095: --Copy value of OUT variable in the IN record type
1096: lp_repv_rec := lx_repv_rec;

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

1107: ,x_msg_count => l_msg_count
1108: ,x_return_status => l_return_status
1109: ,p_repv_rec => lp_repv_rec
1110: ,x_repv_rec => lx_repv_rec) ;
1111: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1115: END IF;

Line 1112: RAISE FND_API.G_EXC_ERROR;

1108: ,x_return_status => l_return_status
1109: ,p_repv_rec => lp_repv_rec
1110: ,x_repv_rec => lx_repv_rec) ;
1111: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1115: END IF;
1116:

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

1109: ,p_repv_rec => lp_repv_rec
1110: ,x_repv_rec => lx_repv_rec) ;
1111: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1115: END IF;
1116:
1117: --Copy value of OUT variable in the IN record type

Line 1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1110: ,x_repv_rec => lx_repv_rec) ;
1111: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1115: END IF;
1116:
1117: --Copy value of OUT variable in the IN record type
1118: lp_repv_rec := lx_repv_rec;

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

1127: ,l_msg_count
1128: ,l_msg_data
1129: ,lp_repv_rec);
1130:
1131: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1132: RAISE FND_API.G_EXC_ERROR;
1133: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;

Line 1132: RAISE FND_API.G_EXC_ERROR;

1128: ,l_msg_data
1129: ,lp_repv_rec);
1130:
1131: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1132: RAISE FND_API.G_EXC_ERROR;
1133: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:

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

1129: ,lp_repv_rec);
1130:
1131: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1132: RAISE FND_API.G_EXC_ERROR;
1133: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137: --Copy value of OUT variable in the IN record type

Line 1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1130:
1131: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1132: RAISE FND_API.G_EXC_ERROR;
1133: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137: --Copy value of OUT variable in the IN record type
1138: lp_repv_rec := lx_repv_rec;

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

1145: ,x_msg_data => l_msg_data
1146: ,x_msg_count => l_msg_count
1147: ,x_return_status => l_return_status
1148: ,p_repv_rec => lp_repv_rec) ;
1149: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;

Line 1150: RAISE FND_API.G_EXC_ERROR;

1146: ,x_msg_count => l_msg_count
1147: ,x_return_status => l_return_status
1148: ,p_repv_rec => lp_repv_rec) ;
1149: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;
1154: END IF;

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

1147: ,x_return_status => l_return_status
1148: ,p_repv_rec => lp_repv_rec) ;
1149: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;
1154: END IF;
1155:

Line 1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1148: ,p_repv_rec => lp_repv_rec) ;
1149: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;
1154: END IF;
1155:
1156:

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

1165: ,x_msg_data => l_msg_data
1166: ,x_msg_count => l_msg_count
1167: ,x_return_status => l_return_status
1168: ,p_repv_rec => lp_repv_rec) ;
1169: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;

Line 1170: RAISE FND_API.G_EXC_ERROR;

1166: ,x_msg_count => l_msg_count
1167: ,x_return_status => l_return_status
1168: ,p_repv_rec => lp_repv_rec) ;
1169: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174: END IF;

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

1167: ,x_return_status => l_return_status
1168: ,p_repv_rec => lp_repv_rec) ;
1169: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174: END IF;
1175: --Customer post-processing user hook call end

Line 1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1168: ,p_repv_rec => lp_repv_rec) ;
1169: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174: END IF;
1175: --Customer post-processing user hook call end
1176:

Line 1185: WHEN FND_API.G_EXC_ERROR THEN

1181: x_return_status := l_return_status ;
1182:
1183: EXCEPTION
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: ROLLBACK TO repos_objects_validate;
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: x_msg_count := l_msg_count ;
1189: x_msg_data := l_msg_data ;

Line 1187: x_return_status := FND_API.G_RET_STS_ERROR;

1183: EXCEPTION
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: ROLLBACK TO repos_objects_validate;
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: x_msg_count := l_msg_count ;
1189: x_msg_data := l_msg_data ;
1190: FND_MSG_PUB.count_and_get(
1191: p_count => x_msg_count

Line 1193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1189: x_msg_data := l_msg_data ;
1190: FND_MSG_PUB.count_and_get(
1191: p_count => x_msg_count
1192: ,p_data => x_msg_data);
1193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1194: ROLLBACK TO repos_objects_validate;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: x_msg_count := l_msg_count ;
1197: x_msg_data := l_msg_data ;

Line 1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1191: p_count => x_msg_count
1192: ,p_data => x_msg_data);
1193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1194: ROLLBACK TO repos_objects_validate;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: x_msg_count := l_msg_count ;
1197: x_msg_data := l_msg_data ;
1198: FND_MSG_PUB.count_and_get(
1199: p_count => x_msg_count

Line 1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1199: p_count => x_msg_count
1200: ,p_data => x_msg_data);
1201: WHEN OTHERS THEN
1202: ROLLBACK TO repos_objects_validate;
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1204: x_msg_count := l_msg_count ;
1205: x_msg_data := l_msg_data ;
1206: FND_MSG_PUB.ADD_EXC_MSG('IEX_REPOS_OBJECTS_PUB','validate_repos_objects');
1207: FND_MSG_PUB.count_and_get(

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

1244: ,x_msg_count => l_msg_count
1245: ,x_return_status => l_return_status
1246: ,p_repv_tbl => lp_repv_tbl
1247: ,x_repv_tbl => lx_repv_tbl) ;
1248: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;

Line 1249: RAISE FND_API.G_EXC_ERROR;

1245: ,x_return_status => l_return_status
1246: ,p_repv_tbl => lp_repv_tbl
1247: ,x_repv_tbl => lx_repv_tbl) ;
1248: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:

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

1246: ,p_repv_tbl => lp_repv_tbl
1247: ,x_repv_tbl => lx_repv_tbl) ;
1248: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:
1254: --Copy value of OUT variable in the IN record type

Line 1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1247: ,x_repv_tbl => lx_repv_tbl) ;
1248: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:
1254: --Copy value of OUT variable in the IN record type
1255: lp_repv_tbl := lx_repv_tbl;

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

1265: ,x_msg_count => l_msg_count
1266: ,x_return_status => l_return_status
1267: ,p_repv_tbl => lp_repv_tbl
1268: ,x_repv_tbl => lx_repv_tbl) ;
1269: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1270: RAISE FND_API.G_EXC_ERROR;
1271: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273: END IF;

Line 1270: RAISE FND_API.G_EXC_ERROR;

1266: ,x_return_status => l_return_status
1267: ,p_repv_tbl => lp_repv_tbl
1268: ,x_repv_tbl => lx_repv_tbl) ;
1269: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1270: RAISE FND_API.G_EXC_ERROR;
1271: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273: END IF;
1274:

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

1267: ,p_repv_tbl => lp_repv_tbl
1268: ,x_repv_tbl => lx_repv_tbl) ;
1269: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1270: RAISE FND_API.G_EXC_ERROR;
1271: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273: END IF;
1274:
1275: --Copy value of OUT variable in the IN record type

Line 1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1268: ,x_repv_tbl => lx_repv_tbl) ;
1269: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1270: RAISE FND_API.G_EXC_ERROR;
1271: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273: END IF;
1274:
1275: --Copy value of OUT variable in the IN record type
1276: lp_repv_tbl := lx_repv_tbl;

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

1285: ,x_msg_count
1286: ,x_msg_data
1287: ,lp_repv_tbl);
1288:
1289: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;

Line 1290: RAISE FND_API.G_EXC_ERROR;

1286: ,x_msg_data
1287: ,lp_repv_tbl);
1288:
1289: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;
1294:

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

1287: ,lp_repv_tbl);
1288:
1289: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;
1294:
1295: --Copy value of OUT variable in the IN record type

Line 1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1288:
1289: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;
1294:
1295: --Copy value of OUT variable in the IN record type
1296: lp_repv_tbl := lx_repv_tbl;

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

1302: ,x_msg_data => l_msg_data
1303: ,x_msg_count => l_msg_count
1304: ,x_return_status => l_return_status
1305: ,p_repv_tbl => lp_repv_tbl) ;
1306: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1307: RAISE FND_API.G_EXC_ERROR;
1308: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: END IF;

Line 1307: RAISE FND_API.G_EXC_ERROR;

1303: ,x_msg_count => l_msg_count
1304: ,x_return_status => l_return_status
1305: ,p_repv_tbl => lp_repv_tbl) ;
1306: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1307: RAISE FND_API.G_EXC_ERROR;
1308: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: END IF;
1311: END IF;

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

1304: ,x_return_status => l_return_status
1305: ,p_repv_tbl => lp_repv_tbl) ;
1306: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1307: RAISE FND_API.G_EXC_ERROR;
1308: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: END IF;
1311: END IF;
1312: --Vertical post-processing user hook call end

Line 1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1305: ,p_repv_tbl => lp_repv_tbl) ;
1306: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1307: RAISE FND_API.G_EXC_ERROR;
1308: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: END IF;
1311: END IF;
1312: --Vertical post-processing user hook call end
1313: --Customer post-processing user hook call start

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

1317: ,x_msg_data => l_msg_data
1318: ,x_msg_count => l_msg_count
1319: ,x_return_status => l_return_status
1320: ,p_repv_tbl => lp_repv_tbl) ;
1321: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1322: RAISE FND_API.G_EXC_ERROR;
1323: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: END IF;

Line 1322: RAISE FND_API.G_EXC_ERROR;

1318: ,x_msg_count => l_msg_count
1319: ,x_return_status => l_return_status
1320: ,p_repv_tbl => lp_repv_tbl) ;
1321: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1322: RAISE FND_API.G_EXC_ERROR;
1323: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: END IF;
1326: END IF;

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

1319: ,x_return_status => l_return_status
1320: ,p_repv_tbl => lp_repv_tbl) ;
1321: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1322: RAISE FND_API.G_EXC_ERROR;
1323: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: END IF;
1326: END IF;
1327:

Line 1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1320: ,p_repv_tbl => lp_repv_tbl) ;
1321: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1322: RAISE FND_API.G_EXC_ERROR;
1323: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: END IF;
1326: END IF;
1327:
1328:

Line 1340: WHEN FND_API.G_EXC_ERROR THEN

1336: x_return_status := l_return_status ;
1337:
1338: EXCEPTION
1339:
1340: WHEN FND_API.G_EXC_ERROR THEN
1341: ROLLBACK TO repos_objects_validate;
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343: x_msg_count := l_msg_count ;
1344: x_msg_data := l_msg_data ;

Line 1342: x_return_status := FND_API.G_RET_STS_ERROR;

1338: EXCEPTION
1339:
1340: WHEN FND_API.G_EXC_ERROR THEN
1341: ROLLBACK TO repos_objects_validate;
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343: x_msg_count := l_msg_count ;
1344: x_msg_data := l_msg_data ;
1345: FND_MSG_PUB.count_and_get(
1346: p_count => x_msg_count

Line 1348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1344: x_msg_data := l_msg_data ;
1345: FND_MSG_PUB.count_and_get(
1346: p_count => x_msg_count
1347: ,p_data => x_msg_data);
1348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1349: ROLLBACK TO repos_objects_validate;
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1351: x_msg_count := l_msg_count ;
1352: x_msg_data := l_msg_data ;

Line 1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1346: p_count => x_msg_count
1347: ,p_data => x_msg_data);
1348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1349: ROLLBACK TO repos_objects_validate;
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1351: x_msg_count := l_msg_count ;
1352: x_msg_data := l_msg_data ;
1353: FND_MSG_PUB.count_and_get(
1354: p_count => x_msg_count

Line 1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1354: p_count => x_msg_count
1355: ,p_data => x_msg_data);
1356: WHEN OTHERS THEN
1357: ROLLBACK TO repos_objects_validate;
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359: x_msg_count := l_msg_count ;
1360: x_msg_data := l_msg_data ;
1361: FND_MSG_PUB.ADD_EXC_MSG('IEX_REPOS_OBJECTS_PUB','validate_repos_objects');
1362: FND_MSG_PUB.count_and_get(