APPS.AR_DEPOSIT_API_PUB dependencies on FND_MSG_PUB

Line 8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

4: /*=======================================================================+
5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_DEPOSIT_API_PUB';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

Line 9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;

5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_DEPOSIT_API_PUB';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

Line 10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;

6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_DEPOSIT_API_PUB';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
14: PG_DEBUG VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

Line 11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_DEPOSIT_API_PUB';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
14: PG_DEBUG VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
15:

Line 12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
14: PG_DEBUG VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
15:
16: FUNCTION CurrRound( p_amount IN number,

Line 13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
14: PG_DEBUG VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
15:
16: FUNCTION CurrRound( p_amount IN number,
17: p_currency_code IN varchar2) RETURN NUMBER;

Line 192: | FND_MSG_PUB.initialize

188: | arp_util.debug(
189: | FND_API.Compatible_API_Call
190: | FND_API.G_EXC_UNEXPECTED_ERROR
191: | FND_API.to_Boolean
192: | FND_MSG_PUB.initialize
193: | AR_DEPOSIT_LIB_PVT.Default_deposit_ids
194: | AR_DEPOSIT_LIB_PVT.Get_deposit_Defaults
195: | ar_deposit_val_pvt.Validate_Deposit
196: | Arp_trx_defaults.get_header_defaults

Line 200: | FND_MSG_PUB.Count_And_Get

196: | Arp_trx_defaults.get_header_defaults
197: | ARP_TRX_VALIDATE.val_and_dflt_pay_mthd_and_bank
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

Line 203: | FND_MSG_PUB.Add;

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
207: | Parameter Type Description

Line 807: FND_MSG_PUB.initialize;

803: +--------------------------------------------------------------*/
804:
805: IF FND_API.to_Boolean( p_init_msg_list )
806: THEN
807: FND_MSG_PUB.initialize;
808: END IF;
809:
810: /*-----------------------------------------+
811: | Initialize return status to SUCCESS |

Line 1030: FND_MSG_PUB.Add;

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
1034: SELECT cust_trx_type_id

Line 1046: FND_MSG_PUB.Add;

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;
1050: END;

Line 1197: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|

1193: ROLLBACK TO Create_Deposit_PVT;
1194:
1195:
1196: /*-------------------------------------------------------+
1197: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|
1198: | in the message stack. If there is only one message in |
1199: | the stack it retrieves this message |
1200: +-------------------------------------------------------*/
1201: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1199: | the stack it retrieves this message |
1200: +-------------------------------------------------------*/
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202:
1203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1204: p_count => x_msg_count,
1205: p_data => x_msg_data);
1206:
1207: arp_util.debug('Error(s) occurred.

Line 1239: FND_MSG_PUB.Add;

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,
1243: p_count => x_msg_count,

Line 1242: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
1243: p_count => x_msg_count,
1244: p_data => x_msg_data);
1245: return;
1246: END;

Line 1423: FND_MSG_PUB.Add;

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;
1427: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1426: FND_MSG_PUB.Add;

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,
1430: p_count => x_msg_count,

Line 1429: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
1430: p_count => x_msg_count,
1431: p_data => x_msg_data);
1432: Return;
1433: END;

Line 1455: FND_MSG_PUB.Add;

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;
1459: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1458: FND_MSG_PUB.Add;

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,
1462: p_count => x_msg_count,

Line 1461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
1462: p_count => x_msg_count,
1463: p_data => x_msg_data);
1464: Return;
1465: END IF;

Line 1472: FND_MSG_PUB.Add;

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,
1476: p_count => x_msg_count,

Line 1475: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
1476: p_count => x_msg_count,
1477: p_data => x_msg_data);
1478: return;
1479:

Line 1514: FND_MSG_PUB.Add;

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;
1518: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1517: FND_MSG_PUB.Add;

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,
1521: p_count => x_msg_count,

Line 1520: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
1521: p_count => x_msg_count,
1522: p_data => x_msg_data);
1523: Return;
1524:

Line 1695: FND_MSG_PUB.initialize;

1691: +--------------------------------------------------------------*/
1692:
1693: IF FND_API.to_Boolean( p_init_msg_list )
1694: THEN
1695: FND_MSG_PUB.initialize;
1696: END IF;
1697:
1698:
1699: /*-----------------------------------------+

Line 1737: FND_MSG_PUB.Add;

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
1741: p_customer_trx_id IS NOT NULL ) then

Line 1749: FND_MSG_PUB.Add;

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 ,
1753: ra_cust_trx_types cust_trx_type

Line 1760: FND_MSG_PUB.Add;

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;
1764: elsif ( p_deposit_number IS NULL AND

Line 1781: FND_MSG_PUB.Add;

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;
1785: elsif ( p_deposit_number IS NOT NULL AND

Line 1802: FND_MSG_PUB.Add;

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;
1806: end if;

Line 1830: FND_MSG_PUB.Add;

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

Line 1854: FND_MSG_PUB.Add;

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;
1858: ELSIF (p_salesrep_id IS NOT NULL) THEN

Line 1873: FND_MSG_PUB.Add;

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

Line 1885: FND_MSG_PUB.Add;

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
1889: l_non_revenue_amount_split := p_non_revenue_amount_split;

Line 1903: FND_MSG_PUB.Add;

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;
1907: l_desc_flex_rec.attribute1 := p_attribute1;

Line 1947: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|

1943:
1944: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1945: ROLLBACK TO Create_non_rev_sales_PVT;
1946: /*-------------------------------------------------------+
1947: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|
1948: | in the message stack. If there is only one message in |
1949: | the stack it retrieves this message |
1950: +-------------------------------------------------------*/
1951: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1953: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1949: | the stack it retrieves this message |
1950: +-------------------------------------------------------*/
1951: x_return_status := FND_API.G_RET_STS_ERROR ;
1952:
1953: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1954: p_count => x_msg_count,
1955: p_data => x_msg_data);
1956:
1957: arp_util.debug('Error(s) occurred.

Line 2007: FND_MSG_PUB.Add;

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;
2011: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2010: FND_MSG_PUB.Add;

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,
2014: p_count => x_msg_count,

Line 2013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
2014: p_count => x_msg_count,
2015: p_data => x_msg_data);
2016: return;
2017: END;