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

Line 60: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

56: ,x_bank_line_id1 OUT NOCOPY NUMBER
57: -- BANK-ACCOUNT-UPTAKE-START
58: )
59: IS
60: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
61: -- -----------------------------------------------------
62: -- Variable definitions for line level bill-to_support
63: -- -----------------------------------------------------
64: l_pmth_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

Line 213: IF (p_kle_id IS NOT NULL AND p_kle_id <> okl_api.g_miss_num) THEN

209: -- BANK-ACCOUNT-UPTAKE-START
210: x_creation_method_code := l_rct_line_method_code;
211: -- BANK-ACCOUNT-UPTAKE-END
212:
213: IF (p_kle_id IS NOT NULL AND p_kle_id <> okl_api.g_miss_num) THEN
214:
215: OPEN get_chr_id(p_kle_id);
216: FETCH get_chr_id INTO l_khr_id;
217: CLOSE get_chr_id;

Line 343: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

339: ,x_receipt_method_id OUT NOCOPY NUMBER
340: ,x_payment_trxn_extension_id OUT NOCOPY NUMBER
341: )
342: IS
343: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
344: lx_remrkt_sty_id number;
345:
346: BEGIN
347: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 373: IF l_return_status = Okl_Api.g_ret_sts_success THEN

369: lx_remrkt_sty_id);
370: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
371: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.nullout_rec_method.debug','Okl_Streams_Util.get_primary_stream_type returned l_return_status:'||l_return_status||' and lx_remrkt_sty_id:'||lx_remrkt_sty_id);
372: END IF;
373: IF l_return_status = Okl_Api.g_ret_sts_success THEN
374:
375: IF(lx_remrkt_sty_id = p_sty_id) THEN
376:
377: x_customer_bank_account_id := NULL;

Line 1044: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1040: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
1041: l_party_id hz_parties.party_id%type;
1042:
1043: BEGIN
1044: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1045: x_receipt_method_id := p_receipt_method_id;
1046: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1047: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_vendor_auto_bank_dtls.debug','p_api_version:'||p_api_version);
1048: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_vendor_auto_bank_dtls.debug','p_init_msg_list:'||p_init_msg_list);

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

1449: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','l_entity_id:'||l_entity_id);
1450: END IF;
1451: x_payment_trxn_extension_id := l_entity_id;
1452: ELSE
1453: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;

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

1451: x_payment_trxn_extension_id := l_entity_id;
1452: ELSE
1453: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;
1458: END IF;
1459:

Line 1468: x_return_status := OKL_API.G_RET_STS_ERROR;

1464: END IF;
1465:
1466: EXCEPTION
1467: WHEN FND_API.G_EXC_ERROR THEN
1468: x_return_status := OKL_API.G_RET_STS_ERROR;
1469: FND_MSG_PUB.Count_And_Get
1470: (p_count => x_msg_count,
1471: p_data => x_msg_data);
1472:

Line 1474: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1470: (p_count => x_msg_count,
1471: p_data => x_msg_data);
1472:
1473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1474: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1475: FND_MSG_PUB.Count_And_Get
1476: (p_count => x_msg_count,
1477: p_data => x_msg_data);
1478:

Line 1480: x_return_status := Okl_Api.G_RET_STS_ERROR;

1476: (p_count => x_msg_count,
1477: p_data => x_msg_data);
1478:
1479: WHEN OTHERS THEN
1480: x_return_status := Okl_Api.G_RET_STS_ERROR;
1481: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1482: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, SQLERRM);
1483: END IF;
1484: END get_vendor_auto_bank_dtls;

Line 1677: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1673: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;
1674:
1675: BEGIN
1676:
1677: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1678:
1679: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1680: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_auto_bank_dtls.debug','p_api_version:'||p_api_version);
1681: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_auto_bank_dtls.debug','p_init_msg_list:'||p_init_msg_list);

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

1842:
1843: -- Assign out variables
1844: x_payment_trxn_extension_id := l_entity_id;
1845: ELSE
1846: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1848: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1849: RAISE FND_API.G_EXC_ERROR;
1850: END IF;

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

1844: x_payment_trxn_extension_id := l_entity_id;
1845: ELSE
1846: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1848: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1849: RAISE FND_API.G_EXC_ERROR;
1850: END IF;
1851: END IF;
1852:

Line 1863: x_return_status := OKL_API.G_RET_STS_ERROR;

1859: END IF;
1860:
1861: EXCEPTION
1862: WHEN FND_API.G_EXC_ERROR THEN
1863: x_return_status := OKL_API.G_RET_STS_ERROR;
1864: FND_MSG_PUB.Count_And_Get
1865: (p_count => x_msg_count,
1866: p_data => x_msg_data);
1867:

Line 1869: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1865: (p_count => x_msg_count,
1866: p_data => x_msg_data);
1867:
1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1869: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1870: FND_MSG_PUB.Count_And_Get
1871: (p_count => x_msg_count,
1872: p_data => x_msg_data);
1873:

Line 1875: x_return_status := Okl_Api.G_RET_STS_ERROR;

1871: (p_count => x_msg_count,
1872: p_data => x_msg_data);
1873:
1874: WHEN OTHERS THEN
1875: x_return_status := Okl_Api.G_RET_STS_ERROR;
1876: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1877: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, SQLERRM);
1878: END IF;
1879: END get_auto_bank_dtls;

Line 2519: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2515: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','p_trx_date_to:'||p_trx_date_to);
2516: END IF;
2517:
2518:
2519: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2520:
2521: --start: | 15-FEB-07 cklee R12 Billing enhancement project
2522: OPEN acc_sys_option;
2523: FETCH acc_sys_option INTO G_ACC_SYS_OPTION;

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

3428: x_customer_bank_account_id => inv_lines_tbl(hdr_cnt).customer_bank_account_id,
3429: x_return_status => x_return_status,
3430: x_msg_count => x_msg_count,
3431: x_msg_data => x_msg_data);
3432: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3434: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3435: RAISE FND_API.G_EXC_ERROR;
3436: END IF;

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

3430: x_msg_count => x_msg_count,
3431: x_msg_data => x_msg_data);
3432: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3434: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3435: RAISE FND_API.G_EXC_ERROR;
3436: END IF;
3437: -- For Automatic receipt method, bank account id should be NULL as the column is obsoleted
3438: l_xfer_tbl(k).CUSTOMER_BANK_ACCOUNT_ID := NULL;

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

3517: x_msg_count => x_msg_count,
3518: x_msg_data => x_msg_data
3519: );
3520: END IF;
3521: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3523: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3524: RAISE FND_API.G_EXC_ERROR;
3525: END IF;

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

3519: );
3520: END IF;
3521: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3523: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3524: RAISE FND_API.G_EXC_ERROR;
3525: END IF;
3526:
3527: -- For Automatic receipt method, bank account id should be NULL as the column is obsoleted

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

3717: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','okl_process_sales_tax_pvt.get_tax_determinants returned with x_return_status:'||x_return_status);
3718: END IF;
3719:
3720:
3721: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3723: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3724: RAISE FND_API.G_EXC_ERROR;
3725: END IF;

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

3719:
3720:
3721: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3723: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3724: RAISE FND_API.G_EXC_ERROR;
3725: END IF;
3726: --akrangan code fix begin
3727: --added to eliminate tax attributes for tax only invoices

Line 4799: x_return_status := OKL_API.G_RET_STS_ERROR;

4795: END LOOP;
4796: END IF;
4797:
4798: WHEN FND_API.G_EXC_ERROR THEN
4799: x_return_status := OKL_API.G_RET_STS_ERROR;
4800: FND_MSG_PUB.Count_And_Get
4801: (p_count => x_msg_count,
4802: p_data => x_msg_data);
4803:

Line 4817: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

4813: END LOOP;
4814: END IF;
4815:
4816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4817: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4818: FND_MSG_PUB.Count_And_Get
4819: (p_count => x_msg_count,
4820: p_data => x_msg_data);
4821:

Line 4835: x_return_status := Okl_Api.G_RET_STS_ERROR;

4831: END LOOP;
4832: END IF;
4833:
4834: WHEN OTHERS THEN
4835: x_return_status := Okl_Api.G_RET_STS_ERROR;
4836: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4837: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'INSERT Failed ' || SQLERRM);
4838: END IF;
4839: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN