APPS.ASO_CHECK_TCA_PVT dependencies on FND_MSG_PUB

Line 62: FND_MSG_PUB.initialize;

58:
59: SAVEPOINT CHECK_TCA_PVT;
60:
61: IF FND_API.to_boolean(p_init_msg_list) THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: IF NOT FND_API.compatible_api_call(
66: l_api_version,

Line 188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

184: OPEN C_Get_Party_From_Acct(p_qte_rec.cust_account_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;

Line 192: FND_MSG_PUB.ADD;

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

Line 308: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

304: if p_qte_rec.org_contact_id is not null and p_qte_rec.org_contact_id <> FND_API.G_MISS_NUM then
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;

Line 311: FND_MSG_PUB.ADD;

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;
315: IF l_sold_to_contact_id is NULL OR

Line 334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

330: aso_debug_pub.add('after create contact role. sold_to_contact_id = ' || l_sold_to_contact_id ,1, 'N');
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;

Line 337: FND_MSG_PUB.ADD;

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

Line 369: FND_MSG_PUB.Count_And_Get

365: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
366: raise FND_API.G_EXC_ERROR;
367: END IF;
368:
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count,
371: p_data => x_msg_data
372: );
373:

Line 379: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

375: WHEN FND_API.G_EXC_ERROR THEN
376: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
377: P_API_NAME => L_API_NAME
378: ,P_PKG_NAME => G_PKG_NAME
379: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
380: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
381: ,P_SQLCODE => SQLCODE
382: ,P_SQLERRM => SQLERRM
383: ,X_MSG_COUNT => X_MSG_COUNT

Line 391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
392: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
393: ,P_SQLCODE => SQLCODE
394: ,P_SQLERRM => SQLERRM
395: ,X_MSG_COUNT => X_MSG_COUNT

Line 470: FND_MSG_PUB.initialize;

466:
467: SAVEPOINT CHECK_HEADER_ACCOUNT_INFO_PVT;
468:
469: IF FND_API.to_boolean(p_init_msg_list) THEN
470: FND_MSG_PUB.initialize;
471: END IF;
472:
473: IF NOT FND_API.compatible_api_call(
474: l_api_version,

Line 609: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

605: aso_debug_pub.add('chk_hdr:site_use_id after deriving invoice = ' || l_invoice_to_org_id,1,'N');
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;

Line 611: FND_MSG_PUB.ADD;

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

Line 737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

733: aso_debug_pub.add('chk_hdr:site_use_id after deriving End_Customer = ' || l_End_Customer_org_id,1,'N');
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;

Line 739: FND_MSG_PUB.ADD;

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

Line 878: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

874: aso_debug_pub.add('chk_hdr:ship to org after deriving = ' || l_ship_to_org_id, 1, 'Y');
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;

Line 881: FND_MSG_PUB.ADD;

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

Line 921: FND_MSG_PUB.Count_And_Get

917: IF aso_debug_pub.g_debug_flag = 'Y' THEN
918: aso_debug_pub.add('end chk_hdr:after map 2 for header',1,'N');
919: END IF;
920:
921: FND_MSG_PUB.Count_And_Get
922: ( p_count => x_msg_count,
923: p_data => x_msg_data
924: );
925:

Line 931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

927: WHEN FND_API.G_EXC_ERROR THEN
928: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
929: P_API_NAME => L_API_NAME
930: ,P_PKG_NAME => G_PKG_NAME
931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
932: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
933: ,P_SQLCODE => SQLCODE
934: ,P_SQLERRM => SQLERRM
935: ,X_MSG_COUNT => X_MSG_COUNT

Line 943: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
941: P_API_NAME => L_API_NAME
942: ,P_PKG_NAME => G_PKG_NAME
943: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
944: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
945: ,P_SQLCODE => SQLCODE
946: ,P_SQLERRM => SQLERRM
947: ,X_MSG_COUNT => X_MSG_COUNT

Line 1038: FND_MSG_PUB.initialize;

1034:
1035: SAVEPOINT CHECK_LINE_ACCOUNT_INFO_PVT;
1036:
1037: IF FND_API.to_boolean(p_init_msg_list) THEN
1038: FND_MSG_PUB.initialize;
1039: END IF;
1040:
1041: IF NOT FND_API.compatible_api_call(
1042: l_api_version,

Line 1232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1228: ,x_msg_data => x_msg_data
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;

Line 1234: FND_MSG_PUB.ADD;

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;
1238: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1372: ,x_msg_data => x_msg_data
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;

Line 1378: FND_MSG_PUB.ADD;

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;
1382: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1511: aso_debug_pub.add('line acct info: after cust_acct_site:l_site_use_id: '||l_site_use_id,1,'N');
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;

Line 1518: FND_MSG_PUB.ADD;

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

Line 1555: FND_MSG_PUB.Count_And_Get

1551:
1552: END LOOP; -- for shipment
1553:
1554:
1555: FND_MSG_PUB.Count_And_Get
1556: ( p_count => x_msg_count,
1557: p_data => x_msg_data
1558: );
1559:

Line 1565: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1561: WHEN FND_API.G_EXC_ERROR THEN
1562: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1563: P_API_NAME => L_API_NAME
1564: ,P_PKG_NAME => G_PKG_NAME
1565: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1566: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1567: ,P_SQLCODE => SQLCODE
1568: ,P_SQLERRM => SQLERRM
1569: ,X_MSG_COUNT => X_MSG_COUNT

Line 1577: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1574: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1575: P_API_NAME => L_API_NAME
1576: ,P_PKG_NAME => G_PKG_NAME
1577: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1578: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1579: ,P_SQLCODE => SQLCODE
1580: ,P_SQLERRM => SQLERRM
1581: ,X_MSG_COUNT => X_MSG_COUNT

Line 1679: FND_MSG_PUB.initialize;

1675:
1676: SAVEPOINT CUSTOMER_ACCOUNT_PVT;
1677:
1678: IF FND_API.to_boolean(p_init_msg_list) THEN
1679: FND_MSG_PUB.initialize;
1680: END IF;
1681:
1682: IF NOT FND_API.compatible_api_call(
1683: l_api_version,

Line 1721: FND_MSG_PUB.ADD;

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

Line 1749: FND_MSG_PUB.ADD;

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

Line 1791: FND_MSG_PUB.ADD;

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

Line 1817: FND_MSG_PUB.ADD;

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:
1821: IF (l_create_acct_prof = 'ALWAYS') OR

Line 1840: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1836: x_msg_count => x_msg_count,
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;

Line 1843: FND_MSG_PUB.ADD;

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;
1847: x_Cust_Acct_Id := cust_account_id;

Line 1851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1847: x_Cust_Acct_Id := cust_account_id;
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;

Line 1854: FND_MSG_PUB.ADD;

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

Line 1868: FND_MSG_PUB.Count_And_Get

1864:
1865: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1866: aso_debug_pub.add('x_cust_acct_id = '|| x_cust_acct_id,1,'N');
1867: END IF;
1868: FND_MSG_PUB.Count_And_Get
1869: ( p_count => x_msg_count,
1870: p_data => x_msg_data
1871: );
1872:

Line 1878: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1874: WHEN FND_API.G_EXC_ERROR THEN
1875: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1876: P_API_NAME => L_API_NAME
1877: ,P_PKG_NAME => G_PKG_NAME
1878: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1879: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1880: ,P_SQLCODE => SQLCODE
1881: ,P_SQLERRM => SQLERRM
1882: ,X_MSG_COUNT => X_MSG_COUNT

Line 1890: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1887: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1888: P_API_NAME => L_API_NAME
1889: ,P_PKG_NAME => G_PKG_NAME
1890: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1891: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1892: ,P_SQLCODE => SQLCODE
1893: ,P_SQLERRM => SQLERRM
1894: ,X_MSG_COUNT => X_MSG_COUNT

Line 2017: FND_MSG_PUB.initialize;

2013:
2014: SAVEPOINT CUSTOMER_ACCOUNT_SITE_PVT;
2015:
2016: IF FND_API.to_boolean(p_init_msg_list) THEN
2017: FND_MSG_PUB.initialize;
2018: END IF;
2019:
2020: IF NOT FND_API.compatible_api_call(
2021: l_api_version,

Line 2047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2043: IF (party_cur%NOTFOUND) THEN
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;

Line 2049: FND_MSG_PUB.ADD;

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;
2053: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2060: FETCH relationship_cur INTO cur_party_id;
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;

Line 2066: FND_MSG_PUB.ADD;

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;
2070: CLOSE relationship_cur;

Line 2104: FND_MSG_PUB.ADD;

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;
2107: CLOSE inactive_site_cur;
2108: END IF; -- active_site_cur%NOTFOUND end if

Line 2138: FND_MSG_PUB.ADD;

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
2141: -- this means that there no site uses , either active or inactive
2142: x_site_use_id := NULL;

Line 2182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2178: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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;

Line 2185: FND_MSG_PUB.ADD;

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

Line 2191: FND_MSG_PUB.Count_And_Get

2187: raise FND_API.G_EXC_ERROR;
2188: END IF;
2189: END IF;
2190:
2191: FND_MSG_PUB.Count_And_Get
2192: ( p_count => x_msg_count,
2193: p_data => x_msg_data
2194: );
2195:

Line 2201: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2197: WHEN FND_API.G_EXC_ERROR THEN
2198: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2199: P_API_NAME => L_API_NAME
2200: ,P_PKG_NAME => G_PKG_NAME
2201: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2202: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2203: ,P_SQLCODE => SQLCODE
2204: ,P_SQLERRM => SQLERRM
2205: ,X_MSG_COUNT => X_MSG_COUNT

Line 2213: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2210: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2211: P_API_NAME => L_API_NAME
2212: ,P_PKG_NAME => G_PKG_NAME
2213: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2214: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2215: ,P_SQLCODE => SQLCODE
2216: ,P_SQLERRM => SQLERRM
2217: ,X_MSG_COUNT => X_MSG_COUNT

Line 2273: FND_MSG_PUB.initialize;

2269:
2270: SAVEPOINT CUST_ACCT_RELATIONSHIP_PVT;
2271:
2272: IF FND_API.to_boolean(p_init_msg_list) THEN
2273: FND_MSG_PUB.initialize;
2274: END IF;
2275:
2276: IF NOT FND_API.compatible_api_call(
2277: l_api_version,

Line 2330: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2326: ELSE
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;

Line 2333: FND_MSG_PUB.ADD;

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

Line 2342: FND_MSG_PUB.Count_And_Get

2338:
2339: END IF; -- l_cust_acct_flag_match
2340:
2341:
2342: FND_MSG_PUB.Count_And_Get
2343: ( p_count => x_msg_count,
2344: p_data => x_msg_data
2345: );
2346:

Line 2352: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2348: WHEN FND_API.G_EXC_ERROR THEN
2349: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2350: P_API_NAME => L_API_NAME
2351: ,P_PKG_NAME => G_PKG_NAME
2352: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2353: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2354: ,P_SQLCODE => SQLCODE
2355: ,P_SQLERRM => SQLERRM
2356: ,X_MSG_COUNT => X_MSG_COUNT

Line 2364: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2362: P_API_NAME => L_API_NAME
2363: ,P_PKG_NAME => G_PKG_NAME
2364: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2365: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2366: ,P_SQLCODE => SQLCODE
2367: ,P_SQLERRM => SQLERRM
2368: ,X_MSG_COUNT => X_MSG_COUNT

Line 2414: FND_MSG_PUB.initialize;

2410: ---- Initialize---------------------
2411: SAVEPOINT CUST_ACCT_CONTACT_ADDR_PVT;
2412:
2413: IF FND_API.to_boolean(p_init_msg_list) THEN
2414: FND_MSG_PUB.initialize;
2415: END IF;
2416:
2417: IF NOT FND_API.compatible_api_call(
2418: l_api_version,

Line 2460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2456: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2457: aso_debug_pub.add('status after get cust acct roles in Cust_Acct_Contact_Addr = ' || x_return_status,1,'N');
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');

Line 2468: FND_MSG_PUB.ADD;

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;
2471:
2472: ELSE -- x_ret_status = success

Line 2494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2490: aso_debug_pub.add('status after create contact role ship = '|| x_return_status,1,'N');
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;

Line 2498: FND_MSG_PUB.ADD;

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;
2501: END IF; -- for creatE_contact_role
2502:

Line 2511: FND_MSG_PUB.Count_And_Get

2507: END IF; -- for party site
2508:
2509: END IF; -- for party id
2510:
2511: FND_MSG_PUB.Count_And_Get
2512: ( p_count => x_msg_count,
2513: p_data => x_msg_data
2514: );
2515:

Line 2521: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2517: WHEN FND_API.G_EXC_ERROR THEN
2518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2519: P_API_NAME => L_API_NAME
2520: ,P_PKG_NAME => G_PKG_NAME
2521: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2522: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2523: ,P_SQLCODE => SQLCODE
2524: ,P_SQLERRM => SQLERRM
2525: ,X_MSG_COUNT => X_MSG_COUNT

Line 2533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2530: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2531: P_API_NAME => L_API_NAME
2532: ,P_PKG_NAME => G_PKG_NAME
2533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2534: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2535: ,P_SQLCODE => SQLCODE
2536: ,P_SQLERRM => SQLERRM
2537: ,X_MSG_COUNT => X_MSG_COUNT

Line 2629: FND_MSG_PUB.initialize;

2625: SAVEPOINT Assign_Customer_Accounts_PVT;
2626:
2627: -- Initialize message list if p_init_msg_list is set to TRUE.
2628: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2629: FND_MSG_PUB.initialize;
2630: END IF;
2631:
2632: -- Initialize API return status to success
2633: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2642: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 2646: FND_MSG_PUB.ADD;

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
2650: aso_debug_pub.add('Assign_Customer_Accounts - Invalid qte_hdr_id', 1, 'Y');

Line 2738: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 2741: FND_MSG_PUB.ADD;

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

Line 2787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 2790: FND_MSG_PUB.ADD;

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

Line 2836: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 2839: FND_MSG_PUB.ADD;

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

Line 2886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2882: aso_debug_pub.add('header ship to account = ' || l_account_id,1,'N');
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;

Line 2889: FND_MSG_PUB.ADD;

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

Line 3001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2997: l_account_id,1,'N');
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;

Line 3004: FND_MSG_PUB.ADD;

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

Line 3048: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3044: l_account_id,1,'N');
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;

Line 3051: FND_MSG_PUB.ADD;

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

Line 3095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3091: l_account_id,1,'N');
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;

Line 3098: FND_MSG_PUB.ADD;

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

Line 3149: FND_MSG_PUB.Count_And_Get

3145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3146: aso_debug_pub.add('Assign_Customer_Accounts: End ', 1, 'N');
3147: END IF;
3148:
3149: FND_MSG_PUB.Count_And_Get
3150: ( p_count => x_msg_count,
3151: p_data => x_msg_data
3152: );
3153:

Line 3159: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3155: WHEN FND_API.G_EXC_ERROR THEN
3156: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3157: P_API_NAME => L_API_NAME
3158: ,P_PKG_NAME => G_PKG_NAME
3159: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3160: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3161: ,P_SQLCODE => SQLCODE
3162: ,P_SQLERRM => SQLERRM
3163: ,X_MSG_COUNT => X_MSG_COUNT

Line 3171: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3169: P_API_NAME => L_API_NAME
3170: ,P_PKG_NAME => G_PKG_NAME
3171: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3172: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3173: ,P_SQLCODE => SQLCODE
3174: ,P_SQLERRM => SQLERRM
3175: ,X_MSG_COUNT => X_MSG_COUNT

Line 3240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3236: aso_debug_pub.add('Check_Hdr_Acct: l_inv_cust_id: '|| l_inv_cust_id, 1, 'N');
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;

Line 3244: FND_MSG_PUB.ADD;

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

Line 3356: FND_MSG_PUB.initialize;

3352: SAVEPOINT Check_Customer_Accounts_INT;
3353:
3354: -- Initialize message list if p_init_msg_list is set to TRUE.
3355: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3356: FND_MSG_PUB.initialize;
3357: END IF;
3358:
3359: -- Initialize API return status to success
3360: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3369: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 3373: FND_MSG_PUB.ADD;

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
3377: aso_debug_pub.add('Check_Customer_Accounts - Invalid qte_hdr_id', 1, 'Y');

Line 3415: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3411: aso_debug_pub.add('Check_Customer_Accounts:hdr_CustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
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;

Line 3417: FND_MSG_PUB.ADD;

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

Line 3447: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3443: aso_debug_pub.add('Check_Customer_Accounts:hdr_InvCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
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;

Line 3449: FND_MSG_PUB.ADD;

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

Line 3479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3475: aso_debug_pub.add('Check_Customer_Accounts:hdr_EndCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
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;

Line 3481: FND_MSG_PUB.ADD;

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

Line 3511: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3507: aso_debug_pub.add('Check_Customer_Accounts:lin_Acct - l_cust_acct: '||l_cust_acct, 1, 'N');
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;

Line 3513: FND_MSG_PUB.ADD;

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

Line 3545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3541: aso_debug_pub.add('Check_Customer_Accounts:lin_EndCustAcct - l_cust_acct: '||l_cust_acct, 1, 'N');
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;

Line 3547: FND_MSG_PUB.ADD;

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

Line 3579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3575: aso_debug_pub.add('Check_Customer_Accounts:shp_Acct - l_cust_acct: '||l_cust_acct, 1, 'N');
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;

Line 3581: FND_MSG_PUB.ADD;

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

Line 3597: FND_MSG_PUB.Count_And_Get

3593: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3594: aso_debug_pub.add('Check_Customer_Accounts: End ', 1, 'N');
3595: END IF;
3596:
3597: FND_MSG_PUB.Count_And_Get
3598: ( p_count => x_msg_count,
3599: p_data => x_msg_data
3600: );
3601:

Line 3607: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3603: WHEN FND_API.G_EXC_ERROR THEN
3604: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3605: P_API_NAME => L_API_NAME
3606: ,P_PKG_NAME => G_PKG_NAME
3607: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3608: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3609: ,P_SQLCODE => SQLCODE
3610: ,P_SQLERRM => SQLERRM
3611: ,X_MSG_COUNT => X_MSG_COUNT

Line 3619: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3616: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3617: P_API_NAME => L_API_NAME
3618: ,P_PKG_NAME => G_PKG_NAME
3619: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3620: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3621: ,P_SQLCODE => SQLCODE
3622: ,P_SQLERRM => SQLERRM
3623: ,X_MSG_COUNT => X_MSG_COUNT