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 720: FND_MESSAGE.Set_Name('ONT','ONT_AVAIL_GENERIC');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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