54: IF (C_Party_Exists%NOTFOUND) THEN
55: x_return_status := FND_API.G_RET_STS_ERROR;
56: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
57: THEN
58: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
59: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
60: FND_MESSAGE.Set_Token('VALUE',p_party_id,FALSE);
61: FND_MSG_PUB.ADD;
62: END IF;
55: x_return_status := FND_API.G_RET_STS_ERROR;
56: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
57: THEN
58: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
59: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
60: FND_MESSAGE.Set_Token('VALUE',p_party_id,FALSE);
61: FND_MSG_PUB.ADD;
62: END IF;
63: END IF;
56: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
57: THEN
58: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
59: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
60: FND_MESSAGE.Set_Token('VALUE',p_party_id,FALSE);
61: FND_MSG_PUB.ADD;
62: END IF;
63: END IF;
64: close C_Party_Exists;
109: IF (C_Party_Site_Exists%NOTFOUND) THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
114: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_SITE_ID', FALSE);
115: FND_MSG_PUB.ADD;
116: END IF;
117: END IF;
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
114: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_SITE_ID', FALSE);
115: FND_MSG_PUB.ADD;
116: END IF;
117: END IF;
118: close C_Party_Site_Exists;
172: IF (C_Party_Cnt_Point_Exists%NOTFOUND) THEN
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
175: THEN
176: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
177: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
178: FND_MSG_PUB.ADD;
179: END IF;
180: END IF;
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
175: THEN
176: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
177: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
178: FND_MSG_PUB.ADD;
179: END IF;
180: END IF;
181: close C_Party_Cnt_Point_Exists;
185: IF (C_Org_Contact_Cnt_Point_Exists%NOTFOUND) THEN
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
188: THEN
189: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
190: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
191: FND_MSG_PUB.ADD;
192: END IF;
193: END IF;
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
188: THEN
189: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
190: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
191: FND_MSG_PUB.ADD;
192: END IF;
193: END IF;
194: close C_Org_Contact_Cnt_Point_Exists;
195: else
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
198: THEN
199: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
200: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
201: FND_MSG_PUB.ADD;
202: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
203: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
198: THEN
199: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
200: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
201: FND_MSG_PUB.ADD;
202: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
203: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
204: FND_MSG_PUB.ADD;
198: THEN
199: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
200: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
201: FND_MSG_PUB.ADD;
202: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
203: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
204: FND_MSG_PUB.ADD;
205: END IF;
206: end if;
199: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
200: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
201: FND_MSG_PUB.ADD;
202: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
203: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
204: FND_MSG_PUB.ADD;
205: END IF;
206: end if;
207:
251: IF (C_Contact_Exists%NOTFOUND) THEN
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
254: THEN
255: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
256: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
257: FND_MSG_PUB.ADD;
258: END IF;
259: END IF;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
254: THEN
255: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
256: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
257: FND_MSG_PUB.ADD;
258: END IF;
259: END IF;
260: close C_Contact_Exists;