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 372: IF l_return_status = Okl_Api.g_ret_sts_success THEN

368: lx_remrkt_sty_id);
369: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
370: 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);
371: END IF;
372: IF l_return_status = Okl_Api.g_ret_sts_success THEN
373:
374: IF(lx_remrkt_sty_id = p_sty_id) THEN
375:
376: x_customer_bank_account_id := NULL;

Line 877: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

873: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;
874:
875: BEGIN
876:
877: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
878:
879: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
880: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_auto_bank_dtls.debug','p_api_version:'||p_api_version);
881: 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 995: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

991:
992: -- Assign out variables
993: x_payment_trxn_extension_id := l_entity_id;
994: ELSE
995: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;

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

993: x_payment_trxn_extension_id := l_entity_id;
994: ELSE
995: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000: END IF;
1001:

Line 1012: x_return_status := OKL_API.G_RET_STS_ERROR;

1008: END IF;
1009:
1010: EXCEPTION
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: x_return_status := OKL_API.G_RET_STS_ERROR;
1013: FND_MSG_PUB.Count_And_Get
1014: (p_count => x_msg_count,
1015: p_data => x_msg_data);
1016:

Line 1018: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1014: (p_count => x_msg_count,
1015: p_data => x_msg_data);
1016:
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1019: FND_MSG_PUB.Count_And_Get
1020: (p_count => x_msg_count,
1021: p_data => x_msg_data);
1022:

Line 1024: x_return_status := Okl_Api.G_RET_STS_ERROR;

1020: (p_count => x_msg_count,
1021: p_data => x_msg_data);
1022:
1023: WHEN OTHERS THEN
1024: x_return_status := Okl_Api.G_RET_STS_ERROR;
1025: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1026: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, SQLERRM);
1027: END IF;
1028: END get_auto_bank_dtls;

Line 1506: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1502: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','p_trx_date_to:'||p_trx_date_to);
1503: END IF;
1504:
1505:
1506: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1507:
1508: --start: | 15-FEB-07 cklee R12 Billing enhancement project
1509: OPEN acc_sys_option;
1510: FETCH acc_sys_option INTO G_ACC_SYS_OPTION;

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

2335: x_return_status => x_return_status,
2336: x_msg_count => x_msg_count,
2337: x_msg_data => x_msg_data
2338: );
2339: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2341: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;

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

2337: x_msg_data => x_msg_data
2338: );
2339: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2341: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;
2344:
2345: -- For Automatic receipt method, bank account id should be NULL as the column is obsoleted

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

2493: 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);
2494: END IF;
2495:
2496:
2497: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2499: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2500: RAISE FND_API.G_EXC_ERROR;
2501: END IF;

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

2495:
2496:
2497: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2499: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2500: RAISE FND_API.G_EXC_ERROR;
2501: END IF;
2502: --akrangan code fix begin
2503: --added to eliminate tax attributes for tax only invoices

Line 3397: x_return_status := OKL_API.G_RET_STS_ERROR;

3393: END LOOP;
3394: END IF;
3395:
3396: WHEN FND_API.G_EXC_ERROR THEN
3397: x_return_status := OKL_API.G_RET_STS_ERROR;
3398: FND_MSG_PUB.Count_And_Get
3399: (p_count => x_msg_count,
3400: p_data => x_msg_data);
3401:

Line 3415: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

3411: END LOOP;
3412: END IF;
3413:
3414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3415: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3416: FND_MSG_PUB.Count_And_Get
3417: (p_count => x_msg_count,
3418: p_data => x_msg_data);
3419:

Line 3433: x_return_status := Okl_Api.G_RET_STS_ERROR;

3429: END LOOP;
3430: END IF;
3431:
3432: WHEN OTHERS THEN
3433: x_return_status := Okl_Api.G_RET_STS_ERROR;
3434: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3435: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'INSERT Failed ' || SQLERRM);
3436: END IF;
3437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN