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_RETS_PUB dependencies on FND_MSG_PUB

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_rets;
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_rets;
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 68: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','insert_sif_rets');

64: ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66:
67: WHEN OTHERS THEN
68: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','insert_sif_rets');
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);

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_RETS_PUB','insert_sif_rets');
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 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_rets;
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_rets;
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 159: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','insert_sif_rets');

155: ,p_count => x_msg_count
156: ,p_data => x_msg_data);
157:
158: WHEN OTHERS THEN
159: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','insert_sif_rets');
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);

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_RETS_PUB','insert_sif_rets');
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 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_rets;
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_rets;
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 217: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','lock_sif_rets');

213: ,p_count => x_msg_count
214: ,p_data => x_msg_data);
215:
216: WHEN OTHERS THEN
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','lock_sif_rets');
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);

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_RETS_PUB','lock_sif_rets');
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 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_rets;
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_rets;
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 297: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','lock_sif_rets');

293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
296: WHEN OTHERS THEN
297: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','lock_sif_rets');
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);

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_RETS_PUB','lock_sif_rets');
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 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_rets;
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_rets;
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 362: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','update_sif_rets');

358: ,p_count => x_msg_count
359: ,p_data => x_msg_data);
360:
361: WHEN OTHERS THEN
362: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','update_sif_rets');
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);

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_RETS_PUB','update_sif_rets');
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 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_rets;
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_rets;
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 453: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','update_sif_rets');

449: ,p_count => x_msg_count
450: ,p_data => x_msg_data);
451:
452: WHEN OTHERS THEN
453: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','update_sif_rets');
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);

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_RETS_PUB','update_sif_rets');
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 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_rets;
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_rets;
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 517: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','delete_sif_rets');

513: ,p_count => x_msg_count
514: ,p_data => x_msg_data);
515:
516: WHEN OTHERS THEN
517: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','delete_sif_rets');
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);

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_RETS_PUB','delete_sif_rets');
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 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_rets;
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_rets;
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 608: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','delete_sif_rets');

604: ,p_count => x_msg_count
605: ,p_data => x_msg_data);
606:
607: WHEN OTHERS THEN
608: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','delete_sif_rets');
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);

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_RETS_PUB','delete_sif_rets');
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 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_rets;
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_rets;
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 672: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','validate_sif_rets');

668: ,p_count => x_msg_count
669: ,p_data => x_msg_data);
670:
671: WHEN OTHERS THEN
672: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','validate_sif_rets');
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);

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_RETS_PUB','validate_sif_rets');
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 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_rets;
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_rets;
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 764: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','validate_sif_rets');

760: ,p_count => x_msg_count
761: ,p_data => x_msg_data);
762:
763: WHEN OTHERS THEN
764: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RETS_PUB','validate_sif_rets');
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);

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_RETS_PUB','validate_sif_rets');
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;