DBA Data[Home] [Help]

APPS.AR_DEPOSIT_API_PUB dependencies on FND_MESSAGE

Line 202: | FND_MESSAGE.SET_NAME

198: | ar_deposit_lib_pvt.Validate_Desc_Flexfield
199: | ar_deposit_lib_pvt.get_doc_seq
200: | FND_MSG_PUB.Count_And_Get
201: | arp_process_header_insrt_cover.insert_header_cover
202: | FND_MESSAGE.SET_NAME
203: | FND_MSG_PUB.Add;
204: | arp_process_header.post_commit
205: |
206: | PARAMETERS

Line 1029: FND_MESSAGE.SET_NAME('AR','AR_DAPI_TRANS_TYPE_NULL');

1025:
1026: IF l_cust_trx_type_id is NULL and
1027: l_default_cust_trx_type_id is NULL THEN
1028:
1029: FND_MESSAGE.SET_NAME('AR','AR_DAPI_TRANS_TYPE_NULL');
1030: FND_MSG_PUB.Add;
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: ELSIF l_cust_trx_type_id is NULL and l_default_cust_trx_type_id is NOT NULL THEN
1033: BEGIN

Line 1045: FND_MESSAGE.SET_NAME('AR','AR_DAPI_TRANS_TYPE_NULL');

1041: cust_trx_type_id = l_default_cust_trx_type_id;
1042: EXCEPTION
1043:
1044: WHEN NO_DATA_FOUND THEN
1045: FND_MESSAGE.SET_NAME('AR','AR_DAPI_TRANS_TYPE_NULL');
1046: FND_MSG_PUB.Add;
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: WHEN OTHERS THEN
1049: RAISE;

Line 1238: FND_MESSAGE.SET_NAME('AR','AR_LE_NAME_MANDATORY');

1234: END IF;
1235:
1236: EXCEPTION
1237: WHEN Others THEN
1238: FND_MESSAGE.SET_NAME('AR','AR_LE_NAME_MANDATORY');
1239: FND_MSG_PUB.Add;
1240: x_return_status := FND_API.G_RET_STS_ERROR ;
1241: ROLLBACK TO Create_Deposit_PVT;
1242: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1422: FND_MESSAGE.SET_NAME('AR','AR_DAPI_INSERT_HEADER_ST');

1418: X_new_rowid := l_new_rowid;
1419: arp_util.debug('arp_process_header_insrt_cover.insert_header_cover: l_new_status'||l_new_status );
1420: EXCEPTION
1421: WHEN Others THEN
1422: FND_MESSAGE.SET_NAME('AR','AR_DAPI_INSERT_HEADER_ST');
1423: FND_MSG_PUB.Add;
1424: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1425: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1426: FND_MSG_PUB.Add;

Line 1424: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');

1420: EXCEPTION
1421: WHEN Others THEN
1422: FND_MESSAGE.SET_NAME('AR','AR_DAPI_INSERT_HEADER_ST');
1423: FND_MSG_PUB.Add;
1424: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1425: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1426: FND_MSG_PUB.Add;
1427: x_return_status := FND_API.G_RET_STS_ERROR ;
1428: ROLLBACK TO Create_Deposit_PVT;

Line 1425: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);

1421: WHEN Others THEN
1422: FND_MESSAGE.SET_NAME('AR','AR_DAPI_INSERT_HEADER_ST');
1423: FND_MSG_PUB.Add;
1424: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1425: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1426: FND_MSG_PUB.Add;
1427: x_return_status := FND_API.G_RET_STS_ERROR ;
1428: ROLLBACK TO Create_Deposit_PVT;
1429: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1454: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');

1450:
1451:
1452:
1453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1454: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
1455: FND_MSG_PUB.Add;
1456: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1457: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1458: FND_MSG_PUB.Add;

Line 1456: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');

1452:
1453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1454: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
1455: FND_MSG_PUB.Add;
1456: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1457: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1458: FND_MSG_PUB.Add;
1459: x_return_status := FND_API.G_RET_STS_ERROR ;
1460: ROLLBACK TO Create_Deposit_PVT;

Line 1457: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);

1453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1454: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
1455: FND_MSG_PUB.Add;
1456: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1457: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1458: FND_MSG_PUB.Add;
1459: x_return_status := FND_API.G_RET_STS_ERROR ;
1460: ROLLBACK TO Create_Deposit_PVT;
1461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1470: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');

1466:
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469:
1470: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1471: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1472: FND_MSG_PUB.Add;
1473: x_return_status := FND_API.G_RET_STS_ERROR ;
1474: ROLLBACK TO Create_Deposit_PVT;

Line 1471: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);

1467: EXCEPTION
1468: WHEN OTHERS THEN
1469:
1470: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1471: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1472: FND_MSG_PUB.Add;
1473: x_return_status := FND_API.G_RET_STS_ERROR ;
1474: ROLLBACK TO Create_Deposit_PVT;
1475: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1513: FND_MESSAGE.SET_NAME('AR','AR_DAPI_POST_COMMIT_ST');

1509: NULL
1510: );
1511: EXCEPTION
1512: WHEN Others THEN
1513: FND_MESSAGE.SET_NAME('AR','AR_DAPI_POST_COMMIT_ST');
1514: FND_MSG_PUB.Add;
1515: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1516: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1517: FND_MSG_PUB.Add;

Line 1515: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');

1511: EXCEPTION
1512: WHEN Others THEN
1513: FND_MESSAGE.SET_NAME('AR','AR_DAPI_POST_COMMIT_ST');
1514: FND_MSG_PUB.Add;
1515: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1516: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1517: FND_MSG_PUB.Add;
1518: x_return_status := FND_API.G_RET_STS_ERROR ;
1519: ROLLBACK TO Create_Deposit_PVT;

Line 1516: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);

1512: WHEN Others THEN
1513: FND_MESSAGE.SET_NAME('AR','AR_DAPI_POST_COMMIT_ST');
1514: FND_MSG_PUB.Add;
1515: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1516: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1517: FND_MSG_PUB.Add;
1518: x_return_status := FND_API.G_RET_STS_ERROR ;
1519: ROLLBACK TO Create_Deposit_PVT;
1520: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1736: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_NO_ID_REQ');

1732:
1733: If ( p_deposit_number IS NULL AND
1734: p_customer_trx_id IS NULL ) then
1735:
1736: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_NO_ID_REQ');
1737: FND_MSG_PUB.Add;
1738: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;
1739:
1740: elsif ( p_deposit_number IS NOT NULL AND

Line 1748: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_NO_ING');

1744: INTO l_customer_trx_id,l_INVOICE_CURRENCY_CODE,l_deposit_date
1745: FROM ra_customer_trx
1746: WHERE customer_trx_id = p_customer_trx_id;
1747:
1748: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_NO_ING');
1749: FND_MSG_PUB.Add;
1750:
1751: SELECT customer_trx_id into l_dummy_number
1752: FROM ra_customer_trx cust_trx ,

Line 1759: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_ID_INVALID');

1755: and customer_trx_id = l_customer_trx_id
1756: and cust_trx_type.TYPE = 'DEP';
1757: exception
1758: when no_data_found then
1759: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_ID_INVALID');
1760: FND_MSG_PUB.Add;
1761: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;
1762:
1763: end;

Line 1780: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_ID_INVALID');

1776: and customer_trx_id = l_customer_trx_id and
1777: cust_trx_type.TYPE = 'DEP';
1778: exception
1779: when no_data_found then
1780: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_ID_INVALID');
1781: FND_MSG_PUB.Add;
1782: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;
1783:
1784: end;

Line 1801: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_NO_INVALID');

1797: and customer_trx_id = l_customer_trx_id and
1798: cust_trx_type.TYPE = 'DEP';
1799: exception
1800: when no_data_found then
1801: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_NO_INVALID');
1802: FND_MSG_PUB.Add;
1803: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;
1804:
1805: end;

Line 1829: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_NO_ID_NAME');

1825: end if;
1826: if ( p_salesrep_id IS NULL AND
1827: p_salesrep_number IS NULL ) then
1828:
1829: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_NO_ID_NAME');
1830: FND_MSG_PUB.Add;
1831: l_nosales_val_return_status := FND_API.G_RET_STS_ERROR;
1832:
1833: end if;

Line 1853: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_NAME_INVALID');

1849:
1850:
1851: exception
1852: when no_data_found then
1853: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_NAME_INVALID');
1854: FND_MSG_PUB.Add;
1855: l_sales_val_return_status := FND_API.G_RET_STS_ERROR;
1856:
1857: end;

Line 1872: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_ID_INVALID');

1868:
1869:
1870: exception
1871: when no_data_found then
1872: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_ID_INVALID');
1873: FND_MSG_PUB.Add;
1874: l_sales_val_return_status := FND_API.G_RET_STS_ERROR;
1875:
1876: end;

Line 1884: FND_MESSAGE.SET_NAME('AR','AR_DAPI_NON_REV_AMT_PCT');

1880:
1881: If ( p_non_revenue_amount_split IS NULL AND
1882: p_non_revenue_percent_split IS NULL ) then
1883:
1884: FND_MESSAGE.SET_NAME('AR','AR_DAPI_NON_REV_AMT_PCT');
1885: FND_MSG_PUB.Add;
1886: l_nonrev_amt_pct_return_status := FND_API.G_RET_STS_ERROR;
1887: elsif ( p_non_revenue_amount_split IS NOT NULL AND
1888: p_non_revenue_percent_split IS NULL ) then

Line 1902: FND_MESSAGE.SET_NAME('AR','AR_DAPI_REV_AMT_IGN');

1898: l_non_revenue_percent_split := p_non_revenue_percent_split ;
1899: l_non_revenue_amount_split := CurrRound(
1900: ( l_non_revenue_percent_split / 100 ) * l_amount,l_INVOICE_CURRENCY_CODE );
1901:
1902: FND_MESSAGE.SET_NAME('AR','AR_DAPI_REV_AMT_IGN');
1903: FND_MSG_PUB.Add;
1904: end if;
1905:
1906: l_desc_flex_rec.attribute_category := p_attribute_category;

Line 1998: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_ST');

1994: l_cust_trx_line_salesrep_id,
1995: l_status );
1996: IF ( l_status <> 'OK' )
1997: THEN
1998: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_ST');
1999: FND_MESSAGE.RAISE_ERROR;
2000:
2001:
2002: END IF;

Line 1999: FND_MESSAGE.RAISE_ERROR;

1995: l_status );
1996: IF ( l_status <> 'OK' )
1997: THEN
1998: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_ST');
1999: FND_MESSAGE.RAISE_ERROR;
2000:
2001:
2002: END IF;
2003:

Line 2006: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_ST');

2002: END IF;
2003:
2004: EXCEPTION
2005: WHEN Others THEN
2006: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_ST');
2007: FND_MSG_PUB.Add;
2008: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
2009: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
2010: FND_MSG_PUB.Add;

Line 2008: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');

2004: EXCEPTION
2005: WHEN Others THEN
2006: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_ST');
2007: FND_MSG_PUB.Add;
2008: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
2009: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
2010: FND_MSG_PUB.Add;
2011: x_return_status := FND_API.G_RET_STS_ERROR ;
2012: ROLLBACK TO Create_non_rev_sales_PVT;

Line 2009: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);

2005: WHEN Others THEN
2006: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_ST');
2007: FND_MSG_PUB.Add;
2008: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
2009: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
2010: FND_MSG_PUB.Add;
2011: x_return_status := FND_API.G_RET_STS_ERROR ;
2012: ROLLBACK TO Create_non_rev_sales_PVT;
2013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,