DBA Data[Home] [Help]

APPS.OKL_PROPERTY_TAX_PUB dependencies on FND_API

Line 50: RAISE FND_API.G_EXC_ERROR;

46: ,lp_ptcv_rec
47: ,lx_ptcv_rec);
48:
49: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
50: RAISE FND_API.G_EXC_ERROR;
51: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54:

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

48:
49: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
50: RAISE FND_API.G_EXC_ERROR;
51: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54:
55: --Copy value of OUT variable in the IN record type
56: lp_ptcv_rec := lx_ptcv_rec;

Line 70: WHEN FND_API.G_EXC_ERROR THEN

66: x_msg_data := l_msg_data ;
67:
68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71: ROLLBACK TO property_tax_insert;
72: x_return_status := OKL_API.G_RET_STS_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;

Line 78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.count_and_get(
76: p_count => x_msg_count
77: ,p_data => x_msg_data);
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: ROLLBACK TO property_tax_insert;
80: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
81: x_msg_count := l_msg_count ;
82: x_msg_data := l_msg_data ;

Line 139: RAISE FND_API.G_EXC_ERROR;

135: ,lp_ptcv_tbl
136: ,lx_ptcv_tbl);
137:
138: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

137:
138: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: --Copy value of OUT variable in the IN record type
145: lp_ptcv_tbl := lx_ptcv_tbl;

Line 158: WHEN FND_API.G_EXC_ERROR THEN

154:
155:
156: EXCEPTION
157:
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO property_tax_insert;
160: x_return_status := OKL_API.G_RET_STS_ERROR;
161: x_msg_count := l_msg_count ;
162: x_msg_data := l_msg_data ;

Line 166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

162: x_msg_data := l_msg_data ;
163: FND_MSG_PUB.count_and_get(
164: p_count => x_msg_count
165: ,p_data => x_msg_data);
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO property_tax_insert;
168: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
169: x_msg_count := l_msg_count ;
170: x_msg_data := l_msg_data ;

Line 203: RAISE FND_API.G_EXC_ERROR;

199: x_msg_data,
200: p_ptcv_rec);
201:
202: IF ( x_return_status = OKL_API.G_RET_STS_ERROR ) THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 211: WHEN FND_API.G_EXC_ERROR THEN

207:
208:
209: EXCEPTION
210:
211: WHEN FND_API.G_EXC_ERROR THEN
212: FND_MSG_PUB.count_and_get(
213: p_count => x_msg_count
214: ,p_data => x_msg_data);
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

211: WHEN FND_API.G_EXC_ERROR THEN
212: FND_MSG_PUB.count_and_get(
213: p_count => x_msg_count
214: ,p_data => x_msg_data);
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN

Line 245: RAISE FND_API.G_EXC_ERROR;

241: x_msg_data,
242: p_ptcv_tbl);
243:
244: IF ( x_return_status = OKL_API.G_RET_STS_ERROR ) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249:

Line 247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

243:
244: IF ( x_return_status = OKL_API.G_RET_STS_ERROR ) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249:
250:
251: EXCEPTION

Line 253: WHEN FND_API.G_EXC_ERROR THEN

249:
250:
251: EXCEPTION
252:
253: WHEN FND_API.G_EXC_ERROR THEN
254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

253: WHEN FND_API.G_EXC_ERROR THEN
254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: FND_MSG_PUB.count_and_get(
259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN

Line 313: RAISE FND_API.G_EXC_ERROR;

309: ,lp_ptcv_rec
310: ,lx_ptcv_rec);
311:
312: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:

Line 315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

311:
312: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: --Copy value of OUT variable in the IN record type
319: lp_ptcv_rec := lx_ptcv_rec;

Line 333: WHEN FND_API.G_EXC_ERROR THEN

329:
330:
331: EXCEPTION
332:
333: WHEN FND_API.G_EXC_ERROR THEN
334: ROLLBACK TO property_tax_update;
335: x_return_status := OKL_API.G_RET_STS_ERROR;
336: x_msg_count := l_msg_count ;
337: x_msg_data := l_msg_data ;

Line 341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

337: x_msg_data := l_msg_data ;
338: FND_MSG_PUB.count_and_get(
339: p_count => x_msg_count
340: ,p_data => x_msg_data);
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: ROLLBACK TO property_tax_update;
343: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
344: x_msg_count := l_msg_count ;
345: x_msg_data := l_msg_data ;

Line 403: RAISE FND_API.G_EXC_ERROR;

399: ,lp_ptcv_tbl
400: ,lx_ptcv_tbl);
401:
402: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
403: RAISE FND_API.G_EXC_ERROR;
404: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END IF;
407:

Line 405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

401:
402: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
403: RAISE FND_API.G_EXC_ERROR;
404: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END IF;
407:
408: --Copy value of OUT variable in the IN record type
409: lp_ptcv_tbl := lx_ptcv_tbl;

Line 422: WHEN FND_API.G_EXC_ERROR THEN

418:
419:
420: EXCEPTION
421:
422: WHEN FND_API.G_EXC_ERROR THEN
423: ROLLBACK TO property_tax_update;
424: x_return_status := OKL_API.G_RET_STS_ERROR;
425: x_msg_count := l_msg_count ;
426: x_msg_data := l_msg_data ;

Line 430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

426: x_msg_data := l_msg_data ;
427: FND_MSG_PUB.count_and_get(
428: p_count => x_msg_count
429: ,p_data => x_msg_data);
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: ROLLBACK TO property_tax_update;
432: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
433: x_msg_count := l_msg_count ;
434: x_msg_data := l_msg_data ;

Line 492: RAISE FND_API.G_EXC_ERROR;

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

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 508: WHEN FND_API.G_EXC_ERROR THEN

504: x_return_status := l_return_status ;
505:
506: EXCEPTION
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO property_tax_delete_rec;
510: x_return_status := OKL_API.G_RET_STS_ERROR;
511: x_msg_count := l_msg_count ;
512: x_msg_data := l_msg_data ;

Line 516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

512: x_msg_data := l_msg_data ;
513: FND_MSG_PUB.count_and_get(
514: p_count => x_msg_count
515: ,p_data => x_msg_data);
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: ROLLBACK TO property_tax_delete_rec;
518: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
519: x_msg_count := l_msg_count ;
520: x_msg_data := l_msg_data ;

Line 586: RAISE FND_API.G_EXC_ERROR;

582: i := p_ptcv_tbl.NEXT(i);
583: END LOOP;
584: END IF;
585: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:

Line 588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

584: END IF;
585: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
586: RAISE FND_API.G_EXC_ERROR;
587: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: END;
592:

Line 605: WHEN FND_API.G_EXC_ERROR THEN

601: x_return_status := l_return_status ;
602:
603: EXCEPTION
604:
605: WHEN FND_API.G_EXC_ERROR THEN
606: ROLLBACK TO property_tax_delete_tbl;
607: x_return_status := OKL_API.G_RET_STS_ERROR;
608: x_msg_count := l_msg_count ;
609: x_msg_data := l_msg_data ;

Line 613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

609: x_msg_data := l_msg_data ;
610: FND_MSG_PUB.count_and_get(
611: p_count => x_msg_count
612: ,p_data => x_msg_data);
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: ROLLBACK TO property_tax_delete_tbl;
615: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
616: x_msg_count := l_msg_count ;
617: x_msg_data := l_msg_data ;

Line 672: RAISE FND_API.G_EXC_ERROR;

668: ,l_msg_data
669: ,lp_ptcv_rec);
670:
671: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676:

Line 674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

670:
671: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676:
677: --Copy value of OUT variable in the IN record type
678: lp_ptcv_rec := lx_ptcv_rec;

Line 695: WHEN FND_API.G_EXC_ERROR THEN

691: x_return_status := l_return_status ;
692:
693: EXCEPTION
694:
695: WHEN FND_API.G_EXC_ERROR THEN
696: ROLLBACK TO property_tax_validate;
697: x_return_status := OKL_API.G_RET_STS_ERROR;
698: x_msg_count := l_msg_count ;
699: x_msg_data := l_msg_data ;

Line 703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

699: x_msg_data := l_msg_data ;
700: FND_MSG_PUB.count_and_get(
701: p_count => x_msg_count
702: ,p_data => x_msg_data);
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: ROLLBACK TO property_tax_validate;
705: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
706: x_msg_count := l_msg_count ;
707: x_msg_data := l_msg_data ;

Line 760: RAISE FND_API.G_EXC_ERROR;

756: ,x_msg_data
757: ,lp_ptcv_tbl);
758:
759: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END IF;
764:

Line 762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

758:
759: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END IF;
764:
765: --Copy value of OUT variable in the IN record type
766: lp_ptcv_tbl := lx_ptcv_tbl;

Line 780: WHEN FND_API.G_EXC_ERROR THEN

776: x_return_status := l_return_status ;
777:
778: EXCEPTION
779:
780: WHEN FND_API.G_EXC_ERROR THEN
781: ROLLBACK TO property_tax_validate;
782: x_return_status := OKL_API.G_RET_STS_ERROR;
783: x_msg_count := l_msg_count ;
784: x_msg_data := l_msg_data ;

Line 788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

784: x_msg_data := l_msg_data ;
785: FND_MSG_PUB.count_and_get(
786: p_count => x_msg_count
787: ,p_data => x_msg_data);
788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
789: ROLLBACK TO property_tax_validate;
790: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
791: x_msg_count := l_msg_count ;
792: x_msg_data := l_msg_data ;