826:
827: IF (c_Dm_Target_Value%NOTFOUND) THEN
828: CLOSE c_Dm_Target_Value;
829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
830: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
831: FND_MSG_PUB.add;
832: END IF;
833: RAISE FND_API.g_exc_error;
834: END IF;
1089: p_lookup_code => p_dm_target_value_rec.target_operator
1090: ) = FND_API.g_false
1091: THEN
1092: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1093: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1094: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_target_value_rec.target_operator);
1095: FND_MESSAGE.set_token ('COLUMN_NAME', 'TARGET_OPERATOR');
1096: FND_MSG_PUB.add;
1097: END IF;
1090: ) = FND_API.g_false
1091: THEN
1092: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1093: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1094: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_target_value_rec.target_operator);
1095: FND_MESSAGE.set_token ('COLUMN_NAME', 'TARGET_OPERATOR');
1096: FND_MSG_PUB.add;
1097: END IF;
1098: x_return_status := FND_API.g_ret_sts_error;
1091: THEN
1092: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1093: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1094: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_target_value_rec.target_operator);
1095: FND_MESSAGE.set_token ('COLUMN_NAME', 'TARGET_OPERATOR');
1096: FND_MSG_PUB.add;
1097: END IF;
1098: x_return_status := FND_API.g_ret_sts_error;
1099: END IF;