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

Line 106: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

102: ------------------------------------------------------------
103:
104: l_api_version CONSTANT NUMBER := 1;
105: l_api_name CONSTANT VARCHAR2(30) := 'pay_ins_payments';
106: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
107: l_msg_data VARCHAR2(2000);
108: l_msg_count NUMBER := 0 ;
109:
110: l_selv_rec Okl_Streams_Pub.selv_rec_type;

Line 235: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

231: ------------------------------------------------------------
232: -- Exception handling
233: ------------------------------------------------------------
234:
235: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
236: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
237:
238: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
239: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);

Line 238: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

234:
235: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
236: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
237:
238: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
239: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
240:
241: WHEN OTHERS THEN
242: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);

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

317: x_retrun_status := OKC_API.G_RET_STS_ERROR ;
318: END IF;
319: EXCEPTION
320: WHEN OTHERS THEN
321: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
323: FND_MSG_PUB.ADD;
324: ROLLBACK TO create_third_party_task_event;
325: x_retrun_status := OKC_API.G_RET_STS_UNEXP_ERROR ;

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

467: x_return_status => l_return_status,
468:
469: x_msg_count => l_msg_count,
470: x_msg_data => l_msg_data);
471: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
472: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'No Document is selected');
473: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
474: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'Unexpected Exception');
475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

469: x_msg_count => l_msg_count,
470: x_msg_data => l_msg_data);
471: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
472: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'No Document is selected');
473: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
474: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'Unexpected Exception');
475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
476: END IF;
477:

Line 475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

471: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
472: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'No Document is selected');
473: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
474: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'Unexpected Exception');
475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
476: END IF;
477:
478: END IF;
479:

Line 486: WHEN OKL_API.G_EXCEPTION_ERROR THEN

482: END IF;
483:
484: EXCEPTION
485:
486: WHEN OKL_API.G_EXCEPTION_ERROR THEN
487: --ROLLBACK TO create_fulfillment;
488: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
489:
490: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 488: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

484: EXCEPTION
485:
486: WHEN OKL_API.G_EXCEPTION_ERROR THEN
487: --ROLLBACK TO create_fulfillment;
488: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
489:
490: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
491: --ROLLBACK TO create_fulfillment;
492: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 490: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

486: WHEN OKL_API.G_EXCEPTION_ERROR THEN
487: --ROLLBACK TO create_fulfillment;
488: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
489:
490: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
491: --ROLLBACK TO create_fulfillment;
492: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
493:
494: WHEN OTHERS THEN

Line 492: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

488: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
489:
490: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
491: --ROLLBACK TO create_fulfillment;
492: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
493:
494: WHEN OTHERS THEN
495: --ROLLBACK TO create_fulfillment;
496: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 496: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

492: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
493:
494: WHEN OTHERS THEN
495: --ROLLBACK TO create_fulfillment;
496: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
497:
498: end pol_exp_notification ;
499:
500: /* $Header: OKLRICXB.pls 120.18 2007/10/10 11:21:06 zrehman noship $ */

Line 527: OKL_API.set_message(G_APP_NAME,

523: OPEN okc_k_status_csr(p_khr_id);
524: FETCH okc_k_status_csr INTO x_contract_status ;
525: IF(okc_k_status_csr%NOTFOUND) THEN
526: -- store SQL error message on message stack for caller
527: OKL_API.set_message(G_APP_NAME,
528: 'OKL_INVALID_CONTRACT_STATUS'
529: );
530: CLOSE okc_k_status_csr ;
531: l_return_status := OKC_API.G_RET_STS_ERROR;

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

846: x_request_id => lx_request_id,
847: x_return_status => l_return_status,
848: x_msg_count => l_msg_count,
849: x_msg_data => l_msg_data);
850: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
851: FOR i IN 1..l_msg_count LOOP
852: JTF_PLSQL_API.get_messages(i,l_msg_data);
853: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
854: END LOOP;

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

851: FOR i IN 1..l_msg_count LOOP
852: JTF_PLSQL_API.get_messages(i,l_msg_data);
853: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
854: END LOOP;
855: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
856: FOR i IN 1..l_msg_count LOOP
857: JTF_PLSQL_API.get_messages(i,l_msg_data);
858: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
859: END LOOP;

Line 860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

856: FOR i IN 1..l_msg_count LOOP
857: JTF_PLSQL_API.get_messages(i,l_msg_data);
858: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,l_msg_data );
859: END LOOP;
860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
861: END IF;
862:
863:
864:

Line 870: WHEN OKL_API.G_EXCEPTION_ERROR THEN

866: CLOSE okl_eli_3rdpolicies_csr ;
867:
868: EXCEPTION
869:
870: WHEN OKL_API.G_EXCEPTION_ERROR THEN
871: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
872:
873: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
874: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 871: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

867:
868: EXCEPTION
869:
870: WHEN OKL_API.G_EXCEPTION_ERROR THEN
871: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
872:
873: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
874: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
875: WHEN OTHERS THEN

Line 873: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

869:
870: WHEN OKL_API.G_EXCEPTION_ERROR THEN
871: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
872:
873: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
874: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
875: WHEN OTHERS THEN
876: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
877:

Line 874: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

870: WHEN OKL_API.G_EXCEPTION_ERROR THEN
871: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
872:
873: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
874: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
875: WHEN OTHERS THEN
876: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
877:
878: end third_party_ins_followup ;

Line 876: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

872:
873: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
874: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
875: WHEN OTHERS THEN
876: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
877:
878: end third_party_ins_followup ;
879:
880: -- Start of comments