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_PROPERTY_TAX_PUB dependencies on OKL_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

2: /* $Header: OKLPPTCB.pls 115.5 2004/04/13 10:59:11 rnaik noship $ */
3:
4: PROCEDURE insert_property_tax(
5: p_api_version IN NUMBER
6: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
7: ,x_return_status OUT NOCOPY VARCHAR2
8: ,x_msg_count OUT NOCOPY NUMBER
9: ,x_msg_data OUT NOCOPY VARCHAR2
10: ,p_ptcv_rec IN ptcv_rec_type

Line 49: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN

45: ,l_msg_data
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;

Line 51: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

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:
55: --Copy value of OUT variable in the IN record type

Line 72: x_return_status := OKL_API.G_RET_STS_ERROR;

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 ;
75: FND_MSG_PUB.count_and_get(
76: p_count => x_msg_count

Line 80: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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 ;
83: FND_MSG_PUB.count_and_get(
84: p_count => x_msg_count

Line 88: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

84: p_count => x_msg_count
85: ,p_data => x_msg_data);
86: WHEN OTHERS THEN
87: ROLLBACK TO property_tax_insert;
88: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROPERTY_TAX_PUB','insert_property_tax');
92: FND_MSG_PUB.count_and_get(

Line 99: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

95: END insert_property_tax;
96:
97: PROCEDURE insert_property_tax(
98: p_api_version IN NUMBER
99: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
100: ,x_return_status OUT NOCOPY VARCHAR2
101: ,x_msg_count OUT NOCOPY NUMBER
102: ,x_msg_data OUT NOCOPY VARCHAR2
103: ,p_ptcv_tbl IN ptcv_tbl_type

Line 138: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN

134: ,l_msg_data
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;

Line 140: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

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:
144: --Copy value of OUT variable in the IN record type

Line 160: x_return_status := OKL_API.G_RET_STS_ERROR;

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 ;
163: FND_MSG_PUB.count_and_get(
164: p_count => x_msg_count

Line 168: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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 ;
171: FND_MSG_PUB.count_and_get(
172: p_count => x_msg_count

Line 176: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

172: p_count => x_msg_count
173: ,p_data => x_msg_data);
174: WHEN OTHERS THEN
175: ROLLBACK TO property_tax_insert;
176: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROPERTY_TAX_PUB','insert_property_tax');
180: FND_MSG_PUB.count_and_get(

Line 187: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

183: END insert_property_tax;
184:
185: PROCEDURE lock_property_tax(
186: p_api_version IN NUMBER
187: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
188: ,x_return_status OUT NOCOPY VARCHAR2
189: ,x_msg_count OUT NOCOPY NUMBER
190: ,x_msg_data OUT NOCOPY VARCHAR2
191: ,p_ptcv_rec IN ptcv_rec_type) IS

Line 202: IF ( x_return_status = OKL_API.G_RET_STS_ERROR ) THEN

198: x_msg_count,
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;

Line 204: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

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:
208:

Line 220: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
221: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROPERTY_TAX_PUB','lock_property_tax');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);

Line 229: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

225: END lock_property_tax;
226:
227: PROCEDURE lock_property_tax(
228: p_api_version IN NUMBER
229: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
230: ,x_return_status OUT NOCOPY VARCHAR2
231: ,x_msg_count OUT NOCOPY NUMBER
232: ,x_msg_data OUT NOCOPY VARCHAR2
233: ,p_ptcv_tbl IN ptcv_tbl_type) IS

Line 244: IF ( x_return_status = OKL_API.G_RET_STS_ERROR ) THEN

240: x_msg_count,
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;

Line 246: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

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:
250:

Line 262: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

258: FND_MSG_PUB.count_and_get(
259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROPERTY_TAX_PUB','lock_property_tax');
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);

Line 271: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

267: END lock_property_tax;
268:
269: PROCEDURE update_property_tax(
270: p_api_version IN NUMBER
271: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
272: ,x_return_status OUT NOCOPY VARCHAR2
273: ,x_msg_count OUT NOCOPY NUMBER
274: ,x_msg_data OUT NOCOPY VARCHAR2
275: ,p_ptcv_rec IN ptcv_rec_type

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

308: ,l_msg_data
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;

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

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:
318: --Copy value of OUT variable in the IN record type

Line 335: x_return_status := OKL_API.G_RET_STS_ERROR;

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 ;
338: FND_MSG_PUB.count_and_get(
339: p_count => x_msg_count

Line 343: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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 ;
346: FND_MSG_PUB.count_and_get(
347: p_count => x_msg_count

Line 351: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

347: p_count => x_msg_count
348: ,p_data => x_msg_data);
349: WHEN OTHERS THEN
350: ROLLBACK TO property_tax_update;
351: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
352: x_msg_count := l_msg_count ;
353: x_msg_data := l_msg_data ;
354: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROPERTY_TAX_PUB','update_property_tax');
355: FND_MSG_PUB.count_and_get(

Line 362: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

358: END update_property_tax;
359:
360: PROCEDURE update_property_tax(
361: p_api_version IN NUMBER
362: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
363: ,x_return_status OUT NOCOPY VARCHAR2
364: ,x_msg_count OUT NOCOPY NUMBER
365: ,x_msg_data OUT NOCOPY VARCHAR2
366: ,p_ptcv_tbl IN ptcv_tbl_type

Line 402: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN

398: ,l_msg_data
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;

Line 404: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

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:
408: --Copy value of OUT variable in the IN record type

Line 424: x_return_status := OKL_API.G_RET_STS_ERROR;

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 ;
427: FND_MSG_PUB.count_and_get(
428: p_count => x_msg_count

Line 432: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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 ;
435: FND_MSG_PUB.count_and_get(
436: p_count => x_msg_count

Line 440: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

436: p_count => x_msg_count
437: ,p_data => x_msg_data);
438: WHEN OTHERS THEN
439: ROLLBACK TO property_tax_update;
440: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
441: x_msg_count := l_msg_count ;
442: x_msg_data := l_msg_data ;
443: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROPERTY_TAX_PUB','update_property_tax');
444: FND_MSG_PUB.count_and_get(

Line 452: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

448:
449: --Put custom code for cascade delete by developer
450: PROCEDURE delete_property_tax(
451: p_api_version IN NUMBER
452: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
453: ,x_return_status OUT NOCOPY VARCHAR2
454: ,x_msg_count OUT NOCOPY NUMBER
455: ,x_msg_data OUT NOCOPY VARCHAR2
456: ,p_ptcv_rec IN ptcv_rec_type) IS

Line 459: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

455: ,x_msg_data OUT NOCOPY VARCHAR2
456: ,p_ptcv_rec IN ptcv_rec_type) IS
457:
458: i NUMBER :=0;
459: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
460: l_api_version NUMBER ;
461: l_init_msg_list VARCHAR2(1) ;
462: l_msg_data VARCHAR2(2000);
463: l_msg_count NUMBER ;

Line 491: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN

487: ,l_msg_count
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;

Line 493: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

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:
497:

Line 510: x_return_status := OKL_API.G_RET_STS_ERROR;

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 ;
513: FND_MSG_PUB.count_and_get(
514: p_count => x_msg_count

Line 518: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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 ;
521: FND_MSG_PUB.count_and_get(
522: p_count => x_msg_count

Line 526: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

522: p_count => x_msg_count
523: ,p_data => x_msg_data);
524: WHEN OTHERS THEN
525: ROLLBACK TO property_tax_delete_rec;
526: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
527: x_msg_count := l_msg_count ;
528: x_msg_data := l_msg_data ;
529: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROPERTY_TAX_PUB','delete_property_tax');
530: FND_MSG_PUB.count_and_get(

Line 537: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

533: END delete_property_tax;
534:
535: PROCEDURE delete_property_tax(
536: p_api_version IN NUMBER
537: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
538: ,x_return_status OUT NOCOPY VARCHAR2
539: ,x_msg_count OUT NOCOPY NUMBER
540: ,x_msg_data OUT NOCOPY VARCHAR2
541: ,p_ptcv_tbl IN ptcv_tbl_type) IS

Line 544: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

540: ,x_msg_data OUT NOCOPY VARCHAR2
541: ,p_ptcv_tbl IN ptcv_tbl_type) IS
542:
543: i NUMBER := 0;
544: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
545: l_api_version NUMBER := p_api_version ;
546: l_init_msg_list VARCHAR2(1) := p_init_msg_list ;
547: l_msg_data VARCHAR2(2000);
548: l_msg_count NUMBER ;

Line 569: l_return_status := OKL_API.G_RET_STS_SUCCESS;

565:
566:
567: BEGIN
568: --Initialize the return status
569: l_return_status := OKL_API.G_RET_STS_SUCCESS;
570:
571: IF (lp_ptcv_tbl.COUNT > 0) THEN
572: i := p_ptcv_tbl.FIRST;
573: LOOP

Line 585: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN

581: EXIT WHEN (i = lp_ptcv_tbl.LAST);
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;

Line 587: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

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:
591: END;

Line 607: x_return_status := OKL_API.G_RET_STS_ERROR;

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 ;
610: FND_MSG_PUB.count_and_get(
611: p_count => x_msg_count

Line 615: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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 ;
618: FND_MSG_PUB.count_and_get(
619: p_count => x_msg_count

Line 623: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

619: p_count => x_msg_count
620: ,p_data => x_msg_data);
621: WHEN OTHERS THEN
622: ROLLBACK TO property_tax_delete_tbl;
623: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
624: x_msg_count := l_msg_count ;
625: x_msg_data := l_msg_data ;
626: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROPERTY_TAX_PUB','delete_property_tax');
627: FND_MSG_PUB.count_and_get(

Line 634: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

630: END delete_property_tax;
631:
632: PROCEDURE validate_property_tax(
633: p_api_version IN NUMBER
634: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
635: ,x_return_status OUT NOCOPY VARCHAR2
636: ,x_msg_count OUT NOCOPY NUMBER
637: ,x_msg_data OUT NOCOPY VARCHAR2
638: ,p_ptcv_rec IN ptcv_rec_type) IS

Line 671: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN

667: ,l_msg_count
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;

Line 673: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

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:
677: --Copy value of OUT variable in the IN record type

Line 697: x_return_status := OKL_API.G_RET_STS_ERROR;

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 ;
700: FND_MSG_PUB.count_and_get(
701: p_count => x_msg_count

Line 705: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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 ;
708: FND_MSG_PUB.count_and_get(
709: p_count => x_msg_count

Line 713: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

709: p_count => x_msg_count
710: ,p_data => x_msg_data);
711: WHEN OTHERS THEN
712: ROLLBACK TO property_tax_validate;
713: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
714: x_msg_count := l_msg_count ;
715: x_msg_data := l_msg_data ;
716: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROPERTY_TAX_PUB','validate_property_tax');
717: FND_MSG_PUB.count_and_get(

Line 724: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

720: END validate_property_tax;
721:
722: PROCEDURE validate_property_tax(
723: p_api_version IN NUMBER,
724: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
725: x_return_status OUT NOCOPY VARCHAR2,
726: x_msg_count OUT NOCOPY NUMBER,
727: x_msg_data OUT NOCOPY VARCHAR2,
728: p_ptcv_tbl IN ptcv_tbl_type) IS

Line 759: IF ( l_return_status = OKL_API.G_RET_STS_ERROR ) THEN

755: ,x_msg_count
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;

Line 761: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR ) THEN

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:
765: --Copy value of OUT variable in the IN record type

Line 782: x_return_status := OKL_API.G_RET_STS_ERROR;

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 ;
785: FND_MSG_PUB.count_and_get(
786: p_count => x_msg_count

Line 790: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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 ;
793: FND_MSG_PUB.count_and_get(
794: p_count => x_msg_count

Line 798: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

794: p_count => x_msg_count
795: ,p_data => x_msg_data);
796: WHEN OTHERS THEN
797: ROLLBACK TO property_tax_validate;
798: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
799: x_msg_count := l_msg_count ;
800: x_msg_data := l_msg_data ;
801: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROPERTY_TAX_PUB','validate_property_tax');
802: FND_MSG_PUB.count_and_get(