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.OE_CREATE_ACCOUNT_INFO dependencies on FND_MESSAGE

Line 399: FND_MESSAGE.Set_Name('ONT','ONT_AAC_INACTIVE_ACCOUNT');

395: x_return_status := FND_API.G_RET_STS_ERROR;
396: IF l_debug_level > 0 THEN
397: oe_debug_pub.add( 'account is not active' ) ;
398: END IF;
399: FND_MESSAGE.Set_Name('ONT','ONT_AAC_INACTIVE_ACCOUNT');
400: OE_MSG_PUB.ADD;
401: CLOSE c_check_account;
402: OE_MSG_PUB.Count_And_Get
403: ( p_count => x_msg_count

Line 419: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_ACCOUNT');

415: x_return_status := FND_API.G_RET_STS_ERROR;
416: IF l_debug_level > 0 THEN
417: oe_debug_pub.add( 'invalid account.no such account_id ' ) ;
418: END IF;
419: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_ACCOUNT');
420: OE_MSG_PUB.ADD;
421: CLOSE c_check_account;
422: OE_MSG_PUB.Count_And_Get
423: ( p_count => x_msg_count

Line 446: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_ACCOUNT');

442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add( 'invalid customer account number:'||p_party_customer_rec.p_cust_account_Number ) ;
444: END IF;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_ACCOUNT');
447: OE_MSG_PUB.ADD;
448: CLOSE c_get_cust_account_id;
449: OE_MSG_PUB.Count_And_Get
450: ( p_count => x_msg_count

Line 460: FND_MESSAGE.Set_Name('ONT','ONT_AAC_INACTIVE_ACCOUNT');

456: x_return_status := FND_API.G_RET_STS_ERROR;
457: IF l_debug_level > 0 THEN
458: oe_debug_pub.add( 'account for account number is not active' ) ;
459: END IF;
460: FND_MESSAGE.Set_Name('ONT','ONT_AAC_INACTIVE_ACCOUNT');
461: OE_MSG_PUB.ADD;
462: CLOSE c_get_cust_account_id;
463: OE_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count

Line 664: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

660: then
661: oe_debug_pub.add('AAC:RC: Relationship is N');
662:
663: if (l_rc_matched = FALSE ) then
664: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
665: FND_MESSAGE.Set_Token('TEXT',' Customer Relationship is not allowed. SoldTo and Site Level Customer should be same');
666: OE_MSG_PUB.ADD;
667: oe_debug_pub.add('AAC:RC: ERROR: Customers are different');
668: x_return_status := FND_API.G_RET_STS_ERROR;

Line 665: FND_MESSAGE.Set_Token('TEXT',' Customer Relationship is not allowed. SoldTo and Site Level Customer should be same');

661: oe_debug_pub.add('AAC:RC: Relationship is N');
662:
663: if (l_rc_matched = FALSE ) then
664: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
665: FND_MESSAGE.Set_Token('TEXT',' Customer Relationship is not allowed. SoldTo and Site Level Customer should be same');
666: OE_MSG_PUB.ADD;
667: oe_debug_pub.add('AAC:RC: ERROR: Customers are different');
668: x_return_status := FND_API.G_RET_STS_ERROR;
669: return;

Line 718: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

714: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
715: oe_debug_pub.add('Creating relationship failed');
716:
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
719: FND_MESSAGE.Set_Token('TEXT',' Customer Relationship creation failed. ', FALSE);
720: OE_MSG_PUB.ADD;
721: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count , p_data => x_msg_data );
722: return;

Line 719: FND_MESSAGE.Set_Token('TEXT',' Customer Relationship creation failed. ', FALSE);

715: oe_debug_pub.add('Creating relationship failed');
716:
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
719: FND_MESSAGE.Set_Token('TEXT',' Customer Relationship creation failed. ', FALSE);
720: OE_MSG_PUB.ADD;
721: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count , p_data => x_msg_data );
722: return;
723: END IF; -- if failure

Line 730: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

726: x_return_status := FND_API.G_RET_STS_ERROR;
727: IF l_debug_level > 0 THEN
728: oe_debug_pub.add('AAC:RC: ERROR: l_add_customer is N' );
729: END IF;
730: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
731: FND_MESSAGE.Set_Token('TEXT',' Customer Relationship not defined. No permission to create relationship. ', FALSE);
732: OE_MSG_PUB.ADD;
733: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count , p_data => x_msg_data );
734: return;

Line 731: FND_MESSAGE.Set_Token('TEXT',' Customer Relationship not defined. No permission to create relationship. ', FALSE);

727: IF l_debug_level > 0 THEN
728: oe_debug_pub.add('AAC:RC: ERROR: l_add_customer is N' );
729: END IF;
730: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
731: FND_MESSAGE.Set_Token('TEXT',' Customer Relationship not defined. No permission to create relationship. ', FALSE);
732: OE_MSG_PUB.ADD;
733: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count , p_data => x_msg_data );
734: return;
735: end if; -- l_add_customer end

Line 1401: FND_MESSAGE.Set_Name('ONT','ONT_AAC_ERROR');

1397: l_return_status := FND_API.G_RET_STS_ERROR;
1398: IF l_debug_level > 0 THEN
1399: oe_debug_pub.add( 'site use not specified' ) ;
1400: END IF;
1401: FND_MESSAGE.Set_Name('ONT','ONT_AAC_ERROR');
1402:
1403: FND_MESSAGE.Set_Token('TEXT','Usage of Account Site should be specified', FALSE);
1404: OE_MSG_PUB.ADD;
1405: IF p_continue_on_error THEN

Line 1403: FND_MESSAGE.Set_Token('TEXT','Usage of Account Site should be specified', FALSE);

1399: oe_debug_pub.add( 'site use not specified' ) ;
1400: END IF;
1401: FND_MESSAGE.Set_Name('ONT','ONT_AAC_ERROR');
1402:
1403: FND_MESSAGE.Set_Token('TEXT','Usage of Account Site should be specified', FALSE);
1404: OE_MSG_PUB.ADD;
1405: IF p_continue_on_error THEN
1406: null;
1407: ELSE

Line 1476: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');

1472: l_return_status := fnd_api.g_ret_sts_error;
1473: IF l_debug_level > 0 THEN
1474: oe_debug_pub.add( 'account site use is inactive' ) ;
1475: END IF;
1476: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');
1477: OE_MSG_PUB.ADD;
1478: end if;
1479: /* IF l_cust_account_id <> px_cust_account_id then
1480: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1485: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');

1481: l_return_status := FND_API.G_RET_STS_ERROR;
1482: IF l_debug_level > 0 THEN
1483: oe_debug_pub.add( 'site does not belong to this account, or site account' ) ;
1484: END IF;
1485: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');
1486: OE_MSG_PUB.ADD;
1487: End if; */
1488: goto end_customer_found;
1489: Else

Line 1511: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');

1507: l_return_status := fnd_api.g_ret_sts_error;
1508: IF l_debug_level > 0 THEN
1509: oe_debug_pub.add( 'account site use is inactive' ) ;
1510: END IF;
1511: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');
1512: OE_MSG_PUB.ADD;
1513: end if;
1514: /* IF l_cust_account_id <> px_cust_account_id then
1515: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1520: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');

1516: l_return_status := FND_API.G_RET_STS_ERROR;
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add( 'site does not belong to this account, or site account' ) ;
1519: END IF;
1520: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');
1521: OE_MSG_PUB.ADD;
1522: End if;*/
1523: goto end_customer_found;
1524: Else -- not invoice to

Line 1546: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');

1542: l_return_status := fnd_api.g_ret_sts_error;
1543: IF l_debug_level > 0 THEN
1544: oe_debug_pub.add( 'account site use is inactive' ) ;
1545: END IF;
1546: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');
1547: OE_MSG_PUB.ADD;
1548: end if;
1549: /* IF l_cust_account_id <> px_cust_account_id then
1550: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1555: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');

1551: l_return_status := FND_API.G_RET_STS_ERROR;
1552: IF l_debug_level > 0 THEN
1553: oe_debug_pub.add( 'site does not belong to this account, or site account' ) ;
1554: END IF;
1555: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');
1556: OE_MSG_PUB.ADD;
1557: End if; */
1558: goto end_customer_found;
1559: else

Line 1591: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');

1587: oe_debug_pub.add( 'account site use is inactive' ) ;
1588: END IF;
1589:
1590: IF l_site_use_code = 'SHIP_TO' then
1591: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');
1592: ELSIF l_site_use_code = 'BILL_TO' then
1593: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');
1594: ELSIF l_site_use_code = 'DELIVER_TO' then
1595: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');

Line 1593: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');

1589:
1590: IF l_site_use_code = 'SHIP_TO' then
1591: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');
1592: ELSIF l_site_use_code = 'BILL_TO' then
1593: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');
1594: ELSIF l_site_use_code = 'DELIVER_TO' then
1595: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');
1596: END IF;
1597:

Line 1595: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');

1591: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');
1592: ELSIF l_site_use_code = 'BILL_TO' then
1593: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');
1594: ELSIF l_site_use_code = 'DELIVER_TO' then
1595: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');
1596: END IF;
1597:
1598: OE_MSG_PUB.ADD;
1599: END IF;

Line 1610: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');

1606: oe_debug_pub.add( 'site does not belong to this account, or site account' ) ;
1607: END IF;
1608:
1609: IF l_site_use_code = 'SHIP_TO' then
1610: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');
1611: ELSIF l_site_use_code = 'BILL_TO' then
1612: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');
1613: ELSIF l_site_use_code = 'DELIVER_TO' then
1614: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');

Line 1612: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');

1608:
1609: IF l_site_use_code = 'SHIP_TO' then
1610: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');
1611: ELSIF l_site_use_code = 'BILL_TO' then
1612: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');
1613: ELSIF l_site_use_code = 'DELIVER_TO' then
1614: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');
1615: END IF;
1616:

Line 1614: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');

1610: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');
1611: ELSIF l_site_use_code = 'BILL_TO' then
1612: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');
1613: ELSIF l_site_use_code = 'DELIVER_TO' then
1614: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');
1615: END IF;
1616:
1617: OE_MSG_PUB.ADD;
1618: END IF;

Line 1631: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');

1627: oe_debug_pub.add( 'INVALID SITE_USE_ID ' ) ;
1628: END IF;
1629:
1630: IF l_site_use_code = 'SHIP_TO' then
1631: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1632: ELSIF l_site_use_code = 'BILL_TO' then
1633: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1634: ELSIF l_site_use_code = 'DELIVER_TO' then
1635: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');

Line 1633: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');

1629:
1630: IF l_site_use_code = 'SHIP_TO' then
1631: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1632: ELSIF l_site_use_code = 'BILL_TO' then
1633: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1634: ELSIF l_site_use_code = 'DELIVER_TO' then
1635: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');
1636: END IF;
1637:

Line 1635: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');

1631: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1632: ELSIF l_site_use_code = 'BILL_TO' then
1633: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1634: ELSIF l_site_use_code = 'DELIVER_TO' then
1635: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');
1636: END IF;
1637:
1638: OE_MSG_PUB.ADD;
1639:

Line 1731: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');

1727: END IF;
1728: CLOSE c_party_site;
1729:
1730: IF l_site_use_code = 'SHIP_TO' then
1731: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1732: ELSIF l_site_use_code = 'BILL_TO' then
1733: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1734: ELSIF l_site_use_code = 'DELIVER_TO' then
1735: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');

Line 1733: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');

1729:
1730: IF l_site_use_code = 'SHIP_TO' then
1731: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1732: ELSIF l_site_use_code = 'BILL_TO' then
1733: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1734: ELSIF l_site_use_code = 'DELIVER_TO' then
1735: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');
1736: END IF;
1737:

Line 1735: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');

1731: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1732: ELSIF l_site_use_code = 'BILL_TO' then
1733: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1734: ELSIF l_site_use_code = 'DELIVER_TO' then
1735: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');
1736: END IF;
1737:
1738: OE_MSG_PUB.ADD;
1739: IF p_continue_on_error THEN

Line 1761: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');

1757: x_return_status := FND_API.G_RET_STS_ERROR;
1758: l_return_status := FND_API.G_RET_STS_ERROR;
1759:
1760: IF l_site_use_code = 'SHIP_TO' then
1761: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');
1762: ELSIF l_site_use_code = 'BILL_TO' then
1763: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');
1764: ELSIF l_site_use_code = 'DELIVER_TO' then
1765: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');

Line 1763: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');

1759:
1760: IF l_site_use_code = 'SHIP_TO' then
1761: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');
1762: ELSIF l_site_use_code = 'BILL_TO' then
1763: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');
1764: ELSIF l_site_use_code = 'DELIVER_TO' then
1765: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');
1766: END IF;
1767:

Line 1765: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');

1761: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');
1762: ELSIF l_site_use_code = 'BILL_TO' then
1763: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');
1764: ELSIF l_site_use_code = 'DELIVER_TO' then
1765: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');
1766: END IF;
1767:
1768: OE_MSG_PUB.ADD;
1769: IF l_debug_level > 0 THEN

Line 1792: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');

1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789: l_return_status := FND_API.G_RET_STS_ERROR;
1790:
1791: IF l_site_use_code = 'SHIP_TO' then
1792: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');
1793: ELSIF l_site_use_code = 'BILL_TO' then
1794: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');
1795: ELSIF l_site_use_code = 'DELIVER_TO' then
1796: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');

Line 1794: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');

1790:
1791: IF l_site_use_code = 'SHIP_TO' then
1792: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');
1793: ELSIF l_site_use_code = 'BILL_TO' then
1794: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');
1795: ELSIF l_site_use_code = 'DELIVER_TO' then
1796: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');
1797: END IF;
1798:

Line 1796: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');

1792: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');
1793: ELSIF l_site_use_code = 'BILL_TO' then
1794: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');
1795: ELSIF l_site_use_code = 'DELIVER_TO' then
1796: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');
1797: END IF;
1798:
1799: OE_MSG_PUB.ADD;
1800: IF l_debug_level > 0 THEN

Line 1827: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

1823: oe_debug_pub.add( 'Yes.. Party_Site_id is not null');
1824: if l_end_customer_passed ='N' then -- if its not end customer(4240715)
1825: x_return_status := FND_API.G_RET_STS_ERROR;
1826: l_return_status := FND_API.G_RET_STS_ERROR;
1827: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
1828: FND_MESSAGE.Set_Token('TEXT','Not a Valid Account Site ', FALSE);
1829: OE_MSG_PUB.ADD;
1830: IF l_debug_level > 0 THEN
1831: oe_debug_pub.add( 'no site information is sent ' ) ;

Line 1828: FND_MESSAGE.Set_Token('TEXT','Not a Valid Account Site ', FALSE);

1824: if l_end_customer_passed ='N' then -- if its not end customer(4240715)
1825: x_return_status := FND_API.G_RET_STS_ERROR;
1826: l_return_status := FND_API.G_RET_STS_ERROR;
1827: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
1828: FND_MESSAGE.Set_Token('TEXT','Not a Valid Account Site ', FALSE);
1829: OE_MSG_PUB.ADD;
1830: IF l_debug_level > 0 THEN
1831: oe_debug_pub.add( 'no site information is sent ' ) ;
1832: END IF;

Line 1876: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');

1872: oe_debug_pub.add( 'not a valid party site use id' ) ;
1873: END IF;
1874:
1875: IF l_site_use_code = 'SHIP_TO' then
1876: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1877: ELSIF l_site_use_code = 'BILL_TO' then
1878: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1879: ELSIF l_site_use_code = 'DELIVER_TO' then
1880: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');

Line 1878: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');

1874:
1875: IF l_site_use_code = 'SHIP_TO' then
1876: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1877: ELSIF l_site_use_code = 'BILL_TO' then
1878: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1879: ELSIF l_site_use_code = 'DELIVER_TO' then
1880: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');
1881: END IF;
1882:

Line 1880: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');

1876: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1877: ELSIF l_site_use_code = 'BILL_TO' then
1878: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1879: ELSIF l_site_use_code = 'DELIVER_TO' then
1880: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');
1881: END IF;
1882:
1883: OE_MSG_PUB.ADD;
1884: CLOSE c_party_site_use;

Line 1935: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');

1931: END IF;
1932: CLOSE c_party_site;
1933:
1934: IF l_site_use_code = 'SHIP_TO' then
1935: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1936: ELSIF l_site_use_code = 'BILL_TO' then
1937: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1938: ELSIF l_site_use_code = 'DELIVER_TO' then
1939: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');

Line 1937: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');

1933:
1934: IF l_site_use_code = 'SHIP_TO' then
1935: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1936: ELSIF l_site_use_code = 'BILL_TO' then
1937: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1938: ELSIF l_site_use_code = 'DELIVER_TO' then
1939: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');
1940: END IF;
1941:

Line 1939: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');

1935: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_SHIPTO');
1936: ELSIF l_site_use_code = 'BILL_TO' then
1937: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_BILLTO');
1938: ELSIF l_site_use_code = 'DELIVER_TO' then
1939: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_DELIVERTO');
1940: END IF;
1941:
1942: OE_MSG_PUB.ADD;
1943: IF p_continue_on_error THEN

Line 1963: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');

1959: x_return_status := FND_API.G_RET_STS_ERROR;
1960: l_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: IF l_site_use_code = 'SHIP_TO' then
1963: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');
1964: ELSIF l_site_use_code = 'BILL_TO' then
1965: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');
1966: ELSIF l_site_use_code = 'DELIVER_TO' then
1967: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');

Line 1965: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');

1961:
1962: IF l_site_use_code = 'SHIP_TO' then
1963: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');
1964: ELSIF l_site_use_code = 'BILL_TO' then
1965: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');
1966: ELSIF l_site_use_code = 'DELIVER_TO' then
1967: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');
1968: END IF;
1969:

Line 1967: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');

1963: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_INACTIVE');
1964: ELSIF l_site_use_code = 'BILL_TO' then
1965: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_INACTIVE');
1966: ELSIF l_site_use_code = 'DELIVER_TO' then
1967: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_INACTIVE');
1968: END IF;
1969:
1970: OE_MSG_PUB.ADD;
1971: IF l_debug_level > 0 THEN

Line 1994: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');

1990: x_return_status := FND_API.G_RET_STS_ERROR;
1991: l_return_status := FND_API.G_RET_STS_ERROR;
1992:
1993: IF l_site_use_code = 'SHIP_TO' then
1994: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');
1995: ELSIF l_site_use_code = 'BILL_TO' then
1996: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');
1997: ELSIF l_site_use_code = 'DELIVER_TO' then
1998: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');

Line 1996: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');

1992:
1993: IF l_site_use_code = 'SHIP_TO' then
1994: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');
1995: ELSIF l_site_use_code = 'BILL_TO' then
1996: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');
1997: ELSIF l_site_use_code = 'DELIVER_TO' then
1998: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');
1999: END IF;
2000:

Line 1998: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');

1994: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_ACCOUNT');
1995: ELSIF l_site_use_code = 'BILL_TO' then
1996: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_ACCOUNT');
1997: ELSIF l_site_use_code = 'DELIVER_TO' then
1998: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_ACCOUNT');
1999: END IF;
2000:
2001: OE_MSG_PUB.ADD;
2002: IF l_debug_level > 0 THEN

Line 2028: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

2024: oe_debug_pub.add( 'Yes.. Party_Site_id is not null.. Second');
2025: if l_end_customer_passed ='N' then -- if its not end customer(bug 4240715)
2026: x_return_status := FND_API.G_RET_STS_ERROR;
2027: l_return_status := FND_API.G_RET_STS_ERROR;
2028: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
2029: FND_MESSAGE.Set_Token('TEXT','Not a Valid Account Site ', FALSE);
2030: OE_MSG_PUB.ADD;
2031: IF l_debug_level > 0 THEN
2032: oe_debug_pub.add( 'no site information is sent ' ) ;

Line 2029: FND_MESSAGE.Set_Token('TEXT','Not a Valid Account Site ', FALSE);

2025: if l_end_customer_passed ='N' then -- if its not end customer(bug 4240715)
2026: x_return_status := FND_API.G_RET_STS_ERROR;
2027: l_return_status := FND_API.G_RET_STS_ERROR;
2028: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
2029: FND_MESSAGE.Set_Token('TEXT','Not a Valid Account Site ', FALSE);
2030: OE_MSG_PUB.ADD;
2031: IF l_debug_level > 0 THEN
2032: oe_debug_pub.add( 'no site information is sent ' ) ;
2033: END IF;

Line 2194: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');

2190:
2191: IF x_msg_count = 1 then
2192:
2193: IF l_site_use_code = 'SHIP_TO' then
2194: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2195: ELSIF l_site_use_code = 'BILL_TO' then
2196: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2197: ELSIF l_site_use_code = 'DELIVER_TO' then
2198: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');

Line 2196: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');

2192:
2193: IF l_site_use_code = 'SHIP_TO' then
2194: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2195: ELSIF l_site_use_code = 'BILL_TO' then
2196: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2197: ELSIF l_site_use_code = 'DELIVER_TO' then
2198: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');
2199: END IF;
2200:

Line 2198: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');

2194: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2195: ELSIF l_site_use_code = 'BILL_TO' then
2196: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2197: ELSIF l_site_use_code = 'DELIVER_TO' then
2198: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');
2199: END IF;
2200:
2201: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2202: OE_MSG_PUB.ADD;

Line 2201: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);

2197: ELSIF l_site_use_code = 'DELIVER_TO' then
2198: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');
2199: END IF;
2200:
2201: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2202: OE_MSG_PUB.ADD;
2203: ELSE
2204: oe_msg_pub.transfer_msg_stack;
2205: END IF;

Line 2216: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SITE_PERMISSION');

2212: END IF;
2213: ELSE
2214: x_return_status := FND_API.G_RET_STS_ERROR;
2215: l_return_status := FND_API.G_RET_STS_ERROR;
2216: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SITE_PERMISSION');
2217: OE_MSG_PUB.ADD;
2218: IF l_debug_level > 0 THEN
2219: oe_debug_pub.add( ' not authorized to create site' ) ;
2220: END IF;

Line 2283: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');

2279: END IF;
2280: IF x_msg_count = 1 then
2281:
2282: IF l_site_use_code = 'SHIP_TO' then
2283: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2284: ELSIF l_site_use_code = 'BILL_TO' then
2285: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2286: ELSIF l_site_use_code = 'DELIVER_TO' then
2287: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');

Line 2285: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');

2281:
2282: IF l_site_use_code = 'SHIP_TO' then
2283: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2284: ELSIF l_site_use_code = 'BILL_TO' then
2285: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2286: ELSIF l_site_use_code = 'DELIVER_TO' then
2287: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');
2288: END IF;
2289:

Line 2287: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');

2283: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2284: ELSIF l_site_use_code = 'BILL_TO' then
2285: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2286: ELSIF l_site_use_code = 'DELIVER_TO' then
2287: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');
2288: END IF;
2289:
2290: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2291: OE_MSG_PUB.ADD;

Line 2290: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);

2286: ELSIF l_site_use_code = 'DELIVER_TO' then
2287: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');
2288: END IF;
2289:
2290: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2291: OE_MSG_PUB.ADD;
2292: ELSE
2293: oe_msg_pub.transfer_msg_stack;
2294: END IF;

Line 2358: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');

2354: oe_debug_pub.add( ' adding to message stack' ) ;
2355: END IF;
2356:
2357: IF l_site_use_code = 'SHIP_TO' then
2358: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2359: ELSIF l_site_use_code = 'BILL_TO' then
2360: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2361: ELSIF l_site_use_code = 'DELIVER_TO' then
2362: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');

Line 2360: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');

2356:
2357: IF l_site_use_code = 'SHIP_TO' then
2358: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2359: ELSIF l_site_use_code = 'BILL_TO' then
2360: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2361: ELSIF l_site_use_code = 'DELIVER_TO' then
2362: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');
2363: END IF;
2364:

Line 2362: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');

2358: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2359: ELSIF l_site_use_code = 'BILL_TO' then
2360: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2361: ELSIF l_site_use_code = 'DELIVER_TO' then
2362: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');
2363: END IF;
2364:
2365: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2366: OE_MSG_PUB.ADD;

Line 2365: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);

2361: ELSIF l_site_use_code = 'DELIVER_TO' then
2362: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVERTO_SITE_CREATION');
2363: END IF;
2364:
2365: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2366: OE_MSG_PUB.ADD;
2367: ELSE
2368: IF l_debug_level > 0 THEN
2369: oe_debug_pub.add( ' transferring to message stack' ) ;

Line 2387: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SITE_PERMISSION');

2383: ELSE
2384:
2385: x_return_status := FND_API.G_RET_STS_ERROR;
2386: l_return_status := FND_API.G_RET_STS_ERROR;
2387: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SITE_PERMISSION');
2388: OE_MSG_PUB.ADD;
2389: IF l_debug_level > 0 THEN
2390: oe_debug_pub.add( '2 not allowed to create site' ) ;
2391: END IF;

Line 2505: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');

2501:
2502: IF x_msg_count = 1 then
2503:
2504: IF l_site_use_code = 'SHIP_TO' then
2505: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2506: ELSIF l_site_use_code = 'BILL_TO' then
2507: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2508: ELSIF l_site_use_code = 'DELIVER_TO' then
2509: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');

Line 2507: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');

2503:
2504: IF l_site_use_code = 'SHIP_TO' then
2505: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2506: ELSIF l_site_use_code = 'BILL_TO' then
2507: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2508: ELSIF l_site_use_code = 'DELIVER_TO' then
2509: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');
2510: END IF;
2511:

Line 2509: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');

2505: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2506: ELSIF l_site_use_code = 'BILL_TO' then
2507: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2508: ELSIF l_site_use_code = 'DELIVER_TO' then
2509: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');
2510: END IF;
2511:
2512: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2513: OE_MSG_PUB.ADD;

Line 2512: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);

2508: ELSIF l_site_use_code = 'DELIVER_TO' then
2509: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');
2510: END IF;
2511:
2512: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2513: OE_MSG_PUB.ADD;
2514: ELSE
2515: oe_msg_pub.transfer_msg_stack;
2516: END IF;

Line 2527: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SITE_PERMISSION');

2523: END IF;
2524: ELSE
2525: x_return_status := FND_API.G_RET_STS_ERROR;
2526: l_return_status := FND_API.G_RET_STS_ERROR;
2527: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SITE_PERMISSION');
2528: OE_MSG_PUB.ADD;
2529: IF l_debug_level > 0 THEN
2530: oe_debug_pub.add( ' not authorized to create site' ) ;
2531: END IF;

Line 2594: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');

2590: END IF;
2591: IF x_msg_count = 1 then
2592:
2593: IF l_site_use_code = 'SHIP_TO' then
2594: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2595: ELSIF l_site_use_code = 'BILL_TO' then
2596: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2597: ELSIF l_site_use_code = 'DELIVER_TO' then
2598: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');

Line 2596: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');

2592:
2593: IF l_site_use_code = 'SHIP_TO' then
2594: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2595: ELSIF l_site_use_code = 'BILL_TO' then
2596: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2597: ELSIF l_site_use_code = 'DELIVER_TO' then
2598: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');
2599: END IF;
2600:

Line 2598: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');

2594: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2595: ELSIF l_site_use_code = 'BILL_TO' then
2596: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2597: ELSIF l_site_use_code = 'DELIVER_TO' then
2598: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');
2599: END IF;
2600:
2601: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2602: OE_MSG_PUB.ADD;

Line 2601: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);

2597: ELSIF l_site_use_code = 'DELIVER_TO' then
2598: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');
2599: END IF;
2600:
2601: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2602: OE_MSG_PUB.ADD;
2603: ELSE
2604: oe_msg_pub.transfer_msg_stack;
2605: END IF;

Line 2669: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');

2665: oe_debug_pub.add( ' adding to message stack' ) ;
2666: END IF;
2667:
2668: IF l_site_use_code = 'SHIP_TO' then
2669: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2670: ELSIF l_site_use_code = 'BILL_TO' then
2671: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2672: ELSIF l_site_use_code = 'DELIVER_TO' then
2673: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');

Line 2671: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');

2667:
2668: IF l_site_use_code = 'SHIP_TO' then
2669: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2670: ELSIF l_site_use_code = 'BILL_TO' then
2671: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2672: ELSIF l_site_use_code = 'DELIVER_TO' then
2673: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');
2674: END IF;
2675:

Line 2673: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');

2669: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SHIPTO_SITE_CREATION');
2670: ELSIF l_site_use_code = 'BILL_TO' then
2671: FND_MESSAGE.Set_Name('ONT','ONT_AAC_BILLTO_SITE_CREATION');
2672: ELSIF l_site_use_code = 'DELIVER_TO' then
2673: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');
2674: END IF;
2675:
2676: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2677: OE_MSG_PUB.ADD;

Line 2676: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);

2672: ELSIF l_site_use_code = 'DELIVER_TO' then
2673: FND_MESSAGE.Set_Name('ONT','ONT_AAC_DELIVER_SITE_CREATION');
2674: END IF;
2675:
2676: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
2677: OE_MSG_PUB.ADD;
2678: ELSE
2679: IF l_debug_level > 0 THEN
2680: oe_debug_pub.add( ' transferring to message stack' ) ;

Line 2698: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SITE_PERMISSION');

2694: ELSE
2695:
2696: x_return_status := FND_API.G_RET_STS_ERROR;
2697: l_return_status := FND_API.G_RET_STS_ERROR;
2698: FND_MESSAGE.Set_Name('ONT','ONT_AAC_SITE_PERMISSION');
2699: OE_MSG_PUB.ADD;
2700: IF l_debug_level > 0 THEN
2701: oe_debug_pub.add( '2 not allowed to create site' ) ;
2702: END IF;

Line 3048: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_NO_CONTACT');

3044: x_return_status := FND_API.G_RET_STS_ERROR;
3045: IF l_debug_level > 0 THEN
3046: oe_debug_pub.add( l_indent|| 'not a valid cust account role id' ) ;
3047: END IF;
3048: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_NO_CONTACT');
3049: OE_MSG_PUB.ADD;
3050:
3051: CLOSE c_get_cust_id;
3052: OE_MSG_PUB.Count_And_Get

Line 3183: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_NO_CONTACT');

3179: x_return_status := FND_API.G_RET_STS_ERROR;
3180: IF l_debug_level > 0 THEN
3181: oe_debug_pub.add(l_indent|| '2 contact_id not found' ) ;
3182: END IF;
3183: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_NO_CONTACT');
3184: OE_MSG_PUB.ADD;
3185: OE_MSG_PUB.Count_And_Get
3186: ( p_count => x_msg_count
3187: , p_data => x_msg_data

Line 3199: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INACTIVE_CONTACT');

3195: oe_debug_pub.add( l_indent|| 'cust account role is not active' ) ;
3196: END IF;
3197: CLOSE c_cust_account_role;
3198: x_return_status := FND_API.G_RET_STS_ERROR;
3199: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INACTIVE_CONTACT');
3200: OE_MSG_PUB.ADD;
3201: OE_MSG_PUB.Count_And_Get
3202: ( p_count => x_msg_count
3203: , p_data => x_msg_data

Line 3215: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_ROLE_CONTACT');

3211: oe_debug_pub.add( l_indent|| 'cust account role type is not valid' ) ;
3212: END IF;
3213: CLOSE c_cust_account_role;
3214: x_return_status := FND_API.G_RET_STS_ERROR;
3215: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_ROLE_CONTACT');
3216: OE_MSG_PUB.ADD;
3217: OE_MSG_PUB.Count_And_Get
3218: ( p_count => x_msg_count
3219: , p_data => x_msg_data

Line 3232: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_CONTACT_ACCOUNT');

3228: oe_debug_pub.add( l_indent|| 'Account role does not belong to this acct' ) ;
3229: END IF;
3230: CLOSE c_cust_account_role;
3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_CONTACT_ACCOUNT');
3233: OE_MSG_PUB.ADD;
3234: OE_MSG_PUB.Count_And_Get
3235: ( p_count => x_msg_count
3236: , p_data => x_msg_data

Line 3274: FND_MESSAGE.Set_Name('ONT','ONT_AAC_CONTACT_ACCOUNT');

3270: oe_debug_pub.add(l_indent|| 'org contact_id does not belong to sent party or '|| ' contact may be inactive' ) ;
3271: END IF;
3272: x_return_status := FND_API.G_RET_STS_ERROR;
3273: CLOSE c_check_org_contact;
3274: FND_MESSAGE.Set_Name('ONT','ONT_AAC_CONTACT_ACCOUNT');
3275: OE_MSG_PUB.ADD;
3276: OE_MSG_PUB.Count_And_Get
3277: ( p_count => x_msg_count
3278: , p_data => x_msg_data

Line 3325: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

3321: IF l_debug_level > 0 THEN
3322: oe_debug_pub.add(l_indent|| 'error >1 contact for org_contact_id' ) ;
3323: END IF;
3324: x_return_status := FND_API.G_RET_STS_ERROR;
3325: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
3326: FND_MESSAGE.Set_Token('TEXT',' Multiple Contacts ', FALSE);
3327: OE_MSG_PUB.ADD;
3328: OE_MSG_PUB.Count_And_Get
3329: ( p_count => x_msg_count

Line 3326: FND_MESSAGE.Set_Token('TEXT',' Multiple Contacts ', FALSE);

3322: oe_debug_pub.add(l_indent|| 'error >1 contact for org_contact_id' ) ;
3323: END IF;
3324: x_return_status := FND_API.G_RET_STS_ERROR;
3325: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
3326: FND_MESSAGE.Set_Token('TEXT',' Multiple Contacts ', FALSE);
3327: OE_MSG_PUB.ADD;
3328: OE_MSG_PUB.Count_And_Get
3329: ( p_count => x_msg_count
3330: , p_data => x_msg_data

Line 3419: FND_MESSAGE.Set_Name('ONT','ONT_AAC_CONTACT_CREATION');

3415: oe_debug_pub.add( l_indent|| ' error = '||X_MSG_DATA ) ;
3416: END IF;
3417:
3418: IF x_msg_count = 1 then
3419: FND_MESSAGE.Set_Name('ONT','ONT_AAC_CONTACT_CREATION');
3420: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
3421: OE_MSG_PUB.ADD;
3422: ELSE
3423: oe_msg_pub.transfer_msg_stack;

Line 3420: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);

3416: END IF;
3417:
3418: IF x_msg_count = 1 then
3419: FND_MESSAGE.Set_Name('ONT','ONT_AAC_CONTACT_CREATION');
3420: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
3421: OE_MSG_PUB.ADD;
3422: ELSE
3423: oe_msg_pub.transfer_msg_stack;
3424: END IF;

Line 3443: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_CONTACT_PERMISSION');

3439: x_return_status := FND_API.G_RET_STS_ERROR;
3440: IF l_debug_level > 0 THEN
3441: oe_debug_pub.add( l_indent|| 'not allowed to create contact' ) ;
3442: end IF;
3443: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_CONTACT_PERMISSION');
3444: OE_MSG_PUB.ADD;
3445: OE_MSG_PUB.Count_And_Get
3446: ( p_count => x_msg_count
3447: , p_data => x_msg_data

Line 3656: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_PARTY');

3652: IF l_debug_level > 0 THEN
3653: oe_debug_pub.add(l_indent|| 'no such party found for party_number' ) ;
3654: END IF;
3655: CLOSE party_number_rec;
3656: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_PARTY');
3657: OE_MSG_PUB.ADD;
3658: return;
3659: END IF;
3660:

Line 3673: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_PARTY');

3669: x_return_status := FND_API.G_RET_STS_ERROR;
3670: IF l_debug_level > 0 THEN
3671: oe_debug_pub.add(l_indent|| 'no such party found for party_id' ) ;
3672: END IF;
3673: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_PARTY');
3674: OE_MSG_PUB.ADD;
3675: CLOSE party_rec;
3676: return;
3677: END IF;

Line 3719: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

3715: IF l_debug_level > 0 THEN
3716: oe_debug_pub.add( l_indent|| 'more than one account for party id' ) ;
3717: END IF;
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
3720: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);
3721: OE_MSG_PUB.ADD;
3722: EXIT;
3723: END IF;

Line 3720: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);

3716: oe_debug_pub.add( l_indent|| 'more than one account for party id' ) ;
3717: END IF;
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
3720: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);
3721: OE_MSG_PUB.ADD;
3722: EXIT;
3723: END IF;
3724: end if;

Line 3755: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_PARTY');

3751: x_return_status := FND_API.G_RET_STS_ERROR;
3752: IF l_debug_level > 0 THEN
3753: oe_debug_pub.add(l_indent|| ' invalid party type' ) ;
3754: end IF;
3755: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_PARTY');
3756: OE_MSG_PUB.ADD;
3757:
3758: END IF; -- party_type
3759:

Line 3874: FND_MESSAGE.Set_Name('ONT','ONT_AAC_ACCOUNT_CREATION');

3870: IF l_debug_level > 0 THEN
3871: oe_debug_pub.add( l_indent|| ' account creation failed' ) ;
3872: END IF;
3873: IF x_msg_count = 1 then
3874: FND_MESSAGE.Set_Name('ONT','ONT_AAC_ACCOUNT_CREATION');
3875: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
3876: OE_MSG_PUB.ADD;
3877: ELSE
3878: oe_msg_pub.transfer_msg_stack;

Line 3875: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);

3871: oe_debug_pub.add( l_indent|| ' account creation failed' ) ;
3872: END IF;
3873: IF x_msg_count = 1 then
3874: FND_MESSAGE.Set_Name('ONT','ONT_AAC_ACCOUNT_CREATION');
3875: FND_MESSAGE.Set_Token('TCA_MESSAGE',x_msg_data, FALSE);
3876: OE_MSG_PUB.ADD;
3877: ELSE
3878: oe_msg_pub.transfer_msg_stack;
3879: END IF;

Line 3906: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_ACCOUNT_PERMISSION');

3902: x_return_status := FND_API.G_RET_STS_ERROR;
3903: IF l_debug_level > 0 THEN
3904: oe_debug_pub.add(l_indent|| 'not allowed to create account' ) ;
3905: END IF;
3906: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_ACCOUNT_PERMISSION');
3907: OE_MSG_PUB.ADD;
3908: ELSE
3909: IF l_debug_level > 0 THEN
3910: oe_debug_pub.add('Contact Center Integration, no permission to create account');

Line 3925: FND_MESSAGE.Set_Name('ONT', 'ONT_AVAIL_GENERIC');

3921: --oe_debug_pub.add('p_out_cust_account_id = '|| p_account_tbl(1));
3922:
3923: ELSE
3924: --x_return_status := FND_API.G_RET_STS_ERROR;
3925: FND_MESSAGE.Set_Name('ONT', 'ONT_AVAIL_GENERIC');
3926: IF l_debug_level > 0 THEN
3927: oe_debug_pub.add(l_indent|| 'party_id or party number is not passed' ) ;
3928: END IF;
3929: l_message := 'Party_id or Party Number is not passed';

Line 3930: FND_MESSAGE.Set_Token('TEXT',l_message, FALSE);

3926: IF l_debug_level > 0 THEN
3927: oe_debug_pub.add(l_indent|| 'party_id or party number is not passed' ) ;
3928: END IF;
3929: l_message := 'Party_id or Party Number is not passed';
3930: FND_MESSAGE.Set_Token('TEXT',l_message, FALSE);
3931: OE_MSG_PUB.ADD;
3932:
3933: END IF; -- if party_id or party_number is not null
3934:

Line 4111: FND_MESSAGE.Set_Name('ONT','ONT_AACC_NO_ACCOUNT');

4107: IF l_debug_level > 0 THEN
4108: oe_debug_pub.add( 'NO SUCH PARTY FOUND FOR PARTY_NUMBER' ) ;
4109: END IF;
4110: x_return_status := FND_API.G_RET_STS_ERROR;
4111: FND_MESSAGE.Set_Name('ONT','ONT_AACC_NO_ACCOUNT');
4112: OE_MSG_PUB.ADD;
4113: CLOSE party_number_rec;
4114: return;
4115: END IF;

Line 4129: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_ACCOUNT');

4125: IF l_debug_level > 0 THEN
4126: oe_debug_pub.add( 'NO SUCH PARTY FOUND FOR PARTY_ID' ) ;
4127: END IF;
4128: x_return_status := FND_API.G_RET_STS_ERROR;
4129: FND_MESSAGE.Set_Name('ONT','ONT_AAC_NO_ACCOUNT');
4130: OE_MSG_PUB.ADD;
4131: CLOSE party_rec;
4132: return;
4133: END IF;

Line 4184: FND_MESSAGE.Set_Name('ONT','ONT_AAC_INVALID_PARTY');

4180: IF l_debug_level > 0 THEN
4181: oe_debug_pub.add( 'INVALID PARTY TYPE' ) ;
4182: END IF;
4183: x_return_status := FND_API.G_RET_STS_ERROR;
4184: FND_MESSAGE.Set_Name('ONT','ONT_AAC_INVALID_PARTY');
4185: OE_MSG_PUB.ADD;
4186: return;
4187: END IF;
4188:

Line 4194: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

4190: IF l_debug_level > 0 THEN
4191: oe_debug_pub.add( 'NO PARTY INFORMATION SENT' ) ;
4192: END IF;
4193: x_return_status := FND_API.G_RET_STS_ERROR;
4194: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
4195: FND_MESSAGE.Set_Token('TEXT','No Customer Information ', FALSE);
4196: OE_MSG_PUB.ADD;
4197: return;
4198: END IF;

Line 4195: FND_MESSAGE.Set_Token('TEXT','No Customer Information ', FALSE);

4191: oe_debug_pub.add( 'NO PARTY INFORMATION SENT' ) ;
4192: END IF;
4193: x_return_status := FND_API.G_RET_STS_ERROR;
4194: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
4195: FND_MESSAGE.Set_Token('TEXT','No Customer Information ', FALSE);
4196: OE_MSG_PUB.ADD;
4197: return;
4198: END IF;
4199:

Line 4504: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_ACCOUNT');

4500: WHEN NO_DATA_FOUND THEN
4501:
4502: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
4503: THEN
4504: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_ACCOUNT');
4505: OE_MSG_PUB.ADD;
4506: END IF;
4507:
4508: IF l_debug_level > 4 THEN

Line 4567: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_ACCOUNT');

4563: WHEN NO_DATA_FOUND THEN
4564:
4565: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
4566: THEN
4567: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_ACCOUNT');
4568: OE_MSG_PUB.ADD;
4569: END IF;
4570:
4571: IF l_debug_level > 4 THEN

Line 4616: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_PARTY');

4612: WHEN NO_DATA_FOUND THEN
4613:
4614: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
4615: THEN
4616: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_PARTY');
4617: OE_MSG_PUB.ADD;
4618: END IF;
4619:
4620: IF l_debug_level > 4 THEN

Line 4661: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_PARTY');

4657: WHEN NO_DATA_FOUND THEN
4658:
4659: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
4660: THEN
4661: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_PARTY');
4662: OE_MSG_PUB.ADD;
4663: END IF;
4664:
4665: IF l_debug_level > 4 THEN

Line 4705: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_PARTY');

4701: WHEN NO_DATA_FOUND THEN
4702:
4703: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
4704: THEN
4705: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_INVALID_PARTY');
4706: OE_MSG_PUB.ADD;
4707: END IF;
4708:
4709: IF l_debug_level > 4 THEN

Line 4803: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

4799:
4800: p_cust_account_id := null;
4801: x_return_status := FND_API.G_RET_STS_ERROR;
4802: p_cust_account_id := null;
4803: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
4804: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);
4805: OE_MSG_PUB.ADD;
4806:
4807: return;

Line 4804: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);

4800: p_cust_account_id := null;
4801: x_return_status := FND_API.G_RET_STS_ERROR;
4802: p_cust_account_id := null;
4803: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
4804: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);
4805: OE_MSG_PUB.ADD;
4806:
4807: return;
4808:

Line 4853: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

4849: END IF;
4850:
4851: x_return_status := FND_API.G_RET_STS_ERROR;
4852: p_cust_account_id := null;
4853: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
4854: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);
4855: OE_MSG_PUB.ADD;
4856:
4857: return;

Line 4854: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);

4850:
4851: x_return_status := FND_API.G_RET_STS_ERROR;
4852: p_cust_account_id := null;
4853: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
4854: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);
4855: OE_MSG_PUB.ADD;
4856:
4857: return;
4858:

Line 4899: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

4895: END IF;
4896:
4897: --x_return_status := FND_API.G_RET_STS_ERROR;
4898: p_cust_account_id := null;
4899: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
4900: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);
4901: OE_MSG_PUB.ADD;
4902: close c_get_account_id;
4903:

Line 4900: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);

4896:
4897: --x_return_status := FND_API.G_RET_STS_ERROR;
4898: p_cust_account_id := null;
4899: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
4900: FND_MESSAGE.Set_Token('TEXT','Multiple Accounts Exist', FALSE);
4901: OE_MSG_PUB.ADD;
4902: close c_get_account_id;
4903:
4904: return;

Line 4938: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_ACCOUNT_PERMISSION');

4934: -- and return
4935: IF l_debug_level > 0 THEN
4936: oe_debug_pub.add ('AAC:FSTI: no permission to create account: returning');
4937: END IF;
4938: FND_MESSAGE.Set_Name('ONT', 'ONT_AAC_ACCOUNT_PERMISSION');
4939: OE_MSG_PUB.ADD;
4940: p_cust_account_id := NULL;
4941: x_return_status := FND_API.G_RET_STS_ERROR;
4942: return;

Line 4990: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');

4986:
4987: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
4988: THEN
4989:
4990: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4991: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','find_sold_to_id');
4992: OE_MSG_PUB.Add;
4993:
4994: END IF;

Line 4991: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','find_sold_to_id');

4987: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
4988: THEN
4989:
4990: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
4991: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','find_sold_to_id');
4992: OE_MSG_PUB.Add;
4993:
4994: END IF;
4995: IF l_debug_level > 4 THEN

Line 5049: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');

5045: END IF;
5046:
5047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5048: THEN
5049: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5050: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
5051: OE_MSG_PUB.Add;
5052: END IF;
5053:

Line 5050: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');

5046:
5047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5048: THEN
5049: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5050: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
5051: OE_MSG_PUB.Add;
5052: END IF;
5053:
5054: RETURN;

Line 5301: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

5297: WHEN NO_DATA_FOUND THEN
5298:
5299: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
5300: THEN
5301: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
5302: FND_MESSAGE.Set_Token('TEXT','Not a Valid party site use ', FALSE);
5303: OE_MSG_PUB.ADD;
5304: END IF;
5305:

Line 5302: FND_MESSAGE.Set_Token('TEXT','Not a Valid party site use ', FALSE);

5298:
5299: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
5300: THEN
5301: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
5302: FND_MESSAGE.Set_Token('TEXT','Not a Valid party site use ', FALSE);
5303: OE_MSG_PUB.ADD;
5304: END IF;
5305:
5306: IF l_debug_level > 4 THEN

Line 5354: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

5350: WHEN NO_DATA_FOUND THEN
5351:
5352: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
5353: THEN
5354: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
5355: FND_MESSAGE.Set_Token('TEXT','Not a Valid party site ', FALSE);
5356: OE_MSG_PUB.ADD;
5357:
5358: END IF;

Line 5355: FND_MESSAGE.Set_Token('TEXT','Not a Valid party site ', FALSE);

5351:
5352: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
5353: THEN
5354: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
5355: FND_MESSAGE.Set_Token('TEXT','Not a Valid party site ', FALSE);
5356: OE_MSG_PUB.ADD;
5357:
5358: END IF;
5359: IF l_debug_level > 4 THEN

Line 5500: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

5496: WHEN NO_DATA_FOUND THEN
5497:
5498: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
5499: THEN
5500: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
5501: FND_MESSAGE.Set_Token('TEXT','Not a Valid account site use', FALSE);
5502: OE_MSG_PUB.ADD;
5503:
5504: END IF;

Line 5501: FND_MESSAGE.Set_Token('TEXT','Not a Valid account site use', FALSE);

5497:
5498: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
5499: THEN
5500: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
5501: FND_MESSAGE.Set_Token('TEXT','Not a Valid account site use', FALSE);
5502: OE_MSG_PUB.ADD;
5503:
5504: END IF;
5505: IF l_debug_level > 4 THEN

Line 5583: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

5579: WHEN NO_DATA_FOUND THEN
5580:
5581: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
5582: THEN
5583: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
5584: FND_MESSAGE.Set_Token('TEXT','Not a Valid party site ', FALSE);
5585: OE_MSG_PUB.ADD;
5586:
5587: END IF;

Line 5584: FND_MESSAGE.Set_Token('TEXT','Not a Valid party site ', FALSE);

5580:
5581: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
5582: THEN
5583: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');
5584: FND_MESSAGE.Set_Token('TEXT','Not a Valid party site ', FALSE);
5585: OE_MSG_PUB.ADD;
5586:
5587: END IF;
5588: IF l_debug_level > 4 THEN

Line 5689: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');

5685:
5686: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))
5687: THEN
5688:
5689: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5690: --{bug 4240715
5691: if p_party_site_use_code is NULL or p_party_site_use_code = 'SOLD_TO' then
5692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
5693: elsif p_party_site_use_code ='SHIP_TO' then

Line 5692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');

5688:
5689: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
5690: --{bug 4240715
5691: if p_party_site_use_code is NULL or p_party_site_use_code = 'SOLD_TO' then
5692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
5693: elsif p_party_site_use_code ='SHIP_TO' then
5694: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
5695: elsif p_party_site_use_code ='BILL_TO' then
5696: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');

Line 5694: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');

5690: --{bug 4240715
5691: if p_party_site_use_code is NULL or p_party_site_use_code = 'SOLD_TO' then
5692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
5693: elsif p_party_site_use_code ='SHIP_TO' then
5694: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
5695: elsif p_party_site_use_code ='BILL_TO' then
5696: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');
5697: elsif p_party_site_use_code ='DELIVER_TO' then
5698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');

Line 5696: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');

5692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
5693: elsif p_party_site_use_code ='SHIP_TO' then
5694: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
5695: elsif p_party_site_use_code ='BILL_TO' then
5696: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');
5697: elsif p_party_site_use_code ='DELIVER_TO' then
5698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
5699: elsif p_party_site_use_code ='END_CUST' then
5700: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');

Line 5698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');

5694: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
5695: elsif p_party_site_use_code ='BILL_TO' then
5696: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');
5697: elsif p_party_site_use_code ='DELIVER_TO' then
5698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
5699: elsif p_party_site_use_code ='END_CUST' then
5700: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');
5701: end if;
5702: --bug 4240715}

Line 5700: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');

5696: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');
5697: elsif p_party_site_use_code ='DELIVER_TO' then
5698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
5699: elsif p_party_site_use_code ='END_CUST' then
5700: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');
5701: end if;
5702: --bug 4240715}
5703: OE_MSG_PUB.Add;
5704:

Line 6040: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');

6036:
6037: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6038: THEN
6039:
6040: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_party_site_id');
6042: OE_MSG_PUB.Add;
6043:
6044: END IF;

Line 6041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_party_site_id');

6037: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6038: THEN
6039:
6040: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_party_site_id');
6042: OE_MSG_PUB.Add;
6043:
6044: END IF;
6045:

Line 6118: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');

6114:
6115: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6116: THEN
6117:
6118: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6119: --{bug 4240715
6120: if p_site_use_code is NULL or p_site_use_code = 'SOLD_TO' then
6121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
6122: elsif p_site_use_code ='SHIP_TO' then

Line 6121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');

6117:
6118: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
6119: --{bug 4240715
6120: if p_site_use_code is NULL or p_site_use_code = 'SOLD_TO' then
6121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
6122: elsif p_site_use_code ='SHIP_TO' then
6123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
6124: elsif p_site_use_code ='BILL_TO' then
6125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');

Line 6123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');

6119: --{bug 4240715
6120: if p_site_use_code is NULL or p_site_use_code = 'SOLD_TO' then
6121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
6122: elsif p_site_use_code ='SHIP_TO' then
6123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
6124: elsif p_site_use_code ='BILL_TO' then
6125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');
6126: elsif p_site_use_code ='DELIVER_TO' then
6127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');

Line 6125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');

6121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
6122: elsif p_site_use_code ='SHIP_TO' then
6123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
6124: elsif p_site_use_code ='BILL_TO' then
6125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');
6126: elsif p_site_use_code ='DELIVER_TO' then
6127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
6128: elsif p_site_use_code ='END_CUST' then
6129: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');

Line 6127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');

6123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
6124: elsif p_site_use_code ='BILL_TO' then
6125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');
6126: elsif p_site_use_code ='DELIVER_TO' then
6127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
6128: elsif p_site_use_code ='END_CUST' then
6129: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');
6130: end if;
6131: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');

Line 6129: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');

6125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','bill_to_org_id');
6126: elsif p_site_use_code ='DELIVER_TO' then
6127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
6128: elsif p_site_use_code ='END_CUST' then
6129: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');
6130: end if;
6131: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
6132: --bug 4240715}
6133: OE_MSG_PUB.Add;

Line 6131: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');

6127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
6128: elsif p_site_use_code ='END_CUST' then
6129: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_id');
6130: end if;
6131: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
6132: --bug 4240715}
6133: OE_MSG_PUB.Add;
6134:
6135: END IF;