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

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

12: ,p_receipt_type IN OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT NULL
13: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
14: ) IS
15:
16: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
17: l_api_name CONSTANT VARCHAR2(30) := 'ADVANCED_CASH_APP';
18: l_api_version NUMBER := 1;
19: l_init_msg_list VARCHAR2(1);
20: l_msg_count NUMBER;

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

110: ,p_receipt_type IN VARCHAR2 DEFAULT NULL
111: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
112: ) IS
113:
114: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
115: l_api_name CONSTANT VARCHAR2(30) := 'REAPPLIC_ADVANCED_CASH_APP';
116: l_api_version NUMBER := 1;
117: l_init_msg_list VARCHAR2(1);
118: l_msg_count NUMBER;

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

212: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
213: ) IS
214:
215: l_api_version NUMBER := 1;
216: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
217: l_msg_count NUMBER;
218: l_msg_data VARCHAR2(450);
219: l_init_msg_list VARCHAR2(1);
220:

Line 291: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

287: ,p_receipt_date_to => l_receipt_date_to
288: ,p_receipt_type => l_receipt_type
289: ,p_cross_currency_allowed => l_cross_currency_allowed
290: );
291: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
292: fnd_file.put_line(fnd_file.log
293: ,'Unexpected error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_ADVANCED_CASH_APP ');
294: RAISE okl_api.g_exception_unexpected_error;
295: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

Line 294: RAISE okl_api.g_exception_unexpected_error;

290: );
291: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
292: fnd_file.put_line(fnd_file.log
293: ,'Unexpected error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_ADVANCED_CASH_APP ');
294: RAISE okl_api.g_exception_unexpected_error;
295: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
296: fnd_file.put_line(fnd_file.log
297: ,'Error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_ADVANCED_CASH_APP ');
298: RAISE okl_api.g_exception_error;

Line 295: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

291: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
292: fnd_file.put_line(fnd_file.log
293: ,'Unexpected error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_ADVANCED_CASH_APP ');
294: RAISE okl_api.g_exception_unexpected_error;
295: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
296: fnd_file.put_line(fnd_file.log
297: ,'Error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_ADVANCED_CASH_APP ');
298: RAISE okl_api.g_exception_error;
299: END IF;

Line 298: RAISE okl_api.g_exception_error;

294: RAISE okl_api.g_exception_unexpected_error;
295: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
296: fnd_file.put_line(fnd_file.log
297: ,'Error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_ADVANCED_CASH_APP ');
298: RAISE okl_api.g_exception_error;
299: END IF;
300:
301: BEGIN
302:

Line 318: WHEN okl_api.g_exception_error THEN

314: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
315: END;
316: retcode := 0;
317: EXCEPTION
318: WHEN okl_api.g_exception_error THEN
319: retcode := 2;
320: -- print the error message in the output file
321:
322: IF (fnd_msg_pub.count_msg > 0) THEN

Line 334: WHEN okl_api.g_exception_unexpected_error THEN

330: END LOOP;
331:
332: END IF;
333:
334: WHEN okl_api.g_exception_unexpected_error THEN
335: retcode := 2;
336:
337: -- print the error message in the output file
338:

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

377: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
378: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
379: )IS
380:
381: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
382: l_api_name CONSTANT VARCHAR2(30) := 'REAPPLIC_RCPT_W_CNTRCT';
383: l_api_version NUMBER := 1;
384: l_init_msg_list VARCHAR2(1);
385: l_msg_count NUMBER;

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

463: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
464: ) IS
465:
466: l_api_version NUMBER := 1;
467: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
468: l_msg_count NUMBER;
469: l_msg_data VARCHAR2(450);
470: l_init_msg_list VARCHAR2(1);
471:

Line 516: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

512: ,p_contract_num => l_contract_num
513: ,p_customer_num => l_customer_num
514: ,p_cross_currency_allowed => l_cross_currency_allowed
515: );
516: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
517: fnd_file.put_line(fnd_file.log
518: ,'Unexpected error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_RCPT_W_CNTRCT');
519: RAISE okl_api.g_exception_unexpected_error;
520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

Line 519: RAISE okl_api.g_exception_unexpected_error;

515: );
516: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
517: fnd_file.put_line(fnd_file.log
518: ,'Unexpected error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_RCPT_W_CNTRCT');
519: RAISE okl_api.g_exception_unexpected_error;
520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
521: fnd_file.put_line(fnd_file.log
522: ,'Error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_RCPT_W_CNTRCT');
523: END IF;

Line 520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

516: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
517: fnd_file.put_line(fnd_file.log
518: ,'Unexpected error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_RCPT_W_CNTRCT');
519: RAISE okl_api.g_exception_unexpected_error;
520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
521: fnd_file.put_line(fnd_file.log
522: ,'Error in call to OKL_BPD_ADVANCED_CASH_APP_PUB.REAPPLIC_RCPT_W_CNTRCT');
523: END IF;
524:

Line 544: WHEN okl_api.g_exception_error THEN

540: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
541: END;
542: retcode := 0;
543: EXCEPTION
544: WHEN okl_api.g_exception_error THEN
545: retcode := 2;
546: -- print the error message in the output file
547:
548: IF (fnd_msg_pub.count_msg > 0) THEN

Line 560: WHEN okl_api.g_exception_unexpected_error THEN

556: END LOOP;
557:
558: END IF;
559:
560: WHEN okl_api.g_exception_unexpected_error THEN
561: retcode := 2;
562:
563: -- print the error message in the output file
564:

Line 665: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

661: );
662:
663: x_return_status := l_return_status;
664:
665: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
667: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_ERROR;
669: END IF;

Line 666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

662:
663: x_return_status := l_return_status;
664:
665: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
667: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_ERROR;
669: END IF;
670:

Line 667: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

663: x_return_status := l_return_status;
664:
665: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
667: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_ERROR;
669: END IF;
670:
671: -- p_remain_rcpt_amount := l_receipt_amount;

Line 668: RAISE OKL_API.G_EXCEPTION_ERROR;

664:
665: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
667: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_ERROR;
669: END IF;
670:
671: -- p_remain_rcpt_amount := l_receipt_amount;
672: