DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on FND_API

Line 766: -- This values based on global variables from FND_API G_TRUE and G_FALSE;

762: l_pmt_channel IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
763: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.trxnextension_rec_type;
764: l_entity_id NUMBER;
765: l_response IBY_FNDCPT_COMMON_PUB.result_rec_type;
766: -- This values based on global variables from FND_API G_TRUE and G_FALSE;
767: l_true VARCHAR2(1) := 'T';
768:
769: CURSOR instr_type_csr(p_instr_use_id NUMBER)
770: IS

Line 930: RAISE FND_API.G_EXC_ERROR;

926: -- for which contract it is failing
927: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);
928: fnd_message.set_name('AR', 'AR_RAXTRX-1763');
929: fnd_msg_pub.add;
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932:
933: OPEN instrument_id_csr(l_instrument_payment_use_id);
934: FETCH instrument_id_csr INTO l_instrument_id;

Line 985: -- The values are based on FND_API. S, E, U (Success, Error, Unexpected

981: x_entity_id => l_entity_id,
982: x_response => l_response);
983:
984:
985: -- The values are based on FND_API. S, E, U (Success, Error, Unexpected
986: IF (x_return_status = 'S') THEN
987: okl_debug_pub.logmessage('AUTOINVOICE:Transaction Extension Id: '|| l_entity_id);
988: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
989: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','l_entity_id:'||l_entity_id);

Line 996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1000: END IF;

Line 998: RAISE FND_API.G_EXC_ERROR;

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:
1002: -- For a receipt method code of 'automatic', customer bank account id column is not used

Line 1011: WHEN FND_API.G_EXC_ERROR THEN

1007: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_auto_bank_dtls.debug','x_customer_bank_account_id:'||x_customer_bank_account_id);
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);

Line 1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1013: FND_MSG_PUB.Count_And_Get
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);

Line 2340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
2344:

Line 2342: RAISE FND_API.G_EXC_ERROR;

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
2346: l_xfer_tbl(k).CUSTOMER_BANK_ACCOUNT_ID := NULL;

Line 2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
2502: --akrangan code fix begin

Line 2500: RAISE FND_API.G_EXC_ERROR;

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
2504: IF l_xfer_tbl(k).OKL_SOURCE_BILLING_TRX <> 'TAX_ONLY_INVOICE_TAX' THEN

Line 3396: WHEN FND_API.G_EXC_ERROR THEN

3392: END IF;
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);

Line 3414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3410: FND_FILE.put_line(fnd_file.log,'ERROR (OKL_ARIntf_Pvt.Get_REC_FEEDER): ' || lx_msg_data);
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);