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.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: -- ER 5484749

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

1819: END IF;
1820: -- ER 5484749
1821: IF p_calling_api_flag = 2 AND (l_create_acct_prof = 'NEVER') THEN
1822: x_return_status := FND_API.G_RET_STS_ERROR;
1823: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
1824: FND_MSG_PUB.ADD;
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827:

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

1845: x_msg_data => x_msg_data,
1846: x_cust_acct_id => cust_account_id);
1847: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1848: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1849: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
1850: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1851: FND_MSG_PUB.ADD;
1852: END IF;
1853: raise FND_API.G_EXC_ERROR;

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

1846: x_cust_acct_id => cust_account_id);
1847: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1848: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1849: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
1850: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1851: FND_MSG_PUB.ADD;
1852: END IF;
1853: raise FND_API.G_EXC_ERROR;
1854: END IF;

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

1856: END IF; -- end party if
1857: ELSIF p_calling_api_flag <> 0 THEN -- profile is N raise error
1858: x_return_status := FND_API.G_RET_STS_ERROR;
1859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1860: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
1861: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1862: FND_MSG_PUB.ADD;
1863: END IF;
1864: raise FND_API.G_EXC_ERROR;

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

1857: ELSIF p_calling_api_flag <> 0 THEN -- profile is N raise error
1858: x_return_status := FND_API.G_RET_STS_ERROR;
1859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1860: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
1861: FND_MESSAGE.Set_Token('ID', to_char(p_Party_Id), FALSE);
1862: FND_MSG_PUB.ADD;
1863: END IF;
1864: raise FND_API.G_EXC_ERROR;
1865: END IF; -- end profile condition

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

2052: l_party_type := NULL;
2053:
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2056: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2057: FND_MSG_PUB.ADD;
2058: END IF;
2059: raise FND_API.G_EXC_ERROR;
2060: END IF;

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

2069: IF (relationship_cur%NOTFOUND) THEN
2070: cur_party_id := NULL;
2071: x_return_status := FND_API.G_RET_STS_ERROR;
2072: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2073: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2074: FND_MSG_PUB.ADD;
2075: END IF;
2076: raise FND_API.G_EXC_ERROR;
2077: END IF;

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

2102: x_cust_acct_site_id := NULL;
2103: x_site_use_id := NULL;
2104: x_return_status := FND_API.G_RET_STS_ERROR;
2105: IF p_acct_site_type = 'BILL_TO' THEN
2106: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2107: ELSIF p_acct_site_type = 'END_USER' THEN
2108: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2109: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2110: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');

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

2104: x_return_status := FND_API.G_RET_STS_ERROR;
2105: IF p_acct_site_type = 'BILL_TO' THEN
2106: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2107: ELSIF p_acct_site_type = 'END_USER' THEN
2108: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2109: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2110: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');
2111: END IF;
2112: FND_MSG_PUB.ADD;

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

2106: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2107: ELSIF p_acct_site_type = 'END_USER' THEN
2108: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2109: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2110: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');
2111: END IF;
2112: FND_MSG_PUB.ADD;
2113: raise FND_API.G_EXC_ERROR;
2114: END IF;

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

2136: IF inactive_site_use_cur%FOUND THEN
2137: x_site_use_id := NULL;
2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139: IF p_acct_site_type = 'BILL_TO' THEN
2140: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2141: ELSIF p_acct_site_type = 'END_USER' THEN
2142: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2143: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2144: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');

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

2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139: IF p_acct_site_type = 'BILL_TO' THEN
2140: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2141: ELSIF p_acct_site_type = 'END_USER' THEN
2142: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2143: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2144: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');
2145: END IF;
2146: FND_MSG_PUB.ADD;

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

2140: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2141: ELSIF p_acct_site_type = 'END_USER' THEN
2142: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_SITE_INACTIVE');
2143: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2144: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_SITE_INACTIVE');
2145: END IF;
2146: FND_MSG_PUB.ADD;
2147: raise FND_API.G_EXC_ERROR;
2148: ELSE

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

2187: aso_debug_pub.add('site_use_id after deriving invoice = ' || x_site_use_id,1, 'Y');
2188: END IF;
2189: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2191: FND_MESSAGE.Set_Name('ASO', 'ASO_ACCT_SITE_USE');
2192: FND_MESSAGE.Set_Token('ID', to_char(p_party_site_id),FALSE);
2193: FND_MSG_PUB.ADD;
2194: END IF;
2195: raise FND_API.G_EXC_ERROR;

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

2188: END IF;
2189: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2191: FND_MESSAGE.Set_Name('ASO', 'ASO_ACCT_SITE_USE');
2192: FND_MESSAGE.Set_Token('ID', to_char(p_party_site_id),FALSE);
2193: FND_MSG_PUB.ADD;
2194: END IF;
2195: raise FND_API.G_EXC_ERROR;
2196: END IF;

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

2351: -- the account ids are matched but bill_to_flag or ship_to_flag is not matched.
2352: -- and the profile is 'Y'.
2353: --- x_return_status := FND_API.G_RET_STS_ERROR;
2354: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2355: -- FND_MESSAGE.Set_Name(' + appShortName +', 'ASO_INVALID_ACCT_RELTN');
2356: -- FND_MESSAGE.Set_Token('TYPE', p_relationship_type, FALSE);
2357: -- FND_MSG_PUB.ADD;
2358: -- END IF;
2359: -- RAISE FND_API.G_EXC_ERROR;

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

2352: -- and the profile is 'Y'.
2353: --- x_return_status := FND_API.G_RET_STS_ERROR;
2354: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2355: -- FND_MESSAGE.Set_Name(' + appShortName +', 'ASO_INVALID_ACCT_RELTN');
2356: -- FND_MESSAGE.Set_Token('TYPE', p_relationship_type, FALSE);
2357: -- FND_MSG_PUB.ADD;
2358: -- END IF;
2359: -- RAISE FND_API.G_EXC_ERROR;
2360:

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

2361: END IF;
2362: /*else
2363: x_return_status := FND_API.G_RET_STS_ERROR;
2364: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2365: FND_MESSAGE.Set_Name(' + appShortName +', 'ASO_INVALID_ACCT_RELTN');
2366: FND_MESSAGE.Set_Token('TYPE', p_relationship_type, FALSE);
2367: FND_MSG_PUB.ADD;
2368: END IF;
2369: RAISE FND_API.G_EXC_ERROR; */

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

2362: /*else
2363: x_return_status := FND_API.G_RET_STS_ERROR;
2364: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2365: FND_MESSAGE.Set_Name(' + appShortName +', 'ASO_INVALID_ACCT_RELTN');
2366: FND_MESSAGE.Set_Token('TYPE', p_relationship_type, FALSE);
2367: FND_MSG_PUB.ADD;
2368: END IF;
2369: RAISE FND_API.G_EXC_ERROR; */
2370:

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

2492: END IF;
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: IF p_role_type = 'BILL_TO' THEN
2496: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_PARTY_AC_CRS');
2497: ELSIF p_role_type = 'END_USER' THEN
2498: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_PARTY_AC_CRS');
2499: ELSIF p_role_type = 'SHIP_TO' THEN
2500: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_PARTY_AC_CRS');

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

2494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2495: IF p_role_type = 'BILL_TO' THEN
2496: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_PARTY_AC_CRS');
2497: ELSIF p_role_type = 'END_USER' THEN
2498: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_PARTY_AC_CRS');
2499: ELSIF p_role_type = 'SHIP_TO' THEN
2500: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_PARTY_AC_CRS');
2501: END IF;
2502: FND_MSG_PUB.ADD;

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

2496: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_PARTY_AC_CRS');
2497: ELSIF p_role_type = 'END_USER' THEN
2498: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_PARTY_AC_CRS');
2499: ELSIF p_role_type = 'SHIP_TO' THEN
2500: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_PARTY_AC_CRS');
2501: END IF;
2502: FND_MSG_PUB.ADD;
2503: END IF;
2504: raise FND_API.G_EXC_ERROR;

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

2525: END IF;
2526:
2527: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2529: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATE_CONTACT');
2530: FND_MESSAGE.Set_Token('ID', to_char(
2531: l_contact_party_id), FALSE);
2532: FND_MSG_PUB.ADD;
2533: END IF;

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

2526:
2527: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2529: FND_MESSAGE.Set_Name('ASO', 'ASO_CREATE_CONTACT');
2530: FND_MESSAGE.Set_Token('ID', to_char(
2531: l_contact_party_id), FALSE);
2532: FND_MSG_PUB.ADD;
2533: END IF;
2534: raise FND_API.G_EXC_ERROR;

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

2673: OPEN C_Validate_Quote (p_qte_header_id);
2674: FETCH C_Validate_Quote into l_dummy;
2675: IF C_Validate_Quote%NOTFOUND THEN
2676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2677: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2678: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
2679: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
2680: FND_MSG_PUB.ADD;
2681: END IF;

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

2674: FETCH C_Validate_Quote into l_dummy;
2675: IF C_Validate_Quote%NOTFOUND THEN
2676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2677: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2678: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
2679: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
2680: FND_MSG_PUB.ADD;
2681: END IF;
2682:

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

2675: IF C_Validate_Quote%NOTFOUND THEN
2676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2677: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
2678: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
2679: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
2680: FND_MSG_PUB.ADD;
2681: END IF;
2682:
2683: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

2770:
2771: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2773: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
2774: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2775: FND_MESSAGE.Set_Token('ID', to_char( l_cust_party), FALSE);
2776: FND_MSG_PUB.ADD;
2777: end if;
2778: END IF;

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

2771: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2773: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
2774: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2775: FND_MESSAGE.Set_Token('ID', to_char( l_cust_party), FALSE);
2776: FND_MSG_PUB.ADD;
2777: end if;
2778: END IF;
2779: raise FND_API.G_EXC_ERROR;

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

2821:
2822: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2824: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
2825: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2826: FND_MESSAGE.Set_Token('ID', to_char( l_inv_cust_party), FALSE);
2827: FND_MSG_PUB.ADD;
2828: end if;
2829: END IF;

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

2822: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2824: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
2825: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2826: FND_MESSAGE.Set_Token('ID', to_char( l_inv_cust_party), FALSE);
2827: FND_MSG_PUB.ADD;
2828: end if;
2829: END IF;
2830: raise FND_API.G_EXC_ERROR;

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

2872:
2873: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2875: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
2876: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2877: FND_MESSAGE.Set_Token('ID', to_char( l_end_cust_party), FALSE);
2878: FND_MSG_PUB.ADD;
2879: end if;
2880: END IF;

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

2873: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2875: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
2876: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2877: FND_MESSAGE.Set_Token('ID', to_char( l_end_cust_party), FALSE);
2878: FND_MSG_PUB.ADD;
2879: end if;
2880: END IF;
2881: raise FND_API.G_EXC_ERROR;

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

2924:
2925: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2926: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2927: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
2928: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2929: FND_MESSAGE.Set_Token('ID', to_char( l_header_shipment_tbl(1).ship_to_cust_party_id), FALSE);
2930: FND_MSG_PUB.ADD;
2931: END IF;
2932: end if;

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

2925: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2926: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2927: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
2928: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2929: FND_MESSAGE.Set_Token('ID', to_char( l_header_shipment_tbl(1).ship_to_cust_party_id), FALSE);
2930: FND_MSG_PUB.ADD;
2931: END IF;
2932: end if;
2933: raise FND_API.G_EXC_ERROR;

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

3041:
3042: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3044: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
3045: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3046: FND_MESSAGE.Set_Token('ID', to_char( l_qte_line_rec.invoice_to_cust_party_id), FALSE);
3047: FND_MSG_PUB.ADD;
3048: end if;
3049: END IF;

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

3042: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3044: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
3045: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3046: FND_MESSAGE.Set_Token('ID', to_char( l_qte_line_rec.invoice_to_cust_party_id), FALSE);
3047: FND_MSG_PUB.ADD;
3048: end if;
3049: END IF;
3050: raise FND_API.G_EXC_ERROR;

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

3090:
3091: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3092: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3093: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
3094: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3095: FND_MESSAGE.Set_Token('ID', to_char( l_qte_line_rec.End_Customer_cust_party_id), FALSE);
3096: FND_MSG_PUB.ADD;
3097: end if;
3098: END IF;

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

3091: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3092: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3093: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
3094: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3095: FND_MESSAGE.Set_Token('ID', to_char( l_qte_line_rec.End_Customer_cust_party_id), FALSE);
3096: FND_MSG_PUB.ADD;
3097: end if;
3098: END IF;
3099: raise FND_API.G_EXC_ERROR;

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

3139:
3140: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3142: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
3143: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3144: FND_MESSAGE.Set_Token('ID', to_char( Line_Acct.ship_to_cust_party_id), FALSE);
3145: FND_MSG_PUB.ADD;
3146: end if;
3147: END IF;

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

3140: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3142: if NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED')<>'NEVER' then -- ER 5484749
3143: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3144: FND_MESSAGE.Set_Token('ID', to_char( Line_Acct.ship_to_cust_party_id), FALSE);
3145: FND_MSG_PUB.ADD;
3146: end if;
3147: END IF;
3148: raise FND_API.G_EXC_ERROR;

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

3285: END IF;
3286: IF l_inv_cust_id <> p_cust_party_id THEN
3287: x_return_status := FND_API.G_RET_STS_ERROR;
3288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3289: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3290: FND_MESSAGE.Set_Token('COLUMN', 'CUST_PARTY_ID',FALSE);
3291: FND_MESSAGE.Set_Token('VALUE', to_char(p_cust_party_id),FALSE);
3292: FND_MSG_PUB.ADD;
3293: END IF;

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

3286: IF l_inv_cust_id <> p_cust_party_id THEN
3287: x_return_status := FND_API.G_RET_STS_ERROR;
3288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3289: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3290: FND_MESSAGE.Set_Token('COLUMN', 'CUST_PARTY_ID',FALSE);
3291: FND_MESSAGE.Set_Token('VALUE', to_char(p_cust_party_id),FALSE);
3292: FND_MSG_PUB.ADD;
3293: END IF;
3294: raise FND_API.G_EXC_ERROR;

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

3287: x_return_status := FND_API.G_RET_STS_ERROR;
3288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3289: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3290: FND_MESSAGE.Set_Token('COLUMN', 'CUST_PARTY_ID',FALSE);
3291: FND_MESSAGE.Set_Token('VALUE', to_char(p_cust_party_id),FALSE);
3292: FND_MSG_PUB.ADD;
3293: END IF;
3294: raise FND_API.G_EXC_ERROR;
3295: END IF;

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

3414: OPEN C_Validate_Quote (p_qte_header_id);
3415: FETCH C_Validate_Quote into l_dummy;
3416: IF C_Validate_Quote%NOTFOUND THEN
3417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3418: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3419: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
3420: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
3421: FND_MSG_PUB.ADD;
3422: END IF;

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

3415: FETCH C_Validate_Quote into l_dummy;
3416: IF C_Validate_Quote%NOTFOUND THEN
3417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3418: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3419: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
3420: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
3421: FND_MSG_PUB.ADD;
3422: END IF;
3423:

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

3416: IF C_Validate_Quote%NOTFOUND THEN
3417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3418: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
3419: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
3420: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_id), FALSE);
3421: FND_MSG_PUB.ADD;
3422: END IF;
3423:
3424: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

3460: END IF;
3461:
3462: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3464: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3465: FND_MSG_PUB.ADD;
3466: END IF;
3467: x_return_status := FND_API.G_RET_STS_ERROR;
3468: RAISE FND_API.G_EXC_ERROR;

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

3492: END IF;
3493:
3494: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3496: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3497: FND_MSG_PUB.ADD;
3498: END IF;
3499: x_return_status := FND_API.G_RET_STS_ERROR;
3500: RAISE FND_API.G_EXC_ERROR;

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

3524: END IF;
3525:
3526: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3528: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3529: FND_MSG_PUB.ADD;
3530: END IF;
3531: x_return_status := FND_API.G_RET_STS_ERROR;
3532: RAISE FND_API.G_EXC_ERROR;

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

3556: END IF;
3557:
3558: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3560: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3561: FND_MSG_PUB.ADD;
3562: END IF;
3563: x_return_status := FND_API.G_RET_STS_ERROR;
3564: RAISE FND_API.G_EXC_ERROR;

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

3590: END IF;
3591:
3592: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3593: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3594: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3595: FND_MSG_PUB.ADD;
3596: END IF;
3597: x_return_status := FND_API.G_RET_STS_ERROR;
3598: RAISE FND_API.G_EXC_ERROR;

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

3624: END IF;
3625:
3626: IF l_cust_acct IS NULL OR l_cust_acct = FND_API.G_MISS_NUM THEN
3627: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3628: FND_MESSAGE.Set_Name('ASO', 'ASO_CANNOT_CREATE_ACCOUNT');
3629: FND_MSG_PUB.ADD;
3630: END IF;
3631: x_return_status := FND_API.G_RET_STS_ERROR;
3632: RAISE FND_API.G_EXC_ERROR;