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;
286:
287: If ( C_Get_entyattmap%NOTFOUND) Then
288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
289: THEN
290: FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');
291: FND_MESSAGE.Set_Token ('INFO', 'entyattmap', FALSE);
292: FND_MSG_PUB.Add;
293: END IF;
294: Close C_Get_entyattmap;
287: If ( C_Get_entyattmap%NOTFOUND) Then
288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
289: THEN
290: FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');
291: FND_MESSAGE.Set_Token ('INFO', 'entyattmap', FALSE);
292: FND_MSG_PUB.Add;
293: END IF;
294: Close C_Get_entyattmap;
295: raise FND_API.G_EXC_ERROR;
305: If (l_tar_ENTYATTMAP_rec.object_version_number is NULL or
306: l_tar_ENTYATTMAP_rec.object_version_number = FND_API.G_MISS_NUM ) Then
307: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
308: THEN
309: FND_MESSAGE.Set_Name('PV', 'API_MISSING_ID');
310: FND_MESSAGE.Set_Token('COLUMN', 'object_version_number', FALSE);
311: FND_MSG_PUB.ADD;
312: END IF;
313: raise FND_API.G_EXC_ERROR;
306: l_tar_ENTYATTMAP_rec.object_version_number = FND_API.G_MISS_NUM ) Then
307: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
308: THEN
309: FND_MESSAGE.Set_Name('PV', 'API_MISSING_ID');
310: FND_MESSAGE.Set_Token('COLUMN', 'object_version_number', FALSE);
311: FND_MSG_PUB.ADD;
312: END IF;
313: raise FND_API.G_EXC_ERROR;
314: End if;
315: -- Check Whether record has been changed by someone else
316: If (l_tar_ENTYATTMAP_rec.object_version_number <> l_ref_ENTYATTMAP_rec.object_version_number) Then
317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
318: THEN
319: FND_MESSAGE.Set_Name('PV', 'API_RECORD_CHANGED');
320: FND_MESSAGE.Set_Token('INFO', 'entyattmap', FALSE);
321: FND_MSG_PUB.ADD;
322: END IF;
323: raise FND_API.G_EXC_ERROR;
316: If (l_tar_ENTYATTMAP_rec.object_version_number <> l_ref_ENTYATTMAP_rec.object_version_number) Then
317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
318: THEN
319: FND_MESSAGE.Set_Name('PV', 'API_RECORD_CHANGED');
320: FND_MESSAGE.Set_Token('INFO', 'entyattmap', FALSE);
321: FND_MSG_PUB.ADD;
322: END IF;
323: raise FND_API.G_EXC_ERROR;
324: End if;
678: elsif p_operator not in ('EQUALS', 'NOT_EQUALS',
679: 'LESS_THAN', 'GREATER_THAN',
680: 'LESS_THAN_OR_EQUALS', 'GREATER_THAN_OR_EQUALS')
681: then
682: FND_MESSAGE.SET_NAME('PV', 'API_INVALID_MAPPING_OPERATOR');
683: FND_MESSAGE.SET_TOKEN('OPERATOR', p_operator);
684: FND_MSG_PUB.ADD;
685:
686: x_return_status := FND_API.G_RET_STS_ERROR;
679: 'LESS_THAN', 'GREATER_THAN',
680: 'LESS_THAN_OR_EQUALS', 'GREATER_THAN_OR_EQUALS')
681: then
682: FND_MESSAGE.SET_NAME('PV', 'API_INVALID_MAPPING_OPERATOR');
683: FND_MESSAGE.SET_TOKEN('OPERATOR', p_operator);
684: FND_MSG_PUB.ADD;
685:
686: x_return_status := FND_API.G_RET_STS_ERROR;
687:
852: P_ENTYATTMAP_Rec.OPERATOR = FND_API.G_MISS_CHAR or
853: P_ENTYATTMAP_Rec.TARGET_ATTR_ID IS NULL or
854: P_ENTYATTMAP_Rec.TARGET_ATTR_ID = FND_API.G_MISS_NUM) then
855:
856: FND_MESSAGE.Set_Name('PV', 'PV_INVALID_ENTITY_MAPPING');
857: FND_MSG_PUB.Add;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859:
860: END IF;