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

Line 73: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

69: END IF;
70:
71: EXCEPTION
72: WHEN OTHERS THEN
73: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
74: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
75: FND_MSG_PUB.ADD;
76: IF okl_key_csr%ISOPEN THEN
77: CLOSE okl_key_csr;

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

143: x_return_status := l_return_status;
144: x_msg_count := l_msg_count;
145: x_msg_data := l_msg_data;
146:
147: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: END IF;

Line 148: RAISE OKL_API.G_EXCEPTION_ERROR;

144: x_msg_count := l_msg_count;
145: x_msg_data := l_msg_data;
146:
147: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: END IF;
152:

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

145: x_msg_data := l_msg_data;
146:
147: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: END IF;
152:
153: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

146:
147: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: END IF;
152:
153: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 167: WHEN OKL_API.G_EXCEPTION_ERROR THEN

163: p_requestor_id);
164:
165: EXCEPTION
166:
167: WHEN OKL_API.G_EXCEPTION_ERROR THEN
168: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
170: p_data => x_msg_data);
171:

Line 168: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

164:
165: EXCEPTION
166:
167: WHEN OKL_API.G_EXCEPTION_ERROR THEN
168: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
170: p_data => x_msg_data);
171:
172: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

174: 'OKL_VSS_WF.createRepurchaseQuote.',
175: 'EXP - G_EXCEPTION_ERROR');
176: END IF;
177:
178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
179: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
180: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
181: p_data => x_msg_data);
182: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 179: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

175: 'EXP - G_EXCEPTION_ERROR');
176: END IF;
177:
178: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
179: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
180: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
181: p_data => x_msg_data);
182: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

185: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
186: END IF;
187:
188: WHEN OTHERS THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
190: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','update_counter');
191: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
192: p_data => x_msg_data);
193: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

540: p_cntr_bill_tbl => l_cntr_bill_tbl,
541: x_cntr_bill_tbl => x_cntr_bill_tbl
542: );
543:
544: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
548: END IF;

Line 545: RAISE OKL_API.G_EXCEPTION_ERROR;

541: x_cntr_bill_tbl => x_cntr_bill_tbl
542: );
543:
544: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
548: END IF;
549:

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

542: );
543:
544: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
548: END IF;
549:
550: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

543:
544: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
548: END IF;
549:
550: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 558: WHEN OKL_API.G_EXCEPTION_ERROR THEN

554: END IF;
555:
556: EXCEPTION
557:
558: WHEN OKL_API.G_EXCEPTION_ERROR THEN
559: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
560: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
561: p_data => x_msg_data);
562: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 559: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

555:
556: EXCEPTION
557:
558: WHEN OKL_API.G_EXCEPTION_ERROR THEN
559: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
560: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
561: p_data => x_msg_data);
562: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 568: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

564: 'OKL_VSS_WF.update_counter.',
565: 'EXP - G_EXCEPTION_ERROR');
566: END IF;
567:
568: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
569: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
571: p_data => x_msg_data);
572: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 569: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

565: 'EXP - G_EXCEPTION_ERROR');
566: END IF;
567:
568: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
569: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
571: p_data => x_msg_data);
572: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 579: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

575: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
576: END IF;
577:
578: WHEN OTHERS THEN
579: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
580: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','update_counter');
581: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
582: p_data => x_msg_data);
583:

Line 873: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

869:
870:
871: l_id VARCHAR2(100);
872: l_approved VARCHAR2(1);
873: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
874: x_msg_count NUMBER;
875: x_msg_data VARCHAR2(2000);
876: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
877: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;

Line 996: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

992:
993:
994: l_id VARCHAR2(100);
995: l_approved VARCHAR2(1);
996: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
997: x_msg_count NUMBER;
998: x_msg_data VARCHAR2(2000);
999: p_qtev_rec OKL_QTE_PVT.qtev_rec_type;
1000: x_qtev_rec OKL_QTE_PVT.qtev_rec_type;