APPS.OE_CREATE_ACCOUNT_INFO dependencies on OE_MSG_PUB

Line 103: oe_msg_pub.initialize;

99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: -- Checking to see if the OM message stack needs to be initialized
102: IF p_control_rec.p_init_msg_list THEN
103: oe_msg_pub.initialize;
104: END IF;
105:
106: IF l_debug_level > 0 THEN
107: oe_debug_pub.add( ' ==== Entering Create Account Layer ====');

Line 201: OE_MSG_PUB.Count_And_Get

197: ,x_msg_count => x_msg_count
198: ,x_msg_data => x_msg_data);
199:
200: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
201: OE_MSG_PUB.Count_And_Get
202: ( p_count => x_msg_count
203: , p_data => x_msg_data
204: );
205: IF l_debug_level > 0 THEN

Line 331: OE_MSG_PUB.Count_And_Get

327: oe_debug_pub.add( '=== ...done calling check_and_create_account' ) ;
328: END IF;
329:
330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
331: OE_MSG_PUB.Count_And_Get
332: ( p_count => x_msg_count
333: , p_data => x_msg_data
334: );
335: IF l_debug_level > 0 THEN

Line 400: OE_MSG_PUB.ADD;

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
404: , p_data => x_msg_data

Line 402: OE_MSG_PUB.Count_And_Get

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
404: , p_data => x_msg_data
405: );
406: return;

Line 420: OE_MSG_PUB.ADD;

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
424: , p_data => x_msg_data

Line 422: OE_MSG_PUB.Count_And_Get

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
424: , p_data => x_msg_data
425: );
426: return;

Line 447: OE_MSG_PUB.ADD;

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
451: , p_data => x_msg_data

Line 449: OE_MSG_PUB.Count_And_Get

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
451: , p_data => x_msg_data
452: );
453: return;

Line 461: OE_MSG_PUB.ADD;

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
465: , p_data => x_msg_data

Line 463: OE_MSG_PUB.Count_And_Get

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
465: , p_data => x_msg_data
466: );
467: return;

Line 487: OE_MSG_PUB.Count_And_Get

483: IF l_debug_level > 0 THEN
484: oe_debug_pub.add( 'INVALID CUSTOMER ACCOUNT ID' ) ;
485: END IF;
486: CLOSE c_cust_account_id;
487: OE_MSG_PUB.Count_And_Get
488: ( p_count => x_msg_count
489: , p_data => x_msg_data
490: );
491: return;

Line 666: OE_MSG_PUB.ADD;

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

Line 722: OE_MSG_PUB.ADD;

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
726: oe_debug_pub.add('AAC:RC: relationship created');

Line 723: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count , p_data => x_msg_data );

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
726: oe_debug_pub.add('AAC:RC: relationship created');
727: else -- l_add_customer = 'N'

Line 734: OE_MSG_PUB.ADD;

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

Line 735: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count , p_data => x_msg_data );

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
738: end if; -- found_relationship
739: else -- l_rc_matched = TRUE

Line 832: --OE_MSG_PUB.Count_And_Get

828: END IF;
829: l_contact_status := FND_API.G_RET_STS_ERROR;
830: x_msg_data_contact := x_msg_data;
831: x_msg_count_contact := x_msg_count;
832: --OE_MSG_PUB.Count_And_Get
833: --( p_count => x_msg_count
834: --, p_data => x_msg_data
835: --);
836: --return;

Line 1068: OE_MSG_PUB.Count_And_Get

1064: if l_debug_level > 0 then
1065: oe_debug_pub.add( 'not commiting the txn' ) ;
1066: END IF;
1067: l_site_failed := TRUE;
1068: OE_MSG_PUB.Count_And_Get
1069: ( p_count => x_msg_count
1070: , p_data => x_msg_data
1071: );
1072:

Line 1119: OE_MSG_PUB.Count_And_Get

1115: x_return_status := FND_API.G_RET_STS_ERROR;
1116:
1117: -- Get message count and data
1118:
1119: OE_MSG_PUB.Count_And_Get
1120: ( p_count => x_msg_count
1121: , p_data => x_msg_data
1122: );
1123:

Line 1138: OE_MSG_PUB.Count_And_Get

1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1135:
1136: -- Get message count and data
1137:
1138: OE_MSG_PUB.Count_And_Get
1139: ( p_count => x_msg_count
1140: , p_data => x_msg_data
1141: );
1142:

Line 1158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1154: IF l_debug_level > 0 THEN
1155: oe_debug_pub.add( 'CREATE_ACCOUNT_LAYER WHEN OTHER EXCEPTION CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
1156: END IF;
1157:
1158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: OE_MSG_PUB.Add_Exc_Msg
1161: ( G_PKG_NAME
1162: , 'create_account_layer'

Line 1160: OE_MSG_PUB.Add_Exc_Msg

1156: END IF;
1157:
1158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: OE_MSG_PUB.Add_Exc_Msg
1161: ( G_PKG_NAME
1162: , 'create_account_layer'
1163: );
1164: END IF;

Line 1168: OE_MSG_PUB.Count_And_Get

1164: END IF;
1165:
1166: -- Get message count and data
1167:
1168: OE_MSG_PUB.Count_And_Get
1169: ( p_count => x_msg_count
1170: , p_data => x_msg_data
1171: );
1172:

Line 1406: OE_MSG_PUB.ADD;

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
1410: OE_MSG_PUB.Count_And_Get

Line 1410: OE_MSG_PUB.Count_And_Get

1406: OE_MSG_PUB.ADD;
1407: IF p_continue_on_error THEN
1408: null;
1409: ELSE
1410: OE_MSG_PUB.Count_And_Get
1411: ( p_count => x_msg_count
1412: , p_data => x_msg_data
1413: );
1414: return;

Line 1479: OE_MSG_PUB.ADD;

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;
1483: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1488: OE_MSG_PUB.ADD;

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
1492: close c_site_use;

Line 1514: OE_MSG_PUB.ADD;

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

Line 1523: OE_MSG_PUB.ADD;

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
1527: close c_site_use;

Line 1549: OE_MSG_PUB.ADD;

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;
1553: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1558: OE_MSG_PUB.ADD;

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
1562: close c_site_use;

Line 1600: OE_MSG_PUB.ADD;

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;
1602:
1603: oe_debug_pub.add( 'px_accoun_id:'||px_cust_account_id||'l_accoun_id:'||l_cust_account_id ) ;
1604: /* IF l_cust_account_id <> px_cust_account_id then

Line 1619: OE_MSG_PUB.ADD;

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;
1621: */
1622:
1623: p_site_tbl(i).p_cust_acct_site_id := l_cust_acct_site_id;

Line 1640: OE_MSG_PUB.ADD;

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:
1642: END IF; -- if cursor found
1643: CLOSE c_site_use;
1644: END IF; -- site_ use_code (bug 4240715)

Line 1740: OE_MSG_PUB.ADD;

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
1742: null;
1743: ELSE
1744: OE_MSG_PUB.Count_And_Get

Line 1744: OE_MSG_PUB.Count_And_Get

1740: OE_MSG_PUB.ADD;
1741: IF p_continue_on_error THEN
1742: null;
1743: ELSE
1744: OE_MSG_PUB.Count_And_Get
1745: ( p_count => x_msg_count
1746: , p_data => x_msg_data
1747: );
1748: return;

Line 1770: OE_MSG_PUB.ADD;

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
1772: oe_debug_pub.add( 'party site is not active' ) ;
1773: END IF;
1774: CLOSE c_party_site;

Line 1778: OE_MSG_PUB.Count_And_Get

1774: CLOSE c_party_site;
1775: IF p_continue_on_error THEN
1776: null;
1777: ELSE
1778: OE_MSG_PUB.Count_And_Get
1779: ( p_count => x_msg_count
1780: , p_data => x_msg_data
1781: );
1782: return;

Line 1801: OE_MSG_PUB.ADD;

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
1803: oe_debug_pub.add( 'party site does not belong to the party' ) ;
1804: END IF;
1805:

Line 1810: OE_MSG_PUB.Count_And_Get

1806: CLOSE c_party_site;
1807: IF p_continue_on_error THEN
1808: null;
1809: ELSE
1810: OE_MSG_PUB.Count_And_Get
1811: ( p_count => x_msg_count
1812: , p_data => x_msg_data
1813: );
1814: return;

Line 1831: OE_MSG_PUB.ADD;

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;
1835: IF p_continue_on_error THEN

Line 1838: OE_MSG_PUB.Count_And_Get

1834: END IF;
1835: IF p_continue_on_error THEN
1836: null;
1837: ELSE
1838: OE_MSG_PUB.Count_And_Get
1839: ( p_count => x_msg_count
1840: , p_data => x_msg_data
1841: );
1842: return;

Line 1885: OE_MSG_PUB.ADD;

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;
1887:
1888: IF p_continue_on_error THEN
1889: null;

Line 1891: OE_MSG_PUB.Count_And_Get

1887:
1888: IF p_continue_on_error THEN
1889: null;
1890: ELSE
1891: OE_MSG_PUB.Count_And_Get
1892: ( p_count => x_msg_count
1893: , p_data => x_msg_data
1894: );
1895: return;

Line 1944: OE_MSG_PUB.ADD;

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
1946: null;
1947: ELSE
1948: OE_MSG_PUB.Count_And_Get

Line 1948: OE_MSG_PUB.Count_And_Get

1944: OE_MSG_PUB.ADD;
1945: IF p_continue_on_error THEN
1946: null;
1947: ELSE
1948: OE_MSG_PUB.Count_And_Get
1949: ( p_count => x_msg_count
1950: , p_data => x_msg_data
1951: );
1952: return;

Line 1972: OE_MSG_PUB.ADD;

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
1974: oe_debug_pub.add( 'party site is not active' ) ;
1975: END IF;
1976: CLOSE c_party_site;

Line 1980: OE_MSG_PUB.Count_And_Get

1976: CLOSE c_party_site;
1977: IF p_continue_on_error THEN
1978: null;
1979: ELSE
1980: OE_MSG_PUB.Count_And_Get
1981: ( p_count => x_msg_count
1982: , p_data => x_msg_data
1983: );
1984: return;

Line 2003: OE_MSG_PUB.ADD;

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
2005: oe_debug_pub.add( 'party site does not belong to the party' ) ;
2006: END IF;
2007: CLOSE c_party_site;

Line 2011: OE_MSG_PUB.Count_And_Get

2007: CLOSE c_party_site;
2008: IF p_continue_on_error THEN
2009: null;
2010: ELSE
2011: OE_MSG_PUB.Count_And_Get
2012: ( p_count => x_msg_count
2013: , p_data => x_msg_data
2014: );
2015: return;

Line 2032: OE_MSG_PUB.ADD;

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;
2036: IF p_continue_on_error THEN

Line 2039: OE_MSG_PUB.Count_And_Get

2035: END IF;
2036: IF p_continue_on_error THEN
2037: null;
2038: ELSE
2039: OE_MSG_PUB.Count_And_Get
2040: ( p_count => x_msg_count
2041: , p_data => x_msg_data
2042: );
2043: return;

Line 2204: OE_MSG_PUB.ADD;

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

Line 2206: oe_msg_pub.transfer_msg_stack;

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;
2208:
2209: IF p_continue_on_error THEN
2210: null;

Line 2219: OE_MSG_PUB.ADD;

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;
2223: CLOSE c_acct_site;

Line 2293: OE_MSG_PUB.ADD;

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;
2297: IF p_continue_on_error THEN

Line 2295: oe_msg_pub.transfer_msg_stack;

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;
2297: IF p_continue_on_error THEN
2298: null;
2299: ELSE

Line 2368: OE_MSG_PUB.ADD;

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

Line 2373: oe_msg_pub.transfer_msg_stack;

2369: ELSE
2370: IF l_debug_level > 0 THEN
2371: oe_debug_pub.add( ' transferring to message stack' ) ;
2372: END IF;
2373: oe_msg_pub.transfer_msg_stack;
2374: END IF;
2375: IF p_continue_on_error THEN
2376: null;
2377: ELSE

Line 2390: OE_MSG_PUB.ADD;

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;
2394: CLOSE c_acct_site;

Line 2515: OE_MSG_PUB.ADD;

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

Line 2517: oe_msg_pub.transfer_msg_stack;

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;
2519:
2520: IF p_continue_on_error THEN
2521: null;

Line 2530: OE_MSG_PUB.ADD;

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;
2534: CLOSE c_acct_site;

Line 2604: OE_MSG_PUB.ADD;

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;
2608: IF p_continue_on_error THEN

Line 2606: oe_msg_pub.transfer_msg_stack;

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;
2608: IF p_continue_on_error THEN
2609: null;
2610: ELSE

Line 2679: OE_MSG_PUB.ADD;

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

Line 2684: oe_msg_pub.transfer_msg_stack;

2680: ELSE
2681: IF l_debug_level > 0 THEN
2682: oe_debug_pub.add( ' transferring to message stack' ) ;
2683: END IF;
2684: oe_msg_pub.transfer_msg_stack;
2685: END IF;
2686: IF p_continue_on_error THEN
2687: null;
2688: ELSE

Line 2701: OE_MSG_PUB.ADD;

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;
2705: CLOSE c_acct_site;

Line 2772: OE_MSG_PUB.Count_And_Get

2768: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
2769: IF l_debug_level > 0 THEN
2770: oe_debug_pub.add( ' doing count and get for site' ) ;
2771: END IF;
2772: OE_MSG_PUB.Count_And_Get
2773: ( p_count => x_msg_count
2774: , p_data => x_msg_data
2775: );
2776: END IF;

Line 2798: OE_MSG_PUB.Count_And_Get

2794: x_return_status := FND_API.G_RET_STS_ERROR;
2795:
2796: -- Get message count and data
2797:
2798: OE_MSG_PUB.Count_And_Get
2799: ( p_count => x_msg_count
2800: , p_data => x_msg_data
2801: );
2802:

Line 2819: OE_MSG_PUB.Count_And_Get

2815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2816:
2817: -- Get message count and data
2818:
2819: OE_MSG_PUB.Count_And_Get
2820: ( p_count => x_msg_count
2821: , p_data => x_msg_data
2822: );
2823:

Line 2841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2837: IF l_debug_level > 0 THEN
2838: oe_debug_pub.add( 'check_and_create_site when other code = '|| sqlcode||' message = '||sqlerrm ) ;
2839: END IF;
2840:
2841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2842: THEN
2843: OE_MSG_PUB.Add_Exc_Msg
2844: ( G_PKG_NAME
2845: , 'Check_and_create_sites'

Line 2843: OE_MSG_PUB.Add_Exc_Msg

2839: END IF;
2840:
2841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2842: THEN
2843: OE_MSG_PUB.Add_Exc_Msg
2844: ( G_PKG_NAME
2845: , 'Check_and_create_sites'
2846: );
2847: END IF;

Line 2851: OE_MSG_PUB.Count_And_Get

2847: END IF;
2848:
2849: -- Get message count and data
2850:
2851: OE_MSG_PUB.Count_And_Get
2852: ( p_count => x_msg_count
2853: , p_data => x_msg_data
2854: );
2855:

Line 3051: OE_MSG_PUB.ADD;

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
3055: ( p_count => x_msg_count

Line 3054: OE_MSG_PUB.Count_And_Get

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
3055: ( p_count => x_msg_count
3056: , p_data => x_msg_data
3057: );
3058:

Line 3186: OE_MSG_PUB.ADD;

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

Line 3187: OE_MSG_PUB.Count_And_Get

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
3190: );
3191: return;

Line 3202: OE_MSG_PUB.ADD;

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

Line 3203: OE_MSG_PUB.Count_And_Get

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
3206: );
3207: return;

Line 3218: OE_MSG_PUB.ADD;

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

Line 3219: OE_MSG_PUB.Count_And_Get

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
3222: );
3223: return;

Line 3235: OE_MSG_PUB.ADD;

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

Line 3236: OE_MSG_PUB.Count_And_Get

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
3239: );
3240: return;

Line 3277: OE_MSG_PUB.ADD;

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

Line 3278: OE_MSG_PUB.Count_And_Get

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
3281: );
3282: IF l_debug_level > 0 THEN

Line 3329: OE_MSG_PUB.ADD;

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

Line 3330: OE_MSG_PUB.Count_And_Get

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
3333: );
3334: return;

Line 3423: OE_MSG_PUB.ADD;

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

Line 3425: oe_msg_pub.transfer_msg_stack;

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;
3427:
3428: OE_MSG_PUB.Count_And_Get
3429: ( p_count => x_msg_count

Line 3428: OE_MSG_PUB.Count_And_Get

3424: ELSE
3425: oe_msg_pub.transfer_msg_stack;
3426: END IF;
3427:
3428: OE_MSG_PUB.Count_And_Get
3429: ( p_count => x_msg_count
3430: , p_data => x_msg_data
3431: );
3432: return;

Line 3446: OE_MSG_PUB.ADD;

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

Line 3447: OE_MSG_PUB.Count_And_Get

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
3450: );
3451: return;

Line 3512: OE_MSG_PUB.Count_And_Get

3508: x_return_status := FND_API.G_RET_STS_ERROR;
3509:
3510: -- Get message count and data
3511:
3512: OE_MSG_PUB.Count_And_Get
3513: ( p_count => x_msg_count
3514: , p_data => x_msg_data
3515: );
3516:

Line 3523: OE_MSG_PUB.Count_And_Get

3519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3520:
3521: -- Get message count and data
3522:
3523: OE_MSG_PUB.Count_And_Get
3524: ( p_count => x_msg_count
3525: , p_data => x_msg_data
3526: );
3527:

Line 3535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3531: IF l_debug_level > 0 THEN
3532: oe_debug_pub.add( 'CHECK_CONTACT WHEN OTHER EXCEPTION CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
3533: END IF;
3534:
3535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3536: THEN
3537: OE_MSG_PUB.Add_Exc_Msg
3538: ( G_PKG_NAME
3539: , 'check_and_create_contact'

Line 3537: OE_MSG_PUB.Add_Exc_Msg

3533: END IF;
3534:
3535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3536: THEN
3537: OE_MSG_PUB.Add_Exc_Msg
3538: ( G_PKG_NAME
3539: , 'check_and_create_contact'
3540: );
3541: END IF;

Line 3545: OE_MSG_PUB.Count_And_Get

3541: END IF;
3542:
3543: -- Get message count and data
3544:
3545: OE_MSG_PUB.Count_And_Get
3546: ( p_count => x_msg_count
3547: , p_data => x_msg_data
3548: );
3549:

Line 3659: OE_MSG_PUB.ADD;

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:
3663: CLOSE party_number_rec;

Line 3676: OE_MSG_PUB.ADD;

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

Line 3723: OE_MSG_PUB.ADD;

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;
3727: IF l_debug_level > 0 THEN

Line 3758: OE_MSG_PUB.ADD;

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:
3762: IF p_account_tbl.COUNT > 0 then

Line 3878: OE_MSG_PUB.ADD;

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

Line 3880: oe_msg_pub.transfer_msg_stack;

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;
3882:
3883: END IF;
3884: p_account_tbl(1):= x_cust_account_id;

Line 3909: OE_MSG_PUB.ADD;

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

Line 3933: OE_MSG_PUB.ADD;

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:
3937:

Line 3945: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,

3941: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
3942: IF l_debug_level > 0 THEN
3943: oe_debug_pub.add(l_indent|| 'doing count_and_get' ) ;
3944: END IF;
3945: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
3946: p_count => x_msg_count,
3947: p_data=>x_msg_data
3948: );
3949: IF l_debug_level > 0 THEN

Line 3977: OE_MSG_PUB.Count_And_Get

3973: x_return_status := FND_API.G_RET_STS_ERROR;
3974:
3975: -- Get message count and data
3976:
3977: OE_MSG_PUB.Count_And_Get
3978: ( p_count => x_msg_count
3979: , p_data => x_msg_data
3980: );
3981:

Line 3999: OE_MSG_PUB.Count_And_Get

3995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3996:
3997: -- Get message count and data
3998:
3999: OE_MSG_PUB.Count_And_Get
4000: ( p_count => x_msg_count
4001: , p_data => x_msg_data
4002: );
4003:

Line 4022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4018: IF l_debug_level > 0 THEN
4019: oe_debug_pub.add( 'CHECK_ACCOUNT WHEN OTHERS EXCEPTION CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
4020: END IF;
4021:
4022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4023: THEN
4024: OE_MSG_PUB.Add_Exc_Msg
4025: ( G_PKG_NAME
4026: , 'check_and_create_account'

Line 4024: OE_MSG_PUB.Add_Exc_Msg

4020: END IF;
4021:
4022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4023: THEN
4024: OE_MSG_PUB.Add_Exc_Msg
4025: ( G_PKG_NAME
4026: , 'check_and_create_account'
4027: );
4028: END IF;

Line 4032: OE_MSG_PUB.Count_And_Get

4028: END IF;
4029:
4030: -- Get message count and data
4031:
4032: OE_MSG_PUB.Count_And_Get
4033: ( p_count => x_msg_count
4034: , p_data => x_msg_data
4035: );
4036: END check_and_create_account;

Line 4114: OE_MSG_PUB.ADD;

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

Line 4132: OE_MSG_PUB.ADD;

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

Line 4187: OE_MSG_PUB.ADD;

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:
4191: ELSE

Line 4198: OE_MSG_PUB.ADD;

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:
4202: END if_multiple_accounts;

Line 4504: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

4500: EXCEPTION
4501:
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;

Line 4507: OE_MSG_PUB.ADD;

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
4511: oe_debug_pub.add ('AAC:VTI: invalid cust_account_id ');

Line 4519: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4515: return;
4516:
4517: WHEN OTHERS THEN
4518:
4519: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4520: --THEN
4521: OE_MSG_PUB.Add_Exc_Msg(
4522: G_PKG_NAME
4523: ,'find_sold_to_id'

Line 4521: OE_MSG_PUB.Add_Exc_Msg(

4517: WHEN OTHERS THEN
4518:
4519: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4520: --THEN
4521: OE_MSG_PUB.Add_Exc_Msg(
4522: G_PKG_NAME
4523: ,'find_sold_to_id'
4524: );
4525: --END IF;

Line 4567: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

4563: EXCEPTION
4564:
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;

Line 4570: OE_MSG_PUB.ADD;

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
4574: oe_debug_pub.add ('AAC:VTI: invalid cust_account_id ');

Line 4582: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4578: return;
4579:
4580: WHEN OTHERS THEN
4581:
4582: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4583: --THEN
4584: OE_MSG_PUB.Add_Exc_Msg(
4585: G_PKG_NAME
4586: ,'find_sold_to_id'

Line 4584: OE_MSG_PUB.Add_Exc_Msg(

4580: WHEN OTHERS THEN
4581:
4582: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4583: --THEN
4584: OE_MSG_PUB.Add_Exc_Msg(
4585: G_PKG_NAME
4586: ,'find_sold_to_id'
4587: );
4588: --END IF;

Line 4616: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

4612: EXCEPTION
4613:
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;

Line 4619: OE_MSG_PUB.ADD;

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
4623: oe_debug_pub.add ('AAC:VTI: invalid party_number ');

Line 4632: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4628: return;
4629:
4630: WHEN OTHERS THEN
4631:
4632: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4633: --THEN
4634: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_sold_to_id' ); --modified for bug 4590205
4635: --END IF;
4636: IF l_debug_level > 4 THEN

Line 4634: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_sold_to_id' ); --modified for bug 4590205

4630: WHEN OTHERS THEN
4631:
4632: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4633: --THEN
4634: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_sold_to_id' ); --modified for bug 4590205
4635: --END IF;
4636: IF l_debug_level > 4 THEN
4637: oe_debug_pub.add ('AAC:VTI: unexpected error in find_sold_to_id');
4638: END IF;

Line 4661: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

4657: EXCEPTION
4658:
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;

Line 4664: OE_MSG_PUB.ADD;

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
4668: oe_debug_pub.add ('AAC:VTI: invalid party_site_use_id ');

Line 4677: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4673: return;
4674:
4675: WHEN OTHERS THEN
4676:
4677: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4678: --THEN
4679: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_sold_to_id' ); --modified for bug 4590205
4680: --END IF;
4681: IF l_debug_level > 4 THEN

Line 4679: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_sold_to_id' ); --modified for bug 4590205

4675: WHEN OTHERS THEN
4676:
4677: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4678: --THEN
4679: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_sold_to_id' ); --modified for bug 4590205
4680: --END IF;
4681: IF l_debug_level > 4 THEN
4682: oe_debug_pub.add ('AAC:VTI: unexpected error in find_sold_to_id');
4683: END IF;

Line 4705: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

4701: EXCEPTION
4702:
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;

Line 4708: OE_MSG_PUB.ADD;

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
4712: oe_debug_pub.add ('AAC:VTI: invalid party_site_id ');

Line 4720: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4716: return;
4717:
4718: WHEN OTHERS THEN
4719:
4720: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4721: --THEN
4722: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_sold_to_id' ); --modified for bug 4590205
4723: --END IF;
4724: IF l_debug_level > 4 THEN

Line 4722: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_sold_to_id' ); --modified for bug 4590205

4718: WHEN OTHERS THEN
4719:
4720: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4721: --THEN
4722: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_sold_to_id' ); --modified for bug 4590205
4723: --END IF;
4724: IF l_debug_level > 4 THEN
4725: oe_debug_pub.add ('AAC:VTI: unexpected error in find_sold_to_id');
4726: END IF;

Line 4763: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4759: p_site_use_id := null;
4760:
4761: WHEN OTHERS THEN
4762:
4763: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4764: --THEN
4765: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_site_id' );
4766: --END IF;
4767: IF l_debug_level > 4 THEN

Line 4765: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_site_id' );

4761: WHEN OTHERS THEN
4762:
4763: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4764: --THEN
4765: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_site_id' );
4766: --END IF;
4767: IF l_debug_level > 4 THEN
4768: oe_debug_pub.add ('AAC:VTI: unexpected error in find_sold_to_id');
4769: END IF;

Line 4807: OE_MSG_PUB.ADD;

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:
4811: WHEN OTHERS THEN

Line 4813: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4809: return;
4810:
4811: WHEN OTHERS THEN
4812:
4813: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4814: --THEN
4815: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_site_id' );
4816: --END IF;
4817: IF l_debug_level > 4 THEN

Line 4815: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_site_id' );

4811: WHEN OTHERS THEN
4812:
4813: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4814: --THEN
4815: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_site_id' );
4816: --END IF;
4817: IF l_debug_level > 4 THEN
4818: oe_debug_pub.add ('AAC:VTI: unexpected error in find_sold_to_id');
4819: END IF;

Line 4857: OE_MSG_PUB.ADD;

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:
4861: WHEN OTHERS THEN

Line 4863: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4859: return;
4860:
4861: WHEN OTHERS THEN
4862:
4863: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4864: --THEN
4865: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_site_id' );
4866: --END IF;
4867: IF l_debug_level > 4 THEN

Line 4865: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_site_id' );

4861: WHEN OTHERS THEN
4862:
4863: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4864: --THEN
4865: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'find_site_id' );
4866: --END IF;
4867: IF l_debug_level > 4 THEN
4868: oe_debug_pub.add ('AAC:VTI: unexpected error in find_sold_to_id');
4869: END IF;

Line 4903: OE_MSG_PUB.ADD;

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

Line 4941: OE_MSG_PUB.ADD;

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

Line 4989: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

4985: EXCEPTION
4986:
4987: WHEN NO_DATA_FOUND THEN
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');

Line 4994: OE_MSG_PUB.Add;

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
4998: oe_debug_pub.add ('AAC:VTI: invalid p_cust_account_id in find_sold_to_id'); -- got a party_name

Line 5006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5002: return;
5003:
5004: WHEN OTHERS THEN
5005:
5006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5007: THEN
5008: OE_MSG_PUB.Add_Exc_Msg(
5009: G_PKG_NAME
5010: ,'find_Sold_To_Org_id'

Line 5008: OE_MSG_PUB.Add_Exc_Msg(

5004: WHEN OTHERS THEN
5005:
5006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5007: THEN
5008: OE_MSG_PUB.Add_Exc_Msg(
5009: G_PKG_NAME
5010: ,'find_Sold_To_Org_id'
5011: );
5012: END IF;

Line 5049: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

5045: IF l_debug_level > 0 THEN
5046: oe_debug_pub.add ('AAC:FCI: cust_contact_id is not null, nothing to do: warn; returning}');
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;

Line 5053: OE_MSG_PUB.Add;

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

Line 5301: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

5297: EXCEPTION
5298:
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;

Line 5305: OE_MSG_PUB.ADD;

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
5309: oe_debug_pub.add ('AAC:VTI: invalid party_site_use_id ');

Line 5317: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5313: return;
5314:
5315: WHEN OTHERS THEN
5316:
5317: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5318: --THEN
5319: OE_MSG_PUB.Add_Exc_Msg(
5320: G_PKG_NAME
5321: ,'find_site_id'

Line 5319: OE_MSG_PUB.Add_Exc_Msg(

5315: WHEN OTHERS THEN
5316:
5317: --IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5318: --THEN
5319: OE_MSG_PUB.Add_Exc_Msg(
5320: G_PKG_NAME
5321: ,'find_site_id'
5322: );
5323: --END IF;

Line 5354: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

5350: EXCEPTION
5351:
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;

Line 5358: OE_MSG_PUB.ADD;

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
5362: oe_debug_pub.add ('AAC:VTI: invalid party_site_id ');

Line 5369: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5365: return;
5366:
5367: WHEN OTHERS THEN
5368:
5369: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5370: THEN
5371: OE_MSG_PUB.Add_Exc_Msg(
5372: G_PKG_NAME
5373: ,'find_site_id'

Line 5371: OE_MSG_PUB.Add_Exc_Msg(

5367: WHEN OTHERS THEN
5368:
5369: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5370: THEN
5371: OE_MSG_PUB.Add_Exc_Msg(
5372: G_PKG_NAME
5373: ,'find_site_id'
5374: );
5375: END IF;

Line 5500: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

5496: EXCEPTION
5497:
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;

Line 5504: OE_MSG_PUB.ADD;

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
5508: oe_debug_pub.add ('AAC:VTI: invalid cust_site_use_id ');

Line 5583: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

5579: EXCEPTION
5580:
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;

Line 5587: OE_MSG_PUB.ADD;

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
5591: oe_debug_pub.add ('AAC:VTI: invalid party_site_id ');

Line 5598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5594: return;
5595:
5596: WHEN OTHERS THEN
5597:
5598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5599: THEN
5600: OE_MSG_PUB.Add_Exc_Msg(
5601: G_PKG_NAME
5602: ,'find_site_id'

Line 5600: OE_MSG_PUB.Add_Exc_Msg(

5596: WHEN OTHERS THEN
5597:
5598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5599: THEN
5600: OE_MSG_PUB.Add_Exc_Msg(
5601: G_PKG_NAME
5602: ,'find_site_id'
5603: );
5604: END IF;

Line 5688: IF (OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR))

5684: EXCEPTION
5685:
5686: WHEN NO_DATA_FOUND THEN
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

Line 5705: OE_MSG_PUB.Add;

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:
5707: END IF;
5708: IF l_debug_level > 4 THEN
5709: oe_debug_pub.add ('AAC:VTI: no data in Get_party_id'); -- got a party_name

Line 5715: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5711: RETURN FND_API.G_MISS_NUM;
5712:
5713: WHEN OTHERS THEN
5714:
5715: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5716: THEN
5717: OE_MSG_PUB.Add_Exc_Msg(
5718: G_PKG_NAME
5719: ,'get_party_id' --modified for bug 4590205

Line 5717: OE_MSG_PUB.Add_Exc_Msg(

5713: WHEN OTHERS THEN
5714:
5715: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5716: THEN
5717: OE_MSG_PUB.Add_Exc_Msg(
5718: G_PKG_NAME
5719: ,'get_party_id' --modified for bug 4590205
5720: );
5721: END IF;

Line 6039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

6035: IF C2%ISOPEN then
6036: CLOSE C2;
6037: END IF;
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');

Line 6044: OE_MSG_PUB.Add;

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:
6048: RETURN NULL;

Line 6060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6056: IF C2%ISOPEN then
6057: CLOSE C2;
6058: END IF;
6059:
6060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6061: THEN
6062: OE_MSG_PUB.Add_Exc_Msg
6063: ( G_PKG_NAME
6064: , 'get_party_site_id'

Line 6062: OE_MSG_PUB.Add_Exc_Msg

6058: END IF;
6059:
6060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6061: THEN
6062: OE_MSG_PUB.Add_Exc_Msg
6063: ( G_PKG_NAME
6064: , 'get_party_site_id'
6065: );
6066: END IF;

Line 6117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

6113: EXCEPTION
6114:
6115: WHEN NO_DATA_FOUND THEN
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

Line 6135: OE_MSG_PUB.Add;

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;
6138:
6139: RETURN FND_API.G_MISS_NUM;

Line 6143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6139: RETURN FND_API.G_MISS_NUM;
6140:
6141: WHEN OTHERS THEN
6142:
6143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6144: THEN
6145: OE_MSG_PUB.Add_Exc_Msg
6146: ( G_PKG_NAME
6147: , 'Sold_To_Org'

Line 6145: OE_MSG_PUB.Add_Exc_Msg

6141: WHEN OTHERS THEN
6142:
6143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6144: THEN
6145: OE_MSG_PUB.Add_Exc_Msg
6146: ( G_PKG_NAME
6147: , 'Sold_To_Org'
6148: );
6149: END IF;