76: IF FND_GLOBAL.User_Id IS NULL
77: THEN
78: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
79: THEN
80: FND_MESSAGE.Set_Name('PV', 'UT_CANNOT_GET_PROFILE_VALUE');
81: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
82: FND_MSG_PUB.ADD;
83: END IF;
84: RAISE FND_API.G_EXC_ERROR;
77: THEN
78: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
79: THEN
80: FND_MESSAGE.Set_Name('PV', 'UT_CANNOT_GET_PROFILE_VALUE');
81: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
82: FND_MSG_PUB.ADD;
83: END IF;
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
285:
286: If ( C_Get_selattval%NOTFOUND) Then
287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
288: THEN
289: FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');
290: FND_MESSAGE.Set_Token ('INFO', 'selattval', FALSE);
291: FND_MSG_PUB.Add;
292: END IF;
293: Close C_Get_selattval;
286: If ( C_Get_selattval%NOTFOUND) Then
287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
288: THEN
289: FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');
290: FND_MESSAGE.Set_Token ('INFO', 'selattval', FALSE);
291: FND_MSG_PUB.Add;
292: END IF;
293: Close C_Get_selattval;
294: raise FND_API.G_EXC_ERROR;
304: If (l_tar_SELATTVAL_rec.object_version_number is NULL or
305: l_tar_SELATTVAL_rec.object_version_number = FND_API.G_MISS_NUM ) Then
306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
307: THEN
308: FND_MESSAGE.Set_Name('PV', 'API_MISSING_ID');
309: FND_MESSAGE.Set_Token('COLUMN', 'object_version_number', FALSE);
310: FND_MSG_PUB.ADD;
311: END IF;
312: raise FND_API.G_EXC_ERROR;
305: l_tar_SELATTVAL_rec.object_version_number = FND_API.G_MISS_NUM ) Then
306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
307: THEN
308: FND_MESSAGE.Set_Name('PV', 'API_MISSING_ID');
309: FND_MESSAGE.Set_Token('COLUMN', 'object_version_number', FALSE);
310: FND_MSG_PUB.ADD;
311: END IF;
312: raise FND_API.G_EXC_ERROR;
313: End if;
314: -- Check Whether record has been changed by someone else
315: If (l_tar_SELATTVAL_rec.object_version_number <> l_ref_SELATTVAL_rec.object_version_number) Then
316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
317: THEN
318: FND_MESSAGE.Set_Name('PV', 'API_RECORD_CHANGED');
319: FND_MESSAGE.Set_Token('INFO', 'selattval', FALSE);
320: FND_MSG_PUB.ADD;
321: END IF;
322: raise FND_API.G_EXC_ERROR;
315: If (l_tar_SELATTVAL_rec.object_version_number <> l_ref_SELATTVAL_rec.object_version_number) Then
316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
317: THEN
318: FND_MESSAGE.Set_Name('PV', 'API_RECORD_CHANGED');
319: FND_MESSAGE.Set_Token('INFO', 'selattval', FALSE);
320: FND_MSG_PUB.ADD;
321: END IF;
322: raise FND_API.G_EXC_ERROR;
323: End if;
803: fetch lc_criterion_dup_values_check into l_attribute_value;
804: close lc_criterion_dup_values_check;
805:
806: if l_attribute_value is not null then
807: FND_MESSAGE.Set_Name('PV', 'PV_DUPLICATE_CRITERIA');
808: FND_MSG_PUB.Add;
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: raise FND_API.G_EXC_ERROR;
811: end if;