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.OKL_INS_QUOTE_PUB dependencies on FND_API

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

41: l_msg_data ,
42: l_ipyv_rec ,
43: x_message
44: );
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: l_ipyv_rec ,
43: x_message
44: );
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: --Assign value to OUT variables

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

43: x_message
44: );
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: --Assign value to OUT variables
51: x_return_status := l_return_status ;

Line 48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

44: );
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: --Assign value to OUT variables
51: x_return_status := l_return_status ;
52: x_msg_count := l_msg_count ;

Line 56: WHEN FND_API.G_EXC_ERROR THEN

52: x_msg_count := l_msg_count ;
53: x_msg_data := l_msg_data ;
54: px_ipyv_rec := l_ipyv_rec ;
55: EXCEPTION
56: WHEN FND_API.G_EXC_ERROR THEN
57: ROLLBACK TO ins_save_quote;
58: x_return_status := FND_API.G_RET_STS_ERROR;
59: x_msg_count := l_msg_count ;
60: x_msg_data := l_msg_data ;

Line 58: x_return_status := FND_API.G_RET_STS_ERROR;

54: px_ipyv_rec := l_ipyv_rec ;
55: EXCEPTION
56: WHEN FND_API.G_EXC_ERROR THEN
57: ROLLBACK TO ins_save_quote;
58: x_return_status := FND_API.G_RET_STS_ERROR;
59: x_msg_count := l_msg_count ;
60: x_msg_data := l_msg_data ;
61: FND_MSG_PUB.count_and_get(
62: p_count => x_msg_count

Line 64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

60: x_msg_data := l_msg_data ;
61: FND_MSG_PUB.count_and_get(
62: p_count => x_msg_count
63: ,p_data => x_msg_data);
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: ROLLBACK TO ins_save_quote;
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: x_msg_count := l_msg_count ;
68: x_msg_data := l_msg_data ;

Line 66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

62: p_count => x_msg_count
63: ,p_data => x_msg_data);
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: ROLLBACK TO ins_save_quote;
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: x_msg_count := l_msg_count ;
68: x_msg_data := l_msg_data ;
69: FND_MSG_PUB.count_and_get(
70: p_count => x_msg_count

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

70: p_count => x_msg_count
71: ,p_data => x_msg_data);
72: WHEN OTHERS THEN
73: ROLLBACK TO ins_save_quote;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: x_msg_count := l_msg_count ;
76: x_msg_data := l_msg_data ;
77: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','save_quote');
78: FND_MSG_PUB.count_and_get(

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

114: l_msg_data ,
115: l_ipyv_rec ,
116: x_message
117: );
118: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;

Line 119: RAISE FND_API.G_EXC_ERROR;

115: l_ipyv_rec ,
116: x_message
117: );
118: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123: --Assign value to OUT variables

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

116: x_message
117: );
118: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123: --Assign value to OUT variables
124: x_return_status := l_return_status ;

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

117: );
118: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123: --Assign value to OUT variables
124: x_return_status := l_return_status ;
125: x_msg_count := l_msg_count ;

Line 128: WHEN FND_API.G_EXC_ERROR THEN

124: x_return_status := l_return_status ;
125: x_msg_count := l_msg_count ;
126: x_msg_data := l_msg_data ;
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129: ROLLBACK TO ins_save_accept_quote;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: x_msg_count := l_msg_count ;
132: x_msg_data := l_msg_data ;

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

126: x_msg_data := l_msg_data ;
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129: ROLLBACK TO ins_save_accept_quote;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: x_msg_count := l_msg_count ;
132: x_msg_data := l_msg_data ;
133: FND_MSG_PUB.count_and_get(
134: p_count => x_msg_count

Line 136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

132: x_msg_data := l_msg_data ;
133: FND_MSG_PUB.count_and_get(
134: p_count => x_msg_count
135: ,p_data => x_msg_data);
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: ROLLBACK TO ins_save_accept_quote;
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: x_msg_count := l_msg_count ;
140: x_msg_data := l_msg_data ;

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

134: p_count => x_msg_count
135: ,p_data => x_msg_data);
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: ROLLBACK TO ins_save_accept_quote;
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: x_msg_count := l_msg_count ;
140: x_msg_data := l_msg_data ;
141: FND_MSG_PUB.count_and_get(
142: p_count => x_msg_count

Line 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

142: p_count => x_msg_count
143: ,p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO ins_save_accept_quote;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: x_msg_count := l_msg_count ;
148: x_msg_data := l_msg_data ;
149: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','save_accept_quote');
150: FND_MSG_PUB.count_and_get(

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

182: ,l_return_status
183: ,l_msg_count
184: ,l_msg_data,
185: l_quote_id);
186: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
187: RAISE FND_API.G_EXC_ERROR;
188: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;

Line 187: RAISE FND_API.G_EXC_ERROR;

183: ,l_msg_count
184: ,l_msg_data,
185: l_quote_id);
186: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
187: RAISE FND_API.G_EXC_ERROR;
188: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191: --Assign value to OUT variables

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

184: ,l_msg_data,
185: l_quote_id);
186: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
187: RAISE FND_API.G_EXC_ERROR;
188: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191: --Assign value to OUT variables
192: x_return_status := l_return_status ;

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: l_quote_id);
186: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
187: RAISE FND_API.G_EXC_ERROR;
188: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191: --Assign value to OUT variables
192: x_return_status := l_return_status ;
193: x_msg_count := l_msg_count ;

Line 196: WHEN FND_API.G_EXC_ERROR THEN

192: x_return_status := l_return_status ;
193: x_msg_count := l_msg_count ;
194: x_msg_data := l_msg_data ;
195: EXCEPTION
196: WHEN FND_API.G_EXC_ERROR THEN
197: ROLLBACK TO ins_accept_quote;
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: x_msg_count := l_msg_count ;
200: x_msg_data := l_msg_data ;

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194: x_msg_data := l_msg_data ;
195: EXCEPTION
196: WHEN FND_API.G_EXC_ERROR THEN
197: ROLLBACK TO ins_accept_quote;
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: x_msg_count := l_msg_count ;
200: x_msg_data := l_msg_data ;
201: FND_MSG_PUB.count_and_get(
202: p_count => x_msg_count

Line 204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

200: x_msg_data := l_msg_data ;
201: FND_MSG_PUB.count_and_get(
202: p_count => x_msg_count
203: ,p_data => x_msg_data);
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO ins_accept_quote;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: x_msg_count := l_msg_count ;
208: x_msg_data := l_msg_data ;

Line 206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

202: p_count => x_msg_count
203: ,p_data => x_msg_data);
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO ins_accept_quote;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: x_msg_count := l_msg_count ;
208: x_msg_data := l_msg_data ;
209: FND_MSG_PUB.count_and_get(
210: p_count => x_msg_count

Line 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

210: p_count => x_msg_count
211: ,p_data => x_msg_data);
212: WHEN OTHERS THEN
213: ROLLBACK TO ins_accept_quote;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: x_msg_count := l_msg_count ;
216: x_msg_data := l_msg_data ;
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','accept_quote');
218: FND_MSG_PUB.count_and_get(

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

253: l_msg_data ,
254: l_ipyv_rec
255: );
256:
257: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
258: RAISE FND_API.G_EXC_ERROR;
259: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;

Line 258: RAISE FND_API.G_EXC_ERROR;

254: l_ipyv_rec
255: );
256:
257: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
258: RAISE FND_API.G_EXC_ERROR;
259: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;
262: --Assign value to OUT variables

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

255: );
256:
257: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
258: RAISE FND_API.G_EXC_ERROR;
259: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;
262: --Assign value to OUT variables
263: x_return_status := l_return_status ;

Line 260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

256:
257: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
258: RAISE FND_API.G_EXC_ERROR;
259: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;
262: --Assign value to OUT variables
263: x_return_status := l_return_status ;
264: x_msg_count := l_msg_count ;

Line 267: WHEN FND_API.G_EXC_ERROR THEN

263: x_return_status := l_return_status ;
264: x_msg_count := l_msg_count ;
265: x_msg_data := l_msg_data ;
266: EXCEPTION
267: WHEN FND_API.G_EXC_ERROR THEN
268: ROLLBACK TO ins_create_ins_streams;
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: x_msg_count := l_msg_count ;
271: x_msg_data := l_msg_data ;

Line 269: x_return_status := FND_API.G_RET_STS_ERROR;

265: x_msg_data := l_msg_data ;
266: EXCEPTION
267: WHEN FND_API.G_EXC_ERROR THEN
268: ROLLBACK TO ins_create_ins_streams;
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: x_msg_count := l_msg_count ;
271: x_msg_data := l_msg_data ;
272: FND_MSG_PUB.count_and_get(
273: p_count => x_msg_count

Line 275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

271: x_msg_data := l_msg_data ;
272: FND_MSG_PUB.count_and_get(
273: p_count => x_msg_count
274: ,p_data => x_msg_data);
275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
276: ROLLBACK TO ins_create_ins_streams;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: x_msg_count := l_msg_count ;
279: x_msg_data := l_msg_data ;

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

273: p_count => x_msg_count
274: ,p_data => x_msg_data);
275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
276: ROLLBACK TO ins_create_ins_streams;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: x_msg_count := l_msg_count ;
279: x_msg_data := l_msg_data ;
280: FND_MSG_PUB.count_and_get(
281: p_count => x_msg_count

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

281: p_count => x_msg_count
282: ,p_data => x_msg_data);
283: WHEN OTHERS THEN
284: ROLLBACK TO ins_create_ins_streams;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: x_msg_count := l_msg_count ;
287: x_msg_data := l_msg_data ;
288: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','create_ins_streams');
289: FND_MSG_PUB.count_and_get(

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

328: l_msg_data ,
329: l_ipyv_rec ,
330: x_message ,
331: x_iasset_tbl );
332: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
333: RAISE FND_API.G_EXC_ERROR;
334: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;

Line 333: RAISE FND_API.G_EXC_ERROR;

329: l_ipyv_rec ,
330: x_message ,
331: x_iasset_tbl );
332: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
333: RAISE FND_API.G_EXC_ERROR;
334: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;
337: --Assign value to OUT variables

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

330: x_message ,
331: x_iasset_tbl );
332: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
333: RAISE FND_API.G_EXC_ERROR;
334: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;
337: --Assign value to OUT variables
338: x_return_status := l_return_status ;

Line 335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

331: x_iasset_tbl );
332: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
333: RAISE FND_API.G_EXC_ERROR;
334: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;
337: --Assign value to OUT variables
338: x_return_status := l_return_status ;
339: x_msg_count := l_msg_count ;

Line 343: WHEN FND_API.G_EXC_ERROR THEN

339: x_msg_count := l_msg_count ;
340: x_msg_data := l_msg_data ;
341: px_ipyv_rec := l_ipyv_rec ;
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO ins_calc_lease_premium;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: x_msg_count := l_msg_count ;
347: x_msg_data := l_msg_data ;

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: px_ipyv_rec := l_ipyv_rec ;
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO ins_calc_lease_premium;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: x_msg_count := l_msg_count ;
347: x_msg_data := l_msg_data ;
348: FND_MSG_PUB.count_and_get(
349: p_count => x_msg_count

Line 351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

347: x_msg_data := l_msg_data ;
348: FND_MSG_PUB.count_and_get(
349: p_count => x_msg_count
350: ,p_data => x_msg_data);
351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
352: ROLLBACK TO ins_calc_lease_premium;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: x_msg_count := l_msg_count ;
355: x_msg_data := l_msg_data ;

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

349: p_count => x_msg_count
350: ,p_data => x_msg_data);
351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
352: ROLLBACK TO ins_calc_lease_premium;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: x_msg_count := l_msg_count ;
355: x_msg_data := l_msg_data ;
356: FND_MSG_PUB.count_and_get(
357: p_count => x_msg_count

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

357: p_count => x_msg_count
358: ,p_data => x_msg_data);
359: WHEN OTHERS THEN
360: ROLLBACK TO ins_calc_lease_premium;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: x_msg_count := l_msg_count ;
363: x_msg_data := l_msg_data ;
364: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','calc_lease_premium');
365: FND_MSG_PUB.count_and_get(

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

401: l_msg_data ,
402: l_ipyv_rec
403: );
404:
405: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
406: RAISE FND_API.G_EXC_ERROR;
407: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;

Line 406: RAISE FND_API.G_EXC_ERROR;

402: l_ipyv_rec
403: );
404:
405: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
406: RAISE FND_API.G_EXC_ERROR;
407: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410: --Assign value to OUT variables

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

403: );
404:
405: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
406: RAISE FND_API.G_EXC_ERROR;
407: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410: --Assign value to OUT variables
411: x_return_status := l_return_status ;

Line 408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

404:
405: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
406: RAISE FND_API.G_EXC_ERROR;
407: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410: --Assign value to OUT variables
411: x_return_status := l_return_status ;
412: x_msg_count := l_msg_count ;

Line 415: WHEN FND_API.G_EXC_ERROR THEN

411: x_return_status := l_return_status ;
412: x_msg_count := l_msg_count ;
413: x_msg_data := l_msg_data ;
414: EXCEPTION
415: WHEN FND_API.G_EXC_ERROR THEN
416: ROLLBACK TO ins_activate_ins_stream;
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: x_msg_count := l_msg_count ;
419: x_msg_data := l_msg_data ;

Line 417: x_return_status := FND_API.G_RET_STS_ERROR;

413: x_msg_data := l_msg_data ;
414: EXCEPTION
415: WHEN FND_API.G_EXC_ERROR THEN
416: ROLLBACK TO ins_activate_ins_stream;
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: x_msg_count := l_msg_count ;
419: x_msg_data := l_msg_data ;
420: FND_MSG_PUB.count_and_get(
421: p_count => x_msg_count

Line 423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

419: x_msg_data := l_msg_data ;
420: FND_MSG_PUB.count_and_get(
421: p_count => x_msg_count
422: ,p_data => x_msg_data);
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: ROLLBACK TO ins_activate_ins_stream;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: x_msg_count := l_msg_count ;
427: x_msg_data := l_msg_data ;

Line 425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

421: p_count => x_msg_count
422: ,p_data => x_msg_data);
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: ROLLBACK TO ins_activate_ins_stream;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: x_msg_count := l_msg_count ;
427: x_msg_data := l_msg_data ;
428: FND_MSG_PUB.count_and_get(
429: p_count => x_msg_count

Line 433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

429: p_count => x_msg_count
430: ,p_data => x_msg_data);
431: WHEN OTHERS THEN
432: ROLLBACK TO ins_activate_ins_stream;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: x_msg_count := l_msg_count ;
435: x_msg_data := l_msg_data ;
436: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_stream');
437: FND_MSG_PUB.count_and_get(

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

481: ,l_return_status
482: ,l_msg_count
483: ,l_msg_data
484: ,l_contract_id) ;
485: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
486: RAISE FND_API.G_EXC_ERROR;
487: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;

Line 486: RAISE FND_API.G_EXC_ERROR;

482: ,l_msg_count
483: ,l_msg_data
484: ,l_contract_id) ;
485: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
486: RAISE FND_API.G_EXC_ERROR;
487: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490: --Assign value to OUT variables

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

483: ,l_msg_data
484: ,l_contract_id) ;
485: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
486: RAISE FND_API.G_EXC_ERROR;
487: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490: --Assign value to OUT variables
491: x_return_status := l_return_status ;

Line 488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

484: ,l_contract_id) ;
485: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
486: RAISE FND_API.G_EXC_ERROR;
487: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490: --Assign value to OUT variables
491: x_return_status := l_return_status ;
492: x_msg_count := l_msg_count ;

Line 495: WHEN FND_API.G_EXC_ERROR THEN

491: x_return_status := l_return_status ;
492: x_msg_count := l_msg_count ;
493: x_msg_data := l_msg_data ;
494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: ROLLBACK TO activate_ins_streams;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: x_msg_count := l_msg_count ;
499: x_msg_data := l_msg_data ;

Line 497: x_return_status := FND_API.G_RET_STS_ERROR;

493: x_msg_data := l_msg_data ;
494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: ROLLBACK TO activate_ins_streams;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: x_msg_count := l_msg_count ;
499: x_msg_data := l_msg_data ;
500: FND_MSG_PUB.count_and_get(
501: p_count => x_msg_count

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

499: x_msg_data := l_msg_data ;
500: FND_MSG_PUB.count_and_get(
501: p_count => x_msg_count
502: ,p_data => x_msg_data);
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO activate_ins_streams;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: x_msg_count := l_msg_count ;
507: x_msg_data := l_msg_data ;

Line 505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

501: p_count => x_msg_count
502: ,p_data => x_msg_data);
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO activate_ins_streams;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: x_msg_count := l_msg_count ;
507: x_msg_data := l_msg_data ;
508: FND_MSG_PUB.count_and_get(
509: p_count => x_msg_count

Line 513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

509: p_count => x_msg_count
510: ,p_data => x_msg_data);
511: WHEN OTHERS THEN
512: ROLLBACK TO activate_ins_streams;
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: x_msg_count := l_msg_count ;
515: x_msg_data := l_msg_data ;
516: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_streams');
517: FND_MSG_PUB.count_and_get(

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

549: ,l_return_status
550: ,l_msg_count
551: ,l_msg_data
552: ,l_ins_policy_id) ;
553: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;

Line 554: RAISE FND_API.G_EXC_ERROR;

550: ,l_msg_count
551: ,l_msg_data
552: ,l_ins_policy_id) ;
553: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558: --Assign value to OUT variables

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

551: ,l_msg_data
552: ,l_ins_policy_id) ;
553: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558: --Assign value to OUT variables
559: x_return_status := l_return_status ;

Line 556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

552: ,l_ins_policy_id) ;
553: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558: --Assign value to OUT variables
559: x_return_status := l_return_status ;
560: x_msg_count := l_msg_count ;

Line 563: WHEN FND_API.G_EXC_ERROR THEN

559: x_return_status := l_return_status ;
560: x_msg_count := l_msg_count ;
561: x_msg_data := l_msg_data ;
562: EXCEPTION
563: WHEN FND_API.G_EXC_ERROR THEN
564: ROLLBACK TO activate_ins_policy;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: x_msg_count := l_msg_count ;
567: x_msg_data := l_msg_data ;

Line 565: x_return_status := FND_API.G_RET_STS_ERROR;

561: x_msg_data := l_msg_data ;
562: EXCEPTION
563: WHEN FND_API.G_EXC_ERROR THEN
564: ROLLBACK TO activate_ins_policy;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: x_msg_count := l_msg_count ;
567: x_msg_data := l_msg_data ;
568: FND_MSG_PUB.count_and_get(
569: p_count => x_msg_count

Line 571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

567: x_msg_data := l_msg_data ;
568: FND_MSG_PUB.count_and_get(
569: p_count => x_msg_count
570: ,p_data => x_msg_data);
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: ROLLBACK TO activate_ins_policy;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: x_msg_count := l_msg_count ;
575: x_msg_data := l_msg_data ;

Line 573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

569: p_count => x_msg_count
570: ,p_data => x_msg_data);
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: ROLLBACK TO activate_ins_policy;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: x_msg_count := l_msg_count ;
575: x_msg_data := l_msg_data ;
576: FND_MSG_PUB.count_and_get(
577: p_count => x_msg_count

Line 581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

577: p_count => x_msg_count
578: ,p_data => x_msg_data);
579: WHEN OTHERS THEN
580: ROLLBACK TO activate_ins_policy;
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: x_msg_count := l_msg_count ;
583: x_msg_data := l_msg_data ;
584: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','activate_ins_policy');
585: FND_MSG_PUB.count_and_get(

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

625: l_msg_data ,
626: l_ipyv_rec ,
627: x_message ,
628: lx_ipyv_rec );
629: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
630: RAISE FND_API.G_EXC_ERROR;
631: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;

Line 630: RAISE FND_API.G_EXC_ERROR;

626: l_ipyv_rec ,
627: x_message ,
628: lx_ipyv_rec );
629: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
630: RAISE FND_API.G_EXC_ERROR;
631: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;
634: --Assign value to OUT variables

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

627: x_message ,
628: lx_ipyv_rec );
629: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
630: RAISE FND_API.G_EXC_ERROR;
631: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;
634: --Assign value to OUT variables
635: x_return_status := l_return_status ;

Line 632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

628: lx_ipyv_rec );
629: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
630: RAISE FND_API.G_EXC_ERROR;
631: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;
634: --Assign value to OUT variables
635: x_return_status := l_return_status ;
636: x_msg_count := l_msg_count ;

Line 640: WHEN FND_API.G_EXC_ERROR THEN

636: x_msg_count := l_msg_count ;
637: x_msg_data := l_msg_data ;
638: x_ipyv_rec := lx_ipyv_rec ;
639: EXCEPTION
640: WHEN FND_API.G_EXC_ERROR THEN
641: ROLLBACK TO ins_calc_optional_premium;
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: x_msg_count := l_msg_count ;
644: x_msg_data := l_msg_data ;

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638: x_ipyv_rec := lx_ipyv_rec ;
639: EXCEPTION
640: WHEN FND_API.G_EXC_ERROR THEN
641: ROLLBACK TO ins_calc_optional_premium;
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: x_msg_count := l_msg_count ;
644: x_msg_data := l_msg_data ;
645: FND_MSG_PUB.count_and_get(
646: p_count => x_msg_count

Line 648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

644: x_msg_data := l_msg_data ;
645: FND_MSG_PUB.count_and_get(
646: p_count => x_msg_count
647: ,p_data => x_msg_data);
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: ROLLBACK TO ins_calc_optional_premium;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: x_msg_count := l_msg_count ;
652: x_msg_data := l_msg_data ;

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

646: p_count => x_msg_count
647: ,p_data => x_msg_data);
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: ROLLBACK TO ins_calc_optional_premium;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: x_msg_count := l_msg_count ;
652: x_msg_data := l_msg_data ;
653: FND_MSG_PUB.count_and_get(
654: p_count => x_msg_count

Line 658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

654: p_count => x_msg_count
655: ,p_data => x_msg_data);
656: WHEN OTHERS THEN
657: ROLLBACK TO ins_calc_optional_premium;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: x_msg_count := l_msg_count ;
660: x_msg_data := l_msg_data ;
661: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','calc_optional_premium');
662: FND_MSG_PUB.count_and_get(

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

709: l_msg_data ,
710: l_pol_qte_id ,
711: lx_total_premium );
712:
713: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
714: RAISE FND_API.G_EXC_ERROR;
715: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;

Line 714: RAISE FND_API.G_EXC_ERROR;

710: l_pol_qte_id ,
711: lx_total_premium );
712:
713: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
714: RAISE FND_API.G_EXC_ERROR;
715: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718: --Assign value to OUT variables

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

711: lx_total_premium );
712:
713: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
714: RAISE FND_API.G_EXC_ERROR;
715: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718: --Assign value to OUT variables
719: x_return_status := l_return_status ;

Line 716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

712:
713: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
714: RAISE FND_API.G_EXC_ERROR;
715: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718: --Assign value to OUT variables
719: x_return_status := l_return_status ;
720: x_msg_count := l_msg_count ;

Line 724: WHEN FND_API.G_EXC_ERROR THEN

720: x_msg_count := l_msg_count ;
721: x_msg_data := l_msg_data ;
722: x_total_premium := lx_total_premium;
723: EXCEPTION
724: WHEN FND_API.G_EXC_ERROR THEN
725: ROLLBACK TO ins_calc_total_premium;
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: x_msg_count := l_msg_count ;
728: x_msg_data := l_msg_data ;

Line 726: x_return_status := FND_API.G_RET_STS_ERROR;

722: x_total_premium := lx_total_premium;
723: EXCEPTION
724: WHEN FND_API.G_EXC_ERROR THEN
725: ROLLBACK TO ins_calc_total_premium;
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: x_msg_count := l_msg_count ;
728: x_msg_data := l_msg_data ;
729: FND_MSG_PUB.count_and_get(
730: p_count => x_msg_count

Line 732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

728: x_msg_data := l_msg_data ;
729: FND_MSG_PUB.count_and_get(
730: p_count => x_msg_count
731: ,p_data => x_msg_data);
732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
733: ROLLBACK TO ins_calc_total_premium;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: x_msg_count := l_msg_count ;
736: x_msg_data := l_msg_data ;

Line 734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

730: p_count => x_msg_count
731: ,p_data => x_msg_data);
732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
733: ROLLBACK TO ins_calc_total_premium;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: x_msg_count := l_msg_count ;
736: x_msg_data := l_msg_data ;
737: FND_MSG_PUB.count_and_get(
738: p_count => x_msg_count

Line 742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

738: p_count => x_msg_count
739: ,p_data => x_msg_data);
740: WHEN OTHERS THEN
741: ROLLBACK TO ins_calc_total_premium;
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: x_msg_count := l_msg_count ;
744: x_msg_data := l_msg_data ;
745: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','calc_total_premium');
746: FND_MSG_PUB.count_and_get(

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

782: l_msg_count ,
783: l_msg_data ,
784: l_ipyv_rec ,
785: lx_ipyv_rec );
786: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
787: RAISE FND_API.G_EXC_ERROR;
788: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
790: END IF;

Line 787: RAISE FND_API.G_EXC_ERROR;

783: l_msg_data ,
784: l_ipyv_rec ,
785: lx_ipyv_rec );
786: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
787: RAISE FND_API.G_EXC_ERROR;
788: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
790: END IF;
791:

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

784: l_ipyv_rec ,
785: lx_ipyv_rec );
786: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
787: RAISE FND_API.G_EXC_ERROR;
788: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
790: END IF;
791:
792: --Assign value to OUT variables

Line 789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

785: lx_ipyv_rec );
786: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
787: RAISE FND_API.G_EXC_ERROR;
788: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
790: END IF;
791:
792: --Assign value to OUT variables
793: x_return_status := l_return_status ;

Line 798: WHEN FND_API.G_EXC_ERROR THEN

794: x_msg_count := l_msg_count ;
795: x_msg_data := l_msg_data ;
796: x_ipyv_rec := lx_ipyv_rec ;
797: EXCEPTION
798: WHEN FND_API.G_EXC_ERROR THEN
799: ROLLBACK TO create_third_prt_ins;
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: x_msg_count := l_msg_count ;
802: x_msg_data := l_msg_data ;

Line 800: x_return_status := FND_API.G_RET_STS_ERROR;

796: x_ipyv_rec := lx_ipyv_rec ;
797: EXCEPTION
798: WHEN FND_API.G_EXC_ERROR THEN
799: ROLLBACK TO create_third_prt_ins;
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: x_msg_count := l_msg_count ;
802: x_msg_data := l_msg_data ;
803: FND_MSG_PUB.count_and_get(
804: p_count => x_msg_count

Line 806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

802: x_msg_data := l_msg_data ;
803: FND_MSG_PUB.count_and_get(
804: p_count => x_msg_count
805: ,p_data => x_msg_data);
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO create_third_prt_ins;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: x_msg_count := l_msg_count ;
810: x_msg_data := l_msg_data ;

Line 808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

804: p_count => x_msg_count
805: ,p_data => x_msg_data);
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO create_third_prt_ins;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: x_msg_count := l_msg_count ;
810: x_msg_data := l_msg_data ;
811: FND_MSG_PUB.count_and_get(
812: p_count => x_msg_count

Line 816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

812: p_count => x_msg_count
813: ,p_data => x_msg_data);
814: WHEN OTHERS THEN
815: ROLLBACK TO create_third_prt_ins;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: x_msg_count := l_msg_count ;
818: x_msg_data := l_msg_data ;
819: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_QUOTE_PUB','create_third_prt_ins');
820: FND_MSG_PUB.count_and_get(