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_TRX_CONTRACTS

Line 42: FROM okl_trx_contracts trx

38: AND astb.id = astl.id
39: AND astl.LANGUAGE = userenv('LANG')
40: AND NOT EXISTS
41: (SELECT khr_id
42: FROM okl_trx_contracts trx
43: WHERE trx.khr_id = khr.id
44: AND(source_trx_id IS NULL OR source_trx_id = astb.id)
45: AND trx.tcn_type = 'EPT'
46: AND trx.tsu_code = 'PROCESSED'

Line 147: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

143: ------------------------------------------------------------
144: -- Local Variables
145: ------------------------------------------------------------
146: l_try_id NUMBER;
147: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
148: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
149: l_actual_tax_amt NUMBER;
150: l_estimated_tax_amt NUMBER;
151: l_adjusted_amt NUMBER;

Line 148: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

144: -- Local Variables
145: ------------------------------------------------------------
146: l_try_id NUMBER;
147: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
148: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
149: l_actual_tax_amt NUMBER;
150: l_estimated_tax_amt NUMBER;
151: l_adjusted_amt NUMBER;
152: l_sty_id NUMBER;

Line 414: Okl_Trx_Contracts_Pub.create_trx_contracts(

410: l_trxH_in_rec.SOURCE_TRX_ID := term_contracts_rec.kle_id;
411: l_trxH_in_rec.SOURCE_TRX_TYPE := 'KLE';
412:
413: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Contract Transaction.');
414: Okl_Trx_Contracts_Pub.create_trx_contracts(
415: p_api_version => l_api_version
416: ,p_init_msg_list => p_init_msg_list
417: ,x_return_status => l_return_status
418: ,x_msg_count => x_msg_count

Line 425: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';

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
428: l_error_status := 'E';
429: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';

Line 426: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating header record in OKL_TRX_CONTRACTS');

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
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');

Line 429: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';

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;
432:
433:

Line 430: FND_FILE.PUT_LINE (FND_FILE.LOG,'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;
432:
433:
434: -- -------------------------------------------------

Line 511: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';

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
514: l_error_status := 'E';
515: l_error_message := 'Error: Creating Streams for Adjusted Property Tax';

Line 629: UPDATE OKL_TRX_CONTRACTS

625: AND (l_estimated_tax_amt = 0)
626: AND (l_adjusted_amt = 0)
627: )
628: THEN
629: UPDATE OKL_TRX_CONTRACTS
630: SET TSU_CODE = 'ERROR'
631: WHERE ID = l_trxH_out_rec.ID;
632: ELSE
633: UPDATE OKL_TRX_CONTRACTS

Line 633: UPDATE OKL_TRX_CONTRACTS

629: UPDATE OKL_TRX_CONTRACTS
630: SET TSU_CODE = 'ERROR'
631: WHERE ID = l_trxH_out_rec.ID;
632: ELSE
633: UPDATE OKL_TRX_CONTRACTS
634: SET TSU_CODE = 'PROCESSED'
635: WHERE ID = l_trxH_out_rec.ID;
636: END IF;
637: -- -------------------------------

Line 651: UPDATE OKL_TRX_CONTRACTS

647: lpad(SUBSTR(succ_tbl(i).adj_tax,1,22),22,' ')
648: );
649: END LOOP;
650: ELSE
651: UPDATE OKL_TRX_CONTRACTS
652: SET TSU_CODE = 'ERROR'
653: WHERE ID = l_trxH_out_rec.ID;
654: END IF;
655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));