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

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

133: -- Declare variables required by APIs
134: ------------------------------------------------------------
135: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ADJUSTMENT_INVOICE';
136: l_api_version CONSTANT NUMBER := 1;
137: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
138: l_error_status VARCHAR2(1);
139: l_error_message VARCHAR2(2000);
140: l_op_unit_name hr_operating_units.name%TYPE;
141: l_request_id VARCHAR2(100);

Line 288: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

284: ------------------------------------------------------------
285: -- Start processing
286: ------------------------------------------------------------
287:
288: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
289:
290: l_return_status := Okl_Api.START_ACTIVITY(
291: p_api_name => l_api_name,
292: p_pkg_name => G_PKG_NAME,

Line 290: l_return_status := Okl_Api.START_ACTIVITY(

286: ------------------------------------------------------------
287:
288: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
289:
290: l_return_status := Okl_Api.START_ACTIVITY(
291: p_api_name => l_api_name,
292: p_pkg_name => G_PKG_NAME,
293: p_init_msg_list => p_init_msg_list,
294: l_api_version => l_api_version,

Line 299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

295: p_api_version => p_api_version,
296: p_api_type => '_PVT',
297: x_return_status => l_return_status);
298:
299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
300: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
301: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
302: RAISE Okl_Api.G_EXCEPTION_ERROR;
303: END IF;

Line 300: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

296: p_api_type => '_PVT',
297: x_return_status => l_return_status);
298:
299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
300: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
301: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
302: RAISE Okl_Api.G_EXCEPTION_ERROR;
303: END IF;
304:

Line 301: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

297: x_return_status => l_return_status);
298:
299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
300: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
301: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
302: RAISE Okl_Api.G_EXCEPTION_ERROR;
303: END IF;
304:
305: ------------------------------------------

Line 302: RAISE Okl_Api.G_EXCEPTION_ERROR;

298:
299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
300: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
301: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
302: RAISE Okl_Api.G_EXCEPTION_ERROR;
303: END IF;
304:
305: ------------------------------------------
306: -- Get try_id for estimated property tax

Line 423: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

419: ,x_msg_data => x_msg_data
420: ,p_tcnv_rec => l_trxH_in_rec
421: ,x_tcnv_rec => l_trxH_out_rec);
422:
423: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
424: l_error_status := 'E';
425: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';
426: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating header record in OKL_TRX_CONTRACTS');
427: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

Line 427: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

423: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
424: l_error_status := 'E';
425: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';
426: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating header record in OKL_TRX_CONTRACTS');
427: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
428: l_error_status := 'E';
429: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';
430: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating header record in OKL_TRX_CONTRACTS');
431: END IF;

Line 509: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

505: x_msg_data => x_msg_data,
506: p_stmv_rec => l_stmv_rec,
507: x_stmv_rec => lx_stmv_rec);
508:
509: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
510: l_error_status := 'E';
511: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';
512: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Streams for Adjusted Property Tax');
513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

509: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
510: l_error_status := 'E';
511: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';
512: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Streams for Adjusted Property Tax');
513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
514: l_error_status := 'E';
515: l_error_message := 'Error: Creating Streams for Adjusted Property Tax';
516: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Streams for Adjusted Property Tax');
517: END IF;

Line 560: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

556: ELSE
557: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Stream Element not created because adjustment amount is zero.');
558: END IF;
559:
560: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
561: l_error_status := 'E';
562: l_error_message := 'Error: Creating Adjusted Property Tax stream element';
563: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Adjusted Property Tax stream element');
564: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 564: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

560: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
561: l_error_status := 'E';
562: l_error_message := 'Error: Creating Adjusted Property Tax stream element';
563: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Adjusted Property Tax stream element');
564: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
565: l_error_status := 'E';
566: l_error_message := 'Error: Creating Adjusted Property Tax stream element';
567: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Adjusted Property Tax stream element');
568: END IF;

Line 667: Okl_Api.END_ACTIVITY (

663: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('=', 132, '='));
664: ------------------------------------------------------------
665: -- End processing
666: ------------------------------------------------------------
667: Okl_Api.END_ACTIVITY (
668: x_msg_count => x_msg_count,
669: x_msg_data => x_msg_data);
670:
671: EXCEPTION

Line 677: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

673: ------------------------------------------------------------
674: -- Exception handling
675: ------------------------------------------------------------
676:
677: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
678: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);
679: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
680: p_api_name => l_api_name,
681: p_pkg_name => G_PKG_NAME,

Line 679: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

675: ------------------------------------------------------------
676:
677: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
678: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);
679: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
680: p_api_name => l_api_name,
681: p_pkg_name => G_PKG_NAME,
682: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
683: x_msg_count => x_msg_count,

Line 682: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

678: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);
679: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
680: p_api_name => l_api_name,
681: p_pkg_name => G_PKG_NAME,
682: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
683: x_msg_count => x_msg_count,
684: x_msg_data => x_msg_data,
685: p_api_type => '_PVT');
686:

Line 687: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

683: x_msg_count => x_msg_count,
684: x_msg_data => x_msg_data,
685: p_api_type => '_PVT');
686:
687: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
688: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXP) => '||SQLERRM);
689: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
690: p_api_name => l_api_name,
691: p_pkg_name => G_PKG_NAME,

Line 689: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

685: p_api_type => '_PVT');
686:
687: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
688: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXP) => '||SQLERRM);
689: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
690: p_api_name => l_api_name,
691: p_pkg_name => G_PKG_NAME,
692: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
693: x_msg_count => x_msg_count,

Line 692: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

688: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXP) => '||SQLERRM);
689: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
690: p_api_name => l_api_name,
691: p_pkg_name => G_PKG_NAME,
692: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data,
695: p_api_type => '_PVT');
696:

Line 699: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

695: p_api_type => '_PVT');
696:
697: WHEN OTHERS THEN
698: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (OTHERS) => '||SQLERRM);
699: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
700: p_api_name => l_api_name,
701: p_pkg_name => G_PKG_NAME,
702: p_exc_name => 'OTHERS',
703: x_msg_count => x_msg_count,