DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on FND_API

Line 1246: RAISE FND_API.G_EXC_ERROR;

1242: --for which contract it is failing
1243: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);
1244: fnd_message.set_name('AR', 'AR_RAXTRX-1763');
1245: fnd_msg_pub.add;
1246: RAISE FND_API.G_EXC_ERROR;
1247: END IF;
1248: OPEN instrument_id_csr(l_instrument_payment_use_id);
1249: FETCH instrument_id_csr INTO l_instrument_id;
1250: CLOSE instrument_id_csr;

Line 1342: RAISE FND_API.G_EXC_ERROR;

1338: --for which contract it is failing
1339: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);
1340: fnd_message.set_name('AR', 'AR_RAXTRX-1763');
1341: fnd_msg_pub.add;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;
1344: --Else payment method is not defined in parties tab
1345: --Hence derive from vendor account or site level
1346: ELSE

Line 1400: RAISE FND_API.G_EXC_ERROR;

1396: --for which contract it is failing
1397: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);
1398: fnd_message.set_name('AR', 'AR_RAXTRX-1763');
1399: fnd_msg_pub.add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: END IF;
1403: END IF;
1404:

Line 1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1456: RAISE FND_API.G_EXC_ERROR;

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:
1460: x_customer_bank_account_id := null;

Line 1467: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

1523: l_pmt_channel IBY_FNDCPT_PMT_CHNNLS_VL.payment_channel_code%TYPE;
1524: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.trxnextension_rec_type;
1525: l_entity_id NUMBER;
1526: l_response IBY_FNDCPT_COMMON_PUB.result_rec_type;
1527: -- This values based on global variables from FND_API G_TRUE and G_FALSE;
1528: l_true VARCHAR2(1) := 'T';
1529: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
1530: l_party_id hz_parties.party_id%type;
1531:

Line 1772: RAISE FND_API.G_EXC_ERROR;

1768: -- for which contract it is failing
1769: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);
1770: fnd_message.set_name('AR', 'AR_RAXTRX-1763');
1771: fnd_msg_pub.add;
1772: RAISE FND_API.G_EXC_ERROR;
1773: END IF;
1774:
1775: OPEN instrument_id_csr(l_instrument_payment_use_id);
1776: FETCH instrument_id_csr INTO l_instrument_id;

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

1832: p_instr_assignment => l_instrument_payment_use_id, --sosharma bug 6608452
1833: p_trxn_attribs => l_trxn_attribs,
1834: x_entity_id => l_entity_id,
1835: x_response => l_response);
1836: -- The values are based on FND_API. S, E, U (Success, Error, Unexpected
1837: IF (x_return_status = 'S') THEN
1838: okl_debug_pub.logmessage('AUTOINVOICE:Transaction Extension Id: '|| l_entity_id);
1839: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1840: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','l_entity_id:'||l_entity_id);

Line 1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1849: RAISE FND_API.G_EXC_ERROR;

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

Line 1862: WHEN FND_API.G_EXC_ERROR THEN

1858: 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);
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);

Line 1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
3437: -- For Automatic receipt method, bank account id should be NULL as the column is obsoleted

Line 3435: RAISE FND_API.G_EXC_ERROR;

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

Line 3522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3524: RAISE FND_API.G_EXC_ERROR;

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

Line 3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3724: RAISE FND_API.G_EXC_ERROR;

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

Line 4798: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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