APPS.OKL_CSH_ORDER_SEQ_PUB dependencies on FND_API

Line 81: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

77: x_return_status := l_return_status ;
78: x_msg_count := l_msg_count ;
79: x_msg_data := l_msg_data ;
80:
81: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
82: RAISE Fnd_Api.G_EXC_ERROR;
83: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
84: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
85: END IF;

Line 82: RAISE Fnd_Api.G_EXC_ERROR;

78: x_msg_count := l_msg_count ;
79: x_msg_data := l_msg_data ;
80:
81: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
82: RAISE Fnd_Api.G_EXC_ERROR;
83: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
84: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:

Line 83: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

79: x_msg_data := l_msg_data ;
80:
81: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
82: RAISE Fnd_Api.G_EXC_ERROR;
83: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
84: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87:

Line 84: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

80:
81: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
82: RAISE Fnd_Api.G_EXC_ERROR;
83: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
84: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87:
88:

Line 93: WHEN Fnd_Api.G_EXC_ERROR THEN

89:
90:
91: EXCEPTION
92:
93: WHEN Fnd_Api.G_EXC_ERROR THEN
94: ROLLBACK TO csh_order_seq_update_rec;
95: x_return_status := Fnd_Api.G_RET_STS_ERROR;
96: x_msg_count := l_msg_count ;
97: x_msg_data := l_msg_data ;

Line 95: x_return_status := Fnd_Api.G_RET_STS_ERROR;

91: EXCEPTION
92:
93: WHEN Fnd_Api.G_EXC_ERROR THEN
94: ROLLBACK TO csh_order_seq_update_rec;
95: x_return_status := Fnd_Api.G_RET_STS_ERROR;
96: x_msg_count := l_msg_count ;
97: x_msg_data := l_msg_data ;
98: --Fnd_Msg_Pub.count_and_get(
99: -- p_count => x_msg_count

Line 101: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

97: x_msg_data := l_msg_data ;
98: --Fnd_Msg_Pub.count_and_get(
99: -- p_count => x_msg_count
100: -- ,p_data => x_msg_data);
101: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
102: ROLLBACK TO csh_order_seq_update_rec;
103: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
104: x_msg_count := l_msg_count ;
105: x_msg_data := l_msg_data ;

Line 103: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

99: -- p_count => x_msg_count
100: -- ,p_data => x_msg_data);
101: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
102: ROLLBACK TO csh_order_seq_update_rec;
103: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
104: x_msg_count := l_msg_count ;
105: x_msg_data := l_msg_data ;
106: --Fnd_Msg_Pub.count_and_get(
107: -- p_count => x_msg_count

Line 111: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

107: -- p_count => x_msg_count
108: -- ,p_data => x_msg_data);
109: WHEN OTHERS THEN
110: ROLLBACK TO csh_order_seq_update_rec;
111: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
112: x_msg_count := l_msg_count ;
113: x_msg_data := l_msg_data ;
114: --Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ORDER_SEQ_PUB','update_csh_order_seq');
115: --Fnd_Msg_Pub.count_and_get(

Line 202: IF (l_return_status = Fnd_Api.G_RET_STS_ERROR) THEN

198: i := p_okl_csh_order_tbl.NEXT(i);
199: END LOOP;
200: END IF;
201:
202: IF (l_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
203: RAISE Fnd_Api.G_EXC_ERROR;
204: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
205: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
206: END IF;

Line 203: RAISE Fnd_Api.G_EXC_ERROR;

199: END LOOP;
200: END IF;
201:
202: IF (l_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
203: RAISE Fnd_Api.G_EXC_ERROR;
204: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
205: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:

Line 204: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

200: END IF;
201:
202: IF (l_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
203: RAISE Fnd_Api.G_EXC_ERROR;
204: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
205: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208:

Line 205: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

201:
202: IF (l_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
203: RAISE Fnd_Api.G_EXC_ERROR;
204: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
205: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208:
209:

Line 214: WHEN Fnd_Api.G_EXC_ERROR THEN

210:
211:
212: EXCEPTION
213:
214: WHEN Fnd_Api.G_EXC_ERROR THEN
215: ROLLBACK TO csh_order_seq_update_tbl;
216: x_return_status := Fnd_Api.G_RET_STS_ERROR;
217: x_msg_count := l_msg_count ;
218: x_msg_data := l_msg_data ;

Line 216: x_return_status := Fnd_Api.G_RET_STS_ERROR;

212: EXCEPTION
213:
214: WHEN Fnd_Api.G_EXC_ERROR THEN
215: ROLLBACK TO csh_order_seq_update_tbl;
216: x_return_status := Fnd_Api.G_RET_STS_ERROR;
217: x_msg_count := l_msg_count ;
218: x_msg_data := l_msg_data ;
219: --Fnd_Msg_Pub.count_and_get(
220: -- p_count => x_msg_count

Line 222: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

218: x_msg_data := l_msg_data ;
219: --Fnd_Msg_Pub.count_and_get(
220: -- p_count => x_msg_count
221: -- ,p_data => x_msg_data);
222: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO csh_order_seq_update_tbl;
224: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
225: x_msg_count := l_msg_count ;
226: x_msg_data := l_msg_data ;

Line 224: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

220: -- p_count => x_msg_count
221: -- ,p_data => x_msg_data);
222: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO csh_order_seq_update_tbl;
224: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
225: x_msg_count := l_msg_count ;
226: x_msg_data := l_msg_data ;
227: --Fnd_Msg_Pub.count_and_get(
228: -- p_count => x_msg_count

Line 232: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

228: -- p_count => x_msg_count
229: -- ,p_data => x_msg_data);
230: WHEN OTHERS THEN
231: ROLLBACK TO csh_order_seq_update_tbl;
232: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
233: x_msg_count := l_msg_count ;
234: x_msg_data := l_msg_data ;
235: --Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ORDER_SEQ_PUB','update_csh_order_seq');
236: --Fnd_Msg_Pub.count_and_get(

Line 312: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

308: x_return_status := l_return_status ;
309: x_msg_count := l_msg_count ;
310: x_msg_data := l_msg_data ;
311:
312: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
313: RAISE Fnd_Api.G_EXC_ERROR;
314: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
315: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
316: END IF;

Line 313: RAISE Fnd_Api.G_EXC_ERROR;

309: x_msg_count := l_msg_count ;
310: x_msg_data := l_msg_data ;
311:
312: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
313: RAISE Fnd_Api.G_EXC_ERROR;
314: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
315: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:

Line 314: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

310: x_msg_data := l_msg_data ;
311:
312: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
313: RAISE Fnd_Api.G_EXC_ERROR;
314: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
315: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318:

Line 315: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

311:
312: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
313: RAISE Fnd_Api.G_EXC_ERROR;
314: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
315: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318:
319:

Line 324: WHEN Fnd_Api.G_EXC_ERROR THEN

320:
321:
322: EXCEPTION
323:
324: WHEN Fnd_Api.G_EXC_ERROR THEN
325: ROLLBACK TO csh_order_seq_update_rec;
326: x_return_status := Fnd_Api.G_RET_STS_ERROR;
327: x_msg_count := l_msg_count ;
328: x_msg_data := l_msg_data ;

Line 326: x_return_status := Fnd_Api.G_RET_STS_ERROR;

322: EXCEPTION
323:
324: WHEN Fnd_Api.G_EXC_ERROR THEN
325: ROLLBACK TO csh_order_seq_update_rec;
326: x_return_status := Fnd_Api.G_RET_STS_ERROR;
327: x_msg_count := l_msg_count ;
328: x_msg_data := l_msg_data ;
329: --Fnd_Msg_Pub.count_and_get(
330: -- p_count => x_msg_count

Line 332: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

328: x_msg_data := l_msg_data ;
329: --Fnd_Msg_Pub.count_and_get(
330: -- p_count => x_msg_count
331: -- ,p_data => x_msg_data);
332: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
333: ROLLBACK TO csh_order_seq_update_rec;
334: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
335: x_msg_count := l_msg_count ;
336: x_msg_data := l_msg_data ;

Line 334: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

330: -- p_count => x_msg_count
331: -- ,p_data => x_msg_data);
332: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
333: ROLLBACK TO csh_order_seq_update_rec;
334: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
335: x_msg_count := l_msg_count ;
336: x_msg_data := l_msg_data ;
337: --Fnd_Msg_Pub.count_and_get(
338: -- p_count => x_msg_count

Line 342: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

338: -- p_count => x_msg_count
339: -- ,p_data => x_msg_data);
340: WHEN OTHERS THEN
341: ROLLBACK TO csh_order_seq_update_rec;
342: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
343: x_msg_count := l_msg_count ;
344: x_msg_data := l_msg_data ;
345: --Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ORDER_SEQ_PUB','update_csh_order_seq');
346: --Fnd_Msg_Pub.count_and_get(

Line 711: IF (l_return_status = Fnd_Api.G_RET_STS_ERROR) THEN

707: END IF;
708: */
709: END IF;
710:
711: IF (l_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
712: RAISE Fnd_Api.G_EXC_ERROR;
713: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
714: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
715: END IF;

Line 712: RAISE Fnd_Api.G_EXC_ERROR;

708: */
709: END IF;
710:
711: IF (l_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
712: RAISE Fnd_Api.G_EXC_ERROR;
713: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
714: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
715: END IF;
716:

Line 713: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

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

Line 714: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

710:
711: IF (l_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
712: RAISE Fnd_Api.G_EXC_ERROR;
713: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
714: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
715: END IF;
716:
717:
718:

Line 723: WHEN Fnd_Api.G_EXC_ERROR THEN

719:
720:
721: EXCEPTION
722:
723: WHEN Fnd_Api.G_EXC_ERROR THEN
724: ROLLBACK TO csh_order_seq_update_tbl;
725: x_return_status := Fnd_Api.G_RET_STS_ERROR;
726: x_msg_count := l_msg_count ;
727: x_msg_data := l_msg_data ;

Line 725: x_return_status := Fnd_Api.G_RET_STS_ERROR;

721: EXCEPTION
722:
723: WHEN Fnd_Api.G_EXC_ERROR THEN
724: ROLLBACK TO csh_order_seq_update_tbl;
725: x_return_status := Fnd_Api.G_RET_STS_ERROR;
726: x_msg_count := l_msg_count ;
727: x_msg_data := l_msg_data ;
728: --Fnd_Msg_Pub.count_and_get(
729: -- p_count => x_msg_count

Line 731: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

727: x_msg_data := l_msg_data ;
728: --Fnd_Msg_Pub.count_and_get(
729: -- p_count => x_msg_count
730: -- ,p_data => x_msg_data);
731: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
732: ROLLBACK TO csh_order_seq_update_tbl;
733: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
734: x_msg_count := l_msg_count ;
735: x_msg_data := l_msg_data ;

Line 733: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

729: -- p_count => x_msg_count
730: -- ,p_data => x_msg_data);
731: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
732: ROLLBACK TO csh_order_seq_update_tbl;
733: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
734: x_msg_count := l_msg_count ;
735: x_msg_data := l_msg_data ;
736: --Fnd_Msg_Pub.count_and_get(
737: -- p_count => x_msg_count

Line 741: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

737: -- p_count => x_msg_count
738: -- ,p_data => x_msg_data);
739: WHEN OTHERS THEN
740: ROLLBACK TO csh_order_seq_update_tbl;
741: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
742: x_msg_count := l_msg_count ;
743: x_msg_data := l_msg_data ;
744: --Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ORDER_SEQ_PUB','update_csh_order_seq');
745: --Fnd_Msg_Pub.count_and_get(