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_SIF_FEES_PUB dependencies on OKC_API

Line 13: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

9:
10:
11: PROCEDURE insert_sif_fees(
12: p_api_version IN NUMBER
13: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
14: ,x_return_status OUT NOCOPY VARCHAR2
15: ,x_msg_count OUT NOCOPY NUMBER
16: ,x_msg_data OUT NOCOPY VARCHAR2
17: ,p_sfev_rec IN sfev_rec_type

Line 56: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

52: WHEN FND_API.G_EXC_ERROR THEN
53: ROLLBACK TO insert_sif_fees;
54: x_return_status := FND_API.G_RET_STS_ERROR;
55:
56: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
57: ,p_count => x_msg_count
58: ,p_data => x_msg_data);
59:
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 63: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

59:
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: ROLLBACK TO insert_sif_fees;
62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
63: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
64: ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66:
67: WHEN OTHERS THEN

Line 70: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

66:
67: WHEN OTHERS THEN
68: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_FEES_PUB','insert_sif_fees');
69: -- store SQL error message on message stack for caller
70: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
71: ,p_count => x_msg_count
72: ,p_data => x_msg_data);
73: -- notify caller of an UNEXPECTED error
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 80: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

76:
77:
78: PROCEDURE insert_sif_fees(
79: p_api_version IN NUMBER
80: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
81: ,x_return_status OUT NOCOPY VARCHAR2
82: ,x_msg_count OUT NOCOPY NUMBER
83: ,x_msg_data OUT NOCOPY VARCHAR2
84: ,p_sfev_tbl IN sfev_tbl_type

Line 147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

143: WHEN FND_API.G_EXC_ERROR THEN
144: ROLLBACK TO insert_sif_fees;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146:
147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
148: ,p_count => x_msg_count
149: ,p_data => x_msg_data);
150:
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

150:
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: ROLLBACK TO insert_sif_fees;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
155: ,p_count => x_msg_count
156: ,p_data => x_msg_data);
157:
158: WHEN OTHERS THEN

Line 161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

157:
158: WHEN OTHERS THEN
159: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_FEES_PUB','insert_sif_fees');
160: -- store SQL error message on message stack for caller
161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
162: ,p_count => x_msg_count
163: ,p_data => x_msg_data);
164: -- notify caller of an UNEXPECTED error
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 170: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

166: END insert_sif_fees;
167:
168: PROCEDURE lock_sif_fees(
169: p_api_version IN NUMBER
170: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
171: ,x_return_status OUT NOCOPY VARCHAR2
172: ,x_msg_count OUT NOCOPY NUMBER
173: ,x_msg_data OUT NOCOPY VARCHAR2
174: ,p_sfev_rec IN sfev_rec_type

Line 205: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

201: WHEN FND_API.G_EXC_ERROR THEN
202: ROLLBACK TO lock_sif_fees;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204:
205: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
206: ,p_count => x_msg_count
207: ,p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO lock_sif_fees;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data);
215:
216: WHEN OTHERS THEN

Line 219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

215:
216: WHEN OTHERS THEN
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_FEES_PUB','lock_sif_fees');
218: -- store SQL error message on message stack for caller
219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
220: ,p_count => x_msg_count
221: ,p_data => x_msg_data);
222: -- notify caller of an UNEXPECTED error
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 228: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

224: END lock_sif_fees;
225:
226: PROCEDURE lock_sif_fees(
227: p_api_version IN NUMBER
228: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
229: ,x_return_status OUT NOCOPY VARCHAR2
230: ,x_msg_count OUT NOCOPY NUMBER
231: ,x_msg_data OUT NOCOPY VARCHAR2
232: ,p_sfev_tbl IN sfev_tbl_type

Line 285: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO lock_sif_fees;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284:
285: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
286: ,p_count => x_msg_count
287: ,p_data => x_msg_data);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 292: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO lock_sif_fees;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
296: WHEN OTHERS THEN

Line 299: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

295:
296: WHEN OTHERS THEN
297: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_FEES_PUB','lock_sif_fees');
298: -- store SQL error message on message stack for caller
299: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
300: ,p_count => x_msg_count
301: ,p_data => x_msg_data);
302: -- notify caller of an UNEXPECTED error
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 308: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

304: END lock_sif_fees;
305:
306: PROCEDURE update_sif_fees(
307: p_api_version IN NUMBER
308: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
309: ,x_return_status OUT NOCOPY VARCHAR2
310: ,x_msg_count OUT NOCOPY NUMBER
311: ,x_msg_data OUT NOCOPY VARCHAR2
312: ,p_sfev_rec IN sfev_rec_type

Line 350: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

346: WHEN FND_API.G_EXC_ERROR THEN
347: ROLLBACK TO update_sif_fees;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349:
350: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
351: ,p_count => x_msg_count
352: ,p_data => x_msg_data);
353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 357: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO update_sif_fees;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
358: ,p_count => x_msg_count
359: ,p_data => x_msg_data);
360:
361: WHEN OTHERS THEN

Line 364: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

360:
361: WHEN OTHERS THEN
362: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_FEES_PUB','update_sif_fees');
363: -- store SQL error message on message stack for caller
364: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
365: ,p_count => x_msg_count
366: ,p_data => x_msg_data);
367: -- notify caller of an UNEXPECTED error
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 374: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

370:
371:
372: PROCEDURE update_sif_fees(
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_count OUT NOCOPY NUMBER
377: ,x_msg_data OUT NOCOPY VARCHAR2
378: ,p_sfev_tbl IN sfev_tbl_type

Line 441: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO update_sif_fees;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
442: ,p_count => x_msg_count
443: ,p_data => x_msg_data);
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 448: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO update_sif_fees;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
449: ,p_count => x_msg_count
450: ,p_data => x_msg_data);
451:
452: WHEN OTHERS THEN

Line 455: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

451:
452: WHEN OTHERS THEN
453: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_FEES_PUB','update_sif_fees');
454: -- store SQL error message on message stack for caller
455: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
456: ,p_count => x_msg_count
457: ,p_data => x_msg_data);
458: -- notify caller of an UNEXPECTED error
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 464: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

460: END update_sif_fees;
461:
462: PROCEDURE delete_sif_fees(
463: p_api_version IN NUMBER
464: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
465: ,x_return_status OUT NOCOPY VARCHAR2
466: ,x_msg_count OUT NOCOPY NUMBER
467: ,x_msg_data OUT NOCOPY VARCHAR2
468: ,p_sfev_rec IN sfev_rec_type

Line 505: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO delete_sif_fees;
503: x_return_status := FND_API.G_RET_STS_ERROR;
504:
505: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
506: ,p_count => x_msg_count
507: ,p_data => x_msg_data);
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 512: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO delete_sif_fees;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
513: ,p_count => x_msg_count
514: ,p_data => x_msg_data);
515:
516: WHEN OTHERS THEN

Line 519: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

515:
516: WHEN OTHERS THEN
517: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_FEES_PUB','delete_sif_fees');
518: -- store SQL error message on message stack for caller
519: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
520: ,p_count => x_msg_count
521: ,p_data => x_msg_data);
522: -- notify caller of an UNEXPECTED error
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 529: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

525:
526:
527: PROCEDURE delete_sif_fees(
528: p_api_version IN NUMBER
529: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
530: ,x_return_status OUT NOCOPY VARCHAR2
531: ,x_msg_count OUT NOCOPY NUMBER
532: ,x_msg_data OUT NOCOPY VARCHAR2
533: ,p_sfev_tbl IN sfev_tbl_type

Line 596: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

592: WHEN FND_API.G_EXC_ERROR THEN
593: ROLLBACK TO delete_sif_fees;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595:
596: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
597: ,p_count => x_msg_count
598: ,p_data => x_msg_data);
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 603: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ROLLBACK TO delete_sif_fees;
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
604: ,p_count => x_msg_count
605: ,p_data => x_msg_data);
606:
607: WHEN OTHERS THEN

Line 610: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

606:
607: WHEN OTHERS THEN
608: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_FEES_PUB','delete_sif_fees');
609: -- store SQL error message on message stack for caller
610: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
611: ,p_count => x_msg_count
612: ,p_data => x_msg_data);
613: -- notify caller of an UNEXPECTED error
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 619: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

615: END delete_sif_fees;
616:
617: PROCEDURE validate_sif_fees(
618: p_api_version IN NUMBER
619: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
620: ,x_return_status OUT NOCOPY VARCHAR2
621: ,x_msg_count OUT NOCOPY NUMBER
622: ,x_msg_data OUT NOCOPY VARCHAR2
623: ,p_sfev_rec IN sfev_rec_type

Line 660: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO validate_sif_fees;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659:
660: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
661: ,p_count => x_msg_count
662: ,p_data => x_msg_data);
663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 667: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO validate_sif_fees;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
668: ,p_count => x_msg_count
669: ,p_data => x_msg_data);
670:
671: WHEN OTHERS THEN

Line 674: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

670:
671: WHEN OTHERS THEN
672: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_FEES_PUB','validate_sif_fees');
673: -- store SQL error message on message stack for caller
674: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
675: ,p_count => x_msg_count
676: ,p_data => x_msg_data);
677: -- notify caller of an UNEXPECTED error
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 684: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

680:
681:
682: PROCEDURE validate_sif_fees(
683: p_api_version IN NUMBER
684: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
685: ,x_return_status OUT NOCOPY VARCHAR2
686: ,x_msg_count OUT NOCOPY NUMBER
687: ,x_msg_data OUT NOCOPY VARCHAR2
688: ,p_sfev_tbl IN sfev_tbl_type

Line 752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

748: WHEN FND_API.G_EXC_ERROR THEN
749: ROLLBACK TO validate_sif_fees;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751:
752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
753: ,p_count => x_msg_count
754: ,p_data => x_msg_data);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 759: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: ROLLBACK TO validate_sif_fees;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
760: ,p_count => x_msg_count
761: ,p_data => x_msg_data);
762:
763: WHEN OTHERS THEN

Line 766: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

762:
763: WHEN OTHERS THEN
764: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_FEES_PUB','validate_sif_fees');
765: -- store SQL error message on message stack for caller
766: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
767: ,p_count => x_msg_count
768: ,p_data => x_msg_data);
769: -- notify caller of an UNEXPECTED error
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;