DBA Data[Home] [Help]

APPS.ASO_CHECK_TCA_PVT dependencies on FND_MESSAGE

Line 189: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

185: FETCH C_Get_Party_From_Acct INTO p_qte_rec.party_id;
186: IF C_Get_Party_From_Acct%NOTFOUND THEN
187: x_Return_Status := FND_API.G_RET_STS_ERROR;
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
189: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
190: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT_ID', FALSE);
191: FND_MESSAGE.Set_Token('VALUE', to_char(p_qte_rec.cust_account_id), FALSE);
192: FND_MSG_PUB.ADD;
193: END IF;

Line 190: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT_ID', FALSE);

186: IF C_Get_Party_From_Acct%NOTFOUND THEN
187: x_Return_Status := FND_API.G_RET_STS_ERROR;
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
189: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
190: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT_ID', FALSE);
191: FND_MESSAGE.Set_Token('VALUE', to_char(p_qte_rec.cust_account_id), FALSE);
192: FND_MSG_PUB.ADD;
193: END IF;
194: CLOSE C_Get_Party_From_Acct;

Line 191: FND_MESSAGE.Set_Token('VALUE', to_char(p_qte_rec.cust_account_id), FALSE);

187: x_Return_Status := FND_API.G_RET_STS_ERROR;
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
189: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
190: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT_ID', FALSE);
191: FND_MESSAGE.Set_Token('VALUE', to_char(p_qte_rec.cust_account_id), FALSE);
192: FND_MSG_PUB.ADD;
193: END IF;
194: CLOSE C_Get_Party_From_Acct;
195: raise FND_API.G_EXC_ERROR;

Line 309: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_ORG_CON_ACT_CRS');

305: p_qte_rec.party_id := l_org_contact_party_id;
306: end if;
307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
309: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_ORG_CON_ACT_CRS');
310: -- FND_MESSAGE.Set_Token('ID', to_char(p_qte_rec.org_contact_id),FALSE);
311: FND_MSG_PUB.ADD;
312: END IF;
313: raise FND_API.G_EXC_ERROR;

Line 310: -- FND_MESSAGE.Set_Token('ID', to_char(p_qte_rec.org_contact_id),FALSE);

306: end if;
307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
309: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_ORG_CON_ACT_CRS');
310: -- FND_MESSAGE.Set_Token('ID', to_char(p_qte_rec.org_contact_id),FALSE);
311: FND_MSG_PUB.ADD;
312: END IF;
313: raise FND_API.G_EXC_ERROR;
314: END IF;

Line 335: FND_MESSAGE.Set_Name('ASO', 'ASO_ORG_CONTACT');

331: aso_debug_pub.add('after create contact role. x_return_status = ' || x_return_status ,1, 'N');
332: END IF;
333: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
335: FND_MESSAGE.Set_Name('ASO', 'ASO_ORG_CONTACT');
336: FND_MESSAGE.Set_Token('ID', to_char(p_qte_rec.party_id), FALSE);
337: FND_MSG_PUB.ADD;
338: END IF;
339: raise FND_API.G_EXC_ERROR;

Line 336: FND_MESSAGE.Set_Token('ID', to_char(p_qte_rec.party_id), FALSE);

332: END IF;
333: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
335: FND_MESSAGE.Set_Name('ASO', 'ASO_ORG_CONTACT');
336: FND_MESSAGE.Set_Token('ID', to_char(p_qte_rec.party_id), FALSE);
337: FND_MSG_PUB.ADD;
338: END IF;
339: raise FND_API.G_EXC_ERROR;
340: END IF;

Line 610: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');

606: aso_debug_pub.add('chk_hdr:cust_acct_site_id after deriving invoice = ' || l_inv_cust_acct_site_id,1,'N');
607: END IF;
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
609: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
610: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
611: FND_MSG_PUB.ADD;
612: END IF;
613: raise FND_API.G_EXC_ERROR;
614: END IF;

Line 738: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');

734: aso_debug_pub.add('chk_hdr:cust_acct_site_id after deriving End_Customer = ' || l_end_cust_acct_site_id,1,'N');
735: END IF;
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
738: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
739: FND_MSG_PUB.ADD;
740: END IF;
741: raise FND_API.G_EXC_ERROR;
742: END IF;

Line 879: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');

875: aso_debug_pub.add('chk_hdr:ship cust acct site after deriving = ' || l_shp_cust_acct_site_id, 1, 'Y');
876: END IF;
877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
878: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
879: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');
880: -- FND_MESSAGE.Set_Token('ID', to_char(p_header_shipment_tbl(1).ship_to_party_site_id),FALSE);
881: FND_MSG_PUB.ADD;
882: END IF;
883: raise FND_API.G_EXC_ERROR;

Line 880: -- FND_MESSAGE.Set_Token('ID', to_char(p_header_shipment_tbl(1).ship_to_party_site_id),FALSE);

876: END IF;
877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
878: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
879: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');
880: -- FND_MESSAGE.Set_Token('ID', to_char(p_header_shipment_tbl(1).ship_to_party_site_id),FALSE);
881: FND_MSG_PUB.ADD;
882: END IF;
883: raise FND_API.G_EXC_ERROR;
884: END IF;

Line 1233: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');

1229: ,x_site_use_id => l_site_use_id);
1230:
1231: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1233: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
1234: FND_MSG_PUB.ADD;
1235: END IF;
1236: raise FND_API.G_EXC_ERROR;
1237: END IF;

Line 1377: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');

1373: ,x_site_use_id => l_site_use_id);
1374:
1375: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1377: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
1378: FND_MSG_PUB.ADD;
1379: END IF;
1380: raise FND_API.G_EXC_ERROR;
1381: END IF;

Line 1516: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');

1512: aso_debug_pub.add('line acct info: after cust_acct_site:l_shp_cust_acct_site_id: '||l_shp_cust_acct_site_id,1,'N');
1513: END IF;
1514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1516: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
1517: -- FND_MESSAGE.Set_Token('ID', to_char(p_line_shipment_tbl(j).ship_to_party_site_id),FALSE);
1518: FND_MSG_PUB.ADD;
1519: END IF;
1520: raise FND_API.G_EXC_ERROR;

Line 1517: -- FND_MESSAGE.Set_Token('ID', to_char(p_line_shipment_tbl(j).ship_to_party_site_id),FALSE);

1513: END IF;
1514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1516: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
1517: -- FND_MESSAGE.Set_Token('ID', to_char(p_line_shipment_tbl(j).ship_to_party_site_id),FALSE);
1518: FND_MSG_PUB.ADD;
1519: END IF;
1520: raise FND_API.G_EXC_ERROR;
1521: END IF;

Line 1719: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');

1715: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');
1716: END IF;
1717: IF l_acct_count > 1 THEN
1718: x_return_status := FND_API.G_RET_STS_ERROR;
1719: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
1720: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1721: FND_MSG_PUB.ADD;
1722: RAISE FND_API.G_EXC_ERROR;
1723: END IF;

Line 1720: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);

1716: END IF;
1717: IF l_acct_count > 1 THEN
1718: x_return_status := FND_API.G_RET_STS_ERROR;
1719: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
1720: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1721: FND_MSG_PUB.ADD;
1722: RAISE FND_API.G_EXC_ERROR;
1723: END IF;
1724: END IF;

Line 1747: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');

1743: aso_debug_pub.add('Cust_Acct:l_acct_count: '|| l_acct_count,1,'N');
1744: END IF;
1745: IF l_acct_count > 1 THEN
1746: x_return_status := FND_API.G_RET_STS_ERROR;
1747: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
1748: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1749: FND_MSG_PUB.ADD;
1750: RAISE FND_API.G_EXC_ERROR;
1751: END IF;

Line 1748: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);

1744: END IF;
1745: IF l_acct_count > 1 THEN
1746: x_return_status := FND_API.G_RET_STS_ERROR;
1747: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
1748: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1749: FND_MSG_PUB.ADD;
1750: RAISE FND_API.G_EXC_ERROR;
1751: END IF;
1752: END IF;

Line 1789: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');

1785: END IF;
1786:
1787: IF l_acct_count > 1 THEN
1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
1790: FND_MESSAGE.Set_Token('ID', to_char(l_object_party_id), FALSE);
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: END IF;

Line 1790: FND_MESSAGE.Set_Token('ID', to_char(l_object_party_id), FALSE);

1786:
1787: IF l_acct_count > 1 THEN
1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
1790: FND_MESSAGE.Set_Token('ID', to_char(l_object_party_id), FALSE);
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: END IF;
1794: END IF;

Line 1816: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');

1812: aso_debug_pub.add('Cust_Acct:l_create_acct_prof: '|| l_create_acct_prof,1,'N');
1813: END IF;
1814: IF p_calling_api_flag = 1 AND (l_create_acct_prof = 'PLACE_ORDER') THEN
1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;
1820:

Line 1841: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

1837: x_msg_data => x_msg_data,
1838: x_cust_acct_id => cust_account_id);
1839: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1840: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1841: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
1842: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1843: FND_MSG_PUB.ADD;
1844: END IF;
1845: raise FND_API.G_EXC_ERROR;

Line 1842: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);

1838: x_cust_acct_id => cust_account_id);
1839: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1840: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1841: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
1842: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1843: FND_MSG_PUB.ADD;
1844: END IF;
1845: raise FND_API.G_EXC_ERROR;
1846: END IF;

Line 1852: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

1848: END IF; -- end party if
1849: ELSIF p_calling_api_flag <> 0 THEN -- profile is N raise error
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1852: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
1853: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1854: FND_MSG_PUB.ADD;
1855: END IF;
1856: raise FND_API.G_EXC_ERROR;

Line 1853: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);

1849: ELSIF p_calling_api_flag <> 0 THEN -- profile is N raise error
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1852: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
1853: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1854: FND_MSG_PUB.ADD;
1855: END IF;
1856: raise FND_API.G_EXC_ERROR;
1857: END IF; -- end profile condition

Line 2048: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');

2044: l_party_type := NULL;
2045:
2046: x_return_status := FND_API.G_RET_STS_ERROR;
2047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2048: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2049: FND_MSG_PUB.ADD;
2050: END IF;
2051: raise FND_API.G_EXC_ERROR;
2052: END IF;

Line 2065: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');

2061: IF (relationship_cur%NOTFOUND) THEN
2062: cur_party_id := NULL;
2063: x_return_status := FND_API.G_RET_STS_ERROR;
2064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2065: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2066: FND_MSG_PUB.ADD;
2067: END IF;
2068: raise FND_API.G_EXC_ERROR;
2069: END IF;

Line 2098: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');

2094: x_cust_acct_site_id := NULL;
2095: x_site_use_id := NULL;
2096: x_return_status := FND_API.G_RET_STS_ERROR;
2097: IF p_acct_site_type = 'BILL_TO' THEN
2098: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2099: ELSIF p_acct_site_type = 'END_USER' THEN
2100: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2101: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2102: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');

Line 2100: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');

2096: x_return_status := FND_API.G_RET_STS_ERROR;
2097: IF p_acct_site_type = 'BILL_TO' THEN
2098: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2099: ELSIF p_acct_site_type = 'END_USER' THEN
2100: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2101: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2102: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');
2103: END IF;
2104: FND_MSG_PUB.ADD;

Line 2102: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');

2098: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2099: ELSIF p_acct_site_type = 'END_USER' THEN
2100: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2101: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2102: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');
2103: END IF;
2104: FND_MSG_PUB.ADD;
2105: raise FND_API.G_EXC_ERROR;
2106: END IF;

Line 2132: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');

2128: IF inactive_site_use_cur%FOUND THEN
2129: x_site_use_id := NULL;
2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131: IF p_acct_site_type = 'BILL_TO' THEN
2132: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2133: ELSIF p_acct_site_type = 'END_USER' THEN
2134: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2135: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2136: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');

Line 2134: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');

2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131: IF p_acct_site_type = 'BILL_TO' THEN
2132: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2133: ELSIF p_acct_site_type = 'END_USER' THEN
2134: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2135: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2136: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');
2137: END IF;
2138: FND_MSG_PUB.ADD;

Line 2136: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');

2132: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2133: ELSIF p_acct_site_type = 'END_USER' THEN
2134: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2135: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2136: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');
2137: END IF;
2138: FND_MSG_PUB.ADD;
2139: raise FND_API.G_EXC_ERROR;
2140: ELSE

Line 2183: FND_MESSAGE.Set_Name('ASO', 'ASO_ACCT_SITE_USE');

2179: aso_debug_pub.add('site_use_id after deriving invoice = ' || x_site_use_id,1, 'Y');
2180: END IF;
2181: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2183: FND_MESSAGE.Set_Name('ASO', 'ASO_ACCT_SITE_USE');
2184: FND_MESSAGE.Set_Token('ID', to_char(p_party_site_id),FALSE);
2185: FND_MSG_PUB.ADD;
2186: END IF;
2187: raise FND_API.G_EXC_ERROR;

Line 2184: FND_MESSAGE.Set_Token('ID', to_char(p_party_site_id),FALSE);

2180: END IF;
2181: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2183: FND_MESSAGE.Set_Name('ASO', 'ASO_ACCT_SITE_USE');
2184: FND_MESSAGE.Set_Token('ID', to_char(p_party_site_id),FALSE);
2185: FND_MSG_PUB.ADD;
2186: END IF;
2187: raise FND_API.G_EXC_ERROR;
2188: END IF;

Line 2331: FND_MESSAGE.Set_Name(' + appShortName +', 'ASO_INVALID_ACCT_RELTN');

2327: -- the account ids are matched but bill_to_flag or ship_to_flag is not matched.
2328: -- and the profile is 'Y'.
2329: x_return_status := FND_API.G_RET_STS_ERROR;
2330: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2331: FND_MESSAGE.Set_Name(' + appShortName +', 'ASO_INVALID_ACCT_RELTN');
2332: FND_MESSAGE.Set_Token('TYPE', p_relationship_type, FALSE);
2333: FND_MSG_PUB.ADD;
2334: END IF;
2335: RAISE FND_API.G_EXC_ERROR;

Line 2332: FND_MESSAGE.Set_Token('TYPE', p_relationship_type, FALSE);

2328: -- and the profile is 'Y'.
2329: x_return_status := FND_API.G_RET_STS_ERROR;
2330: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2331: FND_MESSAGE.Set_Name(' + appShortName +', 'ASO_INVALID_ACCT_RELTN');
2332: FND_MESSAGE.Set_Token('TYPE', p_relationship_type, FALSE);
2333: FND_MSG_PUB.ADD;
2334: END IF;
2335: RAISE FND_API.G_EXC_ERROR;
2336:

Line 2462: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_PARTY_AC_CRS');

2458: END IF;
2459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2461: IF p_role_type = 'BILL_TO' THEN
2462: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_PARTY_AC_CRS');
2463: ELSIF p_role_type = 'END_USER' THEN
2464: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_PARTY_AC_CRS');
2465: ELSIF p_role_type = 'SHIP_TO' THEN
2466: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_PARTY_AC_CRS');

Line 2464: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_PARTY_AC_CRS');

2460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2461: IF p_role_type = 'BILL_TO' THEN
2462: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_PARTY_AC_CRS');
2463: ELSIF p_role_type = 'END_USER' THEN
2464: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_PARTY_AC_CRS');
2465: ELSIF p_role_type = 'SHIP_TO' THEN
2466: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_PARTY_AC_CRS');
2467: END IF;
2468: FND_MSG_PUB.ADD;

Line 2466: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_PARTY_AC_CRS');

2462: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_PARTY_AC_CRS');
2463: ELSIF p_role_type = 'END_USER' THEN
2464: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_PARTY_AC_CRS');
2465: ELSIF p_role_type = 'SHIP_TO' THEN
2466: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_PARTY_AC_CRS');
2467: END IF;
2468: FND_MSG_PUB.ADD;
2469: END IF;
2470: raise FND_API.G_EXC_ERROR;

Line 2495: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATE_CONTACT');

2491: END IF;
2492:
2493: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2495: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATE_CONTACT');
2496: FND_MESSAGE.Set_Token('ID', to_char(
2497: l_contact_party_id), FALSE);
2498: FND_MSG_PUB.ADD;
2499: END IF;

Line 2496: FND_MESSAGE.Set_Token('ID', to_char(

2492:
2493: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2495: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATE_CONTACT');
2496: FND_MESSAGE.Set_Token('ID', to_char(
2497: l_contact_party_id), FALSE);
2498: FND_MSG_PUB.ADD;
2499: END IF;
2500: raise FND_API.G_EXC_ERROR;

Line 2643: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

2639: OPEN C_Validate_Quote (p_qte_header_id);
2640: FETCH C_Validate_Quote into l_dummy;
2641: IF C_Validate_Quote%NOTFOUND THEN
2642: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2643: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2644: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
2645: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
2646: FND_MSG_PUB.ADD;
2647: END IF;

Line 2644: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);

2640: FETCH C_Validate_Quote into l_dummy;
2641: IF C_Validate_Quote%NOTFOUND THEN
2642: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2643: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2644: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
2645: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
2646: FND_MSG_PUB.ADD;
2647: END IF;
2648:

Line 2645: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);

2641: IF C_Validate_Quote%NOTFOUND THEN
2642: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2643: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2644: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
2645: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
2646: FND_MSG_PUB.ADD;
2647: END IF;
2648:
2649: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2739: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

2735:
2736:
2737: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2738: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2739: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2740: FND_MESSAGE.Set_Token('ID', to_char( l_cust_party), FALSE);
2741: FND_MSG_PUB.ADD;
2742: END IF;
2743: raise FND_API.G_EXC_ERROR;

Line 2740: FND_MESSAGE.Set_Token('ID', to_char( l_cust_party), FALSE);

2736:
2737: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2738: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2739: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2740: FND_MESSAGE.Set_Token('ID', to_char( l_cust_party), FALSE);
2741: FND_MSG_PUB.ADD;
2742: END IF;
2743: raise FND_API.G_EXC_ERROR;
2744:

Line 2788: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

2784:
2785:
2786: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2788: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2789: FND_MESSAGE.Set_Token('ID', to_char( l_inv_cust_party), FALSE);
2790: FND_MSG_PUB.ADD;
2791: END IF;
2792: raise FND_API.G_EXC_ERROR;

Line 2789: FND_MESSAGE.Set_Token('ID', to_char( l_inv_cust_party), FALSE);

2785:
2786: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2788: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2789: FND_MESSAGE.Set_Token('ID', to_char( l_inv_cust_party), FALSE);
2790: FND_MSG_PUB.ADD;
2791: END IF;
2792: raise FND_API.G_EXC_ERROR;
2793:

Line 2837: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

2833:
2834:
2835: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2836: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2837: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2838: FND_MESSAGE.Set_Token('ID', to_char( l_end_cust_party), FALSE);
2839: FND_MSG_PUB.ADD;
2840: END IF;
2841: raise FND_API.G_EXC_ERROR;

Line 2838: FND_MESSAGE.Set_Token('ID', to_char( l_end_cust_party), FALSE);

2834:
2835: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2836: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2837: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2838: FND_MESSAGE.Set_Token('ID', to_char( l_end_cust_party), FALSE);
2839: FND_MSG_PUB.ADD;
2840: END IF;
2841: raise FND_API.G_EXC_ERROR;
2842:

Line 2887: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

2883: END IF;
2884:
2885: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2887: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2888: FND_MESSAGE.Set_Token('ID', to_char( l_header_shipment_tbl(1).ship_to_cust_party_id), FALSE);
2889: FND_MSG_PUB.ADD;
2890: END IF;
2891: raise FND_API.G_EXC_ERROR;

Line 2888: FND_MESSAGE.Set_Token('ID', to_char( l_header_shipment_tbl(1).ship_to_cust_party_id), FALSE);

2884:
2885: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2887: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2888: FND_MESSAGE.Set_Token('ID', to_char( l_header_shipment_tbl(1).ship_to_cust_party_id), FALSE);
2889: FND_MSG_PUB.ADD;
2890: END IF;
2891: raise FND_API.G_EXC_ERROR;
2892:

Line 3002: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

2998: END IF;
2999:
3000: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3002: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3003: FND_MESSAGE.Set_Token('ID', to_char( l_qte_line_rec.invoice_to_cust_party_id), FALSE);
3004: FND_MSG_PUB.ADD;
3005: END IF;
3006: raise FND_API.G_EXC_ERROR;

Line 3003: FND_MESSAGE.Set_Token('ID', to_char( l_qte_line_rec.invoice_to_cust_party_id), FALSE);

2999:
3000: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3002: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3003: FND_MESSAGE.Set_Token('ID', to_char( l_qte_line_rec.invoice_to_cust_party_id), FALSE);
3004: FND_MSG_PUB.ADD;
3005: END IF;
3006: raise FND_API.G_EXC_ERROR;
3007:

Line 3049: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

3045: END IF;
3046:
3047: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3048: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3049: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3050: FND_MESSAGE.Set_Token('ID', to_char( l_qte_line_rec.End_Customer_cust_party_id), FALSE);
3051: FND_MSG_PUB.ADD;
3052: END IF;
3053: raise FND_API.G_EXC_ERROR;

Line 3050: FND_MESSAGE.Set_Token('ID', to_char( l_qte_line_rec.End_Customer_cust_party_id), FALSE);

3046:
3047: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3048: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3049: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3050: FND_MESSAGE.Set_Token('ID', to_char( l_qte_line_rec.End_Customer_cust_party_id), FALSE);
3051: FND_MSG_PUB.ADD;
3052: END IF;
3053: raise FND_API.G_EXC_ERROR;
3054:

Line 3096: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

3092: END IF;
3093:
3094: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3096: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3097: FND_MESSAGE.Set_Token('ID', to_char( Line_Acct.ship_to_cust_party_id), FALSE);
3098: FND_MSG_PUB.ADD;
3099: END IF;
3100: raise FND_API.G_EXC_ERROR;

Line 3097: FND_MESSAGE.Set_Token('ID', to_char( Line_Acct.ship_to_cust_party_id), FALSE);

3093:
3094: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3096: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3097: FND_MESSAGE.Set_Token('ID', to_char( Line_Acct.ship_to_cust_party_id), FALSE);
3098: FND_MSG_PUB.ADD;
3099: END IF;
3100: raise FND_API.G_EXC_ERROR;
3101:

Line 3241: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

3237: END IF;
3238: IF l_inv_cust_id <> p_cust_party_id THEN
3239: x_return_status := FND_API.G_RET_STS_ERROR;
3240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3241: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3242: FND_MESSAGE.Set_Token('COLUMN', 'CUST_PARTY_ID',FALSE);
3243: FND_MESSAGE.Set_Token('VALUE', to_char(p_cust_party_id),FALSE);
3244: FND_MSG_PUB.ADD;
3245: END IF;

Line 3242: FND_MESSAGE.Set_Token('COLUMN', 'CUST_PARTY_ID',FALSE);

3238: IF l_inv_cust_id <> p_cust_party_id THEN
3239: x_return_status := FND_API.G_RET_STS_ERROR;
3240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3241: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3242: FND_MESSAGE.Set_Token('COLUMN', 'CUST_PARTY_ID',FALSE);
3243: FND_MESSAGE.Set_Token('VALUE', to_char(p_cust_party_id),FALSE);
3244: FND_MSG_PUB.ADD;
3245: END IF;
3246: raise FND_API.G_EXC_ERROR;

Line 3243: FND_MESSAGE.Set_Token('VALUE', to_char(p_cust_party_id),FALSE);

3239: x_return_status := FND_API.G_RET_STS_ERROR;
3240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3241: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3242: FND_MESSAGE.Set_Token('COLUMN', 'CUST_PARTY_ID',FALSE);
3243: FND_MESSAGE.Set_Token('VALUE', to_char(p_cust_party_id),FALSE);
3244: FND_MSG_PUB.ADD;
3245: END IF;
3246: raise FND_API.G_EXC_ERROR;
3247: END IF;

Line 3370: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

3366: OPEN C_Validate_Quote (p_qte_header_id);
3367: FETCH C_Validate_Quote into l_dummy;
3368: IF C_Validate_Quote%NOTFOUND THEN
3369: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3370: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3371: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
3372: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
3373: FND_MSG_PUB.ADD;
3374: END IF;

Line 3371: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);

3367: FETCH C_Validate_Quote into l_dummy;
3368: IF C_Validate_Quote%NOTFOUND THEN
3369: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3370: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3371: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
3372: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
3373: FND_MSG_PUB.ADD;
3374: END IF;
3375:

Line 3372: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);

3368: IF C_Validate_Quote%NOTFOUND THEN
3369: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3370: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3371: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
3372: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
3373: FND_MSG_PUB.ADD;
3374: END IF;
3375:
3376: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3416: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');

3412: END IF;
3413:
3414: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3415: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3416: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3417: FND_MSG_PUB.ADD;
3418: END IF;
3419: x_return_status := FND_API.G_RET_STS_ERROR;
3420: RAISE FND_API.G_EXC_ERROR;

Line 3448: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');

3444: END IF;
3445:
3446: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3447: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3448: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3449: FND_MSG_PUB.ADD;
3450: END IF;
3451: x_return_status := FND_API.G_RET_STS_ERROR;
3452: RAISE FND_API.G_EXC_ERROR;

Line 3480: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');

3476: END IF;
3477:
3478: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3480: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3481: FND_MSG_PUB.ADD;
3482: END IF;
3483: x_return_status := FND_API.G_RET_STS_ERROR;
3484: RAISE FND_API.G_EXC_ERROR;

Line 3512: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');

3508: END IF;
3509:
3510: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3511: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3512: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3513: FND_MSG_PUB.ADD;
3514: END IF;
3515: x_return_status := FND_API.G_RET_STS_ERROR;
3516: RAISE FND_API.G_EXC_ERROR;

Line 3546: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');

3542: END IF;
3543:
3544: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3546: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3547: FND_MSG_PUB.ADD;
3548: END IF;
3549: x_return_status := FND_API.G_RET_STS_ERROR;
3550: RAISE FND_API.G_EXC_ERROR;

Line 3580: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');

3576: END IF;
3577:
3578: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3580: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3581: FND_MSG_PUB.ADD;
3582: END IF;
3583: x_return_status := FND_API.G_RET_STS_ERROR;
3584: RAISE FND_API.G_EXC_ERROR;