DBA Data[Home] [Help]

APPS.ASO_PARTY_INT dependencies on FND_MESSAGE

Line 652: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

648: NVL(l_termination_date, sysdate))OR
649: l_account_status <> 'A') THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
652: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
653: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT', FALSE);
654: FND_MSG_PUB.ADD;
655: END IF;
656: END IF;

Line 653: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT', FALSE);

649: l_account_status <> 'A') THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
652: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
653: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT', FALSE);
654: FND_MSG_PUB.ADD;
655: END IF;
656: END IF;
657: CLOSE C_Account;

Line 823: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

819: OPEN C_party_info(p_qte_rec.party_id);
820: FETCH C_party_info INTO l_party_type, l_party_name;
821: IF (C_party_info%NOTFOUND) THEN
822: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
823: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
824: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
825: FND_MSG_PUB.ADD;
826: END IF;
827: raise FND_API.G_EXC_ERROR;

Line 824: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);

820: FETCH C_party_info INTO l_party_type, l_party_name;
821: IF (C_party_info%NOTFOUND) THEN
822: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
823: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
824: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
825: FND_MSG_PUB.ADD;
826: END IF;
827: raise FND_API.G_EXC_ERROR;
828: END IF;

Line 860: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_INFO');

856: OPEN C_source_codes( p_qte_rec.marketing_source_code_id);
857: FETCH C_source_codes INTO account_rec.source_code;
858: IF (C_source_codes%NOTFOUND) THEN
859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
860: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_INFO');
861: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE CODES', FALSE);
862: FND_MSG_PUB.ADD;
863: END IF;
864: END IF;

Line 861: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE CODES', FALSE);

857: FETCH C_source_codes INTO account_rec.source_code;
858: IF (C_source_codes%NOTFOUND) THEN
859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
860: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_INFO');
861: FND_MESSAGE.Set_Token('COLUMN', 'SOURCE CODES', FALSE);
862: FND_MSG_PUB.ADD;
863: END IF;
864: END IF;
865: CLOSE C_source_codes;

Line 941: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

937:
938:
939: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
940: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
941: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
942: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
943: FND_MSG_PUB.ADD;
944: END IF;
945: raise FND_API.G_EXC_ERROR;

Line 942: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);

938:
939: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
940: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
941: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
942: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
943: FND_MSG_PUB.ADD;
944: END IF;
945: raise FND_API.G_EXC_ERROR;
946: ELSE

Line 1083: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

1079: aso_debug_pub.add('create acct_site:after create_site:x_return_status '||x_return_status, 1, 'N');
1080: END IF;
1081: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1083: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1084: FND_MESSAGE.Set_Token('COLUMN', 'ACCT SITE', FALSE);
1085: FND_MSG_PUB.ADD;
1086: END IF;
1087: raise FND_API.G_EXC_ERROR;

Line 1084: FND_MESSAGE.Set_Token('COLUMN', 'ACCT SITE', FALSE);

1080: END IF;
1081: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1083: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1084: FND_MESSAGE.Set_Token('COLUMN', 'ACCT SITE', FALSE);
1085: FND_MSG_PUB.ADD;
1086: END IF;
1087: raise FND_API.G_EXC_ERROR;
1088: ELSE

Line 1315: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

1311: END IF;
1312:
1313: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1315: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1316: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_SITE_USES', FALSE);
1317: FND_MSG_PUB.ADD;
1318: END IF;
1319: raise FND_API.G_EXC_ERROR;

Line 1316: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_SITE_USES', FALSE);

1312:
1313: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1315: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1316: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_SITE_USES', FALSE);
1317: FND_MSG_PUB.ADD;
1318: END IF;
1319: raise FND_API.G_EXC_ERROR;
1320: ELSE

Line 1477: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

1473: OPEN C_party(p_org_contact_id);
1474: FETCH C_party INTO l_party_id;
1475: IF (C_party%NOTFOUND) THEN
1476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1477: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1478: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID FOR GIVEN ORG CONTACT', FALSE);
1479: FND_MSG_PUB.ADD;
1480: END IF;
1481: raise FND_API.G_EXC_ERROR;

Line 1478: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID FOR GIVEN ORG CONTACT', FALSE);

1474: FETCH C_party INTO l_party_id;
1475: IF (C_party%NOTFOUND) THEN
1476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1477: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1478: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID FOR GIVEN ORG CONTACT', FALSE);
1479: FND_MSG_PUB.ADD;
1480: END IF;
1481: raise FND_API.G_EXC_ERROR;
1482: END IF;

Line 1544: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

1540: END IF;
1541: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1543: THEN
1544: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1545: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1546: FND_MSG_PUB.ADD;
1547: END IF;
1548: raise FND_API.G_EXC_ERROR;

Line 1545: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);

1541: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1543: THEN
1544: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1545: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1546: FND_MSG_PUB.ADD;
1547: END IF;
1548: raise FND_API.G_EXC_ERROR;
1549: ELSE

Line 1684: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

1680: WHERE acct.cust_account_id = p_acct_id
1681: AND acct.party_id = par.party_id;
1682: IF (SQL%NOTFOUND) THEN
1683: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1684: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1685: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
1686: FND_MSG_PUB.ADD;
1687: END IF;
1688: raise FND_API.G_EXC_ERROR;

Line 1685: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);

1681: AND acct.party_id = par.party_id;
1682: IF (SQL%NOTFOUND) THEN
1683: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1684: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1685: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
1686: FND_MSG_PUB.ADD;
1687: END IF;
1688: raise FND_API.G_EXC_ERROR;
1689: END IF;

Line 1716: fnd_message.set_name('ASO', 'ORG_CONTACT_ID');

1712: Open C_org_contact(p_party_id, l_header_party_id);
1713: Fetch C_org_contact into l_org_contact_id;
1714: IF (C_org_contact%NOTFOUND) THEN
1715: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1716: fnd_message.set_name('ASO', 'ORG_CONTACT_ID');
1717: FND_MSG_PUB.Add;
1718: END IF;
1719: -- RAISE FND_API.G_EXC_ERROR;
1720: l_org_contact_id := NULL;

Line 1762: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

1758: END IF;
1759: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1761: THEN
1762: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1763: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT', FALSE);
1764: FND_MSG_PUB.ADD;
1765: END IF;
1766: raise FND_API.G_EXC_ERROR;

Line 1763: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT', FALSE);

1759: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1761: THEN
1762: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1763: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT', FALSE);
1764: FND_MSG_PUB.ADD;
1765: END IF;
1766: raise FND_API.G_EXC_ERROR;
1767: END IF;

Line 1919: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

1915: END IF;
1916: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1917: x_cust_account_role_id := NULL;
1918: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1919: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1920: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1921: FND_MSG_PUB.ADD;
1922: END IF;
1923: raise FND_API.G_EXC_ERROR;

Line 1920: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);

1916: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1917: x_cust_account_role_id := NULL;
1918: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1919: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1920: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1921: FND_MSG_PUB.ADD;
1922: END IF;
1923: raise FND_API.G_EXC_ERROR;
1924: END IF;

Line 1962: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

1958: aso_debug_pub.add('create_contact_role:after create_role_resp: x_return_status: '||x_return_status,1,'N');
1959: END IF;
1960: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1961: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1962: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1963: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1964: FND_MSG_PUB.ADD;
1965: END IF;
1966: raise FND_API.G_EXC_ERROR;

Line 1963: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);

1959: END IF;
1960: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1961: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1962: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1963: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1964: FND_MSG_PUB.ADD;
1965: END IF;
1966: raise FND_API.G_EXC_ERROR;
1967: END IF;

Line 2185: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

2181: OPEN C_party_info(P_Party_id);
2182: FETCH C_party_info INTO l_party_type, l_party_name;
2183: IF (C_party_info%NOTFOUND) THEN
2184: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2185: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
2186: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
2187: FND_MSG_PUB.ADD;
2188: END IF;
2189: raise FND_API.G_EXC_ERROR;

Line 2186: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);

2182: FETCH C_party_info INTO l_party_type, l_party_name;
2183: IF (C_party_info%NOTFOUND) THEN
2184: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2185: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
2186: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
2187: FND_MSG_PUB.ADD;
2188: END IF;
2189: raise FND_API.G_EXC_ERROR;
2190: END IF;

Line 2205: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

2201: OPEN C_party_info(customer_party_id);
2202: FETCH C_party_info INTO l_party_type, l_party_name;
2203: IF (C_party_info%NOTFOUND) THEN
2204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2205: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
2206: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
2207: FND_MSG_PUB.ADD;
2208: END IF;
2209: raise FND_API.G_EXC_ERROR;

Line 2206: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);

2202: FETCH C_party_info INTO l_party_type, l_party_name;
2203: IF (C_party_info%NOTFOUND) THEN
2204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2205: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
2206: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
2207: FND_MSG_PUB.ADD;
2208: END IF;
2209: raise FND_API.G_EXC_ERROR;
2210: END IF;

Line 2287: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');

2283: aso_debug_pub.add('create_cust_acct:after create_acct:l_acct_id: '||l_acct_id,1,'N');
2284: END IF;
2285: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2287: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
2288: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
2289: FND_MSG_PUB.ADD;
2290: END IF;
2291: raise FND_API.G_EXC_ERROR;

Line 2288: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);

2284: END IF;
2285: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2287: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
2288: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
2289: FND_MSG_PUB.ADD;
2290: END IF;
2291: raise FND_API.G_EXC_ERROR;
2292: ELSE